I want update URL but I don't know the corresponding form of the database

 
1
0
-1

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

  1. Serhiy Onyshchenko

    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?

  2. Serhiy Onyshchenko

    You may also

    UPDATE "AO_08F1AF_SYNC_EVENT" SET "EVENT_STATUS" = 'SEND_REQUEST' WHERE "EVENT_STATUS" = 'WAITING_FOR_RESPONSE';

    Regards, Serhiy.

CommentAdd your comment...