	Product(s):	APM Implementation and Performance Management
	Version(s):	7
	Environment:	N/A
	Area:	N/A
	Subarea:	N/A

Problem Description

An APM (rel 7.19) user with an Oracle database recently upgraded their Oracle Instance from Oracle 12c to Oracle 19. Post upgrade, the Checksheets stopped generating automatically. The error logs indicated that some Oracle prerequisites are missing:

2022-12-17 12:00:00.0000Z Error Bentley.APM.Common.Db.GenericDatabaseConnector [1] Unable to find Oracle.DataAccess.Client data provider EXCEPTION OCCURRED:ArgumentException Unable to find the requested .Net Framework Data Provider. It may not be installed. at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName) at Bentley.APM.Common.Db.GenericDatabaseConnector.CreateDatabaseFactoryAndConnectionStringBuilder()

2022-12-17 12:00:00.0000Z Error Bentley.APM.Common.Db.GenericDatabaseConnector [1] Failing over to the ODBC data provider because we couldn't use the proper data provider for the database, please make sure you have all prerequisites installed. The ODBC data provider is not optimal

Solution

This is due to an Oracle change in behaviour between Oracle 12 and Oracle 19. Oracle 19 relies on info in the app.config for non ODBC connections to the database. In older versions of Oracle (including 12) this was handled in a global app.config but since not every app on a PC is running the same version of Oracle, Oracle changed it in Oracle 18 onwards so that now each app needs it's own app.config with the info on how to connect to Oracle when they are not using ODBC.

This has been addressed by adding 3 new configuration files to APM for different services that independently connect to the database. These files are as follows:

InteropWorkOrderChecksheetGen.exe

XMLGenConsole.exe

Bentley.APM.Service.Monitor.exe

This has been addressed in release 7.20.

If you are and Oracle user recently upgrading to Oracle 19 and experiencing this error shown above, please launch a Service Request for investigation to determine which services may be affected and which will need to have their configuration files updated.

Checksheets stopped generating after upgrading to Oracle 19

Problem Description

Solution

See also