Hi guys,
Iīm having a problem with ETL. I have seen that here in the forum there is a similar problem, but refered to older versions of ETL.
The post is http://www.sggu.com/smf/index.php/topic,7523.msg32251.html#msg32251.
In my case i am having the same error message log:
ETL_Tracking: 14/05/16 14:23:01.360 GMT-03:00 128647168 main COMMAND-LINE-OPT conf=etl.properties
ETL_Tracking: 14/05/16 14:23:01.361 GMT-03:00 128647168 main FILE-PROP-OPT {dropTransferredTables=, CfgAppName=ETL_Proxy, jdbcurl=jdbc:db2://130.100.85.254:50001/GEN_ETL, CfgUserPassword=******, user=appcentt, CfgUser=default, CfgAppPassword=, pass=******}
ETL_Tracking: 14/05/16 14:23:01.361 GMT-03:00 128647168 main INFO Starting ConfigServer Synchronization
ETL_Tracking: 14/05/16 14:23:01.380 GMT-03:00 128647168 main INFO Connecting to ConfigServer ODS[vm-central-1:2020] as 'ETL_Proxy'
ETL_Tracking: 14/05/16 14:23:01.501 GMT-03:00 128647168 main INFO Getting Skills from ConfigServer ODS[vm-central-1:2020]
ETL_Tracking: 14/05/16 14:23:01.504 GMT-03:00 128647168 main INFO Getting Agents from ConfigServer ODS[vm-central-1:2020]
ETL_Tracking: 14/05/16 14:23:01.669 GMT-03:00 128647168 main INFO Getting Agent Groups from ConfigServer ODS[vm-central-1:2020]
ETL_Tracking: 14/05/16 14:23:01.669 GMT-03:00 128647168 main INFO Getting Place Groups from ConfigServer ODS[vm-central-1:2020]
ETL_Tracking: 14/05/16 14:23:01.670 GMT-03:00 128647168 main INFO Getting Queue Groups from ConfigServer ODS[vm-central-1:2020]
ETL_Tracking: 14/05/16 14:23:01.946 GMT-03:00 128647168 main EXCEPT Error Checking ConfigServer for TableRowObject[id: UKey[name: UKey#48625'CONFSERVER_ID':100], values: {'CONFSERVER_ID':100, 'CONFSERVER_NAME':ODS, 'CONFSERVER_HOST':vm-central-1, 'CONFSERVER_PORT':2020}][ExcptMsg: null]
ETL_Tracking: Stack Trace:
ETL_Tracking: java.lang.NullPointerException
ETL_Tracking: at com.genesyslab.Infomart.ConfReport.CSObject.<init>(CSObject.java:59)
ETL_Tracking: at com.genesyslab.Infomart.ConfReport.ConfigServerRef.checkDeletedObjects(ConfigServerRef.java:119)
ETL_Tracking: at com.genesyslab.Infomart.ConfReport.ConfigServerRef.CheckObjects(ConfigServerRef.java:98)
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: 14/05/16 14:23:01.946 GMT-03:00 128647168 main INFO Finished ConfServer Synchronization
ETL_Tracking: 14/05/16 14:23:01.946 GMT-03:00 128647168 main END Log closed
ETL_Tracking: ======== =========== === ============== ======= ======= ===========================================================
Regard to this issue, i am having some problems to get historical data from some periods of time, i think both problems are related.
I have read the post i mentioned before but i canīt really understand what DB values i have to modify.
I would be gratefull if you could help me with this.
Some helpful details:
Datamart version: 7.6.100.08
