SAP Knowledge Base Article - Preview

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

Symptom

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]

 Or

/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

(/bas/sapjvm/71_REL/src/6/hotspot/src/share/vm/runtime/thread.cpp:5423):

VMCOs::init failed

> 139869793175296 0.00 0x00000003 ERROR occured

(/bas/sapjvm/71_REL/src/6/hotspot/src/share/vm/sap/jvmEnv.cpp:133):

VMCOs::init: Initialization of the control area failed

> 139869793175296 0.00 0x00000002 ERROR occured

(/bas/sapjvm/71_REL/src/6/hotspot/src/share/vm/sap/controls.cpp:382):

Controls::init: Could not initialize instance control area

> 139869793175296 0.00 0x00000001 ERROR occured

(/bas/sapjvm/71_REL/src/6/hotspot/src/share/vm/sap/os_unix.inline.hpp:727

): 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.

 

 


Read more...

Product

SAP IQ 16.0

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

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