SOLVED: Remedy API and gcc on Redhat Linux
Good morning: Using the changes to the Makefile shown below and copying the missing library files from ar_install_dir/approval/bin, I was able to compile and link the program driver. It works correctly. Despite what BMC told me via Maryville, I did not need to upgrade my gcc compiler. Thank you, thank you. Thorin From: Axton [mailto:axton.gr...@gmail.com] Sent: Saturday, August 22, 2009 3:17 AM Subject: Re: Remedy API and gcc on Redhat Linux ** Glad to hear you got it working; much easier than compiling a compiler and running into the same problem with the new compiler :) Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Sat, Aug 22, 2009 at 2:50 AM, Conny Martin conny.mar...@t-systems.com wrote: ** Axton, you're right, there is a mismatch. The CFLAGS settings tells gcc to generate 32-Bit object files. But in LDFLAGS -m32 wasn't set. The linker is then trying to generate a 64-Bit binary. But libar.so is definitely a 32-bit binary. The 64 bit version is named libar_lx64.so Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Axton Gesendet: Freitag, 21. August 2009 21:36 An: arslist@ARSLIST.ORG Betreff: Re: Remedy API and gcc on Redhat Linux ** The libraries are provided in both 32-bit and 64-bit on the non-Windows releases of ARS 7.5. Page 64 provides additional information. http://documents.bmc.com/supportu/documents/53/84/95384/95384.pdf This looks like a mismatch between the 32/64 bit api and the CFLAGS you are using. See Lyle's message on how to straighten it out and set the flags properly. Axton Grams On Fri, Aug 21, 2009 at 1:40 PM, Conny Martin conny.mar...@t-systems.com wrote: ** libar.so is 32 bit-binary. The Makefile provided by BMC won't work unless you do a little customisation this one works for me. # # Parameters. PROGRAM = driver SOURCES = api.c get.c main.c print.c util.c OBJECTS = api.o get.o main.o print.o util.o # Compiler flags. CC = cc CFLAGS = -m32 -g -DDEBUG -D_REENTRANT -malign-double CPPFLAGS = -I../include -I../../include LDFLAGS = -m32 -L../lib -L../../lib LDLIBS = -lar -lnsl -lpthread -lncurses -ldl -licuucbmc -licui18nbmc -licudatabmc # Standard targets. all: $(PROGRAM) objects: $(OBJECTS) $(PROGRAM): $(OBJECTS) $(CC) -o $(PROGRAM) $(OBJECTS) $(LDFLAGS) $(LDLIBS) clean: $(RM) $(PROGRAM) $(OBJECTS) core --- There are also some libs missing in ar_install_dir/api/lib. So I copied them from ar_install_dir/bin libicudatabmc.so libicudatabmc.so.32 libicui18nbmc.so libicui18nbmc.so.32 libicuucbmc.so libicuucbmc.so.32 HTH Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Lyle Taylor Gesendet: Freitag, 21. August 2009 18:56 An: arslist@ARSLIST.ORG Betreff: Re: Remedy API and gcc on Redhat Linux ** In your build directory, run the following command and send us the output: file ../../lib/libar.so Your build options seem to be telling it to build a 32-bit executable, but 75 is 64-bit on Linux. The command above will verify whether libar.so is a 32 or 64-bit binary. If it's 64-bit, then change -m32 to -m64 in your
Re: Remedy API and gcc on Redhat Linux
Dear Axton:
Here is a listing of my Makefile (same as out-of-the-box), the run,
and a directory listing after the run.
Thorin
remedy75{xxremedy}57: more Makefile
#
# Parameters.
PROGRAM = driver
SOURCES = api.c get.c main.c print.c util.c
OBJECTS = api.o get.o main.o print.o util.o
# Compiler flags.
CC = cc
CFLAGS = -m32 -g -DDEBUG -D_REENTRANT -malign-double
CPPFLAGS = -I../include -I../../include
LDFLAGS = -L../lib -L../../lib
LDLIBS = -lar -lnsl -lpthread -lcurses -ldl
# Standard targets.
all: $(PROGRAM)
objects: $(OBJECTS)
$(PROGRAM): $(OBJECTS)
$(CC) -o $(PROGRAM) $(OBJECTS) $(LDFLAGS) $(LDLIBS)
clean:
$(RM) $(PROGRAM) $(OBJECTS) core
___
remedy75{xxremedy}58: make
cc -o driver api.o get.o main.o print.o util.o -L../lib -L../../lib -lar
-lnsl -lpthread -lcurses -ldl
/usr/bin/ld: skipping incompatible ../../lib/libar.so when searching for
-lar
/usr/bin/ld: skipping incompatible ../../lib/libar.a when searching for
-lar
/usr/bin/ld: cannot find -lar
collect2: ld returned 1 exit status
make: *** [driver] Error 1
___
remedy75{xxremedy}59: ls -l
total 1880
-rwxr-xr-x 1 xxremedy ftp 411821 Mar 10 04:03 api.c*
-rwxr-xr-x 1 xxremedy ftp 5906 Mar 10 04:03 api.h*
-rw-r--r-- 1 xxremedy ftp 314412 Aug 21 11:22 api.o
-rwxr-xr-x 1 xxremedy ftp 210747 Mar 10 04:03 get.c*
-rwxr-xr-x 1 xxremedy ftp 6902 Aug 7 15:08 get.h*
-rw-r--r-- 1 xxremedy ftp 153016 Aug 21 11:22 get.o
-rwxr-xr-x 1 xxremedy ftp 5727 Mar 10 04:03 globals.h*
-rwxr-xr-x 1 xxremedy ftp 65161 Aug 17 13:30 main.c*
-rwxr-xr-x 1 xxremedy ftp 19440 Mar 10 04:03 main.h*
-rw-r--r-- 1 xxremedy ftp 47636 Aug 21 11:22 main.o
-rwxr-xr-x 1 xxremedy ftp509 Aug 21 11:22 Makefile*
-rwxr-xr-x 1 xxremedy ftp 282759 Mar 10 04:03 print.c*
-rwxr-xr-x 1 xxremedy ftp 7934 Mar 10 04:03 print.h*
-rw-r--r-- 1 xxremedy ftp 200340 Aug 21 11:22 print.o
-rwxr-xr-x 1 xxremedy ftp 46470 Aug 14 19:24 util.c*
-rwxr-xr-x 1 xxremedy ftp 2054 Mar 10 04:03 util.h*
-rw-r--r-- 1 xxremedy ftp 31184 Aug 21 11:22 util.o
-rw-r--r-- 1 xxremedy ftp 1674 Aug 14 19:21 wfd_shared.h
rmdy-papr02.comp.wepco.com{xxremedy}60:
From: Axton [mailto:axton.gr...@gmail.com]
Sent: Thursday, August 20, 2009 7:27 PM
Subject: Re: Remedy API and gcc on Redhat Linux
** I'm not sure why you would need 4.4.1. Why don't you post the
compiler/linker output and the build options.
Axton Grams
The opinions, statements, and/or suggested courses of action expressed
in this E-mail do not necessarily reflect those of BMC Software, Inc. My
voluntary participation in this forum is not intended to convey a role
as a spokesperson, liaison or public relations representative for BMC
Software, Inc.
On Thu, Aug 20, 2009 at 4:24 PM, Marty.Thorin
thorin.ma...@we-energies.com wrote:
**
Good afternoon:
I tried to compile the out-of-the-box program 'driver'.
It compiled but would not link. When I asked BMC I was informed my copy
of gcc (3.4.6) is too old and I need to upgrade to 4.4.1.
I downloaded 4.4.1 today but it looks like I need to build the
gcc compiler!?! This is not a small task. So I figure I must have done
something wrong. Does anyone know where to download gcc 4.4.1 for
Redhat in a tar or zip file?
Thank you,
Thorin
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the
Answers Are_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Remedy API and gcc on Redhat Linux
Good afternoon: I tried to compile the out-of-the-box program 'driver'. It compiled but would not link. When I asked BMC I was informed my copy of gcc (3.4.6) is too old and I need to upgrade to 4.4.1. I downloaded 4.4.1 today but it looks like I need to build the gcc compiler!?! This is not a small task. So I figure I must have done something wrong. Does anyone know where to download gcc 4.4.1 for Redhat in a tar or zip file? Thank you, Thorin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: File wfd_shared.h
Here is a copy of the current run. Although we are running on Redhat
Linux, the same code is bundled with the Windows API. Trying to compile
with a Microsoft C compiler yields this same complaint.
rmdy-papr02.comp.wepco.com{xxremedy}27: cd driver
/opt/bmc_software/Remedy/ARSystem/api/src/driver
rmdy-papr02.comp.wepco.com{xxremedy}28: make
cc -m32 -g -DDEBUG -D_REENTRANT -malign-double -I../include
-I../../include -c -o api.o api.c
api.c:24:24: wfd_shared.h: No such file or directory
api.c: In function `APIWFDSetDebugMode':
api.c:11278: error: `WFD_STOP_START_API' undeclared (first use in this
function)
api.c:11278: error: (Each undeclared identifier is reported only once
api.c:11278: error: for each function it appears in.)
api.c:11283: error: `WFD_STOP_QUALIFIER' undeclared (first use in this
function)
api.c:11288: error: `WFD_STOP_P1_ACTION' undeclared (first use in this
function)
api.c:11293: error: `WFD_STOP_P2_ACTION' undeclared (first use in this
function)
api.c:11298: error: `WFD_STOP_P3_ACTION' undeclared (first use in this
function)
api.c:11303: error: `WFD_STOP_END_API' undeclared (first use in this
function)
api.c:11308: error: `WFD_STOP_ESC_ACTION' undeclared (first use in this
function)
api.c:11313: error: `WFD_STOP_CMDB' undeclared (first use in this
function)
make: *** [api.o] Error 1
rmdy-papr02.comp.wepco.com{xxremedy}29:
The top of aie.c is
/* File: api.c */
#include stdlib.h
#ifdef _WIN32
#include time.h
#ifndef snprintf
#define snprintf _snprintf
#endif
#define strcasecmp _stricmp/* Case-insensitive compare on Windows
*/
#else /* _WIN32 */
#include unistd.h
#endif /* _WIN32 */
#include stdio.h
#include string.h
#include ar.h
#include arextern.h
#include arfree.h
#include api.h
#include get.h
#include globals.h
#include print.h
#include util.h
#include wfd_shared.h
#include arerrno.h
The errors are found in this subroutine: Lines 11259 through 11320.
/***
**/
/*
*/
/* APIWFDSetDebugMode
*/
/*
*/
/***
**/
int
APIWFDSetDebugMode()
{
int result = 0;
unsigned int debugMode = 0;
ARStatusList status = {0, NULL};
/* Get parameters */
if( NOT_WFD_QUIET )
DriverPrintHeader(WFD SET DEBUG MODE);
DriverPrintHeader( Debug Mode to set (stop at)? : );
if( GetARBoolean( Begin API (T): , TRUE) )
debugMode |= WFD_STOP_START_API;
else
debugMode = ~WFD_STOP_START_API;
if( GetARBoolean( Qualifier (T): , TRUE) )
debugMode |= WFD_STOP_QUALIFIER;
else
debugMode = ~WFD_STOP_QUALIFIER;
if( GetARBoolean( Phase 1 (T): , TRUE) )
debugMode |= WFD_STOP_P1_ACTION;
else
debugMode = ~WFD_STOP_P1_ACTION;
if( GetARBoolean( Phase 2 (T): , TRUE) )
debugMode |= WFD_STOP_P2_ACTION;
else
debugMode = ~WFD_STOP_P2_ACTION;
if( GetARBoolean( Phase 3 (T): , TRUE) )
debugMode |= WFD_STOP_P3_ACTION;
else
debugMode = ~WFD_STOP_P3_ACTION;
if( GetARBoolean( End API (T): , TRUE) )
debugMode |= WFD_STOP_END_API;
else
debugMode = ~WFD_STOP_END_API;
if( GetARBoolean( Esc Action (T): , TRUE) )
debugMode |= WFD_STOP_ESC_ACTION;
else
debugMode = ~WFD_STOP_ESC_ACTION;
if( GetARBoolean( CMDB (T): , TRUE) )
debugMode |= WFD_STOP_CMDB;
else
debugMode = ~WFD_STOP_CMDB;
/* Call routine */
return APIWFDDoSetDebugMode( debugMode );
}
_
Thorin
-Original Message-
From: Lyle Taylor [mailto:tayl...@ldschurch.org]
Sent: Tuesday, August 11, 2009 2:56 PM
Subject: Re: File wfd_shared.h
Where is this file actually being included from? Perhaps you could post
the entire error text that the compiler is printing.
Lyle
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Marty.Thorin
Sent: Tuesday, August 11, 2009 1:46 PM
To: arslist@ARSLIST.ORG
Subject: File wfd_shared.h
Good afternoon:
Our system is ARS 7.5 Patch 1. I am trying to compile the API
example 'Driver'. The first file to compile, api.c, fails because it is
missing the include file wfd_shared.h. Does anyone have a copy of this
file that they would post for me?
Thank you,
Thorin
We Energies
Milwaukee, WI
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: File wfd_shared.h
Dear Lyle:
I have contacted BMC. I was just hoping someone else had noticed this
issue and had already received the file. I agree it looks like bit
values.
On Tuesday BMC sent:
***
I have created defect for this issue # SW00339863.
I will check if we can get the file for this defect. I will update you
with more information as soon as possible.
***
As of noon today, no file.
Thorin
-Original Message-
From: Lyle Taylor [mailto:tayl...@ldschurch.org]
Sent: Wednesday, August 12, 2009 12:02 PM
To: Marty.Thorin; arslist@ARSLIST.ORG
Subject: RE: File wfd_shared.h
Hmm. I don't see that file in my 7.5 installation either. Looking at
the program a bit, it looks like BMC probably forgot to include the
header file in the distribution - it doesn't look like it's a system
header or even for a 3rd party API. I would recommend opening a ticket
with BMC and see what they have to say. If it really is their file,
they can send it to you, and submit a bug to get the file included with
the 7.5 installers.
Lyle
-Original Message-
From: Marty.Thorin [mailto:thorin.ma...@we-energies.com]
Sent: Wednesday, August 12, 2009 8:54 AM
To: Lyle Taylor; arslist@ARSLIST.ORG
Subject: RE: File wfd_shared.h
Here is a copy of the current run. Although we are running on Redhat
Linux, the same code is bundled with the Windows API. Trying to compile
with a Microsoft C compiler yields this same complaint.
rmdy-papr02.comp.wepco.com{xxremedy}27: cd driver
/opt/bmc_software/Remedy/ARSystem/api/src/driver
rmdy-papr02.comp.wepco.com{xxremedy}28: make cc -m32 -g -DDEBUG
-D_REENTRANT -malign-double -I../include
-I../../include -c -o api.o api.c
api.c:24:24: wfd_shared.h: No such file or directory
api.c: In function `APIWFDSetDebugMode':
api.c:11278: error: `WFD_STOP_START_API' undeclared (first use in this
function)
api.c:11278: error: (Each undeclared identifier is reported only once
api.c:11278: error: for each function it appears in.)
api.c:11283: error: `WFD_STOP_QUALIFIER' undeclared (first use in this
function)
api.c:11288: error: `WFD_STOP_P1_ACTION' undeclared (first use in this
function)
api.c:11293: error: `WFD_STOP_P2_ACTION' undeclared (first use in this
function)
api.c:11298: error: `WFD_STOP_P3_ACTION' undeclared (first use in this
function)
api.c:11303: error: `WFD_STOP_END_API' undeclared (first use in this
function)
api.c:11308: error: `WFD_STOP_ESC_ACTION' undeclared (first use in this
function)
api.c:11313: error: `WFD_STOP_CMDB' undeclared (first use in this
function)
make: *** [api.o] Error 1
rmdy-papr02.comp.wepco.com{xxremedy}29:
The top of aie.c is
/* File: api.c */
#include stdlib.h
#ifdef _WIN32
#include time.h
#ifndef snprintf
#define snprintf _snprintf
#endif
#define strcasecmp _stricmp/* Case-insensitive compare on Windows
*/
#else /* _WIN32 */
#include unistd.h
#endif /* _WIN32 */
#include stdio.h
#include string.h
#include ar.h
#include arextern.h
#include arfree.h
#include api.h
#include get.h
#include globals.h
#include print.h
#include util.h
#include wfd_shared.h
#include arerrno.h
The errors are found in this subroutine: Lines 11259 through 11320.
/***
**/
/*
*/
/* APIWFDSetDebugMode
*/
/*
*/
/***
**/
int
APIWFDSetDebugMode()
{
int result = 0;
unsigned int debugMode = 0;
ARStatusList status = {0, NULL};
/* Get parameters */
if( NOT_WFD_QUIET )
DriverPrintHeader(WFD SET DEBUG MODE);
DriverPrintHeader( Debug Mode to set (stop at)? : );
if( GetARBoolean( Begin API (T): , TRUE) )
debugMode |= WFD_STOP_START_API;
else
debugMode = ~WFD_STOP_START_API;
if( GetARBoolean( Qualifier (T): , TRUE) )
debugMode |= WFD_STOP_QUALIFIER;
else
debugMode = ~WFD_STOP_QUALIFIER;
if( GetARBoolean( Phase 1 (T): , TRUE) )
debugMode |= WFD_STOP_P1_ACTION;
else
debugMode = ~WFD_STOP_P1_ACTION;
if( GetARBoolean( Phase 2 (T): , TRUE) )
debugMode |= WFD_STOP_P2_ACTION;
else
debugMode = ~WFD_STOP_P2_ACTION;
if( GetARBoolean( Phase 3 (T): , TRUE) )
debugMode |= WFD_STOP_P3_ACTION;
else
debugMode = ~WFD_STOP_P3_ACTION;
if( GetARBoolean( End API (T): , TRUE) )
debugMode |= WFD_STOP_END_API;
else
debugMode = ~WFD_STOP_END_API;
if( GetARBoolean( Esc Action (T): , TRUE) )
debugMode |= WFD_STOP_ESC_ACTION;
else
debugMode = ~WFD_STOP_ESC_ACTION;
if( GetARBoolean( CMDB (T): , TRUE) )
debugMode |= WFD_STOP_CMDB;
else
debugMode = ~WFD_STOP_CMDB;
/* Call routine */
return APIWFDDoSetDebugMode( debugMode ); }
_
Thorin
-Original Message
File wfd_shared.h
Good afternoon: Our system is ARS 7.5 Patch 1. I am trying to compile the API example 'Driver'. The first file to compile, api.c, fails because it is missing the include file wfd_shared.h. Does anyone have a copy of this file that they would post for me? Thank you, Thorin We Energies Milwaukee, WI ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
AIE and HP's Asset Center
I realize this question is a bit more generic than my normal questions. I have co-worker trying to connect Asset Center to Remedy 7.5. This is the product HP got then they purchased Peregrine. (No jokes please. I rode out the Peregrine debacle.) She is trying to follow a manual for connecting EIE to Asset Center that was supplied by our first level support. Additional information: Remedy: 1. Version 7.5 Patch 1 on everything: ARS, CMDB, ITSM, SLM. (Okay, SLM is just 7.5 because it does not have a patch 1.) 2. Oracle 10g database 3. Redhat Linux. Asset Center 1. Asset Center version 4.4.1. 2. Windows 2003 server. 3. Oracle 10g database. Using AIE we can reach the Oracle database for Asset Center. The table on the left is full. We can click on the and additional items show on the right. But I do not know how to view the contents nor update the data. The objective is to exchange data between the two. Scheduled bulk updates would be fine. I am probably missing something incredibly simple. Thorin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
MidTier 6.3 and Windows server 2003 SP 2
Good afternoon: Server operations wants to upgrade my MidTier 6.3 server from Windows 2003 SP1 to Windows 2003 SP2. I just checked the community to see if anyone had any problems with this change. I checked the 6.3 compatibility matrix. It shows Windows Server 2003 but does not list SP2. (Nor SP1 but I downloaded the matrix in 2006.) Thank you, Thorin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Moving databases and switching server names within
Dear Joe: Thank you for the clue. I was easily able to do with with 6.3 but it has really bit us with our 7.1 to 7.5 upgrade. BTW: We were unable to get the system to upgrade because our assignment engine was only 7.1.0. Patch 0. Parch 3 was the first to put an entry into SHARE:Properties. This destroyed our CMDB install,m requiring database rollback before attempting again. We had so many problems upgrading that we abandoned the effort, stripped the database, and did fresh installs. Fortunately our 7.1 system only contained the foundation data, not thousands of Service Desk records. (Those are still safe in our 6.3 system.) As for doing teh same install over and over again, there are two .xml files that hold all the settings from each install. Blow these away and it will install again. Otherwise it checks these files before touching anything. Each of the installers has their own set (ARS, CMDB, ITSM, and SLM). We did our work on Redhat Linux with Oracle 10g. Thorin From: Joe DeSouza [mailto:joe_rem...@yahoo.com] Sent: Tuesday, May 26, 2009 4:37 PM Subject: Re: Moving databases and switching server names within ** Thorin, If you are talking about server names in the definitions, there is a easier way out.. Take an XML definition file and look for the tag Server-Name This tag will have the offending value so you can do a simple search and replace for what you want to do. And then reimport the def file.. Joe From: Marty.Thorin thorin.ma...@we-energies.com To: arslist@ARSLIST.ORG Sent: Tuesday, May 26, 2009 5:29:50 PM Subject: Moving databases and switching server names within ** Good afternoon: I need to copy a fully loaded Remedy 7.5 server and its database to another machine. Copying and updating the Linux files is easy. I just copy then hunt and replace every instance of the old server's name with the new server name. I thought the Oracle 10g database would be just as easy. (All tablespaces keep the their same name so it is ARSystem everywhere. I will be changing the database server's name.) Last time I brought up Remedy then went to the Admin Console and updated the e-mail engine. I am hesitant to do this because this did not catch all of the instances of the old name. Our 7.1 servers were a mess. We first built the production server with the development database. Then I cloned this to create the development server attached to the production database. Then we fixed it so production server with production database and development server with development database. We started over for our 7.5 installs. I just finished doing the 7.5 production server with its 7.5 production database. The older 7.1 development server is still running. Because of a bug, you must use the default password for ARAdmin when doing a 7.5 ARS install. We quickly ran into Oracle lockouts. Changing the ARAdmin password to the same value as the development server was using fixed the problem. So somehow I missed at least one reference to the production database in the database. (Fortunately for me, the server name change is a one letter change: 'p' for production becomes 't' for test'. The names are the same length.) Does anyone have a list of where to look so I am sure I get all of the instances found in the Oracle database? Thank you, Thorin _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Moving databases and switching server names within
Good afternoon: I need to copy a fully loaded Remedy 7.5 server and its database to another machine. Copying and updating the Linux files is easy. I just copy then hunt and replace every instance of the old server's name with the new server name. I thought the Oracle 10g database would be just as easy. (All tablespaces keep the their same name so it is ARSystem everywhere. I will be changing the database server's name.) Last time I brought up Remedy then went to the Admin Console and updated the e-mail engine. I am hesitant to do this because this did not catch all of the instances of the old name. Our 7.1 servers were a mess. We first built the production server with the development database. Then I cloned this to create the development server attached to the production database. Then we fixed it so production server with production database and development server with development database. We started over for our 7.5 installs. I just finished doing the 7.5 production server with its 7.5 production database. The older 7.1 development server is still running. Because of a bug, you must use the default password for ARAdmin when doing a 7.5 ARS install. We quickly ran into Oracle lockouts. Changing the ARAdmin password to the same value as the development server was using fixed the problem. So somehow I missed at least one reference to the production database in the database. (Fortunately for me, the server name change is a one letter change: 'p' for production becomes 't' for test'. The names are the same length.) Does anyone have a list of where to look so I am sure I get all of the instances found in the Oracle database? Thank you, Thorin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Location of WWRUG09
Good morning: Does anyone know the name of the hotel hosting the WWRUG09 in Las Vegas? Thorin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Macros in 2009 (was What would $--1$ relate to?)
Dear Carey: I agree with you that all Macro actions can now be done with Active Links. When we find an old Active Link using a Macro we automatically upgrade it. But the Windows User Tool has a macro drop-down list with about 150 active entries. They are heavily used to prompt and then generate our reports. These macros would be difficult to eliminate without creating a 'macro page'. Plus our user community maintain their own macros. (They do this by replacing the old one. Any editing of a macro is reserved for the true Remedy Administrators.) We do not encourage creation of new macros but do not have the time to implement their reports as Active Links. (And they are happier tweaking their own reports and search paths. Many of these power users have access to Crystal Reports developer.) So macros are alive and maintained in our environment. Thorin Marty We Energies Milwaukee, WI -Original Message- From: Carey Matthew Black [mailto:black@gmail.com] Sent: Sunday, May 10, 2009 6:47 PM Subject: Re: What would $--1$ relate to? Thorin, I understand that Macros continue to work. ( Well, as far as I can tell.) But just for the record: AdvancedGuide-630.pdf , page 250 Macros stopped being supported in the AR System 5.x release. You can view reports created using run macro report actions with releases prior to AR System 5.x in Remedy User, or on the Web, by converting them to an equivalent active link. And since v6.3 is now unsupported. Well, that clearly puts Macros on the shelf for me. Note: I still use them too. :) But if the vendor can not support them, then neither can I. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Sun, May 10, 2009 at 3:13 PM, Marty.Thorin thorin.ma...@we-energies.com wrote: I do not have a problem with macros in 2009. At We Energies we do not use the MidTier to directly support our users. All users use the Windows User Tool. We were using macros when I got here in 1999. We are still using macros and all users have been upgraded to the 7.1 user tool. 7.5 is being implemented. We have not had a problem yet. Our issues all relate to reports. We use Crystal Reports 9 reports with the 7.1 Patch 2 user tool (Crystal Reports IX) and a Remedy 6.3 report server (CR 9). Now that is interesting. Thorin -Original Message- From: Carey Matthew Black [mailto:black@gmail.com] Sent: Friday, May 08, 2009 3:57 PM Subject: Re: What would $--1$ relate to? Robert, I would not use it. ($--1$) Macros are technically not supported since version ARS 5. The idea that they records $NULL$ as bla...bla...bla is not a detail that I want to deal with anymore. :) The fact that they still work in the v7.5 User Tool appears to be... well... almost unexplainable. However I would use the keyword of $ NULL $ as necessary. I know that is vague, but I am not trying to be flippant or anything. It is just hard to explain the type of situation you would use a screw driver without saying something like When I need to do something with a screw. I have almost totally given up on Macros. I keep waiting for Macros v2.0 to happen, but that has yet to show itself. :) Maybe in v8.0? (or v8.5... or v9.0?) If I could only figure out why some of my Open Window actions (to run reports) seem to quietly fail for some forms and/or qualifications... maybe I could replace all of the functionality of Macros with custom workflow. G (Still stuck in v6.3 land.) -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: What would $--1$ relate to?
I do not have a problem with macros in 2009. At We Energies we do not use the MidTier to directly support our users. All users use the Windows User Tool. We were using macros when I got here in 1999. We are still using macros and all users have been upgraded to the 7.1 user tool. 7.5 is being implemented. We have not had a problem yet. Our issues all relate to reports. We use Crystal Reports 9 reports with the 7.1 Patch 2 user tool (Crystal Reports IX) and a Remedy 6.3 report server (CR 9). Now that is interesting. Thorin -Original Message- From: Carey Matthew Black [mailto:black@gmail.com] Sent: Friday, May 08, 2009 3:57 PM Subject: Re: What would $--1$ relate to? Robert, I would not use it. ($--1$) Macros are technically not supported since version ARS 5. The idea that they records $NULL$ as bla...bla...bla is not a detail that I want to deal with anymore. :) The fact that they still work in the v7.5 User Tool appears to be... well... almost unexplainable. However I would use the keyword of $ NULL $ as necessary. I know that is vague, but I am not trying to be flippant or anything. It is just hard to explain the type of situation you would use a screw driver without saying something like When I need to do something with a screw. I have almost totally given up on Macros. I keep waiting for Macros v2.0 to happen, but that has yet to show itself. :) Maybe in v8.0? (or v8.5... or v9.0?) If I could only figure out why some of my Open Window actions (to run reports) seem to quietly fail for some forms and/or qualifications... maybe I could replace all of the functionality of Macros with custom workflow. G (Still stuck in v6.3 land.) -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Fri, May 8, 2009 at 3:23 PM, Robert Halstead badbee...@gmail.com wrote: ** Just out of curiosity, in what type of situation would you use $--1$? On Thu, May 7, 2009 at 7:35 AM, Carey Matthew Black black@gmail.com wrote: All, FWIW: The full set for any specific version of ARS can be found by looking that the C API header file: ar.h for the values that look like AR_KEYWORD_*. Example: taken from the v6.3 ar.h file: /* an additional AR_KEYWORD_NULL concept is mapped to AR_DATA_TYPE_NULL */ /* codes for keywords supported */ #define AR_KEYWORD_DEFAULT 0 /* admin defined default for the field */ #define AR_KEYWORD_USER 1 /* login name of the current user */ #define AR_KEYWORD_TIMESTAMP 2 /* current date/time */ #define AR_KEYWORD_TIME_ONLY 3 /* current time (date defaults to */ /* today) */ #define AR_KEYWORD_DATE_ONLY 4 /* current date (time defaults to */ ... snip ... #define AR_KEYWORD_GROUPIDS 40 /* group ids for groups current user */ /* is a member of */ #define AR_KEYWORD_NO 41 /* no more keywords !! Returns NO */ #define AR_MAX_KEYWORD_USED 41 /* set to code for highest keyword */ -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. 2009/5/7 Brian Bishop brian.bis...@goldstag.demon.co.uk: ** Dave, The value $--1$ is a Remedy keyword conversion that means $NULL$. So in your case it is checking that the fields are NULL. Here is a list of keywords conversions I compiled many years ago which may have been added to since doing it. $-1$ = $USER$ $-2$ = $TIMESTAMP$ $--1$= $NULL$ $-6$ = $SERVER$ $-5$ = $SCHEMA$ $-0$=$DEFAULT$ $-4$=$DATE$ $-14$=$LASTCOUNT$ $-13$=$LASTID$ $-3$-$TIME$ $-7$=$WEEKDAY$ Brian Bishop Goldstag Consultants Ltd tel: +44 (0)7973 746832 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barber, David Sent: 07 May 2009 13:44 To: arslist@ARSLIST.ORG Subject: What would $--1$ relate to? ** Seen on a macro/search - field 1 = $--1$ and also a little later in the same search - field 2 = $--1$ The first field is an assignee, but the second is just a flag. Not exactly obvious what it does at all. Any ideas? Ta Dave This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If
Re: AR Server crashes while copying a form
Dear Zaheer: We had the same issue. We fixed it by turning off the Brie server. A couple of months later we went through the entire list of work for the Brie server. (This is found in forms.) We deleted this work (which was the culprit of the problem), and restarted the Brie server. It has run quietly ever since. Thorin -Original Message- From: Zaheer Malik [mailto:z.ma...@ftel.co.uk] Sent: Thursday, April 16, 2009 3:04 AM Subject: AR Server crashes while copying a form Hi all Remedy server (Version: 6.00.01 Patch 1368) goes down very frequently with ARNOTE 20 (and others), when trying to copy a view from our main helpdesk form then save. Currently the the form has 658 fields and 26 views. ARError log below can any one help or direct me to the possible cause thanks in advance Tue Apr 14 13:56:01 2009 0 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Apr 14 13:56:01 2009 15 Tue Apr 14 13:56:01 2009 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Tue Apr 14 13:56:01 2009 15 Tue Apr 14 13:56:01 2009 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Tue Apr 14 13:56:01 2009 15 Tue Apr 14 13:56:01 2009 Dispatch : AR System Application server terminated when a signal/exception was received by the server (ARAPPNOTE 4500) Tue Apr 14 13:56:01 2009 15 Tue Apr 14 13:56:50 2009 BRIE : Message not in catalog; Message number = 4582 (ARAPPERR 4582) Tue Apr 14 13:56:50 2009 started Wed Feb 18 10:46:47 2009 by pid 9170 Tue Apr 14 13:56:50 2009 BRIE : Invalid session identifier supplied in the control record () ARERR - 161 Tue Apr 14 13:56:50 2009 BRIE : AR System Approval server terminated -- fatal error encountered (ARAPPNOTE 4501) Tue Apr 14 13:56:50 2009 BRIE : Message not in catalog; Message number = 4582 (ARAPPERR 4582) Tue Apr 14 13:56:50 2009 started Wed Feb 18 10:46:47 2009 by pid 9170 Tue Apr 14 13:56:50 2009 BRIE : Invalid session identifier supplied in the control record () ARERR - 161 Tue Apr 14 13:56:50 2009 BRIE : AR System Approval server terminated -- fatal error encountered (ARAPPNOTE 4501) Tue Apr 14 13:56:50 2009 BRIE : Message not in catalog; Message number = 4582 (ARAPPERR 4582) Tue Apr 14 13:56:50 2009 started Wed Feb 18 10:46:47 2009 by pid 9170 Tue Apr 14 13:56:50 2009 BRIE : Invalid session identifier supplied in the control record () ARERR - 161 Tue Apr 14 13:56:50 2009 BRIE : AR System Approval server terminated -- fatal error encountered (ARAPPNOTE 4501) Tue Apr 14 13:56:50 2009 BRIE : Message not in catalog; Message number = 4582 (ARAPPERR 4582) Tue Apr 14 13:56:50 2009 started Wed Feb 18 10:46:47 2009 by pid 9170 Tue Apr 14 13:56:50 2009 BRIE : Invalid session identifier supplied in the control record () ARERR - 161 Tue Apr 14 13:56:50 2009 BRIE : AR System Approval server terminated -- fatal error encountered (ARAPPNOTE 4501) Tue Apr 14 13:56:50 2009 BRIE : Message not in catalog; Message number = 4582 (ARAPPERR 4582) Tue Apr 14 13:56:50 2009 started Wed Feb 18 10:46:47 2009 by pid 9170 Tue Apr 14 13:56:50 2009 BRIE : Invalid session identifier supplied in the control record () ARERR - 161 Tue Apr 14 13:56:50 2009 BRIE : AR System Approval server terminated -- fatal error encountered (ARAPPNOTE 4501) Tue Apr 14 14:03:05 2009 0 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Apr 14 14:03:05 2009 11 Tue Apr 14 14:03:11 2009 Dispatch : Cannot establish a network connection to the AR System server (remedy.z.co.uk : RPC: Miscellaneous tli error - An event requires attentionNo message of desired type) ARERR - 90 Tue Apr 14 14:17:37 2009 0 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Apr 14 14:17:37 2009 11 Tue Apr 14 14:18:12 2009 Dispatch : Cannot establish a network connection to the AR System server (remedy.z.co.uk : RPC: Miscellaneous tli error - An event requires attentionNo message of desired type) ARERR - 90 Tue Apr 14 14:20:00 2009 0 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Apr 14 14:20:00 2009 11 Tue Apr 14 14:33:53 2009 0 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Apr 14 14:33:53 2009 15 Tue Apr 14 14:33:53 2009 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Tue Apr 14 14:33:53 2009 15 Tue Apr 14 14:33:53 2009 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Tue Apr 14 14:33:53 2009 15 Tue Apr 14 14:33:53 2009 Dispatch : AR System Application server terminated when a signal/exception was received by the server
Re: Window User Tool 7.5 and ARS 6.3
Dear Dennis: Thank you for the reply. We rolled out the 7.1 Windows User Tool (WUT) in preparations for going from 6.3 to 7.1. Now management is planning to upgrade our not-yet-released 7.1 system to 7.5. The 7.1 WUT is officially approved for use with 6.3. Our users noticed visual changes with the 7.1 WUT switch. Mostly column widths slightly changed in table fields. Nothing major. Thank you again, Thorin From: Dennis Ruble [mailto:ddru...@rockwellcollins.com] Sent: Monday, April 06, 2009 4:31 PM Subject: Re: Window User Tool 7.5 and ARS 6.3 ** We had tested and piloted 7.5 User Tool with ITSP 4.0 and ARS 6.3(HPUX/Oracle 9.2) with no problems. The only feedback was on some minor visual changes. Dennis Ruble Rockwell Collins Marty.Thorin thorin.ma...@we-energies.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 04/06/2009 04:15 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Window User Tool 7.5 and ARS 6.3 ** Good afternoon: We are in the process of migrating from ARS 6.3 to ARS 7.5. For a short time we will have both systems running. We will be using the 6.3 Admin tool for the 6.5 system and the 7.5 Studio for the 7.5 system. We are worrying about the Windows user tool. We would like to present the users with only one user tool. Has anyone used the 7.5 Windows User Tool with a 6.3 server? Did you have any problems? Thank you for your time, Thorin WUT 7.5 Patch 3 ARS 6.3 Patch 20 on Solaris 10 using Sybase. __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Window User Tool 7.5 and ARS 6.3
Good afternoon: We are in the process of migrating from ARS 6.3 to ARS 7.5. For a short time we will have both systems running. We will be using the 6.3 Admin tool for the 6.5 system and the 7.5 Studio for the 7.5 system. We are worrying about the Windows user tool. We would like to present the users with only one user tool. Has anyone used the 7.5 Windows User Tool with a 6.3 server? Did you have any problems? Thank you for your time, Thorin WUT 7.5 Patch 3 ARS 6.3 Patch 20 on Solaris 10 using Sybase. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
OT: Friday humor
I hear a variation on this a few years ago... Contractor's creed: If you can not Blind them with Brilliance, Dazzle them with Diligence, Baffle them with BS, then Bury them in Binders! Thorin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Remedy ODBC Drivers and 7.1
Dear ??? Attached is the ODBC of my install document for the 7.01.00 Patch 5 user tool. I have had your error. I resolved it by fixing the ODBC setup. List: Do we have a place to put documents? This is a 261KB word document. (Almost all of it is screen shots.) I am not very good at uploading / downloading / etc. Thorin -Original Message- From: ccrashh [mailto:ccra...@gmail.com] Sent: Wednesday, February 25, 2009 7:26 AM Subject: Re: Remedy ODBC Drivers and 7.1 No, it isn't a password issue. It's definitely a problem with the way 7.1 creates the User Datasource. They even have a bug filed for it - but are also calling it as designed. Bizzare... On Feb 24, 2:02 pm, Marty.Thorin thorin.ma...@we-energies.com wrote: The first question to ask is What is in your password? I do not care about A through Z, nor 1 through 9: the other characters. Remedy is not picky but Crystal tries to parse passwords. Thorin -Original Message- From: ccrashh [mailto:ccra...@gmail.com] Sent: Tuesday, February 24, 2009 10:37 AM Subject: Remedy ODBC Drivers and 7.1 Has anyone else seen this issue? When trying to run an embedded Crystal Report, we got the error: An error occurred while generating the Crystal Report: 0x80047e48 - Logon Failed (ARERR 1904) What we discovered is that the AR System ODBC driver existed as a Data Source but did not have a server name (that is, if you go to Windows Start/Administrative Tools/Data Sources (ODBC), there should be a line for the AR System ODBC driver...if not, you can add it). Now, if there is no AR System ODBC driver listed as a User Data Source, you can still run the report via a 6.3 User Tool. The User Data Source is created and set properly (i.e. with a server name). However, if you run the report from a 7.1 User tool, it does NOT create the data source. As well, on SOME machines, even if the data source is there but there is no Server Name, you get the error above - on other machines, as long as the Data Source exists, the report runs even if there is no Server Name. We can't figure out why, and what is happening. BMC says that this is as designed - that is, each Client Workstation has to manually set the AR System ODBC driver. Sigh. __ __ ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgPlatinum Sponsor: RMI Solutions ARSlist: Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
MidTier 7.1 Patch 5, JBoss and IIS
Good morning Ladies and Gentlemen:
We have installed our Remedy 7.1.0 Patch 5 MidTier on a 2003
Windows server. We did the default install except for a path change:
from c:\program files\ to e:\programs\. (The rest of the path is the
same.)
The MidTier works great as long as we use JBoss directly at port 8080.
When we drop the 8080 it switches to IIS. It shows the configuration or
normal login screen then fails on login. I am sure the problem is in
the IIS-JBoss connector. We have instructions for Tomcat and IIS and
these worked for ARS 6.3 patch 20. Does anyone have instructions on how
to set up JBoss and IIS?
Thank you,
Thorin
Other, probably irrelevant, information. Everything is ARS 7.1.0 Patch
5. The server is running on a different Intel box with Redhat.
rmdy-papr02.comp.wepco.com{xxremedy}22: uname -a
Linux rmdy-papr02.comp.wepco.com 2.6.9-78.0.8.ELsmp #1 SMP Wed Nov 5
07:14:58 EST 2008 x86_64 x86_64 x86_64 GNU/Linux
The database is Oracle 10g on a third box.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Remedy ODBC Drivers and 7.1
The first question to ask is What is in your password? I do not care about A through Z, nor 1 through 9: the other characters. Remedy is not picky but Crystal tries to parse passwords. Thorin -Original Message- From: ccrashh [mailto:ccra...@gmail.com] Sent: Tuesday, February 24, 2009 10:37 AM Subject: Remedy ODBC Drivers and 7.1 Has anyone else seen this issue? When trying to run an embedded Crystal Report, we got the error: An error occurred while generating the Crystal Report: 0x80047e48 - Logon Failed (ARERR 1904) What we discovered is that the AR System ODBC driver existed as a Data Source but did not have a server name (that is, if you go to Windows Start/Administrative Tools/Data Sources (ODBC), there should be a line for the AR System ODBC driver...if not, you can add it). Now, if there is no AR System ODBC driver listed as a User Data Source, you can still run the report via a 6.3 User Tool. The User Data Source is created and set properly (i.e. with a server name). However, if you run the report from a 7.1 User tool, it does NOT create the data source. As well, on SOME machines, even if the data source is there but there is no Server Name, you get the error above - on other machines, as long as the Data Source exists, the report runs even if there is no Server Name. We can't figure out why, and what is happening. BMC says that this is as designed - that is, each Client Workstation has to manually set the AR System ODBC driver. Sigh. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Date greater than 2037 in remedy
Goof morning: What you are seeing is the side effect of Unix time starting on January 1, 1970 and being counted, by the second, since then. In 2037 the 32 bit timestamp will roll from 0x7FFF to 0x8000.This is the Unix version of the Y2K problem. It has been solved by going to a 64 bit timestamp. MySQL is just being 'the canary in the coal mine'. Thorin From: Rick Cook [mailto:remedyr...@gmail.com] Sent: Monday, February 16, 2009 11:02 PM Subject: Re: Date greater than 2037 in remedy I am guessing that going to a 64 bit operating system will remove that limitation. Rick Sent from my Verizon Wireless BlackBerry From: Aditya C Date: Tue, 17 Feb 2009 10:14:45 +0530 To: arslist@ARSLIST.ORG Subject: Date greater than 2037 in remedy ** Hello, Remedy cannot take date more than year 2037 anything we can do to have it more than this. Regards, Aditya __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Migrating databases
Good morning: I need to move my database from one Oracle server to another. I shall have the DBA copy the arsystem database from the old server to the new. I know I need to change the file ar.conf. Do I need to do anything else? from today's ar.conf Db-name: arsystem Db-user: ARAdmin Dbhome-directory: /usr/oracle/product/10.2.0/client_1 Oracle-Two-Task: ORDDPS1G.WEPCO Db-Character-Set: UTF-8 end ar.conf Statistics: ARS 7.1.0 Patch 5 Oracle 10g This is our first Remedy system using Oracle. All previous systems used Sybase. Thank you for your help. Thorin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: User operations halt while group cache is performed
Be careful switching this to zero. We did this and ran into a memory problem. When in this mode and it needs to recache (such as a group change), it asks for a second copy in memory, does the update, starts running all new actions in the new workspace. Meanwhile the old workspace is kept until all actions are done. Then the old memory is freed. Sounds great, right? Although the AR System freed the memory, Solaris did not. We found ourselves running out of RAM and had to switch modes. We do all major changes to production after hours. These include group changes (but not group membership), form changes, and a bunch of other things. It takes six minutes to recache when our system is idle. I understand ARS 7.1 continues to have this issue. Thorin From: Hall Chad - chahal [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2008 3:29 PM Subject: Re: User operations halt while group cache is performed ** If you set Cache-Mode to 0 then workflow changes, like group and user changes, will recache silently without affecting users. Chad Hall (501) 342-2650 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Robert Halstead Sent: Thursday, October 23, 2008 1:29 PM To: arslist@ARSLIST.ORG Subject: Re: User operations halt while group cache is performed ** Yes, we do have the Cache-Mode set to 1 in our ar.conf file. Also, thanks for the hint on the arthread.log file. I guess when I change the Cache-Mode in our ar.conf i'll also add the Copy-Cache-Logging command in there as well. By setting this value to 0, would workflow changes essentially behave same then? On Thu, Oct 23, 2008 at 12:13 PM, Hall Chad - chahal [EMAIL PROTECTED] wrote: ** Do you have development cache mode enabled? If so, it handles caching differently. With this enabled it will block all users until the change is complete. Its ideal for development environments because the changes happen faster. With this disabled, it creates a copy of the cache and only replaces it once all active API calls have completed so that users aren't impacted. Look in ar.cfg for the Cache-Mode: tag. If its set to 1, then you're in development mode and that's your problem. If its set to 0, or if its not present in your ar.cfg at all, then you're in production mode and your root cause is still a mystery. There was also a 6.3 bug (although I think it was prior to patch 20) that caused users to lock up during a group recache. Although it may have been specific to dynamic group updates only. I can't remember exactly. Chad Hall (501) 342-2650 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Thursday, October 23, 2008 12:36 PM To: arslist@ARSLIST.ORG Subject: Re: User operations halt while group cache is performed We have the same behavior here. You can see the recache operations in arthread.log if you turn on thread logging and add the ar.conf setting Copy-Cache-Logging: T This is from a 7.1 system so I don't know if it applies to 6.x THRD /* Wed Oct 22 2008 15:29:17.5320 */ CopyCache Begin: rpcCallProc=41 user=Remedy Application Service tid=2364 rpcId=2371423 THRD /* Wed Oct 22 2008 15:35:10.0060 */ CopyCache End Because of this we only perform group additions, deletions and modifications off-hours. Tony Worthington Sr. Technical Analyst Kohl's Department Stores N56 W17000 Ridgewood Drive Menomonee Falls, WI 53051 262.703.5911 (phone) [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.Kohls.com http://www.kohls.com/ Robert Halstead [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 10/23/2008 11:40 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject User operations halt while group cache is performed ** Hi guys, Hope you all are having a great day. I have an slight issue and some questions that I hope someone could help shed some light on before I take this to BMC support. Recently, we did some group changes via the group form which caused a group-cache update to be performed on the servers. During this time, the CPU of our first server jumped to 90% and sustained that for at least 3-4 minutes. During this time no user could operate in Remedy at all. All other operations came to a screeching halt while this was being done. Is this the norm for a group-cache update? I thought I read in the docs that when a group-cache update occurs, only the admin thread is used and should not affect other list and fast threads from using the system. There will be some performance impact, but no where does it state the system will come to a halt when it's performed. We have also seen this same behavior when modifying a piece of workflow. Though I can understand this happening when we modify workflow to
Better Friday Humor
Since we do not seem to be able to avoid politics, I offer, again, a better joke. Mary Poppins' Hotel Stay Mary Poppins was driving home late at night in some really bad weather when she decided to spend the night in a motel. After signing in, she asked if the dining room was open, and the clerk apologized, but offered the room service menu, from which Mary Poppins selected the cauliflower cheese. She also decided she would have breakfast in bed in the morning and asked for poached eggs. In the morning the clerk asked how she liked the cauliflower cheese and the poached eggs. Mary Poppins said the cauliflower cheese was good but the eggs weren't much. The clerk apologized but suggested the Mary Poppins might like to leave a comment in their suggestion ledger. After some thought Mary Poppins made an entry and was on her way. Being a curious type, the clerk looked to see what she wrote, and was amused by the entry Supercauliflowercheesebuteggswerequiteatrocious From my joke log, collected on June 6, 2000. Have a great weekend! Thorin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
OT: Better Friday Humor
Knowing how many people cringe at politics, I felt a better joke was needed. A man is driving along a highway and sees a rabbit jump out across the middle of the road. He swerves to avoid hitting it, but unfortunately the rabbit jumps right in front of the car. The driver, a sensitive man as well as an animal lover, pulls over and gets out to see what has become of the rabbit. Much to his dismay, the rabbit is dead. The driver feels so awful that he begins to cry. A beautiful blonde woman driving down the highway sees a man crying on the side of the road and pulls over. She steps out of the car and asks the man what's wrong. I feel terrible, he explains, I accidentally hit this rabbit and killed it. The blonde says, Don't worry. She runs to her car and pulls out a spray can. She walks over to the limp, dead rabbit, bends down, and sprays the contents onto the rabbit. The rabbit jumps up, waves its paw at the two of them and hops off down the road. Ten feet away the rabbit stops, turns around and waves again. He hops down the road another 10 feet, turns and waves, hops another ten feet, turns and waves, and repeats this again and again and again, until he hops out of sight. The man is astonished! He runs over to the woman and demands, What is in that can? What did you spray on that rabbit? The woman turns the can around so that the man can read the label. It says, Hair Spray - Restores life to dead hair, adds permanent wave. From my archives, dated 6 June 2000. Have a great weekend! Thorin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Can't install ARS 7.1 on SLES 10
Dear James: The bug simple. It does a character comparison rather than a number comparison. Compare the strings 5.3 versus 5.10. The fives match. The dots match. Three is bigger than one. Thus you are trying to install a lower version on a higher server. I just replaced the comparison with 1=1 to get it to do what I wanted to happen -- Do it anyway! Under Solaris there is a similar bug in the disk space logic that I also 'fix'. (After manually checking, of course.) Have a great weekend, Thorin From: Joe DeSouza [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2008 7:33 PM Subject: Re: Can't install ARS 7.1 on SLES 10 ** James, Thats because of a bug in the arsystem install script.. open that script and there is a line that declares the minimum solaris version.. change that from 5.10 to one version lower than what you are at, and rerun the install.. For some reason the installation script interpretes 5.10 as 5.1 which is why it quits the install with that error. I had faced a similar error while installing ARS 6.3 on Solars a few years ago and thats exactly what I did to tweak the script and force it to work.. HOWEVER, make sure that the version of Solaris you are on is compatible to ARS 7.1 before performing that tweak.. Hope this helps ya.. Cheers Joe D'Souza Remedy Developer / Consultant, Shyle Networks, New Jersey. - Original Message From: James Pifer [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, September 11, 2008 8:23:44 PM Subject: Can't install ARS 7.1 on SLES 10 I'm trying to install ARS 7.1 on SLES 10. I've tried both SLES 10 SP1 32bit and SLES 10 SP2 64 bit. On both systems I get about the same error: # ./ar_install ./ar_install: line 4595: release-notes-sles-10.2.0.12SUSE: command not found ./ar_install: line 6394: =0: command not found expr: syntax error expr: syntax error Operating System must be or later AR System installation terminated at . It apparently doesn't recognize the OS. I've tried the support site and googling and have yet to find a solution. Anyone no what the problem is? Thanks, James __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Can Remedy run case insenitive?
Dear Matt and list: Thank you for the response. Our uses use the Windows User tool only -- no MidTier logins. In Remedy 5 we used a login script and forced the ID to lower case. When Remedy 6 was rolled out, it was rolled out using a tool named Radia. Due to inexperience and vendor promises, we dropped the login script. Bad choice. Soon we will be implementing Remedy 7 on Oracle. Case insensitivity was thought of as one way to squash the Active Directory case insensitivity / Remedy case sensitivity once and for all. Plus my user community would prefer if the searches were case insensitive. Why is it not recommended to set the flag? How does this effect the indexes? As for the INIT function, I will need to do a refresher. I got my ARS 7 certification 10 months ago and have used exactly 0% of the new knowledge. Could I use the INIT function to lower-case the ID before the login test? The case decision, ultimately, will not be made by me. I will make a recommendation which will greatly influence the powers-that-be. So I appreciate your advice. Thorin From: Matt Worsdell [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2008 4:08 PM Subject: Re: Can Remedy run case insenitive? ** You can set up Case Insensitivity on oracle 10g R2 by adding the following to the ar conf file. Db-Case-Insensitive:T Although this is documented it is not recommended due to the way indexes are utilised. Could you not use the INIT function to test loginid and if not correct display a nice form that tells them to re-login using the correct case? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Marty.Thorin Sent: 04 September 2008 21:44 To: arslist@ARSLIST.ORG Subject: Can Remedy run case insenitive? ** Good afternoon. We will be moving from Remedy 6 on Sybase to Remedy 7 on Oracle. (Database politics -- let us not go there.) We are forever being bit by the case insensitivity of Active Directory. People try to login in upper case. Active directory allows them to do so. But everything in Remedy is case sensitive so they do not get a home page -- they get a blank screen. As all of our account data comes from case-insensitive sources, I was wondering if we could tell the new Oracle database to be case-insensitive. I would like to hear what the group thinks and what the experience has been. Have a nice day, Thorin Marty We Energies Milwaukee, WI __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Can Remedy run case insenitive?
Good afternoon. We will be moving from Remedy 6 on Sybase to Remedy 7 on Oracle. (Database politics -- let us not go there.) We are forever being bit by the case insensitivity of Active Directory. People try to login in upper case. Active directory allows them to do so. But everything in Remedy is case sensitive so they do not get a home page -- they get a blank screen. As all of our account data comes from case-insensitive sources, I was wondering if we could tell the new Oracle database to be case-insensitive. I would like to hear what the group thinks and what the experience has been. Have a nice day, Thorin Marty We Energies Milwaukee, WI ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Recomended page size for ARS 6.3 with CMDB 2.0, HD 6.0.
Good afternoon: We had a Sybase consultant who expressed shock that we were using 4K pages in our Sybase database. He expected 16K. The Remedy documentation says 4K is the minimum page size. Does anyone have any recommendations / experiences that would indicate what is the correct page size? Thanks! Thorin Marty We Energies, Milwaukee, WI ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
