Global Data Management Forum

  • 1.  .NET Core 3.1 Deployment

    Posted Thu August 06, 2020 05:27 PM
    I have a .net core site running successfully locally using the .NET Core 3.1/Entity Framework nuget packages. I next want to publish this site to a server (within our network, not cloud) which so far I have not been successful. The site itself is functional, however any communication via the connector fails.  I feil like I've read all the articles provided (multiple times), but I haven't had any luck trying different things from that information. There is a lot of mixed info from the articles (nuget vs manual download nuget, install db2 connect vs nothing else required, etc., set PATH variable vs only needing to in linux) making it hard to know what is correct for the version I am using (latest, 3.1.0.200). I have to be missing something as I continue to get the following error:

    2020-08-06T13:32:24.8236361-04:00 800003a4-0001-ff00-b63f-84710c7967bb [ERR] An exception occurred while iterating over the results of a query for context type '"Reporting.Models.IbmIDbContext"'."

    ""IBM.Data.DB2.Core.DB2Exception (0x80004005): ERROR [58005] [IBM][DB2.NET] SQL0902 An unexpected exception has occurred in  Process: 8036 Thread 8 AppDomain: Name:Reporting

    There are no context policies. Function: AESEncryptADONET (Encryption Info)

    This seems similar to this FAQ item:

    https://community.ibm.com/community/user/hybriddatamanagement/blogs/michelle-betbadal1/2020/04/29/frequently-asked-questions-about-ibm-db-net-core-p?CommunityKey=f2e5dc34-896d-4e8e-9678-724907c4b9f5&tab=recentcommunityblogsdashboard


    Where it says:

         The .NET driver is unable to find the compatible GSKit. Set the Path(on Windows) or LD_LIBRARY_PATH(on Linux) to the <Package_Install_location>/<package-name>/<version>/build/clidriver/lib directory of your environment. Remember, this may affect other applications.



    I've set the PATH env variable pointing to the bin directory (as well as many other attempted directories to just try stuff), but I just continue getting this error. Can anyone shed light on the full requirements based on the latest 3.1.0.200 version of the IBM DB2 Connector?

    Thank you.
    Shaun



    ------------------------------
    Shaun Steckley
    ------------------------------

    #DataManagementGlobal
    #DataServerDrivers


  • 2.  RE: .NET Core 3.1 Deployment
    Best Answer

    Posted Tue September 22, 2020 04:33 PM
    I worked with IBM support on this and it turns out that the Visual C++ Redistributable Packages for Visual Studio 2013 for 32 and 64 bit are also needed. Once I installed that, the error stopped and the application started communicating as expected.

    I wanted to note in case it helps others in the future.

    ------------------------------
    Shaun Steckley
    ------------------------------



  • 3.  RE: .NET Core 3.1 Deployment

    Posted Wed November 18, 2020 11:47 AM
    This was exactly the problem for us as well. Thanks for the solution Shaun, saved us a ton of time.

    For reference, for anyone else - this was on an Azure VM. We had .NET Core 3.1 installed, but needed the Visual Studio 2013 Redistributable package as well.

    ------------------------------
    Kiran Ramaswamy
    ------------------------------