Highlighted
Valued Contributor.. Valued Contributor..
Valued Contributor..
305 views

Random ORA-01013 Errors in UCMDB Server Log

I am getting ORA-01013 errors randomly in the UCMDB 10.32 CP23 server log on the following statements:

select * from DB_CONTEXT

 SELECT VERSION FROM CONTENT_PACKS ORDER BY VERSION ASC

 select TruncateTableInAutonomousTrx('CDM_TMP_STR') from DUAL

I don't have a jdbc.properties file with ddoracle.QueryTimeout= so I believe the default value is 600 seconds/10 minutes.  DB_CONTEXT has 1 row and CONTENT_PACKS has 2 rows so those queries should return quickly.    I can run the first two selects in TOAD and they complete quickly.  I haven't tried running the function manually to see how long it takes.  Should I be concerned about these errors?

Thanks!

0 Likes
2 Replies
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: Random ORA-01013 Errors in UCMDB Server Log

Hello ,

It document will help you https://softwaresupport.softwaregrp.com/group/softwaresupport/search-result/-/facetsearch/document/KM1300631

 

Best Regards,

Melissa Carranza Mejias
Customer Support Engineer

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation. “
0 Likes
Highlighted
Valued Contributor.. Valued Contributor..
Valued Contributor..

Re: Random ORA-01013 Errors in UCMDB Server Log

Thanks Melissa for the link to increasing the timeout.  Before I went that route I wanted to try other things because Support recommended I not increase that permanently without good reason.  By increasing several fuses (per Support's direction), I was able to get past the ORA-01013 errors without increasing the timeout. 

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.