Informix - Problem description
Problem IT32248 | Status: Closed |
ERROR IN EXECUTION OF CERTAIN XML QUERIES FOLLOWING EARLIER FAILURE OF JAR FILE INSTALLATION FOR JAVA UDR | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
The fix for APAR IT26222 "executing queries using xml existsnode routine in parallel can assert server" introduces the use of a Java UDR for selected OS platforms, such as AIX, when executing certain XML queries. Upon executing a relevant XML query the Java UDR will automatically be created which requires the installation of a jar file. If there is an error during this process the Java UDR may still be created even though it cannot be executed. Once the problem relating to installation of the jar file is resolved execution of the XML query may still end in failure. Examples of error messages include: 9431: Can't find system class or method or library ($INFORMIXDIR/extend/krakatoa/jre/bin/liblibjava.so.so). and (46103) - Error loading Java UDR class ( : Class xmldb.informix.libxml_jar:libxml not found in jar xmldb.informix.libxml_jar. Please verify the three part name (dbname.username.jarid) of the installed jar with the jar file name in your JAR_TEMP_PATH or /tmp directory.). | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC4. * **************************************************************** | |
Local Fix: | |
These steps should be performed to effect a manual clean-up of the UDR associated with the XML query so that it may then be run successfully: 1. Identify and resolve the problem relating to the failed Jar file installation. For example ensure that any deprecated JVP parameters are removed from the onconfig file. 2. Drop the Java UDR that is automatically created: $ echo 'drop function if exists libxml_xslt_check' | dbaccess - 3. Shut down the database server $ onmode -kuy 4. Remove any jar files from $INFORMIXDIR/tmp that may have been created in relation to the Java UDR: $ rm -f $INFORMIXDIR/tmp/..libxml_jar.jar where is the name of the database where the XML query was executed and is the username that ran it. 5. Restart the database server and re-run the XML query. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC4. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC4. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 20.03.2020 14.12.2020 14.12.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |