OLE Error 800400CF while generating graph

  • KM02023739
  • 14-Dec-2015
  • 14-Dec-2015

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

OLE Error 800400CF while generating graph

Error

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.