Upgrade Scenarios

The following upgrade scenarios can help if you encounter any problems after you upgrade myFileGateway 2.0 to any specific version.

Login and File Upload Failure

You encounter the above issue specifically after you upgrade from v6.0.1.0, v6.0.2.0, v6.0.3.0 to v6.0.3.4 and from v6.0.3.4 to v6.1.0.0, v6.1.0.1,v6.1.0.2, and v6.1.0.3.
Note:
  • This issue does not impact legacy myfilegateway UI.
  • This issue occurs only if you install myFileGateway 2.0 before upgrade.
  • This issue only affects existing customers who are on v6.0.3.4 and installed the B2BAPI jar file, which is bundled along with v6.0.3.4 Media file.
The following error message is displayed when you try to log in or upload a file to the myFileGateway 2.0 UI on any one of the upgrade paths mentioned above. Additionally, when you try to log in to a cluster setup after upgrade, you can encounter a problem during login with similar error trace.
Error 500: javax.servlet.ServletException: Filter [springSecurityFilterChain]: could not be initialized
The Liberty console.log file displays the following error trace. This issue occurs irrespective of the DB vendor used. The below attached error trace is for sample reference.

[1] Oracle Database [6033 to 6034]: 
[err] SEVERE 6/1/21 8:21 AM: liquibase: db/liquibase/cfgapi-changelog-master.xml: 
db/liquibase/cfgapi-changelog-v1.xml::DB2_CFX_CFG_FILE_UPLOAD_CHUNKS_DETAILS::b2bi: 
Change Set db/liquibase/cfgapi-changelog-
v1.xml::DB2_CFX_CFG_FILE_UPLOAD_CHUNKS_DETAILS::b2bi failed.  
Error: ORA-00955: name is already used by an existing object
[Failed SQL: CREATE TABLE SD6X1.CFG_FILE_UPLOAD_CHUNKS_DETAILS (FILE_ID VARCHAR2(100), 
FILE_NAME VARCHAR2(100), CHUNK_NUMBER NUMBER(5, 0), TOTAL_CHUNKS NUMBER(5, 0), 
CHUNK_SIZE NUMBER(20, 0), TOTAL_FILE_SIZE NUMBER(20, 0), CHUNK_DATA BLOB)]
 
[2] DB2 database [6034 to 6103]: 

[err] SEVERE 5/20/21 2:05 PM: liquibase: db/liquibase/cfgapi-changelog-master.xml: 
db/liquibase/cfgapi-changelog-
v1.xml::DB2_CFX_CFG_FILE_UPLOAD_CHUNKS_DETAILS::shaakulk@in.ibm.com: Change Set 
db/liquibase/cfgapi-changelog-
v1.xml::DB2_CFX_CFG_FILE_UPLOAD_CHUNKS_DETAILS::shaakulk@in.ibm.com failed.  
Error: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710,
SQLERRMC=DB2INST1.CFG_FILE_UPLOAD_CHUNKS_DETAILS;TABLE, DRIVER=4.26.14 [Failed SQL: 
CREATE TABLE DB2INST1.CFG_FILE_UPLOAD_CHUNKS_DETAILS (FILE_ID VARCHAR(100), FILE_NAME 
VARCHAR(100), CHUNK_NUMBER numeric(5, 0), TOTAL_CHUNKS numeric(5, 0), CHUNK_SIZE 
numeric(20, 0), TOTAL_FILE_SIZE numeric(20, 0), CHUNK_DATA BLOB(2147483647))]

Workaround for an IIM installation

Perform the following steps:
  1. Stop Sterling B2B Integrator.
  2. Drop the tables CFG_FILE_UPLOAD_CHUNKS_DETAILS and DOCUMENT_AV_SCAN from the database using command DROP TABLE <table_name>. 
    
DROP TABLE CFG_FILE_UPLOAD_CHUNKS_DETAILS; 
DROP TABLE DOCUMENT_AV_SCAN;
  3. Install the B2B APIs (b2biAPIs.jar) of the respective version.
  4. Restart Sterling B2B Integrator and Liberty Server.

Result: You can successfully log in and upload a file using the myFileGateway 2.0 UI.

Workaround for a Certified Container installation

Perform the following steps:
  1. Drop the tables CFG_FILE_UPLOAD_CHUNKS_DETAILS and DOCUMENT_AV_SCAN from the database using command DROP TABLE <table_name>. 
    
DROP TABLE CFG_FILE_UPLOAD_CHUNKS_DETAILS; 
DROP TABLE DOCUMENT_AV_SCAN;
  2. Install v6.1.0.3 Helm chart.

Result: You can successfully log in and upload a file using the myFileGateway 2.0 UI.