============================================================================= Readme File for System i Access for Windows Service Packs 5761-XE1 V6R1M0 Cumulative Service Pack Level ------------- SI32504 ------------- (c) Copyright IBM Corporation 2008. 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 = SI32504 (October 2008) 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 = 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 in this PTR. 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 Check Version ignores any command line parameters specified in the CmdLine key of setup.ini if either the "Perform silent installation" or "Copy install image to PC" options are selected in the Service tab of the System i Access for Windows Properties panel. By default, setup.ini defines the msiexec parameters /l* "%temp%\xe1instlogmsi.txt" in CmdLine, which generates an install log under the temporal folder. In the situation described above, such parameters are ignored and thus an installation log will not be generated when Check Version performs a service pack or upgrade operation. If customer specified additional msiexec parameters in setup.ini, they will be ignored as well. APAR SE32356 : CA400EXP-INSTALL-INCORROUT CWBLAUNCH.EXE IGNORES CMDLINE PARMS SPECIFIED IN SETUP.INI Launching cwblaunch.exe with the /v option causes any command line parameters specified in the CmdLine key of setup.ini to be ignored. For example, launching the following command will cause setup.exe to ignore any command line parameters specified in setup.ini: cwblaunch /v"CWBINSTALLTYPE=PC5250User" By default, setup.ini defines the msiexec parameters /l* "%temp%\xe1instlogmsi.txt" in CmdLine, which generate an install log file under the temporal folder. In the situation described above, such parameters are ignored and thus an installation log will not be generated. If customer specified additional msiexec parameters in setup.ini, they are ignored as well. RESOLUTION: This PTF fixes the reported problem CIRCUMVENTION: Specify all msiexec parameters in the /v option of cwblaunch.exe, including any parameters specified in setup.ini. Alternatively, specify all msiexec parameters in the CmdLine key of setup.ini and avoid using /v. Note: passing in multiple msiexec parameters or parameters that contain spaces -like /l- through the /v option requires enclosing them in quotes, like in the following examples: cwblaunch.exe /v"/l*v mylog.txt" cwblaunch.exe /v"CWBINSTALLTYPE=PC5250User /qb" APAR SE30681 : CA400EXP-NLS-INCORROUT CONVERSION FROM CCSID 5035 TO 932 Incorrect mapping occurred when converting from CCSID 5035 to CCSID 932. RESOLUTION: The correct CCSID mapping has been restored. APAR SE32877 : CA400EXP-OPNAV-OTHER-UNPRED NO SYSTEM I NAVIGATOR PLUGINS WERE DETECTED IN YOUR SOURCE DIRECTORY When attempting to scan for New Plug-ins or initial startup of System i Navigator; one will be prompted to sign-on to i5/OS and will recieve: 'No System i Navigator plugins were detected in your source directory' Looking in the install logs on windows we see: error 'No plugins found' RESOLUTION: This PTF fixes the reported problem CIRCUMVENTION: The following command can be used to install the plug-ins on the PC from the System i. 1. Open a DOS Command prompt 2. Map a drive to \\system_name\QIBM typing the following command: net use x: \\system_name\QIBM 3. Run the following command CWBINPLG /CALLER=WI /INSTALL /SRCDIR=x:\ Where x: is the drive letter assigned to \\system_name\QIBM OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- APAR SE30805 : CA400EXP-INRMTCMD-INCORROUT EXECUTING GRAPHICAL APPLICATIONS Sometimes when using the Incoming Remote Commands function and interact with the desktop option is enabled, it fails with a "ghost window" that is, only the window frame is displayed. System i NAVIGATOR ----------------- APAR SE31184 : CA400EXP-OPNAV-INCORROUT CLUSTER GUI SUPPORT FOR i5OS V6R1 System i Navigator Cluster component incompatibility problems with V6R1 systems. APAR SE31263 : CA400EXP-OPNAV-INCORROUT Error message when creating a user Message: "An internal error has occurred and has been logged.Processing will continue" . is displayed after creating/adding a user profile with system i Navigator. APAR SE31191 : CA400EXP-OPNAV-DBASE DISTINCT VALUES CREATING ADVISED INDEX When trying to create an index from the index advisor dialog in Visual Explain, the New Index dialog may display '0' as the default value for the 'Number of distinct values' field. However, for those advised indexes whose type is binary radix, the dialog should display 'Not specified' as default value for the 'Number of distinct values' field. ADDITIONAL KEYWORDS: INCORROUT APAR SE32302 : CA400EXP-OPNAV-FILESYS Corrupt characters in column headers In System i Navigator, under My Connections, expand the System i server to work with, expand the Network node, expand Servers node, select TCP/IP. Right click on i5/OS NetServer and select 'Open i5/OS NetServer' from its context menu. Select 'Shared Objects' node inside i5/OS NetServer. The 'Share' and 'Share Type' column headers displayed in the i5/OS NetServer's right panel, contain corrupted characters when the System i Navigator installation is in Arabic. APAR SE31816 : CA400EXP-OPNAV-INCORROUT No Message QUEUE/LIBRARY on Monitor For Management Central Message Monitors, context menu actions associated to a message resulted in a "Message QUEUE/LIBRARY not specified" error. APAR SE32303 : CA400EXP UCW does not force selection of country The universal connection wizard does not force the user to select a country under "Location" panel, if the user finishes the wizard without selecting a country the wizard generates an error. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32304 : CA400EXP Wait for Dial tone checkbox shows inconsistency The profile created by Universal connection wizard when selecting a dial up connection shows a different "wait for dial tone" value than the configured on the wizard, there is inconsistency with the values. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32305 : CA400EXP Packet Rules is not shown under IPv6 interfaces From Network->TCPIP Configuration->IPv6->Interfaces-> on The context menu of any interface the action "Active Packet Rules" is not shown ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32306 : CA400EXP OPNAV CRASHES USING DRAG AND DROP IN NEW VIEW DIALOG Using the drag and drop capability in the New View dialog may cause System i Navigator to display a message box that says cwbunnav.exe needs to close. The drag and drop feature is enabled for selecting which columns to establish the join between tables and for selecting which tables will participate in the view definition. ADDITIONAL KEYWORDS: OPNAV-DBASE APAR SE32307 : CA400EXP Error displaying VPN responer connection When trying to display the properties of a Remote Connection Group properties a failure window message is shown from System i Navigator. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32331 : CA400EXP Rules Editor hangs displayed from Group Access From "Network->Remote Access Services-> Receiver Connection Profile->Group Access Policy->New Group Access Policy-> TCPIP settings tab" Click on "Edit Rules Profile". The System i Navigator hangs ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32332 : CA400EXP VPN default settings causes an exception When working with the VPN defaults, try to change the 'key expiration' 'expire at size limit' to 'no size limit' get a number format error from key Expiration tab under vpn. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32333 : CA400EXP Can not change IKE local key identifier in VPN At IKE Policy properties an error is displayed saying that the IP version 6 address is not valid when changing the 'Local Key Server' indentifier from either 'IP version 4' or 'IP version 6' to any other type. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32073 : CA400EXP-OPNAV SCRIPT NOT SAVED WITH CLOSE GROUP ACTION Using the 'Close group' action to close the windows of System i Navigator may result in not saving a script being modified in Run SQL Scripts window. If the closing action is requested and the user has modified a script in the Run SQL Scripts window, but not yet saved it, the System i Navigator closing process should be stopped to ask the user if they want to save the changes. Instead, the application closes and the changes to the script(s) are lost. ADDITIONAL KEYWORDS: DBASE RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Do not use the 'Close Group' option. Instead use the close action from the main window of the System i Navigator to close all windows. APAR SE32334 : CA400EXP-OPNAV-FILESYS Various NLS problems - 'Last used' date do not display a value when the System i Navigator installation is in Arabic. 'Last used' field is available in 'Use' tab page from file properties. - Daemons status table inside NFS server properties is too small when the System i Navigator installation is in Arabic. -The object type is always displayed in English when file properties for a QSYS.LIB object is accessed using IBM Systems Director Navigator for i5/OS. - RESOURCEMISSING message is displayed when an incorrect IP address is typed in 'Primary Wins Server' or 'Secondary Wins Server' from 'Wins configuration' tab page. It happens when NetServer Properties are invoked within i5/OS NetServer window. APAR SE32335 : CA400EXP ISP connection does not save internal resource From "Network -> Remote Access Serivices -> Originator connection profile -> New Intranet or ISP Dial connection", go through the wizard until reach Hardware Resource list then select an internal resource, continue to commit the configuration; Open the profile properties then the associated line, the resource is set as external. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32308 : CA400EXP Language network GUI problems Universal Connection Wizard does not display translated strings under "Country or region" field, also in Location panel the "Country or region" list is not in correct alphabetical order. When creating a new Primary Zone for DNS in the "Allow update" panel when you click on add button there is an extra field 'ACL-list element' on the Address Match List Element panel, there is also an extra button if you select the 'IP prefix' type. In web console select an active IPv4 interface and display its properties,go to the "Advanced" tab, in Chinese language Chinese characters on the far right of the panel are split in two lines. For an originator connection profile under "TCP/IP Settings" panel, click on "Advanced" button, the panel displayed has a truncated text in Arabic language. Also Right click on Receiver Connection Properties and left click on New Profile, the New Point to Point Profile Properties has a truncated text in Arabic language. Universal Connection Wizard VPN Gateway panel shows a truncated text in Arabic language. IPv4 Interface list does not display the "alias name" as available value in the "Columns" panel. Remote Access Services in the "Ethernet Link" tab shows truncated the standard value in Arabic language. Telnet server "General" shows truncated labels in Arabic language. Internet Setup Wizard Summary panel, the "DNS Address" header is not displayed on the correct language. VPN new connection wizard at Local Endpoint panel, in the Id type dropdown list, the string "Point to Point Profile" is truncated in Russian Language. 'Private Address' panel in 'Address Translation' wizard, the order of the components are wrong, first label is shown below of the IP address field in Chinese language. In web console the welcome page for "Internet Setup" wizard shows truncated labels. 'Internet Setup' wizard Virtual IP is not handling the single quote correctly. The apostrophe is not displayed. Under 'New IPv4 interface' wizard the summary page shows 'Subnetmask' caption truncated. Under "New line" wizard the "Welcome" page shows truncated text. Remote Access Services, is able to create a new physical line without name, this field should be required. DNS dump statistics and dump database display "page not found" in web console, after that the web console is unusable. DNS TTL strings units (seconds, minutes, hours, days) in several options panels are displayed in English language. In the DNS configuration panel the "new view" menu and the context menu for views are not translated correctly. DNS Option panel does not response when creating "listen on v4" and "liste on v6" interfaces multiple times in mixed order. Under Remote Access Services, the "delete" action does not display the delete object confirmation dialog. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32309 : CA400EXP-OPNAV-DBASE UNABLE TO EXPLAIN AN OBJECT IN AN IASP Trying to Explain SQL of an object results in an SQL Exception stating that the object cannot be found. This is possible through the SQL Details for Jobs dialog, using the Explain SQL context menu option if the object being explained resides in an Independent Auxiliary Storage Pool (IASP). APAR SE32310 : 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 has a syntax error, the application highlights the error and the cursor should remain in the script area. The problem is when using the toolbar buttons to run the script, this highlights the error but the cursor is not in the script area, so the user needs to click on the text to work with the script. RESOLUTION: Use the short-cut keys to run the scripts instead of using the toolbar buttons. APAR SE32311 : CA400EXP-OPNAV JDBC SETUP USE LIBRARY LIST FOR SERVER JOB In Run SQL Scripts window, if you try to change the JDBC Settings, the user may get an error if they change the SQL default schema field. Recreation: 1) Change the field from the default to another value 2) Change the field value back to 'Use library list of server job' option 3) Press the Connect button. The user will see the 'Use library list of server job is not a valid schema name' error message 4) This happens for temporary and permanent JDBC settings ADDITIONAL KEYWORDS: DBASE-INCORROUT APAR SE32312 : CA400EXP-OPNAV-DBASE CONTEXT MENU OPTION MISSING IN ADVISOR The sub-context menu options for the Table contex menu option for an advised index may be missing menu options. This problem may happen in Index Advisor and Condensed Index Advice windows with other language versions of System i Navigator other than English. ADDITIONAL KEYWORDS: INCORROUT APAR SE32313 : CA400EXP-OPNAV CHANGE FORMAT DATE AND RSA KEY TRANSLATED 1. The long date format used in the applications Intrusion Detection and Cryptographic Services with polish language is not allowed. 2. The algorithm types RSA (Public and private), Triple DES and RC4-compatible used in Cryptographic Services application were not translated. 3. The title of the error window is not correct, when display the permissions of an object. APAR SE32314 : CA400EXP-OPNAV-DBASE OPERATORS AND FUNCTIONS IN EXPRESSIONS The operators and functions lists in the expression builder are incorrect. There are some of them that are not supported but are listed. Only the supported operators and functions should be displayed depending on the context of use. The list was incorrect in the New Check Constraint dialog and in Add Expression and Condition Builder... of Key and WHERE clause tabs respectively in the New Index dialog. ADDITIONAL KEYWORDS: INCORROUT RESOLUTION: The lists of operators and functions will now be shown based on the context of use. APAR SE32315 : CA400EXP-OPNAV-DBASE CANNOT IMPORT SQL PLAN CACHE DATA FILE It is not possible to import an SQL Plan Cache Snapshot data file through System i Navigator from the SQL Plan Cache Snapshots folder. The import does not occur and no error message is displayed. APAR SE32316 : CA400EXP L2TP Remote Dial profile tries to dial *NONE In Remote Access Services, Originator L2TP Remote dial profile's empty phone numbers set to *NONE, and the profile tries to dial *NONE. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32317 : CA400EXP Physical line is not created for PPPoE A new physical line is not created in the system when creating a PPPoE Profile. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32318 : CA400EXP Incorrect profile Script ASCII value When displaying profile properties for a profile created with UCW, and click the OK button an out of range error message is displayed for the ascii code value RAS Properties is not validating the remote tunnelling end point in the field. When creating a new profile, changing the profile name does not update the line combo list in connection tab. In properties>tcpip settings, the local IP address allows you to enter invalid IP addresses. When a validation message comes up, it does not focus the correct panel. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32319 : CA400EXP incorrect modem retrieved by Profile Profile's properties display incorrect modem, in a dial profile created by Universal Connection Wizard. The GUI hangs when selecting modem "NONE" and try to save the configuration. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32320 : CA400EXP Optional Modem parameters are not saved in PPP In the modem tab under the profile's properties, trying to add optional modem parameters, those parameters are not saved. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32321 : CA400EXP-OPNAV-DBASE FORMAT NUMBER IN HEALTH CENTER In the Health Center, the formatting of numbers in the hint text for the Status column may be wrong when the number is a decimal. The problem is that it is displayed with an English format, no matter what the PC locale is. ADDITIONAL KEYWORDS: INCORROUT APAR SE32322 : CA400EXP-OPNAV-DBASE SQL ASSIST IS NOT CONNECTED The SQL Assist tool does not connect to the database. So it is not possible to build any SQL Statemtent since there is no information available for tables or columns. APAR SE32323 : CA400EXP-OPNAV-DBASE -MSGSQL0104 CONTROL STATEMENT SEMICOLON When using the Run SQL Scripts window, the user may get a MSGSQL0104 error message creating procedures, functions or triggers. This is possible when using control statements such as FOR - END FOR or WHILE - END WHILE. The problem is that the application treats the semicolon that ends the control statement as the statement terminator instead of the control statement terminator. APAR SE32324 : CA400EXP-OPNAV-DBASE UNABLE TO LOAD STRING IN REORGANIZE When reorganizing a table, the string 'Unable to load string resource. String ID = "PROCESSING_CONCURRENT_INSERTS_NODE"' may appear in the Reorganize dialog. A representative string should appear instead, such as 'Processing concurrent inserts - 2'. ADDITIONAL KEYWORDS: INCORROUT APAR SE32337 : CA400EXP SLIP Leased terminator profiles hangs on save When configuring a SLIP Leased terminator profile and an invalid IP address is set as "Local IP Address" value, the GUI hangs at saving time. On Web enviroment the panel remains the same but no error message is displayed. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32338 : CA400EXP ICMP version 6 not support in filter rules Protocol ICMP has a defintion and a different protocol number for IPv6 called ICMPv6 in Rules Editor, the Filter panel and the ICMP service panel do not have IPv6 support . ICMP service panel adds an additional parameter of the rule statement "V6" that represents this is an ICMP version 6, 'Filter' panel changes the 'Protocol' paramenter to "ICMPv6". ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT RESOLUTION: This PTF fixes the reported problem. The XPF PTF 'SI29843' should be applied in the system in order to enable ICMP version 6. APAR SE32339 : CA400EXP Able to enter invalid group name in L2TP In Remote Access Services, for a L2TP profile, the properties allows to input invalid data in Connection tab, Connection group name field. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32340 : CA400EXP Can not change Remote Key Server in VPN connections The 'Remote Key Server' identifier can not be changed to another value different of IP version 4 or IP version 6 addresses in a VPN connection. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32341 : CA400EXP FRAGMENT should not be included on permitnonVPNv6 When VPNPOLICYRULES.i3p file are defined for VPN connections and the "Permit Non VPN traffic - IPv6" option is checked from "Dynamic key-Group -> Interfaces Tab", permitnonvpnv6 FILTER line is created to allow all ipv6 traffic, 'FRAGMENTS = NONE' is also added in this statement and should be removed. If FRAGMENTS = NONE Is specified then the rule will be skipped for any fragmented packet, which would result in the packet hitting the default deny rule. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32342 : CA400EXP DNS TTLs units are set in English only The DNS configuration TTL value is not been read with the proper language. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32353 : CA400EXP problems in Multiple Domains and Bindings panels Under "Multiple domain" tab when adding a domain for an interface that is not in the first row of "SMTP Server bound interfaces" list the SMTP GUI hangs. Also under "Bindings" tab the "SMTP Client bound interface" list does not show the selected interfaces saved in the configuration. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32354 : CA400EXP L2TP profile does not save line validation list For a Receiver Connection Profile, when you go to the virtual line properties, set the "verify identity" checkbox in the "Authentication" tab, select a validation list or create a new one, if you add entries they are added in the table. If you click "OK" button to save the changes and open again the validation list, there are no entries in the table. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32357 : CA400EXP-OPNAV-DBASE AVERAGE OF QUERY ESTIMATES IN ADVISOR Using the Index Advisor, the user may see that the 'Average of Query Estimates' column does not display the correct value in microseconds. ADDITIONAL KEYWORDS: INCORROUT APAR SE32358 : CA400EXP Internal modem 576C missing Internal modem 576C is not shown in the resource list for Universal Connection Wizard. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32399 : CA400EXP-OPNAV OBSOLETE TASK DISPLAYED AFTER UPGRADE When you upgrade from iNav client v5r4m0 to v6r1m0, the "Install Additional Component" task under "My tasks" in the "Task" panel is appearing, and that particular task is not supported in v6r1m0 APAR SE29597 : CA400EXP-OPNAV-INCORROUT CLUSTER ADMIN DOMAIN MRE LIST ERROR Unexpected error when you try to open the list of a single MRE type. RECREATION Prerequisites: -Existent Cluster. -Existent Cluster Administrative Domain. -There are no MREs enrolled for that Cluster Administrative Domain. -Management Central Server is started from the server you want to connect from. Steps: 1. Open System i Navigator. 2. Select Management Central. 3. Login to Management Central Server. 4. Expand Management Central. 5. Select Clusters. 6. Expand your cluster. 7. Provide credentials as requested. 8. Expand Peer Resources. 9. Expand your cluster administrative domain. 10. Expand any MRE type category. Result: You will get "Unexpected Error" error message, plus additional information. RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Before expanding the list enroll at least one MRE in the Cluster Administrative Domain. APAR SE29905 : CA400EXP-OPNAV-PRINTERS-INCORROUT UNABLE TO SORT PRINTER OUTPUT Click on the Basic operations plus sign, Printers plus sign, click on a printer, right click on a printer, go to Customize this view. You will find Sort grayed out. This is not grayed out on previous releases. APAR SE29980 : CA400EXP-OPNAV-INCORROUT APPLICATION ADMINISTRATION PLUG-INS SETTING IS NOT WORKING AS DESIGNED Under Central Settings for App Admin in iNav when you restrict users from installing plugins this does not work during install. Users get prompted to install plugins and even if they are restricted they are allowed to answer yes and the install proceeds. APAR SE30770 : CA400EXP-OPNAV CONFIGURATION AND SERVICE FAILS WITH CPF3CF1 System i Navigator fails with CPF3CF1 error. Selection sequence: My Connections > System_name > Configuration and Service > Hardware May result in the following error: Error occurred while retrieving usage information for User_name on System_name CPF3CF1- Error code parameter not valid. where User_name is the signed on user and System_name is the connected system. APAR SE30848 : CA400EXP-OPNAV- ERROR CREATING NEW USER WITH JAPANESE CLIENT System i Navigator problem on Windows 2000 and client on Japanese environment. When creating a new user, CWBUNNAV.EXE fails with application error. The problem does not occur on Windows XP. Recreate as follows: 1. Run System i Navigator 2. My Connections -> System -> right click on Users and Groups and select "New User..." 3. Enter new user name 4. Click on Capabilities 5. Click on Application tab. APAR SE31060 : CA400EXP-OPNAV-DBASE-MSGCWB0111 UPDATING A CHARACTER COLUMN When updating a character column within the Edit Contents dialog in System i Navigator, the user may get a MSGCWB0111 error message. One way to recreate is if the user updates a value where the actual value is larger than the column length. The next attempt to update the value will fail with the MSGCWB0111 error message. It is possible to set a value larger than the column length by: 1. Having significant (non-blank) characters up to the maximum column length. 2. Adding blank spaces at the end, so the sum of the significant plus the blank characters is greater than the column length. RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: The problem is because of the mismatch between the server value and the overflowed client value. So using the Refresh action will reload the data from server and the user will not end up with the error on the next update. APAR SE31061 : CA400EXP-OPNAV-DBASE-INCORROUT UPDATE NOT SAVED INTO SERVER When the user updates a row through Edit Contents dialog, the data is not saved on the server and no error is signaled to the user. 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. The dialog shows the new value, but the server does not reflect the change. 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 SE31229 : CA400EXP IPv4 interface properties is not diplayed from Network->IPv4->Interfaces-> properties is not diplayed using R530 system with a System i Navigator R610 ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE32025 : CA400EXP-OPNAV ADVANCED JOB SCHEDULER CONTAINER IS EMPTY When initially opening the Advanced Job Scheduler plugin, there are no options listed. System i Navigator has to be closed and re-opened, then the plug-in options are displayed. APAR SE32448 : CA400EXP-OPNAV-INCORROUT QLMTDEVSSN inaccurately described Sign on item for device sessions shows inaccurate information when comparing System Values between endpoints under Management Central hierarchy. RESOLUTION: The code has been changed to describe correctly the Maximum number of device session a user can have. APAR SE31085 : CA400EXP-OPNAV-INCORROUT when display strings in norwegian Some strings are displayed in English instead of Norwegian APAR SE32051 : CA400EXP-OPNAV MGTC Fix Task mix Fixes and Fix Groups Management Central Fixes Task, for Compare and Update function, mix Fixes and Fix Groups detailed status in the lower level panel. RESOLUTION: Code has been modified to filter Fixes and Fix Groups properly. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE31895 : CA400EXP-DTRANSFER FILE TYPE CHANGED AFTER MSGCWBTF0002 An System i Access for Windows data transfer request is created to transfer a file to the PC. The output type is set to file and the file name is the name and location of a file that already exist. In the transfer details, the file type is set to any file type and the option to 'Create new file' is selected. When the transfer runs, an error CWBTF0002 will result, prompting the user to select OK to overwrite the existing PC file or press Cancel to stop the transfer request. If the OK is pressed on the message CWBTF0002, the transference succeeds and the file is overwritten correctly but, if the Cancel button is pressed and a different file name is provided, the file is created but no data is transfered. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE31662 : CA400EXP-DTRANSFER ADD-IN FAILS WITH TIME FORMATTED CELLS There is a problem when transferring data from a Microsoft Excel spreadsheet using the System i Access data transfer Excel Add-in. When there are cells that are formatted as a Time value, the scanning tool defines these as numeric columns instead of Time. The only time format that seems to work correctly is a custom time format. Since there is no way to change the type from numeric to Time in the database creation wizard, the wizard cannot be used to create a proper table to put this data in. ODBC ---- APAR SE30295 : CA400EXP-ODBC-INCORROUT INCORRECT TYPE CONVERSION USED A PC application is using the System i Access for Windows ODBC driver through Microsoft's MSDASQL OLEDB provider. Because of this configuration, the application is not making ODBC API calls directly, they are using ADO and the MSDASQL provider determines which ODBC APIs to call and how to call them. When a query returns a LOB type followed by a numeric type it was discovered that the MSDASQL provider will not bind the non-LOB columns or even use the SQLGetData and specify a data type to return the data as. Instead they are defining a descriptor using the SQLSetDescField function to define the column type and size as numeric then later calling the the SQLGetData function specifying SQL_ARD_TYPE for the target type. Tracing and re-creates showed that the System i Access ODBC driver is returning the data as character rather than the ARD type which was defined as numeric. This may ultimately result in another error such as a truncation error or data out of range type of error but that error is because of what the application does with the data that was returned to them in the incorrect format. APAR SE30749 : CA400EXP-ODBC-WAIT HANG ENDING XA ENLISTMENT System i Access for Windows ODBC driver is being used in conjunction with Microsoft's Distributed Transaction Coordinator in Microsoft SQL Server environment with an ODBC connection pool. The first use of the ODBC connection enlists the ODBC driver in a distributed transaction and uses the connection without commiting or rolling the the transaction back. The connection is returned to the connection pool and sits idle until the next use. The second use first has to end the existing transaction. The ODBC driver enters into the function to un-enlist it from the existing distributed transaction. The ODBC driver never returns back from that function. To the SQL Server application it appears to be hung. OLE DB PROVIDER --------------- APAR SE30751 : CA400EXP-INCORROUT DISTRIBUTED TRANSACTION WITH SQL SERVER 2005 AND IBMDASQL FAILS. Customer is attempting to run a distributed transaction with the IBMDASQL provider and a linked server in MS SQL Server 2005. Here is the syntax that they're using from a query window in the SQL Server Management Studio: SET XACT_ABORT ON GO BEGIN DISTRIBUTED TRANSACTION; INSERT INTO IBMDB2i.iDatabase.LibName.FileName (ITDSC) VALUES('MicrosoftXA') COMMIT TRANSACTION; This fails with the following output in the messages window: OLE DB provider "IBMDASQL" for linked server "IBM_DB2" returned message "PWS0002: Function completed successfully. Cause . . . . . : The requested function completed without any errors.". Msg 7394, Level 16, State 2, Line 2 The OLE DB provider "IBMDASQL" for linked server "IBM_DB2" reported an error committing the current transaction. APAR SE30788 : CA400EXP-OLEDB-MSGSQL0104 DUE TO SINGLE LINE COMMENTS IN SQL Customer was complaining that Carrige Returns were being stripped off in OLEDB provider. trace showed SQL0104 APAR SE31868 : CA400EXP-OLEDB-INCORROUT ADSCHEMACOLUMNS FOR OPENSCHEMA METHOD RETURNS NO RESULTS WHEN USING CLIENT SIDE CURSOR. Microsoft ADO OpenSchema method using adSchemaColumns as the QueryType returns empty results instead of a list of columns when using System i Access for Windows OLE DB provider. This issue only occurs when using a client side cursor, adUseClient. Using a server side cursor, adUseServer, returns the correct results. .NET DATA PROVIDER ------------------ APAR SE32325 : CA400EXP-IDB2DATA iDB2Permission fails in 64-bit When using the iDB2Permission or iDB2PermissionAttribute class to restrict permissions on a 64-bit machine, a SecurityException is not always generated when expected. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- APAR SE32359 : CA400EXP-AFPVIEWER OpNav View spooled file fails on Vista Right click a spooled file from System i Navigator and attempt to open it. This action fails when attempted on Windows Vista. APAR SE31194 : CA400EXP-AFPVIEWER-INCORROUT DISPLAY FAILS Unable to display a spooled file from System i Navigator for Windows when running on the Windows Vista operating system. RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Open a DOS window, navigate to c:\program files\ibm\client access\afpviewr (where c: is the drive letter where System i Access is installed) and run the cwbviewd command. Then re-try viewing the spooled file. 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 The PC5250 New Printer Dialog screen shows some corrupted Arabic characters. APAR SE30424 : CA400EXP-TERMEMUL-INCORROUT THE CURSOR DOES NOT APPEAR ON THE FIELD IF THAT IS DEFINED DSPATR(BL HI). The cursor does not appear on the field If that is defined dspatr(BL HI). Blink atribute. For instance: there are three field as FA(first) FB(second) FC(third) FA _____ FB ____ FC ____ FA and FB do not show up the cousor but FC can see it Any condition: This happens on V5R3 as well. APAR SE30508 : CA400EXP-TERMEMUL-UNPRED IN A KOREAN INSTALL ENVIRONMENT, SWITCHING BETWEEN APPLICATIONS CAUSES THE EMULATOR TO CLOSE. When a user with a Korean installation of System i Access opens multiple sessions and attempts to switch between them, all sessions close without warning. APAR SE30613 : CA400EXP-TERMEMUL-INCORROUT CLOSING SESSION WITH FILE EXIT ALL CAUSES APPLICATION ERROR ON PCSWS.EXE Win2003 Server 64-bit version with Citrix. When closing PC5250 display session by using File, exit all option Application error PCSWS.EXE error module MSVCRT.DLL is issued. Problem happens only after installing servicepack SI17741 APAR SE31152 : CA400EXP-TERMEMUL-INCORROUT PC5250 DOES NOT SUPPORT GREEK ALPHABETIC CHARACTERS IN AN ALPHABETIC ONLY FIELD. System i Access for Windows PC5250 display emulation flags a status bar message 'Field requires alphabetic characters' when Greek alphabetic characters are typed into an alphabetic only input field. The PC5250 session is correctly setup for a Greek environment. SECURE SOCKETS LAYER (SSL) -------------------------- APAR SE30656 : CA400EXP-SSL-MSGCWBCO1052 STASH PASSWORD IS NO LONGER CHECKED BY DEFAULT. Design on SSL with System i Access called for the STASH PASSWORD box to be checked by default in iKeyMan. This 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. VISUAL BASIC WIZARDS -------------------- 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. VISUAL BASIC WIZARDS -------------------- 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.