OTBI Analysis- Open po report getting error while adding invoice date
Summary:
Getting errors while adding invoice last updated date
Content (please ensure you mask any confidential information):
Error Codes: OPR4ONWY: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: 46008. [nQSError: 46008] Internal error: File server/Query/Optimizer/SmartScheduler/PhysicalRequestGenerator/Src/SQOSPMarkMultiTargetSupport.cpp, line 6001. (HY000)SQL
Issued: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',DISABLE_CACHE_HIT=1,DISABLE_PLAN_CACHE_HIT=1,LOGLEVEL=7;SELECT 0 s_0, "Payables Invoices - Transactions Real Time"."- General Information"."Invoice Last Updated Date" s_1, "Procurement - Procure To Pay Real Time"."Balancing Segment"."Balancing Segment Code"||'-'||"Procurement - Procure To Pay Real Time"."Balancing Segment"."Balancing Segment Description" s_2, "Procurement - Procure To Pay Real Time"."Cost Center"."Cost Center Code"||'-'||"Procurement - Procure To Pay Real Time"."Cost Center"."Cost Center Description" s_3, "Procurement - Procure To Pay Real Time"."Natural Account"."Account Code"||'-'||"Procurement - Procure To Pay Real Time"."Natural Account"."Account Description" s_4, "Procurement - Procure To Pay Real Time"."Procurement Item"."Category Name" s_5, "Procurement - Procure To Pay Real Time"."Purchase Order Additional Attributes"."Creation Date"