Posts

Link from Twitter

succeedasyourownboss.com/02/2012/7-great-digital-tools-to-help-your-small-business

My EDI Notes

​ ​ E ​DI File Structure ​ ISA GS ST Abouve 3 are envelope hearders. It contain transaction details, sender and receiver details, transaction details, X12 standard versions. SE GE IEA Abouve 3 are envelope Tailers. *) EDI file is delimiter file. *) Each segment (line) is terminated by segmenet terminated. default symbol is ~ *) Segment is collection of elements and composite elements. Composite element is a sub element. *) Each sgement will contain some specific information for the transaction. ​ ​ ISA ISA*00* *00* *08*9251750000 *08*1234567890 *030627*1304*U*00401*000001403*0*P*>~  ​ ​ ​ ​ ISA Elements Details ISA01 Authorization Information Qualifier ISA02 Authorization Information ISA03 Security Information Qualifier ISA04 Security Information ISA05 Interchange ID Qualifier ISA06 Interchange Sender ID ISA07 Interchange ID Qualifier ISA08 Interchange Receiver ID ISA09 Interchange Date ISA10 Interchange Time ISA11 Interchange Control Standards ID ISA12 Inter...

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.

Attach multiple SSH Authorized User Key to Sterling File Gateway (SFG) Profile

Multiple source systems can talk to one Sterling Integrator SFTP server and the Authorized User Key for the remote servers could be different. The limitation with SFG is we can’t attach multiple Authorized user key to SFG profile, if we edit the profile SFG will list all the user profiles in drop down it mean we can select only One. To overcome this problem   DO NOT attach SSH Authorized User Keys from SFG instead go to Sterling Integrator Dashboard and edit the SFG Profile User there is page to attach multiple SSH Authorized User   Keys to one user. SI Dashboard > Account > User Accounts > Account Name (Search on Account Name), Edit the user and assign multiple SSH Authorized User Keys. 

Setting up SSH public/private keys

​ Setting up SSH public/private keys SSH (Secure Shell) can be set up with public/private key pairs so that you don't have to type the password each time. Because SSH is the transport for other services such as SCP (secure copy), SFTP (secure file transfer), and other services (CVS, etc), this can be very convenient and save you a lot of typing.​       SSH Version 2 ​On the local machine, type the BOLD part. The non-bold part is what you might see as output or prompt. Step 1: % ssh-keygen -t dsa Generating public/private dsa key pair. Enter file in which to save the key (~/.ssh/id_dsa): (just type return) Enter passphrase (empty for no passphrase): ...

​ 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...

Installing Oracle 11g Enterprise Edition on Ubuntu 12.10

Image
Required Software’s VMware Player Download and install VMware Player (Non-Commercial Software) Ubuntu 12.10 Download and install Ubuntu 12.10 32 bit or 64 bit based on your Hardware. XClock Problem To setup $DISPLAY across the user try running this as root before you do "su - oracle" or other users. $> xhost local:oracle $> xhost local:sirishg Oracle Installation Process Follow the below link, http://install-climber.blogspot.com/2012/10/InstallOracle11gR2DatabaseLinuxUbuntu1210Quantal64bit.html Note: About link works for Ubuntu 32 Bit as well. Note: Just ignored all above missing packages. Note: Run the above commands as root user. Post Installation Errors Error Message while starting sqlplus sqlplus: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory. Reason for the Problem libclntsh.so.11.1 was missin...