SAP Knowledge Base Article - Preview

2649382 - DB6: SQL0104N error while accessing table TRDIRT

Symptom

There are huge amount of dump files in the system.

The dump reports 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

Read more...

Environment

SAP on IBM Db2 for Linux, UNIX, and Windows

Keywords

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

Search for additional results

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