AW: EXTERNAL: Application-Query-Delete-Entry

2016-09-02 Thread 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

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

2012-06-22 Thread 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

AW: Java API connection pool question..

2012-04-14 Thread 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

AW: DSO Issue

2012-03-27 Thread 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

AW: 32bit Vs.64bit JVM performance

2012-02-08 Thread 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)

Floating users get a floating write token on read operations

2011-03-25 Thread 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

AW: ARS 7.5p007 on SLES11

2011-03-10 Thread Conny Martin
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

AW: ARS 7.5p007 on SLES11

2011-03-06 Thread Conny Martin
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

AW: ARS 7.5p007 on SLES11

2011-03-04 Thread 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

AW: How to configure the Java Plugin to the ARServer

2011-03-04 Thread 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

AW: ARInside 3.0.2 released

2011-03-04 Thread 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:

AW: ORACLE Cursor Sharing

2010-11-29 Thread 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

AW: arcache

2010-08-12 Thread 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:

AW: Curious Advanced Search

2010-07-02 Thread 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

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

2010-07-01 Thread 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

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

2010-06-29 Thread 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

AW: Load Balancer Recommendations 7.5 AR Server Environment

2010-05-10 Thread 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

AW: Load Balancer Recommendations 7.5 AR Server Environment

2010-05-10 Thread Conny Martin
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

AW: Any ksh shell experts on the list?

2010-04-24 Thread 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

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

2010-04-21 Thread 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

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

2010-04-21 Thread Conny Martin
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

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

2010-04-20 Thread 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

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

2010-04-20 Thread Conny Martin
? 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

AW: Problem with JAVA API

2010-03-19 Thread 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

AW: ARSperl on RedHat Linux.

2010-03-18 Thread 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)

AW: Admin tool crashing

2010-03-17 Thread 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)

AW: Admin tool crashing

2010-03-17 Thread Conny Martin
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

AW: ARSPerl on RedHat Linux Question

2010-03-16 Thread 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

AW: SSL certificate for incoming and outgoing ar email

2010-03-09 Thread 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)

AW: Active Link Question

2010-03-08 Thread 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

AW: arcache and arreload (ARS7.1 patch004)

2010-02-22 Thread 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.

AW: Help with Sybase indexes

2010-02-22 Thread 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 =

AW: SQL help needed

2010-02-16 Thread 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

AW: Web Services - please enlight me!

2010-02-15 Thread 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:

AW: ARSperl with ARS 7.5 running on 64bit

2010-02-08 Thread 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

AW: Error while starting a server group member

2010-02-03 Thread 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

AW: Server group testing

2010-01-14 Thread 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

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

2010-01-13 Thread 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)

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

2010-01-13 Thread Conny Martin
: 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

AW: Can't sort table field column

2009-12-21 Thread 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,

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

2009-12-13 Thread 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

Get result from stored procedure

2009-12-10 Thread 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

AW: Get result from stored procedure

2009-12-10 Thread Conny Martin
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

Resolved: Get result from stored procedure

2009-12-10 Thread Conny Martin
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

AW: How to implement HA architecture?

2009-12-06 Thread 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)

AW: ARSPERL on RHEL to talk to ARS 6.3?

2009-12-04 Thread 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)

AW: Advanced Search/field ID?

2009-11-23 Thread 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

AW: Firewall TCP Timeouts

2009-11-18 Thread 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)

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

2009-11-18 Thread 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

AW: Firewall TCP Timeouts

2009-11-18 Thread Conny Martin
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

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

2009-11-12 Thread 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

AW: Load Balancer setup with remedy

2009-11-11 Thread 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

AW: Looooooooooong update times on ARSCHEMA

2009-11-04 Thread 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

AW: AW: Password for Demo Account ? Reset.

2009-10-27 Thread Conny Martin
: 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

AW: Password for Demo Account ? Reset.

2009-10-26 Thread 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

AW: Problem with plugins

2009-10-23 Thread 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

AW: Menu to list flters of a form

2009-10-18 Thread 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)

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

2009-09-24 Thread 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

AW: Filter qualification using !=

2009-09-16 Thread 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' =

AW: ARERR 298 Too Many Filter since upgrade to 7.1

2009-09-15 Thread 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

AW: Strange errors...help appreciated....

2009-09-10 Thread 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.

AW: Error - Reached maximum number of database entries...

2009-09-09 Thread 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:

AW: New fields added becomes Core fields

2009-09-03 Thread 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.

AW: New fields added becomes Core fields

2009-09-02 Thread Conny Martin
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

AW: New fields added becomes Core fields

2009-09-02 Thread Conny Martin
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

AW: New fields added becomes Core fields

2009-09-01 Thread 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

AW: Menu problem....Group List id issue ?

2009-08-31 Thread 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

AW: Remedy API and gcc on Redhat Linux

2009-08-22 Thread Conny Martin
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

AW: Remedy API and gcc on Redhat Linux

2009-08-21 Thread 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 =

AW: ARIMPORTCMD Problem with accentuation

2009-08-13 Thread 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:

AW: Server-side Log Files empty

2009-08-11 Thread 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

AW: Webservice - HTTPS problem :o(

2009-08-03 Thread 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:

AW: Users unable to log in (ARERR 90)

2009-08-03 Thread 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

AW: Unable to connect to secondry host in tnsnames.ora

2009-07-21 Thread 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.

AW: Performance Issue Please Give Me Any Suggesstion

2009-07-16 Thread 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

AW: Allowing users to enter leading characters in search menu field

2009-07-13 Thread 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:

AW: Allowing users to enter leading characters in search menu field SOLVED

2009-07-13 Thread Conny Martin
? 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

AW: Old Install Files

2009-07-07 Thread 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.

AW: How do I Change the ARAdmin password Remedy uses Without having Remedy up

2009-07-02 Thread 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

AW: Installation of AR server 7.1 - No Alert Events form could be found on the server (ARERR 3300)

2009-06-30 Thread 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

AW: Root cause of Nextid out of wack after DB restore

2009-06-22 Thread 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)

AW: Re : AW: RESOVLED Re: Long Time Saving Active Link

2009-06-10 Thread Conny Martin
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

AW: RESOVLED Re: Long Time Saving Active Link

2009-06-09 Thread 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

AW: Lost form reference

2009-06-04 Thread 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:

AW: Remedy 7.0 issue with Direct SQL in a filter

2009-06-03 Thread 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)

AW: View Forms and Synoyms....

2009-06-02 Thread 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

AW: Values of FieldType and FBOption in the table field..

2009-05-27 Thread 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 */

AW: Values of FieldType and FBOption in the table field..

2009-05-27 Thread Conny Martin
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

AW: mid-tier config.jsp can not login

2009-05-24 Thread 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

AW: Japanese Remedy AR Server v6.3

2009-05-22 Thread 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

AW: Filter Table Looping - Phase Issue

2009-05-15 Thread 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

AW: what is T1 used for?

2009-05-14 Thread 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

AW: Index disparity between Remedy and Informix

2009-05-14 Thread 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

AW: ARS Perl Installation Error

2009-05-07 Thread 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

AW: Accellerating the 6.3 - 7.x upgrade process

2009-04-29 Thread 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)

AW: Want to migrate 60,000 odd records from Dev to UAT env bypassing arimport. Please suggest

2009-04-29 Thread 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

AW: Number Validation

2009-04-27 Thread 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

AW: ARServer group and the ports that require load balancing

2009-04-07 Thread 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,

AW: SUBSTRC using 3rd parameter

2009-04-07 Thread 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

AW: Interesting Bug in User Tool

2009-03-26 Thread 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

  1   2   >