Macros not working

Question

Upgraded version to 4.0.3. The following macros throw error while installing:

1. Macro: Attachment

Error Message: Error rendering macro 'attachment' : null

2. Macro: builder-breadcrumbs

Error Message: Error rendering macro 'builder-breadcrumbs' : com.atlassian.renderer.v2.macro.MacroException: This macro may only be used within a builder panel

3. Macro: builder-sidebar

Error Message:

Error rendering macro 'builder-sidebar' : com.atlassian.renderer.v2.macro.MacroException: This macro may only be used within a builder panel

4. Macro: Embed

Error Message:

Error rendering macro 'embed' : null

5. Macro: Insert ‘Excel’

Error Message:

Error rendering macro 'excel' : com.atlassian.renderer.v2.macro.MacroException: Either the file or url parameter is required.

6. Macro: Knowledge Base Survey

Error Message:

Error rendering macro 'kbsurvey' : null

7. Macro: Top Ranked Articles

Error Message:

Error rendering macro 'kbtoparticles' : Hibernate operation; bad SQL grammar ; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence.os_propertyentry' doesn't exist

8. Macro: set-flag

Error Message:

Error rendering macro 'set-flag' : com.atlassian.renderer.v2.macro.MacroException: A flag name is required

Rodrigo Girardi Adami · Answer

Hi Kavita,

Are you able to replicate this behavior in the newer confluence versions? I believe this error could be caused by some corruption in the plugin system of confluence and you can try to reset the plugin system using this documentation and also run the query below to clear all third party plugins:

DELETE FROM plugindata;

Note this will remove all third party plugins and you'll have to install them again. This might do the trick.

Cheers,

Rodrigo

David at David Simpson Apps · Answer

* Browse to Confluence Admin | Configuration | Plugins and check that these are all present and fully enabled -- all modules are enabled.
* Check that versions of each of the these plugins that is installed is Confluence 4.0.x compatible 
e.g. see Theme Builder - Confluence 4 EAP for information on a Confluence 4.x compatible version of Theme Builder
* Upgrade (or perhaps disable) all the macros that are not compatible with Confluence 4.x
* Troubleshoot the remaining problem plugins