QDF: Validating your data and Security Comparison Mismatch

Gamal Mustafa

After I validate or Super validate I keep getting the same error over and over. (see log file at the end)
I can't "Copy" or "Year-End-Copy". I will get a message that reads "File NOT copied".
I can't do a "File Export" to a "Quicken Transfer Format File", because it will ALWAYS crash the program.

Also one of the accounts will open a message window telling me that I have a "Security Comparison Mismatch" every time I do a one-step-update, of two stocks I don't have anymore. (Not sure if is related). Now, notice that the number of shares is negative. I have tried to "Create a placeholder transaction for the difference", but it does not seem to get recorded, so the next time I run one-step-update I will get the same "Security Comparison Mismatch" window.




Here is the Log of the last "Super validate".
Note: I don't have an account called "ACCT_14999"
----------------------------------------------------------------------------------------------------------------
Super Validation 
----------------------------------------------------------------------------------------------------------------

QDF:

Validating your data.

Fixed damaged category.  Please check your category list by going to Tools>Category List.

Quicken repaired damaged transaction index.  No action required.

Quicken found an invalid transaction and removed it. "ACCT_14999"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_14999"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_14999"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_14999"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_14999"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_14999"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_14999"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_14999"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_14999"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_14999"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_14999"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_14999"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_14999"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_14999"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_14999"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_14999"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_14999"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_14999"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_14999"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_14999"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_14999"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_14999"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_14999"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_14999"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_14999"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_14999"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_14999"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_14999"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_14999"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_14999"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_14999"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_14999"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_14999"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_14999"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_14999"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_14999"  0/ 0/1900

Summary:

Quicken repaired 1 accounts.  No action required.

QEL:

The old file was corrupt and only some of the data has been recovered.

QEL:

All internal consistency checks passed.

[Tue Jun 23 20:45:44 2020]

Analyzing securities.

Number of old style Buy/Cash investment transactions updated: 21/0

No out-of-range security references found.

Super validation has completed.

----------------------------------------------------------------------------------------------------------------

markus1957

The security comparison mismatch can be fixed by going to the last sell transaction for the 2 securities and clicking the box to sell all shares.

Your data file is corrupted if the Copy won't run.  You can try to find a good backup that will Copy.  As a last resort; https://www.quicken.com/support/message-file-not-copied

markus1957

I think you found the damaged category.  In my file the group assigned is Rental Property Expenses.  I was able to create a custom group called Test and then assign that category to Test.  I could then remove it from Test and it changed back to the default.

You might try playing with that. If you are lucky, it might change to the correct default group.  Run the validation to see if it still shows damaged.  In any case you might have to live with it.  Your file is in pretty good shape now.  If you don't use that category, it will probably never cause an issue. 

markus1957

I'd do one final Copy without the shift key and then use the Copy.  You may yet stumble into the damaged category, but I'm out of suggestions.

If you encounter the Reminders errors again, currently the only way to fix errors that super-validation does not fix is to manually delete all reminders one-by-one and close/open Quicken. Then re-enter them.

markus1957

The security comparison mismatch can be fixed by going to the last sell transaction for the 2 securities and clicking the box to sell all shares.

Your data file is corrupted if the Copy won't run.  You can try to find a good backup that will Copy.  As a last resort; https://www.quicken.com/support/message-file-not-copied

q_lurker

Security Comparison mismatch -- Motorola went through a series of transactions in Jan, 2011 creating the two securities you are having an issue with.  Share counts in those transactions and in subsequent sales need to be consistent.  There are a variety of ways you could have entered those 2011 transactions including some transactions that might have stretched farther back in time.    

Gamal Mustafa

Ok, I just went back to the last sell transaction for the 2 securities and clicked on the box to "sell all shares". Nothing really changed, but I did not get the "Security Comparison Mismatch"  window I usually get after do a one-step-update and accept the transactions. Thanks!

do you know how do I find where is that  "ACCT_14999"?

Gamal Mustafa

Hi q_lurker, yes the problem has been after I sold them. First when O sold Mot Mobility and the When I sold Mot Solution. I applied markus1957 solution and in the last update the window did not came up. I have to wait until there are new transactions to see if that actually solved.

markus1957

That account is a corrupt ghost account. Unlikely, but sometimes they appear as [Categories] in the Category List. Less often, they show up under the links in the OSU summary screen; clicking gets you to the ghost account register where it can be deleted in Account Details. 

You could try to back door into it by creating a transfer transaction into the account from a spending account. You do that by entering [ACCT_14999] including the brackets into the Category field.  Save the transaction, then right click on it; select Go to matching transfer. That should take you to the account register of the ghost account.  From there in upper right corner, use the gear icon to get to the Account Details window, where there is a button to Delete Account.

Adding- Until your file completes the Quicken Copy routine, it remains significantly corrupted to a level that future problems are almost certain.

Gamal Mustafa

Ok, I tried [ACCT_14999], [ACCT 14999], [14999] and it said "account does not exist"

I checked also for categories with similar name and nothing. I deleted unused categories anyway...

what is the OSU?

Gamal Mustafa

OK. I think I found something. It now change from ACCT_14999 to ACCT_1499f.

If enter something with that category, it will allow it, however it is not a category in the list. If I try to create it as new, it will say "Duplicate category name. try another name".

markus1957

One Step Update (OSU).  You should be able to get to the account register using the "back door" instructions provided above.

Gamal Mustafa

I tried that... ACCT_1499f is a ghost category, not a an account.

if I try "[ACCT_1499f]", it will not find anything.... however if I try "ACCT_1499f" it will.

However ACCT_1499f is not in the Category List, is not even a hidden one, I cannot re-categorize or delete it.

and it make sense because the first message in validate is "Fixed damaged category.  Please check your category list by going to Tools>Category List."

however, when I check Category List, i don't see anything unordinary,

Gamal Mustafa

Now it change from ACCT_14999 to ACCT_1499f

Here is the Log of the last "validate".
----------------------------------------------------------------------------------------------------------------
Validation 
----------------------------------------------------------------------------------------------------------------

QDF:

Validating your data.

Fixed damaged category.  Please check your category list by going to Tools>Category List.

Quicken repaired damaged transaction index.  No action required.

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_1499f"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_1499f"  0/ 0/1900

Summary:

Quicken repaired 1 accounts.  No action required.

QEL:

The old file was corrupt and only some of the data has been recovered.

QEL:

All internal consistency checks passed.

[Wed Jun 24 23:32:19 2020]

1 scheduled transactions corrected

Found 1 reinvestment transaction with zero shares; set dollar amounts to zero.

Repair price history: 0 price(s) repaired.

[Wed Jun 24 23:34:07 2020]

[Wed Jun 24 23:41:09 2020]

Rebuilt investing lots.

Analyzing securities.

Number of old style Buy/Cash investment transactions updated: 21/0

No out-of-range security references found.

Validation has completed.

markus1957

The brackets indicate an account; if you can't get to a register from a bracketed category, then it does not exist or can't be accessed.

Did you try the Copy routine in the link I provided?

Your file is a mess.

Gamal Mustafa

Hi Markus, yes the Copy routine in the link worked. But I am still using the original file.

It ask me if I wanted to use the copy and I said no. Should I had say yes to that?

GeoffG

Yes, you should use the copied file. Quicken rebuilds data tables when File Copy is used and can mitigate some data corrupted files. It may not solve all your issues, but is a step in the right direction.

markus1957

You should use the copy file after you validate and super-validate the Copy. It wouldn't hurt to run the regular Copy routine after the super-validate to verify the file tables don't have to use the "skip over junk" exception.

Gamal Mustafa

The category name keep changing. Perhaps I did not realize that before.....
This is the new error today:

QDF:

Validating your data.

Fixed damaged category.  Please check your category list by going to Tools>Category List.

Quicken repaired damaged transaction index.  No action required.

Quicken found an invalid transaction and removed it. "ACCT_149a4"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_149a4"  0/ 0/1900

Quicken found an invalid transaction and removed it. "ACCT_149a4"  0/ 0/1900

Quicken repaired some transaction information.  No action required.

 "ACCT_149a4"  0/ 0/1900
...

Its is definitely a ghost category called ACCT_149a4. I can even use it... but i cannot find it to delete it. nor can i find transactions from 0/ 0/1900

Gamal Mustafa

Ok I am doing a copy now and ruining validate after that and super validate after that and post the results

Gamal Mustafa

This validate
(some time it does not show the "Quicken found an invalid transaction and removed it. "ACCT_XXXXX"  0/ 0/1900...") but it always say it "Fixed damaged category."
I will post super validate when is done

----------------------------------------------------------------------------------------------------------------
Validation 
----------------------------------------------------------------------------------------------------------------

[Thu Jun 25 12:32:30 2020]

File: "\PERSONAL3" 

QDF:

Validating your data.

Fixed damaged category.  Please check your category list by going to Tools>Category List.

Repaired your data file by removing a damaged category. Please check your category list for missing categories by going to Tools>Category List.

QEL:

No read errors.

QEL:

All internal consistency checks passed.

[Thu Jun 25 12:33:45 2020]

Repair price history: 0 price(s) repaired.

[Thu Jun 25 12:35:11 2020]

[Thu Jun 25 12:39:43 2020]

Rebuilt investing lots.

Analyzing securities.

Number of old style Buy/Cash investment transactions updated: 21/0

No out-of-range security references found.

Validation has completed.

Gamal Mustafa

This is the Super validate

Again it say it "Fixed damaged category."
But for two in a row it did not show "ACCT_XXXXX"  0/ 0/1900...") but it always say it "Fixed damaged category." That is new. 

----------------------------------------------------------------------------------------------------------------
Super Validation 
----------------------------------------------------------------------------------------------------------------

[Thu Jun 25 12:42:16 2020]

File: "PERSONAL3" 

QDF:

Validating your data.

Fixed damaged category.  Please check your category list by going to Tools>Category List.

QEL:

No read errors.

QEL:

All internal consistency checks passed.

[Thu Jun 25 12:44:50 2020]

Found 1 reinvestment transaction with zero shares; set dollar amounts to zero.

Repair price history: 0 price(s) repaired.

[Thu Jun 25 12:46:15 2020]

[Thu Jun 25 12:50:52 2020]

Rebuilt investing lots.

Analyzing securities.

Number of old style Buy/Cash investment transactions updated: 21/0

No out-of-range security references found.

Super validation has completed.

markus1957

You are getting closer to having a usable file. Have you looked at category list, including hidden categories for anything that looks strange? 

Look for that zero shares transaction and delete or edit it with correct information.

Regular Copy process now runs without stopping?

Continue to run Copy, validate, super-validate, choosing to use the copy each time until no errors post. Old style Buy/Cash is not an error. 

Then, when error free, rename the last copy file with the name you want to use.  Use that file from now on.

Adding- turn off Cloud Sync in Preferences so it doesn't screw up the file.  Leave it off if you don't use it.  Otherwise wait to turn it back on until you see your file is behaving.

Gamal Mustafa

Yes, I checked all categories, even hiding one. deleted most of the one not been used.

How do I find a zero share transaction?

markus1957

In the investment account register there is a "Find" icon in upper right.  Try that.

Adding- If your Category List is not too large, you might try clicking on every category to make sure they all open and don't contain gibberish characters in any of the fields.

Gamal Mustafa

I did a find on all 19 active investment accounts. searched for "exact 0 shares" found nothing.

My file have data since 1989... I have a 334 active categories (with items)....and a lot of entries... it would be hard going one by one...

I did a new copy. This time it went Ok. Without the need of Shift (should I do shift anyway?)

I also did a super validation. however, I got the same error..

----------------------------------------------------------------------------------------------------------------
Super Validation 
----------------------------------------------------------------------------------------------------------------

[Thu Jun 25 16:22:17 2020]

File: "PERSONAL4" 

QDF:

Validating your data.

Fixed damaged category.  Please check your category list by going to Tools>Category List.

QEL:

No read errors.

QEL:

All internal consistency checks passed.

[Thu Jun 25 16:25:00 2020]

Found 1 reinvestment transaction with zero shares; set dollar amounts to zero.

Repair price history: 0 price(s) repaired.

[Thu Jun 25 16:26:22 2020]

[Thu Jun 25 16:30:36 2020]

Rebuilt investing lots.

Analyzing securities.

Number of old style Buy/Cash investment transactions updated: 21/0

No out-of-range security references found.

Super validation has completed.

Gamal Mustafa

This validate

The same errors...

----------------------------------------------------------------------------------------------------------------
Validation 
----------------------------------------------------------------------------------------------------------------
[Thu Jun 25 16:38:18 2020]

File: "PERSONAL4" 

QDF:

Validating your data.

Fixed damaged category.  Please check your category list by going to Tools>Category List.

QEL:

No read errors.

QEL:

All internal consistency checks passed.

[Thu Jun 25 16:39:33 2020]

Found 1 reinvestment transaction with zero shares; set dollar amounts to zero.

Repair price history: 0 price(s) repaired.

[Thu Jun 25 16:40:55 2020]

[Thu Jun 25 16:45:13 2020]

Rebuilt investing lots.

Analyzing securities.

Number of old style Buy/Cash investment transactions updated: 21/0

No out-of-range security references found.

Validation has completed.

markus1957

https://www.quicken.com/support/correct-damaged-category  for the Category issue.

Try searching for a zero dollar amount for the investment transaction.

Gamal Mustafa

I found 1 reinvestment transaction with zero shares! Fixed that.
Did another copy.
Did another Super Validation.
only one error... have no idea how to fix it.
what should I check on Tools>Category List?

This is the result:
----------------------------------------------------------------------------------------------------------------
Super Validation 
----------------------------------------------------------------------------------------------------------------

[Thu Jun 25 18:30:32 2020]

File: "PERSONAL5" 

QDF:

Validating your data.

Fixed damaged category.  Please check your category list by going to Tools>Category List.

QEL:

No read errors.

QEL:

All internal consistency checks passed.

[Thu Jun 25 18:35:33 2020]

Repair price history: 0 price(s) repaired.

[Thu Jun 25 18:36:57 2020]

[Thu Jun 25 18:41:10 2020]

Rebuilt investing lots.

Analyzing securities.

Number of old style Buy/Cash investment transactions updated: 21/0

No out-of-range security references found.

Super validation has completed.

markus1957

Use the link.  In Category List window, click Options button at bottom; Manage Categories.  Follow instructions in link to rebuild list.

Or as I mentioned before, click thru each of your Categories to see if one does not respond or contains gibberish.

Gamal Mustafa

Ok. I tried "rebuild the category list" it added a bunch of categories, some of them similar o a name change of my original one... I fixed the rental categories to use the new terminology and format, thinking that could be it... that did not help...

the option was to "Create a new category similarly named to the category that is broken". However, I don't know the which one is broken to be able to do that.

Ran a validate. still the same error...

----------------------------------------------------------------------------------------------------------------
Validation 
----------------------------------------------------------------------------------------------------------------

[Thu Jun 25 21:09:04 2020]

File: "PERSONAL5" 

QDF:

Validating your data.

Fixed damaged category.  Please check your category list by going to Tools>Category List.

QEL:

No read errors.

QEL:

All internal consistency checks passed.

[Thu Jun 25 21:10:19 2020]

Analyzing securities.

Number of old style Buy/Cash investment transactions updated: 21/0

No out-of-range security references found.

Validation has completed.

Gamal Mustafa

I think it may have something to do with rental...

I have never really used it features... But I decided to do a "View Rent Receipt" and it crashed. also there is a category with zero items that I cannot delete or change its group. Quicken had a group called Rental that no it change to Rental Property Expenses, but that category is there lingering. I cannot delete, change the group or change the tax line.

GeoffG

If it's the last item you have highlighted, that is an internal category that cannot be deleted (Quicken will disallow). Any category that begins with _ is internal and can be hidden if not needed.

Gamal Mustafa

12345