Failing Deployment
Issue: Repository Model deployment on Websphere Application Server failed with error "java.sql.SQLException: ORA-01430: column being added already exists in table " on MDM server.
Solution: On Websphere Application Server, the datasource property "Statement cache size" property value is 10. Set the "Statement cache size" property value to 0. An incorrect setting may result in a TransactionRolledback exception. This setting is Windows-specific.
To change statement cache size:
Login to the Administrative console to configure the properties.
In the left panel, expand Resources > JDBC Providers. The Data Sources panel is displayed on the right.
Under Preferences, click data source name. For example, eCMDataSource. The Configuration tab is displayed.
Under Additional Properties, click the WebSphere Application Server data source properties link.
In the Statement cache size field, enter 0.
Click the OK button. A message is displayed with the Save and Review options.
Click the Save link to save changes to the master configuration.