11 Replies Latest reply: Mar 11, 2013 7:50 AM by USER16888 RSS

    Can any one know why this error is comming

    993269
      hi

      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14025] No fact table exists at the requested level of detail: [,,[Dim - Product.Product, Dim - Product.Product Number, Dim - Product.COMMODITY CODE],Day Detail,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Supplier Name,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - Purchase Order Attributes.Purchase Order Number, Dim - Purchase Order Attributes.CURR CODE, Dim - Purchase Order Attributes.STD COST],[Dim - Purchase Requisition Attributes.PO RECEIPT DATE],,,,,,,,,,,,,,,,,,,,,Dim - Purchase Cycle Status,,,,,,,,,,,,,,[Dim - Due Date.Due Date],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Fact - Purchasing - Order.PO PRICE, Fact - Purchasing - Order.PO RECEIVED QTY],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,]. (HY000)
      SQL Issued: SELECT 0 s_0,
      "Procurement and Spend - Purchase Orders"."Cycle Status"."Purchase Cycle Status" s_1,
      "Procurement and Spend - Purchase Orders"."Fact"."PO PRICE" s_2,
      "Procurement and Spend - Purchase Orders"."Fact"."PO RECEIVED QTY" s_3,
      "Procurement and Spend - Purchase Orders"."Product"."COMMODITY CODE" s_4,
      "Procurement and Spend - Purchase Orders"."Product"."Product Name" s_5,
      "Procurement and Spend - Purchase Orders"."Product"."Product Number" s_6,
      "Procurement and Spend - Purchase Orders"."Purchase Details"."CURR CODE" s_7,
      "Procurement and Spend - Purchase Orders"."Purchase Details"."Due Date" s_8,
      "Procurement and Spend - Purchase Orders"."Purchase Details"."PO RECEIPT DATE" s_9,
      "Procurement and Spend - Purchase Orders"."Purchase Details"."Purchase Order Date" s_10,
      "Procurement and Spend - Purchase Orders"."Purchase Details"."Purchase Order Number" s_11,
      "Procurement and Spend - Purchase Orders"."Purchase Details"."STD COST" s_12,
      "Procurement and Spend - Purchase Orders"."Supplier"."Supplier Name" s_13,
      "Procurement and Spend - Purchase Orders"."Supplier"."Supplier Number" s_14,
      "Procurement and Spend - Purchase Orders"."Fact"."PO Amount" s_15,
      "Procurement and Spend - Purchase Orders"."Fact"."PO Quantity" s_16
      FROM "Procurement and Spend - Purchase Orders"


      Thanks