date:20060906


I have exactly the same behaviour on another (even simpler) AL on the
same box too, it's driving me crazy..

I highly appreciate any suggestions..

On 9/6/06, George Barsan [EMAIL PROTECTED] wrote:

Hi all,

I have here an older ARS application which I'm trying to extend and
consolidate.. It includes a nice little AL which runs behind a button
and has 7 actions:

0 set field locally
1 set field from another form
2 commit changes
3 open window / report
4 push fields (create a new request)
5 change field

The very same AL (I didn't modify it anyway) runs perfectly if I
connect to production but stops on the Dev Box at the Open Window
action, the log entries are:
ACTL  3: Open Dialog
ACTLServer: xyz
ACTLSchema: XX:XXX:XYZ
ACTLView:
ACTL /* Mon Sep 04 2006 15:14:30 */
ACTL Stop active link processing - On Control

That's it, no error, no warning.. I cleaned the client cache,
restartet both client  server, enabled  disabled and reimported the
AL from production, recreated the AL manually.. It works for a while
then and it suddenly stops working although I don't change anything..
Has anybody seen that before? It seems like an ARS bug to me, but I
unfortunately don't have access to the support site..

Server (applies both for Dev and Prod): ARS 6.3 P13 running on WinXP
Database: MS Sql on the same box (afaik v2000 8.00.2039)
Client/Admin: workstation a) 6.3 P18 and workstation b) 6.3 unpatched

Many thanks,

George



___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: AL stopped working (no changes on AL)

2006-09-06 Thread Timothy Powell

I hate to ask the is it plugged in type question, but.
The form it's trying to perform the push fields against DOES exist on the
dev server...right? 

What's the log from the other AL? What are the common attributes of the ALs
in question (if any)?

Tim

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of George Barsan
Sent: Wednesday, September 06, 2006 7:58 AM
To: arslist@ARSLIST.ORG
Subject: Re: AL stopped working (no changes on AL)

I have exactly the same behaviour on another (even simpler) AL on the same
box too, it's driving me crazy..

I highly appreciate any suggestions..

On 9/6/06, George Barsan [EMAIL PROTECTED] wrote:
 Hi all,

 I have here an older ARS application which I'm trying to extend and 
 consolidate.. It includes a nice little AL which runs behind a button 
 and has 7 actions:

 0 set field locally
 1 set field from another form
 2 commit changes
 3 open window / report
 4 push fields (create a new request)
 5 change field

 The very same AL (I didn't modify it anyway) runs perfectly if I 
 connect to production but stops on the Dev Box at the Open Window 
 action, the log entries are:
 ACTL  3: Open Dialog
 ACTLServer: xyz
 ACTLSchema: XX:XXX:XYZ
 ACTLView:
 ACTL /* Mon Sep 04 2006 15:14:30 */
 ACTL Stop active link processing - On Control

 That's it, no error, no warning.. I cleaned the client cache, 
 restartet both client  server, enabled  disabled and reimported the 
 AL from production, recreated the AL manually.. It works for a while 
 then and it suddenly stops working although I don't change anything..
 Has anybody seen that before? It seems like an ARS bug to me, but I 
 unfortunately don't have access to the support site..

 Server (applies both for Dev and Prod): ARS 6.3 P13 running on WinXP
 Database: MS Sql on the same box (afaik v2000 8.00.2039)
 Client/Admin: workstation a) 6.3 P18 and workstation b) 6.3 unpatched

 Many thanks,

 George



___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Problem with Remedy Archiving when adding Views to the form.

2006-09-06 Thread Ron Tavares

**
Hugo is correct, I am trying to add the Radio button field because Remedy failed to carry it over when I added it to the original form. The reason that failed, is because we added a new veiw (the 10th view), to original form and that view failed to carry over. Remedy says this is normal because you do not need views on the archive form. But what they are forgetting, is that when the views are not in sync, the Remedy System is unable to carry over new feilds.

Hugo,

I like your suggestion. It sounds like it would work, but I'm a little concerned about things like field IDs and the T#s of the archive table. These might change in the process, no?
On 9/6/06, Hugo Visser [EMAIL PROTECTED] wrote:

** Ian,As I understand adding fields to the archive form is just a work around for him, because Remedy's mechanism isn't adding those fields.What you could try is this, I haven't tested it (yes it's dirty):
Save your original form as a copy, turn on archiving on that copy so that the archive form you want is created. Then export the definition of the archive form and modify the form name. After that import the new archive form in place over the old archive form. Afterwards you can delete the copy and the copy archive.
Hope that works :)Oh and looking back in this thread I see a similar workaround is proposed, well, hopefully this one is usefull for the archives then.
Hugo

On 9/6/06, Ian Trimnell [EMAIL PROTECTED]
wrote:

Ron,
As James has since pointed out, you can not add data fields to an Archive form. Looking at Appendix E of the new V7 manual Form and Application Objects (or Chapter 7 of the V6 Configuring AR System) it says that 'Data fields (including radio) cannot be modified or added to an archive form. All other types, such as trim or table, can be added or modified.' It also states that fields in Archive forms created by AR System have read-only access.

The question that hasn't been asked yet (at least I haven't noticed it yet) is 'Why do you want to add a radio field to an Archive form?'
We have a mix of archive forms, some using the OOB feature, others where we had to set up an archiving facility before Remedy introduced it back in Version 6. I have had a few problems with setting up OOB archiving but eventually got the hang of it when I had passed the learning curve that accompanies these new features that Remedy adds in. I must admit that they appear to have improved it as the versions go on.

Cheers,
Ian

Ian Trimnell, AR System Lead Developer (amongst other jobs),Specialist Support Information Team, Academic Administrative Computing Service
Open University, MILTON KEYNES, UKPhone: 01908 653741 web: http://www.open.ac.uk/

Ron Tavares wrote:

Chris,YES!! that is exactly the issue. Thank You, for a while there I wasthinking I was the only one.As for Remedy's response, initially they opened a bug, SW00248651But then it appears they closed it saying, (and I quote from the support
e-mail)After evaluating the information provided in the open bug engineeringdetermined that the behavior is as expected, with no plan to change it inthe future. Per their comments: The main purpose of a shadow form is to keep
the archive(or audit) data. Views are not required for that.But this statement is only true if you NEVER add any additional fields.Now, after banging my head agains the wall a few times, I figured how to
work around this. By simply re-creating the field, from scratch, beingcareful to keep the same properties and ID, I was able to add the field tothe Archvie AND re-enabel Archiving. (Even though Remedy doesn't support
adding fields directly to the Archive form.) BUT, the problem I am havingis with the Radio Button field. Try creating one of these dirctly on thearchive form and you cannot set the attributes. They are grayed out.
.ron

__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___

__20060125___This posting was submitted with HTML in it___

Re: AL stopped working (no changes on AL)


Sorry, I forgot to mention that both AL are handling reporting and the
open window have open window actions running with window type =
Report and using Advanced mode..

On 9/6/06, George Barsan [EMAIL PROTECTED] wrote:

Hi Tim,

Thanks for the quick answer. The DEV environment is a full copy of the
production, all forms exist there as well (although containing test
data!).

The second AL having the same problems does the following actions:

  0 push fields (update existing request in another form)
  1 set fields from another form
  2 open window (yep, that's the one!)
  3 set fields from another form
  4 set field locally
  5 set field locally
  6 set field locally
  7 commit changes
  8 close window

That's the only AL running behind that button (and on another form
then the AL initially mentioned). The logs are:

ACTL Checking CM:LAU:BU_PrintAndSaveAsAttachment_000 (0)
ACTL - Passed qualification -- perform if actions
ACTL  0: Push Fields
ACTL To Schema Schema:Case on Server @
ACTL (536870991) = Template.rpt
ACTL (536871192) = Schema:Join:Reporting123
ACTL (536871203) = {Schema_Join_Reporting.ID} = '123'
ACTL (536871162) = 06/09/2006
ACTL (536871046) = test test test
ACTL  1: Set Fields
ACTL xAttachmentFormat (536871182) = portabledocformat
ACTL xDataSourceFormName (536871165) = Schema_Join_Reporting
ACTL xFileExtension (536870935) = .pdf
ACTL xReportDefinitionFile (536870927) = Template.rpt
ACTL xSelectionCriteria (536870926) = $ID$ = 'ID'
ACTL  2: Open Dialog
ACTLServer: xyz
ACTLSchema: Schema:Join:Reporting123
ACTLView:
ACTL /* Wed Sep 06 2006 13:22:10 */
ACTL Stop active link processing - On Control

And that's it :(

Many thanks,

George


On 9/6/06, Timothy Powell [EMAIL PROTECTED] wrote:
 I hate to ask the is it plugged in type question, but.
 The form it's trying to perform the push fields against DOES exist on the
 dev server...right?

 What's the log from the other AL? What are the common attributes of the ALs
 in question (if any)?

 Tim

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of George Barsan
 Sent: Wednesday, September 06, 2006 7:58 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: AL stopped working (no changes on AL)

 I have exactly the same behaviour on another (even simpler) AL on the same
 box too, it's driving me crazy..

 I highly appreciate any suggestions..

 On 9/6/06, George Barsan [EMAIL PROTECTED] wrote:
  Hi all,
 
  I have here an older ARS application which I'm trying to extend and
  consolidate.. It includes a nice little AL which runs behind a button
  and has 7 actions:
 
  0 set field locally
  1 set field from another form
  2 commit changes
  3 open window / report
  4 push fields (create a new request)
  5 change field
 
  The very same AL (I didn't modify it anyway) runs perfectly if I
  connect to production but stops on the Dev Box at the Open Window
  action, the log entries are:
  ACTL  3: Open Dialog
  ACTLServer: xyz
  ACTLSchema: XX:XXX:XYZ
  ACTLView:
  ACTL /* Mon Sep 04 2006 15:14:30 */
  ACTL Stop active link processing - On Control
 
  That's it, no error, no warning.. I cleaned the client cache,
  restartet both client  server, enabled  disabled and reimported the
  AL from production, recreated the AL manually.. It works for a while
  then and it suddenly stops working although I don't change anything..
  Has anybody seen that before? It seems like an ARS bug to me, but I
  unfortunately don't have access to the support site..
 
  Server (applies both for Dev and Prod): ARS 6.3 P13 running on WinXP
  Database: MS Sql on the same box (afaik v2000 8.00.2039)
  Client/Admin: workstation a) 6.3 P18 and workstation b) 6.3 unpatched
 
  Many thanks,
 
  George
 

 
 ___
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

 
___
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org




___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: AL stopped working (no changes on AL)

George, We are on p003 client, 18 server. The reason we can't upgrade the 
clients is that macros stops working if we have field 1005 in the form and the 
macro is using ASB ...:) ...Have tested all patches higher than 003 ...even ver 
7. 

What would life be without ARS bugs ...(Maybe better ...)

Is our problem client/server related ..Hmm interesting ...I don't know 
. Ask Dough ...

L ars

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of George Barsan
Sent: Wednesday, September 06, 2006 2:36 PM
To: arslist@ARSLIST.ORG
Subject: Re: AL stopped working (no changes on AL)


Lars,

which patch are you using? My initial guess was that it's client
related, but after testing the application on several workstations
(same behaviour on all of them) it seems like a server issue.

I unfortunately don't have access to the support website at the moment
and therefore can't verify if something is mentioned in the release
notes of the patches  13 (we're on server P13 here)..

George

On 9/6/06, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
 George, very interesting, to get this confirmed by another site, we have had 
 this problem in production since our upgrading to ver 6.3, problem: AL: Open 
 window action, report form - nothing happens, but if You resave the AL, it 
 works for a while, until next 'dying', just to resave (no real change just 
 make the save button to be highlighted). As far as I can see it's exactly the 
 same problem. We have replaced all Open window Actions/Report form with 
 embedded macros because of this problem, BMC have not been able to help us in 
 any way.

 L ars

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] Behalf Of Timothy Powell
 Sent: Wednesday, September 06, 2006 2:12 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: AL stopped working (no changes on AL)


 I hate to ask the is it plugged in type question, but.
 The form it's trying to perform the push fields against DOES exist on the
 dev server...right?

 What's the log from the other AL? What are the common attributes of the ALs
 in question (if any)?

 Tim

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of George Barsan
 Sent: Wednesday, September 06, 2006 7:58 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: AL stopped working (no changes on AL)

 I have exactly the same behaviour on another (even simpler) AL on the same
 box too, it's driving me crazy..

 I highly appreciate any suggestions..

 On 9/6/06, George Barsan [EMAIL PROTECTED] wrote:
  Hi all,
 
  I have here an older ARS application which I'm trying to extend and
  consolidate.. It includes a nice little AL which runs behind a button
  and has 7 actions:
 
  0 set field locally
  1 set field from another form
  2 commit changes
  3 open window / report
  4 push fields (create a new request)
  5 change field
 
  The very same AL (I didn't modify it anyway) runs perfectly if I
  connect to production but stops on the Dev Box at the Open Window
  action, the log entries are:
  ACTL  3: Open Dialog
  ACTLServer: xyz
  ACTLSchema: XX:XXX:XYZ
  ACTLView:
  ACTL /* Mon Sep 04 2006 15:14:30 */
  ACTL Stop active link processing - On Control
 
  That's it, no error, no warning.. I cleaned the client cache,
  restartet both client  server, enabled  disabled and reimported the
  AL from production, recreated the AL manually.. It works for a while
  then and it suddenly stops working although I don't change anything..
  Has anybody seen that before? It seems like an ARS bug to me, but I
  unfortunately don't have access to the support site..
 
  Server (applies both for Dev and Prod): ARS 6.3 P13 running on WinXP
  Database: MS Sql on the same box (afaik v2000 8.00.2039)
  Client/Admin: workstation a) 6.3 P18 and workstation b) 6.3 unpatched
 
  Many thanks,
 
  George
 

 
 ___
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

 ___
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

 ___
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: AL stopped working (no changes on AL)


Hi Nyall,

I didn't define the report server - my understanding was that it uses
the server I'm currently logged in if nothing is defined (I'm only
logged in into dev). I added the servername as you suggest, cleaned
the cache and restarted the client - still the same behaviour.. But a
good point, thanks for suggesting!

The report exists on the dev server too. As said, it even runs fine
partly - until it suddenly stopps for some unknown reason..

George



On 9/6/06, Nyall McCavitt [EMAIL PROTECTED] wrote:

Hi,

Just a thought.

Have you defined the Report Server option in the User Tool to point to
the dev server. If so, does the report exist on the Report form on dev
server?

If I have misread this problem then please ignore this.

Thanks.

Nyall

George Barsan wrote:
 Hi Tim,

 Thanks for the quick answer. The DEV environment is a full copy of the
 production, all forms exist there as well (although containing test
 data!).

 The second AL having the same problems does the following actions:

  0 push fields (update existing request in another form)
  1 set fields from another form
  2 open window (yep, that's the one!)
  3 set fields from another form
  4 set field locally
  5 set field locally
  6 set field locally
  7 commit changes
  8 close window

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org



___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: AL stopped working (no changes on AL)

If something is wrong, it should always be wrong, our problem is that the al is 
working for a while ...1-3 days...or even more ...after that ars gives up, 
'don't like this al anynmore' ...not logical ..so I can't say that anything is 
wrong in the code as we get it to work for a while. /L ars

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Nyall McCavitt
Sent: Wednesday, September 06, 2006 2:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: AL stopped working (no changes on AL)

Hi,

Just a thought.

Have you defined the Report Server option in the User Tool to point to 
the dev server. If so, does the report exist on the Report form on dev 
server?

If I have misread this problem then please ignore this.

Thanks.

Nyall

George Barsan wrote:
 Hi Tim,

 Thanks for the quick answer. The DEV environment is a full copy of the
 production, all forms exist there as well (although containing test
 data!).

 The second AL having the same problems does the following actions:

  0 push fields (update existing request in another form)
  1 set fields from another form
  2 open window (yep, that's the one!)
  3 set fields from another form
  4 set field locally
  5 set field locally
  6 set field locally
  7 commit changes
  8 close window

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: AL stopped working (no changes on AL)

100% matching our problem.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of George Barsan
Sent: Wednesday, September 06, 2006 2:53 PM
To: arslist@ARSLIST.ORG
Subject: Re: AL stopped working (no changes on AL)

Hi Nyall,

I didn't define the report server - my understanding was that it uses
the server I'm currently logged in if nothing is defined (I'm only
logged in into dev). I added the servername as you suggest, cleaned
the cache and restarted the client - still the same behaviour.. But a
good point, thanks for suggesting!

The report exists on the dev server too. As said, it even runs fine
partly - until it suddenly stopps for some unknown reason..

George

On 9/6/06, Nyall McCavitt [EMAIL PROTECTED] wrote:
 Hi,

 Just a thought.

 Have you defined the Report Server option in the User Tool to point to
 the dev server. If so, does the report exist on the Report form on dev
 server?

 If I have misread this problem then please ignore this.

 Thanks.

 Nyall

 George Barsan wrote:
  Hi Tim,

  Thanks for the quick answer. The DEV environment is a full copy of the
  production, all forms exist there as well (although containing test
  data!).

  The second AL having the same problems does the following actions:

   0 push fields (update existing request in another form)
   1 set fields from another form
   2 open window (yep, that's the one!)
   3 set fields from another form
   4 set field locally
   5 set field locally
   6 set field locally
   7 commit changes
   8 close window

 ___
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Administrative Access

2006-09-06 Thread Will Du Chene

**



Koyb:

Ohh... Now that is a loaded question. I am afraid that you have just hit on 
a real sort of sore spot with me. I have seen places out there that have done 
something similar, allowingnon-technical, non-programmer, non-developers 
with little background (or understanding!) with the application administrative 
rights to the installation. Frankly, that situation drives me nuts and makes the 
hair on the back of my neck stand. Believe me when I tell you that I am feeling 
your pain!

In the real world, your AR System administrator is the controller of such 
access. We're the gatekeepers and the developers. Typically, before even 
considering granting such rights to an account, the administrator would run the 
notion of granting the said rights to a project supervisor or some sort of other 
manager to get support for it - simply because of what the power that comes with 
the account can do. This is more or less a way of covering ones self in the 
event that the n00bie actually did something - ahem, bad.

If I were in your situation again, I would do what I typically do - set up 
a meeting with the powers that be and make my case. Explain to them the damage 
that this level of priviledge can do. Cover the facts and explain that - out of 
an organization of hundreds - there might only be one or two individuals that 
might have this role. Explain to them that the typical administrator has been 
doing this for years, and to actually do development work one has to be fairly 
knowledgeable about development (hopefully attended a class or two at some 
point)as a whole and have some experience with other forms of it.

If your counterpart is doing development in a production environment, that 
raises a really big, honkin', ugly-lookin' red flag. That's a no-no on a global 
scale and violates most of the change practices (and common sense) that I am 
aware of. This alone directly impacts your ability to support the system. You 
could explain that - if this other person does something nasty - you might not 
be able to correct it, or that recovery from it might involve recovering the 
database from it's last snapshot.

At the same time, you might want to give this other person the benefit of 
doubt. Perhaps their just doing what they are told to do. Yank their 
administrative rights from your production server and grant them on development. 
Put the new administrator back in the sand box where it belongs and let it play. 
This is not a bad approach at all because you are going to want ONE or maybe TWO 
(hopefully very seasoned) people with production access so that they can move 
changes over into your production environment, rather than letting it be a 
free-for-all in which cows can come falling out of the sky.

Finally, after you have made your case, and explained to them that they are 
on the path to making their installation look like something that came right 
outta H - E - double hockysticks and that it will be next to impossible to 
maintain, well... There are other opportunities out there. I'll fess up - I have 
seen a couple of installations that look really good on the outside, but - 
because some yo-yo higher on the food chain wanted something - looked like road 
kill inside. Yes, in those instances I did the best that I could, tried hard to 
fix it, and waited for something else. Ironically, my frustration level went 
away - AAahhh..

Best of luck with your this.

(Just more proof for my theory that managers are secretly a more evolved 
form of lemmings. If there is a cliff near by, and their buddies jump)







  - Original Message - 
  From: 
  Koyb P. Liabt 
  
  Newsgroups: 
  public.remedy.arsystem.general
  To: arslist@ARSLIST.ORG 
  Sent: Wednesday, September 06, 2006 7:13 
  AM
  Subject: Re: Administrative Access
  ** 
  
  Similar thought - 
  
  How is admin access given in most organizations? Who makes this 
  decision? What is the experience for other listers? How would you handle it if 
  you were responsible for the Remedy application, and some un-trained user is 
  given Admin rights by management.
  
  In my case, I am frustrated because I have an end-user (who is not a 
  Remedy developer) making changes straight on production, and not taking the 
  code thru development to testing, as I requested. And management has 
  given a end-user admin rights to do this.
  
  
  
  __20060125___This posting was 
  submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___

Re: AL stopped working (no changes on AL)

2006-09-06 Thread Kemes, Lisa

I had an AL just stop working all of the sudden and what I had to do was
delete it and then re-import the AL from the Prod server.  Sometimes
AL's get corrupted.  Now my AL has no more problems on my Dev server

If this does not work, at least it only takes a couple of minutes to
do

Hope this helps 

Lisa

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Nyall McCavitt
Sent: Wednesday, September 06, 2006 8:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: AL stopped working (no changes on AL)

Hi,

Just a thought.

Have you defined the Report Server option in the User Tool to point to
the dev server. If so, does the report exist on the Report form on dev
server?

If I have misread this problem then please ignore this.

Thanks.

Nyall

George Barsan wrote:
 Hi Tim,

 Thanks for the quick answer. The DEV environment is a full copy of the

 production, all forms exist there as well (although containing test 
 data!).

 The second AL having the same problems does the following actions:

  0 push fields (update existing request in another form)
  1 set fields from another form
  2 open window (yep, that's the one!)
  3 set fields from another form
  4 set field locally
  5 set field locally
  6 set field locally
  7 commit changes
  8 close window


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Administrative Access

2006-09-06 Thread Timothy Powell

**



Q: How is admin access 
given in most organizations? Who makes this decision? What is the 
experience for other listers?

A: In my experience, 
rights to modify WORKFLOW is only given to those with the training and 
development experiencenot untrained users that don't know what they are 
doing. The rights to modify CONFIGURATION 
DATA on the other hand is handed out much more freely.
In either case, most 
organizations only grant either of these rights after the user has had some type 
of training and/or experience. IMHO, only 
an organization that doesn't care about it's applications and impact to end 
users grants untrained people any type of rights that might result in unwanted 
functionality, data corruption or outright outages. Would your management give 
the same user, admin rights to their HR or accountingapplications or admin 
rights to all of their servers?

While we physically set 
the access, the ultimate decision of granting that accessusually lies with 
the owner of the support process and application. But if he/she values their 
job, they won't let people that don't have experience monkey around in their 
systems. When that untrained person does something that crashes the entire 
system andbrings the support functions in the company to a screeching 
haltsomebody is going to pay for it. 


Q: How would you handle 
it if you were responsible for the Remedy application, and some un-trained user 
is given Admin rights by management.

A: I'd probably ask 
myself a few questions:

1) Was the management 
person that granted the access the application/process owner?
2) Why was that user 
given access? Was it to start them off as a junior person and ramp them up so 
that in the long run they can assistme in myjob? Or was it given 
because the user is the management person's boyfriend/girlfriend that thought it 
would be "neat" to have access? If it's a boyfriend/girlfriend type issue and 
the grantor was not the application/process owner, I'd revoke the access and 
force the issue to the application/process ownerlevel.
3) If this was the case 
of somebody that management wanted to learn the app to assist me, haveI 
documentedmy change process (no changes on production, etc.) in writing 
and has that person continued to ignore that policy? If that's the case, that person needs to start 
followingthe internal processes for changing the system. If they don't, 
I'd revoke their access and force the issue.

If I did revoke the access, I'd haveall of my 
facts ready so thatI could immediately present them to the 
application/process owner to backup my actions and for consideration in making 
their decision. Lastly, I'd capture all of the 
decision discussions that I could via email, so that if the decision is made to 
still grant that access,I'd have a paper trail to back me up when the app 
goes up in smoke.

Bear in mind that the 
political ramifications of doing something like thiscan have negative 
impact on your career development path...in other words, it CAN get you 
fired.I'm not advocating a mutiny and I'm not saying you should do these 
things. These are thoughts that I and I alone have. 
I think that should cover 
the legal disclaimerfine print. :-)

I hope you kept all the 
emails you sent where you strongly advised management to NOT let that untrained 
person have access and where you pointed out issues that arose from this person 
doing things in production
;-)

Tim


From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Koyb P. LiabtSent: 
Wednesday, September 06, 2006 8:14 AMTo: 
arslist@ARSLIST.ORGSubject: Re: Administrative 
Access
** 

Similar thought - 

How is admin access given in most organizations? Who makes this 
decision? What is the experience for other listers? How would you handle it if 
you were responsible for the Remedy application, and some un-trained user is 
given Admin rights by management.

In my case, I am frustrated because I have an end-user (who is not a Remedy 
developer) making changes straight on production, and not taking the code thru 
development to testing, as I requested. And management has given a 
end-user admin rights to do this.



__20060125___This posting was 
submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___

Re: Administrative Access

2006-09-06 Thread Barber, Dave

**



Will,

We've got somethign 
similar in place - all of the core support team have full admin rights. 
Thankfully they don't realise what they have access to (and don't realise that 
if they just install the admin tool, they could do anything), so for the most 
part its pretty safe. That kinda falls over in a way that hasn't yet been 
realised by management - we're an american company, have gone through Sarbanes 
Oxley, and system access control being an important part, i would have thought 
it would have been picked up on by now. I'll have to suggest that security 
and access levels get reviewed when ITSM7 gets put into place.

You're right on about dev 
on a live system. In any application development environment you shouldn't 
ever be developing directly on a live system, just wy too dangerous. 
I've been having to of late, as our dev system had ARS6.3/ITSM6 installed on it, 
and our live system has ARS4.5.2/ITSM4 on it (that wasn't my choice, it was done 
by our server team, pretty irritating, I tell you).

Regards

Dave


From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Will Du CheneSent: 
06 September 2006 14:13To: arslist@ARSLIST.ORGSubject: Re: 
Administrative Access
** 



Koyb:

Ohh... Now that is a loaded question. I am afraid that you have just hit on 
a real sort of sore spot with me. I have seen places out there that have done 
something similar, allowingnon-technical, non-programmer, non-developers 
with little background (or understanding!) with the application administrative 
rights to the installation. Frankly, that situation drives me nuts and makes the 
hair on the back of my neck stand. Believe me when I tell you that I am feeling 
your pain!

In the real world, your AR System administrator is the controller of such 
access. We're the gatekeepers and the developers. Typically, before even 
considering granting such rights to an account, the administrator would run the 
notion of granting the said rights to a project supervisor or some sort of other 
manager to get support for it - simply because of what the power that comes with 
the account can do. This is more or less a way of covering ones self in the 
event that the n00bie actually did something - ahem, bad.

If I were in your situation again, I would do what I typically do - set up 
a meeting with the powers that be and make my case. Explain to them the damage 
that this level of priviledge can do. Cover the facts and explain that - out of 
an organization of hundreds - there might only be one or two individuals that 
might have this role. Explain to them that the typical administrator has been 
doing this for years, and to actually do development work one has to be fairly 
knowledgeable about development (hopefully attended a class or two at some 
point)as a whole and have some experience with other forms of it.

If your counterpart is doing development in a production environment, that 
raises a really big, honkin', ugly-lookin' red flag. That's a no-no on a global 
scale and violates most of the change practices (and common sense) that I am 
aware of. This alone directly impacts your ability to support the system. You 
could explain that - if this other person does something nasty - you might not 
be able to correct it, or that recovery from it might involve recovering the 
database from it's last snapshot.

At the same time, you might want to give this other person the benefit of 
doubt. Perhaps their just doing what they are told to do. Yank their 
administrative rights from your production server and grant them on development. 
Put the new administrator back in the sand box where it belongs and let it play. 
This is not a bad approach at all because you are going to want ONE or maybe TWO 
(hopefully very seasoned) people with production access so that they can move 
changes over into your production environment, rather than letting it be a 
free-for-all in which cows can come falling out of the sky.

Finally, after you have made your case, and explained to them that they are 
on the path to making their installation look like something that came right 
outta H - E - double hockysticks and that it will be next to impossible to 
maintain, well... There are other opportunities out there. I'll fess up - I have 
seen a couple of installations that look really good on the outside, but - 
because some yo-yo higher on the food chain wanted something - looked like road 
kill inside. Yes, in those instances I did the best that I could, tried hard to 
fix it, and waited for something else. Ironically, my frustration level went 
away - AAahhh..

Best of luck with your this.

(Just more proof for my theory that managers are secretly a more evolved 
form of lemmings. If there is a cliff near by, and their buddies jump)







  - Original Message - 
  From: 
  Koyb P. Liabt 
  
  Newsgroups: 
  public.remedy.arsystem.general
  To: arslist@ARSLIST.ORG 
  Sent:

Re: AL stopped working (no changes on AL)

Hi Fred, We don't use Advanced mode so I don't thinks that's is related 
Our actions in the al's are only:

Open window - Report Form
Report Type, does not matter, AR or CR - both gives the same problem.
Target - File or screen - does not matter- both gives the same problem.
Operation - Run
Location - Reporting Form



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Grooms, Frederick W
Sent: Wednesday, September 06, 2006 3:17 PM
To: arslist@ARSLIST.ORG
Subject: Re: AL stopped working (no changes on AL)


I just noticed the Advanced mode...   Do you need to use the Advanced
option?  Are you specifying the form to open in a Field (That's what the
advanced is supposed to be for).  Can you remove the Advanced option and
does the AL work?

Fred 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of George Barsan
Sent: Wednesday, September 06, 2006 7:29 AM
To: arslist@ARSLIST.ORG
Subject: Re: AL stopped working (no changes on AL)

Sorry, I forgot to mention that both AL are handling reporting and the
open window have open window actions running with window type = Report
and using Advanced mode..

On 9/6/06, George Barsan [EMAIL PROTECTED] wrote:
 Hi Tim,

 Thanks for the quick answer. The DEV environment is a full copy of the

 production, all forms exist there as well (although containing test 
 data!).

 The second AL having the same problems does the following actions:

   0 push fields (update existing request in another form)
   1 set fields from another form
   2 open window (yep, that's the one!)
   3 set fields from another form
   4 set field locally
   5 set field locally
   6 set field locally
   7 commit changes
   8 close window

 That's the only AL running behind that button (and on another form 
 then the AL initially mentioned). The logs are:

 ACTL Checking CM:LAU:BU_PrintAndSaveAsAttachment_000 (0)
 ACTL - Passed qualification -- perform if actions
 ACTL  0: Push Fields
 ACTL To Schema Schema:Case on Server @
 ACTL (536870991) = Template.rpt
 ACTL (536871192) = Schema:Join:Reporting123
 ACTL (536871203) = {Schema_Join_Reporting.ID} = '123'
 ACTL (536871162) = 06/09/2006
 ACTL (536871046) = test test test
 ACTL  1: Set Fields
 ACTL xAttachmentFormat (536871182) = portabledocformat
 ACTL xDataSourceFormName (536871165) =
Schema_Join_Reporting
 ACTL xFileExtension (536870935) = .pdf
 ACTL xReportDefinitionFile (536870927) = Template.rpt
 ACTL xSelectionCriteria (536870926) = $ID$ = 'ID'
 ACTL  2: Open Dialog
 ACTLServer: xyz
 ACTLSchema: Schema:Join:Reporting123
 ACTLView:
 ACTL /* Wed Sep 06 2006 13:22:10 */
 ACTL Stop active link processing - On Control

 And that's it :(

 Many thanks,

 George


 On 9/6/06, Timothy Powell [EMAIL PROTECTED] wrote:
  I hate to ask the is it plugged in type question, but.
  The form it's trying to perform the push fields against DOES exist 
  on the dev server...right?
 
  What's the log from the other AL? What are the common attributes of 
  the ALs in question (if any)?
 
  Tim
 
  -Original Message-
  From: Action Request System discussion list(ARSList) 
  [mailto:[EMAIL PROTECTED] On Behalf Of George Barsan
  Sent: Wednesday, September 06, 2006 7:58 AM
  To: arslist@ARSLIST.ORG
  Subject: Re: AL stopped working (no changes on AL)
 
  I have exactly the same behaviour on another (even simpler) AL on 
  the same box too, it's driving me crazy..
 
  I highly appreciate any suggestions..
 
  On 9/6/06, George Barsan [EMAIL PROTECTED] wrote:
   Hi all,
  
   I have here an older ARS application which I'm trying to extend 
   and consolidate.. It includes a nice little AL which runs behind a

   button and has 7 actions:
  
   0 set field locally
   1 set field from another form
   2 commit changes
   3 open window / report
   4 push fields (create a new request)
   5 change field
  
   The very same AL (I didn't modify it anyway) runs perfectly if I 
   connect to production but stops on the Dev Box at the Open Window 
   action, the log entries are:
   ACTL  3: Open Dialog
   ACTLServer: xyz
   ACTLSchema: XX:XXX:XYZ
   ACTLView:
   ACTL /* Mon Sep 04 2006 15:14:30 */ ACTL Stop active link 
   processing - On Control
  
   That's it, no error, no warning.. I cleaned the client cache, 
   restartet both client  server, enabled  disabled and reimported 
   the AL from production, recreated the AL manually.. It works for a

   while then and it suddenly stops working although I don't change
anything..
   Has anybody seen that before? It seems like an ARS bug to me, but 
   I unfortunately don't have access to the support site..
  
   Server (applies both for Dev and Prod): ARS

Re: ARSLIST AWARDS - For Dan

2006-09-06 Thread Keith Bunescu

We heard it was going to be in Vancouver, BC

  
Keith Bunescu
Resource Manager
 
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn
Sent: Wednesday, September 06, 2006 8:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS - For Dan

I don't know where in Houston would be appropriate.  I live in Houston
and while we do have hotels and convention centers that would work,
there's not as much of a night-life as other places nor is there any
real form of public transportation.  Plus I live here so it would be
better to be able to travel some.

On the other hand, the main offices of BMC are here (although not much
of a Remedy presence as far as I know) and it is one of the biggest
cities in the U.S.  If people want to come early or stay late over the
weekend they can always go to see NASA or the Enron building.

Just keep in mind that October still is not cool in Houston for most
people.  When you live here you get used to it and it does feel a lot
cooler than it would in July or August, but it's not like the
temperatures would be like San Francisco was last week.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Watson, Matthew (Melbourne)
Sent: Wednesday, September 06, 2006 1:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS - For Dan


I'm tipping Houston. I didn't think much of it at the time, but on the
last day of BUW I heard a few of the BMC admin staff who were helping
pack up some of the stalls talking about houston next year...

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Tuesday, 5 September 2006 3:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS - For Dan

I'll take Dallas or Houston 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire
Sent: Monday, September 04, 2006 11:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS - For Dan

maybe dallas...  
 
If it is houston... party at my house



From: Action Request System discussion list(ARSList) on behalf of Rick
cook
Sent: Sat 9/2/2006 9:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS - For Dan


**
About the only clues they gave was Fairly easy to get to and the date
(late Oct).   Hmmm...that tells me that it is not a major city, and that
holding it there in the fall is done for a reason - like to escape major
heat?
 
You could be right, Warren.  Houston, Vegas, Orlando, (in that order)
some southern city like that.  No others make sense.  Maybe D.C.?
 
Rick



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Warren Baltimore
Sent: Saturday, September 02, 2006 6:45 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS - For Dan


**
There is quite a bit of rumors about next year.  I'm thinking Texas.
 


 
On 9/1/06, Rick cook [EMAIL PROTECTED] wrote: 

** 
A double Amen from me!
 
Rick



From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG ] On Behalf Of Julie Rockwood
Sent: Friday, September 01, 2006 12:21 PM

To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS - For Dan


 

** I'll second that!
He even keeps us in line to keep the list from becoming
free-for-all - a thankless job.

THANKS DAN!!

At 01:07 PM 9/1/2006, you wrote:


** 
 
Let us not forget to thank Dan for the endless hours and
time
he dedicates all year long to keeping the ARSLIST up and
running 
 
And 
 
for all his efforts year after year for pulling together
the stat, the gifts and the entertainment to make the
ARSList
Awards a hit!!
 
 
Thank You Dan for all your hard work year after
year!!
 
 
Herb Partlow
President/CEO
IB Technical Consulting, Inc.
(O) 408-253-0344
(F) 408-253-0344
(C) 408-309-5316
[EMAIL PROTECTED]
http://www.ibtechnicalconsulting.com
http://www.ibtechnicalconsulting.com/ 
 
 
__20060125___This posting was
submitted with HTML in it___ 

__20060125___This posting was submitted with
HTML in it___ 
__20060125___This posting was submitted with
HTML in it___ 




--
Warren R.

Re: ARSLIST AWARDS - For Dan

2006-09-06 Thread Rick cook

That would be sweet - right up the road from me.

Rick

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Keith Bunescu
Sent: Wednesday, September 06, 2006 6:30 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS - For Dan

We heard it was going to be in Vancouver, BC

Keith Bunescu
Resource Manager

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn
Sent: Wednesday, September 06, 2006 8:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS - For Dan

I don't know where in Houston would be appropriate.  I live in Houston and
while we do have hotels and convention centers that would work, there's not
as much of a night-life as other places nor is there any real form of public
transportation.  Plus I live here so it would be better to be able to travel
some.

On the other hand, the main offices of BMC are here (although not much of a
Remedy presence as far as I know) and it is one of the biggest cities in the
U.S.  If people want to come early or stay late over the weekend they can
always go to see NASA or the Enron building.

Just keep in mind that October still is not cool in Houston for most people.
When you live here you get used to it and it does feel a lot cooler than it
would in July or August, but it's not like the temperatures would be like
San Francisco was last week.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Watson, Matthew (Melbourne)
Sent: Wednesday, September 06, 2006 1:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS - For Dan

I'm tipping Houston. I didn't think much of it at the time, but on the last
day of BUW I heard a few of the BMC admin staff who were helping pack up
some of the stalls talking about houston next year...

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Tuesday, 5 September 2006 3:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS - For Dan

I'll take Dallas or Houston 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire
Sent: Monday, September 04, 2006 11:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS - For Dan

maybe dallas...  

If it is houston... party at my house

From: Action Request System discussion list(ARSList) on behalf of Rick cook
Sent: Sat 9/2/2006 9:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS - For Dan

**
About the only clues they gave was Fairly easy to get to and the date
(late Oct).   Hmmm...that tells me that it is not a major city, and that
holding it there in the fall is done for a reason - like to escape major
heat?

You could be right, Warren.  Houston, Vegas, Orlando, (in that order) some
southern city like that.  No others make sense.  Maybe D.C.?

Rick

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Warren Baltimore
Sent: Saturday, September 02, 2006 6:45 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS - For Dan

**
There is quite a bit of rumors about next year.  I'm thinking Texas.

On 9/1/06, Rick cook [EMAIL PROTECTED] wrote: 

** 
A double Amen from me!

Rick

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG ] On Behalf Of Julie Rockwood
Sent: Friday, September 01, 2006 12:21 PM

To: arslist@ARSLIST.ORG
Subject: Re: ARSLIST AWARDS - For Dan

** I'll second that!
He even keeps us in line to keep the list from becoming free-for-all
- a thankless job.

THANKS DAN!!

At 01:07 PM 9/1/2006, you wrote:

** 

Let us not forget to thank Dan for the endless hours and
time
he dedicates all year long to keeping the ARSLIST up and
running 

And 

for all his efforts year after year for pulling together
the stat, the gifts and the entertainment to make the
ARSList
Awards a hit!!

Thank You Dan for all your hard work year after year!!

Herb Partlow
President/CEO
IB Technical Consulting, Inc.
(O) 408-253-0344
(F) 408-253-0344
(C) 408-309-5316
[EMAIL PROTECTED]
http://www.ibtechnicalconsulting.com
http://www.ibtechnicalconsulting.com/

Re: Question: Disable ODBC

2006-09-06 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: Question: Disable ODBC
**





Jason:

That is a great solution and is going in my 'hold' box for ARS tips and tricks I keep.
This is the main reason I stay on the list is the sharing of solutions that BMC would not have.

James McKenzie





From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller
Sent: Tuesday, September 05, 2006 7:52 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question: Disable ODBC



** I had a situation where I setup a contractor on a temporary basis with an ODBC connection to his MS Access database. We agreed that it was only for his use. He ended up placing it on a network share and letting everybody know it was there. I had some big performance concerns about multiple people starting to do a full dump of the CHG:Change and CHG:Task tables each time they want to see the latest data. Fortunately he pulled it before anybody had a chance to copy it.

I created a filter that fires on Get Entry. The Run If was $CLIENT-TYPE$ = 6 and $USER$ != myusername and I had a error message If Action. This gave me (logged in as a different user) an error in MS Access and Crystal Reports. I really liked this method because it didn't limit myself as the admin, CRD or the people who have a legitimate need to connect via ODBC.

Jason



On 9/5/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED]  wrote: 


 ** 


 Tyrone: 


 Why do you want to do this? ODBC is required for Crystal to access the Remedy database. Is there a performance issue that needs to be addressed instead?

 And, yes, I would like to know this too. It may involve shutting down the entire interface through the ar.cfg(ar.conf) file.

 James Mckenzie 
 L-3 GSI 


  -Original Message- 
 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of T. Dee 
 
 Sent: Tuesday, September 05, 2006 9:39 AM 
 To: arslist@ARSLIST.ORG 
 Subject: Question: Disable ODBC 


  I was wondring if someone could tell me what I can add to the AR.CFG file to disable users from using ODBC to connect to the server to run Crystal reports?

 THANKS! 


 ___ 
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org 


  __20060125___This posting was submitted with HTML in it___ 



__20060125___This posting was submitted with HTML in it___ 




__20060125___This posting was submitted with HTML in it___

Re: Web Services - Loading WSDL Error

2006-09-06 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: Web Services - Loading WSDL Error
**





Paul:

Looks like the file does not exist at that location. Does it and is it accessable?

James McKenzie
L-3 GSI





From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Clements, Paul
Sent: Wednesday, September 06, 2006 1:39 AM
To: arslist@ARSLIST.ORG
Subject: Re: Web Services - Loading WSDL Error



** ** 


Hi,





The WSDL file I am attempting to parse contains the line:





wsdl:import namespace=http://www.-solutions.co.uk/webservices/connectors/common/interface location=CommonConnector-Interface-1.0.wsdl /







The error I get when parsing is:


* 


ERROR: WSDLException: faultCode=OTHER_ERROR: Unable to resolve imported document at 'CommonConnector-Interface-1.0.wsdl'.: This file was not found: file:CommonConnector-Interface-1.0.wsdl file:///\\CommonConnector-Interface-1.0.wsdl 

** 


My guess is when it hits this line it simply cannot find the file 'CommonConnector-Interface-1.0.wsdl'. However, this file is in the same place as the file being parsed. Is there anyone out there who would know where the parsing routine would look for wsdl files contained within the actual wsdl being parsed ?




I appreciate this is probably not an easy question but I'm sure one of you boffins out there will be able to help !! 


Cheers, 


Paul Clements 
IT Professional Officer 
Glasgow City Council 
Centenary House 
100 Morrison Street 
Glasgow G5 8LN 


Phone: 0141 418 1332 
Email: [EMAIL PROTECTED] 
Web: www.glasgow.gov.uk 


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3

Sent: 05 September 2006 17:11
To: arslist@ARSLIST.ORG
Subject: Re: Web Services - Loading WSDL Error





Paul: 
 
file:/// file:///\\ may help. 
 
James McKenzie 


 


From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Clements, Paul 
Sent: Tuesday, September 05, 2006 9:09 AM 
To: arslist@ARSLIST.ORG 
Subject: Web Services - Loading WSDL Error 





** 


Hi, 


I am trying to load in the WSDL of a web servicethe web service is hosted on an in-house server and not externally. When I input the WSDL and click 'Load' within a 'Set Fields' action I get the error:

* 


ERROR: WSDLException: faultCode=OTHER_ERROR: Unable to resolve imported document at 'CommonConnector-Interface-1.0.wsdl'.: This file was not found: file:CommonConnector-Interface-1.0.wsdl file:///\\CommonConnector-Interface-1.0.wsdl 

** 


This implies that it has found the WSDL file I entered but is then having an issue with one of the WSDL's it then subsequently calls. All WSDL files are in the same directory on the server so I'm not sure why it can find the top level one but not one it then calls. 

Any ideas ? 


Cheers, 


Paul Clements 


IT Professional Officer 


Glasgow City Council 


Centenary House 


100 Morrison Street 


Glasgow G5 8LN 


Phone: 0141 418 1332 


Email: [EMAIL PROTECTED] 


Web: www.glasgow.gov.uk 





Support Scotland's Bid to host the 2014 Commonwealth Games in Glasgow - visit www.glasgow2014.com 


 
Disclaimer: 
This message is intended only for use of the addressee. If this message 
was sent to you in error, please notify the sender and delete this message. 
Glasgow City Council cannot accept responsibility for viruses, so please 
scan attachments. Views expressed in this message do not necessarily reflect 
those of the Council who will not necessarily be bound by its contents. 
 
__20060125___This posting was submitted with HTML in it___ 


__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___



__20060125___This posting was submitted with HTML in it___

Re: Question: Disable ODBC

2006-09-06 Thread Tyrone Dee

Title: RE: Question: Disable ODBC
**



Thank you Jason - excellent idea.


From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of 
Jason Miller Sent: Tuesday, September 05, 2006 7:52 
PM To: arslist@ARSLIST.ORG Subject: Re: Question: Disable ODBC 
** I had a situation where I setup a contractor on a temporary 
basis with an ODBC connection to his MS Access database. We agreed that it was 
only for his use. He ended up placing it on a network share and letting 
everybody know it was there. I had some big performance concerns about multiple 
people starting to do a full dump of the CHG:Change and CHG:Task tables each 
time they want to see the latest data. Fortunately he pulled it before anybody 
had a chance to copy it.
I created a filter that fires on Get Entry. The Run If was 
$CLIENT-TYPE$ = 6 and $USER$ != "myusername" and I had a error message If 
Action. This gave me (logged in as a different user) an error in MS Access and 
Crystal Reports. I really liked this method because it didn't limit myself as 
the admin, CRD or the people who have a legitimate need to connect via 
ODBC.
Jason 
On 9/5/06, McKenzie, James J C-E LCMC HQISEC/L3 
[EMAIL PROTECTED]  wrote: 
 ** 
 Tyrone: 
 Why do you want to do 
this? ODBC is required for Crystal to access the Remedy database. Is 
there a performance issue that needs to be addressed instead?
 And, yes, I would 
like to know this too. It may involve shutting down the entire interface 
through the ar.cfg(ar.conf) file.
 James Mckenzie 
 L-3 GSI 

 
 -Original 
Message-  From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of 
T. Dee  
 Sent: Tuesday, 
September 05, 2006 9:39 AM  
To: arslist@ARSLIST.ORG 
 Subject: 
Question: Disable ODBC 
 
 I was wondring if 
someone could tell me what I can add to the AR.CFG file to disable users from 
using ODBC to connect to the server to run Crystal reports?
 THANKS! 
 ___ 
 UNSUBSCRIBE 
or access ARSlist Archives at http://www.wwrug.org 
 
 __20060125___This posting was submitted with HTML in 
it___ 
__20060125___This posting was submitted with 
HTML in it___ __20060125___This posting was 
submitted with HTML in it___
__20060125___This posting was submitted with HTML in it___

Re: Setup Dev Server

2006-09-06 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: Setup Dev Server
**





Brian:


If the two Oracle servers are on the same wire (network) then you cannot set the SID to the same name. You will get an error (I don't know what it is) when you go to start up the second instance. If they are in isolated spaces, then you will not get the error.

James McKenzie



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Luke, Brian
Sent: Tuesday, September 05, 2006 3:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: Setup Dev Server


James / John,
 I should clarify, the fear is not for cross communication between tablespaces - Oracle  ARS handle that well. The concern is if the database SID names are the same, but refer to different oracle instances. If there was a tnsnames.ora copy / overwrite snafu, you could have both ARS instances talking to one Oracle instance and not even know it (If this is in fact what is meant by the DB is the same name).


In thinking about what could be referencing the old ars server that the installer would care about, I could only think of SERVER_CACHE left over from ARS  v5 or a copied .lic file. Table fields  filter guides would not affect the upgrade installer I hope. I can't think of other embedded server references.


I've never encountered the installer upgrade option complaining that the database intact and accessible - that seems very wrong - so I'm left to conclude that the database being present  accessible is not the root problem.

I _suspect_ that the installer detects that the ARS database it is about to upgrade is in use by another running ARS server elsewhere - which could easily happen if your SID's were the same in dev  prod.


The other problem here could be that all of the oracle binaries and config files were copied, including tnsnames which refernces the prod instance - and it is actually Oracle generating this error message. If this is the case, the DBA will need to either:

A:) ensure that all references to the old db server hostname/ip in _any_ Oracle configurations are updated to the dev database hostname/ip Or

B:) erase the instance and re-create it via standard tools/processes, then export the data from prod and import it in dev.

Option B would be highly reccommended - who knows where Oracle stuffs away information about where it is supposed to reside.

-brian luke





From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of McKenzie, James J C-E LCMC

HQISEC/L3
Sent: Tuesday, September 05, 2006 2:28 PM
To: arslist@ARSLIST.ORG
Subject: Re: Setup Dev Server



** 


Brian: 


Why the fear? If you name one tablespace ARSYSTEM for instance, and the second ARSYSTEM1, there should be NO cross-talk between the two tablespaces. The problem here might be that the database was physically copied from one server to another and there may be internal checking that is failing and thus the error.

James McKenzie 
 


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Luke, Brian
Sent: Tuesday, September 05, 2006 2:10 PM
To: arslist@ARSLIST.ORG
Subject: Re: Setup Dev Server 


John, 
 
By the DB is the same name do you mean the ORACLE SID or the database server hostname? 


With Oracle, the Db-name: ar.cfg parameter is used for the tablespace name if it is not ARSYSTEM. 
One thing that worries me about this config is that if the SID's are the same, the only place they are differentiated is in tnsnames.ora - the danger of unintended cross communication seems great.

What version of ARS have and are you upgrading from (this last time, and tracing back?) Check the contents of SERVER_CACHE and see if there are references to old servers there.

Also, did you copy the file containing the ARS licenses to the dev ARS server? - try renaming it if you did. 


One Oracle instance can have one or many tablespaces. Each tablespace can contain the objects for one or more accounts/schemas and keep them separate (even with the same table names).

-Brian Luke 


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley
Sent: Friday, September 01, 2006 8:31 AM
To: arslist@ARSLIST.ORG
Subject: Setup Dev Server 


Hi List: First time emailer. Long time reader. 


I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having errors upgrading an existing DB. 
We took a copy of production DB, and placed it on a different oracle 
Server. Oracle 9.2.0.4.0 64bit. 
My tnsnames is set correctly to Dev Server and connection to remedb listener. 
The name of the DB is the same for Production and Dev. Which is OK. 
They are on different servers. 
When I'm setting up the Dev server running server.exe, Its asks for SID name and what type of install. Upgrade, Overwrite or Shared. I select Upgrade because the DB out there is an exact copy of the Production

Re: Oddity with Submitter field in e-mail notifications

2006-09-06 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: Oddity with Submitter field in e-mail notifications
**





Rick:

I would not delete this user, but rather rename it to see if the problem moves with this user. Also, some legacy software depend on the existance of user id #1.


James McKenzie
L-3 GSI





From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock
Sent: Tuesday, September 05, 2006 4:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: Oddity with Submitter field in e-mail notifications



** 
Excellent idea on checking the deffile, I'll try that next. I may also have to have some users turn on logging (I normally have all logging off for normal users).


The Demo user was still there when I took over as Remedy Admin several years ago and is still the Owner of many, many objects. Will it break any objects owned by Demo if I delete that user?



-Rick





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

Sent: Tuesday, September 05, 2006 3:53 PM
To: arslist@ARSLIST.ORG
Subject: Re: Oddity with Submitter field in e-mail notifications



** 
Don't really understart this, Demo came with the startpacket, as soon admin-accounts have been created in the userform, ok to delete Demo.

I guess Demo has been free for a while, active, so Demo is in field 'Submitter', 'Changed by' and ...

Your wf reads the submitterfield, an 199 of 200 has real names Not Demo

In our appl Demo is a non existing name since long time.

Some wf setting DEMO sometimes? Submitter-mode set to locked? It means you are not allowed to
chanhe the data to get rid of it finally. Possible to switch and then set locked again? (If you need to change field
'Cretaed'

Often when a form is saved as, a lot of data is tranfered to the new form, I try to replace Demo as Owner to something else.

The same with helptext

And Check if there are type Defaulvaues using Demo.

Why not search in the deffile for Demo? and change Owner = Demo

Turn on logging to see if that can give something.

Good Luck!

L asr




 -Original Message-
 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Westbrock
 Sent: Wednesday, September 06, 2006 12:01 AM
 To: arslist@ARSLIST.ORG
 Subject: Oddity with Submitter field in e-mail notifications
 
 
 ** 


 I'm running 5.1.2 on Windows 2000, MS-SQL 2000 and I'm seeing inconsistent results from a notification e-mail that is sent by a filter. The filter fires on Submit and one of the fields in the body of the e-mail is set to Submitter. Most of the time it populates the correct user name but I've now seen a couple e-mails go out with Demo as the username.

 When I check that ticket I see the correct username in the status history and work log so I'm puzzled as to why it would substitute Demo at all. The frustrating part is that I have two e-mails sent within ten minutes of each other and one shows the correct user name and the other shows Demo for the Submitter field.

 Any clues as to why this might happen? 



 -Rick 



 _ 
 Rick Westbrock 
 PETCO Store Systems WAN Supervisor 
 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 




__20060125___This posting was submitted with HTML in it___

Re: Question: Disable ODBC

2006-09-06 Thread Carey Matthew Black


All,

ConfigGuide-630.pdf Page: 287:


Disable-Client-Operation: tag_number_to_disable [[start_time]-
[stop_time]] [group_ID_list]

Restricts time-consuming operations (such as reporting) during busy times,
improving the overall performance. This option can be set to certain times
the day. It can also exclude users of specific groups so that they are not
blocked from performing the specified operation. For example, you can
allow only the administrator to perform reporting during busy hours.


So ... I think the config file option is the best bet. It would allow
any specified groups to be _excluded_ from the restriction.

Jason's Get Entry filter option does go to one level more granular (to
the user not a group) and has the added performance expense of being
evaluated for every data row returned from the form. (Even for the
users listed in the Run If.)

I wonder if the config option will (or was) similarly expanded like
the Assignee Group values were but BMC failed to document that
feature? (Maybe you can be user specific in the config file? if not,
then it would be a good REF idea IMHO.)

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

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

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: AL stopped working (no changes on AL)

2006-09-06 Thread Joe DeSouza

**

Very basic question... Haveyou checked if the permission groups on both the dev and prod instances are identical - both groupnames and their ID's should be the same...
Joe D'Souza
Remedy Developer / Consultant,
BearingPoint,
Virginia.

- Original Message From: "Kemes, Lisa" [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Wednesday, September 6, 2006 9:15:27 AMSubject: Re: AL stopped working (no changes on AL)
I had an AL just stop working all of the sudden and what I had to do wasdelete it and then re-import the AL from the Prod server.SometimesAL's get corrupted.Now my AL has no more problems on my Dev serverIf this does not work, at least it only takes a couple of minutes todoHope this helps Lisa-Original Message-From: Action Request System discussion list(ARSList)[mailto:[EMAIL PROTECTED] On Behalf Of Nyall McCavittSent: Wednesday, September 06, 2006 8:35 AMTo: arslist@ARSLIST.ORGSubject: Re: AL stopped working (no changes on AL)Hi,Just a thought.Have you defined the Report Server option in the User Tool to point tothe dev server. If so, does the report exist on the Report form on devserver?If I have misread this problem then please ignore this.Thanks.NyallGeorge Barsan wrote: Hi
 Tim, Thanks for the quick answer. The DEV environment is a full copy of the production, all forms exist there as well (although containing test  data!). The second AL having the same problems does the following actions:0 push fields (update existing request in another form)1 set fields from another form2 open window (yep, that's the one!)3 set fields from another form4 set field locally5 set field locally6 set field locally7 commit changes8 close window___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125___This posting was submitted with HTML in it___

Re: AL stopped working (no changes on AL)


No, I unfortunately can't remove the advanced option.. But it doesn't
seem to make a different, I tested it as well..

On 9/6/06, Grooms, Frederick W [EMAIL PROTECTED] wrote:

I just noticed the Advanced mode...   Do you need to use the Advanced
option?  Are you specifying the form to open in a Field (That's what the
advanced is supposed to be for).  Can you remove the Advanced option and
does the AL work?

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of George Barsan
Sent: Wednesday, September 06, 2006 7:29 AM
To: arslist@ARSLIST.ORG
Subject: Re: AL stopped working (no changes on AL)

Sorry, I forgot to mention that both AL are handling reporting and the
open window have open window actions running with window type = Report
and using Advanced mode..

On 9/6/06, George Barsan [EMAIL PROTECTED] wrote:
 Hi Tim,

 Thanks for the quick answer. The DEV environment is a full copy of the

 production, all forms exist there as well (although containing test
 data!).

 The second AL having the same problems does the following actions:

   0 push fields (update existing request in another form)
   1 set fields from another form
   2 open window (yep, that's the one!)
   3 set fields from another form
   4 set field locally
   5 set field locally
   6 set field locally
   7 commit changes
   8 close window

 That's the only AL running behind that button (and on another form
 then the AL initially mentioned). The logs are:

 ACTL Checking CM:LAU:BU_PrintAndSaveAsAttachment_000 (0)
 ACTL - Passed qualification -- perform if actions
 ACTL  0: Push Fields
 ACTL To Schema Schema:Case on Server @
 ACTL (536870991) = Template.rpt
 ACTL (536871192) = Schema:Join:Reporting123
 ACTL (536871203) = {Schema_Join_Reporting.ID} = '123'
 ACTL (536871162) = 06/09/2006
 ACTL (536871046) = test test test
 ACTL  1: Set Fields
 ACTL xAttachmentFormat (536871182) = portabledocformat
 ACTL xDataSourceFormName (536871165) =
Schema_Join_Reporting
 ACTL xFileExtension (536870935) = .pdf
 ACTL xReportDefinitionFile (536870927) = Template.rpt
 ACTL xSelectionCriteria (536870926) = $ID$ = 'ID'
 ACTL  2: Open Dialog
 ACTLServer: xyz
 ACTLSchema: Schema:Join:Reporting123
 ACTLView:
 ACTL /* Wed Sep 06 2006 13:22:10 */
 ACTL Stop active link processing - On Control

 And that's it :(

 Many thanks,

 George


 On 9/6/06, Timothy Powell [EMAIL PROTECTED] wrote:
  I hate to ask the is it plugged in type question, but.
  The form it's trying to perform the push fields against DOES exist
  on the dev server...right?
 
  What's the log from the other AL? What are the common attributes of
  the ALs in question (if any)?
 
  Tim
 
  -Original Message-
  From: Action Request System discussion list(ARSList)
  [mailto:[EMAIL PROTECTED] On Behalf Of George Barsan
  Sent: Wednesday, September 06, 2006 7:58 AM
  To: arslist@ARSLIST.ORG
  Subject: Re: AL stopped working (no changes on AL)
 
  I have exactly the same behaviour on another (even simpler) AL on
  the same box too, it's driving me crazy..
 
  I highly appreciate any suggestions..
 
  On 9/6/06, George Barsan [EMAIL PROTECTED] wrote:
   Hi all,
  
   I have here an older ARS application which I'm trying to extend
   and consolidate.. It includes a nice little AL which runs behind a

   button and has 7 actions:
  
   0 set field locally
   1 set field from another form
   2 commit changes
   3 open window / report
   4 push fields (create a new request)
   5 change field
  
   The very same AL (I didn't modify it anyway) runs perfectly if I
   connect to production but stops on the Dev Box at the Open Window
   action, the log entries are:
   ACTL  3: Open Dialog
   ACTLServer: xyz
   ACTLSchema: XX:XXX:XYZ
   ACTLView:
   ACTL /* Mon Sep 04 2006 15:14:30 */ ACTL Stop active link
   processing - On Control
  
   That's it, no error, no warning.. I cleaned the client cache,
   restartet both client  server, enabled  disabled and reimported
   the AL from production, recreated the AL manually.. It works for a

   while then and it suddenly stops working although I don't change
anything..
   Has anybody seen that before? It seems like an ARS bug to me, but
   I unfortunately don't have access to the support site..
  
   Server (applies both for Dev and Prod): ARS 6.3 P13 running on
   WinXP
   Database: MS Sql on the same box (afaik v2000 8.00.2039)
   Client/Admin: workstation a) 6.3 P18 and workstation b) 6.3
   unpatched
  
   Many thanks,
  
   George
  
 
  
  
  ___
  UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: AL stopped working (no changes on AL)


Hello Joe,

Yep, the group names and ID's are equal.. We used a DB dump and
re-import to duplicate production to dev and only removed customer
related data (names, addresses  co)..

George


On 9/6/06, Joe DeSouza [EMAIL PROTECTED] wrote:

**


Very basic question... Have you checked if the permission groups on both the
dev and prod instances are identical - both group names and their ID's
should be the same...

Joe D'Souza
Remedy Developer / Consultant,
BearingPoint,
Virginia.




- Original Message 
From: Kemes, Lisa [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Wednesday, September 6, 2006 9:15:27 AM
Subject: Re: AL stopped working (no changes on AL)


I had an AL just stop working all of the sudden and what I had to do was
delete it and then re-import the AL from the Prod server.  Sometimes
AL's get corrupted.  Now my AL has no more problems on my Dev server

If this does not work, at least it only takes a couple of minutes to
do

Hope this helps

Lisa

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Nyall McCavitt
Sent: Wednesday, September 06, 2006 8:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: AL stopped working (no changes on AL)

Hi,

Just a thought.

Have you defined the Report Server option in the User Tool to point to
the dev server. If so, does the report exist on the Report form on dev
server?

If I have misread this problem then please ignore this.

Thanks.

Nyall

George Barsan wrote:
 Hi Tim,

 Thanks for the quick answer. The DEV environment is a full copy of the

 production, all forms exist there as well (although containing test
 data!).

 The second AL having the same problems does the following actions:

  0 push fields (update existing request in another form)
  1 set fields from another form
  2 open window (yep, that's the one!)
  3 set fields from another form
  4 set field locally
  5 set field locally
  6 set field locally
  7 commit changes
  8 close window


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
 __20060125___This posting was
submitted with HTML in it___


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Problem with Remedy Archiving when adding Views to the form.

2006-09-06 Thread Hugo Visser

**
Ron,The field id's won't change, since you're making a copy of your original form, including view id's and such. The archive form in turn is just a copy of that form with some fields added. When you import a form in place the T# is also unchanged.
I've just tested it and it looks like it's working fine. You don't even have to hack the def files! Just copy your original form. The copy won't have any archiving info set. Set some dummy info and set the name of the new archive form. Then export the created archive form and reimport. On the import dialog you can change the form name of your copy archive form. Be sure to check the import in place option and volia :) Updated archive form, with the existing data and with all new views.
Ofcourse the usual disclaimer applies, so back up first and try it on a test machine :)Btw, Remedy might throw the as designed at you but the thing is really their way of syncing the forms is fragile as you expecienced.
Hope this is working for you too.HugoOn 9/6/06, Ron Tavares [EMAIL PROTECTED] wrote:
**
Hugo is correct, I am trying to add the Radio button field because Remedy failed to carry it over when I added it to the original form. The reason that failed, is because we added a new veiw (the 10th view), to original form and that view failed to carry over. Remedy says this is normal because you do not need views on the archive form. But what they are forgetting, is that when the views are not in sync, the Remedy System is unable to carry over new feilds.


Hugo,

I like your suggestion. It sounds like it would work, but I'm a little concerned about things like field IDs and the T#s of the archive table. These might change in the process, no?
On 9/6/06, Hugo Visser [EMAIL PROTECTED] wrote:


** Ian,As I understand adding fields to the archive form is just a work around for him, because Remedy's mechanism isn't adding those fields.What you could try is this, I haven't tested it (yes it's dirty):
Save your original form as a copy, turn on archiving on that copy so that the archive form you want is created. Then export the definition of the archive form and modify the form name. After that import the new archive form in place over the old archive form. Afterwards you can delete the copy and the copy archive. 
Hope that works :)Oh and looking back in this thread I see a similar workaround is proposed, well, hopefully this one is usefull for the archives then.

Hugo

On 9/6/06, Ian Trimnell [EMAIL PROTECTED]
 wrote: 

** 

Ron,
As James has since pointed out, you can not add data fields to an Archive form. Looking at Appendix E of the new V7 manual Form and Application Objects (or Chapter 7 of the V6 Configuring AR System) it says that 'Data fields (including radio) cannot be modified or added to an archive form. All other types, such as trim or table, can be added or modified.' It also states that fields in Archive forms created by AR System have read-only access.

The question that hasn't been asked yet (at least I haven't noticed it yet) is 'Why do you want to add a radio field to an Archive form?'
We have a mix of archive forms, some using the OOB feature, others where we had to set up an archiving facility before Remedy introduced it back in Version 6. I have had a few problems with setting up OOB archiving but eventually got the hang of it when I had passed the learning curve that accompanies these new features that Remedy adds in. I must admit that they appear to have improved it as the versions go on.

Cheers,
Ian

Ian Trimnell, AR System Lead Developer (amongst other jobs),Specialist Support  Information Team, Academic  Administrative Computing Service
Open University, MILTON KEYNES, UKPhone: 01908 653741  web: http://www.open.ac.uk/


Ron Tavares wrote: 

Chris,YES!! that is exactly the issue.  Thank You, for a while there I wasthinking I was the only one.As for Remedy's response, initially they opened a bug, SW00248651But then it appears they closed it saying, (and I quote from the support
e-mail)After evaluating the information provided in the open bug engineeringdetermined that the behavior is as expected, with no plan to change it inthe future. Per their comments: The main purpose of a shadow form is to keep
the archive(or audit) data. Views are not required for that.But this statement is only true if you NEVER add any additional fields.Now, after banging my head agains the wall a few times, I figured how to
work around this.  By simply re-creating the field, from scratch, beingcareful to keep the same properties and ID, I was able to add the field tothe Archvie AND re-enabel Archiving.  (Even though Remedy doesn't support
adding fields directly to the Archive form.)  BUT, the problem I am havingis with the Radio Button field.  Try creating one of these dirctly on thearchive form and you cannot set the attributes.  They are grayed out.
.ron

__20060125___This posting was submitted with HTML in it___ __20060125___This posting

ANSWER - ITSM 7 Implementation Workshop RSMG-ITIW-0700

2006-09-06 Thread Tony Worthington

**

Well, I just got off the phone with
BMC and they confirmed that this class is only open to BMC Partners.

The suggested replacement courses for
non-partners are:

ITSM 7: Application Administering Essentials
- wbt
Remedy Service Desk 7.x: Using Incident
Management - wbt
Remedy Service Desk 7.x: Using Problem
Management - wbt
Remedy Service Desk 7.x: Administering
Remedy Change Management 7.x: Using
- wbt
Remedy Change Management 7.x: Administering
BMC Service Level Management: 7.x: Basic
- wbt
BMC Service Level Management: 7.x: Advanced
- wbt
Remedy Asset Management 7.x: Using -
wbt
Remedy Asset Management 7.x: Administering

I'd much rather take one week-long course
than have to travel for three or four 1-2 day classes (which aren't even
scheduled back to back) and boring wbt classes on SLM...

-tony

-- 
Tony Worthington
[EMAIL PROTECTED]
262-703-6125





Tony Worthington/Corp/Kohls

08/31/2006 09:07 AM




To
arslist@arslist.org


cc



Subject
ITSM 7 Implementation Workshop RSMG-ITIW-0700







Has anyone who is not a BMC Partner
sucessfully registered for this class (in the USA)?

Our sales person swears that I am not
able to register/attend this class, and instead must take ServiceDesk/Change/Asset
administration courses.

Anyone?

-tony
-- 
Tony Worthington
[EMAIL PROTECTED]
262-703-6125

__20060125___This posting was submitted with HTML in it___

ARS 7 install issues with Oracle 10gR2 on Solaris 9

Hello, All!

I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2.  I am having 
a couple of issues:

1. If we don't get ARSystem table space created prior to the installation, 
we get the following error:

An unknown Oracle error has been detected.
Please resolve this error and re-try the installation.
Refer to /tmp/arDBErrorLog for the Oracle error information.

I checked /tmp/arDBErrorLog, it only has a time stamp, no other error 
details.

After the DBA created ARSystem table space, we were able to move on with 
the installation.  Remedy Tech Support recommends not to create ARSystem 
prior to installation.  If you have done ARS 7 installation with Oracle 
10gR2, did you have to create ARSystem table space prior to installation?  
If you didn't create ARSystem table first, what's the default table space 
for ARAdmin?


2. We got the following after we chose to use UNICODE:

Selecting UNICODE to create or overwrite an existing
Oracle tablespace REQUIRES that the database already
be configured to support the AL32UTF-8 UNICODE character set.

If you are upgrading an existing database to use UNICODE, the database
must already be configured to support the UNICODE character set.

Do you want to use the UNICODE character set?  [n] y

*** Your current locale (C) is not Unicode and you are asking for
*** a Unicode install.  Please adjust your LANG and LC_ALL variables.

*** You can either change your UNICODE option or abort the
*** installation to adjust your LANG and LC_ALL variables.
Do you want to abort the installation? [n]

I couldn't move on with the installation because it keeps asking the same 
question as above if I choose not to abort the installation.  I had to 
abort installation.

I discussed this with my DBA and he sent me the database creation SQL 
statement as following:

CREATE DATABASE rmdytst1
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE 
EXTENT MANAGEMENT LOCAL SYSAUX 
DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf' SIZE 500M REUSE 
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP 
TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE 
SMALLFILE UNDO TABLESPACE UNDOTBS1 
DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE 
CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8

Is character set specified in the SQL statement correct for UNICODE?  If 
not, what's the right SQL statement?  My DBA thinks that AL32UTF-8 is a 
subset of UTF8, but should he change it to AL32UTF-8 during the initial 
database creation?


Thanks in advance for your help.

Eric Zhang
Entergy Services, Inc.
501-377-5815

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9

2006-09-06 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: ARS 7 install issues with Oracle 10gR2 on Solaris 9
**





Eric:


What language are you using as the base language? I may have a suggestion.


James McKenzie



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Zhang
Sent: Wednesday, September 06, 2006 8:36 AM
To: arslist@ARSLIST.ORG
Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9


Hello, All!


I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am having a couple of issues:


1. If we don't get ARSystem table space created prior to the installation, we get the following error:


An unknown Oracle error has been detected.
Please resolve this error and re-try the installation.
Refer to /tmp/arDBErrorLog for the Oracle error information.


I checked /tmp/arDBErrorLog, it only has a time stamp, no other error details.


After the DBA created ARSystem table space, we were able to move on with the installation. Remedy Tech Support recommends not to create ARSystem prior to installation. If you have done ARS 7 installation with Oracle 10gR2, did you have to create ARSystem table space prior to installation? 

If you didn't create ARSystem table first, what's the default table space for ARAdmin?



2. We got the following after we chose to use UNICODE:


Selecting UNICODE to create or overwrite an existing Oracle tablespace REQUIRES that the database already be configured to support the AL32UTF-8 UNICODE character set.

If you are upgrading an existing database to use UNICODE, the database must already be configured to support the UNICODE character set.

Do you want to use the UNICODE character set? [n] y


*** Your current locale (C) is not Unicode and you are asking for
*** a Unicode install. Please adjust your LANG and LC_ALL variables.


*** You can either change your UNICODE option or abort the
*** installation to adjust your LANG and LC_ALL variables.
Do you want to abort the installation? [n]


I couldn't move on with the installation because it keeps asking the same question as above if I choose not to abort the installation. I had to abort installation.

I discussed this with my DBA and he sent me the database creation SQL statement as following:


CREATE DATABASE rmdytst1
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf' SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE UNDO TABLESPACE UNDOTBS1 

DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8

Is character set specified in the SQL statement correct for UNICODE? If not, what's the right SQL statement? My DBA thinks that AL32UTF-8 is a subset of UTF8, but should he change it to AL32UTF-8 during the initial database creation?


Thanks in advance for your help.


Eric Zhang
Entergy Services, Inc.
501-377-5815


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org




__20060125___This posting was submitted with HTML in it___

Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9

2006-09-06 Thread Sinclair, Carin

Eric, 

Make sure your oracle db character set is set for Unicode

select * from v$nls_parameters where parameter in
('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET');

If not set it and then try the install
Carin

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang
Sent: Wednesday, September 06, 2006 10:36 AM
To: arslist@ARSLIST.ORG
Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9

Hello, All!

I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2.  I am
having 
a couple of issues:

1. If we don't get ARSystem table space created prior to the
installation, 
we get the following error:

An unknown Oracle error has been detected.
Please resolve this error and re-try the installation.
Refer to /tmp/arDBErrorLog for the Oracle error information.

I checked /tmp/arDBErrorLog, it only has a time stamp, no other error 
details.

After the DBA created ARSystem table space, we were able to move on with

the installation.  Remedy Tech Support recommends not to create ARSystem

prior to installation.  If you have done ARS 7 installation with Oracle 
10gR2, did you have to create ARSystem table space prior to
installation?  
If you didn't create ARSystem table first, what's the default table
space 
for ARAdmin?


2. We got the following after we chose to use UNICODE:

Selecting UNICODE to create or overwrite an existing
Oracle tablespace REQUIRES that the database already
be configured to support the AL32UTF-8 UNICODE character set.

If you are upgrading an existing database to use UNICODE, the database
must already be configured to support the UNICODE character set.

Do you want to use the UNICODE character set?  [n] y

*** Your current locale (C) is not Unicode and you are asking for
*** a Unicode install.  Please adjust your LANG and LC_ALL variables.

*** You can either change your UNICODE option or abort the
*** installation to adjust your LANG and LC_ALL variables.
Do you want to abort the installation? [n]

I couldn't move on with the installation because it keeps asking the
same 
question as above if I choose not to abort the installation.  I had to 
abort installation.

I discussed this with my DBA and he sent me the database creation SQL 
statement as following:

CREATE DATABASE rmdytst1
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE 
EXTENT MANAGEMENT LOCAL SYSAUX 
DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf' SIZE 500M REUSE 
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP 
TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE 
SMALLFILE UNDO TABLESPACE UNDOTBS1 
DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE 
CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8

Is character set specified in the SQL statement correct for UNICODE?  If

not, what's the right SQL statement?  My DBA thinks that AL32UTF-8 is a 
subset of UTF8, but should he change it to AL32UTF-8 during the initial 
database creation?


Thanks in advance for your help.

Eric Zhang
Entergy Services, Inc.
501-377-5815


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

OT:SFO Photos

For those interested, I put a couple dozen photos of the ARSList awards at 
http://www.bullcreek.com/BUW but beware (those with small download speeds) 
these are NOT thumbnails and I haven't had the time to make a nice page with 
anything other than simple links.  I did try to give the images a meaningfull 
title.

Warning: there are old men in Hawaiian shirts in many photos...

Cheers,

Phil Bautista
President / CEO
Bull Creek Data Corporation
www.bullcreek.com
Remedy Approved Consultant (RAC)
512-731-0304

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9


I used the following env vars for the 7.0 installer on solaris 9 with
Oracle.  This allowed me to do the install with the single-byte and
multi-byte support data (message catalog, etc.).

NLS_LANG=american
LANG=en_US.UTF-8
LC_ALL=en_US.UTF-8

Axton Grams

On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote:

James,
English is the base language.
Thanks,
Eric

On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC HQISEC/L3
[EMAIL PROTECTED] wrote:

Eric:

What language are you using as the base language?  I may have a
suggestion.

James McKenzie


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang
Sent: Wednesday, September 06, 2006 8:36 AM
To: arslist@ARSLIST.ORG
Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9

Hello, All!

I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2.  I am
having a
couple of issues:

1. If we don't get ARSystem table space created prior to the installation,
we get the following error:

An unknown Oracle error has been detected.
Please resolve this error and re-try the installation.
Refer to /tmp/arDBErrorLog for the Oracle error information.

I checked /tmp/arDBErrorLog, it only has a time stamp, no other error
details.

After the DBA created ARSystem table space, we were able to move on with
the
installation.  Remedy Tech Support recommends not to create ARSystem prior
to installation.  If you have done ARS 7 installation with Oracle 10gR2,
did
you have to create ARSystem table space prior to installation?
If you didn't create ARSystem table first, what's the default table space
for ARAdmin?


2. We got the following after we chose to use UNICODE:

Selecting UNICODE to create or overwrite an existing Oracle tablespace
REQUIRES that the database already be configured to support the AL32UTF-8
UNICODE character set.

If you are upgrading an existing database to use UNICODE, the database
must
already be configured to support the UNICODE character set.

Do you want to use the UNICODE character set?  [n] y

*** Your current locale (C) is not Unicode and you are asking for
*** a Unicode install.  Please adjust your LANG and LC_ALL variables.

*** You can either change your UNICODE option or abort the
*** installation to adjust your LANG and LC_ALL variables.
Do you want to abort the installation? [n]

I couldn't move on with the installation because it keeps asking the same
question as above if I choose not to abort the installation.  I had to
abort
installation.

I discussed this with my DBA and he sent me the database creation SQL
statement as following:

CREATE DATABASE rmdytst1
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE
EXTENT
MANAGEMENT LOCAL SYSAUX
DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf'
SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE
'/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE UNDO
TABLESPACE UNDOTBS1
DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE
CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8

Is character set specified in the SQL statement correct for UNICODE?  If
not, what's the right SQL statement?  My DBA thinks that AL32UTF-8 is a
subset of UTF8, but should he change it to AL32UTF-8 during the initial
database creation?


Thanks in advance for your help.

Eric Zhang
Entergy Services, Inc.
501-377-5815

__
__
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

__
_
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org



___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9

2006-09-06 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: ARS 7 install issues with Oracle 10gR2 on Solaris 9
**





Eric:


If you are staying within English, then the language MIGHT BE en_US.UTF8. If you want to use other languages, you will have to set the database up for 16 bit UTF. I don't know if 32 bit UTF is supported or not. 

James McKenzie 


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Zhang
Sent: Wednesday, September 06, 2006 9:00 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9


James,
English is the base language. 
Thanks,
Eric


On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote:


Eric:

What language are you using as the base language? I may have a
suggestion.

James McKenzie


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Zhang
Sent: Wednesday, September 06, 2006 8:36 AM
To: arslist@ARSLIST.ORG
Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9

Hello, All!

I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am
having a
couple of issues:

1. If we don't get ARSystem table space created prior to the 
installation, we get the following error:

An unknown Oracle error has been detected.
Please resolve this error and re-try the installation.
Refer to /tmp/arDBErrorLog for the Oracle error information.

I checked /tmp/arDBErrorLog, it only has a time stamp, no other error 
details.

After the DBA created ARSystem table space, we were able to move on 
with
the
installation. Remedy Tech Support recommends not to create ARSystem 
prior to installation. If you have done ARS 7 installation with Oracle 
10gR2,
did
you have to create ARSystem table space prior to installation?
If you didn't create ARSystem table first, what's the default table 
space for ARAdmin?


2. We got the following after we chose to use UNICODE:

Selecting UNICODE to create or overwrite an existing Oracle tablespace 
REQUIRES that the database already be configured to support the 
AL32UTF-8 UNICODE character set.

If you are upgrading an existing database to use UNICODE, the database
must
already be configured to support the UNICODE character set.

Do you want to use the UNICODE character set? [n] y

*** Your current locale (C) is not Unicode and you are asking for
*** a Unicode install. Please adjust your LANG and LC_ALL variables.

*** You can either change your UNICODE option or abort the
*** installation to adjust your LANG and LC_ALL variables.
Do you want to abort the installation? [n]

I couldn't move on with the installation because it keeps asking the 
same question as above if I choose not to abort the installation. I 
had to
abort
installation.

I discussed this with my DBA and he sent me the database creation SQL 
statement as following:

CREATE DATABASE rmdytst1
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE
EXTENT
MANAGEMENT LOCAL SYSAUX
DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf'
SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 
'/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE 
UNDO TABLESPACE UNDOTBS1
DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE 
CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8

Is character set specified in the SQL statement correct for UNICODE? 
If not, what's the right SQL statement? My DBA thinks that AL32UTF-8 
is a subset of UTF8, but should he change it to AL32UTF-8 during the 
initial database creation?


Thanks in advance for your help.

Eric Zhang
Entergy Services, Inc.
501-377-5815

___
___
__
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
___
_
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org



___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org




__20060125___This posting was submitted with HTML in it___

Re: Deployable Applications

2006-09-06 Thread L. J. Head

To my knowledge the only change that a deployable application has is that
when in Maint only noone except admins can access it...test maps to your
test group...and production map to production groups as defined in the roles
form...I do not believe any other changes occur based on the app state 


L. J. Head
Software Engineer
Remedy Approved Consultant
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Valerie Balloon
Sent: Wednesday, September 06, 2006 11:16 AM
To: arslist@ARSLIST.ORG
Subject: Deployable Applications

I've recently returned from the AR Administrator 7.0 course but neglected to
ask a very important perhaps even simple question? What is the affect on the
underlying database when the state of deployable application moves from
state to state. Will the fields be created and/or removed within the
database? Are special tables be created based on the application's state?


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9

Axton,

Does it matter how you create your initial database when you use those 
environment vars for installation?

Thanks,
Eric

On Wed, 6 Sep 2006 12:29:29 -0400, Axton [EMAIL PROTECTED] wrote:

I used the following env vars for the 7.0 installer on solaris 9 with
Oracle.  This allowed me to do the install with the single-byte and
multi-byte support data (message catalog, etc.).

NLS_LANG=american
LANG=en_US.UTF-8
LC_ALL=en_US.UTF-8

Axton Grams

On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote:
 James,
 English is the base language.
 Thanks,
 Eric

 On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC HQISEC/L3
 [EMAIL PROTECTED] wrote:

 Eric:
 
 What language are you using as the base language?  I may have a
 suggestion.
 
 James McKenzie
 
 
 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang
 Sent: Wednesday, September 06, 2006 8:36 AM
 To: arslist@ARSLIST.ORG
 Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9
 
 Hello, All!
 
 I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2.  I am
 having a
 couple of issues:
 
 1. If we don't get ARSystem table space created prior to the 
installation,
 we get the following error:
 
 An unknown Oracle error has been detected.
 Please resolve this error and re-try the installation.
 Refer to /tmp/arDBErrorLog for the Oracle error information.
 
 I checked /tmp/arDBErrorLog, it only has a time stamp, no other error
 details.
 
 After the DBA created ARSystem table space, we were able to move on 
with
 the
 installation.  Remedy Tech Support recommends not to create ARSystem 
prior
 to installation.  If you have done ARS 7 installation with Oracle 
10gR2,
 did
 you have to create ARSystem table space prior to installation?
 If you didn't create ARSystem table first, what's the default table 
space
 for ARAdmin?
 
 
 2. We got the following after we chose to use UNICODE:
 
 Selecting UNICODE to create or overwrite an existing Oracle tablespace
 REQUIRES that the database already be configured to support the 
AL32UTF-8
 UNICODE character set.
 
 If you are upgrading an existing database to use UNICODE, the database
 must
 already be configured to support the UNICODE character set.
 
 Do you want to use the UNICODE character set?  [n] y
 
 *** Your current locale (C) is not Unicode and you are asking for
 *** a Unicode install.  Please adjust your LANG and LC_ALL variables.
 
 *** You can either change your UNICODE option or abort the
 *** installation to adjust your LANG and LC_ALL variables.
 Do you want to abort the installation? [n]
 
 I couldn't move on with the installation because it keeps asking the 
same
 question as above if I choose not to abort the installation.  I had to
 abort
 installation.
 
 I discussed this with my DBA and he sent me the database creation SQL
 statement as following:
 
 CREATE DATABASE rmdytst1
 MAXINSTANCES 8
 MAXLOGHISTORY 1
 MAXLOGFILES 16
 MAXLOGMEMBERS 3
 MAXDATAFILES 100
 DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE
 EXTENT
 MANAGEMENT LOCAL SYSAUX
 DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf'
 SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE
 '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE 
UNDO
 TABLESPACE UNDOTBS1
 DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE
 CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8
 
 Is character set specified in the SQL statement correct for UNICODE?  
If
 not, what's the right SQL statement?  My DBA thinks that AL32UTF-8 is a
 subset of UTF8, but should he change it to AL32UTF-8 during the initial
 database creation?
 
 
 Thanks in advance for your help.
 
 Eric Zhang
 Entergy Services, Inc.
 501-377-5815
 
 
__
 __
 ___
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
 
 
__
 _
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
 

 
___

 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


__
_
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
=

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9

2006-09-06 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: ARS 7 install issues with Oracle 10gR2 on Solaris 9
**





Eric:


The initial database instance MUST be created allowing for unicode support or the database might no have the proper support. I would consult the Oracle Installation Guide for further information. ARS can only use what the database provides it.

James McKenzie





-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Zhang
Sent: Wednesday, September 06, 2006 11:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9


Axton,


Does it matter how you create your initial database when you use those environment vars for installation?


Thanks,
Eric


On Wed, 6 Sep 2006 12:29:29 -0400, Axton [EMAIL PROTECTED] wrote:


I used the following env vars for the 7.0 installer on solaris 9 with 
Oracle. This allowed me to do the install with the single-byte and 
multi-byte support data (message catalog, etc.).

NLS_LANG=american
LANG=en_US.UTF-8
LC_ALL=en_US.UTF-8

Axton Grams

On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote:
 James,
 English is the base language.
 Thanks,
 Eric

 On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC 
 HQISEC/L3 [EMAIL PROTECTED] wrote:

 Eric:
 
 What language are you using as the base language? I may have a
 suggestion.
 
 James McKenzie
 
 
 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Zhang
 Sent: Wednesday, September 06, 2006 8:36 AM
 To: arslist@ARSLIST.ORG
 Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9
 
 Hello, All!
 
 I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am
 having a
 couple of issues:
 
 1. If we don't get ARSystem table space created prior to the
installation,
 we get the following error:
 
 An unknown Oracle error has been detected.
 Please resolve this error and re-try the installation.
 Refer to /tmp/arDBErrorLog for the Oracle error information.
 
 I checked /tmp/arDBErrorLog, it only has a time stamp, no other 
 error details.
 
 After the DBA created ARSystem table space, we were able to move on
with
 the
 installation. Remedy Tech Support recommends not to create ARSystem
prior
 to installation. If you have done ARS 7 installation with Oracle
10gR2,
 did
 you have to create ARSystem table space prior to installation?
 If you didn't create ARSystem table first, what's the default table
space
 for ARAdmin?
 
 
 2. We got the following after we chose to use UNICODE:
 
 Selecting UNICODE to create or overwrite an existing Oracle 
 tablespace REQUIRES that the database already be configured to 
 support the
AL32UTF-8
 UNICODE character set.
 
 If you are upgrading an existing database to use UNICODE, the 
 database
 must
 already be configured to support the UNICODE character set.
 
 Do you want to use the UNICODE character set? [n] y
 
 *** Your current locale (C) is not Unicode and you are asking for
 *** a Unicode install. Please adjust your LANG and LC_ALL variables.
 
 *** You can either change your UNICODE option or abort the
 *** installation to adjust your LANG and LC_ALL variables.
 Do you want to abort the installation? [n]
 
 I couldn't move on with the installation because it keeps asking the
same
 question as above if I choose not to abort the installation. I had 
 to
 abort
 installation.
 
 I discussed this with my DBA and he sent me the database creation 
 SQL statement as following:
 
 CREATE DATABASE rmdytst1
 MAXINSTANCES 8
 MAXLOGHISTORY 1
 MAXLOGFILES 16
 MAXLOGMEMBERS 3
 MAXDATAFILES 100
 DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE
 EXTENT
 MANAGEMENT LOCAL SYSAUX
 DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf'
 SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 
 '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE
UNDO
 TABLESPACE UNDOTBS1
 DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M 
 REUSE CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8
 
 Is character set specified in the SQL statement correct for UNICODE? 
If
 not, what's the right SQL statement? My DBA thinks that AL32UTF-8 
 is a subset of UTF8, but should he change it to AL32UTF-8 during the 
 initial database creation?
 
 
 Thanks in advance for your help.
 
 Eric Zhang
 Entergy Services, Inc.
 501-377-5815
 
 
___
___
 __
 ___
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
 
 
___
___
 _
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
 

 
___

 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


___
___
_
UNSUBSCRIBE or access ARSlist Archives at

Increase Performance Remedy 6

Hi

is there any way to increase the perfomance in Remedy 6?

Well my clientes told me that the processes in Remedy Help Desk are
very slow.
searching, generate reports and so on.

I think in general HD is slow in general, I changed Server Port and
Queues:

Type ---Min Threads ---
Max Threads

Admin --- 1
- 4
Fast -  2
- 4
List --  2
-  4

I need to change any other parameters to get the best of my server?


regards

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9

Carin,

A quick query shows:

NLS_CHARACTERSET
US7ASCII

NLS_NCHAR_CHARACTERSET
AL16UTF16

So, what values should we set for NLS_CHARACTERSET and 
NLS_NCHAR_CHARACTERSET to support UNICODE?

Thanks,
Eric

On Wed, 6 Sep 2006 10:47:48 -0500, Sinclair, Carin 
[EMAIL PROTECTED] wrote:

Eric, 

Make sure your oracle db character set is set for Unicode

select * from v$nls_parameters where parameter in
('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET');

If not set it and then try the install
Carin

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang
Sent: Wednesday, September 06, 2006 10:36 AM
To: arslist@ARSLIST.ORG
Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9

Hello, All!

I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2.  I am
having 
a couple of issues:

1. If we don't get ARSystem table space created prior to the
installation, 
we get the following error:

An unknown Oracle error has been detected.
Please resolve this error and re-try the installation.
Refer to /tmp/arDBErrorLog for the Oracle error information.

I checked /tmp/arDBErrorLog, it only has a time stamp, no other error 
details.

After the DBA created ARSystem table space, we were able to move on with

the installation.  Remedy Tech Support recommends not to create ARSystem

prior to installation.  If you have done ARS 7 installation with Oracle 
10gR2, did you have to create ARSystem table space prior to
installation?  
If you didn't create ARSystem table first, what's the default table
space 
for ARAdmin?


2. We got the following after we chose to use UNICODE:

Selecting UNICODE to create or overwrite an existing
Oracle tablespace REQUIRES that the database already
be configured to support the AL32UTF-8 UNICODE character set.

If you are upgrading an existing database to use UNICODE, the database
must already be configured to support the UNICODE character set.

Do you want to use the UNICODE character set?  [n] y

*** Your current locale (C) is not Unicode and you are asking for
*** a Unicode install.  Please adjust your LANG and LC_ALL variables.

*** You can either change your UNICODE option or abort the
*** installation to adjust your LANG and LC_ALL variables.
Do you want to abort the installation? [n]

I couldn't move on with the installation because it keeps asking the
same 
question as above if I choose not to abort the installation.  I had to 
abort installation.

I discussed this with my DBA and he sent me the database creation SQL 
statement as following:

CREATE DATABASE rmdytst1
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE 
EXTENT MANAGEMENT LOCAL SYSAUX 
DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf' SIZE 500M REUSE 
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP 
TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE 
SMALLFILE UNDO TABLESPACE UNDOTBS1 
DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE 
CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8

Is character set specified in the SQL statement correct for UNICODE?  If

not, what's the right SQL statement?  My DBA thinks that AL32UTF-8 is a 
subset of UTF8, but should he change it to AL32UTF-8 during the initial 
database creation?


Thanks in advance for your help.

Eric Zhang
Entergy Services, Inc.
501-377-5815


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

__
_
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Question: Disable ODBC

2006-09-06 Thread Jason Miller

**
Tyrone, absolutely you can restrict everybody except admins. That is the beauty of it, you have the flexibility of any query that can be run in a filter Run If.Firing on every get entry is definitely something to take into consideration and was one of my concerns. I figured since it is not a query to the db it wasn't too much of a performance hit for my situation (it is still an API call to the server each time you view a record but there are going to be other various API calls anyways when you view a record). Plus I didn't know about the Disable-Client-Operations option.
Thanks for the Disable-Client-Operation. This looks like an awesome feature that I will play with. You could actually get to the user level by creating a computed group and specify login names (or a mix of login names and groups). Depending on the size of your system and the way you have your groups setup it could become a maintenance burden to make sure all new users are properly restricted.
I guess this is were the get entry filter option has a bit more flexibility because you can disable everybody as a baseline and enable ODBC operations for a group with a NOT statement (i.e. NOT $GROUPS$ LIKE % + Administrator + % versus having to disable each group individually using the config file. But even then you could have a computed group with all groups except the Admin group to use with the Disable-Client-Operation. Many ways to do it (I love ARS).
JasonOn 9/6/06, Carey Matthew Black [EMAIL PROTECTED] wrote:
All,ConfigGuide-630.pdf Page: 287:Disable-Client-Operation: tag_number_to_disable [[start_time]-[stop_time]] [group_ID_list]Restricts time-consuming operations (such as reporting) during busy times,
improving the overall performance. This option can be set to certain timesthe day. It can also exclude users of specific groups so that they are notblocked from performing the specified operation. For example, you can
allow only the administrator to perform reporting during busy hours.So ... I think the config file option is the best bet. It would allowany specified groups to be _excluded_ from the restriction.
Jason's Get Entry filter option does go to one level more granular (tothe user not a group) and has the added performance expense of beingevaluated for every data row returned from the form. (Even for the
users listed in the Run If.)I wonder if the config option will (or was) similarly expanded likethe Assignee Group values were but BMC failed to document thatfeature? (Maybe you can be user specific in the config file? if not,
then it would be a good REF idea IMHO.)--Carey Matthew BlackRemedy Skilled Professional (RSP)ARS = Action Request System(Remedy)Love, then teachSolution = People + Process + ToolsFast, Accurate, Cheap Pick two.
___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125___This posting was submitted with HTML in it___

Re: Increase Performance Remedy 6

2006-09-06 Thread dcharters

What is your RAM and CPU Utilization? How is your Disk I/O on the DB? Is this 
Oracle or MSSQL?

On Wed, 6 Sep 2006 18:13:35 -, [EMAIL PROTECTED] wrote
 Hi
 
 is there any way to increase the perfomance in Remedy 6?
 
 Well my clientes told me that the processes in Remedy Help Desk are
 very slow.
 searching, generate reports and so on.
 
 I think in general HD is slow in general, I changed Server Port and
 Queues:
 
 Type ---Min Threads -
 -- Max Threads
 
 Admin --- 1
 - 4
 Fast -  2
 - 4
 List --  2
 -  4
 
 I need to change any other parameters to get the best of my server?
 
 regards
 
 
__
_
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


--
Open WebMail Project (http://openwebmail.org)

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

OT: Mercury SiteScope

2006-09-06 Thread McKenzie, James J C-E LCMC HQISEC/L3

**



Anyone out here 
working with this product? Contact me off-list, I have a few questions for 
you.

James 
McKenzie
L-3 
GSI

__20060125___This posting was submitted with HTML in it___

Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9

Thanks, James!

But can we just reset values in table v$nls_parameters for 
NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET instead of re-creating the 
database?

Thanks,
Eric



On Wed, 6 Sep 2006 11:13:57 -0700, McKenzie, James J C-E LCMC HQISEC/L3 
[EMAIL PROTECTED] wrote:

Eric:

The initial database instance MUST be created allowing for unicode support
or the database might no have the proper support.  I would consult the
Oracle Installation Guide for further information.  ARS can only use what
the database provides it.

James McKenzie



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang
Sent: Wednesday, September 06, 2006 11:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9

Axton,

Does it matter how you create your initial database when you use those
environment vars for installation?

Thanks,
Eric

On Wed, 6 Sep 2006 12:29:29 -0400, Axton [EMAIL PROTECTED] wrote:

I used the following env vars for the 7.0 installer on solaris 9 with
Oracle.  This allowed me to do the install with the single-byte and
multi-byte support data (message catalog, etc.).

NLS_LANG=american
LANG=en_US.UTF-8
LC_ALL=en_US.UTF-8

Axton Grams

On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote:
 James,
 English is the base language.
 Thanks,
 Eric

 On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC
 HQISEC/L3 [EMAIL PROTECTED] wrote:

 Eric:
 
 What language are you using as the base language?  I may have a
 suggestion.
 
 James McKenzie
 
 
 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang
 Sent: Wednesday, September 06, 2006 8:36 AM
 To: arslist@ARSLIST.ORG
 Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9
 
 Hello, All!
 
 I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2.  I am
 having a
 couple of issues:
 
 1. If we don't get ARSystem table space created prior to the
installation,
 we get the following error:
 
 An unknown Oracle error has been detected.
 Please resolve this error and re-try the installation.
 Refer to /tmp/arDBErrorLog for the Oracle error information.
 
 I checked /tmp/arDBErrorLog, it only has a time stamp, no other
 error details.
 
 After the DBA created ARSystem table space, we were able to move on
with
 the
 installation.  Remedy Tech Support recommends not to create ARSystem
prior
 to installation.  If you have done ARS 7 installation with Oracle
10gR2,
 did
 you have to create ARSystem table space prior to installation?
 If you didn't create ARSystem table first, what's the default table
space
 for ARAdmin?
 
 
 2. We got the following after we chose to use UNICODE:
 
 Selecting UNICODE to create or overwrite an existing Oracle
 tablespace REQUIRES that the database already be configured to
 support the
AL32UTF-8
 UNICODE character set.
 
 If you are upgrading an existing database to use UNICODE, the
 database
 must
 already be configured to support the UNICODE character set.
 
 Do you want to use the UNICODE character set?  [n] y
 
 *** Your current locale (C) is not Unicode and you are asking for
 *** a Unicode install.  Please adjust your LANG and LC_ALL variables.
 
 *** You can either change your UNICODE option or abort the
 *** installation to adjust your LANG and LC_ALL variables.
 Do you want to abort the installation? [n]
 
 I couldn't move on with the installation because it keeps asking the
same
 question as above if I choose not to abort the installation.  I had
 to
 abort
 installation.
 
 I discussed this with my DBA and he sent me the database creation
 SQL statement as following:
 
 CREATE DATABASE rmdytst1
 MAXINSTANCES 8
 MAXLOGHISTORY 1
 MAXLOGFILES 16
 MAXLOGMEMBERS 3
 MAXDATAFILES 100
 DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE
 EXTENT
 MANAGEMENT LOCAL SYSAUX
 DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf'
 SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE
 '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE
UNDO
 TABLESPACE UNDOTBS1
 DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M
 REUSE CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8
 
 Is character set specified in the SQL statement correct for UNICODE?
If
 not, what's the right SQL statement?  My DBA thinks that AL32UTF-8
 is a subset of UTF8, but should he change it to AL32UTF-8 during the
 initial database creation?
 
 
 Thanks in advance for your help.
 
 Eric Zhang
 Entergy Services, Inc.
 501-377-5815
 

___
___
 __
 ___
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
 

___
___
 _
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
 


__
_

 UNSUBSCRIBE or

Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9

2006-09-06 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: ARS 7 install issues with Oracle 10gR2 on Solaris 9
**





Eric:


I don't know, but think you will have to export all of the data in the database, recreate it and then import the data back in so that it will be converted to UNICODE.

James Mckenzie
L-3 GSI 


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Zhang
Sent: Wednesday, September 06, 2006 11:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9


Thanks, James!


But can we just reset values in table v$nls_parameters for NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET instead of re-creating the database?

Thanks,
Eric




On Wed, 6 Sep 2006 11:13:57 -0700, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote:


Eric:

The initial database instance MUST be created allowing for unicode 
support or the database might no have the proper support. I would 
consult the Oracle Installation Guide for further information. ARS can 
only use what the database provides it.

James McKenzie



-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Zhang
Sent: Wednesday, September 06, 2006 11:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9

Axton,

Does it matter how you create your initial database when you use those 
environment vars for installation?

Thanks,
Eric

On Wed, 6 Sep 2006 12:29:29 -0400, Axton [EMAIL PROTECTED] wrote:

I used the following env vars for the 7.0 installer on solaris 9 with 
Oracle. This allowed me to do the install with the single-byte and 
multi-byte support data (message catalog, etc.).

NLS_LANG=american
LANG=en_US.UTF-8
LC_ALL=en_US.UTF-8

Axton Grams

On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote:
 James,
 English is the base language.
 Thanks,
 Eric

 On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC
 HQISEC/L3 [EMAIL PROTECTED] wrote:

 Eric:
 
 What language are you using as the base language? I may have a
 suggestion.
 
 James McKenzie
 
 
 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Zhang
 Sent: Wednesday, September 06, 2006 8:36 AM
 To: arslist@ARSLIST.ORG
 Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9
 
 Hello, All!
 
 I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2. I am
 having a
 couple of issues:
 
 1. If we don't get ARSystem table space created prior to the
installation,
 we get the following error:
 
 An unknown Oracle error has been detected.
 Please resolve this error and re-try the installation.
 Refer to /tmp/arDBErrorLog for the Oracle error information.
 
 I checked /tmp/arDBErrorLog, it only has a time stamp, no other 
 error details.
 
 After the DBA created ARSystem table space, we were able to move on
with
 the
 installation. Remedy Tech Support recommends not to create 
 ARSystem
prior
 to installation. If you have done ARS 7 installation with Oracle
10gR2,
 did
 you have to create ARSystem table space prior to installation?
 If you didn't create ARSystem table first, what's the default table
space
 for ARAdmin?
 
 
 2. We got the following after we chose to use UNICODE:
 
 Selecting UNICODE to create or overwrite an existing Oracle 
 tablespace REQUIRES that the database already be configured to 
 support the
AL32UTF-8
 UNICODE character set.
 
 If you are upgrading an existing database to use UNICODE, the 
 database
 must
 already be configured to support the UNICODE character set.
 
 Do you want to use the UNICODE character set? [n] y
 
 *** Your current locale (C) is not Unicode and you are asking for
 *** a Unicode install. Please adjust your LANG and LC_ALL variables.
 
 *** You can either change your UNICODE option or abort the
 *** installation to adjust your LANG and LC_ALL variables.
 Do you want to abort the installation? [n]
 
 I couldn't move on with the installation because it keeps asking 
 the
same
 question as above if I choose not to abort the installation. I had 
 to
 abort
 installation.
 
 I discussed this with my DBA and he sent me the database creation 
 SQL statement as following:
 
 CREATE DATABASE rmdytst1
 MAXINSTANCES 8
 MAXLOGHISTORY 1
 MAXLOGFILES 16
 MAXLOGMEMBERS 3
 MAXDATAFILES 100
 DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M 
 REUSE
 EXTENT
 MANAGEMENT LOCAL SYSAUX
 DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf'
 SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP 
 TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE 
 SMALLFILE
UNDO
 TABLESPACE UNDOTBS1
 DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M 
 REUSE CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8
 
 Is character set specified in the SQL statement correct for UNICODE?
If
 not, what's the right SQL statement? My DBA thinks that AL32UTF-8 
 is a subset of UTF8, but

Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9

2006-09-06 Thread Sinclair, Carin

US7ASCII supports 7 bit characters. For US English users in the United
States, this could suffice. 
If you are going anywhere other try WE8ISO8859P1 character set it
supports most Europeen languages. This is the Oracle default character
set and can support 8 bit characters.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang
Sent: Wednesday, September 06, 2006 1:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9

Carin,

A quick query shows:

NLS_CHARACTERSET
US7ASCII

NLS_NCHAR_CHARACTERSET
AL16UTF16

So, what values should we set for NLS_CHARACTERSET and 
NLS_NCHAR_CHARACTERSET to support UNICODE?

Thanks,
Eric

On Wed, 6 Sep 2006 10:47:48 -0500, Sinclair, Carin 
[EMAIL PROTECTED] wrote:

Eric, 

Make sure your oracle db character set is set for Unicode

select * from v$nls_parameters where parameter in
('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET');

If not set it and then try the install
Carin

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang
Sent: Wednesday, September 06, 2006 10:36 AM
To: arslist@ARSLIST.ORG
Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9

Hello, All!

I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2.  I am
having 
a couple of issues:

1. If we don't get ARSystem table space created prior to the
installation, 
we get the following error:

An unknown Oracle error has been detected.
Please resolve this error and re-try the installation.
Refer to /tmp/arDBErrorLog for the Oracle error information.

I checked /tmp/arDBErrorLog, it only has a time stamp, no other error 
details.

After the DBA created ARSystem table space, we were able to move on
with

the installation.  Remedy Tech Support recommends not to create
ARSystem

prior to installation.  If you have done ARS 7 installation with Oracle

10gR2, did you have to create ARSystem table space prior to
installation?  
If you didn't create ARSystem table first, what's the default table
space 
for ARAdmin?


2. We got the following after we chose to use UNICODE:

Selecting UNICODE to create or overwrite an existing
Oracle tablespace REQUIRES that the database already
be configured to support the AL32UTF-8 UNICODE character set.

If you are upgrading an existing database to use UNICODE, the database
must already be configured to support the UNICODE character set.

Do you want to use the UNICODE character set?  [n] y

*** Your current locale (C) is not Unicode and you are asking for
*** a Unicode install.  Please adjust your LANG and LC_ALL variables.

*** You can either change your UNICODE option or abort the
*** installation to adjust your LANG and LC_ALL variables.
Do you want to abort the installation? [n]

I couldn't move on with the installation because it keeps asking the
same 
question as above if I choose not to abort the installation.  I had to 
abort installation.

I discussed this with my DBA and he sent me the database creation SQL 
statement as following:

CREATE DATABASE rmdytst1
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE 
EXTENT MANAGEMENT LOCAL SYSAUX 
DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf' SIZE 500M REUSE 
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP 
TEMPFILE '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE 
SMALLFILE UNDO TABLESPACE UNDOTBS1 
DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M REUSE 
CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8

Is character set specified in the SQL statement correct for UNICODE?
If

not, what's the right SQL statement?  My DBA thinks that AL32UTF-8 is a

subset of UTF8, but should he change it to AL32UTF-8 during the initial

database creation?


Thanks in advance for your help.

Eric Zhang
Entergy Services, Inc.
501-377-5815

___
_
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
___
_
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
===
=


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9


This is the way our instance was built.

SQL select * from v$nls_parameters where parameter in
 2  ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET');

PARAMETER   VALUE
--- -
NLS_CHARACTERSETUTF8
NLS_NCHAR_CHARACTERSET  UTF8

Axton Grams

On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote:

Thanks, James!

But can we just reset values in table v$nls_parameters for
NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET instead of re-creating the
database?

Thanks,
Eric



On Wed, 6 Sep 2006 11:13:57 -0700, McKenzie, James J C-E LCMC HQISEC/L3
[EMAIL PROTECTED] wrote:

Eric:

The initial database instance MUST be created allowing for unicode support
or the database might no have the proper support.  I would consult the
Oracle Installation Guide for further information.  ARS can only use what
the database provides it.

James McKenzie



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang
Sent: Wednesday, September 06, 2006 11:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9

Axton,

Does it matter how you create your initial database when you use those
environment vars for installation?

Thanks,
Eric

On Wed, 6 Sep 2006 12:29:29 -0400, Axton [EMAIL PROTECTED] wrote:

I used the following env vars for the 7.0 installer on solaris 9 with
Oracle.  This allowed me to do the install with the single-byte and
multi-byte support data (message catalog, etc.).

NLS_LANG=american
LANG=en_US.UTF-8
LC_ALL=en_US.UTF-8

Axton Grams

On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote:
 James,
 English is the base language.
 Thanks,
 Eric

 On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC
 HQISEC/L3 [EMAIL PROTECTED] wrote:

 Eric:
 
 What language are you using as the base language?  I may have a
 suggestion.
 
 James McKenzie
 
 
 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang
 Sent: Wednesday, September 06, 2006 8:36 AM
 To: arslist@ARSLIST.ORG
 Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9
 
 Hello, All!
 
 I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2.  I am
 having a
 couple of issues:
 
 1. If we don't get ARSystem table space created prior to the
installation,
 we get the following error:
 
 An unknown Oracle error has been detected.
 Please resolve this error and re-try the installation.
 Refer to /tmp/arDBErrorLog for the Oracle error information.
 
 I checked /tmp/arDBErrorLog, it only has a time stamp, no other
 error details.
 
 After the DBA created ARSystem table space, we were able to move on
with
 the
 installation.  Remedy Tech Support recommends not to create ARSystem
prior
 to installation.  If you have done ARS 7 installation with Oracle
10gR2,
 did
 you have to create ARSystem table space prior to installation?
 If you didn't create ARSystem table first, what's the default table
space
 for ARAdmin?
 
 
 2. We got the following after we chose to use UNICODE:
 
 Selecting UNICODE to create or overwrite an existing Oracle
 tablespace REQUIRES that the database already be configured to
 support the
AL32UTF-8
 UNICODE character set.
 
 If you are upgrading an existing database to use UNICODE, the
 database
 must
 already be configured to support the UNICODE character set.
 
 Do you want to use the UNICODE character set?  [n] y
 
 *** Your current locale (C) is not Unicode and you are asking for
 *** a Unicode install.  Please adjust your LANG and LC_ALL variables.
 
 *** You can either change your UNICODE option or abort the
 *** installation to adjust your LANG and LC_ALL variables.
 Do you want to abort the installation? [n]
 
 I couldn't move on with the installation because it keeps asking the
same
 question as above if I choose not to abort the installation.  I had
 to
 abort
 installation.
 
 I discussed this with my DBA and he sent me the database creation
 SQL statement as following:
 
 CREATE DATABASE rmdytst1
 MAXINSTANCES 8
 MAXLOGHISTORY 1
 MAXLOGFILES 16
 MAXLOGMEMBERS 3
 MAXDATAFILES 100
 DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE
 EXTENT
 MANAGEMENT LOCAL SYSAUX
 DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf'
 SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE
 '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE
UNDO
 TABLESPACE UNDOTBS1
 DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M
 REUSE CHARACTER SET US7ASCII NATIONAL CHARACTER SET UTF8
 
 Is character set specified in the SQL statement correct for UNICODE?
If
 not, what's the right SQL statement?  My DBA thinks that AL32UTF-8
 is a subset of UTF8, but should he change it to AL32UTF-8 during the
 initial database creation?
 
 
 Thanks in advance for your help.
 
 Eric Zhang
 Entergy Services, Inc.
 501-377-5815
 

___
___

Cisco Works Adapter

2006-09-06 Thread Theo Simmons

Good afternoon listers-

Does anyone know if there is an adapter for the EIE built for the Ciscoworks
product?

Thanks in advance
Theo

ARS 6.3
MS SQL 2K
Windows 2k

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Increase Performance Remedy 6

before to find out the other points you asked me
well, It's a


Unix Server AIX 5.3
Remedy 6
Help desk 6.3
Websphere 5.1
DB2 8.1

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Created 15,000 tickets

2006-09-06 Thread Kathy Morris

**



Hi all,

Because some workflow had the wrong qualification from a previous 
developer, 15,000 tickets were generated. We left off at 7,000 and now we 
are at 22,000. Isn't there a way thru SQLto reset the value of the 
HPD to 7,000 so Remedy goes to set the next ID, it will think the last ID is 
7,000. We also want to rename the HPD tickets created today with a 7,000 
value within the database.

Our case ID is C1, I can find out the t table, I am just not sure which 
command I would enter to modify the rows in the database. And if this will 
present problems later. I know the users will be referencing the wrong 
ticket number. We definitely do not want to be at 22,000.


__20060125___This posting was submitted with HTML in it___

Error 91

2006-09-06 Thread Dawe, Byron

Hi Listers;

Has anyone ever gotten an:

Message type : ERROR
   Message number :  91
   Message:  Cannot open catalog; Message number = 91
   Appended:  RPC: Procedure unavailable

When trying to do a simple retrieve with the cmdbdriver program before??

I do an init and a log, they seem to work Ok, but the 'gc' bombs!

My driver program works fine, but my cmdbdriver still refuses to rise
from the preverbial ashes!

Thanks to all,

Byron. 

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Created 15,000 tickets

2006-09-06 Thread Nall, Roger

**








Kathy,



Another trick is to create a view form to
the arschema table. You can probably figure out what to do from there. No SQL
involved. Just need to be careful.



HTH,





Roger A. Nall

OSSNMS Sr. Remedy Administrator/Developer

T-Mobile USA

Desk: 973-644-3963

Cell: 973-652-6723

FAX: 973-267-6628

sf49fanv AIM IM

RogerNall Yahoo IM













From: Action Request
System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of Kemes, Lisa
Sent: Wednesday, September 06,
2006 3:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: Created 15,000
tickets





Here's the SQL that we use to reset the
request id: update ARAdmin.arschema set nextId = 1763 where name
='FormName';









From: Action Request System
discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of Kathy Morris
Sent: Wednesday, September 06,
2006 3:11 PM
To: arslist@ARSLIST.ORG
Subject: Created 15,000 tickets

** 



Hi all,











Because some workflow had the wrong
qualification from a previous developer, 15,000 tickets were generated.
We left off at 7,000 and now we are at 22,000. Isn't there a way thru
SQLto reset the value of the HPD to 7,000 so Remedy goes to set the next
ID, it will think the last ID is 7,000. We also want to rename the HPD
tickets created today with a 7,000 value within the database.











Our case ID is C1, I can find out the t
table, I am just not sure which command I would enter to modify the rows in the
database. And if this will present problems later. I know the users
will be referencing the wrong ticket number. We definitely do not want to
be at 22,000.















__20060125___This
posting was submitted with HTML in it___ 






__20060125___This posting was submitted with HTML in it___
__20060125___This posting was submitted with HTML in it___

Business Hours tag - Dynamic reference to group tags

Hello,

Issue is, SLA 6.0, we're looking to leverage business hours tags for
40+ groups, we don't want to have dozens of SLA's to accomplish this.
The Group/Idividual business hours tag is tied to each SLA on a one to
one basis, we need to be able to pass the group (on task) into the SLA
during creation.  Anyone seen an easy way to accomplish this?

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

test

test

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Multiple Groups with different Business Time Tags using same SLA.

2006-09-06 Thread Jase Brandon

**



Hello 
Listers,
Please excuse my SLA 
newbie questions. Irecently was assignedSLA Module 6.0 Out of 
the Box and don't know how to overcome some of these obstacles and have an 
important Demo in the morning.

Problem:
We have multiple 
groups eachwith different business time tags that want to use the same 
SLA. Only one business time tag entry is allowed on an SLA. How can I overcome 
this?

How can I configure 
an SLA so that groups with different business hours tags can use the same SLA? 
Do I just create multiple SLA's referencing each business time 
tag?

Is offset hours the 
answer?

How do I overcome a a virtual group spanning multiple 
time zones using the same business time tag of 8am-5pm? 

Ex. I don't want a group member in eastern time to 
"losethree hours" if a case with SLAin progresis created in 
Pacific Time and Eastern Team Member has gone home for the 
day.

Some teams also 
operate on different business hours within the same time zone and I want them to 
be able to use the same SLA, but with different business time 
tags.

Thanks in advance! 


ARServer 
6.3
Help Desk 
6.0 
SLA 
6.0




DaVita Inc.

__20060125___This posting was submitted with HTML in it___

Re: Created 15,000 tickets

2006-09-06 Thread Susan Palmer

**
I like to run the following statement before and after Lisa's command to make sure the change is effective

select name, nextId from aradmin.arschema where name = 'CHG:Task';

Initially you'll see what the system says is nextId, and then after the update you should see what you have now defined as the nextId

You are deleting all of those autogenerated tickets before you're resetting the ID or you will have unique record errors upon the creation of a ticket after the id is reset.

hth,
Susan
On 9/6/06, Nall, Roger [EMAIL PROTECTED] wrote:

** 


Kathy,

Another trick is to create a view form to the arschema table. You can probably figure out what to do from there. No SQL involved. Just need to be careful.


HTH,


Roger A. Nall
OSSNMS Sr. Remedy Administrator/Developer

T-Mobile USA
Desk: 973-644-3963
Cell: 973-652-6723
FAX: 973-267-6628
sf49fanv AIM IM
RogerNall Yahoo IM





From: Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa
Sent: Wednesday, September 06, 2006 3:13 PMTo: arslist@ARSLIST.ORG

Subject: Re: Created 15,000 tickets




Here's the SQL that we use to reset the request id: update ARAdmin.arschema set nextId = 1763 where name ='FormName';





From:
 Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] On Behalf Of Kathy MorrisSent: Wednesday, September 06, 2006 3:11 PM
To: arslist@ARSLIST.ORGSubject: Created 15,000 tickets

** 

Hi all,



Because some workflow had the wrong qualification from a previous developer, 15,000 tickets were generated. We left off at 7,000 and now we are at 22,000. Isn't there a way thru SQLto reset the value of the HPD to 7,000 so Remedy goes to set the next ID, it will think the last ID is 7,000. We also want to rename the HPD tickets created today with a 7,000 value within the database.




Our case ID is C1, I can find out the t table, I am just not sure which command I would enter to modify the rows in the database. And if this will present problems later. I know the users will be referencing the wrong ticket number. We definitely do not want to be at 22,000.





__20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___

Re: Created 15,000 tickets

2006-09-06 Thread Susan Palmer

**
Sorry, didn't notice you want to renumber some existing tickets for today. If you're using something that uses the SHR:Consolidated form you need to make sure those records are updated also. 

Sounds like you may need a temporary field to hold the existing ID before any changes are made to that field if it is referenced in other forms or you loose that connection. You could make this visible for reference if a customer provides that number also.

On 9/6/06, Susan Palmer [EMAIL PROTECTED] wrote:


I like to run the following statement before and after Lisa's command to make sure the change is effective

select name, nextId from aradmin.arschema where name = 'CHG:Task';

Initially you'll see what the system says is nextId, and then after the update you should see what you have now defined as the nextId

You are deleting all of those autogenerated tickets before you're resetting the ID or you will have unique record errors upon the creation of a ticket after the id is reset.

hth,

Susan

On 9/6/06, Nall, Roger [EMAIL PROTECTED]
 wrote: 

** 


Kathy,

Another trick is to create a view form to the arschema table. You can probably figure out what to do from there. No SQL involved. Just need to be careful. 


HTH,


Roger A. Nall
OSSNMS Sr. Remedy Administrator/Developer
 
T-Mobile USA
Desk: 973-644-3963
Cell: 973-652-6723
FAX: 973-267-6628
sf49fanv AIM IM
RogerNall Yahoo IM





From: Action Request System discussion list(ARSList) [mailto: 
arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa
Sent: Wednesday, September 06, 2006 3:13 PMTo: arslist@ARSLIST.ORG 

Subject: Re: Created 15,000 tickets




Here's the SQL that we use to reset the request id: update ARAdmin.arschema set nextId = 1763 where name ='FormName'; 





From:
 Action Request System discussion list(ARSList) [mailto:
 arslist@ARSLIST.ORG] On Behalf Of Kathy MorrisSent: Wednesday, September 06, 2006 3:11 PM
To: arslist@ARSLIST.ORGSubject: Created 15,000 tickets 

** 

Hi all,



Because some workflow had the wrong qualification from a previous developer, 15,000 tickets were generated. We left off at 7,000 and now we are at 22,000. Isn't there a way thru SQLto reset the value of the HPD to 7,000 so Remedy goes to set the next ID, it will think the last ID is 7,000. We also want to rename the HPD tickets created today with a 7,000 value within the database. 




Our case ID is C1, I can find out the t table, I am just not sure which command I would enter to modify the rows in the database. And if this will present problems later. I know the users will be referencing the wrong ticket number. We definitely do not want to be at 22,000. 





__20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ 

__20060125___This posting was submitted with HTML in it___

Re: Created 15,000 tickets

2006-09-06 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: Created 15,000 tickets
**





Susan:

You said it. Please delete the autogenerated tickets and any created after this BEFORE resetting the nextid or you will not be able to input any new entries. This cannot be stressed enough. I have done this and had users jumping up and down on my desk while I was trying to fix it. 


I suggest practicing on your development server before doing this on a production system unless you have reset the nextid on another form.


James McKenzie
L-3 GSI






From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Susan Palmer
Sent: Wednesday, September 06, 2006 1:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Created 15,000 tickets



** 
I like to run the following statement before and after Lisa's command to make sure the change is effective

select name, nextId from aradmin.arschema where name = 'CHG:Task';

Initially you'll see what the system says is nextId, and then after the update you should see what you have now defined as the nextId


You are deleting all of those autogenerated tickets before you're resetting the ID or you will have unique record errors upon the creation of a ticket after the id is reset.


hth,
Susan



On 9/6/06, Nall, Roger [EMAIL PROTECTED] wrote: 


 ** 


 Kathy,


 


 Another trick is to create a view form to the arschema table. You can probably figure out what to do from there. No SQL involved. Just need to be careful. 

 


 HTH,


 


 Roger A. Nall


 OSSNMS Sr. Remedy Administrator/Developer 


 T-Mobile USA


 Desk: 973-644-3963


 Cell: 973-652-6723


 FAX: 973-267-6628


 sf49fanv AIM IM


 RogerNall Yahoo IM


 


 


  From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of Kemes, Lisa

 Sent: Wednesday, September 06, 2006 3:13 PM
 To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG 


 
 Subject: Re: Created 15,000 tickets


  


 Here's the SQL that we use to reset the request id: update ARAdmin.arschema set nextId = 1763 where name = 'FormName'; 

 


 


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

 Sent: Wednesday, September 06, 2006 3:11 PM
 To: arslist@ARSLIST.ORG
 Subject: Created 15,000 tickets 


 ** 


 Hi all,


 


 Because some workflow had the wrong qualification from a previous developer, 15,000 tickets were generated. We left off at 7,000 and now we are at 22,000. Isn't there a way thru SQL to reset the value of the HPD to 7,000 so Remedy goes to set the next ID, it will think the last ID is 7,000. We also want to rename the HPD tickets created today with a 7,000 value within the database. 

 


 Our case ID is C1, I can find out the t table, I am just not sure which command I would enter to modify the rows in the database. And if this will present problems later. I know the users will be referencing the wrong ticket number. We definitely do not want to be at 22,000. 

 


 


 __20060125___This posting was submitted with HTML in it___ 


  __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ 


__20060125___This posting was submitted with HTML in it___ 




__20060125___This posting was submitted with HTML in it___

Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9


See 
http://arswiki.org/wiki/index.php?title=ARS_7.0_Topics#Fresh_Install_Message_Catalog_Data_Import_Failure
for another issue with solaris/oracle install issues if you plan to do
a fresh install with all language packs.

Axton Grams

On 9/6/06, Axton [EMAIL PROTECTED] wrote:

This is the way our instance was built.

SQL select * from v$nls_parameters where parameter in
 2  ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET');

PARAMETER   VALUE
--- -
NLS_CHARACTERSETUTF8
NLS_NCHAR_CHARACTERSET  UTF8

Axton Grams

On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote:
 Thanks, James!

 But can we just reset values in table v$nls_parameters for
 NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET instead of re-creating the
 database?

 Thanks,
 Eric



 On Wed, 6 Sep 2006 11:13:57 -0700, McKenzie, James J C-E LCMC HQISEC/L3
 [EMAIL PROTECTED] wrote:

 Eric:
 
 The initial database instance MUST be created allowing for unicode support
 or the database might no have the proper support.  I would consult the
 Oracle Installation Guide for further information.  ARS can only use what
 the database provides it.
 
 James McKenzie
 
 
 
 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang
 Sent: Wednesday, September 06, 2006 11:07 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
 
 Axton,
 
 Does it matter how you create your initial database when you use those
 environment vars for installation?
 
 Thanks,
 Eric
 
 On Wed, 6 Sep 2006 12:29:29 -0400, Axton [EMAIL PROTECTED] wrote:
 
 I used the following env vars for the 7.0 installer on solaris 9 with
 Oracle.  This allowed me to do the install with the single-byte and
 multi-byte support data (message catalog, etc.).
 
 NLS_LANG=american
 LANG=en_US.UTF-8
 LC_ALL=en_US.UTF-8
 
 Axton Grams
 
 On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote:
  James,
  English is the base language.
  Thanks,
  Eric
 
  On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC
  HQISEC/L3 [EMAIL PROTECTED] wrote:
 
  Eric:
  
  What language are you using as the base language?  I may have a
  suggestion.
  
  James McKenzie
  
  
  -Original Message-
  From: Action Request System discussion list(ARSList)
  [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang
  Sent: Wednesday, September 06, 2006 8:36 AM
  To: arslist@ARSLIST.ORG
  Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9
  
  Hello, All!
  
  I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2.  I am
  having a
  couple of issues:
  
  1. If we don't get ARSystem table space created prior to the
 installation,
  we get the following error:
  
  An unknown Oracle error has been detected.
  Please resolve this error and re-try the installation.
  Refer to /tmp/arDBErrorLog for the Oracle error information.
  
  I checked /tmp/arDBErrorLog, it only has a time stamp, no other
  error details.
  
  After the DBA created ARSystem table space, we were able to move on
 with
  the
  installation.  Remedy Tech Support recommends not to create ARSystem
 prior
  to installation.  If you have done ARS 7 installation with Oracle
 10gR2,
  did
  you have to create ARSystem table space prior to installation?
  If you didn't create ARSystem table first, what's the default table
 space
  for ARAdmin?
  
  
  2. We got the following after we chose to use UNICODE:
  
  Selecting UNICODE to create or overwrite an existing Oracle
  tablespace REQUIRES that the database already be configured to
  support the
 AL32UTF-8
  UNICODE character set.
  
  If you are upgrading an existing database to use UNICODE, the
  database
  must
  already be configured to support the UNICODE character set.
  
  Do you want to use the UNICODE character set?  [n] y
  
  *** Your current locale (C) is not Unicode and you are asking for
  *** a Unicode install.  Please adjust your LANG and LC_ALL variables.
  
  *** You can either change your UNICODE option or abort the
  *** installation to adjust your LANG and LC_ALL variables.
  Do you want to abort the installation? [n]
  
  I couldn't move on with the installation because it keeps asking the
 same
  question as above if I choose not to abort the installation.  I had
  to
  abort
  installation.
  
  I discussed this with my DBA and he sent me the database creation
  SQL statement as following:
  
  CREATE DATABASE rmdytst1
  MAXINSTANCES 8
  MAXLOGHISTORY 1
  MAXLOGFILES 16
  MAXLOGMEMBERS 3
  MAXDATAFILES 100
  DATAFILE '/data/oradata/rmdytst1/db01/system_01.dbf' SIZE 800M REUSE
  EXTENT
  MANAGEMENT LOCAL SYSAUX
  DATAFILE '/data/oradata/rmdytst1/db01/sysaux_01.dbf'
  SIZE 500M REUSE SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE
  '/data/oradata/rmdytst1/db01/temp_01.dbf' SIZE 400M REUSE SMALLFILE
 UNDO
  TABLESPACE UNDOTBS1
  DATAFILE '/data/oradata/rmdytst1/db01/undotbs_01.dbf' SIZE 400M
  REUSE CHARACTER SET US7ASCII NATIONAL

Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9


Also, if the installer exits at this point, then it didn't complete
successfully.

#
Installing Flash Objects: Mon Jul 24 21:05:36 EDT 2006

./ar_install: test: unknown operator dbVersion
#


The installer dies at this point:

In the stage 6 of the install script:

12299  # Import required and selected plugins
12300  ImportPlugins

12301  ImportFlash


Now in the importFlash function:

3279  ##
3280  # ImportFlash - Upgrade and import FlashObject Forms
3281  #
3282  ##
3283  ImportFlash()
3284  {
3285  lecho Installing Flash Objects: `date` 
3286  lecho
3287  SAMPLE_FORMS=$INSTALL_DIR/samples/en
3288  $CD $SAMPLE_FORMS
3289

 3290  if [ ${DB_UPGRADE} -eq 1 -a ${ARS_VER} -lt 21 ]; then

3291  LoadSchemaWithRIK FlashForms ${IMPORT_MODE}
${UPGRD_USER} ${UPGRD_PASS}
3292  if [ $? -ne 0 ]; then
3293  lecho FlashForms  failed to import.
3294  lecho Problems encountered while importing the
form FlashForms.def
3295  lecho Please refer to the log in
$INSTALL_DIR/Logs/ for further details.
3296  else
3297  note FlashForms successfully installed.
3298  fi
3299  fi


From the output, I can tell that the first line of this function ran.


In the ArEnvHistory file, these are the values of the vars used in the
if statement:

DB_UPGRADE=0
ARS_VER=select dbVersion from control

Obviously the if statement can't handle the sql statement.



Below is a 'sloppy' hack to get new installs (only) to complete successfully.

[EMAIL PROTECTED]:/var/log/remedy/media/ars70p1/ars70p001/arsystem diff
-u ar_install.bak ar_install
--- ar_install.bak  Mon Jul 24 10:41:19 2006
+++ ar_install  Mon Jul 24 21:36:28 2006
@@ -11780,6 +11785,7 @@

# Stage 6 : Set up sample forms and Demo

+ARS_VER=0; export ARS_VER
STAGE=6
LogOnly Stage 6: `date`
if [ $FRESH_INSTALL -eq 1 ]; then

Axton Grams

On 9/6/06, Axton [EMAIL PROTECTED] wrote:

See 
http://arswiki.org/wiki/index.php?title=ARS_7.0_Topics#Fresh_Install_Message_Catalog_Data_Import_Failure
for another issue with solaris/oracle install issues if you plan to do
a fresh install with all language packs.

Axton Grams

On 9/6/06, Axton [EMAIL PROTECTED] wrote:
 This is the way our instance was built.

 SQL select * from v$nls_parameters where parameter in
  2  ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET');

 PARAMETER   VALUE
 --- -
 NLS_CHARACTERSETUTF8
 NLS_NCHAR_CHARACTERSET  UTF8

 Axton Grams

 On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote:
  Thanks, James!
 
  But can we just reset values in table v$nls_parameters for
  NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET instead of re-creating the
  database?
 
  Thanks,
  Eric
 
 
 
  On Wed, 6 Sep 2006 11:13:57 -0700, McKenzie, James J C-E LCMC HQISEC/L3
  [EMAIL PROTECTED] wrote:
 
  Eric:
  
  The initial database instance MUST be created allowing for unicode support
  or the database might no have the proper support.  I would consult the
  Oracle Installation Guide for further information.  ARS can only use what
  the database provides it.
  
  James McKenzie
  
  
  
  -Original Message-
  From: Action Request System discussion list(ARSList)
  [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang
  Sent: Wednesday, September 06, 2006 11:07 AM
  To: arslist@ARSLIST.ORG
  Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
  
  Axton,
  
  Does it matter how you create your initial database when you use those
  environment vars for installation?
  
  Thanks,
  Eric
  
  On Wed, 6 Sep 2006 12:29:29 -0400, Axton [EMAIL PROTECTED] wrote:
  
  I used the following env vars for the 7.0 installer on solaris 9 with
  Oracle.  This allowed me to do the install with the single-byte and
  multi-byte support data (message catalog, etc.).
  
  NLS_LANG=american
  LANG=en_US.UTF-8
  LC_ALL=en_US.UTF-8
  
  Axton Grams
  
  On 9/6/06, Eric Zhang [EMAIL PROTECTED] wrote:
   James,
   English is the base language.
   Thanks,
   Eric
  
   On Wed, 6 Sep 2006 08:41:59 -0700, McKenzie, James J C-E LCMC
   HQISEC/L3 [EMAIL PROTECTED] wrote:
  
   Eric:
   
   What language are you using as the base language?  I may have a
   suggestion.
   
   James McKenzie
   
   
   -Original Message-
   From: Action Request System discussion list(ARSList)
   [mailto:[EMAIL PROTECTED] On Behalf Of Eric Zhang
   Sent: Wednesday, September 06, 2006 8:36 AM
   To: arslist@ARSLIST.ORG
   Subject: ARS 7 install issues with Oracle 10gR2 on Solaris 9
   
   Hello, All!
   
   I am installing ARS 7.0 on a Solaris 9 box with Oracle 10gR2.  I am
   having a
   couple of issues:
   
   1. If

Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9

2006-09-06 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: ARS 7 install issues with Oracle 10gR2 on Solaris 9
**





Axton:


This is b code here:


ARS_VER=select dbVersion from control


This should be a number not a select statement for SQL.


I'm wondering why it did not work.


James McKenzie



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Wednesday, September 06, 2006 1:23 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9


Also, if the installer exits at this point, then it didn't complete successfully.


#
Installing Flash Objects: Mon Jul 24 21:05:36 EDT 2006


./ar_install: test: unknown operator dbVersion #



The installer dies at this point:


In the stage 6 of the install script:


12299 # Import required and selected plugins
12300 ImportPlugins
 12301 ImportFlash


Now in the importFlash function:


3279 ##
3280 # ImportFlash - Upgrade and import FlashObject Forms
3281 #
3282 ##
3283 ImportFlash()
3284 {
3285 lecho Installing Flash Objects: `date` 
3286 lecho
3287 SAMPLE_FORMS=$INSTALL_DIR/samples/en
3288 $CD $SAMPLE_FORMS
3289
 3290 if [ ${DB_UPGRADE} -eq 1 -a ${ARS_VER} -lt 21 ]; then
3291 LoadSchemaWithRIK FlashForms ${IMPORT_MODE}
${UPGRD_USER} ${UPGRD_PASS}
3292 if [ $? -ne 0 ]; then
3293 lecho FlashForms failed to import.
3294 lecho Problems encountered while importing the
form FlashForms.def
3295 lecho Please refer to the log in
$INSTALL_DIR/Logs/ for further details.
3296 else
3297 note FlashForms successfully installed.
3298 fi
3299 fi


From the output, I can tell that the first line of this function ran.


In the ArEnvHistory file, these are the values of the vars used in the if statement:


DB_UPGRADE=0
ARS_VER=select dbVersion from control


Obviously the if statement can't handle the sql statement.




Below is a 'sloppy' hack to get new installs (only) to complete successfully.


[EMAIL PROTECTED]:/var/log/remedy/media/ars70p1/ars70p001/arsystem diff -u ar_install.bak ar_install
--- ar_install.bak Mon Jul 24 10:41:19 2006
+++ ar_install Mon Jul 24 21:36:28 2006
@@ -11780,6 +11785,7 @@

# Stage 6 : Set up sample forms and Demo 
+ARS_VER=0; export ARS_VER
STAGE=6
LogOnly Stage 6: `date`
if [ $FRESH_INSTALL -eq 1 ]; then


Axton Grams




__20060125___This posting was submitted with HTML in it___

Install of 7.0

2006-09-06 Thread Pam Hollis

I have began the process of installing ARSystem 7.0.  This is a fresh 
install on a new box.  Linux - Oracle 10g

Everything installed cleaned and successfully - I have bounced the server 
and everything is up and running.  But, I am unable to login to the User 
Tool as Demo.

Any suggestions.

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Multiple Groups with different Business Time Tags using same SLA.

2006-09-06 Thread Jase Brandon

**



Hello Listers,
Please excuse my SLA 
newbie questions. Irecently was assignedSLA Module 6.0 Out of 
the Box and don't know how to overcome some of these obstacles and have an 
important Demo in the morning.

Problem:
We have multiple 
groups eachwith different business time tags that want to use the same 
SLA. Only one business time tag entry is allowed on an SLA. How can I overcome 
this?

How can I configure 
an SLA so that groups with different business hours tags can use the same SLA? 
Do I just create multiple SLA's referencing each business time 
tag?

Is offset hours the 
answer?

How do I overcome a a virtual group spanning multiple 
time zones using the same business time tag of 8am-5pm? 

Ex. I don't want a group member in eastern time to 
"losethree hours" if a case with SLAin progresis created in 
Pacific Time and Eastern Team Member has gone home for the 
day.

Some teams also 
operate on different business hours within the same time zone and I want them to 
be able to use the same SLA, but with different business time 
tags.

Thanks in 
advance!


Jase Brandon 
Remedy Administration/Development 
Customer Support Systems Group
Desk - (615) - 320-4494
Cell - (334) - 
318-5426
[EMAIL PROTECTED]

ARServer 
6.3
Help Desk 
6.0 
SLA 
6.0




DaVita Inc.

__20060125___This posting was submitted with HTML in it___

Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9


Didn't spend the time to investiage, reported it as a bug and made a
quick/dirty fix to get the installer to complete properly.  The only
thing that fails to import when this happens are the fb
forms/workflow.

Axton Grams

On 9/6/06, McKenzie, James J C-E LCMC HQISEC/L3
[EMAIL PROTECTED] wrote:

**


Axton:

This is b code here:


ARS_VER=select dbVersion from control


This should be a number not a select statement for SQL.

I'm wondering why it did not work.


James McKenzie



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Wednesday, September 06, 2006 1:23 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9


Also, if the installer exits at this point, then it didn't complete
successfully.

#
Installing Flash Objects: Mon Jul 24 21:05:36 EDT 2006

./ar_install: test: unknown operator dbVersion
#


The installer dies at this point:

In the stage 6 of the install script:

 12299  # Import required and selected plugins
 12300  ImportPlugins
 12301  ImportFlash

Now in the importFlash function:

 3279
##
 3280  # ImportFlash - Upgrade and import FlashObject Forms
 3281  #
 3282
##
 3283  ImportFlash()
 3284  {
 3285  lecho Installing Flash Objects: `date` 
 3286  lecho
 3287  SAMPLE_FORMS=$INSTALL_DIR/samples/en
 3288  $CD $SAMPLE_FORMS
 3289
  3290  if [ ${DB_UPGRADE} -eq 1 -a ${ARS_VER} -lt 21 ]; then
 3291  LoadSchemaWithRIK FlashForms ${IMPORT_MODE}
${UPGRD_USER} ${UPGRD_PASS}
 3292  if [ $? -ne 0 ]; then
 3293  lecho FlashForms  failed to import.
 3294  lecho Problems encountered while importing the
form FlashForms.def
 3295  lecho Please refer to the log in
$INSTALL_DIR/Logs/ for further details.
 3296  else
 3297  note FlashForms successfully installed.
 3298  fi
 3299  fi

From the output, I can tell that the first line of this function ran.

In the ArEnvHistory file, these are the values of the vars used in the if
statement:

DB_UPGRADE=0
ARS_VER=select dbVersion from control

Obviously the if statement can't handle the sql statement.



Below is a 'sloppy' hack to get new installs (only) to complete
successfully.

[EMAIL PROTECTED]:/var/log/remedy/media/ars70p1/ars70p001/arsystem
diff -u ar_install.bak ar_install
--- ar_install.bak  Mon Jul 24 10:41:19 2006
+++ ar_install  Mon Jul 24 21:36:28 2006
@@ -11780,6 +11785,7 @@
 
 # Stage 6 : Set up sample forms and Demo

+ARS_VER=0; export ARS_VER
 STAGE=6
 LogOnly Stage 6: `date`
 if [ $FRESH_INSTALL -eq 1 ]; then

Axton Grams
__20060125___This posting was submitted
with HTML in it___


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9

2006-09-06 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: ARS 7 install issues with Oracle 10gR2 on Solaris 9
**





Axton:


Thank you. I did not have this problem when I did my install. 


James McKenzie
L-3 GSI



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Wednesday, September 06, 2006 1:43 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9


Didn't spend the time to investiage, reported it as a bug and made a quick/dirty fix to get the installer to complete properly. The only thing that fails to import when this happens are the fb forms/workflow.

Axton Grams


On 9/6/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote:
 **


 Axton:

 This is b code here:


 ARS_VER=select dbVersion from control


 This should be a number not a select statement for SQL.

 I'm wondering why it did not work.


 James McKenzie



 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
 Sent: Wednesday, September 06, 2006 1:23 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9


 Also, if the installer exits at this point, then it didn't complete 
 successfully.

 #
 Installing Flash Objects: Mon Jul 24 21:05:36 EDT 2006

 ./ar_install: test: unknown operator dbVersion 
 #


 The installer dies at this point:

 In the stage 6 of the install script:

 12299 # Import required and selected plugins
 12300 ImportPlugins
  12301 ImportFlash

 Now in the importFlash function:

 3279
 ##
 3280 # ImportFlash - Upgrade and import FlashObject Forms
 3281 #
 3282
 ##
 3283 ImportFlash()
 3284 {
 3285 lecho Installing Flash Objects: `date` 
 3286 lecho
 3287 SAMPLE_FORMS=$INSTALL_DIR/samples/en
 3288 $CD $SAMPLE_FORMS
 3289
  3290 if [ ${DB_UPGRADE} -eq 1 -a ${ARS_VER} -lt 21 ]; then
 3291 LoadSchemaWithRIK FlashForms ${IMPORT_MODE}
 ${UPGRD_USER} ${UPGRD_PASS}
 3292 if [ $? -ne 0 ]; then
 3293 lecho FlashForms failed to import.
 3294 lecho Problems encountered while importing the
 form FlashForms.def
 3295 lecho Please refer to the log in
 $INSTALL_DIR/Logs/ for further details.
 3296 else
 3297 note FlashForms successfully installed.
 3298 fi
 3299 fi

 From the output, I can tell that the first line of this function ran.

 In the ArEnvHistory file, these are the values of the vars used in the 
 if
 statement:

 DB_UPGRADE=0
 ARS_VER=select dbVersion from control

 Obviously the if statement can't handle the sql statement.



 Below is a 'sloppy' hack to get new installs (only) to complete 
 successfully.

 [EMAIL PROTECTED]:/var/log/remedy/media/ars70p1/ars70p001/arsystem
 diff -u ar_install.bak ar_install
 --- ar_install.bak Mon Jul 24 10:41:19 2006
 +++ ar_install Mon Jul 24 21:36:28 2006
 @@ -11780,6 +11785,7 @@
 
 # Stage 6 : Set up sample forms and Demo 
 
 +ARS_VER=0; export ARS_VER
 STAGE=6
 LogOnly Stage 6: `date`
 if [ $FRESH_INSTALL -eq 1 ]; then

 Axton Grams
 __20060125___This posting was submitted with HTML 
 in it___


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org




__20060125___This posting was submitted with HTML in it___

SQL syntax

2006-09-06 Thread Koyb P. Liabt

**



Hi,


I am trying to update a field (C535478792) with the values on the screen 
from the field $Secondary email$ and pushed directlyvia SQL into the Help 
Desk case record I am currently in.

Is this syntax correct?

update T418 set C535478792 = $Secondary email$ where C1 = $Case 
ID+$;
__20060125___This posting was submitted with HTML in it___

Re: SQL syntax

2006-09-06 Thread Frank Caruso

**
You did not mention what database you are using but you might want to put either single or double quotes around your $ variables.I'll assume since I see the ; at the end that you are on Oracle. Try:
update T418 set C535478792 = '$Secondary email$' where C1 = '$Case 
ID+$';Keep in mind that your a re pointing at the tables and the table number may not be the same from prod to dev to staging. You might try using the View names instead.
On 9/6/06, Koyb P. Liabt [EMAIL PROTECTED] wrote:
**





Hi,


I am trying to update a field (C535478792) with the values on the screen 
from the field $Secondary email$ and pushed directlyvia SQL into the Help 
Desk case record I am currently in.

Is this syntax correct?

update T418 set C535478792 = $Secondary email$ where C1 = $Case 
ID+$;
__20060125___This posting was submitted with HTML in it___

-- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249
__20060125___This posting was submitted with HTML in it___

Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9


I consistently had this issue.  What os/shell did you use?

Axton Grams

On 9/6/06, McKenzie, James J C-E LCMC HQISEC/L3
[EMAIL PROTECTED] wrote:

**


Axton:

Thank you.  I did not have this problem when I did my install.

James McKenzie
L-3 GSI


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Wednesday, September 06, 2006 1:43 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9




Didn't spend the time to investiage, reported it as a bug and made a
quick/dirty fix to get the installer to complete properly.  The only thing
that fails to import when this happens are the fb forms/workflow.

Axton Grams

On 9/6/06, McKenzie, James J C-E LCMC HQISEC/L3
[EMAIL PROTECTED] wrote:
 **


 Axton:

 This is b code here:


 ARS_VER=select dbVersion from control


 This should be a number not a select statement for SQL.

 I'm wondering why it did not work.


 James McKenzie



 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Axton
 Sent: Wednesday, September 06, 2006 1:23 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9


 Also, if the installer exits at this point, then it didn't complete
 successfully.

 #
 Installing Flash Objects: Mon Jul 24 21:05:36 EDT 2006

 ./ar_install: test: unknown operator dbVersion
 #


 The installer dies at this point:

 In the stage 6 of the install script:

  12299  # Import required and selected plugins
  12300  ImportPlugins
  12301  ImportFlash

 Now in the importFlash function:

  3279

##
  3280  # ImportFlash - Upgrade and import FlashObject Forms
  3281  #
  3282

##
  3283  ImportFlash()
  3284  {
  3285  lecho Installing Flash Objects: `date` 
  3286  lecho
  3287  SAMPLE_FORMS=$INSTALL_DIR/samples/en
  3288  $CD $SAMPLE_FORMS
  3289
   3290  if [ ${DB_UPGRADE} -eq 1 -a ${ARS_VER} -lt 21 ]; then
  3291  LoadSchemaWithRIK FlashForms ${IMPORT_MODE}
 ${UPGRD_USER} ${UPGRD_PASS}
  3292  if [ $? -ne 0 ]; then
  3293  lecho FlashForms  failed to import.
  3294  lecho Problems encountered while importing the
 form FlashForms.def
  3295  lecho Please refer to the log in
 $INSTALL_DIR/Logs/ for further details.
  3296  else
  3297  note FlashForms successfully installed.
  3298  fi
  3299  fi

 From the output, I can tell that the first line of this function ran.

 In the ArEnvHistory file, these are the values of the vars used in the
 if
 statement:

 DB_UPGRADE=0
 ARS_VER=select dbVersion from control

 Obviously the if statement can't handle the sql statement.



 Below is a 'sloppy' hack to get new installs (only) to complete
 successfully.


[EMAIL PROTECTED]:/var/log/remedy/media/ars70p1/ars70p001/arsystem
 diff -u ar_install.bak ar_install
 --- ar_install.bak  Mon Jul 24 10:41:19 2006
 +++ ar_install  Mon Jul 24 21:36:28 2006
 @@ -11780,6 +11785,7 @@
  
  # Stage 6 : Set up sample forms and Demo
 
 +ARS_VER=0; export ARS_VER
  STAGE=6
  LogOnly Stage 6: `date`
  if [ $FRESH_INSTALL -eq 1 ]; then

 Axton Grams
 __20060125___This posting was
submitted with HTML
 in it___


___

UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


__20060125___This posting was submitted
with HTML in it___


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Multiple Groups with different Business Time Tags using same SLA.

2006-09-06 Thread Roger Justice

**

1. create an entry in Business time for each group with their hours and any offset from your server


2. create a filter on the helpdesk form that will populate the time fields on the form with the groups time and offset. be sure the filter fires prior to the SLA being set.


3. this will only work on the initial create if the group is changed the SLA stays attached. If you need this to change additinal WF would be needed.




-Original Message-
From: [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Wed, 6 Sep 2006 4:40 PM
Subject: Multiple Groups with different Business Time Tags using same SLA.





** 

Hello Listers,


Please excuse my SLA newbie questions. Irecently was assignedSLA Module 6.0 Out of the Box and don't know how to overcome some of these obstacles and have an important Demo in the morning.





Problem:


We have multiple groups eachwith different business time tags that want to use the same SLA. Only one business time tag entry is allowed on an SLA. How can I overcome this?





How can I configure an SLA so that groups with different business hours tags can use the same SLA? Do I just create multiple SLA's referencing each business time tag?





Is offset hours the answer?





How do I overcome a a virtual group spanning multiple time zones using the same business time tag of 8am-5pm? 


Ex. I don't want a group member in eastern time to "losethree hours" if a case with SLAin progresis created in Pacific Time and Eastern Team Member has gone home for the day.





Some teams also operate on different business hours within the same time zone and I want them to be able to use the same SLA, but with different business time tags.





Thanks in advance!







Jase Brandon 


Remedy Administration/Development 


Customer Support Systems Group


Desk - (615) - 320-4494


Cell - (334) - 318-5426


[EMAIL PROTECTED]






ARServer 6.3


Help Desk 6.0 


SLA 6.0












DaVita Inc. __20060125___This posting was submitted with HTML in it___ 



Check out AOL.com today. Breaking news, video search, pictures, email and IM. All on demand. Always Free.



__20060125___This posting was submitted with HTML in it___

Re: Created 15,000 tickets

2006-09-06 Thread Kathy Morris

**



Yikes!! This is alarming. Your advice regarding the "tickets 
created after the auto-generated tickets" -- can the new tickets created 
todaybe renumbered directly in the database?
__20060125___This posting was submitted with HTML in it___

Re: Multiple Groups with different Business Time Tags using same SLA.

2006-09-06 Thread Jase Brandon

**



Thanks Roger! ")


Jase 


From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Roger JusticeSent: 
Wednesday, September 06, 2006 4:05 PMTo: 
arslist@ARSLIST.ORGSubject: Re: Multiple Groups with different 
Business Time Tags using same SLA.
** 
1. create an entry in Business time for each group with their hours and any 
offset from your server
2. create a filter on the helpdesk form that will populate the time fields 
on the form with the groups time and offset. be sure the filter fires prior to 
the SLA being set.
3. this will only work on the initial create if the group is changed the 
SLA stays attached. If you need this to change additinal WF would be 
needed.
-Original Message-From: 
[EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Wed, 6 Sep 2006 4:40 
PMSubject: Multiple Groups with different Business Time Tags using same 
SLA.


** 
Hello 
Listers,
Please excuse my SLA newbie 
questions. Irecently was assignedSLA Module 6.0 Out of the Box 
and don't know how to overcome some of these obstacles and have an important 
Demo in the morning.

Problem:
We have multiple groups 
eachwith different business time tags that want to use the same SLA. Only 
one business time tag entry is allowed on an SLA. How can I overcome 
this?

How can I configure an SLA 
so that groups with different business hours tags can use the same SLA? Do I 
just create multiple SLA's referencing each business time 
tag?

Is offset hours the 
answer?

How do I overcome a a virtual group spanning multiple 
time zones using the same business time tag of 8am-5pm? 

Ex. I don't want a group member in eastern time to 
"losethree hours" if a case with SLAin progresis created in 
Pacific Time and Eastern Team Member has gone home for the 
day.

Some teams also operate on 
different business hours within the same time zone and I want them to be able to 
use the same SLA, but with different business time tags.

Thanks in 
advance!


Jase Brandon 

Remedy 
Administration/Development 
Customer Support 
Systems Group
Desk - (615) - 
320-4494
Cell - (334) - 
318-5426
[EMAIL PROTECTED]

ARServer 
6.3
Help Desk 6.0 

SLA 
6.0



DaVita Inc. __20060125___This 
posting was submitted with HTML in it___ 


Check out AOL.com today. Breaking news, video search, 
pictures, email and IM. All on demand. Always 
Free.__20060125___This posting was submitted with 
HTML in it___ 
__20060125___This posting was submitted with HTML in it___

Re: SQL syntax

**



I guess that You need ' for char 
fields

update T418 set C535478792 = '$Secondary 
email$' where C1 = '$Case ID+$'

Are You using this code in workflow? T418 
will be changed on another server, or if the form is deleted and reimported.to 
the same server. Use viewnames instead, or avoid hardcoded T no. /L 
ars

  -Original Message-From: Action Request System 
  discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Koyb 
  P. LiabtSent: Wednesday, September 06, 2006 10:56 PMTo: 
  arslist@ARSLIST.ORGSubject: SQL syntax** 
  
  Hi,
  
  
  I am trying to update a field (C535478792) with the values on the screen 
  from the field $Secondary email$ and pushed directlyvia SQL into the 
  Help Desk case record I am currently in.
  
  Is this syntax correct?
  
  update T418 set C535478792 = $Secondary email$ where C1 = $Case 
  ID+$;__20060125___This posting was submitted 
  with HTML in it___ 
__20060125___This posting was submitted with HTML in it___

Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9

2006-09-06 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: ARS 7 install issues with Oracle 10gR2 on Solaris 9
**





Axton:


BASH, KSH. I've seen issues like this one, but I was doing a fresh install to a precreated tablespace. This may have bypassed this problem.

James McKenzie 


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Wednesday, September 06, 2006 2:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9


I consistently had this issue. What os/shell did you use?


Axton Grams


On 9/6/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote:
 **


 Axton:

 Thank you. I did not have this problem when I did my install.

 James McKenzie
 L-3 GSI


 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
 Sent: Wednesday, September 06, 2006 1:43 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9




 Didn't spend the time to investiage, reported it as a bug and made a 
 quick/dirty fix to get the installer to complete properly. The only 
 thing that fails to import when this happens are the fb forms/workflow.

 Axton Grams

 On 9/6/06, McKenzie, James J C-E LCMC HQISEC/L3 
 [EMAIL PROTECTED] wrote:
  **
 
 
  Axton:
 
  This is b code here:
 
 
  ARS_VER=select dbVersion from control
 
 
  This should be a number not a select statement for SQL.
 
  I'm wondering why it did not work.
 
 
  James McKenzie
 
 
 
  -Original Message-
  From: Action Request System discussion list(ARSList) 
  [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
  Sent: Wednesday, September 06, 2006 1:23 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
 
 
  Also, if the installer exits at this point, then it didn't complete 
  successfully.
 
  #
  Installing Flash Objects: Mon Jul 24 21:05:36 EDT 2006
 
  ./ar_install: test: unknown operator dbVersion 
  #
 
 
  The installer dies at this point:
 
  In the stage 6 of the install script:
 
  12299 # Import required and selected plugins
  12300 ImportPlugins
   12301 ImportFlash
 
  Now in the importFlash function:
 
  3279
 
 ##
  3280 # ImportFlash - Upgrade and import FlashObject Forms
  3281 #
  3282
 
 ##
  3283 ImportFlash()
  3284 {
  3285 lecho Installing Flash Objects: `date` 
  3286 lecho
  3287 SAMPLE_FORMS=$INSTALL_DIR/samples/en
  3288 $CD $SAMPLE_FORMS
  3289
   3290 if [ ${DB_UPGRADE} -eq 1 -a ${ARS_VER} -lt 21 ]; then
  3291 LoadSchemaWithRIK FlashForms ${IMPORT_MODE}
  ${UPGRD_USER} ${UPGRD_PASS}
  3292 if [ $? -ne 0 ]; then
  3293 lecho FlashForms failed to import.
  3294 lecho Problems encountered while importing the
  form FlashForms.def
  3295 lecho Please refer to the log in
  $INSTALL_DIR/Logs/ for further details.
  3296 else
  3297 note FlashForms successfully installed.
  3298 fi
  3299 fi
 
  From the output, I can tell that the first line of this function ran.
 
  In the ArEnvHistory file, these are the values of the vars used in 
  the if
  statement:
 
  DB_UPGRADE=0
  ARS_VER=select dbVersion from control
 
  Obviously the if statement can't handle the sql statement.
 
 
 
  Below is a 'sloppy' hack to get new installs (only) to complete 
  successfully.
 
 
 [EMAIL PROTECTED]:/var/log/remedy/media/ars70p1/ars70p001/arsystem
  diff -u ar_install.bak ar_install
  --- ar_install.bak Mon Jul 24 10:41:19 2006
  +++ ar_install Mon Jul 24 21:36:28 2006
  @@ -11780,6 +11785,7 @@
  
  # Stage 6 : Set up sample forms and Demo 
  
  +ARS_VER=0; export ARS_VER
  STAGE=6
  LogOnly Stage 6: `date`
  if [ $FRESH_INSTALL -eq 1 ]; then
 
  Axton Grams
  __20060125___This posting was
 submitted with HTML
  in it___


 __
 _

 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


 __20060125___This posting was submitted with HTML 
 in it___


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org




__20060125___This posting was submitted with HTML in it___

Re: Increase Performance Remedy 6

2006-09-06 Thread Michiel Beijen

**
And of course also very important questions are:how many concurrent users would be logged in to the system at peak times? How many tickets are there in HPD:Helpdesk and how many tickets would you normally log per day (or week, or month)
And I guess there is no such thing as Helpdesk v6.3. You would probably mean Helpdesk 6 and Remedy 6.3...?--MichielOn 9/6/06, dcharters
 [EMAIL PROTECTED] wrote:
So what is your processor at? Is your RAM and Processor at 100% on theapplication or database server?On Wed, 6 Sep 2006 19:05:46 -, [EMAIL PROTECTED] wrote
 before to find out the other points you asked me well, It's a Unix Server AIX 5.3 Remedy 6 Help desk 6.3 Websphere 5.1 DB2 8.1__
_ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org--Open WebMail Project (http://openwebmail.org)___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125___This posting was submitted with HTML in it___

Re: Created 15,000 tickets

2006-09-06 Thread Nall, Roger

Title: RE: Created 15,000 tickets
**








Kathy,



I am sure this will be just one of many
recommendations to not try to renumber your existing tickets using sql. There
are way too many pitfalls. James suggestion to export out your current
tickets, change your next ID value, and import while creating new IDs is the
best course of action.



Good luck. 





Roger A. Nall

OSSNMS Sr. Remedy Administrator/Developer

T-Mobile USA

Desk: 973-644-3963

Cell: 973-652-6723

FAX: 973-267-6628

sf49fanv AIM IM

RogerNall Yahoo IM













From: Action Request
System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of McKenzie, James J C-E
LCMC HQISEC/L3
Sent: Wednesday, September 06,
2006 5:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Created 15,000
tickets





Kathy:

 
It is possible to do this but I
don't have the knowledge on how to do this in the database, but I have done
this through an export/import. Just set the import tool to gen new id's.



James McKenzie 
 




From:
Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of
Kathy Morris 
Sent: Wednesday, September 06, 2006
2:06 PM 
To: arslist@ARSLIST.ORG

Subject: Re: Created 15,000 tickets




** 
Yikes!! This is
alarming. Your advice regarding the tickets created after the
auto-generated tickets -- can the new tickets created today be
renumbered directly in the database?






__20060125___This posting was submitted with HTML in it___
__20060125___This posting was submitted with HTML in it___

Re: Created 15,000 tickets

2006-09-06 Thread Susan Palmer

**
And by doing the import with new ID's those Consolidated records will get created properly since these will be new creations. Trying to synch everything up is a headache to say the least. BUT, delete the old records before importing. You'll have them in the export (arx) file which I generally make two exports for a situation like this. 


Map out what you want to do, think it over slowly, determine what could go wrong, change the plan if necessary, make copies of everything, then go for it. And make sure that offending workflow is corrected or disabled.


Good luck ... let us know how it turns out

Susan
On 9/6/06, Nall, Roger [EMAIL PROTECTED] wrote:

** 


Kathy,

I am sure this will be just one of many recommendations to not try to renumber your existing tickets using sql. There are way too many pitfalls. James' suggestion to export out your current tickets, change your next ID value, and import while creating new IDs is the best course of action.


Good luck. 



Roger A. Nall
OSSNMS Sr. Remedy Administrator/Developer

T-Mobile USA
Desk: 973-644-3963
Cell: 973-652-6723
FAX: 973-267-6628
sf49fanv AIM IM
RogerNall Yahoo IM






From: Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3
Sent: Wednesday, September 06, 2006 5:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: Created 15,000 tickets




Kathy:  It is possible to do this but I don't have the knowledge on how to do this in the database, but I have done this through an export/import. Just set the import tool to gen new id's.

 James McKenzie 
 
 
From: Action Request System discussion list(ARSList) [
mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris Sent: Wednesday, September 06, 2006 2:06 PM 
To: arslist@ARSLIST.ORG Subject: Re: Created 15,000 tickets
 

** Yikes!! This is alarming. Your advice regarding the tickets created after the auto-generated tickets -- can the new tickets created today be renumbered directly in the database?

__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___

Re: Created 15,000 tickets

2006-09-06 Thread John Sundberg

**
I think the number should be meaningless. In other words - I suggest leaving the system as is. Benefits:freefastget to work on the next higher value projectetc...-John John David Sundberg235 East 6th Street, Suite 400BSt. Paul, MN 55101(651) 556-0930-work(651) 247-6766-cell(651) 695-8577-fax[EMAIL PROTECTED] On Sep 6, 2006, at 2:10 PM, Kathy Morris wrote:**   Hi all,   Because some workflow had the wrong qualification from a previous developer, 15,000 tickets were generated.  We left off at 7,000 and now we are at 22,000.  Isn't there a way thru SQL to reset the value of the HPD to 7,000 so Remedy goes to set the next ID, it will think the last ID is 7,000.  We also want to rename the HPD tickets created today with a 7,000 value within the database.    Our case ID is C1, I can find out the t table, I am just not sure which command I would enter to modify the rows in the database.  And if this will present problems later.  I know the users will be referencing the wrong ticket number.  We definitely do not want to be at 22,000.     __20060125___This posting was submitted with HTML in it___
__20060125___This posting was submitted with HTML in it___

Re: Increase Performance Remedy 6

2006-09-06 Thread Sean Garrison

I know they did some oracle specific settings to make it faster:

Server-Side-Table-Chunk-Size: 1
Next-ID-Commit: T
Oracle-Cursor-Sharing: FORCE
Oracle-Search-On-Clob: T
Oracle-Bulk-Fetch-Count: 100
Clustered-Index: T

I am not sure about DB2   you will have to look at the Configuring AR
System manual.  


Also you need to look at your workflow to make sure everything is running on
an index.  Remedy Developer plus can help with that.  We no longer run help
desk here but if I remember right not everything was indexed properly.  Also
you might want to encourage users to uncheck the Refresh Contents on
Display this helps when refreshing tables when you click from record to
record.  In addition training users to build searches that are indexed helps
a lot.  

Thanks,

Sean 




-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of dcharters
Sent: Wednesday, September 06, 2006 4:15 PM
To: arslist@ARSLIST.ORG
Subject: Re: Increase Performance Remedy 6

So what is your processor at? Is your RAM and Processor at 100% on the 
application or database server?

On Wed, 6 Sep 2006 19:05:46 -, [EMAIL PROTECTED] wrote
 before to find out the other points you asked me
 well, It's a
 
 Unix Server AIX 5.3
 Remedy 6
 Help desk 6.3
 Websphere 5.1
 DB2 8.1
 
 

__
_
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


--
Open WebMail Project (http://openwebmail.org)


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Requirements of Remedy