My Oracle Support Banner

Error When Assessing User Adoption Report: "Error getting drill information" (Doc ID 2505026.1)

Last updated on NOVEMBER 01, 2019

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.13.18.05.0 and later
Oracle Fusion Engagement Cloud Service - Version 11.13.17.10.0 and later
Information in this document applies to any platform.

Symptoms

 
When attempting to run user adoption dashboard using Sames Manager user, the following error occurs.

ERROR
-----------------------
Error getting drill information: SELECT "Active Days Facts"."# of Active Days" saw_0, "Channel"."Channel" saw_1 FROM "Sales - CRM Resource System usage" WHERE ("Time"."Month" = VALUEOF ("CURRENT_MONTH"))

Error Details:
Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 27046. [nQSError: 27046] Inaccessible column: "Time"."Month".
Please have your System Administrator look at the log for more details on this error. (HY000)
SQL Issued: {call NQSGetLevelDrillability('SELECT "Active Days Facts"."# of Active Days" saw_0, "Channel"."Channel" saw_1 FROM "Sales - CRM Resource System Usage" WHERE ("Time"."Month" = ''2019 / 03'') AND ("Time"."Year" = ''2019'')')}


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Retrieve the User Adoption Dashboard through https://cloudcustomerconnect.oracle.com/posts/278f67ae52

2. Import the .catalog in Shared/Custom

3. Login as Sales Manager

4. Open the dashboard

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the report

 

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
 Get the User System Usage Duty Role
 Add Additional Users for System Usage
References


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