on 12-05-2012 7:56 AM
ok..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
the message says "
data package contains error messages. transformation inactive, cannot be executed"
also, "too many error records, update terminated"
also, i am getting the below msg:
The existing DTP requires a serialized update because fields are updated
non-commutatively during the processing run (for example, MOVE).
Therefore all new data records that have the same semantic key as
incorrect records that have not yet been corrected in earlier requests
or earlier data packages of the same request, are filtered out after the
extraction in a special step. In this way the system ensures that
incorrect data records are not repeated for your changes, which may not
contain errors themselves.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kirti,
This thread is getting nowhere with an array of suggestions.
Ok. Start fresh.
Since you have mentioned that you couldn't find any error records, I'd suggest you to load a sample dataset (for eg. 5-10 records) and check whether it's loading fine without any issue.
If the problem still persists, start a new discussion and follow it from there. The reason why I'm telling is that if any new person wants to post on your issue, he has to go through all the replies made by others so that he won't suggest existing solutions and it saves time as well. Close this thread and start a new discussion.
Br,
H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi all,
i am working on sap bi version 3.0...i dont have the 'handle duplicate records' option in the dtp.. could u let me know how to perform this action in 3.0 bi?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check if setting "Unique Data Records" is not switched on in your DSO.
Regards,
DL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In addition to the above comments, check whether "Handle duplicate records" is enabled in your DTP under "Update" tab.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Enabling 'handle duplicate records' may solve the issue by overwriting the first erroneous record with the subsequent erroneous records with the same semantic key and at the end there might be only one record.I dont think u can lose records unless its a master data load or multiple transaction data full loads. So enable it if its okay to lose records
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check with your source data and the data type specs (length, type) in the BW system matches.
The records you are showing may not be erroneous records but contains the same key as the error record. This record you have to find but it usually is the first record for the specified key set in the error stack.
If you don't want this, you can delete the records in the error stack and run the dtp for successful loading.
Br,
H
Hi Kirti,
I dont know for what error the dtp filtered out a record.But what i do understand from the error message is you were trying to load to a dso which will overwrite records with same semantic key combination. Also you might have enabled semantic key check in dtp. So ideally u should not be loading data with same semantic key ecombination which means duplicate records which in d so means loss of records.So see the first record in the error dtp or datasource and try to correct it manually or do a trial and error method by running with one record in the same transformation.
It can also happen if u are loading transaction data before master data and u have not enabled it at the same time.
Arjun
hi,
the transformation is active... can i still run the program RSDG_TRFN_ACTIVATE from SE38??
also, i am getting the below msg:
The existing DTP requires a serialized update because fields are updated
non-commutatively during the processing run (for example, MOVE).
Therefore all new data records that have the same semantic key as
incorrect records that have not yet been corrected in earlier requests
or earlier data packages of the same request, are filtered out after the
extraction in a special step. In this way the system ensures that
incorrect data records are not repeated for your changes, which may not
contain errors themselves.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kirti,
If your transformation is active, then no need to use the program.
Semantic keys and error stack ensures serialization and this is the general behavior.
From your error message it is apparent that you have error records in the error stack.
Correct those records in the error stack and run the error dtp.
It is not possible to load further records of same keys unless you correct the records in the error stack and update it to target.
If this is done, you can proceed in loading further records through normal DTP.
Br,
H
Hello Krti
Check the transformation between DataSource and DSO. Sometimes in RSA1 screen it shows green but when you open, it might be inactive.
You can use program RSDG_TRFN_ACTIVATE from SE38 to directly activate an inactive transformation. Run the program and input technical name of the transformation.
Cheers
Anindya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kirti,
Plz check transformation are in M Version or active version(executable). if transformations are inactive, make it as active and delete red request at target manager tab and try to re run DTP.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kirti,
Check whether your transformation is active.
Next, check your source package and error stack (if any) for erroneous records.
Correct those and try to load a single record. If it's successful, go for mass load.
Br,
H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
there might be an invalid data being inserted to the DSO check the other error messages in the DTP.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.