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
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
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
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,
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
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:
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
7 matches
Mail list logo