Hi,
I am new to Commvault and was trying to test some Commcell migration features. But everytime I tried to export from a CommServe, the job gets suspended with an sql failure in the logs.
I did try it on 11.26.0, 11.26.8 and got the same results. Any help on fixing this would be appreciated.
This log segment was taken after performing an export operation on a freshly installed 11.27.1 CommServe with CCM_Feature enabled and EnableCLoudGRCExport additional setting also added.
(All log entries before this were normal and expected)
7100 114c 02/23 16:06:33 6 CVSimpleDB::SQLINFO() - INFO: [RESTORE DATABASE successfully processed 419 pages in 0.031 seconds (105.468 MB/sec).] [RecNum:114, LineNum:1, Spid:80]
7100 114c 02/23 16:06:33 6 CVSimpleDBConnObject::execQuery() - Scrolled through [2] result sets.
7100 114c 02/23 16:06:34 6 CVSimpleDB::SQLINFO() - INFO: [Cannot insert explicit value for identity column in table '#l_CCM_SOURCE_MMLibrary' when IDENTITY_INSERT is set to OFF.] [RecNum:1, Object:CCM_Capture_SubClient, State:23000, NativeErr:544, RowNum:1, Severity:16, LineNum:1, Spid:-1]
7100 114c 02/23 16:06:34 6 CVSimpleDB::SQLINFO() - INFO: [Database name 'tempdb' ignored, referencing object in tempdb.] [RecNum:2, LineNum:1, Spid:-1]
7100 114c 02/23 16:06:34 6 CVSimpleDBConnObject::execQuery() - Failure executing SQL.
SDB Error Code: [5].
Error message: [INFO: [Cannot insert explicit value for identity column in table '#l_CCM_SOURCE_MMLibrary' when IDENTITY_INSERT is set to OFF.] [RecNum:1, Object:CCM_Capture_SubClient, State:23000, NativeErr:544, RowNum:1, Severity:16, LineNum:1, Spid:-1] INFO: [Database name 'tempdb' ignored, referencing object in tempdb.] [RecNum:2, LineNum:1, Spid:-1] ].
SQL Query:[EXEC CCM_Capture_SubClient ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?....]
7100 114c 02/23 16:06:34 6 DBBase-SQL() - dbcursors.cpp:335, Input parameters:
7100 114c 02/23 16:06:34 6 DBBase-SQL() - dbcursors.cpp:336, [1]:[]
7100 114c 02/23 16:06:34 6 DBBase-SQL() - dbcursors.cpp:336, [2]:[2]
7100 114c 02/23 16:06:34 6 DBBase-SQL() - dbcursors.cpp:336, [3]:[0]
7100 114c 02/23 16:06:34 6 DBBase-SQL() - dbcursors.cpp:336, [4]:[0]
7100 114c 02/23 16:06:34 6 DBBase-SQL() - dbcursors.cpp:336, [5]:[1]
7100 114c 02/23 16:06:34 6 DBBase-SQL() - dbcursors.cpp:336, [6]:[1]
7100 114c 02/23 16:06:34 6 DBBase-SQL() - dbcursors.cpp:336, [7]:[1]
7100 114c 02/23 16:06:34 6 DBBase-SQL() - dbcursors.cpp:336, [8]:[1]
7100 114c 02/23 16:06:34 6 DBBase-SQL() - dbcursors.cpp:336, [9]:[Null]
7100 114c 02/23 16:06:34 6 DBBase-SQL() - dbcursors.cpp:336, [10]:[0]
7100 114c 02/23 16:06:34 6 DBBase-SQL() - dbcursors.cpp:336, [11]:[0]
7100 114c 02/23 16:06:34 6 DBBase-SQL() - dbcursors.cpp:336, [12]:[6]
7100 114c 02/23 16:06:34 6 DBBase-SQL() - dbcursors.cpp:336, [13]:[11]
7100 114c 02/23 16:06:34 6 DBBase-SQL() - dbcursors.cpp:336, [14]:[]
7100 114c 02/23 16:06:34 6 DBBase-SQL() - dbcursors.cpp:336, [15]:[0]
7100 114c 02/23 16:06:34 6 DBBase-SQL() - dbcursors.cpp:336, [16]:[CommServ]
7100 3180 02/23 16:06:34 ### OnDemandServiceListener::StartMemberThreadStatic() - Thread terminated normally
7100 114c 02/23 16:06:34 6 CommcellMigration::ccmCaptureClientWithNoSubClients
Capture subclient failed with return [1000] Error Mesg[INFO: [Cannot insert explicit value for identity column in table '#l_CCM_SOURCE_MMLibrary' when IDENTITY_INSERT is set to OFF.] [RecNum:1, Object:CCM_Capture_SubClient, State:23000, NativeErr:544, RowNum:1, Severity:16, LineNum:1, Spid:-1] INFO: [Database name 'tempdb' ignored, referencing object in tempdb.] [RecNum:2, LineNum:1, Spid:-1] ]
7100 114c 02/23 16:06:34 6 CCMigrationJob::startCapture Failed to capture CS client.
7100 114c 02/23 16:06:34 6 CCMigrationJob::startCapture Capture Request failed
7100 114c 02/23 16:06:34 6 CommcellMigration::dropSynonymsCreatedForCaptureSourceDB() - Synonyms Dropped Successfully
7100 114c 02/23 16:06:34 6 CVSimpleDBConnObject::execQuery() - Scrolled through [0] result sets.
7100 114c 02/23 16:06:34 6 CVSimpleDBConnObject::execQuery() - Scrolled through [0] result sets.
7100 114c 02/23 16:06:34 6 CCMigrationJob::WorkPhase Unregistered work-phase for Job [6]. Proceeding.
7100 114c 02/23 16:06:34 6 CCM Job Completed, Job ID = 6
