ISTech Support Forum - Update issue in SO-I

cmsk

Senior Member

Posts: 289

Update issue in SO-I
04/17/17 at 06:21:17

First problem with the new update.

SO-I brings up a blank screen... nothing in the fields and apparently the F2 lookup isn't working either.

Tried searching for a customer and got an error message.

SEVERE -- Customer Service Inquiry -- [04/17/17 08:53:55 am]
---------------------------
Error reading database.
Caller: com.evoerp.csi.sql.Database doCustomerCodeLookup
---------------------------
Build date = 11-15-2015
Version = 2.5.2
Company = B
DB Host = BFIPDC1
DB Port = 1583
DB Name = EVODEFAULT
Report Dest = W:\REPORTS\
Pervasive = null
Evo Version = 2017.2
Company ID = 0
User name = null
---------------------------
java.sql.SQLException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]No such table or object.
at com.pervasive.jdbc.lna.LNAObject.getErrors(LNAObject.java:213)
at com.pervasive.jdbc.lna.LNAStatement.getErrors(LNAStatement.java:929)
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:417)
at com.pervasive.jdbc.v2.Connection.prepareCall(Connection.java:254)
at com.evoerp.csi.sql.Database.doCustomerCodeLookup(Database.java:637)
at com.evoerp.csi.ui.FindCustomerFrame$CodeLookupWorker.doInBackground(FindCustomer
Frame.java:448)
at com.evoerp.csi.ui.FindCustomerFrame$CodeLookupWorker.doInBackground(FindCustomer
Frame.java:444)
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)
------------------------------------------------------------
SEVERE -- Customer Service Inquiry -- [04/17/17 08:53:56 am]
---------------------------
Error performing lookup.
Caller: com.evoerp.csi.ui.FindCustomerFrame$CodeLookupWorker done
---------------------------
Build date = 11-15-2015
Version = 2.5.2
Company = B
DB Host = BFIPDC1
DB Port = 1583
DB Name = EVODEFAULT
Report Dest = W:\REPORTS\
Pervasive = null
Evo Version = 2017.2
Company ID = 0
User name = null
---------------------------
java.lang.NullPointerException
at com.evoerp.ui.util.LookupTableModel.<init>(LookupTableModel.java:24)
at com.evoerp.ui.AbstractLookupFrame.<init>(AbstractLookupFrame.java:32)
at com.evoerp.csi.ui.CodeLookupFrame.<init>(CodeLookupFrame.java:24)
at com.evoerp.csi.ui.FindCustomerFrame$CodeLookupWorker.done(FindCustomerFrame.java
:455)
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(Un
known 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.pumpEventsForFilter(Unknown Source)
at java.awt.WaitDispatchSupport$2.run(Unknown Source)
at java.awt.WaitDispatchSupport$4.run(Unknown Source)
at java.awt.WaitDispatchSupport$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.WaitDispatchSupport.enter(Unknown Source)
at java.awt.Dialog.show(Unknown Source)
at javax.swing.JOptionPane.showOptionDialog(Unknown Source)
at com.evoerp.util.logging.DialogHandler$DialogDisplayer.run(DialogHandler.java:92)

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(Un
known 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)
------------------------------------------------------------
SEVERE -- Customer Service Inquiry -- [04/17/17 08:54:39 am]
---------------------------
Error reading database.
Caller: com.evoerp.csi.sql.Database doCustomerCodeLookup
---------------------------
Build date = 11-15-2015
Version = 2.5.2
Company = B
DB Host = BFIPDC1
DB Port = 1583
DB Name = EVODEFAULT
Report Dest = W:\REPORTS\
Pervasive = null
Evo Version = 2017.2
Company ID = 0
User name = null
---------------------------
java.sql.SQLException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]No such table or object.
at com.pervasive.jdbc.lna.LNAObject.getErrors(LNAObject.java:213)
at com.pervasive.jdbc.lna.LNAStatement.getErrors(LNAStatement.java:929)
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:417)
at com.pervasive.jdbc.v2.Connection.prepareCall(Connection.java:254)
at com.evoerp.csi.sql.Database.doCustomerCodeLookup(Database.java:637)
at com.evoerp.csi.ui.FindCustomerFrame$CodeLookupWorker.doInBackground(FindCustomer
Frame.java:448)
at com.evoerp.csi.ui.FindCustomerFrame$CodeLookupWorker.doInBackground(FindCustomer
Frame.java:444)
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)
------------------------------------------------------------
SEVERE -- Customer Service Inquiry -- [04/17/17 08:54:39 am]
---------------------------
Error performing lookup.
Caller: com.evoerp.csi.ui.FindCustomerFrame$CodeLookupWorker done
---------------------------
Build date = 11-15-2015
Version = 2.5.2
Company = B
DB Host = BFIPDC1
DB Port = 1583
DB Name = EVODEFAULT
Report Dest = W:\REPORTS\
Pervasive = null
Evo Version = 2017.2
Company ID = 0
Use

Back to top

--
Thank you
Chris Simo-Kinzer
Vice President
brookfield industries, inc.

Evo-ERP 2017.2 Build 4.5.17 Update T7-7i R11
Pervasive 9.5

IP Logged

cmsk Senior Member Posts: 289	Re: Update issue in SO-I Reply #1 - 04/17/17 at 06:29:28 Link to the image cap of the SO-I screen is here: https://db.tt/NgFRy3M7aE
Back to top	-- Thank you Chris Simo-Kinzer Vice President brookfield industries, inc. Evo-ERP 2017.2 Build 4.5.17 Update T7-7i R11 Pervasive 9.5 IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5681	Re: Update issue in SO-I Reply #2 - 04/17/17 at 06:57:24 You need to set up the JDBC settings at SM-T. See http://www.istechsupport.com/jdbcsetup.pdf
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

David Waldmann

Active Member

Live to work, or
work to live?

Posts: 1924
Gender: male

Re: Update issue in SO-I
Reply #3 - 04/19/17 at 08:25:39

Quote from Lynn_Pantic on 04/17/17 at 06:57:24:

You need to set up the JDBC settings at SM-T. See http://www.istechsupport.com/jdbcsetup.pdf

I followed that, and when I click Test, nothing happens. No error message, no list of items, nothing. I tried it both with the database name I created with C:\ISTS as the location for reports, and then I tried "Detect Settings" as well (which picked a different database and a Reports folder in DBAMFG). Same thing.

Back to top

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11

IP Logged

cmsk Senior Member Posts: 289	Re: Update issue in SO-I Reply #4 - 04/19/17 at 08:28:51 I my case, the issue was the location MUST be pointed to the DEFAULT folder under the server drive where EVOERP is installed.
Back to top	-- Thank you Chris Simo-Kinzer Vice President brookfield industries, inc. Evo-ERP 2017.2 Build 4.5.17 Update T7-7i R11 Pervasive 9.5 IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1924 Gender:	Re: Update issue in SO-I Reply #5 - 04/19/17 at 08:45:53 Changed to Default and still nothing.
Back to top	David N Waldmann President Vermont Hardwoods Chester, VT Evo-ERP, 5 user IST Build: 3/4/19, patched 04/30/19 Pervasive v11.31 Server 2012 / Win10 x64 Crystal Reports v11 IP Logged

prophet Full Member Posts: 215	Re: Update issue in SO-I Reply #6 - 04/19/17 at 08:55:33 Did you setup SM-T in EVO from you workstation or the Server? Is the Host correct and is the Name of the Table exactly as how you created it In Pervasive?
Back to top	IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1924 Gender:	Re: Update issue in SO-I Reply #7 - 04/19/17 at 09:02:08 From the workstation. Yes & Yes.
Back to top	David N Waldmann President Vermont Hardwoods Chester, VT Evo-ERP, 5 user IST Build: 3/4/19, patched 04/30/19 Pervasive v11.31 Server 2012 / Win10 x64 Crystal Reports v11 IP Logged

prophet Full Member Posts: 215	Re: Update issue in SO-I Reply #8 - 04/19/17 at 10:30:19 what did you use for the hostname? if you used the ip address try the Hostname instead.
Back to top	IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1924 Gender:	Re: Update issue in SO-I Reply #9 - 04/19/17 at 10:44:35 I used SERVERNAME. Does it need the \\?
Back to top	David N Waldmann President Vermont Hardwoods Chester, VT Evo-ERP, 5 user IST Build: 3/4/19, patched 04/30/19 Pervasive v11.31 Server 2012 / Win10 x64 Crystal Reports v11 IP Logged

prophet Full Member Posts: 215	Re: Update issue in SO-I Reply #10 - 04/19/17 at 12:39:39 normally I would say it doesn't but everyones network is different. So its worth a try. If that doesn't work then try the IP address for the server.
Back to top	IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1924 Gender:	Re: Update issue in SO-I Reply #11 - 04/19/17 at 13:06:34 Tried \\SERVERNAME and IP address. No dice. No error, no list.
Back to top	David N Waldmann President Vermont Hardwoods Chester, VT Evo-ERP, 5 user IST Build: 3/4/19, patched 04/30/19 Pervasive v11.31 Server 2012 / Win10 x64 Crystal Reports v11 IP Logged

David Waldmann

Active Member

Live to work, or
work to live?

Posts: 1924
Gender: male

Re: Update issue in SO-I
Reply #12 - 04/19/17 at 13:16:08

Quote from cmsk on 04/19/17 at 08:28:51:

I my case, the issue was the location MUST be pointed to the DEFAULT folder under the server drive where EVOERP is installed.

Maybe I misunderstood this.

The directions say to point the Database Location "the Company folder" so I set it to the active Company that we use.

When I said

Quote from David Waldmann on 04/19/17 at 08:45:53:

Changed to Default and still nothing.

I was talking about Destination in SM-T.

So in the database creation per http://www.istechsupport.com/jdbcsetup.pdf Step 1, am I supposed to use the DEFAULT folder?

If so, how do I delete the first database I made? I tried and it said that the Data Dict is in use.

Back to top

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11

IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5681	Re: Update issue in SO-I Reply #13 - 04/19/17 at 13:43:54 The database location when creating the database in the Pervasive Control Center needs to be your active company subfolder. Do not change anything else on the screen and click Finish. The Destination Folder on the SM-T screen should be a folder such as DBAMFG\REPORTS where exported files will be saved.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

David Waldmann

Active Member

Live to work, or
work to live?

Posts: 1924
Gender: male

Re: Update issue in SO-I
Reply #14 - 04/19/17 at 14:14:53

Quote from Lynn_Pantic on 04/19/17 at 13:43:54:

The database location when creating the database in the Pervasive Control Center needs to be your active company subfolder. Do not change anything else on the screen and click Finish.

Yes, that is what I did,

Quote from Lynn_Pantic on 04/19/17 at 13:43:54:

The Destination Folder on the SM-T screen should be a folder such as DBAMFG\REPORTS where exported files will be saved.

I initially had C:\ISTS\

But nothing happens.

Is there a previous step that I missed?

Back to top

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11

IP Logged

prophet

Full Member

Posts: 215

Re: Update issue in SO-I
Reply #15 - 04/20/17 at 10:58:17

So just to cover our bases. You created a database using the Pervasive Control Center and pointed that database to the correct company subfolder that you are running?
In SM-T You entered the correct Host name and Database name? The Destination is a current folder that exists?
When you save it and click the Test Setting button nothing happens?
Does the window come up and its simply blank or nothing comes up?

Back to top

IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1924 Gender:	Re: Update issue in SO-I Reply #16 - 04/20/17 at 11:08:27 Yes to all above. Click Save, and then Test. Nothing happens. Nothing at all - no error, no table.
Back to top	David N Waldmann President Vermont Hardwoods Chester, VT Evo-ERP, 5 user IST Build: 3/4/19, patched 04/30/19 Pervasive v11.31 Server 2012 / Win10 x64 Crystal Reports v11 IP Logged

prophet Full Member Posts: 215	Re: Update issue in SO-I Reply #17 - 04/20/17 at 12:20:34 Have you tried testing from another workstation or at the Server itself?
Back to top	IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1924 Gender:	Re: Update issue in SO-I Reply #18 - 04/20/17 at 12:28:40 Just tried it on the server and Test pulled up out items. So I tried SO-I and it worked both on the server as well as the WS that I had been using before. Not sure why the Test doesn't work but the actual program does, but anyways - thanks.
Back to top	David N Waldmann President Vermont Hardwoods Chester, VT Evo-ERP, 5 user IST Build: 3/4/19, patched 04/30/19 Pervasive v11.31 Server 2012 / Win10 x64 Crystal Reports v11 IP Logged

David Waldmann

Active Member

Live to work, or
work to live?

Posts: 1924
Gender: male

Re: Update issue in SO-I
Reply #19 - 04/20/17 at 12:36:19

BTW, very handy tool, but it's lost some function from the old BK one.

What I used that mostly for was to find if/when we had shipped a particular item to a customer. I don't see any way to do that in the new one. You can search by PO #, SO, Inv, and a few others, but not Item #.

Basically it seems to be a more streamlined and efficient version of what you can already get from AR-A, with a little extra filtering. Don't get me wrong, it's a great addition, but at the same time it really bugs me when there's an "advance" and yet some things are given up.

Back to top

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11

IP Logged

prophet Full Member Posts: 215	Re: Update issue in SO-I Reply #20 - 04/20/17 at 14:04:50 Have you ever tried the SA-F-D, that is another one of those java programs, it might give you what your looking for.
Back to top	IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1924 Gender:	Re: Update issue in SO-I Reply #21 - 04/21/17 at 04:57:59 I didn't realize those reports were even there, as they were not on my working menu. Some very interesting things, but none that give me what I was looking for. In the old SO-I you could enter a Customer and Item and search Shipped Lines.
Back to top	David N Waldmann President Vermont Hardwoods Chester, VT Evo-ERP, 5 user IST Build: 3/4/19, patched 04/30/19 Pervasive v11.31 Server 2012 / Win10 x64 Crystal Reports v11 IP Logged

David Waldmann

Active Member

Live to work, or
work to live?

Posts: 1924
Gender: male

Re: Update issue in SO-I
Reply #22 - 04/21/17 at 05:26:14

Quote from David Waldmann on 04/20/17 at 12:36:19:

Basically it seems to be a more streamlined and efficient version of what you can already get from AR-A, with a little extra filtering. Don't get me wrong, it's a great addition, but at the same time it really bugs me when there's an "advance" and yet some things are given up.

I've changed my opinion.

While I do still want to be able to find items shipped to a particular customer, that's a relatively rare use and I could pretty easily create a report in Crystal to do that.

The way this program works is awesome for checking order status. The power/ease of use compared to the old SO-! is not even in the same ballpark.

One issue:
Order and Invoice details are sorted by Item Number. If you use Kit type items this makes it all but unreadable unless you only have one or two items on the order. We often have 5-20 items, each of which typically has 3-4 components, many of which components are the same.
It would be good if it showed up in the same order as on the SO.
Another option would be to make it sortable by column by clicking the header, in which case Line Number would be a great additional column. In fact, for us sorting by LN would be ideal as it would put all the top level lines together at the top.

Thanks

Back to top

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11

IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1924 Gender:	Re: Update issue in SO-I Reply #23 - 04/21/17 at 05:29:02 One other advantage of this as a java program, is that it's an actual Windows recognized window. So you can keep it open and alt-tab to it
Back to top	David N Waldmann President Vermont Hardwoods Chester, VT Evo-ERP, 5 user IST Build: 3/4/19, patched 04/30/19 Pervasive v11.31 Server 2012 / Win10 x64 Crystal Reports v11 IP Logged