Support #11208
[SCP ID :##5507##] : statutory register cron error
| Status: | Work Completed-End life cycle | Start date: | September 03, 2020 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Siti Balqis Othman | % Done: | 100% | |
| Category: | BIB | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request:-
We notice below error at statutory register cron, please help to check. Sample file already given to balqis.
org.hibernate.util.JDBCExceptionReporter 2020-08-25 00:03:04,343****String or binary data would be truncated.
org.hibernate.event.def.AbstractFlushingEventListener 2020-08-25 00:03:04,343****Could not synchronize database state with session
org.hibernate.exception.DataException: could not insert: [net.penril.bib.core.BibLHDNRegEmployer]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:100)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2295)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2688)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at net.penril.bib.core.hibernate.BibLHDNRegEmployerDAOImpl.insertOrUpdateRegEmployer(BibLHDNRegEmployerDAOImpl.java:215)
at com.statutory.body.test.status.ProcessLhdnRegisteredEmployerInsertDBServices.main(ProcessLhdnRegisteredEmployerInsertDBServices.java:82)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoader.java:58)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2275)
... 17 more
net.penril.agrobank.statement.Estatement.EstatementCopyRawFile 2020-08-25 02:30:12,564****com.enterprisedt.net.ftp.FTPException: 550 The system cannot find the file specified.
net.penril.agrobank.statement.Estatement.EstatementCopyRawFile 2020-08-25 02:30:13,156****com.enterprisedt.net.ftp.FTPException: 550 The system cannot find the path specified.
History
#1
Updated by Siti Balqis Othman about 4 years ago
- Status changed from New - Begin Life Cycle to Investigation
- % Done changed from 0 to 70
#2
Updated by Siti Balqis Othman over 1 year ago
- Status changed from Investigation to Development / Work In Progress
#3
Updated by Siti Balqis Othman over 1 year ago
- Status changed from Development / Work In Progress to Work Completed-End life cycle
- % Done changed from 70 to 100
Response to Bank
Upon testing on the sample file, program unable to finish reading all the content due to empty line.
Kindly remove the empty new line between the list of company and retry.