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

**URL:** <https://community.exalate.com/t/i-want-update-url-but-i-dont-know-the-corresponding-form-of-the-database/5385>\
**Category:** General Questions\
**Tags:** exalate, migrated\_question\
**Created:** [November 4, 2024, 8:01am UTC](https://community.exalate.com/t/i-want-update-url-but-i-dont-know-the-corresponding-form-of-the-database/5385 "2024-11-04T08:01:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![xl8bot](https://dub1.discourse-cdn.com/flex018/user_avatar/community.exalate.com/xl8bot/32/324_2.png) [@xl8bot](https://community.exalate.com/u/xl8bot)\
**Post date:** [November 4, 2024, 8:01am UTC](https://community.exalate.com/t/i-want-update-url-but-i-dont-know-the-corresponding-form-of-the-database/5385/1 "2024-11-04T08:01:23Z")

</div>

_Originally asked by Bishihai on 24 December 2022 [(original question)](https://oldcommunity.exalate.com/questions/58497996)_

* * *

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](https://docs.exalate.com/docs/how-to-change-the-destination-instance-url)

* * *

#### 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
> 
> ```auto
> UPDATE "AO_08F1AF_SYNC_EVENT" SET "EVENT_STATUS" = 'SEND_REQUEST' WHERE "EVENT_STATUS" = 'WAITING_FOR_RESPONSE';
> 
> ```
> 
> Regards, Serhiy.

---

<div class="post-metadata">

**Author:** ![Majid](https://dub1.discourse-cdn.com/flex018/user_avatar/community.exalate.com/majid/32/343_2.png) [@Majid](https://community.exalate.com/u/Majid)\
**Post date:** [December 4, 2024, 9:15am UTC](https://community.exalate.com/t/i-want-update-url-but-i-dont-know-the-corresponding-form-of-the-database/5385/2 "2024-12-04T09:15:28Z")

</div>