My Oracle Support Banner

OBIA 7.9.6.x - Starting Informatica Service Fails With Error "CANNOT ADD COLUMN TO TABLE; TABLE HAS EDIT PROCEDURE" With DB2 Database (Doc ID 1932062.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Informatica PowerCenter Full Use Server - Version 7.9.6 [1340] to [Release V7]
Information in this document applies to any platform.


In OBIA 7.9.6.x with Informatica 9.1.0 and Database DB2 9.7.7, it is not possible to start Informatica service.

The catalina.out file shows the following error:

[2014-Aug-20 23:17:13.044] Domain Configuration service deinit method is called.
Aug 27, 2014 10:29:16 PM com.informatica.repository.persistence.service.impl.PersistenceManagerImpl initialize
SEVERE: Unable to initialize persistence component due to: [PERSISTENCEAPI_0307] [DBPERSISTER_0015] Repository initialization failed. Contact your administrator. This was caused by [PERSISTENCEAPI_0307] [DBPERSISTER_2005] An exception occurred during repository operation. This was caused by [informatica][DB2 JDBC Driver][DB2]CANNOT ADD COLUMN TO TABLE; TABLE HAS EDIT PROCEDURE
Throwable occurred:


To view full details, 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 a vibrant support community of peers and Oracle experts.