That explains what was going on one of my attempts to customize that form.. I had done everything according to the books but had included one enumerated field value too in the custom forms query and it would look for it in every other form!
BMC wasn't of much help (I wasn't even told it was a software defect or it is as designed for reasons you stated below). I was told that I was attempting to customize something I shouldn't be, without taking training.. I wonder if it would work if you introduced that same dummy field in every other form enlisted in the consoles integration too? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Thad K Esser Sent: Monday, February 22, 2010 2:06 PM To: [email protected] Subject: Re: Integrating custom form into Overview Console (ITSM 7.x) ** Daniel, In ITSM 7.0.3, we had this issue and submitted a defect for it (SW00330605), which I just looked up and its now closed "As designed". When using an enumerated field as part of the external qualification for the table, the system queries ALL forms for that field, not just the form for which its defined. If you look at API/SQL logging, you'll see a bunch of SQL errors similar to: <SQL > *** ERROR *** ORA-00904: "T1021"."C1000000869": invalid identifier <SQL > *** ERROR *** ORA-00904: "T1115"."C1000000869": invalid identifier <SQL > *** ERROR *** ORA-00904: "T1117"."C1000000869": invalid identifier <SQL > *** ERROR *** ORA-00904: "T1118"."C1000000869": invalid identifier <SQL > *** ERROR *** ORA-00904: "T1584"."C1000000869": invalid identifier <SQL > *** ERROR *** ORA-00904: "T1590"."C1000000869": invalid identifier <SQL > *** ERROR *** ORA-00904: "T756"."C1000000869": invalid identifier There is one error for each form defined to display on the overview console (minus the one that actually has the field), culminating in the ARERR 552 error from the API. Everything works fine if you just want to display the enumerated field in the table, but as soon as you use it in the qualification, you get the behavior above. Your choices are to not use the field in the qualification, or add it to all the other base forms. I hope that helps. Thad Esser Remedy Developer From: ARS Dummie <[email protected]> To: [email protected] Date: 02/22/2010 07:35 AM Subject: Re: Integrating custom form into Overview Console (ITSM 7.x) Sent by: "Action Request System discussion list(ARSList)" <[email protected]> ---------------------------------------------------------------------------- -- ** Just to bring this up again! Someone has an idea regarding this? Cheers! Daniel On Wed, Nov 4, 2009 at 5:08 PM, ARS Dummie <[email protected]> wrote: Hi Listers! I am trying to integrate some customers form in the Overview Console (ITSM 7.5), but there seems to be something wrong. What I did is this: - added 1 entry to SHR:ARDBC_OverviewConsoleTemplate (used the form name of the customers form and a GUID called "COMOBJECT". I entered only these two fields and left the rest on default) - added 13 entries to SHR:ARDBCFields using the new Form GUID "COMOBJECT" and used Field IDs from customers form to map it with Field IDs from the vendor form (SHR:ARDBC_OverviewConsole). No fields had to be added to the vendor form. I only took existing standard fields - added three entries to SHR:ARDBCEnumLookup to map the status values of the customer form (field ID 7) to the status values of the vendor form (Consolidated Status) - restarted arplugin process When I try to open the Overview Console I get an error: ARERR [552] Error:ARGetListEntryWithFields - Failure during SQL Operation to the database and the console remains empty. Strangely enough I can see the entries for my "COMOBJECT" within the SHR:ARDBC_OverviewConsole form when I access it directly. So the plugin is working and is collecting the data correctly. I tried to troubleshoot/workaround this by making the external qualification (z1D_ExternalQualString) visible on SHR:OverviewConsole. It contains a long statement asking for different types of requests (MAINHELPDESK, TMSTASK, ...) with their status and assigned users. But I can not find some "COMOBJECT" in there out of the box. So do I have to edit some of the workflow as well which is building this enormous external qualification? When I am editing the external qualification manually by hand (because the field is now visible) I am getting my request from the customers form displayed in the overview console. But why is the original qualification not working anymore. Any help is really appreciated! Thanks! Daniel _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
