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":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
01 July 2015