Marketing Segmentation Query Is Cancelled - ORA-01013: User Requested Cancel Error

(Doc ID 2336973.1)

Last updated on FEBRUARY 28, 2018

Applies to:

Siebel Marketing - Version 16.14 [IP2016] and later
Information in this document applies to any platform.

Symptoms

On : 16.14 [IP2016] version, Siebel Marketing

When running Campaign Load, the WriteListFiles Job generated fails with the following error:

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)


STEPS
-----------------------
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.

Changes

A Custom Subject Area has been created using a custom table/custom joins.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms