Dwayne, You are welcome.. Thad does have a good script below to find more such references that may have got messed up.. What probably might have happened is you have not exported the defs as server independent. I that case you would do good following Thads recommendations and find out if you have more such references to the test server.
You might want to be careful about modifying this directly from the database though. If you are not familiar with how some strings are saved in the database, I would recommend to use Thads script to find all the objects and modify them from the Admin tool rather than from DB level. Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Thad K Esser Sent: Tuesday, November 06, 2007 1:19 PM To: [email protected] Subject: Re: Push Field not happening SOLVED (hard coded server references) ** Here's an SQL (Oracle) snippet I wrote to find any hardcoded server references. It was written for 6.3, but seems to work on 7.1. Maybe it will help you find any others. --------- select 'Table' Item, a.name Form, f.fieldname ObjectName, ft.tfserver ReferredToServer from ARSCHEMA a, field f, field_table ft where a.SCHEMAID = f.schemaid and f.SCHEMAID = ft.SCHEMAID and f.FIELDID = ft.FIELDID and NOT ( tfserver = '@' OR tfserver LIKE '$%$') union select 'AL Push Fields',s.name, a.NAME, substr(ap.assignshort,INSTR(ap.assignshort, '\')+1,substr(ap.assignshort,1,INSTR(ap.assignshort, '\')-1)) from arschema s,actlink a,actlink_mapping am,actlink_push ap where s.schemaid = am.schemaid and am.actlinkid = a.actlinkid and a.ACTLINKID = ap.actlinkid and (not(ap.assignshort like '[EMAIL PROTECTED]') or not(ap.assignlong like '[EMAIL PROTECTED]')) and (not(ap.assignshort like '4\$-_$\%') or not(ap.assignlong like '4\$-_$\%')) union select 'Active Link Open Window', '', al.name, alo.servername from actlink al, ACTLINK_OPEN alo where al.ACTLINKID = alo.ACTLINKID and NOT ( SERVERNAME = '@' OR SERVERNAME LIKE '$%$') union select 'Active Link CallGuide', '', al.name, alc.servername from actlink al, ACTLINK_CALL alc where al.ACTLINKID = alc.ACTLINKID and NOT ( SERVERNAME = '@' OR SERVERNAME LIKE '$%$') union select 'Menu-Search','', cm.name, cmq.server from char_menu cm, CHAR_MENU_query cmq where cm.CHARMENUID = cmq.CHARMENUID and NOT ( SERVER = '@' OR SERVER LIKE '$%$') union select 'Menu-DataDictionary','', cm.name, cmq.server from char_menu cm, CHAR_MENU_DD cmq where cm.CHARMENUID = cmq.CHARMENUID and NOT ( SERVER = '@' OR SERVER LIKE '$%$') union select 'Menu-SQL','', cm.name, cmq.server from char_menu cm, CHAR_MENU_sql cmq where cm.CHARMENUID = cmq.CHARMENUID and NOT ( SERVER = '@' OR SERVER LIKE '$%$') union select 'Filter CallGuide', '', f.name, fc.servername from filter f, filter_call fc where f.filterid = fc. filterid and NOT ( SERVERNAME = '@' OR SERVERNAME LIKE '$%$') order by 1,2,3 --------- Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach "Dwayne Martin" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 11/06/2007 10:06 AM Please respond to [email protected] To [email protected] cc Subject Re: Push Field not happening SOLVED Joe, Thank you! Thank you! Thank you! My table was indeed pointing to the wrong server. I can't remember exactly what I did, but I am 73% certain that I exported the view with the table on it from the test system and imported it into the live system. I'll have to remember that if I ever export and import a view with a table field, to check the server in the target form. Thanks again, Dwayne ---- Original message ---- >Date: Tue, 6 Nov 2007 12:53:39 -0500 >From: "Joe D'Souza" <[EMAIL PROTECTED]> >Subject: Re: Push Field not happening >To: [email protected] > > ** > Can you select 2 or 3 records, perform the operation > on the server where its not working, and then send > the active link logs? My wild wild guess is that > maybe your table field is referencing a wrong > server? Either that or the Push Field action is > referencing the wrong server.. If its neither of > these two reasons maybe the AL logs might tell us > something.. > > Cheers > > Joe D'Souza > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] Behalf Of Dwayne > Martin > Sent: Tuesday, November 06, 2007 12:08 PM > To: [email protected] > Subject: Push Field not happening > > Hello Everyone, > > We have employee records stored in a "PAY:Employee" > form. The Status is either "Active" or "Inactive". > The employees each have a unique "Employee e-ID" > field. The problem is that some of our employees > are, alas, no longer with us, so we want to mark > their Statuses as "Inactive? > > So we have a control panel with a table that > displays all the "Active" records. The "Employee > e-ID" value is listed in an "Employee e-ID col" > column. The user hi-lites the rows he wants to make > inactive, and clicks a "De-Activate" button. This > calls an active link that calls a guide that loops > the table. For each hi-lited record an "inner" > active link pushes the value "Inactive" to the > record where 'Employee e-ID' = $EmployeeEid col$. > The main active link then refreshes the table, and > the hi-lited records disappear. If you display them > they have indeed been changed to "Inactive". > > At least that is the way it worked in our test > system. We have now brot everything over to the > live system, and all the active links fire, and the > log shows the link pushing the "Inactive" value to > the desired records. BUT the records don't get > updated. They do not disappear from the table and > when you display them their Status is still > "Active." > > I ran a filter log just in case some other workflow > was setting the Status back again, but it wasn't. > Besides, the "Last Modified Date" is not getting > set. I inserted a message into the "inner" active > link to print out the "Employee e-ID col" and it is > correct. But the Push Fields is simply not > happening. I am running as Administrator, so it > can't be a permissions issue. > > Any ideas? > > (ARS 7.1, RH Linux server, Oracle 10.2 db) > > Dwayne Martin > James Madison University No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.23/1113 - Release Date: 11/6/2007 10:04 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
