cancel
Showing results for 
Search instead for 
Did you mean: 

CMS System database not available FWM 02088

Former Member
0 Kudos

Dear Experts,

I am installed BI 4.1 SP3 under operating system AIX 7.1 and SQL Anywhere 12 database.

we are facing this issue from starting ( when BI server install ) my SQL Anywhere database down automatically after 2 or 3 days

and we find the error in db.log file

*** ERROR *** Assertion failed: 101413 (12.0.1.3152)

Unable to allocate a multi-page block of memory

I find sap note 2077142 BI 4.1 SQL Anywhere does not start on AIX 7.1 and apply

change in sqlanywhere_startup.sh script

replace/insert "-on 512k -ch 1G" right after "dbsrv12". e.g.: dbsrv12 -on 512k -ch 1G

but issue same

Pleas guide me how to resolved this issue permanently

Regards

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Sorry I upgrade to 4.1 SP5 update 2 version 

also got some error in log file

33007SAP BusinessObjects BI platform CMS: Unable to connect to the CMS system database ""BI4_CMS_DSN_1399443743"". Reason: [Sybase][ODBC Driver][SQL Anywhere]Database server not found
35101The root server reported an error Initialization Failure. (Reason: SAP BusinessObjects BI platform CMS: Unable to connect to the CMS system database ""BI4_CMS_DSN_1399443743"". Reason: [Sybase][ODBC Driver][SQL Anywhere]Database server not foundSAP BusinessObjects BI platform CMS: Unable to connect to the CMS system database ""BI4_CMS_DSN_1399443743"". Reason: [Sybase][ODBC Driver][SQL Anywhere]Database server not found CDatabase::Open failure. ).
lucjan_chmura
Explorer
0 Kudos

Hi Shahid,

the original problem was :database crashing after 2,3 days with : "Assertion failed: 101413"

and, now database can't even be started. Correct?

What is your current startup command in sqlanywhere_startup.sh.

If you have "-o <db_log>" , can you post <db_log> messages when you try to start it?

Also, have a look at system log (/var/adm/messages or /var/log/syslog ) for any messages related to SQL Anywhere when you try to start the database.

FYI. you can also try and start your database from command line e.g. :

- locate your *.db (in 'databases' folder)

- make sure you have your environment set (source sa_config.sh , so dbsrv12 is in your path )

- run : dbsrv12 -z -o .\console.log <your_db_file>

- have a look at console.log file for any errors.

Lucjan

Former Member
0 Kudos

Thanks all for your guidance

recently I upgrade my bI to 4.1 sp2 update 2, but new database not start and stop

session not come on prompt

after upgrading issue is still not resolved.

Regards

Former Member
0 Kudos

Hello Shahid,

the version of SQL Anywhere packaged with BI 4.1 is not compatible with AIX 7.1.

Please refer to this link: http://scn.sap.com/docs/DOC-35654#SA-Unix and you will see that you need EBF #3469 or higher.

Hope this helps.

Best regards,

Jinwoo Park

lucjan_chmura
Explorer
0 Kudos


Hi,

BI build which you have installed came with GA version of SQL Anywhere which has bugs related to this assertion. You need to upgrade your BI environment to BI 4.1 SP05 which will also upgrade SQL Anywhere version from GA to 12.0.1.4110.

regards,
Lucjan