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 ...



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 , 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 ONE Support launchpad (Login required).

Search for additional results

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