My Oracle Support Banner

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

Last updated on FEBRUARY 25, 2021

Applies to:

Oracle Business Process Management Suite - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

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

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
Cause
Solution
References


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