BI Publisher Toolbox 4.5

BI Publisher Toolbox Development Suite Fixes Part III

Last series of updates!!!

A new version of the BI Publisher Toolbox has been released. The following things are fixed in version 4.5

• Bursting Designer randomly crashes when bursting

There are several reasons why the Bursting Designer crashes. It mainly has to do with incorrect or blank data. So, I've coded so more validation to catch these problems before a control file is run. You will still be able to enter invalid file paths (just not in the bursting designer). The following error messages will be displayed if you have incorrectly keyed data in your control file:

1. Document output type cannot be null. See deliveries: [ something]
2. Document key cannot be null. See deliveries: [ something]
3. Document Delivery Id must be assigned!
4. Template type must be populated!
5. Template Location file-path is invalid

If the Bursting Designer still crashes please let me know and I'll fix it.

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!

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

BI Publisher Toolbox 4.2.1

BI Publisher Toolbox Development Suite

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

• Toolbox configuration fails to save or load
• Adhoc PL/SQL attempts to execute when the field is blank or null
• Parameters dialog doesn't open when you click on the button in cell and error is displayed
• Data Template fails to execute and errors out

The BI Publisher Toolbox can be downloaded here. On a side-note, there will be standalone version of the application that will be available for download in the next couple of days. I'll update this post when it's available.