asked on

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 127.0.0.1
Referer
Date/Time 19-Nov-04 05:47 PM

Stack Trace (click to expand)

Crazee

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

Cheers

pinaldave

what is your query?

mdbbound

ASKER

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

ASKER CERTIFIED SOLUTION

heathprovost

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mdbbound

ASKER

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.

SOLUTION

M256

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Seth_Bienek

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mdbbound

ASKER

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

mdbbound

ASKER

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