Originally asked by Bishihai on 24 December 2022 (original question)
Exalate failed to synchronize messages due to Jira address change，so I want update URL but I don’t know the corresponding form of the database。
when I update the issues in my Jira in any way, But The message keeps prompting that it is WAITING FOR REMOTE。
I searched for the update statement, but did not know the database form。
UPDATE FROM “AO_08F1AF_INSTANCE” SET “URL” = ‘new url’, “ISSUE_TRACKER_URL”= ‘new url’ where “URL” = ‘old url’;
UPDATE FROM “AO_08F1AF_NODE_INFO” SET “BASE_URL” = ‘new url’, “ISSUE_TRACKER_URL”= ‘new url’ where “BASE_URL” = ‘old url’;
How to Change the Destination Instance URL? | Exalate Documentation
Comments:
Serhiy Onyshchenko commented on 27 December 2022
Hello, Bishihai , is the size of sync queue (outgoing sync) on sending end equal to the size of the incoming sync on the receiving end?
Serhiy Onyshchenko commented on 27 December 2022
You may also
UPDATE "AO_08F1AF_SYNC_EVENT" SET "EVENT_STATUS" = 'SEND_REQUEST' WHERE "EVENT_STATUS" = 'WAITING_FOR_RESPONSE';
Regards, Serhiy.