Search only in titles

---

Check Sync Process Running

To confirm if the sync process is running, check the server.log for details or the progress from the database.

Connect as 'T_SYNCUSER' (source.db.syncuser created on the same Oracle instance where P6 is the source database) and execute the following:

• To see the details of the file you just successfully posted to the database:

  select * from sync_config;

• To provide an update of the global tables being synced and the status of the sync process for each specific table. The entry_value column status will be changed from NEW to COMPLETE, you can check the corresponding global table data in target admuser schema.

  select * from sync_control;

• To see all the projects registered to be synced:

  select * from sync_whitelist;

  Already synced projects will have a status of SENT.

  Projects that are waiting to be synced will have a status of NEW.

  If the project status is sent, you can check the corresponding project data in target admuser schema.

• To see blob records corresponding to the source admuser schema:

  select * from sync_transfer_data;

  It contains the source admuser data in the form of blob records and will transfer the data to target admuser schema. Each blob record having the status from SAVING, SAVED and SENT in t_syncuser schema. Th sync process picks the records whose status is SAVED and will transfer the data. Check the log/server.log for any errors.

---

Last Published Friday, December 8, 2023