ACE15: Duplicate ODBC Entries in Different Components

AdminStudio 2021 R2 | 22.0 | Application Manager

Edition:This test is included in the AdminStudio Professional and Enterprise Editions.

ACE15 checks for the existence of identical ODBC entries in components with different ComponentId values.

Test Group/Test Category

Application Conflicts/Package Data Conflicts/ODBC Resources

Severity

Error

Message

The ODBC entry [ODBC_ENTRY] in the component [COMPONENT1] in the package [PACKAGE1] conflicts with the same ODBC entry in the component [COMPONENT1] in the package [PACKAGE2].

Background

If identical ODBC entries exist in components with different ComponentId values, ACE15 fails.

Resolution

Automatic Fix (CARD15)

CARD15 changes the ComponentId value of the source package to match that of the target package. To do this, CARD15 runs the following query against the source package and then updates the ComponentId value with the ComponentId value from the target package:

SELECT `ComponentId` FROM

Component` WHERE `Component` = 'Source Package ComponentId'

See Also

Conflict Application Resolution Definitions (CARDs)