Troubleshooting the Sybase ASE Plug-in

4 Troubleshooting the Sybase ASE Plug-in

This chapter provides troubleshooting scenarios related to Sybase ASE plug-inSybase Adaptive Server Enterprise (ASE) plug-in.

The following topics are provided:

General Sybase ASE Error Messages

Table 4-1 shows typical error messages, possible causes, and resolution you may encounter while working with the Sybase ASE 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); } For information, see Doc ID 1493842.1 in My Oracle Support.
Failed to Execute Job Unable to successfully execute job "Start Up Sybase ASE." Please set SYBSERVICE Environment Variable to the name of the Sybase ASE Service.	Windows requires the `SYBSERVICE` environment variable to be set to the name of the Sybase Service.	Set the `SYBSERVICE` environment variable to the name of the Sybase Service. For example: SYBSQL_NODS16WIN12

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, see 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

Sybase ASE Plug-in 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, 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
Sybase ASE Deadlock Statistics	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.
Sybase ASE Configuration (continued)	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.

Support References for Sybase ASE Plug-in

The following support documents are available in My Oracle Support:

https://support.oracle.com

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 1536823.1)
```
https://support.oracle.com/rs?type=doc&id=1536823.1
```
Sybase discovery fails with ASEServerName;Failed to connect (Doc ID 1487187.1)
```
https://support.oracle.com/rs?type=doc&id=1487187.1
```