Highlighted
Absent Member.
Absent Member.
91 views

UCMDB Support Tip: DB errors that prevent uCMDB from starting

Hello all,

 

We had some issues with a customer that ran out of space on the DB transaction log. The error is like this:

ERROR - Error updating JDBC_PING table

java.sql.SQLException: [mercury][SQLServer JDBC Driver][SQLServer]The transaction log for database 'UCMDB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

 

If you have access to the DB or this is a test environment you can do the following:

First you need to check where the log file is and how much available space you have on that drive partition, and if your disk is full and you have no need for the data on the log file (important active transactions to end) you can shrink it. You will need to check with your DBA to achive these steps as this is not an uCMDB issue. He should be the one with access to do these steps as it could have implications. If you have access to SQL Server Management Studio you can go to the UCMDB_Schema db, right click on it -> Tasks -> shrink -> Files. You can check the Currently allocated space and Available free space. The shrinking can also be set here. Also, it would be better to stop the uCMDB process before doing this and start it after the space is free.

Best regards,
Andrei Matei
uCMDB Support Engineer

“HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
Labels (1)
Tags (1)
0 Likes
0 Replies
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.