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