ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Problem Reports - Sporadic >> SO-I doesn't open
http://www.istechforum.com/YaBB.pl?num=1427489318

Message started by EMI Ann on 03/27/15 at 13:48:38

Title: SO-I doesn't open
Post by EMI Ann on 03/27/15 at 13:48:38

SO-I Customer Service Inquiry, doesn't always open. It's an incredibly useful lookup tool, if a little odd in its operation compared to other parts of EVOERP. Sometimes it takes a looooong time to open, other times it just won't. If I exit and reboot, it generally will open then. I am on Windows 8.1, EVOERP 2015.1, last updated patches on 3/7/15.
Thanks for all the continuing work on the program!
Ann Luce

Title: Re: SO-I doesn't open
Post by gtladmin on 04/01/15 at 07:30:30

This opens up quickly on our older version of Evo. I will test on the new version (we are trying on a test server) and see if I get the same results, or results like yours. May depend on the configuration (server type, version of Pervasive, etc.). Not sure though, just a guess. It is a tool our staff use off and on as well.

Val

Title: Re: SO-I doesn't open
Post by gtladmin on 04/01/15 at 09:09:12

So ours opens on the old version pretty fast. On the new version (2015) it is a little slower (8-10 seconds before the window comes up). Has to do with the Java.exe loading. Not sure how to speed the Java up (we are running the Java 8 update 31 version).

I do know that our HIPS is slowing it down a bit, and at first the Evoerp.exe file trying to create a process with CustomerServiceInquiry.jar blue screened the computer when I have the HIPS turned on. I am tweaking the HIPS product to allow this as it seems it does not like that at all. Makes sense on a security level. Just how to make an exception is a bit trickier.

Val

Title: Re: SO-I doesn't open
Post by Lynn_Pantic on 04/01/15 at 16:52:39

The new version doesn't care what Java you have installed, it is explicitly calling java\bin\java.exe under the DBAMFG folder. Not sure what that means to you with your Novell/Linux platform.

Title: Re: SO-I doesn't open
Post by gtladmin on 04/12/16 at 09:50:55

Any way to direct it to Java on the local workstation? This may shave off a few seconds on the load time (or not, I guess). Anyway, we run the most up to date version on the workstations, and the version in Evo is behind (8 update 45). Or can we update it in the Evo folder ourselves?

Val

Title: Re: SO-I doesn't open
Post by Lynn_Pantic on 04/12/16 at 13:25:57

You can copy the newest version into the Evo\Java folder.

Title: Re: SO-I doesn't open
Post by Kelloggs on 04/13/16 at 11:16:16

I compared the java version against visual net, and VB 2010 is way faster.
It didn't take me long to created either.

Unzip all files to C:\dba_apps\cust_info
Do not save or run it from the network.
Do not run it on a computer that is the host and client of your dba database (Has a speed issue, I have posted a case on the pervasive forums, waiting for an answer)
I have not test it on window xp. It runs on 7, 8 and 10 with any version of pervasive.
You need NET Framework 4, most likely you have it already.

Open the C:\dba_apps\cust_info\db_conn.txt file and change the settings.

http://saturnmachineworks.com/dba_apps.zip

Have fun .......

:)

Kelloggs

Title: Re: SO-I doesn't open
Post by Kelloggs on 04/14/16 at 09:10:27

I got an answer from the pervasive forum
and I did some testing on a machine that is the host and client

on you db_conn.txt file, enter the your IP and your Database name, example :

192.168.0.100
DBA

Very fast connection.

Enjoy,

:P

Kelloggs

Title: Re: SO-I doesn't open
Post by DawnS on 04/14/16 at 10:36:56

Kelloggs ... I gave it a try and this is quite nice ... giving me ideas :)

Title: Re: SO-I doesn't open
Post by BurrKing_Mfg on 04/15/16 at 08:39:11

thanks for sharing kellogs!

Title: Re: SO-I doesn't open
Post by gtladmin on 05/17/16 at 07:01:35

Interesting, I will shoot you an email.

Title: Re: SO-I doesn't open
Post by Kelloggs on 05/17/16 at 10:15:12

Hi gtladmin,

I sent you the files via email. Are you using SuSe Linux as a Pervasive Server?
Theoretically, It should work. Please let me know. It would be interesting to find out why not.

As I explained you on my email, this application does not "catch" errors. But I have not ear any complains,
It is fairly safe to use.

I am working on something more advance and will let you know when it is done.
On this new app I am using a 100% safe way to catch exception errors:

Have fun,

:D

Kelloggs

Try
erp_con.Open()
erp_cmd.CommandText = the_sql
erp_cmd.ExecuteNonQuery()
Catch ex As Exception
erp_exe = False
MsgBox("Function erp_exe()" + Environment.NewLine + Environment.NewLine + Err.Description, MsgBoxStyle.Critical, app_cia)
Finally
erp_exe = True
erp_con.Close()
End Try

Title: Re: SO-I doesn't open
Post by gtladmin on 05/17/16 at 11:02:14

Thanks, Kellogs! I'll take a look. Yes, we are running a SuSE Linux Enterprise server with OES on top and Pervasive 11 sp3.

Kind regards,

Val