Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Slow response times

New Here ,
Aug 15, 2011 Aug 15, 2011

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. 

2.2K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 15, 2011 Aug 15, 2011

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

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 15, 2011 Aug 15, 2011

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/

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guide ,
Aug 15, 2011 Aug 15, 2011
LATEST

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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources