LO68097: LEI 8.5.2 OR LEI 8.5.3 (32 BIT OR 64 BIT) DOES NOT HANDLE NULL F IELDS FROM DB2

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • A) table in DB2
    
    
    
    
    
    CREATE TABLE BURPCFILES.LEITEST (
    
    
    
            INTNUMBER NUMERIC(5, 0) NOT NULL ,
    
    
    
            TEXT1 CHAR(5) CCSID 37 DEFAULT NULL ,
    
    
    
            TEXT2 CHAR(10) CCSID 37 DEFAULT NULL )
    
    
    
    B) Values in DB2
    
    
    
     INSERT INTO BURPCFILES.LEITEST VALUES(1,'TEST',NULL)
    
     INSERT INTO BURPCFILES.LEITEST VALUES(2,'TEST','TEST2')
    
    
    
    C) Created a basic form in Lotus, called LEITEST in a Test db,
    with
    Number as Numeric,
    
    
    
    
    
    D) In LEI, created an ODBC Connection to DB2 BURPCFILES.LEITEST
    
    E) In LEI, created a Notes Connection to BURGESS02
    TEST\TEST.NSF.
    Specified (LEI_LEITEST) in Selected view and checked "Allow View
    
    Creation/Overwrite"
    
    
    
    
    
    F) Created a new replication activity, REP_LEITEST.  Source is
    DB2
    BURPCFILES.LEITEST.  Target is Notes Test\Test.nsf LEITEST form.
     Mapped
    the fields, INTNUMBER and NUMBER are keys, the other two are
    fields.
    G) Ran the LEI Activity, it ran successfully, added 2 documents
    
    
    
    03/05/2012 03:37:47 PM        Activity started
    
    03/05/2012 03:37:49 PM        Created Notes view
    '(LEI_LEITest)',
    Connector 'NotesLEITEST',  Method -Select-
    
    03/05/2012 03:37:49 PM        Activity finished
    
    
    
    H) In Lotus Notes, I used a utility to open the documents. The
    first
    document didn't have the TEXT2 field (which is null in DB2).
    The second
    record did have it.
    
    I) In Lotus Notes, I changed the first document. I added a TEXT2
    field
    with a "test" value.
    
    J) Ran LEI activity for the second time.  It crashed:
    
    
    
    03/05/2012 03:39:47 PM        Activity started
    
    03/05/2012 03:39:49 PM        Error: Text translation failure
    
    03/05/2012 03:39:49 PM        Current record key values at the
    time of
    the replication error --
    
    03/05/2012 03:39:49 PM          - Connector A record key values:
    
    INTNUMBER = 1
    
    03/05/2012 03:39:49 PM          - Connector B record key values:
     Number
    = 1
    
    03/05/2012 03:39:49 PM        Activity Ended With An Error
    

Local fix

Problem summary

  • A programming error was found and will be corrected in a future
     release.
    

Problem conclusion

  • A programming error was found and will be corrected in a future
     release.
    

Temporary fix

Comments

  • This APAR is associated with SPR# RWAH8SDPSX.
    This APAR is closed as FIN. We have deferred the fix to a
     future release.
    

APAR Information

  • APAR number

    LO68097

  • Reported component name

    ENTERPRISE INTE

  • Reported component ID

    5724L7600

  • Reported release

    852

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-03-14

  • Closed date

    2013-07-30

  • Last modified date

    2013-07-30

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    ENTERPRISE INTE

  • Fixed component ID

    5724L7600

Applicable component levels

  • R852 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Enterprise Integrator for Domino

Software version:

8.5.2

Reference #:

LO68097

Modified date:

2013-07-30

Translate my page

Machine Translation

Content navigation