A timeout occurred while attempting to lock cfadmin_sqlexecutive.

Posted on 2004-11-19
Last Modified: 2013-12-24
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)  
Question by:mdbbound
    LVL 2

    Expert Comment

    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

    LVL 22

    Expert Comment

    what is your query?

    Author Comment

    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
    LVL 5

    Accepted Solution

    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.


    Author Comment

    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.

    LVL 5

    Assisted Solution

    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.

    LVL 5

    Assisted Solution

    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.

    Author Comment

    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 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

    Author Comment

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Title # Comments Views Activity
    Internal DNS Zone Issue 13 36
    IIS 8.5 2 38
    wordpress email form 23 59
    New OSQA server has a ton of fake users 4 37
    Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
    Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now