SAP Knowledge Base Article - Preview

2628551 - DBSQL_SQL_ERROR SQL code: 0 Database view

Symptom

An SAP work process fails with a runtime error DBSQL_SQL_ERROR

SQL error "SQL code: 0" occurred while accessing table "<view name>"


In the SAP system log, SM21, the following errors can be seen


Database error 0 with UPD access to table <view name>
Runtime error "DBSQL_SQL_ERROR" occurred.


In the OS joblog of the failing work process, the following error codes can be seen

CPF9898 - IMINPUT: Looping error - Fail Query]]].
CPF4204 - Interner Fehler im Abfrageprozessor.
 
SQL0901 -SQL-SystemfehlerDatabase: Database error 0 with UPD access to table <view name>

Note: This document applies only to SAP database views. If the affected object is an SAP table ie: transparent table, this document should NOT be followed.


Read more...

Environment

SAP on IBM i

Product

SAP ERP 6.0

Keywords

AS400 OS400 SQL0901 , KBA , BC-DB-DB4 , DB2 for AS/400 , 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.