远程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:726700
CR Number:   726700
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jan 2013 Fixed
Description
In a nested report, objects are overlaying the footer, when they should be pushed to the next page. This happens when you have an environment variable DW_PUSH_CUT_CONTROL_TO_NEXT_PAGE=yes or =no defined! Either way it does not push the cut controls. If you do not have this environment variable defined then it does not push as expected. In this case when it is not defined if you set the datawindow property dw_1.Modify('datawindow.PushCutControlToNextPage=yes') then it pushes the cut controls correctly for that datawindow. But if you have both the datawindow property and the environment variable set to yes, it should push obviously but it does not. This is a problem with the environment variable.



It would also seem that what should happen is that the code should override the enviornment variable such that I could have all datawindows do what the enviornment variable is set to and override that behavior on specific datawindows with the dw property. I think that is how it should work.



CR:726726
CR Number:   726726
Product Name:   PB Enterprise
Product Component:   Printing
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 2012 Fixed
Description
Starting with build 4953, PrintOpen is returning a -1 any time the showprintdialog argument is false:



Job = PrintOpen() //this fails with -1



Job = PrintOpen("Print Window",false) //this also fails with -1



Job = PrintOpen("Print Window",true) //this code works



CR:726731
CR Number:   726731
Product Name:   PB Enterprise
Product Component:   PB.NET
Status:   Closed
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2012 Fixed
Description
RightA() may return empty or crash on PowerBuilder .Net if a very long multi-byte string is specified.



CR:726814
CR Number:   726814
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The following is the documented behavior for sorting data on a column with null values. Customer would like an enhancement request to be able to sort by a column with nulls and have the sort follow the sort order on the database side.



http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc37783.1250/html/dwref/CCJCHEECdw.htm



"When you sort a DataWindow on a specified column, rows with null data remain at the top, regardless of whether you choose ascending or descending order for your sort criteria. The sort order is performed on a result set returned from a database, but is not necessarily the same sort order used by the database (to return the result set) when an ORDER BY clause is used in a SQL query. "



CR:727162
CR Number:   727162
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)
04 Jan 2013 Fixed
Description
Webservice proxy client using decimal datatype in return structure is ignoring the decimal seperator in non english environment.



CR:727287
CR Number:   727287
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Dec 2012 Consult Complete
Description
A Paint() function fails in initialization of the Graphic class of GDI Plus.



CR:727449
CR Number:   727449
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When using the 'Windows Style Classic' property from the application project, an exe does not have the same behavior as in the IDE when 'Use Windows Classic Style for XP' is checked.





When 'Use Windows Classic Style for XP' is checked, pb adds UseVer5Control=1 in the

pb.ini. By using that property, when a commandbutton has focus, a dotted line

around the control on focus.



When checking the 'Windows classic Style', in the application project and then

running the executable, the dotted line is missing around the commandbutton on focus.
Workaround Description
 The workaround is to put a pb.ini file in the same folder as exe file with only UseVer5Control=1 under [PB] section.



CR:727829
CR Number:   727829
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A feature request to implement an option to make RB raise a runtime error when arithmetic overflow occurs.



CR:727830
CR Number:   727830
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2013 Added to user documentation
Description
Overflow of real, double, and decimal values doesn't cause a runtime error.



CR:727843
CR Number:   727843
Product Name:   PB Enterprise
Product Component:   PB Web Services- NVO deployment
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2013 Fixed
Description
Tested with PB 12.5.1.4971



The webservice worked in 11.5, but when migrated to PB 12.5.1 (classic), they get this error when trying to deploy it:

a_wf_ctn_act.asmx.cs(2111,28): error CS0012: The type 'Sybase.PowerBuilder.WinWebDataWindowCommon.PBDataStore' is defined in an assembly



Error: C# Compilation error when invoking pbwsemit.exe



CR:728607
CR Number:   728607
Product Name:   PB Enterprise
Product Component:   UO - Runtime
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OS: Windows XP SP3 / Windows 2003 SP2

Versions and Build #s Tested: PB 12.5.1_4953

Database/Driver File/Version: N/A



Comments: When inserting a standard visual UO into a Window and running the app that opens this window, PB hangs and CPU peaks to 100%.



CR:728619
CR Number:   728619
Product Name:   PB Enterprise
Product Component:   DB Sybase System
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2013 Fixed
Description
Customer is trying to use ASE 15 with a a function based index on a table. In PB ISQL, the rows are retrieved but when trying to create a datawindow with this table the following error is seen:



Cannot Create Datawindow



Name 'sybfi2_1' is reserverd for internal use by Adaptive Server.

Please use a different name.



Select titles.title.id, titles.id......................



'sybfi2_1' is the name of the function based index.



Is this a bug or is the use of function based indexes not supported?



CR:728727
CR Number:   728727
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Windows XP
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2013 Added to user documentation
Description
In the Users Guide -> Creating Executables and Components -> Defining an executable application project, it list the following for the Windows classic style option:



Select this to add a manifest file to the application that specified the appearance of the controls as an application resource. When a user runs the application on Windows XP with the Windows XP style for controls set in the control panel, all PowerBuilder windows, DataWindows controls that mirror standard Windows controls and other controls, display with the new style.

-----

However when the Window classic style is selected in the application project painter, no manifest file is created.



According to engineering:

It抯 actually for an option 揘ew Visual Controls Style in application project before PB11. The option was changed to 揥indows Classic Style from PB11. Checking the option 揥indows Classic Style will remove the manifest file from the exe file. the manifest file is embedded into exe file by default from PB11.



CR:728740
CR Number:   728740
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2013 Consult Complete
Description
Customeer has a ddlb that dynamically initializes its list in its constructor and opening it in code.



dropdownlistbox iddlb

openuserobject( iddlb, 'u_ddlb_pbllist',1,1)



When the userobject is dynamically opened inside a CVUO, the constructor is double

But when dynamically opened on a window the constructor is only singly called.



Statically creating the ddlb inside a CVUO by placing it in the form surface in the painter, the constructor is only single called.



CR:728832
CR Number:   728832
Product Name:   PB Enterprise
Product Component:   PB.NET DW
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Print Preview of a DataWindow may show garbled characters on .NET of PB 12.5.1 if the DataWindow has 2 or more Text objects and the fonts of those Text objects are different Japanese fonts such as MS Gothic, MS P Gothic and MS UI Gothic.



CR:728848
CR Number:   728848
Product Name:   PB Enterprise
Product Component:   Project Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jan 2013 Fixed
Description
The Source Control currently used is Perforce ( http://www.perforce.com ).

It can use Unicode but if the HEXASCII behaviour is right its not necessary.



Now when exporting using HEXASCII encoding Umlaut characters are not encoded correctly.

Problem exists in PB Classic 12.5.1.4953, earlier Build 4595 is OK.

As it seems also characters with accents are not correctly translated in HEXASCII.



CR:728876
CR Number:   728876
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2013 Consult Complete
Description
The customer is asking how PowerBuilder supports line breaking rules for complex languages such as Thai. They have installed the appropriate Language Pack for Windows 7/Server 2008 R2 and that works for other applications such as MS Word. But it does not work for the Datawindow's Column and Computed fields.



CR:728964
CR Number:   728964
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2013 Fixed
Description
Rand PowerScript function not working in a PB .NET WebService



CR:729260
CR Number:   729260
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2014 Workaround
Description
Migrated from PB9 to PB12.5 and when calling db2 stored procedure in the datawindow or isql returns the

following error:



[IBM][CLI Driver] CLI0115E Invalid cursor state. SQLSTATE=24000



The following is from the odbc trace:

PB125 ba4-1964 EXIT SQLPrepareW with return code 0 (SQL_SUCCESS)

HSTMT 0F211ED0

WCHAR * 0x01211008 [ -3] "{call SYSPROC.DB2CONC4(IPARM1 = 'RR70293 SUNDARS 36644139322', IPARM2 = 'RR701210398034 000.00XXXX ')}\ 0"

SDWORD -3



PB125 ba4-1964 ENTER SQLExecute

HSTMT 0F211ED0



PB125 ba4-1964 EXIT SQLExecute with return code 0 (SQL_SUCCESS)

HSTMT 0F211ED0



PB125 ba4-1964 ENTER SQLNumResultCols

HSTMT 0F211ED0

SWORD * 0x0012C928



PB125 ba4-1964 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)

HSTMT 0F211ED0

SWORD * 0x0012C928 (0)



PB125 ba4-1964 ENTER SQLNumResultCols

HSTMT 0F211ED0

SWORD * 0x0012C910



PB125 ba4-1964 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)

HSTMT 0F211ED0

SWORD * 0x0012C910 (0)



PB125 ba4-1964 ENTER SQLSetStmtOption

HSTMT 0F211ED0

UWORD 9 <SQL_ROWSET_SIZE>

SQLPOINTER 0x000003E8



PB125 ba4-1964 EXIT SQLSetStmtOption with return code 0 (SQL_SUCCESS)

HSTMT 0F211ED0

UWORD 9 <SQL_ROWSET_SIZE>

SQLPOINTER 0x000003E8 (BADMEM)



PB125 ba4-1964 ENTER SQLExtendedFetch

HSTMT 0F211ED0

UWORD 1 <SQL_FETCH_NEXT>

SQLLEN 1

SQLULEN * 0x0012A2A8

UWORD * 0x01265008



PB125 ba4-1964 EXIT SQLExtendedFetch with return code -1 (SQL_ERROR)

HSTMT 0F211ED0

UWORD 1 <SQL_FETCH_NEXT>

SQLLEN 1

SQLULEN * 0x0012A2A8

UWORD * 0x01265008



DIAG [24000] [IBM][CLI Driver] CLI0115E Invalid cursor state. SQLSTATE=24000 (-99999)



PB125 ba4-1964 ENTER SQLErrorW

HENV 0F211C18

HDBC 0F212BE8

HSTMT 0F211ED0

WCHAR * 0x0EE29094 (NYI)

SDWORD * 0x0012A28C

WCHAR * 0x0139F610

SWORD 1026

SWORD * 0x0012A29A



RESOLUTION: Customer used workaround of DB2CODEPAGE=1208



CR:729293
CR Number:   729293
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)
12.1 06 Feb 2013 Fixed
Description
Customer is trying to create a webform application and when he tries to save it, he crashes. We have checked to make sure he has all .net requirements and he appears to.



He has tried uninstalling and reinstalling and the crash still appears to be happening.



CR:729380
CR Number:   729380
Product Name:   PB Enterprise
Product Component:   DW XML
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2013 Fixed
Description
PowerBuilder 12.5.1. Build 4953:



When importing numeric XML data into a decimal(2) DataWindow column only the first digit is imported



CR:729670
CR Number:   729670
Product Name:   PB Enterprise
Product Component:   WPF Compiler
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jan 2013 Consult Complete
Description
Customer is trying to create a PB .NET 12.5 Assembly and receives the following when trying to add a reference for a third party assembly:



Could not load file or assembly 'acPDFCreatorLib.Net, Version=4.5.2.9, Culture=neutral, PublicKeyToken=8aedc7a81d17941d' or one of its dependencies.could not load file or assembly 'acPDFCreatorLib.Net, Version=4.5.2.9, Culture=neutral, PublicKeyToken=8aedc7a81d17941d' or one of its dependencies. Attempt to load an unverifiable executable with fixups (IAT with more than 2 sections or a TLS section.) (Exception from HRESULT: 0x80131019)



(IAT with more than 2 sections or a TLS section.) (Exception from HRESULT: 0x80131019)





I can add this assembly to a C# class library, to a C# WPF application and also to a PB Classic .NET assembly but I cannot add it to the PB .NET assembly or PB .NET WPF application.



Is this a PB. NET bug or a limitation because of the third party assembly?



CR:729698
CR Number:   729698
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.0 04 Mar 2013 Fixed
Description
When editing a large string in the debugger, the string

variable will get truncated and data will be lost.



The string variable has over 20,000 characters.



CR:730021
CR Number:   730021
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Open
OS:   Windows 7
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer has some datawindows that they have been running connected to SQL Anywhere. They now have some customers that use SQL Server so are trying to migrate their application so that these customers can use their application.



If their datawindow has computed columne defined in the datawindow such as the following:



.01 + .01 as net_grant



when they run the datawindow created in SQL Anywhere with SNC and do anything to the datawindow to force the datawindow to update, the update properties now have the computed column as the identity column which is incorrect. You can change it back to (none) but if there are multiple computed columns and you remove one, the next one shows up.



In the datawindow source you can see that this has been changed. The

SNC datawindow that it has added identity=yes, see below.



SNC dw = column=(type=decimal(2) updatewhereclause=yes identity=yes name=net_grant dbname="net_grant" )



Original SQL Anywhere = column=(type=decimal(2) updatewhereclause=yes name=net_grant dbname="net_grant" )



CR:730125
CR Number:   730125
Product Name:   PB Enterprise
Product Component:   WPF Compiler
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2013 Fixed
Description
Customer has a COM Interop .NET assembly that works in VS 2010 but in PB 12.5.x .NET does not seem to expose the GET and SET methods.



In VS 2010, one must 'Embed Interop Type' to False. This appears to be new .NET 4 functionality for COM Interop.



This code compiles in PB 12.1



EpicPremier.ConceptOne.Interop.PDFCreactiveX.PDFCreactiveX i_pdfapp

i_pdfapp = create EpicPremier.ConceptOne.Interop.PDFCreactiveX.PDFCreactiveXClass

System.Object x



x = i_pdfapp.get_ObjectAttribute("x", "y");



In PB 12.5.x .NET the last line of code generates IntelliSense error 'Cannot find the element 摂.'



EpicPremier.ConceptOne.Interop.PDFCreactiveX.PDFCreactiveX i_pdfapp

i_pdfapp = create EpicPremier.ConceptOne.Interop.PDFCreactiveX.PDFCreactiveXClass

System.Object x



x = i_pdfapp.ObjectAttribute["x","y"]



This version is OK with Intellisense



x = i_pdfapp.ObjectAttribute



but the project compiles with



揑ndexed property 'EpicPremier.ConceptOne.Interop.PDFCreactiveX.IPDFCreactiveX.ObjectAttribute' has non-optional arguments which must be provided



CR:730387
CR Number:   730387
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Long standing and documented limitation of the datawindow is to not have one row span multiple pages. In older versions of PB the wordwrap utility was a workaround but as that is not officially supported, customer would like this functionality implemented into the core PowerBuilder product.



The following is contained in the documentation link below. Customer's immediate problem is a very large text column that may at times be larger than the size of the custom page, he would PB to handle this automatically.



"Handling large rows To avoid multiple blank pages or other anomalies in printed reports, never create a DataWindow object with a data row greater than the size of the target page. To handle large text-string columns, break the large string into a series of small strings. The smaller strings are used to populate individual data rows within a nested report instead of using a single text column with an autosized height. "





http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00844.1250/html/pbug/BFCCIAGD.htm



Customer's justification for this is below:



"It would be helpful if the software performed this automatically instead of using the work around by utilizing the wordwrap.dll. Since the wordwrap.dll is no longer supported, that means that it could stop working with any release with no other resolution in place.



This is an important aspect needed for my application and many other from all of the message boards that I have read over the last two days. While reviewing this, I noticed that even Microsoft Access performs this functionality with no issues and no additional coding needed. This should be part of PowerBuilder to stay as part of the leaders in Application Development, otherwise users will start moving to products that perform these functionality effortlessly."



CR:730479
CR Number:   730479
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)
25 Feb 2013 Workaround
Description
Do we offer MAPI mailsend for Mail/outlook 64bit support in powerbuilder 12.5 on 64 bit OS ?



CR:730752
CR Number:   730752
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2013 Not a Bug
Description
Customer is using a Word 2010 .dotx template file and retrieving the data from the database. When finished filling in the data, the data fields are misplaced and all up in the left hand corner of the document.



Is Word 2010 and .dotx files supported in PB? Customer believes the code is correct as they have done this in older versions of PB and Word but I am not sure if there might be changes in the WORD object model.



CR:730809
CR Number:   730809
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
Even if you try to open a Help window from the Properties of the DataWindow painter, the Help window does not appear.



CR:730921
CR Number:   730921
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)
13 Mar 2013 Consult Complete
Description
Customer has an app the does a HALT CLOSE in the destructor event of an nvo. It is causing a crash.



CR:731412
CR Number:   731412
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2013 Added to user documentation
Description
Please add to docu:



We support only Outlook 32bit versions, and Simple MAPI in PB 12.5.

Outlook 64 bit is currently not supported.



CR:731712
CR Number:   731712
Product Name:   PB Enterprise
Product Component:   PB.NET Assembly Deployment
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Mar 2013 Fixed
Description
Thread safety problem; when calling a PowerBuilder nvo, deployed as a .NET assembly, within a multithreaded environment, sometimes a Messagebox appears:



System.NullReferenceException: Object Reference not set to an instance of an object at Sybase.PowerBuilder.Win.PBSession.get_Currentsession() at c__testproject.InitAssembly()



CR:731714
CR Number:   731714
Product Name:   PB Enterprise
Product Component:   PB.NET Assembly Deployment
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2014 Fixed
Description
Handle leak when calling PowerBuilder 12.5 generated assemblies.



CR:731949
CR Number:   731949
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 May 2013 Fixed
Description
The customer has a PB 9 app that processes very large reports. He retireves the reports in a separate thread and once retrieved does a GetFullState to pass a blob back to the main PB thread. He can retrieve reports up to just under 1 Gig, and then the GetFullState will double the memory usage but still be under the 2 Gig limit. All works fine as long as he keeps the reports under 1 Gig. He does this by monitoring the datawindow storage property.



He is migrating this applcation to PB 12.5. But he is finding that the thread in PB 12.5 is crashing when it reaches just 1 Gig of total memory. So he is limited now in PB 12.5 to reports of under 500 meg which when doubled by the GetFullState will stay under the apparent new limit of 1 Gig.



Why is this happening in PB 12.5? Why can't he get the same 2 Gig of total memory usage as he had in PB 9?



CR:732053
CR Number:   732053
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2013 Not a Bug
Description
Customer is saving a group datawindow using SaveAsFormattedText as a csv file and when later opened in Excel the computed fields in the header have extra cells between them. When one opens either the .csv or .txt file you can see extra comma separators.



CR:732087
CR Number:   732087
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Setting transparency property does not make a selected item transparent in a DropDownListBox.



CR:732089
CR Number:   732089
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Transparency property does not take effect on an EditMask if getting and loosing a focus on the EditMask control.



CR:732125
CR Number:   732125
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When using Isolation Level Read Uncommited ('RU') with a SNC SQL Native Client\OLEDB connection to MS SQLServer a retrieve in the DataWindow and DataBase Painter blocked on a retrieve on a table having an update lock on it.



In a running PowerBuilder application however, setting SQLCA.Lock = 'RU' did take effect and the retrieve was not blocked.



CR:732127
CR Number:   732127
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OS: Windows XP SP2

Versions and Build #s Tested: PB 12.5.1_4953

Database/Driver File/Version: N/A

Comments: During DW runtime while in Web Forms, the row datawindow variable does not return zero when dw object header is clicked



CR:732188
CR Number:   732188
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PowerBuilder may crash if a very long expression is specified in the SELECT list if NLS_Charset is 'JA16SJIS'.
Workaround Description
 (1) Use a column alias like "SELECT decode(empno, 7639,7639 ....) as tmpcol1 FROM ...".



(2) Use Unicode instead of JA16SJIS.



CR:732312
CR Number:   732312
Product Name:   PB Enterprise
Product Component:   SYSAM
Status:   Open
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer is using a Citrix farm with PB IDE installed using served licenses. Every time the developer logs in, he might get a new hostname from the Citrix farm, requiring a new license from the server. Hence the uses are running out of licenses quickly.



CR:732457
CR Number:   732457
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2013 Fixed
Description
A Button placed in an N_Up DataWindow evaluates expressions for the wrong row when firing the buttonclicked event.



CR:732478
CR Number:   732478
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)
06 Jan 2014 Third Party Problem
Description
Customer calling a .net webservice from a PB client application

and PB is hanging. Problem only appears to be a win7.



The webservice is using xmlserialization. Customer created a 'pregen' xmlserializer dll. From process monitor, it shows the pregen xmlserializer dll being loaded. However, PB is still creating the *.cs temp files and compiling it to another pregen dll.



casemgt.exe CreateFile C:\coris\DocMgrRetrieverForPowerBuilderService.XmlSerializers.dll SUCCESS



Notice that the executable is still generating temp files and compiling to a dll even though there is a pregen xmlserializer

casemgt.exe CreateFile C:\Users\nuser\AppData\Local\Temp\cbizvben.tmp SUCCESS

casemgt.exe CreateFile C:\Users\nuser\AppData\Local\Temp\cbizvben.0.cs SUCCESS

casemgt.exe CreateFile C:\Users\nuser\AppData\Local\Temp\cbizvben.dll SUCCESS

casemgt.exe CreateFile C:\Users\nuser\AppData\Local\Temp\cbizvben.cmdline SUCCESS



CR:732502
CR Number:   732502
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Open
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 2013 Fixed
Description
remove RAD control in EBF installer



CR:732586
CR Number:   732586
Product Name:   PB Enterprise
Product Component:   DW Web ActiveX
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2013 Fixed
Description
DW Activex does not display in PB 12.5 using Internet Explorer





Cannot register the psdwc125.dll, it returns an error

DllRegisterServer failed with error code 0x80040200





According to the PB documentation:

The DataWIndow Web Control for ActiveX is a deprecated technology and might not be supported in future releases of PowerBuilder.



CR:732879
CR Number:   732879
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows 7
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 May 2014 Fixed
Description
When set to a non-zero value of (Background / font) Transparency property of the columns in the DataWindow, PB Runtime issues a frequent event.
Workaround Description
 Create a new contemporary menu and add it to the main window in order to improve performance if allowed to do that.



CR:732935
CR Number:   732935
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer requests for the DataWindow to automatically handle a user trying to paste multiple lines into a DataWindow Column where it can only have a single line or I need the paste event to fire when pasting into a DataWindow Column.



CR:733107
CR Number:   733107
Product Name:   PB Enterprise
Product Component:   Installation
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PB 12.5 installer outputs a dialog box with incorrect messages "EAS Demo DB V120" when the installer detects that SQL Anywhere is not installed on the machine.



CR:733175
CR Number:   733175
Product Name:   PB Enterprise
Product Component:   DW XML
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Mar 2013 Fixed
Description
Customer has XML that includes the following datetime format that fails validation when imported into a datetime column in a datawindow using ImportString



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

<searchDisbursementDataList>

<list xsi:type="searchDisbursementData" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<addDate>2012-12-17T09:36:18-07:00</addDate>

<busUid>1234567</busUid>

<disbTraceNumber></disbTraceNumber>

<disbursementAmt>000000</disbursementAmt>

<disbursementDate>2012-12-18T00:00:00-07:00</disbursementDate>



In the resolution for CR 290457 I see the following, customer says XMLSchema and XMLSchema-instance should be treated the same.



1. If the meta data type is XMLNone or XMLDTD then the datetime format is yyyy-mm-dd hh:mm:ss

2. If the meta data type is XMLSchema, one of the acceptable formats is yyyy-mm-ddThh:mm:ss where T is the letter to seperate date and time (speciifed in 5.4 of ISO8601)



CR:733182
CR Number:   733182
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2014 Presently Not Targeted For Any Future Release Of This Product
Description
When you have a webform datawindow with a phone number field

as string, aligned left and an edit mask of (###)###-#### and another string editmask

column aligned left with an edit mask of #####-####, once you tab into the edit mask

column and hit the End keyboard key, the cursor goes to the end of the edit mask. Then

hit tab again the cursor positions to the end of the next editmask field.



Also if you position the cursor in the middle of the editmask column and then

hit tab, the cursor will move to the middle of the next edit mask column.



CR:733709
CR Number:   733709
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2013 Fixed
Description
When you open a window containing a dw that calls a global function that returns a global variable, editing the global variables causes PB to crash.



CR:733727
CR Number:   733727
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Open
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer has the following questions:



1) Is it actually necessary for the four PB12.5 assemblies listed above to be registered in the GAC? Why? Is there any way to avoid it? We attempted to distribute those four in the self-contained folder but it didn抰 seem to find them, until they were GAC抎. Is there a way to get our PB app to find and use these assemblies in the self-contained folder, without GAC抜ng them, as MS suggests should be possible (even preferable) above?

2) Why do the four Assemblies listed above report their version as 12.5.0.0 even after we upgraded them for 12.5.1? Is this because there抯 an implication that all 12.5.x versions are backward compatible and a more-recent version will always work with older executables?

3) If we do need to GAC them, how do we manage multiple PB apps which need to co-exist on the same client machine, when they may have been built with different versions of PB? Assuming the answer to #2 is 搚es, then it sounds like it should be safe to always GAC the latest versions. Even if a PB application was compiled with an earlier version of PB 12.5, the more recent GAC抎 assemblies should work fine. Can you confirm?



CR:733729
CR Number:   733729
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)
06 Jan 2014 Not a Bug
Description
PB crashes when closing a window with the ms webbrowser control.



Microsoft provided the following feedback:

mshtml!ClearInterfaceFn+0x9:

643801fc 8b01 mov eax,dword ptr [ecx] ds:002b:0aff4adc=00000000 労================== note this address 0x0aff4adc is supposed to be a VTABLE containing the location for the Release method in that pbvm125 component but it does not look to be a valid memory address



the crash is due to customerˇs component pbvm125.dll executing a method at an invalid memory address



CR:733888
CR Number:   733888
Product Name:   PB Enterprise
Product Component:   WPF Script Editor
Status:   Open
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In PB 12.5 .NET the script editor doesn抰 show the ActionScript IntelliSense of System.Net.Mime.MediaTypeNames.Image.Jpeg as it does in VS 2010



As a workaround, you can use it directly without build error: s=System.Net.Mime.MediaTypeNames.Image.Jpeg



CR:733968
CR Number:   733968
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows 7
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2013 Fixed
Description
Importfile() returned -1 to Empty File.



CR:734047
CR Number:   734047
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Open
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OS: Windows 7 (both 32 and 64-bit)

Versions and Build #s Tested: PB 12.5.1_4953

Database/Driver File/Version: N/A



Comments:

Regression from PB 12.5.1_4595. When you try printing a datawindow for the 2nd time from within datawindow painter, printing fails with "Windows cannot print due to a problem with the current printer setup.".



CR:734305
CR Number:   734305
Product Name:   PB Enterprise
Product Component:   Migration
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Mar 2013 Not a Bug
Description
Customer has an application that runs up through PB 11.5.1 build 4788. Once he migrates to PB 12.5.1, application crashes with no error but the event viewer shows a crash in pbshr125.dll.



CR:734565
CR Number:   734565
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A webform ddlb on a dw will show ** in the column instead

of its value.



The PBDataWindowEnableDDDW is set to true. Also the website was added to the IE compatiblity view.



CR:735054
CR Number:   735054
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If there is a Line control in Header or Detail or Summary or Footer band of a Grid DataWindow,

an extra blank page may be printed out when you print the DataWindow.



CR:735420
CR Number:   735420
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Open
OS:   Windows 7
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When Customer open the window object over 25 using the PB IDE, the application is terminated abnormally due to an exception.



CR:735468
CR Number:   735468
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2013 Presently Not Targeted For Any Future Release Of This Product
Description
Customer is trying to call MS Exchange Webservices and cannot cast an object directly or using DynamicCast.

Using dynamiccast results in a runtime error.



R0023 Error: Cannot assign object of type n_cst_esb_messagetype to variable oftype n_cst_esb_itemtype at line 147 in function of_send_mail ofobjectn_cst_ews.



CR:735764
CR Number:   735764
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 15 May 2013 Fixed
Description
The function OleControl.InsertFile() fails if the length of the full pathname is larger than 128 characters long.



CR:735774
CR Number:   735774
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2013 Fixed
Description
Landscape orientation ignored if printername greater than 30 characters.



CR:736236
CR Number:   736236
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PB classic should be dpi aware. Currently, screen

resolutions can be different sizes and pb cannot detect that.



CR:736244
CR Number:   736244
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2013 Not a Bug
Description
Customer has an internally developed Sybase PowerBuilder 12 application. This has been running fine on XP and is deployed to 6-7000 users. They are migrating to Windows 7 64 bit and the application is experiencing significant slowdowns and is having a big customer impact to the point it is not usable.



pb.ini entry resolves the problem

[DataStore Behavior]

UseHwnd = no
Workaround Description
 pb.ini entry resolves the problem

[DataStore Behavior]

UseHwnd = no



CR:736338
CR Number:   736338
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2013 Added to user documentation
Description
The Users Guide APPENDIX B incorrectly states that the full ORCA tool kit is available to Sybase partners only.

It has been included in the enterprise product install in the PowerBuilder SDK\ORCA directory and the orca dll in the Shared\PowerBuilder directory.



CR:736348
CR Number:   736348
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Apr 2013 Fixed
Description
Customer has an application that displays tooltips with an expression. Once enabled and you move down the rows with the arrow keys, the tooltip is still displayed for rows not meeting the expression.



CR:736442
CR Number:   736442
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Open
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request: Support password protected certificates for web service client calls



CR:736450
CR Number:   736450
Product Name:   PB Enterprise
Product Component:   WCF
Status:   Open
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
* ENHANCEMENT * Allow WCF Wapper to add customized settings



Customer had question - Does the WCF client support using standard WCF config entries in config file?



Feedback from engineering:



"By design, Endpoint address and binding should be set in PB .

And now, we do not support custom bindings. We do not use

settings in the application configuration file ."



CR:736475
CR Number:   736475
Product Name:   PB Enterprise
Product Component:   WPF DW Painter
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
WPF Window target. Customer has an existing external datawindow. He adds a new string column in the DW painter. But at runtime he is unable to click in the new column and enter or edit data. The string length defaults to 0 (instead of 10 like classic) and it seems you are not able to change it. Any length changes revert back to 0. But that does not seem to be the main problem. You can change the length by exporting the srd, changing the source, and importing it back in, but the problem remains a run time. Can't enter or edit the new column.



CR:736549
CR Number:   736549
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2013 Workaround
Description
OS: Windows 7 32-bits

Versions and Build #s Tested: PB 12.5.1_4953

Database/Driver File/Version: SQL Server SNC 10 Client



Customer has a pfc PB app that, when clicking back and forth between two datawindows, application crashes. The issue happens with the P-Code exe generated, only. It never happens when inside PB IDE.
Workaround Description
 I found a workaround: if oyu disable "Windows classic style" from project p_genapp_exe, then the exe works fine and doesn磘 crash any longer.



CR:736647
CR Number:   736647
Product Name:   PB Enterprise
Product Component:   WPF Compiler
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2013 Fixed
Description
Customer tried to create a PB.Net Assembly target that uses iTextSharp. Resulted in illegal datatype compile errors. This works in Visual Studio.



CR:736788
CR Number:   736788
Product Name:   PB Enterprise
Product Component:   DB Informix
Status:   Open
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The customer is using UpdateBlob and SelectBlob to get and retrieve a Word document saved as a blob in Informix. In PB 9 he did this with an Informix column of type text. But now in PB 12.5, the text column is no longer working. It does work with a byte column, but he needs the text column to work to access the existng database.



CR:736803
CR Number:   736803
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2014 Workaround
Description
After migrating application from PB 11.2 to PB 12.1,

application is crashing randomly:

FAULTING_IP:

pbvm120!FN_WndEraseBkgnd+1d9f

10bc0cbf 813abe400000 cmp dword ptr [edx],offset <Unloaded_dll>+0x409d (000040be



CR:736912
CR Number:   736912
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
DW Modify destroy column syntax does not work correctly for example if destroying columns in the middle of a column range - we destroy the columns and while we calculate the new column count that is correct, it seems that we cannot get the column array to move correctly so that we cannot report the column names correctly anymore.



CR:736921
CR Number:   736921
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 May 2013 Not a Bug
Description
JBoss 6.0.1 WSDL file use different notation and hence .NET engine webservice proxies are not created correctly, but it worked fine for WSDL file from JBoss 5.1.2.



Since we are using underlying wsdl.exe from microsoft to generate the needed classes we can spot differences in the output of wsdl.exe.

The question is if this can be changed, ie. to enable generation of proxies with jBoss 6 wsdl files or if there are other methods to make jBoss to generate different/backward compatible wsdl file structure.



CR:736934
CR Number:   736934
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Open
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2013 Fixed
Description
Commit command returns 0 and looks like it works successfully. However, when I check the database using SQL Plus or SQL Developer, the new record is not there. If you wait a few minutes the record will appear. Customer thinks the autocommit of the data source eventually kicks in.



CR:737238
CR Number:   737238
Product Name:   PB Enterprise
Product Component:   Install
Status:   Open
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
EBF installer can not find the correct Shared folder name.



CR:737269
CR Number:   737269
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
Does Powerbuilder supports MS Data Execution Prevention feature.



CR:737371
CR Number:   737371
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Open
OS:   Windows 7
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A Web Service deployed to Tomcat is returning an array of classes, but a DataWindow with this Web Service as datasource does not retrieve any data from it.



CR:737494
CR Number:   737494
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Open
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request to be able to sort the DataWindow with similar results as the SQL Anywhere sortkey() function



CR:737500
CR Number:   737500
Product Name:   PB Enterprise
Product Component:   WPF Compiler
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2013 Fixed
Description
Unknown error when doing a full build on classes that implement interfaces. Repro'd with Extensibility.IDTExtensibility2 interface.



CR:737502
CR Number:   737502
Product Name:   PB Enterprise
Product Component:   WPF DW Painter
Status:   Open
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer is requesting an enhancement to have custom controls show binding rather than separate retrieve options.



CR:737710
CR Number:   737710
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows 7
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.1 20 Jun 2013 Fixed
Description
GetFullState on a datastore with a crosstab datawindow object returns a -1 in PB 12.1 but does not in PB 12.5. Works with other datawindow presentation styles such as tabular.



CR:737711
CR Number:   737711
Product Name:   PB Enterprise
Product Component:   Toolbar
Status:   Closed
OS:   Windows XP
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2013 Fixed
Description
Toolbar icons disappear after customizing PowerBar1.



When you add the icons back to PowerBar1 and restart PB. The icons are still missing.

It will only show 2 icons.
Workaround Description
 From SCN, it states to delete the toolbar entry in the registry and everything will be reset.



I was able to get the toolbar settings back by deleting the following:

hkcu\software\sybase\powerbuilder 12.5\toolbar\1000 12



Although TedZ had a customer do the following to get the toolbar back:

set \\HKEY_CURRENT_USER\Software\Sybase\PowerBuilder\12.5\Toolbar\1003 1\Items = "1268 -1 1270 1272 -1 1324 1326 1328 -1 1334"



CR:737760
CR Number:   737760
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Sep 2013 Fixed
Description
Oracle Error ORA-12704: character set mismatch when compiling script in embedded sql select with host variable with N prefix ie. ls_host="N'c1 default'" and

SELECT Coalesce (c1,:ls_host)

INTO :ls_c1 FROM t1 WHERE pk = :ll_pk;



CR:737908
CR Number:   737908
Product Name:   PB Enterprise
Product Component:   DB DB2
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2013 Consult Complete
Description
Customer is seeing the following error:



Select ErrorL SQLSTATE = 42886

[IBM][CLI Driver][DB2/NT64]SQL0469N The parameter mode OUT or INOUT is not valid for a parameter in the routine named 揇B2CONCT with specific name

揋LTCDEV.DB2CONCT(parameter number 2, IPARM2). SQLSTATE=42886



When calling the COBOL stored procedure with the following syntax:



EXECUTE GLTCDEV.DB2CONCT IPARM1 = 'RR70382 CAREDB 2164491642W', IPARM2 = ' RR700110442781';



CR:737989
CR Number:   737989
Product Name:   PB Enterprise
Product Component:   Section508
Status:   Open
OS:   Windows XP
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.1
Description
Ability to dynamically turn accessiblity message on or off.



When third party accessiblity software is running in the background, it causes PB to

send accessiblity messages (WM_GETOJECT). The outcome is it floods the third party

software message queue and causes PB and the third party software, OneClick to hang.



CR:738006
CR Number:   738006
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)
06 Jan 2014 Presently Not Targeted For Any Future Release Of This Product
Description
Formatting issues with nested reports in 12.5.2 using

datawindow.PushCutControlToNextPage=yes



RESOLUTION: Not a bug controls exceed page.



CR:738017
CR Number:   738017
Product Name:   PB Enterprise
Product Component:   WPF Runtime
Status:   Open
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer is trying to use third party SyncFusion WPF controls in a PB .NET application and has run into some issues and also has questions.



Customer is writing an event handler from the SyncFusion WPF controls DockingManager. The ActiveWindowChanged event passes in a reference to old and new windows cast as System.Object.



Customer has a workaround that works but believes it should not be necessary. There should be a language method or property that implements it. See below:



PB WPF controls often must interact with Microsoft and 3rd party controls. When they do so, the MS or 3rd party control interacts with the PB's InnerControl generally as a System.Window.Framework element or sometimes just as a System.Object. When coding in 3rd party control's event handler, the reference is typically know as Sender cast as a System.Object or as an ArgumentObject parameter of type System.Object.



It should be possible to write code such as this:



UserObject luo



luo.innerclass = Sender

luo.GetPBClass( ) <<this should get the PB reference into the variable luo



luo.triggerevent('ue_customevent') //<<All PB class members should now be available



CR:738102
CR Number:   738102
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Open
OS:   Windows 8
Original Version:   12.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A EAServer 6.3.1 \ PowerBuilder 12.1 application crashes with PowerBuilder heap panics.



CR:738358
CR Number:   738358
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 30 May 2013 Fixed
Description
The issue is an extension of CR 726695 on useDefaultKeyboardLayout=yes and inconsistent behavior.



For a certain datawindow after clicking on a first column and switching to Russian and entering some characters then clicking on a second column; the keyboard stayed in Russian instead of switching to the default US input.



But on the same datawindow the same test without clicking on the second column but clicking on the fourth column the keyboard switched to default as expected.



CR:738361
CR Number:   738361
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2013 Fixed
Description
When using Windows APIs (SetProcessDefaultLayout , SetLayout) to change the layout of an application from LeftToRight to RightToLeft, background position for a GroupBox inside a DataWindow does not change and remains in its original place



CR:738366
CR Number:   738366
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2013 Not a Bug
Description
In customer site adding a Custom visual object on a Inherit windows causes a crash in windows 7, the same action in windows XP works with no problem.



Cannot be reproduced in some enviroments. Crash dump analysis required.



CR:738516
CR Number:   738516
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2013 Consult Complete
Description
Response Windows and Popup Windows don't mirror when SetLayout is changed to RTL



CR:738623
CR Number:   738623
Product Name:   PB Enterprise
Product Component:   WPF Runtime
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 May 2013 Not a Bug
Description
Customer put MS controls inside a PB CVUO already containing PB controls and then dynamically skinned the Window with a custom skin. All the Non-PB controls get skinned-including the MS and SF controls included in the window - but NOT any PB controls.



CR:738757
CR Number:   738757
Product Name:   PB Enterprise
Product Component:   Menus - Runtime
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jun 2013 Fixed
Description
Contemporary Menu Style displayed wrongly when SetLayout is changed to RightToLeft



CR:738759
CR Number:   738759
Product Name:   PB Enterprise
Product Component:   DW Rich Text
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2013 Fixed
Description
DataWindow RitchText Edit Style for a column not accessible when SetLayout is changed to RightToLeft



CR:738765
CR Number:   738765
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows 7
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2013 Fixed
Description
The position of the DataWindow control changes when resizing the control after SetLayout is changed to RightToLeft.



CR:738866
CR Number:   738866
Product Name:   PB Enterprise
Product Component:   PB.NET WebForm
Status:   Open
OS:   Windows 8
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Product: PowerBuilder 12.5.1_4953

OS: Windows 8 64bits

IIS version: 6.2



Comments: After deploying web forms application, when running the web forms app, it gets stuck prior to entering 1st screen and then we see the following error messages on Event Viewer after a while:



- System



- Provider



[ Name] Application Error



- EventID 1000



[ Qualifiers] 0



Level 2



Task 100



Keywords 0x80000000000000



- TimeCreated



[ SystemTime] 2013-04-05T18:11:58.000000000Z



EventRecordID 1396



Channel Application



Computer alorenzo-HP



Security





- EventData



w3wp.exe

8.0.9200.16384

5010885f

ntdll.dll

6.2.9200.16384

5010ae7a

c0000374

000da947

6dc

01ce32290f673056

C:\WINDOWS\SysWOW64\inetsrv\w3wp.exe

C:\WINDOWS\SYSTEM32\ntdll.dll

4e059dd9-9e1c-11e2-be6b-28924acac2b1





And also the following http errors are displayed on IIS httperr1.log:



2013-04-03 01:43:04 ::1%0 58478 ::1%0 80 HTTP/1.1 GET /adela/default.aspx?clientWidth=1584&clientHeight=797 - 1 Connection_Abandoned_By_ReqQueue PBDotnet4AppPool

2013-04-03 01:43:22 ::1%0 58480 ::1%0 80 HTTP/1.1 GET /adela/default.aspx?clientWidth=1600&clientHeight=743 - 1 Connection_Abandoned_By_ReqQueue PBDotnet4AppPool

2013-04-03 01:43:28 ::1%0 58481 ::1%0 80 HTTP/1.1 GET /adela/default.aspx?clientWidth=1600&clientHeight=743 - 1 Connection_Abandoned_By_ReqQueue PBDotnet4AppPool

2013-04-03 01:43:34 ::1%0 58483 ::1%0 80 HTTP/1.1 GET /adela/default.aspx?clientWidth=1600&clientHeight=743 - 1 Connection_Abandoned_By_ReqQueue PBDotnet4AppPool

2013-04-03 01:43:34 ::1%0 58508 ::1%0 80 HTTP/1.1 GET /adela/default.aspx?clientWidth=1584&clientHeight=797 - 1 Connection_Abandoned_By_ReqQueue PBDotnet4AppPool

2013-04-03 01:43:40 ::1%0 58509 ::1%0 80 HTTP/1.1 GET /adela/default.aspx?clientWidth=1584&clientHeight=797 - 1 Connection_Abandoned_By_ReqQueue PBDotnet4AppPool

2013-04-03 01:43:47 ::1%0 58513 ::1%0 80 HTTP/1.1 GET /adela/default.aspx?clientWidth=1584&clientHeight=797 - 1 Connection_Abandoned_By_ReqQueue PBDotnet4AppPool

2013-04-03 01:45:40 ::1%0 58514 ::1%0 80 - - - - - Timer_ConnectionIdle -

2013-04-03 01:47:36 ::1%0 58579 ::1%0 80 HTTP/1.1 GET /adela/default.aspx?clientWidth=1584&clientHeight=797 - 1 Connection_Abandoned_By_ReqQueue PBDotnet4AppPool

2013-04-03 01:47:43 ::1%0 58580 ::1%0 80 HTTP/1.1 GET /adela/default.aspx?clientWidth=1584&clientHeight=797 - 1 Connection_Abandoned_By_ReqQueue PBDotnet4AppPool

2013-04-03 01:47:49 ::1%0 58584 ::1%0 80 HTTP/1.1 GET /adela/default.aspx?clientWidth=1584&clientHeight=797 - 1 Connection_Abandoned_By_ReqQueue PBDotnet4AppPool

2013-04-03 01:47:55 ::1%0 58583 ::1%0 80 HTTP/1.1 GET /adela/default.aspx?clientWidth=1584&clientHeight=797 - 1 Connection_Abandoned_By_ReqQueue PBDotnet4AppPool

2013-04-03 01:48:01 ::1%0 58587 ::1%0 80 HTTP/1.1 GET /adela/default.aspx?clientWidth=1584&clientHeight=797 - 1 Connection_Abandoned_By_ReqQueue PBDotnet4AppPool

2013-04-03 01:52:08 ::1%0 58701 ::1%0 2869 - - - - - Timer_ConnectionIdle -



The same web forms app display the 1st screen fine when using Windows 2003 Server 32bits instead.





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