Skip Headers
Oracle® Enterprise Manager System Monitoring Plug-in Troubleshooting Guide
Release 12.1.0.3.0 for Third-Party Database Plug-ins

E35212-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

4 Troubleshooting Sybase ASE Plug-in

The following sections provide troubleshooting scenarios related to Sybase Adaptive Server Enterprise (ASE) plug-in:

4.1 General Error Messages

Table 4-1 shows typical error messages, possible causes, and resolution you may encounter while working with the Sybase ASR plug-in.

Table 4-1 General Error Messages for Troubleshooting Sybase ASE Plug-in

Error Message Possible Cause Action
Failed to connect, JZ006: 
Caught IOException:
 java.net.ConnectException: 
Connection refused

Port number is incorrect.

Specify the correct port number in the JDBC URL.

Failed to connect, JZ00L: 
Login failed. 
Examine the SQLWarnings chained to 
this exception for the reason(s)

The DB user name and password are incorrect.

Specify the correct DB user name and password.

If that does not work try adding ?charset=iso_1 last in the JDBC URL. For example:

jdbc:sybase:Tds:<HOST>:<PORT>/?charset=iso_1
JZ006: Caught IOException:
 java.io.IOException OR JZ0I6: 
An error occurred converting UNICODE 
to the charset used by the server 
OR 
Error message:
 java.io.CharConversionException:
 java.io.UnsupportedEncodingException:
 hp-roman8

The ?charset=iso_1 last is not set in the JDBC URL.

Add ?charset=iso_1 last in the JDBC URL as shown below:

jdbc:sybase:Tds:<HOST>:<PORT>/?charset=iso_1
SELECT permission denied on object
 <Object Name>, database master, 
owner dbo

The user who is currently monitoring the target does not have the required role and permissions.

Check whether the user has all the required roles and permissions as described in the Configuring Sybase Adaptive Server for Monitoring section of the installation guide. If not, grant the required permissions.

<TABLE NAME> not found. 
Specify owner.objectname or use sp_help
 to check whether the object exists 
(sp_help may produce lots of output)

The <TABLENAME> is not available on the target side. If <TABLENAME> is either master..mon<*> or mon<*>, then the required MDA table is not available.

Check whether the MDA tables are installed. If they are not, install them.

For Segment Usage metric, there is an error when querying: Server user id <USERID> is not a valid user in database '<DATABASE>'

The monitoring user does not have permission on all databases in Sybase ASE target.

Provide permission to query SYSSEGMENTS table to monitoring user or else create guest user account in each database.

ASEServerName;Failed to connect

Incorrect JDBC URL

Specify the JDBC URL to start with jdbc:sybase:Tds:

Can't resolve a non-optional query descriptor property [ServerName] (ServerName)

The ?charset=iso_1 element is not set in the JDBC URL.

Add ?charset=iso_1 last in the JDBC URL as shown below:

jdbc:sybase:Tds:<HOST>:<PORT>/?charset=iso_1

Database reports a metric collection error when it goes down on IBM AIX with this error: Failed to run ps command

There is an OS specific bug in the code which collects the Response metric

Open the response.pl file:

$AGENT_BASE_DIR/plugins/oracle.em.ssad.agent.plugin_<version>/scripts/emx/sybase_ase/response.pl

Replace this code:

if ($? != 0) {
   raise_error_and_exit(“Failed to run ps command”, 9);
}

with this code:

if ($? != 0 && $? != 256) {
   raise_error_and_exit(“Failed to run ps command”, 9);
}

See Doc ID 1493842.1 in My Oracle Support for details:

https://suppport.oracle.com

4.2 Configuration Parameter Errors

You may encounter the following error when performing a query:

Collection of monitoring data for table '<TABLE NAME>' requires that the '<PARAMETER(S)>' configuration option(s) be enabled. To set the necessary configuration, contact a user who has the System Administrator (SA) role

Possible Cause— The <PARAMETER> shown in the error message has not been enabled.

Action— Enable the <PARAMETER> that is shown in the error message. To understand how configuration parameters can be enabled, refer to the Prerequisites section of the installation guide.

Table 4-2 shows the configuration parameters to be enabled for each metric.

Table 4-2 Configuration Parameters to be Enabled for Metrics

Metric Configuration Parameter

Adaptive Server Engines Statistics

enable monitoring

Data Caches statistics

enable monitoring

Procedure Cache statistics

enable monitoring

Open Databases statistics

enable monitoring

Server-wide worker threads statistics

enable monitoring

Network I/O Statistics

enable monitoring

Most recent error messages

enable monitoring, errorlog pipe max messages, errorlog pipe active

Locks Information

enable monitoring

Deadlock Statistics

enable monitoring, deadlock pipe max messages, and deadlock pipe active

Cache Pools Statistics

enable monitoring

Open Objects Statistics

enable monitoring, per object statistics active

Device Data and IO log statistics

enable monitoring

Devices Statistics

enable monitoring

Waiting Events Statistics

enable monitoring, wait event timing

Process Statistics

enable monitoring, wait event timing

Processes activity statistics

enable monitoring, wait event timing, per object statistics active

Processes Network IO activity

enable monitoring

Process Objects Information

enable monitoring, per object statistics active

Waiting Process Statistics

enable monitoring, wait event timing, process wait events

Currently Executing Queries

enable monitoring, wait event timing, per object statistics active, statement statistics active

Currently Executing SQL Text Information

enable monitoring, max SQL text monitored, SQL batch capture

Most recently executed statement statistics

enable monitoring, wait event timing, per object statistics active, statement pipe max messages, statement statistics active

Recently (currently being) executed SQL Text

enable monitoring, max SQL text monitored, SQL batch capture, SQL text pipe max messages, SQL text pipe active


4.3 Report Element Errors

In some cases, you may encounter a report element showing No Data Found or No Rows Returned.

Possible Cause: The underlying metric data has not been collected or the data has not been rolled up into hourly views.

Action: For the report element (chart or table) that shows this message, first identify the dependent metric and then check whether metric data has been collected for it.

The following shows the report elements and their dependent metrics. Using this table, identify the dependent metric. Once that is done, go to the All Metrics page of the target in Enterprise Manager Cloud Control, and check whether metric data has been collected for that dependent metric. If data has not been collected yet, then check the collection frequency and wait until the collection happens.

Table 4-3 shows the report elements and their dependent metrics.

Table 4-3 Report Elements and Dependent Metrics

Report Name Report Element Dependent Metrics

Sybase ASE Performance Statistics

CPU Utilization

Adaptive Server Statistics

IO Utilization

Adaptive Server Statistics

ASE State Summary

Adaptive Server State

ASE State Summary...

Adaptive Server State

Sybase ASE Engines Statistics

System CPU (by all Engine's) Utilization

Adaptive Server Engines Statistics

User CPU (by all Engine's) Utilization

Adaptive Server Engines Statistics

Top 10 Engines by System CPU Utilization

Adaptive Server Engines Statistics

Top 10 Engines by User CPU Utilization

Adaptive Server Engines Statistics

Sybase ASE Databases Space Statistics

Top 5 Databases by Data Space Utilization

Database Instances

Top 5 Databases by Log Space Utilization

Database Instances

Top 10 Databases by Data Space Utilization

Database Instances

Top 10 Databases by Log Space Utilization

Database Instances

Databases Backup Related Summary

Open Databases statistics

Sybase ASE Device IO Statistics

User Data Devices IO Operations Vs Waiting time

Device Data and IO log statistics

User Log Devices IO Operations Vs Waiting Time

Device Data and IO log statistics

User Data Devices IO Summary

Device Data and IO log statistics

User Log Devices IO Summary

Device Data and IO log statistics

Tempdb Data Devices IO Operations Vs Waiting Time

Device Data and IO log statistics

Tempdb Log Devices IO Operations Vs Waiting Time

Device Data and IO log statistics

Tempdb Data Devices IO Summary

Device Data and IO log statistics

Tempdb Log Devices IO Summary

Device Data and IO log statistics

Device Reads Rate Vs Writes Rate Vs APF Reads Rate

Devices Statistics

Devices Semaphore Requests Rate Vs Waits Rate Device IO Operations Summary

Devices Statistics

Sybase ASE Data Cache Statistics

Data Cache Hit Rate History

Data Caches statistics

Data Cache Hit Rates Summary

Data Caches statistics

Data Cache Memory Usage

Cached Objects Statistics

Cached Object Accesses by Processes

Cached Objects Statistics

Top 10 Big Objects in Data Cache

Cached Objects Statistics

Top 10 Popular Objects in Data Cache

Cached Objects Statistics

Sybase ASE Procedure Cache Statistics

Procedure Cache Hit Rate History

Procedure Cache statistics

Procedure Cache Memory Usage History

Procedure Cache statistics

Top 10 Objects in Procedure Cache by Memory Usage

Cached Procedures Statistics

Sybase ASE Network IO Monitoring Report

Incoming Traffic History

Network I/O Statistics

Outgoing Traffic History

Network I/O Statistics

Incoming Packet Traffic History

Network I/O Statistics

Outgoing Packet Traffic History

Network I/O Statistics

Sybase ASE Database Log Statistics

Overall Append Log Requests

Open Databases statistics

Rate Vs Waits Rate

Open Databases statistics

Tempdb Append Log Requests Rate Vs Waits Rate

Open Databases statistics

Overall Append Log Waits Percentage

Open Databases statistics

Tempdb Append Log Waits Percentage

Open Databases statistics

Databases Log Related Summary

Open Databases statistics

Sybase ASE User Statistics

Attempted Logins History

Adaptive Server Statistics

Top 5 User SQL Statistics Summary

Recently (currently being) executed SQL Text

Top 3 Users by CPU Time

Processes activity statistics

Top 3 Users by DiskIO

Processes activity statistics

Top 3 Users by CPU Time - Summary

Processes activity statistics

Top 3 Users by DiskIO Time - Summary

Processes activity statistics

Top 3 Users by Incoming Network Traffic

Processes Network IO activity

Top 3 Users by Outgoing Network Traffic

Processes Network IO activity

Top 3 Users by Incoming Network Traffic - Summary

Processes Network IO activity

Top 3 Users by Outgoing Network Traffic - Summary

Processes Network IO activity

Sybase ASE Process Statistics

Top 10 Processes by CPU Time

Processes activity statistics

Top 10 Processes by Waiting Time

Processes activity statistics

Top 10 Processes by Memory Usage

Processes activity statistics

Top 10 Processes by User Log Cache(ULC) Writes Top 10 Processes by Transactions Rate

Processes activity statistics

Top 10 Processes by DiskIO Rate

Processes activity statistics

Top 10 Processes by Incoming Network Traffic

Processes Network IO activity

Top 10 Processes by Outgoing Network Traffic

Processes Network IO activity

Sybase ASE SQL Statistics

Top 3 CPU Intensive SQL Commands

Most recently executed statement statistics, Recently (currently being) executed SQL Text

Top 3 Disco Intensive SQL Commands

Most recently executed statement statistics, Recently (currently being) executed SQL Text

Top 3 Memory Intensive SQL Commands

Most recently executed statement statistics, Recently (currently being) executed SQL Text

Top 3 Long Waited SQL Commands

Most recently executed statement statistics, Recently (currently being) executed SQL Text

Sybase ASE Open Objects Statistics

Top 5 Hot Objects by Logical Reads

Open Objects Statistics

Top 5 Hot Objects by Physical Reads

Open Objects Statistics

Top 5 Hot Objects by APF Reads

Open Objects Statistics

Top 5 Hot Objects by APF Reads

Open Objects Statistics

Top 5 Hot Objects by Physical Writes

Open Objects Statistics

Sybase ASE Deadlock Statistics

Top 10 Processes by Lock Wait Time

Locks Information

Deadlock Detail Table

Deadlock Statistics

Sybase ASE Worker Threads Statistics

Attempted Parallel Queries History

Server-wide worker threads statistics

Altered Plans History

Server-wide worker threads statistics

Worker Threads Summary

Server-wide worker threads statistics

Sybase ASE Error Statistics

Errors Production Rate (per hr)

Most recent error messages

Recent Error Messages Summary

Most recent error messages

Recent Error Messages with Severity 10 to 16

Most recent error messages

Recent Error Messages with Severity 17 to 18

Most recent error messages

Recent Error Messages with Severity 19 to 26

Most recent error messages

Sybase ASE Configuration

Sybase ASE Version

Configuration metric with the same name.

System Listeners

Configuration metric with the same name.

Information about Databases

Configuration metric with the same name.

Installed Scripts

Configuration metric with the same name.

Charsets Information

Configuration metric with the same name.

Backup/Recovery Configuration Parameters

Configuration metric with the same name.

Cache Manager Configuration Parameters

Configuration metric with the same name.

Component Integration Services Configuration Parameters

Configuration metric with the same name.

Configuration Options Configuration Parameters

Configuration metric with the same name.

DTM Administration Configuration Parameters

Configuration metric with the same name.

Diagnostics Configuration

Configuration metric with the same name.

Disk I/O Configuration Parameters

Configuration metric with the same name.

Error Log Configuration Parameters

Configuration metric with the same name.

Extended Stored Procedure Configuration Parameters

Configuration metric with the same name.

General Information Configuration Parameters

Configuration metric with the same name.

Java Services Configuration Parameters

Configuration metric with the same name.

Languages Configuration Parameters

Configuration metric with the same name.

Lock Manager Configuration Parameters

Configuration metric with the same name.

Memory Use Configuration Parameters

Configuration metric with the same name.

Monitoring Configuration Parameters

Configuration metric with the same name.

Network Communication Configuration Parameters

Configuration metric with the same name.

O/S Resources Configuration Parameters

Configuration metric with the same name.

Physical Memory Configuration Parameters

Configuration metric with the same name.

Physical Resources Configuration Parameters

Configuration metric with the same name.

Processors Configuration Parameters

Configuration metric with the same name.

Rep Agent Thread Administration Configuration Parameters

Configuration metric with the same name.

Security Related Configuration Parameters

Configuration metric with the same name.

SQL Server Administration Configuration Parameters

Configuration metric with the same name.

Unicode Configuration Parameters

Configuration metric with the same name.

User Environment Configuration Parameters

Configuration metric with the same name.


4.4 Support References for Sybase ASE Plug-in

The following support documents are available in My Oracle Support:

https://support.oracle.com
  • Doc ID 1536823.1: Unable to Add Target OEM Plug-in Sybase Adaptiver with error Server Can't resolve a non-optional query descriptor property [STDINUSERNAME] (USERNAME)

  • Doc ID 1493842.1: When a Sybase database goes down, the status is not reported, instead a metric error is reported.

  • Doc ID 1487187.1: Sybase discovery fails with ASEServerName;Failed to connect