Hope this helps anybody with old jars and old versions.
Turns out this was due to old ojdbc6.jar.
I modified the DIH and added a catch for throwable. I discovered I was
getting:
Caused by: java.security.AccessControlException: access denied
("java.lang.RuntimePermission" "accessClassInPackage.sun.security.krb5")
at
java.base/java.security.AccessControlContext.checkPermission(AccessControlContext.java:472)
~[?:?]
at
java.base/java.security.AccessController.checkPermission(AccessController.java:897)
~[?:?]
at
java.base/java.lang.SecurityManager.checkPermission(SecurityManager.java:322)
~[?:?]
at
java.base/java.lang.SecurityManager.checkPackageAccess(SecurityManager.java:1238)
~[?:?]
at
java.base/java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:901)
~[?:?]
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)
~[?:?]
at java.base/java.lang.Class.forName0(Native Method) ~[?:?]
at java.base/java.lang.Class.forName(Class.java:315) ~[?:?]
at oracle.net.ano.AuthenticationService.k(Unknown Source) ~[?:?]
at oracle.net.ano.AuthenticationService.<clinit>(Unknown Source) ~[?:?]
I upgraded to the highest Oracle jdbc that was compatible with our
database: ojdbc8-19.3.0.0.jar
and the access exception went away and the DIH completed successfully
On 2/6/2025 7:04 AM, Patryk Mazurkiewicz wrote:
Hi Mike,
Also, activating debug-level logs for the DIH component could give you more
details.
Thank you,
Patryk
On Wed, Feb 5, 2025 at 09:09 Mikhail Khludnev<m...@apache.org> wrote:
Hello Mike.
If it hangs you may see it in Thread Dump in Solr Admin or via jstack etc.
Probably it may give a clue what's going on there.
On Wed, Feb 5, 2025 at 3:02 AM Mike Phillips <
m.phill...@prosperodigital.com>
wrote:
I have solr 9.8.0 running the data import handler in standalone mode.
All the documented steps fail in zoo keeper mode (bummer).
I can import data from MySQL and Postgres but when I try oracle it
fails. The output in the solr log looks like it is going to connect and
then it just does nothing.
Here is the log output when doing a Full Import in 8.4.1
2025-02-04 13:39:13.301 INFO (qtp599782425-69) [ x:rat_11]
o.a.s.h.d.DataImporter Loading DIH Configuration: data-config.xml
2025-02-04 13:39:13.337 INFO (qtp599782425-69) [ x:rat_11]
o.a.s.h.d.c.DIHConfiguration The field :clientName present in DataConfig
does not have a counterpart in Solr Schema
2025-02-04 13:39:13.337 INFO (qtp599782425-69) [ x:rat_11]
o.a.s.h.d.DataImporter Data Configuration loaded successfully
2025-02-04 13:39:13.360 INFO (Thread-24) [ ] o.a.s.h.d.DataImporter
Starting Full Import
2025-02-04 13:39:13.360 INFO (qtp599782425-69) [ x:rat_11]
o.a.s.c.S.Request [rat_11] webapp=/solr path=/DmeImport
params={commit=true&clean=true&wt=xml&command=full-import} status=0
QTime=65
2025-02-04 13:39:13.389 WARN (Thread-24) [ ]
o.a.s.h.d.SimplePropertiesWriter Unable to read: DmeImport.properties
2025-02-04 13:39:13.637 INFO (Thread-24) [ ] o.a.s.h.d.JdbcDataSource
Creating a connection for entity asset_core with URL:
jdbc:oracle:thin:@rat:52689:dme1
2025-02-04 13:39:14.183 INFO (Thread-24) [ ] o.a.s.h.d.JdbcDataSource
Time taken for getConnection(): 545
2025-02-04 13:39:14.331 INFO (Thread-24) [ ] o.a.s.h.d.JdbcDataSource
Creating a connection for entity asset_dmeaccount with URL:
jdbc:oracle:thin:@rat:52689:dme1
...
After here the rest of my tables connect and import
Here is the log output for solr 9.8.0
2025-02-04 15:04:57.366 INFO (qtp142099757-26-null-12) [c: s: r:
x:rat_11 t:null-12] o.a.s.h.d.DataImporter Loading DIH Configuration:
data-config.xml
2025-02-04 15:04:57.429 INFO (qtp142099757-26-null-12) [c: s: r:
x:rat_11 t:null-12] o.a.s.h.d.c.DIHConfiguration The field :clientName
present in DataConfig does not have a counterpart in Solr Schema
2025-02-04 15:04:57.429 INFO (qtp142099757-26-null-12) [c: s: r:
x:rat_11 t:null-12] o.a.s.h.d.DataImporter Data Configuration loaded
successfully
2025-02-04 15:04:57.451 INFO (qtp142099757-26-null-12) [c: s: r:
x:rat_11 t:null-12] o.a.s.c.S.Request webapp=/solr path=/DmeImport
params={commit=true&clean=true&wt=xml&command=full-import} status=0
QTime=86
2025-02-04 15:04:57.451 INFO (Thread-23) [c: s: r: x: t:]
o.a.s.h.d.DataImporter Starting Full Import
2025-02-04 15:04:57.475 INFO (Thread-23) [c: s: r: x: t:]
o.a.s.h.d.SimplePropertiesWriter Read DmeImport.properties
2025-02-04 15:04:57.623 INFO (Thread-23) [c: s: r: x: t:]
o.a.s.h.d.JdbcDataSource Creating a connection for entity asset_core
with URL: jdbc:oracle:thin:@rat:52689:dme1
2025-02-04 15:04:57.838 INFO (Thread-23) [c: s: r: x: t:]
o.a.s.u.p.LogUpdateProcessorFactory webapp=/solr path=/DmeImport
params={commit=true&clean=true&wt=xml&command=full-import} status=0
QTime=86{deleteByQuery=*:* (-1823169888949108736)} 0 474
It just stops here.
I used a lib directory parallel with the conf directory and I put:
data-import-handler-9.7.0.jar
ojdbc6.jar
Anybody got any suggestions?
--
Sincerely yours
Mikhail Khludnev
