Invalid Row Number Error on Audience when Loading QAS Remote Query with Prompts (Doc ID 2177650.1)

Last updated on AUGUST 30, 2016

Applies to:

PeopleSoft Enterprise CRM Marketing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to load QAS Remote Query with different number of parameters on Audience, the following error is returned:

ERROR MESSAGE
--
Invalid row number 1 for class Rowset method DeleteRow. (2,263)
RA_QAS_FRAMEWORK.GetQueryPrompts.OnExecute Name:GetQryPromptsViaQAS
PCPC:1363 Statement:20
Called from:RA_LIST.GBL.RA_QAS_LISTQRY.RA_QAS_QUERY_NAME.FieldChange
Statement:5

A PeopleCode program has called an object method with an invalid value for
the row number parameter. The row number should be within the range of
existing rows in the rowset.

Use the PeopleCode Debugger or a PeopleCode trace to determine the point of
the error and correct the program.



STEPS
-----------------------
1. Configure QAS Query between CRM 9.2 and HR 9.0

Service Operations Used:
QAS_EXECUTEQRYSYNC_OPER
QAS_LISTQUERY_OPER
QAS_LISTQUERYPROMPTS_OPER

2. In HR, create atleast two(2) queries, one with two(2) prompts or
parameters and the other with three(3).

3. Go to CRM and create a Marketing Audience with Audience Source = ¿Internal
Using PSQuery¿
4. Select Is Remote Query = Yes
5. Locate Remote Query beginning with 'QAS¿
6. Select the query with 2 parameters first
The query is loaded ok and the two(2) parameters are shown.
7. Change the query selected for Remote Query to the query with 3 parameters
- Error is returned.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, existing remote queries cannot be changed in Campus.

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