Attempting to Edit or Update Poll Fails with Error: Failed to Perform Update Survey Operation
(Doc ID 1586599.1)
Last updated on NOVEMBER 01, 2022
Applies to:
Oracle WebCenter Portal - Version 11.1.1.7.0 to 11.1.1.8.8 [Release 11g]Information in this document applies to any platform.
Symptoms
When trying to Edit the Poll or complete the Poll or trying to save the Poll, the error shown in the browser is:
Failed to perform Update Survey operation. Check logs for more details.
The log file shows:
2013-08-28T11:53:12.142+08:00] [WC_Spaces] [WARNING] [] [oracle.webcenter.framework.service] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <USERID>] [ecid: <ECID>] [APP: webcenter#11.1.1.4.0] 2013-08-28 11:53:12.142--ServerSession(18183801)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException[[
Internal Exception: java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid column name '<COLUMN-NAME>'.
Error Code: 207
Call: SELECT RESPONSE_ID, ROW_OPTION, COLUMN_OPTION, feedback, IS_PUBLISHED, QUESTION_ID, RESPONSE_DATE, SURVEY_ID, USER_ID FROM WC_SURVEY_RESPONSE WHERE ((SURVEY_ID = ?) AND (QUESTION_ID = ?))
bind => [2 parameters bound]
Query: ReadAllQuery(name="<MIDDLEWARE-HOME>/user_projects/domains/<DOMAIN-NAME>/servers/WC_Spaces/tmp/_WL_user/oracle.webcenter.framework/2jjeu5/APP-INF/lib/survey-adapters-jpa.jar!/_survey-adapter-toplink" referenceClass=WcSurveyResponse sql="SELECT RESPONSE_ID, ROW_OPTION, COLUMN_OPTION, feedback, IS_PUBLISHED, QUESTION_ID, RESPONSE_DATE, SURVEY_ID, USER_ID FROM WC_SURVEY_RESPONSE WHERE ((SURVEY_ID = ?) AND (QUESTION_ID = ?))")
]]
[2013-08-28T11:53:12.146+08:00] [WC_Spaces] [WARNING] [] [oracle.webcenter.collab.survey.view.bean.EditSurveyBean] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <USERID>] [ecid: <ECID>] [APP: webcenter#11.1.1.4.0] Failed to perform Update Survey operation. Check logs for more details.
[2013-08-28T11:53:12.146+08:00] [WC_Spaces] [WARNING] [] [oracle.webcenter.collab.survey.view.bean.EditSurveyBean] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <USERID>] [ecid: <ECID>] [APP: webcenter#11.1.1.4.0] [[
oracle.webcenter.collab.survey.OperationFailedException: Failed to perform Update Survey operation. Check logs for more details.
at oracle.webcenter.collab.survey.internal.toplink.JPASurveySession._insertOrUpdateSurvey(JPASurveySession.java:969)
at oracle.webcenter.collab.survey.internal.toplink.JPASurveySession.updateSurvey(JPASurveySession.java:693)
at oracle.webcenter.collab.survey.ProxySurveySession.updateSurvey(ProxySurveySession.java:694)
at oracle.webcenter.collab.survey.view.bean.EditSurveyBean.save(EditSurveyBean.java:669)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sun.el.parser.AstValue.invoke(AstValue.java:187)
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)
at org.apache.myfaces.trinidad.component.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:46)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:10
Internal Exception: java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid column name '<COLUMN-NAME>'.
Error Code: 207
Call: SELECT RESPONSE_ID, ROW_OPTION, COLUMN_OPTION, feedback, IS_PUBLISHED, QUESTION_ID, RESPONSE_DATE, SURVEY_ID, USER_ID FROM WC_SURVEY_RESPONSE WHERE ((SURVEY_ID = ?) AND (QUESTION_ID = ?))
bind => [2 parameters bound]
Query: ReadAllQuery(name="<MIDDLEWARE-HOME>/user_projects/domains/<DOMAIN-NAME>/servers/WC_Spaces/tmp/_WL_user/oracle.webcenter.framework/2jjeu5/APP-INF/lib/survey-adapters-jpa.jar!/_survey-adapter-toplink" referenceClass=WcSurveyResponse sql="SELECT RESPONSE_ID, ROW_OPTION, COLUMN_OPTION, feedback, IS_PUBLISHED, QUESTION_ID, RESPONSE_DATE, SURVEY_ID, USER_ID FROM WC_SURVEY_RESPONSE WHERE ((SURVEY_ID = ?) AND (QUESTION_ID = ?))")
]]
[2013-08-28T11:53:12.146+08:00] [WC_Spaces] [WARNING] [] [oracle.webcenter.collab.survey.view.bean.EditSurveyBean] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <USERID>] [ecid: <ECID>] [APP: webcenter#11.1.1.4.0] Failed to perform Update Survey operation. Check logs for more details.
[2013-08-28T11:53:12.146+08:00] [WC_Spaces] [WARNING] [] [oracle.webcenter.collab.survey.view.bean.EditSurveyBean] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <USERID>] [ecid: <ECID>] [APP: webcenter#11.1.1.4.0] [[
oracle.webcenter.collab.survey.OperationFailedException: Failed to perform Update Survey operation. Check logs for more details.
at oracle.webcenter.collab.survey.internal.toplink.JPASurveySession._insertOrUpdateSurvey(JPASurveySession.java:969)
at oracle.webcenter.collab.survey.internal.toplink.JPASurveySession.updateSurvey(JPASurveySession.java:693)
at oracle.webcenter.collab.survey.ProxySurveySession.updateSurvey(ProxySurveySession.java:694)
at oracle.webcenter.collab.survey.view.bean.EditSurveyBean.save(EditSurveyBean.java:669)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sun.el.parser.AstValue.invoke(AstValue.java:187)
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)
at org.apache.myfaces.trinidad.component.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:46)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:10
Changes
The Database is MS SQL Database.
This issue does not occur on Oracle Database.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |