ravinutalasblog

When I was trying to configure TIBCO BW ADB Adapter with SQL server 2012 as the back end database, I got a some issues which am going to post in a series of blog posts. Here I am going to post the steps to configure them as well. First the user should be created to access the DB from TIBCO BW. Administrator users like 'sa' should not be used. If the administration users are used in the configuration then the ADB adapter may not start properly.  To create the user following are the steps: - In 'Microsoft SQL Server Management Studio' go to the   databases -> <your database> -> Security -> Users -> New User  - It opens a pop-up - In the pop-up on the General tab select the User Type as 'SQL user with login' - Give the User name and Login name and then select the Default schema as dbo. - On the Membership tab select the Role Members as db_owner - Then click on OK to complete

When we run the adapter tester in TIBCO BW, we may get the following error: java.io.IOException: Cannot run program "C:\tibco\adapter\adadb\6.3\bin\adbagent.exe" (in directory "C:\tibco\designer\5.8\workingDirAdapter"): CreateProcess error=740, The requested operation requires elevation at java.lang.ProcessBuilder.start(Unknown Source) at java.lang.Runtime.exec(Unknown Source) at com.tibco.ae.tools.adaptertester.AdapterProcess.run(AdapterProcess.java:606) -- and few more lines -------------- To resolve this, we may need to start the TIBCO BW engine as administrator using ' Run as Administrator '

Whenever we want to print only the pop-up in windows just use Alt+Print Scrn together.

I faced an issue when I modified the unix file in windows using cygwin; it was throwing an error. I searched some where and found the following way is simple to do it. This issue is because of the special characters which will be created when we edit a unix file in cygwin. To remove dos2Unix issues in cygwin need to do the following in the vi editor. :e ++ff=dos :w ++ff=unix :e! Once these commands executed, just quit the file and all the additional characters added will be removed. There are other ways to do it. But I felt it is simple and want to share.