Can't install any apps after migrating from cloud

[Francois-Alexandre_Perreault]

I just migrated from Confluence Cloud to Server and had many issues (user passwords didn't follow, system administrator permissions were removed) but all could be fixed from the database. 

Now every time I try to install an app from my site, I get an error message telling me an error occurred and to check logs. I looked at the logs and this is what seems to be coming back :

Caused by: org.codehaus.jackson.map.exc.UnrecognizedPropertyException: Unrecognized field "accountId" (Class com.atlassian.upm.core.log.AuditLogEntryImpl), not marked as ignorable
at [Source: java.io.StringReader@2f8fe060; line: 1, column: 228] (through reference chain: com.atlassian.upm.core.log.AuditLogEntryImpl["accountId"])
...

2019-06-21 09:28:00,479 WARN [Caesium-1-1] [impl.schedule.caesium.JobRunnerWrapper] runJob Scheduled job LaasPerformanceLoggingJob#LaasPerformanceLoggingJob completed unsuccessfully with response JobRunnerResponse[runOutcome=ABORTED,message='LaaS performance logging is turned off']
2019-06-21 09:30:00,022 ERROR [Caesium-1-1] [scheduler.caesium.impl.CaesiumSchedulerService] executeClusteredJobWithRecoveryGuard Unhandled exception during the attempt to execute job 'reminderTrigger'; will attempt recovery in 60 seconds
...

2019-06-21 09:31:00,024 WARN [Caesium-1-1] [scheduler.caesium.impl.CaesiumSchedulerService] runJob Recovery job completed successfully; resuming normal operation
2019-06-21 09:33:00,482 WARN [Caesium-1-4] [impl.schedule.caesium.JobRunnerWrapper] runJob Scheduled job LaasPerformanceLoggingJob#LaasPerformanceLoggingJob completed unsuccessfully with response JobRunnerResponse[runOutcome=ABORTED,message='LaaS performance logging is turned off']
2019-06-21 09:35:00,018 ERROR [Caesium-1-2] [scheduler.caesium.impl.CaesiumSchedulerService] executeClusteredJobWithRecoveryGuard Unhandled exception during the attempt to execute job 'reminderTrigger'; will attempt recovery in 60 seconds
...
Caused by: com.atlassian.scheduler.core.JobRunnerNotRegisteredException: No job runner registered for job runner key 'com.atlassian.confluence.extra.team-calendars:reminderJob'
...
2019-06-21 09:35:29,723 WARN [http-nio-8090-exec-5] [atlassian.upm.pac.PacClientImpl] getUpdates The request to check for add-on updates may take longer than expected because 202 user-installed add-ons are installed. This may impact the performance of loading the Manage Add-ons page.
...
Caused by: org.codehaus.jackson.map.exc.UnrecognizedPropertyException: Unrecognized field "accountId" (Class com.atlassian.upm.core.log.AuditLogEntryImpl), not marked as ignorable
...
2019-06-21 09:35:40,846 ERROR [UpmAsynchronousTaskManager:thread-3] [atlassian.upm.impl.SelfUpdateControllerImpl] prepareSelfUpdate Unable to install self-update plugin: java.lang.RuntimeException: Failed to parse AuditLogEntry from JSON string: {"userKey":"","accountId":"anonymous","date":1561055590802,"i18nKey":"upm.auditLog.auto.update.plugin.failure.needs.permission","entryType":"AUTO_PLUGIN_UPDATE","params":["Qron Calc Macro - Excel formula in table","1.1.47-AC"]}
-- url: /rest/plugins/1.0/ | referer: http://training.cienapps.com/plugins/servlet/upm?source=side_nav_manage_addons | traceId: 7ee2100bfb247876 | userName: faperreault
2019-06-21 09:36:00,021 WARN [Caesium-1-1] [scheduler.caesium.impl.CaesiumSchedulerService] runJob Recovery job completed successfully; resuming normal operation
2019-06-21 09:38:00,325 ERROR [Caesium-1-2] [scheduler.caesium.impl.CaesiumSchedulerService] executeClusteredJobWithRecoveryGuard Unhandled exception during the attempt to execute job 'zipperProgressCleaningJob'; will attempt recovery in 60 seconds
...
Caused by: com.atlassian.scheduler.core.JobRunnerNotRegisteredException: No job runner registered for job runner key 'zipperProgressCleaningJob'
...
2019-06-21 09:38:00,479 WARN [Caesium-1-4] [impl.schedule.caesium.JobRunnerWrapper] runJob Scheduled job LaasPerformanceLoggingJob#LaasPerformanceLoggingJob completed unsuccessfully with response JobRunnerResponse[runOutcome=ABORTED,message='LaaS performance logging is turned off']
2019-06-21 09:38:16,546 INFO [http-nio-8090-exec-8] [synchrony.service.http.SynchronyRequestExecutor] execute Initiating request PUT http://127.0.0.1:8091/synchrony/v1/data/Synchrony-005d063c-2a12-3869-b419-18d4989ac439/confluence-289210519 HTTP/1.1 for 289210519
2019-06-21 09:38:17,010 INFO [http-nio-8090-exec-8] [synchrony.service.http.SynchronyRequestExecutor] execute Initiating request PUT http://127.0.0.1:8091/synchrony/v1/data/Synchrony-005d063c-2a12-3869-b419-18d4989ac439/confluence-289210519 HTTP/1.1 for 289177727
2019-06-21 09:39:00,332 WARN [Caesium-1-3] [scheduler.caesium.impl.CaesiumSchedulerService] runJob Recovery job completed successfully; resuming normal operation
2019-06-21 09:40:00,014 ERROR [Caesium-1-3] [scheduler.caesium.impl.CaesiumSchedulerService] executeClusteredJobWithRecoveryGuard Unhandled exception during the attempt to execute job 'reminderTrigger'; will attempt recovery in 60 seconds
...
Caused by: com.atlassian.scheduler.core.JobRunnerNotRegisteredException: No job runner registered for job runner key 'com.atlassian.confluence.extra.team-calendars:reminderJob'
...
2019-06-21 09:40:53,213 WARN [http-nio-8090-exec-6] [atlassian.upm.pac.PacClientImpl] getUpdates The request to check for add-on updates may take longer than expected because 203 user-installed add-ons are installed. This may impact the performance of loading the Manage Add-ons page.
-- referer: http://training.cienapps.com/plugins/servlet/upm | url: /rest/plugins/1.0/installed-marketplace | traceId: de942cf5c38a526f | userName: faperreault
2019-06-21 09:41:00,018 WARN [Caesium-1-2] [scheduler.caesium.impl.CaesiumSchedulerService] runJob Recovery job completed successfully; resuming normal operation

I took a look for some of these message without any luck. Some pointed to my site URL being improperly set but I double checked. 

This seems very relevant too but it's for Jira and the database queries do not apply to my DB : https://community.atlassian.com/t5/Jira-questions/Can-t-add-apps-after-migrate-local-server-to-cloud/qaq-p/1026093

Anybody else ran into a similar issue? 

[Thomas Wohlwend]

I found the fix / workaround. Worked perfectly for me:

https://jira.atlassian.com/browse/CONFSERVER-58152?_ga=2.4363761.39916435.1560891322-410129071.1559914118

[Thomas Wohlwend]

I have the same problem. It seems there were Application Installation Log Entries migrated from the Cloud Instance which the UPM on the Server Instance can not read/parse. I was able to fix the same Problem in Jira, with the help of this query:

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

taken from https://confluence.atlassian.com/jirakb/audit-log-contains-java-lang-runtimeexception-failed-to-parse-auditlogentry-from-json-string-303661433.html

But the database structure is different in confluence and I was not able to find the migrated entries. Alas, the addons do install and uninstall despite of the error. But it is not possible to update the UPM.