Archive for the ·

BusinessWorks

· Category...

Long names could become a big issue

no comments

When you choose a name for TIBCO domain or BusinessWorks application, please keep in mind that long names could become a big issue. In the future, you may encounter such a problem like this (it was on Windows 2003 NTFS disk):

Can not create/access pager directory [d:\tibco\tra\domain\tibcolb-inttra-com\application\TRCAdapter\working\tibcolb-inttra-com.tibcolb-inttra-com-TRCAdapter.TRC Adapter Processes2Epar\pager.TRCAdapter-TRC_Adapter_Processes-1\TRCAdapter\CoreObjects\SecuritiesTrade\Resubmit SecuritiesTrade.process]

As you can see, domain name and application name are repeated several times in the working folder path and definitely affect the length, which can exceed the file system limit. So, choose the names in TIBCO as short as possible.

How to use AppManage utility to stop and start BW applications

4 comments

AppManage utility can be used to create a BusinessWorks application using EAR file, export and import deployment configuration, deploy, undeploy, start, stop, delete an application. It can operate in batch mode. You can run AppManage utility on any machine in the TIBCO Domain. It is placed in /<tibco_home>/tra/<version>/bin/ folder. Log file will be in the domain log folder. I will show the most simple use of AppManage utility for stop and start one BW application. This can be used for scheduled restart, for example.

  • Prepare credentials file using obfuscate utility:
    > vi cred.txt
    user=admin
    pw=#!tibco

    > ./obfuscate cred.txt

    > cat cred.txt
    user=admin
    pw=#!L3myZM9vfgr/3GAEybDLLRzX9kcdAJxZ

  • Use AppManage to stop a deployed application:
    > ./AppManage -stop -app <application> -domain <domain> -cred cred.txt
  • Use AppManage to start a deployed application:
    > ./AppManage -start -app <application> -domain <domain> -cred cred.txt

<application> is “Application” in TIBCO Administrator, not “Service Instance”

The user, defined in the cred.txt file, mush have appropriate rights to start and stop an application. You can operate as “admin”, or better to define new user in TIBCO Administrator with write access rights.

How to trace BusinessWorks application

1 comment

You can set
Trace.Startup=true
Trace.Task.*=true
Trace.JC.*=true
Trace.Engine=true
Trace.Debug.*=true

in deployed tra file and then restart the application, run the process and until the errors appear again, then check detailed log file locates in the <install-path>\tibco\tra\domain\application\logs folder. Please keep in mind that all manual settings will be cleared after redeploy. To keep it permanent, set in bwengine.tra file in <install-path>\tibco\bw\<version>\bin folder.

Also possible to redirect the stdout and stderr output to any file. Please set in deployed cmd:
"/<install-path>/tibco/bw/<version>/bin/bwengine.exe" --run --propFile "/<install-path>/tibco/tra/domain/application/<application>.tra" > "/tmp/trace.out" 2>&1
then start this cmd from command shell.

You can also enable higher tracing to Hawk, set -tsm_tracelevel -1 in your <install-path>\tibco\tra\domain\<domain-name>\hawkagent.cfg and restart your Hawk Agent. The logs will be under <install-path>\tibco\tra\domain\<domain-name>\logs\tsm.log by default, you can define it using -tsm_traceLogFile parameter.

Connecting from TIBCO to MS SQL using Windows Authentication

5 comments

Yes, it is possible. We can connect from BusinessWorks applications to MS SQL database using Windows authentication. Even more, we can run TIBCO Domain and store all data in MS SQL instance, where only Windows authentication enabled. Do it simply.

Get the latest version of Microsoft SQL Server JDBC Driver from microsoft.com site. Unzip it. Then:

  • copy sqljdbc.jar to <tibco_home>\tpcl\5.6\jdbc
  • copy \auth\x86\sqljdbc_auth.dll to C:\WINDOWS\SysWOW64 (or to C:\WINDOWS\System32 on 32bit system) and to <tibco_home>\tra\5.6\bin

Configure your BW-application to use appropriate driver and connection string:
JDBC_Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
URL: jdbc:sqlserver://<server_name>;
instanceName=<instance>;
databaseName=<database>;
integratedSecurity=true;

The process must be started under Windows domain user who has the database rights. To do that just start domain Hawk Agent service under this user (should be in local admins or has appropriate permissions). Then all BW-applications on this particular machine, started by TIBCO Administrator or using appmanage tool, will also run under this user and can connect to MS SQL database using Windows authentication.

If you would like to create TIBCO Domain and use MS SQL Win auth only instance to store the data, you can use the same JDBC driver and URL. All you need is just run TIBCO Administrator and Hawk Agents in the TIBCO domain under Win domain user who has the database rights.

Problem with libeay32.dll and ssleay32.dll

7 comments

You may experience this problem, when can’t run TIBCO Administrator, Hawk, BW process or any other TIBCO component. In log files you can find messages related to OpenSSL libraries libeay32.dll and ssleay32.dll. The reason is that TIBCO messaging components use OpenSSL, but other applications may also use OpenSSL and have already installed these dlls in C:\WINDOWS\System32 or C:\WINDOWS\SysWOW64 depending on the platform.

When you start the application, it unsuccessful attempts to find dll files near the binary, then tries to find in the System32 folder. But dlls from other version of OpenSSL are there. Your application will use it, instead correct version from TIBCO Rendezvous bin folder for example, even you have this folder in the PATH. TIBCO product can’t call the necessary functions, gives an error and stops working.

Solution is take libeay32.dll and ssleay32.dll from TIBCO Rendezvous bin folder to the bin folders of every installed TIBCO component. Or just copy and replace to C:\WINDOWS\System32 or C:\WINDOWS\SysWOW64.

Update: these libraries are needed for SSL communication using secured daemons (RVSD or RVSRD) only, if you are not using RVSD or RVSRD then just remove the tibrvjsd.jar file from the classpath.

TIBCO Designer libstdc++.so.5 issue on Ubuntu 9.10 (Karmic Koala)

1 comment

After successful upgrade Ubuntu Linux from 9.04 (Jaunty Jackalope) to 9.10 (Karmic Koala) on my laptop, I’ve found that my TIBCO Designer is no longer works here:

./designer: error while loading shared libraries: libstdc++.so.5: cannot open shared object file: No such file or directory

I’ve found that libstdc++.so.5 isn’t available in Karmic repos anymore but still in Jaunty here: http://packages.ubuntu.com/jaunty/i386/libstdc++5/download. You can download and install it:

wget http://mirrors.kernel.org/ubuntu/pool/universe/g/gcc-3.3/libstdc++5_3.3.6-17ubuntu1_i386.deb
sudo dpkg -i libstdc++5_3.3.6-17ubuntu1_i386.deb

After that Designer runs great on Karmic.