Self-Solve Knowledge Search

Minimize Maximize
OLE Error 800400CF while generating graph
This document has not been formally reviewed for accuracy and is provided as is
Title :
OLE Error 800400CF while generating graph
Document ID :
KM02023739
Product - Version:
quality center ;
OS :
Updated :
Mon Dec 14 04:31:49 GMT 2015
Summary :
OLE Error 800400CF while generating graph
Problem

OLE Error 800400CF

image text

Cause
When the graph is generated, the SQL query used in the backend contains columns that are not required.
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.