远程Sybase数据库技术支持,联系手机:13811580958,QQ:289965371!

 

随着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:708573
CR Number:   708573
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Closed
OS:   Red Hat Linux
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2012 Fixed
Description
Core dump is encountered in rs_init interactive mode when using an unrecognized character set.



CR:708629
CR Number:   708629
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   HP-UX
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2012 Fixed
15.7.1 17 Aug 2012 Added to user documentation
Description
ORACLE ONLY: For Oracle 11.2, Replication Agent

goes to REPLICATION DOWN state when replicating

SecureFile LOB.
Workaround Description
 Contact the Sybase Tech Support if already enable replication of tables with SecureFile LOB option enabled.



CR:708776
CR Number:   708776
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2012 Fixed
Description
In a warm standby environment, if the active ASE server is inaccessible

to the RS server, then when a warm standby switch is initiated with the

execution of the RS command 'switch active', the warm standby switch

fails to complete.
Workaround Description
 Please follow the steps exactly, substitute <...> with the right IDs in your system.

Initially, "admin logical_status should return the following:

1> admin logical_status

2> go

Logical Connection Name

Active Connection Name

Active Conn State

Standby Connection Name

Standby Conn State

Controller RS

Operation in Progress

State of Operation in Progress

Spid

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

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

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

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

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

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

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

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

-----

[102] PDS1.pdb1

[103] ost_replnxb15_23.pdb1

Suspended/

[104] ost_replnxb15_46.pdb1

Suspended/

[16777317] ost_replnxb15_56

Switch Active Connection to ost_replnxb15_46.pdb1 in progress

Switch waiting for connection to standby

0073



Note down your logical dbid, old active dbid, new active dbid in the output above. In the example here, logical_dbid=102, old_active_dbid=103, new_active_dbid = 104.



Connect to RSSD and ensure that the following returns the value 10:

1> select state from rs_recovery where seqnum = <logical_dbid> and action = 8

2> go

state

-----------

10



(1 row affected)



Connect to the new active database as sa or maintenance user and issue:

1> rs_syncup_lastcommit <new_active_dbid>, <old_active_dbid>

2> go



Set truncation point at the new active database:

1> dbcc settrunc('ltm','end')

2> go



Connect to RSSD and issue:

1> select id from rs_recovery where seqnum = <logical_dbid> and action = 8

2> go

id

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

0x0100006500000066



(1 row affected)



Take the last 4 bytes (00000066) and convert to int (0x66=102). This is the sequence_number



Connect to the new active DB and issue:

rs_marker "enable replication from <new_active_dbid> to <old_active_dbid> seq <sequence_number>"



Connect to RSSD:

1> update rs_recovery set state = 25 where seqnum = <logical_dbid> and action = 8

2> go



Restart repserver. Switch should finish in a few minutes.

Look for the following in the log:

I. 2012/05/22 15:45:40. Resuming LogTransfer for ...

I. 2012/05/22 15:45:40. Switch completed : PDS.pdb1



Restart rep agent for the new active if it is down. Look for the following in the log:

I. 2012/05/22 16:15:33. Distributor for 'PDS.pdb1' received and proceessed enable marker. Distributing commands to replicates



"admin logical_status" should return:

[103] PDS.pdb1

[104] ost_replnxb15_01.pdb1

Active/

[105] ost_replnxb15_03.pdb1

Suspended/Waiting for Enable Marker

[16777317] ost_replnxb15_60

None

None



The switch is complete at this point.



After the old active is restarted and DSI is started, "admin logical_status" should return:

[103] PDS.pdb1

[105] ost_replnxb15_03.pdb1

Active/

[104] ost_replnxb15_01.pdb1

Active/

[16777317] ost_replnxb15_60

None

None



CR:708924
CR Number:   708924
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
cheverny 27 Jul 2012 Fixed
beauregard EBF7 27 Jul 2012 Fixed
Description
Product: PD 16.1 EBF#4

Repository on MS SQL Server 2008



Issue description:



Our customer is now using PD 16.1 EBF#4. He's using LDAP authentication for the repository connection. They are not using SSL. The issue is: on PD Portal, he connects fine. On PD itself, the connection fails



CR:708933
CR Number:   708933
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add feature to customize how repository contents are displayed in the Browser.



Customer's text:



In the repository we must to be able to create user VIEW following different perspective.



Currently PowerDesigner allows to group objects by Branches and Folders and present them in that form.



It would be advantageous to keep the actual physical structure but also provide the ability to group objects and display objects in other VIEWS. We would like create different perspective (outlook, context), examples :



view "List of objects associated with a user"

view "List of conceptual models"

View "List of projects having working on this subject",

etc.



CR:709328
CR Number:   709328
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.6 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2012 Fixed
20 Dec 2012 Fixed
Description
High occurrence of direct query to RSSD table rs_databases when "save_interval" is set at replicate and Outbound Queue have Segments saved by this feature.



CR:709379
CR Number:   709379
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Unknown
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 May 2012 Fixed
Description
When using eRSSD, after altering the RSSD primary/maintenance user password, the RS cores on attempt to restart. (Using RSSD has no such issue)



CR:709381
CR Number:   709381
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Unknown
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2012 Fixed
Description
After alter primary user password, repserver cannot shutdown or restart dbltm. It will keep trying to start and all attempt will fail. Users have to shutdown repserver, kill the dbltm process, and restart repserver in order to work around this.



CR:709461
CR Number:   709461
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.1 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jul 2012 Fixed
02 Jul 2012 Fixed
03 Jul 2012 Fixed
28 Aug 2012 Fixed
Description
RTL: When using RTL to replicate updates to ASE float columns to IQ double columns, precision may be truncated for some values after 8 or 9 significant digits.
Workaround Description
 Avoid using float datatypes if at all possible.

Or, replace Update with delete/insert using:



alter connection to IQSRVR.iqdb

for replicate table named dbo.'floatTest'

set dsi_command_convert to 'u2di'



CR:709623
CR Number:   709623
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   HP-UX
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2012 Fixed
Description
ORACLE ONLY: Replication Agent fails to

replicate a rollback.



CR:709712
CR Number:   709712
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jun 2012 Fixed
11 Jul 2012 Fixed
Description
Suppose there are more than one replication definitions for a primary table. When the repdef marked for standby is altered, the internal replication definition associated with it is also altered. If there is data in the inbound queue for the old internal replication definition version, DSI would go down with something like "

ERROR #50 DSI EXEC(700(1) SYBOLTPWS.VBDMASTR) - /nrm/nrm.c(733)

'rs_objects' system table is corrupt."
Workaround Description
 In the RSSD of the primary repserver, issue,

update rs_objects set phys_tablename = deliver_as_name where deliver_as_name = '<the name of the table in question>' and objname like 'rs_indrp%'



In the repserver which controls the DSI, issue

sysadmin stscache,invalidate,"rs_objects"

resume connection to <ds name>.<db name>



CR:709823
CR Number:   709823
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   AIX
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2014 Fixed
Description
Instrumentation to help determine why block consistency failed in 15.6
Workaround Description
 upgrade to rs 15.7.1



CR:710095
CR Number:   710095
Product Name:   Rep Serv Admin Guide
Product Component:   Rep Serv Admin Guide
Status:   Closed
OS:   all
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 ESD #1 20 Jun 2013 Fixed
Description
Resetting the erssd transaction log also requires issuing dblog -t after the dblog -il step



CR:710230
CR Number:   710230
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Unknown
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Aug 2012 Fixed
Description
Repserver stops replication for error 13900. It should be ignored.



CR:710410
CR Number:   710410
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Unknown
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2012 Fixed
16 Aug 2012 Fixed
18 Jul 2012 Fixed
Description
For a varbinary column, if the data has trailing zeros, the trailing zeros are stripped off when bulk or hvar is on.



CR:710711
CR Number:   710711
Product Name:   Sybase Replication Server
Product Component:   rs_subcmp
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2012 Fixed
24 Jul 2012 Fixed
26 Jul 2012 Fixed
Description
Utility rs_subcmp pads varbinary values when comparing and does not differentiate between values with different lengths of trailing zeroes.



CR:710943
CR Number:   710943
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7.1 N-Off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2012 Fixed
03 Feb 2013 Fixed
Description
In warm standby replication, when a table is defined with a identity column and its table replication definition is defined with 'send standby all columns' without the identity column, DSI will shutdown when replicate to standby database as identity insert is not set to 'on' when inserting a row.
Workaround Description
 *** Wed Jun 13 2012 11:23:29 GMT+0800 (China Standard Time) *** tning ***



Add the identity column into repdef.



CR:711274
CR Number:   711274
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2012 Not a Bug
Description
A setting of 搊n for parallel_dsi configures these values:

dsi_num_threads to 5

dsi_num_large_xact_threads to 2

dsi_serialization_method to 搘ait_for_commit

dsi_sqt_max_cache_size to 1 million bytes (on 32-bit platform)and 20 million bytes (on 64-bit platform).



With wait_for_commit, DSI will send the next transaction when the previous transaction is ready to commit, but has not finished commit, it may cause data inconsistency at replicate site. An example is:

Step 1. thread 1: begin tran, insert into table A

Step 2. thread 2: begin tran, delete the row thread 1 just inserted

Step 3. thread 1: commit

Step 4. thread 2: commit

The delete at step 2 will affect 0 rows, since the insert at step 1 is not committed yet, leaving the row at replicate database.
Workaround Description
 After setting parallel_dsi to "on", set:

- dsi_serialization_method to wait_after_commit

- dsi_num_large_xact_threads to 0



CR:711507
CR Number:   711507
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2012 Fixed
Description
In rare circumstances, the error message "(HQ Error) Column 'xxx' is missing in target table" is logged in Replication Server errorlog. This is leading HVAR to retry the transaction. However, as the error is rare and random, the retry attempt succeeds most of the times.



CR:712152
CR Number:   712152
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
HQCPL error pkey display is not accurate to the primary key of the repdef -- cannot tell what the real problem is.
Workaround Description
 none



CR:712153
CR Number:   712153
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jul 2012 Fixed
Description
RS stack with ll_first and dsi_validate_row_count
Workaround Description
 none that we are aware of at this time (dsi_row_count_validation was off on this connection at the time of the signal 10)



CR:712288
CR Number:   712288
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   AIX
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jun 2012 Fixed
01 Jul 2012 Fixed
03 Jul 2012 Fixed
02 May 2013 Presently Not Targeted For Any Future Release Of This Product
Description
Turning on dsi_workload counter gives Failed to assert '!((pEntry->obj_stats).statsi_cnt_info[(12)].cnti_status & 0x010)' at 11263, 'eneric/dsi/dsiexec.c'.



CR:712664
CR Number:   712664
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   SunOS
Original Version:   15.7.1 N-Off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Aug 2012 Fixed
Description
Status of DSI is "Awaiting Upgr" after connection has completed upgrade.



CR:712718
CR Number:   712718
Product Name:   Replication Management
Product Component:   Web UI
Status:   Closed
OS:   Windows XP Pro
Original Version:   3.2.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2013 Fixed
06 Aug 2012 Added to user documentation
06 Aug 2012 Added to user documentation
Description
Replication Server collections fail if the server contains no routes



CR:712866
CR Number:   712866
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   AIX
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RS stack with ll_del and sqt_read_from_cache.
Workaround Description
 run the .diag binary and possibly increase sqt cache.



CR:712913
CR Number:   712913
Product Name:   Sybase Replication Server
Product Component:   scripts
Status:   Open
OS:   Linux
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2012 Fixed
Description
rs_init may get a duplicate key error "Attempt to insert duplicate key row in object 'rs_profdetail'

with unique index 'rs_key_profdetail'" and upgrade fails when you try to upgrade Replication Server 15.7 to 15.7.1.
Workaround Description
 In rs_ase_to_oracle_eco.sql:

Change the line:

delete from rs_profdetail where profid = 0x000000000e010000 and pdetailid = 0x000000000e010042

to

delete from rs_profdetail where profid = 0x000000000e010000 and sequence = 67



CR:713269
CR Number:   713269
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   XP
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
beauregard EBF9 24 Sep 2012 Fixed
Description
Using the proxy, the customer is getting intermittent errors when checking in a 40 MB PDM and a 20 MB LDM.



PD is currently in a lab environment. The Proxy and SQL Server database are on different hosts. The Proxy is on a VM and the SQL Server instanced is on a shared host.



In preparation, they began to perform load and stress testing with the repository and have run into the issue that follows.



During a load and stress testing exercise, most models check-in and checkout without issue. However, when performing multiple check-in\outs with their large models, they receive the following errors at different points.



fatal - Exception caught in OnReceive

OdbcError: [S1000] [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt

OdbcError: [S1000] [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server

OdbcError: [S1000] [Microsoft][ODBC SQL Server Driver]Unspecified error occurred on SQL Server. Connection may have been terminated by the server.

OdbcError: [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

OdbcError: [08S01] [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.

OdbcError: [24000] [Microsoft][ODBC SQL Server Driver]Invalid cursor state

OdbcError: [08S01] [Microsoft][ODBC SQL Server Driver]Communication link failure



NOTE: the proxy log includes information for multiple versions of the proxy.



When these errors occur, they encounter deadlocks on SQL Server.



CR:713271
CR Number:   713271
Product Name:   Rep Serv Admin Guide
Product Component:   Rep Serv Admin Guide
Status:   Closed
OS:   all
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2014 Added to user documentation
Description
LOB information in RS Admin Guide Vol 1 is specific to MS SQL and should go into the Heterogeneous manual.



CR:713453
CR Number:   713453
Product Name:   Sybase Replication Server
Product Component:   rsmclient
Status:   Open
OS:   Microsoft Windows
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RSM - Connection Properties, the Error Class is showing incorrect value



CR:713479
CR Number:   713479
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7.1 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Aug 2012 Fixed
Description
ORACLE ONLY: When Replication Agent is

initialized, issuing 'pdb_xlog deinit, force'

returns success when an error message is expected.



CR:713575
CR Number:   713575
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1 N-Off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2012 Fixed
17 Jul 2012 Fixed
Description
HVAR: DSI may shutdown when there is non-compilable command which updates text/image to NULL, and the text/image value length is bigger than 32K or it is compressed.



CR:713596
CR Number:   713596
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Generic
Original Version:   6.0.16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0.18 03 Sep 2012 Fixed
15.7.1 ESD #3 15 Jan 2013 Fixed
22 Jul 2013 Insufficient priority to fix
Description
MICROSOFT SQL SERVER ONLY: Replication Agent goes

down with a NoSuchElementException error when

replicating LOB data.



CR:713649
CR Number:   713649
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Open
OS:   Windows
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
the diagram should be "accessible" by the user by



- PDF export or

- print function which prints the diagram as whole

( which may result in PDF also )



CR:713651
CR Number:   713651
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Open
OS:   Windows
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The bottom line should (including your copyright informations) scale automatically with the hight of the browser window - or should be set by a user parameter to be able to use the full available space



CR:713694
CR Number:   713694
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.6.0.6010ESD01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2012 Presently Not Targeted For Any Future Release Of This Product
Description
Request better handling of Oracle rebalance in asm diskgroup.



CR:713697
CR Number:   713697
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7.1 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Aug 2012 Fixed
31 Jul 2012 Added to user documentation
12 Sep 2012 Diagnostic Provided
Description
ORACLE ONLY: Replication Server's duplicate count

increases unexpectedly because Replication Agent

generates three LTL commands for a single update

to an Oracle table with a column of type Object.
Workaround Description
 For objecttype_rep.tcf{30} in LTL one update in the test has the RAO processing one update as three updates (same update executed 3 times). Not sure if related, in LTL with insert the qauser is prefix with BI, on update it is prefix with BD so the same t_type value has its prefix changed.



In RS log looks like the update is not correctly processed:



T. 2012/07/06 12:03:43. (31): Command(s) to 'o102rh1b.o102rh1b':

T. 2012/07/06 12:03:43. (31): 'update qaquser.qaq_table set t_type=[000000000000

0000000000000000000000000000000000000000000000000000000000] where pkey=2 '

T. 2012/07/06 12:03:43. (31): Last command to 'o102rh1b.o102rh1b':

T. 2012/07/06 12:03:43. (31): Output command: update qaquser.qaq_table set t_typ

e=

I. 2012/07/06 12:03:43. Message from server: Message: 936, State 0, Severity 5 -

- '[ statement ][ o102rh1b ] ociStmt::Execute ORA-00936: missing expression

'.

H. 2012/07/06 12:03:43. THREAD FATAL ERROR #5049 DSI EXEC(104(1) o102rh1b.o102rh

1b) - dsiqmint.c(4413)

The DSI thread for database 'o102rh1b.o102rh1b' is being shutdown. DSI r

eceived data server error #936 which is mapped to STOP_REPLICATION. See logged d

ata server errors for more information. The data server error was caused by outp

ut command #0 mapped from input command #2 of the failed transaction.

I. 2012/07/06 12:03:43. The DSI thread for database 'o102rh1b.o102rh1b' is shutd

own.

I. 2012/07/06 12:04:07. The DSI thread for database 'o102rh1b.o102rh1b' is start





1. Versions



Instance:

RQAV5_21920_RA - Oracle

RepAgent:

Sybase Replication Agent for Unix & Windows/15.7.1.6120ESD01/P/generic/

JDK 7.0/main/6120ESD01/VM: Sun Microsystems Inc. 1.6.0_33/OPT/Fri Jun 2

2 14:31:22 MDT 2012

JRE:

Sun Microsystems Inc. Java(TM) SE Runtime Environment/1.6.0_33-b03/Linu

x 2.6.18-53.el5/amd64/64

RASD:

SQL Anywhere/12.0.1.3152/UNIX

Primary Data Server:

Oracle Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi

t Production

With the Partitioning, OLAP and Data Mining options

PDS JDBC Driver:

Oracle JDBC driver 11.1.0.6.0-Production

RepServer:

Replication Server/15.7.1/P/Linux AMD64/Linux 2.6.18-128.el5 x86_64/1/O

PT64/Sun May 13 18:22:06 2012

RSSD:

SQL Anywhere/12.0.1.3152/UNIX

Sybase JDBC Driver:

jConnect (TM) for JDBC(TM)/7.07 ESD #3(Build 26728)/P/EBF20021/JDK 1.6.

0/jdbcmain/OPT/Mon Mar 19 09:14:34 PDT 2012



(9 rows affected)

1>





2. LTL



5 begin transaction for ~"(QAQUSER osid 140

distribute @origin_qid=~,A{0x}00000000011e576700000001000017da000000cb0018000001

1e576600000001,@origin_time=~*620120706 12:03:33:000,@tran_id=~,O{0x}52514156355

f32313932305f52412e52514156305f32313932305f44434f00000000011e57660006000b00001b5

5 applied owner=~"(qaquser ~"*qaq_table.rs_insert yielding after ~$'t_type=~BIQ

AQUSER.QAQ_OBJ(10, 'Leonardo da Vinci'),~$%pkey=~%"2

distribute @origin_qid=~,A{0x}00000000011e576700000001000017da000000cb0018000001

1e576600000002,@origin_time=~*620120706 12:03:33:000,@tran_id=~,O{0x}52514156355

f32313932305f52412e52514156305f32313932305f44434f00000000011e57660006000b00001b5

5 commit transaction

distribute @origin_qid=~,A{0x}00000000011e576900010001000017da000000cc0010000001

1e576900000000,@origin_time=~*620120706 12:03:34:000,@tran_id=~,O{0x}52514156355

f32313932305f52412e52514156305f32313932305f44434f00000000011e57690002000f00001b0

5 begin transaction for ~"(QAQUSER osid 140

distribute @origin_qid=~,A{0x}00000000011e576900010001000017da000000cc0010000001

1e576900000001,@origin_time=~*620120706 12:03:34:000,@tran_id=~,O{0x}52514156355

f32313932305f52412e52514156305f32313932305f44434f00000000011e57690002000f00001b0

5 applied owner=~"(qaquser ~"*qaq_table.rs_update yielding before ~$%pkey=~%"2

after ~$'t_type=~BDQAQUSER.QAQ_OBJ(20, 'Issac Newton')

distribute @origin_qid=~,A{0x}00000000011e576900010001000017da000000cc0010000001

1e576900000000,@origin_time=~*620120706 12:03:34:000,@tran_id=~,O{0x}52514156355

f32313932305f52412e52514156305f32313932305f44434f00000000011e57690002000f00001b0

5 applied owner=~"(qaquser ~"*qaq_table.rs_update yielding before ~$%pkey=~%"2

after ~$'t_type=~BDQAQUSER.QAQ_OBJ(20, 'Issac Newton')

distribute @origin_qid=~,A{0x}00000000011e576900010001000017da000000cc0010000001

1e576900000000,@origin_time=~*620120706 12:03:34:000,@tran_id=~,O{0x}52514156355

f32313932305f52412e52514156305f32313932305f44434f00000000011e57690002000f00001b0

5 applied owner=~"(qaquser ~"*qaq_table.rs_update yielding before ~$%pkey=~%"2

after ~$'t_type=~BDQAQUSER.QAQ_OBJ(20, 'Issac Newton')

distribute @origin_qid=~,A{0x}00000000011e576a00000001000017da000000cd0094000001

1e576900000000,@origin_time=~*620120706 12:03:34:000,@tran_id=~,O{0x}52514156355

f32313932305f52412e52514156305f32313932305f44434f00000000011e57690002000f00001b0

5 commit transaction





3. Repro:



/RAO/cases/ora_type/objecttype_rep.tcf{30}



CR:713908
CR Number:   713908
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/MsSQL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   6.0.15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2012 Presently Not Targeted For Any Future Release Of This Product
6.1.21 23 Aug 2012 Fixed
To Be Determined 22 Jul 2013 Insufficient priority to fix
15.7.1 ESD #3 08 Mar 2013 Fixed
Description
MICROSOFT SQL SERVER ONLY: You can encounter

deadlocks on the Replication Agent DDL table at

the primary database when more than one DDL

operation is executed in parallel.
Workaround Description
 Do not process "update statistics" and "drop table" in parallel.



CR:713962
CR Number:   713962
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2012 Fixed
21 Aug 2012 Fixed
Description
Replication to IQ not going as fast as expected.

In an environment with only one DSI executor thread, the current group algorithm with SQT cache size as a parameter has a defect, which generates single transaction group.



CR:714035
CR Number:   714035
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   15.7.1 N-Off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jul 2012 Fixed
26 Jul 2012 Fixed
Description
When DSI Bulk Copy or HVAR is enabled, the data is always replicated as OFF ROW when it is configured as IN-ROW in the replicate database.
Target Version
 15.7.1 ESD #1



CR:714114
CR Number:   714114
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.7.1 N-Off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jul 2012 Fixed
07 Mar 2014 Fixed
Description
LOB column got incorrectly changed to NULL when applying multiple updates to the non-LOB column of same row.
Workaround Description
 make the affected table as non-compilable.



CR:714201
CR Number:   714201
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jul 2012 Fixed
Description
ORACLE ONLY: Two files that are needed for

upgrade/downgrade are missing from the Replication

Agent installation.



CR:714328
CR Number:   714328
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   15.6.0.6000
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When restoring to a previous backup of Oracle, make Replication Agent make the process to start replication from those tables, faster.
Workaround Description
 If one has a coordinated RASD, one can do the pdb_xlog init, force to update just the user information of the current Oracle. However, if any of the Oracle object ids have changed (e.g. drop or create table, or certain DDL operations), then the only way around this if one doesn't know the tables, would be to pdb_xlog remove,force then pdb_xlog init and then remark all the tables.



CR:714558
CR Number:   714558
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2012 Fixed
21 Aug 2012 Fixed
Description
RS stack with lll_del_second and mem_free
Workaround Description
 none



CR:714621
CR Number:   714621
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   AIX
Original Version:   15.7.1 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 ESD #2 29 Aug 2012 Fixed
31 Jul 2012 Added to user documentation
Description
ORACLE ONLY: Replication Agent becomes

unresponsive after execution of the

pdb_get_columns command.
Workaround Description
 Be sure to initialize RepAgent (ra_init) prior to making any of the rsm calls.



CR:714775
CR Number:   714775
Product Name:   Real Time Data Services - RepConnector
Product Component:   RepConnector Docs
Status:   Closed
OS:   Generic
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2013 Added to user documentation
Description
DOCS: add RepServer DSI parameters not usable with RepConnector: "dynamic_sql", "dsi_bulk_copy", "dsi_row_count_validation".



CR:714854
CR Number:   714854
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   lelude
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Oct 2012 Fixed
Description
Repository: Order of columns has changed after check out - mapping involved.
Workaround Description
 When updating the model, check the 'Create baseline version' option.



CR:714901
CR Number:   714901
Product Name:   Repository
Product Component:   Repository
Status:   Closed
OS:   all
Original Version:   chambord
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Dec 2012 Not a Bug
Description
Cannot check out glossary anymore -- check in of model has been cancelled



CR:714923
CR Number:   714923
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
Status:   Closed
OS:   all
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2013 Fixed
Description
value for rs_recovery.action is incomplete



CR:714932
CR Number:   714932
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
database repdef with a helping repdef that does not have the image column, will suspend the DSI.
Workaround Description
 use table replication/subscription on this table or add the clause "send standby all columns" to the repdef.



CR:715056
CR Number:   715056
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Management
Status:   Closed
OS:   Generic
Original Version:   15.6.0.6010ESD01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 ESD #3 02 Dec 2012 Fixed
Description
The error message thrown when a user tries to

drop a non-existent replication definition for a

table or procedure is misleading.
Workaround Description
 The command uses the tablename or the procedure name.



CR:715061
CR Number:   715061
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Doc
Status:   Closed
OS:   Generic
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2012 Added to user documentation
Description
rs_drop_repdef is not clear on the value for the parameter "name"



CR:715093
CR Number:   715093
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
After upgrade process is successfully completed by repserver -upgd, a DSI connection to a replicated database may report the error "EXECUTE permission denied on object rs_update_lastcommit ...." and go down.
Workaround Description
 Grant EXECUTE permission to procedures manually.



CR:715230
CR Number:   715230
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Open
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
rs_init flags passwords beginning with rs_ as the first 3 characters, as an error.
Workaround Description
 Do not use rs_ for the first 3 letters of the password, then using isql to alter the password for the apprropriate user to the desired password.



CR:715327
CR Number:   715327
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Open
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
if rs.rs_ltm_rs_pass: exists in the resource file and an outbound only connection is created, a value must be put into the line.
Workaround Description
 comment out the line rs.rs_ltm_rs_pass (by putting a # in the first position of the line)



CR:715374
CR Number:   715374
Product Name:   Other - Docs: Rep Server
Product Component:   Other - Docs: Rep Server
Status:   Closed
OS:   NA
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2013 Added to user documentation
Description
rs_ltm_rs_pass, if it exists in the resource file, must have a password filled in.
Workaround Description
 comment out line rs.rs_ltm_rs_pass



CR:715623
CR Number:   715623
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2013 Fixed
Description
Null pointer received during resume resync
Workaround Description
 We think this is due to the fact that the customer did a ra_init force prior to running resume resync.



However, the in the resync procedure, this is one of the options.



Total workaround is to not use these procedures.



CR:715716
CR Number:   715716
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 ESD #3 21 Nov 2012 Fixed
15.6 ESD #2
15.7.1 ESD #3 10 Jun 2013 Added to user documentation
Description
If the version of Replication Server that

connects to Replication Agent is 15.5 or

later, Replication Agent no longer addes

the 'replicate minimal columns' clause when

creating replication definitions.
Workaround Description
 After the repdef is generated, alter the replication definition to remove the minimal columns override.



CR:715769
CR Number:   715769
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   Management
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2012 Fixed
20 Sep 2012 Fixed
21 Sep 2012 Fixed
Description
Replication Agent instance may fail to start up

after an in place upgrade from earlier versions

to 15.7.1 GA or later release.



CR:715840
CR Number:   715840
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1 N-Off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2012 Fixed
02 Aug 2012 Fixed
Description
An off-row compressed lob is replicated compressed however is in-row at replicate.



CR:715845
CR Number:   715845
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
Status:   Closed
OS:   NA
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2013 Fixed
Description
admin stats,max_mem_use not documented in 15.7.1



CR:715974
CR Number:   715974
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   HP-UX
Original Version:   15.7.1 N-Off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2012 Fixed
Description
Transactions in outbound queue are re-applied after upgrade



CR:715987
CR Number:   715987
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2012 Fixed
Description
Replication Server was not freeing memory used to access repdef during normalization.



CR:716462
CR Number:   716462
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Stack in memcpy, _sqm_read_logical_block
Workaround Description
 Rollback to previous RS binary



CR:716468
CR Number:   716468
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   RH Linux
Original Version:   15.7.1 N-Off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2012 Fixed
Description
IBM PSeries and IBM AIX64: If an error occurs during seamless upgrade, Replication Server could stack



CR:716499
CR Number:   716499
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.7.1 N-Off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2012 Fixed
Description
After upgrade, rs_funcstrings is not using datarows lock scheme



CR:716558
CR Number:   716558
Product Name:   Sybase Replication Server
Product Component:   rs_init
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2012 Fixed
carina 20 Jun 2013 Added to user documentation
21 Aug 2012 Fixed
Description
Added new documented rs_init trace "SKIP_WINDOWS_SERVICE". When used, rs_init will not create Windows services, or update the Windows registry.



CR:716569
CR Number:   716569
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide a method to skip commands for a table in the inbound queue so that the command is not processed by the distributor, yet can process the rest of the commands in the transaction.



CR:716634
CR Number:   716634
Product Name:   Common Metadata Repository
Product Component:   Web UI
Status:   Open
OS:   Windows
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Repository user permissions are incorrect for packages of a model when viewed in the Portal.



In the PD client, a repository user has the List permission defined at the package level of a model. When logged into the Portal with this user and accessing the model via the Repository Explorer, the permissions assigned for the packaged are not applied. It appears that the permissions assigned to the model are cascaded down via the packages.



CR:716665
CR Number:   716665
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   NA
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Aug 2012 Fixed
Description
admin version, "connection" states "Database needs upgrade." when it is already at the correct version.
Workaround Description
 workaround would be to run the same queries the code is attempting to do in the ds.db to verify the database connection has been upgraded ...



select count(*) from sysobjects where name = 'rs_dbversion' and type = 'U'

first select should report ... 1



select last_rssd_ver from rs_dbversion

second select should report ... rs1571



CR:716735
CR Number:   716735
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When updating models to the repository, shortcuts that only have changes to their name and\or code are not updated to the repository.



This occurs for any model type



To reproduce:





1) create a CDM

2) create a package

3) add three entities to the package

4) add all three entities as shortcuts on the Model default diagram

5) check in model

6) in the package, change the name of entity_3 to test_3

7) check in the model

NOTE: the change is not reflected on the entity_3 shortcut

8) add an attribute to test_3

9) check in the model

NOTE: entity_3 shortcut has been changed to test_3



CR:716760
CR Number:   716760
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.6 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhance DSI message in MSA that states it has processed the enable marker.



CR:716964
CR Number:   716964
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7.1 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7.1 ESD #2 28 Aug 2012 Fixed
15.7.1 ESD #3 22 Oct 2012 Presently Not Targeted For Any Future Release Of This Product
Description
ORACLE ONLY: Replication Agent encounters a

NullPointer Exception when replicating SecureFile

LOB data.



CR:717234
CR Number:   717234
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.6 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sqm_zap_command and sqm_zap_tran do not take effect with only hibernate. One must reboot the RS for the command or transaction to work.
Workaround Description
 After zapping the command or transaction, reboot the Rep Server.



CR:717386
CR Number:   717386
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Error 16227 Unknown token TDS stream logged in RS -- shuts down RS
Workaround Description
 Shutdown Sybase Central or Sybase Control Center or anything that might be monitoring the Replication Server.



CR:717466
CR Number:   717466
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Would like to replicate Oracle packages



CR:717508
CR Number:   717508
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   6.1.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2012 Fixed
Description
ORACLE ONLY: Replication Agent does not provide

an informative error message when initialization

fails due to required permissions not being set.



CR:717560
CR Number:   717560
Product Name:   Repository
Product Component:   Repository
Status:   Open
OS:   all
Original Version:   beauregard
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The customer would like to have named path _CHECKOUT or something like that, so each time when a model is checked out from repository, the check out path is automatically set to _CHECKOUT value.



The customer does not like the fact that PD checks out (extracts) the model to the last saved location that is stored in the model. There attempts at defining a named path variable does not work for them.



CR:717579
CR Number:   717579
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   NA
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2012 Fixed
Description
ORACLE ONLY: Replication Agent returns an

incorrect error message when querying a LOB value

against the primary database fails.
Workaround Description
 The actual error message can be found only if tracing is enabled



T. 2012/08/23 15:59:03.988 LRTRACE com.sybase.ds.oracle.logmnr.lob.OracleLOBRead LOB: Failed to execute query for LOB Reader. Caught exception <SQL execution failed.

T. 2012/08/23 15:59:03.988 LRTRACE com.sybase.ds.oracle.logmnr.lob.OracleLOBRead SQL ERROR --

T. 2012/08/23 15:59:03.988 LRTRACE com.sybase.ds.oracle.logmnr.lob.OracleLOBRead Message: ORA-01031: insufficient privileges

T. 2012/08/23 15:59:03.988 LRTRACE com.sybase.ds.oracle.logmnr.lob.OracleLOBRead

T. 2012/08/23 15:59:03.988 LRTRACE com.sybase.ds.oracle.logmnr.lob.OracleLOBRead SQLState: 42000

T. 2012/08/23 15:59:03.988 LRTRACE com.sybase.ds.oracle.logmnr.lob.OracleLOBRead Remote Code: 1031

T. 2012/08/23 15:59:03.988 LRTRACE com.sybase.ds.oracle.logmnr.lob.OracleLOBRead Message: SQL execution failed.> . SQL <select FIELD_RAWSTRING from SAPSR3.ZEB_BLOB WHERE MANDT='000' AND FIELD_CHAR='1_KEY_123'> for operation ID <0x0000.00f53d39.0000:0001.0000069c.000117e4.0018> and article <SAPSR3.ZEB_BLOB, ID=[201715], NAME=[ZEB_BLOB], TYPE=[0], STATUS=[Current], VERSION=[[GENID=0][SCN=16038630][SCNGENID=0][THREAD=1][LSN=1691][BLK=0][OFF=0][OATSCN=16038630][UNIQUE=0]], Columns=[MANDT(VARCHAR2), FIELD_CHAR(VARCHAR2), FIELD_RAWSTRING(BLOB), FIELD_STRING(CLOB)]>

T. 2012/08/23 15:59:04.016 LRTRACE com.sybase.ds.oracle.logmnr.lob.SeparatedLobC Lob processing fail with exception <Could not connect to PDB for direct query for operation ID <0000.00f53d39.0000:0001.0000069c.000117e4.0018> and article <SAPSR3.ZEB_BLOB, ID=[201715], NAME=[ZEB_BLOB], TYPE=[0], STATUS=[Current], VERSION=[[GENID=0][SCN=16038630][SCNGENID=0][THREAD=1][LSN=1691][BLK=0][OFF=0][OATSCN=16038630][UNIQUE=0]], Columns=[MANDT(VARCHAR2), FIELD_CHAR(VARCHAR2), FIELD_RAWSTRING(BLOB), FIELD_STRING(CLOB)]> because: SQL execution failed.>.

T. 2012/08/23 15:59:04.026 LRTRACE com.sybase.ds.oracle.logmnr.lob.SeparatedLobC priorSQL: [NULL] postSQL: [NULL] state: [com.sybase.ds.oracle.logmnr.lob.state.OffRowLobQueryFromPDBState@1e3380c5] article: [ZEB_BLOB]



CR:717595
CR Number:   717595
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Solaris
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RS stacks when getting memory for the parser.



CR:717668
CR Number:   717668
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.7.1 N-Off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2012 Added to user documentation
Description
Insufficient licenses message in Replication Server log reports incorrect available number of CPUs when CPU is added.
Workaround Description
 The message is reported twice in the Replication Server log. The message reports incorrect number of CPUs the first time and correct number of CPUs the second time.



CR:717914
CR Number:   717914
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   6.0.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2012 Fixed
Description
ORACLE ONLY: Replication Agent encounters

a Null Pointer Exception when replication

is suspending.



CR:717919
CR Number:   717919
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2012 Fixed
Description
The replication for row changes on rs_databases may fail upon downgrade to pre155



CR:717925
CR Number:   717925
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   AIX
Original Version:   15.7.1 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2012 Fixed
Description
ORACLE ONLY: If two Oracle procedures have the

same name but different owners, and if we have

already marked one of them for replication and

attempt to mark the other, the second mark

operation will fail.



CR:717932
CR Number:   717932
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Solaris
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jan 2013 Fixed
25 Mar 2013 Fixed
24 Jul 2013 Fixed
07 Mar 2014 Fixed
Description
Wrong date and time values may be replicated or DSI thread may go down due to a 3814 error (The parameter of type 111 did not have a valid value.) if both "dynamic_sql" and "dsi_bulk_copy" parameters for the connection are ON and RS_language is not us_english.



CR:717954
CR Number:   717954
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.6 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Sep 2012 Fixed
04 Sep 2012 Fixed
Description
FOR ORACLE:When Rep Agent drops replication

definition by rs_drop_repdef,

the action is not put into the log.
Workaround Description
 Validate that the repdef was dropped by looking for the repdef in the RSSD:

select objname from rs_objects where phys_tablename = '<tablename>'



CR:718072
CR Number:   718072
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New admin command to report which trace flags are currently enabled in the server.



CR:718107
CR Number:   718107
Product Name:   Rep Serv Commands Ref
Product Component:   Rep Serv Commands Ref
Status:   Closed
OS:   all
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2013 Added to user documentation
Description
Table rs_dbversion is not documented in the Commands Reference Manual.
Workaround Description
 1> sp_help rs_dbversion

2> go

Name Owner Object_type

Object_status Create_date

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

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

rs_dbversion dbo user table

-- none -- Aug 10 2012 2:50PM



(1 row affected)

Column_name Type Length Prec Scale

Nulls Not_compressed Default_name

Rule_name Access_Rule_name

Computed_Column_object Identity

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

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

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

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

last_rssd_ver int 4 NULL NULL

0 0 NULL

NULL NULL

NULL 0

min_compat_ver int 4 NULL NULL

0 0 NULL

NULL NULL

NULL 0

Object does not have any indexes.

No defined keys for this object.

name type partition_type

partitions partition_keys

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

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

rs_dbversion base table roundrobin

1 NULL



partition_name partition_id

compression_level pages row_count

segment create_date

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

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

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

rs_dbversion_912003249 912003249

none 1 1

default Aug 10 2012 2:50PM



Partition_Conditions

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

NULL



Avg_pages Max_pages Min_pages Ratio(Max/Avg)

Ratio(Min/Avg)

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

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

1 1 1 1.000000

1.000000

Table LOB compression level 0

Lock scheme Allpages

The attribute 'exp_row_size' is not applicable to tables with allpages lock

scheme.

The attribute 'concurrency_opt_threshold' is not applicable to tables with

allpages lock scheme.



exp_row_size reservepagegap fillfactor max_rows_per_page identity_gap

ascinserts

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

-----------

1 0 0 0 0

0



(1 row affected)

concurrency_opt_threshold optimistic_index_lock dealloc_first_txtpg

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

0 0 0

(return status = 0)

1>



CR:718153
CR Number:   718153
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.7.1 N-Off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Dec 2012 Duplicate
Description
ERROR #60021 USER( ) - i_thread.c(160) Open Server failed to create the 'csimutex017485186' mutex. (160)



CR:718159
CR Number:   718159
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7.1 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Sep 2012 Fixed
Description
ORACLE ONLY: If Replication Agent replicates a

table with more than one LOB column and if more

than 1MB of data is inserted into any of the LOB

columns, replication will fail.



CR:718205
CR Number:   718205
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RepServer DSI will fail with error #5038 or #5213 if it uses a function string to call a stored procedure that returns a status value of -1.
Workaround Description
 Don't return -1 from RS invoked stored procedures.



CR:718342
CR Number:   718342
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   HP-UX
Original Version:   15.7.1 N-Off
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Aug 2013 Fixed
04 Jun 2013 Added to user documentation
Description
Reference Implementation fails because rs_init requires a non-NULL password for Replication server initialization.
Workaround Description
 Provide not-null password for sa user in the config file



CR:718442
CR Number:   718442
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   Linux
Original Version:   15.6 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
stack in distributor with "A bad switch value"
Workaround Description
 instead of purging queue like what was done, we brought up diag RS with distributor suspended....then started up RA....(which added to the inbound queue), then resumed distributor. Unfortunately, RS crashed again when turned off trace, however, it did run successfully for 3 hours prior to the second crash.



CR:718445
CR Number:   718445
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Support geospatial datatypes in Oracle



CR:718451
CR Number:   718451
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Open
OS:   NA
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Replicate Oracle geospatial datatypes



CR:718452
CR Number:   718452
Product Name:   Rep Server Connectors
Product Component:   Oracle OCI Connector
Status:   Open
OS:   Generic
Original Version:   15.7.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request to replicate geospatial datatypes



CR:718476
CR Number:   718476
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7.1 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Sep 2012 Fixed
Description
Stack trace occurs when no queue type is provided in "sysadmin issue_ticket" command.



CR:718540
CR Number:   718540
Product Name:   Sybase Replication Server
Product Component:   repserver
Status:   Closed
OS:   Linux
Original Version:   15.6 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 May 2013 Presently Not Targeted For Any Future Release Of This Product
19 Oct 2012 Fixed
03 Feb 2013 Fixed
Description
Oracle RDB reports "SQL command not properly ended" when using dbresync with ECO.
Workaround Description
 1. If the DSI is using oracle function string class, apply the following scripts directly in the Repserver system database and then restart RS.



delete rs_systext where parentid= 0x000000000ffffd2a

insert into rs_systext values(0, 0x000000000ffffd2a,'O',1,'delete from rs_lastcommit where origin = ?rs_origin!sys? ; insert into rs_lastcommit values (?rs_origin!sys?, HEXTORAW(''000000000000000000000000000000000000000000000000000000000000000000000000''),')

insert into rs_systext values(0, 0x000000000ffffd2a,'O',2,'HEXTORAW(''000000000000000000000000000000000000000000000000000000000000000000000000''), sysdate, sysdate) ; commit')



2. If the DSI is using a user created function string class, then we can use 'create function string' to update the function string for rs_reset_lastcommit:

create function string rs_reset_lastcommit

for private_function_class with overwrite

output language 'delete from rs_lastcommit where origin = ?rs_origin!sys? ; insert into rs_lastcommit values (?rs_origin!sys?, HEXTORAW(''000000000000000000000000000000000000000000000000000000000000000000000000''),HEXTORAW(''000000000000000000000000000000000000000000000000000000000000000000000000''), sysdate, sysdate) ; commit'



CR:718566
CR Number:   718566
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   6.0.10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Nov 2012 Fixed
26 Feb 2013 Fixed
27 Feb 2013 Fixed
Description
ORACLE ONLY: Replication Agent goes down with

error "Replication Server refused the following

invalid LTL command" when replicating a table

containing a NUMBER column and the value

contains an incorrect number of digits.



CR:718647
CR Number:   718647
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Closed
OS:   Generic
Original Version:   15.7.1 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2012 Fixed
Description
ORACLE ONLY: Replication Agent may hang during

LOB processing.



CR:718659
CR Number:   718659
Product Name:   Sybase Replication Agents for Unix and Windows
Product Component:   RepAgent/Oracle
Status:   Open
OS:   Generic
Original Version:   15.6.0.6010ESD01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide option to create all or drop all repdefs.
Workaround Description
 Build a script to do it. Nothing available in Replication Server or in Replication Agent.





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复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
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集  包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

本工具的应用场景:

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