My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.