sqlanywhere database not start DBSPAWN ERROR -80

[Former Member]

Dear Experts

I am installed BO 4.1 Sp3 under AIX 7 and default database sqlanywhere

after stop BOE

1. tomcat

2. BOE

3 database

from BOBJ home /usr/sap/BOD/sap_bobj

using scripts

but when in start database

./sqlanywhere_startup.sh  Flowing error occur

SQL Anywhere start In background ........

DBSPAWN ERROR -80

Unable to start database

Please guide me how to solved this issue

Regards

[jose_at_sap · Accepted solution]

Hello Shahid,

Error -80 means that the database server was not able to start.  There are many reasons why this happened, so what you must do is look at the database server log to see a more detailed message.

If you take a look at the file "sqlanywhere_startup.sh", you'll see the startup parameters used the launch the SQLA database server executable (dbsrv12).  The option to log messages to an external file is "-o <filename>" so look for that.  You can then open that file and see why the database server is failing.

Feel free to post the error and we'll let you know what it means and how to avoid it.

[Former Member · Accepted solution]

Thanks Jose for your help full reply.

kindly provide me how to generate logs for database startup issue as per you reply using parameter -o but how to us it out put of  script is

SQLANYWHERE_CONFIGSCRIPT=/usr/sap/BOD/sqlanywhere/bin64/sa_config.sh

SQLANYWHERE_CMS_DBFILE=/usr/sap/BOD/sqlanywhere/database/BI4_CMS.db

SQLANYWHERE_AUDIT_DBFILE=/usr/sap/BOD/sqlanywhere/database/BI4_Audit.db

SQLANYWHERE_SERVER=BI4_1399443743

SQLANYWHERE_PORT=2638

. "${SQLANYWHERE_CONFIGSCRIPT}"

dbspawn -f dbsrv12 -gk all -n "$SQLANYWHERE_SERVER" -x "tcpip(port=${SQLANYWHERE_PORT};DoBroadcast=NO;BroadcastListener=NO)" "${SQLANYWHERE_C

MS_DBFILE}" "${SQLANYWHERE_AUDIT_DBFILE}"

and startup script logs as

$ ./sqlanywhere_startup.sh

iAnywhere Solutions, Inc. One Sybase Drive, Dublin, CA 94568, USA

Copyright (c) 2001-2011, iAnywhere Solutions, Inc. Portions copyright (c)

1988-2011, Sybase, Inc. All rights reserved. All unpublished rights reserved.

SQL Anywhere Start Server In Background Utility Version 12.0.1.3152

DBSPAWN ERROR:  -80

Unable to start database server

Regards

[jose_at_sap · Accepted solution]

What you can do to troubleshoot is to add the logging parameter in the startup script.  Edit the script and change the dbspawn line as follows:

dbspawn -f dbsrv12 -gk all -n "$SQLANYWHERE_SERVER" -o <filename> -x "tcpip(port=${SQLANYWHERE_PORT};DoBroadcast=NO;BroadcastListener=NO)" "${SQLANYWHERE_C

MS_DBFILE}" "${SQLANYWHERE_AUDIT_DBFILE}"

Notice the placement of "-o <filename>" before the "-x" argument.  Replace <filename> with the full path of the log file you want to create.

Once you do this, you can re-run the script to attempt execution of the database server.  Have a look at the error log and please provide the contents here.

[Former Member · Accepted solution]

Thanks Jose for tour support.

I add parameter in db start up script -o file name , output of log as

I. 05/11 22:17:12. SQL Anywhere Network Server Version 12.0.1.3152

I. 05/11 22:17:12. OEM Edition, licensed only for use with OEM applications.

I. 05/11 22:17:12.

I. 05/11 22:17:12. Copyright (c) 2001-2011, iAnywhere Solutions, Inc.

I. 05/11 22:17:12. Portions copyright (c) 1988-2011, Sybase, Inc. All rights reserved.

I. 05/11 22:17:12. Use of this software is governed by the Sybase License Agreement.

I. 05/11 22:17:12. Refer to http://www.sybase.com/softwarelicenses.

I. 05/11 22:17:12.

I. 05/11 22:17:12. Processors detected: 4

I. 05/11 22:17:12. Processor limit (licensed processors): 100

I. 05/11 22:17:12. Maximum number of physical processors the server will use: 4

I. 05/11 22:17:12. This server is licensed to:

I. 05/11 22:17:12.     BOE

I. 05/11 22:17:12.     SAP

I. 05/11 22:17:12. Running AIX 7 1 on PPC

I. 05/11 22:17:12. Server built for PPC processor architecture

I. 05/11 22:17:12. 45520K of memory used for caching

I. 05/11 22:17:12. Minimum cache size: 11664K, maximum cache size: 13208376K

I. 05/11 22:17:12. Using a maximum page size of 8192 bytes

I. 05/11 22:17:13. Multiprogramming level: minimum:4, current:20, maximum:80

I. 05/11 22:17:13. Automatic tuning of multiprogramming level is enabled

I. 05/11 22:17:13. Starting database "BI4_CMS" (/usr/sap/BOD/sqlanywhere/database/BI4_CMS.db) at Sun May 11 2014 22:17

I. 05/11 22:17:13. Starting database "BI4_Audit" (/usr/sap/BOD/sqlanywhere/database/BI4_Audit.db) at Sun May 11 2014 22:17

I. 05/11 22:17:13. Database recovery in progress

I. 05/11 22:17:13.     Last checkpoint at Sun May 11 2014 12:31

I. 05/11 22:17:13.     Transaction log: BI4_Audit.log...

I. 05/11 22:17:13. Transaction log: BI4_CMS.log

E. 05/11 22:17:13. *** ERROR *** Assertion failed: 101413 (12.0.1.3152)

Unable to allocate a multi-page block of memory

Regards

[Former Member · Accepted solution]

Thanks Jose for Always you kind support.

Issue is solved

E. 05/11 22:17:13. *** ERROR *** Assertion failed: 101413 (12.0.1.3152)

Unable to allocate a multi-page block of memory

I add one more parameter in db startup script -ch 1g

and my database and BO is up.

please guide me one more thing

I download SQL Anywhere 12 client tool in my windows machine now I want to connection our administration my  sqlanywhere database through this tool but issue is that my database is running in AIX 7 platform ( not windows ) how can I connection my client tool with database because it require ODBC connection .

Kindly guide me how to connect my client tool with database

Regards

[jose_at_sap · Accepted solution]

Glad you got that resolved.  The -ch option limits automatic cache growth, so it looks like the system was running out of memory.

To connect to the database using the SQLA Windows Client, here's what you do:

1. Create a SQL Anywhere 12 ODBC DSN using the ODBC Adminstrator - you can call it any name you want.
2. In the Login tab:
   • Enter the correct User ID and Password.
   • In the "Action" drop down, select "Connect to a running database on another computer".
   • In the "Host" field, type in the host name or IP address of your AIX machine.
   • You can leave the "Port" field blank, or enter 2638.
   • In the "Server name" field, enter BI4_1399443743.  This is the name of the SQL Anywhere database server as specified in the config file.
   • In the "Database name" field, enter BI4_CMS.  If you want to connect to the Audit database instead, then enter BI4_Audit.

You can now test the connection using the Test button in the ODBC tab.

Now when you launch any of the administration tools, simply connect via ODBC and enter the DSN you just created.

Please let me know if this didn't work for you.

[jeff_albion · Accepted solution]

Hello,

E. 05/11 22:17:13. *** ERROR *** Assertion failed: 101413 (12.0.1.3152)
Unable to allocate a multi-page block of memory

Note that this issue is officially resolved by CR #700008, in 12.0.1.3589.

Regards,

Jeff Albion

SAP Active Global Support

[Former Member · Accepted solution]

Jose our BO server have 25 GB of memory and remember that I am newly created BO server no reports universe etc. exits in database if -ch option limit the cache growth then what is the best and proper solution .

@ jaff  in BO we have only 2 database 1. CMS and 2. Audit. I am unable to understand the solution kindly explain it .

Regards

[jeff_albion · Accepted solution]

Hello Shahid,

if -ch option limit the cache growth then what is the best and proper solution .

I am unable to understand the solution kindly explain it .

The link I referenced is a notice from our engineering group with a Change Request (CR) notification that a bug in SQL Anywhere has been addressed. At the link location, you can find the details of what the bug behaviour was (seeing "Assertion failed: 101413"), and the resolution is to apply patch 12.0.1.3589 or higher, which is available in SAP Service Marketplace - the latest for AIX is 12.0.1.4086 (SP71). Your current version is SQL Anywhere 12.0.1.3152 (GA).

---

As SQL Anywhere is installed as part of the BusinessObjects product, upgrading SQL Anywhere itself should be part of the BusinessObjects SPs. I'm not sure myself how this process currently works within BO (I only support SQL Anywhere directly), but you might want to inquire further within the community on SQL Anywhere version compatibility and how upgrades are handled within BusinessObjects.

Regards,

Jeff Albion

SAP Active Global Support

[jose_at_sap · Accepted solution]

Hi Shahid,

You cannot manually update the SQLA binaries in your BOBJ installation.  Instead, I suggest that you get in touch with your BOBJ support contact and explain that you'd like to have the SQLA files updated for the reason that Jeff stated above.  They will be able to tell you what the next steps are.  For now, you can use the -ch argument as a workaround.  Please let me know if you have any questions.

[Former Member · Accepted solution]

Thanks Jose and Jeff for guidance I will contact with SAP .

Regards

[Former Member · Accepted solution]

Hello Jose,

Glad to see your post here as below:

What you can do to troubleshoot is to add the logging parameter in the startup script.  Edit the script and change the dbspawn line as follows:

dbspawn -f dbsrv12 -gk all -n "$SQLANYWHERE_SERVER" -o <filename> -x "tcpip(port=${SQLANYWHERE_PORT};DoBroadcast=NO;BroadcastListener=NO)" "${SQLANYWHERE_C

MS_DBFILE}" "${SQLANYWHERE_AUDIT_DBFILE}"

Notice the placement of "-o <filename>" before the "-x" argument.  Replace <filename> with the full path of the log file you want to create.

Once you do this, you can re-run the script to attempt execution of the database server.  Have a look at the error log and please provide the contents here.

I did the same way as below:

firstly, create a file named file.

secondly, i changed the  sqlanywhere_startup.sh as below

SQLANYWHERE_CONFIGSCRIPT=/BOT/sqlanywhere/bin64/sa_config.sh
SQLANYWHERE_CMS_DBFILE=/BOT/sqlanywhere/database/BI4_CMS.db
SQLANYWHERE_AUDIT_DBFILE=/BOT/sqlanywhere/database/BI4_Audit.db
SQLANYWHERE_SERVER=BI4_1392876980
SQLANYWHERE_PORT=2638

. "${SQLANYWHERE_CONFIGSCRIPT}"
dbspawn -f dbsrv12 -gk all -n "$SQLANYWHERE_SERVER" -o /BOT/sap_bobj/file -x "tcpip(port=${SQLANYWHERE_PORT};DoBroadcast=NO;BroadcastListener=NO)" "${SQLANYWHERE_CMS_DBFILE}" "${SQLANYWHERE_AUDIT_DBFILE}"

thirdly, after re run the ./sqlanywhere_startup.sh.

Fourthly, check the file with command, more file, but nothing find there,

Could you please help me on this?

Best Regards!

Lee

[Former Member · Accepted solution]

Hi Jose

My returen code is 85,

Where can i know the return code meaning?

Best Regards!

Lee

[jose_at_sap · Accepted solution]

Hello Lee,

The log file should have been created, based on what you entered.  Can you try giving it an extension, such as "file.txt"?  The word "file" is reserved under Linux.

[Former Member]

Hi Jose,

I am facing the following issue while trying to bring up the SAP BI 4.1 SP2 , as per above instructions enabled logging and found the following errors anything that i am missing please advise,

I. 04/28 16:32:07. SQL Anywhere Network Server Version 12.0.1.3152

I. 04/28 16:32:07. OEM Edition, licensed only for use with OEM applications.

I. 04/28 16:32:07.

I. 04/28 16:32:07. Copyright (c) 2001-2011, iAnywhere Solutions, Inc.

I. 04/28 16:32:07. Portions copyright (c) 1988-2011, Sybase, Inc. All rights reserved.

I. 04/28 16:32:07. Use of this software is governed by the Sybase License Agreement.

I. 04/28 16:32:07. Refer to http://www.sybase.com/softwarelicenses.

I. 04/28 16:32:07.

I. 04/28 16:32:07. Processors detected: 8

I. 04/28 16:32:07. Processor limit (licensed processors): 100

I. 04/28 16:32:07. Maximum number of physical processors the server will use: 8

I. 04/28 16:32:07. This server is licensed to:

I. 04/28 16:32:07.     BOE

I. 04/28 16:32:07.     SAP

I. 04/28 16:32:07. Running AIX 7 1 on PPC

I. 04/28 16:32:07. Server built for PPC processor architecture

I. 04/28 16:32:07. 39400K of memory used for caching

I. 04/28 16:32:07. Minimum cache size: 14160K, maximum cache size: 22645560K

I. 04/28 16:32:07. Using a maximum page size of 8192 bytes

I. 04/28 16:32:07. Multiprogramming level: minimum:8, current:20, maximum:80

I. 04/28 16:32:07. Automatic tuning of multiprogramming level is enabled

I. 04/28 16:32:07. TCP/IP functions not found

I. 04/28 16:32:07. Database server shutdown due to startup error

I. 04/28 16:32:07. Database server stopped at Tue Apr 28 2015 16:32

Regards

Shiv

[jose_at_sap]

Hi Shiv,

It looks like the database server is unable to load the TCP/IP libraries due to lack of memory.  Can you try limiting the max cache size?  You use the "-ch" argument to do that, like this:

dbspawn -f dbsrv12 -ch 10m -gk all -n "$SQLANYWHERE_SERVER" -o <filename> -x "tcpip(port=${SQLANYWHERE_PORT};DoBroadcast=NO;BroadcastListener=NO)" "${SQLANYWHERE_C

MS_DBFILE}" "${SQLANYWHERE_AUDIT_DBFILE}"

In the above example, I'm telling the db server to set its max cache size to be 10 MB.  You can change that value as you like, such as 5k, 500M, 1g, etc.  Complete documentation on that argument is here: http://dcx.sap.com/index.html#1201en/dbadmin/ch-database-dbengine.html.

[Former Member]

Hello Jose

My output of log show ERROR like below:

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

Unable to find table definition for table referenced in transaction log.

How to solved this issue please

Regards

Read