WebSphere Adapter for SAP Software

Migrating properties from an existing table

To migrate properties from an existing event-recovery table, you configure a new data source, create an event-recovery table, move the properties to the new table, and run enterprise service discovery.

Before you begin

Make sure you have installed the new version of Adapter for SAP Software and that you have updated the adapter RAR file in WebSphere® Integration Developer.

About this task

To transfer data from an existing event-recovery table, you create a new data source, transfer data from the existing table to the new data source (using the information in Table 1, and use enterprise service discovery to generate new business objects.

To configure the data source and run enterprise service discovery, use the following procedure.

How to perform this task

  1. Configure a new data source for ALE event recovery.

    See Configuring the data source for the steps necessary to configure the data source.

  2. Create the event recovery table in the data source.
  3. Stop the application.
  4. Transfer entries from the existing event recovery table to the new event recovery table, using the information in the following table as a guide.
    Table 1. Mapping of new event recovery table entries to deprecated entries
    Event persistence table column Column type and size Deprecated table column Deprecated column type and size
    EVNTID VARCHAR(255) TID VARCHAR(255)
    EVNTSTAT INTEGER Status VARCHAR(255)
    XID VARCHAR (255) N/A N/A
    BQTOTAL INTEGER NumIDocs INTEGER
    N/A N/A NumIDocsProcessed INTEGER
    BQPROC INTEGER CurrIDoc INTEGER
    EVNTDATA VARCHAR(255) N/A N/A
    Use the following mapping between the previous table and the new event recovery table.
    Table 2. Mapping of the new event status entries to the deprecated entries
    New event status (INTEGER) Deprecated event status (VARCHAR)
    0 CREATED
    1 EXECUTED
    3 PARTIAL
    -1 ROLLBACK
  5. Use enterprise service discovery to generate new service descriptions and business objects.

    In the Generate Artifacts window, make sure that Event recovery table name is set to the table that contains the migrated event-recovery data.

  6. Fix any breakages in dependent components.
  7. Deploy and start the application.

Result

A new event recovery table is created, and the associated adapter module is deployed.
Related tasks
Setting activation specification properties

Terms of use |

Last updated: Mon 30 Oct 2006 03:34:56

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)