Symptoms

The following appears in the atlassian-jira.log:

2012-09-15 10:01:31,671 main ERROR      [sal.core.lifecycle.DefaultLifecycleManager] Unable to start component: $Proxy527
java.lang.RuntimeException: Failed to parse AuditLogEntry from JSON string: {"username":"vkharisma","date":1311084545403,"i18nKey":"upm.auditLog.install.plugin.failure","params":["C:\IT\Network\Software\JIRA\jira-workplan-report-plugin-1.0-SNAPSHOT.jar"]}
	at com.atlassian.upm.log.PluginSettingsAuditLogService$4.apply(PluginSettingsAuditLogService.java:504)

Diagnosis

The file path is not properly escaped. it should be C:\\ instead of C:\

Cause

The UPM has stored the file path UN-escaped, but when reading it now the UPM fails and throws an exception complaining that it can't read this entry. This is a bug being tracked here: UPM-1171.

Resolution

1. Execute the following SQL query

   SELECT * FROM propertytext where id = (SELECT id
   FROM propertyentry LIKE property_key = 'com.atlassian.upm.log.PluginSettingsAuditLogService:log:upm_audit_log_v%');

2. Copy the content of propertyvalue column to a Text editor

3. Find the problematic value, in this case

   {"username":"vkharisma","date":1311084545403,"i18nKey":"upm.auditLog.install.plugin.failure","params":["C:\IT\Network\Software\JIRA\jira-workplan-report-plugin-1.0-SNAPSHOT.jar"]}

4. Execute the following SQL query

   DELETE FROM propertytext where id = (SELECT id FROM propertyentry LIKE property_key = 'com.atlassian.upm.log.PluginSettingsAuditLogService:log:upm_audit_log_v%');