Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Jason.Gill on December 17, 2009, 01:25:37 PM

Title: Infomart Error - ExtractIcon Job not working
Post by: Jason.Gill on December 17, 2009, 01:25:37 PM

Hi Guys,

Iam trying to install infomart in my production environment.The infomart app is installed successfully and the error config check util doesnt throw any errors.

But when Iam trying to run the Extract_Icon job it is throwing an error

ORA-01400: cannot insert NULL into ("STG"."STG_WORKFLOW_STATUS"."DBCONNECTION")

Iam using the latest GA release of infomart 7.6

Has any one faced this kind of an error before?

Thanks,

Title: Re: Infomart Error - ExtractIcon Job not working
Post by: zack31 on December 20, 2009, 10:42:27 PM

I used to get this error from Extract relating to a staging database table with Deleted_TS column. The job was failing as the value of 'null' was in the Deleted_TS column when the only correct valid values for that column are 1 or 0. You will probably need to run a script that ensures the value of null is not present in that table and then re-run your Extract ICON jobs.