search : database monitoring

Database Monitoring using Performance Monitoring Toolset

to deal with database […] The post Troubleshooting your application using Performance Monitoring Toolset appeared first on ColdFusion. Adobe ColdFusion,Question,Webinars

application. This include issues around JVM, database issues, application […] The post Overview of the new Performance Monitoring Toolset Webinar :: Recording appeared first on ColdFusion. Adobe ColdFusion 2018,Performance Monitoring Toolset,Question

Bug 82583:In the Server Monitor's Database>Pool Status" page, there seems a mistake in the value reported for "max connections" (on the detail page for a given DSN)

Comment on Error Executing Database Query. Timed out trying to establish connection by External U.

Comment on Error Executing Database Query. Timed out trying to establish connection by External U.

Bug 82584:In the Server Monitor's Database>Pool Status" page, it seems that front page has ample room to add some more columns of data which is now only available by clicking a DSN to see the detail page

during development for debugging and tuning. Please add :) Method: Create an ORM application and run something like EntityLoad( "FOO" ), the executed SQL does not appear in the Database Statistcs section of the Server Monitor. Result: ER: The Server Monitor does not show SQL statements generated

Bug 84259:(Watson Migration Closure)When running long running jobs (Scheduled Tasks) that process thousands of documents, if the Server Monitor's "Monitoring" & "Profiling" features are enabled, the JVM will quickly consume all availabl

Profiler. Every client variable retrieval and update executes sp_prepare, then the statement, then sp_unprepare. I have seen this on SQL Server 2000 and 2005. Method: Connect a SQL Server database as the client storage mechanism. Write a small application that makes use of the client scope. Monitor

5819465 CF-4204482 Database,PMT : Database Monitoring CF2018 adding DB error exception in CF logs when connecting to PMT. Problem: CF2018 adding DB error exception in CF logs when connecting to PMT. Method: The customer added PMT and ColdFusion node and their logs are getting filled

(CACHED=false) Open URL: /internal_ true/?cache=4 (CACHED=false) Refresh URL: /internal_ true/?cache=4 (CACHED=false) Click CLEAR & KILL to test again Show DATABASE - Query Cache Status: /internal_true/monitor.png ----------------------------- Additional Watson Details

access. Sometimes JMC can be useful to use to know if tomcat threads are taking a long time to respond which is indicative of CFML or database slowness. There are other vendor tools available to check on parts of CF11 performance like CFs own Server Monitoring if you have Enterprise edition. Note: Java

Bug 73949:(Watson Migration Closure)I believe restructuring of ColdFusion administrator settings (and the resources they describe) into a standardised model of resources, resource settings, resource security, resource monitors and resou

2596957 CF-3312296 External U. I frequently get calls from clients indicating that they see a new order in the database, but didn't get any email notification. We often send email alerts to third-party providers, but we can't depend on CFMail (Spool or non-spool) since it doesn't consistently work

java.lang.NullPointerException with insert / update for DB2 database

6369214 CF-4205501 Database : CFQuery Unable to run query inside Dynamic Proxy Problem Description: Trying to execute a query using cfquery tag and queryExecute() throws nullPointer when run from within a Dynamic Proxied object. Steps to Reproduce: Using RabbitMQs amqp-client-5.6.0.jar consume

Fusion installed in a windows serverPath /domains specified in the cfclocation does not exist. Method: this.databaseName = 'tutorial';this.ormsettings = {datasource=this.databaseName, dbcreate="update", cfclocation="/domains"}; Result: coldfusion

2609373 CF-3852375 Database : JDBC John Breidenstine DB2 9.7 FP9 Insert Query autogenerated keys retrieval fails with “Element 1 is undefined in RDS” error Problem: Insert Query autogenerated keys retrieval fails with When DB2 9.7 Fix Pack 9 and throws below error:- - Error Occurred While

2601423 CF-3037977 Database : General daniel plesse Bug 76111:Mysql driver 5 Problem: Mysql driver 5.0.5 returns java.lang.NullPointerException at com.mysql.jdbc.Statement.setMaxRows(Statement.java:2178) when maintain connection is set Mysql driver 5.1 returns java.io.EOFException: Can

2598929 CF-3040783 Database : CFQuery Joseph DeVore Bug 81646:Any time I try to use preserveSingleQuotes() inside a CFQUERYPARAM with list="yes", the query doesn't return any values at all and throws an error saying that the query name doesn't exist Problem: Any time I try to use preserve

2600373 CF-3039097 ORM Support Sam Farmer Bug 78418:Hi, Problem: Hi, I am getting a DDL generation error with the code below. Connecting to a MySQL 5.1 community database on Mac OS 10.5.7. Thanks, Sam Method: App.cfc: Component Application { this.name = "trackrApp"; this

to handle it with dbcreate = "update" in the ORMSettings. When I went to the page yesterday it gave the error message below, only instead of being empty, it displayed "7". I've confirmed that the server is running, and that the datasource user has full permissions on the database. Method: Application

2598749 CF-3040986 Database : Query-of-Query(IMQ) Mike Nicholls Bug 82178:With ColdFusion 9 CHF 1 installed, using a column name when using query-of-queries on a query returned from entityToQuery() which has had an extra column added using queryAddColumn() throws the error Problem: With Cold

,SECUREJSON,SECUREJSONPREFIX,SERVERSIDEFORMVALIDATION,SESSIONMANAGEMENT,SESSIO NTIMEOUT,SETCLIENTCOOKIES,SETDOMAINCOOKIES. [vmannebo 11/19/09] Error Executing Database Query. Datasource not found. The error occurred in C:\work\depot\ColdFusion\cf_main\cfusion\wwwroot\bugs\81519\SP\sp.cfm: line 22 20 : DBVarName ="@data_type" 21 : value = "#count#" 22 : CFSQLType = "CF

2602320 CF-3036985 ORM Support John Beynon Bug 74091:If you have a persistent object name object Problem: If you have a persistent object name object.cfc, the database schema will get created but if you try entity load you receive message; unexpected token: object near line 1, column 6 [from

.2.0.4: Success every time Actual result in CF2016 (2016.0.03.301771) with Oracle 11.2.0.4 or Oracle 12.1.0.2 (with latest bundle patches): Exception every time: Error Executing Database Query. [Macromedia][Oracle JDBC Driver]Object has been closed. The error occurred in C

5716595 CF-4204302 Database : Derby Derby throws ArrayIndexOutOfBoundsException on UPDATE Problem Description: When running an UPDATE statement against a DERBY datasource throws an ArrayIndexOutOfBoundsException The same UPDATE statement works fine on CF2016 update 10, which uses Derby 10

the information to the database, however when i try to load an existing record in the database, and save any of the information, an error is thrown that indicates that there is an invalid parameter binding. what appears to be happening is that the object is ignoring any of the information being stored