远程Sybase数据库技术支持,联系手机:13811580958,QQ:289965371!

 

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

如有问题,请联系我!

QQ :289965371 点击这里给我发消息
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

CR:694806
CR Number:   694806
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2012 Presently Not Targeted For Any Future Release Of This Product
Description
Cannot consume an HTTPS web service (EasySoap engine) which uploads an XML file whose size exceeds 1 200 000 bytes.

Error returned is : "Error writing to secure socket, expected to write 1460 bytes, wrote -1 bytes"



CR:695171
CR Number:   695171
Product Name:   PB Enterprise
Product Component:   WPF DW Painter
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2012 Fixed
Description
Case statement can't pass validation testing in DW Expression dialog.

This issue exists already in PB12.1, and needs to be fixed there as well.



CR:695563
CR Number:   695563
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ScrollToRow() does not work in ItemChanged event of a DataWindow object.
Workaround Description
 Call ScrollToRow() twice or post a user-defined event from ItemChanged event and call ScrollToRow() in the user-defined event.



CR:695756
CR Number:   695756
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2012 Fixed
21 May 2012 Fixed
Description
Excel12! format results in unreadable content for a DataWindow datetime column, when the regional settings are set to have a comma , as decimal seperator.



CR:695791
CR Number:   695791
Product Name:   PB Enterprise
Product Component:   WCF
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2012 Fixed
Description
ustomer has a WSE webservice that includes WSE security headers that he would like to call using a PB 12.5 NET WCF Client Proxy. Although WCF has username and password, these are not the same as the WSE security header. Can this be done?



CR:695802
CR Number:   695802
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2012 Consult Complete
Description
Engineering Consult - Customer is having stability issues and crashes with his webform app and has turned on tracing and is seeing exceptions written to the pbtrace.log. The application appears to be working properly and he has resolved some of the errors but he is asking us if these exceptions and/or writing them to the log could be a source of the stability issues.



One such exception he sees frequently is the following:



Exception Type: Sybase.DataWindow.InvalidExpressionException

Exception Message: Sybase.DataWindow.InvalidExpressionException: FindRow had an invalid expression, Expression is : name = Visor

at acy.a(IntPtr A_0, String A_1, Int32 A_2, Int32 A_3)

at Sybase.DataWindow.DataWindowChild.FindRow(String Expression, Int32 BeginRow, Int32 EndRow)

at Sybase.PowerBuilder.Web.WebDataWindow.a(Int32 A_0, Int32 A_1, String A_2, String A_3, Boolean& A_4, Boolean& A_5, Boolean& A_6, Boolean& A_7, String A_8)

Exception Source: Sybase.PowerBuilder.DataWindow.Win

Exception StackTrace: at acy.a(IntPtr A_0, String A_1, Int32 A_2, Int32 A_3)

at Sybase.DataWindow.DataWindowChild.FindRow(String Expression, Int32 BeginRow, Int32 EndRow)



Question is whether or not these exceptions have any effect on stability and/or memory issues and if undetected could they be contributing to crashes.



CR:696073
CR Number:   696073
Product Name:   PB Enterprise
Product Component:   PB.NET Assembly Deployment
Status:   Open
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Trying to run a WPF .NET 12.5 application from a network drive gave the error:



An unhandled exception of type 'System.IO.FileLoadException' occurred in mscorlib.dll

Additional information: Could not load file or assembly



The executable was build with the option 'Create resource-only assembly on executable'

on the assemblies tab of the project



The issue is due to the .NET security model that has been changed with Framework 4

that by default disallows this operation.



Work-around:



Manually add the following within the <configuration> section of the

application.exe.config file next to the application.exe:



<configuration>



<runtime>

<loadFromRemoteSources enabled="true" />

</runtime>



</configuration>



However each time the application is rebuild the .config file will also be overwritten

and the edit change needs to be re-done.



CR:696083
CR Number:   696083
Product Name:   PB Enterprise
Product Component:   Menu Painter
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request to support menu icons for menu items with submenus like

for example in the FireFox bookmark menu.



CR:696744
CR Number:   696744
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 May 2012 Consult Complete
Description
Performance problem calling a WCF web service with serialization. How to take advantage of the assembly generated by sgen.exe in PowerBuilder ?



CR:696922
CR Number:   696922
Product Name:   PB Enterprise
Product Component:   WPF DW Painter
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Feb 2012 Fixed
Description
With PB 12.5 .NET if you select multiple objects/olumns in the datawindow painter and attempting to move them all at once, it does not work well. It seems as though if you move the group to an edge and you go too far, it still keeps the objects moving independently and not as a group. You end up with them superimposed on one another. This makes it hard to work with complex datawindows unless you move one object at a time. Customer reported giving up and having to start over again many times. Undo works but still frustrating to work in the painter and move several objects at once.



In Classic, if you attempt to move a group past the edge, it stops the entire group and seems to treat all selected objects as a whole.



CR:697058
CR Number:   697058
Product Name:   PB Enterprise
Product Component:   WPF Runtime
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Feb 2012 Not a Bug
Description
Customer is trying to use a custom .xaml skin file at the application level and it is not working. When the custom .xaml file is applied to individual controls, they work but customer believes he should be able to use his custom .xaml file at the application level.



From the doc I see the following which says that custom skins can be used on applications.



At design time, you can select system-defined and custom skins for PowerBuilder .NET applications and individual visual controls. You can also allow customers to change skins on applications and controls at runtime.



CR:697060
CR Number:   697060
Product Name:   PB Enterprise
Product Component:   Rich Text
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Feb 2012 Fixed
Description
In PB 12.5 the RTE print margins are slightly different from the PB 11.5 RTE. It looks like the whole document was shifted slightly down and to the right. This customer puts text right to the limit of the margins and this change affects the look of his printed docs. Also one character is now truncated on the right edge in the test case.



CR:697255
CR Number:   697255
Product Name:   PB Enterprise
Product Component:   WPF Migration
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Cust has moved a large application from PB 12.0 build 5530 to PB .Net 12.5 build 2511.

He is now facing issues regarding shared code and mainly building times. We would need a best practices guide on how to increase compilation speed/building times.



CR:697735
CR Number:   697735
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2012 Fixed
Description
Customer has crosstab datawindows that at times return no rows. In PB 10.5.2, if they then used GetFullState on these datawindows it worked and returned 0 for the return code. In recent versions including PB 12.5 that they are migrating to, GetFullState on a crosstab datawindow with no rows returned, returns a -1. Tabular datawindows with no rows returned still returns a 0 when using GetFullState.



CR:697748
CR Number:   697748
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Feb 2012 Fixed
Description
Customer has a XLSM Excel sheet that he is loading into an ole object from a file. If at this point he activates it offsite, the xlsm file works as expected and displays correctly.



If the customer saves the objectdata to a blob and then tries to reload it to the control, it appears corrupted and once activated offsite either freezes or crashes the application.



Simple xls files work as expected both initially and when saved to a blob and reloaded.



CR 688113 might be related but workaround is not applicable.



CR:697765
CR Number:   697765
Product Name:   PB Enterprise
Product Component:   PB.NET DW
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Feb 2012 Fixed
Description
When a datawindow is first built from a table, which

has an owner name prefix to the table name, the update works fine. If the

column update properties are changed via the update properties dialogue, the

update then fails as it can't find the table since the

table owner name prefix is lost.



Only a problem in the .NET version of the product.



For example, the datawindow source code is:

retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"tsmaint.country~" ) COLUMN(NAME=~"tsmaint.country.objectid~") COLUMN(NAME=~"tsmaint.country.objectversion~") COLUMN(NAME=~"tsmaint.country.country~") COLUMN(NAME=~"tsmaint.country.lastupdated~") COLUMN(NAME=~"tsmaint.country.lastupdatedby~") COLUMN(NAME=~"tsmaint.country.created~"))" update="tsmaint.country" updatewhere=1 )



After a change is made via the update properties dialog, the value of the dw source is:

retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"tsmaint.country~" ) COLUMN(NAME=~"tsmaint.country.objectid~") COLUMN(NAME=~"tsmaint.country.objectversion~") COLUMN(NAME=~"tsmaint.country.country~") COLUMN(NAME=~"tsmaint.country.lastupdated~") COLUMN(NAME=~"tsmaint.country.lastupdatedby~") COLUMN(NAME=~"tsmaint.country.created~"))" update="country" updatewhere=1 )





The update="tsmaint.country" changes to update="country" causing the update to fail.



CR:697893
CR Number:   697893
Product Name:   PB Enterprise
Product Component:   DW Rich Text
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RTF datawindow, right edge of text block is truncated after migration from PB 11.5 to PB 12.5. In PB 12.0 or 12.1 it shows also correctly.



CR:698004
CR Number:   698004
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2012 Not a Bug
Description
"New Page on Group Break" option set as group of DataWindow does not work on DotNet WebForm.



CR:698205
CR Number:   698205
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Open
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If it exists, PB will open the browser indicated in in HKEY_CURRENT_USER\Software\Classes\.htm when the user clicks a StaticHyperlink control.

PB should not be using this key anymore and that Microsoft is not maintaining this key.

PB should use other way of determining what is the default browser on the system.



CR:698220
CR Number:   698220
Product Name:   PB Enterprise
Product Component:   Shared Objects
Status:   Closed
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.1 18 Apr 2012 Fixed
Description
Application using SharedObjectRegister/SharedObjectGet for multithreaded behaviour hangs when compiled to machine code.

The problem only occurs when instantiating a number of shared objects in an array.



CR:698232
CR Number:   698232
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When I have a nested report that takes arguments, PB will not prompt to save changes after I modify the argument to the nested report using the ... expression button. Close the painter making no other changes and it never prompts to Save Changes and the changed argument is lost.



CR:698454
CR Number:   698454
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2012 Fixed
Description
PowerBuilder incorrectly handles an output parameter in "%type" format returned from Oracle if NLS_Charset is 'JA16SJIS'.
Workaround Description
 Specify varchar2 as the data type of the output parameter.



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

create or replace package pack7 is

procedure proc7a(as_1 out varchar2);

end;

/



create or replace package body pack7 is

procedure proc7a(as_1 out varchar2)

is

begin

select sha_no into as_1 from sha_m where sha_no = '1327';

end;

end;

/

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



CR:698500
CR Number:   698500
Product Name:   PB Enterprise
Product Component:   PB.NET UI
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2013 Presently Not Targeted For Any Future Release Of This Product
Description
When many objects are included on a wpf window

of type canvas such as userobjects, group boxes, static texts, and you open the window

in the IDE, the following error appears:



Problem Loading

The document contains errors that must be fixed before the designer can be loaded.

Reload the designer after you have fixed the errors.

Reload the designer



RESOLUTION: Not a bug. XAML was corrupted.
Workaround Description
 Make a manual change to the xaml and save the xaml. Reopen the window.



CR:698508
CR Number:   698508
Product Name:   PB Enterprise
Product Component:   PB.NET WinForm
Status:   Open
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Compiling Winform or webform the following error results:

In PB 12.1 - C0352: Unknown error

In PB 12.5 - C0312: An object reference is required for a nonstatic field, method,

or property



CR:698530
CR Number:   698530
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2012 Fixed
Description
A window has a static text that is bolded, and an sle, mle, and rte. At runtime as you type text into the sle, mle, or rte. The bolded text keeps getting bolder until it becomes fuzzy and almost unreadable. It appears that on each keystroke the bold text is getting refreshed or written over itself again. Similar to CR 683738 on which there has been no action.



CR:698934
CR Number:   698934
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Open
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Transparent color of icon is not shown correct on 16bit color depth of desktop.



CR:698943
CR Number:   698943
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   Windows XP
Original Version:   11.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11.5 21 Mar 2012 Fixed
Description
At runtime, we want to change the library search path of the application using SetLibraryList. Whenever an object is used, it is cached and used from the cache next time.

We need a way to clear the objects from memory/cache.



CR:699124
CR Number:   699124
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Feb 2012 Fixed
Description
The Randomize function does not work the same in webform as in classic PowerBuilder.



In classic PowerBuilder you always get the same series of numbers if you provide the same seed in Randomize(seed) with subsequent Rand() calls.



But in webform and winform you get different series.



CR:699208
CR Number:   699208
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2012 Not a Bug
Description
datetime2(3) datatype using SNC and SQLNCI10 is not as described in PB documentation in the column specification for the datawindow.



When using the above driver I see the datetime2(3) column in the column specifications as a simple datetime. The database painter displays as described.



http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.help.pb.12.5/title.htm



Precision settings When you map to a table column in a SQL Server 2008 database, PowerBuilder includes a column labeled 揇ec in the Column Specifications view of the DataWindow painter, and a text box labeled 揊ractional Seconds Precision in the Column (Object Details) view of the Database painter. These fields allow you to list the precision that you want for the TIME and DATETIME2 columns.



CR:699247
CR Number:   699247
Product Name:   PB Enterprise
Product Component:   WPF DW Painter
Status:   Closed
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2012 Fixed
Description
Creating a crosstab datawindow in PB .NET causes the

following error:

Unable to create crosstab: System.ArgumentOutOfRangeException: Index was out of range.

Must be non-negative and less than the size of the collection

Parameter name: index

at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)

at System.ThrowHelper.ThrowArgumentOutOfRangeException()

at System.Collections.Generic.List`1.get_Item(Int32 index)

at fv.a(Int32 A_0, Int32 A_1, String A_2, Int32 A_3)

at fv.o()

at fv.p()

at fv.q()

at fv.r()

at fv.s()

at fv.b()

at fd.k()

at fd.aa()

at Sybase.DataWindow.Common.DWDesignTimeService.a(IDWDataSourceInfo A_0, String A_1, String A_2, String A_3, String A_4, String A_5, Boolean A_6, Boolean A_7, String& A_8)

at Sybase.DataWindow.Common.DWDesignTimeService.GenerateCrosstabSyntax(IDWDataSourceInfo dsInfo, String style, String rows, String columns, String values, String sources, Boolean dynamic, String& error)

at Sybase.PowerBuilder.PBVSX_PlugIn.PBVSX_DataWindowManager.CreateCrosstab(String DWName, String libraryPath, String select, String style, String rows, String values, String columns, Int32 type, Int32 selectType, SByte isDynamic, String spmr, String args)



CR:699385
CR Number:   699385
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like us to make the Crosstab definition window resizable.

Customer feedback:

"Please make the crosstab dialog screen resizable or at least bigger. Attached (11721421.zip) is a screenshot that shows what the Crosstab Report Generator screen looks like when creating a new crosstab report and then what the Crosstab Definition screen looks like when editing the definition for an existing report. Both screens should look the same and behave in the same manner."



CR:699547
CR Number:   699547
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2012 Duplicate
Description
Engineering CR 699208 and they have requested a documentation CR be opened.



datetime2(3) datatype using SNC and SQLNCI10 is incorrect in PB documentation in the column specification for the datawindow. Engineering has confirmed that the SQL Server data type datetime2 is mapped to datetime in PowerScript.



http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.help.pb.12.5/title.htm



Below is what is in the documentation:



Precision settings When you map to a table column in a SQL Server 2008 database, PowerBuilder includes a column labeled 揇ec in the Column Specifications view of the DataWindow painter, and a text box labeled 揊ractional Seconds Precision in the Column (Object Details) view of the Database painter. These fields allow you to list the precision that you want for the TIME and DATETIME2 columns.



This is what engineering has requested it be changed to:



Precision settings When you map to a table column in a SQL Server 2008 database, PowerBuilder includes a column labeled "Dec" in the Columns view of the DB painter, and a text box labeled "Fractional Seconds Precision" in the Column (Object Details) view of the Database painter. These fields allow you to list the precision that you want for the TIME and DATETIME2 columns.



CR:699624
CR Number:   699624
Product Name:   PB Enterprise
Product Component:   Language with .NET
Status:   Open
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PB crashed using ShowHelp() in PB Classic 12 .NET Windows Forms applications
Workaround Description
 #IF DEFINED PBDOTNET THEN

@System.Windows.Forms.Control _parent

@System.Windows.Forms.Help.ShowHelp(_parent, "C:\WINDOWS\Help\camera.chm")

#END IF



CR:699822
CR Number:   699822
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2012 Fixed
Description
The customer has an Oracle stored procedure with and OUT parameter of type number. This has a precision of up to 38 digits. They were calling this from PowerBuilder 9 as a transaction object RPC. PowerBuilder maps the number argument to a double. Since they needed more precision, they changed the PB external declaration of the argument from a double to a decimal. This worked fine and they got the precision they needed.



Now they have migrated to PB 12.1. It is no longer working. If they map the external function declaration to a double, then it does work, but they can't get the precision they need. Prior to the call they do a SetNull on the argument and they notice if they comment this out then it works again. This is fine but they have hundreds of calls with setnulls and the do not want to hunt them all down. They also notice that they must now connect in PB 12.1 with a SQLCA.dbParm = "NLS_CHARSET='WE8ISO8859P1" for everything to work correctly. If they remove this the RPC decimal call works correctly even with the setnull. But they need this dbparm for other areas of their application to work correctly.



So they are hoping there is a way to fix this setnull issue and allow the RPC to work with a decimal argument, setnull on the argument prior to the call, and connecting with the NLS_CHARSET='WE8ISO8859P1'.



CR:700100
CR Number:   700100
Product Name:   PB Enterprise
Product Component:   DW Rich Text
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2012 Fixed
Description
PB 12.5 Autosize Height does not work correctly on RichText DW columns, but it seems it has worked in PB 11.5.1 build 4566.



CR:700205
CR Number:   700205
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Open
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A decimal type is converted by double when truncate is used in the formula of DataWindow.



CR:700761
CR Number:   700761
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2012 Consult Complete
Description
According to the PB doc the return values when doing a setitem to a datastore or datawindow is:



"Returns 1 if it succeeds and 1 if an error occurs. If any argument's value is null, in PowerBuilder and JavaScript the method returns null."



When the datastore or datawindow does not have a datawindow object assigned the return is coming back as null. The customer believes this should be a -1 as the although there is no dataobject assigned, the datastore or datawindow is not null.



CR:700863
CR Number:   700863
Product Name:   PB Enterprise
Product Component:   Project Painter
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If you choose to select "External manifest" in Project > Security painter, PB generates an .exe.manifest file, which must be deployed with the executable file.

Customers may also use tools such as Microsoft.msi, IStool, InnoSetup or InnoIDE.



Once the application is deployed, is it possible to use a custom/generic .exe.manifest file created by customer or does cust always have to use the one generated by PB?



CR:701018
CR Number:   701018
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
DW Column property DBName has incorrect value when Column Alias is used.

For example if you use the following sql for the DW to be created:

SELECT "emp"."emp_id" as colalias, "emp"."emp_fname", "emp"."emp_lname" , "emp"."dept_id" , "emp"."salary" FROM "employee" "emp"

WHERE ( "emp"."salary" > 50000 )

dbname= employee.colalias in that case.

Expected would be employee.emp_id.



CR:701021
CR Number:   701021
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2012 Consult Complete
Description
FileReadEx cannot load in ablob a file over 200 Mb.



CR:701111
CR Number:   701111
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Open
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Copy of cell of Excel cannot be pasted on an Editmask column.



CR:701134
CR Number:   701134
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The DW Find function returns True when the test is an expression comparing two strings containing ~n and ~t.

Using the same expression in a DW If() function works as expected (i.e. the expression ("~r" = "~n") evaluates as FALSE).



CR:701399
CR Number:   701399
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Open
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Even after you close a sheet in an MDI frame window, the toolbar menu on the MDI frame window may be kept highlighted.



CR:701504
CR Number:   701504
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 May 2012 Fixed
07 Nov 2013 Added to user documentation
Description
Customer has a web form application and they used a tool called WebInspect to see if they have any security issues.



Customer has questions on the results they are seeing and would like to know if there is a solution for what they see as security issues.



CR:701514
CR Number:   701514
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2013 Fixed
Description
Migrated app from PB 10 and eas 5.3 to pb 12.5 and eas 6.3.1.

Java component is passing large amounts of data to a pb component and are getting the following errors:



2012-03-13 00:46:20.134 INFO Thread-85 [JaguarServer] n_cst_alternate cannot get a database connection.

2012-03-13 00:46:20.134 INFO Thread-85 CACHE: jonview_host

2012-03-13 00:46:20.134 INFO Thread-85 SQLDBCODE: 3113

2012-03-13 00:46:20.134 INFO Thread-85 SQLERRTEXT: ORA-03113: end-of-file on communication channel

2012-03-13 00:46:20.148 ERROR Thread-85 [TransactionManager] Failed to rollback transaction: javax.transaction.SystemException:

2012-03-13 00:46:20.148 ERROR Thread-85 Caused by: java.sql.SQLException: cm__oci_error: Error rollingback Transaction.

2012-03-13 00:46:20.148 ERROR Thread-85 | 3114 ORA-03114: not connected to ORACLE

2012-03-13 00:46:20.148 ERROR Thread-85 | at com.sybase.jaguar.jcm.oracle.OracleuConnection.nRollback(Native Method)

2012-03-13 00:46:20.148 ERROR Thread-85 | at com.sybase.jaguar.jcm.oracle.OracleuConnection.rollback(OracleuConnection.java:96)

2012-03-13 00:46:20.148 ERROR Thread-85 | at com.sybase.jaguar.jcm.oracle.OracleuConnection_DJC.rollback(OracleuConnection_DJC.java:493)

2012-03-13 00:46:20.148 ERROR Thread-85 | at com.sybase.djc.transaction.Transaction.rollback(Transaction.java:1212)

2012-03-13 00:46:20.148 ERROR Thread-85 | at com.sybase.djc.transaction.Transaction.jdbcRollback(Transaction.java:1285)

2012-03-13 00:46:20.148 ERROR Thread-85 | at com.sybase.djc.transaction.Transaction.rollback(Transaction.java:828)

2012-03-13 00:46:20.148 ERROR Thread-85 | at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:945)

2012-03-13 00:46:20.148 ERROR Thread-85 | at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:758)



Customers says they disconnect from the database in the deactivate event.



n_cst_xml and n_cst_alternate transaction support is set to requires new transaction



RESOLUTION: Patch from cr694125 resolved issue



CR:701830
CR Number:   701830
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Open
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New Page on Group Break" option does not work on PB.NET WebForm.



CR:702226
CR Number:   702226
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
StaticText field in a dw that ends with && shows

incorrectly in the preview view when autosize height is checked.



The text property shows the value as Id&&



From online help for ampersands:

If you want an ampersand to display in the text, type two ampersands, and if you want an ampersand to display and serve as the accelerator key, type three ampersands.



CR:702237
CR Number:   702237
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When defining object functions:



Request to not show an error message "Return type is not a valid name"

when leaving the return type of a function blank at the moment you tab out;

instead for example generate "(none)"



CR:702243
CR Number:   702243
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2012 Not a Bug
Description
Failed to read a file on a Japanease Windows.



CR:702249
CR Number:   702249
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Linux
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2012 Not reproducible with latest version of the product available as of Resolution Date
Description
Customer EAS on Linux is crashing occasionally and he would like to know why. There is nothing in the log file but he sees hs_err*.log files with PB files being referenced. Can these be used to diagnose the problem?



CR:702465
CR Number:   702465
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The following from CR 445351 never made it into the doc set. Customer confirmed that this works in PB 12.5.



Currently in Application Techniques for PowerBuilder components on EAServer is the documented in Table 36-14: PowerBuilder files required on EAServer host with the following:



SOAP clients for EasySoap and .NET Web services (for .NET Web services, the two Sybase.PowerBuilder DLL files must be deployed to the EAServer\Bin directory)



This is wrong for EAS 6 as described in the resolution for CR 446351, and confirmed by the customer. See below copied from the resolution.





We need to document this in our manual and help. The description should look like:





for EAServer 5.x:

Consuming a .NET Web service from a PowerBuilder NVO If you call a .NET Web service from a PowerBuilder component running in EAServer, you must deploy the Sybase.PowerBuilder.WebService.Runtime.dll, Sybase.PowerBuilder.WebService.RuntimeRemoteLoader.dll and the dynamically generated .NET assembly to the EAServer bin directory.



For EAServer 6.0:

Consuming a .NET Web service from a PowerBuilder NVO If you call a .NET Web service from a PowerBuilder component running in EAServer, you must deploy the Sybase.PowerBuilder.WebService.Runtime.dll, Sybase.PowerBuilder.WebService.RuntimeRemoteLoader.dll and the dynamically generated .NET assembly to the JDK/bin directory.



CR:702720
CR Number:   702720
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2012 Fixed
Description
Using the DropDownCalendar property for .NET WebForms applications make the application looping endlessly when there is a some coding in the ItemChanged event



CR:702729
CR Number:   702729
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Len (space (0) ) and Len (space (-4) ) computed expressions return 1 in a DataWindow but 0 in a PowerScript.
Workaround Description
 There is an easy workaround possible:

say you have a variable i that is the number you want to test ie. -4 or 0 then this expression should work:

if (i <1,len(trim(space(i))),len(space(i)))



CR:702737
CR Number:   702737
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2012 Fixed
Description
ItemChanged event is triggered when focus is moved from a Date column.

After migration from PB 11.5 to PB12.5 the ItemChanged event is triggered when focus is moved from a Date column even there is no change in the data.



CR:703092
CR Number:   703092
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 11 Apr 2012 Fixed
Description
Autoselection not working for a dw column

of type edit. The autoselection property is checked when tabbing thru

the dw, the column is not highlighted.



CR:703094
CR Number:   703094
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2012 Presently Not Targeted For Any Future Release Of This Product
Description
Datawindow button with picture associated overlays the button text in a web form application.



CR:703782
CR Number:   703782
Product Name:   PB Enterprise
Product Component:   PB.NET
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Script view not displayed when openning a child WPF



CR:703851
CR Number:   703851
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.1 20 May 2012 Fixed
Description
PBESCAPEMENTMODE option does not affect background color area.



CR:703900
CR Number:   703900
Product Name:   PB Enterprise
Product Component:   WPF Runtime
Status:   Closed
OS:   Windows 7
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jun 2012 Consult Complete
Description
Customer has a PB 12 WPF application that has been deployed to many workstations. The workstations supposedly had the same image but the customer knows that some may have had additional software installed on them. On most, the application works fine but on some, a small percentage, the application crashes on load.



CR:703902
CR Number:   703902
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Linux
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 May 2014 Fixed
Description
String value passed to nvo not displaying correctly

in a dw computed field. Computed field is populated by retrieval argument.



String passed into function is used as retrieval argument



On Linux, only the first character is show.

On Solaris, no characters are showing up

Works ok on windows



CR:703921
CR Number:   703921
Product Name:   PB Enterprise
Product Component:   WPF DW
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like to be able to create a WCF services that he can access from a web services based DataWindow when the service requires arguments.



CR:704189
CR Number:   704189
Product Name:   PB Enterprise
Product Component:   WPF Runtime
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jul 2012 Fixed
Description
When connecting to a ASA database using

ADO.NET, it works ok in PB Classic and from the db profiles in PB .NET environment

without specifying a Datasource



When you run an application that is connecting to ADO.NET in WPF runtime, if

the DataSource is not specified, you get an error message is 'Data Source is not provided'

and the connection to the db fails.



RESOLUTION: Use the following syntax: DATASOURCE='DatabaseName=peat125;ServerName=peat;Host=teamsybase.net

instead of:

PROVIDERSTRING='DatabaseName=peat125;ServerName=peat;Host=teamsybase.net



CR:704625
CR Number:   704625
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Open
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
With PowerBuilder being 32 bit but being able to run on 64 bit platforms there are times when the application needs to read the 64 bit registry for values. Current registry functions (RegistryGet, etc) redirect the registry query to the Wow6432Node. PowerBuilder needs new functions for use on a 64-bit computer to read a registry entry from HKLM\SOFTWARE without that redirection.



CR:704661
CR Number:   704661
Product Name:   PB Enterprise
Product Component:   PB.NET
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Trying to create a .NET assembly that implements the following

interfaces:

Extensibility.IDTExtensibility2

EnvDTE.IDTCommandTarget



1. The interface methods pass arguments of type System.Object that PB.Net will not let customer assign to other more restrictive data types (Application and AddIn). Note that he has the same problem with the return from a GetEnumerator function, customer can't assign it to anything useful.



2. Also the code compiles cleanly in the IDE, a full build results in 17 errors.



3. PB.Net does not allow customer to add enumerated values:



StatusOption = vsCommandStatus.vsCommandStatusSupported! + vsCommandStatus.vsCommandStatusEnabled!



CR:705104
CR Number:   705104
Product Name:   PB Enterprise
Product Component:   WPF DW
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
WPF datawindow where the source is a stored procedure

and taking in 1 argument. The dw sp argument list has 2 retrieval arguments listed.

When retrieving, it will hang in PB .NET.



Works ok in classic.
Workaround Description
 Remove the extra sp argument from the list or add another input argument to the stored procedure.



CR:705370
CR Number:   705370
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 May 2012 Not a Bug
Description
OS: Windows 7 Enterprise

Versions and Build #s Tested: PB 12.5.1_4015

Database/Driver File/Version: N/A



Comments: On Windows 7 Enteprise, the WebForms application does not format the editmasks according to the regional culture in ASP.NET and according to machine Regional Settings. English/USA is always assumed.



On Windows 2003, the issue doesn't happen and all works fine.



Original customer needs culture and regional settings set to Spanish/Peru which is ###,###.00.



CR:705372
CR Number:   705372
Product Name:   PB Enterprise
Product Component:   WPF DW
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 May 2012 Fixed
Description
PowerBuilder.NET 12.5.1. A WPF Window Application connecting to ASE with ASE 15 client does not display retrieval arguments in a datawindow computed field.



CR:705519
CR Number:   705519
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2012 Fixed
Description
After instantiating a soapconnection object and instance,

memory keeps increasing when the webservice is continuously called from a timer

event.



Problem happens in application executable. Memory appears to be reclaimed

when running webservice client from IDE.



CR:705602
CR Number:   705602
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Open
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2012 Fixed
Description
DataWindow in preview mode scrolls in an unexpected position.



CR:705833
CR Number:   705833
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2013 Presently Not Targeted For Any Future Release Of This Product
Description
When using DownloadFile(tmpfilename,false), a

popup window will open and immediately close. There is no option to open or

save the pdf file.



RESOLUTION: Issue caused by IE9's new behavior change



CR:705835
CR Number:   705835
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2013 Presently Not Targeted For Any Future Release Of This Product
Description
When clicking on a dot notation html.link in a dw,

the pdf will open but in the same window as the webform. There is no way

of going back to the original webform.



RESOLUTION: Not to be fixed. PB Webform limitation.



CR:705983
CR Number:   705983
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2013 Workaround
Description
Application migrated from OLEDB to SNC and seeing different

results with SNC.



The following sql is returning different results for OLEDB vs. SNC:

select *, (select (value_2) from table2 where table2.value_1 = table1.value_1) from table1



With OLEDB, it returns the following error:

Select Error: SQLState = 21000

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, ,<=, >, >= or when the subquery is used as an expression



With SNC, it returns a result set.





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

PSE NOTES



OS: winxp

Versions and Build #s Reported: PB 12.5

Versions and Build #s Tested: PB 12.1 (build 7068) and PB 12.5 (build 4525)

Database/Driver File/Version:

Comments: Customers application is handling the OLEDB db error and is causing

problems when they migrated app to SNC.



Customer tried using Mars_Connection=no and MultipleActiveResultSets=false

and same results. Customer would like to see the same from OleDb to SNC



RESOLUTION: Use dbparm of Block=1 to see same behavior as OLEDB



CR:706152
CR Number:   706152
Product Name:   PB Enterprise
Product Component:   DB SQLAnywhere
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2012 Third Party Problem
Description
Customer has an old application written in PB 6.5.1 that was using SQL Anywhere 9. He is now migrating the application to PB 12.5 and his new customers have been purchasing SQL Anywhere 11/12.



In powerscript the customer dynamically creates a datastore from SQL syntax such as:

select keyid, signature_id , '' dummy from table



They then import data into this datastore using the datastore function importfile(filename)



The data in the filename contains two numeric columns and a character column. The character column is quoted and is longer than 1 character.

e.g.

1010 2010 "some data"

2010 3010 "some data2"



When their application executes against a Sybase 9 database the importfile works. When it executes against a Sybase 11 database the importfile generates an error.



The difference is that in Sybase 9 the computed column is created as type char(0) whereas in Sybase 11 it is created as char(1). This is breaking their application. This appears to be a difference in how the database creates the char computed column in PB so it may be a deliberate change from SQL Anywhere 9.



CR:706172
CR Number:   706172
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 2012 Not reproducible with latest version of the product available as of Resolution Date
Description
Customer has an EAS 6.3.1 application with PB and other components that runs fine but then crashes every day when it runs out of memory.



CR:706381
CR Number:   706381
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Open
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When using DownLoadFile() in a webform, provide

same options as the FileManager->Download File link.



The FileManager-> Download file link has the options to open or save a file.

Provide the same 'bar' option to the DownloadFile()



CR:706548
CR Number:   706548
Product Name:   PB Enterprise
Product Component:   MAPI
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2014 Fixed
Description
Enhancement request to update the built in PowerBuilder mail functions to work with newer mail standards. With newer mail systems and operating systems, simple mapi is no longer supported.



Support extended MAPI in outlook 2010 or 2013 and allow 64 bit support.



CR:706672
CR Number:   706672
Product Name:   PB Enterprise
Product Component:   WPF Script Editor
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2012 Fixed
Description
Customer is using a .Net List object (System.Collections.Generic.List<string> names). It creates and you can add elements. If you access it using normal Powerscript array syntax, it works fine if using a long variable as the index:



long ll_index

string ls_name

ll_index = 0

ls_name = names[ll_index]



There are no errors and it works fine. But if you us a literal in the script as an index, there are compile errors. There is a squiggle under the [0] in the script editor. When you hover over the [0] you see the error Cannot find the element "". And when you close the window you'll see the same error. However it runs fine, and a Full Build shows no errors:



string ls_name

ls_name = names[0]



CR:706719
CR Number:   706719
Product Name:   PB Enterprise
Product Component:   Language with .NET
Status:   Closed
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2012 Not a Bug
Description
Building a large array and pre-populating the values seem to create a memory issue resulting in an R0015 execution error. Smaller array does not have a problem.



CR:706776
CR Number:   706776
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer has turned on autosize height on a nested datawindow within a trailer group band. If this nested report in the trailer group band is larger then one page the nested datawindow is truncated. This is long time documented behavior.



CR:706874
CR Number:   706874
Product Name:   PB Enterprise
Product Component:   DataBase
Status:   Closed
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2012 Fixed
Description
Customer uses SyntaxFromSql to create his datawindows and would like to use bind variables (DisableBind=0). When using SyntaxFromSQL the retrieve does the full describe regardless of the setting.



Should PB use the bind variables with SyntaxFromSql or is this not supported? I could not find any limitation in the documentation.

Customer is using Oracle but same behavior can be seen with the demo database and SQL Anywhere.



CR:707498
CR Number:   707498
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 May 2012 Fixed
Description
A mdi application executable that worked in PB 12.5

build (3072) is crashing on opening window in build 4015.



The crash is an invalid pointer read in the gdiplus!CopyonWriteBitmap::GetPixel.



If customer uses the pbshr125.dll from 3072, that app exe works with the 4015 dlls
Workaround Description
 Problem with the pbshr125.dll from build 4015. Customer uses the dlls from 4015 but the pbshr125.dll from build 3072--app works ok.



CR:707674
CR Number:   707674
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OS: Windows XP SP3

Versions and Build #s Tested: PB 12.5_2511 and 12.5.1_4015



When reading data from a CLOB Oracle column that has a file stored on it into a BLOB variable, the resultant BLOB variable size is the double of the original data/file that was saved on CLOB column. This is affecting customer's routines that depend on file size and he can't migrate from PB 9 to 12.5.x due to that.



It worked fine in older PB 9.x.



CR:707740
CR Number:   707740
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Difference in psr file when using "Save File As". opposed to "Save rows as"..

This main datawindow is saved as a Powersoft report and this .psr file is assigned to a datawindow control via .DataObject property.

It returns error: "Load of the nested report failed".



CR:707972
CR Number:   707972
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 May 2012 Fixed
Description
Memory leak can be observed if repeatedly opening and closing a sheet having a menu with icon images (.ico files) within an MDI frame window.



CR:708161
CR Number:   708161
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When the CheckBox type column has been located to DataWindow, DataWindow control scrolls and displays a column without the tab order located out of control size.



CR:708370
CR Number:   708370
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jul 2012 Workaround
Description
Is there any way to change an object of type xloc_ReverseSearchOption into an object of type xloc_searchoptionbase? How to avoid a compilation error in Powerbuilder with complexTypes?



CR:708504
CR Number:   708504
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2012 Fixed
Description
Clicking on the header of a column in a multi-table Grid DataWindow caused a crash in PowerBuilder 12 and 12.5.



CR:708506
CR Number:   708506
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Linux
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jul 2012 Consult Complete
Description
Customer has EAS 3.6.1 on Linux is crashing occasionally and he would like to know why. Customer installed on new hardware and thought the old CR (702249) was resolved but he is now crashing again.



CR:708923
CR Number:   708923
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2013 Presently Not Targeted For Any Future Release Of This Product
Description
App is crashing on lds.object.sync_build[1] running

on vmware on thinapp 4.7. App is crashing in the user32.dll.



CR:708926
CR Number:   708926
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2012 Fixed
Description
When an app has print preview set and then

retrieves, app will crash in the pbdwe.



The dw control has setredraw(off) in the retrievestart event and setredraw(on) in the

retrieveend event.



App crashes with a access violation in the PBDWE125!aggrcomputesum
Workaround Description
 Avoid using print.preview before retrieve or move the setredraw from the retrievestart/retrieveend events.



CR:709030
CR Number:   709030
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.0 10 Jun 2012 Fixed
Description
When using setredraw(false), computed fields are

not getting updated after a retrieve.



The computed fields are on the d_icbs12_1_1 datawindow. They are similar to

the following:

Round( Sum( if( GlDeleteCode = 'N' and RecvFlag = 'Y', recvqnt, 0)), 3)



CR:709063
CR Number:   709063
Product Name:   PB Enterprise
Product Component:   ORCA
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jun 2012 Not a Bug
Description
Customer has several applications that they rebuild in the IDE and also with orcascript. On a few, when using orcascript he gets errors but it works in the IDE.



CR:709268
CR Number:   709268
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Open
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When changing two or more vertical positions of control, Power Builder will replace the order of control.



CR:709321
CR Number:   709321
Product Name:   PB Enterprise
Product Component:   WPF Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
.Net cvuo assembly feature : When calling Popup() from an assembly returns error-> 'System.NullReferenceException' occurred in Sybase.PowerBuilder.WPF.dll
Workaround Description
 Put all cvuo inside of the WPF application, then no runtime error is thrown.



CR:709693
CR Number:   709693
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Open
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
An LF (0x0a) may remain in a column with EditMask "X" of the DataWindow when pressing Ctrl+Enter key in the column.



CR:709758
CR Number:   709758
Product Name:   PB Enterprise
Product Component:   DW Rich Text
Status:   Open
OS:   Windows 7
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Toolbar of RichText column overlaps top-part of the text on Windows 7 \ Vista.



CR:710061
CR Number:   710061
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Open
OS:   Windows 7
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When using DataWindow SaveAs PDF with ghostscript 9.x 64-bit

on 64-bit Windows the generation failed.



It was possible to get it to work by performing the following two steps:

- Install the "Sybase DataWindow PS" printer using ghostpdf.inf

Add a new printer as printing to file and use the "have disk" option

Browse to the ghostscript \lib folder and select the file ghostpdf.inf

The printer must be called "Sybase DataWindow PS"

- In the ghostscript \bin folder make a copy of gswin64c.exe and name it gswin32c.exe



CR:710101
CR Number:   710101
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2013 Consult Complete
Description
Calling webservice issue



Calling webservice from easysoap returned the following response:

RESPONSE:

SRECV: 1024 bytes

HTTP/1.1 200 OK

content-language: en-US

content-length: 615

content-type: text/xml; charset=UTF-8

date: Tue, 29 May 2012 16:59:22 GMT

p3p: CP="NON CUR OTPi OUR NOR UNI"

server: IBM_HTTP_Server

Set-Cookie: PD-H-SESSION-ID=4_1_o0nWfbKfMHKfe8hAzwFTkLnB4znwwrIbzkzSHsiLctFF65T5; Path=/

Set-Cookie: PD-ID=fRtMg8OgiwDd+wJyvo-WGokwZ2p0STGMl2XPPNaJlI8UY4zMb+v1cLfaTYynlNfPNnwKXILq83SjPpAsmgvvOEO+0j85EkrLCpxWrU1hRBnGUcEkChD-dhROykeIiUZp3cTw8s3umxpkl6saErL4JqtGzLjkZtPWrrxtiM9Ro2bBrURlKE3F9vpRFv5BbYFnSPbZcIZGBCzqiFZUqqv7yjC9ivUhCWwBWQVPqXxieLkygGAw7pecK9ytaIKr2jGNl7L0MImS+N3aB1VQruN6mhojEelwfPD7oHW+AOJdf0Wp1fKRLC50bMf6YicXNRHcKlNb1VoAx531D+Setlu5n3zHKPTjhg303fg48QluFND-A+JNGmv1DPhB6Z0+0bjI8HEdMye38WuJRtlPCpDs6g==; Domain=.xxx; Path=/; Secure



<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/"><Body><Fault><faultcode xmlns="">Server</faultcode><faultstring xmlns="">CSMSPEC03 :

xxxx

0

</faultstring><faultactor xmlns="">Server</fSRECV: 348 bytes

aultactor><detail xmlns=""><ns1:BusinessError xmlns:ns1="http://www.ibx.com/ecommerce/2006-v01/error"><LongDescription/><ListEntityID/><TimeOfError>2012-05-29T12:59:22.739-04:00</TimeOfError><ErrorCode>Server</ErrorCode><ShortDescription>CSMSPEC03 :

1215771

AAA

0

</ShortDescription></ns1:BusinessError></detail></Fault></Body></Envelope>

Connection Disconnected







Customer then tried using .NET to call webservice and receiving a 401 unauthorized request



CR:710391
CR Number:   710391
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The MapWinGIS ActiveX SelectShapes function did not pass an array of integers or longs back to PowerBuilder.



CR:710609
CR Number:   710609
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2012 Fixed
Description
Memory leak can be observed if repeatedly opening and closing a sheet having a menu with many submenu items within an MDI frame window.





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复Sybase SQL Anywhere的工具在国内应该算首创。

ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具

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

ReadASADB适用场景

各种误操作:

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

本工具的应用场景:

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