Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Issue while scheduling BI Publisher report - 12.2.1.3.0 — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Issue while scheduling BI Publisher report - 12.2.1.3.0

Received Response
15
Views
1
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 1 comment

Summary

Getting unique constraint violated error while scheduling BIP report.

Content

Hi all,

 

I have a BI Publisher report, which I want to burst and FTP the output. The FTP is working fine.

When the report is run standalone it gets executed and gives output, but when it is being scheduled through BI Publisher scheduler, getting the below error.

Can someone who has faced/not faced the same issue provide the resolution/inputs.

Thanks in advance.

 

I believe the below table would be handled by OBI itself, and column JOB_ID (primary key of table) on which the unique constraint is getting violated would be a sequence, then why its trying to insert the same value in this column?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!