Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: S2H on April 23, 2015, 11:11:59 AM

Title: missing data in infomart
Post by: S2H on April 23, 2015, 11:11:59 AM

hi,
  We made some test calls and the calls exist in GIDB but the calls are not in the INFOMART. I have checked all the jobs, and it is working fine.We are missing the calls in infomart. Please help, regarding this issue.

Title: Re: missing data in infomart
Post by: Kubig on April 23, 2015, 11:31:13 AM

Without any deep information like what logs say, what is status on DB level, etc. In any case, did you open a #SR with Genesys customer care?

Title: Re: missing data in infomart
Post by: OXE_4400 on April 29, 2015, 10:02:36 AM

Have You managed InfoMart connections to ICON_CFG, ICON_CORE, both DAP's, DAP for InfoMart?
Is it correct role management in ICON ?
Have You apllied ICON DB (at least CFG and CORE/VOICE) upgrade for InfoMart?
A lot of places need to check.

Title: Re: missing data in infomart
Post by: pmsylla on November 03, 2015, 03:44:21 PM

thank you.

Title: Re: missing data in infomart
Post by: Campfire on November 04, 2015, 04:56:51 AM

Hi Guys, I am also facing a similar problem like not all calls are apperaing in the infomart DB which are in ICON DB. Ran through the T-server log and all the events are occuring fine. Any inputs please?

Title: Re: missing data in infomart
Post by: Kubig on November 04, 2015, 07:32:48 AM

Check a status of the GIM jobs as first

Title: Re: missing data in infomart
Post by: Campfire on November 05, 2015, 06:13:27 AM

Hi Kubig,

All the jobs were running fine except the one below but that too again was completed successfully. So, is there some problem with the calls where they were not completed properly or something? But the VQ is being captured in the EventRouteUsed in the URS logs. Any ideas?

JOB_ID JOB_NAME WORKFLOW_TYPE JOB_VERSION START_TIME END_TIME DURATION STATUS
Job_ExtractICON@1446016901177 Job_ExtractICON EXTRACT 8.1.202.04 2015-10-28 07:21:41.300 2015-10-28 07:21:54.323 13 FAILED
Job_ExtractICON@1446016901177 Job_ExtractICON INIT 8.1.202.04 2015-10-28 07:21:41.180 2015-10-28 07:21:41.200 0 COMPLETE
Job_ExtractICON@1446016901177 Job_ExtractICON TRUNCATE_TMP 8.1.202.04 2015-10-28 07:21:41.207 2015-10-28 07:21:41.290 0 COMPLETE

Title: Re: missing data in infomart
Post by: nonny on November 05, 2015, 09:25:35 AM

Are your idb cfg tables populated?

Sent from my SM-N9005 using Tapatalk

Title: Re: missing data in infomart
Post by: Campfire on November 05, 2015, 09:38:22 AM

Ya, but there are no entries for some calls in Infomart DB which makes a difference the count between ICON DB (g_virtual_queue) and Infomart DB (g_virtual_queue_v) for the calls processed by a particular VQ. Did I explain it properly? Please let me know if its not clear so that I will try to share more info.

Title: Re: missing data in infomart
Post by: Kubig on November 05, 2015, 11:19:06 AM

You have mentioned just Extract job, which is not enough - did you check status of rest of the GIM jobs?

Title: Re: missing data in infomart
Post by: Campfire on November 05, 2015, 12:54:30 PM

Hi Kubig, thanks for pointing it.. Can see the below jobs ran successfully for the day. So seems no problems with the jobs?

Job_AggregateGIM
Job_ExtractICON
Job_MaintainGIM
Job_TransformGIM