提供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:659719
CR Number:   659719
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Management
Status:   Closed
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.6 ESD #1 10 Mar 2011 Fixed
15.7 10 Mar 2011 Fixed
15.6 ESD #1 06 Apr 2011 Fixed
15.7 31 Jul 2013 Insufficient priority to fix
Description
When Replication Agent is installed on non-HP-UX

machine, it is not able to connect to RSSD if RSSD

resides on HP-UX ASE with Roman8 charset.



CR:659752
CR Number:   659752
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.6 ESD #1 09 Mar 2011 Fixed
15.7 09 Mar 2011 Fixed
Description
ORACLE ONLY: Replication Agent appears to be

hanging with no data being replicated during

'replicating' state. It becomes unresponsive

when trying to suspend replication.



CR:659875
CR Number:   659875
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 02 19 Jan 2012 Fixed
Description
The wrong partition dictionary used to expand data for Non-EA enabled Table Spaces. An undocumented extra 8 bits are added to the high order part of the page number for these table spaces causing the partition number to be calculated incorrectly.



CR:659899
CR Number:   659899
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2011 Fixed
Description
Signal 11 in dALARM( ).



CR:659957
CR Number:   659957
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.6 ESD #1 10 Mar 2011 Fixed
6.0.01 10 Mar 2011 Fixed
15.7 10 Mar 2011 Fixed
Description
ORACLE ONLY: Replication Agent fails with

'Could not create log device for on-line log'

exception while initializing the Replication

Agent instance using 'pdb_xlog init' command.
Workaround Description
 move the online log files into default ASM online log directory: +<DISKGROUP>/<DB_NAME>/ONLINELOG/



CR:659972
CR Number:   659972
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   lelude
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Display status icon in Local Browser gets incorrect when the model was synchronized with the repository and is used to merge to another model. State is now 'Changed' (red check mark) although model did not change.



CR:660011
CR Number:   660011
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RS 15.5: function string using RPC causes ERROR #29031 cs_convert() error
Workaround Description
 Workarounds:



1. upgrade to 15.6



2. change RPC to language:



alter function string branch_rep.rs_insert

for proddb7_class

output language '

execute sp_fs_branch_operations_sum_del_tbl

@record_date = ?record_date!new?, @date_type = ?date_type!new?,

@data_type = ?data_type!new?,

@account_type = ?account_type!new?, @org_id = ?org_id!new?, @pmt_freq = ?pmt_freq!new?,

@del_status = ?del_status!new?, @seq = ?"seq"!new?, @cnt = ?cnt!new?,

@amt = ?amt!new?, @last_chg_userid = ?last_chg_userid!new?,

@last_chg_datetime = ?last_chg_datetime!new?,

@old_record_date = ?record_date!new?, @old_date_type = ?date_type!new?,

@old_data_type = ?data_type!new?, @old_account_type = ?account_type!new?,

@old_org_id = ?org_id!new?, @old_pmt_freq = ?pmt_freq!new?,

@old_del_status = ?del_status!new?'



CR:660046
CR Number:   660046
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Management
Status:   Closed
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.6 ESD #1 09 Mar 2011 Fixed
15.7 09 Mar 2011 Fixed
Description
The <db>_create_rs_primary_connection.sql

script contains an incorrect error function

class.



CR:660085
CR Number:   660085
Product Name:   Replication HDS
Product Component:   HDS scripts
Status:   Closed
OS:   Generic
Original Version:   RS 15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
RS 15.7 25 Nov 2012 Presently Not Targeted For Any Future Release Of This Product
Description
When creating Replication

Server connection using

profile, the HDS script

attempts to make duplicate

entries in rs_translation.



CR:660175
CR Number:   660175
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   lelude
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2011 Fixed
Description
Branches for "earlier" versions are created on current version or cause error if the version is unfrozen and cancel check in.

To create branches from older versions was possible in PD 7.5 GA.



CR:660278
CR Number:   660278
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASE 12.5.4 does not support the desired CS_NUMERIC_TYPE, bigint



CR:660286
CR Number:   660286
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   AIX
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2011 Fixed
17 Mar 2011 Fixed
Description
If a table has multiple replication definitions in a warmstandby environment, after dropping all those replication definitions, there will be a row with objname like rs_indrp% left in RSSD rs_objects which will be never dropped.
Workaround Description
 remove the offending rs_indrp% before creating the route.



CR:660407
CR Number:   660407
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
Please give an option to easily handle (skip or bypass) image/text replication errors:



For instance:



1. Capability in the replication error class to customize how to deal with either "text pointer returns no rows" or "text pointer returns multiple rows" besides just the suspend connection option that is currently available.



2. Allow the capability to allow the rest of the columns to be applied and commit the transaction, even if the text pointer logic fails. The failure of the text should be logged to the RS log.



3. Allow for easier customization of function strings that deal with the text/image replication.



CR:660447
CR Number:   660447
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The connection profile rs_oracle_to_oracle should not be setting the dsi_suspended parameter.



CR:660466
CR Number:   660466
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Installation
Status:   Closed
OS:   Solaris
Original Version:   6.1.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2012 Fixed
Description
ORACLE ONLY: Add support for

Sunx64 platform.



CR:660495
CR Number:   660495
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   6.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2011 Fixed
Description
ORACLE ONLY: When the Replication Agent parallel scan

(lr_parallel_scan) is enabled, issuing the suspend

may result in the Replication Agent to report an

Oracle Log Scanner thread error.



CR:660648
CR Number:   660648
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2011 Fixed
Description
In 15.6 upgrade script, IQ function string class' parent class id incorrect.



CR:660690
CR Number:   660690
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTM
Status:   Closed
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 06 Jun 2012 Fixed
Description
CR 622582 which is supposed to keep RAX running despite RAX errors, is not fully implemented; it will not skip lti formatting errors.
Workaround Description
 pdb_skip_op



CR:660700
CR Number:   660700
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 03 04 Mar 2011 Fixed
Description
RA DB2 continues come up, even when Use_repdefs = Y and server hosting the RSSD is down.
Workaround Description
 Bring up the server that has the RSSD and ensure one can connect to the RSSD from the RA DB2 machine.



CR:660789
CR Number:   660789
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   lelude
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Currently you have two windows to show permissions for a Project in Repository borwser. Ther Folder Permissions and the Project permission. Request is to show all Permissions / Informations of an Project in one window and not ins two.



CR:661012
CR Number:   661012
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   AIX
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 May 2011 Fixed
Description
Error: -99999, Severity 5 -- 'Incorrect value type [8] to create a String.
Workaround Description
 *** Thu May 26 09:58:14 UTC+0800 2011 *** tning ***



This phenomena is repro out inhouse.



That scenario could be work around by set dsi_bulk_threshold to '1'.



If this workaround does not work for you, it should be another new issue/bug.

Pls file a new CR for it and let me know.



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



turn off bulk copy, however, we need it on to get the desired performance.



CR:661018
CR Number:   661018
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 03 13 Jul 2011 Fixed
Description
Rep Agent displays count down banners once a day for 30 days when a license is about to expire. Then displays an expired license banner when it has expired.



CR:661185
CR Number:   661185
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   AIX
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Apr 2012 Duplicate
Description
Cannot tell from message 5181, what value or column and the size that generates this message.
Workaround Description
 No workaround...need to try to make an intelligent guess.



CR:661272
CR Number:   661272
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   NA
Original Version:   6.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2012 Presently Not Targeted For Any Future Release Of This Product
Description
New Feature DOC CR ... add ra_direct_read on if OCFS2 is setup to use direct I/O



Linux only ...



if one does this command in linux ...

mount | grep "ocfs"

... and the result has "datavolume" the for sure configure ra_direct_read to on.



indicate that ra_direct_read needs to be turned on if the OCFS2 is setup to use direct I/O.



CR:661546
CR Number:   661546
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Solaris
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2011 Fixed
06 Nov 2012 Fixed
10 Mar 2011 Fixed
Description
ORACLE ONLY: Replication Agent is replicating a

null value for a non-null column in a table when

character set conversion is not required, causing

Replication Server DSI to go down.
Workaround Description
 Force character set conversion which will allow RA to get around the bug and get correct string values.



For example, ACC has rs_charset = iso1, and the Java charset should be ISO8859_1.



The workaround is to set RA_JAVA_DFLT_CHARSET in the RUN_<instance>.sh to a charset other than ISO8859_1, maybe ISO8859_2.

Please check the RA log for the current setting of the RA and RS Java charset, search for



"The Agent default Java charset is"

"The rs_charset Sybase charset is"



Need to stop and restart the RA instance for the setting to take effect.



CR:661603
CR Number:   661603
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   lelude
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jul 2011 Fixed
12 Sep 2011 Fixed
Description
Integrate: Merge model into another one leads to OdbcError: [24000] [Sybase][ODBC Driver]Invalid cursor state.



CR:661631
CR Number:   661631
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   NA
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RAO 15.6 add flexibility enabling RASD tracing ... creat an option to reduce the voluminous info written to /var/adm/messages by SQLAnywhere / ASA when executing the debug RA binary.
Workaround Description
 The RA always starts the RASD with tracing enabled when running the debug binary. One could start RA with the optimized binary and get the RASD start command from the log. For example:



I. 2011/03/04 14:15:31.184 RASDTRC com.sybase.rep.asa.ASAInstanceAdmin Executing ASA utility: "C:\Workspace\SQLAny11\bin\dbspawn" -f -p -q "C:\Workspace\SQLAny11\bin\dbeng11" -sb 0 -ti 0 -ga -m -x tcpip{PORT=2301} -q -o "C:\Workspace\156\1\rao_or112dr1\repository\trace.log" "C:\Workspace\156\1\rao_or112dr1\repository\rao_or112dr1.db"



Then, one could shutdown the RA and start the ASA manually outside of the RA:



$SYBASE\RAX-15_5\SQLAny11\bin\dbspawn" -f -p -q "$SYBASE\RAX-15_5\SQLAny11\bin\dbeng11" -sb 0 -ti 0 -ga -m -x tcpip{PORT=2301} -q -o "$SYBASE\RAX-15_5\rao_or112dr1\repository\trace.log" "$SYBASE\RAX-15_5\rao_or112dr1\repository\rao_or112dr1.db"



However, prior to doing this, one will need to set the path and libpath environments for the particular platform and RA paths,



Once you have the ASA started manually, you can start the RA with the debug binary and it will detect that the RASD is already started.



This will allow you to work-around this problem where you need the debug binary running without RASD tracing.



CR:661869
CR Number:   661869
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide trigger control package for MSSQL.



CR:662018
CR Number:   662018
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   lelude
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add a new repository right and\or permission to limit users ability to create folders.



If an user only has the 'Connect' right and 'Write' or 'Full' permission, they are able to create Folders within the repository. The customer would like to allow the users to check-in documents, but not create folders.



CR:662109
CR Number:   662109
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Doc
Status:   Open
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2012 Fixed
Description
Impact of column_compression and ltl_send_only_primary_keys and ra_set_autocorrection on where clause of subscription and function string processing.
Workaround Description
 Either set ra_set_autocorrection on (which will mark the table to log values for all columns) or set column_compression to false (for after images) and ltl_send_primary_keys to false (for before images).



CR:662494
CR Number:   662494
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Apr 2011 Fixed
15.7 07 Dec 2011 Fixed
Description
Deprecate configuration parameter 'sqm_seg_prealloc'.
Workaround Description
 configure replication server set sqm_seg_prealloc to "off"

default is "on"



Engineering has realized the performance gain that a customer may experience from this configuration item/feature is minimal / negligible. Customers are able to get as much or more performance from other features, such as increased block size, since increasing the stable device block size will reduce the number of segments need to be allocated.



This workaround should be helpful to most but just to set expectations correctly we know of one customer who continued to have this problem even after sqm_seg_prealloc was set to off.



CR:662644
CR Number:   662644
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   AIX
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RS stacks in dsi_calc_estimated_row_size when 'dsi', 'dsi_workload' trace is enabled.
Workaround Description
 Do not use the trace 'dsi', 'dsi_workload'



CR:662792
CR Number:   662792
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Mar 2011 Fixed
11 Apr 2011 Fixed
Description
When Replication Server needs memory over memory_limit, the 15.5 GA/ESD#1 and 15.6 GA behavior is that memory will be increased automatically by 10%, each time additional memory is needed over mememory_limit. This CR is to disable this behavior. The new behavior is when memory usage exceeds memory_limit, the Replication Server will shut down.



CR:662905
CR Number:   662905
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
Officially support parallel DSI to mainframe DB2
Workaround Description
 Batching, multiple DSI (not totally supported)



CR:662948
CR Number:   662948
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
For auditing purposes, the customer would like PD to track additional repository activities.

The additional activities being requested are:



Repository user: creation, deletion, assignment of rights

Assignment and modification to document and/or folder permission



Deletion of objects within a PowerDesigner document



CR:663172
CR Number:   663172
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   6.0.02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.02 11 Apr 2011 Fixed
15.7 11 Apr 2011 Fixed
15.6 ESD #1 31 Mar 2011 Fixed
15.7 31 Mar 2011 Fixed
15.6 ESD #1 05 Apr 2011 Fixed
Description
ORACLE ONLY: Replication Agent stops replicating

when it encounter "Unable to get the LOB object

from the repository." error when the LOB column

on the table is not configured for replication.
Workaround Description
 skip_lr_error to true will allow the RAO to continue processing despite the log reading error.



CR:663178
CR Number:   663178
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   AIX
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
DSI loops with 5185 in replication server error class set to ignore.
Workaround Description
 This problem is specific to 15.6 to my knowlege. In 15.6, the workaround is to alter the connection to set dsi_row_count_validation to "off"



CR:663210
CR Number:   663210
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2011 Fixed
29 Mar 2011 Fixed
Description
When user connects and disconnects from the Replication Server, internal synchronization element not freed.



CR:663379
CR Number:   663379
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.0.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2011 Fixed
19 Apr 2011 Fixed
Description
ORACLE ONLY: Replication Agent does not skip log

reader errors generated when scanning logs of

Oracle Cluster with skip_lr_errors set true.



CR:663575
CR Number:   663575
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Open
OS:   Microsoft Windows NT
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Support MS SQL replication in a failover cluster



CR:663642
CR Number:   663642
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   NA
Original Version:   6.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Mar 2012 Presently Not Targeted For Any Future Release Of This Product
Description
RSO156 customer needs documentation on how to resync ... bi-directional ... MSA multi site availability ... MSSQL<->MSSQL replication system / environment



CR:663742
CR Number:   663742
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   lelude
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Upon updating a model into the repository, 'Merge Changes to Repository Document' keeps reporting object modifications on some symbols regarding Related Position even Position.



CR:663825
CR Number:   663825
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   AIX
Original Version:   15.2 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ERROR #11061 SQM ... ERROR #1028 SQM ... SQM stopping due to an exception



E. ... ERROR #11061 SQM(102:1 lds.ldb01) - s/stscol.c(2055) Check the log for error messages from RSSD.

E. ... ERROR #1028 SQM(102:1 lds.ldb01) - s/stscol.c(2055) Message from server: Message: 701, State 3, Severity 17 -- 'There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure cache.'.

I. ... SQM stopping due to an exception: 102:1 lds.ldb01



RS 15.0.1 ESD#2 AIX stops abnormally when Warm Standby ASE experiences procedure cache becoming very low or even exhausted



The SQM thread with Replication Server stops working. Only way out is to recycle ASE with

standby and RSSD (which same is on the same ASE server)." Just for clarification. We are

experiencing a stop of the SQM. In one case the SQM stopped and the Replication Server stopped abnormally. In all cases of the SQM stopping, a message arrives in Replication Server log that procedure cache is short. The only way to start the SQM is to SHUTDOWN and START the Replication Server. Resume does not work for the SQM. Looking at the RSSD location in ASE no message can be found.
Workaround Description
 A) One piece of progress is we can tell customers ... our testing shows this problem is

resolved in RS 15.6.



B) for versions

RS 15.0.1e2

RS 15.0.1e4

RS 15.2e3

the customer has presently worked around this production problem by



1) increasing procedure cache and

2) policing users to prevent them from issuing queries that ...

"drain the entire procedure cache in our production".



CR:663834
CR Number:   663834
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2011 Fixed
Description
Cannot create connection using profile to non-ASE replicate databases when RS password encryption is turned on.
Workaround Description
 Turn off encryption or manually create the tables and procedure (use the display_only clause to see what commands would be applied at the target database).



To turn off password encryption:

1> configure replication server

2> set password_encryption to '0'

3> go

Config parameter 'password_encryption' is modified. This change will not take

effect until the Replication Server is restarted.



Reboot RS.



CR:663917
CR Number:   663917
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jun 2011 Fixed
Description
HVAR/RTL: quoted identifier not working if net row change number is smaller than dsi_bulk_threshold.



CR:663946
CR Number:   663946
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Apr 2011 Fixed
Description
ORACLE ONLY: Replication Agent goes to

ADMIN or REPLICATING DOWN state when

processing an Oracle online redo log file which

contains no log data, or Replication Agent

stuck processing an Oracle archive log file

which contains no log data.



CR:664027
CR Number:   664027
Product Name:   Replication HDS
Product Component:   UDD scripts
Status:   Closed
OS:   Generic
Original Version:   RS 15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
RS 15.6 ESD #1 28 Mar 2011 Fixed
RS 15.7 28 Mar 2011 Fixed
Description
rs_oracle_timestamp9 does

not allow 9999 for the year.
Workaround Description
 Manually modify the script to have a maximum boundary of 9999 for the year. Drop the existing datatype for the class and readd the datatype using the modified script.



CR:664029
CR Number:   664029
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 05 19 Jan 2012 Fixed
Description
License check message does not turn off when turning off trace dynamically
Workaround Description
 Shutdown the RA and startup the RA DB2 with logtrace=no



If one starts up the RA with logtrace=no, turning on the trace dynamically will NOT produce the license trace check message.



CR:664145
CR Number:   664145
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   Windows XP
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Product: PD 15.2 EBF#9 and 15.3 EBF#4



This is a request from Itau-Unibanco customer, during meeting with David Dichmann on week of March 21th, 2011.



Currently, PD allows working with only one repository at a time. Customer would like a feature to work with two or more simultaneous repository connections at same time.



CR:664148
CR Number:   664148
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Apr 2011 Duplicate
21 Aug 2012 Not a Bug
Description
ORACLE ONLY: Replication Agent goes to

ADMIN or REPLICATING DOWN state when

processing an Oracle online redo log file which

contains no log data, or Replication Agent

stuck processing an Oracle archive log file

which contains no log data.



CR:664394
CR Number:   664394
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Apr 2011 Fixed
12 Sep 2012 Not a Bug
Description
ORACLE ONLY: When ra_direct_read is enabled,

ASM/ASMLib is configured and ra_devicepath

is configured to a non-ASM disk mirror path

configured for the ASM online log,

Replication Agent will not read the log file using

direct I/O. This may cause problems during

replication.



CR:664651
CR Number:   664651
Product Name:   Replication Management
Product Component:   Agent Plugins
Status:   Open
OS:   Generic
Original Version:   3.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SCC RMAP hangs when adding procs in RSSD and the RSSD log is full



CR:664679
CR Number:   664679
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   Windows XP
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PD 15.2 EBF#9



This is a feature request from Itau-Unibanco customer:



Enable PD APIs with methods for Repository user management. E.g: create new users and groups, asociate users to groups, define rights and permissions etc.



*** Mon Jul 07 2014 11:28:38 GMT-0400 (Eastern Standard Time) *** ahill *** PD 16.5 SP03



Morgan Stanley is requesting this functionality as well.



We would like to raise an ehancement request for a Repository Management API.



This should allow for all the administrative functions that are exposed in the PD GUI to be automated. For example:



- Add/change/remove user

- Add/change/remove group

- Add/remove users to/from groups

- Set user/group permissions on folder





The API could be as simple as a documented set of database stored procedures in the repository database or a SOAP/REST web service or command line tools.



CR:664692
CR Number:   664692
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Server crashes in ll_del ()



CR:664700
CR Number:   664700
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   NA
Original Version:   6.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2012 Fixed
Description
DOC ... RAO needs all nodes in RAC individually listed in tnsnames.ora used by RAO with just the connection info specfic to each individual node since RAO may need to login to each nodes specifically.



CR:664893
CR Number:   664893
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Installation
Status:   Closed
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2011 Fixed
25 Apr 2011 Fixed
03 May 2011 Fixed
Description
Update to the latest version of JRE

to pick up the JRE security vulnerability

fix(CVE-2010-4476).



CR:665181
CR Number:   665181
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2012 Presently Not Targeted For Any Future Release Of This Product
Description
Memory leak when bulk is enabled. The memory could be freed after connection suspend/resume.



CR:665427
CR Number:   665427
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2011 Fixed
29 Sep 2011 Fixed
02 Mar 2012 Fixed
6.0.13 31 May 2012 Fixed
Description
MICROSOFT SQL SERVER ONLY:

Replication Agent goes to

'Replication Down' because of a

NullPointerException.



CR:665544
CR Number:   665544
Product Name:   Rep Server Connectors
Product Component:   Oracle OCI Connector
Status:   Closed
OS:   Generic
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD #2 08 Apr 2011 Fixed
Description
Fixed Replication Server potential core dump when ExpressConnect for Oracle had general_1 tracing turned on.



CR:665570
CR Number:   665570
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.0.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2011 Fixed
26 May 2011 Fixed
16 Apr 2012 Fixed
Description
ORACLE ONLY: Improve LOB replication performance.

A new Replication Agent configuration parameter

lr_max_lobdata_cache is now available to use for

tuning LOB replication performance.



lr_max_lobdata_cache

Determines the maximum size (in byte) of LOB

data cache for each off row LOB data.

Default: 8192

Values: An integer from 8192 to 2147483647

Comments:

- The lr_max_lobdata_cache can be use for

tuning better LOB replication performance.

The recommended value for setting the

lr_max_lobdata_cache is a value larger than

the max LOB data size being replicated.

- The lr_max_lobdata_cache should be set when

the Replication Agent instance is in ADMIN

or REPLICATING DOWN state.



CR:665636
CR Number:   665636
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   NA
Original Version:   5.8.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 May 2011 Fixed
03 May 2011 Fixed
03 May 2011 Fixed
03 May 2011 Fixed
11 Oct 2011 Fixed
Description
MICROSOFT SQL SERVER ONLY: Replication Agent

replicates the non-null bit column value

incorrectly on a table containing a mix of null

and non-null bit column values.



CR:665754
CR Number:   665754
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2011 Fixed
Description
ORACLE ONLY: Add statistics for EOL and LOB

processing.

EOL statistics for single thread scanner

LR Log scan reader end-of-log status

LOB processing timer

LR Avg Large Column Data processing time



CR:665881
CR Number:   665881
Product Name:   Rep Server Connectors
Product Component:   Oracle OCI Connector
Status:   Closed
OS:   Generic
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD #2 10 May 2011 Fixed
Description
Connection to ExpressConnect for Oracle may experience "ORA-02005: implicit (-1 ) length not valid for this bind or define datatype" when table has REAL or FLOAT datatype columns.



CR:666022
CR Number:   666022
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
NFR RS156 create something similar to sp_monitorconfig in ASE for RepServer



It would be great to have a dashboard item like sp_monitorconfig in ASE for Replication Server where customer's could monitor items like num_mutexes configured compared to used, largest amount of sqt_max_cache_size used, num_msgs, num_msgqueues, num_client_connections, num_concurrent_subs, etc ...



CR:666303
CR Number:   666303
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.0.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2011 Fixed
Description
ORACLE ONLY: Replication Agent does not

skip partial LOB error when lr_skip_errors

configuration is enabled.



CR:666457
CR Number:   666457
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2012 Fixed
Description
IBM DB2 ONLY: Replication Server distributor

fails with ERROR #9027 and a message similar to

"A begin with transaction id = some value was

seen while a transaction was still active"

because Replication Agent sent multiple begin

operations for the same transaction when rollback

to savepoint occurred in the transaction.



CR:666471
CR Number:   666471
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   AIX
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2011 Fixed
28 Apr 2011 Fixed
Description
RTL: "Syntax error near '32768' " when replication definition has 'replicate minimal columns' clause and there is a text/image column.
Workaround Description
 *** Wed Apr 20 21:57:37 UTC+0800 2011 *** tning ***



Don't have 'replicate minimal columns' attribute.



alter replication definition reptext

replicate all columns

go



CR:666582
CR Number:   666582
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2011 Fixed
Description
ORACLE ONLY: Replication Agent goes to REPLICATION

DOWN status when replicating LOB data and the

population of the LOB on the primary database is

terminated unexpectedly with ORA-01691: unable to

extend lob segment <?> by 128 in tablespace <?>.



CR:666650
CR Number:   666650
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2011 Fixed
02 May 2011 Fixed
Description
ExpressConnect for Oracle: Replication Server should always obtain delimiters, even for NULL values.



CR:666657
CR Number:   666657
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   NA
Original Version:   5.9.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2011 Fixed
20 Apr 2011 Fixed
Description
IBM DB2 ONLY: Update operations fail to replicate

without any Replication Agent status change,

error or even warning.



CR:667054
CR Number:   667054
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.0.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2011 Fixed
24 Apr 2012 Not a Bug
Description
ORACLE ONLY: Replication Agent fails to replicate

LOB data where the LOB data size hits a database

block size condition. The error is incorrectly

reported as a partial LOB data error.



CR:667104
CR Number:   667104
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   15.2 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature Request: Ability to configure Replication Server to ignore and suppress error #32020 from the errorlog.
Workaround Description
 None known.



CR:667589
CR Number:   667589
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.0.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2011 Fixed
06 Nov 2012 Not a Bug
Description
ORACLE ONLY: Replication Agent fails with

NullPointerException during LOB replication rescan

processing. Replication Agent may report it's

still in REPLICATING status.



CR:668159
CR Number:   668159
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   AIX
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RS cores with _sqt_re_read_from_sqm and ll_del
Workaround Description
 Restart server, however, the server generally crashes again within a few hours.



CR:668319
CR Number:   668319
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New feature request for ability to set send_enc_password at the connection level.



CR:668368
CR Number:   668368
Product Name:   Sybase Replication Server
Product Component:   InstallAnywhere
Status:   Closed
OS:   Solaris
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
carina 08 Feb 2013 Fixed
07 Dec 2011 Added to user documentation
Description
Problem: During installation on Solaris systems, an error occurs when validating available disk space: ./setup: !: not found



Workaround: The error can be ignored. The program should still properly be able to determine if sufficient disk space is available.



CR:668507
CR Number:   668507
Product Name:   Replication HDS
Product Component:   HDS scripts
Status:   Closed
OS:   Generic
Original Version:   RS 15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
RS 15.7 19 May 2011 Fixed
Description
Add new table rs_version

in user databases, IQ and

Oracle.



CR:668685
CR Number:   668685
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.6 ESD #1 24 May 2011 Fixed
Description
ORACLE ONLY: Replication Agent may fail with a

NullPointerException when the Replication Agent

is performing parallel check point processing.



CR:668686
CR Number:   668686
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2011 Fixed
Description
ORACLE ONLY: Replication Agent stops replication

with device not found exception when switching

from the latest archive redo log to the latest

online redo log.



CR:668690
CR Number:   668690
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 May 2011 Fixed
Description
ORACLE ONLY: SCAN_READER_EOL_STATUS statistic

information is missing from the statistics list

when Replication Agent parallel scan

(lr_parallel_scan) is enabled.



CR:668692
CR Number:   668692
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.0.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2011 Bundled Request
Description
ORACLE ONLY: LOB Replication performance may be

slow.



CR:668717
CR Number:   668717
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   lelude
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jun 2011 Fixed
Description
Repository: Order of table columns has changed after check out



CR:668795
CR Number:   668795
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   AIX
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2011 Fixed
Description
HVAR: DSI shutdown with complaining "'CREATE TABLE' cmd is not allowed in multi-stmnt xact".
Workaround Description
 - either disable 'i2di' {alter connection to <> set dsi_command_convert to 'none', or 'u2di' (if it is 'u2di,i2di' originally)



- or set dsi_compile_max_cmds to a bigger value to prevent it doing incremental compilation, you could try its max value '2147483647 to see if it works first. If you want to know how many commands in current group, you could turn on trace (trace 'on', dsi, dsi_trace_group'} to see it.



CR:668822
CR Number:   668822
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   AIX
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Function is missing in stack that is printed to the RS log.
Workaround Description
 Believe the core.



CR:669535
CR Number:   669535
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.0.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2011 Fixed
Description
ORACLE ONLY: Replication Agent log truncation

function may cause an Oracle "Archival Error".



CR:669565
CR Number:   669565
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2011 Duplicate
Description
Feature Request for Replication Server to have new command to report details about licenses that are currently in use.
Workaround Description
 n/a



CR:669628
CR Number:   669628
Product Name:   RepConnector
Product Component:   Documentation
Status:   Closed
OS:   Generic
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2013 Added to user documentation
Description
set dsi_bulk_copy to 'off' needs to be added to the create connection command; bulk copy is not supported to RepConnector.



CR:669797
CR Number:   669797
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.2 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
setting dsi_serialization_method to 'check_rows' causes RepServer to crash



CR:669910
CR Number:   669910
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTI Driver
Status:   Closed
OS:   Generic
Original Version:   6.0.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2011 Fixed
19 Dec 2012 Fixed
Description
Replication Agent fails with a

NullPointerException when attempting to reconnect

to the RSSD after a previous failed connection.



CR:670351
CR Number:   670351
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   lelude
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2011 Fixed
Description
Specific to cust models: Integrate a model document into another document: Some errors occur during the update of the repository model. The collection Transient Reverse Mappings cannot saved in the repository for object External Table Mapping 'Data Warehouse KB.R_Curve_Mapping_FTP.Mapping_1' Unexpected error while updating the repository document.

The check in of the document has been cancelled."



CR:670487
CR Number:   670487
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   lelude
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jul 2012 Fixed
Description
Check in of an EAM takes ten times longer on a MS SQL 2005 Repository compared with an ASA Reprository.



CR:670577
CR Number:   670577
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.6 ESD #1 23 May 2011 Fixed
15.7 23 May 2011 Fixed
Description
MICROSOFT SQL SERVER ONLY: Replication Agent fails

with Unexpected Thread Death from Transaction

LogReader thread error message due to

EndOfLogException when processing the end of

virtual file log.
Workaround Description
 resume RA again when got such exception.



CR:670707
CR Number:   670707
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RS stacks with ll_del and _exc_alloc_element
Workaround Description
 According to case 11629083, increasing num_msgqueues, num_msgs, num_mutexes, and num_stable_queues did not help. The only help was to make smp = off



CR:670840
CR Number:   670840
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Aug 2011 Fixed
22 Jan 2013 Fixed
Description
UDB ONLY: Replication Agent encounters an

unexpected fatal exception when processing a

multi-record update. It can occur when a delete

is executed against a record that no longer

exists in the primary database.



CR:670877
CR Number:   670877
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   Windows XP
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Tested and reproduced with:



PD 15.2 EBF#9 and 15.2 EBF#10

Repository: SQL Server 2008

OS: Windows XP SP3



This is an issue from Itau-Unibanco customer.

When checking in a project with a binary file attached (e.g. docx file), the following error appears during check-in process:



Unexpected error while updating the repository document

The check in of the document has been cancelled



We confirmed issue happens in 15.2 codeline, only. Issue is already fixed in 15.3 (tested with EBF#4 and EBF#6).



CR:671039
CR Number:   671039
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Only the first character of Lock comment of a document in the repository is visible when a Proxy connection is used.

Works fine using a Direct connection.



CR:671222
CR Number:   671222
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   lelude
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2011 Fixed
Description
Integrate a model into another one. Compare the local model and the one you have just stored in the repository. Unexpectedly, it returns a few differences on one view:



CR:671254
CR Number:   671254
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   AIX
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2011 Fixed
05 Oct 2011 Fixed
Description
Incorrect values in the 7036 error message



CR:671385
CR Number:   671385
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   Windows XP
Original Version:   lelude
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2011 Fixed
07 Sep 2011 Fixed
Description
Tested and reproduced with:

- PD 15.3 (EBF#4/EBF#5/EBF#6)

- SQL Anywhere 11 as repository



When creating an user with Connect and Read permissions for the Repository and tring to check out versioned models, some versions are not allowed to be checked out. If you connect/disconnect as ADMIN and then connect with created user again, the list of allowed/not allowed model versions may change. Please, refer to repro steps for details.



CR:671421
CR Number:   671421
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 May 2011 Fixed
Description
OCS messages encountered when turning dsi_bulk_on impacting performance



E. 2011/05/06 12:55:16. ERROR #1027 DSI EXEC(122(1) <ds>.<db>) - /dsiutil.c(354)

Open Client Client-Library error: Error: -99999, Severity 5 -- 'Incorrect value type [8] to create a String.

'.
Workaround Description
 *** Fri May 27 10:26:22 UTC+0800 2011 *** tning ***



This phenomena is repro out inhouse.



That scenario could be work around by set dsi_bulk_threshold to '1'.



If this workaround does not work for you, it should be another new issue/bug.

Pls file a new CR for it and let me know.



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

turn off bulk copy, however, we need it on to get the desired performance.





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

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。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------