SAP Knowledge Base Article - Preview

2825559 - Local Client Copy fails with dump reporting SQLCODE = -802 FIXED POINT OVERFLOW

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

SAP ERP 6.0 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

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.