Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Dudzy on November 27, 2012, 01:11:04 AM

Title: ETL error when moving Config Server
Post by: Dudzy on November 27, 2012, 01:11:04 AM

Can anyone assist, moving development environment to a new set of HOSTS, ETL (DataMart) ETL_Tracking is producing an error.

ETL_Tracking*:* 12/11/27 12:05:01.232 EST 16252928 main INFO Starting ConfigServer Synchronization
ETL_Tracking*:* 12/11/27 12:05:01.310 EST 16252928 main INFO Connecting to ConfigServer confserv[melgtslab05:2020] as 'ETL_Proxy'
ETL_Tracking*:* 12/11/27 12:05:03.216 EST 16252928 main INFO Getting Skills from ConfigServer confserv[melgtslab05:2020]
ETL_Tracking*:* 12/11/27 12:05:05.294 EST 16252928 main INFO Getting Agents from ConfigServer confserv[melgtslab05:2020]
ETL_Tracking*:* 12/11/27 12:05:08.169 EST 16252928 main EXCEPT Error Checking ConfigServer for TableRowObject[id: UKey[name: UKey#49'CONFSERVER_ID':1], values: {'CONFSERVER_ID':1, 'CONFSERVER_NAME':confserv, 'CONFSERVER_HOST':melgtslab05, 'CONFSERVER_PORT':2020}][ExcptMsg: null]
ETL_Tracking*:* Stack Trace:
ETL_Tracking*:* java.lang.NullPointerException
ETL_Tracking*:* at com.genesyslab.Infomart.ConfReport.ConfigServerRef.checkAgents(ConfigServerRef.java:200)
ETL_Tracking*:* at com.genesyslab.Infomart.ConfReport.ConfigServerRef.CheckObjects(ConfigServerRef.java:94)
ETL_Tracking*:* at com.genesyslab.Infomart.ConfReport.Application.start(Application.java:279)
ETL_Tracking*:* at com.genesyslab.Infomart.ConfReport.Application.main(Application.java:242)
ETL_Tracking*:* 12/11/27 12:05:08.169 EST 16252928 main INFO Finished ConfServer Synchronization

Title: Re: ETL error when moving Config Server
Post by: Dudzy on November 27, 2012, 02:09:41 AM

update: checking previous log files pre Config Server move, the error was already in logs files, so moving that can be eliminated.

Any assistance would be appreciated

Title: Re: ETL error when moving Config Server
Post by: cavagnaro on November 27, 2012, 04:23:48 AM

Go to ETL tables and change the DBID value on properties table

Title: Re: ETL error when moving Config Server
Post by: Dudzy on November 27, 2012, 05:40:16 AM

Hi cavagnaro

Not sure which table you are referring to directly

With DataMart/ETL schema there is only one table with "properties "as a name  DM_PROPERTIES
With the ODS schema, there is a OL_DB_PROPERTIES table

Are you able to be a little more specific ?

Dave

Title: Re: ETL error when moving Config Server
Post by: borkokrz on November 27, 2012, 08:14:50 AM

Check if DM_KEY\brand field in DM_PROPERTY equals OL_KEY\brand in OL_DB_PROPERTIES.

I've seen java.lang.NullPointerException in one scenario. When using old ETL with newest confserv 8.0+. In this config when person is configured with one of the ranks : Genesys Administrator/Interaction Workspace) you will have similar error. Upgrade ETL to 7.6.000.17+ or make sure that ETL don't have access to this persons. AFAIR this can also occur with persons with over 20 ranks assigned or when using japanese character encoding.

Title: Re: ETL error when moving Config Server
Post by: Adam G. on November 27, 2012, 08:38:25 AM

Check the table CONFIG_SERVER in your Datamart.

Title: Re: ETL error when moving Config Server
Post by: Dudzy on November 30, 2012, 04:33:39 AM

thanks guys, etl upgrade to latest version resolved.