Skip to Content
0
Former Member
Nov 07, 2012 at 05:22 PM

Error while data previewing calculation view

81 Views

When i preview my calculation view, am getting following error.

Generated Data Preview Query: SELECT TOP 5000 sum("RFID_MATCHED") AS "RFID_MATCHED", sum("RFID_SCANNED") AS "RFID_SCANNED", sum("RFID_SHIPPED") AS "RFID_SHIPPED", "SHIP_TO_PARTY1", "REGION", "PRODUCT", "COUNTRY", "PRODUCT_LINE", "PRODUCT_GROUP", "DELIVERY_DOCUMENT_NO", "SHIP_TO_PARTY", "LAST_RECORDED_DATE", "LAST_RECORDED_LOCATION", "DELIVERY_LOCATION", "STATUS" FROM "_SYS_BIC"."rfid-enabled-scvisibility/CA_DISCREPANCY_ANALYSIS" GROUP BY "SHIP_TO_PARTY1", "REGION", "PRODUCT", "COUNTRY", "PRODUCT_LINE", "PRODUCT_GROUP", "DELIVERY_DOCUMENT_NO", "SHIP_TO_PARTY", "LAST_RECORDED_DATE", "LAST_RECORDED_LOCATION", "DELIVERY_LOCATION", "STATUS"

Error Executing Query: SAP DBTech JDBC: [2048]: column store error: search table error: [2620] executor: plan operation failed;column store error: logical index creation error: [2052] attribute type is invalid at ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/trex_joinindex.cc:1131

And i came to know that it is due to "STATUS" field which i have added as,

CASE WHEN B."RFCNT"="RFID_SHIPPED" AND J."RFID_MATCHED" < B."RFCNT" THEN 'POTENTIAL_COUNTERFEIT' when

(B."RFCNT" < "RFID_SHIPPED") THEN 'LOSS' END AS "STATUS"

Here RFID_SHIPPED AND RFID_MATCHED are coming from innner query. If i remove this STATUS field then am getting output, only if i addthis STATUS field am getting error. Please help me in solving this.