tracker issue : CF-3637491

select a category, or use search below
(searches all categories and all time range)
Title:

Coldfusion tasks will not cluster

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/CannotReproduce

Reporter/Name(from Bugbase): Rory Brown / Rory Brown (gozargozarian3)

Created: 09/20/2013

Components: Scheduler

Versions: 10.0

Failure Type:

Found In Build/Fixed In Build: Final /

Priority/Frequency: Major / All users will encounter

Locale/System: English / Windows 7

Vote Count: 0

Problem Description:
Trying to switch to clustering with the Coldfusion tasks and getting a generic error 'Error while creating tables for cluster setup for datasource CFIDE. Verify the connection. The supported databases for cluster setup are MySQL, Microsoft SQL Server and Oracle'.  The database connection is Microsoft SQL and works fine for other things.
Looking into the coldfusion log gives this error:
Couldn't obtain trigger groups: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'qrtz_TRIGGERS'.

Steps to Reproduce:
Use update 11 and try to switch tasks to clustered mode.

Actual Result:
Get an un-intuitive error and nothing happens.

Expected Result:
For this expensive piece of software to do what it is described to do.

Any Workarounds:
None that I can figure out.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3637491

External Customer Info:
External Company:  
External Customer Name: gozargozarian3
External Customer Email:  
External Test Config: Windows 7 / Server 2003 and Coldfusion 10 update 11

Attachments:

Comments:

This is currently stopping a business need. It would be great if Adobe could start a Quality Assurance program to catch some of these obvious and glaring issues. I could and should use Railo to overcome this, and it would be free.
Comment by External U.
14476 | September 20, 2013 02:14:28 PM GMT
I have checked with multiple datasources and its working fine. Can you provide additional information that will be helpful for us to reproduce the bug? Also can you check if your datasource is verifying fine or not?
Comment by Suchika S.
14477 | September 25, 2013 01:33:35 AM GMT
Datasource is verifying fine and has been working for almost a year now in a production website. The tasks have been working for the same amount of time without being clustered. Just trying to cluster them now. From what I can tell, it looks like the issue it runs into is case-sensitivity in the database. At some point it runs SQL that is looking for 'qrtz_TRIGGERS', but the table is named 'QRTZ_TRIGGERS'. There is a difference in the case of the table name. This seemed to be the issue that other people on the internet had with it. I'm not sure what other info I could provide you. Anything you want specifically?
Comment by External U.
14478 | September 25, 2013 09:18:29 AM GMT
Can you specify the exact version of Microsoft SQL you are using?
Comment by Suchika S.
14479 | September 26, 2013 12:17:15 AM GMT
It is version 10.50.2500. The coallation it is using is supposed to be case-insensitive, but it still seems to be the issue. If I load all of the tables for task clustering manually, it seems to cluster the tasks fine.
Comment by External U.
14480 | September 26, 2013 09:39:52 AM GMT
I have tried in MS SQL 2008 and not able to reproduce the bug.
Comment by Suchika S.
14481 | September 27, 2013 03:22:51 AM GMT
Did you ever find a solution? I'm having the same issue.
Comment by External U.
14482 | February 08, 2014 03:35:25 PM GMT
There was no official solution given by Adobe because they don't believe it is happening. I had to manually run the Quartz install SQL from <coldfusion install>\cfusion\lib\quartz\scripts\. Inside that directory are scripts customized for your database. Open them open and run them directly. When you set up clustering, just uncheck the "Create tables..." option and it should start using the tables.
Comment by External U.
14483 | February 10, 2014 10:16:55 AM GMT