Thread: Re: [Arsperl-users] ars_LoadQualifier blows in ARSPerl 1.85
Brought to you by:
jeffmurphy
Menu
▾
▴
arsperl-users
|
From: STAN H. B. 7. L. <sch...@bl...> - 2007-04-10 17:09:02
|
Mark, thank you for your help. The schema is the same but the 'Case ID+' is a field label in that view not the field name. This script was always working on ARS 5.1, but when we moved to 6.3 it sometimes breaks. -Stan ----- Original Message ----- From: Mark Vaughan <ars...@ar...> At: 4/10 12:57:35 Stan, It looks as though the field 'Case ID+' is not found in the schema. I'm just guessing that the schema you are using is tied to a variable and not hardcoded. Please verify that the schema being used when it fails contains the field as requested and, conversely, that the same schema is used when it properly generates the qualifier. HTH, Mark Vaughan TTS Development Comcast Cable Corporation 720.268.8591 -----Original Message----- From: ars...@ar... [mailto:ars...@ar...] On Behalf Of STAN HOLODNAK, BLOOMBERG/ 731 LEXIN Sent: Tuesday, April 10, 2007 10:13 AM To: ARS...@AR... Subject: [Arsperl-users] ars_LoadQualifier blows in ARSPerl 1.85 for Remedy6.3 It runs OK sometimes but sometimes it exits with this message ars_LoadQualifier: [ERROR] Unknown field referenced in query line (position 39 (... AND 'Case ID+'^ = "00000000037...)) (ARERR #1587) Print out query just before ars_LoadQualifier says 'Case Status' = "Closed" AND 'Case ID+' ="000000000373200". So the query itself is correct. Why the error message shows '^' and why does it exit? Thank you. ------------------------------------------------------------------------ - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDE V _______________________________________________ Arsperl-users mailing list Ars...@ar... https://lists.sourceforge.net/lists/listinfo/arsperl-users ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Arsperl-users mailing list Ars...@ar... https://lists.sourceforge.net/lists/listinfo/arsperl-users |
|
From: STAN H. B. 7. L. <sch...@bl...> - 2007-04-10 18:54:17
|
Thilo, hardcoding field name is working. Thank you. One more thing, ars_MergeEntry fails if the diary field is empty. Any idea why? -Stan ----- Original Message ----- From: Thilo Stapff <ars...@ar...> At: 4/10 13:35:32 I've seen this problem too but was never able to solve it. You might, however, use field IDs in the qualifier instead of labels, e.g. ... AND '536870913' = "00000000037001" .... That way it has, so far, always worked. Regards, Thilo STAN HOLODNAK, BLOOMBERG/ 731 LEXIN wrote: > It runs OK sometimes but sometimes it exits with this message > ars_LoadQualifier: [ERROR] Unknown field referenced in query line (position 39 > (... AND 'Case ID+'^ = "00000000037...)) (ARERR #1587) > Print out query just before ars_LoadQualifier says 'Case Status' = "Closed" > AND 'Case ID+' ="000000000373200". So the query itself is correct. > Why the error message shows '^' and why does it exit? Thank you. > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Arsperl-users mailing list > Ars...@ar... > https://lists.sourceforge.net/lists/listinfo/arsperl-users > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Arsperl-users mailing list Ars...@ar... https://lists.sourceforge.net/lists/listinfo/arsperl-users |
|
From: Thilo S. <thi...@ap...> - 2007-04-11 08:28:22
|
Not sure what you mean. Could you be a little more specific, perhaps send a code sample? Do you get an error message in $ars_errstr or does it simply crash? Thilo STAN HOLODNAK, BLOOMBERG/ 731 LEXIN wrote: > Thilo, hardcoding field name is working. Thank you. One more thing, > ars_MergeEntry fails if the diary field is empty. Any idea why? -Stan > ----- Original Message ----- > From: Thilo Stapff <ars...@ar...> > At: 4/10 13:35:32 > > I've seen this problem too but was never able to solve it. > > You might, however, use field IDs in the qualifier instead of labels, e.g. > > ... AND '536870913' = "00000000037001" .... > > That way it has, so far, always worked. > > Regards, > Thilo > > > STAN HOLODNAK, BLOOMBERG/ 731 LEXIN wrote: >> It runs OK sometimes but sometimes it exits with this message > >> ars_LoadQualifier: [ERROR] Unknown field referenced in query line (position 39 > >> (... AND 'Case ID+'^ = "00000000037...)) (ARERR #1587) > >> Print out query just before ars_LoadQualifier says 'Case Status' = "Closed" >> AND 'Case ID+' ="000000000373200". So the query itself is correct. > >> Why the error message shows '^' and why does it exit? Thank you. >> >> >> ------------------------------------------------------------------------- >> Take Surveys. Earn Cash. Influence the Future of IT >> Join SourceForge.net's Techsay panel and you'll get the chance to share your >> opinions on IT & business topics through brief surveys-and earn cash >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >> _______________________________________________ >> Arsperl-users mailing list >> Ars...@ar... >> https://lists.sourceforge.net/lists/listinfo/arsperl-users >> > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Arsperl-users mailing list > Ars...@ar... > https://lists.sourceforge.net/lists/listinfo/arsperl-users > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Arsperl-users mailing list > Ars...@ar... > https://lists.sourceforge.net/lists/listinfo/arsperl-users > |
|
From: STAN H. B. 7. L. <sch...@bl...> - 2007-04-11 18:18:57
|
Thilo, Mark and Carey thanks for your help. Thilo It was an issue with code, not with ars_MergeEntry. In some cases I did not construct the worklog value properly. -Stan ----- Original Message ----- From: Thilo Stapff <ars...@ar...> At: 4/11 4:28:40 Not sure what you mean. Could you be a little more specific, perhaps send a code sample? Do you get an error message in $ars_errstr or does it simply crash? Thilo STAN HOLODNAK, BLOOMBERG/ 731 LEXIN wrote: > Thilo, hardcoding field name is working. Thank you. One more thing, > ars_MergeEntry fails if the diary field is empty. Any idea why? -Stan > ----- Original Message ----- > From: Thilo Stapff <ars...@ar...> > At: 4/10 13:35:32 > > I've seen this problem too but was never able to solve it. > > You might, however, use field IDs in the qualifier instead of labels, e.g. > > ... AND '536870913' = "00000000037001" .... > > That way it has, so far, always worked. > > Regards, > Thilo > > > STAN HOLODNAK, BLOOMBERG/ 731 LEXIN wrote: >> It runs OK sometimes but sometimes it exits with this message > >> ars_LoadQualifier: [ERROR] Unknown field referenced in query line (position 39 > >> (... AND 'Case ID+'^ = "00000000037...)) (ARERR #1587) > >> Print out query just before ars_LoadQualifier says 'Case Status' = "Closed" >> AND 'Case ID+' ="000000000373200". So the query itself is correct. > >> Why the error message shows '^' and why does it exit? Thank you. >> >> >> ------------------------------------------------------------------------- >> Take Surveys. Earn Cash. Influence the Future of IT >> Join SourceForge.net's Techsay panel and you'll get the chance to share your >> opinions on IT & business topics through brief surveys-and earn cash >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >> _______________________________________________ >> Arsperl-users mailing list >> Ars...@ar... >> https://lists.sourceforge.net/lists/listinfo/arsperl-users >> >> > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Arsperl-users mailing list > Ars...@ar... > https://lists.sourceforge.net/lists/listinfo/arsperl-users > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Arsperl-users mailing list > Ars...@ar... > https://lists.sourceforge.net/lists/listinfo/arsperl-users > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Arsperl-users mailing list Ars...@ar... https://lists.sourceforge.net/lists/listinfo/arsperl-users |
|
From: Vaughan, M. <Mar...@ca...> - 2007-04-10 17:57:51
|
Stan, As I didn't know what the underlying field name was I used the available information (in this case the field label) and presumed that you would understand what I was talking about (as you apparently did). To specifically answer your first question, the '^' implies that the preceding field (in this case the field with the label 'Case ID+') is unknown to the code which generates the qualifier structure. If you have the ARS driver tool available, try it in there and see if it returns a valid structure consistently. HTH, Mark Vaughan TTS Development Comcast Cable Corporation 720.268.8591 -----Original Message----- From: ars...@ar... [mailto:ars...@ar...] On Behalf Of STAN HOLODNAK, BLOOMBERG/ 731 LEXIN Sent: Tuesday, April 10, 2007 11:09 AM To: ars...@ar... Subject: Re: [Arsperl-users] ars_LoadQualifier blows in ARSPerl 1.85 Mark, thank you for your help. The schema is the same but the 'Case ID+' is a=20 field label in that view not the field name. This script was always working on=20 ARS 5.1, but when we moved to 6.3 it sometimes breaks. -Stan=20 ----- Original Message ----- From: Mark Vaughan <ars...@ar...> At: 4/10 12:57:35 Stan, It looks as though the field 'Case ID+' is not found in the schema. I'm just guessing that the schema you are using is tied to a variable and not hardcoded. Please verify that the schema being used when it fails contains the field as requested and, conversely, that the same schema is used when it properly generates the qualifier. HTH, Mark Vaughan TTS Development Comcast Cable Corporation 720.268.8591 -----Original Message----- From: ars...@ar... [mailto:ars...@ar...] On Behalf Of STAN HOLODNAK, BLOOMBERG/ 731 LEXIN Sent: Tuesday, April 10, 2007 10:13 AM To: ARS...@AR... Subject: [Arsperl-users] ars_LoadQualifier blows in ARSPerl 1.85 for Remedy6.3 It runs OK sometimes but sometimes it exits with this message ars_LoadQualifier: [ERROR] Unknown field referenced in query line (position 39 (... AND 'Case ID+'^ =3D "00000000037...)) (ARERR #1587) Print out query just before ars_LoadQualifier says 'Case Status' =3D "Closed" AND 'Case ID+' =3D"000000000373200". So the query itself is correct. Why the error message shows '^' and why does it exit? Thank you. ------------------------------------------------------------------------ - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D= DEVDE V _______________________________________________ Arsperl-users mailing list Ars...@ar... https://lists.sourceforge.net/lists/listinfo/arsperl-users ------------------------------------------------------------------------ - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D= DEVDE V _______________________________________________ Arsperl-users mailing list Ars...@ar... https://lists.sourceforge.net/lists/listinfo/arsperl-users ------------------------------------------------------------------------ - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D= DEVDE V _______________________________________________ Arsperl-users mailing list Ars...@ar... https://lists.sourceforge.net/lists/listinfo/arsperl-users |
|
From: Carey M. B. <bla...@gm...> - 2007-04-11 15:39:42
|
Stan, You said that 'Case ID+' is a field label. You did not supply the line of code that was producing the error. (ars_LoadQualifier) So I have to talk about what might be going on. The docs for say this: " ars_LoadQualifier(ctrl, schema, qualstring, displayTag) <snip> When mapping field names, the server will refer to the view specified in displayTag. If no view is specified, the server will use the default admin view. " Some ideas: What value did you use for the displayTag in your call to ars_LoadQualifier? What is the label for the field on the Default View for the form? What is the field's DB name? Have you tried using the field's DB name? -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 4/10/07, STAN HOLODNAK, BLOOMBERG/ 731 LEXIN <sch...@bl...> wrote: > Mark, thank you for your help. The schema is the same but the 'Case ID+' is a > field label in that view not the field name. This script was always working on > ARS 5.1, but when we moved to 6.3 it sometimes breaks. -Stan |
Thanks for helping keep SourceForge clean.
X