Sybase Rollup EBF 14223 ======================= -------------------------------------------------------------------------------- December 7, 2006 Sybase, Inc. One Sybase Drive Dublin, CA 94568 1-800-8-SYBASE (North America) Web: http://www.sybase.com Dear Customer: Enclosed please find: EBF 14223 for the following platform: Windows x86 32-bit This EBF is part of this release: PowerBuilder 10.5.1 (6537) This EBF contains updates for the following product(s): PowerBuilder Enterprise PowerBuilder Desktop PowerBuilder Professional We recommend that you install this EBF as soon as possible. In response to customer requests, PowerBuilder Emergency Bug Fix (EBF) releases are now generally available to all PowerBuilder customers, and include a setup program (for PB Enterprise, Professional, and Desktop versions, as well as InfoMaker) to make the EBF installation process easier. ------------------------------------------------------------------------------ IMPORTANT: Sybase recommends that customers exercise caution when using these EBFs. Sybase does not encourage their use unless: You have encountered a problem and you want to determine whether or not it has been resolved in the latest EBF build. OR You know that a fix you require is in a given EBF, because it is included in one of the HTML fixed lists provided on the site, or a member of the Sybase Support staff has informed you that it has been fixed in the EBF. Be sure to read the readme file included in each zip file for important up-to- date information specific to that EBF. These readme files also include information about customer testing requirements, the amount of QA testing that was performed on the EBF build, EAServer compatibility (for those customers who use both PowerBuilder and EAServer), as well as additional software requirements, installation instructions, deployment and supportability details, etc. ----------------------------------------------------------------------------- Sybase may remove an EBF from the Sybase downloads site if a severe regression is identified/reported that could potentially adversely affect the majority of the PowerBuilder customer base. We appreciate your patience while we resolve problems in the product and your willingness to install this EBF. Please contact Technical Support if you encounter any problems using this product and let them know that you are using this EBF. This documentation includes these sections: * General Information and Technical Notes * Platform Specific Details * Loading Instructions * New Fixes in this EBF * All Fixes Included in this EBF (EBF14223_Buglist.txt) * List of Files in this EBF (EBF14223_Filelist.txt) Sincerely, Sybase Engineering -------------------------------------------------------------------------------- General Information and Technical Notes --------------------------------------- This section contains general and technical information about this EBF. The files included in this EBF are 32-bit from PowerBuilder 10.5.1 EBF Build 6537 (Post 10.5.1). Dear Sybase Customer, Please note that you are being provided with an EBF release of the Sybase software you requested. In addition to the fixes from the previous scheduled release of the product (GA, Interim or EBF release), this EBF release contains a fix designed to address your particular reported problem. Please note that this release has undergone minimal testing; it has not been subjected to the Sybase QA team's customary standard suite of tests. It is a requirement that you upgrade to the next official PowerBuilder release on http://downloads.sybase.com as soon as it is available. In addition to securing fixes to other problems included in the official release, you will then have a release that has undergone more intensive QA testing. In the interim, please backup your installation, as you normally would do prior to making any updates to your install. Likewise, Sybase recommends testing your application(s) with the patch prior to using it in production. Sincerely, Sybase Technical Support IMPORTANT NOTES: --------------- This 10.5.1 EBF build has received manual and automation QA testing. It is being provided on an Emergency basis. If you decide to use this EBF it will be necessary for you to retest your entire application. By applying these files, you agree to upgrade and apply the next Generally Available public release. New Behavior: ------------- In PowerBuilder 9.0.3, 10.2.1, and 10.5.x EBFs released after July 8, 2006, when you use the OLE DB database interface with a Microsoft SQL Server database and retrieve data into a DataWindow or use an embedded SQL cursor in a SELECT statement, server-side cursors are used to support multiple command execution. If this has a negative impact on performance, try increasing the size of the Block database parameter to 500 or more, or adding the following line to the [Microsoft SQL Server] section in the PBODBnnn.INI file to turn off server-side cursors: ServerCursor = 'NO' New Feature: ------------ Custom Header Support for .NET Web Services ------------------------------------------- The current PowerBuilder EBF adds support for custom SOAP headers in .NET Web services. The PowerBuilder .NET Web Service proxy generator creates a structure for methods of the Web service that require authentication information transmitted in the SOAP header. The number of fields in the generated structure, and their datatypes, depend on information contained in the Web service's SOAP header class. The name of the generated structure consists of the prefix, if any, that you assign to the Web service proxy, and the name of the SOAP header class for the Web service. For example, if you assign "ws_" as the proxy prefix and the SOAP header class name is "Authentication", then the generated structure name will be "ws_Authentication". The proxy generator also creates at least one function for passing authentication values in or to the generated structure. The type of function or functions created is determined by the direction parameter in the Web service SOAP header class. The direction can be "in", "out", or "inout". If the direction is "in", the PowerBuilder .NET Web Service proxy generator creates a function you can use to pass the generated structure to the Web service after populating the structure with authentication values. The name of this function consists of the name of the Web Service SOAP header class with a "set" prefix and a "value" suffix. For the example with the SOAP header class named "Authentication", the syntax for the function is: boolean setAuthenticationValue (ws_Authentication AuthenticationValue) The return value is true for success, and false for failure. In this example, AuthenticationValue is a variable for the generated structure that you submit to the Web service in a custom header. If the value of the SOAP header direction parameter is "out", the PowerBuilder .NET Web Service proxy generator creates a function you can use to get information back from the SOAP header in a Web service call. The name for this function consists of the name of the SOAP header class with a "get" prefix and a "value" suffix. For the example with the SOAP header class named "Authentication", the syntax for this function is: ws_Authentication getAuthenticationValue ( ) For the same example when the SOAP header direction parameter is "inout", both the setAuthenticationValue and getAuthenticationValue functions are created. You can call these functions in PowerScript to set and return authentication values in a custom SOAP header. Platform Specific Details ------------------------- This section contains platform specific details of this EBF. PB: The minimum requirement for applying this EBF is the PB 10.5 (Build 4523). EAServer: N-tier Application testing was run against EAServer 5.3.0 GA (Build 53016) on Windows 2003(SP1) and Windows XP(SP2). Failure to upgrade EAServer to the appropriate version may result in corruption of data. ***This EBF Release includes a file called libjcc.dll. The version of this file included in this distribution is intended for use with PowerBuilder only. You should continue to use the libjcc.dll installed in your %EAServer%\dll directory with EAServer. Do not replace %EAServer%\dll\libjcc.dll with the file in this distribution. Running PB Components in EAServer: To run PowerBuilder components in EAServer, the runtime dynamic shared libraries for the version of PowerBuilder in which the components were developed must be available on the server. The PowerBuilder runtime files on the client and the server must be at the same build level. Using different build levels on client and server machines may result in unpredictable behavior or data corruption. Loading Instructions -------------------- This section contains instructions for loading the new software onto your system. You should shut down any applications and back up the files in the directories below before copying over the new files. To use these DLLs, backup the shared and deployment directories, then add the new files included in this EBF zip file to the same directories. After applying the EBF DLLs, it is highly recommended that you perform a Full Rebuild of your application in the Library Painter (Run->Full Rebuild). This will rebuild all objects and will insure that all descendant objects are in sync with their ancestors. Also, if you do not do a Full Rebuild, compiler fixes will not be reflected in your code. You will also need to do a full retest of your application using this EBF build. These DLLs are considered an interim patch. However, they are deployable and supported. Question: What is meant by "supported"? Answer: If you encounter a regression (i.e. something that worked previously and is now broken) as a result of using these pre-release DLLs, please report the problem and include the EBF build number that you are using. When a new EBF build is available that addresses the regression, it will be necessary for you to replace ALL of your EBF DLLs with the new set of EBF DLLs. Also, if you are already using any other EBF DLLs, it is a requirement that all EBF DLLs on your PC must be replaced with DLLs from the same EBF build number. This requirement is due to the fact that there are links and dependencies between EBF DLLs. If all EBF DLLs on your PC do not come from the same build number, unexpected/undesirable behavior will result. New Fixes in this EBF --------------------- The following is a list of fixes which are specific to this EBF. The list is sorted by the component in which the bug was fixed. For a complete list of fixes in this EBF, see EBF14223_Buglist.txt. Component BugID Description ---------------- ------ ---------------------------------------------- DB Informix 439990 A stored ANSI format BLOB that gets selected via SELECTBLOB will be returned as a.) if short as a ANSI formatted BLOB b.) if longer than as a UNICODE formatted BLOB. DB ODBC 439887 Using Numeric retrieval args against a DB Int column will sometimes not work. The data is not found. DB OLE DB 447474 The customer is connecting to an MS SQL Server databasse via OLE DB. When retrieving from tables that have text datatypes he is seeing very slow performance relative to what he saw in PB 8. My testing here shows that PB 10.5 is about 20 times slower than PB 8! I tested with PB 10.2.1 and see the same faster retrievals as in PB 8. In PB 10.5 I increased the block size to 1000, and set ServerCursor='NO' in the PBODB105.ini file, but neither of those had any impact on retrieval time. I did notice that in the Datawindow painter in PB 10.5 if I retrieved in the preview pane, it's fast. But at runtime retrieving the datawindow is slow. I did PB traces but could not see anything different except slower times. DB OLE DB 446522 Using OLEDB to call RPCFunc does not prevent padding of char columns. PBTrimCharColumns='YES' is in the pbodcXX.ini. Using code of: ls_ret = space(5) ls_val = "ab " u_tran. sp_test(ls_val, ref ls_ret) function long sp_test(string input_char5,ref string output_char5) RPCFUNC ALIAS FOR "dbo.sp_test" DB Oracle 441788 Ct is using PBO10105.dll for connecting Oracle 10g provided to ct. When ct executes the proc, he gets error ORA-06650 (PLS-00703) DB Oracle 440866 Datawindow is not able to save data as OEM cp866. Only ANSI and Unicode is available DB Oracle 438942 Arabic Data saved in PB 8 is being displayed as Junk characters in PB10.x Unicode after migration. No workaround DB Sybase System 441652 Arithmetic overflow during implicit conversion of DATE value '01 Dec 1700' to a Datetime field. This error occurs when selecting a Hijri date through the SYC interface. ASE date/time type is an ASE1251 new feature. Therefor the appropriate client must be installed dbparm ''Release='12.5.1''' or higher must be set for this feature to work. DB Sybase System 441359 From the PowerBuilder and InfoMaker IDEs, in a database profile for ASE, using the ‘Prompt for Database Information’ connection option, the call to the PB System Procedures is not getting made. This is causing Users not to see a complete Table list in the Database Painter. DW - Runtime 445317 Modify a ShareData DW causes a crash on a DeleteRow/RowsDiscard. DW - Runtime 442633 After an "item does not pass validation test" error the statements : Double d_test, Long l_long, d_test = 100. l_long = 50, d_test *= l_long lead into a wrong runtime error. DW - Runtime 441561 When previewing a composite report that contains a multinewspaper column group datawindow, any data beyond the first page is blank. Using 3 newspaper columns and 1 group. DW - Runtime 440954 When Nup Datawindow with protected columns, it is expected that keyboard Tab Key will place the edit focus correctly. However it is observed that "Tab" and "Shift + Tab" incorrectly place the focus. DW - Runtime 439800 Computed fields in a datawindow that refer to decimal columns are not computing. Works fine in previous versions as do other datatypes. I know decimal precision was increased in 10.5, so it looks like a regression was introduced. DW Display 440130 Extended attributed are not getting applied correctly when you build a datawindow where there are 2 tables with 2 different owners and the extended attributes are applied to the database columns. There are 2 display formats created: Mark = [RED]@@@@@@@@@@@@@@ Mike = [BLUE]@@@@@@@@@@@@@@ There are 2 tables: "OWNER1"."CUSTOMER" (Col_2 and Col_3 have Mike's display format) "OWNER2"."CUSTOMER" (Col_2 and Col_3 have Mark's display format) When you connect to the db (under owner2) and create a datawindow, the extended attributes are not getting applied properly. DW Display 439781 Treeview DataWindow does not stay expanded when deleting or inserting a row. DW Expression 440138 When using the new notation for a decimal constant (1.05d or 1.05D), causes incorrect calculations to occur. It appears the decimal point is completely ignored, so in the case of 1.05, the value used is actually 105. DW Expression 437397 retrieval argument not passed correctly to report when Dec separator is comma DW HTML 443502 Looking for customized javascript for Web Datawindow generation. Problem involves changes in date handling with format masks. DW HTML 441563 Customer sees 1/0/1900 value when tabbing out of a date field when the data should be Null. DW HTML 440578 The JavaScript function DW_TimeToString in a Web DataWindow has the following line: var i = inStr.length(); which causes a syntax error because length is not a JavaScript function, it's a property. A second issue is the argument theTime is declared but not used. This is not a huge problem, but it's not clean code and if you look at the 'sister' methods of DW_DateToString and DW_DateTimeToString, neither have arguments. DW Painter 442962 PB IDE crash when assigning ext dw object with no column DW Rich Text 440482 OS: Windows XP SP2 Versions and Build #s Tested: PB 10.5_5063, 10.5_5048 Database/Driver File/Version: EAS Demo DB V105 When migrating RichText Datawindow from PB 10.2.1 to 10.5, the column fields are converted to simple plain text. For instance, field {AU_LNAME} that is understood as a column in RichText DW in 10.2.1 is now just a plain text in 10.5. Documentation 436102 According to the Documentation ( PowerBuilder 10.5, Application Techniques, Chapter 41: Deploying Applications and Components )we expect several DLL's after installing PB 10.5. eg: For DataDirect OEM 5.1 SQL Server 6.5 PBSS621.DLL PBSS621R.DLL PBSS621S.DLL Jaguar 443022 When tabbing out of a column on a jsp page or in Integration dw painter, validation is firing incorrectly. The dw column is defined as char(9) and has a validation defined in the datawindow as: len(gettext()) < 10 The column has a display format defined as: @@@@@-@@@@ When entering the last portion of the zip code and tabbing out of the column causes the validation error to fire. Jaguar 440210 When INOUT parameters are not initialize before Integration calling Stored Procedure, will result in a ora- 03106: Fatal two task communication protocol error. No error when using space(XX): string ls_test1, ls_test2 ls_test1 = space(50) ls_test2 = space(50) lds_sp = Create n_datastore lds_sp.DataObject = 'd_sp' lds_sp.SetTransObject(SQLCA) ll_rc = lds_sp.Retrieve(li_test, ls_test1, ls_test2,'c','d', 'e',1) Jaguar 440043 Consult: EAServer is crashing with unknown root Integration cause after migrating from PB 9.0.3 to PB 10.5. Language - 444257 With PB 10.2.1, the results of the same Runtime calculation using Double datatype vs. Decimal datatype are very close. Using later builds of 10.5 and 10.5.1 the results are quite different: MessageBox("Results", "As double: " + String(double(35878.378302)/double(45878.378302)) + "~r~nAs decimal: " + String(35878.378302/45878.378302)) Language - 441434 DW performance on a tablet PC is severly degraded Runtime due to response to WM_GETOBJECT messages generated from the Tablet's Input Panel Language - 440304 The backquote notation to refer to ancestor Runtime subtypes crashes in PowerBuilder 10.5 Builds after the GA release. Library Painter 430172 OS: Windows XP SP2 PB Version and Build: PowerBuilder 10.5_5034 DB/DLL: N/A Comments: When regenerating one of the objects inside a PBL, sometimes the regeneration returns the following error message: Assertion Failure Invalid type in cm_intrisic_trim, file cmintrin.cpp, line 2905 Abort, Debug Break, Ignore? Sometimes, the regeneration goes fine, sometimes the above error happens. Menu Painter 442678 Menu Painter: For some menu properties, if a change is made to the property, and then the Edit- >Undo Property Change menu is selected, the change is not reflected in the WYSIWYG view. The property change is reverted, and will show if you click on the WYSIWYG view, but it does not reflect automatically in the preview the way it does when you make the change in the Properties view. Menus - Runtime 446549 Using the "Windows XP" theme for the desktop settings, dragging the mouse pointer up and down a submenu off of a main menu, sometimes the window titlebar flickers. Menus - Runtime 445583 Customer has an application with menu items that have toolbar item bmps assigned using a relative path: for example, the bmp file is assigned as "bmp\open.bmp" where the leading "bmp" is a subdirectory of the folder where the workspace/target/pbl reside. This works okay until the application executes a ChangeDirectory, and then the bmps from the toolbar disappear. OLE - Active X - 443293 Crash in pb 10.5 following migration from pb 10 OCX when using a olecontrol userobject to integrate their application with MS Word. PB DOM 442852 Result from using AddNamespaceDeclaration() is incorrect, XMLNS missing PBNI 434861 PB 10.x. Application runs as Windows Service written in C++. It listens for a TCP connection from another Service. Windows Service written in C++, "Connection Closed by Host". Analysis of dump files shows that error was occurring in pbshr100 / 105.dll. Pipeline Painter 446411 Carriage returns removed from SQL in pipeline painter when moving from graphical view to syntax view within the pipeline painter. Printing 438364 Looked like CR 390230, However the crash is still occurring Printed a report with long printer name (over 31 Characters). When they close the report window Application crashes. We have used the PB Build. Printing 438361 Customer finds that her printing application crashes intermittently. Rich Text 444434 RichTextEdit control does not save margin properties selected to PDF in PB10.5 Toolbar 440663 The X and Y properties are not being updated when the toolbar is in the 'Float' position. When a custom event is mapped to the pbm_move and you have the following script: integer li_xpos integer li_ypos string ls_microhelp li_xpos = this.x li_ypos = this.y ls_microhelp = " window.x: " + String ( li_xpos ) + " window.y" + String ( li_ypos ) this.Setmicrohelp( ls_microhelp ) Once you change the MDI Toolbar to 'Float' and Show Text is enabled, the this.x and this.Y are not getting updated. UO - Runtime 440003 GetUrl returns 1 or cause gpf if connetion is broken during the download Web Wizards 442880 * JFS1051 When a PB component is deployed with a PB project on EAS6 as a Web Service, it does not appear in the Web Services Collection of EAServer 6.0. Web Wizards 442547 Problem: EasySoap Web Proxy generated for a UO Business Service is creating invalid syntax causing a failure to import the proxy syntax. With the .NET Web Service implementation, the proxy can be generated and the service invoked successfully. Window - Runtime 442776 Moving a toolbar menu icon effecting the powerscript move function so that the x and y values of the moved control are not correctly updated. Workaround is to set the x and y values in script instead of using the Move function. Window - Runtime 442177 Customer is experiencing treeview display issues when working with Dual monitors. Window Painter 440115 Code structures in NVOs. Declare the structure in another object using the accent: uo_test`str_test lstr_test. Compiler returns "C0001: illegal data type: d`window" then PB crashes down.