date:20060731

Kieran,

Can you run the Uninstall for Incident Management?

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare
Sent: Monday, July 31, 2006 6:22 AM
To: arslist@ARSLIST.ORG
Subject: How do I REinstall an ITSM application

After a botched Incident Management 7 install, I now wish to reinstall
it. I I don't have any other ITSM 7 applications installed.

However, when I try to rerun the installer I get a message

'all requirement systems are present. Nothing to install' and it doesn't
go any further.

What do I need to do to allow a reinstall? I didn't find any help on
this in the ITSM 7 installation guide. Am I correct in saying it
involves entries in SHARE:Application Properties and if so what entries?


Thanks,

Kieran O'Hare
Programmer
Information Systems Services
200/201 Pearse St.
Trinity College
Dublin 2
Phone +353 1 8962774


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

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

Re: SERIOUS!!!---Help with Table Refresh

Title: Message
**




Nisha,

As a test, use the EXTERNAL() function in the tables 
qualification. When you need to refresh the data Set the field that is 
used by EXTERNAL to "1 = 2". Then Refresh. Then set the field back 
to your original qualification. Then Refresh. 

If this works *and* the extra 1=2 refresh does not add 
any perceptible time to the overall refreshing of the table then this may be a 
temporary solution while you find a permanent solution.

Stephen


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nisha 
RAMTRISent: Monday, July 31, 2006 6:33 AMTo: 
arslist@ARSLIST.ORGSubject: SERIOUS!!!---Help with Table 
Refresh
** 

Hello 
All,
I have a 
display only form which has a table field on it. This table A (for eg.) has the 
entries coming into it from some backend form.

Now there's 
an active link guide which is pushing multiple entries into this 
backendform and whenI add a "change field" action to refresh this 
display-only table field after the active link guide action, it fails 
torefresh on the web client even though data is already pushed by the 
guide. On native console, refresh is taking place 
properly.

Can anyone 
suggest where I might be going wrong for the same??? Please suggest what should 
be done in order to refresh data in the table on web also. I am blocked due to 
this now!!

Thanks.

Warm 
Regards,

Nisha Ramtri
Remedy Development, ITAC,
ST Microelectronics Ltd.
Plot#1, Knowledge Park-III,
Greater Noida.
Ph# (0120)3916000 Extn:6247
PSTN# (0120)4006247

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

Re: MidTier on Linux

2006-07-31 Thread Derek Berube

**
I've included my comments in your original message below.DerekOn Jul 30, 2006, at 12:59 PM, Jason McDonald wrote:** Thanks.   I went through the installation instructions, but was unsure what other softwares I need to DL and which exact file to DL. When I visited some of the websites which host the additional softwares reqd. , I was overwhelmed by the amount of links there were for a single product. I just need:    I am assuming that i'll be setting up a mid-tier for: 1) ARS 7.0 2) Windows platform 3) I don't have IIS (Is it licensed or free?)IIS is free and included as part of the operating system.  If you're running on Windows XP, I believe it is called "Personal Web Sharing".  On Windows Server 2003, it may be an optional install.  As is the case with Apache, unless you need IIS for something other than Mid-Tier, I would not bother installing it at all.  Anything related to Mid-Tier is going to be handed off to ServletExec or Tomcat (depending on which you install) and that is where the real "work" happens.  In this specific scenario, introducing IIS just adds another unnecessary layer.The only advantage I may see with using IIS on Windows is perhaps for ARS Mid-Tier sites which are very busy.  Since IIS is integrated into the operating system, I would like to assume that it has been very finely tuned to effectively manage a high number of socket connections.  In performance intensive situations, people tend to use either the Apache Portable Runtime with Tomcat or the Grizzly connector to manage socket-based communications.If you decide to use Tomcat with IIS, you're going to need to install the ISAPI filter for Tomcat. 4) Should i DL tomcat or apache or both? And from what exact link should i DL for windows 32 bit version?Unless you need Apache for other features, I would just install Tomcat.  Much of my reasoning behind this can be found in the earlier discussion for using IIS.  Since Tomcat is 100% pure Java, there is no 32/64-bit choice.  Just download Tomcat 5.5.17 and install it. 5) Apart from tomcat or apache or both, what other S/w is needed?You will need to have the Java Development Kit installed.  I would install Sun's Java Standard Edition 5.0 Release 7 Development Kit (a.k.a., J2SE 1.5 release 7).  There are other options from other vendors, but this is the one I generally use.  I'd be curious to know how many on the list are using JRockit or the IBM JVM.  It's been a while since I've looked at benchmarks. 6) In what order should i install these products?JDK IIS or Apache (optional)TomcatMid-TierIf you are going to use Tomcat alone, then when prompted to choose a web server, select the "Other" option.  Do the same for the question about the Servlet Engine.  I don't normally do this in LINUX/UNIX (I use symbolic links instead), but when you install Mid-Tier, install it to the Tomcat_Installation/webapps/arsys folder.  For example, if you install Tomcat to C:\Program Files\Apache Tomcat, then install Mid-Tier to C:\Program Files\Apache Tomcat\webapps\arsys.Good luck with your install!   This is the first time i'm installing mid-tier, so pls help me out.   Jason  On 7/30/06, Michiel Beijen [EMAIL PROTECTED] wrote:  ** Jason,You could just follow the installation instructions in the pdfs, if you want to install it with IIS on Windows. If you would like to use tomcat, the approach does not differ greatly from the earlier described linux install. (set up tomcat, download warfile, etc.)--Michiel On 7/30/06, Jason McDonald [EMAIL PROTECTED]   wrote:  **   Hi,   Just wondering if there is a step-by-step tutorial out there describing how to install mid-tier on Windows. I have no clue what other software is required (I see some of you mentioning Tomcat / Apache)...If anyone knows of such a text, pls let me know.    Thanks.Jason   On 7/28/06, Watson Benjamin A Contr AFWA/XOO  [EMAIL PROTECTED] wrote:  **  I read through John Baker's MidTier on Linux install guide and got it working finally (really nice How-To by the way).   Basically, I did the same thing Mike mentioned before (using Tomcat manager to import the MidTier WAR file).   This made things work for me locally (e.g. localhost:8080/arsys/home)   However, at present, I can't access the MidTier externally (from another pc) by visiting server ip:8080/arsys/home.   I've found out that I need to do 1 of 2 things.   1.) compile the mod_jk Tomcat connector for Apache (and configure Apache and Tomcat to use it) to allow Apache to receive the external requests and forward it to Tomcat.    2.) use the JSVC daemon that Derek mentioned.  I've already compiled the JSVC, just a matter of configuration.   Unfortunately, I haven't had much time to dedicate to this project as it is merely a test to see which configuration performs better.    Perhaps I'll test both options (1 and 2) above to see how they both behave.     Thanks for your valued feedback.  //SIGNED//BENJAMIN A WATSON, Contractor, AFWA/XOOSAIC - Remedy TeamCommercial: (402) 294-8225DSN:

Re: MidTier on Linux

2006-07-31 Thread Steve

**
Super!! Thanks Derek and all!
On 7/31/06, Derek Berube [EMAIL PROTECTED] wrote:

**
I've included my comments in your original message below.

Derek

On Jul 30, 2006, at 12:59 PM, Jason McDonald wrote:
**
Thanks.

I went through the installation instructions, but was unsure what other softwares I need to DL and which exact file to DL. When I visited some of the websites which host the additional softwares reqd. , I was overwhelmed by the amount of links there were for a single product. I just need:

I am assuming that i'll be setting up a mid-tier for:
1) ARS 7.0
2) Windows platform
3) I don't have IIS (Is it licensed or free?)

IIS is free and included as part of the operating system. If you're running on Windows XP, I believe it is called Personal Web Sharing. On Windows Server 2003, it may be an optional install. As is the case with Apache, unless you need IIS for something other than Mid-Tier, I would not bother installing it at all. Anything related to Mid-Tier is going to be handed off to ServletExec or Tomcat (depending on which you install) and that is where the real work happens. In this specific scenario, introducing IIS just adds another unnecessary layer.

The only advantage I may see with using IIS on Windows is perhaps for ARS Mid-Tier sites which are very busy. Since IIS is integrated into the operating system, I would like to assume that it has been very finely tuned to effectively manage a high number of socket connections. In performance intensive situations, people tend to use either the Apache Portable Runtime with Tomcat or the Grizzly connector to manage socket-based communications.

If you decide to use Tomcat with IIS, you're going to need to install the ISAPI filter for Tomcat.

4) Should i DL tomcat or apache or both? And from what exact link should i DL for windows 32 bit version?

Unless you need Apache for other features, I would just install Tomcat. Much of my reasoning behind this can be found in the earlier discussion for using IIS. Since Tomcat is 100% pure Java, there is no 32/64-bit choice. Just download Tomcat
5.5.17 and install it.

5) Apart from tomcat or apache or both, what other S/w is needed?

You will need to have the Java Development Kit installed. I would install Sun's Java Standard Edition 5.0 Release 7 Development Kit (a.k.a., J2SE 1.5 release 7). There are other options from other vendors, but this is the one I generally use. I'd be curious to know how many on the list are using JRockit or the IBM JVM. It's been a while since I've looked at benchmarks.

6) In what order should i install these products?

JDK
IIS or Apache (optional)
Tomcat
Mid-Tier

If you are going to use Tomcat alone, then when prompted to choose a web server, select the Other option. Do the same for the question about the Servlet Engine. I don't normally do this in LINUX/UNIX (I use symbolic links instead), but when you install Mid-Tier, install it to the Tomcat_Installation/webapps/arsys folder. For example, if you install Tomcat to
C:\Program Files\Apache Tomcat, then install Mid-Tier to C:\Program Files\Apache Tomcat\webapps\arsys
.

Good luck with your install!

This is the first time i'm installing mid-tier, so pls help me out.

Jason
On 7/30/06, Michiel Beijen [EMAIL PROTECTED]
wrote:

** Jason,You could just follow the installation instructions in the pdfs, if you want to install it with IIS on Windows. If you would like to use tomcat, the approach does not differ greatly from the earlier described linux install.
(set up tomcat, download warfile, etc.)--Michiel
On 7/30/06, Jason McDonald [EMAIL PROTECTED]
wrote:

Hi,

Just wondering if there is a step-by-step tutorial out theredescribing how to install mid-tier on Windows. I have no clue what other software is required (I see some of you mentioning Tomcat / Apache)...If anyone knows of such a text, pls let me know.

Thanks.

Jason

On 7/28/06, Watson Benjamin A Contr AFWA/XOO
[EMAIL PROTECTED] wrote:

I read through John Baker's MidTier on Linux install guide and got it working finally (really nice How-To by the way).

Basically, I did the same thing Mike mentioned before (using Tomcat manager to import the MidTier WAR file).

This made things work for me locally (e.g. localhost:8080/arsys/home)

However, at present, I can't access the MidTier externally (from another pc) by visiting server ip:8080/arsys/home.

I've found out that I need to do 1 of 2 things.

1.) compile the mod_jk Tomcat connector for Apache(and configure Apache and Tomcat to use it) to allow Apache to receive the external requests and forward it to Tomcat.

2.) use the JSVC daemon that Derek mentioned. I've already compiled the JSVC, just a matter of configuration.

Unfortunately, I haven't had much time to dedicate to this project as it is merely a test to see which configuration performs better.

Perhaps I'll test both options (1 and 2) above to see how they both behave.

Thanks for your valued feedback.

Re: How do I REinstall an ITSM application

2006-07-31 Thread Kieran O'Hare

Thanks Stephen, but where do I find the Uninstall?

Kieran

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: 31 July 2006 13:15
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Kieran,

Can you run the Uninstall for Incident Management?

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare
Sent: Monday, July 31, 2006 6:22 AM
To: arslist@ARSLIST.ORG
Subject: How do I REinstall an ITSM application

After a botched Incident Management 7 install, I now wish to reinstall
it. I I don't have any other ITSM 7 applications installed.

However, when I try to rerun the installer I get a message

'all requirement systems are present. Nothing to install' and it doesn't
go any further.

What do I need to do to allow a reinstall? I didn't find any help on
this in the ITSM 7 installation guide. Am I correct in saying it
involves entries in SHARE:Application Properties and if so what entries?

Thanks,

Kieran O'Hare
Programmer
Information Systems Services
200/201 Pearse St.
Trinity College
Dublin 2
Phone +353 1 8962774

___
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: How do I REinstall an ITSM application

Add or Remove Programs in the Windows Control Panel.

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare
Sent: Monday, July 31, 2006 8:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Thanks Stephen, but where do I find the Uninstall?

Kieran

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: 31 July 2006 13:15
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Kieran,

Can you run the Uninstall for Incident Management?

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare
Sent: Monday, July 31, 2006 6:22 AM
To: arslist@ARSLIST.ORG
Subject: How do I REinstall an ITSM application

After a botched Incident Management 7 install, I now wish to reinstall
it. I I don't have any other ITSM 7 applications installed.

However, when I try to rerun the installer I get a message

'all requirement systems are present. Nothing to install' and it doesn't
go any further.

What do I need to do to allow a reinstall? I didn't find any help on
this in the ITSM 7 installation guide. Am I correct in saying it
involves entries in SHARE:Application Properties and if so what entries?

Thanks,

Kieran O'Hare
Programmer
Information Systems Services
200/201 Pearse St.
Trinity College
Dublin 2
Phone +353 1 8962774

___
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: How do I REinstall an ITSM application

2006-07-31 Thread Kieran O'Hare

Stephen,
I don't have an entry for Incident Mgmnt in Add/Remove Programs - but do
have for AR System Server, Approval, Assignment,  Email Engine. 

Thanks

Kieran

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: 31 July 2006 13:37
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Add or Remove Programs in the Windows Control Panel.

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare
Sent: Monday, July 31, 2006 8:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Thanks Stephen, but where do I find the Uninstall?

Kieran

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: 31 July 2006 13:15
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Kieran,

Can you run the Uninstall for Incident Management?

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare
Sent: Monday, July 31, 2006 6:22 AM
To: arslist@ARSLIST.ORG
Subject: How do I REinstall an ITSM application

After a botched Incident Management 7 install, I now wish to reinstall
it. I I don't have any other ITSM 7 applications installed.

However, when I try to rerun the installer I get a message

'all requirement systems are present. Nothing to install' and it doesn't
go any further.

What do I need to do to allow a reinstall? I didn't find any help on
this in the ITSM 7 installation guide. Am I correct in saying it
involves entries in SHARE:Application Properties and if so what entries?


Thanks,

Kieran O'Hare
Programmer
Information Systems Services
200/201 Pearse St.
Trinity College
Dublin 2
Phone +353 1 8962774


___
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: How do I REinstall an ITSM application

Something to try:

Copy the C:\Program Files\AR System Applications\your server name\BMC
Remedy Incident Management folder to another drive.  If you do not have
access to another drive then copy to a folder outside of C:\Program
Files.  Then delete the C:\Program Files\AR System Applications\your
server name\BMC Remedy Incident Management folder.

You want to keep a copy of the folder in case deleting it causes any
problems.

Run the install again.  If it works then delete the backup copy of the
folder you created above.

Stephen



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare
Sent: Monday, July 31, 2006 8:49 AM
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Stephen,
I don't have an entry for Incident Mgmnt in Add/Remove Programs - but do
have for AR System Server, Approval, Assignment,  Email Engine. 

Thanks

Kieran

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: 31 July 2006 13:37
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Add or Remove Programs in the Windows Control Panel.

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare
Sent: Monday, July 31, 2006 8:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Thanks Stephen, but where do I find the Uninstall?

Kieran

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: 31 July 2006 13:15
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Kieran,

Can you run the Uninstall for Incident Management?

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare
Sent: Monday, July 31, 2006 6:22 AM
To: arslist@ARSLIST.ORG
Subject: How do I REinstall an ITSM application

After a botched Incident Management 7 install, I now wish to reinstall
it. I I don't have any other ITSM 7 applications installed.

However, when I try to rerun the installer I get a message

'all requirement systems are present. Nothing to install' and it doesn't
go any further.

What do I need to do to allow a reinstall? I didn't find any help on
this in the ITSM 7 installation guide. Am I correct in saying it
involves entries in SHARE:Application Properties and if so what entries?


Thanks,

Kieran O'Hare
Programmer
Information Systems Services
200/201 Pearse St.
Trinity College
Dublin 2
Phone +353 1 8962774


___
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

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

Re: MidTier on Linux

Thanks Derek and Michiel. That was really helpful.
Was able to successfully install mid-tier on WinXp.
Apache Tomcat5.5.17Java Software Development Kit (SDK)jdk1.5.0_07Java Runtime Environment (comes along with SDK)jre1.5.0_07One observation: For apache tomcat, I had to edit the /conf/server.xml file to point to a different port(9090) than the default 8080 as 8080 was already being listened to by oracle.

Still Stuck! - When I navigate to http://localhost:9090/arsys/home and enter Demo/blank as the password, I get a invalid user error..I have already configured mid-tier. Any pointers on this?
Jason

On 7/31/06, Derek Berube [EMAIL PROTECTED]
wrote:

**
I've included my comments in your original message below.

Derek

On Jul 30, 2006, at 12:59 PM, Jason McDonald wrote:
**
Thanks.

I am assuming that i'll be setting up a mid-tier for:
1) ARS 7.0
2) Windows platform
3) I don't have IIS (Is it licensed or free?)

If you decide to use Tomcat with IIS, you're going to need to install the ISAPI filter for Tomcat.

4) Should i DL tomcat or apache or both? And from what exact link should i DL for windows 32 bit version?

5) Apart from tomcat or apache or both, what other S/w is needed?

6) In what order should i install these products?

JDK
IIS or Apache (optional)
Tomcat
Mid-Tier

Good luck with your install!

This is the first time i'm installing mid-tier, so pls help me out.

Jason
On 7/30/06, Michiel Beijen [EMAIL PROTECTED]
wrote:

Hi,

Thanks.

Jason

On 7/28/06, Watson Benjamin A Contr AFWA/XOO
[EMAIL PROTECTED] wrote:

I read through John Baker's MidTier on Linux install guide and got it working finally (really nice How-To by the way).

Basically, I did the same thing Mike mentioned before (using Tomcat manager to import the MidTier WAR file).

This made things work for me locally (e.g. localhost:8080/arsys/home)

However, at present, I can't access the MidTier externally (from another pc) by visiting server ip:8080/arsys/home.

Re: Remedy and BLOB data

**
I am actually trying to bypass remedy and directly get the blob content of a field.

I thought this was possible via special tools but since remedy is compressing them, they are of no use. I will give the c program a shot.

Do you have any other alternative solutions?

Thanks..
On 7/31/06, Michiel Beijen [EMAIL PROTECTED] wrote:
Jason,You should check out the ARGetEntryBLOB call, and check sample scriptsprovided with the API.
Also refer to the documentation for the API, there are two PDF's aboutthis included in the v7 documentation.But it would not be the easiest thing to do if you do not have C experience.What exactly are you trying to accomplish? You might also want to look
in to exporting records using runmacro.--MichielOn 7/30/06, Jason McDonald [EMAIL PROTECTED] wrote: ** -
OK thanks. I downloaded the http://arswiki.org/dist/ars/api/api_win_en_700_000.zip from the web. Now, how do I write a C program to display a BLOB file (PDF) from the table
B52CX in the aradmin schema? Also, I would like the program to automatically know the MIME type (its stored in B52 table)...so the C program must query the B52 table and find out the MIME type and then open it
in a suitable program. Any pointers? Thanks. On 7/31/06, Jason McDonald [EMAIL PROTECTED] wrote:
OK thanks. I downloaded the http://arswiki.org/dist/ars/api/api_win_en_700_000.zip from the web.
Now, how do I write a C program to display a BLOB file (PDF) from the table B52CX in the aradmin schema? Also, I would like the program to automatically know the MIME type (its stored in B52 table)...so the C
program must query the B52 table and find out the MIME type and then open it in a suitable program. Any pointers? Thanks. On 7/30/06, Michiel Beijen
[EMAIL PROTECTED] wrote: you could use it from a C program, or from java, or other langages. See
http://arswiki.org/wiki/index.php?title=API_Programming -- Michiel On 7/30/06, Jason McDonald [EMAIL PROTECTED] wrote: **
Could you please explain how to use the API? Thanks On 7/30/06, Michiel Beijen
[EMAIL PROTECTED] wrote: they are not exactly encrypted, but they ARE compressed. That's why you could not just extract the binary data and open the file. But
that's also the reason that a 30MB word doc only occupies a fraction of that once stored in the database... If you'd extract the attachment using the API it would uncompress the
file nicely. -- Michiel On 7/30/06, Jason McDonald [EMAIL PROTECTED] wrote:
**Hi All, I wanted to know how Remedy ( 7.0) stores LOB data. I was trying to extractdirectly from the database a BLOB field (attachment in remedy ; in
this caseit was a PDF file) but although I knew the MIME type and opened it in aspecial tool designed to extract BLOB data, Acrobat Reader refused to
openit (it said invalid file). Further, following the same process as above, even if I open a 'text file'attachment, the contents seem to be encrypted and I see junk data when
opening it in Notepad. Are attachments encrypted by Remedy before storing it in the database? Ifso, how do I bypass remedy and view BLOB data?
(Dev Env)ARS 7.0Oracle 10gOS - Windows Thanks,Jason __20060125___This posting
wassubmitted 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___
___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125___This posting was submitted with HTML in it___

MidTier on Linux / Windows

2006-07-31 Thread Bezhenar, Dmitry

**



Thank you, Derek!

Could you also share with us some tomcat performance best 
practices? If you know any.

Thanks, again.


Kind Regards/ CDmitry 
Bezhenar



From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek 
BerubeSent: Monday, July 31, 2006 4:22 PMTo: 
arslist@ARSLIST.ORGSubject: Re: MidTier on Linux
** I've included my comments in your original message below. 

Derek 


On Jul 30, 2006, at 12:59 PM, Jason McDonald wrote:
** 
  Thanks.
  
  I went through the installation instructions, but was unsure what other 
  softwares I need to DL and which exact file to DL. When I visited some of the 
  websites which host the additional softwares reqd. , I was overwhelmed by the 
  amount of links there were for a single product. I just need: 
  
  I am assuming that i'll be setting up a mid-tier for:
  1) ARS 7.0
  2) Windows platform
  3) I don't have IIS (Is it licensed or free?)
IIS is free and included as part of 
the operating system. If you're running on Windows XP, I believe it is 
called "Personal Web Sharing". On Windows Server 2003, it may be an 
optional install. As is the case with Apache, unless you need IIS for 
something other than Mid-Tier, I would not bother installing it at all. 
Anything related to Mid-Tier is going to be handed off to ServletExec or Tomcat 
(depending on which you install) and that is where the real "work" 
happens. In this specific scenario, introducing IIS just adds another 
unnecessary layer.

The only advantage I may see with using IIS on Windows is perhaps for ARS 
Mid-Tier sites which are very busy. Since IIS is integrated into the 
operating system, I would like to assume that it has been very finely tuned to 
effectively manage a high number of socket connections. In performance 
intensive situations, people tend to use either the Apache Portable Runtime with 
Tomcat or the Grizzly connector to manage socket-based communications.

If you decide to use Tomcat with IIS, you're going to need to install the 
ISAPI filter for Tomcat.


  4) Should i DL tomcat or apache or both? And from what exact link should 
  i DL for windows 32 bit version?
Unless you need Apache for other features, I would just install 
Tomcat. Much of my reasoning behind this can be found in the earlier 
discussion for using IIS. Since Tomcat is 100% pure Java, there is no 
32/64-bit choice. Just download Tomcat 5.5.17 and install it.

  5) Apart from tomcat or apache or both, what other S/w is 
needed?
You will need to have the Java Development Kit installed. I would 
install Sun's Java Standard Edition 5.0 Release 7 Development Kit (a.k.a., J2SE 
1.5 release 7). There are other options from other vendors, but this is 
the one I generally use. I'd be curious to know how many on the list are 
using JRockit or the IBM JVM. It's been a while since I've looked at 
benchmarks.

  6) In what order should i install these products?
JDK
IIS or Apache (optional)
Tomcat
Mid-Tier

If you are going to use Tomcat alone, then 
when prompted to choose a web server, select the "Other" option. Do the 
same for the question about the Servlet Engine. I don't normally do this 
in LINUX/UNIX (I use symbolic links instead), but when you install Mid-Tier, 
install it to the Tomcat_Installation/webapps/arsys folder. For 
example, if you install Tomcat to C:\Program Files\Apache Tomcat, then 
install Mid-Tier to C:\Program Files\Apache 
Tomcat\webapps\arsys.

Good luck with your install!
__20060125___This posting was submitted with HTML in it___

Remedy Import - Limits to 15 records

**
Hi List,

Once again I seek your advice.

This pertains to Remedy 6.0.3.

I am really getting irritated when trying to import data via the Remedy Import Tool. Irrespective of what form it is and how much data I have in the CSV file, Import always breaks at 15th record with the message - [Record 16 of XX] : Unable to import. Found 30 columns, expected 32


Note that it always says that it foundX-2 columns when there are actually X columns in the CSV file.

In order to import all the records, I have to keep on deleting the first 15 records from the csv file so that the import can process another 15 records. 

Can anyone help on this?
Thanks.
__20060125___This posting was submitted with HTML in it___

Re: Remedy and BLOB data

**





My $0.02. 

I think it would be great if BMC used the ubiquitous 
zip format to compress attachments. This would provide a couple 
advantages:

1. Directly accessible to third-party products, such as 
WinZip, 7-Zip, etc., and also zip format libraries for development in other 
programming languageswithout the ARS API.

2. Administrator or Developercould set the 
desired compression level (Maximum, Normal, Fast, Super Fast, None). This would 
allow the balancing of performance vs compression ratio. Ideally, this 
setting would apply to individual forms instead of global.Certain forms 
you may want to have maximum compression, and other forms fast compression. Even 
better, allow the setting of the compression ratio by field.

Stephen


From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason 
McDonaldSent: Monday, July 31, 2006 9:04 AMTo: 
arslist@ARSLIST.ORGSubject: Re: Remedy and BLOB 
data
** 
I am actually trying to bypass remedy and directly get the blob content of 
a field.

I thought this was possible via special tools but since remedy is 
compressing them, they are of no use. I will give the c program a shot.

Do you have any other alternative solutions?

Thanks..
On 7/31/06, Michiel 
Beijen [EMAIL PROTECTED] 
wrote: 
Jason,You 
  should check out the ARGetEntryBLOB call, and check sample scriptsprovided 
  with the API. Also refer to the documentation for the API, there are two 
  PDF's aboutthis included in the v7 documentation.But it would not be 
  the easiest thing to do if you do not have C experience.What exactly 
  are you trying to accomplish? You might also want to look in to exporting 
  records using runmacro.--MichielOn 7/30/06, Jason McDonald 
  [EMAIL PROTECTED] 
  wrote: ** 
  -  
  OK thanks. I downloaded the http://arswiki.org/dist/ars/api/api_win_en_700_000.zip 
  from the web. Now, how do I write a C program to 
  display a BLOB file (PDF) from the table  B52CX in the aradmin 
  schema? Also, I would like the program to automatically know the MIME 
  type (its stored in B52 table)...so the C program must query the B52 
  table and find out the MIME type and then open it  in a suitable 
  program. Any pointers? Thanks. 
  On 7/31/06, Jason McDonald [EMAIL PROTECTED] wrote: 
 OK thanks.   I 
  downloaded the http://arswiki.org/dist/ars/api/api_win_en_700_000.zip 
  from the web.Now, how do I write a C 
  program to display a BLOB file (PDF) from the table B52CX in 
  the aradmin schema? Also, I would like the program to automatically 
  know the MIME type (its stored in B52 table)...so the C  program must 
  query the B52 table and find out the MIME type and then open it in a 
  suitable program. Any pointers? 
  Thanks. On 7/30/06, Michiel Beijen  [EMAIL PROTECTED]  
  wrote:  you could use it from a C program, or from java, or other 
  langages.  See http://arswiki.org/wiki/index.php?title=API_Programming 
   -- Michiel   On 7/30/06, Jason McDonald [EMAIL PROTECTED]  wrote: 
**Could you please explain how to use the 
  API? Thanks
 On 7/30/06, Michiel Beijen  [EMAIL PROTECTED] 
  wrote:  they are not exactly 
  encrypted, but they ARE compressed. That's why   you could not 
  just extract the binary data and open the file. Butthat's 
  also the reason that a 30MB word doc only occupies a fraction  
   of that once stored in the database...   If you'd extract 
  the attachment using the API it would uncompress thefile 
  nicely.   --   Michiel  
 On 7/30/06, Jason McDonald  [EMAIL PROTECTED] wrote: 
 **Hi All,   
  I wanted to know how Remedy ( 7.0) stores LOB 
  data. I was trying to extractdirectly from the 
  database a BLOB field (attachment in remedy ; in  this  
   caseit was a PDF file) but although I knew the 
  MIME type and opened it in aspecial tool 
  designed to extract BLOB data, Acrobat Reader refused to  open 
 it (it said invalid file). 
Further, following the same process as above, even if I open a 
  'text file'attachment, the contents seem to be 
  encrypted and I see junk data when opening it in 
  Notepad.   Are attachments 
  encrypted by Remedy before storing it in the database? If  
so, how do I bypass remedy and view BLOB data?
  (Dev Env)ARS 7.0 
 Oracle 10gOS - Windows  
   Thanks,Jason 
  __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: Remedy Import - Limits to 15 records

2006-07-31 Thread Mike White

It's caused by variable-length records.  Remedy Import doesn't tolerate
them too well.  When we import from .csv, we make sure the last column is
fully populated - moving columns if necessary.  This will fix/set your
record length.

Mike White
Office:  813-978-2192
E-mail:  [EMAIL PROTECTED]



   
  Jason McDonald  
   
  [EMAIL PROTECTED]To:   arslist@ARSLIST.ORG   

  COM cc:  
   
  Sent by: Action Subject:  Remedy Import - Limits 
to 15 records  
  Request System
   
  discussion
   
  list(ARSList)
   
  [EMAIL PROTECTED]

  ORG  
   

   

   
  07/31/2006 09:15  
   
  Please respond to 
   
  arslist   
   

   

   




**
Hi List,

Once again I seek your advice.

This pertains to Remedy 6.0.3.

I am really getting irritated when trying to import data via the Remedy
Import Tool. Irrespective of what form it is and how much data I have in
the CSV file, Import always breaks at 15th record with the message -
[Record 16 of XX] : Unable to import. Found 30 columns, expected 32

Note that it always says that it found X-2 columns when there are actually
X columns in the CSV file.

In order to import all the records, I have to keep on deleting the first 15
records from the csv file so that the import can process another 15
records.

Can anyone help on this?
Thanks.
__20060125___This posting was submitted with HTML in
it___

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

Re: Remedy Import - Limits to 15 records

**
Its weird that remedy import can't handle the last few empty columnsEscpecially when usually the columns appearing in the last are temporary columns in remedy forms (as the field names start with z..) Anyways, guess i'll have to cut and paste some column in which there is data for all the records.


Thanks.
On 7/31/06, Mike White [EMAIL PROTECTED] wrote:
It's caused by variable-length records.Remedy Import doesn't toleratethem too well.When we import from .csv, we make sure the last column is
fully populated - moving columns if necessary.This will fix/set yourrecord length.Mike WhiteOffice:813-978-2192E-mail:[EMAIL PROTECTED]
 Jason McDonald [EMAIL PROTECTED]To: arslist@ARSLIST.ORG COM cc:
 Sent by: Action Subject:Remedy Import - Limits to 15 records Request System discussion list(ARSList)
 [EMAIL PROTECTED] ORG 07/31/2006 09:15 Please respond to arslist
**Hi List,Once again I seek your advice.This pertains to Remedy 6.0.3.I am really getting irritated when trying to import data via the RemedyImport Tool. Irrespective of what form it is and how much data I have in
the CSV file, Import always breaks at 15th record with the message -[Record 16 of XX] : Unable to import. Found 30 columns, expected 32Note that it always says that it found X-2 columns when there are actually
X columns in the CSV file.In order to import all the records, I have to keep on deleting the first 15records from the csv file so that the import can process another 15records.Can anyone help on this?
Thanks.__20060125___This posting was submitted with HTML init__UNSUBSCRIBE or access ARSlist Archives at 
http://www.wwrug.org
__20060125___This posting was submitted with HTML in it___

Re: Remedy Import - Limits to 15 records

**
But in that case how does it work for the first 15 records?
On 7/31/06, Mike White [EMAIL PROTECTED] wrote:
It's caused by variable-length records.Remedy Import doesn't toleratethem too well.When we import from .csv, we make sure the last column is
fully populated - moving columns if necessary.This will fix/set yourrecord length.Mike WhiteOffice:813-978-2192E-mail:[EMAIL PROTECTED]
 Jason McDonald [EMAIL PROTECTED]To: arslist@ARSLIST.ORG COM cc:
 Sent by: Action Subject:Remedy Import - Limits to 15 records Request System discussion list(ARSList)
 [EMAIL PROTECTED] ORG 07/31/2006 09:15 Please respond to arslist
**Hi List,Once again I seek your advice.This pertains to Remedy 6.0.3.I am really getting irritated when trying to import data via the RemedyImport Tool. Irrespective of what form it is and how much data I have in
the CSV file, Import always breaks at 15th record with the message -[Record 16 of XX] : Unable to import. Found 30 columns, expected 32Note that it always says that it found X-2 columns when there are actually
X columns in the CSV file.In order to import all the records, I have to keep on deleting the first 15records from the csv file so that the import can process another 15records.Can anyone help on this?
Thanks.__20060125___This posting was submitted with HTML init__UNSUBSCRIBE or access ARSlist Archives at 
http://www.wwrug.org
__20060125___This posting was submitted with HTML in it___

Re: CMDB 1.1 Patch 2 or 3

2006-07-31 Thread Lucero, Michelle - IST contractor

Thank you for your responses.  This really helps.  I will pass on and
discuss with my team.

Michelle 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen
Sent: Sunday, July 30, 2006 3:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: CMDB 1.1 Patch 2 or 3

I've recently applied patch 2 and 3 to a cmdb 1.1 install, and they
took a LONG time to complete on very reasonable hardware (HP-UX), both
2-3 hours. The fresh installation took about 1 hour, so the patch is
more intensive than the whole install.

I guess the installation issues they have solved in v3 might apply to
the full installer, and not to the patch.

--
Michiel

On 7/29/06, Murtuza Bookwala [EMAIL PROTECTED] wrote:
 Hi Michelle,

 Although I haven't installed patch 3, I might do it soon. But I didn't
know
 you has to have patch 2 installed before it. One issue which Patch 3
was
 going to fix for us (we have a bug logged with BMC) was the square
bracket
 Instance ID issue. Occasionally when CMDB generates an instance ID for
a new
 class or attribute, it adds a [ or ] to the string. This causes all
searches
 on the class to fail. We have had this happen atleast a dozen times
and this
 was a crucial fix for us.

 Regards,
 Murtuza.

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Lucero, Michelle - IST
contractor
 Sent: Friday, July 28, 2006 8:07 PM
 To: arslist@ARSLIST.ORG
 Subject: CMDB 1.1 Patch 2 or 3

 Hi, Friends:

 Has anyone installed Patch 3 for CMDB 1.1?  According to the release
notes,
 patch 3 is suppose to fix various issues including installation issues
with
 patch 2.  However, patch 2 is required before applying patch 3.  Patch
3 is
 not a standalone patch.

 We are considering applying patch 2 for issues as well as adding the
Menu
 Name and Menu Style fields to the Characteristics tab of the Attribute
 Definition (in the CMDB Class Manager).  We want to know if we should
just
 leave it at patch 2 or if it will be necessary to correct potential
issues,
 by applying patch 3 immediately following.

 If you have installed patch 2 and 3, how many minutes, hours, or days
did it
 take for the actual install?

 Thanks,
 Michelle

 ARS 6.3, patch 11
 ITSM 6.0, CMDB 1.1.0 no patch
 Windows 2003, SQL Server 2000

 Mid-Tier 6.3, patch 13, 17
 Windows 2003, IIS 6.0, Servlet Exec 5.0 Patch 6 ESM Mission: To
provide the
 most accurate, timely, and actionable information to our customers so
that
 they can effectively support the Mary Kay IST environment.

 ___
 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: Remedy Import - Limits to 15 records

2006-07-31 Thread Carey Matthew Black


Jason,

If the columns are empty data values in the file. Then do not map
them in the import tool. (It might help.) However, apparently, some
rows have data, or null data, defined for them.

I have seen such behaviour when the csv file is edited with Excel.

Another possible point of confusion is how hard returns are dealt
with in csv format. Some editors write them as hard returns and thus
break up the single line format of csv.


Keep in mind that filters that fire on merge can look at data supplied
to display only fields too. (A good, old school, way to do some
signaling for data merge work IMHO.)


Then again... this could be as simple as a bad client install, or a bug too.

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

Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.
Never ascribe to malice, that which can be explained by incompetence.


On 7/31/06, Jason McDonald [EMAIL PROTECTED] wrote:

** But in that case how does it work for the first 15 records?


On 7/31/06, Mike White [EMAIL PROTECTED] wrote:
 It's caused by variable-length records.  Remedy Import doesn't tolerate
 them too well.  When we import from .csv, we make sure the last column is
 fully populated - moving columns if necessary.  This will fix/set your
 record length.

 Mike White
 Office:  813-978-2192
 E-mail:  [EMAIL PROTECTED]



  Jason McDonald
  [EMAIL PROTECTED]To:
arslist@ARSLIST.ORG
  COM cc:
  Sent by: Action Subject:  Remedy Import -
Limits to 15 records
  Request System
  discussion
  list(ARSList)
  [EMAIL PROTECTED]
  ORG


  07/31/2006 09:15
  Please respond to
  arslist






 **
 Hi List,

 Once again I seek your advice.

 This pertains to Remedy 6.0.3.

 I am really getting irritated when trying to import data via the Remedy
 Import Tool. Irrespective of what form it is and how much data I have in
 the CSV file, Import always breaks at 15th record with the message -
 [Record 16 of XX] : Unable to import. Found 30 columns, expected 32

 Note that it always says that it found X-2 columns when there are actually
 X columns in the CSV file.

 In order to import all the records, I have to keep on deleting the first
15
 records from the csv file so that the import can process another 15
 records.

 Can anyone help on this?
 Thanks.
 __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: Remedy Import - Limits to 15 records

2006-07-31 Thread Mike White

Length probably changed after the 15th record (column populated for rows
1-14, but not for 15th, or vice-versa).  I haven't seen your data, but this
is where I'd look first.

Matt makes good points about data condition.  Hard returns result in two
(or more) records where you intended one.  Field mapping would misalign.

Imbedded commas in text could be problematic, too.  (.csv files are
comma-separated).

Mike White
Office:  813-978-2192
E-mail:  [EMAIL PROTECTED]



   
  Carey Matthew
   
  Black   To:   arslist@ARSLIST.ORG
   
  [EMAIL PROTECTED]cc: 

  COM Subject:  Re: Remedy Import - 
Limits to 15 records  
  Sent by: Action  
   
  Request System
   
  discussion
   
  list(ARSList)
   
  [EMAIL PROTECTED]

  ORG  
   

   

   
  07/31/2006 09:43  
   
  Please respond to 
   
  arslist   
   

   

   




Jason,

If the columns are empty data values in the file. Then do not map
them in the import tool. (It might help.) However, apparently, some
rows have data, or null data, defined for them.

I have seen such behaviour when the csv file is edited with Excel.

Another possible point of confusion is how hard returns are dealt
with in csv format. Some editors write them as hard returns and thus
break up the single line format of csv.


Keep in mind that filters that fire on merge can look at data supplied
to display only fields too. (A good, old school, way to do some
signaling for data merge work IMHO.)


Then again... this could be as simple as a bad client install, or a bug
too.

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

Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.
Never ascribe to malice, that which can be explained by incompetence.


On 7/31/06, Jason McDonald [EMAIL PROTECTED] wrote:
 ** But in that case how does it work for the first 15 records?


 On 7/31/06, Mike White [EMAIL PROTECTED] wrote:
  It's caused by variable-length records.  Remedy Import doesn't tolerate
  them too well.  When we import from .csv, we make sure the last column
is
  fully populated - moving columns if necessary.  This will fix/set your
  record length.
 
  Mike White
  Office:  813-978-2192
  E-mail:  [EMAIL PROTECTED]
 
 
 
   Jason McDonald
   [EMAIL PROTECTED]To:
 arslist@ARSLIST.ORG
   COM cc:
   Sent by: Action Subject:  Remedy Import -
 Limits to 15 records
   Request System
   discussion
   list(ARSList)
   [EMAIL PROTECTED]
   ORG
 
 
   07/31/2006 09:15
   Please respond to
   arslist
 
 
 
 
 
 
  **
  Hi List,
 
  Once again I seek your advice.
 
  This pertains to Remedy 6.0.3.
 
  I am really getting irritated when trying to import data via the Remedy
  Import Tool. Irrespective of what form it is and how much data I have
in

Re: Inherent Limit of Diary Fields

2006-07-31 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: Inherent Limit of Diary Fields
**





Warren:

You hit the nail on the head, so's to speak.

With Sybase and MS SQL the limit is 2GB.

With Oracle (and unless this has changed) it is 1MB (yes, I had all sorts of problems with this.)

However, if you don't have unlimited database space, I would not recommend testing these limits on a regular basis.

James McKenzie






From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Warren Baltimore
Sent: Friday, July 28, 2006 1:48 PM
To: arslist@ARSLIST.ORG
Subject: Re: Inherent Limit of Diary Fields



** 
I've always been told that it is unlimited. Perhaps it is Db dependant?

Warren



On 7/28/06, Kaiser Norm E CIV USAF 96 CG/SCWOE [EMAIL PROTECTED] wrote: 


 ** 


 All:


 


 Anyone know what the inherent limit is to the number of characters for a diary field? I know a lot of folks think it's unlimited, but I'm pretty certain there's a limit-it's just a very high limit. Anyone know off the top their head? 

 


 Norm


 __20060125___This posting was submitted with HTML in it___ 





-- 
Warren R. Baltimore II
Remedy Developer
UW Medicine IT Services
School of Medicine
University of Washington
Box 358220
1325 Fourth Ave, Suite 2000
Seattle, WA 98101


The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. __20060125___This posting was submitted with HTML in it___ 



__20060125___This posting was submitted with HTML in it___

Re: Oracle Analyze

2006-07-31 Thread McKenzie, James J C-E LCMC HQISEC/L3

Title: RE: Oracle Analyze
**





Claire:

Shoot your DBA for running this on an active database.

This command takes a long time and basically locks up your database, It should NEVER be run on a running database.

James McKenzie






From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire
Sent: Monday, July 24, 2006 11:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle Analyze



** 


This is the thing the DBA did.


exec dbms_stats.gather_schema_stats('ARADMIN')


Right now we are dead in the water. Remedy Tech Support is working on it too...


The AR System was up and running at the time and that command has never been run on this database.


If I stop and start the ARS Server service, people can do searches for a little while, then they get time outs.


Any ideas? 


Claire 10 hours of sleep in 72 hours Sanford






From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook
Sent: Saturday, July 22, 2006 1:36 PM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle Analyze



** 
I was thinking the same thing - the Analyze was like a Checkpoint, updating the statistics. That would constitute a pretty significant re-org of the DB, especially if it had been a while since the last time it was run.


Rick






From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank Caruso
Sent: Saturday, July 22, 2006 10:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle Analyze



** Ensure that you have appropriate indexes for the long running queries. Running statistics should be a good thing. Maybe they had not been run in a long time and now your current indexes do not support your bigger queries. Also, fund out exactly what the DBA did. I can remember having problems when stats were run on each table in its entirety. There is a way ton run stats on just a small percentage of the rows in each table which may work better. 




On 7/22/06, Rick Cook [EMAIL PROTECTED] wrote: 


 Ask your DBA what the Analyze function did. I wonder if it reset some indexes or page sizes or something.
 
 
 
 
 Rick Cook * Remedy Approved Consultant * Denali Advanced Integration * (253) 278-4112 
 
 
 
 From: Action Request System discussion list(ARSList) on behalf of Sanford, Claire
 Sent: Sat 7/22/2006 12:11 AM
 To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG 
 Subject: Oracle Analyze
 
 
 
 
 My DBA performed an Oracle Analyze on the remedy database. Since then we have had weird query timeout issues.
 
 Is doing this to a Remedy database a bad thing?
 
 
 
 ARS 4.5.2
 Oracle 8.x I think
 
 
 
 
 Claire who has been working since 8:00am Sanford
 
 ___
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
 
 
 
 ___
 UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
 





-- 
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com http://www.specificintegration.com 
703-376-1249 __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: How do I REinstall an ITSM application

2006-07-31 Thread Curtis Gallant

If you want the installer to not just bork when trying to install again,
simply delete the Incident application record from
SHARE:Application_Properties and the installer should run again. 

Cheers,



Curtis Gallant

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Monday, July 31, 2006 6:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Something to try:

Copy the C:\Program Files\AR System Applications\your server name\BMC
Remedy Incident Management folder to another drive.  If you do not have
access to another drive then copy to a folder outside of C:\Program
Files.  Then delete the C:\Program Files\AR System Applications\your
server name\BMC Remedy Incident Management folder.

You want to keep a copy of the folder in case deleting it causes any
problems.

Run the install again.  If it works then delete the backup copy of the
folder you created above.

Stephen



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare
Sent: Monday, July 31, 2006 8:49 AM
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Stephen,
I don't have an entry for Incident Mgmnt in Add/Remove Programs - but do
have for AR System Server, Approval, Assignment,  Email Engine. 

Thanks

Kieran

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: 31 July 2006 13:37
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Add or Remove Programs in the Windows Control Panel.

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare
Sent: Monday, July 31, 2006 8:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Thanks Stephen, but where do I find the Uninstall?

Kieran

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: 31 July 2006 13:15
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Kieran,

Can you run the Uninstall for Incident Management?

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare
Sent: Monday, July 31, 2006 6:22 AM
To: arslist@ARSLIST.ORG
Subject: How do I REinstall an ITSM application

After a botched Incident Management 7 install, I now wish to reinstall
it. I I don't have any other ITSM 7 applications installed.

However, when I try to rerun the installer I get a message

'all requirement systems are present. Nothing to install' and it doesn't
go any further.

What do I need to do to allow a reinstall? I didn't find any help on
this in the ITSM 7 installation guide. Am I correct in saying it
involves entries in SHARE:Application Properties and if so what entries?


Thanks,

Kieran O'Hare
Programmer
Information Systems Services
200/201 Pearse St.
Trinity College
Dublin 2
Phone +353 1 8962774


___
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


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

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

Remedy career opportunity

2006-07-31 Thread Raymond Viens

The department of Restructuring and Government Efficiency, Alberta
Provincial Government, Canada has a requirement for a Remedy Analyst to
join our team.  Responsibilities include design, quality, change control
and development.  In-depth understanding of Remedy ARS 5.x or higher is
required.  More information pertaining to this opportunity  (Competition
# 35248)  can be accessed on the Government of Alberta Job Opportunities
at:  http://www.pao.gov.ab.ca/jobs/035248.HTM

 
Raymond Viens
Restructuring and Government Efficiency
Alberta Government, Canada

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

Re: Remedy and BLOB data

2006-07-31 Thread Jarl Grøneng


I guess you already sent this as an enhancment request?

--
Jarl

On 7/31/06, Heider, Stephen [EMAIL PROTECTED] wrote:

**


My $0.02.

I think it would be great if BMC used the ubiquitous zip format to compress
attachments.  This would provide a couple advantages:

1. Directly accessible to third-party products, such as WinZip, 7-Zip, etc.,
and also zip format libraries for development in other programming languages
without the ARS API.

2. Administrator or Developer could set the desired compression level
(Maximum, Normal, Fast, Super Fast, None). This would allow the balancing of
performance vs compression ratio.  Ideally, this setting would apply to
individual forms instead of global. Certain forms you may want to have
maximum compression, and other forms fast compression. Even better, allow
the setting of the compression ratio by field.

Stephen

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jason McDonald
Sent: Monday, July 31, 2006 9:04 AM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy and BLOB data


**
I am actually trying to bypass remedy and directly get the blob content of a
field.

I thought this was possible via special tools but since remedy is
compressing them, they are of no use. I will give the c program a shot.

Do you have any other alternative solutions?

Thanks..


On 7/31/06, Michiel Beijen [EMAIL PROTECTED] wrote:
 Jason,

 You should check out the ARGetEntryBLOB call, and check sample scripts
 provided with the API.
 Also refer to the documentation for the API, there are two PDF's about
 this included in the v7 documentation.
 But it would not be the easiest thing to do if you do not have C
experience.

 What exactly are you trying to accomplish? You might also want to look
 in to exporting records using runmacro.
 --
 Michiel

 On 7/30/06, Jason McDonald [EMAIL PROTECTED] wrote:
  **
 
-
  OK thanks.
 
  I downloaded the
  http://arswiki.org/dist/ars/api/api_win_en_700_000.zip
from
  the web.
 
  Now, how do I write a C program to display a BLOB file (PDF) from the
table
  B52CX in the aradmin schema? Also, I would like the program to
  automatically know the MIME type (its stored in B52 table)...so the C
  program must query the B52 table and find out the MIME type and then
open it
  in a suitable program. Any pointers?
 
  Thanks.
 
 
 
  On 7/31/06, Jason McDonald [EMAIL PROTECTED] wrote:
  
  
   OK thanks.
  
   I downloaded the
  http://arswiki.org/dist/ars/api/api_win_en_700_000.zip
from
  the web.
  
   Now, how do I write a C program to display a BLOB file (PDF) from the
  table B52CX in the aradmin schema? Also, I would like the
program to
  automatically know the MIME type (its stored in B52 table)...so the C
  program must query the B52 table and find out the MIME type and then
open it
  in a suitable program. Any pointers?
 
 
 
  Thanks.
 
 
  On 7/30/06, Michiel Beijen  [EMAIL PROTECTED]  wrote:
   you could use it from a C program, or from java, or other langages.
   See
  http://arswiki.org/wiki/index.php?title=API_Programming
   -- Michiel
  
   On 7/30/06, Jason McDonald [EMAIL PROTECTED]  wrote:
**
Could you please explain how to use the API?
   
Thanks
   
   
On 7/30/06, Michiel Beijen  [EMAIL PROTECTED] wrote:

they are not exactly encrypted, but they ARE compressed. That's why
you could not just extract the binary data and open the file. But
that's also the reason that a 30MB word doc only occupies a fraction
of that once stored in the database...
If you'd extract the attachment using the API it would uncompress
the
file nicely.
--
Michiel
   
On 7/30/06, Jason McDonald  [EMAIL PROTECTED] wrote:
 **
 Hi All,

 I wanted to know how Remedy ( 7.0) stores LOB data. I was trying
to
  extract
 directly from the database a BLOB field (attachment in remedy ; in
  this
case
 it was a PDF file) but although I knew the MIME type and opened it
in
  a
 special tool designed to extract BLOB data, Acrobat Reader refused
to
  open
 it (it said invalid file).

 Further, following the same process as above, even if I open a
'text
  file'
 attachment, the contents seem to be encrypted and I see junk data
when
 opening it in Notepad.

 Are attachments encrypted by Remedy before storing it in the
database?
  If
 so, how do I bypass remedy and view BLOB data?

 (Dev Env)
 ARS 7.0
 Oracle 10g
 OS - Windows

 Thanks,
 Jason __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___

Prompt for Login on XP Service Pack 2

2006-07-31 Thread Richard Brooks

**








We have had an issue since moving to Windows XP service pack
2 with the User tool and the Prompt for login option.



If someone does not have this option selected then they will
be prompted for login the first time and then they can exit and launch the User
tool with no more prompts until they log off the network and relogin to the
network. At that point they get prompted for login again.



If you watch the registry where remedy stores the encrypted
password you can see it changes the value there when the password is prompted
for the second time.



We use LDAP integration for password authentication and this
worked fine until we moved to Service Pack 2.



We are using an unpatched 6.3 User Tool.



I did not see any fixes listed for this in the User Tool
patches.



Any one else having this issue or using Service Pack 2 with
no issues?



Richard
Brooks 
System
Architect 
SIM Team - Desktop Problem Management

General Mills



763-293-2302








__20060125___This posting was submitted with HTML in it___

Re: How do I REinstall an ITSM application

2006-07-31 Thread strauss

You won't be able to reinstall the ITSM application until you clear out
its entries in the SHARE:Application_Properties form.

Christopher Strauss, MSLS
Remedy Database Administrator
University of North Texas Computing Center
http://remedy.unt.edu/helpdesk/


Christopher Strauss, MSLS
Remedy Database Administrator
University of North Texas Computing Center
http://remedy.unt.edu/helpdesk/
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Monday, July 31, 2006 7:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Something to try:

Copy the C:\Program Files\AR System Applications\your server name\BMC
Remedy Incident Management folder to another drive.  If you do not have
access to another drive then copy to a folder outside of C:\Program
Files.  Then delete the C:\Program Files\AR System Applications\your
server name\BMC Remedy Incident Management folder.

You want to keep a copy of the folder in case deleting it causes any
problems.

Run the install again.  If it works then delete the backup copy of the
folder you created above.

Stephen



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare
Sent: Monday, July 31, 2006 8:49 AM
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Stephen,
I don't have an entry for Incident Mgmnt in Add/Remove Programs - but do
have for AR System Server, Approval, Assignment,  Email Engine. 

Thanks

Kieran

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: 31 July 2006 13:37
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Add or Remove Programs in the Windows Control Panel.

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare
Sent: Monday, July 31, 2006 8:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Thanks Stephen, but where do I find the Uninstall?

Kieran

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: 31 July 2006 13:15
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Kieran,

Can you run the Uninstall for Incident Management?

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare
Sent: Monday, July 31, 2006 6:22 AM
To: arslist@ARSLIST.ORG
Subject: How do I REinstall an ITSM application

After a botched Incident Management 7 install, I now wish to reinstall
it. I I don't have any other ITSM 7 applications installed.

However, when I try to rerun the installer I get a message

'all requirement systems are present. Nothing to install' and it doesn't
go any further.

What do I need to do to allow a reinstall? I didn't find any help on
this in the ITSM 7 installation guide. Am I correct in saying it
involves entries in SHARE:Application Properties and if so what entries?


Thanks,

Kieran O'Hare
Programmer
Information Systems Services
200/201 Pearse St.
Trinity College
Dublin 2
Phone +353 1 8962774


___
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


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

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

ARS 7.0 install error

2006-07-31 Thread Jon Potian

**








Happy Monday, July 31, 2006



I receive the following error when installing AR Server
version 7.0:



14:05:30 -[ERROR]: Couldn't
create the Demo user.

14:05:30 -[ERROR]: Failed to
create a valid Admin user. This installation cannot complete importing of forms
or data. A valid Admin user will need to be created and froms and data manually
imported.



This error occurred after the
installation of the AR System was completed.

To correct this error, import the sample
applications from the samples subdirectory.

14:07:33 Done importing forms.

14:07:33 -[ERROR]: Failed to
complete AR Server installation.



The environment is Windows Server 2003 and Oracle 9.2.0.6.0.
I have dbo access to the database, which is on a remote server. The error
occurs when the install executable states that it is importing sample
data. 



Anyone encounter this or have any thoughts as to where the
problem may lie? TIA.



 Regards,





Jon-Marcelius Potian 
Mobile:
908.910.6660  [EMAIL PROTECTED]








__20060125___This posting was submitted with HTML in it___

Question about Data transfer APIs

2006-07-31 Thread Nagaraj, Jayashree

**








Hello,



We are
looking to transfer from remedy tickets into our bug tracking system. Ideally,
we would be able to specify one of more remedy incident numbers and pull all information
about the ticket. 



Are there
APIs available to do this? Any information about this kind of data transfer
capability would be very useful.



Thanks,

-Jayashree



Jayashree Nagaraj
Web Academic Systems Analyst
Stanford Business School
650-736-1433
[EMAIL PROTECTED]


















__20060125___This posting was submitted with HTML in it___

Re: Question about Data transfer APIs

2006-07-31 Thread Joseph Kubasek

Jayashree,

There are a variety of official and unofficial APIs using:
- C
- Java
- Web Services (not exactly an API but...)
- Perl
 and others.

For the  C, Java, or Web Service interfaces, please see you Remedy 
Documentation.

For a Perl interface, please see http://www.arsperl.org/ .

You may also want to look at the ars wiki for some other options 
(http://www.arswiki.org/wiki/index.php?title=Main_Page).

Joe

At 12:30 PM 7/31/2006, you wrote:
** 

Hello,

 

We are looking to transfer from remedy tickets into our bug tracking system. 
Ideally, we would be able to specify one of more remedy incident numbers and 
pull all information about the ticket. 

 

Are there APIs available to do this? Any information about this kind of data 
transfer capability would be very useful.

 

Thanks,

-Jayashree

 

Jayashree Nagaraj
Web Academic Systems Analyst
Stanford Business School
650-736-1433
mailto:[EMAIL PROTECTED][EMAIL PROTECTED]

 

 

 

 
__20060125___This posting was submitted with HTML in it___ 


---
Joseph Kubasek
   AR Systems Administrator
   The Ohio State University (Office of Information Technology)
   [EMAIL PROTECTED]
   614-292-2277

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

Re: Remedy Import - Limits to 15 records

2006-07-31 Thread Michiel Beijen


Have you checked the Error Handling tab in the Preferences dialog in
BMC Remedy Import?
You might want to check the box before Import Records with Too Few
Fields if your data file is correct, but the import keeps moaning
about this.
IMO this would be the easiest option to deal with this issue.
--
Michiel

On 7/31/06, Ron Fariss [EMAIL PROTECTED] wrote:

Jason,

Another trick,  create a final column labeled LAST and put a constant value
in each cell. (I use 1).  Then each row has a guaranteed value and you just
don't map the column to any field.  Remedy doesn't care whether you have
more columns than you need, only if there are less columns.

If you save the file as .csv using Excel, Excel puts all of the text fields
within quotation characters ().  If you are still having problems, open
the .csv file with Notepad to try to determine what might be causing your
problem.

Ron Fariss

AIG Technologies
Remedy  TelAlert Administration
Work:  (713) 831-2365
Cell: (281) 782-0979



  Mike White
  [EMAIL PROTECTED]To:   arslist@ARSLIST.ORG
  ON.COM  cc:
  Sent by: Action Subject:  Re: Remedy Import - 
Limits to 15 records
  Request System
  discussion
  list(ARSList)
  [EMAIL PROTECTED]
  ORG


  07/31/2006 08:51
  AM
  Please respond to
  arslist






Length probably changed after the 15th record (column populated for rows
1-14, but not for 15th, or vice-versa).  I haven't seen your data, but this
is where I'd look first.

Matt makes good points about data condition.  Hard returns result in two
(or more) records where you intended one.  Field mapping would misalign.

Imbedded commas in text could be problematic, too.  (.csv files are
comma-separated).

Mike White
Office:  813-978-2192
E-mail:  [EMAIL PROTECTED]



  Carey Matthew

  Black   To:
arslist@ARSLIST.ORG
  [EMAIL PROTECTED]cc:

  COM Subject:  Re: Remedy Import
- Limits to 15 records
  Sent by: Action

  Request System

  discussion

  list(ARSList)

  [EMAIL PROTECTED]

  ORG



  07/31/2006 09:43

  Please respond to

  arslist







Jason,

If the columns are empty data values in the file. Then do not map
them in the import tool. (It might help.) However, apparently, some
rows have data, or null data, defined for them.

I have seen such behaviour when the csv file is edited with Excel.

Another possible point of confusion is how hard returns are dealt
with in csv format. Some editors write them as hard returns and thus
break up the single line format of csv.


Keep in mind that filters that fire on merge can look at data supplied
to display only fields too. (A good, old school, way to do some
signaling for data merge work IMHO.)


Then again... this could be as simple as a bad client install, or a bug
too.

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

Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.
Never ascribe to malice, that which can be explained by incompetence.


On 7/31/06, Jason McDonald [EMAIL PROTECTED] wrote:
 ** But in that case how does it work for the first 15 records?


 On 7/31/06, Mike White [EMAIL PROTECTED] wrote:
  It's caused by variable-length records.  Remedy Import doesn't tolerate
  them too well.  When we import from .csv, we make sure the last column
is
  fully populated - moving columns if necessary.  This will fix/set your
  record length.
 
  Mike White
  Office:  813-978-2192
  E-mail:  [EMAIL PROTECTED]
 
 
 
   Jason McDonald
   [EMAIL PROTECTED]To:
 arslist@ARSLIST.ORG
   COM cc:
   Sent by: Action Subject:  Remedy Import -
 Limits to 15 records
   Request System
   discussion
   list(ARSList)
   [EMAIL PROTECTED]
   ORG
 
 
   07/31/2006 09:15
   Please respond to
   arslist
 
 
 
 
 
 
  **
  Hi List,
 
  Once again I seek your advice.
 
  This pertains to Remedy 6.0.3.
 
  I am really getting irritated when trying to import data via the Remedy
  Import Tool. Irrespective of what form it is and how much data I have
in
  the CSV file, Import always breaks at 15th record with the message -
  [Record 16 of XX] : Unable to import. Found 30 columns, expected 32
 
  Note that it

Remedy and .NET API

2006-07-31 Thread Mark B.

Hi All,

I'm quite new to Remedy so please be patient :)
I've just encountered with two problems concerning .NET API calls.
I want to retrieve information of description field among other fields
and put it into table. 

Calling function GetListEntryWithFields gives me the error:
Error (241): Cannot specify a diary field, a character field with
unlimited length
or maximum length over 255 bytes, or Status-History as a field in a get 
list description;24007
which is correct: Description field has unilimited length
But I would like to know if  there is any other way to get the
description field content and put it into datatable?

Second problem concerns retrieving information from Status-History
diary field.
I can add a record to a diaryfield eg. this way:
DiaryList.Add(DiaryEntry)
but can't find any relative method to get the specified record out of 
the Status-History field.
Documentation says that there is a public property Item of DiaryList
class but my VisualStudio's IntelliSense either debugger doesn't see
this property

Please point to the right direction  if I'm wrong with this approach 

I use the most recent api from BMC download page and ARSystem 6.3 
Any help (code snippets) would be appreciated.

Thanks, Mark

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

Re: ITSM 7.0 Overview Console - Plug-in Error

**



 

Anjali,

Same error here with Problem Management module. All of 
the ARS 7 and ITSM 7 modules were installed on a newly built server that did not 
have any previous ARS software loaded.

There are 2 private queues that were added by the 
installation programs (After the initial ARS 7.0 p1). I don't know which 
installation program created the private queue (# 

The CAI PluginRegistry form did not have any 
records on our system. I added one record with the private queue number 
(that was created by installation programs) with 2 threads. I restarted 
start the server.

Which registry key? In 
HKLM/Software/Remedy and HDCU/Software/RemedyI don'tsee the place to 
enter the queue number.

Stephen



From: Action Request System discussion 
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Anjali 
GosainSent: Thursday, July 27, 2006 12:06 AMTo: 
arslist@ARSLIST.ORGSubject: Re: ITSM 7.0 Overview Console - Plug-in 
Error
** Hi ,We got the same error. We have not been able to 
resolve this issue but here's a workaround that can be used - Create a 
new private queue in admin tool (Server Information - Server Ports and 
Queue) and note its RPC Program Number. Open the form 'CAI Plugin Registry' and 
look for the entry with PluginID = CAIPLUGIN (our form has only one entry..) 
Modify the registry to reflect the new private queue no = RPC Program Number of 
new queue. Restart the server. As I said this is a workaround and the problem 
will return after a while. Do let me know if you are able to find a 
solution to itRegardsAnjaliMike Gould wrote:
** 
  Good Morning List,
  
  I've just finished a full installation of ITSM 7.0 and was checking out 
  the new features when I tried to open the Foundation Elements Overivew Console 
  and received the following error:
  
  ARERR [8939] The AR System Plug-In server is not 
  responding. Cannot connect to the system at this time. Contact 
  your AR System Administrator for assistance. : RPC: Timed 
  out
  
  I've contacted Remedy Tech Support and provided them all the 
  logsbut they haven't been able to offer a solution so far. 
  Everything else appears to be functioning correctly and all the services are 
  up, including the arplugin.exe service.
  
  If anyone else has experienced this problem and knows of a resolution, I 
  would appreciate it if you could pass it along.
  
  Thanks in advance,
  Michael J. Gould
  Senior Software Engineer
  U.S House of Representatives
  
  ARS 7.0 Patch 1
  ITSM 7.0
  Windows Server 2003 R2
  MS SQL Server 2000 w/ SP4__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___

Has anyone upgraded from 5.1.2 to 7.0

2006-07-31 Thread Marino, Melanie A

**



Has anyone upgraded 
from AR System5.1.2 to 7.0 in a Solaris environment that runs 
Oracle? Did you upgrade your OS and Database prior to the 7.X 
installation?

Any success stories 
would be greatly appreciated.

Thanks,
Melanie 
Marino
KPMG 
LLP
[EMAIL PROTECTED]
 

* 

The information in this email is confidential and may be legally privileged.  It is intended solely for the addressee. Access to this email by anyone else is unauthorized.  

 

If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing KPMG client engagement letter.   

* 

  
__20060125___This posting was submitted with HTML in it___

Deleted Groups

**



Our system doesn't seem to be recovering too well after the group 
duplications. I tried arreload, arcache, upgrade,restoring the 
backup of the database. The application still hangs since the admin 
imported multiple groups.

Our technical team wants to ghost production and turn this to the 
development server. We have CMDB, Mid Tier, Change Mgmt., Help Desk on 
both servers. I didn't think ghosting would be a better option than 
reinstalling. Is ghosting Prod the better solution?

__20060125___This posting was submitted with HTML in it___

Re: Remedy and .NET API

2006-07-31 Thread Papolu, Appajee

Mark,

Fields that can have values over 255 bytes can NOT be used within a
GetListEntryWithFields call. In such cases, you'll have to make separate
calls as below:
- GetListEntry or GetListEntryWithFields : primarily for issuing the
query and secondarily retrieving matched entries' shorter(?) values;
- Loop over the matched entries above and iteratively issue a GetEntry
call to retrieve values for fields with long character data.

For operating on StatusHistory field values, please use StatusHistory 
StatusHistoryItem classes. Diary and StatusHistory are different types;
their values encoded differently; and hence have different classes
handling them.

Regards
Appajee


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mark B.
Sent: Monday, July 31, 2006 12:00 PM
To: arslist@arslist.org
Subject: Remedy and .NET API

Hi All,

I'm quite new to Remedy so please be patient :)
I've just encountered with two problems concerning .NET API calls.
I want to retrieve information of description field among other fields
and put it into table. 

Calling function GetListEntryWithFields gives me the error:
Error (241): Cannot specify a diary field, a character field with
unlimited length
or maximum length over 255 bytes, or Status-History as a field in a get 
list description;24007
which is correct: Description field has unilimited length
But I would like to know if  there is any other way to get the
description field content and put it into datatable?

Second problem concerns retrieving information from Status-History
diary field.
I can add a record to a diaryfield eg. this way:
DiaryList.Add(DiaryEntry)
but can't find any relative method to get the specified record out of 
the Status-History field.
Documentation says that there is a public property Item of DiaryList
class but my VisualStudio's IntelliSense either debugger doesn't see
this property

Please point to the right direction  if I'm wrong with this approach 

I use the most recent api from BMC download page and ARSystem 6.3 
Any help (code snippets) would be appreciated.

Thanks, Mark


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

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

Re: contract to hire opportunity in Pasadena, CA

2006-07-31 Thread Robert Ward

This opportunity is in Pasadena, CA.

Robert Ward
1-800-823-1470

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

Re: Deleted Groups

**



How about the CMDB and MidTier configurations. Wouldn't they now be 
pointing to production? I amconcerned about the ghosting 
option. Is this the best choice vs. re-installing?


__20060125___This posting was submitted with HTML in it___

Remedy Developer - contract to hire opportunity in Pasadena, California

2006-07-31 Thread Robert Ward

Our client is in need of a Remedy Developer.

Position Description: Develops block diagrams and logic flow charts. 
Translates detailed design into computer software. Supports testing, 
debugging, and refining the computer software to produce the required 
product. Helps prepare both program-level and user-level documentation. 
Enhances software to reduce operating time or improve efficiency. 
Experience Level: 6-10 Years. Skill Set: Ability to rely on instructions 
and pre-established guidelines to perform the functions of the position. 
Knowledge of commonly used concepts, practices, and procedures within a 
particular field. Familiar with relational database concepts, and client-
server concepts.

Come join the WaHco Team with over 29 years in the IT Consulting Industry. 
Known for outstanding client and employee satisfaction (our employees are 
our most valuable asset and our best references). We will check your 
references; we invite you to check ours.

We offer a superior benefits package: Employer paid LTD and Life Ins; 
Cafeteria Plan with optional Health, Dental and Child Care; immediate 
eligibility in self-directed 401k Plan; and payroll direct deposit option.

Please send your resume in a word format with the job order number in the 
subject line. If you are not currently available, but know someone who is, 
we do pay a REFFERAL FEE. Please contact us for details.

Robert Ward  
Technical Recruiter 
W.A. Hynes  Company, Inc.
Information Technology  Consulting Services
(800) 823-1470
(707) 586-
[EMAIL PROTECTED]
www.waHco-it.com

 

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

Re: Deleted Groups

2006-07-31 Thread Susan Palmer

**
Kathy,

What advice has Remedy (bmc) support provided? Usually they would give you step by step instructions on how to recover from this. That's what your maintenance fee is also covering.

Susan
On 7/31/06, Kathy Morris [EMAIL PROTECTED] wrote:

** 

How about the CMDB and MidTier configurations. Wouldn't they now be pointing to production? I amconcerned about the ghosting option. Is this the best choice vs. re-installing?


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

Re: Deleted Groups

**



I received two very different set of instructions from Remedy.
This is why I called upon the experts on the ARS 
List.
__20060125___This posting was submitted with HTML in it___

Re: Deleted Groups

2006-07-31 Thread Susan Palmer

**
Do either of the Remedy instructions match up to responses here? What was their response to their different options? Sometimes there are more than one solution.


On 7/31/06, Kathy Morris [EMAIL PROTECTED] wrote:

** 

I received two very different set of instructions from Remedy.
This is why I called upon the experts on the ARS List.
__20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___

Re: Deleted Groups