Wierd Workflow Issue
List, I am having a wierd workflow issue and I am wondering if anyone else has ever had this issue. I have a filter that goes through and takes the data from a character field and pushes it to another character field and adds some HTML tags to it. The main one I am concerned with is the one where I add anytime there is a carriage return. So my set fields value looks like this: REPLACE($Comments HTML$, "", "") and it works fine. The problem I am having now is everytime the AR Server is restarted the system comes through and adds a space my set fields value so it looks like this REPLACE($Comments HTML$, " ", "") Has anyone ever seen this or know why ARS would add that extra space in the filter? This is all custom workflow. ARS 7.1 Windows 2003 -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Wierd Workflow Issue
What I typically do in my code is force the space replacement
REPLACE($Comments HTML$, LTRIM(RTRIM("
")), "")
Fred
NOTE: This does not seem to work the same when using the Developer Studio (It
seems to want to put 2 characters in instead of the single one)
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Kevin Begosh
Sent: Tuesday, January 04, 2011 12:13 PM
To: arslist@ARSLIST.ORG
Subject: Wierd Workflow Issue
**
List,
I am having a wierd workflow issue and I am wondering if anyone else has ever
had this issue. I have a filter that goes through and takes the data from a
character field and pushes it to another character field and adds some HTML
tags to it. The main one I am concerned with is the one where I add
anytime there is a carriage return. So my set fields value looks like this:
REPLACE($Comments HTML$, "", "")
and it works fine. The problem I am having now is everytime the AR Server is
restarted the system comes through and adds a space my set fields value so it
looks like this
REPLACE($Comments HTML$, " ", "")
Has anyone ever seen this or know why ARS would add that extra space in the
filter? This is all custom workflow.
ARS 7.1
Windows 2003
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Wierd Workflow Issue
Kevin, Yes I experience that EXACT issue. The problem is in the ARServer and is fixed by a patch. You didn't mention what patch you are on, but go to the latest and you will see it not being an issue anymore. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kevin Begosh Sent: Tuesday, January 04, 2011 11:13 AM To: arslist@ARSLIST.ORG Subject: Wierd Workflow Issue ** List, I am having a wierd workflow issue and I am wondering if anyone else has ever had this issue. I have a filter that goes through and takes the data from a character field and pushes it to another character field and adds some HTML tags to it. The main one I am concerned with is the one where I add anytime there is a carriage return. So my set fields value looks like this: REPLACE($Comments HTML$, "", "") and it works fine. The problem I am having now is everytime the AR Server is restarted the system comes through and adds a space my set fields value so it looks like this REPLACE($Comments HTML$, " ", "") Has anyone ever seen this or know why ARS would add that extra space in the filter? This is all custom workflow. ARS 7.1 Windows 2003 -- Kevin Begosh _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Wierd Workflow Issue
I will give this a try, I am still using the old admin tool. Thanks. Have
any idea why it would change my filter after restart of the server?
On Tue, Jan 4, 2011 at 1:23 PM, Grooms, Frederick W <
frederick.w.gro...@xo.com> wrote:
> What I typically do in my code is force the space replacement
>
> REPLACE($Comments HTML$, LTRIM(RTRIM("
> ")), "")
>
> Fred
>
> NOTE: This does not seem to work the same when using the Developer Studio
> (It seems to want to put 2 characters in instead of the single one)
>
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org] On Behalf Of Kevin Begosh
> Sent: Tuesday, January 04, 2011 12:13 PM
> To: arslist@ARSLIST.ORG
> Subject: Wierd Workflow Issue
>
> **
> List,
> I am having a wierd workflow issue and I am wondering if anyone else has
> ever had this issue. I have a filter that goes through and takes the data
> from a character field and pushes it to another character field and adds
> some HTML tags to it. The main one I am concerned with is the one where I
> add anytime there is a carriage return. So my set fields value looks
> like this:
>
> REPLACE($Comments HTML$, "", "")
>
> and it works fine. The problem I am having now is everytime the AR Server
> is restarted the system comes through and adds a space my set fields value
> so it looks like this
>
> REPLACE($Comments HTML$, " ", "")
>
> Has anyone ever seen this or know why ARS would add that extra space in the
> filter? This is all custom workflow.
>
> ARS 7.1
> Windows 2003
>
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>
--
Kevin Begosh
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Wierd Workflow Issue
Well we are on 7.1.00 patch 007 200904160530 right now. They are in the proces of upgrading to 7.5 in the next couple of weeks, so I guess I will just see how it acts after that. Thanks. On Tue, Jan 4, 2011 at 1:25 PM, LJ LongWing wrote: > ** > > Kevin, > > Yes I experience that EXACT issue. The problem is in the ARServer and is > fixed by a patch. You didn’t mention what patch you are on, but go to the > latest and you will see it not being an issue anymore. > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *Kevin Begosh > *Sent:* Tuesday, January 04, 2011 11:13 AM > > *To:* arslist@ARSLIST.ORG > *Subject:* Wierd Workflow Issue > > > > ** > > List, > > I am having a wierd workflow issue and I am wondering if anyone else has > ever had this issue. I have a filter that goes through and takes the data > from a character field and pushes it to another character field and adds > some HTML tags to it. The main one I am concerned with is the one where I > add anytime there is a carriage return. So my set fields value looks > like this: > > > > REPLACE($Comments HTML$, "", "") > > > > and it works fine. The problem I am having now is everytime the AR Server > is restarted the system comes through and adds a space my set fields value > so it looks like this > > > > REPLACE($Comments HTML$, " ", "") > > > > Has anyone ever seen this or know why ARS would add that extra space in the > filter? This is all custom workflow. > > > > ARS 7.1 > > Windows 2003 > > > > > -- > Kevin Begosh > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Wierd Workflow Issue
Kevin,
This issue pops up about once a year. It is an artifact of a workaround to a
challenge with a database.
You did not indicate what database you are using... but I can tell you that it
is either SQL Server or Sybase
(and since you did indicate you are running on Windows and we do not support
Sybase there I can say that
it is SQL Server in your case)
The issue is that SQL Server and Sybase has an odd behavior. If you have a
character string that happens to
have a backslash in it that it followed by a carriage return character, the
database will remove the two
characters from the character field. We have no clue why it does it, we just
know that it does.
Since we encode the definitions of qualificaitons and assignments and since we
use backslashes as
separator characters in that encoding and since your definition has a character
string that is a return.
What we did (way back in 1991 by the way) was to protect this scenario by
inserting a space before the
return. Good/bad/indifferent, it is the way we solved the problem. This is
99% innocuous and causes no
issue -- but in situations like the scenario you have here, it introduces an
extra character and can cause
issues.
The strategy that Fred described that includes trims resolves the problem as
the logic trims off the extra
space that is inserted for those databases (and has no issues if it is Oracle
or DB2 as the database).
Recently, logic has been introduced in the system to try and mask the issue by
BMC reversing the extra
space for those databases when we recognize the pattern. This is where people
with the latest version are
not seeing the results of the issue. Has it been resolved everywhere -- we
think so. But if there is a
miss, the trim strategy can be used as a workaround.
I hope that helps at least explain what is occurring.
Now, if we could go back 20 years and use a different workaround, would we?
Probably. But, it is what we
chose at the time to protect the definition from corruption.
Doug Mueller
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Kevin Begosh
Sent: Tuesday, January 04, 2011 10:27 AM
To: arslist@ARSLIST.ORG
Subject: Re: Wierd Workflow Issue
** I will give this a try, I am still using the old admin tool. Thanks. Have
any idea why it would change my filter after restart of the server?
On Tue, Jan 4, 2011 at 1:23 PM, Grooms, Frederick W
mailto:frederick.w.gro...@xo.com>> wrote:
What I typically do in my code is force the space replacement
REPLACE($Comments HTML$, LTRIM(RTRIM("
")), "")
Fred
NOTE: This does not seem to work the same when using the Developer Studio (It
seems to want to put 2 characters in instead of the single one)
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Kevin
Begosh
Sent: Tuesday, January 04, 2011 12:13 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Wierd Workflow Issue
**
List,
I am having a wierd workflow issue and I am wondering if anyone else has ever
had this issue. I have a filter that goes through and takes the data from a
character field and pushes it to another character field and adds some HTML
tags to it. The main one I am concerned with is the one where I add
anytime there is a carriage return. So my set fields value looks like this:
REPLACE($Comments HTML$, "", "")
and it works fine. The problem I am having now is everytime the AR Server is
restarted the system comes through and adds a space my set fields value so it
looks like this
REPLACE($Comments HTML$, " ", "")
Has anyone ever seen this or know why ARS would add that extra space in the
filter? This is all custom workflow.
ARS 7.1
Windows 2003
___
UNSUBSCRIBE or access ARSlist Archives at
www.arslist.org<http://www.arslist.org/>
attend wwrug11 www.wwrug.com<http://www.wwrug.com/> ARSList: "Where the Answers
Are"
--
Kevin Begosh
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Wierd Workflow Issue
Doug,
thanks for taking the time to answer my question/issue. We are in fact
using SQL 2005 here. I am going to try the trim to see if that works. This
is all good and very useful information.
Thanks,
Kevin Begosh
On Thu, Jan 6, 2011 at 1:59 AM, Mueller, Doug wrote:
> **
> Kevin,
>
> This issue pops up about once a year. It is an artifact of a workaround to
> a challenge with a database.
>
> You did not indicate what database you are using... but I can tell you that
> it is either SQL Server or Sybase
> (and since you did indicate you are running on Windows and we do not
> support Sybase there I can say that
> it is SQL Server in your case)
>
> The issue is that SQL Server and Sybase has an odd behavior. If you have a
> character string that happens to
> have a backslash in it that it followed by a carriage return character, the
> database will remove the two
> characters from the character field. We have no clue why it does it, we
> just know that it does.
>
> Since we encode the definitions of qualificaitons and assignments and since
> we use backslashes as
> separator characters in that encoding and since your definition has a
> character string that is a return.
>
> What we did (way back in 1991 by the way) was to protect this scenario by
> inserting a space before the
> return. Good/bad/indifferent, it is the way we solved the problem. This
> is 99% innocuous and causes no
> issue -- but in situations like the scenario you have here, it introduces
> an extra character and can cause
> issues.
>
> The strategy that Fred described that includes trims resolves the problem
> as the logic trims off the extra
> space that is inserted for those databases (and has no issues if it is
> Oracle or DB2 as the database).
>
> Recently, logic has been introduced in the system to try and mask the issue
> by BMC reversing the extra
> space for those databases when we recognize the pattern. This is where
> people with the latest version are
> not seeing the results of the issue. Has it been resolved everywhere -- we
> think so. But if there is a
> miss, the trim strategy can be used as a workaround.
>
> I hope that helps at least explain what is occurring.
>
> Now, if we could go back 20 years and use a different workaround, would
> we? Probably. But, it is what we
> chose at the time to protect the definition from corruption.
>
> Doug Mueller
>
> --
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org] *On Behalf Of *Kevin Begosh
> *Sent:* Tuesday, January 04, 2011 10:27 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Wierd Workflow Issue
>
> ** I will give this a try, I am still using the old admin tool. Thanks.
> Have any idea why it would change my filter after restart of the server?
>
>
> On Tue, Jan 4, 2011 at 1:23 PM, Grooms, Frederick W <
> frederick.w.gro...@xo.com> wrote:
>
>> What I typically do in my code is force the space replacement
>>
>> REPLACE($Comments HTML$, LTRIM(RTRIM("
>> ")), "")
>>
>> Fred
>>
>> NOTE: This does not seem to work the same when using the Developer Studio
>> (It seems to want to put 2 characters in instead of the single one)
>>
>>
>>
>> -Original Message-
>> From: Action Request System discussion list(ARSList) [mailto:
>> arsl...@arslist.org] On Behalf Of Kevin Begosh
>> Sent: Tuesday, January 04, 2011 12:13 PM
>> To: arslist@ARSLIST.ORG
>> Subject: Wierd Workflow Issue
>>
>> **
>> List,
>> I am having a wierd workflow issue and I am wondering if anyone else has
>> ever had this issue. I have a filter that goes through and takes the data
>> from a character field and pushes it to another character field and adds
>> some HTML tags to it. The main one I am concerned with is the one where I
>> add anytime there is a carriage return. So my set fields value looks
>> like this:
>>
>> REPLACE($Comments HTML$, "", "")
>>
>> and it works fine. The problem I am having now is everytime the AR Server
>> is restarted the system comes through and adds a space my set fields value
>> so it looks like this
>>
>> REPLACE($Comments HTML$, " ", "")
>>
>> Has anyone ever seen this or know why ARS would add that extra space in
>> the filter? This is all custom workflow.
>>
>> ARS 7.1
>> Windows 2003
>>
>>
>>
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>
>
>
>
> --
> Kevin Begosh
> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
>
--
Kevin Begosh
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
