Hi,
We did a custom enhancement on LIS standard datasource: 2LIS_11_VAITM. After doing such enhancement, data load to psa is getting failed with the following error message from BW
"
Message no. RSDS016
"
INCLUDE ZXRSAU01 Program written CMOD tcode of SAP PRD:
"
FIELD-SYMBOLS: <FS_LS_VAITM> TYPE MC11VA0ITM.
WHEN '2LIS_11_VAITM'.
DATA : LV_VAR1 TYPE EDATU_VBAK,
LV_VAR2 TYPE LFGSA.
LOOP AT C_T_DATA ASSIGNING <FS_LS_VAITM>.
SELECT SINGLE VDATU FROM VBAK into LV_VAR1
Where VBELN = <FS_LS_VAITM>-VBELN.
IF SY-SUBRC = 0.
<FS_LS_VAITM>-ZZVDATU = LV_VAR1.
SELECT SINGLE LFGSA FROM VBUP INTO LV_VAR2
WHERE VBELN = <FS_LS_VAITM>-VBELN AND
POSNR = <FS_LS_VAITM>-POSNR.
IF SY-SUBRC = 0.
<FS_LS_VAITM>-ZZLFGSA = LV_VAR2.
ENDIF.
ENDIF.
ENDLOOP.
"
Screen shot of error message from BW:
I have searched other threads of similar error message but couldn't find any solution there.
Could you please help us on how to resolve this problem?
Regards,
Antony Jerald.
Request clarification before answering.
Hi All,
As of now, we found the issue is happened because of the following situation:
We cleared lbwq, rsa7 in the early morning before transporting datasource to SAP PRD from quality system and pushed all data to BW. During transportation of datasource from quality to production, some one entered data and it appeared in lbwq. After transportation, we found that there's an entry in lbwq. We are then faced data being piled up in ERP. We cleared this issue from PRD by su01-> (enter user id)-> in parameters tab, we entered some hash code parameter setting it's application component to 11. Then we manually pushed data from lbwq to rsa7.
Even after this, we get the above mentioned error. In that error message, 36985125 is the sales order number entered into lbwq during transportation.
We taken job id of psa request, in PRD, sm37 -> entered job id, executed, it's status is showing finished. In that, we have given tcode jdbg, which helps to debug the program, to remove that erroneous record. We cleared that incorrect record from rsa7 through jdbg tcode.
After that, data push was successful. But a request got stuck in sm58 tcode, trfc. We couldn't execute this luw job manually. Kindly suggest for this.
Regards,
antony jerald.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have you tried to push the stucked LUW at SM58 by using F6. Take basis team help.
As you said it have only one record. if possible delete that luw and thru repair full request you can load that sales order 36985125 . for repair full request you need to delete and fill set up tables for lo data source.
Think twice before delete that LUW. consider this as last option.
Hi,
Yes we can push that one record by filling up set up tables and doing repair ful request. But this is not my problem
My problem is, repeat of last delta is still running and it has transferred all the data packages, more than 10 Lakh records gets transferred to psa. But it's still in yellow. Couldn't complete.
I tried executing LUW. But says, no display message.
Actually basis couldn't recognize why it gets stuck here in sm58. Please suggest.
Regards,
Antony Jerald.
SM58 - will be hanged due to ecc server will be busy with other jobs.
as you said its repeat delta - then don't touch any thing. let it be run to complete.
at ECC side if any jobs running, then basis team to stop them if possible. which are not needed on weekend, better to stop them.
at SM37, you try to check any spool request was generating for your request. if yes then we need to delete it manually.
Thanks
Hi,
Can you please tell me how to resolve this?
We deleted setup tables for 2lis_11_vaitm from SAP PRD by lbwg tcode giving app component 11. After doing this, we went to tcode oli7bw to fill setup table for this datasource. But it says " DataSource 2LIS_11_VAHDR contains data still to be transferred"
Last time I did this it was successful(even data was there in lbwq, rsa7). But now it is not happening.
How to resolve this?
Regards,
Antony Jerald.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.