Genexus 15 U4 - Query + Mysql 64bit Object Preview

Asked

Viewed 660 times

0

Clicking on the Preview tab of the Query Object returns the error:

Can not display the preview of the query:
Type:Genexus.Data.Gxadodataexception.An attempt was made to load a program with an incorrect format. (HRESULT exception: 0x8007000B)

The following is an excerpt from the client.log obtained in: C: Programdata Genexus Genexus 15 Querypreview

21:46:38,606 [3] DEBUG Genexus.Configuration.Config - DOMConfigurator log4net configured with web.config
21:46:38,621 [3] DEBUG Genexus.Configuration.Config - GxClasses version:15.0.4.113785
21:46:38,643 [3] DEBUG Genexus.Application.GxContext - GxContext.Ctr Default handle:1
21:46:38,663 [3] DEBUG GeneXus.Data.ADO.GxConnectionManager - GxConnectionManager.NewConnection   handle: 1, datasource:Default
21:46:38,734 [3] DEBUG Genexus.Application.GXFileWatcher - DeleteFiles C:\ProgramData\GeneXus\GeneXus\15\QueryPreview\PublicTempStorage\
21:46:38,735 [3] DEBUG Genexus.Configuration.Preferences - BLOB_PATH:C:\ProgramData\GeneXus\GeneXus\15\QueryPreview\PublicTempStorage\
21:46:38,736 [3] DEBUG GeneXus.Data.ADO.GxConnection - Setting IsolationLevel : Read Commited
21:46:39,199 [3] DEBUG GeneXus.Resources.GXResourceManager - FindResources C:\ProgramData\GeneXus\GeneXus\15\QueryPreview\bin\messages.eng.dll
21:46:39,257 [3] WARN  Genexus.Application.GxContext - Could not set Cache Control Http Header Value 'no-cache, no-store' to HttpResponse
21:46:39,324 [3] DEBUG Genexus.Application.GxContext - AbsoluteUri dynamicport:http://localhost:52024/QueryPreview/queryviewer.aspx
21:46:39,345 [3] DEBUG GeneXus.Data.ADO.GxConnectionManager - RemoveConnection   handle 1,datasource:Default
21:46:39,383 [3] DEBUG GeneXus.Http.GXHttpHandler - HttpHeaders: Cache-Control:no-cacheConnection:Keep-AliveContent-Length:764Content-Type:application/x-www-form-urlencodedAccept:image/gif, image/jpeg, image/pjpeg, application/x-ms-application, application/xaml+xml, application/x-ms-xbap, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*Accept-Encoding:gzip, deflateAccept-Language:pt-BRCookie:GX_CLIENT_ID=db1daaa8-0c43-4ead-a3e6-f391f0103647; GX_SESSION_ID=LEKn9U6uVzncnSe4kP%2bg1WQjWR0gsjpK0a5t8atYhrw%3dHost:localhost:52024User-Agent:Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 10.0; WOW64; Trident/7.0; .NET4.0C; .NET4.0E; Tablet PC 2.0; .NET CLR 2.0.50727; .NET CLR 3.0.30729; .NET CLR 3.5.30729)
HttpCookies: 
GX_CLIENT_ID:db1daaa8-0c43-4ead-a3e6-f391f0103647
GX_SESSION_ID:LEKn9U6uVzncnSe4kP%2bg1WQjWR0gsjpK0a5t8atYhrw%3d
21:46:39,383 [3] DEBUG Genexus.Application.GxContext - AbsoluteUri dynamicport:http://localhost:52024/QueryPreview/queryviewer.aspx
21:46:40,028 [3] DEBUG Genexus.Application.GxContext - GxContext.Ctr Default handle:2
21:46:40,028 [3] DEBUG GeneXus.Data.ADO.GxConnectionManager - GxConnectionManager.NewConnection   handle: 2, datasource:Default
21:46:40,028 [3] DEBUG GeneXus.Data.ADO.GxConnection - Setting IsolationLevel : Read Commited
21:46:40,042 [3] DEBUG GeneXus.Data.ADO.GxConnectionManager - RemoveConnection   handle 2,datasource:Default
21:46:40,045 [3] DEBUG GeneXus.Http.GXHttpHandler - HttpHeaders: Cache-Control:no-cacheConnection:Keep-AliveContent-Length:0Content-Type:application/x-www-form-urlencodedAccept:*/*Accept-Encoding:gzip, deflateAccept-Language:pt-BRCookie:GX_CLIENT_ID=db1daaa8-0c43-4ead-a3e6-f391f0103647; GX_SESSION_ID=LEKn9U6uVzncnSe4kP%2bg1WQjWR0gsjpK0a5t8atYhrw%3d; ASP.NET_SessionId=jg1jji45aywwtcodo1hirgt2Host:localhost:52024Referer:http://localhost:52024/QueryPreview/queryviewer.aspxUser-Agent:Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 10.0; WOW64; Trident/7.0; .NET4.0C; .NET4.0E; Tablet PC 2.0; .NET CLR 2.0.50727; .NET CLR 3.0.30729; .NET CLR 3.5.30729)
HttpCookies: 
GX_CLIENT_ID:db1daaa8-0c43-4ead-a3e6-f391f0103647
GX_SESSION_ID:LEKn9U6uVzncnSe4kP%2bg1WQjWR0gsjpK0a5t8atYhrw%3d
ASP.NET_SessionId:jg1jji45aywwtcodo1hirgt2
21:46:40,045 [3] DEBUG Genexus.Application.GxContext - AbsoluteUri dynamicport:http://localhost:52024/QueryPreview/agxpl_getrecordsetcachekey.aspx?1493776000022
21:46:40,051 [2] DEBUG Genexus.Application.GXFileWatcher - TIMEOUT (from system.web/httpRuntime ExecutionTimeout)110 seconds
21:46:40,057 [3] DEBUG Genexus.Application.GxContext - GxContext.Ctr Default handle:3
21:46:40,057 [3] DEBUG GeneXus.Data.ADO.GxConnectionManager - GxConnectionManager.NewConnection   handle: 3, datasource:Default
21:46:40,057 [3] DEBUG GeneXus.Data.ADO.GxConnection - Setting IsolationLevel : Read Commited
21:46:40,235 [3] DEBUG GeneXus.Data.ADO.GxConnectionManager - RemoveConnection   handle 3,datasource:Default
21:46:40,236 [3] DEBUG GeneXus.Http.GXHttpHandler - HttpHeaders: Cache-Control:no-cacheConnection:Keep-AliveContent-Length:946Content-Type:application/x-www-form-urlencodedAccept:*/*Accept-Encoding:gzip, deflateAccept-Language:pt-BRCookie:GX_CLIENT_ID=db1daaa8-0c43-4ead-a3e6-f391f0103647; GX_SESSION_ID=LEKn9U6uVzncnSe4kP%2bg1WQjWR0gsjpK0a5t8atYhrw%3d; ASP.NET_SessionId=jg1jji45aywwtcodo1hirgt2Host:localhost:52024Referer:http://localhost:52024/QueryPreview/queryviewer.aspxUser-Agent:Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 10.0; WOW64; Trident/7.0; .NET4.0C; .NET4.0E; Tablet PC 2.0; .NET CLR 2.0.50727; .NET CLR 3.0.30729; .NET CLR 3.5.30729)
HttpCookies: 
GX_CLIENT_ID:db1daaa8-0c43-4ead-a3e6-f391f0103647
GX_SESSION_ID:LEKn9U6uVzncnSe4kP%2bg1WQjWR0gsjpK0a5t8atYhrw%3d
ASP.NET_SessionId:jg1jji45aywwtcodo1hirgt2
21:46:40,236 [3] DEBUG Genexus.Application.GxContext - AbsoluteUri dynamicport:http://localhost:52024/QueryPreview/agxpl_getmetadata.aspx?1493776000047
21:46:40,243 [3] DEBUG Genexus.Application.GxContext - GxContext.Ctr Default handle:4
21:46:40,243 [3] DEBUG GeneXus.Data.ADO.GxConnectionManager - GxConnectionManager.NewConnection   handle: 4, datasource:Default
21:46:40,243 [3] DEBUG GeneXus.Data.ADO.GxConnection - Setting IsolationLevel : Read Commited
21:46:40,350 [3] DEBUG Genexus.Application.GxContext - GxContext.Ctr Default handle:5
21:46:40,351 [3] DEBUG GeneXus.Data.ADO.GxConnectionManager - GxConnectionManager.NewConnection   handle: 5, datasource:Default
21:46:40,351 [3] DEBUG GeneXus.Data.ADO.GxConnection - Setting IsolationLevel : Read Commited
21:46:40,360 [3] DEBUG GeneXus.Data.NTier.DataStoreProvider - Start DataStoreProvider.Ctr, Parameters: handle '5', dataStoreHelper:QueryViewer.Services.dsHelper
21:46:40,365 [3] DEBUG GeneXus.Data.ADO.GxCommand - GxCommand.FetchSize: 100, handle '5'
21:46:40,369 [3] DEBUG GeneXus.Data.NTier.DataStoreProvider - gxObject:QueryViewer.Services.dsHelper, handle '5' cursorName:gxpl0001
21:46:40,375 [3] DEBUG GeneXus.Data.ADO.GxCommand - ExecuteReader: Parameters 
21:46:40,378 [3] DEBUG GeneXus.Data.GxMySql - ExecuteReader: client cursor=False, handle '5', hashcode 28123475 PreparedStmt True
21:46:40,381 [3] DEBUG GeneXus.Data.ADO.GxConnection - Start GxConnection.Open, autoCommit=False handle:5 datastore:Default
21:46:40,387 [3] DEBUG GeneXus.Data.GxMySql - MAX_TRIES=100
21:46:40,387 [3] DEBUG GeneXus.Data.GxMySql - Setting connectionString property Location=localhost;Port=3306;;User ID=root;Password=xxxxx;Data Source=CoopHortaDES;
21:46:40,392 [3] ERROR GeneXus.Data.MySqlConnectionWrapper - Return GxConnection.Open Error 
System.BadImageFormatException: Foi feita uma tentativa de se carregar um programa com um formato incorreto. (Exceção de HRESULT: 0x8007000B)
   em MySQLDriverCS.CPrototypes.mysql_init(Void* must_be_null)
   em MySQLDriverCS.MySQLConnection.Open()
   em GeneXus.Data.MySqlConnectionWrapper.Open()
21:46:40,432 [3] DEBUG GeneXus.Data.GxMySql - ProcessError: dbmsErrorCode=0, emsg 'Foi feita uma tentativa de se carregar um programa com um formato incorreto. (Exceção de HRESULT: 0x8007000B)'
21:46:40,433 [3] ERROR GeneXus.Data.ADO.GxConnection - GxConnection.Open Error 
Type:GeneXus.Data.GxADODataException.Foi feita uma tentativa de se carregar um programa com um formato incorreto. (Exceção de HRESULT: 0x8007000B)
21:46:40,433 [3] ERROR GeneXus.Data.ADO.GxCommand - Return GxCommand.ExecuteReader Error 
Type:GeneXus.Data.GxADODataException.Foi feita uma tentativa de se carregar um programa com um formato incorreto. (Exceção de HRESULT: 0x8007000B)
21:46:40,433 [3] DEBUG GeneXus.Data.GxMySql - ProcessError: dbmsErrorCode=0, emsg 'Foi feita uma tentativa de se carregar um programa com um formato incorreto. (Exceção de HRESULT: 0x8007000B)'
21:46:40,458 [3] ERROR GeneXus.Data.ADO.GxCommand - GxCommand.FetchData Error 
21:46:40,462 [3] DEBUG GeneXus.Data.ADO.GxConnection - UncommitedChanges before Close:False
21:46:40,463 [3] DEBUG GeneXus.Data.ADO.GxConnection - GxConnection.Close connection is closed 
21:46:40,464 [3] DEBUG GeneXus.Data.ADO.GxConnectionManager - RemoveConnection   handle 5,datasource:Default
21:46:40,464 [3] DEBUG GeneXus.Data.ADO.GxConnection - UncommitedChanges before Close:False
21:46:40,464 [3] DEBUG GeneXus.Data.ADO.GxConnection - GxConnection.Close connection is closed 
21:46:40,478 [3] DEBUG Genexus.Application.GxContext - GxContext.Ctr Default handle:6
21:46:40,478 [3] DEBUG GeneXus.Data.ADO.GxConnectionManager - GxConnectionManager.NewConnection   handle: 6, datasource:Default
21:46:40,478 [3] DEBUG GeneXus.Data.ADO.GxConnection - Setting IsolationLevel : Read Commited
21:46:40,483 [3] DEBUG GeneXus.Data.ADO.GxConnectionManager - RemoveConnection   handle 4,datasource:Default
21:46:40,483 [3] DEBUG GeneXus.Http.GXHttpHandler - HttpHeaders: Cache-Control:no-cacheConnection:Keep-AliveContent-Length:866Content-Type:application/x-www-form-urlencodedAccept:*/*Accept-Encoding:gzip, deflateAccept-Language:pt-BRCookie:GX_CLIENT_ID=db1daaa8-0c43-4ead-a3e6-f391f0103647; GX_SESSION_ID=LEKn9U6uVzncnSe4kP%2bg1WQjWR0gsjpK0a5t8atYhrw%3d; ASP.NET_SessionId=jg1jji45aywwtcodo1hirgt2Host:localhost:52024Referer:http://localhost:52024/QueryPreview/queryviewer.aspxUser-Agent:Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 10.0; WOW64; Trident/7.0; .NET4.0C; .NET4.0E; Tablet PC 2.0; .NET CLR 2.0.50727; .NET CLR 3.0.30729; .NET CLR 3.5.30729)
HttpCookies: 
GX_CLIENT_ID:db1daaa8-0c43-4ead-a3e6-f391f0103647
GX_SESSION_ID:LEKn9U6uVzncnSe4kP%2bg1WQjWR0gsjpK0a5t8atYhrw%3d
ASP.NET_SessionId:jg1jji45aywwtcodo1hirgt2
21:46:40,483 [3] DEBUG Genexus.Application.GxContext - AbsoluteUri dynamicport:http://localhost:52024/QueryPreview/agxpl_getdata.aspx?1493776000239
21:46:40,486 [9] DEBUG GeneXus.Data.ADO.GxConnectionManager - RemoveConnection   handle 6,datasource:Default
genexus

3 answers

1

Good evening, got it. I believe there are some points we can think about.

first. the link on the WIKI that points to the 64bit connector, to my understanding, points to the wrong download as I downloaded it, I caught the dll in Syswow64, and it didn’t work. Searching the Mysql site, I went to the connector mysql-Connector-c-6.1.10-winx64. zip . I downloaded it and the dll worked. So it wouldn’t be the case to update the wiki?

2º. If Genexus distributes Webdev.Webserver2 64bits, why not just bring the 64bits dll in the install?!

Well, anyway, thanks for the tips! Anyone can mark as solved?

0

Claudio,

In the C: Programdata folder Genexus Genexus 15 Querypreview bin will probably have the Mysql . dll, called Mysqldrivercs.dll. Try replacing it with the 64-bit dll.

  • So, but I did not find the 64bit Mysqldrivercs.dll.... in the project, which has the link on the wiki, does not have.

  • Claudio, According to information from Genexus itself, 64-bit drivers can be downloaded from: https://dev.mysql.com/downloads/file/? id=382641 Source: http://wiki.genexus.com/commwiki/servlet/wiki?2041,Mysql+driver+for+. NET+installation,

0

The error message is indicating that the driver version is not right (32 vs 64 bit).

The Query preview uses a web server called Webdev.Webserver2, it can be 32 or 64 bits. You have to see which version you have of this web server (Genexus distributes 64-bit version). In this case you have to put yourself in the folder C: Programdata Genexus Genexus 15 Gxplorer Preview bin 64-bit driver for Mysql.

In the SAC #40940 has complementary information.

Browser other questions tagged genexus

You are not signed in. Login or sign up in order to post.