" /> purge all gim database tables - Genesys CTI User Forum

Author Topic: purge all gim database tables  (Read 821 times)

Offline abdel

  • Newbie
  • *
  • Posts: 24
  • Karma: 0
purge all gim database tables
« on: August 31, 2023, 08:32:50 AM »
Advertisement
Hello,

Our GIM database was populated by another environement data and  it's a total mess, so all dimension tables are not sync with config database, even with new extract cycle , since the objects belongs to another environement, they will never be updated because they have different IDs in dimension table.

Is there a way to purge all tables from the database, if there is one? how to run GIM ETL so it can populate all tables?
Otherwise, is there way to to purge only dimension tables.
days-to-keep-cfg-facts is not enough since it doesn't purge all config related tables.

Offline abdel

  • Newbie
  • *
  • Posts: 24
  • Karma: 0
Re: purge all gim database tables
« Reply #1 on: September 22, 2023, 12:42:08 PM »
Or at least the table gidb_gc_skill, changing deleted_ts to a date doesn't help

Offline jag

  • Newbie
  • *
  • Posts: 16
  • Karma: 0
Re: purge all gim database tables
« Reply #2 on: September 30, 2023, 12:14:30 AM »
try re-run initialize GIM job