Re: Any clues on ARERR [552] ?

2006-12-01 Thread Dave Barber
Sabrina, I've had that issue with diary fields before now. However, there are no diary fields on this join form, I've tried removing all the longer text fields (possible problem with some characters), and that doesn't resolve it. I'm doing this the long winded way - removing fields until I find

Re: Any clues on ARERR [552] ?

2006-12-01 Thread Sabrina Ethridge
Dave Do you have any Diary fields in the export when you see the problem? If I recall correctly, we had this problem and it was due to a corrupt timestamp in a diary field, which was corrupted by a bad data import. If I remember correctly, we found the exact record by running smaller and smal

Re: Any clues on ARERR [552] ?

2006-12-01 Thread Dave Barber
Okay then, some (small) amount of progress. I've got the SQL log, which doesn't help that much. However, restricting the report to just one or two fields rather than all allows the query/extract to run correctly. Nothing in the logs points to which field is causing the report to crash out, so i

Re: Any clues on ARERR [552] ?

2006-12-01 Thread Dave Barber
We're definitely doing the search in the correct manner; I learnt about that the hard way a few years back. SQL logging makes for interesting reading, I've grepped out "my" entries into another file, and will start looking through it. Haven't had much experience of this type of debugging before,

Re: Any clues on ARERR [552] ?

2006-12-01 Thread Carey Matthew Black
Dave, This is a WAG without seeing the SQL in question... but... I would make sure that the user is using the following procedure. 1) Open form in Query mode. 2) Specify search conditions 3) DO NOT DO THE SEARCH 4) Jump directly to the report selection screen from the QUERY window. 5) select th

Re: Any clues on ARERR [552] ?

2006-12-01 Thread Ben Chernys
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:

Any clues on ARERR [552] ?

2006-12-01 Thread Dave Barber
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 : Lin