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. *
_Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_
