SAP Replication Server的所有已知BUG列表(2)

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE,可以看到针对不同版本的CR(CR表示Change Request)简单描述信息列表。
需要注意的是:Targeted CR List for ASE列出的CR虽然绝大多数是BUG,但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息!
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

Replication Server的所有已知BUG列表(1)
Replication Server的所有已知BUG列表(2)
Replication Server的所有已知BUG列表(3)
 

CR
Number
Description
494288 ORACLE ONLY: The device status returned by

ra_helpdevice is incorrect if the device is

stored under ASM.

494320 The RMS heartbeat process has been enhanced to use the new rs_ticket version 2.0 feature if the controlling Replication Server is version 15.1 or higher. The RMS will retrieve ticket information from the rs_ticket_history table.
494368 Repserver cannot convert EUC half size kana into SJIS half size kana correctly.This issue is reproduced when the character codes of REP and IQ differ. ASE(EUCJIS) -> REP(SJIS) -> IQ(EUC_JAPAN)
494611 cannot use "use dump marker" clause with XPDL process
494701 When you run the pdb_get_columns command, incorrect

datatypes are returned for varchar(max), nvarchar(max), and varbinary(max)

datatypes.

Workaround: Ensure that the replication agents in your replication environment

are version 15.1 ESD #1.

494740 RepConnector is creating file EAServer\bin\mqjms.trc and it keeps growing and consuming disk space.
494811 ORACLE ONLY: Replication Agent processing fails

with error: "ChainedOperationException: Could not

concatenate chained operation because: Error

processing record with supplemental data whose

column index duplicates other data columns".

494819 comments for user and groups in repository are not shown if using proxy connection to repository after a logout/login -> comments are lost.

Workaround: use direct connection to repository

495027 Issuing command "create connection ... set dsi_replication_ddl 'on'" may cause the Replication Server to terminate unexpectedly.
495244 If the pdb_xlog_prefix_chars configuration

parameter is set to a value that does not

contain an underscore, Replication Agent will

create system objects with delimited names

in the primary database during initialization.

This may cause Replication Agent api commands

to fail.

495246 ORACLE ONLY: Replication Agent fails with a

NULLPointerException when attempting to read

a redo log on an AIX raw device.

495258 ORACLE ONLY: The locator is not getting updated

when the database is inactive with respect to

replicated changes, even after reading to the end

of a log file or when reading at the end of the

log.

495380 The Replication Server can terminate

unexpectedly in its attempt to log an

error message. This can occur when

specific internal resources are not

available during the process of logging

the error message.

495416 ORACLE ONLY: Command

'ra_config pdb_archive_remove, true' fails with

exception "Could not find Resource Bundle

containing index: LR_BAD_ARC_DIR_ACCESS_WRITE".

495445 UDB ONLY: pdb_setreptable command does not display

case-sensitive replicate table name correctly.

495568 create encryption key, alter encryption key, and drop encryption key are replicated by the ASE Rep Agent.
495591 After completing all tasks, 'rs_init'

may suspend and not terminate. This can

occur if 'rs_init' fails to properly

spawn a Replication Server process.

495761 MICROSOFT SQL SERVER ONLY: Replication Agent fails

during DDL replication with error "The object whose id is

XXX is not a valid object." after the Replication

Agent has been re-initialized.

495783 For the ASE messages 13925 and 13905,

the 'assign action' values should be set

to 'warn' rather than

'stop_replication'.

495834 ORACLE ONLY: Replication of a LOB value, which

immediately follows the insertion of an empty LOB

in the same location, fails with an error in

Replication Server indicating "The data row that

the writetext command is associated with is

missing."

495856 Sybase Replication Agent for Unix & Windows/15.1.0.5602 is stopping abnormally when executed by the windows service manager starting a batch file.
495884 The Replication Server may go into an

infinite loop when executing the 'resume

connection skip transaction' command

which may cause the complete consumption

of RSSD log space or ASE locks. This

can occur if the ASE and the Replication

Server are both configured with

multi-byte character sets.

496135 ORACLE ONLY: Date values that occur during

Daylight Saving Time transition are incorrectly

adjusted by one hour.

496199 When upgrading Replication Server 12.6

to Replication 15.0 or higher, an

'assign action' value is incorrectly

created for ASE error #41880 rather than

#418801.

496332 ORACLE ONLY: Configuration property

lr_ntext_byte_order is hidden, and can not be

set by user.

496471 RMS performance is severely impacted when monitoring several hundred event triggers. RMS monitoring causes the Replication Server to deny access to other processes. The RMS consumes 95-100% of the CPU. The RMS can take up to 30 minutes to start.
496499 An update to the 'rs_last_commit' table

could fail yet still allow the

associated transaction to incorrectly

commit. This can occur when the failure

is caused by insufficient ASE procedure

cache.

496624 Examples in filter connection in Replication Monitoring Services API are incorrect
496774 Large model consolidates/extracts very slowly.

Initial testing:

PDM file 22.1 MB

Proxy(TBONE server):

Consolidation: 36 minutes

Extraction: 14 minutes

No proxy(TBONE server):

Consolidation: 20 minutes

Extraction: 13 minutes

496889 "admin who_is_down" should list threads in CONNECTING status. "admin who_is_down" is intended to provide a succinct list of issues requiring user attention. A DSI EXEC thread in a persistent CONNECTING state is such an issue.
496901 MICROSOFT SQL SERVER ONLY: Date values that occur

during Daylight Saving Time transition are

incorrectly adjusted by one hour.

496903 ASE ONLY: Date values that occur during

Daylight Saving Time transition are

incorrectly adjusted by one hour.

496985 The 'get status description' command does not always return the correct descriptions. The command will sometimes return an empty results set.
496987 The result set returned by the 'get status descriptions' command contains 'NULL' rows if the ASE servers in a warm standby configuration are not being monitored by the RMS.
496990 RMA needs to find a better way to get server/RA status without requring the server to be added (thus automatically monitored) to the RMA
496991 Allow event trigger to be created at the server level instead of the component level.
497093 Please make Configurations scriptable. Add Repository Configuration Objects to the Powerdesigner Metamodel and Scripting. Currently we access the Repository Database directly to retrieve informations about the configurations.
497205 ASE ONLY:

Support ASE dump transaction command with

parameter "standby_access".

497275 ORACLE ONLY: Error "Failed to handle the DDL

operations because there is no object information

in the LogRecord" occurred against an "ALTER

PROCEDURE ... COMPILE" command issued against a

procedure whose owner is in the Replication

Agent's owner filter list.

497321 If the number of CPUs exceeds the amount

allowed by the license, the Replication

Server will incorrectly start rather

than terminate. This can occur only

when using an un-served license.

497499 ORACLE ONLY: ra_truncateusers causes

IllegalStateException if Replication

Agent is never resumed.

497530 The RMS reports the rep agent thread for the active connection in a warm standby as suspended when it is active and transactions are being replicated. This occurs when the active ASE dataserver is part of the RMS environment but the standby ASE dataserver has not been added to the RMS environment.
497537 Messages continue to to be sent out to stdout, hence the window after startup.
497693 ORACLE ONLY: pdb_setreptable all, mark fails to

mark all user tables in the primary database.

497728 Improve method to determine queue latency.
497852 *** glibc detected *** double free or corruption (!prev): 0x08a37af0 ***

*** glibc detected *** corrupted double-linked list: 0x08a0d908 ***

Theses errors occurs on RS126E6 when the standby side of replication is stopped when data is being replicated.

497929 ASE ONLY: Generated repdefs for encrypted columns

will generate a DSI 32058 error in Replication

Server with a length mismatch. The error is

similar to "The value given for

'<repdef name>.<encrypted column name>' cannot be

translated from datatype 'binary' to the required

datatype 'varbinary'. Value length is '33';

Maximum target length is '11'."

498013 ORACLE ONLY: Replication fails with a duplicate

key violation at the replicate database because

an insert rolled back at the primary database is

incorrectly replicated.

498030 An RSI internal list can be empty at the

time an SQM callback is executed.

Although this is a valid state for the

RSI internal list, the SQM callback is

unprepared for this state which can

result in a failure of the SQM.

498124 MICROSOFT SQL SERVER and UDB ONLY: A

"Replication Definition Not Found" Exception may

occur if a table is re-marked for replication

using the pdb_setreptable command. Table is marked

once with the "owner" keyword and once without the

"owner" keyword.

498130 MICROSOFT SQL SERVER ONLY: pdb_date command fails

with error "The date time string is invalid and

can not be parsed correctly."

498233 ORACLE ONLY: Replication Agent processing fails

with error: "ChainedOperationException: Could not

concatenate chained operation because: Error

processing record with supplemental data whose

column index duplicates other data columns".

498279 MICROSOFT SQL SERVER ONLY: Replication Agent fails

with a NullPointerException on a 'resume' command

when the owner of the primary database can not be

found in sys.sysusers view.

498376 ORACLE ONLY: Command pdb_setrepcol fails to find

a table when a synonym is passed as a parameter

498379 ORACLE ONLY: Non-zero generation ID field value

in session repository version locators prevents

truncation.

498424 New subscriptions cannot be validated at the standby target database in a mixed-version environment (Replication Server 12.6->Replication Server 15.1) The "send_enc_password" parameter blocks this creation if the replicated Replication Server has "net password encryption reqd" set to "0".
498467 RS may fail with a stack trace during

function replication if the primary

function name and the replicate function

name differ.

498564 ORACLE ONLY:

Two new Replication Agent commands:

"ra_deviceoffset", "ra_helpdeviceoffset"

ra_deviceoffset

Description

------------------------------------------------

Note This command is available only for Oracle.

------------------------------------------------

Changes the raw disk device read offset for a

log device recorded in the RASD.

Syntax

ra_deviceoffset device_id, device_offset

Parameters

device_id The device ID is the Oracle redo log

"Group number".

device_offset The offset of the raw device,

from which Replication Agent starts log scan.

Examples

ra_deviceoffset 1, 20

This command specifies the raw device read off-

set to the log device ID "1" as: 20.

Usage

- When ra_deviceoffset is invoked, Sybase Replica-

tion Agent records the specified raw device read

offset for the specified log device in the RASD.

- To get information about log devices stored in

the RASD, use the ra_helpdevice command.

- When ra_updatedevices is invoked, device offset

will not be reset to default value.

The default device read offset is zero.

- If ra_deviceoffset is invoked when the Sybase

Replication Agent instance is in Replicating

state, it returns an error.

- The ra_deviceoffset command is valid only

when the Sybase Replication Agent instance is

in Admin state.

See also

ra_helpdeviceoffset, ra_devicepath,

ra_helpdevice, ra_updatedevices

ra_helpdeviceoffset

Description

Note This command is available only for Oracle.

Returns device offset information about primary

database log devices from the RASD log device

repository.

Syntax

ra_helpdeviceoffset [device]

Parameters

device

The device ID of the primary database log device.

Examples

Example 1

ra_helpdeviceoffset

This command returns device offset information

about all primary database log devices recorded

in the log device repository.

Example 2

ra_helpdeviceoffset 1

This command returns information about the pri-

mary database log device ID "1" in the log

device repository

Usage

- The ra_helpdeviceoffset command returns the

following information for each primary database

log device recorded in the RASD:

Device ID - the log device ID defined by the

primary data server.

Note For Oracle, the ID is the value of the

Oracle Redo Log Group to which this file

belongs.

Database name - the name of the primary

database associated with the log device.

Device name - the logical name of the log

device defined by the primary data server.

Server device path - the path to a multi-

plexed version of the log device.

Disk device path - the path to the log

device (at the standby site).

Disk device offset - the offset from which

Sybase Replication Agent starts scan Oracle

redo log in the log device. The value of

device offset displayed is the value of

"raw_device_offset" property in the Rep-

lication agent configuration file plus the

offset value set by command "ra_deviceoffset".

Disk device status - the current status of

the server device path (ACCESSIBLE, NOT_VALID,

or OPEN).

- The disk device path is the current value

recorded in the RASD. Sybase Replication Agent

uses the disk device path recorded in its RASD

to find each log device.

- For each log device recorded in the RASD, you

can set or change the disk device path with the

ra_devicepath command and set or change the

device offset with the ra_deviceoffset command.

- If you do not specify a disk device path (using

ra_devicepath), the value recorded for the disk

device path is DEFAULT, and Sybase Replication

Agent uses the value recorded for the server

device path to find the log device.

- The disk device status is updated by the Log

Reader component each time you invoke the

ra_helpdeviceoffset command.

- If ra_helpdeviceoffset is invoked with no option,

it returns information for all log devices

recorded in the RASD log device repository.

- If ra_helpdeviceoffset is invoked with the device

option, it returns information only for the

specified log device.

- The ra_helpdevice command is valid when the

Sybase Replication Agent instance is in

either Admin or Replicating state.

See also

ra_deviceoffset, ra_helpdevice,

ra_updatedevices

498570 0C4 in LTMAPI, reason code 11 at offset 203B0
498650 In RS 15.x 'RS System Table Diagram' badly describes rs_dbsubsets system table.
499292 Configuration parameter lti_send_only_primary_keys,

when set to false, sends all before column images

regardless of columns identified in the

associated Replication Definition.

499317 ORACLE ONLY: IllegalArgumentException during log

scanning stops replication.

499543 ORACLE ONLY: After marking a table with its

synonym, no information was given back when you

try to query marked table through its synonym.

499826 MICROSOFT SQL SERVER ONLY: Replication Agent throws

a SQLException error when invoking the ra_migrate

command.

499978 ORACLE ONLY: The Replication Agent response

file processing fails with the error

"Device <+XYZ> does not exist" when the parameter

"pdb_archive_path" is set to an ASM disk group

name.

500150 ORACLE ONLY: When altering a function or

procedure to add new arguments, an

"Unsupported SQL type 1111" error occurs.

500312 After a RMS server shutdown, status information in RMPlug-in is not updated when the server is restarted. Currently, there is no way for a RMPlug-in user to tell that the RMS server has been restarted other than disconnecting and then reconnecting to RMServices. Once the user has reconnected to the RMServices icon, correct status is returned.
500356 If (1) a warm standby database is registered

with the Replication Server, (2) an MSA database

is also registered with the Replication Server

and (3) a replication definition is created for

a table in the warm standby database, then the

active connection to the warm standby database

cannot be dropped even after the replication

definition has been successfully dropped.

500368 Table replication definition and subscription does not override the exclusion from msa repdef all the time.
500445 ASE ONLY: Invalid LTL command sent to Replication

Server causes Replication Agent to go to ADMIN

state with an error similar to

"com.sybase.jdbc3.jdbc.SybSQLException: Line 1,

character 120: Incorrect syntax with the keyword

'_bf'" because a delete operation row has all

NULL data fields.

500492 The RS script 'rsupgr_ase.sql' incorrectly

populates an RSSD table with the value 'set

computed_dml on'. The correct value is 'set

dml_on_computed on'.

500890 More efficient processing of changes to cached that are identified to sts_full_cache_<tablename>
528338 Using an interfaces file with a full IPV6 hex hostname address on Unix platforms does not get parsed correctly. The result is that RMS cannot add the server, and returns an error message "Incorrect URL format. java.lang.NumberFormatException for input string." The workaround is to use the IPV6 name format for the hostname in the interfaces file.
528395 MRA ONLY:

Resume failure may happen when executing

'pdb_xlog move,force' before 'pdb_init'

and 'ra_init'.

In case of this failure, please issue

command 'pdb_init move_truncpt' to reset

truncation point and 'resume' MRA again.

528401 MICROSOFT SQL SERVER ONLY:

VirtualFileNotFoundException error is thrown after

the primary database is restored.

528438 Using a sql.ini file with a full IPV6 hex hostname address on Windows platforms does not get parsed correctly. The result is that RMS cannot add the server, and returns an error message "Incorrect URL format. java.lang.NumberFormatException for input string." The workaround is to use the IPV6 name format for the hostname in the sql.ini file.
528546 MICROSOFT SQL SERVER ONLY: A stored procedure fails

to replicate after the following sequence of steps:

1. Create a stored procedure and mark it for

replication.

2. Unmark and drop the stored procedure

3. Re-create the procedure with the same name,

mark, execute it.

528691 MICROSOFT SQL SERVER ONLY: During unmark

processing, the article's version in the RASD is

not correctly updated which may cause some

operations to be missed when Replication Agent

re-scans the log.

528695 Immediately after adding a partition, stored procedure 'rs_helppartition' incorrectly

reports 'Segments Allocated' for the new partition as '1' if the stored procedure is invoked without parameters. If the stored procedure is invoked with the new partition name as the parameter, the 'Segments Allocated' field is correctly reported as '0'.

528722 The command 'admin config, dsi_alt_writetext'

does not return the value for the

'dsi_alt_writetext' parameter.

528882 MICROSOFT SQL SERVER ONLY: Table dbo.sysdiagrams is

incorrectly marked for replication.

529131 For internal use only (new development):

Support migration to mra151.

529153 MICROSOFT SQL SERVER ONLY: Replication definition

can not be automatically created for a table with

a column containing 'sysname' datatype.

529242 ORACLE ONLY: The replication agent needs to have

the ability to read redo logs that are mirrored

and also remain replicating if it cannot connect

to ASM when attempting to refresh log devices.

529326 ASE ONLY:

pdb_setreptable can not

recognize tables with long

names having '_' and '%'.

The length of table name cannot

exceed 255.

529367 ORACLE ONLY: The Replication Agent stops

replicating due to an error. The error log

displays an error similar to:

"ChainedOperationException: Could not set header

to operation... because the chained operation

header.... is already set."

The error is caused by a failure to handle a

rollback operation applied to one log operation

of a chained operation.

529380 RepConnector: some control characters in character data can cause an error: An exception while operating the statement.

java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0

529413 ORACLE ONLY: "IndexOutOfBoundsException: Index: 6,

Size: 6" occurred with primary Oracle multi-block

undo enabled.

529738 Seems there are added additional and wrong informations in the configuration dialog. Members and version are inconsitant.
529741 Add a frozen document to a repository configuration.

Update consolidation adds the latest frozen version of the document in addition to the document version you added first as a configuration member.

529907 ASE Only:(windows)

pdb_date can not return

the correct month infomation

if OS regional is Chinese.

529921 ORACLE ONLY: NullPointerException will be

thrown when replicating nested UDD type.

529922 Some signs cannot be included in the password of RMServies.
529924 MICROSOFT SQL SERVER ONLY: Replication Agent fails

to replicate commands whose log record "Flag Bits"

are set to value 3600.

530598 ORACLE ONLY: The Replication Agent sends a

rollback record to Replication Server that

incorrectly removes the begin transaction record,

causing Replication Server to fail with error:

"#9022 DIST Cannot deliver a command since no

transaction is open".

530692 Replication Manager online help may not display when running in a Chinese environment (set LANG=zh_CN.UTF8 or zh_CN.gbk or zh_CN.gb18030 and so on).
530706 ORACLE ONLY: When altering a table to rename the

table, or to add or delete columns, a

NullPointerException occurs.

530800 If the user chooses an installation type of 'Typical', 'Full' or

'Custom' and then decides to navigate backwards to choose a different

installation type, the component subset is not properly changed to match

the installation type.

530820 Track user modifications at the model artifact attribute level

Customer's description:

Currently, PD keeps track of the changes we make at the object level and automatically places check marks next to the updates that we have initiated when consolidating with the repository. However, if there are multiple changes to the same object, PD shows all the changes and we have to select which attribute changes that we have generated. We need PD to keep track of the changes down to the attribute level and automatically check only those changes at the attribute level that we have initiated. We realize that this can be done by manually modifying the check boxes at the attribute level; however, when you have a team of 8 people working on the same model and updating the same requirements, (modifications from a review perspective, modification from a consistency perspective and modifications from a content perspective), the number of modifcations is great and the time that it takes to step through each individual attribute is extensive. Fixing this would greatly reduce people clobbering eachother's work.

531157 The 64-bit version of Redhat Enterprise Linux 5.0 is known to *not* ship

with the Linux 'libXp' package by default. If the Linux 'libXp' package

is missing, the RS 1510 GA and RMP 1510 GA 'setup' installation command

will fail and the following generic message is generated ...

The installer is unable to run in graphical mode. Try running

the installer with the -console or -silent flag.

If the 'setup' installation command is invoked with the following

parameters ...

setup -is:javaconsole -log '#' @ALL

... this additional message is generated ...

Install.product.install,

com.installshield.wizard.StandardWizardListener,

dbg,

java.lang.UnsatisfiedLinkError:

/mnt/cdrom/JVM/bin/libawt.so:

libXp.so.6:

cannot open shared object file:

No such file or directory

To resolve this issue, install the Linux 'libXp' package. This can be

done on Redhat Enterprise Linux with the following command ...

yum install libXp

531261 MICROSOFT SQL SERVER ONLY:

ra_maintid command throws NullPointerException

after Replication Agent is initialized.

531373 RA DB2 will not replicate all tables when use_repdef= Y
531385 ASE ONLY:

pdb_get_tables and pdb_get_procedures

can not recognize table/procedure

with long names having '_' and '%'.

The length of table/procedure name

cannot exceed 255.

531399 ORACLE ONLY: Replication Agent fails to

correctly calculate the rollback point for a

"rollback to save point" operation. The failure

to rollback some operations causes an eventual

'duplicate key' violation at the replicate

database.

531426 In environments that include RMP 15.1 and ASEP 15.0.2, uninstalling the RMP 15.1 may cause the jconn3.jar file to be removed. This causes the ASEP to not function correctly.
531606 The uninstall process may not remove uninstall_RMP.bin when RMP is installed in a multiple Sybase product environment. Running the uninstall_RMP.bin again will produce no results.
531960 Replication definitions are created with invalid

replicate owner when the replication definition

is created automatically and when it is created

for replicating Oracle to ASE.

A new property "rs_replicate_owner_required"

allows Replication Agent to always supply the

owner in the replicate table name when the

replication definition is generated.

rs_replicate_owner_required

Description:

Determines if the owner should always be supplied

in the replicate table name when the Replication

Agent generates replication definitions, so that

Replication Server can distinguish between

replicate tables of the same name with different

schema/owner, and different schema/owner than the

replicate maintenance user applying the command.

Default:

true

Values:

true � The owner will always be included in the

replicate table name of generated replication

definitions.

false � The owner will only be included in the

replicate table name of generated replication

definitions if the primary name is also owner

qualified.

Comments:

- When the rs_replicate_owner_required is set

to true, generated replication definitions will

always be created with the replicate owner

and table name in the "with replicate table

named" clause.

Example:

create replication definition ra$0xca61_MyTable

with primary at rao.ora10g

with primary table named 'MyTable'

with replicate table named 'MyOwner'.'MyTable'

(

"QUANTITY" rs_oracle_decimal,

"ORDER_NUMBER" varchar(200)

)

primary key( "QUANTITY","ORDER_NUMBER" )

searchable columns( "QUANTITY","ORDER_NUMBER" )

send standby all columns

replicate minimal columns

- When the rs_replicate_owner_required is set

to false, generated replication definitions will

be created with the replicate owner

and table name in the "with replicate table

named" clause only if the primary table is

owner qualified.

Example:

create replication definition ra$0xca61_MyTable

with primary at rao.ora10g

with primary table named 'MyTable'

with replicate table named 'MyTable'

(

"QUANTITY" rs_oracle_decimal,

"ORDER_NUMBER" varchar(200)

)

primary key( "QUANTITY","ORDER_NUMBER" )

searchable columns( "QUANTITY","ORDER_NUMBER" )

send standby all columns

replicate minimal columns

531968 ORACLE ONLY: Replication Agent goes to ADMIN

state with error "Error processing

record with supplemental data whose column index

duplicates other data columns."

531977 RAO: Chained Op error: Invalid state error: Op is not part of current chained op
532114 Error messages threw by ma_admin.bat

did not reflect the correct product

catagory 'Mirror Replication Agent'

but always refer to 'Replication Agent'

532153 ORACLE ONLY: Replication fails to start against

Oracle 9i because the Replication Agent does not

correctly recognize the desired archive redo log.

The error is similar to "An Archive file was not

found. Reason: Archive log file for LSN <xxx> is

not found. File <archiveLog>.

532157 Sybase Replication Agent 15.1 is a completely

new version. As a result, there are no fixed

bugs to list in this section.

532297 ORACLE ONLY: An operation that was rolled back at

the primary database can be inappropriately

replicated when a rollback occurs in the middle

of several concurrent transactions.

532509 ORACLE ONLY: Translation error occurs on

rs_oracle_datetime when a year value exceeds 4712.

532510 The Replication Server incorrectly fails to

convert an Oracle date value when the year

portion of the date value is larger than 4712.

532570 The installer for Replication Manager 15.1 does not display a warning when installing into an existing directory unless there is an existing Replication Manager installation.

Also, the installer for Replication Manager 15.1 does not display a confirmation message to create a new directory if the target installation directory does not exist.

532629 New Feature Request ... secure (encrypt) all data RepServer maintains on disks(stable device and logs)
532659 ORACLE ONLY: Re-initializing Replication Agent

with force option causes three Replication Agent

internal tables to be marked for replication and

associated replication definitions are created.

Unexpected replication definitions for rs_marker

and rs_dump are also created when

'rs_create_repdef all' command is issued.

532815 A route cannot be created from a primary

RS using RS 15.0 or higher to a

replicate RS using RS 12.6 or earlier.

This can occur when the primary RS is

upgraded from RS 12.6 or earlier to RS

15.0 or later and the site version for

the primary RS is set to 1500.

532854 Input line on the JCL(RECEIVE) is incorrect
532856 admin config command displays configuration parameter send_timestamp_to_standby to be "on" by default. This is incorrect. The default value of this parameter is "off".
532965 Due to inconsistencies with InstallShield, the uninstall process may not remove the same files on different platforms.
532994 Repository proxy crashes after reaching a connection user limit (approx 10 users).

the debug-log file shows following just before the proxy crashes

2008-06-03.15:24:30.000719 warning - SClient::OnAccept: too many clients

533063 ORACLE ONLY: Replication Agent fails to process

a DDL command that recompiles a procedure. The

error is similar to "Failed to handle the DDL

operations because there is no object

information in the LogRecord."

533069 The Online-help section labeled "Preparing to manage a replication environment" should include the item: "$SYBASE/RMP-15_x/lib/callback.jar" in the list of items to manually enter when using an external class loader.
533092 ORACLE ONLY: Operations in the pdb_skip_op list

are not skipped because the pdb_skip_op command

interface does not take into account Oracle

SUBSCN field values.

Description

This command is available only for Oracle and

Microsoft SQL Server.

Returns, adds, or removes record identifiers from

a list of records to skip in processing. The

format of the identifier is database-specific.

To support RAC, log location and truncation is

done by System Change Number (SCN) instead of

Record Address (RBA). The skip operations feature

must be familiar with SCNs and thread numbers to

truncate the skip operations list and to skip the

correct operation across multiple threads.

Syntax

pdb_skip_op [ add , identifier ]

pdb_skip_op [ remove, { identifier | all } ]

Parameters

add

Adds a specified ID to the list of

identifiers of records to skip.

remove

Removes a specified ID from the list of

identifiers to skip.

identifier

Identifies the log record to skip. The syntax

allows for either an operation locator or a

database-specific identifier.

all

Allows you to remove all IDs in the

list of identifiers to skip.

Examples

Example 1

pdb_skip_op

This command with no parameters returns a list of

the identifiers for the records you want to skip.

Example 2

pdb_skip_op add, id

This command adds an ID to the list of identifiers

you want to skip.

Example 3

pdb_skip_op remove, id

To remove an ID to the list of identifiers you

want to skip.

Example 4

pdb_skip_op remove, all

This command removes all the IDs from the list of

identifiers you want to skip.

Usage

- The pdb_skip_op command allows you to skip

problem records, thereby avoid having to

re-initialize the Replication Agent.

- Skipped records are written to the system log

as a warning message.

- The pdb_skip_op command is valid when the

Replication Agent is in Admin state.

- The format of the generic identifier

is the 64 character LTM locator representing the

operation to skip.

- The format of the database-specific identifier:

- For Microsoft SQL Server, the identifier is

Log Sequence Number (LSN) and it has the

following form:

virtualfileseqno:pageid:operationsseqno

where:

- virtualfileseqno is the virtual

log sequence number.

- pageid is the page number.

- operationsseqno is the sequence

number of the operation.

You can get the LSN using the Microsoft

SQL Server DBCC command, or you can parse

it from the locator. For example:

- LSN in decimal format: �489:112:27�

- LSN in hexadecimal format:

�0x00000489:00000112:0027�

- For Oracle, the identifier contains, SCN

(System Change Number), redo log thread, and

Record Byte Address (RBA) and it has the

following form:

wrap.base.sub, thread, lsn.blknum.blkoffset

where:

- wrap is the SCN wrap number.

- base is the SCN base number.

- sub is the SCN sub index.

- thread is the redo log thread number

that the operation occurred on.

- lsn is the RBA log sequence number.

- blknum is the RBA block number.

- blkoffset is the RBA offset into the

block where this record resides.

The values must be specified in the

pdb_skip_op command together, enclosed in

quotes, each item separated by a period.

For example:

'0000.012345678.0001', '1',

'0012.0000444.0000123'

All values can be described as a hexadecimal

by prefixing the identifier with an �0x� as

follows:

'0x000c.00001bc.000007b'

or

'0x0000.00BC614E.000A'

See also

ra_helplocator, ra_locator

533483 ORACLE ONLY: Replication Agent fails with an

error similar to "Oracle log scanner error ...

log record <> was not correctly sorted - locator

is not greater than previous log record locator".

533571 ASE ONLY: NullPointerException error occurs

during resume when the maintenance user specified

in Replication Server is not a valid user in

primary database.

533997 ORACLE ONLY: Replication Agent stops replicating

with an error similar to: "Could not concatenate

chained operation because: Error processing

record with supplemental data whose column index

duplicates other data columns".

534184 "drop logical connection" crashes repserver, infected with signal 11, if num_threads underconfigured.
534253 MICROSOFT SQL SERVER ONLY: When DDL replication is

enabled, the operation issued by the maintenance

user may not be filtered by the Replication Agent.

534312 Replication Agent generates replication definition

containing column names that are not quoted on the

"replicate if changed" clause.

534317 Replication Agent incorrectly throws an invalid

LTL command exception when the connection

to the Replication Server is lost.

534597 admin translate does not show further information about the error in the RS log
534766 Alter connection can be used to change maintenance passwords of all DSIs and is not restricted to RS using ERSSD
534773 When using the admin utility

to delete an instance, entering

'n' to cancel the delete operation

will display an incorrect message

"Successfully deleted instance

<Instance Name>."

534806 doc steps when ddl is skipped in oracle log with pdb_xlog init, move_trunc

if a customer moves the truncation point with pdb_xlog init, move_truncpt and the truncation point is moved past ddl...alter table...for example, then there are two options.

1) pdb_xlog init, force ... this will update the RASD in a wholesale manner

2) unmark and mark the individual table if the user knows they only changed one table

534845 ORACLE ONLY: An exception is thrown the second

time the Replication Agent is de-initialized with

the force option.

535076 ORACLE ONLY: Issuing the 'ra_init force' command

repeatly will display a different error message

each time.

535342 A route cannot be created from a primary

RS using RS 15.0.1 to a replicate RS

using RS 12.6. This can occur when the

primary RS is upgraded from RS 12.1.

535498 MICROSOFT SQLSERVER ONLY: NullPointerException is

thrown when resuming Replication Agent and the

'pdb_auto_create_repdefs' configuration property

is set to true.

535635 ORACLE ONLY: NoSuchElementException on resume

sends the Replication Agent to ADMIN state.

535675 ORACLE ONLY: Replication Agent may throw

an OutOfMemory exception if there are large

transactions done by the maintenance user.

535712 In an MSA environment, if a table

contains TEXT columns that allows NULL

values, these columns will be missing

from an UPDATE statement's WHERE clause

if these UPDATE statements are applied

at the primary database by an RS

maintenance user.

536128 Show the version string in ltmlog and jesmsglog.
536397 ORACLE ONLY: NullPointerException sends the

Replication Agent to ADMIN state while reading a

log record without any supplemental metadata.

The error is known to occur with an Oracle

database configurations DB_2K_CACHE_SIZE=16M and

undo_tablespace equal to a tablespace with block

size 2048.

536398 ORACLE ONLY: An IllegalStateException during

Oracle DDL command processing sends the

Replication Agent to ADMIN state.

536403 Provide command that would display the connection information of a running server.
536744 MICROSOFT SQL SERVER ONLY: Replication fails with

"No replication definition found" error after a

unmarking a table which is previously marked

with a different replicate name.

536766 Cannot add partition of all sizes and types.
536785 ORACLE ONLY: Issuing the ra_statistics command

directly after the Replication Agent is changed

to replicating state results in a

NullPointerException. The error is limited to a

RAC replication environment.

536814 ORACLE ONLY: An IndexOutOfBoundsException

occurred during initialization of a change vector

sends the Replication Agent to ADMIN state.

536887 It is not possible for a standard user (connection rights to repository and read-rights on model) to extract a model in a specific model-version which is also in a configuration.
536953 "Replication table LTMOBJECTS has ErrorCode= n" is inadequately documented.
537036 ORACLE ONLY: When replicating Oracle RAC, the

Replication Agent doesn't enter the admin state

when the quiesce command is issued.

537398 Provide a parameter to rs_subcmp that automatically tells rs_subcmp to compare trimmed values.
537412 ORACLE ONLY: Truncate table replication failure

results in replicate database constraint

violation.

537427 ORACLE ONLY: If a middle column in a table is

dropped via an alter table, a subsequent insert

on the table will fail to replicate because of

a column mismatch.

537549 Enhance the "Consolidate Multiple Documents" Window so it adds to the consolidation list all the documents modified in the workspace compared to its version in the current branch of the repository.

"Add Modified Documents in Workspace" is not reliable enough because model(s) may have already been saved locally prior to consolidation.

537607 If, for the same database replication

definition, two database subscriptions are

created using the 'with dump marker' clause, the

process of creating the second database

subscription will incorrectly not suspend the

associated DSI connection.

537629 Sybase Replication Server 15.1 is a completely

new version. As a result, there are no fixed

bugs to list in this section.

537824 In an MSA environment, Replication Server failed with DSI error 29023 when multiple replication definitions were defined on the same table.
537884 MICROSOFT SQL SERVER ONLY: ra_truncateusers command

truncate all versions of the user.

537928 ORACLE ONLY: Log truncation fails with error

message "The value '4290772992' can not be

converted into a signed integer."

537934 Quick Install: isql to the Direct Connect Service, no server, to verify connection to MS SQL
537961 MICROSOFT SQL SERVER and ORACLE ONLY:

There are new Replication Agent System Database

backup features for saving and restoring the

ASA database.

The Replication Agent System Database is now

automatically backed up when the transaction log

is re-initialized, so in the event an error

occurs while the transaction log is being

re-initialized, it can be restored to the state

it was before re-initialization started.

When the Replication Agent System Database is

backed up, the most recent database backup is now

saved in a repository backup directory with a

time-stamped name in the format

"yyyy-MM-dd_HH.mm.ss" before the ASA database is

backed up. The ASA database is still backed up in

the location specified by the "rasd_backup_dir".

In addition, the database backup files are not

automatically removed. A new feature is provided

for backup maintenance.

Example backup directory:

<INSTALL_DIR>\RAX-15_1\myRAO\repository\backup\

2008-07-24_15.41.10

Note:

The Replication Agent System Database can be

backed up manually using the "rasd_backup"

command, or will be backed up automatically

when the transaction log is re-initialized.

The "rasd_restore" command has been enhanced to

take advantage of the new backup features. In

addition to having the ability to restore from

the most recent ASA database backup, individual

backups can be selected for restore.

Command Description

rasd_restore

Description

This command is available only for Oracle and

Microsoft SQL Server.

Restores the RASD.

Syntax

rasd_restore [backup_name]

Parameters

backup_name

The name of the backup to restore from. If the

backup name is ommited, the most recent backup

is restored.

Examples

rasd_restore

This command with no parameters restores the RASD

from the most recent backup.

rasd_restore 2008-07-24_15.41.10

This command restores the RASD from the

2008-07-24_15.41.10 backup.

Usage

When rasd_restore is invoked, it starts the

restore process for the RASD.

Sybase Replication Agent looks for the most

recent RASD backup files in the directory

identified by the rasd_backup_dir configuration

parameter when no parameters are input.

Sybase Replication Agent restores from the

specified backup in the directory identified by

the rasd_backup_dir configuration parameter

a backup name is provided as a parameter

When you create a Sybase Replication Agent

instance, a RASD backup directory is created

automatically as part of the instance directory

structure. The default value of the

rasd_backup_dir parameter points to that

directory.

If you invoke rasd_restore when the Sybase

Replication Agent instance is in Replicating

state, it returns an error.

The rasd_restore command is valid only when the

Sybase Replication Agent instance is in Admin

state.

See also

rasd_backup, rasd_helpbackup, rasd_removebackup

There are two new Replication Agent commands for

managing Replication Agent System Database

backups. They are rasd_helpbackup and

rasd_removebackup.

rasd_helpbackup

Description

This command is available only for Oracle and

Microsoft SQL Server.

Displays a list of RASD backups

Syntax

rasd_helpbackup

Example:

1> rasd_helpbackup

2> go

RASD Backups

--------------------

2008-07-24_15.41.10

2008-07-28_10.08.27

2008-07-28_10.09.29

2008-07-28_10.11.31

(4 rows affected)

Usage

When rasd_helpbackup is invoked, it displays a

list of RASD backups stored in the directory

identified by the rasd_backup_dir configuration

parameter when no parameters are input.

The RASD backups are named with the date and time

at which the backup was created.

See also

rasd_backup, rasd_restore, rasd_removebackup

rasd_removebackup

Description

This command is available only for Oracle and

Microsoft SQL Server.

Removes RASD backups

Syntax

rasd_removebackup [backup_name | all]

Parameters

backup_name

The name of the backup to remove.

all

A keyword that allows you to remove all

RASD backups.

Examples:

rasd_removebackup 2008-07-24_15.41.10

This command causes the backup named

2008-07-24_15.41.10 to be removed

1> rasd_removebackup 2008-07-24_15.41.10

2> go

RASD Backups removed

--------------------

2008-07-24_15.41.10

(1 row affected)

rasd_removebackup all

This command causes all of the backups to be

removed.

1> rasd_removebackup all

2> go

RASD Backups removed

--------------------

2008-07-28_10.08.27

2008-07-28_10.09.29

2008-07-28_10.11.31

2008-07-28_10.20.55

(4 rows affected)

Usage

When rasd_removebackup is invoked, it removes a

RASD backup stored in the directory identified by

the rasd_backup_dir configuration parameter.

When rasd_removebackup is invoked with the 'all'

keyword, it removes all RASD backup stored in the

directory identified by the rasd_backup_dir

configuration parameter.

When rasd_backup is invoked, the names of all

backups removed is displayed.

The RASD backups are named with the date and time

at which the backup was created.

See also

rasd_backup, rasd_restore, rasd_helpbackup

538032 ORACLE ONLY: ra_helpuser returns STATUS and

VERSION info with NULL value.

538036 ORACLE ONLY: ra_truncatearticles can not truncate

old versioned articles.

538108 In Reference Manual, dsi_commit_check_locks_log parameter is referenced as dsi_commit_check_locks_logs
538154 Review and recommend/implement RSSD tables that would go to DOL to reduce RSSD contention between tables.
538162 ORACLE RAC ONLY: Replication performance is slow

when only one of the cluster instances is active.

538211 ORACLE ONLY: If the directory identified by the

Replication Agent pdb_archive_path configuration

parameter contains no Oracle archive logs,

Replication Agent will go to ADMIN state with an

unexpected thread death exception.

538254 ORACLE ONLY: Data is not correctly replicated for

parallel transactions with random rollback on

a table containing LOB column.

538449 Build 0411

Attribute in CDM is a special small object that is related to a data item

In all places in PD, Attribute properties inherits from Data item

properties (data type, length, comment, etc...)

Currently CMR is not showing anything for Attribute.

538540 Abend, S0C4 REASON CODE=00000011 in PACKASM$(PACKASM),offset 001710.
538640 ORACLE ONLY: ra_truncateusers can not truncate

old versioned users.

538791 MICROSOFT SQL SERVER ONLY: Issuing the ra_helpuser

command with a username that doesn't exist in the

primary database fails with error "Command

<ra_helpuser> failed - Could not list metadata

for user <XXX> because: null".

539054 Version name is missing the dot sign separating version and branch# from 10th branch.

As an example,

version 1 / branch 10/ branching version 1

is displayed 110.1 where you should read 1.10.1

539141 ORACLE ONLY: Replication Agent falls behind

in processing Oracle archive log files when

customer's batch application runs and creates

40+ gigabytes of archive log files.

539271 If a DSI connection to an Oracle database is

configured to use Dynamic SQL, the DSI

connection will fail and shutdown when

attempting to replicate the UNIVARCHAR datatype.

539307 change repserver to use the ... starting at 2 ... by default for AIX when a stable device is created on a raw partition. ASE does this by default.

stable device ... 0516-622 synclvodm: Warning, cannot write lv control block...

on AIX only when a stable device is created on a raw partition using just the minimum default syntax of...

create partition repro_part on '/dev/r11445073e' with size 60

..., then the unix commands of exportvg and importvg are attempted...this causes the following problem...

0516-622 synclvodm: Warning, cannot write lv control block data.

synclvodm: Logical volume 11445073d updated.

... and then the stable device fails to come back online and the customer had to call IBM to get it rebuilt...

539378 MICROSOFT SQL SERVER ONLY: Replication Agent

fails to replicate empty text/image values.

539588 MICROSOFT SQL SERVER ONLY: Replication Agent

upgrade fails due to Replication Agent

ra_xlog_system_ system table failing to

find dbo.ra_truncate_logs table.

539711 ORACLE ONLY: Replication Agent sends the wrong LTM

locator value to Replication Server when

replicating DDL commands and the pdb_gen_id

configuration parameter is set to a non-zero value.

539826 When the HP800 RS 15.1 GA installer is executed as the Unix user 'root',

the installer will terminate prematurely with the following message ...

Assertion failed: so->so_hard_contents, file softobj.c, line 363

sh: 11794 Abort(coredump)

540059 Request for Replication Server Manager Plugin to support partition management RCL commands.
540099 Non-applicable function strings to heterogeneous targets send empty commands or useless commits to target DBMS
540168 ORACLE ONLY: Replication Agent may throw an

exception "Invalid state encountered processing

commit operation" when applying DML commands

to Oracle system table MGMT_* if they are

for an Index Organized Table.

540234 ORACLE ONLY: Replication Agent will go into ADMIN

state with the following OracleRuntimeException

error "The operation is not the first operation

in a chain and a chained operation is not active."

replicating a table that has an after update trigger

and the update trigger contains some DML operation

that is applied to another table.

540245 When a DSI connection is configured with

the option 'dsi_alt_writetext' set to

'dcany', the Replication Server may

terminate unexpectedly. This can occur

when the Replication Server processes a

system transaction.

540359 When extracting a model into a local model which has been changed with "merge" and "open" checked, the resulting model misses the symbols on the diagram which are part of the model change. The objects themselves however are still existing.
540389 rs_init, create a new rep server, shows shutdown message instead of erroring out that the port is already in use.
540649 When an invalid value is passed to "trace all"

command, the command returns successfully.

540716 "Bind the log extract plan" help invoked through the Installer, has not been updated for DB2 V 8.
540766 ORACLE ONLY: Using an 'opaque' datatype

to create a table level replication

definition results in incorrect data

being sent to Replication Server. The

incorrect data causes the Replication

Server DSI to go down.

540891 ORACLE ONLY: Replication definition is not created

correctly for a table with no replicate columns.

540987 ORACLE ONLY: pdb_setreptable command shows

an incorrect error message when the owner

value passed to it is invalid.

540988 ORACLE ONLY: Replication Agent may throw

an OutOfMemory exception if there are large

transactions done by the maintenance user.

541223 The 'suspend connection' command

inadvertently changes the case of data server name or database name in RSSD if the

case of names specified in the command do not match the case of names in RSSD.

541240 The command 'admin stats, sqm, outbound,

<instance ID>', will fail due to an invalid

instance ID even when a valid instance ID is

provided. This is a byte-order issue that is

only observed on "little-endian" platforms.

541256 MICROSOFT SQL SERVER ONLY: Replication of a text

value which is immediately followed by an

insertion of a null text value causes a

non-null value to be replicated to the

replicate database.

541264 ORACLE ONLY: Replication Agent fails to correctly

replicate a "rollback to savepoint" operation on a

table containing a LOB column.

541284 "rasd_restore" command fails with

"Could not stop database <repository

database name>" error message.

541298 Enhancement request for new permissions that allows only to suspend/resume connection/distributor, resume connection/distributor with skip transaction, and other commands that are display only that relate to DSI/DSI EXEC and distributor (e.g. admin who )
541311 A message is needed to indicate when a tablespace is not available to decompress a log record.
541344 When setting the 'dsi_alt_writetext' parameter

to 'dcany', Replication Server will fail to

replicate LOB data that is over 32KB in size.

541435 clarify that create database repdef can only have one category of filter in repdef and that alter database repdef either adds or replaces the filter category.
541538 ORACLE ONLY: Auto replication definition

generation for a table with OBJECT type fails in

Replication Agent 15.1 using Replication Server

15.0 version.

541607 On HP-UX, disk I/O errors can occur when the

stable queue is defined on a raw device.

541646 ASE ONLY: NullPointerException error sends Mirror

Replication Agent to ADMIN status after issuing

"sp_setrepcol qaz_ddl, null, do_not_replicate"

command in ASE.

541649 ORACLE ONLY: If the maximum value

(9.9999999999999999999999999999999999999e125)

of an Oracle float datatype is inserted into a

marked table, Replication Agent will go to

ADMIN state.

541782 RepServer 12.6 ESD9 on Windows Server 2003: request for RS to run on a Windows Cluster.
541798 ORACLE ONLY: DuplicateEntryException may be

thrown randomly during replication.

541833 ORACLE ONLY: The max float value

in user-defined datatype fails

to replicate.

541909 ORACLE ONLY: A character value of a single space

is incorrectly replicated as an empty string.

541964 The installer of Replication Server 15.0.1 Japanese Edition for Linux x86 doesn't show Japanese messages correctly

on RedHat Enterprise Linux 5.0 if LANG environment variable is ja_JP.eucJP or ja_JP.UTF-8.

542047 When turning on 'use_security_services', error 15358 is raised - "Config parameter 'use_security_services' is not supported by this command or

Replication Server.".

542170 rep_as_standby is not documented clearly and consistently.
542374 ASE ONLY: NullPointer exception occurs when

user invokes pdb_setreptable command to query

a non-existing table.

542431 MICROSOFT SQL SERVER ONLY:

'check' command fails without any

error code printed on sybfilter driver

manager console.

542513 ORACLE ONLY: Resume fails after Replication Agent

restarts with primary database offline.

542517 Replication Server 15.1 on Linux does not currently support security services; requesting support for this.
542534 ORACLE ONLY: Processed Oracle archive redo log

files are removed even when

pdb_archive_remove is set to false.

542629 Type E messages showing up during create or add partition are really informational and are not due to an error.
542674 Using soft pointer to raw device does not use buffered I/O in initializing
542801 New Feature Request to add filter support to table replication definition.
542877 Trailing spaces in varchar columns are not

replicated.

542923 ORACLE ONLY: Replication Agent goes to

ADMIN state with the error: "Invalid block

id <xx, xx> specified on log device

<directory> with log sequence number

<xxx,xxx>" when trying to position the

log scanner.

543009 For HPIA64, use alternate mutex

implementation to help improve latency

and CPU utilization.

543039 MICROSOFT SQL SERVER ONLY: When there are more than

2000 tables in the primary database, executing a

pdb_setreptable command with 'all, mark' option

causes an OutofMemory exception.

543118 Replication Agent fails with an error similar to

"LTIException: Received unexpected exception

during LTI processing", but no indication of

which operation caused the problem is given.

543147 ORACLE ONLY: No error message is produced

when attempting to change configuration

pds_database_name, pds_host_name or

pds_port_number while a TNS connection

description is being used.

543190 Reproduce:

1.go to configuration

2. in the general tab, it shows 10 as default, change the max user to 1 and save it

3. go to server status tab, and click restart

after restart, the max user will show 1, but it still can be accessed by 10. only after restart the tomcat, only 1 user can login.

543297 MICROSOFT SQL SERVER ONLY: If the

pds_dac_port_number property defined in the

response file is set to a value other than

USE_DEFAULT, Replication Agent fails during

initialization with error "The port number

specified for property <pds_dac_port_number>

value <nnnn> is already in use."

543309 ORACLE ONLY: If the device loaded on

initialization is an ASM device, then trying to

set the disk mirror path to a non-ASM (i.e. file

system, raw) device fails, even though no error

is displayed.

543398 ORACLE ONLY: Replication Agent fails to verify

if the database user, defined by configuration

parameter pds_username, has CREATE SEQUENCE

privileges.

543485 When trying to rename mapping names in a model that has been consolidated and extracted using ebf 14 there seem to be orphaned objects that block the renaming process.
543522 LDAP user/group are not able to get email notification. Because we don't have an LDAP API to get the user/group email information. Will defer to 15.1 release.
543523 LDAP groups doesn't do anything in CMR. For LDAP users, we need to create a CMR local group and ass LDAP users to the local group, then assign permission to the local group.
543532 When the Replication Server attempts to

replicate an MSSQL UPDATE statement containing

the MSSQL datatype 'varchar(max)', the

Replication Server incorrectly generates an

UPDATE statement without a WHERE clause.

543558 pdb_auto_create_repdefs does not create proper datatype for column of varchar(max)
543570 Replication Server incorrectly removes trailing

spaces from 'varchar' values.

543646 Function 慐xtract Dependencies� in Dialog 慖mpact Analysis� works not as expected if the user has different rights.

Only with ADMIN Rights we can see then Dependencies from models inside Repository to our Model in the local workspace. We can see the Objects with a red ball.

If we are connected as User with no admin rights it is not possible to get the information about this dependencies. But this should be possible also for our 'Non-Admin'-Users.

543717 MICROSOFT SQL SERVER ONLY: pdb_init command with

the 'move_truncpt' option fails with a

NullPointerException when it is executed before

the ra_init command.

543728 ORACLE ONLY: When processing off-row

LOB data for two tables that are affected

by the same transaction, a NullPointerException

can occur. This exception will cause the

Replication Agent to go to ADMIN state.

543979 MICROSOFT SQL SERVER ONLY: Can not logon to

SQL Server after initializing Replication Agent

for the first time.

544093 RA MS SQL started up a new log when it was not supposed to.
544104 When DSI command batching is enabled for

non-ASE replicate databases, batch

markers may incorrectly be issued twice.

544257 MICROSOFT SQL SERVER ONLY: Replication Agent

fails to replicate the update on a column of

varchar(max) datatype correctly.

544272 ASE ONLY: The "pdb_init move_truncpt" command

moved the primary database's truncation point to

the end of the log, but the Mirror Replication

Agent internal locator is not updated.

544275 ORACLE ONLY: A DDL operation for dropping

the shadow table of a marked stored

procedure is incorrectly replicated.

544279 If you select the 'Extract after consolidation' option in the 'Consolidate Document' window, PDes only updates the local model with the contents of packages on which the connected user owns 'Write' permission at minimum.
544423 ORACLE ONLY: Replication Agent fails for a

transaction that contains both a marked stored

procedure execution and a row containing a LOB

column.

544488 After an instance whose RASD transaction

log is not under default location is

upgraded to a new version, Replication Agent

fails to start with error message "Error

while trying to register Initializing

Repository with the bean manager."

544542 ORACLE ONLY: Replication Agent fails to support

update part of attributes of a object type

544605 RS 15.0.1 ebf installation on Windows does not work well for those customers who only have the RMP Plug-in on Windows.
544610 If the command 'admin logical_status,

print_errno' is sent to the Replication Server

while the Replication Server is also in the

middle of processing the command 'switch

active', the Replication Server may terminate

unexpectedly and generate a stack trace and a

core dump.

544611 Using proxy to connect to a database without repository:

The previous version suggested user to create repository via ODBC.

544617 Using proxy PD15 for PD12 repository, we should avoid to display this message.

Get PD12 repository,

On PD15 try to connect with repository

First message

-->"The repository cannot be upgraded using proxy"

Next message "The connection failed because the repository has not yet be installed..."

544695 When the Replication Server is configured with

the 'stats_sampling' option turned on, the

Replication Server may terminate unexpectedly

and generate a stack trace and a core dump if a

replicated table name or replicated column name

approaches 255 characters in length.

544735 For repository connect dialog, click on 'OK' does nothing in the following use:

Create a repository definition, do not associate a DMBS

Run Drop repository,

On connection dialog->Click 'OK'

-->Nothing happens

544768 Extract multiple documents from repository: minimize/resize controls missing

Workaround: manually resize window using mouse

customer's description:

Extract ("check out") multiple documents from repository: Minimize/Resize controls in upper right corner are missing. Just the "X" control is present. PD Version 12 provides the Minimize/Resize controls for similar functionality.

544769 Allow comments on repository 'Lock' to be viewable.

Customer's description:

When a repository object is 'locked' and comments are placed on the object to indicate the purpose of the lock, the comments are not viewable by anyone afterwards. We believe that these comments should be viewable, and should automatically be deleted when the object is 'unlocked'.

544827 ASE ONLY: Mirror Replication Agent fails to

migrate from earlier versions of 15.0 to

lastest ESD with error "Device id (virtual page

number) and device name mismatch.

544840 MICROSOFT SQL SERVER ONLY: Values for money and

smallmoney can be incorrectly rounded during

replication.

544866 ORACLE ONLY: Table Not Found Exception will

be thrown when user invokes pdb_archive_remove

command before Replication Agent is

initialized.

544868 MICROSOFT SQL SERVER ONLY: Replication Agent

always sends data in little endian order even

if ltl_big_endian_unitext is configured to true.

544926 sp_config_rep_agent <dbname>,"send warm standby xacts" config parm is out-dated and applies to sp_reptostandby usage.
545050 Be able to lock a package even an object in the repository to prevent other users from modifying a package/object, not only the whole document.
545078 Statistics counter overflow when the stable queue grows large.
545079 ORACLE ONLY: "Invalid supplemental data format"

error occurs when Replication Agent scans

a log record that does not contain any

supplemental metadata.

545118 Better tools and messages when dealing with messages that talk about mutexes.
545249 If a partition runs out of space while

processing a large message (i.e. a DML command

for a table with many columns), adding a new

partition may cause the Distributor thread or

the DSI thread to fail with ERROR #6025 ("Block

consistency failed ...").

545254 New Feature Request ... change Repserver to include the dml statement in the exception log when 'resume distributor ..skip tran' is issued.
545263 The 'rs_init' executable for Linux incorrectly

disallows the creation of a partition on a raw

device if the specified partition size is

greater than 2GB.

545304 ASE ONLY: For ASE 12.5.4, use of the command

sp_export_qpgroup can cause Mirror RepAgent

to go to ADMIN state. This issue is addresed

by upgrading to ASE 15.0

545308 The rasd_backup command fails if run after a

rasd_restore with a message similar to "Command

<rasd_backup> failed - The database backup

failed because: Could not create directory

<[directory]/repository/backup/previous_backup>."

545457 The Replication Server incorrectly does not

recognize the entry 'LT=...' in SySAM properties

file.

545534 Trace to show whenever a row coming into the RS is tossed or fails to continue in the replication path in RS.
545544 ORACLE ONLY: Replication Agent fails to

replicate the last 10 characters of a

4,000 character column value.

545626 When an error occurs at start-up and Use_repdefs=Y, RA DB2 produces a dump.
545897 Customer would like to be able to specify, in RepServer, the maximum number of CPU to be used by RepServer process, so licensing could be based on this number of CPU instead of number of CPU on the machine (something like how it works with ASE)

Today, RepServer licensing is base on how big the machine is, the one where RS is running, but it does not mater how big (or how small) the application using RS is.

545952 id_server name change on configure replication server command is to help change all RS in an existing domain due to a changed name of the existing id server, not to help move a RS from one domain to another.
545986 Replication Agent throws a null pointer

exception when it fails to connect to

Replication Server due to a syntax error

in the connection definition.

545988 If the database name in the Replication Server

connection starts with a digit, or a non

standard character, such as "-", is present

in the data server name, Replication Agent

fails to connect to Replication Server.

545990 RAO 15.0 Error initializing change vector <####> in log record...we believe this is fixed after version...15.0.0.5517D1/B/generic/JDK 1.4.2/rax150sustain2/5517D1/VM: Sun Microsystems Inc. 1.4.2_15/OPT/Wed Sep 17 13:40:13 MDT 2008
546005 ASE ONLY: When pdb_setrepproc command fails

to mark a second procedure with the same

name but a different owner, the error

message explaining the cause is not clear.

546090 change Migration procedure to apply to all PDS.PDB...ASE, Oracle, MSSQL, IBMUDB
546137 ASE ONLY: Replication Agent fails to

mark table/procedure with specified schema.

546207 client log file was not truncated after server restart, when the truncate log file after server restart is checked.
546222 RS stacks when dropping a physical connection which has a large amount of data in a warm standby
546224 ORACLE ONLY: Replication Agent goes

to ADMIN state when trying to add

a column with default value to a

marked table that contains data.

546247 "pdb_setrepproc all, unmark, force" returns

error message that indicates dropping of

auto created function replication definition

failed.

546409 When processing TEXT/IMAGE column, DSI error #5138 is raised - "this rs_writetext command is marked as the first chunk for the column. However, there is already a previous rs_writetext command marked as the first chunk."
546490 When Replication Server password encryption is set, rs_init will fail with error message

"SA password too long. Maximum length is 30 characters." in upgrade operation.

546492 insert of single quote ("'") causes StringIndexOutOfBoundsException.
546750 Replication Server became hang because rv_negotiate/srv__act_negotiate didn't return.
546955 Release Builletin Rep15.0.1/15.1 for Sun of Japanese.The Japanese manual mistranslates the patch name of Solaris. x_recommended is a patch name.
546978 MICROSOFT SQL SERVER ONLY:

Values for money and smallmoney can be

incorrectly rounded when replicated.

547026 When the Replication Server is dropping multiple

publications, the Distributor thread may

deadlock with a DSI thread.

547072 After primary ASE is shutdown/restarted, RMS 'get heartbeat tickets' will not work until the UAF agent is also restarted.
547171 build 20081014 in firefox

reproduce:

1.goto configuration and click notification

2.in the mail template, update the content of mail title

3.click save.it will show "Property value has not changed" message, in fact , it should have been update.

the same issue will occur for the continues update in the body content of the mail template.

547246 Request to have RepConnector support database repdefs and subscriptions (MSA).
547278 When executing the command 'sysadmn hibernate

off' the Replication Server will incorrectly

disable STS caching. This will result in an

increase in RSSD queries which in turn may

negatively impact Replication Server

performance.

547374 Check in a repository a model without "store prepared diagram"

change model comment and check-in again with "store prepared diagram"

diagram is not saved in repository

it should

547421 During the upgrade process to RS 15.1 GA, the

index 'rs_key2_diskpartitions' for the RSSD

table 'rs_diskpartition' is incorrectly not

created.

547423 NPE when trying to load multi-model report objects.
547428 When display PD models, we should merge the model document and model object into a single node on the tree. Right now, we are display the document as the parent node, and the model object as the child node.
547430 we need to allow user to change the realm between local and remote. Right now, there is no way to create the same user id for local and remote.
547438 ORACLE ONLY: The configuration parameter

'truncation_type' default is incorrectly set to

'interval'.

547564 ASE ONLY: Replication Agent fails to resume

replication with error "IOException:

java.net.UnknownHostException" when the

primary database is unavailable.

547570 ORACLE ONLY: The incomplete message "The

replication environment is not configured to

allow DDL replication." is displayed if a

database level replication definition is not

configured in Replication Server.

547581 ORACLE RAC ONLY: After a request to start

replicating, an ArrayIndexOutOfBounds

exception occurs during cluster log scanner

positioning sending the Replication Agent

to ADMIN state.

547814 There are three new options to the -u parameter

in the ra_admin utility for upgrading Replication

Agent instances.

SYNTAX: ra_admin -u <upgrade_option>

PARAMETERS

-u <src_instance_dir>

Upgrade one instance of Replication Agent in

the specified source instance directory

to the product installation directory

-u <instance_name> | instance=<instance_name>

Upgrades only the specified instance of

Replication Agent in the current product

installation directory

-u all

Upgrade all instances of Replication Agent

within the current product installation

directory.

EXAMPLE:

To upgrade an individual instance in

a specified source instance directory to

the product installation directory.

ra_admin -u /opt/sybase/RAX-15_0/my_inst

To upgrade all the instances in the current

product installation.

ra_admin -u all

To upgrade a specific instance in the current

product installation directory.

ra_admin instance=my_inst

OR

ra_admin my_inst

NOTE:

- The -u <src_instance_dir> provides the

ability to upgrade an individal instance

from a previous major release to the

current release.

- The 'all' or '<inst_name>' or

'instance=<inst_name>' upgrade options

performs an upgrade of instance(s)

in the current product release. All

upgrades are performed directly on the

instance to be upgraded. The Replication

Agent instance configuration file is

backed before the upgrade for use in error

recovery, if required. If an error occurs,

the upgrade is rolled back. This option is

intended for performing upgrade of instances

between release to release in the same

major release such as a patch update.

547841 RS 15.1: Sybase Unified Agent will not start as a Windows service. Fails with error:

Could not start the Sybase Unified Agent service on Local Computer.

Error 1067: The process terminated unexpectedly.

due to incorrect registy entry.

547888 During repository database installation, we generate .gif icons for metaclasses.

But these icon files have 256 colors, so many colors are lost.

And the background of icons have the "white" color instead of transparent color.

547994 Customer would like to have "rs_subcmp" RepServer tools to be build as a 64bit application, so this tools would be able to compare huge data table.

At that time, Customer is using "rs_subcmp" RepServer tools under Linux platform, but "rs_subcmp" abort when it rich the 4GB limit of used memory on large user table.

For this, Customer would like "rs_subcmp" be able to manage comparing on huge user table.

548063 MICROSOFT SQL SERVER ONLY: In certain cases,

the 'pdb_setrepproc' command can return

an error: "Command <pdb_setrepproc>

failed - Could not list metadata for procedure

<procedure_name> because: Procedure

<procedure_name> is not in database

<database_name>."

548098 MICROSOFT SQL SERVER ONLY: pdb_setreproc command

with the <procName> return results containing dbo

qualifier in the replicate name column.

548128 ORACLE ONLY: Replication will fail after

migrating from GA version to the latest ESD with

an error like "Reposition point <locator value>

is older than start of log point <second locator

value>."

548148 Add indexes to rs_ticket_history.
548183 Interactive rs_init will core when RSSD database was previously created and create RSSD = yes
548375 ORACLE ONLY: A null pointer exception is thrown

when an invalid argument is specified

to the command "pdb_setrepproc".

548378 If a replicate table contains a TEXT/IMAGE

column that contains NULL data, rs_subcmp will repeatedly generate

Open Client Library error 16843070.

548385 Build 20081029-1500version

Steps:

Take Server Configurations->General as example

1. Delete the value in "Session timeout"

2. Click Reset button

Result:

The value does not reset to the former one, still blank.

In Configurations page, all the reset button has the same behavior

548404 EBF1

prepare a pdm model with multiple version

Reproduce:

1.click at the model and go to permission

2.click expand all, there will popup a error page as follows:

java.lang.RuntimeException: Exception while invoking expression #{compareTree.expandTree}

at com.sybase.cmr.webrepository.webapp.filter.LocaleFilter.doFilterInternal(LocaleFilter.java:112)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

at java.lang.Thread.run(Thread.java:595)

548406 EBF1

reproduce:

1.click a model and go to permission

2.delete the public group

3.add in user "a" with list permission

4.logout and login with user a

5.go to RE and and expand the tree, the postfix name of the model will list such as "examplel.pdm - v2";

548418 EBF1

To reproduce:

1>there are two head for exception page.

Attached the image.

548570 Request to support encryption of repository table columns using algorithms supported by the underlying DBMS.
548624 ORACLE ONLY: Mirror log location property

fails to initialize when creating instance

from response file without setting

initialize_instance or start_instance

to true.

548650 References to rs_configure stored procedure, have not been completely removed from the manual.
548652 Message starting with "Error gathering random seed data.." shows up at console when starting up Replication Server.
548654 "rasd_restore" command fails with

"Could not stop database <repository

database name>" error message.

548692 Implement psoibility to trace interactions beween different users / different PD applications on a Reprository and the stored Models.
548796 ORACLE ONLY: pdb_setreptable command

shows an incorrect error message when an invalid

owner string is passed in.

548819 ASE ONLY: Mirror Replication Agent may go

to ADMIN state with an OutOfMemory error in

the log during ra_init if more than 1000

tables are in primary database.

548841 Route is allowed to drop without checking for active subscriptions.
549128 ORACLE ONLY: Replication Agent fails to correctly

process a rollback operation for off-row LOB

data.

549145 EBF1

reproduce:

1.go to search after login

2.click at a model in the tree

the repository path will show the model name and its model type as postfix,such as"/example.oom", but now the tree only show the model object "example", so there is no need to show the model type "oom" any more,same in the result table and general of object in the Repository Explore.

549164 Build 20081104

Steps:

1. Deactivate a user

2. In the user list, show the deactivate user

3. Click the checkbox before the user who is deleted in step1

Result:

The Deactivate button change to enable status

549166 Build 20081104

Steps:

1. Deactivate a user named "aa"

2. Select "Show deactivated members"

3. Select the checkbox before any user in the user list

4. Click "aa", change the status to "active"

5. Click Save button

Result:

After step5, page back to the user list, and the "Deactivate" button is still enabled

549301 RMServices...delete rs_ticket_history too slow...Failed to get heartbeat tickets

when the RMServices server attempts to delete rows from the rs_ticket_history the customer noticed the delete was taking a long time and blocking a maintuser <spid> that was attempting to do inserts ... so they used ... kill <spid> ... on the delete <spid> and then when they attempted in another client session with RMServices ... get heartbeat tickets from pds.pdb to rds.rdb ... they then get the following error...and also the rs_ticket_history table then begins to grow indefinitely large in rows from then on...

C:\ocs15e12\OCS-15_0\bin>isql -SRMServices -Usa -P -w2048

1> get heartbeat tickets from pds.pdb to rds.rdb

2> go

Msg 32000, Level 20, State 0:

Server 'RmaAgent', Procedure 'get heartbeat tickets from pds.pdb to rds.rdb', Line 1:

Failed to get heartbeat tickets.

1> quit

549343 MICROSOFT SQL SERVER ONLY:

"java.lang.IndexOutOfBoundsException" error sends

Replication Agent to ADMIN state during

replication.

549366 ORACLE ONLY: If a table has off-row LOBs and

a table trunction is executed followed by a LOB

operation, Replication Agent encounters a LobObjectID

mismatch error.

549373 ORACLE ASM ONLY: Errors like 'Byte buffer

remainder is too small' and 'BufferUnderflow-

Exception' occur randomly when Replica-

tion Agent is resumed.

549418 Customer request the subcription name (column "subname" in RepServer system table "rs_subscriptions") to be enhanced up to 255 byte, like Replication Definition name could be define.

When Customer create a subscription, he would reference the RepDef name as well as its source PDS/PDB info in its name for easy reference.

Because of the column length restriction, "subname" are usually heavily abbreviated to accommodate lengthy RepDef names (which would be from lengthy table names), which can be a real pain when trying to create unique subscription names for Customer.

So if Customer were to make use of the increased table(object) and RepDef name length, he would have even more difficulty abbreviating these into 30 character subscription names.

549542 MICROSOFT SQL SERVER ONLY: ra_helparticle command

fails with an error "Could not list article

metadata because:

com.sybase.ds.mssql.entity.MSSqlSimpleArticle".

549558 Build 1107

To reproduce:

1>For showing Deployment Instance object in EAM, if it is deployed by "application_1" with no instance name, it will be shown in " " in CMR, and show "Deployment Instance" for all objects.

It should be deal with specially for the special object.

Attached the EAM.

549774 ASE ONLY: Mirror RepAgent does not verify the

value of configuration parameter

pds_interfaces_file.

549788 ORACLE ONLY: Provide separate statistics to

monitor Oracle online and archive log device read

status.

Online log statistics:

1.Average time (ms) per online log device read

2.Total online log read time (ms)

3.Current blocks per device read(online log)

Archive log statistics:

1.Average time (ms) per archive log device read

2.Total archive log read time (ms)

3.Current blocks per device read(archive log)

549859 MICROSOFT SQL SERVER ONLY: pdb_setrepproc

command with the 'all, enable' option is not

supported and should return an error message.

549908 ORACLE ONLY: The underlying tables (MLOG$_xxx)

for materialized view are incorrectly marked

during initialization with pdb_automark_tables

property setting to true.

549979 Tested and reproduced with: PD 12.5 ESD#15 and PD 15.0 ESD#1

This is an issue from UNIBANCO toptier customer.

When two users are dealing with same RQM model extracting/changing/consolidating repository, the merge of changes are not bringing all subitems as expected. Also, in PD 12.5 only, some subitem descriptions get changed.

550000 ORACLE ONLY: A supplemental data column with an

index that duplicates another data column during

operation processing stops replication.

550178 "rasd_restore" command fails when followed

by a "rasd_backup" operation.

550302 ORACLE ONLY: Truncate table replication failure

results in replicate database constraint

violation.

550354 build EBF1

To reproduce:

If repository db is SQL Server 2000, the installer can't connect it successfully.

And can't show data in web browser.

We need to support SQL Server 2000.

550822 Include documentation to bind RA DB2 DBRM as a package.
550868 Option to place trace logs in a different directory than system logs.
550897 MICROSOFT SQL SERVER ONLY: Add trace

functionality in the sybfilter driver. When an

error occurs, the error is logged to an

error file (sybfilter.err). When the trace flag

is enabled, the trace information will be logged

to a trace file(sybfilter.trc). These two files

will reside in the same directory where the

configuration file is located.

There are four level of trace info which can be

configured by users in sybfiltermgr. The default

setting is to output the error message only.

trace

Turn on or off sybfilter trace

Syntax

trace [T1] [T2] [T3] [T4] [all] [off]

Default

T4 - Log error messages

Parameters

T1 Logs driver routine entrance and

return messages

T2 Logs operation status information

T3 Logs normal message such as an

exclusive open file operations

T4 Log error messages

all Logs T1, T2, T3 and T4 level messages

off Turns off tracing

Example:

To turn on T3 trace:

trace T3

To turn on T1 and T3 trace:

trace T1 T3

To turn off trace

trace off

To display help on trace command:

help trace

551006 ORACLE ONLY: Replication fails in Replication

Server with "error ORA-00900: invalid SQL

statement" due to an attempt to replicate only

the second half of a DDL command.

551023 ORACLE ONLY: Correct Log Reader scanner statistic

description from 'Average number of checkpoints

per records read' to be 'Average number of log

records per checkpoint'.

551025 ORACLE ONLY:

Rep Agent dies with 'Invalid block id'

when log scanner tries to position.

551032 MICROSOFT SQL SERVER ONLY: Replication Agent de-initialization

and then re-initialization do not refresh the user articles

information stored in the Replication Agent System Database

repository.

551192 The 'rs_init' executable shipped with

IBMPLINUX64 RS 1510 GA incorrectly

allows the user to optionally configure

the Replication Server with an embedded

RSSD (ERSSD). The 'rs_init' executable

should disallow this option since an

ERSSD requires SQL Anywhere and SQL

Anywhere is not available on

IBMPLINUX64.

551336 ORACLE ONLY: Replication Agent does not

generate a replication definition

after re-setting the pdb_auto_create_repdefs

configuration property to 'true'.

551457 Generate RCL for subscription fails when using eRSSD.
551499 ASE ONLY: Replication Server primary connection

duplicate count increases and the replicate

connection DSI goes down with error 5147 because

parallel transactions with affected LOBs result

in the wrong locator getting sent by Replication

Agent for some operations.

551706 MICROSOFT SQL SERVER ONLY: When maintenance user

is 'sa', Replication Agent goes into ADMIN state

with UserNotFoundException error.

551788 ORACLE ONLY: Stored procedure can not be marked if

the parameter name in the stored prcoedure

contains Oracle reserved words.

551794 PowerDesigner Repository Web Browser

Expanding documents in Repository browser leads to java.lang.RuntimeException.

552175 Performance issue when Replication Server starts up and "rs_subscriptions" contains many rows
552242 ORACLE ONLY: Replication Agent will hang on a

create cluster table DDL operation.

552274 Shouldn't possible for consolidate / integrate to choose a version in a branch due

integrate only happen in the last version of a branch. As well it shouldn't be possble to unfreeze any version except the last one of a branch in the GUI

552300 Set the CNT_NO_RESET bit on for CNT_DSIE_DSQL_STMTS_IN_CACHE_C, so that the associated counter is not reset at the beginning of each observation period.
552399 The "ra_config rasd_tran_log, <new_rasd_log_path>"

command will fail with error message "The database

transaction log file move failed because: Could

not move file <src_file_location> to

<target_file_location>".

552588 All users are unable to connect to repository after upgrading from v12.1.0 EBF10 to v15 EBF1.

When the repository update script is executed outside of PowerDesigner, you unable to connect to the repository with existing users. When attempting to connect, you get the following error message:

Invalid repository user or password!

If you execute the update script within PowerDesigner, then you are able to connect to the repository.

552626 ASE ONLY: pdb_setreptable command

shows an incorrect error message when

an invalid owner string is passed in.

552670 ORACLE ONLY: A stored procedure marked for

replication that executes with error returns

corrupt error stack.

552673 ORACLE ONLY: If a stored procedure is marked for

replication and the stored procedure contains a

truncate table command, both the truncate

command and stored procedure execution are

replicated.

552674 ORACLE ONLY: If a stored procedure that is marked

for replication fails at the primary database,

no message is logged indicating the procedure

will still be executed at the replicate database.

552784 Output from logtrace=yes goes to SYSPRINT.
552793 ORACLE ONLY: A DDL command executed within

a stored procedure that is not marked for

replication is ignored by Replication Agent.

552798 ORACLE ONLY: Attempting to replicate a stored

procedure that has an OUTPUT parameter results in

an error in the Replication Server DSI thread

similar to: PLS-00306: wrong number or types of

arguments in call to 'MY_PROC'.

552804 RepSever can't uninstall products after install EBF.
552820 uninstaller of Sybase does not delete all files. Moreover, uninstaller is not removed from a control panel, either. This is specification.
552868 Provide option to save repository creation/update script from within the 'generation script' window.
552894 LTMCFG requires RSSD parameters when Use_repdefs = N
553088 In a repository, if you right click on a folder and select Add, the model is not added to the folder if you select the model currently in the Browser. The model will be added to the root of the repository

To reproduce:

1) create and save any model (test.pdm)

2) create a folder in the repository (folder_1)

3) right-click on folder_1 and select Add

4) browse to and select test.pdm

5) click open

Note: You are prompted with dialog asking if you want to use the model in the current workspace.

6) Click NO to the dialog

NOTE: Test.pdm will be checked-in under folder_1

7) cancel

8) repeat steps 3, 4, 5 but this time click YES to the dialog

NOTE: Test.pdm will be checked-in under the root of the repository.

This behavior exists in v9.5, 10.1.0, 11.1.0, 12.5., and 15.0

553104 RS 15.x crashes when dbisql is used against it.
553173 ASE ONLY: Instance fails to start up

when pds_interfaces_file is set to

<not_configured> in the instance

configuration file.

553578 Synchronization issue between SQM write thread and ROUTE thread. RS fails due to a synchronization problem between SQM wirte thread and ROUTE thread, SQM thread uses a shared variable without locks and it would be set to NULL in the ROUTE thread when SQM thread was using it. Accessing a NULL value lead to the failure.
553588 rs_ticket command fails with "The date time

string is invalid." error message.

553601 ASE ONLY: pdb_auto_create_repdefs create repdefs

for a table if the table is created before

executing 'ra_init'.

553628 When adding a raw device partition, there is confusing message like 'asynchronous I/O request completed with an error' in Replication Server log.
553676 With the new CMR there must be an API (which should be documented) to be able to read informations from the Repsoitory via Java or .Net
553784 Dynamic SQL optimizaton, if DSQL is turned on language commands are not packed assuming DSQL will be successful. If the DSQL statements fail only then are the language cmds generated. Similarly for generation of prepared statements, the are only generated when required.
553785 When minimal columns is turned on, columns not changed are not available in the DSI. DSQL will not be used and the counter DSINoDsqlMissingCols shows the number of times DSQL is skipped. In Repserver 15.3, RS will allow multiple DSQL statements corresponding to the same table, and the number of DSQL statements depend on the update set clause pattern.
553933 ORACLE ONLY: Underlying tables for a materialized

view are incorrectly replicated.

554036 Replicatoin Server should terminate when RSSD becomes inaccessible
554071 Tested and reproduced with PD 12.5 EBF#3 and SQL Server 2005 as repository.

OS: Windows 2003 SP2

This is an issue from UNIBANCO customer.

After extrating a model from repository, picture that was inserted via "import image" is not displayed inside model. Only picture's area is displayed. If customer uses copy/paste when inserting pictures, then issue doesn't occur.

554216 When using Replication Agent version 15.1 ESD #2

or earlier, and communicating with Replication

Server release 15.2 or later, the Replication

Agent query against the Replication Server System

Database to obtain replication definition

information fails to return the appropriate rows.

This failure causes the Replication Agent to fail

with a 'replication definition not found' error.

554483 ORACLE ONLY: Marked stored procedures will be

unmarked and re-marked during migration.

Failure of re-marking stored procedures will

be logged as error in Replication Agent error

log, and ra_migrate just return success.

Customers must review the error log and may be

required to do manual re-marking.

A list of procedures which need to be manually

re-marked will be provided in the error log.

Two limitations during migration:

1. Marked stored procedures that are executed in

the primary database during migration will not be

replicated.

2. DDL operations done in primary database

between last truncation point and the end of

migration will not be replicated because DDL

replication will be disabled internally by

Replication Agent during migration.

554637 ORACLE ONLY: Replication Agent fail to replicate

execution of procedure if procedure is altered

to add a new parameter.

554669 Convert all data types with type value >= CS_USER_TYPE to the types that Sybase Open Server can understand.
554762 Customer have define lot of Replication Definition, about 17.000 row in "rs_objects".

This cause him awful performance when calling "rs_helprep".

Looking at "rs_helprep" RS system store proc source code, it create and populate a temporary table before processing user request.

Steps to create and populate this temporary table are:

1- create the temporary table

2- populate the temporary table using "insert ... select ..." statement

3- update data in temporary table, one row by one row.

Third steps is the one that may cause poor performance (due to SQL code doing a loop and simulating what could be done using cursors).

The INSERT statement into temporary table "#rs_repinfo" could be improved in order to avoid doing step 3.

Suggesting change:

Original RS 15.1 "INSERT" statement:

---------------------

/* Initialize #rs_repinfo from rs_databases, rs_objects, rs_sites */

insert into #rs_repinfo (objid, objname, prs, prds, prdb, phys_tablename,

phys_objowner, deliver_as_name, repl_objowner, crdate, dbid)

select ro.objid, ro.objname, rs.name, rd.dsname, rd.dbname,

ro.phys_tablename, ro.phys_objowner, ro.deliver_as_name,

ro.repl_objowner, ro.crdate, rd.dbid

from rs_objects ro, rs_sites rs, rs_databases rd

where ro.prsid = rs.id and

rd.dbid = ro.dbid and

ro.objname not like "rs_in%" and

ro.objname not like "rs_drp%"

---------------------

Could be updated as following:

------------------------------

/* Initialize #rs_repinfo from rs_databases, rs_objects, rs_sites */

insert into #rs_repinfo (objid, objname, prs, prds, prdb, phys_tablename,

phys_objowner, deliver_as_name, repl_objowner, crdate, dbid,

/* adding following column */

type, phys_owner_tab, repl_owner_tab)

select ro.objid, ro.objname, rs.name, rd.dsname, rd.dbname,

ro.phys_tablename, ro.phys_objowner, ro.deliver_as_name,

ro.repl_objowner, ro.crdate, rd.dbid,

/* adding following value to populate all columns at same time */

case ro.objtype

when 'R' then 'Tbl'

when 'F' then 'Func'

else 'Sys'

end,

case ro.phys_objowner

when ' ' then ro.phys_tablename

else substring (ro.phys_objowner + '.' + ro.phys_tablename, 1, 255)

end,

case ro.repl_objowner

when ' ' then ro.deliver_as_name

else substring (ro.repl_objowner + '.' + ro.deliver_as_name, 1, 255)

end

from rs_objects ro, rs_sites rs, rs_databases rd

where ro.prsid = rs.id and

rd.dbid = ro.dbid and

ro.objname not like "rs_in%" and

ro.objname not like "rs_drp%" and

/* adding following where clause to select, at the source, only wanted RepDef */

ro.objname like isnull (@object, '%') + '%'

------------------------------

So next block statement could be removed:

---------------------

/* remove following block statement, not needed any more due to above change in population #rs_repinfo table */

/*

select @cur_rep = min(objid) from #rs_repinfo

while @cur_rep != NULL

begin

-- get the type from rs_objects

select @temp = objtype,

@powner = phys_objowner, @ptable = phys_tablename,

@rowner = repl_objowner, @rtable = deliver_as_name

from rs_objects

where objid = @cur_rep

if (@temp = 'R')

select @type = "Tbl"

else if (@temp = 'F')

select @type = "Func"

if (@powner != " ")

select @ptable = substring(@powner+'.'+@ptable, 1, 255)

if (@rowner != " ")

select @rtable = substring(@rowner+'.'+@rtable, 1, 255)

update #rs_repinfo

set type = @type,

phys_owner_tab = @ptable,

repl_owner_tab = @rtable

where objid = @cur_rep

-- get the next entry

select @cur_rep = min(objid)

from #rs_repinfo

where objid > @cur_rep

end

*/

---------------------

This performance improvement request is also valid for RS 12.6 / RS 15.0x

554867 User id on the STATUS and SHOWRBA for Oldest Open Transaction can be inconsistent.
554905 When authenticating an unsupported Replication Server, a null pointer exception is occurring.
554912 cs_ctx_alloc() when starting up RA DB2 15.0 ESD #2
554987 Include timezone information in rs_lastcommit
555039 Stacktrace Signal 11. Thread USER(sa). Cooincident with Error 60031 Sync Element NULL does not exist in the dynamic element list.
555277 Error 2056 and Stop_on_error = Y does not stop Rep Agent.
555566 RMPlugin must use SSL with RS, RSSD, eRSSD, and connection targets
555580 ORACLE ONLY: Replication Agent goes to ADMIN state

with error "OracleRuntimeException:

Off-row LOB leaf update contains unexpected

values".

555631 UDB ONLY: Replication fails when Replication

Agent is running on HP Itanium and connecting to

a UDB server on a platform that has a different

endian architecture.

555930 RepServer fail to write new messages when its errorlog size reach 2GB. (no new messages reported in RS errorlog)

If RepServer is shut down, following error are reported on the console (session where RepServer is started):

-----------------

F. 2008/12/31 02:11:39. FATAL ERROR #1023 USER(sa) - r/errlog.c(309)

Received error 'File too large' while writing 'Shutting down.' to the error log.

E. 2008/12/31 02:11:39. ERROR #1033 USER(sa) - r/errlog.c(419)

Unable to log an error.

F. 2008/12/31 02:11:39. FATAL ERROR #1033 USER(sa) - r/errout.c(564)

Unable to log an error.

I. 2008/12/31 02:11:39. Shutting down.

F. 2008/12/31 02:11:39. FATAL ERROR #1033 USER(sa) - r/errout.c(564)

Unable to log an error.

F. 2008/12/31 02:11:39. FATAL ERROR #1023 USER(sa) - r/errlog.c(309)

Received error 'File too large' while writing '

T. 2008/12/31 02:11:39. (17): ' to the error log.

T. 2008/12/31 02:11:39. (17): F. 2008/12/31 02:11:39. FATAL ERROR #1023 USER(sa) - r/errlog.c(309)

Received error 'File too large' while writing 'Exiting due to a fatal error' to the error log.

Exiting due to a fatal error

F. 2008/12/31 02:11:39. FATAL ERROR #1023 USER(sa) - r/errlog.c(309)

Received error 'File too large' while writing '' to the error log.

-----------------

RepServer also fail to start when its errorlog size is greater than 2GB:

- console output:

-----------------

F. 2008/12/31 01:22:50. FATAL ERROR #1024 GLOBAL RS(GLOBAL RS) - r/errlog.c(114)

Failed to open log file '/remote/cases/11497000s/11497724/RS126_SUNBEAM.log' due to file error 'Value too large for defined data type'.

F. 2008/12/31 01:22:50. FATAL ERROR #1025 GLOBAL RS(GLOBAL RS) - r/errapp.c(376)

Logging failed because the log is not open.

F. 2008/12/31 01:22:50. FATAL ERROR #18028 GLOBAL RS(GLOBAL RS) - servmain.c(334)

Initialization failed. Server is shutting down.

F. 2008/12/31 01:22:50. FATAL ERROR #1033 GLOBAL RS(GLOBAL RS) - r/errout.c(564)

Unable to log an error.

F. 2008/12/31 01:22:50. FATAL ERROR #18028 GLOBAL RS(GLOBAL RS) - servmain.c(291)

Initialization failed. Server is shutting down.

F. 2008/12/31 01:22:50. FATAL ERROR #1033 GLOBAL RS(GLOBAL RS) - r/errout.c(564)

Unable to log an error.

T. 2008/12/31 01:22:50. (-1): Exiting due to a fatal error

-----------------

This works fine using RepServer 15.x (tested on RS 15.0.1)

555960 Replication Agent needs to show in the JES log at start up tables with replication errors.
555962 Replication Agent is calculating the minimum length of a table row that contains long varchars incorrectly.
555984 ORACLE ONLY: Cloning an Oracle database that uses

ASM for storage management can result in multiple

database entries in ASM causing the Replication

Agent to go to ADMIN state with the error: "More

than one row returned for ASMAlias for database

name".

556153 When there is white space such as a carriage return (\n) or tab (\t) in a source text column, RepConnector generates the literal representation "\n" or "\t" in the XML stream.
556171 Add Weblogic 10.3 as a supported application server for CMR.
556185 RS 15.2 DSI bulk option fails when converting from money type to numeric type. Replication Server will report a DSI error #1027 'blk_rowxfer(): blk layer: internal BLK-Library error: Failed in conversion routine ..."
556251 ORACLE ONLY: The underlying table for

a materialized view is not filtered

out correctly by Replication Agent

when all tables are marked for

replication.

556327 In a replication environment with a mixed version route and with SSL enabled on all connection, Replication Server may receive a TDS state machine error raised by Open Server function ct_send(). This error is due to a mixed version problem in OCS with partial updated support.
556356 Incorrect option in bi-directional MSA command
556404 MICROSOFT SQL SERVER ONLY: If user sets the

RACFGFilePath as a user variable instead of a

system variable, Sybfilter manager will throw an

error "could not connect to filter: 0x80070002".

556939 After Customer applying ESD#1 over RepServer 15.1, "Group" level and "Other" level permissions are removed from Sybase RepServer 15.1 distribution, in "REP-15_1" sub-directory:

rep1510:

< drwxr-xr-x 15 ylacramp sybase 512 Jan 16 11:43 REP-15_1

---

> drwx------ 15 ylacramp sybase 512 Jan 16 11:43 REP-15_1

rep1510/REP-15_1:

< drwxr-xr-x 2 ylacramp sybase 512 Jan 16 11:42 bin

< drwxr-xr-x 2 ylacramp sybase 512 Jan 16 11:42 doc

< drwxr-xr-x 3 ylacramp sybase 512 Jan 16 11:42 install

< drwxr-xr-x 3 ylacramp sybase 512 Jan 16 11:43 locales

< drwxr-xr-x 2 ylacramp sybase 2560 Jan 16 11:42 scripts

< drwxr-xr-x 2 ylacramp sybase 512 Jan 16 11:42 upgrade

---

> drwx------ 2 ylacramp sybase 512 Jan 16 11:42 bin

> drwx------ 2 ylacramp sybase 512 Jan 16 11:42 doc

> drwx------ 3 ylacramp sybase 512 Jan 16 11:42 install

> drwx------ 3 ylacramp sybase 512 Jan 16 11:43 locales

> drwx------ 2 ylacramp sybase 2560 Jan 16 11:42 scripts

> drwx------ 2 ylacramp sybase 512 Jan 16 11:42 upgrade

rep1510/REP-15_1/bin:

< -rwxr-xr-x 1 ylacramp sybase 13173912 Apr 17 2008 repserver

< -rwxr-xr-x 1 ylacramp sybase 67930536 Apr 17 2008 repserver.diag

< -rwxr-xr-x 1 ylacramp sybase 4828292 Apr 17 2008 rs_subcmp

---

> -r-xr-x--- 1 ylacramp sybase 13422692 Nov 12 21:30 repserver

> -r-xr-x--- 1 ylacramp sybase 68726944 Nov 12 21:25 repserver.diag

> -r-xr-x--- 1 ylacramp sybase 4829836 Nov 12 21:31 rs_subcmp

rep1510/REP-15_1/doc:

< -rw-r--r-- 1 ylacramp sybase 471079 Apr 17 2008 error_messages_rs

< -rw-r--r-- 1 ylacramp sybase 53861 Apr 17 2008 error_messages_subcmp

---

> -r--r----- 1 ylacramp sybase 487874 Nov 12 21:14 error_messages_rs

> -r--r----- 1 ylacramp sybase 53861 Nov 12 21:17 error_messages_subcmp

rep1510/REP-15_1/install:

< -rwxr-xr-x 1 ylacramp sybase 5908448 Apr 30 2008 rs_init

---

> -r-xr-x--- 1 ylacramp sybase 5912056 Nov 12 21:59 rs_init

rep1510/REP-15_1/locales:

< drwxr-x--- 3 ylacramp sybase 512 Jan 16 11:43 us_english

---

> drwx------ 3 ylacramp sybase 512 Jan 16 11:43 us_english

rep1510/REP-15_1/locales/us_english:

< drwxr-x--- 3 ylacramp sybase 512 Jan 16 11:43 utf8

---

> drwx------ 3 ylacramp sybase 512 Jan 16 11:43 utf8

rep1510/REP-15_1/locales/us_english/utf8:

< -rw-r----- 1 ylacramp sybase 270114 Mar 27 2008 rs.loc

---

> -r--r----- 1 ylacramp sybase 279205 Nov 12 20:43 rs.loc

rep1510/REP-15_1/scripts:

< -rw-r--r-- 1 ylacramp sybase 4248 Aug 25 2003 hds_clt_ase_to_db2.sql

< -rw-r--r-- 1 ylacramp sybase 3396 Aug 25 2003 hds_clt_ase_to_udb.sql

< -rw-r--r-- 1 ylacramp sybase 10758 Feb 27 2008 hds_db2_udds.sql

< -rw-r--r-- 1 ylacramp sybase 36517 Feb 27 2008 hds_oracle_udds.sql

< -rw-r--r-- 1 ylacramp sybase 12689 Feb 27 2008 hds_udb_udds.sql

< -rw-r--r-- 1 ylacramp sybase 512445 Apr 3 2008 rs_install_systables_asa.sql

< -rw-r--r-- 1 ylacramp sybase 511832 Apr 3 2008 rs_install_systables_ase.sql

---

> -r--r----- 1 ylacramp sybase 4924 Sep 23 07:43 hds_clt_ase_to_db2.sql

> -r--r----- 1 ylacramp sybase 4540 Sep 23 07:43 hds_clt_ase_to_udb.sql

> -r--r----- 1 ylacramp sybase 13714 Sep 23 07:49 hds_db2_udds.sql

> -r--r----- 1 ylacramp sybase 36518 Oct 13 06:41 hds_oracle_udds.sql

> -r--r----- 1 ylacramp sybase 15631 Sep 23 08:01 hds_udb_udds.sql

> -r-xr-x--- 1 ylacramp sybase 515226 Oct 23 01:35 rs_install_systables_asa.sql

> -r-xr-x--- 1 ylacramp sybase 514613 Oct 23 01:35 rs_install_systables_ase.sql

rep1510/REP-15_1/upgrade:

< -rw-r--r-- 1 ylacramp sybase 290206 Apr 4 2008 rsupgr_asa.sql

< -rw-r--r-- 1 ylacramp sybase 293453 Apr 4 2008 rsupgr_ase.sql

---

> -r-xr-x--- 1 ylacramp sybase 305894 Oct 23 01:35 rsupgr_asa.sql

> -r-xr-x--- 1 ylacramp sybase 309141 Oct 23 01:35 rsupgr_ase.sql

556945 0C4 at startup with DB2 V 9 at LTMIFI CODE=0C4 REASON CODE=00000011
557071 Rename a project in the repository browser then lock it.

The List of Locks window displays the older name of the project under Name column but Location is correct.

No problem when renaming a folder.

557255 MICROSOFT SQL SERVER ONLY: ntext data is not

replicated correctly to the target database when

the lr_ntext_byte_order configuration parameter

is set to 'little' and the ltl_big_endian_unitext

configuration parameter is set to 'false'.

557276 ORACLE ONLY:

Update value of udd to null, RepAgent

will sent value as 0.

557460 'create connection' command does not check constraint between commit control and serial method. Conflicting values should not be permitted in the create connection command and should report an error.
557576 Request for a "Warning: you are about to change/replace your configuration. Are you sure you wish to do this?" popup message before executing changes to replication configuration.
557590 0C4 in LTMOC in offset 00002B2C
557647 *** Monday, January 26, 2009 8:42:46 AM *** ahill ***

Customer site has migrated from PD v12.5 to 15. For the repository they use SQL Server 2005 and the use 'windows authentication' for all logins. They will have 300+ users accessing CMR.

After installing CMR, I modify the connectionURL in the \config\repository.xml file and enter

jdbc:sqlserver://<servername>:1433;databaseName=<dbname>;integratedSecurity=true;

this is the same connection URL from a working connection profile in PowerDesigner.

When I restart the tomcat server and attempt to connect to the repository, the connection fails. In the cmrserver.log file, the following message is logged:

FATAL Thread-1 2009/01/22 17:54:09 EST com.sybase.cmr.infra.server.persistence.db.connection.DBCPConnectionProvider.init(DBCPConnectionProvider.java:194) Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication.)

FATAL Thread-1 2009/01/22 17:54:09 EST com.sybase.cmr.infra.server.persistence.db.connection.DBCPConnectionProvider.init(DBCPConnectionProvider.java:195) Failed to initialize database connection.

557649 Repository 'Check-out' menu does not launch

Also, notice that the accelerator on the menu is 'CTRL+ALT+O but in the Browser it is CTRL+ALT+E

To reproduce:

1) connect to a PD 15 repository

2) select 'check out' from the repository menu

Note: the Check out window does not launch

557896 0C4 in LTMPACKR
557958 Upon shutdown, RA DB2 abends with 0C1
557993 ORACLE ONLY: On-line logs stored in ASM that were

created under certain conditions will not be

fully replicated, which will cause the

Replication Agent to stop replicating.

558095 Connection is dead/crashed if use only IPAddress in LTMCFG
558098 ASE ONLY: A user defined type that is defined

with a base type of varchar is incorrectly

treated as type 'longsysname'.

558106 ASE ONLY: Mirror Replication Agent fails with

error "TransactionException: Can not find

relative operation locator of CLR".

558164 Change behaviour of partitions for reading symbolic links and disk volumes.
558312 cannot drop active connection with repdef on logical connection...problem happens on RepServer 12.5x, 12.6x, 15x

1) create logical connection with the same or diff name as ds.db for active connection

2) create table repdef with or without send standby all columns or

msa(multiple site availability)db repdef

using logical connection

3) add active connection to logical connection

4) attempt to drop active connection

558321 Invalid token message at RS when Minimal_cols = Y and codepage = 37
558331 0C4 in LTMIFI
558653 ORACLE ONLY: Replication Agent goes to ADMIN

state when processing a truncate table DDL

operation.

558726 The default values for the properties

rasd_backup_dir, rasd_database,

rasd_trace_log_dir, rasd_tran_log, and

rasd_tran_log_mirror are incorrect.

558865 PD15 CMR:DBCS Korean is broken on Repository Object Properties->Description
559042 The Replication Agent (dbltm) could have crashed when shutting down if the shutdown request was issued by the RepServer that was currently connected. This problem has now been fixed.
559386 ORACLE ONLY: The "pdb_archive_path" configuration

property now provides the option to include the

Oracle unique database name with the ASM disk

group name in order to identify the location in

ASM that archived log files are stored.

pdb_archive_path

This parameter is available only for Oracle and

UDB.

Identifies the directory path where the

Replication Agent expects to find archived redo

log files (for Oracle) or archived transaction

log files (for UDB). When archived redo log files

or archived transaction log files are stored in

the file system, the configuration parameter is

set to a file system path.

Default

<not configured>

Values

For Oracle, a valid directory path on the machine

hosting the Replication Agent that points to a

location where Oracle places the archived redo

log files. For example,

ORACLE_HOME\oradata\orcl\archive

For Oracle, when archived redo log files are

stored in Oracle ASM, the configuration parameter

must be set to the name of the ASM disk group

where the archived redo log files are stored.

The disk group name must be preceded with a plus

�+� sign to specify the archive redo log path as

an ASM disk group. For example,

+dgroup_01

For Oracle, when archived redo log files are

stored in Oracle ASM and the Oracle datbase

name and unique database name are different, the

configuration parameter must be set to the name

of the ASM disk group and database name where the

archived redo log files are stored. The disk

group name must be preceded with a plus �+� sign

to specify the archive redo log path as an ASM

disk group followed by a path separator "/" and

database name. For example,

+dgroup_01/XDMQALDA

For UDB, a valid directory path on disk, as

defined by the UDB LOGARCHMETH1 or LOGARCHMETH2

database configuration parameter, when it is

configured to DISK. For example,

<path>

Comments

Setting of the configuration parameter is

required when configuration property

pdb_include_archives is set to true, and must be

set to a valid location before the Replication

Agent can be placed in a replicating state.

If the Replication Agent cannot find an expected

log record in the Oracle online redo logs, the

Replication Agent will search this directory for

the archived log file containing the required

record.

For UDB, pdb_archive_path must be configured

before pdb_archive_remove is enabled

(set to true).When pdb_archive_remove property is

set to true, Replication Agent for UDB truncates

the archived log files from the location

specified by pdb_archive_path.

See also pdb_archive_remove and

pdb_include_archives.

559473 After a Replication Agent zeros the Replication Server truncation point

with 'rs_zeroltm', the Replicatin Agent expects to

receive a zero value from the Replication Server with the 'get

truncation' command. Due to uninitialized

values, a non-zero value is incorrectly received

instead.

559474 Incorrect column name sent to RS.
559506 ORACLE ONLY: Prior to this release, the

Replication Agent would automatically create

replication definitions during ra_init

processing, if configuration property

pdb_auto_create_repdefs is set to true. Now,

in order to shorten the length of time

required for ra_init processing, automatic

creation of replication definitions in

Replication Agent for Oracle has been removed

from ra_init processing, regardless of the

setting of pdb_auto_create_repdefs.

Customers who wish to have replication

definitions created for all tables marked during

execution of ra_init, should execute command

rs_create_repdefs with the 'all' keyword after

ra_init execution.

559689 RepServer 15.1_ESD#1 fails to create a raw partition using rs_init on AIX
559907 LEXTRACE Delete: DBID= 282 OBID= 12 Member= 1, LRSN=C3BB04722260 URID=0004C0048034 CLR.

Wed Feb 11 09:00:17 2009 LTMAPI: LTMPACKR return rc= 432160972.

Regression, the line to set the return code when building or checking a Compensation Log Record (CLR) was missing.

560106 ORACLE ONLY: Replication Agent may fail with

a BufferUnderFlowException when updating a LOB

column in a table from a null value to a non-null

value.

560209 ORACLE ONLY: Replication Agent creates a

replication definition for a table containing a

clob datatype as a text datatype for three bytes

character set.

560260 After "cancel" the Merge Dialog (Check In Model) of an Integrate Model the Updatable Model in the repository becomes Frozen.
560637 If a replication topology contains a large number of primary databases (e.g. 50 or more), Replication Server may report that it is attempting to process a BEGIN statement for a transaction that it has already replicated. This incorrect behavior will report error 24056 in a DSI error message.
560834 ORACLE ONLY: Replication Agent fails to replicate

the execution of stored procedure which have 4

char parameters.

560970 ORACLE ONLY: Replication Agent fails with a

NullPointerException when processing a create/drop

materialized view statement.

561326 add ... If passwd is NULL, omit "set password" from items in add server command
561381 Creating a new agent instance from an existing

agent instance fails with a NullPointerException.

561605 ORACLE ONLY: Replication Agent fails during

migration with an error similar to "Session

repository has multiple entries for session with

instance id <1>, sid <88> and version

<0x000000000d073ef20001000100000b6a0000020d00900

0000000000000000000>".

561695 ASE ONLY: 'pdb_setreptable all, unmark, force'

does not unmark all tables.

561703 RM 15.1 plugin not work with 15.0.3 unless re-install Sybase Central, Open Client and ASE plugin.
561705 ASE ONLY: "pdb_setrepproc all,umark,force" fails

when executed after "pdb_setrepproc all, disable".

561740 ORACLE ONLY: Replication Agent fails to create

a replication definition for a table containing

a FLOAT column.

561784 Changes performed against project document are not updated to the repository.

The Check In has detected that the local document and the repository document are identical. The check in has been canceled.

561884 ASE ONLY: pdb_get_columns owner, table, column

fails.

561903 MICROSOFT SQL SERVER ONLY: When the

pdb_dac_port_number configuration property is set

to an incorrect value, Replication Agent

fails to initialize with a mis-leading error

message "The server is not started in single user

mode".

562014 Unable to decompress DB2 V 9 log record.
562092 ASE ONLY: Command "pdb_get_primary_keys" returns

an error, instead of returning 0 rows, when the

command is executed for a table that does not

exist.

562131 ASE ONLY: If the replicate site is ASE 15.0.2,

system procedure call, sp_setrepproc, can not be

replicated correctly when Replication Agent

unmarks a procedure in the primary site.

562203 Enhance rs_ticket to provide timezone info or use UTC format for datetime fields.
562350 Repository Web Browser Search: Add Description and Annotation properties to Attributes List
562356 Repository Explorer fails to display Comment, Description and Annotation properties for a Repository document.
562690 MICROSOFT SQLSERVER ONLY:

RepAgent throws NullPointerException

when replicating sp_rename.

562732 ORACLE ONLY: Replicating DDL 'ALTER SYSTEM

SET WALLET OPEN' will cause Replication Server

DSI connection to suspend.

562733 Default value for configuration parameter

'truncation_type' is incorrectly set to 'INTERVAL'

instead of 'LOCATOR_UPDATE'.

562734 ORACLE ONLY: SecureFiles LOB column which is

defined as 'DEDUPLICATE' may cause Replication

Agent to go to ADMIN state.

562739 ORACLE ONLY: Replication Agent goes to ADMIN state

with a NullPointerException when trying to alter

a table to modify lob columns.

562743 ORACLE ONLY: Replication Agent failed with

error similar to "Error initializing change

vector <###> in log record <###> because: null".

562805 Replication Server may terminate unexpectedly and generate a core file when the trace flag

'STS, STS_DONT_CACHE' is enabled.

562999 ASE ONLY:

DDL command is not replicated to the

replicate site, which was issued just

before "pdb_setrepddl disable" command.

563044 RepConnector does not recognize two commands sent from RS 15.2
563103 Feature Request: Allow Find on User rights.

In List of Users window, Find a row tool currently opens to search an item in the list based on displayed columns.

563403 ORACLE ONLY: Replication Agent incorrectly creates

a replication definition for multi-byte LOB

column as text datatype.

563431 MICROSOFT SQL SERVER ONLY: Operations executed by

the maintanance user are not filtered out for replication.

563437 ORACLE ONLY: pdb_setrepproc fails to mark a

procedure which has no blank or '/n' between the

procedure specification and the final return.

563694 Customer is using RepAgent for Oracle 12.5.0.303P2 (trigger base RepAgent).

RepAgent 12.5, trigger based release, for Oracle, the store procedure "RA_BLD_REPTRAN_" does not report exception that had occured from RAO system table "RA_EXCEPTION_" when the SQL_Code is negatif (less than 0).

When RepAgent scan the shadow log, it call store proc "RA_BLD_REPTRAN_", this store proc may raise an execption (error 20.000) when exception have been logged in the exception system table "RA_EXCEPTION_" :

RA_BLD_REPTRAN_ source code:

/** check for exceptions, raise -20000 error if any have been registered **/

SELECT COUNT(*) INTO NUM_TRANS FROM RA_EXCEPTION_ WHERE sql_code_ > 0;

IF ( NUM_TRANS > 0 ) THEN

RAISE_APPLICATION_ERROR ( -20000, 'RAO exceptions have been logged');

END IF;

In this peace of code, the WHERE clause "sql_code_ > 0" does not include all exceptions where error code is negatif.

This cause RepAgent to be restarted even the "RA_EXCEPTION_" system table is not cleared, and cause next exception to not be logged.

This code could be change like this: ("sql_code_ <> 0")

/** check for exceptions, raise -20000 error if any have been registered **/

SELECT COUNT(*) INTO NUM_TRANS FROM RA_EXCEPTION_ WHERE sql_code_ <> 0;

IF ( NUM_TRANS > 0 ) THEN

RAISE_APPLICATION_ERROR ( -20000, 'RAO exceptions have been logged');

END IF;

Doing this, the RepAgent exception table will need not allow RepAgent to restart before exception table is cleaned and so next exception will not be lost.

563797 Replication Server with Adaptive Server Enterprise target databases takes a long time to boot when it is configured with a lot of DSI connections and thousands of replication definitions and subscriptions are present. On the condition where there were 50 DSIs and more than 10000 rows on both rs_objects and rs_subscriptions, RS took more than 100 minutes to boot.
563802 MICROSOFT SQL SERVER ONLY: The empty string

value('') for image data type is replicated as

non-empty data to the replicate site.

563809 ORACLE ONLY:

Replication Agent goes into ADMIN state

when replicating table with LOB columns.

564067 Improve Replication Server performance by resolving 'seg_alloc_sync', 'sqmr_read_sync' and 'SQM_GLOBAL_OQID_RW_C' lock contention issues. CRs were orginally filed for these issues are: 562009, 561356 and 561667
564142 Resume connection produces stack in Replication Server when a large transaction is in the queue. Replication Server transaction send buffer is unable to accurately expand to account for new commands, problems with the command separator in DSI impact data flow.
564196 ORACLE ONLY: Replication Agent fails to correctly

replicate a rollback operation on an off-row LOB

column.

564201 UDB ONLY: 'pdb_truncate_xlog' command fails with

error "Procedure 'pdb_truncate_xlog',

Line 1: Illegal command: <pdb_truncate_xlog>".

564293 ORACLE ONLY: After resuming replication, an

EndOfLogException during RBA search positioning

sends the Replication Agent back to ADMIN state.

564308 ORACLE ONLY: The error "OracleRuntimeException:

Off-row LOB leaf update contains unexpected

values" causes the Replication Agent to suspend

replication.

564317 hds_oracle_setup_for_replicate.sql rs_lastcommit needs char(72 byte) for _qid's

select origin, origin_qid, secondary_qid from rs_lastcommit

E. ... ERROR #5094 DSI(104 oracle_dco.oracle_dco) - /dsioqid.c(1781)

The second and third columns returned by the rs_get_lastcommit function should

have type 'binary' or 'char'. The one returned from database 'oracle_dco.

oracle_dco' for column 2 is not 'binary' or 'char'. It is '2' as defined by CS_LIB.

I. ... The DSI thread for database 'oracle_dco.oracle_dco' is shutdown.

REHL5.2 (2.6.18-92.el5) x86_64

we need to change the syntax for creating the rs_lastcommit table in

hds_oracle_setup_for_replicate.sql

should be...

create table rs_lastcommit

(

origin number(8),

origin_qid char(72 byte),

secondary_qid char(72 byte),

origin_time date,

dest_commit_time date

)

go

564438 Tested and reproduced with PD 15.0 EBF#3 and Repository Web Browser 15.0 and 15.0 EBF#3

When accessing a repository created in SQL Server 2005 via CMR, the following error appear in CMR logs right after starting up CMR service:

ERROR Thread-1 2009/03/12 10:29:34 BRT com.sybase.cmr.infra.server.persistence.db.metacommands.LoadMetaModelCmd.execute(LoadMetaModelCmd.java:144) Unrecoverable exception occurred during loading of metamodels from repository

java.lang.NullPointerException

at java.util.Hashtable.get(Hashtable.java:336)

at com.sybase.cmr.infra.server.persistence.db.ExtendedMetaData.getMetaPackageExtendedMetaData(ExtendedMetaData.java:129)

at com.sybase.cmr.infra.server.persistence.db.DbMetaPersistenceManagerImpl.createMetaPackages(DbMetaPersistenceManagerImpl.java:589)

at com.sybase.cmr.infra.server.persistence.db.metacommands.LoadMetaModelCmd.execute(LoadMetaModelCmd.java:106)

at com.sybase.cmr.infra.server.persistence.db.command.CommandWrapper.execute(CommandWrapper.java:107)

at com.sybase.cmr.infra.server.persistence.db.command.TxCommand.execute(TxCommand.java:83)

at com.sybase.cmr.infra.server.persistence.db.command.CommandStackImpl.execute(CommandStackImpl.java:58)

at com.sybase.cmr.infra.server.persistence.db.DbMetaPersistenceManagerImpl.loadAllMetaModels(DbMetaPersistenceManagerImpl.java:342)

at com.sybase.cmr.infra.server.persistence.db.DbMetaPersistenceManagerImpl.loadAllMetaModels(DbMetaPersistenceManagerImpl.java:112)

at com.sybase.cmr.infra.server.meta.management.MetaModelManagerImpl.loadMetaModels(MetaModelManagerImpl.java:227)

at com.sybase.cmr.infra.server.impl.RepositoryImpl.init(RepositoryImpl.java:753)

at com.sybase.cmr.infra.server.impl.RepositoryImpl.<init>(RepositoryImpl.java:203)

at com.sybase.cmr.infra.server.impl.RepositoryImpl.<clinit>(RepositoryImpl.java:112)

at com.sybase.cmr.infra.server.RepositoryFactory.createRepository(RepositoryFactory.java:27)

at com.sybase.cmr.webrepository.webapp.servlet.CMRHttpServlet.init(CMRHttpServlet.java:62)

at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)

at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)

at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)

at org.apache.catalina.core.StandardService.start(StandardService.java:448)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)

at org.apache.catalina.startup.Catalina.start(Catalina.java:552)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)

If the repository is not empty, the following error also occurs when trying to expand Default Treeview within Repository Explorer Tab:

ERROR http-3030-Processor25 2009/03/12 10:30:29 BRT org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260) Servlet.service() for servlet Blocking Servlet threw exception

java.lang.RuntimeException: Could not find metaclass with the specified id 1106.

at com.sybase.cmr.webrepository.webapp.filter.LocaleFilter.doFilterInternal(LocaleFilter.java:112)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

at java.lang.Thread.run(Thread.java:595)

564563 Replication Agent backup log file names are not

generated in sequential order if the log file to

be backed up is exclusively locked by other

application.

564650 'Internal error #23 RSI' will be generated by Replication Server for a route because of a synchronization issue between SQM writer and SQM reader. The RSI thread will report a stack trace in the RS log file when waking up in some circumstances.
564756 The schedule option for 'rasd_trunc_schedule'

command has been enhanced to accept

two kinds of schedule string. The current support

restricted UNIX cron style format and now a full

UNIX cron style format to support range and step

schedule.

The following is a valid schedule string in the

full UNIX cron style format:

[mm] [HH] [DOM] [MON] [DOW]

Note:

- Similar to the restricted UNIX cron style

schedule, a full UNIX cron style have

5 fields: mm, HH, DOM, MON and DOW,

The schedule format consists of 5

fields:

- minutes

- hours

- day of month

- month

- day of week.

- Each of the fields must be separated

by a whitespace. The schedule string

must be enclosed in double quotation marks.

- A list of values, a range of values or

a range of stepped values can be specified

in each fields so that a series schedule

can be specified in one command.

- List values in form i,j,k, which means

integer values applying to a field are i,j

and k. For example, schedule

"1,2,8,10 20 * * *" represents 8:01 pm,

8:02 pm, 8:08 pm, 8:10 pm every days.

- Range values in form of i-j, which means any

integer value from i to j. For example,

0-59 represents values 0,1,2,3,4,5,...58,59;

schedule "0-59 20 * * * " represents every

minutes in 8 pm.

- Step values in form of i-j/n, which means

any value from i to j stepped by n. For

example, 1-10/4 represents values 1,5,9.;

schedule "1-10/4 20 * * *" represents

8:01pm, 8:05 pm and 8:09 pm.

564900 ASE ONLY: Issuing 'resume' command prior to

performing migration causes Mirror Replication

Agent to fail with NullPointerException.

564908 dsi_quoted_identifier is written up as dsi_quoted_identifiers in the manuals.
564947 ASE ONLY: Marked stored procedure is

still marked after Mirror Replication Agent

is re-initialized.

564954 Replication Agent ADMIN utility (ra_admin or

ma_admin) with the " -u <instance_dir>" option

is unable to upgrade the instance if the specified

source instance directory is a relative path with

no file separator.

565081 The apostrophe in this char string must be sent as two apostrophes '' so that the Rep server does not get an error.

@"DS_DOMICILIO"='Calle Baltasar D'Espanya 00002

Bajo',

565127 Quoted keywords in replication definitions do not carry to primary key and do not work on text/image columns. User will see DSI threads shutdown likely reporting illegal syntax, inspection of the RS log file will include misquoted object names.
565132 If using subscription materialization, the primary DSI connection must be altered to use quoted identifiers.
565142 Quoted identifiers failed in subscription materialization even with the connections set to use quoted identifiers. The changes for this CR support quoted identifiers for subscription materialization.

Custom function strings with a quoted constant in the select cannot be used with quoted identifiers and subscription materialization.

565430 PDes does not update the shortcut (name+code) in the target model in the repository with new name/code: the local document and the repository document are identical. The check in has been canceled.

The display in the repository explorer is now confusing: new name is displayed in local browser, old name is displayed in repository browser.

565536 ORACLE ONLY: java.lang.IllegalStateException with

message like "No entry found in oracleLob with

the LOB Column <BLOB_COL> in table <RAUSER>.<TAB>"

is thrown when checking whether the object is in

encrypted tablespace or not.

565548 ORACLE ONLY: "pdb_xlog init" fails against a

supported Oracle version with message "version

... is not supported" after Replication Agent

attempts to initialize against an unsupported

Oracle version.

565564 ORACLE ONLY: Marking a table with partition

defined in encrypted tablespace is successful

when it should not be allowed.

565661 ORACLE RAC ONLY: A LocatorComparisonException

sends the Replication Agent to ADMIN state.

565694 ORACLE ONLY: The "pdb_archive_path" configuration

property now provides the option to include the

Oracle unique database name with the ASM disk

group name in order to identify the location in

ASM that archived log files are stored.

pdb_archive_path

This parameter is available only for Oracle.

Identifies the directory path where the

Replication Agent expects to find archived redo

log files (for Oracle). When archived redo log files

or archived transaction log files are stored in

the file system, the configuration parameter is

set to a file system path.

Default

<not configured>

Values

For Oracle, a valid directory path on the machine

hosting the Replication Agent that points to a

location where Oracle places the archived redo

log files. For example,

ORACLE_HOME\oradata\orcl\archive

For Oracle, when archived redo log files are

stored in Oracle ASM, the configuration parameter

must be set to the name of the ASM disk group

where the archived redo log files are stored.

The disk group name must be preceded with a plus

�+� sign to specify the archive redo log path as

an ASM disk group. For example,

+dgroup_01

For Oracle, when archived redo log files are

stored in Oracle ASM and the Oracle database

name and unique database name are different, the

configuration parameter must be set to the name

of the ASM disk group and database name where the

archived redo log files are stored. The disk

group name must be preceded with a plus �+� sign

to specify the archive redo log path as an ASM

disk group followed by a path separator "/" and

database name. For example,

+dgroup_01/XDMQALDA

Comments

Setting of the configuration parameter is

required when configuration property

pdb_include_archives is set to true, and must be

set to a valid location before the Replication

Agent can be placed in a replicating state.

If the Replication Agent cannot find an expected

log record in the Oracle online redo logs, the

Replication Agent will search this directory for

the archived log file containing the required

record.

See also pdb_archive_remove and

pdb_include_archives.

565702 ORACLE ONLY: Replication Agent 'suspend' command

may take a long time to complete.

565705 Configuration property, retry, does not change length between retries. When RS is in hibernate mode after the RS was replicating, the configuration property, Maximum_connect_retries, does not shutdown the RA DB2 after Maximum_connect_retries is reached.
565724 ORACLE ONLY: The byte order of double byte CLOB

data in LTL is not consistent with the value for

lr_ntext_byte_order setting.

565745 ORACLE ONLY: Replication Agent fails on a rollback

transaction on a multi-block undo enabled Oracle

database.

566000 Feature Request: PDes shall be able to continue to response to users action while it is waiting for the repository connection and PDes shall allow users to browse other models in the workspace while it is checking in/out another document.
566068 Replication:

If the associated Rep Server was authenticated first, you may get the following exception in the SCC (UAF) console when you authenticate an ASEMAP ASE:

[ASEMAP:][ERROR] [btpool1-3] Exception invoking method getRelatedManagedObjects javax.management.RuntimeOperationsException: Exception invoking method getRelatedManagedObjects.

If you continue and schedule collections for all servers, the collection jobs appear to run successfully - no errors are thrown as the collections are running. When you launch the ASE Monitor for the ASEMAP ASE you may get a pop-up error:

  The ASEMO does not contain all the child MO(s).

燙lick OK, and the ASE Monitor displays, but no data will be displayed on the Rep Agent screen

566070 When Replication Server drops a route, it might produce core dump when deleting the segment.

When multiple routes are created concurrently, deadlock might happen.

566080 When using Mirror Replication Agent version

15.1 GA and communicating with Replication

Server 15.2 or later, the Mirror Replication Agent

query against the Replication Server System

Database to obtain replication definition

information fails to return the appropriate rows.

This failure causes the Mirror Replication Agent

to fail with a 'replication definition not found'

error.

566099 Trace statements show up in SYSPRINT in build 22.
566117 ORACLE ONLY: Replication Agent initialization may

fail to locate the Oracle timezone file even

though the ORACLE_HOME environment setting is

defined correctly.

566139 MICROSOFT SQL SERVER ONLY: Replication Agent

instance can not start up after upgrading from

pre-15.1 to current release version.

566225 There are three new options to the -u parameter

in the ra_admin utility for upgrading Replication

Agent instances.

SYNTAX: ma_admin -u <upgrade_option>

PARAMETERS

-u <src_instance_dir>

Upgrade one instance of Replication Agent in

the specified source instance directory

to the product installation directory

-u <instance_name> | instance=<instance_name>

Upgrades only the specified instance of

Replication Agent in the current product

installation directory

-u all

Upgrade all instances of Replication Agent

within the current product installation

directory.

EXAMPLE:

To upgrade an individual instance in

a specified source instance directory to

the product installation directory.

ma_admin -u /opt/sybase/MA-15_0/my_inst

To upgrade all the instances in the current

product installation.

ma_admin -u all

To upgrade a specific instance in the current

product installation directory.

ma_admin instance=my_inst

OR

ma_admin my_inst

NOTE:

- The -u <src_instance_dir> provides the

ability to upgrade an individal instance

from a previous major release to the

current release.

- The 'all' or '<inst_name>' or

'instance=<inst_name>' upgrade options

performs an upgrade of instance(s)

in the current product release. All

upgrades are performed directly on the

instance to be upgraded. The Replication

Agent instance configuration file is

backed before the upgrade for use in error

recovery, if required. If an error occurs,

the upgrade is rolled back. This option is

intended for performing upgrade of instances

between release to release in the same

major release such as a patch update.

566309 5185 message can be misleading.
566422 Replication: A set of stored procedures is loaded into the RSSD when a Replication Server is added to SCC. In the previous release the content of the script was written to the SCC log file. This has been changed to exclude the script's content, but to add an informational message to the log that identifies the name of the script.
566480 ASE ONLY:

For internal use only(QA found the issue

before release):

Table or procedure can not be marked/unmark/

enable/disabled by using "pdb_setreptable"

or "pdb_setrepproc" due to "null" error.

566579 State icon for both project and document does not reflect the current status in the local browser. Sometimes, icon is not displayed at all and you have to click the model/project to see it or have it updated.
566663 Error during FREEMAIN, SYS CODE = 378-0C, for memory not allocated.
566670 MICROSOFT SQL SERVER ONLY: Replication Agent

provides two new API command, ra_deviceoffset

and ra_helpdeviceoffset to set the raw device

offset and provide help on the raw device offset

setting

566715 Replication Server command "admin stats, status" returns error, single quoting the "status" value will avoid the problem but internal and external management tools require this keywork status without single quotes.
566829 *** Tuesday, March 31, 2009 1:17:13 PM *** ahill *** 12.5 & 15.0

BUG: PD 12.5.0.2361(esd#19) consolidate 'metamodel.oom' to ASE 1501 esd#1 using the Sybase ASE ODBC driver 15.00.00.xxx causes loss of metadata.

This issue appears to be due to the size specified in the 'text size' parameter of the ODBC DSN. The default value is 32678.

The consensus from a consult is that the 'text size' attribute needs to be increased to resolve this issue. Changing this value from 32678 to 10,000,000 should have no performance related issues when working with a repository installed on ASE. This value can be increased to a maximum of 2G if necessary.

Another issue that occurred was some text characters being extracted incorrectly. Using metamodel.oom, 'ellipsis' in a comment was extracted as a '.' period.

This is due to the character set of the server. However, this issue can be addressed by changing the 'character set' attribute on the ODBC driver.

ASE TSE has provided the following:

The ellipsis (...) character is properly processed (consolidate/extract/compare from repository)

when PD 125 client has MaxBytesPerChar set and the ODBC driver setting 'User Specified' = utf8 is set...

////////////////////

ASE:

I have an ASE 1501 ESD#1 server.

It's charset = iso_1, sort = bin_iso_1.

---

ODBC driver:

If I set the <<User Specified>> = utf8 in the Character Set groupbox

and the <<Client Default>> > Code Page Type = ANSI (it's greyed out).

---

PD 12.5 client:

The regkey: HKLM\Software\Sybase\PowerDesigner 12\Repository\MaxBytesPerChar =3

The ellipsis character (a unicode character) is properly mananged in the db.

566833 ENH: For Sybase ASE, it would be very helpful to offer mandatory database configuration settings that are required to accept the PD repository script and the consolidation/extraction of any/all of the example models...
566854 When Replication Server can not connect to replicate database and continues to retry the connection, memory leak will happen.
566944 ORACLE ONLY: The system tables for Oracle user

'WK_TEST' and 'FLOWS_FILES' are now being filtered

out for replication by default.

566946 When the transaction log does not exist in the

primary database or the RASD is not yet

initialized, "pdb_setrepcol" with no argument

returns "0 rows affected" instead of returning

an error.

566987 Replication Server 15.2 Upgrade script has a typo when adding a new function string "rs_get_errormode". User may see erroneously reporting of warning message #13110.
567006 'create error class <class>' where <class> is a Replication Server class, returns message about system table being corrupt when it is not. The correct command for creating a Replicaton Server error classes is: create replication server error class rs_repserver_error_class
567192 ORACLE RAC ONLY: Oracle RAC replication

performance is slow.

567241 RS 15.1 and 15.2 use considerable more memory at bootup than RS 15.0.1 for the same number of connections.
567247 Error message #5185 messages is not supressed when the corresponding error action is set to 'ignore'. The error will continue to be reported in the Replication Server error log causing the log to fill very quickly if the source and target databases are out of sync.
567376 Replication: The following error may appear in the Sybase Control Center agent.log:

Attempt to locate entry in sysdatabases for database 'database_name' by name failed - no entry found under that name. Make sure that name is entered properly.

567436 5185, 5186, 5187 should identify the table that is producing the message.
567480 When the Replication Server replicates text data containing multi-byte characters and the length of text data is longer than 4KB,

the Replication Server may fall down with a 7035 error (additional allocation would exceed the memory_limit).

This can occur if the ASE and the Replication Server are both configured with multi-byte character sets.

567610 When parameters "Change in Activity (commands)" and/or "Latency(sec) are zero, the Path dashboard does not display the queues chart.
567614 Only the top 10 queues are being displayed in the Replication Server dashboard Queues view.
567682 RMS agent: If the RMS agent, on IX, is unable to login to the RepServer (due to login failure) then the network may fill with unclosed connections eventually preventing further connections to RS.
567729 ORACLE ONLY: Replication Agent goes to ADMIN state

with error "Too many open files".

567760 When multiple threads update the 'rs_databases' system table twice in one transaction, then the STS cache will be corrupted.
567814 Replication: The Replication Topology view may not display correctly if a server is unregistered from Sybase Control Center and a different server is registered under the same name.
567821 ORACLE ONLY: Low scan_sleep_max configuration

may stop replication. There is a new

Replication Agent configuration

log_scan_eol_threshold for determining when to flush

sorted records that have not been checkpointed.

And in Oracle RAC environment, for helping to

determine when a node in a cluster is no longer

active.

log_scan_eol_threshold

The threshold used to determine when to flush

sorted records that have not been checkpointed.

Default

300

Values

An integer from 300 to 2147483647.

Comments

- The value of the log_scan_eol_threshold

parameter is the maximum number of seconds that

can elapse before the Log Scanner component

flush sorted records that have not been

checkpointed.

Notes

- For Oracle RAC, log_scan_eol_threshold

configuration is used in determining whether a

node in the cluster is active. Since a node

may go down at any point during replication,

Replication Agent has to determine when a node

is no longer active, and the

log_scan_eol_threshold configuration is used

for this purpose. If Replication Agent is

reading at the end of the node's redo log

thread and there are no checkpointed records

in the queue, Replication Agent will treat a

node as inactive after the number of seconds

specified by the log_scan_eol_threshold

configuration pass. The log_scan_eol_threshold

configuration can not be set too low, otherwise

Replication Agent treating a node as inactive

when it is actually still active.

567926 bulk insert doesn't do bulk insert on nullable text column, replicate_if_changed and ASE 12.5.4.
567946 Stack upon startup with quoted identifiers on.
567970 Self-join queries do not be replicated as SQL statement correctly. The Replication Server applies the SQL statement as the maintenance user and the target ASE does not process is correctly. The Replication Server should use the owner name associated with the table in the replication definition and apply the SQL with the prefix owners name included in the target table.
568078 ORACLE ONLY: Transaction user is not sent

correctly when using "Oracle Identity Manager

10.1.4".

There is a new Replication Agent command to

support use of Oracle Identity Manager.

Command:

pdb_send_osuser_list

Description:

Add or remove database user id to/from osuser

list. If the database user is in the osuser

list, then any transactions for that database

user will be sent as the relative operating

system user for that transaction user. This

list is a list of 'database' users that will

need to be replaced with the 'operating system'

user name. This is NOT a list of

'operating system' users. This command also

returns a list of the database users in the

osuser list.

Syntax:

pdb_send_osuser_list

pdb_send_osuser_list [[add | remove],[user | all]]

Parameters:

add The add keyword add user into osuser list,

whose transaction will be sent to

Replication Server as its relative

operating system user.

remove The remove keyword removes database user

from osuser list.

user The name of the database user that need

be converted to operating system user.

The user name is case insensitive.

all All database users will be converted to

operating system user if they have a

valid operating system user.

Examples:

Example 1 pdb_send_osuser_list

This command lists database users who will be

converted to osuser. Assuming a person logs

into their operating system as 慾oeuser�, and

subsequently logs into Oracle as 憉ser_a�:

Example 2 pdb_send_osuser_list add, user_a

This command adds database 'user_a' into

osuser list. The transaction of 'user_a; will be

sent as operating system user 慾oeuser�

Example 3 pdb_send_osuser_list remove, user_a

This command removes database 'user_a' from

osuser list. The transaction of database

'user_a' will no longer be converted to the

operating system user 'joseuser'.

Example 4 pdb_send_osuser_list add, all

The transaction of all database users will be

sent as operating system user

Usage:

- When pdb_send_osuser_list is invoked, its

function is determined by the keywords and

options you specify. When multiple keywords

and options are specified, each must be

separated by a comma. Blank space before or

after a comma is optional.

- Only session login later then

pdb_send_osuser_list will be

converted as osuser. The session by user

which is earlier than pdb_send_osuser_list

setting will not change.

For example:

pdb_send_osuser_list add, user

- The pdb_send_osuser_list command is valid

only when the Replication Agent instance is

in ADMIN state.

- If command without parameters to list only,

then it valid for any status.

568104 Documentation clarification: cannot change the declared datatype if the column is used in a where clause.
568145 ORACLE ONLY: Replication Agent may fail

with Filechannel Map failed Exception

when user initializes Replication Agent

and then re-initializes it on HPIA platform.

568248 Dynamic SQL will not be used when a table has a timestamp data type and a database replication definition and table replication definition are used.
568254 Dynamic SQL procedures that are automatically generated, should have a name that identifies the target table and the operation (insert, update, delete)
568271 Replication Agent will now log the Java VM

maximum, total, and free memory amounts (in bytes)

in the log file during initialization and when

ra_version_all is invoked.

568452 UDB ONLY: Multi-record updates are not

handled correctly when the primary database

is IBM UDB 9.5.

568476 ORACLE ONLY: The primary and replicate databases

are out of synch.

568493 The order of new column rs_errorclassid is wrong in Replication Server 15.2 upgrade/downgrade scripts, which should follow the schema of rs_databases in rs_install_systable_as[a|e].sql script file.
568670 ORACLE ONLY: Replication Agent appears to be hung

after a 'resume' command if there are a lot of

archive logs stored in Oracle ASM.

568684 The following error may be displayed in the Sybase Control Center agent.log:

Collection task failed and will be skipped. Message=null

568982 MICROSOFT SQL SERVER ONLY: If Microsoft SQL Server

is upgraded to SP3, some Replication Agent system

objects are overwritten. Please use ra_migrate

command to restore these missing objects.

569140 ORACLE ONLY: The primary and replicate databases

are out of synch and the Replication Agent system

log contains a warning message indicating that the

log sequence number for the second block in the

log does not match the log header sequence number.

569230 When primary Replication Server can not connect to replicate Replication Server and continues to retry the connection, memory leak will happen.
569283 Replication Agent fails to resume

with error "LTI start replication

failed to initialize connections",

after Replication Server is upgraded

to 15.2.

569335 Provide more details on setting up SSL in RepServer
569519 ORACLE ONLY: The primary and replicate databases

are out of synch or an open transaction prevents

the truncation point from moving and also results

in the Replication Server stable queue filling up.

569549 Replication: SCC now supports Replication Agent and Mirror Replication Agent version 15.2.
569585 MICROSOFT SQL SERVER ONLY: This is a limitation

for Replication Agent. The workaround is that zero

the locator of RASD by Replication Agent command

'ra_locator zero' and zero the locator of

Replication Server by Replication Server command

'rs_zeroltm <data_server>, <database>'. Before

doing this, please make sure that all the data

have finished replication. Then resume Replication

Agent again.

569869 Unfreeze feature is not available if user has Write permission on the document.
569956 Enhancement for latency checking from RepServer to RepConnector.
570001 Replication Server may report a unique constraint error in an Oracle-to-Oracle environment due to incorrectg usage of the begin and end transaction markers (DSIC_XACG_END_M/DSIC_XACT_BEGIN_M).
570015 In the SMP implementation, the SQM_RS_SEGMENTS_MUTEX_C is mistakenly acquired instead of the sqm_segs_sync element, this can cause a deadlock in the SQT and SQM write theads.
570206 reproduce:

1.install repository on ASA10 by JDBC , after executing scripts a few time, it pops up an error window says that "SQLSTATE = 23502 SQL Anywhere Error -195: Column 'CMMT' in table 'PMUSER' cannot be NULL".

This issue only happens when using PD EBF6 to install repository directly, if the repository is installed by some older versions and use PD BEF6 to upgrade, it works fine. And if install by ODBC directly, it works fine too.

570505 Restriction: varchar(max) can only be replicated to MS SQL targets.
570511 Allow varchar(max) to replicate to non-MS SQL targets
570520 Design capability in RS to use appropriate process in DSI to update a column values when the source column value has to be handled in two or more different methods.
570668 Increase rs_packet_size maximum to 64K.
570748 Allow objects within resource files to be viewable via the CMR application.

Specifically, the customer would like to view the extended attributes associated with objects.

The customer uses extended attributes extensively throughout their models. With the introduction of CMR, they would like to the extended attributes exposed. The lack of this exposure limits the effectiveness of the CMR application for their company.

Their intention is to use CMR to allow 300+ users to view metadata associated with their models. Without the extended attribute a large portion of this information is missing.

570754 Abend S23E after monitoring turned off.
570757 After an F REPJOB,C,MONITOR=1 command the monitor display shows when a minute has elapsed but never displays again.
570762 The Rep Agent abends with an 878 trying to getmain storage when the reason code indicates there is none available.
570763 The Rep Agent gets an S0C4 abend when the Rep Server queues fill up and the Rep Server refuses connections.
570766 The Rep Agent job abends on time out with an SEC6 instead of the normal S322 (timeout cancel).
570775 Sybase Replication Server 15.2 is a completely

new version. As a result, there are no fixed

bugs to list in this section.

570934 ORACLE RAC ONLY: There is a new Replication Agent

configuration for scanning the primary database

redo log threads in parallel.

Configuration Parameter Name

lr_parallel_scan

Description

The lr_parallel_scan configuration property is

applicable to Oracle RAC only and determines

whether the redo log threads for all nodes in a

clustered database are scanned in parallel or

whether a single serial scan is used.

Default

false

Values

true, false

Comments

- When true, the Replication Agent will start a

redo log scan thread for each redo log thread in

the clustered database.

- When false, the Replication Agent will do redo

log thread reads for each redo log thread in the

clustered database serially.

570942 ORACLE ONLY: New commit generation feature has

been added to improve RAC replication latency.

The feature is configured and monitored using

the following API commands and properties.

Configuration property:

pdb_commit_generation

Values: true or false

Default: false

Description:

If pdb_commit_generation is set to true,

Replication Agent will generate committed

transactions in the primary database at a

configured interval.

Configuration property:

pdb_commit_interval

Valid values: 1 to 5 seconds

Default: 1 second

Description:

pdb_commit_interval is the interval, in

seconds, at which the committed transactions

are generated in the primary database.

Command:

pdb_commit_generation_status

Description:

The command returns the status for all

primary database commit generation threads.

Command:

pdb_commit_generation_filter <action>,<inst>

Values:

action is the keyword 'add' or

remove',

inst is the valid Oracle instance

name, or the keyword 'all'

Description:

If the keyword 'add' is passed as an

argument, Replication Agent will add the

instance to the filter list, disabling the

commit generation for the instance.

If the keyword 'remove' is passed as an

argument, Replication Agent will remove the

instance from the filter list and enable the

commit generation for the instance.

When the command is called without any

arguments, then the names of all filtered

instances are displayed.

571061 ORACLE AND MICROSOFT SQL SERVER ONLY: ra_help

displays incorrect descriptions for 'pdb_skip_op'.

571111 ASE1502 / RS151. installjava doesn't rep JAR file to RDB in MSA
571484 AIX and Solaris have minimum patch levels. Also discrepancy between Installation Guide/external certification site regarding Solaris 2.8 certification
571520 Administrator GUI fails to start up.
571575 Repserver take a long time to start because of sql in dvre_build function

this DVRE table need to be build for Distributor (DIST)

So, this query executed only once per Distributor.

(you may find 1 Distributor for each Primary connection).

571631 Provide utility in RS to allow cusotmers to modify the license properties without directly editing the files
571646 Make the EBF/version string correlation more visible.
572087 "ra_config pdb_dflt_object_repl, false" does not

take effect when auto_mark_tables is true.

572167 Add ASE/lib directory to the LD_LIBRARY_PATH in SYBASE.sh and SYBASE.csh.
572228 Memory leak in row count verification.
572338 dump of buffer from "invalid syntax" contains garbage.
572424 ORACLE ONLY: Issuing 'pdb_setreptable' or

'pdb_setrepproc' command with 'unmark, all' option

does not set the unmarked object to 'disable'

status.

572506 After changing Cardinalities (from 0:n 1:1 to 1:1 0:n and back again)of a Relationship PowerDesigner throws Unexpected Exception during Check in.
572576 The property files for Oracle and MSSQL that

provide datatype mapping for Replication Server

15.2 are missing. These files are installed under

the config directory and are used to automatically

generate replication definitions.

572579 cust wants oracle slect permissions on ora sys tables info in quick start guide

New Select Privileges required

The select privileges for the following Oracle system tables in the primary

database server must be granted to the Replication Agent pds_user_name/user:

� SYS.TAB$ � required to support table replication

� SYS.MLOG$ � required to filter out materialized view log tables

� SYS.TABPART$ � required to support partitioned table replication

� SYS.TABCOMPART$ � required to support partitioned table replication

� SYS.TABSUBPART$ � required to support partitioned table replication

� SYS.NTAB$ � required to support table replication

� SYS.IND$ � required to identify indexes

� SYS.INDPART$ � required to identify indexes

� SYS.INDCOMPART$ � required to identify indexes

� SYS.INDSUBPART$ � required to identify indexes

� SYS.LOBCOMPPART$ � required to support partitioned LOB replication

� SYS.LOBFRAG$ � required to support partitioned LOB replication

� SYS.TS$ � required to identify tablespace encryption in Oracle 11g

� SYS.SNAP$ � required to filter out materialized view tables

572624 When Replication Server error #5149 is reported due to a DSI failure, the transactions leading up to the #5149 are not ungrouped and applied individually before processing the bad transaction that leads to the error and shutting down the DSI.
572634 Prompt does not return after issuing sysadmin hibernate_on
572675 Replication Server reports an incorrect error message for 'create replication server error class' command when referrencing non-existing error classes. This behavior is confusing to the user who attempts this behavior mistakenly.
573005 To be compatible with pre-126 Replication Server releases, RS should not pack the object ID (objid) in the Replication Server language for function replication commands. Othereise, after upgrading, RS will report error #2056 - "DSI - /prs/sql.y(12367) : Incorrect syntax...".
573225 Admin Guide mistakenly says that SMP is not available on Linux.
573563 rs_init cannot read root of disk volume(i.e. C:\, D:\, E:\, etc) in Windows when add partition
573779 Informational message 'Upgraded from %1! to %2!" is missing in the upgrade process. Due to this missing the upgrade log will not report completion of upgrading from previous version to new version, which causes confusion for the user.
574053 MICROSOFT SQL SERVER ONLY: When upgrading

multiple pre-15.1 Replication Agent instances to

current release, the upgrade process will fail to

upgrade the subsequent Replication Agent instances

with error "SQL Anywhere Error -103: Invalid user

ID or password".

574054 MICROSOFT SQL SERVER ONLY: Upgrading from pre-15.1

Replication Agent instance (trigger-based

Replication Agent) to current release will fail

with error "No verifiable instance <rep_inst>

exists in directory <...>".

574108 Table name not well quoted in an insert command was sent to standby database.
574137 Template scripts for creating a

Replication Server 15.2 connection

to the replicate are missing from the

$SYBASE/RAX-15_2/scripts (UNIX)

or %SYBASE%\RAX-15_2\scripts (Windows)

directory.

574331 DSI error attempting to connect to RepConnector 15.0.1
574339 RS error 6025 - Block consistency failed - in RS 12.6 EBF 15502 Instrumented binary.
574371 ERROR #60021 after a certain number of connections
574375 sysadmin dump_thread_stacks command in Reference Manual is documented as sysadmin dump_thread_stack
574417 4 bullets in "Unsupported Operations" in Rep Server does not apply to RS 15.2.
574471 ORACLE ONLY: A NullPointerException is thrown

while processing a chained operation that is

rolled back.

574522 Distributor ERROR #30025 and subsequent FATAL ERROR #18028
574523 new feature ... trace_all/create_audit_trail of admin cmds done at the repsrv
574524 sysadmin sqm_purge_queue not error on syntax error if seg, blk, row is added to the command.
574542 when batch set to 'on' more config items most be done to have batches succeed

A)

1) batch set to 'on' ... alter connection to ms2k5srv.mssqldb set batch to 'on'

B) required settings that are missing from our doc presently

2) ecda_service_to_ms2k5srv.mssqldb

{Target Interaction}

DelimitSqlRequests=yes

3) dsi_cmd_seperator set to ';' ... for ms2k5srv.mssqldb connection only ...

alter connection to ms2k5srv.mssqldb set dsi_cmd_separator to ';'

... if this is set globally will cause definite problem with rssd stored in ASE

C) required settings that are mentioned seperately in our doc ...

it would be nice if all this was together in at least one place in our doc ...

4) {Client Interaction}

Transaction Mode = long

5) {Target Interaction}

allocate = connect

SQL transformation = Sybase

D) also PSE was seeing different results with the two options for ODBC drivers provided

by Microsoft on Windows if the customer is using ecda on the windows platform. so

we should maybe mention that customer might want to test both of these drivers to

see if one driver would work better than the other.

6) SQLSRV32.DLL ... this driver is most like the datadirect IVMSSS23.DLL

7) SQLNCLI.DLL ... this is another odbc driver Microsoft provides on windows

574571 'rs_get_errormode' function string is incompatible with RepConnector 15.0.2 and earlier releases.
574603 Internal User Only:

Feature of RAX15.3

Primary/Replicate

Databases Re-synchronization.

574763 test
574805 ORACLE ONLY: Stored procedures fail to replicate

when Replication Agent is initialized with

pdb_dflt_object_repl configuration set to false.

574879 ORACLE ONLY: 'pdb_skip_op filter op' supports

filtering by Oracle SCN number.

574919 MICROSOFT SQL SERVER ONLY: Invoking

"ra_config pds_dac_port_number" command

will return an error "Could not find Resource

Bundle containing index: PDS_DAC_PORT_NUMBER".

574965 ORACLE ONLY: Stored procedures fail to replicate

after issuing "pdb_setreptable all,disable"

command.

575052 Function string option 'output none' doesn't take effect after modifying custom function strings in some cases. The 'set ciphertext on' option is not caught by the replicate Replication Server after the change to rs_set_ciphertext function string causing the incorrect behavior.
575114 Copy shutdown messages in JESMSGLG to LTMLOG.
575199 MICROSOFT SQL SERVER ONLY: "ra_migrate" command

may fail with error "Invalid object name

'ra_xlog_system_'" when migrating pre-15.1

Replication Agent to the current release.

575245 Stereotypes used as metaclass does not have a Browser category in the Repository browser. Also, associated icon is not displayed. The local browser does it properly.
575247 ORACLE ONLY: IndexOutOfBoundsException may be

thrown during LOB processing.

575305 If a user connect over proxy to the repository (MSSQL Server) it takes about 5

Minutes an longer until PD came back. It seems that it take 5 Minute until the Repository tree in the browser is build up and the PD user can work again.

575361 CLOB datatype replicates as image in RS versions 12.6 and earlier.
575366 Documentation to install RAX on different machine from MS SQL is not documented.
575531 ORACLE ONLY: Replication Agent resource file

instance creation fails if the pds_password

configuration property contains lower case

characters.

575552 ORACLE ONLY: Verification of the instance resource

file using ADMIN utility (ra_admin or ma_admin)

fails with Oracle 11g.

575559 When authenticating an SCC Replication resource fails; an uninformative message is being displayed.
575610 After a table replication defition is altered the dynamic SQL configuration is not applied to the named table. The dynamic SQL option may be applied to a different replicate table in the same target database.
575937 Replication Agent does not display a clear error

message when attempting to resume replication

before migrating the instance. The error returned

is "Transaction LogReader Initialization Failed".

575978 Pick up rowcount information when doing SQL Statement replication and use the row count when applying the work at the replicate.
576093 Microsoft SQL SERVER ONLY: In 15.3, Microsoft SQL

Server is not initialized by 'pdb_xlog init'.

Instead, a new command 'server_xlog init' is

introduced to initialize the server.

Description:

Initialize or cleanup the server xlog.

Syntax:

server_xlog [init | remove] [,force]

Usage:

-When you want to initialize the server xlog,

you should run 'server_xlog init'

-When you want to cleanup the server xlog,

you should run 'server_xlog remove, force'

-Moreover, 'pdb_xlog init' will check whether

server has initialized. If not, pdb_xlog

won't run and prompt the user to run

'server_xlog init' first.

576226 Old parameter names in 12.0 and 12.5 referenced in 12.6 and 15.0 documentation
576233 CIMax missing in 15.0 doc, range in 12.6 doc is different than what is released with product; duplicate entry for DateTime_conv_err in 15.0 doc.
576261 Timer check on Open Client check is more frequent
576289 Printing of in-memory trace pool makes Replication Server hang.
576484 Replication Server reports incorrect syntax. Need help in finding the problem.
576582 MICROSOFT SQL SERVER ONLY: 'suspend' command in

Replication Agent may take a long time to complete.

576705 Heterogeneous Guide should have command separator for DB2 z/OS as semicolon .
576773 UDB ONLY: pdb_setrepcol <table_name> returns

incorrect column name information.

576787 UDB ONLY: Invoking 'pdb_setrepcol' command with

'<table>, enable' fails. Replication Agent treats

'enable' as a table name and not a reserved keyword.

577102 ORACLE ONLY: LOB columns may not replicate

when they are in-row and the LOB is updated

with more than 4KB of data.

577111 Incomplete listing of dcany parameters in RSO Quick Start Guide
577316 In SCC 3.0 or 3.0.1, a server(repserver, ase etc) can be registered with a name other than its actual server name and can be authenticated w/o any problems, but subsequent functionality for replication such as displaying replication topology view or viewing dashboard for a replication server fails.
577809 ORACLE ONLY: Invoking 'rasd_trunc_schedule'

command with an invalid date in months does not

return an error.

577818 Replication Agent may fail with error

"QueryException: Offending SQL statement" if

the database name is a reserved keyword in the

Replication Server System Database (RSSD).

578085 Replication Server command "admin stats,status" may fail on the Linux platform.
578305 1. The ct, Samsung SDS, is using PD15 and ORACLE database as a repository database which has charset US7ASCII.

2. If a table or column has a korean character, the charater is broken in the repository database.

3. The ct insist that some tools, such as pb, support dbcs(korean) for us7ascii charset.

And they want to PD reverse feature & repository with us7ascii charset.

578409 ORACLE ONLY: Replication Agent fails to

replicate all the LOB data when inserting more

than 10mb of data into a table containing a BLOB

column.

578673 Override writing skipped transactions and log_first_tran to the Replication Server log or alternative file with trace, DSI_NO_LOG_SKIP_TRAN. Transactions will still be written to the database exceptions log. This trace can be used on both Replication Server executables.To turn on this trace, isql in to the Replication Server and issue the following command:

trace "on",DSI,DSI_NO_LOG_SKIP_TRAN

go

This trace can also be added into the .cfg file.

578717 tinyint datatype needs override in DC MS SQL in rs_subcmp.
578861 rasd_restore sometimes fails to restore the

Replication Agent System Repository.

579396 Admin Guide incorrectly states that SMP is not supported in Linux Edition
579517 RS 15.x documentation reports SMP is not available on the Linux platform
579520 ORACLE ONLY: Blocks of LOB data are dropped by

the Replication Agent when the LOB is updated.

579649 ORACLE ONLY: Replication Agent goes to ADMIN state

with an IllegalStateException for error "Cause

already initialized".

579675 option in Sybase Central to be able to copy the configured servers from one client to another
580220 RS command that can be used to change the name of the server and/or database in the replication system.
580392 If there are multiple replication definitions on the same table in an MSA (multisite availability) environment, text/image columns may not replicate.
580554 console command to turn on the trace, is traceon
580596 sysadmin apply_truncate_table syntax has extra "You" at end of syntax which is incorrect
580774 MICROSOFT SQL SERVER ONLY: Distributed transaction

or Bound Connection transaction causes duplicate

key error similar to "Cannot insert duplicate key row

in object 'lr_reptran_' with unique index

'lr_reptran_x1'".

581027 Add a new repository right that allows the end user to specify 'Manage All Documents' at the folder level.

The customer is requesting the following:

Add feature to control the 'Manage All Documents' right; to be able to assign it to either the root or a specific branch and/or to a specific folder. Once the 'Manage All Documents' right is assigned to a user or group, that user/group can create a folder in any other folder even though he has list or read rights. PD needs to be able to offer more flexibility for the permission control to a folder or branch that way they can designate specific group or a specific user document control within a specific end user environment.

Here is a simplified scenario at our company:

We have 3 folders in this repository (at Default branch): Baseline, CAO, and OPC.

We would like to create a manager to be able to create users and manage only the documents within the OPC folder.

Once the 'manage all documents' is applied to the user, they can add/change folders and documents in other folders in which

they do not have write or full permissions.

Repro:

1. Log into repository with 'ADMIN'

2. Create 3 folders all at the root/Default branch.

REPOS::ADMIN::<Default>

Baseline (folder)

CAO (folder)

OPC (folder)

3. Create a user "testmanager" with the following rights:

Connect, Freeze Versions, Lock Versions, Manage Branches, Manage Configurations, Manage All Documents

note: You could do this with just the 'connect' and 'Manage All Documents' rights as well.

4a. select "REPOS::ADMIN::<Default>" branch in repository browser.

b. right-mouse button (RMB) click <Default> branch and select "Permissions" menu.

c. select 'Show All Authorized User's icon.

d. select the 'testmanager' row and then his permission to 'List'.

e. select the 'Copy Permissions to All Children' which will push this permission down to all other items in this <Default> branch.

5. select OPC folder and right-mouse button (RMB) click it > Permissions and set 'testmanager' to Write or Full.

6. select either Baseline or CAO folder and right-mouse button (RMB) click it > Permissions and you see that 'testmanager'

is set to 'List'

7. Try and add a folder to either Baseline or CAO folders. It is allowed.

The problem is he has rights to manager all documents in the repository and can assign permission to users in all objects in the repository. The user would like PowerDesigner to restrict him only to manage OPC folder. If they give the 'testmanager' "Manager Users" rights, they only want 'testmanager' to be able to assign rights to users within the OPC folder only. In other words, we want local administrator has local rights only.

581059 User id showing for oldest open transaction in e,status, is not same user id showing in e,showrba
581071 RSO 15.2 Quick Start Guide includes section to add the tables to the target MS SQL server which is no longer needed because of connection profiles.
581090 ORACLE ONLY: A NullPointerException on RASD

article cache access stops replication.

581250 Replication Agent Installer welcome

screen contains an incorrect EBF

ONE-OFF id.

581373 ORACLE ONLY: Replication Agent fails

to correctly process an alter table

drop UDD or Xml column.

581376 ORACLE ONLY: Replication of an unsupported column

is not prevented when processing an 'alter table'

DDL command.

581377 ORACLE ONLY: Replication Agent goes to ADMIN

state with an IllegalStateException when updating

an off-row LOB column in a table with both

BLOB/CLOB and long/long raw columns.

581381 ORACLE ONLY: After processing an 'alter

table' DDL command, the LOB replicate status

for the altered table is updated incorrectly.

581414 Replication from ase datatype "time" to oracle datatype "TIMESTAMP6" fails.

Using repdef datatype "time": 'ORA-01841: (full) year must be between -4713

and +9999, and not be 0'. Using repdef datatype rs_oracle_timestamp6:

'ORA-01843: not a valid month'.

581455 Server crashed with Thread dAIO( ) infected with signal 11.
581801 Change instructions to login as "sybase" before setting the SYBASE environment variable.
581813 trace tracepool causes resource chain error message in RS log.
582192 ASE ONLY: CacheStoreException may be thrown when

user executes sp_recompile in primary database.

582326 followup of 580985

Stereotype should be visible on general tab of repository property sheet

582352 When bulk copy feature is used and tempdb is full, transaction does not retry and is missed in replicate database.
582386 In PowerDesigner, end users have the option to display the Name or Code for objects in the Browser. The customer is requesting that this same option be available in the Web Repository.
582388 Show/display the column's datatype when I click on the <<Columns>> item under a table object instead of having to drill down into the Attributes tab page to get to the data type information.

For quick lists, it would be more useful/helpful to see simple details of a column at the column list level of the table (name, code, datatype). We realize that viewing this same metadata connected to the repository in the PD Client interface also presents the same behavior. However, having name, code, datatype and possibly the domain is certainly more useful when seeing the (quick) list of columns on a table than having to drill down into the attributes tab to see even more details of the column object.

582641 Request to add info/link on setting the ReturnNativeError in ECDA to work with RepServer's Native Error Code handling.
582768 Some characters could not be converted into client character set during check in.

Unconverted bytes changed to 'inverted question mark (� U+00BF).

582831 Any IP address whose first node > 127 will fail IP syntax.
582948 When definition of procedure is modified and model is updated in the repository, the extended dependency between that procedure and a table is removed from the repository database.

The Check In window does not show deletion.

583144 Replication Agent is unable to start up

when LD_LIBRARY_PATH_64 environment setting

is defined in the environment.

583240 6025 re-occurred with sqm first_read = next_read ptr
583404 In the instructions to install the EBF are incomplete.

Step 6 states the following:

6. Restore any 3rd party class libraries from the backup in Step 3.

The problem is that the CMR directory does not exist in the webapps directory.

In order to rebuild the cmr directory, you must first restart the server.

Step 5a should be something like:

restart the application server which will rebuild the cmr directory structure.

This would then be followed by step 6.

583459 Some Japanese messages are displayed in utf8 code.
583496 ORACLE ONLY: After restarting Replication Agent,

the mirrored device path information set by the

ra_devicepath command is not retained.

583567 Replication:

Authenticating a Replication Sever before its ASE servers have been authenticated causes a Null Pointer Exception to occur.

583737 rs_subcmp is incorrectly reporting inconsistent rows on text/image columns.
583844 When Replication Server is not available,

executing 'ra_locator update' causes Replication

Agent to throw an exception.

584130 Provide support for SySAM sub-capacity.
584138 RS 15.2 ESD #1 needs updated OCS to complete the fix for 556327 that was delivered in 15.1 EBF 16814
584350 New counter to track number of CLR's (compensating log records) processed.
584351 Feature Request to make RS more robust so that even if it is short on memory or heavily loaded, that it will break out of it's loop to service a login request.
584357 Request for engineering supported, QA'd, and documented procedure on moving the ID server to a new server.
584418 ORACLE ONLY: rs_create_repdef fails to create

replication definition for a table containing

an OBJECT column.

584477 RS error 6025 - Block consistency failed - in RS 12.6 EBF 15502 Instrumented binary.
584529 rs_segments table is corrupted and Replication Server can not process queue.
584548 sqm_cache_enable and sqm_seg_prealloc not added in upgrade to 15.1 or 15.2
585278 ASE ONLY: Transactions made by maintainace user

are replicated to replicate database when primary

data base is in warmstandy mode and

Replication Agent "filter_maint_userid" property

is set true.

585307 Replication Server does not open the partition in DIO mode even though the sqm_write_flush is set to 'dio' on RHEL 5.3 LVM raw block devices.
585332 The timestamp in the

name backup directory

name does not match

backup timestamp.

585476 erssd defrag details need to be documented in Admin Guide
585513 ORACLE ONLY:

RepAgent initialization fails

in Oralce RAC environment.

585802 capability to override stable device processing errors using rows in rs_segments.
585987 TRUNCPT doesn't move and coincides with not getting results from e,status e,logingo and e,showrba console commands.
586049 Added new trace flag RSTICKETTRC to trace

rs_ticket processing in the Replication Agent

system log.

586297 The sp_reptostandby db_name, NONE" isn't executed when db repdef is dropped via Central, then replication setting remains. It should be set to NONE.
586538 ORACLE ONLY: Replication Agent de-initialization

without the force option can be executed

successfully even if marked user tables and

procedures still exists.

586567 Improved the error message returned from executing

rs_create_repdef when Replication Server is not

accessible.

586589 ORACLE ONLY: The ra_updatedevices command does not

load ASM disk mappings from the property file into

the repository.

586675 Replication Server 15.2 > Replication Server 15.2 Configuration Guide for UNIX >

Upgrading or Downgrading an Existing Replication Server

Replication Server� 15.2 for UNIX

Document ID: DC35817-01-1520-01

Last revised: February 2009

...

5.

If the Replication Server uses embedded RSSD, edit the rs_name.cfg file,

where rs_name is your Replication Server:

Add the erssd_release_dir parameter to specify the location of the pre-

upgrade SQL Anywhere. For example:

erssd_release_dir=/work1/sybase/REP-15_1/ASA9

Add the erssd_start_cmd parameter to specify the command to start ERSSD.

Obtain the name and location of the Replication Server you are upgrading,

and the port number of the Replication Server RSSD, from the interfaces

file. You can find an example of the parameter in the Replication Server

log file by searching for 揈RSSD start command�. For example:

erssd_start_cmd=/work1/sybase/REP-15_1/ASA9/bin/dbspawn

-f -q /work1/sybase/REP-15_1/ASA9/bin/dbsrv9

-ct- -ti 0 -x "tcpip(PORT=11751;DOBROAD=NO;BLISTENER=NO"

-o /work1/sybase/REP-15_1/samp_repserver/errorlog/SAMP_REPSERVER.out

/work1/sybase/REP-15_1/samp_repserver/dbfile/SAMP_REPSERVER.db

...

the following line should have a closing parenthesis...

-ct- -ti 0 -x "tcpip(PORT=11751;DOBROAD=NO;BLISTENER=NO)"

586684 customer upgraded from RS 12.6 EBF 15273 to RS 15.2 and they misspelled the two config tokens at the bottom of the config file...

they added the following...

errsd_release_dir=...

errsd_start_cmd=...

they should have added the following spelling...

erssd_release_dir=...

erssd_start_cmd=...

the upgrade process proceeded and gave an error...

CONNECTIVITY ERROR: CT-Library error: 'ct_connect(): network packet layer: inte

rnal net library error: Net-Lib protocol driver call to connect two endpoints f

ailed'.

Press <return> to continue.

586694 Error message in ERSSD server log like "Cannot set a temporary option for user 'rstest_RSSD_prim'".
587237 RS15.2 ESD1 Solaris: silent install does not work
587254 JCL(SQLINIT) and JC:(PINGRS) are empty.
587261 Connection property "Error class" always defaults to rs_db2_error_class.
587383 In RS 15.x still need to increase size for subscription name; repdef can be 255 chars but subscription only 30.
587405 15.0 software has .tgz extension instead of .zip extension.
587412 FTP to mainframe does not complete and cannot find the .docs file.
587537 ORACLE ONLY: Replication Agent sends an incorrect

LTL-formatted string to Replication Server for a

timestamp in a user-defined datatype when

pdb_convert_datetime is set to true. This causes

the Replication Server DSI to go down.

587655 add note that user can revoke sa_role of primary_user after RSSD upgrade is complete.
587679 ASE ONLY: Mirror Replication Agent initialization

fails with error "No entry exists for id <XXX>".

587731 The parameter, dsi_bulk_threshold, is typed as dis_bulk_threshold
587757 After the execution of the 'drop replication definition' command, the

execution of additional commands such as 'create replication

definition', 'drop subscription', etc. may result in a deadlock in the

RSSD. To recover from this behavior, restart the Replication Server.

587816 MICROSOFT SQL SERVER ONLY: Replication Agent

throws a NullPointerException when the

ra_truncatearticles or rasd_trunc_schedule 'force'

command is executed twice.

587910 Additional information on load utility and compressed records.
587913 There is no documentation on the new fucntion class rs_asa_function_class.
587926 no documentation on dist_sqt_max_cache_size.
587931 ASE ONLY: Mirror Replication Agent initialization

fails due to insufficient privilege attempting

to select on the audflags,deftabaud,defvwaud,

defpraud columns against the master..sysdatabases

table and the password column against the

master..syslogins table.

588030 MICROSOFT SQL SERVER ONLY: Replication Agent

returns an unformatted error message "The last

saved truncation point <{0}> is less than database

truncation point <{1}>." when attempting to save

the truncation point that is less than the

database truncation point.

588206 reproduce:

1.go to search after login

2.click any model and input "AnyMetaClass:AnyMetaAttribute LIKE *a*" to search

no result return and there is an error in the tomcat as follows:

588225 ORACLE ONLY: Automatically generated replication

definition is not automtically dropped when table

is unmarked for replication or table is dropped.

588281 Replication Server error class and row count validation for non-SQL Statement replication is not documented in 15.2 NFG
588398 ORACLE ONLY: Replication Agent throws

NullPointerException when trying to dump detail

information of problem log record.

588492 Requesting change behavior, when a User has Read_only access to a Repository Document only.

-> A Prompt for Overwrite if document exists as read-only Version locally.

-> A popup Error Message, when Write to File fails.

-> Clean up the different behavior of Treelist and Menu Options

-> Do not offer Merge Document if User has read-only authorization.

588695 rs_asa_function_class doesn't provide proper rs_raw_object_serialization function string implementation for ASA.
589012 ASE ONLY: Mirror Replication Agent causes

Replication Server to fail with error

"Failed to convert from char type to

numeric type" when replicating with Dynamic

SQL option enabled. It may also cause error

"No value or default value available and

NULL not allowed" when DSI Bulk Option

is enabled.

589328 ORACLE ONLY: National character in user defined

type is not processed correctly.

589841 change rs_ticket_report function string to ANSI standard SQL
590047 ASE dataserver error 323 should be mapped to warn.
590248 create a config option in RepServer to suppress messages like the following from showing up in the RepServer log ...

I. 2009/04/01 14:16:43. Replication Agent version (710) for 'ds.db' does not match the default LTI version for this Replication Server 700 using version 700.

...

590307 Error from upgrading repository MS SQL database From 15.0 EBF 8 to version 15.1

*** Executing SQL statement 20:

alter table PMBPMS add AVSN varchar(254) null

[Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared.

SQLSTATE = 37000

*** Executing SQL statement 27:

alter table PMDVTL add AVSN varchar(254) null

[Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared.

SQLSTATE = 37000

590417 ORACLE ONLY: A new option has been added to

'ra_dumptran' that allows the user to obtain

detailed information about database operations

and database operations in a transaction by

specifying the Oracle transaction ID.

Command ra_dumptran

Description:

Command ra_dumptran dumps all operations for a

specified transaction to an exclusive log file

in order to help trouble shoot a failed

operation, or transaction. The time the

transaction was executed, the user that executed

the transaction, the name of the log the

transaction was dumped to, and additional

database specific information is displayed as a

result set.

If the Oracle script

$ORACLE_HOME/rdbms/admin/dbmslm.sql

has not been installed at the primary database,

an error will be reported indicating it must be

installed in order for the ra_ dumptran command

to properly operate.

If the new permissions that must be granted to

the "pds_username" are not granted at the time

ra_ dumptran is executed, an error will be

reported indicating the following permission's

must be granted before the ra_ dumptran command

will properly work:

EXECUTE_CATALOG_ROLE TO PDS$USER;

SELECT ON V$LOGMNR_CONTENTS TO PDS$USER;

SELECT ON V$LOGMNR_LOGS TO PDS$USER;

SELECT ANY TRANSACTION TO PDS$USER;

If a public synonym that must be created for

"SYS.DBMS_LOGMNR" is not created, an error will

be reported indicating that "DBMS_LOGMNR" does

not exist.

CREATE PUBLIC SYNONYM DBMS_LOGMNR FOR SYS.DBMS_LOGMNR;

Syntax: ra_dumptran "opid | locator | xid"

Opid - The Replication Agent operation id for a

database operation

Locator - The Replication Agent locator for a

database operation

Xid - The Oracle transaction ID for the

transaction

Example 1:

ra_dumptran

0x0000.01542e48.0001:0001.000002dc.00000004.0010

This command returns information for the begin

operation in the transaction specified by an

operation ID.

Information for every operation in the transaction

is written to a file in the Replication Agent log

directory. The file is named with the prefix

"XID" followed by the transaction ID and ".log".

Example:

$RAX_DIR/<INSTANCE_NAME>/log/

XID0005.002c.0000002c.log

Example 2:

ra_dumptran

0000000001544ada00060001000002de00000008001000000

000000000000000

This command returns information for the begin

operation in the transaction specified by an

locator.

Example 3:

ra_dumptran 0x0007.002a.000032f0

This command returns information for the begin

operation in the transaction specified by a

transaction Id.

Usage:

The ra_dumptran command returns the following

information for the begin operation specified by a

locator or operatin ID:

- The Replication Agent operation id for the

transactions begin operation in the format:

wrap.scn.subscn.thread.lsn.block.offset

- The Oracle SCN for the transactions begin

operation as logged in a redo log file

- The Oracle id for the transactions begin

operation

- The name of the user that executed the

transaction

- The date and time the transaction executed

- The Oracle thread that transaction was executed

on

- The Replication Agent command that will cause

the transaction to be skipped by the Replication

Agent while replicating

- The name of the file the transaction is written

to

The ra_dumptran command wtites the following

information for for all operations in

the transaction specified by a locator or

operation ID:

- The Oracle SCN for the operation as logged in a

redo log file

- The Oracle thread that operation was executed

on

- The Replication Agent operation id for the

transaction begin operation in the format:

wrap.scn.subscn.thread.lsn.block.offset

- The Oracle id for the object the operation

affected

- The Oracle name of the object the operation

affected

- YES if the object in the operation is marked

for replication by the Replication Agent, No

if it is not marked for replication

- The operation type, i.e. INSERT, UPDATE, DELETE

- The Oracle SQL statement for the operation

590677 rs_init with "Initialize standby using dump and load" = yes, does not create the maintenance user on the standby server.
590802 New Feature ..edit server event trigger script to change location/name instead of drop and re-add
590833 ORACLE ONLY:

Replication Agent supports

replication from Oracle

archive logs only (no online).

590908 FOR ASE ONLY:

Add new LTL trace to trace

begin/commit/rollback only.

The trace name is LTITRACETRAN.

591008 DB2 DBRMLIB library name no longer needed for installation and configuration.
591251 A new state Replication Down has been added

that will be entered whenever an error occurs

during Replication. In addition, all commands

and properties that were restricted to ADMIN

state are now also editable in Replication Down

state.

591679 ASE ONLY: Replication Agent provides two new API

command, ra_deviceoffset and ra_helpdeviceoffset

to set the raw device offset and provide help on

the raw device offset setting.

591804 ORACLE AND MICROSOFT SQL SERVER ONLY:

rasd_restore sometimes fails to restores the

Replication Agent System Data Repository.

591805 ASE AND ORACLE ONLY:

rasd_restore sometimes fails to restores the

Replication Agent System Data Repository.

591806 ORACLE AND MICROSOFT SQL SERVER ONLY:

Invoking 'rasd_trunc_schedule' command with an

invalid date in months does not return an error.

591808 ASE AND ORACLE ONLY:

Invoking 'rasd_trunc_schedule' command with an

invalid date in months does not return an error.

591823 admin config "connection" does not display results unless the connection has been resumed (not necessarily successful) since last reboot
591888 ORACLE ONLY: Marking a table with

securefile LOB and LOB fragment

defined in encrypted tablespace

is successful when it should not

be allowed.

592227 The rasd_trunc_schedule command does not return

after attempting to add a schedule date for every

31st day. The schedule looks like "* * 31 * Mon".

592270 After DB2 crash, transactions started before the crash are still open, when DB2 has them either aborted or committed.
592359 The rasd_trunc_schedule add command sets the next

execution time to the next hours/minutes beyond

the current hours/minutes if the hours and minutes

fields in the schedule have multiple values. When

the schedule time is not the current date, and

the smallest value contained in the schedule is

smaller than the current time, the next execution

time picked up by Replication Agent is not the

earlier time in the schedule.

592441 With dynamic SQL, Replication Server stacks when inserting into a table that does not exist.
592471 ASE ONLY: 'suspend' command in Replication Agent

may take a long time to complete.

592746 In testing this issue, I executed verify Repository data and I get the following result:

PowerDesigner Error:

Missing Parent Relationships (Object without parent): 6344

592898 ENH: Offer more meaningful error messages to PD client when a check-in (consolidation) fails with "The check in of the document has been cancelled."

There is very little to go by to troubleshoot and address such a problem. Especially, when the ct. cannot provide their model or repository database to us.

Here is the full message presented to their PD client in the Output windowpane:

Checking in the document

'D:\Documents\DataModeling\PD15test.oom'

- Freezing the repository document before check in...

- Checking out the repository document 'PD15test'...

The check in of the document has been cancelled.

592961 Power Designer has to be killed from task Manager, if there is a Problem in communication with an Oracle Repository either due to a connectivity issue or becaue of the try to check in a corrupt modell. In this case a Modell was corrupted and for somewhat reason had 2 identintical unique key values.

Checking in the corrupt model in a connection to the Repository without using the Proxy throws and Error and Powerdesigner keeps on reacting

593037 After adding subscription, Replication Server crashes.
593151 When dynamic SQL and minimal columns are used together, Replication Server reports 'Incorrect syntax near 'FAILED' on update command with only identity column in the set clause.
593249 When using dynamic SQL to ASE and there is a deadlock at the replicate, the command(s) prior to the deadlock within the same transaction are not applied.
594039 The SAMPLE_RS cannot be created by 'rs_init' if the environment variable

LD_LIBRARY_PATH_64 is set and does not contain the correct pathnames.

To work around this issue, prior to starting 'rs_init', merge the values

of the environment variables LD_LIBRARY_PATH and LD_LIBRARY_PATH_64 and

set both environment variables to this merged value.

594062 If the Replication Server 15.5 Installer response file is created to

indicate that the installer should start the SAMPLE_RS during a silent

install, the installer fails to do so.

594341 deadlock of rs_oqid and resume queue, results in un-applied transactions as duplicates.
594417 After the Replication Server 15.5 Installer has completed the creation

of the SAMPLE_RS, the subsequent installer panel incorrectly enables the

'Previous' button and allows the user to navigate to the previous panel

to create the SAMPLE_RS again.

594420 When the Replication Server 15.5 Installer is used in console mode and

completes with non-critical errors, the contradictory messages 'Press

Done to quit the installer' and 'PRESS ENTER TO EXIT THE INSTALLER' are

incorrectly displayed.

594431 The Replication Server 15.5 Installer does not present a panel that asks

the user for the location of a Replication Server 15.5 license file.

Thus, the installer is unable to install the license file for the user.

To work around this issue, after the installer completes successfully,

the user can manually copy the license file to the directory

'$SYBASE/SYSAM-2_0/licenses'.

594596 When Replication Server is configured to use Warm Standby or MSA, the

error messages '(HVAR Error) ...' may appear in the Replication Server

error log. To recover from this behavior, issue the 'create replication

definition' command with the 'send standby' clause for the primary table

referenced in the error messages.

594644 CMR throw exception if using repository on DB2. During installation tested JDBC connection is okay.
595544 sp_reptostandby documentation not updated for SQL Statement replication.
595627 sysadmin hibernate_on may result in loss detection
595628 sysadmin hibernate_on may result in 'loss detection' when repserver has routes
596041 sysadmin hibernate_off takes too long to complete.
596062 rs_init attempts to use command, admin version against the ASE server
596098 ORACLE ONLY: The warning information for

insufficent privileges during Replication Agent

initialization lists 'EXECUTE on DBMS_LOCK'

privilege twice.

596157 ORACLE ONLY: Re-initializing Replication Agent

by issuing "pdb_xlog init, force" command causes

rs_ticket to stop working.

596365 ORACLE ONLY: Replication Agent throws an exception

when rescanning a DML log record on a table

containing a LOB column.

605455 ORACLE ONLY: Oracle LOB scanner sorting error

stops replication.

605779 smtp test connection failed when host requires authorization
605846 ORACLE ONLY: The chained-operation error

"Processing has not completed for chained op"

sends Replication Agent into the ADMIN state.

605854 After install of ESD1, some files are read only, causing ESD1.1 install to fail.

"find ${SYBASE} ! -perm -200 | xargs chmod u+w" to workaround.

606051 add documentation steps to reset the transaction log for an ERSSD, which may be necessary in a recovery situation.
606055 request the next release of RS contain the latest EBF for ASA (SQL Anywhere).
606069 When queue is full, RS will hang on sysadmin sqm_purge_queue or shutdown.
606439 RSM Server may become unresponsive and use 100% CPU if it's connection to a Replication Server fails.
606496 Invalid value for dsi_max_xacts_in_group produces 5161 message indicating wrong parameter and wrong value range.
606611 When Replication Server is configured to use Warm Standby, the 'sysadmin

cdb ...' command does behave as expected.

606691 In a 3-tier replication management environment, the Replication Manager Server (RMS) does not display the newer Replication Server parameters. The workaround is to add the Replication Server to a 2-tier environment.
606724 Replication Server will fail to replicate to an IQ server if the

replicated table name or replicated column name is specified with quoted

identifiers.

606824 Customer is attempting to install a new repository on ASE 15.0.3 using the ASE native driver. During the installation, a conversion error occurs.

*** Executing SQL statement 7001:

insert into PMENUM(CLSS,ENID,VALU,RVAL) values(1421, 1, '€', 'EUR')

Error converting characters into server's character set. Some character(s) could not be converted.

End result is that the repository is not created.

Workaround:

Use an ODBC connection to create the repository

606836 DOC RepSrv ... specifics on how to create repdef to handle non dbo table in MSA

Add a section giving examples that show the nuances of combinations between a MSA_dbrepdef and table rep defs...

The main point is to communicate that one should be careful. The best choice is to explicitly specify the OWNER of the table in table rep defs and use sp_setreptable with owner_on to prevent any unsuspected results...

606838 ASE 15.0.2 and ASE 15.0.3

When PD is launched, you are able to connect to the repository via an ASE native driver profile. If you disconnect from the repository and attempt to connect a second time, the repository connection fails. The reported error reads:

Unable to initialize Client Library context.

The problem appears to be introduced after the first disconnection from the repository. As long as I do not disconnect from the repository, I can make multiple ASE connections using the native driver. for example, I am able to reverse engineer a database and I can connect, disconnect and reconnect without issue.

606980 Replication Server will fail to replicate an UPDATE to a JAVA column

because the Replication Server incorrectly treats the JAVA column as an

IMAGE column. To work around this behavior, mark the table as

non-compilable.

607009 Oracle10g Native connection:Version comment is not saved in repository
607046 Minimum year is not working on date columns.
607183 When Replication Server is configured to use Warm Standby, the 'sysadmin

cdb ...' command does not behave as expected. Under certain

circumstances the 'sysadmin cdb ... dump_i ...' command will return the

error message 'Error occured while processing 'sysadm cdb' command'.

When HVAR is disabled, the 'sysadmin cdb ...' command is incorrectly not

disabled.

607212 Attempting to consolidate (check in) a multi-model report, MMR, and the consolidation is canceled when 'File' is selected under local document.

Workaround:

open the MMR in the workspace and then consolidate the mmr.

607273 rs_helprep on pre ase15 rssd fails identifier is too long maximum length is 30

C:\oc15e7\OCS-15_0\bin>isql -Ss6s1254e91ss -Usa -P -w2048 -Drs3s151ss_rssd

1> select @@version

2> go

-----------------------------------------------------------------------------------------

Adaptive Server Enterprise/12.5.4/EBF 16816 ESD#9.1/P/Sun_svr4/OS 5.8/ase1254/2146/

64-bit/FBO/Wed Apr 15 14:39:31 2009

(1 row affected)

1> rs_helprep test123456789012345678901234567890_rd

2> go

Msg 103, Level 15, State 1:

Server 's6s1254e91ss', Line 1:

The identifier that starts with 'test12345678901234567890123456' is too long. Maximum length is 30.

1> rs_helprep 'test123456789012345678901234567890_rd'

2> go

1> quit

C:\oc15e7\OCS-15_0\bin>

607423 Enable replacement of model-versions in a configuration
608065 Specific to PDes 15.1 EBF2.

White/gray area replaces the "Compare Models" dialog while comparing local model with repository.

608153 Provide Monitors and Counters so that a customer knows how much memory is currently allocated by a thread or module.
608155 Bulk copy uses extra memory taken from general memory pool and need to find out who is requesting the extra memory.
608357 MSA with table repdef, an update causes ASSERTION FAILED error and the DSI shuts down. This occurs when the table contains an identity column and a timestamp column, the timestamp column is not included in the repdef, and the update sets the value in a non-timestamp column to it's same value.
608744 More details in RS's log about procedure that caused DSI to be down
609020 Feature Request: Better Management of the RepConnector serialization file
609106 Change heading to more accurately reflect the command: Create connection using profile
609279 rs_init fails when attempting to install new repserver or add a database when there are duplicate entries in the interfaces file.
609309 msa ... when there are two db repdefs ...

one primary db with two db replication definitions each with filters and each replicates to a seperate replicate database. if the 2nd db repdef's filter is modified by RM or isql, the 1st db repdef's filter stops working.

609448 arithmetic overflow errors executing rs_stat_populate
609451 using rs_init to upgrade ERSSD to 15.2 reports:

2009/11/30 12:36:55 ASA Warning 120: 'tsql_outer_joins' is an unknown option

This is just a warning and the upgrade completes successfully.

609538 ERROR #14023 SQM had an error writing to the inbound-queue in rs_init on the Rep Agent of RSSD.
609795 When Replication Server creates a connection to an IQ server, the error

message 'ASA Error -141: Table rs_update_thread ...' may appear in the

Replication Server error log. This behavior is caused by Replication

Server issuing an incorrect command to the internal ASA server embedded

within the IQ server. To recover from this behavior, connect to the IQ

server and issue the 'grant execute on rs_update_thread to public'

command.

609957 ORACLE ONLY: Inserting data greater than 4KB into

an Oracle LOB causes an OracleRuntimeException to

occur which stops replication.

610106 Specific to Proxy.

Check in a model in the repository. Compare local model with repository. PDes has detected slight differences on Position and Size on objects.

It occurs only when check in mode is Update, through a Proxy connection. No problem using a Direct connection.

610511 rs_init fails: 'OS returned: Value too large for defined data type'
610551 Replication Server consumes 100% CPU because of an internal deadlock.
610780 Number of prim users increase with number of databases connected to RS.
610969 Need additional documentation on xpdl and process for use on primary database, with warm standby and msa.
610973 performing an update of a varchar column, if the first character is a parenthesis '(' or a comma ',', immediately following by a line feed, RepConnector gets error and DSI shuts down.
611029 RMP [RepManager Plugin] ... do same login retry ASEP [ASE Plugin] uses when default code page on server is roman8

The ASEP handles this situation in a graceful way and switches to using the iso_1 code page. It would be great if the RMP would do the same graceful handling of this same situation.

611031 RMP Explain the limitation of java/jdk excluding support for roman8 code page

Replication Server� 15.2 Administration Guide: Volume 1

DOCUMENT ID: DC32511-01-1520-01 LAST REVISED: February 2009

Explain the limitation of java/jdk excluding support for roman8 code page when Sybase Central and RMP Replication Manager Plugin are used in conjuction to attempt a login to an ASE/RepServer server that is using the defualt code page of roman8.

The customer needs to be aware that even though roman8 is listed in the drop down list of possible code page choices when making a server connection in the dialogue where the username and password are being requested ... choosing roman8 as the manually select code page will cause a connection failure since java/jdk excludes support for the roman8 code page.

611175 Replication Agent unexpectedly crashed

with errors like "Pid <pid> was killed

due to failure in writing to user

register stack - possible stack

overflow." when command "pdb_xlog init"

is executed on HPIA 64-bit machine.

611419 RMP ... change heading in queues dialogue from "size" to "# of segments in use"

the customer is thinking this showing him how much space is being held up in the

inbound queues by transactions that still need to be removed from the stable queue

and delivered to the dsi ... replicate ds.db

611422 RMP ... add a "size" column for size space held by inbound q by xacts

Refer to CR 611419

the customer is thinking the present "size" column is showing him how much space is

being held up in the inbound queues by transactions that still need to be removed

from the stable queue ... it would great if we could rename the present column to

"# of segments in use" and create a size column based on the difference between

Last Seg.Block and First Seg.Block ... also when Next Read is after the Last

Seg.Block this confirms the inbound queue is drained completely.

and delivered to the dsi ... replicate ds.db

611436 RepSserver SYSAM 2.0 provide support for Solaris zones with served CPU licenses
611622 RepServer crashes with stack/core after deadlock on replicate ASE db.
611923 Replication Server reports 6025 error when doing consistency check on blocks in the stable device
612174 sysadmin dump_queue reports " The packer ran out of bytes while unpacking a command " in the RS log.
612220 Print of in-memory trace pool hangs Replication Server because the signal handling function inside Replication Server ignored most of events generated by Windows OS.
613213 When a new table and repdef are added for replication to RepConnector, the first txn will have dbid=0 in the eventID.
613246 ASE ONLY: Improve performance caused

by frequent access to the Replication Agent

System Repository (RASD) while processing

operations on tables that are not being

replicated.

613457 The "max" datatypes in MS SQL cannot be replicated to any other DBMS other than MS SQL.
613654 Support function strings in RTL.
613696 jConnect warnings that may usually be ignored

are now logged only if RACONTRC trace is enabled.

613849 Retrieve and report Connector version in Rep Server log.
614006 Customer is running 15.1.0 EBF4. However, their repository was created in 15.0.0.2613 (GA). When they connect to the repository via CMR and expand the models via the Repository Explorer, the models appear nested and is listed twice.

For example:

Default

->Folder

->->Project Management(CDM).cdm - v1

->->-> Project Management(CDM) - v1

Note: first reference includes model extension

Using the following steps, I was able to reproduce this issue:

Created a brand new database instance on MS SQL Server 2005

1) install PD15.0.0 GA

2) create repository

3) in repository, create folders CDM and PDM

4) open project.cdm and check-in to CDM folder

5) open project.pdm and check-in to PDM folder

6) in repository, create user tony

7) install CMR 15.0 GA

8) connect via CMR using login tony (same results using ADMIN login)

614110 Check-in prompt behaviour changed between V12 & V15
614408 Multiple source databases with same-named tables replicating to single RepConnector DSI causes eventId to contain incorrect source dbid.
614572 When consolidating an Oracle table with a column that has a blank space not delimited by quotes set as default value, the default value is not consolidated.
614808 For Configurations, the Associated Folder information display is inconsistent. Connecting to the same repository, with the repository and database login and same ODBC driver displays different results when connecting to the repository from different PC clients.

The customer's document, includes screen shots showing the list of configurations. In one image, the Associated Folders field is blank for all configurations. In the second image, three configurations have an associated folder listed. In both images, the customer is connecting to the same repository with the same user. The only difference is that they are using two different PC clients.

Using the following repro, I get similar behavior.

Repository structure is

ROOT

-CDM Folder

--CDM model

-PDM Folder

--PDM model

To reproduce:

1) Connect to repository from PC_1 using ADMIN login

2) Right click on existing folder and create configuration

3) Select Repository -->Configuratiosn and display Associated Folder column Note: the column is populated

4) Connect to repository from PC_2 using ADMIN login

5) Select Repository -->Configuratiosn and display Associated Folder column Note: on PC_2, the folder name has become Folder_1 杤1.1 while on PC_1 it is CDM 杤1.1

For this repro, the configuration was created on a Vista workstation (PC_1) with MS SQL Server as the backend. The version of the SQL Server driver version is 6.00.6002.180005.

For PC_2, a XP workstation is used and the SQL Server driver version is 2000.85.1132.00.

Connected to repository from a third workstation using a different database login and SQL Server driver version 2000.85.1132.00. The connection displays the Associated Folder the same as PC_1.

For the customer they are reporting that the associated folder information is missing. While on the phone teh customer was able to repro this on 15.0.0.

614978 In the CMR UI, rename 'Attributes' to 'Properties' on Repository Object Properties.

The repository objects do not have attributes. They only have properties.

614983 Feature Request that RepConnector runs listener on a specified interface ip-address instead of all interfaces on the local machine.
615006 Replication latency monitoring does not include the day in the time difference and incorrectly handles the cross over from/to AM and PM in the time difference.
615257 The ra_helpdevice command always shows ASM disk

mirror paths as 'NOT_CONFIGURED'.

615258 MICROSOFT SQL SERVER ONLY: Replication fails for

a table containing more than 8 text columns.

615260 Customer's repository structure has nested folders with multiple folders at each nested level. In some cases, there are 40 - 50 folders with nested folders and models. In Internet Explorer 7 or 8, when you navigate to a folder/model and then select the folder/model, the vertical scrollbar resets to the beginning (top). The expectation is for the scrollbar to maintain its position next to the selected folder/model.

If the same is done in Firefox 3.5.7, the vertical scrollbar maintains the current position.

615267 After "ra_updatedevices" executes successfully,

a NullPointerException is thrown from

OracleDatabaseContext.getID when Replication Agent

attempts to resume replication after a restart.

615270 The C,HELP command shuts down the Rep Agent with a return code 8.
615392 ExtInRep Exception on checkin a model with extension on ASE through proxy

checkin the model in an ASE repository using proxy connection

Because of no support of "Max byte per char"

615486 Incorrect default displayed for dsi_quoted_identifier
615577 MICROSOFT SQL SERVER ONLY: Replication Agent

instrumented triggers fail to open cursors

in the same user session after it is fired

for a SQL statement affecting no rows.

615663 ASE ONLY: Replication Agent does not start

reading from the device offset value set in

the ra_deviceoffset command when the

log_read_block_count configuration property

is set to a value greater than 1.

615838 The customer would like the ability to view the contents (details) of any external file that is consolidated (checked-in) to a repository.

For example, if a MS Word document or Excel spreadsheet is checked-in to the repository, when they select this link in CMR, they would like/expect to see the contents of the MS Word document or spreadsheet.

615964 ASE ONLY: Mirror Replication Agent goes to ADMIN

state with IllegalArgumentException from

ds.ase.device.Page.getBufferSlice() error.

616051 In a 3-tier replication management environment, the Replication Manager Server (RMS) does not display the newer Replication Server parameters. The workaround is to add the Replication Server to a 2-tier environment.
616055 Rep Server version 15.5 introduced a new configuration parameter named "block_size". This parameter is not supported in the GA 15.5 version of RMP. There is a change to the configure replication server API that cannot be supported for this particular parameter in RMP. As a result, when trying to configure this parameter within RMP, the following error will be displayed: "Option WITH SHUTDOWN required for block size change"
616057 The Replication Server configuration parameter "block_size" cannot be configured by the Replication Manager Plugin.
616220 Replication Server was unable to connect to target server because of Open Client/Server library CR 550282 - NETLIB: On HP 11.31 and later, ct_connect() fails intermittently with error EISCONN. This CR 616220 was opened to pull in the new Open Client/Server library 15.0 ESD #17 with the fixing of CR 550282 into Replication Server to address this issue.
616508 Replication Agent fails to handle lost connection

caused by network issue.

616727 RS gave signal 11 in mem_free() or signal 6 in free() during restart
616891 The RS 1550 installer for Solaris Sparc 64 incorrectly omits the

installation of the Unified Agent Framework.

616909 ASE ONLY: Replication Agent introduces a new

Log Reader statistic "Last page scanned" which

displays the most recent page scanned from the

device log.

Log Reader statistics for ASE

Component Statistic Description

--------- ----------------- ---------------------

LR Last page scanned Block and page number

of most recent page

scanned from log

devices.

616924 ASE ONLY: Replication Agent spins at the same log

page while ASE is already writing to a new log.

616929 ASE ONLY: Mirror Replication Agent logs an

incorrect truncation point value displayed

for a move truncation point trace message.

616932 The RS 1550 installer for Solaris x86 64 incorrectly omits the

installation of the RMS Agent for the Unified Agent Framework.

617011 When replicating to IQ, Replication Server inexplicably fails to

replicate any and all grouped transactions. In order to replicate them

successfully, Replication Server is forced to ungroup the transactions.

617022 ORACLE ONLY: Replication Agent stops replicating

and reports "java.lang.IllegalState Exception:

No applicable system object found" for DDL

commands when processing large create global

temporary table DDL commands in the redo log.

617406 Signal 11 in function _sqt_check_bulk() when bulk is enabled.
617445 ORACLE ONLY: Replication Agent fails to replicate

NCHAR data correctly when there is both a database

level and a table level replication definition.

617530 ECSA memory is not freed when RA DB2 shuts down.
617535 Support_DB2_comp_rec description of options is opposite of how it behaves.
617567 Time portion of column of datatype TIME is zeroed out when minimum_year is invoked on another column.
618015 Time is not being converted to LTL properly, it is always 00:00:00 when mimimum year is used to add a default date in the datetime field.
618045 Startup fails. Attempting to use RS_charset=cp1251, RS_sortorder=rusnocs. Raising error: INTERNAL ERROR #52 : Failed to map a local name to an object id!
618437 rs_lmconfig utility to configure license management-related information
618624 multiple srv_spawn errors will stack RS.
618812 Customer is requesting for the ability to control (enlarge) the diagram window size on CMR (more than just zooming in/out)

The customer feels that the SVG option is not enough. They would like the ability to resize the control area where the diagram is viewable.

618835 The Replication Server crashes due to a signal 8 in sqt_LoadCache() if Parallel DSI and SMP are enabled.
619049 In an RMP environment that contains multiple warm-standby pairs, if you select multiple logical connections and choose "switch active" so that they all attempt to switch simultaneously, the following error message appears: "Internal Error - Sybase Central".
619074 ORACLE ONLY: Replication Agent goes to the ADMIN

state when replicating an insert or update for a

table containing a nested table column.

619161 Allow DDL to be applied with a different user id than what was at the primary.
619180 updates on pdb_setrepddl doc include ensuring that the database replication definition with DDL enabled exists if use_rssd is true PRIOR to resuming the Replication Agent, and the disclaimer that the syntax of the DDL command that is being replicated must be compatible with the syntax of the replicate DBMS.
619187 MICROSOFT SQL SERVER ONLY: When the pdb_get_column

command is executed, Replication Agent

fails with a NullPointerException.

619248 Replication Agent does not properly handle

accumulating SySAM unserved licenses if there is

more than 1 license file with unserved CPU

licenses.

619290 pdb_setreptable query has incorrect column names in the query against Oracle
619372 During the check-in or check-out of a document, the Folder list is not sorted in alpha order. Instead, the folders are listed in the order in which they were created.

To reproduce:

1) create a repository

2) create the following folders in this order

a) zeta

b) alpha

c) theta

d) beta

3) refresh the repository browser NOTE: the folders are sorted in alpha order

4) consolidate or extract a model

5) In the Check-In or Check-out window, select a Folder

NOTE: the folders are listed in the order that they were created

619602 Update of a text column value to itself causes RepServer to stack and core dump.
619726 ORACLE ONLY: Replication Agent goes to

REPLICATION DOWN state because a table replication

definition is not found. This will occur if both

the column_compression and ltl_send_primary_keys

configurations are enabled and if a database

replication definition does not exist.

619757 Dynamic call to turn on RA DB2 traces is traceon= .
619941 The files '%SYBASE%\REP-15_5\doc\errmsg.rs' and

'%SYBASE%\REP-15_5\doc\errmsg.sub' are re-named

'%SYBASE%\REP-15_5\doc\error_messages_rs' and

'%SYBASE%\REP-15_5\doc\error_messages_subcmp',

respectively.

619964 create source ... should be changed to ... connect source ...in rs_tvalues tbl

when using rs_helpuser in the RSSD and a user has been granted both ...

connect source

create object

... permissions the one may see the following incorrect result ...

isql -Srs3x152e11sx_erssd -Urs3x152e11sx_RSSD_prim -Prs3x152e11sx_RSSD_prim_ps -w2048

1> rs_helpuser

2> go

Users and Privileges Known at Site rs3x152e11sx

Primary Users

User Name Permission(s) Name

------------------------------ ------------------------------

...

rs3x152e11sx_rsi create source, create object

620117 RS runs out of memory with dsi_bulk_copy on.
620213 ORACLE ONLY: Replication Agent fails to resume

after moving the truncation point and setting the

value of the LTM Locator stored in both the

Replication Agent and the Replication Server to

zero.

620279 Subscription name length extended to 255 characters.
620380 Cannot re-create the RS when RSSD exists and "create RSSD" is no.
620657 The SCC server console occasionally displays the message "JZ0C0: Connection is already closed".
620673 Loop on update(2) record
620759 MICROSOFT SQL SERVER ONLY: Updating a text column

value to itself is replicated as partial update.

620844 Message number (EG, LTM01011) should always be the first lexical element
620882 After installing Replication Server 15.2 ESD#1.1 to 15.2, the message "RSSD has been upgraded to support bulk error action mapping." is printed out.

This message should be printed out as an informational message.

620978 Request to get a PDes warning before consolidate if object comment > 2000 characters
621036 MICROSOFT SQL SERVER ONLY: "server_xlog init"

fails with Incorrect syntax near '@tabid' error.

621068 Activate and validate subscription syntax shows that it can be used with database replication definitions.
621218 When upgrading to Replication Server 15.5 fails, it will fail again if retrying upgrade.
621678 add instructions to Replication Administration Guide to remove secondary trunc point from replicate MSA db log. This is only for the "define subscription ... use dump marker" scenario, involving a dump/load copy of the db from the primary to the new MSA replicate.

customer's who setup MSA replication can possibly encounter the following

situation.

The dsi to the replicate abnormally stops because the ASE log on the replicate

fills up and requires manual intervention to get the secondary trunc point

removed ... the customer wishes they had been alerted to this situation

by the documentation

add instructions to remove secondary trunc point from replicate MSA db log

here is the present documentation...

****************************************************************************************

****************************************************************************************

Replication Server� 15.2

Document ID: DC32511-01-1520-01

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32511.1520/

html/rsadmin_vol_1/rsadmin_vol_1540.htm

Chapter 12: Managing Replicated Objects Using Multisite Availability

Subscription with bulk materialization

...

1.Dump PDS.pdb. The DSI connection to the replicate database is suspended when the dump marker reaches the replicate Replication Server. It is suspended so that no data will be replicated until you finished step 2. Replication Server activates and validates the subscription automatically when the dump marker is replicated.

WARNING! Do not activate subscription or it will override the wait for dump marker at the Replication Server.

2. Load PDS.pdb to RDS.rdb.

3. Resume the DSI connection to the RDS.rdb.

****************************************************************************************

****************************************************************************************

here is a proposed set of instructions for the documentation change...

Chapter 12: Managing Replicated Objects Using Multisite Availability

Subscription with bulk materialization

...

After you define the subscription:

1 Dump PDS.primary_db. The DSI connection to the replicate database is

suspended when the dump marker reaches the replicate Replication

Server. It is suspended so that no data will be replicated until you

have finished step 2. Replication Server activates and validates

the subscription automatically when the dump marker is replicated.

Warning! Do not activate subscription or it will override the wait for dump

marker at the Replication Server.

2 Load PDS.primary_db to RDS.rdb.

3. Online RDS.rdb

4. Prepare the RDS.rdb as a replicate:

release the secondary truncation point with dbcc settrunc ('ltm',ignore)

optionally, disable the Replication Agent

dump the transaction log

5 Resume the DSI connection to the RDS.rdb.

621843 ASE ONLY: Mirror Replication Agent goes to ADMIN

state with an error message similar

to 'IllegalArgumentException: Invalid starting

row for page' after resuming.

621876 Repconnector needs Kerberos support
622028 When trying to upgrade from RS 15.2 to RS 15.5 using rs_init, upgrade can sporadically fail with the following message when it tries to check if rs_updown_status table is available in the rssd database and does not find it there:

Cannot drop the table 'rs_updown_status', because it doesn't exist in the system

catalogs.

To workaround this issue, a dummy table rs_updown_status should be created in the RSSD and upgrade should be re-done.

622155 RA DB2 says tablespace not available
622203 ASE ONLY: Replication Agent stops replicating with

"Transaction LogReader received notification of an

unexpected Thread Death ..." error.

622282 In RepServer 15.2 Reference Guide, Chapter 7 "Executable Programs", "rs_subcmp" section:

The "Syntax" part which list a summary of all parameters usable for "rs_subcmp" command, paramter "-h" and "-H" are missing.

Theses 2 parameters are present in the "Parameters" part which describe in detail usage of each parameter.

622542 LTM01014 message contains truncated RS name
622554 For a path that includes an indirect route, the Path Dashboard opens but displays a blank screen with an error in the status bar stating "Error retrieving attribute or data: <path_name>".
622583 Provide more intelligence in the code, before stopping the RAO.
622586 pdb_skip_op command required double quotes instead of single quotes.
622588 Include the xid, transaction id, in the error message to the RAO log. This will make one less step in trying to find the begin, or all commands in a transaction.
622738 Add extra message about RASD being out-of-syn when doing pdb_xlog init, move_truncpt
622748 ORACLE ONLY: DDL transaction which belongs to

maintenance user was not filtered when

filter_maint_id was true.

622904 Enhancement to use the "shortened version" of LTL for a change which includes only primary keys and changed columns
622921 For a path that includes an indirect route, the Path Dashboard opens but displays a blank screen with an error in the status bar stating 'Error retrieving attribute or data'.
622946 RS password containing numerics results is invalid login.
623129 Replication latency monitoring does not show any data when the replicate database is IQ.
623424 Customer would like the ability to define/add a comment on a folder in the repository.
623474 RS will not accept new connections while the sqt is removing transactions from the DSIE
624026 ORACLE ONLY:If the supplemental logging is not

turned on until after the Replication Agent is

started up, the error 'Supplemental logging is

not enabled for the primary database <orcl>'

would be complained when the user execute

'ra_admin init' to initialize the Replication

Agent system objects in the primary database.

But actually, the supplemental logging has already

been turned on.

624239 rs_ticket stops at distributor with publications
624362 doc change - erssd_start_cmd for upgrade needs to point to pre-upgrade environment.
624425 Method to have commands at DSIE/DSI to use a different repdef than what was determined when the data came into the RS.
624596 Include the letters ESD and identify the EBF number in the RAX and MA version strings.
624604 RA DB2 not processing compensation record.
624717 Customer has created multiple projects. One project contains a shortcut of a 'model' from the other project. When the project with the model shortcut is consolidated, the shortcut model is not listed in the repository.

This is expected behavior. In the Check-in window, only models listed in the <project> directory will be checked-in.

the customer desires to see the reference of the model shortcut in the repository browser.

To reproduce:

In your workspace,

1) create 2 projects, Project_A and Project_B.

2) In Project_A you create a new model, Model_A.

3) In Project_B you create new model, Model_B, and you add Model_A from Project_A.

We will have in Project_B a shortcut to Model_A:

Project_A

Model_A

Project_B

Model_B

shortcut to Model_A

Now we check-in both projects in the repository. If we look in the repository we will see the following :

Project_A :

Model_A

Project_B

Model_B

Note: that we don't see in the Project_B the shortcut to Model_A.

However if we checkout Project_B and select "check out dependencies" we will get :

Project_B

Model_B

shortcut to Model_A

*** Wed May 05 2010 15:14:56 GMT-0400 (Eastern Daylight Time) *** ahill ***

This enhancement request has been reviewed by engineering and will not be implemented.

This is expected behavior

As there is not repository model object for the shortcut, PD cannot display a node in repository browser for it.

624811 RA abends with U1403
624999 ASE ONLY: Mirror Replication Agent goes into ADMIN

state with IllegalArgumentException error during

resume when Mirror Replication Agent is configured

for multi-block read.

625312 CMR is unable to connect to an upgraded repository if all the libraries have not been upgraded.

Customer create a repository in V12.x using Studio Enterprise eval. They later purchased DataArchitect Enterprise. They have upgraded to v 15.1 EBF8. When they attempt to connect to the repository via CMR, they get an error. In the log file, there are errors stating problems loading the OOM, RQM, and BPM metaclass. Upon review of the customer's PMLIBR table, the OOM, RQM, And BPM versions are at 12.1 or 12.5.

Since these libraries have not been migrated to v15, CMR is failing to connect.

Workaround

Upgrade all repository tables/libraries to current build

This was done by using an eval license

To reproduce the issue:

1) create repository in v12.5 using studio enterprise

2) upgrade to 15.1 using DataArchitect enterprise

3) upgrade repository to v15.1

4) attempt to connect to repository via CMR

One of the errors reads:

ERROR Thread-1 2010/04/05 10:18:40 EDT com.sybase.cmr.infra.server.persistence.db.DbMetaPersistenceManagerImpl.createMetaClasses(DbMetaPersistenceManagerImpl.java:826) Exception occurred while loading metaclass(383:Object-Oriented Model)

625324 Correct an incorrect spelling found in

ra_status output for

"REPLICATING Transitioning - Stopping

LogReader immediatly" message.

625343 Request to add "Partitions" information in current RMP 15.5.
625472 Single quote is not handled correctly when certain configurations are used together.
625512 Use_repdefs=Y produces LTL for columns that are not in the replication definitions.
625514 Suppress_col_names =Y does not suppress column names
625962 When replicating to a warm standby, stable device space not released when Replication Agent is not connected.
626108 Provide a command/interface

to get RepAgent license

information.

626316 Master replication using warm standby; changing user's expired password using sp_password does not replicate and causes DSI to go down with error:

ERROR #1028 DSI EXEC(116(1) REL1502_cran2.master) - /dsiexec.c(513)

Message from server: Message: 7742, State 1, Severity 16 -- 'You must change your password using the sp_password system stored procedure before you can continue.

626321 Skipped DDL statement does not show up in RS log.
626443 RS152ESD11 Signal 6 in err_raise_syb_lib_my_maps ()
626632 RS hangs when ASE target server is unavailable.
626786 Replication Server/15.2/EBF 17186 ESD#1.1/Linux Intel/

Linux 2.6.9-42.ELsmp i686/1/OPT/Thu Oct 15 16:15:54 2009

there are two problems here ...

after inserting 500 rows in a table ...

with the connection to the standbyDS.standbyDB suspended ...

*********************************************

isql -S<activeDS> -Usa -P -w2048 -D<activeDB>

declare @var int

select @var=1

while @var<= 500

begin

insert t01 values(@var, 'skip')

select @var=@var+1

end

go

quit

*********************************************

resume connection to standbyDS.standbyDB skip 500 transaction ...

1) failure to record all skipped xacts in rs_excepts* tables

2) failure to actually skip the xacts ..

it appears all 500 are skipped ... by the response to the ...

resume connection to standbyDS.standbyDB skip 500 transaction

****************************************************************

isql -S<rs> -Usa -P -w2048

1> resume connection to <standyDS>.<standyDB> skip 500 transaction

2> go

Connection to '<standyDS>.<standyDB>' is resumed.

1>

****************************************************************

but only 21 are recorded in the RSSD in the rs_excepts* tables ... ??? ...

and more surprising is 479 rows replicated ... !!! ... ??? ...

626798 Extremely long process time for message containing very big TEXT column.
627386 Changed defaults for dsi_cmd_prefetch, nrm_thread, and dist_direct_cache_read to "off". This will prevent the license manager from looking for the REP_HVAR_ASE license.
627653 Rep Agent is not changing the Oldest Open Transaction this also causes the E,ROOT command to appear as if it does not function.
627809 Not require length on datatypes of encrypted columns. This could be expanded to not requiring datatype or length on any column and for RS to use what has been stated by the Replication Agent, unless the data needs to be transformed in the Replication Server.
627850 separate Repository Administration and Working with Repository Documents.

This is not possible with out current Users Management due the "Manage Users" rights can give all rights to his own User.

627858 Repository Feature Request: Allow multiple DBMS users for a single repository definition.

Currently, PowerDesigner only allows one DBMS user per repository definition to connect to the repository database.

627860 Repository Feature Request: Allow repository DBMS to handle repository user permissions.

Currently, the permissions are being maintained within the repository database only.

627874 config parameter to timeout connecting to license server
627896 ASE ONLY: When there are concurrent transactions

active at the same time, a mini-rollback for one

transaction is processed, the rollback operation

send to Replication Server can be 'skipped' as a

duplicate because the rollback operation's

location is too old.

628151 Replication Agent version 15.5 introduces support

to downgrade your Replication Agent instance from

version 15.5 back to version 15.2. Users wishing

to downgrade their Replication Agent instance will

need to make sure their target downgrade

Replication Agent is running 15.2 ESD #2 or later

before attempting to downgrade their Replication

Agent instance.

628422 SYSAM lmgrd daemon not installed
628593 rs_helpexception display of the generated sql is corrupt.
628672 With WINX64 RS 1550 GA, critical scripts under

'%SYBASE%\REP-15_5\ASA11\scripts' are missing.

These scripts support, amongst other things, the

ability to unload a SQL Anywhere database which

is a critical step in upgrading an Embedded

RSSD.

628745 After using RepConnector Manager or ratool to Stop Connection to Glassfish JMS, Start Connection fails.
628978 For NT386 and WINX64 Replication Server, a set

of private copies of critical DLL files used by

Replication Server are stored in

'%SYBASE%\%SYBASE_REP%\bin'. For NT386 and

WINX64 RS 1550 GA, this set is incomplete which

can cause Replication Server to reference

incompatible DLL files that could cause

Replication Server to fail.

629048 RepConnector needs to support Oracle Weblogic 10.3 as an Application Server.
629166 RS does not respond to commands when ASE containing RSSD is down. Also RS log will say queue is purged, when it really wasn't.
629246 for ORACLE only:

rs_create_repdef will create wrong

repdef for warmstandby,

if RepAgent has not ever been

started for replication.

629268 RepServer "rs_init" 15.2 GA under Solaris, fail to create a new RepServer instance having first Stable Device to be on a ZFS raw device.

"rs_init" fail with following error:

> Cannot read file '/dev/zvol/rdsk/sybase/rspe10_01'.

> Operating system returned: Invalid argument

629295 If the user's home directory is not writable by the user, the GUI

installation will report in the file '${SYBASE}/log/RepServer_Suite.log'

a runtime exception in 'com.sybase.ia.common.SybaseDestination'.

629537 Migrated 12.5 model to 15.2 can checked in into reprository but can't checked out anymore.
629564 Ability to use multiple license keys and License_Key parameter is not documented
629821 Change the default value of 'sqm_seg_prealloc' from 'on' to 'off' to avoid potential Replication Server System Database rs_segments table corruption.
630421 Row check validation configuration should default to pre-15.2 behavior
630422 dsi_command_convert does not seem to prevent duplicate key violations
630424 RTL retry mechanism severely impacts replication performance.
631494 Optional clauses in create and define subscription to specify userids and passwords if different from what is used for logging into RS.
631652 DDLGENLOC needs name of the executable.
631664 rs_subcmp needs a configuration file for schema comparison.
631691 Rep Agent ends occasionally because of non ascending QIDs
631941 Maintenance user password cannot be 30 characters.
631959 5049 does not have correct command number that is a transaction that uses bulk insert
632052 Customer is requesting that PD use multiple (smaller) transactions instead of one long transaction when deleting document(s) from the repository.

Request:

improve the transactional aspect of the PD when deleting a version ie. break up the work into smaller transactions and keep track of the progress . This will ensure recovery or ability for PD to resume the delete of the version, if a failure occurs before the full logical delete of the version is complete

632058 MICROSOFT SQL SERVER ONLY: Replication Agent

ra_dump command fails with exception: "Execution

failed because: <SQL execution failed.>" on

Microsoft SQL Server 2005.

632428 Provide ability to use replication server gateway to query Oracle when ECO is used to replicate to Oracle.
632461 RepServer incorrectly reports mis-matched sort order with 'utf8'/'nocase'
632503 Repository Enhancement Request:

Currently, the Repository Metamodel provides user and group information in a way that

- the user contains information about

- which group it is in

- which permission he has

- the group contains information about

- which users are member of it

- which groups it belongs to (parent group)

- which permissions it has

Customer would like to have another information added to the metamodel:

- a user or a group can be marked as functionally responsible for maintaining specific repository folders

632697 ORACLE ONLY: Replication Agent generates duplicate

OQIDs for a commit operation when there are

rollback operations and LOB updates in the

transaction.

633137 RepServer core dumps during restart after setting mem_reduce_malloc to 'on'
633141 Enhancement Request: Use broker connection services for RepConnector
633154 Warmstandby - the inbound queue for a logical connection (with no other replicate dbs) does not drain after dropping the connection to the standby.
633179 SySAM license installation grace is not provided on Windows.
633195 MICROSOFT SQL SERVER ONLY: Log truncation failed

with error message likes 'Error occurred

obtaining LCT lsn with message {0}' when

trying to truncate the log.

633273 0C4 at OFFSET=0000110E in LTMPACKR
633274 alter function replication definition does not work if sts_full_cache_rs_objects is 'on'
633508 Invalid decimal or invalid null indicator in logtrace=yes and no indication of problem in LTMLOG or JESMSGLG
633669 RAO 15.2 log record ... was not correctly sorted ... then NullPointerException
633735 When working with the PowerDesigner repository, the lowest granularity level

you can interact with the repository is the package.

Customer would like to lower this granularity down to object level

so that e.g. individual tables can be checked in and out.

633746 Versions are not ordered in numeric order in the version dropdown list box of the "check out documents" dialog.
633920 Capability to drop connection when connection to server or database cannot be made.
633921 Create tests to 30 character userids and passwords
634016 Customer have an OpenServer as a target Server which does not manage "sp_mda" RPC call.

Since RepServer 15.5, O/C connection property "CS_PARTIAL_TEXT" is set in order to determine if target Server will manage partial text update.

Customer would like a new RepServer's Connection parameter in order to specify whether or not to set this O/C connection property.

634059 ORACLE ONLY: Replication Agent fails to replicate

execution of a stored procedure if the stored

procedure is altered to add a new parameter.

634062 ORACLE ONLY: Replication Agent ra_truncatearticles

command fails with a NullPointerException causing

an incomplete error message "<ra_truncatearticles>

failed - Could not truncate article repository

because: null" to be returned.

634076 If RepServer is killed while skip trans is partially written to exceptions log, upon startup the transaction is still skipped and next transaction is applied
634151 rs_subcmp generates duplicated columns in the query command when FASTCMP=y and using multiple KEY columns.
634222 After the Replication Server is upgraded from pre-15.5 to 15.5, the warning #32020 "Table 'xxxx' is not defined." messages may be logged in the error log file and rows are not replicated if the Replication Server ID is greater than 16842751.
634284 "rs_subcmp" 15.5 fail to rebuild "Select" statement when using FASTCMP option.

When option FASTCMP is set to true, "rs_subcmp" rebuilt "PSELECT"/"RSELECT" statement to include hash function call.

To do so, "rs_subcmp" rebuild a list of columns which are not primary key to be passed to the hash function.

Doing so, current column name is compare in a loop with the list of primary key column name.

When column name match, the current column is added to a key column list, but the loop is not ended.

When it does not match, the current column name is added to the hash list column as many time as there is some primary key column, where this "add" must be done only once per column name.

This cause non-key column to be present in duplicate (as many time as there is primary key columns) in the column list used for hash function, and when number of columns (or number of key-column) is to high, "Select" statement fail when it is send to ASE:

Message from server: Message: 3626, State 1, Severity 17 -- 'The transaction was aborted because it used too much stack space. Either use sp_configure to increase the stack size, or break the query into smaller pieces. spid: %d, suid: %d, hostname: %.*s, application name: %.*s'. [c/subcmp.c(2891)]

634361 Origin time is not accurate between 10 pm to midnight.
634374 ASE ONLY:Replication Agent fails with

error message "Can not find relative operation

locator of CLR" when there are nested rollback

to savepoint in transaction and not all the

tables in the transaction are to be replicated.

634455 Currently, a user is only allowd to grant user-rights on:

- The repository root: these permissions apply to the entire contents of the repository.

- Folders: these permissions apply to the contents of the folder.

- Documents: both PowerDesigner models and external application files.

- Model Packages inside PowerDesigner models.

Customer would like to extend this to:

- any diagram

- any model object

634543 ORACLE ONLY: NullPointerException may occur when

Replication Agent log scan component stops

replication and exits abnormally.

634568 Add a new option for 'drop connection' to purge the stable queue
634639 ORACLE ONLY: BufferUnderflowException stops

replication during log scan processing.

635126 The DSI thread may get a 247 error (Arithmetic overflow during implicit conversion of VARCHAR value 'mm/dd/yy hh:mi:ss:mmm' to a DATETIME field.)

and be suspended if you run rs_ticket procedure in a primary database on Japanese ASE.

635182 Memory leak
635234 Quiesce may not always process to the

end of the log before suspending.

635318 RAO 15.5 ... not replicating (or replicating very slowly)
635492 ORACLE ONLY: Replication Agent behavior is

inconsistent when reading from linux block

devices. Potential manifestations are data loss

and instability.

635658 RS 15.6 requires ECO 15.5 ESD #1
635981 RAO 15.5 ... log scanner stopped because of error: java.lang.IllegalArgumentException

Log scanner <thread_1> reached end of active log <###>.

T. ... OracleLogScanne com.sybase.ds.oracle.log.OracleLogScanner Log scanner <thread_1> blocking on end of log.

E. ... ERROR com.sybase.ds.oracle.log.OracleInstanceLogSca Log scanner <thread_1> stopped because of error: java.lang.IllegalArgumentException

636148 ORACLE ONLY: Information message "The configuraion

parameter rs_charset had been overridden with

rs_charset = {0} which obtained from the

replication server." does not display the

character set in the Replication Agent log.

636178 ORACLE ONLY: Replication Agent generates a delete

SQL statement when updating a column which has

NULL value to NULL.

636245 ORACLE ONLY: Replication Agent fails to read new

log data after the ASM disks are resized.

636313 Replication latency history will not display for an ASE server without a primary connection.
636671 "Unable to get message '5173'. ((Intl-Lib error: Unknown error) Location: r/errfmt.c(556))" in dump transaction processing after resume connection skip tran.
636861 Replication Agent displays a

SySAM warning message "Failed

to open the localised message file

'$SYBASE/locales/unicode/sylapi/

en_us/sylapi.lcu' when it attempts

to check out license.

637176 tns_alias_name and ora_sid_name explanations are incomplete.
637196 Make server names on ECO case insensitive.
637314 RQM:Delete/Insert requirement doesn't update the requirement code in Repository
637343 Bulk copy is significantly slower when doing 1000 versus 100 consecutive insert statements.
637439 Enhance to detect stable device corruption when segment for one queue contains block for another queue.
637493 I have a PDM model with two tables. Via a direct connection to a repository installed on Oracle 10g, the consolidation takes around 10 seconds.

If I consolidate the same model via a proxy connection, it takes 5 minutes to complete.

637604 When upgrading PD 15.1 proxy server to PD 15.2 proxy server, the proxy services is removed during the upgrade process.

To reproduce:

proxy 15.1 is installed

install proxy 15.2

prompted to perform upgrade and click yes

after upgrade completes, the proxy service has been removed.

For 15.1, the proxy service was called 'powerdesigner proxy' for 15.2, the service is 'Sybase powerdesigner proxy'.

*** Mon Aug 09 2010 10:21:10 GMT-0400 (Eastern Daylight Time) *** ahill ***

This issue has been fixed in PD 15.2.0 EBF 4. Executing the proxy server EBF will recreate the proxy service.

637731 After upgrading, data with table rep def in MSA environment no longer replicates.
637784 Dump by maintenance user during MSA materialization, produces internal error.
637788 Connect to another server via RS Gateway and specify the user id and password
637851 Check in into the repository will not update external shortcuts as long as both models are open.
637999 more and better messages to help diagnose route create/drop issues
638019 RA DB2 abend without message and only partial SYSMSGLG
638130 After upgrading, error 20026 will be reported and DSI will shutdown when SQL statement replication is used.
638286 5101 message on warm standby connection.
638317 Feature request to be able to add one or many projects to a configuration
638634 Unable to resume connection after a failed system transaction using the 'resume connection to ds.db execute transaction' command.
638638 Progress bar inaccurate during installation.
638660 lack of hvar license message appears until dsi_cmd_prefetch is off
639125 Include dbisql with Replication Manager install.
639152 Support for IQ to IQ replication.
639407 MICROSOFT SQLSERVER ONLY: Replication Agent fails

with "SQL Anywhere Error -141: Table 'articles'

not found" error when Replication Agent is not

initialized and the "pdb_get_tables",

"pdb_get_procedures" or "pdb_get_columns" command

is executed.

639429 Open Client Client-Library error: Error: -99999, Severity 5 --

'Incorrect value type [7] to create a String.' with bulk insert.

639833 With large number of commands in the transaction, sysadmin sqm_zap_tran will not return the prompt in a timely manner.
639870 Missing server name in rs_init error message.
639884 capability to show the names of the replication definitions that apply to a marked or unmarked table.
640141 Feature Request: Currently, PowerDesigner Repository Proxy can only be installed on Windows.

This CR has been opened to request to support Repository Proxy on Unix (and Linux)

640229 request ability to specify format of message, either bytesmessage or textmessage
640247 Turning on trace DSI_CHECK_ROW_COUNT_FULL_NAME as an connection trace produces a stack on the Rep Server.
640369 Repository Consult/Specific to cust models.

Integrate a document into another one, name of a view column has been lost after Check In and is displayed as "View column" in repository explorer.

As a consequence, if you compare the local model with its copy in the repository, 'Compare Models' has detected a difference on that view column and is displayed with no label in that window.

640471 Allow the 5185 message to be set by table and allow different tables on the same connection to handle the 5185 resulting action differently.
640500 Add documentation on how to validate that a parameter has been set.
640806 In CMR, a Java RuntimeException is thrown when attempting to create a subscription with an user that had a subscription on a model\document that was deleted. Executing a refresh or stopping and restarting the CMR server have no effect.

To reproduce:

1) Connect to Portal (in my test, this was a new install of Portal)

2) create user_1 and user_2 (users created with no password and a valid email address)

3) select a model\document (model_1) and create new subscription using user_1

4) in PD, connect to repository and delete the model\document (model_1)

5) in CMR, refresh or stop and restart the server

6) select model_2 and create a new subscription using user_1

7) click Save

NOTE: you get the following error:

An error has occurred! Click logout

java.lang.RuntimeException: wrapped Exception: java.lang.NullPointerException

at com.sybase.cmr.web.filter.LocaleFilter.doFilterInternal(LocaleFilter.java:96)

8) logout and then log back in

9) select model_2 and create a new subscription using user_2

10) click Save

NOTE: the subscription is created. It appears that the problem occurs when attempting to reuse an user that was previously associated with a model that has been deleted from the repository.

640996 rs_init hangs when "exit sybinit" is n
640998 rs_init hangs after getting "Exit sybinit?"
640999 Cannot suspend the connection while the server is in hibernation mode.
641139 RS server needs to be added to the interfaces file of IQ in order for RTL to work.
641146 Add message that one would get when RTL to IQ is used (server not found).
641367 Include doc that in a IQ multiplex environment, the RS has to connect to the coordinator node.
641372 Add message: Permission denied: Command not allowed on

Multiplex Writer servers. to the Troubleshooting Manual

641373 Add documentation on what people have to do to have RS continue processing if the coordinator node fails in a Multi-plex environment.
641825 Replication Server 15.5 script file (ral1550.sql) contains the incorrect Replication Server version. Errors produced are similiar to "com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -265: Procedure 'ral_error_class' not found".
642157 The Replication "Transactions Removed from SQT" graph incorrectly displays zeros for the data points. This graph is on both the Connections and Queues pages of the Replication Server Monitor.
642158 In a Replication Server Monitor, when displaying the Connections page, the DSI SQT Cache graph for the selected connection incorrectly displays zeros for the data points.
642159 In the ASE Monitor for a RepAgent Thread, the Log Size graph incorrectly displays a value of zero.
642212 rssetup.sql is missing from IQ on solaris x64 platform.
642220 Enhance the Quick Start Guide to include how to setup RAO to replicate from RAC and ASM environments.
642242 A user with effected LIST permissions on a model is not allowed to check out the model, what is ok and expected to work this way.

However, upon trying to open the model on the Workspace(it has an exclamation mark to state that it has not been checked out),

it is being checked out and opened although the user who is checking out this model only has effective list permissions on the model in the repository.

642275 Replication Server 15.6 and Replication Agent 15.6 are not SCC-supported versions.
642513 RS gets killed with "failed to connect to logical domain manager"
642703 sysadmin log_first_tran does not leave DSI suspended.
642766 Feature request to add a function to integrate by script a document version into another version or into a different document.
642804 ra_config returns an incorrect

description for

pdb_auto_create_repdefs.

642806 Error: -99999, Severity 5 -- 'Values exceed buffer length.'.
642880 New Feature Request ... Replication Server ... add clientname, clienthostname, clientapplname handled like rs_origin_user
642966 Customer is using RepServer 15.x under Solaris (but this is a generic issue/request)

Customer have define Function-String using T-SQL variable in the "output language" clause.

When several statement using same T-SQL variable are sent to target ASE, ASE error #134 is raised because of redeclaration of T-SQL variable :

E. 2010/08/31 14:11:09. ERROR #1028 DSI EXEC(103(1) ASE1_1503.rdb1) - dsiqmint.c(3221)

Message from server: Message: 134, State 1, Severity 15 -- 'The variable name '@v1o' has already been declared. Variable names must be unique within a query batch or stored procedure.

To work around this issue, Customer have to switch off the "batch" Connection parameter which may cause serious performance issue.

Customer would like RepServer to implement a behavior so RepServer will be able to identify T-SQL variable declaration and send them only once per batch to target ASE in order to avoid ASE error #134.

642967 Folders not shown for Project if using List Permissions for a User.
642969 possibility to back up the user-permission that are set to restore them.

Implement a permission history for Users and Groups to be able to restore them.

643022 Enhance RAX doc to include moving RAX from one machine to another, or if Oracle moves from one machine to another.
643028 Button to make a graph in its own independent window so that it can be docked independently of the screen that originated it.
643043 Expanded latency graph has numbers in milliseconds when the label says seconds on the vertical axis.
643064 A feature request to implement a new feature for DDL commands as same as "send maint xacts to replicate" for DMLs.
643144 Enhancements to Replication Definition creation by Replication Agent:

1) Commands rs_create_repdef and rs_drop_repdef are expanded to support creation of Replication Definitions when the primary database is UDB.

2) Keyword 'display_only' has been added to the rs_create_repdef command to allow the Replication Command Language that would be sent to Replication Server to create the Replication Definition to be displayed. The command syntax is displayed, but it is not executed against Replication Server when the display_only keyword is included.

Syntax:

rs_create_repdef [owner.]tablename[,display_only]

643174 HVAR/RTL: timestamp column is sent to the replicate database even send_timestamp_to_standby is set to off in a warm standby or MSA environment.
643199 When RAX is requested to create the replication definition, it uses user configured as rs_user and the user must have "create object" permission.
643315 Modify ECO in order to incorporate changes to the ExpressConnect Replication Canonical Interface (RCI ), in order to be compatible with Replication Server v15.6. ECO v15.5 ESD #1 is a required update to work with Replication Server v15.6 and is not compatible with any version of Replication Server v15.5.
643366 ORACLE ONLY:

Oracle archive redo

log positioning and

processing is slow

when many archives

exist.

643449 RS 15.x needs fixes in ERSSD
643578 Automatic materialization to Sybase IQ fails.
643710 create route from 15.2 to 15.5, the rs_objects table does not get replicated to replicate RSSD, resulting in missing table repdefs.
643829 The Replication Agent fails with the following message: Could not find Resource Bundle containing index: LTI_ALREADYRUNNING
643841 UDB ONLY: Replication Agent incorrectly sends

"character for bit data" column in character

values to Replication Server.

643916 Check in dialog show wrong Data Type value if connecting via Proxy server.

An in general in the PD repository browser (direct and proxy) if showing the column attributes of a PDM Table)

643921 CMR show wrong name and icon in repository explorer using read permission for folders and list permissions for a project

steps to reproduce:

1. connect to repossitory as ADMIN

2. create user_1

3. create folder_1 with read for user_1 (delete "all Users" permissions)

4. create in folder_1 a folder_2 with read permissions for user_1 (delete "all Users" permissions)

5. create a project and check in in folder_2

6. rmb click on project and select project permissions. apply "List" permissions user_1 (delete "all Users" permissions)

7. rmb click on project and select folder permissions. apply "List" permissions for user_1 (delete "all Users" permissions)

8. connect via CMR as user_1 and open the project in Repository Browser

-> you will see a project inside the project instad seeing the default Diagram.

643924 CMR show wrong project details
643967 If autocorrection is on a repdef, do not generate 5185 if problem occurs on that repdef
643999 RS can allocate memory that shuts down the host machine.
644127 Clarification on quoted identifier usage in alter replication definition and create replication definition.
644329 ORACLE ONLY: BufferUnderflowException stops

replication during operation processing when

parsing a log record resulting from activity

against a compressed table, regardless of

whether the table is marked for replication

or not.

644468 Proxy connection to repository: When many users check in documents simultaneously, the PD task and proxy server stops responding. No error message is displayed on client side, PD just hangs up. This does not happen when only one user checks in a document at a time.
644496 ORACLE ONLY: Replication Agent initialization

fails with a message like 'Could not create log

device for on-line log <+LOG/YYY/XXX>.

The ASM filename 'XXX' is an invalid format.

The format should be <prefix.NUMBER.NUMBER>.'

when the primary database online redo log name

alias is a logical name in ASM.

644522 Embedded RSSD encountered deadlock, SQM stopped:

E. 2010/10/06 14:44:42. ERROR #11061 SQM(217:0 SS01.COMMON) - s/stscol.c(2052)

Check the log for error messages from RSSD.

E. 2010/10/06 14:44:42. ERROR #1028 SQM(217:0 SS01.COMMON) - s/stscol.c(2052)

Message from server: Message: 1205, State 0, Severity 13 -- 'ASA Error -306: Deadlock detected'.

I. 2010/10/06 14:44:42. SQM stopping due to an exception: 217:0 SS01.COMMON

644556 Cannot connect via RS Gateway or "configure replication server" when RS is in hibernate mode.
644564 "A cached row for system table 'rs_systext' was swapped out of the cache..." message when turning off hibernation.
644868 rs_ticket requires pds_username and maintenance user to be different Oracle users.
645156 Added keywords 'wait' and 'nowait' to the pdb_setreptable command.

When the 'wait' keyword is included in the pdb_setreptable command along with the 'mark' keyword, the command will BLOCK until an exclusive lock on the primary table is obtained. There is no timeout unless one is imposed by the primary database. The purpose for obtaining the lock is to ensure any open transactions against the table are complete before the table is marked.

When the 'nowait' keyword is included in the pdb_setreptable command along with the 'mark' keyword, the command will attmpt to acquire an exclusive lock on the primary table , but will fail if the lock can not be obtained. The purpose for requesting the lock is to ensure there are no open transactions against the table when the table is marked.

Syntax:

pdb_setreptable [owner.]tablename,[replicate_owner.]replicate_tablename,mark,owner[,[wait|nowait]]

Note: The wait and nowait keywords are only supported when 'mark', 'owner', and replicate table name values are also supplied with the pdb_setreptable command, and only supported as the last keyword in the command (must be the 5th attribute)

645328 Check in an external file into a folder you've just created in the repository.

The document has been successfully checked in but you cannot expand the folder.

645344 Document the need to put precision on values in "where" clause when the column name is a datatype that allows precision.
645398 rs_databases should not be allowed to be cached as a full table cache in RS.
645478 UDB_ONLY: A CLOB column is incorrectly replicated with a column name of 'dummy' instead of the actual column name.
645560 Replication Agent reports downgrade version

is not supported when downgrading from

Replication Agent version 15.6 to 15.5 during

the pdb_downgrade_accept process.

645620 The ra_marker command does not accept marker content that includes an embedded quotation mark.
645627 Not possible to add project model version to a configuration
645775 Add login auditing: log failed logins, lock logins, enforce password expiration.
645778 New option in Replication Server to use UTC (Coordinated Universal Time) for rs_lastcommit and rs_ticket datetimes.
645833 Oracle Weblogic 10.3 can be installed with either a 64 bit or 32 bit jdk on AIX. Originally only a 32 bit sylapi library was shipped with RepConnector. Now a 64 bit one will be needed as well.
645882 DSI error 11076 and stack when adding column to a replication definition with multiple

repdefs against a table and primary Replication Server is 12.6.

645912 Memory leak during HVAR/RTL compile phase when command reduction on a table with text/image column.
646045 ORACLE ONLY: Tables containing only unsupported

columns can be marked for replication, even with

the 'force' option, when they should not be

markable.

646174 ORACLE ONLY:

The Replication Agent

improperly identifies

a column as a primary

key column when that

column has been defined

only with the 'not null'

attribute.

646205 Incorrect syntax on example for pdb_xlog move_truncpt.
646537 ORACLE ONLY: Replication Agent hangs while

processing an on-line Oracle redo log which has

duplexed copies and the current copy Replication

Agent reading from has a corrupt block header.

646660 ORACLE ONLY: Replication Agent fails with

"MalformedInputException: Input length = 1" error

when the primary database is configured to use a

multi-byte character set.

646860 Document enhancement to describe all the steps to setup database replications using MSA via database replication definition and database subscription using 'dump marker' for materialisation.
646882 UDB ONLY: Replication Agent replicates the

VARGRAPHIC data incorrectly when the primary

database character set is a multi-byte

character set.

646905 The output for trace LTITRACELTL is corrupt for character data when the primary database character set is a mulit-byte character set.
646928 Check-in Check-out on ASE repository DB using ODBC is taking a long time
646943 Apply RS 15.2 ESD#2 on top of RS 15.2 ESD#1.1 will not create indexes rs_key12_subscriptions

and rs_key17_subscriptions on rs_subscriptions table automatically. Need to update configuration

option 'RSEBF1520_RSSD_UPDATED' back to '0' before apply RS 15.2 ESD# 2.

647000 if right-click on a model of a project inside the repository and want to check out it there is no opportunity to choose an earlier version.
647055 RAX/RAO 15.6 ... suppress warning when non archive log file is found
647173 drop route from 15.2 PRS -> 15.5 RRS crashes RRS
647215 Interrupting 'alter repdef' command causes distributor to go down:

ERROR #50 DIST(117 dsname.dbname) - xec/dist.c(12563)

'rs_objects' system table is corrupt.

647234 HVAR enhancement to support 12.5.x ASE versions which only allow temporary table name

unique in leading 13 characters.

647369 ORACLE ONLY: The Replication Agent system log fills with several trace messages for the OracleLogScanner thread even when no trace flags are enabled.
647538 atomic materialization to IQ fails when source ASE database has date column.
647541 atomic materialization is not fully supported to IQ, and attempting this with date columns fails (see CR647538). There should be a note stating this.
647662 ORACLE ONLY: Replication Agent fails to report

an error when an archive log should be processed

but can not be found, resulting in the archive data

being skipped from replication.

647676 RTL allocated all memory on host
647861 DSI error 1027/5215 when dsi_bulk_copy is enabled and number of columns is changed in the middle of a bulk operation.
648233 Change rs_init to add heterogeneous functions strings before first server bootup.
648265 Replication Server stack traces when a route is dropped from a pre 15.5 Replication Server which has some replication definitions.
648267 Route creation from a pre 15.5 Replication Server does not replicate rs_objects and rs_columns rows to current Replication Server's RSSD.
648400 Unable to resume connection after a failed system transaction using the 'resume connection to ds.db execute transaction' command when transaction is a dump database/transaction.
648610 Request that RepServer override 'soft' per process memory limit and report the limit it finds in the environment.
648655 Capability to mark the entire database with a single command.
648761 support Portal on Unix / Linux

Currently Portal is not fully supported on Unix / Linux as well there is no offical documentation how to install the war files etc on a Webserver running on Unix / Linux.

648961 "copy Permissions to all children" on project level fails. The List status does not change.
648995 Customer is having an un-sync replication system and is aware of this situation.

Due to this un-sync situation, Customer is hitting RepServer error #5149 ("Function 'rs_get_textptr' for 'reporting_cmd_log' returned no rows.") which make DSI to goes down often:

E. 2010/11/05 13:12:47. ERROR #5149 DSI EXEC(645(1) SYB2E.workdb) - /dsiexec.c(5113)

Function 'rs_get_textptr' for 'reporting_cmd_log' returned no rows.

Customer would like to be able to assign action (IGNORE) to this RepServer error (like it is possible for RS error 5185 & 5186):

SQL> create replication server error class rs_repserver_error_class

SQL> assign action ignore for rs_repserver_error_class to 5149

649013 Rollback with from/to removed begin transaction, which RS reported as a 9022 error.
649146 RA DB2 leaves open transactions during times of low activity.
649252 Connected to the Repository, when selecting the menu Repository -> Compare, the repository versions number in drop down list are sorted as alphanumeric characters (i.e: 1, 10, 11, 12, 2, 3...) and not as numbers.
649447 threshold on incoming and outgoing thread to notify customer when more than (or less than) x amount of data is flowing.
649622 Replication Manager Plug-in doesn't support Extended Password Encryption.
649637 ORACLE ONLY: Replication Agent may throw an

exception "Invalid state encountered processing

commit operation" when replicating DML commands.

649975 Proxy detach one model version out of the other from Extension
650063 HP-UX ITANIUM 64-BIT ONLY: Replication Agent

nstance creation fails due to RASD creation

failure.

650317 Additional batch on parameters requirements not documented for replication to Oracle.
650318 Using the command C,MONITOR=00 sometimes causes abend S32E
650347 ORACLE ONLY: The ra_direct_read configuration

parameter can not be set before Replication Agent

initialization.

650655 Drop database subscription without specifying 'without purge' does not report error, the subscription drops and replicate data is not purged.
650679 New server with no connections other than the RSSD, changing the db_packet_size doesn't take affect.
650810 Memory leak when DML operations on a table with text column fail.
650837 Customer is using RepServer 15.5 esd#1 under Solaris platform.

Replication Server/15.5/EBF 17804 ESD#1/Sun_svr4/OS 5.8/1/OPT64/Fri May 21 18:08:21 2010

Customer setup an MSA replication (with a primary Database-Replication-Definition + Subscription).

Customer is testing Dynamic-SQL.

When He switch on Dynamic-SQL feature and RepServer Monitor&Counters sampling, RepServer stacking :

1> alter connection to <RDS>.<RDB> set dsi_compile_enable to "on"

2> go

1> configure replication server set stats_sampling to "on"

2> go

When RepServer is charged, RepServer is stack-tracing:

I. 2010/08/09 10:02:39. The DSI thread for database 'SPARADBD06.replihvar_db' is started.

I. 2010/08/09 10:02:39. Loaded Connector [ase.ctlib] for connection to [SPARADBD04.SPARADBD05_RS_RSSD]. Version: [3.2].

I. 2010/08/09 10:03:10. Replication Agent for SPARADBD05.primhvar_db connected in passthru mode.

T. 2010/08/09 10:03:51. (45): Thread DSI EXEC(103(1) SPARADBD06.replihvar_db) infected with signal 10.

T. 2010/08/09 10:03:51. (45): Dumping context structure:

...

T. 2010/08/09 10:03:51. (45): Dumping memory trace.

T. 2010/08/09 10:03:51. (45): ***************STACK TRACE***************

T. 2010/08/09 10:03:51. (45): *****thread DSI EXEC(103(1) SPARADBD06.replihvar_db)*******

T. 2010/08/09 10:03:51. (45): pc: 0x00000000001dfd08 + 00000000000001c8, exc__appDumpStack ()

T. 2010/08/09 10:03:51. (45): pc: 0x00000000001e3408 + 0000000000000464, exc_terminate ()

T. 2010/08/09 10:03:51. (45): pc: 0x0000000000105228 + 00000000000007c0, sun_svr4_catch_signal ()

T. 2010/08/09 10:03:51. (45): pc: 0x0000000000171690 + 00000000000000a8, dsi_exec_inc_aobj_counter ()

T. 2010/08/09 10:03:51. (45): pc: 0x000000000022f500 + 0000000000000d20, _hq_compile_command ()

T. 2010/08/09 10:03:51. (45): pc: 0x00000000002305e8 + 00000000000002a0, _hq_compile_u2di ()

T. 2010/08/09 10:03:51. (45): pc: 0x0000000000230c48 + 00000000000015d4, _dsi_hq_compile ()

T. 2010/08/09 10:03:51. (45): pc: 0x0000000000232298 + 00000000000004cc, dsi_hq_compile ()

T. 2010/08/09 10:03:51. (45): pc: 0x000000000015ebd8 + 0000000000000404, _dsi_exec ()

T. 2010/08/09 10:03:51. (45): pc: 0x00000000001822e0 + 0000000000000bb0, _dsi_qm_exec_cmd ()

T. 2010/08/09 10:03:51. (45): pc: 0x00000000001a8980 + 0000000000000c18, dsie__GenerateSQL ()

T. 2010/08/09 10:03:51. (45): pc: 0x00000000001a6f40 + 0000000000000aec, dsie__ProcessGroup ()

T. 2010/08/09 10:03:51. (45): pc: 0x00000000001a6870 + 0000000000000278, dsie__main ()

T. 2010/08/09 10:03:51. (45): pc: 0x00000000001a52c0 + 000000000000140c, dsie__wrap ()

T. 2010/08/09 10:03:51. (45): pc: 0x000000000054d298 + 00000000000001e4, srv__start_function ()

T. 2010/08/09 10:03:51. (45): pc: 0x7ea00000 + 1ac36, _thr_slot_offset ()

T. 2010/08/09 10:03:51. (45): *****End of stack trace.****

T. 2010/08/09 10:03:51. (45): Internal error. Attempting to produce a core file.

650851 This EBF replaces Replication Agent 15.5 for

Oracle with Replication Agent 15.6 for Oracle in

Replication Server 15.6 Real Time Loading Edition.

651090 ORACLE ONLY: There is a degradation in

performance compared to pre 15.5 versions

when replicating LOB data.

651131 ORACLE ONLY: Replication Agent direct read

component does not read data correctly from

ASMLib disks when the disk size is greater

than 2GB.

651218 UDB ONLY: DBCLOB values are only partially

replicated.

651244 dsi_buf_dump and dsi_cmd_dump show ? for values.
651255 Invalid object messages erroneously reported in the RS log.
651266 RS Gateway cannot connect to ASE server with "net password encryption reqd".
651357 ORACLE ONLY: Replication Agent fails with an

'Invalid supplemental data format' error when

processing some DML commands.

651374 SCC support for net password encyption.
651385 Fail to create connection to MSSQL/UDB/DB2/Oracle with connection profile rs_ase_to_msss

/rs_ase_to_udb/rs_ase_to_db2/rs_ase_to_oracle[ecda|eco].

651568 Replication Server interoperability matrix is missing many of the platforms that previous versions were released on.
651680 ORACLE ONLY: Replication Agent throws an exception

"No replication definition found for replicate

table <> after RSSD resynch -- primary table is

<SYS.SOURCE$>" if there are multi-row insert

operations on an Oracle system table.

652104 Provide OR, IN, LIKE logic in subscription where clause. Do not want to use articles to accomplish the same objective.
652172 When you check out a package containing shortcuts, the package selection is extended to include the target packages referenced by shortcuts even if you do not have the Read permission on these packages.

This is a feature request to change PowerDesigner design because user may not have necessary permissions and see security issues popping up in the future.

652218 Notification that RA DB2 license is due to expire.
652304 Oracle RAC only: cannot set pdb_commit_generation to true.
652567 0C1 REASON CODE=00000001
652596 Capability to replicate only parts of a transaction.
652760 ASE to UDB connection created with errors
652996 ORACLE ONLY: Replication Agent generates a delete

SQL statement when updating a column containing a

NULL value to NULL.

653326 For the repository folder, the customer is requesting the ability to add comments and\or notes to the folder property sheet.

Customer's description:

We have several different groups using the repository for our models. We each have our own folder(s). Is there any way that we can put the name of the group/contact name on the high level folders so all of us know whose they are and who to contact if there are questions.

Since we use the same repository, this would help in gathering us all together when we need to upgrade our software at the same time.

Changing the name of the folder is not a desirable option.

653406 New Feature Request ... Replication Server 15.6 ... support replicating text from ASE to IBM DB2 UDB on linux
653407 New Feature Request ... Rep Server Connectors 15.6 ... support replicating text from ASE to IBM DB2 UDB on linux
653466 PD - Repository Login takes a long time to connect using models with XEM.
653614 New Feature Request add 'set replication off' like ASE repagent to RAX MSSQL
653615 New Feature Request add 'set replication off' like ASE repagent to RAX Oracle
653626 Index to rs_translation table has been changed. For those RSs that exist prior to this fix, one must manually update the index to add the target_status column to the unque index.
653717 Bulk copy can be used on Oracle with ECO.
653735 RA DB2 not able to start up most of the time with DB2 V 10
653781 pdb_remove_archives parameter in the Primary Database Guide is supposed to be pdb_archive_remove (found in the Reference Manual). The correct name is pdb_archive_remove.
654374 ORACLE ONLY: Replication Agent goes to the ADMIN

state when replicating an insert statement for a

table containing a nested table.

654510 Replication Server now replicates CS_Numeric/CS_INT types to an Oracle Number column when the Oracle type DDL does not define precision or scale for this column.
654512 ORA-02005: implicit (-1) length not valid for this bind or define datatype.
654515 ORACLE ONLY: "Invalid supplemental data format"

error occurs when Replication Agent scans

a log record that does not contain any

supplemental metadata.

654763 In the Portal, the customer is attempting to assign a private port number for the SMTP protocol. if they enter a value greater than 1000, the following error is returned:

"the port number should be 1 to 1000"

The customer is requesting that the Portal be enhanced so that they can specify a port in the Dynamic and\or Private Port range.

The customer has made reference to the following specifications:

http://www.iana.org/assignments/port-numbers

Specifically, they are referencing the following:

PORT NUMBERS

(last updated 2011-01-11)

The port numbers are divided into three ranges: the Well Known Ports,

the Registered Ports, and the Dynamic and/or Private Ports.

The Well Known Ports are those from 0 through 1023.

DCCP Well Known ports SHOULD NOT be used without IANA registration.

The registration procedure is defined in [RFC4340], Section 19.9.

The Registered Ports are those from 1024 through 49151

DCCP Registered ports SHOULD NOT be used without IANA registration.

The registration procedure is defined in [RFC4340], Section 19.9.

The Dynamic and/or Private Ports are those from 49152 through 65535

654794 UDB ONLY: Replication Agent fails to stay in

REPLICATING state because the UDB byte order is

unrecognized.

654815 RS 15.0.1 ESD#2 AIX stops abnormally when Warm Standby ASE experiences procedure cache becoming very low or even exhausted

The SQM thread with Replication Server stops working. Only way out is to recycle ASE with

standby and RSSD (which same is on the same ASE server)." Just for clarification. We are

experiencing a stop of the SQM. In one case the SQM stopped and the Replication Server stopped abnormally. In all cases of the SQM stopping, a message arrives in Replication Server log that procedure cache is short. The only way to start the SQM is to SHUTDOWN and START the Replication Server. Resume does not work for the SQM. Looking at the RSSD location in ASE no message can be found.

654935 when RepServer is in hibernation mode and SCC is collecting stats, if hibernate_off is issued, RS crashes. This only occurs when the stat collection runs after hibernate_off has been issued, but before the server comes out of hibernation mode.
655120 Feature Request: Allow the user interaction by displaying the Merge Models dialog box when a model is about to be check in inside the repository by the means of VBScript.
655163 Previously, Oracle synonyms generated a Replication Server stack trace. This fix corrects the issue, replicating Oracle Synonyms.
655395 Example of dcany.cfg file is incorrect. Service name and ACS Required are supposed to be on two lines.
655443 Clearer documentation on placement of logs, as it pertains to ASMlib.
655592 Replication definitions that RS creates, should not include columns with datatype of in-exact numerics.
655770 ORACLE ONLY: NoSuchElementException during

operation processing stops replication.

655833 Need RepConnector 15.0.2 certified on AIX 6.1.
655913 ORACLE ONLY: Replication Agent incorrectly pads

zero at the beginng/ending of a numeric column in the

LTL sent to Replication Server.

655927 Support to integrate something from outside a project, into another project or when a projectmodel losses errously the link to the repository it is not possible to use the integrate function as workaround.
656213 Provide a command/interface

to get RepAgent license

information.

656231 It appears Extended Metamodel Signature is not being modified into the repository when model with embedded XEM is being updated. Following check in keeps detecting a difference on Model's attribute 'Extended Metamodel Signature'.
656321 api_com_test does not have an option O.
656325 create route in RS 15.6 with ERSSD spawns dbltm unix child process that becomes <defunct> after the route is created
656334 MACLIB members, APIXITCA and LECMDEXT were not distributed.
656342 S0C4 in LTMACOM
656515 Dropping connection creates " Internal error. Attempted to free a resource chain with resources."
656519 Minimal columns behavior change at the connection, can change expected replication environment behavior when upgrading.
656848 For consolidated RQMs, the Requirements should be sorted in the same format as the Local copy of the RQM. This would be to sort based on the 'Title ID'.

When a requirement model is consolidated, the requirements are displayed in the repository based on selected sort options which is Name or Code.

NOTE: This sort order does not match the 'Document View' diagram.

In the Local Browser, the Requirements are sorted based on a combination of 'Title Id + Name'. This sort order does match the 'Document View' diagram.

The customer is using CMR\Web Portal. When they attempt to review the RQM, it is impossible to view a true representation of the RQM.

Summary:

Repository View = Portal View

1) PD is functioning as designed. Sorting the Repository view of the Requirements based on the Name\Code sort option.

2) There does not appear to be an option to sort based on the Title ID with in the Repository View

3) Without the option to sort by Title ID within the Repository View, it severely handicaps, the use of the Portal when working with Requirement models. There is no way to provide end users a true view of the consolidated model.

656890 Administration Guide incorrect in documenting affect on replicate_minimal_columns with replication definitions.
656924 replicate_minimal_columns setting on connection will override customer written replication defintions with "replicate all columns" clause.
657166 Repository: LDAP user should be case insensitive
657177 Improve performance after OK button is clicked in the 'Merge changes to Repository Document' window.
657266 dsi_command_convert is available to all licenses and does not require dsi_compile_enable to be on.
657287 For instance the extened Attributes of the Oracle 11g XDB, AutoFixMaterializedView & AutoFixTempAttribute show differences if you reopen a Model saved in reprository without changes.
657294 In multiple user enviroment the mapping editor show wrong accesstype arrow in mapping editor after "Update from Repository". Property stay right.
657325 Support for XML datatype in MS SQL to MS SQL bi-directional replication.
657330 Enhance RA MS SQL to replicate XML datatype to another MS SQL
657347 ORACLE ONLY: Replication Agent encounter

a NULLPointerException during operation

processing.

657381 ORACLE ONLY: Replication Agent could not find

Resource Bundle message key XUSRENBP.

657451 'rs_objects' system table is corrupt

customer hit this problem gave us their erssd db file and erssd xact_log file,

their stable queue files, their <rs_name>.cfg file, and their RUN file and we are

able to reproduce their instance of the problem in-house here at Sybase now.

customer purged the queue and the problem was resolved ... thus the error message

......

'rs_objects' system table is corrupt

......

seems to be a false error message in the sense that there is something seemingly

wrong in the stable queue rather then in the erssd rs_objects table

657469 When a RS function requires log into another server, give the option to use a different user id and password for the login.
657553 UDB ONLY: Replication Agent fails to replicate

some decimal values. The exponential (float)

value is propagated instead of the full decimal

value.

657567 rs_subcmp generates wrong reconcile SQL file if data content special char, e.g. '%'.
657573 Replication Server incorrectly basing partition size on number of segments instead of number of MB. This can cause a create partition command to fail. It also means that more disk space is being used for a partition after block size is increased.
657623 Ability to generate repdef names that are "different" and to put the repdefs to a separate file.
657634 Fixed Replication Server connection to ExpressConnect for Oracle, whereby no suspend occurred when table was not present at replicate, dsi_dynamic_sql = on and dsi_bulk_copy = on.
657760 Provide upgrade instructions from 15.5 to 15.6.
657800 If adding a XEM as an external file to the workspace the xem can not checked in as file.
657988 Tested and reproduced with PD 15.2 ESD#9

'Rebuild Clustered Indexes' alters table index from Unique to Non-Unique. Customer Itau-Unibanco wants to know why this behavior happens. Customer understands the index should not be altered at this point.

658049 Difference in rs_update_thread and rs_intialize_threads stored procedure code.
658132 Rep Agent cannot read the DB2 V10 log because the layout for one structure was changed to have 68 more bytes.
658134 During idle times, empty transaction that splits the begin and commit transaction across a buffer, leaves open transaction upon RA DB2 restart.
658138 DB2 now allows duplicate LRSN values which causes duplicate QIDs in Rep Agent and Rep Agent shuts down.
658141 Rep Agent is occasionally unable to add a table for replication after it is dropped from replication for a short time.
658142 EA enabled partition number calculation is incorrect causing image copy decompression to fail or not find the image copy.
658144 The Operator command C,MONITOR=nn causes an abend when the nn value is not numeric.
658146 Rep Agent gets a SQL -906 error because not all code paths close the cursor when scanning image copy information.
658149 Display license key information and error messages in the log.
658188 Ensure that ECO can connect to a Oracle that has a period in the name.
658357 Make it easier to add "date/time last updated" and "updated by" to a row at the target table.
658444 Feature request that when using rs_init to upgrade RSSDs that it should handle situations where the RSSD is already at the required version without reporting this as an error and failure.
658474 alter database replication defintion syntax for SQLDML is incorrect.
658536 ORACLE ONLY: When replicating numeric columns,

Replication Agent incorrectly pads the beginning

and ending of the column value with 0's when

sending LTLto Replication Server.

658543 ORACLE ONLY: Replication Agent reports an article not

found error if user does not move truncation

point to the end of log after 'pdb_xlog init,force'.

658666 Message in RS log says to refer to dataserver log and there is no message in dataserver log.
658763 ORACLE ONLY: Replication Agent goes to ADMIN

state with error "RAO TranReader unexpected thread

death - IndexOutofBoundException".

658765 ORACLE ONLY: Replication Agent goes to ADMIN

state with error "RAO TranReader unexpected thread

death - NullPointerException".

658816 ORACLE ONLY: Replication Agent fails to replicate

an insert with select into a Index Organized

Table which has only key columns stored in

the index segment.

658825 It is not possible to update an external file in reprository if it was reattached to the workspace.
659602 Repository: Currently, if a package within a model hasn't sufficient permissions (i.e., write or full permissions),

PowerDesginer upon checking in raises a warning:

"Some merge actions may not be applied in the target model,

because you do not have the Write permission on some packages."

This CR is to request an option to suppress this warning in the future like offered by many other Windows applications.

659693 Batch on cannot be used.
659719 When Replication Agent is installed on non-HP-UX

machine, it is not able to connect to RSSD if RSSD

resides on HP-UX ASE with Roman8 charset.

659752 ORACLE ONLY: Replication Agent appears to be

hanging with no data being replicated during

'replicating' state. It becomes unresponsive

when trying to suspend replication.

659875 The wrong partition dictionary used to expand data for Non-EA enabled Table Spaces. An undocumented extra 8 bits are added to the high order part of the page number for these table spaces causing the partition number to be calculated incorrectly.
659899 Signal 11 in dALARM( ).
659957 ORACLE ONLY: Replication Agent fails with

'Could not create log device for on-line log'

exception while initializing the Replication

Agent instance using 'pdb_xlog init' command.

659972 Display status icon in Local Browser gets incorrect when the model was synchronized with the repository and is used to merge to another model. State is now 'Changed' (red check mark) although model did not change.
660011 RS 15.5: function string using RPC causes ERROR #29031 cs_convert() error
660046 The <db>_create_rs_primary_connection.sql

script contains an incorrect error function

class.

660085 When creating Replication

Server connection using

profile, the HDS script

attempts to make duplicate

entries in rs_translation.

660175 Branches for "earlier" versions are created on current version or cause error if the version is unfrozen and cancel check in.

To create branches from older versions was possible in PD 7.5 GA.

660278 ASE 12.5.4 does not support the desired CS_NUMERIC_TYPE, bigint
660286 If a table has multiple replication definitions in a warmstandby environment, after dropping all those replication definitions, there will be a row with objname like rs_indrp% left in RSSD rs_objects which will be never dropped.
660407 Please give an option to easily handle (skip or bypass) image/text replication errors:

For instance:

1. Capability in the replication error class to customize how to deal with either "text pointer returns no rows" or "text pointer returns multiple rows" besides just the suspend connection option that is currently available.

2. Allow the capability to allow the rest of the columns to be applied and commit the transaction, even if the text pointer logic fails. The failure of the text should be logged to the RS log.

3. Allow for easier customization of function strings that deal with the text/image replication.

660447 The connection profile rs_oracle_to_oracle should not be setting the dsi_suspended parameter.
660466 ORACLE ONLY: Add support for

Sunx64 platform.

660495 ORACLE ONLY: When the Replication Agent parallel scan

(lr_parallel_scan) is enabled, issuing the suspend

may result in the Replication Agent to report an

Oracle Log Scanner thread error.

660648 In 15.6 upgrade script, IQ function string class' parent class id incorrect.
660690 CR 622582 which is supposed to keep RAX running despite RAX errors, is not fully implemented; it will not skip lti formatting errors.
660700 RA DB2 continues come up, even when Use_repdefs = Y and server hosting the RSSD is down.
660789 Currently you have two windows to show permissions for a Project in Repository borwser. Ther Folder Permissions and the Project permission. Request is to show all Permissions / Informations of an Project in one window and not ins two.
661012 Error: -99999, Severity 5 -- 'Incorrect value type [8] to create a String.
661018 Rep Agent displays count down banners once a day for 30 days when a license is about to expire. Then displays an expired license banner when it has expired.
661185 Cannot tell from message 5181, what value or column and the size that generates this message.
661272 New Feature DOC CR ... add ra_direct_read on if OCFS2 is setup to use direct I/O

Linux only ...

if one does this command in linux ...

mount | grep "ocfs"

... and the result has "datavolume" the for sure configure ra_direct_read to on.

indicate that ra_direct_read needs to be turned on if the OCFS2 is setup to use direct I/O.

661546 ORACLE ONLY: Replication Agent is replicating a

null value for a non-null column in a table when

character set conversion is not required, causing

Replication Server DSI to go down.

661603 Integrate: Merge model into another one leads to OdbcError: [24000] [Sybase][ODBC Driver]Invalid cursor state.
661631 RAO 15.6 add flexibility enabling RASD tracing ... creat an option to reduce the voluminous info written to /var/adm/messages by SQLAnywhere / ASA when executing the debug RA binary.
661869 Provide trigger control package for MSSQL.
662018 Add a new repository right and\or permission to limit users ability to create folders.

If an user only has the 'Connect' right and 'Write' or 'Full' permission, they are able to create Folders within the repository. The customer would like to allow the users to check-in documents, but not create folders.

662109 Impact of column_compression and ltl_send_only_primary_keys and ra_set_autocorrection on where clause of subscription and function string processing.
662494 Deprecate configuration parameter 'sqm_seg_prealloc'.
662644 RS stacks in dsi_calc_estimated_row_size when 'dsi', 'dsi_workload' trace is enabled.
662792 When Replication Server needs memory over memory_limit, the 15.5 GA/ESD#1 and 15.6 GA behavior is that memory will be increased automatically by 10%, each time additional memory is needed over mememory_limit. This CR is to disable this behavior. The new behavior is when memory usage exceeds memory_limit, the Replication Server will shut down.
662905 Officially support parallel DSI to mainframe DB2
662948 For auditing purposes, the customer would like PD to track additional repository activities.

The additional activities being requested are:

Repository user: creation, deletion, assignment of rights

Assignment and modification to document and/or folder permission

Deletion of objects within a PowerDesigner document

663172 ORACLE ONLY: Replication Agent stops replicating

when it encounter "Unable to get the LOB object

from the repository." error when the LOB column

on the table is not configured for replication.

663178 DSI loops with 5185 in replication server error class set to ignore.
663210 When user connects and disconnects from the Replication Server, internal synchronization element not freed.
663379 ORACLE ONLY: Replication Agent does not skip log

reader errors generated when scanning logs of

Oracle Cluster with skip_lr_errors set true.

663575 Support MS SQL replication in a failover cluster
663642 RSO156 customer needs documentation on how to resync ... bi-directional ... MSA multi site availability ... MSSQL<->MSSQL replication system / environment
663742 Upon updating a model into the repository, 'Merge Changes to Repository Document' keeps reporting object modifications on some symbols regarding Related Position even Position.
663825 ERROR #11061 SQM ... ERROR #1028 SQM ... SQM stopping due to an exception

E. ... ERROR #11061 SQM(102:1 lds.ldb01) - s/stscol.c(2055) Check the log for error messages from RSSD.

E. ... ERROR #1028 SQM(102:1 lds.ldb01) - s/stscol.c(2055) Message from server: Message: 701, State 3, Severity 17 -- 'There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure cache.'.

I. ... SQM stopping due to an exception: 102:1 lds.ldb01

RS 15.0.1 ESD#2 AIX stops abnormally when Warm Standby ASE experiences procedure cache becoming very low or even exhausted

The SQM thread with Replication Server stops working. Only way out is to recycle ASE with

standby and RSSD (which same is on the same ASE server)." Just for clarification. We are

experiencing a stop of the SQM. In one case the SQM stopped and the Replication Server stopped abnormally. In all cases of the SQM stopping, a message arrives in Replication Server log that procedure cache is short. The only way to start the SQM is to SHUTDOWN and START the Replication Server. Resume does not work for the SQM. Looking at the RSSD location in ASE no message can be found.

663834 Cannot create connection using profile to non-ASE replicate databases when RS password encryption is turned on.
663917 HVAR/RTL: quoted identifier not working if net row change number is smaller than dsi_bulk_threshold.
663946 ORACLE ONLY: Replication Agent goes to

ADMIN or REPLICATING DOWN state when

processing an Oracle online redo log file which

contains no log data, or Replication Agent

stuck processing an Oracle archive log file

which contains no log data.

664027 rs_oracle_timestamp9 does

not allow 9999 for the year.

664029 License check message does not turn off when turning off trace dynamically
664145 Product: PD 15.2 EBF#9 and 15.3 EBF#4

This is a request from Itau-Unibanco customer, during meeting with David Dichmann on week of March 21th, 2011.

Currently, PD allows working with only one repository at a time. Customer would like a feature to work with two or more simultaneous repository connections at same time.

664148 ORACLE ONLY: Replication Agent goes to

ADMIN or REPLICATING DOWN state when

processing an Oracle online redo log file which

contains no log data, or Replication Agent

stuck processing an Oracle archive log file

which contains no log data.

664394 ORACLE ONLY: When ra_direct_read is enabled,

ASM/ASMLib is configured and ra_devicepath

is configured to a non-ASM disk mirror path

configured for the ASM online log,

Replication Agent will not read the log file using

direct I/O. This may cause problems during

replication.

664651 SCC RMAP hangs when adding procs in RSSD and the RSSD log is full
664679 PD 15.2 EBF#9

This is a feature request from Itau-Unibanco customer:

Enable PD APIs with methods for Repository user management. E.g: create new users and groups, asociate users to groups, define rights and permissions etc.

*** Mon Jul 07 2014 11:28:38 GMT-0400 (Eastern Standard Time) *** ahill *** PD 16.5 SP03

Morgan Stanley is requesting this functionality as well.

We would like to raise an ehancement request for a Repository Management API.

This should allow for all the administrative functions that are exposed in the PD GUI to be automated. For example:

- Add/change/remove user

- Add/change/remove group

- Add/remove users to/from groups

- Set user/group permissions on folder

The API could be as simple as a documented set of database stored procedures in the repository database or a SOAP/REST web service or command line tools.

664692 Server crashes in ll_del ()
664700 DOC ... RAO needs all nodes in RAC individually listed in tnsnames.ora used by RAO with just the connection info specfic to each individual node since RAO may need to login to each nodes specifically.
664893 Update to the latest version of JRE

to pick up the JRE security vulnerability

fix(CVE-2010-4476).

665181 Memory leak when bulk is enabled. The memory could be freed after connection suspend/resume.
665427 MICROSOFT SQL SERVER ONLY:

Replication Agent goes to

'Replication Down' because of a

NullPointerException.

665544 Fixed Replication Server potential core dump when ExpressConnect for Oracle had general_1 tracing turned on.
665570 ORACLE ONLY: Improve LOB replication performance.

A new Replication Agent configuration parameter

lr_max_lobdata_cache is now available to use for

tuning LOB replication performance.

lr_max_lobdata_cache

Determines the maximum size (in byte) of LOB

data cache for each off row LOB data.

Default: 8192

Values: An integer from 8192 to 2147483647

Comments:

- The lr_max_lobdata_cache can be use for

tuning better LOB replication performance.

The recommended value for setting the

lr_max_lobdata_cache is a value larger than

the max LOB data size being replicated.

- The lr_max_lobdata_cache should be set when

the Replication Agent instance is in ADMIN

or REPLICATING DOWN state.

665636 MICROSOFT SQL SERVER ONLY: Replication Agent

replicates the non-null bit column value

incorrectly on a table containing a mix of null

and non-null bit column values.

665754 ORACLE ONLY: Add statistics for EOL and LOB

processing.

EOL statistics for single thread scanner

LR Log scan reader end-of-log status

LOB processing timer

LR Avg Large Column Data processing time

665881 Connection to ExpressConnect for Oracle may experience "ORA-02005: implicit (-1 ) length not valid for this bind or define datatype" when table has REAL or FLOAT datatype columns.
666022 NFR RS156 create something similar to sp_monitorconfig in ASE for RepServer

It would be great to have a dashboard item like sp_monitorconfig in ASE for Replication Server where customer's could monitor items like num_mutexes configured compared to used, largest amount of sqt_max_cache_size used, num_msgs, num_msgqueues, num_client_connections, num_concurrent_subs, etc ...

666303 ORACLE ONLY: Replication Agent does not

skip partial LOB error when lr_skip_errors

configuration is enabled.

666457 IBM DB2 ONLY: Replication Server distributor

fails with ERROR #9027 and a message similar to

"A begin with transaction id = some value was

seen while a transaction was still active"

because Replication Agent sent multiple begin

operations for the same transaction when rollback

to savepoint occurred in the transaction.

666471 RTL: "Syntax error near '32768' " when replication definition has 'replicate minimal columns' clause and there is a text/image column.
666582 ORACLE ONLY: Replication Agent goes to REPLICATION

DOWN status when replicating LOB data and the

population of the LOB on the primary database is

terminated unexpectedly with ORA-01691: unable to

extend lob segment <?> by 128 in tablespace <?>.

666650 ExpressConnect for Oracle: Replication Server should always obtain delimiters, even for NULL values.
666657 IBM DB2 ONLY: Update operations fail to replicate

without any Replication Agent status change,

error or even warning.

667054 ORACLE ONLY: Replication Agent fails to replicate

LOB data where the LOB data size hits a database

block size condition. The error is incorrectly

reported as a partial LOB data error.

667104 Feature Request: Ability to configure Replication Server to ignore and suppress error #32020 from the errorlog.
667589 ORACLE ONLY: Replication Agent fails with

NullPointerException during LOB replication rescan

processing. Replication Agent may report it's

still in REPLICATING status.

668159 RS cores with _sqt_re_read_from_sqm and ll_del
668319 New feature request for ability to set send_enc_password at the connection level.
668368 Problem: During installation on Solaris systems, an error occurs when validating available disk space: ./setup: !: not found

Workaround: The error can be ignored. The program should still properly be able to determine if sufficient disk space is available.

668507 Add new table rs_version

in user databases, IQ and

Oracle.

668685 ORACLE ONLY: Replication Agent may fail with a

NullPointerException when the Replication Agent

is performing parallel check point processing.

668686 ORACLE ONLY: Replication Agent stops replication

with device not found exception when switching

from the latest archive redo log to the latest

online redo log.

668690 ORACLE ONLY: SCAN_READER_EOL_STATUS statistic

information is missing from the statistics list

when Replication Agent parallel scan

(lr_parallel_scan) is enabled.

668692 ORACLE ONLY: LOB Replication performance may be

slow.

668717 Repository: Order of table columns has changed after check out
668795 HVAR: DSI shutdown with complaining "'CREATE TABLE' cmd is not allowed in multi-stmnt xact".
668822 Function is missing in stack that is printed to the RS log.
669535 ORACLE ONLY: Replication Agent log truncation

function may cause an Oracle "Archival Error".

669565 Feature Request for Replication Server to have new command to report details about licenses that are currently in use.
669628 set dsi_bulk_copy to 'off' needs to be added to the create connection command; bulk copy is not supported to RepConnector.
669797 setting dsi_serialization_method to 'check_rows' causes RepServer to crash
669910 Replication Agent fails with a

NullPointerException when attempting to reconnect

to the RSSD after a previous failed connection.

670351 Specific to cust models: Integrate a model document into another document: Some errors occur during the update of the repository model. The collection Transient Reverse Mappings cannot saved in the repository for object External Table Mapping 'Data Warehouse KB.R_Curve_Mapping_FTP.Mapping_1' Unexpected error while updating the repository document.

The check in of the document has been cancelled."

670487 Check in of an EAM takes ten times longer on a MS SQL 2005 Repository compared with an ASA Reprository.
670577 MICROSOFT SQL SERVER ONLY: Replication Agent fails

with Unexpected Thread Death from Transaction

LogReader thread error message due to

EndOfLogException when processing the end of

virtual file log.

670707 RS stacks with ll_del and _exc_alloc_element
670840 UDB ONLY: Replication Agent encounters an

unexpected fatal exception when processing a

multi-record update. It can occur when a delete

is executed against a record that no longer

exists in the primary database.

670877 Tested and reproduced with:

PD 15.2 EBF#9 and 15.2 EBF#10

Repository: SQL Server 2008

OS: Windows XP SP3

This is an issue from Itau-Unibanco customer.

When checking in a project with a binary file attached (e.g. docx file), the following error appears during check-in process:

Unexpected error while updating the repository document

The check in of the document has been cancelled

We confirmed issue happens in 15.2 codeline, only. Issue is already fixed in 15.3 (tested with EBF#4 and EBF#6).

671039 Only the first character of Lock comment of a document in the repository is visible when a Proxy connection is used.

Works fine using a Direct connection.

671222 Integrate a model into another one. Compare the local model and the one you have just stored in the repository. Unexpectedly, it returns a few differences on one view:
671254 Incorrect values in the 7036 error message
671385 Tested and reproduced with:

- PD 15.3 (EBF#4/EBF#5/EBF#6)

- SQL Anywhere 11 as repository

When creating an user with Connect and Read permissions for the Repository and tring to check out versioned models, some versions are not allowed to be checked out. If you connect/disconnect as ADMIN and then connect with created user again, the list of allowed/not allowed model versions may change. Please, refer to repro steps for details.

671421 OCS messages encountered when turning dsi_bulk_on impacting performance

E. 2011/05/06 12:55:16. ERROR #1027 DSI EXEC(122(1) <ds>.<db>) - /dsiutil.c(354)

Open Client Client-Library error: Error: -99999, Severity 5 -- 'Incorrect value type [8] to create a String.

'.

671452 MICROSOFT SQL SERVER ONLY: Replication Agent ADMIN

utility fails with a primary database version is

not supported error message when creating a

Replication Agent instance using a response file

and the primary database version is Microsoft SQL

Server 10.50.1702 or higher.

671690 Enable CheckOut Configuration inside Configuration Properties Window if User has only read permissions.
671962 32bit linux RS 15.6 with ECO 15.5 ESD#1 EBF18204

W. 2011/05/27 13:06:18. WARNING #13092 DSI(103 ox11gsdx.ox11gsdx2) - seful/cm.c(6983)

The Data Server '<oraservername>' is using the 'iso' character set for Database '<oradbname>'. The Replication Server is using the 'iso_1' character set. Unexpected results may occur.

672211 Create capability for generated replication definitions to go to a file instead of Replication Server.
672266 MICROSOFT SQL SERVER ONLY: Invalid warnings

indicating a user name does not exist in the

database when initializing the Replication Agent,

requesting user name information, or when managing

the owner filter list will no longer be logged in

the Replication Agent log file.

672280 RAU post_install does not complete the run of pdb_xlog init.
672285 When selecting Find Objects via the Repository menu, the 'Operator' column is missing when you select the Advanced tab

When select the Find Object\ Advanced tab via a model, the 'Operator' is available.

672294 Update the Open Server Components of Replication Server to provide essential Open Server vulnerability fixes.
672552 RepConnector: Database replication definitions and subscriptions to RepConnector cause errors in repra.log: "Failed to rebuild the RepEvent. It's retrying." & "Failed to rebuild the RepEvent eventually." from RepHolderException: REPWARN_RepNoTableData.
672974 When checking in multiple documents, the "Check In Multiple Documents" window doesn't provide the feature to specify the location where the documents will be checked in. They will be checked in at the root of the browser. Folder parameter has to be specified separately by clicking the Settings tool for each document one by one.

Feature request to be able to set the folder for all (selected) documents and/or a combo-box for the Folder column for each row.

673023 supported solution to allow DDL replication in either direction on a bi-directional replication in a like-to-like heterogeneous environment
673070 A unique message that is ONLY displayed if the desired activity completed successfully (e.g. if the postinstall upgraded all components to 15.1, then the final message could be "all components successfully upgraded to 15.1)
673071 A unique message that is ONLY displayed if the desired activity completed successfully (e.g. if the postinstall upgraded all components to 15.1, then the final message could be "all components successfully upgraded to 15.1)
673095 After upgrading the Replication Agent instance to

a newer version, Replication Agent will throw an

exception if the 'ra_migrate' command is not

issued prior to resuming replication. Issuing

the 'ra_migrate' command after the error occurs

may cause the Replication Agent instance to hang.

673183 RS 15.6 ebf 18736 ... rs_ticket columns to small for data needs

E. 2011/06/07 15:32:51. ERROR #1028 DSI EXEC(105(1) DSSQUAL.gps) - dsiqmint.c(4292)

Message from server: Message: 247, State 1, Severity 16 -- 'Arithmetic overflow during implicit conversion of BIGINT value '2164895721' to a INT field

673207 Heterogenous Guide has some of the ECDA parameters incorrectly documented.
673525 Resume connection skip transaction may not skip transaction on Oracle replicate connections.
674019 The check in of the document has been cancelled.

SQLSTATE [Microsoft][ODBC driver for Oracle][Oracle]ORA-12899: value too large for column "PDMIG"."PMTEXT"."TDAT" (actual: 2004, maximum: 2000).

Setting up 'MaxBytesPerChar'='3' in Windows Registry does not help with Proxy connection.[HKEY_LOCAL_MACHINE\Software\Sybase\PowerDesigner 11\Repository] 'MaxBytesPerChar'='3'.

674254 Attempting to authenticate a RepServer running on HP/UX using roman8 charset fails with security error.
674255 Enhance login failure message to provide more accurate description of failure.
674752 When replicating UNITEXT data with both database and table repdefs containing heterogeneous datatypes such as rs_msss_nvarchar_max, the UNITEXT data was being translated to a single-byte character set resulting in data corruption.
674893 dsi_alt_writetext set to dcany reports incorrect syntax from ECDA
675461 HANA when postinstall is run, the RAU connection should always be set to have DSI suspended.
675539 Memory leak in warmstandby environment when there have multiple replication definition again same table and one of these replication definitions has 'send standby replication definition columns' attribute.
675590 IQ internal error when varchar and varbinary value length > 255
675619 Replication Server internal error, 'SQLMoreResults' returns FAIL, can be returned if a stored procedure returns an error that is overridden by a customized error action.
675643 Cannot replicate password change when user password expired
675862 Update the jConnect version that the Replication Manager Plug-in uses to jConnect 7.0.
675866 Update the jConnect version that the Replication Monitoring Services use to jConnect 7.0.
675883 SCC 3.2 does not shutdown correctly if the Replication Monitoring Services plugin is loaded.
676083 Tested and reproduced with:

PD 15.3 EBF#7

Repository on Oracle 10gR2

When checking in as update one of model versions, customer receives the following error message:

'Some errors occur during the update of the repository model'

676111 Incorrect LTL is generated when the only change

in an operation is to a LOB column.

676246 warmstandby, SQL replication, replicating a "select into" that has UDD column causes DSI to go down
676313 Replication Server core dumps with a stack trace in _sqm_add_segment.

Workaround: This issue can be avoided by using the following trace in Replication Server: trace=SQM,SQM_ENABLE_SEGPREALLOC

676802 REP: Docs: document known limitation of master replication

Particular care needs to be taken for the automatic expiration of login passwords in a warmstandby of master. When a login password has expired, ASE is enforcing an immediate change. When a login password has expired on a standby ASE, Replication Server

can't comply with the rule enforced by ASE. Therefore, it is recommended that the login passwords on a standby ASE never expire by configuring a higher login expiration interval on the standby ASE than on the primary so that the change of passwords is driven by the primary ASE.

676974 RS15.6 reports Error 5216 and Error 1027 when set "dsi_alt_writetext" to dcany
677333 Include LTMFREE in 15.0 linklib
677340 SYS CODE = 378-14 when rollback performed against LTMOBJECTS.
677397 ORACLE ONLY: Replication Agent goes to

REPLICATION DOWN state with 'Could not get marked

object' error.

677455 ORACLE ONLY:

Replication Agent throws

NullPointerException while

being suspended.

677458 PD Portal does not regognize LDAP users. Only the internal users of the repository are recognized. Ct uses exact the same LDAP connection informations which are working well with PowerDesigner Windows Client and PD Viewer.
677613 Replication server is failing with a coredump when parallel DSI is activated and a deadlock is detected on a DSI Executor thread connection. The issue occurs while DSI-Executor thread is doing its own deadlock detection processing and when the deadlock error is simultaneously raised by ASE (the DSI-E being the victim of the deadlock).
677725 Error message not complete
677824 Replication Agent sometimes logs the messages

to the system log file when it is intended for

other logs.

677955 (UDB only) Configuration parameter

pdb_archive_remove does not fit usage

as documented.

678014 A memory alignement issue may lead to a signal 10 occurence (followed by a repserver coredump) on some plateforms when using HVAR/RTL feature.
678126 Using ISQL v10.0.4 to connect to RepServer may cause FATAL ERROR #21.
678471 For Internal Use Only (Functional Enhancement)

Provide options on RAU to allow the RAU to continue to run even when encountering errors.

678598 Tested and reproduced with:

PD 15.3 EBF#6 and EBF#7

Repository in Oracle 10g R2

When connecting into repository, latest version displayed in repository tree is 108, but when verifying all model versions, latest is actually 109. Any attempts to check out and check in v108 or v109 results in "Check in cancelled" and version list shows an incomplete v110 in repository.

678792 sqt_max_read_delay parameter value range issue
678860 Replication Agent goes

down with 'Lost connection

to Rep Server.' error,

and fails to resume

automatically after

Replication Server was

recovered.

678927 RepConnector NFR: request to include date in the timestamp in repra.log
678928 Enhance RTE (RepConnector) to show log timestamp in milliseconds
678948 Tested and reproduced with:

PD 15.3 EBF#4

MS SQL Server 2005 as Repository

This is for Itau-Unibanco. This specific model (see repro steps) delays around 6 minutes to be checked in (which is ok) but delays around one hour to be checked out.

678976 RepDef: The max byte per char is not changed when selecting a repository
678979 Console command e,trace=on does not turn on logtrace.
679181 rs_objects and rs_columns has column names that are wrapped around and cannot be found when using pdf search.
679423 Change to rs_diskpartitions table not identified in What's New in 15.0
679464 ORACLE ONLY:

Replication Agent went

down with 'Byte buffer

remainder is too small'

error.

679624 Implementation of a feature request that allow to create a warning alert when DSI is down
679697 W. YYYY/MM/DD HH:MM:SS. WARNING #7038 DSI EXEC(103(5) <dsname>.<dbname>) - /mem/mem.c(2429)

WARNING: Memory usage is above 80 percent.

one situation that will cause this warning . . .

1) alter connection to <dsname>.<dbname> set parallel_dsi to 'on'

. . . and . . .

2) alter connection to <dsname>.<dbname> set dsi_serialization_method 憌ait for start�

679799 Native SQL Server driver cannot support transaction
680051 The Use_repdefs=Y configuration does not limit column values to those in the replication definition
680132 Document Status Icon in PD Browser turns into 'Changed' unnecessarily.

Model generation let PD detects a change to the repository after generation when

- the generation has been checked in (update, freeze, check-out)

- the local models have been saved to disk

Comparing with repository doesn't yield any differences.

680266 Repositoly of PowerDesigner which set up Byte per char of "2-Byte" using ASE ODBC Driver 15.5 fails in creation.
680796 Problem: During installation on Solaris systems, an error occurs when validating available disk space: ./setup: !: not found

Workaround: The error can be ignored. The program should still properly be able to determine if sufficient disk space is available.

681209 HDS SCRIPTS:

Upgrade from Replication Server

15.6 to 15.7 failed with duplicate

key error.

681211 dsi_bulk_copy 'on' causes many rs_config queries
681230 Parameter listing with alter connection does not show which parameters are not used when dsi_compile_enable = on.
681234 Leaking memory with uni* columns
681254 RepConnector: problem with embedded single quotes in TEXT column
681400 Docs: Change upgrade documentation to explain implications of upgrading a RepServer in a mixed version environment.
681536 RepConnector performance needs improving for large batches of events.
681852 Replication Manager 15.6 cannot create replication defintions for tables with column names which are replication server reserved words, also does not allow "quoted/not quoted" when selecting columns for replication definition.
681875 Resume connection skip transaction may not skip transaction on warm standby.
682002 HVAR does not ungroup and apply the transactions individually when a command within the group fails.
682042 ORACLE ONLY: Replication Agent goes into the

REPLICATION DOWN state due to a log scanner error

stating 'Invalid record offset with block id

<XXX,XXX> and block offset <XXX> specific on log

device <XXX>.'

682671 Memory usage much higher than expected; cannot apply transactions with large number of commands because of memory usage.
682693 When route is suspended on PRS, performance is noticeably worse and data accumulates in the inbound queue.
682778 Tested and reproduced with:

PD 15.2 EBF#11

Repository in SQL Server 2005 DBMS - using Native Connection Profile

Environment: Windows 2003

This issue is for Itau-Unibanco.

When a checkin process is cancelled due to a log full state from SQL Server 2005, PMTEXT is inserted an improper row that is never deleted and this row remains orphan since then.

Also, native connection profile does not reflect database Log Full state and customer never knows a log full occurred in db.

By using ODBC driver, the error IS reflected successfully, but improper row is also inserted into PMTEXT and not deleted as it should be, after checkin is cancelled.

682797 ORACLE ONLY: If there are two tables that have the

same table name but belong to different schemas,

marking those tables without specify the owners

(schemas) will fail with 'Table is not in the

database' error.

683050 RepConnector/SySam: counting number of threads as CPUs
683147 When customizing class level function string like rs_usedb, only last part of the function string content is sent.
683186 timestamp_in_char=Y has format of 2000-02-29 18:20:23:222222 . New option of i or iso will provide the format of 2000-02-29-18.20.23.222222 which is documented as the format for Y.
683267 15.7 CTP NFG: Check Altering or Dropping Alternate Replicate Connections has incorrect syntax for the description.
683318 rs_msss_varbinary_max can not handle 0x
683332 Either memory leak or incorrect reporting of the amount of memory RS is using.
683342 Syntax message regarding triggers and replication is misleading.
683389 Alternate primary connections do not allow a change on the dataserver side of the connection name. RS example is incorrect.
683816 Customer requested a certification of RSME 15.2 (RepServer Messaging Edition 15.2) on RedHat 5 platform for Linux x86/x64 using JBoss 6 and JBoss 7.
683875 admin stats, "all", save fails to write a row in rs_statdetail in warmstandby
683945 Alter repdef statement to modify a identity column to map to numeric fails:

1> alter replication definition AA alter columns with AA_IDENTITY identity map to numeric

2> go

returns message "Replication definition 'AA' is altered."

but the update does not take place.

684093 Tested and reproduced with:

PD 15.2 EBF#11 and 15.3_EBF#9

When checking out a model to replace an existent pdm file, the extended attribute is not being updated correctly.

684350 ORACLE ONLY: Replication Agent goes into the

REPLICATION DOWN state due to a log scanner error

stating 'Byte buffer remainder is too small.'

684401 Example values are incorrect for "sp_configure 'replication agent memory size', 8194" command.
684506 stack/hang error in distributor
684561 REGR : when switching user in repository, the library is lost
684795 When the connection to the repository via the proxy is lost, the PD client still appears to be connected to the repository. When the end user attempts to check-in a model, the consolidation is cancelled but the end user does not know why. If you select the repository tab in the Browser, the PD client still appears to be connected to the repository.

The PD client should provide some indication that the connection to the repository is no longer available.

1) connect to repository via a proxy connection

2) consolidate a model

3) shutdown the proxy server, but keep the PD client open

4) modify the model

5) consolidate the model

NOTE: The consolidation is cancelled but the user does not know why

6) select Repository\Connection information

NOTE: it shows that you are connected to the repository via the proxy that has been shutdown.

684813 NFR: Classes should not be replicated. Causes problems with "drop route"
684817 Suppose a primary table contains some integer columns, and it does not have a replication definition. There is some performance impact if both the meta data reduction feature and HVAR feature are enabled. To avoid that performance impact, the user could create a replication definition with the SEND STANDBY REPLICATION DEFINITION clause for the affected table.
684900 Edit comment : update an object should version link attached to it

--EOF--

  • 本文链接地址:http://www.dbainfo.net/sap-rs-cr-number-2.htm
  • 本文为dbainfo个人原创,请在尊重作者劳动成果的前提下进行转载;
  • 转载务必注明原始出处 : Sybase数据库技术,数据库恢复专家
  • 对《SAP Replication Server的所有已知BUG列表(2)》有何疑问或见解,请在本文下方发表;
  • 对网站还有其他问题或建议,请提交在留言板,谢谢!
  • 本文的评论功能被关闭了.