sqlH2 pb with insert statement
From: lolo (lolo_at_nospam.fr)
Date: 10/11/04
- Next message: Samuel: "Re: identity seed"
- Previous message: thejamie: "Can I use Crystal to call a view that calls an SQL function"
- Next in thread: Grigory Pogulsky [MS]: "Re: sqlH2 pb with insert statement"
- Reply: Grigory Pogulsky [MS]: "Re: sqlH2 pb with insert statement"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 11 Oct 2004 16:05:17 +0200
Helo,
i'm trying to use the SQLH2 tools but i always got the same error when
i launch the tools.
here is the log :
***************
08/10/2004 17:42:03 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.
08/10/2004 17:42:03 ERROR: Insert dbo.c_database
(run_id,srv_id,inst_id,dbid,name,CompatibilityLevel,CreateDate,DataSpaceUsag
e,IndexSpaceUsage,dbSize,SpaceAvailable,IsSystem,txSize,txSpaceAvailable,txL
astBackup,oRecoveryModel,oPageVerify,oUserAccess,oAutoClose,oAutoShrink,oAut
oCreateStat,oAutoUpdateStat,oOffline,oReadOnly,oSelectIntoBulkCopy,oTruncate
LogOnCheckpoint,oPublished,oSubscribed,oMergePublished,oMergeSubscribed,oFul
lTextEnabled,oDbChaining) Values (2, 1, 1, 1, 'master', 90, '08/04/2003
09:13:36', 1176, 896, 7,062500, 4,289063, 1, 1,250000, 0,710938, '01/01/1900
00:00:00', 3, 1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1)
08/10/2004 17:42:03 ERROR: Unit 1 failed
08/10/2004 17:42:03 Status: Closing Unit 1
08/10/2004 17:42:03 ERROR: Insert dbo.c_database
(run_id,srv_id,inst_id,dbid,name,CompatibilityLevel,CreateDate,DataSpaceUsag
e,IndexSpaceUsage,dbSize,SpaceAvailable,IsSystem,txSize,txSpaceAvailable,txL
astBackup,oRecoveryModel,oPageVerify,oUserAccess,oAutoClose,oAutoShrink,oAut
oCreateStat,oAutoUpdateStat,oOffline,oReadOnly,oSelectIntoBulkCopy,oTruncate
LogOnCheckpoint,oPublished,oSubscribed,oMergePublished,oMergeSubscribed,oFul
lTextEnabled,oDbChaining) Values (2, 1, 1, 1, 'master', 90, '08/04/2003
09:13:36', 1176, 896, 7,062500, 4,289063, 1, 1,250000, 0,710938, '01/01/1900
00:00:00', 3, 1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1)
08/10/2004 17:42:03 ERROR: STLAIVRE998: Collection failed; Error:104;
Provider Error: 110
08/10/2004 17:42:03 ERROR: Critical Repository Failure
08/10/2004 17:42:03 SQLH2 is shutting down
08/10/2004 17:42:03 Closing Log
******************
Did someone got an idea ?
Thanks
Laurent
- Next message: Samuel: "Re: identity seed"
- Previous message: thejamie: "Can I use Crystal to call a view that calls an SQL function"
- Next in thread: Grigory Pogulsky [MS]: "Re: sqlH2 pb with insert statement"
- Reply: Grigory Pogulsky [MS]: "Re: sqlH2 pb with insert statement"
- Messages sorted by: [ date ] [ thread ]