Known Issues for SAP Sybase IQ
5 stars based on
Adding a hash or hash-range partition to an unpartitioned table causes a server error. If you attempt to add a hash or hash-range partition to an existing unpartitioned table, an error message appears. If you unpartition a table with a hash or hash-range partition, you cannot re-add it. This behavior does not occur when adding a range partition to an existing unpartitioned table.
Missing multiplex resource in the Perspective window. Only the original simplex resource appears. After you convert a simplex resource to a multiplex resource, the wizard indicates success, but the new multiplex resource does not appear in the Perspective Resources view. If you open the Administration Console and click IQ serverthe error message Object detail load failed appears.
No objects for the simplex resource appear in the folders of the Administration Console. Missing objects for the coordinator IQ server resource in Administration Console folders after creating a new multiplex resource. After converting a simplex resource to a multiplex resource, no objects for the original simplex resource now the coordinator resource appear in the various folders in the administration console.
In the Failover Wizard, if both the coordinator node CN and designated failover node DFO are stopped, and you select a new failover node, an error message appears, and the failover fails.
This behavior occurs because the CN must be running in order to select a different failover node. Use Interactive SQL to stop the multiplex node and restart it using the appropriate flags to bring the node online as the coordinator. Contact technical support for further assistance. You cannot grant or revoke permissions on a proxy table. The functionality to grant and revoke object-level permissions on a proxy table at the table level is not currently implemented in SCC.
The functionality to configure one user to temporarily assume the roles and system privileges of another user known as impersonation is not currently implemented in SCC. Performing a task that includes database validation on a SUSE platform causes a server error. Dual control password management does not work. Dual control password management is not currently implemented in SCC. If you use Server Properties to change the server configuration, and you also make changes at Request Logging or Options pages, the server configuration process runs but does not make the additional changes.
Make changes in Server Properties from individual pages and click OK for each page. Even if you leave the value at the default seconds or set it in the Configuration Editor and restart, the INC Properties dialog displays a Liveness Timeout of 0 seconds. The value is correct on the server; only the display is wrong. If you change the database location, restart the server, and later try to change back to the previous location, the server fails to start. The failure occurs because old database files remain in place when you change to a new location.
If you change back to an old location, the server finds out-of-date files. When you modify property values in the Dbspace Properties dialog in the Administration Console, changes to dbspace properties that should propagate to the DB Files Properties dialog do not automatically do so.
There is no way to specify MB or GB. Use K, M or G after the numerical value. In the Debug page of the Configuration File Editor, the following logging levels are missing from the Debug Level drop-down: To set the debug level to any of the missing levels, set the -zr switch in the params.
You can include more than one level. Use Interactive SQL to configure the options. Reauthenticate the simplex resource so that SCC displays it as multiplex. Authentication can take a very long time, especially when the resource is a multiplex. You can safely click Cancel to dismiss the Authentication dialog at any time after you click OK. Sybase Control Center 3. Change Request Number Description Adding a hash or hash-range partition to an unpartitioned table causes a server error.
Workaround — Create a new table with a hash or hash-range partition. Migrate the data from the original table to the new table, and then drop the original table. Workaround Stop and restart the SCC server. Log in to SCC. In the Perspective Resources view, re-authenticate the simplex resource. The simplex resource becomes a functioning multiplex resource. Stop and restart the SCC server. In the Perspective Resources view, re-authenticate the multiplex resource.
Objects now appear for the coordinator resource. When you click the Refresh Now button on the properties page of a text index, the process fails with the message: Index name, object name and object owner must be either all null or all non-null.
Select the table on which the text index is based in the right pane and either: In the left pane, select Text Indexes. In the right pane, select the text index, and click Refresh. Select the text index from the right pane and either: This workaround is available for all refresh types except Snapshot.
When you click the Truncate Now button on the properties page of a text index, the process fails with the message: In the right pane, select the text index, and click Truncate. Select a stopped node from the right pane and either: Accept the defaults displayed and click OK. Select the same node from the right pane and either: Click Finish to start the synchronization. Click Close when synchronization is complete.
Click Finish to start the server. Click Close when the server is successfully started. Repeat these steps for each stopped node in the multiplex. Grant the object-level permissions at the user, group Use Interactive SQL to grant the object-level permissions at the table level. The process fails with the message: Something is wrong with the IQ Agent plug-in. Shut down Sybase Control Center.
Log on as root. Log on as the original user. In the right pane, select a server and click the drop-down arrow that appears to the right. In the left pane of the properties dialog, select Server Properties. In the right pane, enter liv in the filtering field above the Name column. This filters out all the properties except Liveness Timeout.
To view or change the path to the database location: In the left pane of the properties dialog, select Configuration. Before changing back to the old location, remove the. If they exist, also remove params. Doing so may prevent your server from starting. Close the DB File Properties dialog. In the Folder menu, select Refresh. Select the dbfile in the right pane, click the drop-down arrow, and select Properties.
Created September 23, Send feedback on this help topic to Technical Publications: Server error when refreshing a text index. Index name, object name and object owner must be either all null or all non-null Workaround 1: Server error when truncating a text index. Use dbisql to truncate. User impersonation does not work. Something is wrong with the IQ Agent plug-in Workaround: Interactive SQL users expect a message like Execution time: In some cases, the authentication dialog fails to dismiss.