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-working-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
Re: active link not working after import
Are you exporting to a .def file or to a .xml file? Open the exported file and see if your server name is in it (or does it specify @ for the server name). After a release are you going in to the Mid-Tier Admin page and telling it to Flush the Cache? Also are you using 7.6.04 SP1, SP2, or unpatched 7.6.04? And on what OS is Remedy running on? And what version Dev Studio? (Yes these can all make a difference) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of NormD Sent: Wednesday, October 26, 2011 9: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? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: active link not working after import
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 clientsthe 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 againbut 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
Re: active link not working after import
LJ Do you know if a bug has been opened against that? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Wednesday, October 26, 2011 9:53 AM To: arslist@ARSLIST.ORG Subject: Re: active link not working after import 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 clientsthe 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 againbut 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? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: active link not working after import
I don't know but I've raised a support request with our support. Regards; Norm From: Grooms, Frederick W [via ARS (Action Request System)] [mailto:ml-node+s1093659n693302...@n2.nabble.com] Sent: Wednesday, October 26, 2011 11:15 AM To: Dignard, Norman Subject: Re: active link not working after import LJ Do you know if a bug has been opened against that? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[hidden email]/user/SendEmail.jtp?type=nodenode=6933024i=0] On Behalf Of LJ LongWing Sent: Wednesday, October 26, 2011 9:53 AM To: [hidden email]/user/SendEmail.jtp?type=nodenode=6933024i=1 Subject: Re: active link not working after import 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 clientsthe 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 againbut an export of the workflow and import into another server still works. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[hidden email]/user/SendEmail.jtp?type=nodenode=6933024i=2] On Behalf Of NormD Sent: Wednesday, October 26, 2011 8:28 AM To: [hidden email]/user/SendEmail.jtp?type=nodenode=6933024i=3 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? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are If you reply to this email, your message will be added to the discussion below: http://ars-action-request-system.1093659.n2.nabble.com/active-link-not-working-after-import-tp6932876p6933024.html To unsubscribe from active link not working after import, click herehttp://ars-action-request-system.1093659.n2.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=6932876code=ZGlnbmFybkBOQVZDQU5BREEuQ0F8NjkzMjg3NnwxOTQ2MjEyNzIy. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/active-link-not-working-after-import-tp6932876p6933035.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
Re: active link not working after import
Thanks for the info. Regards; Norm From: LJ Longwing [via ARS (Action Request System)] [mailto:ml-node+s1093659n6932947...@n2.nabble.com] Sent: Wednesday, October 26, 2011 10:53 AM To: Dignard, Norman Subject: Re: active link not working after import 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 clientsthe 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 againbut an export of the workflow and import into another server still works. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[hidden email]/user/SendEmail.jtp?type=nodenode=6932947i=0] On Behalf Of NormD Sent: Wednesday, October 26, 2011 8:28 AM To: [hidden email]/user/SendEmail.jtp?type=nodenode=6932947i=1 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 If you reply to this email, your message will be added to the discussion below: http://ars-action-request-system.1093659.n2.nabble.com/active-link-not-working-after-import-tp6932876p6932947.html To unsubscribe from active link not working after import, click herehttp://ars-action-request-system.1093659.n2.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=6932876code=ZGlnbmFybkBOQVZDQU5BREEuQ0F8NjkzMjg3NnwxOTQ2MjEyNzIy. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/active-link-not-working-after-import-tp6932876p6933040.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
Re: active link not working after import
I had an issue a couple months back where I exported a working AL to a .def file from DEV, but when I imported it to PROD a couple of actions' field references were switched. Was odd but an easy fix. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of NormD Sent: Wednesday, October 26, 2011 10:22 AM To: arslist@ARSLIST.ORG Subject: Re: active link not working after import ** Thanks for the info. Regards; Norm From: LJ Longwing [via ARS (Action Request System)] [mailto:[hidden email]/user/SendEmail.jtp?type=nodenode=6933040i=0] Sent: Wednesday, October 26, 2011 10:53 AM To: Dignard, Norman Subject: Re: active link not working after import 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 clientsthe 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 againbut an export of the workflow and import into another server still works. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[hidden email]/user/SendEmail.jtp?type=nodenode=6932947i=0] On Behalf Of NormD Sent: Wednesday, October 26, 2011 8:28 AM To: [hidden email]/user/SendEmail.jtp?type=nodenode=6932947i=1 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 If you reply to this email, your message will be added to the discussion below: http://ars-action-request-system.1093659.n2.nabble.com/active-link-not-working-after-import-tp6932876p6932947.html To unsubscribe from active link not working after import, click here. View this message in context: RE: active link not working after importhttp://ars-action-request-system.1093659.n2.nabble.com/active-link-not-working-after-import-tp6932876p6933040.html Sent from the ARS (Action Request System) mailing list archivehttp://ars-action-request-system.1093659.n2.nabble.com/ at Nabble.com. _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
Re: active link not working after import
I have not opened one with my front line...but I can confirm that it is in fact a bug :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, October 26, 2011 9:15 AM To: arslist@ARSLIST.ORG Subject: Re: active link not working after import LJ Do you know if a bug has been opened against that? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Wednesday, October 26, 2011 9:53 AM To: arslist@ARSLIST.ORG Subject: Re: active link not working after import 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 clientsthe 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 againbut 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? ___ 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: active link not working after import
We are exporting .def files. Yes we flush the cache every time. It started at some point with 7.1, and still an issue with sp1 and now also sp2 (dev Studio) Regards; Norm From: Grooms, Frederick W [via ARS (Action Request System)] [mailto:ml-node+s1093659n6932933...@n2.nabble.com] Sent: Wednesday, October 26, 2011 10:48 AM To: Dignard, Norman Subject: Re: active link not working after import Are you exporting to a .def file or to a .xml file? Open the exported file and see if your server name is in it (or does it specify @ for the server name). After a release are you going in to the Mid-Tier Admin page and telling it to Flush the Cache? Also are you using 7.6.04 SP1, SP2, or unpatched 7.6.04? And on what OS is Remedy running on? And what version Dev Studio? (Yes these can all make a difference) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[hidden email]/user/SendEmail.jtp?type=nodenode=6932933i=0] On Behalf Of NormD Sent: Wednesday, October 26, 2011 9:28 AM To: [hidden email]/user/SendEmail.jtp?type=nodenode=6932933i=1 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? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are If you reply to this email, your message will be added to the discussion below: http://ars-action-request-system.1093659.n2.nabble.com/active-link-not-working-after-import-tp6932876p6932933.html To unsubscribe from active link not working after import, click herehttp://ars-action-request-system.1093659.n2.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=6932876code=ZGlnbmFybkBOQVZDQU5BREEuQ0F8NjkzMjg3NnwxOTQ2MjEyNzIy. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/active-link-not-working-after-import-tp6932876p6933308.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