Marketing Segmentation Query Is Cancelled - ORA-01013: User Requested Cancel Error
(Doc ID 2336973.1)
Last updated on APRIL 13, 2021
Applies to:Siebel Marketing - Version 16.14 [IP2016] and later
Information in this document applies to any platform.
On : 16.14 [IP2016] version, Siebel Marketing
When running Campaign Load, the WriteListFiles Job generated fails with the following error:
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 1013, message: ORA-01013: user requested cancel of current operation at OCI call OCIStmtFetch. [nQSError: 60009] The user request exceeded the maximum query governing execution time. (HY000)
The issue can be reproduced at will with the following steps:
1. Configure a Campaign with a Segment
2. Load it
3. In OBIEE go to Manage Marketing Jobs
4. Locate the WriteListFiles
5. The Job says that no file has been generated as there is no data to be generated
6. If you check the Job Details then you will see the error above mentioned.
A Custom Subject Area has been created using a custom table/custom joins.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document