| Author |
Message
|
| madi |
 Posted: Tue Jul 11, 2006 12:55 pm Post subject: cannot find function!! wbi6.0 |
 |
|
Chevalier
Joined: 17 Jan 2006
Posts: 475
|
Hello guys
i am getting this error when i deploy the flows
| Quote: |
BIP2558E: (.ERR_DEFAULT_DATETIMESTAMP_FIELD_VALUE, 1.67) : Undefined function '.CURRENT_DATE_TIME_STAMP_STRING'.
The program is attempting to call a function which is not defined or is not in the schema path.
Correct the logic of the ESQL program and re-deploy the message flow. |
here is that function which is in another project referenced
| Code: |
CREATE FUNCTION CURRENT_DATE_TIME_STAMP_STRING() RETURNS CHARACTER
BEGIN
-- Converting the Current Date and Local Time to Character and returning the string equivalent of Current Date and Local time.
RETURN CAST(CURRENT_TIMESTAMP AS CHARACTER);
END;
|
the same flow with the same code worked in 5.0 and this error is only when i try to create a bar file in 6.0 and try to deploy it
i dont why something that was working fine would just give an error!!
can somebody help??
--madi |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Tue Jul 11, 2006 3:04 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Can you post the calling code?
And read up on timestamp functions. I believe they may work a little bit differently in the V6 broker...
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Tue Jul 11, 2006 7:41 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi madi,
Can u try a clean on the projects...i have such issues once in a while, rebuilding a few times and cleaning it fixes it...
Regards. |
|
| Back to top |
|
|
| madi |
| Posted: Wed Jul 12, 2006 6:31 am Post subject: |
|
|
Chevalier
Joined: 17 Jan 2006
Posts: 475
|
well .. i have tried cleaning them and will try again
| Quote: |
| Can you post the calling code? |
thats the funny part, i am not calling this function at all!!!!
--madi |
|
| Back to top |
|
|
| madi |
| Posted: Wed Jul 12, 2006 7:18 am Post subject: |
|
|
Chevalier
Joined: 17 Jan 2006
Posts: 475
|
when i take that function out completely i get this error about another function
| Quote: |
BIP2558E: (.ERR_EAI_SERVER_NAME_FIELD_VALUE, 1.61) : Undefined function '.GET_WIB_BROKER_NAME'.
The program is attempting to call a function which is not defined or is not in the schema path.
Correct the logic of the ESQL program and re-deploy the message flow. |
here is the code
| Code: |
DECLARE ERR_EAI_SERVER_NAME_FIELD_VALUE CONSTANT CHARACTER GET_WIB_BROKER_NAME();
CREATE PROCEDURE GET_WIB_BROKER_NAME ( ) RETURNS CHARACTER
LANGUAGE JAVA
EXTERNAL NAME "com.tgt.wbimb.enterprise.util.WbiMbUtil.getBrokerName";
|
both the calling code and function are in the same eSQL file!! but it still cannot see it
--madi |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Jul 12, 2006 3:03 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Are you sure your executable is in synch with your source ?
If you have a decent source I would try recompiling it and redeploying it.
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
