Re: Re : Non clustered indices (ITSM 7.3)

[Frex Popo]

I stumbled across a fresh 7.3 installation and only 13 indices all together and 
same number at the database level ... so will be discussing this with the DBA 
over the morning coffee.
 
Thanks


--- En date de : Jeu 4.6.09, Lyle Taylor  a écrit :


De: Lyle Taylor 
Objet: Re: Re : Non clustered indices (ITSM 7.3)
À: arslist@ARSLIST.ORG
Date: Jeudi 4 Juin 2009, 21h16


** 





Is there an appropriate existing index that you could simply add the field to 
rather than creating a new one for this field?  That way, you don’t exceed the 
limit, and it may be more efficient for the DB as well.
 
Lyle
 

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Frex Popo
Sent: Thursday, June 04, 2009 12:39 PM
To: arslist@ARSLIST.ORG
Subject: Re : Non clustered indices (ITSM 7.3)
 
** 




Reason I am asking is that I think it's better to create the index through the 
Admin Client so that the server is aware of it rather than having to create the 
index at the DB level.. But if it comes to having to create it at the DB level 
I think I would opt for the latter since having an index is better than not 
having it at all :)

--- En date de : Jeu 4.6.09, Frex Popo  a écrit :

De: Frex Popo 
Objet: Non clustered indices (ITSM 7.3)
À: arslist@ARSLIST.ORG
Date: Jeudi 4 Juin 2009, 12h26






Hello everyone,

 

Found a number of join forms using a particular column in the join criteria. 
This column did not look it was indexed on the base form (i.e. HPD:Help Desk), 
so thought let's create one. When I tried to do so I got a SQL error: 

 


No se pudo crear índice no agrupado 'I1035_904003986_1' porque supera el máximo 
de 249 permitido por tabla o vista.  (SQL Server 1910) (ARERR 552). Failure 
during SQL operation to the database : 904003986 (ARWARN 552).

 

This simply means that the SQL server could not create the nonclustered index 
as it is beyond the maximum allowed. The form has 13 indexes. As a test I 
removed an existing non clustered index and create the new one and it works 
just fine, but of course I want to keep all the existing ones and be able to 
create the new one.

 

I checked the table definition in the SQL Enterprise client by running 
sp_helpindex and got a list of some 250 entries. Now, I don't have a non 
customised version of this form nor do I have another environment to check if 
this is all created by the remedy server, hence the question, does anyone have 
all these indices defined on the Help Desk form in their ITSM 7.0 installation?

I am using ARS 7.1 patch 4 / ITSM 7.3 / SQL server 2005.

 

Here is part of the 250 entries. 


index_name,index_description,index_keys
I1035_100019_1,nonclustered located on PRIMARY,C100019, C100018
I1035_100063_1,nonclustered located on PRIMARY,C100063, C100064, 
C100065
I1035_100079_1,nonclustered located on PRIMARY,C100079
I1035_100080_1,nonclustered located on PRIMARY,C100080
I1035_100161_1,nonclustered, unique located on PRIMARY,C100161
I1035_100427_1,nonclustered located on PRIMARY,C100427
I1035_100869_1,nonclustered located on PRIMARY,C100869
I1035_100875_1,nonclustered located on PRIMARY,C100875
I1035_179_1,nonclustered, unique located on PRIMARY,C179
I1035_20003_1,nonclustered located on PRIMARY,C20003, C20004, 
C20005
I1035_240001002_1,nonclustered located on PRIMARY,C240001002
I1035_4_1,nonclustered located on PRIMARY,C4
I1035_7_1,nonclustered located on PRIMARY,C7
missing_index_100016,nonclustered located on PRIMARY,C100079, C103009, 
C7
missing_index_100040,nonclustered located on PRIMARY,C100014, C100251, 
C100296, C100082, C100217
missing_index_100058,nonclustered located on PRIMARY,C100014, C100251, 
C100079, C100082, C100217
missing_index_100062,nonclustered located on PRIMARY,C100014, C100079, 
C100217, C100251, C100082
missing_index_100064,nonclustered located on PRIMARY,C100014, C100217, 
C100251, C100082
missing_index_100089,nonclustered located on PRIMARY,C100079, C7
.
.
.
.
missing_index_99846,nonclustered located on PRIMARY,C100099, C100251, C7
missing_index_99878,nonclustered located on PRIMARY,C100014, C100251, 
C100082
missing_index_99880,nonclustered located on PRIMARY,C100014, C100251, 
C100082, C100217
missing_index_99882,nonclustered located on PRIMARY,C100014, C100079, 
C100251, C100296, C100572, C100082, C100217
missing_index_99929,nonclustered located on PRIMARY,C7
PK__T1035__4032018A,clustered, unique, primary key located on PRIMARY,C1

Regards

frex

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_



NOTICE: This email message is for the sole use of the intended recipient(s) and 
may contain confidential and privileged information. Any unauthorized review, 
use, disclosure or distribution is prohibited. If you are 

Re: Re : Non clustered indices (ITSM 7.3)

[Frex Popo]

Thanks Rick, 
 
Yes I am aware of that ... having too many indices on a table requires space 
and resources to maintain these indeces to start with hence my question, so I 
can first find out what came initially with the helpdesk form and see what we 
have added through the Admin tool (none documented here yet) and what the DBAs 
without telling the rest, how many indices they have added and why without 
telling the rest. :-)
 
Anyway, I think I will be taking this up with the DBAs.
 
Have a good day
frex

--- En date de : Jeu 4.6.09, Rick Cook  a écrit :


De: Rick Cook 
Objet: Re: Re : Non clustered indices (ITSM 7.3)
À: arslist@ARSLIST.ORG
Date: Jeudi 4 Juin 2009, 20h49


Frex, that limit is there for a reason. Once you exceed about 8 indices, 
performance increasingly suffers, especially on submits. 

Rick


From: Frex Popo 
Date: Thu, 4 Jun 2009 18:39:20 +
To: 
Subject: Re : Non clustered indices (ITSM 7.3)

**



Reason I am asking is that I think it's better to create the index through the 
Admin Client so that the server is aware of it rather than having to create the 
index at the DB level.. But if it comes to having to create it at the DB level 
I think I would opt for the latter since having an index is better than not 
having it at all :)

--- En date de : Jeu 4.6.09, Frex Popo  a écrit :


De: Frex Popo 
Objet: Non clustered indices (ITSM 7.3)
À: arslist@ARSLIST.ORG
Date: Jeudi 4 Juin 2009, 12h26







Hello everyone,
 
Found a number of join forms using a particular column in the join criteria. 
This column did not look it was indexed on the base form (i.e. HPD:Help Desk), 
so thought let's create one. When I tried to do so I got a SQL error: 
 

No se pudo crear índice no agrupado 'I1035_904003986_1' porque supera el máximo 
de 249 permitido por tabla o vista.  (SQL Server 1910) (ARERR 552). Failure 
during SQL operation to the database : 904003986 (ARWARN 552).
 
This simply means that the SQL server could not create the nonclustered index 
as it is beyond the maximum allowed. The form has 13 indexes. As a test I 
removed an existing non clustered index and create the new one and it works 
just fine, but of course I want to keep all the existing ones and be able to 
create the new one.
 
I checked the table definition in the SQL Enterprise client by running 
sp_helpindex and got a list of some 250 entries. Now, I don't have a non 
customised version of this form nor do I have another environment to check if 
this is all created by the remedy server, hence the question, does anyone have 
all these indices defined on the Help Desk form in their ITSM 7.0 installation?

I am using ARS 7.1 patch 4 / ITSM 7.3 / SQL server 2005.
 
Here is part of the 250 entries. 

index_name,index_description,index_keys
I1035_100019_1,nonclustered located on PRIMARY,C100019, C100018
I1035_100063_1,nonclustered located on PRIMARY,C100063, C100064, 
C100065
I1035_100079_1,nonclustered located on PRIMARY,C100079
I1035_100080_1,nonclustered located on PRIMARY,C100080
I1035_100161_1,nonclustered, unique located on PRIMARY,C100161
I1035_100427_1,nonclustered located on PRIMARY,C100427
I1035_100869_1,nonclustered located on PRIMARY,C100869
I1035_100875_1,nonclustered located on PRIMARY,C100875
I1035_179_1,nonclustered, unique located on PRIMARY,C179
I1035_20003_1,nonclustered located on PRIMARY,C20003, C20004, 
C20005
I1035_240001002_1,nonclustered located on PRIMARY,C240001002
I1035_4_1,nonclustered located on PRIMARY,C4
I1035_7_1,nonclustered located on PRIMARY,C7
missing_index_100016,nonclustered located on PRIMARY,C100079, C103009, 
C7
missing_index_100040,nonclustered located on PRIMARY,C100014, C100251, 
C100296, C100082, C100217
missing_index_100058,nonclustered located on PRIMARY,C100014, C100251, 
C100079, C100082, C100217
missing_index_100062,nonclustered located on PRIMARY,C100014, C100079, 
C100217, C100251, C100082
missing_index_100064,nonclustered located on PRIMARY,C100014, C100217, 
C100251, C100082
missing_index_100089,nonclustered located on PRIMARY,C100079, C7
.
.
.
.
missing_index_99846,nonclustered located on PRIMARY,C100099, C100251, C7
missing_index_99878,nonclustered located on PRIMARY,C100014, C100251, 
C100082
missing_index_99880,nonclustered located on PRIMARY,C100014, C100251, 
C100082, C100217
missing_index_99882,nonclustered located on PRIMARY,C100014, C100079, 
C100251, C100296, C100572, C100082, C100217
missing_index_99929,nonclustered located on PRIMARY,C7
PK__T1035__4032018A,clustered, unique, primary key located on PRIMARY,C1

Regards
frex

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 




___
UNSUBSCRIBE or access ARSlist Archives at

Re: BMC RKM

[strauss]

What version are they running (of RKM)?

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing & IT Center
http://itsm.unt.edu/

> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Axton
> Sent: Thursday, June 04, 2009 10:50 PM
> To: arslist@ARSLIST.ORG
> Subject: BMC RKM
> 
> This should now be working as expected again.  It's always the little
> things that bite you.  Please continue to post to the list when you
> see that things are not working as expected.  I will do my best to
> watch for them and get things back in order.
> 
> Axton Grams
> 
> The opinions, statements, and/or suggested courses of action expressed
> in this E-mail do not necessarily reflect those of BMC Software, Inc.
> My voluntary participation in this forum is not intended to convey a
> role as a spokesperson, liaison or public relations representative for
> BMC Software, Inc.
> 
> ___
> 
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"

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

Re: BMC RKM

[Matt Reinfeldt]

Thank you, sir.

Matt

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Axton
Sent: Thursday, June 04, 2009 10:50 PM
To: arslist@ARSLIST.ORG
Subject: BMC RKM

This should now be working as expected again.  It's always the little
things that bite you.  Please continue to post to the list when you
see that things are not working as expected.  I will do my best to
watch for them and get things back in order.

Axton Grams

The opinions, statements, and/or suggested courses of action expressed
in this E-mail do not necessarily reflect those of BMC Software, Inc.
My voluntary participation in this forum is not intended to convey a
role as a spokesperson, liaison or public relations representative for
BMC Software, Inc.


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

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

BMC RKM

[Axton]

This should now be working as expected again.  It's always the little
things that bite you.  Please continue to post to the list when you
see that things are not working as expected.  I will do my best to
watch for them and get things back in order.

Axton Grams

The opinions, statements, and/or suggested courses of action expressed
in this E-mail do not necessarily reflect those of BMC Software, Inc.
My voluntary participation in this forum is not intended to convey a
role as a spokesperson, liaison or public relations representative for
BMC Software, Inc.

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

Re: WWRUG09 Hotel Registration: Hard Rock Hotel / Las Vegas

[Shellman, David]

**

I think your reading too much into that section. It doesn't say anything about 
not throwing Twinkies. It doesn't say anything about not throwing stress balls. 
It only notes "Throwing of articles in a deliberate or aggressive manner;"

Sounds to me like tossing is ok. Gentle underhand pitches wouldn't be 
aggressive. Well maybe deliberate but not aggressive.
Dave
-
dave.shell...@tycoelectronics.com
(Wireless)


From: Action Request System discussion list(ARSList) 
To: arslist@ARSLIST.ORG 
Sent: Thu Jun 04 20:39:51 2009
Subject: Re: WWRUG09 Hotel Registration: Hard Rock Hotel / Las Vegas


According to:

http://www.wwrug.org/wwrug/downloads/RULES.pdf

Section II
1.c suggests there will not be Twinkies thrown.
c) Throwing of articles in a deliberate or aggressive manner;



(BTW -- I think the whole "rules" document is very odd.)

I mean really -- the rules don't allow stealing (g) or for me to pack heat (h).
g) Theft of property;
h) Possession of weapons;


Where is the fun now?



-John


On Jun 2, 2009, at 3:35 PM, Daniel Bloom wrote:

**
What makes you think that?
I'm sure we will have the opportunity,
and after that poem I know who I'm throwing them at :-)


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Susan Palmer
Sent: June 2, 2009 4:21 PM
To: arslist@ARSLIST.ORG
Subject: Re: WWRUG09 Hotel Registration: Hard Rock Hotel / Las Vegas

** But even worse ... no twinkie throwing !!

On Tue, Jun 2, 2009 at 1:13 PM, patrick zandi 
mailto:remedy...@gmail.com>> wrote:
**
The part that will be missed, is the Railing on BMC Management for things that 
are not being done!
Oh, wait.. maybe that is why they did not have one this year?

On Tue, Jun 2, 2009 at 9:07 AM, Pierson, Shawn 
mailto:shawn.pier...@sug.com>> wrote:
**

That’s probably half of the rate for the hotel of any BMC UW that I’ve gone to. 
 I know the economy is suffering some in Las Vegas, but I still think that’s a 
great rate for a nice hotel like that.



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Daniel 
Bloom
Sent: Tuesday, June 02, 2009 6:37 AM
To: arslist@ARSLIST.ORG
Subject: WWRUG09 Hotel Registration: Hard Rock Hotel / Las Vegas



**

WWRUG09 is happening at the Hard Rock Hotel in Las Vegas NV
Stay close to the action with a room on-site at the HRH.

WWRUG09 Conference rates are $79/night for the entire conference, Nov 9 - Nov 
13, 2009,

with some rooms available at that rate for a few days before and after.

Follow the  'Accommodations' link at www.WWRUG.com to 
the Hard Rock Hotel reservation page.

(the Accommodations link is at the bottom of each page)

WWRUG09: the Other November event.



questions or comments about the conference? email 
wwrug2...@wwrug.org



 Daniel

Daniel Bloom, Conference Chair



_Platinum Sponsor: rmisoluti...@verizon.net 
ARSlist: "Where the Answers Are"_

Private and confidential as detailed 
here. If you cannot access 
hyperlink, please e-mail sender.
_Platinum Sponsor: rmisoluti...@verizon.net 
ARSlist: "Where the Answers Are"_



--
Patrick Zandi

_Platinum Sponsor: rmisoluti...@verizon.net 
ARSlist: "Where the Answers Are"_

_Platinum Sponsor: rmisoluti...@verizon.net 
ARSlist: "Where the Answers Are"_
_Platinum Sponsor: rmisoluti...@verizon.net 
ARSlist: "Where the Answers Are"_

--
John David Sundberg
235 East 6th Street, Suite 400B
St. Paul, MN 55101
(651) 556-0930-work
(651) 247-6766-cell
(651) 695-8577-fax
john.sundb...@kineticdata.com





_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

Re: WWRUG09 Hotel Registration: Hard Rock Hotel / Las Vegas

[John]

According to:

http://www.wwrug.org/wwrug/downloads/RULES.pdf

Section II
1.c suggests there will not be Twinkies thrown.
c) Throwing of articles in a deliberate or aggressive manner;



(BTW -- I think the whole "rules" document is very odd.)

I mean really -- the rules don't allow stealing (g) or for me to pack  
heat (h).

g) Theft of property;
h) Possession of weapons;


Where is the fun now?



-John


On Jun 2, 2009, at 3:35 PM, Daniel Bloom wrote:

**
What makes you think that?
I'm sure we will have the opportunity,
and after that poem I know who I'm throwing them at :-)

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

Sent: June 2, 2009 4:21 PM
To: arslist@ARSLIST.ORG
Subject: Re: WWRUG09 Hotel Registration: Hard Rock Hotel / Las Vegas

** But even worse ... no twinkie throwing !!

On Tue, Jun 2, 2009 at 1:13 PM, patrick zandi   
wrote:

**
The part that will be missed, is the Railing on BMC Management for  
things that are not being done!

Oh, wait.. maybe that is why they did not have one this year?

On Tue, Jun 2, 2009 at 9:07 AM, Pierson, Shawn   
wrote:

**
That’s probably half of the rate for the hotel of any BMC UW that I’ve  
gone to.  I know the economy is suffering some in Las Vegas, but I  
still think that’s a great rate for a nice hotel like that.



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

Sent: Tuesday, June 02, 2009 6:37 AM
To: arslist@ARSLIST.ORG
Subject: WWRUG09 Hotel Registration: Hard Rock Hotel / Las Vegas


**

WWRUG09 is happening at the Hard Rock Hotel in Las Vegas NV
Stay close to the action with a room on-site at the HRH.

WWRUG09 Conference rates are $79/night for the entire conference, Nov  
9 - Nov 13, 2009,


with some rooms available at that rate for a few days before and after.


Follow the  'Accommodations' link at www.WWRUG.com to the Hard Rock  
Hotel reservation page.


(the Accommodations link is at the bottom of each page)

WWRUG09: the Other November event.


questions or comments about the conference? email wwrug2...@wwrug.org


 Daniel

Daniel Bloom, Conference Chair


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the  
Answers Are"_


Private and confidential as detailed here. If you cannot access  
hyperlink, please e-mail sender.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the  
Answers Are"_




--
Patrick Zandi

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the  
Answers Are"_


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the  
Answers Are"_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the  
Answers Are"_


--
John David Sundberg
235 East 6th Street, Suite 400B
St. Paul, MN 55101
(651) 556-0930-work
(651) 247-6766-cell
(651) 695-8577-fax
john.sundb...@kineticdata.com






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

Re: Useful information about BMC Analytics

[Benedetto Cantatore]

I looked at BMC Analytics about a year ago and I really wanted to get
that, however, all the points that Guillaume made are true.  So while
Analytics is based on the BO engine, you don't have the freedom to do
reporting outside its scope.  I think both vendors miss out by creating
that limitation.  So while its a powerful reporting tool I would love to
put in the hands of my end users, at the end of the day, I need to be
able to create reports without some of the limitations imposed by the
Analytic product.  
 
Ben Cantatore
Remedy Manager
(914) 457-6209
 
Emerging Health IT
3 Odell Plaza
Yonkers, New York 10701


>>> guilla...@dcshq.com 06/04/09 12:58 PM >>>

** 
I will not even attempt to answer that...Hopefully someone at BMC can
answer that...
Before I got the information below, I went to several support techs as
you can imagine, since most people at BMC don't have a clear
understanding of all this.

It could depend on the BMC Analytics version. The info below is from
Analytics 2.5

-Guillaume


-Original Message-
From: Action Request System discussion list(ARSList) on behalf of Tony
Worthington
Sent: Thu 06/04/09 11:40 AM
To: arslist@ARSLIST.ORG
Subject: Re: Useful information about BMC Analytics

I remember hearing in Vancouver that you could purchase the universe
and
not the B/O components.  Maybe that was incorrect or has changed?


  Tony Worthington
  Sr. Technical Analyst
  Kohl's Department Stores
  N56 W17000 Ridgewood Drive
  Menomonee Falls, WI 53051
  262.703.7763 (phone)
  tony.worthing...@kohls.com
  www.kohls.com




From:
"Pierson, Shawn" 
To:
arslist@ARSLIST.ORG
Date:
06/04/2009 10:14 AM
Subject:
Re: Useful information about BMC Analytics
Sent by:
"Action Request System discussion list(ARSList)" 



**
We have the opposite issue.  We have been Business Objects users for
years, and we?ve owned BMC Analytics for a year and a half, but the
?extra? BO server license is really useless for us since we put it on
our
production BOXI server.  BMC didn?t want to give us a discount even
though
we wouldn?t be using their BOXI licenses.

From: Action Request System discussion list(ARSList) [
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ --_=_NextPart_001_01C9E536.2028C0BD

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

Re: Page Holder fields in Mid-Tier

[Rick Cook]

Yeah, I was thinking that was a 7.1 feature that didn't exist before.  I
agree with Peter - upgrade.  7.1 MT works just fine - in fact, better than
7.0.1 MT - over a 7.0.1 AR System.

Rick
On Thu, Jun 4, 2009 at 2:14 PM, Lammey, Peter A. wrote:

> ** We had the same problem some months ago and the solution BMC gave us
> was to upgrade our Mid Tier to 7.1 from 7.0.1.
> Mid Tier 7.1 has a arrow to allow the user to then view the other tabs that
> exceed the number that is shown on the screen.
>
>
> Thanks
> Peter Lammey
> ESPN IT Client Architecture and Automation
> 860-766-4761
>
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org] *On Behalf Of *Drake,Dave
> *Sent:* Thursday, June 04, 2009 5:10 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Page Holder fields in Mid-Tier
>
> **
>
> Hi all,
>
> I’ve got a page holder field that has two rows of tabs at the top.  In the
> 32bit client it shows up correctly with both rows, however, in mid-tier
> the top row is not visible and there’s no scroll bar that would allow one
> to get to it.  Where should I look to fix this so that either both rows
> are visible or that there’s a scroll bar to allow navigation?  Thanks!
>
> ARS 7.0.1 p007, Mid-Tier 7.0.1 p007, IE, WinVista stations, Win2K3 servers
> --
> CONFIDENTIALITY NOTICE This message and any included attachments are from
> Cerner Corporation and are intended only for the addressee. The information
> contained in this message is confidential and may constitute inside or
> non-public information under international, federal, or state securities
> laws. Unauthorized forwarding, printing, copying, distribution, or use of
> such information is strictly prohibited and may be unlawful. If you are not
> the addressee, please promptly delete this message and notify the sender of
> the delivery error by e-mail or you may call Cerner's corporate offices in
> Kansas City, Missouri, U.S.A at (+1) (816)221-1024.
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
> --
> Please consider the environment before printing this e-mail.
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_

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

Re: Page Holder fields in Mid-Tier

[LJ Longwing]

That's what I was going to suggest.

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lammey, Peter A.
Sent: Thursday, June 04, 2009 3:15 PM
To: arslist@ARSLIST.ORG
Subject: Re: Page Holder fields in Mid-Tier


** 
We had the same problem some months ago and the solution BMC gave us was to
upgrade our Mid Tier to 7.1 from 7.0.1.
Mid Tier 7.1 has a arrow to allow the user to then view the other tabs that
exceed the number that is shown on the screen.
 


Thanks 
Peter Lammey 
ESPN IT Client Architecture and Automation 
860-766-4761 

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Drake,Dave
Sent: Thursday, June 04, 2009 5:10 PM
To: arslist@ARSLIST.ORG
Subject: Page Holder fields in Mid-Tier


** 

Hi all,

I've got a page holder field that has two rows of tabs at the top.  In the
32bit client it shows up correctly with both rows, however, in mid-tier the
top row is not visible and there's no scroll bar that would allow one to get
to it.  Where should I look to fix this so that either both rows are visible
or that there's a scroll bar to allow navigation?  Thanks!

ARS 7.0.1 p007, Mid-Tier 7.0.1 p007, IE, WinVista stations, Win2K3 servers

  _  

CONFIDENTIALITY NOTICE This message and any included attachments are from
Cerner Corporation and are intended only for the addressee. The information
contained in this message is confidential and may constitute inside or
non-public information under international, federal, or state securities
laws. Unauthorized forwarding, printing, copying, distribution, or use of
such information is strictly prohibited and may be unlawful. If you are not
the addressee, please promptly delete this message and notify the sender of
the delivery error by e-mail or you may call Cerner's corporate offices in
Kansas City, Missouri, U.S.A at (+1) (816)221-1024.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 

  _  

Please consider the environment before printing this e-mail.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 

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

Re: Functional Spec Document Request

[Jase Brandon]

Thankyou Louise - very helpful and just what I was looking for.

Thanks,

Jase

On Tue, Jun 2, 2009 at 3:37 PM, Louise Van Hine  wrote:

> **   sorry I posted the wrong link - here's a good general spec doc.
> There are also many other samples available publically.
>
> www.*processimpact.com*/process_assets/srs_template.doc
>
> It can be easily adapted to Remedy applications.  What I do in the
> workflow-specific area is break it down as follows:
>
> Form
>
> Links
>
> Filters
>
> Menus
>
> Guides
>
> For each form that gets modified.
>
>
> --- On *Tue, 6/2/09, Jase Brandon * wrote:
>
>
> From: Jase Brandon 
> Subject: Functional Spec Document Request
> To: arslist@ARSLIST.ORG
> Date: Tuesday, June 2, 2009, 2:09 PM
>
> ** Hello All,
> Does anyone have a basic Functional Spec Document specific to Remedy that
> they would be willing to share?
>
> Thanks in Advance,
>
> Jase Brandon
> Quality Technology Services
> 300 Satellite Blvd, Suwanee, GA 30024
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>

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

Re: Page Holder fields in Mid-Tier

[Lammey, Peter A.]

We had the same problem some months ago and the solution BMC gave us was to 
upgrade our Mid Tier to 7.1 from 7.0.1.
Mid Tier 7.1 has a arrow to allow the user to then view the other tabs that 
exceed the number that is shown on the screen.



Thanks
Peter Lammey
ESPN IT Client Architecture and Automation
860-766-4761




From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Drake,Dave
Sent: Thursday, June 04, 2009 5:10 PM
To: arslist@ARSLIST.ORG
Subject: Page Holder fields in Mid-Tier

**

Hi all,

I've got a page holder field that has two rows of tabs at the top.  In the 
32bit client it shows up correctly with both rows, however, in mid-tier the top 
row is not visible and there's no scroll bar that would allow one to get to it. 
 Where should I look to fix this so that either both rows are visible or that 
there's a scroll bar to allow navigation?  Thanks!

ARS 7.0.1 p007, Mid-Tier 7.0.1 p007, IE, WinVista stations, Win2K3 servers


CONFIDENTIALITY NOTICE This message and any included attachments are from 
Cerner Corporation and are intended only for the addressee. The information 
contained in this message is confidential and may constitute inside or 
non-public information under international, federal, or state securities laws. 
Unauthorized forwarding, printing, copying, distribution, or use of such 
information is strictly prohibited and may be unlawful. If you are not the 
addressee, please promptly delete this message and notify the sender of the 
delivery error by e-mail or you may call Cerner's corporate offices in Kansas 
City, Missouri, U.S.A at (+1) (816)221-1024.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

Please consider the environment before printing this e-mail.

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

Page Holder fields in Mid-Tier

[Drake,Dave]

Hi all,
I've got a page holder field that has two rows of tabs at the top.  In the 
32bit client it shows up correctly with both rows, however, in mid-tier the top 
row is not visible and there's no scroll bar that would allow one to get to it. 
 Where should I look to fix this so that either both rows are visible or that 
there's a scroll bar to allow navigation?  Thanks!

ARS 7.0.1 p007, Mid-Tier 7.0.1 p007, IE, WinVista stations, Win2K3 servers

--
CONFIDENTIALITY NOTICE This message and any included attachments are from 
Cerner Corporation and are intended only for the addressee. The information 
contained in this message is confidential and may constitute inside or 
non-public information under international, federal, or state securities laws. 
Unauthorized forwarding, printing, copying, distribution, or use of such 
information is strictly prohibited and may be unlawful. If you are not the 
addressee, please promptly delete this message and notify the sender of the 
delivery error by e-mail or you may call Cerner's corporate offices in Kansas 
City, Missouri, U.S.A at (+1) (816)221-1024.

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

Re: Lost form reference

[Wacholz, Jeanette (Jenni)]

Thanks, Nicky. I ran this query earlier. It does find and return the
correct record. But Remedy still can't find it.
 
I have had our dba validate the correct owner of the tables. So that
does not appear to be the problem. I am currently reviewing the
arerror.log file to see what I can find. We are also opening a ticket to
BMC on this issue. Fortunately, this does not affect anyone but us
admins so it's not a high priority issue.

Jenni Wacholz 
480-445-2517 
WFH Tuesdays  602-606-7484 

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Nicky Madjarov
Sent: Thursday, June 04, 2009 11:09 AM
To: arslist@ARSLIST.ORG
Subject: Re: Lost form reference


** 
Jenni,
 
In toad run select * from arschema where schema_id=107;
 
arschema is the top layer where form inforrmation starts, if you dont
have a record there, you won't see it.
 
Regards,
 
Nicky Madjarov
phone: 973-202-4278
Find out how to bust your AR System performance @
http://www.SpeedUpARS.com

- Original Message - 
From: Wacholz, Jeanette (Jenni)   
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 
Sent: Thursday, June 04, 2009 12:46 PM
Subject: Lost form reference

** 
Hi Listers,
 
ARS V6.3 P020
ITSM 6
Oracle V10g
AIX 5.3
 
We have lost the ability to access one form via the User or the
Admin tool. The form is SHRCFG:ConfigPeople. If I look in TOAD, I can
see the view of the form. I can also see the t107, h107 and b107 tables
there. But the form is not visible or available from inside Remedy. I
believe I've seen issues similar to this on the list but I haven't been
successful finding them in the archives. The issue began last night
after our dba's installed Guardium on the db server. (ARSystem was
shutdown correctly before the dba's started their install and brought
back up after the install was completed.)
 
Any help you can offer would be appreciated!

Jenni Wacholz 
Coventry Health Care Inc 
Scottsdale AZ
480-445-2517 



 

Email Confidentiality Notice: The information contained in this
transmission is confidential, proprietary or privileged and may be
subject to protection under the law, including the Health Insurance
Portability and Accountability Act (HIPAA). The message is intended for
the sole use of the individual or entity to whom it is addressed. If you
are not the intended recipient, you are notified that any use,
distribution or copying of the message is strictly prohibited and may
subject you to criminal or civil penalties. If you received this
transmission in error, please contact the sender immediately by replying
to this email and delete the material from any computer. _Platinum
Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 


Email Confidentiality Notice: The information contained in this transmission is 
confidential, proprietary or privileged and may be subject to protection under 
the law, including the Health Insurance Portability and Accountability Act 
(HIPAA).

The message is intended for the sole use of the individual or  entity to whom 
it is addressed.  If you are not the intended recipient, you are notified that 
any use, distribution or copying of the message is strictly prohibited and may 
subject you to criminal or civil penalties.  If you received this transmission 
in error, please contact the sender immediately by replying to this email and 
delete the material from any  computer.

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

Re: Error while setting a Group name in the assignee field (only in Webclient)

[jham36]

You can use Groups in the assignee field.  How are you populating this
information though?
Are you using an ITSM app? If so the assignee needs to be a User.

James

On Jun 4, 12:19 pm, LJ Longwing  wrote:
> If I'm not mistaken, the assignee field (id 4), HAS to be a user, and cannot
> be a group.
>
>   _  
>
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Bhupesh Gupta
> Sent: Thursday, June 04, 2009 10:14 AM
> To: arsl...@arslist.org
> Subject: Re: Error while setting a Group name in the assignee field (only in
> Webclient)
>
> **
>
> Error while setting a Group name in the assignee field (only in Webclient)
>
> you can not translate the group name in the group list or assignee group
> field: row level group
>
> Remedy Version : 7.5
> DB : Oracle
>
> Any clues folks..
>
> --
> Regards,
> Bhupesh Gupta
>
> --
> Regards,
> Bhupesh Gupta _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where
> the Answers Are"_
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

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

Re: Re : Non clustered indices (ITSM 7.3)

[Lyle Taylor]

Is there an appropriate existing index that you could simply add the field to 
rather than creating a new one for this field?  That way, you don't exceed the 
limit, and it may be more efficient for the DB as well.

Lyle

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Frex Popo
Sent: Thursday, June 04, 2009 12:39 PM
To: arslist@ARSLIST.ORG
Subject: Re : Non clustered indices (ITSM 7.3)

**
Reason I am asking is that I think it's better to create the index through the 
Admin Client so that the server is aware of it rather than having to create the 
index at the DB level.. But if it comes to having to create it at the DB level 
I think I would opt for the latter since having an index is better than not 
having it at all :)

--- En date de : Jeu 4.6.09, Frex Popo  a écrit :

De: Frex Popo 
Objet: Non clustered indices (ITSM 7.3)
À: arslist@ARSLIST.ORG
Date: Jeudi 4 Juin 2009, 12h26
Hello everyone,

Found a number of join forms using a particular column in the join criteria. 
This column did not look it was indexed on the base form (i.e. HPD:Help Desk), 
so thought let's create one. When I tried to do so I got a SQL error:

No se pudo crear índice no agrupado 'I1035_904003986_1' porque supera el máximo 
de 249 permitido por tabla o vista.  (SQL Server 1910) (ARERR 552). Failure 
during SQL operation to the database : 904003986 (ARWARN 552).

This simply means that the SQL server could not create the nonclustered index 
as it is beyond the maximum allowed. The form has 13 indexes. As a test I 
removed an existing non clustered index and create the new one and it works 
just fine, but of course I want to keep all the existing ones and be able to 
create the new one.

I checked the table definition in the SQL Enterprise client by running 
sp_helpindex and got a list of some 250 entries. Now, I don't have a non 
customised version of this form nor do I have another environment to check if 
this is all created by the remedy server, hence the question, does anyone have 
all these indices defined on the Help Desk form in their ITSM 7.0 installation?
I am using ARS 7.1 patch 4 / ITSM 7.3 / SQL server 2005.

Here is part of the 250 entries.

index_name,index_description,index_keys
I1035_100019_1,nonclustered located on PRIMARY,C100019, C100018
I1035_100063_1,nonclustered located on PRIMARY,C100063, C100064, 
C100065
I1035_100079_1,nonclustered located on PRIMARY,C100079
I1035_100080_1,nonclustered located on PRIMARY,C100080
I1035_100161_1,nonclustered, unique located on PRIMARY,C100161
I1035_100427_1,nonclustered located on PRIMARY,C100427
I1035_100869_1,nonclustered located on PRIMARY,C100869
I1035_100875_1,nonclustered located on PRIMARY,C100875
I1035_179_1,nonclustered, unique located on PRIMARY,C179
I1035_20003_1,nonclustered located on PRIMARY,C20003, C20004, 
C20005
I1035_240001002_1,nonclustered located on PRIMARY,C240001002
I1035_4_1,nonclustered located on PRIMARY,C4
I1035_7_1,nonclustered located on PRIMARY,C7
missing_index_100016,nonclustered located on PRIMARY,C100079, C103009, 
C7
missing_index_100040,nonclustered located on PRIMARY,C100014, C100251, 
C100296, C100082, C100217
missing_index_100058,nonclustered located on PRIMARY,C100014, C100251, 
C100079, C100082, C100217
missing_index_100062,nonclustered located on PRIMARY,C100014, C100079, 
C100217, C100251, C100082
missing_index_100064,nonclustered located on PRIMARY,C100014, C100217, 
C100251, C100082
missing_index_100089,nonclustered located on PRIMARY,C100079, C7
.
.
.
.
missing_index_99846,nonclustered located on PRIMARY,C100099, C100251, C7
missing_index_99878,nonclustered located on PRIMARY,C100014, C100251, 
C100082
missing_index_99880,nonclustered located on PRIMARY,C100014, C100251, 
C100082, C100217
missing_index_99882,nonclustered located on PRIMARY,C100014, C100079, 
C100251, C100296, C100572, C100082, C100217
missing_index_99929,nonclustered located on PRIMARY,C7
PK__T1035__4032018A,clustered, unique, primary key located on PRIMARY,C1
Regards
frex



_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_


 NOTICE: This email message is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information. Any unauthorized 
review, use, disclosure or distribution is prohibited. If you are not the 
intended recipient, please contact the sender by reply email and destroy all 
copies of the original message.



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

Re: 'Remedy Application Service' Password

[Axton]

http://arswiki.org/wiki/Securing_ARS#Locking_Down_Built-in_ARS_Accounts

Axton Grams

The opinions, statements, and/or suggested courses of action expressed
in this E-mail do not necessarily reflect those of BMC Software, Inc.
My voluntary participation in this forum is not intended to convey a
role as a spokesperson, liaison or public relations representative for
BMC Software, Inc.

On Thu, Jun 4, 2009 at 1:03 PM, arsadm  wrote:
> ** Hi Listers, We have to use 'Remedy Application Service' user name to
> integrate another app to ARS. But unfortunately we forget our password for
> this account. Is there any way to trace this password out. Also can anyone
> guide us to reset this password, as this will force us to reset Approval
> Server, Email engine & Flashboards password. We are in ARS 7.1 on Win 2K3
> SQL 2005
> 
> View this message in context: 'Remedy Application Service' Password
> Sent from the ARS (Action Request System) mailing list archive at
> Nabble.com.
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_

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

Re: Re : Non clustered indices (ITSM 7.3)

[Rick Cook]

Frex, that limit is there for a reason. Once you exceed about 8 indices, 
performance increasingly suffers, especially on submits. 

Rick

-Original Message-
From: Frex Popo 

Date: Thu, 4 Jun 2009 18:39:20 
To: 
Subject: Re : Non clustered indices (ITSM 7.3)


Reason I am asking is that I think it's better to create the index through the 
Admin Client so that the server is aware of it rather than having to create the 
index at the DB level.. But if it comes to having to create it at the DB level 
I think I would opt for the latter since having an index is better than not 
having it at all :)

--- En date de : Jeu 4.6.09, Frex Popo  a écrit :


De: Frex Popo 
Objet: Non clustered indices (ITSM 7.3)
À: arslist@ARSLIST.ORG
Date: Jeudi 4 Juin 2009, 12h26







Hello everyone,
 
Found a number of join forms using a particular column in the join criteria. 
This column did not look it was indexed on the base form (i.e. HPD:Help Desk), 
so thought let's create one. When I tried to do so I got a SQL error: 
 

No se pudo crear índice no agrupado 'I1035_904003986_1' porque supera el máximo 
de 249 permitido por tabla o vista.  (SQL Server 1910) (ARERR 552). Failure 
during SQL operation to the database : 904003986 (ARWARN 552).
 
This simply means that the SQL server could not create the nonclustered index 
as it is beyond the maximum allowed. The form has 13 indexes. As a test I 
removed an existing non clustered index and create the new one and it works 
just fine, but of course I want to keep all the existing ones and be able to 
create the new one.
 
I checked the table definition in the SQL Enterprise client by running 
sp_helpindex and got a list of some 250 entries. Now, I don't have a non 
customised version of this form nor do I have another environment to check if 
this is all created by the remedy server, hence the question, does anyone have 
all these indices defined on the Help Desk form in their ITSM 7.0 installation?

I am using ARS 7.1 patch 4 / ITSM 7.3 / SQL server 2005.
 
Here is part of the 250 entries. 

index_name,index_description,index_keys
I1035_100019_1,nonclustered located on PRIMARY,C100019, C100018
I1035_100063_1,nonclustered located on PRIMARY,C100063, C100064, 
C100065
I1035_100079_1,nonclustered located on PRIMARY,C100079
I1035_100080_1,nonclustered located on PRIMARY,C100080
I1035_100161_1,nonclustered, unique located on PRIMARY,C100161
I1035_100427_1,nonclustered located on PRIMARY,C100427
I1035_100869_1,nonclustered located on PRIMARY,C100869
I1035_100875_1,nonclustered located on PRIMARY,C100875
I1035_179_1,nonclustered, unique located on PRIMARY,C179
I1035_20003_1,nonclustered located on PRIMARY,C20003, C20004, 
C20005
I1035_240001002_1,nonclustered located on PRIMARY,C240001002
I1035_4_1,nonclustered located on PRIMARY,C4
I1035_7_1,nonclustered located on PRIMARY,C7
missing_index_100016,nonclustered located on PRIMARY,C100079, C103009, 
C7
missing_index_100040,nonclustered located on PRIMARY,C100014, C100251, 
C100296, C100082, C100217
missing_index_100058,nonclustered located on PRIMARY,C100014, C100251, 
C100079, C100082, C100217
missing_index_100062,nonclustered located on PRIMARY,C100014, C100079, 
C100217, C100251, C100082
missing_index_100064,nonclustered located on PRIMARY,C100014, C100217, 
C100251, C100082
missing_index_100089,nonclustered located on PRIMARY,C100079, C7
.
.
.
.
missing_index_99846,nonclustered located on PRIMARY,C100099, C100251, C7
missing_index_99878,nonclustered located on PRIMARY,C100014, C100251, 
C100082
missing_index_99880,nonclustered located on PRIMARY,C100014, C100251, 
C100082, C100217
missing_index_99882,nonclustered located on PRIMARY,C100014, C100079, 
C100251, C100296, C100572, C100082, C100217
missing_index_99929,nonclustered located on PRIMARY,C7
PK__T1035__4032018A,clustered, unique, primary key located on PRIMARY,C1

Regards
frex





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

Re: MidTier 6.3 and Windows server 2003 SP 2

[Mark Wilson]

We are currently running our Test Mid-Tier 6.3 server on Windows 2003 SP2
with no problems.

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Marty.Thorin
Sent: Thursday, June 04, 2009 10:53 AM
To: arslist@ARSLIST.ORG
Subject: MidTier 6.3 and Windows server 2003 SP 2


** 

Good afternoon: 
Server operations wants to upgrade my MidTier 6.3 server from
Windows 2003 SP1 to Windows 2003 SP2.  I just checked the community to see
if anyone had any problems with this change.  I checked the 6.3
compatibility matrix.  It shows Windows Server 2003 but does not list SP2.
(Nor SP1 but I downloaded the matrix in 2006.)

Thank you, 
Thorin 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_

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

Re : Non clustered indices (ITSM 7.3)

[Frex Popo]

Reason I am asking is that I think it's better to create the index through the 
Admin Client so that the server is aware of it rather than having to create the 
index at the DB level.. But if it comes to having to create it at the DB level 
I think I would opt for the latter since having an index is better than not 
having it at all :)

--- En date de : Jeu 4.6.09, Frex Popo  a écrit :


De: Frex Popo 
Objet: Non clustered indices (ITSM 7.3)
À: arslist@ARSLIST.ORG
Date: Jeudi 4 Juin 2009, 12h26







Hello everyone,
 
Found a number of join forms using a particular column in the join criteria. 
This column did not look it was indexed on the base form (i.e. HPD:Help Desk), 
so thought let's create one. When I tried to do so I got a SQL error: 
 

No se pudo crear índice no agrupado 'I1035_904003986_1' porque supera el máximo 
de 249 permitido por tabla o vista.  (SQL Server 1910) (ARERR 552). Failure 
during SQL operation to the database : 904003986 (ARWARN 552).
 
This simply means that the SQL server could not create the nonclustered index 
as it is beyond the maximum allowed. The form has 13 indexes. As a test I 
removed an existing non clustered index and create the new one and it works 
just fine, but of course I want to keep all the existing ones and be able to 
create the new one.
 
I checked the table definition in the SQL Enterprise client by running 
sp_helpindex and got a list of some 250 entries. Now, I don't have a non 
customised version of this form nor do I have another environment to check if 
this is all created by the remedy server, hence the question, does anyone have 
all these indices defined on the Help Desk form in their ITSM 7.0 installation?

I am using ARS 7.1 patch 4 / ITSM 7.3 / SQL server 2005.
 
Here is part of the 250 entries. 

index_name,index_description,index_keys
I1035_100019_1,nonclustered located on PRIMARY,C100019, C100018
I1035_100063_1,nonclustered located on PRIMARY,C100063, C100064, 
C100065
I1035_100079_1,nonclustered located on PRIMARY,C100079
I1035_100080_1,nonclustered located on PRIMARY,C100080
I1035_100161_1,nonclustered, unique located on PRIMARY,C100161
I1035_100427_1,nonclustered located on PRIMARY,C100427
I1035_100869_1,nonclustered located on PRIMARY,C100869
I1035_100875_1,nonclustered located on PRIMARY,C100875
I1035_179_1,nonclustered, unique located on PRIMARY,C179
I1035_20003_1,nonclustered located on PRIMARY,C20003, C20004, 
C20005
I1035_240001002_1,nonclustered located on PRIMARY,C240001002
I1035_4_1,nonclustered located on PRIMARY,C4
I1035_7_1,nonclustered located on PRIMARY,C7
missing_index_100016,nonclustered located on PRIMARY,C100079, C103009, 
C7
missing_index_100040,nonclustered located on PRIMARY,C100014, C100251, 
C100296, C100082, C100217
missing_index_100058,nonclustered located on PRIMARY,C100014, C100251, 
C100079, C100082, C100217
missing_index_100062,nonclustered located on PRIMARY,C100014, C100079, 
C100217, C100251, C100082
missing_index_100064,nonclustered located on PRIMARY,C100014, C100217, 
C100251, C100082
missing_index_100089,nonclustered located on PRIMARY,C100079, C7
.
.
.
.
missing_index_99846,nonclustered located on PRIMARY,C100099, C100251, C7
missing_index_99878,nonclustered located on PRIMARY,C100014, C100251, 
C100082
missing_index_99880,nonclustered located on PRIMARY,C100014, C100251, 
C100082, C100217
missing_index_99882,nonclustered located on PRIMARY,C100014, C100079, 
C100251, C100296, C100572, C100082, C100217
missing_index_99929,nonclustered located on PRIMARY,C7
PK__T1035__4032018A,clustered, unique, primary key located on PRIMARY,C1

Regards
frex





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

Re: MidTier 6.3 and Windows server 2003 SP 2

[Brittain, Mark]

HI Thorin,

 

The matrix I have was created in 2004 and makes not mention of service
packs. I only downloaded the matrix last December so I assume this is
the most current.

 

Mark

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Marty.Thorin
Sent: Thursday, June 04, 2009 1:53 PM
To: arslist@ARSLIST.ORG
Subject: MidTier 6.3 and Windows server 2003 SP 2

 

Good afternoon: 
Server operations wants to upgrade my MidTier 6.3 server from
Windows 2003 SP1 to Windows 2003 SP2.  I just checked the community to
see if anyone had any problems with this change.  I checked the 6.3
compatibility matrix.  It shows Windows Server 2003 but does not list
SP2.  (Nor SP1 but I downloaded the matrix in 2006.)

Thank you, 
Thorin 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_

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

Re: BMC KB site - now 100% less useful than before!

[Nicky Madjarov]

RE: BMC KB site - now 100% less useful than before!Well, this message should be 
dated from the time of the Remedy assets aquisition from Peregrine and 
consequent merging of the kb's together with the old BMC products, e.g. quite 
some time ago.

Regards,

Nicky Madjarov
phone: 973-202-4278
Find out how to bust your AR System performance @
http://www.SpeedUpARS.com
  - Original Message - 
  From: Walters, Mark 
  Newsgroups: public.remedy.arsystem.general
  To: arslist@ARSLIST.ORG 
  Sent: Thursday, June 04, 2009 8:56 AM
  Subject: Re: BMC KB site - now 100% less useful than before!


  ** 
  BMC are aware that there is a problem with KB searches at the moment - this 
is from the support web site;

   

  Latest Support News

  We are currently experiencing technical difficulties with our Knowledge Base 
Search functionality, which is causing inconsistent search results to be 
returned. We apologize for the inconvenience and are working to resolve the 
problem as quickly as possible.  

  Mark

   

  From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Rodriguez, Rafael J x23718
  Sent: 04 June 2009 13:54
  To: arslist@ARSLIST.ORG
  Subject: Re: BMC KB site - now 100% less useful than before!

   

  ** 

  THIS IS SO TRUE! I hardly search KB on BMC site anymore as it never gives 
you a direct result.

   

  -Rafael

   


--

  From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Sanford, Claire
  Sent: Wednesday, June 03, 2009 4:01 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: BMC KB site - now 100% less useful than before!

   

  I so agree!  I did a search on  "ARERR" and it returned 3 articles!  

   

  It is a loose situation!  They may lose too!!

   

  I searched archives of the list and found a conversation regarding my problem 
from 2006 that was more helpful.  It didn't answer the problem, but it at least 
pointed me in the right direction.

   


--

  From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault
  Sent: Wednesday, June 03, 2009 2:11 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: BMC KB site - now 100% less useful than before!

  ** 

  All this is to the detriment of BMC support itself, because the KB isn't 
working now (and before this problem, it was not very good anyway), so we'll 
have to keep submitting more tickets to BMC support for things that we should 
be able to find in the KB in the first place. This in turn may raise support 
fees, or at least eats into R&D dollars. It's a loose-loose situation for 
everybody

  -Guillaume


  -Original Message-
  From: Action Request System discussion list(ARSList) on behalf of Rick Cook
  Sent: Wed 06/03/09 2:12 PM
  To: arslist@ARSLIST.ORG
  Subject: BMC KB site - now 100% less useful than before!

  I can't even search for something like "license" and get even ONE result,
  despite leaving the search criteria wide open.  I need some information that
  I know is (was?) probably out there, but I can't get to it since they
  "upgraded" the site recently.

  Does anyone have any idea who to contact about this?  There is no "Contact
  the webmaster" or some such on the page, either.

  Rick

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

  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 

This message and any attachments are intended only for the use of the addressee 
andmay contain information that is privileged and confidential. If the reader 
of the message is not the intended recipient or an authorized representative of 
theintended recipient, you are hereby notified that any dissemination of 
thiscommunication is strictly prohibited. If you have received this 
communication inerror, please notify us immediately by e-mail and delete the 
message and anyattachments from your system.  _Platinum Sponsor: 
rmisoluti...@verizon.net ARSlist: "Where the Answers Are"__Platinum Sponsor: 
rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

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

Re: Odd table field issue

[Nicky Madjarov]

Hi, if you are not looking in different views in admin and user, then you can 
consider rebuilding an index called FIELD_TABLE_IND. This one is the only index 
of FIELD_TABLE.

Regards,

Nicky Madjarov
phone: 973-202-4278
Find out how to bust your AR System performance @
http://www.SpeedUpARS.com
  - Original Message - 
  From: William Rentfrow 
  Newsgroups: public.remedy.arsystem.general
  To: arslist@ARSLIST.ORG 
  Sent: Thursday, June 04, 2009 1:06 PM
  Subject: Odd table field issue


  ** 
  I'm working in a 6.3 CSS system (ARS Patch 25, appropriate User/Admin tools)s

  All of the table fields on every form I open do not show the correct fields.  
They show the fields for the form the table is located on and not the fields 
from the selected table in the Admin tool.  Even if I change the form the 
fields do not change.

  We've tried rebooting, bouncing the AR Server, etc - I've never seen this 
before.  It is essentially impossible at this point to edit existing or add new 
table fields.  

  Anyone run into this?  The only redeeming factor is that this system is in 
the process of being replaced.

  William Rentfrow
  Principal Consultant, StrataCom Inc.
  wrentf...@stratacominc.com
  Corporate Website, www.stratacominc.com
  Blog, www.williamrentfrow.com
  715-410-8156 C

  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

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

Re: Odd table field issue

[David Sanders]

Hi William

 

Just a WAG, but have you tried right-clicking on the table header in the
User Tool and choosing Reset?  The table field will not show any changes if
you have previously saved layout changes in the user tool.

 

HTH

 

David Sanders

Remedy Solution Architect

Enterprise Service Suite @ Work

==

 

tel +44 1494 468980

mobile +44 7710 377761

email  
david.sand...@westoverconsulting.co.uk

 

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

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of William Rentfrow
Sent: Thursday, June 04, 2009 6:07 PM
To: arslist@ARSLIST.ORG
Subject: Odd table field issue

 

I'm working in a 6.3 CSS system (ARS Patch 25, appropriate User/Admin
tools)s

 

All of the table fields on every form I open do not show the correct fields.
They show the fields for the form the table is located on and not the fields
from the selected table in the Admin tool.  Even if I change the form the
fields do not change.

 

We've tried rebooting, bouncing the AR Server, etc - I've never seen this
before.  It is essentially impossible at this point to edit existing or add
new table fields.  

 

Anyone run into this?  The only redeeming factor is that this system is in
the process of being replaced.

 

William Rentfrow

Principal Consultant, StrataCom Inc.

wrentf...@stratacominc.com

Corporate Website, www.stratacominc.com  

Blog, www.williamrentfrow.com  

715-410-8156 C

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_

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

Re: Lost form reference

[Nicky Madjarov]

Jenni,

In toad run select * from arschema where schema_id=107;

arschema is the top layer where form inforrmation starts, if you dont have a 
record there, you won't see it.

Regards,

Nicky Madjarov
phone: 973-202-4278
Find out how to bust your AR System performance @
http://www.SpeedUpARS.com
  - Original Message - 
  From: Wacholz, Jeanette (Jenni) 
  Newsgroups: public.remedy.arsystem.general
  To: arslist@ARSLIST.ORG 
  Sent: Thursday, June 04, 2009 12:46 PM
  Subject: Lost form reference


  ** 
  Hi Listers,

  ARS V6.3 P020
  ITSM 6
  Oracle V10g
  AIX 5.3

  We have lost the ability to access one form via the User or the Admin tool. 
The form is SHRCFG:ConfigPeople. If I look in TOAD, I can see the view of the 
form. I can also see the t107, h107 and b107 tables there. But the form is not 
visible or available from inside Remedy. I believe I've seen issues similar to 
this on the list but I haven't been successful finding them in the archives. 
The issue began last night after our dba's installed Guardium on the db server. 
(ARSystem was shutdown correctly before the dba's started their install and 
brought back up after the install was completed.)

  Any help you can offer would be appreciated!
  Jenni Wacholz 
  Coventry Health Care Inc 
  Scottsdale AZ
  480-445-2517 





  Email Confidentiality Notice: The information contained in this transmission 
is confidential, proprietary or privileged and may be subject to protection 
under the law, including the Health Insurance Portability and Accountability 
Act (HIPAA). The message is intended for the sole use of the individual or 
entity to whom it is addressed. If you are not the intended recipient, you are 
notified that any use, distribution or copying of the message is strictly 
prohibited and may subject you to criminal or civil penalties. If you received 
this transmission in error, please contact the sender immediately by replying 
to this email and delete the material from any computer. _Platinum Sponsor: 
rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

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

'Remedy Application Service' Password

[arsadm]

Hi Listers,
We have to use 'Remedy Application Service' user name to integrate
another app to ARS. But unfortunately we forget our password for this
account. Is there any way to trace this password out. Also can anyone guide
us to reset this password, as this will force us to reset Approval Server,
Email engine & Flashboards password.

We are in ARS 7.1
on Win 2K3
 SQL 2005
-- 
View this message in context: 
http://www.nabble.com/%27Remedy-Application-Service%27-Password-tp23874977p23874977.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

MidTier 6.3 and Windows server 2003 SP 2

[Marty.Thorin]

Good afternoon:
Server operations wants to upgrade my MidTier 6.3 server from
Windows 2003 SP1 to Windows 2003 SP2.  I just checked the community to
see if anyone had any problems with this change.  I checked the 6.3
compatibility matrix.  It shows Windows Server 2003 but does not list
SP2.  (Nor SP1 but I downloaded the matrix in 2006.)

Thank you,
Thorin

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

Re: BMC KB site - now 100% less useful than before!

[Stephen Heider]

There is a utility on http://arswiki.org/projects/dotnetutil called
ARS_KBImport.  It is used to download and import KB articles into a Remedy
form.  From there you can perform regular Remedy searches.

Since BMC changed their URL format (ie.
http://rkm.bmc.com/rkm/viewdoc.jsp?doc=KM-01001282) the utility will
need to be updated to accommodate.If anyone wants to update it, it's
open source and written in .Net.

HTH

-- 
Stephen
Remedy Skilled Professional



On Thu, Jun 4, 2009 at 11:00 AM, Tami Palacky  wrote:

> i have never had success with KB searches on the BMC website and that
> is why i rarely use it.
>
> On Jun 4, 8:53 am, "Rodriguez, Rafael J x23718"
>  wrote:
> > THIS IS SO TRUE! I hardly search KB on BMC site anymore as it never
> > gives you a direct result.
> >
> > -Rafael
> >
> > 
> >
> > From: Action Request System discussion list(ARSList)
> > [mailto:arsl...@arslist.org] On Behalf Of Sanford, Claire
> > Sent: Wednesday, June 03, 2009 4:01 PM
> > To: arsl...@arslist.org
> > Subject: Re: BMC KB site - now 100% less useful than before!
> >
> > I so agree!  I did a search on  "ARERR" and it returned 3 articles!
> >
> > It is a loose situation!  They may lose too!!
> >
> > I searched archives of the list and found a conversation regarding my
> > problem from 2006 that was more helpful.  It didn't answer the problem,
> > but it at least pointed me in the right direction.
> >
> > 
> >
> > From: Action Request System discussion list(ARSList)
> > [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault
> > Sent: Wednesday, June 03, 2009 2:11 PM
> > To: arsl...@arslist.org
> > Subject: Re: BMC KB site - now 100% less useful than before!
> >
> > **
> >
> > All this is to the detriment of BMC support itself, because the KB isn't
> > working now (and before this problem, it was not very good anyway), so
> > we'll have to keep submitting more tickets to BMC support for things
> > that we should be able to find in the KB in the first place. This in
> > turn may raise support fees, or at least eats into R&D dollars. It's a
> > loose-loose situation for everybody
> >
> > -Guillaume
> >
> >
> >
> > -Original Message-
> > From: Action Request System discussion list(ARSList) on behalf of Rick
> >
> > Cook
> > Sent: Wed 06/03/09 2:12 PM
> > To: arsl...@arslist.org
> > Subject: BMC KB site - now 100% less useful than before!
> >
> > I can't even search for something like "license" and get even ONE
> > result,
> > despite leaving the search criteria wide open.  I need some information
> > that
> > I know is (was?) probably out there, but I can't get to it since they
> > "upgraded" the site recently.
> >
> > Does anyone have any idea who to contact about this?  There is no
> > "Contact
> > the webmaster" or some such on the page, either.
> >
> > Rick
> >
> > 
> > ___
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > Platinum 
> > Sponsor:rmisoluti...@verizon.netARSlist:
> >  "Where the Answers
> > Are"
> >
> > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> > Are"_
> >
> > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> > Are"_
> >
> > This message and any attachments are intended only for the use of the
> addressee and
> > may contain information that is privileged and confidential. If the
> reader of the
> > message is not the intended recipient or an authorized representative of
> the
> > intended recipient, you are hereby notified that any dissemination of
> this
> > communication is strictly prohibited. If you have received this
> communication in
> > error, please notify us immediately by e-mail and delete the message and
> any
> > attachments from your system.
> >
> >
> ___­
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > Platinum 
> > Sponsor:rmisoluti...@verizon.netARSlist:
> >  "Where the Answers Are"- Hide quoted text -
> >
> > - Show quoted text -
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum 
> Sponsor:rmisoluti...@verizon.netARSlist: 
> "Where the Answers Are"
>

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

Re: how to make the field label appear in the error message o the web

[Frank Caruso]

I do not believe there is a setting for this. It may actually be a bug in
the version/patch of the MidTier you are running.

On Thu, Jun 4, 2009 at 5:08 PM, Remedy Maniac
wrote:

> dear listers,
>
> ARSystem 6.00.01
> Mid-tiers 6.3 on Apache/Tomcat
>
> on the user client whenever I get an error message because of no permission
> on a field I can read something like this:
> "ARERR [331] You do not have write access (for this entry) to field :
>  Originator"
>
> So the name of the field "Originator" is displayed.
>
> On the web it's different. I just get the ID. How can I make the field name
> also be displayed on the web?
> Anybody any clue on this?
>
> Serouche
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum 
> Sponsor:rmisoluti...@verizon.netARSlist: 
> "Where the Answers Are"
>

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

Re: Understanding of Field_dispprop

[Carey Matthew Black]

Vijayalakshmi Paulraj,

Now that you have defined what you are trying to do it is possible to
try to guide you down a path to your goal. :) However, you were not
specific about which version of the ARS Java API you are using. So the
following assumes v7.1.


You likely are not setting setDisplayInstance(DisplayInstanceMap
displayInstance) on the field before you create the field
(ARServerUser.createField()).

DisplayInstanceMap has a method ( setProperty() )to effect all of the
things your may want to set.

DisplayInstanceMap.setProperty(int viewId, int propertyId, Value value)
  viewId:
This needs to be the "field Id" for the forms View where the field
will be present.
  See: List = ARServerUser.getListView(String formName,
long changedSince)

Note: A field can be a part of the Form object and not be included
in ANY ARS view or only one, or included in all Views.

  propertyId:
You will likely need to set a few of these..
 Reference:
   Constants.AR_DPROP_BBOX
  ( Likely one of the settings you need to set.)
Tip: Get a Field object and look inside the DisplayInstanceMap
returned from getDisplayInstance() as a good/faster way to figure out
what you need to set here.

  value:
 It all depends on the propertyId of interest. (com.bmc.arsys.api.Value)

Hope that helps.

The suggestion about looking at the XML def file can be helpful in
combination with reviewing the DisplayInstanceMap from an existing
field. :)

-- 
Carey Matthew Black
BMC Remedy AR System Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.



On Thu, Jun 4, 2009 at 3:13 AM, Vijayalakshmi Paulraj
 wrote:
> Thanks all, I am trying to create a Field in an existing form using Java
> API call.
>
> The field is getting created in the Field Table and not in the
> field_disprop table, because the display properties are not set (as it
> is expecting...)
>
> When I try to understand the display properties of another existing
> field, (as below)
>
> {536870912=[[X=6074,Y=5000], [X=31158,Y=7100]], 4=1, 7=2147483641,
> 20=Submitter,
>  21=[[X=0,Y=400], [X=6411,Y=2100]], 27=16, 28=4, 29=1, 60=1, 61=30,
> 65=[[X=0,Y=0
> ], [X=0,Y=0]], 66=[[X=22722,Y=0], [X=25084,Y=2100]], 143=4294967295,
> 151=[[X=697
> 4,Y=0], [X=22159,Y=2100]]}
>
> Now, can you please pass some ideas on how to interpret this??? Looks
> much simpler than what is stored in the database on propshort column :)
>
> Getting confused with too many X,Y Coordinates, my form has got only one
> View ("Default Administrator View")
>
> Is it documented anywhere??
>
> All I just did is created a Regular form using Remedy Admin Tool.
> Created a Field via the Java API call... my aim is to make it
> visible(Field_Disprop should get populated in correct manner)
>
> Thanks&Regards,
> Vijayalakshmi Paulraj

< snip >

> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky
> Sent: Wednesday, June 03, 2009 7:29 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Understanding of Field_dispprop
>
> Hi,
>
> It is pretty easy to understand the properties...
>
> In the example below, the first number indicates the number of fields:
> 14
>
> The second number 3 indicates the property 3 (AR_DPROP_BBOX in ar.h)
>
> The third number 41 indicates a set of coordinates (AR_DATA_TYPE_COORDS)
>
> Following the data-type is a number of field, in this case 4 that
> corresponds to the coordinates 5399x2500 and 28233 and 4600.
>
> The second field has id 4 (AR_DPROP_VISIBLE) with datatype 6
> (AR_DATA_TYPE_ENUM) and value 1 (the value possibly corresponds to a
> true).
>
> And so on...
>
> The 10 before Request ID is the size of a char-field.
>
>        Best Regards - Misi, RRR AB, http://www.rrr.se
>
> Products from RRR Scandinavia:
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
> logs.
> * RRR|Translator - Manage and automate your language translations.
> Find these products, and many free tools and utilities, at
> http://rrr.se.
>
>> Hi All,
>>
>> Please pass  ideas on what will get stored in the Field_disprop table
>> when a new field is added to a form and how to interpret the column
>> value of 'propshort'?
>>
>> For E.g., the value stored for the Request Id field when a fresh
>> regular form is created is as below:
>>
>>
>> 14\3\41\2\5399\2500\28233\4600\4\6\1\7\40\2147483642\20\4\10\Request
>> ID\21\41\2\0\400\7086\2100\27\8\16\28\6\4\29\6\1\60\40\1\65\41\2\0\0\0
>> \0 \143\40\4294967295\151\41\2\7649\0\22834\2100\170\40\0\231\6\1\
>>
>> Please pass some clue to interpret this
>>
>>
>> Thanks & Regards,
>> Vijayalakshmi Paulraj

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@v

Re: Lost form reference

[Wacholz, Jeanette (Jenni)]

Thanks Rick and Conny, for your suggestions. I'm checking them out.

Jenni Wacholz 
480-445-2517 

[ 


From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Rick Cook
Sent: Thursday, June 04, 2009 10:01 AM
To: arslist@ARSLIST.ORG
Subject: Re: Lost form reference



** 
Jenni, check the owner of the tables in the DB.  I have seen this change
at times, and cause similar problems.
 
Rick

On Thu, Jun 4, 2009 at 9:46 AM, Wacholz, Jeanette (Jenni)
 wrote:


** 
Hi Listers,
 
ARS V6.3 P020
ITSM 6
Oracle V10g
AIX 5.3
 
We have lost the ability to access one form via the User or the
Admin tool. The form is SHRCFG:ConfigPeople. If I look in TOAD, I can
see the view of the form. I can also see the t107, h107 and b107 tables
there. But the form is not visible or available from inside Remedy. I
believe I've seen issues similar to this on the list but I haven't been
successful finding them in the archives. The issue began last night
after our dba's installed Guardium on the db server. (ARSystem was
shutdown correctly before the dba's started their install and brought
back up after the install was completed.)
 
Any help you can offer would be appreciated!

Jenni Wacholz 
Coventry Health Care Inc 
Scottsdale AZ
480-445-2517 



 

Email Confidentiality Notice: The information contained in this
transmission is confidential, proprietary or privileged and may be
subject to protection under the law, including the Health Insurance
Portability and Accountability Act (HIPAA). The message is intended for
the sole use of the individual or entity to whom it is addressed. If you
are not the intended recipient, you are notified that any use,
distribution or copying of the message is strictly prohibited and may
subject you to criminal or civil penalties. If you received this
transmission in error, please contact the sender immediately by replying
to this email and delete the material from any computer. _Platinum
Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 


Email Confidentiality Notice: The information contained in this transmission is 
confidential, proprietary or privileged and may be subject to protection under 
the law, including the Health Insurance Portability and Accountability Act 
(HIPAA).

The message is intended for the sole use of the individual or  entity to whom 
it is addressed.  If you are not the intended recipient, you are notified that 
any use, distribution or copying of the message is strictly prohibited and may 
subject you to criminal or civil penalties.  If you received this transmission 
in error, please contact the sender immediately by replying to this email and 
delete the material from any  computer.

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

Odd table field issue

[William Rentfrow]

I'm working in a 6.3 CSS system (ARS Patch 25, appropriate User/Admin
tools)s
 
All of the table fields on every form I open do not show the correct
fields.  They show the fields for the form the table is located on and
not the fields from the selected table in the Admin tool.  Even if I
change the form the fields do not change.
 
We've tried rebooting, bouncing the AR Server, etc - I've never seen
this before.  It is essentially impossible at this point to edit
existing or add new table fields.  
 
Anyone run into this?  The only redeeming factor is that this system is
in the process of being replaced.
 
William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
Corporate Website, www.stratacominc.com  
Blog, www.williamrentfrow.com  
715-410-8156 C
 

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

Re: Useful information about BMC Analytics

[Guillaume Rheault]

This is a multi-part message in MIME format.
I will not even attempt to answer that...Hopefully someone at BMC can answer 
that...
Before I got the information below, I went to several support techs as you can 
imagine, since most people at BMC don't have a clear understanding of all this.

It could depend on the BMC Analytics version. The info below is from Analytics 
2.5

-Guillaume


-Original Message-
From: Action Request System discussion list(ARSList) on behalf of Tony 
Worthington
Sent: Thu 06/04/09 11:40 AM
To: arslist@ARSLIST.ORG
Subject: Re: Useful information about BMC Analytics
 
I remember hearing in Vancouver that you could purchase the universe and 
not the B/O components.  Maybe that was incorrect or has changed?


  Tony Worthington
  Sr. Technical Analyst
  Kohl's Department Stores
  N56 W17000 Ridgewood Drive
  Menomonee Falls, WI 53051
  262.703.7763 (phone)
  tony.worthing...@kohls.com
  www.kohls.com




From:
"Pierson, Shawn" 
To:
arslist@ARSLIST.ORG
Date:
06/04/2009 10:14 AM
Subject:
Re: Useful information about BMC Analytics
Sent by:
"Action Request System discussion list(ARSList)" 



** 
We have the opposite issue.  We have been Business Objects users for 
years, and we?ve owned BMC Analytics for a year and a half, but the 
?extra? BO server license is really useless for us since we put it on our 
production BOXI server.  BMC didn?t want to give us a discount even though 
we wouldn?t be using their BOXI licenses.
 
From: Action Request System discussion list(ARSList) [
mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault
Sent: Thursday, June 04, 2009 9:41 AM
To: arslist@ARSLIST.ORG
Subject: Useful information about BMC Analytics
 
** 
FYI
This is from a knowledgeable BMC support tech that was answering questions 
that I sent him.
Useful information to know about BMC Analytics:

Q. Can I use my BusinessObjects license to do web reporting on AR System 
forms? (Crystal Reports OEM for Remedy does not work on the web)
A. BMC Analytics includes BusinessObjects Professional, which does NOT 
include Crystal Reports or Crystal Report Server. The customer needs to 
purchase an upgrade to BO Premium through SAP/Business Objects directly. 
It should be noted, that there is not automated conversion of Crystal 
reports into WebI reports or vice versa, so use of the BO Premium simply 
entitles the user to work with multiple BusinessObjects content types and 
other add-on applications.

Q. What Business objects products am i licensed to use with the bmc 
analytics oem version of bo xi professional?
A. BMC Analytics includes BusinessObjects Professional, which licenses the 
BO Infoview Portal with WebIntelligence as the single content type enabled 
and used by the BMC Analytics for BSM product.  Use of the Desktop 
Intelligence, Infoview, and the Designer tool are enabled with the OEM 
license; however, BMC Analytics and all of its out-of-box reports are 
WebI-based content and therefore do not exploit or support the extended 
reporting capabilities available through Desktop Intelligence 
(client-based) UI.  The Designer Tool enables power users/administractors 
to do customization and other universe management operations.

The OEM BO Professional license does NOT include, entitle use of, or make 
use of the following Business Objects add-on products: Desktop 
Intelligence (content type), Crystal Reports, Crystal Report Server, BO 
Dashboards, BO Live Office, BO Voyager, or any other add-on products that 
are included in the BO Enterprise Premium solution suite.

-Guillaume 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
Are"_
Private and confidential as detailed here. If you cannot access hyperlink, 
please e-mail sender. 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
Are"_ 

**
CONFIDENTIALITY NOTICE: 
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of 
the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify 
us immediately at 262-703-7000.

CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves the 
right to retrieve and read any message created, sent and received.  Kohl's 
reserves the right to monitor messages by authorized Kohl's Associates at any 
time
without any further consent.


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

Re: Lost form reference

[Rick Cook]

Jenni, check the owner of the tables in the DB.  I have seen this change at
times, and cause similar problems.

Rick
On Thu, Jun 4, 2009 at 9:46 AM, Wacholz, Jeanette (Jenni)  wrote:

> ** Hi Listers,
>
> ARS V6.3 P020
> ITSM 6
> Oracle V10g
> AIX 5.3
>
> We have lost the ability to access one form via the User or the Admin tool.
> The form is SHRCFG:ConfigPeople. If I look in TOAD, I can see the view of
> the form. I can also see the t107, h107 and b107 tables there. But the form
> is not visible or available from inside Remedy. I believe I've seen issues
> similar to this on the list but I haven't been successful finding them in
> the archives. The issue began last night after our dba's installed Guardium
> on the db server. (ARSystem was shutdown correctly before the dba's started
> their install and brought back up after the install was completed.)
>
> Any help you can offer would be appreciated!
>
> Jenni Wacholz
> Coventry Health Care Inc
> Scottsdale AZ
> 480-445-2517
>
>
>
> Email Confidentiality Notice: The information contained in this
> transmission is confidential, proprietary or privileged and may be subject
> to protection under the law, including the Health Insurance Portability and
> Accountability Act (HIPAA). The message is intended for the sole use of the
> individual or entity to whom it is addressed. If you are not the intended
> recipient, you are notified that any use, distribution or copying of the
> message is strictly prohibited and may subject you to criminal or civil
> penalties. If you received this transmission in error, please contact the
> sender immediately by replying to this email and delete the material from
> any computer. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where
> the Answers Are"_

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

AW: Lost form reference

[Conny Martin]

Jenni,
 
there should be some errors in arerror.log regarding this problem.
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Wacholz, Jeanette (Jenni)
Gesendet: Donnerstag, 4. Juni 2009 18:47
An: arslist@ARSLIST.ORG
Betreff: Lost form reference


** 
Hi Listers,
 
ARS V6.3 P020
ITSM 6
Oracle V10g
AIX 5.3
 
We have lost the ability to access one form via the User or the Admin
tool. The form is SHRCFG:ConfigPeople. If I look in TOAD, I can see the
view of the form. I can also see the t107, h107 and b107 tables there.
But the form is not visible or available from inside Remedy. I believe
I've seen issues similar to this on the list but I haven't been
successful finding them in the archives. The issue began last night
after our dba's installed Guardium on the db server. (ARSystem was
shutdown correctly before the dba's started their install and brought
back up after the install was completed.)
 
Any help you can offer would be appreciated!

Jenni Wacholz 
Coventry Health Care Inc 
Scottsdale AZ
480-445-2517 



 

Email Confidentiality Notice: The information contained in this
transmission is confidential, proprietary or privileged and may be
subject to protection under the law, including the Health Insurance
Portability and Accountability Act (HIPAA). The message is intended for
the sole use of the individual or entity to whom it is addressed. If you
are not the intended recipient, you are notified that any use,
distribution or copying of the message is strictly prohibited and may
subject you to criminal or civil penalties. If you received this
transmission in error, please contact the sender immediately by replying
to this email and delete the material from any computer. _Platinum
Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 

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

Lost form reference

[Wacholz, Jeanette (Jenni)]

Hi Listers,
 
ARS V6.3 P020
ITSM 6
Oracle V10g
AIX 5.3
 
We have lost the ability to access one form via the User or the Admin
tool. The form is SHRCFG:ConfigPeople. If I look in TOAD, I can see the
view of the form. I can also see the t107, h107 and b107 tables there.
But the form is not visible or available from inside Remedy. I believe
I've seen issues similar to this on the list but I haven't been
successful finding them in the archives. The issue began last night
after our dba's installed Guardium on the db server. (ARSystem was
shutdown correctly before the dba's started their install and brought
back up after the install was completed.)
 
Any help you can offer would be appreciated!

Jenni Wacholz 
Coventry Health Care Inc 
Scottsdale AZ
480-445-2517 



 


Email Confidentiality Notice: The information contained in this transmission is 
confidential, proprietary or privileged and may be subject to protection under 
the law, including the Health Insurance Portability and Accountability Act 
(HIPAA).

The message is intended for the sole use of the individual or  entity to whom 
it is addressed.  If you are not the intended recipient, you are notified that 
any use, distribution or copying of the message is strictly prohibited and may 
subject you to criminal or civil penalties.  If you received this transmission 
in error, please contact the sender immediately by replying to this email and 
delete the material from any  computer.

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

Re: Error while setting a Group name in the assignee field (only in Webclient)

[LJ Longwing]

If I'm not mistaken, the assignee field (id 4), HAS to be a user, and cannot
be a group.

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Bhupesh Gupta
Sent: Thursday, June 04, 2009 10:14 AM
To: arslist@ARSLIST.ORG
Subject: Re: Error while setting a Group name in the assignee field (only in
Webclient)


** 

Error while setting a Group name in the assignee field (only in Webclient)
 
you can not translate the group name in the group list or assignee group
field: row level group
 

 
 
Remedy Version : 7.5
DB : Oracle
 
Any clues folks..

-- 
Regards,
Bhupesh Gupta 





-- 
Regards,
Bhupesh Gupta _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where
the Answers Are"_ 

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

Re: Error while setting a Group name in the assignee field (only in Webclient)

[Bhupesh Gupta]

Error while setting a Group name in the assignee field (only in Webclient)

you can not translate the group name in the group list or assignee group
field: row level group


>
>
> Remedy Version : 7.5
> DB : Oracle
>
> Any clues folks..
>
> --
> Regards,
> Bhupesh Gupta
>
>


-- 
Regards,
Bhupesh Gupta

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

Re: AW: Remedy 7.0 issue with Direct SQL in a filter

[Scott Fluegge]

All,

Thanks for your suggestions.  I looked into the logs and played with the SQL
some more and got resolution.  First thing I noticed once it started working
is that when you trigger a filter on save and/or modify of a field and
reference that field from the database, you get the value BEFORE the update
and not after.  So, I re-worked it and used the power of SQL against the
field record and not the database entry and it worked.  Below is the query I
used in case any are interested.

update HPD_Help_Desk set SLM_EMAIL_TO = (rtrim(ltrim(substring('$Assigned
Group$', Charindex('-', '$Assigned Group$') + 1, Len('$Assigned Group$'
+ 't...@client.com'), SLM_EMAIL_CC = (rtrim(ltrim(substring('$Assigned
Group$', Charindex('-', '$Assigned Group$') + 1, Len('$Assigned Group$'
+ 't...@client.com') + '; ' + (rtrim(ltrim(substring('$Assigned Group$',
Charindex('-', '$Assigned Group$') + 1, Len('$Assigned Group$' +
't...@client.com'), SLM_EMAIL_BCC = 'serviced...@gssamerica.com' where
(Incident_Number = '$Incident Number$' and (upper('$Assigned Group$') like
upper('%Tier 4%')))

Thanks,

Scott
Scott Fluegge
CIO & Sr. VP of Operations
GSS America Infotech Ltd., A SEI-CMMI Level 3 certified company 
Third Floor, Block ‘B’,
Cyber Gateway, HITEC City, Madhapur, 
Hyderabad - 500 081. AP. India
Phone : 91 40 44556600 ext: 312
Mobile: 91 970118
VoIP: (847) 307 7606 ext: 250
Email: scott.flue...@gssamerica.com
Visit: http://www.gssamerica.com


-Original Message-
From: Peter Romain [mailto:p.romain.arsl...@parsolutions.co.uk] 
Sent: Wednesday, June 03, 2009 3:15 PM
Subject: Re: AW: Remedy 7.0 issue with Direct SQL in a filter

Scott,

You may find extra quotes are being inserted into the SQL.

Try building the complete SQL statement in a Remedy temp field and using
just this field in the direct sql action (Direct SQL -> $temp field$).

Cheers

Peter



> Scott,
>
> turn on SQL-Logging and you'll see the statement wich the arserver is
> issueing against the database. I think this should point you in the
> right direction.
>
> HTH
>
> Kind Regards Conny
>
> 
>
> Von: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] Im Auftrag von Scott Fluegge
> Gesendet: Mittwoch, 3. Juni 2009 09:53
> An: arslist@ARSLIST.ORG
> Betreff: Remedy 7.0 issue with Direct SQL in a filter
> Wichtigkeit: Hoch
>
>
> **
>
> Anyone able to help me on a potentially simple Remedy question that has
> my team stumped?
>
>
>
> This is in regards to a Remedy customization we need to do in our
> environment.  It is with respect to custom filters invoking Direct SQL
> (MS SQL 2005 database).  The SQL works PERFECT from the enterprise
> manager but doesn't execute the complex query in Remedy.  I did 4 direct
> SQL statements.  3 are complex and don't do anything.  The simple 4th
> test (all are table updates) does work.  I can't for the life of me
> figure out why the others fail.  I am pasting the SQL here in case you
> can look into it...  I am desperate!!!  We are writing to hidden objects
> within the incident record which SLM will use for notification.
>
>
>
> Here is a sample that works:
>
> update HPD_Help_Desk set SLP_EMAIL_TO = 'email_address_here' where
> Incident_Number = '$Incident_Number$' and Assigned_Group like '%TIER 2%'
>
>
>
> And this one does nothing... (No errors unless I invalidate the SQL so
> seems a matching issue):
>
> update HPD_Help_Desk set SLM_EMAIL_TO =
> (rtrim(ltrim(substring(Assigned_Group, Charindex('-', Assigned_Group) +
> 1, Len(Assigned_Group + 't...@client.com'), SLM_EMAIL_BCC =
> 'serviced...@gssamerica.com' where Incident_Number = '$Incident_Number$'
> and Assigned_Group like '%TIER 2%'
>
>
>
> Can you help me???  Just to re-iterate, the SQL works perfect from SQL
> Enterprise Manager (just changing the $Incident_Number$ to a real
> number) so I know it is not a simple SQL error...
>
> Thanks,
>
>
>
> Scott
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>
>

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


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

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

Re: Useful information about BMC Analytics

[Tony Worthington]

I remember hearing in Vancouver that you could purchase the universe and 
not the B/O components.  Maybe that was incorrect or has changed?


  Tony Worthington
  Sr. Technical Analyst
  Kohl's Department Stores
  N56 W17000 Ridgewood Drive
  Menomonee Falls, WI 53051
  262.703.7763 (phone)
  tony.worthing...@kohls.com
  www.kohls.com




From:
"Pierson, Shawn" 
To:
arslist@ARSLIST.ORG
Date:
06/04/2009 10:14 AM
Subject:
Re: Useful information about BMC Analytics
Sent by:
"Action Request System discussion list(ARSList)" 



** 
We have the opposite issue.  We have been Business Objects users for 
years, and we?ve owned BMC Analytics for a year and a half, but the 
?extra? BO server license is really useless for us since we put it on our 
production BOXI server.  BMC didn?t want to give us a discount even though 
we wouldn?t be using their BOXI licenses.
 
From: Action Request System discussion list(ARSList) [
mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault
Sent: Thursday, June 04, 2009 9:41 AM
To: arslist@ARSLIST.ORG
Subject: Useful information about BMC Analytics
 
** 
FYI
This is from a knowledgeable BMC support tech that was answering questions 
that I sent him.
Useful information to know about BMC Analytics:

Q. Can I use my BusinessObjects license to do web reporting on AR System 
forms? (Crystal Reports OEM for Remedy does not work on the web)
A. BMC Analytics includes BusinessObjects Professional, which does NOT 
include Crystal Reports or Crystal Report Server. The customer needs to 
purchase an upgrade to BO Premium through SAP/Business Objects directly. 
It should be noted, that there is not automated conversion of Crystal 
reports into WebI reports or vice versa, so use of the BO Premium simply 
entitles the user to work with multiple BusinessObjects content types and 
other add-on applications.

Q. What Business objects products am i licensed to use with the bmc 
analytics oem version of bo xi professional?
A. BMC Analytics includes BusinessObjects Professional, which licenses the 
BO Infoview Portal with WebIntelligence as the single content type enabled 
and used by the BMC Analytics for BSM product.  Use of the Desktop 
Intelligence, Infoview, and the Designer tool are enabled with the OEM 
license; however, BMC Analytics and all of its out-of-box reports are 
WebI-based content and therefore do not exploit or support the extended 
reporting capabilities available through Desktop Intelligence 
(client-based) UI.  The Designer Tool enables power users/administractors 
to do customization and other universe management operations.

The OEM BO Professional license does NOT include, entitle use of, or make 
use of the following Business Objects add-on products: Desktop 
Intelligence (content type), Crystal Reports, Crystal Report Server, BO 
Dashboards, BO Live Office, BO Voyager, or any other add-on products that 
are included in the BO Enterprise Premium solution suite.

-Guillaume 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
Are"_
Private and confidential as detailed here. If you cannot access hyperlink, 
please e-mail sender. 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
Are"_ 

**
CONFIDENTIALITY NOTICE: 
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of 
the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify 
us immediately at 262-703-7000.

CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves the 
right to retrieve and read any message created, sent and received.  Kohl's 
reserves the right to monitor messages by authorized Kohl's Associates at any 
time
without any further consent.
<>

Re: WWRUG09 Hotel Registration: Hard Rock Hotel / Las Vegas

[Susan Palmer]

Signed, sealed, delivered and paid.  Already made the hotel reservations and
checked out flights.

Quite frankly I think for the price this is far more what all of us want
than what we've had in recent years.  Stellar thought to include tutorials
as part of the schedule.  Kudos for that!

AND ... such active participation from Doug promoting this.  VERY
IMPRESSIVE!  I'm really looking forward to it.  Good time of the year, good
location, nice hotel (I assume the sessions are right in the hotel), just an
overall wonderful job.

Thanks to all the hard work by Dan, Lenny, Phil and Joel  and anyone
else I've missed!

I'm so excited and I just can't hide it
I'm about to lose control and I think I like it
I'm so excited and I just can't hide it
And I know I know I know I know I know I want it!

Ok ... no song writer here  just a music lover!

Have you all signed up already too?  We need to show our support  for this
effort to insure it's success.  I didn't wait for company dollars, put my
own funds out there because this is important and vital to our Remedy
community.

See you all there!

Susan


On Tue, Jun 2, 2009 at 6:37 AM, Daniel Bloom  wrote:

> **
>
> WWRUG09 is happening at the Hard Rock Hotel in Las Vegas NV
> Stay close to the action with a room on-site at the HRH.
>
> WWRUG09 Conference rates are $79/night for the entire conference, Nov 9 -
> Nov 13, 2009,
>
> with some rooms available at that rate for a few days before and after.
>
>
> Follow the  'Accommodations' link at www.WWRUG.com to 
> the Hard Rock Hotel reservation page.
>
> (the Accommodations link is at the bottom of each page)
>
> WWRUG09: the Other November event.
>
>
>
> questions or comments about the conference? email wwrug2...@wwrug.org
>
>
>
>  Daniel
>
> Daniel Bloom, Conference Chair
>
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_

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

Re: Useful information about BMC Analytics

[Pierson, Shawn]

We have the opposite issue.  We have been Business Objects users for years, and 
we've owned BMC Analytics for a year and a half, but the "extra" BO server 
license is really useless for us since we put it on our production BOXI server. 
 BMC didn't want to give us a discount even though we wouldn't be using their 
BOXI licenses.

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault
Sent: Thursday, June 04, 2009 9:41 AM
To: arslist@ARSLIST.ORG
Subject: Useful information about BMC Analytics

**

FYI
This is from a knowledgeable BMC support tech that was answering questions that 
I sent him.
Useful information to know about BMC Analytics:

Q. Can I use my BusinessObjects license to do web reporting on AR System forms? 
(Crystal Reports OEM for Remedy does not work on the web)
A. BMC Analytics includes BusinessObjects Professional, which does NOT include 
Crystal Reports or Crystal Report Server. The customer needs to purchase an 
upgrade to BO Premium through SAP/Business Objects directly.  It should be 
noted, that there is not automated conversion of Crystal reports into WebI 
reports or vice versa, so use of the BO Premium simply entitles the user to 
work with multiple BusinessObjects content types and other add-on applications.

Q. What Business objects products am i licensed to use with the bmc analytics 
oem version of bo xi professional?
A. BMC Analytics includes BusinessObjects Professional, which licenses the BO 
Infoview Portal with WebIntelligence as the single content type enabled and 
used by the BMC Analytics for BSM product.  Use of the Desktop Intelligence, 
Infoview, and the Designer tool are enabled with the OEM license; however, BMC 
Analytics and all of its out-of-box reports are WebI-based content and 
therefore do not exploit or support the extended reporting capabilities 
available through Desktop Intelligence (client-based) UI.  The Designer Tool 
enables power users/administractors to do customization and other universe 
management operations.

The OEM BO Professional license does NOT include, entitle use of, or make use 
of the following Business Objects add-on products: Desktop Intelligence 
(content type), Crystal Reports, Crystal Report Server, BO Dashboards, BO Live 
Office, BO Voyager, or any other add-on products that are included in the BO 
Enterprise Premium solution suite.

-Guillaume
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

Private and confidential as detailed here: 
http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the 
link, please e-mail sender.

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

Re: BMC KB site - now 100% less useful than before!

[Tami Palacky]

i have never had success with KB searches on the BMC website and that
is why i rarely use it.

On Jun 4, 8:53 am, "Rodriguez, Rafael J x23718"
 wrote:
> THIS IS SO TRUE! I hardly search KB on BMC site anymore as it never
> gives you a direct result.
>
> -Rafael
>
> 
>
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Sanford, Claire
> Sent: Wednesday, June 03, 2009 4:01 PM
> To: arsl...@arslist.org
> Subject: Re: BMC KB site - now 100% less useful than before!
>
> I so agree!  I did a search on  "ARERR" and it returned 3 articles!  
>
> It is a loose situation!  They may lose too!!
>
> I searched archives of the list and found a conversation regarding my
> problem from 2006 that was more helpful.  It didn't answer the problem,
> but it at least pointed me in the right direction.
>
> 
>
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault
> Sent: Wednesday, June 03, 2009 2:11 PM
> To: arsl...@arslist.org
> Subject: Re: BMC KB site - now 100% less useful than before!
>
> **
>
> All this is to the detriment of BMC support itself, because the KB isn't
> working now (and before this problem, it was not very good anyway), so
> we'll have to keep submitting more tickets to BMC support for things
> that we should be able to find in the KB in the first place. This in
> turn may raise support fees, or at least eats into R&D dollars. It's a
> loose-loose situation for everybody
>
> -Guillaume
>
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) on behalf of Rick
>
> Cook
> Sent: Wed 06/03/09 2:12 PM
> To: arsl...@arslist.org
> Subject: BMC KB site - now 100% less useful than before!
>
> I can't even search for something like "license" and get even ONE
> result,
> despite leaving the search criteria wide open.  I need some information
> that
> I know is (was?) probably out there, but I can't get to it since they
> "upgraded" the site recently.
>
> Does anyone have any idea who to contact about this?  There is no
> "Contact
> the webmaster" or some such on the page, either.
>
> Rick
>
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>
> This message and any attachments are intended only for the use of the 
> addressee and
> may contain information that is privileged and confidential. If the reader of 
> the
> message is not the intended recipient or an authorized representative of the
> intended recipient, you are hereby notified that any dissemination of this
> communication is strictly prohibited. If you have received this communication 
> in
> error, please notify us immediately by e-mail and delete the message and any
> attachments from your system.
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"- 
> Hide quoted text -
>
> - Show quoted text -

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

Re: BMC KB site - now 100% less useful than before!

[Rick Cook]

True, Mark, and I understand that the core issue is with a non-BMC component.  
But wasn't the announcement posted days after the issue was known?

And if the ETA is still unknown, is rolling back to the prior version an option 
until then? It is what BMC's customers do all the time when their testing 
misses something. 

Rick

-Original Message-
From: "Walters, Mark" 

Date: Thu, 4 Jun 2009 14:56:43 
To: 
Subject: Re: BMC KB site - now 100% less useful than before!


BMC are aware that there is a problem with KB searches at the moment - this is 
from the support web site;

Latest Support News
We are currently experiencing technical difficulties with our Knowledge Base 
Search functionality, which is causing inconsistent search results to be 
returned. We apologize for the inconvenience and are working to resolve the 
problem as quickly as possible.
Mark

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Rodriguez, Rafael J x23718
Sent: 04 June 2009 13:54
To: arslist@ARSLIST.ORG
Subject: Re: BMC KB site - now 100% less useful than before!

**
THIS IS SO TRUE! I hardly search KB on BMC site anymore as it never gives 
you a direct result.

-Rafael


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Sanford, Claire
Sent: Wednesday, June 03, 2009 4:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMC KB site - now 100% less useful than before!

I so agree!  I did a search on  "ARERR" and it returned 3 articles!

It is a loose situation!  They may lose too!!

I searched archives of the list and found a conversation regarding my problem 
from 2006 that was more helpful.  It didn't answer the problem, but it at least 
pointed me in the right direction.


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault
Sent: Wednesday, June 03, 2009 2:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMC KB site - now 100% less useful than before!
**

All this is to the detriment of BMC support itself, because the KB isn't 
working now (and before this problem, it was not very good anyway), so we'll 
have to keep submitting more tickets to BMC support for things that we should 
be able to find in the KB in the first place. This in turn may raise support 
fees, or at least eats into R&D dollars. It's a loose-loose situation for 
everybody

-Guillaume


-Original Message-
From: Action Request System discussion list(ARSList) on behalf of Rick Cook
Sent: Wed 06/03/09 2:12 PM
To: arslist@ARSLIST.ORG
Subject: BMC KB site - now 100% less useful than before!

I can't even search for something like "license" and get even ONE result,
despite leaving the search criteria wide open.  I need some information that
I know is (was?) probably out there, but I can't get to it since they
"upgraded" the site recently.

Does anyone have any idea who to contact about this?  There is no "Contact
the webmaster" or some such on the page, either.

Rick

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

This message and any attachments are intended only for the use of the addressee 
and

may contain information that is privileged and confidential. If the reader of 
the

message is not the intended recipient or an authorized representative of the

intended recipient, you are hereby notified that any dissemination of this

communication is strictly prohibited. If you have received this communication in

error, please notify us immediately by e-mail and delete the message and any

attachments from your system.





_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

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

Useful information about BMC Analytics

[Guillaume Rheault]

FYI
This is from a knowledgeable BMC support tech that was answering questions that 
I sent him.
Useful information to know about BMC Analytics:

Q. Can I use my BusinessObjects license to do web reporting on AR System forms? 
(Crystal Reports OEM for Remedy does not work on the web)
A. BMC Analytics includes BusinessObjects Professional, which does NOT include 
Crystal Reports or Crystal Report Server. The customer needs to purchase an 
upgrade to BO Premium through SAP/Business Objects directly.  It should be 
noted, that there is not automated conversion of Crystal reports into WebI 
reports or vice versa, so use of the BO Premium simply entitles the user to 
work with multiple BusinessObjects content types and other add-on applications.

Q. What Business objects products am i licensed to use with the bmc analytics 
oem version of bo xi professional?
A. BMC Analytics includes BusinessObjects Professional, which licenses the BO 
Infoview Portal with WebIntelligence as the single content type enabled and 
used by the BMC Analytics for BSM product.  Use of the Desktop Intelligence, 
Infoview, and the Designer tool are enabled with the OEM license; however, BMC 
Analytics and all of its out-of-box reports are WebI-based content and 
therefore do not exploit or support the extended reporting capabilities 
available through Desktop Intelligence (client-based) UI.  The Designer Tool 
enables power users/administractors to do customization and other universe 
management operations.

The OEM BO Professional license does NOT include, entitle use of, or make use 
of the following Business Objects add-on products: Desktop Intelligence 
(content type), Crystal Reports, Crystal Report Server, BO Dashboards, BO Live 
Office, BO Voyager, or any other add-on products that are included in the BO 
Enterprise Premium solution suite.

-Guillaume

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

Re: Understanding of Field_dispprop

[LJ Longwing]

Vijayalakshmi,
I'm willing to help you try to figure out the Java API if you would like.
What object is that a print of? 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Vijayalakshmi Paulraj
Sent: Thursday, June 04, 2009 1:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: Understanding of Field_dispprop

Thanks all, I am trying to create a Field in an existing form using Java API
call.

The field is getting created in the Field Table and not in the field_disprop
table, because the display properties are not set (as it is expecting...)

When I try to understand the display properties of another existing field,
(as below)

{536870912=[[X=6074,Y=5000], [X=31158,Y=7100]], 4=1, 7=2147483641,
20=Submitter,  21=[[X=0,Y=400], [X=6411,Y=2100]], 27=16, 28=4, 29=1, 60=1,
61=30, 65=[[X=0,Y=0 ], [X=0,Y=0]], 66=[[X=22722,Y=0], [X=25084,Y=2100]],
143=4294967295,
151=[[X=697
4,Y=0], [X=22159,Y=2100]]}

Now, can you please pass some ideas on how to interpret this??? Looks much
simpler than what is stored in the database on propshort column :)

Getting confused with too many X,Y Coordinates, my form has got only one
View ("Default Administrator View")

Is it documented anywhere??

All I just did is created a Regular form using Remedy Admin Tool.
Created a Field via the Java API call... my aim is to make it
visible(Field_Disprop should get populated in correct manner)

Thanks&Regards,
Vijayalakshmi Paulraj 


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of John
Sent: Wednesday, June 03, 2009 11:36 PM
To: arslist@ARSLIST.ORG
Subject: Re: Understanding of Field_dispprop

One thing you can do -- is export the form as an arxml -- lots of info  
is now easier to digest.

And BMC could change it -- but -- it would be easy to follow and fix.  
(IMHO)


-John


On Jun 3, 2009, at 9:25 AM, copits.rich...@bwc.state.oh.us wrote:

But where is all of these explanations documented??



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of LJ Longwing
Sent: Wednesday, June 03, 2009 10:22 AM
To: arslist@ARSLIST.ORG
Subject: Re: Understanding of Field_dispprop

Hehehe...easy maybe for someone that's been studying the field for as
many
years as you Misi...:)

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky
Sent: Wednesday, June 03, 2009 7:29 AM
To: arslist@ARSLIST.ORG
Subject: Re: Understanding of Field_dispprop

Hi,

It is pretty easy to understand the properties...

In the example below, the first number indicates the number of fields:
14

The second number 3 indicates the property 3 (AR_DPROP_BBOX in ar.h)

The third number 41 indicates a set of coordinates (AR_DATA_TYPE_COORDS)

Following the data-type is a number of field, in this case 4 that
corresponds to the coordinates 5399x2500 and 28233 and 4600.

The second field has id 4 (AR_DPROP_VISIBLE) with datatype 6
(AR_DATA_TYPE_ENUM) and value 1 (the value possibly corresponds to a
true).

And so on...

The 10 before Request ID is the size of a char-field.

Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at
http://rrr.se.

> Hi All,
>
> Please pass  ideas on what will get stored in the Field_disprop table
> when a new field is added to a form and how to interpret the column
> value of 'propshort'?
>
> For E.g., the value stored for the Request Id field when a fresh
> regular form is created is as below:
>
>
> 14\3\41\2\5399\2500\28233\4600\4\6\1\7\40\2147483642\20\4\10\Request
> ID\21\41\2\0\400\7086\2100\27\8\16\28\6\4\29\6\1\60\40\1\65\41\2\0\0\0
> \0 \143\40\4294967295\151\41\2\7649\0\22834\2100\170\40\0\231\6\1\
>
> Please pass some clue to interpret this
>
>
> Thanks & Regards,
> Vijayalakshmi Paulraj
>
>
>
> --
> --
>
> This message, including any attachments, contains confidential
> information intended for a specific individual and purpose, and is
> intended for the addressee only. Any unauthorized disclosure, use,
> dissemination, copying, or distribution of this message or any of its
> attachments or the information contained in this e-mail, or the taking

> of any action based on it, is strictly prohibited. If you are not the
> intended recipient, please notify the sender immediately by return
> e-mail and delete this message.
>
> --
> --
>
> __

how to make the field label appear in the error message o the web

[Remedy Maniac]

dear listers,

ARSystem 6.00.01
Mid-tiers 6.3 on Apache/Tomcat

on the user client whenever I get an error message because of no 
permission on a field I can read something like this:
"ARERR [331] You do not have write access (for this entry) to field :  
Originator"


So the name of the field "Originator" is displayed.

On the web it's different. I just get the ID. How can I make the field 
name also be displayed on the web?

Anybody any clue on this?

Serouche

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

Re: SLM Color Not Turning Yellow

[Rob Cvetkovski]

Howard,
 
That would be great if you can find out which filters needed to be updated.
I'm working with backline support but lets just say they are not exactly 
quickly providing the answers.




From: Action Request System discussion list(ARSList) on behalf of Howard Richter
Sent: Wed 03/06/2009 2:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: SLM Color Not Turning Yellow


** 
Rob,
 
It sounds like the issue I had with BMC last year. We needed to work with the 
back line people to get the issue resolved. I know they needed to patch a 
couple of the filters, however, I just dont remember which ones.
 
I will see if I have any notes on it, but make sure you have the latest patch 
of SLM installed.
 
Howard


On Wed, Jun 3, 2009 at 10:16 AM, Rob Cvetkovski  
wrote:


** 
Dear fellow ARListers,
 
I have an issue with SLM. I have 2 Milestones (80% and 100%) setup with 
2 different actions (obviously!).
When one Milestone fails, the SLM color on the top right hand corner of 
the incident remains green, until the 2nd Milestone fails, then turns red. The 
total escalations on the SLM tab sets to 1 and 2 respectively when each 
Milestone fails. One thing I do notice as well is when the first Milestone 
fails the SLM Status remains "Within the Service Target" when I believe it 
should set the status to "Service Target Breached" on yellow. When all 
Milestones fail, it sets the SLM Status to "All Targets Breached".
 
When an incident is created with multiple targets - and one target 
fails, the SLM color turns yellow then red if both targets fail.
 
My question isis this behaviour out-of-the-box for SLM to only turn 
yellow if one of multiple targets are attached or should it ALSO turn yellow 
with different Milestones as well? The customer is asking that if 1 Milestone 
fails that it turn yellow. 
 
I've created a ticket with BMC and tried some of their "methods" of 
resolving the issue.
I've rebuilt the data sources (filters), I have referenced KB20013624 
and modified the INT:HPDSLM:MeasurementStatusUpdate filter with the correct 
database values and still get the same issue. We are on AR 7.1 - patch 
6ITSM 7.03 patch 6 on SQL 2005.
 
Has anyone experienced this before? Please let me know. 
 
Thanks
Rob Cvetkovski
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
Are"_




-- 
Howard Richter
Red Hat Certified Technician
CompTIA Linux+ Certified
ITIL Foundation Certified 
E-Mail = hbr4...@gmail.com
LinkedIn Profile = http://www.linkedin.com/in/hbr4270
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ 

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

Re: BMC KB site - now 100% less useful than before!

[Walters, Mark]

BMC are aware that there is a problem with KB searches at the moment - this is 
from the support web site;

Latest Support News
We are currently experiencing technical difficulties with our Knowledge Base 
Search functionality, which is causing inconsistent search results to be 
returned. We apologize for the inconvenience and are working to resolve the 
problem as quickly as possible.
Mark

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Rodriguez, Rafael J x23718
Sent: 04 June 2009 13:54
To: arslist@ARSLIST.ORG
Subject: Re: BMC KB site - now 100% less useful than before!

**
THIS IS SO TRUE! I hardly search KB on BMC site anymore as it never gives 
you a direct result.

-Rafael


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Sanford, Claire
Sent: Wednesday, June 03, 2009 4:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMC KB site - now 100% less useful than before!

I so agree!  I did a search on  "ARERR" and it returned 3 articles!

It is a loose situation!  They may lose too!!

I searched archives of the list and found a conversation regarding my problem 
from 2006 that was more helpful.  It didn't answer the problem, but it at least 
pointed me in the right direction.


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault
Sent: Wednesday, June 03, 2009 2:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMC KB site - now 100% less useful than before!
**

All this is to the detriment of BMC support itself, because the KB isn't 
working now (and before this problem, it was not very good anyway), so we'll 
have to keep submitting more tickets to BMC support for things that we should 
be able to find in the KB in the first place. This in turn may raise support 
fees, or at least eats into R&D dollars. It's a loose-loose situation for 
everybody

-Guillaume


-Original Message-
From: Action Request System discussion list(ARSList) on behalf of Rick Cook
Sent: Wed 06/03/09 2:12 PM
To: arslist@ARSLIST.ORG
Subject: BMC KB site - now 100% less useful than before!

I can't even search for something like "license" and get even ONE result,
despite leaving the search criteria wide open.  I need some information that
I know is (was?) probably out there, but I can't get to it since they
"upgraded" the site recently.

Does anyone have any idea who to contact about this?  There is no "Contact
the webmaster" or some such on the page, either.

Rick

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

This message and any attachments are intended only for the use of the addressee 
and

may contain information that is privileged and confidential. If the reader of 
the

message is not the intended recipient or an authorized representative of the

intended recipient, you are hereby notified that any dissemination of this

communication is strictly prohibited. If you have received this communication in

error, please notify us immediately by e-mail and delete the message and any

attachments from your system.





_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

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

Re: BMC KB site - now 100% less useful than before!

[Rodriguez, Rafael J x23718]

THIS IS SO TRUE! I hardly search KB on BMC site anymore as it never
gives you a direct result.

 

-Rafael

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Sanford, Claire
Sent: Wednesday, June 03, 2009 4:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMC KB site - now 100% less useful than before!

 

I so agree!  I did a search on  "ARERR" and it returned 3 articles!  

 

It is a loose situation!  They may lose too!!

 

I searched archives of the list and found a conversation regarding my
problem from 2006 that was more helpful.  It didn't answer the problem,
but it at least pointed me in the right direction.

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault
Sent: Wednesday, June 03, 2009 2:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMC KB site - now 100% less useful than before!

** 

All this is to the detriment of BMC support itself, because the KB isn't
working now (and before this problem, it was not very good anyway), so
we'll have to keep submitting more tickets to BMC support for things
that we should be able to find in the KB in the first place. This in
turn may raise support fees, or at least eats into R&D dollars. It's a
loose-loose situation for everybody

-Guillaume


-Original Message-
From: Action Request System discussion list(ARSList) on behalf of Rick
Cook
Sent: Wed 06/03/09 2:12 PM
To: arslist@ARSLIST.ORG
Subject: BMC KB site - now 100% less useful than before!

I can't even search for something like "license" and get even ONE
result,
despite leaving the search criteria wide open.  I need some information
that
I know is (was?) probably out there, but I can't get to it since they
"upgraded" the site recently.

Does anyone have any idea who to contact about this?  There is no
"Contact
the webmaster" or some such on the page, either.

Rick


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

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_

This message and any attachments are intended only for the use of the addressee 
and
may contain information that is privileged and confidential. If the reader of 
the 
message is not the intended recipient or an authorized representative of the
intended recipient, you are hereby notified that any dissemination of this
communication is strictly prohibited. If you have received this communication in
error, please notify us immediately by e-mail and delete the message and any
attachments from your system.


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

Re: RESOLVED Re: Bad HPD Assignment Records

[Tony Worthington]

That Process Flow Bar is nothing but trouble, I tell ya... :-)

(Seriously though, we have a lot of issues with it - at least on patch005)


  Tony Worthington
  Sr. Technical Analyst
  Kohl's Department Stores
  N56 W17000 Ridgewood Drive
  Menomonee Falls, WI 53051
  262.703.7763 (phone)
  tony.worthing...@kohls.com
  www.kohls.com




From:
Frank Caruso 
To:
arslist@ARSLIST.ORG
Date:
06/04/2009 05:04 AM
Subject:
RESOLVED Re: Bad HPD Assignment Records
Sent by:
"Action Request System discussion list(ARSList)" 



** Looks like the problem has to do with users searching for a customer 
first (on an Incident) then using the Process Flow accelerator to move the 
ticket forward. When the window closes it is pushing 0 back to some date 
fields.

On Thu, May 28, 2009 at 5:29 PM, Lammey, Peter A.  wrote:
** 
Ive noticed that as well.  I have seen it typically with the first 
HPD:AssignmentLog entry for a particular ticket.
Obviously it is performing some Application-Business-Time-Add but the 
original date is not filled in so it assumes "0" time which depending on 
your server's timezone might put it at 12/31/1969 or 1/1/1970.
 
Never been pressed by my users to investigate this but I would be curious 
to know if there is a bug submitted to BMC about this.
 
ITSM 7.02 patch 005

Thanks 
Peter Lammey 
ESPN IT Client Architecture and Automation 
860-766-4761 
 

From: Action Request System discussion list(ARSList) [mailto:
arsl...@arslist.org] On Behalf Of Frank Caruso
Sent: Thursday, May 28, 2009 10:16 AM
To: arslist@ARSLIST.ORG 

Subject: Bad HPD Assignment Records

** 
Has anybody seen issues with ITSM 7 creating HPD Assignment records with 
Actual and Business Duration (Seconds) that are equal to roughly 40 years 
time? The seconds value are 1242994998 and bigger. Not all of the 
assignment records are like this.
 
I think what is happening is that a bad Date (DateTime) value is getting 
sent to this form and getting set to 12/31/1969 before calculations are 
made.
 
Thoughts?
 
Frank Caruso
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
Are"_ 
Please consider the environment before printing this e-mail.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
Are"_ 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
Are"_ 

**
CONFIDENTIALITY NOTICE: 
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of 
the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify 
us immediately at 262-703-7000.

CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves the 
right to retrieve and read any message created, sent and received.  Kohl's 
reserves the right to monitor messages by authorized Kohl's Associates at any 
time
without any further consent.
<>

Non clustered indices (ITSM 7.3)

[Frex Popo]

Hello everyone,
 
Found a number of join forms using a particular column in the join criteria. 
This column did not look it was indexed on the base form (i.e. HPD:Help Desk), 
so thought let's create one. When I tried to do so I got a SQL error: 
 

No se pudo crear índice no agrupado 'I1035_904003986_1' porque supera el máximo 
de 249 permitido por tabla o vista.  (SQL Server 1910) (ARERR 552). Failure 
during SQL operation to the database : 904003986 (ARWARN 552).
 
This simply means that the SQL server could not create the nonclustered index 
as it is beyond the maximum allowed. The form has 13 indexes. As a test I 
removed an existing non clustered index and create the new one and it works 
just fine, but of course I want to keep all the existing ones and be able to 
create the new one.
 
I checked the table definition in the SQL Enterprise client by running 
sp_helpindex and got a list of some 250 entries. Now, I don't have a non 
customised version of this form nor do I have another environment to check if 
this is all created by the remedy server, hence the question, does anyone have 
all these indices defined on the Help Desk form in their ITSM 7.0 installation?

I am using ARS 7.1 patch 4 / ITSM 7.3 / SQL server 2005.
 
Here is part of the 250 entries. 

index_name,index_description,index_keys
I1035_100019_1,nonclustered located on PRIMARY,C100019, C100018
I1035_100063_1,nonclustered located on PRIMARY,C100063, C100064, 
C100065
I1035_100079_1,nonclustered located on PRIMARY,C100079
I1035_100080_1,nonclustered located on PRIMARY,C100080
I1035_100161_1,nonclustered, unique located on PRIMARY,C100161
I1035_100427_1,nonclustered located on PRIMARY,C100427
I1035_100869_1,nonclustered located on PRIMARY,C100869
I1035_100875_1,nonclustered located on PRIMARY,C100875
I1035_179_1,nonclustered, unique located on PRIMARY,C179
I1035_20003_1,nonclustered located on PRIMARY,C20003, C20004, 
C20005
I1035_240001002_1,nonclustered located on PRIMARY,C240001002
I1035_4_1,nonclustered located on PRIMARY,C4
I1035_7_1,nonclustered located on PRIMARY,C7
missing_index_100016,nonclustered located on PRIMARY,C100079, C103009, 
C7
missing_index_100040,nonclustered located on PRIMARY,C100014, C100251, 
C100296, C100082, C100217
missing_index_100058,nonclustered located on PRIMARY,C100014, C100251, 
C100079, C100082, C100217
missing_index_100062,nonclustered located on PRIMARY,C100014, C100079, 
C100217, C100251, C100082
missing_index_100064,nonclustered located on PRIMARY,C100014, C100217, 
C100251, C100082
missing_index_100089,nonclustered located on PRIMARY,C100079, C7
.
.
.
.
missing_index_99846,nonclustered located on PRIMARY,C100099, C100251, C7
missing_index_99878,nonclustered located on PRIMARY,C100014, C100251, 
C100082
missing_index_99880,nonclustered located on PRIMARY,C100014, C100251, 
C100082, C100217
missing_index_99882,nonclustered located on PRIMARY,C100014, C100079, 
C100251, C100296, C100572, C100082, C100217
missing_index_99929,nonclustered located on PRIMARY,C7
PK__T1035__4032018A,clustered, unique, primary key located on PRIMARY,C1

Regards
frex




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

RESOLVED Re: Bad HPD Assignment Records

[Frank Caruso]

Looks like the problem has to do with users searching for a customer first
(on an Incident) then using the Process Flow accelerator to move the ticket
forward. When the window closes it is pushing 0 back to some date fields.

On Thu, May 28, 2009 at 5:29 PM, Lammey, Peter A.
wrote:

> ** Ive noticed that as well.  I have seen it typically with the first
> HPD:AssignmentLog entry for a particular ticket.
> Obviously it is performing some Application-Business-Time-Add but the
> original date is not filled in so it assumes "0" time which depending on
> your server's timezone might put it at 12/31/1969 or 1/1/1970.
>
> Never been pressed by my users to investigate this but I would be curious
> to know if there is a bug submitted to BMC about this.
>
> ITSM 7.02 patch 005
>
> Thanks
> Peter Lammey
> ESPN IT Client Architecture and Automation
> 860-766-4761
>
>
>  --
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org] *On Behalf Of *Frank Caruso
> *Sent:* Thursday, May 28, 2009 10:16 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Bad HPD Assignment Records
>
> **
>  Has anybody seen issues with ITSM 7 creating HPD Assignment records with
> Actual and Business Duration (Seconds) that are equal to roughly 40 years
> time? The seconds value are 1242994998 and bigger. Not all of the assignment
> records are like this.
>
> I think what is happening is that a bad Date (DateTime) value is getting
> sent to this form and getting set to 12/31/1969 before calculations are
> made.
>
> Thoughts?
>
> Frank Caruso
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
> --
> Please consider the environment before printing this e-mail.
>  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>

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

Release Notes v6

[Matt Worsdell]

Thanks to all those who sent them, I have a copy now.

Matt

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

Re: Understanding of Field_dispprop

[Vijayalakshmi Paulraj]

Thanks all, I am trying to create a Field in an existing form using Java
API call.

The field is getting created in the Field Table and not in the
field_disprop table, because the display properties are not set (as it
is expecting...)

When I try to understand the display properties of another existing
field, (as below)

{536870912=[[X=6074,Y=5000], [X=31158,Y=7100]], 4=1, 7=2147483641,
20=Submitter,
 21=[[X=0,Y=400], [X=6411,Y=2100]], 27=16, 28=4, 29=1, 60=1, 61=30,
65=[[X=0,Y=0
], [X=0,Y=0]], 66=[[X=22722,Y=0], [X=25084,Y=2100]], 143=4294967295,
151=[[X=697
4,Y=0], [X=22159,Y=2100]]}

Now, can you please pass some ideas on how to interpret this??? Looks
much simpler than what is stored in the database on propshort column :)

Getting confused with too many X,Y Coordinates, my form has got only one
View ("Default Administrator View")

Is it documented anywhere??

All I just did is created a Regular form using Remedy Admin Tool.
Created a Field via the Java API call... my aim is to make it
visible(Field_Disprop should get populated in correct manner)

Thanks&Regards, 
Vijayalakshmi Paulraj 


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of John
Sent: Wednesday, June 03, 2009 11:36 PM
To: arslist@ARSLIST.ORG
Subject: Re: Understanding of Field_dispprop

One thing you can do -- is export the form as an arxml -- lots of info  
is now easier to digest.

And BMC could change it -- but -- it would be easy to follow and fix.  
(IMHO)


-John


On Jun 3, 2009, at 9:25 AM, copits.rich...@bwc.state.oh.us wrote:

But where is all of these explanations documented??



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of LJ Longwing
Sent: Wednesday, June 03, 2009 10:22 AM
To: arslist@ARSLIST.ORG
Subject: Re: Understanding of Field_dispprop

Hehehe...easy maybe for someone that's been studying the field for as
many
years as you Misi...:)

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky
Sent: Wednesday, June 03, 2009 7:29 AM
To: arslist@ARSLIST.ORG
Subject: Re: Understanding of Field_dispprop

Hi,

It is pretty easy to understand the properties...

In the example below, the first number indicates the number of fields:
14

The second number 3 indicates the property 3 (AR_DPROP_BBOX in ar.h)

The third number 41 indicates a set of coordinates (AR_DATA_TYPE_COORDS)

Following the data-type is a number of field, in this case 4 that
corresponds to the coordinates 5399x2500 and 28233 and 4600.

The second field has id 4 (AR_DPROP_VISIBLE) with datatype 6
(AR_DATA_TYPE_ENUM) and value 1 (the value possibly corresponds to a
true).

And so on...

The 10 before Request ID is the size of a char-field.

Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at
http://rrr.se.

> Hi All,
>
> Please pass  ideas on what will get stored in the Field_disprop table
> when a new field is added to a form and how to interpret the column
> value of 'propshort'?
>
> For E.g., the value stored for the Request Id field when a fresh
> regular form is created is as below:
>
>
> 14\3\41\2\5399\2500\28233\4600\4\6\1\7\40\2147483642\20\4\10\Request
> ID\21\41\2\0\400\7086\2100\27\8\16\28\6\4\29\6\1\60\40\1\65\41\2\0\0\0
> \0 \143\40\4294967295\151\41\2\7649\0\22834\2100\170\40\0\231\6\1\
>
> Please pass some clue to interpret this
>
>
> Thanks & Regards,
> Vijayalakshmi Paulraj
>
>
>
> --
> --
>
> This message, including any attachments, contains confidential
> information intended for a specific individual and purpose, and is
> intended for the addressee only. Any unauthorized disclosure, use,
> dissemination, copying, or distribution of this message or any of its
> attachments or the information contained in this e-mail, or the taking

> of any action based on it, is strictly prohibited. If you are not the
> intended recipient, please notify the sender immediately by return
> e-mail and delete this message.
>
> --
> --
>
> __
> _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>



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