Error when I want to run with -js option

[Anonymous]

I want use jobset to extract data from service-now with option js.

I create jobset with job in service-now, the datapump user has right on extract tables.

With script file option -f it's works.

With -js option i have error

C:\Users\??????\DataPump>java -jar -Dproxyset="true" -Dhttps.proxyHost="
XXX.XXX.XXX.XX" -Dhttps.proxyPort="xxxx" -Dhttps.proxyUser="xxxx" -Dhttps-prox
yPassword="xxxxxxx" servicenow-sql-pump.jar -p datapump.properties -js DSA
INFO DataPump.Pumper propfile=datapump.properties
INFO DataPump.DatabaseWriter database=jdbc:oracle:thin:@xxxxxxxxx:0000:xxx
user=xxxxxxxx
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-D
D 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(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
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.sql.Pumper.main(Unknown Source)

Could you help me on this point

Best regards

[Giles Lewis]

Hmmm...
There is no line number. Can you try running with servicenowpump-1.6.1.jar? Maybe it will give a better error message. The main class should be servicenow.community.sql.Pumper.

[Giles Lewis]

P.s. you may need to download dependent JARs and include them in your class path: log4j 1.2, jdom 2.0, apache commons lang, apache commons codec.

[Anonymous]

Thanks, but i'm not use to java term where can i found this jar ? Where is the class path, it's the directory where is the files ?

I don't understand (sorry) can you explain "try running with servicenowpump-1.6.1.jar" ? I ran this command C:\Users\??????\DataPump>java -jar -Dproxyset="true" -Dhttps.proxyHost="
XXX.XXX.XXX.XX" -Dhttps.proxyPort="xxxx" -Dhttps.proxyUser="xxxx" -Dhttps-prox
yPassword="xxxxxxx" servicenow-sql-pump.jar -p datapump.properties -js DSA

and the 1.6.1.jar is in the same directory.

The directory C:\Users\??????\DataPump contains datapump.properties, servicenowpump-1.6.1.jar, servicenow-sql-pump.jar, sqltemplates.xml

Best regards

Daniel LEMEE

[Anonymous]

PS : Where can i will find the dependent jar ? and where i put them ?

I'm apologize for dummies questions.

Daniel LEMEE

[Anonymous]

Hello,

I think, we found the solution,

1- pumper.signal_file must exists in .properties and fill with a signal file and his directory like pumper.signal_file=c:\signal.txt

2- The jobset must be periodic

For us, in main code, it's get the property and create an object link with the filename, if it can't the exception will be raise because it can't instantiate the object.

Perhaps the documentation will be updated with this information.

Best regards

Daniel LEMEE

And now it's works.

[Giles Lewis]

Thanks for the feedback. "pumper.signal_file" should be an optional property. Since you are getting a NullPointerException, there is probably a bug. I will try to track it down.

[Anonymous]

Could you help me with the below error :

Its able to create the table in the local mysql database but unable to load the data as its throwing the error as table already exists.

[Giles Lewis]

This version of SNDML is no longer supported. Please download 2.6.5 from https://github.com/gflewis/sndml/releases