IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Services and service-related functions > Access external services with adapters > Configure and using adapters > IBM WebSphere Adapters > Flat Files > Troubleshooting and support

Solutions to common problems

Some of the problems you might encounter while running WebSphere Adapter for Flat Files with your database are described along with solutions and workaround. These problems and solutions are in addition to those documented as technotes on the software support website.

For a complete list of technotes about WebSphere Adapters, see http://www.ibm.com/support/search.wss?tc=SSMKUK&rs=695&rank=8&dc=DB520+D800+D900+DA900+DA800+DB560&dtm.

Adapter throws an exception requesting users to migrate their existing tables

Problem

When install the version 7.5.0.3 of the adapter without migrating the existing event table structure with the same name as specified in the activation specification properties, the adapter throws an exception error at run time.

Solution

Migrate the existing event table while retaining the same table name as provided in the previous version of the activation specification properties.

You can use the database scripts available at <IID-HOME>\Resource Adapters\FlatFile_7.5.0.2\SQLScripts, to migrate the existing event table.

Use the script corresponding to your database:

• scripts_db2_upgrade.sql – for DB2 and Derby database
• scripts_mssql_upgrade.sql – for Microsoft SQL Server database
• scripts_oracle_upgrade.sql – for Oracle database

See Migrating databases.

Troubleshooting and support