远程Sybase数据库技术支持,联系手机:13811580958,QQ:289965371!

 

随着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信息!

如有问题,请联系我!

QQ :289965371 点击这里给我发消息
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

CR:737215
CR Number:   737215
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   NA
Original Version:   6.1.70
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2013 Fixed
08 May 2013 Fixed
24 Apr 2013 Fixed
29 Apr 2013 Fixed
Description
Solved the read failure when a LOB change is inside a large(long) transaction.



CR:737421
CR Number:   737421
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.7.1 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New feature to 'admin config' to be able to display all the parameter settings that have been changed from default.



CR:737441
CR Number:   737441
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Management
Status:   Closed
OS:   Generic
Original Version:   15.7.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 ESD #3 07 May 2013 Fixed
Description
Execution of ra_locator move_truncpt is allowed

while Replication Agent is in replicating state.



CR:737505
CR Number:   737505
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Doc
Status:   Open
OS:   Generic
Original Version:   15.7.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Missing description of asm parameters in RSO-Oracle 15.7.1 ESD #2
Workaround Description
 Use the description from either RSO GA version or RSO 15.7.1 SP100



CR:737537
CR Number:   737537
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Repository
Status:   Closed
OS:   Generic
Original Version:   15.7.1 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2013 Added to user documentation
Description
Add asa_host and asa_port to the Reference Manual.



CR:737617
CR Number:   737617
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   6.0.14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
To Be Determined 14 May 2013 Fixed
Description
ORACLE ONLY: Replication Agent fails to replicate

operations that are logged just prior to an

Oracle online log switch.



CR:737743
CR Number:   737743
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7.1 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2013 Fixed
Description
ORACLE ONLY: After Oracle LogMiner terminates

the connection with Replication Agent,

Replication Agent may not be able to resume

replication without being restarted.



CR:737841
CR Number:   737841
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
Status:   Closed
OS:   all
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2013 Added to user documentation
Description
The maximum number of transactions that resume connection skip N tran can skip is the number of committed unread transactions in SQT.



CR:737923
CR Number:   737923
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.7.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Warmstandby and MSA replication: the 'send standby' clause does not appear to be working as documented when adding table repdefs.
Workaround Description
 WORKAROUND - first create table repdef with identity column, then create second table repdef with identity map to numeric



create replication definition ACC_INFO_HIST_rd

with primary at ASE157.rs1571_msa1

with primary table named ACCESSED_INFO_HIST

with replicate table named ACCESSED_INFO_HIST

(PR_ID numeric, HIST_DT datetime, HIST_SEQ_ID identity)

primary key (PR_ID, HIST_DT)

send standby all columns

replicate minimal columns



create replication definition ACC_INFO_HIST_rd2

with primary at ASE157.rs1571_msa1

with primary table named ACCESSED_INFO_HIST

with replicate table named ACCESSED_INFO_HIST

(PR_ID numeric, HIST_DT datetime, HIST_SEQ_ID identity map to numeric)

primary key (PR_ID, HIST_DT)

replicate minimal columns

without dynamic sql



create subscription ACC_INFO_HIST_sub

for ACC_INFO_HIST_rd2

with replicate at ASE157.joe

without materialization



CR:737926
CR Number:   737926
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   AIX
Original Version:   15.6 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RTL enabled: automatic materialization to IQ fails with table not found - missing table owner.



CR:737994
CR Number:   737994
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Open
OS:   Windows
Original Version:   cheverny
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Currently hyperlinks of mappings are not active, no mapping information can be shown or only minimum information are available for mappings.



CR:738119
CR Number:   738119
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   cheverny
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request is to enable a way to save passwords to Repository local like in the previous versions. To be able to connect to repository without authentification.
Workaround Description
 Use a VBScript to open a connection to Repository

In the script you can store password and user of the DB and Repository:



Open(ByVal RepDef As String = "", ByVal User As String = "", ByVal Pass As String = "", ByVal DBUser As String = "", ByVal DBPass As String = "") As Boolean

Opens the repository connection. This function is equivalent to the call of the 'Connect' action in the user interface. The connection parameters are the name of the repository definition to use, the name of the repository user, the repository password, and the database login and database password. For repository definitions associated with a proxy, the database information is not necessary and can remain empty.



CR:738329
CR Number:   738329
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   cheverny
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If debug log on proxy sever is enabled. ODBC errors during login to Oracle 11g repository is logged.



OdbcError(-2): [S1000] [Oracle][ODBC][Ora]ORA-00933: SQL command not properly ended



CR:738343
CR Number:   738343
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   15.7.1 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2013 Fixed
05 May 2013 Not a Bug
Description
For internal use only (QA finded):

ORACLE ONLY: Replication Agent Oracle intervalDS

data type parse error make materialize session close.



CR:738393
CR Number:   738393
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Open
OS:   Windows
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When searching attributes of type 'string' the Portal search operator defaults to 'Contains'. However, the customer would like to select '=' (equals) for the operator. Depending on the attribute selected, the ability to select a specific operator is not available. The customer states that using 'Contains' for 'strings' returns too much information.



The step to reproduce the issue:

1) Start Portal. Login

2) Click Search. Click New Search. In Model Type field, select Physical Data Model.

In Object type field, select Column. In Attributes field, select Data Type.



You can see Operator automatically set to Contains. There is no way to change it.

The customer wants to use '=' in this case.



CR:738468
CR Number:   738468
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7.1 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2013 Fixed
15 May 2013 Fixed
Description
ORACLE ONLY: When Replication Agent uses JDBC to

execute SQL statements against the primary database

or RASD, in some cases, JDBC PreparedStatement or

Statement objects may not be closed to relinquish

database resources.



CR:738501
CR Number:   738501
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   cheverny
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2013 Fixed
Description
PowerDesigner 16.5 fails to check stereotyped metaclasses of Glossary model into the repository.

As an example, if you modify only a stereotyped metaclass, the Check in is cancelled because the repository document and the local copy are considered identical.

It does not happen with stereotypes.



CR:738536
CR Number:   738536
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Open
OS:   Windows
Original Version:   cheverny
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The customer is requesting an enhancement to add support for the Kerberos Protcol for use with the PowerDesigner portal.



CR:738567
CR Number:   738567
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   Generic
Original Version:   15.7.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2013 Fixed
Description
IBM UDB ONLY: Improve performance for log record

processing.



CR:738681
CR Number:   738681
Product Name:   Rep Server Connectors
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
provide method in RS to diagnose why connection cannot be made to DBMS when using the connector factory, especially with DBMSs not accessible with isql.



CR:738716
CR Number:   738716
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   15.7.1 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2013 Fixed
Description
MICROSOFT SQL SERVER ONLY: text or ntext column

data fails to replicate correctly in a double byte

environment.
Workaround Description
 1. PRS/RRS must be used, this is the requirement of materialization functionality

2. then, the charset of RA and PRS/RRS must be configured as:

MSSQL(cp936) --> RAM (gb18030) --> PRS (gb18030) --> RRS (UTF8) --> HANA (UTF8)



CR:738764
CR Number:   738764
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.6 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RepServer should validate the replicate data server's ability to implement DNR and disable DNR if the RDS error message explicitly states that DNR is not supported; or if the RDS is undergoing a SHUTDOWN and does not explicitly state that DNR is not supported, don't reset DNR to 'off'.



CR:738841
CR Number:   738841
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   6.1.70
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2013 Fixed
20 Mar 2014 Added to user documentation
Description
ORACLE ONLY: After updating the log archive path

location to a new location, Replication Agent

may go down when it is unable to find the

previous archive log file.



CR:738901
CR Number:   738901
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   NA
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2013 Fixed
16 Oct 2013 Not a Bug
20 May 2013 Fixed
Description
MICROSOFT SQL SERVER ONLY: Added support for Microsoft SQL Server datatypes: date, time, datetime2, and datetimeoffset.



CR:738914
CR Number:   738914
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2013 Diagnostic Provided
Description
RS should not require a reboot of RS for changes in interfaces file.
Workaround Description
 shutdown and restart the RS



CR:738928
CR Number:   738928
Product Name:   Sybase Replication Server
Product Component:   scripts
Status:   Open
OS:   NA
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 May 2013 Fixed
04 Jun 2013 Added to user documentation
cepheus
Description
A new script (hds_oracle_new_setup_for_replicate.sql) is provided to re-initialize the replicate oracle database after dbresync.
Workaround Description
 The following script is shown in the RS 15.7.1 SP100 RB. I am pasting this out of a pre-GA draft of the 15.7.1 SP100 RB. Please check GA copy for accurate correct script:



drop table rs_info;

commit;

create table rs_info (rskey varchar2 (20), rsval varchar2 (20));

commit;

insert into rs_info values ('charset_name', 'iso_1');

commit;

insert into rs_info values ('sortorder_name','bin_iso_1');

commit;

drop public synonym rs_lastcommit;

commit;

drop table rs_lastcommit;

commit;

create table rs_lastcommit(origin number(8),origin_qid char(72 byte),secondary_qid char(72 byte), origin_time date, dest_commit_time date,conn_id number default 0);

commit;

grant all on rs_lastcommit to public;

commit;

create public synonym rs_lastcommit for rs_lastcommit;

commit;

CREATE OR REPLACE PROCEDURE RS_UPDATE_SEQUENCE

(

SequenceName VARCHAR2,

SequenceValue NUMBER,

Increment NUMBER

)

AS

CurrentID NUMBER;

LastID NUMBER;

SeqCursor INTEGER;

SQLStmt VARCHAR2(1024);

Result NUMBER;

BEGIN

SQLStmt := 'SELECT ' || SequenceName || '.NEXTVAL FROM DUAL';

SeqCursor := DBMS_SQL.OPEN_CURSOR;DBMS_SQL.PARSE(Seq-Cursor,SQLStmt,

DBMS_SQL.NATIVE);

DBMS_SQL.DEFINE_COLUMN(SeqCursor,

1,

LastID);

Result := DBMS_SQL.EXECUTE_AND_FETCH(SeqCursor);

DBMS_SQL.COLUMN_VALUE(SeqCursor,1,CurrentID);

LOOP

IF ( Increment < 0 ) THEN

EXIT WHEN CurrentID <= SequenceValue;

EXIT WHEN CurrentID > LastID;

ELSE

EXIT WHEN CurrentID >= SequenceValue;

EXIT WHEN CurrentID < LastID;

END IF;

LastID := CurrentID;

Result := DBMS_SQL.EXECUTE_AND_FETCH(SeqCursor);

DBMS_SQL.COLUMN_VALUE(SeqCursor,1,CurrentID);

END LOOP;

DBMS_SQL.CLOSE_CURSOR(SeqCursor);

END;

/

grant all on RS_UPDATE_SEQUENCE to public;

commit;

DROP sequence rs_ticket_seq;

CREATE sequence rs_ticket_seq;

Drop table rs_ticket_history;

CREATE TABLE rs_ticket_history (

cnt numeric(8,0),

h1 varchar(10),

h2 varchar(10),

h3 varchar(10),

h4 varchar(50),

pdb varchar(30),

prs varchar(30),

rrs varchar(30),

rdb varchar(30),

pdb_t varchar(128),

exec_t varchar(128),

dist_t varchar(128),

rsi_t varchar(128),

dsi_t varchar(128),

rdb_t varchar(128) default current_date,

exec_b numeric(22,0),

rsi_b numeric(22,0),

dsi_tnx numeric(22,0),

dsi_cmd numeric(22,0),

ticket varchar(1024),

conn_id number NULL);

create unique index rs_ticket_idx on rs_ticket_history(cnt);

create or replace trigger rs_ticket_tri

before insert on rs_ticket_history for each row

begin

if :new.cnt is null then

select rs_ticket_seq.nextval into :new.cnt from

dual;

end if;

end rs_ticket_tri;

/

grant all on rs_ticket_history to public;

commit;

create or replace package RS_TRIGGER_CONTROL

as

procedure ENABLE;

function IS_ENABLED

return boolean;

end;

/

create or replace package body RS_TRIGGER_CONTROL

as

fire_trigger boolean := TRUE;

function IS_ENABLED return boolean as

begin

if fire_trigger then

return FALSE;

else

return TRUE;

end if;

end IS_ENABLED;

procedure ENABLE

as

begin

fire_trigger := FALSE;

end ENABLE;

procedure DISABLE

as

begin

fire_trigger := TRUE;

end DISABLE;

end RS_TRIGGER_CONTROL;

/

grant all on rs_trigger_control to public;

drop public SYNONYM rs_trigger_control;

create public SYNONYM rs_trigger_control for rs_trigger_

control;

commit;

CREATE OR REPLACE PROCEDURE rs_send_repserver_cmd(rs_api

IN VARCHAR2)

AS

cmd VARCHAR2 (4000);

plsql_block VARCHAR2(50);

BEGIN

if (instr(lower(rs_api), 'rs_rcl') > 0) then

DBMS_OUTPUT.put_line('The Replication Server

command should not contain the keyword ''rs_rcl''');

return;

end if;

cmd := 'rs_rcl ''' || replace(rs_api, '''',

'''''') || ''' rs_rcl';

if ('rs_rcl' != substr(cmd, length(cmd) - 5)) then

DBMS_OUTPUT.put_line('The Replication Server

command is too long.');

DBMS_OUTPUT.put_line('Please split it into two

or more commands');

return;

end if;

plsql_block := 'begin rs_marker(:a); end;';

EXECUTE IMMEDIATE plsql_block USING cmd;

END;

/

drop public SYNONYM rs_send_repserver_cmd;

create public SYNONYM rs_send_repserver_cmd for

rs_send_repserver_cmd;

commit;



CR:738978
CR Number:   738978
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP101 27 May 2013 Not reproducible with latest version of the product available as of Resolution Date
04 Jun 2013 Added to user documentation
Description
When an ASE user datbase connection which uses 'dsi_dataserver_make'= ase and a customized function string directly or indirectly derived from rs_default_function_class (but is not derived from other system defined function class such as rs_oracle_function_class) has been successfully upgraded by rs_init "user database upgrade" function, the command "admin version, "connection"" reports incorrect message "Database information not found".



CR:738985
CR Number:   738985
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ability to specify the name of the connection with a dot in the admin config command, and other similar commands (sysadmin dump_queue)



CR:739068
CR Number:   739068
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2013 Fixed
21 May 2013 Fixed
04 Jun 2013 Added to user documentation
Description
When there are more than 255 columns in a table, and if any of the columns in the primary and replication definition columns are a unichar or univarchar datatype then a 揷reate subscription ... direct load command may fail with the following error message in the repserver log file,



E. 2013/05/08 14:17:29. ERROR #1027 MatApply( ) - /dsiutil.c(420)

Open Client Client-Library error: Error: 34, Severity 5 -- '[ ExpressConnect for ODBC Data Source|statement ] /calm/bldr/rsconx/odbc/generic/src/odbccolumn.cpp:1241 odbcCol::SetValue failed, value too long. Setting Parameter 15 to it's bind location failed. '.
Workaround Description
 For unichar/univarchar columns, multiply the target column length by 2. Here is an example,



Suppose col1 is of unichar (50) at the ASE source, and repdef column is defined as unichar (5), you could define the HANA target column as nchar(100).



CR:739101
CR Number:   739101
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 2014 Fixed
13 May 2013 Fixed
Description
The calculated cache size (block_size*sqm_page_size*sqm_cache_size*1024) cannot exceed 2047 MB.

If an attempt is made to configure the cache size over the limit, Rep Server will crash during start up. This fix checks the calculated cache size and reverts to default values if it exceeds the limit and will then give warnings in RS log.
Workaround Description
 Reconfigure the block_size, sqm_page_size, sqm_cache_size so the calculated cache size (block_size*sqm_page_size*sqm_cache_size*1024) is less than 2047*1048576.



CR:739280
CR Number:   739280
Product Name:   Sybase Replication Server
Product Component:   scripts
Status:   Open
OS:   Generic
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
hds_oracle_new_setup_for_replicate.sql incorrect for RS 15.7 and later. rs_lastcommit now contains a column, conn_id introduced with MPR.
Workaround Description
 create connection with profile using display_only. From the display, pick out those things that are just for the target.



CR:739284
CR Number:   739284
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   15.7.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP102 28 May 2013 Fixed
6.1.42 28 May 2013 Fixed
Description
ORACLE ONLY: Replication Agent command

'ra_dumptran' when executed may prevent

other Replication Agent commands from

being executed.



CR:739285
CR Number:   739285
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Replication needs to have scripts that only do replicate DBMS objects in case of resync.



CR:739287
CR Number:   739287
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   15.7.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2013 Insufficient priority to fix
28 May 2013 Fixed
20 Mar 2014 Added to user documentation
02 Aug 2013 Fixed
Description
ORACLE ONLY: Introduce a new Replication Agent

configuration parameter lr_max_session_cache_size

to configure the session cache size.



lr_max_session_cache_size

The maximum number of Oracle sessions to be cached

in memory during replication.



Default:1024

Value: an integer from 128 to 2147483647



CR:739376
CR Number:   739376
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 May 2013 Fixed
Description
When a subscription created with direct_load fails, RepServer would sometimes leave behind the stable queue for the catch-up connection. The subsequent command 搒ysadmin drop_queue .. would then fail to drop the queue.



CR:739416
CR Number:   739416
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2013 Fixed
Description
ORACLE ONLY: Replication Agent goes down with

ArrayIndexOutOfBoundsException when replicating

large LOB operation from Oracle RAC node other

than the first one.



CR:739467
CR Number:   739467
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for certification and documentation for Sun Cluster 3.3.



CR:739582
CR Number:   739582
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2013 Fixed
Description
When the character sets differ between the primary data server (iso_1) and the primary Replication Server (UTF8), the following error message will appear when applying CLOB data:



odbcStatement::PutData Data chunk of <x> bytes is larger than expected, total size exceeded.'.



This occurs because the character set conversion adds an additional byte per the encoding, which results in additional data beyond the initial data's length.



CR:739701
CR Number:   739701
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Closed
OS:   AIX
Original Version:   15.7.1 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 May 2013 Fixed
04 Jun 2013 Added to user documentation
Description
When using rs_init to create a new server, an incorrect CSI message is returned to the console stating that the server should not be put into production.
Workaround Description
 ignore the message. The RS is created successfully and can be used in production.



CR:739723
CR Number:   739723
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   Generic
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2013 Fixed
14 Jun 2013 Fixed
Description
IBM UDB ONLY: Replication Agent

supports replicating 'truncate table'

command.



CR:739724
CR Number:   739724
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   NA
Original Version:   15.7.1 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP102 03 Jun 2013 Fixed
Description
MICROSOFT SQL SERVER ONLY: Replication Agent

replicates a varchar single space value as an

empty string.



CR:739775
CR Number:   739775
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   cheverny
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Users using different LDAP servers each LDAP server installed in one different windows domain. These Users should be able to work with the same models on one repository.



Implement feature to be able to configure more than one LDAP server for one Repository.



CR:739797
CR Number:   739797
Product Name:   Common Metadata Repository
Product Component:   Documentation
Status:   Open
OS:   Windows
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In the "Installation Guide\Installing the PowerDesigner Portal Server\Installing the PowerDesigner Portal server on UNIX" section, step 5 references the incorrect file.





Step 5 states:



Extract the appropriate license library for your flavor of UNIX from

CMR_HOME/license/lib/sylapi 2.2.0.7.zip to CMR_HOME/license/lib."





However, if you install the Portal from PD 16.1 EBF 6 or PD 16.5, you must extract the file from the "sylapi 2.2.0.8fc.zip".



To reproduce:

1) Install Portal from 16.1 GA image

2) Apply portal EBF 6

3) Check for the referenced file, you find the following:



Under directory "C:\Program Files\Sybase\PowerDesigner Portal 16

\license\lib", there are two libraries files



"sylapi 2.2.0.8fc.zip" and "sylapi 2.2.0.7.zip"



NOTE: if you only install 16.1 EBF 6, the "sylapi 2.2.0.7.zip" is not installed.



CR:739809
CR Number:   739809
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide capability when modifying the replication definition, to affect the data already in the DSI (at a minimum, return to alter replication definition 15.2 and earlier behavior)



CR:739910
CR Number:   739910
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 May 2013 Fixed
Description
When creating a subscription with the direct load option and a quoted identifier is enabled for a column in a corresponding table replication definition, then materialization will fail

due to incorrect quoted identifier handling by RepServer.



CR:739934
CR Number:   739934
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Microsoft Windows
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When using rs_init in interactive mode, rs_init crashes when attempting to add a database to the replication system. Windows only.
Workaround Description
 use a resource file



CR:740003
CR Number:   740003
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Utilities
Status:   Open
OS:   Generic
Original Version:   15.7.1 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2013 Fixed
30 May 2013 Fixed
08 Jan 2014 Added to user documentation
17 Oct 2013 Added to user documentation
Description
Improved process for upgrade/downgrade.



CR:740027
CR Number:   740027
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Open
OS:   Microsoft Windows
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
capability to make resource file from rs_init on Windows (equivalent of CTRL+w capability on UNIX)



CR:740123
CR Number:   740123
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
provide documentation or script to clean up after SAMPLE_RS creation failure.
Workaround Description
 The following instructions will work if one has to stop the ERSSD as well as rebuild the SAMPLE_RS. Note that it uses the resource file that is created with SAMPLE_RS and that if rs_init is executed at the DOS prompt, the DOS window will go away after completion of the task:





1. 燘ring up a DOS prompt.

2. Go to the directory where you installed RS. In that directory, there should be a SYBASE.bat. Execute it.

3. At the same DOS prompt (cut and paste): set PATH=%SYBASE%\%SYBASE_REP%\ASA12\win32;%PATH%

4. Then shutdown the ERSSD:

a) In the $SYBASE/REP-15_5/samp_repserver, view the SAMPLE_RS.cfg file. Get the values for the RSSD_server name 燼nd the RSSD_primary_user .

b) go to the REP-15_5/ASA12/win32 directory.

c) execute the following command, using the proper RSSD_server_name and RSSD_primary_user and RSSD_password (the password was entered when you answered the prompts for the SAMPLE_RS creation):

d) dbstop -c "uid=RSSD_primary_user;pwd=RSSD_password;eng=RSSD_server_name"

e) for example: dbstop -c "uid=SAMPLE_RS_RSSD_prim;pwd=sa_pass;eng=SAMPLE_RS_ERSSD"

f) If it executes successfully, the prompt will say : SQL Anywhere Stop Server Utility Version 12.0.1.3152

g) One can check if the ERSSD is stopped by examining outstanding processes, or looking at the ERSSD log ($SYBASE_REP/samp_repserver/errorlog/*.out file) 爁or:

Database server stopped at <date>

5. Delete or rename the following files from the following directories:

a) under $SYBASE/$SYBASE_REP/samp_repserver

1) RUN_SAMPLE_RS

2) SAMPLE_RS.cfg

3) SAMPLE_RS.log

b) under $SYBASE/$SYBASE_REP/samp_repserver/backup

all files

c) under $SYBASE/$SYBASE_REP/samp_repserver/dbfile

all files牋

d) under $SYBASE/$SYBASE_REP/samp_repserver/errorlog

all files

e) under $SYBASE/$SYBASE_REPsamp_repserver/log

all files

6. Fix whatever the problem was

7. Ensure that your DOS prompt is at $SYBASE/REP-15_5/samp_repserver

8. To recreate the SAMPLE_RS, at the DOS prompt, execute: rs_init-SAMPLE_RS.bat After execution, the DOS window will close.

9. After the RS is created, verify that the RS is available by: isql -Usa -Ppassword -SSAMPLE_RS





***** Differences if running on UNIX ****



1. Use the UNIX command line

2. Go to the directory where you installed RS ($SYBASE). In that directory, there should be a SYBASE.csh and SYBASE.sh. Source or export the correct shell script. This will set $SYBASE.

3. In UNIX, one must the the PATH and the LD_LIBRARY_PATH (SHLIB_PATH if HP, LIB_PATH if AIX)

setenv PATH $SYBASE/$SYBASE_REP/ASA12/bin:$PATH

setenv LD_LIBRARY_PATH $SYBASE/$SYBASE_REP/ASA12/lib:$LD_LIBRARY_PATH



The rest of the steps in Windows, applies to UNIX.



CR:740140
CR Number:   740140
Product Name:   Rep Serv Admin Guide
Product Component:   Rep Serv Admin Guide
Status:   Closed
OS:   NA
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2013 Added to user documentation
02 Apr 2014 Added to user documentation
Description
Admin Guide not updated for correct path for setting environment variables for ASA12.
Workaround Description
 Substitute ASA12 for ASA11



CR:740165
CR Number:   740165
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2013 Fixed
04 Jun 2013 Fixed
04 Jun 2013 Fixed
04 Jun 2013 Fixed
29 May 2013 Fixed
14 Jun 2013 Fixed
06 Jun 2013 Fixed
Description
IBM UDB ONLY: Improved the transaction

integrity guarantee for LOB data replication.



CR:740232
CR Number:   740232
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   Generic
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2013 Fixed
Description
Replication Agent fails to automatically generate

the replication definition correctly for a table

containing quoted identifier.



CR:740249
CR Number:   740249
Product Name:   Sybase Replication Server
Product Component:   InstallAnywhere
Status:   Open
OS:   Generic
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Use real machine name instead of localhost in the interfaces file when building SAMPLE_RS



CR:740253
CR Number:   740253
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Doc
Status:   Open
OS:   Generic
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Incorrect impression on how to set asm_username in the Primary Database Guide



CR:740258
CR Number:   740258
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   NA
Original Version:   6.1.80
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2013 Fixed
26 May 2013 Fixed
Description
IBM UDB ONLY: Unable to unmark all the tables

marked for replication in Replication Agent.



CR:740429
CR Number:   740429
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP102 03 Jun 2013 Fixed
Description
ECH throws an error when the qualified column name length exceeds 90 characters.



CR:740491
CR Number:   740491
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2013 Fixed
Description
Command: "admin version, 'connection'" shows in-correct information for non-supported ds_make.



CR:740498
CR Number:   740498
Product Name:   Replication Management
Product Component:   Web UI
Status:   Open
OS:   Generic
Original Version:   3.2.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New feature request to implement options to maintain rs_ticket_history table from SCC.



CR:740508
CR Number:   740508
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP102 03 Jun 2013 Fixed
15.7.1 SP102 04 Jun 2013 Fixed
Description
ORACLE ONLY: When a table contains quoted

identifier, replication will fail when replicating

from Oracle to HANA DB.



CR:740622
CR Number:   740622
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2013 Fixed
Description
The varbinary_strip_trailing_zeros function does not work properly during direct load materialization.



CR:740656
CR Number:   740656
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 May 2013 Fixed
Description
On some occasions an attempt to create more than 10 direct load subscriptions will throw an error.



CR:740657
CR Number:   740657
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.7.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ERR #5213 DSI EXEC dsiutil.c(447) SQLMoreResults fails no data srv err messages



CR:740686
CR Number:   740686
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2013 Fixed
15.7.1 SP110 04 Sep 2013 Fixed
Description
There is a general problem using quoted identifiers for direct load materialization. Until the Create Replication Definition syntax is amended, the mixing of an unquoted table name and a quoted table name between the replicate and primary can cause a direct load subscription failure. This issue also occurs when mixing quoted/unquoted column names between the replicate and the primary. The subscription failure manifests as a SELECT statement syntax error at the primary or INSERT statement syntax error at the replicate database.
Workaround Description
 For direct load subscription materialization avoid mixing quoted/unquoted table and/or column names between the replicate and the primary.



CR:740819
CR Number:   740819
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2013 Fixed
15.7.1 SP120 24 Nov 2013 Fixed
04 Mar 2014 Already Fixed by Another CR
20 Mar 2014 Added to user documentation
Description
New command rs_repdef_schema_map to support

primary schema to replicate schema mapping

when creating replication definitions.



CR:740912
CR Number:   740912
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Open
OS:   Generic
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2013 Fixed
Description
IBM UDB ONLY: Replication Agent supports

replicating tables without a primary key.



CR:740968
CR Number:   740968
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   cheverny EBF3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Depending on the open models in the workspace the compare dialog shows invalid differences for "Target Object Package Location" on Sub-Shortcuts and "File Name" of All Target Models.
Workaround Description
 Open all dependent models if doing "Compare with Repository"



CR:741037
CR Number:   741037
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2013 Presently Not Targeted For Any Future Release Of This Product
06 Jun 2013 Fixed
07 Jun 2013 Presently Not Targeted For Any Future Release Of This Product
Description
When dsi_bulk_copy is turned on and there is an exception in the processing, the Replication Server will crash.



CR:741085
CR Number:   741085
Product Name:   Sybase Replication Server
Product Component:   InstallAnywhere
Status:   Open
OS:   Solaris
Original Version:   15.7.1 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Installer completes, however, installer log shows errors.
Workaround Description
 None. The error messages appear to be "noise". Verify that the binaries under REP*/connector/lib/* and REP*/connector/devlib/* exist. If using ECO, verify that files under REP*/connector/oraoci/* exist.



CR:741097
CR Number:   741097
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   NA
Original Version:   15.7.1 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Feb 2014 Fixed
Description
MICROSOFT SQL SERVER ONLY: Replicating varchar

and nvarchar data type column containing NULL,

empty value and empty space data into

HANA DB causes Replication Server DSI to

go down.



CR:741100
CR Number:   741100
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Utilities
Status:   Open
OS:   Generic
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Oct 2013 Added to user documentation
Description
Improved process for upgrade/downgrade.



CR:741251
CR Number:   741251
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Closed
OS:   AIX
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2013 Fixed
21 Aug 2013 Fixed
Description
The rs_init utility does not detect correct size of raw device and the "create partition" command incorrectly reports no free space when raw device partition size is equal to or larger than 2048 megabytes.
Workaround Description
 Create partitions as files or find a magic number and work with it. Another customer's experience:



My was able to create partition to 2047. He was not able to create partition from 2048 to 4096. But again was able to create partition after 4097 to 8GB.



CR:741369
CR Number:   741369
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   AIX
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP102 14 Jun 2013 Duplicate
Description
ECO (Oracle Connector) RS 1571 SP101 fails to load properly on AIX platforms when making a connection to an Oracle Database. This issue is specific to the AIX platforms and the use of ECO. Other combinations are not affected.



CR:741410
CR Number:   741410
Product Name:   Sybase Replication Server
Product Component:   DRAgent
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP111 20 Aug 2013 Bundled Request
Description
Change the sap_set_host command to allow the DR Agent port parameter to be specified.
Target Version
 15.7.1 SP111



CR:741411
CR Number:   741411
Product Name:   RepConnector
Product Component:   Run-time Engine
Status:   Open
OS:   Generic
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to provide JMS_IBM_Format=MQSTR in the JMS header.



CR:741500
CR Number:   741500
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2013 Fixed
Description
The catchup queue DSI did not quote names when dsi_quoted_identifier is set to 'always'.



CR:741541
CR Number:   741541
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7.1.6140ESD02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2013 Fixed
15.7.1 SP102 21 Jun 2013 Fixed
Description
ORACLE ONLY: Duplicate BEGIN transaction error during

bulk loading operation causes Replication Agent to

go to REPLICATION DOWN state.



CR:741630
CR Number:   741630
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2013 Fixed
Description
Distributor crashes with a signal 11 error because RepServer is attempting to access memory that has already been freed.



CR:741644
CR Number:   741644
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Microsoft Windows
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RepServer stacktraces in sqm_delseg_thread_func



CR:741694
CR Number:   741694
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   15.7.1 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2013 Fixed
Description
MICROSOFT SQL SERVER ONLY: nclob data is

replicated incorrectly with the wrong

byte order.



CR:741801
CR Number:   741801
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Aug 2013 Fixed
20 Mar 2014 Added to user documentation
16 Aug 2013 Fixed
Description
When a subscription with direct_load results in an ERROR, the subscriptions that are in ERROR are counted towards the num_concurrent_subs limit. If the number of concurrent subscriptions reaches that limit, replication Server will not start the next subscription.



CR:741988
CR Number:   741988
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jun 2013 Fixed
Description
The "admin version, 'connection'" command could not handle a <ds.db> longer than 30 characters.



CR:742209
CR Number:   742209
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   cheverny
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Recent artifact associated with a stereotyped metaclass is missing in the model checked out of the repository.



CR:742383
CR Number:   742383
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Open
OS:   Windows
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Client requires the capability of printing models or parts of models that are larger than 8.5 by 11 thorugh the Portal.



Through the Portal UI, the customer cannot print a model that is larger than screen view or group of model objects that are larger than screen. Client requests the capability of printing models or parts of models that are larger than 8.5 by 11 thorugh the Portal



CR:742478
CR Number:   742478
Product Name:   Sybase Replication Server
Product Component:   DRAgent
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP111 02 Jul 2013 Fixed
Description
Modify the timestamp format that is displayed by the DR Agent. The new format will be: YYYY-MM-DD HH:MM:SS:mmm, e.g. 2013-06-27 14:36:44.233.



CR:742479
CR Number:   742479
Product Name:   Sybase Replication Server
Product Component:   DRAgent
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP111 26 Jul 2013 Bundled Request
Description
Create a DR Agent API that displays the log messages found in the Replication Server log file.



CR:742480
CR Number:   742480
Product Name:   Sybase Replication Server
Product Component:   DRAgent
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP111 30 Jul 2013 Fixed
Description
Modify the sap_status resource result set to dispay an estimate of failover time. This value estimates the amount of time it will table for the ASE transaction log and the Replication Server queues to drain.



CR:742484
CR Number:   742484
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sysadmin lmconfig returns 'srv_xferdata' error



CR:742493
CR Number:   742493
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.6 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP101 02 Jul 2013 Fixed
Description
rs_subcmp delivered with 64bit Replication Server (repserver) 15.6 ESD#3 on linux fails with the following error ...



Parse schema file failed. [c/subcmp.c(8964)]



solution: upgrade to 64bit Replication Server 1571sp101 on linux
Workaround Description
 upgrade to rs 1571sp101



CR:742559
CR Number:   742559
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Aug 2013 Fixed
22 Jul 2013 Fixed
16 Jul 2013 Fixed
20 Mar 2014 Added to user documentation
17 Jan 2014 Fixed
Description
Allow approximate types as part

of primary key in the replication definition.
Target Version
 15.7.1 SP102



CR:742563
CR Number:   742563
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Admin
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2013 Fixed
Description
Auto-generated replication definition incorrectly

generates a fixed non-null LOB column as a null

LOB column. If the column on the replicate is

also a non-null, this will result in Replication

Server抯 DSI to go down with an error trying to

insert or update NULL into a non-null column.



CR:742608
CR Number:   742608
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   cheverny
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Expected behaviour:

Document added by "Add Document" should be Integrated into a brach where the document already exist if usign "Integrate Document". PD should open merge dialog.



Observed behaviour:

"Integrate Document" creates a second document with identical name in the a branch
Workaround Description
 1. <Repository> create Folder

2. <Repository> create Branch

3. <Local> create LDM and "check in" into Branch <default>

4. <Repository> right mouse click on LDM and do "Integrate Document" inot the new Branch



-> now it is possible to "Integrate Document" chnages between the two branches



CR:742731
CR Number:   742731
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   Windows XP
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2013 Duplicate
Description
Product: PD 16.1 EBF#11



Error: When client checked in a user profile, it is unable to edit in Repository tab.



CR:742748
CR Number:   742748
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2013 Fixed
Description
Upgrade from Rep Server v12.6 to Rep Server v15.7.1 SP100 would stop during an update to rs_subscriptions table.



CR:742755
CR Number:   742755
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2013 Fixed
05 Aug 2013 Fixed
07 Aug 2013 Fixed
14 Aug 2013 Fixed
05 Sep 2013 Fixed
22 Jan 2014 Already Fixed by Another CR
24 Apr 2014 Fixed
Description
A new configuration parameter 'dsi_check_unique_key' is now available. The default value is "on", possible values are "on" and "off". This is available at the server-level through 'configure replication server' command and at the connection-level through 'alter connection' command. This configuration parameter will toggle the replication server behavior that will check the no unique key criteria when a subscription is being materialized using direct_load.



If the primary table does not have a unique key and is using direct_load materialization, no activity is allowed on the primary until the subscription is VALID. If activity occurs during this process and 'dsi_check_unique_key' is 'on', the subscription will fail.



By turning off 'dsi_check_unique_key', the subscription may be created successfully but risks potential data inconsistency. Only turn off this configuration parameter under the following circumstances to ensure data is correct following subscription validation:

1. There cannot be any delete statements at the primary table with no unique key.

2. There cannot be any insert statements of duplicate rows at the primary table with no unique key.



CR:742867
CR Number:   742867
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP102 11 Jul 2013 Fixed
Description
MICROSOFT SQL SERVER ONLY: The origin times for

all LTL operations other than BEGIN TRANSACTION

are null when ltl_origin_time_required is set to

true.



CR:742879
CR Number:   742879
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Closed
OS:   Linux
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2013 Presently Not Targeted For Any Future Release Of This Product
Description
Some maint user names cause rs_init to core dump when adding primary db connection.



CR:742998
CR Number:   742998
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Aug 2013 Fixed
15 Aug 2013 Not a Bug
Description
When upgrading Rep Server 12.6 to Rep Server 15.7.1, issues would cause a failure to upgrade the RSSD.



CR:743000
CR Number:   743000
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jul 2013 Fixed
Description
Subscriptions created with direct_load option leaves rows in rs_recovery table. These rows record the subscription markers and positions in the outbound queue segments. They would normally be removed as the relevant outbound queue segments are freed. If the outbound queue is purged however, or rebuilt, the rs_recovery entries are not removed.
Workaround Description
 When "sysadmin sqm_purge_queue" or "rebuild queues" command is issued, you could safely issue the following command to the RSSD to get rid of the subscription related entries,



delete * from rs_recovery where action = 21 or action = 22



CR:743001
CR Number:   743001
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Include the repdef name or object id associated with each row in the stable device.



CR:743003
CR Number:   743003
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2013 Fixed
Description
RS stacks when when setting dsi_non_blocking_commit in "create connection".
Workaround Description
 Create the connection without setting dsi_non_blocking_commit . Then alter the connection to set the dsi_non_blocking_commit parameter.





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复Sybase SQL Anywhere的工具在国内应该算首创。

ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具

  1. 适用于所有的SQL Anywhere版本    包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集  包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

本工具的应用场景:

1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况;
2.误操作,包括truncate table,drop table,不正确的where条件导致的误删除等;
Sybase SQL Anywhere无法打开时,比较常见的错误是:Assertion failed。
如:
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------