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)  
 
mdbboundAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

CrazeeCommented:
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
0
pinaldaveCommented:
what is your query?
0
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
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

heathprovostCommented:
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.

Heath
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.


 
0
M256Commented:
Hi mdbbound,

I'm not sure if you know this or not, but ColdFusion 6.1 has a free developer edition you can use:
http://www.macromedia.com/software/coldfusion/?promoid=home_prod_cf_082403
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.

Matthew
0
Seth_BienekCommented:
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.
0
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
0
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.