Re: Data Wizard locked in Pending

[lars . j . pettersson]

Thanks for that info, I’m sure this will solve the problem ☺ // Lars

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Karicheti anil kumar
Sent: Friday, July 08, 2016 9:43 AM
To: arslist@ARSLIST.ORG
Subject: Re: Data Wizard locked in Pending

**
Hi Lars,

You can manually delete the Lock record on the form DLD:Lock to initiate new 
operation.

Regards,
Anil Kumar K
https://www.facebook.com/RemedyRockStars/


On Fri, Jul 8, 2016 at 12:47 PM, 
> 
wrote:
**
Hi, some days ago, an update action was started in Data Wizard. Status still in 
Pending.

This prevents a new update action to be started.

[cid:image001.png@01D1D902.8F6296A0]


This comes when a new update is started:

[cid:image002.png@01D1D902.8F6296A0]

Re-Run does not help.

How to cancel the failing update?

Best regards, Lars, Vattenfall
_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Data Wizard locked in Pending

[lars . j . pettersson]

Hi, some days ago, an update action was started in Data Wizard. Status still in 
Pending.

This prevents a new update action to be started.

[cid:image001.png@01D1D8F8.F0BEF330]


This comes when a new update is started:

[cid:image002.png@01D1D8F9.83CAD720]

Re-Run does not help.

How to cancel the failing update?

Best regards, Lars, Vattenfall

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: ITSM Datawizard its forms and usage

[lars . j . pettersson]

Hi, I'm also interested to get a complete list of forms. I would also like to 
know if entries in all statues are updated by the Data Wizard (Obsolete, 
Offline and the other ones), or for some forms maybe only Enabled entries are 
updated?

// Lars, Vattenfall.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rüdiger Tams
Sent: Tuesday, February 23, 2016 9:18 AM
To: arslist@ARSLIST.ORG
Subject: ITSM Datawizard its forms and usage

Dear Listers,

We have this an installation: ARS 8.1.2 and ITSM 8.1.2, MS SQL Server 2012

When I look into the form DLD:SYS:DataWizardProductStatus I can see all the 
forms that are processed by the DataWizard when e.g. renaming a Company Name.

I was wondering what specific forms are behind the entries
- Foundation forms
- CMDB forms
- Asset forms
- Change forms
- Help Desk forms
- Problem forms
- Service Request Configuration forms
- Service Request Management forms
- etc.

Does anybody knows about a documentation for these forms?

Thanks!

Regards
Rüdiger

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers 
Are, and have been for 20 years"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Data Wizard Tool / Sites

[lars . j . pettersson]

Hi, it seems that we need to rename some sites in our ITSM system, 7.6.

Have you used the Data Wizard Tool in this situation, if so, have you seen any 
issues, or are all forms handled correctly?

The alternative, to do it manually is a huge task.

Hope for some feedback :)

// Lars, Vattenfall, Sweden





___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Row level access in ITSM

[lars . j . pettersson]

Yes, people belonging to a special team should be restricted from public access 
to entries. Not only for Incidents, I guess also for CI's...Problems, Changes...

They need access to the different companies we have, so therefore the company 
restriction does not work.

Maybe more easy to take down the sun than configure this...:)

// Lars

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Friday, October 23, 2015 11:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Row level access in ITSM

Hi,

When we discussed this earlier I understood that the group you want to give 
limited access is an external Vendor.

Field 60900 is called Vendor Assignee Group, which seems to imply that it is 
intended for this.

What is also important is that 112 is not set to Public, as this would prevent 
field 60900 to have any affect for those tickets.

Note that I have very limited knowledge about ITSM, and what can be configured. 
I have just looked at the permissions on field id 1 and a little on the 
workflow attached to field 112 and 60900. To me it seems that someone intended 
the OOB functionality to work exactly as you desired, but I do not know if it 
all got implemented...

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* 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,
>
> I have worked on row level access where company A can not see 
> incidents of company B. To do that you have to do customization very 
> carefully so that it doesnt break other functionality which is dependent on 
> that.
> You can work with two fields , 112 and 60900 which is used for row 
> level access. there are few workflows which sets the company 
> permission group ids into this fields and you can have look at the 
> logs and alter the workflow based on you need.
>
> Regards,
> Jayesh
>
> On Thu, Oct 22, 2015 at 1:25 PM,  wrote:
>
>> **
>>
>> Hi, we have an ARS system built ourselves, where we have implemented 
>> Row Level Access by changing permission for field 1 and using dynamic groups.
>>
>> This makes it possible to only allow access for users to entries that 
>> they are allowed to see.
>>
>>
>>
>> In our ITSM system, all Incidents for example can be accessed by all 
>> users. We have no possibility to use company restrictions.
>>
>>
>>
>> I wonder if anyone has been able to implement row level access in 
>> ITSM as described? If so, how did you solve it?
>>
>>
>>
>> Best regards, Lars, Vattenfall Sweden.
>>
>>
>>
>>
>> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
> __
> _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> "Where the Answers Are, and have been for 20 years"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers 
Are, and have been for 20 years"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Row level access in ITSM

[lars . j . pettersson]

Hi, we have an ARS system built ourselves, where we have implemented Row Level 
Access by changing permission for field 1 and using dynamic groups.
This makes it possible to only allow access for users to entries that they are 
allowed to see.

In our ITSM system, all Incidents for example can be accessed by all users. We 
have no possibility to use company restrictions.

I wonder if anyone has been able to implement row level access in ITSM as 
described? If so, how did you solve it?

Best regards, Lars, Vattenfall Sweden.



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Join forms in ITSM

[lars . j . pettersson]

Hi, I have created some outer join forms in an 'add-on module' besides ITSM.

I have used AST:BusinessService and AST:AssetPeople
And AST:BusinessService and FIN:CostAssociationJoin

The meaning is to make a report for Business Services and Relations, and 
Business Services with/without costs.

Seems to works fine, but would it have been more correct if I had used 
BMC.CORE:BMC_BaseElement instead of AST:BusinessService?

The number of entries returned when searching is the same if I use DataSetID 
BMC.ASSET in BMC.CORE:BMC_BaseElement

Best regards, Lars, Vattenfall Sweden

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Currency field

[lars . j . pettersson]

Hi, is this as designed or a bug?

I have a report including a Currency field. If I generate the report to screen, 
I get this result:

[cid:image001.png@01D0754A.706DD420]

'Value' has been selected:

[cid:image002.png@01D0754A.706DD420]

But report to CSV file sends all data from the field:

[cid:image003.png@01D0754A.706DD420]

ITSM 7.6

// Lars

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

SQL help

[lars . j . pettersson]

Hi group, I have this sql, working fine:

SELECT distinct (PeopleGroup_Form_Entry_ID) from VATT_HelpTool___Join___AssetPe 
where AssetLifecycleStatus = 3 and Data_Set_Id = 'BMC.ASSET' and 
PeopleGroup_Form_Entry_ID like 'SGP%'

Now I would like to include number of entries for each unique match.

Like this:

SGP000216, 164
SGP000512, 12

How can that be arranged?

Thanks in advance

Lars, Vattenfall, Sweden


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Swedish date format in Remedy ITSM web-application

[lars . j . pettersson]

Hi, I dislike the American date format that I have now, and want it like this:

2014-09-10 12:22:30

I have tried to change in the user pref form with syntax -mm-dd HH:mm:ss

But that gave this strange result: Look at Last Modified Date...

[cid:image001.png@01CFCD39.207DA990]

Anyone who knows what to do to fix this?

Thanks in advance,

Lars

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Re: Swedish date format in Remedy ITSM web-application

[lars . j . pettersson]

Fredric, this is my national settings on my pc: Svenska = Swedish is set as you 
can see.

[cid:image002.png@01CFCD3F.9997F460]

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, September 10, 2014 9:10 PM
To: arslist@ARSLIST.ORG
Subject: Re: Swedish date format in Remedy ITSM web-application

**
Is your PC set to use the Swedish format?

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of 
lars.j.petters...@vattenfall.commailto:lars.j.petters...@vattenfall.com
Sent: Wednesday, September 10, 2014 1:52 PM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Swedish date format in Remedy ITSM web-application

**
Hi, I dislike the American date format that I have now, and want it like this:

2014-09-10 12:22:30

I have tried to change in the user pref form with syntax -mm-dd HH:mm:ss

But that gave this strange result: Look at Last Modified Date...

[cid:image003.png@01CFCD3F.9997F460]

Anyone who knows what to do to fix this?

Thanks in advance,

Lars


_ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Http to https

[lars . j . pettersson]

Hi, we have changed from http to a secure link, https (redirecting) for our 
web-application, but after that we got some strange behaviours...For example

An AL opening a form in new mode, now opens it in search mode...some links of 
the same type works, as they have worked for years before the change.
Some Attachments can no longer be opened or seen in a view field.
Double click on a row in a table field opens the form with empty fields...

I have flushed the MidTier cache, also the local pc cache ans restarted the 
windows servers, tried with IE and FireFox
I have also changed the default web path to https in ar.cfg

´7.6.04

Any idea anyone?

// Best regards, L ars



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

SV: Http to https

[lars . j . pettersson]

 Yes, first we didn't touch ar.cfg, but then I have tried with https there too, 
does not help. // Lars

-Ursprungligt meddelande-
Från: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] För John Baker
Skickat: den 24 mars 2014 22:39
Till: arslist@ARSLIST.ORG
Ämne: Http to https

Have you changed the Default-Web-Path in ar.cfg?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers 
Are, and have been for 20 years

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

SV: Http to https

[lars . j . pettersson]

 I have right now turned on the AL loggning and performed the actions which 
cause strange behaviour, I will tomorrow analyze the logs and see if something 
is seen there. // Lars

-Ursprungligt meddelande-
Från: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] För John Baker
Skickat: den 24 mars 2014 22:54
Till: arslist@ARSLIST.ORG
Ämne: SV: Http to https

Email me a Fiddler trace. I'll take a look.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers 
Are, and have been for 20 years

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Solution time / Incident

[lars . j . pettersson]

Hi list, is it possible OOTB to calculate the difference Submit date - Resolved 
date using one common business time 8-17 entry and include this in a report for 
Incidents? Not only if SLA is passed or not.

Best regards, Lars




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Format outgoing emails

[lars . j . pettersson]

Hi, In 'Tabasco', home build application, I use form 'Ar System Email 
Templates' in notification filters to get formatted emails, with colors, bold 
text and things like that. Works fine. But in ITSM ? For assignment and 
confirmation mails to customers? How do I solve it there, using HTML code for 
outgoing emails?

// Lars


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

SV: Slow import

[lars . j . pettersson]

Server reboot helped, now fast as expected…☺

// Lars



Från: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] För Danny Kellett
Skickat: den 14 augusti 2013 09:48
Till: arslist@ARSLIST.ORG
Ämne: Re: Slow import

**
Lars

Have you run this query outside the AR system? E.g. Through SQLplus / SQL query 
analyser?

Regards
Danny

On 14 Aug 2013, at 07:31, 
lars.j.petters...@vattenfall.commailto:lars.j.petters...@vattenfall.com wrote:
**
Hi, I have problem using the import tool, it can take 10 seconds to import one 
entry from a file…this has worked fine before with the same code.

We have isolated to problem to the sql below, which is run several 
times/record, and this sql takes a lot of time.

T1 is Ar System Message Catalog

There is one index for this form which has been rebuilt without any better 
performance


SELECT T1.C1,C152,C155,C156 FROM T1 WHERE ((T1.C8 = '302') AND (T1.C7
= 0) AND
(T1.C150 = 0) AND ((T1.C152 LIKE 'SVE%') OR (T1.C152 IS NULL))) ORDER
BY C152 ASC, 1 ASC


Any ideas?

7.6.04

// BR Lars

_ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Slow import

[lars . j . pettersson]

Hi, I have problem using the import tool, it can take 10 seconds to import one 
entry from a file...this has worked fine before with the same code.

We have isolated to problem to the sql below, which is run several 
times/record, and this sql takes a lot of time.

T1 is Ar System Message Catalog

There is one index for this form which has been rebuilt without any better 
performance


SELECT T1.C1,C152,C155,C156 FROM T1 WHERE ((T1.C8 = '302') AND (T1.C7
 = 0) AND
 (T1.C150 = 0) AND ((T1.C152 LIKE 'SVE%') OR (T1.C152 IS NULL))) ORDER
 BY C152 ASC, 1 ASC


Any ideas?

7.6.04

// BR Lars


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

One problem to solve...

[lars . j . pettersson]

I'm building a HelpTool besides ITSM, when removing a user from a Support 
Group, or inactivate a Support Group, checking open objects like inc, changes, 
problems, auto-routing and things like that.

But, how to find Templates authorized for a Support Group, or, is that not 
needed, if status for the Support Group is set to Offline or Obsolete when all 
open tickets have been handled, there is ITSM code taking care of templates 
authorized for Support Groups...?

// Lars


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Check for open Changes

[lars . j . pettersson]

Hi, status in CHG:Infrastructure Change, db name z1D Status is a display only 
field, not available in the field list in dev studio, so how do I write code to 
check for open Changes...(Not Closed, Cancelled, Rejected or Completed)

Any idea? No problens in incidents, as status is a regular field there.

// Lars


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

SV: Check for open Changes

[lars . j . pettersson]

Thanks Jacques, I will try that :)

// L ars


Från: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] För Andre, Jacques
Skickat: den 13 juni 2013 09:45
Till: arslist@ARSLIST.ORG
Ämne: Re: Check for open Changes

**
Hi Lars,

The field you need to query against is Change Request Status with the DB name 
of Status* (Field ID 7) which is hidden at the bottom of the 
CHG:Infrastructure Change form.

Kind regards

Jacques Andre


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of lars.j.petters...@vattenfall.com
Sent: 13 June 2013 08:31
To: arslist@ARSLIST.ORG
Subject: Check for open Changes

**
Hi, status in CHG:Infrastructure Change, db name z1D Status is a display only 
field, not available in the field list in dev studio, so how do I write code to 
check for open Changes...(Not Closed, Cancelled, Rejected or Completed)

Any idea? No problens in incidents, as status is a regular field there.

// Lars

_ARSlist: Where the Answers Are and have been for 20 years_

This message contains information which may be confidential and/or privileged. 
Unless you are the intended recipient (or authorized to receive for the 
intended recipient), you may not read, use, copy or disclose to anyone the 
message or any information contained in the message. If you have received the 
message in error, please advise the sender by reply e-mail and delete the 
message and any attachment(s) thereto without retaining any copies.
_ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

SV: Alias in ITSM

[lars . j . pettersson]

 Great, very helpful :)

-Ursprungligt meddelande-
Från: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] För Misi Mladoniczky
Skickat: den 13 juni 2013 10:58
Till: arslist@ARSLIST.ORG
Ämne: Re: Alias in ITSM

Hi,

Here is the direct access URL for the Alias lookup:
https://rrr.se/cgi/alias

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12):
* 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.

 are you guys aware of the alias lookup capability on RRR.se?...it has 
 multiple ITSM versions and everything.


 On Wed, Jun 12, 2013 at 12:28 PM, Kemes, Lisa A DLA CTR INFORMATION 
 OPERATIONS lisa.kemes@dla.mil wrote:

 I'd love to see it when you are finished.  Would be a nice reference 
 to have.

 Lisa

 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arslist@ARSLIST.ORG] On Behalf Of 
 lars.j.petters...@vattenfall.com
 Sent: Wednesday, June 12, 2013 2:08 PM
 To: arslist@ARSLIST.ORG
 Subject: Alias in ITSM

 **
 Hej, just annoying I think when a form has a visible name in the user 
 tool, but another name in dev studio, not easy to find the matching 
 form I think.
 And, db name is often the same as label, but sometimes a total 
 different one, many fields has also the same label name, makes it 
 diffucult when making reports...

 I'm builing a helptool for ITSM, and have been aware of this now.

 // Lars

 _ARSlist: Where the Answers Are and have been for 20 years_


 _
 __ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
 Where the Answers Are, and have been for 20 years


 __
 _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
 Where the Answers Are, and have been for 20 years


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers 
Are, and have been for 20 years

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Alias in ITSM

[lars . j . pettersson]

Hej, just annoying I think when a form has a visible name in the user tool, but 
another name in dev studio, not easy to find the matching form I think.
And, db name is often the same as label, but sometimes a total different one, 
many fields has also the same label name, makes it diffucult when making 
reports...

I'm builing a helptool for ITSM, and have been aware of this now.

// Lars


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

SV: Alias in ITSM

[lars . j . pettersson]

Yes, I will try misi's tool. The helptooll will check for open objects when 
removing a team member from a support group for exampe. To just remove if 
he/she has open inc, problems, changes sems wrong to me, first close or reassin 
the ticksts,, then remove..the user, the helptool is 100% besides itsm module. 
// Lars



Från: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] För Longwing, Lj
Skickat: den 12 juni 2013 20:34
Till: arslist@ARSLIST.ORG
Ämne: Re: Alias in ITSM

**
are you guys aware of the alias lookup capability on RRR.se?...it has multiple 
ITSM versions and everything.


On Wed, Jun 12, 2013 at 12:28 PM, Kemes, Lisa A DLA CTR INFORMATION OPERATIONS 
lisa.kemes@dla.milmailto:lisa.kemes@dla.mil wrote:
I'd love to see it when you are finished.  Would be a nice reference to
have.

Lisa

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of
lars.j.petters...@vattenfall.commailto:lars.j.petters...@vattenfall.com
Sent: Wednesday, June 12, 2013 2:08 PM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Alias in ITSM

**
Hej, just annoying I think when a form has a visible name in the user
tool, but another name in dev studio, not easy to find the matching form
I think.
And, db name is often the same as label, but sometimes a total different
one, many fields has also the same label name, makes it diffucult when
making reports...

I'm builing a helptool for ITSM, and have been aware of this now.

// Lars

_ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at 
www.arslist.orghttp://www.arslist.org
Where the Answers Are, and have been for 20 years

_ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

SV: SV: SV: Permission template?

[lars . j . pettersson]

 Okey Lisa, all users are in the Peoples form, so no new users. I guess that if 
only two users is be added to a group, then it's faster to make it manually, 
but not if 20 should be added. I got contacted about a tool called 'Meta 
Update', at least I can check what that tool can. // Lars

-Ursprungligt meddelande-
Från: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] För Lisa Singh
Skickat: den 14 maj 2013 16:29
Till: arslist@ARSLIST.ORG
Ämne: Re: SV: SV: Permission template?

On 5/13/13, Jlbess jlb...@yahoo.com wrote:
 Are they new users or existing users? If they're new users, you can 
 create a people template with all of that information. Then just 
 create new accounts specifying their name and contact info.
 If they're existing users, you can use the data management tool. Just 
 fill out the spreadsheet tabs for permissions, group assignments, and 
 functional roles.

I think you can use the people management console to update people records with 
a template as well, I just noticed an error with trying to apply some 
Functional Roles to an existing user, so I'm about to test the update function 
from the people management console - will let you know if that works.

Kind Regards,

Lisa Singh

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers 
Are, and have been for 20 years

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

SV: Permission template?

[lars . j . pettersson]

Well, I have to add 20 users to a new support group, some things in itsm does 
not impress me...:)


Från: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] För Pierson, Shawn
Skickat: den 13 maj 2013 13:27
Till: arslist@ARSLIST.ORG
Ämne: Re: Permission template?

**
People Templates only apply when you are creating new people.  If you are 
setting up people who already exist, you can't apply a template.  
Unfortunately, without the ability to customize, you're going to have a tough 
time getting past this one.

Thanks,

Shawn Pierson
Remedy Developer | Energy Transfer

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of lars.j.petters...@vattenfall.com
Sent: Monday, May 13, 2013 12:42 AM
To: arslist@ARSLIST.ORG
Subject: SV: Permission template?

**
oki, If I had right to create own workflow, but a decision has been made only 
to make minimal with changes, run ootb...

I will look at the People Template and how it works. // Lars


Från: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] För Joe D'Souza
Skickat: den 13 maj 2013 06:30
Till: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Ämne: Re: Permission template?
**

Create some sort of a staging form for adding new users and create workflow 
there to create entries required in the CTM:People Permissions Group.



The OTB filters on that form will take care of the rest.



Joe


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of 
lars.j.petters...@vattenfall.commailto:lars.j.petters...@vattenfall.com
Sent: Sunday, May 12, 2013 11:52 PM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Permission template?

Hi, is there a way to use some kind of 'Template' when creating new team 
members in support groups? To manually add application permissions, companies 
and functional roles takes a lot of time. Just create a basic profile, then 
manually add special permissions.

Best regards, Lars
_ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where 
the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_
Private and confidential as detailed 
herehttp://www.energytransfer.com/mail_disclaimer.aspx. If you cannot access 
hyperlink, please e-mail sender. _ARSlist: Where the Answers Are and have 
been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

SV: SV: Permission template?

[lars . j . pettersson]

Yes, but still add Companies (8) and Applications permissions (10), and 
functional roles (3) * 20...Many clicks...:)


Från: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] För Tauf Chowdhury
Skickat: den 13 maj 2013 15:33
Till: arslist@ARSLIST.ORG
Ämne: Re: SV: Permission template?

**
For something like support group, you can go to the ctm:support group form and 
click Add on People tab. If you do a search that returns multiple people, I 
think you can ctrl+click multiple and add that way.

Sent from my iPhone

On May 13, 2013, at 9:30 AM, 
lars.j.petters...@vattenfall.commailto:lars.j.petters...@vattenfall.com 
lars.j.petters...@vattenfall.commailto:lars.j.petters...@vattenfall.com 
wrote:

**
Well, I have to add 20 users to a new support group, some things in itsm does 
not impress me...:)


Från: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] För Pierson, Shawn
Skickat: den 13 maj 2013 13:27
Till: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Ämne: Re: Permission template?

**
People Templates only apply when you are creating new people.  If you are 
setting up people who already exist, you can't apply a template.  
Unfortunately, without the ability to customize, you're going to have a tough 
time getting past this one.

Thanks,

Shawn Pierson
Remedy Developer | Energy Transfer

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of 
lars.j.petters...@vattenfall.commailto:lars.j.petters...@vattenfall.com
Sent: Monday, May 13, 2013 12:42 AM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: SV: Permission template?

**
oki, If I had right to create own workflow, but a decision has been made only 
to make minimal with changes, run ootb...

I will look at the People Template and how it works. // Lars


Från: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] För Joe D'Souza
Skickat: den 13 maj 2013 06:30
Till: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Ämne: Re: Permission template?
**

Create some sort of a staging form for adding new users and create workflow 
there to create entries required in the CTM:People Permissions Group.



The OTB filters on that form will take care of the rest.



Joe


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of 
lars.j.petters...@vattenfall.commailto:lars.j.petters...@vattenfall.com
Sent: Sunday, May 12, 2013 11:52 PM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Permission template?

Hi, is there a way to use some kind of 'Template' when creating new team 
members in support groups? To manually add application permissions, companies 
and functional roles takes a lot of time. Just create a basic profile, then 
manually add special permissions.

Best regards, Lars
_ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where 
the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_
Private and confidential as detailed 
herehttp://www.energytransfer.com/mail_disclaimer.aspx. If you cannot access 
hyperlink, please e-mail sender. _ARSlist: Where the Answers Are and have 
been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Permission template?

[lars . j . pettersson]

Hi, is there a way to use some kind of 'Template' when creating new team 
members in support groups? To manually add application permissions, companies 
and functional roles takes a lot of time. Just create a basic profile, then 
manually add special permissions.

Best regards, Lars


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

SV: Permission template?

[lars . j . pettersson]

oki, If I had right to create own workflow, but a decision has been made only 
to make minimal with changes, run ootb...

I will look at the People Template and how it works. // Lars


Från: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] För Joe D'Souza
Skickat: den 13 maj 2013 06:30
Till: arslist@ARSLIST.ORG
Ämne: Re: Permission template?

**

Create some sort of a staging form for adding new users and create workflow 
there to create entries required in the CTM:People Permissions Group.



The OTB filters on that form will take care of the rest.



Joe


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of lars.j.petters...@vattenfall.com
Sent: Sunday, May 12, 2013 11:52 PM
To: arslist@ARSLIST.ORG
Subject: Permission template?

Hi, is there a way to use some kind of 'Template' when creating new team 
members in support groups? To manually add application permissions, companies 
and functional roles takes a lot of time. Just create a basic profile, then 
manually add special permissions.

Best regards, Lars
_ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where 
the Answers Are and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Ar System Message Catalog

[lars . j . pettersson]

Hi list, The mentioned form 'Ar System Message Catalog' contains 'Message 
Identifier' (Al name/Filter name) and 'Msg Num'.

Suppose that Message Identifier is 'Check Name' and Msg Num 60229

I set locale to 'de' and enter a text in German. The corresponding Filter has 
message No 60229 with an english text.

Test: Works.

Then, I rename this filter In Dev Studio but keep the Message Number, will it 
still work, the text will be in German?

I tried to change the name of Message Identifier in 'Ar System Message 
Catalog', but when I did this, I got the text in English.

Conclusion: If serverobjects are renamed the localization will be lost for that 
serverobject?

Best regards, Lars



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years

Reports

[lars . j . pettersson]

Hi, we run 7.6.04 SP4 and not ITSM, we run our home built application, which 
have been upgraded and MidTier activated.

I select some rows in the web based version, after having searched, right-click 
and select 'Report'
Then button 'New'.
Type: Web
Name: Testreport
OK

I select four fields.

Filter by: I select 'Status is equal to Active'

Then, button 'Preview'.


ARERR [3600] Internal error.
Anyone seen this, and have a solution?
Thanks in advance,
L ars






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

Change a Support Group Structure, ITSM

[lars . j . pettersson]

Hi, suppose that we have this entry in form Support Group

Support Company: xxx
Support Organization: yyy
Support Group Name: zzz

There are Team Members, Templates, Problems, Incidents, Changes, Auto-routing 
and more.

Now, Support Group Name zzz has to be moved to Support Organization 'aaa'.

How do you perform this action?

I have got the information that a new Group entry has to be created, all team 
members manually moved, all templates handled manually, and all other forms too 
where xxx/yyy/zzz exist. 'The Data Wizard are not working on Unix and shall not 
be used' have I heard. To make this operation manually takes a lot of time, 
there must be a better way?

Thanks,

Lars


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

Asking for code...

[lars . j . pettersson]

Hi, I have no access to the right version of admin-tool for ITSM, I would 
appreciate if someone could send me the arscode which executes when Data Wizard 
is used for changing name of a Support Group. Direct sql och push fields, I 
don't know. Easy to validate the forms involved and maybe make some adjustments.

Thanks In Advance.

Lars


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

SV: SV: Data Wizard

[lars . j . pettersson]

Okey thanks for info, but is the long group name really used somewhere? Will 
there be any consequences if the name not is changed. But...Of course it should 
be changed to avoid confusion.

//Lars


Från: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] För Kelly Deaver
Skickat: den 19 mars 2012 01:30
Till: arslist@ARSLIST.ORG
Ämne: Re: SV: Data Wizard

**
You have to manually change the long group name in the Group form. This is 
documented. What isn't documented is if you don't then your SLTs may not find 
the right group to notify.

Kelly Deaver
Unisys Corporation
kdea...@kellydeaver.commailto:kdea...@kellydeaver.com (ARSlist mail)
kelly.dea...@unisys.commailto:kelly.ctr.dea...@faa.gov (Business mail)


 Original Message 
Subject: SV: Data Wizard
From: lars.j.petters...@vattenfall.commailto:lars.j.petters...@vattenfall.com
Date: Fri, March 16, 2012 2:09 pm
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG

**
And when I tried, the Supportgroup Lead was never updated. (Where a group is 
linked to an Escalation group).

// Lars


Från: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] För Guillaume Rheault
Skickat: den 16 mars 2012 18:16
Till: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Ämne: Re: Data Wizard

**
Jesus,

The issues you describe see to me bugs. What version of ITSm are you using?

Guillaume


From: Action Request System discussion list(ARSList) 
[arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] on behalf of Ortega, Jesus A 
[jesus.ort...@lyondellbasell.commailto:jesus.ort...@lyondellbasell.com]
Sent: Friday, March 16, 2012 10:25 AM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Re: Data Wizard

**
Lars,
It will change the support group name, not the ID, on many of the ITSM forms 
and update functional roles for the people in that group. However, it does not 
update any templates that are using that group. So, if have any change, work 
order, or Incident templates where use that support group, make sure to change 
the ownership first to another group or it could corrupt the templates. That 
has happened to me with infrastructure change templates.  Make sure to check 
the group notification option on the support group after you've renamed it. It 
will set it to no and that group will not get messages when a group 
notification event fires.

Jesus Ortega
ITSM Technologist
LyondellBasell Industries
Office: 713 309-4914
Cell:281 546-0735
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of 
lars.j.petters...@vattenfall.commailto:lars.j.petters...@vattenfall.com
Sent: Friday, March 16, 2012 8:58 AM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Data Wizard

**
Hello, if I use Data Wizard in ITSM and change the name of a Support Group, 
will that name be changed in all forms where Support Group exist?
Any issues with this function? I tried it, but I found at least one form where 
the name not was changed.(Supportgroup Lead).

// Lars

_attend WWRUG12 www.wwrug.comhttp://www.wwrug.com/ ARSlist: Where the 
Answers Are_

Information contained in this email is subject to the disclaimer found by 
clicking on the following link: 
http://www.lyondellbasell.com/Footer/Disclaimer/ _attend WWRUG12 
www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_
_attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers 
Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the 
Answers Are_
_attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_

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

Data Wizard

[lars . j . pettersson]

Hello, if I use Data Wizard in ITSM and change the name of a Support Group, 
will that name be changed in all forms where Support Group exist?
Any issues with this function? I tried it, but I found at least one form where 
the name not was changed.(Supportgroup Lead).

// Lars


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

SV: Data Wizard

[lars . j . pettersson]

And when I tried, the Supportgroup Lead was never updated. (Where a group is 
linked to an Escalation group).

// Lars


Från: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] För Guillaume Rheault
Skickat: den 16 mars 2012 18:16
Till: arslist@ARSLIST.ORG
Ämne: Re: Data Wizard

**
Jesus,

The issues you describe see to me bugs. What version of ITSm are you using?

Guillaume


From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on 
behalf of Ortega, Jesus A [jesus.ort...@lyondellbasell.com]
Sent: Friday, March 16, 2012 10:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Data Wizard

**
Lars,
It will change the support group name, not the ID, on many of the ITSM forms 
and update functional roles for the people in that group. However, it does not 
update any templates that are using that group. So, if have any change, work 
order, or Incident templates where use that support group, make sure to change 
the ownership first to another group or it could corrupt the templates. That 
has happened to me with infrastructure change templates.  Make sure to check 
the group notification option on the support group after you've renamed it. It 
will set it to no and that group will not get messages when a group 
notification event fires.

Jesus Ortega
ITSM Technologist
LyondellBasell Industries
Office: 713 309-4914
Cell:281 546-0735
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of lars.j.petters...@vattenfall.com
Sent: Friday, March 16, 2012 8:58 AM
To: arslist@ARSLIST.ORG
Subject: Data Wizard

**
Hello, if I use Data Wizard in ITSM and change the name of a Support Group, 
will that name be changed in all forms where Support Group exist?
Any issues with this function? I tried it, but I found at least one form where 
the name not was changed.(Supportgroup Lead).

// Lars

_attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers 
Are_

Information contained in this email is subject to the disclaimer found by 
clicking on the following link: 
http://www.lyondellbasell.com/Footer/Disclaimer/ _attend WWRUG12 www.wwrug.com 
ARSlist: Where the Answers Are_
_attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_

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

Name of Server Object

[lars . j . pettersson]

Hi, can anyone give me the name of the server object that makes a name change 
for a Support Group using the Data Wizard Console under Foundation/Data 
Management Tool, I want to look at the code in Admin Tool.

// Lars


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

Asset Invoicing

[lars . j . pettersson]

Hi, has anyone been able to create an invoicing module of assets in the 
ITSM-system (7.6) with very few changes within the itsm-code. Something besides 
itsm handling the invoicing of assets. Assets are supposed to be connected to a 
paying unit, have a price which can easily modified, logic for initial cost and 
after that a monthly cost, file has to be created for R3, and excelfiles has to 
be created as specifications to the different customers. Each asset has to be 
connected to a project number, and a lot of other economy attributes, like 
order number.

We have run this for many years in our home built system, but now it has to be 
done in itsm.

Any feedback will be appreciated.

L ars




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

SV: Asset Invoicing

[lars . j . pettersson]

We have different prices for different customers, today we have an ars form 
with price-information/asset, and when an asset is created and marked yes for 
invoicing, we check who the customer is, and get the right price set, this also 
have to work when using the import tool, we also need to connect an asset to 
different attributes, like a special user, or just connect to an organisation. 
During the invoicing routine we have some forms locked for editing, so that the 
files to R3 will match the specifications. We need to be able to change a 
price, and that should update all assets related. Before invoicing starts we 
need to be able to find errors, like mismatch between projectnumber/asset and 
related customer e t c and correct that. There need to be functions to merge 
two customers into one, change customer numbers and so on. And much more. All 
this is working today in our home built system. I look forward to find out how 
itsm can handle this.

// L ars


Från: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] För Brian Pancia
Skickat: den 29 februari 2012 15:33
Till: arslist@ARSLIST.ORG
Ämne: Re: Asset Invoicing

**
For the purchasing piece you probably only need the COTAR as an approver.  
Adding/modifying a project should fall under the Change Management process, 
with the purchasing portion being a task(s) under the CR.  The CR would then 
have the multiple approvals if needed.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Roger Justice
Sent: Wednesday, February 29, 2012 8:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Asset Invoicing

** This is included with ITBM.

-Original Message-
From: Tommy Morris 
tommy.mor...@pinebreeze.commailto:tommy.mor...@pinebreeze.com
To: arslist arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Sent: Wed, Feb 29, 2012 8:22 am
Subject: Re: Asset Invoicing
**
The OOB Purchasing module is not very robust. There is only one approval 
allowed so chain approvals are out of the question. If you have a current 
homegrown process then you need to really go through the OOB purchase process 
to see where all the gaps are. I'll bet that you are going to have to customize 
like crazy to get it to work the way your business partners need it.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG?] On Behalf Of Brian 
Pancia
Sent: Wednesday, February 29, 2012 6:53 AM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Re: Asset Invoicing

**
Lars,

The Asset Management piece has a purchasing and receiving piece that might 
solve the bulk of your requirements.  You may also be able to setup the 
projects as CIs and relate all the items purchased to the project CI.  Add your 
additional attributes that you need to the project CI.  If there are a lot of 
things outside the OOB functionality that you need you can always setup a 
backend staging form to setup your invoicing, but I think with little effort 
you can probably use the straight OOB functionality to handle most of what 
you're looking for.  You can setup the paying units as cost centers and you 
have the ability to relate multiple cost centers.  The only part that may 
require some customization is your pricing model for initial cost versus 
monthly costs, but it doesn't sound like this would be major.

Brian


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG?] On Behalf Of 
lars.j.petters...@vattenfall.commailto:lars.j.petters...@vattenfall.com
Sent: Wednesday, February 29, 2012 5:16 AM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Asset Invoicing

**
Hi, has anyone been able to create an invoicing module of assets in the 
ITSM-system (7.6) with very few changes within the itsm-code. Something besides 
itsm handling the invoicing of assets. Assets are supposed to be connected to a 
paying unit, have a price which can easily modified, logic for initial cost and 
after that a monthly cost, file has to be created for R3, and excelfiles has to 
be created as specifications to the different customers. Each asset has to be 
connected to a project number, and a lot of other economy attributes, like 
order number.

We have run this for many years in our home built system, but now it has to be 
done in itsm.

Any feedback will be appreciated.

L ars



_attend WWRUG12 www.wwrug.comhttp://www.wwrug.com/ ARSlist: Where the 
Answers Are_
_attend WWRUG12 www.wwrug.comhttp://www.wwrug.com/ ARSlist: Where the 
Answers Are_
_attend WWRUG12 www.wwrug.comhttp://www.wwrug.com/ ARSlist: Where the 
Answers Are_
_attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers 
Are_
_attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend 

My first 7-up question

[lars . j . pettersson]

Hello, I'm back on arslist, long time ago. Now I belong to our 7-up management 
unit. Our home built system Tabasco is a dying application, but it has lived 
since -97:)
My question is: Is there any issues with Foundation/Data Management Tool/Data 
Wizard Console, or is this module working as expected. Direct SQL, or ars 
workflow?

Thanks in advance,

Lars



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

String title captionbar..

[lars . j . pettersson]

Hi list, i have encountered this problem:

When installing ars admin tool i get the messages 'String Title Captionbar was 
not found in the string table'. / 'VerFindFileverion failed'
I have tried two different versions of admin.exe, 701 .p005 and 701 p10.
I have also tried on two different pc's.

I only get this message then logged in with a local admin account (I need that 
to be able to install).
If i use my ordinary account this message does not appear, but the installation 
fails due to insufficient permissions.

I have been able to install the program successfully using the same mediafile 
earlier.

Anyone seen this, or have some suggestions what can be wrong?

Conflict with some MS security parches?

I have searched the BMC KB but have not been able to get any matches.

Platform: XP SP 2

Thanks in advance, L ars

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

Q: 0.5 in CR

[lars . j . pettersson]

Hi, after we upgraded server and clients to 7.0.1 p 004 (Oracle 10) we have 
problems with a Crystalreport which has been working for years. Created in 
earlier version of CR.

Suppose that we have 100 items each with a price 0.51

Before:

100 * 0.51 = 51

Now:

The report shows a quantity of 51, price each 1

If I change to 2 items with price 100: 

2*100 = 200, right

If I change to 100 items with a price each 0.50 I get division by zero ...
So 0.50 and below are now set to 0 ...

Anyone seen something similar?

Thanks,
L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: [EMAIL PROTECTED]


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are

Q: Buildnumber

[lars . j . pettersson]

Hi, where can I see build number? I got this answer from BMC: (Related to a 
problem we have seen and reported).

'There was some problem with ARGetEntry in 7.0.1 patch 4, after which it was 
rectified and a new build was released. I have tested this on ARS Server Patch 
4 build 200708262106 and found that it is behaving similar to 6.3, which is 
correct'.

***

It means that patch 4 can exist in two different versions ...why replace a 
patch and give it the same patch number confusing ...

L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: [EMAIL PROTECTED]


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

SV: Field ID is not related to this form....

[lars . j . pettersson]

 Try to search in which form id 536870993 exist, maybe a push action ?

SELECT s.name,fieldName FROM field f , arschema s WHERE f.fieldID = 536870993 
and s.schemaid = f.schemaid order by s.name asc


L ars

-Ursprungligt meddelande-
Från: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
För Kemes, Lisa
Skickat: den 29 augusti 2007 15:43
Till: arslist@ARSLIST.ORG
Ämne: Re: Field ID is not related to this form

I really thought that was going to do the trick.  After deleting 472 .arf files 
and 523 .arv files (with all of their folders), I'm still getting this error 
message.  :( 

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Grooms, Frederick W
Sent: Tuesday, August 28, 2007 7:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: Field ID is not related to this form

Maybe you have a corrupted WUT cache file.  Try deleting the .arf and .arv WUT 
cache files (usually located under your Remedy Home directory).

Fred

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Kemes, Lisa
Sent: Tuesday, August 28, 2007 2:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Field ID is not related to this form

Flushed the cache and it's still not giving me the error message like it does 
on the WUT.weird... 

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE
Sent: Tuesday, August 28, 2007 3:00 PM
To: arslist@ARSLIST.ORG
Subject: Re: Field ID is not related to this form

Have you flushed your Midtier cache since you deleted the workflow?

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Kemes, Lisa
Sent: Tuesday, August 28, 2007 1:56 PM
To: arslist@ARSLIST.ORG
Subject: Field ID is not related to this form

**
I receive an error: ARERR[311] Field ID is not related to this form:
536870993 when I try to do a search on my form in the Windows User Tool.
 
I started receiving this error message when I deleted this field and all 
workflow attached to it.  I created a def file of everything that was
attached to this form and there is no 536870993.   I don't get this
error when I do a search on the Mid Tier.
 
I checked my workflow logs and I don't see anything that tries to 
refer/change/or set this field.
 
Did I do anything wrong?  How do I get rid of this error?
 
User Tool:  7.0.01 Patch 003
Server: 6.3
Mid Tier: 7.0.01 Patch 003
 
Lisa
 
__20060125___This posting was submitted with HTML in it___ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Access question

[lars . j . pettersson]

Hi list, suppose permissions are set so that a user can't access a ticket when 
searching directly in a form. No access to field 1.

I have a joinform, users are able to see fields from this 'forbidden entry' in 
this join, unexpected, can't be as designed?

L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: [EMAIL PROTECTED]


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

SV: Subadministration / Deleting records

[lars . j . pettersson]

Michael, If you add group sub admin to a user, this user must also belong to a 
group which is defined on page 'subadmin permissions' in the admin tool for 
that form. and the user must have a fixed license. / L ars



Från: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
För Joe D'Souza
Skickat: den 14 augusti 2007 00:16
Till: arslist@ARSLIST.ORG
Ämne: Re: Subadministration / Deleting records


** 
Can the sub-Admins log into the Administrator Tool? Also check what others have 
asked you to - ie. Fixed Licenses and the Delete function if disabled from the 
menus..
 
Cheers
 
Joe

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL 
PROTECTED] Behalf Of Durrant, Michael M. - ITSD
Sent: Monday, August 13, 2007 6:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: Subadministration / Deleting records


** 
Yep, logged out, logged back in - still no Delete functionality.  
Refreshed user and group caches using arsignal, still no Delete functionality.
 
For my own verification, I'm expecting the Delete action to be 
available from the toolbar - or being able to use Ctrl-D to delete.  Neither of 
these work.


From: Action Request System discussion list(ARSList) [mailto:[EMAIL 
PROTECTED] On Behalf Of Joe D'Souza
Sent: Monday, August 13, 2007 2:57 PM
To: arslist@ARSLIST.ORG
Subject: Re: Subadministration / Deleting records


** 
Michael,
 
Asking the obvious here but have the relogged in after you gave them 
sub admin rights?
 
If so, try refreshing the user and group cache using the arsignal 
command from the AR System bin directory and then ask those sub admins to 
relogin.
 
Cheers
 
Joe

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] Behalf Of Durrant, Michael M. - ITSD
Sent: Monday, August 13, 2007 3:47 PM
To: arslist@ARSLIST.ORG
Subject: Subadministration / Deleting records


** 
The ARS 7 documentation says that subadministrators can delete 
records.  I have given the appropriate groups Subadministrator permissions to 
the form and I still can't get the Delete function to work.  Any ideas?
 
thanks,
 
Michael

__20060125___This posting was submitted with HTML in it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

SV: Subadministration / Deleting records

[lars . j . pettersson]

Maybe I was unclear:
 
1. The user must have a fixed licence.
2. They must belong to group Sub Administrator in the User Form
3. They must belong to that group which is defined on page 'Subadministrative 
Permissions' in Admin Tool.
 
When the log in to admin tool, they will be able to see those forms, for which 
they are subadmins, no other forms will be shown.
 
L ars

 




Från: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
För Durrant, Michael M. - ITSD
Skickat: den 14 augusti 2007 00:39
Till: arslist@ARSLIST.ORG
Ämne: Re: Subadministration / Deleting records


** 
So I need to make anyone who is a Sub-Administrator a member of Group ID 5, in 
addition to adding their group as a Subadministrator on the form and having a 
fixed license?
 
Thanks for your input Joe, Candance, Wes, Ron, and Lars.  =)



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of [EMAIL PROTECTED]
Sent: Monday, August 13, 2007 4:28 PM
To: arslist@ARSLIST.ORG
Subject: SV: Subadministration / Deleting records


** 
Michael, If you add group sub admin to a user, this user must also belong to a 
group which is defined on page 'subadmin permissions' in the admin tool for 
that form. and the user must have a fixed license. / L ars



Från: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
För Joe D'Souza
Skickat: den 14 augusti 2007 00:16
Till: arslist@ARSLIST.ORG
Ämne: Re: Subadministration / Deleting records


** 
Can the sub-Admins log into the Administrator Tool? Also check what others have 
asked you to - ie. Fixed Licenses and the Delete function if disabled from the 
menus..
 
Cheers
 
Joe

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL 
PROTECTED] Behalf Of Durrant, Michael M. - ITSD
Sent: Monday, August 13, 2007 6:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: Subadministration / Deleting records


** 
Yep, logged out, logged back in - still no Delete functionality.  
Refreshed user and group caches using arsignal, still no Delete functionality.
 
For my own verification, I'm expecting the Delete action to be 
available from the toolbar - or being able to use Ctrl-D to delete.  Neither of 
these work.


From: Action Request System discussion list(ARSList) [mailto:[EMAIL 
PROTECTED] On Behalf Of Joe D'Souza
Sent: Monday, August 13, 2007 2:57 PM
To: arslist@ARSLIST.ORG
Subject: Re: Subadministration / Deleting records


** 
Michael,
 
Asking the obvious here but have the relogged in after you gave them 
sub admin rights?
 
If so, try refreshing the user and group cache using the arsignal 
command from the AR System bin directory and then ask those sub admins to 
relogin.
 
Cheers
 
Joe

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] Behalf Of Durrant, Michael M. - ITSD
Sent: Monday, August 13, 2007 3:47 PM
To: arslist@ARSLIST.ORG
Subject: Subadministration / Deleting records


** 
The ARS 7 documentation says that subadministrators can delete 
records.  I have given the appropriate groups Subadministrator permissions to 
the form and I still can't get the Delete function to work.  Any ideas?
 
thanks,
 
Michael

__20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___ 
The information contained in this email may be privileged, confidential or 
otherwise protected from disclosure.  All persons are advised that they may 
face penalties under state and federal law for sharing this information with 
unauthorized individuals.  If you received this email in error, please reply to 
the sender that you have received this information in error.  Also, please 
delete this email after replying to the sender. 
__20060125___This posting was submitted with HTML in it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

SV: I Apologize Profusely

[lars . j . pettersson]

 It's a human righ to make mistakes sometime, we have all done something we 
regret.

-Ursprungligt meddelande-
Från: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
För Tim Widowfield
Skickat: den 23 juli 2007 21:17
Till: arslist@ARSLIST.ORG
Ämne: OT: I Apologize Profusely

Ladies and Gentlemen,

I apologize for my outburst earlier today.  Somebody in a wholly unrelated 
group sent me a very troubling email that I felt obliged to respond to. 
Unfortunately, he had BCC-ed the other group, and I added the ARSLIST by 
mistake in my reply.

I'm deeply sorry for offending anyone.  I will be more careful in the future.

Humbled and scorched by my own flame,

--Tim

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Error message

[lars . j . pettersson]

Open the form i RA and check all unique indexes, you have at least two records 
in the database with the same values in the fields included in the index. An 
easy way to find those entries are to export the fields to excel and sort the 
columns, add a formula checking if row x is similar to row x-1, after you have 
changed those entries to unique combinations, you will be able to add a new 
unique index.

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
Behalf Of Dan Fraser
Sent: Thursday, June 07, 2007 10:47 PM
To: arslist@ARSLIST.ORG
Subject: Error message


** 
Hello All,
 
This is probably a dumb question but, does anyone have an idea what this 
index is ?
 
Thu Jun 07 14:40:12 2007  390603 : The value(s) for this entry violate a unique 
index that has been defined for this form (ARERR 382)
__20060125___This posting was submitted with HTML in it___ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Archive Form Invalid

[lars . j . pettersson]

The advantage of this method is that you have full control over fields in the 
backup form, maybe you only need 20% of the fields compared with the source 
form, you will be able to create/delete fields in the source form without any 
aut change in the archiveform. We have a check that the post-is exists in the 
backupform before the sourcerequest is deleted. This has been running for years 
without any problems.

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
Behalf Of Amen, Kevin
Sent: Thursday, June 07, 2007 11:36 PM
To: arslist@ARSLIST.ORG
Subject: Re: Archive Form Invalid


** 
We've also moved away from the out-of-box archiving.  Instead, what we're doing 
now is we've made a copy of the form, called it form-name_BACKUP, then run an 
escalation that does a push-fields to the Backup form, then a run process to do 
an Application-Delete-Entry on the original form.

  _  

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Ron Tavares
Sent: Thursday, June 07, 2007 13:56
To: arslist@ARSLIST.ORG
Subject: Re: Archive Form Invalid


** I came across this many times.  It means there is a field somewhere on your 
original form that is not on the archive form.  Or the fields have the same id 
but are of a different type.  One time I was able to resolve this by using ar 
utilities to create .csv files of all the fields on both forms, then comparing 
the two line by line till I found where they were out of sync.  Sometimes the 
field you create on the orginal form does not copy to the archive because the 
'Views' are out of sync.  If you have a .def of the form before the change, you 
should import that. It would probably be the easiest solution.  Or, try 
reversing the change you made.  Either case, the out-of-box archiving sucks.  
That's why we are getting away from it. 


On 6/7/07, Cathy Ward  [EMAIL PROTECTED] wrote: 

** 
Was there a resolution to this issue? 
 
I'm also receiving  ARERR 8999.  I'm getting this error when creating an 
archive form from 
the original form.  I can move past the error, the archive form gets created 
and data gets moved. 
 

 

After the original form is saved with archiving enabled, I am unable to make a 
change in time selection or in the qualification.  I receive the 8999 error 
again along with  Unable to Save/Update 

form

 

We're on 6.3 patch 21, Oracle 9i R2 patch 8, Windows 2003
 
Cathy Ward
University of Michigan
IT Communications
 
 
- Original Message 
From: Amen, Kevin   mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Wednesday, February 28, 2007 8:18:55 PM
Subject: Re: Archive Form Invalid

** 
Tried to add two new groups to the permissions on a field.

  _  

From: Action Request System discussion list(ARSList) [mailto: 
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Archivetest

[lars . j . pettersson]

L. J: I've checked, the form and all fields have owner set in the source form.
 
L ars

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
Behalf Of L. J. Head
Sent: Friday, June 01, 2007 3:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Archivetest


** 
Well...based on the last line in the log I'm assuming that the name of your DB 
instance is 'ARDev'...and that it is trying to set the field 'Owner' in table 
'Field' to a null value which is not allowed...from this I would suspect that 
it's trying to copy the owner of the current from/Field to the new table.  
Verify that the form and all fields have an owner value defined on the change 
history tab.

  _  

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, May 31, 2007 11:52 PM
To: arslist@ARSLIST.ORG
Subject: Archivetest


** 

Hi, long time ago since I posted, but no problems for a long time .. 
This morning I tried the Archivefunction, but I receive this when saving: 

Could not create the Archive Form specified. Archive for this form has been 
disabled. Please check the error log for errors. (ARERR 8992).

From arerror.log: 

Fri Jun  1 07:24:53 2007  390600 : Failure during SQL operation to the database 
(ARERR 552) 
Fri Jun  1 07:24:53 2007 CreateArchiveOnSet():Could not create archive 
form, disabling archive 
Fri Jun  1 07:24:53 2007 
Fri Jun  1 07:24:53 2007  390600 : Failure during SQL operation to the database 
: ORA-01400: cannot insert NULL into (ARDEV.FIELD.OWNER) (ARERR 552)

The form I'm trying to enable archiving from is a simple testform with only 
corefields, I name the archiveform to archivetest (does not exist on the 
server).

6.3 p18, Oracle 9 

Any hints to isolate the problem will be appreciated, 

L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: [EMAIL PROTECTED] 

__20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Archivetest

[lars . j . pettersson]

Hmm...i just tried the exactly same operation from my home pc, successfully. 
The archive form was created without any errors.
My Office PC is not equal to my Home PC, W 2000/XP, but I can't see that this 
could cause this error ...
 
L ars

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
Behalf Of L. J. Head
Sent: Friday, June 01, 2007 9:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: Archivetest


** 
I bet if you turn on SQL Logging on the server you will see that it's trying to 
do an insert of a null value into the owner field...what I mentioned is the 
only thing I can think of that would cause that...might want to run the log 
anyway and open a ticket with BMC

  _  

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of [EMAIL PROTECTED]
Sent: Friday, June 01, 2007 1:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Archivetest


** 
L. J: I've checked, the form and all fields have owner set in the source form.
 
L ars

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
Behalf Of L. J. Head
Sent: Friday, June 01, 2007 3:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Archivetest


** 
Well...based on the last line in the log I'm assuming that the name of your DB 
instance is 'ARDev'...and that it is trying to set the field 'Owner' in table 
'Field' to a null value which is not allowed...from this I would suspect that 
it's trying to copy the owner of the current from/Field to the new table.  
Verify that the form and all fields have an owner value defined on the change 
history tab.

  _  

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, May 31, 2007 11:52 PM
To: arslist@ARSLIST.ORG
Subject: Archivetest


** 

Hi, long time ago since I posted, but no problems for a long time .. 
This morning I tried the Archivefunction, but I receive this when saving: 

Could not create the Archive Form specified. Archive for this form has been 
disabled. Please check the error log for errors. (ARERR 8992).

From arerror.log: 

Fri Jun  1 07:24:53 2007  390600 : Failure during SQL operation to the database 
(ARERR 552) 
Fri Jun  1 07:24:53 2007 CreateArchiveOnSet():Could not create archive 
form, disabling archive 
Fri Jun  1 07:24:53 2007 
Fri Jun  1 07:24:53 2007  390600 : Failure during SQL operation to the database 
: ORA-01400: cannot insert NULL into (ARDEV.FIELD.OWNER) (ARERR 552)

The form I'm trying to enable archiving from is a simple testform with only 
corefields, I name the archiveform to archivetest (does not exist on the 
server).

6.3 p18, Oracle 9 

Any hints to isolate the problem will be appreciated, 

L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: [EMAIL PROTECTED] 

__20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___ 

__20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Archivetest

[lars . j . pettersson]

Hi, long time ago since I posted, but no problems for a long time ..
This morning I tried the Archivefunction, but I receive this when saving:

Could not create the Archive Form specified. Archive for this form has been 
disabled. Please check the error log for errors. (ARERR 8992).

From arerror.log:

Fri Jun  1 07:24:53 2007  390600 : Failure during SQL operation to the database 
(ARERR 552)
Fri Jun  1 07:24:53 2007 CreateArchiveOnSet():Could not create archive 
form, disabling archive
Fri Jun  1 07:24:53 2007 
Fri Jun  1 07:24:53 2007  390600 : Failure during SQL operation to the database 
: ORA-01400: cannot insert NULL into (ARDEV.FIELD.OWNER) (ARERR 552)

The form I'm trying to enable archiving from is a simple testform with only 
corefields, I name the archiveform to archivetest (does not exist on the 
server).

6.3 p18, Oracle 9

Any hints to isolate the problem will be appreciated,

L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: [EMAIL PROTECTED]


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2

[lars . j . pettersson]

Shawn, why not take a look at rrrLog from misi, at www.rrr.se

rrrLog: Find the performance bottle necks in your system. 
What form use most system resources? 
Find slow API/SQL-calls, and browse the filters that have been triggered.

You will be able to sort by processing time and identify which sql command a 
used made, and who this user was.

In the bottom are the logfiles, api, sql, filter, esc, but presented is a 
readable format.

We tested the product, and found slow 'like searches', both in ars code and 
triggered by users.

L ars


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Shawn Stonequist
Sent: Tuesday, January 02, 2007 11:34 PM
To: arslist@ARSLIST.ORG
Subject: Performance Issues caused by User Queries - Remedy 6.3/Oracle
10.0.2


Greetings List!!

We have an issue in which some users (we know not who) are running queries
which are affecting the performance of our Remedy system, causing
significant delays, issues, and even complete system lock-ups for all our Users.

We have three goals that we would like to accomplish:
1) Identify the user(s) and what they are doing
2) Prevent future performance degradation of this nature
3) Stop offending queries in progress should prevention be not possible to
bypassed in some manner, using a method other than rebooting our database
(as this brings all our users down, which is what we are trying to remedy)

We are interested in any possible solutions or paths to accomplish one or
more of these goals. We spoke with our Remedy Partner that provides our
support, but unfortunately, their best resolution was using User/API/SQL
Logging Remedy-side.

Unfortunately, for this to be successful, we would need to know before the
offending query is run, or have it always running (something our SA is
against due to system resource concerns)

Our SA provided me the following information concerning our configuration,
which may be helpful (I apologize that I don't know what it all means):

Distributed Server
Remedy 6.3.0 patch 018
Oracle 10.0.2
Monolithic

We look forward to and appreciate any assistance available.

Thanks
Shawn Stonequist
EMNS, Inc.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Re: Archiving Data in Remedy

[lars . j . pettersson]

Hi, we have done exactly the same, and it has been up and running i prod för 
about 3-4 years, we archive request which have been in staus closed for 13 
months, 500 every night including attachments, escalations and push field 
action, works fine. /L ars

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
Behalf Of Webster, Basil
Sent: Friday, December 01, 2006 11:03 AM
To: arslist@ARSLIST.ORG
Subject: Re: Archiving Data in Remedy


** 

Hi Jase,

 

We have tried to use the built in archiving on numerous occasions and it let us 
down badly. From the archive form not being accessible to adding of fields etc. 
These can lead to the loss of data.

 

What we did was use a similar approach as Remedy but build our own. We took the 
original form and copied it, removed all the unnecessary fields like page 
fields, table fields and buttons, changed the permissions to public on all the 
fields that remained. Form permissions are reserved for admins or a specific 
group. We then have 2 fields that are used to control the copy of the data 
(which could be done by either push or DSO, depending on what fits our needs). 
These same fields are applied to the archive form. The one field is used as a 
trigger which is stepped through stages. An escalation selects the records and 
marks this field ready for archive. This triggers a copy to the archive form. 
From the archive form an escalation checks the staging field and sets the 
original form as copied and an escalation takes care of the delete from the 
original form.

 

I forgot, we had to create another field to house the original ID (same as 
Remedy).

 

Trust this gives you an idea.

 

 

Regards,

 

Basil Webster

 

Remedy Developer

Siemens Business Services (Pty) Ltd 
* E-Mail:  [EMAIL PROTECTED]

* Tel:  +27 11 652 7523
* Fax: +27 11 652-7501 
* Mobile: +27 82 452 9389

 


  _  


From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Jase Brandon
Sent: 30 November 2006 19:11
To: arslist@ARSLIST.ORG
Subject: Archiving Data in Remedy

 

Hello Listers,

 

I am looking for best practices and ideas for the beginning of Remedy data 
archival. We have had Remedy here for almost a year and are beginning to look 
into data archival options.

Can anyone share ideas or experiences?

 

 

Thanks in Advance, )

 

 

Help Desk 6.0

Windows

 

Jase Brandon 

Remedy Administration/Development 

Customer Support Systems Group

Desk - (615) - 320-4494

Cell   - (334) - 318-5426

[EMAIL PROTECTED]

 

DaVita Inc. 

__20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

Crystal reports

[lars . j . pettersson]

 We have a very strange problem with CR, some user get 'Field name not known' 
 or 'error in formula'. The workaround to solve this, for a while are two 
 methods I've seen can fix this. Delete contents in the home folder (keep 
 dde.ini), or delete the user preference request. Some users have no problems 
 at all. And what is most strange, users having this problem can have it on 
 Monday, not next day, very inconsistent. I can't see the logic. We never had 
 this problem before 6.3. All users have ODBC YES in the pref form.
 
 Anyone else seen this?
 
 
 L ars Pettersson
 Vattenfall Business Services Nordic AB
 Action Request System Engineer (Tabasco)
 S-461 88 Trollhättan
 Sweden
 
 Phone +46 520 888 35 Mobil +46 70 608 99 95
 e-mail: [EMAIL PROTECTED]
 

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Arwarn 1200

[lars . j . pettersson]

Hi, is there a way to suppress the message, No matching requests (or no 
permission to requests) for qualification criteria. (ARWARN 1200) from a macro 
in an al with macroparameters, I want to replace it with my own message if 
lastcount = 0, else close the dialogform from where the macro is activated.

In open window action I know suppress empty list is available, but I can't use 
this as I have to use report to application with the use of dde.ini in the 
macro.

L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: [EMAIL PROTECTED]

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Disable Remedy Splash Screen

[lars . j . pettersson]

Hi, what is a Splash screen?/L ars

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Leonard Nelson
Sent: Tuesday, September 19, 2006 3:33 PM
To: arslist@ARSLIST.ORG
Subject: Disable Remedy Splash Screen


Hi All

Is there a way to disable the default Remedy Splash screen from showing?

Any suggestions would be appreciated.

Leo

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: request crashing user tool - malloc failed

[lars . j . pettersson]

Title: RE: request crashing user tool - malloc failed
**



We had 
similar problem some years ago when importing arx files, crasch related to 
attachments. The workaround was toimport without attachments, and add 
thoses later separate with the use of'Update record'. Never got any 
further explaination, not a problem anymore as we now can migrate with data in 
the forms.

  -Original Message-From: Action Request System 
  discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of 
  McKenzie, James J C-E LCMC HQISEC/L3Sent: Friday, September 15, 
  2006 3:42 PMTo: arslist@ARSLIST.ORGSubject: Re: request 
  crashing user tool - malloc failed** 
  
  Nyall and Raido: 
  I'm willing to state that the affected action has a very large 
  diary or attachment associated with it. If you attempt to export the 
  record from your database, Oracle can handle the data collection, but Remedy 
  cannot. Thus, you see a large increase in memory usage and then the 
  crash. If you care to explore, you can look at the CLOB storage for that 
  record and find the record is very large. Don't know how this happens as 
  the limit for a diary field under Oracle is 1MB of text.
  If you need help, I think that I can provide a little bit of 
  it. 
  James McKenzie L-3 GSI 
   
  -Original Message- From: 
  Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of 
  Nyall McCavitt Sent: Friday, September 15, 2006 5:55 
  AM To: arslist@ARSLIST.ORG Subject: Re: request crashing user tool - malloc failed 
  Hi, 
  I have a similar situation with my system: 
  ARS Server V6.00.01 patch 1497 Solaris 
  5.9 Oracle 9.2.0.7.0 
  Each access to the affected ticket causes 100MB of ram to be 
  used by the arserverd process. When a certain amount of ram has been used 
  arserverd crashes and armonitor restarts.
  SQL trace logs don't show anything but api logging does show 
  an error. In many cases it is only the values of the Query List that are 
  returned. No values for any other fields are displayed. Initially this was 
  showing up as an RPC error/timeout.
  I have a ticket open with Remedy Support for 2 weeks now but 
  nothing that we have tried has traced the problem. We have even exported the 
  production database and re-imported it into a different Oracle server and 
  pointed our development Remedy Server at this copied database. The problem is 
  apparent on both the production and development servers and it is reproducible 
  100% of the time.
  If anyone has any ideas I would be grateful. 
  Thanks. 
  Nyall 
  Quoting Raido Oja [EMAIL PROTECTED]: 
   Hello,   I have discovered 2 requests so far on a regular form, that cause 
  the  user tool to crash with 'malloc failed on 
  server' error msg. I can see  the requests through 
  a table on some other form, but when searching  
  for them the user tool crashes.   When trying to export data the export process hangs when it 
  reaches  these requests, as does runmacro.exe when 
  exporting from the command line.   As I have to save the data I am thinking of exporting on the 
  database  level, deleting the data and creating a 
  new request afterwards. Or can  anyone suggest 
  another way of salvaging these requests?  
   My system:   ARS 5.01.02 patch 1357  Windows 
  2000  Oracle 9.2.0.3.0   Thanks for any ideas, 
Raido
   ___ 
   UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org 
   
  ___ 
  UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org 
  __20060125___This posting was submitted with HTML in 
  it___
__20060125___This posting was submitted with HTML in it___

Re: Allow Any User To Submit

[lars . j . pettersson]

hi, don't really understand, in fact this checkbox exists on the permissions 
tab in RA, been there for years. Run ver 3.1 and You will see it in place even 
there, or am I misunderstandning the Q? / Lars

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Elmo Gentry
Sent: Thursday, September 14, 2006 7:16 PM
To: arslist@ARSLIST.ORG
Subject: Allow Any User To Submit


All,

Is there a way to set the Allow Any User To Submit checkbox on Remedy 
fields?


Elmo Gentry
Datacraft Solutions Inc.,

There is a difference between interest and commitment. When you are 
interested in doing something, you do it only when it is convenient. When 
you are committed to something you accept no excuses, ONLY RESULTS.

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

HP Openview/ARS

[lars . j . pettersson]

Hello, I would like to get some comments upon this issue: Suppose the 
Management make a decision because 'ARS is expensive' - replace the ars system 
with HP Openview. My thougts are:

Is there an Admin tool for HP Openview which can be compared with ars, make 
changes fast, safe and even in production?

How will the migration be done and what will it cost ... We can't loose all 
reqeusts. A lot of data must to be transfered to the new system in a new 
datastructure.

Suppose 700 active users, If every user needs 8 h time to learn a new system, 
this means 5600 h, and 8 h is at a low estimate I think.

Is ars expensive? Maybe licenses, but is development expensive? Some skilled 
ars devlelopers can implement a lot with only 100 hrs of work. The same with 
Openview? Our system has always been changing rapidly, new conditions every 
year, not a problem, just make a new release of the application with max 15 hrs 
of migration. Easy to make a new release of an Openview application with new 
code?

I guess that another platform maybe is less expensive in one way, but add all 
costs for changing, I'm not sure it in the end will save money for the company.

And, I don't even know how to compare ars with HP Openview, I've never seen the 
application.

And, add hrs to implement all processes/routines into another system.

Why Open view? Because it's used in another country with is going to be 
integrated in our company. (They use an home-built ars system too for some 
modules)

Maybe Integration is the best solution, we run ars and they run openview, just 
build an IF between those two systems intead of replacing one?


L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: [EMAIL PROTECTED]

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Macros for multiple users

[lars . j . pettersson]

**



It 
also possiby to have more  1 path for example c:\Program 
files\\home;H:\test\macros;E:\Common\macros

Just 
separate them with a semicolon, this sting is stored in the user pref 
form.
L 
ars

  -Original Message-From: Action Request System 
  discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Susan 
  PalmerSent: Friday, September 08, 2006 3:51 AMTo: 
  arslist@ARSLIST.ORGSubject: Re: Macros for multiple 
  users** So to clarify, you have the .arq files copied to 
  everyone's arcmds path on their own computers. Then they should see 
  them. Check the path they have in their Tools / Options which should 
  point to that same folder. When they record a macro do they see it? 
  I'm not sure if Preferences will make a difference if those are 
  utilized since we don't use them. Someone else might chime in on 
  that. Do you used Centralized Preferences?Susan
  On 9/7/06, Hall, 
  Granville V [EMAIL PROTECTED] 
wrote:
  
** 


Thanks 
Susan,

We've been just 
copying them all to that folder on each of the computers because it was the 
default for Remedy. I should clarify that they other users are on the 
local machine. I'll try moving it to the network and see if that 
helps. It was weird because they were there and then they disappeared 
and they only show up for me.

Thanks.





From: 
Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] 
On Behalf Of Susan 
PalmerSent: Thursday, 
September 07, 2006 9:23 PMTo: arslist@ARSLIST.ORGSubject: Re: Macros for multiple 
users

** Buddy,
The macros are on YOUR harddrive. The only way others 
could get to them would be for your computer to be shared and the network 
path to that location be put in Tools / Options in the path field on the 
other computers. Generally people choose a network location 
for commonly used macros or they simply distribute them (via email) to 
others that may use them and they store them in the path you have listed 
below on their own computer. That's the default path provided during 
the client install and you can change it and/or add an additional path to 
it. Susan




On 9/7/06, Hall, 
Granville V [EMAIL PROTECTED] wrote:
Hey 
guys,I have an interesting problem going on.We are 
running Remedy User6.0.3 and I have macros in the C:\Program Files\AR 
System\HOME\ARCmds,but they are only showing up for me in the macro bar 
and not the other users of the computer.Do you have any idea 
why that would be?Thanks,Buddy 
Hall___UNSUBSCRIBE 
or access ARSlist Archives at http://www.wwrug.org

__20060125___This posting 
was submitted with HTML in it___ 
__20060125___This posting 
was submitted with HTML in it___ 
  __20060125___This posting was 
  submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___

Re: new remedy admin needs training advice (U)

[lars . j . pettersson]

Hi! I don't agree that studying Oracle is the right for You, I have been an ars 
developer since 1997, and never noticed that I miss knowledge about Oracle, C 
and VB ...well, yes good to have knowledge, but it's not releted to the title 
'Remedy Administrator'.

Question: What are the expectations upon You? Are you responible for an ars 
system in production? just to maintain this, have it up and running, or many 
change requests related to the ars code which must be implemented in a few 
months?

Do You have any DBA at your company? He/she takes care of Oracle i think.

Start to learn the usertool, how it works, that's the basic before you login to 
the admin tool and make any changes.
If You don't have any knowledege about macros, how to perform a search on ASB, 
it will be diffucult to analyze the code.
And, you must also have 100% knowledge about the application, how it works, 
knowledge about Groups and policys for permissions in the application.

Later, continue with Oracle and C.

L ars

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Barber, Dave
Sent: Friday, September 08, 2006 3:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: new remedy admin needs training advice (U)


Have you had any background in any sort of application development - ie.
Anything like VB, C, or even HTML coding?

Regards

Dave 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of NoSuchStudios
Sent: 08 September 2006 14:43
To: arslist@ARSLIST.ORG
Subject: Re: new remedy admin needs training advice (U)

unfortunately no. all my experience is all helpdesk and server
administration related. I've just started studying Oracle and i've dug
into the books that came with ARS but thats all i've got so far. 

Jason
NoSuch


Hennigan, Sandra H CTR OSD EOST wrote:
 
 UNCLASSIFIED
 
 Do you have any database or account management experience? 
 
 Sandra Hennigan
 
 OSD Remedy Administrator
 Office # 703-602-2525 x251
 CACI - Ever Vigilant(tm)
 
 Apparently, there is nothing that cannot happen today.  Mark Twain
 
 
 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:[EMAIL PROTECTED] On Behalf Of NoSuchStudios
 Sent: Wednesday, September 06, 2006 2:56 PM
 To: arslist@ARSLIST.ORG
 Subject: new remedy admin needs training advice
 
 
 Hi all,
 
 I've recently been assigned the title of Remedy Administrator...the 
 problem...i'm a Sys Admin with very little Remedy experience and my 
 company won't be able to get me into training until january or so.
 
 My question is this. What should i be studying outside of the remedy 
 manuals so i can become at least fairly proficient. I've managed to 
 work out some basic things like CTI's, basic AL's and escalations, and

 some basic CM and Helpdesk administration but its been very very slow.

 What programs, languages, etc.. should i be focusing on?
 
 Any advice would be much appreciated. We're working on a Windows 2k3 
 platform with AR System 6.3 and Oracle 9i.
 
 V/R
 
 Jason
 NoSuchStudios
 
 --
 View this message in context:
 http://www.nabble.com/new-remedy-admin-needs-training-advice-tf2228920
 .h
 tml#a6177596
 Sent from the ARS (Action Request System) forum at Nabble.com.
 
 __
 __
 ___
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
 
 __
 _ UNSUBSCRIBE or access ARSlist Archives at 
 http://www.wwrug.org
 
 

--
View this message in context:
http://www.nabble.com/Re%3A-new-remedy-admin-needs-training-advice-%28U%
29-tf2235514.html#a6209165
Sent from the ARS (Action Request System) forum at Nabble.com.


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: SQL Syntax

[lars . j . pettersson]

Do you have this in workflow?, try to skip ; at the end of the command, Lars

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Koyb P. Liabt
Sent: Thursday, September 07, 2006 7:04 PM
To: arslist@ARSLIST.ORG
Subject: SQL Syntax


Hi,
 
I am trying to pass a value into a field on HPD:Helpdesk, and make  sure it 
only updates the current record open.  I met with the dba,  referenced database 
guide, and I have this command below, however I am getting  failure during 
SQL operation - invalid character.
 
Does anybody know what is wrong with the syntax below:
 
update T418 set C535478792 = '$Secondary email$' where  C1 = '$Case ID+$';
update T418 set C535478792 = $Secondary email$ where C1 = $Case  ID+$;
 
update T418 set C535478792 = $Secondary email$ where C1 = $Case ID+$;
 

ARERR [552] Failure during SQL operation to the database : ORA-00911:  
invalid character

-
Forwarded Message: 

   Subj: Re: SQL syntax   Date: 9/6/2006 5:04:09 P.M. Eastern Standard 
Time  From: [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED])   Reply-to: 

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Avoid opening the same request-id twice

[lars . j . pettersson]

Hi, anyone tried this successfully, to prevent user X from opening the same 
request-id twice?
Use Global fields ..?
Give an error/warning(?) message if criteria is met?
Any way to switch to the already opended window?
L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: [EMAIL PROTECTED]

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: AL stopped working (no changes on AL)

[lars . j . pettersson]

George, sure this problem is related to action 'set fields'? We have Al's only 
running Open window and we have to resave the al to get it to work ..for a 
while .../L ars

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of George Barsan
Sent: Thursday, September 07, 2006 11:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: AL stopped working (no changes on AL)


Hi David,

I removed all fields from the set field and added them one by one..
The one causing the problem is the field SelectionCriteria which I use
later on as external qualification for the open window. The strange
thing is that it stopps not only the open-win AL firing next, it
blocks all open-win AL's running behind that form (even though it
doesn't run there)...

I tried the following combinations for SelectionCriteria:
  ( $NumericCaseID$ = 'NumericCaseID')  // as used in another AL and
working fine there
  $NumericCaseID$ = 'NumericCaseID'
  $NumericCaseID$ = 1
  'NumericCaseID' = 1
  1 = 1
  1 = 2

None of them worked: the AL processing stops as described without any
error message.

Please also note that if I change the qualification to something
invalid (i.e. $NumericCaseID$ = 'XXNumericCaseID' or
$XXNumericCaseID$ = 'NumericCaseID' ARS correctly shows me a There
was a problem expanding the EXTERNAL qualification error message).

If no requests match is set to default message.

Any ideas would be greatly appreciated..

Many thanks,

George



On 9/6/06, David Sanders [EMAIL PROTECTED] wrote:
 Hi George

 Is the set fields action before the window open building a qualification for
 the report?  What are your settings in the open window to report action in
 the No Requests Match area?  If your qualification returns no matching
 records and you have your options set to 'Do Not Show Any message' and
 'Suppress empty list', then the report window will just not open.

 Try setting the No Match options to 'Show Default Message' and see if that
 gives any clues.

 HTH

 David Sanders
 Remedy Solution Architect
 Enterprise Service Suite @ Work
 ==
 ARS List Award Winner 2005
 Best 3rd party Remedy Application

 tel +44 1494 468980
 mobile +44 7710 377761
 email [EMAIL PROTECTED]

 web http://www.westoverconsulting.co.uk

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of George Barsan
 Sent: Wednesday, September 06, 2006 5:17 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: AL stopped working (no changes on AL)

 No, not yet - but I'm going to do that..

 What I tried to do is to separate the actions from one large AL into 3
 smaller ones. The funny thing is, that I ended up with an
 open-window-AL (let's call it ReportInternal), for which I have a
 handy def file and it works fine. However, I need a set fields action
 running in front of it. I had two ideas:

 1) I tried to add it to the ReportInternal-AL = open window fails
 2) I tried to create a separate AL (called GetReportData) running with
 a lower order = open window fails

 Importing GetReportData-AL messes up all open window actions even in
 other AL behind that form, although they are running on totally
 different conditions. As soon as I delete the AL GetReportData, the
 open window actions are working again..

 Next, I exported both AL's as XML and copy  pasted the missing set
 field action in an editor and import the new XML.. Same result = open
 window fails :(

 I guess that there is a relationship between the set-field and the
 open window action... However, I've ran out of ideas..

 George

 On 9/6/06, [EMAIL PROTECTED]
 [EMAIL PROTECTED] wrote:
  George, have you checked the .arf files in the Home Folder on the clients,
 contains the al defintions I know, maybe a difference when the al is not is
 working and when it is working? Something corrupt in the arf file? /L ars
 
  -Original Message-
  From: Action Request System discussion list(ARSList)
  [mailto:[EMAIL PROTECTED] Behalf Of George Barsan
  Sent: Wednesday, September 06, 2006 4:53 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: AL stopped working (no changes on AL)
 
 
  Hello Joe,
 
  Yep, the group names and ID's are equal.. We used a DB dump and
  re-import to duplicate production to dev and only removed customer
  related data (names, addresses  co)..
 
  George
 
 
  On 9/6/06, Joe DeSouza [EMAIL PROTECTED] wrote:
   **
  
  
   Very basic question... Have you checked if the permission groups on both
 the
   dev and prod instances are identical - both group names and their ID's
   should be the same...
  
   Joe D'Souza
   Remedy Developer / Consultant,
   BearingPoint,
   Virginia.
  
  
  
  
   - Original Message 
   From: Kemes, Lisa [EMAIL PROTECTED]
   To: arslist@ARSLIST.ORG
   Sent: Wednesday, September 6, 2006 9:15:27 AM
   Subject: Re: AL stopped working (no changes on AL)
  
  
   I had an AL just stop working all of the sudden and what I had to do 

Re: Avoid opening the same request-id twice

[lars . j . pettersson]

You are right ...but, is there any reason to open the same id/form twice for 
user? I can't see any situation. This should not be be possibly I think, in 
next aruser.exe ...? One of the most frequest asked questions is, why are so 
may windows opened in ars ../L ars 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Mike White
Sent: Thursday, September 07, 2006 9:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: Avoid opening the same request-id twice


I'm not sure you can prevent opening (i.e. displaying) the same Request ID
more than once without some ugly stuff - setting a flag field, which trips
the change flag, requiring the user to save a request that he/she was only
viewing, coupled with an error on display if the flag field is set.

An alternative might be to use events to close the window of an
already-displayed request.

You could build an AL with Execute On = Display, no Run If (or 'Request ID'
!= $NULL$?), If Action = Run Process PERFORM-ACTION-SEND-EVENT (ARS 6.0,
DAB, p. 710).  target would probably be * (i.e. all windows managed by
the client) and event_type could be a concatenation of $SCHEMA$ and
$Request ID$ (unique to form and record).

A second AL with an earlier Execution Order, Execute On = Event, Run If =
$EVENTTYPE$ = $SCHEMA$ + 'Request ID', If Action = Close Window (possibly
preceded by a message to let the user know what's going on).

This isn't great, either.  You really don't know what you're closing.  The
user could have searched for multiple records and happens to be positioned
on one that was later searched for/displayed in another window.  The second
display would cause the first to close.  Could be irritating.

Mike White
Office:  813-978-2192
E-mail:  [EMAIL PROTECTED]



   
  [EMAIL PROTECTED] 
   
  TENFALL.COM  To:   
arslist@ARSLIST.ORG   
  Sent by: Action cc:  
   
  Request System   Subject:  Avoid opening the 
same request-id twice   
  discussion
   
  list(ARSList)
   
  arslist@ARSLIST.ORG 
   

   

   
  09/07/2006 14:05  
   
  Please respond to 
   
  arslist   
   

   

   




Hi, anyone tried this successfully, to prevent user X from opening the same
request-id twice?
Use Global fields ..?
Give an error/warning(?) message if criteria is met?
Any way to switch to the already opended window?
L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: [EMAIL PROTECTED]

___

UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org



___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: AL stopped working (no changes on AL)

[lars . j . pettersson]

George, We are on p003 client, 18 server. The reason we can't upgrade the 
clients is that macros stops working if we have field 1005 in the form and the 
macro is using ASB ...:) ...Have tested all patches higher than 003 ...even ver 
7. 

What would life be without ARS bugs ...(Maybe better ...)

Is our problem client/server related ..Hmm interesting ...I don't know 
. Ask Dough ...

L ars

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of George Barsan
Sent: Wednesday, September 06, 2006 2:36 PM
To: arslist@ARSLIST.ORG
Subject: Re: AL stopped working (no changes on AL)


Lars,

which patch are you using? My initial guess was that it's client
related, but after testing the application on several workstations
(same behaviour on all of them) it seems like a server issue.

I unfortunately don't have access to the support website at the moment
and therefore can't verify if something is mentioned in the release
notes of the patches  13 (we're on server P13 here)..

George

On 9/6/06, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
 George, very interesting, to get this confirmed by another site, we have had 
 this problem in production since our upgrading to ver 6.3, problem: AL: Open 
 window action, report form - nothing happens, but if You resave the AL, it 
 works for a while, until next 'dying', just to resave (no real change just 
 make the save button to be highlighted). As far as I can see it's exactly the 
 same problem. We have replaced all Open window Actions/Report form with 
 embedded macros because of this problem, BMC have not been able to help us in 
 any way.

 L ars

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] Behalf Of Timothy Powell
 Sent: Wednesday, September 06, 2006 2:12 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: AL stopped working (no changes on AL)


 I hate to ask the is it plugged in type question, but.
 The form it's trying to perform the push fields against DOES exist on the
 dev server...right?

 What's the log from the other AL? What are the common attributes of the ALs
 in question (if any)?

 Tim

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of George Barsan
 Sent: Wednesday, September 06, 2006 7:58 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: AL stopped working (no changes on AL)

 I have exactly the same behaviour on another (even simpler) AL on the same
 box too, it's driving me crazy..

 I highly appreciate any suggestions..

 On 9/6/06, George Barsan [EMAIL PROTECTED] wrote:
  Hi all,
 
  I have here an older ARS application which I'm trying to extend and
  consolidate.. It includes a nice little AL which runs behind a button
  and has 7 actions:
 
  0 set field locally
  1 set field from another form
  2 commit changes
  3 open window / report
  4 push fields (create a new request)
  5 change field
 
  The very same AL (I didn't modify it anyway) runs perfectly if I
  connect to production but stops on the Dev Box at the Open Window
  action, the log entries are:
  ACTL  3: Open Dialog
  ACTLServer: xyz
  ACTLSchema: XX:XXX:XYZ
  ACTLView:
  ACTL /* Mon Sep 04 2006 15:14:30 */
  ACTL Stop active link processing - On Control
 
  That's it, no error, no warning.. I cleaned the client cache,
  restartet both client  server, enabled  disabled and reimported the
  AL from production, recreated the AL manually.. It works for a while
  then and it suddenly stops working although I don't change anything..
  Has anybody seen that before? It seems like an ARS bug to me, but I
  unfortunately don't have access to the support site..
 
  Server (applies both for Dev and Prod): ARS 6.3 P13 running on WinXP
  Database: MS Sql on the same box (afaik v2000 8.00.2039)
  Client/Admin: workstation a) 6.3 P18 and workstation b) 6.3 unpatched
 
  Many thanks,
 
  George
 

 
 ___
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

 ___
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

 ___
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: AL stopped working (no changes on AL)

[lars . j . pettersson]

If something is wrong, it should always be wrong, our problem is that the al is 
working for a while ...1-3 days...or even more ...after that ars gives up, 
'don't like this al anynmore' ...not logical ..so I can't say that anything is 
wrong in the code as we get it to work for a while. /L ars

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Nyall McCavitt
Sent: Wednesday, September 06, 2006 2:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: AL stopped working (no changes on AL)


Hi,

Just a thought.

Have you defined the Report Server option in the User Tool to point to 
the dev server. If so, does the report exist on the Report form on dev 
server?

If I have misread this problem then please ignore this.

Thanks.

Nyall

George Barsan wrote:
 Hi Tim,

 Thanks for the quick answer. The DEV environment is a full copy of the
 production, all forms exist there as well (although containing test
 data!).

 The second AL having the same problems does the following actions:

  0 push fields (update existing request in another form)
  1 set fields from another form
  2 open window (yep, that's the one!)
  3 set fields from another form
  4 set field locally
  5 set field locally
  6 set field locally
  7 commit changes
  8 close window

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: AL stopped working (no changes on AL)

[lars . j . pettersson]

100% matching our problem.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of George Barsan
Sent: Wednesday, September 06, 2006 2:53 PM
To: arslist@ARSLIST.ORG
Subject: Re: AL stopped working (no changes on AL)


Hi Nyall,

I didn't define the report server - my understanding was that it uses
the server I'm currently logged in if nothing is defined (I'm only
logged in into dev). I added the servername as you suggest, cleaned
the cache and restarted the client - still the same behaviour.. But a
good point, thanks for suggesting!

The report exists on the dev server too. As said, it even runs fine
partly - until it suddenly stopps for some unknown reason..

George



On 9/6/06, Nyall McCavitt [EMAIL PROTECTED] wrote:
 Hi,

 Just a thought.

 Have you defined the Report Server option in the User Tool to point to
 the dev server. If so, does the report exist on the Report form on dev
 server?

 If I have misread this problem then please ignore this.

 Thanks.

 Nyall

 George Barsan wrote:
  Hi Tim,
 
  Thanks for the quick answer. The DEV environment is a full copy of the
  production, all forms exist there as well (although containing test
  data!).
 
  The second AL having the same problems does the following actions:
 
   0 push fields (update existing request in another form)
   1 set fields from another form
   2 open window (yep, that's the one!)
   3 set fields from another form
   4 set field locally
   5 set field locally
   6 set field locally
   7 commit changes
   8 close window

 ___
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: AL stopped working (no changes on AL)

[lars . j . pettersson]

Hi Fred, We don't use Advanced mode so I don't thinks that's is related 
Our actions in the al's are only:

Open window - Report Form
Report Type, does not matter, AR or CR - both gives the same problem.
Target - File or screen - does not matter- both gives the same problem.
Operation - Run
Location - Reporting Form



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Grooms, Frederick W
Sent: Wednesday, September 06, 2006 3:17 PM
To: arslist@ARSLIST.ORG
Subject: Re: AL stopped working (no changes on AL)


I just noticed the Advanced mode...   Do you need to use the Advanced
option?  Are you specifying the form to open in a Field (That's what the
advanced is supposed to be for).  Can you remove the Advanced option and
does the AL work?

Fred 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of George Barsan
Sent: Wednesday, September 06, 2006 7:29 AM
To: arslist@ARSLIST.ORG
Subject: Re: AL stopped working (no changes on AL)

Sorry, I forgot to mention that both AL are handling reporting and the
open window have open window actions running with window type = Report
and using Advanced mode..

On 9/6/06, George Barsan [EMAIL PROTECTED] wrote:
 Hi Tim,

 Thanks for the quick answer. The DEV environment is a full copy of the

 production, all forms exist there as well (although containing test 
 data!).

 The second AL having the same problems does the following actions:

   0 push fields (update existing request in another form)
   1 set fields from another form
   2 open window (yep, that's the one!)
   3 set fields from another form
   4 set field locally
   5 set field locally
   6 set field locally
   7 commit changes
   8 close window

 That's the only AL running behind that button (and on another form 
 then the AL initially mentioned). The logs are:

 ACTL Checking CM:LAU:BU_PrintAndSaveAsAttachment_000 (0)
 ACTL - Passed qualification -- perform if actions
 ACTL  0: Push Fields
 ACTL To Schema Schema:Case on Server @
 ACTL (536870991) = Template.rpt
 ACTL (536871192) = Schema:Join:Reporting123
 ACTL (536871203) = {Schema_Join_Reporting.ID} = '123'
 ACTL (536871162) = 06/09/2006
 ACTL (536871046) = test test test
 ACTL  1: Set Fields
 ACTL xAttachmentFormat (536871182) = portabledocformat
 ACTL xDataSourceFormName (536871165) =
Schema_Join_Reporting
 ACTL xFileExtension (536870935) = .pdf
 ACTL xReportDefinitionFile (536870927) = Template.rpt
 ACTL xSelectionCriteria (536870926) = $ID$ = 'ID'
 ACTL  2: Open Dialog
 ACTLServer: xyz
 ACTLSchema: Schema:Join:Reporting123
 ACTLView:
 ACTL /* Wed Sep 06 2006 13:22:10 */
 ACTL Stop active link processing - On Control

 And that's it :(

 Many thanks,

 George


 On 9/6/06, Timothy Powell [EMAIL PROTECTED] wrote:
  I hate to ask the is it plugged in type question, but.
  The form it's trying to perform the push fields against DOES exist 
  on the dev server...right?
 
  What's the log from the other AL? What are the common attributes of 
  the ALs in question (if any)?
 
  Tim
 
  -Original Message-
  From: Action Request System discussion list(ARSList) 
  [mailto:[EMAIL PROTECTED] On Behalf Of George Barsan
  Sent: Wednesday, September 06, 2006 7:58 AM
  To: arslist@ARSLIST.ORG
  Subject: Re: AL stopped working (no changes on AL)
 
  I have exactly the same behaviour on another (even simpler) AL on 
  the same box too, it's driving me crazy..
 
  I highly appreciate any suggestions..
 
  On 9/6/06, George Barsan [EMAIL PROTECTED] wrote:
   Hi all,
  
   I have here an older ARS application which I'm trying to extend 
   and consolidate.. It includes a nice little AL which runs behind a

   button and has 7 actions:
  
   0 set field locally
   1 set field from another form
   2 commit changes
   3 open window / report
   4 push fields (create a new request)
   5 change field
  
   The very same AL (I didn't modify it anyway) runs perfectly if I 
   connect to production but stops on the Dev Box at the Open Window 
   action, the log entries are:
   ACTL  3: Open Dialog
   ACTLServer: xyz
   ACTLSchema: XX:XXX:XYZ
   ACTLView:
   ACTL /* Mon Sep 04 2006 15:14:30 */ ACTL Stop active link 
   processing - On Control
  
   That's it, no error, no warning.. I cleaned the client cache, 
   restartet both client  server, enabled  disabled and reimported 
   the AL from production, recreated the AL manually.. It works for a

   while then and it suddenly stops working although I don't change
anything..
   Has anybody seen that before? It seems like an ARS bug to me, but 
   I unfortunately don't have access to the support site..
  
   Server (applies both for Dev and Prod): ARS 

Re: SQL syntax

[lars . j . pettersson]

**



I guess that You need ' for char 
fields

update T418 set C535478792 = '$Secondary 
email$' where C1 = '$Case ID+$'

Are You using this code in workflow? T418 
will be changed on another server, or if the form is deleted and reimported.to 
the same server. Use viewnames instead, or avoid hardcoded T no. /L 
ars

  -Original Message-From: Action Request System 
  discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Koyb 
  P. LiabtSent: Wednesday, September 06, 2006 10:56 PMTo: 
  arslist@ARSLIST.ORGSubject: SQL syntax** 
  
  Hi,
  
  
  I am trying to update a field (C535478792) with the values on the screen 
  from the field $Secondary email$ and pushed directlyvia SQL into the 
  Help Desk case record I am currently in.
  
  Is this syntax correct?
  
  update T418 set C535478792 = $Secondary email$ where C1 = $Case 
  ID+$;__20060125___This posting was submitted 
  with HTML in it___ 
__20060125___This posting was submitted with HTML in it___

Request id available

[lars . j . pettersson]

Hi, this has been asked before, when is request-id available in workflow? I 
though a filter on submit could check 'Post-id' = 000100, but it is not 
firing. But I get it to work with an AL after submit. I guess as designed, and 
I also guess that it's available in filterphase 'notify'. But I need it 
on/after submit - so, comments? Is an AL after submit the right way?

L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: [EMAIL PROTECTED]

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

New fieldtype - RTF?

[lars . j . pettersson]

Hi, I often get this question, why can't we use bold/colors för keywords, 
important info in char fields like Description? I know a new fieldtype is 
required for this, and I guess that the reason we don't have it yet is that 
it's not so easy technical? It it related to the underlying db? Maybe not 
supported at all?

L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: [EMAIL PROTECTED]

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Need SQL statement to retrieve field attributes

[lars . j . pettersson]

Title: Need SQL statement to retrieve field attributes
**



Jenni, 
interesting question, I don't have the answer, I wonder where information is 
stored for display/attribute propertes. QBE is on the db tab. I know it's 
possible the get the field type with the use of sql, SELECT foption from field 
where fieldid = $Field-ID$ and schemaid = $Table Name$.  'Foption' = 2 is 
"Optional" for example. Should be possible to get qbe too (I 
guess).

  -Original Message-From: Action Request System 
  discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of 
  Wacholz, Jeanette (Jenni)Sent: Tuesday, September 05, 2006 
  11:13 PMTo: arslist@ARSLIST.ORGSubject: Need SQL 
  statement to retrieve field attributes** 
  
  Hi listers! 
  Is there an SQL statement that will retrieve all 
  the attributes for every field on a form...or on all forms? We are 
  specifically interested in seeing the QBE settings for the fields.
  Jenni Wacholz Coventry HealthCare 480-445-2517 
  "MMS firsthealth.com" made the following 
  annotations.--This 
  message, including any attachments, is intended solely for the use of the 
  named recipient(s) and may contain confidential and/or privileged information. 
  Any unauthorized review, use, disclosure or distribution of this 
  communication(s) is expressly prohibited. If you are not the intended 
  recipient, please contact the sender byreply e-mail and destroy any and 
  all copies of the original 
  message.==__20060125___This 
  posting was submitted with HTML in it___
__20060125___This posting was submitted with HTML in it___

Re: Oddity with Submitter field in e-mail notifications

[lars . j . pettersson]

Title: Oddity with Submitter field in e-mail notifications
**



No 
problems, as long as there is at least one more admin account you can delete the 
demo user. Even if Owner is Demo, you can delete the account. In RA there is a 
field Owner - You can enter what you want in this field, it's not user form 
validated at all. So if You want a clean up, i would suggest a replace in the 
deffile of the string owner: Demo 
to
owner: 
Newname

  -Original Message-From: Action Request System 
  discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Rick 
  WestbrockSent: Wednesday, September 06, 2006 1:22 AMTo: 
  arslist@ARSLIST.ORGSubject: Re: Oddity with Submitter field in 
  e-mail notifications** 
  
  Excellent idea on checking the deffile, I'll try that 
  next. I may also have to have some users turn on logging (I normally 
  have all logging off for normal users).
  
  The Demo user was still there when I took over as Remedy 
  Admin several years ago and is still the Owner of many, many objects. Will it 
  break any objects owned by Demo if I delete that user?
  
  
  -Rick
  
  
  From: Action Request System discussion 
  list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of 
  [EMAIL PROTECTED]Sent: Tuesday, September 05, 
  2006 3:53 PMTo: arslist@ARSLIST.ORGSubject: Re: Oddity 
  with Submitter field in e-mail notifications
  ** 
  
  Don't really understart this, Demo came with the 
  startpacket, as soon admin-accounts have been created in the userform, ok to 
  delete Demo.
  I 
  guess Demo has been free for a while, active, so Demo is in field 
  'Submitter','Changed by' and 
  ...
  
  Your wf reads the 
  submitterfield, an 199 of 200 hasreal namesNot 
  Demo
  
  In our appl Demo is a 
  non existing name since long time.
  
  Some wf setting DEMO 
  sometimes?Submitter-mode setto locked? It means you are not 
  allowed to
  chanhe the data to get 
  rid of it finally. Possible to switch and then set locked again? (Ifyou 
  need to change field
  'Cretaed'
  
  Often when a form is 
  saved as, a lotof data is tranfered to the new form, I try to replace 
  Demo as Owner to something else.
  The same with 
  helptext
  
  And Check if there are 
  type Defaulvaues using Demo.
  
  Why not search in the 
  deffile for Demo? and change Owner = 
  "Demo"
  
  Turn on logging to see 
  if that can give something.
  
  Good 
  Luck!
  
  L 
  asr
  
  
  
-Original Message-From: Action Request System 
discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of 
Rick WestbrockSent: Wednesday, September 06, 2006 12:01 
AMTo: arslist@ARSLIST.ORGSubject: Oddity with 
Submitter field in e-mail notifications** 

I'm running 5.1.2 on Windows 2000, MS-SQL 2000 
and I'm seeing inconsistent results from a notification e-mail that is sent 
by a filter. The filter fires on Submit and one of the fields in the body of 
the e-mail is set to Submitter. Most of the time it populates the correct 
user name but I've now seen a couple e-mails go out with Demo as the 
username.
When I check that ticket I see the correct 
username in the status history and work log so I'm puzzled as to why it 
would substitute Demo at all. The frustrating part is that I have two 
e-mails sent within ten minutes of each other and one shows the correct user 
name and the other shows Demo for the Submitter field.
Any clues as to why this might happen? 

-Rick 
_ 
Rick Westbrock PETCO Store Systems WAN Supervisor [EMAIL PROTECTED] __20060125___This 
posting was submitted with HTML in 
  it_20060125___This posting was submitted 
  with HTML in it___ __20060125___This posting was submitted 
  with HTML in it___ 
__20060125___This posting was submitted with HTML in it___

Oracle 9-10

[lars . j . pettersson]

Hi, suppose uppgrading from 6.3 to 7.01, advantages to upgrade Oracle to ver 
10, or ok to keep 9i? (9.2.0 2.0)?
TIA, L ars

L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: [EMAIL PROTECTED]

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Diary Field last entry

[lars . j . pettersson]

Try to perform a set fields, CURRENT TRANSACTION, set a tmp field to $Diary$, 
works for me .../L ars

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Sueli Kanegae
Sent: Monday, September 04, 2006 9:57 PM
To: arslist@ARSLIST.ORG
Subject: Re: Diary Field last entry


Hi List,

I need to know the last entry in a Diary field and was taking a look at old 
exchanged messages. I´ve found a solution below but couldn´t do the Set 
Field:
Most Recent Action
'TR.Work Diary'
I also tried '$TR.Work diary$', but it doesn´t work.

Any other idea to save just the last entry (diary field)in a character 
field? (I don´t need odbc drivers or crystal as Carina does)

Thanks in advance!
Sueli


On Tue, 15 Jun 2004 14:26:16 -0400, Tilton, Claire E. Ms. NGB-ARNG 
[EMAIL PROTECTED] wrote:

Make a field called Most Recent Action (Field Size = 0 or whatever you
feel is appropriate to catch the last diary entry).  Create a filter that
fires on
'TR.Work Diary' != $NULL$.

Do a set fields Most Recent Action := 'TR.Work Diary'.  Then you can
report on that field instead of the work diary.

Thanks,
Claire
-Original Message-
From: Carina Burns [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 15, 2004 1:32 PM
To: ARSLIST@ARSLIST.ORG
Subject: Diary Field Question

Listers,
With the user preference form, you can set the diary field to display the
most recent entry first.  While this works through the forms (whether web
or client,) it doesn't work when using the odbc drivers and crystal
reports -despite using an id with the diary preference set.  The first
entry is displayed rather than the last entry.  Has anyone out there found
a way to retrieve only the last entry or to specify the display order of
the diary entries within a crystal report?

Much Appreciated,

Carina Burns
Database Admin
Richardson ISD
[EMAIL PROTECTED]


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: ARSLIST AWARDS - For Dan

[lars . j . pettersson]

**



No 
plans for something like Sorrento? It's a very long/boring flight from Sweden to 
W US. Any statistics how many arssites outside US compared with 
US-sites?
L 
ars
-Original 
Message-From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED]On Behalf Of straussSent: Monday, 
September 04, 2006 10:32 PMTo: arslist@ARSLIST.ORGSubject: 
Re: ARSLIST AWARDS - For Dan
** 
  
  That would make some sense - late October puts it in 
  the 30-day period between the end of 100+ degree temperatures and the 
  beginning of theice storms.
  Christopher Strauss, Ph.D.Remedy Database 
  AdministratorUniversity of North Texas Computing Centerhttp://remedy.unt.edu/helpdesk/
   
  

  
  From: Action Request System discussion 
  list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Warren 
  BaltimoreSent: Saturday, September 02, 2006 8:45 PMTo: 
  arslist@ARSLIST.ORGSubject: Re: ARSLIST AWARDS - For 
  Dan
  ** 
  There is quite a bit of rumors about next year. I'm thinking 
  Texas.__20060125___This posting was submitted 
  with HTML in it___ 
__20060125___This posting was submitted with HTML in it___

Re: Diary Field last entry

[lars . j . pettersson]

Good ..There is always a solution to everything, sometimes hidden behind deep 
clouds, sometimes just around the corner ...but never say, not impossible ...// 
L ars

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Sueli Kanegae
Sent: Monday, September 04, 2006 10:43 PM
To: arslist@ARSLIST.ORG
Subject: Re: Diary Field last entry


It worked, thank you!

On Mon, 4 Sep 2006 22:07:13 +0200, [EMAIL PROTECTED] wrote:

Try to perform a set fields, CURRENT TRANSACTION, set a tmp field to 
$Diary$, works for me .../L ars

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Sueli Kanegae
Sent: Monday, September 04, 2006 9:57 PM
To: arslist@ARSLIST.ORG
Subject: Re: Diary Field last entry


Hi List,

I need to know the last entry in a Diary field and was taking a look at 
old 
exchanged messages. I´ve found a solution below but couldn´t do the Set 
Field:
Most Recent Action
'TR.Work Diary'
I also tried '$TR.Work diary$', but it doesn´t work.

Any other idea to save just the last entry (diary field)in a character 
field? (I don´t need odbc drivers or crystal as Carina does)

Thanks in advance!
Sueli


On Tue, 15 Jun 2004 14:26:16 -0400, Tilton, Claire E. Ms. NGB-ARNG 
[EMAIL PROTECTED] wrote:

Make a field called Most Recent Action (Field Size = 0 or whatever you
feel is appropriate to catch the last diary entry).  Create a filter that
fires on
'TR.Work Diary' != $NULL$.

Do a set fields Most Recent Action := 'TR.Work Diary'.  Then you can
report on that field instead of the work diary.

Thanks,
Claire
-Original Message-
From: Carina Burns [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 15, 2004 1:32 PM
To: ARSLIST@ARSLIST.ORG
Subject: Diary Field Question

Listers,
With the user preference form, you can set the diary field to display the
most recent entry first.  While this works through the forms (whether web
or client,) it doesn't work when using the odbc drivers and crystal
reports -despite using an id with the diary preference set.  The first
entry is displayed rather than the last entry.  Has anyone out there found
a way to retrieve only the last entry or to specify the display order of
the diary entries within a crystal report?

Much Appreciated,

Carina Burns
Database Admin
Richardson ISD
[EMAIL PROTECTED]


___

UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___

UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Escalation - Cannot change Assignee information

[lars . j . pettersson]

**



AR_ESCALATOR is 
run with admin permissions, yes, maybe you have some workflow checking for 
$USER$ and triggers filters? Try to add and $USER$ != "AR_ESCALATOR" in those 
filters if so. /L ars

  -Original Message-From: Action Request System 
  discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of 
  Menachem, SharonSent: Sunday, September 03, 2006 7:56 
  PMTo: arslist@ARSLIST.ORGSubject: Escalation - Cannot 
  change Assignee information** 
  
  I am trying to run 
  an escalation on ARS 5.1.2 patch 1484 (with Helpdesk 5.6) to change the 
  Assignee information when a the due date of the call is within the next 24 
  hours.The escalation meets the criteria and fires but fails to do the 
  write to the database as it is not being run by the assignee or the 
  application administrator. 
  
  I would have 
  thought that escalations would run by default with the administrator user and 
  therefore would be able to make changes to assigness of the helpdesk 
  cases.Andifthe administrator user is not considered the 
  owner of the Remedy Management application then who the heck is and how can I 
  run an escalation with a specific user?
  
  Any and all 
  insight would be much appreciated.
  
  Thanks,
  Sharon***This 
  email message and any attachments thereto are intended only for use by the 
  addressee(s) named above, and may contain legally privileged and/or 
  confidential information. If the reader of this message is not the intended 
  recipient, or the employee or agent responsible to deliver it to the intended 
  recipient, you are hereby notified that any dissemination, distribution or 
  copying of this communication is strictly prohibited. If you have received 
  this communication in error, please immediately notify the [EMAIL PROTECTED] 
  and destroy the original 
  message.*** 
  __20060125___This posting was submitted with HTML in it___ 

__20060125___This posting was submitted with HTML in it___

Re: Twinkie Experiments - Friday Humor

[lars . j . pettersson]

**



Curious about all this discussion about Twinkies, misi, please bring one 
or two home to Sweden, also a good test of Twinkies capacityto keep the 
qualities during a long flight. L ars

  -Original Message-From: Action Request System 
  discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Mark 
  BlankenshipSent: Friday, September 01, 2006 2:06 PMTo: 
  arslist@ARSLIST.ORGSubject: OT: Twinkie Experiments - Friday 
  Humor** 
  
  

  For Misi, having eaten his first 
  twinkie.
  A scientific analysis of the twinkie
  http://www.twinkiesproject.com/
  
  
  Mark__20060125___This posting was 
  submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___

Re: BMCWorld happenings

[lars . j . pettersson]

**



Yes, 
this was a mistake, Mars wes a great product, I used it several days a week 
during development, and it saved hours of time finding wf, unused menues, good 
for documentation and a lot more. And a great support.I've not been able 
to even start RDP ...L ars

  -Original Message-From: Action Request System 
  discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Rick 
  cookSent: Friday, September 01, 2006 4:10 PMTo: 
  arslist@ARSLIST.ORGSubject: Re: BMCWorld 
  happenings** 
  
  I totally agree with you, but have heard nothing about 
  enhancements to the RDP.
  
  Rick
  
  
  From: Action Request System discussion 
  list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt 
  ReinfeldtSent: Thursday, August 31, 2006 11:33 PMTo: 
  arslist@ARSLIST.ORGSubject: Re: BMCWorld 
  happenings
  ** 
  
  

  
  Rick,
  
  Has there been any 
  mention of reviving MasterARSuite? Or, at the very least, trashing RDP 
  and replacing it with something that really works? J 
  
  
  Sorry to be biased, 
  but I feel the RDP replacing MasterARSuite was a bad ploy. It just 
  doesnt compare.
  
  Thanks!
  Matt
  
  
  
  
  
  From: Rick 
  cook [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, August 31, 
  2006 11:35 PMTo: 
  arslist@ARSLIST.ORGSubject: Re: BMCWorld 
  happenings
  
  Really not all that 
  much. They seemed to be focusing on giving people (including themselves) 
  more time to assimilate, or be assimilated, into the ITSM 7 world. So 
  there will be more tools for managing the business and better connectivity 
  between the applications, but they didn't even mention a version 8 today, or 
  some code name for it.
  
  Not even a projected 
  due date for a next versioncurious.
  
  Rick
  
  
  
  
  From: Action 
  Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gordon M. FrankSent: Thursday, August 31, 2006 6:04 
  PMTo: arslist@ARSLIST.ORGSubject: BMCWorld 
  happenings
  ** 
  Hey all of you 
  BMCWorld attendees!
  
  Was anything new 
  announced at the opening?
  
  Web based Admin Tool 
  maybe
  
  Curious!
  Gordon 
  Frank
  
  --No 
  virus found in this outgoing message.Checked by AVG Free 
  Edition.Version: 7.1.405 / Virus Database: 268.11.7/434 - Release Date: 
  8/30/2006
  __20060125___This posting was 
  submitted with HTML in it___ 
  __20060125___This 
  posting was submitted with HTML in it___ __20060125___This 
  posting was submitted with HTML in it___ __20060125___This 
  posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___

Re: Twinkie Experiments - Friday Humor

[lars . j . pettersson]

**



Hmm...is is really good forhuman beingsto eat those things 
...Maybegood for meI didn't attended the Conference this year ../L 
ars

  -Original Message-From: Action Request System 
  discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Ron 
  GehringSent: Friday, September 01, 2006 4:46 PMTo: 
  arslist@ARSLIST.ORGSubject: Re: Twinkie Experiments - Friday 
  Humor** 
  
  

  
  You may want to call 
  the airline first to see if you are even allowed to carry a Twinkie on 
  board. The chemical makeup of those things may prevent you from being 
  able to board the aircraft ;-)
  
  
  
  
  
  From: Action 
  Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of 
  [EMAIL PROTECTED]Sent: Friday, September 01, 2006 8:17 
  AMTo: 
  arslist@ARSLIST.ORGSubject: 
  Re: Twinkie Experiments - Friday Humor
  
  
  Curious about all 
  this discussion about Twinkies, misi, please bring one or two home to 
  Sweden, also a good test of 
  Twinkies capacityto keep the qualities during a long flight. L 
  ars
  
-Original 
Message-From: Action 
Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Mark 
BlankenshipSent: Friday, 
September 01, 2006 2:06 PMTo: arslist@ARSLIST.ORGSubject: OT: Twinkie Experiments - 
Friday Humor
** 

For Misi, having eaten his first 
twinkie.

A scientific analysis of the 
twinkie

http://www.twinkiesproject.com/





Mark
__20060125___This posting was 
submitted with HTML in it___ 
  __20060125___This 
  posting was submitted with HTML in it___ __20060125___This 
  posting was submitted with HTML in it___
__20060125___This posting was submitted with HTML in it___

Re: OT: Excel

[lars . j . pettersson]

There is, I found it, Use Subtotal, =SUBTOTAL(1;$D2:D$68)

1 means average, so if you use autofilter, the average is only calculated for 
visible rows, very powerful feature. No need to use pivot table, and the 
diagram is changed when the autofilterselection is changed.

L ars

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Chris Williams
Sent: Thursday, August 31, 2006 12:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: OT: Excel


Hi Lars,
  Off the top of my head I can't think of any function that would do exactly 
that,
but depending on what you are trying to achieve, you might be able to get the
results you want from a Pivot Table.
HTH
Chris.

 But data from ars Is there a way, I know it is, to make a diagram based 
 on the
 visible rows when autofilter has been selected for some columns.
 Now I have the formula Average(A2:A120), if I activate autofilter, maybe only 
 22
 rows are returned, so I want average to be calculated only for those 22 rows.
 With my formula now the diagram is not changed as the intervall is the same, 
 in what
 way do I have to change the formula to only use visible rows?

 I think someone has the answer.
 L ars Pettersson
 Vattenfall Business Services Nordic AB
 Action Request System Engineer (Tabasco)
 S-461 88 Trollhättan
 Sweden

 Phone +46 520 888 35 Mobil +46 70 608 99 95
 e-mail: [EMAIL PROTECTED]

 ___
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: BUW:ARSlist Awards .... Tonight!

[lars . j . pettersson]

Yes, why not a on line connection, via webcast or streeming media, web cam or 
something  from the ARSlist Awards evening available for those not beeing 
there ...should have beeen great ...but maybe not possible ..:) /L ars

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Reiser, John J
Sent: Thursday, August 31, 2006 5:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: BUW:ARSlist Awards  Tonight!


We want pictures and video.
Twinkie carnage everywhere. Oh the Humanity.


John J. Reiser
Software Development Analyst
Remedy Administrator/Developer
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:[EMAIL PROTECTED] On Behalf Of Daniel Bloom
Sent: Thursday, August 31, 2006 10:40 AM
To: arslist@ARSLIST.ORG
Subject: ADM:BUW:ARSlist Awards  Tonight!

5:45 p.m. PST Room: Imperial A [If that hasn't changed]

Phil Bautista: how about programming your miniature sign to announce it?

For those of you not able to be here, expect the post of the winners
shortly after the session, if not during.

 Daniel


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Table of User's Logged in

[lars . j . pettersson]

**



Take a look at rrrLic, http://www.rrr.se/en/

This tool analyze the user log in 
arsand the user accountsin the User Formand can give input to 
a change of licenstype, fixed/floating depending of most actice users during 
peek time. This tool have helped us to get a better allocation of fixed 
licences.

Or, You can create wf using initform, and 
calculate last login and numbers of login if that's enought.

L ars



  -Original 
  Message-From: Action Request System discussion list(ARSList) 
  [mailto:[EMAIL PROTECTED]On Behalf Of Dorothy A. 
  MartinSent: Tuesday, August 29, 2006 7:54 PMTo: 
  arslist@ARSLIST.ORGSubject: Table of User's Logged 
  in** 
  
  Does anyone know of a table in Remedy that allows me to query who logged 
  in over a period of time? I know I can tell real-time with the Admin 
  tool, but I wanted to run a query and get a summary of people logged in for 
  the past month.
  
  
  AR Server 6.00
  Help Desk 5.5
  DB = MS SQL 2000
  
  Any ideas would be appreciated.
  
  Regards,
  Dorothy
  
  Dorothy A. MartinIT Customer SupportDesktop Support 
  Analyst302.678.6363[EMAIL PROTECTED]__20060125___This 
  posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___

Web based training whats's new in 7.0?

[lars . j . pettersson]

Anyone taking this course, worth the money? Will it give a good understanding 
of the new features in 7.0? Or is it better to take the ordinary course, admin 
7.0. Or, maybe not neccessary to take any course at all ...? Just install and 
test on Your own and read the documents ...?

L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: [EMAIL PROTECTED]

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: How to verify if the current value entering exists on the database

[lars . j . pettersson]

**



 Why make it so 
complicated


Filter 1:

( 'TR.field' != 'DB.field') AND ( 'TR.field' != 
$NULL$ )

Action, set field,  'field' = $field$ to a tmp field, 
use first matching request, else set to null

Filter 2: Check if the tmp field is null or not, and 
give an errormessage if not null.

L ars

  -Original Message-
  
  From: Action Request 
  System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of 
  Addis SolomonSent: Monday, August 28, 2006 5:43 
  PMTo: arslist@ARSLIST.ORGSubject: Re: How to verify if 
  the current value entering exists on the database** 
  Kelly,
  I followed instruction # 2 however, the lastcount is counting all the 
  records that areon the form instead of only values that matched 
  the current value. Any recommendation?Kelly Deaver 
  [EMAIL PROTECTED] wrote:
  ** 

There are several ways, depending on what you are trying to accomplish. 
I'm going to call the field you are interested in FieldA in my 
examples.

1. If you are trying to assure that no two records have the same value 
in a particular field (FieldA), create a unique index for that field. In the 
Admin tool, open the form and select formform properties. On the Index 
tab, move the desired field to the right column and check the "unique" box 
below. Save. When the user submits a new record, it will say that entry 
violates a unique ID on FieldA.

2.Add a field, FieldB,to number field to check the result 
of an active link you are going to create.Create an active link that runs on 
loose focus, run if - FieldA != Null.Select a set field of the field 
action. Query the form name of the same form (not CURRENT SCREEN) where 
$FieldA$ = 'FieldA'. Set the no match= set the field to null. Set 
multiple match= Use first matching request. Set Field - FieldB= 
$LASTCOUNT$. This will tell you how many already submitted records match the 
current value in FieldA. You can then create an error message if FieldB not 
NULL that tells the user in more detail what you want them to change.

3. Do the same thing with a filter to check on submit and block the 
submit action if you like.

4. If you aren't trying to block, but rather find matches, you can do 
the same as #2 except insteadof setting multiple match to Display a 
List. 
-Kelly DeaverDirector, ITSM 
PracticeXinify[EMAIL PROTECTED]

 
  Original Message Subject: How to verify if the current value 
  entering exists on thedatabaseFrom: Addis Solomon 
  [EMAIL PROTECTED]Date: Sun, August 27, 2006 12:27 pmTo: 
  arslist@ARSLIST.ORG** 
  Can anybody help me how can I check if the current value entering 
  already exists on the database?
  
  Thanks in advance for your help
  
  
  All-new 
  Yahoo! Mail - Fire up a more powerful email and get things done 
  faster. __20060125___This posting was submitted with 
  HTML in it___ __20060125___This 
posting was submitted with HTML in it___ 
  
  
  Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great 
  rates starting at 1¢/min. __20060125___This posting was 
  submitted with HTML in it___
__20060125___This posting was submitted with HTML in it___

Re: Direct SQL

[lars . j . pettersson]

**



Hello, some 
useful sql: (we are using Oracle)


If You know the Formname and want the T Number, use 
this:

SELECT schemaId from 
arschema where name = 'Formname'

If You know 
the T number but will get the formname, use this: 

SELECT name from arschema where schemaId = 
604


If You 
have a databaseid, 536970114 and want to get all forms in your 
applicationwhere this id exists, use this:

SELECT s.name,fieldName FROM field f , 
arschema s WHERE f.fieldID = 536870914 and s.schemaid = f.schemaid order by 
s.name asc


If You 
have a databasename,'Customerno' and want to get all forms in your 
applicationwhere thisname exists, use 
this:


SELECT s.name,fieldName FROM field f , arschema s WHERE f.fieldName = 'Customerno' and s.schemaid = f.schemaid order by 
s.name asc
If You 
want to get all databasenames and databseid'sexisting in a form, use 
this:
select fieldName, fieldId from field where 
schemaId = 604 order by fieldName asc
I have built 
aHelptool for this and I find it very useful when developing and searching 
for errors in the application.
Much more can 
be done, this is only some examples.
L 
ars








  -Original Message-From: Action Request System 
  discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Mimi 
  LakewSent: Sunday, August 27, 2006 6:06 PMTo: 
  arslist@ARSLIST.ORGSubject: Direct SQL** 
  Hi Lisr,
  
  I am trying to use Direct SQL action which I never used before. 
  Myunderstanding is,on the SQL statement the table name has to be 
  defined.Like "select* from tablename"I am trying to search 
  an ARSform, is there anyway tofindwhat the table name is on 
  the database for the form? 
  
  I will appreciate your help!
  
  Mimi
  
  
  Get your email and more, right on the new 
  Yahoo.com __20060125___This posting was submitted with 
  HTML in it___ 
__20060125___This posting was submitted with HTML in it___

Sql limitation

[lars . j . pettersson]

Yes, using views are often the best, but there is a limitation of 30 char.

SELECT count (Mailbox_ID) from AR_System_Email_Mailbox_Configuration returns 
ARERR [552] Failure during SQL operation to the database : ORA-00972: 
identifier is too long

Is this case SELECT count (C1) from T721 works

To avoid using T721 in the code, which will be changed after a migration, get 
the T nr before executing the command.

select schemaid from arschema where name = '$SCHEMA$' 

Save the result, 721 in a tmp field

After that You can run select count (c1) from T$Tnr Form$ where C538170941 = 0 
or whatever you want.

This will work even after a migration. (Databaseid's are not changed)


L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: [EMAIL PROTECTED]

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Picture in Attachment in View Field? Need a good idea...

[lars . j . pettersson]

I must have misunderstood, I though you had the attachment in an att.pool and 
besides a viewfield, in which you wanted to show the file instead of 
doubleklick and open it, and leaving the form. We have 4 slots, and a 
radiobuttonfield 1,2,3,4, if user select 3, file 3 is shown in the viewfield. 
If you delete the file, how can you still show it after that?

L ars

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
Behalf Of Alexander G. Zinoviev
Sent: Wednesday, August 23, 2006 7:55 AM
To: arslist@ARSLIST.ORG
Subject: HA: Picture in Attachment in View Field? Need a good idea...


Hello, Lars,
 
Thanks for your answer!
 
It works only if the path, that stored in the view field exist. It doesn`t work 
if I`ll save file to attachment, then delete file, and then execute set field 
action you said...
 
 
Best regards,
Alexander Zinoviev



От: Action Request System discussion list(ARSList) от имени [EMAIL PROTECTED]
Отправлено: Вт, 22.08.2006 14:14
Кому: arslist@ARSLIST.ORG
Тема: Re: Picture in Attachment in View Field? Need a good idea...


** 
Just use set field action from the attachmentslot to the view field (Active 
Link) / L ars

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL 
PROTECTED] Behalf Of Alexander G. Zinoviev
Sent: Tuesday, August 22, 2006 10:46 AM
To: arslist@ARSLIST.ORG
Subject: Picture in Attachment in View Field? Need a good idea...


** 
Hello,
 
Is it possible to show the picture from attachment field in the view 
field?
 
I have one idea, but I don`t like it. I mean to save an attachment to 
disk and put full picture path to view field.
 
Thanks in advance,
Alexander Zinoviev
__20060125___This posting was submitted with HTML 
in it___

__20060125___This posting was submitted with HTML in it___ 

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Picture in Attachment in View Field? Need a good idea...

[lars . j . pettersson]

Hmm, I thing we must be misunderstanding each other. I have a file in a folder 
somewhere, I add this file to slot 1 in an attachmentspool. Save the request. 
Now is the file in the db. I can now delete the file from the sourcefolder, ars 
knows nothing about this. An Active link can still perform a set field action 
fron the attachmentpool to the viewfield. as the data in within ars, the 
sourcefolder is now irrelevant after you have saved it into the db.

You write 'I see nothing, because view field contains the text c:\pic.jpg', 
?The attachmentslot contains the file, I can't see any referense from the 
sourcefolder.

I tested to add an attachment, deleted the file from the sourse, and after that 
it's still shown in the viewfield. As expected.

L ars

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
Behalf Of Alexander G. Zinoviev
Sent: Wednesday, August 23, 2006 9:38 AM
To: arslist@ARSLIST.ORG
Subject: HA: Picture in Attachment in View Field? Need a good idea...


Hello,
 
For example I have file c:\pic.jpg. A am saving this file to attachment field. 
Then I delete file from c:\pic.jpg. Attachment is still contain the picture. I 
call active link, that makes set field ViewField=Attachment. I see nothing, 
because view field contains the text c:\pic.jpg, but there is no file pic.jpg 
on disk c:, it exist only in attachment!
 
After you make set field you are only copy text from attachment thing...
 
Best regards,
Alexander Zinoviev



От: Action Request System discussion list(ARSList) от имени [EMAIL PROTECTED]
Отправлено: Ср, 23.08.2006 10:06
Кому: arslist@ARSLIST.ORG
Тема: Re: Picture in Attachment in View Field? Need a good idea...



I must have misunderstood, I though you had the attachment in an att.pool and 
besides a viewfield, in which you wanted to show the file instead of 
doubleklick and open it, and leaving the form. We have 4 slots, and a 
radiobuttonfield 1,2,3,4, if user select 3, file 3 is shown in the viewfield. 
If you delete the file, how can you still show it after that?

L ars

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
Behalf Of Alexander G. Zinoviev
Sent: Wednesday, August 23, 2006 7:55 AM
To: arslist@ARSLIST.ORG
Subject: HA: Picture in Attachment in View Field? Need a good idea...


Hello, Lars,

Thanks for your answer!

It works only if the path, that stored in the view field exist. It doesn`t work 
if I`ll save file to attachment, then delete file, and then execute set field 
action you said...


Best regards,
Alexander Zinoviev



От: Action Request System discussion list(ARSList) от имени [EMAIL PROTECTED]
Отправлено: Вт, 22.08.2006 14:14
Кому: arslist@ARSLIST.ORG
Тема: Re: Picture in Attachment in View Field? Need a good idea...


**
Just use set field action from the attachmentslot to the view field (Active 
Link) / L ars

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL 
PROTECTED] Behalf Of Alexander G. Zinoviev
Sent: Tuesday, August 22, 2006 10:46 AM
To: arslist@ARSLIST.ORG
Subject: Picture in Attachment in View Field? Need a good idea...
   
   
**
Hello,

Is it possible to show the picture from attachment field in the view 
field?

I have one idea, but I don`t like it. I mean to save an attachment to 
disk and put full picture path to view field.

Thanks in advance,
Alexander Zinoviev
__20060125___This posting was submitted with HTML 
in it___

__20060125___This posting was submitted with HTML in it___

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org



___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Home Page Button for Non-Home Page?

[lars . j . pettersson]

**



I 
guess this is important too, from the help in RA:

"Any form that contains an application list 
field (id 1575)can be used as a Home Page form. You can insert only one 
application list field on a form. "

L 
ars

  -Original Message-From: Action Request System 
  discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of 
  Michiel BeijenSent: Wednesday, August 23, 2006 1:13 
  PMTo: arslist@ARSLIST.ORGSubject: Re: Home Page Button 
  for Non-Home Page?** Will it be an option just to replace 
  the home page? You can set your own form you would like to use as the Home 
  Page in the Server Information dialog in Remedy 
  Administrator.--Michiel
  On 8/23/06, Chris 
  Abell [EMAIL PROTECTED] 
  wrote:
  Hi 
allI'm attempting to reproduce the functionality provided by the 
Home Pagebutton for a form that *isn't* (and cannot be) the home page. 
For reasonsof brevity it shall hereafter be referred to as "the 
console". Best I can come up with is the following:1. 
Capture the window id of the console in a Global field on window open2. 
When one of the "go to console" buttons is clicked, senda "CloseWindow" 
event to the current console (using aforementioned id). 3. Open a new 
console.Ideally I'd like to be able to send an event that would 
cause the consoleto steal focus (i.e. move to front) so that current 
console information(row selection etc) is retained.Has anyone 
ever done anything like this? Can you suggest an 
alternativeapproach?ThanksChris___UNSUBSCRIBE 
or access ARSlist Archives at http://www.wwrug.org__20060125___This 
  posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___

Re: Picture in Attachment in View Field? Need a good idea...

[lars . j . pettersson]

**



Just 
use set field action from the attachmentslotto the view field (Active 
Link)/ L ars

  -Original Message-From: Action Request System 
  discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of 
  Alexander G. ZinovievSent: Tuesday, August 22, 2006 10:46 
  AMTo: arslist@ARSLIST.ORGSubject: Picture in Attachment 
  in View Field? Need a good idea...** 
  Hello,
  
  Is it possible to show the picture from 
  attachment field in theview field?
  
  I haveone idea, but I don`t like it. 
  I mean to save an attachment to disk and putfullpicture path to 
  view field.
  
  Thanks in advance,
  Alexander 
  Zinoviev__20060125___This posting was 
  submitted with HTML in it___
__20060125___This posting was submitted with HTML in it___

Macros/ASB and field 1005

[lars . j . pettersson]

Hello, anyone seen this: In regular form A is field 1005. You record a macro 
and use ASB in the macro, for example enter data in some fields and on ASB you 
enter 'Status' != 6.
While recording the macro seach returns entries. But, when you try to run the 
macro 'No matching requests'. Delete field 1005 and everything works fine.
Databaselogging when You run the macro shows this: AND 
(dbms_lob.instr(T886.C1005, '''7'' != 6'). What's that?

Macros with forms without 1005 and using ASB, no problems.

This problem is seen on out site for patches  6.3 /003, I have tries with both 
p15.16 and 18, and also with ver 7. But in patch 003 it works as expected.

I have also created a brand new forms with only core fields and added 1005 - 
problem with this macro - delete of 1005, works. This test was done in 6.3 p18.
I have also tried to delete field 1005, save the form and recreate it.

I have reported this to out local ars support.

Anyone else seen this?
L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: [EMAIL PROTECTED]

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Mandatory / Required Field

[lars . j . pettersson]

You can use action Submit (= Create) and have a filter checking if the field is 
null or not, this filter will not trigger when editing already created requests 
(modify). You can also add a filter which don't accept the field to be set to 
null if set before. Based on CTI? Filters can perform anything .. I guess You 
want to make the field required if another field is XXX or check values is 
another form based upon field in your mainfom, ordinary filter actions, no 
problems. /L ars

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Vianna
Sent: Friday, August 18, 2006 8:33 PM
To: arslist@ARSLIST.ORG
Subject: Mandatory / Required Field


Hello

I have been asked to add a new mandatory field to our ticket form.
Unfortunately I have done very little development in the past (my
primary role is administration).

I'm wondering what ramifications adding this field might have?  For
example, I would like it to be mandatory for any new tickets, but if
somebody opens an existing (older) ticket, would they be forced to fill
in something to that field as well?  I don't want that to happen.

Also, is there a way to make a field mandatory based on CTI?

Any help that somebody can offer me would be great.  I'm relatively new
to this user group as well, so if I should be providing more info,
please let me know.  (We're running 5.01.02 patch level 1346 if that
helps?) 

Thank you!!

Vianna

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Mandatory / Required Field

[lars . j . pettersson]

It's also possible to make the field required and use modify all or sql and 
enter N/A for existing requests. For all new requests, create a filter on 
submit for which N/A is invalid. The user have to enter a value but not N/A. 
Sometimes it's better to make the field really required, depends on the 
situation.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Timothy Powell
Sent: Friday, August 18, 2006 9:20 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mandatory / Required Field


If you create a field on your form, and the Entry Mode for that field (as
defined on the Database tab of the Field Properties) is set to Required,
then any submit or modification of a record where that field value is NULL
will result in an error. The record cannot be saved until that required
field has a value.

To make a field conditionally required, create the same field, but this time
set the Entry Mode to Optional. Then you can create workflow (active links
or filters) to enforce value based on conditions that you define. For
instance, in your example, to make a field value required on a new ticket
but not an existing ticket, I'd create a filter that executes on Submit and
the Run If statement is: $YourField$ = $NULL$. Then add an If Action that
throws an Message (type Error). Your message text might say something like
A value for YourField is required in order to submit a new ticket.

Enforce based on C/T/I? Sure...same concept as above, but you modify your
Run If statement to look at particular C/T/I (and/or any other field) values
present in the ticket. But if there is any chance that you might want the
field mandatory based on numerous C/T/Is that you have, I'd do the C/T/I
checking via some type of lookup and have the filter examine the result of
that lookup in order to determine the enforcement.

HTH,

Tim Powell

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Vianna
Sent: Friday, August 18, 2006 2:33 PM
To: arslist@ARSLIST.ORG
Subject: Mandatory / Required Field

Hello

I have been asked to add a new mandatory field to our ticket form.
Unfortunately I have done very little development in the past (my primary
role is administration).

I'm wondering what ramifications adding this field might have?  For example,
I would like it to be mandatory for any new tickets, but if somebody opens
an existing (older) ticket, would they be forced to fill in something to
that field as well?  I don't want that to happen.

Also, is there a way to make a field mandatory based on CTI?

Any help that somebody can offer me would be great.  I'm relatively new to
this user group as well, so if I should be providing more info, please let
me know.  (We're running 5.01.02 patch level 1346 if that
helps?) 

Thank you!!

Vianna


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

ArTask

[lars . j . pettersson]

hi, what could be the reason? Some users have no association to the ARTASK 
icon, AR Shortcut File, command C:\Program Files\AR System\artask.exe %1 
sent in email by filters. But it works for 95%, and some users have told me 
that 'it works now' ...without having done anything special ..we have had the 
same client this year, and the problem came at the same time as we migrated to 
a new version of the application. But, it's not a generall problem ...related 
to the pc rather than to ars I guess.

L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: [EMAIL PROTECTED]

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Search on diary field

[lars . j . pettersson]

This article may help, Oracle
http://www.remedy.com/customers/dht/archive/RxPress_V9_I1_2001_A.htm

L ars

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Shibu Samuel
Sent: Tuesday, August 15, 2006 4:08 PM
To: arslist@ARSLIST.ORG
Subject: Re: Search on diary field


We are on Unix and using Oracle

-Original Message- 
From: Action Request System discussion list(ARSList) on behalf of Frank 
Caruso 
Sent: Tue 8/15/2006 2:58 PM 
To: arslist@ARSLIST.ORG 
Cc: 
Subject: Re: Search on diary field


** It depends on your database. What database and OS are you using?

I can speak for Sybase 12.5 and that it is possible to search a diary 
field.



On 8/15/06, Shibu Samuel [EMAIL PROTECTED] wrote: 

Hi,

Is it possible to perform a search for a keyword on Diary Field 
?
If possible pleae let me know, how i can achieve this.

Sam







-- 
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125___This posting was 
submitted with HTML in it___