You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.