Marketing Segmentation Query Is Cancelled - ORA-01013: User Requested Cancel Error
Last updated on FEBRUARY 28, 2018
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms