My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.