WebSphere Message Broker, Version 8.0.0.7
Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS
See information about the latest product version
See information about the latest product version
Resolving ESQL problems when developing message flows
This topic contains advice for dealing with some common ESQL problems that can arise when developing message flows:
A Routine not defined error message is issued in ESQL when you move a routine
- Scenario: A Routine not defined error message is displayed in ESQL when you move a routine from one schema to another.
- Explanation: If a routine that was referenced by code in one schema is moved to another schema, where it is still visible, a false error is generated stating that the routine cannot be resolved.
- Solution: Clean the project by clicking .
The product fails to respond when you paste ESQL statements from Adobe Reader
- Scenario: When you copy and paste certain ESQL statements from Adobe Reader into the ESQL editor, WebSphere® Message Broker stops responding.
- Explanation: This problem occurs when you paste text directly from Adobe Reader into either the ESQL editor or the Java™ editor.
- Solution: To work around this problem, either enter the text manually, or copy and paste it to a text editor (such as Notepad), then perform another copy and paste action from there.
You do not know how message flows handle the code page of ESQL files
You do not know the naming restrictions for ESQL procedures and functions
- Scenario: You do not know the restrictions for choosing names for ESQL modules or schema scope ESQL and mapping procedures and functions.
- Solution: Module and schema scope procedures and functions cannot have names starting with IBM_WBIMB_ because IBM_ is reserved for IBM® use, and IBM_WBIMB_ is reserved for WebSphere Message Broker.
Error message BIP5431 is issued and the broker fails
- Scenario: Error message BIP5431 is displayed and the broker fails.
- Explanation: When setting output message properties, you have specified an incorrect physical format name for the message format.
- Solution: The name that you specify for the physical layer must match the name that you have defined for it. The default physical layer names are Binary1, XML1 and Text1.
You are unable to call Java from ESQL
- Scenario: Your Java class files are not being found.
- Explanation: When creating the class files, you have not placed them in the correct location within the system CLASSPATH.
- Solution: See the CREATE PROCEDURE statement for further information.
Error message BIP3203 is issued: Format expression is not a valid FORMAT expression for converting expression to type
- Scenario: Your format expression contains an unrecognized character for the conversion.
- Explanation: Your format expression for a numeric conversion was used to convert to or from a DATE, TIME, TIMESTAMP, GMTTIME or GMTTIMESTAMP variable. Another possible explanation is that your format expression for a DateTime conversion was used to convert to or from an INTEGER, DECIMAL or FLOAT variable.
- Solution: Replace the format expression with one from the applicable types. For more information about valid data types and expressions, see the ESQL reference topic.
Error message BIP3204 is issued: Input expression does not match FORMAT expression. Parsing failed to match
- Scenario: You have used an input string that does not match the format expression.
- Explanation: Your format expression contains data that does not match the current element of the format expression.
- Solution: Either rewrite the format expression to match the input data, or modify the input data to match the format expression. For more information about valid data types and expressions, see the ESQL reference topic.
The CAST function does not provide the expected DST offset for non-GMT time zones
- Scenario: You are using the CAST function to convert a string to a TIME variable, in a broker that is running in a time zone other than GMT. The daylight saving time (DST) offset is not correctly calculated.
- Explanation: If no time zone is associated with the time string passed to CAST, it is converted to GMT time. If no date is supplied, the current system date is assumed.
- Solution: Specify the correct time zone and date. See Formatting and parsing dateTimes as strings for more information.
Error message BIP3205 is issued: The use of a FORMAT expression is not allowed when converting
- Scenario: You have used a format expression when it is not applicable, for example when converting from decimal to integer.
- Explanation: The use of format expressions is limited to casting between datetime and string values or numeric and string values. Your format expression cannot be applied in this case.
- Solution: Either remove the FORMAT clause, or change the parameters. For more information about valid data types and expressions, see the ESQL reference topic.