This chapter provides troubleshooting scenarios related to Sybase Adaptive Server Enterprise (ASE) plug-in.
The following topics are provided:
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 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 |
Add 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 |
Check whether the MDA tables are installed. If they are not, install them. |
|
For Segment Usage metric, there is an error when querying: |
The monitoring user does not have permission on all databases in Sybase ASE target. |
Provide permission to query |
|
ASEServerName;Failed to connect |
Incorrect JDBC URL |
Specify the JDBC URL to start with |
|
Can't resolve a non-optional query descriptor property [ServerName] (ServerName) |
The |
Add 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 |
There is an OS specific bug in the code which collects the Response metric |
Open the $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 |
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 |
Set the SYBSQL_NODS16WIN12 |
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 |
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. |
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