Sybase Central Known Issues from Previous Versions

Descriptions of known issues and workarounds for Sybase Central from previous versions of Sybase IQ.

Create Trigger Wizard Does Not Show User Tables [CR #631447]

The Sybase Central Create Trigger Wizard does not list user tables.

Workaround: Use Interactive SQL (dbisql) to create a trigger.

Sybase IQ Plug-in Not Registered [CR #629604]

The Sybase IQ plug-in for Sybase Central may not be registered on IBM POWER7 systems running AIX 6.1. A symptom of this problem is these messages in $IQDIR15/uninstall/IQ/RegisterIQjpr.out:

ERROR! This file could not be found: jh.jar
ERROR! This file could not be found: java

Workaround:

You can correct this problem by manually executing Sybase Central and supplying the required configuration command line parameters:

Open a command prompt or xterm window.
Change to the Sybase IQ installation directory.
Source the environment shell scripts:
```
source IQ-15_2.csh
```
Change to the directory that contains Sybase Central:
```
cd $IQDIR15/shared/sybcentral600
```
Execute the registration command:
```
scjview -register $IQDIR15/java/iq.jpr
```
Run Sybase Central:
```
scjview
```

Remote Client Cannot Connect to Sybase IQ Agent [CR #563823]

When Sybase Central running on a remote client attempts to connect to the Sybase IQ Agent running on the server host, this error may be reported:

“Unable to connect to the IQ Agent on Server host
“<hostname>:<port_number>”

The root cause of this problem may be the configuration of the network, which incorrectly resolves the hostname to loopback IP address 127.0.0.1, rather than the real IP address. You can verify the source of the problem by running the command ping <hostname>, which returns an IP address. If the IP address returned is 127.0.0.1, rather than the real IP address of the host, then the network configuration is the problem.

To resolve this issue, ask your system administrator to change the network configuration, so that the hostname is resolved as the real IP address. On a UNIX system, you can edit the system file /etc/hosts, so that the hostname is resolved to the real IP address.

Creating Proxy Tables with “Selected Columns” Option [CR #559895]

Creating a proxy table in the Sybase Central wizard with the All Columns option creates the proxy table as expected. However, if you create a proxy table in the Sybase Central wizard with the Selected Columns option, even if you select all columns, the proxy table does not show the data.

Either build the proxy table with the All Columns option, or use dbisql to build the proxy table with just the selected columns that you want.

Sybase Central Operation Issues [CR #549750]

These issues with Sybase Central operations while using the Create Database Wizard and browsing for a file on remote systems are related to JRE 6.0. The workarounds are either to enter in the text field the required path name to the file, rather than selecting the file using the wizard, or to run Sybase Central on the system on which you are creating the database.

Running Sybase Central in either Windows or Linux: you cannot traverse inside a newly created directory, while browsing on a remote system
Running Sybase Central in Windows: double clicking on directories on a remote Linux system is non-responsive
Running Sybase Central in either Windows or Linux: the Create New Directory button is disabled, while browsing for files on a remote Linux system
Running Sybase Central in Linux: while navigating the C: drive on a remote Windows system, if you click the Up > Up > ... button, the listing of files for the C: drive is not correct
Running Sybase Central on all platforms: renaming a file on a remote system does not work. After you enter the new name and press Enter, there is no response and the rename operation fails without returning an error.
Running Sybase Central on all platforms: clicking and double clicking files and directories on a remote system does not work as expected. Sometimes Sybase Central navigates into the directory and sometimes it edits the directory name for rename. Similarly for files, sometimes Sybase Central selects the file and sometimes it edits the file name for rename.