SAP Knowledge Base Article - Preview

2649382 - DB6: SQL error while accessing table TRDIRT

Symptom

There are huge amount of dump files in the system.

Symptom 1

SQL0104N error while accessing table TRDIRT.

A blank field name "" was generated in the SQL statement.

Category      Resource bottleneck
Runtime Errors DBIF_RTAB_SQL_ERROR
Short Text
SQL error "-104" occurred while accessing table "TRDIRT".
SQL0104N An unexpected token """" was found following "AND "SPRSL" = ? AND". 
Expected tokens may include: "<space>". SQLSTATE=42601
SELECT * FROM "TRDIRT" WHERE "NAME" = ? AND "SPRSL" = ? AND "" = ? WITH UR

Symptom 2

Category      Resource bottleneck
Runtime Errors DBIF_RTAB_SQL_ERROR
Short Text 
SQL error "-99999" occurred while accessing table "TRDIRT".


Read more...

Environment

SAP on IBM Db2 for Linux, UNIX, and Windows

Keywords

"TRDIRT","-104", SQL0104N, SQL error "-99999", nametab buffer , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DBI , DB Independent Database Interface , 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.