Problem with SQLH2

Hi all i have problem with SQLH2. SQLH2 installed on Windows XP Pro SP2
Russian.
Version SQLH2 is H2 Collector ver. V2 2.0.024.0 9/30/04 17:58
this is log
28.12.2004 15:00:16 Opening Log
28.12.2004 15:00:16 SQLH2 ver. V2 2.0.024.0 9/30/04 17:58
28.12.2004 15:00:16 Status: Init
28.12.2004 15:00:16 WARNING: There are no PerfProviders in the config file
28.12.2004 15:00:16 Status: Initializing repository: manushind
28.12.2004 15:00:16 Status: Repository Database: SQLH2Repository
28.12.2004 15:00:16 INFO: host_id = 1
28.12.2004 15:00:16 Status: Starting RUN
28.12.2004 15:00:16 Status: Registering Run
28.12.2004 15:00:16 INFO: run_id = 8
28.12.2004 15:00:16 Status: Starting Targets processing
28.12.2004 15:00:16 Status: Initializing Target: SRV-ELDDB2
28.12.2004 15:00:16 Status: registering Server
28.12.2004 15:00:16 INFO: srv_id = 2; signature =
aad193c2-d36c-4760-a312-57dc78d07944
28.12.2004 15:00:16 Status: Scanning Registry on SRV-ELDDB2
28.12.2004 15:00:16 Status: registering instance SRV-ELDDB2
28.12.2004 15:00:16 INFO: inst_id = 1
28.12.2004 15:00:16 INFO: version: 8.00.818
28.12.2004 15:00:16 Status: RUN
28.12.2004 15:00:16 Status: Initializing collector: WMI
28.12.2004 15:00:16 Status: Running WMI collector
28.12.2004 15:00:16 Status: Opening Unit 1 (OS/CS)
28.12.2004 15:00:16 Status: Collecting Win32_OperatingSystem
28.12.2004 15:00:17 Status: Closing Unit 1
28.12.2004 15:00:17 ERROR: NotFound
28.12.2004 15:00:17 WARNING: WMI Collector encountered critical error.
Abandoning Collector.
28.12.2004 15:00:17 Status: Initializing collector: EventLog
28.12.2004 15:00:17 Status: Initializing collector: SQL
28.12.2004 15:00:17 Status: Running SQL collector on SRV-ELDDB2
28.12.2004 15:00:17 Status: Opening Unit 5 (Server Properties)
28.12.2004 15:00:17 Status: Closing Unit 5
28.12.2004 15:00:17 Status: Opening Unit 1 (Databases)
28.12.2004 15:00:18 ERROR: There are fewer columns in the INSERT statement
than values specified in the VALUES clause. The number of values in the
VALUES clause must match the number of columns specified in the INSERT
statement.
28.12.2004 15:00:18 ERROR: Insert dbo.c_database
(run_id,srv_id,inst_id,dbid,name,CompatibilityLeve l,CreateDate,DataSpaceUsage,IndexSpaceUsage,dbSize ,SpaceAvailable,IsSystem,txSize,txSpaceAvailable,t xLastBackup,oRecoveryModel,oPageVerify,oUserAccess ,oAutoClose,oAutoShrink,oAutoCreateStat,oAutoUpdat eStat
,oOffline,oReadOnly,oSelectIntoBulkCopy,oTruncateL ogOnCheckpoint,oPublished,oSubscribed,oMergePublis hed,oMergeSubscribed,oFullTextEnabled,oDbChaining)
Values (8, 2, 1, 8, 'auxdb', 80, '15.12.2004 15:25:56', 15904, 368,
38,812500, 8,414063, 0, 1,250000, 0,820313, '18.12.2003 1:35:22', 3, 1, 0, 0,
0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0)
28.12.2004 15:00:18 ERROR: Unit 1 failed
28.12.2004 15:00:18 Status: Closing Unit 1
28.12.2004 15:00:18 ERROR: Insert dbo.c_database
(run_id,srv_id,inst_id,dbid,name,CompatibilityLeve l,CreateDate,DataSpaceUsage,IndexSpaceUsage,dbSize ,SpaceAvailable,IsSystem,txSize,txSpaceAvailable,t xLastBackup,oRecoveryModel,oPageVerify,oUserAccess ,oAutoClose,oAutoShrink,oAutoCreateStat,oAutoUpdat eStat
,oOffline,oReadOnly,oSelectIntoBulkCopy,oTruncateL ogOnCheckpoint,oPublished,oSubscribed,oMergePublis hed,oMergeSubscribed,oFullTextEnabled,oDbChaining)
Values (8, 2, 1, 8, 'auxdb', 80, '15.12.2004 15:25:56', 15904, 368,
38,812500, 8,414063, 0, 1,250000, 0,820313, '18.12.2003 1:35:22', 3, 1, 0, 0,
0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0)
28.12.2004 15:00:18 ERROR: SRV-ELDDB2: Collection failed; Error:104;
Provider Error: 110
28.12.2004 15:00:18 ERROR: Critical Repository Failure
28.12.2004 15:00:18 SQLH2 is shutting down
28.12.2004 15:00:18 Closing Log
P.S.
i have Domain admins right.
Thank you.
Dimitri,
I suspect this is a localisation issue. Is your decimal symbol a comma by
any chance?
If you look at the Appendix C of the SQLH2 Deployment Guide (this should be
in your root installation directory), you will see some useful hints on how
to get SQLH2 working on localised Windows platforms.
Looking at your log, I would also advise that your dates are not in the
expected format for SQLH2, so you will need to use the /D switch (again
please see Appendix C).
Hope this helps,
John Marsh
"dmitri" wrote:

> Hi all i have problem with SQLH2. SQLH2 installed on Windows XP Pro SP2
> Russian.
> Version SQLH2 is H2 Collector ver. V2 2.0.024.0 9/30/04 17:58
> this is log
> 28.12.2004 15:00:16 Opening Log
> 28.12.2004 15:00:16 SQLH2 ver. V2 2.0.024.0 9/30/04 17:58
> 28.12.2004 15:00:16 Status: Init
> 28.12.2004 15:00:16 WARNING: There are no PerfProviders in the config file
> 28.12.2004 15:00:16 Status: Initializing repository: manushind
> 28.12.2004 15:00:16 Status: Repository Database: SQLH2Repository
> 28.12.2004 15:00:16 INFO: host_id = 1
> 28.12.2004 15:00:16 Status: Starting RUN
> 28.12.2004 15:00:16 Status: Registering Run
> 28.12.2004 15:00:16 INFO: run_id = 8
> 28.12.2004 15:00:16 Status: Starting Targets processing
> 28.12.2004 15:00:16 Status: Initializing Target: SRV-ELDDB2
> 28.12.2004 15:00:16 Status: registering Server
> 28.12.2004 15:00:16 INFO: srv_id = 2; signature =
> aad193c2-d36c-4760-a312-57dc78d07944
> 28.12.2004 15:00:16 Status: Scanning Registry on SRV-ELDDB2
> 28.12.2004 15:00:16 Status: registering instance SRV-ELDDB2
> 28.12.2004 15:00:16 INFO: inst_id = 1
> 28.12.2004 15:00:16 INFO: version: 8.00.818
> 28.12.2004 15:00:16 Status: RUN
> 28.12.2004 15:00:16 Status: Initializing collector: WMI
> 28.12.2004 15:00:16 Status: Running WMI collector
> 28.12.2004 15:00:16 Status: Opening Unit 1 (OS/CS)
> 28.12.2004 15:00:16 Status: Collecting Win32_OperatingSystem
> 28.12.2004 15:00:17 Status: Closing Unit 1
> 28.12.2004 15:00:17 ERROR: NotFound
> 28.12.2004 15:00:17 WARNING: WMI Collector encountered critical error.
> Abandoning Collector.
> 28.12.2004 15:00:17 Status: Initializing collector: EventLog
> 28.12.2004 15:00:17 Status: Initializing collector: SQL
> 28.12.2004 15:00:17 Status: Running SQL collector on SRV-ELDDB2
> 28.12.2004 15:00:17 Status: Opening Unit 5 (Server Properties)
> 28.12.2004 15:00:17 Status: Closing Unit 5
> 28.12.2004 15:00:17 Status: Opening Unit 1 (Databases)
> 28.12.2004 15:00:18 ERROR: There are fewer columns in the INSERT statement
> than values specified in the VALUES clause. The number of values in the
> VALUES clause must match the number of columns specified in the INSERT
> statement.
> 28.12.2004 15:00:18 ERROR: Insert dbo.c_database
> (run_id,srv_id,inst_id,dbid,name,CompatibilityLeve l,CreateDate,DataSpaceUsage,IndexSpaceUsage,dbSize ,SpaceAvailable,IsSystem,txSize,txSpaceAvailable,t xLastBackup,oRecoveryModel,oPageVerify,oUserAccess ,oAutoClose,oAutoShrink,oAutoCreateStat,oAutoUpdat eSt
at,oOffline,oReadOnly,oSelectIntoBulkCopy,oTruncat eLogOnCheckpoint,oPublished,oSubscribed,oMergePubl ished,oMergeSubscribed,oFullTextEnabled,oDbChainin g)
> Values (8, 2, 1, 8, 'auxdb', 80, '15.12.2004 15:25:56', 15904, 368,
> 38,812500, 8,414063, 0, 1,250000, 0,820313, '18.12.2003 1:35:22', 3, 1, 0, 0,
> 0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0)
> 28.12.2004 15:00:18 ERROR: Unit 1 failed
> 28.12.2004 15:00:18 Status: Closing Unit 1
> 28.12.2004 15:00:18 ERROR: Insert dbo.c_database
> (run_id,srv_id,inst_id,dbid,name,CompatibilityLeve l,CreateDate,DataSpaceUsage,IndexSpaceUsage,dbSize ,SpaceAvailable,IsSystem,txSize,txSpaceAvailable,t xLastBackup,oRecoveryModel,oPageVerify,oUserAccess ,oAutoClose,oAutoShrink,oAutoCreateStat,oAutoUpdat eSt
at,oOffline,oReadOnly,oSelectIntoBulkCopy,oTruncat eLogOnCheckpoint,oPublished,oSubscribed,oMergePubl ished,oMergeSubscribed,oFullTextEnabled,oDbChainin g)
> Values (8, 2, 1, 8, 'auxdb', 80, '15.12.2004 15:25:56', 15904, 368,
> 38,812500, 8,414063, 0, 1,250000, 0,820313, '18.12.2003 1:35:22', 3, 1, 0, 0,
> 0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0)
> 28.12.2004 15:00:18 ERROR: SRV-ELDDB2: Collection failed; Error:104;
> Provider Error: 110
> 28.12.2004 15:00:18 ERROR: Critical Repository Failure
> 28.12.2004 15:00:18 SQLH2 is shutting down
> 28.12.2004 15:00:18 Closing Log
> P.S.
> i have Domain admins right.
> Thank you.
|||John, i see this hints but not try use it yet. I hope this help. thank you.
"John Marsh" wrote:
[vbcol=seagreen]
> Dimitri,
> I suspect this is a localisation issue. Is your decimal symbol a comma by
> any chance?
> If you look at the Appendix C of the SQLH2 Deployment Guide (this should be
> in your root installation directory), you will see some useful hints on how
> to get SQLH2 working on localised Windows platforms.
> Looking at your log, I would also advise that your dates are not in the
> expected format for SQLH2, so you will need to use the /D switch (again
> please see Appendix C).
> Hope this helps,
> John Marsh
>
> "dmitri" wrote:
Stat,oOffline,oReadOnly,oSelectIntoBulkCopy,oTrunc ateLogOnCheckpoint,oPublished,oSubscribed,oMergePu blished,oMergeSubscribed,oFullTextEnabled,oDbChain ing)[vbcol=seagreen]
Stat,oOffline,oReadOnly,oSelectIntoBulkCopy,oTrunc ateLogOnCheckpoint,oPublished,oSubscribed,oMergePu blished,oMergeSubscribed,oFullTextEnabled,oDbChain ing)[vbcol=seagreen]