Stale or Failed Cardinality Statistics cause queries to fail
Welcome to "KB Articles"
Stale or Failed Cardinality Statistics cause queries to fail
book
Article ID: KB0083066
calendar_today
Updated On: 12-12-2017
Products
Versions
TIBCO Data Virtualization
-
Description
com.compositesw.cdms.webapi.WebapiException: An internal error has occurred. Cause: i=42 j=0 Unable to execute: /* SELECT RESOURCE_NAME, STATUS FROM /services/databases/system/SYS_STATISTICS WHERE STATUS <> 'UP' AND PARENT_PATH like '/shared/WSCommon/Physical/Metadata/NewMSS/MSSNG_LIVE%' AND LAST_SUCCESS_DURATION is NULL ORDER BY RESOURCE_NAME /* SELECT * FROM --/shared/MSSUnifiedView/Application/Published/MSS/UnifiedView/ORDER_SEARCH /shared/MSSUnifiedView/Business/Business/ORDER_SEARCH_BL WHERE ORDER_NUMBER = '12345' ORDER BY CUST_NAME */ SELECT * FROM /shared/MSSUnifiedView/Application/Published/MSS/UnifiedView/NEXTGEN_ORDER_SEARCH WHERE /*CUST_NAME = 'ALLTEL'*/ORDER_NUMBER = '12345' ORDER BY CUST_NAME /* SELECT count(*) FROM /shared/WSCommon/Physical/Metadata/ExistingMSS/lVOX/ASAP/SERV_REQ --FROM /shared/WSCommon/Physical/Metadata/ExistingMSS/lVOX/ASAP/CIRCUIT */ --select count(*) from /shared/WSCommon/Physical/Metadata/ExistingMSS/lVOX/ASAP/CIRCUIT --select COUNT(*) from /shared/WSCommon/Physical/Metadata/ExistingMSS/lVOX/ASAP/SERV_REQ /* select * from /shared/ASAssets/Utilities/repository/getDependentResourcesRecurseCursor('/shared/WSCommon/Physical/Metadata/ExistingMSS/hWIN/ASAP/SERV_REQ_SI_VALUE', 'TABLE', NULL) WHERE resourcePath like '/services%' AND resourcePath not like '%MSSOCDM%' */
Issue/Introduction
Stale or Failed Cardinality Statistics cause queries to fail