远程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:352127
CR Number:   352127
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   Solaris 2.8
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2004 Not a Bug
28 Feb 2005 Fixed
Description
PB 9.0.1 (6533) Solaris, HP, and AIX PBVMs:

The fop.bat references lib/logkit-1.0.jar and lib/jimi-1.0.jar and those two files are not in the fop-0.20.4/lib directory.



RESOLUTION: Apache intends for these to be optionally added by the FOP end-user, but they keep these in their CLASSPATH in anticipation.



CR:352128
CR Number:   352128
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for an option for closer integration of DW.NET(DWDesigner) with VisualStudio. Customer feels that the best way is to save DW not in PBL(PBD) but in RESX-files. This way there will be no need to deploy pbd with app, resx could be embeded in EXE(DLL).



CR:352133
CR Number:   352133
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2004 Fixed
Description
Filter method returns void not the number of rows filtered as the on-line help indicates.



CR:352137
CR Number:   352137
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2004 Fixed
Description
This is a follow-on to CR 348892. A datawindow has only a computed column displayed, and the expression uses the value of a source datawindow column. The datawindow is empty (no rows). If you use dot notation to insert a value into the source column for a row that doesn't exist, the rows are inserted and the value is assigned to the appropriate source column in the appropriate row. But the computed column based on the source column does not display.



CR:352162
CR Number:   352162
Product Name:   PocketBuilder
Product Component:   Language - Compiler
Status:   Open
OS:   Windows 2000
Original Version:   1.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add GetFullState, SetFullState in PocketBuilder.



CR:352164
CR Number:   352164
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Open
OS:   Windows XP
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add option to have a web page using the PowerBuilder Window ActiveX control be configured to use the WinXP style for visual controls.



CR:352165
CR Number:   352165
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 12 Sep 2004 Fixed
Description
PB errors out for a DW stored proc. insert when the first argument is null. This happens for an ODBC driver and one gets an error message Program Type Out of range which comes from ODBC driver manager.



CR:352175
CR Number:   352175
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Apr 2004 Fixed
Description
Errors in compiled HTML Help file: Several Titles/Topics are incomplete, or simply listed as "untitled".



CR:352177
CR Number:   352177
Product Name:   PB Enterprise
Product Component:   DW XML
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2004 Fixed
Description
If you create a comment in the header section of the XML template for a DataWindow that is then used as a nested DataWindow in another DataWindow, when saving rows as XML the nested datawindow is not included in the XML generated.



CR:352185
CR Number:   352185
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
DataWindow Designer 1.0 needs an option "Open last project at startup" or "Reload project on startup" in the "System Options".



CR:352249
CR Number:   352249
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Windows XP
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2004 Fixed
Description
Making an odbc connection from a PowerBuilder component in EAS 5.0 fails

when using a FILE DSN or DSN-less connect.



This CR is related to CR 329080 for earlier EAServer versions.

==========

DSN-less connects are not supported, the connection parameters need to be written to a dsn file. Also the length of the pathname may not be too long (up to 80-90 characters).

Examples:

SQLCA.DBParm = "ConnectString='FILEDSN=c:\test_asa.dsn;uid=dba;pwd=sql'"



CR:352267
CR Number:   352267
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2004 Fixed
Description
When unselecting the Database Write option during a custom

install of Infomaker, you can still write changes to the database.



After installation, the Readonly property in the im.ini is set to 0. When you create

a query and preview it, if you make a change and then close out of the preview, you

are prompted to save changes back to the database. If you hit yes, the changes are

updated to the database.
Workaround Description
 Changing the ReadOnly property to 1 from 0 will make it readonly in the im.ini.



CR:352281
CR Number:   352281
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   Solaris 2.8
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2004 Fixed
Description
The windows version of the fop.bat gets installs when installing PBVM 9.0.1 (6533) on EAServer.



From looking at the fop.bat,

java -cp build\fop.jar;lib\batik.jar;lib\xalan-2.3.1.jar;lib\xercesImpl-2.1.0.jar;lib\xml-apis.jar;lib\avalon-framework-cvs-20020315.jar;lib\logkit-1.0.jar;lib\jimi-1.0.jar org.apache.fop.apps.Fop %1 %2 %3 %4 %5 %6 %7 %8

When it should something like:

java -cp build/fop.jar:lib/batik.jar:lib/xalan-2.3.1.jar:lib/xercesImpl-2.0.1.jar:lib/xml-apis.jar:lib/avalon-framework-cvs-20020315.jar:lib/logkit-1.0.jar:lib/jimi-1.0.jar org.apache.fop.apps.Fop $*



CR:352284
CR Number:   352284
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2004 Fixed
Description
Wizard becomes unstable in Powerbuilder if the datawindow creation is cancelled.



CR:352288
CR Number:   352288
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Solaris 2.8
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Fixed
Description
PB 9.0.1 (6533) When using the fop.bat to generate a pdf file from a fo file, results in the following errors:



building formatting object tree

[1]

fo:flow must contain block level children

at org.apache.fop.fo.flow.flow.layout (Unknown Source)

at org.apache.fop.fo.pagination.PageSequence.format(Unknown Source)

at org.apache.fop.apps.StreamRenderer.render (Unknown Source)

at org.apache.fop.fo.FOTreebuilder.endElement (Unknown Source)

.

.

at org.apache.fop.apps.Driver.render (Unknown Source)

at org.apache.fop.apps.CommandLineStarter.run (Unknown Source)

at org.apache.fop.apps.Fop.main (Unknown Source)



CR:352308
CR Number:   352308
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jul 2005 Not a Bug
Description
The customer has a datawindow with a column of type number that is a dddw column. The display column of the dddw is from a computed column with the expression "string(col1, '00000'). So the number should be displayed with leading zeros and it is in most cases. But if the dddw is filtered so that there are fewer choices, if you then pick one of the choices and tab off, the number is displayed without the leading zeros.



From Engineering: This is not a bug. The dddw filter is being applied to the dddw in the rowfocuschanged event of the main datawindow. What is happening in the case where they click on a row and select a value from the drop down and then tab off, is they are tabbing into the next row. This applies a different filter to the dddw and the value they picked for the previous row, has now been filtered out of the dddw. PB is doing what it always does when a data value does not have a match in a dddw, it displays the data value, so there are no leading zeros. You have to realize there is only one dddw, and it applies to the dddw column of all the rows on the main datawindow. So if you are filtering to be different for each row, be careful you don't eliminate vaues that are in use by other rows.



CR:352312
CR Number:   352312
Product Name:   PB Enterprise
Product Component:   Migration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2004 Fixed
Description
The migration of external function declarations that have single quotes from pb 9.0 to PB 10 fail. The results in 10.0 make it seem that double quotes are expected, but the single quotes compile fine in 9.0.1 and should migrate as well.



CR:352407
CR Number:   352407
Product Name:   PB Enterprise
Product Component:   Shared Objects
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2004 Fixed
Description
SharedObject opens windows behind the main thread.



CR:352426
CR Number:   352426
Product Name:   PocketBuilder
Product Component:   DB ODBC
Status:   Open
OS:   Pocket PC 2003
Original Version:   1.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
On the PocketPC, opening both a local and a remote database connection, then

closing the remote connection makes the PDA run extremely slow.

Solution: Updated DBODBCx.DLL from iAnywhere



Fixed by the ASA crew - need a new DBODBCx.DLL

Change ported to 8.0.2 and 8.0.3, as well as all the 9.0.0 and later codelines.
Workaround Description
 Solution: Updated DBODBCx.DLL from iAnywhere



CR:352467
CR Number:   352467
Product Name:   PB Enterprise
Product Component:   WT - System Tree
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add a search option to a JSP/Web Target similar to

what is available now for PB targets.



CR:352470
CR Number:   352470
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Windows XP
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2004 Fixed
Description
DataWindow columns with lowered style borders, SelectRow() leads to invisible the column text (white on white) when using XP Style.



CR:352557
CR Number:   352557
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.3 03 Aug 2005 Fixed
Description
Autoincrement column not displayed after an insert/update



CR:352560
CR Number:   352560
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Apr 2004 Fixed
Description
The following SQL statement which executes in PB 9.0.1 with no problems, crashes in PB 10.0:

SELECT Coalesce((SELECT item_receipt_flag FROM item_table WHERE item_no

= :ls_itemno,(SELECT item_receipt_flag FROM item_table WHERE

trim(item_no) = trim(:ls_itemno))) FROM dummy;



CR:352578
CR Number:   352578
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Apr 2004 Fixed
Description
A COM object with 2 functions is built and deployed. The first function is declared as: function1( ref string, ref string, value integer) At runtime calling function 1 causes a PB crash. The second function is declared as: function2( ref string, value string, value integer) At runtime calling function 2 is OK.



CR:352602
CR Number:   352602
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 May 2004 Fixed
Description
PFC "dw.Event pfc_print" will call out Print dialog box of OS.

From the Print Dialog box inturn, it provide a feature "pages per sheet" to merge mulitple

page into one sheet printout. The feature work fine with it is Win95/98 but fail on

Windows 2000



CR:352604
CR Number:   352604
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2005 Fixed
Description
If a certain control has focus on a window and you pop a messagebox, after the messagebox is closed the focus reverts back to the first control in the tab order, not the one that had focus before the messagebox.



CR:352605
CR Number:   352605
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2004 Fixed
Description
SortDialog and CrosstabDialog require datawindow resources within PBVM100.DLL, so on a DW.NET only machine, those dialogs appear blank.



CR:352653
CR Number:   352653
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2004 Fixed
Description
When using double-quotes within a DbParameter string, the string is ignored (at least for ConnectString)



CR:352655
CR Number:   352655
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2004 Fixed
Description
The edit control appears to have an 'underline' when used with a DataWindow object that was created with SyntaxFromSql.



CR:352656
CR Number:   352656
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2004 Fixed
Description
DDDW on columns for dynamically created datawindows are not appearing in DW.NET. When creating a DataWindow using DataWindowSyntaxFromSql, if a column has an edit style (from extended attribute table) that is a dropdown datawindow, the dropdown datawindow is not displaying, even though it's in the same PBL associated with the DataWindow object.



CR:352689
CR Number:   352689
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jun 2005 Fixed
Description
In the System Tree, if you try to delete an object that is not open for editing while you have a different object open, you cannot do so by using the delete key. You can right click on the object and select Delete from the pop up menu and this works. If you do not have any objects open in a painter, you can successfully delete an object from the System Tree using the Delete key.



CR:352772
CR Number:   352772
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2004 Fixed
Description
Normally if an "end if" is missing from an if statement, PB gives a Syntax error when compiling the script. But if you have the PB_POOL_THRESHOLD system environment variable defined, then PB crashes instead when compiling. If you also have the PB_HEAP_DEBUG system environment variable set to TRUE, then it does not crash and gives the syntax error.



CR:352788
CR Number:   352788
Product Name:   PB Enterprise
Product Component:   PD Integration
Status:   Open
OS:   Microsoft Windows NT
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request: In a OOM model in a class, customer would like to be able to make the operations display in Alphabetical order.



CR:352805
CR Number:   352805
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2004 Fixed
Description
For the style string argument of the DataWindowSyntaxFromSql method, the DataWindow engine actually can accept a null, and if a null is passed a default tabular type will be used.



So this is a request that documentation explicitly mention that a null value passed in as a style string to the DataWindowSyntaxFromSql method results in the default datawindow style being used. This is unlike most other string arguments which would throw an ArgumentNullException.



CR:352810
CR Number:   352810
Product Name:   PB Enterprise
Product Component:   PD Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2004 Fixed
Description
The customer has some VB script which he uses to scan class diagrams. It runs fine in PD standalone. But when attempting to run it in the PB PD Plug-in, it fails with this error:

"Microsoft VBScript runtime error Permission denied: 'InputBox' (0x800A0046) At line 24, character 4".



CR:352875
CR Number:   352875
Product Name:   PocketBuilder
Product Component:   Debugger
Status:   Open
OS:   Windows 2000
Original Version:   1.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Debugger shows incorrect value (zero) for an enumeration.



object le_t

le_t = this.typeof()



This contains the correct value at runtime (like a CHOOSE/CASE stmt) but the

debugger always displays ADOResultSet! (which is zero)
Target Version
 2.0



CR:352896
CR Number:   352896
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2004 Fixed
04 Jul 2004 Fixed
06 Apr 2005 DEFER
Description
Powerbuilder switches to English keybord on a hebrew machine.



CR:352897
CR Number:   352897
Product Name:   PB Enterprise
Product Component:   PD Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2004 Fixed
Description
After creating a report in the PowerDesigner plugin, you cannot open it via the Open Diagram (misnamed??) context menu option, or via the first icon on the tool bar after pressing Ctrl-E to bring up the list of reports.



CR:352909
CR Number:   352909
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 May 2004 Fixed
Description
PBDATA100.DLL is a .NET assembly used for the ADO.NET database driver. Per engineering, in beta 2 and prior the assembly was registered via REGASM to provide COM clients (PBADO100.DLL) the mechanism to access classes within the assembly. The COM access has been discontinued in favor of hosting the .NET runtime in the unmanaged classes of PBADO100.DLL; therefore, I believe this registration is no longer required.



If you install Build 4016, for instance, you will find the following registry sub key has been installed



HKEY_CLASSES_ROOT\CLSID\{13B236BD-1AA9-4EA2-8ADB-0A12510C8CBE}\InprocServer32\10.0.4016.0



CR:352914
CR Number:   352914
Product Name:   PB Enterprise
Product Component:   PD Integration
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The shortcut for compiling a script in PB is Crtl-L. In PD, that's the shortcut in a script editor for "delete line". That's going to cause some of pain for folks working in an 'integrated' environment...



CR:352918
CR Number:   352918
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.0 beta3 27 Apr 2004 Fixed
Description
When trying to call Oracle procedure with OUT parameter defined as ref array, getting Error Message:"ORA-01486: size of array element is too large" or PB crash.



CR:352929
CR Number:   352929
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2004 Fixed
Description
A regression from 7.0.4 where selectrow works fine in a label datawindow. But nothing happens in 9.0.1.



CR:352930
CR Number:   352930
Product Name:   PB Enterprise
Product Component:   PD Integration
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement description: If I attempt to open the properties dialog for a class, check with the source control system to make sure that the underlying PB object is actually checked out if the workspace is under source control. Warn me if the object is not checked out, similar to what happens if I try to edit the PB object directly.



CR:352932
CR Number:   352932
Product Name:   PB Enterprise
Product Component:   PD Integration
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request: Currently, it looks like there are two different methods of supporting multi-developer work, one for PB (through SCC) and one for PD (through the repository). When PD is intergrated into PB through the plug-in, there should be one intergrated method of handling source control. Checking out of an object or a class representing the object should be done in tandem (checking out one checks out both).



CR:352934
CR Number:   352934
Product Name:   PB Enterprise
Product Component:   PD Integration
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request: PD plug-in. It would be good to have a 'preview changes' option for the Language->Generate PowerBuilder option so the user can see what PD is about to attempt.



CR:352935
CR Number:   352935
Product Name:   PB Enterprise
Product Component:   PD Integration
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request: Customer reverse engineers his PB target as a OOM into PD. In the model he double clicks on an object (userobject) and makes a change/update to it. When he clicks Save he gets a progressbar which tells that it is updating and the update happens on the object both in the model in PD and the object in PB. However if the customer opens the object in PB and makes a change/update to it, the effect takes place only in PB. The object in PD is not automatically changed/updated. Customer feels it should happen both ways. The same thing when he does a Get Latest Version out of the source control system. The object model should be automatically udpated with any changes that are resulting from that as well. Basically, the object model should always be up to date with any changes in the underlying PB code, no matter how they got there.



CR:352943
CR Number:   352943
Product Name:   PB Enterprise
Product Component:   PD Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2004 Fixed
09 Jun 2004 Fixed
Description
A user event in PB with a parameter declared, does not require a return statement to compile. For example you can declare a user event with an integer parameter and not put any script in the event,` and you are allowed to save the object. But if you reverse engineer such an object to PD and then bring it back to PB with Generate PowerBuilder, you will get an error that a return is required. Hit OK to the error message and the object in PB now gets the error and doesn't compile. And you are not able to open the object in the painter.



CR:353071
CR Number:   353071
Product Name:   PB Enterprise
Product Component:   PD Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1281 19 Oct 2004 Fixed
28 Apr 2005 Fixed
Description
The Shortcut for the Close workspace menu option is Maj+F4 instead of Shift+F4.



CR:353072
CR Number:   353072
Product Name:   PB Enterprise
Product Component:   PD Integration
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PD Plug-in: Hot key (Alt-key) for Run and Repository menu are the same



CR:353074
CR Number:   353074
Product Name:   PB Enterprise
Product Component:   PD Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Oct 2004 Fixed
27 Apr 2005 Fixed
Description
After reverse engineering a small PowerBuilder application, the PowerDeisgner workspace, Classes folder shows quite a few 'classes' that have no symbols in the diagram. These seem to be controls within windows, which should be treated more as attibutes than classes. Additionally, those 'classes' often display with incorrect icons. A 'commandbutton' class in that folder has a Window icon next to it, for instance.



CR:353150
CR Number:   353150
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2006 Not a Bug
Description
calling dw_1.update(FALSE) twice saves datas to database
Workaround Description
 in the itemChanged event, reject data with a return code 1 or 2

OR change the ItemStatus of the column to NotModified!



CR:353158
CR Number:   353158
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2004 Fixed
Description
A number of old SaveAs types (WMF, DIF, Excel, etc.) were removed from PB10. Doing so will cause migration issues for some customers. Additionally, there are places in PB - picture buttons for instance - where you can add a WMF image, so it seems inconsitent to desupport that same format elsewhere.



These types SHOULD be hidden from DW.NET though (as they are currently but via a different mechanism).



CR:353175
CR Number:   353175
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2004 Fixed
Description
The TypeOfDataWindow property is not being reset to None when you set the DataWindowObject property to an empty string.



CR:353177
CR Number:   353177
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
For usability, the Lock attribute of the Transaction class should be an enumerated type. This parameter is currently a string and the syntax varies depending upon the database driver used. For usability, we should map the string values to a set of enumerated types that would work across all native database drivers.



CR:353179
CR Number:   353179
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2004 Fixed
Description
As an enhancement, provide ToString implementation for Transaction and AdoTransaction.



For the other classes of DW.NET we have provided ToString methods so that when you do a MsgBox(dw.ToString()) you get some information about the current instance of the class - like datawindow object and library list.



We should do the same for Transaction and AdoTransaction; HOWEVER, we should not display the userid and password in clear text, since that would be a security issue. The other DW.NET classes have a pattern for how to format the ToString output.



CR:353180
CR Number:   353180
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement: For DW.Net make possible to use method dw.Create() without presetting liblist and dw_name. Customer had been able to do this in DW.NET by creating a stub PBL with a stub DW. In PB I can initialize DWControl from string without setting dw.DataObject.



CR:353194
CR Number:   353194
Product Name:   PB Enterprise
Product Component:   PD Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jun 2004 Fixed
08 Jun 2004 Fixed
Description
Reverse engineering of local object structures is a problem in PD. One problem is if there are local object structures that contain elements of a type that is another local object structure, the elements are omitted. Another problem is local external function delarations that contain arguments of a local object structure type, are not reverse engineered.



CR:353200
CR Number:   353200
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2004 Fixed
Description
Need to remove one of the sets of overrides to enhance usability and increase consistency.



In the Object Browser of VS.NET you can see that we currently we have the following overloads:



GetItem (row#, col#)

GetItem (row#, colname)

GetItem (row#, col#, original)

GetItem (row#, colname, original)

GetItem (row#, col#, buffer, original)

GetItem (row#, colname, buffer, original)



and



GetItemSQLxxx (row#, col#, buffer, original)

GetItemSQLxxx (row#, colname, buffer, original)



So there is some inconsistency here both within the overrides of GetItem and between GetItemxxx and GetItemSQLxxx



1. Remove the two GetItemxxx(row, col, original) overloads, this reduces the number of overloads and eliminates the illogical progression where the original parameter is last the GetItemxxx(row, col, buffer, original) overload.



2. Add a GetItemSqlxx(row, col#) and GetItemSqlxx(row,colname) overload so that we have a consistent set of overload for all the GetItem methods.



CR:353251
CR Number:   353251
Product Name:   PB Enterprise
Product Component:   AutoScript
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 08 May 2004 Fixed
Description
Using the script painter and going to an empty line and put in a space. If activate Autoscript using the menu Edit > Activate Autoscript. Powerbuilder 9.0.1 causing a gpf.



CR:353288
CR Number:   353288
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2004 Fixed
Description
UpdateData should throw InvalidOperationException instead of MethodFailureException when the DataWindow is not updateable.



CR:353293
CR Number:   353293
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.0 18 May 2004 Fixed
10.0 27 May 2004 Fixed
Description
SaveAsAscii's intent is to provide a cross between SaveAs(Text!) and SaveAs(HTML!), the use of "Ascii" in the method name is unfortunate since it doesn't imply Ascii encoding. Given that there are some questions:



1. Does SaveAsAscii save only in Ascii? If not, we need an encoding argument like for SaveAs. If so, then shouldn't there be a SaveAsUnicode method as well?



2. This would be better called SaveAsEx and then we could add an encoding argument and deprecate SaveAsAscii



Whatever choices are made in PowerBuilder should be carried through consistently to DataWindow .NET



CR:353297
CR Number:   353297
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2004 Fixed
Description
An editmask with decimal code table data crashes PB when the code table exceeds a certain size.



CR:353300
CR Number:   353300
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2004 Fixed
Description
After inserting a rtf document and then using replacetext,

the formatting leaves large spaces between words.



CR:353317
CR Number:   353317
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2004 Fixed
Description
RowsCopy/RowsDiscard/RowsMove throw InvalidArgumentException in many cases when they should throw InvalidRowNumberException.



CR:353322
CR Number:   353322
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2004 Fixed
Description
FindNextModifiedRow throws NullReferenceException when the row argument < 0.



Simple resolution here, the C# layer should throw InvalidRowNumberException if the input argument is less than 0... N.B., 0 itself is a VALID value.



CR:353328
CR Number:   353328
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2004 Fixed
Description
When a nested report is in the header band of a datawindow,

its missing from the datawindow after page 1.



The problem happens after you retrieve data and using getfullstate/setfullstate

It can also be seen on a psr report.



If you open the psr in the datawindow, its missing the nested report after page 1.



CR:353342
CR Number:   353342
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2004 Fixed
Description
Reduce number of overloads of ImportString/File/Clipboard to reduce complexity and provide symmetry with SaveAs methods.



SaveAs methods all require FileSaveAsType argument, so ImportFile/String/Clipboard should as well. This would reduce the number of overloads of each of those functions from four to two.



Also, given that SaveAs now requires a FileEncoding, does Import need to specify that as well?



CR:353344
CR Number:   353344
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 May 2004 Fixed
Description
SetAdoTransaction should be renamed to be an overload of SetTransaction for a consistent object-oriented presentation.



This would result in:



SetTransaction(Sybase.DataWindow.Transaction) and

SetTransaction(Sybase.DataWindow.AdoTransaction)



CR:353347
CR Number:   353347
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2004 Fixed
Description
SetSqlSelect should throw NotSupportedException for consistency with other methods, SetSqlSelect should throw System.NotSupportedException when called for a datawindow that does not have a SQL statement as its source (e.g., an external datawindow or one from a stored procedure).



The method currently throws MethodFailureException if the datawindow source is not a SQL select statement, so end-user is aware that method has not completed successfully; however, most other methods throw System.NotSupportedException when the method does not apply to the DataWindow type.



CR:353349
CR Number:   353349
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2004 Fixed
Description
The Encoding and IncludeColumnHeaders arguments of the 4-argument overload of SaveAs should be switched. Encoding argument should logically be last.



CR:353350
CR Number:   353350
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2009 Not a Bug
Description
1. Drop the Clipboard value. It's used to copy a graph image to clipboard, but we have that with GraphicObjectGraph.Copy

2. Change Csv to CommaSeparatedText.

3. Change Text to TabSeparatedText

4. Change Pdf and Xml to PDF and XML respectively.

5. Change PSReport to PSR.

6. Change FileSaveAsEncoding should to FileEncoding.

7. Change the name of the enumeration to just FileType.



CR:353410
CR Number:   353410
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2004 Fixed
Description
When installing PB 10 (build 4021), no size of the installation

is displayed in the Add/Remove programs from the Control Panel.



CR:353414
CR Number:   353414
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2004 Fixed
Description
DW.NET: missing property to allow for canceling all or skipping current request.



SQLPreviewEventArgs class has no property corresponding to the return values allowed in PowerBuilder:



0 Continue processing

1 Stop processing

2 Skip this request and execute the next request



CR:353426
CR Number:   353426
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Open
OS:   Pocket PC 2002
Original Version:   1.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Application contains a dw with 2 dddw columns. When you select a value in the first column, then click to the 2nd column and make a selection, the first column changes to display the data value instead of the display value. Problem occurs on the Device, not on the desktop.



CR:353445
CR Number:   353445
Product Name:   PB Enterprise
Product Component:   PD Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2004 Fixed
Description
In the PD plugin within PB the user is allowed to open a Business Process Model. The model gets added to the workspace but nothing can be done with it. But the user cannot open the BPM diagram. You can right click on the objects in the model in the workspace and open the properties windows. But what is the use of this when the diagrams in the model cannot be opened? Only OOM's should be allowed to be opened in the PB PD plugin.



CR:353446
CR Number:   353446
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2004 Fixed
Description
None of the arguments to the PrintBegin, PrintEnd, or PagePrinting argument contain the correct values; they are always zero. Additionally, the Cancel option for PagePrinting doesn't work.



CR:353450
CR Number:   353450
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2004 Fixed
Description
Cancelling a retrieve or cancelling an Update in the BeginUpdate method throws a MethodFailureException and should not.



From looking at some other .NET class implementation, one option is to file a CommandCanceled event when the Retrieve is cancelled by any mechanism. That event can allow user to code what should happen when the retrieve is cancelled - if anything.



CR:353453
CR Number:   353453
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2004 Fixed
Description
A DataWindowNotCreatedException fires when you use the Create method on a DataStore and the DataStore does not already have a LibraryList property and a DataWindowObject assigned. Create is for dynamic datawindows, this should not be a requirement.



Datastore.Create method throws an exception if there is not already a DataWindowObject assigned.



CR:353454
CR Number:   353454
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Closed
OS:   Pocket PC 2002
Original Version:   1.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.5.2 394 06 Jul 2004 Fixed
Description
Datawindow with source using an Outer Join runs okay on the desktop, but you get an error running on the Pocket PC device "Table 'xxx' not found." Unclear as to whether the error is PPB or ASA CE.



CR:353459
CR Number:   353459
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2004 Fixed
Description
Performing a retrieve on an external datawindow clears whatever data is in it before throwing a MethodFailureException. There are two issues here:



a. the data should be left alone and not changed, since the method is doomed to failure and should not have this side-effect

b. the exception thrown should be System.InvalidOperationException



CR:353462
CR Number:   353462
Product Name:   PB Enterprise
Product Component:   Query Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.3 14 Jun 2005 Fixed
22 Jun 2005 Fixed
Description
In the Query painter (or datawindow painter) when you select multiple tables, PowerBuilder will give you a best guess join of those tables. According to the Help:

"If you have selected more than one table, PowerBuilder joins columns according to whether they have a key relationship: Columns with a primary/foreign key relationship are joined automatically. Columns with no key relationship are joined, if possible, based on common column names and types."



In 8.0.4 this seemed to be working as stated. But it appears to have regressed in 9.0.1. In this testcase there are 2 tables and there is a foreign key relationship consisting of 5 columns from one table to another. When selecting these 2 tables in PB 8.0.4, they are joined with a where clause that correctly reflects the foreign key relationship. But in 9.0.1 the where clause is a single column that is not part of the foreign key, but is another column that does have the same name and type in both tables. It appears that something has changed in 9.0.1.



CR:353466
CR Number:   353466
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2004 Fixed
Description
A DataWindow expecting a retrieval argument of double, when presented with a string type, causes a "DataWindow Error" messagebox to occur, followed by a MethodFailureException. We should NEVER display message boxes like this.



CR:353551
CR Number:   353551
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request: PB support for a tab control should include Microsoft's Common Controls Tab control and should support TCS_BUTTONS, TCS_FLATBUTTONS (only when button style is used), TCS_HOTTRACK and other style bits which are currently not supported.



CR:353560
CR Number:   353560
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add the ability to dynamically re-dimension multi-dimensional dynamic arrays. VB allows this using their REDIM statement. There are times the arrays used are built at different times using different sizes with no idea of what the max size could be.



CR:353669
CR Number:   353669
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2004 Fixed
Description
ItemError can fire as a result of ImportFile/String/Clipboard, so this functionality has a valid place in the DataStore, even if there is no visual representation by which a column can lose focus and thus more directly cause an ItemError to occur.



CR:353702
CR Number:   353702
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2004 Fixed
Description
The SetPosition method from PowerBuilder is not implemented.



CR:353705
CR Number:   353705
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The IMEModeChanged event doesn't work correctly in DW.NET.



CR:353716
CR Number:   353716
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2004 Fixed
Description
When you retrieve a DataWindow for which you have not set the Transaction object, an InvalidOperationException should be thrown. Instead we get a DbErrorException, whose text refers to SetTrans and SetTransObject - methods that don't exist in DataWindow .NET. For a nested datawindow, a system generated message box is displayed.



CR:353717
CR Number:   353717
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 25 May 2004 Fixed
Description
When opening a sheet that has a windowstate = maximized, the sheet contains two sets of system control menus along with two sets of min, max and restore buttons.



CR:353868
CR Number:   353868
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2007 Presently Not Targeted For Any Future Release Of This Product
Description
problem occurred Only on win98 in PB8.x & PB9.x (except 803.9704 , 900,5507 )



CR:353871
CR Number:   353871
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Open
OS:   Windows XP
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to increase the performance of getting database connections with Powerbuilder

components in EAServer.



CR:353881
CR Number:   353881
Product Name:   PB Enterprise
Product Component:   BAM Deployment
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jul 2004 Fixed
Description
When running an executable that was created with a pbr at

the application level, the filemon utility is showing that the exe is still searching

for the icons.



The icons are being added dynamically from a dropdown picture listbox using

addpicture. When the executable is running, you can see the icons in the dropdown.



CR:353915
CR Number:   353915
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Open
OS:   Microsoft Windows NT
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Retrieving data in a Oracle 8i server through a database link on another Oracle server (in this problem its 9i) using: SELECTBLOB , it returns a -1 in the SQLCode, no data, and no SQLErrText. If the database connected is 8i , then everything works.



The above turned out to be an Oracle issue, as discovered by the customer. However it leaves a question about UpdateBlob and binding as noted:

"I found the problem, and it's a bug in the Oracle 9i OCI layer (see attached metalink note). On 9i, OCI is reporting the size of long (and long raw) columns as if they were VARCHAR2(4000). So PB is sizing the host variable too small, which is why you end up with a Error 2 code. I was able to finally track it down because I wrote a Java Stored Procedure to transfer the data and it worked fine on 8i but generated ORA-01406 errors when run on 9i. Basically, any tool (including PB and Java) that sizes it's host variables based on what the OCI layer tells it the size of the data is will have this problem. Those tools that don't rely on that information don't have the problem.



The remaining question is how to get PB to do a 'describeless retrieval' for the SelectBlob statement. Apparently the staticbind setting doesn't seem to affect that statement.



Oracle's Bug Document :

ftp://psaftp.sybase.com/pub/uploads/ecm/11027367_2553240.pdf "



CR:353921
CR Number:   353921
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0 beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2004 Fixed
Description
When calling a stored procedure, receiving the

ora-01740 error:

Missing double quote in identifier





Problem happens when calling Oracle stored procedure using synonyms and with the O84 driver.



CR:353922
CR Number:   353922
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2004 Fixed
Description
The customer has an application that is GPFing in 9.0.1 on a save of a datawindow. It works OK in 8.0.4. They are doing some complex modifys on the datawindow and this seems to be a part of the problem. Also the problem is data sensitive, some data saves OK, but saving certain data in a field always GPFs.



CR:353971
CR Number:   353971
Product Name:   PB Enterprise
Product Component:   JSP DW DTC
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Allow JSP page to be deployed from PB to tomcat to use a custom component generator for Web Datawindow DTC on MTS/COM+.



CR:353972
CR Number:   353972
Product Name:   PB Enterprise
Product Component:   JSP Help
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2004 Fixed
Description
Unclear section about MTS integration for JSP targets.



CR:353981
CR Number:   353981
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2004 Fixed
Description
PowerBuilder 8.0.4 Build 10666

The function PrintGetPrinter crashes when there are a large number of printers with possibly long names are defined.



CR:353985
CR Number:   353985
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Windows XP
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jun 2004 Third Party Problem
25 Jun 2004 Duplicate
Description
Time for the database connect statement in a component increases considerably when connecting with a larger number of concurrent clients.



CR:353990
CR Number:   353990
Product Name:   PB Enterprise
Product Component:   ORCA
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2004 Fixed
Description
When running the orcascr9 script to regenerate an object

in a pbl, the following error occurs:



Command syntax error at line 4. Found "w_test", expected "<word>"

endSession





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从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等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------