1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
| #14 2019-08-20 13:45:06,287 Common.DLL OracleHelper.ExecuteReader ORA-12571: TNS:packet writer failure
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #9 2019-08-20 14:51:22,416 Common.DLL OracleHelper.ExecuteReader ORA-01722: invalid number
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #9 2019-08-20 14:51:22,429 Dao.DLL GwSmDao.LoadInfoList ORA-01722: invalid numberselect count(*) as count from LG_SM_20190820 where 1=1 and AP_ID=:ApID and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex)
|
| #14 2019-08-20 14:51:25,423 Common.DLL OracleHelper.ExecuteReader ORA-01722: invalid number
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #14 2019-08-20 14:51:25,428 Dao.DLL GwSmDao.LoadInfoList ORA-01722: invalid numberselect count(*) as count from LG_SM_20190820 where 1=1 and AP_ID=:ApID and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex)
|
| #8 2019-08-20 14:51:25,905 Common.DLL OracleHelper.ExecuteReader ORA-01722: invalid number
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #8 2019-08-20 14:51:25,908 Dao.DLL GwSmDao.LoadInfoList ORA-01722: invalid numberselect count(*) as count from LG_SM_20190820 where 1=1 and AP_ID=:ApID and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex)
|
| #12 2019-08-20 16:16:51,964 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #12 2019-08-20 16:16:51,979 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 0) where r > 0
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ376
|
| #8 2019-08-20 16:16:57,245 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #8 2019-08-20 16:16:57,248 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ376
|
| #13 2019-08-20 16:16:59,480 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #13 2019-08-20 16:16:59,484 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ376
|
| #5 2019-08-20 16:17:00,085 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #5 2019-08-20 16:17:00,089 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ376
|
| #9 2019-08-20 16:17:00,592 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #9 2019-08-20 16:17:00,597 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ376
|
| #5 2019-08-20 16:17:01,170 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #5 2019-08-20 16:17:01,182 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ376
|
| #8 2019-08-20 16:17:11,696 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #8 2019-08-20 16:17:11,703 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ376
|
| #9 2019-08-20 16:17:19,648 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #9 2019-08-20 16:17:19,653 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ376
|
| #8 2019-08-20 16:17:20,224 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #8 2019-08-20 16:17:20,227 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ376
|
| #8 2019-08-20 16:17:20,433 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #8 2019-08-20 16:17:20,436 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ376
|
| #9 2019-08-20 16:17:41,580 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #9 2019-08-20 16:17:41,584 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 0) where r > 0
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ376
|
| #5 2019-08-20 16:17:46,254 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #5 2019-08-20 16:17:46,259 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ376
|
| #8 2019-08-20 16:17:54,820 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #8 2019-08-20 16:17:54,824 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ376
|
| #13 2019-08-20 16:19:42,222 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #13 2019-08-20 16:22:27,363 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ376
|
| #14 2019-08-21 16:03:22,734 Common.DLL OracleHelper.Execute SQL=select * from (select rownum r,t.* from (SELECT op.op_name,ca.SP_ID,ca.OP_ID,ca.MSG_CONTENT,ca.KEYWORD,ca.HASH_CODE,COUNT(*) CNT FROM GW_AUDIT_CACHE ca left join gw_op op on ca.op_id=op.op_id WHERE ca.AP_SUBMIT_TIME BETWEEN :START_TIME AND :END_TIME AND (ca.MSG_CONTENT LIKE :CONTENT OR :CONTENT='%%') AND ca.AUDITING_STATUS=:AUDITING_STATUS
| GROUP BY ca.SP_ID,ca.OP_ID,ca.MSG_CONTENT,ca.KEYWORD,ca.HASH_CODE) t where rownum <=1) where r > 0 Message=ORA-00979: not a GROUP BY expression
|
| #14 2019-08-21 16:03:24,584 Common.DLL OracleHelper.Execute SQL=select * from (select rownum r,t.* from (SELECT op.op_name,ca.SP_ID,ca.OP_ID,ca.MSG_CONTENT,ca.KEYWORD,ca.HASH_CODE,COUNT(*) CNT FROM GW_AUDIT_CACHE ca left join gw_op op on ca.op_id=op.op_id WHERE ca.AP_SUBMIT_TIME BETWEEN :START_TIME AND :END_TIME AND (ca.MSG_CONTENT LIKE :CONTENT OR :CONTENT='%%') AND ca.AUDITING_STATUS=:AUDITING_STATUS
| GROUP BY ca.SP_ID,ca.OP_ID,ca.MSG_CONTENT,ca.KEYWORD,ca.HASH_CODE) t where rownum <=1) where r > 0 Message=ORA-00979: not a GROUP BY expression
|
| #14 2019-08-21 17:41:41,439 Common.DLL OracleHelper.ExecuteReader ORA-12571: TNS:packet writer failure
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #4 2019-09-10 11:12:33,228 Common.DLL OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
| (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
| NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
| NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
| from LG_SM_20190910 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-12571: TNS:packet writer failure
|
| #4 2019-09-10 11:13:03,726 Dao.DLL GwSmDao.LoadInfoList ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
| ÔÚ Oracle.DataAccess.Client.OracleConnection.Open()
| ÔÚ Common.OracleHelper.PrepareConnection()
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ368
|
| #4 2019-09-10 11:13:04,780 Dao.DLL GwSmDao.LoadInfoList ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
| ÔÚ Oracle.DataAccess.Client.OracleConnection.Open()
| ÔÚ Common.OracleHelper.PrepareConnection()
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ368
|
| #5 2019-09-10 11:13:05,507 Dao.DLL GwSmDao.LoadInfoList ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
| ÔÚ Oracle.DataAccess.Client.OracleConnection.Open()
| ÔÚ Common.OracleHelper.PrepareConnection()
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ368
|
| #5 2019-09-10 11:13:06,135 Dao.DLL GwSmDao.LoadInfoList ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
| ÔÚ Oracle.DataAccess.Client.OracleConnection.Open()
| ÔÚ Common.OracleHelper.PrepareConnection()
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ368
|
| #12 2019-09-10 11:33:32,386 Common.DLL OracleHelper.ExecuteScalar SQL=select count(1) FROM GW_AUDIT_CACHE ca left join gw_op op on ca.op_id=op.op_id WHERE ca.AP_SUBMIT_TIME BETWEEN :START_TIME AND :END_TIME AND (ca.MSG_CONTENT LIKE :CONTENT OR :CONTENT='%%') AND ca.AUDITING_STATUS=:AUDITING_STATUS
| Message=ORA-12571: TNS:packet writer failure
|
| #14 2019-09-10 11:40:15,711 Common.DLL OracleHelper.ExecuteReader ORA-01722: invalid number
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #14 2019-09-10 11:40:15,717 Dao.DLL GwSmDao.LoadInfoListcount ORA-01722: invalid numberselect count(*) as count from LG_SM_20190910 where 1=1 and AP_ID=:ApID and OP_ID=:OpID and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoListcount(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ160
|
| #14 2019-09-10 11:40:15,734 Common.DLL OracleHelper.Execute SQL=select * from (select rownum r,t.* from (select AP_MID,CLIENT_ID,SP_ID,AP_ID,OP_ID,ACCESS_CODE,MOBILE,PK_NUMBER,AP_FEE_COUNT,OP_FEE_COUNT,TPUDHI,PRIORITY,RD_FLAG,MSG_FORMAT,MSG_LENGTH,AP_RESULT,OP_MID,OP_RESULT,AP_SUBMIT_TIME,OP_SUBMIT_TIME,OP_DELIVER_TIME,MSG_CONTENT,STAT from LG_SM_20190910 where 1=1 and AP_ID=:ApID and OP_ID=:OpID and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME) t where rownum <= 100000) Message=ORA-01722: invalid number
|
| #5 2019-09-20 15:47:37,022 Common.DLL OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
| (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
| NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
| NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
| from LG_SM_20190920 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: table or view does not exist
|
| #13 2019-09-20 15:56:52,984 Common.DLL OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
| (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
| NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
| NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
| from LG_SM_20190920 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: table or view does not exist
|
| #10 2019-10-14 17:41:49,731 Common.DLL OracleHelper.ExecuteReader ORA-00918: column ambiguously defined
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #10 2019-10-14 17:41:49,751 Dao.DLL GwSmDao.LoadInfoListcount ORA-00918: column ambiguously definedselect * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20191014 a left join gw_op b on a.op_id=b.op_id where 1=1 and b.OP_Name LIKE :OpName and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 0)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ197
|
| #10 2019-10-14 17:41:49,791 Common.DLL OracleHelper.Execute SQL=select * from (select rownum r,t.* from (select AP_MID,CLIENT_ID,SP_ID,AP_ID,a.OP_ID,ACCESS_CODE,MOBILE,PK_NUMBER,AP_FEE_COUNT,OP_FEE_COUNT,TPUDHI,PRIORITY,RD_FLAG,MSG_FORMAT,MSG_LENGTH,AP_RESULT,OP_MID,OP_RESULT,AP_SUBMIT_TIME,OP_SUBMIT_TIME,OP_DELIVER_TIME,MSG_CONTENT,STAT,b.op_name from LG_SM_20191014 a left join gw_op on a.op_id=b.op_id where 1=1 and b.OP_NAME LIKE :OpName and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME) t where rownum <= 100000) Message=ORA-00904: "B"."OP_ID": invalid identifier
|
| #12 2019-10-14 17:43:25,328 Common.DLL OracleHelper.ExecuteReader ORA-00918: column ambiguously defined
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #12 2019-10-14 17:43:25,337 Dao.DLL GwSmDao.LoadInfoListcount ORA-00918: column ambiguously definedselect * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20191014 a left join gw_op b on a.op_id=b.op_id where 1=1 and b.OP_Name LIKE :OpName and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 0)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ197
|
| #12 2019-10-14 17:43:25,365 Common.DLL OracleHelper.Execute SQL=select * from (select rownum r,t.* from (select AP_MID,CLIENT_ID,SP_ID,AP_ID,a.OP_ID,ACCESS_CODE,MOBILE,PK_NUMBER,AP_FEE_COUNT,OP_FEE_COUNT,TPUDHI,PRIORITY,RD_FLAG,MSG_FORMAT,MSG_LENGTH,AP_RESULT,OP_MID,OP_RESULT,AP_SUBMIT_TIME,OP_SUBMIT_TIME,OP_DELIVER_TIME,MSG_CONTENT,STAT,b.op_name from LG_SM_20191014 a left join gw_op on a.op_id=b.op_id where 1=1 and b.OP_NAME LIKE :OpName and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME) t where rownum <= 100000) Message=ORA-00904: "B"."OP_ID": invalid identifier
|
| #5 2019-10-14 17:43:44,224 Common.DLL OracleHelper.ExecuteReader ORA-00918: column ambiguously defined
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #5 2019-10-14 17:43:44,239 Dao.DLL GwSmDao.LoadInfoListcount ORA-00918: column ambiguously definedselect * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20191014 a left join gw_op b on a.op_id=b.op_id where 1=1 and b.OP_Name LIKE :OpName and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 0)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ197
|
| #5 2019-10-14 17:45:54,786 Common.DLL OracleHelper.Execute SQL=select * from (select rownum r,t.* from (select AP_MID,CLIENT_ID,SP_ID,AP_ID,a.OP_ID,ACCESS_CODE,MOBILE,PK_NUMBER,AP_FEE_COUNT,OP_FEE_COUNT,TPUDHI,PRIORITY,RD_FLAG,MSG_FORMAT,MSG_LENGTH,AP_RESULT,OP_MID,OP_RESULT,AP_SUBMIT_TIME,OP_SUBMIT_TIME,OP_DELIVER_TIME,MSG_CONTENT,STAT,b.op_name from LG_SM_20191014 a left join gw_op on a.op_id=b.op_id where 1=1 and b.OP_NAME LIKE :OpName and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME) t where rownum <= 100000) Message=ORA-00904: "B"."OP_ID": invalid identifier
|
| #10 2019-10-14 17:47:34,151 Common.DLL OracleHelper.ExecuteReader ORA-00918: column ambiguously defined
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #10 2019-10-14 17:47:34,174 Dao.DLL GwSmDao.LoadInfoListcount ORA-00918: column ambiguously definedselect * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20191014 a left join gw_op b on a.op_id=b.op_id where 1=1 and b.OP_Name LIKE :OpName and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 0)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ197
|
| #10 2019-10-14 17:47:34,203 Common.DLL OracleHelper.Execute SQL=select * from (select rownum r,t.* from (select AP_MID,CLIENT_ID,a.SP_ID,AP_ID,a.OP_ID,a.ACCESS_CODE,MOBILE,PK_NUMBER,AP_FEE_COUNT,OP_FEE_COUNT,TPUDHI,a.PRIORITY,RD_FLAG,a.MSG_FORMAT,MSG_LENGTH,AP_RESULT,OP_MID,OP_RESULT,AP_SUBMIT_TIME,OP_SUBMIT_TIME,OP_DELIVER_TIME,MSG_CONTENT,STAT,b.op_name from LG_SM_20191014 a left join gw_op on a.op_id=b.op_id where 1=1 and b.OP_NAME LIKE :OpName and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME) t where rownum <= 100000) Message=ORA-00904: "B"."OP_ID": invalid identifier
|
| #12 2019-10-14 17:49:12,645 Common.DLL OracleHelper.ExecuteReader ORA-00918: column ambiguously defined
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #12 2019-10-14 17:49:12,662 Dao.DLL GwSmDao.LoadInfoListcount ORA-00918: column ambiguously definedselect * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20191014 a left join gw_op b on a.op_id=b.op_id where 1=1 and b.OP_Name LIKE :OpName and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 0)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ197
|
| #10 2019-10-14 17:49:21,425 Common.DLL OracleHelper.ExecuteReader ORA-00918: column ambiguously defined
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #10 2019-10-14 17:49:21,435 Dao.DLL GwSmDao.LoadInfoListcount ORA-00918: column ambiguously definedselect * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20191014 a left join gw_op b on a.op_id=b.op_id where 1=1 and b.OP_Name LIKE :OpName and MOBILE=:DestnationId and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 0)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ197
|
| #13 2020-03-04 10:33:03,802 Common.DLL OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
| (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
| NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
| NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
| from LG_SM_20200304 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: table or view does not exist
|
| #11 2020-03-11 10:50:58,862 Common.DLL OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: end-of-file on communication channel
| Process ID: 4176
| Session ID: 22 Serial number: 8520
|
| #12 2020-03-18 15:21:27,817 Common.DLL OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
| (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
| NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
| NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
| from LG_SM_20200318 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: table or view does not exist
|
| #11 2020-05-20 17:33:11,140 Common.DLL OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
| (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
| NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
| NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
| from LG_SM_20200520 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: table or view does not exist
|
| #11 2020-05-20 17:33:18,366 Common.DLL OracleHelper.ExecuteReader ORA-00942: table or view does not exist
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #11 2020-05-20 17:33:30,304 Dao.DLL GwSmDao.LoadInfoList ORA-00942: table or view does not existselect count(*) as count from LG_SM_20200520 sm left join GW_OP op on sm.op_id=op.op_id where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:ÐкŠ399
|
| #9 2020-05-20 17:37:41,531 Common.DLL OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: end-of-file on communication channel
| Process ID: 1324
| Session ID: 21 Serial number: 4
|
| #4 2020-05-26 16:17:57,963 Common.DLL OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
| (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
| NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
| NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
| from LG_SM_20200526 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: table or view does not exist
|
| #9 2020-05-26 16:22:34,058 Common.DLL OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
| (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
| NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
| NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
| from LG_SM_20200526 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: table or view does not exist
|
| #9 2020-05-26 16:35:35,256 Common.DLL OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
| (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
| NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
| NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
| from LG_SM_20200526 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: table or view does not exist
|
| #11 2020-05-26 16:42:21,621 Common.DLL OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
| (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
| NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
| NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
| from LG_SM_20200526 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: table or view does not exist
|
| #12 2020-05-26 16:49:55,469 Common.DLL OracleHelper.ExecuteReader ORA-00942: table or view does not exist
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #12 2020-05-26 16:49:55,481 Dao.DLL GwTransferDao.LoadInfoList ORA-00942: table or view does not existselect count(*) as count from GwTransfer b where 1=1 order by Id DESC
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwTransferDao.LoadInfoList(String phone, Int32& recordcount, Int32 PageIndex, Int32 pageSize) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwTransferDao.cs:ÐкŠ51
|
| #13 2020-05-26 16:50:29,949 Common.DLL OracleHelper.ExecuteReader ORA-00942: table or view does not exist
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #13 2020-05-26 16:50:29,956 Dao.DLL GwTransferDao.LoadInfoList ORA-00942: table or view does not existselect count(*) as count from GwTransfer b where 1=1 order by Id DESC
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwTransferDao.LoadInfoList(String phone, Int32& recordcount, Int32 PageIndex, Int32 pageSize) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwTransferDao.cs:ÐкŠ51
|
| #5 2020-05-26 16:52:50,091 Common.DLL OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
| (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
| NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
| NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
| from LG_SM_20200526 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: table or view does not exist
|
| #5 2020-05-26 16:52:58,704 Common.DLL OracleHelper.ExecuteReader ORA-00942: table or view does not exist
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #5 2020-05-26 16:52:58,715 Dao.DLL GwTransferDao.LoadInfoList ORA-00942: table or view does not existselect count(*) as count from GwTransfer b where 1=1 order by Id DESC
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwTransferDao.LoadInfoList(String phone, Int32& recordcount, Int32 PageIndex, Int32 pageSize) λÖà C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwTransferDao.cs:ÐкŠ51
|
| #9 2020-05-26 16:54:53,404 Common.DLL OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
| (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
| NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
| NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
| from LG_SM_20200526 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: table or view does not exist
|
| #4 2020-05-26 17:13:27,295 Common.DLL OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
| (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
| NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
| NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
| from LG_SM_20200526 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: table or view does not exist
|
| #11 2020-05-26 17:39:23,789 Common.DLL OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
| (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
| NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
| NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
| from LG_SM_20200526 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: table or view does not exist
|
| #4 2020-05-26 17:48:03,946 Common.DLL OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
| (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
| NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
| NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
| from LG_SM_20200526 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: table or view does not exist
|
| #5 2020-05-26 17:50:26,523 Common.DLL OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
| (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
| NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
| NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
| from LG_SM_20200526 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: table or view does not exist
|
| #11 2020-05-26 17:59:24,940 Common.DLL OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
| (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
| NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
| NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
| from LG_SM_20200526 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: table or view does not exist
|
| #13 2020-09-09 18:19:45,462 Common.DLL OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
| (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
| NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
| NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
| from LG_SM_20200909 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: table or view does not exist
|
| #16 2021-01-18 13:47:49,504 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: end-of-file on communication channel
| Process ID: 13948
| Session ID: 73 Serial number: 20339
|
| #8 2021-01-21 12:07:43,015 Common.dll OracleHelper.ExecuteReader ORA-00904: "ID": invalid identifier
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #23 2021-01-21 12:08:02,652 Common.dll OracleHelper.ExecuteReader ORA-00942: table or view does not exist
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #23 2021-01-21 12:08:02,672 Dao.dll GwTransferDao.LoadInfoList ORA-00942: table or view does not existselect count(*) as count from Gw_Transfer b where 1=1 order by Id DESC
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwTransferDao.LoadInfoList(String phone, Int32& recordcount, Int32 PageIndex, Int32 pageSize) λÖà F:\Ô´Âë\ÕÆ¿¥Ôƺǫ́\web\Dao\GwTransferDao.cs:ÐкŠ50
|
| #10 2021-01-21 16:35:44,754 Common.dll OracleHelper.ExecuteReader ORA-00942: table or view does not exist
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #10 2021-01-21 16:35:44,783 Dao.dll GwTransferDao.LoadInfoList ORA-00942: table or view does not existselect count(*) as count from Gw_Transfer b where 1=1 order by Id DESC
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
| ÔÚ Dao.GwTransferDao.LoadInfoList(String phone, Int32& recordcount, Int32 PageIndex, Int32 pageSize) λÖà C:\Users\Administrator\Desktop\Archives\Git\SMGW\SMGW_CODE\web\Dao\GwTransferDao.cs:ÐкŠ50
|
| #16 2021-01-27 17:49:04,357 Common.dll OracleHelper.ExecuteReader ORA-00904: "ID": invalid identifier
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms)
|
| #8 2021-07-23 16:10:06,286 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: end-of-file on communication channel
| Process ID: 12064
| Session ID: 6 Serial number: 27293
|
| #6 2021-07-28 10:02:21,208 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(B.AP_IN_COUNT,0) AP_IN_COUNT,NVL(b.AP_PENDING_COUNT,0) AP_PENDING_COUNT FROM GW_AP A LEFT JOIN
| (SELECT AP_ID,NVL(SUM(AP_FEE_COUNT),0) AP_IN_COUNT, NVL(SUM(CASE WHEN STATUS=0 THEN AP_FEE_COUNT ELSE 0 END),0) AP_PENDING_COUNT FROM LG_SM_20210728 where AP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY AP_ID) b ON A.AP_ID = b.AP_ID Message=ORA-03113: end-of-file on communication channel
| Process ID: 7904
| Session ID: 6 Serial number: 11866
|
| #6 2021-09-03 11:07:11,651 Common.dll OracleHelper.ExecuteReader ORA-00933: SQL ÃüÁîδÕýÈ·½áÊø
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) λÖà C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:ÐкŠ219
|
| #6 2021-09-03 11:07:17,336 Dao.dll GwSmDao.LoadInfoList ORA-00933: SQL ÃüÁîδÕýÈ·½áÊøselect count(*) as count from LG_SM_20210903 sm left join GW_OP op on sm.op_id=op.op_id where 1=1from LG_SM_20210903 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) λÖà C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:ÐкŠ227
| ÔÚ Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex, String Resend) λÖà D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:ÐкŠ408
|
| #9 2021-09-03 11:07:17,644 Common.dll OracleHelper.ExecuteReader ORA-00933: SQL ÃüÁîδÕýÈ·½áÊø
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) λÖà C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:ÐкŠ219
|
| #9 2021-09-03 11:07:18,930 Dao.dll GwSmDao.LoadInfoList ORA-00933: SQL ÃüÁîδÕýÈ·½áÊøselect count(*) as count from LG_SM_20210903 sm left join GW_OP op on sm.op_id=op.op_id where 1=1from LG_SM_20210903 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) λÖà C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:ÐкŠ227
| ÔÚ Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex, String Resend) λÖà D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:ÐкŠ408
|
| #6 2021-09-03 11:07:24,386 Common.dll OracleHelper.ExecuteReader ORA-00933: SQL ÃüÁîδÕýÈ·½áÊø
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) λÖà C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:ÐкŠ219
|
| #6 2021-09-03 11:08:09,005 Dao.dll GwSmDao.LoadInfoList ORA-00933: SQL ÃüÁîδÕýÈ·½áÊøselect count(*) as count from LG_SM_20210902 sm left join GW_OP op on sm.op_id=op.op_id where 1=1from LG_SM_20210902 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) λÖà C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:ÐкŠ227
| ÔÚ Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex, String Resend) λÖà D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:ÐкŠ408
|
| #7 2021-09-03 11:08:45,659 Common.dll OracleHelper.ExecuteReader ORA-00933: SQL ÃüÁîδÕýÈ·½áÊø
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) λÖà C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:ÐкŠ219
|
| #7 2021-09-03 11:09:27,156 Dao.dll GwSmDao.LoadInfoList ORA-00933: SQL ÃüÁîδÕýÈ·½áÊøselect count(*) as count from LG_SM_20210903 sm left join GW_OP op on sm.op_id=op.op_id where 1=1 from LG_SM_20210903 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) λÖà C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:ÐкŠ227
| ÔÚ Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex, String Resend)
|
| #8 2021-09-15 15:08:29,581 Common.dll OracleHelper.ExecuteReader ORA-00918: δÃ÷È·¶¨ÒåÁÐ
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) λÖà D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:ÐкŠ219
|
| #8 2021-09-15 15:08:29,616 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: δÃ÷È·¶¨ÒåÁÐselect * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210915 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 5)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) λÖà D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:ÐкŠ227
| ÔÚ Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) λÖà D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:ÐкŠ197
|
| #5 2021-09-15 15:19:02,877 Common.dll OracleHelper.ExecuteReader ORA-00918: δÃ÷È·¶¨ÒåÁÐ
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) λÖà D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:ÐкŠ219
|
| #5 2021-09-15 15:19:02,902 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: δÃ÷È·¶¨ÒåÁÐselect * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210915 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 8)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) λÖà D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:ÐкŠ227
| ÔÚ Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount)
|
| #19 2021-09-15 15:26:27,580 Common.dll OracleHelper.ExecuteReader ORA-00918: δÃ÷È·¶¨ÒåÁÐ
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) λÖà D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:ÐкŠ219
|
| #19 2021-09-15 15:26:27,610 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: δÃ÷È·¶¨ÒåÁÐselect * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210915 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 8)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) λÖà D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:ÐкŠ227
| ÔÚ Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount)
|
| #19 2021-09-15 15:26:27,878 Common.dll OracleHelper.Execute SQL=select * from (select rownum r,t.* from (select AP_MID,CLIENT_ID,a.SP_ID,AP_ID,b.OP_NAME,a.ACCESS_CODE,MOBILE,PK_NUMBER,PK_TOTAL,AP_FEE_COUNT,OP_FEE_COUNT,TPUDHI,a.PRIORITY,RD_FLAG,a.MSG_FORMAT,MSG_LENGTH,AP_RESULT,OP_MID,OP_RESULT,AP_SUBMIT_TIME,OP_SUBMIT_TIME,OP_DELIVER_TIME,MSG_CONTENT,STAT,b.op_name,ROUND(TO_NUMBER(a.op_deliver_time-a.ap_submit_time)*24*60*60,0) as OUT_TIME from LG_SM_20210915 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME) t where rownum <= 100000) Message=ORA-00918: δÃ÷È·¶¨ÒåÁÐ
|
| #19 2021-09-15 15:27:44,480 Common.dll OracleHelper.ExecuteReader ORA-00918: δÃ÷È·¶¨ÒåÁÐ
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) λÖà D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:ÐкŠ219
|
| #19 2021-09-15 15:27:44,509 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: δÃ÷È·¶¨ÒåÁÐselect * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210915 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 8)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) λÖà D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:ÐкŠ227
| ÔÚ Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount)
|
| #19 2021-09-15 15:27:44,559 Common.dll OracleHelper.Execute SQL=select * from (select rownum r,t.* from (select AP_MID,CLIENT_ID,a.SP_ID,AP_ID,b.OP_NAME,a.ACCESS_CODE,MOBILE,PK_NUMBER,PK_TOTAL,AP_FEE_COUNT,OP_FEE_COUNT,TPUDHI,a.PRIORITY,RD_FLAG,a.MSG_FORMAT,MSG_LENGTH,AP_RESULT,OP_MID,OP_RESULT,AP_SUBMIT_TIME,OP_SUBMIT_TIME,OP_DELIVER_TIME,MSG_CONTENT,STAT,b.op_name,ROUND(TO_NUMBER(a.op_deliver_time-a.ap_submit_time)*24*60*60,0) as OUT_TIME from LG_SM_20210915 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME) t where rownum <= 100000) Message=ORA-00918: δÃ÷È·¶¨ÒåÁÐ
|
| #8 2021-09-15 15:31:58,906 Common.dll OracleHelper.ExecuteReader ORA-00918: δÃ÷È·¶¨ÒåÁÐ
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
| ÔÚ Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) λÖà D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:ÐкŠ219
|
| #8 2021-09-15 15:31:58,942 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: δÃ÷È·¶¨ÒåÁÐselect * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210915 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 8)
| ÔÚ Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) λÖà D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:ÐкŠ227
| ÔÚ Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) λÖà D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:ÐкŠ197
|
|