ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> FO Tree not loading
http://www.istechforum.com/YaBB.pl?num=1489100698

Message started by gtladmin on 03/09/17 at 16:04:58

Title: FO Tree not loading
Post by gtladmin on 03/09/17 at 16:04:58

In testing FO, we are not getting the FO tree to select the options. Here's the process:

We enter the line item in the SO with FO part (skip lot info when asked) and the Features and Options window goes to load (see it on the lower left part of the Evo screen). After a few seconds, we quickly see a window that appears to be the Enter Features and Options window (9/23/16) where it has the "Search for" section at the top and below the table that contains the description, parent part, date created, and status data. This window is very quickly replaced by a program screen that you would see if you hit the green plus icon in the FO-G window. After a few seconds an error popup occurs that reads:

(title) An error occurred: Error building tree.
It may be possible to continue running the program however it may not function
properly. If you are unable to resolve the problem, please email a copy of the
error log file to support@istechsupport.com

You can choose Okay or exit.

If you click okay, you are left at the FO-G add window (9/23/2016) with no data. If you click exit, you are in the FO-G window with data: the part # entered for the SO line item, and the description, the customer code and status (copied). You can't really do anything here except close the window.

When I watch the task manager, during all this, a process loads when the Features and Options window initially starts to load:

Process image: JAVA.exe
Command Line for process:
java -jar FOTree.jar -c B)( -tp "Sysadmin 052213P20170309 "-p C:\ISTS\T7FNO.TXT -f SOA -log finolog.txt

It seems that the FOTree.jar is not working/not loading the tree. I have on my system all host intrusion/av/firewall turned off for the testing, so I know that is not a factor as to why it is not loading.

The FOTree.jar file is dated 11/7/2016
The FOTreeRun.jar file is dated 6/17/2012

The FO Tree Log contents:

SEVERE -- FO Tree -- [03/09/17 05:35:56 pm]
---------------------------
Error building tree.
Caller: com.evoerp.fotree.sql.Database getTopPart
---------------------------
Build date = 7-31-2015
Version = 2.1.4
Company = B09
DB Host = LINUX-OESEVO
DB Port = 1583
DB Name = EVOB09
Report Dest = H:\REPORTS
Pervasive = 11.31.0056 000
Evo Version = 2016.2
Company ID = 0
User name = null
---------------------------
java.sql.SQLException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernel cannot find the specified file(Btrieve Error 12)
at com.pervasive.jdbc.lna.LNAObject.getErrors(LNAObject.java:213)
at com.pervasive.jdbc.lna.LNAStatement.getErrors(LNAStatement.java:937)
at com.pervasive.jdbc.lna.LNAObject.checkError(LNAObject.java:256)
at com.pervasive.jdbc.lna.LNAStatement.prepare(LNAStatement.java:273)
at com.pervasive.jdbc.v2.PreparedStatement.<init>(PreparedStatement.java:54)
at com.pervasive.jdbc.v2.Connection.prepareStatement(Connection.java:539)
at com.pervasive.jdbc.v2.Connection.prepareStatement(Connection.java:372)
at com.evoerp.fotree.sql.Database.getTopPart(Database.java:53)
at com.evoerp.fotree.sql.Database.buildTree(Database.java:103)
at com.evoerp.fotree.main.Main.main(Main.java:58)

So.......I know Btrieve error 12 means file not found, but what file is it looking for?? Is that really the issue?

Val

Title: Re: FO Tree not loading
Post by gtladmin on 03/16/17 at 13:22:38

Anybody? This is preventing Manufacturing from utilizing the Features and Options in Evo. They are very frustrated with Evo at the moment.

Title: Re: FO Tree not loading
Post by Kelloggs on 03/16/17 at 17:12:54

Could it be a Linux issue?
I pretty sure that your DBA/EVO server is a SuSE Linux,
I believe java is a client side, but are your workstations SuSE as well?

Another thing, if this is a ODBC issue, have you installed it on your Linux?
It is call unixODBC

:(

Kelloggs

Title: Re: FO Tree not loading
Post by Lynn_Pantic on 03/17/17 at 11:25:55

Also, does SM-T Test JDBC Settings work?

Title: Re: FO Tree not loading
Post by gtladmin on 03/29/17 at 14:26:13

Sorry, been tied up with other things. Thank you both for the response here's what I can tell you:

We have had ODBC enabled since the start, system DSNs were setup for all the companies, also UPS WorldShip and FedEx Ship use them to connect to Evo for shipping, and all sales and finance use the system DSNs for their Crystal reports, so I am fairly sure that's all working, but I could be a dope and be wrong.... ::)

What I do get when I use the test in the live production companies is a successful connection, for both companies.

When I use SM-T in the test companies, I get a connection failure, and in the resulting log is a btrieve error 12. What I don't know is what file it is unable to find. The test companies are copies of the production companies. Here's the log file:
Test Settings Attempt -- Wed Mar 29 17:22:34 EDT 2017
----------------------------------------------------------
company = B09
serial = 0
db host = LINUX-OESEVO
db port = 1583
db name = EVOB09
----------------------------------------------------------
[05:22:35 pm] java.util.concurrent.ExecutionException: java.sql.SQLException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernel cannot find the specified file(Btrieve Error 12) -- java.sql.SQLException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernel cannot find the specified file(Btrieve Error 12)
java.util.concurrent.ExecutionException: java.sql.SQLException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernel cannot find the specified file(Btrieve Error 12)
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: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernel cannot find the specified file(Btrieve Error 12)
at com.pervasive.jdbc.lna.LNAObject.getErrors(LNAObject.java:213)
at com.pervasive.jdbc.lna.LNAStatement.getErrors(LNAStatement.java:937)
at com.pervasive.jdbc.lna.LNAObject.checkError(LNAObject.java:256)
at com.pervasive.jdbc.lna.LNAStatement.prepare(LNAStatement.java:273)
at com.pervasive.jdbc.v2.PreparedStatement.<init>(PreparedStatement.java:54)
at com.pervasive.jdbc.v2.CallableStatement.<init>(CallableStatement.java:40)
at com.pervasive.jdbc.v2.Connection.prepareCall(Connection.java:544)
at com.pervasive.jdbc.v2.Connection.prepareCall(Connection.java:381)
at ui.ProgressFrame$1.doInBackground(ProgressFrame.java:82)
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)
[05:22:35 pm] java.sql.SQLException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernel cannot find the specified file(Btrieve Error 12) -- [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernel cannot find the specified file(Btrieve Error 12)
java.sql.SQLException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernel cannot find the specified file(Btrieve Error 12)
at com.pervasive.jdbc.lna.LNAObject.getErrors(LNAObject.java:213)
at com.pervasive.jdbc.lna.LNAStatement.getErrors(LNAStatement.java:937)
at com.pervasive.jdbc.lna.LNAObject.checkError(LNAObject.java:256)
at com.pervasive.jdbc.lna.LNAStatement.prepare(LNAStatement.java:273)
at com.pervasive.jdbc.v2.PreparedStatement.<init>(PreparedStatement.java:54)
at com.pervasive.jdbc.v2.CallableStatement.<init>(CallableStatement.java:40)
at com.pervasive.jdbc.v2.Connection.prepareCall(Connection.java:544)
at com.pervasive.jdbc.v2.Connection.prepareCall(Connection.java:381)
at ui.ProgressFrame$1.doInBackground(ProgressFrame.java:82)
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)

So, maybe something didn't get transferred/copied over correctly when the test companies were last created? I know I didn't have any errors or issues with the creation, but I could have missed something.

Let me know what else I can check on.

Thank you!

Val

Title: Re: FO Tree not loading
Post by Kelloggs on 03/29/17 at 17:05:01

Hi,

Can you access the test company using Pervasive Control Panel? can you see the tables? the data?
Even if you can, login into the Test Company as the admin, open UT-A
and run :

BKUTJ.RUN
ODBCDDF.RUN

See what happens, Do not run them on the real company !!!!!!!!

;)

Kelloggs

PD: The Pervasive Control Panel is java as well, it is going to be interesting to know what happens.....

Title: Re: FO Tree not loading
Post by gtladmin on 03/31/17 at 07:13:56

I can see all the tables for the test company when in the PCC. BUT if I try to run an SQL query on the actual data in any table I continue to get the error showing in the Java log, [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The Microkernel cannot find the specified file (Btrieve Error 12). If I select Edit (just to try something different), I get the Btrieve error 12, and after clicking on OK it does go ahead and show me the table structure (Column name, type size, precision, etc.), and I can see to add indexes, columns, foreign keys, and an sql view.

I logged into Evo as the Evo admin user and ran the first util, it was successful. I ran the second util, and it was also successful. I do remember the DDFs getting created when the test company was created, so perhpas something occured in the background that they didn't complete? I don't recall ever seeing any ODBC DDF files get created when I create test companies, though.

So then I went back to the Java settings and re-tested the settings, and this time it made a successful connection to the database. The items displayed are correct, no java or btrieve errors now! If I go back into the PCC, I can now see and query the data in the tables.

So back into Features and Options, and things are working smoothly now. The process completes all the way thru from the sales order completion. I'll let the engineers test the rest (SO to WO, etc.).

AWESOME! Kelloggs, you've been a great help! Thanks so very much. This makes my day! :D

Val