I encountered this error exporting a table in text format using navision 4.0
(as I wrote in the object)
the table is 12181 (italian object) and there are only 2 personalized lines(developed by another company). even if I delete this modify the error appears.
Why this error appears?
thanks for the help
-Mirko-
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog0
Answers
Did you try to recompile it?
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
However, if it is not causing a problem for Kriki, I can only suggest that somehow the object in the database table "Object" has become corrupted in its binary form or there is something in the code that is sending the client haywire.
Obviously, I do not have access to this object so cannot check it myself, but have you tried to note what the changes are and where they happen. Then, open a Cronus database and export its version of the object as a FOB file. Import this into your DB to replace what is already there. Then add whatever changes you noted down and try to recompile it, then export it as text.
PS. Which service pack of v4 are you using? Have you tried it with SP3, it could be a bug in the client.
i have already tried to do everything you say (except use 4.3 version)but without results...the only thing i can think(as you say)is data corruption...
aah...the disadvantages in stealing a customers... #-o
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
:shock: why would it be a problem for me :shock:
I would try with 4.00SP3.
Or if that doesn't work, create a copy of the DB. In that copy, put the original object and put the changes manually.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
I try to export some objects in txt format (all compiled) and get this error message - using 4.0, no SP.
I know this issue is set as [SOLVED] but I found the cause of this error and a simpler fix to rather than just re-do'ing the whole object.
For some reason the Key seems to have become corrupt.
If you delete and re-add the key, it seems to be able to export successfully afterwards.
It does not occure if you disable the clustered property on all keys of the table in the 5.0 client.
Does this tell somebody how to fix the problem without deleting and recreating the key?
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
After I created a second key and deleted the primary key, I could export my table in text format.
After that, I created the origin primary key as secondary key and deleted the primary key.
I still can export the table in text format.
Many thanks to raven44!
Microsoft Dynamics NAV Developer since 1997
MSDynamics.de - German Microsoft Dynamics Community - member of [clip]
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
I encountered this in a 4.0 client (no SP) and using 3.6 objects.
Never seen this before, or had problems exporting from this database in the past - it's our DEV server 8-[
With thanks
David
The trick with the primay key works.
Cause ... ? I suspect that it happened a few months ago when importing the object as a .txt.
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
At some point in time, MS added the "Clustered" property to the database keys. These versions check the keys of a table object to see whether the property is set for at least one key, and if not, it is set for the primary key automatically.
If you transfer this object to an older system as a fob, that property is still there, but the system does not know what it is and ignores it. Since it does not know it, there is also no UI to modify or delete it.
When you try to export that object in that older client to text, the system is no longer able to ignore it (without modifying the object in case you reimport the text version) and displays the error.
When you detele the key with the Clustered property set, the property is deleted along with it. If you recreate the key in that older client the problem is gone.
As I wrote before, another way to avoid he problem is to clear the Clustered property on all keys on the later client before you create the fob for transfer to an earlier client.
And the moral of the story: Do not transfer objects to older versions! [-X