SOLR import from Dspace 5 to Dspace 7

[mad...@udel.edu]

Hi All,

I've recebtly exported my SOLR stats in a dspace 5 instance, into .csv files. I've tried to import the stats into a Dspace 7.3 instance. I've used this command:

bin/dspace stats-log-importer -s -v -i usagestats_9990000.csv

I get the following error:

Writing to solr server at: server
Processing file: usagestats_9990000.csv
Line:Sun Nov 13 02:02:35 EST 2022,view_bitstream,97341,2022-11-13T02:02:35,anonymous,52.7.141.1
Exception: Cannot invoke "com.maxmind.geoip2.DatabaseReader.city(java.net.InetAddress)" because "org.dspace.statistics.util.StatisticsImporter.geoipLookup" is null
java.lang.NullPointerException: Cannot invoke "com.maxmind.geoip2.DatabaseReader.city(java.net.InetAddress)" because "org.dspace.statistics.util.StatisticsImporter.geoipLookup" is null
    at org.dspace.statistics.util.StatisticsImporter.load(StatisticsImporter.java:290)
    at org.dspace.statistics.util.StatisticsImporter.main(StatisticsImporter.java:516)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:568)
    at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:277)
    at org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:133)
    at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98)

With the old Dspace 5 instance, we did start out using the GeoCity database, but in the new Dspace 7 instance we are using the free dbip-city-lite database.

Any help will be appreciated.

Thanks

Keith Jones

Systems Programmer

University of Delaware

[Mark H. Wood]

I am just guessing, but perhaps the 'usage-statistics.dbfile'
configuration property is undefined or incorrect. Does it *log* an
error saying that the geo database file is missing or could not be
loaded? Another possibility is that the process loading the stat.s
lacks sufficient permission to open the geo database. In these
conditions the importer will complain but still attempt to proceed,
though apparently it should fail-fast.

--
Mark H. Wood
Lead Technology Analyst

University Library
Indiana University - Purdue University Indianapolis
755 W. Michigan Street
Indianapolis, IN 46202
317-274-0749
www.ulib.iupui.edu

[mad...@udel.edu]

Thanks for the information.

The setting for usage-statistics.dbfile is set in my local.cfg file. The file is being read because you can see location stats being generated when you click the statistics option in the user interface of the Dspace 7 instance.  Has anyone run into an issue with switching from the geolite databse to the new free database?

Thanks