Posts

Sterling Integrator User, Workflow Queries

Active Worksflows in Sterling Integrator select DISTINCT NAME , WC2.WORKFLOW_ID, sysdate - START_T AS TIMEDIFF From WORKFLOW_CONTEXT WC, ( SELECT MAX(STEP_ID) STEP_ID , MIN(START_TIME) START_T, WORKFLOW_ID FROM WORKFLOW_CONTEXT GROUP BY WORKFLOW_ID ) WC2, WFD WHERE WC.WORKFLOW_ID = WC2.WORKFLOW_ID AND WC.STEP_ID = WC2.STEP_ID AND WC.NEXT_AI_ID != -1 AND WC.WFD_ID = WFD.WFD_ID AND WC.WFD_VERSION = WFD.WFD_VERSION AND BASIC_STATUS = 0 Sterling Integrator User & User Associated Groups List  select YFS_USER.LOGINID, YFS_USER_GROUP.USERGROUP_NAME from YFS_USER, YFS_USER_GROUP, YFS_USER_GROUP_LIST where YFS_USER.USER_KEY=YFS_USER_GROUP_LIST.USER_KEY and YFS_USER_GROUP.USERGROUP_KEY=YFS_USER_GROUP_LIST.USERGROUP_KEY

SSHKeyGrabber in Sterling Integrator not working

http://www-01.ibm.com/support/docview.wss?uid=swg21628336 Sometimes SSHKeyGrabber don't work when we trying to extract Known Host Key from Sterling Integrator UI. The work around for this is disable StrictHostKeyChecking and download the Key from Linux/Windows and Check in the key to Sterling Integrator. $ssh -o StrictHostKeyChecking=no user@sftp.host.com -p 22 Above command will save host key to known_hosts file located .~/.ssh/known_hosts Note: Remove excess content from host key and just keep the key from ssh-rsa followed the key. 

B2BI MESA API/JAR's for Custom Service Development

asset.jar b2b_aee.jar b2b_base.jar b2b_oba.jar ebics.jar entities.jar gis.jar install_foundation.jar mailbox.jar maverick-all.jar perimeter.jar platform_activemq.jar platform_activity.jar platform_afc.jar platform_afc_security.jar platform_aop.jar platform_asi.jar platform_baseutils.jar platform_dv.jar platform_ifcbase.jar platform_ifcui.jar platform_osgi.jar platform_security.jar platform_services.jar resources.jar soap.jar standards.jar translator.jar

Launching ikeyman from IBM JDK

Navigate to IBM JDK bin directory and execute the following command, C:\Sirish\Softwares\ibm_sdk80\bin>java com.ibm.gsk.ikeyman.Ikeyman

Integration Concepts

Amazon EC2 (Amazon Elastic Compute Cloud)? Amazon Elastic Compute Cloud (Amazon EC2) provides scalable computing capacity in the Amazon Web Services (AWS) cloud. Using Amazon EC2 eliminates your need to invest in hardware up front, so you can develop and deploy applications faster. You can use Amazon EC2 to launch as many or as few virtual servers as you need, configure security and networking, and manage storage. Amazon EC2 enables you to scale up or down to handle changes in requirements or spikes in popularity, reducing your need to forecast traffic. Amazon S3? Amazon Simple Storage Service is storage for the Internet. It is designed to make web-scale computing easier for developers. Amazon S3 has a simple web services interface that you can use to store and retrieve any amount of data, at any time, from anywhere on the web. It gives any developer access to the same highly scalable, reliable, fast, inexpensive data storage infrastructure that Amazon uses to run its own global ...

Wake up before your competition do!

Image
Some inspiration from 5AM group on Facebook You might not have a competitive advantage over your competition and maybe you don't have all the tools and resources to play with the big boys in your industry. ~ But one thing you do have is the ability to out work your competition! ~ You don't need to come up with anymore excuses about why you aren't where you want to be, what you need to do is get up earlier, show up and show the world you're not here to make up the numbers and be another statistic! ~ If you're not prepared to out work your competition and wake up before 5am every single day then maybe it's time to ask yourself how serious you are about your goals and dreams! ~ Stop doing normal things and stop performing at average levels because that is exactly why you aren't where you want to be... ~ Be unusual, be abnormal, be obsessed, be prepared to wake up at 4:00am and work harder than anyone you've ever met because that is the only way you're e...

Grab Known Host Key From Remote SFTP Server in OpenSSH Format

1. Get the host key by running this command: ssh-keyscan > /tmp/ssh_out.openssh 2. Convert the host key format by running this command: ssh-keygen -l -f /tmp/ssh_out.openssh