提供7*24专业Sybase数据库远程及现场技术支持,Sybase ASE及Sybase SQL Anywhere数据库修复服务,
请联系电话: (微信),QQ: 289965371!
We supply technical support for Sybase ASE and Sybase SQL Anywhere, also have many years of experience in recovering data from damanged Sybase devices.
Please contact us:
Phone:
Wechat: 13811580958
QQ: 289965371 联系我们获取数据库技术支持!
Email: 289965371@qq.com
扫描下方微信,联系我们:
扫描雨翰数据恢复官方微信获取专业数据库恢复服务

 

随着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:743194
CR Number:   743194
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   beauregard EBF17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Users cant connect to the repository using LDAP



CR:743196
CR Number:   743196
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)
12 Mar 2014 Fixed
Description
UDB ONLY:

Replication Agent may fail to mark all

tables when configuration parameter

pdb_support_large_identifier is false.



CR:743231
CR Number:   743231
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)
02 Aug 2013 Fixed
21 Oct 2013 Fixed
20 Mar 2014 Added to user documentation
08 Aug 2013 Fixed
26 Sep 2013 Fixed
10 Oct 2013 Fixed
06 Dec 2013 Fixed
Description
The use of the "admin config, connection" command provides the wrong results.



CR:743256
CR Number:   743256
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)
13 Aug 2013 Fixed
27 Jul 2013 Duplicate
15.7.1 SP120 24 Sep 2013 Fixed
Description
Added a new RepServer configuration API to apply a set of configuration values with a single command.



CR:743264
CR Number:   743264
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)
15.7.1 SP110 12 Aug 2013 Fixed
Description
Added dsi_log_cmds which will work in conjunction with dsi_max_cmds_to_log to control the logging of failed/skipped commands to the rs.log file and RSSD. To configure replication server set dsi_log_cmds to <'on'|'off'> with command, "alter connection to dataserver.database set dsi_log_cmds <'on'|'off'>". The dsi_log_cmds enables logging of transactions and commands that are skipped or the result in DSI errors. Default is off, classification is database_param. When dsi_log_cmds is on, the dsi_max_cmds_to_log parameter is used to limit the number of commands recorded.



CR:743296
CR Number:   743296
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2013 Fixed
Description
When privileges on the 'rs_update_lastcommit' stored procedure is not being granted to public, Replication Server fails to replicate DDL command.
Workaround Description
 *** Tue Aug 13 2013 10:10:15 GMT+0800 (China Standard Time) *** lkong ***

Alter connnection to RDB set 'dsi_replication_ddl' to 'on' will enable repserver to switch user to original user only for DDL command.



or



Grant permission on rs_update_lastcommit to public

or to corresponding specific user who executed the DDL in primary.



CR:743383
CR Number:   743383
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)
15 Aug 2013 Fixed
Description
When an ASE timestamp type column is used as the only column in a Primary key the where clause within Rep Server is incorrectly formed.
Workaround Description
 Add a helping table repdef.



In earlier versions of RS, the helping repdef will have to be more than just the timestamp column.



CR:743461
CR Number:   743461
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Capability to specify different user id and password for each of the components in materialization. This does not apply to direct load which already has this capability.
Workaround Description
 none at this time. Materialization uses user id that has subscription authorization, and the password for that user must be identical between PRS/RRS and ASE primary.



One could create a new user in RS that would only be used for subscriptions (authorization = primary subscribe), however, that user id and password still must be on PRS/RRS and ASE primary.



CR:743557
CR Number:   743557
Product Name:   Rep Serv Admin Guide
Product Component:   Rep Serv Admin Guide
Status:   Closed
OS:   all
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2014 Fixed
Description
ASE to ASE, A2A, direct load is supported in RS 15.7.1 SP102



CR:743559
CR Number:   743559
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 17 Jul 2013 Fixed
Description
Modify the sap_set result set to provide the DR Agent generated names for the Replication Server instance and the remote ASE instance.



CR:743565
CR Number:   743565
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   chambord
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In the 'Check In Document' window the customer would like the 'Check Model' option to be available. They would like to prevent their end users from consolidating a model that contains 'metadata' errors.



The customer has been made aware that they can execute Check Model at any time via the Tools\Check Model menu.



Customer's business case:



We need to ensure that our metadata is of high quality. This includes the enforcement of consistent values in extended attributes. If the check model process could be invoked before model check-in, then the checks that we have put in-place, when they throw errors, will prevent bad quality metadata from being stored in the Repository. We are just now starting to audit the quality of metadata stored in the repository and find it quite poor at the present time. This situation needs to be improved.



CR:743576
CR Number:   743576
Product Name:   Replication Management
Product Component:   Web UI
Status:   Closed
OS:   Windows XP Pro
Original Version:   3.2.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2013 Fixed
26 Aug 2013 Fixed
Description
No activity is being reported on either the ASE rep agent thread log size or activity graph



CR:743661
CR Number:   743661
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)
19 Jul 2013 Fixed
Description
MICROSOFT SQL SERVER ONLY: Sybfilter may fail

to start on Windows x64 platform.



CR:743770
CR Number:   743770
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
marker misspelled as "maker"
Workaround Description
 data is correct. Ignore the misspelling.



CR:743792
CR Number:   743792
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Utilities
Status:   Closed
OS:   NA
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2014 Fixed
20 Mar 2014 Added to user documentation
Description
start_instance = yes in resource file does not work.
Workaround Description
 Sometimes the Rep Agent will not start after the instance is created if start_instance and initialize_instance are both set to yes. In these cases you will need to start the instance manually by invoking the run script for the instance and then running ra_admin init to initialize the instance.



CR:743797
CR Number:   743797
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   unknown
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP102 22 Jul 2013 Fixed
15.7.1 SP102 07 Aug 2013 Fixed
15.7.1 SP110 13 Aug 2013 Fixed
15.7.1 SP110 07 Aug 2013 Fixed
15.7.1 SP110 12 Dec 2013 DEFER
6.2.00 12 Dec 2013 Fixed
Description
ORACLE ONLY: If the Oracle primary is down when Replication Agent is resumed, the Replication Agent will not connect again when the primary is brought back up.
Workaround Description
 Hi, all,



Heres a few more things I have learned along with what Jianbing suggested:



- Setting both pds_tns_connection and pds_database_name (for example, both set to or112ch1) will resolve the uninitialized error with pdb_setreptable or resume. You must shutdown and restart the RA instance after configuring the parameters. Order of configuration matters.

CAVEAT: pds_database_name must be set before pds_tns_connection is set.



When pds_tns_connection is set, there is a code prevention error when you try to configure the pds_database_name (and pds_host_name and pds_port_number).

ERROR:

Unexpected exception : SqlState: 0 java.sql.SQLException: Command <ra_config> failed - Could not

set property <pds_database_name> to value <or112ch1> because: Error setting property <pds_database_

name> to value <or112ch1> because: pds_database_name can not be set when configured to use pds_tns_c

onnection for connection properties., ErrorCode: 32000



WORKAROUND:



Config pds_tns_connection to <not_configured> (ra_config pds_tns_connection, <not_configured>) (for some reason, I needed to set this twice. First time, you get an error reason: null, second time is successful need to investigate more)

Config pds_database_name (ex: ra_config pds_database_name, or112ch1)

Config pds_tns_connection to ORACLE instance (ex: ra_config pds_tns_connection, or112ch1)



- You must configure the pds_database_name first before you config pds_tns_connection.

-

- Using Resource file to create an instance, pds_tns_connection setting takes precedence over pds_database_name when both are defined in the resource file. Only pds_tns_connections/pds_tns_filename is set.



pds_database_name=<not_configured> -- DEFAULTS

pds_host_name=<not_configured> -- DEFAULTS

pds_port_number=1111 - DEFAULTS

pds_tns_connection=or112ch1

pds_tns_filename=/net/radepot/lanrat/work/lisalew/tnsnames.ora



WORKAROUND:



Set pds_tns_connection to <not_configured> (for some reason, you need to set this twice. First time, you can an error, second time is successful need to investigate more)

config pds_database_name

Then configure pds_tns_connection



- As Jianbing suggested, do not use pds_tns_connection/pds_tns_filename and only use pds_database_name/pds_port_number/pds_host_name



Thanks



Lisa



CR:743820
CR Number:   743820
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Aug 2013 Fixed
Description
In Dynamic SQL Mode, the OCI connector replicates Binary or Oracle RAW data as NULL.
Target Version
 15.7.1 SP110



CR:743875
CR Number:   743875
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Open
OS:   Microsoft Windows NT
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ra_admin and pdb_xlog displays are not the same.
Workaround Description
 ra_admin is more accurate.



CR:743928
CR Number:   743928
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
FR: RCL command to get Rep Server boot time



CR:743946
CR Number:   743946
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Management
Status:   Open
OS:   Generic
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ra_config should do "like" comparisons on the configuration parameters.
Workaround Description
 search the .cfg with vi or notepad.



CR:744019
CR Number:   744019
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   HP-UX
Original Version:   15.2 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2013 Workaround
Description
When creating replication defintion, the RS stacks.



CR:744042
CR Number:   744042
Product Name:   Replication Management
Product Component:   Web UI
Status:   Closed
OS:   Windows XP Pro
Original Version:   3.2.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Aug 2013 Fixed
Description
DR Agent implemented a more accurate ASE transaction back log calculation



CR:744144
CR Number:   744144
Product Name:   Sybase Replication Server
Product Component:   DRAgent
Status:   Closed
OS:   NA
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP111 16 Aug 2013 Fixed
Description
The DR Agent will provide new commands to assist with upgrading the Replication Server and ASE on a standby host in an existing SAP Disaster Recovery replication environment.



CR:744307
CR Number:   744307
Product Name:   RepConnector
Product Component:   Run-time Engine
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2013 Fixed
Description
Customer requested certification of RSME (Rep Server Messaging Edition) using JBoss.



CR:744310
CR Number:   744310
Product Name:   RepConnector
Product Component:   Run-time Engine
Status:   Open
OS:   AIX
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
When running the SAP version of java on AIX, an error similar to this may be seen:



$ java -version



os::malloc: failed to malloc 1048576 bytes (errno 12).#

# There is insufficient memory for the Java Runtime Environment to continue.

# Native memory allocation (malloc) failed to allocate 1048576 bytes for /bas/sapjvm/cons/6/src/6/hotspot/src/share/vm/utilities/taskqueue.hpp:383: E/bas/sapjvm/cons/6/src/6/hotspot/src/share/vm/utilities/taskqueue.hpp. Out of swap space or heap resource limit exceeded (check with limits or ulimit)?
Workaround Description
 1. Rename the java executable under ${JAVA_HOME} to 'java.aix'.

2. In place of the java executable, put the following into an executable script named 'java':

#!/bin/sh

LDR_CNTRL=MAXDATA=0x80000000 ${JBOSS_HOME}/repra/sapjvm_6/jre/bin/java.aix "$@"



references:

http://ftp.magicsoftware.com/www/help/ibolt3/mergedProjects/How_To/Malloc_Failure_on_AIX.htm

http://pic.dhe.ibm.com/infocenter/tivihelp/v2r1/index.jsp?topic=%2Fcom.ibm.itame.doc_6.0%2Frev%2Fam60_perftune64.htm



CR:744316
CR Number:   744316
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)
06 Nov 2013 Workaround
Description
An instance of the Replication Agent for Microsoft SQL Server was able to be instantiated on a different host than the database server.
Workaround Description
 To initialize an instance on a host other than the primary database server (e.g. when log files are shared over the network or instance is part of a cluster instance), set verify_sybfilter=no in the resource file.



CR:744373
CR Number:   744373
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2013 Fixed
15.7.1 SP101 12 Dec 2013 Fixed
15.7.1 SP110 12 Sep 2013 Fixed
Description
ORACLE ONLY: Replication Agent fails to be resumed

with resync option due to NullPointerException.



CR:744380
CR Number:   744380
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
Provide capability to send whole numbers to replicate with a precision (e.g. 4.0).
Workaround Description
 currently none



CR:744383
CR Number:   744383
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 SP110 21 Aug 2013 Workaround
Description
Installer for SP102 gets into infinite loop if sysam properties file does not have correct permission.
Workaround Description
 If a user encounters a permissions issue due to work done outside the installer, they should cancel the install session and fix the permission issue.



CR:744442
CR Number:   744442
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)
Description
15.7.1 SP 102 Cover Letter states that it is compiled with OCS SP 100, instead of SP 101.



CR:744466
CR Number:   744466
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Open
OS:   MVS
Original Version:   15.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
0C4 in LTMGMSG when RSSD password is incorrect.
Workaround Description
 put a valid RSSD password



CR:744605
CR Number:   744605
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)
27 Feb 2014 Fixed
05 Feb 2014 Fixed
Description
The automatic materialization option was enhanced to use stripes to improve dump and load processing time.



CR:744610
CR Number:   744610
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
W. ####/##/## ##:##:##. WARNING #13110 DSI(### rds.rdb) - ul/cmapp.c(2023) 'rds.rdb' does not return native errors. Error action mapping may not be correct.



workaround



hard code RepServer to always return



varchar (3) 'yes' 0x79657





******************************************************************************************

use RSSD

go



rs_helpclassfstring rs_msss_function_class,rs_get_errormode

go



Note: the above rs_helpclassfstring should report the default "select @@ReturnNativeError"



update rs_systext set textval = "select 'yes'" where parentid = 0x000000000ffff825

select * from rs_systext where parentid in (select fstringid from rs_funcstrings where funcid = 0x0000000004000025 and classid = 0x0000000001000011 and fstringid = 0x000000000ffff825)

go



rs_helpclassfstring rs_msss_function_class,rs_get_errormode

go



Note: the above rs_helpclassfstring should report the new value for rs_get_errormode which is

select 'yes'



Then shutdown and restart repserver.

******************************************************************************************
Workaround Description
 hard code RepServer to always return



varchar (3) 'yes' 0x79657





******************************************************************************************

use RSSD

go



rs_helpclassfstring rs_msss_function_class,rs_get_errormode

go



Note: the above rs_helpclassfstring should report the default "select @@ReturnNativeError"



update rs_systext set textval = "select 'yes'" where parentid = 0x000000000ffff825

select * from rs_systext where parentid in (select fstringid from rs_funcstrings where funcid = 0x0000000004000025 and classid = 0x0000000001000011 and fstringid = 0x000000000ffff825)

go



rs_helpclassfstring rs_msss_function_class,rs_get_errormode

go



Note: the above rs_helpclassfstring should report the new value for rs_get_errormode which is

select 'yes'



Then shutdown and restart repserver.

******************************************************************************************



CR:744680
CR Number:   744680
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2013 Fixed
04 Dec 2013 Fixed
Description
When upgrading RepAgent, the properties file "<install dir>/RAX-15_5/config/RS_repdef_reserved.props" was being overwritten.



CR:744752
CR Number:   744752
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)
27 Sep 2013 Fixed
Description
When RepServer processes a large number of subscriptions created with the direct_load option, a subscription would occationally fails with messages similar to the following in the repserver log:



E. 2013/08/05 09:49:49. ERROR #13045 MatApply( ) - seful/cm.c(4936)

Failed to connect to server 'HANARep' as user 'q06maint'. See CT-Lib and/or server error messages for more information.

E. 2013/08/05 09:49:49. ERROR #28153 SUB(sub_l_CUS_ACTOBT) - /sub_mat.c(1207)

Subscription <sub_l_CUS_ACTOBT> for replication definition <ra$UDBPrimary_Q04_SAPQ04_CUS_ACTOBT> with replicate at <HANARep.Q06> has experienced an unrecoverable error. The error flag for the subscription has been set
Target Version
 15.7.1 SP120



CR:744819
CR Number:   744819
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2013 Fixed
10 Feb 2014 Presently Not Targeted For Any Future Release Of This Product
Description
ORACLE ONLY: Error during rollback

processing sends Replication Agent to

REPLICATION DOWN state.



CR:744914
CR Number:   744914
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2013 Fixed
20 Mar 2014 Added to user documentation
Description
ORACLE ONLY:Replication Agent supports replicating

the table in which a materialized view is stored

in the primary database to an ordinary table in

the replicate database.



CR:744920
CR Number:   744920
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   AIX
Original Version:   6.1.110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2013 Fixed
16 Aug 2013 Fixed
Description
ORACLE ONLY: NullPointerException during LOB

processing sends Replication Agent to

REPLICATION DOWN state.
Workaround Description
 To avoid replication down, increase the retry times:

e.g.:

ra_config rs_retry_count, 100

go



CR:744965
CR Number:   744965
Product Name:   Sybase Replication Server
Product Component:   DRAgent
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP111 22 Aug 2013 Fixed
Description
Add a sap_set_databases command to provide a list of database names for setting up a new replication environment. The database list will be verified, persisted, and used to validate any sap commands specifying a database name. If a commands database name does not exist in the database list, the command will be rejected.



If database names are NOT set, the default database names master, <SID>, and saptools will be used when setting up a new replication environment.



Once a replication environment has been setup its database list cannot be modified.



CR:745185
CR Number:   745185
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)
01 Jan 2014 Fixed
20 Mar 2014 Added to user documentation
Description
Retryable error actions modified. The current number of times a retry is attempted is based on the configuration command_retry. Default is to retry 3 times. There is no sleep between retries.



Added a new error action called "retry_forever":

- Any error with severity 17 will have this error action as default action

- It will retry forever

- It will sleep for DSI_RETRY_INTERVAL_C (14 seconds) between retries.

- It will print a message about "still retrying" every 2 minutes.



CR:745186
CR Number:   745186
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)
02 Jan 2014 Fixed
14 Jan 2014 Added to user documentation
Description
Retryable error actions retry fixed number of times based on the configuration command_retry. Default is to retry 3 times. There is no sleep between retries.



We will add a new error action called "retry_forever":

- Any error with severity 17 will have this error action as default action

- It will retry forever

- It will sleep for DSI_RETRY_INTERVAL_C (14 seconds) between retries.

- It will print a message about "still retrying" every 2 minutes.



CR:745227
CR Number:   745227
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2013 Fixed
20 Mar 2014 Added to user documentation
Description
IBM UDB ONLY: Support UDB migration between

different minor versions.



CR:745236
CR Number:   745236
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2013 Presently Not Targeted For Any Future Release Of This Product
19 Aug 2013 Fixed
26 Oct 2013 Fixed
Description
ORACLE ONLY: Replication Agent failed to send a

commit or rollback transaction notification to

Replication Server and that resulted in an open

transaction in Replication Server.
Workaround Description
 None



CR:745364
CR Number:   745364
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2013 Fixed
Description
When the "admin version, "connection"" command is used it returns "Database needs upgrade." for a newly created replication server instance.
Workaround Description
 use "sysadmin upgrade, "database", ds_name, db_name" to upgrade the database which indicates "needs upgrade".



CR:745409
CR Number:   745409
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   NA
Original Version:   6.1.110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2013 Fixed
Description
IBM UDB ONLY: Replication Agent cannot update

the pdb_archive_control_path configuration.



CR:745454
CR Number:   745454
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   NA
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2013 Presently Not Targeted For Any Future Release Of This Product
Description
RepAgent installer fails with NullPointerException when the user's account has a $HOME directory that is read-only.



Workaround: Install RepAgent with a userid that has a $HOME directory with write permissions.
Workaround Description
 [CR745454]

Replication Agent installer fails with NullPointerException when the user's

account has a $HOME directory that is read-only.



Workaround:

Install RepAgent with a userid that has a $HOME directory with write

permissions.



CR:745461
CR Number:   745461
Product Name:   Sybase Replication Server
Product Component:   DRAgent
Status:   Closed
OS:   NA
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP111 26 Aug 2013 Fixed
Description
Add a new command to the DR Agent API to configure Replication Server and Replication Server database connection parameters.



CR:745487
CR Number:   745487
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.7.1 N-Off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ERROR #32059 Invalid object identifier for table or function
Workaround Description
 *** Fri Aug 23 2013 11:23:26 GMT-0600 (Mountain Standard Time) *** gcarter ***

Changing site_version to at least 1550 works around the issue.



CR:745534
CR Number:   745534
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2013 Not a Bug
21 Oct 2013 Fixed
Description
MSSQL ONLY: Cannot use direct load materialization with the following MSSQL data types: ntext, varchar(max), nvarchar(max), varbinary(max)



CR:745556
CR Number:   745556
Product Name:   Replication Management
Product Component:   Web UI
Status:   Closed
OS:   Generic
Original Version:   3.2.8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2013 Fixed
Description
Authenticating a Replication Agent version 15.7.1 generates an error in the SCC UI and errors in the gateway.log



CR:745654
CR Number:   745654
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)
Description
'create connection using profile rs_ase_to_ase;standard' fails



CR:745724
CR Number:   745724
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)
Description
Logical connection with active only, unable to resume DIST after 'set distribution on'
Workaround Description
 purge queue, manually update rs_databases for the logical connection to set dist_status to 1 and enable_seq to 0 and restart the server



CR:745726
CR Number:   745726
Product Name:   Sybase Replication Server
Product Component:   DRAgent
Status:   Closed
OS:   Linux
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP111 22 Oct 2013 Fixed
Description
The sap_set command is throwing an ArrayIndexOutOfBoundsException when it checks for arguments when none exist.



CR:745840
CR Number:   745840
Product Name:   Rep Serv Admin Guide
Product Component:   Rep Serv Admin Guide
Status:   Open
OS:   all
Original Version:   15.7.1 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
changing to RDB(PDB) from PDB(RDB) does not correspond to latest version.
Workaround Description
 Stored procedure the following is required for each site.

Customers need to find rs_install_primary.sql and rs_install_replicate.sql from the source code of these.

And Customers must grant execute permissions to public users.



Primary Site

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

rs_marker

rs_check_repl_stat

rs_ticket

rs_ticket_v1

rs_ticket_report

rs_send_repserver_cmd



Replication Site

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

rs_get_thread_seq



In addition, Customer must use rs_update_thread of rs_install_replicate.sql to the primary.



CR:745849
CR Number:   745849
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2013 Presently Not Targeted For Any Future Release Of This Product
06 Nov 2013 Fixed
30 Oct 2013 Added to user documentation
20 Mar 2014 Added to user documentation
Description
After upgrading Microsoft SQL Server DB version from 2008 to 2008R2 or later version, ra_migrate Replication Agent command fails.



Workaround: Review Replication Agent documentation about upgrading the Microsoft SQL Server

database.
Workaround Description
 [CR745849]

After upgrading Microsoft SQL Server DB version from 2008 to 2008R2 or later version, ra_migrate Replication Agent command fails.



Workaround: Review Replication Agent documentation about upgrading the Microsoft SQL Server

database.



CR:745948
CR Number:   745948
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
repserver -upgr ... seamless upgrade with pending subscriptions stops with wrong error



here is the error message where the upgrade process should be stopping ...

SENDMESG, spid ##: Msg 17001, Severity 16, State 1

Please complete your pending subscription create/drop before upgrading.



here is the the wrong error message where the upgrade process eventually stops ...

Message from server: Message: 208, State 1, Severity 16 -- 'rs_objects1500 not found.

Specify owner.objectname or use sp_help to check whether the object exists (sp_help

may produce lots of output).'.
Workaround Description
 clear away the subscriptions that show in the result set of the following query ...

select * from rs_subscriptions where materializing <> 0 or dematerializing <> 0



2 ways

1) delete rs_subscriptions where materializing <> 0

... or ...

2) update rs_subscriptions set materializing = 0 where materializing <> 0



CR:745949
CR Number:   745949
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Sep 2013 Fixed
02 Apr 2014 Added to user documentation
Description
When using the command "repserver -upgr ..." the seamless upgrade fails because rs_subscriptions1570.mechanism col should allow nulls but does not. This results in the following message: E. 2013/08/27 15:43:33. ERROR #1028 GLOBAL RS(GLOBAL RS) - ain/upgr.c(3976) Message from server: Message: 515, State 3, Severity 16 -- 'Attempt to insert NULL value into column 'mechanism', table '<rssd_dbname>.dbo.rs_subscriptions1570'; column does not allow nulls. Update fails.'.
Workaround Description
 change the $SYBASE/$SYBASE_REP/upgrade/rsupgr_ase.sql script to change all null values in the mechanism column to empty string "" before inserting them into the rs_subscriptions1570 table. An update statement [update rs_subscriptions set mechanism = "" where mechanism is null] is add before the insert into rs_subscriptions1570 statement.



change the following STEP 3 section of $SYBASE/$SYBASE_REP/upgrade/rsupgr_ase.sql from . . .



...

/* STEP 3: Insert into the new table */

begin

if not exists (select * from #upgrade

where version >= 1570 or hadError <> 0)

begin

insert into rs_subscriptions1570

(

...



. . . to . . .



...

/* STEP 3: Insert into the new table */

begin

if not exists (select * from #upgrade

where version >= 1570 or hadError <> 0)

begin

/* some repserver upgrade from 11.X will contain null value */

update rs_subscriptions set mechanism = ""

where mechanism is null



insert into rs_subscriptions1570

(

...



CR:745958
CR Number:   745958
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2013 Fixed
Description
ORACLE ONLY:If pds_tns_filename configuration

parameter is configured with a tnsnames.ora

file which contains lowercase characters

in the TNS connection string, then when you

execute 'ra_config pds_host_name' or

'ra_config pds_port_number', errors may result.
Workaround Description
 change tnsnames.ora file to have key words in ALL CAPS ... like ... HOST and PORT etc



CR:745977
CR Number:   745977
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
cepheus 06 Jan 2014 Fixed
cepheus 20 Mar 2014 Added to user documentation
Description
ORACLE ONLY: The command move_truncpt does not

work if Oracle archive directory is empty.
Workaround Description
 1. Restore the archive directory with logs. At this time, I don't know if any log will do or which of the archive logs is needed.



2. the root cause is Oracle view v$archived_log becomes out of sync after customer removed Oracle archive files. So to execute RMAN "crosscheck archivelog" command to update v$archived_log view can workaround the issue.



CR:746024
CR Number:   746024
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)
05 Sep 2013 Fixed
Description
Race condition - During the direct load materialization for a large table using multiple apply threads, one of the apply threads might lose the last chunk of data, and cause data loss. Parallel direct load - When starting a large number of direct load requests simultaneously for large tables, the select clause from the primary DB might fail with the follow error; I. 2013/08/30 01:08:50. Message from server: Message: 32000, State 0, Severity 0 -- 'Command <pdb_execute_sql> failed - Error <Connection to be released <com.sybase.ra.conn.RAConnection@4c3d2615> not found in pool.> encountered closing connection to Primary Database <odehost2>'. Bulk/DSQL - Due to the inaccurate calculation of the batch size, some of the rows will be applied without using bulk inserts thereby affecting the replicate performance.



CR:746099
CR Number:   746099
Product Name:   Sybase Replication Server
Product Component:   DRAgent
Status:   Closed
OS:   Generic
Original Version:   15.7 SP100 PL00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Feb 2014 Bundled Request
Description
The 'unplanned' keyword was added to the sap_failover command. In a failover scenario where the primary ASE is down, the user should execute the sap_failover command with the 'unplanned' option. This will force the standby ASE to become the HADR primary ASE. Note there is potential data loss in an unplanned failover scenario.



CR:746119
CR Number:   746119
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)
Description
RS stack with Monitors and Counters running while direct load is also running.
Workaround Description
 Do not turn on Monitors and Counters.



CR:746158
CR Number:   746158
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 2013 Fixed
23 Jan 2014 Already Fixed by Another CR
Description
When a downstream RepServer v12.6 is preceded by a v15.7.1 SP110 RepServer the 12.6 Repserver fails to parse commands from the 15.7.1 RepServer. This only occurs when the RSSD is an ASE v15.7 or later.



CR:746232
CR Number:   746232
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2013 Presently Not Targeted For Any Future Release Of This Product
17 Sep 2013 Fixed
23 Sep 2013 Fixed
Description
When using admin config command it does not return any results for the ascii_pack_ibq parameter.



CR:746314
CR Number:   746314
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Oct 2013 Fixed
Description
Warmstandby text column update fails with 'Incorrect syntax near 'FAILED'.



CR:746374
CR Number:   746374
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   NA
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RAO1571sp102 restore msgs to rao.log stating log thread reader moving to log ###



with version rao 156x the following lines used to be seen in the rao.log



I. 2013/08/30 16:52:21.067 INFORMATION com.sybase.ds.oracle.log.OracleRedoLogThreadR Oracle redo log thread reader for thread <1> is moving to log <68725>.



these msgs report progress rao is making reading through oracle's redo and archive log and are useful. add these same msgs in version 1571x.



CR:746417
CR Number:   746417
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)
Description
Capability to split direct load for a single target database across multiple Rep Servers and hosts.



CR:746555
CR Number:   746555
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2013 Fixed
Description
MSSQL ONLY: Cannot truncate table that was

previously marked for replication but has since

been unmarked.
Target Version
 15.7.1 SP120
Workaround Description
 Manually disable replication fo the table:



Get the object id for the table:



ra_helparticle table_name



Execute the sp_SybSetLogforReplTable specifying the table's object id and mark status of 0:



exec sp_SybSetLogforReplTable object_id, 0



CR:746657
CR Number:   746657
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)
24 Sep 2013 Failed
25 Nov 2013 Fixed
24 Sep 2013 Fixed
Description
When there are more than 32,768 users on the system, running running 'ra_admin init' may cause an arithmetic overflow error.



CR:746712
CR Number:   746712
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2013 Fixed
24 Sep 2013 Fixed
Description
MICROSOFT SQL SERVER ONLY: Replication Agent

hangs during bi-directional replication of

LOBs.



CR:746720
CR Number:   746720
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   HP-UX
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2014 Already Fixed by Another CR
12 Feb 2014 Fixed
Description
UDB ONLY: Executing the command

ra_set_autocorrection all, enable

may fail when there exists unmarked

tables in the primary database.



CR:746785
CR Number:   746785
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 2013 Fixed
Description
*** Fri Sep 27 17:26:14 UTC+0800 2013 *** ljoice ***

Replication Agent is unresponsive after several

invalid SQL statements are executed using

pdb_execute_sql.



CR:746787
CR Number:   746787
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   HP-UX
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2014 Fixed
Description
UDB ONLY: Auto-correction is not disabled after

unmarking a table.



CR:746791
CR Number:   746791
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent
Status:   Open
OS:   Generic
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2013 Fixed
17 Nov 2013 Fixed
30 Oct 2013 Fixed
21 Nov 2013 Fixed
25 Nov 2013 Fixed
01 Dec 2013 Fixed
18 Dec 2013 Fixed
09 Dec 2013 Fixed
18 Dec 2013 Fixed
09 Jan 2014 Fixed
17 Jan 2014 Fixed
cepheus 05 Jan 2014 Fixed
13 Jan 2014 Fixed
Description
DDL replication as part of Cepheus DB subscription enhancement feature, which enables hetegeneous DDL replication; the main target database is HANA, while the source databases will cover MSSQL, IBM UDB and Oracle;
Target Version
 cepheus



CR:746808
CR Number:   746808
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2013 Fixed
Description
ORACLE ONLY: Replication Agent fails to mark a

table whose name contains special character(s).

Example: db_setreptable "a/special/table/name"
Target Version
 15.7.1 SP1xx



CR:746966
CR Number:   746966
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)
12 Nov 2013 Fixed
20 Mar 2014 Added to user documentation
Description
Change Error message and the comments of resource files to indicate that default user id and password is not allowed to create RAX instance unless "-e" option is defined.



CR:746971
CR Number:   746971
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2014 Fixed
Description
ORACLE ONLY: Replication Agent goes to the REPLICATION

DOWN state with no article found error when the table

marking process is not completed successfully and

changes have been applied on the table.
Workaround Description
 Resume Replication Agent.



CR:746984
CR Number:   746984
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   HP-UX
Original Version:   6.1.110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP110 23 Sep 2013 Fixed
15.7.1 SP110 20 Sep 2013 Fixed
Description
ORACLE ONLY: NULL Secure Files LOB value is

incorrectly replicated as 0x.
Workaround Description
 Setting the Oracle database parameter db_securefile = PERMITTED can workaround this issue.



SQL> connect sys as sysdba

Enter password:

Connected.

SQL> alter system set db_securefile = 'PERMITTED';



System altered.



SQL> show parameter db_securefile



NAME TYPE VALUE

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

db_securefile string PERMITTED



CR:747015
CR Number:   747015
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2013 Presently Not Targeted For Any Future Release Of This Product
17 Sep 2013 Fixed
Description
If the DSI for the target connection goes down when a subscription created with the direct_load option is being processed, the subscription should be marked ERROR.
Workaround Description
 After the target DSI is resumed, the subscription in question should be dropped and recreated again.



CR:747039
CR Number:   747039
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   NA
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
replication agent for oracle ... ra_locator gets stuck compared to the corresponding value in the rs_locater table in replication server.



RAO1571sp102 ra_locator gets stuck ... "ra_" row found in <prefix>_agent in pdb



'RA_' is the default prefix.



RAO1571sp102 ra_locator gets stuck ... "ra_" row found in RA_agent table in pdb (oracle)
Workaround Description
 select * from <pdsuser>.<prefix>agent;



look for multiple rows and the row with the 'ra_' value in the prefix column has a locator value of all zeros.



delete from rep_admin.ra_agent where prefix='ra_';



CR:747076
CR Number:   747076
Product Name:   Sybase Replication Server
Product Component:   scripts
Status:   Open
OS:   Solaris
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A permission error #11061 may occur when creating a user on the Replication Server after upgrading from 15.6 to 15.7.1.
Workaround Description
 grant all on rs_passwords to rs_systabgroup

grant all on rs_dictionary to rs_systabgroup



CR:747213
CR Number:   747213
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   AIX
Original Version:   15.7.1 SP101
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Oct 2013 Fixed
20 Oct 2013 Fixed
11 Dec 2013 Fixed
12 Mar 2014 Fixed
Description
Invalid object name is found in srv__create_obj while replicating to IQ, when IQ logs back into Replication Server.
Workaround Description
 nothing found at this time. Increasing num_mutexes has not helped.



CR:747365
CR Number:   747365
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   6.1.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2013 Fixed
23 Sep 2013 Fixed
Description
ORACLE ONLY: NullPointerException during LTL

formatting of a table that contains an

unsupported spatial type causes Replication

Agent to go to REPLICATION DOWN.



CR:747408
CR Number:   747408
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)
25 Sep 2013 Fixed
Description
Some of the RepServer's parameters have a default value that are out of the range of the legal value list.



CR:747468
CR Number:   747468
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7.1 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2013 Fixed
28 Oct 2013 Fixed
20 Mar 2014 Added to user documentation
Description
ORACLE ONLY:If the service name of the primary database

is different from the database name, XStream based

Replication Agent would fail to connect to the primary

database even if pds_service_name is correctly configured.

LogMiner based Replication Agent would fail to connect to

the primary database for same cause if its use_ssl

parameter is configured to true.



CR:747812
CR Number:   747812
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   NA
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
cepheus 21 Jan 2014 Fixed
05 Jul 2014 Fixed
Description
MICROSOFT SQL SERVER ONLY:

A change in the BEGIN_XACT log record body from

MSSQL 2008 to MSSQL 2012 can cause a parsing error

that stops replication.



CR:747932
CR Number:   747932
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 Oct 2013 Fixed
19 Nov 2013 Fixed
Description
If both DR Agent's do not resolve the primary and standby hostnames identically, master materialization fails to complete. The workaround is to execute master materialization on the standby DR Agent.



CR:747942
CR Number:   747942
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 Oct 2013 Fixed
15.7.1 SP120 15 Oct 2013 Fixed
Description
Replicating Oracle varchar to a HanaDB nvarchar can cause data corruption using bulk copy. The problem occurs when the first varchar column value contains NULL.



CR:748236
CR Number:   748236
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   chaumont
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Icons of models in local browser tab are not updated correctly from the Repsitory. Extended Model Signatur shows differences during check out.



CR:748347
CR Number:   748347
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Open
OS:   Generic
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
setupdb.rs template: remove LTM references and add required RA props



CR:748367
CR Number:   748367
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   cheverny
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Title: Branch Integration functionality to allow use of Change lists



Description:

Integrating from development Branches to a development Trunk should be simpler, suggest using the Change List mechanism to allow a streamlined process yet still retain control of the Trunk model.





Use of Change Lists in integrating branches to trunk

Scenario - customer has multiple branches with the same model. Users have permissions on their branch but not write permissions to the trunk. Use of change list should be implemented to allow branch users to submit an integration to be approved by the admin of the change list.



CR:748368
CR Number:   748368
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   cheverny
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add feature to push changes from main (root) model out to models in the Branch



Enhancement to sync trunk changes with branches in the repository



Scenario - customer has multiple branches with the same model. When a user submits a change to his branch and then integrates it with the trunk (main) model, they would like these changes to replicate or sync down to all the branch models.



Customer's comments:



We need a way to get changes (in the root\main model) integrated back to branches without removing work in the branch its too complicated to pick changes out manually. The integration back should omit anything touched in the branch and overwrite anything not touched.



CR:748581
CR Number:   748581
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   15.7.1 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide info in DIST error message so that the command is easier to locate and zap in the inbound/outbound queue.



CR:748620
CR Number:   748620
Product Name:   Sybase Replication Server
Product Component:   DRAgent
Status:   Closed
OS:   Linux
Original Version:   15.7.1 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 SP111 10 Oct 2013 Fixed
10 Oct 2013 Fixed
Description
When retrieving information from the Replication Server, the DR Agent is inadvertently formatting the Replication Server site version. DR Agent should pass a version number with no numeric formatting.



CR:748632
CR Number:   748632
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   cheverny
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 2014 Consult Complete
Description
Enhancement request to bypass the merge window if there are no conflicts

Add functionality on a Check in / Check-out before the Merge window to bypass the Merge window if there are no conflicts.



For the functionality, client is requesting code that would automatically check for no conflict and skip the merge screen altogether.



Please see customer's document for more context for this enhancement request.



CR:748653
CR Number:   748653
Product Name:   Sybase Replication Server
Product Component:   InstallAnywhere
Status:   Open
OS:   Microsoft Windows
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Windows: SAMPLE_RS fails to boot because grace is based on Sybase products already present on the host.
Workaround Description
 Add the license, clean up the pieces of the SAMPLE_RS, and re-create the SAMPLE_RS (see rs_init-SAMPLE_RS.bat script in $SYBASE/REP*/samp_repserver . Resource file used is in the same directory.



CR:748658
CR Number:   748658
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2013 Fixed
Description
On windows platforms only, create Rep Server does not complete if the partition specified is at the disk drive level (e.g. e:\part1.dat)
Workaround Description
 The Rep Server is still up despite the failure.



Create the partition manually by executing the create partition command. The create partition command will allow the file to be directly off the disk drive.



Add the rsi user, the id user (see rs.cfg file for the proper name of the id user) and the ra user manually. The id user has no grants. The ra and rsi users have connect source permission.



The heterogeneous scripts have been added prior to RS bootup in SP110 so they do NOT need to be loaded.



CR:748667
CR Number:   748667
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7.1 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2013 Fixed
20 Mar 2014 Added to user documentation
Description
On windows platforms only, when rs_init is unable to create a partition while in the GUI window, rs_init aborts.
Workaround Description
 1) run rs_init as administrator (right mouse click option) --or-- 2) put the partition in a directory under the disk drive (e.g. c:\dir\stable.dat ) Was working on CR 748658 when this problem occurred.



CR:748708
CR Number:   748708
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)
14 Oct 2013 Fixed
15 Oct 2013 Fixed
Description
HVAR fails to apply NULL Oracle decimals to HANA database. The issue happens when all the decimal values are NULL for the same decimal column in the data set being applied by the current array processing operation.



CR:748721
CR Number:   748721
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)
Description
Provide capability to: 1) continue direct load even if there is an error 2) if there are errors, print enough identifying information in log or file so that the row can be found at the primary 3) provide a file so that it is easy to find/load after-the-fact rows that were missed.
Workaround Description
 none -- capability to continue despit problems is not available as of SP 110





--------------------------------------华丽的分割线-------------------------------------------------------------------------

Sybase SQL Anywhere数据库恢复工具ReadASADB:

之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具: ReadASADB。
此工具支持ASA v5.0, v6.0, v7.0, v8.0, v9.0, v10.0, v11.0, v12.0, v16.0, v17.0等版本。
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具。
恢复Sybase SQL Anywhere的工具在国内处于领先水平。

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,16.x,17.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使用介绍

Sybase SQL Anywhere数据库恢复工具ReadASADB适用场景

各种误操作:

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

Sybase SQL Anywhere数据库恢复工具ReadASADB的应用场景:

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
7、*** ERROR *** Assertion failed: 201417 (7.0.4.3541) Invalid count or free space offset detected on a table page
8、Internal database error *** ERROR *** Assertion failed: 201425 (8.0.3.5594) Invalid count or free space offset detected on a free list page -- transaction rolled back.
9、Internal database error *** ERROR *** Assertion failed: 100702 (8.0.1.2600) Unable to modify indexes for a row referenced in rollback log -- transaction rolled back


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

Sybase ASE数据库恢复工具READSYBDEVICE:

一个不依赖数据库管理系统、直接从Sybase数据库设备文件上提取数据的业内领先的恢复工具!
能够从损坏的Sybase ASE设备文件(.dat)上提取数据的非常规恢复工具。

Sybase ASE数据库恢复工具READSYBDEVICE的主要功能:

  1. 被勒索病毒加密数据文件及备份文件情况下的恢复;
  2. 系统崩溃只剩下数据文件的情况下的恢复,甚至数据库文件不存在而只有损坏的备份文件情况下的恢复;
  3. 因断电、硬盘坏道等造成数据库文件损坏情况下的恢复;
  4. delete数据恢复、误update数据恢复、误删除表(drop)恢复、误truncate表恢复 等;
  5. 各种Sybase内部系统表损坏、索引错误的修复;
  6. master数据库损坏而无法正常运行情况下的恢复;
  7. Sybase数据库被标记为可疑,不可用等情况的恢复;
  8. Sybase数据库中数据文件内部出现坏块情况下的恢复;
  9. Sybase数据库无数据文件但有日志文件的情况下的恢复;
  10. Sybase数据库只有数据文件无任何日志文件的情况下的恢复;
  11. Sybase数据文件被误删除情况下的碎片提取恢复;
  12. 磁盘阵列上的Sybase数据库被误格式化情况下的数据库恢复;
  13. 数据库sysobjects等系统表损坏无法正常应用情况下的恢复;
  14. Sybase数据库还原数据库出现失败情况下的恢复;
  15. Sybase数据库只剩下损坏的备份文件情况下的恢复。

Sybase ASE数据库恢复工具READSYBDEVICE支持的版本:

Sybase ASE 11.0.x,11.5.x,11.9.x,12.0.x,12.5.x,15.0.x,15.5.x,15.7.x,16.0.x


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

SQL Server数据库恢复工具SQLRescue:

一个不依赖数据库管理系统、直接从SQL Server数据库文件上提取数据的业内领先的恢复工具!
能够从损坏的SQL Server数据库文件(.mdf)上提取数据的非常规恢复工具。

SQL Server数据库恢复工具SQLRescue的主要功能:

  1. 系统崩溃只剩下数据文件的情况下的恢复,即无日志文件或者日志文件损坏情况下的恢复;
  2. 断电导致数据库文件损坏情况下的恢复;
  3. 硬盘坏道造成数据库损坏情况下的恢复;
  4. 数据文件内部存在坏页情况下的恢复;
  5. 企业管理器误删除数据表记录,管理软件误删除数据表记录的恢复;
  6. 并闩锁错误、格式化、误删除后导致软件不能使用的情况;
  7. 无法读取并闩锁页sysindexes失败情况下的修复;
  8. 数据文件被误删除情况下的碎片提取恢复;
  9. 系统表损坏、索引错误、误删除数据库表、删除记录的数据找回;
  10. master数据库损坏而无法正常运行情况下的恢复;
  11. 数据文件无法附加情况下的数据恢复;
  12. 数据库被标记为可疑,质疑,不可用等情况的恢复;
  13. 数据库sysobjects等系统表损坏情况下的恢复;
  14. 数据被误(drop、delete、truncate)删除表数据的恢复,误update后的数据恢复等;
  15. 还原时报一致性错误,错误823等情况下的数据恢复,各种错误提示的数据库文件修复;
  16. 数据库被误格式化等情况下的数据库恢复;
  17. 日志收缩造成数据库损坏情况下的恢复;
  18. 仅剩损坏的备份文件情况下的恢复。

SQL Server数据库恢复工具SQLRescue技术特点:

只要SQL Server数据库的数据文件存在,我们就有办法帮您从数据文件中找回重要数据。
  1. 从数据文件中直接恢复数据
  2. 不能附加时直接恢复数据并生成新的数据库
  3. 系统表损坏的数据库修复
  4. 快速修复SQL 823错误、连接中断错误

SQL Server数据库恢复工具SQLRescue支持的版本:

Microsoft SQL Server 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017,2019。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------