Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Getting error while upgrading ResourceDataClass table.

Created: 29 Mar 2012 • Updated: 10 May 2012 | 2 comments
peeyushd's picture
This issue has been solved. See solution.

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

 

Comments 2 CommentsJump to latest comment

Abhinav Sharma's picture

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

SOLUTION
peeyushd's picture

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.