Known Issues for Installation and Configuration

Descriptions of known issues and workarounds for SAP Sybase IQ installation.

Installer issues
CR#	Description
749703	Installer displays the available disk space as 'Error' – If the available disk space is greater than the installer can display, the pre-installation summary displays the available disk space as 'Error'. Workaround – There is no workaround for this display issue, which does not affect installation. SAP Sybase is aware of the problem and will address the issue in a future release.
749835	Windows installer requires Microsoft Visual C++ 2005 SP1 Redistributable Package – Launching the installer may return the following exception: Windows error 14001 occurred while loading the Java VM Workaround – If you get this error, install the Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package MFC Security Update before launching the installer again. This service pack is included as part of the installation package. To install: Open Windows Explorer. Navigate to \archives\ms-redist-2005 on the installable image. Do this: On 32-bit machines, run vcredist_x86.exe On 64-bit machines, run vcredist_x86.exe and vcredist_x64.exe Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package MFC Security Update is also available as a free download from the Microsoft Download Center at: http://www.microsoft.com/en-us/download/details.aspx?id=26347
690606	RH 6.x default setting for max user processes may be too low for starting SAP Sybase IQ servers – Red Hat 6.x introduced a change that affects the number of threads that the SAP Sybase IQ engine can start. By default, Red Hat 5.x set the limit dynamically based on the machine configuration. (For example, an 8-core system would set the limit at 256693.) In Red Hat 6.x, this limit is hard-coded to 1024 regardless of system size. This change particularly affects systems with high CPU per core counts and systems where the same user account starts multiple IQ servers. Workaround 1 – Calculate the number of threads needed. For each server started by any single user, use the following formula to calculate the number of threads IQ allocates: numThreads = 604 + 50(numCPUs - 4) + numConnections + 3 For an 8-core system with 100 users, the `numThreads` is 543 threads per server. For a 64-core system with 100 users, the `numThreads` is 3343 threads per server. The formula also works for systems with fewer CPUs, for example, on 2-core systems. To set hard and soft limits, add the following lines to /etc/security/limits.conf: sybase soft nproc 7712 -- The soft limit allows for 2 servers on the 64-core system plus 1024 default. sybase hard nproc 16384 -- Powers of 16 work well for kernel and engine settings. (1024 * 16) is rounded up for extra space. You can increase the soft limit, but the hard limit is the threshold for the value unless raised by a privileged user limit. To set limits for all users instead of the sybase user, replace sybase with ``, for example: soft nproc 7712 * hard nproc 16384 Set the process number limit in the shell script of the user who starts servers, for example: For the tcsh or C (csh) shell: limit maxproc 7712 For the bash or Korn (ksh) shell: ulimit –u 7712 Reboot your machine. Workaround 2 – Return to Red Hat 5.x behavior by commenting out the following line in the file /etc/security/limits.d/90-nproc.conf: #* soft nproc 1024 Reboot your machine.
684311	Install on RH 6.0 fails with java stack trace – Red Hat Enterprise Linux 6 requires 32-bit compatibility libraries to support Java-based applications in SAP Sybase IQ, including the SAP Sybase IQ installer. Workaround – These libraries are required to install SAP Sybase IQ on Red Hat Enterprise Linux 6: libXext-devel.i686 libXtst-devel.i686 If you start the SAP Sybase IQ installer in GUI mode without installing these libraries, the installer generates an exception and fails.
665300	Installer stops responding on some UNIX-like platforms – On some UNIX-like operating systems, a network resource may cause the installer to stop responding and return the error "syntax error near unexpected token 'fi'." The df command also stops responding in this situation. Workaround – Identify the network file system (NFS) mounts that may have problems: strace -e statfs, statfs64 df Use the umount command to unmount an identified NFS mount: umount -l <path> Repeat the above steps until there are no more NFS mounts that have stopped responding. Note: The umount command requires root permission. If umount unmounts the NFS, you may have to restart your machine.
664968, 669802	Installer returns "Permission denied" error on Red Hat – The installer may return this error on Red Hat, when the installation DVD has been automatically mounted: ./setup.bin: /bin/sh: bad interpreter: Permission denied Workaround – Remount the installation media and run the installation again: Unmount the installation media. Manually mount the DVD drive: Use one of the following commands to remount the drive: mount -t iso9660 /dev/hda /mnt/cdrom mount -o exec /dev/cdrom /media Start the installation using the new mounted directory /mnt/cdrom.
655963	Installer returns error "No filesystem could mount root" on Red Hat – The installer may return this error on Red Hat when installing on IBM P6 and P7 machines: rhel6 install error: No filesystem could mount root, tried: iso9660 Workaround – Follow the steps on http://www.ibm.com/developerworks/forums/thread.jspa?threadID=357314 and re-install.
641873, 652690, 652696, 652866, 643106	Do not install SAP Sybase IQ16.0 into the same directory as older Sybase products – Installing Sybase SAP Sybase IQ 16.0 into the same directory with older SAP Sybase Products may render some or all of these products unusable. Workaround – Install SAP Sybase IQ16.0 into a different directory than the one you use for older products.