| 737595 |
- Server error when trying to add a hash or hash-range
partition to an existing unpartitioned table – 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.
- 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.
|
| 736548 |
Behavior #1:
- Missing multiplex resource in the Perspective window. Only
the original simplex resource appears – After converting a simplex resource to a multiplex resource,
though the wizard indicates success, the new multiplex
resource does not appear in the Perspective window. Only the
original simplex resource appears. If you open the
Administration Console and click IQ server, the error
message Object detail load failed appears. No
objects for the simplex resource appear in the folders of
the Administration Console.
- 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.
Behavior #2:
- 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.
- Workaround –
- Stop and restart the SCC Server.
- Log in to SCC.
- In the Perspective Resources view, re-authenticate
the multiplex resource. Objects now appear for the
coordinator resource.
|
| 735485 |
Behavior #1:
- Workaround #1 –
- In the left pane of the Administration Console,
select .
- Select the table on which the text index is based in
the right pane and either:
- Click the arrow to the right of the name and
select Properties, or
- From the Administration Console menu bar,
select .
- In the left pane, select Text
Indexes.
- In the right pane, select the text index and click
Refresh.
Behavior #2:
- Workaround #1 –
- In the left pane of the Administration Console,
select .
- Select the text index from the right pane and
either:
- Click the arrow to the right of the name and
select Truncate Data, or
- From the Administration Console menu bar,
select .
- Workaround #2 –
- In the left pane of the Administration Console,
select .
- Select the table on which the text index is based in
the right pane and either:
- Click the arrow to the right of the name and
select Properties, or
- From the Administration Console menu bar,
select .
- In the left pane, select Text
Indexes.
- In the right pane, select the text index, and click
Truncate.
|
| 732628 |
- Some nodes in a multiplex shut down after adding a DB file
to IQ_SYSTEM_MAIN – When adding a DB file to IQ_SYSTEM_MAIN, any node in the
multiplex whose agent is not registered and authenticated
becomes stopped.
- Workaround –
- In the left pane of the Administration Console,
select .
- Select a stopped node from the right pane and either:
- Click the arrow to the right of the name and
select Register Agent,
or
- From the Administration Console menu bar,
select .
- Accept the defaults displayed and click OK.
- Select the same node from the right pane and either:
- Click the arrow to the right of the name and
select Authenticate Agent,
or
- From the Administration Console menu bar,
select .
- Type the SCC agent password and click OK.
- Select the same node from the right pane and either:
- Click the arrow to the right of the name and
select Synchronize Server,
or
- From the Administration Console menu bar,
select .
- Click Finish to start the synchronization.
- Click Close when synchronization is complete.
- Select the same node from the right pane and either:
- Click the arrow to the right of the name and
select Start Server,
or
- From the Administration Console menu bar,
select .
- Click Finish to start the server.
- Click Close when the server is successfully started.
- Repeat these steps for each stopped node in the
multiplex.
|
| 730793 |
- 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.
- Workaround – Use
interactive SQL to stop the MPX node and restart it
using the appropriate flags to bring the node online as
the coordinator. Please contact technical support for
further assistance.
|
| 729451 |
- 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
Sybase Control Center.
- Workaround –
- Grant the object-level permissions at the user,
group (15.3 and 15.4) or role (16.0) level.
- Use Interactive SQL to grant the object-level
permissions at the table level.
|
| 727450 |
- You cannot truncate data although you have
the correct permissions (TRUNCATE permission on the
materialized view) – The Truncate Data option is unavailable.
- Workaround – Use Interactive SQL to truncate.
|
| 724206 |
- User impersonation does not work – 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
- Workaround – Use Interactive SQL.
|
| 721981 |
- When you use a 64-bit version of Internet Explorer 9 to read
SCC online help,
graphics may fail to load – Each missing graphic is replaced with a red X. The problem
is most noticeable on the landing page when you first open
the online help.
- Workaround – Use an earlier or a 32-bit version of IE, or use another
browser.
|
| 721119 |
- Script execution is not logged as expected
on UNIX-like operating systems – Alert-triggered script executions are not being recorded in
SCC-3_2\log\alert-server.log as
they are supposed to be. Information about the execution
from the RemoteShell Service’s ProcessRunner is appearing in
SCC-3_2\log\agent.log, but this is
not the alert script execution code that we expect to see
logged in alert-server.log.
|
| 716431 |
- Dual control password management does not work – When the Change Password Dual Control option is enabled in a
user's login policy, an error message appears if you attempt
to change the user's password. This functionality is not
implemented in Sybase Control Center.
- Workaround – Use interactive SQL to change the user's password.
|
| 697145 |
- You cannot use incremental backups of the
Sybase Control Center
repository to recover the database –
- Workaround: –
- Shut down
SCC.
- Open this file in a text editor:
SCC-3_2/services/SccSADataserver/service-config.xml.
- Delete this line:
<set-property property="com.sybase.asa.database.options" value="-m" />
- Save the changes and start
SCC.
You can restore the repository database using
incremental backups taken after this change.
|
| 696767 |
- Cannot set timeout and row count options in
SCC Properties – Administration Console options in the
SCC Properties dialog () let you set timeout and row count thresholds
for data retrieval. These settings have no effect in
Sybase Control Center for
SAP Sybase IQ.
- Workaround – None.
|
| 686963 |
- 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 –
- Workaround – Make changes in Server Properties from individual pages and
click OK for each page.
|
| 685207 |
- The Liveness Timeout value for multiplex
secondary servers always appears as 0 seconds in the INC
Properties dialog – Even if you leave the value at the default (120 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.
- Workaround: – In the SCC
Administration Console:
- In the left pane, expand and select Multiplex
Servers.
- In the right pane, select a server and click the
drop-down arrow that appears to the right.
- Select Properties.
- 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.
|
| 676665 |
- 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.
To view or change the path to the database location: - In the Administration Console, select
IQ Servers.
- Select a server in the right pane and click the
drop-down arrow that appears next to the server’s
name.
- Select Properties.
- In the left pane of the properties dialog,
select Configuration.
|
| 676218 |
- When you modify 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 –
- Workaround: – If your changes to the Dbspace
Properties dialog do not appear in the
DB Files Properties dialog:
- Close the DB File Properties dialog.
- Click DB Files in the
left pane of the Administration Console.
- In the Folder menu, select
Refresh.
- Select the dbfile in the right pane, click the
drop-down arrow, and select
Properties.
|
| 676079 |
- In the Configuration File Editor, the
Maximum Output File Size uses kilobytes as the default.
There is no way to specify MB or GB –
- Workaround: – In the params.cfg file in the database
directory, set the value with the -zs
switch. Use K, M or G after the numerical value. For
example: -zs 4000K, -zs
240M, or -zs 30G.
|
| 676076 |
- In the Debug page of the Configuration File
Editor, the following logging levels are missing from the
Debug Level drop-down: "other," "procedures," "triggers,"
"plan," "hostvars," "replace," and "blocks" –
- Workaround: – To set the debug level to any of the missing levels, set the
-zr switch in the
params.cfg file in the database
directory. You can include more than one level. For example:
-zr procedures,triggers,plans.
|
| 670173 |
- The Database Options, Group Options, and
User Options dialogs do not allow these actions provided in
Sybase Central: Create Options, Remove Options, and Mark
Options as Permanent –
|
| 669571 |
- The Administration Console’s Execute SQL
window returns no status for successful queries that return
no results – Interactive SQL users expect a message like Execution
time: 0.01 seconds.
|
| 667667 |
- Conversion to multiplex disregarded – If
an
SAP Sybase IQ
simplex server that is registered in
Sybase Control Center is converted to a
multiplex server
using
anything other than this instance of SCC
(including
another instance of
SCC, Sybase Central, or
the command
line),
the current SCC does not
detect the conversion and continues to display the server as
simplex.
- Workaround – Reauthenticate the simplex resource so that
SCC displays it as
multiplex.
|
| 666382 |
- Prolonged authentication – Authentication can take a very long time, especially when
the resource is a multiplex. In some cases, the
authentication dialog fails to dismiss.
- Workaround – You can safely click Cancel to
dismiss the Authentication dialog at any time after you
click OK.
|
| 587717 |
- Datatips in monitoring views and the
statistics chart appear in fixed locations on the browser
screen regardless of where the chart is located. If you move
the chart on the screen, the datatips do not move with the
chart – (A datatip is a tooltip that displays the data value for a
particular spot on a graph or chart when you mouse over that
spot.) This occurs in all product module plug-ins.
- Workaround: – None. This is an Adobe Flex SDK issue.
|
| 576129 |
- Pressing F5 to refresh your browser logs
you out of Sybase Control Center – Browser refresh does not refresh data inside
Sybase Control Center, but refreshes the
loaded application or pages in the browser—in this case, the
Adobe Flash on which Sybase Control Center
is built. Consequently, pressing F5 logs you out of any
servers you are currently logged in to, including
Sybase Control Center.
- Workaround: – Do not use F5 when you are logged in to
Sybase Control Center.
|
| 560601 |
|