BI Publisher Toolbox 4.2.3

BI Publisher Toolbox Development Suite Fixes Part II

Once, again....
A new version of the BI Publisher Toolbox has been released. The following things are fixed:

• BI Publisher Toolbox fail to email reports when running burst control files
• Bursting Designer fails to e-mail reports, there are no errors
• Delivery Designer does nothing when the run button is pushed for email

The reason the output files were not being emailed is simple. The javamail-1.4.3.zip is required to make this functionality work. If you don't have these jar files you should see the following error message: Unable to locate provider for protocol: smtp. Below is some sample output from the delivery designer....Also, that's how I was able to fix this issue. The Delivery Designer is a great utility for bursting troubleshooting....

Known Issues
There is still an outstanding issue with the Bursting Designer crashing. This is caused by a space or an invalid location to a format template. Be sure to verify the template location is valid. I should have another patch out this week for this issue.

Download
The BI Publisher Toolbox can be downloaded here. I'm still working on the standalone version of the application. Should be available for download in the next couple of days. I'll update the blog when it's out there!

Sample output from the Delivery Designer
[042210_050359941][][STATEMENT] XDO_CFG Location: null
[042210_050359941][oracle.apps.xdo.delivery.smtp.SMTPDeliveryRequest][STATEMENT] submit(DeliveryResponseListener): Called
[042210_050359941][oracle.apps.xdo.delivery.smtp.SMTPDeliveryRequest][STATEMENT] submit(DeliveryResponseListener): Starting status checking thread.
[042210_050400004][oracle.apps.xdo.delivery.AbstractDeliveryRequest$RequestChecker][STATEMENT] Constructor called. [Check interval : 10000 ms][Timeout : 86400000 ms][Retry : 0][Retry interval : 60000]
[042210_050400020][oracle.apps.xdo.delivery.AbstractDeliveryRequest$RequestChecker][STATEMENT] run(): Called. Start the request checking thread for request id #1
[042210_050400020][oracle.apps.xdo.delivery.AbstractDeliveryRequest$RequestChecker][STATEMENT] run(): Begin retry loop : 0
[042210_050400020][oracle.apps.xdo.delivery.AbstractDeliveryRequest$RequestChecker][STATEMENT] run(): Calling submit()
[042210_050400020][oracle.apps.xdo.delivery.smtp.SMTPDeliveryRequest][STATEMENT] submit(): Called
[042210_050400066][oracle.apps.xdo.delivery.smtp.SMTPDeliveryRequest][STATEMENT] setDefaultServerProperties(): No properties for the server '' were found.
[042210_050400066][oracle.apps.xdo.delivery.smtp.SMTPDeliveryRequest][STATEMENT] setDefaultServerProperties(): properties defined in this request.
----
[PORT:Integer] [25]
[SMTP_FROM:String] [Ike_Wiggins@starkey.com]
[SMTP_CHARSET:String] [UTF-8]
[SMTP_CHARACTER_ENCODING:String] [UTF-8]
[SMTP_CONTENT_TYPE:String] [application/pdf]
[ASYNC_TIMEOUT:Integer] [86400000]
[SMTP_ENCODING:String] [B]
[HOST:String] [mail.starkey.com ]
[RETRY:Integer] [0]
[ASYNC_CHECK_INTERVAL:Integer] [10000]
[SMTP_TO_RECIPIENTS:String] [Ike_Wiggins@starkey.com]
[TEMP_FILE_SUFFIX:String] [.tmp]
[BUFFERING_MODE:Boolean] [true]
[SMTP_ATTACHMENT_FIRST:Boolean] [false]
[SMTP_SUBJECT:String] [This is a converison test!]
[TEMP_FILE_PREFIX:String] [dlvr]
[RETRY_INTERVAL:Integer] [60000]
----

[042210_050400066][oracle.apps.xdo.delivery.smtp.SMTPDeliveryRequest][STATEMENT] submit(): BUFFERING_MODE is ON.
[042210_050400066][oracle.apps.xdo.delivery.smtp.SMTPDeliveryRequest][STATEMENT] submit(): TEMP_DIR not found. Turn off the BUFFERING_MODE.
[042210_050400066][oracle.apps.xdo.delivery.smtp.SMTPDeliveryRequest][STATEMENT] submit(): Start reading the document file. : C:\SALES.pdf
[042210_050400066][oracle.apps.xdo.delivery.smtp.SMTPDeliveryRequest][STATEMENT] submit(): Calling DeliveryRequestHandler.submitRequest()
[042210_050400066][oracle.apps.xdo.delivery.smtp.SMTPDeliveryRequestHandler][STATEMENT] submitRequest(): called
[042210_050400113][oracle.apps.xdo.delivery.smtp.SMTPDeliveryRequestHandler][STATEMENT] submitRequest(): This request has never been submitted before.
[042210_050400145][oracle.apps.xdo.delivery.smtp.Attachment][STATEMENT] addAttachment(): Adding an attachment ...[filename]=[null], [content-type]=[application/pdf], [index]=[0], [disposition]=[inline]
[042210_050400145][oracle.apps.xdo.delivery.smtp.Attachment][STATEMENT] addAttachment(): Character set for MIME headers : UTF-8
[042210_050400145][oracle.apps.xdo.delivery.smtp.Attachment][STATEMENT] addAttachment(): Character encoding for MIME headers : B
[042210_050400145][oracle.apps.xdo.delivery.smtp.Attachment][STATEMENT] addAttachment(): Exiting addAttachment()
[042210_050400160][oracle.apps.xdo.delivery.smtp.SMTPDeliveryRequestHandler][STATEMENT] submitRequest(): Character set for MIME headers : UTF-8
[042210_050400160][oracle.apps.xdo.delivery.smtp.SMTPDeliveryRequestHandler][STATEMENT] submitRequest(): Character encoding for MIME headers : B
[042210_050400176][oracle.apps.xdo.delivery.AbstractDeliveryRequest$RequestChecker][STATEMENT] run(): Calling Thread.sleep() before checking status : 10000
[042210_050410176][oracle.apps.xdo.delivery.AbstractDeliveryRequest$RequestChecker][STATEMENT] run(): Checking request status. (10172 millisec passed since thread started.
[042210_050410176][oracle.apps.xdo.delivery.AbstractDeliveryRequest$RequestChecker][STATEMENT] run(): Got request status. (Status id : 19)
[042210_050410176][oracle.apps.xdo.delivery.AbstractDeliveryRequest$RequestChecker][STATEMENT] run(): Calling callback - DeliveryResponseListener.responseReceived()
[042210_050410176][][STATEMENT] Request done!
[042210_050410176][][STATEMENT] Request status id : 19
[042210_050410176][][STATEMENT] Request status msg: Unable to locate provider for protocol: smtp
[042210_050410176][][STATEMENT] Request body: null