Cannot Create a project, OLE Error 80040A29

Cannot Create a project, OLE Error 80040A29

OLE Error 80040A29

Error log are listed below:

Messages:

Failed to create HP ALM project;

Failed to create project ‘LoadTest1’;

Failed to create new project ‘LoadTest1’;

Maintenance task EnableExtensionsTask failed;

Actual upgrade failed;

Failed to check integrity of table ‘ENTITY_SUBTYPE_FIELDS in the project default_loadtest1_db;

Failed SQL: /* ~~QC */ INSERT INTO ENTITY_SUBTYPE_FIELDS (ESTF_SUBTYPE_ID,ESTF_SF_COLUMN_NAME,ESTF_ENTITY_TABLE_NAME) VALUES (/*P*/’PERFORMANCE-TEST’,/*P*/’TS_PC_BLOB’,/*P*/’TEST’)

[Mercury][SQLServer JDBC Driver][SQLServer]Cannot insert duplicate key row in object ‘td.ENTITY_SUBTYPE_FIELDS’ with unique index ‘ESTF_SUBTYPE_FIELDS_IDX’.;

Stack Trace:

java.sql.SQLException: Failed SQL: /* ~~QC */ INSERT INTO ENTITY_SUBTYPE_FIELDS (ESTF_SUBTYPE_ID,ESTF_SF_COLUMN_NAME,ESTF_ENTITY_TABLE_NAME) VALUES (/*P*/’PERFORMANCE-TEST’,/*P*/’TS_PC_BLOB’,/*P*/’TEST’)

[Mercury][SQLServer JDBC Driver][SQLServer]Cannot insert duplicate key row in object ‘td.ENTITY_SUBTYPE_FIELDS’ with unique index ‘ESTF_SUBTYPE_FIELDS_IDX’.

at com.mercury.optane.core.db.CAbsStatement.createSQLExceptionWithSQLStatement(CAbsStatement.java:214)

at com.mercury.optane.core.db.CAbsStatement.doExecute(CAbsStatement.java:197)

at com.mercury.optane.core.db.CTdPreparedStatement.executeUpdate(CTdPreparedStatement.java:540)

at com.mercury.optane.core.db.spring.JDBCTemplate.executeUpdate(JDBCTemplate.java:1066)

wrapped in com.mercury.optane.core.db.CTdDbException:

at com.mercury.optane.core.db.spring.JDBCTemplate.executeUpdate(JDBCTemplate.java:1071)

at com.mercury.optane.core.db.spring.JDBCTemplate.executeUpdate(JDBCTemplate.java:999)

at com.mercury.td.saserver.maintenance.TableDataFromXmlMerger.insertMissingPredefinedRecords(TableDataFromXmlMerger.java:332)

at com.mercury.td.saserver.maintenance.TableDataFromXmlMerger.mergeDataFromXml(TableDataFromXmlMerger.java:119)

wrapped in com.mercury.optane.core.CTdException: Failed to check integrity of table ‘ENTITY_SUBTYPE_FIELDS in the project default_loadtest1_db

at com.mercury.td.saserver.maintenance.TableDataFromXmlMerger.mergeDataFromXml(TableDataFromXmlMerger.java:125)

at com.mercury.td.saserver.maintenance.upgrade.TablesDataUpgrader.run(TablesDataUpgrader.java:72)

at com.mercury.td.saserver.maintenance.BaseFlowStep.start(BaseFlowStep.java:61)

at com.mercury.td.saserver.maintenance.FlowEngine.executeStep(FlowEngine.java:108)

at com.mercury.td.saserver.maintenance.FlowEngine.executeXML(FlowEngine.java:212)

at com.mercury.td.saserver.maintenance.FlowEngine.executeFlowScript(FlowEngine.java:177)

at com.mercury.td.saserver.maintenance.UpgradeTask.actualUpgrade(UpgradeTask.java:319)

wrapped in com.mercury.optane.core.CTdException: Actual upgrade failed

at com.mercury.td.saserver.maintenance.UpgradeTask.actualUpgrade(UpgradeTask.java:336)

at com.mercury.td.saserver.maintenance.UpgradeTask.runTask(UpgradeTask.java:127)

at com.mercury.td.saserver.maintenance.EnableExtensionsTask.upgradeProject(EnableExtensionsTask.java:76)

at com.mercury.td.saserver.maintenance.EnableExtensionsTask.runTask(EnableExtensionsTask.java:56)

at com.mercury.td.saserver.maintenance.EnableExtensionsTask.runTask(EnableExtensionsTask.java:32)

at com.mercury.td.saserver.maintenance.AbsMaintenanceTask.run(AbsMaintenanceTask.java:267)

wrapped in com.mercury.optane.core.CTdException: Maintenance task EnableExtensionsTask failed

at com.mercury.td.saserver.maintenance.AbsMaintenanceTask.run(AbsMaintenanceTask.java:328)

at com.mercury.td.saserver.maintenance.MaintenanceLogic.enableExtensions(MaintenanceLogic.java:298)

at com.mercury.td.saserver.api.logics.CProjectLogic.enableExtensionsAfterCreateProject(CProjectLogic.java:5358)

at com.mercury.td.saserver.api.logics.CProjectLogic.createEmptyProject(CProjectLogic.java:5323)

wrapped in com.mercury.optane.core.CTdException: Failed to create new project ‘LoadTest1’

at com.mercury.td.saserver.api.logics.CProjectLogic.createEmptyProject(CProjectLogic.java:5331)

at com.mercury.td.saserver.api.logics.CProjectLogic.createProject(CProjectLogic.java:2260)

wrapped in com.mercury.optane.core.CTdException: Failed to create project ‘LoadTest1’

at com.mercury.td.saserver.api.logics.CProjectLogic.createProject(CProjectLogic.java:2288)

wrapped in com.mercury.optane.core.CTdException: Failed to create HP ALM project

at com.mercury.td.saserver.api.logics.CProjectLogic.createProject(CProjectLogic.java:2340)

at com.mercury.td.saserver.api.logics.CProjectLogic.createProject(CProjectLogic.java:2071)

at com.mercury.td.saserver.requests.CreateProject.execute(CreateProject.java:56)

at com.mercury.optane.core.web.RequestsDispatcher.execute(RequestsDispatcher.java:90)

at com.mercury.td.web.CAbsServlet.executeFunction(CAbsServlet.java:483)

at com.mercury.td.web.CAbsServlet.processRequest(CAbsServlet.java:475)

at com.mercury.td.web.CAbsServlet.doPost(CAbsServlet.java:349)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.hp.qc.core.utils.gzipfilter.GZIPFilter.doFilter(GZIPFilter.java:30)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.mercury.optane.core.state.ServerStatusFilter.doFilter(ServerStatusFilter.java:33)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

at java.lang.Thread.run(Thread.java:619)

When run the system test from Lab manager, for ALM, PC Servers, & PC Hosts it completes without errors.

This happens when PC extension is enabled on the project.

Check the ENTITY_SUBTYPE_FIELDS table and verify if the ESTF_SUBTYPE_ID contains ‘PERFORMANCE-TEST’.

The error shows that it is trying to insert a duplicate entry which is the cause of failure.

To fix this issue follow the below steps

Select * from ENTITY_SUBTYPE_FIELDS where ESTF_SUBTYPE_ID = ‘PERFORMANCE-TEST’ run this query before enabling extension.

Steps:

1)Create a new QC project.

2)run the query above to verify.(If the entry is there try deleting that entry and proceed)

3)Enable extension on the project.

4)If it fails run the query again.

Might be a problem with the XML files in domsinfo. The steps above might help isolating this issue.

Advertisements

One thought on “Cannot Create a project, OLE Error 80040A29

  1. ash

    Hi, “This happens when PC extension is enabled on the project.” what kind of extension do you mean?

    I have similar error:

    Failed to create HP ALM project;
    Failed to create project ‘HRM’;
    Failed to create new project ‘HRM’;
    Maintenance task EnableExtensionsTask failed;
    Actual upgrade failed;
    Failed SQL: /* ~~QC */ CREATE UNIQUE NONCLUSTERED INDEX [LS_FATHER_NAME_LWR_IDX] ON [LISTS]([LS_FATHER_ID],[LS_NAME])
    [Mercury][SQLServer JDBC Driver][SQLServer]The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name ‘td.LISTS’ and the index name ‘LS_FATHER_NAME_LWR_IDX’. The duplicate key value is (0, ??).;

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s