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"
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:arslist@ARSLIST.ORG] On Behalf Of Frank Caruso Sent: Friday, April 06, 2012 08:59 To: arslist@ARSLIST.ORG 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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Column Sort on Vendor Form
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: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Frank Caruso Sent: Friday, April 06, 2012 08:59 To: arslist@ARSLIST.ORG 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"
Re: Column Sort on Vendor Form
Joe: I never ran into that, but my first thought would be to enhance the source code of the ARDBC plugin to produce the desired behavior and recompile. I suppose you could just write your own plugin, also. --Phil -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Friday, April 06, 2012 09:27 To: arslist@ARSLIST.ORG Subject: Re: Column Sort on Vendor Form 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: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Frank Caruso Sent: Friday, April 06, 2012 08:59 To: arslist@ARSLIST.ORG 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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Column Sort on Vendor Form
Does not seem to be an issue with the ARDBCPlugin. We have custom fields added to the vendor form with data populated for some records and NULL on others. The column sorts fine in a table field referencing the vendor form. We are on SQL server (ARS 7.1 and ITSM 7) and I know NULL is handled differently between SQL Server and Oracle. Could this be related to the backend db as well? Saby --- On Fri, 4/6/12, Murnane, Phil wrote: From: Murnane, Phil Subject: Re: Column Sort on Vendor Form To: arslist@ARSLIST.ORG Date: Friday, April 6, 2012, 2:31 PM Joe: I never ran into that, but my first thought would be to enhance the source code of the ARDBC plugin to produce the desired behavior and recompile. I suppose you could just write your own plugin, also. --Phil -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Friday, April 06, 2012 09:27 To: arslist@ARSLIST.ORG Subject: Re: Column Sort on Vendor Form 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: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Frank Caruso Sent: Friday, April 06, 2012 08:59 To: arslist@ARSLIST.ORG 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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Column Sort on Vendor Form
It was too long ago when I experienced it, to remember details. I recall it was during the days when the ARDBC plugin was fairly new, when I had an opportunity to use it at a customer somewhere in the middle-east.. Many of them were on MS-SQL but we had a small number of Oracle dependent sites too so I can’t say with certainty... I think the Plugin later matured to even handle nulls in the Request ID column, so chances are this problem may have been fixed but might have resurfaced again.. Joe From: Sabyson Fernandes Sent: Friday, April 06, 2012 3:50 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Column Sort on Vendor Form ** Does not seem to be an issue with the ARDBCPlugin. We have custom fields added to the vendor form with data populated for some records and NULL on others. The column sorts fine in a table field referencing the vendor form. We are on SQL server (ARS 7.1 and ITSM 7) and I know NULL is handled differently between SQL Server and Oracle. Could this be related to the backend db as well? Saby --- On Fri, 4/6/12, Murnane, Phil wrote: From: Murnane, Phil Subject: Re: Column Sort on Vendor Form To: arslist@ARSLIST.ORG Date: Friday, April 6, 2012, 2:31 PM Joe: I never ran into that, but my first thought would be to enhance the source code of the ARDBC plugin to produce the desired behavior and recompile. I suppose you could just write your own plugin, also. --Phil -Original Message- From: Action Request System discussion list(ARSList) [mailto:wlmailhtml:/mc/compose?to=arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Friday, April 06, 2012 09:27 To: wlmailhtml:/mc/compose?to=arslist@ARSLIST.ORG Subject: Re: Column Sort on Vendor Form 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: wlmailhtml:/mc/compose?to=arslist@ARSLIST.ORG 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:wlmailhtml:/mc/compose?to=arslist@ARSLIST.ORG] On Behalf Of Frank Caruso Sent: Friday, April 06, 2012 08:59 To: wlmailhtml:/mc/compose?to=arslist@ARSLIST.ORG 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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"