Search This Blog

Friday, November 7, 2014

Job fails on kickouts

Symptom:
Job failed on kickouts. Please reference SQLISPackage100 errors on the SQL server application event log more detail.

Upon further inspection of the SQLISPackage100 in the Windows event log, the following error is discovered:

Event Name: OnError
Log Name:      Application
Source:        SQLISPackage110
Date:          11/7/2014 11:54:48 AM
Event ID:      12550
Task Category: None
Level:         Error
Keywords:      Classic
User:          AM\BPCADMINMAME
Computer:      servername
Description:
Event Name: OnError
Message: Incorrect syntax near ')'



Reason for Issue:
This is due to SQL casting problem in the routine p_ETL_KICK when nulls or blanks are discovered in the signeddata column.   This affects DBObjects version 3.2.8 or higher.


Solution:
There is a patch available to solve this issue.  Download and execute the script p_ETL_KICK_v3.1.sql on the troubled instance of BPM Connect to clear up this  problem.  This patch will be included in the 321 pack of BPM Connect.

No comments:

Post a Comment