============================================================================= Readme File for System i Access for Windows Service Packs 5761-XE1 V6R1M0 Cumulative Service Pack Level ------------- SI34289 ------------- (c) Copyright IBM Corporation 2009. All rights reserved. ============================================================================= 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 A System i 1.2 COMBINING THE SERVICE PACK WITH A System i ACCESS FOR WINDOWS INSTALL IMAGE 1.3 INSTALLING A SECONDARY LANGUAGE 2.0 RECOMMENDATIONS/RESTRICTIONS 2.1 System i SERVER FIXES 2.2 APPLICATION DEVELOPMENT FUNCTION WITHIN System i NAVIGATOR 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS - SERVICE PACK LEVEL = SI34289 (February 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 A System i -------------------------------------- The following method would be used if you have received the System i Access for Windows service pack through the System i PTF ordering process either as an individual PTF order or as part of an i5/OS PTF cumulative package. Once this service pack has been applied to a System i with the LODPTF and APYPTF System i commands, it can be installed on individual PC's with the "Check Service Level" shortcut in the System i Access for Windows Service folder. Check Service Level, controlled by the System i 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 command will update each of the System i Access for Windows install image directories (\QIBM\ProdData\Access\Windows\image32, \QIBM\ProdData\Access\Windows\image64a and \QIBM\ProdData\Access\Windows\image64i) on the System i. Any client that installs System i Access for Windows (or selected features) from one of these images 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. NOTE: The System i contains three System i Access for Windows install images, one for each processor architecture supported by System i Access for Windows: \QIBM\ProdData\Access\Windows\image32 for 32-bit (X86) based PCs, \QIBM\ProdData\Access\Windows\image64a for AMD64 based PCs and \QIBM\ProdData\Access\Windows\image64i for Itanium based PCs. Running setup.exe from the System i Access for Windows install image directory that matches your PC's processor type (\image32 for 32-bit (X86) based PCs, \image64a for AMD64 based PCs or \image64i for Itanium based PCs) will launch the install wizard for that specific architecture. Running cwblaunch.exe from the System i Access for Windows install image root directory (\QIBM\ProdData\Access\Windows) will determine your PC's processor architecture and accordingly launch the install wizard from the appropriate image directory. RMVPTF will restore your System i install image to the prior service level (or the base release if there was no prior service pack applied). 1.2 COMBINING THE SERVICE PACK WITH A System i ACCESS FOR WINDOWS INSTALL IMAGE -------------------------------------------------------------------------------- The following method could be used if you downloaded the service pack from the System i Access for Windows web page location: http://www-03.ibm.com/systems/i/software/access/ System i Access for Windows service pack PTFs are combined with the original System i Access for Windows installation images in \QIBM\ProdData\Access\Windows\image32, \QIBM\ProdData\Access\Windows\image64a and \QIBM\ProdData\Access\Windows\image64i. This means that a user can install (or upgrade) System i Access for Windows from one of these combined image directories and get the latest applied service level automatically in one integrated step - since the original installation images files have been replaced by updated versions via the service pack PTF. If your install image resides on a local or network drive, you can download the service pack from the System i Access for Windows web page. Then you can combine your installation image with the service pack in order to update it to the latest service level. You will need to create an administrative install image and then use the appropiate UPDATE.EXE download available in the service pack FTP directory to update the administrative image to the latest service pack level. NOTE: You can not combine a service pack with the image that was shipped with your System i Access for Windows DVD or your System i. You need to create a separate administrative image as explained below. To create the administrative install image follow these steps: 1. Open a command prompt window. 2. Change directories to the folder containing the System i Access for Windows install image. This can be the image on the System i, the image on the System i Access for Windows DVD or an image on a local or network drive. 3. Run the following command: SETUP.EXE /a The installation wizard will start. 4. If your install image has multiple language sources, you will be prompted to choose one as your Primary Language. 5. In the Network Location dialog, choose the target directory for your administrative image and click Install. The administrative image will be generated under the chosen directory. You only need to perform this process once. Subsequent service packs can be combined with the same administrative image. Once you have an administrative image, you can merge it with the service pack by following these steps: 1. Download UPDATE.EXE from the service pack FTP directory to a directory on your PC or server. NOTE: a separate version of the UPDATE.EXE download exists for each installation image type: for the 32-bit based image you must download UPDATE_32.EXE, for the 64-bit AMD based image download UPDATE_64A.EXE and for the Itanium based image download UPDATE_64I.EXE. 2. Open a command prompt window. 3. Change directories to the folder containing UPDATE.EXE. 4. Run the following command: UPDATE.EXE /v"/a X:\admin_image\cwbinstall.msi" where X:\admin_image denotes the drive and directory containing the administrative image. The installation wizard will start. 5. Follow the instructions in the wizard to start the update process. 4. The target administrative image will be updated to the new service level. 5. After completion, you can delete the downloaded UPDATE.EXE file, as it is no longer needed. A user that installs from the merged administrative image will get the latest applied service level automatically. Users that originally installed from the administrative image can reinstall by running SETUP.EXE from the merged image or by using the "Check Service Level" shortcut in the System i Access for Windows Service folder to get the latest service level. NOTE: Users that originally installed System i Access for Windows from the System i, from the System i Access for Windows DVD or from any other source that contains a non-administrative image, will not be able to reinstall from an administrative image. Only installations that were initially done from an administrative image can be updated by reinstalling from a merged administrative image. 1.3 INSTALLING A SECONDARY LANGUAGE ------------------------------------ Starting with service pack SI31390, customers can install secondary languages in V6R1M0 System i Access for Windows as in previous releases. You can install secondary languages from a System i platform that has both System i Access for Windows (5761–XE1) and the desired secondary language installed, or from the System i Access for Windows V6R1M0 DVD, as long as the client computers have the latest service level installed. The following instructions describe how to install secondary languages from a System i and from the DVD. Note: in the steps detailed below, you can use setup.exe instead of cwblaunch.exe as long as you are located in the ImageXX folder that contains the installation image that is right for your PC, i.e. Image32 for 32-bit based PCs, Image64a for AMD 64-bit and Image64i for Itanium. To install a secondary language from a System i In order to make secondary languages available to your users, you first need to apply System i Access for Windows PTF SI31390 or later on your System i. During a new installation: 1. Map a drive to the System i QIBM sharepoint (\\NetServerName\QIBM). 2. Double-click QIBM > ProdData > Access > Windows > cwblaunch.exe to start the setup program. 3. Choose a Custom installation to select which secondary languages and features you want installed to your PC. Note: If you select a Complete or a PC5250 User installation, no secondary languages will be installed by default. In this case, you can specify what secondary languages to install with the CWBADDSECLANG property from the command line, as explained below. 4. Complete the wizard. During an upgrade: 1. Map a drive to the System i QIBM sharepoint (\\NetServerName\QIBM). 2. Double-click QIBM > ProdData > Access > Windows > cwblaunch.exe to start the setup program. 3. Choose a Custom installation. If you had the secondary language installed in the previous version, the language will appear selected under the Languages node. You can select which secondary languages and features you want to add or remove. 4. Complete the wizard. Note: If you have secondary languages and the .NET Data Provider installed in the previous version, you must: 1. Use Selective Setup to uninstall the .NET Data Provider prior to upgrade. Upgrading .NET Data Provider secondary languages is not supported by System i Access for Windows V6R1M0. 2. Run cwblaunch.exe to start the upgrade as described above. To install a secondary language after System i Access for Windows has been installed: 1. Map a drive to the System i QIBM sharepoint (\\NetServerName\QIBM) 2. Double-click QIBM > ProdData > Access > Windows > cwblaunch.exe to start the setup program. 3. If your local installation is at an older service level than the level on the System i, the installation program will be launched in service pack mode. At this time you will not be able to add secondary languages yet. Complete the service pack wizard, then re-run cwblaunch.exe as pointed out in the next step. 4. Run cwblaunch.exe from QIBM > ProdData > Access > Windows to start the maintenance wizard. 5. Choose Modify to select which secondary languages you want installed on your PC. 6. Complete the wizard. To install a secondary language from the V6R1M0 System i Access for Windows DVD Since the V6R1M0 System i Access for Windows DVD was shipped without secondary language support,you first must install System i Access for Windows from the DVD, then download service pack SI31390 or later from the System i Access for Windows web site and install it on the PC, then re-run the installation from the DVD in order to install secondary languages. 1. Install the System i Access for Windows DVD by running Windows > cwblaunch.exe. 2. Download the latest service pack from the System i Access for Windows web site. Note: Make sure to download the service pack version that is right for your computer’s processor architecture. 3. Launch the service pack download on your PC in order to upgrade System i Access for Windows to the new service level. 4. From your DVD, double click Windows > cwblaunch.exe to start the maintenance wizard. 5. Choose Modify to select which secondary languages you want installed on your PC. 6. Complete the wizard. Using CWBADDSECLANG to add secondary languages A new public property named CWBADDSECLANG is available to specify secondary languages from the command line. This is particularly useful for unattended installations. Note that your local installation of System i Access for Windows V6R1M0 must be at service level SI31390 or greater. Otherwise, the CWBADDSECLANG property will be ignored. If System i Access for Windows is not yet installed, then your source installation image must be at service level SI31390 or greater. If you are installing from the System i Access for Windows V6R1M0 DVD then, after installing the DVD, you must download and install service pack SI31390 or later from the System i Access for Windows web site prior to use CWBADDSECLANG. To specify secondary languages at the command line: 1. Open a command prompt window. 2. Change directories to your installation image: - If you are installing from a System i, change directories to QIBM > ProdData > Access > Windows. - If you are installing from DVD, change directories to the Windows folder. 3. Type in the following command: cwblaunch /v"CWBADDSECLANG=mri29xx,mri29yy,…" Where mri29xx, mri29yy, etc. are the NLV codes of the languages that you want to install. Note: a list of 29xx NLV codes is available in the IBM i5/OS information web site at http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/index.jsp Search for "National language version feature codes". 4. To install secondary languages silently, type in the following command: cwblaunch /s /v"/qb CWBADDSECLANG=mri29xx,mri29yy,…" 5. To install all languages available on your installation image, specify CWBADDSECLANG=ALL. 6. Complete the wizard. To install a secondary language from a custom DVD You can burn a DVD out from the updated image residing on your System i, and distribute this custom DVD to your users so they can install secondary languages from the DVD without needing to download the service pack from the web. 1. Apply System i Access for Windows PTF SI31390 or later on your System i. 2. Map a drive to the System i QIBM sharepoint (\\NetServerName\QIBM). 3. Burn the contents of QIBM > ProdData > Access > Windows to your DVD. Note: The three images under the Windows folder might not fit on a single DVD. In that case, you can burn just the image that is needed by your users -i.e. Image32, Image64a or Image64i. 4. Instruct your users to run cwblaunch.exe from the custom DVD in order to install secondary languages. The procedure is identical to the steps described under the section 'To install a secondary language from a System i' above. After you have installed the secondary language, use System i Access for Windows Properties to select the language you want to use. Notes: - You must run cwblaunch.exe –or setup.exe- in order to install secondary languages. You cannot install secondary languages from the Add or Remove Programs panel; in that case, the Languages node will not be available. 2.0 RECOMMENDATIONS/RESTRICTIONS --------------------------------- 2.1 System i SERVER FIXES -------------------------- In addition to installing the System i 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 System i Technical Support: Recommended fixes at http://www-912.ibm.com/s_dir/slkbase.nsf/recommendedfixes 2.2 Application Development function within System i Navigator --------------------------------------------------------------- The Application Development folder within System i Navigator is added when the System i 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. 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 = SI34289 Build date = February 2009 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE35852: CA400EXP-INSTALL ADMIN IMAGE FAILS FROM NETWORK DRIVE Attempting to update an administrative image with service pack SI32504 fails when the installation image is located on a network drive. The user is presented with the following message: "Could not update readmesp.txt. rc=3" The installation log file contains the following message: 'CopyFile' for 'source: "readmesp.txt", target: "readmesp.txt"' failed with return code '3' RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Copy the administrative installation image as well as the service pack executable to a folder on your local PC, and perform the update process locally. Once the update process has been completed, you can copy the administrative image back to the distribution point in your network. APAR SE36316: CA400EXP-INSTALL ADMIN IMAGE FAILS WHEN USING NON-ENGLISH The problem occurs when the customer combines service pack SI32504 with an administrative image and starts an installation from the combined image, and in the Choose Setup Language dialog selects a language other than English. The following message is displayed: "Fel 2229. Database: Could not load table 'LaunchCondition' in SQL query: SELECT 'Condition', 'Description' FROM 'LaunchCondition'" RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: The customer can start the installation and select English in the Choose Setup Language dialog. Although the installation wizard will be presented in English, the customer will be able to select any language as the product's primary language. APAR SE37017: CA400EXP-INSTALL-LOOP Hang when JAVA plug-in file not found When a Java file defined in the setup.ini is not found in the plug-in files, it may cause an infinite loop. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. System i NAVIGATOR ----------------- APAR SE37020: CA400EXP Inbound Admission Policies list is not loaded This problem is reproducible in the web environment: - Go to Network -> Show All Network Tasks -> Quality of Service -> Change Configuration. - Click on 'Inbound Admission Policies' from the QoS tree. - If policies do not already exist, create at least one. - If policies do already exist, they are not listed correctly in the table on the right panel. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE37021: CA400EXP v.25 Bis command string is not saved Go to Network, Remote Access Services, Originator Connection Profile list. Open a switched Originator connection profile. Go to connection, open line properties. (Must be external modem) Select AT dial command type, Enable v25 bis command, Set some string command. Save line and profile. The change in the command string was not saved. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE36983: CA400EXP UCW problem with proxy password confirmation Select Network->Remote Access Services->Originator Connection Profiles. Right-click on Configure IBM Universal Connection. Using the Universal Connection Wizard, select "Additionally configure a proxy connection." Configure a user ID and password for the proxy under the Proxy Destination panel. A confirmation panel for the password pops up, and the "OK" button is hidden behind a button that says "confirmPassword.Button3.TEXT". ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE37022: CA400EXP-OPNAV UNEXPECTED ERROR EXECUTING AN SQL SCRIPT When running an SQL statement in Run SQL Scripts the user may get an unexpected MSGSQL0104 error message. The error may happen when trying to execute a script which contains a CASE...END CASE clause. This causes the end of the SQL statement to not be handled properly. ADDITIONAL KEYWORDS: DBASE-MSGSQL0104 RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Remove the word 'CASE' from the phrase 'END CASE'. APAR SE37024: CA400EXP-OPNAV-DBASE-INCORROUT COMMAND PROMPTER IN RSS When using the Run SQL Scripts (RSS) window, the user may get incorrect output when prompting a CL command through the Command Prompter. The problem may happen after the user has brought up the Command Prompter dialog in the current RSS session, switched to another system with a different release and then brought up the Command Prompter dialog again. The available parameters would be the same as the first time the user displays the dialog. APAR SE37025: CA400EXP-OPNAV-DBASE-INCORROUT ANALYZE A SUMMARY SQL MONITOR When the user is in the SQL Performance Monitor list, and they try an analyze action over a monitor, they may get an 'An unknown error has occurred.' error dialog. The steps to recreate are as follow: 1. Open the SQL Performance Monitors list 2. Start a Summary monitor 3. End the Summary monitor. Its status is updated (from Started to Ended). 4. Select the 'Analyze...' context menu action of the just created monitor. RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Refresh the list before doing the analyze action. APAR SE37026: CA400EXP-OPNAV DEFAULT IP ADDRESS CREATING AN SQL MONITOR When creating a Detailed SQL Performance Monitor, the Client location field may display an incorrect default value. ADDITIONAL KEYWORDS: DBASE-INCORROUT APAR SE37027: CA400EXP DNS GUI is unable to set IPv6 in dynamic update Go to Network -> Servers -> DNS. Click the Configuration action of an interface. Click New Primary Zone option from the Server\forward lookup zone folder. Set the zone to perform dynamic updates. While trying to add elements to the Address Match List, IPv6 addresses cannot be specified. IPv6 addresses are also not allowed in the allow-update statement via zone properties. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT 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 SE37029: CA400EXP OSPF interface authentication GUI problems When an interface has its authentication type set to 'Area,' some rare behaviors appear on the GUI. Go through Network -> Servers -> TCP/IP -> OMROUTED -> OSPF -> Properties. Go to the 'Interfaces' tab, select an existing IPv4 interface, and click on the 'Edit' button. Go to the 'Authentication' tab: 1. When 'Area' is selected as 'Authentication type,' the password is always validated as MD5, even if the area is configured with authentication type as password. 2. When editing the interface which has 'Area' as 'Authentication type,' the confirm password value is not stored and the password's fields are not enabled. 3. The Authentication key's valid range is from 1 to 255 when MD5 is selected. 4. Authentication passwords accepts invalid entries. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE35394: CA400EXP-OPNAV-FILESYS OBJECTS SORTS INCORRECTLY File System objects sorts incorrectly in the main list of Integrated File Systems when the user sorts by selecting the Type column. The objects are only sorted by the type but the objects should be sorted by type and then alphabetically by the name. APAR SE35432: CA400EXP Value from SMTP Filter tab not saved Select Network->Servers->TCP/IP. Select SMTP and right-click on Properties. Go to the Filters tab. Select the "Keep message" radio button. The selection is not saved. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE35482: CA400EXP LAST TWO LIBRARIES ARE NOT SHOWN UNDER QSYS.LIB Additional keywords: OPNAV-FILESYS When QSYS.LIB contains more than 200 libraries, the last two libraries are not shown. This error occurs using File Systems in the System i Navigator. APAR SE36007: CA400EXP Error adding static routes in RAS profiles Go to Network, Remote Access Services, Originator Connection Profiles. Select profile, open properties. Unable to define static hosts routes for PPP connections. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE36188: CA400EXP RAS GUI is setting a different value internally for pap Go to Network -> Remote Access Services -> Originator Connection Profile list. Create or change an Originator profile. The Remote Access Services GUI is setting a different value internally for PAP. This causes PAP to fail on PPP connections to remote hosts. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE36469: CA400EXP-OPNAV-FILESYS DOES NOT SHOW DETAILS BUTTON The "Details..." button, from the "Use" page is not enabled when the file is in use by a job. The "Details..." button is in the "Use" page, that is displayed following these steps: 1. From System i Navigator, click on Integrated File System. 2. Click on Root. 3. Right click on a file that is in use by a job. 4. Select Properties. 5. Click on the "Use" tab. 6. Click on the "Show Usage..." button. APAR SE36552: CA400EXP-OPNAV Warning after dynamic update on DNS GUI Go to Network. Go to Servers. Go to DNS. Select an instance with a dynamic update performed. The DNS Navigator displays a warning triangle icon in the tree for dynamic zones after a dynamic update. ADDITIONAL KEYWORDS: 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. APAR SE36608: CA400EXP ENABLE PROXY ARP SAVES THE HOST SUBNET MASK Go to Network-> TCP/IP Configuration-> IPv4-> Interface List. In the Properties of a Virtual Ethernet Interface, Enabling Proxy ARP automatically changes the subnet mask to 32-bit for iSeries servers running V6R1M0. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE36617: CA400EXP-OPNAV NETWORK PRINTERS NOT SHOWN AT GRAPH HISTORY The Graph History and System Monitor Print panels do not show the network printers in the list of printers the customer can select from. RESOLUTION: Code has been changed to retrieve all (local and remote) printers in the network connection. APAR SE36633: CA400EXP Problem adding Remote Name Server in DNS GUI Go to Network -> Servers -> DNS. Select the instance and click configuration. Select File -> Properties, then select the Remote Name Server tab. Add a remote name server. At save time, the DNS GUI adds both IPv6 and IPv4 statements. This causes the DNS to fail during startup with a message in joblog like the following: named[4614] - /QIBM/UserData/OS400/DNS/WIGMU/named.conf:1642: server 'x.x.x.x': query-source-v6 not legal. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT RESOLUTION: This PTF fixes the reported problem. The statements that do not correspond to the remote server IP version are ignored. APAR SE36717: CA400EXP VPN IPSEC DATA POLICY DOES NOT SAVE 3DES When configuring IPSEC data policy Tunnel using iSeries Navigator, you can select the 3DES, but it will not be saved. Select 'Network' -> 'IP Policies' -> 'Virtual Private Networking' -> 'IP Security Policies'. Right click on 'Internet Key Exchange Policies' and select the 'New Internet Key Exchange Policy' option. When the properties page appears, complete the configuration for the 'Remote Server' and 'Association' panes, then go to the 'Transform' pane. Click on the 'Add' button. After the 'Internet Key Exchange Policy Transform' dialog is displayed, set '3DES-CBC' as the encryption algorithm. Commit the Internet Key Exchange configuration. In the left pane, right click on 'Data Policies' and select 'New Data Policy'. Enter the configuration in the 'General' pane. Go to the 'Proposal' pane and click on the 'Add' button. When the 'New Data Policy Proposal' property sheet appears, go to the 'Transforms' pane and click on the 'Add' button. After the 'Data Policy Transform' dialog appears, select the 'Protocol' -> 'Encapsulating security payload (ESP)' radio button. Set the encryption algorithm as '3DES-CBC' and commit the transform dialog. The column 'Encryption Algorithm' at the transforms list displays '---' instead of the configured value. Also, after saving the Internet Key Exchange Policy and reopening, the Transform List buttons are grayed out -- even if the first transform is selected. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE36749: CA400EXP Changing the TCP/IP configuration properties fail Go to Network-> TCP/IP Configuration-> Properties. When specifying the Domain Name of the system, if hyphens are included in the name, the following message is shown: Expression parameter not allowed for parameter DMNNAME. Error found on CHGTCPDMN command. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE36874: CA400EXP-OPNAV-DBASE IMPORT TO TABLE WITH CCSID 13488 FAILS When using the Data Import wizard in System i Navigator - Database to import data into a target table with a CCSID of 13488, the import will fail. RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: This problem can be circumvented by pressing the Show Command button on the last page of the Import wizard. The CL command for the error record file may look like this: /* Creating error record file */ CL:CRTSRCPF FILE(QTEMP/QAUGDBERCD) RCDLEN(959) CCSID(13488); Change the CCSID parameter value in this command to be CCSID(1208) and run the commands from within the Run SQL Scripts window. APAR SE37019: CA400EXP Unsaved parameters and missing panel on QoS wizard Problem 1: 1. Select System i -> Network -> IP Policies -> Quality of Service -> Configuration 2. Open the wizard to create a new Inbound policy or to change the properties of an existing policy 3. On the Codepoint window (or tab in properties), select "Specific codepoint", and select the first codepoint of the list. 4. On the Local IP Address window (or tab in properties), select "IP address" and select the first IP address of the list. 5. Save the changes clicking on Finish button (or OK in properties). 6. Open the created (modified) policy properties. Result: The Codepoint and IP Address were not saved as expected. Problem 2: 1. Go to System i -> Network -> IP Policies -> Quality of Service -> Configuration 2. Open Properties for an outbound diffserv or intserv policy 3. On the 'Local IP Address' window, select "IP Addresss" and select any IP from the dropdown list 4. Click on the OK button to save the policy. 5. Reopen the properties and go to 'Local IP Address' and select 'All IP Addresses' 6. Save the policy by clicking the OK button 7. Reopen the properties and make sure the change was applied. Result: the IP Address is still set to a single IP Address. Problem 3: 1. Go to System i -> Network -> IP Policies -> Quality of Service -> Configuration 2. Open the IntServ wizard 3. On the Application panel, select Protocol TCP 4. On the Performance Limits panel, type a value into 'Maximum number of flows' Result: after the 'Local IP Address' panel, the wizard shows the 'Integrated Services Marking' instead of 'Integrated Services Type'. The value of 'Maximum number of flows' is not saved after the wizard is finished. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE37018: CA400EXP Schedule and clients not saved in Diffserv policy In the path: Network -> IP Policies -> Quality of Service -> Configuration, open the Properties for one of the policies. On the Schedule tab, create a new schedule. On the Client tab, create more than two clients. Save the changes by clicking on the OK button. Open the modified policy properties, and as a result, the clients and schedule were not saved as expected. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE37016: CA400EXP static routes are not created for new interfaces Go through: Network-> TCP/IP Configuration-> IPv4-> Interfaces-> New LAN Interface. After committing the wizard, the added static routes in the "Routing" panel are not created. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE37015: CA400EXP IPv6 stateless interface values are not saved In the path: Network-> TCP/IP Configuration-> IPv6-> Interfaces, right-click on "Properties" for a stateless interface. On the General tab, click on "Properties" and set the "Specify MTU size" and "Use duplicate address detection" settings. The MTU and Duplicate address detection values are not saved. Additional Keywords: OPNAV-NETWORK-INCORROUT APAR SE37014: CA400EXP New DHCP configuration wizard problems Select Network-> Servers-> TCP/IP-> DHCP-> Configuration. - Right Click on "General" and select "New Configuration". If the user chooses to migrate the Bootp server, the following message appears at the end of the wizard: "PCML document source 'com.ibm.as400.opnav.dhcp.Migratebootp' cannot be found". Also, the "Autostart" value of the wizard is not saved. - Right click on "Global" and select the "Properties" action. Under the "other" tab, the "bootstrap" field does not allow any IP addresses to be entered. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE37437: CA400EXP-OPNAV-DBASE-MSGSQL0338 DISPLAYING INDEXES LIST WITH R610 CHANGES MADE REQUIRING MORE CONSISTANT JOIN DEFINITIONS A MSGSQL0338 ERROR MAY BE GENERATED WHEN USING ISERIES NAVIGATOR TO DISPLAY INDEXES FOR A SCHEMA. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE35769: CA400EXP-DTRANSFER IASP OF JOB DESCRIPTION IS NOT HONORED This APAR describes the behavior of the iSeries Access for Windows Data Transfer component when using auxiliary storage pools (IASPs). In the V5R3M0 version of iSeries Access, Data Transfer always used the IASP specified in the job description of the user profile. Starting in the V5R4M0 version of iSeries Access for Windows, the IASP in the job description was no longer used; instead, Data Transfer read the IASP setting from the Connection tab of the Data Transfer Properties dialog. If not changed by the user, the IASP defaulted to *SYSBAS. As a result of this change in behavior, the IASP in the user's job description was never used. To remedy this situation and allow the user better control over how the IASP for Data Transfer is specified, the IASP setting for each system can now be set using a new [IASP] cwbtfr.ini option, for example: [IASP] myiSeriesIASP1=IASP1 myiSeriesIASP2=IASP2 ... etc ... The two systems, myiSeriesIASP1 and myiSeriesIASP2 are defined in iSeries Navigator. If the IASP setting is specified in the cwbtfr.ini file, the value is used to initialize the IASP value in the Connection tab of the Data Transfer Properties dialog. The value in the dialog can then be changed if desired. If the IASP setting in the .ini file and in the Properties dialog is not changed from the default value of *SYSBAS, then the user's job description is used. 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. 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. DATA TRANSFER EXCEL ADD-IN -------------------------- 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 SE35508: CA400EXP-ODBC-INCORROUT ACCESS VIOLATION IN CWBODBC.DLL A Windows application is using the System i 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. 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 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. 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 SE37287 : CA400EXP-OLEDB Data Mapping Error on INSERT using SQL Server A MSGCPF5029 - "Data mapping error on member &4" occurs when executing SQL INSERT or UPDATE statement(s) using the 4-part naming convention (LINKED SERVER.RDB.SCHEMA.TABLE) in SQL Server through the System i Access IBMDA400 and IBMDASQL OLE DB providers. .NET DATA PROVIDER ------------------ APAR SE35276: CA400EXP-IDB2DATA INDEXOUTOFRANGEEXCEPTION READING NULL CHAR 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 READING CLOB DATA 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. APAR SE37122 : CA400EXP-IDB2DATA EventWaitHandle UnauthorizedAccessException EventWaitHandle constructor throws UnauthorizedAccessException in the System i Access for .NET Managed Provider intermittently. For example: UnauthorizedAccessException: Access to the path is denied. System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) 2057035 System.Threading.EventWaitHandle..ctor(Boolean initialState, EventResetMode mode, String name) +2840139 IBM.Data.DB2.iSeries.iDB2NamedEvent..ctor(String eventName) +127 IBM.Data.DB2.iSeries.iDB2Trace..cctor() +89 - TypeInitializationException: The type initializer for 'IBM.Data.DB2.iSeries.iDB2Trace' threw an exception.! IBM.Data.DB2.iSeries.iDB2Trace.get_Tracing() +12 IBM.Data.DB2.iSeries.iDB2Factory..cctor() +69 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 5761JC1 SI32768. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.9 Level 20090409 APAR SE37023: CA400EXP-TERMEMUL-INCORROUT CWBLM0111 KERBEROS LARGE TICKET When kerberos Enterprise Identity Management (EIM) / Single Sign On (SSO) is used with a large ticket size the message CWBLM0111 may be produced. This can happen if the user is a member of many groups. APAR SE35063: CA400EXP-TERMEMUL-INCORROUT PC5250 FAILS TO LAUNCH BROWSER When using Windows Server 2003 with iSeries Access for Windows service pack SI29771 installed, attempting to launch the PC5250 web browser from the URL/Hotspots fails. APAR SE35095: CA400EXP-TERMEMUL OPENING >15 PC5250 SESSIONS CRASHES PCSWS Opening more than 15 sessions causes the pc5250/PCSWS.exe to crash. Windows Reports an Access Violation and closes sessions. APAR SE35326: CA400EXP-TERMEMUL CWBEM0005 WHEN CONFIGURING COMMUNICATIONS When configuring the Communication settings for PC5250, selecting both "Use Computer Name" and "Avoid duplicate names with other workstations" results in CWBEM0005. APAR SE35381: CA400EXP-TERMEMUL Incorrect cursor position or behavior The cursor appears to move when a user on a different PC performs actions on their 5250 session and/or the cursor doesn't behave as it should. APAR SE35805: CA400EXP-TERMEMUL TRIM RECTANGLE REAPPEARS AFTER AID KEY USE Following upgrade to SI32504, the trim rectangle used for the copy function in System i Access for Windows reappears following the use of any aid key. 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. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. --------------------------------- Service Pack Level = SI32504 Build date = October 2008 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE35312: CA400EXP-INSTALL-INCORROUT WELCOME WIZARD ENABLED AFTER UPGRADE If the Welcome wizard is configured not to be shown at computer startup and the customer upgrades to System i Access for Windows V6R1M0 from a previous release or installs a V6R1M0 service pack, the installation resets the "Show Welcome wizard at computer startup" option to its default value of enabled, causing the Welcome wizard to be displayed at PC startup. RESOLUTION: This PTF will fix the setup program in order that the current Welcome wizard configuration is preserved during a release upgrade or a service pack installation. If you installed a previous V6R1M0 service pack and this resulted in the Welcome wizard being re-enabled, you can disable it manually as explained in the Circumvention section of this APAR. CIRCUMVENTION: The customer can disable the "Show Welcome Wizard at computer startup" option manually by following these steps: 1. Go to Start menu > All Programs > System i Access for Windows 2. Open System i Access for Windows Properties 3. Select the "Other" tab and uncheck "Show Welcome Wizard at computer startup" APAR SE35316: CA400EXP-INSTALL Secondary language install support for plug-ins Add the Installation support for secondary languages for System i Navigator plug-ins RESOLUTION: Secondary language installation support for System i Navigator plug-ins was added APAR SE35313: CA400EXP-INSTALL-UNPRED ADMIN INSTALL CAUSES CWBSY1040 ON WINDOWS 64BIT OS When System i Access for Windows V6R1 is installed using an administrative image, users on Windows 64-bit operating systems get a CWBSY1040 error when logging in with the "Use Windows User Name and Password, no prompting" option. APAR SE33754: CA400EXP-INSTALL-INCORROUT CAN'T INSTALL SYSTEM I ACCESS USING GROUP POLICY Cwbinstall.msi into a GPO fails with Add operation failed. Unable to extract deployment information from the package. Run validation on the package to ensure that the package is correct. RESOLUTION: This code change fixes the reported problem CIRCUMVENTION: To circumvent the problem and be able to add the cwbinstall.msi file to the GPO file, follow these instructions: 1. Edit the cwbinstall.msi file you are trying to add to Active Directory with Microsoft Orca. If you need information on how to install Microsoft Orca consult the Info Center (http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/top ic/rzaij/rzaijtlsavailcrtxfms.htm?tocNode=int_233307) 2. Go to the LaunchCondition table and remove the row containing ACTION<>"ADVERTISE". APAR SE34183: CA400EXP-INSTALL-INCORROUT MACHINE.CONFIG PERMISSIONS ARE MODIFIED DURING INSTALL OF THE .NET DATA PROVIDER When user installs the .NET Data Provider feature of System i Access for Windows V6R1M0, the .NET Framework configuration file machine.config is edited, but the install program modifies the existing file permissions, thus some permissions might be deleted from machine.config. Machine.config is a global configuration file used by .NET applications. This can cause problems to applications that use machine.config and require it to have an specific permission that might had been lost after installing the .NET Data Provider. RESOLUTION: The System i Access for Windows install program will preserve machine.config's current file permissions while editing it. Note that any modifications done by the installer to machine.config's permissions previous to installing this PTF will not be reversed. In order to recreate any permissions that were deleted previous to installing this PTF please follow the procedure detailed in the circumvention section of this APAR. CIRCUMVENTION: Users can add any missing permissions to machine.config manually as explained next. Note: This procedure requires that the Simple File Sharing feature of Windows XP is disabled. In order to do so, follow these steps: 1. Open Windows Explorer. The Windows Explorer can be found under Start menu > All Programs > Accessories. 2. From the menu, select Tools > Folder Options. 3. Open the View tab. 4. In the Advanced Settings panel identify the following option: 'Use simple file sharing (Recommended)' and uncheck it. When you are done adding all required permissions to machine.config, you can check the simple file sharing option back. Once Simple File Sharing is disabled, follow these steps: 1. Open Windows Explorer. 2. Open the folder containing machine.config (by default is C:\WINDOWS\Microsoft.NET\Framework\\CONFIG). 3. Right-click machine.config and select Properties. 4. Open the Security tab. 5. Click the Add button (on Windows Vista, click Edit then Add). 6. Enter the user account name for which you need to reset a permission and click OK. 7. Back in the Security tab, adjust any permissions as needed for the user you just added. Repeat steps 5 through 7 for each user you need to reset a permission for. 8. When you are done, click OK to dismiss the Properties panel (on Windows Vista, you might get a warning about changing permission settings on system folders, click Yes to accept the changes and click OK again to close the Properties panel). Note: If you are uncertain about what permissions to set, you can look at the permissions of the file named machine.config.comments, which is located in the same folder as machine.config. Such file is a copy of machine.config and it generally has the same access rights with which machine.config was originally created. In order to query the permissions of machine.config.comments, right-click on it and open the Security tab. APAR SE34652: CA400XW1-UNPRED PROGRAMMER'S TOOLKIT HELP FILES PRODUCE AN ERROR FOR JAPANESE LANGUAGE. When choosing the Database Help Topics in Programmer's Toolkit on a Japanese language PC, the user receives a message indicating that the Help Files need to be updated. The Help Files are displayed behind the message box. APAR SE34884: CA400EXP-SERVICE-INCORROUT CWBSVGET GETS A FAULT WITH CWBINFEAT When a customer executes cwbsvget from a Windows Command Prompt a "Runtime Error" may be displayed on cwbinfeat.exe program RESOLUTION: The cwbinfeat.exe program was fixed to not produce the runtime error. CIRCUMVENTION: Delete the cwbinfeat.txt file from the %temp% directory and run cwbsvget.exe again. APAR SE35160: CA400EXP-INSTALL-UNPRED SP SI31390 CAUSES CWBSY1040 ON WINDOWS 64BIT OS. Following the application of Service Pack SI31390 to the V6R1 client using the installer available at the System i Access for Windows Service Packs page, users on both Windows XP 64-bit and Vista 64-bit OS report CWBSY1040 when logging in with the "Use Windows User Name and Password, no prompting" option. The error also happens when the Service Pack SI31251 download is applied. 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. APAR SE33999: CA400EXP-DTRANSFER-INCORROUT PACKED TO CHARACTER CONVERSION A problem was discovered with the System i 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. 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 "System i 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. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. System i NAVIGATOR ----------------- APAR SE35281: CA400EXP QoS Inbound admission policy wizard hangs Go through Network -> IP Policies -> Quality of Service -> Right click and select 'Configuration' action. Go to QoS -> Inbound Admission Policy -> right click and select 'New Policy' from action menu. Click 'Next' button until reach 'Applications' page, select 'Specific port, range of ports or server type' radio button and click on 'New' button. Result: If the list of specific application does not have at least an element when 'New' button is clicked the GUI hangs. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE35287: CA400EXP New RIP server is not available from GUI When RIP's SI31381 PTF is installed as superseded, the new RIP server are not available from the GUI. 1) Go through Network -> Servers -> TCP/IP -> OMPROUTED -> Right click - Result: RIP options are not displayed in the action menu. ADDITIONAL KEYWORDS: -OPNAV-NETWORK-INCORROUT RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: In order to get this functionality enabled from the GUI without this fix, the next points are required: 1. RIP's PTF SI31381 must be temporarily applied in the system before installing the latest PTF which supersede it. At this point, RIP functions are enabled in the GUI, but do not contain the final version, so if the user wants it continue with the next point. 2. Load and Applied the latest PTF on the system. APAR SE35288: CA400EXP RIP GUI accepts unsupported filter types 1. Go through Network -> Servers -> TCP/IP -> OMPROUTED -> Right click -> RIP -> Properties -> Interface Tab -> Click Add button -> Filters Tab. A blackhole filter (*) can be added in the interface even if an invalid filter type is selected. The only valid filter's types are 'Do not send over' and 'Do not receive messages'. ADDITIONAL KEYWORDS: -OPNAV-NETWORK-INCORROUT APAR SE35310: CA400EXP New DHCPv4 interface is not available from GUI When DHCPv4 SI30797 PTF is superseded, new DHCPv4 interface is not available in the GUI. 1) Go through Network -> TCP/IP Configuration -> IPv4 -> Interfaces -> Right click and select "New Interface" -> "Local Area Network". - Result: DHCPv4 options are not displayed through the wizard configuration. ADDITIONAL KEYWORDS: -OPNAV-NETWORK-INCORROUT RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: In order to get this functionality enabled from the GUI the next points are required: 1. DHCPv4's PTF SI30797 must be temporarily applied in the system before installing the latest PTF which supersede it. At this point, DHCPv4 functions are enabled in the GUI, but do not contain the final version, so if the user wants it continue with the next point. 2. Load and Applied the latest PTF on the system. APAR SE35289: CA400EXP error adding RIP IPv4 blackhole filter Go through Network -> Servers -> TCP/IP -> OMPROUTED -> RIP -> Properties -> Filters Tab -> Click on 'Add' button from IPv4 filters list. An error message is displayed when the user try to add a new IPv4 filter with a blackhole 'Destination router' identifier (i.e. *IPv4). ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE35311: CA400EXP Wrong field validations for SNTP and RExec 1. Go through Network -> Servers -> TCP/IP -> SNTP -> Right click -> Properties -> Client tab : click in 'Add' button and then cancel the dialog box, an empty item to server list is added. Also 'Poll interval' field shows a lot of blanks. 2. Go through Network -> Servers -> TCP/IP -> Remote Execution -> Right click -> Properties : the validation of range fails for 'Initial number of servers to start', 'Inactivity timeout' and 'ASCII coded character set identifier' fields. 3. Property sheet icons for TCP/IP servers are not set. ADDITIONAL KEYWORDS: -OPNAV-NETWORK-INCORROUT APAR SE35290: CA400EXP- DHCP Relay server properties is not displayed Using The System i Navigator: Network->Servers->TCP/IP->Bootp DHCP Relay Agent->Properties The DHCP Relay configuration is not launched when errors exist in the \QIBM\UserData\OS400\DHCP\dhcprd.conf file. This is working fine on web enviroments. Additional Keywords: OPNAV-NETWORK-INCORROUT APAR SE35291: CA400EXP- Host Domain values are not saved from the GUI In the path: Network->TCP/IP Configuration-> Properties-> Host Domain Information. Click on the "Advanced" button. "Retries" and "Domain name server selection" fields are not saved correctly. Additional Keywords: OPNAV-NETWORK-INCORROUT APAR SE35292: CA400EXP Inactive router timeout value is not saved Go through Network -> Servers -> TCP/IP -> OMPROUTED -> OSPF -> Properties. Go to 'Virtual Links' tab, click on 'Add' or 'Edit' buttons. Go to 'Advanced' tab, then change the 'Inactive router timeout(2-65535)' value and click in 'OK' button. Result: The new value is not saved. Additional Keywords: OPNAV-NETWORK-INCORROUT RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Use green screen ADDOSPFLNK/CHGOSPFLNK CL command instead. In green screen use either ADDOSPFLNK to add or CHGOSPFLNK to edit a virtual link and set the Inactive router timeout (INACTTIMO) parameter value. APAR SE35293: CA400EXP Unable to remove OSPF IPv6 areas Having an OSPF area already configured in the IP version 6 routing protocol on the system: 1.- Go through Network -> Servers -> TCP/IP 2.- In the server's list right click on OMPROUTED server and select 'Properties' action. 3.- When OMPROUTED property sheet panel is displayed go to 'Areas' tab. 4.- Select the area from the IPv6 list and click 'Remove' button. 5.- Click 'Ok' button. Result: An error message is displayed: "OSPF Area identifier has not been removed from configuration file. Fails with reason code 9". The reason code 9 is: "9. The area identifier must exist in the configuration file in order to be removed." Additional Keywords: -OPNAV-NETWORK-INCORROUT APAR SE35294: CA400EXP OSPF backbone area is not allowed from GUI Go through Network -> Servers -> TCPIP -> OMPROUTED -> OSPF "Properties". Add the backbone area and commit the property sheet. Reopen OSPF's properties, go to 'Areas' tab. The problems are: 1. The backbone area is not shown in the area list 2. Backbone radio button is not enabled in either Interface property sheet or Ranges dialog. 3. The backbone area should not be allowed to use as link transmission area of a virtual link. Additional Keywords: OPNAV-NETWORK-INCORROUT APAR SE35295: CA400EXP Wrong buttons behavior in subsystems page - Go through Network -> Servers -> System i Access. Right click on any server and select 'Properties' from the list. - Click on 'Subsystems' tab, when no client is selected in 'Specific client' list and click on 'Edit' or 'Remove' button no action is performed. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE35296: CA400EXP-OPNAV-INCORROUT MGTC Delete Tasks function fails Being connected to Management Central throw System i Navigator, the "Delete Tasks..." function fails after pressing the Delete button, causing System i Navigator closes with CWBUNAV.EXE error. APAR SE35297: CA400EXP RouteD configuration problems Go through: Network -> Servers -> TCP/IP -> Right click on RouteD -> Properties -> Routing Networks tab - Problem 1: click on 'New' button, select 'Network' type at 'General' tab, fill out the IP and subnet fields and click 'OK'. Reopening the added routing peer, the 'Subnet mask' value is not shown as expected. - Problem 2: click on 'New' button, in 'Forwarding Parameters' tab enter several address of different types and click 'OK'. Reopening the added routing peer and remove some addresses. Click 'OK' to save. Reopen the same routing peer, a strange behavior is presented with the addresses. - Problem 3: click on 'New' button, in 'General' tab when a valid host name is entered seems like the validation is wrong, if you put a hostname value without dot(s) reopening is considered as PPP profile. - Problem 4: select an existing routing network, click on 'Open' button, modify any field and save it. Click 'OK' on RouteD properties. Reopen RouteD properties,the modified routing network is shown twice. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE35304: CA400EXP DNS Statistics interval reported as error When connecting v6r1 GUI with v5r4 system. The statistics-interval statement is marked as an error, this option is valid for v5r4 configuration. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE35305: CA400EXP DNS v6r1 connected to v5r4 created rndc-key When creating a new instance with GUI v6r1, connected to a v5r4 system, the gui creates an rndc-key, which it's been used on bind9 v6r1 systems. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE35306: CA400EXP problem adding dual stack servers When you add an ip address in the dual stack server list and don't set a general port, then save the configuration, the configuration is not saved propertly, it add the keyword port without a port number, this sintax problem stop the server for been started. Have to fix it by hand. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE35307: CA400EXP error adding servers in manage RNDC option When adding a saver in the manage RNDC option, adding the key, and clicking OK button to commit changes, an error message is displayed about the server key is missing, which is already entered, so you can't add servers to the list. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE35309: CA400EXP error adding RIP IPv6 blackhole filter Go through Network -> Servers -> TCP/IP -> OMPROUTED -> RIP -> Properties -> Filters Tab -> Click on 'Add' button from IPv6 filters list. An error message is displayed when the user try to add a new IPv6 filter with a blackhole 'Destination router' identifier (i.e. *IPv6). ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32681: CA400EXP SMTP GUI not displayed with 5.4 systems Network->Servers->TCP/IP->SMTP When using the 6.1 version of System i Navigator 6.1 it does not display the SMTP properties on lower system versions. Additional Keywords: OPNAV-NETWORK-INCORROUT APAR SE34055: CA400EXP- DHCP Subnet Properties fails loading subnet ranges Go to Network->Servers->TCP/IP Servers->DHCP->Properties when editing the properties of a subnet that was previously configured as Subnet Range. If the properties are loaded again. After clicking the "OK" button, the subnet is saved as a subnet address instead of an address range. Additional Keywords: OPNAV-NETWORK-INCORROUT APAR SE34077: CA400EXP- Error message displayed on DHCP subnet wizard Go to Network->Servers->TCP/IP Servers->DHCP->Properties. When creating a subnet from "New Subnet (Advanced)" with an specific subnet address, the next error message is displayed: Specify a valid address within the address range for this subnet. Additional Keywords: OPNAV-NETWORK-INCORROUT APAR SE34308: CA400EXP- problem changing properties of a HEA interface Using iNav V6R1 to configure VIPA, the TCP/IP interface based on HEA physical interface is considered like a VIPA. Network->TCP/IP Configuration->IPv4->Interfaces Select an existing HEA interface, right click and select "Properties" action. In the "Advanced" tab, the "Associated local" interface allows only *NONE, and the Proxy ARP option is available. Additional Keywords: OPNAV-NETWORK-INCORROUT APAR SE34631: CA400EXP Adding same OSPF area in either IP protocols fails Go to Network -> TCP/IP Servers -> OMPROUTED -> OSPF "Properties" action -> Areas tab. The user is not allowed to add the same OSPF area for either IPv4 or IPv6 protocols. ADDITIONAL KEYWORDS: -OPNAV-NETWORK-INCORROUT RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: The user can use the Green Screen instead. When the user add the same area for both IP protocols from green screen, strange GUI behaviors may appear. APAR SE35159: CA400EXP wrong autostart value on telnet, FTP and SMTP GUIs Network->Servers->TCP/IP Telnet, FTP and SMTP servers properties show wrong status for autostart checkbox. Additional Keywords: OPNAV-NETWORK-INCORROUT APAR SE34375: CA400EXP-OPNAV MGTC IPv6 Support Implementation Management Central IPv6 Support implementation. Further details can be found at APAR SE33664. RESOLUTION: Enhancements have been added to Management Central to enable IPv6 connectivity support. IBM i and System i Navigator will continue working in the same way for Management Central with IPv4 at 6.1 release and previous. *************************************************************** * The visible changes for this enhancements at the System i * * Navigator are: * *************************************************************** 1) Endpoint Systems, Properties panel has been modified to handle IPv6 addresses. 2) Endpoint Systems, Explore and Open panels have been modified to handle IPv6 addresses. 3) Endpoint Systems, Discovery Systems panel has been enhanced to discover systems into an IPv6 link-local subnet, specifying IPv6 subnet and the prefix length. You can select from 2 options: - Use IPv4 address format - Use IPv6 address format *************************************************************** * COMMUNICATIONS * *************************************************************** ------------------- | Considerations: | ------------------- A. There are two options to handle IPv6 connection between System i Navigator and IBM i: 1) Using IPv6 address, or 2) Configuring the DNS to return the IPv6 address for the system when the hostname is used. B. Options to add an IPv6 Central System/Endpoint: 1) Specifying its IPv6 address. This one has to be exactly typed as in the interface configured on the server, without any other interpretation or abbreviation. 2) Specifying its hostname that resolves the IPv6 address (this is a DNS server task configuration). C. In order to establish an IPv6 ONLY environment connection between Central System and Endpoints, the following configuration needs to be set up: 1) PC with IPv6 activated and System i Navigator with Service Pack 3. 2) Central System with IPv6 configured (check B. consideration options above to add an IPv6 Central System/Endpoint). 3) QYPS_HOSTNAME property configured with IPv6 on the Central System server. 4) Endpoint with IPv6 configured (check B. consideration options above to add an IPv6 Central System/Endpoint). 5) QYPS_HOSTNAME property configured with IPv6 on the Endpoint System server. D. At 6.1 release, in order to have the correct IPv6 Endpoint address information on any Exported inventory, the QYPS_HOSTNAME property needs to be set up with the IPv6 address on the Endpoint server. Otherwise all exported inventory files will show the IPv4 Endpoint System address. --------------------------------- | Restrictions and Limitations: | --------------------------------- A. Even though it is possible to add an IPv4 mapped address or an invalid IPv6 address as an Endpoint System, Management Central will NOT be able to establish a successful connection with it. B. IPv6 Central System will be able to handle the communications with IPv4 and IPv6 Endpoints configurations (this will be limited by the server configuration and specifications), but IPv4 Central System can ONLY communicate with Endpoints using IPv4 version. C.- The connections to System i Navigator and IBM i server through Management Central using IPv6 address format will ONLY be possible if the Service Pack 3 is installed on *Windows and Management Central IPv6 SI31888, SI31892, SI32720 and SI32721 PTFs are applied at IBM i 6.1 server. * Windows is a registered trademark. D. To use IPv6 on System i Navigator (PC) and/or IBM i, it should be configured in the TCP/IP network. This means that if an IPv6 connection is tried to be establish between the System i Navigator (PC) and IBM i without have it configured previously the connection will FAIL. E. For Management Central to establish successful connections (with IPv4 or IPv6) it is VERY important to have the hostname properly configured in the DNS according with the IP version to be used, because an error or inconsistency in these tables may cause connections failures. F. For the Central System to connect back to the PC; the PC client MUST use the same IP version used at IBM i. Even if you handle both IP versions (DUAL IP), you have to specify one PC IP address (IPv4 or IPv6 only) at C:\MgmtCtrl.properties file as the value of "QYPS_HOSTNAME" property. G. Having any of the following scenarios, the connection between Central System and Endpoints will FAIL between 6.1 releases: *************************************************************** |Central System |QYPS_HOSTNAME | Endpoint |QYPS_HOSTNAME| | (Name) | | (Name) | | *************************************************************** | IPv4 address | IPv4 | IPv6 address | IPv6 | *-------------------------------------------------------------* | IPv4 address | IPv4 | Hostname | IPv6 | | | | (IPv4 on DNS) | | *-------------------------------------------------------------* | Hostname | IPv4 | IPv4 address | IPv6 | | (IPv4 on DNS) | | | | *-------------------------------------------------------------* | Hostname | IPv4 | Hostname | IPv6 | | (IPv4 on DNS) | | (IPv4 on DNS) | | *-------------------------------------------------------------* | IPv4 address | IPv6 | IPv4 address | IPv4 | *-------------------------------------------------------------* | IPv4 address | IPv6 | Hostname | IPv4 | | | | (IPv4 on DNS) | | *-------------------------------------------------------------* | Hostname | IPv6 | IPv4 address | IPv4 | | (IPv4 on DNS) | | | | *-------------------------------------------------------------* | Hostname | IPv6 | Hostname | IPv4 | | (IPv4 on DNS) | | (IPv4 on DNS) | | *************************************************************** *************************************************************** * DISCOVERY FUNCTION * *************************************************************** ------------------- | Considerations: | ------------------- A. Only the discover of one IP version (IPv4 or IPv6) will be available at one time. B. For IPv4 version, only IPv4 discovery is enable (this means that systems at releases previous to 6.1 will only have IPv4 discovery enabled). For IPv6 both are enabled, but will search on one TCP/IP version at a time. C. If Central System is being used with Dual IP, it will be possible to select any (IPv4 or IPv6), one at a time. This depends on the Central System IP configuration NOT on the PC (System i Navigator) IP configuration. D. When IPv6 is selected, the "Earliest operating system release to search for" field will be set to V6R1M0 and user will not be able to change its value. E. When working with System i Navigator at releases previous to 6.1 Discovery function will probably show IPv6 subnets, and Endpoints list will probably show IPv6 addresses, but this will not mean that a connection, or a discovery search on any interaction with IPv6 addresses are going to take place. If using System i Navigator previous to 6.1 and the Discovery function shows IPv6 subnet/prefix pairs; they MUST removed prior to submitting the Discovery; otherwise, the Discovery will not run successfully. 1) If Central System host list entry does not have a hostname with an associated IPv6 address, the IPv6 address will be listed on the Endpoint panel list. F. On the Discovery panel, user is responsible to add VALID IPv6 subnet address. G. Discovery function will only look for those hosts in the same link-local subnet where the Central System is running at. If site-local search want to be performed extra configuration beyond Management Central is need it. H. There will be 2 types of results after Discovery function is executed looking for hosts within IPv6 subnets: 1) If Central System host list entry does not have a hostname with a associated IPv6 address, the IPv6 address will be listed on the Endpoint panel list. 2) If Central System host list entry has (for any reason) an IPv6 address associated with a hostname, the hostname will be listed on the Endpoint panel list. I. The Management Central Discovery function uses an specific non-permanently assigned multicast address (FF15::666) to find IPv6 hosts on the network. The scope of the multicast address FF15::666 is site-local. J. The Management Central Discovery function uses an specific IPv6 port number that is 6661. --------------------------------- | Restrictions and Limitations: | --------------------------------- A.Even though we use a site-local multicast address, Discovery function for IPv6 will work as a link-local ONLY. Multicast site-local functionality for IPv6 Discovery depends directly on routers configurations and their multicast capacity; thus, Discovery does not guarantee, under any circumstances that it will work at a site scope. For site search; verify all the routers configuration, multicast support and ask your network administrator. For further information on each router contact the router manufacturer's support. As stated before, Management Central will not guarantee a success search at site scope. *************************************************************** * SEND AND SYSTEM VALUES FUNCTIONS * *************************************************************** ------------------- | Considerations: | ------------------- A. At 6.1 release Send (Users, Users Groups Fixes, Fix Groups) and System Values functions such as "Compare & Update" and "Synchronize Date and Time" will FAIL using the following configurations: *************************************************************** | Central System | Endpoint System | *************************************************************** | Hostname (IPv6 on DNS) | IPv4 address | *-------------------------------------------------------------* | Hostname (IPv6 on DNS) | Hostname (IPv4 on DNS) | *************************************************************** THERE is a CIRCUMVENTION, at 6.1 release when using Send and System Values functions, adding into the Endpoint "Host List Table entries" the Central System hostname with its IPv6 address, the tasks will be SUCCESS. --------------------------------- | Restrictions and Limitations: | --------------------------------- A Send (Users, User Groups, Fixes, Fix Groups) and System Values functions, such as "Compare & Update" and "Synchronize Date and Time" will FAIL using the following configurations between 6.1 --> 5.4 releases: *************************************************************** | Central System | Release | Endpoint System | Release| *************************************************************** | Hostname | 6.1 | IPv4 address | 5.4 | | (IPv6 on DNS) | | | | *-------------------------------------------------------------* | Hostname | 6.1 | Hostname | 5.4 | | (IPv6 on DNS) | | (IPv4 on DNS) | | *************************************************************** Tasks will FAIL because 5.4 release doesn't support the addition of an IPv6 address on their "Host List Table entries", this way the Central System that is calling tasks is never recognized at the Send and System Values functions. *************************************************************** * MONITORS AND SYSTEM VALUES FUNCTIONS * *************************************************************** ------------------ | Considerations | ------------------ A. To work with File, Job, Messages Monitors and System Values functions the QYPS_HOSTNAME property SHOULD BE configured with the corresponding PC IPv4 or IPv6 address on the C:\MgmtCtrl.properties file (according with the IP version used for connection between System i Navigator and IBM i server). *************************************************************** * SYSTEM i ACCESS FOR WIRELESS (PERVASIVE) FUNCTION * *************************************************************** ------------------- | Considerations: | ------------------- A. System i Access for Wireless will work with IPv6 address on an URL using the following format: http://[IPv6_address]:9004/McYpvPervasive However, it will continue working as usual when using a hostname. *************************************************************** * WINDOWS * *************************************************************** --------------------------------- | Restrictions and Limitations: | --------------------------------- A. IPv6 is supported for *Windows XP (32 and 64 bits), *Windows Vista (32 and 64 bits), and *Windows Server 2008. It is NOT supported on Windows 2000 or earlier. * Windows is a registered trademark. B. System i Navigator does NOT support the connection from two instances on the same PC at a time, no matter which IP version (IPv4 or IPv6) is being used. APAR SE34913: CA400EXP-OPNAV-INCORROUT- IPv6 Discovery Panel Issues There are 2 problems reported: The First one is about the TIMEOUT value on the Discovery window, which doubles it size each time a Discovery function is performed. The second one is about SNMP and FTP check boxes value, which are incorrectly setted when IPv6 radio button is selected on the Discovery Window. APAR SE35385: 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 System i 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 System i 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 SE35282: CA400EXP AVERAGE OF QUERY ESTIMATES COLUMN DISPLAYS 0.0000 Using the Index Advisor window, the "Average of Query Estimates" column may display 0.0000. This can happen when the value is greater than 0 but less than 0.0001. ADDITIONAL KEYWORDS: OPNAV-DBASE-INCORROUT RESOLUTION: Any value that comes back from system that is less than 0.0001 will be rounded up to 0.0001. APAR SE35283: CA400EXP-OPNAV-DBASE-MSGSQL0104 SORTING LIST OF TRANSACTIONS When trying to display the statistic data dialog for a table with a name longer than 128 characters, it may result in a Data truncation error. ADDITIONAL KEYWORDS: DBASE APAR SE35284: CA400EXP-OPNAV OBJECT NOT FOUND IN A PROCEDURE/FUNCTION When trying to do the "Explain SQL" or "Permissions" actions for a procedure or function, an error may occur and the target dialog may not be displayed. This can happen if the procedure/function was created with the PROGRAM TYPE SUB parameter. A MSGCPFA0A9 or "Unable to explain SQL for this object because the associated program in schema cannot be found." are the most common error messages. APAR SE35285: CA400EXP-OPNAV-DBASE-MSGSQL0104 SORTING LIST OF TRANSACTIONS When displaying the list of transactions, trying to sort this list by a specific column may fail with a MSGSQL0104. The columns that have this problem are: 1. In the Database Transactions folder a) User b) Local Pending Changes 2. In the Global Transactions folder a) Local Pending Changes 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 SE35299: CA400EXP-OPNAV-DBASE DATABASE PREFERENCES SAVED INCORRECTLY Using the Preferences dialog in Databases the changes to the preferences are not saved correctly when working with General and DB2 On Demand Performance Center categories. The problem only occurs for systems with IASPs as follows: 1) Bring up the Preferences dialog. 2) Select any database other than the last one listed and click the Change Schema button. Enter a value and click OK. Click OK on the Preferences dialog. 3) Open the Preferences dialog again. You will see that your schema setting was not saved. 4) Try steps 1 to 3 again, this time entering a schema name for the last database listed. This time, on step 3 you will see your schema value for every database in the list. APAR SE35300: CA400EXP-OPNAV TABLE NAME SUPPORT LONGER THAN 128 CHARACTERS When displaying the definition of a table, the table name will be truncated if the name is longer than 128 characters. For example: CREATE TABLE "Table with a name which is 130 characters in length including quotes Table with a name which is 130 characters in length incl..." ... This problem will cause an error when trying to change information for the table. ADDITIONAL KEYWORD: DBASE-INCORROUT APAR SE35301: CA400EXP IGNORE SQL0204 WHEN ALTER STATEMENT INCLUDES DROP The Run SQL Scripts (RSS) window has the capability to ignore the "Object not found" error (MSGSQL0204, SQL State 42704) when executing a DROP statement. This is applicable when the "Ignore "Object not found"" menu option is selected in the Options pull down menu. However when executing a SQL statement that has a merged DROP clause, such as ALTER TABLE DROP CONSTRAINT... , and if it fails with an MSGSQL0204 error, the script execution is stopped even if the option is selected. ADDITIONAL KEYWORDS: OPNAV-DBASE-MSGSQL0204 APAR SE35302: CA400EXP-OPNAV-DBASE PARTITION FILTER ERROR IN STATISTICS When working in the Statistics Data window for a partitioned table, an error may occur when a partition is selected from the Partition filter field. The error displays "An unknown error has occurred" message and the list becomes empty after pressing the OK button. 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 SE34965: CA400EXP UNABLE TO PERFORM ACTION WITH *JOBCTL AUTHORITY Using System i Navigator, there are some actions in the Databases folder that the connected user must have *JOBCTL authority to perform that action. The problem occurs if the user profile does not have that specific authority, but their profile belongs to a group profile that has the necessary authority, the user is not allowed to perform that action. A message box is displayed instead. The user should be allowed to perform that action if the group profile has the necessary authority. Some of the actions that do this checking include: Creating/starting an SQL Performance Monitor, ending an SQL Performance Monitor, Showing the statements from the SQL Plan Cache, Change Query Attributes, and creating a SQL Plan Cache Snapshot. ADDITIONAL KEYWORDS: OPNAV-DBASE APAR SE35286: CA400EXP-OPNAV ADD PRINTER WIZARD PORT NUMBER WRONG 1. Open System i Navigator. 2. Expand a system. 3. Expand Basic Operations. 4. Right click on printers and select 'Add Printer'. 5. Wizard will start. 6. Click next on the Welcome screen. 7. On the 'Location printer' screen enter a valid DNS name and select the box 'Printer is connected to a print server' at the bottom . 8. Click Next . 9. Select at the left pane the manufacter 'Hewlett-Packard' or 'D-Link' . 10. Select at the right pane the model for 'Hewlett-Packard' HP Jetdirect 170x or the 300x, if you selected D-Link any of the models will do. 11. Click Next. 12. The 'Choose physical port' screen appears, just click Next leaving the default '1' -> message pops up "'1' is outside the range 1 through 0". By the way the arrow up and down doesn't work at all. APAR SE33505: CA400EXP-OPNAV UNABLE TO LAUNCH SYSTEM I NAVIGATOR When you tried to run System i Navigator, it looks like nothing happens. The problem can occur from either an upgrade from previous release of Access for Windows or a new installation of v6r1m0 System i Access for Windows. The problem can occur with base code and/or latest service pack (at the time this document was written) SI31251 applied. When double clicking or clicking icon(s) to launch the interface, nothing happens. There is no visible error message or window. APAR SE34372: CA400EXP-OPNAV-PRINTERS ADD PRINTER WIZARD PORT NUMBER INCORRECT 1. Open System i Navigator. 2. Expand a system. 3. Expand Basic Operations. 4. Right click on printers and select 'Add Printer'. 5. Wizard will start. 6. Click next on the Welcome screen. 7. On the 'Location printer' screen enter a valid DNS name and select the box 'Printer is connected to a print server' at the bottom . 8. Click Next . 9. Select at the left pane the manufacter 'Hewlett-Packard' or 'D-Link' . 10. Select at the right pane the model for 'Hewlett-Packard' HP Jetdirect 170x or the 300x, if you selected D-Link any of the models will do. 11. Click Next. 12. The 'Choose physical port' screen appears, just click Next leaving the default '1' -> message pops up "'1' is outside the range 1 through 0". By the way the arrow up and down doesn't work at all. APAR SE34466: CA400EXP-OPNAV CWBUNNAV.EXE FAILS WITH SECUR32.DLL FAULTING There are three different scenarios for the same problem: 1. When System i 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 System i Access and Windows Vista Enterprise Edition with SP1. 2. Start System i 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 System i 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. 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 SE34941: CA400EXP-DTRANSFER-INCORROUT CWBDB0014 WHEN BROWSING MEMBER When clicking on the Data Transfer "Browse" button (files and members), expanding a library, and clicking on the plus (+) in front of a file that is not externally described, the following error messages are shown: CWBDB0014 - Internal software error (System %1) PWS00D2 - Function completed successfully, but no data returned. Cause.....: The function completed successfully, but no objects matched the criteria specified. Recovery...: Determine if request is specified correctly, correct the problem, and run the function again. Clicking OK on the message allows you to select the file, but the file member is never shown. The transfer can then be completed without error. This problem occurs with the Data Transfer GUI when doing both uploads and downloads. 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 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 a System i 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. This occurs with V6R1 SP1(SI31251) and V6R1 SP2 (SI31390). 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 a System i 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 SE35315: CA400EXP-IDB2DATA-MSGSYSTEM.ACCESSVIOLATIONEXCEPTION WITH IDB2DATAREADER AND DISPOSED COMMAND The application generates an iDB2DataReader object using an iDB2Command object. The iDB2Command object is disposed, and the application then tries to use the iDB2DataReader, and receives a System.AccessViolationException. APAR SE33957: CA400EXP-IDB2DATA-INCORROUT STACKOVERFLOWEXCEPTION READING IDB2TRANSACTION.CONNECTION PROPERTY A StackOverflowException occurs when reading the Connection property of an iDB2Transaction object. 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 System i. The .Net provider will be updated to flow the CloseCursor. APAR SE34166: CA400EXP-IDB2DATA-THREADS-INCORROUT FAULT WITH DISTRIBUTED TRANSACTIONS An application is using the System i Access for Windows .NET managed provider to insert a large number of rows of data in distributed transactions, inserting one row per connection. An unhandled IBM.Data.DB2.iSeries.iDB2DCFunctionErrorException is thrown at a point that seems to coincide with the maximum number of uses for a connection in the connection pool. 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 5761JC1 SI32768. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.9 Level 20080919 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. 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. 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 ------------------ APAR SE34459: CA400EXP-OPCON-INCORROUT LAN RCP FUNCTION 21 FAILS For certain PC locales such as Japanese or other Double-Byte Character Sets (DBCS) when using the Operations Console LAN connection Control Panel function 21 to force DST, the panel returns 21 FF indicating a failure. RESOLUTION: With this change Operations Console LAN Control Panel correctly sends function 21 to force the console to DST, regardless of PC locale. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. --------------------------------- Service Pack Level = SI31390 Build date = July 2008 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE33915 : CA400EXP-INSTALL NO SECONDARY LANGUAGE SUPPORT IN V6R1 In previous releases, System i Access for Windows included support for installing secondary languages. Secondary languages allow users to configure System i Access for Windows to display System i Access features in different languages. In V6R1, GA code of System i Access for Windows does not have secondary language support. RESOLUTION This PTF adds secondary language support for V6R1M0 System i Access for Windows. You can install secondary languages from a System i platform that has both System i Access for Windows (5761-XE1) and the desired secondary language installed, or from the System i Access for Windows V6R1M0 DVD, as long as the client computers have the latest service level installed. (Please consult the section 1.3 - INSTALLING A SECONDARY LANGUAGE of this readme file for further information on how to install secondary languages) APAR SE33680 : CA400EXP-INSTALL-INCORROUT CUSTOM AND PC5250 INSTALL TYPES BEHAVE WRONG When user selects a Custom setup in the installation wizard, the expected behavior is that only the typical features are selected in the selection tree; however, all features appear selected instead. This problem does not occur if user specifies one or more feature names in the ADDLOCAL property; in that case, selecting Custom will mark only the specified features to be installed, which is the right behavior. Also, if user selects a PC5250 User setup, the following error message is displayed when the Next button is pressed, and the installation is interrupted immediately after: "Error 2711. The specified Feature name ("") not found on Feature table." RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: You can specify a Custom setup by setting the CWBINSTALLTYPE public property to 'Custom' from the command line, as follows: setup /v"CWBINSTALLTYPE=Custom" This will force the setup wizard to select only the typical features. In order to start an installation that is equivalent to the PC5250 User setup type, pass in 5250 Emulator's feature key name through ADDLOCAL in the command line, as shown below: setup /v"ADDLOCAL=emu" Then, choose Custom on the Setup Type dialog. Only Required Programs and 5250 Emulator will be selected, which are the features that get installed with a PC5250 User setup. Alternatively, run setup and choose Custom, then uncheck all features except for Required Programs and 5250 Emulator. APAR SE32538 : CA400EXP-INSTALL-UNPRED INSTALLATION OF ADDITIONAL FEATURES FROM DVD FAILS WITH PROMPT FOR DVD. When attempting to install additional features using the Modify option of System i Access for Windows and using the original installation DVD, the user is continually prompted for Disk 1 even though the disk is already loaded in the PC. If the user originally installed System i Access for Windows from an installation image located on the local hard disk or on a network directory and later attempts to add features using the DVD, the installation might fail with error 1706 "No valid source could be found for product IBM System i Access for Windows V6R1M0". The problem can also occur if the user originally installed System i Access for Windows from an installation image located on the local hard disk or on a network directory and attempts to upgrade the application to a newer service level using a custom CD or DVD that was burnt from an updated installation image. RESOLUTION: This PTF fixes the reported problem. Note: You must burn a new DVD from an updated image that contains the fix in order to avoid this problem. Refer to the following article to get instructions on how to burn a DVD (notice that due to space restrictions the address had to be divided in two lines; please enter the address as a single line without spaces in your web browser): http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/ topic/rzaij/rzaijcdrom.htm?tocNode=int_48830 CIRCUMVENTION: Copy the image to the hard disk or to a network drive and launch setup.exe from there. Depending on your PC's processor type, copy the entire contents of the folder Windows\Image32 for a 32-bit based PC, Windows\Image64a for an AMD 64-bit (x64) based PC or Windows\Image64i for an Itanium (IA64) based PC, including the MRI29xx subfolder, where xx is the number that identifies the (29xx) language code that is currently installed on your PC, to an empty directory in the hard drive or to an available network directory. Run setup.exe from the local disk or network location. This will start the installer in maintenance mode and you will be able to add features. APAR SE33006 : CA400EXP-SERVICE-INCORROUT CWBSVGET DOESN'T WORK ON VISTA Cwbsvget.exe doesn't work on vista and Windows Server 2008 operating systems. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. System i 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 SE33563 : CA400EXP-INCORROUT-DISK IASP Jobs is not available in web Independent ASP Jobs option is not available on System Director Navigator tasks on the web and IBM Systems Director Navigator for i5/OS. RESOLUTION: The Independent ASP Jobs option will be available for both System I Navigator web environments. 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 are 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 SE33565 : CA400EXP-OPNAV CORRUPTED PATH DIRECTORIES IN SECURED OBJECTS Additional keywords: OUTPUT-INCORROUT. The path name directories in "Secured Objects" sub-panel from the "Permissions" panel of an authorization list are shown corrupted. APAR SE33107 : CA400EXP-OPNAV IASP QSYS displays the contents of QSYS Open System i Navigator->My Connections->System->File Systems->Integrated File System->Root. When '//QSYS.LIB' folder is expanded, the contents listed are from '/QSYS.LIB' instead of the contents from the IASP QSYS. Where '' is the name of the Independent Auxiliary Storage Pool (IASP). APAR SE33569 : CA400EXP-OPNAV-INCORROUT Wrong host for Integrated Server In the Integrated Server Administration function of System i Navigator, if the user works with more then one i5/OS system at a time, then sometimes actions are performed on the wrong system. RESOLUTION: The correct system is now used for actions on objects. APAR SE33570 : CA400EXP-OPNAV INCOMPATIBLE AUTHORITY USING /QSYS.LIB Additional keywords:-FILESYS Attempting to display Permissions on /QSYS.LIB, the message: "com.ibm.as400.access.QSYSPermission incompatible with com.ibm.as400.access.RootPermission" is displayed and the Permissions panel is not shown. APAR SE33571 : CA400EXP-OPNAV Exclude from Parity Set option unavailable On System i Navigator Disk Management GUI and with System i fully started, menu option "Exclude from Parity Set..." is unavailable on non configured excludable parity protected disk units if at least one disk unit on the same parity set is part of a Basic ASP. Recreation: The System i must be fully started. Must have a parity set with the following characteristics: - At least one non configured excludable disk unit. - At least one configured disk unit in a Basic ASP. 1. Run System i Navigator. 2. Expand your Environment (Usually "My Connections"). 3. Expand your System. 4. Provide your user id and password and press OK button. 5. Expand Configuration and Service item. 6. Expand Hardware item. 7. Expand Disk Units item. 9. Provide Service Tools ID and password and press OK button. 8. Expand Parity Sets item. 9. Select your Parity Set. 10. Right click on the excludable non configured disk unit to call its context menu. Result: The "Exclude from Parity Set..." menu option will not be available. Additional keywords: INCORROUT RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: The System i must be in DST mode. Steps: 1. Run System i Navigator. 2. Select "Open System i Navigator service tools window" from Environment tasks located at the bottom right panel. 3. Provide the Service Tools IP address then click OK button. 4. Provide Service Tools ID and password and press OK button. 5. Expand your System. 6. Expand Disk Units item. 7. Expand Parity Sets item. 8. Select your Parity Set. 9. Right click on the excludable non configured disk unit to call its context menu. 10. Select "Exclude from Parity Set..." option. APAR SE33572 : CA400EXP-OPNAV-DBASE-INCORROUT GIANT ICON IN VISUAL EXPLAIN Visual Explain shows oversized icons. This may happen when using the Graph Detail -> Full option. If you run a complex query and select the "Expand to Window" context menu option on a Table Probe and then select the "Collapse" context menu option to reset to the original icon size. This may cause the original icon to be sized to oversized dimensions. APAR SE33573 : CA400EXP-OPNAV Work with copy description resources fails The resources associated to a copy description are not listed in the panel of properties of the copy description in the Disk Management graphical user interface. Furthermore, adding a resource to a copy description fails with message CPD0043, indicating that the keyword RSRCNAME is not valid. ADDITIONAL KEYWORDS: OTHER-MSGCPD0043 APAR SE33574 : CA400EXP-OPNAV-DBASE PREFERRED FOLDER WHEN OPENING A SCRIPT In the Run SQL Scripts (RSS) window, the first time the user uses the Open menu option to open a file, the open dialog places the user at the My Documents folder instead of user's last accessed sub-folder. APAR SE33575 : CA400EXP-OPNAV-DBASE-INCORROUT COMMENTS IN AN SQL PACKAGE When trying to edit comments for an SQL Package you may get an error dialog stating "nameContainer invalid for sql ordinary identifier". This is possible by selecting the "Comments..." option from the SQL Package's context menu. The exception is shown and no Comments dialog displays. APAR SE33576 : CA400EXP-OPNAV-DBASE USER PREFERENCES NOT HONORED IN MAPS When adding objects to a map, the user preferences are not taken into account. At the moment an object is added to the map, objects related to the object may be added to the map based on the options specified on the user preferences dialog. If a user tries to add an object or a set of objects, the 'Finding relations' dialog shows the status with the value of 'Omitted' for those objects the user does not want to be added to the map. However, the first time this occurs, the value for those object types to be omitted starts counting up and thus are added to the map. The problem is the preferences from the User Preferences dialog are being ignored. APAR SE33577 : CA400EXP-OPNAV-DBASE-INCORROUT CURSOR IN RSS IS LOST After running a script in the Run SQL Scripts window, the cursor may be lost and the user cannot work with the script text anymore. When the script being run executes successfully, the application highlights the next query in the script and the cursor should remain in the script area. The problem is when using the toolbar buttons to run the script, this highlights the next query but the cursor is not in the script area, so the user needs to click on the text to work with the script. RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Use the short-cut keys to run the scripts instead of using the toolbar buttons. 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 SE33579 : CA400EXP-OPNAV-DBASE INVALID ERROR WITH CORRECT SHORT NAME When creating a new index, the validation of the SQL name and short name of the index may not be correct. In the case that the SQL name is greater than 10 characters, it is not suitable to be used as the short name so the user can specify a name up to 10 characters in short name field. However, if the user does specify a name, the dialog incorrectly displays a warning message that the "Short name cannot be specified when the SQL name provided is also a valid short name." 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 SE33582 : CA400EXP-OPNAV Collect Attributes invalid file prefix error Typing an invalid file prefix in 'Collect Attributes' panel sends the error 'Expression not allowed for parameter INFFILEPFX' and an entry is created in the table of 'Display Collected Attributes' panel. RESOLUTION: The fix prevents the application from creating the entry inside the table of 'Display Collected Attributes' panel when an invalid file prefix has been typed in 'Collect Attributes' panel. 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 SE33584 : CA400EXP-OPNAV TRIPLE DES AND RC4 ALGORITHMS NOT RECOGNIZED Addional keywords: -OTHER-INCORROUT Using Cryptographic Services Key Management to create a new key record, the algorithms Triple DES and RC4-Compatible are not recognized, at the last panel of the New Key record wizard an error message is displayed about those algorithms are not valid, this happens if a not English Language is configured in the client. APAR SE33585 : CA400EXP ISW does not commit wizard configuration 1. Go to Network -> Internet -> right click and select Internet Setup Wizard option. 2. Select "To a protected network" radio button at the Panel where the type of connection is selected. 3. Follow instructions until you get the summary panel, then click on Finish button to commit configuration. Result: The Summary panel is refreshed and configuration is not saved from web console and no error or warning message is displayed. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT 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 System i Navigator and System i 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 SE33587 : CA400EXP-OPNAV Reattach Metro Mirror session hangs If a Metro Mirror session is reattached using the Disk Management graphical user interface (GUI), and PTF SI31364 (or any superseding PTF) of product 5761HAS is installed on the system, the GUI hangs until the CPF9898 inquiry message sent to the system operator message queue (QSYSOPR) asking to confirm the reattach operation is answered. ADDITIONAL KEYWORDS: OTHER-WAIT RESOLUTION: The Disk Management GUI code is changed to show to the user the text of the CPF9898 inquiry message (English only) sent to the system operator message queue. The user can either continue with the reattach operation by pressing the Continue button, or cancel the operation by pressing the Cancel button. CIRCUMVENTION: From a 5250 session, use the command DSPMSG QSYSOPR to see the system operator messages, look for the CPF9898 message asking to confirm the reattach operation and answer the message. After the message is answered, the Disk Management GUI will continue working. APAR SE33588 : CA400EXP-OPNAV-FILESYS Object properties on IASP not shown Limited information is displayed inside the properties of the following objects that reside in an independent auxiliary storage pool (IASP): - Database Schema. - SQL packages. - AFP resources, PSF configuration objects, and font mapping tables. - library inside a job's library list. Even when the user profile has enough authorities. APAR SE33589 : CA400EXP Create Modem with parameters command empty Go to Network -> RAS -> Modems Right click on Modems and select New Modem Enter a valid name in General panel then click on Additional paramters tab Click on Add button, enter a Parameter name then click on OK button leaving empty the command field. Result: The parameter is added to modem list After Modem is created, open modem properties and edit Aditional parameters tab, by changing parameters order then click on OK button to save changes, open properties again and order was not saved successfuly. And if you move any parameter to the bottom of the list the parameter is duplicated after save changes. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE33590 : CA400EXP-INCORROUT-GUI DOES NOT SUPPORT MULTIDEVD The GUI does not allow me to specify what devd the CPYD can use. We cannot guarantee that the device description name is the same at the resource name. RESOLUTION: The support to handle multiple device descriptions for an IASP has been added. The user will be able to select the device description to work with in Cross Site Mirroring tasks. CIRCUMVENTION: The user can run the command on green screen selecting the device description desired. APAR SE33591 : CA400EXP profile not created if remote authentication is set SLIP Switched profile not created if requires remote system authentication. Go to Network -> Remote Access Services -> Receiver Connection Profiles Right click on RCP and select New Profile option. In Authentication panel, check "Require this system to verify the identity of the remote system" checkbox, select any validation list then complete configuration and press OK button to commit wizard. Result: The message "Select an authentication protocol to allow" message is displayed and profile is not created. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE33592 : CA400EXP Local system identification not saved for RCP Go to Network -> RAS -> Receiver Connection Profile Right click on any L2TP - PPP profile and select Properties option Click on Authentication tab and check "Allow the remote system to verify the identity of this system" checkbox then check "Require unencrypted password" radio button, enter any username an password value then click on OK button to save changes Right click on edited profile and select Properties options to make sure changes were saved. "Require unencrypted authentication protocol" radio button is not cheked. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE33593 : CA400EXP SMTP schedule attribute dismatch in AT&T summary Go to Network -> RAS -> Originator Connection Profile Right click on Originator Connection Profile and select New ATT Global Network dial connection option Follow instructions until you get to SMTP Shcedule page, Activate the schedule and enter a valid time value different than 30 (i.e. enter 1000). Continue with the wizard instructions until you get to Summary panel and verify the value of SMTP Shcedule time. Result: The summary displays the default value (30 minute) in SMTP Schedule attribute. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE33594 : CA400EXP named.conf is not updated with the generated key Generated a RNDC key from function manage RNDC within DNS configuration. The rndc.conf file and the key files are created correctly. The named.conf is not updated with the include for this key. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE33595 : CA400EXP save master copy of data does not create the files Go to Network -> Severs -> DNS, select an instance and select configuration. When you go to the new Secondary or Stub zone wizard, there is an option in the Master Server panel, when you check that option its supposed to create a file for that zone, so transfers from the master server will be performed and a copy will be available localy. This file is not created, its like if you choose not to save the master data copy. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE33596 : CA400EXP-OPNAV-DBASE UNABLE TO EXPLAIN CREATE OF MQT TABLE When using Run SQL Scripts and trying to use the "Explain" or "Run & Explain" actions on a CREATE TABLE statement for a Materialzed Query Table (MQT), the Visual Explain picture may not be displayed. Instead a message box may be displayed stating "Cannot display the query diagram because the query access plan information was not collected for the query". The following is an example of a CREATE TABLE statement for an MQT: CREATE TABLE MQTTABLE AS( SELECT * FROM MY_TABLE) DATA INITIALLY IMMEDIATE REFRESH DEFERRED ENABLE QUERY OPTIMIZATION MAINTAINED BY USER APAR SE33566 : CA400EXP-OPNAV Enable Global mirror functions for GUI Global Mirror functions are not enabled. RESOLUTION: This PTF will enable the Global Mirror functions for the Disk Management GUI. APAR SE33567 : CA400EXP IPv6 Enhancements for TCP/IP applications The new functionality included is: RIPng Network->Servers->TCP/IP->OMPROUTED->RIP Provides the Routing Information Protocol next generation(RIPng) and Routing Information Protocol version 2 (RIPv2).This is a routing protocol that exchanges routing information used to compute routes and is intended for Internet Protocol version 6 (IPv6)-based networks. Besides, this provides the support for the old RIP protocol as well that this was being configuring by ROUTED server. DHCP Network->TCP/IP Configuration->IPv4->Interfaces IPv4 Dynamic Host Configuration Protocol (DHCP) client for the System i will provide customers with a capability to automatically acquire a dynamic IPv4 address on a per line description for their system using the System i Navigator. This will be accomplished by configuring a IPv4 DHCP interface for a line description. To enable the help follow the instructions in the following link: ftp://ftp.software.ibm.com/as400/products/clientaccess/win32/v6r 1m0/files/iNav/se33567 ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT RESOLUTION: This PTF includes the changes to support the new functionality, as long as the following i5/OS PTFs are also installed: - SI31381 and its prerequisites (SI31858, SI31859, SI31860, SI31861, SI31863, SI31865, SI31866, SI31867, SI31868, SI31869, SI31889) for RIPng - SI30797, SI30957, SI30958, SI30959, SI30960, SI30961, SI30962,SI30963 for DHCP APAR SE29734 : CA400EXP-OPNAV-INCORROUT USER NETWORKS OPTION FAILS When going into the properties of a user profile using System i 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 SE30855 : CA400EXP Help is not available on Rules Editor. The customer is using R540 iSeries Accesss for Windows and in iSeries Navigator he brings up the Rules Editor then tries to display the general help without success, there isn't help available. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT 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 System i 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 System i 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 System i Navigator - Application Administration component. 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 System i host, and the System i Navigator Advisor is used to check the network items of the host, the System i Navigator Advisor - Performance window may stop at 0%. At this point the Status of the Performance window is Analyzing network: Response Time. 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 SE33354 : CA400EXP-OPNAV-INCORROUT UPDATE FIX-GROUPS TASK FAIL Appears when doing a comparision for fix groups only, where is expected to have first the compare task and then do the update with selected items. Ensure that the Target Systems do not report ANY missing fixes, but do report missing fix groups. 1. Hit the Update option button. 2. Press next button until summary page. 3. Press Finish button 4. After hitting Finish button GUI will crash and stop responding. RESOLUTION: Code has been changed to handle "Fix Groups Only" updating task. 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 SE33244 : CA400EXP-OPNAV-INCORROUT CENTRAL SYSTEM CHANGE PROBLEM Attempting to change the System i Navigator Central System may result in the application not responding. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- 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 System i 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 to specify a customized default date format but it selects the date format based on the PC's Windows regional setting. 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 the Format Settings panel and change the date format manually every time a new transfer request is created. 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 : 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 System i Access for Windows Data Transfer to System i GUI are addressed in this APAR, all of them related to the "MS XML Excel spreadsheet" file type: 1) The XML scanner in the System i Access for Windows Create System i 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 System i Access for Windows Create System i 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 System i 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. APAR SE33422 : CA400EXP-DTRANSFER-INCORROUT FIELD NAMES ARE ALPHEBETIZED Using Data Transfer from System i, when clicking 'Data Options' and then 'Details' buttons, the field names are alphabetized instead of being displayed in the order they occur in the physical file as it used to be in other releases. APAR SE32981 : CA400EXP-DTRANSFER-MSGCWBDB0052 RETRIEVING A LIST OF LIBRARIES AND FILES FAILED ON JAPANESE SYSTEM I ACCESS When a user clicks the "Browse" button on "Data Transfer From System i" of Japanese System i Access in order to retrieve a list of libraries and files, it fails with CWBDB0052. CWB0111 is also issued in the History Log. This happens after install of SI30128. The same problem happens also on "Data Transfer To System i". DATA TRANSFER EXCEL ADD-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 setting. 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 the Format Settings panel and change the date format manually every time a new transfer request is created. 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 SE32981 : CA400EXP-DTRANSFER-MSGCWBDB0052 RETRIEVING A LIST OF LIBRARIES AND FILES FAILED ON JAPANESE SYSTEM I ACCESS When a user clicks the "Browse" button on "Data Transfer From System i" of Japanese System i Access in order to retrieve a list of libraries and files, it fails with CWBDB0052. CWB0111 is also issued in the History Log. This happens after install of SI30128. The same problem happens also on "Data Transfer To System i". 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 ---->"System i 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 System i 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 SE32817 : CA400EXP-ODBC-INCORROUT STORED PROCEDURE CALLS FAIL WITH {} Stored procedure calls that completed successfully when using iSeries Access for Windows V5R3 and V5R4 fail when using System i Access for Windows V6R1. TRCCNN or an ODBC trace shows that the call was made to the stored procedure. CWBCOTRC indicates that the ODBC driver is hung. The statement being sent through SQLExecDirect() is something like this: "{call SomeLib.SomeProcedure}". At this point, the pNode becomes invalid resulting in the hang. This will only occur when using the {} syntax. Adding parameters or even an empty parameter list will avoid the problem. Failing Example: {call SomeLib.SomeProcedure} Working Example: {call SomeLib.SomeProcedure()} APAR SE33393 : CA400EXP-ODBC-INCORROUT GARBAGE DATA APPENDED TO DATA RETURNED FOR RESULT SET. Unicode configured PHP script run under Microsoft Windows using the System i Access for Windows ODBC driver returns DB2 data from the System i but the displayed output appears to have appended garbage data to the result set. The System i 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 SE32880 : CA400EXP-OLEDB-INCORROUT QUERY OPTIONS LIBRARY NOT SET FROM SQL SERVER The System i Access for Windows OLE DB provider is not setting the query options library (the library whose QAQQINI file will be used) is not being set correctly 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 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 ---->"System i Access for Windows OLE DB Technical Reference - SQL"----> Help Topics---->Contents tab---->System i OLEDB provider functions----> Special Properties. .NET DATA PROVIDER ------------------ APAR SE33568 : CA400EXP-IDB2DATA GetDataSources() strings contain garbage characters When using the iDB2DataSourceEnumerator's GetDataSources() method, the strings returned from this method contain an undisplayable character at the end. 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 System i 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 -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 6.2 (2008-04-30) and the equivalent of PTF 5761JC1 SI31554. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.9 Level 20080430 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 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 : 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 : CA400EXP-TERMEMUL-MSGPCSERR100 PC5250 ABENDS WITH PCSERR100 ERROR PC5250 abends with PCSERR100 error when used in conjunction with screen scraping software. SECURE SOCKETS LAYER (SSL) -------------------------- No fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE33431 : CA400EXP-OPCON-INCORROUT IP address as config name fails Attempting to connect with an operations console LAN connection that has an IP address as the name fails shortly after the DST sign on. The error is "Communication error attempting to validate DST User ID and Password. Do you want to try again?" RESOLUTION: With this fix dotted decimal IP addresses can be used as configuration names. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. --------------------------------- Service Pack Level = SI31251 Build date = March 2008 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE32355 : CA400EXP-INSTALL-INCORROUT CHECK VERSION IGNORES CMDLINE PARMS SPECIFIED IN SETUP.INI APAR SE32356 : CA400EXP-INSTALL-INCORROUT CWBLAUNCH.EXE IGNORES CMDLINE PARMS SPECIFIED IN SETUP.INI APAR SE30681 : CA400EXP-NLS-INCORROUT CONVERSION FROM CCSID 5035 TO 932 APAR SE32877 : CA400EXP-OPNAV-OTHER-UNPRED NO SYSTEM I NAVIGATOR PLUGINS WERE DETECTED IN YOUR SOURCE DIRECTORY OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- APAR SE30805 : CA400EXP-INRMTCMD-INCORROUT EXECUTING GRAPHICAL APPLICATIONS System i NAVIGATOR ----------------- APAR SE31184 : CA400EXP-OPNAV-INCORROUT CLUSTER GUI SUPPORT FOR i5OS V6R1 APAR SE31263 : CA400EXP-OPNAV-INCORROUT Error message when creating a user APAR SE31191 : CA400EXP-OPNAV-DBASE DISTINCT VALUES CREATING ADVISED INDEX APAR SE32302 : CA400EXP-OPNAV-FILESYS Corrupt characters in column headers APAR SE31816 : CA400EXP-OPNAV-INCORROUT No Message QUEUE/LIBRARY on Monitor APAR SE32303 : CA400EXP UCW does not force selection of country APAR SE32304 : CA400EXP Wait for Dial tone checkbox shows inconsistency APAR SE32305 : CA400EXP Packet Rules is not shown under IPv6 interfaces APAR SE32306 : CA400EXP OPNAV CRASHES USING DRAG AND DROP IN NEW VIEW DIALOG APAR SE32307 : CA400EXP Error displaying VPN responer connection APAR SE32331 : CA400EXP Rules Editor hangs displayed from Group Access APAR SE32332 : CA400EXP VPN default settings causes an exception APAR SE32333 : CA400EXP Can not change IKE local key identifier in VPN APAR SE32073 : CA400EXP-OPNAV SCRIPT NOT SAVED WITH CLOSE GROUP ACTION APAR SE32334 : CA400EXP-OPNAV-FILESYS Various NLS problems APAR SE32335 : CA400EXP ISP connection does not save internal resource APAR SE32308 : CA400EXP Language network GUI problems APAR SE32309 : CA400EXP-OPNAV-DBASE UNABLE TO EXPLAIN AN OBJECT IN AN IASP APAR SE32310 : CA400EXP-OPNAV-DBASE-INCORROUT CURSOR IN RSS IS LOST APAR SE32311 : CA400EXP-OPNAV JDBC SETUP USE LIBRARY LIST FOR SERVER JOB APAR SE32312 : CA400EXP-OPNAV-DBASE CONTEXT MENU OPTION MISSING IN ADVISOR APAR SE32313 : CA400EXP-OPNAV CHANGE FORMAT DATE AND RSA KEY TRANSLATED APAR SE32314 : CA400EXP-OPNAV-DBASE OPERATORS AND FUNCTIONS IN EXPRESSIONS APAR SE32315 : CA400EXP-OPNAV-DBASE CANNOT IMPORT SQL PLAN CACHE DATA FILE APAR SE32316 : CA400EXP L2TP Remote Dial profile tries to dial *NONE APAR SE32317 : CA400EXP Physical line is not created for PPPoE APAR SE32318 : CA400EXP Incorrect profile Script ASCII value APAR SE32319 : CA400EXP incorrect modem retrieved by Profile APAR SE32320 : CA400EXP Optional Modem parameters are not saved in PPP APAR SE32321 : CA400EXP-OPNAV-DBASE FORMAT NUMBER IN HEALTH CENTER APAR SE32322 : CA400EXP-OPNAV-DBASE SQL ASSIST IS NOT CONNECTED APAR SE32323 : CA400EXP-OPNAV-DBASE -MSGSQL0104 CONTROL STATEMENT SEMICOLON APAR SE32324 : CA400EXP-OPNAV-DBASE UNABLE TO LOAD STRING IN REORGANIZE APAR SE32337 : CA400EXP SLIP Leased terminator profiles hangs on save APAR SE32338 : CA400EXP ICMP version 6 not support in filter rules APAR SE32339 : CA400EXP Able to enter invalid group name in L2TP APAR SE32340 : CA400EXP Can not change Remote Key Server in VPN connections APAR SE32341 : CA400EXP FRAGMENT should not be included on permitnonVPNv6 APAR SE32342 : CA400EXP DNS TTLs units are set in English only APAR SE32353 : CA400EXP problems in Multiple Domains and Bindings panels APAR SE32354 : CA400EXP L2TP profile does not save line validation list APAR SE32357 : CA400EXP-OPNAV-DBASE AVERAGE OF QUERY ESTIMATES IN ADVISOR APAR SE32358 : CA400EXP Internal modem 576C missing APAR SE32399 : CA400EXP-OPNAV OBSOLETE TASK DISPLAYED AFTER UPGRADE 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 WORKING AS DESIGNED APAR SE30770 : CA400EXP-OPNAV CONFIGURATION AND SERVICE FAILS WITH CPF3CF1 APAR SE30848 : CA400EXP-OPNAV- ERROR CREATING NEW USER WITH JAPANESE CLIENT APAR SE31060 : CA400EXP-OPNAV-DBASE-MSGCWB0111 UPDATING A CHARACTER COLUMN APAR SE31061 : CA400EXP-OPNAV-DBASE-INCORROUT UPDATE NOT SAVED INTO SERVER APAR SE31229 : CA400EXP IPv4 interface properties is not diplayed APAR SE32025 : CA400EXP-OPNAV ADVANCED JOB SCHEDULER CONTAINER IS EMPTY APAR SE32448 : CA400EXP-OPNAV-INCORROUT QLMTDEVSSN inaccurately described APAR SE31085 : CA400EXP-OPNAV-INCORROUT when display strings in norwegian APAR SE32051 : CA400EXP-OPNAV MGTC Fix Task mix Fixes and Fix Groups DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE31895 : CA400EXP-DTRANSFER FILE TYPE CHANGED AFTER MSGCWBTF0002 DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE31662 : CA400EXP-DTRANSFER ADD-IN FAILS WITH TIME FORMATTED CELLS ODBC ---- 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 APAR SE31868 : CA400EXP-OLEDB-INCORROUT ADSCHEMACOLUMNS FOR OPENSCHEMA METHOD RETURNS NO RESULTS .NET DATA PROVIDER ------------------ APAR SE32325 : CA400EXP-IDB2DATA iDB2Permission fails in 64-bit LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- APAR SE32359 : CA400EXP-AFPVIEWER OpNav View spooled file fails on Vista APAR SE31194 : CA400EXP-AFPVIEWER-INCORROUT DISPLAY FAILS TOOLBOX FOR JAVA ---------------- Includes JTOpen 6.1 (2008-01-15) and the equivalent of PTF 5761JC1 SI29813. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.9 Level 20080208 APAR SE32336 : CA400EXP-TERMEMUL-INCORROUT CORRUPTED PRINTER DIALOG STRINGS APAR SE30424 : CA400EXP-TERMEMUL-INCORROUT THE CURSOR DOES NOT APPEAR ON THE FIELD IF THAT IS APAR SE30508 : CA400EXP-TERMEMUL-UNPRED IN A KOREAN INSTALL ENVIRONMENT, SWITCHING BETWEEN APPLICATIONS APAR SE30613 : CA400EXP-TERMEMUL-INCORROUT CLOSING SESSION WITH FILE EXIT ALL CAUSES APPLICATION APAR SE31152 : CA400EXP-TERMEMUL-INCORROUT PC5250 DOES NOT SUPPORT GREEK ALPHABETIC CHARACTERS 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 ------------------------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. --------------------------------- Service Pack Level = SI29455 Build date = November 2007 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE30715 : CA400EXP-INSTALL-INCORROUT General Availability Updates. V6R1M0 GA fixes. Build 20071122. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. System i NAVIGATOR ----------------- No fixes. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- No fixes. DATA TRANSFER EXCEL ADD-IN -------------------------- ODBC ---- No fixes. OLE DB PROVIDER --------------- No fixes. .NET DATA PROVIDER ------------------ No fixes. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 6.1 (11/1/2007) and the equivalent of PTF 5761JC1 SI29061. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.9 Level 20071102 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. JAVA PROGRAMMER'S TOOLS ----------------------- 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 ------------------------------ You cannot remove a service pack that was installed by running setup.exe from an updated installation image. In order to revert a service pack that was installed in this fashion, you must first uninstall System i Access for Windows and re-install it using an image that is at an older service level, such as the image available on the System i Access for Windows DVD. The SI31251 service pack download available on the System i Access FTP site can be uninstalled individually; however, due to significant changes introduced to the installation support during service pack SI31390, individual service packs cannot longer be removed starting with SI31390. Please refer to the readme.txt file that accompanies each service pack for details on service pack uninstall support. ftp://ftp.software.ibm.com/as400/products/clientaccess/win32/v6r1m0/servicepack/ 4.2 UNABLE TO INSTALL FROM THE SERVICE SOURCE? ----------------------------------------------- If you experience problems while installing a service pack over slow communication lines, and if installing from a DVD or a faster connection is not possible, then the service pack could be installed in this manner: 1) A setting exists on the System i 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 System i 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 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 System i 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 System i National Language Support Manual.