Log in Register

Login to your account

Username *
Password *
Remember Me

Create an account

Fields marked with an asterisk (*) are required.
Name *
Username *
Password *
Verify password *
Email *
Verify email *
Captcha *
Welcome, Guest
Username: Password: Remember me
Questions and answers test do it together
  • Page:
  • 1
  • 2

TOPIC:

Turbocash: Year-end rollover error: violation of P 9 years 10 months ago #272

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)
Attachments:

Please Log in or Create an account to join the conversation.

Turbocash: Year-end rollover error: violation of P 9 years 10 months ago #271

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.

Please Log in or Create an account to join the conversation.

Turbocash: Year-end rollover error: violation of P 9 years 10 months ago #270

Sorry - edited my post before seeing your reply

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

Please Log in or Create an account to join the conversation.

Last edit: by arcay. Reason: added screencapture

Turbocash: Year-end rollover error: violation of P 9 years 10 months ago #269

look at the tab parameters there is the violating entry.

Please Log in or Create an account to join the conversation.

Turbocash: Year-end rollover error: violation of P 9 years 10 months ago #268

Capture of DBMonitor with error

SQL-command giving problem:
INSERT INTO totals
  (totals.WACCOUNTID, totals.WPERIODID, totals.WYEARID, totals.BACTUAL, 
   totals.FAMOUNT, totals.DSYSDATE)
VALUES
  (:WACCOUNTID, :WPERIODID, :WYEARID, :BACTUAL, :FAMOUNT, :DSYSDATE)

EDIT:
Error:
violation of PRIMARY or UNIQUE KEY constraint "INTEG_139" on table "TOTALS"

Additional capture showing parameters

/EDIT

Any other information I can provide?
Attachments:

Please Log in or Create an account to join the conversation.

Last edit: by arcay. Reason: Additional screencapture and errormsg-detail

Turbocash: Year-end rollover error: violation of P 9 years 10 months ago #267

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.

Please Log in or Create an account to join the conversation.

Turbocash: Year-end rollover error: violation of P 9 years 10 months ago #266

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:
SELECT a.WACCOUNTID, a.WPERIODID, a.WYEARID, a.BACTUAL, a.FAMOUNT, a.DSYSDATE
FROM TOTALS a 
WHERE
    a.WACCOUNTID = NULL OR 
    a.WPERIODID = null OR 
    a.WYEARID = null OR 
    a.BACTUAL = null OR 
    a.FAMOUNT = null

but result is empty.

Shall I attach a copy of the Totals-table?

Please Log in or Create an account to join the conversation.

Turbocash: Year-end rollover error: violation of P 9 years 10 months ago #265

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.

Please Log in or Create an account to join the conversation.

Turbocash: Year-end rollover error: violation of P 9 years 10 months ago #264

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

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
  • 2