arsperl-users

[Arsperl-users] AR_RETURN_WARNING

[Amen A. <aas...@ho...>]

Hi,

I am trying to run a C program in Unix to retrieve data from remedy. It 
compiles ok but when I run it, I get the error message below. Is there a way 
to change the Maximum return in a query to say up to a 1000?.

ERROR: DTR-Workorder Get List Entry: 'WO Status' = "Closed" AND 'Action' != 
$NULL$ AND ('Asset Updated?' = "No" OR 'Asset Updated?' = $NULL$)
Number of items in Status List: 1
Message Type: WARNING Message Number: 8911
Message: Some of the fields have been truncated from the results list 
because the total length of the fields and separators is greater than the 
maximum allowed
Appended Message:

Please help!!!

Thank you.

Amen.

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

Re: [Arsperl-users] AR_RETURN_WARNING

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

Amen,

 Not really sure why you think an ARSPerl list is the right place to
post an ARS C API question.... ( I would think www.arslist.org would
have been a better choice.)


However, with that said, I will still take a stab at the problem. It
sounds like ...

Your using the ARGetListEntry function and the AREntryListFieldList
structure is being truncated because the form is configured with to
many fields in the Results list.

First, if this is the case then, this should be a safe error to
ignore. (unless you are only getting your data from the
AREntryListFieldList structure. If you are doing that then I would
suggest you use the ARGetListEntryWithFields function anyway.) The
reason you can safely ignore it is that when you later call the
ARGetEntry function you get all the details anyway.


On the other hand... You might also be seeing that the ARGetListEntry
function is only returning a subset of the actual number of records
found on the form.(100 of 1000000) If so then check your maxRetrieve
value in the function and the Server's configuration for
AR_SERVER_INFO_MAX_ENTRIES. That setting might be what your being
limited by too. If so then reuse the ARGetListEntry with a setting for
->firstRetrieve and set it to the max Entry ID that was returned by
the previous call to ARGetListEntry and repeat until you get zero
records from the query.


HTH.

--=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 6/13/05, Amen Asemota <aas...@ho...> wrote:
> Hi,
>=20
> I am trying to run a C program in Unix to retrieve data from remedy. It
> compiles ok but when I run it, I get the error message below. Is there a =
way
> to change the Maximum return in a query to say up to a 1000?.
>=20
> ERROR: DTR-Workorder Get List Entry: 'WO Status' =3D "Closed" AND 'Action=
' !=3D
> $NULL$ AND ('Asset Updated?' =3D "No" OR 'Asset Updated?' =3D $NULL$)
> Number of items in Status List: 1
> Message Type: WARNING Message Number: 8911
> Message: Some of the fields have been truncated from the results list
> because the total length of the fields and separators is greater than the
> maximum allowed
> Appended Message:
>=20
> Please help!!!
>=20
> Thank you.
>=20
> Amen.

Re: [Arsperl-users] AR_RETURN_WARNING

[Amen A. <aas...@ho...>]

I just want to say a very big thank you to you. I decided to use 
ARGetListEntryWithFields and I dont get that error any more. It's working 
very well now.

Thanks for letting me know about the www.arslist.org . It's been very 
helpful to me. I am kind of new in Remedy and didn't know that site exist.

Once againthank you and I appreciate all your help.

Amen.

>From: Carey Matthew Black <bla...@gm...>
>Reply-To: ars...@ar...
>To: ars...@ar...
>Subject: Re: [Arsperl-users] AR_RETURN_WARNING
>Date: Tue, 14 Jun 2005 08:50:49 -0500
>
>Amen,
>
>  Not really sure why you think an ARSPerl list is the right place to
>post an ARS C API question.... ( I would think www.arslist.org would
>have been a better choice.)
>
>
>However, with that said, I will still take a stab at the problem. It
>sounds like ...
>
>Your using the ARGetListEntry function and the AREntryListFieldList
>structure is being truncated because the form is configured with to
>many fields in the Results list.
>
>First, if this is the case then, this should be a safe error to
>ignore. (unless you are only getting your data from the
>AREntryListFieldList structure. If you are doing that then I would
>suggest you use the ARGetListEntryWithFields function anyway.) The
>reason you can safely ignore it is that when you later call the
>ARGetEntry function you get all the details anyway.
>
>
>On the other hand... You might also be seeing that the ARGetListEntry
>function is only returning a subset of the actual number of records
>found on the form.(100 of 1000000) If so then check your maxRetrieve
>value in the function and the Server's configuration for
>AR_SERVER_INFO_MAX_ENTRIES. That setting might be what your being
>limited by too. If so then reuse the ARGetListEntry with a setting for
>->firstRetrieve and set it to the max Entry ID that was returned by
>the previous call to ARGetListEntry and repeat until you get zero
>records from the query.
>
>
>HTH.
>
>--
>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 6/13/05, Amen Asemota <aas...@ho...> wrote:
> > Hi,
> >
> > I am trying to run a C program in Unix to retrieve data from remedy. It
> > compiles ok but when I run it, I get the error message below. Is there a 
>way
> > to change the Maximum return in a query to say up to a 1000?.
> >
> > ERROR: DTR-Workorder Get List Entry: 'WO Status' = "Closed" AND 'Action' 
>!=
> > $NULL$ AND ('Asset Updated?' = "No" OR 'Asset Updated?' = $NULL$)
> > Number of items in Status List: 1
> > Message Type: WARNING Message Number: 8911
> > Message: Some of the fields have been truncated from the results list
> > because the total length of the fields and separators is greater than 
>the
> > maximum allowed
> > Appended Message:
> >
> > Please help!!!
> >
> > Thank you.
> >
> > Amen.
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you 
>shotput
>a projector? How fast can you ride your desk chair down the office luge 
>track?
>If you want to score the big prize, get to know the little guy.
>Play to win an NEC 61" plasma display: http://www.necitguy.com/?r
>_______________________________________________
>Arsperl-users mailing list
>Ars...@ar...
>https://lists.sourceforge.net/lists/listinfo/arsperl-users

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

Re: [Arsperl-users] AR_RETURN_WARNING

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

Amen,

Your very welcome.

  ARSPerl is a smaller (sub set) of the Remedy ARS universe. While it
is a Perl rapper around the C API, most people here only really use
the Perl wrapper and not the C API directly. However there are those
that maintain ARSPerl itself that lurk here and they certainly use the
C API. :) So it is not bad to post messages about the C API here, but
you have a smaller set of people to pull information from.

On the other hand.... www.arslist.org is a more general mailing list
for "all things Remedy" and has a larger user subscription. So your a
bit more likely to find people who use any given part of ARS there.

Both groups are good groups of people and rarely do they give you a
hard time about asking "newbie questions". So feel free to ask
anything ARS related. Use which ever list you choose, but ARSPerl
things are more likely to be answered correctly and directly by those
that develop that tool here. Most other things are "best" routed to
www.ARSlist.org.

Happy developing. :)

--=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 6/15/05, Amen Asemota <aas...@ho...> wrote:
> I just want to say a very big thank you to you. I decided to use
> ARGetListEntryWithFields and I dont get that error any more. It's working
> very well now.
>=20
> Thanks for letting me know about the www.arslist.org . It's been very
> helpful to me. I am kind of new in Remedy and didn't know that site exist=
.
>=20
> Once againthank you and I appreciate all your help.
>=20
> Amen.
>=20
> >From: Carey Matthew Black <bla...@gm...>
> >Reply-To: ars...@ar...
> >To: ars...@ar...
> >Subject: Re: [Arsperl-users] AR_RETURN_WARNING
> >Date: Tue, 14 Jun 2005 08:50:49 -0500
> >
> >Amen,
> >
> >  Not really sure why you think an ARSPerl list is the right place to
> >post an ARS C API question.... ( I would think www.arslist.org would
> >have been a better choice.)
> >
> >
> >However, with that said, I will still take a stab at the problem. It
> >sounds like ...
> >
> >Your using the ARGetListEntry function and the AREntryListFieldList
> >structure is being truncated because the form is configured with to
> >many fields in the Results list.
> >
> >First, if this is the case then, this should be a safe error to
> >ignore. (unless you are only getting your data from the
> >AREntryListFieldList structure. If you are doing that then I would
> >suggest you use the ARGetListEntryWithFields function anyway.) The
> >reason you can safely ignore it is that when you later call the
> >ARGetEntry function you get all the details anyway.
> >
> >
> >On the other hand... You might also be seeing that the ARGetListEntry
> >function is only returning a subset of the actual number of records
> >found on the form.(100 of 1000000) If so then check your maxRetrieve
> >value in the function and the Server's configuration for
> >AR_SERVER_INFO_MAX_ENTRIES. That setting might be what your being
> >limited by too. If so then reuse the ARGetListEntry with a setting for
> >->firstRetrieve and set it to the max Entry ID that was returned by
> >the previous call to ARGetListEntry and repeat until you get zero
> >records from the query.
> >
> >
> >HTH.
> >
> >--
> >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 6/13/05, Amen Asemota <aas...@ho...> wrote:
> > > Hi,
> > >
> > > I am trying to run a C program in Unix to retrieve data from remedy. =
It
> > > compiles ok but when I run it, I get the error message below. Is ther=
e a
> >way
> > > to change the Maximum return in a query to say up to a 1000?.
> > >
> > > ERROR: DTR-Workorder Get List Entry: 'WO Status' =3D "Closed" AND 'Ac=
tion'
> >!=3D
> > > $NULL$ AND ('Asset Updated?' =3D "No" OR 'Asset Updated?' =3D $NULL$)
> > > Number of items in Status List: 1
> > > Message Type: WARNING Message Number: 8911
> > > Message: Some of the fields have been truncated from the results list
> > > because the total length of the fields and separators is greater than
> >the
> > > maximum allowed
> > > Appended Message:
> > >
> > > Please help!!!
> > >
> > > Thank you.
> > >
> > > Amen.