Onderwerp:

OK - I did the following:
Query Totals-table for AccountID=9, and saved as CSV-file, (FlameRobin)
Then Backup DB (TC5)
Then Deleted all rows where AccountID=9 (FlameRobin)
Then opened in TC5 and agree to YearEnd....

Same Error but on AccountID=40

Screencapture on parameters added

What I can't confirm is whether AccountID=9 was re-added during the Year-end tasks (I need Flamerobin to access SQL-data, but TC5 has it locked)

Now query the totals for the accountid 9

To see what rows are there.

Backup database and delete the rows to see if it progresses.

Sorry - edited my post before seeing your reply

Added addtional screencapture on that post, but here as well.

look at the tab parameters there is the violating entry.

Capture of DBMonitor with error

SQL-command giving problem:
EDIT:
Error:
Additional capture showing parameters

/EDIT

Any other information I can provide?

www.osf-boekhoudpakket-administratie.nl/index.php/en/downloads2

See SQL monitor tool.
Go to setup->company data and then second tab.
Turn on SQL debug and press save on the right bottom.

See what params are used to understand what data is entered.
The errors are red in the sql debugger.

Thanks for the reply.
I had a look at the table using FlameRobin, and can only see 'Null'-values in the DSYSDATE-field.

Tried this SQL-statement:
but result is empty.

Shall I attach a copy of the Totals-table?

looks like you have a totals table that is messesed up.
it takes special tools to get that fixed.
it could be just a null field so if you know sql look at the table totals and see if a key has a null value.

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