Files typically get corrupted because of something in the deployment; I would scrutinize the deployment to make sure it is completely to best practices before deploying any of the new files.
In addition to the recovery: can you run an XML DDR on the files? Does that error out at some point?
1 of 1 people found this helpful
"Recover" is not well documented, so "problems" found can be unnecessarily scary
I have collected info here: http://www.fileshoppe.com/recover.htm
The key is the Recover Log. You need to see what the "Problems" actually are
( You can send me the log, if not sure )
If you can remove, or replace objects, and get the "Problems" to disappear, then the file is probably okay
Are there any other symptoms ?
I have a few files in production, that have "problems", that are minor, and just don't matter
if one file in a multi-file system is "corrupt", it can affect performance of the entire solution. I have seen this happen
> I think i narrowed it down to 2 tables with key errors. I replaced those tables and it appears to be working but I don't want to risk staying in that file.
I can run a full xml DDR that does not error out. Sorry I am not positive what you mean by deployment. I assume it means making sure my server machine is set up correctly. power failover as well as the right versions of java and the like?
I have a great server now and properly deployed server now. unfortunately in the past, I did not. Based on checking my backups from when i first moved the file over, it was giving the same errors then.
I will post my symptoms in a follow up post.
I get the usual 8495 problems error. then i get
Schema: scanned fields and tables; some problems were found...
fields created to match record data: 0
field values deleted due to invalid ID or repetition: 0
records deleted due to invalid ID: 0
Structure: scanned; 2 item(s) modified
there are no other errors in the log file. I was praying that i could perform surgery on the file. I started by deleted EVERYTHING from a copy to see if it would go away. down to the privilege sets and custom functions. nothing worked.
then i tried copying the tables to a new DB and receiving that, it failed the same way
when I tried copying table by table, i narrowed it down to 2 fields that gave me the error "Resetting invalid table key"
I attempted to complete delete those tables and their TOs in my file and that still does not fix the issue. and that was hours of work but worth a shot based on my trouble shooting.
-exiting layout mode does not work. edits are kept but i have to close the window and reopen it to resume normal operation.
-random quits which were not really a concern but these things are finally adding up.
-gernerally poor performance which i blamed on a few calcs that were verifying data on a few related records. I recently made them auto enter fields that just get updated with the child rec is updated and that really highlighted the laggy/skippy scrolling in list view.
- most recently, at times, selecting a rec in list view makes the field you are editing actually change the record below it. deleting a record will also delete the record below where the button was clicked. this can happen to the next record in a table even if it is not in the found set!
This has happened across many macs running different versions of the latest OS and server 15.0.1, 15.0.2 and now 15.0.3
also, running a server class windows PC with windows server 12 as the os.
Not quite clear. Did removing the Tables remove the "Problems", but not the symptoms ?
Just out of curiosity, send me the full Recover Log ( email@example.com )
If "2 item(s) modified", you need to find those items, in the Log ( search for "Changed" )
Worth a try: Save the file as "compacted", export all data to .MER files, then import back into a Clone
> I attempted to complete delete those tables and their TOs in my file and that still does not fix the issue
Removing and recreating had no effect. same symptoms.
ah ha! searching "changed" produced the following
Item count changed from 62 to 63 in: library catalog 'User'
Rebuilding library catalog 'User' order list: quick reference
Rebuilding library catalog 'User' order list: type
Recovering: library catalog
Item count changed from 64 to 65 in: library catalog
Rebuilding library catalog order list: quick reference
Rebuilding library catalog order list: type
the second one is strange because its not identifying a table, I wonder if it thinks there is a blank table.
I am going to run a fresh recovery log of my current file and see if i get the same errors. will email shortly. thanks so so much for your responses.
Since you are up to FM 15, it might pay to call Tech Support
They may not fix your file, but any clarification you get would help the rest of us
"Libraries" contain the items stored in container fields such as graphics, or Word documents. There is also a Library that contains any graphics stored on layouts ( and even graphics no longer in use )
"Catalogs" are internal lists of things, layouts, field ID's, etc. If a Catalog gets scrambled, all bets are off
If Recover did "fix" the Catalog, for two libraries, that could make a difference
> Recovering: library catalog
Sorry I am not positive what you mean by deployment. I assume it means making sure my server machine is set up correctly. power failover as well as the right versions of java and the like?
It's the "set up correctly" that needs to be scrutinized. Things like indexing, OS-level file sharing, AV and external backup software,... basically anything that could touch the FM files directly where it should not.
Starting and stopping procedures, FMS auto-hosting settings, event log monitoring to get early warnings,...
There are plenty of "Help" articles on Server Setup
But first, you need to get your file working
Corruption is fickle, and can happen even with the best of practices
> I am not positive what you mean by deployment