angeltwo
Member | Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору
IBE> Trace session "IBE_17.08.2016 11:53:15" started successfully...
IBE> Server: ***********
IBE> Client library: **********\gds32.dll
IBE> User: SYSDBA
Trace session ID 1 started
2016-08-17T11:53:17.4670 (5588:00000000003DD9E8) TRACE_INIT
SESSION_1 IBE_17.08.2016 11:53:15
2016-08-17T11:53:17.8320 (5588:00000000003DD9E8) EXECUTE_STATEMENT_FINISH
fin16 (ATT_592, **********:FINTUNER, WIN1251, TCPv4:***********)
C:\Documents and Settings\*********\Infotech\B2K\Bin\Bit2000mnu.exe:3988
(TRA_4712, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Statement 52399:
-------------------------------------------------------------------------------
SELECT TYPEMSG FROM RASPRI_MAIL WHERE TABLENAME='RAS' AND CODEBRANCH= ? AND CAST(UNIQ AS NUMERIC(16,0))= ?
AND (TABLENAME='RAS' AND CODEBRANCH= ? AND CAST(UNIQ AS NUMERIC(16,0))= ? )
param0 = integer, "<NULL>"
param1 = bigint, "<NULL>"
param2 = integer, "<NULL>"
param3 = bigint, "<NULL>"
0 records fetched
145 ms, 939 read(s), 90462 fetch(es)
2016-08-17T11:53:34.0180 (13028:0000000000EFD9E8) TRACE_INIT
SESSION_1 IBE_17.08.2016 11:53:15
2016-08-17T11:53:45.2970 (3756:00000000028BD9E8) TRACE_INIT
SESSION_1 IBE_17.08.2016 11:53:15
2016-08-17T11:53:47.7900 (3756:00000000028BD9E8) EXECUTE_STATEMENT_FINISH
fin16 (ATT_593, ***********:FINWRITER, WIN1251, TCPv4:***********)
C:\Users\**********\Infotech\B2K\Bin\Bit2000mnu.exe:6160
(TRA_4724, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Statement 52521:
-------------------------------------------------------------------------------
select BS_D as K_BS,EXPENSEITE_D as K_EXPENSEITE,PREDIM_D as K_PREDIM,SRKAPSTR7_D as K_SRKAPSTR7,VIDO_D as K_VIDO,MESTOR39_D as K_MESTOR39,FAKT_D as K_FAKT,INVOBOS77_D as K_INVOBOS77,STRVLSTROB_D as K_STRVLSTROB,NALOGPER999_D as K_NALOGPER999,min(NP) as NP,min(DAT) as DAT,min(GEN) as MYREGND,min(REGDOC) as REGDOC,min(BS_K) as BS,sum(DB.VAL) as VAL,CRY,sum(RUB) as RUB,sum(KOLVO) as KOLVO,min(PRIM) as PRIM from DB where DAT between '01/01/2016' and '07/31/2016' and (BS_D in ('0803','0809')) and (EXPENSEITE_D LIKE '03235%') group by BS_D,EXPENSEITE_D,PREDIM_D,SRKAPSTR7_D,VIDO_D,MESTOR39_D,FAKT_D,INVOBOS77_D,STRVLSTROB_D,NALOGPER999_D,CRY HAVING SUM(RUB)<>0.00 OR SUM(DB.VAL)<>0.00 OR SUM(KOLVO)<>0.000000 order by BS_D NULLS LAST,EXPENSEITE_D NULLS LAST,PREDIM_D NULLS LAST,SRKAPSTR7_D NULLS LAST,VIDO_D NULLS LAST,MESTOR39_D NULLS LAST,FAKT_D NULLS LAST,INVOBOS77_D NULLS LAST,STRVLSTROB_D NULLS LAST,NALOGPER999_D NULLS LAST,CRY
5 records fetched
2368 ms, 17392 read(s), 1075871 fetch(es)
2016-08-17T11:53:59.4750 (13028:0000000000EFD9E8) EXECUTE_STATEMENT_FINISH
fin16 (ATT_255, ***********:FINWRITER, WIN1251, TCPv4:**************)
C:\Users\************\Infotech\B2K\Bin\Bit2000mnu.exe:3436
(TRA_4728, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Statement 52546:
-------------------------------------------------------------------------------
select BS as K_BS,CONTRAGENT as K_CONTRAGENT,DOGUNIQ as K_DOGUNIQ,min(DAT) as DAT,max(PRIM) as PRIM,sum(RUB) as RUB,'RUR' as CRY,sum(OB.VAL) as VAL,sum(KOLVO) as KOLVO from OB where GOD=2016 and MES=08 AND DOGUNIQ=759584.0 group by BS,CONTRAGENT,DOGUNIQ order by BS NULLS LAST,CONTRAGENT NULLS LAST,DOGUNIQ NULLS LAST
1 records fetched
556 ms, 3891 read(s), 399160 fetch(es)
2016-08-17T11:53:59.6530 (13028:0000000000EFD9E8) EXECUTE_STATEMENT_FINISH
fin16 (ATT_255, *************:FINWRITER, WIN1251, TCPv4:***********)
C:\Users\****************\Infotech\B2K\Bin\Bit2000mnu.exe:3436
(TRA_4728, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Statement 52547:
-------------------------------------------------------------------------------
select BS_D as K_BS,CONTRAGENT_D as K_CONTRAGENT,DOGUNIQ_D as K_DOGUNIQ,min(NP) as NP,min(DAT) as DAT,min(GEN) as MYREGND,min(REGDOC) as REGDOC,min(BS_K) as BS,sum(DB.VAL) as VAL,CRY,sum(RUB) as RUB,sum(KOLVO) as KOLVO,min(PRIM) as PRIM from DB where DAT between '08/01/2016' and '08/31/2016' AND DB.DOGUNIQ_D =759584.0 group by BS_D,CONTRAGENT_D,DOGUNIQ_D,CRY order by BS_D NULLS LAST,CONTRAGENT_D NULLS LAST,DOGUNIQ_D NULLS LAST,CRY
0 records fetched
161 ms, 693 read(s), 38299 fetch(es)
2016-08-17T11:53:59.8420 (13028:0000000000EFD9E8) EXECUTE_STATEMENT_FINISH
fin16 (ATT_255, **********:FINWRITER, WIN1251, TCPv4:**********)
C:\Users\***************\Infotech\B2K\Bin\Bit2000mnu.exe:3436
(TRA_4728, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Statement 52548:
-------------------------------------------------------------------------------
select BS_K as K_BS,CONTRAGENT_K as K_CONTRAGENT,DOGUNIQ_K as K_DOGUNIQ,min(NP) as NP,min(DAT) as DAT,min(GEN) as MYREGND,min(REGDOC) as REGDOC,min(BS_D) as BS,sum(DB.VAL) as VAL,CRY,sum(RUB) as RUB,sum(KOLVO) as KOLVO,min(PRIM) as PRIM from DB where DAT between '08/01/2016' and '08/31/2016' AND DB.DOGUNIQ_K =759584.0 group by BS_K,CONTRAGENT_K,DOGUNIQ_K,CRY order by BS_K NULLS LAST,CONTRAGENT_K NULLS LAST,DOGUNIQ_K NULLS LAST,CRY
0 records fetched
174 ms, 693 read(s), 38299 fetch(es)
2016-08-17T11:54:02.3710 (3756:00000000028BD9E8) TRACE_FINI
SESSION_1 IBE_17.08.2016 11:53:15
2016-08-17T11:54:26.4670 (8844:00000000003DD9E8) TRACE_INIT
SESSION_1 IBE_17.08.2016 11:53:15
IBE> Trace session IBE_17.08.2016 11:53:15 terminated.
|
Всего записей: 257 | Зарегистр. 09-05-2007 | Отправлено: 11:12 17-08-2016 | Исправлено: angeltwo, 13:56 17-08-2016 |
|
