|
ISTech Support Forum
http://www.istechforum.com/YaBB.pl Evo-ERP and DBA Classic >> Sales >> Update issue in SO-I http://www.istechforum.com/YaBB.pl?num=1492435277 Message started by cmsk on 04/17/17 at 06:21:17 |
|
Title: Update issue in SO-I Post by cmsk on 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(FindCustomerFrame.java:448) at com.evoerp.csi.ui.FindCustomerFrame$CodeLookupWorker.doInBackground(FindCustomerFrame.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(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.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(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) ------------------------------------------------------------ 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(FindCustomerFrame.java:448) at com.evoerp.csi.ui.FindCustomerFrame$CodeLookupWorker.doInBackground(FindCustomerFrame.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 |
|
Title: Re: Update issue in SO-I Post by cmsk on 04/17/17 at 06:29:28 Link to the image cap of the SO-I screen is here: https://db.tt/NgFRy3M7aE |
|
Title: Re: Update issue in SO-I Post by 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 |
|
Title: Re: Update issue in SO-I Post by David Waldmann on 04/19/17 at 08:25:39 Lynn_Pantic wrote:
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. |
|
Title: Re: Update issue in SO-I Post by 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. |
|
Title: Re: Update issue in SO-I Post by David Waldmann on 04/19/17 at 08:45:53 Changed to Default and still nothing. |
|
Title: Re: Update issue in SO-I Post by prophet on 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? |
|
Title: Re: Update issue in SO-I Post by David Waldmann on 04/19/17 at 09:02:08 From the workstation. Yes & Yes. |
|
Title: Re: Update issue in SO-I Post by prophet on 04/19/17 at 10:30:19 what did you use for the hostname? if you used the ip address try the Hostname instead. |
|
Title: Re: Update issue in SO-I Post by David Waldmann on 04/19/17 at 10:44:35 I used SERVERNAME. Does it need the \\? |
|
Title: Re: Update issue in SO-I Post by prophet on 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. |
|
Title: Re: Update issue in SO-I Post by David Waldmann on 04/19/17 at 13:06:34 Tried \\SERVERNAME and IP address. No dice. No error, no list. |
|
Title: Re: Update issue in SO-I Post by David Waldmann on 04/19/17 at 13:16:08 cmsk wrote:
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 David Waldmann wrote:
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. |
|
Title: Re: Update issue in SO-I Post by 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. The Destination Folder on the SM-T screen should be a folder such as DBAMFG\REPORTS where exported files will be saved. |
|
Title: Re: Update issue in SO-I Post by David Waldmann on 04/19/17 at 14:14:53 Lynn_Pantic wrote:
Yes, that is what I did, Lynn_Pantic wrote:
I initially had C:\ISTS\ But nothing happens. Is there a previous step that I missed? |
|
Title: Re: Update issue in SO-I Post by prophet on 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? |
|
Title: Re: Update issue in SO-I Post by David Waldmann on 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. |
|
Title: Re: Update issue in SO-I Post by prophet on 04/20/17 at 12:20:34 Have you tried testing from another workstation or at the Server itself? |
|
Title: Re: Update issue in SO-I Post by David Waldmann on 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. |
|
Title: Re: Update issue in SO-I Post by David Waldmann on 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. |
|
Title: Re: Update issue in SO-I Post by prophet on 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. |
|
Title: Re: Update issue in SO-I Post by David Waldmann on 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. |
|
Title: Re: Update issue in SO-I Post by David Waldmann on 04/21/17 at 05:26:14 David Waldmann wrote:
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 |
|
Title: Re: Update issue in SO-I Post by David Waldmann on 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 ;D |
|
ISTech Support Forum » Powered by YaBB 2.1! YaBB © 2000-2005. All Rights Reserved. |