============================================================================ Readme File for iSeries Access for Windows Service Packs 5722-XE1 V5R4M0 Cumulative Service Pack Level ------------- SI35287 ------------- (c) Copyright IBM Corporation 2008. All rights reserved. ======================================================================== SI35287 can be installed on any PC/server that is at V5R4 service level SI20465 or newer. See iSeries Access for Windows Properties in the IBM iSeries Access for Windows folder to determine current service level. Previous service pack readmesp.txt files can be downloaded from the following website: ftp://ftp.software.ibm.com/as400/products/clientaccess/win32 Select the directory for the release, then the "servicepack" directory, then the service pack PTF number. In each such directory will be the readmesp.txt file. Since the full problem description text for each APAR is not carried forward into the next service pack's readmesp.txt file, you may want to download such files to read details about these earlier fixes. Windows Vista Support --------------------- Starting with service pack level SI25949 iSeries Access for Windows supports running on Windows Vista. There are a few issues you should be aware of when installing on a PC with Windows Vista: First, using Check Service Level or Install Service Pack from a service level prior to SI25949 to install this service pack (SI35287) is not supported on Windows Vista. Please see section 1.0 INSTALLATION INSTRUCTIONS for details about other methods of installation for the service pack, either by running setup.exe or setupsp.bat. Another issue concerns how the Check Service Level function works once this service pack has been installed on a Windows Vista PC. Check Service Level determines whether there is a more recent version or service pack of iSeries Access for Windows available at a configured location, than is currently on your PC. Due to a Microsoft restriction new in Windows Vista, programs that run at logon time may not use administrator authority, and may not launch other programs that do. Because Check Service Level launches applications that require administrator authority (such as Service Pack install), it may not run at logon time. Settings in iSeries Access for Windows Properties that control how often Check Service Level runs at logon time will be ignored on Windows Vista. To run Check Service Level manually, click Start, All Programs, then iSeries Access for Windows, then Service, then Check Service Level. Another issue has to do with the Welcome Wizard. If you run the setup.exe program to install the entire product along with the service pack, you will have the opportunity at the end of the installation to choose whether you want the Welcome Wizard to be launched at the next logon or not. Because the Welcome Wizard uses the Microsoft WinHelp engine to display its contents, if you are installing on a Windows Vista PC, the Welcome Wizard will not work unless you have downloaded the WinHelp engine from Microsoft's website and installed it on the PC. If you have not done this, when you next logon, you will receive a message from Windows Vista stating that you cannot get help from the program because it uses the WinHelp engine, which is no longer shipped with Windows Vista. This can be a nuisance, especially when the Welcome Wizard is automatically launched at every logon. Therefore, you may, at install time, elect not to have the Welcome Wizard run at logon time, by unchecking the appropriate checkbox. The logon-time run of the Welcome Wizard can be re-enabled from the "Other" tab of iSeries Access for Windows Properties, once the WinHelp engine has been installed on the PC, if you wish. If you already chose to run the Welcome Wizard at logon, you can disable this via the "Other" tab as well. A third issue is related to installing from the applied iSeries PTF. Once the PTF is applied, you can install this service pack or complete merged image from the network share called QIBM on your iSeries system. Accessing this share uses the LAN Manager component of Windows, and NetServer support on the iSeries server. In Windows Vista, Microsoft has changed the default negotiation method for such connections, so that, at this time, accessing shares on the iSeries system will fail. One way to work around this problem is to change a policy setting on the PC. This action requires administrator authority, and can be performed as follows: 1) Click Start, click All Programs, click Accessories, click Run; then type "secpol.msc" (without the quotes) in the Open text box, and click OK. 2) If a User Account Control dialog box appears. verify that the details shown match the request you initiated (you are starting the Microsoft Management Console), and if so, click Continue. 3) From the Local Security Settings console tree, expand Local Policies, then click Security Options. 4) In the right pane, scroll down to the setting called "Network security: LAN Manager authentication level Properties" and double-click it. 5) Note the current value. The default value at the time of this writing is "Send NTLMv2 response only" If the value is not as follows, change it to be: "Send LM & NTLM - use NTLMv2 session security if negotiated" then click OK, and exit the Local Security Settings console. You should now be able to access network shares on the iSeries system. The last issue has to do with installing from a network share. Testing has shown that, in some cases, installing iSeries Access for Windows on a Windows Vista PC from a network share, fails. In such cases, copying the files from the network share to the PC's local hard disk, then re-starting the installation from the local hard disk, completes successfully. The cause of this failure is being investigated. There are other issues, known problems, and details regarding how iSeries Access for Windows works on Windows Vista, that IBM highly recommends that you read about. See information associated with APAR SE27507, and read Information APAR SI14239, so you are prepared to run iSeries Access for Windows on Windows Vista. NOTICE: ------- Application of this PTF may disable or render ineffective programs that use system memory addresses not generated by the IBM translator, including programs that circumvent control technology designed to limit interactive capacity to purchased levels. This PTF may be a prerequisite for future PTFs. By applying this PTF you authorize and agree to the foregoing. This PTF is subject to the terms of the license agreement which accompanied, or was contained in, the Program for which you are obtaining the PTF. You are not authorized to install or use the PTF except as part of a Program for which you have a valid Proof of Entitlement. SUBJECT TO ANY WARRANTIES WHICH CAN NOT BE EXCLUDED OR EXCEPT AS EXPLICITLY AGREED TO IN THE APPLICABLE LICENSE AGREEMENT OR AN APPLICABLE SUPPORT AGREEMENT, IBM MAKES NO WARRANTIES OR CONDITIONS EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OR CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON INFRINGEMENT, REGARDING THE PTF. The applicable license agreement may have been provided to you in printed form and/or may be viewed using the Work with Software Agreements (WRKSFWAGR) CL command. ----------------- Table of Contents ----------------- 1.0 INSTALLATION INSTRUCTIONS 1.1 INSTALLING FROM AN iSeries SYSTEM 1.2 INSTALLING FROM A LOCAL OR NETWORK DRIVE 1.3 COMBINING THE SERVICE PACK WITH AN iSeries ACCESS FOR WINDOWS INSTALLATION IMAGE 2.0 RECOMMENDATIONS/RESTRICTIONS 2.1 iSeries SERVER FIXES 2.2 APPLICATION DEVELOPMENT FUNCTION WITHIN iSeries NAVIGATOR 2.3 iSeries NAVIGATOR DATABASES COMPONENT 2.4 JAVA RUNTIME ENVIRONMENT (JRE) 1.4.2 Service Release 8 (SR8) 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS - SERVICE PACK LEVEL = SI35287 (June, 2009) 4.0 INSTALL/UNINSTALL CONSIDERATIONS 4.1 REMOVING THE SERVICE PACK 4.2 UNABLE TO INSTALL FROM THE SERVICE SOURCE? 4.3 SERVICE PACK CONTROL 5.0 DATA TRANSFER CONSIDERATIONS 5.1 TRANSFERRING DATA WHEN THE FILE OR DATA CCSID IS 65535 --------------------------------------------------------------------- 1.0 INSTALLATION INSTRUCTIONS ------------------------------ 1.1 INSTALLING FROM AN iSeries SYSTEM -------------------------------------- The following method would be used if you have received the iSeries Access for Windows service pack through the iSeries PTF ordering process either as an individual PTF order or as part of an OS/400 PTF cumulative package. Once this service pack has been applied to an iSeries system with the LODPTF and APYPTF iSeries commands, it can be installed on individual PC's with the "Check Service Level" or "Install Service Pack" shortcuts in the iSeries Access for Windows Service folder. Check Service Level, controlled by the iSeries Access for Windows Properties Service tab, will detect that the Service source directory has been updated, and will present the user with the option to install the service pack at startup time as well. The APYPTF will update the iSeries Access for Windows install image directory (\QIBM\ProdData\Access\Windows\Install\Image) on the iSeries. Any client that installs iSeries Access for Windows (or selected components) from this image will automatically receive this service pack level (no extra steps or reboots). In this scenario, the service pack cannot be uninstalled on the client PC because it is merged in with the base release. Running setupsp.bat from the iSeries Access for Windows install image directory (\QIBM\ProdData\Access\Windows\Install\Image) will launch the service pack install wizard. View setupsp.bat via Notepad or Wordpad to see instructions on how to invoke setupsp.bat to record or run a silent service pack install. RMVPTF will restore your iSeries install image to the prior service level (or the base release if there was no prior service pack applied). 1.2 INSTALLING FROM A LOCAL OR NETWORK DRIVE --------------------------------------------- The following method would be used if you have received the iSeries Access for Windows service pack as a set of install image files via a download from IBM's FTP site. Install the service pack by running the "SETUP.EXE" program from your PC. This program is part of the install image files shipped with a service pack. If you change the iSeries Access for Windows Properties Service tab Source Directory to the directory containing these install image files, you can also use the "Check Service Level" or "Install Service Pack" shortcuts in the iSeries Access for Windows Service folder. Before running this program, copy the service pack install image files to a local drive on your PC or to any accessible network drive. Once the install setup program has completed, you can then remove the install image files from that drive. 1.3 COMBINING THE SERVICE PACK WITH AN iSeries ACCESS FOR WINDOWS INSTALLATION IMAGE ------------------------------------------------------------------------------------- The following method could be used if you downloaded the service pack image from the iSeries Access for Windows web page location: http://www-03.ibm.com/servers/eserver/iseries/access/casp.html The iSeries Access for Windows service pack PTFs are combined with the original iSeries Access for Windows installation image in QIBM\ProdData\Access\Windows\Install\Image NOTE: this directory is a symbolic link to QIBM\ProdData\CA400\Express\Install\Image There is one physical directory - either of these paths will access the directory. This means that a user can install (or upgrade) iSeries Access for Windows from this combined image directory and get the latest applied service level automatically in one integrated step - since the original installation image files have been replaced by updated versions via the service pack PTF. Selectively installing components from this combined image directory will also automatically get the latest applied service level for that component. If you tailored the iSeries Access for Windows install image to another directory (for instance, on another server), using the Create Tailored Installation Image (cwbinimg.bat) tool, you can use the PTFFORM.EXE download in the FTP directory to duplicate the function of applying the iSeries PTF by following these steps: 1. Download PTFFORM.EXE (from the tailored/ FTP directory) to a directory on your PC or server. 2. Run PTFFORM.EXE to automatically expand the service pack image files to a temporary directory. 3. You will then be prompted via a wizard panel to select the iSeries Access for Windows install image directory to update to the new service level. 4. The components that are contained in the target install image will be automatically updated to the new service level from the files in the temporary directory, and then the temporary directory will be removed. 5. After completion, you can delete the downloaded PTFFORM.exe file, as it is no longer needed. Now you have combined this service pack level with the iSeries Access for Windows installation image, so that users can install iSeries Access for Windows plus this service pack in one integrated step. Note that this procedure also works if the installation image has already been combined with a prior service pack level. This procedure will replace the prior service level in the combined image with this new level. Alternatively, if you have a full copy of the original iSeries Access for Windows install image in a directory, you can combine PTFFORM.EXE with this full image, using the same 5-step procedure detailed above. Then you can run Create Tailored Installation Image (cwbinimg.bat) from this full image directory, to create tailored image directories that will automatically have the service pack merged in. 2.0 RECOMMENDATIONS/RESTRICTIONS --------------------------------- 2.1 iSeries SERVER FIXES -------------------------- In addition to installing the iSeries Access for Windows Service Pack, all servers should stay current on the latest Cumulative PTF Package, HIPER Group PTF, and Database Group PTF. Refer to IBM eServer iSeries Technical Support: Recommended fixes at http://www-912.ibm.com/s_dir/slkbase.nsf/recommendedfixes 2.2 Application Development function within iSeries Navigator --------------------------------------------------------------- The Application Development folder within iSeries Navigator is added when the iSeries Navigator Network component is installed. Application Administration can be used to restrict the display of the Application Development folder to certain users or groups of users. 2.3 iSeries NAVIGATOR DATABASES COMPONENT ------------------------------------------ The 'Import Data' and 'Export Data' wizards in iSeries Navigator use the CPYFRMIMPF and CPYTOIMPF CL commands, respectively. The commands may function check with an MCH3402 message when executed by iSeries Navigator. The first time the wizards execute the command it will succeed, but later attempts may fail if the database host server job is reused for a later use of the wizard. The commands may fail with a CPF4248 message with reason code 3 for an ASCII or Unicode CCSID. This is an error in writing data to the error record file (ERRRCDFILE parameter on the CPYFRMIMPF command) if the data file is ASCII or Unicode. Lastly, a problem with system names that contain double quote characters has been identified. Apply the latest PTFs for CPYFRMIMPF and CPYTOIMPF on the server if you plan to use the 'Import Data' and 'Export Data' wizards. PTFs SI20896 and SI17385 for product 5722SS1 V5R3M0 are required. PTFs SI21418 and SI21459 for product 5722SS1 V5R4M0 are recommended. In V5R4M0, SQL Assist has been changed so that 'smart statement selection' can be used to pre-prime the SQL statement at the cursor position into the SQL Assist dialog. In V5R3M0 and earlier, the user had to manually select the SQL statement that SQL Assist would use. The new design is similar to using 'smart statement selection' to execute an SQL statement. However, when 'smart statement selection' is enabled, the user will be unable to position the cursor at an arbitrary place in the script and start with a default SQL statement in SQL Assist. The SQL statement nearest the cursor position will be shown in the SQL Assist dialog. If the user wishes to use SQL Assist to insert a new statement into the script, disable 'smart statement selection' with the 'Options/Smart Statement Selection' menu item. SQL Assist will appear with a default statement, or with the text that was explicitly selected as it would in V5R3M0. APAR SE22766 documents the following scenario that will be addressed in a future release: Run SQL Scripts now reports the return code from a stored procedure for the CALL statement. The return code is specified by an optional RETURN statement in an SQL stored procedure, or by a high level language construct in an external stored procedure. If the user runs a CALL statement to call a stored procedure A that returns a return code, Run SQL Scripts will report the return code. However, if the user runs another CALL to a stored procedure B which does not execute the RETURN statement, Run SQL Scripts will report the previous return code from A as the return code for the latter stored procedure B. The following document conditions that will be fixed in a future release: APAR SE25353: CA400EXP-OPNAV-DBASE-MSGSQL0443 ANALYSIS QUERIES FETCHING The 'Analysis Queries' dialog from 'Analyze...' option for a SQL Performance Monitor or SQL Plan Cache Snapshot may stop displaying results after working with a specific SQL Performance monitor or SQL Plan Cache Snapshot after displaying several reports. This symptom may happen with any detailed report or SQL Plan Cache Snapshot, such as the resulting list from 'Analysis Queries' option on 'Analyze...' for SQL Performance Monitor or SQL Plan Cache Snapshot. Everything in the report may work fine for a while before the user may see the MSGSQL0443 error message and a resulting blank list. Right-click on a SQL Performance Monitor or SQL Plan Cache Snapshot, select 'Analyze...' option on the context menu. It will bring up the Analyze dialog. Select 'Analysis Queries' option from 'Actions' menu. From the resulting list, stepping through the rows, one at time and clicking 'View Results' from 'Actions' menu causes the behavior. You may see the MSGSQL0443 error message, and then if you scroll up or down, the list becomes empty. APAR SE25354: CA400EXP-OPNAV-DBASE OVERSIZED ICON ON VISUAL EXPLAIN Visual Explain shows oversized icons. This may happen if you resize the Visual Explain window as it is being drawn and the 'Graph Detail' option is set to FULL. The following document conditions that are permanent restrictions, however, circumventions do exist: APAR SE25179: CA400EXP-OPNAV-DBASE-MSGMCH0602 VISUAL EXPLAIN Visual Explain fails with 'Boundary alignment of pointer or template not valid' error message. You may see this error when you use iSeries Navigator for V5R4 against a v5r3 or v5r4 system and try to run Visual Explain. This may happen if the QIWS.QQQDBVE2 stored procedure has been created incorrectly. CIRCUMVENTION: Recreate the QIWS.QQQDBVE2 stored procedure using the following steps: 1) In STRSQL, Run SQL Scripts in iSeries Navigator, or any SQL interface, execute the following statement: DROP SPECIFIC PROCEDURE QIWS.QQQDBVE2 2) From iSeries Navigator, go to Databases > DatabaseName > Schemas > QIWS > Procedures and then Delete the QQQDBVE2 procedure. If the QIWS is not listed on schemas, you can add it through 'Select Schemas to Display' option of the context menu of the Schemas folder. 3) iSeries Navigator is responsible for creating this procedure. The next time Visual Explain is used it will recreate the QQQDBVE2 procedure. APAR SE25238: CA400EXP-OPNAV-DBASE-MSGSQL0332 NEW SQL PLAN CACHE SNAPSHOT iSeries Navigator cannot create a SQL Plan Cache Snapshot. A message dialog may display the MSGSQL0332 and a MSGCPD4381 may be displayed in the Job log. If the control files that iSeries Navigator uses to retrieve the list of monitors have different CCSID's, the query will only work if the conversion between both CCSID's are supported. CIRCUMVENTION: The control files QAUGDBPMD and QAUGDBPMD2 are used to get the list of SQL Performance Monitors and SQL Plan Cache Snapshots. The control files may exist in QUSRSYS library if working with the SYSBAS ASP and may be in the QRCYnnnnn library if connecting to an IASP as well. Alter either one or the other control file's columns that are CCSID based so they have the same CCSID in those columns as the other control file. Another work-around is to delete one of the control files, sign-on to iSeries Navigator using a userid with a compatible CCSID and this will recreate the control file using the user's CCSID. 2.4 JAVA RUNTIME ENVIRONMENT (JRE) 1.4.2 Service Release 8 (SR8) ------------------------------------------------------------------ PTF 5722XE1 V5R4M0 SI29819 contains Java Runtime Environment (JRE) 1.4.2 Service Release 8 (SR8) which will replace version 1.4.2 SR2, which was on the original iSeries Access for Windows V5R4M0 media. The following APAR is fixed with JRE 1.4.2 SR8: APAR SE29861: CA400EXP-DATEBASE-INCORROUT JAPANESE WINDOWS VISTA, RUN SQL Run SQL scripts fail to open when using Japanese Windows Vista with error message "cwbunnav.exe is stopped". If SI29819 is applied to the iSeries, and a service pack install is run from that iSeries image, the service pack install will upgrade the JRE level, if needed. Subsequent service packs will not reinstall the JRE if the latest level already exists on the PC. A new install, reinstall, or upgrade from an install image with SI29819 applied, will install the new JRE 1.4.2 SR8. A JRE 1.4.2 SR8 install package will also be provided on the IBM FTP site in a subdirectory off of the service pack FTP directory, for those users that prefer to get their service packs from the IBM FTP site. 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS -------------------------------------------------------- This a list of APAR fixes included in this service pack. Each service pack is cumulative; the current service pack includes all the fixes from the prior service pack levels. The APAR abstracts are listed by installable component within a service pack level. --------------------------------- Service Pack Level = SI35287 Build date = June, 2009 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE37687: CA400EXP-APIS-OTHER-INCORROUT "COULD NOT LOAD FILE OR ASSEMBLY" WHEN TRYING TO LOAD ISERIES ACCESS HACL PC5250 APIS. "Could not load file or assembly 'Interop.AutSessTypeLibrary, Version=1.0.0.0, Culture=neutral, PublicKeyToken=4165431dd907d942' or one of its dependencies. Strong name validation failed.(Exception from HRESULT: 0x8013141A)." The above message is received when attempting to load any of the iSeries Access Host Access Class Library (HACL) PC5250 Automation Objects. The message will occur whether the "Copy Local" property is set to "true" and the Primary Interop Assembly (PIA) is located in the same directory as the application or the PIA is loaded into the Global Assembly Cache (GAC). The HACL Automation Objects include the following: Interop.AutConnListTypeLibrary.dll Interop.AutConnMgrTypeLibrary.dll Interop.AutOIATypeLibrary.dll Interop.AutPSTypeLibrary.dll Interop.AutScreenDescTypeLibrary.dll Interop.AutScreenRecoTypeLibrary.dll Interop.AutSessTypeLibrary.dll Interop.AutSettingsTypeLibrary.dll Interop.AutSystemTypeLibrary.dll Interop.AutWinMetricsTypeLibrary.dll Interop.AutXferTypeLibrary.dll RESOLUTION: This problem is the result of incorrect processing of the HACL automation objects during build of the IBM iSeries Access for Windows client. The outcome is that customer applications are unable to dynamically load these DLLs in their applications. We have corrected this processing and customer applications will be able to dynamically link to these libraries once this service pack has been applied to clients. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE37028: CA400EXP ISP deletes default routes at the end of the wizard Select Network->Internet->Internet Setup Wizard For Company/Office to ISP scenario, the following occurs: - An existing default route is deleted at the end of the Internet Setup Wizard. This affects all existing LAN connections. - Active rules for the profile created fail. - Selecting an existing dialup connection profile from "Choosing a Profile" panel makes the wizard fail. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE36593: CA400EXP-OPNAV-OUTPUT-INCORROUT WRKSPLF COMMAND FAILS Enter the WRKSPLF command from the DOS prompt of a Windows PC. If the host system is version 610, the list of spooled files will either display incorrectly or fail with MSGCWB0012 or MSGCWB0089 Unicode data cannot be converted. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE37485: CA400EXP-DTRANSFER-INCORROUT ORDER BY CLAUSE RESULTS SQL0125 When performing a Data Transfer download using a ORDER BY clause the ORDER BY looks correct in the GUI and when viewing the .dtf in Notepad but when executed results in message SQL0125. Data Transfer is not sending the correct string for the ORDER BY in the SQL statement which results in an SQL0125. The exact same string in a GROUP BY works fine. RESOLUTION: Tokens for the ORDER BY clause are now being process correctly into a single token and passed to the IBM i database. Potential memory leak was fixed where multiple local string objects are used for statement tokens but only the last one is deleted. APAR SE36052: CA400EXP-DTRANSFER-INCORROUT POSITION NOT WRITTEN TO TRACE When enabled, Data Transfer option to 'Log position of untranslatable fields' should write an entry to the Detail Trace logging the row and column where the untranslatable character was encountered. V5R4 and V6R1 clients are currently not logging the position to the trace. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE37441: CA400EXP-DTRANSFER EXCEL COLUMN HEADING RETURNED WITH QUOTES When running data transfer to Excel, set the data options "select" clause to select a column with a delimited name. For example: aban8 as "Address Number". Results returned to Excel have the column heading returned with double quotes. In V5R3, the same select clause would return the column heading without double quotes. RESOLUTION: This change in behavior from V5R3 is intentional. In order to provide customers a way to get the V5R3 behavior, a new CWBTFR.INI option will be added to configure the desired behavior. The new .ini option is described below. UseDelimitedNames 0 - Return names without the double quotes (v5r3m0 behavior) 1 - Return names with double-quote delimiters if needed (default option / v5r4m0 behavior) APAR SE36134: CA400EXP-DTRANSFER ADD-IN CAUSES EXCEL TO CLOSE ABRUPTLY The Data Transfer Add-in causes Excel to crash and close abruptly when an attempt is made to upload data to an existing iSeries file and the selected area in the spreadsheet has more columns than exist in the iSeries file. This happens when using the options "Append to existing member" or "Replace member" and only if the FDF file has not been previously created. APAR SE36808: CA400EXP-DTRANSFER-INCORROUT CWBTF0011 FIELD LENGTH > 1022 Attempting to upload an Excel file in BIFF8 format that contains a field with a length greater than 1022 will fail with a CWBTF0011 message indicating data truncation occurred. This occurs even if the target table column is defined with a size large enough to hold the data. The BIFF8 specification has a column or field limit of 32767 and DB2 for iSeries has a CHAR limit of 32766, so this truncation should not occur. ODBC ---- APAR SE35669: CA400EXP-ODBC-INCORROUT SQLGETDATA WRONG STRLEN_OR_INDPTR Starting at iSeries Access V5R4 service pack level SI31388, calls to the ODBC API SQLGetData return the incorrect value for *StrLen_or_IndPtr. Instead of returning the length of the buffer remaining in the column, it is returning the length of the target buffer specified on the call to SQLGetData. This issue also exists in the IBM System i Access for Windows v6r1m0 product. The driver will be updated to return the length of the data remaining in the column. The SQLGetData API is documented here: http://msdn.microsoft.com/en-us/library/ms715441(VS.85).aspx APAR SE35964: CA400EXP-ODBC-INCORROUT SQLTRANS ROLLBACK NOT HONORED ODBC application using the iSeries Access for Windows ODBC driver attempts to insert a record into a table. If the insert fails, for example a duplicate key value or invalid length, and the application then executes an SQLTrans rollback, the rollback is not sent to the iSeries so a lock is left on the table potentially causing lock contention on the table until a commit or rollback flows or the job is ended. APAR SE36703: CA400EXP-ODBC-INCORROUT ODBC WRONG NUMBER OF PARAMETERS This error happened after upgrading to iSeries Access V5R4 from Client Access Express V5R1. Using the .NET ODBC wrapper over ODBC drivers encounters the following error message: [IBM][iSeries Access ODBC Driver]Wrong number of parameters. The sequence that causes this error is: Allocate statement Bind parameters This step includes retrieving the statement attribute for SQL_ATTR_APP_PARAM_DESC. All numeric params have their precision, scale, and data pointer set using this method. Repeat 3 times... ExecDirect on an update statement SQLFreeStmt with close option Rebind a single numeric parameter, SQLBindParameter, followed by multiple SQLSetDescField calls for precision, scale, and data pointer. ExecDirect, fails with the wrong number of parameters error. Since the application never dropped the statement, or unbound the parameters, it should be legal to rebind one of the parameters and execute the statement again. RESOLUTION: The SQLSetDescField API needed to be fixed to account for total number of columns, not just the current column passed to the API. OLE DB PROVIDER --------------- APAR SE37343: CA400EXP-OLEDB Exception reading null LOB with static cursor An application may experience an exception when trying to read null LOB data from a result set, when using a static cursor. APAR SE36806: CA400EXP-OLEDB-INCORROUT NEGATIVE DECIMAL NUMBERS LOSE SIGN Using OLEDB to insert a negative value into a decimal field will sometimes lose the sign. .NET DATA PROVIDER ------------------ No fixes. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 6.3 (2008-08-29) and the equivalent of PTF 5722JC1 SI32766 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20090518 APAR SE34533: CA400EXP-TERMEMUL-INCORROUT CWBLM0111 KERBEROS AND EIM/SSO WITH LARGE TICKET SIZE Starting a PC5250 session will fail with a CWB0111 The buffer passed into the program is too small. The problem will only occur when Kerberos EIM/SSO is used, with a larger ticket size. APAR SE37369: CA400EXP-PRINTEMUL MSGCPF5261 RC10050228 PRINTING WITH DBCS PC5250 PRINTER EMULATION A DBCS iSeries Access printer emulation session is created. The printer driver is setup to print landscape on A4 size paper. Intermittently, the writer will fail with MSGCPF5261 RC10050228, indicating invalid *SCS data. APAR SE37597: CA400EXP-PRINTEMUL INCORRECT PAPER FEED WHEN USING ESC_P.PDT TABLE WITH PC5250 PRINTER EMULATION The customer creates a spooled file that specifies 64 lines long at 8 Lines Per Inch. When the page feed is processed at the end of the page, the printer ejects the wrong amount of paper. They are using the esc_p.pdt support. APAR SE37679: CA400EXP-TERMEMUL-INCORROUT CPF5140 RESULTS WHILE RUNNING PC5250 QUERIES. When running a query from PC5250, theuser session appears to hang and a CPF5140 message is generated on the iSeries. APAR SE37680: CA400EXP-APIS-OTHER-INCORROUT GETTEXT METHOD OF AUTOECL OBJECT USING HCP1399 RETURNS INCORRECT DATA. When writing a VB ECL application using auto ECL classes, customers request text using GetText Method of autoECL object using HCP1399. The received data is incorrect. APAR SE37735: CA400EXP-PRINTEMUL VIETNAMESE PC5250 PRINTER EMULATION CONCERNS 1) Output truncated when using A4 paper size 2) Alignment not correct. 3) Character overlay when using bold print when using Vietnamese PC5250 printer emulation. APAR SE35919: OSP-PAR UNABLE TO SET OR USE THE MACRO/SCRIPT DIRECTORY WHEN USING A UNC NAMING CONVENTION In System i Access for Windows v5r4m0 SI31388 and v6r1m0 SI32504; When setting the Macro/Script Directory to use an alternate location that uses UNC Naming Convention a couple of problems may be seen: 1. From PC5250 session a. Select - Edit + Preferences + Macro/Script option b. in: Macro/Script Directory field input - UNC naming convnetion as = \\\share - note: system has already been authenticated (Client for MS Networks and System i Netserver) c. The dialog appears to take/accept the input, but doesn't provide anything further. 2: As a result of first problem: From PC5250 session a. Now when you select: Edit + Preferences + Macro/Script option = nothing happens, no dialog box is populated. - rebooting the PC doesn't change this behavior. APAR SE36727: CA400EXP-TERMEMUL-INCORROUT KEYBOARD MAPPING OPTIONS WILL NOT LOAD. When using Split View the keyboard mapping options will not load. APAR SE36960: CA400EXP-TERMEMUL-THREADS-UNPRED NO SOUND IN CITRIX ENVIRONMENT. PC5250 emmulation has no sound in a Citrix Enviroment. APAR SE37061: CA400EXP-TERMEMUL-INCORROUT THAI AND VIETNAMESE FIELD NAMES DISPLAY INCORRECTLY. In PC5250, some Thai and Vietnamese field names are not being displayed correctly. APAR SE37109: CA400EXP-PRINTEMUL FORM SETTINGS BLANK WITH PRINTER EMULATION INTERFACE On a PC with Windows Vista, create a printer emulation session. Click File/Page Setup, and then the Forms Settings tab. The settings are blank, and you cannot set them using the Defaults button. On Windows XP, you can recreate the same thing by using Windows Default Printer, save the settings, then close and reopen. APAR SE37509: CA400EXP-TERMEMUL-INCORROUT WINDOWS XP SP3 CAUSES PCSCM.EXE ERROR ON PCTLNET.DLL OFFSET 0X00025995 Customer has upgraded PC to Windows XP SP3 and installed latest iSeries Access for Windows R540 Servicepack SI32972. When using no administrator users and starting PC5250 session they receive PCSCM.EXE error on PCTLNET.DLL offset 0x00025995. APAR SE36774: CA400EXP-PRINTEMUL-INCORROUT PC5250 PRINT EMULATION MISPOSITIONS SOME CHARACTERS Two incorrect output problems have been identified with PC5250 printer emulation. A pdt file is in use based on KMPCL6.PDT. Both incorrect output situations involve characters that are incorrectly shifted. SECURE SOCKETS LAYER (SSL) -------------------------- No fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ No fixes. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI32972 Build date = December, 2008 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE34758: CA400EXP-NLS-INCORROUT CONVERSION FROM UNICODE TO BIDI If bidirectional text support is enabled when converting from Unicode to bidirectional text the output text may be followed by unexpected characters. For instance, when the "Enable bidirectional script transformations" checkbox is selected inside the "iSeries Access for Windows properties" panel, a problem may present in Data Transfer when downloading data to an Excel spreadsheet. A field with a value of 5070020 will have an extra zero appended to the end resulting in an incorrect value of 50700200. RESOLUTION: The conversion returns the buffer without unexpected characters at the end. APAR SE34759: CA400EXP-NLS-INCORROUT CONVERSION FROM UTF8 TO UNICODE Incorrect conversion when converting data from UTF8 to Unicode. When the target buffer is not large enough to store the converted data, an exception may occur instead returning a buffer overflow. For instance, the problem may occur in System i Navigator when viewing contents of a table with a Large Object field. RESOLUTION: The conversion returns a buffer overflow when the target buffer is not large enough to store the converted data. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE35298: CA400EXP-OPNAV-DBASE-INCORROUT CONDENSED INDEX ADVICE LIST After an advised index is created from the Condensed Index Advice list, a message box is displayed with the following question: "The index has been created successfully. Would you like to remove the advised index entry?". If the response is Yes, an exception "An unknown error has occurred" is displayed. The message box with the question should not be displayed when creating an advised index from the Condensed Index Advice list. APAR SE35303: CA400EXP STATISTICS DATA DISPLAYS 1ST PARTITION MEMBER INFO The Statistics Data window is not displaying complete information when it is displayed for a partitioned table from within the Visual Explain window. This window only displays data for the first (*FIRST) partition of the table. ADDITIONAL KEYWORDS: OPNAV-DBASE-INCORROUT APAR SE35308: CA400EXP-OPNAV-DBASE INDEXES LIST INSTEAD MQTs LIST FROM VE When working with a table from within the Visual Explain window, after selecting the table, if the user selects the Show Materialized Query Tables option from the Actions menu, the Indexes list is displayed instead of the related Materialized Query Tables list. RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Use the table's context menu instead. APAR SE33859: CA400EXP-OPNAV SOME LINKS AT HELP TOPICS SEARCH WINDOW FAIL Some links in the Help Topics search window fail with "The topic does not exist. Contact your application vendor for an updated Help file (129) message. RESOLUTION: This problem will be fixed next release, because it involves MRI APAR SE33892: CA400EXP-OPNAV-NETWORK KERBEROS WIZARD CALLED FROM EIM HANGS Additional Keywords: INCORROUT A problem was reported into the Network Authentication Service configuration wizard when the next steps are followed: 1.- Configuring iSeries Netserver and selecting Passwords/Network authentication option as the authentication method. 2.-Press the Verify configuration button, the EIM Configuration wizard should be displayed. 2.-The screen changes to EIM Configuration wizard - Select Join an existing domain. 3.-Configure Network Authentication Service. Select yes, 4.-Would you like to configure network authentication at this time? Click next and it hangs. The screen never changes and a restart of the iSeries Navigator is required to recover. APAR SE34466: CA400EXP-OPNAV CWBUNNAV.EXE FAILS WITH SECUR32.DLL FAULTING There are three different scenarios for the same problem: 1. When iSeries Navigator is started, an error message may be displayed stating that the Fault Module Name is Secur32.dll. This error has been reported running with iSeries Access and Windows Vista Enterprise Edition with SP1. 2. Start iSeries Navigator, from Environment tasks, select Install plug-ins. Type the source system from where to install the plug-ins. Once the Setup is started and the Signon to iSeries Netserver is displayed, click Cancel. The cwbunnav.exe error described on scenario 1 may be displayed. 3. Operations Console may not start on Windows Vista SP1. APAR SE34893: CA400EXP-OPNAV DOWNLOAD CA FAILS WITH 540 CLIENT AND 610 OS When using a v5r4m0 iSeries Navigator, and connecting to a v6r1 i5/OS system, the Download Certificate Authority does not work. APAR SE35273: CA400EXP-OPNAV ISERIES NAVIGATOR HANGS SEARCHING ALL FIXES Open iSeries Navigator, go to your system, then Configuration and Service, then Fixes Inventory, then All Fixes. If you use the CTL-F search or the Edit/Find... search, the operation will hang and go to "Not responding" RESOLUTION: This PTF describes the circumvention for this problem CIRCUMVENTION: Scroll down all the list, and then do the Search APAR SE35728: CA400EXP-OPNAV-OTHER-INCORROUT Selective prompt not working Prompting a command ignores ?? and ?* selective prompt options RESOLUTION: This PTF enables ?? and ?* selective command prompting DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE35138: CA400EXP-DTRANSFER CREATION OF STD FDF BY DEFAULT IS NEEDED The Data Transfer From application creates, by default, Enhanced FDF files and this is an inconvenience for customers who need Standard FDF files, as they have to manually specify the desired format every time a transfer request is created. A new CWBTFR.INI switch to customize the default FDF format is needed. RESOLUTION: This PTF fixes the reported problem. A new switch has been created to let users specify the FDF format to use. See the example below. [Client Access Data Transfer] ;UseStandardFDF makes the Data Transfer From GUI create, by ;default, standard FDF files, instead of Enhanced FDFs. UseStandardFDF= 1 APAR SE35769: CA400EXP-DTRANSFER IASP OF JOB DESCRIPTION IS NOT HONORED In the V5R4 version of iSeries Access for Windows, a new capability was added to allow the users to set the independent auxiliary storage pool (IASP) that will be used for data transfer. Prior to this client version, users were limited to the IASP that was defined in the job description specified in the user profile. As a result of adding this property, the data transfer client no longer honors the initial ASP group setting in the job description. The IASP must be set in the connection property, and it always defaults to *SYSBAS. It has been requested that the data transfer client continues to offer the option to use the IASP defined in the job description specified in a user profile. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE34570: CA400EXP-DTRANSFER ADD-IN FAILS TO UPLOAD DATE OR TIME CELLS The Excel Add-in fails to scan and upload date or time data to an iSeries and a variety of wrong behaviors may appear, from error messages such as CWBDB0036 and SQL0180 while the data is being uploaded, to date or time columns being scanned as NUMERIC data. This happens when the cells in which the data resides use a not-supported date or time format. RESOLUTION: This PTF fixes the reported problem. The list of supported Time and Date formats has been updated so now it is as follows: Time formats Date formats h:mm AM/PM m/d/yy h:mm:ss AM/PM d-mmm-yy h:mm d-mmm h:mm:ss mmm-yy [h]:mm:ss m/d/yy h:mm mm:ss.0 yyyy-mm-dd mm:ss mm/dd/yy hh.mm.ss 3/14/2001 [$-409]h:mm:ss AM/PM Wednesday, March 14, 2001 hh:mm:ss 3/14 1:01:01 AM 3/14/01 13:30 03/14/01 1:30 PM 14-Mar 13:30:55 14-Mar-01 1:30:55 PM 14-Mar-01 30:55.2 Mar-01 37:30:55 March-01 March 14, 2001 3/14/01 1:30 PM 3/14/01 13:30 M M-01 13/14/2001 14-Mar-2001 ODBC ---- APAR SE34540: CA400EXP-ODBC-UNPRED SQLSETCONNECTATTR CURRENTCATALOG FAILS Customer is using the mail merge function of Microsoft Word, and it is failing when attempting to set the SQL_ATTR_CURRENT_CATALOG of the connection with the SQLSetConnectAttrW API. They first call SQLTables to retrieve the catalog name, which is "ELECTRONIC". Then, they call SetConnectAttr The problem here is that they are passing in an indicator length in BYTES, not in CHARACTERS. Microsoft in this case is passing in a name that is only 10 characters long. It is failing because they specified the length of the buffer in bytes instead of characters. APAR SE35097: CA400EXP-ODBC-INCORROUT SQLGETDATA CAUSES FAULT ODBC application using SQLGetData to fetch a row until the end of the result set faults and ends without message. When the end of the data is reached the ODBC driver should return SQL_NO_DATA but instead appears to be returning a null which causes a fault. APAR SE35508: CA400EXP-ODBC-INCORROUT ACCESS VIOLATION IN CWBODBC.DLL A Windows application is using the iSeries Access for Windows ODBC driver to prepare and execute an SQL statement. The statement is over 600,000 characters long and contains some characters that do not have EBCDIC equivalents. When the conversion is done from unicode to EBCDIC, the untranslatable characters are converted to the standard code point for characters that do not exist in a character set. But the ODBC driver is incorrectly sending a statement to the host server with over 1,800,000 spaces appended to the end of the statement. That makes the statement over the 2 megabyte limitation for SQL statements. When the error is returned to the PC, the ODBC driver fails with a protection fault. OLE DB PROVIDER --------------- APAR SE34359: CA400EXP-OLEDB-INCORROUT SQL UPDATE STATEMENT FAILS USING IBMDASQL OLE DB PROVIDER. Executing a Microsoft SSIS package to conditionally update a table on an iSeries using the IBMDASQL OLE DB provider fails. Messages from Microsoft Visual Studio executing the package are; Error: 0xC0202009 at Syncronize Data To DB2, Update_Command [204]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E00. Error: 0xC0047022 at Syncronize Data To DB2, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Update_Command" (204) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. Error: 0xC0047021 at Syncronize Data To DB2, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited. IBMDA400.trc file shows the next error message: CCommand::Execute() - invalid accessor handle .NET DATA PROVIDER ------------------ APAR SE34938: CA400EXP-IDB2DATA-F/QSQRUN1-T/QSQRUN1-MSGSQL0519 THE IBM.DATA.DB2.ISERIES .NET PROVIDER IS NOT CLOSING AN SQL CURSOR The IBM.Data.DB2.iSeries .Net provider is not closing an SQL cursor when an exception occurs in the .Net application. The next time a statement is Prepared/Described with the same cursor name, an SQL0519 message is returned by DB2 for iSeries. The .Net provider will be updated to flow the CloseCursor. APAR SE35276: CA400EXP-IDB2DATA-INCORROUT .NET EXCEPTION 'SYSTEM.INDEXOUTOFRANGEEXCEPTION' WHEN DATA CONTAINS A NULL An application using the iSeries Access for Windows .NET provider to access data on the iSeries encounters an exception when getting data. The application is using the DataAdapter.Fill method to get data from the iSeries but the data has an embedded null. This results in an exception in the application, 'System.IndexOutOfRangeException'. If the same is done using the iSeries Access OLEDB IBMDASQL provider no exception is encountered. RESOLUTION: The problem happens because the null character causes a translation error. This is the expected behavior. Because some customers would like to avoid this problem and instead receive a substitution character instead of the exception, a new property is added to the .NET provider that can be used to get the desired behavior. This new property should be set in the ConnectionString of the iDB2Connection object. Property: bool AllowUnsupportedChar Description: Gets a value which indicates whether unsupported characters will be allowed during translation, or whether their presence will cause an exception to be thrown during translation of data coming from the host. Default value: false (cause an exception) Example of how to get the new behavior: iDB2Connection cn = new iDB2Connection("DataSource=mysystem; AllowUnsupportedChar=true;"); APAR SE35399: CA400EXP-IDB2DATA-INCORROUT MEMORY LEAK WHEN CLOB DATA IS RETRIEVED The iSeries Access .Net managed data provider is being used to retrieve records that contain Character Large OBjects (CLOBs). Every time that a data set is retrieved and disposed of, the memory allocated to the application increases. Process Explorer was used to show that the memory is not being allocated by the .Net CLR, it seems to be in the .Net provider itself. Deeper analysis showed that the problem was actually in a lower level component and that this same failure could affect the OLEDB provider. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 6.3 (2008-08-29) and the equivalent of 5722JC1 PTF: SI32766 No fixes. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20081104 APAR SE34002: CA400EXP-TERMEMUL-INCORROUT IN USER-DEFINED SCREENS, THE "PC" DDS KEYWORD IS IGNORED WHEN THE DISPLAY REFRESHES. In a user defined screen, the "PC" keyword is ignored in the case of screen refresh and error handling. APAR SE34044: CA400EXP-TERMEMUL-UNPRED FOLLOWING INSTALLATION OF SI29771 FOR V5R4 OF 5722XE1, USERS RECEIVE PCSWS041 Following installation of SI29771 for V5R4 of 5722XE1, users receive PCSWS041. A removal of the SP resolves the issue. APAR SE34106: OSP-PAR-940XMISC AFTER SI30707 INSTALLATION V5R3 5722XE1, PCSWS041 RECEIVED ATTEMPTING TO RUN MACRO ON WINDOWS 2003 SERVER Following installation of SI30707 V5R3 5722XE1, users receive error message PCSWS041 "The system has insufficent resource or the script is not properly installed" when attempting to run a macro on Windows 2003 Server APAR SE34184: CA400EXP-TERMEMUL-UNPRED PCSWS.EXE FAILS WITH PCSWLIB.DLL FAULTING ON PC5250 LAUNCH When opening PC5250 sessions, PCSWS.EXE fails with pcswlib.dll faulting. APAR SE34231: CA400EXP-PRINTEMUL VIETNAMESE SUPPORT FOR PC5250 PRINTER EMULATION Support for Vietnamese characters is needed for PC5250 printer emulation support. It should be able to recognize input code page 1130, and it also needs to print combination characters while keeping columnar data lined up, similar to what has been done for Thai printing. APAR SE34629: CA400EXP-TERMEMUL-UNPRED PASTE INTO AN PC5250 SESSION WILL LET THE SESSION DIE WITHOUT A MESSAGE Client is using PC5250 session in a CITRIX or TSE / RemoteDesktop environment. Using the COPY / PASTE function in a PC5250 session will let the session die, this behavior will occur more often if the client is using the "SoundsOn=Y" parameter in the WS file. APAR SE35063: CA400EXP-TERMEMUL-THREADS-INCORROUT INSTALLING SI29771 CAUSES THE URL/HOTSPOTS TO FAIL TO LAUNCH THE WEBBROWSER IN PC5250. Windows 2003 Server, installing SI29771 causes the URL/Hotspots to fail to launch the web browser in PC5250. APAR SE35381: CA400EXP-TERMEMUL-THREADS-UNPRED INCORRECT CUSOR POSITION IN PC5250 AFTER INSTALLING SI31388. The cursor appears to move when user on a different PC performs actions on thier 5250 session. and/or cusor doesn't behaive as it should. SECURE SOCKETS LAYER (SSL) -------------------------- No fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ No fixes. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI31388 Build date = July, 2008 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE33006: CA400EXP-SERVICE-INCORROUT CWBSVGET DOESN'T WORK ON VISTA Cwbsvget.exe doesn't work on vista and Windows Server 2008 operating systems. APAR SE33905: CA400EXP-INCORROUT PC5250 CONFIGURATION FILES NOT FOUND Using iSeries Access for Windows V5R4 on a Windows Vista PC, the PC5250 emulator may fail finding specific application configuration files. For example, when printing a spooled file with a PC5250 printer emulation session, the printout is compressed and sometimes with blanks in between. This same spool file is printed correctly on Windows XP. RESOLUTION: With the added support of Windows Vista the default PC5250 file paths were changed as Microsoft suggested. That is why under Windows Vista may fail to find the PC5250 configuration files. After applying this fix, the files will be copied at boot time only if the configuration files exist on the old PC5250 paths. CIRCUMVENTION: Manually copy all the files located in the old common PC5250 files path: (iSeries Access for Windows install path)\emulator\private To the new common PC5250 files path: %ProgramData%\IBM\Client Access\Emulator\private Also copy all the files (if any) from the old per-user PC5250 files path: (My Documents folder)\IBM\Client Access\Emulator\private To the new per-user PC5250 files path: %APPDATA%\IBM\Client Access\Emulator\private These paths are PC5250 files path examples of an English Windows Vista PC, these paths are customizable and can also change depending the language or the Operating System. For more details about the PC5250 paths, see APAR II14380. APAR SE33999: CA400EXP-DTRANSFER-INCORROUT PACKED TO CHARACTER CONVERSION A problem was discovered with the iSeries Access data transfer Excel Add-In. Intermittently a packed decimal value will be converted incorrectly. It was found that a single digit number may be converted to a value 10 times that of the original value. For example, the original value is 3 but the value in the spreadsheet would be 30. Further analysis revealed this to be a problem in the code that converts packed decimal data to character data. This problem could therefore affect not only Data Transfer but also the OLE DB and .Net components. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE33562: CA400EXP-OPNAV-DBASE-INCORROUT UPDATE NOT SAVED INTO SERVER When the user updates a row through the Edit Contents dialog, the data may not be saved on the server and an error message may be displayed. This is possible if the user repeatedly updates the same row and commits the change without moving between rows and using the File -> Save menu option and if the column being updated is a numeric type. On the first update attempt the dialog shows the new value but the server does not reflect the change. Consecutive attempts will show an error message stating that the row the user attempted to change no longer exists in the table. RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Move to another row to submit the change to the server. Then the user should use the File -> Save menu option to commit the transaction. APAR SE33564: CA400EXP-OPNAV-DBASE CREATING NEW SOURCE FUNCTION WITH UDT When trying to create a new sourced function, it may fail with an MSGSQL0683. This happens if the source function has user-defined type parameters and at least one of them is a type of character data. The New Sourced Function window displays the user-defined type with the CCSID value which will cause the error message to be displayed when the user tries to create the function. ADDITIONAL KEYWORDS: MSGSQL0683 RESOLUTION: The CCSID clause will not be filled in as the default if the parameter type is a user-defined type. CIRCUMVENTION: Clear all CCSID fields for those parameters whose the data type is a user-defined type. APAR SE33578: CA400EXP-OPNAV HANDLE NULL POINTER EXCEPTION IN PLAN CACHE When working with SQL Plan Cache Snapshots, there are some actions where an error message may display due to a null pointer exception not being handled. Such actions are: 1) Selecting the "Show Statements" option for an SQL Plan Cache Snapshot which its data file is empty. This will display an empty list and a null pointer exception in the trace. An "An unknown error has occurred." error dialog may be displayed before the Show Statements dialog displays. 2) Selecting the "SQL Statements with the Same Statement Text" option for a statement within a drill-down analysis report. The message, "An unknown error has occurred.", may display if the Join Field column value is missing for the record. A null pointer exception is logged in the trace. ADDITIONAL KEYWORDS: DBASE-INCORROUT APAR SE33581: CA400EXP-OPNAV INDEX ADVISED NOT GENERATED CORRECTLY FROM VE Trying to display the create index dialog for an advised index through the Visual Explain (VE) window may have problems. In Visual Explain, the user can display the list of advised indexes of the query being explained. The list may contain binary radix index and encoded vector index (EVI) index types. To create an advised index the user checks the checkbox for the one they want and then presses the Create button to display the create index dialog. The following problems may occur when the user tries to create advised indexes: 1) Displaying the create index dialog for the first time on an advised index other than the first one in the list, will display the correct index. But the next time the user presses the Create button, they will get the create index dialog for the first index in the list. 2) If the list has an EVI index and a binary radix advised, the create index dialog for the EVI may not display. ADDITIONAL KEYWORDS: DBASE-INCORROUT APAR SE34116: CA400EXP-OPNAV-DBASE-MSGSQL0440 DOING A VISUAL EXPLAIN When trying to do Visual Explain it may fail with a MSGSQL0440 error message. This is possible if the system the client is connected to is i5/OS V6R1 or later and if the iSeries Navigator version is V5R4 or prior. RESOLUTION: This PTF fixes the reported problems. CIRCUMVENTION: Delete the QQQDBVE2 stored procedure in the QIWS library. Then use Visual Explain from a V5R4 version of iSeries Navigator. It will generate the stored procedure with the correct parameters. APAR SE33583: CA400EXP-OPNAV NESTED BRACKETED COMMENTS IN RUN SQL SCRIPTS When using the Run SQL Scripts (RSS) window to execute a script, it may fail if it has nested comments. This is possible if each pair of bracketed comments do not have spaces between them and other bracketed comments. Example: /*/* some comment */*/ ADDITIONAL KEYWORDS: DBASE-INCORROUT RESOLUTION: This PTF fixes the reported problems. CIRCUMVENTION: Put at least one space between each set of 2 character comments ("/*" or "*/") so the comment looks like: /* /* some comment */ */ Then execute the query. APAR SE33586: CA400EXP ADD SERVER MODE CONNECTING JOB TO JOB SQL DETAILS The Current SQL for a Job and SQL Details for a Job dialogs will be extended to display the 'Server mode connecting job:' within the current job SQL information. This will be added to a V5R4 and V6R1 clients of iSeries Navigator and iSeries Navigator respectively when connected to a V5R4 version of i5/OS or greater. This is the definition of the new Server mode connecting job value. It will be the qualified job name of the job which established the SQL Server Mode connection. If the job name of the current job is not QSQSRVR, then blanks will be displayed for the Server mode connecting job if the client is a V5R4. In V6R1 the value will not be displayed if it is not filled in. If the job name is QSQSRVR, then the qualified job name of the connecting job will be displayed. This job name will be of the form 'xxxxxxxxxx/yyyyyyyyyy/zzzzzz', where x = job name, y = user name and z = job number. ADDITIONAL KEYWORDS: OPNAV-DBASE RESOLUTION: The Current SQL for a Job and SQL Details for a Job dialogs have been extended. But this extended functionality is available only if the following PTFs are installed on the system: PTF '5722SS1 V5R4M0 SI31631' PTF '5722SS1 V5R4M0 SI31632' PTF '5722SS1 V5R4M0 SI31633' PTF '5761SS1 V6R1M0 SI31640' PTF '5761SS1 V6R1M0 SI31641' PTF '5761SS1 V6R1M0 SI31644' APAR SE34117: CA400EXP ADD SERVER MODE CONNECTED THREAD TO JOB SQL DETAILS The Current SQL for a Job and SQL Details for a Job dialogs will be extended to display the 'Server mode connected thread:' within the current job SQL information. This will be added to a V5R4 and V6R1 clients of iSeries Navigator and iSeries Navigator respectively when connected to a V5R4 version of i5/OS or greater. The 'Server mode connected thread' corresponds to the application thread identifier which last used this SQL server mode connection. When using a V5R4 iSeries Navigator client, if the job name of the current job is not QSQSRVR, then blanks will be displayed for the Server mode connected thread. When a V6R1 iSeries Navigator client is used, the Server mode connected thread information will only appear if it contains non-blanks. The Server mode connected thread could refer to an application thread identifier which no longer exists. ADDITIONAL KEYWORDS: OPNAV-DBASE RESOLUTION: The Current SQL for a Job and SQL Details for a Job dialogs have been extended. But this extended functionality is available only if the following PTFs are installed on the system: PTF '5722SS1 V5R4M0 SI31830' PTF '5761SS1 V6R1M0 SI31850' APAR SE34118: CA400EXP-OPNAV CHANGE KRB5.CONF FILE AND KERBEROS BATCH FILE Additional Keywords:OTHER-INCORROUT Problems reported: Problem 1 : The newer ktpass.exe windows command used on Win2003 server doesn't default to DES-only encryption like the Win2K version of ktpass.exe command does. That is, service principals must have the "Use DES encryption for this account", option set, otherwise a RC4-HMAC encrypted service ticket is generated, which i5/OS will not be able to handle. The 'NASConfig_.bat' batch file created using the NAS wizard should add the '+DesOnly' flag on the calls to ktpass.exe for the Win2003 portion of the batch file. Problem 2 : The -ptype 'KRB5_NT_PRINCIPAL' option should be included on the Win2003 ktpass.exe calls, otherwise a warning message will be generated. Problem 3 : The trigraphs characters used on the krb5.conf kerberos configuration file should be optional, due to problems reported with some kerberos clients implementations. APAR SE34119: CA400EXP-OPNAV-USRGRP-THREADS-INCORROUT CUSTOMIZE VIEW, INCLUDE, BROWSE, DISPLAY ALL USERS, ONLY SHOWS A SUBSET OF When the customer uses the option Under Navigator, > Printer Output, Customize View, include, browse ? the display All Users, the display only shows a small subset of users. RESOLUTION: A change will be made to the code that displays a list of users so that all users will be shown. The change is the same change that was made in V6R1, that is, to call Java Toolbox support to provide the list. APAR SE29734: CA400EXP-OPNAV-INCORROUT USER NETWORKS OPTION FAILS When going into the properties of a user profile using iSeries Navigator and adding a second Network, Navigator shuts down. This may also be experienced when the user profile has associated two or more networks to its definition. RESOLUTION: The code has been modified to display the network servers associated with each user profile. CIRCUMVENTION: To display the networks associated to a user profile, you may use DSPSVRAUTE command on a 5250 session. APAR SE30970: CA400EXP-OPNAV CWBUNNAV.EXE IS ACTIVE AFTER CLOSE NETSERVER SHORTCUT When closing the window for a netserver desktop shortcut, error cwbunnav.exe occurs: the process is not released in window process. APAR SE32155: CA400EXP-OPNAV-INCORROUT EMPTY PANELS WITH HIGH RESOLUTION Some dialogs in iSeries Navigator are not displayed correctly. They do not show any information, instead they are empty, blank panels, with the normal blue title bar. The dialogs with this problems are usually Properties dialogs. This problem has been found using Windows XP pro SP2 with V5R4 iSeries Access for Windows and the Intel 82845G Graphics Controller, the Intel 82865G Graphics Controller or TFT WideScreen monitors with the display resolution set to 1680x1050. APAR SE32165: CA400EXP-OPNAV ERRORS WHEN APPLICATION ADMINISTRATION IS NOT INSTALLED The following Application Administration errors may occur: 1) A Runtime error with program CWBUNPLP is received when trying to perform any function with iSeries Access for Windows. Message: Runtime Error! Program: n:\Windows\System32\cwbunplp.exe n= location of installed application 2) From the Administration System tab in the iSeries Access for Windows Properties window, when user tries to run "Scan Settings Now" and a message error is to be displayed, user will get the following exception: An exception occurred while trying to run "shell32.dll,Control_RunDLL "C:\WINDOWS\System32\ca400cpl.cpl"," RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Use the selective setup to add the iSeries Navigator - Application Administration component. APAR SE32025: CA400EXP-OPNAV ADVANCED JOB SCHEDULER CONTAINER IS EMPTY When initially opening the Advanced Job Scheduler plugin, there are no options listed. iSeries Navigator has to be closed and re-opened, then the plug-in options are displayed. APAR SE32235: CA400EXP-OPNAV-INCORROUT BAD INVENTORY EXPORT STORAGE VALUE Management Central Export Inventory feature writes incorrect value for available storage and storage used. Problem may be observable when values being handled are close and above 2.1 TB. RESOLUTION: Code has been modified to handle storage reports correctly. APAR SE32527: CA400EXP-OPNAV-DBASE-MSGSQL0551 EDIT CONTENTS OF A TABLE When trying to edit a table using the 'Edit Contents' menu option of the table's context menu, a MSGSQL0551 error message may appear. The error states that the user is not authorized to the object QADBIFLD in QSYS type *FILE. This happens if the user trying to do the action does not have enough authority to the QADBIFLD object. APAR SE32734: CA400EXP-OPNAV ISERIES NAVIGATOR PERFORMANCE ADVISOR STOPS When the firewall rules are configured to deny access to the iSeries host, and the iSeries Navigator Advisor is used to check the network items of the host, the iSeries Navigator Advisor - Performance window may stop at 0%. At this point the Status of the Performance window is Analyzing network: Response Time. APAR SE32748: CA400EXP-OPNAV-INCORROUT SELECTING PERMISSIONS FOR AN OBJECT Additional Keywords: -DBASE Working with database objects a connection error was displayed. Currently Secure Socket Layer is enabled and the not secure ports are blocked by a firewall. APAR SE32841: CA400EXP-OPNAV CWBUNNAV.EXE FAILS REORDERING SPOOLED FILES Using a 2.99 GHz processor, under iSeries Navigator, expand Basic Operations / Printers, and selecting a printer, and then moving a spooled file down the list can cause a cwbunnav.exe error. It does not happen every time. You can circumvent by creating a shortcut to the printer view and working with the spooled files in the shortcut. RESOLUTION: This APAR documents the reported problem and provides a circunvention CIRCUMVENTION: Create a shortcut for the printer and work with the spooled files in the shortcut window. APAR SE33434: CA400EXP-OPNAV-DBASE-INCORROUT PARTITIONED TABLE DEFINITION The definition dialog for a table may not appear for partitioned tables. When selecting the "Definition" context menu option for a partitioned table, the Definition dialog may not display and no error is signaled to the user. This happens with partitioned tables that have many partitions. APAR SE32073: CA400EXP-OPNAV SCRIPT NOT SAVED WITH CLOSE GROUP ACTION Using the 'Close group' action to close the windows of iSeries Navigator may result in not saving a script being modified in Run SQL Scripts window. If the closing action is requested and the user has modified a script in the Run SQL Scripts window, but not yet saved it, the iSeries Navigator closing process should be stopped to ask the user if they want to save the changes. Instead, the application closes and the changes to the script(s) are lost. ADDITIONAL KEYWORDS: DBASE RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Do not use the 'Close Group' option. Instead use the close action from the main window of the iSeries Navigator to close all windows. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE31895: CA400EXP-DTRANSFER FILE TYPE CHANGED AFTER MSGCWBTF0002 An iSeries Access for Windows data transfer request is created to transfer a file to the PC. The output type is set to file and the file name is the name and location of a file that already exist. In the transfer details, the file type is set to any file type and the option to 'Create new file' is selected. When the transfer runs, an error CWBTF0002 will result, prompting the user to select OK to overwrite the existing PC file or press Cancel to stop the transfer request. If the OK is pressed on the message CWBTF0002, the transference succeeds and the file is overwritten correctly but, if the Cancel button is pressed and a different file name is provided, the file is created but no data is transfered. APAR SE31984: CA400EXP-DTRANSFER-LOOP RXFERPCB GOES INTO AN ENDLESS LOOP When RXFERPCB uploads an Excel Spreadsheet (.BIFF file), it should not try to upload multiple worksheets. Currently, it tries to do so and, when the second worksheet contains empty records, the upload algorithm goes into an endless loop, transferring blank records until the job is manually ended or the iSeries table has reached it's maximum size. APAR SE32445: CA400EXP-DTRANSFER-MSGCWBDB0052 INCORRECT ROW NUMBER Data transfer is reporting an error CWBDB0052 in V5R3 or V5R4, or CWBTF0105 starting in V6R1, due to data in a file that cannot be converted from the host CCSID to the PC code page. The error displays the column and row numbers of the result set with the error, however, the indicated row number is wrong. APAR SE32745: CA400EXP-DTRANSFER CUSTOMIZED DEFAULT DATE FORMAT IS NEEDED The Data Transfer application does not allow a user to specify a customized default date format but it selects the date format based on the PC's Windows regional settings. This behavior represents a problem for customers that do not want to use the automatically selected date format, especially for those who create many transfer requests, as they have to go to the Format Settings panel and change the date format manually every time a new transfer request is created. APAR SE33249: CA400EXP-DTRANSFER-INCORROUT IASP PARAMETER IS IGNORED The Data Transfer application ignores the IASP/Database value stored in transfer requests; the default value (*SYSBAS) is used instead. APAR SE33421: CA400EXP-DTRANSFER UPLOADING XML FILES CAUSES VARIOUS ERRORS Several problems with the iSeries Access for Windows Data Transfer to iSeries GUI are addressed in this APAR, all of them related to the "MS XML Excel spreadsheet" file type: 1) The XML scanner in the iSeries Access for Windows Create iSeries Database file GUI fails to recognize XML spreadsheets that contain more than one worksheet correctly. As a result, incorrect table layouts are generated which make Data Transfer fail to parse the spreadsheets and cause the following error message to be displayed: CWBTF0100 Microsoft XML Parser encountered an error at line x, column x, with return code - 2147467259. Message text, if available, is Unspecified error'. 2) An access violation may occur when the XML scanner in the iSeries Access for Windows Create iSeries Database file GUI scans a large XML file. 3) An endless loop can occur when extra columns are added to an XML file after it has been used to create a table on the iSeries and an FDF file has already been created based on the original layout. The expected behavior in this situation is to display a warning message stating that extra data will not be sent. Appropriate data should be transferred. 4.- A hang may occur in the middle of an upload operation of an XML file, specially with big files. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE33886: CA400EXP-DTRANSFER CWBTF0073 ON UPLOAD WITH EXCEL ADD-IN The Excel Add-in displays the error message CWBTF0073 (Data type mismatch) when an attempt is made to upload data to an existing table that contains fields of type DATE or TIME; this problem only happens when there are empty cells on the spreadsheet that correspond to the fields of type DATE or TIME and the FDF is created through the options "Replace member" or "Append to existing member". APAR SE31662: CA400EXP-DTRANSFER ADD-IN FAILS WITH TIME FORMATTED CELLS There is a problem when transferring data from a Microsoft Excel spreadsheet using the iSeries Access data transfer Excel Add-in. When there are cells that are formatted as a Time value, the scanning tool defines these as numeric columns instead of Time. The only time format that seems to work correctly is a custom time format. Since there is no way to change the type from numeric to Time in the database creation wizard, the wizard cannot be used to create a proper table to put this data in. APAR SE32745: CA400EXP-DTRANSFER CUSTOMIZED DEFAULT DATE FORMAT IS NEEDED The Data Transfer application does not allow to specify a customized default date format but it selects the date format based on the PC's Windows regional settings. This behavior represents a problem for customers that do not want to use the automatically selected date format, especially for those who create many transfer requests, as they have to go to the Format Settings panel and change the date format manually every time a new transfer request is created. APAR SE33037: CA400EXP-DTRANSFER ADD-IN DOES NOT SUPPORT EXCEL 2007 LIMITS iSeries Access Data Transfer Add-In supports Excel 2003 limits (65535 rows by 256 columns), not being able to handle Excel 2007 limits (1,048,576 rows by 16,384 columns). APAR SE33119: CA400EXP-DTRANSFER-INCORROUT FDF DEFAULT PATH IS NOT DEFINED When using the Data Transfer Excel Add-in to upload data and no path is specified, the FDF file is created in C:\Documents and Settings\UserID\My Documents directory. The correct default behaviour, if no directory path is specified, is for the FDF file to be created in the C:\Documents and Settings\UserID\My Documents\IBM\Client Access directory. APAR SE33249 (PTR SE33249): CA400EXP-DTRANSFER-INCORROUT IASP PARAMETER IS IGNORED The Data Transfer application ignores the IASP/Database value stored in transfer requests; the default value (*SYSBAS) is used instead. ODBC ---- APAR SE33580: CA400EXP-DATABASE-MSGSQL0401 using translate hex connection property SQL0401 message error occurs when using extended dynamic support under a connection with a different Hex Parser Option than the one used when the SQL package was originally created. For example, if an SQL package created with Hex Parser Option set to 0 (Default) is used under a connection with Hex Parser Option set to 1, SQL0401 message occurs. RESOLUTION: This PTF fixes the reported problem CIRCUMVENTION: - Don't use extended dynamic support - For ODBC and JDBC, the user can create one package with the option set to Default in one library (eg, HEXPKGLIB), and then set the option ON and create the package to a different library (eg, BINPKGLIB). - For OLE DB the connection string/property "SQL Library Package Name" must be used to specify the Package location library JDBC Additional information about "translate hex" can be found in JDBC driver connection properties http://publib.boulder.ibm.com/infocenter/iseries/v5r4/ index.jsp?topic=/rzaha/conprop.htm ODBC Additional information about HEXPARSEROPT can be found in Connection string keywords - Translation properties http://publib.boulder.ibm.com/infocenter/iseries/v5r4/ index.jsp?topic=/rzaik/rzaikconnstrkeywordstranprop.htm OLE DB Additional information about "SQL Library Package Name" and "Hex Parser Option" can be found in the programmer's toolkit. Programmer's toolkit---->Database ---->ADO/OLE DB ---->"iSeries Access for Windows OLE DB Technical Reference - SQL"----> Help Topics---->Contents tab---->System i OLEDB provider functions----> Special Properties APAR SE32285: OSP-INCORROUT MSGSQL0104 LINUX ODBC DRIVER wrong length stmt Linux PHP script using iSeries Access for Linux ODBC driver encounters an msgSQL0104 when the SQL statement contains a character outside the invariant character set (a-z, 0-9). Languages other than English commonly use characters outside the invariant set, i.e. accented letters, and are more likley to encounter this issue. APAR SE33393: CA400EXP-ODBC-INCORROUT GARBAGE DATA APPENDED TO DATA RETURNED FOR RESULT SET. Unicode configured PHP script run under Microsoft Windows using the iSeries Access for Windows ODBC driver returns DB2 data from the iSeries but the displayed output appears to have appended garbage data to the result set. The iSeries Access for Windows ODBC driver was configured with the CCSID keyword to force the client code page to be used to 1208 UTF-8. Detail trace or CWBCOTRC will reveal there is a CWB0111 truncation warning message but doesn't account for the extra data appended to the result set. OLE DB PROVIDER --------------- APAR SE31868: CA400EXP-OLEDB-INCORROUT ADSCHEMACOLUMNS FOR OPENSCHEMA METHOD RETURNS NO RESULTS WHEN USING CLIENT SIDE CURSOR. Microsoft ADO OpenSchema method using adSchemaColumns as the QueryType returns empty results instead of a list of columns when using iSeries Access for Windows OLE DB provider. This issue only occurs when using a client side cursor, adUseClient. Using a server side cursor, adUseServer, returns the correct results. APAR SE32880: CA400EXP-OLEDB-INCORROUT QUERY OPTIONS LIBRARY NOT SET FROM SQL SERVER The iSeries Access for Windows OLE DB provider is not setting the query options library (the library whose QAQQINI file will be used) when the provider string is set to "QUERY OPTIONS FILE LIBRARY=MYLIB" in SQL Server. If a trace is also set on through the provider string, the query options library gets set properly though. For example the following provider string will work as it should, "QUERY OPTIONS FILE LIBRARY=MYLIB;TRACE=7" APAR SE33171: CA400EXP-OLEDB-F/QZDASQL-T/QZDASQL-MSGPWS0005 ERROR OCCURS ON DELETE OR UPDATE IN SQL SERVER LINKED SERVER. MSGPWS0005 f/QZDASQL t/QZDASQL "Error occurred in the i5/OS database server code" is generated on a new linked server connection from SQL Server to the i5 database. The error occurs trying to run an UPDATE or DELETE statement using iSeries Access for Windows V5R4M0 with Service Pack SI25949 or SI29771 installed. No other errors are generated to the JOBLOG. TRCCNN shows QSQDELET followed by the error: 3807 - SQLCA SQLCAID: SQLCA SQLCABC: 136 SQLCODE: 0 SQLERRML: 32 SQLERRMC: ..PPBACPPGUY..PRKTESTF ........ SQLERRP: QSQDELET SQLERRD: {0,0,11,0,0,-134613515} SQLWARN: {W, , , ,W, , , , , , } SQLSTATE: 01504 A zz trace indicate that data is deleted from a table, and then an attempt is made to perform a fetch on a cursor that isn't open. .NET DATA PROVIDER ------------------ APAR SE32989: CA400EXP-IDB2DATA Using CommandBuilder with a closed connection fails With the iSeries Access for Windows V5R4M0 .Net provider, using the CommandBuilder to perform updates on a table with a primary key causes the error: "The iDB2DataAdapter's SelectCommand did not return any column information." ...even though a comm trace shows that the iSeries host did indeed return the information about the lone unique key on the table. The problem is caused due to the iDB2DataAdapter being attached to a previously closed connection. RESOLUTION: This ptf fixes the reported problem. CIRCUMVENTION: Open the connection before using the CommandBuilder. APAR SE33517: CA400EXP-IDB2DATA-INCORROUT EXCEPTION WITH EMPTY STRING PARAMETERS A program using the IBM DB2 for i5/OS .Net provider encounters an exception when a string parameter is assigned an empty string as a value. The exception code is 0xC000000D and is reported in module MSVCR80.DLL or equivalent runtime library. The problem can be recreated using the following C# code: static void Main(string[] args) { String strParm = ""; iDB2Connection cnn = new iDB2Connection("DataSource=MYSYSTEM"); cnn.Open(); iDB2Command cmd = cnn.CreateCommand(); cmd.CommandText = "call MyLib.MyProc(@myCharParm)"; cmd.DeriveParameters(); cmd.Parameters["@myCharParm"].Value = strParm; iDB2DataReader dr = cmd.ExecuteReader(); } APAR SE32401: CA400EXP-IDB2DATA-INCORROUT CONNECTION TIMEOUT NOT WORKING The .Net data provider supports a connection timeout property that specifies the amount of time that the provider will wait for a connection to complete before it returns a connection timeout back to the application. The provider only seems to set the timeout value for the connection that is made to the database host server. In many cases, there are other connections that the core communications functions are in control of, which must be made before this database server connection is attempted. The .Net timeout value should apply to all of the connections that are made. As part of the investigation into this problem, an important discovery was made that bears mentioning here. If the system is configured (in iSeries Navigator's connection properties) to look up the address of the system, then a DNS name resolution will be performed for the connections and that sort of connection does not use sockets so the timeout cannot be applied to the DNS address lookup. If that fails, the length of that timeout is beyond the control of an application. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- APAR SE32359: CA400EXP-AFPVIEWER OpNav View spooled file fails on Vista Right click a spooled file from iSeries Navigator and attempt to open it. This action fails when attempted on Windows Vista. TOOLBOX FOR JAVA ---------------- Includes JTOpen 6.2 (2008-04-30) and the equivalent of 5722JC1 PTF: SI31547 No fixes. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20080618 APAR SE34115: CA400EXP-TERMEMUL-INCORROUT CORRUPTED PRINTER DIALOG STRINGS The PC5250 New Printer Dialog screen shows some corrupted Arabic characters. APAR SE29418: CA400EXP-TERMEMUL-WAIT MACROS CREATED IN AN EARLIER RELEASE RUN SLOWER AFTER VERSION UPGRADE TO V5R4M0 Macros that were created at V5R3 of iSeries Access for Windows run significantly slower after upgrade to V5R4. Each step of the macro appears to wait for a response from the iSeries before the next step is processed. APAR SE29943: CA400EXP 5250 SESSION HANG WHEN THE MIXED DATA WAS PASTED. When the data with which the SBCS blank is contained between DBCS is pasted to G type field (Graphic field), the session loses a response. This problem occurs only in the DBCS environment. Ex, 'A B' (A and B is DBCS. It is a SBCS blank between them.) If the data containing SBCS and DBCS is pasted into G field, a session will be hung. APAR SE31152: CA400EXP-TERMEMUL-INCORROUT PC5250 DOES NOT SUPPORT GREEK ALPHABETIC CHARACTERS IN AN ALPHABETIC ONLY FIELD. iSeries Access for Windows PC5250 display emulation flags a status bar message 'Field requires alphabetic characters' when Greek alphabetic characters are typed into an alphabetic only input field. The PC5250 session is correctly setup for a Greek environment. APAR SE31610: CA400EXP-PRINTEMUL PRINTER EMULATION ENDS ABNORMALLY WITH PDT CONTAINING START_JOB WITH MORE THAN 255 BYTES A pdt table is created from custom source. The source contains a START_JOB tag with more than 255 bytes of data. When put in use, the printer emulation session ends abnormally. APAR SE32283: CA400EXP-TERMEMUL-INCORROUT COPY AND PASTE AT G TYPE FIELD PCOMM APAR IC55304 Incorrout Copy and Paste function on host codepage 1399/1390 session. When user tries to copy G type fields for Input/Output type, copied string is invalid. The problem issues G type fields has all blanks. The results is different between host codepage 930/939 and 1390/1399. It will not DBCS blanks. Already reported under PCOMM APAR IC55304. APAR SE32400: CA400EXP-TERMEMUL-INCORROUT PC5250 KEYBOARD ERROR WILL NOT RESET PC5250 keyboard error will not Reset. APAR SE32408 (PTR SE32408): OSP-PAR-940XCOM CURSOR POSITIONED INCORRECTLY AFTER UPGRADE TO R540 ACCESS FOR WINDOWS After upgrading to R540 Si27741 in Access for Windows, the cursor is positioned incorrectly to the first input field in screen, instead of the last field prior to entering detailed screen. APAR SE32924: CA400EXP-TERMEMUL-UNPRED PCSWS.EXE FAILS DURING PLAYING MACRO ON 5250 SESSION WITH VISTA. CODE PAGES 1399 OR 1390. PCSWS.EXE fails during playing macro. It issues when 5250 display session has host codepage 1399/1390 . Steps to recreate: . 1. Configure 5250 session with host codepage 1399 2. Start recording macro 3. Record signon operation or something_____________________} 4. Stop recording . 5. Try to play macro APAR SE33046: CA400EXP-TERMEMUL-INCORROUT PASTING DBCS/SBCS MIXED DATA TO O-TYPE FIELD INCORROUT In case that FieldWrap is set to 'N' on a PC5250 terminal session, only DBCS data is pasted when DBCS/SBCS mixed data is pasted to an O-type field. This happens after a fix for SE29943 is applied. APAR SE33077: CA400EXP-TERMEMUL-INCORROUT * AT THE END OF A URL IS IGNORED When using hotspots the customer uses an * at the end of a url. This is getting stripped off. APAR SE33291 (PTR SE33291): CA400EXP-TERMEMUL-MSGPCSERR100 PC5250 ABENDS WITH PCSERR100 ERROR PC5250 abends with PCSERR100 error when used in conjunction with screen scraping software. APAR SE33455: CA400EXP-TERMEMUL-INCORROUT DUP KEY BEHAVES DIFFERENTLY ON WINDOWS XP THAN IT DOES WITH WINDOWS 2000. With the keyboards mapped identically, the DUP key behaves differently on Windows XP than it does with Windows 2000. The DUP key seems to be blank when used to Type J field (DBCS-Only data) by WIndowsXP. It does not occur in Windows2000. APAR SE33459: CA400EXP-PRINTEMUL INCORRECT OUTPUT WITH ESC_P.PDT A spooled file has these attributes: 51 lines per page 6 lines per inch for a length of 8.5 inches. A printer session is created that uses the esc_p.pdt table. The printer does not eject the proper distance. Instead, it appears to send down a command to use a 8 inch page length. APAR SE33610: CA400EXP-PRINTEMUL PRINTER EMULATION FAILURE WITH NO PDT AND SI30707 Customer upgraded their service pack from SI10817 to SI30707. After this their printer emulation sessions started failing with Pcsws.exe application error: AppName:pcsws.exe AppVer:5070.60.8024.546 Modname:pcspd.dll ModVer:5070.60.8024.546 Offset:000458bb If they enable pdt support on the session, the failure will not occur. APAR SE33691: CA400EXP-TERMEMUL-INCORROUT PC5250 EMULATOR SCREEN HANGS When a large number of embedded 5250 datastream frames are received in one TCP/IP packet it can hang the emulator. APAR SE33740: CA400EXP-TERMEMUL-UNPRED KONICA MINOLTA PRINTER SUPPORT Add PDT support for Konica Minolta PCL XL printers for Japanese users. SECURE SOCKETS LAYER (SSL) -------------------------- APAR SE33913: CA400EXP-SSL-UNPRED SETTING TLS CIPHER ENV VAR FAILS When selecting a customer preferred TLS cipher in PC5250, the cipher that is actually used is not the one selected. RESOLUTION: This PTF fixes the reported problem. The environment variable CWBCO_TLS_CIPHER_SPECS has been added to override the TLS ciphers used by the Client Access connections. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ No fixes. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI29771 Build date = January, 2008 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE29369 : CA400EXP-NLS-INCORROUT PRE-FORMATTED TEXT BIDI TRANSFORMS APAR SE29543 : CA400EXP-NLS INCORROUT CONVERSION FROM CCSID 935 TO UNICODE APAR SE29861 : CA400EXP-DATEBASE-INCORROUT JAPANESE WINDOWS VISTA, RUN SQL SCRIPTS WINDOW FAILS APAR SE29893 : OSP-OTHER-UNPRED ISERIES NAVIGATOR DOES NOT DROP THE 'Q' WHEN THE REST APAR SE30681 : CA400EXP-NLS-INCORROUT CONVERSION FROM CCSID 5035 TO 932 OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- APAR SE30805 : CA400EXP-INRMTCMD-INCORROUT EXECUTING GRAPHICAL APPLICATIONS iSeries NAVIGATOR ----------------- APAR SE29333 : CA400EXP-OPNAV GRAPH HISTORY SHOWS SPIKES FOR DISK METRIC APAR SE29404 : CA400EXP-OPNAV-DBASE INCREASE LIMIT TO DISPLAY LOCKED ROWS APAR SE31183 : CA400EXP PROPERTIES ACTION NOT SHOWN FOR SYSBASE AND IASP APAR SE29686 : CA400EXP-OPNAV-DBASE EDIT OF A TABLE WITH LOBS NOT SUPPORTED APAR SE29687 : CA400EXP-OPNAV-DBASE-MSGCWBNL0107 EDIT TABLE CONTENTS APAR SE31274 : CA400EXP-OPNAV CHANGE KRB5.CONF FILE AND KERBEROS BATCH FILE APAR SE31184 : CA400EXP-OPNAV-INCORROUT CLUSTER GUI SUPPORT FOR i5OS V6R1 APAR SE31185 : CA400EXP Eclipse Help is not displayed on Windows Vista APAR SE31186 : CA400EXP-MESSAGES-MSGCPF9802 in System Operator messages APAR SE31187 : CA400EXP-OPNAV-INCORROUT Empty dropdown lists for Country/Region and Language fields APAR SE31188 : CA400EXP-OPNAV-DBASE-INCORROUT LOCKED ROWS LIST EMPTY APAR SE31189 : CA400EXP CONTROL DOES NOT RETURN AFTER ADVISOR THROUGH VE APAR SE31190 : CA400EXP-OPNAV-DBASE VISUAL EXPLAIN PREFERENCES LOST APAR SE31191 : CA400EXP-OPNAV-DBASE DISTINCT VALUES CREATING ADVISED INDEX APAR SE31192 : CA400EXP-OPNAV DESCRIPTOR INDEX NOT VALID IN ANALIZE REPORT APAR SE31193 : CA400EXP-OPNAV-DBASE-INCORROUT SYMMETRIC MULTIPROCESSING APAR SE29300 : CA400EXP-OPNAV-OUTPUT EXPORT HAS DUPLICATED PAGES APAR SE29597 : CA400EXP-OPNAV-INCORROUT CLUSTER ADMIN DOMAIN MRE LIST ERROR APAR SE29905 : CA400EXP-OPNAV-PRINTERS-INCORROUT UNABLE TO SORT PRINTER OUTPUT APAR SE29980 : CA400EXP-OPNAV-INCORROUT APPLICATION ADMINISTRATION PLUG-INS SETTING IS NOT APAR SE30183 : CA400EXP-OPNAV-DBASE-MSGSQL0302 UPDATE A TABLE WITH J FIELDS APAR SE30770 : CA400EXP-OPNAV CONFIGURATION AND SERVICE FAILS WITH CPF3CF1 APAR SE30848 : CA400EXP-OPNAV- ERROR CREATING NEW USER WITH JAPANESE CLIENT APAR SE30855 : CA400EXP Help is not available on Rules Editor. APAR SE31060 : CA400EXP-OPNAV-DBASE-MSGCWB0111 UPDATING A CHARACTER COLUMN APAR SE31024 : CA400EXP UCW and ISW do not show new hardware types APAR SE31061 : CA400EXP-OPNAV-DBASE-INCORROUT UPDATE NOT SAVED INTO SERVER APAR SE29016 : CA400EXP-OPNAV-OTHER-UNPRED RUNTIME ERROR IN NAVIGATOR APAR SE31155 : CA400XW1-INCORROUT UNABLE TO RETRIEVE SERVICE AGENT REGISTRATION DETAILS DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE29793 : CA400EXP-DTRANSFER-INCORROUT CUSTOMIZED IASP IS NOT ALLOWED APAR SE29838 : CA400EXP-DTRANSFER-MSGCWBTF0009 CSV FILE TYPE UPLOAD WARNING DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE29150 : CA400EXP-ODBC-MSGSQL0104 INCORRECT ERROR DUE TO SQL PACKAGE APAR SE29339 : CA400EXP-ODBC-WAIT VARIABLE FIELD COMPRESSION APAR SE30295 : CA400EXP-ODBC-INCORROUT INCORRECT TYPE CONVERSION USED APAR SE30749 : CA400EXP-ODBC-WAIT HANG ENDING XA ENLISTMENT OLE DB PROVIDER --------------- APAR SE30751 : CA400EXP-INCORROUT DISTRIBUTED TRANSACTION WITH SQL SERVER 2005 AND IBMDASQL FAILS. APAR SE30788 : CA400EXP-OLEDB-MSGSQL0104 DUE TO SINGLE LINE COMMENTS IN SQL .NET DATA PROVIDER ------------------ No fixes. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- APAR SE29302 : CA400EXP-AFPVIEWER INCORRECT LANGUAGE USED WITH AFP VIEWER TOOLBOX FOR JAVA ---------------- Includes JTOpen 6.1 (2008-01-11) and the equivalent of 5722JC1 PTFs: SI29774 and SI29775 APAR SE29800 : TOOLBOXJAVA-JT400 SCS5553WRITER CLASS CPI Support missing 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20071214 APAR SE29388 : CA400EXP-TERMEMUL-UNPRED PCSWS.EXE EXITS WHEN WINDOWS REGIONAL SETTINGS ARE VIETNAMESE APAR SE29578 : CA400EXP-PRINTEMUL TURKISH CHARACTERS NOT PRINTED CORRECTLY APAR SE29829 : CA400EXP-TERMEMUL-INCORROUT WRONG KEY WITH BULGARIAN KEYBOARD LAYOUT APAR SE30424 : CA400EXP-TERMEMUL-INCORROUT THE CURSOR DOES NOT APPEAR ON THE FIELD IF THAT IS DEFINED DSPATR(BL HI). APAR SE30508 : CA400EXP-TERMEMUL-UNPRED IN A KOREAN INSTALL ENVIRONMENT, SWITCHING BETWEEN APPLICATIONS CAUSES THE EMULATOR TO CLOSE. APAR SE30613 : CA400EXP-TERMEMUL-INCORROUT CLOSING SESSION WITH FILE EXIT ALL CAUSES APPLICATION ERROR ON PCSWS.EXE SECURE SOCKETS LAYER (SSL) -------------------------- APAR SE30656 : CA400EXP-SSL-MSGCWBCO1052 STASH PASSWORD IS NO LONGER CHECKED BY DEFAULT. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ No fixes. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- APAR SE29546 : CA400EXP - XDA stack corruption problem number 2 VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI27741 Build date = July, 2007 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE28143: CA400EXP-INCORROUT CCSID override needed for 300 and others APAR SE28646: CA400EXP-LICMGMT-MSGCWB0999 RC 9052 274D INTERMITTENT CWB0999 RC 9052 274D LICENSE MANAGEMENT ERROR. APAR SE28767: CA400EXP-COMM-INCORROUT CWBPING FAILS FOR MIXED-CASE SERVICE APAR SE29219: CA400EXP-INSTALL-UNPRED Welcome Wizard flashes on Vista Reboot OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE28166: CA400EXP-OPNAV-DBASE-UNPRED ANALYZE CLOSES RUN SQL SCRIPTS APAR SE28319: CA400EXP-OPNAV Cannot change MGTC Job Monitor metrics APAR SE28454: CA400EXP-OPNAV-FILESYS-INCORROUT Missing files in QSYS.LIB APAR SE28529: CA400EXP-OPNAV-OTHER-MSGAS400SECURITYEXCEPTION TOOL ENHANCED APAR SE28632: CA400EXP Association of physical to virtual IP address fails APAR SE28636: CA400EXP-2-INCORROUT START OPTION NOT AVAILABLE APAR SE28749: CA400EXP-OPNAV-DBASE-WAIT WHEN A QUERY HAS AN ERROR IN RSS APAR SE28860: CA400EXP-OPNAV-DBASE-MSGSQL0454 CREATING NEW INDEX APAR SE28988: CA400EXP-OPNAV-DBASE-MSGCPF3219 REORGANIZE AFTER SUSPENDED APAR SE28989: CA400EXP-OPNAV-DBASE-INCORROUT INDEX ADVISOR OVER AN MQT APAR SE29303: CA400EXP-OPNAV-INCORROUT No iSeries Navigator help APAR SE29155: CA400EXP-OPNAV-DBASE-INCORROUT SHOW STATEMENTS FROM ADVISOR APAR SE29214: CA400EXP-OPNAV Last used date APAR SE29215: CA400EXP Subnets sorted on DHCP Monitor APAR SE29217: CA400EXP hardware type 5767/5768 does not allow 1Gb ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE29218: CA400EXP-OPNAV Multi-Path Group Properties Disabled APAR SE29220: CA400EXP Network gui does not show new hardware types APAR SE29223: CA400EXP MGTC Wrong License Key Expiration Date exported DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE28290: CA400EXP-DTRANSFER DOWNLOAD GUI FAILS TO APPEND TO BIG FILES APAR SE28716: CA400EXP-DTRANSFER-INCORROUT HANG DOWNLOADING FILE DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE28376: CA400EXP-2-MSG "Enlist with DTC phase failed. 2" failure in distributed transaction APAR SE28524: CA400EXP-ODBC-INCORROUT ODBC DRIVER KEYWORD TRIMMING OPTION OLE DB PROVIDER --------------- APAR SE28443: CA400EXP-OLEDB-INCORROUT LEADING WHITE SPACE NOT IGNORED APAR SE28973: CA400EXP-OLEDB-PERFM OLEDB NEW BLOCK SIZE PROPERTY APAR SE29198: CA400EXP-OLEDB-INCORROUT LIBRARY LIST PROPERTY ON 64-BIT .NET DATA PROVIDER ------------------ APAR SE28398 : CA400EXP-IDB2DATA-INCORROUT DESERIALIZING IDB2EXCEPTION OBJECT FAILS WITH EXCEPTION. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 6.1 (2008-01-11) and the equivalent of 5722JC1 PTFs: SI29774 and SI29775 No fixes. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20070614 APAR SE28231: CA400EXP-TERMEMUL-INCORROUT YEN SIGN IS CHANGED TO THE MIDDL APAR SE28352: CA400EXP-TERMEMUL-INCORROUT TOOLBAR OPTIONS NOT GRAYED OUT APAR SE28504: CA400EXP-TERMEMUL-UNPRED RUN THE SAME CAUSES PROMPT APAR SE28527: CA400EXP-PRINTEMUL PRINT TO FILE ERROR ON VISTA APAR SE28541: CA400EXP-TERMEMUL-INCORROUT HACL SCREEN RECOGNITION EVENT APAR SE28564: CA400EXP-TERMEMUL-PC5250 SBCS in DBCS field hangs session APAR SE28682: CA400EXP-SECURITY-UNPRED USER PROFILES BELONGING TO MULTIPLE ACTIVE DIRECTORY GROUPS MAY FAIL WITH PC5250 KERBEROS SSO. APAR SE28732: CA400EXP-APIS-OTHER-PERFM CUSTOM PROGRAM USING AUTSESS.DLL, CAUSES A PC5250 PERFORMANCE ISSUE. APAR SE28893: CA400EXP-TERMEMUL-MSGCPIAD06 FAILURE IN APAR SE27644 STILL OCCURS WITH PTFS SI26600 OR SI26879 IF USING MULTIPLE SESSIONS. APAR SE28940: CA400EXP-PRINTEMUL SLOWER PRINTING WITH ESC_P.PDT APAR SE29092: CA400EXP-TERMEMUL-MSGPCSERR101 PC5250 COPY PASTE AFTER EXCEL USED APAR SE29104: CA400EXP-PRINTEMUL FONT IS PRINTED TOO SMALL SECURE SOCKETS LAYER (SSL) -------------------------- APAR SE27311: CA400EXP-SSL-WAIT SSL SLOW RESPONSE PENTIUM D PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ No fixes. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- APAR SE29216: CA400EXP - XDA Stack Corruption Problem VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI26879 Build date = March, 2007 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE28194 : CA400EXP-INCORROUT CWBCFG fails with /IPADDR values OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE28301 : CA400EXP-MSGCPF26A7 ISERIES NAVIGATOR SPOOLED FILE ERROR APAR SE28184 : CA400EXP-OPNAV MGTC MONITORS SHOW FUNCTION NOT SUPPORTED APAR SE27912 : CA400EXP-NETWORK-INCORROUT wrong username on UCW profiles APAR SE28060 : CA400EXP-OPNAV-DBASE-MSGSQL0501 SCROLLING RESULT SET VIEWER APAR SE27913 : CA400EXP-OPNAV-NETWORK-INCORROUT ATT prefix problems APAR SE28171 : CA400EXP-FILESYS Source physical file member is not copied APAR SE28018 : CA400EXP-NETWORK-INCORROUT Incomplete UCW phone list APAR SE28073 : CA400EXP-OPNAV DISPLAY MOUNTED VOLUME APAR SE28169 : CA400EXP-OPNAV-FILESYS Drag and drop causes lost focus APAR SE28165 : CA400EXP COPY MONITOR ONLY COPIES FIRST SELECTION APAR SE28196 : CA400EXP-OPNAV-NETWORK-INCORROUT Remove CIMOM Server APAR SE27684 : CA400EXP-OPNAV-FILESYS Create new folder in QDLS APAR SE27946 : CA400EXP-OPNAV-DBASE CLOSE ACTION NOT WORKING IN MAIN WINDOW APAR SE27976 : CA400EXP-OPNAV-DBASE CANNOT UPDATE DBCS BLANK-ENDED COLUMN APAR SE28007 : CA400EXP-OPNAV-FILESYS Time is missing in date-time columns APAR SE28011 : CA400EXP iNav hangs if user cancels out of SST signon. APAR SE28045 : CA400EXP-OPNAV-UNPRED Long environment name not displayed APAR SE28067 : CA400EXP Add Disk Unit Wizard shows the wrong Frame/Unit APAR SE28130 : CA400EXP-OPNAV DIRECTOR SERVER JOB QCPMGTSVR IS NOT LISTED DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE28174 : CA400EXP-DTRANSFER CHARACTER TRUNCATION WARNING NOT SHOWN APAR SE27880 : CA400EXP-DTRANSFER BATCH APPS CRASH WITH EMPTY LIST FILES APAR SE27774 : CA400EXP-DTRANSFER BATCH /I IGNORE WARNINGS NOT WORKING FINE APAR SE28396 : CA400EXP-DTRANSFER-PERFM TRANSFERS SLOW WITH SI25949 DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE27879 : CA400EXP-DTRANSFER PROTECTED SHEETS CAUSE EXCEL TO CRASH APAR SE28192 : CA400EXP-DTRANSFER EXCEL CRASHES WHEN REQUEST FILE IS EMPTY APAR SE27881 : CA400EXP-DTRANSFER FIELD LENGTH IS INCORRECTLY VALIDATED APAR SE27553 : CA400EXP-DTRANSFER COMMA NOT SUPPORTED AS DECIMAL SEPARATOR APAR SE27739 : CA400EXP-DTRANSFER EXCEL ADDIN DOWNLOAD FAILS IN EXCEL 2007 ODBC ---- APAR SE27524 : CA400EXP-ODBC-INCORROUT AUTOCOMMIT/ISOLATION NOT HONORED APAR SE28179 : CA400EXP-ODBC-MSGCWBCO1047 CONNECTIONS MAY HANG OR ABNORMALL APAR SE28373 : CA400EXP-ODBC-MSGSQL0180 SQLDescribeParam problem OLE DB PROVIDER --------------- APAR SE27877 : CA400EXP-OLEDB-INCORROUT MS SQL SERVER 2005 SP1 DTS Wizard APAR SE27941 : CA400EXP-OLEDB-INCORROUT Error 0x80040E00 in SQLServer SSIS .NET DATA PROVIDER ------------------ No fixes. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 5.3 (02/14/2007) and the equivalent of PTF 5722JC1 SI26731. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20070214 APAR SE28195 : CA400EXP-TERMEMUL-INCORROUT IN A CL PGM THE COMMAND STRPCCMD APAR SE27542 : CA400EXP-PRINTEMUL-PERFM SLOW PERFORMANCE OR FAILURES USING APAR SE27543 : CA400EXP-PRINTEMUL-INCORROUT COLLECT PRINT JOBS FUNCTION APAR SE27549 : CA400EXP-OUTPUT-INCORROUT COMMAND LINE OR UNDERLINE DISAPPEA APAR SE27620 : CA400EXP-2-INCORROUT TERMINAL SERVER ENVIRONMENT DOES NOT APAR SE27644 : CA400EXP-COMM-MSGE004 AUTO RECONNECT WITH BYPASS SIGNON PASS APAR SE27733 : CA400EXP-PRINTEMUL-UNPRED PRINTER SETUP WINDOW ALWAYS DISPLA APAR SE27827 : OSP-PAR PC5250, KOREAN KEYBORD DOESN'T RETURN TO ENGLISH MOD APAR SE28001 : CA400EXP-2-PERFM MEMORY LEAK WHEN RUNNING VB MACRO APAR SE28209 : CA400EXP-INCORROUT APPDATA IDs do not work in Properties APAR SE28247 : CA400EXP-2-UNPRED WINDOW SIZE NOT RESTORED ON SAVED VIEW APAR SE28249 : CA400EXP-OUTPUT-INCORROUT PCOMM TP5250 TERMINAL-FONT INCORRE SECURE SOCKETS LAYER (SSL) -------------------------- APAR SE28292 : CA400EXP-SSL-WAIT Mgmt Central with SSL fails with SI25949 PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE28193 : CA400EXP-OPCON-UNPRED RCS cannot reconnect after close PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- APAR SE27888 : CA400EXP - Enhance XDA Windows client serviceability VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- APAR SE28228 : OSP-INCORROUT EZ-Setup support for Domino 7 --------------------------------- Service Pack Level = SI25949 Build date = December 2006 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE27505 : CA400EXP-NLS-INCORROUT Japanese character conversion APAR SE27507 : CA400EXP Support running on Windows Vista OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE26734: CA400EXP-OPNAV-INCORROUT Wrong Shortcuts settings APAR SE27312: CA400EXP-OPNAV-FILESYS Authority error creating a folder APAR SE26127: CA400EXP-OPNAV ENVIRONMENT CANNOT BE DELETED APAR SE27313: CA400EXP-OPNAV-DBASE-INCORROUT VARYING DATA SIZE DESC DIALOG APAR SE27315: CA400EXP-OPNAV-DBASE-WAIT UNSUPPORTED REFRESH ACTION IN VE APAR SE27411: CA400EXP-OPNAV-DBASE-INCORROUT SHOW ACTIONS OVER MQTs IN VE APAR SE27460: CA400EXP-OPNAV-NETWORK-INCORROUT Router selection hangs APAR SE27412: CA400EXP-OPNAV-DBASE-MSGSQL0443 CANCELING THRESHOLD PROMPT APAR SE27413: CA400EXP-OPNAV-DBASE NONE TREATED AS A DELIMITER IN IMP/EXP APAR SE27459: CA400EXP-OPNAV-DBASE SUPPORT CONDENSED INDEX ADVICE APAR SE27461: CA400EXP-NETWORK-INCORROUT DNS autostart checkbox not saved APAR SE27468: CA400EXP-OPNAV-DBASE NODE UNEXPANDED IN HEALTH CENTER HIST APAR SE27470: CA400EXP-OPNAV-DBASE DISPLAY SIZE FORMAT APAR SE26797: CA400EXP-OPNAV-INCORROUT CLUSTER SWITCH IASP FAILS APAR SE27073: CA400EXP associate virtual IP to physical interfaces APAR SE27216: CA400EXP-DATABASE AN SQL STATEMENT WITH JDBC ESCAPE SEQUENCE APAR SE27281: CA400EXP-OPNAV-PRINTERS-PERFM PERFORMANCE PROBLEM Listing DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE27163: CA400EXP-DTRANSFER BATCH PROGRAMS SHOW ERROR AND CRASH APAR SE26929: CA400EXP-DTRANSFER RXFERPCB & ACTIVEX NOT REPORTING ERRORS APAR SE27233: CA400EXP-DATAXFER MEMBER AND FILE TEXT DO NOT SUPPORT DBCS DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE27102: CA400EXP-DTRANSFER EXCEL ADD-IN CONVERTS TABS TO SPACES ODBC ---- APAR SE26738: CA400EXP-ODBC-PERFM - Several ODBC driver performance fixes APAR SE27506 : CA400EXP-ODBC-INCORROUT BLOCK UPDATABLE CURSOR BEHAVIOR WITH ADO/ODBC APAR SE26605: CA400EXP-ODBC-INCORROUT - CORRUPTS PARAMETER MARK APAR SE26785: CA400EXP-ODBC-INCORROUT INTERNAL DRIVER ERROR WHEN CACHE OLE DB PROVIDER --------------- No fixes. .NET DATA PROVIDER ------------------ APAR SE27502 : CA400EXP-IDB2DATA-MSGSQL0470 Don't set null for output-only parameters APAR SE27503 : CA400EXP-IDB2DATA-MSGSQL0502 after calling SP using ExecuteNonQuery APAR SE27521: CA400EXP-IDB2DATA-UNPRED IDB2DATAADAPTER METHOD LEAKS MEMORY LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 5.2 (08/28/2006) and the equivalent of PTF 5722JC1 SI25173. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20061116 APAR SE25556: CAEXP-PC5250-PRINT-INCORROUT SPOOL FILE IS HELD WITH MSGCPF5 APAR SE26231: OSP MACRO NAME WITH SPACE HIDES OTHER MACRO NAMES APAR SE26558: CA400EXP-TERMEMUL-INCORROUT CURSOR POSITION IS INCORRECT AFT APAR SE26717: CA400EXP-TERMEMUL-MSGECL37180 THE '@' KEY STROKE THROWS AN APAR SE27562: CA400EXP-TERMEMUL Unique session ID limit too small SECURE SOCKETS LAYER (SSL) -------------------------- Non-APAR fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ Non-APAR fixes. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- APAR SE27504 : CA400EXP-DTATRANS-INCORROUT ZonedConverter FromBytes fails APAR SE26929: CA400EXP-DTRANSFER RXFERPCB & ACTIVEX NOT REPORTING ERRORS VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI24893 Build date = September 2006 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE25733: CA400EXP-OPNAV-INCORROUT APPLICATION ADMINISTRATION SIGNON APAR SE25775: CA400EXP - LOB optimization in XDA APAR SE26399: CA400EXP-OPNAV-INCORROUT JOBS FUNCTION UNAVAIL WITH SSL APAR SE26420: CA400EXP-INCORROUT CWBNL0101 FOR CODEPAGE 1386 to 937 OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE25164: CA400EXP-OPNAV CAN NOT SELECT ANSI/ASCII CCSID ON NETSERVER APAR SE25671: CA400EXP-OPNAV Cannot create remote system configuration APAR SE25735: CA400EXP-OPNAV-FILESYS UNABLE TO ADD HOST TO NETGROUP BY IP APAR SE25909: CA400EXP-OPNAV-DBASE MAINTAINED TEMPORARY INDEXES IN ADVISOR APAR SE25910: CA400EXP-OPNAV-DBASE JOB LOG VIEWER HANGS APAR SE25911: CA400EXP-OPNAV-DBASE RSS CANCEL REQUEST NOT FREEING RESOURCE APAR SE25934: CA400EXP-OPNAV-INCORROUT SWITCHABLE DEVICES JAVA TRACE APAR SE25945: CA400EXP-OPNAV-INCORROUT Unable to restart shared monitors APAR SE26107: CA400EXP-OPNAV-DBASE-INCORROUT MULTI-GLOBAL TRANSACT SUPPORT APAR SE26172: CA400EXP-OPNAV-DBASE-INCORROUT SHOW INDEXES AND MQTs APAR SE26232: CA400EXP-OPNAV-DBASE IMPORT DATA WIZARD ALLOWS INVALID INPUT APAR SE26326: CA400EXP-OPNAV-OUTPUT-INCORROUT PAGES PER COPY DOES NOT SORT APAR SE26328: CA400EXP-OPNAV-OUTPUT-INCORROUT SHORTCUTS TO PRINTER OUTPUT APAR SE26339: CA400EXP-OPNAV-INCORROUT ADD SECONDARY DISK POOL FAILS APAR SE26342: CA400EXP-OPNAV-DBASE-INCORROUT BLANK LINES PASTING FROM RSS APAR SE26346: CA400EXP-OPNAV-DBASE-INCORROUT GLOBAL TRANSACTION PROPERTIES APAR SE26430: CA400EXP-OPNAV RUN SQL DEBUGGER NOT DISPLAYING PROPER NLV APAR SE26540: CA400EXP-OPNAV-DBASE-INCORROUT DESCRIPTOR INDEX NOT VALID DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE25348: CA400EXP-DTRANSFER-INCORROUT PASTING DATA AS LINK IN EXCEL APAR SE25421: CA400EXP-DTRANSFER-INCORROUT WRONG COLUMN SORTING IN DISPLAY APAR SE26348: CA400EXP-DTRANSFER CREATE HOST FILE WITH EMPTY COLUMNS FAILS DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE26329: CA400EXP-DTRANSFER EXCEL ADD-IN HANGS AFTER DOWLOADING FILE ODBC ---- APAR SE25951: CA400EXP-ODBC-INCORROUT - SQLTABLES PROBLEM WITH MQT APAR SE26128: CA400EXP-ODBC-INCORROUT PCBVALUE NOT SET FOR RETURN CODE APAR SE26325: CA400EXP-ODBC-MSGERROR IN HOST SERVER DATASTREAM MSACCESS 97 OLE DB PROVIDER --------------- APAR SE25382: CA400EXP-OLEDB-MSGSQL0104 When update recordset using system naming APAR SE25454: CA400EXP-OLEDB-UNPRED WHEN IN PARM IS DEFINED AS IN/OUT APAR SE25755: CA400EXP-OLEDB BLANK PROPERTY IN EXTENDED PROPERTIES FAILS .NET DATA PROVIDER ------------------ APAR SE25710: CA400EXP-IDB2DATA Read & Write LOB data in chunks more often LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 5.1.1 (05/17/2006) and the equivalent of PTF 5722JC1 SI23572. Also includes the equivalent of PTF 5722JC1 SI24544: APAR SE26135: CA400EXP-OPNAV-INCORROUT COMMAND PROMPTER INVALID PWD LENGTH 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20060806 APAR SE24106: CA400EXP-OPCON-HOST PRINT FAILS WITH MSGMCH0601 OR MSGCPF519 APAR SE25092: CA400EXP-TERMEMUL-INCORROUT PC5250 WINDOW DISAPPEARS WHEN APAR SE25262: CA400EXP-PRINTEMUL-INCORROUT PRINT SAME SPOOLED FILE TWICE I APAR SE25697: CA400EXP-COMM-UNPRED PC5250 HANGS AFTER HITTING RESET KEY APAR SE26108: CA400EXP-OUTPUT-INCORROUT DISPLAY FIELDS ARE NOT PRESENTING APAR SE26139: CA400EXP-TERMEMUL-INCORROUT IN A CL PGM THE COMMAND STRPCCMD SECURE SOCKETS LAYER (SSL) -------------------------- No fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ APAR SE25533: CA400EXP-OUTPUT-INCORROUT V5R4 FAXING PC DOCUMENTS SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE25845: CA400EXP-OPCON-INCORROUT cpanel src changes not displayed PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI23696 Build date = May 2006 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE24562: CA400EXP-OPNAV HANDLE LEAK IN APPLICATION ADMINISTRATION APAR SE24598: CA400EXP-OPNAV-INCORROUT extended attributes trap in IFS APAR SE24713: CA400EXP-INSTALL-INCORROUT INSTALL SAME SERVICEPACK TWICE APAR SE24726: CA400EXP-ODBC-INCORROUT SQL BIG-ENDIAN UTF16 WITH 'XXFF' APAR SE25099: CA400EXP-COMM-MSGCWBSY1040 Windows credentials not found APAR SE25422: CA400EXP-TERMEMUL NO PC5250 SOUNDS AFTER V5R4 INSTALL OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE24032: CA400EXP-OPNAV-DBASE-INCORROUT INDEX ADVISOR EMPTY WITH IASP APAR SE24173: CA400EXP-OPNAV-MSGCWBNL0107 EDIT TABLE CONTENTS DBCS BLANKS APAR SE24176: CA400EXP-OPNAV-DBASE-INCORROUT ACCESS PLAN REBUILD COUNT APAR SE24257: OSP-DB-MSGCPFA0A2 ACCESSING PERMISSIONS FROM ISERIES NAVIGAT APAR SE24550: CA400EXP-OPNAV-DBASE-INCORROUT REORGANIZE TABLE INFORMATION APAR SE24551: CA400EXP-OPNAV-MSGCPD8ED5-MSGCPF2718 When adding VE to NWSD APAR SE24625: CA400EXP-OPNAV- Export LPAR configuration to IFS fails APAR SE24642: CA400EXP- Disks on 5787 expansion unit are not displayed APAR SE24710: CA400EXP-OPNAV-INCORROUT History Log msgs of < 5 chars gone APAR SE24711: CA400EXP-OPNAV-DBASE PER MON QUERY JAPANESE COMPATIBILITY APAR SE24873: CA400EXP-OUTPUT-INCORROUT WHEN EXPORT MONITOR DATA FROM INAV APAR SE24882: CA400EXP-OPNAV-JOBS-INCORROUT CURRENT SQL STATEMENT STATUS APAR SE24894: CA400EXP-OPNAV-NETWORK-MSGDATA DATA ENTRY ERROR MESSAGE APAR SE25008: CA400EXP-OPNAV-DBASE EXPLAIN SQL FROM VISUAL EXPLAIN APAR SE25012: CA400EXP-OPNAV-DBASE PREFERENCES IN RUN SQL SCRIPTS ARE LOST APAR SE25014: CA400EXP-OPNAV-DBASE-INCORROUT TIMESTAMP ON SHOW INDEXES APAR SE25050: CA400EXP-OPNAV-NETWORK-INCORROUT IPv6 GUI problems APAR SE25054: CA400EXP-OPNAV Error setting spooled file expiration date APAR SE25068: CA400EXP-OPNAV-DBASE-INCORROUT INVALID COLUMN ID ON INDEXES APAR SE25104: CA400EXP-OPNAV-DBASE SHOW STATEMENTS DIALOG DIMENSION APAR SE25107: CA400EXP-OPNAV Error code 7 on mirror synchronization on IPL APAR SE25123: CA400EXP-OPNAV Unable to add nodes to administrative domain APAR SE25124: CA400EXP-OPNAV CHANGES TO ADMIN DOMAIN NOT PRESERVED APAR SE25125: CA400EXP-OPNAV-INCORROUT Cannot stop cluster APAR SE25235: CA400EXP-OPNAV User name/password not correct on initialize APAR SE25236: CA400EXP-OPNAV Upper case CHAP name shown in mixed case APAR SE25298: CA400EXP-OPNAV LOAD IMAGE CATALOG PANEL APAR SE25299: CA400EXP-OPNAV-DBASE-INCORROUT SHOW STATEMENTS SORT COLUMNS DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE24961: CA400EXP-DTRANSFER USERID NOT SAVED CORRECTLY IN DTT FILE APAR SE25102: CA400EXP-DTRANSFER UNEXPECTED ERROR IN EXCEL WIZARD DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE24170: CA400EXP-DTRANSFER USERID TRUNCATION IN EXCEL ADD-IN ODBC ---- APAR SE00013: CA400EXP-ODBC FETCH PROBLEMS WITH SQL_ATTR_ROW_ARRAY_SIZE APAR SE24285: CA400EXP-ODBC-INCORROUT CAN NOT REGISTER ODBC TRANSLATION OP APAR SE24755: CA400EXP-ODBC DRIVER CRASH WITH LARGE SQL_C_DOUBLE VALUES OLE DB PROVIDER --------------- APAR SE24629: CA400EXP-OLEDB-MSGSQL0104 Problems with long database names .NET DATA PROVIDER ------------------ APAR SE24436: CA400EXP-IDB2DATA-INCORROUT CLOB LENGTH SET INCORRECTLY WITH APAR SE24985: CA400EXP-IDB2DATA-INCORROUT NullReferenceException in GetDcRow LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- APAR SE25325: CA400EXP-AFPVIEWER VERSION 2.02.01.01 TOOLBOX FOR JAVA ---------------- Includes JTOpen 5.0 (12/16/2005) and the equivalent of PTF 5722JC1 SI20169. Also includes the equivalent of PTF 5722JC1 SI23220: APAR SE24779: CA400EXP-OPNAV-INCORROUT Prompting problem with CALLPRC 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20060324 APAR SE22922: CA400EXP-TERMEMUL-INCORROUT CURSOR DOESN'T MOVE TO THE FIRST APAR SE23600: CA400EXP-TERMEMUL-INCORROUT EVENT NOTIFICATION NOT WORKING APAR SE23782: CA400EXP-TERMEMUL-INCORROUT HACL NOTIFYKEYEVENT APAR SE24597: CA400EXP-TERMEMUL-INCORROUT STRPCCMD FAILS WITH BATCH FILES APAR SE24958: CA400EXP-PRINTEMUL-INCORROUT EXTRA SPACE CHARACTER INVALIDAT APAR SE25088: CA400EXP-TERMEMUL-INCORROUT Keyword support for color settings on 5250 APAR SE25221: CA400EXP-TERMEMUL-INCORROUT Not using iNav default SSL port APAR SE25222: CA400EXP-TERMEMUL-INCORROUT PC5250 Macro poppad window size APAR SE25223: CA400EXP-TERMEMUL-INCORROUT PC5250 Macro poppad window focus APAR SE25224: CA400EXP-TERMEMUL-INCORROUT Collect and Print PC5250 jobs SECURE SOCKETS LAYER (SSL) -------------------------- No fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE24807: CA400EXP-OPCON-INCORROUT File access failure causes fault APAR SE24809: CA400EXP-OPCON-INCORROUT Control Panel close may fault APAR SE24811: CA400EXP-OPCON-INCORROUT Apply button causes bootp failure APAR SE25097: CA400EXP-OPCON-INCORROUT Device id out of sync APAR SE25176: CA400EXP-OPCON-INCORROUT gui hang during close APAR SE25177: CA400EXP-OPCON-INCORROUT cwbopcon.exe ends APAR SE25424: CA400EXP-OPCON-INCORROUT UNUSABLE GERMAN CONFIG PANEL PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI22257 Build date = February 2006 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE23024: CA400EXP-ODBC-INCORROUT UTF8 to ME Linux PWS0006 APAR SE23309: CA400EXP - Update the extended user defined field support in XDA APAR SE24325: CA400EXP-TERMEMUL-INCORROUT PRINTER ASSOCIATION CHECKBOX OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE22769: CA400EXP-OPNAV-DBASE-PERFM SPECIFY QAQQINI FILE FOR ANALYZE APAR SE22770: CA400EXP-OPNAV-DBASE-INCORROUT SORTING PERFMON AND SNAPSHOT APAR SE22936: CA400EXP-OUTPUT-INCORROUT Precache causes cwbundbs.exe hang APAR SE23087: CA400EXP-OPNAV-MSGCPF2422 Wrong reply with message monitor APAR SE23239: CA400EXP- IFS GUI crashes when getting usage of directories APAR SE23263: CA400EXP-OPNAV Disk Management Miscellaneous problems APAR SE23288: CA400EXP-OPNAV HISTORY LOG DBCS PARSING APAR SE23295: CA400EXP - Problems in DM GUI when TCP/IP is down APAR SE23296: CA400EXP-OPNAV-DBASE STRING INDEX OUT OF RANGE: -1 WILDCARD APAR SE23312: CA400EXP-OPNAV-INCORROUT Unable to change Model System APAR SE23332: CA400EXP-OPNAV-INCORROUT MRE STACK TRACE ERROR APAR SE23401: CA400EXP-OPNAV-NETWORK Missing Virtual Ethernet Ifc Support APAR SE23447: TCPIP-MSGCPF3CF1 CREATING THE PPP PROFILE FAILS WITH CPF3CF1 APAR SE23507: CA400EXP-OPNAV-DBASE-MSGSQL0443-MSGCPF3224 INDEX ANALYZER APAR SE23618: CA400EXP - Slot D03 on 0595 Tower is not displayed APAR SE23657: CA400EXP-OPNAV DDM SERVER PROPERTIES ON JAPANESE DBCS APAR SE23809: CA400EXP-OPNAV-DBASE-PERFM RSS NO BLOCKS RECS ON CALL PARAMS APAR SE23824: CA400EXP-OPNAV-INCORROUT HISTORY LOG MESSAGE PROPERTIES APAR SE23825: CA400EXP-OPNAV-DBASE-UNPRED EXPLAIN SQL FROM VE EMPTY ERROR APAR SE23835: CA400EXP-OPNAV-DBASE PER MON QUERY JAPANESE COMPATIBILITY APAR SE23837: CA400EXP-OPNAV-DBASE-INCORROUT INDEX FUNCTIONS APAR SE23840: CA400EXP-OPNAV-DBASE-INCORROUT NATIONAL LANGUAGE SUPPORT APAR SE23846: CA400EXP-OPNAV-DBASE-INCORROUT IMPORTING FIXED FORMAT DATA APAR SE23847: CA400EXP-OPNAV-DBASE-INCORROUT SQL PERFORMANCE FUNCTIONS APAR SE23864: CA400EXP-OPNAV DUPLICATE TAPE USES WRONG FROMVOL APAR SE23941: CA400EXP-OPNAV-NETWORK RAS Profile connections may fail APAR SE23946: CA400EXP-OPNAV-NETWORK UCW fixes for ECC support APAR SE23965: CA400EXP-OPNAV-NETWORK AC3 not required for V5R4 VPN server DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE22760: CA400EXP-DTRANSFER - Vertical aligment incorrect for HTML APAR SE23381: CA400EXP-DTRANSFER-INCORROUT DATA TRANSFER TO PRINTER APAR SE23668: CA400EXP-DTRANSFER Customized sheet names for Excel files APAR SE24030: CA400EXP-DTRANSFER A CRASH OCCURS WHEN BROWSE FOR LIBRARIES APAR SE24081: CA400EXP-DTRANSFER INCORRECT CELL TEXT ALIGNMENT IN HTML DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE23267: CA400EXP-DTRANSFER-WAIT DATA TRANSFER EXCEL ADD-IN HANGS ODBC ---- APAR SE22732: CA400EXP-ODBC-PERFM RESULTS SETS ARE RETURNED WITH BLOCKING APAR SE22932: CA400EXP-ODBC Support loosely-coupled XA transactions APAR SE23227: CA400EXP-ODBC-INCORROUT POUND STERLING SYMBOL IN ODBC DS APAR SE23930: CA400EXP-ODBC-INCORROUT Improved Delimited Names Support OLE DB PROVIDER --------------- No fixes. .NET DATA PROVIDER ------------------ APAR SE22266: CA400EXP-IDB2DATA Item has already been added to collection APAR SE22506: CA400EXP-IDB2DATA .NET Provider with .NET Framework 2.0 APAR SE23880: CA400EXP-IDB2DATA-MSGCPD0005 Trace - wrong decimal separator APAR SE24056: CA400EXP-IDB2DATA Server trace fails with system naming LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 5.0 (12/16/2005). 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20051220 APAR SE23207: CA400EXP-TERMEMUL-INCORROUT SPECIFIC CHARACTERS GET GARBAGE APAR SE23367: CA400EXP-TERMEMUL-UNPRED LONG NAME MACRO IN .PMP APAR SE23503: CA400EXP-TERMEMUL-INCORROUT DBCS PASTE ADDS SBCS BLANK SECURE SOCKETS LAYER (SSL) -------------------------- No fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE23862: CA400EXP-OPCON-INCORROUT CWBOPAOC.EXE FAULT CONNECTING LAN PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI20465 Build date = October 2005 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE21177: CA400EXP-INCORROUT cwbback.exe faults on some PCs APAR SE21440: CA400EXP-ODBC-INCORROUT INSERT OR UPDATE FROM PC UNICODE TO APAR SE21823: CA400EXP-INSTALL-INCORROUT AFP VIEWER ON 64BIT APAR SE22152: CA400EXP-RMTCMD RMTCMDS WHICH PREVIOUSLY RETURNED ERROR LEVE APAR SE22356: CA400EXP-OPNAV-INCORROUT IFS fault with extended attributes OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE21629: CA400EXP-OPNAV-DBASE-WAIT LOCK NOT RELEASED BY EDIT CONTENTS APAR SE22008: CA400EXP-OUTPUT-INCORROUT Change URL of Infocenter APAR SE22609: CA400EXP-OPNAV-INCORROUT Problems in some Cluster wizards DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE20527: CA400EXP-DTRANSFER UNICODE DATA WITH X'1A' IN THE DATA APAR SE20765: CA400EXP-DTRANSFER-MSGCWBTF0005 UPLOAD OF MS EXCEL APAR SE21329: CA400EXP-DTRANSFER-INCORROUT WARNING MESSAGES STOP RFROMPCB APAR SE21880: CA400EXP-DTRANSFER-INCORROUT SENDS MULTIPLE SHEETS APAR SE22045: CA400EXP-DTRANSFER INCORRECT TRANSLATE FROM VALUE DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE21228: CA400EXP-DTRANSFER-WAIT MS EXCEL TRANSFER FROM HANGS ODBC ---- APAR SE20631: CA400EXP-ODBC-INCORROUT BLOCK UPDATE FAILS WITH NO MESSAGE APAR SE20801: CA400EXP-ODBC-INCORROUT SPORADIC CONVERSION ERROR APAR SE20919: CA400EXP-ODBC-INCORROUT STORED PROCEDURES COMPILED WITH *CAL APAR SE21192: CA400EXP-ODBC-INCORROUT ODBC RUNNING AT INCORRECT ISOLATION APAR SE21505: CA400EXP-ODBC-MSGSQL0100 PRE-FETCH OF DATA APAR SE21580: CA400EXP-ODBC-MSG7399 DISTRIBUTED TRANSACTION FAILS WITH ERR APAR SE21773: CA400EXP-ODBC-WAIT A CALL TO A PROCEDURE CONTAINING BLOB APAR SE21909: CA400EXP-ODBC Character truncation error converting exponential number from SQL_C_CHAR to SQL_DECIMAL OLE DB PROVIDER --------------- APAR SE21950: CA400EXP-OLEDB-INCORROUT SETTING PROPERTIES WITH SQL SERVER .NET DATA PROVIDER ------------------ APAR SE20843: CA400EXP-IDB2DATA DataAdapter with LOB locators fail APAR SE21919: CA400EXP-IDB2DATA Avoid implicit prepares when not necessary APAR SE21966: CA400EXP-IDB2DATA-INCORROUT .NET PROVIDER CONNECTION MANAGEMENT LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.8 (10/06/2005). 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20050818 APAR SE20279: OSP-PAR PRINTER SESSION, FILE, PAGE SETUP, FORMS SETTING APAR SE20458: CA400EXP-INCORROUT DISABLE STRPCCMD COMMAND VIA WS KEYWORD APAR SE20629: CA400EXP-PRINTEMUL-MSGCPF5261 ERROR PRINTING WITH RHM WITHIN APAR SE20734: CA400EXP-PC5250 KANA MODE INPUT INCORROUT ON CP1399 SESSION. APAR SE20890: CA400EXP-TERMEMUL-INCORROUT FUNCTION KEY NOT ALLOWED WHEN US APAR SE20923: CA400EXP-TERMEMUL-INCORROUT LETTER "O" AND ZERO NOT DISCERNA APAR SE21646: CA400EXP-TERMEMUL-INCORROUT POPUP MENU BAR OPERATION APAR SE21726: CA400EXP-TERMEMUL-INCORROUT KOREAN INPUT ON CODEPAGE 037 SECURE SOCKETS LAYER (SSL) -------------------------- APAR SE22490: CA400EXP-INSTALL-INCORROUT SSL GSKIT 7.0.3.18 PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE21607: CA400EXP-OPCON-INCORROUT OpNav service functions unavailable PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. 4.0 INSTALL/UNINSTALL CONSIDERATIONS ------------------------------------- The following sections describe additional support and known problems that you may notice while using the Install/Uninstall function. 4.1 REMOVING THE SERVICE PACK ------------------------------ To remove this service pack from your PC (if the service pack was originally installed with the Enable Service Pack Uninstall option): 1. Click the Windows Start button, click on Settings, and then click on Control Panel. 2. Double-click on the Add/Remove Programs icon. 3. Click on the Change or Remove Programs button (if necessary), then find and click on the IBM iSeries Access for Windows SI25949 item, and then click on the Change/Remove button. 4. Follow the instructions on the screen. Note: The SSL component fixes installed with this service pack cannot be removed as part of the service pack. To remove SSL fixes, use Selective Setup to remove the SSL component, then run Selective Setup again to re-install the SSL component, then apply the desired level of product service pack. 4.2 UNABLE TO INSTALL FROM THE SERVICE SOURCE? ----------------------------------------------- InstallShield is the tool used to provide the install support for iSeries Access for Windows. The same tool is used for installing service packs. Setup.exe has a 2 minute timeout to initialize to the first wizard panel, which could expire when installing service packs over very slow communication lines. If installing from a CD or a faster connection is not possible, then the service pack could be installed in this manner: 1) A setting exists on the iSeries Access for Windows Properties Service tab that will copy the service pack image to the PC's temporary directory, install the service pack, then remove the copied files. To use this support you will need to specify this setting ("Copy install image to PC before installing"). 2) Run Check Service Level (either from the IBM iSeries Access for Windows Service folder shortcut or when Check Service Level runs at system boot on its defined schedule) STATUS: No status information is displayed while the files are copied. To determine if the transfers are progressing, look in the 'CA400CKV' temporary directory (beneath the PC temporary directory, for example C:\Documents and Settings\username\Local Settings\Temp). You should see new files appear periodically. 3) Proceed through the Service Pack install wizard to complete the install. 4.3 SERVICE PACK CONTROL ------------------------- To prevent users from installing the Service Pack, an administrator can use the SP.TXT file. If the administrator places a file named SP.TXT (with a 'N' in the first position of the first line) in the service pack installation image directory, the service pack will not be installed. 5.0 DATA TRANSFER CONSIDERATIONS --------------------------------- The following sections describe additional support or known problems that you may notice while using the Data Transfer function. 5.1 TRANSFERRING DATA WHEN THE FILE OR DATA CCSID IS 65535 ----------------------------------------------------------- WHY DOES MY DATA LOOK LIKE GARBAGE WHEN I PERFORMED A DOWNLOAD? By default, the Data Transfer function will not convert data between EBCDIC and ASCII if the data is tagged with a CCSID of 65535. In older versions of the Win 95/NT Client Access product, the 65535 conversion was controlled by the CWBTFR.INI file. This process has been changed, and the conversion is now controlled by the Data Transfer user interface. Once the setting has been made in the user interface, it is then stored in the transfer request. This is only true for .TTO, .TFR, .DTT, and .DTF files. .RTO and .DT files are still controlled by the CWBTFR.INI file. The conversion setting for .RTO and .DT files can be modified in the Data Transfer user interface, but the setting will not be saved. The setting to control the conversion is found in the File, Properties information. WARNING: This feature is designed as a workaround for people that can not change the CCSID of their files. In order for this translation to work properly, you must be confident the data in the file matches the CCSID of your user profile. The design of the iSeries is that data with a 65535 CCSID are not to be converted. This feature will attempt to do a conversion of the data from the job CCSID to the PC CCSID. This conversion may not work if the data in the file does not match the user profile/job CCSID. The correct solution to this problem is to appropriately tag the data with the correct CCSID. One way of doing this is by using CHGPF. For more information on the 65535 CCSID, please reference the iSeries National Language Support Manual.