This discussion is archived
3 Replies Latest reply: Oct 25, 2013 10:38 AM by user10615659 RSS

Error in Answers

986975 Newbie
Currently Being Moderated

Hi All,

 

I create a Physical table from query as follows -

 

with t as ( select order_id,shipped_date

from order_ship_detail_fact

group by  order_id,shipped_date)

 

 

select

ts.ORDER_ID

,ts.SRC_ORG_ID

,ts.ITEM_ID

,ts.EXPECTED_SHIP_DATE

,ts.LINE_FILL_STATUS

,ts.LINE_FILL_COUNT

,ts.LINE_SHORT_COUNT

,t.SHIPPED_DATE

from order_fill_rate ts,

t

where t.order_id=ts.order_id

 

This table has got joints with ORDER_ID, ITEM_ID, SHIPPED_DATE and EXPECTED_SHIP_DATE.

There are 2 different tables for SHIPPED_DATE and EXPECTED_SHIP_DATE

 

When I create a report, I get following error -

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

 

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. Please have your System Administrator look at the log for more details on this error. (HY000)
Any pointers on this?

 

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points