Solved

SQL Failure during CCM-Export?

  • 23 February 2022
  • 3 replies
  • 148 views

Badge +1

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

icon

Best answer by adisai 23 February 2022, 22:10

View original

If you have a question or comment, please create a topic

3 replies

Userlevel 3
Badge +6

Hi @adisai 

Are you trying to import the CCM data from FR27 to FR26? I will suggest to open a support case to get this check

 

Regards,

 

 

 

Badge +1

I was attempting just an export on source CommCell. Anyway, I found the solution with some help from CCM devs, my machine had an installation of MS SQL Express Edition which is not usually shipped to customers. Upgrading to Standard Edition fixed this issue.

Userlevel 7
Badge +23

I haven’t seen that issue in YEARS!!!  Good catch with everyone involved :nerd: