Messages: Failed to Get Req Value; Failed to fetch data from REQ; Failed SQL: /*~~QC*/ SELECT RQ_ATTACHMENT,RQ_DEV_COMMENTS,RQ_FATHER_ID,RQ_FATHER_NAME,RQ_HAS_RICH_CONTENT,RQ_IS_FOLD ER,RQ_ISTEMPLATE,RQ_NO_OF_SONS,RQ_ORDER_ID,RQ_RBT_ANALYSIS_PARENT_REQ_ID,RQ_RBT_ANALYSIS_R ESULT_DATA,RQ_RBT_ANALYSIS_SETUP_DATA,RQ_RBT_ASSESSMENT_DATA,RQ_RBT_BSNS_IMPACT,RQ_RBT_CU STOM_BSNS_IMPACT,RQ_RBT_CUSTOM_FAIL_PROB,RQ_RBT_CUSTOM_TESTING_HOURS,RQ_RBT_CUSTOM_TESTI

coldwaterphewServers

Nov 17, 2013 (4 years and 1 month ago)

348 views

Messages:

Failed to Get Req Value;

Failed to fetch data from REQ;

Failed SQL: /*~~QC*/ SELECT
RQ_ATTACHMENT,RQ_DEV_COMMENTS,RQ_FATHER_ID,RQ_FATHER_NAME,RQ_HAS_RICH_CONTENT,RQ_IS_FOLD
ER,RQ_ISTEMPLATE,RQ_NO_OF_SONS,RQ_ORDER_ID,RQ_RBT_ANALYSIS_PARENT_REQ_ID,R
Q_RBT_ANALYSIS_R
ESULT_DATA,RQ_RBT_ANALYSIS_SETUP_DATA,RQ_RBT_ASSESSMENT_DATA,RQ_RBT_BSNS_IMPACT,RQ_RBT_CU
STOM_BSNS_IMPACT,RQ_RBT_CUSTOM_FAIL_PROB,RQ_RBT_CUSTOM_TESTING_HOURS,RQ_RBT_CUSTOM_TESTI
NG_LEVEL,RQ_RBT_EFFECTIVE_BSNS_IMPACT,RQ_RBT_EFFECTIVE_FAIL_PRO
B,RQ_RBT_FAIL_PROB,RQ_RBT_IGN
ORE_IN_ANALYSIS,RQ_RBT_LAST_ANALYSIS_DATE,RQ_RBT_RND_ESTIM_EFFORT_HOURS,RQ_RBT_TESTING_HOU
RS,RQ_RBT_TESTING_LEVEL,RQ_RBT_USE_CUSTOM_BSNS_IMPACT,RQ_RBT_USE_CUSTOM_FAIL_PROB,RQ_RBT_
USE_CUSTOM_TL_AND_TE,RQ_REQ_AUTHOR,RQ_REQ_COMMEN
T,RQ_REQ_DATE,RQ_REQ_ID,RQ_REQ_NAME,RQ
_REQ_PATH,RQ_REQ_PRIORITY,RQ_REQ_PRODUCT,RQ_REQ_REVIEWED,RQ_REQ_STATUS,RQ_REQ_TIME,RQ_RE
Q_TYPE,RQ_REQ_VER_STAMP,RQ_REQUEST_ASSIGN_TO,RQ_REQUEST_ID,RQ_REQUEST_NOTE,RQ_REQUEST_S
ERVER,RQ_REQUEST_STATUS,RQ_REQUEST_TYPE,RQ_
REQUEST_UPDATES,RQ_TARGET_RCYC,RQ_TARGET_REL
,RQ_TYPE_ID,RQ_VTS FROM REQ WHERE RQ_REQ_ID IN ( 0) ORDER BY RQ_ORDER_ID ASC

[Mercury][SQLServer JDBC Driver][SQLServer]Invalid column name 'RQ_FATHER_NAME'.;


Stack Trace:

java.sql.SQLException: Failed SQL: /*~
~QC*/ SELECT
RQ_ATTACHMENT,RQ_DEV_COMMENTS,RQ_FATHER_ID,RQ_FATHER_NAME,RQ_HAS_RICH_CONTENT,RQ_IS_FOLD
ER,RQ_ISTEMPLATE,RQ_NO_OF_SONS,RQ_ORDER_ID,RQ_RBT_ANALYSIS_PARENT_REQ_ID,RQ_RBT_ANALYSIS_R
ESULT_DATA,RQ_RBT_ANALYSIS_SETUP_DATA,RQ_RBT_ASSESSMENT_DATA,RQ_R
BT_BSNS_IMPACT,RQ_RBT_CU
STOM_BSNS_IMPACT,RQ_RBT_CUSTOM_FAIL_PROB,RQ_RBT_CUSTOM_TESTING_HOURS,RQ_RBT_CUSTOM_TESTI
NG_LEVEL,RQ_RBT_EFFECTIVE_BSNS_IMPACT,RQ_RBT_EFFECTIVE_FAIL_PROB,RQ_RBT_FAIL_PROB,RQ_RBT_IGN
ORE_IN_ANALYSIS,RQ_RBT_LAST_ANALYSIS_DATE,RQ_RBT_RND
_ESTIM_EFFORT_HOURS,RQ_RBT_TESTING_HOU
RS,RQ_RBT_TESTING_LEVEL,RQ_RBT_USE_CUSTOM_BSNS_IMPACT,RQ_RBT_USE_CUSTOM_FAIL_PROB,RQ_RBT_
USE_CUSTOM_TL_AND_TE,RQ_REQ_AUTHOR,RQ_REQ_COMMENT,RQ_REQ_DATE,RQ_REQ_ID,RQ_REQ_NAME,RQ
_REQ_PATH,RQ_REQ_PRIORITY,RQ_REQ_PRODUCT,RQ
_REQ_REVIEWED,RQ_REQ_STATUS,RQ_REQ_TIME,RQ_RE
Q_TYPE,RQ_REQ_VER_STAMP,RQ_REQUEST_ASSIGN_TO,RQ_REQUEST_ID,RQ_REQUEST_NOTE,RQ_REQUEST_S
ERVER,RQ_REQUEST_STATUS,RQ_REQUEST_TYPE,RQ_REQUEST_UPDATES,RQ_TARGET_RCYC,RQ_TARGET_REL
,RQ_TYPE_ID,RQ_VTS FROM REQ WHERE RQ_
REQ_ID IN ( 0) ORDER BY RQ_ORDER_ID ASC

[Mercury][SQLServer JDBC Driver][SQLServer]Invalid column name 'RQ_FATHER_NAME'.

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

at com.mercury.optane.core.db.C
TdPreparedStatement.executeQuery(CTdPreparedStatement.java:516)

at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:576)


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

at com.mercury.optane.core.db.spring.JDBCTemplate.
executeQuery(JDBCTemplate.java:582)

at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:466)

at com.mercury.td.appbase.getvalue.GetValueService.fetchData(GetValueService.java:934)

at com.mercury.td.appbase.getvalue.GetValueServ
ice.fetchEntities(GetValueService.java:886)


wrapped in com.mercury.optane.core.CTdException: Failed to fetch data from REQ

at com.mercury.td.appbase.getvalue.GetValueService.fetchEntities(GetValueService.java:893)

at com.mercury.td.appbase.getvalue.GetVal
ueService.getValue(GetValueService.java:174)

at com.mercury.td.tdserver.api.logics.CAbsBaseApiLogic.getValue(CAbsBaseApiLogic.java:1132)

at com.mercury.td.tdserver.api.logics.CAbsBaseApiLogic.getValue(CAbsBaseApiLogic.java:1144)

at com.mercury.td.tdserver.
api.logics.CRequirementLogic.getRequirementValue(CRequirementLogic.java:191)

at com.mercury.td.web.server.CTdServlet.redirectGetReqValue(CTdServlet.java:769)

at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAcc
essorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:554)


wrapped in com.mercury.optane.core.CTdException: Failed to Get Req
Value

at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:560)

at com.mercury.optane.core.web.CAbsServlet.processRequest(CAbsServlet.java:535)

at com.mercury.td.web.server.CTdServlet.processRequest(CTdServlet.java:320)

at com.mercur
y.optane.core.web.CAbsServlet.doPost(CAbsServlet.java:418)

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(A
pplicationFilterChain.java:252)

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.ApplicationFilter
Chain.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.catali
na.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.ap
ache.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 o
rg.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(PoolTcpEndpo
int.java:527)

at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)

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