Friday, May 19, 2006

BB notes from Greg

Problem:

Excel BLP functionality was not working. Additionally, Bloomberg DDE Server popped up a message saying "Unable to initialize the Time Zone Adjustment feature: request timed out"

Steps to Resolve the Problem:

Turn off TaskMaster service (if appropriate)

End process on bbcomm.exe and blp.exe. Make sure that bbcomm does not relaunch, and it will if something on the machine is still trying to access BBG data (i.e. Excel, wl_Rates, DataExtracter, etc)

Delete file: c:\blp\api\monitor.rte

Run program: c:\blp\api\mkmonrte.exe with the following inputs: 2, [default], 208.134.161.30, [default], 208.134.161.62, [default]

Run program: c:\blp\api\bbcomm.exe; click Defaults; point Route file to the just created .rte file above (c:\blp\api\monitor.rte); point Log file to c:\blp\api\bbcomm.log; verify that both IP addresses when SOCKS5 is clicked are 0.0.0.0 (the port numbers may be immaterial, I don't know); click OK

At this point, its easiest to test by opening up an Excel spreadsheet that contains BLP functionality. You can also run c:\blp\api\apidemo.exe, choose Bloomberg > Monitor, enter a security and yellow key (i.e. "IBM eqty") and click Subscribe. Click through all the status boxes that pop up until the data fields populate. If they don't after about 20 clicks or so, then call the help desk.

If everything is running, be sure to restart TaskMaster service if appropriate.