[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 685
  • Last Modified:

A timeout occurred while attempting to lock cfadmin_sqlexecutive.

I have created a DB2 datasource connecting to linux however it is not stable.  Sometimes I am connected, and most of the time it does not connect.   I always get the following error and CF Admin hangs up, as a matter of fact right now i can't even get in to CFAdmin.  Can someone please help me?  Thank you.  I am using CFMX and it's very hard to test the queries.

Error Occurred While Processing Request  
A timeout occurred while attempting to lock cfadmin_sqlexecutive.  
The Error Occurred in C:\CFusionMX\wwwroot\CFIDE\administrator\Application.cfm: line 158
Please Try The Following:

Check the CFML Reference Manual to verify that you are using the correct syntax.

Search the Knowledge Base to find a solution to your problem.

Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Remote Address
Date/Time   19-Nov-04 05:47 PM
Stack Trace (click to expand)  
3 Solutions
You can try to inecrase lock timeout value, just to see if it makes any difference...
Check what scopes of lock you are using, and if they are nested make sure that application lock is inside the session etc...
Best if you could post the Application.cfm file as it hard to say anything specific

what is your query?
mdbboundAuthor Commented:
It's not about the query, or locks on my code.  It's about the datasource and connection and seeing my database tables.  I get disconnected a lot of times and have to verify my datasource.  However, The Coldfusion Administration will hang up once all this happens
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

What version of CF are you running? Is it 6.0 or 6.1? There is a bug noted as fixed in 6.1 (bug 48538). Description of the fixed bug is as follows:

"Attempting to verify a bad data source within the Administrator would cause the Administrator to hang."

That explains the hang, at least if you are running 6.0, but it doesnt explain why the data source is bad in the first place... It might help if you post details for the datasource, i.e. what driver you are using, network configuration, etc.

mdbboundAuthor Commented:
Hi Heath,

I am using the following:

CF Developer Version 6.0 (in my PC)
Database: DB2 on a linux server
Driver:  DB2 Universal Database
I connect through the network

My PC also has DB2 Client Fixpack 6

Is it because I am using the developer version or does the Enterprise Edition has the same problem?

The trial version of 6.1 only works for 30 days.  Does it normally have the full feature and then after 30 days some features will no longer work?

Thank you Heath for taking some time and give your input.

Hi mdbbound,

I'm not sure if you know this or not, but ColdFusion 6.1 has a free developer edition you can use:
It should be identical to the production version; except it is limited to two IP addresses connecting (the server and the developer client).

I don't remember for sure, but I think the trial version will revert to the developer edition after the 30 days.

Would you mind clicking on the 'Stack Trace (click here to expand) link and sending the entire error?

That would be helpful, but ultimately, it looks like the error is a symptom of another problem, rather than being the problem itself.

My guess without knowing too much is that there's a configuration error somewhere in the DSN, or that there is a network connectivity problem.

Are you able to conect to the DB2 datasource through other apps on your local machine?  What do you use for managing your database?  Is it working ok?  No disconnects, lags..?

Check connectivity from your workstation:
Go to a command prompt (Start -> Run -> type 'command'), and type 'ping [ip]) -t' where [ip] is your db2 server's ip address, and watch that for a minute or so to see if there are any dropped packets.

If everything looks OK as far as your network goes, then it's gotta be a config issue.

Hope this helps!

Seth Bienek

PS: After 30 days, the trial version of CFMX automatically switches to "developer mode", and will only work from one IP address, but remains otherwise fully functional.
mdbboundAuthor Commented:
The connection is fine when I used the IBM interface Client Configuration (kinda like SQL Server), this is how I know that the linux/UDB server is up and I can also query my database there just like in SQL Server.

I will download the CFMX 6.1 and will try that as it says in Macromedia.com that 6.1 fixed that bug.  I just hope that i will be affected by other problems because 6.1 has its own issues as well.

Just to let you know that CF5.0 has a stable datasource connection to linux/DB2, I wonder what happened to CFMX

Thanks so much for all your input, i will keep you posted
mdbboundAuthor Commented:
So far, I do not have any problem with my datasource.  I have moved my data from Access to UDB using Coldfusion.

Now, I am in a stage of modifying my cfquery to work with UDB.  It's harder than I thought.

I will now close this post and award the points

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now