1. Menna Pablo Javier
  2. PowerBuilder
  3. Tuesday, 28 March 2023 15:26 PM UTC

Hi,
I have a problem that appeared after we migrated the system to PowerBuilder 2021, with SQLServer 2017 and SQLServer 2019 databases.
It is presented when we call dw.retrieve(). Although the query does start (from what we can see from the SQLServer Profiler), the Select does not return the data. We note that dw.rowcount() = 0.
The problem is randomly generated. The following is logged in the Windows event viewer:

Error,3/28/2023 10:39:12,Application Error,1000,(100),"Faulting Application Name: system.exe, version: 1.1.0, time stamp: 0x61e55e53
Faulting Module Name: pbSNC.dll, Version: 21.0.0.1288, Timestamp: 0x61020394
Exception Code: 0xc000041d
Error Offset: 0x000023f0
Faulting process identifier: 0x15e4
Faulting Application Start Time: 0x01d961759f81aa11
Faulting application path: C:\Systems\system.exe
Faulting module path: C:\Systems\pbSNC.dll
Report Identifier: c5293e9e-e0eb-4639-83a3-be04d1f240df
Full name of the package with errors:
Faulting package relative application identifier: "

 

Any idea the reason for this error?
Thank you so much
Regards

Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 28 March 2023 16:05 PM UTC
  2. PowerBuilder
  3. # 1

Are you compiling your app as 32-bit or 64-bit?

Do you still have same problem if you use the new MSOLEDBSQL driver instead?

Comment
  1. Armeen Mazda @Appeon
  2. Wednesday, 29 March 2023 18:23 PM UTC
You're very welcome. Yes, PB 2021 requires v18 of the driver that's why I said to not install 19. In future when you upgrade to PB 2022 you can use version 19 of the driver.
  1. Helpful 1
  1. Menna Pablo Javier
  2. Wednesday, 19 April 2023 14:04 PM UTC
Hi,

We have changed the connector to use the MSOLEDBSQL. But randomly it keeps producing errors like the following:



Nombre de la aplicación con errores: sistema.exe, versión: 4.1.50.4, marca de tiempo: 0x61e55e53

Nombre del módulo con errores: pbmsoledbsql.dll, versión: 21.0.0.1506, marca de tiempo: 0x61e55ef3

Código de excepción: 0xc000041d

Desplazamiento de errores: 0x000023f0

Identificador del proceso con errores: 0x26cc

Hora de inicio de la aplicación con errores: 0x01d971fe8750618e

Ruta de acceso de la aplicación con errores: C:\Sistemas\sistema.exe

Ruta de acceso del módulo con errores: C:\Sistemas\pbmsoledbsql.dll

Identificador del informe: 843c3400-ac07-4129-994f-835f3adf6b5e

Nombre completo del paquete con errores:

Identificador de aplicación relativa del paquete con errores:



Any idea why this error is?

Thanks.

Regards
  1. Helpful
  1. Chris Pollach @Appeon
  2. Wednesday, 19 April 2023 15:31 PM UTC
Hi Menna;

Since you are now using the MSO SS DB Driver and this issue is happening - please open a Support Ticket for this issue and also please attach the mini-dump to this ticket as well. Thanks!

Regards ... Chris
  1. Helpful 1
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.