Norm, The problem is that with 7.6.4, the age old representation of @ as server is somehow changing to * in the definitions. In the case of AL's with Direct SQL actions, it is causing an issue. The 7.6.4 Dev Studio (all versions that I have tested) convert the reference to 'server' to *, and then fail to work with the clients....the fix we have found is to export to an XML, change the * to an @, and re-import the workflow. This 'fixes' the workflow until someone else modifies the same workflow again with the Dev Studio...the procedure must be done again....but an export of the workflow and import into another server still works.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of NormD Sent: Wednesday, October 26, 2011 8:28 AM To: arslist@ARSLIST.ORG Subject: active link not working after import Remedy 7.6.0.4, Oracle 11g Using the midtier interface, a user performing any operation that uses and active link generates an error - "cannot establish a network connection to the AR system server" This error occurs when an active link that executes a SQL programmed command is altered. It is inconvenient to have to re-construct many active links. This error also occurs when one of these active links is exported from one server to another (eg. from our dev to test server). There are too many types of these active links to manually adjust during a release. As time goes on we are using this functionality more, so more of our code will break without us knowing about it until someone tries to use the portions of the program that use it. In our setup ARS server, midtier and Oracle db are all on the same host. What is causing this issue and how do I address it? -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/active-link-not-worki ng-after-import-tp6932876p6932876.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ____________________________________________________________________________ ___ 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"