| Author |
Message
|
| bhavyabhandari |
 Posted: Thu May 17, 2007 12:25 am Post subject: URGENT-Set value in Expiry field in MQMD |
 |
|
Apprentice
Joined: 09 Nov 2006
Posts: 33
|
Hi
i am using the following codes for setting value in expiry field in MQMD but while deploying i am getting error in eventlog
(
User defined attribute must specify an initial value expression.
User defined attributes must either be given an initial value on the DECLARE statement or be given a value at deploy time.
Set the value of the User Defined Attribute at deploy time.
)
The codes which i have used:
1.
SET OutputRoot.MQMD.Expiry = CAST(CURRENT_TIME + CAST(30 AS INTERVAL SECOND) AS GMTTIMESTAMP);
2. SET OutputRoot.MQMD.Expiry = 1500;
Both these are giving errors.
Kindly tell the code for setting the value.
Thanks in advance |
|
| Back to top |
|
 |
| marcin.kasinski |
| Posted: Thu May 17, 2007 12:32 am Post subject: Re: URGENT-Set value in Expiry field in MQMD |
|
|
Sentinel
Joined: 21 Dec 2004
Posts: 850
Location: Poland / Warsaw
|
This problem refers to totally different part of your code.
Are you using UDP in your flow ?
Check EXTERNAL variable in your ESQL .
It should be initialized or you should set UDP value in configure tab.
_________________
Marcin
Last edited by marcin.kasinski on Thu May 17, 2007 2:21 am; edited 1 time in total |
|
| Back to top |
|
|
| bhavyabhandari |
| Posted: Thu May 17, 2007 12:43 am Post subject: Re: |
|
|
Apprentice
Joined: 09 Nov 2006
Posts: 33
|
Wel I am not using UDP in the flow..
Still it is giving the errors as mentioned,... |
|
| Back to top |
|
|
| marcin.kasinski |
| Posted: Thu May 17, 2007 1:02 am Post subject: Re: |
|
|
Sentinel
Joined: 21 Dec 2004
Posts: 850
Location: Poland / Warsaw
|
| bhavyabhandari wrote: |
Wel I am not using UDP in the flow..
Still it is giving the errors as mentioned,... |
How about ESQL.
Is there EXTERNAL keyword ?
_________________
Marcin |
|
| Back to top |
|
|
| bhavyabhandari |
| Posted: Thu May 17, 2007 1:53 am Post subject: |
|
|
Apprentice
Joined: 09 Nov 2006
Posts: 33
|
welll i have not used external in the esql....
can u plese tell me the code for setting the value in the expiry field as i am trying it for the last 4 hours and still i am not able to do it.
thanks |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu May 17, 2007 2:14 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| bhavyabhandari wrote: |
| can u plese tell me the code for setting the value in the expiry field as i am trying it for the last 4 hours and still i am not able to do it. |
The 2. code you're using is fine (Expiry is an integer not a timestamp).
What leads you to believe the error you're quoting is connected to the code you're quoting? As the previous posts have mentioned, there's no obvious connection between setting the expiry and a missing UDP.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| marcin.kasinski |
| Posted: Thu May 17, 2007 2:16 am Post subject: |
|
|
Sentinel
Joined: 21 Dec 2004
Posts: 850
Location: Poland / Warsaw
|
| bhavyabhandari wrote: |
welll i have not used external in the esql....
can u plese tell me the code for setting the value in the expiry field as i am trying it for the last 4 hours and still i am not able to do it.
thanks |
I'm trying to tell you that this is not problem with code you showed here.
Please comment this lines and you will get the same error.
What I suggest :
- clear Event logs in toolskit.
- check flows in bar (if it has UDP defined)
- check ESQL (is there EXTERNAL keyword)
- deploy bar.
- check Event logs again.
If you get the same error you should have UDP defined or EXTERNAL keyword in your esql.
_________________
Marcin |
|
| Back to top |
|
|
| kishoreraju |
| Posted: Thu May 17, 2007 12:46 pm Post subject: |
|
|
Disciple
Joined: 30 Sep 2004
Posts: 156
|
did you checked the event log . it will show you the correct error. like what was missing in the header for setting expiry.try by setting the reporting option also.
SET OutputRoot.MQMD.Report =0 |
|
| Back to top |
|
|
| marcin.kasinski |
| Posted: Thu May 17, 2007 12:56 pm Post subject: |
|
|
Sentinel
Joined: 21 Dec 2004
Posts: 850
Location: Poland / Warsaw
|
| kishoreraju wrote: |
did you checked the event log . it will show you the correct error. like what was missing in the header for setting expiry.try by setting the reporting option also.
SET OutputRoot.MQMD.Report =0 |
In my opinion error message showed here explains source of problem.
| Quote: |
User defined attribute must specify an initial value expression.
User defined attributes must either be given an initial value on the DECLARE statement or be given a value at deploy time.
Set the value of the User Defined Attribute at deploy time. |
_________________
Marcin |
|
| Back to top |
|
|
|
|
