Highlighted
Absent Member.
Absent Member.
443 views

BIG 10 POINTS - Problem when saving customized project entities in QC 9.2 Patch 26

Jump to solution
We just upgraded our server (Windows Server 2003, SQL Server 2005) and one of our customers is experiencing the following error:

Messages:
Failed to Set Project Customization Data;
Failed to set the meta data of project ttg::aoc_pmo;
Failed SQL: /* ~~QC */ CREATE FULLTEXT INDEX ON REQ(RQ_DEV_COMMENTS LANGUAGE 1033,RQ_REQ_COMMENT LANGUAGE 1033,RQ_REQ_NAME LANGUAGE 1033,RQ_TARGET_RCYC LANGUAGE 1033,RQ_TARGET_REL LANGUAGE 1033,RQ_USER_01 LANGUAGE 1033,RQ_USER_03 LANGUAGE 1033) KEY INDEX RQ_PRIMARYKEY
[Mercury][SQLServer JDBC Driver][SQLServer]Column 'RQ_TARGET_RCYC' cannot be used for full-text search because it is not a character-based, image, or varbinary(max) type column.;

Stack Trace:
java.sql.SQLException: Failed SQL: /* ~~QC */ CREATE FULLTEXT INDEX ON REQ(RQ_DEV_COMMENTS LANGUAGE 1033,RQ_REQ_COMMENT LANGUAGE 1033,RQ_REQ_NAME LANGUAGE 1033,RQ_TARGET_RCYC LANGUAGE 1033,RQ_TARGET_REL LANGUAGE 1033,RQ_USER_01 LANGUAGE 1033,RQ_USER_03 LANGUAGE 1033) KEY INDEX RQ_PRIMARYKEY
[Mercury][SQLServer JDBC Driver][SQLServer]Column 'RQ_TARGET_RCYC' cannot be used for full-text search because it is not a character-based, image, or varbinary(max) type column.
at com.mercury.optane.core.db.CAbsStatement.createSQLExceptionWithSQLStatement(CAbsStatement.java:110)
at com.mercury.optane.core.db.CTdPreparedStatement.execute(CTdPreparedStatement.java:850)
at com.mercury.optane.core.db.spring.JDBCTemplate.execute(JDBCTemplate.java:111)
wrapped in com.mercury.optane.core.db.CTdDbException:
at com.mercury.optane.core.db.spring.JDBCTemplate.execute(JDBCTemplate.java:116)
at com.mercury.optane.core.db.spring.JDBCTemplate.execute(JDBCTemplate.java:84)
at com.mercury.optane.core.db.spring.JDBCTemplate.execute(JDBCTemplate.java:74)
at com.mercury.td.appbase.textsearch.TextSearchSQLIndexCreator.createIndex(TextSearchSQLIndexCreator.java:105)
at com.mercury.td.appbase.textsearch.TextSearchIndexCreator.createIndexes(TextSearchIndexCreator.java:77)
at com.mercury.td.appbase.textsearch.TextSearchSQLIndexCreator.createIndexes(TextSearchSQLIndexCreator.java:59)
at com.mercury.td.tdserver.api.logics.search.TextSearchCustomizationListener.customizationChanged(TextSearchCustomizationListener.java:38)
at com.mercury.td.tdserver.customization.CCompoundCustomizationChangeListener.customizationChanged(CCompoundCustomizationChangeListener.java:43)
at com.mercury.td.tdserver.customization.CProjectMetaDataLogic.setMetaData(CProjectMetaDataLogic.java:732)
wrapped in com.mercury.optane.core.CTdException: Failed to set the meta data of project ttg::aoc_pmo
at com.mercury.td.tdserver.customization.CProjectMetaDataLogic.setMetaData(CProjectMetaDataLogic.java:753)
at com.mercury.td.tdserver.requests.SetProjectCustomizationData.execute(SetProjectCustomizationData.java:26)
at com.mercury.optane.core.web.RequestsDispatcher.execute(RequestsDispatcher.java:87)
wrapped in com.mercury.optane.core.CTdException: Failed to Set Project Customization Data
at com.mercury.optane.core.web.RequestsDispatcher.execute(RequestsDispatcher.java:93)
at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:555)
at com.mercury.optane.core.web.CAbsServlet.processRequest(CAbsServlet.java:547)
at com.mercury.td.web.server.CTdServlet.processRequest(CTdServlet.java:292)
at com.mercury.optane.core.web.CAbsServlet.doPost(CAbsServlet.java:431)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.hp.qc.core.utils.gzipfilter.GZIPFilter.doFilter(GZIPFilter.java:23)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:481)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
0 Likes
1 Solution

Accepted Solutions
Highlighted
Absent Member.
Absent Member.
Possibly need to uncheck "Searchable" for Target Cycle
Definitely need to open a ticket with support.

View solution in original post

4 Replies
Highlighted
Absent Member.
Absent Member.
Possibly need to uncheck "Searchable" for Target Cycle
Definitely need to open a ticket with support.

View solution in original post

Highlighted
Absent Member.
Absent Member.
a) Try to copy the project
b) search for "bad" chars in the table(s) by scrolling them in the siteadmin

Jo
Highlighted
Absent Member.
Absent Member.
I see you took my advice and upgraded your server?

Good job.
Highlighted
Absent Member.
Absent Member.
qcdev_kr, could you please provide more detail about how to accomplish what you are suggesting? Thanks.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.