Database Access not setup for AgilePoint?

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=4.122.19.1, 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=4.122.19.1, 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)

Venkat A

April 30, 2021 01:22

Hi Sylvia,
Does your production and development have same agilepoint version installed ?

Thanks,
Venkat

Sylvia Able

April 30, 2021 12:05

Yes, same version in both prod and dev. 7.0 SU2.6

AgilePoint NX Support

May 22, 2021 05:27

Hi Sylvia,

Can you drop in a support ticket request for this so that we can coordinate look into it?

Thanks,

May 24, 2021 12:05

I don't see this problem anymore. I resolved somehow but forget how. This can be closed.

Database Access not setup for AgilePoint?

Comments

Didn't find what you were looking for?