提供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:304314
CR Number:   304314
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
An OLE datawindow contains a .doc file with several (14 or 15) pages. But only the first page prints from PowerBuilder.



CR:304319
CR Number:   304319
Product Name:   PB Enterprise
Product Component:   Migration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2003 Not a Bug
Description
Creating an app in either build 5049 or 5051 and then

opening the same app in an earlier build (such as build 4510) will result in

a target error--Cannot open target.



If you try to create a new target, a message will display saying that the target

already exist.



CR:304374
CR Number:   304374
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Closed
OS:   Solaris 2.6
Original Version:   8.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2009 DEFER
Description
On window platform, it is allow to specify property "lds_tmp.object.datawindow.print.filename" to generate a printer file with the filename. On Solaris PBVM, the setting is totally ignore and only generate the default filename "jaguar.ps"
Workaround Description
 No workaround



CR:304427
CR Number:   304427
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 01 Oct 2003 Fixed
Description
Memory leak and hitting Virtual Byte limit using PB component on EAServer, db-ASE.



CR:304476
CR Number:   304476
Product Name:   PB Enterprise
Product Component:   PBNI
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 15 Jan 2003 Fixed
14 Feb 2003 Fixed
Description
PBNI extension crashes when passing enumerated type argument.



CR:304491
CR Number:   304491
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 10 Apr 2003 Fixed
Description
"OLE Object Properties" button disabled on standard visual objects of OLEControl type when put on a window.



CR:304501
CR Number:   304501
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 27 Jan 2003 Fixed
Description
Regression in 8.0.3 starting in build 9820: Gpf when trying to return a structure populated in a userobject function after a response window is opened and closed.

Fixed in build 9860.



CR:304549
CR Number:   304549
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2007 Fixed
Description
When creating a Web Service proxy using the proxy wizard, after poining to the wsdl file and executing the project the error:

"Generation Errors:

Error: The object getsubscriberinfoport had fatal compile error(s).

The source for getsubscriberinfoport has been saved as C:\TEMP\getsubscriberinfoport.srx.

The error(s) for getsubscriberinfoport have been saved in file C:\TEMP\getsubscriberinfoport_srx.log

appears.



CR:304554
CR Number:   304554
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Feb 2003 Fixed
08 Feb 2003 Fixed
08 Feb 2003 Fixed
Description
Change EAServer deployment options to reflect best practices and new features.



CR:304565
CR Number:   304565
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If no workspace is opened, allow to do a New->Target->Application and then automatically create a workspace as well.



CR:304567
CR Number:   304567
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide MouseEnter and MouseLeave events for all graphic objects.



CR:304581
CR Number:   304581
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2003 Presently Not Targeted For Any Future Release Of This Product
Description
Active Reports Runtime OCX not working correctly in PowerBuilder.
Review Status
 09/-8/2003:

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".



CR:304793
CR Number:   304793
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2003 Fixed
Description
When modifying a list of local external functions, even just adding and then removing a character leaving a net change of nothing, renders the object un-saveable and various compilation errors occur.



CR:304798
CR Number:   304798
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 14 May 2003 Fixed
Description
Issues using SetLibraryList with a PowerBuilder EAServer component need to be addressed in PowerBuilder 8. This CR suggests a possible workaround for PB 8.



CR:304799
CR Number:   304799
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Editmask not displaying last character when autoskip is checked, and code in the em modified event does something that takes some time.



CR:304844
CR Number:   304844
Product Name:   PB Enterprise
Product Component:   DataBase
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to be able to paste fetch SQL for locally declared stored procedures.



CR:304901
CR Number:   304901
Product Name:   PB Enterprise
Product Component:   Font
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2003 Third Party Problem
Description
OS: Win32

Versions and Build #s Reported: 8.03.9704

Versions and Build #s Tested: Fails with ALL controls 8.0 GA -> 8.0.2.9506

Partially working 7.03/ 8.02.9601 -> 8.03.9850 / 9.0 Beta 4



Russian characters are not displayed correctly with certain controls when using ARIAL CYR font.

From PB 8.0 GA to 8.02.9506 NO controls could display non latin characters with ARIAL CYR font

From PB 8.02.9601 -> 8.0.3.9850 the following controls DO NOT display russian chars with ARIAL CYR font (only latin chars are displayed)

- CommandButton

- CheckBox

- RadioButton

- GroupBox

- DropDownListBox



All other controls that support fonts (ie not draw objects) now display the Russian chars correctly.



See repro steps for more details.



Possible related CRs

CR 268163

CR 274273 - fixed but not for ARIAL CYR font

CR 300884



Reviewed by PB Engineering and determined not to be a PB bug:

This is a Microsoft issue. The same behaviour can be found using a simple VisualBasic example or VisualC++ app. A summary of engineer's conclusions:

There are some limitations in displaying cross-codepage data in some of the Microsoft Common Controls. For example when displaying Russian on a U.S. English machine the Microsoft Edit control can properly render the text but the Microsoft Button control cannot display properly.

In PowerBuilder, Button and Edit controls are implemented by using underlying Microsoft button and edit controls respectively and hence any flaw in the Microsoft controls also appears in the PowerBuilder controls. The problem is happening in PB CommandButtons, CheckBox, RadioButton and GroupBox because these are all different versions of the same Microsoft Button Control with a different style.

The problem is not happening for the PB PictureControl because in this case the display of the control is achieved after overriding the normal display behaviour of Microsoft button control (this is the same with the PictureButton).



One easy workaround for the problem is to change the "Regional setting" to the corresponding language, for example for Arabic the steps would be...



1. Open the "Regional Settings Properties" dialog from Control Panel of any Windows platform (NT/2K/XP);

2. Focus on the first tab page of "Regional Settings", on Win-2K platform you can see a dropdown listbox on upper side

and a list of checkboxes on the bottom. Choose "Arabic (Saudi Arabia)" option from the dropdown listbox, and check the

"Arabic" option checkbox from "language settings for your system", highlight this option (in blue)

3. Important ! Click on the button "Set as default " at bottom left corner of the dialog

Click "OK" to close the dialog and Windows will ask you to restart your system.

4. After your system is restarted, run PB or VB application again, you will see correct display of Arabic characters

on either Command Buttons as well as other controls.
Workaround Description
 None



CR:304902
CR Number:   304902
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2005 Fixed
Description
When dw_1.Update() is called on a datawindow with INPUT / OUTPUT parameters to stored procedures, PB crashes. -> GPF



Different behvior depending on used DBMS interface:



ODBC gives error:

SQLSTATE = 22005

[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification



No changes made to database.



execute dbo.ap_UpdateBigParms;1



OLEDB and native:

GPF / Exception

Exception code: C0000005 ACCESS_VIOLATION

File Name: C:\Program Files\Sybase\Shared\PowerBuilder\PBDWE80.dll

File Version: 8.0.3.9850

Fault address=1164435C Section:Offset=01:0014335C



Registers:

EAX:00000000

EBX:07CE0010

ECX:07CF1920

EDX:00007340

ESI:07CD5628

EDI:00000000

CS:EIP:001B:1164435C

SS:ESP:0023:0012E494 EBP:0723B260

DS:0023 ES:0023 FS:0038 GS:0000

Flags:00010202



Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

1164435C 0723B260 FFFFFFFF 00000000 00000000 0723B280 0001:0014335C C:\Program Files\Sybase\Shared\PowerBuilder\PBDWE80.dll
Review Status
 *** Wednesday, May 11, 2005 15:13:58 ***

This CR was reviewed and closed as part of the Quarterly CR Review process.

Its fixed in PB 10 build 8011.



CR:304903
CR Number:   304903
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 03 Jun 2003 Fixed
Description
PB ignores the hardcoded filename when using Print command when called by a Jaguar Component. It displays the input dialog on the Jaguar server despite the hardcoded filename to receive the filename from the user. If the user inputs the filename it prints it to the respective file correctly.



CR:304910
CR Number:   304910
Product Name:   PB Enterprise
Product Component:   P-Code Exe Creation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2003 Presently Not Targeted For Any Future Release Of This Product
Description
PB9 Beta 4: Enhancement: Ability to create multiple runtime libraries.



CR:304934
CR Number:   304934
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PowerBuilder 9.0 enhancements: 1) provide status bar as a native PB control, 2) allow hide option on current MDI frame 3) support multiple panels without requiring PFC



CR:304935
CR Number:   304935
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ENH: Provide syntax in a tooltip for all userdefined and system functions



CR:304936
CR Number:   304936
Product Name:   PB Enterprise
Product Component:   Workspace and Targets
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PowerBuilder 9.0 enhancement requests:

1) Provide autohide capability for System Tree.

2) Include Properties and 'toolbox' as a new tab.



CR:304937
CR Number:   304937
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PowerBuilder 9.0 enhancement request: Provide tooltips for all controls including DataWindow columns.



CR:304938
CR Number:   304938
Product Name:   PB Enterprise
Product Component:   Workspace and Targets
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PB 9.0 Enhancement: There's no easy way to move an obj from one PBL to another when SCC is on.



CR:304939
CR Number:   304939
Product Name:   PB Enterprise
Product Component:   DataBase
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In DB Profile, the option 'Use Connection Pool' option should be automatically disabled when ConnectAs is set to non-default SYSDBA or SYSOPER, this would help avoid user error.



CR:304941
CR Number:   304941
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Allow for grouping of N-Up style datawindows.



CR:304952
CR Number:   304952
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2003 Presently Not Targeted For Any Future Release Of This Product
06 May 2003 Fixed
Description
Powerbuilder 9.0 Beta: Datawindow SaveAs HTML does not suppress repeating values.



CR:305039
CR Number:   305039
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2003 Fixed
Description
The datawindow function CreateFrom can return an error -5 when the load of the

resultset into the datawindow fails.



CR:305042
CR Number:   305042
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2003 Presently Not Targeted For Any Future Release Of This Product
Description
Description of Problem: A stored procedure update of a datawindow can have an expression as an argument but this will get always equated as a string: expression: eg 5 or number("5") or double(5") or global function returning a double inside of the expression will send the following to the dbms:

exec dbo.ap_UpdateBigParms NULL, NULL, NULL, '5', NULL, 'xxx', NULL ...



Workarounds:

1.)Use a normal input column argument and eg. set the value in code upon the buffer eg. dw_1.object.column[line].

2.)Use a convert function inside the sp if possible
Review Status
 *** Monday, September 08, 2003 3:15:00 PM ***

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release"



CR:305047
CR Number:   305047
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PBL regeneration should provide list of unused local variables, functions and objects.



CR:305073
CR Number:   305073
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide a DataWindow.GetDWObject("col_1") function to return a DWObject. The current method of DataWindow.Object.col_1 isn't possible under certain situations.



CR:305074
CR Number:   305074
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 14 Mar 2003 Fixed
Description
If you enter 64 or more characters in an Editmask character field and then press the backspace key, PowerBuilder crashes.



CR:305075
CR Number:   305075
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2003 Presently Not Targeted For Any Future Release Of This Product
Description
When using the native pbo9090.dll in the 9.0 profile painter, it describes the driver as "O90 Oracle 9.0.1". Does this driver work with Oracle 9.2? If so the driver description should be amended to include Oracle 9.2.
Review Status
 09/08/2003:

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".



CR:305087
CR Number:   305087
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2003 Fixed
14 Feb 2003 Fixed
Description
To set options on a SOAP connection you specify a string that includes name/value pairs, some values of which are also strings. You can only use double-quotes in the individual values, meaning the property itself must be delimited with single quotes or ~



CR:305094
CR Number:   305094
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2003 Fixed
28 Jan 2003 Fixed
Description
The SoapLog option rewrites the log file for each SOAP request severly limiting its use as a debugging tool.



CR:305098
CR Number:   305098
Product Name:   PB Enterprise
Product Component:   Web.PB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2003 Duplicate
Description
9.0 Enhancement for Web Services: Connection-caching for web services proxy object.



CR:305162
CR Number:   305162
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Would like to see three (3) button added to the Datawindow Vertical ScrollBar for Next, Prior & GoTo page features, as in MS-Word, so developers wont have to put extra buttons on a window for this action.



CR:305164
CR Number:   305164
Product Name:   PB Enterprise
Product Component:   DB JDBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 21 Feb 2003 Fixed
Description
Using Informix JDBC and calling a stored procedure using an input argument will crash Powerbuilder.



The jdbc declare syntax is as follows (different for jdbc than for native Informix driver)

DECLARE l_state_sel PROCEDURE FOR

getuid2 name = :name USING sqlca;





In PB 7.0.3, the jdbc log shows:

DriverManager.initialize: jdbc.drivers = null

JDBC DriverManager initialized

registerDriver: driver[className=com.informix.jdbc.IfxDriver,context=null,com.informix.jdbc.IfxDriver@5be8cb]

DriverManager.getConnection("jdbc:informix-sqli://primerib:1526/ts_data:informixserver=ts_informix7")

trying driver[className=com.informix.jdbc.IfxDriver,context=null,com.informix.jdbc.IfxDriver@5be8cb]

SQLWarning: reason(Database has transactions) SQLState(01I01)

SQLWarning: reason(Database selected) SQLState(01I04)

SQLWarning: reason(Float to decimal conversion has been used) SQLState(01I05)

getConnection returning driver[className=com.informix.jdbc.IfxDriver,context=null,com.informix.jdbc.IfxDriver@5be8cb]

SQLException: SQLState(IX000) vendor code(-202)

java.sql.SQLException: An illegal character has been found in the statement.

at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:346)

at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:2881)

at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3167)

at com.informix.jdbc.IfxSqli.dispatchMsg(Compiled Code)

at com.informix.jdbc.IfxSqli.receiveMessage(Compiled Code)

at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:1988)

at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:1963)

at com.informix.jdbc.IfxResultSet.executeExecute(IfxResultSet.java:342)

at com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:812)

at com.informix.jdbc.IfxStatement.execute(IfxStatement.java:552)

at com.sybase.powerbuilder.jdbc.PbjdbcCommand.Execute(PbjdbcCommand.java:1194)

Java PbjdbcCommand::Execute SQLException thrown

------->SQLState = IX000

------->ErrorCode = -202

------->Message = An illegal character has been found in the statement.

SQLException: SQLState(42000) vendor code(-201)

java.sql.SQLException: A syntax error has occurred.

at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:346)

at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:2881)

at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3167)

at com.informix.jdbc.IfxSqli.dispatchMsg(Compiled Code)

at com.informix.jdbc.IfxSqli.receiveMessage(Compiled Code)

at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1024)

at com.informix.jdbc.IfxResultSet.executePrepare(IfxResultSet.java:193)

at com.informix.jdbc.IfxPreparedStatement.setupExecutePrepare(IfxPreparedStatement.java:183)

at com.informix.jdbc.IfxCallableStatement.<init>(IfxCallableStatement.java:111)

at com.informix.jdbc.IfxSqliConnect.prepareCall(IfxSqliConnect.java:1402)

at com.sybase.powerbuilder.jdbc.PbjdbcSession.CreateCommand(PbjdbcSession.java:718)

Java PbjdbcSession::CreateCommand SQLException thrown

------->SQLState = 42000

------->ErrorCode = -201

------->Message = A syntax error has occurred.

SQLException: SQLState(42000) vendor code(-201)

java.sql.SQLException: A syntax error has occurred.

at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:346)

at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:2881)

at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3167)

at com.informix.jdbc.IfxSqli.dispatchMsg(Compiled Code)

at com.informix.jdbc.IfxSqli.receiveMessage(Compiled Code)

at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1024)

at com.informix.jdbc.IfxResultSet.executePrepare(IfxResultSet.java:193)

at com.informix.jdbc.IfxPreparedStatement.setupExecutePrepare(IfxPreparedStatement.java:183)

at com.informix.jdbc.IfxCallableStatement.<init>(IfxCallableStatement.java:111)

at com.informix.jdbc.IfxSqliConnect.prepareCall(IfxSqliConnect.java:1402)

at com.sybase.powerbuilder.jdbc.PbjdbcSession.CreateCommand(PbjdbcSession.java:718)

Java PbjdbcSession::CreateCommand SQLException thrown

------->SQLState = 42000

------->ErrorCode = -201

------->Message = A syntax error has occurred.

DriverManager.getConnection("jdbc:informix-sqli://primerib:1526/ts_data:informixserver=ts_informix7;")

trying driver[className=com.informix.jdbc.IfxDriver,context=null,com.informix.jdbc.IfxDriver@5be8cb]

SQLWarning: reason(Database has transactions) SQLState(01I01)

SQLWarning: reason(Database selected) SQLState(01I04)

SQLWarning: reason(Float to decimal conversion has been used) SQLState(01I05)

getConnection returning driver[className=com.informix.jdbc.IfxDriver,context=null,com.informix.jdbc.IfxDriver@5be8cb]







In PB 8.0.2, no crash but the error message of: 'Powerbuilder JDBC Internal Error'

shows in the pbtrace.log.



In PB 8.0.3, PB will also crash.



CR:305166
CR Number:   305166
Product Name:   PB Enterprise
Product Component:   BAM Deployment
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide a simple tool to ease application deployment.



CR:305168
CR Number:   305168
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide ScrolltoPage(n) function, which can scroll to specified page number similar to ScrolltoRow(n)



CR:305178
CR Number:   305178
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
The datawindow Position and SelectedStart functions always return a 1 for an EditMask column when the code is in the datawindow editchanged event.
Workaround Description
 Take the code in the editchanged event and put it in a datawindow user event, and post that event from the editchanged event. That gives you back the 6.5 behavior.



CR:305197
CR Number:   305197
Product Name:   PB Enterprise
Product Component:   Install
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2003 Fixed
Description
PB 9.0 Install: Awkward phrasing of installation message for PowerDynamo.



CR:305199
CR Number:   305199
Product Name:   PB Enterprise
Product Component:   Install
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2003 Fixed
Description
The Oracle 9 driver is not followed by the (O90) designation and we should drop the 8.x.4+ on the O84 driver



CR:305263
CR Number:   305263
Product Name:   PB Enterprise
Product Component:   JSP Web Services
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 17 Feb 2004 Fixed
16 Feb 2004 Not a Bug
Description
if the response is huge , the response will use

transfer-coding = "chunked" | transfer-extension

transfer-extension = token *( ";" parameter ) .

if the response from EAServer is more than 0x2000(8192), the response will use transfer-encoding:chunked. JSP WS couldn't parse it.



CR:305270
CR Number:   305270
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When using a manifest file on XP (as described in technote:) the accelerator key (underline character) is not accessible via Alt + key on controls eg. CommandButton etc. For menu it works correctly.



Workaround: In the control panel , Appearance, In the Effects dialog box:

Unselect the option "Hide underlined letters for keyboard navigation until I press the Alt key"



CR:305289
CR Number:   305289
Product Name:   PB Enterprise
Product Component:   Project Wizards
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2003 Fixed
Description
When generating a EAS component via the project wizard and the library list is long, when the wizard is finished, it will crash.

See crashhandler output:

Exception code: C0000005 ACCESS_VIOLATION

File Name: C:\WINNT\system32\MSVCRT.dll

File Version: 6.00.8797.0

Fault address=7802601E Section:Offset=01:0002501E



Registers:

EAX:0012D398

EBX:0012D301

ECX:00000000

EDX:00000001

ESI:07703D82

EDI:00000007

CS:EIP:001B:7802601E

SS:ESP:0023:0012D38C EBP:0012D3B8

DS:0023 ES:0023 FS:003B GS:0000

Flags:00010202



Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

7802601E 0012D3B8 00000001 00410100 780106C6 073FDA90 strtok+49

076DE717 78025FD5 570C758B FDD871E8 89086AFF 33590C45 0001:0000D717 C:\Program Files\Sybase\Shared\PowerBuilder\pbjcg80.dll
Workaround Description
 Do not use the wizard when using long lib lists



CR:305299
CR Number:   305299
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2005 Presently Not Targeted For Any Future Release Of This Product
Description
In the HTML Datawindow when the case property is set on a column, then other settings

can be ignored. When entering text you don't get expected uppercase or lowercase

behavior and characters are only appended. Text is not inserted and selected text is not replaced.
Review Status
 [*** Tuesday, June 21, 2005 14:26:39 ***]

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".



CR:305300
CR Number:   305300
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Ability to create a unbound multi-dimentional array. Something that may be intialized like this: string ls_tmpData[][]



CR:305314
CR Number:   305314
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In all painters, it would be very helpful if the appropriate menu items under "View" were toggled between settings rather than just disabled when selected. This way, using the keyboard, one could close various panes without needing to go to a particular open view and close it from there.



CR:305325
CR Number:   305325
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Feb 2003 Not a Bug
Description
Problem with the Web Service Proxy generator. The proxy generated wrong method signature (a structure for args rather than a set of strings).



CR:305329
CR Number:   305329
Product Name:   PB Enterprise
Product Component:   JSP DW DTC
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2004 Not a Bug
Description
DW using tag library Datawindow90.tld in JSP works for retrieves. Added update, insert and delete buttons. Modify data, click Update button, No refresh.



CR:305330
CR Number:   305330
Product Name:   PB Enterprise
Product Component:   JSP 4GL
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2003 Not a Bug
Description
Not able to access new method added to custom HTML Generator (HTMLGenerator90) component from JSP page. Error: 'Method loadddw(java.lang.String) not found in class com.sybase.powerbuilder.jspobject.PSWebDataWindowClass'



Per Development: 4GL datawindow class is not a dynamic class, so can't be customize at runtime, maybe this problem can be considered for a later version.



CR:305337
CR Number:   305337
Product Name:   PB Enterprise
Product Component:   DW Graph
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Would like to see a new graph type of 'stock' similar to Excel 2000 Chart. In Excel the 'stock' type has sub-types of: "High-Low-Close", "Volume-High-Low-Close", "Open-High-Low-Close", "Volume-Open-High-Low-Close". These are very useful in banking products, Share markets.



CR:305397
CR Number:   305397
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Aug 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
Issue not reproducible with EAS 5.2 and PB9 Build 7692.

--

An EAServer crash can occur after a number of repeated crashes in the PowerBuilder vm

or the pbvm may stop responding.



This problem has been found with the combination EAS 3.6.1. C5 and PBVM 8 (8.0.3.9849).

This problem was not reproducible with EAS3.6.1 and PowerBuilder 7.0.3 vm's

This problem was not reproducible with EAS4.1.3 and PowerBuilder 8.0.3 vm's



CR:305415
CR Number:   305415
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 20 May 2003 Fixed
25 Feb 2004 Fixed
Description
GPF occurs when trying to destroy columns using Modify on a grid datawindow.



CR:305416
CR Number:   305416
Product Name:   PB Enterprise
Product Component:   ORCA
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2003 Fixed
Description
Enhancement in OrcaScript: There should be some way to populate the version/build/company fields (just as in the Project object) within OrcaScript, so that these get embedded into the PBDs/DLLs and EXEs.



CR:305458
CR Number:   305458
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PB 9.0 enhancement: Provide mapped event to WM_NOTIFY



CR:305471
CR Number:   305471
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jan 2003 Workaround
Description
In PB 8.0 build 9121, the following dot notation

is causing PowerBuilder to crash:

dw_1.Object.r_holp_graph.Object.Data[1, 9 ] = 1.2



Works ok in build 9501 and 9506.



CR:305478
CR Number:   305478
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Feb 2003 Fixed
Description
Window Titlebar property is not modifable in script, but document implies it is.



CR:305481
CR Number:   305481
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2003 Fixed
Description
PB 90 (RC) is still using the PB 8 icon.



CR:305528
CR Number:   305528
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10 Mar 2003 Fixed
Description
fetching image column into string varible using embedded SQl via OLE DB cause exception / gpf

i.e. FETCH cur_image INTO :ls_tmp1;



Workaround: use odbc, jdbc or native driver



or SELECTBLOB syntax
Workaround Description
 workaround use ODBC, jdbc or native dirvers

or use SELCTBLOB



Blob bl_berichtimage

SELECTBLOB berichtimage

INTO :bl_berichtimage

FROM berichtdaten

WHERE AnlagenNr=26 AND BerichtNr=1;



CR:305531
CR Number:   305531
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Apr 2003 Fixed
Description
when dw field has focus has a datetype (with date mask), this field is shown as '00/00/0000' or old value instead of the value previously retrieved from the database.

datetime filed with format is [shortdate][time] and editmask is dd/mm/yyyy

Happens if modify DataWindow.ReadOnly or columnname.Background.color properties





no workaround
Workaround Description
 non



CR:305545
CR Number:   305545
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   Solaris 2.6
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
Cpu() reurns millionth of seconds on Solaris and milliseconds on NT.
Workaround Description
 Create a global function long my_cpu():

environment env // holds environment information

errorlogging ierr



GetContextService ("ErrorLogging", ierr)

ierr.log ("------------------------------------MY CPU() ---------------------------------------------



CR:305547
CR Number:   305547
Product Name:   PB Enterprise
Product Component:   Help
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jan 2003 Fixed
Description
Online Help: 'Object and Control' properties list is not in alphbetical order.



CR:305548
CR Number:   305548
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2003 Fixed
Description
Documentation error for PrintSetup.



CR:305555
CR Number:   305555
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Feb 2003 Fixed
Description
The sample scripts provided in the "Advanced ways to manipulate OLE objects" portion of the PB Docs should be updated with current Pb coding syntax and techniques.



CR:305560
CR Number:   305560
Product Name:   PB Enterprise
Product Component:   DW ActiveX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 22 Apr 2003 Fixed
Description
PB 9 Beta RC1: DW ActiveX Blank Sort Screen in browser.



CR:305569
CR Number:   305569
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
The problem appears after a script call to a Changemenu function from a response window to affect a Powerbuilder MDI frame. Powerbuilder will cause a gpf in PBVM70.dll .

If the window type is popup, the problem does not appear.



The problem is a regression because PB 7.0.3 releases (build 10227 and lower) are OK and do not cause a gpf.

PB 7.0.3 build 10237 has failed.

PB 8.0.3 builds are all OK.
Workaround Description
 Change the window type to be a POPUP instead of RESPONSE window or can customer migrate to PB v8 ? The problem does not occur in version 8. I think that we cannot do anything programmatically except to avoid calling this function in a RESPONSE window.



CR:305601
CR Number:   305601
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Sep 2003 Presently Not Targeted For Any Future Release Of This Product
Description
OLE Control using InsertFile for pdf file activates on alternate doubleclicks
Review Status
 09/12/2003:

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".



CR:305623
CR Number:   305623
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10 Apr 2003 Fixed
Description
PBSYC70 DBparm TrimSpaces='0' not working.



Fixed in PB 7.0.3 build 10279, PB 8.0.3 build 9918, and PB 9.0 build 6044.



CR:305789
CR Number:   305789
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 28 Jan 2003 Fixed
Description
PB Native Registry conflict with PB 8 & 9
The SCC specification requires that SCC providers are listed in [HKEY_LOCAL_MACHINE\SOFTWARE\SourceCodeControlProvider\InstalledSCCProviders]
PB Native=Software\Sybase\PowerBuilder\9.0\Native SCC

Then, within this PB Native registry key, entries provide connect information to either PBNAT80.DLL or PBNAT90.DLL. The last install of either product will affect which DLL is used as the SCC provider DLL. Both SCC provider DLLs work fine with both PB IDEs, but it is preferable to use PBNAT90.DLL for both IDEs.

If an uninstall of either product occurs, the registry entry above may get removed. There is a very easy workaround to re-register the PB Native SCC provider DLL.
1) Open a DOS box and make Sybase\Shared\PowerBuilder your current directory
2a) Run REGSVR32 PBNAT90.DLL to register PBNAT90 as the SCC provider DLL
2b) Run REGSVR32 PBNAT80.DLL to register PBNAT80 as the SCC provider DLL
Workaround Description
 1) Open a DOS box and make Sybase\Shared\PowerBuilder your current directory
2a) Run REGSVR32 PBNAT90.DLL to register PBNAT90 as the SCC provider DLL



CR:305799
CR Number:   305799
Product Name:   PB Enterprise
Product Component:   EJB Client
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 5002 12 Feb 2003 Fixed
Description
"Bad Java classname" error when trying to generate proxies for EJB class.



CR:305857
CR Number:   305857
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2003 Fixed
Description
Online help in the Release Candidate build 5058 is not complete. Object functions are missing.



CR:305858
CR Number:   305858
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2003 Fixed
Description
PB 9 RC: "Prompt before Print" option missing from DataWindow Print Specifications tab on the datatwindow properties view.



CR:305859
CR Number:   305859
Product Name:   PB Enterprise
Product Component:   DataBase
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 30 Apr 2004 Fixed
26 Jul 2004 Fixed
Description
OS: All supported platforms

Versions and Build #s Reported: 8.03

Versions and Build #s Tested: 8.02/8.03 builds 9704 -> 9850 amd 9.0 Build 5058 (RC1)

Database/Driver File/Version: PBSYC & PBSYJ with ASE 12 and later (HA enabled)

(could also include fix in Oracle drivers - see notes below for more details)



Using the dbparm SvrFailOver with PBSYC and PBSYJ to enable PB to participate in failover to a backup ASE server. If the PB application is performing an unfinished transaction at the moment failover occurs(ie it has not issued a commit) then PB issues a rollback.

There is no way in code to know if the rollback has occurred due to the Failover. SQLCA (sqlcode, sqldbcode, sqlerrtext etc) do not hold any information to indicate the transaction failed although ASE does provide the information that it has rolledback and failed over to the backup server. As the transaction has been aborted PB should provide information to allow the developer to retry the operation (in the case of a failover) or prompt for the user to revise the data, reretrieve etc (in the case of some other error). The current behaviour does not even inform the client that a rollback has occurred.



In Oracle, when SvrFailover is used, there is an additional option (dbparm FoDialog='Yes') to make PB display a message that failover has occurred. This is a partial fix as it still doesn't solve the problem from a developers point of view and is of no use when using PB components in EAS. Perhaps SQLCA.SQLCode should indicate something has gone wrong and provide info in SQLErrText/SQLDbCode/SQLReturnData.

Recommend implementing the solution in PBSYC & PBSYJ and the Oracle 8 & 9 drivers for all platforms.



CR:305897
CR Number:   305897
Product Name:   PB Enterprise
Product Component:   Install
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Feb 2003 Fixed
28 Jan 2003 Fixed
Description
Install of PB DataDirect OLE-DB provider breaks SQL Server 2000 installation.



CR:306002
CR Number:   306002
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2003 Presently Not Targeted For Any Future Release Of This Product
Description
When in a grid datawindow, objects like pictures or

buttons are added to the right of the grid in the

detaiband, then the datawindow does not scroll to them

or enable the scrollbar if they are hidden from view.



Work-around:

Add a dummy grid column by adding a computed field to the datawindow

and place the control in it. The computed field can be hidden from view by

reducing its height to zero.
Review Status
 [2003-08-08]

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".



CR:306007
CR Number:   306007
Product Name:   PB Enterprise
Product Component:   Web Wizards
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2003 Presently Not Targeted For Any Future Release Of This Product
Description
Web page editor opens scrolled to the right obscuring part of the script.
Review Status
 09/08/2003:

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".



CR:306009
CR Number:   306009
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
PVCS 681 changes in librarylist not reflected after checking out target. Check out target add libs to liblist try adding to source control , new libraries do not get listed.
Workaround Description
 non



CR:306022
CR Number:   306022
Product Name:   PB Enterprise
Product Component:   DW XML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jan 2003 Fixed
9.0 5070 06 Feb 2003 Fixed
Description
SaveRowsAs XML and XSL-FO fail to save characters in range > ASC(127) with correct UTF-8 encoding.



CR:306027
CR Number:   306027
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 Beta 4 07 Feb 2003 Not a Bug
Description
The Status refresh rate (in Workspace properties under Source Control Tab) is coded to increment or decrement by 5 when using the spincontrol. So, if the user manually sets the value to 1, it's incremented to 6, 11 etc. when using the spincontrol.



CR:306032
CR Number:   306032
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2003 Fixed
Description
In the Application project painter, RC1 adds, new fields and new/revised categories "File" vs "Product" version. These changes are not documented in PB Help or the "ReadMe" file.



CR:306036
CR Number:   306036
Product Name:   PB Enterprise
Product Component:   Project Painter
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2003 Presently Not Targeted For Any Future Release Of This Product
Description
The new version information in the Application Project painter either does not use the Regional Settings of the computer, or uses the wrong setting. The default value on my machine for a new project showed up in the format "1,0,0,1" whereas file version information on my machine should be in the format "1.0.0.1".
Review Status
 24 Sep 2003

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".



CR:306038
CR Number:   306038
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jan 2003 Fixed
Description
Many of the names of the functions for OLEControl are missing in on-line help. The descriptions are there, but the names and links are not.



CR:306041
CR Number:   306041
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2003 Fixed
Description
graphicobject (and hence its descendants, window, and all the things you can put on a window) have a number of new, undocumented events.



CR:306044
CR Number:   306044
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When editing an external datawindow, you must be connected to a database. Why does this requirement exist? it should not be necessary.



CR:306054
CR Number:   306054
Product Name:   PB Enterprise
Product Component:   DW Graph
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
It would be extremely nice to be able to turn off the symbols on graphs ('symbol' i.e. a triangle, star, square, etc.).



CR:306066
CR Number:   306066
Product Name:   PB Enterprise
Product Component:   JSP Editor
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5070 07 Feb 2003 Fixed
Description
JSP default formatting causes loss and reformatting of JSP script.



CR:306071
CR Number:   306071
Product Name:   PB Enterprise
Product Component:   PBNI
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 05 Jun 2003 Fixed
Description
Use of the PBNI ReleaseValue() method in a tight loop is causing the CPU to be pegged at near 100% for an exceptionally long time



CR:306101
CR Number:   306101
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 9990 01 Feb 2004 Fixed
Description
Malfuntion of print/preview data which is inside "summary" band

1. Printing the DW to be made of composite(nested) DW and has data in summary band

works wrong. Print omits some data which is in the bottom of summary band.

1.1) for reference : each nested DW has no relation with data(there is no related retrival arguments)

1.2) same problem occurrs although getting rid of lines

2. Preview of composite DW omits the data in summary band.



CR:306136
CR Number:   306136
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   NT4
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2003 Fixed
Description
Two locations in the User Guide contain incorrect information about behavior of incremental rebuilds.



(1) Chapter 29 Defining an executable application project, info on Rebuild option states "If you choose Incremental, PowerBuilder only regenerates objects that have changed, and objects referenced by objects that have changed, since the last time you built your application"



That is incorrect. It should be changed to "If you choose Incremental, PowerBuilder only regenerates objects that have changed, and objects that reference any objects that have changed, since the last time you built your application"



(2) Chapter 5 Rebuilding Workspaces and targets section, states for Incremental rebuild "Updates all the objects and libraries referenced by any objects that have been changed since the last time you built the workspace or target"



It should state Updates all the objects and libraries that reference any objects that have been changed since the last time you built the workspace or target"





To illustrate:

-- ObjectA references ObjectB.

(Reference can be a reference to methods, properties, or inheritance.)

-- User modifies ObjectB.

-- Selecting Incremental Rebuild will regenerate Object A, even though ObjectB was the only object modified.



CR:306138
CR Number:   306138
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 10 Feb 2003 Fixed
Description
When a deleterow button is in the header band of a

datawindow and when sharedata is used, the current row is not being

deleted.



The primary datasource is using d_dept and a datastore. The secondary datawindow

is also using d_dept and a datawindow control. Once the data is retrieved and sharedata

is turned on and a row is selected, when you hit the deleterow button the first

row is always removed.



CR:306140
CR Number:   306140
Product Name:   PB Enterprise
Product Component:   DB JDBC
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 11 Apr 2003 Fixed
Description
JDBC driver does not prompt for userid/password when 'prompt for database information' is checked. The only way you can connect is by hardcoding the userid/password in the db-profile.



CR:306142
CR Number:   306142
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2003 Fixed
Description
Issuing a HALT CLOSE in the close event of an error window opened in the SystemError event causes PowerBuilder 9 to crash.



CR:306168
CR Number:   306168
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2003 Fixed
Description
Please document the restriction that the slash / character cannot be used as the SQL terminator in the database painter. Also whether there are any additional characters that are also not allowed.



CR:306173
CR Number:   306173
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Please add an error message to the database painter options so that the user is unable to enter and save an invalid SQL terminator character such as the slash / which is not allowed per CR 262369.



CR:306175
CR Number:   306175
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2003 Fixed
Description
Please find a way around the restriction on using a slash / character as the SQL terminator in the database painter. Please allow the slash to be used.



CR:306177
CR Number:   306177
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2003 Presently Not Targeted For Any Future Release Of This Product
Description
Undoing a delete of a tab control reverses order of the controls on the tabpg's.



Reviewed by PB Engineering:

Not to be fixed. It only happens on this testcase, and dropping and re-adding the tab control fixes the problem.



CR:306180
CR Number:   306180
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jul 2003 Fixed
Description
Using PrintDefineFont and PrintText results in slightly smaller fonts than in previous PB versions.

Verified fixed in PB 9.0.1 build 6531.





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

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