Menu

#47 Statement detail in error

v1.0_(example)
open
nobody
None
1
2018-05-29
2018-05-29
Anonymous
No

Hello,
Using asemon report v3.0.9, in the "Statements" board, when we choose one, this message appears in the new window :
ERROR
Module : refresh_stmtstats
Message :
Sybase error in msg_handler_GET : 207 severity : 16 state : 4 line : 1 Msg : Invalid column name 'StatementNumber'.

Query:
select StmtID, BootID, KPID, SPID, BatchID, Strttm=convert(varchar,StartTime,109), Elapsed_s=str(convert(float,datediff(ms,StartTime,EndTime))/1000,8,3), Elapsed_ms=datediff(ms,StartTime,EndTime), ExactStat, [Login], Application, ClientHost, ClientIP, ClientOSPID, DBID, ProcName, LineNumber, CpuTime, WaitTime, MemUsageKB, PhysicalReads, LogicalReads, PagesModified, PacketsSent, PacketsReceived, NetworkPacketSize, PlansAltered, PlanID, ContextID, RowsAffected , SQLHashKey, PLANHashKey, StatementNumber, ProcNestLevel, tran_name from XXX_StmtStat where StmtID=264817

Actually, there's no StatementNumber or ProcNestLevel columns in XXX_StmtStat. In Asemon_report/ASE/Statement_detail.php , I switched this :
"
if ( supportFieldsAnja == 1 ) {
selClientInfo = selClientInfo + ", StatementNumber, ProcNestLevel";
}

if ( col_tran_name_Exists == 1 ) {
selClientInfo = selClientInfo + ", StatementNumber, ProcNestLevel";
selClientInfo = selClientInfo + ", tran_name";
}
"
to this
" if ( supportFieldsAnja == 1 ) {
selClientInfo = selClientInfo + ", StatementNumber, ProcNestLevel";
}

if ( col_tran_name_Exists == 1 ) {
// selClientInfo = selClientInfo + ", StatementNumber, ProcNestLevel";
selClientInfo = selClientInfo + ", tran_name";
}
"
disabling the first selClientInfo if col_tran_name_Exists equal 1.

It works.

Asemon report is running on windows, the client (windows) is ASE 12.5.4 and asemon_logger_V3.0.9

Discussion

Anonymous
Anonymous

Add attachments
Cancel





MongoDB Logo MongoDB