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.

Editing Sybase Central Password Field [CR #625254]

In Sybase Central, the password field cannot be edited on the Connection Parameters step in the Create Database Wizard, unless password is the first field edited.

Workaround:
  • Set the LC_ALL environment variable in the scjview script to a value other than LC_ALL=C (recommended), or

  • Click Back or Next on the Connection Parameters screen.

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.

Starting Sybase Central Online Help on Linux on POWER [CR #390320]

When you use the Help button from a Sybase Central wizard or utility on Linux on POWER, the loading image displays the message “Loading online help,” but remains open without starting help. If the image displays in a window with a Close icon (for example, in an Exceed for Windows display), close it manually. If there is no icon, use Alt+F4 (for example, on Solaris CDE display).

Once initialized, the help system works correctly and may subsequently be invoked from wizards or utilities without problems.