Highlighted
Absent Member.. Absent Member..
Absent Member..
1593 views

UCMDB 10.10 - Issue with connecting to DB

Hi,

 

I am trying to do a fresh Installation of UCMDB 10.10 on Red hat 6.2 (Linux), we had asked the DBA team to create a Schema in advance for UCMDB. The schema user has all the permissions as mentioned in DB Guide. Also the user which I am using for UCMDB Installation has all permissions to access files, however I am getting below errors in the log files:

 

2013-12-27 11:07:53,730 [AWT-EventQueue-0] N/A Can't execute prepared statement [select * from DB_CONTEXT where SCHEMA_TYPE=? and IS_GLOBAL=?; Values: 'CMDB',1], due to exception: java.sql.SQLSyntaxErrorException: [mercury][Oracle JDBC Driver][Oracle]ORA-00942: Table ou vue inexistante

 

2013-12-27 11:07:58,188 [AWT-EventQueue-0] WARN  Can't read connection pool config file from ../conf/connection_pool.conf, will work with defaults

java.io.FileNotFoundException: ../conf/connection_pool.conf (No such file or directory)

 

I am attaching the logs for the reference. any help would be appreciated.

Regards
Puneet

If you find this reply helpful, Click the KUDOS button on the bottom to say 'Thanks'
0 Likes
2 Replies
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: UCMDB 10.10 - Issue with connecting to DB

Just to confirm, I can execute the same query from SQLPLUS using same schema user without any issues and I can see connection_pool.conf file in the UCMDB directory:

Regards
Puneet

If you find this reply helpful, Click the KUDOS button on the bottom to say 'Thanks'
0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: UCMDB 10.10 - Issue with connecting to DB

Puneet;

 

R&D found an issue similar to the one you describe.  Here is the error:

2013-12-27 11:07:53,732 [AWT-EventQueue-0] (CmdbDalException.java:88) ERROR - Sql exception occurred. Details:
Can't execute prepared statement [select * from DB_CONTEXT where SCHEMA_TYPE=? and IS_GLOBAL=?; Values: 'CMDB',1], due to exception: java.sql.SQLSyntaxErrorException: [mercury][Oracle JDBC Driver][Oracle]ORA-00942: Table ou vue inexistante
. The exceptions in the chain:
Cause (1): java.sql.SQLSyntaxErrorException: [mercury][Oracle JDBC Driver][Oracle]ORA-00942: Table ou vue inexistante

 

The problem was that the db schema wasn't completely created due to permissions problems... please have the DBAs recreate the schema and grant all appropriate permissions from the db guide.

 

The pool.conf problem I have seen, but it doesn't seem to be an issue... I'll let you know what I find out on this one.

 

Keith Paschal

UCMDB Support

Hope this helps,
Keith Paschal
UCMDB Worldwide Support Lead
Micro Focus Support
If you find this or any post resolves your issue, please be sure to mark it as an accepted solution."

Click the KUDOS star on the left to say 'Thanks'
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.