DBmonitor logs truncated

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
wchris
Posts: 51
Joined: Thu 09 Jun 2005 09:44

DBmonitor logs truncated

Post by wchris » Mon 02 Jun 2008 13:51

Latest versions of DBmonitor truncate parameters of procedures with many parameters when the log output is saved to a file.

latest known working version is 2.11

can you reproduce and fix this ?

Thx
Top
Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Tue 03 Jun 2008 13:30

We have fixed this problem. We'll release new DBMonitor build with the fix in few days.
Top
wchris
Posts: 51
Joined: Thu 09 Jun 2005 09:44

Post by wchris » Tue 03 Jun 2008 14:26

Great !

Just to be sure you understood me :

This is the DBmonitor 2.12 log

C:\AtalSrc32\BIN\ATALANTE32.exe
03/06/2008 14:42:54 n/a ODAC monitoring is started. Complete
03/06/2008 14:42:54 0:0.15 SQL Execute: SELECT replace(paanom, ' ', '_') "PAANOM",PAAVAL FROM PARAMAPPLI
Complete
03/06/2008 14:43:00 0:0.0 SQL Execute: begin
MAJ_CRE_ARBRE(:ARB_NO, :ARB_LIB, :ARB_IDFORET, :ARB_UTIL, :ARB_DESCR, :J_TRACE, :J_MODUL, :J_UTILATAL, :J_UTILOS, :J_MACHINE, :J_MESG, :MODE_APPEL, :ERR_NUM, :ERR_MSG);
end;
:A Complete
03/06/2008 14:43:01 0:0.0 SQL Execute: begin
MAJ_CRE_ARBORESCENCES(:NOE_NO, :NOE_ARBRE, :NOE_LIB, :NOE_MODEINSERT, :NOE_DESTIN, :NOE_EXT, :NOE_TYPEDONNEE, :NOE_DONNEE, :J_TRACE, :J_MODUL, :J_UTILATAL, :J_UTILOS, :J_MACHINE, Complete
03/06/2008 14:43:01 0:0.0 SQL Execute: begin
MAJ_CRE_ARBORESCENCES(:NOE_NO, :NOE_ARBRE, :NOE_LIB, :NOE_MODEINSERT, :NOE_DESTIN, :NOE_EXT, :NOE_TYPEDONNEE, :NOE_DONNEE, :J_TRACE, :J_MODUL, :J_UTILATAL, :J_UTILOS, :J_MACHINE, Complete
03/06/2008 14:43:01 0:0.0 SQL Execute: begin
MAJ_CRE_ARBORESCENCES(:NOE_NO, :NOE_ARBRE, :NOE_LIB, :NOE_MODEINSERT, :NOE_DESTIN, :NOE_EXT, :NOE_TYPEDONNEE, :NOE_DONNEE, :J_TRACE, :J_MODUL, :J_UTILATAL, :J_UTILOS, :J_MACHINE, Complete





and this is the 2.10 log (10 x bigger )

C:\AtalSrc32\BIN\ATALANTE32.exe
03/06/2008 15:28:37 n/a ODAC monitoring is started. Complete
03/06/2008 15:28:37 0:0.0 SQL Execute: SELECT replace(paanom, ' ', '_') "PAANOM",PAAVAL FROM PARAMAPPLI
Complete
03/06/2008 15:28:40 0:0.0 SQL Execute: begin
MAJ_CRE_ARBRE(:ARB_NO, :ARB_LIB, :ARB_IDFORET, :ARB_UTIL, :ARB_DESCR, :J_TRACE, :J_MODUL, :J_UTILATAL, :J_UTILOS, :J_MACHINE, :J_MESG, :MODE_APPEL, :ERR_NUM, :ERR_MSG);
end;
:A Complete
03/06/2008 15:28:40 0:0.0 SQL Execute: begin
MAJ_CRE_ARBORESCENCES(:NOE_NO, :NOE_ARBRE, :NOE_LIB, :NOE_MODEINSERT, :NOE_DESTIN, :NOE_EXT, :NOE_TYPEDONNEE, :NOE_DONNEE, :J_TRACE, :J_MODUL, :J_UTILATAL, :J_UTILOS, :J_MACHINE, Complete
03/06/2008 15:28:40 0:0.16 SQL Execute: begin
MAJ_CRE_ARBORESCENCES(:NOE_NO, :NOE_ARBRE, :NOE_LIB, :NOE_MODEINSERT, :NOE_DESTIN, :NOE_EXT, :NOE_TYPEDONNEE, :NOE_DONNEE, :J_TRACE, :J_MODUL, :J_UTILATAL, :J_UTILOS, :J_MACHINE, Complete
03/06/2008 15:28:40 0:0.0 SQL Execute: begin
MAJ_CRE_ARBORESCENCES(:NOE_NO, :NOE_ARBRE, :NOE_LIB, :NOE_MODEINSERT, :NOE_DESTIN, :NOE_EXT, :NOE_TYPEDONNEE, :NOE_DONNEE, :J_TRACE, :J_MODUL, :J_UTILATAL, :J_UTILOS, :J_MACHINE, Complete
C:\AtalSrc32\BIN\ATALANTE32.exe
03/06/2008 15:33:55 n/a ODAC monitoring is started. Complete
03/06/2008 15:33:55 0:0.0 SQL Execute: SELECT replace(paanom, ' ', '_') "PAANOM",PAAVAL FROM PARAMAPPLI
Complete
03/06/2008 15:34:11 0:0.0 SQL Execute: begin
MAJ_CRE_ARBRE(:ARB_NO, :ARB_LIB, :ARB_IDFORET, :ARB_UTIL, :ARB_DESCR, :J_TRACE, :J_MODUL, :J_UTILATAL, :J_UTILOS, :J_MACHINE, :J_MESG, :MODE_APPEL, :ERR_NUM, :ERR_MSG);
end;
:ARB_NO(VARCHAR[0],IN/OUT)=
:ARB_LIB(VARCHAR[7],IN)='Emucrit'
:ARB_IDFORET(VARCHAR[23],IN)='SELECTION MULTICRITERES'
:ARB_UTIL(VARCHAR[3],IN)='100'
:ARB_DESCR(VARCHAR[0],IN)=
:J_TRACE(VARCHAR[1],IN)='0'
:J_MODUL(VARCHAR[1],IN)='0'
:J_UTILATAL(VARCHAR[3],IN)='100'
:J_UTILOS(VARCHAR[5],IN)='clach'
:J_MACHINE(VARCHAR[10],IN)='INFOPOSTE2'
:J_MESG(VARCHAR[14],IN)='AtaORAtreeview'
:MODE_APPEL(INTEGER,IN)=0
:ERR_NUM(FLOAT,OUT)=
:ERR_MSG(VARCHAR[0],OUT)= Complete
03/06/2008 15:34:11 0:0.16 SQL Execute: begin
MAJ_CRE_ARBORESCENCES(:NOE_NO, :NOE_ARBRE, :NOE_LIB, :NOE_MODEINSERT, :NOE_DESTIN, :NOE_EXT, :NOE_TYPEDONNEE, :NOE_DONNEE, :J_TRACE, :J_MODUL, :J_UTILATAL, :J_UTILOS, :J_MACHINE, :J_MESG, :MODE_APPEL, :ERR_NUM, :ERR_MSG, :NOE_REFCURSOR);
end;
:NOE_NO(VARCHAR[0],IN/OUT)=
:NOE_ARBRE(VARCHAR[3],IN)='101'
:NOE_LIB(VARCHAR[0],IN)=
:NOE_MODEINSERT(VARCHAR[0],IN)=
:NOE_DESTIN(VARCHAR[0],IN)=
:NOE_EXT(VARCHAR[0],IN)=
:NOE_TYPEDONNEE(VARCHAR[0],IN)=
:NOE_DONNEE(VARCHAR[0],IN)=
:J_TRACE(VARCHAR[1],IN)='0'
:J_MODUL(VARCHAR[1],IN)='0'
:J_UTILATAL(VARCHAR[3],IN)='100'
:J_UTILOS(VARCHAR[5],IN)='clach'
:J_MACHINE(VARCHAR[10],IN)='INFOPOSTE2'
:J_MESG(VARCHAR[14],IN)='AtaORAtreeview'
:MODE_APPEL(INTEGER,IN)=20
:ERR_NUM(FLOAT,OUT)=
:ERR_MSG(VARCHAR[0],OUT)=
:NOE_REFCURSOR(CURSOR,IN/OUT)= Complete
03/06/2008 15:34:11 0:0.0 SQL Execute: begin
MAJ_CRE_ARBORESCENCES(:NOE_NO, :NOE_ARBRE, :NOE_LIB, :NOE_MODEINSERT, :NOE_DESTIN, :NOE_EXT, :NOE_TYPEDONNEE, :NOE_DONNEE, :J_TRACE, :J_MODUL, :J_UTILATAL, :J_UTILOS, :J_MACHINE, :J_MESG, :MODE_APPEL, :ERR_NUM, :ERR_MSG, :NOE_REFCURSOR);
end;
:NOE_NO(VARCHAR[0],IN/OUT)=
:NOE_ARBRE(VARCHAR[3],IN)='101'
:NOE_LIB(VARCHAR[0],IN)=
:NOE_MODEINSERT(VARCHAR[0],IN)=
:NOE_DESTIN(VARCHAR[0],IN)=
:NOE_EXT(VARCHAR[0],IN)=
:NOE_TYPEDONNEE(VARCHAR[0],IN)=
:NOE_DONNEE(VARCHAR[0],IN)=
:J_TRACE(VARCHAR[1],IN)='0'
:J_MODUL(VARCHAR[1],IN)='0'
:J_UTILATAL(VARCHAR[3],IN)='100'
:J_UTILOS(VARCHAR[5],IN)='clach'
:J_MACHINE(VARCHAR[10],IN)='INFOPOSTE2'
:J_MESG(VARCHAR[14],IN)='AtaORAtreeview'
:MODE_APPEL(INTEGER,IN)=21
:ERR_NUM(FLOAT,OUT)=
:ERR_MSG(VARCHAR[0],OUT)=
:NOE_REFCURSOR(CURSOR,IN/OUT)= Complete
03/06/2008 15:34:11 0:0.0 SQL Execute: begin
MAJ_CRE_ARBORESCENCES(:NOE_NO, :NOE_ARBRE, :NOE_LIB, :NOE_MODEINSERT, :NOE_DESTIN, :NOE_EXT, :NOE_TYPEDONNEE, :NOE_DONNEE, :J_TRACE, :J_MODUL, :J_UTILATAL, :J_UTILOS, :J_MACHINE, :J_MESG, :MODE_APPEL, :ERR_NUM, :ERR_MSG, :NOE_REFCURSOR);
end;
:NOE_NO(VARCHAR[0],IN/OUT)=
:NOE_ARBRE(VARCHAR[3],IN)='101'
:NOE_LIB(VARCHAR[3],IN)='DIM'
:NOE_MODEINSERT(VARCHAR[2],IN)='EC'
:NOE_DESTIN(VARCHAR[0],IN)=
:NOE_EXT(VARCHAR[3],IN)='DIR'
:NOE_TYPEDONNEE(VARCHAR[0],IN)=
:NOE_DONNEE(VARCHAR[0],IN)=
:J_TRACE(VARCHAR[1],IN)='0'
:J_MODUL(VARCHAR[1],IN)='0'
:J_UTILATAL(VARCHAR[3],IN)='100'
:J_UTILOS(VARCHAR[5],IN)='clach'
:J_MACHINE(VARCHAR[10],IN)='INFOPOSTE2'
:J_MESG(VARCHAR[14],IN)='AtaORAtreeview'
:MODE_APPEL(INTEGER,IN)=2
:ERR_NUM(FLOAT,OUT)=
:ERR_MSG(VARCHAR[0],OUT)=
:NOE_REFCURSOR(CURSOR,IN/OUT)= Complete
Top
Post Reply

Return to “Oracle Data Access Components”