AnsweredAssumed Answered

RAWSQL PROPERTY IS NOT WORKING (Agent v9.1.0.2)

Question asked by rodfloprz on Jun 15, 2012
Latest reply on Jun 20, 2016 by Hiko_Davis
Hi Everyone:

A java agent is configured in a weblogic server 10.3 and it is necessary to get SQL parameters, so I found a property in a pdf file that describe how to do it.

It consist of uncommenting introscope.agent.sqlagent.sql.rawsql and set into "true" value.

But at this moment I can not see parameters in a trasanction trace as the attached image shows.


6/13/12 12:34:08 PM CDT [INFO] [IntroscopeAgent.ProbeInformation] Instrumentation of code in managed application has created a non supported ordering of tracer. This could lead to application performance degradation and missing reported data. Please verify the autoprobe log and consult documentation. 
Probed declared class name: oracle.jdbc.driver.OraclePreparedStatement
Probed method: executeQuery()Ljava/sql/ResultSet;
Probed runtime class name: oracle.jdbc.driver.T4CPreparedStatement

6/13/12 12:34:08 PM CDT [INFO] [IntroscopeAgent.Agent] Configuration property (introscope.agent.errorsnapshots.throttle) set to "10"
6/13/12 12:34:08 PM CDT [INFO] [IntroscopeAgent.Agent] Configuration property (introscope.agent.errorsnapshots.throttle) set to "10"
6/13/12 12:35:17 PM CDT [VERBOSE] [IntroscopeAgent.Agent] Skipping invalid class name:com.syc.fortimax.service.model.package-info
6/13/12 12:35:22 PM CDT [VERBOSE] [IntroscopeAgent.Agent] Skipping invalid class name:com.syc.fortimax.service.model.package-info
6/13/12 12:37:37 PM CDT [INFO] [IntroscopeAgent.Agent] Cross-JVM tracing has been disabled
6/13/12 12:37:37 PM CDT [INFO] [IntroscopeAgent.Agent] Activating JMX Data Collection
6/13/12 12:37:42 PM CDT [INFO] [IntroscopeAgent.Agent] Using the following JMX Primary Keys: 
6/13/12 12:37:42 PM CDT [INFO] [IntroscopeAgent.Agent] Using the following JMX Filter Keys: ThreadPoolRuntime:ExecuteThreadIdleCount,ThreadPoolRuntime:ExecuteThreadTotalCount,ThreadPoolRuntime:HoggingThreadCount,ThreadPoolRuntime:PendingUserRequestCount,ThreadPoolRuntime:QueueLength,ThreadPoolRuntime:StandbyThreadCount,ThreadPoolRuntime:Throughput,JDBCDataSourceRuntime|*:ActiveConnectionsCurrentCount,JDBCDataSourceRuntime|*:ActiveConnectionsHighCount,JDBCDataSourceRuntime|*:ConnectionDelayTime,JDBCDataSourceRuntime|*:ConnectionsTotalCount,JDBCDataSourceRuntime|*:CurrCapacity,JDBCDataSourceRuntime|*:CurrCapacityHighCount,JDBCDataSourceRuntime|*:FailedReserveRequestCount,JDBCDataSourceRuntime|*:FailuresToReconnectCount,JDBCDataSourceRuntime|*:HighestNumAvailable,JDBCDataSourceRuntime|*:HighestNumUnavailable,JDBCDataSourceRuntime|*:LeakedConnectionCount,JDBCDataSourceRuntime|*:NumAvailable,JDBCDataSourceRuntime|*:NumUnavailable,JDBCDataSourceRuntime|*:WaitingForConnectionCurrentCount,JDBCDataSourceRuntime|*:WaitingForConnectionFailureTotal,JDBCDataSourceRuntime|*:WaitingForConnectionHighCount,JDBCDataSourceRuntime|*:WaitingForConnectionSuccessTotal,JDBCDataSourceRuntime|*:WaitingForConnectionTotal,JDBCDataSourceRuntime|*:WaitSecondsHighCount,JMSDestinationRuntime|*:BytesCurrentCount,JMSDestinationRuntime|*:BytesHighCount,JMSDestinationRuntime|*:BytesPendingCount,JMSDestinationRuntime|*:BytesReceivedCount,JMSDestinationRuntime|*:ConsumersCurrentCount,JMSDestinationRuntime|*:ConsumersHighCount,JMSDestinationRuntime|*:ConsumersTotalCount,JMSDestinationRuntime|*:MessagesCurrentCount,JMSDestinationRuntime|*:MessagesDeletedCurrentCount,JMSDestinationRuntime|*:MessagesHighCount,JMSDestinationRuntime|*:MessagesPendingCount,JMSDestinationRuntime|*:MessagesReceivedCount,WorkManagerRuntime|*:CompletedRequests,WorkManagerRuntime|*:PendingRequests,WorkManagerRuntime|*:StuckThreadCount,ExecuteQueueRuntime|*:ExecuteThreadCurrentIdleCount,ExecuteQueueRuntime|*:ExecuteThreadTotalCount,ExecuteQueueRuntime|*:PendingRequestCurrentCount,ExecuteQueueRuntime|*:ServicedRequestTotalCount,WebAppComponentRuntime|*:OpenSessionsCurrentCount,WebAppComponentRuntime|*:OpenSessionsHighCount,WebAppComponentRuntime|*:SessionsOpenedTotalCount,WebAppComponentRuntime|*:SessionTimeoutSecs
6/13/12 12:37:42 PM CDT [INFO] [IntroscopeAgent.Agent] Lookup and use the platform MBeanServer instead of creating a new one




 (com.wily.use.platform.mbeanserver) set to default value of "false"
6/13/12 12:37:42 PM CDT [INFO] [IntroscopeAgent.JMXService] JMX data collection activated
6/13/12 12:41:29 PM CDT [INFO] [IntroscopeAgent.Agent] Automatically renaming the Agent to "evolv_bco_dev_domain//evolv_bco_dev_server".
6/13/12 12:41:29 PM CDT [INFO] [IntroscopeAgent.Agent] The Introscope AutoProbe log file has been automatically renamed from /bea/Introscope9.1.0.2/wily/logs/AutoProbe.WebLogicAgent.log to /bea/Introscope9.1.0.2/wily/logs/AutoProbe.evolv_bco_dev_domain__evolv_bco_dev_server.log.
6/13/12 12:41:29 PM CDT [INFO] [IntroscopeAgent.Agent] The Introscope Agent log file has been automatically renamed from /bea/Introscope9.1.0.2/wily/logs/IntroscopeAgent.WebLogicAgent.log to /bea/Introscope9.1.0.2/wily/logs/IntroscopeAgent.evolv_bco_dev_domain__evolv_bco_dev_server.log.
6/13/12 12:41:29 PM CDT [INFO] [IntroscopeAgent.Agent] The Introscope Agent is sending a name change request (from "WebLogicAgent" to "evolv_bco_dev_domain//evolv_bco_dev_server") to the Introscope Enterprise Manager.
6/13/12 12:41:29 PM CDT [INFO] [IntroscopeAgent.IsengardServerConnectionManager] The name of the Introscope Agent has been changed to "evolv_bco_dev_domain//evolv_bco_dev_server".
6/13/12 12:41:29 PM CDT [VERBOSE] [IntroscopeAgent.Agent] Registering RemoteConfigurationService for new agent name : wlsdev|WebLogic|evolv_bco_dev_domain//evolv_bco_dev_server
6/13/12 12:41:29 PM CDT [VERBOSE] [IntroscopeAgent.Thread dump] The ThreadDump Extension is attempting to register its service with the EM
6/13/12 12:41:29 PM CDT [VERBOSE] [IntroscopeAgent.Agent] Registering class com.wily.introscope.agent.bizrecording.BizRecordingServiceBean for new agent name : wlsdev|WebLogic|evolv_bco_dev_domain//evolv_bco_dev_server
6/13/12 12:43:57 PM CDT [INFO] [IntroscopeAgent.Agent] Waiting for the agent server connection to set the sampling per interval and samples per intervals
6/13/12 12:43:57 PM CDT [INFO] [IntroscopeAgent.Agent] Waiting for the agent server connection to set the sampling per interval and samples per intervals
6/13/12 12:43:58 PM CDT [INFO] [IntroscopeAgent.Agent] Waiting for the agent server connection to set the sampling per interval and samples per intervals
6/13/12 12:43:58 PM CDT [INFO] [IntroscopeAgent.Agent] Waiting for the agent server connection to set the sampling per interval and samples per intervals
6/13/12 12:43:58 PM CDT [INFO] [IntroscopeAgent.Agent] Waiting for the agent server connection to set the sampling per interval and samples per intervals
6/13/12 12:43:58 PM CDT [INFO] [IntroscopeAgent.Agent] Waiting for the agent server connection to set the sampling per interval and samples per intervals
6/13/12 12:43:59 PM CDT [INFO] [IntroscopeAgent.Agent] Waiting for the agent server connection to set the sampling per interval and samples per intervals
6/13/12 12:43:59 PM CDT [INFO] [IntroscopeAgent.Agent] Waiting for the agent server connection to set the sampling per interval and samples per intervals
6/13/12 12:43:59 PM CDT [INFO] [IntroscopeAgent.Agent] Waiting for the agent server connection to set the sampling per interval and samples per intervals
6/13/12 12:44:00 PM CDT [INFO] [IntroscopeAgent.Agent] Waiting for the agent server connection to set the sampling per interval and samples per intervals
6/13/12 12:44:00 PM CDT [WARN] [IntroscopeAgent.Agent] The agent server connection did not set the sampling per interval and samples per intervals!
6/13/12 12:44:37 PM CDT [INFO] [IntroscopeAgent.ProbeInformation] Instrumentation of code in managed application has created a non supported ordering of tracer. This could lead to application performance degradation and missing reported data. Please verify the autoprobe log and consult documentation. 
Probed declared class name: oracle.jdbc.driver.OraclePreparedStatement
Probed method: executeBatch()[I
Probed runtime class name: oracle.jdbc.driver.T4CPreparedStatement
Best Regards

Rodrigo

Outcomes