Title: Different Java? Issues (Could be Pervasive Perms)
Post by AndyOB on 03/22/17 at 15:46:28
Trying to get Java programs working.
Good news, we're running 2017.1 Bad News, we're still running Pervasive v7.9 SP4 (2000i)
When I go to enter the Java settings (SM-T), the first thing I get is an error that windows can't find pvddl.exe. Pressing OK bypasses that bit. At the SM-T screen everything looks ok, but when I test the connection, it says connection unsuccessful. The .log file should follow.
When I go to fiddle with the Databases in PCC, I can't add a new database to our Pervasive server, it's saying it cannot retrieve the database names, but the database I want to use for JAVA (EVOB) is there already and it's pointing to our Evo Default folder for our main company files. So that's weird.
Some Google searching led me to think maybe the server securities were messed up. I read mention of "Pervasive_Admin" group being needed, so I added a group named that and then made sure I was in that group.
With these settings if I try to run BM-N, I get the following in my log file:
Code:
------------------------------------------------------------ SEVERE -- BOM Tree -- Wed Mar 22 15:44:33 PDT 2017 --------------------------- Error getting items Caller: com.evoerp.bomtree.javafx.NewTreePane$ItemStubWaitTask failed --------------------------- Build date = 9-16-2014 Version = 2.2.5 Company = B DB Host = Wire DB Port = 1583 DB Name = EVOB Report Dest = \\Wire\mrp\DBAMFG\REPORTS Pervasive = ? Evo Version = 2017.1 Company ID = null User Name = null --------------------------- java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.FutureTask.report(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at com.evoerp.bomtree.javafx.NewTreePane$ItemStubWaitTask.call(NewTreePane.java:364) at com.evoerp.bomtree.javafx.NewTreePane$ItemStubWaitTask.call(NewTreePane.java:352) at javafx.concurrent.Task$TaskCallable.call(Task.java:1423) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.NullPointerException at com.evoerp.sql.DatabaseWorkerService.getThreadLocalConn(DatabaseWorkerService.java:86) at com.evoerp.bomtree.sql.TreeWorkerService.access$800(TreeWorkerService.java:22) at com.evoerp.bomtree.sql.TreeWorkerService$ItemStubTask.call(TreeWorkerService.java:243) at com.evoerp.bomtree.sql.TreeWorkerService$ItemStubTask.call(TreeWorkerService.java:233) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at com.evoerp.sql.DatabaseWorkerService$ConnectionClosingThreadFactory.lambda$newThread$0(DatabaseWorkerService.java:174) ... 1 more ------------------------------------------------------------ |
|
Here's the SM-T error info.
Code:
Test Settings Attempt -- Wed Mar 22 15:37:42 PDT 2017 ---------------------------------------------------------- company = B serial = Ahem! db host = Wire db port = 1583 db name = EVOB ---------------------------------------------------------- [03:37:42 pm] java.util.concurrent.ExecutionException: java.sql.SQLException: java.net.ConnectException: Connection timed out: connect -- java.sql.SQLException: java.net.ConnectException: Connection timed out: connect java.util.concurrent.ExecutionException: java.sql.SQLException: java.net.ConnectException: Connection timed out: connect at java.util.concurrent.FutureTask.report(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at javax.swing.SwingWorker.get(Unknown Source) at ui.ProgressFrame$1.done(ProgressFrame.java:103) at javax.swing.SwingWorker$5.run(Unknown Source) at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(Unknown Source) at sun.swing.AccumulativeRunnable.run(Unknown Source) at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(Unknown Source) at javax.swing.Timer.fireActionPerformed(Unknown Source) at javax.swing.Timer$DoPostEvent.run(Unknown Source) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEventImpl(Unknown Source) at java.awt.EventQueue.access$500(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.awt.EventQueue$3.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Caused by: java.sql.SQLException: java.net.ConnectException: Connection timed out: connect at com.pervasive.jdbc.v2.Connection.<init>(Connection.java:151) at com.pervasive.jdbc.v2.Driver.connect(Driver.java:57) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at ui.ProgressFrame$1.doInBackground(ProgressFrame.java:76) at javax.swing.SwingWorker$1.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at javax.swing.SwingWorker.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) [03:37:42 pm] java.sql.SQLException: java.net.ConnectException: Connection timed out: connect -- java.net.ConnectException: Connection timed out: connect java.sql.SQLException: java.net.ConnectException: Connection timed out: connect at com.pervasive.jdbc.v2.Connection.<init>(Connection.java:151) at com.pervasive.jdbc.v2.Driver.connect(Driver.java:57) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at ui.ProgressFrame$1.doInBackground(ProgressFrame.java:76) at javax.swing.SwingWorker$1.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at javax.swing.SwingWorker.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) |
|
|