Posts

Remove SFG Partner Profile (Hard Delete if SFG removal fails)

There was bug in SFG (old versions) where it leaves some orphan entries in DB when you try to remove the trading partner from SFG UI. To solve the problem here are steps to do hard delete of partner profile. Attempt to delete from SFG in regular way and then remove from Dashboard --> Trading Partner (All Contracts, Document Exchange, Profile, Routing Channels, Mailbox Virtual Roots if any etc.) Make sure the following table should not return any entry for Trading Partner, If it returns then remove the entry manually... This example Partner Name is : EDI select 'YFS_USER' from YFS_USER where UPPER(USERNAME) like '%EDI%'  UNION select 'YFS_ORGANIZATION' from YFS_ORGANIZATION where UPPER(ORGANIZATION_KEY) like '%EDI%'  UNION select 'MBX_ACTION'  from MBX_ACTION where UPPER(USER_ID) like '%EDI%'  UNION select 'MBX_MAILBOX'  from MBX_MAILBOX where UPPER(PATH) like '%EDI%'  UNION select 'SCI_CONTRACT' fro...

Enterprise Integration Techniques - Notes

Integration Patterns:    Enterprise Integration Patterns    Self Managing      Minimize the dependency between components.      John Prosul Robust principle      Be liberal with what you receive and be specific with what you send out.      Always support previous versions (Backward compatibility). It's always hard to support backward compatibility but it's matter of discipline.      Software is craft not a science.      Be wise on Technical Decision vs Business Decision.      InfoQ.com      gotoconferences    Twitter University    Emerging Techologies for Enterprise (Conference hosted in Philly)      Agile Stuff      hackernews.com (YCombinator)      HighScalability.com      Netflix Engineering      Thoughtworks Tech Rada...

Design Patterns Tutorial

Design Patterns Tutorial

Sterling Integrator issue with MSSQL Database

Error while installing -  The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server returned an incomplete response. The connection has been closed.". [2014-11-13 17:31:50.499] ERRORDTL [1415899910498]com.microsoft. sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server returned an incomplete response. The connection has been closed.". Solution below link.  --  Alternate Solution: http://www-01.ibm.com/support/docview.wss?uid=swg21690335 Other useful links......... http://blogs.msdn.com/b/jdbcteam/archive/2008/09/09/the-driver-could-not-establish-a-secure-connection-to-sql-server-by-using-secure-sockets-layer-ssl-encryption.aspx https://www.microsoft.com/en-us/download/details.aspx?id=44622

Rain

Image

Harmonium Lessons

http://learnraagabasics.blogspot.com/

Encoding a Payload in Sterling Integrator using Java Task

import java.io.InputStream; import java.lang.StringBuilder; import com.sterlingcommerce.woodstock.workflow.Document; import com.sterlingcommerce.woodstock.util.Base64; Document doc = wfc.getPrimaryDocument(); InputStream in = doc.getInputStream(); StringBuilder sb = new StringBuilder(); for (int i = 0; i < in.available(); i++) {    sb.append(in.read()); } byte data[] = sb.toString().getBytes(); byte newdata[] = Base64.encode(data); doc.setBody(new String( " "+ new String(newdata)+" ").getBytes()); return new String(sb.toString());