Error when assigning SID: Action VAL_SID_CONVERT InfoObject

[Former Member]

Hi,

We are loading data from a custom table of ERP to BW system.  But at the time of activation, we face lots of errors due to incorrect maintenance of time data from source.  The custom table were populated with data from users.

We find difficult in correcting data from PSA as we are doing full upload, it's a painful task to correct the data every day.  Please suggest what's the best approach to be followed to optimize the same.

Following is the errors displayed:

"

Value '0330' of characteristic 0TIME is not a number with 000006 spaces

Error when assigning SID: Action VAL_SID_CONVERT InfoObject ZCUT_OFF

Process 000002 returned with errors

"

Plz find attached screen shot of incorrect updation:

Regards,

Antony Jerald.

[Former Member]

Hi,

Can any one help me in this?

Actually, this kind of information was automatically handled in ERP Abap reports.  This actually creates problem in BW Reporting at the time of data loading.

Plz help me how to handle these errors.

Regards,

Antony Jerald.

[srinivasan_vinayagam]

Hi Antony,

Run the report in SE38 RSDMD_CHECKPRG_ALL and re-activate the objects.

Regards,

V Srinivasan

[Former Member]

Hi,

How does this report works and corrects all the incorrect records?  The error is due to incorrect records which is getting transferred from source ERP system.  In source system, those type of incorrect time data were automatically handled by abap program.

Plz suggest.

Regards,

Antony Jerald.

[Former Member]

HI,

If you are loading into DSO, please uncheck SID generation in DSO settings.

Regards,

Rahul S