IBM Support

Login and File Upload Failure

Troubleshooting


Problem

Customers who upgrade from B2BI v6034 to v6.1.0.x face the issue of login and file upload failure from myFileGateway 2.0 UI.

Symptom

This issue is encountered after you upgrade 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 configure myFileGateway 2.0 before upgrade.
  • This issue only affects existing customers who are on 6034 and have installed B2BAPi jar that is bundled with 6034 media.

The following error message is displayed when trying to upload a file or log in to the myFileGateway 2.0 UI, on any one of the upgrade paths:
Error 500: javax.servlet.ServletException: Filter [springSecurityFilterChain]: could not be initialized.
Additionally on a cluster setup post upgrade, Customer can face the issue with login with similar error trace.

The Liberty console.log file displays the following sample error trace:
(This issue occurs irrespective of the DB vendor used. Here is the error trace for sample reference.)

DB2 database [6034-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::xxxx@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))]

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"ARM Category":[{"code":"a8m50000000CjsrAAC","label":"Sterling File Gateway-\u003EMyFileGateway"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.1.0"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
28 June 2021

UID

ibm16467567