My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.