New Idea in BMC Developer Communities

[Grooms, Frederick W via ARSList]

https://communities.bmc.com/ideas/19399

In AR 9.x BMC has discontinued the arfork log file.  You'll notice from the
following link the arfork log is not described and in the screenshot it is
grayed out and unavailable:

https://docs.bmc.com/docs/ars91/en/setting-log-files-options-609073755.html
The log option does not appear on the Logs tab in the later releases
because it is no longer used

The arfork log file was the place to find the execution of an external Run
Process command
   Tue Nov 20 07:54:49 2018 Received record marker.
   Tue Nov 20 07:54:49 2018 Spawning child, shell "", command "{FULL
COMMAND LINE}".
   Tue Nov 20 07:54:49 2018 Spawned "{FULL COMMAND LINE}" as pid 56744.
   Tue Nov 20 07:54:49 2018 Awaiting record marker.
   Tue Nov 20 07:54:49 2018 process id 56744 has exited with status 0x0.

This idea is for BMC to bring back logging the external run process actions
in some log file (my preference would be the Thread log file if they do not
wish to use the arfork log again)

Please vote up
Fred
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: [E] Re: Table field refresh in Remedy 18.05

[Grooms, Frederick W via ARSList]

When I do a new action for Change Field It comes up for Field Name.
Somehow your default seems to have changed to Field Value.  That does sound
like a corrupt workspace cache

On Wed, Oct 10, 2018 at 1:16 AM Carl Wilson  wrote:

> Hi Misi,
> Sometimes the Studio crashes and seems to corrupt the stored cache which
> then stops a number of things working.
> Creating a new workspace, or purging the old will rebuild the stored
> objects.
>
> Cheers.
>
> On Tue, 9 Oct 2018, 23:25 Misi Mladoniczky,  wrote:
>
>> Hi Carl!
>>
>> That seems to do the trick :-)
>>
>> Any idea why or when this can happen?
>>
>>
>> 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
>> 
>>
>>
>>
>>
>> October 9, 2018 10:44 PM, "Carl Wilson" > <%22carl%20wilson%22%20%3ccarlbwil...@gmail.com%3E>> wrote:
>>
>> Hi,
>> Try creating a new workspace in the Dev Studio and recreating you AL.
>> Cheers
>> On Tue, 9 Oct 2018, 21:38 Misi Mladoniczky,  wrote:
>>
>> Hi,
>>
>> I am on 18.05, Oracle, Linux.
>>
>> I am trying to do a simple table-refresh from an Active Link, but in Dev
>> Studio I can not even pick the Table-field for the Change Field action.
>>
>> If I load an old Active Link the table field shows, but it is underlined
>> with red and the action does not seem to trigger in Mid-Tier...
>>
>>
>>
>> So how are you supposed to do this? Am I doing some obvious mistake?
>>
>> When running Mid-Tier Active Link logging it looks like this, but the
>> refresh does not happen:
>>
>>
>> When choosing a column instead it looks like this in the Mid-Tier Active
>> Link logging, or in other words nothing happens:
>>
>>
>> Any suggestions?
>>
>> 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
>> 
>> --
>> ARSList mailing list
>> ARSList@arslist.org
>> https://mailman.rrr.se/cgi/listinfo/arslist
>> 
>>
>> --
>> ARSList mailing list
>> ARSList@arslist.org
>> https://mailman.rrr.se/cgi/listinfo/arslist
>> 
>>
> --
> ARSList mailing list
> ARSList@arslist.org
>
> https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist=DwICAg=udBTRvFvXC5Dhqg7UHpJlPps3mZ3LRxpb6__0PomBTQ=IuUzZpoH4G8vKkBa7TmXnNHc2-87dHrFn9R25Pv__1k=inHAvW7nOQwV74xyrwl6LkwV8dL4zKVZGH5X9Ah5Pcw=P5ukU_k0aZ8ABihCoosD6zWwLgFkMQaIBsrLcpW-mnw=
>


-- 

*Fred Grooms*
Senior Software Engineer *|* Network Systems - Service Assurance *|* XO
Communications - A Verizon Company  *|* www.xo.com

Verizon Certified SCRUM Master
*Office:* 972.578.6528 *|* *Fax:* 972.516.3556 *|* *E-mail:*
frederick.w.gro...@verizon.com
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: [E] Re: Strange goings on with Attachments in form Report - 9.1.02 (& most probably prior)

[Grooms, Frederick W via ARSList]

Report may be a little different as there is a form "Report Definition"
that actually stores the definition attachment for a report

Fred

On Fri, Oct 5, 2018 at 10:49 AM Jason Miller  wrote:

> With it described like that, it sounds like some kind of plugin at work.
>
> Jason
>
> On Fri, Oct 5, 2018 at 8:22 AM LJ LongWing  wrote:
>
>> So, you have a record that can get the attachment no problem, but when
>> you look at the DB there is no B or BC entry for the attachment?if this
>> is true then the only way that can possibly be delivered is through the
>> Remedy server, meaning it's not stored in the db at all, it's stored in the
>> Remedy binaries and delivered as if it existed in the db.
>>
>> On Thu, Oct 4, 2018 at 5:56 PM Ben Chernys <
>> ben.cher...@softwaretoolhouse.com> wrote:
>>
>>> Hi LJ,
>>>
>>>
>>>
>>> The attachment field has both a name and contents.  The GUI can save it
>>> no problem (as can Meta-Update now).
>>>
>>> Both the name and contents are delivered with GetEntry.  GetBLOB returns
>>> no entry in database.  There is no record in the B or BC table…
>>>
>>>
>>>
>>> > SthMqry -q select * from B140C212   where entryid =
>>> '842'
>>>
>>> 173747.521 i ArQryGet returns 0 records for select * from B140C212
>>> where entryid = '842'
>>>
>>>
>>>
>>> > SthMsch Report | grep Attach
>>>
>>>212 Report Attachment Field(Report Definition File)  Attach Max:
>>> 0
>>>
>>>
>>>
>>> As for no way – of course there’s a way.  It’s called code.  There may
>>> be special code for this table.  I have not seen this before in any other
>>> table and have saved many attachments from many different tables.
>>> Meta-Archive generates HTML with links to the attachments, so it’s been
>>> tested on ALL the ITSM modules.  The Report table has not been part of the
>>> default Archive configs.
>>>
>>>
>>>
>>> Same results with “driver”.
>>>
>>>
>>>
>>> I highlighted the file name below in red.
>>>
>>> Cheers
>>>
>>> Ben Chernys
>>>
>>> www.softwaretoolhouse.com
>>> 
>>>
>>>
>>>
>>> *From:* ARSList  *On Behalf Of *LJ LongWing
>>> *Sent:* October-04-18 3:40 PM
>>> *To:* arslist@arslist.org
>>> *Subject:* Re: Strange goings on with Attachments in form Report -
>>> 9.1.02 (& most probably prior)
>>>
>>>
>>>
>>> For each Remedy form there is a T, H, and B tables
>>>
>>> T - Data
>>>
>>> H - Status History
>>>
>>> B - Binary (Attachments)
>>>
>>>
>>>
>>> B table is going to have a column for each attachment field, one each
>>> for the file name, original file size, compressed file size.
>>>
>>>
>>>
>>> For each attachment field there will be an additional table...if your
>>> table is 123 and your field id is 543 then your BC table would be
>>>
>>> B123C543
>>>
>>>
>>>
>>> the BC table is the table that contains the actual attachment...
>>>
>>>
>>>
>>> So the B table contains the metadata regarding each of the attachments,
>>> the BC table contains the ACTUAL attachment
>>>
>>>
>>>
>>> so, you are saying that there is no B entry, but is there a
>>> BC?without the BC the Remedy server would have no way of giving you the
>>> contents of the file, without the B it has no way of telling you the name
>>> of the file...
>>>
>>>
>>>
>>> On Thu, Oct 4, 2018 at 2:50 PM Ben Chernys <
>>> ben.cher...@softwaretoolhouse.com> wrote:
>>>
>>> Hi LJ,
>>>
>>>
>>>
>>> Correct.  The same will be on your system (if you have ITSM and perhaps
>>> if you have a whack of languages).
>>>
>>> The GUI handles it OK (as do I now).
>>>
>>>
>>>
>>> What’s a BC table?
>>>
>>>
>>>
>>> > SthMqry -q select * from BC140 where c1 = '842'
>>>
>>> 144304.453 E ARGetListSQL returned an error 2.  Status messages: 1
>>>
>>> 144304.453 E ARGetListSQL ==> 2, 552, The SQL database operation failed.
>>> ORA-00942: table or view does not exist
>>>
>>>
>>>
>>> /Ben
>>>
>>>
>>>
>>> *From:* ARSList  *On Behalf Of *LJ LongWing
>>> *Sent:* October-04-18 2:36 PM
>>> *To:* arslist@arslist.org
>>> *Subject:* Re: Strange goings on with Attachments in form Report -
>>> 9.1.02 (& most probably prior)
>>>
>>>
>>>
>>> So, you are saying that you have a record in a table (Report) that's
>>> reporting that it has an attachment in an attachment field, but when you go
>>> look at the B table it's not showing there?...what about if you look in the
>>> BC table?  Is the record there?
>>>
>>>
>>>
>>> On Thu, Oct 4, 2018 at 1:27 PM Ben Chernys <
>>> ben.cher...@softwaretoolhouse.com> wrote:
>>>
>>> Hi Folks,
>>>
>>>
>>>
>>> I discovered something curious about attachment fields.  I've never had
>>> an attachment field which had a value (ie a file) with a non-null location
>>> in a myriad of tables.  I got one such from the Report table.  A type =
>>> buffer.  Locations 

RE: What is locking my account?

[Grooms, Frederick W]

Maybe I’m confused, but I think there may be an error in your code
You are setting the port to  serverPort, but your integer value is just port


From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Thomas 
Miskiewicz
Sent: Tuesday, March 20, 2018 11:12 AM
To: ARSList 
Subject: Re: What is locking my account?

Thank you Keith, good to know.

1. We’re not windows.

2. We don’t have more than one server defined in the mid-tier

I rather thing that it’s related to a ARS bug which attacks when we use our ARF 
Plugin.


Thomas


On Mar 20, 2018, at 5:05 PM, 
spearmint.l...@gmail.com wrote:

I haven't followed this whole thread, so not sure if this was mentioned. We had 
a problem in the past where if you had more than one AR server defined in the 
mid-tier, then anytime you try to login it attempts to log into each AR server 
defined. So if you have three AR servers defined, and your Windows system is 
set to lock after three bad attempts, then just one incorrect password when 
trying to log in will lock you out.

Regards,
Keith

On Tue, Mar 20, 2018 at 6:14 AM Thomas Miskiewicz 
> wrote:
Unfortunately it’s still locking.

I enabled all kinds of debugs and see this:

Di Mär 20 10:41:19.086 2018 Preparing context to be sent to pluginserver -  
User : NULL, sessionId : 0, authGuid : NULL, cacheId : 9279, threadId : 366
360393 Di Mär 20 10:41:19.099 2018 Preparing context to be sent to 
pluginserver -  User : NULL, sessionId : 0, authGuid : NULL, cacheId : 9280, 
threadId : 366
360394 Di Mär 20 10:41:19.109 2018 Preparing context to be sent to 
pluginserver -  User : NULL, sessionId : 0, authGuid : NULL, cacheId : 9281, 
threadId : 366
360395 Di Mär 20 10:41:19.118 2018 Preparing context to be sent to 
pluginserver -  User : NULL, sessionId : 0, authGuid : NULL, cacheId : 9282, 
threadId : 366
360396 Di Mär 20 10:41:33.252 2018/* 
Di Mär 20 2018 10:41:33.2520 */ Escalation Trace Log -- ON (AR Server 9.1.04 
201711272256)
360397 Di Mär 20 10:41:33.418 2018/* 
Di Mär 20 2018 10:41:33.4180 */ Escalation Trace Log -- ON (AR Server 9.1.04 
201711272256)
360398 Di Mär 20 10:41:33.650 2018 Preparing context to be sent to 
pluginserver -  User : NULL, sessionId : 0, authGuid : NULL, cacheId : 9292, 
threadId : 366
360399 Di Mär 20 10:41:33.660 2018 Preparing context to be sent to 
pluginserver -  User : NULL, sessionId : 0, authGuid : NULL, cacheId : 9293, 
threadId : 366
360400 Di Mär 20 10:41:33.667 2018 Preparing context to be sent to 
pluginserver -  User : NULL, sessionId : 0, authGuid : NULL, cacheId : 9294, 
threadId : 366
360401 Di Mär 20 10:41:35.095 2018 Preparing context to be sent to 
pluginserver -  User : ize0578, sessionId : 0, authGuid : NULL, cacheId : 8439, 
threadId : 403
360402 Di Mär 20 10:41:35.962 2018 Preparing context to be sent to 
pluginserver -  User : ize0578, sessionId : 0, authGuid : NULL, cacheId : 8439, 
threadId : 401

@Doug - what does User: NULL mean? How is that possible?


Thomas




On Mar 15, 2018, at 9:41 AM, Thomas Miskiewicz 
> wrote:

Thank you, Rajesh! I will delete my account completely and try again.

Thomas

On 15. Mar 2018, at 09:37, Rajesh Nair 
> wrote:
Not sure if this is going to help,
i remember facing such issue but not in ARS but frequently on my machine which 
i am using it

Issue turned out to be problem in user's cache where the password has been 
stored. My account used to get locked automatically, even though i was using 
the correct password.
I had to delete the old entries and the issue got fixed.

On Wed, Mar 14, 2018 at 6:22 PM, Thomas Miskiewicz 
> wrote:
Hi Doug,

I got an AR Filter Plugin which uses the context of the current user which in 
this case even happens to be an Admin User.

public List filterAPICall(ARPluginContext context, List inValues)
{
if (context!=null) {
String sPort=context.getARConfigEntry("TCD-Specific-Port");
Integer port=new Integer(sPort);

ARServerUser arCtx = new ARServerUser(context, "de_DE", "localhost");
arCtx.setPort(serverPort);
}
}

Everything works well until it doesn’t. At some point I see in the plugin log 
that authGuid ist empty…

Mi Mär 14 12:36:27.527 2018 Preparing context to be sent to pluginserver -  
User : ize0578, sessionId : 118, authGuid : PAGAAFGYFE3BUAPFKWINPEO0LWMIJ1, 
cacheId : 118, threadId : 323
Mi Mär 14 12:36:27.541 2018 Preparing context to be sent to pluginserver -  
User : ize0578, sessionId : 118, authGuid : PAGAAFGYFE3BUAPFKWINPEO0LWMIJ1, 
cacheId : 118, threadId : 323
Mi Mär 14 12:36:27.563 2018 Preparing context to be sent to pluginserver -  
User : ize0578, sessionId : 118, authGuid : PAGAAFGYFE3BUAPFKWINPEO0LWMIJ1, 
cacheId : 118, threadId : 323
Mi Mär 14 

RE: How to enable logging for a filter plugin in Remedy 9.1.x?

[Grooms, Frederick W]

Check this link
https://docs.bmc.com/docs/ars91/en/enabling-server-side-ar-system-logs-609073593.html

You may have to adjust the  conf/logback_server.xml

Searching the communities for logback_server.xml found a large number of 
articles on many different types of logs.  You may be looking for the logging 
on internal server plugins.

Fred

-Original Message-
From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Thomas 
Miskiewicz
Sent: Tuesday, March 13, 2018 4:04 PM
To: ARSList 
Subject: How to enable logging for a filter plugin in Remedy 9.1.x?

Hello there,

I set logging to TRACE in AR System Administration Plugin Server Config Form, 
enabled Plugin Logging, set Logging in log4j_pluginsvr.xml to debug but I still 
get no logs for Filter Plugins.

Any idea how to do it?


Thomas
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

RE: Phase 3 Filter action threw ARERR and deleted record from form

[Grooms, Frederick W]

>From your description, as long as nothing else but the Filter that calls the 
>Run Process is executed on Submit then the record in your staging form should 
>still be there.

This is the same methodology we use for all of our external interfaces.

-  External system inserts record in Interface/Staging form as "New" 
(Usually thru a web service)

-  On Submit filter does Run Process action to call external utility to 
change status to "Ready".  (This filter should not have the `! )

-  Filters to process data run on Modify/Merge when status is "Ready" 
(and when complete set status to "Complete")

If there is an error in processing the data the Interface/Staging record is 
still there as "New".  The other main reason we use this method is if we are 
working with a complex web service call (with child forms), this will allow the 
AR System to save the child records (in the phase 2 of the web service process 
from the external system) so they are available when we go to process the data.

Fred

From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Narayanan, 
Radhika
Sent: Wednesday, March 07, 2018 8:17 AM
To: ARSList 
Subject: Phase 3 Filter action threw ARERR and deleted record from form

Hi,

I was under the impression that if a Phase 3 action on a submit filter met with 
ARERR error, then the submitted record will still be present on the form , will 
not get deleted or rolled back. However, I observed quite the contrary on ARS 
8.1.02.  Have you come across this before and how did you overcome?

I have a custom form on ITSM 8.1.02. Another system creates records into the 
custom form by consuming Remedy's web service [USER: webservices.user]. A 
filter on submit on the custom form has a Run process action  that executes a  
batch file. The batch file uses BMC javadataimport utility to import status 
into the same record that was just submitted [User: import.user]. Merge filters 
fire when that particular status value is set. One of the merge filters met 
with ARERR. After that the record submitted also got deleted ! Is this expected 
behavior?

> 1: Push Fields -> "SRM:SMI:InboundTxn_inbound-notify-ack`!" (ARERR 
> 286)
    Error while performing filter action: Error 286
    Filter "SRM:SMI:InboundTxn_inbound-notify-ack`!": No enabled 
error handler
End of filter processing (phase 1) -- Operation - MERGE on SRM:SMI:StagingForm 
- TSF13524329

*/DELETE FROM T3636 WHERE C1 = 'TSF13524329'

Thanks,
Radhika Narayanan
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

FW: [Remedy AR System] Announcement: Checkout Remedy Test Automation Libraries

[Grooms, Frederick W]

For those not also in the BMC Communities

From: Vishnu Nair [mailto:for...@developer.bmc.com]
Sent: Thursday, February 22, 2018 2:28 AM
Subject: [Remedy AR System] Announcement: Checkout Remedy Test Automation 
Libraries

BMC Communities

Announcement: Checkout Remedy Test Automation Libraries

created by Vishnu 
Nair
 in Remedy AR 
System



Test Automation libraries are tons of JavaScript functions developed by Remedy 
team. You can use these libraries in the test automation scripts and automate 
complex scenarios very easily. These automation libraries can help you to 
identify the SmartUI and mid-tier UI seamlessly.

Checkout Remedy Test Automation 
Libraries now!

Announcement expires on 1 March, 2018



Thank you for your participation in BMC Communities.
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

RE: Pentaho Spoon

[Grooms, Frederick W]

Thanks …. I realized I forgot to add ARS 8.1.02

From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Ashish Joshi
Sent: Thursday, February 15, 2018 12:08 PM
To: ARSList <arslist@arslist.org>
Subject: Re: Pentaho Spoon

Mark's suggestion is on the spot.

I guess there's already a hotfix available for this.

Please contact BMC Support

Regards,

Ashish Joshi
+91 9766 928 678

On Thu, Feb 15, 2018 at 11:01 PM, Walters, Mark 
<mark_walt...@bmc.com<mailto:mark_walt...@bmc.com>> wrote:
You don’t mention you version but I think are hotfixes to address this – see 
https://communities.bmc.com/docs/DOC-62897 or contact Support for details.

Mark

From: ARSList 
[mailto:arslist-boun...@arslist.org<mailto:arslist-boun...@arslist.org>] On 
Behalf Of Grooms, Frederick W
Sent: 15 February 2018 16:06
To: 'ARSList' <arslist@arslist.org<mailto:arslist@arslist.org>>
Subject: Pentaho Spoon

Our security team has recently started doing additional scans of our servers 
and we started getting errors on the Remedy systems stating that HTTP TRACE was 
enabled.  I tracked it down to the embedded Jetty inside the Pentaho Spoon 
(Atrium Integrator) process.

Does anyone know how to disable the HTTP TRACE method of the embedded Jetty?

Thanks
Fred
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, 
Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 
1927903 The content of this email is confidential. If you are not the 
addressee, you may not distribute, copy or disclose any part of it. If you 
receive this message in error, please delete this from your system and notify 
the sender immediately.

--
ARSList mailing list
ARSList@arslist.org<mailto:ARSList@arslist.org>
https://mailman.rrr.se/cgi/listinfo/arslist

-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Pentaho Spoon

[Grooms, Frederick W]

Our security team has recently started doing additional scans of our servers 
and we started getting errors on the Remedy systems stating that HTTP TRACE was 
enabled.  I tracked it down to the embedded Jetty inside the Pentaho Spoon 
(Atrium Integrator) process.

Does anyone know how to disable the HTTP TRACE method of the embedded Jetty?

Thanks
Fred
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

RE: Basic AR System version 9.1.04

[Grooms, Frederick W]

Active Links and Filters are still the same.  We have a non-prod on 9.1.x

Fred

From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Reiser, John J
Sent: Friday, January 19, 2018 1:35 PM
To: arslist@ARSLIST.ORG
Subject: Basic AR System version 9.1.04

Hello Listers,

Has anyone using inhouse created forms and workflow upgraded to 9.1.X?
Has anything changed drastically from 8.1.2?
I saw something a while ago about not using Active Links and filters anymore or 
are they just changing the names ( like when Schemas became Forms )?


Thank you,
---
John J. Reiser
Building 760-J202
Remedy AR System Developer
Senior Software Development Analyst
Lockheed Martin - RMS Moorestown Region
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me



-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

RE: Macro Questions

[Grooms, Frederick W]

Since you are on 8.1.2 you can always query the form  “AR System Metadata: 
actlink_macro” for what is in the system.
ShortText + LongText should give you the actual macro.
Using the actlink ID against the “AR System Metadata: actlink” form will give 
you which Active Links they exist in.

Personally if there are not too many I think it might be better to recreate 
what they are doing instead of converting.

Fred

From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Keith Sinclair
Sent: Monday, January 08, 2018 8:54 AM
To: ARSList 
Subject: Macro Questions

Okay, so circling back to something very old here… We have been asked to pull a 
list of all macros continued in the Active Links. Problem is that we are using 
version 812. Is there any easy way to get a list of all the  macros from a DEF 
file? Also, does anyone have a copy of Remedy 5 or 6 admin tool that has the 
Macro conversion utility or know of a third party application that can do the 
job?
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

RE: Date format in Java API search criteria

[Grooms, Frederick W]

What if you do set ARDATE?

From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Misi Mladoniczky
Sent: Wednesday, December 13, 2017 10:46 AM
To: ARSList 
Subject: Re: Date format in Java API search criteria

Hi,

Well, on my Ubuntu-machine it apparently defaults to the Swedish format 
"-MM-DD HH:mm:ss". One of my clients using that same program are 
successfully using the format "M/D/ h:mm:ss a"...

I tried changing my LANG environment variable without success. It seems to pick 
up some other system setting.

My standard setting:
locale
LANG=sv_SE.UTF-8
LANGUAGE=sv
LC_CTYPE="sv_SE.UTF-8"
LC_NUMERIC=sv_SE.UTF-8
LC_TIME=sv_SE.UTF-8
LC_COLLATE="sv_SE.UTF-8"
LC_MONETARY=sv_SE.UTF-8
LC_MESSAGES="sv_SE.UTF-8"
LC_PAPER=sv_SE.UTF-8
LC_NAME=sv_SE.UTF-8
LC_ADDRESS=sv_SE.UTF-8
LC_TELEPHONE=sv_SE.UTF-8
LC_MEASUREMENT=sv_SE.UTF-8
LC_IDENTIFICATION=sv_SE.UTF-8
LC_ALL=

I reset LC_ALL and get this, but the parseQualification still uses the same 
-MM-DD format:
locale
LANG=en_US.UTF-8
LANGUAGE=sv
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=en_US.UTF-8

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




December 13, 2017 5:29 PM, "LJ LongWing" 
>
 wrote:
okthat's a very good question that I've never had to explore.the API 
defaults to MM-DD- HH:MM:SS type of formatwhich is standard in America 
(and just about nowhere else)I've never had to deal with date/time 
formatting in the Java APIso sorry, I don't have a ready answer for you :|
On Wed, Dec 13, 2017 at 9:15 AM, Misi Mladoniczky 
> wrote:
Hi,

You sort of understood.

It concerns controlling the date+time format when the Java-API program is 
calling the parseQualification method.

In a C-API program, you just set the environment variable ARDATE before running 
it, and it will use the specified format.

So how can you control this before running a Java-API program?

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


December 13, 2017 5:11 PM, "LJ LongWing" 
>
 wrote:
I'm sorry Misi, I'm not sure I understand your inquiry...are you asking how do 
you tell the Java api that when using the parseQualification method what format 
a date, included in that string is?
On Wed, Dec 13, 2017 at 9:04 AM, Misi Mladoniczky 
> wrote:
Hi,

How do you control which date format is used by a client Java ARAPI program 
when parsing the qualifier string before q query?

In the C-API you would set environment ARDATE="%Y-%m-%d %H:%M:%S" or similar.

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

--
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

--
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

RE: New Chrome versions

[Grooms, Frederick W]

Google has released v63 of Chrome and the issues no longer happen

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Friday, November 17, 2017 9:51 AM
To: arslist@ARSLIST.ORG
Subject: Re: New Chrome versions

**
I'd be interested to see if you upgrade to the 63 beta, if the problem is 
resolved though :)

On Fri, Nov 17, 2017 at 7:51 AM, Grooms, Frederick W 
<frederick.w.gro...@xo.com<mailto:frederick.w.gro...@xo.com>> wrote:
**
I did not have the issue with MT 9.1.002 and Chrome 61, only 62
The funny one is I have a form where some buttons are default visible (an AL 
hides them on Window Open) and with Chrome 62 they stay visible but as you 
cursor over them they disappear

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of LJ 
LongWing
Sent: Friday, November 17, 2017 8:32 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: New Chrome versions

**
https://communities.bmc.com/docs/DOC-101247

On Tue, Nov 14, 2017 at 12:12 PM, Grooms, Frederick W  wrote:
 Has anyone seen issues in the new Chrome version where workflow fires to make 
a field Visible (or Hidden) and the screen doesn't change?

Fred




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

_ARSlist: "Where the Answers Are" and have been for 20 years_
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: Question about PERFORM-ACTION-OPEN-ATTACHMENT

[Grooms, Frederick W]

First ...  Is 536880912 your attachment pool or attachment field?   It should 
be your attachment field you want to open.
Second ... You don't need to use a set fields action as nothing is returned 
from the open so just use a Run Process action of 
PERFORM-ACTION-OPEN-ATTACHMENT 536880912

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Fawver, Dustin
Sent: Tuesday, November 21, 2017 6:57 PM
To: arslist@ARSLIST.ORG
Subject: Question about PERFORM-ACTION-OPEN-ATTACHMENT

**
Hi, Experts!

I have a primary ticket form and a secondary form that has just an attachment 
pool.  The primary form has a table that lists the entries in the secondary 
form associated with the current request.  I can see the list and successfully 
call the secondary form from the primary one in order to add additional 
attachments.  For users to view the attachments, I could simply leave the table 
drill down option to True.  This would simply open up the secondary form and 
the user would then click on the Display button.  I wanted to make it a bit 
nicer than that by having the user just double-click on the entry in the table 
and display the attachment.

I currently have a separate view created for this purpose.  I've tried it with 
just an empty view and I've tried it having the attachment pool and attachment 
field in the view.  I have an active link that checks the $VUI$ value to match 
the view in question.  If it matches, I have a Set Fields action that calls 
"$PROCESS$ PERFORM-ACTION-OPEN-ATTACHMENT 536880912".  The AL fires off, but 
I'm getting a failure code of 2.

I'm not sure if there's a server-side log that I can turn on to see what may be 
causing this.  If you think that I'm misunderstanding the purpose of the open 
attachment action, please let me know.

This is on ARS 9.1.02.
Thanks!
Dustin Fawver
Sr. Help Desk Technician
Information Technology Services

P: 423-439-4648
itsh...@etsu.edu
[itslogo]




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

Re: New Chrome versions

[Grooms, Frederick W]

I did not have the issue with MT 9.1.002 and Chrome 61, only 62
The funny one is I have a form where some buttons are default visible (an AL 
hides them on Window Open) and with Chrome 62 they stay visible but as you 
cursor over them they disappear

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Friday, November 17, 2017 8:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: New Chrome versions

**
https://communities.bmc.com/docs/DOC-101247

On Tue, Nov 14, 2017 at 12:12 PM, Grooms, Frederick W  wrote:
 Has anyone seen issues in the new Chrome version where workflow fires to make 
a field Visible (or Hidden) and the screen doesn't change?

Fred






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

Re: Is there a state of the art way to prevent unauthorised access to Form Views in Mid Tier?

[Grooms, Frederick W]

Form views don't have permissions so the only way I know to do it is to use an 
Active Link on Window Open where you are checking $VUI$

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Thomas Miskiewicz
Sent: Friday, November 17, 2017 7:42 AM
To: arslist@ARSLIST.ORG
Subject: Is there a state of the art way to prevent unauthorised access to Form 
Views in Mid Tier?

**
Hello there,

I have Form A with User View and Admin View. How can I prevent unauthorised 
access to the Admin View?

If there is no configurable state of the art way maybe you have an elegant idea 
how to achieve it?


Thank you

Thomas



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

Re: [EXTERNAL] Re: New Chrome versions

[Grooms, Frederick W]

Actually the issue is I have code that hides (or makes visible) buttons and 
other objects based on other fields and for some reason on the new version of 
Chrome that code is not updating the screen even though I can see in the 
logging window the Active Links firing.   Other browsers on the same machine 
work correctly.

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Fawver, Dustin
Sent: Tuesday, November 14, 2017 4:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: [EXTERNAL] Re: New Chrome versions

**
I’m on 9.1.02 (no patch level) for both AR and MT.  If I open up my (custom) 
ticket form, I have a button that opens up a dialog panel on the form.  It 
works for me in Chrome.  The button on the panel that closes the panel also 
works.  I’m not sure if that’s the same thing that you were trying to 
accomplish.

Dustin Fawver
Sr. Help Desk Technician
Information Technology Services

P: 423-439-4648
itsh...@etsu.edu<mailto:itsh...@etsu.edu>
[itslogo]<http://www.etsu.edu/helpdesk>

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller
Sent: Tuesday, November 14, 2017 4:34 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: [EXTERNAL] Re: New Chrome versions

**
Hmmm.  Now that you mention the logging part I had a coworker at a another 
job that was experiencing the same thing on 9.1.x. It was driving him crazy. 
Although he was likely using IE since that was the standard there.

Jason

On Tue, Nov 14, 2017 at 3:27 PM, Grooms, Frederick W  wrote:
**
We are on MT version 9.1.02.002 against an 8.1.2 server.
We can see the workflow fire in the log window, but the action doesn’t seem to 
happen.  In testing with IE and Firefox both seem to be working correctly.

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Jason 
Miller
Sent: Tuesday, November 14, 2017 2:31 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: New Chrome versions

**
What version of AR/MT?

We are seeing a strange issue in ITSM Incident on MT 9.1.03.001 where looking 
up the Customer doesn't seem to fire all of the AL workflow. The workflow sets 
the field to the CTM:People record ID when choosing a name and the other AL 
workflow fires and eventually replaces that with the name of the person. What 
we sporadically see is the record ID doesn't get replaced (like the rest of the 
workflow isn't firing).

So far we have only seen it in Chrome; which is our primary browser so it 
probably hasn't been tested or experienced in any other. It happens 
inconsistently so it has been hard to track down what is really happening (or 
not happening). At this point we are likely just going to wait for SP 4.

Jason

On Tue, Nov 14, 2017 at 1:12 PM, Grooms, Frederick W  wrote:
 Has anyone seen issues in the new Chrome version where workflow fires to make 
a field Visible (or Hidden) and the screen doesn't change?

Fred



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

Re: New Chrome versions

[Grooms, Frederick W]

We are on MT version 9.1.02.002 against an 8.1.2 server.
We can see the workflow fire in the log window, but the action doesn’t seem to 
happen.  In testing with IE and Firefox both seem to be working correctly.

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller
Sent: Tuesday, November 14, 2017 2:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: New Chrome versions

**
What version of AR/MT?

We are seeing a strange issue in ITSM Incident on MT 9.1.03.001 where looking 
up the Customer doesn't seem to fire all of the AL workflow. The workflow sets 
the field to the CTM:People record ID when choosing a name and the other AL 
workflow fires and eventually replaces that with the name of the person. What 
we sporadically see is the record ID doesn't get replaced (like the rest of the 
workflow isn't firing).

So far we have only seen it in Chrome; which is our primary browser so it 
probably hasn't been tested or experienced in any other. It happens 
inconsistently so it has been hard to track down what is really happening (or 
not happening). At this point we are likely just going to wait for SP 4.

Jason

On Tue, Nov 14, 2017 at 1:12 PM, Grooms, Frederick W  wrote:
 Has anyone seen issues in the new Chrome version where workflow fires to make 
a field Visible (or Hidden) and the screen doesn't change?

Fred






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

New Chrome versions

[Grooms, Frederick W]

 Has anyone seen issues in the new Chrome version where workflow fires to make 
a field Visible (or Hidden) and the screen doesn't change?

Fred

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

Re: Installing Remedy 7.6.0.4 on Windows 2016

[Grooms, Frederick W]

Are you using the ITSM canned application?   
If you are using just custom applications you can use ARS 8.1.x or 9.1.x and 
the User tool will still work.   

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of NormD
Sent: Friday, November 03, 2017 9:41 AM
To: arslist@ARSLIST.ORG
Subject: Installing Remedy 7.6.0.4 on Windows 2016

We're stuck using 7.6.0.4 due to end-user needs for the client.  We need to
upgrade the OS as Windose2003 is no longer supportable.  

I've tried installing it on Windows 2016 using Java 1.6 as the installer
would not recognize 1.8x or 9x.
Noted during the install, the installer did not list IIS for the web server
but continues the install only to fail in the long run.  I've also added the
IIS 6 compat packs and retried the install but get the same results. The
installer does not see IIS, and the redirector does not get setup.

I've tried to manually setup the redirector but again Remedy install fails. 

Has anyone migrated to Remedy ARS 7x to Windows 2016 successfully? If so can
you share your setup process.

Regards
Norm Dignard 
   

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

Re: How to call a .sh script located in remote unix box from the remedy server 8.1 on windows using the FILTER Run Process command?

[Grooms, Frederick W]

So you have a filter calling  batch file

Is this what is in your batch file?   
   C:\plink -l  -pw * stemipt /usr/opt/temip_tttls/Runtime/OpenCTI.sh 
CLOSE "$Request ID$"   

If so then your issue is $Request ID$, as your batch will never know what that 
is.   Your batch should be:   
   C:\plink -l  -pw * stemipt /usr/opt/temip_tttls/Runtime/OpenCTI.sh 
CLOSE "%1"

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Abhishek Anand
Sent: Sunday, October 15, 2017 1:43 AM
To: arslist@ARSLIST.ORG
Subject: How to call a .sh script located in remote unix box from the remedy 
server 8.1 on windows using the FILTER Run Process command?

Hi  Experts,
 
 
How to call a .sh script located in remote unix box  from the  remedy server 
8.1  on windows using the FILTER Run Process command?
 
I have designed the close_tt.bat file in my local system which in turn is 
calling below script residing on remote server:-
 
C:\plink -l  -pw * stemipt /usr/opt/temip_tttls/Runtime/OpenCTI.sh 
CLOSE "$Request ID$"
 
I am using below logic in FILTER Run Process command line but its failing :-
 
cmd /c C:\Users\An**\Desktop\close_tt.bat "$Request ID$"
 
Early response will be highly appreciated.
 
Regards,
AA

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

Re: What's the NextId?

[Grooms, Frederick W]

Where is there a difference in the time to create the next ID
   UPDATE ARSCHEMA SET NEXTID = NEXTID + 1 WHERE SCHEMAID = x
   UPDATE ARSCHEMA SET NEXTID = NEXTID + 100 WHERE SCHEMAID = x
It is not like the database goes 1+1+1+1+1+1…   with a save to the file each 
time.

My db bottleneck was pure ARS workflow.  Legal required an audit trail on some 
15 fields of the main form.  One user doing an update on the main form could 
then generate 15 new child records in an audit table.  Multiply that by 200 
users and you get a possibility of 3000 new records at a given time for a 
single table.  Actual results in the SQL.log showed that in a 5 minute 
timeframe the Set NEXTID was called for the audit table 23 times when the size 
was set to 20 (460 new records in the audit table in 5 minutes from 1 ARS 
server).  Bumping the size to 100 eliminated the Oracle db_lock contention 
errors.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook
Sent: Thursday, October 12, 2017 7:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: What's the NextId?

**
Abhijeet, my results were repeated and conclusive.  Here is the only logical 
explanation for my findings that makes sense:

There is a time cost to the DB call for Entry IDs.  The cost increases 
incrementally the more that are requested at once.  The thought is that 100 
individual requests will take substantially more time than retrieving 100 IDs 
in one request.  That thought has been proven to be correct - it's why the 
feature was added. However, the difference in time was tested against a system 
that had multiple sources (NMS) attempting to grab multiple Entry IDs at the 
same time, not a normal system without those multiple outside requests, because 
it was the first environment that was reporting the problem with performance.

On a system where the volume of IDs is high enough to cause a system bottleneck 
at the DB ID request, which requires multiple simultaneous requests from 
different sources, that bottleneck costs more additional time than is lost by 
the increased time it takes to request multiple IDs at one time.  However, on a 
system that is not bound by the Next ID calls to the DB, or has only a single 
source (AR System) requesting IDs, there is no advantage gained by the multiple 
requests, because the time "gained" by having a cached ID is negligible - too 
small to even notice.  And, as my testing proved (to my surprise), there was an 
increasing net cost to system performance as the number of IDs requested in a 
single call grew.  This must be because the time it takes to gather, say, 100 
records in one call is actually *higher* than it is to do 100 individual calls 
- IF AR System is the only source of those calls.  The simple correlation is 
that if AR System is the only thing generating new Request ID requests to the 
DB, you don't need, and will not benefit from, a number larger than 1.  If you 
have multiple outside entities creating large number of records at once, you 
very well may benefit from it.

My tests that showed decreasing performance as the Next Id block grew were 
creating about 1.5 million records, but, and this is important - all were from 
the same source - AR System workflow.  There were no other simultaneous demands 
on the table, and few on the system.  Therefore, the system of generating one 
ID at a time had a cumulatively lower transaction time than it did when it had 
to wait for multiples to be retrieved and then allocated individually.  The BMC 
Engineer, who I know to be very smart and experienced with Remedy, had no 
explanation for my results.  I believe this to be that BMC didn't test against 
a control (normal) system, and therefore had no data on its effect on them.

Why then, they chose to recommend that setting to all customers, is a mystery 
to me.

Rick Cook

On Thu, Oct 12, 2017 at 4:56 PM, Gadgil, Abhijeet 
> wrote:
**
Rick, I do not think that is accurate.
Logically, if the block size is 100 then the server will access the DB once to 
retrieve the next block id every 100 records.  If it is 1, then the server goes 
to the DB for every record.
Later cannot be faster.

Further, to answer the original question, returning the next id in an API call 
would mean preventing creation of ids by anyone other than the caller until the 
id has actually been used -- otherwise the information might be obsolete before 
the client receives it. That is the reason for not exposing it via an API

Regards,
Abhijeet


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook
Sent: 13 October 2017 02:12
To: arslist@ARSLIST.ORG
Subject: Re: What's the NextId?

**
Here's the skinny on that.  I got this from the engineer who built that 
feature, btw.

The problem was that system performance was 

Re: What's the NextId?

[Grooms, Frederick W]

Actually I had a case where we needed Next ID > 1 due to DB performance.   It 
wasn’t on the primary form, it was on a child form (something like the Worklog 
in ITSM where every action to a ticket is recorded).  The database was being 
blocked on the update of the Arschema record for that form.  On the primary 
(i.e. HelpDesk) form the size is set to 1.

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook
Sent: Thursday, October 12, 2017 3:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: What's the NextId?

**
Here's the skinny on that.  I got this from the engineer who built that 
feature, btw.

The problem was that system performance was being constricted around the action 
of getting the NextId for a record when multiple sources (say, Netcool and 
HPOV) were throwing tons of requests at the (Incident) form at the same time.  
The process of getting each Next Entry ID in individual DB calls was 
bottlenecking the process of creating the records.  So that's why BMC came up 
with a way to pre-allocate those in bulk, so that only every N times (whatever 
the number is set to) would an actual call to the DB to get Next IDs be 
necessary.  The transaction time to retrieve 1 or 100 wasn't much different, 
and those customers with multiple programs requiring many simultaneous record 
creations saw a marked performance increase.  It was, and is, a good feature 
add.

So (then a miracle occurs) and BMC announces that this particular corner case 
had a solution that everyone should benefit from, and announced that the number 
should be 100 for *all* customers.  I tested this back in 7.6.04 against a RH 
server, with settings at 1, 10, 100, and 1000, and found that performance was 
actually NEGATIVELY affected the higher the number was set.  It wasn't a huge 
difference (10%~), but it was a clear, repeatable one for which BMC's engineer 
had no explanation.  It is why I have always advocated that unless a customer 
has the specific set of circumstances that caused the feature to be beneficial, 
there is no real benefit to setting the number larger than 1.  And there are 
minor drawbacks to doing so, the current subject being one of them.

Every time I ask someone from BMC to justify a larger number to the average 
customer, they repeat the party line, unaware of the history behind the 
feature.  I will continue to tilt at this windmill until someone at BMC shows 
me some performance testing numbers that justify this setting for the entire 
customer base.
Rick

On Oct 12, 2017 13:30, "Thomas Miskiewicz" 
> wrote:
**
i.e. there is no hack to find out the nextID before it actually gets submitted?

Apart from that, I really don’t understand why BMC makes such a fuss around the 
nextID. Why can’t they just provide a special command GET-NEXTID?


Thomas


On Oct 12, 2017, at 10:26 PM, LJ LongWing 
> wrote:

**
There are no interfaces that I'm aware of to ask a specific server what the 
next id it will hand out for a specific form is

On Thu, Oct 12, 2017 at 2:14 PM, Thomas Miskiewicz 
> wrote:
Hello List,

with NextID Block size being set to 100 —>  is it possible the find out using 
the API which will be the next Request-ID that the server will assign to a 
request? Or what other options do I have to find out?


--Thomas

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

Re: How to set / change the server language in Remedy 9.1.03?

[Grooms, Frederick W]

We also still run Non-Unicode so our environment variables of LANG and LC_ALL 
did not change for 9.x
If you want to run Unicode then you have to change your database to a Unicode 
character set first


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Thomas Miskiewicz
Sent: Wednesday, October 11, 2017 9:58 AM
To: arslist@ARSLIST.ORG
Subject: How to set / change the server language in Remedy 9.1.03?

**
Hello List,

according to Server Information

in ARS 7.6.4 we had the setting: de_DE@euro;WESTERN

in 9.1.03 swe have: de;UTF-8

According to these articles:

https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=kA21400dAcECAU

https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=kA21400dCHzCAM

we should be able to change this setting. So we added to arserverd.conf:

jvm.option.17 = -Duser.country=Germany
jvm.option.18 = -Duser.timezone=Europe/Berlin
jvm.option.19 = -Duser.language=GER

Unfortunately the display on Server Information did no change.

[cid:image002.jpg@01D34278.4D606CB0]

What else can we do?


Thomas



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

Re: Second try --> Upgrade 8.1.00 to 9.1.03 Failed

[Grooms, Frederick W]

Is there anything in the arDebug.log or arError.log?   


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Thomas Miskiewicz
Sent: Friday, October 06, 2017 11:24 AM
To: arslist@ARSLIST.ORG
Subject: Second try --> Upgrade 8.1.00 to 9.1.03 Failed

Hello Listers,

at the moment I do ARS upgrades from 7.6.4, 8.1.00 and higher to 9.1.03 for 
various customers. OS: Linux and Solaris.

Not a single system that just worked! I'm really not sure how to move to 
production under this circumstances...

What's even worse: the BMC support in India has zero clue and just keeping us 
busy with their ideas and requests. In all the month not a single hint with 
substance! BTW, talked to some partners and customers which I do not work for - 
same issues! But BMC support always pretends they never heard of any issues.

The logs of my recent 
installation:https://s3.eu-central-1.amazonaws.com/miskiewicz/arslist/INC112333.tar.gz
 Maybe one of you has an idea what is going on.

Basically the job went like this:

1. Clean and working 8.1.00 installation.
2. Installer 9.1.03 runs.
3. Installer 9.1.03 cannot start the server it installed and gives up.
4. Result: A messed up ARS 9.1.03 installation that doesn't start, but is 
trying to do a gazzilion of inserts into various tables and is violating the 
unique index at the same time.

I restored and started from scratch. Same result. Not sure what to do. The only 
comfort is BMC doesn't know either. I feel less stupid.


Thomas

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

Re: Menu on same field

[Grooms, Frederick W]

Personally I would use an SQL type menu
Select DISTINCT ...

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark
Sent: Wednesday, October 04, 2017 4:39 PM
To: arslist@ARSLIST.ORG
Subject: Menu on same field

**
Hi All

This is one of those case where I did something years ago and can't remember 
how I did it. Hoping someone can assist.

Have 10 records and the First Name field contains Joe, Joe, Bob, Joe, Mike, 
Joe, Bob, Mike, Joe and Bill.

On the same field I want have a menu that searches on the First Name field and 
displays Bill, Bob, Joe, Mike.

If I create a new record I could use the existing names or type in a new one. 
If the new record was for Mary, after submit, the menu would contain Bill, Bob, 
Joe, Mary, Mike

I just know this is simple enough to do, but it was about 10 years last time I 
did it. Any suggestions would be greatly appreciated.

ARS 9.1

Thanks
Mark

Mark Brittain  | Senior Systems Engineer | 315.634.9337
125 Elwood Davis Road | Syracuse NY 13212
[new_spectrum]

_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"

Re: arinside download link

[Grooms, Frederick W]

Just change out the domain for the IP (same way you reached the main page)
   http://173.249.157.224/downloads/46


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Maheshwari Lakshmanan
Sent: Wednesday, September 20, 2017 2:04 AM
To: arslist@ARSLIST.ORG
Subject: arinside download link

**
Hi listers,

arinside.org appears to be not reachable so I used the 
link in the communities and reached http://173.249.157.224/.
However, the download link is not working - http://arinside.org/downloads/46
Does anyone know of an alternative? My desktop OS got restaged so I have to set 
this up soon(hate it when devstudio hangs loading rships!!!).

Regards,
Maheshwari L



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

Re: Can we call shell script on remote server via AL run process command?

[Grooms, Frederick W]

What happens if you run the plink command in a CMD window on the server?

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Abhishek Anand
Sent: Wednesday, September 13, 2017 3:03 AM
To: arslist@ARSLIST.ORG
Subject: Can we call shell script on remote server via AL run process command?

Hi Experts,

Please could you assist in below scenario:-


Requirement is  stated as below:-
 
1. On the change in Status of a field to CLOSE in one of the form , it should 
trigger a script residing in a remote unix box.


I am using below logic:-
 
Created an AL with Run process Command Line as shown below:-
@@: c:/test.bat _"$Request ID$"
 
Also test.bat consist of the below lines:-
 
D:\putty\plink.exe  /usr/opt/xxx/Runtime/test.sh CLOSE 
"%1"
 
Remote server script path - /usr/opt/xxx/Runtime/test.sh
 
The unix box as well as script is accessible via putty on the windows box where 
remedy is installed.
 
But its not working.

 
Early response will be highly appreciated.
 
Regards,
AA

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

Re: Upgrade Remedy from 8.1 to 9.1.3

[Grooms, Frederick W]

It is in the Centralized Configuration not CMDB.  For some reason not 
everything is removed from the ar.conf (ar.cfg in Windows)
Open the AR System Administration Console  -> System -> General -> Centralized 
Configuration  and you should see the values.

Yes the upgrade should migrate the values

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Walters, Mark
Sent: Tuesday, July 18, 2017 9:40 AM
To: arslist@ARSLIST.ORG
Subject: Re: Upgrade Remedy from 8.1 to 9.1.3

**
There has been a change in where the LDAP component settings are stored but 
it's the Centralized Configuration forms and not the CMDB.  See 
https://docs.bmc.com/docs/display/public/ars91/Centralized+configuration

The upgrade should have migrated the settings from the ar.cfg to the new 
location so I'm not sure why this didn't happen but it's not related to the 
CMDB in any way.

Mark


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd
Sent: 18 July 2017 15:24
To: arslist@ARSLIST.ORG
Subject: Upgrade Remedy from 8.1 to 9.1.3

**
I have a question on the way version 9.1.3 stores the AREA LDAP, ARDBC config 
files.  In version 8.1 they are part of the ar.cfg file.  Am I correct that in 
9.1.3 they are stored in the CMDB?  Can someone confirm this for me. If that is 
correct, then I assume the CMDB needs to be set up and functional in order to 
access the info.  The reason I am asking is that we currently do not use the 
CMDB.  We have it installed but it is not configured correctly to work.  When I 
did the upgrade from 8.1 to 9.1.3 we lost all the settings for the AREA LDAP 
and ARDBC.  I am assuming this is because the CMDB is not functional.  Any 
input is appreciated.

Thanks,
Todd Arner

The information contained in this communication may be confidential, is 
intended only for the use of the recipient(s) named above, and may be protected 
under state or federal law. If the reader of this message is not the intended 
recipient, you are hereby notified that any dissemination, distribution, or 
copying of this communication, or any of its contents, is strictly prohibited. 
If you have received this communication in error, please forward the 
communication to no...@glhec.org immediately and 
destroy or delete the original message and any copy of it from your computer 
system. If you have any questions concerning this message, please contact the 
sender.



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

Re: How to send the Incident Work log, Status ...etc updates to third part via web service?

[Grooms, Frederick W]

It really depends on how the 3rd party requires the data.
I.e.  Does it want the updates in 1 large field or each update as a separate 
entry?

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Abhishek Anand
Sent: Monday, July 17, 2017 7:52 AM
To: arslist@ARSLIST.ORG
Subject: How to send the Incident Work log, Status ...etc updates to third part 
via web service?

Hi Experts,
 
Please could you assist in designing the flow for below scenario in Remedy 
8.1.02:-
 
How to send the Incident Work log, Status ...etc updates to third part via web 
service?
 
Early response will be highly appreciated.
 
Cheers,
AA.

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

Re: How to transfer an attachment via SFTP in remedy?

[Grooms, Frederick W]

As long as you have rights it should be   
   xcopy "C:\Users\630386\Desktop\test\*txt" "\\10.215.133.50\opt\workorder\" 
/d   

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Abhishek Anand
Sent: Tuesday, June 20, 2017 7:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: How to transfer an attachment via SFTP in remedy?

I got the command to transfer the file from one location to another in a local 
system.
But unable to perform it for remote system.

For local system - 

xcopy "C:\Users\630386\Desktop\test\*txt" "10.215.133.50/opt/workorder/" /d

Please could you suggest for the file transfer on to the remote system.

Also please suggest for the steps to create the RUN PROCESS& its execution.

Regards,
AA

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

Re: Error 106 - No entry for statistical operation

[Grooms, Frederick W]

What does the Filter and API logs show?   
Even though your Active Link is only pushing an integer, there could be Filters 
firing (on the form you are pushing to) that are causing the error.

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kaur
Sent: Friday, June 16, 2017 3:46 PM
To: arslist@ARSLIST.ORG
Subject: Error 106 - No entry for statistical operation

Hello All,

We're getting ARERR 106 - No entry is specified for this statistical operation.
It started few days ago and nothing has changed on server/remedy side in last 
few weeks.
Flushing mid -tier cache didn't solve the problem.
Active link logs shows an error in Push Fields where it tries to set an integer 
value to a field (Mostly 0).

Have anyone experienced this problem before?

Thanks!
Kaur
 

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

Re: v.9.1.3 upgrade fails

[Grooms, Frederick W]

2 things I can think of to try

1   Always use an account with a local password in the User form (during the 
upgrade the LDAP integration may not be available)
2   Always re-type all the passwords in the install GUI (I have encountered 
where the install GUI shows the password dots, but the data in there is bad)

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joel D Sender
Sent: Wednesday, June 14, 2017 10:58 AM
To: arslist@ARSLIST.ORG
Subject: v.9.1.3 upgrade fails

**
I’ve got a ticket at BMC for this, but I thought the ARSlist might have some 
insight:

I am attempting to upgrade ARS 8.1 to 9.1.3 (or 9.1.2 – same problem).
Both versions complain that the ‘AR System Server Admin’ user fails 
authentication.
I’ve verified that ‘Demo’ and my ID can login to the server with the same 
passwords entered into the upgrade dialog.

BMC support has requested LOG files from the install, but after extensively 
searching the disk, no log files are found.

Anyone bump into this before?
Thanks,
Joel
Joel Sender  *   jdsen...@earthlink.net



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

Re: EXTERNAL: Re: Expanding Menus on open in Mid Tier

[Grooms, Frederick W]

Believe me John, we all have seen these type of groups.  Another way we have 
had success in moving a stubborn group over to the web was to show that the 
Mid-Tier was actually faster than the User tool.  (We are running ARS 8.01.02 
and MidTier 9.01.02.002 all on Linux)

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Thursday, June 08, 2017 8:42 AM
To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Re: Expanding Menus on open in Mid Tier

**
John,
In this case I would impose the 'management' rule.  Does the company want to 
stay on a supported platform, on a supported version of that platform?...if so, 
they need to move on from the long ago unsupported tool and move forward into 
the futurehorses were great at the time, but we moved on as a world...yes, 
some people still use horses for transportation, but most of the modernized 
world has moved onto something else.  The current and supported client for 
Remedy is Mid-Tier, and that's the client they need to use if your company 
wants to be on a supported platform.if on the other hands, like many, your 
company doesn't care about that, then they can stay on the client until the OS 
they run doesn't work with it and they can't install it


-Original Message-
On Thu, Jun 8, 2017 at 7:34 AM, Reiser, John J  wrote:
**

Fred, Joe & Misi,

I have used type-ahead and a dialog form pop-up for other portions of this form.

The main issue is that the Tier 0 team are, shall we say, a little demanding 
and they want to do anything to stay on the WUT.

And they don’t rely on type-ahead because they are on the WUT. When they test 
the browser client they cite “muscle-memory” as the reason for having 
difficulty adapting to a web based system.

I may hide the menu icon on type-ahead fields to act as a reminder.



Oh and I tried the SET fields action with Display a List option but you have to 
set the Results list for the form where the menu data are “just right” to get 
any kind of keyboard response. (Some of our menus are large, hence the multiple 
levels.)



I was thinking of using a modal or dialog panel and a tree table field to 
display the results and then just SET the value selected into the main form 
field.



Thank you,
---
John J. Reiser
Building 760-J202
Remedy AR System Developer
Senior Software Development Analyst
Lockheed Martin - RMS Moorestown Region
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Misi 
Mladoniczky
Sent: Thursday, June 08, 2017 5:53 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: EXTERNAL: Re: Expanding Menus on open in Mid Tier

**
Joe, type ahead might be a good thing, as it is usually faster than navigating 
a big char menu (expanded or not).

You might also be able to create a solution with a table field or maybe an 
navigation field. Using a display only form dialog could also help.

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


-Original Message-
June 7, 2017 6:12 PM, "Joe D'Souza"  wrote:

The “Type Ahead” feature may also be a workaround for certain situations where 
the user requires to type a part of the value which will pop a list of similar 
values.. For most use cases this works as the user knows more or less what the 
value is supposed to look like..

Joe



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG<mailto:mailto:arslist@ARSLIST.ORG>] On Behalf Of 
Grooms, Frederick W
Sent: Wednesday, June 07, 2017 9:30 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Expanding Menus on open in Mid Tier

I don’t think the menu can do that on MidTier. What I have done before is to 
use my own button to do a search (when the menu data is in a form). Each level 
of the menu becomes a column and they just select the row

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG<mailto:mailto:arslist@ARSLIST.ORG>] On Behalf Of 
Reiser, John J
Sent: Wednesday, June 07, 2017 7:19 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Expanding Menus on open in Mid Tier

**

Hello Listers,

Remedy ARSystem 8.1.SP02

Mid Tier 8.1.2

We are still working on getting ALL clients out of the WUT and into Mid Tier.

Our Tier 0 folks don’t want to switch and have listed the inability of 
multi-level menus to expand when opened.

In the docs this is no

Re: Expanding Menus on open in Mid Tier

[Grooms, Frederick W]

I don't think the menu can do that on MidTier.  What I have done before is to 
use my own button to do a search (when the menu data is in a form).  Each level 
of the menu becomes a column and they just select the row

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J
Sent: Wednesday, June 07, 2017 7:19 AM
To: arslist@ARSLIST.ORG
Subject: Expanding Menus on open in Mid Tier

**
Hello Listers,
Remedy ARSystem 8.1.SP02
Mid Tier 8.1.2
We are still working on getting ALL clients out of the WUT and into Mid Tier.
Our Tier 0 folks don't want to switch and have listed the inability of 
multi-level menus to expand when opened.
In the docs this is not a feature that works in the browser.
Has anyone come up with a solution ( javascript? ) to make all menu levels open 
when you click the widget on a menu enabled character field?

Thanks in advance,
---
John J. Reiser
Building 760-J202
Remedy AR System Developer
Senior Software Development Analyst
Lockheed Martin - RMS Moorestown Region
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me






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

Re: ARERR 91 RPC: Can't decode result - on 9.1.00; Anyone NOT using UTF-8 on their DB on anything > 7.6.04?

[Grooms, Frederick W]

>From the bin directory, what do you get if you run
> ./arsystem env | sort

Look at the values of
   CLIENT_LOCALE en_us.8859-1
   LANG C
   LC_ALL   C

What is the database character set you see when you run the following
SELECT * FROM NLS_DATABASE_PARAMETERS ;

We currently have a 9.1.02.003 system Red Hat Enterprise Linux Server release 
7.2 (Maipo) (Linux 3.10.0-327.36.1.el7.x86_64)
Using   NLS_CHARACTERSET   US7ASCII

I have not seen your error
Fred


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ben Chernys
Sent: Wednesday, May 24, 2017 7:05 PM
To: arslist@ARSLIST.ORG
Subject: ARERR 91 RPC: Can't decode result - on 9.1.00; Anyone NOT using UTF-8 
on their DB on anything > 7.6.04?

**
Hi Folks,

I have a customer using what I think of as a first.  An Oracle DB with charset
DB_CHAR_SET := (11) iso-8859-15

This is against ARS 9.1.00 201610281101 running on Linux 
2.6.32-573.3.1.el6.x86_64 against Oracle 12.1.0.2.0 - 64bit Production.

I issue a Query and the response includes the default Form based list of query 
fields.  There apparently is no way to request none.  You can override the 
default which is the obvious work-around and will be tested shortly.  
Presumably, you may say the client is using the same character set and get 
around the issue being thrown by the translation dlls.

In this case the form's query fields includes those with umlauts.  When such a 
record (containing an umlaut in a form specified query field) is queried, the 
ARERR 91 occurs.  When said query returns records with no umlauts in the 
generated "short description", there is no error.

The client (Meta-Update) is running under Windows and is compiled with 9.1 
libraries.  An 8.1 library version also suffered the same problem.  The Linux 
version has not yet been tested.

I would tend to think it is a client api responsibility - given the plethora of 
modified character translate open source dlls - but the fact that both the 
8.1.2 and 9.1 compiles behave the same way (with changes in these supplied 
dlls) - makes me want to think of the server.

I guess after spending some hours, I am quite curious.  I believe I have an 
enhancement that may work (to define the character set as above in the 
ARControl block) and one that most likely will work (to request an override to 
the form's configured fields).

So,
1)  Anyone ever experienced this?  We have not tried the Windows driver at 
this point.
2)  Does anyone NOT use UTF-8 on their DB with anything above 7.6.04?
3)  Any comments?

Thanks a bunch in advance for your efforts!

Cheers,
Ben Chernys
Senior Software Architect
[logoSthInc-sm]

Canada / Deutschland
Mobile:+49 171 380 2329   GMT - 7 + [ DST ]
Mobile +1 403  554 0887
Email:   
Ben.Chernys_AT_softwaretoolhouse.com
Web: www.softwaretoolhouse.com

We are a BMC Technology Alliance Partner



Check out Software Tool House's free Diary Editor and our  Freebies Section for 
ITSM Forms and Fields spreadsheet.

Meta-Update, our premium ARS Data tool, lets you automate your imports, 
migrations, in no time at all, without programming, without staging forms, 
without merge workflow.

Meta-Archive does ITSM Archiving your way: with your forms and your 
multi-tenant rules, treating each root request as a complete tree and checking 
associatuions.  Archive output to different servers, HTML pages with links to 
attachments or archive forms.

Pre ITSM 9.1.02?  Clarify?  Roll your own?  No problem!
You can keep your valuable data!

http://www.softwaretoolhouse.com/





_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"

Re: Server Alias Production and COOP

[Grooms, Frederick W]

The way we handle it here is to never use the real server names, always use an 
alias for both the web server and the AR Server.

In the AR System you can add the IP-Name entries to the ar.conf (ar.cfg for 
Windows) so the AR System will recognize both names as the same server
i.e.
Server-Name: name1
IP-Name: name1.fqdn.com
IP-Name: alias1
IP-Name: alias1.fqdn.com

We typically also add the alias to the hosts file so from inside the server it 
will resolve the alias to itself always


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Pancia
Sent: Wednesday, May 17, 2017 9:19 AM
To: arslist@ARSLIST.ORG
Subject: Server Alias Production and COOP

**

We have a number of integrations with our remedy environment using web 
services.  We want to seamlessly switch between Production and COOP without 
impacting the integrations, since the remedy application server name is in the 
mid-tier url.  I'm assuming we can setup a DNS server alias and then just mess 
with DNS when switching between environments.  How have other people managed 
this and are there any things to lookout for?  Ideally I would like to be able 
to swap in and out of environments without the integrations or end users 
realizing we are switching.



Current sample settings, names changed to protect the innocent:



https://productionmidtierserver/arsys/forms/productionappserver/...



https://coopmidtierserver/arsys/forms/coopappserver/...



Would like both to use:



https://remedy.com/arsys/forms/remedyappserver/...





Thanks,



Brian


DISCLAIMER: The information contained in this e-mail and its attachments 
contain confidential information belonging to the sender, which is legally 
privileged. The information is intended only for the use of the recipient(s) 
named above. If you are not the intended recipient, you are notified that any 
disclosure, copying, distribution or action in reliance upon the contents of 
the information transmitted is strictly prohibited. If you have received this 
information in error, please delete it immediately.
_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"

Re: Put another way

[Grooms, Frederick W]

Wow … Something SOAP can do that REST can’t
(Sorry just had to say it)


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Thursday, May 11, 2017 11:58 AM
To: arslist@ARSLIST.ORG
Subject: Re: Put another way

**
Mark,
I don't believe so, the reason being is that even back in the old days of 
'modify all' in the user tool, you selected the records you wanted to modify, 
then the user tool did a loop through a list of request id's and did the same 
update to all of themfrom an api perspective, when doing a set entry, 
'which request are you updating, on which form' is the primary information, of 
course it also needs to know what you are changing...but you need to know 
exactly which records

So, if you are trying to do it via 'query', you'll need to write a query 
routine to get the request id's in question, then push an update to each one 
respectively

Alternativelyyou could push a query to an 'interface' form with the query 
as one of the inputs, then have a filter to the execution of the query and 
update for you :)

On Thu, May 11, 2017 at 10:29 AM, Brittain, Mark  wrote:
**
Hi All
 Is there a way to do a put using a field other that the request id (1)?

curl -X PUT "http://192.168.1.131:8008/api/arsys/v1/entry//"
 -H  "accept: application/json" -H  "Authorization: AR-JWT " -H  
"content-type: application/json" -d "{  \"values\": {\"Escalation\": \"0\"  
}}"


ARS9
ITSM 9

Thanks
Mark

Mark Brittain  | Senior Systems Engineer | 315.634.9337
125 Elwood Davis Road | Syracuse NY 13212
[new_spectrum]



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

Re: External Email Restriction and Validation check

[Grooms, Frederick W]

The easiest way I can think of is to do the following

Filter 1
  Action 1:  Set a Display Only character field (for this example I am calling 
it zTemp1)  to UPPER the TO email address field.
  Action 2:  Set zTemp1 = REPLACE($zTemp1$, “@TEST.COM”, “”)

Filter 2:  If zTemp1 like “%@%” show error

Basically after removing all occurrences of @test.com in the string if you have 
any @ left then there is at least 1 address that does not meet your criteria.

Fred


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of syed Ziyan
Sent: Monday, May 08, 2017 1:17 AM
To: arslist@ARSLIST.ORG
Subject: External Email Restriction and Validation check

**
Hi Team,

We would like to implement one validation check while sending email to External 
email address via CTM:Email System form (Email System Link in Incident Form > 
Opens this form)

Requirement is to validate external email from list of emails

a...@test.com; b...@test.com; 
c...@notest.com; d...@test.com..> 
to restrict email sending if we have any email address that is NOT 
"test.com"..

We can have a AL on button "Send Email Now" on this form (CTM:Email System) .. 
but cant prepare the substring logic of verifying the wrong/external email 
address out of list of email addresses.

Looking forward your help..

Thanks
Ziyan



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

Re: Remedy Run Process Issue

[Grooms, Frederick W]

Success means it was able to call the Java executable.  My guess is Java is not 
able to find the  SampleClientPost1  file.
When you run it from the command line, where are you running it from?

As for debugging That would be whatever you have put into your  
SampleClientPost1  program.
Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of sriram pm
Sent: Tuesday, April 18, 2017 9:57 AM
To: arslist@ARSLIST.ORG
Subject: Remedy Run Process Issue

**
Hi Experts,

I need your help.

I am executing an Run Process in an active link as shown below.

@@: C:\Program Files\Java\jdk1.8.0_121\jre\bin\java  SampleClientPost1  
"{\"short_description\":\"This is a test 
ticket\",\"assignment_group\":\"ENVIRONMENTS\",\"category\":\"Software\"}"

The Logs says it is Successful as shown below:

 Run Process on server
   Server: 
ars-dev.tycoelectronics.com
   Process: C:\Program Files\Java\jdk1.8.0_121\jre\bin\java  
SampleClientPost1  "{\"short_description\":\"This is a test 
ticket\",\"assignment_group\":\"ENVIRONMENTS\",\"category\":\"Software\"}"
  Success

The above program is supposed to create a ticket in another cloud based 
ticketing tool. But even though it says successful the ticket is not getting 
created.

How to debug whether the program got executed or not?

When I run using Command Line it works fine.

Kindly check and advice.

Thank you,
Sriram.





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

Re: Set Date Format for Server

[Grooms, Frederick W]

Dates in web services must conform to the XML DateTime standards
   https://www.w3schools.com/xml/schema_dtypes_date.asp

A date only is specified in the following form "-MM-DD"
A time only is specified in the following form "hh:mm:ss"
A dateTime is specified in the following form "-MM-DDThh:mm:ss"
where:

  *    indicates the year
  *   MM indicates the month
  *   DD indicates the day
  *   T indicates the start of the required time section
  *   hh indicates the hour
  *   mm indicates the minute
  *   ss indicates the second

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Bächler Samuel (ewz)
Sent: Friday, March 31, 2017 9:52 AM
To: arslist@ARSLIST.ORG
Subject: Set Date Format for Server

**
Dear All

We upgraded to BMC Remedy 9.1. When consuming a webservice we get the error 
'ERROR (8957): The date format is invalid.' We changed the locales of the 
corresponding webservice user and we changed the date format of the host 
(German (Switzerland) on Windows Server 2008 R2) with no luck. Any ideas what 
we could try next?

Regards,
Sam



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

Re: Need help with .NET API

[Grooms, Frederick W]

I would say Plugin and User logs
Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook
Sent: Monday, March 20, 2017 9:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Need help with .NET API

** 
Plug-in logs? 
Rick


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kaur
Sent: Monday, March 20, 2017 9:22 AM
To: arslist@ARSLIST.ORG
Subject: Re: Need help with .NET API

Client have been using it for years and we have no idea what credentials are 
being used.
Of course, we can't ask that from client and we don't have at documentation.

Any way we can identify/find the user id?

Thanks!
Kaur

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

Re: Is it a good idea to eliminate the use of Diary Fields?

[Grooms, Frederick W]

And the unlimited Display Only field method will not work as it will be subject 
to the same cell character limit as a Diary field.

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Wednesday, March 15, 2017 3:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: Is it a good idea to eliminate the use of Diary Fields?

**
John,
BMC themselves went away from Diary fields for the most part (certainly in the 
work log process) many years agothe down side, as you pointed out is 
storing the diary in individual records causes issues with reportingthis is 
easily worked around in a sufficiently advanced reporting tool allowing you to 
create sub-reports reporting all of the diary entries from a second 
tablethe fact that they can't be pulled in the same entry is the only down 
side that I know of...with plenty of up sides.

On Wed, Mar 15, 2017 at 3:06 PM, Reiser, John J  wrote:
**
Hello Listers,

Is there a downside to replacing diary fields with a different method of 
capturing work activity?
Since diary fields don’t show up in Mid Tier Web reporting I was looking into a 
way to replace the diary field for reporting.

We actually have reports that get created in csv format for Excel that use the 
Diary.
Occasionally we have a diary so large it breaks the cell character limit in 
Excel.

I was contemplating using a table field to display records from a work activity 
form and then using either a join or some other temporary means to gather the 
activity into a report.

Can I use an unlimited Display Only field to dump the diary during the report 
process?
Is there a better mouse trap for collecting large amounts of data and reporting 
it?

As always, thanks in advance.

Thank you,
---
John J. Reiser
Building 760-J202
Remedy AR System Developer
Senior Software Development Analyst
Lockheed Martin - RMS Moorestown Region
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me




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

Re: Problem with creating/modifying form indexes

[Grooms, Frederick W]

You must create indexes thru Dev Studio so ARS will know about them.  

The only thing I can think of why your developer studio stopped responding was 
that the db had not completed building the index

Fred


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kaur
Sent: Friday, March 10, 2017 12:29 PM
To: arslist@ARSLIST.ORG
Subject: Problem with creating/modifying form indexes

Hello All,

I created an index on customized form from developer studio. Form stopped 
responding when I saved it.
I had to force close dev studio and restart ARS service.
Once the service was back up, I opened the form again from developer studio and 
my changes were in place but the db went out of sync.
New index was not in database.
I then deleted the index from dev studio and saved the form.
Changes were saved pretty fast.
I manually created index from db query. Query was successful and I was able to 
see the new table index from db but now dev studio isnt showing that index on 
the form.
I reopened it several times. Even restarted ARS service.

What could have went wrong?
Please suggest.

Thanks!
Kaur

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

Re: Official announcement of BMC Exchanges replacement for BMC Engage

[Grooms, Frederick W]

BMC Also seems to be having some other events  BMC Day 2017 in Chicago

http://bmcdays.bmc.com/chicago/agenda?elqTrackId=3198073cda8d4ffd998ad40b2d3fca87=ee18ae36df4c490b9025d238b51748f2=2388=1=1651



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook
Sent: Wednesday, February 22, 2017 2:51 PM
To: arslist@ARSLIST.ORG
Subject: Re: Official announcement of BMC Exchanges replacement for BMC Engage

**
Well, I suppose if one lives in one of those cities, there would be no cost. 
For many of the rest of us, traveling for just one day isn't even worth 
requesting.
Rick

On Feb 22, 2017 12:47, "Jason Miller" 
> wrote:
**
https://communities.bmc.com/groups/bmc-global-services/blog/2017/02/22/bmc-exchange-coming-to-a-city-near-you

BMC Exchanges are one-day, no cost events where you will gain new insights 
about digital business, get up-to-date information about the latest BMC 
products and services, and network with your peers, BMC partners, and BMC 
experts.

Hosted in nine cities across four continents, we’ve made it easier than ever to 
attend a BMC Exchange event near you:
Washington, DC – June 7th
New York City – October 12th
San Francisco – October 25th
Singapore – October 31st
Beijing – November 2nd
Essen (Germany) – November 14th
London – November 16th
Sao Paulo – November 30th
Paris – January 25th (2018)



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

Re: Custom Java AREA plugin

[Grooms, Frederick W]

Update:   I made my own java AREA plugin (based on the sample) and I can see it 
being called.  Now I am getting an error when it chains to the BMC java AREA 
plugin   

  /* Thu Feb 16 
2017 02:54:32.076 */  Calling AREAVerifyLogin() through plugin: 
MY.AREA.AREAXOLDAP   
 <ARPluginContext.java:173> /* Thu Feb 16 
2017 02:54:32.076 */  areaVerifyLogin()   
  /* Thu Feb 16 
2017 02:54:32.077 */  Calling AREAVerifyLogin() through plugin: 
ARSYS.AREA.AREALDAP   
 <ARPluginContext.java:173> /* Thu Feb 16 
2017 02:54:32.077 */  areaVerifyLogin()   
  /* Thu Feb 16 
2017 02:54:32.094 */  AREAVerifyLogin() FAIL for plugin ARSYS.AREA.AREALDAP   
   ERROR (9004): Error during symmetric key data decryption; 
com.bmc.arsys.arencrypt.AREncryptionException: 
java.security.InvalidParameterException: Wrong encrypted data bytes to decrypt. 
  

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, February 15, 2017 3:04 PM
To: arslist@ARSLIST.ORG
Subject: Custom Java AREA plugin

Does anyone have an example of using a custom Java AREA plugin in the 
pluginsvr_config.xml for ARS 9.1 (and having the system chain thru the plugins 
correctly)?   

I tried doing what we had to do on 8.1 (reverting to the C plugin hub) but 
because of the central config (which deletes line out of the ar.conf) the C 
AREA LDAP plugin does not know what LDAP server to go to (it defaults to the 
server that Remedy is running on instead of what is in the central config)   
 
Fred

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

Custom Java AREA plugin

[Grooms, Frederick W]

Does anyone have an example of using a custom Java AREA plugin in the 
pluginsvr_config.xml for ARS 9.1 (and having the system chain thru the plugins 
correctly)?   

I tried doing what we had to do on 8.1 (reverting to the C plugin hub) but 
because of the central config (which deletes line out of the ar.conf) the C 
AREA LDAP plugin does not know what LDAP server to go to (it defaults to the 
server that Remedy is running on instead of what is in the central config)   
 
Fred

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

Re: Need help with force logout on mid tier

[Grooms, Frederick W]

Use the run process action
PERFORM-ACTION-EXIT-APP

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kaur
Sent: Friday, February 10, 2017 2:41 PM
To: arslist@ARSLIST.ORG
Subject: Need help with force logout on mid tier

Hi All,

I'm trying to create following design but having problem forcing user log out -

1. User hits 'change password' button on home page.
2. Pop up window appears where user can set new password.
3. On pop-up window, when user saves the changes, message appears 'Pwd 
successfully changed'
4. When 'Ok' is clicked on message/note, all windows - pop up and home page 
should be closed and logs out user from mid tier.  

How can I implement step 4?

Tried 'close All' action and then run-process-open-url  https://midtier/logout
but nothing worked.
Please help!

Thanks!
Kaur

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

Re: BMC Engage

[Grooms, Frederick W]

Was that more of a Networking/Happy Hour type event?  They just had one of 
those here in Dallas (but it was more social from the Control-M people than 
anything)


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire
Sent: Wednesday, February 08, 2017 3:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMC Engage

**
The one they had in Houston was at Top Golf!  After work hours sort of.  I 
think it started at 2pm?  I didn’t go.



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mike Gould
Sent: Wednesday, February 08, 2017 10:22 AM
To: arslist@ARSLIST.ORG
Subject: [EXTERNAL] Re: BMC Engage

**
Here's the response I received from our Federal account rep:

"Engage was not cancelled but modified to align with five geographical metro 
areas for easier travel. Our event in DC will have a strong Federal focus. From 
that perspective, it works to our customers' benefit due to restrictions with 
travel and we can now offer Federal based sessions. Please let us know if you 
have any questions."

Gotta love the spin on how Engage was not "cancelled".  How on earth does BMC 
think a 1 day event is better.  How will I have time in one day to attend 
sessions on enhancements coming to the next version of ARS/ITSM? Or learn about 
other BMC products like Service Broker, Client Management or their various 
cloud offerings?  How will I fit in lab sessions to test drive Smart Reporting? 
 Or experience hands-on Innovation Studio?  etc.
Ridiculous...

On Wed, Feb 8, 2017 at 8:43 AM, Dave Barber 
> wrote:
**
Engage in London last year was quite enjoyable, but the focus did seem to be a 
little chaotic.  Rucksack was good.  Tee shirt was too small.  Pen still works. 
 Was good to catch up with some old colleagues too that I hadn't seen in a few 
years.
But there did seem to be a lack of real in depth sessions on the new 
technology, actually seeing the innovation studio was high on my wish list, and 
that was totally denied.
Hope we do have another here in london again, but won't hold my breath.

On 7 February 2017 at 19:53, Paul J. Zagarella 
> wrote:
**
I spoke to my sales rep and confirmed that the 2017 Engage in Vegas is 
cancelled. The comments that I heard about Engage 2016 were in line with what I 
noticed at the conference as well. The fact that they pushed Innovation Studio 
and did not have any sessions on it or any workshops was crazy. They were 
really pushing Blade Logic and Control M but did very little with ITSM. The 
funny thing is that all the ITSM sessions and workshops were booked and the 
Blade Logic and Control M sessions were empty or half empty. They really need 
to focus on tech for these instead of sales and more people would come and 
maybe even buy stuff! When you go to CES or even something like Blizzcon, you 
see product and get to try stuff out. They should have scheduled labs with 
HRCase, Innovation Studio, etc, going the whole entire time. In general, they 
should have planned way more labs/training sessions  and encouraged developers 
to bring their apps to showcase. Also, moving it from the second week of 
September would really help as most schools are too busy with the start of the 
school year. Well…. we will see what happens at the new format but basically it 
will probably end up being more sales. ☹

Paul

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook
Sent: Tuesday, February 7, 2017 2:34 PM

To: arslist@ARSLIST.ORG
Subject: Re: BMC Engage

**
Yeah, given how well the last one was attended, there has to be some other 
reason.  I'm guessing it has something to do with sales goals.
Rick

On Feb 7, 2017 11:31, "Saji Philip" 
> wrote:
** I hear they are trying to revive the WWRUG (the founders) in a different 
format, if BMC does announce no more Engages.  BMC really blew it with this 
one..

And everything they are saying is 'we conducted surveys and listened to the 
public and decided that multiple geo-centric events is betier than a 4 day 
global conference.'  Really? Who did they talk to?  I say the new CEO did not 
want to fork over a million to subsidize and organize these events.  Probably 
gave the pink slip to the BMC event dept.
On Tue, Feb 7, 2017, 6:27 AM Joe D'Souza 
> wrote:
**
I haven’t been to an ENGAGE yet so can’t comment on it but yes the WWWRUG were 
definitely worth it for a lot of reasons if you could afford the cost and 
expense associated to making to one..

So where would these “exchanges” be held at?

Joe


From: Action Request System discussion list(ARSList) 

ARS 9.1.02 Upgrade

[Grooms, Frederick W]

I am trying to upgrade an 8.1.02 ARS only (Single server, no CMDB no ITSM) to 
9.1 and when it tries to start I get the following 

INFO - Thu Feb 02 11:45:11.013 2017 Application context refresh failed 
(OsgiBundleXmlApplicationContext(bundle=com.bmc.arsys.server, 
config=spring-context/base_context.xml,spring-context/infrastructure_septran_context.xml,spring-context/profiles/aspectj_ctw/application_context.xml,spring-context/osgi.xml))
   
INFO - org.springframework.beans.factory.BeanCreationException: Error creating 
bean with name 'sqlHelper' defined in URL 
[bundleentry://162.fwk796684896/spring-context/application/sql_context.xml]: 
Cannot resolve reference to bean 'configurator' while setting bean property 
'configurator'; nested exception is 
org.springframework.beans.factory.BeanCreationException: Error creating bean 
with name 'arTransactionalManager' defined in URL 
[bundleentry://162.fwk796684896/spring-context/application/aspects_context.xml]:
 Cannot resolve reference to bean 'cacheManager' while setting bean property 
'cacheManager'; nested exception is 
org.springframework.beans.factory.BeanCreationException: Error creating bean 
with name 'cacheManager' defined in URL 
[bundleentry://162.fwk796684896/spring-context/application/cache_context.xml]: 
Cannot resolve reference to bean 'serverGroupBoardDAOManager' while setting 
constructor argument; nested exception is 
org.springframework.beans.factory.BeanCreationExceptio
 n: Error creating bean with name 'serverGroupBoardDAOManager' defined in URL 
[bundleentry://162.fwk796684896/spring-context/application/domain/servergroup_context.xml]:
 Invocation of init method failed; nested exception is ERROR (552): Message not 
in catalog; Message number = 552; Exception [EclipseLink-4002] (Eclipse 
Persistence Services - 2.4.2.v20130514-5956486): 
org.eclipse.persistence.exceptions.DatabaseException   
INFO - Internal Exception: org.apache.commons.dbcp.SQLNestedException: Cannot 
create PoolableConnectionFactory (ORA-01031: insufficient privileges   
INFO - )   
INFO - Error Code: 0; nested exception is 
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse 
Persistence Services - 2.4.2.v20130514-5956486): 
org.eclipse.persistence.exceptions.DatabaseException   
INFO - Internal Exception: org.apache.commons.dbcp.SQLNestedException: Cannot 
create PoolableConnectionFactory (ORA-01031: insufficient privileges   
INFO - )   

I have a ticket opened with BMC but they have not responded.   

According to the install docs (which I had to find under the ITSM install) the 
only rights needed for ARS are (which I have):   
grant alter session, create cluster, create database link, create sequence, 
create session, create synonym, create table, create view, create procedure, 
create trigger, query rewrite to ARole_arsys;   

Anybody know what other permissions I need to have granted for ARS 9.1 to run.  
 
I am on Red-Hat Linux 7 with Oracle 11g and the installer did not complain 
about any missing privileges.   

Fred

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

Re: Defined Searches

[Grooms, Frederick W]

User searches are stored in the AR System Search Preferences form.
You could do some process to clone the search record you create to additional 
users (i.e. Copy to New  on that form).

Another point about the Form defined searches is that you can only have 16 (I 
think that is the number) on the view of the form.

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Monday, January 30, 2017 4:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: Defined Searches

**
What about user defined "my searches"? They would presumably be stored in a 
form. I do not remember exactly how though...
Brian Pancia  skrev: (30 januari 2017 18:46:36 CET)
**

Well that's not good.  I have multiple companies using the system and was 
hoping to use a backend form to control the searches without doing a whole lot 
of customization.  I was hoping it pulled off the AR System Search Preferences. 
 They want to run a bunch of searches based on an start/end date.  I want to 
set this based on permissions.  They also want to be able to export this data 
as needed to a csv file.  Just doing reports won't work because they may only 
want to drill into the individual ticket data, in which they would only need 
the search and not need the report.  Back to the drawing board.



Brian.


From: Action Request System discussion list(ARSList) 
<arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>> on behalf of Grooms, 
Frederick W
Sent: Monday, January 30, 2017 11:21 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Defined Searches

**
Defined searches are created on the form itself.  In the properties of the view.

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Pancia
Sent: Monday, January 30, 2017 9:51 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Defined Searches

**

It has been awhile since I messed with this feature.  Trying to setup defined 
searches on HPD:Help Desk.  I setup a search and went into AR System Searches 
Preferences and set the search type to Admin-Defined.  The option to Run 
Defined searches is greyed out on HPD:Help Desk.  What am I missing?  Version 
9.1.



Brian



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

Re: Defined Searches

[Grooms, Frederick W]

Defined searches are created on the form itself.  In the properties of the view.

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Pancia
Sent: Monday, January 30, 2017 9:51 AM
To: arslist@ARSLIST.ORG
Subject: Defined Searches

**

It has been awhile since I messed with this feature.  Trying to setup defined 
searches on HPD:Help Desk.  I setup a search and went into AR System Searches 
Preferences and set the search type to Admin-Defined.  The option to Run 
Defined searches is greyed out on HPD:Help Desk.  What am I missing?  Version 
9.1.



Brian





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

Re: SERVER keyword in Filters

[Grooms, Frederick W]

Usually I am comparing to a field so I just did a Document to an .rtf file I 
opened in Word and searched for $SERVER$

Still a pain to deal with.

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, January 25, 2017 2:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: SERVER keyword in Filters

Hi,

If you export your filters to a def file, you can just search for the server 
name to find the locations. The server name is typically not used that much for 
other stuff.

You can even use RRR|DefSearch to get a list of matching objects:
https://rrr.se/cgi/tools/main?tool=rrrDefSearch

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

-Original Message-
January 23, 2017 2:03 PM, "Grooms, Frederick W"  wrote:
> That is exactly what I am having to do (It is just not fun trying to find and 
> change all the
> workflow that uses $SERVER$). 
> 
> Fred
> 
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi
> Mladoniczky
> Sent: Saturday, January 21, 2017 3:13 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: SERVER keyword in Filters
> 
> Hi,
> 
> Doing a LEFT requires filter actions. In this case it should work to use 
> something like this in the
> Run If of the filter:
> $SERVER$ LIKE "%devars01%"
> 
> 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
> 
> -Original Message-
> January 20, 2017 8:03 PM, "Murnane, Phil" wrote:
> 
>> Hi Fred,
>> 
>> We've run into this issue in the past, and always got around it by appending 
>> a period to $SERVER$
>> and then taking the LEFT() # of characters up to the first period. If you 
>> need the alias, just use
>> what's returned. If you need the FQDN, then append the domain to what's 
>> returned.
>> 
>> HTH
>> --Phil
>> 
>> -Original Message-
>> From: Action Request System discussion list(ARSList) 
>> [mailto:arslist@ARSLIST.ORG] On Behalf Of
>> Grooms, Frederick W
>> Sent: Friday, January 20, 2017 11:49 AM
>> To: arslist@ARSLIST.ORG
>> Subject: SERVER keyword in Filters
>> 
>> We are in the process of moving our servers to new hardware.
>> 
>> Old OS is Red Hat Enterprise Linux Server release 5.11 (Linux 
>> 2.6.18-400.1.1.el5)
>> New OS is Red Hat Enterprise Linux Server release 7.2 (Linux 
>> 3.10.0-327.36.1.el7.x86_64)
>> 
>> We have the same version of ARS (8.1.02 201408260235) on each server (Once 
>> we are on the new
>> hardware we can upgrade). Both servers are pointing to the same database.
>> 
>> On the old hardware the $SERVER$ keyword in filters is reporting the short 
>> name (i.e. devars01).
>> On the new hardware it is reporting the FQDN (i.e. devars01.myxyz.com).
>> 
>> The environment variables and ar.conf are all the same between the servers.
>> Does anyone know what setting I can change to make it report back with the 
>> short name?
>> 
>> Fred

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

Re: SERVER keyword in Filters

[Grooms, Frederick W]

Yes, Oracle

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Bächler Samuel (ewz)
Sent: Thursday, January 26, 2017 12:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: SERVER keyword in Filters

**
Hi Fred

Out of curiosity, is your whole ARSystem running on Red Hat? In particular, 
what database are you using (MS SQL, MySQL, Oracle, Postgres etc.)?

Regards,
Sam




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

Re: SERVER keyword in Filters

[Grooms, Frederick W]

That is exactly what I am having to do (It is just not fun trying to find and 
change all the workflow that uses $SERVER$).  

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Saturday, January 21, 2017 3:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: SERVER keyword in Filters

Hi,

Doing a LEFT requires filter actions. In this case it should work to use 
something like this in the Run If of the filter:
$SERVER$ LIKE "%devars01%"

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

January 20, 2017 8:03 PM, "Murnane, Phil"  wrote:
> Hi Fred,
> 
> We've run into this issue in the past, and always got around it by appending 
> a period to $SERVER$
> and then taking the LEFT() # of characters up to the first period. If you 
> need the alias, just use
> what's returned. If you need the FQDN, then append the domain to what's 
> returned.
> 
> HTH
> --Phil
> 
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arslist@ARSLIST.ORG] On Behalf Of
> Grooms, Frederick W
> Sent: Friday, January 20, 2017 11:49 AM
> To: arslist@ARSLIST.ORG
> Subject: SERVER keyword in Filters
> 
> We are in the process of moving our servers to new hardware. 
> 
> Old OS is Red Hat Enterprise Linux Server release 5.11 (Linux 
> 2.6.18-400.1.1.el5) 
> New OS is Red Hat Enterprise Linux Server release 7.2 (Linux 
> 3.10.0-327.36.1.el7.x86_64) 
> 
> We have the same version of ARS (8.1.02 201408260235) on each server (Once we 
> are on the new
> hardware we can upgrade). Both servers are pointing to the same database. 
> 
> On the old hardware the $SERVER$ keyword in filters is reporting the short 
> name (i.e. devars01). 
> On the new hardware it is reporting the FQDN (i.e. devars01.myxyz.com). 
> 
> The environment variables and ar.conf are all the same between the servers. 
> Does anyone know what setting I can change to make it report back with the 
> short name? 
> 
> Fred 
> 

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

SERVER keyword in Filters

[Grooms, Frederick W]

We are in the process of moving our servers to new hardware.   

Old OS is   Red Hat Enterprise Linux Server release 5.11(Linux 
2.6.18-400.1.1.el5)   
New OS is  Red Hat Enterprise Linux Server release 7.2  (Linux 
3.10.0-327.36.1.el7.x86_64)   

We have the same version of ARS (8.1.02 201408260235) on each server (Once we 
are on the new hardware we can upgrade).  Both servers are pointing to the same 
database.   

On the old hardware the $SERVER$ keyword in filters is reporting the short name 
(i.e. devars01).
On the new hardware it is reporting the FQDN (i.e. devars01.myxyz.com).   

The environment variables and ar.conf are all the same between the servers.   
Does anyone know what setting I can change to make it report back with the 
short name?   

Fred 

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

Re: Pat Zandi

[Grooms, Frederick W]

I’m sorry to hear that.
He will be missed

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Warren R. Baltimore II
Sent: Wednesday, January 11, 2017 1:31 PM
To: arslist@ARSLIST.ORG
Subject: Pat Zandi

**
Folks,
I wanted to take a few moments and let those of you who are following the list 
know that Pat Zandi passed away on Monday.
Pat had been battling cancer for the last year.  He came to work for Dev 
Technology about a year or so before I did after he retired from the Air Force. 
 He was a great team mate, and a good guy.  He will be missed.
His obituary can be found here:  
http://www.colonialfuneralhome.com/home/index.cfm/obituaries/view/fh_id/11079/id/4062535
Warren

--
Warren R. Baltimore II
Remedy Developer
410-533-5367



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

Re: Process not stopping - Linux

[Grooms, Frederick W]

Do you run Non-Root?  Since this is owned by root it can't be stopped by a 
non-root user.
I believe this is the service /application process dispatcher.

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark
Sent: Tuesday, January 10, 2017 3:24 PM
To: arslist@ARSLIST.ORG
Subject: Process not stopping - Linux

**
Hi All,

I have notice whenever I stop the AR Server (7.6.04) that the following process 
continues to run. Server is Linux Redhat 5.

root 19622 1  0 Nov16 ?00:00:14 ./arsvcdsp -s ars-as-s2 -d 
/opt/bmc/ARSystem

Can anyone tell me, what that process is and if I can kill it?

Thanks
Mark

Mark Brittain  | Systems Engineer | 315.634.9337
125 Elwood Davis Road | Syracuse NY 13212
[Navisite]




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

Re: echo

[Grooms, Frederick W]

Check your path to make sure it can find echo
Since you are on linux you can turn on the arfork log to see the command being 
executed and the actual results

You may have to use   /bin/echo   in place of just   echo
And if you have tabs, returns/new lines you may want to doecho -e   so the 
\n and \t are recognized

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark
Sent: Thursday, January 05, 2017 10:26 AM
To: arslist@ARSLIST.ORG
Subject: echo

**
Hi All

I am trying to do a filter run process echo "$Configuration Item List$" > 
/tmp/file.json

On the client filter log it appears to go fine but the file on the server is 
not updated. I suspect the issue is permissions. The AR server was not 
installed as root but if I understand echo correctly this is executed by root. 
Any suggestion on how to get around this?

ARS 9.1
Linux 6

Mark

Mark Brittain  | Systems Engineer | 315.634.9337
125 Elwood Davis Road | Syracuse NY 13212
[Navisite]




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

Re: Dialog panels and Notify action

[Grooms, Frederick W]

This is one reason I created the idea:
  Improve the method of overriding Filter Phases   
https://communities.bmc.com/ideas/3639

Since you are creating everything for the email yourself there is one other 
method you can use.  Do a push action to the AR System Email Messages form 
yourself

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug
Sent: Wednesday, January 04, 2017 2:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: Dialog panels and Notify action

**
Thomas,

THAT is the tradeoff.  You get the current values when you override phasing.   
You cannot say, phase for this attribute to get the final value but not for 
that attribute.   That is where you need to make the call about what your 
specific situation is and choose the right option.

If you are modifying, then the requestID is available.  If you are creating, 
then it is not until phase 3….

Doug

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Thomas Miskiewicz
Sent: Tuesday, January 03, 2017 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Re: Dialog panels and Notify action

**
Doug,

is overriding Filter phasing in connnection with notifications a good idea? I 
mean when we do that we won't be able to send out the Request-ID in the 
notification.


Thomas

On 3 Jan 2017, at 19:03, Mueller, Doug 
> wrote:
**
Dustin,

There are three options that I can think of for you to consider.


1)  Don’t NULL the value – the notification runs in phase 3 and will pick 
up the FINAL value of the field not an intermediate one.  This stores the value 
in the field.

2)  Put the value in a display only field (as suggested) – This stores 
nothing to the DB, but the value in the display only field is available 
throughout the phases of the operation.

3)  Override the filter phasing.  End the name of your filter (yes, this is 
a naming convention rather than a filter option, and there is lots of history 
for why this is this way, but it is….) with `!  (that is a BACKQUOTE followed 
by an exclamation point).  This will override the phasing of the filter for 
this filter and cause the notification to be executed NOW not in phase 3.  OK, 
honestly, it just takes a snapshot of all the values and saves then for the 
notification rather than actually sending the notification right now but the 
result is the same…This would use the CURRENT VALUE AT THAT TIME of the 
field not the value at the end of the transaction.  This should work for your 
situation (a quick test would confirm it).

For your situation, you may find that the third option is the simplest solution 
without needing extra work or handling.

Doug Mueller

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Fawver, Dustin
Sent: Tuesday, January 03, 2017 9:43 AM
To: arslist@ARSLIST.ORG
Subject: Re: Dialog panels and Notify action

**

Tim,



That is a most excellent idea!  I may have to change some things in that panel, 
depending on what management wants, so if that's the case I'll give that a try.



Thanks again!


--Dustin Fawver

HelpDesk Technician
East Tennessee State University
(423) 439-4648


From: Action Request System discussion list(ARSList) 
> on behalf of Timothy Powell 
>
Sent: Tuesday, January 3, 2017 7:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: Dialog panels and Notify action

**
Not knowing how the field value is getting set, I’m going to guess that it’s 
set/input by the tech at transaction time.
That said, If you only need the contents of this field for the 
transaction/message (and the value is actually stored elsewhere), maybe you can 
just use a Display Only field.
Tim

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Fawver, Dustin
Sent: Monday, January 02, 2017 7:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Dialog panels and Notify action

**

Greetings, once again!



I have figured this out, but I would still like some advice.  What was causing 
my issue is that I was setting the field in question to $NULL$ after the Notify 
action within the filter.  I even tried setting the field to $NULL$ in a 
different filter step with a later execution order.  I suppose this is due to 
filter phases.  (https://docs.bmc.com/docs/display/public/ars91/Filter+phases).



Aside from emailing the contents of this field, the contents are also copied to 
one of two other fields, depending on the tech's choice, that are also saved to 
the database.  Thus I don't need yet another copy of the field's contents.  For 
those who may have encountered this before, should I create 

ADM:Timing test

[Grooms, Frederick W]

This is just a timing test



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

Re: Quotes in a set field

[Grooms, Frederick W]

What OS is your Remedy server on?   On Unix/Linux you can look at the 
arfork.log file to see the actual command executed and what error may have 
occurred.
And is this server side (Filter) or client side (Active Link)?

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark
Sent: Wednesday, December 21, 2016 2:41 PM
To: arslist@ARSLIST.ORG
Subject: Re: Quotes in a set field

**
Hi Fred

Actually echo echo “$field$” > file worked on the Remedy Side but didn’t 
actually create or update the file. Probably either a path or permission issue, 
but this was a great start.

Thanks
Mark


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, December 21, 2016 1:54 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Quotes in a set field

**
There are multiple ways to do this.

Notify Action (using the Other value)
Runprocess Action (doing something like echo “$field$” > file )
Doing a plugin to write the file

After you have a file on the server you can use the runprocess command in a set 
fields action
  PERFORM-ACTION-ADD-ATTACHMENT fieldID [ "fileName" ]

Fred


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark
Sent: Wednesday, December 21, 2016 12:29 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Quotes in a set field

**
Thanks everyone, this has been very helpful. Have a second question which might 
not be possible.

Based on the workflow that I started with below I end up with something like 
this

{
"MultiRequest":  {
"data":  [

   {
  "host": "Server ABC.34190",
  "duration" :"1440 minutes"
},
   {
  "host": "Server Z.34190",
  "duration" :"1440 minutes"
}
  ]
}
}

Is there way to push this into a file and then attach the file to a record? The 
file would always have the same file name.

Thanks
Mark


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Tuesday, December 20, 2016 3:54 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Quotes in a set field

**

Hi,

The LJ solution is the simplest one. But you can do what you originally tried 
to if you add one more double quote making it four, not three:
("""" + "hosts:" + """" + $Server Name$)

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


-Original Message-
December 19, 2016 11:13 PM, "LJ LongWing" 
<lj.longw...@gmail.com<mailto:%22lj%20longwing%22%20%3clj.longw...@gmail.com%3e>>
 wrote:
**
"""hosts: """ + $Server Name$



-Original Message-
On Mon, Dec 19, 2016 at 3:09 PM, Brittain, Mark 
<mbritt...@navisite.com<mailto:mbritt...@navisite.com>> wrote:
**

Hi All

I need to do a set field where there is text in quotes and the a field 
reference. Result would be like

“host:” server1

Tried “”” + “hosts:” + “”” + $Server Name$ but that doesn’t work. I know it is 
something simple but it has been a long time since I have tried it.

ARS 7.6

Thanks

Mark

Mark Brittain | Systems Engineer | 315.634.9337

125 Elwood Davis Road | Syracuse NY 13212

[Navisite]




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

Re: Quotes in a set field

[Grooms, Frederick W]

There are multiple ways to do this.

Notify Action (using the Other value)
Runprocess Action (doing something like echo “$field$” > file )
Doing a plugin to write the file

After you have a file on the server you can use the runprocess command in a set 
fields action
  PERFORM-ACTION-ADD-ATTACHMENT fieldID [ "fileName" ]

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark
Sent: Wednesday, December 21, 2016 12:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: Quotes in a set field

**
Thanks everyone, this has been very helpful. Have a second question which might 
not be possible.

Based on the workflow that I started with below I end up with something like 
this

{
"MultiRequest":  {
"data":  [

   {
  "host": "Server ABC.34190",
  "duration" :"1440 minutes"
},
   {
  "host": "Server Z.34190",
  "duration" :"1440 minutes"
}
  ]
}
}

Is there way to push this into a file and then attach the file to a record? The 
file would always have the same file name.

Thanks
Mark

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Tuesday, December 20, 2016 3:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: Quotes in a set field

**
Hi,

The LJ solution is the simplest one. But you can do what you originally tried 
to if you add one more double quote making it four, not three:
( + "hosts:" +  + $Server Name$)

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


December 19, 2016 11:13 PM, "LJ LongWing" 
>
 wrote:
**
"""hosts: """ + $Server Name$
On Mon, Dec 19, 2016 at 3:09 PM, Brittain, Mark 
> wrote:
**

Hi All

I need to do a set field where there is text in quotes and the a field 
reference. Result would be like

“host:” server1

Tried “”” + “hosts:” + “”” + $Server Name$ but that doesn’t work. I know it is 
something simple but it has been a long time since I have tried it.

ARS 7.6

Thanks

Mark

Mark Brittain | Systems Engineer | 315.634.9337

125 Elwood Davis Road | Syracuse NY 13212

[Navisite]


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

Re: ARERR 552 - when saving a record

[Grooms, Frederick W]

There are a few ways to correct depending on what you need ...
   a. You can reset the NextID in the ARSCHEMA table
   b. You can adjust the max by changing the size of the Request ID field in 
the form   

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Su Kaur
Sent: Monday, December 12, 2016 10:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARERR 552 - when saving a record

How to fix this issue?

Thanks!
Kaur

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Monday, December 12, 2016 9:40 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARERR 552 - when saving a record

Yes.   The SQL log shows you have reached the MAX for the Request ID

2147483640  = ID you are trying to set
2147453907  = Max Request ID allowed

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kaur
Sent: Monday, December 12, 2016 9:16 AM
To: arslist@ARSLIST.ORG
Subject: ARERR 552 - when saving a record

Hello All,

I'm getting following error when saving a record. Checked all the field values 
and everything is correct.
ARERR [552] The SQL database operation failed. : Arithmetic overflow error 
converting expression to data type int.

Following in SQL errors -
UPDATE arschema SET nextId = nextId + 25 OUTPUT inserted.nextId WHERE schemaId 
= 1256
OK
ROLLBACK TRANSACTION


nextID = 2147483640  in arschema for schemaID 1256
max requestId in the form is 2147453907

Number of records in form = 36836

Could this be an issue with generating a requestId? I'm not having any issue 
updating a record manually or via import.

Thanks!
Kaur

___
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"

Re: ARERR 552 - when saving a record

[Grooms, Frederick W]

Yes.   The SQL log shows you have reached the MAX for the Request ID   

2147483640  = ID you are trying to set   
2147453907  = Max Request ID allowed   

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kaur
Sent: Monday, December 12, 2016 9:16 AM
To: arslist@ARSLIST.ORG
Subject: ARERR 552 - when saving a record

Hello All,

I'm getting following error when saving a record. Checked all the field values 
and everything is correct.
ARERR [552] The SQL database operation failed. : Arithmetic overflow error 
converting expression to data type int.

Following in SQL errors -
UPDATE arschema SET nextId = nextId + 25 OUTPUT inserted.nextId WHERE schemaId 
= 1256
OK
ROLLBACK TRANSACTION


nextID = 2147483640  in arschema for schemaID 1256
max requestId in the form is 2147453907

Number of records in form = 36836

Could this be an issue with generating a requestId? I'm not having any issue 
updating a record manually or via import.

Thanks!
Kaur 

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

Re: Regarding Upgrade of Microsoft Exchange from 2007 to 2013

[Grooms, Frederick W]

I believe it will work with Exchange 2007 and later

How are you connecting with Exchange (MAPI, POP/SMTP, IMAP, …)?


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of sriram pm
Sent: Sunday, December 11, 2016 6:44 AM
To: arslist@ARSLIST.ORG
Subject: Regarding Upgrade of Microsoft Exchange from 2007 to 2013

**
Hi Experts,

From the "BMC Remedy AR System 7.6.04 Compatibility Matrix" I understand that 
the Email Engine is compatible only with Microsoft Exchange 2007. Since the 
support for Exchange 2007 is ending by April 2017, we would like to know is 
there any workaround to make the Current version Email Engine(7.6.04) work with 
Microsoft Exchange 2013.

Kindly share any possible workaround.

Thank you,
Sriram.


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

Re: Outlook Integration

[Grooms, Frederick W]

Since you are using HTTPS have you loaded the certificate into the keystore (or 
told SoapUI which certificate to use)?  

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Irving, Isabel (ACCESS LLP)
Sent: Wednesday, November 30, 2016 6:19 AM
To: arslist@ARSLIST.ORG
Subject: Outlook Integration

Hello!

We're looking to create a room booking system which would also integrate with 
Outlook.  We're on Outlook 2007 and Remedy 8.1.

My preference would be to use web services because that is tried and tested in 
our environment.

Has anyone else tried this?

What we've tried so far is connecting to the Services.wsdl in SOAP UI.  If I 
just put the wsdl URL in "Initial WSDL" field it prompts me for a username, 
password and domain and after entering that, I get this error:

Error loading [https://webmail.access.uk.com/ews/Services.wsdl]: 
org.apache.xmlbeans.XmlException: org.apache.xmlbeans.XmlException: error: 
Unexpected end of file after nul
I get EXACTLY the same error if I intentionally put in wrong credentials.

The email team have created a user for me to test with, and that user has 
"exchange impersonation rights".  Is that necessary or should it also work if I 
connect as myself (i.e. a normal outlook exchange user).

Any pointers?  I feel like this should be a straightforward operation but maybe 
it isn't...

Thanks!
Isabel


Server Information
Application server version: 8.1.00 201301251157
Operating system: SunOS 5.10
On Sun Solaris virtual cluster

Database
Database version: 11.1.0.6.0 - 64bit Production
On Sun Solaris virtual cluster

Mid Tier Version
8.1.SP02 Patch 001 201505281150 Hotfix
Installation Directory
 Web Server Information
Apache Tomcat/7.0.53
Operating System Name
Windows Server 2012
Java Version
1.7.0_80

Glasgow - UK Council of the Year 2015

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

Re: Publish Web Services from BMC Remedy based on AR Server Event

[Grooms, Frederick W]

For Remedy to push to Jira you will do a Set Fields action in Remedy that calls 
the Jira web service and pushes the data to them.

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sivarama Velicheti
Sent: Monday, October 24, 2016 2:37 PM
To: arslist@ARSLIST.ORG
Subject: Publish Web Services from BMC Remedy based on AR Server Event

**
Hi Group,
  I have a pretty basic questions regarding Remedy Web Services which I 
am trying to figure out. We are trying to establish a bi directional flow 
between remedy and Jira. When a ticket is created in Jira (Incident) it's also 
created in remedy for certain request types and vice verso. We are using SOAP 
calls for this purpose. I have the ticket creation/updates in remedy part 
defined and we have tested it to be working fine. I am stuck when it comes to 
publishing data from remedy. How do we exactly trigger this from remedy? I have 
received a wsdl from the jira team but am unable to figure out how to send data 
from remedy on let's say ticket creation or worklog updates? Any Help into 
explaining process this will be greatly appreciated.

--
Thanks
Shiva V



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

Re: 9.1 Upgrade Change HostID

[Grooms, Frederick W]

Is this a system where the hardware people had to “override” or “clone” the MAC 
address?

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Friday, September 02, 2016 11:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: 9.1 Upgrade Change HostID

**
Frank, are there multiple NIC's in the machine?  I 100% agree that the host id 
should not change on an upgrade, but 8.x and 9.1 use different code bases 
c/java, so it's possible that Java is making the equivalent call to the OS but 
getting a different value if there are multiple host idsthe best bet is to 
re-license with the new host id.

On Fri, Sep 2, 2016 at 9:15 AM, Frank Caruso wrote:
I understand the MAC "could" change but the history of this server is that it 
has had the same license key (therefore MAC) for the last two years. It was 
only when the ARS 9.1 upgrade was run did the hostid change. When I checked 
BMCs web site I can find the original license key and host id and the hostid is 
different from what is being shown on the Add/Remove license screen.





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

Re: Application-Query-Delete-Entry

[Grooms, Frederick W]

I learn something new

Thanks

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug
Sent: Wednesday, August 31, 2016 2:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry

**
Fred,

The key is to not have the keyword interpreted as you prepare the command line 
to be run.

As entered by Dave, there were no “” around the keyword – as there should not 
be to work as a keyword.  But, as it was just the keyword, it was being 
expanded as the run process was being created rather than staying as a keyword 
to be processed in the qualifier as the command ran.

It would expand into the timestamp value.  Without quotes, you get one error – 
a syntax error.  With quotes you get another syntax error of a character string 
being subtracted by a number (or if it auto converts, likely you get the month 
as an integer and that is involved in the arithmetic operation).

The key is to keep it from expanding as the command line is being built so that 
it is a true keyword when the command is run and it is passed on to the process.

Doug

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, August 31, 2016 12:28 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Application-Query-Delete-Entry

**
Would using the Slash (and no Double Quotes) make the keyword be treated as the 
number value in the Run Process?
   '3' < (1472670600 - (86400 * 75))

I was thinking he was getting the qualification error when the Active Link 
fires because of the expansion and no double quotes
   '3' < ($TIMESTAMP$ - (86400 * 75))
Expands to something (assuming US format) which the Run Process command 
wouldn’t understand
   '3' < (08/31/2016 2:10:00 PM - (86400 * 75))
(8 divided by 31 divided by 2016 then error as it doesn’t know what to do with 
the 2 )

With Double Quotes around the keyword  ( “$TIMESTAMP$” ) it would expand to
   '3' < (“08/31/2016 2:10:00 PM” - (86400 * 75))

Fred


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug
Sent: Wednesday, August 31, 2016 2:01 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Application-Query-Delete-Entry

**
Dave,

All the other suggestions about archive and escalations and the like apply as 
different ways to get this done.

But, to tell you why what you were doing below doesn’t work and to help any 
other users having issues with qualifiers in run processes.

Use $\TIMESTAMP$ instead of $TIMESTAMP$ in the qualifier.

The extra \ is to escape interpretation of the value.  As entered, the 
TIMESTAMP keyword is expanded as it is processing rather than being a keyword 
so you get the syntax error.  Putting in the \ will keep it a keyword and your 
qualifier should do what you wanted.  This syntax is needed only for situations 
where you are putting a qualifier inside the logic of an operation (not in the 
RunIF  but in places where normally the keyword is expanded during as the 
operation proceeds).


(and I think it is a \.  If not, try /…..)

NOTE: Still using the archive or escalation or other mechanism may be the best 
answer for your specific situation.   I just wanted to explain the reason that 
you were having the issue with the qualifier below.

Doug Mueller

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Dave Barber
Sent: Tuesday, August 30, 2016 6:49 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Application-Query-Delete-Entry

**
All,
I'm trying to figure out the syntax required for Application-Query-Delete-Entry 
 (Server is running ARS 7.5)
Trying to keep an "archive" of emails - we have a requirement to keep 6 months 
worth in the system (audit trail, proof of sending, etc.), and the form was 
actually turning out to be the largest on the system (over 7 million records - 
I manually deleted the older ones via the user tool, that is not fun!).
In an active link, just trying a simple
 $PROCESS$ @@:Application-Query-Delete-Entry "AR System Email Messages" '3' < 
($TIMESTAMP$ - (86400 * 75))
The 75 is related to a test system and the data that is on it (would obviously 
be changed on live).  The query itself is fine against the email messages form, 
it just comes up with a qualification error when run via the active link.
Any suggestions?  I could try an alternative using Application-Delete-Entry 
  and table walking, but that'll be horrendously inefficient 
in comparison to Application-Query-Delete-Entry.
Regards
Dave Barber


_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"

Re: Application-Query-Delete-Entry

[Grooms, Frederick W]

Would using the Slash (and no Double Quotes) make the keyword be treated as the 
number value in the Run Process?
   '3' < (1472670600 - (86400 * 75))

I was thinking he was getting the qualification error when the Active Link 
fires because of the expansion and no double quotes
   '3' < ($TIMESTAMP$ - (86400 * 75))
Expands to something (assuming US format) which the Run Process command 
wouldn’t understand
   '3' < (08/31/2016 2:10:00 PM - (86400 * 75))
(8 divided by 31 divided by 2016 then error as it doesn’t know what to do with 
the 2 )

With Double Quotes around the keyword  ( “$TIMESTAMP$” ) it would expand to
   '3' < (“08/31/2016 2:10:00 PM” - (86400 * 75))

Fred


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug
Sent: Wednesday, August 31, 2016 2:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: Application-Query-Delete-Entry

**
Dave,

All the other suggestions about archive and escalations and the like apply as 
different ways to get this done.

But, to tell you why what you were doing below doesn’t work and to help any 
other users having issues with qualifiers in run processes.

Use $\TIMESTAMP$ instead of $TIMESTAMP$ in the qualifier.

The extra \ is to escape interpretation of the value.  As entered, the 
TIMESTAMP keyword is expanded as it is processing rather than being a keyword 
so you get the syntax error.  Putting in the \ will keep it a keyword and your 
qualifier should do what you wanted.  This syntax is needed only for situations 
where you are putting a qualifier inside the logic of an operation (not in the 
RunIF  but in places where normally the keyword is expanded during as the 
operation proceeds).


(and I think it is a \.  If not, try /…..)

NOTE: Still using the archive or escalation or other mechanism may be the best 
answer for your specific situation.   I just wanted to explain the reason that 
you were having the issue with the qualifier below.

Doug Mueller

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Dave Barber
Sent: Tuesday, August 30, 2016 6:49 AM
To: arslist@ARSLIST.ORG
Subject: Application-Query-Delete-Entry

**
All,
I'm trying to figure out the syntax required for Application-Query-Delete-Entry 
 (Server is running ARS 7.5)
Trying to keep an "archive" of emails - we have a requirement to keep 6 months 
worth in the system (audit trail, proof of sending, etc.), and the form was 
actually turning out to be the largest on the system (over 7 million records - 
I manually deleted the older ones via the user tool, that is not fun!).
In an active link, just trying a simple
 $PROCESS$ @@:Application-Query-Delete-Entry "AR System Email Messages" '3' < 
($TIMESTAMP$ - (86400 * 75))
The 75 is related to a test system and the data that is on it (would obviously 
be changed on live).  The query itself is fine against the email messages form, 
it just comes up with a qualification error when run via the active link.
Any suggestions?  I could try an alternative using Application-Delete-Entry 
  and table walking, but that'll be horrendously inefficient 
in comparison to Application-Query-Delete-Entry.
Regards
Dave Barber



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

Re: Application-Query-Delete-Entry

[Grooms, Frederick W]

Usually I have to enclose Date values in strings 

And I enclose the entire query string in a set of parenthesis   
('3' < (“$TIMESTAMP$” - (86400 * 75)))



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Dave Barber
Sent: Tuesday, August 30, 2016 8:49 AM
To: arslist@ARSLIST.ORG
Subject: Application-Query-Delete-Entry

** 
All,
I'm trying to figure out the syntax required for Application-Query-Delete-Entry 
 (Server is running ARS 7.5)
Trying to keep an "archive" of emails - we have a requirement to keep 6 months 
worth in the system (audit trail, proof of sending, etc.), and the form was 
actually turning out to be the largest on the system (over 7 million records - 
I manually deleted the older ones via the user tool, that is not fun!).
In an active link, just trying a simple
 $PROCESS$ @@:Application-Query-Delete-Entry "AR System Email Messages" '3' < 
($TIMESTAMP$ - (86400 * 75))
The 75 is related to a test system and the data that is on it (would obviously 
be changed on live).  The query itself is fine against the email messages form, 
it just comes up with a qualification error when run via the active link.
Any suggestions?  I could try an alternative using Application-Delete-Entry 
  and table walking, but that'll be horrendously inefficient 
in comparison to Application-Query-Delete-Entry.
Regards
Dave Barber
_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"

Re: ARS Version Question

[Grooms, Frederick W]

I believe 4
I think 4.5 removed that option

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Timothy Powell
Sent: Friday, August 26, 2016 1:59 PM
To: arslist@ARSLIST.ORG
Subject: ARS Version Question

I'm sure this is going to be easy for those of you that are skilled trivia 
buffs, but I honestly can't recall.
What was the last version of ARS with the ability to run on a flat file?
Anybody remember?

TIA,
Tim




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

Re: Send request

[Grooms, Frederick W]

Did they upgrade to the 32 bit Office 2016 or the 64 bit Office?   
Remember the User Tool is 32 bit and Windows has issues with a 32 bit app 
calling a 64 bit app 

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Lee Cullom
Sent: Thursday, August 18, 2016 8:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: Send request

Try this:

http://www.technipages.com/word-enable-send-to-mail-recipient-option

they may need to set their default mail client.

Lee Cullom | Northcraft Analytics
IT Metrics Specialist | Business Intelligence Applications for IT
Direct – 678-438-7244 | http://www.northcraftanalytics.com
Main - (678) 664-ITSM

What is Northcraft Analytics? Find out in 87 Seconds.  

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Janne Olsson
Sent: Thursday, August 18, 2016 6:17 AM
To: arslist@ARSLIST.ORG
Subject: Send request

Hi,
We run ARServer 8.1 with SQL Server.
Our users still prefer to use User tool 7.6.04 (and it works fine).
Recently we upgraded to Office 2016 and after that some users face a problem 
with the function File -> Send Request -> Mail Recipient.
The menu choice is disabled (grayed out).
Anyone else that have faced that problem and found a solution for it?

Thanks,
Janne



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

Re: Limit Time Of Day a Filter Runs

[Grooms, Frederick W]

I have used something like this in the past   ( Substitute $TIMESTAMP$ or 
$SERVERTIMESTAMP$ for 'Create Date' )
Example of between 1 AM and 5 AM   
('Create Date' - "1/1/70" ) % 86400) >= (1 * 3600)) AND ((('Create 
Date' - "1/1/70") % 86400) <= (5 * 3600   

The Logic is as follows   
Take the date/time and subtract the constant of the first date allowed.   This 
converts the date/time to an integer internally in seconds.   
MOD the date by the number of seconds in a day (This gives you the time of day) 
  

You can then do your comparisons 

Fred

 Original Message 
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd
Sent: Friday, August 12, 2016 12:51 PM
To: arslist@ARSLIST.ORG
Subject: Limit Time Of Day a Filter Runs

** 
We have a filter that is set up to send an email and need to limit it so that 
it only sends the email if the current time is between 7 AM and 6 PM.  Does 
anyone know if there is a way to limit this maybe by adding a qualification to 
the run if statement?  Any other ideas on how we may be able to limit the time 
of day the filter fires?

We are on ARS 8.1, and SQL 2008

Thanks in advance for any help

Todd Arner
Great Lakes

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

BIRT reporting

[Grooms, Frederick W]

I wanted to verify something...  From the documents "Birt Reports: Resources" 
 and "Enabling BIRT to access your 
BMC Remedy AR System data by setting BIRT preferences - BMC Remedy Action 
Request System 8.…" 

   I was able to pull down the zip files and create a BIRT report.

In order for my users to use the report on the web do I need to put the 2 zip 
files into the AR System Resource Definitions form (I have base ARS 9.1 without 
ITSM so there are no records in that form)?

If I do then what are the values for the fields in the record: Name, Status 
(Active), Type (BIRT Library), Description, Mime Type, Sub Type)?   Will 
someone with ITSM look in the Resource Definitions form and tell me the records 
you have for  Type = "BIRT Library".

Thanks
Fred

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

Re: New Instance Setup

[Grooms, Frederick W]

It looks like it is trying to login to the new ARS (like it is expecting the 
ARS to be up and running to be able to do an upgrade)

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of DanfromVA
Sent: Friday, June 24, 2016 9:36 AM
To: arslist@ARSLIST.ORG
Subject: New Instance Setup

We are running to authentication error. We have only done 7.6.04 setup on ARS. 
No mid tier yet. 
What we have done is cloned the existing DB, install ARS except mid tier, 
during install use all the same ID and password.
When prompted, we used "upgrade" option on the database instead of "overwrite".

Errors appear as 
THROWABLE EVENT = Failure while trying to connect to ARServer,
ERROR 623: Authencation failed;

THROWABLE EVENT = failed to perform approval server sanity check





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

Re: ARSlist Future

[Grooms, Frederick W]

Actually I have tried the email reply to other Communities posts and I always 
get an error

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Thursday, June 02, 2016 9:09 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARSlist Future

Hi Frederick,

If you are not interested in other things on communities, it is very easy to
set it up in a similar way as it works now.

You get an email for each post, and you can reply to the post using email.

To get the complete thread you click on a link in the email to read it.

Or the thread view, in my email reader, also works fine on the communities
emails.

It is easy to create a mail-sorting-filter on the subject of the email to get
all future ARSList emails into a separate folder, just as I get my current
ARSList emails sorted :-)

So if you do not want things to change, it can stay more or less as it is now.

I think that Dan has made sure that something similar to the digest emails
will also be available. Right Dan?

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.

> I will be sad to see it move.   Email is so much easier and so much less
> bandwidth than a web forum.
>
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Daniel Bloom
> Sent: Wednesday, June 01, 2016 3:37 PM
> To: arslist@ARSLIST.ORG
> Subject: ADM: ARSlist Future
>
> **
> I will be moving the ARSlist Community to BMC Communities. Where our members
> will still be the only ones that know why this is the Action Request System
> list and not the Remedy list.
>
> Some of the concerns expressed have been raised by me with BMC and I make this
> move with the assurance of non-interference and in fact increased co-operation
> for the good of the community.
>
> At least one server will stay commissioned until October, but various web
> sites and services you see will vanish between now and then as I work with BMC
> and my ISP.
>
> The URLs will be changed to point to the new home at the appropriate time, and
> I will continue with (likely monthly) updates over the summer.
>
> Note: WWRUG still exists and like any franchise of repeatable events, can
> return at any time with the same or a new cast :)
>
> The Farewell to the Listserv based version of the ARSlist will be held at
> BMC:Engage, where the answers are.
>
> Cheers Daniel
> RAC 1995 [no number, they didn't have them yet]
> Founder of the ARSlist
> Chairman of WWRUG



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

Re: Modify login.jsp on Unix mid tier

[Grooms, Frederick W]

Since it is owned by root then only root can modify

You will need to contact your system admin (whoever can login to the server as 
root) to change the permissions/owner

If root has given you rights to run the chown command you could do 
   sudo  chown      login.jsp   

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Su Kaur
Sent: Thursday, June 02, 2016 9:05 AM
To: arslist@ARSLIST.ORG
Subject: Re: Modify login.jsp on Unix mid tier

This is what I used.

-bash$   ls -l login.jsp
-rwxr-xr-x1   root   root

-bash$  pfexec chown   login.jsp
chown: login.jsp: Not owner


-Kaur



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

Re: ARSlist Future

[Grooms, Frederick W]

I'm will be sad to see it move.   Email is so much easier and so much less 
bandwidth than a web forum.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Daniel Bloom
Sent: Wednesday, June 01, 2016 3:37 PM
To: arslist@ARSLIST.ORG
Subject: ADM: ARSlist Future

**
I will be moving the ARSlist Community to BMC Communities. Where our members 
will still be the only ones that know why this is the Action Request System 
list and not the Remedy list.

Some of the concerns expressed have been raised by me with BMC and I make this 
move with the assurance of non-interference and in fact increased co-operation 
for the good of the community.

At least one server will stay commissioned until October, but various web sites 
and services you see will vanish between now and then as I work with BMC and my 
ISP.

The URLs will be changed to point to the new home at the appropriate time, and 
I will continue with (likely monthly) updates over the summer.

Note: WWRUG still exists and like any franchise of repeatable events, can 
return at any time with the same or a new cast :)

The Farewell to the Listserv based version of the ARSlist will be held at 
BMC:Engage, where the answers are.

Cheers Daniel
RAC 1995 [no number, they didn't have them yet]
Founder of the ARSlist
Chairman of WWRUG



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

Re: Modify login.jsp on Unix mid tier

[Grooms, Frederick W]

If you do   
ls -lt login.jsp   
It should tell you which login is the owner and what the permissions are

You will then need to either login as that login or as root to change the owner 
or permissions

Fred


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Su Kaur
Sent: Thursday, June 02, 2016 8:14 AM
To: arslist@ARSLIST.ORG
Subject: Modify login.jsp on Unix mid tier

Hello,

I am trying to edit login.jsp on 7.6 Unix mid tier but getting an error 
'Permission denied. You are not the owner'. I also tried changing the 
permissions still no luck.
Rename the file or moving a new file didnt work too.

Trying to add a 'System maintenance message' on top of the login screen.

How can I change the permission and update the file?

Thanks!
Kaur



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

Re: How to locate a macro? - Remedy 9

[Grooms, Frederick W]

LJ means that instead of calling a Macro from the Active Link you need to write 
in Active Links to do what the Macro is doing

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Fawver, Dustin
Sent: Wednesday, May 25, 2016 1:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: How to locate a macro? - Remedy 9

**

LJ,



I hope this isn't a stupid question, but could you clarify what you mean by 
"native Remedy code"?  I'm familiar with Active Links, Filters, Escalations and 
the like, but are you referring to something more than that?



Thanks!



--Dustin Fawver



ITS Helpdesk

East Tennessee State University

423-439-4648

itsh...@etsu.edu


From: Action Request System discussion list(ARSList) 
> on behalf of LJ LongWing 
>
Sent: Wednesday, May 18, 2016 9:44 AM
To: arslist@ARSLIST.ORG
Subject: Re: How to locate a macro? - Remedy 9

**
Kaur,
I seem to remember a button in the AL that allowed you to 'save' the macro to 
filebut

Macros in Active Links have only ever worked in the user tool, which hasn't had 
a release since 7.6.04, and those macros have never worked on Mid-Tier, which 
is the only client produced and supported since 8.0so, when you say it's 
not workingare you still using the 7.6.04 user tool against your 9.x 
server?then it should still workotherwise, it won'tand as far as 
technology is concerned...you should replace that macro functionality with 
native Remedy code instead of a Macro to make it work in Mid-Tier.

On Wed, May 18, 2016 at 6:54 AM, Su Kaur 
> wrote:
Hello All,

We have an active link with SET field actions - 'Run Macro'. How can I locate 
this macro? Only the macro name is there, not full path.
This macro is working on 7.6 prod but not on 9.0.01 test environment. Is it 
located somewhere on the app server?

Only thing I know is, it deletes the selected record.

Thanks!
Kaur



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

Re: How to locate a macro? - Remedy 9

[Grooms, Frederick W]

LJ,
I think that was in the v5 (or 5.5) Admin tool.  I don’t even think it was in 
the v6.3 Admin tool.

What is funny is I just looked and even a base AR System install for v 8.01 has 
5 Active Links with Macros (All are named Pre5.)

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Wednesday, May 18, 2016 8:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: How to locate a macro? - Remedy 9

** 
Kaur,
I seem to remember a button in the AL that allowed you to 'save' the macro to 
filebut

Macros in Active Links have only ever worked in the user tool, which hasn't had 
a release since 7.6.04, and those macros have never worked on Mid-Tier, which 
is the only client produced and supported since 8.0so, when you say it's 
not workingare you still using the 7.6.04 user tool against your 9.x 
server?then it should still workotherwise, it won'tand as far as 
technology is concerned...you should replace that macro functionality with 
native Remedy code instead of a Macro to make it work in Mid-Tier.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Su Kaur
Sent: Wednesday, May 18, 2016 7:54 AM
To: arslist@ARSLIST.ORG
Subject: How to locate a macro? - Remedy 9

Hello All,

We have an active link with SET field actions – ‘Run Macro’. How can I locate 
this macro? Only the macro name is there, not full path.
This macro is working on 7.6 prod but not on 9.0.01 test environment. Is it 
located somewhere on the app server?

Only thing I know is, it deletes the selected record.

Thanks!
Kaur

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

Re: How to locate a macro? - Remedy 9

[Grooms, Frederick W]

Macro's in Active Links were stored in the database on the server in the 
ACTLINK_MACRO table.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Su Kaur
Sent: Wednesday, May 18, 2016 7:54 AM
To: arslist@ARSLIST.ORG
Subject: How to locate a macro? - Remedy 9

Hello All,

We have an active link with SET field actions – ‘Run Macro’. How can I locate 
this macro? Only the macro name is there, not full path.
This macro is working on 7.6 prod but not on 9.0.01 test environment. Is it 
located somewhere on the app server?

Only thing I know is, it deletes the selected record.

Thanks!
Kaur



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

Re: Making field required after the fact

[Grooms, Frederick W]

Are you saying the field is required each time a member of the group updates 
the record or once it has a value it is good for the life of the ticket?

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Tom Siegel
Sent: Friday, May 06, 2016 2:43 PM
To: arslist@ARSLIST.ORG
Subject: Making field required after the fact

Folks I have a custom tab on the HPD:Help Desk form that holds a custom 
DateTime field. The ask was to make the field required if the logged in user is 
a member of a specific support group. Easy enough so I created an active link 
to make the field required. Everything works as it should on submit, but even 
though the lable is bold and has the asterisk, the system is not treating the 
field as required on Modify. After doing some active link logging I decided to 
disable my active link and make the field required on the HPD:Help Desk form. 
Same behavior, it is enforced on submit but not on modify. Could this perhaps 
be built in functionality for Remedy? If so are there any suggested work 
arounds?

Thansk,

Tom




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

Re: arforkd - Linux upgrade issue

[Grooms, Frederick W]

Since you are on Linux, yes you can copy binaries (or create symbolic links if 
the patch moved a binary file)   

You can also check the runtime environment to see if the PATH or 
LD_LIBRARY_PATH is different.   
>From the bin directory   arsystem env   
(Since arforkd is 32 bit it may be using LD_LIBRARY_PATH_32)   

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow
Sent: Thursday, May 05, 2016 12:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: arforkd - Linux upgrade issue

Thanks all for the help so far.  It appears that possibly the AR Server service 
was up on 1 or more boxes when Linux was patched, causing a bunch of broken 
library references, etc.

Still working on what to do about it long term - we're running some tests on a 
"good" server seeing if we can break it right now.

I am hoping that if this is the cause we can just copy binaries, etc, from a 
good server to a broken oneone thing at a time.

William Rentfrow
wrentf...@stratacominc.com
Office: 715-204-3061 or 701-232-5697x25
Cell: 715-498-5056


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, May 04, 2016 11:58 AM
To: arslist@ARSLIST.ORG
Subject: Re: arforkd - Linux upgrade issue

If it is a missing library you should be able to find out by doing (when logged 
in as the user running the processes)   
   ldd arforkd

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow
Sent: Wednesday, May 04, 2016 11:43 AM
To: arslist@ARSLIST.ORG
Subject: Re: arforkd - Linux upgrade issue

Thanks all! We're checking the logs ASAP!  I think it is tied to the os 
libraries somehowstill trying to figure it out.

William Rentfrow
wrentf...@stratacominc.com
Office: 715-204-3061 or 701-232-5697x25
Cell: 715-498-5056


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Stone, Brian
Sent: Wednesday, May 04, 2016 10:24 AM
To: arslist@ARSLIST.ORG
Subject: Re: arforkd - Linux upgrade issue

It might be related to the os libraries which might be causing segment

faults while executing the arforkd process.   You could  set your ulimit to

unlimited(ulimit -c unlimited) to generate a dump.  It should go to the

ARSystem/bin dir


Also this is from KA331603

A log file name can be specified for the daemon by adding the line

Arfork-Log-File: xxx

to the AR System server's configuration file, where xxx is replaced by the name 
of the file to which the arforkd should write its log. If a log file name for 
the arforkd is specified, the arforkd will automatically be started by the 
server with logging turned on. Note that setting the name of the arforkd log 
file will have no effect until the arforkd is restarted, since the filename is 
passed to the process when it is started. Unlike the AR System server, the fork 
daemon does not perform circular logging, nor does it rename a log file if the 
file exists when the daemon starts. Instead, the daemon always appends its 
output to the file. This should ensure that we can learn the last action 
performed by a daemon if it dies without worrying that the log file will be 
removed if the process is restarted twice.

If the arforkd is started without specifying a log file and logging is turned 
on, it will write its log to its standard output. Logging is turned on by 
sending the arforkd a SIGUSR1 signal and turned off by sending the process a 
SIGUSR2 signal. If a fork daemon log file is to be removed while the arforkd is 
running, logging should be turned off before removing the file. Otherwise, the 
file will remain open as long as the process continues logging, even though the 
file's directory entry has been removed.

A last note: if the arforkd executable is not installed in the same directory 
as the AR System server executable, the server will not be able to start the 
fork daemon. In that case, the server will produce an error message and fall 
back to running child processes itself.


From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on 
behalf of Grooms, Frederick W [frederick.w.gro...@xo.com]
Sent: Wednesday, May 04, 2016 11:10 AM
To: arslist@ARSLIST.ORG
Subject: Re: arforkd - Linux upgrade issue

**
arforkd is started internally from arserverd

Is there any message giving an error in the arerror log on the startup?

Fred


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow
Sent: Wednesday, May 04, 2016 9:47 AM
To: arslist@ARSLIST.ORG
Subject: arforkd - Linux upgrade issue

**
Hi all -

We've been upgrading Linux on some older servers running ARS/ITSM 7.6.04x.

Some of them work.  Some do not - the ones that do not g

Re: arforkd - Linux upgrade issue

[Grooms, Frederick W]

If it is a missing library you should be able to find out by doing (when logged 
in as the user running the processes)   
   ldd arforkd

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow
Sent: Wednesday, May 04, 2016 11:43 AM
To: arslist@ARSLIST.ORG
Subject: Re: arforkd - Linux upgrade issue

Thanks all! We're checking the logs ASAP!  I think it is tied to the os 
libraries somehowstill trying to figure it out.

William Rentfrow
wrentf...@stratacominc.com
Office: 715-204-3061 or 701-232-5697x25
Cell: 715-498-5056


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Stone, Brian
Sent: Wednesday, May 04, 2016 10:24 AM
To: arslist@ARSLIST.ORG
Subject: Re: arforkd - Linux upgrade issue

It might be related to the os libraries which might be causing segment

faults while executing the arforkd process.   You could  set your ulimit to

unlimited(ulimit -c unlimited) to generate a dump.  It should go to the

ARSystem/bin dir


Also this is from KA331603

A log file name can be specified for the daemon by adding the line

Arfork-Log-File: xxx

to the AR System server's configuration file, where xxx is replaced by the name 
of the file to which the arforkd should write its log. If a log file name for 
the arforkd is specified, the arforkd will automatically be started by the 
server with logging turned on. Note that setting the name of the arforkd log 
file will have no effect until the arforkd is restarted, since the filename is 
passed to the process when it is started. Unlike the AR System server, the fork 
daemon does not perform circular logging, nor does it rename a log file if the 
file exists when the daemon starts. Instead, the daemon always appends its 
output to the file. This should ensure that we can learn the last action 
performed by a daemon if it dies without worrying that the log file will be 
removed if the process is restarted twice.

If the arforkd is started without specifying a log file and logging is turned 
on, it will write its log to its standard output. Logging is turned on by 
sending the arforkd a SIGUSR1 signal and turned off by sending the process a 
SIGUSR2 signal. If a fork daemon log file is to be removed while the arforkd is 
running, logging should be turned off before removing the file. Otherwise, the 
file will remain open as long as the process continues logging, even though the 
file's directory entry has been removed.

A last note: if the arforkd executable is not installed in the same directory 
as the AR System server executable, the server will not be able to start the 
fork daemon. In that case, the server will produce an error message and fall 
back to running child processes itself.


From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on 
behalf of Grooms, Frederick W [frederick.w.gro...@xo.com]
Sent: Wednesday, May 04, 2016 11:10 AM
To: arslist@ARSLIST.ORG
Subject: Re: arforkd - Linux upgrade issue

**
arforkd is started internally from arserverd

Is there any message giving an error in the arerror log on the startup?

Fred


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow
Sent: Wednesday, May 04, 2016 9:47 AM
To: arslist@ARSLIST.ORG
Subject: arforkd - Linux upgrade issue

**
Hi all -

We've been upgrading Linux on some older servers running ARS/ITSM 7.6.04x.

Some of them work.  Some do not - the ones that do not give a message saying 
arforkd is not running.  And sure enough it's not.

I'm having a brain cramp - where/how is arforkd started?  I don't see it 
referenced in the arsystem file or any of the *.sh files, and it's not in the 
armonitor.conf file or ar.conf.

???

William Rentfrow
wrentf...@stratacominc.com<mailto:wrentf...@stratacominc.com>
Office: 715-204-3061 or 701-232-5697x25
Cell: 715-498-5056

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

Re: arforkd - Linux upgrade issue

[Grooms, Frederick W]

arforkd is started internally from arserverd

Is there any message giving an error in the arerror log on the startup?

Fred


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow
Sent: Wednesday, May 04, 2016 9:47 AM
To: arslist@ARSLIST.ORG
Subject: arforkd - Linux upgrade issue

**
Hi all -

We've been upgrading Linux on some older servers running ARS/ITSM 7.6.04x.

Some of them work.  Some do not - the ones that do not give a message saying 
arforkd is not running.  And sure enough it's not.

I'm having a brain cramp - where/how is arforkd started?  I don't see it 
referenced in the arsystem file or any of the *.sh files, and it's not in the 
armonitor.conf file or ar.conf.

???

William Rentfrow
wrentf...@stratacominc.com
Office: 715-204-3061 or 701-232-5697x25
Cell: 715-498-5056




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

Re: I lost my father last evening..

[Grooms, Frederick W]

My deepest sympathy for your loss

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza
Sent: Friday, April 22, 2016 11:55 AM
To: arslist@ARSLIST.ORG
Subject: OT: I lost my father last evening..

**
I have considered many of you as a part of my extended family and have got to 
know many of you over the years personally so felt the need to inform those 
that know me that I lost my father last evening. He passed away peacefully and 
will be missed by those that he left behind, my mom, my brother and me.. He was 
a big part of who I am and what I may have become and I could not have asked 
anything more from him than what he could have given me.. Some of my best years 
of my childhood and my young adult life were the years I spent with him before 
I left home for perusing my career with Remedy..

Please keep him in your prayers..

Joe



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

Re: Web Service Server Configuration

[Grooms, Frederick W]

How are you triggering the Filter that consumes the customer’s WSDL?   If it is 
just an update on a form in your system that the Filter fires from then it 
should be immediate.  The only way I can see it taking that kind of time is if 
you are using an Escalation to trigger the send.

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Tom Shurmur
Sent: Friday, April 22, 2016 9:23 AM
To: arslist@ARSLIST.ORG
Subject: Web Service Server Configuration

**
TGIF Listers,

We have created an integration with a customer using the customers WSDL to send 
data. All is working well with the exception of the time it takes for 
attachments to be sent out of Remedy.

Currently sending a small 32k attachment takes 6 minutes for the attachment to 
leave Remedy.

Is there a config setting or settings that control this?

Thank you for any help

--
Tom Shurmur

The ARS List
Where answers are found



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

Re: Sending request - mailto: Navigation was cancelled

[Grooms, Frederick W]

Thomas,
A couple of questions.
What is your normal email program?   In IE what do you have for your default 
app to handle MAILTO?

And just for fun … What happens if you copy and paste the URL into an IE window?

The only thing I can see from your example that might cause an issue is that 
everywhere in the URL you encoded the space as %20 except for the space between 
Incident and Ticket.  Try changing that one to %20 as well

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark
Sent: Tuesday, April 19, 2016 12:41 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending request - mailto: Navigation was cancelled

**
Thomas

I have also tried mailto and unless you are real good formatting across 
multiple mail platforms and smartphones it might not get you the results you 
want. In any case, good luck

Mark

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Thomas Miskiewicz
Sent: Monday, April 18, 2016 9:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sending request - mailto: Navigation was cancelled

** Mark,

yes, we use PERFORM-ACTION-OPEN-URL and tried with New and current. The problem 
is IE not ARS.

The dialog option is of course nice, but we tried to keep it simple so we went 
for mailto.


Thanks
Thomas

On Monday, April 18, 2016, Brittain, Mark 
> wrote:
**
Thomas

Couple of options. First have you tried including current or new like 
PERFORM-ACTION-OPEN-URL NEW

I think I am doing the same opening a custom pre-formatted email form. I handle 
this by doing an open window (dialog) and then have a push field (create new 
record) and close window behind the sent button. Then I have an on create 
notify filter to actually send. Using the dialog allows you to size the “email” 
form

Hope this helps.

Mark

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG]
 On Behalf Of Thomas Miskiewicz
Sent: Saturday, April 16, 2016 4:09 AM
To: arslist@ARSLIST.ORG
Subject: Sending request - mailto: Navigation was cancelled

**
Hello there,
we got a button that builds the URL to the current request and then we perform 
PERFORM-ACTION-OPEN-URL $URL$ to open a new email.
The $url$ contains something like this: 
mailto:?subject=Incident
 
Ticket:%2000869696=%0ALink%20to%20Ticket:%0A>.
This works just fine but when we do it in the Internet Explorer it has the side 
effect that it opens and new IE window that says Navigation to the webpage was 
cancelled.
Ideas how to get rid of it or alternative solution how to email a link to a 
request?
Thanks
Thomas



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

Re: Table Field Initial State

[Grooms, Frederick W]

I’ve never paid attention to that property.   I have just used the Visible  
(True/False) property.

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Thomas Miskiewicz
Sent: Wednesday, April 13, 2016 8:59 AM
To: arslist@ARSLIST.ORG
Subject: Re: Table Field Initial State

**
Just found it in the display properties of the table field column. It's called 
initial state: Shown / Removed.

Thanks
Thomas

On 13 Apr 2016, at 15:31, Grooms, Frederick W 
<frederick.w.gro...@xo.com<mailto:frederick.w.gro...@xo.com>> wrote:
**
Depends on exactly what you are doing

Worst case would be to start with the columns hidden and use buttons with 
change field actions to make the columns visible

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Thomas Miskiewicz
Sent: Wednesday, April 13, 2016 5:53 AM
To: arslist@ARSLIST.ORG<mailto:arslist@arslist.org>
Subject: Table Field Initial State

**
Hello Listers,

I have a Form with 20 fields. I expose 10 of them using a Table Field.

Is it possible to pick 4 colums of those 10 and say show them by default and 
leave it up to the user whether he want to make them visible or not? If yes, 
how?


Thanks
Thomas





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

Re: Table Field Initial State

[Grooms, Frederick W]

Depends on exactly what you are doing

Worst case would be to start with the columns hidden and use buttons with 
change field actions to make the columns visible

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Thomas Miskiewicz
Sent: Wednesday, April 13, 2016 5:53 AM
To: arslist@ARSLIST.ORG
Subject: Table Field Initial State

**
Hello Listers,

I have a Form with 20 fields. I expose 10 of them using a Table Field.

Is it possible to pick 4 colums of those 10 and say show them by default and 
leave it up to the user whether he want to make them visible or not? If yes, 
how?


Thanks
Thomas



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

Re: DATE field value in Oracle calculation

[Grooms, Frederick W]

The Remedy DATE fields match up with the Oracle Julian format
   select to_date(2456797,'J') from DUAL
   5/19/2014

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Wednesday, March 30, 2016 10:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: DATE field value in Oracle calculation

** 
Keith,
I'm not in front of a computer at the moment, but searching the archives or on 
communities will give you the formula for days only fields

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sinclair, Keith
Sent: Wednesday, March 30, 2016 9:52 AM
To: arslist@ARSLIST.ORG
Subject: DATE field value in Oracle calculation

** 
I know DATETIME fields store the value as epoch time. However, when I look into 
the value for a DATE only field value, I get "2456797", which doesn't seem to 
match epoch time. How does this get stored and is there a formula that can be 
applied to the value to calculate the value to display the proper DATE in a 
human readable- format?
 
Example: START_DATE in the database stored as 2456797, needs to display an 
Oracle DATE type of 5/19/14.
 
Keith Sinclair
Remedy Development
ShopperTrak Chicago, USA
O 312.676.8289
ksincl...@shoppertrak.com | shoppertrak.com
Retail Profitability, Improved. 

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

Re: BMC Remedy Skype Intergration

[Grooms, Frederick W]

Starting a chat is simple…   Skype (was Lync) set itself up for the SIP 
protocol so all you have to do is to open a browser window to SIP://emailaddress

I don’t know about logging the chat session

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of BradRemedy
Sent: Wednesday, March 16, 2016 7:56 AM
To: arslist@ARSLIST.ORG
Subject: BMC Remedy Skype Intergration

**
Hi

Has anyone integrated Skype with BMC Remedy at all? We are looking into options 
in which a chat conversation could be started for a call and the chat log is 
added as a work info to a ticket when the chat is finished.

I am busy investigating options however wanted to know if anyone else has done 
this sort of integration before.

Thanks in advance

Brad



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

Re: Turn off AREA LDAP Polling?

[Grooms, Frederick W]

And if you are looking for the AR.CONF (ar.CFG for Windows) value it is  
External-Authentication-Sync-Timeout


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sinclair, Keith
Sent: Wednesday, March 16, 2016 9:05 AM
To: arslist@ARSLIST.ORG
Subject: Re: Turn off AREA LDAP Polling?

**
Never mind. I found it.

For those of you who are wondering -

On the EA tab in the Server Information Configuration form, you'll see a box 
called "Need To Sync". If this is set to 0, Remedy won't periodically make AD 
checks.

From: Sinclair, Keith
Sent: Wednesday, March 16, 2016 8:58 AM
To: arslist@ARSLIST.ORG
Subject: Turn off AREA LDAP Polling?

If I recall correctly, there is a way to tell Remedy to not make periodic AD 
checks every so often with a user's account that signed into Remedy using AREA 
LDAP but for the life of me, I cannot remember how or where it's done.

Anyone know where the setting is at?

Keith Sinclair
Remedy Development
ShopperTrak Chicago, USA
O 312.676.8289
ksincl...@shoppertrak.com | shoppertrak.com
Retail Profitability, Improved.

_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"

Re: BMC Remedy Skype Intergration

[Grooms, Frederick W]

Do you have Skype/Lync application?   Try opening a browser and put in the URL 
the SIP:emailaddress (No Slashes, that was a typo in my earlier response)

Sip (being a protocol like FTP) have MIME associations for them, so the 
standard browser will associate the SIP to call the Lync (or Skype) application 
and use the app as normal.

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jamie
Sent: Thursday, March 17, 2016 10:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: BMC Remedy Skype Intergration

Hello Fred,

I was interested in your comment where you said you can launch a chat window 
with Skype/Lync using SIP://emailaddress.  However, when I reached out to my 
exchange team that supports our Skype/Lync platform, they weren't aware of this 
capability and aren't sure how it can be done.  Can you provide a little more 
information on this?

Thanks!
Jamie




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

Re: Vendor Form to external Oracle Database

[Grooms, Frederick W]

Oops … that should have been
   create a local database view in the ARSYSTEM schema pointing to the external 
database

Basically in the local ARS database do
CREATE DATABASE LINK MY_DBLINK
CONNECT TO external_db_user
IDENTIFIED BY external_db_pass
USING '(description= (address_list= (address= (protocol=tcp) 
(host=external_server) (port=1521))) (connect_data= (service_name= 
external_service_name)))';

Then in the local ARS database do
CREATE OR REPLACE VIEW MY_LOCAL_VIEW
AS
Select * From external_table@MY_DBLINK;

You can then create a View Form in ARS against MY_LOCAL_VIEW

One advantage of using the local database view of the external is if you have 
multiple environments (Dev, Test, Prod, …)  and you need to connect Dev to an 
external Dev, … the ARS form is exactly the same in each.  Only the dbLink 
definition or local database view definition changes between environments.

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, March 09, 2016 1:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Vendor Form to external Oracle Database

**
Since you are on Oracle I would suggest just creating a dbLink to the external 
Oracle.
You can then create a View form thru the dbLink (although I prefer to create a 
local database view in the ARSYSTEM schema of the external database and then 
create my View Form off of that)

No Vendor plugin needed for a View form

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of jham36
Sent: Wednesday, March 09, 2016 12:17 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Vendor Form to external Oracle Database

**
ARS 9.1 windows 2008 oracle 11
External DB Oracle 11
I am trying to use ojdbc6.jar file from the oracle client installation to 
create a plugin to be used in a view form.
I am trying to follow the limited instructions that BMC offers on how to do 
this, but everything is too generic.  "create your plugin", "Add it to the 
Plugin Server Configuration", "Add anything else you need"
That's not much help.  I am sure someone has figured out how to do this.  I 
would think a connection to an external oracle database would be fairly common. 
 Common enough for BMC to provide better documentation.

Can anyone point me in the right direction here?  What needs to be provided 
when using the Plugin Server Config form?  What user defined parameters are 
needed?  What else is needed?  Do I have to manually update pluginserver cong 
and ar.cfg?

Thanks,
James


_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"

Re: Vendor Form to external Oracle Database

[Grooms, Frederick W]

Since you are on Oracle I would suggest just creating a dbLink to the external 
Oracle.
You can then create a View form thru the dbLink (although I prefer to create a 
local database view in the ARSYSTEM schema of the external database and then 
create my View Form off of that)

No Vendor plugin needed for a View form

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of jham36
Sent: Wednesday, March 09, 2016 12:17 PM
To: arslist@ARSLIST.ORG
Subject: Vendor Form to external Oracle Database

**
ARS 9.1 windows 2008 oracle 11
External DB Oracle 11
I am trying to use ojdbc6.jar file from the oracle client installation to 
create a plugin to be used in a view form.
I am trying to follow the limited instructions that BMC offers on how to do 
this, but everything is too generic.  "create your plugin", "Add it to the 
Plugin Server Configuration", "Add anything else you need"
That's not much help.  I am sure someone has figured out how to do this.  I 
would think a connection to an external oracle database would be fairly common. 
 Common enough for BMC to provide better documentation.

Can anyone point me in the right direction here?  What needs to be provided 
when using the Plugin Server Config form?  What user defined parameters are 
needed?  What else is needed?  Do I have to manually update pluginserver cong 
and ar.cfg?

Thanks,
James



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

Re: NextID being ignored

[Grooms, Frederick W]

It sounds like you have not set the Next Request ID block size (The default is 
25 so the server only reads the arschema when it runs out of the current block 
of numbers it has in memory)

Fred


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sinclair, Keith
Sent: Friday, March 04, 2016 11:29 AM
To: arslist@ARSLIST.ORG
Subject: NextID being ignored

**
Got a weird one.

On a form, I wanted to reset the Request ID to use a specific number range. 
When I reset the Next ID to say 1001, it creates the next record using the next 
number in sequence, . However, when I look at the arschema metadata, it 
tells me that the next ID to be used is 1001. Why would this be ignored?

Thanks,

Keith Sinclair
Remedy Development
ShopperTrak Chicago, USA
O 312.676.8289
ksincl...@shoppertrak.com | shoppertrak.com
Retail Profitability, Improved.




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