远程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:221193
CR Number:   221193
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Pb7.0 stability problem on Win 95. GPF's intermintently in WIndow painter



CR:221195
CR Number:   221195
Product Name:   PB Enterprise
Product Component:   Function Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Aug 2000 Fixed
Description
In PB7 script cannot be printed in the global function painter.

Work-around : print the function from the library painter or copy paste it the scrip to a file editor



CR:221197
CR Number:   221197
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2002 Fixed
11 Jul 2002 Fixed
Description
When an ole control is linked to word and activated offsite, if you
change a menu configuration (such as hide the ruler) and then change to inplace
activation, you cannot get focus back to the ole control. You cannot toggle between
inplace and offsite activation.
Workaround Description
 Minimize the app and then maximize it. Control is returned to the
ole control so that you can toggle between inplace and offsite
activation.



CR:221198
CR Number:   221198
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Changing the menu configuration of a ole word control
when activated offsite and then minimize and then maximize the pb app, the
changes revert back to the way it started.



CR:221217
CR Number:   221217
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2001 Fixed
Description
Error event on JaguarORB is not firing.



CR:221247
CR Number:   221247
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Solaris 2.6
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Oct 2000 Fixed
Description
When a getitemstatus is done in a pb jaguar
component where a datastore was just populated using setfullstate,
the rowstatus still says NotModified!.

A new row is inserted and populated with data on a pb client app. A getfullstate
is done and that blob is sent to a pb jaguar component. A setfullstate populates
the datastore and a getitemstatus returns the item status. The item status from
DWItemStatus RowStatus
shows NotModified!



CR:221279
CR Number:   221279
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2000 Fixed
Description
The problem is that when First() and Last() are used in a dw expression, the value returned
is null or zero when the dw is a nested dw/ report object.
For example calling First(getrow() for page) or Last(getrow() for page) does not produce a correct result.



CR:221280
CR Number:   221280
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
When using n-up datawindow columns and a user specifies link arguments they are evaluated to NULL in the resulting HTML code.
Using the column names as link arguments is not possible.
Workaround:
Workaround Description
 Reference the Field dept_id_1 with the undocumented way of referencing computed fields using dept_id[0]
In Script write eg:
SetColumnLink("dept_name_1", "Detail.asp", "a_dept_id='dept_id[0] + \"\"'", "");
For further fields : dept_id_2 -> dept_id[1] etc.



CR:221301
CR Number:   221301
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
2042 09 Jan 2001 Fixed
Description
You cannot extract datetime values from a datawindow using GetItemDateTime() or dot notation if the values contain milliseconds and were retrieved into the datawindow using the OLEDB driver.
Workaround Description
 none.



CR:221313
CR Number:   221313
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2004 EOL'd version. Not to be Fixed.
Description
Sheet toolbar disappears on close of 2nd sheet (1 sheet still open) when response windows are used in the sheet open event.
Workaround Description
 Open response window before the sheet opens in the frame pfc_open event. If the user chooses the close, then don't even open the sheet. This gives the same look and feel as before, but the toolbar now displays correctly.



CR:221355
CR Number:   221355
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
6.0.00 Regression. Sharedata from a primary datawindow to a secondary datawindow which is a child on composite datawindow GPFs when destroyed on the SECOND iteration if sharedataoff() is not explictly called. This is assuming the secondary composite datawindow of the sharedata() is destroyed by some means (closing a window the secondary datawindow resides on, destroying the datastore the secondary datawindow resides on) and recreated for the second iteration.

Workaround: Always use sharedataoff() before destroying the secondary datastore or datawindow in the sharedata. The secondary datastore/datawindow might be destroyed explicitly with DESTROY or implicitly when an object or sheet is closed. For the case of a sheet close, the sharedataoff() is typically coded in the close event of a sheet (if the secondary datawindow in the sharedata is visible).



CR:221356
CR Number:   221356
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 9004 14 Jul 2000 Fixed
Description
7.0.2 ebf Regression. Small autosizeheight scrolling bug with 7.0.2 8046 (PBDWE 6/28/00) but this started earlier after 7.0.2 8011.

When you have a typical tabular with autosizeheight on all columns and slide up directly above, it appears the last row or couple or rows are being hidden and can't be scrolled to. This sometimes requires higher resolutions to see but the example supplied shows the problem at 800x600.



CR:221373
CR Number:   221373
Product Name:   PB Enterprise
Product Component:   DataBase Administrator
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2001 Fixed
Description
Column-Validation-Initial Value property is broken for PB7.x release in the DB Admin painter;
If the "Initial Value" property is set to anything except 'None', when one does
an insert new row for the table, the column will display the fixed string instead of
the action defined.

In PB7, this property can be set in the DB Admin painter (by selecting the appropriate column, and setting the 'Initial' property on the Validation tab to a value) or set using pb script.
Workaround Description
 Set the property in pb script and the table column will use the 'initial' property setting. See desc section of this CR.



CR:221389
CR Number:   221389
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Aug 2000 Fixed
Description
Invalid row/column specified error in crosstab wizard when you click in an empty space in the rows/columns/values wizard listboxes while creating a crosstab datawindow.

IN 8003, 8011, and 8046 you get....
Application Execution Error [R00006]
Application terminated.
Error: Invalid DataWindow row/column specified at line 5 in doubleclicked event of object dw_rows of k13_definition.

This works correctly in 7.0.2 9012.



CR:221404
CR Number:   221404
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2000 Fixed
Description
Almost all rows disappear in N-up report detail band when detail band AUTOSIZE HEIGHT is on.

Problem was not happened on PB 7.02 #8011, #8025, #8037
Affected version PB 7.02 #8045.
Workaround Description
 Turn off detail band property : AUTOSIZE HEIGHT.



CR:221466
CR Number:   221466
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2004 Not reproducible with latest version of the product available as of Resolution Date
Description
If a set of PBLs are located on a network drive and the local machine is running WIN NT sp6a, then the user will experience severe delays in the opening times of their objects.

Check out this Microsoft.com article...(mentions changing a registry entry to fix it)
Slow Network Performance with Service Pack 4, 5, 6, or 6a
http://support.microsoft.com/support/kb/articles/q249/7/99.asp?LN=EN-US&SD=gn&FR=0



CR:221491
CR Number:   221491
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
dynamicly changing dddw in dwndropdown event causes the change of all rows, if the rows are inserted and not modified. IN PB4 now following rows are changed if the dddw in the first row is changed dynamicly.

Workaround: Insert only one new row / avoid that several new rows are inserted.
Workaround Description
 Insert only one new row / avoid that several new rows are inserted.



CR:221537
CR Number:   221537
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jan 2001 Fixed
Description
Using a partial EditMask of mm/yy, the non masked portion of a field should take a DEFAULT value according to the following published editmask behavio. But MM/YY>>12/99>>12/01/1999 results in a Datawindow Error of not passing the Validation Test.

According to the "PowerBuilder Year 2000 primer - A practical guide for detecting Year 2000 (Y2K) coding and date ambiguity problems" on Sybase's website the following is how partial editmasks should be handled.

April 24, 1998 12:15:35 - or today's date after the UPDATE.

When a partial editmask is used for input to a date, time or date time field we will set the NON MASKED portions of the field to DEFAULT values. PowerBuilder will make no attempt to preserve any database values for portions NOT represented in the editmask.

Examples of defaults:
YYYYY with value 1970 will result in January 1, 1970, 0:0.0000
MM/YYYY with value 04/1970 will result in April 1, 1970, 0:0.0000
MM/DD/YYYY with value 04/02/1998 will result in April 2, 1998, 0:0.0000
HH:MM with value 2:45 will result in January 1, 1900, 2:24.0000
HH:MM with a retrieved date of 1947 will send back January 1, 2000 2:24.0000

BUT, according to CR 213449 this may have changed since then. The following note is extracted from CR 213449:

Note:
With the fix made in this CR, there will be an impact for other customer applications.
This concerns date display controls where the editmask is of DATE datatype though not neccessarily displaying the full date for user-entry.
E.g. Editmask of DATE datatype : Mask is mm/yyyy -
Error does not pass validation test because PB will validate for day = 00, mm = user-entry, yyyy = user-entry.
Editmask of DATE datatype : Mask is yyyy -
Error does not pass validation test because PB will validate for day = 00, mm = 00, yyyy = user-entry.

Is this the new correct behavior? If so, then are partial editmask in the datawindow are no longer allowed? Why do they still work with an editmask control, shouldn't they be consistent:?



CR:221538
CR Number:   221538
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Infinite validation loop with web datawindow in Netscape frames



CR:221556
CR Number:   221556
Product Name:   PB Enterprise
Product Component:   Project Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2000 Fixed
Description
GPF in project painter on regenaration during 2nd pass. Application can regenerate but not fully rebuild. Incremental rebuild works ok.



CR:221581
CR Number:   221581
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
computed object if dependendent on another computed object which involves goups and is depenedent on a third computed object but not the values in the detail band returns a 0 value for the first preview.
Workaround Description
 There is no workaround for the dw painter preview problem but in the script after the retrieve if you do a dw_1.Groupcalc() then the object get populated correctly.



CR:221593
CR Number:   221593
Product Name:   PB Enterprise
Product Component:   DB Other
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2002 Fixed
08 Jul 2002 Fixed
Description
DBParm setting DBTextLimit='0' is ignored, causing text field return value to be set
-for MSS native to length 1
-for ASE native to length 4000
when in fact the application should default to the maximum length text field defined in the respective db server.
Workaround Description
 Set DBTextLimit to a value to the maximum expected bytes to be returned from the database.



CR:221606
CR Number:   221606
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2000 Fixed
Description
GPF's intermintently in Script painter selecting script.



CR:221617
CR Number:   221617
Product Name:   PB Enterprise
Product Component:   UO Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2000 Presently Not Targeted For Any Future Release Of This Product
Description
After deleting code from a user object event, other actions in the object painter, such as deleting a function, may cause a GPF.
Workaround Description
 none.



CR:221623
CR Number:   221623
Product Name:   PB Enterprise
Product Component:   Profile Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Profiler detail files (.PBP) do not conatin detailed script line info if they are produced from machine code (or DLL) executables.
Workaround Description
 None.



CR:221657
CR Number:   221657
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Customer would like to be able to scroll a right aligned dw edit control which is
only partially visible.
This feature is standard for a left aligned dw edit control where the additional
characters scroll along to the right when the edit control size is smaller than the column defined size.

The problem appears when the dw edit control data cannot scroll to the right if column alignment property is 'Right', edit tab - Auto Horz scroll: ON, control is sized shorter on the dw than the actual length of the control.
E.g. column "phone" might be length char(10) and the visual display might be
allow char(6) for the window font and screen resolution etc.
The scroll will stop at position char(6) when in fact there are more chars after that.
Workaround Description
 Set Auto Vert scroll: ON. In data-entry, the visual display is blank when the column display is exceeded and the cursor 'moves to the next line' , however the edit control does retain the data and will display 'what fits' when the control has lost focus;



CR:221674
CR Number:   221674
Product Name:   PB Enterprise
Product Component:   Migration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 9012 29 Sep 2000 Fixed
Description
PowerBuilder 7.0. Full Rebuild GPFs in PBVM70.DLL on 2-4th full rebuild. The rebuild GPF's based on inheritance, etc but definitely fails when rebuilding the MetaTools Library.

Related to CR221556.

Fixed in 7.0.2 9012 PBVM70.DLL. Need 7.0.2 8046 C3 + PBVM70.DLL from build 9012.



CR:221695
CR Number:   221695
Product Name:   PB Enterprise
Product Component:   DPB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 09 Oct 2002 Fixed
Description
Code itemchanged event using GetFullState/SetFullState.

After itemchanged event has fired once, this code prevents the event from getting fired again.



CR:221752
CR Number:   221752
Product Name:   PB Enterprise
Product Component:   SQL Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2000 Fixed
Description
6.5 EBF/7.0.2EBF Regression. If you have a datawindow that contains a select statement with a LEFT OUTER JOIN and make any change in SQL syntax mode (drop a column, even just add a newline), you get a 'database error' when you click on the SQL button to return to design mode..


2 workarounds:
1. Use the {oj ..... } syntax to surround the LEFT OUTER JOIN.
2. Enclose the entire LEFT OUTER JOIN clause in parenthesis (parens) ( )

This should allow you to edit the statement in syntax mode.

Ex: This statement gives a "Database Error:

SELECT customer.company_name, sales_order.id, sales_order.order_date
FROM customer LEFT OUTER JOIN sales_order ON customer.id = sales_order.cust_id

Workarounds:
SELECT customer.company_name, sales_order.id, sales_order.order_date
FROM
{oj
customer LEFT OUTER JOIN sales_order ON customer.id = sales_order.cust_id
}

or

SELECT customer.company_name, sales_order.id, sales_order.order_date
FROM
(
customer LEFT OUTER JOIN sales_order ON customer.id = sales_order.cust_id
)



CR:221757
CR Number:   221757
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement. Would like to be able to create crosstab datawindows dynamically using SyntaxFromSQL. Crosstab is not listed as one of the presentation styles available for this method.



CR:221758
CR Number:   221758
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
PB 7.02 only - In the Window Painter: Window with UO of type DW. DW has a user event defined with basic script. Make a change to the UE script and go back to the window, PB will cause a Dr. Watson or Page Fault.
IF the event is not user defined or it's compiled before going to another object the crash does not occur.



CR:221767
CR Number:   221767
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Aug 2000 Fixed
Description
With the increased functionality and improved design of the window painter in PB7, it is no longer possible to modify an existing user event name from within the dialog box/ dw painter.
There are several workarounds.

However in PB6x, it is possible to select Declare User Event dialog and modify the name of an existing event.
Workaround Description
 See desc section.



CR:221806
CR Number:   221806
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 8046 08 Aug 2000 Fixed
Description
6.5EBF/7.0.2EBF Regression. Windows 95 (Win95) and Windows 98 (Win98). When printing > 7 pages to an HP PCL (such as HP4si or HP4050) or Lexmark 5700 (PCL) printer or POSTSCRIPT, pages 1-6 or 1-7 print OK but the rest of the pages print only the header and footer. The detail area is blank (missing) for pages 6-n or 7-n. This only happens in a composite - nested works fine in Windows 95 or Windows 98 with more than 7 pages.

Print preview shows all the pages - this is a printing problem only.

This is a generalized problem with HP PCL and Postscript printers under Windows 95 and Windows 98.
The postscript printer starts it's blank pages at page 12 or 13.

Started with 7.0.2 8033. (5/10/2000)
6.5 builds affected should be 6.5 1191 and up through 1209. Builds after July 17th, 2000 should have the patch.



CR:221813
CR Number:   221813
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.0 21 Sep 2000 Fixed
Description
7.0 Regression. SetDropHighLight() does not highlight a treeview item as it did in 6.0. If after dragging and dropping an item, when you click with the mouse the item is selected but upon releasing the mouse button the highlight disappears although the focus remains.

You can see this using the PB Examples Treeview Drag/Drop in PowerBuilder 6.x and 7.0


Workaround: The problem can be fixed in the Code Examples by adding a call to SetDropHighlight(0) in the dragdrop event.
Workaround Description
 none



CR:221877
CR Number:   221877
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Apr 2001 Fixed
Description
Unable to delete a object if it is associated with the man with sunglasses
If somehow a object in your a pbl gets associated with the symbol that is used to define a userid or a man's face with sunglasses then one cannot not delete the object, nor can you check out the same object from the registered pbl into the pbl that has the problematic object.
Workaround Description
 1) Create a Temp pbl.
2) Move all the objects from the pbl except object A
3) Using windows explorer delete the pbl with object A (has man with sunglasses associated with it)
4) rename the new temp pbl as the work pbl.



CR:221887
CR Number:   221887
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
8.0.0 2034 20 Feb 2004 Fixed
Description
The DataWindow painter will hang if DISTINCT is used as part of the DW SQL select syntax.
Workaround Description
 PowerBuilder will hang if DISTINCT is used as part of the DW select SQL syntax.



CR:221910
CR Number:   221910
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2000 Fixed
Description
REGRESSION: (thread.safe) Concurrency property set to FALSE upon PB component deployment into Jaguar.

Problem started in 7.0.2 8033. In builds prior to 8033, this property wasn't written to Jaguar at all and thus defaulted to TRUE for new components, and left this property unchanged for existing components ( leaving it at whatever it was set at).



CR:221916
CR Number:   221916
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2001 Fixed
Description
Enhancement Request: AM/PM editmask to accept upper and lower case



CR:221961
CR Number:   221961
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 2000 Not a Bug
Description
OS: WIN32
PB Version and Build: 7.0 GA -> 7.0.2.8046, PB 8.0.1290
Comments:

In the script painter you cannot navigate to an event by typing its full name in the event listbox. This was possible up until the new PB 7GUI.

Although this is possible using the event view you must still use the mouse to select the event (the enter key does nothing).

Can also press the same letter various times to scroll through all the events beginning with that letter but this is not so good if all the the events begin with 'U_' or 'pfc_'
Workaround Description
 Can repeatedly press the first letter of the event or use the arrow key but this is not much good if all the user events begin with a 'u'



CR:221966
CR Number:   221966
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
If you set up one Jaguar server (a) as a name server, point a second one (b) to use this name server and give both initial contexts (a and b respectively), you will not be able to connect to server A and access PowerBuilder components on server B using it's initial context.



CR:221970
CR Number:   221970
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Dynamically changing the column visibility of columns in a crosstab datawindow causes summary
computed fields to display in the incorrect column, sometimes appearing over the value in the
grand total field.



CR:222007
CR Number:   222007
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10034 25 Feb 2004 Fixed
Description
HTML DW on html page created in PowerSite deployed with PowerDynamo and Jaguar Server.
The datawindow has a stretched field (done in dw painter) so that user can hit <enter> when inputing data, thus inputing two lines. Htmldw retrieves these as
tag.

WORKAROUND:
Step 1: Create a user defined JS file that includes a method that will place focus on the column with the <BR> tag.
Ie:
function setFocus()
{
document.htmlDW_dataForm.lname_0.focus();
}

Step 2: Set the following properties either in the htm file or in the HTMLGenerator component:
DataWindow.HTMLGen.ResourceBase=<url>
DataWindow.HTMLGen.UserJSFile = <file.js>

Step 3: Call the method after the Generate().
Workaround Description
 See Description.



CR:222043
CR Number:   222043
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.2 01 Dec 2000 Fixed
Description
The Currentrow argument is 1 in the Rowfocuschanged event after a Filter has been applied that moves all the rows into the filter buffer.The primary DW has no rows and should have the currentrow set to 0.



CR:222051
CR Number:   222051
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Sep 2000 Fixed
Description
Control object VTrackBar's property "position" is ignored for initial settings.
Workaround Description
 In the "constructor" event, assign an initial value to the property.



CR:222054
CR Number:   222054
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
UpdateBlob sets Textsize to the size of the blob being updated but does not set it back afterwards.
Consequently if a dw retrieves data from that table after the updateblob the textsize is still set to the size of the last blob updated.
If this last value happens to be shorter than other values in the dw for that col then they will appear truncated.

Workarounds exists but as this is not the same behaviour as other drivers eg tested in O84, ODBC (with ASA & ASE), MSS etc the ct would like to see PBSYC reset textsize
Workaround Description
 Use a separate transaction object for updateblob transaction.

Set textsize back to desired size...
ls_sql = 'set textsize 32000'
EXECUTE IMMEDIATE :ls_sql USING SQLCA;



CR:222065
CR Number:   222065
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Solaris 2.6
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 06 Sep 2000 Fixed
Description
Running a pb stateless component in jaguar causes the component
to go immediately to the deactivate event once it hits getfullstate and causes
the pb client to hang.

Problem happens in the n_data/f_get_data (n_ds ds_data[ ],s_data s_data) routine:
integer i,dwcount,rc
blob initblob
dwcount=upperbound(dw_data[])
for i = 1 to dwcount
s_data.datablob[i]=initblob
rc=dw_data[i].getfullstate(s_data.datablob[i])
s_data.windowname[i]=""
next

The s_data structure is:
blob{188614692} datablob[]
string dberr[]
string windowname[]


The problem happens in the n_risk_position/f_risk_position routine. The
last line that is processed is f_select_currency_position. Using that to
remote debug n_position/f_select_currency_position it calls the f_get_data.
You can see it goes to the deactive event in remote debugging.



CR:222082
CR Number:   222082
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
The ODBC.INI file that ships with PowerBuilder does not contain a TableListType entry for Oracle ODBC drivers to include 'SYNONYM' in the table list selecion



CR:222083
CR Number:   222083
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.2 13 Sep 2000 Fixed
Description
Fractional truncation error using ODBC driver with decimal parameters and rpc calls to stored procedures in 6.5.
Verified fixed in 6.5 build 1219.



CR:222091
CR Number:   222091
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
If a row in a DW is not completely displayed, then the buttonclicked event of the DW control is ignored.
When you click the button on the row, the row is scrolled up vertically.



CR:222093
CR Number:   222093
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.00 02 Aug 2000 Not reproducible with latest version of the product available as of Resolution Date
Description
6.0.00/7.0 GA Regression. Under certain conditions, a datetime column used a in crosstab shows 01/??/1900 (question marks) if the column is one of 2 or more columns in the crosstab definition "Rows"..

Note: this happens for all databases that support datetime. Oracle native driver O84, Microsoft SQL Server 6.5, 7.x Native driver MSS and Sybase.

Works fine in 5.0.04, 6.5 gold (build 444) and above and 7.0.1 6012 and above.



CR:222108
CR Number:   222108
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Solaris 2.6
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 06 Sep 2000 Fixed
Description
Running a pb component in jaguar causes a MEM_BAD_POINTER
error message to appear in the jaguar console. On the PB client, the following corba
error appears:

Powerbuilder Application Execution Error (R0094)
Application Terminated
Error: Corba System Exception
CORBA_COMM_FAILURE at line 66 in e_select event of w_risk_position

The pb client calls the n_risk_position/f_risk_position component. This is
the entry point. It then calls the n_position/f_set_price_profile nvo. This
nvo calls the n_retrieve/f_retrieve(s_data lstr_data,s_criteria s_criteria,string additionalwhere, boolean append) returns s_data. (The f_set_price_profile has a for/next loop. It's in the third iteration
that calls the f_retrieve where the error happens.)

The problem appears to be in:
rc=retrieveds.getfullstate(lstr_data.datablob[i])



CR:222160
CR Number:   222160
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Pass by Reference string argument variable in a non-visual user object (NVO) function GPFs in Web.PB (WebPB) when you assign a local string to the argument .

This happens most often when Client/Server nvos are ported to run in Web.PB. (See example)

Function Of_setsomething (ref as_stringarg string)
string ls_sql
ls_sql = 'test - made it past assignment'
as_stringarg = ls_sql
return ls_sql



CR:222163
CR Number:   222163
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Heavy manipulation/iterations using variables of type double cause a major slowdown in processing in the executable only using Machine Code. This is NOT a memory leak or process leak but a weird slowdown (100x or more) using a double variable heavily. There is no slowdown in pcode or development.

Also, if you use machine code and a variable of type DECIMAL instead, there is no problem.

Project 'Optimization' settings don't make a difference (Speed, Space, No Optimization)



CR:222191
CR Number:   222191
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Solaris 2.6
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Sep 2000 Fixed
Description
Running a pb stateless component in jaguar causes the
component to go immediately to the deactive event once it hits setfullstate. It
causes the pb client to hang.



CR:222204
CR Number:   222204
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10032 06 Feb 2001 Fixed
Description
6.0.00/7.0 Regression. Composite datawindows. Computed fields in header/summary/footer (depending on version) don't paint (are missing, blank) in a composite until a Retrieve() is invoked.



CR:222214
CR Number:   222214
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Aug 2000 Fixed
Description
6.5 EBF Regression. Date and numeric editmasks meta characters get deleted when using backspace (when the field is NOT fully autoselected but when the cursor is placed at the END of the data.

For example, the "slash" in the date or the $ and decimal separator in the currency or numeric editmask would be deleted.



CR:222222
CR Number:   222222
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 9012 08 Aug 2000 Fixed
11 Jun 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Running a PowerBuilder component under Jaguar 3.5 (both on C3) causes a error in the srv.log ORA-01000 maximum number of open cursors exceeded.

The component has instance pooling, auto demarcation/deactivation off but a SetComplete() to return the instance back to the pool.

NOTE: This works fine with the Oracle 8.0.5 client but DOES NOT WORK with the Oracle 8.1.x client (Specifically the 8.1.5)

Fixed in PB 7.0.2 9012 in PBO8470.DLL so it now works under both Oracle 8.0.5 and Oracle 8.1.5. You will need the Jag 3.5 and PowerBuilder C3 releases (PB 7.0.2 8046) plus PBO8470.DLL from 7.0.2 9012. libjcm.dll is required for Jaguar and is part of the C3 patch.



CR:222226
CR Number:   222226
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
of_SetUpdateOnRowChange is causing an application error if the DataWindow is on a tab user object inherited from u_tabpg.



CR:222227
CR Number:   222227
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2001 Fixed
Description
PFC of_insertitem has lines commented in pfc_n_cst_lvsrv_datasource object
Workaround Description
 Uncomment the lines in of_insertitem function.



CR:222232
CR Number:   222232
Product Name:   PB Enterprise
Product Component:   Shared Objects
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
PB will stop processing after 6 or 7 iterations of
running application on unix. App is using sharedobjects. Problem happens in development
and as a pcode executable. Happens in the destroy statements.



CR:222246
CR Number:   222246
Product Name:   PB Enterprise
Product Component:   Plug-ins
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
Memory leak of 256K was observed in IE 5.5 with the use of Windows Plug-In. Customer has developed a website which is often down. Korea TS suspects that the problem could be due to this memory leak.
Workaround Description
 None available at the moment.



CR:222254
CR Number:   222254
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9015 25 Sep 2000 Fixed
Description
Related to CR 207204. This still crashes in 7.02.8046 when using conditional expressions which modify row/col/value properties

For example the conditional expression for property background.color ...
IF (salary > 200, 255,0)
Will give the following crash in build 8046
0x77f2ba00 referenced memory at 0x695f656e (memory could not be read)



CR:222262
CR Number:   222262
Product Name:   PB Enterprise
Product Component:   Automation
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
This problem has been identified with MS Word as the OLE server.
The scenario is that a request to open a non-existing document file triggers a top level
PB application SystemError event but ignores the code in the ExternalException event
AND the Error event (when code in ExternalException is commented out).
Workaround Description
 The partial workaround (see CR desc section) is not satisfactory because the main concept is that the ExternalException event does not trigger and this is detrimental for ole automation interaction.



CR:222313
CR Number:   222313
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Feb 2002 Presently Not Targeted For Any Future Release Of This Product
Description
When you scroll a datawindow with group headers using the vertical scroll arrow, the group heading dsiappears when you reach the bottom of the datawindow.

According to development , this behavior occurs when the datawindow designed by the user does not have enough room to display the following on one page:

Report Header band
all group headers
all group trailers
summary band
footer band.

To remedy the problem you must either modify the datawindow design or increase the height of the datawindow control.
Workaround Description
 none



CR:222318
CR Number:   222318
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Solaris 2.6
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Sep 2000 Fixed
Description
A pb component running in jaguar on solaris causes
a MEM_BAD_POINTER error on a setfullstate call. On the pb client, the
following corba error appears:

Powerbuilder Application Execution Error (R0094)
Application Terminated
Error: Corba System Exception
CORBA_COMM_FAILURE at line 66 in e_select event of w_risk_position

The pb client calls the n_risk_position/f_risk_position component. It then calls
the f_select_oil_position. This component calls the nvo_data/f_set_data.
The f_set_data(n_ds n_ds[ ], s_data s_data) return integer has the following
routine:
integer i,dwcount,rc
blob initblob
dwcount=upperbound(dw_data[ ])
for i = 1 to dwcount
s_data.datablob[i].initblob
rc=dw_data[i].getfullstate(s_data.datablob[i])
next



CR:222319
CR Number:   222319
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
2032 25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Using the oledb driver.
DW retrieve gives the error "Column lists do not match" when the DW SQL is dynamically changed from...
SELECT col1, charcol2 FROM table
to...
SELECT col1, NULL FROM table
using Modify("DataWindow.Table.Select=...)

The column being changed above is correctly defined as char (10) in the dw. When retrieving the new SQL the NULL is described as LONG hence the above error.

However the same code with O84, SYC, ODBC, MSS drivers does not cause this error. The new hardcoded NULL remains correctly described as CHAR.

This same code with oledb and, for example ASA via oledb, also gives the same error so this is not just a MSSQLServer issue



CR:222325
CR Number:   222325
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Exporting Package created in PB fails: Invalid IDL file.



CR:222326
CR Number:   222326
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2000 Not a Bug
Description
This problem has been identified with PB connect ODBC interface to MSSQL 7 for column datatype CHAR. Behaviour for column datatype VARCHAR is correct.

The column data is compared to "match string" that can include special
symbol "%". This symbol is supposed to match any string of zero or more chars.
E.g.
Branch.county LIKE "%" -> Should return all rows
Branch.county LIKE "L%" -> Should return rows where "county" begins with "L"
Branch.county LIKE "%e%" -> Should return rows where "county" has letter "e" in it
Workaround Description
 If possible: use varchar col instead of char, use Microsoft Sql Server native interface ... until this CR is fixed;



CR:222344
CR Number:   222344
Product Name:   PB Enterprise
Product Component:   DW Graph
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
If a graph datawindow's Text Object: Value Axis Text is changed and saved, when reopened the
display format is listed but it does not display correctly. The Text Object can be found on the Text Tab of the dw property menu. This worked in 6.5.



CR:222385
CR Number:   222385
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
ActiveX OLE object events with the same names than PB Events are replaced by PB events instead of being renamed.
It only occurs when their signature is different from the PB event signature
Workaround Description
 Paste the OLE control on the window and save it.
Export the syntax of the window and open it with the script painter.
For each event causing trouble add "ocx_" as prefix for the event and modify the signature as needed
Reimport the syntax



CR:222388
CR Number:   222388
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0 Beta 3 31 May 2001 Fixed
Description
The documentation for _Narrow () function needs updating for calling EJBs running on Jaguar CTS from a PB client.

The example shows the following...

my_corbaobj._narrow(my_account,"n_Bank_Account")

This will not work for EJBs if the the java package name follows the domain-name.package name format which the EJB/PJ docs recommend.

It works fine if the java package name is the same as the Jaguar package name. The only way it works is by passing the classpath and home interface to the _narrow method - e.g. myexample/simplebeanpackage/simplebeanhome (where the EJB package is created as myexamples.simplebeanpackage -> this creates directory structure in %JAGUAR%\html\classes called myexamples\simplebeanpackage containing all the classes )

So calling the ejb this way...
my_corbaobj._narrow(lnv_cmhome,"SBean/SimpleBean")
//Component name or Package/Component name does not work, whereas this does...

my_corbaobj._narrow(lnv_cmhome,"myexample/simplebeanpackage/SimpleBeanHome")

This needs changing for the _Narrow() function and also for the example for String_To_Object function



CR:222391
CR Number:   222391
Product Name:   PB Enterprise
Product Component:   UO - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Simple application with many numeric instance variables on a user object performing a lot of calculations runs quickly in development and with a pcode executable but slows down or freezes when run with a machine code executable in all versions of PB 6.5.1, 7.0.2 and 8.0 tested.



CR:222397
CR Number:   222397
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
Current Documentation has SaveAs description as the following :
Saves the contents of a DataWindow or DataStore in the format you specify.
When using SaveAs (excel) only the information that gets saved is from the primary buffer, not the info that one might have in computed fields or group bands, in other words info that is calculated at runtime is not saved. It would be helpful if this documented in the documentation as many customers open cases because of this.
DW Reference Guide = MC0013



CR:222438
CR Number:   222438
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 9021 28 Nov 2000 Fixed
Description
IN9 and IN7 native connection to Informix 9.20 (works fine with Infomix 7)
Tablenames are incorrect in database- and dw-painter.
Instead of "tablename" (if user is owner) or "owner.tablename" PB shows
"owner tablename.tablename"
When trying to create DataWindow this returns Error -201 (rc -1) : SQL error -201 : A syntax error has occurred.



CR:222442
CR Number:   222442
Product Name:   PB Enterprise
Product Component:   Structure - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Passing a null value to a Any datatype in a structure
causes a error of:
Powerbuilder Application Execution Error (R0091)

Application Terminated
Error: Cannot convert any in Any variable to a string. Possible cause of uninitialized value
at line 17 in clicked event of object cb_2 of w_test



CR:222444
CR Number:   222444
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.2 06 Feb 2001 Fixed
Description
Tabbing out of a dddw that contains a NULL in the list causes the value to revert to NULL
Workaround Description
 none



CR:222450
CR Number:   222450
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2000 Not a Bug
Description
This problem has been identified in the DW painter.
For datawindows which have group(s) of 1 or greater, they exhibit a display problem when box/thumb on vscrollbar is moved in little increments. The incorrect page display is sporadic. Some pages have extra blank lines at the page break section.

This display problem does not occur when the vscrollbar arrows are clicked using the up/ down arrows on the vertical scroll bar.



CR:222454
CR Number:   222454
Product Name:   PB Enterprise
Product Component:   Environment Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2000 Fixed
Description
When a folder has a dot in its name and you select set
root to a directory, the treeview is blank.



CR:222457
CR Number:   222457
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5031 23 Apr 2001 Fixed
Description
GPFs accessing variablelist initialvalue property of a classdefinition object



CR:222462
CR Number:   222462
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2000 Fixed
Description
8.0 Beta 1: Next/Previous Error menu items and icons should be disabled



CR:222463
CR Number:   222463
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 2000 Fixed
Description
8.0 Beta 1: The system tree view displays items in descending sort order.



CR:222478
CR Number:   222478
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0 Beta 3 10 Nov 2000 Fixed
Description
1) Wordings in the messagebox when no Jaguar servers are set in the components tab is wrong
2) No visible behavior when Yes is selected
3) When No is selected the tree does not refresh properly.



CR:222479
CR Number:   222479
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 EOL'd version. Not to be Fixed.
Description
When component is deployed to Jaguar and a Delete is done after a GetFullstate issuing
a ResetUpdate does not clear the delete buffer.



CR:222482
CR Number:   222482
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PB8Beta1 : Select only profile name in EAServer Servers rather than the complete row.



CR:222483
CR Number:   222483
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Sep 2000 Fixed
Description
PB8Beta1 : exported source of dw says Release 7 instead of Release 8



CR:222488
CR Number:   222488
Product Name:   PB Enterprise
Product Component:   Environment Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Sep 2000 Fixed
Description
In PB ide, select "window - clip". This would open a clip window. The delete button on the window overlays the vertical splitter bar. The concern is that it can be accidentally clicked in the process of resizing the window.



CR:222504
CR Number:   222504
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jul 2004 Not reproducible with latest version of the product available as of Resolution Date
Description
PSE Notes : hchaudha 08/01/2000
PB8Beta1 : Takes > 3 minutes to load Java Applets tree



CR:222508
CR Number:   222508
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2000 Not a Bug
Description
In PB GUI, open up the system tree view.
1. The system tree view docking window does not have a expand button.
2. The splitter should also be wider.
3. The LinesAtRoot property of the treeview (TVS_LINESATROOT Windows style) should be turned off .



CR:222541
CR Number:   222541
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2004 EOL'd version. Not to be Fixed.
Description
Running the pbsyc.sql in isql.exe for a ASE 12.0
causes the following errors to appear:

Functions may only be nested to level 10
Msg xxx, Level 15, State 1



CR:222562
CR Number:   222562
Product Name:   PB Enterprise
Product Component:   UO - Runtime
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
GPF occurs while repeating destroying UO instance
On NT 4.0 it works fine. GPF occurs only on win95 and after some iterations
Creates (5700) Destroy (590) invalid page fault in pbvm60.dll



CR:222602
CR Number:   222602
Product Name:   PB Enterprise
Product Component:   Structure - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
PB 7.x : The datatype of a structure's member variable of type ANY is not correctly set when copying a NULL variable into it.



CR:222607
CR Number:   222607
Product Name:   PB Enterprise
Product Component:   Install
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2001 Not a Bug
Description
When installing PB 8 beta 1 on a win98 machine , after about 75% of the install is over one gets the following error :
ComponentMoveData Error Information
MediaName:data
Component:Client Install (PowerSite)\Program Files
File Group:Program DLLs(ps)
File:
Error Number:-145



CR:222623
CR Number:   222623
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10001 26 Oct 2000 Fixed
07 Nov 2000 Fixed
Description
7.0.2 EBF Regression build 9010. (Works OK in 7.0.2 8003 and C3 Build 8046) Simple date editmask of mm/dd/yyyy "day" portion skips right to 'year' part of editmask after you have typed in only 1 number for "day".



CR:222648
CR Number:   222648
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.2 10021 20 Nov 2000 Fixed
Description
PB7.02 slow performance on datastore CREATEFROM on handling large resultset.
Workaround Description
 replace pbdwe07.dll of PB 7.02 build #8011 or above by #8003



CR:222655
CR Number:   222655
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Sep 2000 Duplicate
Description
In PowerBuilder 6.x if you have a window object which contains a UserObject control which is inherited from an existing UserObject. You cannot open and edit the UserObject if the window object is open.



CR:222657
CR Number:   222657
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Sep 2000 Presently Not Targeted For Any Future Release Of This Product
Description
Short Desc:
Sql against db2 with a where clause doing a look back of 1 month fails when the current month has 31 days and the month it is looking back at has less then 31 days.



CR:222662
CR Number:   222662
Product Name:   PB Enterprise
Product Component:   File Editor
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Oct 2001 Fixed
Description
Memory Leak in PB 8.0 when opening a large srd file from file editor. PB hangs.



CR:222663
CR Number:   222663
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Sep 2000 Fixed
09 Feb 2001 Fixed
Description
Description of Problem: Library painter shows files of all types of extensions on your drive (e.g; exe. txt., dll, doc etc). Also sorting by "name" requires numerous clicks. Should sort in an alphabetical order on a single click.
Comments:



CR:222679
CR Number:   222679
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10032 19 Apr 2001 Fixed
Description
OLEDB driver is deleteing the preceding 0's in milliseconds when going against a MSS 7
database.
The only workaround for the time being would be to use the Convert function :
CONVERT(character, datetime_covercall.date_info, 9)
Workaround Description
 The only workaround for the time being would be to use the Convert function :
CONVERT(character, datetime_covercall.date_info, 9)



CR:222776
CR Number:   222776
Product Name:   PB Enterprise
Product Component:   Web.PB
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5.1 1259 31 Oct 2002 Fixed
Description
using webpb to transfer an "exe" file, the exe retrieved is corrupted..





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