Stale or Failed Cardinality Statistics cause queries to fail

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

Resolution

This issue is resolved in 7.0.5 Hotfix 04