Symantec Management Platform (SMP) Community

Hi,

We have created a Resource DataClass item in the config file with proper schema information. We haved added a new column in the data class in current release which is not available in the prior releases of our project. Now when I tried to upgrade my solution from one of our old releases build to the current one, I got the error during configuration that "<New_Column> does not exist ( where "New_Column" is the name of the newly added column in the data class )

I have added a custom logic to alter the above resource dataclass table in case of Upgrade and add the newly added column but I am getting following error during configuration:-

"Failed to confirm schema. Error:Class Name: Image Resource Component Class Guid: e32ba902-73ad-480a-94f9-aafa05db5ad5"

Does anyone have idea of how to handle this scenario in case of Upgrade ?

Regards,

Peeyush Dongre

You can use upgradeMode="Overwrite" attribute while you configure the database during upgrade, Also make sure newly added column not be refernced prior to this configuration.

Thanks,

Abhinav Sharma

Hi,

I have added "upgradeMode=Overwrite" attribute in the resource data class item while configuration and also moved the stored procedure where I was referring newly added column in the PostInstallSQL config file so that the new column should not be referenced prior to this configuration.

Thanks for all the help.