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 for Me (Login required).

Search for additional results

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