on 02-11-2015 8:47 PM
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
Sorry I upgrade to 4.1 SP5 update 2 version
also got some error in log file
33007 | 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 found |
35101 | The 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. ). |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.