FREVVO: CANNOT CREATE WEBFORMS IN INTEGRATED JDEV SVR (Doc ID 2755132.1)

Last updated on NOVEMBER 16, 2023

Applies to:

Symptoms

error 500 occurs when trying to create web forms in BPM Composer in JDeveloper Integrated Server.

Error in log:

<org.apache.myfaces.trinidadinternal.context.RequestContextImpl> <RequestContextImpl> <addPartialTriggerListeners> <Could not find partial trigger roleFilter from RichTable[org.apache.myfaces.trinidad.component.UIXTable$RowKeyFacesBeanWrapper@59e98cec, id=roleMappingTable] with the supported partialTriggers syntax. The partial trigger was found with the deprecated syntax. Please use the supported syntax.>
<org.apache.myfaces.trinidadinternal.context.RequestContextImpl> <RequestContextImpl> <addPartialTriggerListeners> <Could not find partial trigger showDoc_cb from RichTable[org.apache.myfaces.trinidad.component.UIXTable$RowKeyFacesBeanWrapper@410e590d, id=t1NarrativeActivityTable] with the supported partialTriggers syntax. The partial trigger was found with the deprecated syntax. Please use the supported syntax.>
<org.apache.myfaces.trinidadinternal.context.RequestContextImpl> <RequestContextImpl> <addPartialTriggerListeners> <Could not find partial trigger redoButton from RichTable[org.apache.myfaces.trinidad.component.UIXTable$RowKeyFacesBeanWrapper@410e590d, id=t1NarrativeActivityTable] with the supported partialTriggers syntax. The partial trigger was found with the deprecated syntax. Please use the supported syntax.>
<org.apache.myfaces.trinidadinternal.context.RequestContextImpl> <RequestContextImpl> <addPartialTriggerListeners> <Could not find partial trigger undoButton from RichTable[org.apache.myfaces.trinidad.component.UIXTable$RowKeyFacesBeanWrapper@410e590d, id=t1NarrativeActivityTable] with the supported partialTriggers syntax. The partial trigger was found with the deprecated syntax. Please use the supported syntax.>
<org.apache.myfaces.trinidadinternal.context.RequestContextImpl> <RequestContextImpl> <addPartialTriggerListeners> <Could not find partial trigger ::properties:artifactDisplayName from RichTree[org.apache.myfaces.trinidad.component.UIXTree$RowKeyFacesBeanWrapper@79d59ae8, id=fpTree] with the supported partialTriggers syntax. The partial trigger was found with the deprecated syntax. Please use the supported syntax.>
Inside toFrevvoURL Client's Offset is : 120.0
h = 2 : m = 0
GMT+2:00
Inside toFrevvoURL Client's Offset is : 120.0
h = 2 : m = 0
GMT+2:00
<org.hibernate.util.JDBCExceptionReporter> <JDBCExceptionReporter> <logExceptions> <SQL Error: 20000, SQLState: 42X01>
<org.hibernate.util.JDBCExceptionReporter> <JDBCExceptionReporter> <logExceptions> <Syntax error: Encountered "where" at line 1, column 278.>
<com.gauss.forms.web.ApplicationContainer> <ApplicationContainer> <service> <Application Error>
javax.servlet.ServletException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
at com.gauss.forms.service.f.a(SourceFile:522)
at com.gauss.forms.service.f.a(SourceFile:296)
at com.gauss.forms.web.bP.a(SourceFile:1003)
at com.gauss.forms.web.bS.handle(SourceFile:396)
at com.gauss.forms.core.r.doHandle(SourceFile:31)
at com.gauss.forms.core.M.doHandle(SourceFile:66)
at com.gauss.forms.web.bP.doHandle(SourceFile:978)
at com.gauss.forms.core.M.handle(SourceFile:54)
at com.gauss.forms.core.q.handle(SourceFile:40)
at com.gauss.forms.web.eC.handle(SourceFile:196)
at com.gauss.forms.core.q.handle(SourceFile:40)
at com.gauss.forms.web.aw.handle(SourceFile:80)
at com.gauss.forms.core.q.handle(SourceFile:40)

....

at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1215)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1148)
at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:307)
at com.gauss.forms.submission.service.FormSubmissionService.getNextFormTypeVersion(SourceFile:146)
at com.gauss.forms.service.g.execute(SourceFile:506)
at com.gauss.forms.submission.service.EntityTransactionScope.<init>(SourceFile:12)
at com.gauss.forms.service.g.<init>(SourceFile:497)
at com.gauss.forms.service.f.a(SourceFile:497)
... 106 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2536)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:274)
... 111 more
Caused by: java.sql.SQLSyntaxErrorException: Syntax error: Encountered "where" at line 1, column 278.
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.ClientConnection.prepareStatement(Unknown Source)
at org.apache.derby.client.am.LogicalConnection.prepareStatement(Unknown Source)
at weblogic.jdbc.wrapper.XAConnection.prepareStatement(XAConnection.java:658)
at weblogic.jdbc.common.internal.ConnectionEnv.makeStatement(ConnectionEnv.java:2220)
at weblogic.jdbc.common.internal.ConnectionEnv.getCachedStatement(ConnectionEnv.java:1916)
at weblogic.jdbc.common.internal.ConnectionEnv.getCachedStatement(ConnectionEnv.java:1830)
at weblogic.jdbc.common.internal.ConnectionEnv.getCachedStatement(ConnectionEnv.java:1823)
at weblogic.jdbc.wrapper.Connection.prepareStatement(Connection.java:660)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
at org.hibernate.loader.Loader.doQuery(Loader.java:801)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2533)
... 119 more
Caused by: ERROR 42X01: Syntax error: Encountered "where" at line 1, column 278.
at org.apache.derby.client.am.ClientStatement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
at org.apache.derby.client.am.ClientStatement.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.am.ClientPreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.ClientPreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.ClientPreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.ClientConnection.prepareStatementX(Unknown Source)
... 134 more

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.