Audit log contains 'java.lang.RuntimeException: Failed to parse AuditLogEntry from JSON string:'
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
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%');
Copy the content of propertyvalue column to a Text editor
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"]}
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%');