#119602 - 06/28/05 08:01 PM
Re: Email Engine Issue: Semi-Colon ;
[Re: patrick zandi]
|
journeyman
Registered: 05/10/05
Posts: 156
|
What happens if you use workflow to convert all the semicolons to commas
before it hits the Email Engine?
--Tim
Zandi Patrick S TSgt AFRL/IFOS wrote:
> Hello,
> Found an issue on Remedy Email engine..
>
> We have set up a trigger in oracle to send remedy an Email engine Submit
> into remedy
> This seems to be working well.. Except..
> In the oracle procedures.. It is sending an extra ";" at the end of every
> list of addressees.
> Now normally in the exchange world it would be removed and ingnored.
> But in the SMTP world.. It is still there..
>
> So the issue is :: if the address is a Single address
> MyName@rl.af.mil;
> The email engine parses and it works fine..
> But if the messages come in with multiple addresses. Like
> yourname@rl.af.mil; myname@rl.af.mil;
> That extra Semi-colon gets rejected by the email server.. And sends the
> following error.
>
> javax.mail.internet.AddressException: Illegal semicolon, not in group in
> string ``name1@rl.af.mil;name2@rl.af.mil;'' at position 18
>
> Rejecting the incoming message..
>
> Has anyone else found this .. And is there a fix / patch for this..
> I will look over the web site here after this post..
>
> Just trying to solve as fast as possible.. Thanks.
> We are also trying to remove the Extra ; from the oracle code as well
> But it was written by someone who is gone.. Oh what fun.
> thanks
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
|
|
Top
|
|
|
|
|
|
#119604 - 06/28/05 08:42 PM
Re: Email Engine Issue: Semi-Colon ;
[Re: patrick zandi]
|
newbie
Registered: 09/09/04
Posts: 24
|
You can use the following in your SQL to replace the ";" to ",";
REPLACE(<
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Zandi Patrick S TSgt AFRL/IFOS
Sent: Wednesday, June 29, 2005 1:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Email Engine Issue: Semi-Colon ;
Have not tested on that side.. Yet.. Tim.
We are still Decoding three different portions of Oracle that is executing
this..
I really needed to know if the ; issue was apparent and it someone will
should ..
Oh yeah... That was patch blah blah.
ENV:: ARS 5.1.2 P 1389
Application has started Version: 5.01.02 patch 1313
Using JRE: 1.4.208
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Tim Widowfield
Sent: Wednesday, June 29, 2005 2:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: Email Engine Issue: Semi-Colon ;
What happens if you use workflow to convert all the semicolons to commas
before it hits the Email Engine?
--Tim
Zandi Patrick S TSgt AFRL/IFOS wrote:
> Hello,
> Found an issue on Remedy Email engine..
>
> We have set up a trigger in oracle to send remedy an Email engine
> Submit into remedy This seems to be working well.. Except..
> In the oracle procedures.. It is sending an extra ";" at the end of
> every list of addressees.
> Now normally in the exchange world it would be removed and ingnored.
> But in the SMTP world.. It is still there..
>
> So the issue is :: if the address is a Single address
> MyName@rl.af.mil; The email engine parses and it works fine..
> But if the messages come in with multiple addresses. Like
> yourname@rl.af.mil; myname@rl.af.mil; That extra Semi-colon gets
> rejected by the email server.. And sends the following error.
>
> javax.mail.internet.AddressException: Illegal semicolon, not in group
> in string ``name1@rl.af.mil;name2@rl.af.mil;'' at position 18
>
> Rejecting the incoming message..
>
> Has anyone else found this .. And is there a fix / patch for this..
> I will look over the web site here after this post..
>
> Just trying to solve as fast as possible.. Thanks.
> We are also trying to remove the Extra ; from the oracle code as well
> But it was written by someone who is gone.. Oh what fun.
> thanks
>
>
> UNSUBSCRIBE or access ARSlist Archives at
> http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
|
|
Top
|
|
|
|
|
|
#119605 - 06/28/05 08:46 PM
Re: Email Engine Issue: Semi-Colon ;
[Re: patrick zandi]
|
newbie
Registered: 09/09/04
Posts: 24
|
You can use the following in Oracle to replace the ";" to ","
replace('',';',',')
your SQL could be as below:
select REPLACE(EMAIL,';',')
from
in Oracle world and us that to set your e-mail separator.
Hoipe it helps.
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Zandi Patrick S TSgt AFRL/IFOS
Sent: Wednesday, June 29, 2005 1:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Email Engine Issue: Semi-Colon ;
Have not tested on that side.. Yet.. Tim.
We are still Decoding three different portions of Oracle that is executing
this..
I really needed to know if the ; issue was apparent and it someone will
should ..
Oh yeah... That was patch blah blah.
ENV:: ARS 5.1.2 P 1389
Application has started Version: 5.01.02 patch 1313
Using JRE: 1.4.208
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Tim Widowfield
Sent: Wednesday, June 29, 2005 2:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: Email Engine Issue: Semi-Colon ;
What happens if you use workflow to convert all the semicolons to commas
before it hits the Email Engine?
--Tim
Zandi Patrick S TSgt AFRL/IFOS wrote:
> Hello,
> Found an issue on Remedy Email engine..
>
> We have set up a trigger in oracle to send remedy an Email engine
> Submit into remedy This seems to be working well.. Except..
> In the oracle procedures.. It is sending an extra ";" at the end of
> every list of addressees.
> Now normally in the exchange world it would be removed and ingnored.
> But in the SMTP world.. It is still there..
>
> So the issue is :: if the address is a Single address
> MyName@rl.af.mil; The email engine parses and it works fine..
> But if the messages come in with multiple addresses. Like
> yourname@rl.af.mil; myname@rl.af.mil; That extra Semi-colon gets
> rejected by the email server.. And sends the following error.
>
> javax.mail.internet.AddressException: Illegal semicolon, not in group
> in string ``name1@rl.af.mil;name2@rl.af.mil;'' at position 18
>
> Rejecting the incoming message..
>
> Has anyone else found this .. And is there a fix / patch for this..
> I will look over the web site here after this post..
>
> Just trying to solve as fast as possible.. Thanks.
> We are also trying to remove the Extra ; from the oracle code as well
> But it was written by someone who is gone.. Oh what fun.
> thanks
>
>
> UNSUBSCRIBE or access ARSlist Archives at
> http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
|
|
Top
|
|
|
|
|
|
#119606 - 06/28/05 08:55 PM
Re: Email Engine Issue: Semi-Colon ;
[Re: patrick zandi]
|
journeyman
Registered: 04/06/05
Posts: 155
|
Wow...that looks like you either hit send to fast...or the list processor
ate it
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rahman, Sayeed
Sent: Wednesday, June 29, 2005 12:43 PM
To: arslist@ARSLIST.ORG
Subject: Re: Email Engine Issue: Semi-Colon ;
You can use the following in your SQL to replace the ";" to ",";
REPLACE(<
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Zandi Patrick S TSgt AFRL/IFOS
Sent: Wednesday, June 29, 2005 1:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Email Engine Issue: Semi-Colon ;
Have not tested on that side.. Yet.. Tim.
We are still Decoding three different portions of Oracle that is executing
this..
I really needed to know if the ; issue was apparent and it someone will
should ..
Oh yeah... That was patch blah blah.
ENV:: ARS 5.1.2 P 1389
Application has started Version: 5.01.02 patch 1313 Using JRE: 1.4.208
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Tim Widowfield
Sent: Wednesday, June 29, 2005 2:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: Email Engine Issue: Semi-Colon ;
What happens if you use workflow to convert all the semicolons to commas
before it hits the Email Engine?
--Tim
Zandi Patrick S TSgt AFRL/IFOS wrote:
> Hello,
> Found an issue on Remedy Email engine..
>
> We have set up a trigger in oracle to send remedy an Email engine
> Submit into remedy This seems to be working well.. Except..
> In the oracle procedures.. It is sending an extra ";" at the end of
> every list of addressees.
> Now normally in the exchange world it would be removed and ingnored.
> But in the SMTP world.. It is still there..
>
> So the issue is :: if the address is a Single address
> MyName@rl.af.mil; The email engine parses and it works fine..
> But if the messages come in with multiple addresses. Like
> yourname@rl.af.mil; myname@rl.af.mil; That extra Semi-colon gets
> rejected by the email server.. And sends the following error.
>
> javax.mail.internet.AddressException: Illegal semicolon, not in group
> in string ``name1@rl.af.mil;name2@rl.af.mil;'' at position 18
>
> Rejecting the incoming message..
>
> Has anyone else found this .. And is there a fix / patch for this..
> I will look over the web site here after this post..
>
> Just trying to solve as fast as possible.. Thanks.
> We are also trying to remove the Extra ; from the oracle code as well
> But it was written by someone who is gone.. Oh what fun.
> thanks
>
>
> UNSUBSCRIBE or access ARSlist Archives at
> http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
|
|
Top
|
|
|
|
|
|
#119608 - 06/28/05 11:30 PM
Re: Email Engine Issue: Semi-Colon ;
[Re: patrick zandi]
|
old hand
Registered: 06/12/01
Posts: 930
|
FYI... In Oracle you can also remove the last ';' (or ',') as well with
rtrim('','value') Value defaults to a space.
rtrim(replace('',';',','),',')
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rahman, Sayeed
Sent: Wednesday, June 29, 2005 1:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: Email Engine Issue: Semi-Colon ;
You can use the following in Oracle to replace the ";" to ","
replace('',';',',')
your SQL could be as below:
select REPLACE(EMAIL,';',')
from
in Oracle world and us that to set your e-mail separator.
Hoipe it helps.
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Zandi Patrick S TSgt AFRL/IFOS
Sent: Wednesday, June 29, 2005 1:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Email Engine Issue: Semi-Colon ;
Have not tested on that side.. Yet.. Tim.
We are still Decoding three different portions of Oracle that is
executing this..
I really needed to know if the ; issue was apparent and it someone
will
should ..
Oh yeah... That was patch blah blah.
ENV:: ARS 5.1.2 P 1389
Application has started Version: 5.01.02 patch 1313 Using JRE: 1.4.208
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Tim Widowfield
Sent: Wednesday, June 29, 2005 2:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: Email Engine Issue: Semi-Colon ;
What happens if you use workflow to convert all the semicolons to commas
before it hits the Email Engine?
--Tim
Zandi Patrick S TSgt AFRL/IFOS wrote:
> Hello,
> Found an issue on Remedy Email engine..
>
> We have set up a trigger in oracle to send remedy an Email engine
> Submit into remedy This seems to be working well.. Except..
> In the oracle procedures.. It is sending an extra ";" at the end of
> every list of addressees.
> Now normally in the exchange world it would be removed and ingnored.
> But in the SMTP world.. It is still there..
>
> So the issue is :: if the address is a Single address
> MyName@rl.af.mil; The email engine parses and it works fine..
> But if the messages come in with multiple addresses. Like
> yourname@rl.af.mil; myname@rl.af.mil; That extra Semi-colon gets
> rejected by the email server.. And sends the following error.
>
> javax.mail.internet.AddressException: Illegal semicolon, not in group
> in string ``name1@rl.af.mil;name2@rl.af.mil;'' at position 18
>
> Rejecting the incoming message..
>
> Has anyone else found this .. And is there a fix / patch for this..
> I will look over the web site here after this post..
>
> Just trying to solve as fast as possible.. Thanks.
> We are also trying to remove the Extra ; from the oracle code as well
> But it was written by someone who is gone.. Oh what fun.
> thanks
>
>
> UNSUBSCRIBE or access ARSlist Archives at
> http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
|
|
Top
|
|
|
|
|
|
|
Previous Topic
Index