The CMS system database is not available (FWM 02088) until restart

[former_member946991]

works for a while

restart Server Intelligence agent and it works for a while more.

the event log states this:

Server registration denied for com.seagatesoftware.img.osca.pjs."[Server]"-[Server].WebApplicationContainerServer; server not found in cluster.

[former_member946991 · Accepted solution]

the best way to solve it was running this script as a batch file on the server with the 70+GB log file.

"C:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\BIN64\dbbackup.exe"^

-c "Server=[Server];DBN=[UserName];UID=dba;PWD=[password]"^

-o c:\temp\dbbackup_log.txt^

-xo

PAUSE

[denis_konovalov]

Your version of the product is very old and no longer supported, so the best way to resolve this issues is to upgrade to a current version.

Meanwhile look at following KBA's
https://launchpad.support.sap.com/#/notes/2063467
https://launchpad.support.sap.com/#/notes/2559718

[former_member946991]

I found the issue, but I still need some help.

the hdd space was completely used up, I cleared some space and it was almost completely sued up again.

it appears as though the SQLAnywhere Database Log file is 70+GB

should there be a mechanism to clear that?

Thanks

[former_member946991]

I've kind of inherited this so am not super confident in finding that info but here it goes

1) Product: 14.0.7 © Copyright 2013 SAP AG. All rights reserved.

2) Checking ODBC SQLAnywhere and local host appears to be what's running.

3) uhhh do you want a snippit of the logs here? there are thousands of lines from that time period all looking like this:

.\apsfactory.cpp:1025:-: TraceLog message 71310 |0d443a87-6a76-3794-380b-0c75496350e3|2020 06 22 07:18:47:687|-0700|Error| |>>| | |cms_[][Server].CentralManagementServer| 5108|5488|| |15|0|1|0|BIPSDK.InfoStore:query|[Server]:5876:127.1111029:1|BIPSDK.InfoStore:query|[Server]:5876:127.1111029:1|cms_[Server].CentralManagementServer.newService|localhost:5108:5488.1145118:1|CsbcQEmBXUh0ji2f6oggQUE1019bf|||||||||||assert failure: (.\apsfactory.cpp:1025). (0 : Corba user exception). .\apsfactory.cpp:1025:-: TraceLog message 71311 |87142656-4a14-0214-6ac3-53cfa65da14d|2020 06 22 07:18:47:936|-0700|Error| |>>| | |cms_[Server].CentralManagementServer| 5108|5400|| ||||||||||||||||||||||assert failure: (.\apsfactory.cpp:1025). (0 : Corba user exception).

[denis_konovalov]

you are not providing enough information to guess what's wrong.

The title error means that CMS DB is not available, but you have not listed what DB are you using and if it is on the same host or not.
Restart of SIA doesn't affect CMS DB, so if that fixes it - could mean 2 things :
1. CMS DB was not available, then was, but CMS server lost connection and couldn't re-connect and restart allowed it to happen.
2. CMS process was hanged and restart fixed it.
Event log entry you posted is not relevant to the title error and is for WACS, which can't register with CMS as CMS DB is not available.

So, if you want community to help you find root cause, you should provide :
1. version of the product you're using
2. What CMS DB you have and if its on the same host as bobj server
3. CMS server trace logs exempts, from the time of the error -- they will be in /logging directory.