Duh, solved this second issue. When doing the backups and restores I
failed to notice permissions on the fdb were root rather than
firebird. After that validation went fine.

--- In firebird-support@yahoogroups.com, "David at PFI"
<firebird-support-david@...> wrote:

>
> Hi, this is a further followup to the below message. The error I
> received when trying to validate, check, mend, or sweep is:
> "Connection error.
> bad parameters on attach or create database.
> secondary server attachments cannot validate databases."
>
> I could not find an explanation in the release notes as to what this
> error means in layman terms. Any ideas.
>
> Thanks a bunch,
>
> David
>
> --- In firebird-support@yahoogroups.com, "David at PFI"
> <firebird-support-david@> wrote:
> >
> > Hello all,
> >
> > Can't seem to find anyone else seeing this. Hence this request

for help

> >
> > Environment:
> > server: ubuntu running fb 1.5.3
> > devel client: running winxp with fb 2.0 rc3 and IBExpert
> >
> > In ibexpert I have the connection to the 1.5.3 server using the
> > fbclient.dll ver 2. The local connection on server 2.0 is also using
> > the fbclient.dll ver 2.
> >
> > I have been making revisions both to the content and structure of the
> > database from the server by backing it up, and restoring onto the ver
> > 2.0 client. When i am satisfied with the changes made, I run a
> > database compare from IBExpert which prepares a DDL script to
> > impliment the changes. I then pick through the statements one at a
> > time onto the live fb 1.5.3 server. Any content changes I hand do. I
> > am not using any of the features unique to ver 2. It was actually a
> > mistake that 2.0 was on the devel client as I had though the live copy
> > was running ver 2 originally.
> >
> > This error started appearing the last time I attempted to do my
> > regular backups. It is appearing on both the server and client

copies.

> >
> > Error: "Firebird error. arithmetic exception, numeric overflow, or
> > string trunication. unknown ISC error 0."
> >
> > This error stops the backup from completing. It seems to die near the
> > end when it is working through the Generators.
> >
> > I do use a few calculated fields, though deleting those did not fix
> > the error. I have not dropped the tables that I imported just before
> > I started seeing the error, as they have numerous keys and constraints
> > and hence a pain to drop or delete all.
> >
> > Since the error is pretty ambiguous, I thought I should not try to
> > hack through a fix and make things worse since I am unable to backup
> > successfully. I did try to validate the database but a similar error
> > prevented validation. Error: "Connection error.
> > bad parameters on attach or create database.
> > secondary server attachments cannot validate databases."
> >
> > I did try deleting the generator that the backup log failed at. when
> > i did that I got a new error:
> > "Arithmetic overflow or division by zero has occurred. arithmetic
> > exception, numeric overflow, or string trunication. gds_$receive
> failed."
> >
> > Any help would be appreciated.
> >
>