El Foro

App using odbc crashes

any hints appreciated

Autor Respuestas
shh Wednesday 25 March 2015 at 10:14
shhAnonymous

Hi, my employer just asked me, if a certain piece of software that he uses would run on linux - so I did my best to test and got fairly far, but hit a wall so... here are the details:

- Ubuntu MATE, 14.04 running as guest on a VM server (using KVM)

- WF-MAG (windows version 7.9)

App info, errors and install history:

The app is a stock and invoice management tool currently using MSSQL EXPRESS 2008r2 as its database engine. The database is on a different VM (win 7 pro) and the app connects to the DB through LAN. 

Installing requires at least .NET 3.5, mdac2.8 (though I added vcrun2008). Additionally the software requires CrystalReports XI Runtime. 

The db connection works fine (using FreeTDS and unixodbc), I am able to connect and perform some actions, but after a minute or so the app crashes. 

Errors:

During installation of Crystal Reports Runtime:

Runtime Error! Program c:\Windows\system32\msiexec.exe, no further info. However the main app installs correctly regardles of this error.

On launching the main app:

Create MSXML2.XMLHTTP error (REGDB_E_CLASSNOTREG) 80040154 

Than the app continues startup. I can leave the window open for an indefinite time and it is all OK. I can open sub-windows and commit changes to the DB, create invoices and so on. At a seemingly random moment the app crashes - no errors, all I get is the POL debug window.

 

The full debug log is pretty long, should I post this or is it better to use pastebin or host it somwhere?

Ronin DUSETTE Wednesday 25 March 2015 at 15:26
Ronin DUSETTE

If you could post the full debug log via pastebin, that would be cool. That would probably tell us a lot more. Also, what version of Wine are you using to build the virtual drive? What architecture? I would start with the newest version of Wine, in a clean 32-bit virtual drive (1.7.39 x86), install NOTHING extra (nothing from the Install Components tab), try to install/run the program, and let's start with that particular log first. With Wine, you want to install as little extra as possible. wine-mono provides some .NET compatibility, and that will install automatically with Wine, so try that for now. 

Also, install libxml2:i386, as it looks like that will be needed by Wine (install it into your Linux machine), before doing what I said above, and let's see if that works a little better. Or at least gives us some more insight. 


Please:
Post debug logs & full computer specs in first post
No private messages for general help, use the forums
Read the wiki, Report broken scripts
shh Thursday 26 March 2015 at 8:57
shhAnonymous

Hi again.

First of all - thanks for the reply.

Next - my current setup and logs:

POL version 4.2.2

using wine version 1.7.39, 32 bit install with .net, mdac28, vcrun2008. 

The debug log (used a polish pastebin alternative as I don't have a pro account there...)

http://wklej.to/Skiih

So thats it for now. I'm going to test the libxml2:i386 today and add results here.

Best regards,

Shh

Edit 1: libxml2:i386 was already on the linux box.

Edit 2: Started with a clean wineprefix/drive in POL as suggested, am currently debating if I should try to install the Crystal Reports Runtime required by the main app without errors (Microsoft Visual C++ error, msiexec.exe, This application has requested the Runtime to terminate it in an unusual way) or to ignore the errors and try plowing forward with the main software package.

Editado por: shh

Ronin DUSETTE Thursday 26 March 2015 at 18:22
Ronin DUSETTE

Upgrade to POL 4.2.6. Just to make sure you are up to date with that. The only reason I said start with a clean prefix is so that you only add stuff from Install Components as needed. If it is needing that stuff, for sure install it. I just wanted to make sure that it really needed those things. lol. 

Try and do that. If is complaining about it, attempt to correct it. 


Please:
Post debug logs & full computer specs in first post
No private messages for general help, use the forums
Read the wiki, Report broken scripts