| Author |
Message
|
| brgmo |
 Posted: Mon Apr 11, 2005 7:09 am Post subject: gETING ERROR WHILE DEPLOYING ESQL CALLING JAVA TO BROKER |
 |
|
Master
Joined: 03 Jun 2002
Posts: 227
|
hI
i GET THE FOLLOWING ERROR WHEN I TRY TO DEPLOY AN ESQL COMPUTE NODE WHICH CALLS A JAVA CLASS:
BIP4121E: Syntax error in SQL statements in compute node 'Error_Handler.'.
The configuration of compute node Error_Handler. failed due to errors in the SQL expression. See the following messages for details of the error. The statement text was ' CREATE SCHEMA "" CREATE COMPUTE MODULE Error_Handler_Compute CREATE FUNCTION Main() RETURNS BOOLEAN BEGIN CALL CopyMessageHeaders(); CALL CopyEntireMessage(); DECLARE ERRORMESSAGE CHARACTER; DECLARE errMsgID CHARACTER; DECLARE ts TIMESTAMP; DECLARE errMsgToErrQ CHARACTER; DECLARE start REFERENCE TO InputRoot.*[1]; SET errMsgID = start.Xml.ErrorMessage.ErrorHeader.ErrorMessageID; SET ts = start.Xml.ErrorMessage.ErrorHeader.TimeStamp; SET errMsgToErrQ = errMsgID || ts; CALL LogToFile(errMsgToErrQ); PROPAGATE; RETURN TRUE; END; CREATE PROCEDURE CopyMessageHeaders() BEGIN DECLARE I INTEGER 1; DECLARE J INTEGER CARDINALITY(InputRoot.*[]); WHILE I < J DO SET OutputRoot.*[I] = InputRoot.*[I]; SET I = I + 1; END WHILE; END; CREATE PROCEDURE CopyEntireMessage() BEGIN SET OutputRoot = InputRoot; END; --CREATE PROCEDURE LogToFile(IN ERRMSG CHARACTER,OUT ERRMSG1 CHARACTER,INOUT ERRMSG3 INTEGER) CREATE PROCEDURE LogToFile(IN ERRMSG CHARACTER) LANGUAGE JAVA EXTERNAL NAME "FileWriterUtl.writeToFile"; END MODULE; '.
The next error message will give specific details of where the error occurred in the statement text. Check the correct syntax for compute node SQL statements in the WebSphere MQ Integrator publications. Correct the statements configuring the node and redeploy the configuration.
BIP2498E: (.Error_Handler_Compute.LogToFile, 1.2) : Illegal third argument to SUBSTRING function.
The third argument must be an integer giving a valid length for the substring.
Correct the syntax of the expression and redeploy the message flow.
ANY IDEA WHY THIS VOULD BE HAPPENING.
BRGMO. |
|
| Back to top |
|
 |
| JT |
| Posted: Mon Apr 11, 2005 7:23 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Are there any messages in the Windows EventLog? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Apr 11, 2005 7:30 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
There should be an additional error message in the Event Log after the two.
It may or may not include anything more than just a BIP number.
Enter the BIP number here and it will tell you what is wrong with your Java code.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| brgmo |
| Posted: Mon Apr 11, 2005 7:56 am Post subject: |
|
|
Master
Joined: 03 Jun 2002
Posts: 227
|
yes,i looked into the bip messages and they say that class can not be found in the classpath.however i have put classpath which is c:\java into the system classpath.any help is greatly appreciated.
brgmo. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Apr 11, 2005 8:18 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You have to explicitly add the individual jar file that contains your class to the broker classpath.
If your broker is on Windows, you will have to restart the machine for the classpath settings to take effect.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| brgmo |
| Posted: Mon Apr 11, 2005 8:26 am Post subject: |
|
|
Master
Joined: 03 Jun 2002
Posts: 227
|
i have created a jar file which contains the class file which will be called from the esql.now how to add this file to broker classpath like ishould place it somewhere in the root directory of wbi.
brgmo. |
|
| Back to top |
|
|
| brgmo |
| Posted: Mon Apr 11, 2005 9:28 am Post subject: |
|
|
Master
Joined: 03 Jun 2002
Posts: 227
|
can anybody help me as why the message flow is not getting deployed.I have tried all my attempts.nothing seems to be working.
brgmo. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Apr 11, 2005 9:38 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
There's some specific information about deploying java procedures here.
The Info Center in general is a lot more helpful than not.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| brgmo |
| Posted: Mon Apr 11, 2005 10:56 am Post subject: |
|
|
Master
Joined: 03 Jun 2002
Posts: 227
|
I have read all that and followed strictly what was written but still its not working.Please help me.Its very crucial.
brgmo. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Apr 11, 2005 11:09 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Is it still giving you the class not found BIP?
Or a different BIP?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mgk |
| Posted: Tue Apr 12, 2005 1:14 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
It would appear that your tooling / runtime is not at the reqired level. Try reinstalling FixPack 4
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| brgmo |
| Posted: Tue Apr 12, 2005 6:06 am Post subject: |
|
|
Master
Joined: 03 Jun 2002
Posts: 227
|
I dont know suddenly it has started working.i havent done anything.
brgmo. |
|
| Back to top |
|
|
| waugh |
| Posted: Tue Apr 12, 2005 6:11 am Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 225
|
| You restarted the system i guess.... |
|
| Back to top |
|
|
|
|
