提供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:365606
CR Number:   365606
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2005 Fixed
Description
DataWindow Designer: Provide Edit Source option from context menu in System Tree.



DataWindow Designer doesn't allow you to do an Edit Source directly, we should enable this option for convenience.



CR:365682
CR Number:   365682
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2005 Fixed
Description
QueryClear crashes on shared datawindow.



A datawindow is shared and set in querymode.

After a retrieve of the datawindow a crash occurs when setting DataWindow.QueryClear = "yes".



Work-around is to call sharedataoff() before the QueryClear and re-establish the sharedata afterwards.



CR:365690
CR Number:   365690
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.0 28 Sep 2004 Fixed
Description
When trying to place an SLE or static text on a window where the font is set to Tahoma size 12, the font gets set to -16 and the control height is set very small.



CR:365810
CR Number:   365810
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2004 Fixed
Description
When using the IN9 driver to connect to a informix 7 server

and you try to expand a table in the db painter, the following error will result:



SQL Error -217: Column(extended_id) not found in any table in the query

(or SLV is undefined).



CR:365917
CR Number:   365917
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.0 13 Sep 2004 Fixed
Description
When calling a stored procedure from pb 10, the following

error message will appear:





Location Services Error - Procedure

ORA-06550: line1, column 15:

PLS-00306: wrong number or types of arguments in call to 'NEWPART'

ORA-06550: line1, column 15:

PL/SQL: Statement ignored



CR:365923
CR Number:   365923
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2004 Fixed
Description
A problem with a datawindow that has columns of radio buttons or checkboxes, and if you change the color of these columns at runtime. Once you change the color if the focus is on the column changed, you are unable to click and change the radio button or check the checkbox. If you click on some other column and then come back it works OK. From then on it works OK, until you change the color again.



Verified fixed in PB 9.0.1 build 7284.



CR:365926
CR Number:   365926
Product Name:   PB Enterprise
Product Component:   Machine Code Exe Creation
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2004 Duplicate
Description
When compiling a machine code exe in the application

project, a codegen compilation error results. From the log file, the following

is listed:



CGEN: Compiling 'C:\WINNT\TEMP\a_cdap_repl.c'

CGEN: Compiling 'C:\WINNT\TEMP\cgi3h2uv.c'

CGEN: Compiling 'C:\WINNT\TEMP\cgi3h2uu.c'

C:\WINNT\TEMP\cgi3h2uu.c(935) function argument(s) do not match those in prototype

C:\WINNT\TEMP\cgi3h2uu.c(935) 'OB_OBJECT * stdcall ob_copy_rtinst( ob_this *, OB_OBJECT * )' defined in: C:\pb80\Shared\PowerBuilder\cgen\DN32T.h(44) (col 44)

C:\WINNT\TEMP\cgi3h2uu.c(935) cannot convert argument 2 defined in: C:\WINNT\TEMP\cgi3h2uu.c(935) (col 103)

C:\WINNT\TEMP\cgi3h2uu.c(935) source conversion type is "tag_OB_NARRAY * (lvalue)"

C:\WINNT\TEMP\cgi3h2uu.c(935) target conversion type is "OB_OBJECT *"



RESOLUTION: Applying fix of CR273803 to PB80 will require all the current PB80 applications to do a full rebuild to work correctly. That means all the application must do migration. That's why we haven't applied the fix to PB80. The fix is in PB 90.



CR:365941
CR Number:   365941
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2004 Fixed
Description
When connected to the in9 driver in the db painter,

pb will crash when you select edit data -> tabular or freeform for a stored procedure

that has 13 or more arguments.



CR:365950
CR Number:   365950
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Sep 2004 Fixed
Description
When creating a datawindow using a Informix 9 stored procedure

and that sp has 13 or more arguments, pb will crash as soon as you select that

sp in the datawindow wizard.



CR:365952
CR Number:   365952
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Sep 2004 Fixed
Description
When connecting to a informix7 server using the native

driver, pb will crash when you try to paste the Declare Procedure syntax into

any pb object.



CR:366045
CR Number:   366045
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2006 Fixed
Description
Wrong datas entered in HTML Generator when decimal separator is comma.



CR:366069
CR Number:   366069
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2004 Fixed
16 Jan 2005 Not a Bug
Description
korean character is broken whose type is char array at calling external function on DLL in PB10



CR:366093
CR Number:   366093
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2005 Fixed
Description
Regression with popmenu opening at the wrong position.



When in the open event of a mdi sheet a popup window is opened and closed,

then a subsequent popup menu may open at the wrong position.

After minimizing and restoring the frame window, the popup menu appears at the right position.



The problem is reproducible in PowerBuilder 9 Build 7096 and later, and also in PowerBuilder 8 and 10.



CR:366257
CR Number:   366257
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2004 Fixed
Description
The customer is importing a .srw file into an application. The window being imported has continuation characters (&) in a couple of messagebox statements. One of them is imported fine, but one has an extra blank line inserted after the continuation character. This causes a compile problem.



CR:366345
CR Number:   366345
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Windows XP
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 May 2005 Fixed
Description
PowerBuilder 9 and 10 cannot parse WSDL files containing user-derived simpleTypes.



CR:366434
CR Number:   366434
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.0 15 Oct 2004 Fixed
Description
When the PBMaxBlobSize is set to a high value, the selectblob does not work and the sqlcode and sqlerrtext don't indicate the problem.



When the PBMaxBlobSize is set high value, the pbtrace.log shows the following:

(12a5ff4): BLOB READ: COLUMN=store_data1 TABLE=store_data1 CLAUSE= from store_data1 WHERE store_key ='APDF111122223333' AND segment =0 (90 MilliSeconds)

(12a5ff4): GET AFFECTED ROWS: (0 MilliSeconds)

(12a5ff4): ^ 0 Rows Affected



When its set to 32767, the log file shows the correct results:

(1300220): BLOB READ: COLUMN=store_data1 TABLE=store_data1 CLAUSE= from store_data1 WHERE store_key ='APDF111122223333' AND segment =0 (10 MilliSeconds) LENGTH=346

(1300220): GET AFFECTED ROWS: (0 MilliSeconds)

(1300220): ^ 1 Rows Affected



Customer setting the PBMaxBlobSize to PBMaxBlobSize='2147483647' in the pbodb100.ini.

Works ok in PB 9.0.1 (build 7560).
Workaround Description
 Works ok when PBMaxBlobSize is set to 32767.



CR:366470
CR Number:   366470
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Cannot use AdoTransaction with an IBM.Data.Informix.IfxConnection only with System.Data.OleDb, but IfxConnection implements the IDbConnection interface.
Workaround Description
 use AdoTransaction with an System.Data.OleDb instead of IBM.Data.Informix.IfxConnection



CR:366487
CR Number:   366487
Product Name:   PB Enterprise
Product Component:   Workspace and Targets
Status:   Closed
OS:   Windows XP
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2004 Fixed
Description
Applying changes to deploy projects in a PB target properties does not work on XP



Workaround: run right project manualy from project painter



CR:366517
CR Number:   366517
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Need to implement the Righ to Left property in the rich text control.



CR:366619
CR Number:   366619
Product Name:   PB Enterprise
Product Component:   Target Wizards
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2005 Fixed
Description
Some PowerBuilder Wizards can not treat UNC (Universal Naming Convention) properly.
Workaround Description
 For Symptom 2, add 6 backslash signs (\\\\\\) at the beginning of line in Library and Target field.

For Symptom 1, create a target on a network computer and then add the target to the local workspace using mouse right click [Add target].



CR:366638
CR Number:   366638
Product Name:   PB Enterprise
Product Component:   Migration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2004 Fixed
Description
External function call not working after migration to PB 10.



External function declaration in PB 9.x before migration:

FUNCTION int GetNames(ref string names[]) LIBRARY "TEST.DLL"

External function declaration in PB 10 after migration:

FUNCTION int GetNames(ref string names[]) LIBRARY "TEST.DLL" alias for "GetNames;Ansi"



UpperBound is returning invalid values and data returned is also corrupted.



CR:366686
CR Number:   366686
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Nov 2004 Fixed
Description
If a resultset includes a bit datatype column (say the resultset was created in a java component, and the resultset is passed to PB), the datastore CreateFrom function to create a datastore from the resultset fails. PB should not fail, and instead create a number type column in the datawindow for the bit column. This is what happens if you create a datawindow in the painter that includes a bit column.



CR:366694
CR Number:   366694
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
If datawindow column has Text Color set to 'Window Text' and Background Color set to 'Highlight Text', running on XP using the Silver color scheme on the desktop, the fields display black on black. NOTE: Not clear that this is a bug. This should be checked for in deployment testing. It is always possible to set up colors so that fields do not display as expected upon deployment.



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:366707
CR Number:   366707
Product Name:   PB Enterprise
Product Component:   DW XML
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2004 Fixed
Description
A datawindow with a large XML template is crashing if you make almost any change to the datawindow and then save.



CR:366729
CR Number:   366729
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2004 Fixed
Description
Powerbuilder tries to load the UxTheme.dll, this is an WinXP themes DLL, whenever a datawindow object is loaded into memory. This happens even on a Win2K machine where there is no UxTheme.dll. The customer is experiencing a significant slowdown because of this, as PB seaches for the dll many times, and when it does not exist each search takes in the range of .8 to 1.2 seconds. They used a tool call BlackBox which showed that there is considerable delays because of constant lookups for this dll. The problem becomes acute if one has a Network drive in the system path.



CR:366782
CR Number:   366782
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Not a Bug
Description
If you select a column and choose the Edit Style Type Checkbox it does not appear immediately, it is necessary to close and reopen the DataWindow again for instance.



CR:366926
CR Number:   366926
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2004 Fixed
Description
DW.net: sign assemblies for datawindow.dll and datawindowinterop.dll



Wants to develop a big secured application with Datawindow .net product.

According to the .NET technology, it is possible to create signed assemblies (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconProgrammingWithAssemblies.asp)



Customer has noticed that, unlike pbdata100.dll which is signed and has a section .publickey, datawindow.dll and datawindowinterop.dll are not signed.



CR:366950
CR Number:   366950
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2009 DEFER
Description
Data type 'float' generates weid behaviour in DW HTML with comma as Decimal separator



CR:366976
CR Number:   366976
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Sep 2004 Duplicate
Description
Customer has a C++ application, using PBNI, application accesses PB window throough C++ application. In open event of window, customer retrieves data in datawindow and inserts row. Customer thinks application crashes after he calls insertrow function, crash is random and he has provided a custom dump file that he has created.



CR:366998
CR Number:   366998
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11.0 18 May 2005 Fixed
08 Nov 2005 Fixed
Description
Enhancement Request: Customer has a datawindow for which he has specified alias names for the tables in the dw sql syntax. He wants to have a option/property in the tool where he can go and see the table and alias names so that he can manipulate the where clause when using the dw in query mode. Right now he has to parse the sql himself to see the table aliases.



CR:367007
CR Number:   367007
Product Name:   PB Enterprise
Product Component:   DB JDBC
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 28 Oct 2004 Fixed
Description
Everytime a jdbc connection is made in EAServer, the

following is written to the Jaguar.log:



Java VM loaded. Version: 1.4.1_03, Vendor: Sun Microsystems Inc."



If you doing alot of connections, it will create alot of output. The java vm message

appears whether a connection cache is used or not.



CR:367043
CR Number:   367043
Product Name:   PB Enterprise
Product Component:   JSP 4GL
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2004 Fixed
23 Nov 2010 Presently Not Targeted For Any Future Release Of This Product
Description
Customer has application that use PB JSP variable.

It is reported that PB JSP 4GL get problem on handling the variables / parameter,

as the variable content of the first JSP session always be overwritten by another session.



CR:367197
CR Number:   367197
Product Name:   PB Enterprise
Product Component:   EJB Client
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2004 Fixed
Description
Java class, using EJBClient proxy wizard, customer created java proxy in PB. He accesses method in Java class thru PB. Even after the method is completed PB app doesn't release the memory used.



CR:367203
CR Number:   367203
Product Name:   PocketBuilder
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows 2000
Original Version:   2.0 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2004 Fixed
Description
When running an application from the development environment, response windows do not show the "OK" (or "X") button in the upper right corner of the window. They do show (as an "OK") when running on the device.



CR:367216
CR Number:   367216
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Closed
OS:   Pocket PC 2002
Original Version:   2.0 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
646 27 Oct 2004 Fixed
Description
Filtering when column is of type number and contains a large number example (900002313) does not work properly. Row is not filtered. Smaller numbers filter properly. Works correctly in development environment.
Workaround Description
 This issue comes from losing numeric precision in the mantissa portion of a floating point number. One workaround would be to use a LONG data type.



CR:367217
CR Number:   367217
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2004 Fixed
Description
CR#338302 introduced a new function ( pageabs() ) to get the absolute page number of a grouped datawindow with ResetPageCount flag set. This enabled a user to print a specific page range of a report. The function works for simple datawindows, however it does not give the correct absolute page number for more complex datawindows.



CR:367239
CR Number:   367239
Product Name:   PB Enterprise
Product Component:   WT - System Tree
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enh Req: Ability to select multiple objects from multiple PBLs in SystemTree



CR:367294
CR Number:   367294
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Dec 2004 Duplicate
Description
Random but very often crashes in development environment while attempting to save window objects after having altered event/function scripts.



CR:367318
CR Number:   367318
Product Name:   PB Enterprise
Product Component:   DW XML
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2004 Duplicate
Description
The XML encoding property is not set in the DW attribute at Runtime.



CR:367404
CR Number:   367404
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 19 Sep 2005 Fixed
Description
Problem with checkbox editstyle in N-up DWs if visibility is controlled with an expression like (if columnname[0]= x, 1, 0). This cuases to show up all checkboxes in th eright way but the last checkboxes in the row could be not checked or unchecked anymore with the mouse. looks like they are protected somehow.



No workaround



CR:367432
CR Number:   367432
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.3 05 Dec 2004 Fixed
Description
Regression: When resetting a date or currency EditMask on a window by setting the value to an empty string, the insertion point remains where it was prior, usually at the end of the mask, instead of resetting to position 1. Doing the same in PB 8.0.4 resets the insertion point to 1.



As a workaround until this is fixed you can set the insertion point in an editmask to the first position with this code:

em_1.SelectText ( 1, 0 )

See the help on SelectText for more details.
Workaround Description
 As a workaround until this is fixed you can set the insertion point in an editmask to the first position with this code:

em_1.SelectText ( 1, 0 )

See the help on SelectText for more details.



CR:367433
CR Number:   367433
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2004 Fixed
Description
Document limitation of 1000 columns per DataWindow.



There is a hard-coded limit of 1000 columns per datawindow as evidenced by the following constant in the dw.h include file:



// Restrict maximum number of columns to ensure consistent performance.

// Should look at this number again at some point.

#define DW_MAXIMUM_COLUMNS 1000





This limitation should be documented.



CR:367521
CR Number:   367521
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2004 Fixed
Description
Retrieving twice into the same Crosstab datawindow forces the summation rows to all display the same value. On first retrieve sum values are correct.



Workaround: reassign the dataobject to the datawindow or datastore before a 2nd retrieve

dw_1.dataobject = "d_test"

dw_1.settransobject(sqlca)

dw_1.retrieve()



CR:367532
CR Number:   367532
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When a datawindow has a taborder of 0, getitem

doesn't work. This behavior is different than with a datawindow. Getitem does

return the value when the taborder is 0 for a regular dw.



Customer would like to seem the same behavior on a web datawindow that is now

for a regular dw and that is getitem works when the taborder is 0.

When taborder is 0 the following is generated:

<SPAN CLASS=dwClient92C STYLE="position:absolute; left:2.803in; top:0.000in; width:1.980in" onClick="{return dwClient.itemClicked(125,-1,'address');}" >91 Washington Street</SPAN>



When taborder is greater than 0, the following is generated:

<INPUT TYPE="text" NAME="address_125" SIZE=30 MAXLENGTH=35 VALUE="91 Washington Street" CLASS=dwClient629 TABINDEX=629 STYLE="position:absolute; left:2.803in; top:0.000in; width:1.980in" READONLY onFocus="{dwClient.itemGainFocus(125,4,this,dwClient.gobs.address); dwClient.selectControlContent(this);}" onClick="{var ret; ret= dwClient.itemClicked(125,4,'address'); return ret;}" onChange="{this.bChanged = true;}" onkeypress="DW_EditKeyPressed(-1)" onBlur="{dwClient.itemLoseFocus (this);}">



The getitem function generated from the webdw:

function HTDW_GetItem(row, col)

{

var result;

var colNum = this.getColNum(col);

var rowObj = this.rows[row-1];



if (colNum == -1 ||

(rowObj + "" == "undefined") ||

rowObj[colNum] + "" == "undefined")

result = -1;

else

result = rowObj[colNum];



return result;

}



CR:367571
CR Number:   367571
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2009 DEFER
Description
A report with a blob column works fine and retrieves as expected. But when this report is placed in a composite report and a getchild is done to get a reference to this report, it takes 2 retrieves to get data in the report. The first retrieve appears to do nothing, it returns a 0 and no rows are displayed. Do a second retrieve and this time it works as expected.



CR:367572
CR Number:   367572
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer requests that the SCC icons be made somewhat larger and more distinguishable. The user's complain about having difficulty distinguishing between a "+" and a dot.



CR:367651
CR Number:   367651
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Customer calling PB components on EAServer and also

using SQL Server and IIS on the same machine.



Machine is a quad processor with 4GB of RAM.
Review Status
 4/22/2005

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



CR:367677
CR Number:   367677
Product Name:   PB Enterprise
Product Component:   Inheritance
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2005 Presently Not Targeted For Any Future Release Of This Product
Description
PowerBuilder allows a typed variable to be set using an unrelated class if the classes are not auto-instantiating.



CR:367748
CR Number:   367748
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2004 Fixed
Description
When saving a stored procedure in the IDE that

has a Declare statement with output parameters defined as follows will cause

the error of 'Database C0038: Can't use the OUTPUT option when passing a constant to a

stored procedure'.



Declare deptproc Procedure For deptroster

@rc = deptroster,

@deptno = :lDeptno,

@totsal = :dTotSal output,

@avgsal = :dAvgSal output using sqlca;



CR:367770
CR Number:   367770
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2004 Fixed
Description
When customer generates and HTML datawindow from PowerBuilder 8.0.4, the appearance of an extra blank column shows up on the right side of the report. This was not present in PB 8.0.1.



CR:367879
CR Number:   367879
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   Windows XP
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
In PowerBuilder 9 the facename must match exactly when calling the function PrintDefineFont.



For example, the following will not select the desired font:



PrintDefineFont(Job, 1, "Courier 10Cpi", -18, 400, Default!, Decorative!, FALSE, FALSE)





The following does select the desired font (10cpi in lower case):



PrintDefineFont(Job, 1, "Courier 10cpi", -18, 400, Default!, Decorative!, FALSE, FALSE)



CR:367883
CR Number:   367883
Product Name:   PB Enterprise
Product Component:   DW Graph
Status:   Closed
OS:   Windows XP
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 17 Nov 2004 Fixed
Description
When printing a datawindow graph to PDF or color printer then the markers are printed in black instead of color.



CR:367918
CR Number:   367918
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Opensheet Original! size issue with scrollbars



CR:367938
CR Number:   367938
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 09 Oct 2004 Fixed
Description
When connected to an ASA 9.0 or ASA 8.0 database via OLE DB, there are problems using a column of type long binary. You get an error trying to edit the table in the database painter, and you are unable to use UPDATEBLOB in script to populate the column. When connected to the very same database via ODBC, there are no problems.



CR:368012
CR Number:   368012
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2004 Fixed
Description
If you call CrosstabDialog on a datawindow not associated with a connection object, the dialog doesn't appear. As this behavior is seen in all versions of PB tested it appears to be expected behavior that is not currently documented. Behavior is also seen in DW.NET



CR:368047
CR Number:   368047
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2005 Fixed
Description
This is a regression in both 8.0.4 and 9.0.1. It used to be that if you had the row focus indicator (the hand) displayed, and you click elsewhere in the datawindow but not on a row, the hand stayed displayed on the current row, and the current row stayed the same as the last current row. But now in both 8.0.4 and 9.0.1 latest builds, if you have a current row and you click in the header for example, the current row goes to 0, the rowfocuschanging and rowfocuschanged events fire, and the focus indicator disappears.



In 8.0 build 10691 and prior it had the old behavior as it did in 9.0.1 build 7196 and prior. But shortly after those builds the behavior changed.



CR:368097
CR Number:   368097
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2004 Workaround
Description
Can't scroll in an edit mask when number size wider than the control width



CR:368118
CR Number:   368118
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.2.1 30 May 2007 Fixed
Description
When procedure is described in to the staging area, DESCRIBE SQLSA INTO SQLDA, results in ORA-24333.



no workaround



CR:368159
CR Number:   368159
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2005 Fixed
Description
If you have a dw that has rows with a 3d checkbox column, and you modify the 3d property of the checkbox with a dw Modify statement, the row in the dw that had focus, no longer has focus, in fact no row has focus. If you tab into the dw you will tab right out to the next control in the window tab order.



By contrast, if you modify the text property of the same checkbox column, the row that had focus, still has focus after the modify, and when you tab into the datawindow, it goes to the first column in that row and tabs from column to column in the dw.



CR:368219
CR Number:   368219
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2004 Not a Bug
13 Dec 2004 Fixed
Description
Has a column with an editmask with format containing ';' and alignment set to right. When using BackSpace or DEL keys, it gives a weird behaviour and corrupts data. Same problem with a control edit mask(See Repro).

Could be linked to CR368097.



CR:368258
CR Number:   368258
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 18 Apr 2005 Fixed
Description
When saving a large number of rows of data to an Excel8!

file and then you try to open up the *.xls file, no data shows up in Excel.



If you try to open up the file in PB 9.0.2, you get a memory error. In PB 10,

it opens with no data inside. Works ok using Excel5!.



Save problem when trying to save to Excel8 from the datawindow or database painter.

In the datawindow painter, if you select File/Save Rows As and save to excel8, when

you try to open it no data shows up.



CR:368346
CR Number:   368346
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.0 09 Nov 2004 Fixed
Description
What is the max length of a datawindow object name? Documentation would indicate 40, but other areas of the painter and peeks at ths source code see a limit of 49 or 50. The maximum should be consistent through out PB and enforced, not allowing any changes to dw object names to exceed the limit. Another problem is that you can enter a valid column name of 40 chracters, but then PB names the header the same name and appends 2 more characters '_t' to it making the header name 42 characters which exceeds the limit.



CR:368364
CR Number:   368364
Product Name:   PocketBuilder
Product Component:   DB Painter
Status:   Closed
OS:   Windows 2000
Original Version:   2.0 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
649 27 Oct 2004 Fixed
Description
Run the Following SQL Select Statement in the ISQL pain of the PocketBuilder Database Painter. PocketBuilder will crash.



select convert(varchar(2),datepart(MM,getdate())) + substring('00',1,2 - length(convert(varchar(2),datepart(DD,getdate()))))+ convert(varchar(2),datepart(DD,getdate()));



CR:368380
CR Number:   368380
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Customer is using a dw with required columns. It is using sharedata, and the application datastore is the primary dw. They are also using the PFC of_SetReqColumn(True) in the constructor event of the datawindow. This service allows users to Tab/Click out of Required fields without entering any data.



The problem they have is that under certain conditions, because the datastore is primary and of_SetReqColumn does not effect the datastore, the dw focus can become "stuck" in a field with no error message and the subsequent attempt to sort fails.



There are a number of workarounds depending upon the full implementation. The simplest workaround is to use the datastore as the secondary and the datawindow as the primary datasource when using ShareData in combination with Required fields and the of_SetReqColumn method. In this customer's case, that workaround is unacceptable.



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:368482
CR Number:   368482
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2004 Fixed
Description
When running a application that connects to the

Informix 9 driver, pb will crash with an access violation in the pbshr100.dll.



CR:368541
CR Number:   368541
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Open
OS:   Windows XP
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PowerBuilder 10 and deploying and exposing a PowerBuilder nonvisual object as a WebService.

To get the actual argument names of a Webservice in the resulting wsdl requires the following server property to be set:



com.sybase.jaguar.server.jvm.options=-Djava.protocol.handler.pkgs=com.sybase.jaguar.net,-DSERVER_STUBS_DEBUG=true



CR:368582
CR Number:   368582
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2005 Fixed
14 Aug 2005 Fixed
Description
Using ASE 12.5. The customer has datawindows with nested outer joins, that get the error "Select error: Tables 'xx' and 'yy' have the same exposed names. Use correlation names to distinguish them". This is a known issue with databases that support ANSI SQL-92 syntax. There is a dbparm, ojsyntax that can be set to eliminate this error. But this dbparm is not available for SYC (ASE). But it is possible to set the dbparm ojsyntax in script (OJSyntax = 'PB') for SYC connections, and the problem goes away when running in the IDE or an exe when this is done. If this is so why is the ojsyntax dbparm not available in the SYC connection profile? Other db profiles have a dropdown to select "PB" or "ANSI".



CR:368630
CR Number:   368630
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2009 Fixed
Description
Customer is encountering a regression in PB 10.0_5046, with GPF when tabbing in DW that has taborders=0. There was no problem in PB 10.0_4510. Believe this regression may be due to fix to CR365350.



CR:368637
CR Number:   368637
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2005 Fixed
Description
Groupboxes do not displaying correct textcolor on XP Operating System when running an exe built using the New Visual Style Controls. They show up in other Windows operating systems, and they show up in XP if you don't select the New Visual Style Controls when building the exe.



CR:368660
CR Number:   368660
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2007 Not a Bug
Description
On XP machine, when she runs her application in development mode, she can't see Lowered Style border. Similar to CR 360980 but this problem is when running app in IDE.



The solution for the problem is to switch to Windows Classic View through Control panel.



Customer does not want to have to alter her control panel settings in order to get the Lowered borders to show up when running from the IDE. She has used the solution of deselecting "New Visual Style Control" in the project painter for her Executable. She would like a better solution for running within the development environment.



CR:368724
CR Number:   368724
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2004 Fixed
Description
Using Web Service Proxy Wizard, it doesn't create structure of type <choice> correctly. Also affects a function using it.



Workaround: export proxy and change the function manualy and import it again. As well complete the empty structure manualy.



CR:368726
CR Number:   368726
Product Name:   PB Enterprise
Product Component:   Table Painter
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When a column of a table is created via ISQL eg. create table T_ASA (C1 int); comment on column T_ASA.C1 is 'C1_Comment'; the comment cannot be seen as a property of the column. The field is empty.



CR:368734
CR Number:   368734
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
When running a dw in PB10 that has an OCX control inside the OCX does not display. Happens with several calendar controls.



Inconsitant behavior in PB9:

In PB9 OLE control (mscal.ocx) inside of a datawindow can display a 'ghost' image on the window, where it has been placed onto. PB will crash if user clicks on 'ghost' image.
Workaround Description
 Try using either another OCX (for PB9) or try applying the PFC dropdowncalendar service.



CR:368783
CR Number:   368783
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like to be able to use the System.Windows.Forms.MonthCalendar control in Visual Studio.NET in a similar way as one can use PFCs u_calendar object.



Functionality would include a date column appearing to be a dropdown and when one clicks on the dropdown it opens the Microsoft control positioned right over the date column.



CR:368844
CR Number:   368844
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Fixed
Description
A Web service running on WebSphere (app server here might not be significant) returns an array of structures with 16 elements each. When the service is deployed as a document-style service, PowerBuilder interprets a returned array of one element as having 16 elements. When the service is deployed as a RPC-style service, PowerBuilder interprets the returned array value correctly.



CR:368848
CR Number:   368848
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2004 Fixed
Description
Cannot execute ASE extended stored procedures on HP.



CR:368957
CR Number:   368957
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 11 May 2005 Fixed
16 Dec 2004 Fixed
Description
Computed field expressions execute on mouseover in the dw in preview or at runtime in XP.



CR:368959
CR Number:   368959
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2004 Fixed
Description
When HALT CLOSE is called, destructor events of user objects are not fired.



CR:368990
CR Number:   368990
Product Name:   PB Enterprise
Product Component:   EJB Client
Status:   Closed
OS:   Windows XP
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2005 Fixed
Description
With longer java class names ejb2pb90 generates proxies that can not be imported because the object names are too long.



CR:369049
CR Number:   369049
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2005 Not a Bug
Description
PB 9.0.1_7275 regression: Currentrow(), GetRow() returning (different) values on protected rows.



CR:369069
CR Number:   369069
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2005 DEFER
15 Apr 2005 DEFER
Description
When JSP calling PB component, easerver will randomly disappear.



No errors in Jaguar.log file.



The user dump provided shows:

Stack overflow - code c0000fd

jvm!JVM_FindSignal





Customer is using jdk 1.4.2 hotspot (mixed mode).



CR:369161
CR Number:   369161
Product Name:   PB Enterprise
Product Component:   Function Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2004 Fixed
Description
C0031 Syntax error when saving function object for 2nd time

Tested and reproduced with PB 9.0.1 7204, 7236 and 7275

Works fine with PB 9.0 with no EBFs
Workaround Description
 Use PB 9.0 with no EBFs.



CR:369216
CR Number:   369216
Product Name:   PB Enterprise
Product Component:   MTS Integration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2007 Not a Bug
Description
ONLY on Windows NT4! COM/MTS component on NT4 which was working in PB7 but does not now work in after migration to PB9. Could be related to CR 348334.



Workaround: Migrate to Windows 2000 or higher



CR:369256
CR Number:   369256
Product Name:   PocketBuilder
Product Component:   DB Synchronization
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   1.5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 Beta
Description
With Ultralite, if you omit a list of publications, the ULConn->Synchronize() method should sync all of the publications defined in the UL database. However, the parsePublications() method in PKUL915U.DLL returns a -280 PUBLICATION NOT FOUND error and aborts the sync request.



Instead, it should allow a blank list of publications and return a ul_publication_mask of zero. -280 will still be returned if the user explicitly requests a publication that is not found.
Target Version
 2.0 Beta



CR:369287
CR Number:   369287
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 7516 17 Jan 2005 Fixed
04 Jul 2005 Fixed
Description
Add to source control is much slower in PB9 than PB8. Also consumes more memory.

The problem increases exponentially as the number of objects to add increases. Thus, if you try to add an entire target with 10+ PBLs, you will see noticable degradation. Add a target with 100 PBLs and you could hang forever or consume all available memory.



The performance problem is due to an error handling routine called CreateValidEnum() that was introduced in PB9 development. It tries to make sure that the .PBG file entries that are added only include objects that were successfully added to source control. A more efficient technique is needed.
Workaround Description
 Instead of adding the contents of the entire target through one SccAdd request, limit each Add request to one PBL. The problem only manifests with large numbers of objects.



CR:369324
CR Number:   369324
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2005 Fixed
Description
When debugging for example an ejb client app, the returned any value is shown as NULL for its value in the local objects pane, although it has values.
Workaround Description
 Only further assigning the any to a variable of the corresponding type allows checking the values in the debugger.



CR:369345
CR Number:   369345
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2005 Consult Complete
02 Mar 2005 Fixed
Description
Calling SetChanges for a second time on a datawindow results in a -2 error code; however, that seems to happen only when the datawindow had previous changes made to it.



CR:369379
CR Number:   369379
Product Name:   PB Enterprise
Product Component:   Language - Compiler
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like to be able from a computed field to reference computed fields on other rows.



CR:369402
CR Number:   369402
Product Name:   PB Enterprise
Product Component:   DW.Net
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like to be able to let users download PBD used in Datawindow .NET from webserver along with the application. Specific request is to be able to use LoadFrom( URL) to run the application



CR:369472
CR Number:   369472
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2004 Fixed
Description
Placing a horizontal line in a GRID DataWindow column does not anchor the line to the column it is in. It seems to anchor to the right most GRID column for resizing but does not move when the columns are re-ordered. It also does not resize unless it is placed in the first or second column. Regardless of the placement of the line, if the columns are reordered, the line does not "stick" to the column in which it was placed.



CR:369475
CR Number:   369475
Product Name:   PB Enterprise
Product Component:   MAPI
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Feb 2005 Fixed
Description
MailLogon seems to be broken in PB10. It returns a return code of mailReturnFailure! , which is not documented. The exact same code works in PB 9.



CR:369489
CR Number:   369489
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When Orcascript "OUTOFDATE EXCLUDE_CHECKOUT" options are used to refresh a Perforce target, the processing is inefficient in PB9. Assume 1000 objects in the target, and SccMaxArraySize=500.



EXCLUDE_CHECKOUT processing will issue two SccQueryInfo calls with an array of 500 file names.

Perforce OUTOFDATE processing also needs the SCC_STATUS_OUTOFDATE flag setting from SccQueryInfo. However, instead of saving the status indicators from the EXCLUDE_CHECKOUT request, PB9 must re-issues 1000 SccQueryInfo requests with array size of 1. This adds several minutes to time needed to complete the job.



This is fixed in PB10 and PocketBuilder 1.5.2. This CR documents the fact that the problem exists in PB9 and a customer has reported the problem on the newsgroup.
Review Status
 Worth considering for PB9 backpatch - mikecobb.
Workaround Description
 Upgrade to PB10 is only remedy. IMPORTONLY OUTOFDATE would solve the problem, but that's not available in PB9 either.



CR:369567
CR Number:   369567
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Dec 2004 Fixed
Description
Description of Problem: When calling a publically available webservice (wsdl location at http://greg.froh.ca/fun/random_bushism/soap/?wsdl) with PB soapclient, an error is received calling a service function: Error: Could not find element by name: return

The log however (soaplog), shows the returned values ok.
Workaround Description
 We are generating a wrong proxy object, ie. the line where the function is declared: the return needs to be exchanged with the RandomBushism.



Before:

forward prototypes

public:

function tns__RandomBushism getRandomBushism () alias for "getRandomBushism() return tns:RandomBushism return@urn:RandomBushism@urn:RandomBushism#bushism#getRandomBushism"

end prototypes



Changed:

forward prototypes

public:

function tns__RandomBushism getRandomBushism () alias for "getRandomBushism() return tns:RandomBushism RandomBushism@urn:RandomBushism@urn:RandomBushism#bushism#getRandomBushism"

end prototypes



So basically export the originally generated proxy object, and just exchange the function declaration in an editor, then just reimport the source into the pbl.



CR:369586
CR Number:   369586
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2004 Not a Bug
Description
Application creates tab pages and user objects dynamically and has code which retrieves datawindow with datawindowChild. The application crashes consistently while doing this, but crashes at a different location everytime. Request analysis from engineering.



CR:369669
CR Number:   369669
Product Name:   PB Enterprise
Product Component:   Menu Painter
Status:   Closed
OS:   Windows XP
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Apr 2005 Fixed
Description
When use Copy & Paste or Drag & Drop on a brach of submenu items,

PowerBuilder will incorrectly attach the submenu branch.

From observeration, wrong order and miss menu item may occur.



CR:369696
CR Number:   369696
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2004 Fixed
Description
Clarify documentation when using saveas to save to PDF,

that the Distill method is not supported on unix.



The documentation describes Distill and XSL-FO. It mentions the following:

The XSL-FO option provides a platform-independent solution and offers the possibility of customizing the saved PDF file and printing it directly to a printer. Saving as PDF using XSL-FO is particularly useful for printing DataWindow objects in EAServer on a UNIX operating system.

------



It probably should just mention that Distill is not supported on unix.



CR:369758
CR Number:   369758
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2004 Fixed
Description
Input data may be inserted into the wrong position on editmask control if the edit field has a value and a digit of the value has been highlighted by dragging the mouse.



CR:369783
CR Number:   369783
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Dec 2004 Consult Complete
Description
ActiveX created with AXBridge (provided by Sun) from a Java Bean failed to save.

-> Save of OLE binary information failed. Object must be resaved to preserve it.



No workaround



CR:369792
CR Number:   369792
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   10.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2005 Fixed
Description
Customer is using Window-Eyes with PB application that provides blind users access to Windows based computers by speaking the contents of the computer's screen.

Getting error:

"PowerBuilder Accessibility Error" "Error loading library. Please check whether PowerBuilder Accessibility library can be located in the path."



This was solved by deploying PBACC100.DLL to the deployment machine. I do not find PBACC100.DLL listed as a deployment dll in the documentation.



CR:369817
CR Number:   369817
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Dec 2004 Fixed
Description
Web Service Proxy can not be generated for a wsdl file.



Generates an error: The data type, 'gYear', is not supported.





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

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。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------