Good morning Mibuso. I'm working with 2009 for the first time (6.0) and all I'm trying to do is create a new database and then restore a backup into it. Here is what I've done:
1. Created a new database 200MB in size
2. Use the restore tool (I have a partner license) to select my .fbk file
3. There is only one company in the backup, and I've selected both data and application objects to be restored
It runs almost all the way through before the problem. The error I'm getting is this:
"The field property must be '65'.
Property: DataLength
Field: ID
Table: Windows Login" (bold only to emphasize new lines in the error message)
If I remember correctly, the last time I got this error was because of a difference between the property in the backup and the database I created. This is just a new database, and I've verified that this field length IS 65 in my database, which indicates to me that I've got a backup where the field length in that table is NOT 65 (or maybe even greater). Where I'm confused is that this table is in the 2 billion range, which I didn't think could be modified by anyone. Any thoughts?
Sorry if this is a stupid question from a 2009 newbie, but I promise I searched on it first
As always, I thank you all in advance for your help.
Answers
Are you sure its a new database? If its new, how are you able to see objects.
Also why aren't you selecting data common to all companies?
I am selecting data common to all companies, but there is only one company in the backup in question... sorry I was a bit vague on that one.
"Show All..."
"Oh..."
"Show All..."
"Oh..."
Why don't you export the table from your new database, back into the old one. Then recreate the backup and see if that will restore.
"Show All..."
"Oh..."
Then I think you need to restore it into an older set of executables. Check what the field lengths were in 2009, in 2009sp1 they are different, but I don;t know when they changed.
Thanks for all your help and hopefully we'll have an answer soon.
"Show All..."
"Oh..."
Hang on... back up a bit...
Are you trying to restore a NAV2009sp1 Backup into a database with NAV2009 executables?
I think I tried that once and got an error about the field size of the windows login table....
:shock:
t
"Show All..."
"Oh..."
Yeah but answer the question.
Are you trying to restore a newer backup into older executables?
or
Where did you get the backup from?
"Show All..."
"Oh..."
Peter
- Open an existing database doesn't matter what version
- Open object designer choose File -> Import and point it to the fbk file.
Then it will read the objects in the fbk file and you can see what versions they are from in the import window.
Opps it was a second page...so my suggestion was already posted sorry
NAV Freelance Consultant
Awesome tip on using the .fbk as an import to see the version though, thank you, I will definitely remember that!
Thank you to everyone!
"Show All..."
"Oh..."
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!