Marketing Campaign Load Fails For Segmentation Trees Using Filtered Marketing List Formats, erros [nQSError: 59001] and [nQSError: 17001] - ORA-30483:
(Doc ID 2479527.1)
Last updated on SEPTEMBER 17, 2021
Applies to:
Siebel Marketing - Version 16.16 [IP2016] and laterInformation in this document applies to any platform.
Symptoms
On : 16.16 [IP2016] version, Siebel Marketing
Marketing Campaign Load fails for Segmentation Trees using filtered Marketing List Formats
Scenario For the Behavior:
A) Add Section 1 and Section 2 as logical SQL to any report that returns more than 4 records.
Result => only the first 4 records are shown
B) Add Section 1 and Section 2 and Section 3 as logical SQL to any report that returns more than 4 records.
Result => [nQSError: 59001] Multiply operation is not permitted on VARCHAR, NUMERIC operand(s). (HY000)
C) Add Section 1 and Section 2 and Section 3 as logical SQL to any report that returns more than 4 records - but remove CASE WHEN ... END statement before
Result => [nQSError: 17001] Oracle Error code: 30483, message: ORA-30483: Fensterfunktionen sind hier nicht zulässig at OCI call OCIStmtExecute. (HY000)
NOTE: The same error occurred when behavior was tested in Answers.
Cause
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
Symptoms |
Cause |
Solution |
References |