We see that many questions about how to retrieve a list of the Producers and Consumers and associated protocols like FTP, SFTP and about routing channels assigned. For the above question all that information is not located in the same table and might require joining few tables. This articles guides to get above info and please find below some database table information that can help to develop the requires queries. A) The first place to check would be the table YFS_ORGANIZATION B) The best way to get a list of producers and consumers is using... [More]

Tags:  channels transport assigned protocol of theconsumers the list producers routing

If you are using Sterling File Gateway to route files between users and ever wanted to rename file in consumer Inbox? So this article is for you. I want to cover "Custom facts" in Routing Channel Template along with an example. Custom facts help you to rename files while routing from producer to consumer Inbox. Screen-print below shows where these custom facts can be configured.   You have to be familiar with Regular Expressions to use custom facts to the fullest extent.   Consider a requirement where producer sends the file... [More]

Tags:  custom fact kishore filegateway

I recently worked with a customer who had successfully installed a fix pack to Sterling B2B Integrator only to find that the SAP Suite Adapter for JCo 3.x would longer start. I checked all the usual suspects: <SI Root >/in stal l/pr oper ties /dyn amic clas spat h.cf g contained a reference to the sapjco3.jar. The <SI Root >/in stal l/ja r/sa pjco 3/<s ap version> directory contained the sapjco3.jar <SI Root >/in stal l/sa pjco 3/<s ap version>/linux directory contained the library file. Everything looked fine,... [More]

I have seen a number of customers do one or more of the following things in their SFG setup in an attempt to "simplify" or "clean up" things.   * delete the user accounts for partners that are listening consumers * delete some user accounts' virtual roots * change the name of the user account that is associated with an SFG partner * delete some partners' default mailboxes   At the time, all of these things seemed like a good idea to the person that did them, but they also come with hidden costs.   All... [More]

Tags:  partners sfg

Author: Manisha Khond   There are certain situations where you want to decode the certificate to verify that it contains the correct information. The easiest way to view the certificate content on Windows host, is to open the certificate and view it’s contents field by field. There are tools available to parse the certificate contents. OpenSSL is free tool and it can decode the contents of the certificate as well.   This is the certificate that we want to decode (Part of the certificate displayed below is erased due to security... [More]

Automatically updating expiring AS2 certificates            This blog is intended to provide steps to aid in replacing an AS2 certificate used in your profile Organization.  In it, I describe a method which can be used to replace the certificate automatically on a specified date.   AS2 requires users to replace expired system certificates configured in the profile Organizations, and defined as the Exchange and Signing certificates.  All certificates, used for any purpose, have an... [More]

Tags:  automatically as2 update certificate organization

Manually updating an expiring AS2 Organization certificate This blog is intended to provide a few simple steps to aid in replacing an AS2 certificate used in your profile Organization, when it  is about to expire.  I will outline creating a new certificate, how to update it in the profile Organization, and provide some tips for managing the process of coordinating the replacement of the certificate with partners who need to use it.   AS2 requires users to replace expired system certificates configured in the profile... [More]

Tags:  organization certificate system as2 replace profile

If you are looking to implement Java based REST API Client to invoke B2B APIs, my previous articles would help you. These include working java (REST API Client) classes for 2 of the APIs. REST API Proof Of Concept - Automate Sterling FileGateway Community and Trading Partner creation  REST API Client - upload message to Sterling B2B Integrator Mailbox    These articles covered how to generate JSON input string for... [More]

Tags:  sterling kishore json sfg b2bapi

When you are using the B2B APIs, you can use the Read SSHUserIdentityKey option to see both private keys and public keys in your B2B Integrator currently.   These keys are in base64 encoded format.   To see the keys in the non-base64 encoded format similar to when you are using the B2B Integrator Dashboard to check out the User Identity Key, you would need to copy out the string.   For example:    public key string would show something like below:     "publicKeyData":... [More]

The Sterling File Gateway (SFG) product documentation explains the specifics of what to do in order migrate a SFG instance, but misses something in the planning stage. There is a tool named sfgdbcheck that can be used to tell you how well prepared you are to begin a migration. For the more recent versions of SFG, the tool appears in the /<install>/bin directory as sfgdbcheck.sh for installations with a Linux operating system or in the \<install>\bin directory as sfgdbcheck.cmd for installations with a Windows operating system. The... [More]

Changing the attachment name in a business process is not difficult, but until you know the tricks, it can be maddening. After a little experimentation, I created a sample business process that seems to do the job.  I will spare you the wailing and gnashing of teeth that accompanied my first efforts, sharing only what I found to work. As you will see, there are a few things that will make the journey more pleasant. 1. If your file name will be created from concatenated values, it is probably best to get this out of the way.  (Should... [More]

Tags:  info attachment mail document adapter service send smtp pbarrie mime get

The following is an example onFault that will send an email whenever a failure happens in a workflow. The email will be sent to (and from) the admin account located in the sandbox.cfg file. The email will contain a subject that reads "Business Process 9999999 failed" It will be sent to the smtp host, email server, that is located in the sandbox.cfg. The following bpml is set to fail so you can see how it works. The lines in red bold is the onFault code that can be added to an existing bpml. As always, please test the code out as... [More]

Sterling B2B Integrator allows configuration for external authentication so that users would get authenticated against servers such as LDAP, Active Directory. Here is supporting documentation.   It is not uncommon for some clients to misconfigure authentication policies in authentication_policy.properties . That would lead to authentication errors or Java Exceptions some are hard to troubleshoot. I would like to discuss some common mistakes clients might make and few troubleshooting tips.   I am not discussing some... [More]

Tags:  ldap password_attribute search_filter b2b kishore sterling

NOTE:  This API service is equivalent to Trading Partner > SSH > User Identity Key > Check In option in the dashboard user interface and not the Create option.   The Rest API covers each required field pretty straight forward except on the field of Private Key Data. When creating an  SSHUserIdentityKey using API, it is askin g us to supply privateKeyData (A Base 64-encoded string repr esentation of the private key.... [More]