findings.txt

19 & 22 Aug - Yap Kah Yan, August 26, 2016 11:28

Download (23.2 KB)

 
1
19/08/2016
2
4.30pm
3

    
4
App1 RIB_System.log.62
5
[2016-08-19 16:01:07,601 ERROR](com.ib.enterprise.services.ib101_access.IBGenericLoginServices) - Error details : org.hibernate.exception.LockAcquisitionException: could not execute update query
6
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
7
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
8
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 94) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
9
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
10
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
11
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
12
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
13
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
14
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
15
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
16
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
17
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
18
	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1156)
19
	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:797)
20
	at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:98)
21

    
22

    
23
App1 svr2 SystemOut_16.08.19_16.37.45
24
[8/19/16 16:01:07:601 SGT] 00000021 SystemOut     O [19/08/2016] [16:01:07:601] [ERROR] [IBGenericLoginServices]:527 - Error details : org.hibernate.exception.LockAcquisitionException: could not execute update query
25
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
26
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
27
	at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:107)
28
	at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:419)
29
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 94) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
30
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
31
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
32
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
33
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
34
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
35
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
36
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
37
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
38
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
39
	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1156)
40
	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:797)
41
	at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:98)
42

    
43

    
44
App2 RIB_System.log.211
45
[2016-08-19 16:28:37,810 ERROR](com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices) - Error details : java.lang.NumberFormatException: null
46
	at java.lang.Integer.parseInt(Integer.java:428)
47
	at java.lang.Integer.valueOf(Integer.java:565)
48
	at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
49
	at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
50

    
51
[2016-08-19 16:30:48,252 ERROR](com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices) - Error details : java.lang.NumberFormatException: null
52
	at java.lang.Integer.parseInt(Integer.java:428)
53
	at java.lang.Integer.valueOf(Integer.java:565)
54
	at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
55
	at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
56
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
57

    
58
App2 svr1 SystemErr_16.08.19_17.14.13
59
[8/19/16 16:41:09:959 SGT] 00000022 SystemErr     R org.hibernate.exception.LockAcquisitionException: could not insert: [net.penril.ibss.core.hibernate.IbUserTransactionHistory]
60
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
61
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
62
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 107) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
63
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
64
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
65
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
66
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
67
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
68
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
69
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
70
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
71
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
72
	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1156)
73
	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:797)
74
	at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46)
75
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2275)
76

    
77

    
78

    
79

    
80

    
81
====================================================================================================================================================================================
82
22/08/2016
83
2.43pm & 4:00pm - 4:30pm
84

    
85
App1 RIB_System.log.35
86
[2016-08-22 14:40:43,363 ERROR](com.ib.enterprise.services.ib101_access.IBGenericLoginServices) - Error details : org.hibernate.exception.LockAcquisitionException: could not execute update query
87
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
88
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
89
	at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:107)
90
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 118) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
91
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
92
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
93
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
94
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
95
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
96
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
97
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
98
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
99
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
100
	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1156)
101
	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:797)
102
	at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:98)
103

    
104
App2 svr2 SystemOut_16.08.22_15.02.50
105
[8/22/16 14:40:43:363 SGT] 00000056 SystemOut     O [22/08/2016] [14:40:43:363] [ERROR] [IBGenericLoginServices]:527 - Error details : org.hibernate.exception.LockAcquisitionException: could not execute update query
106
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
107
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
108
	at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:107)
109
	at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:419)
110
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 118) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
111
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
112
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
113
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
114
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
115
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
116
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
117
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
118
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
119
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
120
	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1156)
121
	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:797)
122
	at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:98)
123

    
124

    
125

    
126
App2  RIB_System.log.118
127
[2016-08-22 14:41:50,140 ERROR](com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices) - Error details : java.lang.NumberFormatException: null
128
	at java.lang.Integer.parseInt(Integer.java:428)
129
	at java.lang.Integer.valueOf(Integer.java:565)
130
	at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
131
	at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
132

    
133
App2  RIB_System.log.117
134
[2016-08-22 14:44:54,923 ERROR](com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices) - Error details : java.lang.NumberFormatException: null
135
	at java.lang.Integer.parseInt(Integer.java:428)
136
	at java.lang.Integer.valueOf(Integer.java:565)
137
	at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
138
	at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
139

    
140
App2  RIB_System.log.113
141
[2016-08-22 16:02:34,219 ERROR](com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices) - Error details : java.lang.NumberFormatException: null
142
	at java.lang.Integer.parseInt(Integer.java:428)
143
	at java.lang.Integer.valueOf(Integer.java:565)
144
	at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
145
	at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
146

    
147
[2016-08-22 16:05:22,124 ERROR](com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices) - Error details : java.lang.NumberFormatException: null
148
	at java.lang.Integer.parseInt(Integer.java:428)
149
	at java.lang.Integer.valueOf(Integer.java:565)
150
	at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
151
	at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
152

    
153
[2016-08-22 16:07:02,674 ERROR](com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices) - Error details : java.lang.NumberFormatException: null
154
	at java.lang.Integer.parseInt(Integer.java:428)
155
	at java.lang.Integer.valueOf(Integer.java:565)
156
	at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
157
	at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
158

    
159
App2  RIB_System.log.112
160
[2016-08-22 16:21:14,199 ERROR](com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices) - Error details : java.lang.NumberFormatException: null
161
	at java.lang.Integer.parseInt(Integer.java:428)
162
	at java.lang.Integer.valueOf(Integer.java:565)
163
	at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
164
	at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
165

    
166
[2016-08-22 16:22:46,545 ERROR](com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices) - Error details : java.lang.NumberFormatException: null
167
	at java.lang.Integer.parseInt(Integer.java:428)
168
	at java.lang.Integer.valueOf(Integer.java:565)
169
	at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
170
	at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
171

    
172

    
173
App2  svr1 SystemOut_16.08.22_14.48.16
174
[8/22/16 14:41:01:081 SGT] 00000059 SystemOut     O [22/08/2016] [14:41:01:081] [ERROR] [IBInterbankFundTransferConfirmServices]:527 - Error details : java.lang.NumberFormatException: null
175
	at java.lang.Integer.parseInt(Integer.java:428)
176
	at java.lang.Integer.valueOf(Integer.java:565)
177
	at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
178
	at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
179

    
180
[8/22/16 14:41:49:844 SGT] 00000044 SystemOut     O [22/08/2016] [14:41:49:844] [ERROR] [IBInterbankFundTransferConfirmServices]:527 - Error details : java.lang.NumberFormatException: null
181
	at java.lang.Integer.parseInt(Integer.java:428)
182
	at java.lang.Integer.valueOf(Integer.java:565)
183
	at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
184
	at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
185

    
186
[8/22/16 14:44:54:923 SGT] 00000045 SystemOut     O [22/08/2016] [14:44:54:923] [ERROR] [IBInterbankFundTransferConfirmServices]:527 - Error details : java.lang.NumberFormatException: null
187
	at java.lang.Integer.parseInt(Integer.java:428)
188
	at java.lang.Integer.valueOf(Integer.java:565)
189
	at com.ib.enterprise.services.ib104_fundtransfer.interbank.transfer.IBInterbankFundTransferConfirmServices.execute(IBInterbankFundTransferConfirmServices.java:148)
190
	at com.ib.rib.controller.actions.ib104_fundtransfer.interbank.transfer.IBInterbankTransferConfirmAction.execute(IBInterbankTransferConfirmAction.java:133)
191

    
192
[8/22/16 14:39:40:090 SGT] 0000006f SystemOut     O [22/08/2016] [14:39:40:090] [ERROR] [IBGenericLoginServices]:527 - Error details : org.hibernate.exception.LockAcquisitionException: could not retrieve snapshot: [net.penril.ibss.core.hibernate.IbCustAccounts#component[accountNumber,userId]{userId=40534, accountNumber=1007021000062252}]
193
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
194
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
195
	at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnapshot(AbstractEntityPersister.java:1075)
196
	at org.hibernate.engine.StatefulPersistenceContext.getDatabaseSnapshot(StatefulPersistenceContext.java:269)
197
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 111) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
198
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
199
	at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:4762)
200
	at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1682)
201
	at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:955)
202
	at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet.java:3120)
203
	at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnapshot(AbstractEntityPersister.java:1051)
204

    
205

    
206
App2  svr1 SystemOut_16.08.22_16.14.06
207
[8/22/16 16:11:10:887 SGT] 00000060 SystemOut     O [22/08/2016] [16:11:10:887] [ERROR] [JDBCExceptionReporter]:101 - Transaction (Process ID 67) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
208
[8/22/16 16:11:10:887 SGT] 00000060 SystemOut     O [22/08/2016] [16:11:10:887] [ERROR] [JDBCExceptionReporter]:101 - Transaction (Process ID 67) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
209
[8/22/16 16:11:10:902 SGT] 00000060 SystemOut     O [22/08/2016] [16:11:10:902] [ERROR] [IBGenericLoginServices]:527 - Error code : 9999
210
[8/22/16 16:11:10:902 SGT] 00000060 SystemOut     O [22/08/2016] [16:11:10:902] [ERROR] [IBGenericLoginServices]:527 - Error details : org.hibernate.exception.LockAcquisitionException: could not execute update query
211
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
212
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 67) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
213
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
214
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
215
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
216
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
217
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
218
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
219
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
220
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
221
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:308)
222
	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1156)
223
	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:797)
224
	at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:98)
225

    
226

    
227
[8/22/16 16:17:24:036 SGT] 00000060 SystemOut     O Socket input data (in Hex): [22/08/2016] [16:17:24:052] [ERROR] [JDBCExceptionReporter]:101 - Transaction (Process ID 99) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
228
[8/22/16 16:17:24:052 SGT] 0000006f SystemOut     O [22/08/2016] [16:17:24:052] [ERROR] [JDBCExceptionReporter]:101 - Transaction (Process ID 99) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
229
[8/22/16 16:17:24:067 SGT] 0000006f SystemOut     O [22/08/2016] [16:17:24:067] [ERROR] [IBGenericLoginServices]:527 - Error code : 9999
230
[8/22/16 16:17:24:067 SGT] 0000006f SystemOut     O [22/08/2016] [16:17:24:067] [ERROR] [IBGenericLoginServices]:527 - Error details : org.hibernate.exception.LockAcquisitionException: could not retrieve snapshot: [net.penril.ibss.core.hibernate.IbCustAccounts#component[accountNumber,userId]{userId=60191, accountNumber=2007201000094725}]
231
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
232
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
233
	at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnapshot(AbstractEntityPersister.java
234
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 99) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
235
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
236
	at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:4762)
237
	at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1682)
238
	at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:955)
239
	at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet.java:3120)
240
	at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnapshot(AbstractEntityPersister.java:1051)