This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.
Summary
Error
OLE Error 800400CF
Cause
Fix
This is the query that is ran in the backend for the graph.
SELECT TC_TESTCYCL_ID FROM TESTCYCL INNER JOIN ((SELECT -1 AS TSC_BL_ID, TSC_ATTACHMENT,TSC_CREATED_BY,TSC_CREATION_DATE,TSC_DATA_FILTERING,TSC_DATA_OBJ,TSC_DATA_STATE,TSC_DESC,TSC_EXEC_STATUS,TSC_ID,TSC_NAME,TSC_TEST_ID,TSC_USER_01,TSC_VC_CHECKOUT_USER_NAME,TSC_VTS FROM TEST_CONFIGS) UNION ALL (SELECT TSC_BL_ID,TSC_ATTACHMENT,TSC_CREATED_BY,TSC_CREATION_DATE,TSC_DATA_FILTERING,TSC_DATA_OBJ,TSC_DATA_STATE,TSC_DESC,TSC_EXEC_STATUS,TSC_ID,TSC_NAME,TSC_TEST_ID,TSC_USER_01,TSC_VC_CHECKOUT_USER_NAME,TSC_VTS FROM BL_TEST_CONFIGS)) TEST_CONFIGS_TABLE ON TSC_ID=TC_TEST_CONFIG_ID INNER JOIN ((SELECT -1 AS TS_BL_ID, TS_ATTACHMENT,TS_BASE_TEST_ID,TS_BPTA_CHANGE_DETECTED,TS_CREATION_DATE,TS_DESCRIPTION,TS_DEV_COMMENTS,TS_ESTIMATE_DEVTIME,TS_EXEC_STATUS,TS_NAME,TS_ORDER_ID,TS_PATH,TS_PROTOCOL_TYPE,TS_RESPONSIBLE,TS_RUNTIME_DATA,TS_SERVICE_TEST_MODE,TS_STATUS,TS_STEPS,TS_STEP_PARAM,TS_SUBJECT,TS_TEMPLATE,TS_TESTING_FRAMEWORK,TS_TESTING_TOOL,TS_TEST_ID,TS_TEST_VERSION,TS_TEST_VER_STAMP,TS_TEXT_SYNC,TS_TIMEOUT,TS_TYPE,TS_USER_01,TS_USER_02,TS_USER_03,TS_USER_04,TS_USER_05,TS_USER_06,TS_USER_07,TS_USER_08,TS_USER_09,TS_USER_10,TS_USER_11,TS_USER_12,TS_USER_13,TS_USER_14,TS_USER_15,TS_USER_16,TS_USER_17,TS_USER_18,TS_USER_19,TS_USER_20,TS_USER_21,TS_USER_22,TS_USER_23,TS_USER_24,TS_USER_HR_01,TS_USER_HR_02,TS_USER_HR_03,TS_USER_HR_04,TS_USER_HR_05,TS_USER_HR_06,TS_UT_CLASS_NAME,TS_UT_METHOD_NAME,TS_UT_PACKAGE_NAME,TS_VC_CHECKIN_COMMENTS,TS_VC_CHECKIN_DATE,TS_VC_CHECKIN_TIME,TS_VC_CHECKIN_USER_NAME,TS_VC_COMMENTS,TS_VC_CUR_VER,TS_VC_DATE,TS_VC_END_AUDIT_ACTION_ID,TS_VC_START_AUDIT_ACTION_ID,TS_VC_STATUS,TS_VC_TIME,TS_VC_USER_NAME,TS_VC_VERSION_NUMBER,TS_VTS,TS_WORKING_MODE FROM TEST) UNION ALL (SELECT TS_BL_ID,TS_ATTACHMENT,TS_BASE_TEST_ID,TS_BPTA_CHANGE_DETECTED,TS_CREATION_DATE,TS_DESCRIPTION,TS_DEV_COMMENTS,TS_EI_EFFORT,TS_EI_PRIORITY,TS_ESTIMATE_DEVTIME,TS_EXEC_STATUS,TS_NAME,TS_ORDER_ID,TS_PATH,TS_PROTOCOL_TYPE,TS_RESPONSIBLE,TS_RUNTIME_DATA,TS_SERVICE_TEST_MODE,TS_STATUS,TS_STEPS,TS_STEP_PARAM,TS_SUBJECT,TS_TEMPLATE,TS_TESTING_FRAMEWORK,TS_TESTING_TOOL,TS_TEST_ID,TS_TEST_VERSION,TS_TEST_VER_STAMP,TS_TEXT_SYNC,TS_TIMEOUT,TS_TYPE,TS_USER_01,TS_USER_02,TS_USER_03,TS_USER_04,TS_USER_05,TS_USER_06,TS_USER_07,TS_USER_08,TS_USER_09,TS_USER_10,TS_USER_11,TS_USER_12,TS_USER_13,TS_USER_14,TS_USER_15,TS_USER_16,TS_USER_17,TS_USER_18,TS_USER_19,TS_USER_20,TS_USER_21,TS_USER_22,TS_USER_23,TS_USER_24,TS_USER_HR_01,TS_USER_HR_02,TS_USER_HR_03,TS_USER_HR_04,TS_USER_HR_05,TS_USER_HR_06,TS_UT_CLASS_NAME,TS_UT_METHOD_NAME,TS_UT_PACKAGE_NAME,TS_VC_CHECKIN_COMMENTS,TS_VC_CHECKIN_DATE,TS_VC_CHECKIN_TIME,TS_VC_CHECKIN_USER_NAME,TS_VC_COMMENTS,TS_VC_CUR_VER,TS_VC_DATE,TS_VC_END_AUDIT_ACTION_ID,TS_VC_START_AUDIT_ACTION_ID,TS_VC_STATUS,TS_VC_TIME,TS_VC_USER_NAME,TS_VC_VERSION_NUMBER,TS_VTS,TS_WORKING_MODE FROM BL_TEST)) TEST_TABLE ON (TS_TEST_ID=TC_TEST_ID AND isnull((TC_PINNED_BASELINE), (-1))=TS_BL_ID) WHERE TC_TESTCYCL_ID IN (/*P*/1554,/*P*/1561,/*P*/1562,/*P*/1555,/*P*/1556,/*P*/1559,/*P*/1558,/*P*/1557,/*P*/1560) ORDER BY TC_TEST_ORDER ASC;
This query contains two columns (TS_EI_EFFORT and TS_EI_PRIORITY) that are not available in TEST table but available in BL_TEST table which caused the issue. Once the columns are removed from BL_TEST table, the issue is resolved.