提供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:698133
CR Number:   698133
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.1.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.1.00 15 Mar 2012 Fixed
6.1.00 15 Mar 2012 Fixed
6.1.00 15 Mar 2012 Fixed
6.1.00 15 Mar 2012 Fixed
15.7.1 14 Mar 2012 Fixed
15.7.1 14 Mar 2012 Fixed
Description
For internal use only (new development):

Provide new ra_downgrade and enhanced

ra_migrage API to improve upgrade

and downgrade process.



CR:698553
CR Number:   698553
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
DDL and system procedures do not display as offending transactions when the DSI is suspended.
Workaround Description
 sysadmin log_first_tran will display the transaction in the RS exceptions log.



CR:698605
CR Number:   698605
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Mar 2012 Fixed
Description
The Replication Manager Plug-in now identifies the connection and thread associated with an embedded RSSD and always marks it active. The user can no longer attempt to suspend or resume the Rep Agent for the embedded RSSD.



CR:698823
CR Number:   698823
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
LTL buffer dump is not occurring on LTL syntax error.
Workaround Description
 Look in the ASE log (in my case it is 15.7 GA) for additional clues. In my case, the ASE log was accurate:



00:0002:00000:00001:2012/02/15 16:51:44.02 server RepAgent(4): Received the following error message from the Replication Server: Msg 2057. Line 1, character 356: Incorrect syntax with the keyword 'distribute'..

00:0002:00000:00001:2012/02/15 16:52:43.98 server RepAgent(4): Error in passthru packet: 'distribute 4 0x00000000000287c80000fcd300230000fcd3002100009ff80115e09200000000,6 0x00000000000287c8002161736531353769707269 dump database pri '20120215' '.

00:0002:00000:00001:2012/02/15 16:52:43.99 server RepAgent(4): Received the following error message from the Replication Server: Msg 2056. Line 1, character 144: Incorrect syntax with '20120215'..

00:0002:00000:00001:2012/02/15 16:52:43.99 server Error: 9261, Severity: 20, State: 0

00:0002:00000:00001:2012/02/15 16:52:43.99 server RepAgent(4): This Rep Agent Thread is aborting due to an unrecoverable communications or Replication Server error.

00:0002:00000:00001:2012/02/15 16:52:43.99 server Rep Agent Thread for database 'pri' (dbid = 4) terminated abnormally with error. (major 92, minor 61)



CR:698865
CR Number:   698865
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2012 Fixed
07 Mar 2014 Fixed
09 Mar 2012 Fixed
13 Apr 2012 Fixed
Description
delete uses more memory with database repdef than with table replication definition.
Workaround Description
 Do not use database repdef.



CR:698867
CR Number:   698867
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2012 Fixed
Description
In the Connection Properties dialog box, the contents of the function string class combo box and the error class combo box were incorrect, thus the actual settings could not be displayed nor could they be changed.



CR:698883
CR Number:   698883
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RS 157 fails with the following error ...



E. 2012/02/16 13:50:06. ERROR #2100 REP AGENT(p6x155e5sdx.pdb1) - s/packer.c(8434)Packer failed with bad multibyte string data. Length=57(bytes). String='Xxxxxx Xxxxxxx Xxxxx- xxxxxx xxxxxxx xxx...'.



when ASE -> RS -> IQ ... with ...

1) 64bit ASE 155e5 pds.pdb on linux

use sqllocres to change the default code page to utf8 and sort_order to bin_utf8

sqlsrv.default_characterset: utf8

sqlsrv.sort_order: bin_utf8

2) IQ 15.4 on linux using ... collation 'UTF8'

create database

...

case respect collation 'UTF8' java off

...

go

3) multibyte data bcp'd into ASE pds.pdb



CR:699035
CR Number:   699035
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
modify behavior of synchronize_trans=Yes to only run during low activity times automatically.
Workaround Description
 toggle the parameter dynamically; no need to recycle the RA DB2 to toggle the parameter



CR:699226
CR Number:   699226
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Aug 2012 Presently Not Targeted For Any Future Release Of This Product
27 Nov 2012 Fixed
Description
admin stats, backlog should show backlog for suspended connections.



CR:699290
CR Number:   699290
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin Installer
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Aug 2014 Presently Not Targeted For Any Future Release Of This Product
Description
On Microsoft Windows, The Replication Manager uninstall process is not unregistering the plugin correctly. When Sybase Central is started after the uninstall, it displays an error message that it can't load the Replication Manager Plugin. Sybase Central will continue to work correctly after the message is dismissed.



CR:699364
CR Number:   699364
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
carina 18 Jun 2013 Fixed
Description
Documentation does not state that rs_ticket is non-compileable to both ASE and IQ.



CR:699366
CR Number:   699366
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2013 Duplicate
Description
MICROSOFT SQL SERVER ONLY: Replication Agent

remains in REPLICATING state but fails to

replicate any changes after processing an 'alter

index ... rebuild' log operation.
Workaround Description
 After rebuilding the clustered index, reset replication using:

pdb_setreptable table_name , disable

pdb_setreptable table_name, unmark

pdb_setreptable table_name, mark



CR:699398
CR Number:   699398
Product Name:   Other - Docs: Rep Server
Product Component:   Other - Docs: Rep Server
Status:   Closed
OS:   NA
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 ESD #1 18 Jun 2013 Added to user documentation
Description
Documentation does not state hvar/rtl limitation with views.
Workaround Description
 do not use view or....mark the repdef as non-compileable



CR:699688
CR Number:   699688
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 May 2012 Added to user documentation
Description
DOC RS ... AIX ... specify all required libraries needed for RS to start
Workaround Description
 the optional AIX 6.x piece the customer needs to install is ... xlsmp.aix53.rte

fileset ... and it is found on the AIX 6.x 1st installation dvd ... on the first

disk at /<mount point>/installp/ppc/xlsmp.aix53.rte





this is what the customer should see before they attempt to execute the repserver binary after install ...



source $SYBASE/SYBASE.csh

cd $SYBASE/$SYBASE_REP/bin

ldd ./repserver



tcsh:sybase@slingaix:/sy/rs6a156e1/REP-15_5/bin> source $SYBASE/SYBASE.csh

tcsh:sybase@slingaix:/sy/rs6a156e1/REP-15_5/bin> cd $SYBASE/$SYBASE_REP/bin

tcsh:sybase@slingaix:/sy/rs6a156e1/REP-15_5/bin> ldd ./repserver

./repserver needs:

/sy/rs6a156e1/REP-15_5/lib64/libsybeconn.so

/sy/rs6a156e1/OCS-15_0/lib3p64/libsbgse2.so

/usr/lib/libpthread.a(shr_xpg5_64.o)

/sy/rs6a156e1/REP-15_5/lib3p64/log4cxx/lib/liblog4cxx.so

/sy/rs6a156e1/REP-15_5/lib3p64/log4cxx/lib/libapr-1.so

/sy/rs6a156e1/REP-15_5/lib3p64/log4cxx/lib/libaprutil-1.so

/sy/rs6a156e1/REP-15_5/lib3p64/log4cxx/lib/libexpat.so

/usr/lib/libwlm.a(shr_64.o)

/usr/lib/libC.a(shr_64.o)

/usr/lib/libC.a(ansi_64.o)

/usr/lib/threads/libc.a(shr_64.o)

/usr/lib/threads/libc.a(aio_64.o)

/usr/lib/libC.a(shr2_64.o)

/usr/lib/libpthreads.a(shr_xpg5_64.o)

/unix

/usr/lib/libxlsmp.a(smprt_64.o)

/usr/lib/libiconv.a(shr4_64.o)

/usr/lib/libcorcfg.a(shr_64.o)

/usr/lib/libC.a(ansicore_64.o)

/usr/lib/libC.a(shrcore_64.o)

/usr/lib/libC.a(shr3_64.o)

/usr/lib/libcrypt.a(shr_64.o)

/usr/lib/libsrc.a(shr_64.o)

/usr/lib/libodm.a(shr_64.o)

/usr/lib/libcfg.a(shr_64.o)



CR:699745
CR Number:   699745
Product Name:   RepConnector
Product Component:   Run-time Engine
Status:   Open
OS:   Generic
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
Upgrade RepConnector to support EAS 6.3.1



CR:699795
CR Number:   699795
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Wrong path structure could not be updated / removed in the repository via GUI.



There are several samples where a wrong or obsolete path structure of models using named path are not possibe to be corrected via the PowerDesigner GUI.

The path in the PMFLDR (XNAM) or PMXFIL (XNAM)persist in the repositroy.

During a check in, the subpath information can not be modified.

It persist in the repository no matter how you try to resolve it.



CR:699812
CR Number:   699812
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 using:



- Power Designer 15.2 EBF#10

- Windows XP 32-bits

- SQL 2005 and SQL 2008



Problem Description: Repository is displaying duplicated folders in the repository, when there are more than one branch with the same model.



CR:699957
CR Number:   699957
Product Name:   RepConnector
Product Component:   Run-time Engine
Status:   Open
OS:   Generic
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
reduce I/O access to serialization file.
Workaround Description
 Unknown



CR:700015
CR Number:   700015
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Feb 2012 Fixed
08 Mar 2012 Fixed
14 Apr 2012 Fixed
Description
The memory used reported from Solaris "prstat" for Rep Server process is not comparable

to what is reported by RS "admin stats, mem_in_use" command.



The issue is Solaris memory management does not release memory used by a process immediately once it is allocated even though Rep Server already freed the memory by "free()".

In effect, "prstat" represents maximum RS memory use.



A new RS command is provided in this resolution: "admin stats, max_mem_use" to get the max memory space used since RS start up. This number should be comparable to the Solaris "prstat".
Workaround Description
 None.



CR:700050
CR Number:   700050
Product Name:   Rep Server Connectors
Product Component:   Oracle OCI Connector
Status:   Open
OS:   Suse
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
DSI failed with error 5213 when replicating text column to Oracle thru' ECO with user defined rs_writetext function string which called Oracle stored proc to update CLOB column.



CR:700236
CR Number:   700236
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2012 Fixed
Description
Users cannot connect to PowerDesigner repository through proxy configurations.



A error message is always being thrown out:

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

PowerDesigner - Error

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

You may not connect to the repository because your account has been inactive for more than 365 days. Contact your administrator to unblock your account.





1. Setup the proxy for instance to a MS SQL or ASA database where repository 16.1 is always is installed

2. Setup proxy repository definition using the proxy connection

Repository -> Repository Definitions ...

3. Login as Administrator to the repository in Repository Browser

4. Create a new user "Stefan"

Repository -> Administration -> Users

5. Press the "Reset Password" button and set the password to "Sybase001"

6. Disconnect from Repository

7. Connect as Stefan to the Repository using the Proxy



-> PowerDesigner - Error
Workaround Description
 1. Do the first User connect via a direct connection and reset the password

2. After this you can use the proxy as the User.



CR:700485
CR Number:   700485
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Open
OS:   NA
Original Version:   6.1.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2012 Fixed
10 Jun 2013 Added to user documentation
Description
DB2 UDB ONLY: The default lr_read_buffer_size

value of 16K is too small, frequently resulting

in DB2 SQL error 2650 and reason code 8. The

default value is now 64K.
Workaround Description
 Increase the lr_read_buffer_size.



Increasing it to 64K has resolved the problem in all instances so far.



CR:700565
CR Number:   700565
Product Name:   Rep Serv Admin Guide
Product Component:   Rep Serv Admin Guide
Status:   Closed
OS:   NA
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 08 May 2012 Fixed
Description
LDAP authentication - add clarifications in Replication Server documentation



clarify:

1. When manual says that "Replication Server only uses LDAP for ...server names and connection properties". The result is you may use and LDAP server in place of an

Interfaces file. LDAP is only supported for server/interfaces access.



2. You can NOT use LDAP with Replication Server for Replication Server user

authentication. Further explanation that normally *ONLY* RS admins need to log in to the RS -- this is not a system that has or should expect a lot of logins from general user population. More often, monitoring processes NOT LIKELY in LDAP will be the more normal user logins (via RMS/UAF/SCC). Accordingling, LDAP user authentication has limited affect/impact within any organization and NOT supported by Replication Server.



CR:700657
CR Number:   700657
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Bulk insert works inconsistently when number of columns in the repdef is different than the number of columns at the target table.
Workaround Description
 Match the repdef to the target table.



CR:700697
CR Number:   700697
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
Status:   Closed
OS:   all
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 08 May 2012 Presently Not Targeted For Any Future Release Of This Product
Description
Some Replication Server 15.7 manuals say that dsi_xact_group_size is obsolete.

But dsi_xact_group_size can be used on RS 15.7.



CR:701074
CR Number:   701074
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.1.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2012 Fixed
Description
For internal use only (new development):

ORACLE ONLY: Oracle11g XMLType table

replication feature support.



CR:701077
CR Number:   701077
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Microsoft Windows
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2012 Fixed
20 Mar 2012 Fixed
30 Mar 2012 Fixed
Description
Cannot replicate text/image to MS SQL with dsi_alt_writetext = dcany
Workaround Description
 Have not found workaround except to turn dsi_alt_writetext to 'off'



CR:701195
CR Number:   701195
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
customer believes the text based utilities like isql, bcp, and rs_subcmp should be

consistent ... the password arguments should function the same for all three of

these utilities ... rs_subcmp is different compared to isql and bcp. At least

isql and bcp are consistent.



CR:701215
CR Number:   701215
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Microsoft Windows
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
windows subcmp with cfg file gives message when other platforms are silent



When last line and last character of (=) in the cfg file ends with ... PPWD =<absence of a carriage return line feed characters by the way> ...



PPWD =



then the following message happens ...



Warning: line 7 in configuration file does not contain a valid assignment. [\subinit.c(600)]



this only happens on windows



CR:701521
CR Number:   701521
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Message of invalid datatype 'bit' happens when bit datatype is specified with a length
Workaround Description
 remove precision when using datatype of bit



CR:701548
CR Number:   701548
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
RS does not warn that custom function string processing not allowed for text/image processing with ECO.



CR:701550
CR Number:   701550
Product Name:   Other - Docs: Rep Server
Product Component:   Other - Docs: Rep Server
Status:   Closed
OS:   NA
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2012 Fixed
15.7.1 08 May 2012 Fixed
Description
Cannot override text/image processing in ECO with custom function strings.
Workaround Description
 Use DCO, however, at this time, DCO has not been certified with use RAO 15.6.



CR:701683
CR Number:   701683
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Admin
Status:   Closed
OS:   Generic
Original Version:   6.1.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jun 2012 Fixed
17 Apr 2012 Added to user documentation
Description
After the user carries out the Replication Agent

migration, the Replication Agent will prompt the

user that migration has succeeded. But the

Replication Agent tables in the primary database

may not have actually been upgraded or downgraded.



CR:701946
CR Number:   701946
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   Windows XP
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2012 Duplicate
Description
Tested and reproduced with:



- PD 16.1 GA and 16.1 EBF#2

- Repository DB: Microsoft SQL Server 2008

- Using PD 16.1 Proxy (However, issue also occurrs from outside PD proxy)



When checking in a model in PD 16.1, customer receives the following errors:



Message box: "Unexpected error while executing SQL statements in repository"



If using PD proxy, customer may also receive the following message box:

PDProxy16.exe application error:

"The exception unknown software exception (0xc0000417) occurred in the application at location 0x78b2a3f6"



And PDProxy16.exe error log shows data mismatch as root cause of check in:



2012-03-16 10:26:59 info - OnClose: Closing client connection 10.2.209.119

2012-03-16 10:26:59 debug - SSockClient: closing #3

2012-03-16 10:27:00 debug - status: 0 clients, 2 sockets, 1 db connections, 0 for pipes, 5 own/882 total threads, 168.1MB private bytes, 646.5MB available of 2.1GB physical memory, 2.7GB available of 4.1GB virtual memory

-------------------------------- 16.1.0.3637 Unicode

2012-03-16 10:27:06 debug - CreateSocket: Listening on created socket.

-------------------------------- 16.1.0.3637 Unicode

2012-03-16 10:33:57 fatal - SProxyQueryColumn: unsupported length for SRepCHAR 0

2012-03-16 10:33:57 fatal - SProxyQueryColumn: unsupported length for SRepCHAR 0

2012-03-16 10:34:23 fatal - SProxyQueryColumn: unsupported length for SRepCHAR 0

2012-03-16 10:34:31 fatal - SProxyQueryColumn: unsupported length for SRepCHAR 0

2012-03-16 10:34:31 fatal - SProxyQueryColumn: unsupported length for SRepCHAR 0

2012-03-16 10:38:07 error - OdbcError: [22026] [Microsoft][SQL Server Native Client 10.0]String data, length mismatch



And on PD Console you will see:



Checking in the document 'C:\Cases\11726366\DBQLADM.pdm'

- Saving the local document in the repository...

Unexpected error while executing SQL statements in the repository

The check in of the document has been cancelled.



CR:701966
CR Number:   701966
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2012 Fixed
22 Mar 2012 Fixed
Description
After upgrade to 15.6, ERROR #21 DSI EXEC call to routine 'srv_langcpy' failed with custom function string.



CR:702039
CR Number:   702039
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
Feature request for MSA to have better wildcard support in database replication definition filters, e.g.

alter database replication definition db_repdef

with primary at PDS.PDB

not replicate tables in ('owner1.a*')



CR:702213
CR Number:   702213
Product Name:   RepConnector
Product Component:   Run-time Engine
Status:   Open
OS:   Generic
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
By default, RepConnector truncates database float values to the precision of the Java float type.
Workaround Description
 None known.



CR:702333
CR Number:   702333
Product Name:   Rep Serv Troubleshoot Guide
Product Component:   Rep Serv Troubleshoot Guide
Status:   Closed
OS:   all
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 May 2012 Fixed
Description
Document message if product name is missing on a parameter in the resource file.
Workaround Description
 fix the parameter name. In the Replication Server resource file, most parameters are prefixed with a rs. prior to the parameter name.



CR:702410
CR Number:   702410
Product Name:   Other - Docs: Rep Server
Product Component:   Other - Docs: Rep Server
Status:   Open
OS:   Unknown
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RepConnector Installation on HPia requires updating to show how to configure 64-bit EAServer to connect to ASA instance.
Workaround Description
 Configure a new datasource in EAServer to use jConnect to connect to the ASA instance.



CR:702431
CR Number:   702431
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2012 Fixed
Description
Customer request to add the feature to disallow subscribing directly from the Replication Definition if it is used in an Article and Publication.



CR:702515
CR Number:   702515
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.1.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 26 Mar 2012 Fixed
Description
For internal use only (found by dev):

ORACLE ONLY: In a Multiple Replication Agent

environment, when we run 'pdb_xlog init' again

after running 'pdb_xlog init' and 'pdb_xlog remove',

the following error comes along.



Could not read upgrade finialization status on

primary database <"orcl">, because <null>.



CR:702586
CR Number:   702586
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)
25 Mar 2012 Fixed
Description
Using RS>=15.5, replicating store procedure call in some particular situation, cause DSI to goes down on #5216 error.



This situation occurs if remote store procedure raise a user-error and also return a result-set after having raised the user-error:



- if the user-error is assigned (in RS side) to STOP_REPLICATION, DSI goes down on user-error (=> this is expected behavior)

- if the user-error is assigned to IGNORE, DSI goes down with 5216
Workaround Description
 Do not generate a result-set (do not execute a "select") after having raised a user-error in remote store procedure.



CR:702651
CR Number:   702651
Product Name:   Other - Docs: Rep Server
Product Component:   Other - Docs: Rep Server
Status:   Closed
OS:   Unknown
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2012 Added to user documentation
Description
Documentation to state that RS does not support custom function strings for text/image columns in ExpressConnect for Oracle.



CR:702666
CR Number:   702666
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
Status:   Closed
OS:   all
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 ESD #1 19 Jun 2013 Fixed
Description
alter replication definition and create replication definition does not allow for column name in the "references" clause.



CR:702769
CR Number:   702769
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2012 Fixed
Description
Stored procedure rs_helpcheckrepdef is modified so that it,

1) When the Repserver's site_version is at 1570, lists the replication definitions which exist to only define primary key columns and/or quoted table/column names.

2) When the Repserver's site_version is at or greater than 1571, lists the repdefs which exist to only define primary key columns, quoted table/column names and/or customized function strings.



CR:702837
CR Number:   702837
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)
18 Jun 2012 Fixed
18 May 2012 Added to user documentation
Description
ORACLE ONLY: Replication Agent can't access a

remote database if the archive path is not set.
Workaround Description
 *** Thu May 17 16:29:27 UTC+0800 2012 *** wenjingw ***

When RepAgent and Primary DB are not located on the same host, the parameter 'pdb_archive_path' of RepAgent should be set to a valid local directory, which matches the actual database archive path on remote host.



CR:702838
CR Number:   702838
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)
08 Jun 2012 Fixed
Description
ORACLE ONLY: Replication Agent validates the

LogMiner configuration/permission when

replication starts rather than during

Replication Agent initialization.



CR:702840
CR Number:   702840
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   NA
Original Version:   6.1.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2012 Fixed
04 Jun 2012 Fixed
06 Jun 2012 Fixed
Description
DB2 UDB ONLY: When user issues the

'ra_locator zero' command, the trunction point is

positioned at the end of the log instead of at the

beginning.



CR:702974
CR Number:   702974
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Unix
Original Version:   6.1.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Apr 2013 Fixed
Description
rs_oracle_binary datatype is limited to 254 bytes.
Workaround Description
 Manually create the replication definition using varbinary for the correct size



CR:703022
CR Number:   703022
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
To have a traceflag to turn off error 8040 report



CR:703098
CR Number:   703098
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Tested and reproduced with PD 16.1 EBF#2

Repository: MS-SQL Server 2008





This is for Itau-Unibanco.





Some indexes from repository tables were not dropped/recreated properly during repository migration process.

Customer needs to know if the same 15.2 scripts they used to drop/recreate the indexes can also be safely used in production repository. On QA environment, they used the scripts and repository connection time/performance was very good after that.



CR:703214
CR Number:   703214
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
beauregard EBF3 29 Mar 2012 Fixed
Description
Check in of a model via 16.1 EBF2 proxy cancelled



Checking in the document 'XXX'

- Saving the local document in the repository...

Unexpected error while executing SQL statements in the repository

A command sent to the repository proxy failed.

The check in of the document has been cancelled.





Working well via direct ODBC connect.
Workaround Description
 use ODBC connection



or



sometimes reconnect to proxy and check in again is working.



CR:703235
CR Number:   703235
Product Name:   RepConnector
Product Component:   Run-time Engine
Status:   Open
OS:   Generic
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
After applying 15.0.2 ESD4, version string shows ESD3.



CR:703302
CR Number:   703302
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Admin
Status:   Closed
OS:   Generic
Original Version:   6.1.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 ESD #2 13 Aug 2012 Fixed
Description
Replication Agent command 'pdb_setrepddl'

execution fails due to trailing whitespaces in

the parameter values.



CR:703402
CR Number:   703402
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Solaris
Original Version:   6.0.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 14 Jun 2012 Fixed
15.7.1 ESD #1 08 Nov 2012 Added to user documentation
6.0.17 31 Jul 2012 Fixed
6.0.15 23 Oct 2012 Fixed
Description
ORACLE ONLY: Replication Agent truncates Oracle

archive logs too soon, before Oracle completes

its archive work.



CR:703474
CR Number:   703474
Product Name:   Sybase Replication Server
Product Component:   scripts
Status:   Open
OS:   Linux
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New UDD for Oracle 'timestamp(6) with timezone' to ASE 'datetime'.



CR:703562
CR Number:   703562
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.1.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2012 Fixed
Description
If the user re-configures 'ra_admin_owner'

parameter but does not restart the Replication

Agent, and then execute 'ra_admin init', the error

'Could not initialize the primary database

because:ORA-00942: table or view does not exist'

comes along.
Workaround Description
 restart RA instance and do the xlog init again.



CR:703563
CR Number:   703563
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.1.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2012 Fixed
15.7.1 17 May 2012 Added to user documentation
15.7.1 26 Mar 2013 Fixed
17 Dec 2012 Fixed
Description
ORACLE ONLY: Replication Agent initialization

fails if the user specified by ra_admin_owner is

different than the user specified by

pds_username.
Workaround Description
 *** Tue Oct 23 10:56:44 UTC+0800 2012 *** haiyanc ***

If BDA is already granted to "pds_username", no issue.

Else

if this is the first RA to be initialized on this primary database,

follow workaround steps:

1. Connect to primary database and grant DBA to "pds_username".

For example,

grant dba to qa3user;



2. Restart RA instance and initialize it by "ra_admin init"



3. Connect to primary database and revoke DBA from "pds_username"

For example,

revoke dba from qa3user;



4. Grant all privilege of RA system objects (under schema "ra_admin_owner") to "pds_username" user.

4.1 Get the RA system objects name by

1> ra_admin

2> go

Component Name

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

database_name orcl11p

installed_buildnum 6140

installed_pdbver 11.1.0.6.0

ramaint_id <not_configured>

agent_table RA_AGENT

table_table RA_TABLE

procedure_table RA_PROCEDURE

xlogsys_table RA_XLOG_SYSTEM_

pcall_seq RA_PCALL

procactive_table RA_PROCACTIVE

rs_dump_proc RS_DUMP

rs_dump_shadow RA_DUMPSH

rs_marker_proc RS_MARKER

rs_marker_shadow RA_MARKERSH

table_name_base NULL



4.2 write a script for all the 10 RA system objects

For example,



grant all on qa10user.RA_AGENT to qa3user;

grant all on qa10user.RA_TABLE to qa3user;

grant all on qa10user.RA_PROCEDURE to qa3user;

grant all on qa10user.RA_XLOG_SYSTEM_ to qa3user;

grant all on qa10user.RA_PCALL to qa3user;

grant all on qa10user.RA_PROCACTIVE to qa3user;

grant all on qa10user.RS_DUMP to qa3user;

grant all on qa10user.RA_DUMPSH to qa3user;

grant all on qa10user.RS_MARKER to qa3user;

grant all on qa10user.RA_MARKERSH to qa3user;



4.3 Run the script in primary database with proper login



5. Restart RA instance and RA is able to mark table for replication.



If it's the second and later instance to be initialized on the same primary database:

if "pds_username" of this instance is same as the first instance, nothing is required to be done.

else, follow the workaround steps:

1. grant all privileged of RA system objects (under schema "ra_admin_owner") to "pds_username" user.

1.1 get the RA system objects name from the first RA instance by

1> ra_admin

2> go

Component Name

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

database_name orcl11p

installed_buildnum 6140

installed_pdbver 11.1.0.6.0

ramaint_id <not_configured>

agent_table RA_AGENT

table_table RA_TABLE

procedure_table RA_PROCEDURE

xlogsys_table RA_XLOG_SYSTEM_

pcall_seq RA_PCALL

procactive_table RA_PROCACTIVE

rs_dump_proc RS_DUMP

rs_dump_shadow RA_DUMPSH

rs_marker_proc RS_MARKER

rs_marker_shadow RA_MARKERSH

table_name_base NULL



1.2 write a script for all the 10 RA system objects

For example,



grant all on qa10user.RA_AGENT to qa4user;

grant all on qa10user.RA_TABLE to qa4user;

grant all on qa10user.RA_PROCEDURE to qa4user;

grant all on qa10user.RA_XLOG_SYSTEM_ to qa4user;

grant all on qa10user.RA_PCALL to qa4user;

grant all on qa10user.RA_PROCACTIVE to qa4user;

grant all on qa10user.RS_DUMP to qa4user;

grant all on qa10user.RA_DUMPSH to qa4user;

grant all on qa10user.RS_MARKER to qa4user;

grant all on qa10user.RA_MARKERSH to qa4user;



1.3 Run the script in primary database with proper login



2. Restart RA instance and initialize it with "ra_admin init"

3. RA is able to mark table for replication.



CR:703668
CR Number:   703668
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   6.1.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jun 2012 Fixed
08 May 2012 Added to user documentation
Description
ORACLE ONLY: After the user connects to the

Replication Agent instance and issues the 'resume'

command, an error might occur: "Oracle LogMiner

must be installed in order to use this command.

Please verify that LogMiner is installed."
Workaround Description
 GRANT DEBUG ON "SYS"."DBMS_LOGMNR" to the pds_username.

And then restart your Rep Agent instance.



CR:703684
CR Number:   703684
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.1.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2012 Fixed
15.7.1 17 May 2012 Added to user documentation
Description
ORACLE ONLY: The Replication Agent configuration

property pdb_thread_filter can be set but has

no affect.



CR:703888
CR Number:   703888
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
Whenever RS gets a message that does not allow a command to complete (e.g. failed to get sync lock), RS should put the command that failed in the RS log.



CR:703894
CR Number:   703894
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Closed
OS:   Linux
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2013 Fixed
23 May 2012 Added to user documentation
Description
Initialize standby using dump and load = yes for the standby database does not set up the ASE components at the standby properly.
Workaround Description
 add the maintenance user to the standby server with sp_addlogin.



CR:703935
CR Number:   703935
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ECDA hangs and/or crashes when data is replicated with a database subscription and the dsi_alt_writetext is set to dcany.
Workaround Description
 replicate using table repdefs and table subs. Do not replicate through a database subscription.



CR:704555
CR Number:   704555
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   lelude
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Randomly occurs, repository inconsistencies.

When repository administrator is updating a model into the repository, the model is saved with wrong version number and another versions with totally different version numbers are created at the same time. Only one of these versions contains check in comment.

If user does not manually delete the unexpected versions, he is not allowed to update the model anymore.



CR:704748
CR Number:   704748
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   HP-UX
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Apr 2012 Fixed
23 May 2012 Added to user documentation
25 May 2012 Fixed
30 May 2012 Fixed
Description
HVAR may hit a signal 11 while processing a source command having more columns than defined in the replication definiton. The issue occures when HVAR generates the DDL for the worktables involved

in compiled update/ or delete commands replication (through join-update/delete operations).



CR:704829
CR Number:   704829
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Microsoft Windows
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
when update only text/image and the row does not exist, the DSI does not suspend.
Workaround Description
 none at this time.



CR:705295
CR Number:   705295
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Microsoft Windows
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
cannot replicate image to MS SQL using dsi_alt_writetext = dcany
Workaround Description
 dsi_alt_writetext = off, however, for this customer, this is too slow.



CR:705455
CR Number:   705455
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2012 Fixed
25 May 2012 Fixed
17 Jan 2014 Insufficient priority to fix
Description
Partition initialization optimization is extended to support platform linuxamd64.



CR:705502
CR Number:   705502
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1
Description
password in rs config not in sync with table rs_users after modified in rs_init



CR:705657
CR Number:   705657
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 May 2012 Fixed
23 May 2012 Added to user documentation
Description
Though the sqm_cmd_cache_size is allowed to be as high as 2251799813685247 on 64-bit platforms, the max value that can actually get assigned to it is only 2147483647 (2GB -1).



CR:705698
CR Number:   705698
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
ERROR #6027/stack trace when adding partition while stable device is filling up



CR:705702
CR Number:   705702
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)
15.7.1 08 May 2012 Fixed
15.7.1 10 May 2012 Fixed
15.7.1 18 May 2012 Added to user documentation
15.7.1 ESD #1 14 Jun 2012 Fixed
15.7.1 ESD #1 08 Nov 2012 Added to user documentation
Description
ORACLE ONLY: Replication Agent fails to filter

DDL that is executed by SYS user.
Workaround Description
 Add SYS user into DDL filter list, as:

pdb_setrepddl user, SYS, disable

go



CR:705716
CR Number:   705716
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)
07 Jun 2012 Fixed
Description
ORACLE ONLY: Tables owned by SYS user are marked

and replicated when they should not be.



CR:705721
CR Number:   705721
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Apr 2012 Fixed
Description
MSA for tables with text/image column stack traces when HVAR is on.



CR:705736
CR Number:   705736
Product Name:   Rep Server Connectors
Product Component:   Oracle OCI Connector
Status:   Closed
OS:   Generic
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2012 Fixed
Description
clarification on overridding the default for connector trace log location.



CR:706053
CR Number:   706053
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Installation
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2012 Added to user documentation
Description
Cannot create pds_username in the resource file as part of instance creation.
Workaround Description
 Create the username directly into the DBMS and assign all the permissions.



CR:706505
CR Number:   706505
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)
25 May 2012 Not a Bug
Description
'alter replication definition' unique key violation on rs_objects



CR:706652
CR Number:   706652
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jan 2013 Fixed
Description
MICROSOFT SQL SERVER ONLY: Replication Agent

sometimes sends an inaccurate length attribute

for an image column to Replication Server

resulting in data loss.



CR:706707
CR Number:   706707
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Open
OS:   Windows
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer is using Internet Explorer 8. When they attempt to print details from the Portal, the Repository Object Properties information does not get printed. If the customer uses Firefox or Chrome, the information is included in the printout.



to reproduce:

1) connect to portal in IE 8 or 9

2) via repository explorer, click on an object to 'view detailed information' (diagram or text)

3) select Print Preview

NOTE: The header, footer, and explorer treeview are visible. However, the details of the selected object is not included in the printout



CR:706721
CR Number:   706721
Product Name:   Rep Server Configuration Guide
Product Component:   Rep Server Configuration Guide
Status:   Closed
OS:   BSD
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 08 May 2012 Fixed
Description
admin show_route_version should be admin show_route_versions



CR:706730
CR Number:   706730
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)
25 Jul 2012 Fixed
25 Jul 2012 DEFER
11 Jul 2012 Fixed
07 Jun 2012 Fixed
Description
Suppose a primary Replication Server is at 15.5 or up, a replicate Replication Server is upgraded from pre 15.5 to 15.5, and its site_version is still lower than 1550. Suppose a replication definition is altered at the primary at some point so that its rs_objects.version != rs_objects.objid. When data associated with the replication definition goes to the replicate Replication Server, it would get an error message like the follows,

Invalid object identifier for table or function 'tab1_repdef'. id = 0x0102006500000065.

E. 2012/04/27 13:34:37. ERROR #5035 DSI EXEC(107(1) ost_repsolvm_01.rdb2) - /dsiutil.c(4091)

Error from unpacker or parser. See previous message for more information.
Workaround Description
 Set the replicate Replication Server's site_version to 1550 or up, and perform route upgrade from PRS to RRS, so that information about rs_objects.version can be copied over to RRS's RSSD. Please don't use "sysadmin fast_route_upgrade ..." to perform route upgrade for this use case.



CR:707017
CR Number:   707017
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 May 2013 Fixed
13 Jun 2012 Fixed
Description
If create a new branch it is not possible to select during "apply model changes to database" and "using a model from repository" the version of the new branch. Only versions of <Default> branch are shown.



CR:707096
CR Number:   707096
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)
Description
Upgrading site version to 15.5, incorrectly states that route from version 15.2 to 15.6 must be upgraded.



CR:707116
CR Number:   707116
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.6 ESD #2 31 May 2012 Fixed
6.0.13 31 May 2012 Fixed
15.7.1 ESD #1 06 Jun 2012 Fixed
Description
MICROSOFT SQL SERVER ONLY: Replication Agent fails

to replicate IMAGE column data.



CR:707179
CR Number:   707179
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 06 May 2012 Fixed
15.7.1 ESD #1 12 Jul 2012 Fixed
Description
ORACLE ONLY: Update operation on XML column

failed to be replicated by Replication Agent.



CR:707238
CR Number:   707238
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)
12 Jun 2012 Fixed
Description
ORACLE ONLY: Replication Agent fails to mark a

procedure when the procedure owner (schema)

is different than the pds_username user.
Workaround Description
 As the procedure owner user (qa6user):



1. cleanup the procedure to remove RA instrumentation or re-create the procedure so that it compiles successfully:



create or replace procedure qay_proc3 (parm_IN IN number) as

BEGIN

insert into qay_table values(parm_IN,1);

END;

/



As the pds_username (qaluser) user:



2. drop the shadow table:



sqlplus> drop table ra_qay_proc3sh;



3. create a public synonym for the RA_PCALL sequence:



sqlplus> create public synonym RA_PCALL for RA_PCALL;



Then, in RAO:



4. Execute pdb_setrepproc again:



isql> pdb_setrepproc qay_proc3, mark

isql> go



CR:707265
CR Number:   707265
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2013 Fixed
Description
Stack when the columns in the primary key differ in the same compilation of commands.
Workaround Description
 hvar/rtl relies on the fact that the primary key must be consistent between PRS and RRS. If this cannot be done, then the table should not be compiled.



CR:707274
CR Number:   707274
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   6.1.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jun 2012 Fixed
17 May 2012 Added to user documentation
Description
ORACLE ONLY: Replication fails to start because

LogMiner fails to start with a 0 start SCN.
Workaround Description
 resume Rep Agent



CR:707408
CR Number:   707408
Product Name:   Other - Docs: Rep Server
Product Component:   Other - Docs: Rep Server
Status:   Closed
OS:   Solaris
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 ESD #1 19 Jun 2013 Added to user documentation
Description
Formally doc need for IQ maintenance user to have: STRING_RTRUNCATION to OFF



CR:707544
CR Number:   707544
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/UDB
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2012 Fixed
18 May 2012 Added to user documentation
Description
DB2 UDB ONLY: Replication Agent aborts due to

no metadata found in marked object.



CR:707701
CR Number:   707701
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Certify RS 15.7.1 with ASE 12.5.4



CR:707720
CR Number:   707720
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   6.0.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2012 Fixed
31 May 2012 Fixed
07 Jun 2012 Fixed
Description
MICROSOFT SQL SERVER ONLY: A

VirtualFileNotFoundExceptions sends Replication

Agent to REPLICATION DOWN state.
Workaround Description
 Resume Rep Agent



CR:707877
CR Number:   707877
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   6.0.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.6 ESD #2 30 May 2012 Fixed
6.0.13 30 May 2012 Fixed
06 Jun 2012 Fixed
Description
MICROSOFT SQL SERVER ONLY: Replication Agent goes to REPLICATION DOWN status with

NoSuchElementException error when processing a rollback operation.



CR:708025
CR Number:   708025
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2012 Not reproducible with latest version of the product available as of Resolution Date
Description
MSA: If a table level subscription does NOT include 'subscribe to truncate table' (which is the default) but a database subscription includes 'subscribe to truncate table' then truncate table at the primary will be incorrectly replicated to the table subscription replicate as well as the database replicate.
Workaround Description
 Do not use 'subscribe to truncate table' in database subscription.



CR:708118
CR Number:   708118
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2012 Fixed
Description
Configuration parameter dsi_text_convert_multiplier should only be used for text datatype. Currently, it is incorrectly being used for image and unitext datatypes too.



CR:708154
CR Number:   708154
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jun 2012 Fixed
29 Aug 2012 Fixed
Description
In MSA environment, if the table replication definition has numeric column and have any map to clause and does not have 'send standby' clause, DSI may shut down due to error 32024 complaining datatype '101' not supported.
Workaround Description
 Use "send standby all columns" in table replication definition, can help new data replication into MSA standby database.

OR

add additional replication definition for MSA warm standby with "send standby all columns"



CR:708398
CR Number:   708398
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2012 Fixed
23 May 2012 Added to user documentation
Description
HVAR corrupts compressed LOB column values when applying them as non-compliable commands and when the compressed value has a size smaller than 32K bytes. A second issue is a DSI shutdown when HVAR applies non-compilable commands having a LOB column value larger than 32K bytes (compressed or not).
Workaround Description
 1) Disable minimally packed commands on the object if issue due to a pkey update on minimally

pack command.

2) or Disable non-compilable attribute on table if this is possible.

3) or Disable HVAR if the non-compilable command cannot be avoided (foreing key constraint detection)



CR:708406
CR Number:   708406
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 May 2012 Not reproducible with latest version of the product available as of Resolution Date
Description
alter replication definition breaks "identity mapped to numeric"



CR:708416
CR Number:   708416
Product Name:   Rep Server Tests
Product Component:   Rep Server Tests
Status:   Open
OS:   NA
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Test is not checking to ensure that RS is properly set up for "native error code" handling.



CR:708568
CR Number:   708568
Product Name:   Rep Server Connectors
Product Component:   Oracle OCI Connector
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 ESD #1 16 May 2012 Fixed
HANA 21 Aug 2012 Fixed
Description
Oracle connection via ECO cannot be created in Replication Server when tnsnames.ora file has FAILOVER_MODE section.
Workaround Description
 customer is activating Oracle's Transparent Application Failover (TAF)

by the following lines in their tnsnames.ora file ...

...

(LOAD_BALANCE = yes)

...

(FAILOVER_MODE =(TYPE = session)(METHOD = basic))

...





they need to ...



change ...



tcsh:sybase@slings:/sy/rs6s157/REP-15_5/connector/oraoci/network/admin> cat ./tnsnames.ora

ox11gsox =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = slingox.sybase.com)(PORT = 11201))

(LOAD_BALANCE = yes)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ox11gsox)

(FAILOVER_MODE = (TYPE = session)(METHOD = basic))

)

)

tcsh:sybase@slings:/sy/rs6s157/REP-15_5/connector/oraoci/network/admin>





to ...



tcsh:sybase@slings:/sy/rs6s157/REP-15_5/connector/oraoci/network/admin> cat ./tnsnames.ora

ox11gsox =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = slingox.sybase.com)(PORT = 11201))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ox11gsox)

)

)

tcsh:sybase@slings:/sy/rs6s157/REP-15_5/connector/oraoci/network/admin>





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

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