Re: CRITICAL - ARS Does not start

2011-10-04 Thread patchsk
Would you be able to send a screen shot of the error you are seeing when you access overview console? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers

Re: Help with Approval Change Request

2011-10-04 Thread patchsk
To my knowledge MAPI is a microsoft protocol which works in windows only. So you need to build a separate windows box just for to use for remedy incoming emails. ___ UNSUBSCRIBE or access ARSlist Archives at

Re: RRRChive

2011-10-04 Thread Walters, Mark
No doubt Misi will be along shortly with definitive information but in the meantime... Qualifications are pretty much what you would expect, for example - qual= '2' = Demo would select records where the Submitter (fieldID 2) is Demo. This one - qual= ('Group Role' =

ITSM Implementation team for the US required

2011-10-04 Thread Greg Park
Dear All I am currently looking for a 1x Technical Project Manager/Lead Consultant 1x ITSM Implementation consultant 1x Integration consultant For a long term ITSM implementation assignment in Dallas. There will be remote working available however the beginning of the assignment will

Re: RRRChive

2011-10-04 Thread Misi Mladoniczky
Hi Mark, Thank you for the input. You can also add parameters on the command line that completely overrides anything in the config: rrrchive --qual='2' = \Demo\ rrr.cfg (Note that this example is complicated, as it contains both spaces, single- and double-quotes that needs to be taken into

SLM 7.6.04 - different SVT Goal Times depending on Reported Time

2011-10-04 Thread Mario Roehr
Hi all, I have to achieve the following in SLM: When a Change Request / Incident is reported before 12:00 the SVT Goal Time shall be 18:00 same day. If the Change Request / Incident was reported after 12:00 the SVT Goal Time shall be 13:00 next business day. Any idea how to manage this without

Re: SQL Link Server Issue

2011-10-04 Thread Rodriguez, Rafael J x23718
Thanks LJ, I have tried this as well. I have decided to go with Web Services. Was able to get this done relatively quick with no issues. Rafael From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, October 03, 2011 10:52 AM To:

Bitmap indexes vs Regular indexes

2011-10-04 Thread Ron Tavares
Good Morning List, I am a Remedy guy, not a DB guy,.. so I am looking for some help from the DBAs on the List. Recently, our DBA ran a performance analysis of our Remedy DB and came back with 9 fields that are recommended for indexing. 3 of those fields are recommended to have bitmap indexes.

Re: CRITICAL - ARS Does not start

2011-10-04 Thread patrick zandi
go to the backup folder and look for the ar.conf, find the ldap section and replace.. Hope that helps.. when installing it does make a copy.. nice... On Mon, Oct 3, 2011 at 7:06 PM, Hyunkel v2.0 lord_dyna...@hotmail.comwrote: ** Now After running an installer with upgrade option service is up

Other CMDB products

2011-10-04 Thread Newbold, Paul (ISE)
All, Has anyone had any experience (good, bad, indifferent) of using other (Non-Remedy/BMC) CMDB products with ITSM? We did look at BMC's CMDB module, but it's cough/ cough/ too expensive. Is it even possible? Thanks, Regards, Paul. *CONFIDENTIALITY NOTICE* This electronic

Re: CRITICAL - ARS Does not start

2011-10-04 Thread Hyunkel v2.0
I've already checked that, even once the upgrade ended, I used the old ar.cfg file to start up the services, but just the same result. 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

Re: RRRChive

2011-10-04 Thread Elry
Gentlemen... Thank you for your responses. Misi - thanks for the more detailed email. We are now moving forward with testing. I must say that we are very pleased with the speed of the transactions and the ease of use of the Configurator. We have tried a number of command line utilities and

Re: When did someone login......

2011-10-04 Thread patchsk
Do some research and test it in dev before turning on this option in production. Early this year we turned on this option hoping to do some usage statistics. However it seems there is a bug in that feature, it completely hosed our remedy system and no body could login. BMC support suggested

Re: Other CMDB products

2011-10-04 Thread Jason Miller
Hi Paul, Just to clarify, you are talking about the BMC ITSM products? The CMDB is included if you have any of the ITSM products installed (Service Desk, Change Management, Asset Management). The CMDB is considered a core piece of all of these (and becoming even more with each release). If you

Re: Other CMDB products

2011-10-04 Thread Matt Laurenceau
Not sure I understand your comment. BMC Atrium CMDB comes for free with Remedy ITSM apps now (it's natively included in the same database). From an architecture point of view, Atrium CMDB often leverages data from other repositories: - Copy/Import from databases (what some vendors sometime

Re: Bitmap indexes vs Regular indexes

2011-10-04 Thread Guillaume Rheault
Hi Ron, My thoughts are these bitmap indexes should be created at the database level, so that Remedy is not aware of them, because all Remedy created indexes are standard (i.e. b-tree indexes). After these indexes are created, the DBA can profile the overall performance again, to see if the

Re: CRITICAL - ARS Does not start

2011-10-04 Thread Siddiqi, Wirasat (Contractor)
Do you guys do the database and Application server back up. You may want to consider restoring from the backup if it is in place. Thanks, Wirasat From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hyunkel v2.0 Sent: Tuesday, October 04, 2011 9:46 AM

Re: CRITICAL - ARS Does not start

2011-10-04 Thread Hyunkel v2.0
Restored the Application didn't work. 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

Re: Bitmap indexes vs Regular indexes

2011-10-04 Thread Rick Cook
Well, the immediate question is best answered by whether fast submits or fast searches are more important. That's a form-by-form argument, and you have to balance your users' needs and potential SLAs for performance in there as you see best. The longer-term question is about the viability of

Re: Bitmap indexes vs Regular indexes

2011-10-04 Thread Axton
Also keep in mind that certain form modifications will drop those indexes. If that happens you will need to recreate the indexes. It used to be that the alteration of the precision of a decimal field, or the modification of a currency field would trigger this. Not sure if this still holds true.

Drop Table AR0float

2011-10-04 Thread Joseph Kasell
Our environment - Application Server: MS Windows 2003 SP 1 ARS 7.0.01, patch 001 ITSM 6 CMDB 1.1, patch 4 Database Server: MS Windows 2003 SP 2 MS SQL 2005 Our Remedy service suddenly began to run very sluggishly with users reporting long wait times to bring up or to update a case, or to

Re: Drop Table AR0float

2011-10-04 Thread Rick Cook
I could comment on the drop table issue, but I think Misi or someone will probably be able to do so more intelligently than I, and I don't think that is causing your problem anyway. The thing that jumped out at me was your Entry IDs, which were in seven or eight non-zero digits (3 million+/18

Re: Bitmap indexes vs Regular indexes

2011-10-04 Thread Garrison, Sean (Norcross)
Is there a way to accomplish what he is asking for by configuring the ardb.conf file? I would think that the index could be maintained that way via Remedy. Just curious. Sean From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Tuesday,

Get Entry + Set Fields from another form's Set Fields operation

2011-10-04 Thread Brien Dieterle
ARS 7.5 P7 I have a form (formA) that sets a field on Get Entry. This works great when looking at records or running reports on FormA, even if the field is display only. Is there any reason why this filter wouldn't execute from another form (FormB) performing a Set Fields operation of its

Re: Bitmap indexes vs Regular indexes

2011-10-04 Thread Axton
Unfortunately, no. The ardb.conf takes values to append to the related DDL statement. The difference in the DDL to create an index, versus a bitmap index, does not fit this mold. For example: CREATE INDEX emp_bitmap_idx ON index_demo (gender); CREATE BITMAP INDEX emp_bitmap_idx ON index_demo

installing 7.1 on win7

2011-10-04 Thread Opela, Gary L CTR USAF ABW 72 ABW/SCOOA
I have 7.1 user and admin trying to install on windows7. I used to could set compatibility mode on the install file to run as vista sp2, but this stopped working. Any other ideas of what I can try? Thanks, Gary Opela, Jr. Remedy Engineer ITIL V3 Foundations Certified Avaya Phone

Re: installing 7.1 on win7

2011-10-04 Thread Rick Cook
Most of us use XP as the compatibility mode. More stable than Vista. Rick On Tue, Oct 4, 2011 at 11:30 AM, Opela, Gary L CTR USAF ABW 72 ABW/SCOOA gary.opela@tinker.af.mil wrote: ** I have 7.1 user and admin trying to install on windows7. I used to could set compatibility mode on the

Re: Get Entry + Set Fields from another form's Set Fields operation

2011-10-04 Thread Misi Mladoniczky
Hi, There are three types of operations that gets data I guess. 1. GetEntry in variouse ways, that triggers get-entry-fitlers 2. GetListEntryWithFields and some alternatives that do NOT trigger the get-entry-filters 3. Internal Filter Set Fields that do NOT trigger the get-entry-filters In you

Re: installing 7.1 on win7

2011-10-04 Thread Easter, David
Your other option is to install the 7.5.00 Remedy User client and use Developer Studio - both of which are supported on Windows 7 and are backwards compatible to working with an AR System 7.1.00 server. -David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The

Re: installing 7.1 on win7

2011-10-04 Thread Opela, Gary L CTR USAF ABW 72 ABW/SCOOA
@Rick: Thanks, I'll try xp. @David: I always knew the user tool was backwards compatible, I never did know that the admin tool would be. If xp won't work, then I'll have to use 7.5 Thanks! Thanks, Gary Opela, Jr. Remedy Engineer ITIL V3 Foundations Certified Avaya Phone Support CNI/IT Tinker

Re: Get Entry + Set Fields from another form's Set Fields operation

2011-10-04 Thread Ben Chernys
It is expected behaviour. A set fields filter action is NOT a get fields. So, to do what you want, you'll need to - do a GetFields and add the fields you need to your formB and to your push fields or - (better) add a condition on the get fields filter such as any of the fields you are

Re: installing 7.1 on win7

2011-10-04 Thread Dariusz Kuzara
Hello Garry, I've managed to install both Remedy User and Admin 7.1.0.1 on Windows 7 64bits. They both run without Windows XP compatibility mode. However I had to run both (User and Admin) installers in Windows XP (SP3) compatibility mode. The other option is running your tools under Win XP

SOLVED: CRITICAL - ARS Does not start

2011-10-04 Thread Hyunkel v2.0
Listers; We're back... And the solution was what I expected, the path for the Java version, but I wasn't aware on how Microsoft uses the ENV variables. For the record and as a knowledge for everyone. 1. Do not set up automatic JAVA (JDK or JRE) upgrades, be sure that they're turned of and

Re: Drop Table AR0float

2011-10-04 Thread Joe Martin D'Souza
I would check all the searches that happen through workflow (set field if and push field if conditions) and otherwise (table field qualifications on tables that load on window open when the home page is opened). I’ll lay a bet some of the searches on these are using fields that are not indexed

Re: Get Entry + Set Fields from another form's Set Fields operation

2011-10-04 Thread Brien Dieterle
Thank you both for the responses. I've always skipped over the service action docs thinking it was web services-- I'm trying the service action first since I don't want to have to modify any records or do any push fields operations, if I can avoid it. I can't get it to work so far, though.

Re: Get Entry + Set Fields from another form's Set Fields operation

2011-10-04 Thread Misi Mladoniczky
Hi, I have mostly used services without loading the request, but to be able to perform the normal filters of the get-entry, you would be required to pass the Request ID of FormA. In other words, you may need a Set-Fields prior to the Service-call to retrieve that Request ID. This should make

Re: Separation of DB and Application server

2011-10-04 Thread Joe Martin D'Souza
Good move.. Never host the DB Server on the same box as the Application Server... Apart from maintaining the same database name, database user name and password, all you need to do is point to the remote DB once you set it up on a remote machine by editing the ar.cfg file.. Obviously in

Re: Separation of DB and Application server

2011-10-04 Thread Joe Martin D'Souza
Ignore this email – I am not sure why I was reading this now and didn’t notice when it was posted before I replied to this.. Joe From: Joe Martin D'Souza Sent: Tuesday, October 04, 2011 5:06 PM To: arslist@ARSLIST.ORG Subject: Re: Separation of DB and Application server Good move.. Never

Re: Separation of DB and Application server

2011-10-04 Thread Pargeter, Christie :CO IS
Here are the steps I documented when we moved our DB from one SQL Cluster to a different SQL Cluster. Remedy v Shut down ARS Service v Copy ARSystem DB o Verify permissions / owner is ARAdmin password v Change Sybase_Server_Name in AR.CFG o Program Files\AR

Re: Separation of DB and Application server

2011-10-04 Thread patchsk
Also make sure your ars and db are with in same LAN and it is configured for full duplex. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are