提供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:629295
CR Number:   629295
Product Name:   Sybase Replication Server
Product Component:   InstallAnywhere
Status:   Open
OS:   Solaris
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If the user's home directory is not writable by the user, the GUI

installation will report in the file '${SYBASE}/log/RepServer_Suite.log'

a runtime exception in 'com.sybase.ia.common.SybaseDestination'.
Workaround Description
 Choose one ...



(1) Ensure user's home directory is writable by the user.



(2) Ignore the message. The software directories are fine.



CR:629537
CR Number:   629537
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2010 Fixed
Description
Migrated 12.5 model to 15.2 can checked in into reprository but can't checked out anymore.



CR:629564
CR Number:   629564
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Open
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Ability to use multiple license keys and License_Key parameter is not documented



CR:629821
CR Number:   629821
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2010 Fixed
Description
Change the default value of 'sqm_seg_prealloc' from 'on' to 'off' to avoid potential Replication Server System Database rs_segments table corruption.



CR:630421
CR Number:   630421
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jun 2010 Fixed
Description
Row check validation configuration should default to pre-15.2 behavior
Workaround Description
 None, only way to change default behavior is:



Update the RSSD manually --OR-- create a replication server error class



CR:630422
CR Number:   630422
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
dsi_command_convert does not seem to prevent duplicate key violations
Workaround Description
 None



CR:630424
CR Number:   630424
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2010 Fixed
16 Jul 2010 Fixed
Description
RTL retry mechanism severely impacts replication performance.



CR:631494
CR Number:   631494
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Optional clauses in create and define subscription to specify userids and passwords if different from what is used for logging into RS.
Workaround Description
 None



CR:631652
CR Number:   631652
Product Name:   Sybase Replication Server
Product Component:   rs_subcmp
Status:   Closed
OS:   NA
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 08 May 2012 Fixed
Description
DDLGENLOC needs name of the executable.
Workaround Description
 Set DDLGENLOC to include the ddlgen executable, e.g.

setenv DDLGENLOC /remote/releases/solaris/rel1503/ASEP/bin/ddlgen



CR:631664
CR Number:   631664
Product Name:   Sybase Replication Server
Product Component:   rs_subcmp
Status:   Open
OS:   Solaris
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
rs_subcmp needs a configuration file for schema comparison.
Workaround Description
 Add a configuration file and execute with it:



Sample configuration file (rs_subcmp.cfg):

PDS = sunak1503x

RDS = sunak1503x

PDB = p1

RDB = r1

PUSER = sa

RUSER = sa

PPWD =

RPWD =

SCHEMAFLAG = 1



(optionally can only compare one table with the PTABLE and RTABLE parameters)





Then run: rs_subcmp -f rs_subcmp.cfg



CR:631691
CR Number:   631691
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 09 29 Jul 2010 Fixed
Description
Rep Agent ends occasionally because of non ascending QIDs



CR:631941
CR Number:   631941
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.2 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Maintenance user password cannot be 30 characters.
Workaround Description
 passwords must be 29 characters or less.



CR:631959
CR Number:   631959
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.2 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
5049 does not have correct command number that is a transaction that uses bulk insert
Workaround Description
 Apply as language events (turn off bulk insert)



CR:632052
CR Number:   632052
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer is requesting that PD use multiple (smaller) transactions instead of one long transaction when deleting document(s) from the repository.



Request:



improve the transactional aspect of the PD when deleting a version ie. break up the work into smaller transactions and keep track of the progress . This will ensure recovery or ability for PD to resume the delete of the version, if a failure occurs before the full logical delete of the version is complete



CR:632058
CR Number:   632058
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   5.5.30
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jun 2010 Fixed
Description
MICROSOFT SQL SERVER ONLY: Replication Agent

ra_dump command fails with exception: "Execution

failed because: <SQL execution failed.>" on

Microsoft SQL Server 2005.



CR:632428
CR Number:   632428
Product Name:   Rep Server Connectors
Product Component:   Oracle OCI Connector
Status:   Closed
OS:   Generic
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2011 Presently Not Targeted For Any Future Release Of This Product
Description
Provide ability to use replication server gateway to query Oracle when ECO is used to replicate to Oracle.
Workaround Description
 Use ECDA for Oracle instead of ECO



CR:632461
CR Number:   632461
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RepServer incorrectly reports mis-matched sort order with 'utf8'/'nocase'
Workaround Description
 (1) Copy the file ...



$SYBASE/charsets/utf8/nocase.srt



... to ...



$SYBASE/charsets/utf8/utf8_nocase.srt



... and specify the sort order in the RS configuration file as ...



RS_sortorder=utf8_nocase



(2) Edit the file ...



$SYBASE/config/objectid.dat



... and modify the line ...



1.3.6.1.4.1.897.4.9.3.52 = nocase



... to ...



1.3.6.1.4.1.897.4.9.3.52 = nocase, utf8_nocase



CR:632503
CR Number:   632503
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Repository Enhancement Request:

Currently, the Repository Metamodel provides user and group information in a way that



- the user contains information about

- which group it is in

- which permission he has



- the group contains information about

- which users are member of it

- which groups it belongs to (parent group)

- which permissions it has



Customer would like to have another information added to the metamodel:



- a user or a group can be marked as functionally responsible for maintaining specific repository folders



CR:632697
CR Number:   632697
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.8.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jul 2010 Fixed
27 Jun 2010 Fixed
23 Dec 2010 Fixed
Description
ORACLE ONLY: Replication Agent generates duplicate

OQIDs for a commit operation when there are

rollback operations and LOB updates in the

transaction.



CR:633137
CR Number:   633137
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 2010 Fixed
Description
RepServer core dumps during restart after setting mem_reduce_malloc to 'on'
Workaround Description
 update rs_config set charvalue = 'off' where optionname = "mem_reduce_malloc"



CR:633141
CR Number:   633141
Product Name:   Real Time Data Services - RepConnector
Product Component:   RepConnector Base Product
Status:   Open
OS:   Generic
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request: Use broker connection services for RepConnector



CR:633154
CR Number:   633154
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.2 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD #2 14 Jul 2010 Fixed
Description
Warmstandby - the inbound queue for a logical connection (with no other replicate dbs) does not drain after dropping the connection to the standby.



CR:633179
CR Number:   633179
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Microsoft Windows
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
10 Oct 2010 Added to user documentation
Description
SySAM license installation grace is not provided on Windows.
Workaround Description
 If you are evaluating the product then you will need to request an evaluation license from Sybase. Otherwise, you need to generate your licenses at SPDC and deploy them.



CR:633195
CR Number:   633195
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   5.7.15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.7.16 04 Jul 2010 Fixed
19 Jul 2013 EOL'd version. Not to be Fixed.
19 Jul 2013 Insufficient priority to fix
15.7.1 ESD #3 26 Feb 2013 Fixed
Description
MICROSOFT SQL SERVER ONLY: Log truncation failed

with error message likes 'Error occurred

obtaining LCT lsn with message {0}' when

trying to truncate the log.
Workaround Description
 1. update the locator (ra_locator update)

2. suspend replication

3. drop and re-create the xlog_ra_lct_sql_proc in the primary database (see below)

4. resume replication

5. verify that truncation occurs as expected





Step 3 - To drop and re-create the xlog_ra_lct_sql_proc:



- Execute ra_admin to get the physical name of the xlog_ra_lct_sql_proc component.



For example:



1> ra_admin

2> go

Component Name

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

database_name raxdevms8m2h

xlog_rs_markersh_table dbo.ra_markersh_

xlog_rs_marker_proc dbo.rs_marker

xlog_rs_dumpsh_table dbo.ra_dumpsh_

xlog_rs_dump_proc dbo.rs_dump

xlog_ra_lct_sql_proc dbo.ra_lct_sql_

xlog_ra_check_object_proc dbo.ra_check_

xlog_ra_mark_object_proc dbo.ra_mark_

xlog_ra_chek_object_table dbo.ra_checkObject_

xlog_ra_mark_object_table dbo.ra_markObject_

xlog_ra_ddl_trigger_table dbo.ra_ddl_trig_

xlog_ra_ddltrig ra_ddl_trig_

xlog_ra_createtable_trigger_ddltrig ra_createtable_trig_



From the ra_admin results, we see the following mapping in my environment:



Logical Name Physical Name

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

xlog_ra_lct_sql_proc dbo.ra_lct_sql_



- Replace the logical procedure name (xlog_ra_lct_sql_proc) in the drop/create procedure commands below

with the physical name from your ra_admin results and execute the commands in the primary MSSQL database:



DROP PROCEDURE xlog_ra_lct_sql_proc

go



CREATE PROCEDURE xlog_ra_lct_sql_proc

@lctPageID int

,@lctOperationNO int



AS

SET NOCOUNT ON

BEGIN

DECLARE @id int

DECLARE @fileNO int

DECLARE @pageID int

DECLARE @operationNO smallint

DECLARE @hit bit

DECLARE @repltrans TABLE (

id int identity (1,1),

xactid varbinary(16),

xact_seqno varbinary(16)

)

DECLARE @result TABLE (id int, fileNo int, pageID int, operationNo smallint)

INSERT INTO @repltrans EXEC sp_repltrans;

DECLARE rowcursor CURSOR SCROLL FOR SELECT id, cast(substring(xact_seqno,1,4) as int) as fileNO, cast(substring(xact_seqno,5,4) as int) as pageID, cast(substring(xact_seqno,9,2) as smallint) as operationNO FROM @repltrans ORDER BY fileNO, pageID, operationNO;

OPEN rowcursor;

FETCH NEXT FROM rowcursor INTO @id, @fileNO, @pageID, @operationNO

WHILE @@FETCH_STATUS = 0

BEGIN

IF (@pageID=@lctPageID and @operationNO = @lctOperationNO)

BEGIN

SET @hit = 1;

FETCH PRIOR FROM rowcursor

INTO @id, @fileNO, @pageID, @operationNO

BREAK;

END

ELSE

BEGIN

FETCH NEXT FROM rowcursor

INTO @id, @fileNO, @pageID, @operationNO

END

END

CLOSE rowcursor;

DEALLOCATE rowcursor

IF(@hit=1)

BEGIN

SELECT @id, @fileNO, @pageID, @operationNO;

END

SELECT * FROM @result;

END



GO



CR:633273
CR Number:   633273
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 14 11 Oct 2010 Fixed
Description
0C4 at OFFSET=0000110E in LTMPACKR



CR:633274
CR Number:   633274
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.2 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2012 Presently Not Targeted For Any Future Release Of This Product
Description
alter function replication definition does not work if sts_full_cache_rs_objects is 'on'



CR:633508
CR Number:   633508
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 12 11 Oct 2010 Fixed
Description
Invalid decimal or invalid null indicator in logtrace=yes and no indication of problem in LTMLOG or JESMSGLG
Workaround Description
 Whenever do an alter table, always reorg the table to fill in the default values on old records.



CR:633669
CR Number:   633669
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   15.2.0.5810P2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RAO 15.2 log record ... was not correctly sorted ... then NullPointerException
Workaround Description
 see workaround in CR 635492



CR:633735
CR Number:   633735
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When working with the PowerDesigner repository, the lowest granularity level

you can interact with the repository is the package.

Customer would like to lower this granularity down to object level

so that e.g. individual tables can be checked in and out.



CR:633746
CR Number:   633746
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jan 2012 Fixed
Description
Versions are not ordered in numeric order in the version dropdown list box of the "check out documents" dialog.



CR:633920
CR Number:   633920
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Capability to drop connection when connection to server or database cannot be made.



CR:633921
CR Number:   633921
Product Name:   Rep Server Tests
Product Component:   Rep Server Tests
Status:   Open
OS:   Unknown
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Create tests to 30 character userids and passwords



CR:634016
CR Number:   634016
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer have an OpenServer as a target Server which does not manage "sp_mda" RPC call.



Since RepServer 15.5, O/C connection property "CS_PARTIAL_TEXT" is set in order to determine if target Server will manage partial text update.



Customer would like a new RepServer's Connection parameter in order to specify whether or not to set this O/C connection property.



CR:634059
CR Number:   634059
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.5.30
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2010 Fixed
Description
ORACLE ONLY: Replication Agent fails to replicate

execution of a stored procedure if the stored

procedure is altered to add a new parameter.



CR:634062
CR Number:   634062
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 2010 Fixed
Description
ORACLE ONLY: Replication Agent ra_truncatearticles

command fails with a NullPointerException causing

an incomplete error message "<ra_truncatearticles>

failed - Could not truncate article repository

because: null" to be returned.



CR:634076
CR Number:   634076
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
If RepServer is killed while skip trans is partially written to exceptions log, upon startup the transaction is still skipped and next transaction is applied



CR:634151
CR Number:   634151
Product Name:   Sybase Replication Server
Product Component:   rs_subcmp
Status:   Closed
OS:   Linux
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jul 2010 Fixed
19 Jul 2010 Fixed
01 Aug 2010 Fixed
01 Aug 2010 Fixed
17 Nov 2010 Fixed
Description
rs_subcmp generates duplicated columns in the query command when FASTCMP=y and using multiple KEY columns.



CR:634222
CR Number:   634222
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.6 11 Aug 2010 Fixed
16 Aug 2010 Fixed
Description
After the Replication Server is upgraded from pre-15.5 to 15.5, the warning #32020 "Table 'xxxx' is not defined." messages may be logged in the error log file and rows are not replicated if the Replication Server ID is greater than 16842751.
Workaround Description
 No reasonable workaround.



CR:634284
CR Number:   634284
Product Name:   Sybase Replication Server
Product Component:   rs_subcmp
Status:   Closed
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jul 2010 Duplicate
Description
"rs_subcmp" 15.5 fail to rebuild "Select" statement when using FASTCMP option.



When option FASTCMP is set to true, "rs_subcmp" rebuilt "PSELECT"/"RSELECT" statement to include hash function call.



To do so, "rs_subcmp" rebuild a list of columns which are not primary key to be passed to the hash function.

Doing so, current column name is compare in a loop with the list of primary key column name.

When column name match, the current column is added to a key column list, but the loop is not ended.

When it does not match, the current column name is added to the hash list column as many time as there is some primary key column, where this "add" must be done only once per column name.



This cause non-key column to be present in duplicate (as many time as there is primary key columns) in the column list used for hash function, and when number of columns (or number of key-column) is to high, "Select" statement fail when it is send to ASE:



Message from server: Message: 3626, State 1, Severity 17 -- 'The transaction was aborted because it used too much stack space. Either use sp_configure to increase the stack size, or break the query into smaller pieces. spid: %d, suid: %d, hostname: %.*s, application name: %.*s'. [c/subcmp.c(2891)]



CR:634361
CR Number:   634361
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 16 11 Oct 2010 Fixed
Description
Origin time is not accurate between 10 pm to midnight.
Workaround Description
 None



CR:634374
CR Number:   634374
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   15.2 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jul 2010 Fixed
13 Jul 2010 Fixed
08 Sep 2010 Presently Not Targeted For Any Future Release Of This Product
03 Nov 2010 Fixed
02 Nov 2010 Fixed
28 Nov 2010 Fixed
Description
ASE ONLY:Replication Agent fails with

error message "Can not find relative operation

locator of CLR" when there are nested rollback

to savepoint in transaction and not all the

tables in the transaction are to be replicated.



CR:634455
CR Number:   634455
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Currently, a user is only allowd to grant user-rights on:

- The repository root: these permissions apply to the entire contents of the repository.

- Folders: these permissions apply to the contents of the folder.

- Documents: both PowerDesigner models and external application files.

- Model Packages inside PowerDesigner models.



Customer would like to extend this to:

- any diagram

- any model object



CR:634543
CR Number:   634543
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.5.30
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5.30 08 Jul 2010 Fixed
Description
ORACLE ONLY: NullPointerException may occur when

Replication Agent log scan component stops

replication and exits abnormally.



CR:634568
CR Number:   634568
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
Add a new option for 'drop connection' to purge the stable queue



CR:634639
CR Number:   634639
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2011 Fixed
18 Jan 2011 Fixed
22 Dec 2010 Fixed
28 Jan 2011 Fixed
28 Jan 2011 Fixed
6.0.01 09 Feb 2011 Fixed
Description
ORACLE ONLY: BufferUnderflowException stops

replication during log scan processing.
Workaround Description
 just issue ... resume ... after logging into the RAO instance as administrator



CR:635126
CR Number:   635126
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.2 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The DSI thread may get a 247 error (Arithmetic overflow during implicit conversion of VARCHAR value 'mm/dd/yy hh:mi:ss:mmm' to a DATETIME field.)

and be suspended if you run rs_ticket procedure in a primary database on Japanese ASE.
Workaround Description
 (1) Set dateformat to "mdy" in the rs_ticket_report function string. You may also need to turn off "batch" parameter for the database connection to the replicate database.



(2) Create a stored procedure which sets dateformat to "mdy" and then inserts a row into rs_ticket_history. And change the rs_ticket_report function string to execute the stored procedure.



(3) Set dateformat to "mdy" in a login trigger for the maintenance user on the replicate database.



CR:635182
CR Number:   635182
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 15 11 Oct 2010 Fixed
Description
Memory leak
Workaround Description
 Stop and restart the RA DB2



CR:635234
CR Number:   635234
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   Generic
Original Version:   5.9.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2010 Fixed
12 Nov 2010 Fixed
Description
Quiesce may not always process to the

end of the log before suspending.



CR:635318
CR Number:   635318
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2010 Duplicate
Description
RAO 15.5 ... not replicating (or replicating very slowly)
Workaround Description
 see workaround in CR 635492



CR:635492
CR Number:   635492
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2011 Presently Not Targeted For Any Future Release Of This Product
15.6 20 Sep 2010 Fixed
15.6 21 Sep 2010 Fixed
Description
ORACLE ONLY: Replication Agent behavior is

inconsistent when reading from linux block

devices. Potential manifestations are data loss

and instability.
Workaround Description
 root_cause 1) the low level disk mapping in the /proc/partitions file must match between

node1 and node2 ... there seemed to be some push back on this "required

item" on the customre side but each time PSE consulted with a certain

engineer, he reiterated this item is essential.



root_cause 2) since RAO is only able to read raw devices in linux presently, a raw device

"mapping" is created in linux so RAO is able to read the RAW device in the

linux OS which is mapped to the ASMLib BLOCKED devices to which oracle is

writing.



a raw device 'mapping' was created in linux to the ASMLib BLOCKED devices

to which oracle writes the redo / archive logs



the steps:



1. Map a raw device (or devices) and create a new diskgroup(s) in ASM that

references the raw devices.

2. Reconfigure the Oracle online redo log groups to use the new ASM

diskgroup that references the raw devices. The user must make sure that

the new group members are the last member in the group when sorted

alphabetically. For example

group 1:

redo01a.log

redo01b.log

In this example, redo01b.log should be in the new diskgroup that uses

raw devices.



Also, for simplicity, I used a group member alias in the example above

(redo01a.log, redo01b.log). However, we recommend that the user just

let ASM assign the default member name by only specifying the disk group

name when adding the redo log member.



3. Add an archive log destination that uses the new diskgroup(s) that

reference raw devices



4. Initialize RA and configure pdb_archive_path to point to the new archive

location, check ra_helpdevice results and start replicating.



Regarding ASM on raw block versus raw character devices, how can we tell if

a Oracle log under ASM control is a raw block versus a raw character

device? Is there a OS command or a Oracle command that would tell us this?



On linux, the OS will cache IO for a raw (aka character) device.

For a block device, it is left up to the user/application. The

problem at the customer site was specific to block devices.



Users will usually know whether block versus raw are used.

However, you can also tell via a simple "ls" on linux. If the

device is a block device, it will be represented with a "b." If

it is a raw (character) device, it will be a "c."



CR:635658
CR Number:   635658
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2010 Fixed
Description
RS 15.6 requires ECO 15.5 ESD #1



CR:635981
CR Number:   635981
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RAO 15.5 ... log scanner stopped because of error: java.lang.IllegalArgumentException



Log scanner <thread_1> reached end of active log <###>.

T. ... OracleLogScanne com.sybase.ds.oracle.log.OracleLogScanner Log scanner <thread_1> blocking on end of log.

E. ... ERROR com.sybase.ds.oracle.log.OracleInstanceLogSca Log scanner <thread_1> stopped because of error: java.lang.IllegalArgumentException
Workaround Description
 possibly the workaround in CR 635492 will resolve this CR 635981.



CR:636148
CR Number:   636148
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jul 2010 Fixed
5.8.20 02 Aug 2010 Fixed
Description
ORACLE ONLY: Information message "The configuraion

parameter rs_charset had been overridden with

rs_charset = {0} which obtained from the

replication server." does not display the

character set in the Replication Agent log.



CR:636178
CR Number:   636178
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Solaris
Original Version:   15.2.0.5810P2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Nov 2010 Fixed
26 Jul 2010 Fixed
27 Jul 2010 Fixed
25 Sep 2010 Fixed
Description
ORACLE ONLY: Replication Agent generates a delete

SQL statement when updating a column which has

NULL value to NULL.



CR:636245
CR Number:   636245
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   5.9.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2010 Fixed
13 Sep 2010 Fixed
Description
ORACLE ONLY: Replication Agent fails to read new

log data after the ASM disks are resized.
Workaround Description
 suspend

go

ra_updatedevices

go

resume

go



CR:636313
CR Number:   636313
Product Name:   Replication Management
Product Component:   Agent Plugins
Status:   Closed
OS:   Generic
Original Version:   3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2010 Fixed
30 Nov 2010 Fixed
Description
Replication latency history will not display for an ASE server without a primary connection.



CR:636671
CR Number:   636671
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.2 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
"Unable to get message '5173'. ((Intl-Lib error: Unknown error) Location: r/errfmt.c(556))" in dump transaction processing after resume connection skip tran.



CR:636861
CR Number:   636861
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Installation
Status:   Closed
OS:   Generic
Original Version:   5.9.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2010 Fixed
Description
Replication Agent displays a

SySAM warning message "Failed

to open the localised message file

'$SYBASE/locales/unicode/sylapi/

en_us/sylapi.lcu' when it attempts

to check out license.



CR:637176
CR Number:   637176
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)
17 May 2012 Fixed
Description
tns_alias_name and ora_sid_name explanations are incomplete.



CR:637196
CR Number:   637196
Product Name:   Rep Server Connectors
Product Component:   Oracle OCI Connector
Status:   Open
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Make server names on ECO case insensitive.



CR:637314
CR Number:   637314
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2010 Not a Bug
Description
RQM:Delete/Insert requirement doesn't update the requirement code in Repository



CR:637343
CR Number:   637343
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)
12 Nov 2010 Fixed
18 Nov 2010 Fixed
11 Jun 2012 Fixed
Description
Bulk copy is significantly slower when doing 1000 versus 100 consecutive insert statements.
Workaround Description
 They need to increase the SQT cache size. But they can't increase it so much that repserver runs out of memory. Increasing dsi_large_xact-size probably wouldn't help.



CR:637439
CR Number:   637439
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Nov 2010 Fixed
06 Dec 2010 Fixed
07 Jun 2012 Fixed
Description
Enhance to detect stable device corruption when segment for one queue contains block for another queue.



CR:637493
CR Number:   637493
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
usse EBF5 31 Aug 2010 Fixed
Description
I have a PDM model with two tables. Via a direct connection to a repository installed on Oracle 10g, the consolidation takes around 10 seconds.



If I consolidate the same model via a proxy connection, it takes 5 minutes to complete.



CR:637604
CR Number:   637604
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When upgrading PD 15.1 proxy server to PD 15.2 proxy server, the proxy services is removed during the upgrade process.



To reproduce:



proxy 15.1 is installed

install proxy 15.2

prompted to perform upgrade and click yes

after upgrade completes, the proxy service has been removed.



For 15.1, the proxy service was called 'powerdesigner proxy' for 15.2, the service is 'Sybase powerdesigner proxy'.





*** Mon Aug 09 2010 10:21:10 GMT-0400 (Eastern Daylight Time) *** ahill ***



This issue has been fixed in PD 15.2.0 EBF 4. Executing the proxy server EBF will recreate the proxy service.



CR:637731
CR Number:   637731
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2010 Fixed
21 Oct 2010 Fixed
Description
After upgrading, data with table rep def in MSA environment no longer replicates.
Workaround Description
 Shutdown repserver, then:



select * into bp_objects_hold from rs_objects

go

select convert(binary, phys_objowner) from rs_objects

where objname = "<valid replication definition>"

go

alter table rs_objects modify phys_objowner varchar(30)

go

alter table rs_objects modify repl_objowner varchar(30)

go

select convert(binary, phys_objowner) from rs_objects

where objname = "<rep def from above query>"

go





(That last select to return a column filled

with trailing 0000's) --> this is done in case there is an ASE issue where the alter table leaves the value with "spaces" at the end of the value instead of binary 0s





Restart repserver.



CR:637784
CR Number:   637784
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.2 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Dump by maintenance user during MSA materialization, produces internal error.
Workaround Description
 Do not use the maintenance user to dump the primary database.



However, if you should get this message, the DSI does shutdown. Then you can resume connection skip transaction to get past the dump marker after loading the database at the target. (It is important to set "send warm standby xacts" on the RA to true. Otherwise, one will get the "system transaction" problem after that")



CR:637788
CR Number:   637788
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.2 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Connect to another server via RS Gateway and specify the user id and password



CR:637851
CR Number:   637851
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2011 Fixed
Description
Check in into the repository will not update external shortcuts as long as both models are open.



CR:637999
CR Number:   637999
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.2 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
more and better messages to help diagnose route create/drop issues



CR:638019
CR Number:   638019
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 16 11 Oct 2010 Fixed
Description
RA DB2 abend without message and only partial SYSMSGLG
Workaround Description
 None known except to move to a different build



CR:638130
CR Number:   638130
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Oct 2010 Fixed
15.2 ESD #3 25 Aug 2010 Fixed
28 Sep 2010 Fixed
13 Sep 2010 Fixed
19 Oct 2010 Fixed
Description
After upgrading, error 20026 will be reported and DSI will shutdown when SQL statement replication is used.
Workaround Description
 Current error have to be zapped (zap both "exec rs_sqldml" message) and resume connection.



Then log into RSSD and update "dbid" column of "rs_objects" system table and set it to the Connection ID corresponding to the RSSD connection:



1> begin tran

2> go

1> select * from rs_objects where objid = 0x0000000000000100

2> go

1> update rs_objects set dbid = 101 where objid = 0x0000000000000100

2> go

1> commit

2> go



Restart RepServer.



CR:638286
CR Number:   638286
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   AIX
Original Version:   15.2 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
5101 message on warm standby connection.
Workaround Description
 Unknown. Potential workaround, however, not confirmed is:



1. lower load on RS

2. set sqm_cache_enable and sqm_seg_prealloc to off



CR:638317
CR Number:   638317
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to be able to add one or many projects to a configuration



CR:638634
CR Number:   638634
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2010 Fixed
17 Nov 2010 Fixed
01 Apr 2011 Fixed
Description
Unable to resume connection after a failed system transaction using the 'resume connection to ds.db execute transaction' command.
Workaround Description
 resume connection skip tran does not work for system transactions, must use:



sysadmin sqm_zap_command



CR:638638
CR Number:   638638
Product Name:   Sybase Replication Server
Product Component:   InstallAnywhere
Status:   Closed
OS:   Linux
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2011 Fixed
Description
Progress bar inaccurate during installation.
Workaround Description
 just wait



CR:638660
CR Number:   638660
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2010 Not a Bug
Description
lack of hvar license message appears until dsi_cmd_prefetch is off
Workaround Description
 1> configure replication server

2> set dsi_cmd_prefetch to "off"

3> go



The messages will be gone when one resumes the next connection, no need to reboot the server to get rid of the messages.



CR:639125
CR Number:   639125
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Open
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Include dbisql with Replication Manager install.



CR:639152
CR Number:   639152
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
Support for IQ to IQ replication.



CR:639407
CR Number:   639407
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   5.9.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.6 02 Sep 2010 Fixed
15.5 ESD #3 02 Sep 2010 Fixed
Description
MICROSOFT SQLSERVER ONLY: Replication Agent fails

with "SQL Anywhere Error -141: Table 'articles'

not found" error when Replication Agent is not

initialized and the "pdb_get_tables",

"pdb_get_procedures" or "pdb_get_columns" command

is executed.



CR:639429
CR Number:   639429
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 May 2011 Fixed
Description
Open Client Client-Library error: Error: -99999, Severity 5 --

'Incorrect value type [7] to create a String.' with bulk insert.
Workaround Description
 *** Fri May 27 10:25:08 UTC+0800 2011 *** tning ***



This phenomena is repro out inhouse.



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



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

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



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



Turn off bulk.



CR:639833
CR Number:   639833
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.2 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
With large number of commands in the transaction, sysadmin sqm_zap_tran will not return the prompt in a timely manner.
Workaround Description
 Manually find the begin of the transaction and se sysadmin sqm_zap_command to zap the begin.



CR:639870
CR Number:   639870
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
Missing server name in rs_init error message.
Workaround Description
 Make sure that the Replication Server name is correct and is a Rep Server.



CR:639884
CR Number:   639884
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Management
Status:   Open
OS:   Generic
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
capability to show the names of the replication definitions that apply to a marked or unmarked table.
Workaround Description
 Go to RSSD and select from rs_objects and rs_dbrep for the replication definition names.



CR:640141
CR Number:   640141
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature Request: Currently, PowerDesigner Repository Proxy can only be installed on Windows.

This CR has been opened to request to support Repository Proxy on Unix (and Linux)



CR:640229
CR Number:   640229
Product Name:   RepConnector
Product Component:   Run-time Engine
Status:   Open
OS:   Generic
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
request ability to specify format of message, either bytesmessage or textmessage



CR:640247
CR Number:   640247
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)
12 Oct 2010 Fixed
Description
Turning on trace DSI_CHECK_ROW_COUNT_FULL_NAME as an connection trace produces a stack on the Rep Server.
Workaround Description
 issue at the server. For example:



C:\sybase1520>isql -Usa -P -Sredeyeak1560rep

1> trace "on",dsi,DSI_CHECK_ROW_COUNT_FULL_NAME

2> go



CR:640369
CR Number:   640369
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   usse EBF4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2010 Fixed
Description
Repository Consult/Specific to cust models.



Integrate a document into another one, name of a view column has been lost after Check In and is displayed as "View column" in repository explorer.

As a consequence, if you compare the local model with its copy in the repository, 'Compare Models' has detected a difference on that view column and is displayed with no label in that window.



CR:640471
CR Number:   640471
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
Allow the 5185 message to be set by table and allow different tables on the same connection to handle the 5185 resulting action differently.



CR:640500
CR Number:   640500
Product Name:   Other - Docs: Rep Server
Product Component:   Other - Docs: Rep Server
Status:   Closed
OS:   NA
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.6 12 Sep 2011 Fixed
Description
Add documentation on how to validate that a parameter has been set.



CR:640806
CR Number:   640806
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Open
OS:   Windows
Original Version:   usse
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In CMR, a Java RuntimeException is thrown when attempting to create a subscription with an user that had a subscription on a model\document that was deleted. Executing a refresh or stopping and restarting the CMR server have no effect.



To reproduce:

1) Connect to Portal (in my test, this was a new install of Portal)

2) create user_1 and user_2 (users created with no password and a valid email address)

3) select a model\document (model_1) and create new subscription using user_1

4) in PD, connect to repository and delete the model\document (model_1)

5) in CMR, refresh or stop and restart the server

6) select model_2 and create a new subscription using user_1

7) click Save

NOTE: you get the following error:

An error has occurred! Click logout



java.lang.RuntimeException: wrapped Exception: java.lang.NullPointerException

at com.sybase.cmr.web.filter.LocaleFilter.doFilterInternal(LocaleFilter.java:96)



8) logout and then log back in

9) select model_2 and create a new subscription using user_2

10) click Save



NOTE: the subscription is created. It appears that the problem occurs when attempting to reuse an user that was previously associated with a model that has been deleted from the repository.



CR:640996
CR Number:   640996
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Open
OS:   Solaris
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
rs_init hangs when "exit sybinit" is n
Workaround Description
 Basically none, Allow rs_init to end and start over.



CR:640998
CR Number:   640998
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Open
OS:   Linux
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
rs_init hangs after getting "Exit sybinit?"
Workaround Description
 None



CR:640999
CR Number:   640999
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Cannot suspend the connection while the server is in hibernation mode.
Workaround Description
 shutdown the RS



Bring up the RS in standalone mode (-M )



Suspend the connections and shutdown the server



Bring up the RS in normal mode. Now the connections are suspended.



CR:641139
CR Number:   641139
Product Name:   Other - Docs: Rep Server
Product Component:   Other - Docs: Rep Server
Status:   Closed
OS:   NA
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.6 12 Sep 2011 Fixed
Description
RS server needs to be added to the interfaces file of IQ in order for RTL to work.



CR:641146
CR Number:   641146
Product Name:   Rep Serv Troubleshoot Guide
Product Component:   Rep Serv Troubleshoot Guide
Status:   Closed
OS:   all
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.6 27 Sep 2010 Added to user documentation
Description
Add message that one would get when RTL to IQ is used (server not found).



CR:641367
CR Number:   641367
Product Name:   Other - Docs: Rep Server
Product Component:   Other - Docs: Rep Server
Status:   Open
OS:   NA
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Include doc that in a IQ multiplex environment, the RS has to connect to the coordinator node.



CR:641372
CR Number:   641372
Product Name:   Rep Serv Troubleshoot Guide
Product Component:   Rep Serv Troubleshoot Guide
Status:   Closed
OS:   NA
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2011 Added to user documentation
Description
Add message: Permission denied: Command not allowed on

Multiplex Writer servers. to the Troubleshooting Manual



CR:641373
CR Number:   641373
Product Name:   Other - Docs: Rep Server
Product Component:   Other - Docs: Rep Server
Status:   Closed
OS:   NA
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2010 Added to user documentation
Description
Add documentation on what people have to do to have RS continue processing if the coordinator node fails in a Multi-plex environment.



CR:641825
CR Number:   641825
Product Name:   Replication Management
Product Component:   Web UI
Status:   Closed
OS:   Generic
Original Version:   3.2.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2010 Fixed
30 Nov 2010 Fixed
Description
Replication Server 15.5 script file (ral1550.sql) contains the incorrect Replication Server version. Errors produced are similiar to "com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -265: Procedure 'ral_error_class' not found".
Workaround Description
 For supporting Replication Server version 15.5 in RMAP 3.1

1) Locate file <SCC install dir>\SCC-3_1\plugins\RMAP\scripts\ral1550.sql

2) Edit ral1550.sql

3) Search for "rs_script_version"

4) Change to "rs_script_version = "1550").





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

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