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.
Project managers know this problem: A “mountain of work” lays in front of you, and you don’t know how and where to tackle them. Different to-dos lie ahead, but just one task after the other can be ha...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events