NullPointerException

[Anonymous]

Can anyone advise what is the correct jdbc connection string for a MySQL db or whether the error below is being caused by something else?
I've got:

pumper.sql.url=jdbc:mysql://localhost:3306/datapump1

and I get the error:

:~/datapump# java -jar servicenow-sql-pump.jar -p datapump.properties -f load_location.txt
INFO DataPump.Pumper propfile=datapump.properties
INFO DataPump.DatabaseWriter database=jdbc:mysql://localhost:3306/datapump1 user=datapump1
INFO DataPump.DatabaseWriter set time_zone = '+0:00'
INFO DataPump.DatabaseWriter set sql_mode='ANSI_QUOTES'
Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.simontuffs.onejar.Boot.run(Boot.java:342)
at com.simontuffs.onejar.Boot.main(Boot.java:168)
Caused by: java.lang.NullPointerException
at servicenow.community.soap.GlideTableSchema.<init>(Unknown Source)
at servicenow.community.soap.GlideTable.loadSchema(Unknown Source)
at servicenow.community.soap.Instance.<init>(Unknown Source)
at servicenow.community.soap.Instance.<init>(Unknown Source)
at servicenow.community.sql.Pumper.initialize(Unknown Source)
at servicenow.community.sql.Pumper.main(Unknown Source)
... 6 more

Any ideas?

[Anonymous]

Looks very similar to my issue...Haven't identified the problem yet.

java -jar servicenow-sql-pump.jar -p datapump.properties -f load_location.txt INFO DataPump.Pumper propfile=datapump.properties
INFO DataPump.DatabaseWriter database=jdbc:mysql://localhost:3306/snowrep user=snow
INFO DataPump.DatabaseWriter set time_zone = '+0:00'
INFO DataPump.DatabaseWriter set sql_mode='ANSI_QUOTES'
Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.simontuffs.onejar.Boot.run(Boot.java:342)
at com.simontuffs.onejar.Boot.main(Boot.java:168)
Caused by: java.lang.NullPointerException
at servicenow.community.soap.GlideTableSchema.<init>(Unknown Source)
at servicenow.community.soap.GlideTable.loadSchema(Unknown Source)
at servicenow.community.soap.Instance.<init>(Unknown Source)
at servicenow.community.soap.Instance.<init>(Unknown Source)
at servicenow.community.sql.Pumper.initialize(Unknown Source)
at servicenow.community.sql.Pumper.main(Unknown Source)
... 6 more

[Anonymous]

Could it be linked to ServiceNow instances that are running Fuji?

D.

[Anonymous]

I tried folllowing the "QuickStart" instructions - using the demo instance and the admin user - and I get the exact same error. I think something has changed in the SN that causes the error. Remember the last code drop was from 2013.

D.

[Anonymous]

Have the same issue this code doesnt even work on the Demo sanbox env in service now.
Looks like all the pieces are there but some code issue with loading the tables from source. please help Giles.

[Giles Lewis]

This code is really old (more than 2 years) and the diagnostic messages are not very good. I am trying to release a new version based on a more recent code base. However, the configuration, syntax and features have changed a bit, and I do not yet have updated documentation for the new version. In order to assist please send an email directly to gflewis at users.sourceforge.net. I need to know what version of ServiceNow you are using, what database you are using (Oracle, MySQL, other?) and what features of this product you are using. Are you using load? refresh? prune? polling? Sample script files would be helpful. Also a sample config file if relevant (remove URLs and passwords from the config file before sending). The new code has been tested extensively on Eureka, but only a bit on Fuji.

[Anonymous]

I am using Helsinki version, and I am getting the same error, appreciate help from anyone. please?

C:\Users\Gil Sabado\Desktop\snow-link>java -jar servicenow-sql-pump.jar -p datapump.properties -f load_location.txt
INFO DataPump.Pumper propfile=datapump.properties
INFO DataPump.DatabaseWriter database=jdbc:oracle:thin:@localhost:1521:xe user=snow
INFO DataPump.DatabaseWriter alter session set nls_length_semantics = 'CHAR'
INFO DataPump.DatabaseWriter alter session set nls_date_format = 'YYYY-MM-DD'
INFO DataPump.DatabaseWriter alter session set nls_timestamp_format = 'YYYY-MM-DD HH24:MI:SS'
INFO DataPump.DatabaseWriter alter session set time_zone = '+0:00'
Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.simontuffs.onejar.Boot.run(Boot.java:342)
at com.simontuffs.onejar.Boot.main(Boot.java:168)
Caused by: java.lang.NullPointerException
at java.io.Reader.<init>(Reader.java:78)
at java.io.InputStreamReader.<init>(InputStreamReader.java:72)
at servicenow.community.soap.SoapProxy.readFully(Unknown Source)
at servicenow.community.soap.SoapProxy.callSoap(Unknown Source)
at servicenow.community.soap.GlideTable.getRecords(Unknown Source)
at servicenow.community.soap.GlideTable.get(Unknown Source)
at servicenow.community.soap.GlideTable.determineParentName(Unknown Source)
at servicenow.community.soap.GlideTable.<init>(Unknown Source)
at servicenow.community.soap.Instance.table(Unknown Source)
at servicenow.community.soap.Instance.<init>(Unknown Source)
at servicenow.community.soap.Instance.<init>(Unknown Source)
at servicenow.community.sql.Pumper.initialize(Unknown Source)
at servicenow.community.sql.Pumper.main(Unknown Source)
... 6 more