on 01-02-2006 6:04 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.