Unable to find the error record in data package in PSA

[Former Member]

Hi all,

We have an error "Error when assigning SID: Action VAL_SID_CONVERT, InfoObject ZLOC_ITEM, Process0021 returned with errors" and checked in the process monitor under the "Activation of data" in Data package 0021 the error displayed. this is due to invalid chars.

In PSA there are 253 data package with 20000 records each, we checked in data package no.21 for the invalid chars, couldn't find the error that particular data package. My doubt is how come the error record is not available in the data Pkg of PSA.

Note: In the process monitor under the "activation of data" only 152 data packages are available. Please advise.

Raj

[Former Member]

HI ,

It won't be showing as an error in PSA and you cannot see the record in same data packet what you have seen in error log. The data packet you have seen is DTP's one. Hope following steps will help you to resolve the issue....

go to you error log and find out the info object which has got error and select the value as well from the log.

Right click on you data source and manage

Select your latest request and press F5

select first 5 or 6 DP and execute

PSA will be opened with selected DP

Identify the field which is belogs to that Info Object which got error and Select the Entire field by clicking on top

then context menu of the field and find

Paste the value what you have copied from log and find

then edit

Save

continue the process if there are small amout of record to be modified , else go for abap routine for permanent solution..

regards

BVR

[Former Member]

Hi,

Me thinks this is "Assigning SID" error, so this will occur only while activating. It is not always with Invalid values. So those values are not showing as errorenous.

If in your DSO, you do not have "SIDs Generation upon Activation" checked, then data will be successfully loaded in DSO too.

Check DSO activation error log.

[Former Member]

Try this,

Right click on datsource --> Manage.

Top of right hand side you will find technical name of PSA table something like /BIC/B0000*

Go to SE16 display the name /BIC/B0000* keep filter with invalid character, it will give you details like request no.

In PSA you can use this request no. and filter out your error record to solve your problem

Sushant

[Former Member]

Hi

durairaj.shan ,

When ur running the DTP, it gives the error , please see the records in the Error Stack , where you can find the all the error records .

From there Error Stack select the records based on ur column values , select those records in the PSA and change those records . Please do the free selection means select all the packets in PSA.

Hope this will help u

With Records

Avenai

[Former Member]

hi,

Please check whether there are any look ups being used. In this case you cant find any error in the PSA.

The Invalid characters might be the result of a look up.

Regards,

Rahul

[Former Member]

Hi Raj,

The size of datapacket is only 20,000 when compared to size of datapacket while activation of the same request is 50000.

So, for the datapacket of DSO Activation 21 meaning( 50000 *20 = 1000, 000 +50000). Meaning 20000 * 50 + 51,52,53 (20K each ) will comprise your datapackage where you will find the error.

So, search in data packages 51,52 and 53 of PSA.

Else select all the records and give the filter value of the erroneous record value during the activation.

Since the activation failed, you cant see the value directly in the filter selection of erroneous records..

Hope this will help you a lot .

[Former Member]

the package no getting displayed in the Error msg depends on the data packet size of your DTP.

Say for ex if the data packet size of DTP is 30000 then the erroneous record is in-between 600001 and 630000( the 30000 records present in the 21st package of the DTP).

these records between 600001 and 630000 should be from package 30 & 31 of your PSA. so you have to check in these two package for that erroneous record.

The better idea would be to select all the packages in your PSA and use filter for the erroneous field. the invalid char value should be mentioned in the error msg. use that in the filter condition and search for the erroneous record in PSA.

--- Thanks...

[former_member182470]

Hi Raj,

When you try to display the data records from th data package 21, please give free selection in No. of records to be displayed.

Try to locate your erroneous record in this way.

Hope it helps........

Regards,

Suman

[Former Member]

Hi Suman,

thanks for the reply. But my doubt is the error record is not available in the data pkg 21 of psa. How to find the error record in 253 data pakage of PSA.

[Former Member]

follow the advice of rookie:

Select all the PSA packages and filter on erroneous records

That should do the trick.

Marco