Skip to main content
commvault.com commvault.com
Question

Error during CommServe Upgrade - Cannot insert the value NULL into column 'password'

  • December 15, 2025
  • 2 replies
  • 11 views
I
Novice
Forum|alt.badge.img+11

Hi,

The below error is generated in the post upgrade phase of the a CommServe upgrade from 11.36.68 to 11.40.26.

Install.log

2196  7     12/10 14:17:52 ### ### ### - Performing  PostUpgrade tasks for the databases...
2196  7     12/10 14:17:52 ### ### ### - Please check [E:\Program Files\Commvault\ContentStore\Log Files\DatabaseUpgrade.log] for granular details
2196  7     12/10 14:17:53 ### ### ### - Warning: ["E:\Program Files\Commvault\ContentStore\Base\CvDBUpgradeWrapper.exe" -install -phasename PostUpgrade -clientname 'CommServe' -instance Instance001 -productname ALL -ProductVersion 11.40.26 -oemId 1 -DBUpgradeDir "E:\Program Files\Commvault\ContentStore\Base\DBUpgrade" -DBBackupDir "E:\Program Files\Commvault\ContentStore\iDataAgent\JobResults" -log "E:\Program Files\Commvault\ContentStore\Log Files" -DoNotBackupDB  -resume ] exit code 2 
2196  7     12/10 14:17:53 ### ### ### - Error: Failed to complete  PostUpgrade tasks for the databases.
2196  7     12/10 14:17:53 ### ### ### - Error: Failed post install configuration for the databases.

 

DatabaseUpgrade.log

4616 25f4  12/10 14:17:52 ### DBUpgrade::executePhase() - <?xml version="1.0" encoding="UTF-8" standalone="no" ?><CVDBUpgrade_ProcessPhase currentFileName="UpgradePostgreSQLCredentialsToUseCM.sql" currentLstFileName="PostUpgrade.lst" currentStep="1" phaseName="PostUpgrade" resume="0"/>
24616 25f4  12/10 14:17:52 ### INIFileProcessor::validatePhase() - Validating Phase [PostUpgrade].
24616 25f4  12/10 14:17:52 ### INIFileProcessor::processPhase() - Processing Phase [PostUpgrade].
24616 25f4  12/10 14:17:52 ### INIFileProcessor::executeSQLList() - Processing list file [E:\Program Files\Commvault\ContentStore\Base\DBUpgrade\CommServer\PostUpgrade\PostUpgrade.lst].
24616 25f4  12/10 14:17:53 ### INIFileProcessor::executeSQLList() - Executing file [E:\Program Files\Commvault\ContentStore\Base\DBUpgrade\CommServer\PostUpgrade\UpgradePostgreSQLCredentialsToUseCM.sql].
24616 25f4  12/10 14:17:53 ### CVSimpleDB::SQLINFO() - INFO: [Error running script. Error code: 515       , Cannot insert the value NULL into column 'password', table 'CommServ.dbo.APP_Credentials'; column does not allow nulls. INSERT fails.] [RecNum:1, LineNum:371, Spid:74] 
24616 25f4  12/10 14:17:53 ### CVSimpleDB::SQLINFO() - INFO: [ERROR CODE: 515 ERROR LINE: 139 ERROR STRING: Cannot insert the value NULL into column 'password', table 'CommServ.dbo.APP_Credentials'; column does not allow nulls. INSERT fails.] [RecNum:1, LineNum:376, Spid:74] 
24616 25f4  12/10 14:17:53 ### CVSimpleDB::SQLINFO() - INFO: [Cannot insert the value NULL into column 'password', table 'CommServ.dbo.APP_Credentials'; column does not allow nulls. INSERT fails.] [RecNum:1, State:23000, NativeErr:515, RowNum:1, Severity:16, LineNum:139, Spid:74] 
24616 25f4  12/10 14:17:53 ### INIFileProcessor::executeSQLList() - INFO: [Error running script. Error code: 515       , Cannot insert the value NULL into column 'password', table 'CommServ.dbo.APP_Credentials'; column does not allow nulls. INSERT fails.] [RecNum:1, LineNum:371, Spid:74] INFO: [ERROR CODE: 515 ERROR LINE: 139 ERROR STRING: Cannot insert the value NULL into column 'password', table 'CommServ.dbo.APP_Credentials'; column does not allow nulls. INSERT fails.] [RecNum:1, LineNum:376, Spid:74] INFO: [Cannot insert the value NULL into column 'password', table 'CommServ.dbo.APP_Credentials'; column does not allow nulls. INSERT fails.] [RecNum:1, State:23000, NativeErr:515, RowNum:1, Severity:16, LineNum:139, Spid:74] 
24616 25f4  12/10 14:17:53 ### INIFileProcessor::executeSQLList() - Execution of file [E:\Program Files\Commvault\ContentStore\Base\DBUpgrade\CommServer\PostUpgrade\UpgradePostgreSQLCredentialsToUseCM.sql] failed

 

 

The upgrade was reverted by means of a VMWare snapshot.

I was wondering if there is a way that the offending entry in the table “CommServ.dbo.APP_Credentials” could be identified and corrected.

 

Thanks.

Ignes

 

2 replies

P
Vaulter
Forum|alt.badge.img+12
  • PradeepVaulter
  • Vaulter
  • December 16, 2025

Hi ​@Iggy ,

Thanks for sharing the detailed information related to upgrade failure. Based on the error, I understand that one of the PostgreSQL database credentials is causing a conflict during execution. UpgradePostgreSQLCredentialsToUseCM.sql.


suspect that one of the database client credentials has not been updated, which is preventing a null value from being inserted. I would appreciate it if we could create support tickets with the current set of logs, as this will help us identify the root cause and provide a permanent solution.

D
D
Vaulter
Forum|alt.badge.img+8

Hi ​@Iggy ,

CommServe upgrade from SP36 to 11.40.26 is failing during the PostUpgrade phase due to SQL Error 515. During this phase, the post-upgrade script 'UpgradePostgreSQLCredentialsToUseCM.sql' attempts to insert credential records into CommServ.dbo.APP_Credentials. However, at least one source configuration contains a NULL password, which violates the table’s NOT NULL constraint. This is a known issue observed in similar upgrades and typically occurs during the migration of PostgreSQL credentials to Commvault’s centralized Credential Manager.

This error occurs at runtime when a NULL value is inserted into or used to update a column that does not permit NULL values. It may also occur if a target table for an INSERT or UPDATE operation is dropped and re-created with one or more columns changed from NULL to NOT NULL.

Next Steps:
==
- If you have access to SQL Server Management Studio (SSMS) on the CommServe, manually run the script ‘UpgradePostgreSQLCredentialsToUseCM.sql' located at: E:\Program Files\Commvault\ContentStore\Base\DBUpgrade\CommServer\PostUpgrade\ and verify whether it executes successfully.

- From SSMS, run the following query to review existing credentials:

USE CommServ;
SELECT * FROM app_credentials;

- In Credential Manager, ensure all required credentials are properly configured. Identify any source configuration with a missing password and correct or remove it (through the Commvault UI).

- Once addressed, take a VM snapshot and rerun SP40 upgrade so the post-upgrade process can complete successfully. If the issue persists, it is recommended to log a support case with Commvault.


DatabaseUpgrade.log
==
24616 25f4  12/10 14:17:52 ### INIFileProcessor::executeSQLList() - Processing list file [E:\Program Files\Commvault\ContentStore\Base\DBUpgrade\CommServer\PostUpgrade\PostUpgrade.lst].
24616 25f4  12/10 14:17:53 ### INIFileProcessor::executeSQLList() - Executing file [E:\Program Files\Commvault\ContentStore\Base\DBUpgrade\CommServer\PostUpgrade\UpgradePostgreSQLCredentialsToUseCM.sql].
24616 25f4  12/10 14:17:53 ### CVSimpleDB::SQLINFO() - INFO: [Error running script. Error code: 515       , Cannot insert the value NULL into column 'password', table 'CommServ.dbo.APP_Credentials'; column does not allow nulls. INSERT fails.] [RecNum:1, LineNum:371, Spid:74] 
24616 25f4  12/10 14:17:53 ### CVSimpleDB::SQLINFO() - INFO: [ERROR CODE: 515 ERROR LINE: 139 ERROR STRING: Cannot insert the value NULL into column 'password', table 'CommServ.dbo.APP_Credentials'; column does not allow nulls. INSERT fails.] [RecNum:1, LineNum:376, Spid:74] 
24616 25f4  12/10 14:17:53 ### CVSimpleDB::SQLINFO() - INFO: [Cannot insert the value NULL into column 'password', table 'CommServ.dbo.APP_Credentials'; column does not allow nulls. INSERT fails.] [RecNum:1, State:23000, NativeErr:515, RowNum:1, Severity:16, LineNum:139, Spid:74] 
.. 
24616 25f4  12/10 14:17:53 ### INIFileProcessor::executeSQLList() - Execution of file [E:\Program Files\Commvault\ContentStore\Base\DBUpgrade\CommServer\PostUpgrade\UpgradePostgreSQLCredentialsToUseCM.sql] failed


Regards,

Dheeraj

Terms & ConditionsCookie settingsAccessibility statement