Database Access not setup for AgilePoint?

已完成

追蹤

Sylvia Able

• 2021年04月29日 19:36

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)

 

 

 

0

• 

  Venkat A

  • 2021年04月30日 01:22

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

  Thanks,
  Venkat

  0

  評論操作 永久連結
• 

  Sylvia Able

  • 2021年04月30日 12:05

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

  0

  評論操作 永久連結
• 

  AgilePoint NX Support

  • 2021年05月22日 05:27

  Hi Sylvia,

   

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

   

  Thanks,

  AgilePoint NX Support

  0

  評論操作 永久連結
• 

  Sylvia Able

  • 2021年05月24日 12:05

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

  0

  評論操作 永久連結

請登入寫評論。