Support #11433: [SCP ID :##5678##] : java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended - Maybank RCAS Support - Penril Support System

Support #11433

[SCP ID :##5678##] : java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

Added by Zahir Abd Latif almost 4 years ago. Updated over 3 years ago.

Status:

Closed - End of life cycle

Start date:

December 14, 2020

Priority:

Normal

Due date:

Assignee:

Zahir Abd Latif

% Done:

100%

Category:

Spent time:

Target version:

Description

Hi,
Kindly attend below request:-

Please assist to check on dormant user checking task as we are getting below error in production server.

[12/5/20 2:12:38:758 MYT] 000000a7 AdminMaintena I ################### Process Start ###################
[12/5/20 2:12:38:759 MYT] 000000a7 AdminMaintena I ################### Update Inactive Internal User
[12/5/20 2:12:38:779 MYT] 000000a7 AdminMaintena E Error 5
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
 at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
 at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)
 at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
 at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1295)
 at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:836)
 at net.penril.cas.service.impl.BaseService.updateInactiveOrDormantUser(BaseService.java:187)
 at net.penril.cas.service.impl.AdminMaintenanceServiceImpl.UpdateDormantUserAccount(AdminMaintenanceServiceImpl.java:250)
 at net.penril.cas.service.EJSRemote0SLnet_penril_cas_service_AdminMain_ab35aced.UpdateDormantUserAccount(EJSRemote0SLnet_penril_cas_service_AdminMain_ab35aced.java)
 at net.penril.cas.service._AdminMaintenanceService_Stub.UpdateDormantUserAccount(_AdminMaintenanceService_Stub.java:1)
 at net.penril.rcas.servlet.TimeLoader.runDormantUserCheckingTask(TimeLoader.java:103)
 at net.penril.rcas.servlet.TimeLoader.runTask(TimeLoader.java:70)
 at net.penril.rcas.servlet.TimeLoader.start(TimeLoader.java:35)
 at net.penril.rcas.servlet.TimerManager.process(TimerManager.java:60)
 at net.penril.rcas.servlet.TimerManager.doGet(TimerManager.java:29)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:575)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
 at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1233)
 at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:782)
 at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481)
 at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
 at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1114)
 at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
 at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:949)
 at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
 at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
 at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
 at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
 at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
 at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
 at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1820)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:558)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:608)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:985)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1074)
 at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)

[12/5/20 2:12:38:790 MYT] 000000a7 AdminMaintena I ################### Update Inactive External User
[12/5/20 2:12:38:794 MYT] 000000a7 AdminMaintena E Error 5
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
 at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
 at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)
 at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
 at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1295)
 at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:836)
 at net.penril.cas.service.impl.BaseService.updateInactiveOrDormantUser(BaseService.java:187)
 at net.penril.cas.service.impl.AdminMaintenanceServiceImpl.UpdateDormantUserAccount(AdminMaintenanceServiceImpl.java:252)
 at net.penril.cas.service.EJSRemote0SLnet_penril_cas_service_AdminMain_ab35aced.UpdateDormantUserAccount(EJSRemote0SLnet_penril_cas_service_AdminMain_ab35aced.java)
 at net.penril.cas.service._AdminMaintenanceService_Stub.UpdateDormantUserAccount(_AdminMaintenanceService_Stub.java:1)
 at net.penril.rcas.servlet.TimeLoader.runDormantUserCheckingTask(TimeLoader.java:103)
 at net.penril.rcas.servlet.TimeLoader.runTask(TimeLoader.java:70)
 at net.penril.rcas.servlet.TimeLoader.start(TimeLoader.java:35)
 at net.penril.rcas.servlet.TimerManager.process(TimerManager.java:60)
 at net.penril.rcas.servlet.TimerManager.doGet(TimerManager.java:29)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:575)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
 at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1233)
 at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:782)
 at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481)
 at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
 at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1114)
 at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
 at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:949)
 at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
 at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
 at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
 at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
 at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
 at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
 at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1820)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:558)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:608)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:985)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1074)
 at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)

[12/5/20 2:12:38:795 MYT] 000000a7 AdminMaintena I ################### Update Dormant Internal User
[12/5/20 2:12:38:798 MYT] 000000a7 AdminMaintena E Error 5
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
 at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
 at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)
 at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
 at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1295)
 at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:836)
 at net.penril.cas.service.impl.BaseService.updateInactiveOrDormantUser(BaseService.java:187)
 at net.penril.cas.service.impl.AdminMaintenanceServiceImpl.UpdateDormantUserAccount(AdminMaintenanceServiceImpl.java:254)
 at net.penril.cas.service.EJSRemote0SLnet_penril_cas_service_AdminMain_ab35aced.UpdateDormantUserAccount(EJSRemote0SLnet_penril_cas_service_AdminMain_ab35aced.java)
 at net.penril.cas.service._AdminMaintenanceService_Stub.UpdateDormantUserAccount(_AdminMaintenanceService_Stub.java:1)
 at net.penril.rcas.servlet.TimeLoader.runDormantUserCheckingTask(TimeLoader.java:103)
 at net.penril.rcas.servlet.TimeLoader.runTask(TimeLoader.java:70)
 at net.penril.rcas.servlet.TimeLoader.start(TimeLoader.java:35)
 at net.penril.rcas.servlet.TimerManager.process(TimerManager.java:60)
 at net.penril.rcas.servlet.TimerManager.doGet(TimerManager.java:29)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:575)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
 at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1233)
 at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:782)
 at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481)
 at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
 at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1114)
 at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
 at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:949)
 at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
 at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
 at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
 at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
 at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
 at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
 at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1820)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:558)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:608)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:985)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1074)
 at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)

[12/5/20 2:12:38:799 MYT] 000000a7 AdminMaintena I ################### Update Dormant External User
[12/5/20 2:12:38:801 MYT] 000000a7 AdminMaintena E Error 5
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
 at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
 at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)
 at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
 at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1295)
 at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:836)
 at net.penril.cas.service.impl.BaseService.updateInactiveOrDormantUser(BaseService.java:187)
 at net.penril.cas.service.impl.AdminMaintenanceServiceImpl.UpdateDormantUserAccount(AdminMaintenanceServiceImpl.java:256)
 at net.penril.cas.service.EJSRemote0SLnet_penril_cas_service_AdminMain_ab35aced.UpdateDormantUserAccount(EJSRemote0SLnet_penril_cas_service_AdminMain_ab35aced.java)
 at net.penril.cas.service._AdminMaintenanceService_Stub.UpdateDormantUserAccount(_AdminMaintenanceService_Stub.java:1)
 at net.penril.rcas.servlet.TimeLoader.runDormantUserCheckingTask(TimeLoader.java:103)
 at net.penril.rcas.servlet.TimeLoader.runTask(TimeLoader.java:70)
 at net.penril.rcas.servlet.TimeLoader.start(TimeLoader.java:35)
 at net.penril.rcas.servlet.TimerManager.process(TimerManager.java:60)
 at net.penril.rcas.servlet.TimerManager.doGet(TimerManager.java:29)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:575)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
 at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1233)
 at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:782)
 at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481)
 at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
 at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1114)
 at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
 at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:949)
 at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
 at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
 at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
 at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
 at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
 at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
 at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1820)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:558)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:608)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:985)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1074)
 at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)

[12/5/20 2:12:38:803 MYT] 000000a7 AdminMaintena I ################### Update Password Expiry
[12/5/20 2:12:43:870 MYT] 000000a7 AdminMaintena I ################### Process End ###################
[12/5/20 2:12:43:884 MYT] 000000a7 TimeLoader I END DORMANT USER CHECKING TASK...
[12/5/20 2:12:43:885 MYT] 000000a7 TimeLoader I START EXCEPTION REPORT CLEAN UP TASK...

userlinking-synch-error.log (193 KB) Zahir Abd Latif, December 14, 2020 18:29

History

#1 Updated by Ngoh Chee Onn almost 4 years ago

Status changed from New - Begin Life Cycle to Pending Customer Feedback
% Done changed from 0 to 70

Hi All,

Fixed package had been delivery to Maybank Saadah, pending customer deploy and testing on the fixed package.

Thank you

#2 Updated by Ngoh Chee Onn over 3 years ago

Assignee changed from Ngoh Chee Onn to Zahir Abd Latif

Hi Zahir,

Since there is no response from customer, please ask to close this issue.

Thank you

#3 Updated by Nurul Akmal over 3 years ago

Status changed from Pending Customer Feedback to Closed - End of life cycle
% Done changed from 70 to 100

Issue closed in SCP.

Also available in: Atom PDF

B - Production Support » Maybank Support » Maybank RCAS Support