05-04-2014 11:44 PM
We have HPBSM 9.23 on windows and it is connected to Oracle 11.2 Enterprise edition 64 bit.
We have created and connected to all the schema's successfully and while connecting to the profileschema, we are getting an error. When we checked in the back end, the schema is created and we also have all the tables created under that schema but on the console it gives and error.
On the Manage Profile DB page, i entered all the details that are required and when i click on apply, i get the attached error(error1.png). The credentials are all ok. The permissions are all ok and the port is also able to telnet.
The default tablespace we are using is PROFILESCHEMA and the temp tablespace is PROFTEMP.
I tried 2 options:
Option1: PROFILESCHEMA and PROFTEMP were already created in the Oracle DB and we tried to connect to that. During this time the schema was created new(by the console, when we click apply from the console)
Option2: PROFILESCHEMA and PROFTEMP were not created, but then when we click on apply from the console, it is created on the db automatically.
Once when the error comes, if i try to again connect using the same schema name, it gives an error(error2.png) this error means that the user has got permission nad it is able to create schemas.
Please advice what do i need to do...
Need to know what log files do i refer to for knowing the problem.
Solved! Go to Solution.
05-05-2014 12:32 AM
1. Are you using RAC in oracle db?
2. This profile schema was created from BSM console?
3. Currently this profile is used by any collector ?
4. DB has enough temp space ?
05-05-2014 12:38 AM
1.We are not using RAC in Oracle
2.This ProfileSchema was alreasy created by the Oracle Admin before we ran the Manage DB from Console.
3. PROFILESCHEMA has initial size 1GB and it can expand to unlimited. PROFTEMP has a size of 2GB.
"Currently this profile is used by any collector ?"
--Actually i am new to BSM so do not exactly know how do i check this...
Also, what log files can i check to look into this error??
Hope the above info helps...let me know if you need anything else.
05-05-2014 04:35 AM - edited 05-05-2014 05:23 AM
If you have set integration from data collectors to use this database you can see the profile database assigned in admin page from that specific integration. For example for SiteScope you should look at System Availability Management.
Regarding log files, you can take a look at HPBSM\log\configserver\ folder.
05-05-2014 05:00 AM
just check the box- create database/tables and try.
is there any specific reason to use existing profile db?try create from bsm console.
05-05-2014 05:06 AM
I tried unchecking but that too did not work... i was under the impression that we had to create an empty tablespace and temp tablespace and then when you run it from the console, that time that new schema will be created and the bsm related tables will be created inside the default tablespace..... is that right??? i read somewhere that the script that can be run to create manually is the one being referenced by the console in the backend...
i do not have any inyegration as yet... i am a bit confused by you question though...can you please explain...??
05-05-2014 05:12 AM
In this case-just delete that db and try to create fresh profile db from bsm console. Plz give the snapshot of enter information when u create new.
05-05-2014 05:28 AM - edited 05-05-2014 05:34 AM
Can you try connecting oracle and against the Profile schema run a new query which is under the
please share the logs from topaz.
05-05-2014 05:32 AM
You can check database integrity and permissions by running HPBSM\dbverify\bin\run_db_verify.bat
If the database does not have permissions or had problems while creating it, you may be able to check for possible problems.
05-05-2014 05:34 AM
can you tell me exactly which log file you require??
run_dbverify was the first thing i did...it was successful without errors....
05-06-2014 04:20 AM
Can you provide HPBSM\log\configserver folder?
This will contain some details about the validations and the errors you are seeing.
05-06-2014 10:19 AM - edited 05-06-2014 10:21 AM
Hi all, I was able to solve this problem. I found an error in the topaz_all.ejb. The error was as below:
2014-05-06 11:42:37,209 [GEO locations loader] (GeoLocationLoaderImpl.java:864) ERROR - failed loading IP ranges to database com.mercury.infra.util.db.DataAccessException: failed to update the database: INSERT /*+append */ INTO GEO_LOCATIONS_IPS_V4 (GLO_ID, PART_ID, START_IP, END_IP, GLO_COUNTRY, GLO_STATE, GLO_CITY, GLO_LATITUDE, GLO_LONGITUDE, ISP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) at com.mercury.infra.util.db.DatabasePreparedBatchUpd
The error for ORA, ORA-01683 lead me to this link: http://ora-01683.ora-code.com/ and as per the ORACLE code mentioned we needed to add a DATA file to the tablespace.
I asked the DB admin to do that and after that it worked like a charm..!!!
Thankyou all for your help..!!
Thank you specially Sumit and Javier really appreciate that..