Symptom
While executing a local client copy, background job 'CLIENTCOPY XXX -> YYY' fails with the following dump produced:
Category Installation Errors
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time 25.07.2019 17:40:47
---------------------------------------------------------------------------------------
|Short Text
| SQL error "SQL code: -802" occurred while accessing table "CCSELTAB".
---------------------------------------------------------------------------------------
|What happened?
| Database error text: "SQL message: [IBM][CLI Driver] CLI0115E Invalid cursor
| state. SQLSTATE=24000"
---------------------------------------------------------------------------------------
The following is reported in the work process log:
C Thu Jul 25 17:40:46:898 2019
C *** ERROR => DB2 Call 'SQLFetch' Error: conHdl = 00 SQLCODE = -802 : [IBM][CLI Driver][DB2] EXCEPTION ERROR FIXED POINT OVERFLOW HAS OCCURRED DURING COLUMN FUNCTION OPERATION ON INTEGER DATA, POSITION
[dbdb2cli.c 6579]
C {root-id=0050568F90641ED9ABE49A858B8CFD60}_{conn-id=00000000000000000000000000000000}_0
C DB2Trc: SELECT SUM( "NBRINS" ) , SUM( "NBRUPD" ) , SUM( "NBRDEL" ) , COUNT_BIG(*) FROM "CCSELTAB" WHERE "MAN\
C DB2Trc: DT" = ? AND "STATUS" <> 'N' FOR READ ONLY WITH UR ;
C *** ERROR => DB2 Call 'SQLCloseCursor' Error: conHdl = 00 SQLCODE = -99999 : [IBM][CLI Driver] CLI0115E Invalid cursor state. SQLSTATE=24000
[dbdb2cli.c 6579]
B ***LOG BY4=> sql error -802 performing FET on table CCSELTAB [dbdbslst 5137]
B ***LOG BY0=> [IBM][CLI Driver] CLI0115E Invalid cursor state. SQLSTATE=24000 [dbdbslst 5137]
B dumping DbDbslStatement ...
Read more...
Environment
- SAP Netweaver 7.40 and higher
- Db2 z/OS any version
Product
Keywords
SQL0802N,DBSQL_SQL_ERROR,CX_SY_OPEN_SQL_DB,CCSELTAB , KBA , BC-CTS-CCO , Client Copy (For ByD issues select BC-TLM-CP) , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB2 , DB2 for z/OS , 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