DIF_SQL_SQL_ERROR during CTM job

[Former Member]

Hi,

When CTM job runs in our APO PRD system, it throws up an dump error.

Runtime Errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

How to correct the error

Database error text........: "ORA-01458: invalid length inside variable

character string"

Internal call code.........: "[RSQL/FTCH//SAPAPO/V_TRPROD ]"

Please check the entries in the system log (Transaction SM21).

If the error occures in a non-modified SAP program, you may be able to

find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with the following

keywords:

"DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"

"/SAPAPO/SAPLOO_TR_READ" or "/SAPAPO/LOO_TR_READF06"

"LANE_FULL_SELECTION"

Please help...

Regards,

P. Kumaravel

[keiji_mishima]

Hi Kumaravel Palani

Regading on your problem, I think SAP Note 972096 will help. So could you kindly check whether your system has above note.

If not please try Note 972096 and 1062113.

Best Regards

Keiji

Edited by: Keiji Mishima on Jan 11, 2008 6:32 AM

[Former Member]

Hi Keiji,

Thanks for your response. But the SCM version we are using is SCM 5.0, but the note is for SCM 4.10. Any more ideas????

Thanks,

P. K

[keiji_mishima]

Hi Kumaravel

In case of SCM5.0, could you kindly check your system has following notes ?

996565

934554

918312

1015144

1040179

Please implement missing notes.

Best Regards

Keiji