Attempting to Edit or Update Poll Fails with Error: Failed to Perform Update Survey Operation (Doc ID 1586599.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle WebCenter Portal - Version 11.1.1.7.0 and later
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: webcenter1] [ecid: 0000K333RmVDOdWFLzBT8A1I2SUb0007Qb,0] [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 'feedback'.
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="zip:D:/Oracle/Middleware/user_projects/domains/citysuper_domain/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: webcenter1] [ecid: 0000K333RmVDOdWFLzBT8A1I2SUb0007Qb,0] [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: webcenter1] [ecid: 0000K333RmVDOdWFLzBT8A1I2SUb0007Qb,0] [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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms