Hi Roy, I actually fixed most of the problem last night..
It appears that you HAVE TO have all the fields in the SHR:ARDBCFields form irrespective of whether or not the ID's match, failing which they do not appear in any table lists, Results List (Field 1020) including. This is in contrary to the documentation where it claims you need to add the fields there only if the ID's do not match.. However even after doing so, I still get that warning "ARWARN [51] Field ID specified does not exist in this form : 7" while using the thick client (Windows User Tool). I do not get this warning while using the thin client (Mid-Tier). I did clear the Mid-Tier cache but I haven't tried clearing the client cache which I will do in a bit and check if the warning still pops up... In the event that the problem doesn't go away with clearing the client cache, any idea why I may be getting this warning? And how significant is it? I know I can suppress it, but that's not a resolution.. Joe ________________________________ From: "Roys, Eric D" <[email protected]> To: [email protected] Sent: Tue, October 13, 2009 10:08:40 AM Subject: Re: REPOST: Customizing the SHR:ARDBC_OverviewConsole to view custom form and its data... ** Joe, You may also need to add data records to SHR:ARDBCEnumLookup for any fields you added that were drop-list in structure. To debug you can turn on server-side sql logging to capture the output of the query issued to see where it's failing. Typical problems occur due to swapping of Field ID and Vendor Field ID in SHR:ARDBCFields record and not restarting the plugin after making a change. Check out the sql log and it should point you in the right direction. If you want to save yourself some time when you make a change to the overview console you can (unix) kill the arplugin pid or (windows) end process on the arplugin instead of waiting the 10 minutes for the full arserver restart. (best left to non-production environments). Armonitor will kick off the armonitor again automagically. Enjoy, Eric ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Duncan McFarlane Sent: Monday, October 12, 2009 9:21 PM To: [email protected] Subject: Re: REPOST: Customizing the SHR:ARDBC_OverviewConsole to view custom form and its data... ** I had to restart the AR Server service to have the data show last time I added fields to the console ________________________________ From:Action Request System discussion list(ARSList) [mailto: [email protected] ] On Behalf Of Joe DeSouza Sent: October 12, 2009 2:55 PM To: [email protected] Subject: REPOST: Customizing the SHR:ARDBC_OverviewConsole to view custom form and its data... Considering there seemed to have been some sort of a latency in the list lately, I thought I'd repost what I had posted last week just before the weekend. So I apologize if you receive this twice. I want to add a custom form and results from that to the console results. I think I have done everything that I thought that I should do in order to do this. So far I have: 1) Added the fields that need to appear in the console to the SHR:ARDBC_OverviewConsoleTemplate form 2) Created a data record for the custom form with a GUID "USERASSETRECORDS" for that form. 3) Added these same fields to the SHR:ARDBC_OverviewConsole form 4) Added data records mapping the fields whose ID's do not match on the custom application form and the template form to the SHR:ARDBCFields form to match the above GUID. 5) Restarted the AR Server. When I search the vendor SHR:ARDBC_OverviewConsole form, I do see the additional records that should be seen but I cannot see the data. I created a table field and added the fields that were added to that table field and I fail to view the data.. However the table field does return as many rows as it should but with null data. I have checked the permissions and its pretty much public everywhere including the Request ID column of the custom application form. And I fail to see the data even as the administrator of the system. Also at the time when I try to display the result to the table field, I get a warning "ARWARN [51] Field ID specified does not exist in this form : 7". Which form is it looking for the Status field? Obviously the custom application form does have this field, as it is a core field. The only form that doesn't have it is the display only form where the table field is on. Is there some configuration step that I am missing? Joe _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

