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.