Hi,
I have followed the steps for Oracle Reports HA setup, I have 2 nodes and job status repository setup in the database.
The reports are running fine, but the jobid that is generated on each node is not unique across the cluster, only locally. This creates unique constraint errors when creating a new job.
The jobid doesn't appear to come from a database sequence, rather from each Managed Server, but they do not share a sequence. I know I can replace the sequential jobids with random IDs, but I doubt this will be guaranteed to be unique across the cluster either.
Did I miss a step somewhere?
Thanks!
(Reports 12.2.1.19.0, Linux)