Skip to main content
S
steak1986
Participant
August 15, 2011
Question

Slow response times

  • August 15, 2011
  • 2 replies
  • 2170 views

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. 

    This topic has been closed for replies.

    2 replies

    C
    carl type3
    Legend
    August 16, 2011

    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.

    S
    steak1986Author
    Participant
    August 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

    S
    steak1986Author
    Participant
    August 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/

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices