SAP Knowledge Base Article - Preview

2276484 - Dbisql -nogui batches do no terminate and causes resources overload - SAP IQ


Execute consecutive dbisql -nogui batches.

At some point, they reach resources limit and cannot be executed anymore!

Errors below may be displayed:

Supplemental message: [Sybase][ODBC Driver][SQL Anywhere]Connection error: Insufficient system resources - failed to allocate a SYSV semaphore [sdbsrc:290]

09/29/2015 22:21:50.165 (15004) [E] [PROCESS] [SMS Base] Select PROCESS_RUN_ABORT: CODE 11518: Database connection error [sprocrun:801]

09/29/2015 22:21:50.166 (15004) [N] [MACRO FUNC] [SMS Base] ParseTree::ComputeInternal(): CODE 790: * Error. [parstree:2362]


/opt/sybase_client/IQ-16_0/bin64/dbisql -c "uid=$1;pwd=$2;eng=xxxx;links=tcpip(host=xxxxxx)" -nogui

> <(><<)>thread> <(><<)>time> <(><<)>id> <(><<)>description>

> 139869793175296 0.00 0x00000004 ERROR occured


VMCOs::init failed

> 139869793175296 0.00 0x00000003 ERROR occured


VMCOs::init: Initialization of the control area failed

> 139869793175296 0.00 0x00000002 ERROR occured


Controls::init: Could not initialize instance control area

> 139869793175296 0.00 0x00000001 ERROR occured


): os::create_event: semget failed (key=5593300) (28: No space left on device)

> Error: Could not create the Java Virtual Machine.

> Error: A fatal exception has occurred. Program will exit.





SAP IQ 16.0


sybase, dbisql ; On_Error ; Onerror ; -Onerror ; Prompt ; Exit; Exception ; catch ; failed to allocate a SYSV semaphore ; Could not create the Java Virtual Machine ; VM ; , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.