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
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.
SAP Knowledge Base Article - Preview