Copy link to clipboard
Copied
This last weekend, we migrated off of our old server 2003 cf7mx server, to a new Server 2008r2 x64 CF 9,0,1,274733 server. We are now experiencing slow response times for our server,according to the Windows Performance monitor our Avg Request times are way up. I have been going through some logs but nothing seems to leap out at me, but i am not the best CF admin. As i dont know what information would be usefull, i have tried to give all the info.
Here is our coldfusion-event log:
08/14 16:22:58 user JSPServlet: init
08/14 16:23:00 user ColdFusionStartUpServlet: init
08/14 16:23:00 user ColdFusionStartUpServlet: ColdFusion: Starting application services
08/14 16:23:00 user ColdFusionStartUpServlet: ColdFusion: VM version = 14.3-b01
08/14 16:23:08 user ColdFusionStartUpServlet: ColdFusion: application services are now available
08/14 16:23:08 user CFMxmlServlet: init
08/14 16:23:08 user CFMxmlServlet: Macromedia Flex Build: 87315.134646
08/14 16:23:10 user CFSwfServlet: init
08/14 16:23:10 user CFCServlet: init
08/14 16:23:12 user FlashGateway: init
08/14 16:23:12 user MessageBrokerServlet: init
08/14 16:23:13 user CFFormGateway: init
08/14 16:23:13 user CFInternalServlet: init
08/14 16:23:13 user WSRPProducer: init
08/14 16:23:13 user ServerCFCServlet: init
08/15 08:13:09 user GraphServlet: init
08/15 10:25:45 user CFInternalServlet: destroy
08/15 10:25:50 user FlashGateway: destroy
08/15 10:25:50 user WSRPProducer: destroy
08/15 10:25:50 user CFCServlet: destroy
08/15 10:25:50 user GraphServlet: destroy
08/15 10:25:50 user CFMxmlServlet: destroy
08/15 10:25:50 user CFFormGateway: destroy
08/15 10:25:50 user CFSwfServlet: destroy
08/15 10:26:50 info No JDBC data sources have been configured for this server (see jrun-resources.xml)
08/15 10:26:50 info JRun Proxy Server listening on *:51800
08/15 10:26:50 info Deploying enterprise application "Adobe_ColdFusion_9" from: file:/C:/ColdFusion9/
08/15 10:26:51 info Deploying web application "Adobe ColdFusion 9" from: file:/C:/ColdFusion9/
08/15 10:26:52 user JSPServlet: init
08/15 10:26:53 user ColdFusionStartUpServlet: init
08/15 10:26:53 user ColdFusionStartUpServlet: ColdFusion: Starting application services
08/15 10:26:53 user ColdFusionStartUpServlet: ColdFusion: VM version = 14.3-b01
08/15 10:26:58 user ColdFusionStartUpServlet: ColdFusion: application services are now available
08/15 10:26:58 user CFMxmlServlet: init
08/15 10:26:58 user CFMxmlServlet: Macromedia Flex Build: 87315.134646
08/15 10:26:59 user CFSwfServlet: init
08/15 10:27:00 user CFCServlet: init
08/15 10:27:03 user FlashGateway: init
08/15 10:27:03 user MessageBrokerServlet: init
08/15 10:27:04 user CFFormGateway: init
08/15 10:27:04 user CFInternalServlet: init
08/15 10:27:04 user WSRPProducer: init
08/15 10:27:05 user ServerCFCServlet: init
08/15 10:36:30 user CFInternalServlet: destroy
08/15 10:36:36 user FlashGateway: destroy
08/15 10:36:36 user WSRPProducer: destroy
08/15 10:36:36 user CFCServlet: destroy
08/15 10:36:36 user CFMxmlServlet: destroy
08/15 10:36:36 user CFFormGateway: destroy
08/15 10:36:36 user CFSwfServlet: destroy
08/15 10:38:35 info No JDBC data sources have been configured for this server (see jrun-resources.xml)
08/15 10:38:35 info JRun Proxy Server listening on *:51800
08/15 10:38:35 info Deploying enterprise application "Adobe_ColdFusion_9" from: file:/C:/ColdFusion9/
08/15 10:38:35 info Deploying web application "Adobe ColdFusion 9" from: file:/C:/ColdFusion9/
08/15 10:38:36 user JSPServlet: init
08/15 10:38:37 user ColdFusionStartUpServlet: init
08/15 10:38:37 user ColdFusionStartUpServlet: ColdFusion: Starting application services
08/15 10:38:37 user ColdFusionStartUpServlet: ColdFusion: VM version = 14.3-b01
08/15 10:38:41 user ColdFusionStartUpServlet: ColdFusion: application services are now available
08/15 10:38:41 user CFMxmlServlet: init
08/15 10:38:41 user CFMxmlServlet: Macromedia Flex Build: 87315.134646
08/15 10:38:44 user CFSwfServlet: init
08/15 10:38:44 user CFCServlet: init
08/15 10:38:46 user FlashGateway: init
08/15 10:38:46 user MessageBrokerServlet: init
08/15 10:38:47 user CFFormGateway: init
08/15 10:38:47 user CFInternalServlet: init
08/15 10:38:47 user WSRPProducer: init
Here is our cf application log:
"Severity","ThreadID","Date","Time","Application","Message"
"Information","jrpp-0","06/25/11","19:24:19",,"C:\ColdFusion9\logs\application.log initialized"
"Error","jrpp-0","06/25/11","19:24:19",,"File not found: /CFIDE/main/ide.cfm The specific sequence of files included or processed is: C:\inetpub\wwwroot\CFIDE\main\ide.cfm'' "
"Error","jrpp-1","06/25/11","22:14:06",,"File not found: /CFIDE/main/ide.cfm The specific sequence of files included or processed is: C:\inetpub\wwwroot\CFIDE\main\ide.cfm'' "
"Error","jrpp-2","06/25/11","22:32:05",,"File not found: /CFIDE/main/ide.cfm The specific sequence of files included or processed is: C:\inetpub\wwwroot\CFIDE\main\ide.cfm'' "
"Information","jrpp-3","06/26/11","11:45:13","CFADMIN","Invalid login for Default User"
"Error","jrpp-0","07/06/11","15:46:07",,"File not found: /CFIDE/main/ide.cfm The specific sequence of files included or processed is: C:\inetpub\wwwroot\CFIDE\main\ide.cfm'' "
"Error","jrpp-1","08/14/11","20:56:25","impager","Element DEPT is undefined in FORM. The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\clinical\pagers\impager\sendpage.cfm, line: 1 "
"Error","jrpp-1","08/14/11","21:04:33",,"File not found: /CFIDE/main/ide.cfm The specific sequence of files included or processed is: C:\inetpub\wwwroot\CFIDE\main\ide.cfm'' "
"Error","jrpp-4","08/14/11","22:04:43","impager","Element DEPT is undefined in FORM. The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\clinical\pagers\impager\sendpage.cfm, line: 1 "
"Error","jrpp-36","08/15/11","08:50:29","TEAMS_database","Variable MYPERIOD is undefined. The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\monthly_entry.cfm, line: 220 "
"Error","jrpp-50","08/15/11","09:12:36",,"Invalid CFML construct found on line 2 at column 25.ColdFusion was looking at the following text:<p>=</p><p>The CFML compiler was processing:<ul><li>An expression that began on line 2, column 8.<br>The expression might be missing an ending #, for example, #expr instead of #expr#.<li>A cfset tag beginning on line 2, column 2.</ul> The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\clinpub\L2\ess\page3e.cfm, line: 2 "
"Error","jrpp-50","08/15/11","09:13:39",,"Invalid CFML construct found on line 2 at column 25.ColdFusion was looking at the following text:<p>=</p><p>The CFML compiler was processing:<ul><li>An expression that began on line 2, column 8.<br>The expression might be missing an ending #, for example, #expr instead of #expr#.<li>A cfset tag beginning on line 2, column 2.</ul> The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\clinpub\L2\ess\page3e.cfm, line: 2 "
"Error","jrpp-50","08/15/11","09:14:17",,"Invalid CFML construct found on line 42 at column 35.ColdFusion was looking at the following text:<p>=</p><p>The CFML compiler was processing:<ul><li>An expression that began on line 42, column 8.<br>The expression might be missing an ending #, for example, #expr instead of #expr#.<li>A cfset tag beginning on line 42, column 2.</ul> The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\clinpub\L2\ess\page4a.cfm, line: 42 "
"Error","jrpp-78","08/15/11","09:56:53","TEAMS_database","Variable MYPERIOD is undefined. The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\monthly_entry.cfm, line: 220 "
"Error","jrpp-75","08/15/11","10:10:12","TEAMS_database","Error Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\monthlyentry1a.cfm, line: 9 "
"Error","jrpp-80","08/15/11","10:10:46","TEAMS_database","Error Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\monthlyentry1a.cfm, line: 9 "
"Error","jrpp-78","08/15/11","10:11:28","TEAMS_database","The request has exceeded the allowable time limit Tag: CFQUERY The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\monthlyentry1a.cfm, line: 124 "
"Error","jrpp-89","08/15/11","10:13:20","TEAMS_database","The request has exceeded the allowable time limit Tag: CFQUERY The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\monthlyentry1a.cfm, line: 418 "
"Error","jrpp-88","08/15/11","10:13:52","TEAMS_database","Error Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\login.cfm, line: 77 "
"Error","jrpp-82","08/15/11","10:14:35","TEAMS_database","The request has exceeded the allowable time limit Tag: CFQUERY The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\monthlyentry1a.cfm, line: 9 "
"Error","jrpp-92","08/15/11","10:16:25","TEAMS_database","The request has exceeded the allowable time limit Tag: CFQUERY The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\login.cfm, line: 77 "
"Error","jrpp-84","08/15/11","10:18:11","impager","Error Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\clinical\pagers\impager\pagerlist.cfm, line: 620 "
"Error","jrpp-89","08/15/11","10:19:37","TEAMS_database","The request has exceeded the allowable time limit Tag: CFQUERY The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\entry_2011_1.cfm, line: 233 "
"Error","jrpp-80","08/15/11","10:22:19","TEAMS_database","Error Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\entry_2011_1.cfm, line: 154 "
"Error","jrpp-92","08/15/11","10:23:24","TEAMS_database","Error Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\login.cfm, line: 84 "
"Error","jrpp-96","08/15/11","10:24:12","TEAMS_database","The request has exceeded the allowable time limit Tag: cfoutput The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\entry_2011_2.cfm, line: 157 "
"Error","jrpp-95","08/15/11","10:24:12","TEAMS_database","The request has exceeded the allowable time limit Tag: CFQUERY The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\entry_2011_1.cfm, line: 233 "
"Error","jrpp-14","08/15/11","10:31:03","TEAMS_database","Error Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\monthlyentry1a.cfm, line: 9 "
"Error","jrpp-2","08/15/11","10:31:33","TEAMS_database","Error Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\sow.cfm, line: 144 "
"Error","jrpp-15","08/15/11","10:32:04","TEAMS_database","Error Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\TA_entry.cfm, line: 154 "
"Error","jrpp-1","08/15/11","10:32:15","TEAMS_database","The request has exceeded the allowable time limit Tag: CFQUERY The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\monthlyentry1a.cfm, line: 124 "
"Error","jrpp-12","08/15/11","10:32:58","TEAMS_database","The request has exceeded the allowable time limit Tag: CFQUERY The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\sow.cfm, line: 169 "
"Error","jrpp-10","08/15/11","10:33:21","TEAMS_database","The request has exceeded the allowable time limit Tag: CFQUERY The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\monthlyentry1a.cfm, line: 418 "
"Error","jrpp-4","08/15/11","10:33:43","TEAMS_database","The request has exceeded the allowable time limit Tag: CFQUERY The specific sequence of files included or processed is: C:\inetpub\wwwroot\cf\tpep\teendata\entry_2011_2.cfm, line: 233 "
Please let me know if any other data would be usefull.
Copy link to clipboard
Copied
I also have this error in my CF admin event log a lot
The description for Event ID 0 from source ColdFusion 9 ODBC Server cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
ColdFusion 9 ODBC Server@LOCALHOST,ErrorCode=3059,ErrorMessage=The specified data source is not defined.,ClientHost=127.0.0.1,Session=969
Copy link to clipboard
Copied
Also We do not use sql, right now we are still using old Access databases, and creating manual entries in the ODBC admin in syswow64. similar to this post http://www.cfexecute.com/post/access-dsns-in-64bit-coldfusion/
Copy link to clipboard
Copied
Hi,
I expect the error details in CF9\runtime\logs\coldfusion-out.log will like provide a clue as to problem.
For a more long term plan I think you should do what you can to migrate the ACCESS data to SQL or some other database.
HTH, Carl.
Find more inspiration, events, and resources on the new Adobe Community
Explore Now