Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrades.
Please accept our apologies in advance for any inconvenience this might cause.

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.