提供7*24专业Sybase数据库远程及现场技术支持,Sybase ASE及Sybase SQL Anywhere数据库修复服务,
请联系电话: (微信),QQ: 289965371!
We supply technical support for Sybase ASE and Sybase SQL Anywhere, also have many years of experience in recovering data from damanged Sybase devices.
Please contact us:
Phone:
Wechat: 13811580958
QQ: 289965371 联系我们获取数据库技术支持!
Email: 289965371@qq.com
扫描下方微信,联系我们:
扫描雨翰数据恢复官方微信获取专业数据库恢复服务

 

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE,可以看到针对不同版本的CR(CR表示Change Request)简单描述信息列表。
需要注意的是:Targeted CR List for ASE列出的CR虽然绝大多数是BUG,但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息!

如有问题,请联系我!

QQ :289965371 联系我们获取数据库技术支持!
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

CR:237909
CR Number:   237909
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Aug 2004 EOL'd version. Not to be Fixed.
Description
In Library painter, RMB on a dll in order to view the properties. PB hangs on Win95 and Win98. THe problem does not occur on Win2000 or NT.



CR:237910
CR Number:   237910
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7015 22 Jun 2001 Fixed
Description
DW Evaluate expression: Evaluate('count ( id for group 1 )', row) not being evaluated correctly in 8.0



CR:237912
CR Number:   237912
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)
18 Sep 2001 Not a Bug
Description
Customer would like a workaround for the general problem with binary storage of floating point numbers implemented in PowerBuilder.



CR:237913
CR Number:   237913
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2004 Not reproducible with latest version of the product available as of Resolution Date
Description
Installation of pb8 version 5029. When Infomaker is installed first including JDBC, OLE DB and Oracle O73/O84 native drivers and several ODBC drivers, a subsequent Powerbuilder installation with the same selections fails with the following error:

MediaName: Data
Component: Merant 2.5 ADO for Oracle 8i
File Group: OLE DB Merant Adapter
File: C:\WINNT\temp\SFGb180.rra\ivpbb180.rra
Error Number: -2147024891



CR:237946
CR Number:   237946
Product Name:   PB Enterprise
Product Component:   DW Graph
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Sep 2002 Fixed
Description
The graph functions like seriescount, categorycount, SeriesName, categoryname, GetData all do not work for datastores for the functions.

Resolution:

(1) From documentation, between datawindow object and datastore object, for datastore, ''Your can do anything to the datastore object EXCEPT graphics operations''.

(2) All powerscript function calls like ''seriescount()'', ''categorycount()'', ''seriesname'', ''categoryname'', and ''getdata'' will get a pointer to graph instance which is created during the painting processing. The pointer is used to get the attribute values and relevant data. Painting is done everytime drawing a datawindow control with datawindow object, but for datastore object, no painting process is needed.



CR:237971
CR Number:   237971
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2004 Fixed
Description
PB 8.0 Beta: A boolean expression in the Validation message should be invalid.



CR:237981
CR Number:   237981
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Aug 2004 Not reproducible with latest version of the product available as of Resolution Date
Description
If you have a structure defined within a user object, it is not found when you do a global search (for the structure name) from the library painter. Customer would like this functionality added.



CR:237995
CR Number:   237995
Product Name:   PB Enterprise
Product Component:   P-Code Deployment
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
String handling functions need performance improvements. In particular, Mid function and concatenation operation ( <string1> += <string2> )



CR:237999
CR Number:   237999
Product Name:   PB Enterprise
Product Component:   Help
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2001 Fixed
Description
Typo in the help file "Database Profile Setup - OLE DB dialog box." Under the fifth sub heading "Data Source", the first line reads, "Select the name of the OLE DB data source to which you want to connect. This value varys..."
It should be "varies"



CR:238132
CR Number:   238132
Product Name:   PB Enterprise
Product Component:   DB Profile
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2005 Fixed
Description
Specify ODBC API Trace File name in DB Profile painter (Options Tab). Uncheck it later and the filename disappears from the textbox. But it continues to remain in the DBParm.



CR:238143
CR Number:   238143
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Aug 2004 Third Party Problem
Description
Merant driver for Oracle 8 shows wrong list of stored procedures and is slow

2 issues here with the Merant Oracle 8 driver (PBOR815.dll v3.60.00.16) as compared to the

PB Native driver for oracle and the PB Intersolv Driver (PBOR813.dll v3.11) for Oracle

going against Oracle 8 database.

1) Performance - Bringing up the list of Stored Procedures in database painter takes a

longer when using the Merant driver

2) In database painter or create a new dw based on SP - List of Stored Procedures and

functions seems to display only the ones whose owner is tstemp (the userid I used to connect

to database) when using the merant driver, but if you see the list displayed using intersolv

or native interface then you will see all the sp's.



CR:238225
CR Number:   238225
Product Name:   PB Enterprise
Product Component:   AutoScript
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6018 10 Jul 2001 Fixed
Description
OS: Win32
PB Version and Build: PB 8.0 6006/ 6008 /6014
Comments:

When repeatedly switching to another app using the ALT + TAB keys while autoscript is 'suggesting' the next piece of code to write, an additional bit of code gets pasted into the script painter each time you switch back to PB.

This happens when there is only 1 valid suggested method/property ie when it pastes the suggested code directly into the script , if you select from the autoscript list box there is no problem. It may take several ALT + TABs to see the problem.
Workaround Description
 Use Window taskbar to switch between apps
Hit enter before ALT + TABbing between applications



CR:238231
CR Number:   238231
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2004 Fixed
Description
Wheel mouse doesn't work properly in the Properties of the dw design. Clicking on properties and scrolling the wheel will make a single change to the units dd and then cursor goes to the preview pane.



CR:238245
CR Number:   238245
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 RC0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
Error R0023
Cannot assign object of type <type> to variable of type <type>

In PB7 error R0023 can occur when creating an object in syntax 2 (CREATE USING objecttypestring)
after the function SetLibraryList has been called.

This happens when the object is in the exe and the object was not yet loaded during script execution.
Work-around is to compile the objects into dynamic libraries instead of the exe.



CR:238246
CR Number:   238246
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2004 Third Party Problem
Description
after calling PrintSetup Dialogfor HPLJ1100, pointer missing over command buttons when finished
Cr is closed as an HP problem with the comment that it is reproducable in other applications.
With a VB sample that problem is NOT reproduceable.
Please review CR#: 205992.
Workaround Description
 non



CR:238250
CR Number:   238250
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0 Beta 4 7004 10 Jul 2001 Fixed
Description
If you select an invalid .ico file or .cur file PB will crash with the following error
0x10bb1e20 @ 0x0b337000 -> mem read error (PBVM)
Problem is only with .cur and .ico files, using invalid .bmp / .gif / .jpg / .rle files on picture buttons works fine (ie no crash)



CR:238252
CR Number:   238252
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Please include a default function in the datawindow which would calculate the current week number of the running year.



Customer needs a function in the datawindow which would calculate and return the week number of current week in the running year. (out of the 52/53 weeks).



The international rule while calculating the week number is as follows:

1. If the first week starts any later than wednesday, then the days till the saturday are considered to be the part of the 53rd week of the previous year.

2. The first week starts from the immediate sunday onwards.

3. If the week starts any earlier than thursday, then it is considered as the first week.



CR:238280
CR Number:   238280
Product Name:   PB Enterprise
Product Component:   Browser
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jul 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Local external functions on a user object of type transaction (RPCFUNC) no longer show up in object browser (userobject tab, under functions) in PB 7 and PB 8. They did show in PB 6.5.
Target Version
 9.0.3
Review Status
 This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release



CR:238294
CR Number:   238294
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10077 25 Feb 2004 Fixed
Description
Termination of cache connections in EAS leads to PB component instability.



CR:238410
CR Number:   238410
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2001 Fixed
Description
PB 8 build 6017 :
The status refresh rate should be set to 5 not 0 by default.



CR:238421
CR Number:   238421
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2002 Third Party Problem
Description
Short Desc:
If you use HP PCL driver then mouse cursor dissappears after going into the drivers setup, does not happen

if you use the Postscript printer driver.
Workaround Description
 Either use the postscript driver or set the Pointer to Icon! instead of Arrow!



CR:238423
CR Number:   238423
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jun 2001 Fixed
Description
Web Datawindow, column with date field, format "mm/yyyy" validation error

WebDatawindow, html dw, HTMLDw.

Workaround: If you enter the date as dd/mm/yyyy, you can tab off without the validation error and the date will be displayed as mm/yyyy.
Workaround Description
 If the date is entered dd/mm/yyyy you can tab off without the validation error, and the display value remains mm/yyyy



CR:238464
CR Number:   238464
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 RC2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
Generated syntax for a DW based on stored procedure does not work with JDBC
Workaround Description
 * Export your DataWindow and check for the line
procedure="1 execute informix .jz_sp_informix_in9;0 " )
Remove the spaces and Import the Datawindow : normally, you can retrieve the datas.



CR:238466
CR Number:   238466
Product Name:   PB Enterprise
Product Component:   DW Expression
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
Describe(Evaluate('Page()'," + string( row ) +")")
The above expression returns the page number of the specified row.
But if the datawindow contains a nested datawindow, then the describe returns the
current page number.

To find out the page number of a particular row, the function scrolltorow can be used.
For example:
dw_1.setredraw(false)
current_row=long(dw_1.object.datawindow.firstrowonpage)
dw_1.Scrolltorow(10)
dw_1.Describe( "Evaluate('Page()'," + string( the_row ) +")")
dw_1.scrolltorow(current_row)
dw_1.setredraw(true)



CR:238479
CR Number:   238479
Product Name:   PB Enterprise
Product Component:   DW DDDW
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In a Drop Down DataWindow, when the user moves the mouse over it, the item does NOT highlight as the mouse tracks over it. In a real DDLB, the items highlight. This is std MS behavior. Please change the DW to comply.



CR:238492
CR Number:   238492
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PB Version and Build: PB 8.0 build 6014 and PB 7.0 GA to 7.03
Comments:
Allow SetFullState to pass dynamically modified dw properties.
With its current implementation SetFullState only passes properties which can be saved in a .srd file. New feature request to allow this function to pass properties which have been modified dynamically at runtime. For example DataWindow.Print.Copies property can only be modified/set dynamically. A further example is for Selected Rows to be passed (especially as GetSelectedRow() method is available in the datastore)
Workaround Description
 Would need to implement a user defined function which calls Set/GetFullState AND also passes the print.copies value as an additional arg



CR:238495
CR Number:   238495
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10138 13 Dec 2001 Fixed
Description
Edit data for a valid table returns nothing after executing a select stmt against an invalid or non existing table until you disconnect and connect again

ODBC to ASA , Native Oracle, ASE all work fine. Even connecting to a MSS database using the ODBC interface works fine. The problem seems to lie only with the native interface.
Workaround Description
 Workaround : Use ODBC interface



CR:238497
CR Number:   238497
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0 Beta 4 7013 10 Jul 2001 Fixed
Description
Delete Event is disabled for user-mapped events in the context menu accessed in the event prototype area of the script painter.



CR:238501
CR Number:   238501
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10085 25 Jun 2001 Fixed
Description
Justify works correctly on a column but behaves erratically only on a computed fields
Workaround Description
 Resize the computed field



CR:238512
CR Number:   238512
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10104 25 Feb 2004 Fixed
Description
EAServer Internal System Exception thrown when multiple PB components running in EAServer connect to Oracle 8.17 DB



CR:238532
CR Number:   238532
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2001 Fixed
Description
PB Version and Build: PB 7.03 and PB 8.0 docs and online help
Manual: Datawindow Reference
Comments:

DW buttons and pictures do not have a property called 'PictureName' -> this should be documented as 'FileName'. Code (Modify/Describe/dot notation) which references PictureName property of a DW Button or
Picture will give an error.

Use the object browser with a dw containing a picture or button - only the FileName property exists for the picture/button.

Note: the PictureName property does exist for the PictureButton / Picture window controls however and there is no FileName property for these controls - this is correctly documented
Workaround Description
 n/a



CR:238566
CR Number:   238566
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 May 2001 Duplicate
Description
PB 8 build 6017
Status refresh rate checks if it has a valid value only when you click on "Apply", not on "Connect", should be on Connect as well.



CR:238567
CR Number:   238567
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 May 2001 Duplicate
Description
Instead of Connect if you Click "Apply" after adding all the info regarding userid, project etc , then you are automatically connected to Source Control . At this point the "Connect" button should be disabled as we are already connected, which is not the case



CR:238595
CR Number:   238595
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If you call PopulateError() in script, it loads the Error Object with information such as the name of the object, the method that is being processed, the line number etc. Is there any way that I can get to these underlying functions in script? For example, is there a GetMethod() function that will give me the name of the method currently running. Classname() will give me the name of the object, but I'd really like to pick up the method name without having to
hard-code it.



CR:238627
CR Number:   238627
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2001 Fixed
Description
GPF saving changes to an object in an application that contains many global structure variables which have nested structure fields. Not a circular reference in this case.



CR:238637
CR Number:   238637
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PB 8.0 Enhancement Request: Wants to Zoom in and out in the DW painter.



CR:238669
CR Number:   238669
Product Name:   PB Enterprise
Product Component:   WT - Object Model
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0 GA 6020 08 May 2001 Fixed
Description
InsertRow then a delete causes wrong row to be deleted with Web Target



CR:238713
CR Number:   238713
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 May 2001 Not a Bug
Description
PB 8 Build 6017 :
Since we have moved from Target -centric pbg file to PBL Centric PBG file there is no purpose of storing the Libraries section in the PBG file
Update from development :
It may be the case that the libraries section of the .pbg is now unnecessary, but there is absolutely no compelling reason to redesign PB internal data files DURING or AFTER the GA code freeze.



CR:238726
CR Number:   238726
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10077 22 Jun 2001 Fixed
Description
Using sharedata with a 2 level nested dw causes a GPF on close of window



CR:238757
CR Number:   238757
Product Name:   PB Enterprise
Product Component:   DB JDBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Aug 2003 Fixed
Description
When the table contains special characters (eg. turkish character Ascii code 145 or Ascii code 146 ) , retrieving this row from the table yields in Errormessage: "Select error: PowerBuilder JDBC Internal Error"



CR:238759
CR Number:   238759
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2003 Not a Bug
Description
When selects an Item and then clicks somewhere else the treeview looses focus but the selected item is not visible anymore if the treeview background color is "ButtonFace" (hideselection is disabled)
Workaround:
change the background color of a treeview into a color that is different from "buttonface" or "gray"
Workaround Description
 change the background color of a tv into a color that is different from "buttonface" or "gray"



CR:238771
CR Number:   238771
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2001 Fixed
9.0 Beta 4 10 Apr 2005 Fixed
Description
Run Source Control Management Tool should be available at the Workspace level



CR:238772
CR Number:   238772
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 2001 Fixed
Description
Selecting Require Comments on Check-In with VSS forces user to add comments on Checkout as well.



CR:238783
CR Number:   238783
Product Name:   PB Enterprise
Product Component:   SQL Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10081 10 Jul 2001 Fixed
Description
The problem is occuring for a nested outer join in the PB SQL painter when
the connection is ODBC for an Oracle 8.x db. The SQL painter does not accept the
syntax of this escape sequence and displays an Error 999 (rc -1) : SQLSTATE = 37000

However painting the above for an ASA v7 db is successful in PB SQL painter.



CR:238838
CR Number:   238838
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jul 2001 Fixed
7.0.3 03 Jul 2001 Fixed
Description
The customer has a requirement to use Infomaker and Powerbuilder tools to work
against Oracle and ASA databases. They require that nested outer join sql is
transparent for the 2 databases interrogated.

Can a workaround be found for PB so that 'oj' syntax is consistent in PB SQL
between databases Oracle / ASA
e.g. for dw sql "convert to syntax", pb ISQL session etc.
and then code manipulation at runtime when odbc api called ?

Per Development:
The fix only applies to Oralce client 8.1.6 or above.



CR:238845
CR Number:   238845
Product Name:   PB Enterprise
Product Component:   DB Other
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
Request for Powerbuilder to support Int(64). This is an enhancement request as a result of an EP customer trying to use AI for CICS. Please refer to CR 238711 for an associated CR.

Request is as a result of a customer having a Cobol app written from AI for CICS. With one column that has a declaration of PIC(9) and Col (3) there is a problem. A truncation error occurs when the Application Integrator Component Builder attempts to bind the column to an int(32). Since the int(32) is too small to hold up the column value from his cobol code PB needs to support int(64)

Currently PowerBuilder currently supports 32 bit integer. Refer to CR 238845 for related CR.



CR:238855
CR Number:   238855
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2001 Not a Bug
Description
Using Merant ODBC driver to Oracle 8, create a new datawindow with stored procedure source. The list of stored procedures never comes back. PowerBuilder hangs.



CR:238857
CR Number:   238857
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
From customer:
We have a PB component running in Jaguar generically processing requests.
This component operates on datawindows and datastores that many other
developers built. If a developer makes invalid reference (and did not test
their code sufficiently) it brings the generic component application down
due to PB system error. It would be extremely helpful if Jaguar would
automatically refresh that component to allow subsequent calls to go
through. Instead, now the whole thing remains down until someone either
refreshes that generic component or re-cycle the server.

In another situation it would be helpful for me to know how to refresh the
component from within a PB code. For example, I have a shared component
that caches some data. This data rarely changes, but when it does, it would
be nice to be able to trigger a "refresh" of this component to force it to
retrieve a fresh set of data. We have a C/S PB app that could change that
data and so I would then call a Jaguar primitive from within that app to
refresh the component running in Jaguar.



CR:238878
CR Number:   238878
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jun 2001 Fixed
Description
Error trying to create a datawindow using the Merant ODBC driver to Oracle 8, with a stored procedure source
when the stored procedure has retrieve arguments.



CR:238938
CR Number:   238938
Product Name:   PB Enterprise
Product Component:   DW - Runtime
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
wrong dwo is given back in dragdrop event for dw for cb, textobject, pictureobject.
It should given back like in the clicked event.

workaround:
use the in the dragdrop event the function getobjectatpointer() instead dwo.name

String objectname
objectname=getobjectatpointer()
Workaround Description
 use the in the dragdrop event the function getobjectatpointer() instead dwo.name

String objectname
objectname=getobjectatpointer()



CR:238966
CR Number:   238966
Product Name:   PB Enterprise
Product Component:   DW HTML
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
Customer has a datawindow with an Oracle column of type string with a length of 2000. The datawindow alone automatically reports an error if you try to enter more than 2000 characters. The Web datawindow does not enforce the column length.

Workaround is to explicitly add a validation expression: len(gettext()) <= 2000



CR:239051
CR Number:   239051
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like to have describe.dbname return the alias they are using in their select statement rather than the actual table name in the database.



CR:239140
CR Number:   239140
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Feb 2004 Presently Not Targeted For Any Future Release Of This Product
Description
According to the PB 7.0.3 readme.txt, the following dbparms are not
supported by syj. However, if you do a lookup of these dbparms in the
online help, it lists that they supported for the syj driver.

AppName
Host
MaxConnect
PacketSize
PwEncrypt
Release
TableCriteria
Async
DBGetTime
Language
Charset
Locale
DS_Provider
DS_DITBase
DS_Principal
DS_TimeLimit
DS_Failover
DS_Copy
DS_Alias
Sec_Mechanism
Sec_Server_Principal
Sec_Sess_Timeout
Sec_Cred_Timeout
Sec_Mutual_Auth
Sec_Network_Auth
Sec_Delegation
Sec_Channel_Bind
Sec_Keytab_file
Sec_Confidential
Sec_Data_Integrity
Sec_Data_Origin
Sec_Replay_Detection
Sec_Seq_Detection



CR:239149
CR Number:   239149
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2001 Fixed
Description
Executing SqlConfigDatasource dynamically with DataSourceName as part of the attributes will cause PB to crash.
Workaround Description
 Workaround : Do not pass DSN name as part of the attributes when creating a datasource

dynamically or use ASA 7 instead of ASA 6.



CR:239182
CR Number:   239182
Product Name:   PB Enterprise
Product Component:   BAM Deployment
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Aug 2001 Fixed
Description
Trying to deploy a pb component to jaguar 3.6.1 (c1) crashes pb.



CR:239221
CR Number:   239221
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2001 Fixed
Description
implement Oracle Net 8.1.x support in 6.5.1



CR:239223
CR Number:   239223
Product Name:   PB Enterprise
Product Component:   UO Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0 RC 7012 11 Jul 2001 Fixed
Description
PB8 Beta : GPF when opening a UO with breakpoints and arguments with _

workaround:
to open the object delete the debug entry in the pb.ini file
Workaround Description
 to open the object delete the debug entry in the pb.ini file



CR:239274
CR Number:   239274
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10088 16 Aug 2001 Fixed
Description
Dot notation loading data in datawindow doesn't re-draw datawindow in certain situations.
Workaround Description
 In the datawindow itemfocuschanged event use setitem to put data into the primary buffer, rather than dot notation.



CR:239333
CR Number:   239333
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6023 29 May 2001 Fixed
Description
PB Version and Build: Tested in PB 8.0 Builds 6006, 6017, 6020
DB/DLL: pbo7380.dll & pbo8480.dll
Comments:

Native Oracle drivers ignore delimitidentifier = 'No' dbparm. Quotes are always put around SQL no matter what this is set to.

Checked the sql in a dw created when 'Enclose Table and Column Names in Quotes' option checked OFF (the dbparm can be seen in pbtrace.log).
Not reproduced with other dbms.



CR:239336
CR Number:   239336
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2004 Fixed
Description
A gpf can occur on inherited shared objects running in a PB7 exe when the objects have been compiled into the exe and not in pbd's or dll's.
Work-around is to compile the application with the option not to put any objects in the exe.



CR:239341
CR Number:   239341
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request from a customer.

Customer would like the ImportString to import numbers in any format even if there is no standard symbol in either the decimal symbol and / or in the digit grouping symbol. This is allowed in a datawindow retrieve.

The ImportString function will not work if the regional settings - number has only one standard setting (period or comma or other) for the decimal symbol or the digit grouping symbol and the import is of a format other than the Regional setting. The customer uses this function to import numeric string data from a tab delimited file and would like to keep the same base line of code for each customer, regardless of the customer's country standard (ie Czechoslovakia uses spaces for a digit grouping symbol, and other countries use either commas or periods. Other countries use varying symbols for the decimal symbol). He would like the ImportString to work like the datawindow, which retrieves numbers without needing either a comma or a decimal in either place in the import string or in the regional settings - number.



CR:239381
CR Number:   239381
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2001 Duplicate
Description
Allow NT authentication when using Native Oracle Interface from PB.
Assuming the oracle server alias name in tnsnames.ora file is "oracle817". After addition of userid on the Oracle server (Follow steps indicated in Oracle8i Administrator's Guide - Authenticating Database Users with Windows, http://technet.oracle.com/doc/oracle8i_816/nt.816/a73008/ch7.htm). Run sqlplus, leave userid and password blank, for server put "oracle817". Click OK. Then when you are prompted to enter user name again , type "/@oracle817", hit Enter , you should be connected. From PB - dbprofile, create a datasource, leave userid and password blank and for servername put "oracle817". Click ok and Connect you should be sucessfull.
Workaround Description
 Use OLEDB interface to connect to Oracle , then you can use the IntegratedSecurity DBParm parameter (If you use SSPI as the security service then it will use NT authentication)



CR:239482
CR Number:   239482
Product Name:   PB Enterprise
Product Component:   Function Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
PB8 Beta 4 , build 6021.



Menut Items under Edit - Paste Special when a new function object is created are not similarly enabled or disabled as you would see when you right mouse button click in script painter of the function object. For example on RMB Paste Special - function - Built-In is enabled but it is not if you go to Edit - Paste Special - Function - Built-In. Same behavior is seen for SQL and Statement as well



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:239513
CR Number:   239513
Product Name:   PB Enterprise
Product Component:   DW - Runtime
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
With a decimal field on a datawindow that has right or center alignment and is sized to be the exact size of the data to be displayed, one digit less than can be displayed can only be entered when doing data entry. As an example if the decimal value is 56.75 and the edit field is sized to correctly display this, when one would attempt to input the value only 56.7 can be entered. When one tabs off the field 56.70 is displayed and would be saved to the database.

If left alignment is used there is not a problem. Simple workaround is to accomodate for this and make the field slightly larger.

This is a simple edit field, not an edit mask as reported in a similar problem in CR 225714. This is also not a result of the Office 2000 Ariel fonts as both True Type and non true type were tested and the machine this was tested on did not have Office 2000 installed.



CR:239515
CR Number:   239515
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Aug 2003 Fixed
Description
A Disconnect in PB destructor event disables the Jaguar connection cache



CR:239574
CR Number:   239574
Product Name:   PB Enterprise
Product Component:   DW HTML
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
Getitem() failing on computed field with WebDW.
Use the following workaround until fixed.

1. Hide the computed fields on the DataWindow
2. Return two empty columns from the Stored Procedure to the DataWindow
3. Use these two empty columns as holders for the computed fields data.
4. Create a server-side service class that moves the data from the computed fields into the empty columns in the retrieveend event
5. This should allow you to use GetItem to retrieve these "Computed Fields" from regular columns



CR:239579
CR Number:   239579
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Aug 2004 Fixed
Description
PB 8 build 6022 :
Problem 1
When application is run in debug mode without any breakpoints set, then it will stop at an imaginary breakpoint at somepoint in the application.
Problem 2
Cannot switch to another app like notes/windows explorer etc when you are running a PB 8 app in debug mode , especially if PB is maximizied in the background. If you minimize pb then go into notes or some other app you will run into some weird behavior like being able to view an e-mail but not able to edit it etc.



CR:239599
CR Number:   239599
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2004 Not a Bug
Description
The customer is creating a system that reports on the last Windows API error that was generated. He is using the API call GetLastError() to get the information about the last error. He is also using a PB exception and in the exception object he is calling GetLastError(). It appears that the in the process of throwing the exception or in the creation of the exception object that PowerBuilder itself is calling a Windows API function, that is of course affecting what the customer is getting from GetLastError(). He wants to know what is PB doing that changes the information returned by GetLastError()



This is not a PB bug. The testcase triggers an error and then throws an exception. In the exception object the GetLastError API call is made. On the first iteration of throwing the exception PB needs to load some dlls and is making API calls that change the system error log and what the customer sees when calling GetLastError. On subsequent iterations, the dlls are already loaded and there are no api calls made by PB between the triggering of the error and GetLastError call and he gets expected results.



CR:239619
CR Number:   239619
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jun 2001 Not a Bug
Description
PowerBuilder client crashes with JDBC2 compliant TabularResultSet

Per Development "Not A Bug:
It was found that the crash was due to TabularResults package not returning the correct number of rows to PowerBuilder client.
Workaround:
The customer will have to convert JDBC2 compliant TabularResultSet to JDBC1.1 compliant TabularResultSet before sending it back to PB client.
Workaround Description
 The customer will have to convert JDBC2 compliant TabularResultSet to JDBC1.1 compliant TabularResultSet before sending it back to PB client.

The workaround is not efficient because of extra conversion but it's the only alternative.



CR:239632
CR Number:   239632
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2001 Not a Bug
Description
When a response window is opened from a main window and in the open event of the response window is an error, the response window should not be opened (PB7 behavior). Now in PB8 the response window is opened and the errormessage is displayed when closing the response window.

Not a bug - feature in PB8 (see pb8readme.txt about SystemError):
I have implemented the error handling in the open event script of the
w_response window as following, which solves the problem

datastore ds
try
ds.dataobject = ""
catch(runtimeerror e)
messagebox("Application Error",e.getmessage())
close(This)
end try
Workaround Description
 I have implemented the error handling in the open event script of the
w_response window as following, which solves the problem

datastore ds
try
ds.dataobject = ""
catch(runtimeerror e)
messagebox("Application Error",e.getmessage())
close(This)
end try



CR:239636
CR Number:   239636
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2001 Fixed
Description
When inserting a new function and using only key 'tab' to move to the newly inserted argument, defining the argument name as 'a[' -> then pressing key TAB -->>GPF



CR:239647
CR Number:   239647
Product Name:   PB Enterprise
Product Component:   DW ActiveX
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 Fixed
Description
PB Version and Build: 7.x/8.x/9.0 doc

Doc: Datawindow Reference - GetChild function

Chapter 9 - Page 620 (in PB 9 doc set)

'Return Value' section

'Web ActiveX' paragraph



Comments:



The Datawindow Reference entry for the GetChild function states that with the Datawindow Web ActiveX the function returns ...

"an object that is the DataWindowChild or Report"



In reality it returns a Number which in JavaScript can only be handled as a simple number ie you cannot use it to reference dwchild properties or make dwchild function calls



This is a document error, the correct way to get a reference to a datawindowchild with the DW Web ActiveX is as follows



1) Call GetChild with the name of the column with the dddw (or report name). If there is no dwchild associated with the given column name then GetChild will return -1. If everything is OK it will return 1

For example...

window.dw_1.GetChild ("dept_id");



2) If GetChild returns 1 then call GetChildObject() (this is not documented)

GetChildObject() returns a reference to a datawindow child which can then be used in the usual way

eg

dwc = window.dw_1.GetChildObject();

ls = ldwc.Describe ("Datawindow.Table.Select");





/////A simple code sample /////////

var ls ;

var ldwc;



window.dw_1.GetChild ("dept_id");

dwc = window.dw_1.GetChildObject();

ls = ldwc.Describe ("Datawindow.Table.Select");

window.alert(ls);



CR:239648
CR Number:   239648
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 10112 13 Sep 2001 Fixed
Description
PB7.0.3/Jaguar3.6.1 C1 : SetChanges return -2 on 3rd execution without retrieve.

workaround: Use Statefull component or use retrieve.
Workaround Description
 Use Statefull component or use retrieve.



CR:239653
CR Number:   239653
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)
06 Aug 2003 Fixed
Description
Consult with development because cannot duplicate it inhouse:
Customer using a sparcstation 20 solaris 2.6 machine and getting a return code of 52 of the createinstance.



CR:239689
CR Number:   239689
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2001 Fixed
Description
PB 8 RC: Online Books Typical install fails to correctly map entries in dynatext.ini, therefore the shortcut to the Online Books from the Start menu fails.



CR:239724
CR Number:   239724
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 May 2001 Not a Bug
Description
Would be useful to get the list of usable pbm events and the PRIVATE ones. This used to be in PB 6.5 help files under the keyword: Windows messages.



CR:239725
CR Number:   239725
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7061 21 Aug 2001 Fixed
Description
When copy & paste eg. a user object function it will not paste the Throws property. Happens also with Window object level functions.



CR:239747
CR Number:   239747
Product Name:   PB Enterprise
Product Component:   AutoScript
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2001 Not a Bug
Description
When using Autoscript to finish a code statement, it is possible to change the content of the clipboard. Happens also to PB 7.



CR:239754
CR Number:   239754
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
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
Using OLE customer's application opens, edits and saves multiple Excel worksheets. Happens with both Excel 97 and 2000. Memory usage creeps up and continues to increase until an Out of Virtual Memory message is displayed. This happens regardless of whether the application disconnects or not. With the testcase depending on system tested on you may only see the increase and not the Out of Virtual Memory message.

This looks similar to CR 223241 reporting the problem using OLE and Word.

The script of uf_ole in the sample is the original way that the customer sent it to us. However I thought that possibly if an explicit disconnectobject() along with connecttonewobject() for each speadsheet would correct the problem but it does not seem to release the memory. The destroy is what returns it and this may turn out to be correct behavior.

You can comment and uncomment the script and see that the problem still exists even if there is a connectonewobject()/disconnectobject() for each spreadsheet. According to PB documentation the disconnectobject () should "Releases any object that is connected to the specified OLEObject variable." and I would assume return all memory.

It is only when the object is destroyed that the memory is returned. Although the PB documentation for Destroy
states that this is when the memory is released for the object it does not make sense that memory is not returned for closed spreadsheets.

PB Help for Destroy:

When you are finished with an object that you created, you can call DESTROY to release its memory. However, you should only call DESTROY if you are sure that the object is not referenced by any other object. PowerBuilder's garbage collection mechanism maintains a count of references to each object and destroys unreferenced objects automatically.

If this is not a bug then this should be documented more thoroughly.



CR:239760
CR Number:   239760
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0 RC 7022 10 Jul 2001 Fixed
Description
GPF in the IDE when selecting multiple controls and Shift + Double click and being in default Layout.



CR:239763
CR Number:   239763
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 Beta 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.1 08 Aug 2002 Fixed
Description
If you enable PBDebug Tracing, and check prompt before overwriting in the system options, the dbg file is overwritten each time PB is started.



CR:239767
CR Number:   239767
Product Name:   PB Enterprise
Product Component:   Install
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2001 Fixed
Description
Install ASA 7.0 from the PB8 installation CD - The InProcServer32 key is missing the DLL extension for ASAEnum



CR:239786
CR Number:   239786
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
When WindowText colour is Dark Red, datawindow checkboxes use datawindow.color (background colour) to display the checks or X's. This makes the checkboxes invisible for 2D checkboxes all the time and for 3D checkboxes invisible if background color is white.
Review Status
 04/23/2005:

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



CR:239789
CR Number:   239789
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2004 Third Party Problem
Description
The common installer checks for enough space before installing, and if it finds there is not enough, it does prompt you to change selections; however, dismissing that message box causes the install to continue so there is no opportunity to modify your selections.



PER DEVELOPMENT: This is InstallSheild default behavior and we cannot change it on our side.



CR:239800
CR Number:   239800
Product Name:   PB Enterprise
Product Component:   ORCA
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Fixed
Description
PB 8 build 6024, PB 7.03.10075 :
Pb will crash instead of giving an error message if you try to close an already closed ORCA session



CR:239802
CR Number:   239802
Product Name:   PB Enterprise
Product Component:   Install
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2001 Fixed
Description
The on-line books shortcut does not work if the path contains a space (e.g., C:\Program Files\Sybase\OnLine Books). If you try to use the shortcut, it starts a search for the EXE.

Workaround: Go to the properties for the shortcut and switch to the General tab of the Properties dialog and back again, press OK. This will place the quotes into the path and the shortcut will now work correctly.



CR:239805
CR Number:   239805
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2001 Not a Bug
Description
PB application is running a rpc stored procedure call
using a ASE database. It has 2 input parms -- integer and decimal.

The pbtrace log shows that the stored procedure is cancelling on the following:
(5ac03a0): CONNECT TO TRACE SYC Adaptive Server Enterprise:
(5ac03a0): DATABASE=ts_data
(5ac03a0): LOGID=tsmaint
(5ac03a0): DBPARM=CharSet='cp850'
(5ac03a0): SERVER=ts_sybase1192
(5ac03a0): SRV 10 #5701 Changed database context to 'ts_data'. (0 MilliSeconds) (0 MilliSeconds)
(5ac03a0): PREPARE: (0 MilliSeconds)
(5ac03a0): BEGIN TRANSACTION: (0 MilliSeconds)
(5ac03a0): EXECUTE REMOTE PROCEDURE: dbo.upd_employee2
TYPE INT
TYPE VCHAR
(5ac03a0): SRV 16 #241 Scale error during implicit conversion of DECIMAL value '5678.540' to a DECIMAL field. (0 MilliSeconds) (31 MilliSeconds)
(5ac03a0):
Error 241 (rc -1) : Scale error during implicit conversion of DECIMAL value '5678.540' to a DECIMAL field.
(5ac03a0): COMMIT: (0 MilliSeconds)
(5ac03a0): DISCONNECT: (15 MilliSeconds)
(5ac03a0): SHUTDOWN DATABASE INTERFACE: (0 MilliSeconds)

The application is initializing the decimal variable as follows:
decimal{3} ld_val = 0.000
integer li_id
long ll_ret

li_id = 100
ld_val = 5678.540
ll_ret = SQLCA.upd_employee2(li_id,ld_val)

Also tried using set arithabort numeric_truncation off in the stored procedure
and same error.



CR:239807
CR Number:   239807
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2004 Fixed
Description
Customer is having a problem trying to display data from the database using the importstring. This problem shows up only if the data has double quotes in it. For example if the customer has "K" Line America in his database if he retrieves it by using the describe function then everything is fine but if he uses the importstring the he can only see K in his datawindow column.





Workaround:

Add a space at the begining the string solved the problem.
Workaround Description
 Add a space at the beginning of the string



CR:239877
CR Number:   239877
Product Name:   PB Enterprise
Product Component:   DataBase
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.00 EBF1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2001 Fixed
Description
O84 interface does not allow to correct errors in the SQL Script Painter



CR:239879
CR Number:   239879
Product Name:   PB Enterprise
Product Component:   Generators
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 May 2001 Fixed
Description
Runtime error.. R6025 - pure virtual function call when trying to build project to deploy a COM object w instance variable.

Does not happen with PB 7.0.3 build 10077.



CR:239883
CR Number:   239883
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)
28 Sep 2001 Fixed
Description
Filtering on a datastore, and then calling GetFullState doesn't work with PBVM on Solaris.



CR:239895
CR Number:   239895
Product Name:   PB Enterprise
Product Component:   Install
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
One of the HKEY_CLASSES entries in the registry place there by online books install points to a file that does not exist in the installation. It's not clear if this has any impact on the product.

After installing online books, there is a registry entry:

HKEY_LOCAL_MACHINE\Software\Classes|\CLSID\{03793450-cb6f-11ce-b1cd-0020afd60791}\InprocServer32 that has a default value of "adinet.dll"

That DLL does not exist after the installation, however.



CR:239898
CR Number:   239898
Product Name:   PB Enterprise
Product Component:   Plug-ins
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2002 Not a Bug
Description
Datawindow plugin not displaying in Internet explorer or
Netscape.

From the registry, it appears that the plugin is registrying as
HKLM\Software\Classes\.psr Powersoft.Report.7 and application/datawindow

The mime type from the PB 8.0 online shows:
application/datawindow8.



CR:239899
CR Number:   239899
Product Name:   PB Enterprise
Product Component:   DW - Runtime
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
Customer questioning if behavior seen in all versions of PB available for testing is a but or expected behavior.
With DW controls in print preview mode with many pages. DW contains a nested report. Dragging the vertical scroll "thumb" causes the the control to go blank for several seconds, while the page counter visibly counts. There is not a page counter explicitly on the dw so this is internal processing that is occurring.

Is this expected behavior or is it a bug?



CR:239971
CR Number:   239971
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   6.5.00
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7037 26 Aug 2001 Fixed
Description
A grouped datawindow that has:
- a computed field which does a describe on a text field
- a second computed field that uses an aggregate function like avg on the first computed field
can crash when put into a composite report.

Work-around is to use a computed field instead of the text object.
This computed field can have as expression the hard coded text value of the text object, or a
global function that returns the text value based upon the current row.



CR:239974
CR Number:   239974
Product Name:   PB Enterprise
Product Component:   Install
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2001 Fixed
Description
PB8 RC1: Javascript files for WebDW caching not installed



CR:239975
CR Number:   239975
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7058 16 Aug 2001 Fixed
Description
PB Version and Build: Broke between 7.03 build 10039 (OK) and 7.03 build 10047 (crash)
Also broken in PB 8.0 build 6024
REGRESSION: A new DW which has at least 1 join and queries a table with a long table name and/or long column name will crash the dw painter if the dw preview view is open.

In PB 7.0.3.10075 -> 0x112a2cb1 memory read error @ 0x00000000 in PBVM70.DLL
In PB 8.0.6024 -> 0x115ef473 memory read error @ 0x00000000 in PBDWE80.DLL

Seems to be the length to the combined table_name.column_name which is causing this.
If the tablename is 50 chars long and the colname just 1 char - Crashes. Or...
If the tablename is 1 char long and the colname 50 chars - Crashes. Or...
If the tablename is 25 char long and the colname 25 chars - Crashes
SQL needs to access at least 2 tables. The size of the other column & table names not relevant
Overall SQL length not the cause as this can be reproduced with short SQL (just 86 characters in SQL).
Workaround Description
 Keep the preview view closed and after creating dw change SQL to use a short alias for the long col name

SELECT VeryLongTableName.VeryLongColumnName a , etc



CR:239978
CR Number:   239978
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 02 Jun 2005 EOL'd version. Not to be Fixed.
Description
Help button on "Targets - To Be Migrated" dialog does nothing



CR:239982
CR Number:   239982
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2001 Not a Bug
Description
Intermittently, the rightclicked event appears to be ignored. Customer is using the rightclicked event to begin drag mode. Application intermittently does not function properly.

NOTE: PowerBuilder Treeview implementation did change between 6.5 and 7.0, so it may be that this will not be something we can fix.



CR:239987
CR Number:   239987
Product Name:   PB Enterprise
Product Component:   DW ActiveX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2003 Fixed
Description
Activating a Wordperfect doc as OLE DB Blob, causes WP to open a documents equal to the number of rows in the table and then on a Save of the new row , wordperfect and pb will crash.





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

Sybase SQL Anywhere数据库恢复工具ReadASADB:

之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具: ReadASADB。
此工具支持ASA v5.0, v6.0, v7.0, v8.0, v9.0, v10.0, v11.0, v12.0, v16.0, v17.0等版本。
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具。
恢复Sybase SQL Anywhere的工具在国内处于领先水平。

Sybase SQL Anywhere数据库恢复工具ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具
  1. 适用于所有的SQL Anywhere版本    包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x,16.x,17.x
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集,包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

Sybase SQL Anywhere数据库恢复工具ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

Sybase SQL Anywhere数据库恢复工具ReadASADB的应用场景:

1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况;
2.误操作,包括truncate table,drop table,不正确的where条件导致的误删除等;
Sybase SQL Anywhere无法打开时,比较常见的错误是:Assertion failed。
如:
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page
7、*** ERROR *** Assertion failed: 201417 (7.0.4.3541) Invalid count or free space offset detected on a table page
8、Internal database error *** ERROR *** Assertion failed: 201425 (8.0.3.5594) Invalid count or free space offset detected on a free list page -- transaction rolled back.
9、Internal database error *** ERROR *** Assertion failed: 100702 (8.0.1.2600) Unable to modify indexes for a row referenced in rollback log -- transaction rolled back


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

Sybase ASE数据库恢复工具READSYBDEVICE:

一个不依赖数据库管理系统、直接从Sybase数据库设备文件上提取数据的业内领先的恢复工具!
能够从损坏的Sybase ASE设备文件(.dat)上提取数据的非常规恢复工具。

Sybase ASE数据库恢复工具READSYBDEVICE的主要功能:

  1. 被勒索病毒加密数据文件及备份文件情况下的恢复;
  2. 系统崩溃只剩下数据文件的情况下的恢复,甚至数据库文件不存在而只有损坏的备份文件情况下的恢复;
  3. 因断电、硬盘坏道等造成数据库文件损坏情况下的恢复;
  4. delete数据恢复、误update数据恢复、误删除表(drop)恢复、误truncate表恢复 等;
  5. 各种Sybase内部系统表损坏、索引错误的修复;
  6. master数据库损坏而无法正常运行情况下的恢复;
  7. Sybase数据库被标记为可疑,不可用等情况的恢复;
  8. Sybase数据库中数据文件内部出现坏块情况下的恢复;
  9. Sybase数据库无数据文件但有日志文件的情况下的恢复;
  10. Sybase数据库只有数据文件无任何日志文件的情况下的恢复;
  11. Sybase数据文件被误删除情况下的碎片提取恢复;
  12. 磁盘阵列上的Sybase数据库被误格式化情况下的数据库恢复;
  13. 数据库sysobjects等系统表损坏无法正常应用情况下的恢复;
  14. Sybase数据库还原数据库出现失败情况下的恢复;
  15. Sybase数据库只剩下损坏的备份文件情况下的恢复。

Sybase ASE数据库恢复工具READSYBDEVICE支持的版本:

Sybase ASE 11.0.x,11.5.x,11.9.x,12.0.x,12.5.x,15.0.x,15.5.x,15.7.x,16.0.x


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

SQL Server数据库恢复工具SQLRescue:

一个不依赖数据库管理系统、直接从SQL Server数据库文件上提取数据的业内领先的恢复工具!
能够从损坏的SQL Server数据库文件(.mdf)上提取数据的非常规恢复工具。

SQL Server数据库恢复工具SQLRescue的主要功能:

  1. 系统崩溃只剩下数据文件的情况下的恢复,即无日志文件或者日志文件损坏情况下的恢复;
  2. 断电导致数据库文件损坏情况下的恢复;
  3. 硬盘坏道造成数据库损坏情况下的恢复;
  4. 数据文件内部存在坏页情况下的恢复;
  5. 企业管理器误删除数据表记录,管理软件误删除数据表记录的恢复;
  6. 并闩锁错误、格式化、误删除后导致软件不能使用的情况;
  7. 无法读取并闩锁页sysindexes失败情况下的修复;
  8. 数据文件被误删除情况下的碎片提取恢复;
  9. 系统表损坏、索引错误、误删除数据库表、删除记录的数据找回;
  10. master数据库损坏而无法正常运行情况下的恢复;
  11. 数据文件无法附加情况下的数据恢复;
  12. 数据库被标记为可疑,质疑,不可用等情况的恢复;
  13. 数据库sysobjects等系统表损坏情况下的恢复;
  14. 数据被误(drop、delete、truncate)删除表数据的恢复,误update后的数据恢复等;
  15. 还原时报一致性错误,错误823等情况下的数据恢复,各种错误提示的数据库文件修复;
  16. 数据库被误格式化等情况下的数据库恢复;
  17. 日志收缩造成数据库损坏情况下的恢复;
  18. 仅剩损坏的备份文件情况下的恢复。

SQL Server数据库恢复工具SQLRescue技术特点:

只要SQL Server数据库的数据文件存在,我们就有办法帮您从数据文件中找回重要数据。
  1. 从数据文件中直接恢复数据
  2. 不能附加时直接恢复数据并生成新的数据库
  3. 系统表损坏的数据库修复
  4. 快速修复SQL 823错误、连接中断错误

SQL Server数据库恢复工具SQLRescue支持的版本:

Microsoft SQL Server 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017,2019。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------