AW: EXTERNAL: Application-Query-Delete-Entry

[Conny Martin]

Dave,

it’s normal behavior of an oracle database to not release any space if you 
delete records. It’s also not an issue specific to LOBs. But there are ddl 
commands to reorganize the table online to reclaim “wasted” space.

alter table T63 enable row movement;
alter table T63 shrink space cascade;

and don’t forget to rebuild the indexes as well.

Regards

Conny

Von: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] Im Auftrag von Dave Barber
Gesendet: Donnerstag, 1. September 2016 15:39
An: arslist@ARSLIST.ORG
Betreff: Re: EXTERNAL: Application-Query-Delete-Entry

**
All,
Many thanks - I'm going with the archive/delete from source option.  The 
messages form is already down to a "manageable" number of records (2 million, 
we're sending about 10,000 messages per day!)
Interesting aside - this hasn't actually freed up any space on the database.  
Its apparently something in the nature of LOBs (which are used in the To/Cc/Bcc 
fields) which means that Oracle doesn't release the space as you may expect.  
One of our DBAs has some thoughts on resolving this that involves creating a 
copy of T63, copy records over, then replace T63 with the copy.  That leaves me 
feeling a little uncomfortable with the H/B tables and database integrity.
Regards
Dave

On 31 August 2016 at 17:22, Brittain, Mark 
> wrote:
**
Sort of like Todd says, I had a similar situation but with a much larger form 
in 6.3 using archive, delete from source. What I did was a little bit each 
night changing the archive query each morning sort of like this

‘Create Date’ < $DATE$ - (60 * 60 *24 * 720)
‘Create Date’ < $DATE$ - (60 * 60 *24 * 713)
‘Create Date’ < $DATE$ - (60 * 60 *24 * 706)

Took me about a month to get where I wanted to be. Slow but if you’re worried 
about performance, that works

Mark

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Dave 
Barber
Sent: Wednesday, August 31, 2016 2:55 AM

To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Application-Query-Delete-Entry

**
Todd,
Regardless of the method used (archiving, or application-query-delete-entry), I 
realised this could be a problem - I've already (manually) cleared down the 
email messages form.
Awkward though, as I had set it to run overnight and delete a small data set 
(should have only been 21 records), and it doesn't appear to have done anything.
Regards
Dave

On 30 August 2016 at 16:39, Arner, Todd 
> wrote:
**
Be cautious when adding the archiving, especially if the first night it runs if 
it will be trying to archive a large number of records.  We ran into some major 
performance issues.  We ended up slow adjusting the archive criteria so that a 
smaller amount of records were archived each night until the back log was 
processed.

Todd Arner
Great Lakes

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Dave 
Barber
Sent: Tuesday, August 30, 2016 10:29 AM
To: arslist@ARSLIST.ORG
Subject: Re: EXTERNAL: Application-Query-Delete-Entry

**
I had completely forgotten about the archiving options (my bad, etc. etc)
Much appreciated, I've put that in place to run overnight, with luck it should 
work!

On 30 August 2016 at 15:11, Reiser, John J 
> wrote:
**
Dave,
Have you tried using the Archive function to just “Delete from Source”?
It sets up just like an escalation with a timing cycle to run it and a 
Qualification to select which data to delete.

Thank you,
---
John J. Reiser
Building 760-J202
Remedy AR System Developer
Senior Software Development Analyst
Lockheed Martin - MST Moorestown Region
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Dave 
Barber
Sent: Tuesday, August 30, 2016 9:49 AM
To: arslist@ARSLIST.ORG
Subject: EXTERNAL: Application-Query-Delete-Entry

**
All,
I'm trying to figure out the syntax required for Application-Query-Delete-Entry 
 (Server is running ARS 7.5)
Trying to keep an "archive" of emails - we have a requirement to keep 6 months 
worth in the system (audit trail, proof of sending, etc.), and the form was 
actually turning out to be the largest on the system (over 7 million records - 
I manually deleted the older ones via the user tool, that is not fun!).
In an active link, just trying a simple
 $PROCESS$ @@:Application-Query-Delete-Entry "AR System Email Messages" '3' < 
($TIMESTAMP$ - (86400 * 75))
The 75 is related to a test system and the data that is on it (would obviously 
be changed on live).  The query itself is 

AW: Filter Table Refresh differ if Admin User...

[Conny Martin]

Hi,

Some years ago I had a similar problem in ARS 7.1. The answer was: works as 
designed and they created a defect to correct the manuals. But I never 
verified if BMC modified their manuals.

SW00301166  -- Doc bug: Server Side Table loop requires access permission on 
supporting table form REF ARS 7.1 Worfklow Objects Pg15 

KR Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] Im Auftrag von Misi Mladoniczky
Gesendet: Mittwoch, 20. Juni 2012 19:51
An: arslist@ARSLIST.ORG
Betreff: Re: Filter Table Refresh differ if Admin User...

Hi,

I missed this feature too... I usually read the release notes quite thoroughly, 
but I did not see this. Which version was it introduced?

RRR|Log does not strip out anything from the logged lines, but in this
case I checked the setting for Data Access - Get Data As, and it is set to 
System, not User. So it seems like this is actually a bug then...

AR System 7.6.04 SP2.

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.

 Fred,
 That is an interesting feature I didn't know existed

 Misi,
 A few choice notes from the workflow guide, page 303

 Workflow Functions
 In addition to the Set Fields, Push Fields, and Call Guide actions, 
 setting Get Data As to User affects the workflow functions COLCOUNT, 
 COLAVG, COLMIN, and COLMAX.
 These functions operate over the columns in a table field. When 
 performed in a guide that was called by a filter with the Get Data As 
 User set, the entries and fields used to populate columns in the table 
 field are limited to those visible to the calling user.

 And almost more importantly

 Filters with Get Data As set to User are identified in the filter log 
 file by the string with data retrieval as user userName.

 So...being all we have access to is your RRR|Log parsed 
 portionsdid this text display in the filter log?  Is the filter in 
 question set with this restriction?

 If your answer to either of those questions is No...then we have a bug 
 somewhere...I don't recognize 'MOB'...is that a custom application?

 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
 Sent: Wednesday, June 20, 2012 6:54 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: Filter Table Refresh differ if Admin User...

 Actually if you look at a filter in Developer Studio 7.6.04, in the 
 Properties you will see

 + Change History
 - Data Access
   Get Data As
 + Full Text Search
 + Help Text
 + Integration Workflow

 And the choices for Data Access are:  System  |  User

 Fred

 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
 Sent: Wednesday, June 20, 2012 3:52 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: Filter Table Refresh differ if Admin User...

 Hi,

 It turned out that if I changed the permission on the table and 
 underlying join form, the table got refreshed.

 This definitely seems like a BUG, as filters should ALWAYS run with 
 administrator privileges...

 Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 
 2011)

 Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
 * RRR|License - Not enough Remedy licenses? Save money by optimizing.
 * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
 Find these products, and many free tools and utilities, at http://rrr.se.

 Hi LJ,

 Thank you for the input.

 In this specific case, the table is never refreshed.

 And I am not doing a table loop, just a Set-Fields with a COLSUM().

 And the really strange thing is that the behaviour differ depending 
 on the users permission groups...

 I agree that there is need for more control over the filter tables!

 Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP
 2011)

 Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
 * RRR|License - Not enough Remedy licenses? Save money by optimizing.
 * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy 
 logs.
 Find these products, and many free tools and utilities, at 
 http://rrr.se.

 Misi,
 I can't speak directly to your situation, but I have seen in the 
 past that server table loops don't necessarily refresh the table 
 every time you do something with them...I have done loops before 
 where the table has a dynamic qualification, and you set the field 
 that makes it dynamic, then utilize the table...then within the same 
 transaction, you change that qual, and try again and it doesn't 
 necessarily refresh the table even though the qual, and thus the 
 

AW: Java API connection pool question..

[Conny Martin]

Dee,

IHMO the easiest way to avoid flushing connections on the firewall is to set 
the tcp keepalive timeout to a value shorter than 60 minutes.

If your arserver is running on a linux box just do 

echo 3500 /proc/sys/net/ipv4/tcp_keepalive_time

as root and restart your arserver. 

HTH

KR Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] Im Auftrag von Dee
Gesendet: Donnerstag, 12. April 2012 17:13
An: arslist@ARSLIST.ORG
Betreff: Re: Java API connection pool question..

Axton,

From our network admins, these points where made, in response to your post.

The connections from the midtier (Websphere) server to the ARserver are 
persistent TCP connections.  These connections are not stateless.  
Our firewall is doing stateful inspection on these connections.
The firewall security policy allows all of these connections to be started.
Connections are flushed from the firewall state tables after 1 hour of 
INACTIVITY.  Not active connections are ever flushed.
After an inactive connection has been flushed, any further packets (in either 
direction) are dropped by the firewall.  No RST packets are sent to the session 
endpoints at the time of the flush or at the time of the packet drops.  A 
firewall log entry is created for each of these out-of-state
packet drops.
After attempting to re-use one of the inactive/flushed connections, the 
application's session endpoint make take several minutes doing TCP retries of 
their dropped packets before they give up and start a new connection.

We want to know how we can configure the AR product to either: 
1) keep these connections active by implementing the keepalive protocol or
2) close the connections when the immediate unit of work is finished.




--
View this message in context: 
http://ars-action-request-system.1093659.n2.nabble.com/Java-API-connection-pool-question-tp7454090p7459721.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are

AW: DSO Issue

[Conny Martin]

Sagar,

DIST** WARNING ** Access problem trying to get target form definition, 
retry later...  (Mon Mar 26 2012 06:18:18.3582)

For me it looks like some communication problem between source and target 
Server.

Try to test the communication with rpcinfo.

rpcinfo -t Y.bst.com 390600

The output should be something like this
program 390600 version 1 ready and waiting
program 390600 version 2 ready and waiting
program 390600 version 3 ready and waiting
program 390600 version 4 ready and waiting
program 390600 version 5 ready and waiting
program 390600 version 6 ready and waiting
program 390600 version 7 ready and waiting
program 390600 version 8 ready and waiting
program 390600 version 9 ready and waiting
program 390600 version 10 ready and waiting
program 390600 version 11 ready and waiting
program 390600 version 12 ready and waiting
program 390600 version 13 ready and waiting

KR Conny



-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] Im Auftrag von vidyasagar kommu
Gesendet: Montag, 26. März 2012 13:43
An: arslist@ARSLIST.ORG
Betreff: DSO Issue

Hi All,

I want to send one form data in to another form two different AR servers when i 
am submiting form of source server the same date is pushed to another server 
with specified form in That i have created one DSO and fileter i have created 
in the filter i am calling my DSO The data is not pushing to Target server .

Could you please guide me .

I have checked DSO Log ...please find the below

Distributed Server Trace Log -- ON  (Mon Mar 26 2012 06:17:48.1407) DIST 
Flushing cached pending list -- Will reload  (Mon Mar 26 2012
06:17:48.1409)
DIST Get a list of items to process (stage 0)  (Mon Mar 26 2012 06:17:48.1410)
DISTHandleDSOs: lastEntryId =
DISTGetThreadPendingList: lastEntryId =
DISTGetThreadPendingList: Error resetting lastEntryId.
DIST8 new item(s) found
DIST Processing item number 0  (Mon Mar 26 2012 06:17:48.2503)
DISTPending Type -- 1
DISTSource Form -- MarchCTTSPush Data
DISTSource ID -- 013
DISTPending Other --
DIST  -m MarchXtoY -p X-Y
DISTGet source schema definition (stage 2)
DIST   Using EXISTING cache definition for MarchXPush Data (X.bst.com)
DISTGet entry details (stage 3)
DISTGet mapping details (stage 4)
DIST   Filter-specified mapping -- MarchXtoY
DIST   Mapping MarchXtoY not in the cache or expired
DISTMapping name -- MarchXtoY
DISTTarget form -- MarchRecieveData
DISTTarget server -- Y.bst.com
DISTPerform final checks (stage 5)
DISTGet target schema definition (stage 6)
DIST** WARNING ** Access problem trying to get target form
definition, retry later...  (Mon Mar 26 2012 06:18:18.3582)
DISTSleeping for 43:42 minutes  (Mon Mar 26 2012 06:18:18.3586)



Thanks
Sagar

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 
www.wwrug12.com ARSList: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are

AW: 32bit Vs.64bit JVM performance

[Conny Martin]

we had the same issue on linux. Arserverd died when a non existent login was 
used. The behaviour is also reproducible with driver. After upgrading to SP2 
the issue has gone.

Kind Regards Conny

Von: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] Im Auftrag von strauss
Gesendet: Mittwoch, 8. Februar 2012 19:21
An: arslist@ARSLIST.ORG
Betreff: Re: 32bit Vs.64bit JVM performance

**
The three mid-tiers we deployed into production in August and September last 
year are all 64-bit:

Windows Server 2003 R2 Enterprise x64 Sp2, and Windows Server 2003 Enterprise 
x64 Sp2
JDK 1.6.24 x64   (32-bit is also installed)
Tomcat 6.0.32 x64 full install including Service Startup, Native
(runs under a domain account with FULL permissions to the Tomcat 6.0, OpenSSL, 
and BMC Software directories)
Mid-Tier 7.6.04 SP1_MDB_08032011+ESC23674+403423+398559  x64  (specified 64-bit 
JRE during installation)
All are set to use SSL

Added to Java Options for Tomcat:
-Xincgc
-XX:PermSize=256m
-XX:MaxPermSize=256m
-XX:+UseConcMarkSweepGC
//this enables the low pause concurrent garbage collector
-XX:+UseCompressedOops
//improves performance of 64 bit JDK; Must be on at least 1.6 
patch 006 of the JDK to use

Initial memory pool = 1536
Maximum memory pool = 1536
Shutdown = 240

-In tomcat root/conf/server.xml change the connector 
element used for the HTTP and HTTPS SSL connections to Tomcat, add these 
attributes:

connectionTimeout=9
maxKeepAliveRequests=-1
acceptCount=100
maxThreads=500

We have not seen any performance or load problems, and of course all of our 
support staff are now using these mid-tiers (one primarily) for their access to 
the ITSM apps.  The ONLY problem that we have had with these mid-tiers is with 
the ehcache crap that they now use for pre-fetch and caching.  These servers 
cache all logins, to include mis-typed ones, incorrect case (capitalized first 
letter), ones that do not exist at all, and ones that have been deprecated when 
support staff are removed.  On a ,id-tier startup, or when they feel the need 
to re-fetch/re-cache, they throw all of these account names (without passwords) 
at the AR Server, which passes them on to the AREA plugin which tries to 
resolve them.  Or something like that.  The result is occasionally a crash of 
the AREA plugin (simply stops authenticating - requires killing the 
arplugin.exe process to force a restart), but more often it is a spate of 
thread deaths on the AR Server, during which time the mid-tier becomes 
unresponsive and drops sessions. BMC Support has been useless on this one, 
which we reported as early as September 2011 - after going into production in 
late August.  The most recent thread crashes are as recent as 2 Feb, so the fun 
continues.  They look like this in the arerror.log (server/user/IP masked) - 
these ones definitely triggered by restarting the mid-tier tomcat instance:

Mon Jan 16 02:05:04 2012: AR System server terminated when a signal/exception 
was received by the server (ARNOTE  20)

   Thread Id: 1240
   Version: 7.6.04 SP1 HotFix 01 201107051610 Jul  5 2011 17:17:48
   ServerName: xx
   Database: SQL -- SQL Server
   Hardware: x86_64
   OS: Windows Server 2003
   RPC Id: 16071
   RPC Call: 36 (GSI)
   RPC Queue: 390620
   Client: User xxx from Mid-tier (protocol 18) at IP address 
999.999.999.999
   Logging On: User
   Code: c005
   Operation: read
   Access Addr: 
   Stack Begin:
   Stack End
Mon Jan 16 02:05:03 2012  390620 : AR System server terminated when a 
signal/exception was received by the server (ARNOTE 20)
Mon Jan 16 02:05:03 2012 0xc005
Mon Jan 16 02:05:03 2012  390620 : AR System server terminated - fatal error 
occurred in ARSERVER (ARNOTE 21)


No, I don't attribute these problems to going 64-bit; I blame 7.6.04.01+ and 
ehcache.  We were seeing similar thread deaths from when people tried to log in 
to our Kinetic Request web using an iCrap or other mobile device - they 
capitalize your login name - but we stopped that by adding some javascript to 
the login page to force everything to lower case.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing  IT Center
http://itsm.unt.edu/
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew C Goodall
Sent: Tuesday, January 17, 2012 9:36 AM
To: arslist@ARSLIST.ORG
Subject: 32bit Vs.64bit JVM performance

**
I'm soliciting feedback regarding experience observed in the field regarding 
migrating from 32bit JVM to 64bit processes - is it worth it?

So we'll be upgrading from 7.5 32bit to 7.6.04 64bit (on Windows 2008), our 
major objective is to drastically improve client performance.

Due to BMC RD response, BMC PS is recommending we 

Floating users get a floating write token on read operations

[Conny Martin]

Hello All,

I searched the list but found no answer.

I have an issue where floating users are granted a write token on read 
operations. I verified this with driver to eliminate workflow that could 
trigger this behaviour. On the first GetListEntry the user is granted a write 
token, although this is not neccessary in my opinion. So every user who logs 
into the system only to check if there are tickets assigned to him is blocking 
a floating write token for at least one hour.

Has anyone else experienced this behaviour?

Kind Regards Conny


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

AW: ARS 7.5p007 on SLES11

[Conny Martin]

Yes indeed, there is something strange.

I've got the same issue. But I never realized the problem because I always 
connect to arsystem using a tcp port regardless of the 
Register-With-Portmapper setting.

I digged through the sourcecode of rpcbind and found the problem. If a process 
is trying to register with portmapper the ip and port information is carried in 
a string. If the process trys to register a programm with tcpport 3334 the 
string is 0.0.0.0.6.13 

0.0.0.0 is for the ip address
6.13 is for the port

13 - 0x0d
6 - 0x06
0x0d06 - 3334

The algo for computing the port from this string swapped the two bytes and this 
leads to registering the wrong port.

#ifdef PORTMAP
/*
 * Extract port from universal TCP/UDP address
 */
int
uaddr2port(char *uaddr, u_long *p_port)
{
char *pt1, *pt2;
int rc = -1;

if ((pt1 = strrchr(uaddr, '.')) != NULL) {
*pt1++ = 0;
if ((pt2 = strrchr(uaddr, '.')) != NULL) {
*pt2++ = 0;
*p_port = atoi(pt1) * 256 + atoi(pt2); //Here I 
exchanged pt1 with pt2 and everything is working
rc = 0;
*--pt2 = '.';
}
*--pt1 = '.';
}
return rc;
}

Kind Regards Conny



-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] Im Auftrag von michep
Gesendet: Mittwoch, 9. März 2011 14:25
An: arslist@ARSLIST.ORG
Betreff: Re: ARS 7.5p007 on SLES11

OMG! Its getting more and more interesting with every step!

Ok, thanx to Conny (-i parameter to rpcbind service) now im able to start ARS 
server with Register-With-Portmapper:T option without errors. BUT!!!
Now trying to connect to ARS server with RUT without specified TCP port I 
receive error:

ARERR [90] Cannot establish a network connection to the AR System server : 
msk-m1-rem001 : RPC: Miscellaneous tli error - System error (Connection refused)

Ok, thanx to Axton, I stop rpcbind service and started it in debug
mode: rpcbind -id, and able to see whats happen inside.

Restart ARS server, and see that a lot of registration commands
(RPCB_SET) was processed and succeeded.

Now, connecting with RUT without specified TCP and see rpc command in rpcbind 
log:

PMAP_GETPORT req for (390620, 18, tcp) from
192.168.170.10.250.247 :port = 47240

So, comment was proessed and port number was returned - 47240.

WTH!? I didn't remove port options in ar.conf, now its looks like:

Register-With-Portmapper: T
TCD-Specific-Port: 35000
Plugin-Port: 36000

and netstat shows that ports 35000 and 36000 are in LISTEN state, so why 
rpcbind returned wrong port number?

Next, comment out port options:

Register-With-Portmapper: T
#TCD-Specific-Port: 35000
#Plugin-Port: 36000

and restart ARS server, truing to connect with RUT without specified TCP port - 
error again, rpcbind returns:

PMAP_GETPORT req for (390620, 18, tcp) from
192.168.170.10.223.199 :port = 18773

BUT! ARS server is listening on different port:

# lsof +M -p 13564|grep IPv4
...
arserverd 13564 root9u  IPv4 1994493  0t0 TCP *:21833
(LISTEN)
...

Whats goning on?!

And even one more finding - in this configuration arplugin reports segfault 
every one and a half minutes:

Mar  9 16:02:10 msk-m1-rem001 kernel: [2598443.587831]
arplugin[13909]: segfault at 1c ip f6a33cc1 sp
f42fae28 error 4 in libc-2.11.1.so[f69c2000+15b000]

I call support ...

On 6 мар, 12:48, Conny Martin conny.mar...@t-systems.com wrote:
 so go to /etc/sysconfig/rpcbind and add this line

 RPCBIND_OPTIONS=-i

 then restart rpcbind (/etc/init.d/rpcbind restart) you should now see 
 the -i option in ps output If you start your arserver it should now be 
 able to register with portmapper


On 6 мар, 02:33, Axton axton.gr...@gmail.com wrote:
 Try starting rpcbind in debug mode to see what it reports.  Look in 
 /var/log/messages to see if rpcbind is reporting anything there already.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 
www.wwrug.com ARSList: Where the Answers Are

AW: ARS 7.5p007 on SLES11

[Conny Martin]

I think you're using something like msk-m1-rem001 as Server-Name in ar.conf. 
This name will resolve to 192.168.65.199. arserverd trys to connect to rpcbind 
using this IP and get's refused because rpcbind allows only calls to SET or 
UNSET from localhost.

This is from the manpage of rpcbind

 -i  ``Insecure'' mode.  Allow calls to SET and UNSET from any host.
 Normally rpcbind accepts these requests only from the loopback
 interface for security reasons.  This change is necessary for
 programs that were compiled with earlier versions of the rpc
 library and do not make those requests using the loopback inter-
 face. 

so go to /etc/sysconfig/rpcbind and add this line

RPCBIND_OPTIONS=-i

then restart rpcbind (/etc/init.d/rpcbind restart)
you should now see the -i option in ps output
If you start your arserver it should now be able to register with portmapper

HTH

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] Im Auftrag von michep
Gesendet: Samstag, 5. März 2011 10:47
An: arslist@ARSLIST.ORG
Betreff: Re: ARS 7.5p007 on SLES11

Hello Conny. Thanx for reply.

Yes, you know, I found something strange in /etc/hosts:

127.0.0.1   msk-m1-rem001.x5.ru localhost
127.0.0.2   msk-m1-rem001.x5.ru msk-m1-rem001
192.168.65.199  msk-m1-rem001.x5.ru msk-m1-rem001

I fixed it to:

127.0.0.1   localhost
#127.0.0.2   msk-m1-rem001.x5.ru msk-m1-rem001
192.168.65.199  msk-m1-rem001.x5.ru msk-m1-rem001

but it does not help. Still the same errors on startup with portmapper 
registering enabled.

On 4 мар, 22:13, Conny Martin conny.mar...@t-systems.com wrote:
 I installed a AR-Server 7.5 on Opensuse 11 and afaik this is the base for the 
 sles versions. I had the same problem. In my case the problem was localhost 
 pointing to 127.0.0.2 instead of 127.0.1 Portmapper is accepting registration 
 requests only from local adresses and treated 127.0.0.2 not as a local 
 adress.

 So have a look at your /etc/hosts file and check which ip address is mapped 
 to localhost.

 HTH

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 
www.wwrug.com ARSList: Where the Answers Are

AW: ARS 7.5p007 on SLES11

[Conny Martin]

I installed a AR-Server 7.5 on Opensuse 11 and afaik this is the base for the 
sles versions. I had the same problem. In my case the problem was localhost 
pointing to 127.0.0.2 instead of 127.0.1 Portmapper is accepting registration 
requests only from local adresses and treated 127.0.0.2 not as a local adress.

So have a look at your /etc/hosts file and check which ip address is mapped to 
localhost. 

HTH

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] Im Auftrag von michep
Gesendet: Freitag, 4. März 2011 12:34
An: arslist@ARSLIST.ORG
Betreff: ARS 7.5p007 on SLES11

Hello listers.

Is here anyone who have real experience of installing ARS75 server on SUSE11? I 
stuck in a problem - arserver cant register itself in portmapper.

Starting arsystem prints

AR System Server unable to create (390600, 0) for TCP.
ARMonitor child process (pid:17889) died with 256.
./arserverd

and

unable to create (390695, 0) for TCP
ARMonitor child process (pid:17888) died with 256.
./arplugin

And yes, rpcbind service is up and running.

If I switch to fixed TCP ports without portmapping - everything is fine.

Any comments?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 
www.wwrug.com ARSList: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

AW: How to configure the Java Plugin to the ARServer

[Conny Martin]

to use a java based plugin you have to create a Server-Plugin-Alias in ar.conf. 
By default the arserver trys to connect to the c-plugin-server. 

The line in ar.conf should look like this:

Server-Plugin-Alias: EXAMPLE.ARDBC.WHATEVER EXAMPLE.ARDBC.WHATEVER 
localhost:java-plugin-tcp-port

HTH

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] Im Auftrag von gok's
Gesendet: Freitag, 4. März 2011 16:46
An: arslist@ARSLIST.ORG
Betreff: How to configure the Java Plugin to the ARServer

I have worked on creating the plugin when I run the Java plugin it is 
connecting to the external database and showing the arschema , arcontainer 
. I am failing to configure it to the ARServer even though I added the
C: location path in ar.cfg ...I have checked the plugin log's it is not 
showing up there do I need to create a record in the configuration ARDBC form 
in the User tool can some one give me some help ..

Envi: ARSystem 7.5 patch4
Database : SQL 2008 sp2

Thanks

--
View this message in context: 
http://old.nabble.com/How-to-configure-the-Java-Plugin-to-the-ARServer-tp31068684p31068684.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 
www.wwrug.com ARSList: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

AW: ARInside 3.0.2 released

[Conny Martin]

good job!!!

It has become really fast on documenting large installations.

Kind Regards Conny


Von: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] Im Auftrag von Luthgers, John
Gesendet: Dienstag, 1. März 2011 12:32
An: arslist@ARSLIST.ORG
Betreff: ARInside 3.0.2 released

**
Hello all,

Do you know ARInside? I hope so. For those who don't: ARInside is a free 
open-source utility to create a static html documentation of your AR-Server. If 
you need something to quickly browse through your workflow, ARInside might be 
worth a try.

Today I'm pleased to announce the release of ARInside 3.0.2. It has some new 
features, lots of bugfixes and other improvements.

Just to name a few:
- documentation improvements
- 64-bit platform support
- experimental support for Solaris and AIX
- basic ARS 7.6.x support
- huge performance plus on big installations

Please check the What's New page at 
http://arinside.org/wiki/ARInsideWhatsNew302 to learn more about it.

I hope the new version is helpful to some of you. The download is available at 
http://arinside.orghttp://arinside.org/.

As always I'm looking for new ideas or suggestions. You can send me a mail, use 
the arinside-misc-list or open a ticket at http://arinside.org/newticket. Thank 
you.

John


_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

AW: ORACLE Cursor Sharing

[Conny Martin]

Frank,

IMHO this parameter does not have an effect on performance. Somtimes arserverd 
issues an alter session set cursor_sharing = exact for some reason. To reset 
it back to it's desired value you have to specify it in ar.cfg


SQL  TID: 1081108800 RPC ID: 013703 Queue: Fast   Client-RPC: 
390620USER: xxx  /* So Nov 14 2010 08:21:24.2067 
*/INSERT INTO B233C536870999 (C536870999, entryId) VALUES (:x,'W0015085672')
SQL  TID: 1081108800 RPC ID: 013703 Queue: Fast   Client-RPC: 
390620USER: xxx  /* So Nov 14 2010 08:21:24.2068 */Set 
LOB into the above row ...
SQL  TID: 1081108800 RPC ID: 013703 Queue: Fast   Client-RPC: 
390620USER: xxx  /* So Nov 14 2010 08:21:24.2068 */ALTER 
SESSION set CURSOR_SHARING = EXACT
SQL  TID: 1081108800 RPC ID: 013703 Queue: Fast   Client-RPC: 
390620USER: xxx  /* So Nov 14 2010 08:21:24.2070 */OK
SQL  TID: 1081108800 RPC ID: 013703 Queue: Fast   Client-RPC: 
390620USER: xxx  /* So Nov 14 2010 08:21:26.9983 */OK
SQL  TID: 1081108800 RPC ID: 013703 Queue: Fast   Client-RPC: 
390620USER: xxx  /* So Nov 14 2010 08:21:26.9983 */ALTER 
SESSION set CURSOR_SHARING = FORCE
Don't know why, but always when inserting an attachment these alter session 
statements are issued.

Kind Regards Conny


Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Frank Caruso
Gesendet: Montag, 22. November 2010 19:46
An: arslist@ARSLIST.ORG
Betreff: ORACLE Cursor Sharing

** Does anyone know what effect setting the Oracle Cursor Sharing parameter in 
the ar.cfg has on performance?

I understand what cursor sharing is and have it set at the Oracle (database) 
level but want to know why it needs to be set in the ARS server config file.

Thank you,
_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

AW: arcache

[Conny Martin]

Atul,

ommit the -s servername and everything will be fine. Since 7.x arcache is only 
working if you're local to the server

Kind Regards Conny 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Atul Vohra
Gesendet: Mittwoch, 11. August 2010 22:25
An: arslist@ARSLIST.ORG
Betreff: arcache

Hi,

Pre 7.x, I was able to use the following arcache command to create remedy admin 
account (aka Demo):

arcache -Ua -n aaa -p  -e 009 -lw 1 -g1; -s servername

But now on a 7.1 server it is failing with the following message:
Message not in catalog; Message number = 9907 (ARERR 9907)
  -s


It is complaining about -s option. Any help would be appreciated.

Thanks
Atul 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 
www.wwrug.com ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

AW: Curious Advanced Search

[Conny Martin]

Naveen,

The Grouplist is stored internal as a list of groupids separated by a semicolon 
(and sometimes an additional space)

For example to search for all User belonging to group Administror your advanced 
query should look like this

('Group List' like 1;% or 'Group List' like % 1;% or 'Group List' like 
%;1;%)

HTH

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von NNMN
Gesendet: Freitag, 2. Juli 2010 12:31
An: arslist@ARSLIST.ORG
Betreff: Curious Advanced Search

Hi ARSers,

Hi have a pretty silly and curious advanced search issue. This is a Advanced 
Search i am trying on User Form. I am trying to give a search on the basis of 
'Group List'. I have,say 6 groups, Group1 to Group 6.

I want to list out record of users belonging to Group List namely 'Group1', 
'Group2' and 'Group3'

So I gave,
1.'Group List' = (Group1) OR 'Group List' = (Group2) OR 'Group List' = 
(Group3). It doesn't fetch me any record. 
2. I have been trying to search for records which has 'Group1' only also.
But its not giving me any records.
3. Then I tried 'Group List' != (Group1) whihc fetched me all the records.
:S

I am going crazy over here. Can anyone help me.

Thank you

Cheers,
Naveen

-
With Warm Regards,
Naveen
--
View this message in context: 
http://old.nabble.com/Curious-Advanced-Search-tp29054806p29054806.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 
www.wwrug.com ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

AW: ARS 7.1.0 from NON unicode to unicode - oracle from 9.x to 10.x on new machines

[Conny Martin]

Fons,

sorry, but my hack has been proved to work on unix. I've never done this on a 
windows box with MSSQL. The installer for unix-systems is a simple shell 
script where one can see what's going on behind the scenes. The installer for 
windows is more like a black box. Furthermore the database migration from 
nonUnicode to Unicode is a bit more complicated on MSSQL, because you have to 
alter all the (var)char and text columns to their respective n-types.

Sorry

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Fons Bruins
Gesendet: Donnerstag, 1. Juli 2010 16:05
An: arslist@ARSLIST.ORG
Betreff: Re: ARS 7.1.0 from NON unicode to unicode - oracle from 9.x to 10.x on 
new machines

Hi Conny,

Will this hack also work on a MS SQL 2005 DB ?
We are planning a similar Unicode conversion from ARS 7.0.1 to ARS 7.5

Could you share the additional information to me as well ?

Thank you for your help.
Regards,
Fons

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 
www.wwrug.com ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

AW: ARS 7.1.0 from NON unicode to unicode - oracle from 9.x to 10.x on new machines

[Conny Martin]

Antonio,

Simply changing parameters, locale settings etc. won't work. The reason is 
explained in document BMC Remedy Action Request System 7.1.00 Installing on 
page 162. The only supported way to upgrade to Unicode is from 6.3 to 7.x

But you can do a little hack.

In short:

1. UPDATE .control SET dbversion = 21 (21 means ARS 6.3)
2. run arupora (this will update the serialized qualifiers to have the correct 
byte lengths)
3. UPDATE .control SET dbversion = 23

I can provide you additional information if you're not familiar with the 
internals of the upgrade process.

HTH

Kind Regards Conny


Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Antonio Monizza
Gesendet: Dienstag, 29. Juni 2010 15:05
An: arslist@ARSLIST.ORG
Betreff: ARS 7.1.0 from NON unicode to unicode - oracle from 9.x to 10.x on new 
machines

** Hello listers,

we have a custom application, with ARS 7.1.0 server on AIX machine, installed 
in NON Unicode mode and
pointing to AIX db server with Oracle 9.2, characterset UTF8. So database is 
already Unicode enabled, ARS is not.

We are planning to do a major upgrade: we need to have our ARS server in 
Unicode mode,
then we will point app server to a new db machine with Oracle 10, eventually we 
want to upgrade to ARS 7.5.

Currently we are focusing on the non Unicode to Unicode upgrade step, so we are 
looking for any valuable advise on the topic.
At BMC support they keep on saying that a brand new ARS installation in Unicode 
mode is needed (i.e. no upgrade),
and then def+data must be imported at ARS level

Has anyone of you ever tried to upgrade ARS 7.1.0 from non Unicode to Unicode 
mode 'simply' changing parameters
and environment variables (LANG and LC_ALL) and locale settings on the ARS 
application server,
acting directly on ar.conf and arsystem files, and then doing a stop/restart of 
ars server?

Should a new installation be inevitable, we really want to avoid using migrator 
or arimport for data migration
(too many forms, too many data...), and use oracle export/import instead of 
whole arschema:
has anyone of you ever tried this option?

Any advise and suggestion on this topic is very welcome!

Thanks in advance

Best Regards,
Antonio Monizza
_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

AW: Load Balancer Recommendations 7.5 AR Server Environment

[Conny Martin]

if you're looking for a cheap solution have a look at
http://www.linuxvirtualserver.org/whatis.html
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von David Abry
Gesendet: Montag, 10. Mai 2010 16:41
An: arslist@ARSLIST.ORG
Betreff: Re: Load Balancer Recommendations 7.5 AR Server Environment


** Thanks.  I am getting a quote on F5 LTM now. Not sure how much they
run...  I am sure they are not cheap..


On Mon, May 10, 2010 at 10:19 AM, Robert Molenda
robert.mole...@gmail.com wrote:


As long as the IP address remains the same you will be fine -
the MAC
address must remain the same for licensing obviously...

On Mon, May 10, 2010 at 5:53 AM, David Abry
davidla...@gmail.com wrote:
 **


 Thanks for the response.  Do you know if the F5 LTM's work
well in VMWare
 virtual environments? We are going to have these servers on a
VM server with
 multiple AR VM server instances.

 Regards,
 Dave

 On Wed, May 5, 2010 at 9:13 AM, Axton axton.gr...@gmail.com
wrote:

 ** With the F5 LTM's you can host hundreds of farms using a
single device.
 Axton
 These statements represent my opinions and nothing more.

 On Wed, May 5, 2010 at 7:07 AM, David Abry
davidla...@gmail.com wrote:

 **

 So one hardware load balancer can be used for both the
ARServer and
 Mid-Tiers?

 Thank you all for your response!!

 Regards,

 Dave Abry

 On Tue, May 4, 2010 at 10:37 PM, Axton
axton.gr...@gmail.com wrote:

 ** When using appliances like F5's LTM, there is no need to
purchase
 multiple load balancers unless you are looking for physical
segregation for
 security reasons or fault tolerance for the load balancers.
 Axton Grams
 These statements represent my opinions and nothing more.

 On Tue, May 4, 2010 at 12:22 PM, David Abry
davidla...@gmail.com
 wrote:

 **
 Hi List,

 We are looking into purchasing a load Balancer for the
Mid-Tier and a
 second load Balancer for the ARServers. We will be using
ITSM 7.6 / 7.5
 ARServer in a all Windows 2003 environment.  We are using
IIS / Apache
 Servlet Engine.  We have a high number of users connecting
via the
 Mid-Tier...

 I am looking for any recommendations on what customers are
currently
 using for load balancers as well as success stories.  I
know BMC has
 recommendations in the Using a hardware load Balancer
7.1 white paper, but
 it would be good to know what has proven to be successful
since BMC support
 only provides the white paper...

 I have seen on the list that some customers are using F5
BIG-IP.

 Thanks in advance.

 V/R,

 David Abry
 _attend WWRUG10 www.wwrug.com http://www.wwrug.com/
ARSlist: Where the Answers Are_

 _attend WWRUG10 www.wwrug.com http://www.wwrug.com/
ARSlist: Where the Answers Are_

 _attend WWRUG10 www.wwrug.com http://www.wwrug.com/
ARSlist: Where the Answers Are_

 _attend WWRUG10 www.wwrug.com http://www.wwrug.com/
ARSlist: Where the Answers Are_

 _attend WWRUG10 www.wwrug.com http://www.wwrug.com/
ARSlist: Where the Answers Are_




--
If it were not for the gutter, my mind would be homeless!



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
http://www.arslist.org/ 
attend wwrug10 www.wwrug.com http://www.wwrug.com/  ARSlist:
Where the Answers Are



_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

AW: Load Balancer Recommendations 7.5 AR Server Environment

[Conny Martin]

Yes, this is no problem. We're using it without any problems on a ESX
Virtualized SLES 10 Box.
 
Take a look at www.loadbalancer.org, they use the same technique. You
can download a fully functional virtual appliance and test it for 30
days.
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von David Abry
Gesendet: Montag, 10. Mai 2010 17:26
An: arslist@ARSLIST.ORG
Betreff: Re: Load Balancer Recommendations 7.5 AR Server Environment


** 
Thanks Conny,
 
Can you set up a Linux VM instance and load balance windows
environments?  I will check it out. Are you using this and has it been
stable and reliable?
 
Thanks!


On Mon, May 10, 2010 at 11:05 AM, Conny Martin
conny.mar...@t-systems.com wrote:


** 
if you're looking for a cheap solution have a look at
http://www.linuxvirtualserver.org/whatis.html
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von David Abry
Gesendet: Montag, 10. Mai 2010 16:41
An: arslist@ARSLIST.ORG
Betreff: Re: Load Balancer Recommendations 7.5 AR Server
Environment


** Thanks.  I am getting a quote on F5 LTM now. Not sure how
much they run...  I am sure they are not cheap.. 


On Mon, May 10, 2010 at 10:19 AM, Robert Molenda
robert.mole...@gmail.com wrote:


As long as the IP address remains the same you will be
fine - the MAC
address must remain the same for licensing obviously...

On Mon, May 10, 2010 at 5:53 AM, David Abry
davidla...@gmail.com wrote:
 **


 Thanks for the response.  Do you know if the F5 LTM's
work well in VMWare
 virtual environments? We are going to have these
servers on a VM server with
 multiple AR VM server instances.

 Regards,
 Dave

 On Wed, May 5, 2010 at 9:13 AM, Axton
axton.gr...@gmail.com wrote:

 ** With the F5 LTM's you can host hundreds of farms
using a single device.
 Axton
 These statements represent my opinions and nothing
more.

 On Wed, May 5, 2010 at 7:07 AM, David Abry
davidla...@gmail.com wrote:

 **

 So one hardware load balancer can be used for both
the ARServer and
 Mid-Tiers?

 Thank you all for your response!!

 Regards,

 Dave Abry

 On Tue, May 4, 2010 at 10:37 PM, Axton
axton.gr...@gmail.com wrote:

 ** When using appliances like F5's LTM, there is no
need to purchase
 multiple load balancers unless you are looking for
physical segregation for
 security reasons or fault tolerance for the load
balancers.
 Axton Grams
 These statements represent my opinions and nothing
more.

 On Tue, May 4, 2010 at 12:22 PM, David Abry
davidla...@gmail.com
 wrote:

 **
 Hi List,

 We are looking into purchasing a load Balancer for
the Mid-Tier and a
 second load Balancer for the ARServers. We will be
using ITSM 7.6 / 7.5
 ARServer in a all Windows 2003 environment.  We
are using IIS / Apache
 Servlet Engine.  We have a high number of users
connecting via the
 Mid-Tier...

 I am looking for any recommendations on what
customers are currently
 using for load balancers as well as success
stories.  I know BMC has
 recommendations in the Using a hardware load
Balancer 7.1 white paper, but
 it would be good to know what has proven to be
successful since BMC support
 only provides the white paper...

 I have seen on the list that some customers are
using F5 BIG-IP.

 Thanks in advance.

 V/R,

 David Abry
 _attend WWRUG10 www.wwrug.com
http://www.wwrug.com/  ARSlist: Where the Answers Are_

 _attend WWRUG10 www.wwrug.com
http://www.wwrug.com/  ARSlist: Where the Answers Are_

 _attend WWRUG10 www.wwrug.com
http://www.wwrug.com/  ARSlist: Where the Answers Are_

 _attend WWRUG10 www.wwrug.com http://www.wwrug.com

AW: Any ksh shell experts on the list?

[Conny Martin]

Christopher,

I'm not a ksh expert, but this works for me.

#!/bin/ksh
count=$($ORACLE_HOME/bin/sqlplus -s user/password  EOF
set wrap off
set feedback off
set pagesize 0
set verify off
SELECT count(*) from arschema
/
exit
EOF
)

echo $count 





HTH

Kind Regards Conny


-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Pruitt, Christopher (Bank of 
America Account)
Gesendet: Freitag, 23. April 2010 21:52
An: arslist@ARSLIST.ORG
Betreff: Any ksh shell experts on the list?

Are there any KSH shell experts on the list or can you point me to some. I am 
at my wits end. 

I have a script that monitors a Remedy table in Oracle and does a count of 
records in that table. The select statement brings back a count but what I 
can't seem to get the sqlplus to do is return the results of the select 
statement back to a variable in the script. The reason I need it to return the 
results of the count statement is to then test it in an If statement. Below is 
an example of what I have tried.

I have tried some many different approaches to this and none seem to work. Has 
anyone on here done something like this before?


#- Oracle SQL -

sqlplus -S $user/$pass EOF
select count(*)
from aradmin.monitor_table;
EXIT
EOF
let RESULTS = $?


#- If Statement -

if [ $RESULTS -gt 10  $RESULTS -lt 150 ]; then
echo'SUCCESS'
fi


Christopher Pruitt
Business Consulting III
HP Enterprises Services
christopher.pru...@hp.com
www.hp.com 


Confidentiality Notice: This message and any files transmitted with it are 
intended for the sole use of the entity or individual to whom it is addressed, 
and may contain information that is confidential, privileged, and exempt from 
disclosure under applicable law. If you are not the intended addressee for this 
e-mail, you are hereby notified that any copying, distribution, or 
dissemination of this e-mail is strictly prohibited. If you have received this 
e-mail in error, please immediately destroy, erase, or discard this message. 
Please notify the sender immediately by return e-mail if you have received this 
e-mail by mistake.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 
www.wwrug.com ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

AW: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

[Conny Martin]

following env-vars are set by arsystem

LANG
TWO_TASK
ARCONFIGDIR
LC_ALL
PATH
ORACLE_HOME
LD_LIBRARY_PATH
ORA_NLS
ORA_NLS32
ORA_NLS33
NLS_LANG
NLSPATH
CLIENT_LOCALE 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von koray
Gesendet: Mittwoch, 21. April 2010 13:57
An: arslist@ARSLIST.ORG
Betreff: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

Hello again,

Can anyone send me the output of env command related to Remedy or APIs?

Best Regards,
Koray

On Apr 21, 12:24 pm, koray ko...@alkankoray.net wrote:
 @Juan Ingles: The C script exits with 0 in any case.
 Trying above arsystem env mypath/script results with Abort - core 
 dumped

 However the script isn't directly called in order to set the 
 environment variables. mypath/script consists of

 #!/usr/bin/sh
 LD_LIBRARY_PATH=paths
 export LD_LIBRARY_PATH
 /mypath/the_c_script_itself $@

 @Conny: you are right, I doubt that this is really related to the 
 environment variables.. But i am not sure how to overcome this..

 Best Regards,
 Koray

 __
 _  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org 
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

 --
 You received this message because you are subscribed to the Google Groups 
 Remedy ARS group.
 To post to this group, send email to arsl...@googlegroups.com.
 To unsubscribe from this group, send email to 
 arslist+unsubscr...@googlegroups.com.
 For more options, visit this group 
 athttp://groups.google.com/group/arslist?hl=en.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 
www.wwrug.com ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

AW: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

[Conny Martin]

Koray,

to isolate the problem I would suggest the following.

1. . ar_install_dir/bin/arsystem don't forget the dot in front, so you 
will have all the env-vars set by arsystem in your actual unix-shell 
2. try to start your script. It should abort with core dump
3. unset ENV-VAR
4. try to start your script
5. unset NEXT-ENV-VAR
6. try to start your script
...
...
...
...


you should be able to find the env-var which is causing trouble and perhaps 
this leads you to a solution.

HTH

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von koray
Gesendet: Mittwoch, 21. April 2010 15:57
An: arslist@ARSLIST.ORG
Betreff: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

Update: FreeAREntryListFieldList causes this error, included with arfree.h 
file..

On Apr 21, 4:09 pm, koray ko...@alkankoray.net wrote:
 By the way, is there any way I can view the coredump file generated?

 On Apr 21, 3:47 pm, koray ko...@alkankoray.net wrote:





  A few of them were missing such as ARCONFIGDIR but although I tried 
  copying them from another server it didn't work again..
  I did the server restart to see shell messages and it is exactly the 
  same : X Abort(coredump)

  I am totally lost.

  On Apr 21, 3:05 pm, Conny Martin conny.mar...@t-systems.com wrote:

   following env-vars are set by arsystem

   LANG
   TWO_TASK
   ARCONFIGDIR
   LC_ALL
   PATH
   ORACLE_HOME
   LD_LIBRARY_PATH
   ORA_NLS
   ORA_NLS32
   ORA_NLS33
   NLS_LANG
   NLSPATH
   CLIENT_LOCALE

   -Ursprüngliche Nachricht-
   Von: Action Request System discussion list(ARSList) 
   [mailto:arsl...@arslist.org] Im Auftrag von koray
   Gesendet: Mittwoch, 21. April 2010 13:57
   An: arsl...@arslist.org
   Betreff: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR 
   Server 7.5

   Hello again,

   Can anyone send me the output of env command related to Remedy or APIs?

   Best Regards,
   Koray

   On Apr 21, 12:24 pm, koray ko...@alkankoray.net wrote:

@Juan Ingles: The C script exits with 0 in any case.
Trying above arsystem env mypath/script results with Abort - 
core dumped

However the script isn't directly called in order to set the 
environment variables. mypath/script consists of

#!/usr/bin/sh
LD_LIBRARY_PATH=paths
export LD_LIBRARY_PATH
/mypath/the_c_script_itself $@

@Conny: you are right, I doubt that this is really related to 
the environment variables.. But i am not sure how to overcome this..

Best Regards,
Koray


__ _  UNSUBSCRIBE or access ARSlist Archives 
atwww.arslist.org attend wwrug10www.wwrug.comARSlist:Where the 
Answers Are

--
You received this message because you are subscribed to the Google 
Groups Remedy ARS group.
To post to this group, send email to arsl...@googlegroups.com.
To unsubscribe from this group, send email to 
arslist+unsubscr...@googlegroups.com.
For more options, visit this group 
athttp://groups.google.com/group/arslist?hl=en.

   __
   _  UNSUBSCRIBE or access ARSlist Archives 
   atwww.arslist.orgattendwwrug10www.wwrug.comARSlist:Where the Answers Are

   __
   _  UNSUBSCRIBE or access ARSlist Archives 
   atwww.arslist.org attend wwrug10www.wwrug.comARSlist:Where the Answers 
   Are

   --
   You received this message because you are subscribed to the Google Groups 
   Remedy ARS group.
   To post to this group, send email to arsl...@googlegroups.com.
   To unsubscribe from this group, send email to 
   arslist+unsubscr...@googlegroups.com.
   For more options, visit this group 
   athttp://groups.google.com/group/arslist?hl=en.

  
  ___  UNSUBSCRIBE or access ARSlist Archives 
  atwww.arslist.org attend wwrug10www.wwrug.comARSlist:Where the Answers Are

  --
  You received this message because you are subscribed to the Google Groups 
  Remedy ARS group.
  To post to this group, send email to arsl...@googlegroups.com.
  To unsubscribe from this group, send email to 
  arslist+unsubscr...@googlegroups.com.
  For more options, visit this group 
  athttp://groups.google.com/group/arslist?hl=en.

 __
 _  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org 
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

 --
 You received this message because you are subscribed to the Google Groups 
 Remedy ARS group.
 To post to this group, send email to arsl...@googlegroups.com.
 To unsubscribe from this group, send email to 
 arslist+unsubscr...@googlegroups.com.
 For more options, visit

AW: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

[Conny Martin]

Koray,

acivate arfork-log. If you don't see anything in arfork.log restart arserverd 
in your Unix-shell to see stdout/stderr.

HTH

Kind Regards Conny 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von koray
Gesendet: Dienstag, 20. April 2010 18:29
An: arslist@ARSLIST.ORG
Betreff: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

Script's working quite perfect. I tried copyingpasting /mypath/ script -p1 
parameter1 -p2 parameter2 to UNIX shell and it returns as expected. So it 
can't be the syntax.

On Apr 20, 7:21 pm, Frank Caruso caruso.fr...@gmail.com wrote:
 Is the problem with the syntax or with what /mypath/script is doing?





 On Tue, Apr 20, 2010 at 7:18 PM, koray ko...@alkankoray.net wrote:
  Hello together,

  I have upgraded my ARS servers from 6.3 to 7.5 and facing with some 
  major problems since then.
  The previous syntax to run an external process via an Active Link 
  was

  $PROCESS$ @@: /mypath/script -p1 parameter1 -p2 parameter2

  and it worked perfect. But since the 7.5 upgrade I have been 
  receiving
  errors:

  ACTL     - Passed qualification -- perform if actions ACTL          
  0: Set Fields

  ACTL             Process: /mypath/script -p1 parameter1 -p2
  parameter2
  ACTL      Error while performing active link action

  Do you have any idea? What am I doing wrong here?
  I even tried double-quoting the parameters but nothing seems to work.

  Also removing : character from active link results with no error 
  but returns null.

  Thanks in advance!
  Koray

  
  ___  UNSUBSCRIBE or access ARSlist Archives 
  atwww.arslist.org attend wwrug10www.wwrug.comARSlist: Where the Answers 
  Are

 __
 _  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org 
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

 --
 You received this message because you are subscribed to the Google Groups 
 Remedy ARS group.
 To post to this group, send email to arsl...@googlegroups.com.
 To unsubscribe from this group, send email to 
 arslist+unsubscr...@googlegroups.com.
 For more options, visit this group 
 athttp://groups.google.com/group/arslist?hl=en.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 
www.wwrug.com ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

AW: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

[Conny Martin]

Koray,

when you restart arserverd in your shell and then execute the AL with run 
process you will perhaps see some helpful error-messages.

I think it's something related to the environment (ENV-Vars like 
LD_LIBRARY_PATH or something like that).

To execute your script with the same env. as arserverd do the following.

/ar_install_dir/bin/arsystem env /mypath/script -p1 parameter1 -p2 parameter2

Kind Regards Conny

 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von koray
Gesendet: Dienstag, 20. April 2010 18:54
An: arslist@ARSLIST.ORG
Betreff: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

Hello Conny,

I activated arfork-log and here is the output:

arforkd version 7.5.00 PatchTue Apr 20 18:46:00 2010 Arforkd: Opening log file 
in overwrite mode.
Tue Apr 20 18:46:00 2010 Awaiting record marker.
Tue Apr 20 18:46:04 2010 Received record marker.
Tue Apr 20 18:46:04 2010 Spawning child, shell , command /mypath/ script -p1 
parameter1 -p2 parameter2.
Tue Apr 20 18:46:04 2010 Spawned /mypath/script -p1 parameter1 -p2 parameter2 
as pid 886.
Tue Apr 20 18:46:04 2010 Awaiting record marker.
Tue Apr 20 18:46:06 2010 process id 886 has exited with status 0x86.
Tue Apr 20 18:46:14 2010 Received record marker.

@process id 886 has exited with status 0x86: Can you help me on what
0x86 status is?
@arserverd restart: How can I see the stdout messages related while the restart?

Best Regards,
Koray

On Apr 20, 7:32 pm, Conny Martin conny.mar...@t-systems.com wrote:
 Koray,

 acivate arfork-log. If you don't see anything in arfork.log restart arserverd 
 in your Unix-shell to see stdout/stderr.

 HTH

 Kind Regards Conny

 -Ursprüngliche Nachricht-
 Von: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] Im Auftrag von koray
 Gesendet: Dienstag, 20. April 2010 18:29
 An: arsl...@arslist.org
 Betreff: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR 
 Server 7.5

 Script's working quite perfect. I tried copyingpasting /mypath/ script -p1 
 parameter1 -p2 parameter2 to UNIX shell and it returns as expected. So it 
 can't be the syntax.

 On Apr 20, 7:21 pm, Frank Caruso caruso.fr...@gmail.com wrote:





  Is the problem with the syntax or with what /mypath/script is doing?

  On Tue, Apr 20, 2010 at 7:18 PM, koray ko...@alkankoray.net wrote:
   Hello together,

   I have upgraded my ARS servers from 6.3 to 7.5 and facing with 
   some major problems since then.
   The previous syntax to run an external process via an Active Link 
   was

   $PROCESS$ @@: /mypath/script -p1 parameter1 -p2 parameter2

   and it worked perfect. But since the 7.5 upgrade I have been 
   receiving
   errors:

   ACTL     - Passed qualification -- perform if actions ACTL
   0: Set Fields

   ACTL             Process: /mypath/script -p1 parameter1 -p2
   parameter2
   ACTL      Error while performing active link action

   Do you have any idea? What am I doing wrong here?
   I even tried double-quoting the parameters but nothing seems to work.

   Also removing : character from active link results with no error 
   but returns null.

   Thanks in advance!
   Koray

   __
   __ ___  UNSUBSCRIBE or access ARSlist Archives 
   atwww.arslist.orgattend wwrug10www.wwrug.comARSlist:Where the Answers 
   Are

  
  __ _  UNSUBSCRIBE or access ARSlist Archives 
  atwww.arslist.org attend wwrug10www.wwrug.comARSlist:Where the 
  Answers Are

  --
  You received this message because you are subscribed to the Google Groups 
  Remedy ARS group.
  To post to this group, send email to arsl...@googlegroups.com.
  To unsubscribe from this group, send email to 
  arslist+unsubscr...@googlegroups.com.
  For more options, visit this group 
  athttp://groups.google.com/group/arslist?hl=en.

 __
 _  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgattend 
 wwrug10www.wwrug.comARSlist: Where the Answers Are

 __
 _  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org 
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

 --
 You received this message because you are subscribed to the Google Groups 
 Remedy ARS group.
 To post to this group, send email to arsl...@googlegroups.com.
 To unsubscribe from this group, send email to 
 arslist+unsubscr...@googlegroups.com.
 For more options, visit this group 
 athttp://groups.google.com/group/arslist?hl=en.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 
www.wwrug.com ARSlist: Where the Answers

AW: Problem with JAVA API

[Conny Martin]

Hi,

it seems like some kind of connectivity problem. Try a 

telnet arserver arport

It should accept the connection but you won't see any output. If that doesn't 
work then you'll have to investigate on the network connection (Firewall, etc.)

HTH

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Guillermo Alfredo Torres Barron
Gesendet: Donnerstag, 18. März 2010 20:25
An: arslist@ARSLIST.ORG
Betreff: Re: Problem with JAVA API

Hi
I add the instruction userInfo.login(); in the java program, but appear the 
same error

ERROR (91): RPC call failed; ONC/RPC call timed out

Thanks
Regards

-Mensaje original-
De: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] 
En nombre de Jarl Grøneng Enviado el: Miércoles, 17 de Marzo de 2010 11:59 p.m.
Para: arslist@ARSLIST.ORG
Asunto: Re: Problem with JAVA API

Seems like you mising the the login part.

userInfo = new ARServerUser();
userInfo.setServer(misPropiedades.getProperty(datos.arserver));
userInfo.setUser(misPropiedades.getProperty(datos.aruser));
userInfo.setPassword(misPropiedades.getProperty(datos.arpass));
userInfo.setPort(Integer.parseInt(misPropiedades.getProperty(datos.arport)));
   try
   {
userInfo.login();
userInfo.verifyUser();
...
...

--
Jarl



2010/3/18 Guillermo Alfredo Torres Barron guillermo.torres.bar...@banorte.com:
 Hi dear listers
 I try to do a java program with java api 7.1, the program compile 
 without errors but run it appear the next

 ERROR (91): RPC call failed; ONC/RPC call timed out

 I send you a extract of the program

 import com.bmc.arsys.api.*;
 import java.io.*;
 import java.lang.*;
 import java.util.*;
 import java.text.SimpleDateFormat;
 import java.lang.Integer;

 public class carga_indicadores
 {
 
 static void connect()
 {
String ruta = conn.conf;
Properties misPropiedades = new Properties();
try
{
misPropiedades.load(new FileInputStream(ruta));
}
catch (Exception e)
{
System.out.println(Error configuration file: +e);
System.exit(1);
}
userInfo = new ARServerUser();

 userInfo.setServer(misPropiedades.getProperty(datos.arserver));
userInfo.setUser(misPropiedades.getProperty(datos.aruser));

 userInfo.setPassword(misPropiedades.getProperty(datos.arpass));

 userInfo.setPort(Integer.parseInt(misPropiedades.getProperty(datos.ar
 po
 rt)));
try
{
userInfo.verifyUser();
}
catch (ARException e)
{
//This exception is triggered by a bad server, password 
 or,
//if guest access is turned off, by an unknown username.
System.out.println(Error usuario: +e);
//Clear memory used by our user context object
userInfo.clear();
System.exit(1);
}
System.out.print(Conectado.); .
 }

 Any idea is good for us
 Thanks in advance
 Regards


 ...
 Este correo electronico es confidencial y/o puede contener informacion 
 privilegiada.
 Si usted no es su destinatario o no es alguna persona autorizada por este 
 para recibir sus correos electronicos, NO debera usted utilizar, copiar, 
 revelar, o tomar ninguna accion basada en este correo electronico o cualquier 
 otra informacion incluida en el, favor de notificar al remitente de inmediato 
 mediante el reenvio de este correo electronico y borrar a continuacion 
 totalmente este correo electronico y sus anexos.
 Nota: Los acentos y caracteres especiales fueron omitidos para su correcta 
 lectura en cualquier medio electronico.

 This e-mail is confidential and/or may contain privileged information.
 If you are not the addressee or authorized to receive this for the 
 addressee, you must not use, copy, disclose, or take any action based on this 
 message or any other information herein, please advise the sender immediately 
 by reply this e-mail and delete this e-mail and  its attachments.
 ...

 __
 _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
 attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 
www.wwrug.com ARSlist: Where the Answers Are


...
Este correo electronico es confidencial y/o puede contener informacion 
privilegiada.
Si usted no es su destinatario o no es alguna 

AW: ARSperl on RedHat Linux.

[Conny Martin]

William,

IMHO there are some of the libraries missing under api/lib. I've copied them 
from ar_install_dir/bin to ar_install_dir/api/lib and everything works fine.

HTH

Kind Regards Conny 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von William Abdo
Gesendet: Donnerstag, 18. März 2010 19:10
An: arslist@ARSLIST.ORG
Betreff: Re: ARSperl on RedHat Linux.

Thank You for responding:

I did checked the LD_LIBRARY_PATH and the API path is in the list, see
below:
LD_LIBRARY_PATH=/opt/oracle/app/oracle/product/11.1.0/client_1/lib:/lib:
/usr/lib:/usr2/api75p2/api/lib:/usr2/api75p2/bin:/usr2/api75p2/api:

It must be something really obvious.

Any Other suggestions of which rock to possibly look under?



Respectfully,

William Abdo
Verio - Boca Raton
Remedy Administration Group
561-912-2434



-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Thilo Stapff
Sent: Thursday, March 18, 2010 1:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARSperl on RedHat Linux.

It might be necessary to add /usr2/api75p2/api to your system's LD_LIBRARY_PATH 
variable or to run ldconfig /usr2/api75p2/api.


Regards,
Thilo



On 18.03.2010 17:08, William Abdo wrote:
 **

 Hi All,

 I hope your day is going well.

 Maybe I am missing the obvious thing here or something like that.

 I am wondering if anyone else has experienced this issue and can maybe
 point me in the correct direction.

 On 32 bit Redhat Linux, running ARSperl 1.92 (beta) It does not seem
to
 find my libraries.

 When I do the perl Makefile.PL I see the following exerts of results.

 Perl Makefile.PL

 ...

 Generating serverTypeInfoHints.h ..

 Converting C header files to perl modules ..

 Configuring with options:

 ARSVERSION = 7.50

 ARSAPI = /usr2/api75p2/api

 AUTODEFINES = -m32 -g -DDEBUG -D_REENTRANT -lpthread
 -Wno-unused-variable -Wuninitialized -DARS32 -DARS452 -malign-double
 -DPERL_PATCHLEVEL_IS=8 -DPERL_SUBVERSION_IS=8 -DPERL_BASEREV_IS=50

 ARS_LIBS = -lnsl -lpthread -L/usr2/api75p2/api/lib -libicuucbmc
 -libicui18nbmc -libicudatabmc

 Note (probably harmless): No library found for -libicuucbmc

 Note (probably harmless): No library found for -libicui18nbmc

 Note (probably harmless): No library found for -libicudatabmc

 Writing Makefile for ARS

 === ARSperl 'make test' configuration. ===

 ...

 As you can see there are No Errors, just Notes issued.

 So I do the make with questions about the No Library Found lines

 make

 ...

 ...

 gcc: -lpthread: linker input file unused because linking not done

 There are No Errors on the make with the exception of the above
message
 is issued.

 Make Install is successful with no errors or messages.

 Then the Perl script dies on the Use ARS; line in the script.

 In my thinking, the No library found is the key.

 When I check the lib path -L/usr2/api75p2/lib  they are there as the
 following 32 bit names:.

 ibicui18nbmc.so libicui18nbmc.so.32

 libicuucbmc.so libicuucbmc.so .32

 libicudatabmc.so libicudatabmc.so.32

 Did I miss checking something or is there something in the Makefile.PL
I
 missed configuring?

 Any assistance is appreciated.

 Respectfully,

 William Abdo

 Verio - Boca Raton

 Remedy Administration Group

 561-912-2434

 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the
Answers
 Are_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

AW: Admin tool crashing

[Conny Martin]

Christopher,

I would try to enable client-side API-logging.

Open a cmd-box

set ARAPILOGGING=24

Then start aradmin.exe out of this cmd-box. I hope this gives you a clue what's 
going on.

Kind Regards Conny 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Pruitt, Christopher (Bank of 
America Account)
Gesendet: Mittwoch, 17. März 2010 13:57
An: arslist@ARSLIST.ORG
Betreff: Re: Admin tool crashing

Yes, it still does it when I clear my temp directory and reboot. I have tried 
every trick I have learned over the 15+ years of working with the Remedy tools 
and nothing is working. 

Christopher Pruitt
Business Consulting III
HP Enterprises Services
christopher.pru...@hp.com
www.hp.com 


Confidentiality Notice: This message and any files transmitted with it are 
intended for the sole use of the entity or individual to whom it is addressed, 
and may contain information that is confidential, privileged, and exempt from 
disclosure under applicable law. If you are not the intended addressee for this 
e-mail, you are hereby notified that any copying, distribution, or 
dissemination of this e-mail is strictly prohibited. If you have received this 
e-mail in error, please immediately destroy, erase, or discard this message. 
Please notify the sender immediately by return e-mail if you have received this 
e-mail by mistake.


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Richard Copits
Sent: Tuesday, March 16, 2010 2:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: Admin tool crashing

Does it do it when you clean out your temp directory and reboot?

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Pruitt, Christopher (Bank of America 
Account)
Sent: Tuesday, March 16, 2010 3:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: Admin tool crashing

I can log into my account on someone else's computer and it works fine. If 
someone logs into their account on my computer it crashes. I tried blowing away 
the user profile and it did not change anything, same results.

Christopher Pruitt
Business Consulting III
HP Enterprises Services
christopher.pru...@hp.com
www.hp.com 


Confidentiality Notice: This message and any files transmitted with it are 
intended for the sole use of the entity or individual to whom it is addressed, 
and may contain information that is confidential, privileged, and exempt from 
disclosure under applicable law. If you are not the intended addressee for this 
e-mail, you are hereby notified that any copying, distribution, or 
dissemination of this e-mail is strictly prohibited. If you have received this 
e-mail in error, please immediately destroy, erase, or discard this message. 
Please notify the sender immediately by return e-mail if you have received this 
e-mail by mistake.


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A
Sent: Tuesday, March 16, 2010 1:16 PM
To: arslist@ARSLIST.ORG
Subject: Re: Admin tool crashing

what if you re-create your windows user profile? Or if someone else logs into 
your computer - do they experience the same issue? 

Marcelo

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Pruitt, Christopher (Bank of America 
Account)
Sent: Tuesday, March 16, 2010 12:56 PM
To: arslist@ARSLIST.ORG
Subject: Re: Admin tool crashing

Sorry, don't have Developer Studio tool installed.

Christopher Pruitt
Business Consulting III
HP Enterprises Services
christopher.pru...@hp.com
www.hp.com 


Confidentiality Notice: This message and any files transmitted with it are 
intended for the sole use of the entity or individual to whom it is addressed, 
and may contain information that is confidential, privileged, and exempt from 
disclosure under applicable law. If you are not the intended addressee for this 
e-mail, you are hereby notified that any copying, distribution, or 
dissemination of this e-mail is strictly prohibited. If you have received this 
e-mail in error, please immediately destroy, erase, or discard this message. 
Please notify the sender immediately by return e-mail if you have received this 
e-mail by mistake.


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of William Abdo
Sent: Tuesday, March 16, 2010 11:49 AM
To: arslist@ARSLIST.ORG
Subject: Re: Admin tool crashing

Hi Christopher,
Here is something else to try that I ran into.

If this is the Developer Studio tool, Did you change the devstudio.ini file 
settings for the max memory to with -Xms1280m -Xmx1280m

That will crash it for sure if the values are too high.

If your using the original tool than you may need to reinstall because of a 
corrupt dll.

AW: Admin tool crashing

[Conny Martin]

Christopher,

I'm able to reproduce your issue. Your admintool does not use standard RPC-Port 
(390600). Either you have set ARRPC or you did specify a special RPC-Port in 
your account.

HTH

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Pruitt, Christopher (Bank of 
America Account)
Gesendet: Mittwoch, 17. März 2010 15:09
An: arslist@ARSLIST.ORG
Betreff: Re: Admin tool crashing

Very interesting. I did what you suggested. I see in the API log where the 
ARCreateActiveLink actually creates the active link but then the 
ARGetActiveLink results shows a failure. SO I tried it with the other objects 
and it fails at the same point every time on the ARGet action. I have sent this 
API log to BMC Tech Support.



#
# ARCreateActiveLink
#
cal
CJP_Test_Again2
0
1
1
AIM:Asset
0
0
0
0
0
0
1
4
0
1
I am here to test again
T
0

vzcadmin

2
60016
4
0
60017
4
0

   ARCreateActiveLink results
Return Code: OK
Status List: 0 items
Start Time:1268833833.372000 (Wed Mar 17 2010 08:50:33)
Finish Time:   1268833836.106000 (Wed Mar 17 2010 08:50:36)
Elapsed Time:  2.734000

#
# ARGetActiveLink
#
gal
CJP_Test_Again2

   ARGetActiveLink results
Return Code: ERROR
Status List: 1 items
Status Struct:
   Message type: ERROR
   Message number: 346
   Message: Active link does not exist on server
   Appended: CJP_Test_Again2
Start Time:1268833836.106000 (Wed Mar 17 2010 08:50:36)
Finish Time:   1268833836.122000 (Wed Mar 17 2010 08:50:36)
Elapsed Time:  0.016000



Christopher Pruitt
Business Consulting III
HP Enterprises Services
christopher.pru...@hp.com
www.hp.com 


Confidentiality Notice: This message and any files transmitted with it are 
intended for the sole use of the entity or individual to whom it is addressed, 
and may contain information that is confidential, privileged, and exempt from 
disclosure under applicable law. If you are not the intended addressee for this 
e-mail, you are hereby notified that any copying, distribution, or 
dissemination of this e-mail is strictly prohibited. If you have received this 
e-mail in error, please immediately destroy, erase, or discard this message. 
Please notify the sender immediately by return e-mail if you have received this 
e-mail by mistake.


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Conny Martin
Sent: Wednesday, March 17, 2010 8:12 AM
To: arslist@ARSLIST.ORG
Subject: AW: Admin tool crashing

Christopher,

I would try to enable client-side API-logging.

Open a cmd-box

set ARAPILOGGING=24

Then start aradmin.exe out of this cmd-box. I hope this gives you a clue what's 
going on.

Kind Regards Conny 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Pruitt, Christopher (Bank of 
America Account)
Gesendet: Mittwoch, 17. März 2010 13:57
An: arslist@ARSLIST.ORG
Betreff: Re: Admin tool crashing

Yes, it still does it when I clear my temp directory and reboot. I have tried 
every trick I have learned over the 15+ years of working with the Remedy tools 
and nothing is working. 

Christopher Pruitt
Business Consulting III
HP Enterprises Services
christopher.pru...@hp.com
www.hp.com 


Confidentiality Notice: This message and any files transmitted with it are 
intended for the sole use of the entity or individual to whom it is addressed, 
and may contain information that is confidential, privileged, and exempt from 
disclosure under applicable law. If you are not the intended addressee for this 
e-mail, you are hereby notified that any copying, distribution, or 
dissemination of this e-mail is strictly prohibited. If you have received this 
e-mail in error, please immediately destroy, erase, or discard this message. 
Please notify the sender immediately by return e-mail if you have received this 
e-mail by mistake.


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Richard Copits
Sent: Tuesday, March 16, 2010 2:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: Admin tool crashing

Does it do it when you clean out your temp directory and reboot?

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Pruitt, Christopher (Bank of America 
Account)
Sent: Tuesday, March 16, 2010 3:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: Admin tool crashing

I can log into my account on someone else's computer and it works fine. If 
someone logs into their account on my computer it crashes. I tried blowing away 
the user profile and it did not change anything, same results.

Christopher Pruitt
Business Consulting III
HP Enterprises Services
christopher.pru...@hp.com
www.hp.com 


Confidentiality Notice: This message and any files transmitted with it are 
intended for the sole use of the entity

AW: ARSPerl on RedHat Linux Question

[Conny Martin]

William,
 
exsi.pl tries to determine the datatype for the AR_SERVER_INFO_* tags out of 
the comment after the #define. In most cases this works fine, but there are 
some lines which does not follow the conventions.
 
Try to add the datatype as first word in the comment like this
 
#define AR_SERVER_INFO_FT_COLLECTION_DIR 231 /* char deprecated - scheduled 
for  */
 /*  removal in future release  
*/
#define AR_SERVER_INFO_FT_CONFIGURATION_DIR  232 /* char deprecated - scheduled 
for  */
 /*  removal in future release  
 */
#define AR_SERVER_INFO_FT_TEMP_DIR   233 /* char deprecated - scheduled 
for  */
 
There may be some other lines that have to be adjusted.
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von William Abdo
Gesendet: Dienstag, 16. März 2010 16:22
An: arslist@ARSLIST.ORG
Betreff: ARSPerl on RedHat Linux Question


** 

Hello ARS-Listeners,

I am having difficult in installing ARSPerl 1.91 on Linux.  Has anyone 
successfully performed this install on this version?

I am trying to install  ARSPerl  1.91 on Red Hat Enterprise Linux Server 
release 5.4 (Tikanga)  Linux 2.6.18-164.11.1.el5 GNU/Linux

I am asking you because you have had success with this on Linux on the past.

The ARSPerl  installer fails because of the ar. h file. It picked a line out 

I am using the 7.5 API Library. 

 

My error is: 

cant map deprecated to an artype for AR_SERVER_INFO_FT_COLLECTION_DIR

something went wrong when i ran /usr/bin/perl infra/exsi.pl  
/usr2/api75p2/api/include/ar.h  serverTypeInfoHints.h (rv = 2304, expected 
0) at Makefile.PL line 242.

 

Anyone have any ideas of what has to be modified  in the vanilla ar.h file to 

Should I be using a different ARSPerl version?

 

Respectfully,

 

William Abdo

Verio - Boca Raton

Remedy Administration Group

561-912-2434

 

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

AW: SSL certificate for incoming and outgoing ar email

[Conny Martin]

here is an example how to import a certificate

keytool -keystore c:\Program Files\Java\j2re1.4.2_04\lib\security\cacerts 
-import -file mozilla.cer -alias mozilla 

HTH

Kind Regards Conny 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Atul Vohra
Gesendet: Dienstag, 9. März 2010 15:35
An: arslist@ARSLIST.ORG
Betreff: SSL certificate for incoming and outgoing ar email

Hi,

I am trying to set up AR Email and use customers exchange server which uses SSL.

I have outgoing mailbox set and am getting this error:

javax.mail.MessagingException: Exception reading response;
  nested exception is:
javax.net.ssl.SSLHandshakeException: 
sun.security.validator.ValidatorException: PKIX path building failed: 
sun.security.provider.certpath.SunCertPathBuilderException: unable to find 
valid certification path to requested target

Where do I need to install the certificate (if that is the issue) and also it 
is not generated by a commercial CA. 
ARS v7.5 p4 on Windows Server 2003

Regards
Atul Vohra

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 
www.wwrug.com ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

AW: Active Link Question

[Conny Martin]

Form - Form Properties - Sort

Kind Regards Conny 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Mayfield, Andy L.
Gesendet: Montag, 8. März 2010 17:00
An: arslist@ARSLIST.ORG
Betreff: Active Link Question

When performing a Set Field action from an AL, I have it set to if multiple 
requests match - Display a List.   Is there a way to dictate the order in 
which this list is displayed?  I can't figure out how it's determining the 
order.

Thanks,

Andy L. Mayfield
Sr. Protection  Control Technician
Alabama Power Company
Office: 205-226-1805
Cell: 205-288-9140
SoLinc: 10*19140

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 
www.wwrug.com ARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

AW: arcache and arreload (ARS7.1 patch004)

[Conny Martin]

Frex,
 
just ommit the -s switch.
 
arcache and arreload will only work local. (connecting to localhost)
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Frex Popo
Gesendet: Montag, 22. Februar 2010 10:14
An: arslist@ARSLIST.ORG
Betreff: arcache and arreload (ARS7.1 patch004)


** 
Dear all,
 
Has anyone tried to run arcache and arreload successfully? It keep
complaining about the -s switch. 
 
set ARTCPPORT=
 
arcache -Ua -e 001 -lw 1 -n admin_user -p -s server_des
-g 1; -d 
Illegal command line parameter (ARERR 9907) 
-s
 
arreload -u User -a admin_user -p  -s server_test -d
Illegal command line parameter (ARERR 9907)
-s
 
Windows server 2003 SP2
ARS 7.1 patch004
 
Regards
frex


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_

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

AW: Help with Sybase indexes

[Conny Martin]

Larry,

you should compare the metatables with the indexes oracle knows.

If one of these 2 statements gives you any rows, you have messed up your 
indexes.

SELECT name,'pk_idx for T-Table' FROM arschema WHERE schematype = 1 AND NOT 
EXISTS (SELECT * FROM user_indexes WHERE index_name = 'IT'||schemaid)
UNION ALL
SELECT name,'pk_idx for H-Table' FROM arschema WHERE schematype = 1 AND NOT 
EXISTS (SELECT * FROM user_indexes WHERE index_name = 'IH'||schemaid)
UNION ALL
SELECT name,'pk_idx for B-Table' FROM arschema WHERE schematype = 1 AND NOT 
EXISTS (SELECT * FROM user_indexes WHERE index_name = 'IB'||schemaid)


SELECT 
name,arschema.schemaid,schema_index.numfields,uniqueflag,indexname,f1,f2,f3 
FROM arschema,schema_index WHERE indexname NOT IN (SELECT INDEX_name FROM 
user_indexes) AND schema_index.schemaid = arschema.schemaid

HTH

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von L G Robinson
Gesendet: Montag, 22. Februar 2010 14:33
An: arslist@ARSLIST.ORG
Betreff: Re: Help with Sybase indexes

Hi Joe,

Thanks for the reply. I did compare the information in the AR System's 
meta-tables between the two systems (schema_index) and it matches up as 
expected. However, I believe it is possible for there to be a mismatch between 
what ARS thinks and what actually exists in the DB. The situation I am trying 
to detect is the one where ARS thinks there is an index, but for whatever 
reason, the index no longer exists in the DB.

I have been using Misi's wonderful RRRchive utility and on occasion, I have to 
interrupt a copy operation before it finishes. In this case, I believe that the 
target table will be left without its index since RRRchive does not get the 
chance to recreate the index on the target table when the program is killed. I 
recreate the index(es) when this happens... I just want to make sure I have not 
missed any.

Thanks again.
Larry
  
On Feb 21, 2010, at 8:53 AM, Joe D'Souza wrote:

 Larry,
 
 Why not look this same information up from the AR System's meta information?
 That way it would be easier to compare the two systems indexes if they 
 should be identical..
 
 Joe
 
 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org]on Behalf Of L G Robinson
 Sent: Friday, February 19, 2010 5:47 PM
 To: arslist@ARSLIST.ORG
 Subject: Help with Sybase indexes
 
 
 Hi Folks,
 
 I need some Sybase help regarding indexes.
 
 I am migrating from Sybase to Oracle and I want to compare the two 
 systems to make sure that the Oracle system has all of the same 
 indexes on the T-tables as currently exist in the Sybase system. I 
 don't doubt that they were there originally as a result of the 
 workflow import that I did to create the Oracle system. I just want to 
 make sure that I have not inadvertently messed any of the indexes up 
 while I have been working in the Oracle system and copying data over (Thanks 
 Misi!!!).
 
 On the Oracle side, I can do the following:
 
 SELECT s.name as Form Name, b.column_name, a.table_name, 
 a.index_name, a.uniqueness,a.index_type FROM USER_INDEXES a, 
 USER_IND_COLUMNS b, arschema s WHERE a.index_name = b.index_name AND 
 cast(s.schemaId as varchar2(40)) =
 substr(a.table_name,2) AND substr(a.table_name,1,1) = 'T' 
 ORDER by 1,2;
 
 This gives me exactly what I need. However, I have been spelunking 
 through the Sybase system tables all day and I can not seem to locate 
 all of the information I need. I can see almost everything in the 
 sysindexes table.
 However, I do not see the name or id number of the column that the 
 index is built upon. Maybe I'm just missing something obvious but I 
 sure don't see it.
 
 Anyone have any insights into how to accomplish the above in Sybase?
 
 Thanks.
 Larry
 
 ARS:5.1.2
 Sybase: 12.5.2
 Oracle: 10.2.0.4.0
 
 Larry Robinson   n...@ncsu.edu
 Office of Information Technology
 NC State University  919-515-5432 Voice
 Raleigh, NC  27695-7109  919-513-0877 FAX
 
 __
 _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
 Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

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

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

AW: SQL help needed

[Conny Martin]

if you turn on sql-logging and search for users belong to administrator
group you will see a statement like this.
 
SELECT * FROM ( SELECT
T31.C1,C101,C536870913,C8,C536870912,C54000,C54002 FROM T31
WHERE ((T31.C104 LIKE '1;%') OR (T31.C104 LIKE '% 1;%') OR (T31.C104
LIKE '%;1;%')) ORDER BY 1 ASC )
 
This makes sense because in earlier versions of arsystem the groupids
were separeted by ;space and now it's only separated by ;
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Joe D'Souza
Gesendet: Dienstag, 16. Februar 2010 23:27
An: arslist@ARSLIST.ORG
Betreff: Re: SQL help needed


** 
The second statement should be
 
select count(*) from t9 where c104 like '1; %' or c104 like '% 1; %';
 
However I would rather use the view name of the user form which is
user_x instead of t9 because if you are writing code that needs to be
migrated across servers, writing SQL statements on the T tables may not
be the best idea unless in your environment you are absolutely sure that
you have the whole table structures migrated across systems maintaining
the identical T numbers for those tables across environments..
 
So I would rather prefer the statement
 
select count(*) from user_x where group_list like '1; %' or group_list
like '% 1; %';
 
This statement will be good for all environments irrespective of how
careful you are to ensure ideal case database migrations between
different environments...
 
As far as parsing the group ID's to real group names, if you absolutely
have to do it using direct SQL queries why not try writing a stored
procedure to do it? It may be a lot easier..
 
Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of remedy.help
Sent: Tuesday, February 16, 2010 5:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL help needed


** 
What i need --
 
I need to pull out the group names from group list field(c104).
Since it contains the group id and not the group names i need to convert
it back to group names; 
 
Also can we do a select statement for group list field where we
say 
 
select count(*) from t9 where c104 like '1';
 
I am on oracle DB and the list i have checked for every other
string habits;
 
regards


 
On Tue, Feb 16, 2010 at 4:00 PM, Joe D'Souza jdso...@shyle.net
wrote:


** 
Have you tried retrieving the same using a simple select
statement using a like clause? I do not see a distinct advantage of
using a cursor to retrieve what you are trying to.
 
Joe


-Original Message-
From: Action Request System discussion
list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of remedy.help
Sent: Tuesday, February 16, 2010 4:42 PM
To: arslist@ARSLIST.ORG

Subject: Re: SQL help needed


** 
the error points to the Fetch statement Fetch C1
into froup_id,group_name
It will be great if somebody has done sql
manipulations on the C104 filed of the t9(User Form)


On Tue, Feb 16, 2010 at 3:37 PM, Joe D'Souza
jdso...@shyle.net wrote:


** 
What is the error that you are getting?
 
Joe

-Original Message-
From: Action Request System discussion
list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of amit dw
Sent: Tuesday, February 16, 2010 4:20 PM
To: arslist@ARSLIST.ORG
Subject: SQL help needed


** 
Hello All,
 

Below is the problem and way I was
trying to handle it 

 

C_list contains comma separated values
of group Id's. this list contains all the group id's associated to a
particular login name.

 

C_list=
(1,15005,85,83,84,805)

 

This variable will be holding up
dynamically value in numbers.

 

 

AW: Web Services - please enlight me!

[Conny Martin]

You should use some WebService Client, e.g. SoapUI http://www.soapui.org 

HTH

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Mark Milke
Gesendet: Montag, 15. Februar 2010 13:44
An: arslist@ARSLIST.ORG
Betreff: Re: Web Services - please enlight me!

Can anyone tell me how to send a request to a Web Service via Web Browser?

https://my_domain/arsys/services/ARService?server=ip_addresswebService=PO

shows me:

ARService

Hi there, this is an AXIS service!
Perhaps there will be a form for invoking the service here...

I guess I need to complete the URL with some kind of request?

Thanks,
Mark


On 15 Feb., 10:42, Mark Milke mark_mi...@yahoo.com wrote:
 Hello everyone,

 we're still on 6.3. I'm trying to do something with the Web Services, 
 so I got started by setting up the PO Example from the ARS manual, 
 i.e. I've created the PO and Line Item forms and the PO Web Service.

 I want to try consume the Web Service from the same ARS machine. In 
 order to do that, I've created a from called PO Consumer and a filter 
 with a Set Fields action trying to query a the aforementioned Web 
 Service. I've entered the WDSL URL from the Web Service into the 
 'Choose wdsl' field, I'' pressing the 'Load' button and get:

 ERROR: URI not 
 foundhttps://ourdomain/arsys/WSDL/public/the_ip_of_our_ARS_server/PO

 The funny thing is, that on the WDSL tab of the Web Service the same 
 URL displays the WDSL contents. The same URL works just fine in a web 
 broswer too.

 QUESTION: Which route/path is ARS taking when I specify the URL to the 
 WDSL in a Set Fields action. Is it trying to go from the Admin Tool to 
 the specified URL? Is it trying from the ARS server to the Mid-Tier?
 Or what else? I guess some firewall might be blocking here, but 
 without knowing what ARS is trying to do here, I can't really help it.
 This is really confusing...

 Another Web Service question I have is this: When you go to the WDSL 
 tab in a Web Service, it will display the contents of the WDSL. How do 
 I get this stuff into a file? I tried with copy and paste, but this 
 always causes some formatting problems resulting in ARS not accepting 
 the file.

 Thanks,
 Mark

 __
 _­ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org 
 Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

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

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

AW: ARSperl with ARS 7.5 running on 64bit

[Conny Martin]

Hi Sean,
 
it would run if you compile ARSPerl using a 32-Bit Perl. It won't run
with a 64-Bit Perl.
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Sean Harrodine
Gesendet: Montag, 8. Februar 2010 11:38
An: arslist@ARSLIST.ORG
Betreff: ARSperl with ARS 7.5 running on 64bit


** 
Hi everyone,
 
Can anyone confirm please whether ARSPerl will work with ARS 7.5 running
on a redhat linux 64bit server and if so, whether there's anything
undocumented i need to be aware of before i have a crack at installing
it ?
 
TIA, as always !
 
Sean

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_

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

AW: Error while starting a server group member

[Conny Martin]

IMHO this is related to the processes and sessions parameter on the
oracle-db. You're running out of available oracle processes.
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von SriSamSri Appecherla
Gesendet: Mittwoch, 3. Februar 2010 17:23
An: arslist@ARSLIST.ORG
Betreff: Error while starting a server group member


** 
Hi Listers,
 
I am getting the following error when I start the AR server. The server
is a server group member. At any point of time, only one server comes up
fine, while the other shows this error. However, the DB client is able
to connect to the DB using ARS credentials without any problem from both
the hosts.
 
Wed Feb  3 11:09:11 2010  PreloadTableThread : Failure while trying to
connect to the SQL database.
Please ensure the SQL database is running or contact the Database
Administrator for help (ARERR 550)
Wed Feb  3 11:09:11 2010 Preload Tables Thread DB access
Wed Feb  3 11:09:11 2010 ORA-12516: TNS:listener could not find
available handler with matching protocol stack
 
 
Platform: Sun Solaris 10
DB :  Oracle 11g
ARS : 7.5
 
Appreciate your help.

Regards,
SriSamSri Appecherla
Mobile# +91 988 480 4001
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: Server group testing

[Conny Martin]

you're missing a loadbalancer.
 
Server group has only failover functionality for some internal
services like escalation, dso, email etc. 
 
Kind Regards Conny
 



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von SriSamSri Appecherla
Gesendet: Donnerstag, 14. Januar 2010 14:18
An: arslist@ARSLIST.ORG
Betreff: Re: Server group testing


** Hi,

I set a common alias name for both Primary and Secondary servers. I
added the alias name in the /etc/hosts/ with the corresponding IPs on
both the servers. I added the same alias name for both the Primary and
the Secondary server IPs on my client machine. 

I tried this but it did not work. I am using Server group only for
failover and not for load balancing. So I do not have a load balancer.
Also, I have retained the default entries in the Server group ranking
form and created no additional entries. Is it necessary to add entries
in this form with rankings for the secondary server? Is there anything
else that I am missing?

Thanks in advance!

Regards,
SriSamSri Appecherla
Mobile# +91 988 480 4001



On Tue, Jan 12, 2010 at 10:34 PM, DCI Remedy dci.rem...@gmail.com
wrote:


** 
Our production environment is setup as a server group.  You have
to have both servers aliased.  IE, Primary (P01) is aliased to P00 and
Secondary (P02) is also aliased to P00.  The config guide goes into more
detail.
 
but basically, you would then log into P00, which would either
log you into P01 or P02.  I you were logged into P01 (through P00) and
then shut down P01, you would failover to P02.
 


 
On Tue, Jan 12, 2010 at 9:56 AM, SriSamSri Appecherla
appecherla@gmail.com wrote:


** 
Hi,
 
I am new to using the Server group concept. I installed
2 servers in Server group (one primary and another secondary). How can I
test the failover functionality between them? If I am logged into the
Primary server from the User tool and the primary server shuts down,
will I still be able to continue working with the User tool? Will the
Secondary server take over in this case?
 
Details of the server are as below:
ARS 7.5, ITSM 7.5, CMDB 7.5, SLM 7.5; Platform - Sun
Solaris; DB - Oracle 11g

Regards,
SriSamSri Appecherla
Mobile# +91 988 480 4001

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist:
Where the Answers Are_ 


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the
Answers Are_ 


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: Is there a way to set an Oracle nologging option for Remedy Archiving process?

[Conny Martin]

This will not have any effect.

see http://www.orafaq.com/wiki/Nologging_and_force_logging

ARS does normal update's, insert's or delete's and this is always logged in the 
redo-logs.

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Guillaume Rheault
Gesendet: Mittwoch, 13. Januar 2010 21:49
An: arslist@ARSLIST.ORG
Betreff: Re: Is there a way to set an Oracle nologging option for Remedy 
Archiving process?

You need to find out the schemaid in the arschema table related to your form.
Once you do that, you need to issue a sql statement through SQL Plus, Toad or 
SQL Developer, like this one


SQL alter table T12345 nologging;

Guillaume

From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on 
behalf of Pruitt, Christopher (Bank of America Account) 
[christopher.pru...@hp.com]
Sent: Wednesday, January 13, 2010 3:40 PM
To: arslist@ARSLIST.ORG
Subject: Is there a way to set an Oracle nologging option for Remedy Archiving 
process?

Issue Details:
Is there a way to set the nologging option on the Remedy Archive tables when 
the Remedy archival process is running to disable the Oracle Archiving logging?


We need to ensure that it Oracle doesn't generate Oracle archive logs for the 
Remedy Archiving table when we are pushing data from the data tables to the 
archive tables. We are having issues where the tablespace growth is directly 
proportional to the number of records being archived. If there are more records 
archived,  more tablespace growth. In this case since Remedy archiving process 
would insert on to the Remedy archived tables, the number of Oracle archive 
logs increase. Last month we ran Remedy Archiving and it generated over 1.5 gb 
of Oracle Archiving logs in a matter of just a few hours.

Environment

Remedy version 7.1.00 Build 200708221849 Oracle 10.2.0.4.0 - 64bi OS SunOS 5.9


Christopher Pruitt
Business Consulting III
HP Enterprises Services
christopher.pru...@hp.commailto:mary.jo...@hp.com
www.hp.comhttp://www.hp.com/

Confidentiality Notice: This message and any files transmitted with it are 
intended for the sole use of the entity or individual to whom it is addressed, 
and may contain information that is confidential, privileged, and exempt from 
disclosure under applicable law. If you are not the intended addressee for this 
e-mail, you are hereby notified that any copying, distribution, or 
dissemination of this e-mail is strictly prohibited. If you have received this 
e-mail in error, please immediately destroy, erase, or discard this message. 
Please notify the sender immediately by return e-mail if you have received this 
e-mail by mistake.




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

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

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

AW: Is there a way to set an Oracle nologging option for Remedy Archiving process?

[Conny Martin]

NOLOGGING can be used to minimize the amount of redo generated by Oracle. Only 
the following operations can make use of nologging: 

SQL*Loader in direct mode 
INSERT /*+APPEND*/ ... 
CTAS 
ALTER TABLE statements (move/add/split/merge partitions) 
CREATE INDEX 
ALTER INDEX statements (move/add/split/merge partitions)  

Nothing of this is used when ARS is archiving records.




-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Guillaume Rheault
Gesendet: Mittwoch, 13. Januar 2010 23:20
An: arslist@ARSLIST.ORG
Betreff: Re: Is there a way to set an Oracle nologging option for Remedy 
Archiving process?

This is true if the instance or the tablespace has been configured to force 
logging.
Otherwise it should work. 

have you tested this scenarios?

Guillaume


From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on 
behalf of Conny Martin [conny.mar...@t-systems.com]
Sent: Wednesday, January 13, 2010 4:36 PM
To: arslist@ARSLIST.ORG
Subject: AW: Is there a way to set an Oracle nologging option for Remedy 
Archiving process?

This will not have any effect.

see http://www.orafaq.com/wiki/Nologging_and_force_logging

ARS does normal update's, insert's or delete's and this is always logged in the 
redo-logs.

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Guillaume Rheault
Gesendet: Mittwoch, 13. Januar 2010 21:49
An: arslist@ARSLIST.ORG
Betreff: Re: Is there a way to set an Oracle nologging option for Remedy 
Archiving process?

You need to find out the schemaid in the arschema table related to your form.
Once you do that, you need to issue a sql statement through SQL Plus, Toad or 
SQL Developer, like this one


SQL alter table T12345 nologging;

Guillaume

From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on 
behalf of Pruitt, Christopher (Bank of America Account) 
[christopher.pru...@hp.com]
Sent: Wednesday, January 13, 2010 3:40 PM
To: arslist@ARSLIST.ORG
Subject: Is there a way to set an Oracle nologging option for Remedy Archiving 
process?

Issue Details:
Is there a way to set the nologging option on the Remedy Archive tables when 
the Remedy archival process is running to disable the Oracle Archiving logging?


We need to ensure that it Oracle doesn't generate Oracle archive logs for the 
Remedy Archiving table when we are pushing data from the data tables to the 
archive tables. We are having issues where the tablespace growth is directly 
proportional to the number of records being archived. If there are more records 
archived,  more tablespace growth. In this case since Remedy archiving process 
would insert on to the Remedy archived tables, the number of Oracle archive 
logs increase. Last month we ran Remedy Archiving and it generated over 1.5 gb 
of Oracle Archiving logs in a matter of just a few hours.

Environment

Remedy version 7.1.00 Build 200708221849 Oracle 10.2.0.4.0 - 64bi OS SunOS 5.9


Christopher Pruitt
Business Consulting III
HP Enterprises Services
christopher.pru...@hp.commailto:mary.jo...@hp.com
www.hp.comhttp://www.hp.com/

Confidentiality Notice: This message and any files transmitted with it are 
intended for the sole use of the entity or individual to whom it is addressed, 
and may contain information that is confidential, privileged, and exempt from 
disclosure under applicable law. If you are not the intended addressee for this 
e-mail, you are hereby notified that any copying, distribution, or 
dissemination of this e-mail is strictly prohibited. If you have received this 
e-mail in error, please immediately destroy, erase, or discard this message. 
Please notify the sender immediately by return e-mail if you have received this 
e-mail by mistake.




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

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

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

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

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

AW: Can't sort table field column

[Conny Martin]

William,
 
check the field lengths of the table fields source columns. If it goes
beyond 255 you can't sort on these columns.
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Martinez, Marcelo A
Gesendet: Montag, 21. Dezember 2009 17:09
An: arslist@ARSLIST.ORG
Betreff: Re: Can't sort table field column


** 

William,

I know this doesn't tell you what the issue is... but a possibility
could be to use Remedy Migrator. The good thing about Migrator is that
you can import (from Dev to Prod) just the table and not the entire
form.

 

Hope this helps.

 

Marcelo 

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of William Rentfrow
Sent: Friday, December 18, 2009 1:16 PM
To: arslist@ARSLIST.ORG
Subject: Can't sort table field column

 

** 

We have a table field which has (among other things) the description
from the Incident in IM 7.03. 

On both our Development and test environments we can sort by clicking
the field header in the table.  We can NOT in the production server.  We
don't get the ascending/descending arrow and it does not sort.

The forms are synced.  The table field source forms are synced.  As far
as I can tell nothing is different? 

Anyone have a clue here?  

William Rentfrow 
Principal Consultant, StrataCom Inc. 
wrentf...@stratacominc.com 
O 715-592-5185 
C 715-410-8056 

_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

AW: View form from Oracle based AR system to remote MS SQL server

[Conny Martin]

Victor,
 
running only the insert statement from sqlplus is not the whole story. 
 
If you create an entry through ARS there are a bunch of statements which
gets executed. Immediately before the insert are 2 statements to
generate the request_id. You should see something like this in your
sql-logfile.
 
update arschema set nextid = nextid + 1 where schemaid = ;
select nextid from arschema where schemaid = ;
insert into T (cxxx,cyyy,czzz) values ('x','y','z');
 
Try to run these 3 in sqlplus. IMHO error  ORA-02047 indicates some
problem with handling distributed transactions. If this sequence of
statements generates an error in sqlplus try a commit; after the first 2
statements. If this solves the problem you can set Next-ID-Commit: T
in ar.conf. This causes ARS to issue a commit after generating the
nextid.
 
HTH
 
Kind Regards Conny
 
 



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Victor Olufowobi
Gesendet: Sonntag, 13. Dezember 2009 09:41
An: arslist@ARSLIST.ORG
Betreff: Re: View form from Oracle based AR system to remote MS SQL
server


** 

Thanks again Joe,

I will try what you suggested and have the outcome posted - but I want
you to consider the following:
- I can update without problem using the view form created. It's when
I'm inserting (CREATE operation) the error occurs
- I can successfull run the INSERT command ARS is trying to run from
sqlplus 

Victor

On Sat 12/12/09 14:56 , Joe D'Souza jdso...@shyle.net sent:


Victor,

Well that's half the battle won then.. Yes MS-SQL can be weird
when it comes
to case sensitivity of view names and columns within views
even.. For e.g.
if your ARS was hosted on a MS-SQL server, and the view name was
in small
case and you tried creating a view form in upper case, it would
not
recognize that name. There is a way to override that case
sensitivity but we
won't deal with that since you already updated the view to have
it upper
cased..

This is what I found for ORA-02047.

http://ora-02047.ora-code.com/ http://ora-02047.ora-code.com/ 

Based on the clue provided with the explanation of the error
code, can you
the Run Process Application-Release-Pending just an action
before updating
the MS-SQL view data in your workflow - and if that does not
work the same
action after the update action to that DB-Link? I'm assuming
that will force
any pending commits before (or if necessary after) you try
updating the
external view using that DB-Link in light of what the article in
the above
link says..

If that does not work (and the commit is required while and not
before or
after the update), try writing a stored procedure that has a
commit inside
of it - e.g..

BEGIN
update tablen...@. set ... where ...;
commit;
END;

Use that stored procedure in a direct SQL at the point where you
want to run
that update to the foreign database. Make sure that you declare
all the
variables that you need while defining the stored procedure.

Let me know how it goes..

Cheers

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[arsl...@arslist.org]on Behalf Of Victor
Sent: Saturday, December 12, 2009 3:48 AM
To: arslist@ARSLIST.ORG
Subject: Re: View form from Oracle based AR system to remote MS
SQL
server


On Thursday 10 December 2009 21:16:14 Joe D'Souza wrote:
 Hello Victor,

 That is what I suspected with the invalid identifier error..
if your table
 was not recognized it would be invalid table or view name
error which is
 not your case.. Which is why the later part of my previous
email holds
 good.. Take a SQL log, you may find that offending column name
or
columns..

 There is something in the way that ARS is naming the offending
column or
 columns causing that error..

 When you find what column it is email the list or me directly
and we'll
try
 to figure it out.. you might need to create a independent view
in MS-SQL
of
 that table having names of fields that are legal to use in
case there is a
 column name there that the ARS converts into something else..
This is just
 a speculative solution, we'll know more when you know more..

 Cheers

 Joe

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [arsl...@arslist.org]on Behalf Of Victor
 Sent: Thursday, December 10, 2009 3:00 PM
 To: 

Get result from stored procedure

[Conny Martin]

All,

Not sure if this is possible, but is there a way to get the results from
a stored procedure via set-field-sql into ars.

This works in Query-Analyzer

declare @p_result int 
exec SP_TEST 'MDP00072713', @p_result output 
select @p_result

But in a set-fields-sql $1$ is always null.

ARS 7.1p6
MSSQL 2005
W2K3 Enterprise Server

Any help is really appreciated.

Thanks

Conny

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

AW: Get result from stored procedure

[Conny Martin]

Joe,

I'm calling it the same way as in Query Analyzer.

declare @p_result int
exec SP_TEST 'MDP00072713', @p_result output 
select @p_result

No Errormessage is returned but $1$ doesn't get the value from p_result

With oracle there is no problem. One can just do
select sp_test('MDP00072713') from dual
but I don't know the correct syntax for MS-SQL.

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Joe D'Souza
Gesendet: Donnerstag, 10. Dezember 2009 10:32
An: arslist@ARSLIST.ORG
Betreff: Re: Get result from stored procedure

Conny,

Yes it is possible.. how are you calling/executing the stored procedure when 
you are using it in the set-field-sql?

Begin procedure name;
works from the ARS with Oracle as the backend DB.. (I'm not 100% certain if you 
need the semi colon in the end)

I'm not sure if that would work with MS-SQL as well but you could try that..

Joe

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org]on Behalf Of Conny Martin
Sent: Thursday, December 10, 2009 3:08 AM
To: arslist@ARSLIST.ORG
Subject: Get result from stored procedure


All,

Not sure if this is possible, but is there a way to get the results from a 
stored procedure via set-field-sql into ars.

This works in Query-Analyzer

declare @p_result int
exec SP_TEST 'MDP00072713', @p_result output select @p_result

But in a set-fields-sql $1$ is always null.

ARS 7.1p6
MSSQL 2005
W2K3 Enterprise Server

Any help is really appreciated.

Thanks

Conny

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

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

Resolved: Get result from stored procedure

[Conny Martin]

Frank,
 
great, it works.
 
Thank you for your assistance.
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Frank Caruso
Gesendet: Donnerstag, 10. Dezember 2009 11:32
An: arslist@ARSLIST.ORG
Betreff: Re: Get result from stored procedure


** 
I have created Functions in MS SQL that return values. You call them like this:
 
select fn_test 'param1','param2'
 
Specificy a return field for $1$.
 
For a Stored Procedure, to obtain the return result, which I am assuming will 
tell you whether or not the procedure succeeded or failed, put a select 
statement directly before the  return 1 statement. Select the value you would 
like returned. Then you call the proc from like this:
 
exec sp_testproc 'param1'
 
It might not be the correct way but it seems to work

 
On Thu, Dec 10, 2009 at 1:14 PM, David Morgan dave.mor...@tiberone.com wrote:


Hi Conny/Joe

Not sure if it helps but MS SQL doesn't require any helper table so 
where in Oracle you might use:-

   Select sysdate from dual ;

In MS-SQL you could use

   select getsysdate

Perhaps you can do something similar with your SP?

   Select sp


Failing that - you could use a sledgehammer to crack the nut and use a 
Java JDBC program to launch the SP and write out the result (ie use Java the 
Java program to glue the two together?)

ARS   -- Java program --   JDBC   -- Database (Oracle/SQL 
SERVER/SYBASE/INFORMIX etc)

Regards
Dave Morgan


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
Sent: 10 December 2009 11:05
To: arslist@ARSLIST.ORG
Subject: Re: Get result from stored procedure

There is a small difference on how you call stored procedures while 
using
either the direct SQL or the set field SQL feature from the ARS at 
least as
far as Oracle is concerned.. When using the Oracle client SQL*Plus, 
Execute
procedure name works, but from the ARS interface for SQL, EXECUTE 
doesn't
work. This I believe is because the ARS does not use the extended set 
of the
database API that SQL*Plus uses.

So in Oracle instead of using EXECUTE you use BEGIN. However no error is
returned if you use EXECUTE. It just ignores it and doesn't do anything.

I'm guessing your problem with MS-SQL is something similar.. Only I'm 
not
sure if Begin would be the right keyword to execute a SP if the 
underlying
DB is MS-SQL..

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Conny Martin
Sent: Thursday, December 10, 2009 4:48 AM
To: arslist@ARSLIST.ORG
Subject: AW: Get result from stored procedure


Joe,

I'm calling it the same way as in Query Analyzer.

declare @p_result int
exec SP_TEST 'MDP00072713', @p_result output
select @p_result

No Errormessage is returned but $1$ doesn't get the value from p_result

With oracle there is no problem. One can just do
select sp_test('MDP00072713') from dual
but I don't know the correct syntax for MS-SQL.

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Joe D'Souza
Gesendet: Donnerstag, 10. Dezember 2009 10:32
An: arslist@ARSLIST.ORG
Betreff: Re: Get result from stored procedure

Conny,

Yes it is possible.. how are you calling/executing the stored procedure 
when
you are using it in the set-field-SQL?

Begin procedure name;
works from the ARS with Oracle as the backend DB.. (I'm not 100% 
certain if
you need the semi colon in the end)

I'm not sure if that would work with MS-SQL as well but you could try 
that..

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Conny Martin
Sent: Thursday, December 10, 2009 3:08 AM
To: arslist@ARSLIST.ORG
Subject: Get result from stored procedure


All,

Not sure if this is possible, but is there a way to get the results 
from a
stored procedure via set-field-SQL into ars.

This works in Query-Analyzer

declare @p_result int

AW: How to implement HA architecture?

[Conny Martin]

There's an open source solution not limited to web traffic.

www.linuxvirtualserver.org

We're using this as a load balancer for ARS and Web-Servers and it works like a 
charm.

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Axton
Gesendet: Samstag, 5. Dezember 2009 23:26
An: arslist@ARSLIST.ORG
Betreff: Re: How to implement HA architecture?

There are many other solutions that are just as viable.  The concept is that of 
a reverse proxy and/or a load balancer.

BigIP has gone to lengths to:
1. add bells and whistles to their devices to make the configuration, 
administration, and maintenance as easy as possible.
2. choose the best hardware for the job at hand

They are in essence the 800lb gorilla in this arena.

The BigIP LTM's run on a Linux kernel; they used to run on a BSD kernel.

There are a number of open source programs that implement similar functionality 
and there are other vendors that offer competitive
products:
Open Source: squid, varnish, ...
Proprietary: Cisco ACE, Radware AppDirector, Barracuda Load Balancer, ...

The open source offerings are generally limited to web traffic (http/https).

There is a lot to be gained by the hardware in these types of devices 
(performance, scalability, reliability, capability) and as such they are 
generally marketed and sold as network appliances, not a software solution; an 
area that the open source model does not address very well.

See here for more information:
http://en.wikipedia.org/wiki/Reverse_proxy
http://blog.loadbalancer.org/load-balancer-comparison-a-refreshingly-simple-comparison-of-load-balancing-hardware-specifications/

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, Dec 5, 2009 at 7:08 AM, Martin Liu liuz...@gmail.com wrote:
 ** Axton,

 Thank you very much!

 Finial questions:

 does this means F5 is the only possible HA solution for Remedy system?

 If the customer don't have F5 for this project, is there any HA 
 solution existing?

 Regards,
 Martin


 2009/12/5 Axton axton.gr...@gmail.com

 You can create many farms on a single F5 (of any type you choose).  
 If one arserver is down, things should just keep working as if 
 nothing were wrong.  If you are going with a farm with many active 
 nodes, I do not see the need for MS Clustering.

 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, Dec 5, 2009 at 2:49 AM, Martin Liu liuz...@gmail.com wrote:
  ** Thanks you all!
 
  I learned a lot from you guys. But I still got something to confirm.
 
  What I have: 1) 4 physical machines MS Windows OS(2 for Mid-tier, 2 
  for ARS); 2) One physical F5 device; 3)One Oracle RAC hosting DB 
  for ARS. My customer is primarily using Web client.
 
  Q1)Can I create two farms on one single F5 device? one for 
  Mid-tier; one for ARS.  Does this configuration have HA capability 
  for ARS? I mean if one ARS server down, the whole system is still 
  working.
 
  Q2)Does MS cluster provide one single entry and HA function for two 
  ARS servers? I mean two ARS servers within one server group. If one 
  ARS server down, MS cluster will switch to another ARS server. And 
  this server will still pick up Administrative Operations, 
  Escalation, Reconciliation, etc...
  Does MS cluster service equal to a F5 device from HA point view?
 
  I will post F5 device model that you may know.
 
  Best regards!
  Martin
 
 
 
 
  2009/12/5 Kelly Deaver kdea...@kellydeaver.com
 
  **
  You may find this presentation handy as well. It was my attempt to 
  pull together the info in all the various install manuals -
  http://communities.bmc.com/communities/docs/DOC-2841
 
  Kelly Deaver
  Effective Technologies
  www.effect-tech.com
 
  kdea...@kellydeaver.com (ARSlist mail) ke...@effect-tech.com 
  (Business mail)
 
 
 
   Original Message 
  Subject: Re: How to implement HA architecture?
  From: Garrison, Sean (Norcross) sean.garri...@fiserv.com
  Date: Fri, December 04, 2009 3:12 pm
  To: arslist@ARSLIST.ORG
 
  True high availability allows your server to still be up and 
  running if one of the locations goes down. This is pretty much 
  impossible with remedy because the app server is highly dependent 
  on the connection to the db.
  We
  tried it with one of our remote locations and it took 45 minutes 
  just for one app server to start because the DB was located in 
  Georgia and the App 

AW: ARSPERL on RHEL to talk to ARS 6.3?

[Conny Martin]

we've done this many times.

with ARSPerl1.91 you can use ARS libraries up to 7.1. But you need to have a 
32bit Perl, because the ARS libraries are 32bit.

HTH 

Kind Regards Conny 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Rabi Tripathi
Gesendet: Freitag, 4. Dezember 2009 20:06
An: arslist@ARSLIST.ORG
Betreff: ARSPERL on RHEL to talk to ARS 6.3?

Is anybody doing this? 
Has anybody successfully complied ARSPerl on Red Hat Enterprise Linux 4 or 5 ? 
I believe we have 64bit servers.

ARSPerl 1.9 install guide talks about needing ARS 2-5 API libraries. However 
arsperl.org web site talks about being compatible with ARS 7.1. Does anybody 
know if that means ARSPerl can use 7.1 libraries or that ARSPerl using older 
ARS libraries can talk to ARS 7.1?

I need to move ARSPerl setup from a solaris box to RHEL box. The ARS server is 
6.3, so I think I need 6.3 ARS libraries or earlier to work on RHEL. Not sure 
if such libraries exist.

TIA.


  

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

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

AW: Advanced Search/field ID?

[Conny Martin]

1005
 
IMHO you have to add this field to your form to be able to reference it
in workflow.
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Barber, David
Gesendet: Montag, 23. November 2009 16:41
An: arslist@ARSLIST.ORG
Betreff: Advanced Search/field ID?


** 
All,
 
I'm sure I've done something like this before, but can't find the
details ...
 
The advanced search criteria has a field ID, doesn't it - so that you
can query over what is, er, being queried?  I can't for the life of me
find the details of the field ID in question.
 
Regards
 
Dave Barber

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 you are not named above as a recipient, you must not
read, copy, disclose, forward or otherwise use the information contained
in this email. If you have received this e-mail in error, please notify
the sender (whose contact details are above) immediately by reply e-mail
and delete the message and any attachments without retaining any copies.

Cable and Wireless plc 
Registered in England and Wales.Company Number 238525 
Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: Firewall TCP Timeouts

[Conny Martin]

We had the same issue. We solved this by using libkeepalive 
(http://libkeepalive.sourceforge.net/) on the arserver machine. But it would 
work only if you are using Linux.

HTH 

Kind Regards Conny 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Leihkauff, Kenneth
Gesendet: Mittwoch, 18. November 2009 18:18
An: arslist@ARSLIST.ORG
Betreff: Re: Firewall TCP Timeouts

Thanks for your time, Axton.  I spoke with our network engineer and he studied 
the firewall logs and sees quit a few denials and some resets, but is confident 
things should be set up correctly on the firewall.  He only sees these 
denials/resets for the Midtier application, not some of our other apps.  

Here is what we're observing on the Linux Midtier server.  Below is an example 
of 3 existing tcp connections that remain intact indefinitely or until midtier 
is restarted.  The firewall knows about these 3 tcp connections, but if the 
connections are idle for more than 60 minutes (default firewall setting), the 
firewall will drop these idle tcp connections.  Then, when a user gets on 
midtier (after the idle period), midtier will attempt to use one or more of 
these tcp connections and the firewall responds with a Deny (since it has aged 
off the inactive connection).  This is normal behavior for a firewall as I 
understand things, but the application (midtier in this case) should ideally 
make use of the tcp keepalive or inactivetly timeout supported by Linux.  
Apparently, midtier does not take advantage of this.

I suspect other customers are having this problem IF their topology utilizes a 
firewall between Midtier and ARS and there are long periods of inactivity.  The 
reason, however, they may not be complaining is because once you get the RCP 
failure (arerr 91), then subsequent connections seem to work fine.  For the 
example below, once the arerr 91 timeout finally occurred, the associated tcp 
connection was terminated on the midtier server and a new one was created.  

$netstat -antopp|grep 2031
Proto Recv-Q Send-Q Local Address   Foreign Address 
State   Timer
tcp0  0 :::172.16.0.129:54310   :::10.1.1.141:2031  
ESTABLISHED 24977/java  off (0.00/0/0)
tcp0864 :::172.16.0.129:54309   :::10.1.1.141:2031  
ESTABLISHED 24977/java  on (3.59/12/0)
tcp0   1416 :::172.16.0.129:43717   :::10.1.1.141:2031  
ESTABLISHED 24977/java  on (16.19/11/0)

After a very long wait trying to login in, the user will receive this message:
ARERR [91]
RPC call failed : ONC/RPC call timed out


Ken 


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Axton
Sent: Tuesday, November 17, 2009 3:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Firewall TCP Timeouts

You need to configure your firewall properly.  With a firewall, you can define 
what types of packets can create a state entry on the firewall.  Typical is 
syn, syn ack.  Even if there is no state entry, a new packet should create a 
new state (not be dropped).  If a new packet does not create a new state, 
change the firewall rules so that it does.  A network dump will tell you what 
type of packet is going out; the firewall logs should tell you what type of 
packet was rejected.

I could see that this would be a problem if the midtier servers were behind a 
NAT.  Is this the case?

Axton Grams

On Tue, Nov 17, 2009 at 12:07 PM, Leihkauff, Kenneth 
kenneth.g.leihka...@saic.com wrote:
 **

 Hello,



 We have a firewall between our MidTier server and ARS system.  The 
 firewall is configured to drop tcp connections after being idle for 60 
 minutes (typical/default firewall setting).  Several MidTier user 
 sessions will make use of a shared tcp connection so you might have 
 100 sessions but significantly fewer tcp connections.  During idle 
 times (like at night), the firewall will discard these idle tcp 
 connections but the MidTier server will still retain these tcp 
 references (this can be seen by using netstat -anto).  So, when 
 users get back on the system, MidTier apparently is trying to utilize 
 one of these defunct tcp connections so you end up with problems like 
 ARERR 91 rpc timeouts because these tcp connections are broken pipes.



 Is there a MidTier/Tomcat or other setting that you have found 
 addresses this problem?



 Thanks.



 Ken



 Background:

 Version 7.5 patch 3

 MidTier - Linux, Tomcat JSP

 ARS - Linux, Oracle 10g

 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the 
 Answers Are_

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

___
UNSUBSCRIBE 

AW: Oracle in-row LOB storage issue - IM 7.03

[Conny Martin]

William,

here's an excerpt out of the oracle docs



Choosing the Value of CHUNK
Once the value of CHUNK is chosen (when the LOB column is created), it cannot 
be changed. Hence, it is important that you choose a value which optimizes your 
storage and performance requirements.

Space Considerations
The value of CHUNK does not matter for LOBs that are stored inline. This 
happens when ENABLE STORAGE IN ROW is set, and the size of the LOB locator and 
the LOB data is less than 4000 bytes. However, when the LOB data is stored 
out-of-line, it will always take up space in multiples of the CHUNK parameter. 
This can lead to a large waste of space if your data is small, but the CHUNK is 
set to a large number. The following table illustrates this point:

Table 4-4 Data Size and CHUNK Size

Data Size   CHUNK Size  Disk Space Used 
to Store the LOBSpace Utilization (Percent) 
3500 enable storage in row  irrelevant  3500 in row 
100 
3500 disable storage in row 32 KB   32 KB   
10 
3500 disable storage in row 4 KB4 KB
90 
33 KB   32 KB   64 KB   
51 
2 GB +1032 KB   2 GB + 32 KB
99+  



HTH

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von William Rentfrow
Gesendet: Mittwoch, 18. November 2009 18:50
An: arslist@ARSLIST.ORG
Betreff: Re: Oracle in-row LOB storage issue - IM 7.03

Thanks for all the responses.

I'm trying to reconcile our db size usage (53% of 47 MB after some 
re-structuring) with BMC's in-row examples.

The in-row examples (from Oracle) in their docs mention a table with 43000+ 
with 32000+ of those having LOB entries and a size of ~261 MB.

Even if I give Remedy a 50% fudge factor and bump that number to 390 (heck, 
let's go 400) we are using nearly 100X the space.  And we only have 10X the 
records.  

All LOBS are now confirmed (again) as being in-row - waiting for BMC..and any 
bright ideas from the list.  DBA is working on your suggestions to determine 
where exactly all the space has gone.

William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
O 715-592-5185
C 715-410-8056

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Wednesday, November 18, 2009 11:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle in-row LOB storage issue - IM 7.03

I should have posted my output:
   select SEGMENT_NAME, bytes
   from USER_SEGMENTS
   Where SEGMENT_NAME in (select SEGMENT_NAME from USER_LOBS where TABLE_NAME 
like '_10' or TABLE_NAME like '_10C%')
   orSEGMENT_NAME like '_10'
   orSEGMENT_NAME like '_10C%'

   SEGMENT_NAMEBYTES
   -- --
   B10   1048576
   H10   2097152
   T10   2097152
   SYS_LOB039519C00010$$ 1048576
   SYS_LOB039519C00012$$ 1048576

You can verify the In Row of your CLOB data with:
   select TABLE_NAME, COLUMN_NAME, SEGMENT_NAME, IN_ROW
   from USER_LOBS
   where TABLE_NAME like '_10' or TABLE_NAME like '_10C%'

   TABLE_NAME  COLUMN_NAME  SEGMENT_NAME   IN_ROW
   ---  -- ---
   T10 C536870915   SYS_LOB039519C00012$$  YES
   T10 C536870913   SYS_LOB039519C00010$$  YES

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Wednesday, November 18, 2009 11:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle in-row LOB storage issue - IM 7.03

Wow... I actually have something to disagree with Axton on ...

If you create a form (since v6x) Remedy no longer uses the BtttCccc 
structure to hold the long character fields.  I am on 7.1.0 patch 7 with Oracle 
10g and all of my CLOB columns are just columns in the normal table.

   SQL describe T10;
Name Null?Type
  ---
C1   NOT NULL VARCHAR2(15)
C2VARCHAR2(254)
C3   NOT NULL NUMBER(15)
C4VARCHAR2(254)
C5   NOT NULL VARCHAR2(254)
C6   NOT NULL NUMBER(15)
C7   NOT NULL NUMBER(15)
C8   NOT NULL VARCHAR2(128)
C536870912VARCHAR2(255)
C536870913CLOB
C536870914NUMBER(15)
C536870915CLOB
C536870916NUMBER(15)
C536870921VARCHAR2(4000)
C536870924

AW: Firewall TCP Timeouts

[Conny Martin]

on the arserver! 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Leihkauff, Kenneth
Gesendet: Mittwoch, 18. November 2009 22:51
An: arslist@ARSLIST.ORG
Betreff: Re: Firewall TCP Timeouts

Thanks, Conny. Are you saying the libkeepalive was implemented on the ARserver 
-- not the MidTier linux server? Our midtier and arserver are linux with a 
firewall in between.  

Unfortunately, the firewall is not an application level firewall so the 
firewall rule changes Axton proposed cannot be implemented according to our 
network engineer.

Ken 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Conny Martin
Sent: Wednesday, November 18, 2009 3:30 PM
To: arslist@ARSLIST.ORG
Subject: AW: Firewall TCP Timeouts

We had the same issue. We solved this by using libkeepalive 
(http://libkeepalive.sourceforge.net/) on the arserver machine. But it would 
work only if you are using Linux.

HTH 

Kind Regards Conny 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Leihkauff, Kenneth
Gesendet: Mittwoch, 18. November 2009 18:18
An: arslist@ARSLIST.ORG
Betreff: Re: Firewall TCP Timeouts

Thanks for your time, Axton.  I spoke with our network engineer and he studied 
the firewall logs and sees quit a few denials and some resets, but is confident 
things should be set up correctly on the firewall.  He only sees these 
denials/resets for the Midtier application, not some of our other apps.  

Here is what we're observing on the Linux Midtier server.  Below is an example 
of 3 existing tcp connections that remain intact indefinitely or until midtier 
is restarted.  The firewall knows about these 3 tcp connections, but if the 
connections are idle for more than 60 minutes (default firewall setting), the 
firewall will drop these idle tcp connections.  Then, when a user gets on 
midtier (after the idle period), midtier will attempt to use one or more of 
these tcp connections and the firewall responds with a Deny (since it has aged 
off the inactive connection).  This is normal behavior for a firewall as I 
understand things, but the application (midtier in this case) should ideally 
make use of the tcp keepalive or inactivetly timeout supported by Linux.  
Apparently, midtier does not take advantage of this.

I suspect other customers are having this problem IF their topology utilizes a 
firewall between Midtier and ARS and there are long periods of inactivity.  The 
reason, however, they may not be complaining is because once you get the RCP 
failure (arerr 91), then subsequent connections seem to work fine.  For the 
example below, once the arerr 91 timeout finally occurred, the associated tcp 
connection was terminated on the midtier server and a new one was created.  

$netstat -antopp|grep 2031
Proto Recv-Q Send-Q Local Address   Foreign Address 
State   Timer
tcp0  0 :::172.16.0.129:54310   :::10.1.1.141:2031  
ESTABLISHED 24977/java  off (0.00/0/0)
tcp0864 :::172.16.0.129:54309   :::10.1.1.141:2031  
ESTABLISHED 24977/java  on (3.59/12/0)
tcp0   1416 :::172.16.0.129:43717   :::10.1.1.141:2031  
ESTABLISHED 24977/java  on (16.19/11/0)

After a very long wait trying to login in, the user will receive this message:
ARERR [91]
RPC call failed : ONC/RPC call timed out


Ken 


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Axton
Sent: Tuesday, November 17, 2009 3:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Firewall TCP Timeouts

You need to configure your firewall properly.  With a firewall, you can define 
what types of packets can create a state entry on the firewall.  Typical is 
syn, syn ack.  Even if there is no state entry, a new packet should create a 
new state (not be dropped).  If a new packet does not create a new state, 
change the firewall rules so that it does.  A network dump will tell you what 
type of packet is going out; the firewall logs should tell you what type of 
packet was rejected.

I could see that this would be a problem if the midtier servers were behind a 
NAT.  Is this the case?

Axton Grams

On Tue, Nov 17, 2009 at 12:07 PM, Leihkauff, Kenneth 
kenneth.g.leihka...@saic.com wrote:
 **

 Hello,



 We have a firewall between our MidTier server and ARS system.  The 
 firewall is configured to drop tcp connections after being idle for 60 
 minutes (typical/default firewall setting).  Several MidTier user 
 sessions will make use of a shared tcp connection so you might have 
 100 sessions but significantly fewer tcp connections.  During idle 
 times (like at night), the firewall will discard these idle tcp 
 connections but the MidTier server will still retain these tcp

AW: Connection timed out. Message number = 90 in ars 5.1

[Conny Martin]

I would suggest to use driver to check if you can connect to the
arserver.
 
here's a sample driver session. Things that I typed in are marked red
 
arad...@affhc126:/mnt/mnt1/arsbin/IN2ARIM1
/apps/ars/ars512p1494/api/src/driver/driver
 
 AR System API Driver
 
 Active Link   Escalation  FilterEntry   Entry
 ---   --  ---   -
 get(gal)  get(ges)get(gf)   get   (ge)  merge
(me)
 set(sal)  set(ses)set(sf)   set   (se)  stats
(stat)
 create (cal)  create (ces)create (cf)   create(ce)  get BLOB
(geb)
 delete (dal)  delete (des)delete (df)   delete(de)  getmult
(gme)
 getlist(glal) getlist(gles)   getlist(glf)  getlist   (gle)
 getmult(gmal)   getlistw/f(glewf)
 
 Container Schema  Char Menu Schema FieldVUI
 - --  - ---
 get(gco)  get(gs) get(gc)   get (gsf)   get(gv)
 set(sco)  set(ss) set(sc)   set (ssf)   set(sv)
 create (cco)  create (cs) create (cc)   create  (csf)   create (cv)
 delete (dco)  delete (ds) delete (dc)   delete  (dsf)   delete (dv)
 getlist(glco) getlist(gls)getlist(glc)  getlist (glsf)
getlist(glsv)
   gls w/a(glsa)   expand (ec)   getmult (gmsf)
   getmult(gms)exp ssm(essm) delmult (dmsf)
   getlist ext(glxsc)getmult ext cands(gmxfc)
 
 License   Alert   Info  Encode/Decode
Thread/Timer
 ---   -     -

 val(vl)   create   (cae)  get svr (gsi) enquery(ecqal)  launch
(lt)
 valmult(vml)  register (rfa)  set svr (ssi) dequery(dcqal)  launch wait
(lwt)
 getlist(gll)  deregistr(dfa)  get FT  (gft) enassig(ecasn)  release
wait(rwt)
 create (cl)   gla user (glau) set FT  (sft) deassig(dcasn)  sleep
(st)
 delete (dl)   get count(gac)  get stat(gss) echstry(echst)  random
sleep(rst)
   decode   (dcam)   ecdiary(ecdia)  msec sleep
(msst)
 
 Init/Term Control/Logging Misc ListsMiscMisc
 - --- --
 init  (init)  record   (rec)  server(svr)   ver user (ver)  get file
(gfl)
 term  (term)  stop rec (srec) group (glg)   export   (exp)  set file
(sfl)
 help  (h, ?)  open out (oout) user  (glu)   import   (imp)  get errmsg
(gem)
 exit  (e, q)  close out(cout) sql   (glsql) exec proc(proc) set
logging(slog)
 login (log)   execute  (ex)   sql al(sqlal) exec p al(epal) close conn
(cnc)
 dr ver(dver)  bgn loop (bl) load qual(lqs)  valid
cache(vfc)
   end loop (el) set port (ssp)  signal
(sig)
 
 Complex Entry Session Config  Localized Val DateCurrency
Ratio
 - --  - 
--
 create(xmlce) get conf(gsc)   get(glv)  ecdate (ecdat)  getmult
sets(gmcrs)
 get   (xmlge) set conf(ssc)   getmult(gmlv) dcdate (dcdat)  get ratio
(gcr)
 set   (xmlse)
 
 
Command: init
INITIALIZATION
 
   ARInitialization  results
ReturnCode:  OK
Status List : 0 items
 
Command: log
Control record:
   Authentication string () :
   User name () : xxx
   Password () : xx
   Language () :
   Server () : arsim1.telekom.de
 
Command: ver
VERIFY USER
 
   ARVerifyUser  results
ReturnCode:  OK
Admin flag:  TRUE
SubAdmin flag:  FALSE
Customize flag:  TRUE
Status List : 0 items

 
 
HTH Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von LJ Longwing
Gesendet: Donnerstag, 12. November 2009 17:24
An: arslist@ARSLIST.ORG
Betreff: Re: Connection timed out. Message number = 90 in ars 5.1


** 
I saw a post yesterday discussing port mapper that suggested it's port
111



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Llinares, Jordi
Sent: Thursday, November 12, 2009 7:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: Connection timed out. Message number = 90 in ars 5.1


** 
Hi Ben,
 
When I telnet I use 3 port which is actually the default one. When I
have tried in windows like in linux, I do not specify any port, I type
netstat -an and I see 3 port. 
 
I have set ARTCPPORT=3 and it doesn't work. I'm gonna look for that
thread, if you find it, please, post it here cause I'm desperated.
 
 
Thanks so much,
Jordi




From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Ben Chernys
Sent: jueves, 12 de noviembre de 2009 14:15
To: arslist@ARSLIST.ORG
Subject: Re: Connection timed out. Message number = 90 in ars 5.1


** 
When you telnet, what port did you specify?  Looks like you do have a
port set on your ARS server.  Port Mapper goes though a special UDP
port.  Don't know 

AW: Load Balancer setup with remedy

[Conny Martin]

Hi,

there is no default port number. If you don't configure a port in WUT or WAT 
then the client tries to use the portmapper to determine the correct port. You 
have to create a rule for Port 111(UDP) to be directed to rem1 or rem2.

This works for us.

It should look something like this

   remedyvip:44629remedyvip:111(UDP)
  |  |
  |  |
  |  |
 / \/ \
/   \  /   \
   / \/ \
 rem1:44629  rem2:44629   rem1:111(UDP) rem2:111(UDP)


HTH

Kind Regards Conny


-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von patchsk
Gesendet: Mittwoch, 11. November 2009 10:07
An: arslist@ARSLIST.ORG
Betreff: Load Balancer setup with remedy

Hi,
We are trying to setup Load balancer in our new environement.
We created a 'remedyvip' for loadbalancer and created rules to route the 
traffic to rem1/rem2 arservers  which use 44629 as the tcp port.

But we don't want to use the port number with the vip.
That is any connection coming to remedyvip (port is optional and can be null or 
anything) should be directed to rem1 or rem2 and to port:
44629

Our SA told the CSS rules are written to look at connections coming to
44629 and direct those connections to rem1 or rem2.
He does not know how to configure CSS rules so that any connection coming to 
remedyvip to be directed to rem1 or rem2 to port 44629.

We tried enabling the portmapper in rem1/rem2 but still does not work with 
remedyvip, it did work when we use the actual server name to login with no port 
number.

What is the default port remedy user tool uses when no port number is specified?
Any one has this kind of setup and some hints?

Thanks,
Vamsi

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

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

AW: Looooooooooong update times on ARSCHEMA

[Conny Martin]

William,
 
this looks like a locking issue. Perhaps some other threads has also
updated this row but hasn't commited yet.
 
There is a parameter you can set in ar.conf
 
Next-ID-Commit: T
 
When the system generates the next ID number for a record in the
database, it performs a new commit transaction if this parameter is set
to T
(true). If the parameter is set to F (false), the transaction to
generate the next
ID is included as part of the create entry transaction. Set the value to
T to
increase efficiency and for debugging. The default is F.
This option does not work with Informix databases.
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von William Rentfrow
Gesendet: Mittwoch, 4. November 2009 19:39
An: arslist@ARSLIST.ORG
Betreff: Looong update times on ARSCHEMA


** 
Listers...
 
I was helping a person who contacted me look at a performance problem.
I do not have access to the system.
 
It appears the update to ARSCHEMA that is called by the CE API call is
taking forever for just ONE record.  In other words when this executes:
 
UPDATE arschema SET nextId = nextId + 1 WHERE schemaId = xxx
 
...it works fine for all but 1 row.  Most rows complete in 0.01 seconds
or less.  The troublesome row update can take 90 seconds or more.
 
I've never seen that.  Has anyone else?  I thinking rebuilding the
indexes on that table is the first thing to try.
 
William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
Corporate Website, www.stratacominc.com http://www.stratacominc.com/ 
Blog, www.williamrentfrow.com http://www.williamrentfrow.com/ 
715-410-8156 C
 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: AW: Password for Demo Account ? Reset.

[Conny Martin]

this works at least for 7.1
 
arcache -d -Ua -e001 -n tmp_admin -lw 1 -g '1;' 



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Howard Richter
Gesendet: Montag, 26. Oktober 2009 18:36
An: arslist@ARSLIST.ORG
Betreff: Re: AW: Password for Demo Account ? Reset.


** 
Is that string for 7.x ?

Sent from Howard Richter's iPhone

On Oct 26, 2009, at 1:11 PM, Conny Martin conny.mar...@t-systems.com
wrote:



** 
you can add a new user with arcache
 
arcache -d -Ua -e001 -n tmp_admin -lw 1 -g '1;' -s localhost
this will add a user tmp_admin with an empty password. If you're
on ARS version  6.3 you must ommit -s localhost
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Arbot Drone
Gesendet: Montag, 26. Oktober 2009 18:06
An: mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG
Betreff: Re: Password for Demo Account ? Reset.


** 

Not comfortable posting the EXACT string to the list.  But the
external utility used for this purpose is ARCACHE.EXE.



Instructions for ARCACHE.EXE usage can be found in the ARSystem
Configuring document.



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Howard Richter
Sent: Monday, October 26, 2009 11:31 AM
To: mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG
Subject: Re: Password for Demo Account ? Reset.



** 

There use to be a startup string that would reset the Demo
account. That is something toggle you could put at that start of the
arserver. Its been a long time and in my old age I have forgotten it. 



 Maybe some one has that string.



Howard

On Mon, Oct 26, 2009 at 11:19 AM, Raj 
mailto:ravi6...@gmail.com ravi6...@gmail.com wrote:

Hello All,

By default I know there is no password for Demo, since lot of
people
in our team has started logging in using Demo.

I tried changing it by going into user form. Now, unable to
login
through Demo / and the new password created in the user form.

Is there a way to reset the password for Demo.Tried logging in
through
other accounts AppAdmin , etc but can't view user form through
those
accounts .


Please advise,

Raj



___
UNSUBSCRIBE or access ARSlist Archives at
http://www.arslist.org/ www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net
mailto:sponsor%3armisoluti...@verizon.net  ARSlist: Where the Answers
Are




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

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the
Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist:
Where the Answers Are_ 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: Password for Demo Account ? Reset.

[Conny Martin]

you can add a new user with arcache
 
arcache -d -Ua -e001 -n tmp_admin -lw 1 -g '1;' -s localhost
this will add a user tmp_admin with an empty password. If you're on ARS
version  6.3 you must ommit -s localhost
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Arbot Drone
Gesendet: Montag, 26. Oktober 2009 18:06
An: arslist@ARSLIST.ORG
Betreff: Re: Password for Demo Account ? Reset.


** 

Not comfortable posting the EXACT string to the list.  But the external
utility used for this purpose is ARCACHE.EXE.

 

Instructions for ARCACHE.EXE usage can be found in the ARSystem
Configuring document.

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Howard Richter
Sent: Monday, October 26, 2009 11:31 AM
To: arslist@ARSLIST.ORG
Subject: Re: Password for Demo Account ? Reset.

 

** 

There use to be a startup string that would reset the Demo account. That
is something toggle you could put at that start of the arserver. Its
been a long time and in my old age I have forgotten it. 

 

 Maybe some one has that string.

 

Howard

On Mon, Oct 26, 2009 at 11:19 AM, Raj ravi6...@gmail.com wrote:

Hello All,

By default I know there is no password for Demo, since lot of people
in our team has started logging in using Demo.

I tried changing it by going into user form. Now, unable to login
through Demo / and the new password created in the user form.

Is there a way to reset the password for Demo.Tried logging in through
other accounts AppAdmin , etc but can't view user form through those
accounts .


Please advise,

Raj


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
http://www.arslist.org/ 
Platinum Sponsor:rmisoluti...@verizon.net
mailto:sponsor%3armisoluti...@verizon.net  ARSlist: Where the Answers
Are




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

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: Problem with plugins

[Conny Martin]

imho the servername ISAB is not resolveable to an ip-adress. 
 
Try to ping isab on your server. If that doesn't work either change the
server-name to an resolveable alias or add it to the hosts file.
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Gianluca Nieri
Gesendet: Freitag, 23. Oktober 2009 20:19
An: arslist@ARSLIST.ORG
Betreff: Problem with plugins


** Trying to access server informations in ARS7.1 patch7, i get the
following errore

ARERR [8760] Cannot establish a network connection to the AR System
Plug-In server : ISAB (8201) : RPC: Success

It happens only  with that application, I can, for example, change
password to demo user.

RPC-Ports are not used by any other applications, in ar.cfg i made the
single plugins point to the specific path.

What I'm doing wrong?

Thanks,
Gian
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: Menu to list flters of a form

[Conny Martin]

here's the correct one.

select f.name
from filter f,filter_mapping fm, arschema s
where f.filterid = fm.filterid AND fm.schemaid = s.schemaid
  and s.name = 'formname' 

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Norbert Bolmer
Gesendet: Sonntag, 18. Oktober 2009 16:13
An: arslist@ARSLIST.ORG
Betreff: Re: Menu to list flters of a form

Hi Nitin,

yes, use a SQL menu with following statement:

select name
   from filter f,
arschema s
where f.schemaid = a.schemaid
and a.name = 'formname'

Br,
Norbert


Am 18.10.2009 um 16:04 schrieb nitin gogna:

 **
 Hi ARlist,

 Is there any way to create character menu in which I can list the 
 filters related to a particular form?

 --
 With Warm Regards,

 Nitin Gogna

 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the 
 Answers Are_

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

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

AW: Help with exporting an Oracle DB ....

[Conny Martin]

Sean,
 
I've done houndreds of exports with consistent=y and it works like a
charm. Even in heavy loaded production systems. If oracle is not able to
do a consistent export you will get appropriate error messages.
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Garrison, Sean (Norcross)
Gesendet: Donnerstag, 24. September 2009 14:35
An: arslist@ARSLIST.ORG
Betreff: Help with exporting an Oracle DB 


** 

We have a 24x7 remedy system that runs on an Oracle DB.  We are trying
to get an export from production into our lower environments.  We are
unable to just lock out users in order to do an export.  Whenever we try
to do this the count of the T vs H tables are different.  Basically
what is happening is oracle is exporting the H tables first and then
later gets to the T tables.  In between the exports new records were
created on a form which causes the T tables to have more records than
the H tables do.  There is an option called Consistency=Yes when
doing an export that is supposed to go back and synch up all of the data
but from our experience that isn't happening.  The export doesn't have
to be real-time but does have to have consistent data.  I was wondering
if there was a way to pass in an date into the export file so that no
records created after a certain date get included -- or something to
that effect.  Any suggestions or ideas on how to get an Oracle export of
a Remedy db?

 

Thanks,

 

Sean

 

Michael (Sean) Garrison

Remedy Developer - Senior 

Enterprise Technology 

Fiserv

Phone: 678-375-1089

Mobile: 770-851-8238

Fax: 678-375-3434

www.fiserv.com http://www.checkfree.com 

P Please consider the environment before printing this e-mail.

 

 

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: Filter qualification using !=

[Conny Martin]

One can not say in general that having != in a qualification does a full table 
scan.

Here is a little example

You have a Form where Field1 has an index.

'Field1' = foo would use the index defined on Field1 
'Field1' = foo and 'Field2' != $NULL$ would use the index defined on Field1
'Field1' = foo and 'Field2' = bar would use the index defined on Field1
'Field1' != $NULL$ and 'Field2' = bar would not(!!) use the index defined on 
Field1
'Field1' = $NULL$ and 'Field2' = bar would not(!!) use the index defined on 
Field1
'Field1' != foo would not(!!) use the index defined on Field1

One can say that using != with an indexed field prevents the database from 
using that index. If your qualification does not include any other indexed 
field then this would result in a full table scan.

HTH

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von lee
Gesendet: Mittwoch, 16. September 2009 18:52
An: arslist@ARSLIST.ORG
Betreff: Filter qualification using !=

Hi,

I have some filters that use the qualification != $NULL$.
In the documentation it says to avoid using != as it will do a full table scan.

My question is 'does having != $NULL$ AND Field1 = Organization' make the full 
table scan smaller?

Or
Is it better to do a != $NULL$ or LIKE 'CU%

When I try the LIKE qualification, it seems a lot slower (timeout
message) compared to the != $NULL$

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

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

AW: ARERR 298 Too Many Filter since upgrade to 7.1

[Conny Martin]

David,

we noticed the same problem after upgrading to 7.1(from 6.3). I did some 
investigations and found out that before 7.1 only filters were counted if the 
at least one action of the filter was executed. In 7.1 every filter is counted 
regardless if an action is executed or not. We multiplied the Maximum filters 
for an Operation by 10 and everything is fine now.

HTH

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Shellman, David
Gesendet: Dienstag, 15. September 2009 16:36
An: arslist@ARSLIST.ORG
Betreff: Re: ARERR 298 Too Many Filter since upgrade to 7.1

Peter,

Thanks.  Support just got back to me an noted that the default is 10,000 but 
that most applications need 200,000 to 660,000.  From the Configuring 
documentation Defines the number of filters that can be performed in an 
operation. The default and recommended number is 1. Increase this number at 
your own risk only if you reach a limit in your system and you have verified 
that your workflow is valid.

They also noted trying to increase the Filter Stack Size to a minimum of 
200,000.  If the they are referring to Maximum Stack of Filters, then 200,000 
is not a valid number.  100,000 is the maximum.  Also the Configuration 
documentation gives a similar warning as Maximum Filters for an Operation.

Dave

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Peter Romain
Sent: Tuesday, September 15, 2009 9:03 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARERR 298 Too Many Filter since upgrade to 7.1

My ITSM 7.5 installation automatically set this to 500,000 so you've a way to 
go before you match that!

Cheers

Peter


 Dave,
 It may or may not be the case with you but,

 We faced the same error when we were using the qualification 
 TR.Status != DB.Status  instead of Status != DB.Status.

 We got rid of this error when i corrected the qualification. This was 
 during the upgrade from ARS 6.0 to ARS 7.1

 On Tue, Sep 15, 2009 at 8:34 AM, Shellman, David  
 dave.shell...@tycoelectronics.com wrote:

 **  We upgraded to 7.1 Patch 7 (Windows/Oracle) from 7.0.1 over the 
 weekend.  Since then we are seeing issues a large number of Too many 
 filters processed during this operation (ARERR 298) errors.  Most 
 are associated with escalations but we are also seeing it in when 
 individuals are updating records in our home grown system.  Very 
 seldom did we see this issue when on 7.0.1.

 Yesterday I updated the Maximum Filters for an Operation to 2.  I 
 just bumped it to 4.

 Any ideas of what parameters to change to or reasonable values is 
 greatly appreciated.

 Dave

 Dave Shellman

 Phone:  (717) 810-3687
 Fax:(717) 810-2124
 email:  dave.shell...@tycoelectronics.com

 *Tyco **Electronics*
 MS 161-043
 PO Box 3608
 Harrisburg, PA 17105-3607



  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the 
 Answers Are_




 --
 Regards,
 Kiran Kodali
 Ph: 940-231-8524

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


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

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

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

AW: Strange errors...help appreciated....

[Conny Martin]

390603 indicates that this error messages are generated through an
escalation.
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von
copits.rich...@bwc.state.oh.us
Gesendet: Donnerstag, 10. September 2009 19:44
An: arslist@ARSLIST.ORG
Betreff: Strange errors...help appreciated


** 

Each day we seem to be getting the 4 error lines shown below right after
midnight. There is no one here to

be on the system to be doing anything. These errors are in arerror.log
and occur at the same time each day.

There aren't any errors in any of the other log files. Any
suggestions/help/information on what might be

causing these errors?  We're stumped... Thanks!!

 

Thu Sep 10 00:05:02 2009  390603 : Required field (without a default)
not specified : AAS:ActivityInterface_Create : Company (ARERR 307)

Thu Sep 10 00:05:02 2009  390603 : Required field (without a default)
not specified : AAS:ActivityInterface_Create : First Name (ARERR 307)

Thu Sep 10 00:05:02 2009  390603 : Required field (without a default)
not specified : AAS:ActivityInterface_Create : Last Name (ARERR 307)

Thu Sep 10 00:05:02 2009  390603 :  : Required field (without a default)
not specified :  Location Company* (ARERR 45649)



Portions of this message may be confidential under an exemption to
Ohio's public records law or under a legal privilege. If you have
received this message in error or due to an unauthorized transmission or
interception, please delete all copies from your system without
disclosing, copying, or transmitting this message. _Platinum Sponsor:
rmisoluti...@verizon.net ARSlist: Where the Answers Are_ 

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

AW: Error - Reached maximum number of database entries...

[Conny Martin]

Kali,
 
try to delete /etc/.multilicense and restart your arserver.
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Kali Obsum
Gesendet: Mittwoch, 9. September 2009 09:21
An: arslist@ARSLIST.ORG
Betreff: Re: Error - Reached maximum number of database entries...


** 
ARS Version 6.3
OS = Solaris v9
DB Version = Sybase v12.5
 
How do I find out the hostid of the server? I tried to run
/usr/bin/hostid, converted the hex value to decimal and it's the same as
the hostid listed in the licenses. is there another way to check the
correct hostid?
 
Regards,
Kali
 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Marc Simmons
Sent: Tuesday, 8 September 2009 9:48 PM
To: arslist@ARSLIST.ORG
Subject: Re: Error - Reached maximum number of database entries...


** 
Could you give us more information about the implementation:
 
ARS Version
OS
DB Version
etc.

There are ways to check the hostid of the server and compare that to
what is in the license file/Admin tool etc.  Getting some of this
information varies depending on the type of server you have implemented.
 
Marc
 
On Tue, Sep 8, 2009 at 9:28 AM, Barb Wagner bar...@us.ibm.com wrote:


** 
Another thought would be to check in your */etc directory to see
if you have any *.lck files - If  I remember correcty ... they are
hidden files so you will have to search for them - I have seen this
cause problems with licensing as well (if it's there - stop your server
- remove the file - restart) 

Barb Wagner
IBM Global Services
218-828-4135
bar...@us.ibm.com




Kali Obsum kali.ob...@macquarie.com 
Sent by: Action Request System discussion list(ARSList)
arslist@ARSLIST.ORG 

09/08/2009 01:09 AM 
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG 
cc
Subject
Re: Error - Reached maximum number of database entries...   







I've checked by going to Licenses-Add/Remove Licenses and the
AR Server
license has no Expire Date, which means it's not expired right? 

But when I go to Server Information-Licenses, Fixed Write
Licenses is
only 3.


Regards,
Kali

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Rod Harris
Sent: Tuesday, 8 September 2009 11:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Error - Reached maximum number of database
entries...

HI Kali,
The license for your dev server has expired. You can get a
temporary one
via the BMC website if you have a support login.

Rod



On 08/09/2009, Kali Obsum kali.ob...@macquarie.com wrote:
 **
 Hi,

 We suddenly encountered this error in our DEV environment that
we've 
 been using for years:

 (when trying to save a record using User Tool) ARERR [337]
You have 
 reached the maximum number of database entries permitted with
this 
 version of the Action Request System(R). To purchase the
unrestricted 
 version, contact your sales representative.

 (when trying to log-in using Admin Tool) This version of
Action 
 Request System(R) is ready for use or evaluation without
purchasing or

 activating an authorication key. For unlimited capabilities,
contact 
 your sales representative or visit www.remedy.com/ (ARERR
2877)

 Checked the app server and used space in the installation
directory is
66%.
 Checked the db server and free space for ARSystem db is as
follows:
 data file = 43% free
 log file = 100% free

 Anyone knows what may have caused this problem? Is it possible
that 
 something somewhere has been corrupted?

 Regards,
 Kali


 NOTICE

 The information contained in this email is confidential. If
you are 
 not the intended recipient, you must not disclose or use the 
 information in this email in any way. If you received it in
error, 
 please tell us immediately by return email and delete the
document. We

 do not guarantee the integrity of any e-mails or attached
files and 
 are not responsible for any changes made to them by any other
person.

  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where
the 
 Answers Are_



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

AW: New fields added becomes Core fields

[Conny Martin]

Lyle,
 
IMHO there are at least 2 different ways how new fieldids are generated.
It depends on the type of field you're adding to a form. Character
fields initially have a blank fieldid and after saving the form the
fieldid gets populated with a fieldidvalue according to the value of
nextfieldid. If you add a tablefield-column the fieldid gets set by the
Admintool. If someone created a column with fieldid 6 the next
column gets fieldid 7, but nextfieldid in arschema remains its
value. Same behaviour applies to pageholders and its pages.
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Lyle Taylor
Gesendet: Mittwoch, 2. September 2009 22:22
An: arslist@ARSLIST.ORG
Betreff: Re: New fields added becomes Core fields


** 

Thanks for responding, Doug.  In our environment, we do not ever
directly update the database, so I don't think this is what happened
here.  It appears to have changed just as a result of modifying the
form.  Now, I did manually enter field IDs for many of the fields as I
was adding them to the forms (to make them match custom fields on other
forms as well as ITSM fields that I was pulling data from).
Additionally, I copied and pasted some fields from other forms (such as
the Company field from HPD:Help Desk).  Could either of those have reset
the nextFieldID counter to a higher value?

 

Thanks,
Lyle

 

 

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

AW: New fields added becomes Core fields

[Conny Martin]

Kali,
 
with the following sql statement you can set nextfieldid to a safe
number.
 
UPDATE arschema SET nextfieldid = (SELECT MAX(fieldid) FROM field WHERE
field.schemaid =arschema.schemaid) + 1 where name = 'Name of your
form'
 
After that you must restart your arserver.
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Kali Obsum
Gesendet: Mittwoch, 2. September 2009 03:05
An: arslist@ARSLIST.ORG
Betreff: Re: New fields added becomes Core fields


** 
Hi,
 
The nextfieldid for that form is set to 23 (don't know how it happened).
Is it safe to just manually set it to a certain id? How do i know what
number is safe?
 
Thanks!
 
Regards,
Kali
 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Conny Martin
Sent: Tuesday, 1 September 2009 2:49 PM
To: arslist@ARSLIST.ORG
Subject: AW: New fields added becomes Core fields


** 
Kali,
 
check the field nextfieldid in arschema with the following sql
statement.
 
select name, nextfieldid from arschema
 
In normal case the nextfieldid contains something like 5368709xx
 
HTH
 
Kind Regards Conny




Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Kali Obsum
Gesendet: Dienstag, 1. September 2009 08:16
An: arslist@ARSLIST.ORG
Betreff: New fields added becomes Core fields


** 
Hi,
 
Everytime I add a new field in an existing form, the field is created as
a Core field (DB id is set to 16,17,18 etc). Any ideas why this is
happening?
 
Regards,
Kali
 

NOTICE 

The information contained in this email is confidential. If you are not
the intended recipient, you must not disclose or use the information in
this email in any way. If you received it in error, please tell us
immediately by return email and delete the document. We do not guarantee
the integrity of any e-mails or attached files and are not responsible
for any changes made to them by any other person.

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the
Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist:
Where the Answers Are_ 

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

AW: New fields added becomes Core fields

[Conny Martin]

if you create a new form nextfieldid is initially set to 536870912,
regardless if you create a field with a manually given fieldid or not.



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Lyle Taylor
Gesendet: Mittwoch, 2. September 2009 20:47
An: arslist@ARSLIST.ORG
Betreff: Re: New fields added becomes Core fields


** 

What sets the initial nexfieldid for a given form?  For example, if I
create a new form and add a new field and manually set the ID to X
(and it's not in the reserved range and higher than any other field on
the form), will that plus one become the next field ID?

 

Thanks,
Lyle

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Conny Martin
Sent: Wednesday, September 02, 2009 12:31 PM
To: arslist@ARSLIST.ORG
Subject: AW: New fields added becomes Core fields

 

** 

Kali,

 

with the following sql statement you can set nextfieldid to a safe
number.

 

UPDATE arschema SET nextfieldid = (SELECT MAX(fieldid) FROM field WHERE
field.schemaid =arschema.schemaid) + 1 where name = 'Name of your
form'

 

After that you must restart your arserver.

 

Kind Regards Conny

 



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Kali Obsum
Gesendet: Mittwoch, 2. September 2009 03:05
An: arslist@ARSLIST.ORG
Betreff: Re: New fields added becomes Core fields

** 

Hi,

 

The nextfieldid for that form is set to 23 (don't know how it happened).
Is it safe to just manually set it to a certain id? How do i know what
number is safe?

 

Thanks!

 

Regards,

Kali

 

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Conny Martin
Sent: Tuesday, 1 September 2009 2:49 PM
To: arslist@ARSLIST.ORG
Subject: AW: New fields added becomes Core fields

** 

Kali,

 

check the field nextfieldid in arschema with the following sql
statement.

 

select name, nextfieldid from arschema

 

In normal case the nextfieldid contains something like 5368709xx

 

HTH

 

Kind Regards Conny

 



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Kali Obsum
Gesendet: Dienstag, 1. September 2009 08:16
An: arslist@ARSLIST.ORG
Betreff: New fields added becomes Core fields

** 

Hi,

 

Everytime I add a new field in an existing form, the field is created as
a Core field (DB id is set to 16,17,18 etc). Any ideas why this is
happening?

 

Regards,

Kali

 

NOTICE 

The information contained in this email is confidential. If you are not
the intended recipient, you must not disclose or use the information in
this email in any way. If you received it in error, please tell us
immediately by return email and delete the document. We do not guarantee
the integrity of any e-mails or attached files and are not responsible
for any changes made to them by any other person.

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the
Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist:
Where the Answers Are_ 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 



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


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: New fields added becomes Core fields

[Conny Martin]

Kali,
 
check the field nextfieldid in arschema with the following sql
statement.
 
select name, nextfieldid from arschema
 
In normal case the nextfieldid contains something like 5368709xx
 
HTH
 
Kind Regards Conny




Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Kali Obsum
Gesendet: Dienstag, 1. September 2009 08:16
An: arslist@ARSLIST.ORG
Betreff: New fields added becomes Core fields


** 
Hi,
 
Everytime I add a new field in an existing form, the field is created as
a Core field (DB id is set to 16,17,18 etc). Any ideas why this is
happening?
 
Regards,
Kali
 

NOTICE 

The information contained in this email is confidential. If you are not
the intended recipient, you must not disclose or use the information in
this email in any way. If you received it in error, please tell us
immediately by return email and delete the document. We do not guarantee
the integrity of any e-mails or attached files and are not responsible
for any changes made to them by any other person.

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: Menu problem....Group List id issue ?

[Conny Martin]

Sean,
 
you can make use of a SQL-Menu with the following statement
 
SELECT login_name FROM user_x WHERE
group_list LIKE (SELECT group_id FROM group_x WHERE group_name =
'$536870925$')||';%' OR
group_list LIKE '%; '||(SELECT group_id FROM group_x WHERE group_name =
'$536870925$')||';%' OR
group_list LIKE '%;'||(SELECT group_id FROM group_x WHERE group_name =
'$536870925$')||';%'
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Sean Harrodine
Gesendet: Montag, 31. August 2009 12:09
An: arslist@ARSLIST.ORG
Betreff: Re: Menu problemGroup List id issue ?


** 
Hi Frank,
 
To your knowledge, is there no way around it other than storing the id
and having to use that ?
 
Sean




From: Frank Caruso caruso.fr...@gmail.com
To: arslist@ARSLIST.ORG
Sent: Monday, 31 August, 2009 10:48:48
Subject: Re: Menu problemGroup List id issue ?

Store the GROUPID value (number) in a temp field when the user selects
the assigned group. Then use the temp value in your menu.


On Mon, Aug 31, 2009 at 12:43 PM, Sean
Harrodinesean_rem...@yahoo.co.uk wrote:
 **
 Hi everyone,

 Can anyone help me with the following menu / query issue please on a
bespoke
 app.


 I have a field name on a form called AssignedToGroup (id = 536870925).
An
 example of its contents would be TECH_PLAN

 On the same form i have a field called Assignee (id = 536870926)

 The group TECH_PLAN exists in the group form and there are 3 users in
the
 User form that have TECH_PLAN in their Group List


 I have created and attached a menu to the Assignee field, with the
following
 query against the User form

  'Group List' LIKE ( %  + ($536870925$ +  % ))

 .in the hope that the menu will display a list of the users with
 TECH_PLAN in their group list but it doesn't


 I suspect this is something to do with that the User form actually
stores
 the ID for the Group in the User Form.

 Is there anyway of being able to present a menu based on using the
actual
 Group Name, rather than the group ID ?


 TIA

 Sean
 _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


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_

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

AW: Remedy API and gcc on Redhat Linux

[Conny Martin]

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 Makefile, do a make clean and then try building it
again.

 

Lyle

 


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

AW: Remedy API and gcc on Redhat Linux

[Conny Martin]

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 Makefile, do a make clean and then try building it again.

 

Lyle

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Marty.Thorin
Sent: Friday, August 21, 2009 10:28 AM
To: arslist@ARSLIST.ORG
Subject: 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.

AW: ARIMPORTCMD Problem with accentuation

[Conny Martin]

it looks like your csv file is UTF-8 encoded. But arimportcmd is expecting a 
file encoded in your native codepage. (CP1252)
 
Try to open the file in notepad and in the Save As Dialog choose ANSI 
encoding and save the file.
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Hellyson
Gesendet: Donnerstag, 13. August 2009 17:06
An: arslist@ARSLIST.ORG
Betreff: ARIMPORTCMD Problem with accentuation


** I have a problem when I try to import some data with accentuation using 
arimporcmd command at the MS-DOS

Here, in Brazil, we use accentuation  (^,~,´, etc) in some words, when i try to 
import a csv file, in the arimport.log displays the correct data, but in the 
arsql.log displays the wrong data.

Example:
Log of Import
 Marcão;5/7 - 11/7/2009;SextaAusência;;;

Log of SQL:
SELECT T95.C1 FROM T95 WHERE ('MarcÃo' = T95.C536870913) ORDER BY 1 ASC

I did the test on my machine, development server and approval server.

Operation System: Windows
DB: Microsoft SQL Server 2003
ARS Server Version: 7.1.00 Patch 002



Hellyson
helly...@gmail.com
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ 

AW: Server-side Log Files empty

[Conny Martin]

Kali,
 
perhaps you have turned on Log per Thread. The files are then named
xxx.log-threadid.
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Kali Obsum
Gesendet: Dienstag, 11. August 2009 04:17
An: arslist@ARSLIST.ORG
Betreff: Server-side Log Files empty


** 
Hi,
 
We have an external application that connects to remedy through the
Remedy APIs. We would like to trace what happens (what workflows are
triggered etc) so we turned on the logging in the server by going to
File-Server Information-Logs and checking the API, Filter, User logs,
then asking them to perform a process in the external application.
However, when I went to the server, the log files are created but no
activity was recorded.
 
Content of Log file:
 
FLTR TID: 09 RPC ID: 0033482866 Queue: Admin 
Client-RPC: 390600  USER: xxx  /* Tue Aug 11 2009 11:34:39.4448
*/Filter Trace Log -- OFF
USER TID: 09 RPC ID: 0033482866 Queue: Admin 
Client-RPC: 390600  USER: xxx  /* Tue Aug 11 2009 11:34:39.4448
*/User Trace Log -- OFF
API  TID: 09 RPC ID: 0033482866 Queue: Admin 
Client-RPC: 390600  USER: xxx /* Tue Aug 11 2009 11:34:39.4449 */API
Trace Log -- OFF
END OF LOG FILE
 
Is there something else I need to configure in order to record the
activity in the server?

Thanks!
 
Regards,
Kali

NOTICE 

The information contained in this email is confidential. If you are not
the intended recipient, you must not disclose or use the information in
this email in any way. If you received it in error, please tell us
immediately by return email and delete the document. We do not guarantee
the integrity of any e-mails or attached files and are not responsible
for any changes made to them by any other person.

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: Webservice - HTTPS problem :o(

[Conny Martin]

Sean,
 
try to save the wsdl and use this file instead of providing an URI.
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Sean Harrodine
Gesendet: Montag, 3. August 2009 11:17
An: arslist@ARSLIST.ORG
Betreff: Re: Webservice - HTTPS problem :o(


** 
Hi LJ,

Unfortunately no, i cannot access the WSDL from my desktop. The network
routing has been setup from server to server for port 443 only.

Sean




From: LJ Longwing lj.longw...@gmail.com
To: arslist@ARSLIST.ORG
Sent: Saturday, 1 August, 2009 0:09:49
Subject: Re: Webservice - HTTPS problem :o(

** 
Are you able to hit that URL from YOUR workstation without
error?unfortunately, the whole WSDL thing is a weird integration
between client (your workstation) and the server...



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Sean Harrodine
Sent: Friday, July 31, 2009 11:02 AM
To: arslist@ARSLIST.ORG
Subject: Webservice - HTTPS problem :o(


** 
Hi everyone !

(Remedy 6.3)

I am trying to access a HTTPS WSDL from within a filter but am receiving
the following error when i click to Load the WSDL.


Failed to create internal mapping from wsdl. (ARERR 7012)


ERROR: URI not found https://...com/nWS/DocHandler?wsdl

Additional Details:
...com
com.remedy.arsys.ws.util.ARWSException: URI not found
https://...com/nWS/DocHandler?wsdl
at com.remedy.arsys.ws.util.WsdlUtil.newDocument(WsdlUtil.java:151)
at com.remedy.arsys.ws.util.WsdlUtil.newDocument(WsdlUtil.java:165)
at com.remedy.arsys.ws.wsdl.WsdlParser.init(WsdlParser.java:88)
at
com.remedy.arsys.ws.util.WsdlAdminInterface.parseWsdl(WsdlAdminInterface
.java:327)
at
com.remedy.arsys.ws.util.WsdlAdminInterface.parseWSDLIntoMappingString(W
sdlAdminInterface.java:191)


The URL is an HTTPS secure connection to a company who are doing some
hosting work for us.

From my Linux server, i can run a telnet to the ...com
server on port 443..

results...

# telnet ...com 443

Trying xxx.xxx.xxx.xxx...
Connected to ...com.
Escape character is '^]'.

Ther are also able to perform the same tests in reverse so i am
presuming that the network is fine.


I can also access their WSDL using a browser with no proxy settings set
! on my Linux Remedy server, i can accept the certificate and see the
contents of their WSDL


But, when i try to create a Filter / WebService / Set Field
(WEBSERVICE), i get the error message detailed at the top of this email.


So, is anyone able to advise what the issue may be please ???

thanks in advance to anyone who is able to offer some support !
Sean 



_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are__Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the
Answers Are_ 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_

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

AW: Users unable to log in (ARERR 90)

[Conny Martin]

Sue
 
The message RPC: Program not registered indicates that the clients are
connecting without specifying a tcp-port. This works only if you have
configured your server to Register with Port mapper.
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Barber, Sue
Gesendet: Montag, 3. August 2009 14:49
An: arslist@ARSLIST.ORG
Betreff: Users unable to log in (ARERR 90)


** 

 Morning all,

 

We are having a strange problem with user connectivity.  We have several
users who can't log in to the desktop client - this is an intermittent
problem.  They get the ARERROR 90 - I replace the actual server name
with 'servername' below, but it does show the proper name in the
message.  Strange thing is that they can connect via midtier and if they
log in wireless or VPN.  Only when they are directly connected to the
network, and like I said, they get in sometimes.  I have a ticket opened
with Remedy, but we are still going through the send me this stage and
meanwhile, I have 5 HD people who can't connect!   Any help would be
greatly appreciated.

 

Server:  7.1.00 Patch 004 

O.S. Linux 2.6.9-89.0.3

DB:  Oracle 10.2.0.4.0

Client Tool:  7.1.00 Patch 4

 

Sue Barber

 

ARERR [90] Cannot establish a network connection to the AR System
server : servername (0) : RPC: Program not registered

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: Unable to connect to secondry host in tnsnames.ora

[Conny Martin]

Ankur,

IMHO your oracle listener isn't configured properly. Try to stop the listener 
on .230 after switch.

Kind Regards Conny 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Ankur Gulati
Gesendet: Dienstag, 21. Juli 2009 14:00
An: arslist@ARSLIST.ORG
Betreff: Unable to connect to secondry host in tnsnames.ora

Hi Listers,

We are setting up the our ARS solution using Server group with two Database 
servers in Active and Standby mode using Data guard. In the application server, 
the tnsnames.ora has an entry with two hosts(primary and secondary) connected 
with the same service name.

Below is the txt from tnsnames.ora

test =
  (DESCRIPTION =
   (ADDRESS_LIST=
    (ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.230 )(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.231 )(PORT = 1521))
   )
    (CONNECT_DATA =
  (SERVICE_NAME = abc)
 )
   )

Now when the primary host (.230) is active, the application runs fine.
The moment we switch off the primary database (.230)and mount the secondary 
one. The application shuts down. It gives Unable to connect to Database error.

In the tnsnames.ora on the application server, when we make the primary HOST as 
231 and secondary as 230, it again runs fine.

Why ARS Application does not connect to the secondary address automatically? 
What can be the solution to this?

ARS 7.1 patch 4 on Solaris 10
Oracle 10g on Red hat Linux

Regards
Ankur

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

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

AW: Performance Issue Please Give Me Any Suggesstion

[Conny Martin]

Manoj,
 
turn on API-Logging on all 3 servers. So you can check (and compare) how
many API-calls reaching each of the servers. Perhaps this gives you some
information why server1 is performing so bad.
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von manoj jain
Gesendet: Donnerstag, 16. Juli 2009 09:44
An: arslist@ARSLIST.ORG
Betreff: Re: Performance Issue Please Give Me Any Suggesstion


** 
Hi Lina  Ken,
 
Yes you were right that load balancer is infornt of system so what we
can do for reducing performance issue?But Performance issue occuring
only in one server which is not primary server.
 
Thanks  Regards,
Manoj jain


On Thu, Jul 16, 2009 at 12:52 PM, Lina Hartojo linahart...@gmail.com
wrote:


** Hi Manoj

I assume the load balancer is the traffic controller for user
access to the servers within this server group, which means that the
load balancer is *always* in front of the system.  Ken, is that the case
or is there any other situation where this is not the case?  Apologies
for my novice knowledge, please explain if you can.

Kind regards - Lina


On Thu, Jul 16, 2009 at 4:56 PM, manoj jain
manoj.jain4...@gmail.com wrote:


** 
Hi Ken,
 
1.No that server in which performance issue going on is
not our primary server.
so email and escalation is not part of that server.
2.We have a load balancer but i didn't get what is
meaning of this sentence load balancer infornt of server.
 
Thanks  Regards,
Manoj Jain


On Wed, Jul 15, 2009 at 11:00 PM, Ken Pritchard
pri...@ptd.net wrote:


** 

Manoj,

 

   Probably need to provide some additional
information, such as:

 

   Is this your primary server (does it run
escalations, email, etc..)?  

 

   Do you have a load balancer in front of the
system?

 

  I found it helpful to lower the amount of user
traffic that goes to the primary server where your non-user items (such
as escalations) are primarily set to run.

 

Thank you - ken

 

From: Action Request System discussion
list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of manoj jain
Sent: Wednesday, July 15, 2009 12:21 PM
To: arslist@ARSLIST.ORG
Subject: Performance Issue Please Give Me Any
Suggesstion

 

** 

Hi Remedians,

 

I have one issue 

 

1.i have one server group on linux box there are
three servers  in that group.

2.Two servers running very good   without any
performance issue.

3.One server running very  bad with high
performance  issue.

4.CPU utilization  in that server is 150%,Idel
time 2%.

5.So please give me  any suggesstion  so that i
could  resolve  this  performance  issue. 

6. How can i reduce cpu utilization and increase
idel time.

 

Thanks  Regards,

Manoj Jain

_Platinum Sponsor: rmisoluti...@verizon.net
ARSlist: Where the Answers Are_ 

_Platinum Sponsor: rmisoluti...@verizon.net
ARSlist: Where the Answers Are_ 


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist:
Where the Answers Are_ 


_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

AW: Allowing users to enter leading characters in search menu field

[Conny Martin]

'Department' LIKE ($10$ + % ) or $10$ =  
 
don't forget the blank between the double quotes

HTH
 
Kind Regards Conny


Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von marti...@ad.jmu.edu
Gesendet: Montag, 13. Juli 2009 17:35
An: arslist@ARSLIST.ORG
Betreff: Allowing users to enter leading characters in search menu field


** 

Dear List,

 

I have a Department field (field ID 10), with choices listed
in a Department Form.  I want users to be able to either click on the
Menu button and see all choices, or enter one or more leading characters
and see the choices that begin with those letters.  (Eg, type in Eco
and then see Ecology and Economics in the menu.)

 

If I have no qualifications in my menu it shows all choices.

 

If my qualification says:

'Department' LIKE ($10$ + % ) 

It works if the user enters a leading letter or two, but if there are no
leading letters it says, (No entries in menu).

 

I tried:

$10$ = $NULL$ OR 'Department' LIKE ($10$ +
% ) 

But still got (No entries in menu).

 

'Department' LIKE ( %  + $10$ +  % )

works if there are no leading characters, but if there are leading
characters, it offers choices in which the leading characters appear
anywhere in the Department name.  (Workable, but not ideal.)

 

Any suggestions?

(ARS 7.1 p3, RH Linux server, Oracle 10.2)

 

Dwayne Martin

James Madison University

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: Allowing users to enter leading characters in search menu field SOLVED

[Conny Martin]

http://rkm.bmc.com/rkm/viewdoc.jsp?remedy=1doc=KM-4198sid=3117
422type=Publishedterms=searchTermsuser=Self%20Help



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von LJ Longwing
Gesendet: Montag, 13. Juli 2009 18:13
An: arslist@ARSLIST.ORG
Betreff: Re: Allowing users to enter leading characters in search menu
field SOLVED


** 
Because of a 'bug' that functions 'as designed' in the Remedy code that
replaces null values with the character string  



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of marti...@ad.jmu.edu
Sent: Monday, July 13, 2009 10:08 AM
To: arslist@ARSLIST.ORG
Subject: Re: Allowing users to enter leading characters in search menu
field SOLVED


** 

Thanks, Conny!

 

That works!  But WHY does it work?  There is no space in the Department
field.

 

Dwayne

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Conny Martin
Sent: Monday, July 13, 2009 11:53 AM
To: arslist@ARSLIST.ORG
Subject: AW: Allowing users to enter leading characters in search menu
field

 

** 

'Department' LIKE ($10$ + % ) or $10$ =  

 

don't forget the blank between the double quotes

HTH

 

Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von marti...@ad.jmu.edu
Gesendet: Montag, 13. Juli 2009 17:35
An: arslist@ARSLIST.ORG
Betreff: Allowing users to enter leading characters in search menu field

** 

Dear List,

 

I have a Department field (field ID 10), with choices listed
in a Department Form.  I want users to be able to either click on the
Menu button and see all choices, or enter one or more leading characters
and see the choices that begin with those letters.  (Eg, type in Eco
and then see Ecology and Economics in the menu.)

 

If I have no qualifications in my menu it shows all choices.

 

If my qualification says:

'Department' LIKE ($10$ + % ) 

It works if the user enters a leading letter or two, but if there are no
leading letters it says, (No entries in menu).

 

I tried:

$10$ = $NULL$ OR 'Department' LIKE ($10$ +
% ) 

But still got (No entries in menu).

 

'Department' LIKE ( %  + $10$ +  % )

works if there are no leading characters, but if there are leading
characters, it offers choices in which the leading characters appear
anywhere in the Department name.  (Workable, but not ideal.)

 

Any suggestions?

(ARS 7.1 p3, RH Linux server, Oracle 10.2)

 

Dwayne Martin

James Madison University

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the
Answers Are_ 

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

AW: Old Install Files

[Conny Martin]

Andy,

these files are available on the patchdownload ftp-server. But the macro 
converting feature is available until 6.3

HTH

Kind Regards Conny 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Mayfield, Andy L.
Gesendet: Dienstag, 7. Juli 2009 15:29
An: arslist@ARSLIST.ORG
Betreff: Old Install Files

Does anyone know where I can get a copy of the installation files for the 
version 5.X admin tool?  It had a feature to convert macros to active links and 
wanted to give that a try.

Windows Based System

Thanks,



Andy L. Mayfield
Protection  Control Technician Sr.
Alabama Power Company
Office: 205-226-1805
Cell: 205-288-9140
SoLinc: 10*19140 

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

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

AW: How do I Change the ARAdmin password Remedy uses Without having Remedy up

[Conny Martin]

Ray,

you can put the aradmin password unencrypted into ar.conf

HTH

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Ray T.
Gesendet: Donnerstag, 2. Juli 2009 19:10
An: arslist@ARSLIST.ORG
Betreff: How do I Change the ARAdmin password Remedy uses Without having Remedy 
up

Hi all, I am trying to setup an instance of Remedy that is a copy of the 
production. I copied the file system and had the oracle database copied as 
well, and then made changes as necessary, but I hit a wall.

unfortunately, the aradmin password was changed in the copied database. When 
the new instance of Remedy starts and tries to connect to the copied database, 
it of course tries to use the aradmin password from production and it fails to 
connect. I don't know the password for aradmin user in production database 
(don't ask).

How can I tell Remedy, when it's not running, to use a certain password for 
aradmin? I thought the password was encrypted in ar.conf, but I don't see it 
there. Not that it would help, because it would be in encrypted form. Where 
does Remedy store aradmin password? Can't be in the database.

Other than doing an upgrade install of AR Server on the copied instance, what 
option do I have?

I hesitate to change the password in prod and then copy ar.conf...because I 
suspect that some external stuff may be tapping into the database there using 
aradmin account.

TIA.

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

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

AW: Installation of AR server 7.1 - No Alert Events form could be found on the server (ARERR 3300)

[Conny Martin]

Rao,
 
I would suggest to enable SQL-Logging in ar.cfg. Add the following line.
 
Debug-mode: 1
 
Restart ARServer and post the arsql.log
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Joe DeSouza
Gesendet: Dienstag, 30. Juni 2009 03:16
An: arslist@ARSLIST.ORG
Betreff: Re: Installation of AR server 7.1 - No Alert Events form could
be found on the server (ARERR 3300)


** 
Rao,
 
This means that the H and T tables that are the underlying tables for
the said form have perhaps been created already.
 
To verify this first of all find out the schema ID for that form.
 
select schemaid from arscheama where name = 'Alert Events';
 
Lets say it returns 20.. then the T and H tables for that form will be
T20 and H20.. Describe these tables and see if you get a valid
description. If you get a nor rows selected result from the above SQL,
then you have some problem..
 
Also describe the view ALERT_EVENTS and see if you get a valid
description. You shouldn't get invalid object as a result..
 
If your results of the above area ll positive, then for some reason this
form is not being recognized by the AR System. What you could try is a
import in place from the def file in the installforms folder that will
exist in your installation directory. I do not have access to the exact
name of what that def file will be at the moment but if you cannot
figure it out let me know and I'll log into my systems later and get
that for you.
 
Joe




From: Rao Rao scenery@gmail.com
To: arslist@ARSLIST.ORG
Sent: Monday, June 29, 2009 3:12:09 PM
Subject: Re: Installation of AR server 7.1 - No Alert Events form could
be found on the server (ARERR 3300)

** 
Joe/Axton,
 
Joe, I ran the sql for Alerts.  Please see below.
 
SQL Select count(*) from arschema where name = 'Alert Events';
  COUNT(*)
--
 1
 
= = = = =
 
Axton, Please see my earlier mail on the sqls - you asked.  Thanks to
both of you for help and sparing time.
 
With Regards,
 
Rao


On Mon, Jun 29, 2009 at 2:34 PM, Joe DeSouza joe_rem...@yahoo.com
wrote:


** 
At what point and how do you reproduce that error then?
 
Have you checked if the entry for the Alerts form does exist in
the arschema table? (Select count(*) from arschema where name = 'Alert
Events';)
 
Joe





From: Rao Rao scenery@gmail.com
To: arslist@ARSLIST.ORG

Sent: Monday, June 29, 2009 1:15:07 PM
Subject: Re: Installation of AR server 7.1 - No Alert Events
form could be found on the server (ARERR 3300)

** 
Thank you Axton.  I reinstlled the app.  This time also it
failed with the same error message. arerror.log does not show any error.
Following is the arrerror log.
 
= = = = = = arerror.log = = = =
Mon Jun 29 12:47:46 2009 : Action Request System(R) Server
Version 7.1.00 Build 200708221849
(c) Copyright 1991-2007 BMC Software, Inc. 
Mon Jun 29 12:47:46 2009  390600 : This version of the Action
Request System(R) is ready for use or evaluation without purchasing or
activating an authorization key.
For unlimited capabilities, contact your sales representative.
(ARNOTE 27)
= = = = = = = = = =
 
armonitor.log shows the following:
 
= = = = armonitor = = = =
Mon Jun 29 12:47:44 2009   (ARNOTE 0)
Mon Jun 29 12:47:44 2009 AR Monitor version 7.1.00 Build
200708221849 started.
Mon Jun 29 12:47:44 2009   (ARNOTE 0)
Mon Jun 29 12:47:44 2009 AR Monitor started.
Mon Jun 29 12:47:44 2009   (ARNOTE 0)
Mon Jun 29 12:47:44 2009 ARMonitor child process (pid:4384)
started.
c:\program files\ar system\vanaja\arserver.exe
Mon Jun 29 12:47:44 2009   (ARNOTE 0)
Mon Jun 29 12:47:44 2009 ARMonitor child process (pid:2936)
started.
c:\program files\ar system\vanaja\arplugin.exe
Mon Jun 29 12:47:44 2009   (ARNOTE 0)
Mon Jun 29 12:47:44 2009 ARMonitor child process (pid:2276)
started.
c:\program files\ar system\vanaja\arsvcdsp.exe
Mon Jun 29 12:47:44 2009   (ARNOTE 0)
Mon Jun 29 12:47:44 2009 ARMonitor child process (pid:4912)
started.
c:\program files\java\jre6\bin\java
Mon Jun 29 12:47:44 2009   (ARNOTE 0)
Mon Jun 29 12:47:44 2009 Pausing for max 900 seconds or
until server up.
= = = = = = = = = =
 
following are contents of ar.cfg file.
 
= = = = ar.cfg = = = = 
 
Alternate-Approval-Reg: T
Private-RPC-Socket: 390603   1   1
Private-RPC-Socket: 390601   1   1
ARF-Java-Class-Path: C:\Program Files\AR
System\Vanaja\arapi71.jar;
ARF-Java-Class-Path: C:\Program Files\AR 

AW: Root cause of Nextid out of wack after DB restore

[Conny Martin]

William,
 
what kind of backup is your DBA taking?
 
If I read between the lines it sounds like she's doing an exp/imp. If
thats the case you must use the option consistent=yes.
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von William Rentfrow
Gesendet: Montag, 22. Juni 2009 18:42
An: arslist@ARSLIST.ORG
Betreff: Root cause of Nextid out of wack after DB restore


** 

We were doing some destructive data cleansing - we knew we'd wreck stuff
so before hand we had the DBA take a DB backup (oracle 9i, ARS 6.3 patch
20 running CSS - not that it matters).

After we were done we had a restore of the full database done.
Immediately we started getting index errors, etc, so I check the nextid
versus the max(c1) for a few tables and found they were out of wack (ie,
max(c1)  nextid for a particular table).

I know how to fix this of course - it's pretty straightforward SQL and
I've had it happen a few times over the years - yet I've never been able
to pinpoint a root cause.  Has anyone else found out why?  The DBA says
she dropped all users and objects and then restored so I'd have to
assume the synch error occurs before the database is backed up.

William Rentfrow 
Principal Consultant, StrataCom Inc. 
wrentf...@stratacominc.com 
Personal blog: www.williamrentfrow.com file://www.williamrentfrow.com

O 715-592-5185 
C 715-410-8056 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_

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

AW: Re : AW: RESOVLED Re: Long Time Saving Active Link

[Conny Martin]

 Time Saving Active Link

** 

Thanks Conny, like when you say but only for active links :-)

 

I applied the patch and did some tested with active links but not sure if I 
have noticed too much difference, but perhaps I have a server running on a 
VMWARE and things will be slow anyway :)

 

--- En date de : Mar 9.6.09, Conny Martin conny.mar...@t-systems.com a écrit :


De: Conny Martin conny.mar...@t-systems.com
Objet: AW: RESOVLED Re: Long Time Saving Active Link
À: arslist@ARSLIST.ORG
Date: Mardi 9 Juin 2009, 13h36

It's fixed in Admintool 7.1 Patch 7, but only for Active Links :-(

Kind Regards Conny 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG 
http://fr.mc265.mail.yahoo.com/mc/compose?to=arsl...@arslist.org ] Im Auftrag 
von David Morgan
Gesendet: Dienstag, 9. Juni 2009 13:25
An: arslist@ARSLIST.ORG 
http://fr.mc265.mail.yahoo.com/mc/compose?to=arsl...@arslist.org 
Betreff: Re: RESOVLED Re: Long Time Saving Active Link

No worries Frank - I think its fixed in a user tool patch later in the
7.1 series - but I cannot remember which patch

It's a little bit of a pain to switch off the details view - but 
typically I'd use ARUtilities to determine the details etc, and leave the admin 
tool switched off for speed :-)

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers 
Are_

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers 
Are_ 


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers 
Are_ 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers 
Are_ 


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ 

AW: RESOVLED Re: Long Time Saving Active Link

[Conny Martin]

It's fixed in Admintool 7.1 Patch 7, but only for Active Links :-(

Kind Regards Conny 

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von David Morgan
Gesendet: Dienstag, 9. Juni 2009 13:25
An: arslist@ARSLIST.ORG
Betreff: Re: RESOVLED Re: Long Time Saving Active Link

No worries Frank - I think its fixed in a user tool patch later in the
7.1 series - but I cannot remember which patch

It's a little bit of a pain to switch off the details view - but typically I'd 
use ARUtilities to determine the details etc, and leave the admin tool switched 
off for speed :-)



Cheers
Dave Morgan


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
Sent: 09 June 2009 12:12
To: arslist@ARSLIST.ORG
Subject: RESOVLED Re: Long Time Saving Active Link

--0016e6d999da2bc1e0046be86f9b
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

I do have details turned on  looking at active links without it is sort of 
useless  :)

But that did fix the problem. Without details active links save much faster.

Thankx!

On Tue, Jun 9, 2009 at 2:05 PM, David Morgan
dave.mor...@tiberone.comwrote:

 Hi Frank

 I think this is a known issue - and I'll bet you have the Details view 
 switched on in the Admin tool

 Switch off details view and try to save an active link/filter/form
etc.

 Regards
 Dave Morgan

 David Morgan
 Senior Technical Consultant

 Tiberone Technologies Limited
 Golden Cross House
 8 Duncannon Street
 London WC2N 4JF
 Ph: +44 (0) 207 484 5069
 Fax: +44 (0) 870 8310 381
 Mob: +44 (0) 7876 450102
 www.tiberone.com



 -Original Message-
 From: Action Request System discussion list(ARSList) [mailto:
 arsl...@arslist.org] On Behalf Of Frank Caruso
 Sent: 09 June 2009 11:46
 To: arslist@ARSLIST.ORG
 Subject: Long Time Saving Active Link

 --001636c5ad4dd05241046be810c3
 Content-Type: text/plain; charset=ISO-8859-1
 Content-Transfer-Encoding: 7bit

 ARS 7.1 p5
 SQL Server 2005
 Windows 2003

 Has anyone else noticed an issue with 7.1 where it takes a long time
to
 create and modify active links. I thought it was an issue with my last 
 environment but it appears to be the same way at my current shop.




___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSl
ist: Where the Answers Are

 --001636c5ad4dd05241046be810c3
 Content-Type: text/html; charset=ISO-8859-1
 Content-Transfer-Encoding: quoted-printable

 **
 div dir=3DltrdivARS 7.1 p5/div divSQL Server 2005/div 
 divWindows 2003/div div=A0/div divHas anyone else noticed an 
 issue with 7.1 where it takes a long
time
 t=
 o create and=A0modify active links. I thought it was an issue with my
last
 =
 environment but it appears to be the same way at my current shop.
/div
 /div
 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the
Answers
 Are_

 --001636c5ad4dd05241046be810c3--




___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSl
ist: Where the Answers Are



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

--0016e6d999da2bc1e0046be86f9b
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

**
div dir=3DltrdivI do have details turned on  looking at active li= 
nks without it is sort of useless=A0 :)/div div=A0/div divBut that did 
fix the problem. Without details active links save much f= aster./div 
div=A0/div divThankx!brbr/div div class=3Dgmail_quoteOn Tue, 
Jun 9, 2009 at 2:05 PM, David Morgan sp= an dir=3Dltrlt;a 
href=3Dmailto:dave.mor...@tiberone.com;dave.mor...@=
tiberone.com/agt;/span wrote:br
blockquote class=3Dgmail_quote style=3DPADDING-LEFT: 1ex; MARGIN:
0px 0=
px 0px 0.8ex; BORDER-LEFT: #ccc 1px solidHi FrankbrbrI think this is = a 
known issue - and I#39;ll bet you have the Details view switched on in t= he 
Admin toolbr brSwitch off details view and try to save an active 
link/filter/form etc.= brbrRegardsbrDave MorganbrbrDavid 
MorganbrSenior Technical Cons= ultantbr=A0brTiberone Technologies 
LimitedbrGolden Cross
Housebr8 D=
uncannon Streetbr
London WC2N 4JFbrPh: +44 (0) 207 484 5069brFax: +44 (0) 870 8310 381br=
Mob: +44 (0) 7876 450102bra href=3Dhttp://www.tiberone.com/;
target=3D=
_blankwww.tiberone.com/abr
div
div/div
div class=3Dh5brbrbr-Original Message-brFrom: Action Re= 
quest System discussion list(ARSList) [mailto:a href=3Dmailto:arsl...@ars= 
LIST.ORGarslist@ARSLIST.ORG/a] On Behalf Of 

AW: Lost form reference

[Conny Martin]

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



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


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

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



 

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

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

AW: Remedy 7.0 issue with Direct SQL in a filter

[Conny Martin]

Scott,
 
turn on SQL-Logging and you'll see the statement wich the arserver is
issueing against the database. I think this should point you in the
right direction.
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Scott Fluegge
Gesendet: Mittwoch, 3. Juni 2009 09:53
An: arslist@ARSLIST.ORG
Betreff: Remedy 7.0 issue with Direct SQL in a filter
Wichtigkeit: Hoch


** 

Anyone able to help me on a potentially simple Remedy question that has
my team stumped?  

 

This is in regards to a Remedy customization we need to do in our
environment.  It is with respect to custom filters invoking Direct SQL
(MS SQL 2005 database).  The SQL works PERFECT from the enterprise
manager but doesn't execute the complex query in Remedy.  I did 4 direct
SQL statements.  3 are complex and don't do anything.  The simple 4th
test (all are table updates) does work.  I can't for the life of me
figure out why the others fail.  I am pasting the SQL here in case you
can look into it...  I am desperate!!!  We are writing to hidden objects
within the incident record which SLM will use for notification.

 

Here is a sample that works:

update HPD_Help_Desk set SLP_EMAIL_TO = 'email_address_here' where
Incident_Number = '$Incident_Number$' and Assigned_Group like '%TIER 2%'

 

And this one does nothing... (No errors unless I invalidate the SQL so
seems a matching issue):

update HPD_Help_Desk set SLM_EMAIL_TO =
(rtrim(ltrim(substring(Assigned_Group, Charindex('-', Assigned_Group) +
1, Len(Assigned_Group + 't...@client.com'), SLM_EMAIL_BCC =
'serviced...@gssamerica.com' where Incident_Number = '$Incident_Number$'
and Assigned_Group like '%TIER 2%'

 

Can you help me???  Just to re-iterate, the SQL works perfect from SQL
Enterprise Manager (just changing the $Incident_Number$ to a real
number) so I know it is not a simple SQL error...

Thanks,

 

Scott

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: View Forms and Synoyms....

[Conny Martin]

Lisa,

View Forms using synonyms are working only if the owner of the underlying 
object is the same as the owner of the synonym. IMHO this is a bug.

Kind Regards Conny

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Kemes, Lisa
Gesendet: Montag, 1. Juni 2009 02:59
An: arslist@ARSLIST.ORG
Betreff: Re: View Forms and Synoyms

SQL client works just fine

We need to know if others are creating view tables using either a public 
synonym or a synonym owned by ARAdmin instead of using the table name?


Lisa

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Axton
Sent: Wednesday, May 27, 2009 11:48 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms and Synoyms

So what do the sql statements below return when run from your sql client?  Are 
synonyms available in all_tab_columns?  If they are not then you are probably 
out of luck using synonyms.

Axton Grams

On Wed, May 27, 2009 at 11:27 AM, Kemes, Lisa lisa.ke...@tycoelectronics.com 
wrote:
 Thanks Fred.  I tried this, but I'm still getting the error. (Even 
 though it's not captured on the SQL logs for some reason)

 */SELECT count(*) from all_tab_columns where table_name = 'COST_CENTER_V' and 
 owner = 'DCC'
 */OK
 */SELECT table_name from all_synonyms where synonym_name = 'COST_CENTER_V' 
 and owner = 'DCC'
 */OK


 Lisa

 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
 Sent: Wednesday, May 27, 2009 12:12 PM
 To: arslist@ARSLIST.ORG
 Subject: Re: View Forms and Synoyms

 Try adding in the owner of your synonym.

 Here is an excerpt of the server SQL Log.  This is with 7.1.0 Patch
 007 on Solaris w/Oracle 10i (Remote DB)

 Attempting to create a View Form on USER_VIEWS

 SQL   Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed 
 May 27 2009 10:49:37.0270 */ SELECT count(*) from all_tab_columns where 
 table_name = 'USER_VIEWS' and owner = 'ARADMIN'
 SQL   Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed 
 May 27 2009 10:49:37.0325 */OK SQL   Queue: Admin Client-RPC:
 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0327 */ SELECT 
 table_name from all_synonyms where synonym_name = 'USER_VIEWS' and owner = 
 'ARADMIN'
 SQL   Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed 
 May 27 2009 10:49:37.0574 */OK SQL   Queue: Admin Client-RPC:
 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0575 */ Error - can't 
 find table USER_VIEWS (owner = ARADMIN).

 Attempting to create a View Form on SYS.USER_VIEWS

 SQL   Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed 
 May 27 2009 10:51:30.7681 */ SELECT count(*) from all_tab_columns where 
 table_name = 'USER_VIEWS' and owner = 'SYS'
 SQL   Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed 
 May 27 2009 10:51:30.7696 */OK SQL   Queue: Admin Client-RPC:
 390600 USER: fwgrooms /* Wed May 27 2009 10:51:30.7699 */ SELECT 
 column_name,data_type,data_length,data_precision,data_scale from 
 all_tab_columns where table_name = 'USER_VIEWS' and owner = 'SYS'
 SQL   Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed 
 May 27 2009 10:51:30.7771 */OK


 Fred

 
 From: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa
 Sent: Wednesday, May 27, 2009 10:14 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: View Forms and Synoyms

 Yes it does work from the SQL Client.  Sorry, I should have specified 
 that.

 Lisa

 
 From: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza
 Sent: Wednesday, May 27, 2009 11:01 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: View Forms and Synoyms

 I thought I'd ask you the very obvious question... Can you query the view 
 form as aradmin from the SQL client when logged in as aradmin using that same 
 view name???

 Joe
 
 From: Kemes, Lisa lisa.ke...@tycoelectronics.com
 To: arslist@ARSLIST.ORG
 Sent: Wednesday, May 27, 2009 10:44:30 AM
 Subject: View Forms and Synoyms

 Got a ticket into BMC, we are having problems using Synonyms for our View 
 Forms.  Getting Requested Database table not found.  Please check the 
 spelling (table name is case-sensitive) ARERR 481.

 We are on 7.01 patch 3.  I thought this bug was fixed with SW00180955?

 Oracle 10i
 Windows 2003

 Lisa Kemes
 AR System Developer
 Tyco Electronics
 717-810-2408 tel
 717-810-2124 fax
 lisa.ke...@tycoelectronics.com

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

 __
 _ 

AW: Values of FieldType and FBOption in the table field..

[Conny Martin]

Joe,
 
from ar.h
 
FBOption
#define AR_FIELD_BITOPTION_NONE  0x /* no bit option */
#define AR_FIELD_BITOPTION_AUDIT 0x0001 /* BIT 0 - bit option to
audit */
#define AR_FIELD_BITOPTION_COPY  0x0002 /* BIT 1 - bit option to
copy when some field is being audited */
  /* 0x0003BIT 0  1 - indicates
AUDIT + COPY */
#define AR_FIELD_BITOPTION_LOG_KEY1 0x0004  /* BIT 2 - bit option to
indicate this field is log key 1 */
#define AR_FIELD_BITOPTION_LOG_KEY2 0x0008  /* BIT 3 - bit option to
indicate this field is log key 2 */
#define AR_FIELD_BITOPTION_LOG_KEY3 0x000c  /* BIT 2  3 - bit option to
indicate this field is log key 3 */
 
#define AR_FIELD_BITOPTION_AUDIT_MASK 0x0003 /* mask to check if any
audit option is set */
#define AR_FIELD_BITOPTION_AUDIT_LOG_KEY_MASK 0x000c /* mask to check if
any audit log key is set */
 
FieldType
#define AR_FIELD_NONE 0  /* null field */
#define AR_FIELD_REGULAR  1  /* field of regular schema */
#define AR_FIELD_JOIN 2  /* field of join schema */
#define AR_FIELD_VIEW 3  /* field of view schema */
#define AR_FIELD_VENDOR   4  /* field of vendor schema */
#define AR_FIELD_INHERITANCE  5  /* field of inheritance type */
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Joe DeSouza
Gesendet: Mittwoch, 27. Mai 2009 20:56
An: arslist@ARSLIST.ORG
Betreff: Values of FieldType and FBOption in the table field..


** 
I had a compiled a list of what these values meant. I don't seem to find
where I kept that information.. Does anyone have it handy?
 
I need to write a db script to change some value in a field and it would
be nice to have this info. I looked up the ar.h file (which I usually do
when looking for such info) but I sort of have forgotten what to grep
for to return only that section for finding the map to these values.. I
did find the data type though..
 
FieldType
0 - 
1 - 
2 - 
3 - 
4 - 
 
FBOption
0 - 
1 - 
2 - 
3 - 
4 - 
5 - 
6 - 
8 - 
10 - 
14 - 
 
DataType
0 - NULL
1 - KEYWORD
2 - Integer Field
3 - Real Field
4 - Character Field
5 - Diary Field
6 - Enum (Drop Down) Field
7 - Time Field
10 - Decimal Field
11 - Attachment Field
12 - Currency Field
13 - Date Field
14 - Time of Day Field
31 - Visual Trim Field
32 - Control button, Menu Icon Field
33 - Table Field
34 - Table Column Field
35 - Page Field
36 - Page Holder Field
37 - Attachment Pool Field
40 - ULONG
41 - COORDS
42 - View Field
43 - Display Field

 

Cheers

 

Joe


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_

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

AW: Values of FieldType and FBOption in the table field..

[Conny Martin]

this is foption not fboption



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Grooms, Frederick W
Gesendet: Mittwoch, 27. Mai 2009 21:32
An: arslist@ARSLIST.ORG
Betreff: Re: Values of FieldType and FBOption in the table field..


** 

Actually I believe the FBOPTION in FIELD is:

 

#define AR_FIELD_OPTION_REQUIRED   1   /* tags for field definition
option */

#define AR_FIELD_OPTION_OPTIONAL   2

#define AR_FIELD_OPTION_SYSTEM 3   /* system field; read-only to ALL
users */

   /*  NOTE that fields cannot be
created  */

   /*   with nor set to this option
*/

#define AR_FIELD_OPTION_DISPLAY4   /* display-only field; no data
will be */

   /*  stored for this field in the
DB*/

 

Fred

 

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Conny Martin
Sent: Wednesday, May 27, 2009 2:21 PM
To: arslist@ARSLIST.ORG
Subject: AW: Values of FieldType and FBOption in the table field..

 

** 

Joe,

 

from ar.h

 

FBOption

#define AR_FIELD_BITOPTION_NONE  0x /* no bit option */
#define AR_FIELD_BITOPTION_AUDIT 0x0001 /* BIT 0 - bit option to
audit */
#define AR_FIELD_BITOPTION_COPY  0x0002 /* BIT 1 - bit option to
copy when some field is being audited */
  /* 0x0003BIT 0  1 - indicates
AUDIT + COPY */
#define AR_FIELD_BITOPTION_LOG_KEY1 0x0004  /* BIT 2 - bit option to
indicate this field is log key 1 */
#define AR_FIELD_BITOPTION_LOG_KEY2 0x0008  /* BIT 3 - bit option to
indicate this field is log key 2 */
#define AR_FIELD_BITOPTION_LOG_KEY3 0x000c  /* BIT 2  3 - bit option to
indicate this field is log key 3 */

 

#define AR_FIELD_BITOPTION_AUDIT_MASK 0x0003 /* mask to check if any
audit option is set */
#define AR_FIELD_BITOPTION_AUDIT_LOG_KEY_MASK 0x000c /* mask to check if
any audit log key is set */

 

FieldType

#define AR_FIELD_NONE 0  /* null field */
#define AR_FIELD_REGULAR  1  /* field of regular schema */
#define AR_FIELD_JOIN 2  /* field of join schema */
#define AR_FIELD_VIEW 3  /* field of view schema */
#define AR_FIELD_VENDOR   4  /* field of vendor schema */
#define AR_FIELD_INHERITANCE  5  /* field of inheritance type */

 

HTH

 

Kind Regards Conny

 



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Joe DeSouza
Gesendet: Mittwoch, 27. Mai 2009 20:56
An: arslist@ARSLIST.ORG
Betreff: Values of FieldType and FBOption in the table field..

** 

I had a compiled a list of what these values meant. I don't seem to find
where I kept that information.. Does anyone have it handy?

 

I need to write a db script to change some value in a field and it would
be nice to have this info. I looked up the ar.h file (which I usually do
when looking for such info) but I sort of have forgotten what to grep
for to return only that section for finding the map to these values.. I
did find the data type though..

 

FieldType
0 - 
1 - 
2 - 
3 - 
4 - 

 

FBOption
0 - 
1 - 
2 - 
3 - 
4 - 
5 - 
6 - 
8 - 
10 - 
14 - 

 

DataType
0 - NULL
1 - KEYWORD
2 - Integer Field
3 - Real Field
4 - Character Field
5 - Diary Field
6 - Enum (Drop Down) Field
7 - Time Field
10 - Decimal Field
11 - Attachment Field
12 - Currency Field
13 - Date Field
14 - Time of Day Field
31 - Visual Trim Field
32 - Control button, Menu Icon Field
33 - Table Field
34 - Table Column Field
35 - Page Field
36 - Page Holder Field
37 - Attachment Pool Field
40 - ULONG
41 - COORDS
42 - View Field
43 - Display Field

 

Cheers

 

Joe


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: mid-tier config.jsp can not login

[Conny Martin]

LD_LIBRARY_PATH must include the path to libarutiljni71.so
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von ??
Gesendet: Sonntag, 24. Mai 2009 13:16
An: arslist@ARSLIST.ORG
Betreff: mid-tier config.jsp can not login


Hi, all
 
I installed mid-tier7.1 patch007 under Linux Rathat 5, with it's own
tomcat 5.5, i start up tomcat, and want to config my mid-tier, but in
the config.jsp web pager, can not login, tomcat get an error like this:
 
ConfigServlet /arsys/servlet/ConfigServlet?action=logon
- Could not load native library
java.lang.UnsatisfiedLinkError: no arutiljni71 in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1682)
at java.lang.Runtime.loadLibrary0(Runtime.java:822)
at java.lang.System.loadLibrary(System.java:993)
at com.bmc.arsys.api.NativeLibraryLoader.load(Unknown Source)
at com.bmc.arsys.util.ARUtilEgcp.clinit(ARUtilEgcp.java:12)
at com.remedy.arsys.config.Configuration.login(Unknown Source)
at com.remedy.arsys.config.ConfigServlet.login(Unknown Source)
at com.remedy.arsys.config.ConfigServlet.doLogin(Unknown Source)
at
com.remedy.arsys.config.ConfigServlet.performOperation(Unknown Source)
at com.remedy.arsys.config.ConfigServlet.doRequest(Unknown
Source)
at com.remedy.arsys.config.ConfigServlet.postInternal(Unknown
Source)
at com.remedy.arsys.config.ConfigServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
51)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:87
0)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:685)
at java.lang.Thread.run(Thread.java:595)
- Servlet.service() for servlet ConfigServlet threw exception
java.lang.UnsatisfiedLinkError: CCPUtilApp
at com.bmc.arsys.util.ARUtilEgcp.CCPUtilApp(Native Method)
at com.remedy.arsys.config.Configuration.login(Unknown Source)
at com.remedy.arsys.config.ConfigServlet.login(Unknown Source)
at com.remedy.arsys.config.ConfigServlet.doLogin(Unknown Source)
at
com.remedy.arsys.config.ConfigServlet.performOperation(Unknown Source)
at com.remedy.arsys.config.ConfigServlet.doRequest(Unknown
Source)
at com.remedy.arsys.config.ConfigServlet.postInternal(Unknown
Source)
at com.remedy.arsys.config.ConfigServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
51)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:87
0)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:528)
at

AW: Japanese Remedy AR Server v6.3

[Conny Martin]

Rick,
 
AFAIK, all patches includes the same languages as the initial release.
Patches for 6.3 are available through supportweb.
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Rick Cook
Gesendet: Freitag, 22. Mai 2009 18:14
An: arslist@ARSLIST.ORG
Betreff: Japanese Remedy AR Server v6.3


** 

I have need of this, to test some localization for an integration I am
supporting a connector to.

Neither Support nor my local sales engineer says they can get it,
because it is no longer on the EPD.  They say they have no awareness of
any back channel to bypass this.  FWIW, I will probably need the German
version, and whatever other languages are available, at some point in
the near future.  I can get a patched version, but those are only in
English, as far as I know.

I don't care if it's a patched or unpatched version, if it's available,
I need it, and I would appreciate any help I could get in getting it.

Rick

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: Filter Table Looping - Phase Issue

[Conny Martin]

Bala,
 
don't use a table loop. Do a push field to the form where you define
your destination servers. Let's call this form DSO:Config. You need to
push the request_id into a temporary (display only) field. A second
filter running on DSO:Config does the Distributed-Transfer. I've
implemented this for Distributed-Delete but it should also work for
Transfer.
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Bala Patel
Gesendet: Freitag, 15. Mai 2009 19:57
An: arslist@ARSLIST.ORG
Betreff: Re: Filter Table Looping - Phase Issue


** 
All,
 
I had a question about Filter table looping and phases.  I am creating a
table field on a form that will be used to DSO tickets to each selected
server that has been added into the tables form.  When I save the
ticket, the table field should be looped through. A distributed transfer
should be performed for each server that is in the loop.
 
The  issue I am having is that I have to add the `! to the end of the
filter which makes everything happen during Phase I.  The Distributed
Transfer fails since it is happening in phase I. The DSO transfer should
happen during a later phase and not phase I.  If I take the `! off the
filter, then the filter loops and uses only the first record value for
each record in the table field.  Does anyone know of another method to
do this or a way around this?
 
ARS 7.1
Custom applications
 SQL 2005
Windows 2003 Server
 
Thanks very much.
 
 
Bala

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_

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

AW: what is T1 used for?

[Conny Martin]

Serouche,
 
I'm not familiar with sybase, but on some DB's (e.g. Informix) changing
the length from 255 to 4000 causes a datatype change of the column. If
that's the case ARS creates a new column with the new datatype, copy's
the data from old to new column, drops old column and renames new column
to old column name. 
 
I think there was some problem and ARS has already created the new
column. If you try to do the same again, the db is complaining about
already existing column name. But to be sure whats going on, turn on
SQL-Logging and you'll see the failing sql statement.
 
HTH
 
Regards Conny
 
PS: The new columns are generally named old_nameZ. So if youre
changing field with ID 536870915 from 255 to 4000, your new column name
will be C536870915Z.



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Remedy Maniac
Gesendet: Donnerstag, 14. Mai 2009 10:49
An: arslist@ARSLIST.ORG
Betreff: Re: what is T1 used for?


** thank you Misi.
It's realy good to know there are people out there who care about
others.
My problem is now solved. It's still unclear to me what was the issue.
But as a matter of fact here is what happend:
I was trying to modify a character field from a length of 255 to 4000
I did the change on the dev server and it went ok
On the production the Admin tool answered back some problems and that T1
could not be found on the server (Sybase).
Right after this no connection was possible anymore.
My DBA checked and he could see ARAdmin is logged into master which
should not be.
And where T1 is not.
So kicked ARAdmin out of master so I could login again.
But then just to display the list of forms in the admin tool was hanging
for ever
So I thought it could be somehow T1
But as I see T1 is for Message Catalog.
So I don't see the relation.
But anyway.
Has anybody already experienced something similar?
By the way, now I am able to access the forms but if I try to perform
the same change I did on dev, I get an error that the column exists 2
times in the table.
Strange, no?

Serouche



Misi Mladoniczky wrote: 

Hi,

T1 corresponds to a Remedy-form, and data needs to be copied
parallel with
the H1 and B1 table.

To understand which form this is, you must check the
ARSCHEMA-table. The
T1 table may be completely different.

select name from arschema where schemaid=1

The above SQL will give you the form name.

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

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

  

dear all,

I am not able to access my server with the admin tool
anymore.
T1 is empty.
I suspect this must be the problem.
How and when and why that happend, is really not my
concern.
I'll investigate later.
What I need right now is to know how to recover?
Can I simply copy the content of T1 from my dev server
to my prod?
Many thanks for your help
Serouche



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

--
This message was scanned by ESVA and is believed to be
clean.






___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
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

AW: Index disparity between Remedy and Informix

[Conny Martin]

schema_index
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Steve McDonald
Gesendet: Donnerstag, 14. Mai 2009 20:41
An: arslist@ARSLIST.ORG
Betreff: Index disparity between Remedy and Informix


** 
Hello All,
 
On one of my email forms, Remedy says I have 2 indexes, Informix says I
have none.  Can someone tell me which admin table stores the Remedy
listing on indexes?  I'm familiar with DBAccess and need to drop them
from the table.
 
 
Thanks
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: ARS Perl Installation Error

[Conny Martin]

Ritesh,
 
sh: cc: not found means there is no C-Compiler installed or it's not
in your PATH env-var.
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Ritesh-HOTMAIL
Gesendet: Donnerstag, 7. Mai 2009 11:36
An: arslist@ARSLIST.ORG
Betreff: ARS Perl Installation Error


** 

Hi All,

 

While installing ARS perl I am getting the following error:

 

bash-2.05$ make

Skip blib/lib/ARSnt-h.pm (unchanged)

Skip blib/lib/ARS.pm (unchanged)

Skip blib/lib/artypes.ph (unchanged)

Skip blib/lib/ARSOOmsgs.pm (unchanged)

Skip blib/lib/ARSnparm.pm (unchanged)

Skip blib/lib/ARSarerrno-h.pm (unchanged)

Skip blib/lib/ARSar-h.pm (unchanged)

Skip blib/lib/ARSOOform.pm (unchanged)

Skip blib/lib/ARSnterrno-h.pm (unchanged)

Skip blib/lib/_h2ph_pre.ph (unchanged)

Skip blib/lib/ARSOOsup.pm (unchanged)

cc -c -I/local/apps/remedy/ARSPerl/API/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -xO3 -xdepend-DVERSION=\1.84\
-DXS_VERSION=\1.84\ -KPIC
-I/usr/perl5/5.6.1/lib/sun4-solaris-64int/CORE -g  -DARS32  -DARS452
-DPERL_PATCHLEVEL_IS=6 -DPERL_SUBVERSION_IS=1 -DPERL_BASEREV_IS=50 ARS.c

sh: cc: not found

*** Error code 1

make: Fatal error: Command failed for target `ARS.o'

 

 

I get this error while executing the make command. Kindly suggest.

 

Version/Environment:

ARS Perl 1.85

ARS APIs for 6.3 patch 20

OS: Sun Solaris 5.9

 

Thanks,

Ritesh

ritesh.kaly...@gmail.com 

 

 

 

 

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: Accellerating the 6.3 - 7.x upgrade process

[Conny Martin]

this problem won't occur on an Oracle Database. I've upgraded several
AR-Servers from 6.3 to 7.1 within 20 Minutes having tables containing
over 100 million records.
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Steve McDonald
Gesendet: Dienstag, 28. April 2009 21:55
An: arslist@ARSLIST.ORG
Betreff: Accellerating the 6.3 - 7.x upgrade process


** 
Hello All,
 
Disclaimer:  This upgrade involved an Informix upgrade as well.
 
While testing the ARSystem upgrade process, what we thought would be
around 4 hours turned into about 12.   With tables containing nearly two
million records and an audit trail table with over 9 million, the outage
would have been unacceptable.  What we found was the ARSystem database
upgrade was increasing the length of  three columns, c2, c4, and c5, in
every table that had them to varchar(254). 
 
As part of our upgrade we were changing from v9.4 - v10 of Informix.
My DBA had already created scripts to migrate the data from the 9.4
instance to the 10.0 instance by first creating empty tables and then
moving the data.  By changing his scripts to pre-alter the three columns
in the largest table BEFORE moving in the data, we saved 11 hours of
upgrade time as the ARSystem alter effectively did nothing to the table.
The problem with Remedy's upgrade script is that it performs 3 seperate
alters for every table it changes instead of one alter to change all 3
at once.
 
Having a talented DBA is a good thing!
 
Hope this helps someone.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Are_ 

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

AW: Want to migrate 60,000 odd records from Dev to UAT env bypassing arimport. Please suggest

[Conny Martin]

Bhupesh,
 
if your form doesn't contain any attachment fields you can copy the
records via database link.
 
insert into txxx select * from t...@dev;
insert into hxxx select * from h...@dev;
 
xxx = schemaid of your form.
 
Kind Regards Conny 



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Bhupesh Gupta
Gesendet: Mittwoch, 29. April 2009 13:13
An: arslist@ARSLIST.ORG
Betreff: Re: Want to migrate 60,000 odd records from Dev to UAT env
bypassing arimport. Please suggest


** 
To add more details;
 
DB is oracle 10G
Remedy Version 7.5


On Wed, Apr 29, 2009 at 6:02 AM, Rod Harris r...@smapps.com.au wrote:


On the website there is an interactive guide to creating a
config file. You just need to follow the prompts. At the end of it all
you can just copy and paste the text into a file. This is the best way
to get started I think. 
 


 
2009/4/29 Bhupesh Gupta gupta.bhupesh3...@gmail.com 


Can you please help me to use it.






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

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

AW: Number Validation

[Conny Martin]

Sachin,

you can use following Run-If Qualification to check a field for numbers and 
display an error message if not

Run-IF:
not ('tmp_field' like [0-9] or 'tmp_field' like [0-9][0-9] or 'tmp_field' 
like [0-9][0-9][0-9] or 'tmp_field' like [0-9][0-9][0-9][0-9])

If Action:
Error-Message

Kind Regards Conny


-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von nsachin
Gesendet: Montag, 27. April 2009 12:19
An: arslist@ARSLIST.ORG
Betreff: Re: Number Validation

Thanks Shafqat,

I had used $DIGIT$ patten in the temporary field.But the error message contains 
the field id of this temporary field if this field doesn't contain 
numbers.Instead,i want to give a customized message if the format of the 
character field is not like 'APP1234' i.e alphates and then followed by number.

Regards,



Hi
you could look at the keyword $DIGIT$. You can define this in the pattern field 
on the Attributes tab of the field properties.
if you need further help drop me a line

shafqat



--- On Mon, 4/27/09, nsachin sachin.namjo...@gmail.com wrote:

 From: nsachin sachin.namjo...@gmail.com
 Subject: Number Validation
 To: arslist@ARSLIST.ORG
 Date: Monday, April 27, 2009, 5:22 AM
 Hello Listers,
 
 I have one character field.This field should contain 'characters and 
 then followed by numbers'.For example the field should contain the 
 value of 'PRQ1234'.I am extracting the string after PRQ in a temporary 
 field.So,the temporary field will have value if 1234 in this case.But, 
 if this temporary field contains a value other than numbers,then the 
 user should get a error message.
 
 How should i check if this  temporary field contains only numbers 
 after alphabets?
 
 Please help me on this.
 
 :confused:
 --
 View this message in context:
 http://n2.nabble.com/Number-Validation-tp2721765p2721765.html
 Sent from the ARS (Action Request System) mailing list archive at 
 Nabble.com.
 
 __
 _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
 Platinum Sponsor:rmisoluti...@verizon.net ARSlist:
 Where the Answers Are


  

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



--
View this message in context: 
http://n2.nabble.com/Number-Validation-tp2721765p2724988.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

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

AW: ARServer group and the ports that require load balancing

[Conny Martin]

George,
 
IMHO this is the relevant part of the documentation. 
 
Specifying plug-in server aliases (Step 4e)

When you specify a common AR System server alias, AR System uses the alias

name to connect to the plug-in server. When the AR System server is connecting 
to

its local plug-in server, the connection will not be successful if the server 
name

resolves to anything other than the local server.

To route connections successfully in an environment where the server name

resolves to a load balancer, you must define plug-in server aliases. The 
purpose of

this step is to designate the local server as the host, not to change the name 
of the

plug-in.

 To specify plug-in server aliases

Add an alias definition for each loaded plug-in to the configuration file, 
using the

plug-in name specified in the plug-in definition. Use the following format,

substituting the alias name, plug-in name, host name, and optional port number:

Server-Plugin-Alias: plug-in_alias_name plug-in_real_name

host_name[:port_number]

The AR System server connects to the plug-in server using host host_name at

port port_number when the AR System server communicates with the plugin_

alias_name plug-in. Host host_name must resolve to the local AR System

server, and the port number is specified if the plug-in server is listening on a

particular port. The following definition is a typical example:

Server-Plugin-Alias: ARSYS.ARDBC.REPORT ARSYS.ARDBC.REPORT myserver:2020

For more information about Server-Plugin-Alias, see “ar.conf (ar.cfg)” on

page 248.

 
 
We have a similar setup and solved this problem in a different way. We added 
the following line to /etc/hosts
 
127.0.0.1   itsm.telekom.de
 
itsm.telekom.de is configured as common server alias in ar.conf which is used 
to connect to the plugin server. 
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von George Jungle
Gesendet: Dienstag, 7. April 2009 03:21
An: arslist@ARSLIST.ORG
Betreff: ARServer group and the ports that require load balancing


** Guys,

Wondering if you can help me out.

We've got an issue with the Plug-in server running within a high available 
environment of Remedy (2 Midtiers, 2 AR Servers, 2 DB Servers) with each tier 
separated by a firewall.   There is one load balancer in front of the midtier 
servers and another in front of the AR Servers.   So, basically the AR Servers 
are running within a Server Group.

When we try to open up a Remedy form, such as the Server Information form, we 
get an error saying : 

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

Currently the only port that is load balanced is the TCP port that the users 
access the AR Servers by.

Should we also need to load balance the Plug-In port? (9000)?

All help is appreciated.

Below are some emails I've dug up just from searching the web... 

Thanks.

George




Re: RPC: Unable to receive

Tony Worthington
Mon, 06 Aug 2007 11:27:16 -0700

You probably need to review the BMC documents about plugins behind a VIP 
or firewall without a portmapper.  Using a Hardware Load Balancer with 
BMC Remedy Action Request System 7.0 page 9, and others that I can't find 
at the moment.

Here's an example of some lines from one of our ar.conf's (this one from a 
server group, but relevant since we don't use portmapper either)

Plugin-Port: 9000
Register-With-Portmapper: F
TCD-Specific-Port: 8639
Server-Plugin-Alias: ARSYS.ARDBC.CONFIGFILE ARSYS.ARDBC.CONFIGFILE 
ksms562:9000
Server-Plugin-Alias: ARSYS.ARDBC.LDAP ARSYS.ARDBC.LDAP ksms562:9000
Server-Plugin-Alias: ARSYS.ARDBC.PREVIEW ARSYS.ARDBC.PREVIEW ksms562:9000
Server-Plugin-Alias: ARSYS.AREA.LDAP ARSYS.AREA.LDAP ksms562:9000
Server-Plugin-Alias: ARSYS.ARF.WEBSERVICE ARSYS.ARF.WEBSERVICE 
ksms562:9000
Server-Plugin-Alias: BMC.ARF.CMDBCONSOLE BMC.ARF.CMDBCONSOLE ksms562:9000
Server-Plugin-Alias: REMEDY.ARDBC.APPQUERY REMEDY.ARDBC.APPQUERY 
ksms562:9000
Server-Plugin-Alias: REMEDY.ARDBC.FLASHBOARD.FORM 
REMEDY.ARDBC.FLASHBOARD.FORM ksms562:9000
Server-Plugin-Alias: REMEDY.ARDBC.SERVER.ADMINISTRATION 
REMEDY.ARDBC.SERVER.ADMINISTRATION ksms562:9000
Server-Plugin-Alias: REMEDY.ARF.CAI REMEDY.ARF.CAI ksms562:9000
Server-Plugin-Alias: REMEDY.ARF.CBDATA REMEDY.ARF.CBDATA ksms562:9000
Server-Plugin-Alias: REMEDY.ARF.OMFOBJIE REMEDY.ARF.OMFOBJIE ksms562:9000
Server-Plugin-Alias: REMEDY.ARF.SLASETUP REMEDY.ARF.SLASETUP ksms562:9000

You may not need the alias lines, but you certainly need the Plugin-Port.

hth,
tony

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



Mike Chepaykin [EMAIL PROTECTED] 
Sent by: Action Request System discussion list(ARSList) 
arslist@ARSLIST.ORG
08/06/2007 10:12 AM
Please 

AW: SUBSTRC using 3rd parameter

[Conny Martin]

Andreas,
 
this is a known problem if you're using a non-English Client.
 
Put a space after 0.
 
SUBSTRC($Version$, 0 , STRSTRC($Version$, .)-1)
 
The problem is, that the Admintool treats the second parameter as a
number with a decimal separator and expects a number after the comma. So
you can also write
 
SUBSTRC($Version$, 0,0, STRSTRC($Version$, .)-1)
 
If you were using an english client your decimal separator is a . (dot)
and you won't have this problem
 
 
This is what BMC suggests in the admintool help.

Specifying arguments that use a comma as a decimal separator 

Specifying arguments that use a comma as a decimal separator (as is the
case in a German locale, for example) requires special consideration for
the following functions: 


*   LPAD

*   RPAD

*   MAX

*   MIN

*   SUBSTR

To specify an argument that uses a comma as a decimal separator 


1.  Use a hidden, read-only field, and assign a default value to it.

2.  Use the appropriate field keywords as arguments.
For example, instead of using SUBSTR($Character Field$, 56, 65)
use SUBSTR($Character Field$, $Integer1$, $Integer2$) where Integer1 and
Integer2 are hidden, read-only fields with default values of 56 and 65
assigned to them, respectively. 

The following table lists the functions you can use in a Set Fields
action.

IMHO this is a very crazy workaround for this problem.
 
HTH
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Andreas Munch
Gesendet: Dienstag, 7. April 2009 10:59
An: arslist@ARSLIST.ORG
Betreff: SUBSTRC using 3rd parameter


** 
Hey everyone
 
ARS 6.03.00
MSSQL 2005
 
Problem:
 
Actually this proberbly is a novice question, but...
 
I'm trying to remove the .'s from the ARS Version information, pushing
it to a Form containing users client version. This version information
comes as a string eg. 6.03.00 or 7.1.00. For comparison of client
versions I need to remove the .'s from then string ending up with only
digits which I then can assign to an integer field.
 
I'm using then command (for the first part) SUBSTRC($Version$, 0,
STRSTRC($Version$, .)-1) but are getting an error message as:
Unexpected character (ARERR 2291) zIntVersionMajor  [Assign line error
at position 29]. If I'm trying to only provide the two first parameters
I'm not getting the error message, but the third one is the error
trigger. Trying to do other stuff it seems like I'm not allowed to use
the 3rd parameter.
 
What can be then mistake I'm doing while using the SUBSTRC function with
all 3 parameters causing then error message?
 
 
A. Munch
 
__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

AW: Interesting Bug in User Tool

[Conny Martin]

Ben,
 
try latest patch of User Tool. This Bug has been fixed.
 
Kind Regards Conny



Von: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] Im Auftrag von Ben Chernys
Gesendet: Donnerstag, 26. März 2009 10:06
An: arslist@ARSLIST.ORG
Betreff: Interesting Bug in User Tool


** 
ITSM 7.0.3 Patch 5
ARS 7.1
Sun Solaris 5.10
Oracle 10g2

Run a Query on HPD:Help Desk (ITSM 7), arrange the result list column s  so 
that the Date is the first column.  Try to sort by date.  No action.  Works 
fine for other fields at the first column and works fine for date in any column 
except number 1.

Noticed in Production. 

Cheers 
Ben 

__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