My Oracle Support Banner

Check Syntax for PLC fails after upgrading OFSAAI to 8.0.6 (Doc ID 2474879.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.6 and later
Information in this document applies to any platform.

Symptoms

Post upgrading OFSAAI to 8.0.6.0.0, when user checked syntax for PLC, it failed with error '[4496] Syntax Checking failed'.

OFSAA.log has below exception

[09-10-18 11:53:29,334 MST AM] [INFO ] [WEB] [C1630608] [DMT] [ProcedureCreation]~[compileProcedure]~Exception compiling procedure

java.sql.SQLException: Could not execute sql command - Original message: ORA-00972: identifier is too long

at com.ofs.aai.database.OFSAAPreparedStatementDecorator.executeUpdate(OFSAAPreparedStatementDecorator.java:895) ~[aai-core.jar:?]

at com.ofs.aai.service.dmt.plc.utility.ProcedureCreation.compileProcedure(ProcedureCreation.java:1324) [aai-dmt-service.jar:?]

at com.ofs.aai.service.dmt.plc.utility.ProcedureCreation.createDTProcedure(ProcedureCreation.java:1215) [aai-dmt-service.jar:?]

at com.ofs.aai.service.dmt.plc.utility.ProcedureCreation.createProcedure(ProcedureCreation.java:160) [aai-dmt-service.jar:?]

at com.ofs.aai.service.dmt.client.DMTClient.createProcedure(DMTClient.java:4319) [aai-dmt-service.jar:?]

at com.ofs.aai.service.web.PLCHandlerImpl.checkSyntax(PLCHandlerImpl.java:1398) [aai-web.jar:?]

at com.ofs.aai.service.web.PLCHandlerImpl.handleRequest(PLCHandlerImpl.java:165) [aai-web.jar:?]

at com.ofs.aai.service.web.DMTServiceImpl.provideService(DMTServiceImpl.java:56) [aai-web.jar:?]

at com.ofs.aai.service.web.OFSAAController.handleRequest(OFSAAController.java:97) [aai-web.jar:?]

at com.ofs.aai.service.web.OFSAAController.doPost(OFSAAController.java:129) [aai-web.jar:?]

at javax.servlet.http.HttpServlet.service(HttpServlet.java:751) [weblogic.server.merged.jar:12.1.3.0.0]

at javax.servlet.http.HttpServlet.service(HttpServlet.java:844) [weblogic.server.merged.jar:12.1.3.0.0]

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280) [weblogic.server.merged.jar:12.1.3.0.0]

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254) [weblogic.server.merged.jar:12.1.3.0.0]

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136) [weblogic.server.merged.jar:12.1.3.0.0]

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346) [weblogic.server.merged.jar:12.1.3.0.0]

at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25) [weblogic.server.merged.jar:12.1.3.0.0]

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) [weblogic.server.merged.jar:12.1.3.0.0]

at com.iflex.fic.filters.FilterServlet.doFilter(FilterServlet.java:1071) [FICServer.jar:?]

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) [weblogic.server.merged.jar:12.1.3.0.0]

at com.iflex.fic.filters.EncodingFilter.doFilter(EncodingFilter.java:105) [FICFilters.jar:?]

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) [weblogic.server.merged.jar:12.1.3.0.0]

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3451) [weblogic.server.merged.jar:12.1.3.0.0]

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3417) [weblogic.server.merged.jar:12.1.3.0.0]

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) [weblogic.server.merged.jar:12.1.3.0.0]

at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) [com.oracle.css.weblogic.security.wls_7.1.0.0.jar:CSS 7.1 0.0]

at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57) [weblogic.server.merged.jar:12.1.3.0.0]

at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2280) [weblogic.server.merged.jar:12.1.3.0.0]

at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2196) [weblogic.server.merged.jar:12.1.3.0.0]

at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174) [weblogic.server.merged.jar:12.1.3.0.0]

at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1632) [weblogic.server.merged.jar:12.1.3.0.0]

at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:256) [weblogic.server.merged.jar:12.1.3.0.0]

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311) [weblogic.server.merged.jar:12.1.3.0.0]

at weblogic.work.ExecuteThread.run(ExecuteThread.java:263) [weblogic.server.merged.jar:12.1.3.0.0]

Caused by: java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc7.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc7.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) ~[ojdbc7.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) ~[ojdbc7.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) ~[ojdbc7.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) ~[ojdbc7.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) ~[ojdbc7.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) ~[ojdbc7.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943) ~[ojdbc7.jar:12.1.0.2.0]

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) ~[ojdbc7.jar:12.1.0.2.0]

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) ~[ojdbc7.jar:12.1.0.2.0]

at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4875) ~[ojdbc7.jar:12.1.0.2.0]

at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1361) ~[ojdbc7.jar:12.1.0.2.0]

at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:178) ~[weblogic.server.merged.jar:12.1.3.0.0]

at sun.reflect.GeneratedMethodAccessor163.invoke(Unknown Source) ~[?:?]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_80-ea]

at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_80-ea]

at com.ofs.aai.database.OFSAAPreparedStatementDecorator.logAndExecuteQuery(OFSAAPreparedStatementDecorator.java:167) ~[aai-core.jar:?]

at com.ofs.aai.database.OFSAAPreparedStatementDecorator.executeUpdate(OFSAAPreparedStatementDecorator.java:892) ~[aai-core.jar:?]

 




Changes

 Upgrade OFSAAI to 8.0.6.0.0.

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


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