PxPlus User Forum

Twitter Twitter Twitter

Author Topic: ODBC Service Crashing  (Read 3355 times)

Jeffrey Ferreira

  • Diamond Member
  • *****
  • Posts: 188
  • I must have taken a wrong turn at Albuquerque.
    • View Profile
ODBC Service Crashing
« on: April 12, 2024, 08:09:26 AM »
Hello All,

I  have a customer who uses ODBC a lot to access their pxplus files. We have service crashes quite often.
I'm assuming the first thing we should do is update their ODBC Version but before we do that, is their anything that could possibly be going on

thanks

jeff

Error Message:
Faulting application name: pxpiosvr.exe, version: 5.20.0.0, time stamp: 0x51815515
Faulting module name: ntdll.dll, version: 10.0.14393.6343, time stamp: 0x6502749b
Exception code: 0xc0000005
Fault offset: 0x000587a9
Faulting process id: 0x8d2c
Faulting application start time: 0x01da8ccff7520e30
Faulting application path: C:\PVX Plus Technologies\File Server\pxpiosvr.exe
Faulting module path: C:\Windows\SYSTEM32\ntdll.dll
Report Id: e605ac47-8a76-4ee5-abcb-93544bd6bc91
Faulting package full name:
Faulting package-relative application ID:

Jeffrey Ferreira

  • Diamond Member
  • *****
  • Posts: 188
  • I must have taken a wrong turn at Albuquerque.
    • View Profile
Re: ODBC Service Crashing
« Reply #1 on: April 26, 2024, 09:18:00 AM »
I upgraded to version 7.10 and the service still crashes with this generic error.  The problem is I keep having more and more customers wanting to use Power BI to connect to our data.

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 387
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: ODBC Service Crashing
« Reply #2 on: April 26, 2024, 09:40:14 AM »
The crash is happening in a Microsoft Windows DLL: ntdll.dll.

Is this only happening on this one Windows system?

Is it reproducible on other systems?
Principal Software Engineer for PVX Plus Technologies LTD.

Jeffrey Ferreira

  • Diamond Member
  • *****
  • Posts: 188
  • I must have taken a wrong turn at Albuquerque.
    • View Profile
Re: ODBC Service Crashing
« Reply #3 on: April 26, 2024, 09:49:28 AM »
Hi Deven,

The Power BI Reports are specific to this one company so no it is only happening at this company. But i have more companies asking to query data using power bi

jeff



Mike King

  • Diamond Member
  • *****
  • Posts: 3830
  • Mike King
    • View Profile
    • BBSysco Consulting
Re: ODBC Service Crashing
« Reply #4 on: April 29, 2024, 05:48:48 PM »
Jeffrey

The issue may be related to invalid data in your file.  PxPlus doesn't, by default, validate that the data you write into the files matches the data dictionary specifications. On the other hand, ODBC access relies on the fact that the data adheres to the specifications.

What might be happening is that there is a field whose contents is larger than expected thereby causing a memory access problem.

To check this try running the Verify Data option on the Database export utility.  Basically pretend you are going to export your data to a database, launch the export utility from the data dictionary and select "Verify Data".  It should read through your file and check that the file contents adheres to the Data Dictionary specifications.

Good luck
Mike King
President - BBSysco Consulting
eMail: mike.king@bbsysco.com