Posts

Enable External Purge in Sterling Integrator

Starting an External Purge Procedure If you have a cluster installation, make sure that you are not running the external purge on another node of the cluster. If you are running the external purge on more than one node, it will cause database locks. For more information, see  Monitoring an External Purge . Important:  It is the customer's responsibility to keep exactly one of these external purge processes running in the cluster. If you need to shut down the hardware that is running the external purge, you must run the external purge on a different node. Disable the default Purge service. Click  Deployment  >  Schedules , search for PurgeService, and then clear the  Enabled  checkbox for PurgeService. Note:  If you have customized the Schedule_PurgeService business process, you need to add your customized code to the new Schedule_PurgeService business process. The new Schedule_PurgeService business process includes a warning mess...

Remote FTP Directory Sync using lftp

http://www.cyberciti.biz/faq/lftp-mirror-example/ $lftp user@my.ftp.com $ mirror -c source target Reverse Sync to Server: Change local directory to  where you saved the files /home/somedirectory $ lcd /home/somedirectory $ mirror -R

Enterprise Logging with Logstash

Basic Flow of Logstash? LS Agent(s) (Installed on App Server(s)) --> RabbitMQ --> LS Server --> Elasticsearch Server <-- Kibana <-- end user. So which scripting language is recommended to parse the logs or data? There is a bunch of plugins for logstash but mostly we use the grok filter. https://www.elastic.co/guide/en/logstash/current/plugins-filters-grok.html It takes grok expressions which can be the special grok or even ruby regexes with named captures. If you need help building patterns to match your logs, you will find the http://grokdebug.herokuapp.com and http://grokconstructor.appspot.com/ applications quite useful! We need to include Puppet in setup or we can manage with out puppet? Puppet manages LS Agents on all servers. We create filters and apply them based off the server hostgroup and also input files. Videos on Logstash: https://www.youtube.com/watch?v=96og3aIgyrc https://www.youtube.com/watch?v=Kqs7UcCJquM htt...

10 Management Tips

Image

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());

Sir A.P.J Abdul Kalam

Don't take rest after your first victory because if you fail in second, more lips are waiting to say that your first victory was just luck." - A.P.J Abdul Kalam "All Birds find shelter during a rain. But Eagle avoids rain by flying above the Clouds." - A.P.J Abdul Kalam "Failure will never overtake me if my definition to succeed is strong enough". - A.P.J Abdul Kalam "Man needs difficulties in life because they are necessary to enjoy the success." - A.P.J Abdul Kalam "If you want to shine like a sun. First burn like a sun." - A.P.J Abdul Kalam "It is very easy to defeat someone, but it is very hard to win someone" - A.P.J Abdul Kalam "All of us do not have equal talent. But , all of us have an equal opportunity to develop our talents." - A.P.J Abdul Kalam " Be more dedicated to making solid achievements than in running after swift but synthetic happiness." -A.P.J Abdul Kalam ...