CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Report throwing an error for some of the users

edited Feb 25, 2014 3:50PM in CRM On Demand - Reports and Dashboards (MOSC) 7 commentsAnswered

I have a report based on the Company Object and I am also displaying it on the Dashboard.
If I run it as an Admin it see it correctly, however if I run it as a user with specific access, they cannot see the report and it throws the following error:

Odbc driver returned an error (SQLExecDirectW).
Error Details Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 14023] None of the fact sources for FILTER(# of Accounts:[DAggr(Fact - Account.# of Accounts by [ Dim - Time.Calendar Month/Yr, Dim - Time.Calendar Week] )] USING Dim - Account.Created Date >= TIMESTAMP '2012-12-16 00:00:00.000' and Dim - Account.Created By <> 'ADMINISTRATOR' and Dim - Account.Account Type in ([ 'Customer', 'Customer Prospect', 'Other', 'Potential Supplier- Non-US', 'Potential Supplier- US', 'Supplier'] ) and Dim - Account.PICK_4 in ([ 'Marine', 'Marine EIP'] )) are compatible with the detail filter [Dim - Contact.Security Position (Group Based) = 'ANNA-IEBOB', Dim

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center