Re: Mid-Tier 7.5 Problems
We see these errors on 5.5.20 Tomcat (Solaris 9) on QST. A full restart of Tomcat was required. I haven't seen these errors on Development with Tomcat 6.0.28 (Solaris 9) --Chuck On Tue, Jul 27, 2010 at 10:42 AM, Axton wrote: > ** Unfortunately, bypassing Apache altogether is not an option as our SSO > authentication is handled through an Apache plug-in. > > Axton Grams > > The opinions, statements, and/or suggested courses of action expressed in > this E-mail do not necessarily reflect those of BMC Software, Inc. My > voluntary participation in this forum is not intended to convey a role as a > spokesperson, liaison or public relations representative for BMC Software, > Inc. > On Tue, Jul 27, 2010 at 9:44 AM, LJ LongWing wrote: > >> ** >> >> Axton, >> >> Our configs are surprisingly similar….we are using the WebLogic server as >> both Web and JSP at this point…we don’t seem to be having issues with the >> WebLogic with no Proxy in place…nor do we seem to have issues when using the >> Tomcat that comes with 7.5 (5.5.28)…so I suggest trying to bypass Apache all >> together and see if that eliminates your issue…just a thought. >> >> >> >> Mid Tier Version >> >> 7.5.00 Patch 005 201005111542 >> >> Installation Directory >> >> /app/bmc/midtier >> >> Web Server Information >> >> WebLogic Server 10.3.2.0 Tue Oct 20 12:16:15 PDT 2009 1267925 Oracle >> WebLogic Server Module Dependencies 10.3 Tue Oct 20 13:57:01 EDT 2009 >> >> Operating System Name >> >> SunOS >> >> Java Version >> >> 1.6.0_18 >> >> >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arsl...@arslist.org] *On Behalf Of *Axton >> *Sent:* Monday, July 26, 2010 8:36 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: Mid-Tier 7.5 Problems >> >> >> >> ** That's the same situation I am in. Getting logs is troublesome, at >> best. Reproducing the errors seems to be a draw of the hat (maybe 1 in 30 >> chance), so we too are having a near impossible time getting logs of the >> errors. The errors seem to persist with a given session; meaning that I can >> consistently reproduce the errors with a given set of actions when I get a >> bad session, but as soon as I log out and log back in, the errors stop in >> that given scenario. It's as if something associated with the session >> becomes corrupted; it doesn't seem to be anything that is cached on the >> client side, as clearing the cache while the error happens does not resolve >> the issue for that session; but creating a new session does. >> >> >> >> What version of Java were you using when you ran into the issues. We are >> using the following: >> >> >> >> Tomcat 6.0.20 >> >> Sun Java 1.6.0_17 >> >> Apache 2.0.63 >> >> mod_jk 1.2.28 (we were using 1.2.30, but had more problems with that >> version) >> >> Solaris 9 >> >> Mid-Tier 7.5 patch 4 >> >> >> >> We are getting ready to try mod_proxy instead of mod_jk to see if this >> resolves the issues. >> >> >> >> We are seeing the errors most around actions that pull table results as >> well. >> >> >> >> Let me know if your issues stop after your move to WebLogic. >> >> >> >> Axton >> >> >> >> The opinions, statements, and/or suggested courses of action expressed in >> this E-mail do not necessarily reflect those of BMC Software, Inc. My >> voluntary participation in this forum is not intended to convey a role as a >> spokesperson, liaison or public relations representative for BMC Software, >> Inc. >> >> >> >> >> >> On Mon, Jul 26, 2010 at 5:01 PM, LJ LongWing >> wrote: >> >> ** >> >> Axton, >> >> We are seeing lots of ‘Caught Exception’ errors….we have been struggling >> to get them fixed even with vendor support…I have also received a single ‘if >> you are on SSO’ report, but only one. >> >> >> >> I haven’t investigated the SSO error because I have only gotten it once >> >> >> >> The ‘Caught Exception’ errors….we are switching from Tomcat to WebLogic >> servers, and upgrading from one version of a SunOne proxy server to >> another….too many changes to be able to track which one is the cause…we have >> found that the problem doesn’t seem to exist when hitting the web servers >> directly/bypassing the proxy….we have been able to narrow it down to what >> seems to be URL length issues making backchannel calls. This seems to >> happen most often when workflow is doing a refresh of a table field, but not >> able to get it to happen consistently enough to get good logs to send to >> BMC…. >> >> >> >> Let me know if any of this is helpful/if you have anything to add to help >> us fix… >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arsl...@arslist.org] *On Behalf Of *Axton >> *Sent:* Monday, July 26, 2010 3:24 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Mid-Tier 7.5 Problems >> >> >> >> ** Wanted to see if anyone out there is having these types of issues with >> Mid-Tier 7.5 patch 4 or higher: >> >> - blank page when accessing a form >> >> - page stops loading at the animated gif (loading) >> >>
MT 7.1 and AR Server 7.0
Is it OK to Run MidTier version 7.1 against an AR System 7.0 server? Want to know if anyone has experienced any issues with this configuration. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Escalation refuses to run
Copy this escalation to a new escalation and rename it without the underscore _, disable the original. On Tue, May 25, 2010 at 9:52 AM, William Rentfrow < wrentf...@stratacominc.com> wrote: > ** > I'm baffled. Tech support at BMC seems baffled as well. > > The OOB escalation for SLM is named > SLM:EventSchedule:TAD_PollingEscalation. It has not been modified at all > except for the thread/pool changes noted below. It is an interval > escalation set to 5 minutes. > > It refuses to fire however. There is simply no mention of it in the logs. > Ever. > > We'd added a dedicated thread - in fact, we have 6 escalations > threads/pools. #6 is dedicated solely for this escalation - nothing else is > on it. > > Escalation logging shows all the other escalations working correctly. But > for some reason Pool 6 is never mentioned in the logs and the escalation > named above is nevere mentioned. There is no message saying the escalation > is disabled - there's nothing saying it is computing the next fire time - it > is literally as if this escalation doesn't exist as far as the server is > concerned. > > Suggestions? So far we have... > > -bounced the server. Repeatedly. > -thread level logging > -every other kind of logging imaginable > -restricted pool to this single escalation > -verified pool configuration, etc > -verified server licensing, etc. > > William Rentfrow > Principal Consultant, StrataCom Inc. > wrentf...@stratacominc.com > Corporate Website, www.stratacominc.com > Blog, www.williamrentfrow.com > 715-410-8156 C > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: RKM/Tomcat Issue
The only thing I can think of is that its interpreting the \u as and escape character. I am not too familiar with RKM , can you use forward slashes / instead? On Tue, May 25, 2010 at 10:20 AM, Kevin Begosh wrote: > ** > So I found another RKM/Tomcat issue when working in a decision tree > template. I have a couple of nested trees and when I put the in following > link the decision tree does not work > > *\t45share\helpdesk\utest* > but when I take out the u it works > > *\t45share\helpdesk\test* > ** > ** > This link is about 4 decision trees down. with the "u" in there the > decision tree does not display. When I modify the article and take the "u" > out it works fine. > > Any ideas? > > RKM 7.2 Patch 4 > ARS 7.5 > Tomcat 5.5.20 > > -- > Kevin Begosh > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: User gets a blank screen while accessing Atrium Core Console 7.6 through Mid-Tier 7.5 patch4
Upgrade to Patch5 if you can. On Mon, May 24, 2010 at 12:43 PM, Bilinski, John CTR WHS/ITMD/ASD < john.bilinski@whs.mil> wrote: > ** > > Listers: > > I am receiving a Blank (or grey) screen when trying to access the Atrium > CMDB Console v7.6p1 through Mid-Tier patch 4? > > The problem seems to be with the Data Visualizations field not loading > properly. When I try to access the console through the User tool it > completely freezes my User Tool. > > I found a KB on the BMC Knowledge Base article ‘20014080‘ but none of the > troubleshooting helped me to resolve the issue. > > I ran into this issue a few months back in my QA environment installation > and a re-install of Mid-Tier solved the problem BUT I am in my production > environment and re-installing is a last resort for I have SSL and a 3rdParty > CAC SSO integration(which took signifgant timeto get working) > installed which may cause me more issues after the re-install. > > Does anyone know what cause is at the root of this issue and can offer any > suggestions for me to fix without having to re-install Mid-Tier? > > Thanks. > > John Bilinski > > WHS Remedy Developer > > Contractor (ASD) > > Pentagon 5A936 > > Office: 703.571.2057 > > ITIL v3 Foundation Certified > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Benefit of Prefetch Remedy midtier 7.1
You are right, no way that the midTier stores prefetch items on the client computer. Unless you acknowledged security bypass for your browser Prefetch runs as an assumed user login. So if you setup Prefetch as Joe User, all the views, code, and fields that Joe User sees will load as prefetched. If Jane logs in and she has the same permissions as Joe, then boom she gets the form without extra processing and the form opens fast for her. OH but here comes FRED; he has more permissions, he is a supervisor, 20% more fields and workflow are available to him, so guess what, when he logs in, midTier has to fetch all the field defs and workflow for FRED, so he might see a slightly slower form load the First time only, regardles of prefetch. IF you wanted FRED's form to open fast you need to define another prefetch for a user with FREDS permission set. ---:)--- cpg...@gmail.com On Wed, Apr 14, 2010 at 8:44 AM, remedy lee wrote: > Hi, > > I'm confused on this prefetch 'feature' in midtier. > The way I read it is that only when a server is restarted will the > forms (on the web server) reload in order to save time when the first > user logs in. > So instead of loading HPD:Help Desk when a user first hits it, it will > load by itself when restarted. > Benefit is that the first user logging in won't get that 1-2 mins > loading wait. > > Now sales people and certain consultants say that prefetch does more > than that. > It actually loads the forms into the clients computer and therefore > speeds up the whole midtier itself. > So they say that prefetch helps overall everyday midtier use such as > the 50th person using HPD:Help Desk will notice better speeds with > prefetch than without. > They say it loads the forms to the clients computers preemptively and > therefore improves performance. > To me that doesn't make sense, how can the server know where to load > the files. Does it work by loading all the web forms when the person > logs in? > > I really see no benefit to using prefetch if our server hardly restarts > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: ARX Files from MidTier
Have you tried using a different browser?
On Wed, Apr 14, 2010 at 10:39 AM, Joe D'Souza wrote:
> **
> Lisa,
>
> I highly doubt there is a limit like that.. Check your web server log files
> to see if there is a web server level error that was reported at that time.
> I'm inclined to think you might have encountered a out of memory error on
> the web server that may have resulted in that. In which case adjusting your
> heap size might be in order..
>
> Cheers
>
> Joe
>
> -Original Message-
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org]*on Behalf Of *Kemes, Lisa
> *Sent:* Monday, April 12, 2010 12:21 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* ARX Files from MidTier
>
> **
> Is there a limit to how many columns or characters you can save to an arx
> file from the MidTier? Looks like we are starting to get errors ("Failed to
> Perform Action") when we add more than 213 columns. The Client is fine and
> can handle much more than this….
>
> ARS 7.1 p7
> AR Midtier 7.5 p2
> Windows 2003
>
> *Lisa Kemes** *
> AR System Developer
> Tyco Electronics
> 717-810-2408 tel
> 717-810-2124 fax
> lisa.ke...@tycoelectronics.com
>
> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
>
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Extracting digits from a character field
You see a view field can run javascript and send events back to the parent,
whether web or user.
in this case you use the javascript REGEXP.
On Thu, Apr 15, 2010 at 5:40 PM, cpgold wrote:
> Its what I use to dynamicall format phone numbers on the fly.
>
>
> On Thu, Apr 15, 2010 at 5:39 PM, cpgold wrote:
>
>> If it is an active link, I have a View field javascript event solution...
>>
>>
>> On Thu, Apr 15, 2010 at 5:39 PM, cpgold wrote:
>>
>>> Does it have to be a filter, an active link is much better suited for
>>> this type of processing than to let the server handle it.
>>>
>>>
>>> On Wed, Apr 14, 2010 at 1:58 PM, Joe D'Souza wrote:
>>>
>>>> I do not have access to an Oracle instance at the moment to try it, but
>>>> I'm
>>>> quite sure that
>>>>
>>>> update tablename set columnname = REPLACE('Does work', 'Does ', NULL);
>>>> commit;
>>>>
>>>> would update the column to 'work'. Which is ideally what you would want
>>>> it
>>>> to..
>>>>
>>>> With MS-SQL it sets the column to NULL.
>>>>
>>>> Joe
>>>>
>>>> -Original Message-
>>>> From: Action Request System discussion list(ARSList)
>>>> [mailto:arsl...@arslist.org]on Behalf Of Jim Fox
>>>> Sent: Wednesday, April 14, 2010 2:03 PM
>>>> To: arslist@ARSLIST.ORG
>>>> Subject: Re: Extracting digits from a character field
>>>>
>>>>
>>>> You mean works incorrectly. LOL.
>>>>
>>>> F
>>>> Sent from my Verizon Wireless BlackBerry
>>>>
>>>> -Original Message-
>>>> From: Joe D'Souza
>>>> Date: Wed, 14 Apr 2010 13:25:31
>>>> To:
>>>> Subject: Re: Extracting digits from a character field
>>>>
>>>> You are right, I just tried and it sets the whole column to NULL instead
>>>> of
>>>> just replacing the specific characters in expression 2 to NULL.. It
>>>> works
>>>> correctly in Oracle to the best of my knowledge..
>>>>
>>>> Joe
>>>>
>>>> -Original Message-
>>>> From: Action Request System discussion list(ARSList)
>>>> [mailto:arsl...@arslist.org]on Behalf Of Jim Fox
>>>> Sent: Wednesday, April 14, 2010 1:00 PM
>>>> To: arslist@ARSLIST.ORG
>>>> Subject: Re: Extracting digits from a character field
>>>>
>>>>
>>>> Replaciing a character with Null is an oxymoron in MS-SQL. You would
>>>> replace
>>>> a character with a zero-length string. Null and "" are not the same.
>>>>
>>>> Fluxman
>>>> Sent from my Verizon Wireless BlackBerry
>>>>
>>>> -Original Message-
>>>> From: Joe D'Souza
>>>> Date: Wed, 14 Apr 2010 11:42:21
>>>> To:
>>>> Subject: Re: Extracting digits from a character field
>>>>
>>>> Jim,
>>>>
>>>> Just curious.. What are the limitations that you encountered replacing a
>>>> character or a string with NULL on MS-SQL.. And what version of MS-SQL??
>>>>
>>>> Joe
>>>>
>>>> -Original Message-
>>>> From: Action Request System discussion list(ARSList)
>>>> [mailto:arsl...@arslist.org]on Behalf Of Jim Fox
>>>> Sent: Wednesday, April 14, 2010 11:12 AM
>>>> To: arslist@ARSLIST.ORG
>>>> Subject: Re: Extracting digits from a character field
>>>>
>>>>
>>>> On MS-SQL, trying to replace one character with Null is not a good idea.
>>>>
>>>> Fluxman
>>>> --Original Message--
>>>> From: Joe D'Souza
>>>> Sender: Action Request System discussion list(ARSList)
>>>> To: arslist@ARSLIST.ORG
>>>> ReplyTo: arslist@ARSLIST.ORG
>>>> Sent: Apr 14, 2010 11:07
>>>> Subject: Re: Extracting digits from a character field
>>>>
>>>> If you are in an Oracle database, use the function TRANSLATE to replace
>>>> all
>>>> Alpha characters with either NULL or space or whatever else you wish
>>>> to..
>>>> This will leave the string with only special characters and numerical
>>>> characters..
>>>>
>>>> I am not sure if TRANSLATE works on MS-SQL but you could give it a shot
>>>> if
>>>> MS-SQL is your underlying database.
>>>>
>>>> Joe
>>>>
>>>> -Original Message-
>>>> From: Action Request System discussion list(ARSList)
>>>> [mailto:arsl...@arslist.org]on Behalf Of Atul Vohra
>>>> Sent: Wednesday, April 14, 2010 9:42 AM
>>>> To: arslist@ARSLIST.ORG
>>>> Subject: Extracting digits from a character field
>>>>
>>>>
>>>> I have a free form character field and need to extract digits from that
>>>> field - may be in a filter? Am on v7.1, oracle.
>>>>
>>>> Any one has some function they used (like in sql or may be combination
>>>> of
>>>> strstr??) Looks painful to me.
>>>>
>>>> Help please
>>>>
>>>> Atul
>>>>
>>>>
>>>> ___
>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>>> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>>>>
>>>
>>>
>>
>
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Extracting digits from a character field
Its what I use to dynamicall format phone numbers on the fly.
On Thu, Apr 15, 2010 at 5:39 PM, cpgold wrote:
> If it is an active link, I have a View field javascript event solution...
>
>
> On Thu, Apr 15, 2010 at 5:39 PM, cpgold wrote:
>
>> Does it have to be a filter, an active link is much better suited for this
>> type of processing than to let the server handle it.
>>
>>
>> On Wed, Apr 14, 2010 at 1:58 PM, Joe D'Souza wrote:
>>
>>> I do not have access to an Oracle instance at the moment to try it, but
>>> I'm
>>> quite sure that
>>>
>>> update tablename set columnname = REPLACE('Does work', 'Does ', NULL);
>>> commit;
>>>
>>> would update the column to 'work'. Which is ideally what you would want
>>> it
>>> to..
>>>
>>> With MS-SQL it sets the column to NULL.
>>>
>>> Joe
>>>
>>> -Original Message-
>>> From: Action Request System discussion list(ARSList)
>>> [mailto:arsl...@arslist.org]on Behalf Of Jim Fox
>>> Sent: Wednesday, April 14, 2010 2:03 PM
>>> To: arslist@ARSLIST.ORG
>>> Subject: Re: Extracting digits from a character field
>>>
>>>
>>> You mean works incorrectly. LOL.
>>>
>>> F
>>> Sent from my Verizon Wireless BlackBerry
>>>
>>> -Original Message-
>>> From: Joe D'Souza
>>> Date: Wed, 14 Apr 2010 13:25:31
>>> To:
>>> Subject: Re: Extracting digits from a character field
>>>
>>> You are right, I just tried and it sets the whole column to NULL instead
>>> of
>>> just replacing the specific characters in expression 2 to NULL.. It works
>>> correctly in Oracle to the best of my knowledge..
>>>
>>> Joe
>>>
>>> -Original Message-
>>> From: Action Request System discussion list(ARSList)
>>> [mailto:arsl...@arslist.org]on Behalf Of Jim Fox
>>> Sent: Wednesday, April 14, 2010 1:00 PM
>>> To: arslist@ARSLIST.ORG
>>> Subject: Re: Extracting digits from a character field
>>>
>>>
>>> Replaciing a character with Null is an oxymoron in MS-SQL. You would
>>> replace
>>> a character with a zero-length string. Null and "" are not the same.
>>>
>>> Fluxman
>>> Sent from my Verizon Wireless BlackBerry
>>>
>>> -Original Message-
>>> From: Joe D'Souza
>>> Date: Wed, 14 Apr 2010 11:42:21
>>> To:
>>> Subject: Re: Extracting digits from a character field
>>>
>>> Jim,
>>>
>>> Just curious.. What are the limitations that you encountered replacing a
>>> character or a string with NULL on MS-SQL.. And what version of MS-SQL??
>>>
>>> Joe
>>>
>>> -Original Message-
>>> From: Action Request System discussion list(ARSList)
>>> [mailto:arsl...@arslist.org]on Behalf Of Jim Fox
>>> Sent: Wednesday, April 14, 2010 11:12 AM
>>> To: arslist@ARSLIST.ORG
>>> Subject: Re: Extracting digits from a character field
>>>
>>>
>>> On MS-SQL, trying to replace one character with Null is not a good idea.
>>>
>>> Fluxman
>>> --Original Message--
>>> From: Joe D'Souza
>>> Sender: Action Request System discussion list(ARSList)
>>> To: arslist@ARSLIST.ORG
>>> ReplyTo: arslist@ARSLIST.ORG
>>> Sent: Apr 14, 2010 11:07
>>> Subject: Re: Extracting digits from a character field
>>>
>>> If you are in an Oracle database, use the function TRANSLATE to replace
>>> all
>>> Alpha characters with either NULL or space or whatever else you wish to..
>>> This will leave the string with only special characters and numerical
>>> characters..
>>>
>>> I am not sure if TRANSLATE works on MS-SQL but you could give it a shot
>>> if
>>> MS-SQL is your underlying database.
>>>
>>> Joe
>>>
>>> -Original Message-
>>> From: Action Request System discussion list(ARSList)
>>> [mailto:arsl...@arslist.org]on Behalf Of Atul Vohra
>>> Sent: Wednesday, April 14, 2010 9:42 AM
>>> To: arslist@ARSLIST.ORG
>>> Subject: Extracting digits from a character field
>>>
>>>
>>> I have a free form character field and need to extract digits from that
>>> field - may be in a filter? Am on v7.1, oracle.
>>>
>>> Any one has some function they used (like in sql or may be combination of
>>> strstr??) Looks painful to me.
>>>
>>> Help please
>>>
>>> Atul
>>>
>>>
>>> ___
>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>>>
>>
>>
>
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Extracting digits from a character field
If it is an active link, I have a View field javascript event solution...
On Thu, Apr 15, 2010 at 5:39 PM, cpgold wrote:
> Does it have to be a filter, an active link is much better suited for this
> type of processing than to let the server handle it.
>
>
> On Wed, Apr 14, 2010 at 1:58 PM, Joe D'Souza wrote:
>
>> I do not have access to an Oracle instance at the moment to try it, but
>> I'm
>> quite sure that
>>
>> update tablename set columnname = REPLACE('Does work', 'Does ', NULL);
>> commit;
>>
>> would update the column to 'work'. Which is ideally what you would want it
>> to..
>>
>> With MS-SQL it sets the column to NULL.
>>
>> Joe
>>
>> -Original Message-
>> From: Action Request System discussion list(ARSList)
>> [mailto:arsl...@arslist.org]on Behalf Of Jim Fox
>> Sent: Wednesday, April 14, 2010 2:03 PM
>> To: arslist@ARSLIST.ORG
>> Subject: Re: Extracting digits from a character field
>>
>>
>> You mean works incorrectly. LOL.
>>
>> F
>> Sent from my Verizon Wireless BlackBerry
>>
>> -Original Message-
>> From: Joe D'Souza
>> Date: Wed, 14 Apr 2010 13:25:31
>> To:
>> Subject: Re: Extracting digits from a character field
>>
>> You are right, I just tried and it sets the whole column to NULL instead
>> of
>> just replacing the specific characters in expression 2 to NULL.. It works
>> correctly in Oracle to the best of my knowledge..
>>
>> Joe
>>
>> -Original Message-
>> From: Action Request System discussion list(ARSList)
>> [mailto:arsl...@arslist.org]on Behalf Of Jim Fox
>> Sent: Wednesday, April 14, 2010 1:00 PM
>> To: arslist@ARSLIST.ORG
>> Subject: Re: Extracting digits from a character field
>>
>>
>> Replaciing a character with Null is an oxymoron in MS-SQL. You would
>> replace
>> a character with a zero-length string. Null and "" are not the same.
>>
>> Fluxman
>> Sent from my Verizon Wireless BlackBerry
>>
>> -Original Message-
>> From: Joe D'Souza
>> Date: Wed, 14 Apr 2010 11:42:21
>> To:
>> Subject: Re: Extracting digits from a character field
>>
>> Jim,
>>
>> Just curious.. What are the limitations that you encountered replacing a
>> character or a string with NULL on MS-SQL.. And what version of MS-SQL??
>>
>> Joe
>>
>> -Original Message-
>> From: Action Request System discussion list(ARSList)
>> [mailto:arsl...@arslist.org]on Behalf Of Jim Fox
>> Sent: Wednesday, April 14, 2010 11:12 AM
>> To: arslist@ARSLIST.ORG
>> Subject: Re: Extracting digits from a character field
>>
>>
>> On MS-SQL, trying to replace one character with Null is not a good idea.
>>
>> Fluxman
>> --Original Message--
>> From: Joe D'Souza
>> Sender: Action Request System discussion list(ARSList)
>> To: arslist@ARSLIST.ORG
>> ReplyTo: arslist@ARSLIST.ORG
>> Sent: Apr 14, 2010 11:07
>> Subject: Re: Extracting digits from a character field
>>
>> If you are in an Oracle database, use the function TRANSLATE to replace
>> all
>> Alpha characters with either NULL or space or whatever else you wish to..
>> This will leave the string with only special characters and numerical
>> characters..
>>
>> I am not sure if TRANSLATE works on MS-SQL but you could give it a shot if
>> MS-SQL is your underlying database.
>>
>> Joe
>>
>> -Original Message-
>> From: Action Request System discussion list(ARSList)
>> [mailto:arsl...@arslist.org]on Behalf Of Atul Vohra
>> Sent: Wednesday, April 14, 2010 9:42 AM
>> To: arslist@ARSLIST.ORG
>> Subject: Extracting digits from a character field
>>
>>
>> I have a free form character field and need to extract digits from that
>> field - may be in a filter? Am on v7.1, oracle.
>>
>> Any one has some function they used (like in sql or may be combination of
>> strstr??) Looks painful to me.
>>
>> Help please
>>
>> Atul
>>
>>
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>>
>
>
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Extracting digits from a character field
Does it have to be a filter, an active link is much better suited for this
type of processing than to let the server handle it.
On Wed, Apr 14, 2010 at 1:58 PM, Joe D'Souza wrote:
> I do not have access to an Oracle instance at the moment to try it, but I'm
> quite sure that
>
> update tablename set columnname = REPLACE('Does work', 'Does ', NULL);
> commit;
>
> would update the column to 'work'. Which is ideally what you would want it
> to..
>
> With MS-SQL it sets the column to NULL.
>
> Joe
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org]on Behalf Of Jim Fox
> Sent: Wednesday, April 14, 2010 2:03 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Extracting digits from a character field
>
>
> You mean works incorrectly. LOL.
>
> F
> Sent from my Verizon Wireless BlackBerry
>
> -Original Message-
> From: Joe D'Souza
> Date: Wed, 14 Apr 2010 13:25:31
> To:
> Subject: Re: Extracting digits from a character field
>
> You are right, I just tried and it sets the whole column to NULL instead of
> just replacing the specific characters in expression 2 to NULL.. It works
> correctly in Oracle to the best of my knowledge..
>
> Joe
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org]on Behalf Of Jim Fox
> Sent: Wednesday, April 14, 2010 1:00 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Extracting digits from a character field
>
>
> Replaciing a character with Null is an oxymoron in MS-SQL. You would
> replace
> a character with a zero-length string. Null and "" are not the same.
>
> Fluxman
> Sent from my Verizon Wireless BlackBerry
>
> -Original Message-
> From: Joe D'Souza
> Date: Wed, 14 Apr 2010 11:42:21
> To:
> Subject: Re: Extracting digits from a character field
>
> Jim,
>
> Just curious.. What are the limitations that you encountered replacing a
> character or a string with NULL on MS-SQL.. And what version of MS-SQL??
>
> Joe
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org]on Behalf Of Jim Fox
> Sent: Wednesday, April 14, 2010 11:12 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Extracting digits from a character field
>
>
> On MS-SQL, trying to replace one character with Null is not a good idea.
>
> Fluxman
> --Original Message--
> From: Joe D'Souza
> Sender: Action Request System discussion list(ARSList)
> To: arslist@ARSLIST.ORG
> ReplyTo: arslist@ARSLIST.ORG
> Sent: Apr 14, 2010 11:07
> Subject: Re: Extracting digits from a character field
>
> If you are in an Oracle database, use the function TRANSLATE to replace all
> Alpha characters with either NULL or space or whatever else you wish to..
> This will leave the string with only special characters and numerical
> characters..
>
> I am not sure if TRANSLATE works on MS-SQL but you could give it a shot if
> MS-SQL is your underlying database.
>
> Joe
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org]on Behalf Of Atul Vohra
> Sent: Wednesday, April 14, 2010 9:42 AM
> To: arslist@ARSLIST.ORG
> Subject: Extracting digits from a character field
>
>
> I have a free form character field and need to extract digits from that
> field - may be in a filter? Am on v7.1, oracle.
>
> Any one has some function they used (like in sql or may be combination of
> strstr??) Looks painful to me.
>
> Help please
>
> Atul
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Incoming mail message error
BASE64DecoderStream is used for attachments, maybe an attachment you are sending is corrupt? On Thu, Apr 15, 2010 at 7:36 AM, Rogerio Aguiar wrote: > ** > > Hi all, > > We are getting an error when receiving incoming mail messages: > > Error in encoded stream: needed at least 2 valid base64 characters, but > only got 1 before padding character (=), the 10 most recent characters were: > "et/ctt?kn=" > > java.io.IOException: Error in encoded stream: needed at least 2 valid > base64 characters, but only got 1 before padding character (=), the 10 most > recent characters were: "et/ctt?kn=" > > at > com.sun.mail.util.BASE64DecoderStream.decode(BASE64DecoderStream.java:246) > > at com.sun.mail.util.BASE64DecoderStream.read(BASE64DecoderStream.java:135) > > at java.io.FilterInputStream.read(FilterInputStream.java:90) > > at > com.bmc.arsys.emaildaemon.ReceiverModule.writeToTempFile(ReceiverModule.java:1395) > > at > com.bmc.arsys.emaildaemon.ReceiverModule.createAttachmentEntry(ReceiverModule.java:1479) > > at > com.bmc.arsys.emaildaemon.ReceiverModule.logMessage(ReceiverModule.java:859) > > at com.bmc.arsys.emaildaemon.ReceiverModule.doWork(ReceiverModule.java:312) > > at com.bmc.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:288) > > at java.lang.Thread.run(Thread.java:595) > > > > Only a few messages are presenting this problem. Does anyone knows what is > going on? > > > Enviroment: 7.1.00 Patch 004 > > > Thanks and Regards > > Rogerio > > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: TR vs DB sanity check please
Now if you only want to fire on a change in value not when a value goes from Null to being filled in then its 'AssignedToTech' != 'DB.AssignedToTech' AND 'DB.AssignedToTech' != $NULL$ On Thu, Apr 15, 2010 at 5:26 PM, cpgold wrote: > NOTE Listers: > > 'AssignedToTech' != 'DB.AssignedToTech' > is equal to > 'TR.AssignedToTech' != 'DB.AssignedToTech' and 'TR.AssignedToTech' != > $NULL$ > > this qual > 'AssignedToTech' != 'DB.AssignedToTech' AND 'TR.AssignedToTech' != $NULL$ > is redundant. > > > On Thu, Apr 15, 2010 at 12:02 PM, Tanner, Doug < > doug.tan...@compass-usa.com> wrote: > >> Foolproof method (assuming the field is NOT required at the database >> level) >> >> 'AssignedToTech' != 'DB.AssignedToTech' AND 'TR.AssignedToTech' != $NULL$ >> >> >> -Original Message- >> From: Action Request System discussion list(ARSList) [mailto: >> arsl...@arslist.org] On Behalf Of Brien Dieterle >> Sent: Thursday, April 15, 2010 12:50 PM >> To: arslist@ARSLIST.ORG >> Subject: Re: TR vs DB sanity check please >> >> Maybe add an >> >> AND 'TR.AssignedToTech' != $NULL$ >> >> Brien >> >> On 4/15/2010 9:28 AM, Drew Shuller wrote: >> > I typed the email wrong. >> > >> > I've tried the Run If as both 'TR.AssignedToTech' != 'DB.AssignedToTech' >> > and without the TR in the first instance. >> > >> > I'm running a Notify action. I do get inconsistent results. >> > >> > Drew >> > >> > >> ___ >> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" >> > >> > >> >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" >> >> >> DISCLAIMER Important! This message is intended for the above named >> person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the >> intended recipient of this e-mail and have received it in error, please >> immediately notify the sender by return email and then delete it from your >> mailbox. This message may be protected by the attorney-client privilege >> and/or work product doctrine. Accessing, copying, disseminating or re-using >> any of the information contained in this e-mail by anyone other than the >> intended recipient is strictly prohibited. Finally, you should check this >> email and any attachments for the presence of viruses, as the sender accepts >> no liability for any damage caused by any virus transmitted by this email. >> Thank you. >> >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" >> > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: TR vs DB sanity check please
NOTE Listers: 'AssignedToTech' != 'DB.AssignedToTech' is equal to 'TR.AssignedToTech' != 'DB.AssignedToTech' and 'TR.AssignedToTech' != $NULL$ this qual 'AssignedToTech' != 'DB.AssignedToTech' AND 'TR.AssignedToTech' != $NULL$ is redundant. On Thu, Apr 15, 2010 at 12:02 PM, Tanner, Doug wrote: > Foolproof method (assuming the field is NOT required at the database level) > > 'AssignedToTech' != 'DB.AssignedToTech' AND 'TR.AssignedToTech' != $NULL$ > > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] On Behalf Of Brien Dieterle > Sent: Thursday, April 15, 2010 12:50 PM > To: arslist@ARSLIST.ORG > Subject: Re: TR vs DB sanity check please > > Maybe add an > > AND 'TR.AssignedToTech' != $NULL$ > > Brien > > On 4/15/2010 9:28 AM, Drew Shuller wrote: > > I typed the email wrong. > > > > I've tried the Run If as both 'TR.AssignedToTech' != 'DB.AssignedToTech' > > and without the TR in the first instance. > > > > I'm running a Notify action. I do get inconsistent results. > > > > Drew > > > > > ___ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > > > > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > > > DISCLAIMER Important! This message is intended for the above named > person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the > intended recipient of this e-mail and have received it in error, please > immediately notify the sender by return email and then delete it from your > mailbox. This message may be protected by the attorney-client privilege > and/or work product doctrine. Accessing, copying, disseminating or re-using > any of the information contained in this e-mail by anyone other than the > intended recipient is strictly prohibited. Finally, you should check this > email and any attachments for the presence of viruses, as the sender accepts > no liability for any damage caused by any virus transmitted by this email. > Thank you. > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: how to use web service client to upload an attachement in filter's set fields action
Just Map Your Attachment field to the the field in the WS as described by the WSDL. Its graphically driven. IF you can't match input and output it means the data types are incompatible. If you hover your mouse over a attachment field in WS def. it says dataType:base64binary. On Sat, Apr 10, 2010 at 12:49 PM, jiangxiaofeng86 wrote: > ** > hi all, > > I try to create a filter, which has a "set fields" action that consume a > web service. > the web service method needs a "datahandler" type input parameter. How do I > provide this parameter using an attachement from my form? > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
