08-09-2010 8:12 PM
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
08-10-2010 4:56 AM
Hi there,
please open a support message for this issue.
regards,
Lars