BAM does not run after maintenance pack update (Doc ID 1334858.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Business Process Management Suite - Version: 10.3.2 and later   [Release: AS10gR3 and later ]
Information in this document applies to any platform.

Symptoms

After upgrading the BPM to version 10.3.2, BAM stops running. Following error is seen in bam_dwupdater.log after enabling debug mode.

Steps to enable debug and asserts in BAM:

Open $BPMHomeDir/conf/WarehouseService.conf and edit/add these properties
  wrapper.logfile.loglevel=DEBUG. (uncomment if this is line is commented ).
  wrapper.java.additional.3=-ea (add this line).
Restart the updater service 'oraclebpmwarehouse.sh' in order for the flags to take effect.

Error:

[<D> 29/06/11 11:19:54] Synchronizing external variables...
[<S> 29/06/11 11:20:09] Column [V_EXTERNVAR] already exists, associated with a different data type [DATE], required [Time]
fuego.jdbc.DatabaseManager$ColumnAlreadyExistsWithDifferentTypeException: Column [V_EXTERNVAR] already exists, associated with a different data type [DATE], required [Time]
at fuego.jdbc.DatabaseManager.classifyColumns(DatabaseManager.java:1839)
at fuego.jdbc.DatabaseManager.addColumns(DatabaseManager.java:421)
at fuego.analyzer.OrganizationMetadata.changeTableColumns(OrganizationMetadata.java:310)
at fuego.analyzer.OrganizationMetadata.synchronizeExternalVariables(OrganizationMetadata.java:179)
at fuego.analyzer.UpdaterRunner.synchronizeMetadata(UpdaterRunner.java:608)
at fuego.analyzer.UpdaterRunner.run(UpdaterRunner.java:393)
at fuego.analyzer.UpdaterRunner.runUpdater(UpdaterRunner.java:262)
at fuego.analyzer.service.BAMUpdaterRunnerService.run(BAMUpdaterRunnerService.java:154)
at fuego.analyzer.service.WarehouseService$WarehouseServiceThread.runItem(WarehouseService.java:460)
at fuego.analyzer.service.WarehouseService$WarehouseServiceThread.run(WarehouseService.java:393)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms