cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

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

"

Error 'The argument 2000001<0000.000 cannot be interpreted as a number'
when assigning application structure, line 1, contents "36985125 A
A000010CCCC00000000ZODN 00000..."

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.

0 Likes
View Entire Topic
Former Member
0 Likes

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.

RamanKorrapati
Active Contributor
0 Likes

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.

Former Member
0 Likes

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.

RamanKorrapati
Active Contributor
0 Likes

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

Former Member
0 Likes

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.