SAP Knowledge Base Article - Preview

2912559 - DB6: about SQL message: SQLSTATE=HY000

Symptom

1, You may got short dump: DBSQL_SQL_ERROR as following:

Short Text
SQL error "SQL code: -99999" occurred while accessing table "xxx".

What happened?
Database error text: "SQL message: SQLSTATE=HY000"

2, And you may find the fillowing error in the dev trace file:

C *** ERROR in DB6Execute[/bas/753_REL/src/dbs/db6/dbdb6.c, 5844] (END)
B ***LOG BY4=> sql error -99999 performing MOD on table xxx [dbdbslst 5137]
B ***LOG BY0=> SQLSTATE=HY000 [dbdbslst 5137]

or

C *** ERROR in DB6Execute[/bas/745_REL/src/dbs/db6/dbdb6.c, 5671] (END)
B ***LOG BY4=> sql error 0 performing MOD on table xxx [dbdbslst 4806]
B ***LOG BY0=> SQLSTATE=HY000 [dbdbslst 4806]


Read more...

Environment

SAP on IBM Db2 for Linux, UNIX, and Windows

Keywords

SQLSTATE=HY000, sql error -99999, sql error 0, DBSQL_SQL_ERROR, sapcpe, permission , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.