Feedback
Did this article resolve your question/issue?

   

Article

OpenAccess .NET service crash when query has doubleval() with 64-bit application in Local mode

Information

 
TitleOpenAccess .NET service crash when query has doubleval() with 64-bit application in Local mode
URL Nameopenaccess-net-service-crash-when-query-has-doubleval-with-64-bit-application-in-local-mode
Article Number000122657
EnvironmentProduct: Openaccess Local ODBC Client
Version: 8.1.0089
OS: Windows
Application: 64-bit ODBC application
Question/Problem Description
OpenAccess .NET service crash with 64-bit application in Local mode when query has doubleval().
Steps to ReproduceBuild the 64-bit OpenAccess example1 sample IP.
Create an ODBC data sources that uses and example1 sample IP.
From Excel 64-bit:
Choose Data/Get Data/From other data sources/From ODBC.
Choose the OpenAccess Local data source, then open Advanced Options and add this SQL Statement:
select name, intval, doubleval(floatval), time from curvalue;
click OK
Clarifying Information
Error MessageMicrosoft.Mashup.Evaluator.Interface.ErrorException: Exception has been thrown by the target of an invocation. --->
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. --->
System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

Exception has been thrown by the target of an invocation.
Exception thrown: read access violation.
**pValExpList** was 0x32F37DF8. Occurred
Defect NumberDefect OASL-305
Enhancement Number
Cause
The OpenAccess .Net layer was not passing the scalar value expression as a 64-bit integer.
Resolution
Fixed in hot fix 8.1.0.0092.
Refer to article OpenAccess SDK hot fix download and install instructions for instructions on how to download and install the hot fix.
Workaround
Notes
Last Modified Date11/20/2020 7:02 AM
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.