Re: Error on particular CTI
Just a thought .. See if the summary (template) was set-up with a C/T/I that as since been deleted. The template C/T/I may have been OK before, but is filling in an invalid C/T/I now HTH, Joel * Joel D. Sender Director of Western Operations QMX Support Services, Inc. [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of nsachin Sent: Friday, July 13, 2007 3:16 AM To: arslist@ARSLIST.ORG Subject: Re: Error on particular CTI i think nobody is able to solve my problem. Regards, Sachin Namjoshi nsachin wrote: Hi all Listers, I am getting a strange error on saving a request on CHG:Change form. After selecting a particular summary only ( as per predefined CTI) and filling all the required fields, I get this error as per attachment on Save button. After checking the log, I have found that this error is occurring after push field action. The save button works fine on other CTI's of Summary field. It doesn't give this SQL error after selecting other CTI's. Can you please help me on this? http://www.nabble.com/file/p11575655/SQLerror1.bmp SQLerror1.bmp :-D -- View this message in context: http://www.nabble.com/Error-on-particular-CTI-tf4073030.html#a11576647 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Error on particular CTI
Did you look at the Active link in Question? Why don't you post the SQL statement in the Active link. It sais that you are missing a comma. Look at the Query and then copy and paste the Query into what ever database client tool that you use. Look at your syntax and see what your backend database expects. Rob ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Error on particular CTI
Error 552 is simply an error stating that there was a problem with a SQL call to the database. The following message ORA-00917 shows that there was a SQL call written missing a semicolon. The bottom of the error message looks like this error is being generated by an active link. I can't tell which al from the image. I would check the active link generating the error and the next few above it (in execution order) to see if there are set fields or other actions using direct SQL calls that could be generating the error message. If that is not the case, turn on SQL logging to zone in on what is causing the error. Marc Simmons On 7/16/07, Joel D. Sender [EMAIL PROTECTED] wrote: Just a thought .. See if the summary (template) was set-up with a C/T/I that as since been deleted. The template C/T/I may have been OK before, but is filling in an invalid C/T/I now HTH, Joel * Joel D. Sender Director of Western Operations QMX Support Services, Inc. [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] Behalf Of nsachin Sent: Friday, July 13, 2007 3:16 AM To: arslist@ARSLIST.ORG Subject: Re: Error on particular CTI i think nobody is able to solve my problem. Regards, Sachin Namjoshi nsachin wrote: Hi all Listers, I am getting a strange error on saving a request on CHG:Change form. After selecting a particular summary only ( as per predefined CTI) and filling all the required fields, I get this error as per attachment on Save button. After checking the log, I have found that this error is occurring after push field action. The save button works fine on other CTI's of Summary field. It doesn't give this SQL error after selecting other CTI's. Can you please help me on this? http://www.nabble.com/file/p11575655/SQLerror1.bmp SQLerror1.bmp :-D -- View this message in context: http://www.nabble.com/Error-on-particular-CTI-tf4073030.html#a11576647 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- Marc Simmons Remedy Administrator Everyday above ground is a good day... the rest is a choice! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Error on particular CTI
i think nobody is able to solve my problem. Regards, Sachin Namjoshi nsachin wrote: Hi all Listers, I am getting a strange error on saving a request on CHG:Change form. After selecting a particular summary only ( as per predefined CTI) and filling all the required fields, I get this error as per attachment on Save button. After checking the log, I have found that this error is occurring after push field action. The save button works fine on other CTI’s of Summary field. It doesn’t give this SQL error after selecting other CTI’s. Can you please help me on this? http://www.nabble.com/file/p11575655/SQLerror1.bmp SQLerror1.bmp :-D -- View this message in context: http://www.nabble.com/Error-on-particular-CTI-tf4073030.html#a11576647 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Error on particular CTI
The screen shot simply shows the SQL error message. In order to diagnose, you should turn on AL/Filter/SQL Logging into a consolidated file, and analyze. Locate the failing SQL statement to determine if it is ARServer generating the SQL, or some internal workflow. Thanks-n-advance; HDT Platform Incident / Problem Manager Architect Robert Molenda IT OS PA Tel: +1 408 503 2701 Fax: +1 408 503 2912 Mobile: +1 408 472 8097 [EMAIL PROTECTED] Quality begins with your actions. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of nsachin Sent: Friday, July 13, 2007 3:16 AM To: arslist@ARSLIST.ORG Subject: Re: Error on particular CTI i think nobody is able to solve my problem. Regards, Sachin Namjoshi nsachin wrote: Hi all Listers, I am getting a strange error on saving a request on CHG:Change form. After selecting a particular summary only ( as per predefined CTI) and filling all the required fields, I get this error as per attachment on Save button. After checking the log, I have found that this error is occurring after push field action. The save button works fine on other CTI's of Summary field. It doesn't give this SQL error after selecting other CTI's. Can you please help me on this? http://www.nabble.com/file/p11575655/SQLerror1.bmp SQLerror1.bmp :-D -- View this message in context: http://www.nabble.com/Error-on-particular-CTI-tf4073030.html#a11576647 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Error on particular CTI
Hi all Listers, I am getting a strange error on saving a request on CHG:Change form. After selecting a particular summary only ( as per predefined CTI) and filling all the required fields, I get this error as per attachment on Save button. After checking the log, I have found that this error is occurring after push field action. The save button works fine on other CTI’s of Summary field. It doesn’t give this SQL error after selecting other CTI’s. Can you please help me on this? http://www.nabble.com/file/p11575655/SQLerror1.bmp SQLerror1.bmp -- View this message in context: http://www.nabble.com/Error-on-particular-CTI-tf4073030.html#a11575655 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Error on particular CTI
Turn on your SQL logging and maybe filter logging on the server to see what you get. Sounds like there might be something with a character in the Summary or CTI. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of nsachin Sent: Friday, July 13, 2007 3:49 AM To: arslist@ARSLIST.ORG Subject: Error on particular CTI Hi all Listers, I am getting a strange error on saving a request on CHG:Change form. After selecting a particular summary only ( as per predefined CTI) and filling all the required fields, I get this error as per attachment on Save button. After checking the log, I have found that this error is occurring after push field action. The save button works fine on other CTI's of Summary field. It doesn't give this SQL error after selecting other CTI's. Can you please help me on this? http://www.nabble.com/file/p11575655/SQLerror1.bmp SQLerror1.bmp -- View this message in context: http://www.nabble.com/Error-on-particular-CTI-tf4073030.html#a11575655 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are