1. Tatiana Blanco
  2. PowerServer
  3. Friday, 24 March 2023 16:41 PM UTC

Hello

 I recently migrated to Mysql 8.0 (from 5.6) and I am having an issue with my reporting application, when accessing a report that calls a stored procedure, i am receiving this error:

I searched about it, and it seems that Mysql 8.0 does not have that table anymore that was needed before to access a stored procedure.

Investigating, looked into the MySQL driver installer /dll and is 8.0.18

But looks like the MySql.Data.dll drivers  that power server is using are not updated (I found two places C:\\inetpub\\wwwroot\appeon\AEM\bin

and

C:\\inetpub\\wwwroot\appeon\Toolkit\status monitor).

I tried to manually replace the old ones with the new one and resulted in a error, when running my web application (see error from my appeon logs), I had to put it back, it seems that in some harcoded place is looking for the Version=60308, but i couldnt find it .

Please I need some help with this issue, I'd appreciate if any other light can be shed on this.

"

2023-03-22 08:54:37.099 : [Application name=reports,conn cache=SQLCA]Could not load file or assembly 'MySql.Data, Version=6.3.8.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
   at Appeon.Server.Services.DataService.DataServiceFactory.CreateDBConnection(PBTransactionProperties pbTrans, String connCache, String ext)
   at Appeon.Server.Services.DataService.DataServiceFactory.CreateDBConnection(PBTransactionProperties pbTrans, String connCache)
   at Appeon.Server.Commands.ConnectDBCommand.AttempToConnectDatabase()
   at Appeon.Server.Commands.ConnectDBCommand.Execute()

"

Thank you in advance for your help.

Tatiana.

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 24 March 2023 16:52 PM UTC
  2. PowerServer
  3. # 1

Hi Taliana;

  Looks like your using the old PowerServer version 2020 or older. The v2020 release was deprecated in 2020 and is now the last release to use that technology platform. PS version 2021 and higher is now totally different and not only supports native "Cloud" Apps but also has newer DBMS driver support.

  My suggestion currently though would be to open a support ticket for this issue as PS 2020 still has long term support. It might be possible that Engineering has a fix for this or a possible workaround.  HTH

Regards ... Chris

Comment
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.