Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 19, 2016 at 07:14 PM

    The following thread might help you

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2016 at 10:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded