IBM Support

IT09764: DBVERIFY CREATES A CORRUPT FILE EFRAME_INDEXADDS.SQL AND THIS FILE NEEDS TO BE MODIFED TO GET IT TO WORK.

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

  • dbverify when run manually from commandline will create
    fileEFrame_IndexAdds.sql corrupt.
    
    Steps to replicate are below:
    
    1. Delete any two indexes from Sterling B2B Integrator and run
    dbverify.sh from
    <SI_ROOT>/bin so it generates the EFrame_IndexAdds.sql file in
    same location.
    
    /opt/si/52/si523/install/bin>./dbverify.sh
    
    2. Run the db_execFile.sh to create the indexes again and see
    the error below
    
    /opt/si/52/si523/install/bin>./db_execFile.sh -i
    /opt/si/52/si523/install/bin/EFrame_IndexAdds.sql -j -p
    
    Found internal config file
    /com/sterlingcommerce/security/jcae/provider.txt, loading it
    now!
    Done loading it.
    Security Providers: IBMJCE, Certicom, STERCOMM, IBMJSSE2,
    IBMJGSSProvider, IBMCertPath, SCIKS, SCIKM, CerticomJSSE
    
    Exception: The input SQL script file must end SQL with '/', ';'
    or 'GO' characters in a new line.
    java.lang.Exception: The input SQL script file must end SQL
    with '/', ';' or 'GO' characters in a new line.
            at
    com.sterlingcommerce.db.ExecSQLFile.testExecSQLFile(ExecSQLFile.
    java:427)
            at
    com.sterlingcommerce.db.ExecSQLFile.main(ExecSQLFile.java:364)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
    Method)
            at
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
    Impl.java:48)
            at
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
    AccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:600)
            at
    com.sterlingcommerce.woodstock.noapp.NoAppLoader.main(NoAppLoade
    r.java:82)
    Found internal config file
    /com/sterlingcommerce/security/jcae/provider.txt, loading it
    now!
    Done loading it.
    
    Error '1' running a list of SQL commands from a input file.
    
    3. hex edit the EFrame_IndexAdds.sql and you will find a space
    after each "/" which causes the problem :-
    
    /opt/si/52/si523/install/bin>od -cx EFrame_IndexAdds.sql
    0000000   C   R   E   A   T   E       U   N   I   Q   U   E
      I   N
            5243 4145 4554 5520 494e 5551 2045 4e49
    0000020   D   E   X       A   S   3   _   S   T   O   R   A   G
      E
            4544 2058 5341 5f33 5453 524f 4741 5f45
    0000040   I   D   X   1       O   N           A   S   3   _   S
      T   O
            4449 3158 4f20 204e 4120 3353 535f 4f54
    0000060   R   A   G   E      \n  \t   (       S   T   O   R   A
      G   E
            4152 4547 0a20 2809 5320 4f54 4152 4547
    0000100   _   I   D       ,   P   A   R   T   N   E   R   _   I
      D
            495f 2044 502c 5241 4e54 5245 495f 2044
    0000120   )  \n   /      \n   C   R   E   A   T   E       I   N
      D   E
            0a29 202f 430a 4552 5441 2045 4e49 4544
    0000140   X       S   C   I   _   I   D   X   _   D   M   I   7
          O
            2058 4353 5f49 4449 5f58 4d44 3749 4f20
    0000160   N           A   C   T   _   S   E   S   S   I   O   N
         \n
            204e 4120 5443 535f 5345 4953 4e4f 0a20
    0000200  \t   (       C   O   N   _   S   T   A   R   T   _   T
      I   M
            2809 4320 4e4f 535f 4154 5452 545f 4d49
    0000220   E       )  \n   /      \n  \0
            2045 0a29 202f 000a
    0000227
    
    4. Remove the spaces and it then works :-
    
    /opt/si/52/si523/install/bin>./db_execFile.sh -i
    /opt/si/52/si523/install/bin/EFrame_IndexAdds.sql -j -p
    
    Found internal config file
    /com/sterlingcommerce/security/jcae/provider.txt, loading it
    now!
    Done loading it.
    Security Providers: IBMJCE, Certicom, STERCOMM, IBMJSSE2,
    IBMJGSSProvider, IBMCertPath, SCIKS, SCIKM, CerticomJSSE
    
    Found internal config file
    /com/sterlingcommerce/security/jcae/provider.txt, loading it
    now!
    Done loading it.
    
    -------------------------------------------------
    command:  CREATE UNIQUE INDEX AS3_STORAGE_IDX1 ON  AS3_STORAGE
    ( STORAGE_ID ,PARTNER_ID )
    -------------------------------------------------
    Rows Effected: 0
    
    -------------------------------------------------
    command:  CREATE INDEX SCI_IDX_DMI7 ON  ACT_SESSION (
    CON_START_TIME )
    ------------------------------------------------
    Rows Effected: 0
    

Local fix

  • AC / AC
    
    STRTC 426200
    

Problem summary

  • Problem Description:
    In Oracle, when indexes are deleted and then dbverify.sh is
    manually run from the command line, the file
    EFrame_IndexAdds.sql is created incorrectly.  A space character
    is added after the forward slash in the INSERT statements in the
    file.
    
    Platforms Affected:
    All
    
    Users Affected:
    Oracle DB users
    

Problem conclusion

  • Resolution Summary:
    A code fix has been provided.
    
    Delivered In:
    5020500_6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT09764

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    524

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-06-30

  • Closed date

    2015-06-30

  • Last modified date

    2015-07-01

  • 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

    STR B2B INTEGRA

  • Fixed component ID

    5725D0600

Applicable component levels

  • R525 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.4","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
01 July 2015