cancel
Showing results for 
Search instead for 
Did you mean: 

Error uploadind data into ODS

Former Member
0 Kudos

Hello there,

i'm trying to load data into an ODS from R/3 DataSources. I plan the infoPackage to load data into the PSA and then into the ODS.

The data is actually loaded into the PSA but the process fails (i think) when activating the ODS Data. I get the following error messages (several times):

"Task 0001 for parallel SID assignment terminated with errors"

"Error getting SID for ODS Object <ODS_name>"

"System error occurred (RFC Call)"

Do you know what can i do to fix this?

Thanks a lot!

Marta

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Marta,

This problem occurs sometime becuase of Table space problem in database.

Try to uncheck the option " Automatic Activate data " option in ODS Settings and see manually you are able to activate that or not.

If not give us the detailed message.

Regards,

Ashish

Former Member
0 Kudos

Hi!

It works. I did the load first and then manually activated the ODS data and it worked.

Thanks a lot.

i'm sorry, i know it's sad, but i'm trying to reward your answers and i can't find the way. i see the check-list buttons but, is there any button to commit the selection?

Answers (1)

Answers (1)

0 Kudos

hi Marta,

happy new year ...

try to check detail error

- monitoring tab 'details' expand the last node 'processing'

- shortdump and system log transaction st22 and sm21

- job log with transaction sm37, job name 'bi_odsa*'

possible error

- no master data exist -> check in infopackage tab 'update' if option set 'always update data.. even no master data'.

- invalid data

  • lower case not allowed -> translate to upper case use method 'routine' in infoobject mapping.

result = tran_structure-[fieldname].

translate result to upper case.

  • contains special character -> transaction rskc and type in 'ALL_CAPITAL' to allow all special characters.

  • time characteristics not in correct format

date : YYYYMMDD ; month : MMYYYY

  • 0unit not exist in master data

try to check table t006a, if not exist, you may check the same table t006a in r/3 side, if exist you can transfer these data from r/3

rsa1->source system->right click r/3 source system->'transfer global setting', mark 'unit of measurements' and choose option 'update table'->execute

if the data also not exist in r/3 then you need to maintain manually using transaction CUNI following steps in the thread

hope this helps.