My Oracle Support Banner

Error: 'The Following Error Occurred: Oracle BI Scheduler Error: [nQSError: 16002] Cannot Obtain Number of Columns for the Query Result' When Attempting to Set Up an Agent to Deliver Dashboard Data to Any Email Address (Doc ID 2417329.1)

Last updated on MARCH 09, 2020

Applies to:

Primavera Analytics Cloud Service - Version 16.2.0.0 and later
Primavera Analytics - Version 16.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When configuring an Agent to send a Dashboard to an email address, the following error is displayed when attempting to save the changes to the Agent:

ERROR
-----------------------
"The following error occurred: Oracle BI Scheduler Error: [nQSError: 16002] Cannot obtain number of columns for the query result".

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Login to the Analytics environment
  2. In the Global Header, click Catalog
  3. Navigate to the configured Agent
  4. Click the Schedule tab and ensure a schedule is defined.
  5. Click the Recipients Tab and ensure an email address is defined.
  6. Click the Save button to Save the Agent.

Changes

 

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
Changes
Cause
Solution


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