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

SAP Adaptive Server Enterprise的所有已知BUG列表(1)

随着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信息!
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

Adaptive Server Enterprise的所有已知BUG列表(1)
Adaptive Server Enterprise的所有已知BUG列表(2)
Adaptive Server Enterprise的所有已知BUG列表(3)
Adaptive Server Enterprise的所有已知BUG列表(4)
Adaptive Server Enterprise的所有已知BUG列表(5)
Adaptive Server Enterprise的所有已知BUG列表(6)
Adaptive Server Enterprise的所有已知BUG列表(7)
Adaptive Server Enterprise的所有已知BUG列表(8)
Adaptive Server Enterprise的所有已知BUG列表(9)
 

CR
Number
Description
279309 Using BCP with packetsize larger than 32767 may fail on ASE running on the windows NT, Linux and Dec Alpha platforms.
279344 ASE Replicator: Sporadically, text/image replication fails when running for a long time.
279406 A 551 error or the message "current process infected with 11" is reported in the error log together with a stack trace when a row is inserted into a table that has a rule which references a constant value which is outside the range of the column datatype.
279474 Check constraint expression shows name of the constraint along with the defination. This happens only when user changes the constraint name in the property page and applies the changes.
279520 When a connection is terminated while running Java, the message "Java services are temporarily unavailable while the Java system is being recycled" is reported in the error log and all other Java operations may be terminated so that no further Java operations can be performed. All subsequent attempts to use Java in ASE are rejected with a 10734 error.
279558 CIS : Performance slows down when there are many idle CIS connections within ASE.
279568 The message "current process infected with 11" together with stack trace which includes the module 'jvmh_mem_p_sema' will be reported in the error log if a reference is made to a Java class before recovery has completed.
279595 If the source ASE has large free spaces in the logical devices and runs Migration Tool in "setup" session, Migration Tool will throw the IndexOutOfBoundsException error in "CALC_DEVICE_SIZE" thread.
279606 ASE 12.0 used to send back the actual table name in the row format information when responding to PowerBuilder. Now with ASE 12.5 the view name is sent back in the row format information instead of the actual table name and this causes PowerBuilder to try an update against the view instead of the actual table.
279616 ASE Replicator: During initial setup, an instance directory is created and RUNinstance scripts are generated. On Unix, the RUNinstance script also has its permissions changed to include execute permission. If there is a problem setting the permissions, an uninformative error message is returned, and the sp_helpddb.sql script does not get generated which causes problems later on. Now, the sp_helpddb.sql script is generated first, and, if there is any problem setting permission on the RUNinstance script, a warning is logged in the system.log, but setup completes successfully. The user will have to manually set the proper execute permissions on the RUNinstance script.
279617 A request to allow aliases to the real server name

to be used with kerberos network based security feature

SAP Replication Server的所有已知BUG列表(3)

随着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信息!
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

Replication Server的所有已知BUG列表(1)
Replication Server的所有已知BUG列表(2)
Replication Server的所有已知BUG列表(3)
 

CR
Number
Description
685119 MICROSOFT SQL SERVER ONLY: Replication Agent

encounters a java.lang.NullPointerException

when resuming replication after changing the

maintenance user id.

685330 When creating a replication definition, the Replication Manager Plugin incorrectly uses the datatype numeric for identity columns. The default value should remain as an identity datatype.
685331 Create subscription with atomic materialization puts text data to incorrect row.
685438 Customer is RepServer 15.6 GA under AIX platform.

Customer have installed "rs_install_statreport_v1510_ase.sql".

When Customer populate statistics using "rs_stat_popultae", this store proc call "rs_stat_populate_netspd" which report duplicate key error:

1> rs_stat_populate

2> go

We are going to populate report. Script version 1510. :-)

Msg 2601, Level 14, State 2:

Server 'SYBASE_MEDISREP2', Procedure 'rs_stat_populate_netspd', Line 189:

Attempt to insert duplicate key row in object 'rs_statreport' with unique index 'rs_key_statreport'

Command has been aborted.

SAP Replication Server的所有已知BUG列表(2)

随着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信息!
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

Replication Server的所有已知BUG列表(1)
Replication Server的所有已知BUG列表(2)
Replication Server的所有已知BUG列表(3)
 

CR
Number
Description
494288 ORACLE ONLY: The device status returned by

ra_helpdevice is incorrect if the device is

stored under ASM.

494320 The RMS heartbeat process has been enhanced to use the new rs_ticket version 2.0 feature if the controlling Replication Server is version 15.1 or higher. The RMS will retrieve ticket information from the rs_ticket_history table.
494368 Repserver cannot convert EUC half size kana into SJIS half size kana correctly.This issue is reproduced when the character codes of REP and IQ differ. ASE(EUCJIS) -> REP(SJIS) -> IQ(EUC_JAPAN)
494611 cannot use "use dump marker" clause with XPDL process
494701 When you run the pdb_get_columns command, incorrect

datatypes are returned for varchar(max), nvarchar(max), and varbinary(max)

datatypes.

Workaround: Ensure that the replication agents in your replication environment

are version 15.1 ESD #1.

494740 RepConnector is creating file EAServer\bin\mqjms.trc and it keeps growing and consuming disk space.

SAP Replication Server的所有已知BUG列表(1)

随着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信息!
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

Replication Server的所有已知BUG列表(1)
Replication Server的所有已知BUG列表(2)
Replication Server的所有已知BUG列表(3)
 

CR
Number
Description
214559 1. Create a new user and attach it to a group having the Connect RIght.

2. Go to the Rights tab of the User prop sheet. Note that the Connect right has not been added to the user.

We should have a mechanism a checked-grayed box for inherited rights.

It could also be a "show inherited rights" icon like in member tab for a group.

221815 7.5.0.715

BUG when creating repository tables. No confirmation message to say "Finished creating tables."

I know that this is not a major issue, but from the customer's perspective, they need to know when a PowerDesigner process has completed.

224873 7.5.0.739

During consolidation of large models, PD shell stops responding to Windows (doesn't update display, etc). Need more than just "Saving the local document in the repository..."

1) Import model into PD7 and save it

2) Then consolidate that model into your favorite repository.

3) When it gives you the "Saving the local document..." message, launch the TaskManager and check out the PowerDesigner program.

NOTE: It will be listed as "Not responding".

4) If you have another application open, move its window around in front of the PD GUI.

Notice that it doesn't refresh the display. This is not good.

It takes a long time (anything over a minute or so is too long, but I'm talking 30 minutes and longer here) before it will update the GUI.

What I want to see is more GUI refreshes and some kind of status update in the message window, like what happens when I Reverse Engineer a database. The old MetaWorks gave me more information than this when it was working. Just giving me an hourglass is not acceptable

SAP SDK的所有已知BUG列表

随着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信息!
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

CR
Number
Description
273145 Linux post install script, SWR 9803 and 9939 RPM, does not install new files that are not installed during GA/Rollup release.
279302 When executing remote procedure using "ctisql", an additional message (eg. 1 row affected) is printed while dbisql does not show this message.

Resolution: Reviewed Sep 2002. Presently not targeted for any future release of the product as changes between dblib and ctlib based isql are expected. This is documented in the 11.1 'Release Bulletin Open Client/Server' manual, section on 'Standalone Utilities'.

There are several differences between dblib and ctlib based isql. A change so late in the game could cause a regression to scripts at other customer sites.

279451 OCC does not support the TDS 5.0 Returm Parm format.
279892 OSC 12.5 EBFI0335 not freeing up one of the 2 TDSPROCS which are allocated, leaving 1524 bytes of shared memory around below is a code frag from CTDSMS stdfree routine.
280053 OCC MVS 3.2 EBF6780 not process Cancel correctly ctbreults fails
280245 Add gatewayless support for sgw_setserver rpc
280283 OLEDB: adTinyInt datatype in ADO application, when used as a parameter in a stored procedure, caused an error: "The given type name is unrecognized." Sybase ASE tinyint datatype was not supported as parameter in stored procedure. It is now.
286543 CPRE: cpre core dumps on structure declarations as a result of the fix to CR 254863.
286574 OCC 12.5 problems with ASE 12.5 support
286671 Because of an error in the jConnect metadata, customers using ASA7 or higher could not take advantage of the Dynamic Class Loading feature in jConnect. That bug has been fixed.
286966 ESQL: COBPRE produces invalid area A code when used in /terminal mode on VMS

SAP IQ的所有已知BUG列表

随着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信息!
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

CR
Number
Description
297099 Adaptive Server IQ parsed a query incorrectly when the query

combined the CONTAINS predicate and an 'Into #temp' clause.

297235 A query takes 25min to get a query plan while the execution only need 1 seconds.

This happens in version 12.4.3 ESD7.

300063 The IQ server has 2 user event enabled. The event actions gete executed very 3 seconds and contain an INSERT... LOCATION statement. If you stop and start the IQ server the events cannot be executed because if the error:

Exception Thrown from hqm_con.cxx:102, Err# 1, tid 264 origtid 264

O/S Err#: 0, ErrID: 8192 (hqm_exception)

CtLibrary Error: 141, Severity: 0, Origin: 1, Layer: 1

Error Message: ct_con_props(SET,PASSWORD): user api layer: external error: buflen must be 0 or CS_UNUSED when buffer is NULL.

OS Error: 0, OS Message: .

-- (hqm_con.cxx 102)

Probelm reason:

The INSERT... LOCATION statement always takes the user and password from the

current connection to connect to an ASE server. The catalog stores the password

only as hash value created by an one-way algorithm for security reason.

So the password string is not available for the event execution before the end user

using this username has connected to ASIQ.

As soon as an user has connected using the username all subsequent INSERT... LOCATION

in events work file

Its not possible to fix this problem without added new syntax or an new feature.

i'm going to create an Enhancement Request for this.

master数据库配置区域(configuration area)损坏的一种修复方法

本文提供master配置区域损坏的一种修复方法!

Sybase ASE master数据库的前2048字节存储着Sybase数据库服务器的configuration area(配置区域)。如果configuration area corrupt,那么Sybase服务器无法启动。

造成configuration area corrupt的原因一般为硬件故障。通过下面的案例分享configuration area corrupt的一种恢复方法。

背景:

版本:ASE 15.0.3 ESD#3

在通过临时设置参数upgrade version为492来重置sa口令为空时,忘记将upgrade version改回原值 (参考:将Sybase ASE登录sa的密码置为空NULL的方法)。之后重启Sybase服务器时报错:

Pre 10.0 database cannot work with this version of the server. Please upgrade the databases to 10.0 or above release and then try to start with this version of the server. Shutting down ***.

ASE配置文件(*.cfg)中大多数情况下不存在参数:upgrade version。在cfg中添加upgrade version=15000后,启动时仍然报上面的master数据库版本低于10.0的错误。

通过比较多个版本的configuration area,发现master数据库的第1805和第1806字节表示upgrade version,15000的十六进制形式为:0x3A98,则将第1805字节改为98,第1806字节改为3A(此处master为linux平台上的数据库)。改为之后启动报错:

The configuration area in device '/home/sybase/data/master.dat' appears to be corrupt. The server cannot continue and will shut down.

看来仅仅修改2个字节的内容无法验证通过,那么通过替换master数据库头部2048字节呢? 我测试是可行的!

DB-Engines数据库排名 Sybase跌出前10(转)

【IT168 资讯】 DB-Engines于近日发布2014年12月份的数据库系统排名。这个排行榜和TIOBE编程语言排行榜一样权威,在每个月的上旬发布。根据数据库的受欢迎程度进行排名。与之前的比较,整个排名并无太大变化,尤其是前三位。

  根据排行榜显示,Oracle居首,而开源的MySQL数据库排名第二,SQL Server位列第三,原本第十名的Sybase ASE被非关系型数据库Redis所取代,而Sybase ASE则跌至第十一名。Redis是内存数据库,在本月的增长较大。到目前为止,前十名中的NoSQL数据库占了三席分别是MongoDB、Cassandra和Redis。