Error when assigning application structure Message no. RSDS016

[Former Member]

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.

[Former Member · Accepted solution]

Finally we did by bringing data from setup tables.

[Former Member · Accepted solution]

Hi Jerald, Can you tell the steps you followed to resolve this. We are having the same problem.

[Former Member · Accepted solution]

Hi,

We tried with Hash solution but that doesn't require here as data loading from Delta queue to BW is failing.  Then We've loaded setup tables for all those Sales orders, collecting it from PSA Table, and from there(setup tables) we brought data to BW System.

Regards,

Antony Jerald.

[Former Member]

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]

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]

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]

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]

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.

[Former Member]

Hi Jerald,

Its the problem with your exit code... Move the line FIELD_SYMBOLS into the When '2LIS_11_VAITM'..

Change your code with the below and try to execute ...

WHEN '2LIS_11_VAITM'.

 DATA : LV_VAR1 TYPE EDATU_VBAK,

            LV_VAR2  TYPE LFGSA.

FIELD-SYMBOLS: <FS_LS_VAITM>   TYPE   MC11VA0ITM.

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.

If needed try to take help of ABAP person and debug the code...

Regards

KP

[Former Member]

Hi,

Here, I couldn't understand the error message:

Error 'The argument 2000001<0000.000 cannot be interpreted as a number'

when assigning application structure, line 1, contents "36985125 A

A000010CCCC00000000ZODN 00000..."

There's no field name mentioned.  Could you tell me How could I find such?

Regards,

Antony Jerald.

[RamanKorrapati]

Can you reactivate your extrcat structure and data source.

please check oss note 1370672.

[Former Member]

Hi,

Actually background job in SAP PRD getting successfully completed.  While checking the data package, we found data packages from 2-10 but we have problem in data package 1, which doesn't appears in PSA.

This had happened because, after clearing lbwq, rsa7, we transported datasource but unfortunately, some one posted data.  We forgot to lock users.

Then data gets piled up in lbwq;  We resolved this issue.  But now, data load to BW system is failing.

Kindly suggest on how to address this issue and close this as early as possible.

Regards,

Antony Jerald.

[RamanKorrapati]

Hi,

When we are planned to move new changes for existing delta flow, first we need to clear all delta records by running delta info twice and v3 jobs(incase of lo).

Can you try to RSRV test on your PSA tables.

if your enhancement was working fine then better to raise to sap and check them.

if possible can you try to reload your delta request by making present req as red and trigger by manually. it will ask repeat delta. but think twice and do this step.

Thanks

[Former Member]

Hi,

We've deleted PSA data, activated datasource through program, then we've repulled data.  Even then after the dataload is failing.

While doing RSRV test for psa table, we didn't get any errors.

Yeah, we've raised a ticket with SAP.  But if any of you experts get any idea, please suggest.

Regards,

Antony Jerald.

[RamanKorrapati]

One more thing,

the field which you enhanced have units or currencies. if yes then those are mapped properly? can you check in that way.

[KodandaPani_KV]

Hi antony,

Please check the RSA3 level and select the Debug mode then check.

missing data type of object.

And  whether data is coming from data source  like that you can check in RSA3 in R3 system and if yes you may remove such records at CMOD code level .

Thanks,

Phani.

[anshu_lilhori]

Did you check in RSA3 whether your code is running properly or not.

It might be the issue with the datatype of the enhanced field or might be because of junk data.

Please check the same and also try to load data for one sales order or so.

Regards,

AL

[RamanKorrapati]

Have tested at RSA3. can your enhancement code with help of abap expert.

try to do test run at RSA3. if it gives same error, try to debug your data source.

[Former Member]

Hi Antony,

can you execute this in RSA3 with DEBUG mode and check as to where exactly its getting this error (which line of code)..seems to be some variable issue.

rgds

SVU