Using Windows Server 2012 R2 and latest Confluence x64.
After yesterday's team calendars plug-in update they no longer render. I googled this and tried clearing the confluence home plugin folders then started the windows service again and I still get:
Error rendering macro 'calendar' : bundle [com.atlassian.confluence.extra.team-calendars]
The issue was caused due to a schema change for AO prefixed tables where someone changed various column types to unicode equivalents, i.e. what was varchar is now nvarchar in SQL Server. This broke my confluence install and I'm sure many others will suffer the same, if not already. The page about this is at https://confluence.atlassian.com/display/CONFKB/Confluence+upgrade+fails+because+SQL+Server+could+not+complete+schema+update.
The backup/restore option failed due to primary key conflicts on restore - XML backup/restore is hard broke! I would have had to change 60 tables and the columns within manually but I had an idea as I'm a software developer to use my Red Gate SQL COMPARE tool to compare my current schema against the new schema created during this triage process. The product generated the change script when comparing the schemas, I shut down the confluence windows service and applied the schema change and then started up confluence again and it worked perfectly. Hope this will help anyone else that may suffer this unfortunate breaking change in this product.
It seems that the plugin update didn't work well and got corrupted.
I suggest we reinstall the plugin following the below steps:
This should do the trick.
If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot