I recall this to be happening a long time ago too. I think it just never got
fixed.
Never tried that workaround though.. How would it work with ARDBC plugin
related vendor form where the data is not actually stored in the form?
Joe
-----Original Message-----
From: Murnane, Phil
Sent: Friday, April 06, 2012 9:04 AM Newsgroups:
public.remedy.arsystem.general
To: [email protected]
Subject: Re: Column Sort on Vendor Form
Frank:
I vaguely recall something like this happening to me years ago. The
workaround was to get the DBA to change the database view to contain a space
character when the data would have been null. If it's a numeric column, we
asked the DBA to put zero instead of null.
Maybe this would work for you?
--Phil
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Frank Caruso
Sent: Friday, April 06, 2012 08:59
To: [email protected]
Subject: Column Sort on Vendor Form
ARS 7.6.04 sp2
Oracle / Redhat
Created a vendor form using the ARDBC LDAP connection with about 30 fields.
The form opens correctly (User Tool and Midtier) and I can run queries
against it. I can also click on a results list column heading and sort the
results. However, when I try and sort on a column where one of the result
records has no value (NULL, empty string) value for the field being sorted
the plugin crashes and I get this error:
Cannot establish a network connection to the AR System Plug-In server :
abcd-123 ARSYS.ARDBC.LDAP : RPC: Miscellaneous tli error - System error
(Connection refused) (ARERR 8760)
Anyone else seen this issue?
Thank you
Frank Caruso
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
