Error : SQL error in the database when accessing a table

vinodmathew_thomas — Mon, 09 Aug 2010 19:12:48 GMT

Hello All,

In SAP ECC 6.0, OS Linux, Database MAXDB, we have a job scheduled daily every 15 mins.

This job has been failing for a particular record daily.

I have gone to table IHPA, and i'm able to fetch the contents from the

databrowser(se16), but in the program code it fails,

only for this particular record.

Technical code:-

 clear: first_name, last_name, cust_telf1, cust_name.
         select b~namev b~name1 b~telf1 c~name1
         into (first_name, last_name, cust_telf1, cust_name)
         from ihpa as a
         join knvk as b on a~parnr = b~parnr
         join kna1 as c on b~kunnr = c~kunnr
         where a~objnr = qmel-objnr
         and   a~parvw = 'AP'
         and   b~kunnr ne qmel-kunum
         and   b~kunnr ne z_endcust
         and   b~loevm = space.
           if sy-subrc = 0.
             concatenate 'Other contact:' cust_name '-' first_name
                        last_name 'Tel:' cust_telf1
                   into text_lines separated by space.
             append text_lines.
           endif.
         endselect.

         clear text_lines.
         append text_lines.

Can you gurus, please provide some valuable suggestions

SAP DUMP - Info

short text

SQL error in the database when accessing a table.

ABAP/4 processor: DBIF_RSQL_SQL_ERROR

Runtime Errors DBIF_RSQL_SQL_ERROR

Except. CX_SY_OPEN_SQL_DB

Database error text........: "POS(1) System error: BD Illegal record"

Internal call code.........: "[RSQL/OPEN/IHPA ]"

Program : RSWUWFML" or "RSWUWFML"

Database type..... "ADABAS D"

Database............. "MaxDB 7.6, MaxDB 7.7"

SAP database version. 700

Operating system..... "Linux 2.6"

The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in procedure "SEND_MESSAGES" "(FORM)", but it was neither handled locally nor declared in the RAISING clause of its signature.

SM21, give the following information

Database error -602 requires database administrator to intervene

Database error -602 at SEL access to table IHPA

> POS(1) System error: BD Illegal record

Run-time error "DBIF_RSQL_SQL_ERROR" occurred

> Short dump "100809 101039 sdcerp01 C2100 " generated

Transaction Canceled 00 671 ( DBIF_RSQL_SQL_ERROR 20100809101039sdcerp01_C21_00 RMA_WORKFLOW011 )

Appreciate if you can help me out. Thanks in advance.

Regards,

Vinod

Edited by: Vinod Mathew Thomas on Aug 9, 2010 9:13 PM

Re: Error : SQL error in the database when accessing a table

lbreddemann — Tue, 10 Aug 2010 03:56:41 GMT

Hi there,

please open a support message for this issue.

regards,

Lars

topic Re: Error : SQL error in the database when accessing a table in Application Development and Automation Discussions

Error : SQL error in the database when accessing a table

Re: Error : SQL error in the database when accessing a table