提供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:361749
CR Number:   361749
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2006 Fixed
11 Jul 2006 Fixed
11 Jul 2006 Fixed
Description
If MSA is used, turning off dsi_exec_request_sproc causes 5158 error.



CR:361915
CR Number:   361915
Product Name:   Sybase Replication Server
Product Component:   rsmsrvr
Status:   Closed
OS:   AIX
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2005 Insufficient priority to fix
Description
Memory limit message is displayed on RSM Server on AIX.
Workaround Description
 a. Do not specify more than 4 events for RSM Server.



For HP platform, use the GA binary instead of ESD #2



CR:361916
CR Number:   361916
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   12.5.0.301
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.0.303P2 22 Nov 2004 Fixed
5.0.00 07 Oct 2005 Fixed
Description
ORACLE ONLY: Shadow table column is not wide

enough for DATE.



CR:361993
CR Number:   361993
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   12.5.0.301
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.0.303P2 22 Nov 2004 Fixed
5.0.00 07 Oct 2005 Fixed
Description
MICROSOFT SQL SERVER ONLY: Marking needs to

handle user synonyms of system datatypes.



CR:362019
CR Number:   362019
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2004 Fixed
Description
When we drop pubsub without purge and there is also an existed dbsub, repserver will complain "There is dtabase subscription in charge of replicating table <tablename>. Subscriptions for this table cannot be dropped with automatic de-materialization".



CR:362093
CR Number:   362093
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2004 Fixed
Description
Feature Request:

Quiesce command should just suspend the RAT , It shouldn't kill RAT

Currently, ASE command "quiesce database" kills RepAgent
Workaround Description
 assign action ignore for rs_sqlserver_error_class



If rs_sqlserver_error_class has not been created, create it:

create error class rs_sqlserver_error_class



CR:362409
CR Number:   362409
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   chronos
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2004 Fixed
Description
Migration of repository from v. 9.5.2 to 10.x: the repository Update script in v.10 requires modification of 2 UPDATE statements when repository tables reside on ASE 12.5.x database system.



Scenario: version 9.5.2 PowerDesigner. was used to create repository tables that resides on Sybase ASE 12.5.x database (Unix platform), then the end user connects to the repository using version 10.x PowerDesigner to update it. The repository update script dialog pops up. The end user executes it and during the transactions, the generation log produces 2 errors on the last 2 UPDATE statements:



Errors:

----------



*** Executing statement 1032:

update PMEMDL set TOID=(select POID from PMOBJT where OBJT=TOID) where exists(select 1 from PMOBJT O where PMEMDL.TOID=O.OBJT)



[INTERSOLV][ODBC SQL Server driver][SQL Server]Invalid column name 'TOID'. SQLSTATE = S0022



*** Executing statement 1033:

update PMEOBJ set TOID=(select POID from PMOBJT where OBJT=TOID) where exists(select 1 from PMOBJT O where PMEOBJ.TOID=O.OBJT)



[INTERSOLV][ODBC SQL Server driver][SQL Server]Invalid column name 'TOID'. SQLSTATE = S0022





Resolution from PD Development:

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

Run PowerDesigner's (auto-generated) update script outside of PowerDesigner UI (in an ISQL session) AND modify the 2 update scripts by adding in the alias (PMEMDL and PMEOBJ) for the TOID column in the first select statement as follows:





update PMEMDL set TOID=(select POID from PMOBJT where OBJT=PMEMDL.TOID) where

exists(select 1 from PMOBJT O where PMEMDL.TOID=O.OBJT)

go



update PMEOBJ set TOID=(select POID from PMOBJT where OBJT=PMEOBJ.TOID) where

exists(select 1 from PMOBJT O where PMEOBJ.TOID=O.OBJT)

go



9/9/04

This issue has been addressed in PowerDesigner 11.0.0.



CR:362605
CR Number:   362605
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Apr 2005 Fixed
Description
Data in a DATETIME column is sometimes corrupted when preceeded by a DB2 VARCHAR column.
Workaround Description
 Set RAD config DATETIME_in_char to N (or avoid defining a DATETIME column immediately following a CHAR column in a DB2 table)



CR:362667
CR Number:   362667
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 May 2005 Fixed
28 Jun 2005 Fixed
12.6 13 May 2005 Fixed
12.6 06 May 2005 Fixed
Description
Support for replication of encrypted columns has been added as a feature in RS 12.6. Further documentation can be found on this new function in the updated online RS 12.6 documentation.



CR:362697
CR Number:   362697
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2005 Duplicate
Description
When E,XSTATUS console command is entered against the RAD 12.5 batch process, the user receives one block of details for the DB2 data sharing group (under LAE0180I ) and one for each of the members being replicated (under LAE0182I). In RAD 12.6.3, there is much less details without any breakdown by member.
Workaround Description
 None



CR:362867
CR Number:   362867
Product Name:   RepAgent/ASA
Product Component:   Replication Agent
Status:   Closed
OS:   Generic
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 2384 03 Aug 2004 Fixed
9.0.1 1900 03 Aug 2004 Fixed
9.0.0 1344 03 Aug 2004 Fixed
8.0.3 5140 03 Aug 2004 Fixed
8.0.2 4454 03 Aug 2004 Fixed
Description
The Replication Agent dbltm, may have hung with zero CPU utilization on Unix platforms, if it had been running for more than 36 minutes, and it scanned the online transaction log faster than the log has growing. This has been fixed.



CR:362975
CR Number:   362975
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   chronos
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide user with option to specify an user defined version# for branches



CR:363066
CR Number:   363066
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2004 Fixed
Description
The function strings created to support Heterogeneous Datatypes must have an expiration date of '01-01-4000' when an Embedded RSSD is used.



CR:363327
CR Number:   363327
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Informix
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.0.302P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.0.303P2 22 Nov 2004 Fixed
Description
INFORMIX ONLY: RepAgent sends bad/strange LTL

message after being interrupted. For more

details, see description of fix to CR #365503.



CR:363607
CR Number:   363607
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Management
Status:   Closed
OS:   Generic
Original Version:   12.5.0.302P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4047P5 16 Sep 2004 Fixed
12.5.0.303P2 22 Nov 2004 Fixed
12.5.0.3021P1-ONE_OFF 05 Oct 2004 Fixed
Description
In non-English locales, the class containing

result set headers and valid states in which

commands can be executed cannot be found

causing an error similar to the following when

the user tries to set properties or issue

commands:



Cannot load resource bundle,

com.sybase.ra.resource.RACLIResource,

for TDS header print out, <Can't find

resource for base name

com.sybase.ra.resource.RACLIResource, locale

iw_IL>



CR:363786
CR Number:   363786
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   12.5.0.302P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.0.303P2 22 Nov 2004 Fixed
5.0.00 07 Oct 2005 Fixed
Description
ORACLE ONLY: Query in RA_GET_TX_INFO procedure

returns multiple rows when Oracle is parallel.



CR:363856
CR Number:   363856
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Closed
OS:   NA
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2006 Fixed
Description
Upgrade to RS 12.6 is only allowed from versions 11.5.1 and newer.
Workaround Description
 RS 12.5 was the last version that allowed upgrade from 11.0.3 and 11.5.0. Upgrade from current release to 12.5, and then upgrade from 12.5 to 12.6.



CR:364141
CR Number:   364141
Product Name:   Rep Serv What's New
Product Component:   Rep Serv What's New
Status:   Closed
OS:   NA
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Feb 2005 Fixed
Description
The correct name of the parameter 'RS_enc_pw' is 'RS_send_enc_pw'.

This is one of the doc bug.



CR:364257
CR Number:   364257
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.04 29 Apr 2005 Fixed
Description
S0C7 in LTMEXT for OFFSET=0002B12



CR:364435
CR Number:   364435
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)
16.0
Description
client needs to be able to sync at databases level for his MSA environment



Request for Enhancement per peck:

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



Extend "set autocorrection" semantic

to support autocorrection at a whole-database

level:

Currently, we only support autocorrection

for specifically-identified tables, as

follows:

set autocorrection { on | off }

for replication_definition

with replicate at data_server.database

Proposal:

Also Support:

set autocorrection { on | off }

for database replication definition db_repdefname

with primary at data_server.database

with replicate at data_server.database
Target Version
 12.6
Workaround Description
 error action



CR:364702
CR Number:   364702
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Informix
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.0.302P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2008 EOL'd version. Not to be Fixed.
Description
RepAgent for Informix 12.50.302P1 on Windows 2000 has its Log Reader process halted due to Informix access locking conflict with ct's high volumne batch transaction run despite ct's Informix is configured with 2 million locks. Batch run updates the index (INSERTS) where process_seq = 0 which conflicts with the RAX Log Reader procedure's where process_seq = 0 (RAI times out and attempts recursive resume/restart, which gives rise to "rogue" LTL send to RS - see CR 363327)



CR:364890
CR Number:   364890
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   NA
Original Version:   12.6.0.4044P2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4045P3 24 Aug 2004 Fixed
Description
NullPointerException in ASETransactionContext sends MRA to ADMIN state.



CR:364977
CR Number:   364977
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   NA
Original Version:   12.6.0.4044P2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4045P3 24 Aug 2004 Fixed
Description
NullPointerException out of LTLFormatter sends MRA to ADMIN state.



CR:364988
CR Number:   364988
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   NA
Original Version:   12.6.0.4044P2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4045P3 24 Aug 2004 Fixed
Description
NullPointerException out of ASESchemaChangeContext sends MRA to ADMIN state.



CR:365057
CR Number:   365057
Product Name:   Sybase Replication Server
Product Component:   rsmsrvr
Status:   Closed
OS:   Generic
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 13 Sep 2004 Fixed
Description
The RSM Server will reach its memory limit when reading a large log file that is being updated continuously by the Replication Server. The RSM Server cannot read and send new entries to the RSM Plug-in as fast as the server can add new log entries. This only occurs when monitoring a very active Replication Server when the DSI buffer trace is turned on.



CR:365077
CR Number:   365077
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2004 Fixed
15.0 27 Aug 2004 Fixed
Description
'rs_helpdbrep' does not provide accurate subscription information



CR:365209
CR Number:   365209
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2004 Fixed
Description
In cases where a Replication Server may be configured to support a large number of connections, say 25 or more, it is possible when the "smp_enable" configuration is set to "on" that at startup the Replication Server process will seem to "hang" while consuming large amoutn of CPU. In fact, if stack traces are taken several minutes apart one can see that the threads are making progress, only slowly, and that if one waits long enough, depending on the number of connections and the number of available CPUs, RepServer will eventually resolve all the thread initialization issues and be ready for work.



The difficulty here is one of the various threads thrashing about in contention for an internal resource required to complete their initializations. This resolution addresses the issue by enforcing "tighter" thread serialization at startup and putting threads to sleep until it is their turn to initialize, thus reducing CPU requirements during this initialization phase.



CR:365379
CR Number:   365379
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   Generic
Original Version:   12.6.0.4045P3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4046P4 09 Sep 2004 Fixed
Description
When the logical page number within the truncation point's oldest open transaction is negative, replication fails with an error message similar to:

Device Usage Map entry for database <4>, logical page id <-1> not found.



CR:365503
CR Number:   365503
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTI Driver
Status:   Closed
OS:   Generic
Original Version:   12.5.0.302P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.0.3021P1-ONE_OFF 05 Oct 2004 Fixed
12.5.0.303P2 22 Nov 2004 Fixed
Description
Operation sent out of order causes RepServer to

throw out un-replicated operations as "duplicates."



CR:365577
CR Number:   365577
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2004 Fixed
Description
The installation file transfer to mainframe fails on some machines.
Workaround Description
 Created 9 xmit files (all are FB, 80, 3120 except where noted)

MCI.DBRM.XMIT

MCI.DOCS.XMIT

MCI.ISPF.XMIT

MCI.JCL.XMIT

MCI.LTMLOC (FB 255, 2550)

MCI.MAC.XMIT

MCI.OBJ.XMIT

MCI.RA.XMIT

MCI.SAS.XMIT



and ftp'ed them to customer. LTMLOC is the only dataset that is not a PDS. Customer FTPed the nine files up to the mainframe (without using the EBF software), expanded MCI.DBRM.XMIT, MCI.DOCS.XMIT, MCI.ISPF.XMIT, MCI.JCL.XMIT, MCI.OBJ.XMIT with the TSO receive function and proceeded with Task 5. The problem with doing it this way is that the JCL and other tailoring had not been done.



Another way to preserve the tailoring is go to wherever the tailored JCL is (the directory specified in the first panel of the EBF install), and upload DOCS, ISPF and JCL directories to the mainframe (each one is a PDS) and separately send the other libs.



CR:365623
CR Number:   365623
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.07 015 16 May 2005 Fixed
Description
When Use_repdef=Y and Stop_on_error=Y and there is no repdef defined for the table, the message returned by the RA DB2 is not specific to the error.
Workaround Description
 check to ensure that there is an replication definition defined for this table.



CR:365753
CR Number:   365753
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2005 Fixed
Description
Default "DD" entry for "RPCLIB" should reference back to "STEPLIB"



CR:366058
CR Number:   366058
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   12.6.0.4045P3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4046P4 09 Sep 2004 Fixed
5.0.00 19 May 2008 Fixed
5.3.00 07 Mar 2006 Fixed
Description
Replication fails when primary contains columns

with same names but with different character case

(e.g., "MyColumn" and "mycolumn").



CR:366059
CR Number:   366059
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   Generic
Original Version:   12.6.0.4045P3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4046P4 09 Sep 2004 Fixed
5.0.00 02 Dec 2005 Fixed
Description
Replication fails when it encounters a record of type XREC_DOL_DNOOP.



CR:366104
CR Number:   366104
Product Name:   RepConnector
Product Component:   Run-time Engine
Status:   Closed
OS:   Generic
Original Version:   2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2005 Fixed
15.0 23 May 2005 Fixed
Description
This CR fixes the problem with RepConnector not supporting NUMERIC data types for ASE12.5.1
Workaround Description
 The workaround of this CR is using "int" type instead of "NUMERIC".



CR:366110
CR Number:   366110
Product Name:   RepConnector
Product Component:   Run-time Engine
Status:   Closed
OS:   Generic
Original Version:   2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2004 Fixed
Description
Added an enhancement to handle the ownership information of tables with the same table name but

different owners.
Workaround Description
 The workaround is defining the replication definitions separately for all of the tables with the same name and different owners.



CR:366287
CR Number:   366287
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Utilities
Status:   Closed
OS:   Generic
Original Version:   12.6.0.4046P4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.3.00 07 Mar 2006 Fixed
Description
If the primary database allows a table (or

procedure) to have more than one column (or

parameter) with the same name but different

character case (e.g., "myCol" and "MYcol"), then

when replicating, RepAgent replicates the value

of the first column to *both* columns.



CR:366409
CR Number:   366409
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)
Description
The attention handler that the replication server installs makes

illegal calls at the interrupt level if the trace OSRV, OS RV_TR_ATTN

is turned on. The trc_print functions that are called to write

messages require a mutex to be locked via a call to srv_lockmutex().

This is not allowed at the interrupt level by Open Server. This

results in an endless loop of attempting to report an error until

the server runs out of memory and crashes.



CR:366474
CR Number:   366474
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   neptune beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add in the sample VBS-scripts a skeleton for

a. Browsing packages in the repository

b. Extract each package from it

c. for each of these models, create a report and generate html file



CR:366482
CR Number:   366482
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   Minerva
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Wouldn't be interesting to provide some views that are indeed more intuitive like

a table with all classes 'flatten', another with attributes,and a FK that refers to the classes tabels (instead the relationship table), ....



CR:366523
CR Number:   366523
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   MRAgent/ASE
Status:   Closed
OS:   Generic
Original Version:   4.0.43
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4052P10 14 Feb 2005 Fixed
12.6.0.4052P10 14 Feb 2005 Fixed
5.0.00 07 Oct 2005 Fixed
5.0.00 07 Oct 2005 Fixed
12.6.0.4052P10 14 Feb 2005 Fixed
5.0.00 02 Aug 2007 Fixed
Description
Two new parameters have been added to the

mra_admin utility to allow a Mirror Replication

Agent instance to be created and configured using

a resource file.



Resource files are text files that you can modify

with any text editor. They contain information

that identifies the resources and configuration

values to be used by the mra_admin utility to

create a Mirror Replication Agent instance.



To create a resource file, copy the template file

found in the init subdirectory of the Mirror

Replication Agent installation directory and edit

the copy as needed. The template resource file

contains descriptions of each of the values and

options that you can set.



Once the resource file is created, you can execute

mra_admin with the -vr or -r command line

parameter, specifying the resource file that

mra_admin will use for input.



New mra_admin parameters:

-r <resource> Creates a Mirror ReplicationAgent

instance based on the contents

of the resource file specified.



-vr <resource> Validates the contents of the

resource file specified, without

creating an instance.





Note: Sybase recommends that you validate a new

resource file by using the mra_admin -vr parameter

first, before you create the instance using the -r

parameter.





EXAMPLES:



USING RESOURCE FILES FOR MRA_ADMIN



This section explains how to prepare a resource

file for mra_admin.



1. Make a copy of the template file and rename

it to distinguish it from the original.

For example:



cp mra.rs pubs2.rs



2. Use a text editor to edit the new resource

file.



To use the vi editor, for example, enter:



vi pubs2.rs



See "Editing a resource file" below for

instructions.



3. When you finish editing the resource file,

properly set your Sybase environment

variables and start mra_admin from the

operating system prompt, using the -vr or

-r parameter. For example:



$SYBASE/MRA-12_6/bin/mra_admin -vr pubs2.rs





EDITING A RESOURCE FILE:



Resource files list the attributes to be defined

during an mra_admin session and the values for the

attributes. Attribute entries are in this format:



attribute=value



where:

attribute - is an item for which you are

supplying information, such as a

server name or network protocol.



value - is the value you want to assign to

the attribute.



mra_admin ignores blank lines and lines that begin

with a pound sign (#). No spaces should separate

the attribute, equals sign, or value.



If a Sybase-defined default value exists for an

attribute, you can specify the default with the

special value USE_DEFAULT.





RUNNING MRA_ADMIN IN VALIDATION MODE



Note: Before you can invoke Mirror Replication

Agent utility mra_admin, you must first make sure

that the Sybase environment variables are set.

Refer to the "Mirror Replication Agent

Administration Guide" section on "Using Mirror

Replication Agent utilities" for more information.



Each execution of mra_admin with the -vr (validate

resource file) parameter returns information about

the validation and the result. When complete, the

last message displayed is "Admin processing

completed" or "Validation encountered failures."



If you encounter the "Validation encountered

failures" message, review the previous messages to

determine the exact cause of failure, correct the

necessary values in the resource file, and re-run

the validation until it executes successfully.



You can re-run the validation process as many

times as necessary. No entities are changed or

created as a result of this process.





RUNNING MRA_ADMIN IN CREATE MODE



Each time you execute mra_admin with the -r

(resource file) parameter, it attempts to create a

Mirror Replication Agent instance using the

resource file as input.



Note: Executing mra_admin with the -r parameter

creates files and other resources. Any attempt to

re-run this command will fail unless you first

remove those resources as described at the end of

this section.



Each execution of mra_admin returns information

about the instance being created and the result.

When complete, the last message displayed is

"Admin processing completed" or "Admin processing

completed with errors". If the "Admin processing

completed with errors" message is returned,

review the previous messages to determine the

exact cause of failure, and correct the necessary

values in the resource file.



Note:Before you re-run the mra_admin with the -r

parameter, delete any instance created during the

previous execution by using the mra_admin -d

(delete)parameter:



$SYBASE/MRA-12_6/bin/mra_admin -d <INSTANCE_NAME>



Example:

$SYBASE/MRA-12_6/bin/mra_admin -d pubs2_mra



CR:366586
CR Number:   366586
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.04 28 Apr 2005 Fixed
Description
RA DB2 says stop_on_error says terminate, when stop_on_error has value of N.
Workaround Description
 No workaround at this time. See CR 346791 for sysadmin hibernate on/off bug. Okay to restart up the RA DB2 after whatever condition caused RA DB2 to go down, is corrected.



CR:366750
CR Number:   366750
Product Name:   Sybase Replication Server
Product Component:   rsmsrvr
Status:   Closed
OS:   Generic
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 13 Sep 2004 Fixed
12.6 15 Oct 2004 Fixed
Description
The RSM Server generates an error message in the log file during the ping cycle if a data server associated with a connection is not included in the set of managed servers. Customers should not be required to monitor all data servers in a replication environment.



CR:366751
CR Number:   366751
Product Name:   Sybase Replication Server
Product Component:   rsmsrvr
Status:   Closed
OS:   Generic
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 14 Sep 2004 Fixed
Description
Add support for the Mirror Replication Agent (MRA). The RSM Server will monitor the status of the MRA, set configuration parameters, and display the MRA error log file.



CR:366760
CR Number:   366760
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   Generic
Original Version:   12.6.0.4046P4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4047P5 16 Sep 2004 Fixed
5.8.00 25 Jul 2008 Fixed
Description
Replication fails on an updated null Text/Image across tables in same transaction.



CR:366767
CR Number:   366767
Product Name:   Sybase Replication Server
Product Component:   rsmsrvr
Status:   Closed
OS:   HP-UX
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2004 Fixed
Description
The Replication Server Manager Server (RSMS) fails immediately after

startup with the error "ERROR #7035 BROKER(1) - /mem/mem.c(242)

Additional allocation would exceed the memory_limit of '20971520'

specified in the configuration." Increasing the memory limit via the

'memory' configuration line in the RSMS configuration file has no

effect. This behavior is more frequently observed when RSMS invokes

multiple event scripts.



CR:366856
CR Number:   366856
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2005 Fixed
Description
Messages sent from User Exit to RA DB2 show up as "internal errors"
Workaround Description
 None.



CR:366863
CR Number:   366863
Product Name:   Sybase Replication Server
Product Component:   rsmclient
Status:   Closed
OS:   Generic
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 14 Sep 2004 Fixed
Description
The server event dialog was not saving processes defined for the server events: invalid, shutdown, or quiesce. The dialog was not sending the RSM Server the command to save the server events. The dialog now allows the user to assign processes to the server events listed above.



CR:367211
CR Number:   367211
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.08 001 26 Oct 2005 Fixed
Description
" LEXTRACE RBA cannot be found in DB2 log." needs reason code included on the message.
Workaround Description
 Start up RA DB2 again and set LogTrace=yes in the LTMCFG --or--



Restart RA DB2 and start up the LogTrace via console command:

/f jobname,e,trace=on

/f jobname,e,trace=off



CR:367212
CR Number:   367212
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 26 Sep 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Message from Rep Server does not indicate that it will stop RA DB2, however it does.
Workaround Description
 Fix the problem based on the Rep Server message returned back to RA DB2.



CR:367241
CR Number:   367241
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.05 29 Apr 2005 Fixed
Description
Enhancement to line up the RBAs returned in STATUS and LOGINFO commands for easier comparison.
Workaround Description
 None, or other software vendor alternatives (e.g. screen scraper utilities)



CR:367245
CR Number:   367245
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2005 Fixed
Description
Add URID to the line that contains dbid and table information for each log record that was replicated.
Workaround Description
 Get the DSN1LOGP for the record in question. The print of the log record will display the URID.



CR:367255
CR Number:   367255
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.04 29 Apr 2005 Fixed
Description
Message that shows ECSA/CSA that is allocated



CR:367268
CR Number:   367268
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   Generic
Original Version:   12.6.0.4047P5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4048P6 21 Sep 2004 Fixed
Description
Replication fails on XBEGIN record type.



CR:367270
CR Number:   367270
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   Generic
Original Version:   12.6.0.4047P5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4048P6 21 Sep 2004 Fixed
Description
Log records for DBCC SETTRUNC commands are not recognized.



CR:367360
CR Number:   367360
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTI Driver
Status:   Closed
OS:   Generic
Original Version:   12.6.0.4047P5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4048P6 21 Sep 2004 Fixed
12.6.0.4048P6 21 Sep 2004 Fixed
02 Dec 2005 Fixed
Description
Replication fails on XREC_DOL_INSIND record type.



CR:367379
CR Number:   367379
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   Generic
Original Version:   12.6.0.4047P5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4048P6 21 Sep 2004 Fixed
Description
Oldest open transaction list is not guaranteed to be ordered correctly.



CR:367576
CR Number:   367576
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 04 Jan 2006 Fixed
Description
RA DB2 does not retry connection when sysadmin hibernate_on and then sysadmin hibernate_off is issued at the Replication Server.
Workaround Description
 Do not issue sysadmin hibernate_on/off. After the condition has been corrected, the RA DB2 should start up and not lose any data or transactions.



CR:367601
CR Number:   367601
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   Solaris
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 205 15 Feb 2005 Not reproducible with latest version of the product available as of Resolution Date
15 Dec 2005 Fixed
Description
Replication Manager with dump marker option leaves standby connection in "Waiting for Enable Marker" status.
Workaround Description
 Do not use RM with the dump_marker option. For the dump marker option, use rs_init.



CR:367615
CR Number:   367615
Product Name:   RepConnector
Product Component:   GUI
Status:   Closed
OS:   Generic
Original Version:   2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2005 Fixed
Description
This CR fixes the problem where the RepConnector and the RSSD passwords are displayed in the properties window in plain text.



CR:367669
CR Number:   367669
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   Generic
Original Version:   12.6.0.4048P6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4049P7 05 Oct 2004 Fixed
Description
Date conversion error causes the Mirror RepAgent to go to ADMIN state.



CR:367713
CR Number:   367713
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Open
OS:   NA
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Modify rsupgr.sql script to improve performance of upgrade.

And/Or add additional indexes that will improve performance

of rsupgr.sql upgrade script



CR:367741
CR Number:   367741
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   Generic
Original Version:   12.6.0.4048P6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4052P10 14 Feb 2005 Fixed
5.3.08 06 Mar 2008 Fixed
12.6.0.4052P10 14 Feb 2005 Fixed
5.0.00 07 Oct 2005 Fixed
5.0.00 02 Aug 2007 Fixed
Description
Mirror Replication Agent fails to find the

maintenance user unless it exists in sysusers.



CR:367784
CR Number:   367784
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.10 11 21 Sep 2006 Fixed
Description
Add subpool number to CSA/ECSA message in JESLOG.



CR:367792
CR Number:   367792
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.09 14 Feb 2006 Presently Not Targeted For Any Future Release Of This Product
Description
RA DB2 fails to detect a disconnect to Rep Server and fails to reconnect.
Workaround Description
 Restart RA DB2.



CR:368191
CR Number:   368191
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   Generic
Original Version:   12.6.0.4048P6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4049P7 05 Oct 2004 Fixed
Description
A timing error causes Mirror RepAgent to return to ADMIN state but shows up as either ClassCastException or "Illegal log record type" error. However, a timing error can potentially have other, different manifestations.



CR:368352
CR Number:   368352
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2009 Presently Not Targeted For Any Future Release Of This Product
Description
RepServer should not be affected by default external Open Client configuration file ocs.cfg.
Workaround Description
 Run RepServer in it's own $SYBASE directory system.



CR:368372
CR Number:   368372
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)
Description
Be able to customize the occurrence of informational messages in the Rep Server log.



CR:368599
CR Number:   368599
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   Generic
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2009 EOL'd version. Not to be Fixed.
Description
Support use of firewalls with RSM and RM, and provide configuration parms and process that would keep an active connection through the firewall.
Workaround Description
 Configure a RSM Server outside of the firewall with the RSM client also on the outside and the servers inside. Configure the RSM Server to ping servers within the timeframe of when the connection will close.



The ping cycle, although configured through the client, is a server property, hence will keep the firewall connection open.



CR:368703
CR Number:   368703
Product Name:   Sybase Replication Server
Product Component:   rsmsrvr
Status:   Closed
OS:   NA
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2009 Presently Not Targeted For Any Future Release Of This Product
Description
SybaseCentral RSM Plugin, Replication Definition DDL:

The owner.table syntax gets generated incorrectly.

It should be owner."table" instead it generates "owner.table"



CR:368768
CR Number:   368768
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   Generic
Original Version:   12.6.0.4049P7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4050P8 11 Oct 2004 Fixed
Description
Incorrect Mirror RepAgent processing of update operations causes data loss at the replicate.



CR:368975
CR Number:   368975
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTI Driver
Status:   Closed
OS:   Generic
Original Version:   12.5.0.303P2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.0.303P2 22 Nov 2004 Fixed
12.6.0.4052P10 14 Feb 2005 Fixed
5.0.00 07 Oct 2005 Fixed
Description
If the default charset is an invalid Java charset,

then during replication, a NullPointerException

may be thrown.



CR:369294
CR Number:   369294
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Research into...

THREAD FATAL ERROR #60036 GLOBAL RS(GLOBAL RS) -xec/exec.c(365)

Failed to acquire lock on sync element 'rsinfo_global_rshandle_mutex'



CR:369355
CR Number:   369355
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   unknown
Original Version:   12.6.0.4051P9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4051P9 20 Oct 2004 Fixed
Description
Replicating a rollback of a range of operations in a large transaction causes the Replication Server distributor error "Invalid command encountered in distributor. smd_cmd = 114"



CR:369400
CR Number:   369400
Product Name:   Sybase Replication Server
Product Component:   rsmsrvr
Status:   Closed
OS:   Generic
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2005 Fixed
Description
The RSM Server will fail when retrieving SQT thread data when the first transaction field is longer then expected. The field size was increased in Replication Server version 12.5. The RSM Server retrieves SQT data when displaying queue properties and queue data.



CR:369474
CR Number:   369474
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.05 12 May 2005 Fixed
Description
LEXTRACE Read Error rc=00000008 reason=00E60865.
Workaround Description
 Restart the RA DB2



CR:369512
CR Number:   369512
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Informix
Status:   Closed
OS:   Generic
Original Version:   12.5.0.303P2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.0.303P2 22 Nov 2004 Fixed
19 Oct 2004 Not a Bug
Description
INFORMIX ONLY: Running "pdb_xlog create" causes

a syntax error when the XLog create script is

executed.



CR:369527
CR Number:   369527
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   Generic
Original Version:   12.6.0.4050P8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4051P9 20 Oct 2004 Fixed
Description
Mirror Replication Agent produces error: ASE date <0x83950000 0x71e42200> conversion error of date type 1



CR:369601
CR Number:   369601
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Reader
Status:   Closed
OS:   Generic
Original Version:   12.6.0.4050P8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4051P9 20 Oct 2004 Fixed
5.0.00 02 Aug 2007 Fixed
Description
The truncation point and validation point are not updated in Mirror RepAgent on re-initialization.



CR:369748
CR Number:   369748
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 09 Jan 2006 Fixed
Description
Diagram 6-4 does not correctly show an usupported route schema. The description that goes along with diagram 6-4 does not correctly describe an unsupported route schema.
Workaround Description
 Unsupported route schemas will give errors at route creation time, not data replication time.



CR:369795
CR Number:   369795
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   LTI Driver
Status:   Closed
OS:   Generic
Original Version:   12.5.0.303P2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.0.303P2 22 Nov 2004 Fixed
Description
When sending LTL commands, RepAgent sends the

whole byte buffer (including 0x00 bytes)

instead of only the LTL command within the

buffer.



CR:369949
CR Number:   369949
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2005 Fixed
Description
Missing commands (including commit) could occur if network connection is broken between RA DB2 and Rep Server.
Workaround Description
 back up in the DB2 log and replay the DB2 log that includes the transactions (if you do this after RA DB2 has been restarted and more work has been done, you might need to increase the generation number, and turn autocorrection on at the target DSI)



CR:369991
CR Number:   369991
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Management
Status:   Closed
OS:   Generic
Original Version:   12.6.0.4043P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4052P10 14 Feb 2005 Fixed
12.6.0.4052P10 14 Feb 2005 Fixed
12.6.0.4052P10 14 Feb 2005 Fixed
5.0.00 07 Oct 2005 Fixed
5.0.00 13 Jul 2005 Fixed
Description
To make it easier to adjust the Mirror RepAgent

Java max memory, all the executable scripts in

the $SYBASE/MRA-12_6/bin directory and the RUN

script for any instance created after applying

this EBF now contain a variable called

RA_JAVA_MAX_MEM. Before setting it to a default

value, the executable scripts first check to see

if it has already been set. This allows you to

customize it by setting the RA_JAVA_MAX_MEM

variable in either the instance RUN script

(MRA-12_6/<instance>/RUN_<instance>) or in your

environment.



CR:370359
CR Number:   370359
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request:

Add delay between command_retry for deadlocks;

...add command_retry_delay parameter to DSI connection.



CR:370553
CR Number:   370553
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   chronos
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2004 Fixed
02 Dec 2004 Fixed
18 Nov 2004 Fixed
Description
Repository on DB2 OS/390

ODBC Driver : IBM ODBC driver or Datadirect wire protocol



When extracting a model from the repository, the following error message occurs:



SQL0104N An unexpected token "COUNT" was found following "".

Expected tokens may include: "+ ) - ". SQLSTATE=42601



This results in an unreadable file.



CR:370626
CR Number:   370626
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Microsoft Windows
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature Request for future support of Windows XP,

Request support to start repserver as a service
Workaround Description
 Couldn't startup the RS thru Service, only can start it up by .bat file.



CR:370627
CR Number:   370627
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2005 Fixed
16 Jun 2005 Fixed
Description
Update the rs_sqlserver_error_class error actions of the following ASE errors

to "ignore", Errors 4985, 4986, 4987, 4988. Currently, these ASE errors are not

defined; defualt to "stop replication"



CR:370868
CR Number:   370868
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Log Admin
Status:   Closed
OS:   Generic
Original Version:   12.6.0.4051P9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.0.4052P10 14 Feb 2005 Fixed
Description
Unnecessary CHECKPOINT command execution results

in permission failures during pdb_quiesce

processing.



CR:371403
CR Number:   371403
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   NA
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2009 EOL'd version. Not to be Fixed.
Description
Replication Manager will not successfully create MSA replication when it has to create the connection, the database replication definition and the database subscription.
Workaround Description
 Use rs_init for setup (define subscription is what is used for dump) --OR--



use rs_init to setup regular connection to the target MSA server, then use the RM to add the database replication definition and database subscription.



CR:371408
CR Number:   371408
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   NA
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 205 11 Feb 2005 Fixed
12.6 205 15 Oct 2009 EOL'd version. Not to be Fixed.
Description
Logical connection names that are not valid "DS.DB" names, should be allowed for input when setting up MSA. These panels need to allow for any logical connection name, even when the logical connection name does not match an entry in the interfaces file.
Workaround Description
 a. Manually set up MSA by using rs_init to create the connection to the MSA database, and then using isql to create the database replication definition and the database subscription.



OR



b. When setting up warm standby, ensure that the name of the logical connection is the same name as a potential physical database connection (e.g. dataserver = something in the interfaces file and database = valid database on that dataserver)



CR:371417
CR Number:   371417
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2005 Fixed
Description
Cannot change the Charset name to something other than iso_1 or utf8/utf16



CR:371716
CR Number:   371716
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   AIX
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2004 Fixed
01 Dec 2004 Fixed
15.0 29 Nov 2004 Fixed
15.0 01 Dec 2004 Fixed
15.0 08 Dec 2004 Fixed
09 Dec 2004 Fixed
07 Dec 2004 Fixed
15.0 08 Dec 2004 Fixed
14 Jun 2005 Fixed
12.6 21 Jan 2005 Fixed
12.6 21 Jan 2005 Fixed
12.6 21 Jan 2005 Fixed
29 Apr 2007 Fixed
Description
Repserver stack dump mechanism is not accurate or broken on several platforms.



CR:371745
CR Number:   371745
Product Name:   Sybase Replication Server
Product Component:   RSMJavaPlugin
Status:   Closed
OS:   Generic
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Sep 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Provide graphical interface tool for rs_subcmp to create the file, as well as the option to run the program from the tool.



CR:371959
CR Number:   371959
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.09 08 14 Feb 2006 Fixed
Description
RA fails after RS is restarted.



CR:372207
CR Number:   372207
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
_resume_ret trigger alarm handler which triggers crash
Workaround Description
 Start up the Rep Server



CR:372268
CR Number:   372268
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Graphic data containing SJIS and EUCJIS must be translated. Currently, graphic data is always sent to the client in Binary form.



CR:372733
CR Number:   372733
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.07 006 16 May 2005 Fixed
Description
After LPAR being taken down abruptly and restarted, RAD terminates on startup with the following error messages:

> LEX0024 Connection established to DB2 subsystem DB2W.

> LEX0062 QID: E2E3D6D7000000000000000000000000000000000000000000000000130A1200

> LEX0025 Log processing to begin at log RBA D6D700000000.

> LEXTRACE Read past end of log, check the truncpt.

> LTM0015 LTM IS PROCESSING SHUTDOWN

> LEX0026 Sybase log Extract terminating with return code 0.



A:

+ The QID appears to contain the EBCDIC character string "STOP" (xE2E3D6D7)

+ All DB2 transactions pending replication before the unscheduled/forced LPAR re-IPL are not received at the Rep Server



CR:372960
CR Number:   372960
Product Name:   RepConnector
Product Component:   GUI
Status:   Closed
OS:   Generic
Original Version:   2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2005 Fixed
Description
This CR enhances the customization functionality of RepConnector with supporting the configurable customization for the custom sender and formatter plugins. With this enhancement, the same plugin class can have different configurations with it's own configuration file.



CR:373392
CR Number:   373392
Product Name:   RepAgent for MVS
Product Component:   DB2
Status:   Closed
OS:   MVS
Original Version:   12.6.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.08 011 26 Oct 2005 Fixed
Description
S0C4 in LTMEXT or LTMGMSG when working with compressed records.
Workaround Description
 None at this time



CR:374071
CR Number:   374071
Product Name:   RepConnector
Product Component:   Run-time Engine
Status:   Closed
OS:   Generic
Original Version:   2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2005 Fixed
Description
This CR fixes the problem where a socket is keeping it's file descriptor open after it's session is removed. This causes EAServer to consume 100% CPU time.





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

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