Error when Filtering Logical SQL Report off OTBI Report
Summary
Obdc Driver Error when filtering based off OTBI ReportContent
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)
1