Error when Filtering Logical SQL Report off OTBI Report

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)