Re: Frustrations with Remedy Developer Studio 7.5

[Shafqat Ayaz]

I am having the exact same problem with speed, every time i change something, 
not Save, just change, for example select a field and move it, it goes into a 
funk!
I think the people who wrote the code for Dev Studio have servers installed on 
their local machines and never bothered to do any testing over the network. I 
have found so many bugs and problems that it is unreal. if i wrote code like 
this i would get fired within a week.

 


Shafqat Ayaz








From: pritch 
To: arslist@ARSLIST.ORG
Sent: Tue, March 1, 2011 9:51:17 AM
Subject: Re: Frustrations with Remedy Developer Studio 7.5

I know y'all probably don't want to hear this, but I don't seem to have the
issues that you're mentioning - Dev Studio seems to function just fine. 
May not be like lightning, but it definitely doesn't take me 15, 30 or even
5 minutes to open update and save (even the more complex forms).

On Tue, 1 Mar 2011 07:07:09 -0800, Robert Molenda

wrote:
> The performance issues seem to never have been addressed with ANY of the
> incarnations of the "Admin Tool/Developer Studio" - this performance
issue
> has resulted in a "tooling requirement" for a Terminal Server available
> within the Data Center of the actual Remedy Server in order to perform
> routine work. WAN performance has decreased greatly. As you both are
> stating
> - a "quick fix is no longer quick!" - a 5 minute "open, update, save" can
> take 15 to 30 minutes easily.
> 
> I've requested an enhancement many years ago about a "offline mode" where
> you extract a def-file, and run the tool against that - perfect for what
I
> call "airplane mode" where you want to look at code while traveling.
Should
> be easy one would think right..?? After all Panacea has had this offline
> comparison feature for YEARS...
> 
> If I had the spare time (which no-one does, and slow tools make any hint
of
> that now impossible) - I would look to re-invent another tool - because
the
> API is sitting there for all of us to use... I know I've written extract
to
> def, update def, reimport def code before for mass updates!
> 
> Competition brings out the "best of class" so to say - I wonder if some
of
> the partners like Panacea, RRR, etc might see this as a huge opportunity
to
> enhance their tools / products to suit the needs of the communities.
> Definitely would not be the FIRST TIME - that is for sure.
> 
> I could just imagine - taking a Panacea extract of the system, get on the
> airplane, and start coding. Once I'm to the site a migration package is
> ready, if any objects I updated were also updated these are flagged so
> investigation could be made, else - click-whir-coffee-done... [Dang -
back
> to reality :( ]
> 
> Opportunity knocks - lets see if someone can pickup the ball and run with
> it!!!
> Robert Molenda
> 
> On Mon, Feb 28, 2011 at 3:17 PM, strauss  wrote:
> 
>> I’ve lost mine.  This so-called “application” is a HUGE piece of ^%$#%
on
>> the best day.
>>
>>
>>
>> Today I am fighting to clean up the dregs of the first Best Practices
>> Conversion Utility run, and I have to edit three things side by side;
the
>> customized active link prefixed with two * that was active, the interim
>> one
>> that was inactive with one * prefix, and the original, where the BPCU
>> combined the two inactive ones and left the active one hanging.  When I
>> open
>> all three they lay over one another by default.  There is no VIEW menu
>> where
>> you can select things like Cascade, Tile, Tile Vertically, or Tile
>> Horizontally like MOST decent windowing programs… NOTHING.  Support
>> explained that you had to grab the edges of the objects and drag them
>> manually into some sort of side by side array, a HUGE time-waster, and I
>> was
>> doing that earlier today, but now they refuse to be selected by the
>> mouse,
>> so I have to assume that it has gone into some obtuse mode where even
>> manual
>> manipulation of the editor environment is impossible.  Resetting the
>> Perspective has no effect.  Has anyone figured this one out?
>>
>>
>>
>> NO tool used for production work should be this crude or obtuse. 
Period.
>>
>>
>>
>> Christopher Strauss, Ph.D.
>> Call Tracking Administration Manager
>> University of North Texas Computing & IT Center
>> http://itsm.unt.edu/
>>
>> *From:* Action Request System discussion list(ARSList) [mailto:
>> arslist@ARSLIST.ORG] *On Behalf Of *Robert Halstead
>> *Sent:* Monday, February 14, 2011 4:44 PM
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* Frustrations with Remedy Developer Studio 7.5
>>
>>
>>
>> ** Forgive me as this is more of a rant.
>>
>>
>>
>> My patience for Remedy Developer Studio 7.5 is growing thin.  I find
that
>> performing the most insignificant tasks become a test in patience as the
>> tool communicates to server for every single action.
>>
>>
>>
>> Selecting a field on a form, talk to the server to get properties.
>>
>> Selecting multiple fields, talk to the server to get all properties.
>>

Re: ARERR [8959] The XML data type is not supported. <>

[Chintan Shah]

Hi Mark,

The suggestion I am giving here is not related to Remedy but more related to 
SOAP Return Envelope testing.

Can you try to consume service outside of Remedy (i.e. through Java or Perl or 
C# web-service client) and then do a Set fields for "Status" through a 
$PROCESS$ calling your web-service client (in java you can package it as a JAR 
and call it)? You will need to parse specifically that field from SOAP Response 
and return it to the $PROCESS$.

See if you can parse out specifically that field from SOAP Response without any 
errors.

Thanks
Chintan.

--- On Mon, 2/28/11, Mark Milke  wrote:

From: Mark Milke 
Subject: ARERR [8959] The XML data type is not supported. <>
To: arslist@ARSLIST.ORG
Date: Monday, February 28, 2011, 8:35 AM

Hi Listers,

I've build a SOAP Message Queue and I'm testing a web service with our
partner.

I'm testing in manual mode, i.e. I'm setting every message's status to
Completed in order to initiate the comsumption of our partner's Web
Service.

While consuming a web service I'm getting the error mentioned in the
title and I have no idea what is causing it.

What's even more odd is, that is SOAP message arrives at the Web
Service provider, just can't set my message to Completed because of
the error. When I let an escalation run over it, it will fail I guess.

The top of oddity is that when I redo the mapping in the filter, the
error disappears for a few hours to return a few hours later.

Do you guys have an idea how to track down the problem?


Mark

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
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"
  

Using rrrchive to migrate SRM data

[Thad Esser]

Hello,

I was wondering if anyone has used rrrchive to migrate SRM Service Request
Definitions (and supporting data) from a staging server to a production
server and if you have, would you be willing to share your rrrchive config
file?  How bad an idea is it to do it that way?

I've been working with the SRM Import/Export console and besides being
really slow, its a little more cantankerous than I'd like.  The import
doesn't appear to like shared AOTs or shared questions and if anything goes
wrong during the import, I haven't found a way to (cleanly) do it over.
Also, it disassociates our AOTs with the actual back end fulfillment
templates which will cause a lot of manual work when we go live.  I'm
thinking rrrchive would be faster and better, but wanted to seek the wisdom
of the list.

Environment:
ARS 7.1
ITSM 7.0.3
SRM 2.2

Thanks in advance for your input.

Thad

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: EXTERNAL: Re: workflow objects hiding in Developer Studio

[LJ LongWing]

:)

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, March 02, 2011 4:15 PM
To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Re: workflow objects hiding in Developer Studio

Ok ... I am bad today.. I didn't even look at the WHERE clause 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, March 02, 2011 5:08 PM
To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Re: workflow objects hiding in Developer Studio

That’s odd …  The SQL is for a LEFT outer JOIN so it should return all rows 
from T1415 (AR System Metadata: actlink) even if there is no corresponding row 
in T1417 (AR System Object Relationships) since T1415 is on the left.

SELECT  TOP 10 J0.C1, J0.C2, J0.C20013, J0.C20012, J0.C20500,   
   J0.C20005, J0.C20506, J0.C20001, J0.C20002, J0.C20003, J1.C756, J1.C757   
FROM T1415 J0  
   LEFT JOIN T1417 J1 ON (J0.C2 = J1.C754)   
WHERE ((J1.C751 = 501) AND (J1.C756 = 1) AND (J0.C20001 > 0))   
ORDER BY J0.C1 ASC

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Wednesday, March 02, 2011 4:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Re: workflow objects hiding in Developer Studio

** 
Some more information on this for the list….I experienced this some more today 
and decided to do some digging.  I found the cause/fix for it.

I wanted to know where Dev studio got its list of workflow, so I turned on SQL 
logging and found this

 /* Wed Mar 02 2011 14:52:27.2290 */+GLEWMSF  
ARGetListEntryWithMultiSchemaFields -- from Developer Studio (protocol 14) at 
IP address x.x.x.x
 /* Wed Mar 02 2011 14:52:27.2290 */SELECT  TOP 10 J0.C1, 
J0.C2, J0.C20013, J0.C20012, J0.C20500, J0.C20005, J0.C20506, J0.C20001, 
J0.C20002, J0.C20003, J1.C756, J1.C757 FROM T1415 J0 LEFT JOIN T1417 J1 ON 
(J0.C2 = J1.C754) WHERE ((J1.C751 = 501) AND (J1.C756 = 1) AND (J0.C20001 > 
0)) ORDER BY J0.C1 ASC
 /* Wed Mar 02 2011 14:52:27.3700 */OK

I found that 1415 was ‘AR System Metadata: actlink’ and 1417 was ‘AR System 
Object Relationships’.  So it appears that if you have object relationships 
turned on, Dev Studio uses that table.  So I looked through that list and found 
my missing AL wasn’t in the list.  So I broke the join apart and pulled the 
same data minus the join and found my AL WAS in that list….

So I went into that table and looked, and sure enough, my AL did not have an 
entry….so I went into the admin console and unchecked ‘Record Object 
Relationships’, restarted (it deleted the records), re-checked it, restarted, 
and low and behold it showed up….so….

There is a bug somewhere in the object relationship status that doesn’t record 
all objects….and because the records aren’t there, those objects don’t show up 
in the dev studio…..bad design if you ask me…but I now have a workaround to it, 
and that’s what I truly needed ☺

-Original Message-
From: LJ LongWing [mailto:lj.longw...@gmail.com] 
Sent: Friday, February 11, 2011 9:25 AM
To: 'arslist@ARSLIST.ORG'
Subject: RE: EXTERNAL: Re: workflow objects hiding in Developer Studio

So you weren’t able to find a common cause of the ones that disappeared?  And 
FYI, the only ones I have seen ‘missing’ are AL’s.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J
Sent: Friday, February 11, 2011 8:58 AM
To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Re: workflow objects hiding in Developer Studio

** 
LJ and Fred,

It’s got to be gremlins.
Today I opened the filters and saw all of them BUT there are Active Links still 
missing/hiding.
I did the same thing LJ. Opened an AL in the old admin tool and cycled the 
enabled check box.
Saved it in the Admin tool then I went to the Dev Studio (both running at the 
same time) and hitF5 and that AL showed up in the list now.
Maybe by tomorrow they’ll all be there.
Oh and on the filters that showed up today, they have their old modified dates 
so nothing was done to the filters elsewhere.

On to 7.6.04 I guess.

Thanks all.

--- 
John J. Reiser 
Remedy Developer/Administrator 
Senior Software Development Analyst 
Lockheed Martin - MS2 
The star that burns twice as bright burns half as long. 
Pay close attention and be illuminated by its brilliance. - paraphrased by me 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Friday, February 11, 2011 10:43 AM
To: arslist@ARSLIST.ORG
Subject: EXTERNAL: Re: workflow objects hiding in Developer Studio

** 
John,
I just came across this situation in my 7.5 Patch 7 environment earlier this 
week.  The only way I was able to find the workflow was in the 7.1 Admin tool, 
sa

Re: EXTERNAL: Re: workflow objects hiding in Developer Studio

[LJ LongWing]

Unfortunately, even when you do a left join, if you use the item on the right 
in the WHERE

WHERE ((J1.C751 = 501) AND (J1.C756 = 1) AND (J0.C20001 > 0))

You essentially turn your left into a inner because you are saying show all 
from J0, but where J1 = this and thatessentially makes it an inner join...

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, March 02, 2011 4:08 PM
To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Re: workflow objects hiding in Developer Studio

That’s odd …  The SQL is for a LEFT outer JOIN so it should return all rows 
from T1415 (AR System Metadata: actlink) even if there is no corresponding row 
in T1417 (AR System Object Relationships) since T1415 is on the left.

SELECT  TOP 10 J0.C1, J0.C2, J0.C20013, J0.C20012, J0.C20500,   
   J0.C20005, J0.C20506, J0.C20001, J0.C20002, J0.C20003, J1.C756, J1.C757   
FROM T1415 J0  
   LEFT JOIN T1417 J1 ON (J0.C2 = J1.C754)   
WHERE ((J1.C751 = 501) AND (J1.C756 = 1) AND (J0.C20001 > 0))   
ORDER BY J0.C1 ASC

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Wednesday, March 02, 2011 4:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Re: workflow objects hiding in Developer Studio

** 
Some more information on this for the list….I experienced this some more today 
and decided to do some digging.  I found the cause/fix for it.

I wanted to know where Dev studio got its list of workflow, so I turned on SQL 
logging and found this

 /* Wed Mar 02 2011 14:52:27.2290 */+GLEWMSF  
ARGetListEntryWithMultiSchemaFields -- from Developer Studio (protocol 14) at 
IP address x.x.x.x
 /* Wed Mar 02 2011 14:52:27.2290 */SELECT  TOP 10 J0.C1, 
J0.C2, J0.C20013, J0.C20012, J0.C20500, J0.C20005, J0.C20506, J0.C20001, 
J0.C20002, J0.C20003, J1.C756, J1.C757 FROM T1415 J0 LEFT JOIN T1417 J1 ON 
(J0.C2 = J1.C754) WHERE ((J1.C751 = 501) AND (J1.C756 = 1) AND (J0.C20001 > 
0)) ORDER BY J0.C1 ASC
 /* Wed Mar 02 2011 14:52:27.3700 */OK

I found that 1415 was ‘AR System Metadata: actlink’ and 1417 was ‘AR System 
Object Relationships’.  So it appears that if you have object relationships 
turned on, Dev Studio uses that table.  So I looked through that list and found 
my missing AL wasn’t in the list.  So I broke the join apart and pulled the 
same data minus the join and found my AL WAS in that list….

So I went into that table and looked, and sure enough, my AL did not have an 
entry….so I went into the admin console and unchecked ‘Record Object 
Relationships’, restarted (it deleted the records), re-checked it, restarted, 
and low and behold it showed up….so….

There is a bug somewhere in the object relationship status that doesn’t record 
all objects….and because the records aren’t there, those objects don’t show up 
in the dev studio…..bad design if you ask me…but I now have a workaround to it, 
and that’s what I truly needed ☺

-Original Message-
From: LJ LongWing [mailto:lj.longw...@gmail.com] 
Sent: Friday, February 11, 2011 9:25 AM
To: 'arslist@ARSLIST.ORG'
Subject: RE: EXTERNAL: Re: workflow objects hiding in Developer Studio

So you weren’t able to find a common cause of the ones that disappeared?  And 
FYI, the only ones I have seen ‘missing’ are AL’s.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J
Sent: Friday, February 11, 2011 8:58 AM
To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Re: workflow objects hiding in Developer Studio

** 
LJ and Fred,

It’s got to be gremlins.
Today I opened the filters and saw all of them BUT there are Active Links still 
missing/hiding.
I did the same thing LJ. Opened an AL in the old admin tool and cycled the 
enabled check box.
Saved it in the Admin tool then I went to the Dev Studio (both running at the 
same time) and hitF5 and that AL showed up in the list now.
Maybe by tomorrow they’ll all be there.
Oh and on the filters that showed up today, they have their old modified dates 
so nothing was done to the filters elsewhere.

On to 7.6.04 I guess.

Thanks all.

--- 
John J. Reiser 
Remedy Developer/Administrator 
Senior Software Development Analyst 
Lockheed Martin - MS2 
The star that burns twice as bright burns half as long. 
Pay close attention and be illuminated by its brilliance. - paraphrased by me 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Friday, February 11, 2011 10:43 AM
To: arslist@ARSLIST.ORG
Subject: EXTERNAL: Re: workflow objects hiding in Developer Studio

** 
John,
I just came across this situation in my 7.5 Patch 7 environment earlier this 
week.  The only way I was able to find the workflow was in the 7.1 Admin tool, 
same as you, a simple save caused it 

Re: EXTERNAL: Re: workflow objects hiding in Developer Studio

[Grooms, Frederick W]

Ok ... I am bad today.. I didn't even look at the WHERE clause 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, March 02, 2011 5:08 PM
To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Re: workflow objects hiding in Developer Studio

That’s odd …  The SQL is for a LEFT outer JOIN so it should return all rows 
from T1415 (AR System Metadata: actlink) even if there is no corresponding row 
in T1417 (AR System Object Relationships) since T1415 is on the left.

SELECT  TOP 10 J0.C1, J0.C2, J0.C20013, J0.C20012, J0.C20500,   
   J0.C20005, J0.C20506, J0.C20001, J0.C20002, J0.C20003, J1.C756, J1.C757   
FROM T1415 J0  
   LEFT JOIN T1417 J1 ON (J0.C2 = J1.C754)   
WHERE ((J1.C751 = 501) AND (J1.C756 = 1) AND (J0.C20001 > 0))   
ORDER BY J0.C1 ASC

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Wednesday, March 02, 2011 4:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Re: workflow objects hiding in Developer Studio

** 
Some more information on this for the list….I experienced this some more today 
and decided to do some digging.  I found the cause/fix for it.

I wanted to know where Dev studio got its list of workflow, so I turned on SQL 
logging and found this

 /* Wed Mar 02 2011 14:52:27.2290 */+GLEWMSF  
ARGetListEntryWithMultiSchemaFields -- from Developer Studio (protocol 14) at 
IP address x.x.x.x
 /* Wed Mar 02 2011 14:52:27.2290 */SELECT  TOP 10 J0.C1, 
J0.C2, J0.C20013, J0.C20012, J0.C20500, J0.C20005, J0.C20506, J0.C20001, 
J0.C20002, J0.C20003, J1.C756, J1.C757 FROM T1415 J0 LEFT JOIN T1417 J1 ON 
(J0.C2 = J1.C754) WHERE ((J1.C751 = 501) AND (J1.C756 = 1) AND (J0.C20001 > 
0)) ORDER BY J0.C1 ASC
 /* Wed Mar 02 2011 14:52:27.3700 */OK

I found that 1415 was ‘AR System Metadata: actlink’ and 1417 was ‘AR System 
Object Relationships’.  So it appears that if you have object relationships 
turned on, Dev Studio uses that table.  So I looked through that list and found 
my missing AL wasn’t in the list.  So I broke the join apart and pulled the 
same data minus the join and found my AL WAS in that list….

So I went into that table and looked, and sure enough, my AL did not have an 
entry….so I went into the admin console and unchecked ‘Record Object 
Relationships’, restarted (it deleted the records), re-checked it, restarted, 
and low and behold it showed up….so….

There is a bug somewhere in the object relationship status that doesn’t record 
all objects….and because the records aren’t there, those objects don’t show up 
in the dev studio…..bad design if you ask me…but I now have a workaround to it, 
and that’s what I truly needed ☺

-Original Message-
From: LJ LongWing [mailto:lj.longw...@gmail.com] 
Sent: Friday, February 11, 2011 9:25 AM
To: 'arslist@ARSLIST.ORG'
Subject: RE: EXTERNAL: Re: workflow objects hiding in Developer Studio

So you weren’t able to find a common cause of the ones that disappeared?  And 
FYI, the only ones I have seen ‘missing’ are AL’s.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J
Sent: Friday, February 11, 2011 8:58 AM
To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Re: workflow objects hiding in Developer Studio

** 
LJ and Fred,

It’s got to be gremlins.
Today I opened the filters and saw all of them BUT there are Active Links still 
missing/hiding.
I did the same thing LJ. Opened an AL in the old admin tool and cycled the 
enabled check box.
Saved it in the Admin tool then I went to the Dev Studio (both running at the 
same time) and hitF5 and that AL showed up in the list now.
Maybe by tomorrow they’ll all be there.
Oh and on the filters that showed up today, they have their old modified dates 
so nothing was done to the filters elsewhere.

On to 7.6.04 I guess.

Thanks all.

--- 
John J. Reiser 
Remedy Developer/Administrator 
Senior Software Development Analyst 
Lockheed Martin - MS2 
The star that burns twice as bright burns half as long. 
Pay close attention and be illuminated by its brilliance. - paraphrased by me 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Friday, February 11, 2011 10:43 AM
To: arslist@ARSLIST.ORG
Subject: EXTERNAL: Re: workflow objects hiding in Developer Studio

** 
John,
I just came across this situation in my 7.5 Patch 7 environment earlier this 
week.  The only way I was able to find the workflow was in the 7.1 Admin tool, 
same as you, a simple save caused it to re-appear in the 7.5 Dev studio…I 
haven’t had a chance to do a deep dive on this and figure out what is going on 
or exactly what caused it.  One ‘clue’ on my part is that the workflow I’m 
dealing with is all associated (either primary form or

Re: Java script error - security issue

[Larry Barnes]

Sorry for replying late on this.

I'm using:
Atrium 7.5 patch 004
SRM2.2 patch 003 
ARS7.5 patch 007
Incident Mgmt 7.0.03 patch 009

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Juan Ingles
Sent: Wednesday, March 02, 2011 2:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Java script error - security issue

Agreed! It's wrong on so many levels...
The server process shouldn't even know what the user's password is, much less 
pass it somewhere else.

I really hope that "fixing" it didn't simply mean "we changed it to a POST"

Juan Ingles



On Wed, Mar 2, 2011 at 6:35 AM, Axton  wrote:
> ** They should really remove the URL parameters used to pass the 
> username and password.  There is no reason those should EVER be used.  
> It's a bad thing to do and it's there due to poor design.  Anything 
> that uses those URL parameters is also poorly designed.
>
> 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 Wed, Mar 2, 2011 at 12:18 AM, Ian Trimnell 
> 
> wrote:
>>
>> **
>> On 01/03/2011 21:25, Larry Barnes wrote:
>>
>> We have a Service Request template called "Cabinet", when we attempt 
>> to open it using the Request Entry link we get a java script error.
>> The error displays the users logon id and p/w!  This is the only 
>> template that is causing us issues.
>>
>> A modification was made prior to this error showing up.  Some of the 
>> questions were removed and replaced with different questions.  Once 
>> the questions were sequenced the mapping was removed and rebuilt; 
>> this is when the problem started.
>> The questions were Single Answer Menu type questions.  One of the 
>> questions would not display the menu to select from.
>> Finally we completely rebuilt the SRD and everything is working now 
>> but my concern is why would the user's name and password be displayed 
>> on the screen?
>> Has anyone seen this before?
>> The Java error is:
>>An error has occurred in the script on this page.
>> Line:  123
>> Char:   22
>> Error:   Unterminated string constant
>> Code:   0
>> URL:
>> http://remedyweb/arsys/plugins/SRMSServiceRequestGrowser/params?name=
>> &se 
>> rver=remedy%2Exxx%2Ecom&username=tester&pwd=tmp1234&auth=&fieldid
>> =30
>> 2899
>>  
>>  
>> Do you want to continue   Yes  or No
>> The actual password and user name are displayed on the screen!
>> Thanks for your time,
>> Larry B.
>>
>> Hi Larry,
>>
>> You don't say which version of the server you are running.  When we 
>> first installed 7.5, when it was released, we noticed that the user 
>> details were being passed through to web calls (flashboards, images, 
>> view fields, etc.) and also appearing in log files (especially the 
>> active link log file).  We raised this with BMC and it was fixed 
>> during a patch release (I think it was there by patch 004, but am not 
>> entirely sure).
>>
>> I have check the BMC support site and it looks as though it was fixed 
>> at patch 003 of 7.5.00.
>>
>> If you are using a version of AR System server later than this then 
>> it looks as though they have exposed the old error again.
>>
>> Hope this helps in some way,
>>
>> Ian
>> 
>> Ian Trimnell, Systems Programmer, Client Systems Distributed Systems, 
>> Information Technology Open University, MILTON KEYNES, UK
>> Phone: 01908 653741   web: http://www.open.ac.uk/ The Open University 
>> is incorporated by Royal Charter (RC 000391), an exempt charity in 
>> England & Wales and a charity registered in Scotland (SC 038302).
>> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
>
> _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"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: EXTERNAL: Re: workflow objects hiding in Developer Studio

[Grooms, Frederick W]

That’s odd …  The SQL is for a LEFT outer JOIN so it should return all rows 
from T1415 (AR System Metadata: actlink) even if there is no corresponding row 
in T1417 (AR System Object Relationships) since T1415 is on the left.

SELECT  TOP 10 J0.C1, J0.C2, J0.C20013, J0.C20012, J0.C20500,   
   J0.C20005, J0.C20506, J0.C20001, J0.C20002, J0.C20003, J1.C756, J1.C757   
FROM T1415 J0  
   LEFT JOIN T1417 J1 ON (J0.C2 = J1.C754)   
WHERE ((J1.C751 = 501) AND (J1.C756 = 1) AND (J0.C20001 > 0))   
ORDER BY J0.C1 ASC

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Wednesday, March 02, 2011 4:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Re: workflow objects hiding in Developer Studio

** 
Some more information on this for the list….I experienced this some more today 
and decided to do some digging.  I found the cause/fix for it.

I wanted to know where Dev studio got its list of workflow, so I turned on SQL 
logging and found this

 /* Wed Mar 02 2011 14:52:27.2290 */+GLEWMSF  
ARGetListEntryWithMultiSchemaFields -- from Developer Studio (protocol 14) at 
IP address x.x.x.x
 /* Wed Mar 02 2011 14:52:27.2290 */SELECT  TOP 10 J0.C1, 
J0.C2, J0.C20013, J0.C20012, J0.C20500, J0.C20005, J0.C20506, J0.C20001, 
J0.C20002, J0.C20003, J1.C756, J1.C757 FROM T1415 J0 LEFT JOIN T1417 J1 ON 
(J0.C2 = J1.C754) WHERE ((J1.C751 = 501) AND (J1.C756 = 1) AND (J0.C20001 > 
0)) ORDER BY J0.C1 ASC
 /* Wed Mar 02 2011 14:52:27.3700 */OK

I found that 1415 was ‘AR System Metadata: actlink’ and 1417 was ‘AR System 
Object Relationships’.  So it appears that if you have object relationships 
turned on, Dev Studio uses that table.  So I looked through that list and found 
my missing AL wasn’t in the list.  So I broke the join apart and pulled the 
same data minus the join and found my AL WAS in that list….

So I went into that table and looked, and sure enough, my AL did not have an 
entry….so I went into the admin console and unchecked ‘Record Object 
Relationships’, restarted (it deleted the records), re-checked it, restarted, 
and low and behold it showed up….so….

There is a bug somewhere in the object relationship status that doesn’t record 
all objects….and because the records aren’t there, those objects don’t show up 
in the dev studio…..bad design if you ask me…but I now have a workaround to it, 
and that’s what I truly needed ☺

-Original Message-
From: LJ LongWing [mailto:lj.longw...@gmail.com] 
Sent: Friday, February 11, 2011 9:25 AM
To: 'arslist@ARSLIST.ORG'
Subject: RE: EXTERNAL: Re: workflow objects hiding in Developer Studio

So you weren’t able to find a common cause of the ones that disappeared?  And 
FYI, the only ones I have seen ‘missing’ are AL’s.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J
Sent: Friday, February 11, 2011 8:58 AM
To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Re: workflow objects hiding in Developer Studio

** 
LJ and Fred,

It’s got to be gremlins.
Today I opened the filters and saw all of them BUT there are Active Links still 
missing/hiding.
I did the same thing LJ. Opened an AL in the old admin tool and cycled the 
enabled check box.
Saved it in the Admin tool then I went to the Dev Studio (both running at the 
same time) and hitF5 and that AL showed up in the list now.
Maybe by tomorrow they’ll all be there.
Oh and on the filters that showed up today, they have their old modified dates 
so nothing was done to the filters elsewhere.

On to 7.6.04 I guess.

Thanks all.

--- 
John J. Reiser 
Remedy Developer/Administrator 
Senior Software Development Analyst 
Lockheed Martin - MS2 
The star that burns twice as bright burns half as long. 
Pay close attention and be illuminated by its brilliance. - paraphrased by me 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Friday, February 11, 2011 10:43 AM
To: arslist@ARSLIST.ORG
Subject: EXTERNAL: Re: workflow objects hiding in Developer Studio

** 
John,
I just came across this situation in my 7.5 Patch 7 environment earlier this 
week.  The only way I was able to find the workflow was in the 7.1 Admin tool, 
same as you, a simple save caused it to re-appear in the 7.5 Dev studio…I 
haven’t had a chance to do a deep dive on this and figure out what is going on 
or exactly what caused it.  One ‘clue’ on my part is that the workflow I’m 
dealing with is all associated (either primary form or push to that form) to a 
form that was renamed.  I don’t have much, anything you can share about your 
cause might help nail it down.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J
Sent: Thursday, February 10, 2011 5:09 PM
To: arslist@ARSLIST.ORG
Subj

Re: Trying not to Merge a whole dataset?

[Roger Justice]

Your logic will not work since items in A should not be related to items in B. 
Each Data Set is independent and the merge is to move the data and 
relationships of one dataset into BMC.Asset. Then you do an ID job against 
BMC.Asset with the second dataset to get the same CI to get the right ReconID 
so that when you merge the second data set both the CI and relationships are 
merged.




-Original Message-
From: Scott Philben 
To: arslist 
Sent: Wed, Mar 2, 2011 4:44 pm
Subject: Re: Trying not to Merge a whole dataset?


** 
I ran an ID job on B based against itself (this is the first import, no data in 
BMC.ASSET yet). I got ReconIDs auto generated for all my B CIs. Now I want to 
relate and merge only those that relate.


Still can't figure it out.








On Mar 2, 2011, at 1:35 PM, Roger Justice wrote:


** How did you do the Identification between B and BMC.Asset?





-Original Message-
From: sphilben 
To: arslist 
Sent: Wed, Mar 2, 2011 1:20 pm
Subject: Trying not to Merge a whole dataset?


** 
All:
 
I have two datasets (A and B). I want to merge all of dataset A to BMC.ASSET 
but only those in dataset B that are related to CIs in A. So after my ID job I 
ran a relationship job that created HOSTEDSYSTEMCOMPONENT entries and filled in 
the SystemName field on B. Can I use that field now to restrict the merge on B?
 
I tried setting up a merge job on B with one activity: merge source B to 
BMC.ASSET using the Default Merge Set. I then added a qualification on the 
class with 'SystemName' !=  $\NULL$ in the Qualification* field. 
 
When I run the job nothing happens. No records get copied to BMC.ASSET.
 
Can I even do something like I am trying to do? Can I restrict a dataset merge 
in this way? Or do I have to merge everything?
 
Thanks.
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are&qu 
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_


_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: Java script error - security issue

[Juan Ingles]

Agreed! It's wrong on so many levels...
The server process shouldn't even know what the user's password is,
much less pass it somewhere else.

I really hope that "fixing" it didn't simply mean "we changed it to a POST"

Juan Ingles



On Wed, Mar 2, 2011 at 6:35 AM, Axton  wrote:
> ** They should really remove the URL parameters used to pass the username
> and password.  There is no reason those should EVER be used.  It's a bad
> thing to do and it's there due to poor design.  Anything that uses those URL
> parameters is also poorly designed.
>
> 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 Wed, Mar 2, 2011 at 12:18 AM, Ian Trimnell 
> wrote:
>>
>> **
>> On 01/03/2011 21:25, Larry Barnes wrote:
>>
>> We have a Service Request template called "Cabinet", when we attempt to
>> open it using the Request Entry link we get a java script error.
>> The error displays the users logon id and p/w!  This is the only
>> template that is causing us issues.
>>
>> A modification was made prior to this error showing up.  Some of the
>> questions were removed and replaced with different questions.  Once the
>> questions were sequenced the mapping was removed and rebuilt; this is
>> when the problem started.
>> The questions were Single Answer Menu type questions.  One of the
>> questions would not display the menu to select from.
>> Finally we completely rebuilt the SRD and everything is working now but
>> my concern is why would the user's name and password be displayed on the
>> screen?
>> Has anyone seen this before?
>> The Java error is:
>>An error has occurred in the script on this page.
>> Line:  123
>> Char:   22
>> Error:   Unterminated string constant
>> Code:   0
>> URL:
>> http://remedyweb/arsys/plugins/SRMSServiceRequestGrowser/params?name=&se
>> rver=remedy%2Exxx%2Ecom&username=tester&pwd=tmp1234&auth=&fieldid=30
>> 2899
>>  
>>  
>> Do you want to continue   Yes  or No
>> The actual password and user name are displayed on the screen!
>> Thanks for your time,
>> Larry B.
>>
>> Hi Larry,
>>
>> You don't say which version of the server you are running.  When we first
>> installed 7.5, when it was released, we noticed that the user details were
>> being passed through to web calls (flashboards, images, view fields, etc.)
>> and also appearing in log files (especially the active link log file).  We
>> raised this with BMC and it was fixed during a patch release (I think it was
>> there by patch 004, but am not entirely sure).
>>
>> I have check the BMC support site and it looks as though it was fixed at
>> patch 003 of 7.5.00.
>>
>> If you are using a version of AR System server later than this then it
>> looks as though they have exposed the old error again.
>>
>> Hope this helps in some way,
>>
>> Ian
>> 
>> Ian Trimnell, Systems Programmer, Client Systems
>> Distributed Systems, Information Technology
>> Open University, MILTON KEYNES, UK
>> Phone: 01908 653741   web: http://www.open.ac.uk/
>> The Open University is incorporated by Royal Charter (RC 000391), an
>> exempt charity in England & Wales and a charity registered in Scotland (SC
>> 038302).
>> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
>
> _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: EXTERNAL: Re: workflow objects hiding in Developer Studio

[LJ LongWing]

Some more information on this for the list..I experienced this some more
today and decided to do some digging.  I found the cause/fix for it.

 

I wanted to know where Dev studio got its list of workflow, so I turned on
SQL logging and found this

 

 /* Wed Mar 02 2011 14:52:27.2290 */+GLEWMSF
ARGetListEntryWithMultiSchemaFields -- from Developer Studio (protocol 14)
at IP address x.x.x.x

 /* Wed Mar 02 2011 14:52:27.2290 */SELECT  TOP 10 J0.C1,
J0.C2, J0.C20013, J0.C20012, J0.C20500, J0.C20005, J0.C20506, J0.C20001,
J0.C20002, J0.C20003, J1.C756, J1.C757 FROM T1415 J0 LEFT JOIN T1417 J1 ON
(J0.C2 = J1.C754) WHERE ((J1.C751 = 501) AND (J1.C756 = 1) AND
(J0.C20001 > 0)) ORDER BY J0.C1 ASC

 /* Wed Mar 02 2011 14:52:27.3700 */OK

 

I found that 1415 was 'AR System Metadata: actlink' and 1417 was 'AR System
Object Relationships'.  So it appears that if you have object relationships
turned on, Dev Studio uses that table.  So I looked through that list and
found my missing AL wasn't in the list.  So I broke the join apart and
pulled the same data minus the join and found my AL WAS in that list..

 

So I went into that table and looked, and sure enough, my AL did not have an
entry..so I went into the admin console and unchecked 'Record Object
Relationships', restarted (it deleted the records), re-checked it,
restarted, and low and behold it showed up..so..

 

There is a bug somewhere in the object relationship status that doesn't
record all objects..and because the records aren't there, those objects
don't show up in the dev studio...bad design if you ask me.but I now have a
workaround to it, and that's what I truly needed J

 

From: LJ LongWing [mailto:lj.longw...@gmail.com] 
Sent: Friday, February 11, 2011 9:25 AM
To: 'arslist@ARSLIST.ORG'
Subject: RE: EXTERNAL: Re: workflow objects hiding in Developer Studio

 

So you weren't able to find a common cause of the ones that disappeared?
And FYI, the only ones I have seen 'missing' are AL's.

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J
Sent: Friday, February 11, 2011 8:58 AM
To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Re: workflow objects hiding in Developer Studio

 

** 

LJ and Fred,

 

It's got to be gremlins.

Today I opened the filters and saw all of them BUT there are Active Links
still missing/hiding.

I did the same thing LJ. Opened an AL in the old admin tool and cycled the
enabled check box.

Saved it in the Admin tool then I went to the Dev Studio (both running at
the same time) and hitF5 and that AL showed up in the list now.

Maybe by tomorrow they'll all be there.

Oh and on the filters that showed up today, they have their old modified
dates so nothing was done to the filters elsewhere.

 

On to 7.6.04 I guess.

 

Thanks all.

 

--- 
John J. Reiser 
Remedy Developer/Administrator 

Senior Software Development Analyst 
Lockheed Martin - MS2 
The star that burns twice as bright burns half as long. 
Pay close attention and be illuminated by its brilliance. - paraphrased by
me 

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Friday, February 11, 2011 10:43 AM
To: arslist@ARSLIST.ORG
Subject: EXTERNAL: Re: workflow objects hiding in Developer Studio

 

** 

John,

I just came across this situation in my 7.5 Patch 7 environment earlier this
week.  The only way I was able to find the workflow was in the 7.1 Admin
tool, same as you, a simple save caused it to re-appear in the 7.5 Dev
studio.I haven't had a chance to do a deep dive on this and figure out what
is going on or exactly what caused it.  One 'clue' on my part is that the
workflow I'm dealing with is all associated (either primary form or push to
that form) to a form that was renamed.  I don't have much, anything you can
share about your cause might help nail it down.

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J
Sent: Thursday, February 10, 2011 5:09 PM
To: arslist@ARSLIST.ORG
Subject: workflow objects hiding in Developer Studio

 

** 

Hello Listers,

 

ARS 7.6.03

SQL Server 2005

 

Has anyone had the experience of workflow that "appears" to be missing from
the system?

I did an upgrade from 7.1 to 7.6.03 and when I go in to try to find my
filters there are 2 filters in the All Objects | Filters section.

Now I've increased the number to 221 by finding the filters via the
Applications sections an "touching" them. In the Application listing the
Primary Form column is empty until I open a filter and disable/enable it
then save it. The Primary Form is displayed in the filter object when opened
just not in the list's column.

I don't want to open and mess with every filter, active link and escalation
in the system.

Is there perhaps setting to configure for this? I've checked the "Filter by"
and everything is cleared.

I set the Relationship checkbox via the Adm

Remedy 7.1 with Oracle 10G R2 Encrypted (Column or Tablespace level)

Hi all,

 

We are trying to implement the remedy 7.1 with oracle 10G R2 version.

We also have an additional requirement that the data should be
"Encrypted". As Oracle 10GR2 version supports the encryption we are
looking forward to this approach.

 

Question:

1.   Does the remedy 7.1 supports "Column level" or "Tablespace
level" encryption. 

2.   If yes

a.   Do we have to change any settings in remedy for this changed?

b.  How and what impact it will be on the application and data?

 
i.  While view/search/add/update?

3.   If No

a.   What should be the approach?

Thanks & Regards 
Saurabh Batwe 
Email: sba...@its.jnj.com


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Trying not to Merge a whole dataset?

[Scott Philben]

I ran an ID job on B based against itself (this is the first import, no data in 
BMC.ASSET yet). I got ReconIDs auto generated for all my B CIs. Now I want to 
relate and merge only those that relate.

Still can't figure it out.




On Mar 2, 2011, at 1:35 PM, Roger Justice wrote:

> ** How did you do the Identification between B and BMC.Asset?
> 
> 
> 
> -Original Message-
> From: sphilben 
> To: arslist 
> Sent: Wed, Mar 2, 2011 1:20 pm
> Subject: Trying not to Merge a whole dataset?
> 
> **
> All:
>  
> I have two datasets (A and B). I want to merge all of dataset A to BMC.ASSET 
> but only those in dataset B that are related to CIs in A. So after my ID job 
> I ran a relationship job that created HOSTEDSYSTEMCOMPONENT entries and 
> filled in the SystemName field on B. Can I use that field now to restrict the 
> merge on B?
>  
> I tried setting up a merge job on B with one activity: merge source B to 
> BMC.ASSET using the Default Merge Set. I then added a qualification on the 
> class with 'SystemName' !=  $\NULL$ in the Qualification* field.
>  
> When I run the job nothing happens. No records get copied to BMC.ASSET.
>  
> Can I even do something like I am trying to do? Can I restrict a dataset 
> merge in this way? Or do I have to merge everything?
>  
> Thanks.
> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are&qu
> _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: Refreshing table through a filter

[Chintan Shah]

Actually List, this was my bad..its working. I was actually iterating on a 
different table and expecting below result.

Sorry for causing unnecessary trouble .

Thanks
Chintan.

--- On Wed, 3/2/11, Chintan Shah  wrote:

From: Chintan Shah 
Subject: Refreshing table through a filter
To: arslist@arslist.org
Date: Wednesday, March 2, 2011, 11:36 AM

Hi all,

I have a table field and an external qual to it.

Basically, I want to re-use the same table and perform different queries on it 
through workflow so that I can retrieve different records based on 
qualification.

In simple terms, idea is 
1. Set fields -Get qual for table
2. Call guide
3. Set fields- Get qual for table
4. call guide.

The problem I am encountering is table is not getting refreshed on the 3rd Set 
fields.

Has anyone tried to refresh a table through a filter or is this a known bug?

I have read this thread but wasn't sure if its fixed or not.
http://www.mattreinfeldt.com/forums/ubbthreads.php/topics/129110/Re_How_to_Refresh_Table_Field_

We are on ARS- 7.1 Patch 7.

Thanks in advance.

Regards,
Chintan.



  



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
  

Re: Where to copy program on server for run process

[Angus Comber]

>From your email I am reading this to mean that if Active-Link-Dir is NOT 
>specified then this security feature is disabled?  

It is not so much of a security issue I suppose because only Remedy 
administrators should be able to configure an active link.  But don't take my 
word for that - there could be loopholes.

Angus

p.s. this was not a real application but instead a proof of concept to check 
that it is possible to invoke a program on the Remedy server from an active 
link.  The program wrote any parameters passed to a file but the directory was 
not specified so it wrote to the working directory I guess - which in this case 
was C:\Windows.

  - Original Message - 
  From: Mueller, Doug 
  Newsgroups: public.remedy.arsystem.general
  To: arslist@ARSLIST.ORG 
  Sent: Tuesday, March 01, 2011 6:35 PM
  Subject: Re: Where to copy program on server for run process


  Joe,

  Just to help clarify.

  From the initial report of issue, things were working.  The program in 
question simply had the output
  directed to an unexpected location.  Without understanding the program -- was 
it writing to a file or just to
  stdout (standard out) -- hard to tell what was going on.

  Any process run in the background should carefully control where files are 
being written or what is
  written when just stdout is written.  Either redirect that or use full 
filenames or filenames directed by
  environment variables (and remember that the environment is the one the AR 
System is run in).


  As for the Active-Link-Dir setting

  According to the documentation (and the documentation is accurate), this 
setting is

The directory where active link server run processes are stored.  Only 
commands located in the specified
directory can be run.  This is a security feature that makes sure clients 
or API programs can use only a
safe set of server processes.

  So, this is simply a setting that says that if someone tries to run a program 
from an active link on the server,
  the program MUST BE in the directory specified.  If there is not the program 
executable in that directory, the
  command will fail.  This is a security feature to allow you as the 
administrator to specify a directory and
  unless you put a specific executable in that directory, it cannot be run from 
the client.

  It does not control the environment that the program is run in in any way.  
It simply is a way to control
  whether a given program can run at all.


  There are other controls like  Active-Link-Shell (UNIX and Linux) that allow 
you to control the parent shell.
  Again, not where you run, just the environment under which you run.


  For any program run, remember you are running under the context of the AR 
System server so you will be
  in the environment of the AR System server when the program is run.  The 
controls above simply control
  what can be run not where (unless you build the where into the custom shell 
you specify).

  I hope this helps,

  Doug Mueller



--
  From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza
  Sent: Sunday, February 27, 2011 10:50 AM
  To: arslist@ARSLIST.ORG
  Subject: Re: Where to copy program on server for run process


  ** 
  It might be a bug. I am not confident that is the way it should behave. If it 
were as designed, it would beat the purpose of that configuration by 50% – it 
would be like just half the expected work done...

  I wish I had an older installation to test to prove this but I do not. You 
may want to report it to customer support and ask them if they can get 
engineering to confirm that is how it should work..

  If we are lucky Doug Mueller may be watching this thread.. <>

  Joe

  From: Angus Comber 
  Sent: Sunday, February 27, 2011 1:41 PM
  Newsgroups: public.remedy.arsystem.general
  To: arslist@ARSLIST.ORG 
  Subject: Re: Where to copy program on server for run process

  **  
  No, it seemed to have no effect.  Which was disappointing.
- Original Message - 
From: Joe Martin D'Souza 
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 
Sent: Sunday, February 27, 2011 10:23 AM
Subject: Re: Where to copy program on server for run process

** 
Did the output directory change after the introduction of Active-Link-Dir ??

Joe

From: Angus Comber 
Sent: Saturday, February 26, 2011 5:33 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 
Subject: Re: Where to copy program on server for run process

**  
The Active-Link-Dir key in ar config file was not required.  The only thing 
required is that the program must be accessible - either in the system path or 
specify full path in active link or place in Remedy server process working? 
directory.  I didn't work out what the correct directory was.

My proble

Re: User profile modification question...

[Richard Copits]

Oh man I TOTALLY missed seeing that! If it was a snake it would have
bit me   Thank you !!

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Chris Danaceau
Sent: Wednesday, March 02, 2011 3:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: User profile modification question...

Richard, People records have supported images since 7.0 in ITSM.  On the 
General tab there is an attachment field for an image which is displayed in a 
view field at top right of the form.

--
Chris Danaceau
AttivaSoft Solutions Architect



From: Action Request System discussion list(ARSList) on behalf of Richard Copits
Sent: Wed 3/2/2011 2:44 PM
To: arslist@ARSLIST.ORG
Subject: User profile modification question...


**



I've been asked how to add a graphic/picture to the users profile. I've combed 
the

profile setup in the system as well as read the config. manual for 7.5 but 
can't find

anything on being able to add a graphic/picture/etc. to a user profile. Can it 
be done,

and if so, where would it be explained how to do it? Thanks!







Portions of this message may be confidential under an exemption to Ohio's 
public records law or under a legal privilege. If you have received this 
message in error or due to an unauthorized transmission or interception, please 
delete all copies from your system without disclosing, copying, or transmitting 
this message.
_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"


Portions of this message may be confidential under an exemption to Ohio's 
public records law or under a legal privilege. If you have received this 
message in error or due to an unauthorized transmission or interception, please 
delete all copies from your system without disclosing, copying, or transmitting 
this message.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: User profile modification question...

[Chris Danaceau]

Richard, People records have supported images since 7.0 in ITSM.  On the 
General tab there is an attachment field for an image which is displayed in a 
view field at top right of the form.
 
-- 
Chris Danaceau
AttivaSoft Solutions Architect



From: Action Request System discussion list(ARSList) on behalf of Richard Copits
Sent: Wed 3/2/2011 2:44 PM
To: arslist@ARSLIST.ORG
Subject: User profile modification question...


** 

 

I've been asked how to add a graphic/picture to the users profile. I've combed 
the

profile setup in the system as well as read the config. manual for 7.5 but 
can't find

anything on being able to add a graphic/picture/etc. to a user profile. Can it 
be done,

and if so, where would it be explained how to do it? Thanks!

 





Portions of this message may be confidential under an exemption to Ohio's 
public records law or under a legal privilege. If you have received this 
message in error or due to an unauthorized transmission or interception, please 
delete all copies from your system without disclosing, copying, or transmitting 
this message.
_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: User profile modification question...

[Richard Copits]

We have 7.5  when you set up a user there's a place for it but I can't find 
out how to
"populate" that profile area with different graphics or a picture

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire
Sent: Wednesday, March 02, 2011 3:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: User profile modification question...

**
In ver 7.6.4 there appears to be a place to add it.  I can't be 100% sure since 
I have not loaded it yet.


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Richard Copits
Sent: Wednesday, March 02, 2011 1:45 PM
To: arslist@ARSLIST.ORG
Subject: User profile modification question...
**

I've been asked how to add a graphic/picture to the users profile. I've combed 
the
profile setup in the system as well as read the config. manual for 7.5 but 
can't find
anything on being able to add a graphic/picture/etc. to a user profile. Can it 
be done,
and if so, where would it be explained how to do it? Thanks!




Portions of this message may be confidential under an exemption to Ohio's 
public records law or under a legal privilege. If you have received this 
message in error or due to an unauthorized transmission or interception, please 
delete all copies from your system without disclosing, copying, or transmitting 
this message.
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_



Portions of this message may be confidential under an exemption to Ohio's 
public records law or under a legal privilege. If you have received this 
message in error or due to an unauthorized transmission or interception, please 
delete all copies from your system without disclosing, copying, or transmitting 
this message.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: User profile modification question...

[Sanford, Claire]

In ver 7.6.4 there appears to be a place to add it.  I can't be 100%
sure since I have not loaded it yet.



From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Richard Copits
Sent: Wednesday, March 02, 2011 1:45 PM
To: arslist@ARSLIST.ORG
Subject: User profile modification question...


** 

 

I've been asked how to add a graphic/picture to the users profile. I've
combed the

profile setup in the system as well as read the config. manual for 7.5
but can't find

anything on being able to add a graphic/picture/etc. to a user profile.
Can it be done,

and if so, where would it be explained how to do it? Thanks!

 





Portions of this message may be confidential under an exemption to
Ohio's public records law or under a legal privilege. If you have
received this message in error or due to an unauthorized transmission or
interception, please delete all copies from your system without
disclosing, copying, or transmitting this message.
_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"

User profile modification question...

[Richard Copits]

I've been asked how to add a graphic/picture to the users profile. I've combed 
the
profile setup in the system as well as read the config. manual for 7.5 but 
can't find
anything on being able to add a graphic/picture/etc. to a user profile. Can it 
be done,
and if so, where would it be explained how to do it? Thanks!




Portions of this message may be confidential under an exemption to Ohio's 
public records law or under a legal privilege. If you have received this 
message in error or due to an unauthorized transmission or interception, please 
delete all copies from your system without disclosing, copying, or transmitting 
this message.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Abydos Analyser Recommendation

[Clifton Edward Teate]

When we started to receive multiple enhancement requests for our Remedy 6.3
ARSystem environment, we found ourselves spending a great deal of time in
the documentation of the forms, fields, and workflow that were related to
each enhancement.  We originally purchased the Abydos Analyser tool for the
instant development documentation feature, of which saved 4 to 16 hours of
development documentation tasks per enhancement request.

We started to utilize some of the other features (wild card searches for
workflow and interactive workflow diagrams) and quickly discovered that
Abydos Analyser was more than just a development documentation tool.  Our
6.3 ARSystem environment did not have the "Sync Search Database" updated in
quite some time and every attempt at updating was met with failure and/or
too risky (only one environment - production).  You can imagine the
nightmare that we experienced when troubleshooting workflow problems for an
environment that did not include best practice (or logical) naming
conventions for workflow objects, coupled with years of multiple
administrators/developers that produced new processes without
documentation.  A typical troubleshooting task would take us between 5 and
16 hours of research using the Remedy Developer tool (6.3).  Abydos Analyser
provided us with a solution to perform wild-card searches against workflow
objects, state change diagrams, and event diagrams...of which improved our
troubleshooting task time to less than 1 hour in most cases.  In addition,
it provided us with the mechanism to assess impact for enhancement requests
(e.g. add a field, menu item, new active link, etc.) and improved our
development time for enhancements.

We are currently working on a migration project to 7.6.04 and based on past
experience, the BMC classes do not provide you with training on "how" they
developed their out-of-the-box applications (e.g. Service Desk, Change
Management, etc.).  In all cases, BMC will recommend that you "do not"
attempt to customize their applications due to problems with future hot
fixes, patches and/or upgrades.  However, we continued to receive
enhancement requests that required some level of customization to the
out-of-the-box applications.  Abydos Analyser provided us with the mechanism
to "learn" their workflow, which improved our ability to "safely" create a
customization that would not impact functionality or future releases from
BMC.  To this day, I have not found similar features in the developer studio
versions that were released from BMC and I consider the Abydos Analyser tool
a "must have" for all Remedy Administrators and Developers.  The small
investment for this tool will create an immediate return on investment
within the first couple of enhancement requests, troubleshooting tasks, or
upgrade/migration that you will work on.

- Clifton Teate, Business Inelligence Sytems Integrator, MedQuist

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Refreshing table through a filter

[Chintan Shah]

Hi all,

I have a table field and an external qual to it.

Basically, I want to re-use the same table and perform different queries on it 
through workflow so that I can retrieve different records based on 
qualification.

In simple terms, idea is 
1. Set fields -Get qual for table
2. Call guide
3. Set fields- Get qual for table
4. call guide.

The problem I am encountering is table is not getting refreshed on the 3rd Set 
fields.

Has anyone tried to refresh a table through a filter or is this a known bug?

I have read this thread but wasn't sure if its fixed or not.
http://www.mattreinfeldt.com/forums/ubbthreads.php/topics/129110/Re_How_to_Refresh_Table_Field_

We are on ARS- 7.1 Patch 7.

Thanks in advance.

Regards,
Chintan.




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
  

Any known workarounds for using Remedy ODBC driver on 64-bit windows platform?

[Anderson Debra (PRN)]

Hi Everyone,

 

We have a user group that is having issues trying to use the Remedy ODBC
driver to query remedy forms via excel.

They are running on a 64-bit windows platform which I know if not
officially supported but was wondering if anyone knows of any workaround
for using this platform.

 

Here are some details I received from the user.  We are using remedy
version 7.0.01.

1.  I'm using Windows  7 Ultimate
7600.16695.amd64fre.win7_gdr.101026-1503.   
2.  Remedy driver was installed per the installation instructions 
3.  On 64 bit Windows, using 64 bit ODBC, can't even configure the
driver or add a datasource using it (it doesn't even show up on the add
datasource list).  Attempting to configure the driver produces error
"The specified DSN contains an architecture mismatch between the Driver
and the Application"

4.  Using c:\windows\syswow64\odbcad32.exe, can configure the driver
and even test it successfully, however, on 32-bit Office, get error
"unable to obtain list of tables from the datasource" when trying to
access Remedy AR ODBC.  On 64-bit Office, get error "The specified DSN
contains an architecture mismatch between the Driver and the
Application" when trying to access the datasource.



All of my users on 32-bit windows platforms have no issues using the
driver to query remedy data from excel!

 

Thanks

Debra

 

Debra Anderson
T  415.808.9118   |   F  415.808.3535   
600 Harrison St *   San Francisco, CA   *   94107

PRN | media where & when it matters

This e-mail (including any attachments) is meant for only the intended
recipient of the transmission, and may include confidential information.
If you are not the intended recipient or you received this e-mail in
error, any review, use, dissemination, distribution, or copying of this
e-mail is strictly prohibited.  If you have received this message in
error, please notify the sender immediately by telephone at (415)
808-3500 or by return e-mail and delete this e-mail, along with any
attachments and copies, from your system.  Thank you.



 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Abydos Analyser 5.2 Released

[Bill Hoffmeier]

I've been using Abydos Analyzer for three years now, and
I can tell you if you're not using this product you should be. The product is
continually improving.  If you want a
quick answer from your Remedy Server workflow, Analyzer gives you a way to get
it; it is an instant gratification tool. 
I am extremely pleased that I have this product, and I'm so much more
productive because of it.  BTW, I'm not
only impressed with the software, but their support rocks!

 

Bill Hoffmeier

Lockheed Martin 

Altadena, Ca



Date: Wed, 2 Mar 2011 14:05:30 +
From: mherr...@abydos-workflow.com
Subject: Abydos Analyser 5.2 Released
To: arslist@ARSLIST.ORG

**


Dear Listers, Abydos are pleased to announce the release of Abydos Analyser 
5.2. Abydos Analyser 5.2 is now available for download from the Abydos website 
at www.abydos-workflow.com This new release includes a complete overhaul of the 
Event Diagram to provide an extensive range of options to control the output 
and presentation of workflow events. This includes: a) filtering options on 
diagram contents based on execution order range, field references, run-if 
conditions, keywords or text stringsb) explosion of diagram to show workflow 
impact on other forms where there is a knock-on effect which causes workflow to 
fire elsewherec) ability to save and re-load diagram settingsd) show disabled 
workflow (greyed out)e) highlight actions that commonly spawn other workflow; 
These new features will further improve the time savings for Remedy 
Administrators and support staff in analysing, documenting and trouble-shooting 
Remedy-based applications.
For more information or to download a free trial, visit the Abydos Analyser 
Product Page   Kind RegardsMark Herring USA: Toll Free: 1-866-635-4358Outside 
US: +44 (0)1582 400127 
_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: Trying not to Merge a whole dataset?

[Roger Justice]

How did you do the Identification between B and BMC.Asset?





-Original Message-
From: sphilben 
To: arslist 
Sent: Wed, Mar 2, 2011 1:20 pm
Subject: Trying not to Merge a whole dataset?


** 
All:
 
I have two datasets (A and B). I want to merge all of dataset A to BMC.ASSET 
but only those in dataset B that are related to CIs in A. So after my ID job I 
ran a relationship job that created HOSTEDSYSTEMCOMPONENT entries and filled in 
the SystemName field on B. Can I use that field now to restrict the merge on B?
 
I tried setting up a merge job on B with one activity: merge source B to 
BMC.ASSET using the Default Merge Set. I then added a qualification on the 
class with 'SystemName' !=  $\NULL$ in the Qualification* field. 
 
When I run the job nothing happens. No records get copied to BMC.ASSET.
 
Can I even do something like I am trying to do? Can I restrict a dataset merge 
in this way? Or do I have to merge everything?
 
Thanks.
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are&qu 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: trying to query ARRemedy 6.3 data from ARserver 7.5.....help me with any ideas

[Joe DeSouza]

That is not large enough to create a significant delay (few seconds delay at 
most on unindexed searches) yet not small enough that the query plan would 
ignore indexes if present.. an index on a search would definitely be useful.

You didn't say what the search criteria/qualification was.. I'm assuming a 
table 
field?

Joe




From: gok's 
To: arslist@ARSLIST.ORG
Sent: Tue, March 1, 2011 10:30:19 PM
Subject: Re: trying to query ARRemedy 6.3 data from ARserver 7.5.help me 
with any ideas


My manager didn't want to move the data structures in to the 7.5 database he 
want it keep out side but .user want see only CHG:Change tickets from that 
6.3 data...

I want to see only to view the CHG:Change tickets in 7.5 user tool.


Joe Martin D'Souza wrote:

If the database doesn't have a running AR Server, why not just upgrade it to AR 
System Server 7.5 by installing one and choosing the upgrade option against 
that 
database?

That way the data structures will be of the same version..

I do not have a complete idea of what you are trying to achieve - meaning if  
you want to access this database to just view or modify or ?? So if you 
can give 
a little more of what you are trying to achieve I or someone here might have 
some better views on how to help you..

Joe

-Original Message- 
From: gok's
Sent: Saturday, February 26, 2011 1:20 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: trying to query ARRemedy 6.3 data from ARserver 7.5.help me with 
any ideas

Hi All,

I am trying to query or to search by based on CHG request id from ARSystem 6.3 
to ARSystem 7.5. here ARSystem_6_3 database didn't have any ARServer 
and Mid-tier so I am trying to use Java API ..Here I want some information 
regarding whether I can get the chg ticket information like related tasks and 
attachments to ARSystem 7.5.


Thanks for replies
I do have around 85,370 records  But I switched to use the vendor form hope 
this works.


Joe DeSouza wrote:
 
How many records do you have in that form? What is the query you are using 
to query the data in that form? Are the columns used in the criteria of that 
query indexed in the source data?

Joe

 


From: gok's 
To: arslist@ARSLIST.ORG
Sent: Mon, February 28, 2011 3:45:48 PM
Subject: Re: trying to query ARRemedy 6.3 data from ARserver 7.5.help 
me with any ideas

Thanks for response Sabyson I worked as you said but when I query any records 
it is taking a lot of time some times time out error because I need to get 
related tasks as well and moving the tables  which my manger don't want to do 
it. So i am trying with stored proc to set a parameter value to get the records 
but is it possible to display the related tasks in the task tab in CHG:Change 
form.



Sabyson Fernandes wrote:

You can look into creating a Database link between the 6.3 ARSystem database 
and 
the 7.5 ARSystem database. Then create a database SQL view in the 7.5 database 
that points to the 6.3 database change form. You can then create a view form 
that points to this DB view and you can access the 6.3 change data from within 
Remedy 7.5 .

Sometimes DB links are slow, so for best results I would just copy the relevant 
tables into a separate database within the same database instance as your 7.5 
database and create the view form on top of that.

Hope this helps.

Saby

--- On Sat, 2/26/11, gok's  wrote:

From: gok's 
Subject: Re: trying to query ARRemedy 6.3 data from ARserver 7.5.help me 
with any ideas
To: arslist@ARSLIST.ORG
Date: Saturday, February 26, 2011, 8:15 PM




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: is it possible to get attachments from a vendor form..........

[Joe DeSouza]

Appreciate the explanation..

Joe




From: Misi Mladoniczky 
To: arslist@ARSLIST.ORG
Sent: Wed, March 2, 2011 12:42:38 AM
Subject: Re: is it possible to get attachments from a vendor form..

Hi,

The Vendor-form/ARDBC-functionality does not care about how the data in the 
opposite side is stored.

You have to do the programming to get this BLOB into either a memory buffer or 
on to the servers filesystem before you handle it over to the AR Server through 
ARDBCGetGetEntryBLOB.

Or in the other direction, you will get the file as an uncompress (char *) 
buffer from ARDBCSetEntry/ARDBCCreateEntry to store as you see fit.

        Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.

> My bad... I did mean compression but wrote encryption..
>
> Thanks for the correction..
>
> So if you have a foreign table that contains a blob field that stores
> attachment, can you use a AR Vendor form to retrieve that attachment which
> has
> been compressed using a non Remedy compression method? How would you know
> what
> compression method has been used to store it?
>
> Joe
>
>
>  
>
> 
> From: Misi Mladoniczky 
> To: arslist@ARSLIST.ORG
> Sent: Tue, March 1, 2011 12:23:43 AM
> Subject: Re: is it possible to get attachments from a vendor
> form..
>
> Hi,
>
> You just implement the ARDBCGetEntryBLOB-call in your ARDBC-plugin.
>
> I actually did just that doing a general purpose Documentum-integration
> for
> accessing your documents through the ARUser-interface.
>
> The data is not encrypted, but rather compressed. This is done between the
> client and server, but is allays handled uncompressed when sent to an
> API-program such as an ARDBC-plugin.
>
>         Best Regards - Misi, RRR AB, http://www.rrr.se
>
> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> Find these products, and many free tools and utilities, at http://rrr.se.
>
>> Wouldn't the proprietary encryption that Remedy uses for its attachment
>> create
>>a
>> problem to read attachments stored by some other application in a
>> foreign
> table
>> in a BLOB? Or is the Vendor form functionality smart enough to know that
>> since
>> its not a ARS attachment to use the regular database compression
>> algorithm to
>> read the attachment?
>>
>> Joe
>>
>>  
>>
>> 
>> From: Misi Mladoniczky 
>> To: arslist@ARSLIST.ORG
>> Sent: Mon, February 28, 2011 10:09:29 AM
>> Subject: Re: is it possible to get attachments from a vendor
>> form..
>>
>> Hi,
>>
>> The Vendor-form-functionality (ARDBC) definitely supports the attachment
>> data type, but if ARGetEntryBLOB is fully supported depends on that
>> specific
>> implementation of ARDBC.
>>
>> Are you writing your own plugin or do you make use of one that someone
>> else wrote?
>>
>> Many of the Vendor-forms supplied by BMC only support the bare minimum
>> required of them, depending on their purpose.
>>
>> For example they may have implemented simple qualifications for
>> searching
>> using ARGerListEntryWithFields, but not retrieval of individual records
>> using
>> ARGetEntry. In other words if you do a search in ARUser, you will see
>> the
>> list, but the fields will be blank in the form details.
>>
>>         Best Regards - Misi, RRR AB, http://www.rrr.se
>>
>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
>> logs.
>> Find these products, and many free tools and utilities, at
>> http://rrr.se.
>>
>> hi all,
>>
>> I am trying to get data from out side and most of the data had
>> attachments in
>> .txt and pdf and .doc is it possible to get those through by using
>> the vendor form.
>>
>> Thanks in advance




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: is it possible to get attachments from a vendor form..........

[gok's]

Hi Misi,,

Thanks for response I got small doubt I  have seen  the Class ActiveLink
using this do I can  set the values based on in put parameters passed in to
the tdatabse table.

In brief to query I will pass some parameters so in the Java code based on
the parameter I will query the values from database so at that point in the
Java code to get the values as much quicker can I use any Class ActiveLink
like set field action there so that it will get the values very quickly?.

Thanks

Gokul




Misi Mladoniczky wrote:
> 
> Hi,
> 
> I have used these two configs to copy data from the production server to a
> backup server. One config that runs every 15 and synchronizes everything,
> and one fast config that runs every minute on the forms where most records
> are created.
> 
> Best Regards - Misi, RRR AB, http://www.rrr.se
> 
> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> Find these products, and many free tools and utilities, at http://rrr.se.
> 
> ### Run every 15 minutes, and took around 3 minutes to complete ###
> source_server= kenny1
> source_user  = Demo
> source_password  = ***
> target_server= kenny2
> target_user  = SOURCE
> target_password  = SOURCE
> multipleforms= *
> skipforms= \
>   Application Pending, \
>   Application Statistics, \
>   AR System Licenses Audit, \
>   AR System Licenses, \
>   AR System Log*, \
>   AR System Application State, \
>   Server Events, \
>   Server Statistics
> # Replace source server name with target server name in data
> setfields= \
>   *=ANYWHERE("kenny1", "kenny2"), \
>   *=ANYWHERE("Kenny1", "Kenny2"), \
>   *=ANYWHERE("KENNY1", "KENNY2")
> splitsearch  = YES
> transfertype = SYNCTOTARGET
> logfile  = AUTO
> 
> ### Run every minute, and took about 4 seconds to complete ###
> source_server= kenny1
> source_user  = Demo
> source_password  = ***
> target_server= kenny2
> target_user  = SOURCE
> target_password  = SOURCE
> # List of the forms with a lot of added records
> # Make sure you have an index on 'Create Date' on these forms
> multipleforms= \
>   HelpDesk, \
>   HPD:WorkLog, \
>   ...
> # Sync records created the last 120 second
> # Change 120 to %s to supply the number on the command line as an extra
> arg
> # Make sure to index the Create Date in these forms
> qual = '3' > $TIMESTAMP$ - 120
> # Ensures that no heavy copy operations are performed
> maxrecords   = 100
> # Ensures that no delete operations are performed
> syncmaxdeletedpercent= 0
> transfertype = SYNCTOTARGET
> logfile  = AUTO
> 
>> Hi Misi,
>>
>> Thanks for replay I am almost done with the vendor form it is showing
>> small
>> errors hope i am going to solve them. Where can I get this
>> rrrchive-config-skeleton. please let me know and I went through you're
>> WWRUG09_RRR_LogFilePerformanceTuning.pdf good work keep I really like
>> this
>> I
>> will follow the document.
>>
>> Thanks
>>
>>
>>
>>
>>
>> Misi Mladoniczky wrote:
>>>
>>> Hi,
>>>
>>> No, I can not give you the code. The skeleton program by BMC is a good
>>> starting point.
>>>
>>> I may would actually suggest another solution though, and that is to
>>> synchronize the data between the two servers using DSO.
>>>
>>> Or if you only need read-functionality, you may use RRR|Chive to
>>> synchronize the data on regular interval in one direction. This is easy
>>> to
>>> set up, and version independent. Let me know if you like an
>>> rrrchive-config-skeleton to do this.
>>>
>>> Best Regards - Misi, RRR AB, http://www.rrr.se
>>>
>>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
>>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
>>> logs.
>>> Find these products, and many free tools and utilities, at
>>> http://rrr.se.
>>>
 Hi Misi,

 Thanks for replying to my message. the actual scenario I am using this
 vendor form is I am trying to pull my arsystem 6.3 data which is out
 side
 to
 my current ARSystem 7.5. Te user requirement here is using vendor form
 they
 can get all information related Chg:Change and related tasks hope fully
 I
 think i will try to get that information my doubt is to get that all
 information do I need to write the Plugin in such a way to get all
 information or do I need to tweak the tables doing left outer join
 .can you help me here. if possible can you please please
 give
 me
 the plugin which you created i will check it here.

 Thanks

Data import into BMC_Document class using AIE..?

[rmdusr]

Has anyone tried performing bulk import in BMC_document class using AIE? How
do we include bulk attachments & make them attached into corresponding
attachment field of BMC_Document?
I see there are fields named as 'DocumentAttachment' &
'DocumentAttachment_Pool' which shows up in AIE 'data field mapping' tab
when trying to create a CI class mapping for BMC_Document class.

 
Version specifications: Atrium CMDB 7.6 patch1 on ARS Server 7.5 patch4 &
ITSM 7.0.3 patch9

 
thanks in advance.


--
View this message in context: 
http://ars-action-request-system.1093659.n2.nabble.com/Data-import-into-BMC-Document-class-using-AIE-tp6081160p6081160.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Java script error - security issue

[Axton]

They should really remove the URL parameters used to pass the username and
password.  There is no reason those should EVER be used.  It's a bad thing
to do and it's there due to poor design.  Anything that uses those URL
parameters is also poorly designed.

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 Wed, Mar 2, 2011 at 12:18 AM, Ian Trimnell wrote:

> **
> On 01/03/2011 21:25, Larry Barnes wrote:
>
> We have a Service Request template called "Cabinet", when we attempt to
> open it using the Request Entry link we get a java script error.
> The error displays the users logon id and p/w!  This is the only
> template that is causing us issues.
>
> A modification was made prior to this error showing up.  Some of the
> questions were removed and replaced with different questions.  Once the
> questions were sequenced the mapping was removed and rebuilt; this is
> when the problem started.
> The questions were Single Answer Menu type questions.  One of the
> questions would not display the menu to select from.
>
> Finally we completely rebuilt the SRD and everything is working now but
> my concern is why would the user's name and password be displayed on the
> screen?
>
> Has anyone seen this before?
>
> The Java error is:
>
>An error has occurred in the script on this page.
>
> Line:  123
> Char:   22
> Error:   Unterminated string constant
> Code:   0
> 
> URL:http://remedyweb/arsys/plugins/SRMSServiceRequestGrowser/params?name=&se
> rver=remedy%2Exxx%2Ecom&username=tester&pwd=tmp1234&auth=&fieldid=30
> 2899
>   
>   
> Do you want to continue   Yes  or No
>
> The actual password and user name are displayed on the screen!
>
>
> Thanks for your time,
>
> Larry B.
>
>  Hi Larry,
>
> You don't say which version of the server you are running.  When we first
> installed 7.5, when it was released, we noticed that the user details were
> being passed through to web calls (flashboards, images, view fields, etc.)
> and also appearing in log files (especially the active link log file).  We
> raised this with BMC and it was fixed during a patch release (I think it was
> there by patch 004, but am not entirely sure).
>
> I have check the BMC support site and it looks as though it was fixed at
> patch 003 of 7.5.00.
>
> If you are using a version of AR System server later than this then it
> looks as though they have exposed the old error again.
>
> Hope this helps in some way,
>  Ian
> --
> Ian Trimnell, Systems Programmer, Client Systems
> Distributed Systems, Information Technology
> Open University, MILTON KEYNES, UK
> Phone: 01908 653741   web: http://www.open.ac.uk/
> The Open University is incorporated by Royal Charter (RC 000391), an exempt
> charity in England & Wales and a charity registered in Scotland (SC 038302).
>  _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"

Abydos Analyser 5.2 Released

[Mark Herring]

Dear Listers,

 

Abydos are pleased to announce the release of Abydos Analyser 5.2.

 

Abydos Analyser 5.2 is now available for download from the Abydos website at
www.abydos-workflow.com

 

This new release includes a complete overhaul of the Event Diagram to
provide an extensive range of options to control the output and presentation
of workflow events. This includes:

 

a) filtering options on diagram contents based on execution order range,
field references, run-if conditions, keywords or text strings

b) explosion of diagram to show workflow impact on other forms where there
is a knock-on effect which causes workflow to fire elsewhere

c) ability to save and re-load diagram settings

d) show disabled workflow (greyed out)

e) highlight actions that commonly spawn other workflow;

 

These new features will further improve the time savings for Remedy
Administrators and support staff in analysing, documenting and
trouble-shooting Remedy-based applications.


For more information or to download a free trial, visit the Abydos Analyser
Product Page
   

 

Kind Regards

Mark Herring

 

USA: Toll Free: 1-866-635-4358

Outside US: +44 (0)1582 400127

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Trying not to Merge a whole dataset?

[sphilben]

**
All:
 
I have two datasets (A and B). I want to merge all of dataset A to BMC.ASSET but only those in dataset B that are related to CIs in A. So after my ID job I ran a relationship job that created HOSTEDSYSTEMCOMPONENT entries and filled in the SystemName field on B. Can I use that field now to restrict the merge on B?
 
I tried setting up a merge job on B with one activity: merge source B to BMC.ASSET using the Default Merge Set. I then added a qualification on the class with 'SystemName' !=  $\NULL$ in the Qualification* field. 
 
When I run the job nothing happens. No records get copied to BMC.ASSET.
 
Can I even do something like I am trying to do? Can I restrict a dataset merge in this way? Or do I have to merge everything?
 
Thanks.
_attend WWRUG11 www.wwrug.com  ARSlist: "Where the Answers Are"_

Re: Huge queries hogging up the database

[Misi Mladoniczky]

Hi,

I would use RRR|Log to analyze a ~1Gb ESCL/API/FLTR/SQL-log snapshot on
Monday, Wednesday and Friday, to be able to see the difference in the
server activity.

Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.

> hi,
>
> We see this issue on every Monday after the deployment and it resolves by
> itself by Wednesday after the deployment is done on Saturday . I am
> checking
> the other interfaces that might have an impact as well.
>
> Thanks,
> Vikram
>
> Misi Mladoniczky wrote:
>>
>> Hi,
>>
>> No you don't have the "%zzz%".
>>
>> You have a "zzz%", which is an entirely different thing, and will allow
>> usage of indexes.
>>
>> It is the leading match in the LIKE "%zzz%" that prevents the index from
>> being used.
>>
>> Admin changes can take a lot of resources from the server in the period
>> right after the change, to allow for the server to recache all
>> definitions. Typically less than 10 minutes will be needed.
>>
>> Admin changes will require the clients to recache as well, which may
>> slow
>> things down slightly, but should not prevent the database from using
>> indexes.
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se
>>
>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
>> logs.
>> Find these products, and many free tools and utilities, at
>> http://rrr.se.
>>
>>> hi Doug,
>>>
>>> Thanks for the reply as always lot of knowledge shared. You are right I
>>> picked this query from TOAD application and hence the SYS_B_XX variable
>>> comes into the picture. I was able to catch the query from SQL logs and
>>> its
>>> pasted below :
>>>
>>>
>>> >> 390620   >  /* Mon Feb 28 2011
>>> 08:46:16.9857 */ SELECT
>>> T28.C1,C600011000,C536870984,C536870913,C900106001,C901050057,C536871019,C900200400,C536870958,C536870950,C900170325,C536870935,C90013,C536870929,C536870931,C536870914,C536871018,C536870938,C65000,C536870952,C536871025,C536871038,C53690,C536870912,C7,C900040206,C901092014,C900110076,C536870987,C901170021,C536870957
>>> FROM T28 WHERE (((T28.C112 LIKE '%;44451;%') OR ((T28.C112 LIKE
>>> '%;44450;%') OR ((T28.C112 LIKE '%;999;%') OR ((T28.C112 LIKE
>>> '%;500014;%') OR ((T28.C112 LIKE '%;500013;%') OR ((T28.C112 LIKE
>>> '%;50;%') OR ((T28.C112 LIKE '%;50098;%') OR ((T28.C112 LIKE
>>> '%;99986;%') OR ((T28.C112 LIKE '%;99986;%') OR ((T28.C112 LIKE
>>> '%;99989;%')
>>> OR ((T28.C112 LIKE '%;99930;%') OR ((T28.C112 LIKE '%;99985;%') OR
>>> ((T28.C112 LIKE '%;99931;%') OR ((T28.C112 LIKE '%;99925;%') OR
>>> ((T28.C112
>>> LIKE '%;99906;%') OR ((T28.C112 LIKE '%;99928;%') OR ((T28.C112 LIKE
>>> '%;99957;%') OR ((T28.C112 LIKE '%;99932;%') OR ((T28.C112 LIKE
>>> '%;99929;%')
>>> OR ((T28.C112 LIKE '%;99921;%') OR ((T28.C112 LIKE '%;99926;%') OR
>>> ((T28.C112 LIKE '%;99902;%') OR ((T28.C112 LIKE '%;99950;%') OR
>>> ((T28.C112
>>> LIKE '%;99924;%') OR ((T28.C112 LIKE '%;44407;%') OR ((T28.C112 LIKE
>>> '%;99960;%') OR ((T28.C112 LIKE '%;99922;%') OR ((T28.C112 LIKE
>>> '%;0;%')
>>> OR ((T28.C112 LIKE '%;44405;%') OR ((T28.C112 LIKE '%;44404;%') OR
>>> ((T28.C112 LIKE '%;44418;%') OR ((T28.C112 LIKE '%;44418;%') OR
>>> ((T28.C112
>>> LIKE '%;99923;%') OR ((T28.C112 LIKE '%;99908;%') OR ((T28.C112 LIKE
>>> '%;99904;%') OR ((T28.C112 LIKE '%;99927;%') OR ((T28.C112 LIKE
>>> '%;99939;%')
>>> OR ((T28.C112 LIKE '%;99971;%') OR ((T28.C112 LIKE '%;1;%') OR
>>> ((T28.C112 LIKE '%;99901;%') OR ((T28.C112 LIKE '%;99905;%') OR
>>> ((T28.C112
>>> LIKE '%;99941;%') OR ((T28.C112 LIKE '%;99958;%') OR ((T28.C112 LIKE
>>> '%;99907;%') OR ((T28.C112 LIKE '%;99953;%') OR ((T28.C112 LIKE
>>> '%;44406;%')
>>> OR ((T28.C112 LIKE '%;99987;%') OR ((T28.C112 LIKE '%;99903;%') OR
>>> ((T28.C112 LIKE '%;99988;%') OR ((T28.C112 LIKE '%;99951;%') OR
>>> ((T28.C112
>>> LIKE '%;99972;%') OR ((T28.C112 LIKE '%;500012;%') OR ((T28.C112 LIKE
>>> '%;50045;%') OR ((T28.C112 LIKE '%;50048;%') OR ((T28.C112 LIKE
>>> '%;500011;%') OR ((T28.C112 LIKE '%;500010;%') OR ((T28.C112 LIKE
>>> '%;666;%')
>>> OR ((T28.C112 LIKE '%;59;%') OR ((T28.C112 LIKE '%;58;%') OR
>>> ((T28.C112 LIKE '%;57;%') OR ((T28.C112 LIKE '%;50046;%') OR
>>> ((T28.C112
>>> LIKE '%;56;%') OR ((T28.C112 LIKE '%;55;%') OR ((T28.C112 LIKE
>>> '%;54;%') OR ((T28.C112 LIKE '%;53;%') OR ((T28.C112 LIKE
>>> '%;52;%') OR ((T28.C112 LIKE '%;51;%') OR ((T28.C112 LIKE
>>> '%;0;%')
>>> OR ((T28.C112 LIKE '%;2005000;%') OR ((T28.C112 LIKE '%;655;%') OR
>>> ((T28.C112 LIKE '%;20017;%') OR ((T28.C112 LIKE '%;652;%') OR
>>> ((T28.C112
>>> LIKE '%;671;%') OR (T28.C11

Re: Huge queries hogging up the database

[vikram_k]

hi,

We see this issue on every Monday after the deployment and it resolves by
itself by Wednesday after the deployment is done on Saturday . I am checking
the other interfaces that might have an impact as well.

Thanks,
Vikram 

Misi Mladoniczky wrote:
> 
> Hi,
> 
> No you don't have the "%zzz%".
> 
> You have a "zzz%", which is an entirely different thing, and will allow
> usage of indexes.
> 
> It is the leading match in the LIKE "%zzz%" that prevents the index from
> being used.
> 
> Admin changes can take a lot of resources from the server in the period
> right after the change, to allow for the server to recache all
> definitions. Typically less than 10 minutes will be needed.
> 
> Admin changes will require the clients to recache as well, which may slow
> things down slightly, but should not prevent the database from using
> indexes.
> 
> Best Regards - Misi, RRR AB, http://www.rrr.se
> 
> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> Find these products, and many free tools and utilities, at http://rrr.se.
> 
>> hi Doug,
>>
>> Thanks for the reply as always lot of knowledge shared. You are right I
>> picked this query from TOAD application and hence the SYS_B_XX variable
>> comes into the picture. I was able to catch the query from SQL logs and
>> its
>> pasted below :
>>
>>
>> > 390620   >  /* Mon Feb 28 2011
>> 08:46:16.9857 */ SELECT
>> T28.C1,C600011000,C536870984,C536870913,C900106001,C901050057,C536871019,C900200400,C536870958,C536870950,C900170325,C536870935,C90013,C536870929,C536870931,C536870914,C536871018,C536870938,C65000,C536870952,C536871025,C536871038,C53690,C536870912,C7,C900040206,C901092014,C900110076,C536870987,C901170021,C536870957
>> FROM T28 WHERE (((T28.C112 LIKE '%;44451;%') OR ((T28.C112 LIKE
>> '%;44450;%') OR ((T28.C112 LIKE '%;999;%') OR ((T28.C112 LIKE
>> '%;500014;%') OR ((T28.C112 LIKE '%;500013;%') OR ((T28.C112 LIKE
>> '%;50;%') OR ((T28.C112 LIKE '%;50098;%') OR ((T28.C112 LIKE
>> '%;99986;%') OR ((T28.C112 LIKE '%;99986;%') OR ((T28.C112 LIKE
>> '%;99989;%')
>> OR ((T28.C112 LIKE '%;99930;%') OR ((T28.C112 LIKE '%;99985;%') OR
>> ((T28.C112 LIKE '%;99931;%') OR ((T28.C112 LIKE '%;99925;%') OR
>> ((T28.C112
>> LIKE '%;99906;%') OR ((T28.C112 LIKE '%;99928;%') OR ((T28.C112 LIKE
>> '%;99957;%') OR ((T28.C112 LIKE '%;99932;%') OR ((T28.C112 LIKE
>> '%;99929;%')
>> OR ((T28.C112 LIKE '%;99921;%') OR ((T28.C112 LIKE '%;99926;%') OR
>> ((T28.C112 LIKE '%;99902;%') OR ((T28.C112 LIKE '%;99950;%') OR
>> ((T28.C112
>> LIKE '%;99924;%') OR ((T28.C112 LIKE '%;44407;%') OR ((T28.C112 LIKE
>> '%;99960;%') OR ((T28.C112 LIKE '%;99922;%') OR ((T28.C112 LIKE
>> '%;0;%')
>> OR ((T28.C112 LIKE '%;44405;%') OR ((T28.C112 LIKE '%;44404;%') OR
>> ((T28.C112 LIKE '%;44418;%') OR ((T28.C112 LIKE '%;44418;%') OR
>> ((T28.C112
>> LIKE '%;99923;%') OR ((T28.C112 LIKE '%;99908;%') OR ((T28.C112 LIKE
>> '%;99904;%') OR ((T28.C112 LIKE '%;99927;%') OR ((T28.C112 LIKE
>> '%;99939;%')
>> OR ((T28.C112 LIKE '%;99971;%') OR ((T28.C112 LIKE '%;1;%') OR
>> ((T28.C112 LIKE '%;99901;%') OR ((T28.C112 LIKE '%;99905;%') OR
>> ((T28.C112
>> LIKE '%;99941;%') OR ((T28.C112 LIKE '%;99958;%') OR ((T28.C112 LIKE
>> '%;99907;%') OR ((T28.C112 LIKE '%;99953;%') OR ((T28.C112 LIKE
>> '%;44406;%')
>> OR ((T28.C112 LIKE '%;99987;%') OR ((T28.C112 LIKE '%;99903;%') OR
>> ((T28.C112 LIKE '%;99988;%') OR ((T28.C112 LIKE '%;99951;%') OR
>> ((T28.C112
>> LIKE '%;99972;%') OR ((T28.C112 LIKE '%;500012;%') OR ((T28.C112 LIKE
>> '%;50045;%') OR ((T28.C112 LIKE '%;50048;%') OR ((T28.C112 LIKE
>> '%;500011;%') OR ((T28.C112 LIKE '%;500010;%') OR ((T28.C112 LIKE
>> '%;666;%')
>> OR ((T28.C112 LIKE '%;59;%') OR ((T28.C112 LIKE '%;58;%') OR
>> ((T28.C112 LIKE '%;57;%') OR ((T28.C112 LIKE '%;50046;%') OR
>> ((T28.C112
>> LIKE '%;56;%') OR ((T28.C112 LIKE '%;55;%') OR ((T28.C112 LIKE
>> '%;54;%') OR ((T28.C112 LIKE '%;53;%') OR ((T28.C112 LIKE
>> '%;52;%') OR ((T28.C112 LIKE '%;51;%') OR ((T28.C112 LIKE
>> '%;0;%')
>> OR ((T28.C112 LIKE '%;2005000;%') OR ((T28.C112 LIKE '%;655;%') OR
>> ((T28.C112 LIKE '%;20017;%') OR ((T28.C112 LIKE '%;652;%') OR ((T28.C112
>> LIKE '%;671;%') OR (T28.C112 LIKE
>> '%;0;%'))
>> AND (T28.C536870913 LIKE '101200140%')) ORDER BY 1 ASC
>>
>>
>> We have a lot of users in lot of groups and hence we have high number of
>> LIKE clauses.
>> As you can see we have "%zzz% as you mentioned in your post which will
>> cause
>> a complete table scan. Right now we are trying 2 things :
>>
>> a) Find the workflow that tends to fire this query and
>> b) Try and find a way to minimize the groups every user belongs. Can
>> computed groups be a good option for this and is it supported for ARS
>> 5.0.1.? 

Java script error - security issue

[John Baker]

Ian,

When you say 'fixed', how was it fixed? The last time I looked, the
username/password were still being passed from WUT to MT in the clear -
albeit a slightly scrambled clear, but still clear.


John
-- 
Single sign On for AR System
http://www.javasystemsolutions.com/jss/ssoplugin

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"