Hi
Triying to do a year-end rollover and getting the following error:
TC4-message:
"SQL Error: violation of PRIMARY or UNIQUE KEY constraint "INTEG_139" on table "TOTALS". Error Code: -803. Invalid insert or update value(s): object columns are
constrained - no 2 table rows can have duplicate column values The SQL: INSERT INTO totals (totals.WACCOUNTID, totals.WPERIODID, totals.WYEARID, totals.BACTUAL, totals.FAMOUNT, totals.DSYSDATE) VALUES (?, ?, ?, ?, ?, ?); on account9 Period 1"
TC5-message:
"violation of PRIMARY or UNIQUE KEY constraint "INTEG_139" on table "TOTALS" on account9 Period 1"
I've tried TC500600 and TC500763
There was a similar error reported on Turbocash.ning.com (
turbocash.ning.com/forum/topics/year-end-procedure),
but the 'solution' mentioned there did not work for me.
This query was also posted on Turbocashlive.com (
www.turbocashlive.com/index.php/componen...ation-of-primary-key), with another user having the a similar problem.
But no answers so far, even ignoring my request for quote to look at my database.
Any ideas what I need to fix?
r