DBIF_RSQL_SQL_ERROR

[Former Member]

Dear all,DBIF_RSQL_SQL_ERROR

System detail: Ecc 6, (sp10), kernel unicode 75, v5r3m5,

When we logon to the system, it throw:

Runtime Errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

Date and Time 24.02.2007 20:34:36

Short text

SQL error in the database when accessing a table.

Database error text........: "DOKCLUH2 in R3TQA42060 type * MSGID=

Job=069187/TQA00/WP04"

Internal call code.........: "[RSQL/FTCH/DOKTL ]"

When we restart the work process through sm50, then it work fine. Sometime it throw multiple short dump at different places with different wp, so when we restart the wp, then it works fine.

When i checked the job log for wrkjob 069187/TQA00/WP04

Library QGY added to library list.

Current library changed to R3TQADATA.

CONCURRENT WRITE IS ENABLED.

CONCURRENT WRITE WILL BE ENABLED NEXT IPL.

Library SAPTQAUCN removed from library list.

Library SAPTQAUCN added to library list.

Connect from workprocess w4 on MASAPTQA_TQA_00

Library R3SYS added to library list.

Prepared statement IzFZMABcAA not found.

Prepared statement IzFZMAMYCA not found.

DOKCLUH2 in R3TQA42060 type *SQLPKG not found.

DOKCLUH2 in R3TQA42060 type *SQLPKG not found.

DOKCLUH2 in R3TQA42060 type *SQLPKG not found.

DOKCLUH2 in R3TQA42060 type *SQLPKG not found.

What to do?

[Former Member · Accepted solution]

Dear volker,

I will see this parameter QDBENCWT.

I tried by deleting SQL packages but didnt work. The problem looks solved as what i did, i disabled the Delete SQL Package line by putting # in start profile. uptil now its working fine. I dont know is it correct or not.

Thanks

Imran Hasware

[Former Member · Accepted solution]

Hi Imran,

then you should open an OSS ticket, as this means, that DLTOLDPKS is the root cause ... this should not happen ...

Regards

Volker Gueldenpfennig, consolut.gmbh

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

[Former Member]

Dear volker,

I already had this problem in my DEV server and we opened an OSS. For that we were replied to update R3INLPGM patch 10 which is released shortly. But even after updating the patch, the problem is the same until we disable delete sql package.

I am in contact with sap and can update you when i get proper solution.

Thanks

Imran

[former_member204746]

problems with DOKTL as usually caused by bad network configuration such as no IP address. check your network config.

[Former Member]

Hi Imran,

first of all you should enable the following:

“CONCURRENT WRITE IS ENABLED”. In the Job-Log ?

=> You upgraded from lower than V5R3 to V5R3 or higher and didn’t do the following (the default as of V5R3)

CALL QDBENCWT '1' (becomes active after next IPL ok)

Check status as follows: CALL QDBENCWT

(note 992299 - iSeries: Databas Parameter QDBENCWT)

The I would suggest to delete the SQL packs with DLTR3PKG sid ...

On my site the problem disappeared then - otherwise I would apply the latest PTFs (not the latest kernel for this issue) and if you still run into issues, open an OSS ticket.

Regards

Volker Gueldenpfennig, consolut.gmbh

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de