arsperl-users — Discussions regarding the use of ARSperl

[Arsperl-users] Install problems 1.83 on Solaris 8...

[Misi M. <mi...@rr...>]

Hi,

I am having problems doing "make test" on Solaris 8 with ARSPerl 1.83 and
ARAPI version 6.3.

"make test" gives me a lot of errors, but I did a "make install" anyway.
This is what happens when i try to use ARS:
# perl
use ARS;
Can't locate auto/ARS/autosplit.ix in @INC (@INC contains:
/usr/local/lib/perl5/5.8.5/sun4-solaris /usr/local/lib/perl5/5.8.5
/usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris
/usr/local/lib/perl5/site_perl/5.8.5 /usr/local/lib/perl5/site_perl .) at
/usr/local/lib/perl5/5.8.5/AutoLoader.pm line 160.
 at ARS.pm line 64

This is some of the output from "make test":
# make test
...
t/10getlist..........Can't locate auto/ARS/autosplit.ix in @INC (@INC
contains: /data/urbekl/ARSperl-1.83/blib/lib
/data/urbekl/ARSperl-1.83/blib/arch
/usr/local/lib/perl5/5.8.5/sun4-solaris
/usr/local/lib/perl5/5.8.5/sun4-solaris /usr/local/lib/perl5/5.8.5
/usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris
/usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris
/usr/local/lib/perl5/site_perl/5.8.5
/usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris
/usr/local/lib/perl5/site_perl/5.8.5 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.8.5/sun4-solaris /usr/local/lib/perl5/5.8.5
/usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris
/usr/local/lib/perl5/site_perl/5.8.5 /usr/local/lib/perl5/site_perl .) at
/usr/local/lib/perl5/5.8.5/AutoLoader.pm line 160.
 at ARS.pm line 64
t/10getlist..........NOK 2#     Failed test (t/10getlist.t at line 20)
# GetListEscalation (-1) [ERROR] RPC call failed (RPC: Can't encode
arguments) (ARERR #91)
t/10getlist..........NOK 4#     Failed test (t/10getlist.t at line 28)
# GetListFilter (-1) [ERROR] RPC call failed (RPC: Can't encode arguments)
(ARERR #91)
t/10getlist..........NOK 6#     Failed test (t/10getlist.t at line 36)
# GetListSchema [ERROR] RPC call failed (RPC: Can't encode arguments)
(ARERR #91)
t/10getlist..........ok 9/9# Looks like you failed 3 tests of 9.
t/10getlist..........dubious
        Test returned status 3 (wstat 768, 0x300)
DIED. FAILED tests 2, 4, 6
        Failed 3/9 tests, 66.67% okay
...
Failed Test        Stat Wstat Total Fail  Failed  List of Failed
-------------------------------------------------------------------------------
t/02export.t          0   139    ??   ??       %  ??
t/10alink.t           0   139    ??   ??       %  ??
t/10entry.t          22  5632    10   18 180.00%  2-10
t/10getlist.t         3   768     9    3  33.33%  2 4 6
t/12lotsoffields.t              104  102  98.08%  3-104
t/13join.t                        7    5  71.43%  3-7
t/20merge.t                       5    2  40.00%  4 6
Failed 7/13 test scripts, 46.15% okay. 119/154 subtests failed, 22.73% okay.
make: *** [test_dynamic] Error 29
#

These are the system specific things i installed prior to arsperl:
binutils-2.11.2-sol8-sparc-local
gcc_small-3.4.2-sol8-sparc-local
libiconv-1.8-sol8-sparc-local
make-3.80-sol8-sparc-local
perl-5.8.5-sol8-sparc-local
SUNWarc
SUNWhea
SUNWlibm

        Best Regards - Misi, RRR AB, http://www.rrr.se

RE: [Arsperl-users] ARSystem Menu question...

[Kelly L. <kel...@ra...>]

Hi Jeff,

I would check the permissions on the field that you are searching on.  =
It
sounds like it may only have the default "Submitter" permission group on =
it.
This would only allow the user to see entries that have that user listed =
in
the 'Submitter' field.  Try adding a permission group appropriate for =
that
user; "public" for testing purposes or if you don't have any other main
permission groups.  You should then see all of the entries in that =
search
menu.

Feel free to give me a call if you have any questions.

Kelly Logan
Cybernetic Solutions, Inc.
(313) 586-8334
kel...@cy...

P.S.:  I would have sent this off-list, but I didn't see your contact
information in your message.

-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of wheeler, jeff
Sent: 04/14/2005 12:05 AM
To: 'ars...@ar...'
Subject: [Arsperl-users] ARSystem Menu question...


Hi folks -

 I inherited control of an ARS 5.1 system almost 2 years ago and it has =
been
running smoothly.  Until now, the only work that I have been doing on =
the
system was creating report scripts using ARSPerl, and those have worked
without a problem.  Now, however, there has been a renewed interest in
adding functionality to the system for other internal departments. =20


  Since my main role is system administration, I have no training in =
form
development and process flow, but I have a pretty good grasp on how the
basics work.  However, I am having a problem with creating a search-type
menu.  I just wanted to create a menu of names based on already existing
names.  What is happening is that the menu will only contain names that =
were
entered by the user looking at the menu.  I turned on SQL debugging, and =
you
can see it make that call.  However, it doesn't happen when I run as a
member of the Administrators group.  Below is one of the calls:

SELECT T440.C1,C8,C536870927,C7,C8,C536870927,C7,C8=20
FROM T440     =20
WHERE ((T440.C2 =3D 'smsusertest1') OR (T440.C4 =3D 'smsusertest1'))=20
ORDER BY 6 ASC,7 ASC,8 ASC


Here is the same menu call, made from an account the Admin group: SELECT
T440.C1,C8,C536870927,C7,C8,C536870927,C7,C8=20
FROM T440=20
ORDER BY 6 ASC,7 ASC,8 ASC

 =20
If anyone is able to offer suggestions as to what I am doing wrong, =
please
do so offlist - since this isn't ARSPerl related...  Thanks in advance!


jeff





-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=3D6595&alloc_id=3D14396&op=3Dclick
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users

Re: [Arsperl-users] SLES9 + ARSPerl 1.82

[David A. <D.J...@so...>]

Christoph,

There was a change to ars_GetListEntry between versions of ARSperl.  It 
sounds as though you have a later version on your SLES9 Linux machine?
Try changing:

my %entries = ars_GetListEntry($ars_connect->ctrl, $scheme, $qual, 0);

to:

my %entries = ars_GetListEntry($ars_connect->ctrl, $scheme, $qual, 0, 0);

David Adams
Corporate Information Services
Information Systems Services
University of Southampton

----- Original Message ----- 
From: "Christoph Schumacher" <chr...@po...>
To: <ars...@ar...>
Sent: Wednesday, April 13, 2005 7:50 AM
Subject: Re: [Arsperl-users] SLES9 + ARSPerl 1.82


> Sure ;-)
> Here it comes...:
>
> sub mycatch {
>        print ("catching call");
> }
>
> (my $ars_connect = new ARS(
>               -server => $hostname,
>                -username =>$username,
>                -password =>$pass,
>                -catch => { ARS::AR_RETURN_ERROR => "main::mycatch",
>                            ARS::AR_RETURN_WARNING => "main::mycatch",
>                            ARS::AR_RETURN_FATAL => "main::mycatch"
>                          },
>                -debug => undef)) || die $ars_errstr;
>
> # Parse command line parameters
> # Load the qualifier structure
> (my $qual = ars_LoadQualifier($ars_connect->ctrl,$scheme, "('Primary 
> Hostname' = \"welcmap2\")")) ||
>        die "error in ars_LoadQualifier";
>
> # Retrieve all of the entry-id's for the schema.
> my %entries = ars_GetListEntry($ars_connect->ctrl, $scheme, $qual, 0);
>
> foreach my $entry_id (sort keys %entries)
> {
>        (my %vals = ars_GetEntry($ars_connect->ctrl, $scheme , $entry_id)) 
> || die $ars_errstr;
>     foreach my $key  (sort {$a <=> $b} keys %vals)
>        {
>                if ($vals{$key})
>                {
>                        print "$key : $vals{$key}\n";
>                }
>        }
> }
>
> # Log out of the server.
> ars_Logoff($ars_connect->ctrl);
>
>
> No, i dont' have a solaris machine to try.....only HP-UX...
>
> Cheers
>
> ------------------------------------------
> Christoph Schumacher
> Porsche Information-Kommunikation-Services
> Competence Center UNIX
> Porschestrasse
> D-71287 Weissach
> ------------------------------------------
>
>
>
>
> Richard Hellier schrieb:
>
>>Christoph, Any chance of seeing the script, please?
>>
>>Cheers,
>>
>>Richard.
>>
>>PS: do you have a Solaris machine to try as well?
>>
>>-----Original Message-----
>>From: ars...@ar...
>>[mailto:ars...@ar...] On Behalf Of Christoph Schumacher
>>Sent: 12 April 2005 15:42
>>To: ars...@ar...
>>Subject: [Arsperl-users] SLES9 + ARSPerl 1.82
>>
>>Hi !
>>
>>I've compiled ARSperl 1.82 successfully with API9 for use with Remedy 
>>5.0.1.
>>I've written a small skript for asking our database per GetListEntry and 
>>GetEntry with dummy identifier (1=1), but nothing is returned.
>>If the script is called on a windows machine (ARSperl 1.4x) it succeeds 
>>and returns correct result. On my SLES9 Linux machine the script returns 0 
>>but does not return any values from the database .... how to debug the api 
>>or is it a fault of mine ??
>>
>>Thanks for the help.
>>
>>
>
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
> 

[Arsperl-users] ARSystem Menu question...

[wheeler, j. <whe...@em...>]

Hi folks -

 I inherited control of an ARS 5.1 system almost 2 years ago and it has been
running smoothly.  Until now, the only work that I have been doing on the
system was creating report scripts using ARSPerl, and those have worked
without a problem.  Now, however, there has been a renewed interest in
adding functionality to the system for other internal departments.  


  Since my main role is system administration, I have no training in form
development and process flow, but I have a pretty good grasp on how the
basics work.  However, I am having a problem with creating a search-type
menu.  I just wanted to create a menu of names based on already existing
names.  What is happening is that the menu will only contain names that were
entered by the user looking at the menu.  I turned on SQL debugging, and you
can see it make that call.  However, it doesn't happen when I run as a
member of the Administrators group.  Below is one of the calls:

SELECT T440.C1,C8,C536870927,C7,C8,C536870927,C7,C8 
FROM T440      
WHERE ((T440.C2 = 'smsusertest1') OR (T440.C4 = 'smsusertest1')) 
ORDER BY 6 ASC,7 ASC,8 ASC


Here is the same menu call, made from an account the Admin group:
SELECT T440.C1,C8,C536870927,C7,C8,C536870927,C7,C8 
FROM T440 
ORDER BY 6 ASC,7 ASC,8 ASC

  
If anyone is able to offer suggestions as to what I am doing wrong, please
do so offlist - since this isn't ARSPerl related...  Thanks in advance!


jeff

[Arsperl-users] RE: Windows XP - ARSPerl - ARSdoc & ARS 5.1.2

[Sprenger, J. : CO I. <JSp...@LH...>]

What versions of Perl/ARSPerl and ARSDoc are being used with ARS 6.3 now?


ActivePerl-5.8.0.806-MSWin32-x86.msi ?

ARSPerl 1.81 or ARSPerl 1.83  ?

ARSDoc 1.28  ?



Thanks,
Janie Sprenger
Remedy Administrator
Legacy Health System
503-415-5826
jsp...@lh... 



IMPORTANT NOTICE:  This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely
for the entity or individual to whom it is addressed.  If you are not the
intended recipient, you should contact the sender and delete the message.
Any unauthorized disclosure, copying, or distribution of this message is
strictly prohibited.  Nothing in this email, including any attachment, is
intended to be a legally binding signature.

Re: [Arsperl-users] SLES9 + ARSPerl 1.82

[Christoph S. <chr...@po...>]

Great !
That does it. I thought it would be C++-alike as a default 0.

Thanks....

------------------------------------------
Christoph Schumacher
Porsche Information-Kommunikation-Services
Competence Center UNIX
Porschestrasse
D-71287 Weissach
------------------------------------------




Richard Hellier schrieb:

>-----Original Message-----
>From: ars...@ar... [mailto:arsperl-users-
>
># Retrieve all of the entry-id's for the schema.
>my %entries = ars_GetListEntry($ars_connect->ctrl, $scheme, $qual, 0);
>
>-------------------
>
>
>Christoph,
>
>The first thing I'd eliminate is the missing 0 in the ars_GetListEntry()
>call.  That is, try writing:
>
>my %entries = ars_GetListEntry($ars_connect->ctrl, $scheme, $qual, 0, 0);
>
>(one zero specifies the max # of entries (0 => infinity) and the other means
>start the fetch at the first entry).
>
>Try this and see what happens.
>
>Cheers,
>
>Richard.
>
>
>
>
>
>-------------------------------------------------------
>SF email is sponsored by - The IT Product Guide
>Read honest & candid reviews on hundreds of IT Products from real users.
>Discover which products truly live up to the hype. Start reading now.
>http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
>_______________________________________________
>Arsperl-users mailing list
>Ars...@ar...
>https://lists.sourceforge.net/lists/listinfo/arsperl-users
>
>
>
>
>
>  
>

RE: [Arsperl-users] SLES9 + ARSPerl 1.82

[Richard H. <rl...@ls...>]

-----Original Message-----
From: ars...@ar... [mailto:arsperl-users-

# Retrieve all of the entry-id's for the schema.
my %entries = ars_GetListEntry($ars_connect->ctrl, $scheme, $qual, 0);

-------------------


Christoph,

The first thing I'd eliminate is the missing 0 in the ars_GetListEntry()
call.  That is, try writing:

my %entries = ars_GetListEntry($ars_connect->ctrl, $scheme, $qual, 0, 0);

(one zero specifies the max # of entries (0 => infinity) and the other means
start the fetch at the first entry).

Try this and see what happens.

Cheers,

Richard.

Re: [Arsperl-users] SLES9 + ARSPerl 1.82

[Christoph S. <chr...@po...>]

Sure ;-)
Here it comes...:

sub mycatch {
        print ("catching call");
}

(my $ars_connect = new ARS(
               -server => $hostname,
                -username =>$username,
                -password =>$pass,
                -catch => { ARS::AR_RETURN_ERROR => "main::mycatch",
                            ARS::AR_RETURN_WARNING => "main::mycatch",
                            ARS::AR_RETURN_FATAL => "main::mycatch"
                          },
                -debug => undef)) || die $ars_errstr;

# Parse command line parameters
# Load the qualifier structure
(my $qual = ars_LoadQualifier($ars_connect->ctrl,$scheme, "('Primary 
Hostname' = \"welcmap2\")")) ||
        die "error in ars_LoadQualifier";

# Retrieve all of the entry-id's for the schema.
my %entries = ars_GetListEntry($ars_connect->ctrl, $scheme, $qual, 0);

foreach my $entry_id (sort keys %entries)
{
        (my %vals = ars_GetEntry($ars_connect->ctrl, $scheme , 
$entry_id)) || die $ars_errstr;
     
        foreach my $key  (sort {$a <=> $b} keys %vals)
        {
                if ($vals{$key})
                {
                        print "$key : $vals{$key}\n";
                }
        }
}

# Log out of the server.
ars_Logoff($ars_connect->ctrl);


No, i dont' have a solaris machine to try.....only HP-UX...

Cheers

------------------------------------------
Christoph Schumacher
Porsche Information-Kommunikation-Services
Competence Center UNIX
Porschestrasse
D-71287 Weissach
------------------------------------------




Richard Hellier schrieb:

>Christoph,	
>	Any chance of seeing the script, please?
>
>Cheers,
>
>Richard.
>
>PS: do you have a Solaris machine to try as well?
>
>-----Original Message-----
>From: ars...@ar...
>[mailto:ars...@ar...] On Behalf Of Christoph Schumacher
>Sent: 12 April 2005 15:42
>To: ars...@ar...
>Subject: [Arsperl-users] SLES9 + ARSPerl 1.82
>
>Hi !
>
>I've compiled ARSperl 1.82 successfully with API9 for use with Remedy 
>5.0.1.
>I've written a small skript for asking our database per GetListEntry and 
>GetEntry with dummy identifier (1=1), but nothing is returned.
>If the script is called on a windows machine (ARSperl 1.4x) it succeeds 
>and returns correct result. On my SLES9 Linux machine the script returns 
>0 but does not return any values from the database .... how to debug the 
>api or is it a fault of mine ??
>
>Thanks for the help.
>
>  
>

RE: [Arsperl-users] SLES9 + ARSPerl 1.82

[Richard H. <rl...@ls...>]

Christoph,	
	Any chance of seeing the script, please?

Cheers,

Richard.

PS: do you have a Solaris machine to try as well?

-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of Christoph Schumacher
Sent: 12 April 2005 15:42
To: ars...@ar...
Subject: [Arsperl-users] SLES9 + ARSPerl 1.82

Hi !

I've compiled ARSperl 1.82 successfully with API9 for use with Remedy 
5.0.1.
I've written a small skript for asking our database per GetListEntry and 
GetEntry with dummy identifier (1=1), but nothing is returned.
If the script is called on a windows machine (ARSperl 1.4x) it succeeds 
and returns correct result. On my SLES9 Linux machine the script returns 
0 but does not return any values from the database .... how to debug the 
api or is it a fault of mine ??

Thanks for the help.

-- 

------------------------------------------
Christoph Schumacher
Porsche Information-Kommunikation-Services
Competence Center UNIX
Porschestrasse
D-71287 Weissach
------------------------------------------





-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users

[Arsperl-users] SLES9 + ARSPerl 1.82

[Christoph S. <chr...@po...>]

Hi !

I've compiled ARSperl 1.82 successfully with API9 for use with Remedy 
5.0.1.
I've written a small skript for asking our database per GetListEntry and 
GetEntry with dummy identifier (1=1), but nothing is returned.
If the script is called on a windows machine (ARSperl 1.4x) it succeeds 
and returns correct result. On my SLES9 Linux machine the script returns 
0 but does not return any values from the database .... how to debug the 
api or is it a fault of mine ??

Thanks for the help.

-- 

------------------------------------------
Christoph Schumacher
Porsche Information-Kommunikation-Services
Competence Center UNIX
Porschestrasse
D-71287 Weissach
------------------------------------------

RE: [Arsperl-users] Remedy Query to SQL

[Bowman, B. A <Bow...@st...>]

Thanks Carey,

That is very similar to what I thought I'd need to do.  I was just =
hoping that I wouldn't :)

-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...]On Behalf Of Carey Matthew Black
Sent: Thursday, April 07, 2005 2:19 PM
To: ars...@ar...
Subject: Re: [Arsperl-users] Remedy Query to SQL


Brent,

   I must say I am a bit confused by what your trying to do.... I
would think that you could more simply use the API to do the search
(with a Remedy formated query) than to use the API to convert it to an
SQL statement then use an SQL connection to do the search. (But maybe
you have some reasons for trying to do what you are trying to do?)


However, I can imagine a way of converting a Remedy query to an SQL
query, but you are not going to like doing it. You have to know a good
deal about Remedy's API and it will be error prone. (IMHO.)

Your best bet (if you really have to do this) is to use a combination
of the following ARSPerl functions:

ars_GetFieldTable
   This will get a hash of Field ID to Field DB name.
ars_GetListVUI
   Get a list of all views for the form in question
ars_GetField
   Get the "displayInstanceList" and further the "dInstanceList" value
for the VUI (View) that the query was built for.... You can then map
field Label (for the view) to field ID/Field DB name. You will have to
build a similar hash to what ars_GetFieldTable returns but based on
the Field Labels for the View instead of the Fields DB Name.


Then....

Parse the query to translate:
*  the English field names to field ID's (which nicely map to the
Column names on the DB tables.)
* The values might have wild cards or other differences in the
notation between double quotes and single quotes for your RDBMS
syntax.
* And likely other things....

But maybe that would help you along your path?

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

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

http://www.fellowshipchurch.com


On Apr 7, 2005 11:53 AM, Bowman, Brent A <Bow...@st...> wrote:
> I want to get the conversion without ever querying the ARS.  I want to =
go directly to Oracle, but let the user input a Remedy style query.
>=20
> -----Original Message-----
> From: ars...@ar...
> [mailto:ars...@ar...]On Behalf Of Covert, Jack
> Sent: Thursday, April 07, 2005 12:01 PM
> To: ars...@ar...
> Subject: RE: [Arsperl-users] Remedy Query to SQL
>=20
> How about running the query with SQL logging on?
>=20
> -----Original Message-----
> From: Bowman, Brent A [mailto:Bow...@st...]
> Sent: Thursday, April 07, 2005 7:09 AM
> To: ars...@ar...
> Subject: [Arsperl-users] Remedy Query to SQL
>=20
> Listers,
>=20
> I am wondering if there is a simple algorithm available to convert a =
remedy
> qualification directly to an SQL query that I can use with oracle.  Is =
there
> something available in arsperl?
>=20
> Thanks,
>=20
> Brent Bowman



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=3D6595&alloc_id=3D14396&op=3Dclick
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users

RE: [Arsperl-users] Remedy Query to SQL

[Bowman, B. A <Bow...@st...>]

Thanks Jeff.  I guess I'll have to do it myself.  I was hoping that it =
was done before :)

Brent

-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...]On Behalf Of Jeff Murphy
Sent: Thursday, April 07, 2005 2:43 PM
To: ars...@ar...
Subject: RE: [Arsperl-users] Remedy Query to SQL


On Thu, 2005-04-07 at 14:16 -0400, Bowman, Brent A wrote:
> Is this the only way?  How does remedy do it.  And how do I turn =
logging on from the same perl script?  Also, how do I know that the log =
entry is from my query and not from another users' request?  Really, the =
algorithm would be better here.


you can examine a query and derive the algorithm. i think they replace
spaces and non-alphanum characters in field and form names with
underscores. some forms are special ("User" is "USER_X").=20

so if you have "My Form #1" and it contains a field "Phone #" and
"Entry-Id". the view should be "MY_FORM__1" and it should contain
"PHONE__" and "ENTRY_ID".

you'll need to grant your oracle users permission to query the view.

jeff




-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=3D6595&alloc_id=3D14396&op=3Dclick
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users

RE: [Arsperl-users] Remedy Query to SQL

[Jeff M. <jcm...@je...>]

On Thu, 2005-04-07 at 14:43 -0400, Jeff Murphy wrote:
> On Thu, 2005-04-07 at 14:16 -0400, Bowman, Brent A wrote:
> > Is this the only way?  How does remedy do it.  And how do I turn logging on from the same perl script?  Also, how do I know that the log entry is from my query and not from another users' request?  Really, the algorithm would be better here.
> 
> 
> you can examine a query and derive the algorithm. 

i should've said "you can examine the view and derive the algorithm"

RE: [Arsperl-users] Remedy Query to SQL

[Jeff M. <jcm...@je...>]

On Thu, 2005-04-07 at 14:16 -0400, Bowman, Brent A wrote:
> Is this the only way?  How does remedy do it.  And how do I turn logging on from the same perl script?  Also, how do I know that the log entry is from my query and not from another users' request?  Really, the algorithm would be better here.


you can examine a query and derive the algorithm. i think they replace
spaces and non-alphanum characters in field and form names with
underscores. some forms are special ("User" is "USER_X"). 

so if you have "My Form #1" and it contains a field "Phone #" and
"Entry-Id". the view should be "MY_FORM__1" and it should contain
"PHONE__" and "ENTRY_ID".

you'll need to grant your oracle users permission to query the view.

jeff

Re: [Arsperl-users] Remedy Query to SQL

[Carey M. B. <bla...@gm...>]

Brent,

   I must say I am a bit confused by what your trying to do.... I
would think that you could more simply use the API to do the search
(with a Remedy formated query) than to use the API to convert it to an
SQL statement then use an SQL connection to do the search. (But maybe
you have some reasons for trying to do what you are trying to do?)


However, I can imagine a way of converting a Remedy query to an SQL
query, but you are not going to like doing it. You have to know a good
deal about Remedy's API and it will be error prone. (IMHO.)

Your best bet (if you really have to do this) is to use a combination
of the following ARSPerl functions:

ars_GetFieldTable
   This will get a hash of Field ID to Field DB name.
ars_GetListVUI
   Get a list of all views for the form in question
ars_GetField
   Get the "displayInstanceList" and further the "dInstanceList" value
for the VUI (View) that the query was built for.... You can then map
field Label (for the view) to field ID/Field DB name. You will have to
build a similar hash to what ars_GetFieldTable returns but based on
the Field Labels for the View instead of the Fields DB Name.


Then....

Parse the query to translate:
*  the English field names to field ID's (which nicely map to the
Column names on the DB tables.)
* The values might have wild cards or other differences in the
notation between double quotes and single quotes for your RDBMS
syntax.
* And likely other things....

But maybe that would help you along your path?

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

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

http://www.fellowshipchurch.com


On Apr 7, 2005 11:53 AM, Bowman, Brent A <Bow...@st...> wrote:
> I want to get the conversion without ever querying the ARS.  I want to go directly to Oracle, but let the user input a Remedy style query.
> 
> -----Original Message-----
> From: ars...@ar...
> [mailto:ars...@ar...]On Behalf Of Covert, Jack
> Sent: Thursday, April 07, 2005 12:01 PM
> To: ars...@ar...
> Subject: RE: [Arsperl-users] Remedy Query to SQL
> 
> How about running the query with SQL logging on?
> 
> -----Original Message-----
> From: Bowman, Brent A [mailto:Bow...@st...]
> Sent: Thursday, April 07, 2005 7:09 AM
> To: ars...@ar...
> Subject: [Arsperl-users] Remedy Query to SQL
> 
> Listers,
> 
> I am wondering if there is a simple algorithm available to convert a remedy
> qualification directly to an SQL query that I can use with oracle.  Is there
> something available in arsperl?
> 
> Thanks,
> 
> Brent Bowman

RE: [Arsperl-users] Remedy Query to SQL

[Bowman, B. A <Bow...@st...>]

Is this the only way?  How does remedy do it.  And how do I turn logging =
on from the same perl script?  Also, how do I know that the log entry is =
from my query and not from another users' request?  Really, the =
algorithm would be better here.

-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...]On Behalf Of Michael Armbrecht
Sent: Thursday, April 07, 2005 2:10 PM
To: ars...@ar...
Subject: Re: [Arsperl-users] Remedy Query to SQL


On Apr 7, 2005 5:53 PM, Bowman, Brent A <Bow...@st...> wrote:
> I want to get the conversion without ever querying the ARS.  I want to =
go directly to Oracle, but let the user input a Remedy style query.

1.) Turn on SQL Logging on your ARS Server.
2.) Run your query in ARS
3.) Turn SQL Logging off.
4.) Check SQL Log file and you will see the SQL that ARS generated
from your ARS Query. Use this for your application.

M.


> -----Original Message-----
> From: ars...@ar...
> [mailto:ars...@ar...]On Behalf Of Covert, Jack
> Sent: Thursday, April 07, 2005 12:01 PM
> To: ars...@ar...
> Subject: RE: [Arsperl-users] Remedy Query to SQL
>=20
> How about running the query with SQL logging on?
>=20
> -----Original Message-----
> From: Bowman, Brent A [mailto:Bow...@st...]
> Sent: Thursday, April 07, 2005 7:09 AM
> To: ars...@ar...
> Subject: [Arsperl-users] Remedy Query to SQL
>=20
> Listers,
>=20
> I am wondering if there is a simple algorithm available to convert a =
remedy
> qualification directly to an SQL query that I can use with oracle.  Is =
there
> something available in arsperl?
>=20
> Thanks,
>=20
> Brent Bowman
>=20
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real =
users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_ide95&alloc_id=14396&op=3Dclick
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>=20
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real =
users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=3D6595&alloc_id=3D14396&op=3Dclick
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>=20
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real =
users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_ide95&alloc_id=14396&opclick
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_ide95&alloc_id=14396&op=3Dclick
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users

Re: [Arsperl-users] Remedy Query to SQL

[Michael A. <mic...@gm...>]

On Apr 7, 2005 5:53 PM, Bowman, Brent A <Bow...@st...> wrote:
> I want to get the conversion without ever querying the ARS.  I want to go=
 directly to Oracle, but let the user input a Remedy style query.

1.) Turn on SQL Logging on your ARS Server.
2.) Run your query in ARS
3.) Turn SQL Logging off.
4.) Check SQL Log file and you will see the SQL that ARS generated
from your ARS Query. Use this for your application.

M.


> -----Original Message-----
> From: ars...@ar...
> [mailto:ars...@ar...]On Behalf Of Covert, Jack
> Sent: Thursday, April 07, 2005 12:01 PM
> To: ars...@ar...
> Subject: RE: [Arsperl-users] Remedy Query to SQL
>=20
> How about running the query with SQL logging on?
>=20
> -----Original Message-----
> From: Bowman, Brent A [mailto:Bow...@st...]
> Sent: Thursday, April 07, 2005 7:09 AM
> To: ars...@ar...
> Subject: [Arsperl-users] Remedy Query to SQL
>=20
> Listers,
>=20
> I am wondering if there is a simple algorithm available to convert a reme=
dy
> qualification directly to an SQL query that I can use with oracle.  Is th=
ere
> something available in arsperl?
>=20
> Thanks,
>=20
> Brent Bowman
>=20
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_ide95&alloc_id=14396&op=3Dclick
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>=20
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=3D6595&alloc_id=3D14396&op=3Dclick
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>=20
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_ide95&alloc_id=14396&opclick
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>

RE: [Arsperl-users] Remedy Query to SQL

[Bowman, B. A <Bow...@st...>]

I want to get the conversion without ever querying the ARS.  I want to =
go directly to Oracle, but let the user input a Remedy style query.

-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...]On Behalf Of Covert, Jack
Sent: Thursday, April 07, 2005 12:01 PM
To: ars...@ar...
Subject: RE: [Arsperl-users] Remedy Query to SQL


How about running the query with SQL logging on?=20

-----Original Message-----
From: Bowman, Brent A [mailto:Bow...@st...]=20
Sent: Thursday, April 07, 2005 7:09 AM
To: ars...@ar...
Subject: [Arsperl-users] Remedy Query to SQL

Listers,

I am wondering if there is a simple algorithm available to convert a =
remedy
qualification directly to an SQL query that I can use with oracle.  Is =
there
something available in arsperl?=20

Thanks,


Brent Bowman



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_ide95&alloc_id=14396&op=3Dclick
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=3D6595&alloc_id=3D14396&op=3Dclick
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users

RE: [Arsperl-users] Remedy Query to SQL

[Covert, J. <Jac...@Mc...>]

How about running the query with SQL logging on? 

-----Original Message-----
From: Bowman, Brent A [mailto:Bow...@st...] 
Sent: Thursday, April 07, 2005 7:09 AM
To: ars...@ar...
Subject: [Arsperl-users] Remedy Query to SQL

Listers,

I am wondering if there is a simple algorithm available to convert a remedy
qualification directly to an SQL query that I can use with oracle.  Is there
something available in arsperl? 

Thanks,


Brent Bowman



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_ide95&alloc_id396&op=click
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users

[Arsperl-users] Remedy Query to SQL

[Bowman, B. A <Bow...@st...>]

Listers,

I am wondering if there is a simple algorithm available to convert a =
remedy qualification directly to an SQL query that I can use with =
oracle.  Is there something available in arsperl?=20

Thanks,


Brent Bowman

RE: [Arsperl-users] Timeout with ars_GetListFilter (ARSperl 1.73,api 4.5.2, ARS Server 6.3)

[Mark V. <mva...@ev...>]

I spoke with the folks at Remedy and they suggested I run their 'driver'
program.  It runs just fine for all of the API calls listed below.

I compared the GetListFilter routines between ARS.xs and their api.c and
found the following differences:
ARS.xs:
<         ARStatusList status;
<         ARPropList   propList;
api.c
>         ARStatusList status =3D {0, NULL};
>         ARPropList   propList =3D {0, NULL};

I updated ARS.xs to match api.c, recompiled, and now GetListFilter
works.  I went through each of the other routines listed below and found
similar differences to those routines.  I updated each of these and now
I get no more errors.

Here is the complete diff output:
>diff /opt/ARSperl/ARSperl-1.83/ARS.xs.orig
/opt/ARSperl/ARSperl-1.83/ARS.xs
998c998
<         ARStatusList status;
---
>         ARStatusList status =3D {0, NULL};
1002c1002
<         ARPropList propList;
---
>         ARPropList propList =3D {0, NULL};
1854,1855c1854,1855
<         ARStatusList status;
<           ARPropList   propList;
---
>         ARStatusList status =3D {0, NULL};
>           ARPropList   propList =3D {0, NULL};
2241,2242c2241,2242
<         ARStatusList status;
<         ARPropList   propList;
---
>         ARStatusList status =3D {0, NULL};
>         ARPropList   propList =3D {0, NULL};
2271,2272c2271,2272
<         ARStatusList status;
<         ARPropList   propList;
---
>         ARStatusList status =3D {0, NULL};
>         ARPropList   propList =3D {0, NULL};
2300,2303c2300,2303
<         ARStatusList status;
<           ARPropList   propList;
<           ARNameList   schemaNameList;
<           ARNameList   actLinkNameList;
---
>         ARStatusList status =3D {0, NULL};
>           ARPropList   propList =3D {0, NULL};
>           ARNameList   schemaNameList =3D {0, NULL};
>           ARNameList   actLinkNameList =3D {0, NULL};

Jeff,
I'm not sure what to do with this update.

Thanks,
Mark

Mark Vaughan

Programmer III

=20

Direct: +1 303 802 2426

Cell: +1 303 601 4434

Fax: +1 303 802 1420

mar...@ev...

Evolving Systems, Inc.=20

9777 Mt. Pyramid Court, Suite 100, Englewood, CO USA 80112

www.evolving.com


-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of Mark Vaughan
Sent: Friday, April 01, 2005 10:17 AM
To: ars...@ar...
Subject: RE: [Arsperl-users] Timeout with ars_GetListFilter (ARSperl
1.73,api 4.5.2, ARS Server 6.3)

Jeff,
Thanks for the answer.  I am now able to login using the new API and
ARSPerl versions:
API version:        |8|
ARSperl version:    |1.83|
server version:     |6.03.00|
server major version:       |6|

All,
I am now receiving the following error when calling any of
ars_GetListActiveLink, ars_GetListCharMenu,
> ars_GetListEscalation, ars_GetListFilter, and ars_GetListSchema:
[ERROR] RPC call failed (RPC: Can't encode arguments) (ARERR #91)

Additional info:
Reading list of active link entries
ars_errstr: |[ERROR] RPC call failed (RPC: Can't encode arguments)
(ARERR #91)|
ars_errhash (HASH(0x219d7c)) (4 keys)
ars_errhash{messageNum} (ARRAY(0x6d32a4)) (1 element)
ars_errhash{messageNum}[0]: |91|
ars_errhash{messageText} (ARRAY(0x6d32ec)) (1 element)
ars_errhash{messageText}[0]:        |RPC call failed (RPC: Can't encode
arguments)|
ars_errhash{messageType} (ARRAY(0x6d32e0)) (1 element)
ars_errhash{messageType}[0]:        |2|
ars_errhash{numItems}:      |1|

Thanks,
Mark

Mark Vaughan

Programmer III

=20

Direct: +1 303 802 2426

Cell: +1 303 601 4434

Fax: +1 303 802 1420

mar...@ev...

Evolving Systems, Inc.=20

9777 Mt. Pyramid Court, Suite 100, Englewood, CO USA 80112

www.evolving.com

-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of Jeff Murphy
Sent: Wednesday, March 30, 2005 12:23 PM
To: ars...@ar...
Subject: Re: [Arsperl-users] Timeout with ars_GetListFilter (ARSperl
1.73,api 4.5.2, ARS Server 6.3)

On Wed, 2005-03-30 at 11:03 -0700, Mark Vaughan wrote:
> All,
>=20
> I current use ARSperl 1.73 to connect to a 4.5.2 server and everything
> works just peachy.  We have created a new 6.3 server and when I try to
> use ARSperl 1.73 and call ars_GetListFilter, I always get back the
> following:
>=20
> =20
>=20
> [ERROR] Timeout during data retrieval due to busy server -- retry the
> operation (atlantic) (ARERR #93)
>=20
> =20
>=20
> The other calls I make (Ars_GetListActiveLink, ars_GetListCharMenu,
> ars_GetListEscalation, and ars_GetListSchema) all return valid data.
>=20

i don't know what would cause the above.

> =20
>=20
> Do I need to use ARSperl 1.83?=20

perhaps not, but you could compile it and try it to see if it resolves
the problem.

> Do I need to recompile with the 6.0 api?=20

not necessarily, but you should if you have them available. if the above
problem persists and you re-used the 4.x API, then try the 6.x API.=20

>  If I need to recompile, will I be able to still talk to my 4.5.2
> server=20

yes.


> or is there a way to install both versions simultaneously?


yes. "use lib 'path';" should allow you to over-ride the location of
ARSperl. e.g. if you unpack 1.83 into '/tmp/ARSperl-1.83' and compile it
against 6.x, you can write a test script:

#!/usr/bin/perl
use lib '/tmp/ARSperl-1.83/blib/lib';
use lib '/tmp/ARSperl-1.83/blib/arch';
use ARS;
login...
loadqualifier....



without needing to do the "make install" step





>=20
> =20
>=20
> The 6.3 server is running on WinServer 2003 and ARSperl is on Solaris
> 8.
>=20
> =20
>=20
> Thanks in advance,
>=20
> Mark
>=20
> =20
>=20
> Mark Vaughan
>=20
> Programmer III
>=20
> =20
>=20
> Direct: +1 303 802 2426
>=20
> Cell: +1 303 601 4434
>=20
> Fax: +1 303 802 1420
>=20
> mar...@ev...
>=20
> Evolving Systems, Inc.=20
>=20
> 9777 Mt. Pyramid Court, Suite 100, Englewood, CO USA 80112
>=20
> www.evolving.com
>=20
> =20
>=20
>=20
> This e-mail and any attachments may be confidential and/or legally
> privileged. If you have received this e-mail and you are not a named
> addressee, please inform Evolving Systems TIS at ti...@ev... and
> then delete the e-mail from your system. If you are not a named
> addressee you must not use, disclose, distribute, copy, print or rely
> on this e-mail. To ensure regulatory compliance and for the protection
> of our clients and business, Evolving Systems may monitor and read
> e-mails sent to and from its servers. Although Evolving Systems
> routinely screens for viruses, addressees should scan this e-mail and
> any attachments for viruses. Evolving Systems makes no representation
> or warranty as to the absence of viruses in this e-mail or any
> attachments.=20
>=20
> Registered Office: 9777 Mt. Pyramid Ct Suite 100, Englewood, CO 80112
--=20
Jeff Murphy <jcm...@je...>



-------------------------------------------------------
This SF.net email is sponsored by Demarc:
A global provider of Threat Management Solutions.
Download our HomeAdmin security software for free today!
http://www.demarc.com/Info/Sentarus/hamr30
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users
This e-mail and any attachments may be confidential and/or legally
privileged. If you have received this e-mail and you are not a named
addressee, please inform Evolving Systems TIS at ti...@ev... and
then delete the e-mail from your system. If you are not a named
addressee you must not use, disclose, distribute, copy, print or rely on
this e-mail. To ensure regulatory compliance and for the protection of
our clients and business, Evolving Systems may monitor and read e-mails
sent to and from its servers. Although Evolving Systems routinely
screens for viruses, addressees should scan this e-mail and any
attachments for viruses. Evolving Systems makes no representation or
warranty as to the absence of viruses in this e-mail or any attachments.


Registered Office: 9777 Mt. Pyramid Ct Suite 100, Englewood, CO 80112



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_ide95&alloc_id=14396&op=3Dick
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users
This e-mail and any attachments may be confidential and/or legally privil=
eged. If you have received this e-mail and you are not a named addressee,=
 please inform Evolving Systems TIS at ti...@ev... and then delete t=
he e-mail from your system. If you are not a named addressee you must not=
 use, disclose, distribute, copy, print or rely on this e-mail. To ensure=
 regulatory compliance and for the protection of our clients and business=
, Evolving Systems may monitor and read e-mails sent to and from its serv=
ers. Although Evolving Systems routinely screens for viruses, addressees =
should scan this e-mail and any attachments for viruses. Evolving Systems=
 makes no representation or warranty as to the absence of viruses in this=
 e-mail or any attachments.=20

Registered Office: 9777 Mt. Pyramid Ct Suite 100, Englewood, CO 80112

RE: [Arsperl-users] Timeout with ars_GetListFilter (ARSperl 1.73,api 4.5.2, ARS Server 6.3)

[Mark V. <mva...@ev...>]

Jeff,
Thanks for the answer.  I am now able to login using the new API and
ARSPerl versions:
API version:        |8|
ARSperl version:    |1.83|
server version:     |6.03.00|
server major version:       |6|

All,
I am now receiving the following error when calling any of
ars_GetListActiveLink, ars_GetListCharMenu,
> ars_GetListEscalation, ars_GetListFilter, and ars_GetListSchema:
[ERROR] RPC call failed (RPC: Can't encode arguments) (ARERR #91)

Additional info:
Reading list of active link entries
ars_errstr: |[ERROR] RPC call failed (RPC: Can't encode arguments)
(ARERR #91)|
ars_errhash (HASH(0x219d7c)) (4 keys)
ars_errhash{messageNum} (ARRAY(0x6d32a4)) (1 element)
ars_errhash{messageNum}[0]: |91|
ars_errhash{messageText} (ARRAY(0x6d32ec)) (1 element)
ars_errhash{messageText}[0]:        |RPC call failed (RPC: Can't encode
arguments)|
ars_errhash{messageType} (ARRAY(0x6d32e0)) (1 element)
ars_errhash{messageType}[0]:        |2|
ars_errhash{numItems}:      |1|

Thanks,
Mark

Mark Vaughan

Programmer III

=20

Direct: +1 303 802 2426

Cell: +1 303 601 4434

Fax: +1 303 802 1420

mar...@ev...

Evolving Systems, Inc.=20

9777 Mt. Pyramid Court, Suite 100, Englewood, CO USA 80112

www.evolving.com

-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of Jeff Murphy
Sent: Wednesday, March 30, 2005 12:23 PM
To: ars...@ar...
Subject: Re: [Arsperl-users] Timeout with ars_GetListFilter (ARSperl
1.73,api 4.5.2, ARS Server 6.3)

On Wed, 2005-03-30 at 11:03 -0700, Mark Vaughan wrote:
> All,
>=20
> I current use ARSperl 1.73 to connect to a 4.5.2 server and everything
> works just peachy.  We have created a new 6.3 server and when I try to
> use ARSperl 1.73 and call ars_GetListFilter, I always get back the
> following:
>=20
> =20
>=20
> [ERROR] Timeout during data retrieval due to busy server -- retry the
> operation (atlantic) (ARERR #93)
>=20
> =20
>=20
> The other calls I make (Ars_GetListActiveLink, ars_GetListCharMenu,
> ars_GetListEscalation, and ars_GetListSchema) all return valid data.
>=20

i don't know what would cause the above.

> =20
>=20
> Do I need to use ARSperl 1.83?=20

perhaps not, but you could compile it and try it to see if it resolves
the problem.

> Do I need to recompile with the 6.0 api?=20

not necessarily, but you should if you have them available. if the above
problem persists and you re-used the 4.x API, then try the 6.x API.=20

>  If I need to recompile, will I be able to still talk to my 4.5.2
> server=20

yes.


> or is there a way to install both versions simultaneously?


yes. "use lib 'path';" should allow you to over-ride the location of
ARSperl. e.g. if you unpack 1.83 into '/tmp/ARSperl-1.83' and compile it
against 6.x, you can write a test script:

#!/usr/bin/perl
use lib '/tmp/ARSperl-1.83/blib/lib';
use lib '/tmp/ARSperl-1.83/blib/arch';
use ARS;
login...
loadqualifier....



without needing to do the "make install" step





>=20
> =20
>=20
> The 6.3 server is running on WinServer 2003 and ARSperl is on Solaris
> 8.
>=20
> =20
>=20
> Thanks in advance,
>=20
> Mark
>=20
> =20
>=20
> Mark Vaughan
>=20
> Programmer III
>=20
> =20
>=20
> Direct: +1 303 802 2426
>=20
> Cell: +1 303 601 4434
>=20
> Fax: +1 303 802 1420
>=20
> mar...@ev...
>=20
> Evolving Systems, Inc.=20
>=20
> 9777 Mt. Pyramid Court, Suite 100, Englewood, CO USA 80112
>=20
> www.evolving.com
>=20
> =20
>=20
>=20
> This e-mail and any attachments may be confidential and/or legally
> privileged. If you have received this e-mail and you are not a named
> addressee, please inform Evolving Systems TIS at ti...@ev... and
> then delete the e-mail from your system. If you are not a named
> addressee you must not use, disclose, distribute, copy, print or rely
> on this e-mail. To ensure regulatory compliance and for the protection
> of our clients and business, Evolving Systems may monitor and read
> e-mails sent to and from its servers. Although Evolving Systems
> routinely screens for viruses, addressees should scan this e-mail and
> any attachments for viruses. Evolving Systems makes no representation
> or warranty as to the absence of viruses in this e-mail or any
> attachments.=20
>=20
> Registered Office: 9777 Mt. Pyramid Ct Suite 100, Englewood, CO 80112
--=20
Jeff Murphy <jcm...@je...>



-------------------------------------------------------
This SF.net email is sponsored by Demarc:
A global provider of Threat Management Solutions.
Download our HomeAdmin security software for free today!
http://www.demarc.com/Info/Sentarus/hamr30
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users
This e-mail and any attachments may be confidential and/or legally privil=
eged. If you have received this e-mail and you are not a named addressee,=
 please inform Evolving Systems TIS at ti...@ev... and then delete t=
he e-mail from your system. If you are not a named addressee you must not=
 use, disclose, distribute, copy, print or rely on this e-mail. To ensure=
 regulatory compliance and for the protection of our clients and business=
, Evolving Systems may monitor and read e-mails sent to and from its serv=
ers. Although Evolving Systems routinely screens for viruses, addressees =
should scan this e-mail and any attachments for viruses. Evolving Systems=
 makes no representation or warranty as to the absence of viruses in this=
 e-mail or any attachments.=20

Registered Office: 9777 Mt. Pyramid Ct Suite 100, Englewood, CO 80112

Re: [Arsperl-users] Timeout with ars_GetListFilter (ARSperl 1.73, api 4.5.2, ARS Server 6.3)

[Jeff M. <jcm...@je...>]

On Wed, 2005-03-30 at 11:03 -0700, Mark Vaughan wrote:
> All,
> 
> I current use ARSperl 1.73 to connect to a 4.5.2 server and everything
> works just peachy.  We have created a new 6.3 server and when I try to
> use ARSperl 1.73 and call ars_GetListFilter, I always get back the
> following:
> 
>  
> 
> [ERROR] Timeout during data retrieval due to busy server -- retry the
> operation (atlantic) (ARERR #93)
> 
>  
> 
> The other calls I make (Ars_GetListActiveLink, ars_GetListCharMenu,
> ars_GetListEscalation, and ars_GetListSchema) all return valid data.
> 

i don't know what would cause the above.

>  
> 
> Do I need to use ARSperl 1.83? 

perhaps not, but you could compile it and try it to see if it resolves
the problem.

> Do I need to recompile with the 6.0 api? 

not necessarily, but you should if you have them available. if the above
problem persists and you re-used the 4.x API, then try the 6.x API. 

>  If I need to recompile, will I be able to still talk to my 4.5.2
> server 

yes.


> or is there a way to install both versions simultaneously?


yes. "use lib 'path';" should allow you to over-ride the location of
ARSperl. e.g. if you unpack 1.83 into '/tmp/ARSperl-1.83' and compile it
against 6.x, you can write a test script:

#!/usr/bin/perl
use lib '/tmp/ARSperl-1.83/blib/lib';
use lib '/tmp/ARSperl-1.83/blib/arch';
use ARS;
login...
loadqualifier....



without needing to do the "make install" step





> 
>  
> 
> The 6.3 server is running on WinServer 2003 and ARSperl is on Solaris
> 8.
> 
>  
> 
> Thanks in advance,
> 
> Mark
> 
>  
> 
> Mark Vaughan
> 
> Programmer III
> 
>  
> 
> Direct: +1 303 802 2426
> 
> Cell: +1 303 601 4434
> 
> Fax: +1 303 802 1420
> 
> mar...@ev...
> 
> Evolving Systems, Inc. 
> 
> 9777 Mt. Pyramid Court, Suite 100, Englewood, CO USA 80112
> 
> www.evolving.com
> 
>  
> 
> 
> This e-mail and any attachments may be confidential and/or legally
> privileged. If you have received this e-mail and you are not a named
> addressee, please inform Evolving Systems TIS at ti...@ev... and
> then delete the e-mail from your system. If you are not a named
> addressee you must not use, disclose, distribute, copy, print or rely
> on this e-mail. To ensure regulatory compliance and for the protection
> of our clients and business, Evolving Systems may monitor and read
> e-mails sent to and from its servers. Although Evolving Systems
> routinely screens for viruses, addressees should scan this e-mail and
> any attachments for viruses. Evolving Systems makes no representation
> or warranty as to the absence of viruses in this e-mail or any
> attachments. 
> 
> Registered Office: 9777 Mt. Pyramid Ct Suite 100, Englewood, CO 80112
-- 
Jeff Murphy <jcm...@je...>

[Arsperl-users] Timeout with ars_GetListFilter (ARSperl 1.73, api 4.5.2, ARS Server 6.3)

[Mark V. <mva...@ev...>]

All,

I current use ARSperl 1.73 to connect to a 4.5.2 server and everything
works just peachy.  We have created a new 6.3 server and when I try to
use ARSperl 1.73 and call ars_GetListFilter, I always get back the
following:

=20

[ERROR] Timeout during data retrieval due to busy server -- retry the
operation (atlantic) (ARERR #93)

=20

The other calls I make (Ars_GetListActiveLink, ars_GetListCharMenu,
ars_GetListEscalation, and ars_GetListSchema) all return valid data.

=20

Do I need to use ARSperl 1.83? Do I need to recompile with the 6.0 api?
If I need to recompile, will I be able to still talk to my 4.5.2 server
or is there a way to install both versions simultaneously?

=20

The 6.3 server is running on WinServer 2003 and ARSperl is on Solaris 8.

=20

Thanks in advance,

Mark

=20

Mark Vaughan

Programmer III

=20

Direct: +1 303 802 2426

Cell: +1 303 601 4434

Fax: +1 303 802 1420

mar...@ev... <mailto:mar...@ev...>=20

Evolving Systems, Inc.=20

9777 Mt. Pyramid Court, Suite 100, Englewood, CO USA 80112

www.evolving.com

=20

This e-mail and any attachments may be confidential and/or legally privil=
eged. If you have received this e-mail and you are not a named addressee,=
 please inform Evolving Systems TIS at ti...@ev... and then delete t=
he e-mail from your system. If you are not a named addressee you must not=
 use, disclose, distribute, copy, print or rely on this e-mail. To ensure=
 regulatory compliance and for the protection of our clients and business=
, Evolving Systems may monitor and read e-mails sent to and from its serv=
ers. Although Evolving Systems routinely screens for viruses, addressees =
should scan this e-mail and any attachments for viruses. Evolving Systems=
 makes no representation or warranty as to the absence of viruses in this=
 e-mail or any attachments.=20

Registered Office: 9777 Mt. Pyramid Ct Suite 100, Englewood, CO 80112

Re: [Arsperl-users] How to Connect to ARS Remedy Database

[Andrew H. <an...@hi...>]

Joseph:

I meant in that documentation that, under certain circumstances, one 
should consider querying the underlying remedy database rather than 
querying the remedy daemon. In situations where frequent or large 
queries are required, this is almost certainly preferable. The reason 
is that by directly querying the database, one does not utilize the 
remedy daemons. On a busy system with many users, in a situation where 
you need to do frequent or large queries, this is quite important.

In any case you can query remedy's database directly, though exactly 
how is dependent on the type of database your are running. Under Sybase 
and Oracle (the only two remedy databases with which I have experience 
so far), there is an ARAdmin user and tablespace, under which views are 
set up for each schema on the server. One can query these views 
approximately like one would query the remedy schema itself (i.e. one 
database record == one remedy ticket, SQL on the other hand is quite 
different than QBE).

In the Remedy::ARSTools documentation I shamelessly recommended my own 
DBI extension module DBIx::YAWM. Feel free to use it if you like. Most 
of the goodness that was DBIx::YAWM (returning a record list as an 
array of hash references) has long since been rolled into DBI proper 
(and done much better, BTW).

Please keep in mind that my module, Remedy::ARSTools is merely a 
wrapper for ARSperl, that provides a few convenience functions, and 
field definition caching (a bit of a speed boost on frequent queries). 
It's not been tested with any version > 1.74 of ARSperl, which (I 
believe) is incompatible with certain later versions of ARS (i.e. 6.*). 
So ... use at your own risk, and consider learning ARSperl before you 
mess around too much with my module ... it'll probably just be 
confusing, as it's not terribly well documented or tested on any 
machines except for my own.

cheers,

-Andrew ;-)


On Mar 17, 2005, at 12:50 PM, Lamb Joseph wrote:

> Hello,
>
> How do I connect to a Remedy database and query the
> information in a form?
>
> In the Remedy::Arstools I found the following
> statement:
>  You should get a read-only database account with
> select access on the aradmin views, and use something
> like DBIx::YAWM to query the database directly.
>
> Does even one have an example using DBIx::YAWM or some
> other common method?
>
>
>
> The following did not work:
> use strict;
> use DBI;
>
>
> my  $dbh = DBI->connect('dbi:ODBC:Remedy',
> 'user','pass' ) or die "Cannot connect\n";
> my $statement = "SELECT
>     Assigned_To_Group_
> FROM
>     HelpDesk
> WHERE
>    Assigned_To_Group_ LIKE 'NFS%'";
>
> my $sth = $dbh->prepare($statement) or die "Cannot
> prepare\n";
>
>
>
>
> Joseph Lamb
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real 
> users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>
>
###################################################
## Andrew N. Hicox
## Hicox Information Systems Development
## [voice]: 703-367-9085
## [email]: an...@hi...
## [web]: http://hicox.com
##
## Rome built daily.
###################################################