远程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:373889
CR Number:   373889
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2004 Fixed
Description
When connected to an MS SQL Server database via OLEDB, a table with a multiple column primary key does not display correctly. Both the primary key properties and the image of the table in the layout view, show only one column as the primary key, and not the others. When connected to the same database via ODBC, the primary key displays correctly.



CR:373959
CR Number:   373959
Product Name:   PB Enterprise
Product Component:   ORCA
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   9.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.3 13 Jun 2005 Fixed
Description
A SCC Partner requested a new ORCA function that allows an ORCA program to reset the Scc revision number of an object in a PBL. This is not possible via ORCA today, so a new API function is proposed:

PBWINAPI_(INT) PBORCA_SccResetRevisionNumber

( HPBORCA hORCASession,

LPTSTR lpszLibraryName,

LPTSTR lpszEntryName,

PBORCA_TYPE otEntryType,

LPTSTR lpszRevisionNum

);

To delete the revision number in the PBL, call this function with lpszRevisionNum set to NULL. This function does not require an ORCA SCC connection.



CR:374046
CR Number:   374046
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   10.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.2 17 Dec 2004 Fixed
10 Jul 2006 Fixed
Description
PB10 export dialog has a new combobox that allows the user to choose the encoding format to be used when exporting source code to the file system. It would be nice if the last format chosen would be used as the default the next time the dialog appears.



Users typically choose the same format every time they export source. So keeping track of the user's preferred encoding format makes the dialog more efficient.



CR:374151
CR Number:   374151
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 23 Mar 2005 Fixed
Description
The EditChanged event in a DW control is not triggered when the user highlights and tries to paste something into the DW column which has edit style set to EditMask.
Workaround Description
 Use Style Type = Edit with validation expression set



CR:374156
CR Number:   374156
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2004 Fixed
Description
OpenSheet() with Layered! option displays sheets with incorrect size.



CR:374166
CR Number:   374166
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2005 Fixed
Description
Rows Discard makes PB crash if the datawindow has a certain height.



CR:374169
CR Number:   374169
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Consult Complete
Description
ESRI tech support says PowerBuilder will not support ArcGIS because ArcGIS has multiple custom interfaces for its objects and PowerBuilder will not work with an object

that has multiple custom interfaces. I would like to either have this

verified or refuted by Sybase. They said their older product, MapObjects,

would work with PowerBuilder.



CR:374274
CR Number:   374274
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)
26 Aug 2005 Presently Not Targeted For Any Future Release Of This Product
Description
EAServer SYJ ct_lib connection but not JDBC

If a pooled stateless component is deactivated and sent back to the pool without releasing the connection then it still holds a connection open on the database plus possibly table locks.
Review Status
 [2005-08-26]

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



CR:374330
CR Number:   374330
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2005 Fixed
Description
The customer has a datawindow with a column that has a Date editmask of MM/DD/YYYY. He wants to perform his own validation of entered dates, so he does not want PB to do any automatic changes to the entered values, that PB will do in date editmasks. To inhibit the automatic changes he has put the following in his PB.ini file:



[Edit Mask Behaviors]

AutocompleteDates=no



The following four scenarios describe what happens with various inputs. The primary complaint here is that he does not want PB to make any automatic changes to the values he types into the date editmask.



Scenario 1: If user enters 00/01/0000 (or 01/00/000) in the date field and tabs out, the itemchanged event does not fire and the date field has a displayed value of 00/00/0000. But if you click back in the field the value is still the value entered. Why does PB change it to 00/00/0000? Why is 00/00/0000 considered a valid date? If it is a valid date shouldn't the itemchanged event fire and the primary buffer get the value?

Desired behavior: Don't make any automatic changes to the value entered because the AutocompleteDates=no is set. Display a datawindow validation error message and fire itemerror when tabbing off because the 00/01/0000 value is not valid.



Scenario 2: If user enters 00/01/2000 in the date field and tabs out, PB changes it to 01/01/2000 and allows it, the itemchanged event fires. But if you click back in the field it is still 00/01/2000. If this is correct behavior why isn't the value in the primary buffer changed?

Desired behavior: Don't make any automatic changes to the value entered because the AutocompleteDates=no is set. A datawindow validation message should display and the itemerror event should fire because 00/01/2000 is invalid.



Scenario 3: If user enters 00/00/2000 in the date field and tabs out, you get a datawindow validation error message and the itemerror event fires. But the value displayed in the error message is 2000-01-00 and the value in the field is 00/00/2000. The data value passed into the itemerror event is also incorrectly 2000-01-00.

Desired behavior: Display the correct error message of 2000-00-00 and pass the 2000-00-00 value into the itemerror event.



Scenario 4: If user enters 01/00/2000 in the date field and tabs out, you get a datawindow validation error message and the itemerror event fires. This behavior seems correct and the correct value is displayed in the error message and passed to the itemerror event.



CR:374333
CR Number:   374333
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2005 Fixed
Description
In PB 10, if customer uses O84 interface and calls function which returns NCLOB or CLOB, he gets all the characters back. But if he calls same the function while connecting using O90 interface, he gets only some of the characters back. The end characters are truncated.



CR:374350
CR Number:   374350
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request for SCC: Add a check-out option in RMB menu in other areas than system tree/library painter. Currently, a developer needs to know in which pbl an object is located before he can check it out. This can be difficult/time-consuming in large projects. It would speed things up to be able to check out an object directly from a RMB popup menu on the object in the browser painter, in the open dialog, or as the result of a search.



CR:374420
CR Number:   374420
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Closed
OS:   Windows XP
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Apr 2005 Fixed
Description
A large composite report with many graphical objects is printed only partially.



CR:374426
CR Number:   374426
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows 2000
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2004 Fixed
Description
*) New Window

*) Add DataWindow control (no object, just a control)

*) Add button and script:



dw_1.AcceptText()



*) Run app and press button (run from within IDE)



PocketBuilder will crash



CR:374438
CR Number:   374438
Product Name:   PB Enterprise
Product Component:   MAPI
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Feb 2005 Consult Complete
Description
Tested and reproduced with PB 10.0.1_5502 and 8.0.4_10784.

Customer would like to have possibility to ommit sender name in MailMessage object. Today, we don't have a property to ommit it.



CR:374481
CR Number:   374481
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Solaris 2.8
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jan 2005 Not reproducible with latest version of the product available as of Resolution Date
07 Jan 2005 DEFER
Description
Application running EAServer on Solaris with PB Component accessing Oracle 9i database. Running on Solaris the component sometimes does not return result set, and component is deactivated. Problem does not occur when running EAServer on Windows. Cannot reproduce this problem here at Sybase. Consulting with engineering.



CR:374549
CR Number:   374549
Product Name:   PB Enterprise
Product Component:   ORCA
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2005 Fixed
Description
Doing "build project" task after "scc refresh target" task in OrcaScript causes GPF.



start session

scc get connect properties "w.pbw"

scc connect

scc set target "Benchmark.pbt" "outofdate exclude_checkout"

scc refresh target "full"

build project "pbexbm.pbl" "p_benchmark_pcode"

scc close

end session







no Workaround



CR:374550
CR Number:   374550
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2005 Fixed
Description
If we call the InsertObject() function, and insert a tif file with the link option activated, powerbuilder will crash. There is a workaround (using setredraw()) that works in W2000 but not XP. On XP it fails with -9. Happens also for other file types, ie. jpg, gif and sound files.
Workaround Description
 ________________________



ole_1.setredraw( false)



if ole_1.insertobject() <> 0 then

messagebox("","failed")

else

messagebox("", "success")

end if



ole_1.setredraw( true)



CR:374555
CR Number:   374555
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Windows XP
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jan 2005 Fixed
04 Mar 2005 Fixed
Description
Unable to convert successfully from Oracle charset WE8ISO8859P15 to Unicode.

This worked fine in previous Ansi versions of PB.



Workaround:

Change the both registry keys to AMERICAN_AMERICA.WE8MSWIN1252 to make the Oracle client convert to cp1252.



CR:374698
CR Number:   374698
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2005 Fixed
21 Feb 2005 Not a Bug
22 Nov 2005 Fixed
Description
A PB 9.0.2 regression. A component in EAServer uses a connection cache that is ODBC to MS SQL Server. When an embedded SQL delete where the where clause does not find any rows, is executed, the SQLCA.SQLCode returns a -1. When using PB 8.0.4 it returned a 0 which is the correct behavior, and with PB 9.0.2 standalone connected to the same odbc datasource the same sql delete also returns a 0.



CR:374745
CR Number:   374745
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 03 Jan 2005 Fixed
Description
The customer is using 8.0.4 and connecting to Oracle 9i. They have a datawindow with a retrieval argument of type number. In a database trace you can see that PB is binding the retrieval argument to a vchar type. This is causing some performance problems for the customer on the Oracle server as the string type does not match the index datatype.



The customer has been made aware of the workaround to set DisableBind=1 or to add an explicit CAST() (with whatever Oracle function is used) to the query.
Workaround Description
 Two workarounds: 1) Set DisableBind=1 or 2) Add an explicit CAST() (with whatever Oracle function is used) to the query.



CR:374873
CR Number:   374873
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
The customer is using a Micosoft OCX control. He has a datawindow which has computed columns. The expressions in these columns evaluate correctly when he opens the datawindow the first time. But after opening the window with the OCX control,the datawindow expressions no longer evaluate correctly, even though there has been no change to the data in the datawindow. Somehow the OCX which is on a separate window from the datawindow is interfering with the datawindow expressions.
Workaround Description
 I added a string() to each side of the boolean part of the expression so that it compares a string of digits instead of a number. That behaves as you would expect, evaluating to true (equal). So that is a possible workaround for the customer.



CR:374980
CR Number:   374980
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Feb 2005 Fixed
27 Mar 2005 Fixed
Description
In PB 10.0 there is a new boolean argument in the datawindow print that will bring up the system print dialog box when set to true; dwcontrol.Print(true,true). Normally you can select a range of page numbers to be printed. But this page range option is disabled when the system print dialog box is displayed from this call in PB.



CR:374998
CR Number:   374998
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jan 2005 Fixed
Description
A 10.0 listview control is displaying garbage characters in columns that have nothing in them and in columns where a space character was put with additem. If columns have data other than a space put to them, they seem to display OK. Everything was fine in 9.0.2.



CR:375086
CR Number:   375086
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.0 23 Jan 2005 Fixed
Description
Tested and reproduced with PB 10.0.1_5502, 10.0.1_6019, 10.0.0_4510

ASE: 12.5.2 on Windows 2000



When calling stored procedure to raise custom error message using SYC, only the 1st letter of the error message is retrieved. Works fine in PB 9.0.2_7509.



CR:375252
CR Number:   375252
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2005 Fixed
Description
Button text is put into 'Selected Text' color (white by default) which becomes unreadable on the button surface. Under XP themes, you cannot modify the button color to accomodate this.



CR:375254
CR Number:   375254
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jun 2005 Fixed
Description
A RPC call to a stored procedure returning a null value, fetches a "0" instead of NULL into Powerbuilder. The Stored procedure is in Oracle and is set up to return a number.



CR:375453
CR Number:   375453
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 25 Jan 2005 Fixed
Description
When calling an ASE 12.5 stored procedure with output parameters in a component deployed to EAServer using an EAServer connection cache (SYJ), you get the following error: "Error Executing bug_test2; SQLCode = -1 SQL DbCode = 137 SQL Error Text = Must declare variable '@rc'". In standalone PB when connected to the same database via SYC, the same calling code works fine.



CR:375568
CR Number:   375568
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Windows XP
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 May 2005 Fixed
Description
Custom java exceptions CORBAUserException from components in EAServer are not caught.

Instead there is a runtimeerror.



This is a regression that occurs from PowerBuilder 8 Build 10691 and PowerBuilder 9 Build 7196.



CR:375579
CR Number:   375579
Product Name:   PB Enterprise
Product Component:   BAM Deployment
Status:   Closed
OS:   Windows XP
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2005 Fixed
Description
When running a application exe where the

exe was compiled with a pbr file, the wmf is not included in the application exe.



It works ok with a jpg file but not a wmf file.



CR:375582
CR Number:   375582
Product Name:   PocketBuilder
Product Component:   Window - Runtime
Status:   Closed
OS:   Pocket PC 2002
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2005 Not a Bug
Description
Memory Error when doing fileread() multiple times. Memory is freed when application is closed, but not when you try to repeat the fileread running the application only once.



CR:375627
CR Number:   375627
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
The customer has an OCX called ActiveGannttVC Scheduler Component. This was working fine in 9.0. But after upgrading to a newer build of 9.0.2, the ole control with this ocx is painting it as transparent. You can see thorough it. It starts around build 7534. Seems to be some kind of migration issue, if you create the ocx control from scratch in the newer version all is OK. It's only controls migrated from an earlier version that paint as transparent...



CR:375711
CR Number:   375711
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   Linux
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jan 2005 Fixed
Description
Build number of the PBVM does not appear for a

shared library.



When running the following command to check the build number of a shared library,

the build number is not listed.



strings libpbvm90x.so | grep Version



For the other versions of the PBVM on unix, this information is available. For example

on solaris the following will appear:

Version 9.0.1.6533

Version Inconsistencies

Version: %s

getVersion

.

.

.



CR:375725
CR Number:   375725
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Linux
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2009 Not a Bug
Description
Createinstance is returning the following error:



Failed Distributed Service Error: E13 Could not create object of class sedcsm/n_sedcsm (70C)



From the jaguar.log:

Dec 23 10:59:25 2004: 180287-Library: 'libpbjag90x.so' for component type 'pb90'

Dec 23 10:59:25 2004: AFLIB Message: 18011/11/0: DLL lookup for 'libpbjag90x.so' failed, OS Message: '/lib/i686/libpthread.so.0: version `GLIBC_2.3.2' not found (required by /bigred1/duquette/jag/EAServer/lib/libpbjag90x.so)'





Dec 23 10:59:25 2004: AFLIB Message: 18011/11/0: DLL lookup for 'libpbjag90x.so' failed, OS Message: '/lib/i686/libpthread.so.0: version `GLIBC_2.3.2' not found (required by /bigred1/duquette/jag/EAServer/lib/libpbjag90x.so)'





Dec 23 10:59:25 2004: DynamicLibrary::lookup: af_dll_lookup (libpbjag90x.so, new_JagComponent) failed

Dec 23 10:59:25 2004: 180286-CTS_JagComponent::load: failed to load component model library

Dec 23 10:59:25 2004: 180918-CTS_Component::load: failed for component 'sedcsm_pkg/n_sedcsm'

Dec 23 10:59:25 2004: SystemException: OBJECT_NOT_EXIST (sedcsm_pkg/n_sedcsm:Home/create - @10.18.43.234)

Dec 23 11:12:30 2004: 180287-Library: 'libpbjag90x.so' for component type 'pb90'

Dec 23 11:12:30 2004: AFLIB Message: 18011/11/0: DLL lookup for 'libpbjag90x.so' failed, OS Message: '/lib/i686/libpthread.so.0: version `GLIBC_2.3.2' not found (required by /bigred1/duquette/jag/EAServer/lib/libpbjag90x.so)'





Dec 23 11:12:30 2004: AFLIB Message: 18011/11/0: DLL lookup for 'libpbjag90x.so' failed, OS Message: '/lib/i686/libpthread.so.0: version `GLIBC_2.3.2' not found (required by /bigred1/duquette/jag/EAServer/lib/libpbjag90x.so)'





Dec 23 11:12:30 2004: DynamicLibrary::lookup: af_dll_lookup (libpbjag90x.so, new_JagComponent) failed

Dec 23 11:12:30 2004: 180286-CTS_JagComponent::load: failed to load component model library



CR:375788
CR Number:   375788
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 01 Feb 2005 Fixed
Description
Column property html.appendedhtml not saved by GetFullState.



CR:375792
CR Number:   375792
Product Name:   PB Enterprise
Product Component:   MAPI
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2005 Fixed
Description
Cannot send hebrew or chinese characters from a PB-MAPI application



CR:375793
CR Number:   375793
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jun 2005 Fixed
Description
When trying to create a datawindow in the painter with the following syntax:



SELECT TOP :NumRows * FROM DEPARTMENT



where NumRows is a retrieval argument of type number, you get the error:



"Error -674 Statements size limit is invalid"



If you do "SELECT TOP 3 * FROM DEPARTMENT" all is fine and it works. A PB trace shows that on the retrieval argument select the painter sends "SELECT TOP 0 * FROM DEPARTMENT" to the database. This causes the size limit error becasue a 0 is invalid. On the initial send of the syntax to the database, the painter needs to do a valid substitution for the retrieval argument.



CR:375802
CR Number:   375802
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 28 Mar 2005 Fixed
Description
A datawindow has a blob column. If the main dw retrieve returns rows, but the blob key clause is such that no blob column is retrieved, then a subsequent unrelated select returns incorrect data.



CR:375807
CR Number:   375807
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2005 Fixed
Description
Header group column width aren't well adjusted on crosstab DataWindows.

The width of header column @col is to short.



CR:375811
CR Number:   375811
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2005 Fixed
Description
The customer has a Tidestone Formula One OCX in a window OLE contol. It's a spreadsheet type of OCX and they load data into it from a datawindow and all is OK in PB 8.0.4. But upon migrating the app to 10.0, the control no longer displays any data after it is loaded from the datawindow. Creating a new OLE control in 10.0, has the same problem, no data is displayed.



CR:375872
CR Number:   375872
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2005 Fixed
Description
Error when order of array arguments is not the sames in report and child datawindow. Error is "Retrieve argument 1 does not match excpected type".
Workaround Description
 If the order of the array args in the main report correspond to the order in the nesteds then it will run ok.



CR:375908
CR Number:   375908
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 29 Jun 2005 Fixed
Description
Two regressions in 9.0.2 from 8.0.4 involving datawindow editmask columns. The first problem is a datetime column with an editmask of date. The editchanged event is firing twice on each change when it should only fire once. The data argument passed into the event is incorrect the first time, and is correct the second time. A gettext() called in the editchanged event is also incorrect the first time and is blank the second time. In 8.0.4 the editchanged fires only once and the data argument is correct, although a gettext() call is blank.



The second problem is a datetime column that has an editmask of hh:mm and a spincontrol. The field is too narrow so you can't see all of the 4 digits. When you enter valid data you can see the format is changed and when you tab off, you get a validation error. In 8.0.4 the valid data was entered correctly and you could tab off with no validation error.

The problem can be corrected in 9.0.2 by making the field wider so that you can see all 4 digits.



CR:375961
CR Number:   375961
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 06 Feb 2005 Fixed
Description
For SYC native dirver, PB fail to pass string argument greater than 255 to Sybasee 12.5x.

For ODBC driver, Sybase ASE 12.5.x fail to return output string argment greater than 255 to PB
Workaround Description
 For SYC connection only, replace the output string argument to blob data type can successfully return argument greater 255.



e.g.

subroutine rpc_out(string in255, REF string out255) RPCFUNC ALIAS FOR "inout255"

modified to

subroutine rpc_out(blob in255, REF string out255) RPCFUNC ALIAS FOR "inout255"



CR:375977
CR Number:   375977
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 25 Jan 2005 Fixed
Description
When calling a sp, the sp will fail with an Invalid column name error.



From the trace from PB 10, it shows the following:

ce1a40): EXECUTE:

(ce1a40): EXECUTE dbo.mpb_flp_batch_label @i_printer_id = 0, @i_printer_ut_id = 804, @i_printer_type = "SAM8400D", @i_header_user = "sa", @i_client_id = "PREPNISH", @i_client_unit_id = 804, @i_parm1 = 1, @i_parm2 = 804, @i_reprint_flag = "0", @o_return_code = a OUTPUT

(ce1a40): SRV 16 #207 Invalid column name 'a'. (0 MilliSeconds)

(ce1a40): SRV 16 #207 Invalid column name 'a'. (0 MilliSeconds) (60 MilliSeconds)

(ce1a40): Error 207 (rc -1) : Invalid column name 'a'.



Using Ribo, it shows the following:

LANGUAGE Token

Status [1]: UNUSED (0x00)

Text [313]: "DECLARE @o_return_code鐆/ char(1) EXECUTE dbo.mpb_flp_batch_label @i_printer_id = 0, @i_printer_ut_id = 804, @i_printer_type = "SAM8400D", @i_header_user = "sa", @i_client_id = "PREPNISH", @i_client_unit_id = 804, @i_parm1 = 1, @i_parm2 = 804, @i_reprint_flag = "0", @o_return_code = @o_return_code鐆/ output "



Capture Record Header

Source [4]: RESPONSE (0x00000002)

EED Token

Message Number [4]: 102

Message State [1]: 1

Message Class [1]: 15

SQL State [5]: "42000"

Status [1]: NO_EED (0x00)

Transaction State [2]: TDS_NOT_IN_TRAN (0x0000)

Message Text [27]: "Incorrect syntax near '/'."

Server Name [7]: "CATALPA"

Line Number [2]: 1

EED Token

Message Number [4]: 137

Message State [1]: 2

Message Class [1]: 15

SQL State [5]: "ZZZZZ"

Status [1]: NO_EED (0x00)

Transaction State [2]: TDS_NOT_IN_TRAN (0x0000)

Message Text [42]: "Must declare variable '@o_return_code鐆'. "



The sp is called from the n_cst_label_print/of_flp_main_execute. The setup of the

arguments is done from n_cst_label_print/of_flp_register_app.



CR:376004
CR Number:   376004
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Closed
OS:   Pocket PC 2002
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
675 12 Jan 2005 Fixed
Description
In the PDA (runtime) the syntax generated by "datawindow.syntax" is

not usable by "datawindow.create(string)"



1) release 8; should be release 9;

2) edit.inputeditmode=0 is not understood by PocketBuilder (though it

exports it)



CR:376095
CR Number:   376095
Product Name:   PB Enterprise
Product Component:   ORCA
Status:   Closed
OS:   Windows XP
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jun 2005 Presently Not Targeted For Any Future Release Of This Product
Description
When using orcascript and the exclude_checkout, a object

that is checked out appears to be getting overwritten anyways.



When a target is checked out and then you add a pbl to the library list, once you

run the orcascript and then reopen PB you will notice that the pbl you had added is

no longer included in the library list.



Using the following script:

start session

scc get connect properties "C:\pse\pse-90\11101366\test1.pbw"

scc set connect property logfile "C:\pse\pse-90\11101366\recompile.log"

scc set connect property logappend "FALSE"

scc connect

scc set target "C:\pse\pse-90\11101366\test1.pbt" "outofdate exclude_checkout"

scc refresh target

scc close

end session



Problem happens when using PBNative. With PVCS the following dialog appears:

Confirm Overwrite Work File

A Writable "<targetname.pbt>" Exists. Check out anyway?



If you hit no, the target file does not get overwritten. But the log file shows the following:

/6/2005 09:55 Source Management Initialization...

Scc Provider: PVCS Source Control

UserID: duquette

Project Path: /PB_11013666?PVCS Version Manager?C:\Program Files\PVCS\vm\common\SampleDB?

Aux Project Path: ?PVCS Version Manager?C:\Program Files\PVCS\vm\common\SampleDB?

Local Project Path: c:\pse\pse-90\11101366



Connection to source control established

PBORCA_SccSetTarget: c:\pse\pse-90\11101366\test20.pbt

Target settings: REFRESH OUT OF DATE | EXCLUDE CHECKOUT

Non Specific Error performing SccGetLatest()

Unable to get latest version of c:\pse\pse-90\11101366\test20.pbt from SCC. Operation cannot continue.

PBORCA_SccClose

1/6/2005 09:55 Source control terminated





If you hit yes when the Confirm Overwrite Work File, than the target file does get overwritten (even though exclude_checkout is set). The log file shows the following:



/6/2005 09:57 Source Management Initialization...

Scc Provider: PVCS Source Control

UserID: duquette

Project Path: /PB_11013666?PVCS Version Manager?C:\Program Files\PVCS\vm\common\SampleDB?

Aux Project Path: ?PVCS Version Manager?C:\Program Files\PVCS\vm\common\SampleDB?

Local Project Path: c:\pse\pse-90\11101366



Connection to source control established

PBORCA_SccSetTarget: c:\pse\pse-90\11101366\test20.pbt

Target settings: REFRESH OUT OF DATE | EXCLUDE CHECKOUT

PVCS Source Control Info: /PB_11013666/test20.pbt Checked out revision 1.0.

App Name: test20 App Lib: c:\pse\pse-90\11101366\test20.pbl

Library List:

c:\pse\pse-90\11101366\test20.pbl

PBORCA_SccRefreshTarget. Full Rebuild

PVCS Source Control Info: /PB_11013666/test20.pbg Checked out revision 1.0.

Calling cm_rebuild_application(CM_REBUILD_FULL).

PBORCA_SccClose

1/6/2005 09:57 Source control terminated



RESOLUTION: At current,"Scc set target" will use .pbt file in the scc server. It will overwrite .pbt file in the local.



It is a good logic, because "Scc set target" can only rely on the file of server. Because at most of time .pbt file does not exist in the local.



If we want use local .pbt file ,we must check in it before invoke "Scc set target".



CR:376155
CR Number:   376155
Product Name:   PB Enterprise
Product Component:   PB DOM
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2006 Not a Bug
Description
Customer is using PBDOM calls like BuildFromString on a Citrix server with reduced premissions on the root directory and it causes a failure.



CR:376198
CR Number:   376198
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.2 24 Jan 2005 Fixed
Description
RPC function with array argument failed if first value is empty. the error is "ORA-01403 : No data found" appear and all values behind are lost. No problem with O84 driver.



CR:376199
CR Number:   376199
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.2 24 Jan 2005 Fixed
Description
RPC function to Oracle with array argument crashes if first value of the string array is set to NULL. The gpf is in:

Exception code: C0000005 ACCESS_VIOLATION

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



CR:376226
CR Number:   376226
Product Name:   PB Enterprise
Product Component:   P-Code Exe Creation
Status:   Closed
OS:   Windows XP
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2005 Fixed
Description
When creating a pcode exe, pb will crash with

an access violation error in the pbvm90.dll. From the project painter, the crash

occurred while 'Inspecting application objects'.



The crash handler reported the following:

xception code: C0000005 ACCESS_VIOLATION

File Name: C:\pb\pb9\Shared\PowerBuilder\PBVM90.dll

File Version: 9.0.2.7559

Fault address=10C98169 Section:Offset=01:00197169



Registers:

EAX:00000000

EBX:00B7E7B0

ECX:00000000

EDX:0012E4E4

ESI:00B7E7B0

EDI:00000000

CS:EIP:001B:10C98169

SS:ESP:0023:0012E4D8 EBP:00000006

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

Flags:00010246



Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

10C98169 0012E4D8 00B7E7B0 00000000 0012E4F8 00000000 ob_destroy_rtinst+49

10C9D779 0012E4F0 00B7E7B0 00000000 06ED260C 00B7E7B0 ob_get_obinst_system_class+39

10BE47EC 0012E520 00B7E7B0 07966890 00000000 00000001 FN_CtlCreateAll+9C

10C867C6 0012E544 0000406B 07966890 046CAB88 00000000 ob_link_project+C26

10C86DB8 0012E564 00000058 0000DAC0 046CAB88 00000001 ob_link_project+1218

10C86FB0 0012E58C 00B702BC 04390C30 07930C34 046C9B88 ob_link_project+1410

10C86D5B 0012E5B0 0000001C 0000D890 046C9B88 00000001 ob_link_project+11BB

10C86FB0 0012E5D8 00B702B5 043DA794 03152794 05FE9768 ob_link_project+1410

10C86D5B 0012E5FC 00000010 0000D1B0 05FE9768 00000001 ob_link_project+11BB

10C86FB0 0012E624 00B7029F 043D463C 03FF07D4 05FE9208 ob_link_project+1410

10C86D5B 0012E648 0000000B 0000D110 05FE9208 00000001 ob_link_project+11BB

10C86FB0 0012E670 00B7029D 043D113C 03C51360 05FE91C8 ob_link_project+1410

10C86D5B 0012E694 00000001 0000D0C0 05FE91C8 00000001 ob_link_project+11BB

10C86FB0 0012E6BC 00B7029C 043CACA4 036C5748 05FE8FE8 ob_link_project+1410

10C86D5B 0012E6E0 00000008 0000D070 05FE8FE8 00000001 ob_link_project+11BB

10C86FB0 0012E708 00B7029B 06F27BB8 0683CFF8 00C3F208 ob_link_project+1410

10C86D5B 0012E72C 00000022 00000230 00C3F208 00000001 ob_link_project+11BB

10C86FB0 0012E754 00B70007 06F23978 068336D4 02E00528 ob_link_project+1410

10C86D5B 0012E778 00000013 000001E0 02E00528 00000001 ob_link_project+11BB

10C86FB0 0012E7A0 00B70006 06F22680 06F21DA8 02E02428 ob_link_project+1410

10C86D5B 0012E7C4 00000001 00000190 02E02428 00000001 ob_link_project+11BB

10C86FB0 0012E7EC 00B70005 06F20C00 06EF23C8 02EB4A48 ob_link_project+1410

10C86D5B 0012E810 00000001 00000140 02EB4A48 00000001 ob_link_project+11BB

10C86FB0 0012E838 00B70004 00BA6324 0688E62C 00C28D28 ob_link_project+1410

10C86D5B 0012E85C 0000000F 00000050 00C28D28 00C6FC20 ob_link_project+11BB

10C83881 0012E87C 00B7E7B0 00C6FC20 00BB057C 0000002B ob_create_appl_report+C1

1080BC22 0012E898 77D46AF8 00BA907C 0012F01C 00010011 CreatePBIGeneratorFactory+5482

1080BB8B 00BB057C 108104E0 00000002 00B7D644 0007079C CreatePBIGeneratorFactory+53EB

10810500 10810560 108069B0 108069E0 10806A20 10806A30 0002:00000500 C:\pb\pb9\Shared\PowerBuilder\PBAPL90.dll

1080699F 108068E0 C0681424 56108129 000007C7 C7E80000 CreatePBIGeneratorFactory+1FF

7C8B570C 24748B56 00000000 00000000 00000000 00000000 0001:0002470C C:\WINDOWS\System32\CLBCATQ.DLL



CR:376245
CR Number:   376245
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2005 Fixed
Description
When customer is connected to PVCS and they try to deploy web target, they get error.



Error: Deployment JAR initialization failed. changerequest Deployed - 2 error(s), 0 warning(s)

When they are not connected to PVCS, deployment works fine.



CR:376346
CR Number:   376346
Product Name:   PocketBuilder
Product Component:   Language - Runtime
Status:   Open
OS:   Pocket PC 2002
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0.1 Beta 675 Fixed
Description
The "PhoneCall" object's *constructor* is failing if the device is not phone enabled.

Instead, the internal state of the object should hold this information and simply refuse to function (return an error).



CR:376398
CR Number:   376398
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 23 Feb 2005 Fixed
Description
A regression from 7.0.4. An editmask column with a code table was editable in 7.0.4, and you could make a change and tab off the column. But in 9.0.2, you can still make the change, but when you tab off you get a validation error "Value must be greater than zero".



CR:376563
CR Number:   376563
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Feb 2005 Fixed
Description
A COM object that builds successfully in 9.0.2, fails to build in 10.0. There are compiling and linking errors.



CR:376564
CR Number:   376564
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Open
OS:   Windows XP
Original Version:   10.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
After creating a ADO Microsoft ADO .Net database profile

using the System.Data.SqlClient Namespace in the DW Designer, once you reopen

the profile some of the properties are missing.



CR:376586
CR Number:   376586
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Windows XP
Original Version:   10.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2005 Fixed
Description
When using the right mouse button on an item in the Control List for a DataWindow, the Delete menu click seems to be ignored, but inconsistently. At one point, the first Delete always worked, but TSE could only delete again if he switched to another pane and then back to Control List. TSE was also able to always delete the last item in the control list. And at somepoint in those scenarios, it started working regardless of which object were clicked, even when he closed and reopened the datawindow. However, if restarted PB, the odd behavior would recur.
Workaround Description
 seems that if select bring to front first , then select delete , it works.



CR:376734
CR Number:   376734
Product Name:   PB Enterprise
Product Component:   DW Plugin
Status:   Closed
OS:   Windows XP
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Feb 2005 Fixed
02 Mar 2005 Fixed
20 Jan 2005 Presently Not Targeted For Any Future Release Of This Product
Description
When using the DW plugin on Netscape to view a psr

file, the file is not showing up in the browser.



When you move the npbdwe100.dll to the Netscape plugins directory, it showing it

with a application/datawindow9 mime type.



CR:376833
CR Number:   376833
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2009 DEFER
Description
When using nested reports in a datawindow changing <DW Control Name>.Object.DataWindow.Print.Preview.Zoom while in preview jumps back to page 1, although you might be on page x. In a normal datawindow this doesn't happen.
Workaround Description
 code example:

string ret, row

int i



row = dw_1.Object.DataWindow.FirstRowOnPage



ret = dw_1.Describe("Evaluate('pageabs()', "+row+")")

messagebox("", ret)

dw_1.Object.DataWindow.Print.Preview.Zoom=150



for i=1 to (Integer(ret) - 1)

dw_1.scrollnextpage()

next



CR:376834
CR Number:   376834
Product Name:   PocketBuilder
Product Component:   Documentation
Status:   Open
OS:   Windows 2000
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
PocketBuilder 2.0 : Looking for doc about CAB Configuration Tool.

new tool "Cab configuration tool " in PocketBuilder2.0-->New-->Tool--> CAB Configuration Tool
Workaround Description
 http://sys-con.com/pbdj/article.cfm?id=608



CR:376846
CR Number:   376846
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Need to Understand from Engineering on the numbers shown in IIOP stats. in Jag Manager.

Customer is seeing values for Sessions, Last Maximum Session, Peak Maximum session increment when there is only one client session involved. They want to know why this is happening.



CR:376885
CR Number:   376885
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   Windows XP
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2005 Fixed
Description
PowerBuilder is hitting a breakpoint with (PB_HEAP_DEBUG=true) when importing a datawindow .srd file.



CR:376944
CR Number:   376944
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 16 Mar 2005 Fixed
Description
If you select PB Native as SCC provider and specify "P:\" as the project path (no subfolders), you'll see many error messages in the output window. Actually, any project path that ends with a backslash will cause this condition.

Workaround is to remove the backslash at the end of the project path or upgrade to latest EBF of PBNATnn.DLL.



CR:376968
CR Number:   376968
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Feb 2005 Fixed
Description
A large Ansi text file gets only partially imported into a datawindow in PowerBuilder 10.

The text file could be imported fine in PowerBuilder 9.

Also a unicode text file imported fine in PowerBuilder 10



CR:377006
CR Number:   377006
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Windows XP
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2005 Fixed
Description
On Windows XP, the border for a text datawindow column that is set as Lowered appears as a thick dark line when the data value in that column is null (looks like the height of the column may be set to 0 so we see the top and bottom of the border compressed).



CR:377104
CR Number:   377104
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2005 Fixed
Description
The computed column is missing in "Sort" tab for SQL Tab in graphic mode while creating new DataWindow. It simply shows all columns of the table being used in the select statement.



CR:377129
CR Number:   377129
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
This is a request for PB Engineering to look at the customer's scc log files to see if they can shed any light on what is happening to the customer. PB 9.0.2 and PVCS. Objects seem to drop out of SourceControl. Their status changes to "not in Source Control" (a +) intermittently. Once the status changes to a + it does not change back till PB is restarted. This happens while connected to Merant Version Mgr. 8.0.2.



The customer reports that they always see the error when they have more than one PBL expanded and when they go expand more PBLS. As soon as a new PBL is expanded the objects all appear with "+"s against them. The customer believes that this was not a problem in PB8.0 and consequently should be working in PB9.0.2 as well.



10/27/2005 Customer upgraded to PVCS version 8.0.2.3 (Build 662) and problem went away.



CR:377132
CR Number:   377132
Product Name:   PocketBuilder
Product Component:   Window - Runtime
Status:   Open
OS:   Pocket PC 2002
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Call to SetNull(blobvar) then passing that blob var to a function to read a file into the blob. The file is never added to the blob - length remains zero/null.



CR:377138
CR Number:   377138
Product Name:   PocketBuilder
Product Component:   Application Painter
Status:   Closed
OS:   Windows XP
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
678 29 Jan 2005 Fixed
Description
If you run the application PocketBuilder crashes. Run again with the application object open in the Application Painter and there is no crash. Appears to be something specific to this application, perhaps something in the Open event code, as this problem does not occur with other applications.



CR:377148
CR Number:   377148
Product Name:   PocketBuilder
Product Component:   System Runtime Functions
Status:   Closed
OS:   Windows XP
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2005 Fixed
Description
Call to GarbageCollect function causes PocketBuilder to crash.



CR:377269
CR Number:   377269
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 14 Jun 2005 Fixed
Description
When using setredraw on a composite report and

you set a filter on a child dw, pb will crash when filter() is called.



The crash handler shows the following error:



Exception code: C0000005 ACCESS_VIOLATION

File Name: C:\pb\pb10\Shared\PowerBuilder\PBDWE100.dll

File Version: 10.0.1.6052

Fault address=107023B6 Section:Offset=01:001413B6



Registers:

EAX:00000000

EBX:0302473C

ECX:00000000

EDX:00000000

ESI:00C398AC

EDI:0000189B

CS:EIP:001B:107023B6

SS:ESP:0023:0012CECC EBP:00000587

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

Flags:00010246



Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

107023B6 00000587 00000000 00000000 00000000 00000000 dwTabSortCmp+6836



CR:377272
CR Number:   377272
Product Name:   PocketBuilder
Product Component:   Window - Runtime
Status:   Closed
OS:   Pocket PC 2002
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
679 28 Jan 2005 Fixed
Description
For an application deployed to the PDA, double-clicking the shortcut will SOMETIMES launch the application twice.

There must be some timing hole in the "FocusToPreviousInstance" system function.



CR:377390
CR Number:   377390
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 13 Apr 2005 Fixed
Description
PB component with Dynamic SQL causes memory leak



CR:377422
CR Number:   377422
Product Name:   PB Enterprise
Product Component:   EJB Client
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2005 Fixed
Description
A simple call to an EJB which returns an array ob objects produces a memory leak.



CR:377472
CR Number:   377472
Product Name:   PB Enterprise
Product Component:   DW XML
Status:   Closed
OS:   Linux
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2005 Not a Bug
Description
ImportString returns -1 when importing a xml string

into a datastore.



li_FileNum = FileOpen(file_xml,StreamMode! )

iret=FileRead(li_FileNum,string_xml)

iret = ids.importstring(XML!,string_xml,1,75,1,20,1)



CR:377474
CR Number:   377474
Product Name:   PB Enterprise
Product Component:   DW XML
Status:   Closed
OS:   MS Windows 3.1
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2005 Not a Bug
Description
When importing a file of type xml, ImportFile will

fail with a return code of -4.



iret = ids.importfile(XML!,file_xml)



CR:377476
CR Number:   377476
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Open
OS:   Linux
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When using the getenvironment() to populate the

environment structure, the osType will return sol2! when running the PBVM on

linux.



CR:377544
CR Number:   377544
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Windows XP
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2005 Not a Bug
Description
After removing all PowerBuilder objects from source control through the PB IDE, there may be extra files like vssver.scc and libname.PBG that remain in the SCC repository. These may be manually deleted by the SCC administrator. The PB IDE will not automatically delete these metadata files.
Workaround Description
 Manually delete the extra files from the SCC repository using the Vendor's administration utility.



CR:377557
CR Number:   377557
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 01 Feb 2005 Fixed
Description
TX OCX Control (Rich text edit control from The Imaging Source Europe GmbH )

OCX does not appear correctly in the most recent builds of PB, when it worked fine in earlier builds. (pre PB 9.0.2 7534+)
Workaround Description
 Create a new window/userobject and place the ole/activex on it and save it with the new version (builds higher 7534+) then it will work.



CR:377605
CR Number:   377605
Product Name:   PB Enterprise
Product Component:   Project Painter
Status:   Closed
OS:   Windows XP
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2005 Fixed
Description
When you specify a unc entry for the Executable File

Name in the application project painter, the executable does not get created.



The following error results:

---------- Deploy: Deploy of p_pb10_unc_exe

Creating executable file...

Inspecting Application Dependencies...

Inspecting Application Dependencies...

Inspecting application libraries...

Create of executable file failed

---------- Finished Deploy of p_pb10_unc_exe



CR:377715
CR Number:   377715
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.3 14 Sep 2005 Fixed
9.0.2 02 Dec 2005 Fixed
Description
Differences in behavior between MSS and OLE DB connections for datawindow editstyles of dropdownlistbox, checkbox, and radiobuttons. The display is incorrect using OLE DB.



CR:377717
CR Number:   377717
Product Name:   PB Enterprise
Product Component:   ORCA
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 01 Mar 2005 Fixed
Description
The PBORCA_LibraryEntryExport function generates incorrect hexascii representation of the binary component of the object. Specifically, the last data record should be zero-filled to the fixed length of all the other data records. Also, the last data record is mistakenly generated twice.



With this fix applied, the binary component generated by LibraryEntryExport should be identical to the binary component generated by the library painter "export" menuitem.

This actual fix for this problem is in PBVM90.DLL, not PBORC90.DLL. New PBVM90.DLL must be deployed for this fix to be seen.



Not a problem in PB10.
Workaround Description
 PB 9 users need this fix. PB10 should be fine.



CR:377724
CR Number:   377724
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2005 Not a Bug
Description
Setting the following Print Specification Properties in the datawindow:

Paper Orientation = Landscape

Paper Size = Legal 8 x 14

Then doing a SaveAs(PDF!) Distill! Method. When Printing the resulting PDF File, it is not using the correct paper size. No sure this is a PB problem. When you open up the PDF file in Adobe, it is displayed in landscape, and the document properties show a page size of 8 1/2 x 14. But when you print it shows portrait and 8 1/2 x 11 as the defaults. It prints in landscape but on 8 1/2 x 11 paper.



CR:377873
CR Number:   377873
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2005 Duplicate
Description
Regression: Dw column Format for number ****#,##0.00 shows incorrect display in PB 9.0.2

Tested and reproduced with PB 9.0.2_7554 and 10.0.1_7554. Works fine with PB 7.0.2



The display in PB 9 and 10 for number 2.91 becomes 0,002.91 and in PB 7 becomes 2.91 correctly.
Workaround Description
 Use \*\*\*\*#,##0.00 format instead.



CR:377985
CR Number:   377985
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2007 Not reproducible with latest version of the product available as of Resolution Date
Description
Performace is very slow in version 9



CR:378044
CR Number:   378044
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2005 Fixed
Description
Tab characters in DW displayed as boxes if dw column does not have focus. CR #310775 dealt with embedded CR/LFs in the data having different display depending if field has focus, a similar fix should have been applied for Tab Characters as well.



CR:378227
CR Number:   378227
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   Windows XP
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2005 Fixed
Description
When calling a stored procedure with no return value, the following error will occur:



-410 Prepare statement failed or was not executed.



The pbtrace log shows the following:

(c98610): SERVER=tbone@tbone_informix9(DBI_CONNECT)

(c98610): (DBI_CURSOR_CONNECTION)

(c98610): (DBI_SPECIAL_DECIMAL)

(c98610): (DBI_SPECIAL_DOUBLE)

(c98610): PREPARE:

(c98610): execute test_proc ( 100 ) (DBI_PREPARE)

(c98610): GET AFFECTED ROWS:(DBI_GET_AFFECTED_ROWS)

(c98610): ^ 1 Rows Affected

(c98610): GET NUMBER OF COLUMNS SELECTED:(DBI_GET_SELECT_ITEMS)

(c98610): ^ 0 Columns

(c98610): EXECUTE:(DBI_DYN_EXECUTE)

(c98610): *** ERROR -410 ***(rc -1) : SQL Error -410 : Unknown error message number '-410'

(c98610): CANCEL:(DBI_CANCEL)

(c98610): DISCONNECT:(DBI_DISCONNECT)



CR:378231
CR Number:   378231
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Open
OS:   Windows XP
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When running a stored procedure with Informix odbc,

the following error will result:



(c98610): PREPARE WITH BIND VARIABLES:

(c98610): execute test_proc ( ? )

(c98610): INT Length=0 ID=?

(c98610): *** ERROR -11116 ***(rc -1) : SQLSTATE = S1003

[Informix][Informix ODBC Driver]Invalid application buffer type.

(c98610): CANCEL:

(c98610): DISCONNECT:



CR:378297
CR Number:   378297
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Apr 2005 Fixed
Description
When using an Crystal Report ole component a call to the component will cause a subsequent update fail.



no workaround



CR:378457
CR Number:   378457
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2005 Fixed
Description
If "Allways Show Arrow" and "Allow Editing" is choosen for a DDDW or DDLB the arrow width is bigger than if only "Allways Show Arrow" is choosen. This happens only if the XP style is used.



no workaround



CR:378458
CR Number:   378458
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 10 May 2005 Fixed
Description
When a datawindow has a conditional expression set and additionally a modify() call is being made to its columns, it will decrease scrolling performance of scrolltorow() considerably.
Workaround Description
 Around the scrolltorow() function place dw redraw functions, eg:

for ...

dw_1.setredraw(false)

dw_1.scrolltorow(i)

dw_1.setredraw(true)

next



CR:378460
CR Number:   378460
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.0 02 Mar 2005 Fixed
Description
Unicode characters are lost whenb using copyRtf/pasteRtf



CR:378476
CR Number:   378476
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.0 10 Mar 2005 Fixed
Description
DataWindow.Data.HTML property does not include header and footer background color



CR:378507
CR Number:   378507
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Windows XP
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.0 05 Feb 2005 Fixed
Description
When using selectbob to retrieve a column of type long,

the data appears to be getting truncated.



The table is defined as:

create table testlong ("id" number 5,0) not null, "mydata" long);

alter table testlong add (constraint pk_long_id primary key ("id"));



blob mydata

SELECTBLOB mydata

INTO :mydata

FROM testlong

WHERE id = 1 ;



CR:378608
CR Number:   378608
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 08 Mar 2005 Fixed
Description
Request for an utility that can automate the resaving of windows when moving to the

XP platform as described by CR 340943 and Release Bulletin PowerBuilder Enterprise 10.0.1 :

4.2 Window sizing change or change the solution of CR 340943.



The solution of CR 340943 has been modified.



CR:378642
CR Number:   378642
Product Name:   PocketBuilder
Product Component:   Menus - Runtime
Status:   Open
OS:   Pocket PC 2002
Original Version:   2.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
An application deployed to a NON-PocketPC or SmartPHone device (like the HP-Jornada 720) has non-functional menus. Additionally, the painting seems messed up.

This is undoubtedly because the PocketPC & SmartPhone menu handling is with AYGSHELL functions that don't exist on the "bare" WinCE platforms.



CR:378648
CR Number:   378648
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2005 Fixed
Description
When running the PFC examples PB is disappearing. No error messages, no GPF messages. It happens on an example that links a treeview and a listview. Tracing the code it happens when a listview AddColumn object function is called. This is a PB problem, not a PFC issue. The PB 9 PFC examples run fine in PB 9.0.2 but when migrated to 10.0.1 the same app crashes.



CR:378696
CR Number:   378696
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Closed
OS:   Pocket PC 2002
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0.1 685 14 Feb 2005 Fixed
Description
Bug in the syntaxFromSQL() function in the PocketBuilder 2.0 version (build 659). It doesn't happen with the desktop VM but only on the PocketPC VM. If the select joins two tables together and creates a datawindow with a column from the second table (only exists in second table, not in both tables) the resultant column name in the datawindow is prefixed with the first table name. So:



table1 has columns primekey and column_a

table2 has columns primekey and column_b



After running the code below on a PocketPC and checking the syntax generated, you will see that the datawindow column name is table1_column_b rather than table2_column_b as it should be.



CR:378749
CR Number:   378749
Product Name:   PB Enterprise
Product Component:   Function Painter
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Apr 2005 Fixed
Description
A global function with many arguments (75) cannot be successfully edited in the function painter. PowerBuilder crashes. The problem may be a combination of the number of arguments and the length of the argument names since another function with the same number of arguments could be successfully modified. However it was a test function where the argument names did not need to be meaningful to the application developer.



CR:378787
CR Number:   378787
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   Windows XP
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2005 Not a Bug
Description
When calling a stored procedure using Declare and Fetch,

the following sql error appears when executing the stored procedure:



Can't use the OUTPUT option when passing a constant to a stored procedure

reate PROCEDURE dbo.sp_test

@test_in tinyint,

@test_out tinyint OUTPUT



AS



BEGIN

SELECT @test_out = @test_in * 2

END



CR:378873
CR Number:   378873
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Windows XP
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Feb 2006 Fixed
Description
Tested and reproduced with PB 10.0.1_5502, 10.0.1_6044

Text Color never changes for group box in StyleLowered! in Windows XP only.
Workaround Description
 Do not use StyleLowered! in BorderStyle



CR:378875
CR Number:   378875
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Apr 2005 Fixed
Description
This is an extension to CR 369324. CR 369324 fixed the problem with simple arguments, but for more complex arguments (nested types) the debugger doesn't show the value. Currently they have to be casted to derived classes and then they are observable in the Debugger.
Workaround Description
 Currently they have to be casted to a variable of the correct type and then they are observable in the Debugger.





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