Message-ID: <02f501c39fbc$405e5d60$0a52dcc1@CATSMGMT> From: "Volven D'souza" <volven@cats-net.com> Subject: Re: [Emerald] Call Table Nightly processing Date: Fri, 31 Oct 2003 17:35:37 +0300
Hi Dale,
We were using version 2.5 and we had upgraded to 4.5 about 9-10 Months ago.
Now, we have a new situation here , after the roll-back of yesterday we are
seeing the following error when trying to Void an Invoice ;
Failed to create reversal invoice. SQL Error: [Microsoft][ODBC SQL Server
Driver][SQL Server]INSERT statement conflicted with COLUMN FOREIGN KEY
constraint 'FK__Invoices__Invoic__6E565CE8'. The conflict occurred in
database 'emerald4', table 'InvoiceTypes', column 'InvoiceTypeID'.
Please assist !
Regards
Volven D'souza
----- Original Message -----
From: "Dale E. Reed Jr." <daler@iea-software.com>
To: <emerald@iea-software.com>
Sent: Thursday, October 30, 2003 8:39 PM
Subject: RE: [Emerald] Call Table Nightly processing
> > didn't see any documentaion about the installation of the same,
> > applied the
> > patch and could no longer login as the Admin, it would spill out an SQL
> > Error message ! Had to roll back to 4.5.3 !
> >
> > Any hints what could have caused it ? or any prerequisites ?
>
> See the changes.txt in 4.5.3 about upgrading from 4.2 and lower to 4.5
> (about running Emerald in debug modem and making sure the database upgrade
> completes). Most likely the DB update didn't complete and that is why
> the new version fails.
>
> Dale
>
>