Run SQL logging on the server; grep out unwanted records (say by user id); then look at the SQL statement that throws the error.
Cheers Ben >----- ------- Original Message ------- ----- >From: Dave Barber <[EMAIL PROTECTED]> >To: arslist@ARSLIST.ORG >Sent: Fri, 1 Dec 2006 12:47:15 > >All, > >One of our users is running a report/extract >against a join form. You can >browse the join form without any issues, but upon >running the report and >extracing the data, you get the following : > >Error occurred in generating report. >ARERR [552] failure during SQL operation to the >database : Line 1; Incorrect >syntax near ')' (SQL Server 170). > >>From what I've browsed, that seems to imply that >we have a field with a >label of ')'. The only field labeled with a >non-text character is labelled >with a dash (-). Its not this field thats throwing >out the extract (removal >of it still leaves the same issue). > >Its an in-house application, running on ARS 5.1.2 >against a SQL Server >database. > >Any suggestions? > >Regards > >Dave > >___________________________________________________ >____________________________ >UNSUBSCRIBE or access ARSlist Archives at >www.arslist.org ARSlist:"Where the Answers Are" >** ><div>All,</div> ><div> </div> ><div>One of our users is running a report/extract >against a join form. You can browse the join >form without any issues, but upon running the >report and extracing the data, you get the >following :</div> ><div> </div> ><div>Error occurred in generating report.</div> ><div>ARERR [552] failure during SQL operation to >the database : Line 1; Incorrect syntax near ')' >(SQL Server 170).</div> ><div> </div> ><div>From what I've browsed, that seems to imply >that we have a field with a label of ')'. The >only field labeled with a non-text character is >labelled with a dash (-). Its not this field >thats throwing out the extract (removal of it still >leaves the same issue). ></div> ><div> </div> ><div>Its an in-house application, running on ARS >5.1.2 against a SQL Server database.</div> ><div> </div> ><div>Any suggestions?</div> ><div><br>Regards</div> ><div> </div> ><div>Dave</div> >__20060125_______________________This posting was >submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"