远程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:317914
CR Number:   317914
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 17 Sep 2003 Not reproducible with latest version of the product available as of Resolution Date
Description
Versions and Build #s Reported: 8.03

Versions and Build #s Tested: 8.03.9704 and earlier OK

9809 and later - Crash

9.0 GA and later - Crash

Comments:



Regression, broke in 8.03.9809.



Calling a global function in a datawindow validation rule. The code in this function opens a response window which will crash PB on closing the window. A non response window does not crash and neither does MessageBox.



Calling a response window from the DW ItemChanged or ItemError event also works fine

Example crash in 8.03 build 9918 (but it varies)



*****

The exception Breakpoint

A breakpoint has been reached

(0x80000003) occurred in the application at location 0x002a1609

****
Workaround Description
 Do not call windows from global functions when these functions are to invoked from a dw validation rule - Use Itemerror & ItemChanged events instead.



CR:317920
CR Number:   317920
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2003 Fixed
Description
Error creating WebService Proxies from WSDL file for the Web service.



CR:317921
CR Number:   317921
Product Name:   PocketBuilder
Product Component:   DW Painter
Status:   Open
OS:   Windows 2000
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
I cannot create a new datawindow with PPB beta build 62. As soon as I select a display style (any style) and click OK, PPB crashes.



CR:317923
CR Number:   317923
Product Name:   PocketBuilder
Product Component:   PB GUI
Status:   Open
OS:   Windows 2000
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
Cannot create a new Target with PPB beta build 62. PPB crashes as soon as I click OK, after selecting any of the 4 icons on the Target tab. New...Target...(any icon)...Okay...GPF



CR:317944
CR Number:   317944
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement:Ability to use a global variable in the SQL query of a datawindow



CR:317946
CR Number:   317946
Product Name:   PB Enterprise
Product Component:   DW Graph
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement:Ability to choose the data points, font, and the colors in a graph.



CR:317957
CR Number:   317957
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 26 Jun 2003 Fixed
18 Sep 2003 Fixed
Description
Datawindow migrated from PB7 to PB9 crashes the dw painter. Appears to be related to a combination of a Group in the datawindow and a computed field that uses the "Len" function in its expression. If either the Group or the Computed field is deleted, the problem does not occur.



CR:318060
CR Number:   318060
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2003 Not a Bug
Description
The position func. of RichTextEdit returns wrong position value compared with that of PB 5.x. After movement of cursor on RTE, the position value showed correctly.



<<---------------- NOT a Bug -------------------------------------------------------->>

From PB7 to PB9

1. The position Func in Key event of RTE returned the same position from pb5

2. The position Func. in post user event call which called in Key event of RTE

returned different from pb5

( confirmed append ret.Paste()in user event after position func.)

This is reported in PB8 help doc. (refer below)

"When you post a function or event, it is added to the object's queue and

executed in its turn. In most cases, it is executed when the current script

is finished, but if other system events have occurred in the meantime, its

position in the queue may be after other scripts. Its return value is not

available to the calling script.

All events posted by PowerBuilder are processed by a separate queue from

the Windows system queue. PowerBuilder posted messages are processed before

Windows posted messages, so PowerBuilder events that are posted in an event

that posts a Windows message are processed before the Windows message.

For example, when a character is typed into an EditMask control, the

PowerBuilder pdm_keydown event posts the Windows message WM_CHAR to enter

the character. If you want to copy the characters as they are entered from

the EditMask control to another control, do not place the code in an event

posted in the pdm_keydown event. The processing must take place in an event

that occurs after the WM_CHAR message is processed, such as in an event

mapped to pdm_keyup. "



CR:318064
CR Number:   318064
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 17 Sep 2003 Fixed
Description
ReadOnly setting not working properly in DropDownDW columns.



CR:318080
CR Number:   318080
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 11 Sep 2003 Fixed
Description
When adding an object to an existing project, the following

error message appears:



Access to SCC Provider Failed during SccCheckin(). Try Again.



Works ok from XP to remote drive that is not novell.



CR:318136
CR Number:   318136
Product Name:   PocketBuilder
Product Component:   Window - Runtime
Status:   Closed
OS:   Emulator 2002
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2003 Presently Not Targeted For Any Future Release Of This Product
Description
CloseQuery event does not fire on the device.



PER DEVELOPMENT:

The CloseQuery event is triggered by the windows WM_QUERYENDSESSION message.

This message is not supported in WinCE. Processing that would normally be done in a CloseQuery event script must be moved to one of the other event scripts.

e.g. Use the Close event or the "SuperMinimize" (Resize event).



CR:318214
CR Number:   318214
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2004 Presently Not Targeted For Any Future Release Of This Product
Description
Customer thinks that PB/IM WordCap function should behave similar to Microsoft Word, Format --> Change Case --> Title Case and it does not. In PB you need to have a space before the beginning of a word or not have it in quotations. Using wordcap datawindow expression to convert the first character of a string to capital.



Example of observed behavior for both PB/IM and MS Word :



Input String

i work in building six ,in "concord"

i come here five days a week



In Microsoft word if you do Format --> Change Case --> Title Case then the string will be like this :



I Work In Building Six ,In "Concord"

I Come Here Five Days A Week



But using PB/IM 7/8/9 Wordcap will give this :



I Work In Building Six ,in "concord"

i Come Here Five Days A Week
Review Status
 02/04/2004:

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



CR:318282
CR Number:   318282
Product Name:   PocketBuilder
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows 2000
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2003 Fixed
Description
When the soft input (keyboard, transcriber,etc) pops up it reduces the screen size by about 30%. If the control for entry is at the bottom of the screen the soft input area obscures it. Is there any way that we can get an event added to the window/app object to detect that the soft input area has been popped up so that we can take resize/rescale/refocus actions meaning the input area is still visible.



CR:318294
CR Number:   318294
Product Name:   PocketBuilder
Product Component:   Window Painter
Status:   Closed
OS:   Windows 2000
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2007 Fixed
Description
Add properties to support/display the SIP icon



CR:318300
CR Number:   318300
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Application crashes upon selecting a menu option twice in a row.



CR:318311
CR Number:   318311
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jun 2003 Fixed
11 Nov 2003 Fixed
Description
If customer sets an initial value in an editmask that uses a code table, then clicks on Up arrow in spin control, he sees wrong value in editmask. The value jumps to the first value assigned in the code table. After that you cycle through the values as expected. This worked correctly with PB8.



CR:318316
CR Number:   318316
Product Name:   PB Enterprise
Product Component:   ORCA
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2003 Fixed
21 Dec 2003 Fixed
Description
OrcaScript crashes when doing scc refresh target "full", with no local PBLs.



Verified fixed on PB901_6532.



CR:318370
CR Number:   318370
Product Name:   PB Enterprise
Product Component:   DW Graph
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2005 Fixed
Description
Datawindow with graph object in a header group. The data is displayed fine until you use SetSeriesStyle(). The display changes, ie. the groups are arranged differently.



CR:318387
CR Number:   318387
Product Name:   PB Enterprise
Product Component:   Menu Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2004 Presently Not Targeted For Any Future Release Of This Product
Description
Reported for both PocketBuilder and PB 8. Descendant menu and disabling the inherited "ShiftToRight" property. Initially the menu item is positioned correctly, but after closing/reopening it displays at the right.
Review Status
 02/04/2003:

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



CR:318397
CR Number:   318397
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Ability to insert a new group between an existing group

in the Datawindow painter. For example, if you have 4 groups in a datawindow,

and you want the ability to insert a new group between groups 2 and 3. The

new group becomes 3 and automatically changes the existing groups to 3,4,5 (3 becomes

4, 4 becomes 5).



The agregate fields, etc in the moved groups should also be moved.

For example when group 4 becomes 5 (in the above example) all the aggregate fields,etc

should also move.



CR:318625
CR Number:   318625
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 May 2003 Workaround
Description
GPF when running application within PB and opening a window. Tested with 8.0.3 9820/9838/9933 and 9/0 6053



Solution:

This issue was resolved by having the customer make some coding changes to their application.



CR:318630
CR Number:   318630
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2004 Presently Not Targeted For Any Future Release Of This Product
Description
Cannot create DW from Stored Proc that has an Oracle Out parameter.
Review Status
 02/11/2004:

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



CR:318664
CR Number:   318664
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2004 Not a Bug
Description
PB 8.0.3 - Oracle 804 native driver is slower than Oracle O73 native driver.



According to PB Engineering this is caused by different OCI behavior of o73 and o84. It is not a PB bug.



CR:318682
CR Number:   318682
Product Name:   PB Enterprise
Product Component:   DataBase
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Sep 2003 Fixed
Description
The transaction object property of sqlreturndata not returning a value.



According to documentation, this property is supported for ODBC, Informix,and Oracle.



In PB 9.0 (build 5507) using ODBC and ASA, sqlreturndata is returning a value of 'Adaptive Server Anywhere'. In the latest builds of 8.0.3 and 9.0, it is not returning a value.



In PB 8.0.3 and 9.0 using Informix, sqlreturndata is returning 0 when inserting a row

into a table. Sqlreturndata is not returning a value by just connecting to the database.



In PB 8.0.3 and 9.0 using Oracle, sqlreturnata is not returning a value.



CR:318689
CR Number:   318689
Product Name:   PocketBuilder
Product Component:   DW Painter
Status:   Closed
OS:   Windows 2000
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
75 16 Jun 2003 Fixed
Description
Creating a new Group style datawindow which uses multiple columns in the group definition crashes the dw painter.



Workaround: Create a different dw style and do Rows > Create Group instead.



CR:318761
CR Number:   318761
Product Name:   PB Enterprise
Product Component:   DW Web ActiveX
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2007 Insufficient priority to fix
Description
When the tabsequence on a radiobutton is set to 0, it can still be changed on the HTMLDW. On IE, the dot disappears completely, on Netscape the option can be changed.



CR:318787
CR Number:   318787
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 03 Jun 2003 Fixed
9.0.1 23 Feb 2004 Fixed
13 Jun 2003 Duplicate
Description
XMLParseFile gives error message: Unknown Element 'xs:schema'when parsing a xsd file.



Update:

Documentation about pasing xsd files has been updated. See PB 9.0.1.



CR:318793
CR Number:   318793
Product Name:   PB Enterprise
Product Component:   Project Painter
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request for better error messages in project painter build failure



CR:318804
CR Number:   318804
Product Name:   PocketBuilder
Product Component:   Window Painter
Status:   Closed
OS:   Windows 2000
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2003 Not a Bug
Description
The default for a new window with build 69 appears to be to have the SmartMinimize setting turned on instead of Close. In most cases I would think customers would want the default to be Close.



CR:318805
CR Number:   318805
Product Name:   PocketBuilder
Product Component:   Installation
Status:   Closed
OS:   Windows 2000
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2003 Fixed
Description
The install of ASA802 that is bundled with PPB does not have 'Adaptive Server Anywhere for Windows CE' enabled by default, even though it would be most often selected by users. Can install be updated to have this turned on by default ?



CR:318811
CR Number:   318811
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Nov 2003 Fixed
Description
SCC Help in PB 9.0 still showing some old 7.0 descriptions.



CR:318982
CR Number:   318982
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 17 Jun 2003 Fixed
19 Sep 2003 Fixed
Description
PB8.0 and 9.0 do not pick up password expire message at run time.



Verified fixed in PowerBuilder 8.0.3 Build 9961.



CR:319086
CR Number:   319086
Product Name:   PocketBuilder
Product Component:   Language - Runtime
Status:   Closed
OS:   Windows 2000
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2003 Not a Bug
Description
Reading a file using Linemode fails when run on the device. Using Streammode works okay.



User Error: Line mode reads UNICODE files only. The DSN file is an ANSI file.



CR:319106
CR Number:   319106
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2004 Fixed
13 Jun 2004 Fixed
Description
The incorrect classid for the pbrx90.ocx and pbrxs90.ocx is listed in the PB 9.0 Application Techniques Manual.





For example, pages 636,639,640 and 641 show the classid for pbrx90.ocx as:

CLASSID="CLSID:88881304-8888-1000-8000-080009AC61A9"



The classsid has changed for pbrx90.ocx and it should be:

CLASSID="CLSID:99991304-9999-1000-8000-080009AC61A9">



The classid for the pbrxs90.ocx is:

CLASSID="CLSID:99991314-9999-1000-8000-080009AC61A9">



CR:319114
CR Number:   319114
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 25 Jul 2003 Fixed
9.0.1 01 Apr 2004 Fixed
9.0.1 25 Jul 2003 Fixed
Description
PB 9 Web Services do not work with proxy servers requiring authentication.



CR:319122
CR Number:   319122
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2003 Fixed
21 Oct 2003 Fixed
Description
DW with a Union clause in the SQL fails with ORA-00933 error with O84 and O90.



Verified fixed in PB 803_9961, PB 90_6086



CR:319234
CR Number:   319234
Product Name:   PB Enterprise
Product Component:   BAM Deployment
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
FeatureRequest : Centralized Deployment Profile for EAServer Deployment
Workaround Description
 N/A



CR:319254
CR Number:   319254
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Want to be able to return an array in an any function return value.



CR:319266
CR Number:   319266
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add a way to save a DataWindow's attributes as an XSLT. Currently have XSL-FO but Microsoft currently does not interpret that template.



CR:319276
CR Number:   319276
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Feb 2004 Fixed
Description
PB 9.0 Gettting started - Ch10 has a tutorial programming error.



CR:319298
CR Number:   319298
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 03 Dec 2004 Fixed
8.0.4 06 Jan 2005 Fixed
Description
Disable() and Enable() do not work when menu item is not visible.



Verified fixed in PB9 build 7048
Workaround Description
 Enabled = false or Enabled = true do work as alternatives.



CR:319306
CR Number:   319306
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jun 2003 Fixed
10.0 Alpha 14 Oct 2003 Fixed
Description
When applying a edit mask of [date][time] to a datetime

column field in the datawindow painter and once you tab off the format property,

the error message of:

Specified edit mask is invalid



CR:319379
CR Number:   319379
Product Name:   PocketBuilder
Product Component:   System Runtime Functions
Status:   Closed
OS:   Pocket PC 2002
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2004 Fixed
Description
Multiple retrieve() calls on a DataWindow/DataStore which shares data with another DataWindow using sharedata gives an OutOfMemory error (migh be also infinite loop). When using on Desktop it works ok.



Update:

Checked with PP1.5 - Fixed in PPB 1.5
Workaround Description
 re-assign the dataobject.



dw_1.dataobject = d_mydataobject"

dw_1.SetTransObject( sqlca )

dw_1.Retrieve()



CR:319433
CR Number:   319433
Product Name:   PB Enterprise
Product Component:   BAM Deployment
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature Request for distribution of ghost script with Powerbuilder 9.0



The current implementation of printing pdf files does not lend itself to easy distribution to a large user community. If someone has to distribute their PB9 app to their 500 users(say) and wants the functionality to save the datawindow as pdf then they need to install Ghost script in each of those 500 machines. This issue needs to be addressed in future releases which will



1. not require a freeware driver (write our own?)

2. provide a packaging option when building an exe?



CR:319437
CR Number:   319437
Product Name:   PocketBuilder
Product Component:   DW Printing
Status:   Closed
OS:   Windows 2000
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Nov 2003 Fixed
Description
When we preview a DataWindow in the IDE, there is a printer icon on the powerbar. Click on it and the printe dialog will be displayed. The "Printer" name on the dialog is represented by a "?" symbol instead of the full path of the printer name.



CR:319484
CR Number:   319484
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Solaris 2.6
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2004 Not a Bug
Description
"com.sybase.jaguar.component.iso_level=serializable" by default for shared components.



On your internet site:

http://manuals.sybase.com:80/onlinebooks/group-eag/ear0413e/eassolrb/@Generic__BookView) we read :



6.1 Unexpected deadlock errors If you see unexpected deadlock or slow database throughput when executing transactional components, check for the following setting in

the properties of the component that initiates the transaction:



com.sybase.jaguar.component.iso_level=serializable



This setting causes the transaction to run with serializable isolation

level ...





Per PB Engineering:

1. When we deploy a PB component in Jaguar, PB never creates the "Transaction Isolation Level property" for the component. So for any component, pb does not write "com.sybase.jaguar.component.iso_level=serializable".



2. When a Database is connected from PB application or component, if we don't set the transaction isolation level explicitly, the default isolation will be depend on how your database is configured.



3. Isolation level of a transaction object is handled trough the "Lock" property (e.g. Sqlca.Lock = value). You can refer to the PB Help for the value of the lock for different DBMS.



CR:319488
CR Number:   319488
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2005 Fixed
Description
PB IDE GPFs when entering SQLPainter for a datawindow containing a computed field with an unclosed quote. e.g. :

SELECT DIVISION_CODE, '"' FROM DIVISION".

The datawindow will preview acceptably with no problems. But if you try to edit the SQL PB GPFs.



Workaround:

Edit source shows the following: SELECT DIVISION_CODE, '~"' FROM DIVISION".

If I change the source to read: SELECT DIVISION_CODE, '~"~"' FROM DIVISION" PB no longer crashes.
Workaround Description
 Edit source shows the following: SELECT DIVISION_CODE, '~"' FROM DIVISION".

If I change the source to read: SELECT DIVISION_CODE, '~"~"' FROM DIVISION" PB no longer crashes.



CR:319520
CR Number:   319520
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2004 Presently Not Targeted For Any Future Release Of This Product
Description
When the setrow and setcolumn are called from a javascript

function, the focus is not being set for the Web Datawindow row and column. The following function is being called from the onload event.



<script language=JavaScript>function setrow_and_column()

{

dw_1.SetRow(3)

dw_1.Setcolumn('dept_name')



The onload event appears to work ok because if you add dw_1.SetItem(1,2,'new dept name') to the function, it changes the first row, second column's dept name to the new value.



The javascript generated for the setrow function is:

function HTDW_SetRow(row)

{

var result = -1;

row -= 1;

var colNum = this.currCol;



if (colNum != -1)

{

var colObj = this.cols[colNum];

if (typeof colObj != "undefined" && colObj.displayGobName != null)

{

var control = this.findControl(colObj.displayGobName, row, true);

// if we can't find a control, then we can't set the row

if (control != null)

{

// force focus onto the found control,

// the onFocus event will change the currency variables

control.focus();

result = 1;

}

}

}

return result;

}



The javascript generated for the setcolumn is:

function HTDW_SetColumn(col)

{

var result = -1;

var colNum = this.getColNum(col);



if (colNum != -1)

{

var colObj = this.cols[colNum];

if (typeof colObj != "undefined" && colObj.displayGobName != null)

{

var control = this.findControl(colObj.displayGobName, this.currRow, true);

// if we can't find a control, then we can't set the column

if (control != null)

{

// force focus onto the found control

// the onFocus event will change the currency variables

control.focus();

result = 1;

}

}

}

return result;

}
Review Status
 2/4/2004

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".
Workaround Description
 Using dw_1.dataForm.dept_name_0.focus(); is setting the focus to a hardcoded column.



CR:319521
CR Number:   319521
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 18 Sep 2003 Fixed
08 Oct 2003 Fixed
Description
SaveRowsAs dbase3 in datawindow does not create valid dbase file.



Verified fixed in PowerBuilder 804 Build 10501. Verified fixed in PowerBuilder 901 Build 7011.



CR:319543
CR Number:   319543
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 19 Feb 2004 Fixed
13 Aug 2003 Fixed
8.0.4 11 Dec 2003 Fixed
20 Feb 2004 Fixed
Description
In PB 7, when there is a runtime error in a series of database operations, including updates, and one operation fails, the entire transaction is rolled back. When this happens in PB 8 and 9, the updates that occured prior to the failed one are committed. If a RunTimeError is caught in a TRY-CATCH block, a SetAbort can be performed so that the behavior is the same as in PB 7.



PB Engineering:

In PB 8 and 9, the default behavior has been changed so that for stateful components, the default behavior is the same as in PB 7, i.e. the transaction is rolled back. This issue was fixed on February 27, 2004, and is included in all PB 8.0.4 and PB 9.0.1 EBFs created after that date (which can be determined by looking at the datestamp on the PB EBF DLLs). This change does not apply to stateless components. A new CR 347702 has been raised to restore the default behavior for stateless components to the behavior in PowerBuilder 7.



Also introduced 2 new environment variables "PBOnFatalError" and "PBRollbackOnRTError".



PBOnFatalError environment variable:

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

Controls whether or not to restart server on PBVM corruption. Three case-insensitive values are available: "continue", "restart" and "shutdown". Default value is "continue", which will rollback the current transaction, but let the server continue running.



PBRollbackOnRTError environment variable:

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

If a runtime exception is raised by a PowerBuilder component running in EAServer, in PowerBuilder 7 the transaction is rolled back and the exception is thrown back to the client. In PowerBuilder 8, the behavior was changed so that the transaction is committed before the exception is thrown back. You can control this behavior by using the new PBRollbackOnRTError environment variable. To specify that the transaction is committed before the exception is thrown back to the client, set the PBRollbackOnRTError environment variable to 'n', 'no', or 'false'. When this environment variable is set to 'y', 'yes', or 'true', the transaction is rolled back before the exception is thrown back to the client.



These environment variables were introduced on August 13, 2003, and are included in all PB 8.0.4 and PB 9.0.1 EBFs created after that date.



CR:319544
CR Number:   319544
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Open
OS:   Pocket PC 2002
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Deferred
Description
Transparent background images do not show up as transparent when deployed to Dell Axim and contained in a datawindow. The same images on a window do show up with transparent background, and customer reports that running on a Cassiopeia the images are also transparent.



PER DEVELOPMENT: the problem is this: A transparent gif allows the container window color to show through. Overlapping transparent gifs will not always work as expected because now the transparent pixels are using the container window color, not the colors in another object under the gif. Transparency happens when the picture is instantiated, based on its container color, it does not happen dynamically. Moving a gif programatically may also give unexpected results. The IDE produces a similar efect, but the container color used there is always button face (just as in PB9). We cannot get it any better than it is now in this release.



CR:319555
CR Number:   319555
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 6503 17 Jun 2003 Fixed
07 Nov 2003 Fixed
9.0.1 6533 07 Nov 2003 Fixed
Description
With usehwnd=no, a modified datastore does not save as PDF file correctly.



Verified fixed in PB 901_7011.



CR:319556
CR Number:   319556
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 12 Jun 2003 Fixed
Description
Customer is using a script with PrintOpen and PrintText functions since he needs to print a DW to a dot matrix printer. The code was working fine in PB 8 but after the migration to PB 9 he had problems.



Workaround to the problem:

This is how the workaround works and the necesary files to use it.



The following is the code I added to the of_imprime_formulario function of the nvo_nf

It does following:

1. Delete a file temp.pdf if exists

2. Get the printername the user choosed

3. runs a command called print.bat (this batch copies the temp.pdf file to the printer.)

The print.bat file should be placed in the running directory (where the exe is) it will save there the pdf

The only problem I found was when using printers that have spaces in the name for example "My printer" in this case the workarround won't work I suggest to rename the printer to "MyPrinter" for example.



string ls_printer, ls_command

FileDelete("temp.pdf") // To be sure the file does not exist



pds_nota_fiscal.SaveAs ("temp.pdf",PDF!,true)

ls_printer = left(PrintGetPrinter(), pos (PrintGetPrinter(), "~t") -1)

ls_command = "print.bat "+ ls_printer

run (ls_command, Minimized! )



The print.bat file is as follows:

:Loop

SET ARG=%1

IF "%ARG%" == "" GOTO Print

set Printer=%Printer% %ARG%

SHIFT

GOTO Loop



:Print

copy temp.pdf %Printer%



CR:319565
CR Number:   319565
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2004 Presently Not Targeted For Any Future Release Of This Product
Description
Cannot call a registered .NET dll from PB. Get a return of -3 Object could not be created.



According to MSDN.

To overcome .NET and COM differences, the runtime provides wrapper classes to make both managed and unmanaged clients think they are calling objects within their respective environment. Whenever your managed client calls a method on a COM object, the runtime creates a runtime callable wrapper <cpconruntimecallablewrapper.asp> (RCW). RCWs abstract the differences between managed and unmanaged reference mechanisms, among other things. The runtime also creates a COM callable wrapper <cpconcomcallablewrapper.asp> (CCW) to reverse the process, enabling a COM client to seamlessly call a method on a .NET object. As the following illustration shows, the perspective of the calling code determines which wrapper class the runtime creates.

In most cases, the standard RCW or CCW generated by the runtime provides adequate marshaling for calls that cross the boundary between COM and the .NET Framework. Using custom attributes, you can optionally adjust the way the runtime represents managed and unmanaged code.



_______________________________________________________________________________________________

This seems to indicate that there needs to be nothing new done from the client side. However I still get the "-3 Object could not be created" error.
Review Status
 02/04/2004:

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



CR:319675
CR Number:   319675
Product Name:   PocketBuilder
Product Component:   Window Painter
Status:   Open
OS:   Windows 2000
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The ancestor definition fields are incorrectly enabled in custom user events. Minor because although there is no error on Save, no changes to the ancestor are really saved. Attempts in the descendant script to use changed values will still generate an error message.



CR:319679
CR Number:   319679
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Windows XP
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2003 Third Party Problem
Description
Insertfile on an OLE control fails in PB 9.0 on Windows XP.



Resolution:

This is an XP Operating System problem. The same problem happens in VB on XP.



CR:319699
CR Number:   319699
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2004 Fixed
Description
Dragging the pointer off of a spinning editmask corrupts the display value.



CR:319721
CR Number:   319721
Product Name:   PocketBuilder
Product Component:   Window - Runtime
Status:   Closed
OS:   Pocket PC 2002
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
95 19 Jun 2003 Fixed
Description
Tab control right/left arrow scrolling does not work on device.



CR:319851
CR Number:   319851
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 08 Oct 2003 Fixed
Description
Doubleclicking on a field with DW EditMask ##,###.00 (Format ##0.00) places the cursor on the right side of the field.



CR:319855
CR Number:   319855
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2005 Fixed
Description
GPF / crash when using case()...when.. statment expression with computed fields (referencing other computed fields).
Workaround Description
 Workaround: Using IF statement works fine.



CR:319880
CR Number:   319880
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Aug 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
Selecting a different printer using the Object.Datawindow.Printer property does not

work for datastores. The printout is always directed to the default printer.

This is a regression in PowerBuilder 8.0.3 Build 9601 and later.



To work-around the issue use the PrintSetPrinter function or

add the following section into the pb.ini file:



[Datastore Behavior]

usehwnd=yes



CR:319887
CR Number:   319887
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 08 Oct 2003 Fixed
Description
SetDetailHeight(row, row, height) doesn't work if row is the last row in dw.



Verified fixed in PB901_7026



CR:319895
CR Number:   319895
Product Name:   PocketBuilder
Product Component:   Installation
Status:   Closed
OS:   Windows 2000
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
88 02 Jun 2003 Fixed
Description
When user runs PPB install and accidentally enters the drive letter for a CDROM drive instead of a hard disk, the user is given a "Catastrophic Error" message from the installation. Although this is user error, the error message should handle this better.



CR:319913
CR Number:   319913
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2003 Fixed
Description
When calling a com object from PowerBuilder's IDE, the com object

stays in memory until you exit Powerbuilder. The reason is the com object is hosted in the same process that Powerbuilder is.



A side effect to this behavior is if you call a com object and then go back and make a change and then try to regenerate the com object (from the project painter), you will see

errors such as:

CGEN: Compiling 'c:\case\powerbuilder9x\_tmpguid.cpp'

CGEN: Compiling 'c:\case\powerbuilder9x\_tmpclas.cpp'

CGEN: Compiling 'c:\case\powerbuilder9x\_tmpserv.cpp'

CGEN: Linking... cannot open pb9bug.dll : unknown error I/O error processing pb9bug.dll : Permission denied



You will need to exit and restart PowerBuilder to remove the object from memory.



oleobject lole_comapp

lole_comapp = create oleobject

lole_comapp.connecttonewobject("PB9.0.n_pbcom")

lole_comapp.of_com()

disconnect lole_comapp



CR:319915
CR Number:   319915
Product Name:   PocketBuilder
Product Component:   Business Graphics
Status:   Open
OS:   Pocket PC 2002
Original Version:   1.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.5 366
Description
DW Graph: The labels marking the category axis in a bar graph (where the text would normally display vertically, for lack of space horizontally) do not display at runtime (emulator or device)



CR:320012
CR Number:   320012
Product Name:   PocketBuilder
Product Component:   System Runtime Functions
Status:   Closed
OS:   Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2004 Presently Not Targeted For Any Future Release Of This Product
Description
HANDLE(this, TRUE) in application object does not report another instance running.



Update:

For applications, the Handle function does not return a useful value when the previous flag is true. You can use the FindWindow Windows function to determine whether a Windows application is already running. FindWindow returns the handle of a window with a given title.



CR:320013
CR Number:   320013
Product Name:   PocketBuilder
Product Component:   Project Painter
Status:   Closed
OS:   Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2004 Fixed
Description
Bitmap (.BMP) in a DW disappears at runtime on device with build 75.



Update:

Fixed in latest builds.
Workaround Description
 Add bitmap to pkr file (resource file) to add it to exe.



CR:320024
CR Number:   320024
Product Name:   PocketBuilder
Product Component:   Language - Compiler
Status:   Closed
OS:   Windows 2000
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2003 Fixed
Description
Corrupted file, invalid character appended to a window's name everywhere in the .srw

We have not been able to recreate the problem internally, so this may not be solvable.
Workaround Description
 The workaround is to edit the source in the "source editor" option.

Global Replace the offending string (the window name with the funny char) with the correct name.



CR:320033
CR Number:   320033
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 18 Sep 2003 Fixed
05 Apr 2005 Fixed
13 Oct 2003 Fixed
Description
PB crashes on a retrieve of a datastore if the transaction object is disconnected.



Verified fixed in PB 804_10501. Verified fixed in PB 901_7011.



CR:320046
CR Number:   320046
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2004 Not a Bug
Description
When trying to retrieve data from a view created on a

remote database using dblink, receiving a ora-03113 end-of-file communication error.



Problem happens using:

Oracle 9.2.0.1.0 Client -> Oracle 8i db -> o84

Oracle 9.2.0.1.0 Client -> Oracle 8i db -> o90

(Works ok using Oracle 9.0.1 client)



Works ok using:

Oracle 9.2.0.1.0 Client -> Oracle 9i db -> o84

Oracle 9.2.0.1.0 Client -> Oracle 9i db -> o90



Works ok when retrieving from a datawindow. Problem happens when using embedded sql.



RESOLUTION: Works ok using PB 8.0.4 (build 10538) and PB 9.0.1 (build 7048) and Oracle client 9.2.0.3. Upgraded Oracle client per tech doc http://www.sybase.com/detail?id=1011566.



CR:320065
CR Number:   320065
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 26 Jun 2003 Fixed
21 Oct 2003 Fixed
Description
9.0 Regression: A null datetime value was 00/00/00 in 6.5 but now is 01/01/00.



Fixed in PB 901_6516.



CR:320164
CR Number:   320164
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2003 Workaround
Description
OS: Win 2000 (2 CPU)

Versions and Build #s Reported: EAS 4.0 GA with PB 7.03.10108

Versions and Build #s Tested: As above (not reproduced outside production env)

Database/Driver File/Version: ASE 12.0.0.4/P/SWR 9842



Comments:

2 Jag servers in a cluster on multiprocessor W2K machines running PB 7.03.10108 components

Both servers crashing randomly each day with no messages in the log. As this is only happening in the production env the ct is unwilling to test an upgrade without guarantees the upgrade will fix the problem. This consult is to ask if engineering can analyse the user.dmp files from these crashes to gives us evidence that this crash is due to a known CR which is fixed in later versions of EAS/PB.



*** Wednesday, June 04, 2003 2:36:21 PM

The problem has not repeated itself since bind.thread=true was set for the PB components.



CR:320170
CR Number:   320170
Product Name:   PocketBuilder
Product Component:   System Runtime Functions
Status:   Closed
OS:   Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2003 Not a Bug
Description
GPF when using closewithreturn in an application running in the IDE, deployed to the desktop. Works fine on PDA.



CR:320197
CR Number:   320197
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 03 Jun 2003 Fixed
23 Dec 2003 Fixed
Description
Memory leak with stored procedure returning empty string and called as RPC



CR:320199
CR Number:   320199
Product Name:   PocketBuilder
Product Component:   DB SQLAnywhere
Status:   Closed
OS:   Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
104 23 Feb 2004 Fixed
Description
Execution of a RPC leads to truncated data. It works fine in PowerBuilder.



create PROCEDURE DBA."dbp_test_parameter" ( in @argstring varchar(6) )

BEGIN

print @argstring;

END;



subroutine dbp_test_parameter(string argstring) RPCFUNC ALIAS FOR "~"dba~".~"dbp_test_parameter~""



Use in a customized transaction object : code

sqlca.dbp_test_parameter("123456");



-> The ASA log will show only 123.



UPDATE:

Fixed in builds after in 6/17/03 build.



CR:320205
CR Number:   320205
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2003 Fixed
Description
A column in a DB that returns a name of a .BMP and setting the 'Display as picture' property so that the .BMP can be displayed. Design time its OK, running in IDE and on the device it does not display.



CR:320233
CR Number:   320233
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Dropdown datawindow which has been created on table that just has one column, so the dddw that same data and display col. When he tries to use this dddw in datawindow, rows in dddw don't get populated.



Workaround: assign one column for the data and a different column for the display in the dddw style column. Then it works fine.



04/25/2005:

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



CR:320242
CR Number:   320242
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 07 Apr 2004 Fixed
Description
PB MDI Notepad example, Search->GoToLine doesn't work.



CR:320243
CR Number:   320243
Product Name:   PocketBuilder
Product Component:   Window Painter
Status:   Open
OS:   Windows 2000
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Cannot drag visual objects from the system tree to the window painter. It keeps the circle/line mouse pointer. Also cannot drag non-visual objects from system tree to non-visual object list pane.



CR:320246
CR Number:   320246
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Closed
OS:   Emulator 2002
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2003 Not a Bug
Description
Application and database close with no message if datastore.Update() is fired. When running on PocketBuilder Desktop using running man Update works as expected.



CR:320361
CR Number:   320361
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Ability to set the position of a docked toolbar in the Painter



CR:320366
CR Number:   320366
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2003 Fixed
Description
PB Help for the SetToolbarPos PowerScript function (Syntax 1 For docked toolbars) has an error. In the description of the 'offset' argument it refers to the value of a 'replace' argument. That should be the 'insert' argument.



Verified fixed in PB 804 build 10501++ and PB 901 build 6533++.



CR:320425
CR Number:   320425
Product Name:   PocketBuilder
Product Component:   DB Painter
Status:   Closed
OS:   Windows 2000
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2004 Fixed
1.5 24 Apr 2007 Fixed
1.5 22 May 2007 Fixed
Description
1. Connect to any ASA database in the DB Painter of PPB.

2. Right-Click on "Users" under the connected database. Click on "New User...".

3. Under the "User properties" page, enter a new user name and password, as well as confirm the new password".

4. Right-click on "Save Changes" in the "User properties" page.

5. Right-click on "Users" under the connected database. Click on "Refresh...". Nothing shows up under "Users".

6. Repeat steps 2-5 but this time work on "Groups" under the connected database.



If we open up PowerBuilder after creating the users and groups and connect to the same database, we can see the new users and groups created successfully.



CR:320509
CR Number:   320509
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SP Datawindow does not get updated after changing the data source.
Target Version
 



CR:320514
CR Number:   320514
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2004 Presently Not Targeted For Any Future Release Of This Product
Description
The SCC status of an object is wrongly represented. To cause this wrong condition leaves itself by the fact that for an individual object A ' GET Latest version ' is accomplished.



workaround: do an refresh on the object to show the right status.
Review Status
 *** Thursday, April 22, 2004 11:18:51 *** ssturm ***

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".
Workaround Description
 Workaround: do a "refresh" between step 25) and 26)



CR:320515
CR Number:   320515
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 03 May 2005 Fixed
Description
OS: Windows 2000 - 4 CPUs or more

Versions and Build #s Reported: EAS 4.2 & 8.03.9704

Versions and Build #s Tested: 8.03 Builds 9704 -> 9838 EAS version



Some background info:



Tried to repro on a single CPU machine, on a dual CPU machine and when binding the Jag process to just 1 CPU on a machine with 4 CPUs and not able to see the problem. Only able to reproduce the problem when using 4 CPUs or more.



All PB components are deployed as standard, non-transactional, threadsafe components. Instance pooling and automatic demarcation supported.

Bind thread is not selected (this is PB 8.03 on EAS 4.2 and no datastores are used)

(Tested with concurrency & pooling on and off, with of without transaction support or dbms access)



On the client side (PB) the app uses shared components to simulate concurrent users on separate threads.



On the Jaguar server, there is a component that accepts the request and

launches another component for executing the business logic.



So launching 5 concurrent clients gives 5 + 5 components active/concurrent on the Jaguar server.



The components seem to respond sequentially which didn't happen in PB 8.0.1. Giving the impression that one component waits for the other to finish, or places a lock somewhere...



Behaviour Difference observed with 8.03 and 4 CPU machine.

Counting the number of method invocation in a given amount of time (10 secs) with 2 simultaneous components and with 20



With Powerbuilder 8.0.3 Build 9704 or 9838



2 components / 10 seconds 927 method invocations

20 components / 10 seconds 975 method invocations



With Powerbuilder 8.0.1 Build 8004



2 components / 10 seconds 825 method invocations

20 components / 10 seconds 2450 method invocations



With PB 8.03 20 simultaneous connections process almost the same number of method invocations as 2 simultaneous connections ( 927 vs 975)in the same time (10 secs)



With PB 8.01 20 simultaneous connection process 3 times as many method invocations as 2 simultaneous connections



On a single or dual processor machine (or on the same machine with the jag process bound to 1 CPU) the results are similar as those for 8.01



CR:320526
CR Number:   320526
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Versions and Build #s Reported: 9.0

Versions and Build #s Tested: 8.03/9.0



Comments:

The horizontal and vertical scrollbars in the DW control cannot be disabled when there is less than 1 page of data, they are hidden when not required. This NFR raised to display the scrollbars Greyed Out when there is not more than one page of data. Or add a property so the developer/user can decide to have scrollbar disabled or allow it to be hidden (current behaviour).



CR:320559
CR Number:   320559
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 30 Jun 2003 Fixed
21 Oct 2003 Fixed
Description
When a Popup menu is used, window references get confused.



Verified fixed in PB 901_7011. Verified fixed in PB 703_10305.



CR:320564
CR Number:   320564
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 17 Jul 2003 Fixed
Description
A syntax error is in the .srx file for a Web Service proxy to a Cold Fusion web



CR:320646
CR Number:   320646
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 07 Dec 2003 Fixed
Description
2 shared DataWindows using sharedata: when running SetFilter() on primary DW, the Event rowfocuschanged() and rowfocuschanging() of the secondary DW is triggered. Also on the Filter()that is called afterwards the same events are triggered again.



CR:320667
CR Number:   320667
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2003 Not a Bug
Description
SYC Interface returns "Login Failed" when executing RPC for the 1st time.

IMPORTANT INFORMATION: This issue does not happen when both logins and passwords are equal in primary and secondary ASEs.



Resolution: This is not a PB defect. It's just a behavior changE between ASEs 11.x and 12.x. From 12.x on, there's new transactional model for RPCs. So, it was possible to reproduce the same issue by using isql and SQLAdv. Solution is to map and use CIS + external logins in ASE.
Workaround Description
 1) Use Autocommit = true (NOT APPLICABLE, since this would change customer's transaction logic in client side)

2) Use same login/password in both primary and secondary ASEs (this is what customer is doing to workaround this issue by now)



CR:320670
CR Number:   320670
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jul 2003 Not a Bug
19 Jul 2004 Fixed
Description
In printing/previewing of nested N-UP DW which consist of "newspaper columns across", it always was produced one more blank page.



3/2004 Update from PB Engineering.

This is not a bug. This problem can be solved by shrinking the bottom space room of detailband to a height less than zero. The previous fix will be reverted.



CR:320711
CR Number:   320711
Product Name:   PB Enterprise
Product Component:   Workspace and Targets
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jun 2005 Fixed
Description
PowerBuilder 8 and 9 can crash when you try to move the application object from

one pbl to another pbl if you use RIGHT click and drag and drop in the systemtree.



The active application can not be moved. To move it, select a second application

and use the Move popupmenu item without drag and drop to move the object.



CR:320714
CR Number:   320714
Product Name:   PB Enterprise
Product Component:   Project Painter
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add an option to the application project painter so that

all the pbd check boxes can be click with one option.



For example, add an "Check All" check box.



CR:320752
CR Number:   320752
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2003 Third Party Problem
06 Aug 2003 Presently Not Targeted For Any Future Release Of This Product
Description
After stress testing, EAServer will stop responding after many

iterations. You cannot log in to Jaguar Manager.



The client application is set up where the timer event creates a shared object instance and then calls a function from that shared object where a connection to EAServer is made and then a getfullstate is done on the server side. The datastore is retrieving aprox. 4000 rows.



I was able to capture the following from win2000:

Full thread dump Classic VM (JDK-1.2.2_010, native threads):

"Thread-28" (TID:0x25ed10e0, sys_thread_t:0x42441810, state:R, native ID:0xc44) prio=5

"Thread-20" (TID:0x25ddb420, sys_thread_t:0x423c2a88, state:R, native ID:0xb38) prio=5

"Thread-13" (TID:0x25ece420, sys_thread_t:0x422eb950, state:R, native ID:0x910) prio=5

"Thread-2" (TID:0x25e6f9e0, sys_thread_t:0x42197ab8, state:R, native ID:0xc24) prio=5

"Thread-1" (TID:0x25e71370, sys_thread_t:0x403edd80, state:R, native ID:0xc70) prio=5

"SymcJIT-LazyCompilation-0" (TID:0x25e0f380, sys_thread_t:0x4019f850, state:CW, native ID:0x950) prio=1

at SymantecJITCompilationThread.DoCompileMethod(Native Method)

at SymantecJITCompilationThread.run(JITcompilationthread.java, Compiled Code)

"SymcJIT-LazyCompilation-PA" (TID:0x25e0f3a8, sys_thread_t:0x4019f6e0, state:CW, native ID:0x900) prio=10

at java.lang.Object.wait(Native Method)

at java.lang.Object.wait(Object.java:424)

at SymantecJITCompilationThread.run(JITcompilationthread.java,



CR:320759
CR Number:   320759
Product Name:   PB Enterprise
Product Component:   DB JDBC
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10 Jun 2003 Fixed
30 Nov 2003 Fixed
Description
When calling a stored procedure that has numeric or smallint as datatype there's an error

(c613800):

Error 999 (rc -1) : [Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.
Workaround Description
 Don't use smallint or numeric, try to use int.

Use another driver.



CR:320842
CR Number:   320842
Product Name:   PocketBuilder
Product Component:   Window - Runtime
Status:   Open
OS:   Pocket PC 2002
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 Fixed
Description
SIP icon gets lost under certain circumstances. Very similar to CR 313510. However, for 313510, you can work around the problem by activating some application, e.g. Calculator, that shows the SIP icon, then reactivating the PocketPB application. That workaround fails here. Perhaps because the window is not a Main! window, or not of default size?



CR:320851
CR Number:   320851
Product Name:   PocketBuilder
Product Component:   Language - Compiler
Status:   Open
OS:   Windows 2000
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Deferred
Description
When your library list contains a compiled library (.pkd) , right click on the target to do Full Rebuild. The process should ignore these libraries and only do the ones with source in them (.pkl).



CR:320854
CR Number:   320854
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request. When columns are added to dw source, prompt to change the update properties since they are not modified automatically. When columns not involved in the update are removed, do not force update prop changes.



CR:320883
CR Number:   320883
Product Name:   PocketBuilder
Product Component:   DW Painter
Status:   Closed
OS:   Windows 2000
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2003 Fixed
Description
In the SQLPainter, when you use Paste "Value" in the Where clause, the PopUp dialog's fonts are unreadable.





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