Hello.
We have the following setup:
DS 4.1 (14.1.2.378)
BW 7.3
And we’re attempting to load data into BW using DS. We have done all the setup required on both sides and the connections are working. Now, when I execute a load job in DS with BW targets, data is loaded fine into the BW PSA and everything is OK on the DS side, no errors or warnings. However, in the BW data package we get an error:
Error while accessing repository: BODS_DEV_Develop Violation of PRIMARY KEY constraint 'PK__AL_BW_RE_
If I look in my repository database, AL_BW_REQUEST, I can see that requests are logged there with the correct Dataflow names. However, if I look up the job in DS (DS/BW seems to create their own “background” jobs corresponding to the InfoPackages) I can sometimes see that the job has an incorrect, not valid, target object! It seems that something is lost along the way between DS and BW…
We have tried to delete InfoPackages and re-running the jobs, but no luck there, still the same error.
Have any of you encountered anything like this?
rtaro 
(BOB member since 2007-06-19)