Troubleshooting
Required permissions to create SQL Server triggers, and have the triggers run a TaskCentre task
Last Updated: August 3, 2022Permissions to Create or Delete a trigger Before you can work with triggers from the Microsoft SQL Server Trigger tool, you must have the following permissions to create or delete the trigger: Action Required Permission Browse databases on the SQL instance from the Microsoft SQL Server Trigger tool Server level CONNECT SQL – Grants the...
SQL Instance Not Connectable
Last Updated: July 4, 2022Symptom Within the Configurator, the SQL Agent instance prerequisites screen displays the following error: SQL Instance Not Connectable The Configurator prompts for credentials but fails to clear the error, no matter what credentials are entered. Cause Both Shared Memory and TCP/IP must be enabled network protocols for the SQL server instance being connected to. Resolution...
SQL triggers not working. Error code 0x80037000
Last Updated: July 1, 2022Symptom Tasks triggered by the SQL trigger agent do not run and the BPA Platform event log records the following error code: 0x80037000 Cause This error occurs because by default versions of SQL Server starting with SQL Server 2005 provide a restricted set of features. Resolution The resolution is to enable OLE Automation by using...
Unable to run an SQL Server trigger: Database is modified but Task fails to trigger
Last Updated: July 1, 2022Symptom An SQL Server trigger has been created on a database table but when the table is modified the task is not triggered to run. The Windows Event Viewer log on the agent side will display the following error code stating that the task failed to queue: Error: 70000 Severity: 16 State: 1 Trigger on[Table...
Unable to run an SQL Server trigger: SQL Server blocked access to procedure ‘sys.sp_OACreate’ of component OLE Automation Procedures
Last Updated: July 1, 2022Symptom Unable to run an SQL Server trigger, the following error message is received: SQL Server blocked access to procedure ‘sys.sp_OACreate’ of component ‘Ole Automation Procedures’ because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Ole Automation Procedures’ by using sp_configure....
When configuring the Microsoft SQL Server Trigger Agent, OLE Automation is not detected
Last Updated: July 1, 2022Symptom Unable to configure the Microsoft SQL Server Trigger Agent from the TaskCentre Configurator tool as it does not detect the OLE Automation flag from the database. The Configurator log shows the following error: TCConfigurator.AddIns.SQLTriggerAddIn.SQLAgentHelper::IsOLEAutomationEnabled: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing aconnection to SQL Server. The server was not found or was...
Windows application event log shows Access Denied (-214724891) from Microsoft SQL Server Trigger Agent
Last Updated: July 1, 2022Symptom The Windows application event log shows Access Denied (-214724891) when firing a TaskCentre SQL agent trigger. This occurs when a trigger is fired using SQL Server 2005 or higher. The following error is logged to the Windows Event Log and SQL Logs: Error: 70000 Severity: 16 State: 1 Trigger on “<TABLE NAME>” failed to...
Oracle Trigger Agent – Bad version number in class file
Last Updated: July 1, 2022Symptom When you install the TaskCentre Oracle Agent on a Windows system you may see the following exception: Exception in thread "main" java.lang.UnsupportedClassVersionError: Bad version number in class file. On UNIX and Linux systems this shows as: Exception in thread "main" java.lang.ClassFormatError: TCInstallerMain (unrecognized class file version) Cause The version of java installed is incompatible...
Configuring the SMTP Virtual Server for the Email Trigger (SMTP) Agent
Last Updated: August 3, 2022Introduction In order for the Email Trigger (SMTP) Agent to receive incoming emails, the SMTP Virtual Server (available as part of IIS version 6.0) must be installed. Unfortunately, later versions of IIS (from Windows Server 2008 onwards) do not have SMTP functionality as standard. But they do allow IIS 6.0 to be installed and used...
Email attachments – An event was unable to invoke any of the subscribers 0x80040201
Last Updated: July 1, 2022Symptom When using a variable to save email attachments the following error is produced: An event was unable to invoke any of the subscribers 0x80040201 Cause There are two separate causes: The attachment file size is zero bytes, this normally indicates a blank file. The data file variable has not been setup as an Array...
