Re: ITSM Upgrade completed with warnings - In fact failed to upgrade

[Aditya Shrivastava]

Hi Pavan,

Please find my responses inline. Thanks!

Bottomline:
1) Compile all the 65 INVALID objects, in fact they are the reason for
longer run of your ITSM upgrade installer. They should have been identified
before running installer and must have been re-compiled. Keep checking for
them when installer is running and compile them.
2) You have trouble importing one join form. Take backup of base forms in
your environment. Import OOTB 8.1.02 version of the form directly.

Regards,
Aditya Shrivastava

On Tue, Mar 17, 2015 at 6:50 PM, Nagidi Pavan  wrote:

> **
> Hi Aditya,
>
> Thank you very much for your reply. Please find my answers below.
>
> 1) Which database you have? If you have Oracle, did you check for INVALID
> objects while installing/upgrading?
> ANS: Oracle, How do we checked INVALID objects by the below query and it
> fetched almost 65 entries
> select object_name,object_type,status from user_objects where
> status='INVALID';
>


> [APS]: Yes, this query gives you count of INVALID objects. You can
> re-compile these objects using "Compile" option from whatever software you
> are using. or run query to compile those objects.
>
Any suggestions to correct them is highly appreciated, also I would like to
> know why they are INVALID. How to troubleshoot that?
>
There are INVALID objects because of the fact that there are some
structural differences between how Remedy and Oracle creates tables and
views. But this is not a big problem as those INVALID objects can be
"Compiled" and then everything would be in sync.

>
> 2) Hope you must have seen ITSM install log files, but would again suggest
> you to look through logs and find out which .def failed to import. For ex
> chg_deplapp.def etc
> ANS: Fixed all most all the issues that we could see in the logs. The
> issues which we are seeing now is while importing
> CHG:ChangeRelationshipinterface form, which does not exist in 7.6.03 but
> seems like newly added in 8.1.02
>
> [APS]: I believe you have already followed recommended upgrade path 7.6.03
to 7.6.04 to 8.1.02.
Since this form doesn't exist in 7.6.03, I would like to try out following:
1. Identify the def to which it belong like chg_deplapp**.def and try to
import this form alone from 8.1.02_install folder.
2. If unable to find the def, you can try importing def of this form alone
obtained from an OOTB environment. Please note this is a join form so you
should have the base forms inn your environment
CHG:ChangeRelationshipinterface -> CHG:Associations + CHG:ChangeInterface


> 3) Go through all INC/PBM/CHG and import all the failed def files.
> ANS: imported all the def files related to INC and PBM only facing issues
> while importing chg_deplapp.def and especially with
> CHG:ChangeRelationshipinterface form.
>

[APS]:  You can try importing def of this form alone obtained from an OOTB
environment.

>
> 4) If you are facing issues with specific form import also - suggest you
> to modify them, save changes and again try to import them.
> ANS: Since we are only facing issues with CHG:ChangeRelationshipinterface
> form, is that fine modifying that form?
> My only concern is the above mentioned form does not exist in 7.603. We
> are upgrading ITSM from 7.6.03 to 8.1.02.
>

[APS]: As you said, this form doesn't exist in old environment and might be
newly added one. Would suggest take backup of base forms and import the
newly added join form obtained from an OOTB environement.

>
> Please let me now your thoughts and any suggestions to move forward!!
>
> Thanks once again.
>
>
> On Tue, Mar 17, 2015 at 9:07 AM, Aditya Shrivastava 
> wrote:
>
>> **
>> Hi Pavan,
>>
>> 1) Which database you have? If you have Oracle, did you check for INVALID
>> objects while installing/upgrading?
>> 2) Hope you must have seen ITSM install log files, but would again
>> suggest you to look through logs and find out which .def failed to import.
>> For ex chg_deplapp.def etc
>> 3) Go through all INC/PBM/CHG and import all the failed def files.
>> 4) If you are facing issues with specific form import also - suggest you
>> to modify them, save changes and again try to import them.
>>
>> Let us know how it goes. Thanks!
>>
>> Regards,
>> Aditya
>>
>> On Tue, Mar 17, 2015 at 5:59 AM, Nagidi Pavan 
>> wrote:
>>
>>> **
>>> Hello Experts,
>>>
>>> Do anyone has any suggestions for me!!
>>>
>>> On Fri, Mar 13, 2015 at 8:04 PM, Nagidi Pavan 
>>> wrote:
>>>
 Hi Ken,

 Thanks for your response.

 For the form which we are facing the issue, in the Base devleopment
 mode it shows its "overlaid", in the Best Practice Customization mode it
 shows "unmodified".

 Is this the issue? If so, how to overcome this?

 On Fri, Mar 13, 2015 at 2:52 AM, Ken Pritchard  wrote:

> **
>
> I’ve seen the unique index error occur when there is a form with and
> without the __c designation.  Seems like the system thinks they are two
> different forms, but the same form.
>
>
>
>>>

Archive-Delete possiblities for SLM forms

[Madhu V]

Hi List,

Can anyone suggest me the Archive-Delete possiblities for below SLM forms?.

SLM:AuditLog
SLM:Measurement
SLM:MilestoneLogging


We found many Entries in the above forms , since the Database size is growing 
we want to go for Archive-Delete option. Please let me if you foresee any 
impact if we archive-Delete these records.


Regards
Madhu

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

Re: Looking for a document

[Thad Esser]

Is this what you are looking for?  (its for Oracle)

https://docs.bmc.com/docs/display/public/ars81/Preparing+your+Oracle+database+before+you+install+the+AR+System+server#PreparingyourOracledatabasebeforeyouinstalltheARSystemserver-Settingupapreviouslycreatedtablespace


Here's the link with links to the other database types:

https://docs.bmc.com/docs/display/public/ars81/Preparing+your+database


Thad

On Wed, Mar 18, 2015 at 4:52 PM, Gordon Frank  wrote:

> **
> I know there is a document which has all of the SQL code which is used
> when ARSYSTEM is built.
>
> Does anyone know the document which has this? I can't remember which one
> it is.
>
> Thanks
> Gordon Frank
> _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"

Looking for a document

[Gordon Frank]

I know there is a document which has all of the SQL code which is used when
ARSYSTEM is built.

Does anyone know the document which has this? I can't remember which one it
is.

Thanks
Gordon Frank

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

Re: Digitally signed email or attached PDF

[Jason Miller]

I haven't done it but two things come to mind. 1) if there are command line
utilities for your platform (Win/*nix) that can check the signatures then
it must be doable with a combination of workflow and scripts.  2) I am
figuring there are probably Java libraries that can check the signatures so
you could write a Java plugin.

Jason

On Wed, Mar 11, 2015 at 1:45 PM, Reiser, John J 
wrote:

> **
>  Hello Listers,
> We have a new process to try to support.
> I need to either receive and authenticate a digitally signed email or a
> digitally signed PDF.
> Receiving email and capturing incoming attachments is straight forward but
> I was asked to find a way to verify that the email or the document was
> digitally signed.
> Has anyone done this or can you point me in the general direction of some
> help.
>
> Thank you,
> ---
> John J. Reiser
> Building 760-J202
> Remedy Developer/Administrator
> Senior Software Development Analyst
> Lockheed Martin - MST 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: "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: Incident template with tasks - no tasks?

[Jason Miller]

How much more time do you want me to spend on this?   :)   I think I have
spend enough time on it today.



You know me too well.  Here is a quick look at a few other product families.

ProductDelivered Requested   Percent Delivered  Server
Automation

12 600 2%  Network Automation

15 168 9%  FootPrints Service Core

99 1575 6%  Remedyforce

166 862 19%  Track-It

33 497 7%  Cloud Lifecycle Mgmt

7 92 8%  Ttl Delivered  Ttl Requested   Ttl Percentage
Delivered  332 3794 9%
Jason


On Wed, Mar 18, 2015 at 2:32 PM, LJ LongWing  wrote:

> **
> Jason,
> What if you compare the other product sets?there are a few out there
> touting that they listen to ideas and implement them...like Remedy Force,
> or Footprints?
>
> On Wed, Mar 18, 2015 at 3:17 PM, Jason Miller 
> wrote:
>
>> **
>> Ok, so I did some investigating and a little number crunching.  Below is
>> the breakout of Ideas Delivered / Requested per Idea grouping.
>>
>> Idea Grouping Delivered   Requested   Percent
>> Delivered
>> AR System
>> 
>> 4   352 1%
>> ITSM General
>> 
>>  3   305 1%
>> Asset Management
>> 
>> 0   49 0%
>> Change and Release
>> 
>> 2   145 1%
>> CMDB
>> 
>>  1   111 1%
>> Dashboards and Analytics
>> 
>>  0   26 0%
>> Incident and Problem
>> 
>> 6   90 7%
>> Knowledge Management
>> 
>>  2   82 2%
>> Service Level Management
>> 
>>  0   13 0%
>> Service Request Management
>> 
>>  3   127 2%
>> ADDM
>> 
>>  46   451 10%
>> Atrium SSO
>> 
>>  0   6 0%
>>Ttl Delivered  Ttl Requested Ttl Percentage
>> Delivered67   1757 4%
>>
>> T

SRM Product Orderinig Feature

[Veronica Soriano]

Has anyone implemented the SRM Product Ordering Feature.  I prototyped this 
feature and it looks promising for one of my customer's requirements.  Just 
want to see if there are any issues I should be aware of.  Thank you.

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

Re: Incident template with tasks - no tasks?

[LJ LongWing]

Jason,
What if you compare the other product sets?there are a few out there
touting that they listen to ideas and implement them...like Remedy Force,
or Footprints?

On Wed, Mar 18, 2015 at 3:17 PM, Jason Miller 
wrote:

> **
> Ok, so I did some investigating and a little number crunching.  Below is
> the breakout of Ideas Delivered / Requested per Idea grouping.
>
> Idea Grouping Delivered   Requested   Percent
> Delivered
> AR System
> 
> 4   352 1%
> ITSM General
> 
>  3   305 1%
> Asset Management
> 
> 0   49 0%
> Change and Release
> 
> 2   145 1%
> CMDB
> 
>  1   111 1%
> Dashboards and Analytics
> 
>  0   26 0%
> Incident and Problem
> 
> 6   90 7%
> Knowledge Management
> 
>  2   82 2%
> Service Level Management
> 
>  0   13 0%
> Service Request Management
> 
>  3   127 2%
> ADDM
> 
>  46   451 10%
> Atrium SSO
> 
>  0   6 0%
>Ttl Delivered  Ttl Requested Ttl Percentage
> Delivered67   1757 4%
>
> That is *4%* of the requests being delivered.  And that is including ADDM
> which I left in to show some contrast with the Remedy products.  If I
> remove ADDM it is *2%*.  Admittedly those numbers also include
> duplicates, Ideas that should have been a Discussion type of document, etc.
> But I think there is a pretty clear picture even with those variances.   (I
> bet there might be some BMCers saying right now "I told you so!!!  If we
> become more transparent and let our customers see RFEs it will bite us in
> the butt."  #OldWaysDieHard)
>
> Jason
>
>
> On Wed, Mar 18, 2015 at 1:50 PM, Jason Miller 
> wrote:
>
>> I have seen a small handful of the Ideas implemented.  Not nearly what
>> the Community and customer expect.
>>
>> Jason
>>
>> On Thu, Mar 12, 2015 at 5:49 AM, Martinez, Marcelo A 
>> wrote:
>>
>>> **
>>>
>>> Thank you guys… I suppose it just made sense in my head to have this.
>>>
>>> I haven’t used PD very much  -just to do some basic FTP. I struggled to
>>> find documentation on it. –I may end up doing it thru workflow.
>>>
>>>
>>>
>>> Speaking of ideas.. have you seen any of your “ideas” added into
>>> ARS/ITSM?
>>>
>>>
>>>
>>> Thx,
>>>
>>> Marcelo
>>>
>>>
>>>
>>> *From:* Action Request System discussion list(ARSList) [mailto:
>>> arslist@ARSLIST.ORG] *On Behalf Of *Dmitry Baryshnikov
>>> *Sent:* Thursday, March 12, 2015 1:59 AM
>>> *To:* arslist@ARSLIST.ORG
>>> *Subject:* Re: Incident template with tasks - no tasks?
>>>
>>>
>>>
>>> **
>>>
>>> Jason is right: now you can attach the task templates only to the
>>> changes.
>>>
>>> Is there an option to use the Process Designer? You could try to develop
>>> a process that would create the tasks after the

Re: Incident template with tasks - no tasks?

[Jason Miller]

Ok, so I did some investigating and a little number crunching.  Below is
the breakout of Ideas Delivered / Requested per Idea grouping.

Idea Grouping Delivered   Requested   Percent
Delivered
AR System

4   352 1%
ITSM General

 3   305 1%
Asset Management

0   49 0%
Change and Release

2   145 1%
CMDB

 1   111 1%
Dashboards and Analytics

 0   26 0%
Incident and Problem

6   90 7%
Knowledge Management

 2   82 2%
Service Level Management

 0   13 0%
Service Request Management

 3   127 2%
ADDM

 46   451 10%
Atrium SSO

 0   6 0%
   Ttl Delivered  Ttl Requested Ttl Percentage Delivered
  67   1757 4%

That is *4%* of the requests being delivered.  And that is including ADDM
which I left in to show some contrast with the Remedy products.  If I
remove ADDM it is *2%*.  Admittedly those numbers also include duplicates,
Ideas that should have been a Discussion type of document, etc. But I think
there is a pretty clear picture even with those variances.   (I bet there
might be some BMCers saying right now "I told you so!!!  If we become more
transparent and let our customers see RFEs it will bite us in the butt."
 #OldWaysDieHard)

Jason


On Wed, Mar 18, 2015 at 1:50 PM, Jason Miller 
wrote:

> I have seen a small handful of the Ideas implemented.  Not nearly what the
> Community and customer expect.
>
> Jason
>
> On Thu, Mar 12, 2015 at 5:49 AM, Martinez, Marcelo A 
> wrote:
>
>> **
>>
>> Thank you guys… I suppose it just made sense in my head to have this.
>>
>> I haven’t used PD very much  -just to do some basic FTP. I struggled to
>> find documentation on it. –I may end up doing it thru workflow.
>>
>>
>>
>> Speaking of ideas.. have you seen any of your “ideas” added into ARS/ITSM?
>>
>>
>>
>> Thx,
>>
>> Marcelo
>>
>>
>>
>> *From:* Action Request System discussion list(ARSList) [mailto:
>> arslist@ARSLIST.ORG] *On Behalf Of *Dmitry Baryshnikov
>> *Sent:* Thursday, March 12, 2015 1:59 AM
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* Re: Incident template with tasks - no tasks?
>>
>>
>>
>> **
>>
>> Jason is right: now you can attach the task templates only to the changes.
>>
>> Is there an option to use the Process Designer? You could try to develop
>> a process that would create the tasks after the Incident had been created.
>>
>> Regards,
>> Dmitry Baryshnikov
>>
>> On Mar 12, 2015 9:23 AM, "Jason Miller"  wrote:
>>
>> **
>>
>> It doesn't look like it is an option for incidents (so your not missing
>> anything). There is an Idea (RFE) to add it here:
>> https://communities.bmc.com/ideas/7438
>> 

Re: REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

[Pamela Morales]

Let me try...

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

Re: Incident template with tasks - no tasks?

[Jason Miller]

I have seen a small handful of the Ideas implemented.  Not nearly what the
Community and customer expect.

Jason

On Thu, Mar 12, 2015 at 5:49 AM, Martinez, Marcelo A 
wrote:

> **
>
> Thank you guys… I suppose it just made sense in my head to have this.
>
> I haven’t used PD very much  -just to do some basic FTP. I struggled to
> find documentation on it. –I may end up doing it thru workflow.
>
>
>
> Speaking of ideas.. have you seen any of your “ideas” added into ARS/ITSM?
>
>
>
> Thx,
>
> Marcelo
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Dmitry Baryshnikov
> *Sent:* Thursday, March 12, 2015 1:59 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Incident template with tasks - no tasks?
>
>
>
> **
>
> Jason is right: now you can attach the task templates only to the changes.
>
> Is there an option to use the Process Designer? You could try to develop a
> process that would create the tasks after the Incident had been created.
>
> Regards,
> Dmitry Baryshnikov
>
> On Mar 12, 2015 9:23 AM, "Jason Miller"  wrote:
>
> **
>
> It doesn't look like it is an option for incidents (so your not missing
> anything). There is an Idea (RFE) to add it here:
> https://communities.bmc.com/ideas/7438
> 
>
> Jason
>
> **
>
> Hello List,
>
>
>
> I’m trying to create an incident template that includes about 3 tasks. –
> or maybe a task group template (don’t know if this is necessary).
> Ultimately this incident template will be consumed by the “Rule Base Email
> Engine” to create an incident from an email. The issue I have is that my
> incident template does not have a tab for tasks… huh? Shouldn’t it have a
> tab for tasks??
>
>
>
> Ideally I would of liked for the RBE to create 3 incidents from one email.
> But I have not found a way to do that w/o customizing. Or… if the email
> could create an SRM request that was tied to a PDT that created 3
> incidents.. would be perfect. J
>
>
>
>
>
> ARS/ITSM 8.1.01
>
>
>
> Thanks,
> Marcelo
>
>
>
>
>
>
>
> _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_
>  _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: REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

[Lippincott, Levi (OMA-GIS)]

So if it was me I would do the following.

Existing Field Examples
hour1
hour2
hour3
minute1
minute2
minute3

Next the number of extra fields I would create would change based on my need 
and how complex my comparison qualification will need to be.

Assuming you need to compare all 6 fields I would probably create 6 new fields 
like the below examples.
cmp_hour1
cmp_hour2
cmp_hour3
cmp_minute1
cmp_minute2
cmp_minute3

Then I would have 2 basic escalations, although the # could go up the more 
complex your comparison will be.

The first I would have it set to fire at whatever interval or time you want it 
to be fired at with set action for the respective cmp_hour# & cmp_minute# 
fields using the HOUR($TIMESTAMP$) & MINUTE($TIMESTAMP$) functions.

Then the 2nd escalation would be the actual action that needs to be taken and 
the run if qualification would do the field comparisons.

Something sort of like this: ('cmp_hour1' >= 'hour1') AND ('cmp_hour2' < 
'hour2') AND ('cmp_minute1' >= 'minute1') AND ('cmp_minute2' < 'minute2')

I hope that makes sense.

Levi Lippincott / Remedy Administrator

+1 402 561 7014 office
+1 402 321 5421 mobile
levi.lippinc...@interpublic.com

Interpublic Group  6825 Pine Street, Omaha, NE 68106

"Talent is a Gift; But Character is a Choice." -Matt Grotewold-

-Original Message-
From: Pamela Morales [mailto:pmora...@grupocontext.com] 
Sent: Wednesday, March 18, 2015 3:34 PM
To: arslist@ARSLIST.ORG; Lippincott, Levi (OMA-GIS)
Subject: Re: REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

Yes, they are setted manually and I need compare to time stamp

This message contains information which may be confidential and privileged. 
Unless you are the intended recipient (or authorized to receive this message 
for the intended recipient), you may not use, copy, disseminate or disclose to 
anyone the message or any information contained in the message.  If you have 
received the message in error, please advise the sender by reply e-mail, and 
delete the message.  Thank you very much.


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

Re: REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

[Pamela Morales]

Yes, they are setted manually and I need compare to time stamp

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

Re: REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

[Lippincott, Levi (OMA-GIS)]

So are those values set manually and that is what you need to compare the 
current time stamp to or do you want to set those to workflow too?

Levi Lippincott / Remedy Administrator

+1 402 561 7014 office
+1 402 321 5421 mobile
levi.lippinc...@interpublic.com

Interpublic Group  6825 Pine Street, Omaha, NE 68106

"Talent is a Gift; But Character is a Choice." -Matt Grotewold-

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Pamela Morales
Sent: Wednesday, March 18, 2015 3:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

Yes, Now I do like that.

Hour1:  3  Minute1: 15
Hour2:  15  Minute1: 30
Hour3:  18  Minute1: 59


Before, I had

Hora1: 03:15:00
Hour2: 15:30:00
Hour3: 18:59:00

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers 
Are, and have been for 20 years"
This message contains information which may be confidential and privileged. 
Unless you are the intended recipient (or authorized to receive this message 
for the intended recipient), you may not use, copy, disseminate or disclose to 
anyone the message or any information contained in the message.  If you have 
received the message in error, please advise the sender by reply e-mail, and 
delete the message.  Thank you very much.


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

Re: REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

[Pamela Morales]

Yes, Now I do like that.

Hour1:  3  Minute1: 15
Hour2:  15  Minute1: 30
Hour3:  18  Minute1: 59


Before, I had

Hora1: 03:15:00
Hour2: 15:30:00
Hour3: 18:59:00

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

Re: REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

[Lippincott, Levi (OMA-GIS)]

When you say three numeric fields for 3 hours and three numeric fields for 3 
minutes do you mean you have 6 fields total used to store values like the 
following?

Hour 1: 3
Hour 2: 6
Hour 3: 9
Minute 1:   15
Minute 2:   30
Minute 3:   45


Levi Lippincott / Remedy Administrator

+1 402 561 7014 office
+1 402 321 5421 mobile
levi.lippinc...@interpublic.com

Interpublic Group  6825 Pine Street, Omaha, NE 68106

"Talent is a Gift; But Character is a Choice." -Matt Grotewold-

-Original Message-
From: Pamela Morales [mailto:pmora...@grupocontext.com] 
Sent: Wednesday, March 18, 2015 3:20 PM
To: arslist@ARSLIST.ORG; Lippincott, Levi (OMA-GIS)
Subject: Re: REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

Hi,

Originally,  I had a form with three time fields. I need to save those on the 
form becasuse with an escalation I compare those fields to $TIME$, and if this 
qualification is true, the escalation push fields on 
CHG:ChangeInterface_Create. The only part that is not working is the 
comparision between the time fields and $TIME$ because I need to execute only 
once per time, and it is executed more than once because it is taking seconds.

Now, I'm trying to do the same form with three numeric fields for 3 hours and 
three numeric fields for 3 minutes. I need to save those on the form becasuse 
with an escalation I compare those hours and minute, and execute the action. I 
guess it could work and compare once.

So??What should I do??

Regards

Pamela

This message contains information which may be confidential and privileged. 
Unless you are the intended recipient (or authorized to receive this message 
for the intended recipient), you may not use, copy, disseminate or disclose to 
anyone the message or any information contained in the message.  If you have 
received the message in error, please advise the sender by reply e-mail, and 
delete the message.  Thank you very much.


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

Re: REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

[Pamela Morales]

Hi,

Originally,  I had a form with three time fields. I need to save those on the 
form becasuse with an escalation I compare those fields to $TIME$, and if this 
qualification is true, the escalation push fields on 
CHG:ChangeInterface_Create. The only part that is not working is the 
comparision between the time fields and $TIME$ because I need to execute only 
once per time, and it is executed more than once because it is taking seconds.

Now, I'm trying to do the same form with three numeric fields for 3 hours and 
three numeric fields for 3 minutes. I need to save those on the form becasuse 
with an escalation I compare those hours and minute, and execute the action. I 
guess it could work and compare once.

So??What should I do??

Regards

Pamela

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

Re: REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

[Lippincott, Levi (OMA-GIS)]

Pamela,

My solution is probably way dumber than some of the responses you are going to 
get. :)

Not knowing anything else about your environment I would set a temp hour and 
minute field using these functions HOUR($TIMESTAMP$) & MINUTE($TIMESTAMP$) and 
then I would have another escalation whose qualification meets your needs 
compare the numeric fields to those.

If the comparison doesn't work because it is a string to integer then you would 
need another 2 temp fields for the first escalation and would set those fields 
using a string command like UPPER() with the numeric value fields in them to 
convert them to a string.

Levi Lippincott / Remedy Administrator

+1 402 561 7014 office
+1 402 321 5421 mobile
levi.lippinc...@interpublic.com

Interpublic Group  6825 Pine Street, Omaha, NE 68106

"Talent is a Gift; But Character is a Choice." -Matt Grotewold-

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Pamela Morales
Sent: Wednesday, March 18, 2015 2:47 PM
To: arslist@ARSLIST.ORG
Subject: REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

Hi everyone,

I need use in an escalation the hour and the minute from $TIME$ or $TIMESTAMP$ 
to compare with a numeric field which has the hour and otherone has the minute 
to execute an action.

I need asap to resolve a customer's case 

Thanks

Pamela

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers 
Are, and have been for 20 years"
This message contains information which may be confidential and privileged. 
Unless you are the intended recipient (or authorized to receive this message 
for the intended recipient), you may not use, copy, disseminate or disclose to 
anyone the message or any information contained in the message.  If you have 
received the message in error, please advise the sender by reply e-mail, and 
delete the message.  Thank you very much.


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

REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

[Pamela Morales]

Hi everyone,

I need use in an escalation the hour and the minute from $TIME$ or $TIMESTAMP$ 
to compare with a numeric field which has the hour and otherone has the minute 
to execute an action.

I need asap to resolve a customer's case 

Thanks

Pamela

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

Re: Requirements Doc

[Tami Palacky]

thank you!

On Tuesday, March 17, 2015 at 4:44:03 PM UTC-4, Lucero, Michelle wrote:
>
> ** 
>  
> Hi, Tami, et al::
>
>  
>
> The sample zoo requirements doc also exists in the 8.1.00 online 
> documentation.  Search for this *EXACT* text inside these quotation 
> marks,  “An example BMC Remedy AR System application”.
>
>  
>
> Thanks to  LJ for originating this topic – as I was trying to find ideas 
> for some new developers as well.
>
>  
>
> I’d be interested in any other mini-requirements docs as well.
>
>  
>
> Michelle
>
>  
>  
> *From:* Action Request System discussion list(ARSList) [mailto:
> ars...@arslist.org ] *On Behalf Of *Tami Palacky
> *Sent:* Tuesday, March 17, 2015 11:15 AM
> *To:* ars...@arslist.org 
> *Subject:* Re: Requirements Doc
>  
>  
>
> ** 
>  
> Ben, I would be interested in seeing the document if you dont mind 
> sharing.  Thank You
>
> On Friday, March 6, 2015 at 12:31:39 PM UTC-5, Ben Cantatore wrote:
>
> ** LJ, 
>
> I'm not sure if this is something you're looking for, but I currently have 
> an enhancement request from one of my users to modify the email function 
> (located under function on left side navigation panel) in tickets to allow 
> for canned messages.  Many teams that are fulfilling requests have messages 
> to send formatted in a specific way with a specific message and want to 
> send during the setup/completion of the requests. 
>
> So the idea would be to create a form where the various teams can 
> add/modify their canned messages and then have it selectable from a menu on 
> the email dialog box. 
>
> In this example, your junior develop would have to create a form, menu, 
> active links and buttons.  I think I recall you have a custom environment 
> so add dialog box and maybe tack on the actual email function if you want 
> to ramp up the difficulty level.
>
>
>
>
> [image: Image removed by sender.]
> *Ben Cantatore* 
> *Remedy Product Manager* 
> Bed Bath & Beyond 
> 650 Liberty Avenue 
> Union NJ 07083-8130 
> Office: (908) 613-5769 
> Cell: (914) 263-6802 
>
> [image: Image removed by sender. LinkedIn] 
> 
>
>
>
> From:LJ LongWing  
> To:ars...@arslist.org, 
> Date:03/06/2015 09:58 AM 
> Subject:Requirements Doc 
> Sent by:"Action Request System discussion list(ARSList)" <
> ars...@arslist.org> 
>  --
>  
>
>
>
> ** 
> All, 
> I'm training up a newbie on Remedy Development, and we have reached the 
> point where I think he's ready for a 'test'I remember going through my 
> 7.x RAC class, and they gave us a small 'requirements doc' for a fairly 
> simple, yet complex enough application that needed to be built...the guys 
> that were in the class with me all built different applications of course, 
> but they all met the application...it was a good exercise and helped hone 
> the blade so to speak on all of our skills...I was wondering if anyone 
> happened to have something like that laying around that I would be able to 
> use 
>
> It doesn't need to be related to any particular industry, etc...just a 
> couple of pages of requirements for an app that requires a few forms, and 
> some description of functionality, but of course, not how the functionality 
> needs to be built 
>
> If anyone is willing to send me some stuff, either on or offline, I would 
> appreciate it. 
> _ARSlist: "Where the Answers Are" and have been for 20 years_ 
>
> "-- CONFIDENTIALITY 
> NOTICE: This e-mail, and any attachments thereto, is intended only for use 
> by the addressee(s) named herein and may contain confidential information. 
> If you are not the intended recipient of this e-mail, you are hereby 
> notified that any dissemination, distribution or copying of this e-mail, 
> and any attachments thereto, is strictly prohibited. If you have received 
> this e-mail in error, please permanently delete the original and any copy 
> of any e-mail and any printout thereof. Thank you for your compliance."
>
>   ­­   _ARSlist: "Where the Answers Are" and have been for 20 years_
>  
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>  --
> This message, and any attachments, is for the intended recipient(s) only, 
> may contain information that is privileged, confidential and/or proprietary 
> and subject to important terms and conditions available at 
> http://www.bankofamerica.com/emaildisclaimer. If you are not the intended 
> recipient, please delete this message.
>  _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 find SQL query while querying a vendor form

[Walters, Mark]

As LJ points out, if the AR server was issuing the SQL it would be inside the 
API call.  However, this is a vendor form backed by an ARDBC plugin, and it is 
this that is doing the actual data fetching.  You’ll need to see what debug 
options are available for the plugin or, failing that, at the remote database 
end itself.

Mark

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: 18 March 2015 16:19
To: arslist@ARSLIST.ORG
Subject: Re: How to find SQL query while querying a vendor form

**
Saurabh,
If it was there, I would expect it to be between these two lines

/* Wed /Mar 18 2015 07:28:08.4525 */+GLEWFARDBCGetListEntryWithFields – vendor 
CROOM.ARDBC.POSTGRE table ORB:asset_display
/* Wed Mar 18 2015 07:28:08.8188 */-GLEWF FAIL/

but it's not there...you can try changing the logging level from whatever it is 
right now to Debug, restart the plugins, and try again to see if CROOM put 
debug statements into the log so you can see that sort of databut I don't 
know if it was done or not.

On Wed, Mar 18, 2015 at 9:45 AM, MalviyaSaurabh 
mailto:malviya.saurab...@gmail.com>> wrote:
i All,

An active link is defined on a display-only form, its set field action is
querying a vendor form using the EXTERNAL operator. From the extract of the
below plugin log I can see its failing when tryin to query ORB:asset_display
form. I am getting an error like shown below:

/Database error: could not receive data from server: Error 0 while trying to
execute SQL statement: SELECT CAST("element_id" as varchar(15)) as PriKey,
A."asset_hostname" as COL0, A."asset_labelname" as COL1,
A."asset_operation_status" as COL2, A."asset_s (ARERR 10502)/

I would like to know about the full SQL query which is queried at the
external database. Can anybody point out from which log I might be able to
fetch our this full query ?? Enabling SQL log is not helping me.

ARDBCGetEntry – vendor CROOM.ARDBC.POSTGRE table ORB:project_display entry
512991
 /* Wed Mar 18 2015 07:28:07.9915 */-GE OK
 /* Wed Mar 18 2015 07:28:07.9921 */+CT ARDBCCommitTransaction –
vendor CROOM.ARDBC.POSTGRE
 /* Wed Mar 18 2015 07:28:07.9927 */-CT OK
 /* Wed /Mar 18 2015 07:28:08.4525 */+GLEWF
ARDBCGetListEntryWithFields – vendor CROOM.ARDBC.POSTGRE table
ORB:asset_display
 /* Wed Mar 18 2015 07:28:08.8188 */-GLEWF FAIL/
 /* Wed Mar 18 2015 07:28:08.8199 */+RT ARDBCRollbackTransaction –
vendor CROOM.ARDBC.POSTGRE
 /* Wed Mar 18 2015 07:28:08.8556 */-RT FAIL


Regards,
Saurabh



--
View this message in context: 
http://ars-action-request-system.1.n7.nabble.com/How-to-find-SQL-query-while-querying-a-vendor-form-tp121104.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

___
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_
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.

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

Re: How to find SQL query while querying a vendor form

[LJ LongWing]

Saurabh,
If it was there, I would expect it to be between these two lines

/* Wed /Mar 18 2015 07:28:08.4525 */+GLEWFARDBCGetListEntryWithFields –
vendor CROOM.ARDBC.POSTGRE table ORB:asset_display
/* Wed Mar 18 2015 07:28:08.8188 */-GLEWF FAIL/

but it's not there...you can try changing the logging level from whatever
it is right now to Debug, restart the plugins, and try again to see if
CROOM put debug statements into the log so you can see that sort of
databut I don't know if it was done or not.

On Wed, Mar 18, 2015 at 9:45 AM, MalviyaSaurabh  wrote:

> i All,
>
> An active link is defined on a display-only form, its set field action is
> querying a vendor form using the EXTERNAL operator. From the extract of the
> below plugin log I can see its failing when tryin to query
> ORB:asset_display
> form. I am getting an error like shown below:
>
> /Database error: could not receive data from server: Error 0 while trying
> to
> execute SQL statement: SELECT CAST("element_id" as varchar(15)) as PriKey,
> A."asset_hostname" as COL0, A."asset_labelname" as COL1,
> A."asset_operation_status" as COL2, A."asset_s (ARERR 10502)/
>
> I would like to know about the full SQL query which is queried at the
> external database. Can anybody point out from which log I might be able to
> fetch our this full query ?? Enabling SQL log is not helping me.
>
> ARDBCGetEntry – vendor CROOM.ARDBC.POSTGRE table ORB:project_display entry
> 512991
>  390695> /* Wed Mar 18 2015 07:28:07.9915 */-GE OK
>  390695> /* Wed Mar 18 2015 07:28:07.9921 */+CT ARDBCCommitTransaction –
> vendor CROOM.ARDBC.POSTGRE
>  390695> /* Wed Mar 18 2015 07:28:07.9927 */-CT OK
>  390695> /* Wed /Mar 18 2015 07:28:08.4525 */+GLEWF
> ARDBCGetListEntryWithFields – vendor CROOM.ARDBC.POSTGRE table
> ORB:asset_display
>  390695> /* Wed Mar 18 2015 07:28:08.8188 */-GLEWF FAIL/
>  390695> /* Wed Mar 18 2015 07:28:08.8199 */+RT ARDBCRollbackTransaction –
> vendor CROOM.ARDBC.POSTGRE
>  390695> /* Wed Mar 18 2015 07:28:08.8556 */-RT FAIL
>
>
> Regards,
> Saurabh
>
>
>
> --
> View this message in context:
> http://ars-action-request-system.1.n7.nabble.com/How-to-find-SQL-query-while-querying-a-vendor-form-tp121104.html
> Sent from the ARS (Action Request System) mailing list archive at
> Nabble.com.
>
>
> ___
> 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"

How to find SQL query while querying a vendor form

[MalviyaSaurabh]

i All,
 
An active link is defined on a display-only form, its set field action is
querying a vendor form using the EXTERNAL operator. From the extract of the
below plugin log I can see its failing when tryin to query ORB:asset_display
form. I am getting an error like shown below:

/Database error: could not receive data from server: Error 0 while trying to
execute SQL statement: SELECT CAST("element_id" as varchar(15)) as PriKey,
A."asset_hostname" as COL0, A."asset_labelname" as COL1,
A."asset_operation_status" as COL2, A."asset_s (ARERR 10502)/
 
I would like to know about the full SQL query which is queried at the
external database. Can anybody point out from which log I might be able to
fetch our this full query ?? Enabling SQL log is not helping me.
 
ARDBCGetEntry – vendor CROOM.ARDBC.POSTGRE table ORB:project_display entry
512991
 /* Wed Mar 18 2015 07:28:07.9915 */-GE OK
 /* Wed Mar 18 2015 07:28:07.9921 */+CT ARDBCCommitTransaction –
vendor CROOM.ARDBC.POSTGRE
 /* Wed Mar 18 2015 07:28:07.9927 */-CT OK
 /* Wed /Mar 18 2015 07:28:08.4525 */+GLEWF
ARDBCGetListEntryWithFields – vendor CROOM.ARDBC.POSTGRE table
ORB:asset_display
 /* Wed Mar 18 2015 07:28:08.8188 */-GLEWF FAIL/
 /* Wed Mar 18 2015 07:28:08.8199 */+RT ARDBCRollbackTransaction –
vendor CROOM.ARDBC.POSTGRE
 /* Wed Mar 18 2015 07:28:08.8556 */-RT FAIL


Regards,
Saurabh



--
View this message in context: 
http://ars-action-request-system.1.n7.nabble.com/How-to-find-SQL-query-while-querying-a-vendor-form-tp121104.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

How to configure TLS 1.1 or 1.2 transport protocol on outgoing web-service calls from ARSystem

[Terry Bootsma]

 

Hello ARSListers: 

This is a very specific technical question, so if anyone can help or has
had experience configuring this, I would definitely appreciate any
response. 

We are using Remedy 8.1.01 on Linux with the following java version: 

java version "1.7.0_09-icedtea"
OpenJDK Runtime Environment (rhel-2.3.4.1.el6_3-x86_64)
OpenJDK 64-Bit Server VM (build 23.2-b09, mixed mode) 

We are consuming web-services on another server via the standard
ARSystem Java plugin. The problem is that our security requirements
dictate that we need to use TLS 1.1 or 1.2, not TLS 1.0. We have defined
that the standard java plugin server have the following attributes
defined as part of the plugin startup (in armonitor.conf).. 

 -Ddeployment.security.SSLv2Hello=false
-Ddeployment.security.SSLv3=false -Ddeployment.security.TLSv1=false
-Ddeployment.security.TLSv1.1=true -Ddeployment.security.TLSv1.2=true 

..however, when analyzing the network traffic, we still see TLS 1.0
being used and negotiated from outbound web-service calls from the
web-service java plugin. 

Anyone out there have any experience with this ? 

Thx. 

Terry 

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

Re: Reporting question

[Arner, Todd]

Have you looked at using the My Reports menu on the mid-tier?  Basically you 
would create your advanced query with parameters on the form you want to report 
against, run the query, select all from the search results, click the Report 
button, select the report that you already created, run the report, close the 
report, click the My Reports menu, select Save, and name it.  From here forward 
when you want to run the report click on the My reports menu, Run and select 
the report you just saved. It will prompt for the parameters and run the 
report.   It’s kind of goofy to set up the first time but my get you what you 
need.  Hope that’s helpful.

Thanks,
Todd Arner
Great Lakes

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Warren R. Baltimore II
Sent: Tuesday, March 17, 2015 4:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Reporting question

**
Thanks all!  I was aware of the pre built using the advanced query bar.  This 
customer wanted them built directly into the report, and unless it's a crystal 
or Birt report, that isn't going to happen.

a well..

On Tue, Mar 17, 2015 at 2:03 PM, Patrick Zandi 
mailto:remedy...@gmail.com>> wrote:
**
I was looking for that.. myself..

On Tue, Mar 17, 2015 at 2:00 PM, Frank Caruso 
mailto:caruso.fr...@gmail.com>> wrote:
Not sure if this helps but you can create Advanced searches which do prompt for 
parameters. In the advanced bar you can type the following:

'Submit Date' >= $Enter Start Date$ and 'Submit Date' <= $End Date$

When you run this a dialog box will appear asking for the dates. After the 
query is run you can then save the Search. The next time you run it the 
parameter dialog will appear.

HTH

Frank Caruso

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


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



--
Warren R. Baltimore II
Remedy Developer
410-533-5367
_ARSlist: "Where the Answers Are" and have been for 20 years_

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