Error when Filtering Logical SQL Report off OTBI Report — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Error when Filtering Logical SQL Report off OTBI Report

edited Mar 26, 2019 5:36PM in Reporting and Analytics for HCM 3 comments

Summary

Obdc Driver Error when filtering based off OTBI Report

Content

Hello,

I'm currently trying to filter a logical SQL changes report based off an OTBI Analysis that identifies officers by using pay elements. I receive the below error once I apply the filter. I have attached both of the XML's. Any advice is appreciated!

The error is below!

 

Code Snippet

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P


State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)


State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)


State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)


State: HY000. Code: 59001. [nQSError: 59001] Join operation is not permitted on operand(s). (HY000)


State: HY000. Code: 46035. [nQSError: 46035] Datatype(UNSIGNED INTEGER) nullable(0) unicode(1) external char(0) conversion to datatype(VARCHAR) nullable(0) unicode(1) external char(0) is not supported. (HY000)
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!