SAP Knowledge Base Article - Preview

2854539 - saphostctrl upgrade times out - SAP ASE for Business Suite

Symptom

SAP ASE database upgrade via saphostctrl fails while setting up CDS objects.

A timeout error is received while running a SELECT query. Per dev_sapdbctrl log file:

[PID 9830] serverMessageCallback: Server message: Number 5701, Severity 10, State 1, Line 1, Server ABC --- Message string: Changed database context to 'ABC'.
[PID 9830] executeQuery: --- Start of Query ---
[PID 9830] executeQuery: select
[PID 9830] executeQuery: distinct obj.name,
[PID 9830] executeQuery: obj.type,
[PID 9830] executeQuery: com.text
[PID 9830] executeQuery: from
[PID 9830] executeQuery: ABC..syscomments com,
[PID 9830] executeQuery: ABC..sysobjects obj
[PID 9830] executeQuery: where
[PID 9830] executeQuery: obj.id = com.id and
[PID 9830] executeQuery: com.number = 0 and
[PID 9830] executeQuery: com.texttype = 0 and
[PID 9830] executeQuery: com.id in (select
[PID 9830] executeQuery: distinct id
[PID 9830] executeQuery: from
[PID 9830] executeQuery: ABC..syscomments
[PID 9830] executeQuery: where
[PID 9830] executeQuery: text like '%CUDF_VERSION%' or
[PID 9830] executeQuery: text like '%DATS_IS_VALID%' or
[PID 9830] executeQuery: text like '%D_TO_I%' or
[PID 9830] executeQuery: text like '%DATS_ADD_MONTHS%' or
[PID 9830] executeQuery: text like '%SAP_REPLACE%' or
[PID 9830] executeQuery: text like '%SAP_CONCAT%' or
[PID 9830] executeQuery: text like '%SAP_UPPER%' or
[PID 9830] executeQuery: text like '%SAP_LOWER%' or
[PID 9830] executeQuery: text like '%UNIT_CONVERSION%' or
[PID 9830] executeQuery: text like '%FLOAT_TO_DECIMAL_07%' or
[PID 9830] executeQuery: text like '%FLOAT_TO_DECIMAL_15%' or
[PID 9830] executeQuery: text like '%FLOAT_TO_DECIMAL_23%' or
[PID 9830] executeQuery: text like '%FLOAT_TO_DECIMAL_31%' or
[PID 9830] executeQuery: text like '%DATS_ADD_DAYS%' or
[PID 9830] executeQuery: text like '%DATS_DAYS_BETWEEN%' or
[PID 9830] executeQuery: text like '%DATE_FROM_DAYOFWEEK%' or
[PID 9830] executeQuery: text like '%I_TO_D%' or
[PID 9830] executeQuery: text like '%INT_TO_TIMS%' or
[PID 9830] executeQuery: text like '%TIMS_TO_INT%' or
[PID 9830] executeQuery: text like '%TIMS_IS_VALID%' or
[PID 9830] executeQuery: text like '%ABAP_SYSTEM_TIMEZONE%' or
[PID 9830] executeQuery: text like '%ABAP_USER_TIMEZONE%' or
[PID 9830] executeQuery: text like '%IS_VALID_TZ%' or
[PID 9830] executeQuery: text like '%DATS_TIMS_TO_TSTMP%' or
[PID 9830] executeQuery: text like '%TSTMP_ADD_SECONDS%' or
[PID 9830] executeQuery: text like '%TSTMP_CURRENT_UTCTIMESTAMP%' or
[PID 9830] executeQuery: text like '%TSTMP_IS_VALID%' or
[PID 9830] executeQuery: text like '%TSTMP_TO_DATS%' or
[PID 9830] executeQuery: text like '%TSTMP_TO_DST%' or
[PID 9830] executeQuery: text like '%TSTMP_TO_TIMS%' or
[PID 9830] executeQuery: text like '%TSTMP_SECONDS_BETWEEN%')
[PID 9830] executeQuery: order by
[PID 9830] executeQuery: com.id,
[PID 9830] executeQuery: com.colid2,
[PID 9830] executeQuery: com.colid
[PID 9830] executeQuery: --- End of Query ---
[PID 10131]
Thu Oct 3 19:11:25 2019
[PID 10131] SigISetDefaultAction : default handling for signal SIGCHLD
[PID 9830] Thu Oct 3 19:11:25 2019
[PID 9830] ERROR AT sybOpenClient.cpp:clientMessageCallback:117 TIME: 2019 Oct 03 19:11:25 DESCRIPTION: Read from server has timed out LAST OS-ERROR: (11) : Resource temporarily unavailable
[PID 9830] clientMessageCallback: Canceling executions on connection
[PID 9830] ERROR AT sybOpenClient.cpp:executeQuery:2326 TIME: 2019 Oct 03 19:11:25 DESCRIPTION: ct_results finished with error -202=CS_CANCELED LAST OS-ERROR: (0) : Success
[PID 9830] resetConnection: Resetting connection: ABC
[PID 10131] ERROR AT sybServer.cpp:checkServerProcesses:46363 TIME: 2019 Oct 03 19:11:25 DESCRIPTION: realpath failed to resolve path for: LAST OS-ERROR: (2) : No such file or directory
[PID 9830] serverMessageCallback: Server message: Number 5701, Severity 10, State 2, Line 0, Server OEZ --- Message string: Changed database context to 'ABC'.
[PID 9830] resetConnection: Connection ABC was reset
[PID 9830] LiveUpdate from library 'libsapdbsybctrl.so' failed with error: 'Generic error', error message: 'ct_results finished with error -202=CS_CANCELED.'
[PID 9830] *** ERROR => 'Database live update' failed: ct_results finished with error -202=CS_CANCELED. [sapdbctrl.cp 4218]
sapparam: sapargv(argc, argv) has not been called!
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline


Read more...

Environment

  •  SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Product

SAP ERP 6.0

Keywords

saphostctrl, SETUP_CDS, "Read from server has timed out", "Resource temporarily unavailable", dev_sapdbctrl , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , 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.