Kbase P31500: SQL Exception - FathomTrending Unavailable every 5 minutes
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/15/2003 |
|
Status: Unverified
FACT(s) (Environment):
Fathom for Management 2.1A beta
SYMPTOM(s):
FathomTrending Unavailable every 5 minutes
SQL error within FathomTrendDB
Unable to trend OpenEdge resources
[Fathom] * An SQL Exception occured during an insert into the trend database. SQLState: 21S01
[Fathom] * message: [JDBC Progress Driver]:Too many values specified (7531)
[Fathom] * vendor: -20017
[Fathom] * statement: INSERT INTO PUB.Cf_Sample values (1628,299,''7/14/2003'',67796,9,0,''9002'',''LT1'' );INSERT INTO PUB.Sys_Process ( Process_StartTimeStamp,Process_ElapsedTime,Process_ResMemory,Process_UserName,Process_CPUUser,Process_PID,Process_UserGroup,Process_VirtMem,Process_CPUPctWT,Process_CPUPct,Process_CPUSystem,Process_CommandArgs,Process_PPID,Process_Command, Sample_ID) values (''maandag 14 juli 2003 10:43:30'',0.0,3176,0,'''',0.0,944,'''',0,2,0.0,0.0,0.0,''d:\dlc91d\bin\_proapsv.exe'',2656,''d:\dlc91d\bin\_proapsv.exe'',1628 );INSERT INTO PUB.OE_ActSrv ( ActSrv_BusyTime,ActSrv_LockedTime,ActSrv_IdleTime,ActSrv_Status,ActBrk_PID,ActBrk_UUID,ActSrv_PID,ActSrv_BusyCount,ActSrv_IdleCount,ActSrv_LockedCount, Sample_ID) values (0.0,0.0,0.0,1,2656,''932.99.999.XXX:1ee77e:cf3bbe3d33:-8000'',944,0.0,0.0,0.0,1628 );INSERT INTO PUB.OE_ActBrk ( ActBrk_ReqRec,ActBrk_TotClients,ActBrk_ReqRejected,ActBrk_Mode,ActBrk_PID,ActBrk_UUID,ActBrk_ReqQueued,ActBrk_ReqComp,ActBrk_CurrClients,ActBrk_Name, Sample_ID) values (0.0,0.0,0.0,''State-reset'',2656,''932.99.999.XXX:1ee77e:cf3bbe3d33:-8000'',0.0,0.0,0,''asbroker1'',1628 ); (9494)
CAUSE:
BUG# 20030617-044
CAUSE:
This is a known issue - numbers with comma separators (vs. a decimal point) are being interpreted as multiple values.
FIX:
Change the OS locale on the machine to use decimal separators (and restart the AdminServer)