提供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:547026
CR Number:   547026
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.1 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2008 Fixed
21 Oct 2008 Fixed
25 Feb 2009 Fixed
Description
When the Replication Server is dropping multiple

publications, the Distributor thread may

deadlock with a DSI thread.



CR:547072
CR Number:   547072
Product Name:   Sybase Replication Server
Product Component:   RMA
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2009 Presently Not Targeted For Any Future Release Of This Product
Description
After primary ASE is shutdown/restarted, RMS 'get heartbeat tickets' will not work until the UAF agent is also restarted.



CR:547171
CR Number:   547171
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Closed
OS:   Windows
Original Version:   Jove
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2008 Fixed
Description
build 20081014 in firefox





reproduce:

1.goto configuration and click notification

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

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

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



CR:547246
CR Number:   547246
Product Name:   RepConnector
Product Component:   Run-time Engine
Status:   Open
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to have RepConnector support database repdefs and subscriptions (MSA).



CR:547278
CR Number:   547278
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Oct 2008 Fixed
17 Oct 2008 Fixed
Description
When executing the command 'sysadmn hibernate

off' the Replication Server will incorrectly

disable STS caching. This will result in an

increase in RSSD queries which in turn may

negatively impact Replication Server

performance.



CR:547374
CR Number:   547374
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   closluce
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2008 Fixed
Description
Check in a repository a model without "store prepared diagram"

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

diagram is not saved in repository

it should



CR:547421
CR Number:   547421
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2008 Fixed
11 Jan 2009 Fixed
Description
During the upgrade process to RS 15.1 GA, the

index 'rs_key2_diskpartitions' for the RSSD

table 'rs_diskpartition' is incorrectly not

created.
Workaround Description
 Manually make the index. Not that this index is not absolutely needed. However, because the index is partition id, the use of this index will prevent accidental creation of two partitions with the same partition id.



CR:547423
CR Number:   547423
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Closed
OS:   Windows
Original Version:   Jove
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2008 Fixed
25 Nov 2008 Fixed
25 Nov 2008 Fixed
Description
NPE when trying to load multi-model report objects.



CR:547428
CR Number:   547428
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Closed
OS:   Windows
Original Version:   Jove
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2008 Fixed
30 Oct 2008 Fixed
Description
When display PD models, we should merge the model document and model object into a single node on the tree. Right now, we are display the document as the parent node, and the model object as the child node.



CR:547430
CR Number:   547430
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Closed
OS:   Windows
Original Version:   Jove
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Nov 2008 Fixed
Description
we need to allow user to change the realm between local and remote. Right now, there is no way to create the same user id for local and remote.



CR:547438
CR Number:   547438
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.5.17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.24 27 Jan 2009 Fixed
02 Feb 2009 Fixed
02 Feb 2009 Fixed
Description
ORACLE ONLY: The configuration parameter

'truncation_type' default is incorrectly set to

'interval'.



CR:547564
CR Number:   547564
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   12.6.0.5307P18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2009 Fixed
15 Oct 2009 Fixed
5.7.15 14 Oct 2009 Fixed
5.8.02 15 Oct 2009 Fixed
5.9.00 15 Oct 2009 Fixed
Description
ASE ONLY: Replication Agent fails to resume

replication with error "IOException:

java.net.UnknownHostException" when the

primary database is unavailable.



CR:547570
CR Number:   547570
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.8.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2009 Fixed
05 Feb 2009 Fixed
Description
ORACLE ONLY: The incomplete message "The

replication environment is not configured to

allow DDL replication." is displayed if a

database level replication definition is not

configured in Replication Server.



CR:547581
CR Number:   547581
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.01 22 Oct 2008 Fixed
5.8.00 24 Oct 2008 Fixed
Description
ORACLE RAC ONLY: After a request to start

replicating, an ArrayIndexOutOfBounds

exception occurs during cluster log scanner

positioning sending the Replication Agent

to ADMIN state.



CR:547814
CR Number:   547814
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   5.7.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.01 27 Oct 2008 Fixed
5.7.01 06 Nov 2008 Fixed
5.8.00 06 Nov 2008 Fixed
Description
There are three new options to the -u parameter

in the ra_admin utility for upgrading Replication

Agent instances.



SYNTAX: ra_admin -u <upgrade_option>



PARAMETERS



-u <src_instance_dir>



Upgrade one instance of Replication Agent in

the specified source instance directory

to the product installation directory



-u <instance_name> | instance=<instance_name>



Upgrades only the specified instance of

Replication Agent in the current product

installation directory



-u all



Upgrade all instances of Replication Agent

within the current product installation

directory.





EXAMPLE:



To upgrade an individual instance in

a specified source instance directory to

the product installation directory.



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



To upgrade all the instances in the current

product installation.



ra_admin -u all



To upgrade a specific instance in the current

product installation directory.



ra_admin instance=my_inst

OR

ra_admin my_inst





NOTE:



- The -u <src_instance_dir> provides the

ability to upgrade an individal instance

from a previous major release to the

current release.



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

'instance=<inst_name>' upgrade options

performs an upgrade of instance(s)

in the current product release. All

upgrades are performed directly on the

instance to be upgraded. The Replication

Agent instance configuration file is

backed before the upgrade for use in error

recovery, if required. If an error occurs,

the upgrade is rolled back. This option is

intended for performing upgrade of instances

between release to release in the same

major release such as a patch update.



CR:547841
CR Number:   547841
Product Name:   Sybase Replication Server
Product Component:   InstallShield
Status:   Closed
OS:   Microsoft Win32s
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2010 Presently Not Targeted For Any Future Release Of This Product
Description
RS 15.1: Sybase Unified Agent will not start as a Windows service. Fails with error:

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

Error 1067: The process terminated unexpectedly.

due to incorrect registy entry.
Workaround Description
 Either start the agent from a command line or modify "JRE Home" value in the registry to point to the Shared\JRE-6_0_6_32BIT dir. E.g (something like):

[HKEY_LOCAL_MACHINE\SOFTWARE\Sybase\Unified Agent]

"Agent Home"="C:\\sybase\\rs151\\UAF-2_0"

"Service Version"="2.0"

"Sybase Home"="C:\\sybase\\rs151"

"JRE Home"="C:\\sybase\\rs151\\Shared\\JRE-6_0_6_32BIT"



CR:547888
CR Number:   547888
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   closluce
Fixed Version Build Resolution Date Closure Code (If Appropriate)
closluce EBF1 28 Oct 2008 Fixed
Description
During repository database installation, we generate .gif icons for metaclasses.

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

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



CR:547994
CR Number:   547994
Product Name:   Sybase Replication Server
Product Component:   rs_subcmp
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2009 Duplicate
Description
Customer would like to have "rs_subcmp" RepServer tools to be build as a 64bit application, so this tools would be able to compare huge data table.



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



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



CR:548063
CR Number:   548063
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   5.7.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.01 26 Oct 2008 Fixed
Description
MICROSOFT SQL SERVER ONLY: In certain cases,

the 'pdb_setrepproc' command can return

an error: "Command <pdb_setrepproc>

failed - Could not list metadata for procedure

<procedure_name> because: Procedure

<procedure_name> is not in database

<database_name>."



CR:548098
CR Number:   548098
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   5.7.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2008 Fixed
02 Dec 2008 Fixed
5.5.23 07 Jan 2009 Presently Not Targeted For Any Future Release Of This Product
Description
MICROSOFT SQL SERVER ONLY: pdb_setreproc command

with the <procName> return results containing dbo

qualifier in the replicate name column.



CR:548128
CR Number:   548128
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.5.17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.17 27 Oct 2008 Fixed
5.7.01 27 Oct 2008 Fixed
5.8.00 27 Oct 2008 Fixed
Description
ORACLE ONLY: Replication will fail after

migrating from GA version to the latest ESD with

an error like "Reposition point <locator value>

is older than start of log point <second locator

value>."



CR:548148
CR Number:   548148
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add indexes to rs_ticket_history.



CR:548183
CR Number:   548183
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Open
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Interactive rs_init will core when RSSD database was previously created and create RSSD = yes
Workaround Description
 1. Drop the RSSD database. No need to drop the devices. Then re-create the RSSD

--OR--

2. Use a resource file to build the RS. Here is a sample:



sybinit.charset: iso_1

sybinit.language: us_english

sybinit.component_directory: /c11014900/sybase1510/REP-15_1

sybinit.release_directory: /c11014900/sybase1510

sybinit.boot_directory: /c11014900/sybase1510

sybinit.product: rs

sqlsrv.sa_password: USE_DEFAULT

sqlsrv.sa_login: USE_DEFAULT

sqlsrv.master_device_size: USE_DEFAULT

sqlsrv.master_device_physical_name: USE_DEFAULT

sqlsrv.server_name: USE_DEFAULT

sqlsrv.new_config: USE_DEFAULT

rs.rs_operation: rs_install

rs.rs_diskp_lname: p1

rs.rs_diskp_name: /c11014900/devices/sunak1510rep2p1.dat

rs.rs_rssd_log_device_name: sunak1510rep2_RSSD

rs.rs_rssd_db_device_name: sunak1510rep2_RSSD

rs.rs_create_rssd: yes

rs.rs_rssd_sqlsrvr: sunak1502i

rs.rs_idserver_name: sunak1510rep2

rs.rs_id_server_is_rs_server: yes

rs.rs_name: sunak1510rep2

# -END_ATTRIBUTES-



CR:548375
CR Number:   548375
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.5.17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Nov 2008 Fixed
15 Dec 2008 Fixed
Description
ORACLE ONLY: A null pointer exception is thrown

when an invalid argument is specified

to the command "pdb_setrepproc".



CR:548378
CR Number:   548378
Product Name:   Sybase Replication Server
Product Component:   rs_subcmp
Status:   Closed
OS:   Solaris
Original Version:   15.0.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0.1 ESD #4 04 Nov 2008 Fixed
02 Dec 2008 Fixed
25 Nov 2008 Fixed
Description
If a replicate table contains a TEXT/IMAGE

column that contains NULL data, rs_subcmp will repeatedly generate

Open Client Library error 16843070.



CR:548385
CR Number:   548385
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Closed
OS:   Windows
Original Version:   Jove
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2008 Fixed
Description
Build 20081029-1500version



Steps:

Take Server Configurations->General as example



1. Delete the value in "Session timeout"

2. Click Reset button



Result:

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

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



CR:548404
CR Number:   548404
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Closed
OS:   Windows
Original Version:   Jove
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Nov 2008 Fixed
Description
EBF1

prepare a pdm model with multiple version

Reproduce:

1.click at the model and go to permission

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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



CR:548406
CR Number:   548406
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Closed
OS:   Windows
Original Version:   closluce EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2008 Fixed
Description
EBF1

reproduce:

1.click a model and go to permission

2.delete the public group

3.add in user "a" with list permission

4.logout and login with user a

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



CR:548418
CR Number:   548418
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Closed
OS:   Windows
Original Version:   Jove
Fixed Version Build Resolution Date Closure Code (If Appropriate)
closluce EBF2 17 Nov 2008 Fixed
Description
EBF1

To reproduce:

1>there are two head for exception page.

Attached the image.



CR:548570
CR Number:   548570
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   closluce
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to support encryption of repository table columns using algorithms supported by the underlying DBMS.



CR:548624
CR Number:   548624
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   5.5.14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.23 08 Jan 2009 Fixed
5.7.01 10 Nov 2008 Fixed
5.8.00 10 Nov 2008 Fixed
Description
ORACLE ONLY: Mirror log location property

fails to initialize when creating instance

from response file without setting

initialize_instance or start_instance

to true.



CR:548650
CR Number:   548650
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 05 Feb 2009 Fixed
Description
References to rs_configure stored procedure, have not been completely removed from the manual.



CR:548652
CR Number:   548652
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2009 Not a Bug
Description
Message starting with "Error gathering random seed data.." shows up at console when starting up Replication Server.
Workaround Description
 ignore the message



CR:548654
CR Number:   548654
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Repository
Status:   Closed
OS:   AIX
Original Version:   5.5.17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.23 06 Jan 2009 Fixed
5.7.01 17 Nov 2008 Fixed
5.8.00 17 Nov 2008 Fixed
Description
"rasd_restore" command fails with

"Could not stop database <repository

database name>" error message.



CR:548692
CR Number:   548692
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   closluce
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Implement psoibility to trace interactions beween different users / different PD applications on a Reprository and the stored Models.



CR:548796
CR Number:   548796
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.7.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.01 06 Nov 2008 Fixed
5.8.00 17 Nov 2008 Fixed
Description
ORACLE ONLY: pdb_setreptable command

shows an incorrect error message when an invalid

owner string is passed in.



CR:548819
CR Number:   548819
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   NA
Original Version:   5.8.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.8.00 26 Nov 2008 Presently Not Targeted For Any Future Release Of This Product
5.7.01 26 Nov 2008 Presently Not Targeted For Any Future Release Of This Product
5.5.18 26 Nov 2008 Presently Not Targeted For Any Future Release Of This Product
Description
ASE ONLY: Mirror Replication Agent may go

to ADMIN state with an OutOfMemory error in

the log during ra_init if more than 1000

tables are in primary database.



CR:548841
CR Number:   548841
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2008 Fixed
26 Nov 2008 Fixed
Description
Route is allowed to drop without checking for active subscriptions.
Workaround Description
 Well, one cannot stop the route. So the only thing we can do is to clean up after the accident:



1. On the RRS, sysadmin purge_route_at_replicate, PRS

This should stop the messages to the RRS log

2. On the PRS, drop route to xxx with nowait



Reboot the Rep Servers.



Do admin who on both Rep Servers, repeat #1 if needed.



Reboot the Rep Servers.



Do admin who. If on the RRS, you see RSI User thread showing inactive to the rsid of the old rep server. This is because a rs_routes entry. I deleted the rs_routes entry and rebooted the RS and it went away:



Bad entry that needs to be fixed:

31 SQM Awaiting Message 102:1 repit1501i.repit1510repb_RSSD

30 SQM Awaiting Message 102:0 repit1501i.repit1510repb_RSSD

33 REP AGENT Awaiting Command repit1501i.repit1510repb_RSSD

RSI USER Inactive 16777317

36 dSUB Sleeping

15 dCM Awaiting Message



What a good entry looks like:

30 SQM Awaiting Message 102:0 repit1501i.repit1510repb_RSSD

43 REP AGENT Awaiting Command repit1501i.repit1510repb_RSSD

45 RSI USER Active repit1510repa

35 dSUB Sleeping

15 dCM Awaiting Message



CR:549128
CR Number:   549128
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.6.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.02 25 Nov 2008 Fixed
5.5.24 02 Feb 2009 Fixed
5.8.00 08 Dec 2008 Fixed
Description
ORACLE ONLY: Replication Agent fails to correctly

process a rollback operation for off-row LOB

data.



CR:549145
CR Number:   549145
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Closed
OS:   Windows
Original Version:   closluce EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2008 Fixed
Description
EBF1



reproduce:

1.go to search after login

2.click at a model in the tree

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



CR:549164
CR Number:   549164
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Closed
OS:   Windows
Original Version:   Jove
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2008 Fixed
Description
Build 20081104



Steps:

1. Deactivate a user

2. In the user list, show the deactivate user

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



Result:

The Deactivate button change to enable status



CR:549166
CR Number:   549166
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Closed
OS:   Windows
Original Version:   closluce EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2008 Fixed
Description
Build 20081104



Steps:

1. Deactivate a user named "aa"

2. Select "Show deactivated members"

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

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

5. Click Save button



Result:

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



CR:549301
CR Number:   549301
Product Name:   Sybase Replication Server
Product Component:   RMA
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2009 Presently Not Targeted For Any Future Release Of This Product
Description
RMServices...delete rs_ticket_history too slow...Failed to get heartbeat tickets



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



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

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

2> go

Msg 32000, Level 20, State 0:

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

Failed to get heartbeat tickets.

1> quit



CR:549343
CR Number:   549343
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.1.0.5605P1b-ONE_OFF
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.01 06 Nov 2008 Fixed
5.8.00 06 Nov 2008 Fixed
5.7.01 14 Nov 2008 Fixed
5.8.00 17 Nov 2008 Fixed
5.7.01 09 Nov 2010 Fixed
Description
MICROSOFT SQL SERVER ONLY:

"java.lang.IndexOutOfBoundsException" error sends

Replication Agent to ADMIN state during

replication.



CR:549366
CR Number:   549366
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.8.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Nov 2008 Fixed
03 Feb 2009 Fixed
Description
ORACLE ONLY: If a table has off-row LOBs and

a table trunction is executed followed by a LOB

operation, Replication Agent encounters a LobObjectID

mismatch error.



CR:549373
CR Number:   549373
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.7.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.01 26 Nov 2008 Fixed
5.8.00 30 Nov 2008 Fixed
5.7.02 11 Dec 2008 Fixed
5.8.00 11 Dec 2008 Fixed
5.7.01 15 Dec 2008 Fixed
Description
ORACLE ASM ONLY: Errors like 'Byte buffer

remainder is too small' and 'BufferUnderflow-

Exception' occur randomly when Replica-

tion Agent is resumed.



CR:549418
CR Number:   549418
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Sep 2011 Duplicate
Description
Customer request the subcription name (column "subname" in RepServer system table "rs_subscriptions") to be enhanced up to 255 byte, like Replication Definition name could be define.



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

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



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



CR:549542
CR Number:   549542
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   5.7.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.01 07 Nov 2008 Fixed
5.8.00 07 Nov 2008 Fixed
Description
MICROSOFT SQL SERVER ONLY: ra_helparticle command

fails with an error "Could not list article

metadata because:

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



CR:549558
CR Number:   549558
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Open
OS:   Windows
Original Version:   closluce EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2008 Presently Not Targeted For Any Future Release Of This Product
Description
Build 1107



To reproduce:

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

It should be deal with specially for the special object.



Attached the EAM.



CR:549774
CR Number:   549774
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2008 Fixed
08 Dec 2008 Fixed
07 Dec 2008 Not a Bug
Description
ASE ONLY: Mirror RepAgent does not verify the

value of configuration parameter

pds_interfaces_file.



CR:549788
CR Number:   549788
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.5.19
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 2008 Fixed
Description
ORACLE ONLY: Provide separate statistics to

monitor Oracle online and archive log device read

status.



Online log statistics:

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

2.Total online log read time (ms)

3.Current blocks per device read(online log)



Archive log statistics:

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

2.Total archive log read time (ms)

3.Current blocks per device read(archive log)



CR:549859
CR Number:   549859
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   5.7.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2008 Fixed
01 Dec 2008 Fixed
08 Jan 2009 Presently Not Targeted For Any Future Release Of This Product
Description
MICROSOFT SQL SERVER ONLY: pdb_setrepproc

command with the 'all, enable' option is not

supported and should return an error message.



CR:549908
CR Number:   549908
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.5.19
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.20 13 Nov 2008 Fixed
5.7.02 04 Dec 2008 Fixed
5.8.00 04 Dec 2008 Fixed
Description
ORACLE ONLY: The underlying tables (MLOG$_xxx)

for materialized view are incorrectly marked

during initialization with pdb_automark_tables

property setting to true.
Workaround Description
 For example:



create table zp_test (col1 int primary key, col2 varchar(10));

CREATE MATERIALIZED VIEW LOG ON zp_test;





with Ruanwei's help , we found that we can query the mlog$ table to filter the MLOG$_xxx table.



SQL> select mowner,master,log from mlog$;



MOWNER MASTER LOG

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

RA_USER ZP_TEST MLOG$_ZP_TEST



so the workaround is querying the mlog$ system table, In "LOG" column you can found the table name for those "MLOG$_xxx",

then you can unmark those tables one by one.



For above case, you got a table named "MLOG$_ZP_TEST"

then you can use the following to unmark the table in our RepAgent:



pdb_setreptable MLOG$_ZP_TEST,unmark,force



CR:549979
CR Number:   549979
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   Windows XP
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2008 Fixed
19 Nov 2008 Fixed
19 Nov 2008 Fixed
Description
Tested and reproduced with: PD 12.5 ESD#15 and PD 15.0 ESD#1



This is an issue from UNIBANCO toptier customer.



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



CR:550000
CR Number:   550000
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.5.17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2008 Fixed
25 Feb 2009 Fixed
04 Mar 2009 Fixed
11 Mar 2009 Fixed
Description
ORACLE ONLY: A supplemental data column with an

index that duplicates another data column during

operation processing stops replication.



CR:550178
CR Number:   550178
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   5.7.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2008 Fixed
07 Dec 2008 Fixed
5.5.23 07 Jan 2009 Fixed
Description
"rasd_restore" command fails when followed

by a "rasd_backup" operation.



CR:550302
CR Number:   550302
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.5.17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.19 14 Nov 2008 Fixed
5.7.02 14 Jan 2009 Fixed
5.8.00 30 Jan 2009 Fixed
Description
ORACLE ONLY: Truncate table replication failure

results in replicate database constraint

violation.



CR:550354
CR Number:   550354
Product Name:   Common Metadata Repository
Product Component:   Installation
Status:   Closed
OS:   Windows
Original Version:   closluce EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2008 Fixed
Description
build EBF1



To reproduce:

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

And can't show data in web browser.

We need to support SQL Server 2000.



CR:550822
CR Number:   550822
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Open
OS:   NA
Original Version:   12.6.12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Include documentation to bind RA DB2 DBRM as a package.
Workaround Description
 Here is the parameter listing from David Wilcox's bind of package:



READY

DSN SYSTEM(DB0T)

DSN

BIND PACKAGE(LEDBW150) ACT(REPLACE) MEMBER(LTMINFO) ENCODING(EBCDIC) EXPLAIN(NO) DEGREE(ANY) ISOLATION(CS) VALIDATE(BIND)

DSNT254I -DB1T DSNTBCM2 BIND OPTIONS FOR

PACKAGE =

DSNDB0T.LEDBW150.LTMINFO.(2008-08-13-17.42.59.809854)

ACTION ADD

OWNER DWILCOX

QUALIFIER DWILCOX

VALIDATE BIND

EXPLAIN NO

ISOLATION CS

RELEASE

COPY

DSNT255I -DB1T DSNTBCM2 BIND OPTIONS FOR

PACKAGE =

DSNDB0T.LEDBW150.LTMINFO.(2008-08-13-17.42.59.809854)

SQLERROR NOPACKAGE

CURRENTDATA YES

DEGREE ANY

DYNAMICRULES

DEFER

NOREOPT VARS

KEEPDYNAMIC NO

IMMEDWRITE NO

DBPROTOCOL DRDA

OPTHINT

ENCODING EBCDIC(05035)

PATH

DSNT232I -DB1T SUCCESSFUL BIND FOR

PACKAGE =

DSNDB0T.LEDBW150.LTMINFO.(2008-08-13-17.42.59.809854)

DSN

END



CR:550868
CR Number:   550868
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Management
Status:   Open
OS:   Generic
Original Version:   15.1.0.5607P2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Option to place trace logs in a different directory than system logs.
Workaround Description
 The parameter log_directory states where the log files will go. This includes all log files, including trace files.



CR:550897
CR Number:   550897
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   5.6.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2009 Fixed
12 Feb 2009 Duplicate
5.7.02 09 Dec 2008 Fixed
5.8.00 09 Dec 2008 Fixed
5.7.02 08 Jan 2009 Fixed
5.8.00 08 Jan 2009 Fixed
Description
MICROSOFT SQL SERVER ONLY: Add trace

functionality in the sybfilter driver. When an

error occurs, the error is logged to an

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

is enabled, the trace information will be logged

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

will reside in the same directory where the

configuration file is located.



There are four level of trace info which can be

configured by users in sybfiltermgr. The default

setting is to output the error message only.



trace

Turn on or off sybfilter trace



Syntax



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



Default



T4 - Log error messages



Parameters



T1 Logs driver routine entrance and

return messages

T2 Logs operation status information

T3 Logs normal message such as an

exclusive open file operations

T4 Log error messages

all Logs T1, T2, T3 and T4 level messages

off Turns off tracing





Example:



To turn on T3 trace:

trace T3



To turn on T1 and T3 trace:

trace T1 T3



To turn off trace

trace off



To display help on trace command:

help trace



CR:551006
CR Number:   551006
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.5.19
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2008 Fixed
25 Nov 2008 Fixed
25 Nov 2008 Fixed
Description
ORACLE ONLY: Replication fails in Replication

Server with "error ORA-00900: invalid SQL

statement" due to an attempt to replicate only

the second half of a DDL command.
Workaround Description
 Corrupt transaction in Rep Server must be skipped at DSI.



CR:551023
CR Number:   551023
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.7.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2008 Fixed
Description
ORACLE ONLY: Correct Log Reader scanner statistic

description from 'Average number of checkpoints

per records read' to be 'Average number of log

records per checkpoint'.



CR:551025
CR Number:   551025
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.6.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.01 20 Nov 2008 Fixed
Description
ORACLE ONLY:

Rep Agent dies with 'Invalid block id'

when log scanner tries to position.



CR:551032
CR Number:   551032
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   5.6.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.02 26 Nov 2008 Fixed
5.8.00 26 Nov 2008 Fixed
Description
MICROSOFT SQL SERVER ONLY: Replication Agent de-initialization

and then re-initialization do not refresh the user articles

information stored in the Replication Agent System Database

repository.



CR:551192
CR Number:   551192
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Closed
OS:   RH Linux
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2009 Fixed
Description
The 'rs_init' executable shipped with

IBMPLINUX64 RS 1510 GA incorrectly

allows the user to optionally configure

the Replication Server with an embedded

RSSD (ERSSD). The 'rs_init' executable

should disallow this option since an

ERSSD requires SQL Anywhere and SQL

Anywhere is not available on

IBMPLINUX64.



CR:551336
CR Number:   551336
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.7.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.01 25 Nov 2008 Fixed
5.8.00 25 Nov 2008 Fixed
5.7.10 26 Nov 2008 Fixed
5.5.19 26 Nov 2008 Fixed
Description
ORACLE ONLY: Replication Agent does not

generate a replication definition

after re-setting the pdb_auto_create_repdefs

configuration property to 'true'.
Workaround Description
 unmark table, then mark it manually, the auto_created repdef is created.



CR:551457
CR Number:   551457
Product Name:   Sybase Replication Server
Product Component:   RMA
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Oct 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Generate RCL for subscription fails when using eRSSD.



CR:551499
CR Number:   551499
Product Name:   Mirror Replication Agent
Product Component:   MRAgent/ASE
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0.0.5512P6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.19 01 Dec 2008 Fixed
5.5.21 03 Dec 2008 Fixed
5.7.02 03 Dec 2008 Fixed
5.8.00 03 Dec 2008 Fixed
Description
ASE ONLY: Replication Server primary connection

duplicate count increases and the replicate

connection DSI goes down with error 5147 because

parallel transactions with affected LOBs result

in the wrong locator getting sent by Replication

Agent for some operations.



CR:551706
CR Number:   551706
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Open
OS:   Generic
Original Version:   5.7.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2009 Fixed
06 Mar 2009 Fixed
5.8.00
Description
MICROSOFT SQL SERVER ONLY: When maintenance user

is 'sa', Replication Agent goes into ADMIN state

with UserNotFoundException error.



CR:551788
CR Number:   551788
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.7.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.15 19 May 2009 Fixed
5.8.00 26 Feb 2009 Fixed
Description
ORACLE ONLY: Stored procedure can not be marked if

the parameter name in the stored prcoedure

contains Oracle reserved words.



CR:551794
CR Number:   551794
Product Name:   Common Metadata Repository
Product Component:   Others
Status:   Closed
OS:   Windows
Original Version:   closluce
Fixed Version Build Resolution Date Closure Code (If Appropriate)
lelude 12 Jun 2010 Fixed
Description
PowerDesigner Repository Web Browser

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



CR:552175
CR Number:   552175
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jul 2009 Fixed
03 Sep 2009 Fixed
03 Sep 2009 Fixed
02 Oct 2009 Fixed
08 Dec 2009 Fixed
Description
Performance issue when Replication Server starts up and "rs_subscriptions" contains many rows
Workaround Description
 Create following indexes on "rs_subscriptions" RS system table help Customer to improve starting time:



create index rs_subind1 on rs_subscriptions (pdbid)

go

create index rs_subind3 on rs_subscriptions (objid)

go



CR:552242
CR Number:   552242
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.7.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.8.00 07 Dec 2008 Fixed
5.7.10 07 Dec 2008 Fixed
Description
ORACLE ONLY: Replication Agent will hang on a

create cluster table DDL operation.
Workaround Description
 If created a normal table(not partitioned table), this case can PASS:

create table qaf_range (pkey number primary key, date_col date, timestamp_col timestamp, varchar_col varchar(30), blob_col blob,

clob_col clob)



CR:552274
CR Number:   552274
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   tyresias
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Shouldn't possible for consolidate / integrate to choose a version in a branch due

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



CR:552300
CR Number:   552300
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2009 Fixed
13 Apr 2009 Fixed
12 Apr 2009 Fixed
Description
Set the CNT_NO_RESET bit on for CNT_DSIE_DSQL_STMTS_IN_CACHE_C, so that the associated counter is not reset at the beginning of each observation period.



CR:552399
CR Number:   552399
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   5.7.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 2008 Fixed
5.5.23 07 Jan 2009 Fixed
18 Dec 2008 Fixed
17 Dec 2008 Presently Not Targeted For Any Future Release Of This Product
Description
The "ra_config rasd_tran_log, <new_rasd_log_path>"

command will fail with error message "The database

transaction log file move failed because: Could

not move file <src_file_location> to

<target_file_location>".



CR:552588
CR Number:   552588
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   Windows XP
Original Version:   closluce
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Dec 2008 Workaround
18 Mar 2009 Fixed
19 May 2009 Fixed
Description
All users are unable to connect to repository after upgrading from v12.1.0 EBF10 to v15 EBF1.



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



Invalid repository user or password!



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



CR:552626
CR Number:   552626
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.7.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2008 Bundled Request
Description
ASE ONLY: pdb_setreptable command

shows an incorrect error message when

an invalid owner string is passed in.



CR:552670
CR Number:   552670
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.0.0.5517P8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2009 Fixed
19 Dec 2008 Fixed
02 Feb 2009 Fixed
Description
ORACLE ONLY: A stored procedure marked for

replication that executes with error returns

corrupt error stack.



CR:552673
CR Number:   552673
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.0.0.5517P8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.23 06 Jan 2009 Fixed
5.7.02 31 Jan 2009 Fixed
5.8.00 27 Jan 2009 Fixed
Description
ORACLE ONLY: If a stored procedure is marked for

replication and the stored procedure contains a

truncate table command, both the truncate

command and stored procedure execution are

replicated.



CR:552674
CR Number:   552674
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.0.0.5517P8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2010 Fixed
29 Dec 2008 Fixed
25 Feb 2009 Fixed
Description
ORACLE ONLY: If a stored procedure that is marked

for replication fails at the primary database,

no message is logged indicating the procedure

will still be executed at the replicate database.



CR:552784
CR Number:   552784
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Open
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Output from logtrace=yes goes to SYSPRINT.



CR:552793
CR Number:   552793
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.0.0.5517P8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2009 Fixed
29 Dec 2008 Fixed
02 Feb 2009 Fixed
Description
ORACLE ONLY: A DDL command executed within

a stored procedure that is not marked for

replication is ignored by Replication Agent.



CR:552798
CR Number:   552798
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.0.0.5517P8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.23 06 Jan 2009 Fixed
5.7.02 07 Jan 2009 Fixed
17 Mar 2009 Fixed
Description
ORACLE ONLY: Attempting to replicate a stored

procedure that has an OUTPUT parameter results in

an error in the Replication Server DSI thread

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

arguments in call to 'MY_PROC'.
Workaround Description
 In order to successfully replicate to an Oracle stored procedure that expects an OUTPUT argument, you must create a custom function string in Replication Server to provide the needed OUTPUT argument(s). The custom function string must declare any needed output variables, in addition to the normal input parameters. Using the output language form for a custom function string, declare the needed output variables.

A simple example:



CREATE PROCEDURE INANDOUT (p_IN IN integer, p_OUT OUT CHAR, p_IN2 IN integer )



will require custom function string language:



'DECLARE p_out CHAR(1000);; BEGIN INANDOUT(?p_in!param?,p_out,?p_in2!param?);; END;;'



Please refer to the Replication Server documentation for more details

on creating custom function strings.



CR:552804
CR Number:   552804
Product Name:   Sybase Replication Server
Product Component:   InstallShield
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RepSever can't uninstall products after install EBF.
Workaround Description
 1. "%SYBASE%" of all files are deleted manually.

2. The following keys are deleted from a windows registry.



[HKEY_LOCAL_MACHINE\SOFTWARE\SYBASE\Replication Server]

[HKEY_LOCAL_MACHINE\SOFTWARE\SYBASE\Server\xxxxxx]

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SYBREP_xxxxxx]



"xxxxxx" is user server name.



3. Uninstaller of RepServer is started from a control panel.

Windows will delete uninstaller of RepServer from a system.



4. "REP-12_6" is deleted from a system environment variable. And REP-12_6 is deleted from PATH.



CR:552820
CR Number:   552820
Product Name:   Sybase Replication Server
Product Component:   InstallShield
Status:   Open
OS:   Microsoft Windows NT
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2010 Fixed
Description
uninstaller of Sybase does not delete all files. Moreover, uninstaller is not removed from a control panel, either. This is specification.
Workaround Description
 1. All files are deleted manually.

2. uninstaler of RepServer is performed from a control panel.



Windows will remove uninstaller from a system.



CR:552868
CR Number:   552868
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   closluce
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide option to save repository creation/update script from within the 'generation script' window.



CR:552894
CR Number:   552894
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#3 15 16 Jan 2009 Fixed
Description
LTMCFG requires RSSD parameters when Use_repdefs = N
Workaround Description
 Uncomment out the RSSD parameters. The parameters can have bogus values as it is not checked if Use_repdefs = N.



CR:553088
CR Number:   553088
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   closluce
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In a repository, if you right click on a folder and select Add, the model is not added to the folder if you select the model currently in the Browser. The model will be added to the root of the repository



To reproduce:



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

2) create a folder in the repository (folder_1)

3) right-click on folder_1 and select Add

4) browse to and select test.pdm

5) click open

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

6) Click NO to the dialog

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

7) cancel

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

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



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



CR:553104
CR Number:   553104
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RS 15.x crashes when dbisql is used against it.
Workaround Description
 set property USE_METADATA=false



however, if this setting is used on ASE connction, the setting will prevent the initial sp_mda call



so now CT decided not use IISQL for now. just use OCS isql to connect to their RS.



CR:553173
CR Number:   553173
Product Name:   Mirror Replication Agent
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.7.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2008 Fixed
14 Dec 2008 Fixed
Description
ASE ONLY: Instance fails to start up

when pds_interfaces_file is set to

<not_configured> in the instance

configuration file.



CR:553578
CR Number:   553578
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2008 Duplicate
06 Jun 2009 Fixed
Description
Synchronization issue between SQM write thread and ROUTE thread. RS fails due to a synchronization problem between SQM wirte thread and ROUTE thread, SQM thread uses a shared variable without locks and it would be set to NULL in the ROUTE thread when SQM thread was using it. Accessing a NULL value lead to the failure.



CR:553588
CR Number:   553588
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Admin
Status:   Closed
OS:   Generic
Original Version:   5.7.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.02 17 Dec 2008 Fixed
5.8.00 17 Dec 2008 Fixed
Description
rs_ticket command fails with "The date time

string is invalid." error message.



CR:553601
CR Number:   553601
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   5.7.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.8.00 11 Feb 2009 Fixed
12 Feb 2009 Fixed
5.5.24 11 Feb 2009 Fixed
Description
ASE ONLY: pdb_auto_create_repdefs create repdefs

for a table if the table is created before

executing 'ra_init'.



CR:553628
CR Number:   553628
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2009 Fixed
12 Feb 2009 Fixed
01 Apr 2009 Fixed
04 Aug 2009 Fixed
Description
When adding a raw device partition, there is confusing message like 'asynchronous I/O request completed with an error' in Replication Server log.



CR:553676
CR Number:   553676
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   closluce
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
With the new CMR there must be an API (which should be documented) to be able to read informations from the Repsoitory via Java or .Net



CR:553784
CR Number:   553784
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jan 2009 Fixed
16 Jun 2009 Fixed
09 Jun 2009 Fixed
16 Oct 2009 Fixed
Description
Dynamic SQL optimizaton, if DSQL is turned on language commands are not packed assuming DSQL will be successful. If the DSQL statements fail only then are the language cmds generated. Similarly for generation of prepared statements, the are only generated when required.



CR:553785
CR Number:   553785
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jan 2009 Fixed
16 Jun 2009 Fixed
28 Apr 2009 Fixed
Description
When minimal columns is turned on, columns not changed are not available in the DSI. DSQL will not be used and the counter DSINoDsqlMissingCols shows the number of times DSQL is skipped. In Repserver 15.3, RS will allow multiple DSQL statements corresponding to the same table, and the number of DSQL statements depend on the update set clause pattern.



CR:553933
CR Number:   553933
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   5.5.17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.23 13 Jan 2009 Fixed
5.7.10 21 Jan 2009 Fixed
5.8.00 05 Mar 2009 Fixed
Description
ORACLE ONLY: Underlying tables for a materialized

view are incorrectly replicated.
Workaround Description
 For example:



create table zp_test (col1 int primary key, col2 varchar(10));

CREATE MATERIALIZED VIEW LOG ON zp_test;





with Ruanwei's help , we found that we can query the mlog$ table to filter the MLOG$_xxx table.



SQL> select mowner,master,log from mlog$;



MOWNER MASTER LOG

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

RA_USER ZP_TEST MLOG$_ZP_TEST



so the workaround is querying the mlog$ system table, In "LOG" column you can found the table name for those "MLOG$_xxx",

then you can unmark those tables one by one.



For above case, you got a table named "MLOG$_ZP_TEST"

then you can use the following to unmark the table in our RepAgent:



pdb_setreptable MLOG$_ZP_TEST,unmark,force





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

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