I'm moving a MySQL database application to our production environment for the first time and I setup the MySQL database access token and tested it and it returns success.
However, when I publish and run my form, it cannot access the database. The error in the log is listed at the bottom of this post.
I searched the production AgilePoint folders and there are no "Oracle.ManagedDataAccess" files anywhere, but in development, there are several. Apparently, something isn't installed in production. I do see the 4 AgilePoint services running on the machine and I compared the settings in the AP Server Manager between prod and dev machines and most everything looks the same. I do see that there's an extension called "Enterprise Social" on dev that is not on prod, but most everything else looks the same....
2021-04-29 19:19:39.734 >>> Exception: System.InvalidOperationException: Error occurred while invoking the method :ExecuteSQLQuery, Error: Could not load file or assembly 'Oracle.ManagedDataAccess, Version=18.104.22.168, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.ManagedDataAccess, Version=22.214.171.124, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
at AgilePoint.Workflow.DataSources.DataSourceDescriptorDatabase.GetOracleUserIDAttributeName(String connstr)
at AgilePoint.Workflow.DataSources.DataSourceDescriptorDatabase.ExecuteSQLQuery(CustomMethodParameter obj)
--- End of inner exception stack trace ---
at m7.f(Type A_0, String A_1, CustomMethodParameter A_2)
at m7.f(String A_0, String A_1, String A_2, CustomMethodParameter A_3)
at ng.InvokeDynamicAssemblyMethodHandler(String UniqueMethodName, List`1 Parameters)
Please sign in to leave a comment.