Bobj4.1 Sp2: CMS DB Sybase SQL Anywhere

[Former Member]

Hi Experts,

Recently we have installed SAP Business Intelligence platform 4.1 SP2. Operating system is suse linux enterprise server 11 sp3 x86_64 and CMS DB is sybase sql anywhere. Installation was successful. After sometimes DB  went down. I am not able to log in to the CMC due to the CMS DB critical error.

when I am starting the DB using the dbeng12 option getting the following error.

dbeng12 -n BI4_CMS

/bobj/sqlanywhere/database/BI4_CMS.db

Resource temporarily unavailable

Database server shutdown due to startup error

Database server stopped at Sat Feb 22 2014 11:18

I already set the ulimit as per the installation guide. But it is still not working.

Thanks in advance.

Shemy

[JasonHinsperger · Accepted solution]

Are there any other messages in the server window, (or in the console if you started it that way)?

If you start the database server using the additional dbeng options -z and -o <filename> you may get more information on what is happening that is causing the error.  Start the server and post the content of the output file and we should be able to help you further.

[Former Member]

Hellow i had same problem.  If you have solved the problem please write as. Thenks

[Former Member]

Hi,

Please follow the below sequence to start and stop. It may resolve your issue.

1. Stop the BOE servers (stopservers)

2. Stop the Tomcat Server

3. Stop the CMS Database using only SL AnyWhere shutdown script.

Then:

1. Start CMS Database using only SQLAnywhere startup script.

2. Start the Tomcat Server

3. Start BO services (startservers) 

Thanks,

Shemy