Re: Unable to create View Form
Does the ARAdmin user that owns the ARSystem database have access to this db link that has been created? If not you will need to grant that user at bare minimum the rights to select assuming you will use this view only to view data and not modify it from the ARS. If you need to modify data then the user should also be given the rights to insert and update.. If all this is taken care of, make sure there is at least one unique field that is at a minimum length of 5 or a max length of 15. Make sure this field is indexed in that database.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Carin Grobler Sent: Thursday, September 16, 2010 2:13 AM To: arslist@ARSLIST.ORG Subject: Unable to create View Form Hi I have come across a weirdness when creating a View FORM Created the db Link Verified db link access external oracle database Query table using the dblink Load the table and build view form but on submission I get the following error The following form was not imported (ARERR 55) No errors in SQL or API logs All other forms and workflow saves as well as other View forms (not to same db though) AR Server 7.1 patch 6 Oracle 10G Any ideas Carin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Unable to create View Form
Carin, I have had this happen with 7.0.1 and 7.1. Never found out why. I did find that if I manually created the View form on the server, even with minimum fields, the import would modify the View Form as expected. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Carin Grobler Sent: Thursday, September 16, 2010 2:13 AM To: arslist@ARSLIST.ORG Subject: Unable to create View Form Hi I have come across a weirdness when creating a View FORM Created the db Link Verified db link access external oracle database Query table using the dblink Load the table and build view form but on submission I get the following error The following form was not imported (ARERR 55) No errors in SQL or API logs All other forms and workflow saves as well as other View forms (not to same db though) AR Server 7.1 patch 6 Oracle 10G Any ideas Carin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Unable to create View Form - Resolved
Restarted the ARServer managed to save the form - still not sure why this occurred Almost like the Control table and last Schemaid got muddled (all looks ok now) Add this to the mysteries of the universe C On Thu, Sep 16, 2010 at 8:45 AM, Shellman, David dave.shell...@tycoelectronics.com wrote: Carin, I have had this happen with 7.0.1 and 7.1. Never found out why. I did find that if I manually created the View form on the server, even with minimum fields, the import would modify the View Form as expected. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] On Behalf Of Carin Grobler Sent: Thursday, September 16, 2010 2:13 AM To: arslist@ARSLIST.ORG Subject: Unable to create View Form Hi I have come across a weirdness when creating a View FORM Created the db Link Verified db link access external oracle database Query table using the dblink Load the table and build view form but on submission I get the following error The following form was not imported (ARERR 55) No errors in SQL or API logs All other forms and workflow saves as well as other View forms (not to same db though) AR Server 7.1 patch 6 Oracle 10G Any ideas Carin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Unable to create View Form
Hi I have come across a weirdness when creating a View FORM Created the db Link Verified db link access external oracle database Query table using the dblink Load the table and build view form but on submission I get the following error The following form was not imported (ARERR 55) No errors in SQL or API logs All other forms and workflow saves as well as other View forms (not to same db though) AR Server 7.1 patch 6 Oracle 10G Any ideas Carin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are