Avoid duplicate file processing in Sterling File Gateway (SFG)

-
The actual error we see in the logs is just the way SFTP in SI detects
duplicate files and since you have the option in the
mailbox.properties set to:

disallowDuplicateMessages=false

This means that duplicate files are allowed and therefore SFG
processed those duplicate uploads.

So the partner should investigate why did their application trigger a
duplicate upload of the same file.

If you want to avoid duplicate uploads, you should consider setting
the option disallowDuplicateMessages to true in both nodes, this will
stop SI from accepting duplicate files.

If you want to make that change, you will need to modify\create your
customer_overrides.properties on both nodes and add the following
line:
mailbox.disallowDuplicateMessages=true

Both nodes need to be restarted for the change to take effect.

Comments

Post a Comment

Popular posts from this blog

Java Task Service - Sterling Integrator

-
import com.sterlingcommerce.woodstock.workflow.Document; import java.io.InputStream; import java.io.InputStreamReader; import java.io.BufferedReader; Document doc = wfc.getPrimaryDocument(); Document outPutDoc = wfc.newDocument(); ; InputStream inS = doc .getInputStream(); BufferedReader br = new BufferedReader( new InputStreamReader( inS )); String strData = “<SampleData>” ; String strLine; while ((strLine = br .readLine()) != null ) {     strData = strData.concat(strLine); } br.close(); strData = strData + “</SampleData>”; outPutDoc. setBody( strData .toString().getBytes()); wfc.putPrimaryDocument( outPutDoc );
Read more

Hibernate Connection Fails if there is Database inconsistency or DB fail-over (Oracle RAC)

-
        /**      * A static method with returns Hibernate Sessoin Object.      *      * @return {@link Session}      */     public static Session getSession() throws HibernateException {         Session appSession = sessionFactory .openSession();         try         {                 if (appSession.connection().isClosed()||!appSession.isConnected()||!appSession.isOpen()){                         System. out .println( "Session Closed, Creating Session again..." );                  ...
Read more

​ Configure External Databases to IBM Sterling B2B Integrator

-
We can add multiple ​​ external databases to IBM Sterling B2B Integrator. To add custom database need to do the following things, 1. Stop IBM Sterling B2B Integrator 2. Navigate to SI_INSTALL_DIR\properties and edit jdbc_customer.properties.in and add the below properties. 3. Run setupfiles.bat/sh (SI_INSTALL_DIR\bin\setupfiles.bat/sh) 4. Start IBM Sterling B2B Integrator Note: SI_EXTENSION is my pool name. We can name whatever we want. ​ ​ MS SQL Server Database Need to change the test query depending on server, For MS SQL Server Database SI_EXTENSION.testOnReserveQuery=SELECT GETDATE() Oracle Database Need to change the test query depending on server, For Oracle Database SI_EXTENSION.testOnReserveQuery=SELECT * FROM DUAL jdbc_customer.properties.in SI_EXTENSION.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver SI_EXTENSION.url=jdbc:sqlserver://localhost:1433;databaseName=SI_EXTENSION;SelectMethod=cursor SI_EXTENSION.user=sa SI_EXTENSION.password= #SI_EX...
Read more