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

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 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