Skip to Content
0

Loading data in BW - Violation of PRIMARY KEY constraint 'PK__AL_BW_RE in AL_BW_REQUEST table

Oct 19, 2016 at 05:03 PM

111

avatar image

Hello All,

I am trying to load the data from BODS into BW target datasource(PSA), When I am loading the data from my local repository the data is getting loaded successfully.

However when we are executing the job from designer/admin console of dedicated development repository, the same one that is configured below in BW infopackage(Third party parameters), we are getting error as ‘primary key violation in AL_BW_REQUEST ’ table.

I also checked the request ID generated on BW end but found no duplicates.

Note: Repository and Job server is maintained and configured by our basis team, we are only providing the job name in below selections.

Can anyone please suggest what is causing this error and how can we prevent this?

image11.jpg (37.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Magesh Subramanian Oct 19, 2016 at 07:14 PM
0

The following thread might help you

https://archive.sap.com/discussions/thread/3681955

Share
10 |10000 characters needed characters left characters exceeded
RAJIV KUMAR Oct 20, 2016 at 10:58 AM
0

Hello Magesh,

The thread you asked me to refer suggested a solution to provide the info package name in BODS end, I have already mentioned the info package name in BODS data source attributes(Refer to below image).

I have facing issues when executing the job from designer/admin console of dedicated development repository, the same one that is configured below in BW info package(Third party parameters)

And getting this error ‘primary key violation in AL_BW_REQUEST ’ table.

Can anyone suggest me a solution here?

Regards,

Rajiv


image22.jpg (51.8 kB)
Share
10 |10000 characters needed characters left characters exceeded