" /> Data from ICON database has stopped transferring into INFOMART - Genesys CTI User Forum

Author Topic: Data from ICON database has stopped transferring into INFOMART  (Read 2386 times)

Offline mohit

  • Newbie
  • *
  • Posts: 12
  • Karma: 0
Advertisement
Hi,

I am working on Genesys 8.0 environment. Currently I am facing issue in my lab environment, wherein my data which was getting transferred to my GIM database without any issues for 4-5 days, has stopped transferring.

I could see my interactions in ICON databases. When I run Extract_JOBICON, it completes without any error and maintain and transform also goes the same way. I don't see any error in my gim_etl logs too.

Wondering what might be the issue, that has stopped by data to transfer to the GIM.

Any help for the same will be highly appreciated. ::)

Regards,

Mohit

Offline smile

  • Sr. Member
  • ****
  • Posts: 286
  • Karma: 6
Re: Data from ICON database has stopped transferring into INFOMART
« Reply #1 on: April 06, 2011, 12:24:00 PM »
did you run load and aggregate jobs? how you chech the existance of records in gim database? is the options populate-xxx-facts turned on?

Offline mohit

  • Newbie
  • *
  • Posts: 12
  • Karma: 0
Re: Data from ICON database has stopped transferring into INFOMART
« Reply #2 on: April 06, 2011, 01:21:59 PM »
Hey,

I don't run the aggregate job. I run Extract & Transform job. Mantain job is scheduled. I can see data directly into the tables of GIM database.

Regards,
Mohit

Offline fnunezsa

  • Full Member
  • ***
  • Posts: 213
  • Karma: 5
Re: Data from ICON database has stopped transferring into INFOMART
« Reply #3 on: April 06, 2011, 03:27:35 PM »
You MUST run Load Recent, Load GIM and Aggregate GIM if you want to see new records in GIM database.

Offline mohit

  • Newbie
  • *
  • Posts: 12
  • Karma: 0
Re: Data from ICON database has stopped transferring into INFOMART
« Reply #4 on: April 07, 2011, 04:57:37 AM »
Hi,

We don't have any options for Load Recent, Load GIM in GIM 8.0.

In 8.0, we only need to run Extract_ICON >> Transform for getting the data. Running aggregate is optional.

mohit

Offline smile

  • Sr. Member
  • ****
  • Posts: 286
  • Karma: 6
Re: Data from ICON database has stopped transferring into INFOMART
« Reply #5 on: April 07, 2011, 07:10:10 AM »
oh, gim version 8... what about loading? ETL cycle without load job looks unaccomplished

Offline fnunezsa

  • Full Member
  • ***
  • Posts: 213
  • Karma: 5
Re: Data from ICON database has stopped transferring into INFOMART
« Reply #6 on: April 07, 2011, 07:06:32 PM »
Sorry. You didn't mention your GIM version and I assumed it was 7.6 or earlier...