Re: determining schema name using driver.exe...

[Kulkarni, Vikrant]

Hi,

Asking a silly question but are you trying to run sql via driver.exe?

Thanks,
Vikrant

Sent from my Xperia™ smartphone

Rick Phillips  wrote:



** Hi, everyone,

I'm using the 8.1 driver.exe, and wondering if it's possible to determine a 
schemaname from a given schemaid.

I've tried select * from arschema where schemaid=382 (and variations of the 
same), but no success.  What does this statement look like in glsql?

Thanks,

Rick
_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: Getting my development feet wet...

[Kulkarni, Vikrant]

I would go with best practice mode. I treat any development as customization 
hence best practice mode and be upgrade safe.

Sent from my Xperia™ smartphone

Lisa Singh  wrote:


I just did the Administrator Foundation stuff so you'd think this
would be clearer but I'm still not sure...

I want to get my developer feet wet by writing a simple application
that support team leaders can use to request new support staff
accounts.

I realise I could easily do this and automate the whole process with a
service request but this is mostly an excuse to get some practice in
Remedy development.

I'm not going to make it a deployable application because I want
access to all the user records that are in ITSM since a large number
of requests are people already have non-support user records.

So, do I start in Base Development or Best Practice Mode? I guess the
actual underlying question is do upgrades leave new applications with
base fields alone since there's no OOTB settings that could possibly
overwrite them?

Kind Regards,

Lisa

___
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: Is it just me or is BMC Developer Studio full of bugs?

[Kulkarni, Vikrant]

We have seen this in our dev environment few weeks back but it was for custom 
fields on any kinda form. Everything worked fine the fields are in place till 
we restart the server. Once restarted the custom fields are gone and we cannot 
create new ones with same id. It seems the field id is used up.

We didn't raise a bmc ticket as we thought some of our magic developer had done 
some weird trick on the server we just got it re imaged.

But there was no import in the picture for us. Might just be a generic server 
overlay error condition.

Thanks,
Vikrant

Sent from my Xperia™ smartphone

"Longwing, Lj"  wrote:



**
Joe,
Just out of curiosity, are your 'server references' turned on?  If yes, have 
you tried turning them off and restarting the server and then try your 
scenarios?I ask because I have personally seen the references cause a whole 
heck of problems with dev studio...(but I keep them turned on anyway :)


On Thu, Jul 25, 2013 at 2:54 PM, Joel Sender 
mailto:jdsen...@earthlink.net>> wrote:
I have an open issue with BMC Support regarding forms definitions imported by 
DevStudio.
On two separate servers, importing a custom form works until the AR server is 
rebooted.
After that the form is listed in DevStudio until an attempt to open it, which 
fails with 'form no found', then it is no longer listed.
Attempting to import the form, with or without, overwrite fails with a 
violation of a unique index.

Running 'checkdb' reveals a high number of errors.
BMC said they have seen this behavior before, but are treating this case as if 
it was their first encounter.

Since these are new servers running ARS 8.1, and the only activity has been to 
import the custom applications and data, without any ITSM modules, my feeling 
is that the DevStudio import is the source of the problem.

I'm told BMC support is attempting to recreate the problem ...

Joel
Joel Senderjdsen...@earthlink.net
310.829.5552

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, 
Frederick W
Sent: Thursday, July 25, 2013 11:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: Is it just me or is BMC Developer Studio full of bugs?

Just running it on a local laptop, connected to the ARS servers over VPN, is 
slow to do some tasks (like right clicking and waiting for the menu to open)

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Lisa Singh
Sent: Thursday, July 25, 2013 12:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: Is it just me or is BMC Developer Studio full of bugs?

-Original Message-
On 7/25/13, Tauf Chowdhury  wrote:
> Lisa,
> Can you expand on this? Are you saying that for on demand, you connect
> to a dedicated server running Dev studio and the WUT? Is that server
> on prem or in the BMC cloud?
>

BMC Cloud - customers who use a dedicated VPN can run DevStudio locally 
apparently, but it doesn't work with the bog standard cisco client. You have 
connect to the BMC VPN, then remote desktop to a BMC "jump" server and from 
there to the BMC tools server which is on the same subnet as the various Remedy 
servers.

DevStudio runs okay-ish well when no one else is on the tols box but a couple 
few users and it grinds to a halt...it's not a way to develop for the 
impatient...



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

_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: Approval list parsing issue?

[Kulkarni, Vikrant]

hi Doug,

Yes I agree with you about the incorrect syntax or the miss formatted input to 
the approval process. We have set in the check that you have suggested to 
replace ";;" with ";" in the approver list just some time back. 

But on further analysis of our issue we found out few more things and one more 
such case.

We found out that the approval notification was not sent to everyone in the org 
(about 100K people) but was sent to about 82K of them the reason or at least 
the possible reason I found was that all the 82K people had '0' in there login 
ID. Does it have any significance? still to find out...

Second thing was that we got one more such case today late in the evening where 
the approver list passed on the SRM:Request form was 

Next Approvers (13005) =;175558;;175558;;175558;;175558;;175558;;175558;

which was parsed by the approval server into

Expanding roles for approver(s): 175558;8;75558

Looking at this the theory of replacing '0' for ";;" in the code does not fit 
right as I had initially thought about. May be some issue with the parsing 
logic.

We have raised a BMC ticket as well for this let's see if we can get something 
out of it. Again the approval process is working fine seems like something to 
do with parsing.

Also apologies to mention late about the environment details

ARS 7.6.04 ITSM 7.6.04 SRM 7.6.04 SQL 2008 Remote Database and everything is 
SP4 on windows.

Thanks,
Vikrant

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug
Sent: Wednesday, July 24, 2013 10:17 PM
To: arslist@ARSLIST.ORG
Subject: Re: Approval list parsing issue?

Vikrant,

So, what we have here is an error condition and a question about error handling.

The error condition is a misformatted input -- extra semicolon separators.

The problem really is that there is no error handling for this condition.  The 
approval process is parsing the string, finds an empty definition, and just 
converts the value it finds into an integer and continues.  And, the integer 
conversion logic converts anything non-numeric into a 0 (blank, letters, 
whatever is there if it is non-numeric).

OK, but then, the issue is that a value of 0 has a very special meaning of 
Public which is all users


So, what is really needed here for this case -- or other cases of misformatting 
like 3344;a;3433 which would produce the same problem as after processing that 
would be 3344;0;3433 -- is better handling of the problem of a value of 0.

Realistically, you could argue that there is never a condition where sending a 
notification to Public is a good idea.  I agree with that position myself.  
Even if there was some corner case where every single registered user of the 
product somehow needed to be involved in an approval, I would argue that you 
should have a group that everyone is a member of and not use Public which is 
uncontrolled and unconstrained.


For now, you can put in logic that checks for the condition you encountered and 
eliminate double separators.  A set fields using REPLACE('field', ";;", ";") 
and assigned back to the field would do the trick.

I also suggest submitting a bug report (I am going to share the condition 
internally as well, but bug reports from customers always carry more weight) 
that Public should simply not be allowed as a target for an approval and any 
attempt to specify Public as an approver should be ignored.


The approval server and processing is working correctly.  The issue is that we 
really should not allow Public to be an approval target at any time as it is 
not deterministic and not a reliable or safe target.

Doug Mueller

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Vikrant
Sent: Tuesday, July 23, 2013 11:33 PM
To: arslist@ARSLIST.ORG
Subject: Approval list parsing issue?

hi Everyone,

   Yesterday we came across a strange issue with the SRM approval 
processing. The case is such that we are creating approver list on the 
SRM:Request form. From there we have written an approval rule which attaches 
the approval process to the request and sends out approval requests to the 
entire approver list on the SRM:Request form.

The string works about 99% of times(till yesterday evening 100%) but yesterday 
evening we found out an issue with it. What happened is that due to data 
inconsistency the approver list that got generated on the SRM:Request form was 
like 

Next Approvers (13005) = ;175540;;175540;;175540;;175540;;175540;;175540;

instead of Next Approvers (13005) = ;175540;175540;175540;175540;175540;175540;

Now this string was picked up by the approval process and somehow parsed into 
the below string

Expanding roles for approver(s): 175540;0;75540

The 0 in the approver string set out an approval email to each and every 
individual of the organization for approval (even  the CEO :( scary).

So my question s

Re: Web services

[Kulkarni, Vikrant]

Can you kindly elaborate on the issue you facing? Any errors or unexpected 
behavior?

This will help us understand you problem better.

Sent from my Xperia™ smartphone

Deepali Nigade  wrote:


hi all,

I have created and Published Web service, but unable to consume them.I have 
created a filter to consume but stuck with wsdl file. please guide on the same.

___
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: Is it just me or is BMC Developer Studio full of bugs?

[Kulkarni, Vikrant]

That's spot on what we just observe.

Sent from my Xperia™ smartphone

Brent Goodman  wrote:



**
Increase the memory heap being used reduces the frequency. I am using 7.6.04 
patch 4 and this solved the problem for the most part, but does still occur 
when dev studio has been running for a few days and opening/closing object 
lists.

Your guaranteed to get this same error shortly after doing a log out and then 
back into a different server session.

Seems to be memory management issue going on.

Making it a habit of only loading one server per instance, and always using its 
dedicated workspace for us has eliminated corrupt workspaces, and the null 
pointer errors.


Sent from my iPhone

On 2013-07-20, at 9:21 AM, Angus Comber 
mailto:arsl...@iteloffice.com>> wrote:

**
I am running Developer Studio v7.6.04 SP3 and frequently have to restart studio 
because I get:

Problem Occurred

Save Failed

javqa.lang.NullPointerException

I can't seem to work out a pattern.  It happens a lot on creating run process 
active links.

Is there a patch to fix this or is it just part of life as a Remedy developer?

_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: Is it just me or is BMC Developer Studio full of bugs?

[Kulkarni, Vikrant]

Can you check the jvm heap size for your dev studio. Can try and increase the 
max to 1024 mb and min to 512 mb. This has reduced the number of restarts for 
me significantly specially if I work with multiple server in a single instance 
of the studio.

Sent from my Xperia™ smartphone

Angus Comber  wrote:



**
I am running Developer Studio v7.6.04 SP3 and frequently have to restart studio 
because I get:

Problem Occurred

Save Failed

javqa.lang.NullPointerException

I can't seem to work out a pattern.  It happens a lot on creating run process 
active links.

Is there a patch to fix this or is it just part of life as a Remedy developer?

_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: SRM Approval

[Kulkarni, Vikrant]

Hi,

What I have done in one such requirements was

1. Create a new custom form which holds information of the Approval group for 
particular CTI's for which I need approval to be triggered.

2. Next is we got the CTI for which the request is raised on the SRM:Request 
form.

3. Then we created a join of the SRM:Request form and the custom form we 
created above. The join criteria is CTI.

4. Next we created rule for SRM level approval. The rule uses the join form 
created above in the set fields tab and on matching Request Number 
qualification I would set next approver from the join form with level as 
required.

5. The last thing remains is to adjust correct approval order. What we have 
done is the new rule that re have written takes precedence over the OOTB rule 
that looks for possible approval in the approval mapping form.

These steps got the custom approval running in the system which are CTI based 
and can be either group level or individual level.

Hope this helps.

Thanks,
Vikrant

Sent from my Xperia™ smartphone apologies if the formatting gets messed up 
still half asleep I am.

Łukasz Krzaczkowski  wrote:



**
Hi,

Please map interesting answer (e.g. system type) to one of "SR Type Field" 
parameters. Then use this parameter in approval chain qualification.

Regards
Lukasz


2013/7/19 Mohamed Abdelaziz 
mailto:moe.abdela...@gmail.com>>
**
Hello

I was wondering if anyone ever done customized approval process to SRM in which 
the requester answers a field and the approval process kicks in.

The scenario is as follow: Requester selects windows system from a drop down, 
no approval is generated. However, when Linux or Unix, approval should be 
generated.

I created a custom approval process with few rules as Get Authority, Prep Get 
and Get Next, but it doesn't seem to be working as needed. How can I not attach 
the approval to those requests that the user indicated a Windows System?

SRM 7.6.04

Any thoughts will be appreciated

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



--
Łukasz Krzaczkowski

[http://www.linkedin.com/img/webpromo/btn_viewmy_160x25.png]
_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: WWRUG/ARSlist Awards 2013: Nominations for MVP etc. and New Categories now open

[Kulkarni, Vikrant]

Same is with me. I guess you should see more votes than the nominations.

Sent from my Xperia™ smartphone

Julie Sellers  wrote:



**
I plan to vote cause all my nominees are already nominated (or ineligible).



From: Jason Miller 
To: arslist@ARSLIST.ORG
Sent: Monday, July 15, 2013 5:36 PM
Subject: Re: WWRUG/ARSlist Awards 2013: Nominations for MVP etc. and New 
Categories now open

** I don't know LJ.  With only 23 people playing it almost seems like the whole 
thing should be scrapped.  Dan may have been right; the awards are not 
providing the value they once did and people are too busy or don't care about 
this tradition anymore?

Although I think I remember seeing and talking to more the 23 people who said 
they would play this year if the awards were kept alive.  Maybe there will be a 
flood of actual votes?

On Mon, Jul 15, 2013 at 7:51 AM, LJ LongWing 
mailto:lj.longw...@gmail.com>> wrote:
**
Ok folks, we are 1 week from voting beginning on the ARSList awards.  For 
nomination, thus far we have had 23 participants nominating 9 MVP's and 6 BMC 
Above and Beyond.  I personally consider this awesome to have so many people to 
choose from for a nomination perspective, but am disappointed in the number of 
participants.

Please remember that your effort as a participant is in recognition of another 
person's effort to help you.

All nominations must go to 
arslistawa...@wwrug.com, and should include a 
sentence or two describing why they deserve the nomination.

This will likely be my last email on this subject, with the next one listing 
your nominees for voting.  Thank you to those of you that have already 
participated.



On Wed, Jul 10, 2013 at 9:47 AM, LJ LongWing 
mailto:lj.longw...@gmail.com>> wrote:
1 Week in and we now have a total of 15 people participating in the nomination 
process.  We are up to 5 MVP and 4 BMCers which I think is the highest numbers 
I have ever seen thus far, but I'm truly still disappointed that only 15 people 
have taken the minute or two that it takes out of your day to look back at your 
postings, see who has helped you the most, and nominate them.

I have spent more time thus far this year asking you to nominate than a vast 
majority of the list can bother to spend nominating.  Come on folks, you can do 
it.


On Mon, Jul 8, 2013 at 3:55 PM, LJ LongWing 
mailto:lj.longw...@gmail.com>> wrote:
Ok folksI remember an outcry last year, after the awards when people were 
saying that they would vote, how important this list was to them, just give you 
one more chancewhere is that passion?  To date, we have a total of 9 people 
that even sent an email...that's not much

We have 3 valid MVP nominees, and 2 BMC Above and Beyond

I know that I see more than 3 non bmc and 2 bmcers posting to the list in the 
last year.  There have been ALLOT of questions asked, and MANY people that have 
helped out.

If you have been helped by someone on this list, and you feel they deserve to 
be recognized, lets do this and recognize them.  There can be only one winner 
(in each category), but as a twice nominated person, I can tell you that it was 
an honor to even be nominated the first time...so lets get to this and nominate 
some of your favorite people on the list this year.

Remember, nominations need to be accompanied by a paragraph (or a sentence 
even) saying WHY they deserve the honor of MVP.


On Wed, Jul 3, 2013 at 7:09 AM, LJ LongWing 
mailto:lj.longw...@gmail.com>> wrote:
Daniel has chosen to do things a bit differently this year.  He has decided to 
let the incumbent MVP, that's me this year, run the Awards.

This is the 18th Annual ARSlist Awards, Call For Nominations.

These awards were created by Daniel in 1995 to recognize the efforts of posters 
asking questions, those providing answers, and sometimes even of those 
providing what is titled as Friday Humor, and even sometimes gets a laugh.

It was also to provide posters an incentive to keep providing those excellent 
technical replies and perhaps improve the quality of the jokes (but that 
doesn't seem to ever happen).

The Rules for Nominations and some General Rules:

* An individual wishing to submit a nomination for MVP must also provide a 
short description of WHY they deserve to be MVP for the nomination to be 
considered (this is a change from previous years requiring two independent 
nominations)
* The years postings are somewhat reviewed to ensure that this is someone who 
posts quality answers. ( Not that anyone has ever been rejected on this basis)
* Only those that have registered on the ARSlist before July 3rd 2013 will be 
eligible to vote.  It is assumed you won't vote if you haven't been around long 
enough to know the posters in question.  In the unlikely event of another tie, 
the person or product with the greatest number of sources of votes will be 
declared winner.  If it is still a tie, a panel of past winners will convene to 

Re: Archive Incident Management& Change Management 7.1

[Kulkarni, Vikrant]

Well use tools like RRR to delete data via remedy. I have deleted similar sized 
data. In less than 3 weeks.

Sent from my Xperia™ smartphone

mahmoud mahdy  wrote:



**
I contacted WIPRO whom support BMC Remedy, and they told me that deleting from 
DB level is better as it is a huge data and the system may not be able to 
complete.


Date: Mon, 15 Jul 2013 04:19:48 -0500
From: vkulka...@columnit.com
Subject: Re: Archive Incident Management& Change Management 7.1
To: arslist@ARSLIST.ORG

**

Delete from remedy as far as possible.

Sent from my Xperia™ smartphone

mahmoud mahdy  wrote:



**
Dears,
I'd like to delete the history and keep only the last two years.
so, is it better to delete form remedy forms or DB..?
Thanks


Date: Mon, 15 Jul 2013 14:41:23 +0530
From: kiranpatil@gmail.com
Subject: Re: Archive Incident Management& Change Management 7.1
To: arslist@ARSLIST.ORG

**
Hi Mahmoud,

You can achieve remedy archiving using some of the external tools like rrchive, 
Informatica, BMC DSO

1. First find out business timeframe and condition for data archieving.
2. Identify main forms and related forms to archieve.

Use any of the above tool or similar tool to migrate data.

Challenge here would be data integritiy which should be impacted.

Good Luck !!

Regards
Kiran






On Mon, Jul 15, 2013 at 2:22 PM, mahmoud mahdy 
mailto:mahmoud_ma...@live.com>> wrote:
**
Dears,

Kindly help as we have (500 GB database file) which affecting our performance 
and causing system down.
is there a way to truncate the history data from the system or DB..?.

Thanks,
Best Regards,

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



--
Regards

Kiran Patil
Cognizant Technology Solutions
Pune, India
Mob No: +91 989 037 7125

_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: Archive Incident Management& Change Management 7.1

[Kulkarni, Vikrant]

Delete from remedy as far as possible.

Sent from my Xperia™ smartphone

mahmoud mahdy  wrote:



**
Dears,
I'd like to delete the history and keep only the last two years.
so, is it better to delete form remedy forms or DB..?
Thanks


Date: Mon, 15 Jul 2013 14:41:23 +0530
From: kiranpatil@gmail.com
Subject: Re: Archive Incident Management& Change Management 7.1
To: arslist@ARSLIST.ORG

**
Hi Mahmoud,

You can achieve remedy archiving using some of the external tools like rrchive, 
Informatica, BMC DSO

1. First find out business timeframe and condition for data archieving.
2. Identify main forms and related forms to archieve.

Use any of the above tool or similar tool to migrate data.

Challenge here would be data integritiy which should be impacted.

Good Luck !!

Regards
Kiran






On Mon, Jul 15, 2013 at 2:22 PM, mahmoud mahdy 
mailto:mahmoud_ma...@live.com>> wrote:
**
Dears,

Kindly help as we have (500 GB database file) which affecting our performance 
and causing system down.
is there a way to truncate the history data from the system or DB..?.

Thanks,
Best Regards,

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



--
Regards

Kiran Patil
Cognizant Technology Solutions
Pune, India
Mob No: +91 989 037 7125

_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: performance issue

[Kulkarni, Vikrant]

I too have a good experience with the RRR tools. Very helpful in archiving data.

Vikrant

Sent from my Xperia™ smartphone

Misi Mladoniczky  wrote:


Hi,

If you are on the new (blue) license model, an extra AR Server does not cost
you anything from a license perspective.

I have used RRR|Chive successfully to keep tables synchronized between servers.

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

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

> Hi everyone,
>
> In addition to a reporting server, we have some 10 forms in
> a primary server with large volume of data. Adhoc AR Reports and searches are
> executed
> on the data nearly every day and this is causing some serious performance
> issues.
> Any thought on how to resolve this? We were thinking about
> moving the data to a different database (thorough replication or nightly
> database copy) but we need either an additional server (perhaps DSO) but this
> will need an extra license. Enabling archiving at the form level is another
> option but we will still have to use the primary server and additional
> configuration
> needs to be done at the queues and thread level as well and plenty of table
> indexing.
> Any pointer will be very much appreciated.
>
> BTW this is ARS7.1
>
> Thank you
> frex
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"

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

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

Re: Lost view in Database of T852

[Kulkarni, Vikrant]

You can use ar schema metadata form to find out which table has schema id you 
looking for.

Thanks,
Vikrant

Sent from my Xperia™ smartphone

Eamonn O'Riordan  wrote:


I seem to have lost a view in the database.

The error message I'm getting is

ARERR [552] Failure during SQL operation to the database : Could not use view 
or function 'T885' because of binding errors. (SQL Server 4413)Invalid object 
name 'T852'. (SQL Server 208)

This happened before about 5 years ago and the solution was to save the form 
again which rebuilt the view. Unfortunately, since 5 years ago, auditors have 
restricted the visibility of the database and I can't figure out which forms 
relate to T852 and T885. Anybody able to offer a suggestion? Thanks Eamonn

___
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: Archiving ITSM data

[Kulkarni, Vikrant]

hi,

Recently I have completed one of such project and here is what I followed.

1) Create a new archving server with same AR/ITSM/SRM/SLM version as you 
production. This server will hold your archived data for reporting purpose.
2) Classify the forms on you production system as Foundation forms and 
Transaction forms.
3) Set up DSO between your production server and your archiving server. It 
works well its been more than 4 months the customer has not faced any issue.
4) Set up real time DSO for all the foundation and transaction forms from 
production to arhiving server.
5) Use RRR|Chive (the best tool for data transfer) to move data between 
production to archiving server.
6) Once that is done. Think about data deletion policy what we have implemented 
is that foundation data will be residing on both the server all the time and 
will be synced real time but transaction forms data will be delete for records 
older than 13 months from production.
7) Again use RRR|Chive tool to delete records from production the advantage is 
that you can generate an arx file of the data deleted using this toll. Hence 
you will always have a back of what you deleted.

This is just about it in a nutshell. If you would like to have a discussion in 
detail will surely help you. The archiving does seems to be tricky process but 
once you set the process right its not that difficult.

Thanks,
Vikrant


From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On 
Behalf Of Shafqat Ayaz [shafq...@yahoo.com]
Sent: Tuesday, June 18, 2013 7:08 AM
To: arslist@ARSLIST.ORG
Subject: Archiving ITSM data

**
Hi All
I am looking at archiving ITSM data. Has anyone got any stratagies or can 
reccomend either some method or any apps that can be purchased.

Many thanks for your help in advance.


Shafqat Ayaz
_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: Problem in Migrating forms from 7.5 to 7.6.4

[Kulkarni, Vikrant]

Hi,

Did you check the overlays point of view. You are moving objects from a non 
overlay aware server to an overlay aware server.

You might need to refer to the migrator doc for this.

Thanks,
Vikrant

Sent from my Xperia™ smartphone

Vikram_Betholi  wrote:


Hi,

When i migrate the objects from 7.5 remedy server to 7.6.4, all the NEW FORMS 
and other Objects got migrated succeessfully.
But the problem is, modifications on the EXISTING FORMS are not migrated ( i.e. 
Any new Fields created or Any new Tabs added...etc). But still Migrator report 
says that everything has got imported successfully.
Can any one please let me know what can be the problem.

With Regards,
B.Vikram.

___
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: field length issue

[Kulkarni, Vikrant]

If you make the field length 0 would do the trick for you as Abhijeet suggested 
but there are issues with FTS and QBE search depending your ARS version. I 
guess there is a BMC ticket open for this. You may like to know about it. The 
ARS version 7.5 and 7604 have this issue (at least till SP2).

Thanks,
Vikrant

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Gadgil, Abhijeet
Sent: Thursday, April 11, 2013 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: field length issue

You could make it a 0 length field, essentially a clob that way. You will need 
to use like then on for this field in searches.



Raj  wrote:


Hi,
can we any mechanism to increase the length of a character field dynamically as 
the data in that field increases ?

Regards,
Rajkumar Padole.

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

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

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

Re: CMDB Driver

[Kulkarni, Vikrant]

It should not take that long. Did you check the pending form to check if there 
is some error.

Sent from my Xperia™ smartphone

Naoufal El Hilali  wrote:



**
Can I have an answer please ? Still waiting for the synchronization to end, I 
do not know how much time it will take. It has been almost 4 hours.

Thank you in advance.
Regards

Naoufal El Hilali


On Fri, Mar 1, 2013 at 11:03 AM, Naoufal El Hilali 
mailto:naoufalelhil...@gmail.com>> wrote:
Hello All,

I have created a new attribute in a class in CMDB but it showed as Change 
Pending, so I used the cmdbdriver to speed up the synchronization. I have done 
everything from init, log, ssp, to sync and supplied the pending ID. Now it has 
been almost an hour and I did not get any result, still synchronizing ?? How 
long does it take usually ?

[cid:ii_13d259ef9cee5262]

Regards

Naoufal El Hilali

_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: DSO and large number of records

[Kulkarni, Vikrant]

hi Abhijeet,

I am using DSO action in an escalation as I want to copy data to an archive 
server. And no not using private queue for DSO. 
If the escalation has more than 100K records to process via a DSO action I see 
the malloc error.

And by 1 go I mean without splitting data in smaller chunks by using run if 
qualifications.

Thanks,
Vikrant

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Gadgil, Abhijeet
Sent: Thursday, February 07, 2013 12:23 AM
To: arslist@ARSLIST.ORG
Subject: Re: DSO and large number of records

Are you moving these after an update (modify) is done on each record?
Also what do you mean by one go?
For filter based actions (like the ones on which DSO would trigger) events 
would really be transactions being executed on a queue.
Are you using private queue for DSO?

Abhijeet


On 07-Feb-2013, at 12:16 AM, "Vikrant"  wrote:

> hi List,
> 
> I would like to know what is the max number of records anyone of you have 
> tried to move via DSO at one go. I have about 3 million records in one form 
> and I need to move it using DSO. Even with 10 number of records I see the 
> malloc error on the server while the escalation tries to search for the 
> records that needs to be moved to pending form. 
> 
> The few config values that I can think of and have set as below:
> 
> 1) Max retrive in get list call = 5000
> 2) Max number of records for DSO to process = 5000
> 
> Is there anything else I need to check or do better?
> 
> How can i get rid of the Malloc failed error which I am guessing is due to 
> large number of records in the form.
> 
> We are on ARS 7.5 P4, ITSM 7.6 SRM 7.6 SLM 7.6 all on windows and SQL as 
> remote DB.
> 
> Any help is appreciated. 
> 
> Thanks,
> Vikrant
> 
> __
> _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> "Where the Answers Are, and have been for 20 years"

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

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

Re: Issues with Remedy Ebonding- Consuming AO process through Filter

[Kulkarni, Vikrant]

Why not use the DSO process for this?

Vikrant

Sent from my Xperia™ smartphone

Vivek Garg  wrote:


Hi,

We are trying to achieve remedy ebonding i.e. bidirectional incidents sync 
between 2 remedy systems.

We have created an AO(Atrium Ochestrator) process which we are trying to 
consume through set fields action in a filter.

Now we want the update/modifications to happen first on remedy 1 and then our 
filter should call AO process to make the same changes on 2nd remedy.If there 
is some issue with the AO like CDP is down or for any reason my AO process 
failed, then we do not want to loose changes made on remedy 1, we want to store 
these changes in a temporary table and with the help of an esclation we want to 
resend these changes again through our AO process once it's up.

Basically what I want to know is that how should I design such a workflow which 
ensures that AO process must be called after changes successfully gets stored 
on Remedy 1.
Please suggest some approach to implement this.

Thanks ,
VIvek

___
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: Slow system restart/arsystem errors after restarting the mid-tiers on 7.6.4

[Kulkarni, Vikrant]

Probably you might have checked but still is worth mentioning about a thread on 
the list regarding pre loading of MT. You might wanna give it a look

Sent from my Xperia™ smartphone

Howard Richter  wrote:



**
Happy Friday all,

We have been seeing a very strange error since our go-live with 7.6.4 (and 
working with no luck with BMC support), when we restart our mid-tiers. We are 
on windows server 2008 and using MSSQL 2008.

What we have seen is we will shut down our two customer facing arservers (as 
well as our integration arserver), as well as our three mid-tiers. Then we 
bring up our three arservers (integration first, then the two customer facing 
ones), with no issues. After testing them with auto creation of an incident via 
email (an integration we created) and some poking around using the old user 
tool, we bring up one of our mid-tiers (i.e. start up the tomcat engine). At 
that point, the arserver that the mid-tier starts to talk to, starts to show 
database time out errors and you can no longer log in via the user tool.

It takes about 30 minutes for the system (the arserver/mid-tier) to stabilize 
and then we are able to bring up the other two mid-tiers.

We have not seen this issue in our QA system (which is all on VM) and our 
staging system. They both have somewhat the same architecture and we have 
verified the mid-tier configuration/patch releases.

Since we are still working with BMC support (for over 3 months on this), I just 
wanted to see if anyone had seen this type of issue on other 7.6.4 systems.

Take care,

Howard
_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: Archiving Case Study....

[Kulkarni, Vikrant]

Seems like a good idea let me check on that.

Thanks,
Vikram

Sent from my Xperia™ smartphone

"Hullule, Kiran"  wrote:


Vikram,

If you have server group environment with multiple servers in group then you 
can have one dedicated server for DSO and Escalation Operation and configure 
that outside the load-balancer so that it will remained non-user facing server, 
this way you can even run DSO/Escalation during production hours (business 
hours) and accomplish what you require.

Best Regards,
Kiran H

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Vikram
Sent: Thursday, January 03, 2013 9:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: Archiving Case Study

LJ,

Yeah we also plan to do something similar but we need to let the system be free 
from the escalation at business hours. So may be we can break the data on a 
timeline and then run the escalation daily/weekly to migrate the data as well 
as delete it from the production in off business hours.

Thanks,
Vikram

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

___
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: Finding a Active Link ID

[Kulkarni, Vikrant]

You can also use ARinside tool to get your workflow documented. Then it becomes 
easy to find workflow with specific actions.

Thanks,
Vikram

Sent from my Xperia™ smartphone

Joe D'Souza  wrote:



**

SELECT name FROM actlink WHERE actlinkId IN (SELECT actlinkId FROM 
actlink_process WHERE command = ‘PERFORM-ACTION-ACTIVE-LINK 128 101767’);

Your query statement would have to look something like that when searching for 
the active links that contains that process action..

You may have to prefix the table name with dbo. If you are on MS-SQL depending 
on how you have it setup.. It may also be useful to use upper or lower function 
to make the search string case insensitive in case that action exists in more 
than one active link and if it is keyed in with different case each place..

Cheers

Joe


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Hugo Ruesga
Sent: Friday, December 14, 2012 12:58 PM
To: arslist@ARSLIST.ORG
Subject: Re: Finding a Active Link ID

Hi Mark;

Well actually, that qualification is built on the way, that seems that an AL 
Guide is building the qualification criteria for the option you selected from 
the Overview Panel. To be more specific and towards minimizing your search 
time; when you use All My Groups feature, qualification is build to retrieve 
all records, no matter the assignee, belonging your assigned gropus, and by all 
records I'm talking about all ITSM records you may be handling, unless you have 
modified the search parameters on the Options of the console.

So you're more likely to receive the list of Incidents, problems, changes and 
tasks assigned to all of your support groups configured for your people record.

And asking to your question about finding the AL, you'll need to use a friendly 
tool such as ARUtilities to find out the field 101767 and found the AL that 
performs action to that field, that will retrieve you the list of all AL 
related.

Happy Friday for you too.

Hugo Ruesga
Software Development Advisor
US  972.577.7000 x 332.3868
MX +52 (33) 3332.3868
P Please consider the environment before printing this email
The information contained in and transferred with this electronic message is 
intended only for the recipient(s) designated above, it is protected by law and 
it may contain information which is privileged and confidential. If you are not 
the intended recipient, please do not read, copy, or use it, and do not 
disclose it to others. Please notify the sender of the delivery error by 
replying to this message, and then delete it from your system. Thank you.



Date: Fri, 14 Dec 2012 12:50:35 -0500
From: mbritt...@navisite.com
Subject: Finding a Active Link ID
To: arslist@ARSLIST.ORG

**
Hi All & TGIF,

We are new to ITSM. One question that has come is what is search criteria when 
I select Assigned to All My Groups in the Incident Console? Let’s say I am in 
the IT Staff group. Are the results where the Assigned Group = IT Staff, the 
Owner Group i= IT Staff or both?

I tried to figure this out by running Active Link logging and thought I had it 
until I encountered PERFORM-ACTION-ACTIVE-LINK 128 101767

Is there an easy way to find the active link?

Thanks
Mark

Mark Brittain
Remedy Developer
ITILv3 Foundation
NaviSite – A Time Warner Cable Company
mbritt...@navisite.com
Office: 315-453-2912 x5335
Mobile: 315-882.5360



This e-mail is the property of NaviSite, Inc. It is intended only for the 
person or entity to which it is addressed and may contain information that is 
privileged, confidential, or otherwise protected from disclosure. Distribution 
or copying of this e-mail, or the information contained herein, to anyone other 
than the intended recipient is prohibited.
_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 archiving methods

[Kulkarni, Vikrant]

hi Vishal,

And to find the relationship between objects we can always enable object 
relationships on the test servers and find out the relations of each form. Once 
that's done we can use this list of forms for DSO mappings and data transfers.
Using a time ranged escalation you can delete the historic data from the forms 
found by the above method.

Thanks,
Vikrant

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Vishal Navale
Sent: Sunday, December 02, 2012 8:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy archiving methods

**
Thanks Vaibav.

Do you know how to delete the data from database? How to find out all 
relationships for IM/CM/PM/SRM/SLM etc

Data is huge and we want to delete from database.

Thanks
Vishal
On Thu, Nov 29, 2012 at 11:43 PM, vaibhav wadekar 
mailto:wadekar.vaib...@gmail.com>> wrote:
** DSO is one of the option I can suggest you for archiving data from main 
server.

Regards/Vaibhav

On Thu, Nov 29, 2012 at 12:01 PM, Vishal Navale 
mailto:vishal...@gmail.com>> wrote:
**
Hi,

We want to archieve Remedy data archive. Currently Remedy have 3 years of data 
so we want to keep only last 15 months data.

Setup is customized. ARS 7.5p4/ITSM 7.6/SQL2008

Please let me know best way to achive this?

Regards,
Vishal

_attend WWRUG12 www.wwrug.com ARSlist: "Where the 
Answers Are"_

_attend WWRUG12 www.wwrug.com ARSlist: "Where the 
Answers Are"_

_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 Support/EOL

[Kulkarni, Vikrant]

It would also depend if you want to leverage the new features introduced in the 
new version or if you don't want them in your system.
It is a tricky one..

-Vikrant 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rackley, James
Sent: Thursday, November 29, 2012 11:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMC Support/EOL

Anyone know what the EOL is for 7.6.03? It came up in a meeting yesterday and I 
had no answer.

v/r,
Jim

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC
Sent: Thursday, November 29, 2012 12:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMC Support/EOL

Matthew,
Going out of support can have many impacts.  Depending on what your corporate 
direction is, and the criticality of your system, your company may have a 
policy that you MUST be up to date on patches/versions of software if for no 
other reason than security.  They typically seem to want someone to escalate an 
issue to if a problem exists that is causing an outage.  Neither of these would 
be possible if you stay on your current version beyond the EOL.

Outside of that aspect of it, 7.5 was a stable version in general, and isn't 
prone to crashing on a regular basis, so if you drop out of support, then you 
aren't likely to have a system just dying on you regularily.

On a separate note though, BMC in the past has required you to basically 'pay 
back rent' when you stop support, and then re-start at a later date...so the 
general 'savings' don't end up materializing if that is the thought behind 
potentially dropping support.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Moellmer, Matthew
Sent: Thursday, November 29, 2012 10:01 AM
To: arslist@ARSLIST.ORG
Subject: BMC Support/EOL

** 

Hello all, 

 

I don't post a lot here but I do read a lot. Currently we are on version 7.5 
which is scheduled for end of life 2nd qtr. 2013 I think. While trying to get a 
project moving and get the system upgraded I have found that we may not be 
given/granted all of the tools we need to make the move successfully. With that 
being said, has anyone dealt with BMC and falling out of support completely? 
This is something I haven't had to deal with in the past and if it comes down 
to it I am just wondering if any other customers have had to deal with this and 
what to expect. I am already working with BMC on this, so I am just looking for 
an outside opinion from others that may have dealt with this. 

 

Matthew Moellmer

 

This e-mail transmission contains information that is confidential and may be 
privileged.
It is intended only for the addressee(s) named above. If you receive this 
e-mail in error, please do not read, copy or disseminate it in any manner.  If 
you are not the intended recipient, any disclosure, copying, distribution or 
use of the contents of this information is prohibited. Please reply to the 
message immediately by informing the sender that the message was misdirected. 
After replying, please erase it from your computer system. Your assistance in 
correcting this error is appreciated.

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ 

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

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

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

Re: several instances of AR System on the same box

[Kulkarni, Vikrant]

Also if I remember it correctly you need to either have only 1 server with port 
mapper or no server registered with port mapper to make sure you can connect to 
both the server concurrently. Correct me if I am wrong here guys.

Thanks,
Vikrant

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Hullule, Kiran
Sent: Friday, October 19, 2012 3:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: several instances of AR System on the same box

**
Then you are good, you can have 2 separate instances (one 7.5 and another 8.0) 
on same box using same database server but separate db instance (tablespace - 
e.g. ARSystem and ARsystem80)

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Remedy Maniac
Sent: Friday, October 19, 2012 1:28 PM
To: arslist@ARSLIST.ORG
Subject: Re: several instances of AR System on the same box

**
of course we will use a new license key when the real upgrade will come.

Presently my intention is only to evaluate the product and see what it looks 
like.
So my concern is really if i can safely install the AR System 8 (for evaluation 
purpose of max 30 days) on the same box than my current dev and licensed AR 
System 7.5 ? using 2 different databases on the same RDBMS server, namely 
Sybase 15. I've checked the Matrix for compatibility as well.




On 10/19/2012 9:53 AM, Hullule, Kiran wrote:

Yes you can do that with following consideration:



1) Hardware requirement for 8.0  ( Refer 8.0 Installing Guide - Before you 
install Topic)

2) Compatibility Matrix (OS / Database version-patch etc - refer 8.0 
compatibility matrix doc)

3) licensing requirement, you need to purge 7.5 license key and apply it for 
8.0 or else you need to buy new license key for 8.0





-Original Message-

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Remedy Maniac

Sent: Friday, October 19, 2012 1:14 PM

To: arslist@ARSLIST.ORG

Subject: several instances of AR System on the same box



hi list,



we are running AR Syste, 7.5 patch 7 on a Solaris 10 box with a Sybase 15.

We would like to upgrade at some point to 8. Quiet soon.

But by then we still need our 7.5 installation.

My understanding is that I could install the AR System 8 on the same box

using a new DB on the same Sybase server.

Can anybody confirm that please?

Is there any specifics  to pay attention to?

Are there any known issues with such config?



Best wishes before the ... sunny :-) here in South Germany ... week-end



Serouche



___

UNSUBSCRIBE or access ARSlist Archives at 
www.arslist.org

attend wwrug12 www.wwrug12.com ARSList: "Where the 
Answers Are"



___

UNSUBSCRIBE or access ARSlist Archives at 
www.arslist.org

attend wwrug12 www.wwrug12.com ARSList: "Where the 
Answers Are"

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers 
Are"_
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers 
Are"_

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

Re: Pending Start and End Time Fields

[Kulkarni, Vikrant]

This is just something we did a couple of days ago for one of our client.

What  you need is a back end form and 2 filters. Filter 1 will fire on status 
change to pending which marks the start of the pending state and makes an entry 
in the backend form. Now filter 2 will fire on status change from pending to 
anything else which marks the end of the pending state and updates the same 
entry with end time on the backend form. You can use the request id/incident id 
to the backend form to track the correct record to update on pending status 
closure.

Also the time difference on the backend form gives you the overall pending time 
info as well, even if it's in pending status multiple times as the incident 
Id/request id will be same for all the respective records.

Seems a bit too much if yes let me know can help you more on the same.

Thanks,
Vikrant

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Suresh Loganathan
Sent: Tuesday, October 09, 2012 8:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Pending Start and End Time Fields

**
Longwing,

Thanks for swift response. Some forms are capturing this info in OOB.
1. I need to discover Pending start and end time
or
2. Overall Pending time info

Regards,

Suresh Loganathan.
On Tue, Oct 9, 2012 at 8:31 PM, Longwing, LJ CTR MDA/IC 
mailto:lj.longwing@mda.mil>> wrote:
Suresh,
Based on discussions I have seen on this topic in the past, I don't think the 
information you are looking for is currently being captured, so it would be a 
customization to capture it.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Suresh 
Loganathan
Sent: Tuesday, October 09, 2012 8:41 AM
To: arslist@ARSLIST.ORG
Subject: Pending Start and End Time Fields

**
Team,

I need to discover the ticket (Pending Status) pending start time and pending 
end time info.Which form and field is capturing this info. Can you please 
kindly advice the same.

I am waiting for your speedy response.

Regards,

Suresh Loganathan
_attend WWRUG12 www.wwrug.com ARSlist: "Where the 
Answers Are"_

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

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers 
Are"_

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

Re: New Columns To Web Report Designer

[Kulkarni, Vikrant]

May we know the field type and length of the fields you trying to get on the 
report.

Frank Caruso  wrote:


That worked when creating a new report. But for existing reports the new field 
does not show up.

Any thoughts on how to get the field to show for existing reports?

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

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

Re: New Columns To Web Report Designer

[Kulkarni, Vikrant]

Also it won't show the diary fields and if I am not wrong fields with length 
more than 256 chars...(need to confirm the second part but first Iam very sure 
of.)

Thanks,
Vikrant

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk
Sent: Thursday, October 04, 2012 7:21 PM
To: arslist@ARSLIST.ORG
Subject: Re: New Columns To Web Report Designer

** I think( I might be wrong) the web report designer shows only the fields 
that are on the default view.
So you may have to bring the fields you want to default view and hide them.
I do not have a working ITSM instance with me to validate it.

On Thursday, October 4, 2012 6:28:40 AM UTC-7, Frank Caruso wrote:
ITSM 764 sp2

Does anybody know how to add new values to the Available Fields list on the new 
Web report designer form? We have a requirement to include the Help Desk field 
Support Group Organization as a field that can be used in Web reports.

Thank you.

Frank

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

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

Re: Fuzzy Midteir

[Kulkarni, Vikrant]

We had the same issue the field labels on one our homegrown incident form had 
just one text hence the form was useless for a while. We flushed the cache on 
MT, user browser cache and also restarted the tomcat and it did the trick for 
us... seems kind of a bug to me.

Thanks,
Vikrant

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury
Sent: Monday, October 01, 2012 8:04 AM
To: arslist@ARSLIST.ORG
Subject: Re: Fuzzy Midteir

**
To be honest, it doesn't look that bad to me from the pics you sent. I'm on an 
iPhone though.

Sent from my iPhone

On Sep 30, 2012, at 9:25 PM, "Benz, Michael" 
mailto:michael.b...@holcim.com>> wrote:
**
Hello World

I've noticed something very interesting (and slightly annoying)

We recently updated our Tomcat server to V7 with midteir 7.6.04 SP4 and with 
the new midteir, everything is "fuzzy" (note the attached screenshot)



Does anyone have any idea how to change this back so it looks crisp and clear 
like SP2?


Regards,

Michael Benz
Remedy Support

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers 
Are"_
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers 
Are"_

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

Re: Cannot login to mid-tier but CAN login using Windows user tool

[Kulkarni, Vikrant]

hi Angus,

have you configured the Authentication server correctly in the MT config page?

Thanks,
Vikram

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Angus Comber
Sent: Thursday, September 27, 2012 12:47 PM
To: arslist@ARSLIST.ORG
Subject: Cannot login to mid-tier but CAN login using Windows user tool

Hi

I have Remedy v7.5 mid-tier setup and I can login using the Windows user tool 
(thick client) with standard Demo account.  If I try to login to the mid-tier I 
go to

http://myserver:8080/arsys/shared/login.jsp and get the login page as expected. 
 But if I login using username Demo and leave password field and authentication 
fields blank then I get

ARERR [623]
Authentication failed

Is there some step I have missed?

Angus

p.s. I get exactly same error if I attempt to login with an unknown username, 
eg john. 

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

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

Re: Remedy Startup

[Kulkarni, Vikrant]

The only thing i can think to do is.. Keep the startup of your ar server 
service manual.. And only when you can login to your SQL Management studio with 
ARAdmin login you can start the service.. but off course it will be manual 
thing... which is not always recommended but still worth a try to pin point the 
issue if not already done.

Thanks,
Viki

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Thursday, June 14, 2012 7:14 AM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Startup

** If only google and other search engines were indexing the BMC knowledge 
base.  One would probably find that solution relatively quickly.

Axton Grams

On Wed, Jun 13, 2012 at 8:42 PM, Axton 
mailto:axton.gr...@gmail.com>> wrote:
Maybe this kb is more applicable: 
https://kb.bmc.com/infocenter/index?page=content&id=KA333064
A search of "remedy delay startup" hits that as number 1.

Axton Grams

On Wed, Jun 13, 2012 at 8:15 AM, Longwing, LJ CTR MDA/IC 
mailto:lj.longwing@mda.mil>> wrote:
If only it did.  That particular article is essentially useless to me.  It 
essentially says 'just set your dependencies and you should be good', but I 
have the dependencies set properly and I'm not goodthe issue that I'm 
specifically having is that one of their own products is incorrectly reporting 
as 'started' when it's not available (sql server).  The article goes on to say 
that if you need your service to start 'later' in the process, then to just 
make it dependent on spooler or messenger.  I have done that and STILL it 
doesn't start late enough in the process to allow SQL to actually become 
availableso no...that article doesn't give me everything I'm looking for 
unfortunately.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Avy Mann
Sent: Wednesday, June 13, 2012 7:09 AM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Startup

**
You want to delay the startup of the AR service.  Here is an article that 
should give you everything you are looking for:


http://support.microsoft.com/kb/193888



Enjoy!



From: "Longwing, LJ CTR MDA/IC" 
mailto:lj.longwing@mda.mil>>
To: arslist@ARSLIST.ORG
Sent: Wednesday, June 13, 2012 8:57:54 AM
Subject: Re: Remedy Startup


Andrew,
You are correctSQL Server is reporting itself as online, when it's not 
fully available, and this is screwing up Remedy because it's trying to connect 
to a DB that's not yet available.  I'm looking for a way to delay that startup

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew 
Fremont
Sent: Tuesday, June 12, 2012 3:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Startup

** It could be that the SQL service is not up yet by the time AR start.

It happened on one of our dev machines after rebooting where both AR and SQL 
are installed.

Andrew.

On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC 
mailto:lj.longwing@mda.mil>> wrote:


   Ok...my box is running Remedy and SQL Server both and on startup the Remedy 
service fails to start properly.  The arerror.log shows an error about ARAdmin 
login failing twice, then the process dies.  An immediate attempt to start the 
service functions fine.  Checking the SQL Logs I see something along the lines 
of

   12:00:00 Starting ARSystem
   12:00:01 Attempted login from ARAdmin failed
   12:00:02 Scanning ARSystem
   12:00:06 Recovery of ARSystem complete

   That's not a copy of the log (because I can't get that to the 
internet)...but that's close to what it saysthis is only happening on one 
of my boxes, and I suspect that it's a memory related issue because when I 
check a functional box, I see everything except the login failed line, but it 
all happens within a second of each other...and my remedy doesn't have any 
problems starting.  I have the Remedy service set to depend on the SQL service, 
but according to the internet (and my personal experience) the SQL Service 
reporting as 'up' does not mean that DB's are available.  MS recommends that if 
you need to 'delay' the startup of a particular service that you should set it 
dependent on 'Spooler'...I've done this but it doesn't help...I need another 
5-10 seconds delay with the attempted starting of Remedy serviceany 
recommendations?

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



_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers 
Are"_

___

Re: PROBLEM :Invoking 3rd party sms gateway URL via remedy and capturing the response.

[Kulkarni, Vikrant]

Thanks all, last night we were able to write a filter plug-in for the same. And 
it works fine..
Just a bit impatience on my side to post the issue too soon.

Regards,
Vikram

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Wednesday, May 09, 2012 6:23 AM
To: arslist@ARSLIST.ORG
Subject: Re: PROBLEM :Invoking 3rd party sms gateway URL via remedy and 
capturing the response.

** I try to keep things on the server side when I can.  Too many variables on 
the client side to dream of dealing with.  wget is another program you can use. 
 A filter plugin would not be hard to write.  I think it could be done in < 100 
lines of code.
On Tue, May 8, 2012 at 7:01 PM, Chuck 
mailto:cpg...@gmail.com>> wrote:
**
I agree call the URL from the AR Server.
View fields are inherently limited by whatever version of IE dll, ocx whatever.
I use perl's http libs to get data via urls.

Active Link -> Service Call -> Filter -> Set Fields Run Process (Blocking 
process) -> Perl


On Tuesday, May 8, 2012 4:22:16 AM UTC-5, Vikram wrote:
Hi,

I am in search of something I have not done before. We are trying to implement 
sms functionality for one of our customer. In short the requirement is such  
that we have a sms gateway URL which has destination number, and 2 text fields 
embedded into the URL.

Once when we hit the URL with this info we get a 3 digit code in response which 
tell us about the status of the sms i.e. Delivered, failed, pending etc. This 
code is what the customer needs to record for auditing purpose.

I am not sure how can we achieve this via Remedy workflow. Can any one help me 
with  this.

Thanks,
Vikram

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

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_

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

Re: PROBLEM :Invoking 3rd party sms gateway URL via remedy and capturing the response.

[Kulkarni, Vikrant]

Thx Misi,

One confusion still. I liked the idea of the view field but can I read the 
value back from that field as a http response?

Need to check it. Will update on this approach shortly.

Thanks
Vikram

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Tuesday, May 08, 2012 4:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: PROBLEM :Invoking 3rd party sms gateway URL via remedy and 
capturing the response.

Hi,

The best way would probably be to write a small filter-plugin that can do
the call from the server.

Or you might be able to write some small javascript-code for Mid-Tier that
does the call.

If you create a small View-field, and assign the URL to that field. The
returned value should be displayed.

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

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

> Hi,
>
> I am in search of something I have not done before. We are trying to
> implement sms functionality for one of our customer. In short the
> requirement is such  that we have a sms gateway URL which has destination
> number, and 2 text fields embedded into the URL.
>
> Once when we hit the URL with this info we get a 3 digit code in response
> which tell us about the status of the sms i.e. Delivered, failed, pending
> etc. This code is what the customer needs to record for auditing purpose.
>
> I am not sure how can we achieve this via Remedy workflow. Can any one
> help me with  this.
>
> Thanks,
> Vikram
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>

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

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