web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Error code 85132273 during upgrade from 2009 to 2013R2

(0) ShareShare
ReportReport
Posted on by 450

I'm following the upgrade document (msdn.microsoft.com/.../dn271668(v=nav.71).aspx) and has come to the part where I need to compile the system tables in the 2013R2-database after the database-conversions. I did use the latest builds (2013 build 36605) and (2013 R2 build 36703)

All but four tables is accepted, but the 'Page Data Personalization', 'User', 'User Property' and 'Device'-tables all give "Error code: 85132273" when i try to save their design.

When I look in the database the 'User' table is missing the 'Authentication Email' field, and the 'User Property'-table is missing the add 'Authentication Object ID' field...

I have searched for hours but neither the error code or is hex-counterpart '51303F1' is nowhere to be found (and if '85132273 ' was hex that would give 2232623731 as decimal which is nowhere relevant to be found either)

I have enabled Debugging on the NST, but there are no errors in the EventLog either.

Is anyone in position to help me.

kind regards

*This post is locked for comments

I have the same question (0)
  • Daniele Rebussi Profile Picture
    2,480 on at

    Just one silly suggestion: did you try downloading the Cumulative Update 6 and checking these tables in it? Another user reported a problem of fields missing with the latest build, I think worth checking the previous CU released.

  • Duizy Profile Picture
    45 on at

    I'm having exactly the same problem and same error code. I'm upgrading from NAV2013CU5 to NAV2013R2CU7. After opening and converting the old database with the new finsql, I'm not able to get an allobjects.fob imported into this database. I then removed all the objects except the tables. I could export the table objects as text and remove all code/variables/procedures/properties etc. and import this table definition only object text file back into the database, but allas compiling is still not possible. Error code 85132273 is still on most tables. Restoring an fbk is not possible anymore. (I know of some SQL scripting to do that but it is not time yet for such a matter).

    At the moment I do not know what to do next.

  • Duizy Profile Picture
    45 on at

    I found a solution:

    1. Open database with old client and remove all objects except the tables

    2. Export all tables as text and use a tool which removes everything from the table object file except tablename, fieldnames+type+Length, a so calles Table definition only file.

    3. Import the table definition only file and compile all tables

    4. Open database with new client and convert database as asked

    5. Compile all objects again.

    You should now have a database which will accept the importing of an All_NAV2013R2CUx.fob.

  • StickyMan Profile Picture
    10 on at

    Hi Duizy,

    What tool are you referring too?

  • Duizy Profile Picture
    45 on at

    In this case my tool. A simple report that accepts a filename with only table objects and creates a new one.

    It's a bit old the code, but still works.

    Documentation()

    OnInitReport()

    OnPreReport()

    OnPostReport()

    IF NAVObjectFileName <> '' THEN BEGIN

     MergeFileReadMgt.Set(NAVObjectFileName,MAXSTRLEN(NAVObjectFileName));

     OutputFile.WRITEMODE := TRUE;

     OutputFile.TEXTMODE := TRUE;

     IF LOWERCASE(COPYSTR(NAVObjectFileName,STRLEN(NAVObjectFileName))) = '.txt' THEN

       NAVObjectFileName := COPYSTR(NAVObjectFileName,1, STRLEN(NAVObjectFileName) - 4);

     OutputFile.CREATE(NAVObjectFileName + 'CleanTable.txt');

     Windows.OPEN(Text003);

     WHILE NOT MergeFileReadMgt.EndOfFile DO BEGIN

       MergeFileReadMgt.RUN;

       MergeFileReadMgt.GetLine(TextLine);

       Windows.UPDATE(2,TextLine);

       IF COPYSTR(TextLine,1,6) = 'OBJECT' THEN BEGIN

         EndObject;

         TableObjectFound := COPYSTR(TextLine,1,12) = 'OBJECT Table';

         IF TableObjectFound THEN BEGIN

           Windows.UPDATE(1,TextLine);

           OutputFile.WRITE(TextLine);

           OutputFile.WRITE('{');

         END;

       END;

       IF TableObjectFound THEN BEGIN

         IF NOT ObjectPropertiesTagFound THEN

           ObjectPropertiesTagFound := COPYSTR(TextLine,1,19) = '  OBJECT-PROPERTIES';

         IF ObjectPropertiesTagFound THEN BEGIN

           OutputFile.WRITE(TextLine);

           IF COPYSTR(TextLine,1,3) = '  }' THEN

             ObjectPropertiesTagFound := FALSE;

         END;

         IF NOT PropertiesTagFound THEN

           PropertiesTagFound := COPYSTR(TextLine,1,12) = '  PROPERTIES'

         ELSE

           IF COPYSTR(TextLine,1,18) = '    DataPerCompany' THEN BEGIN

             OutputFile.WRITE('  PROPERTIES');

             OutputFile.WRITE('  {');

             OutputFile.WRITE(TextLine);

             OutputFile.WRITE('  }');

           END ELSE

             PropertiesTagFound := COPYSTR(TextLine,1,18) <> '  }';

         IF NOT KeyTagFound THEN BEGIN

           KeyTagFound := COPYSTR(TextLine,1,6) = '  KEYS';

           IF KeyTagFound THEN

             OutputFile.WRITE(TextLine);

         END ELSE

           IF COPYSTR(TextLine,1,5) = '  }' THEN BEGIN

             OutputFile.WRITE(TextLine);

             KeyTagFound := FALSE

           END ELSE

             OutputFile.WRITE(TextLine);

         IF NOT FieldsTagFound THEN BEGIN

           FieldsTagFound := COPYSTR(TextLine,1,8) = '  FIELDS';

           IF FieldsTagFound THEN BEGIN

             OutputFile.WRITE(TextLine);

             OutputFile.WRITE('  {');

           END;

         END;

         IF FieldsTagFound THEN

           CASE TRUE OF

             COPYSTR(TextLine,1,5) = '    {':

               BEGIN

                 TempTextLine := TextLine;

                 OutputTextLine := '';

                 OptionFieldFound := FALSE;

                 FieldType := '';

                 FieldProperty := '';

                 FieldPropertyDelimiterPosition := 0;

                 FOR FieldTagCounter := 1 TO 5  DO BEGIN

                   // { FieldNo;Enabled;FieldName;DataType

                   // OptionString

                   // FieldClass

                   // { 6   ;   ;Bill of Materials   ;Boolean       ;FieldClass=FlowField;

                   FieldTagDelimiterPosition := STRPOS(TempTextLine,';');

                   CASE FieldTagCounter OF

                     1: OutputTextLine := OutputTextLine + COPYSTR(TempTextLine,1,FieldTagDelimiterPosition); // Field No

                     2: OutputTextLine := OutputTextLine + COPYSTR(TempTextLine,1,FieldTagDelimiterPosition); // Enabled

                     3: OutputTextLine := OutputTextLine + COPYSTR(TempTextLine,1,FieldTagDelimiterPosition); // Field Name

                     4: // Data Type

                       IF FieldTagDelimiterPosition > 0 THEN BEGIN

                         FieldType := COPYSTR(TempTextLine,1,FieldTagDelimiterPosition - 1);

                         FieldType := DELCHR(FieldType,'>',' ');

                         OutputTextLine := OutputTextLine + COPYSTR(TempTextLine,1,FieldTagDelimiterPosition);

                       END ELSE

                         OutputTextLine := TextLine;

                     5: // Field Property

                       BEGIN

                         FieldPropertyDelimiterPosition := STRPOS(TempTextLine,'=');

                         IF FieldPropertyDelimiterPosition > 0 THEN BEGIN

                           FieldProperty := COPYSTR(TempTextLine,1,FieldPropertyDelimiterPosition - 1);

                           IF IsExtraFieldProperty(FieldProperty) THEN

                             OutputTextLine := TextLine;

                         END;

                       END;

                   END;

                   TempTextLine := COPYSTR(TempTextLine,FieldTagDelimiterPosition + 1);

                 END;

                 WriteLine(OutputTextLine,FALSE);

               END;

             COPYSTR(TextLine,1,3) = '  }':

               BEGIN

                 FieldsTagFound := FALSE;

                 OutputFile.WRITE(TextLine);

               END;

             ELSE BEGIN

               TempTextLine := COPYSTR(TextLine,52); // Start Field Property

               FieldPropertyDelimiterPosition := STRPOS(TempTextLine,'=');

               IF FieldPropertyDelimiterPosition > 0 THEN BEGIN

                 IF STRLEN(COPYSTR(TempTextLine,1,FieldPropertyDelimiterPosition - 1)) <= MAXSTRLEN(FieldProperty) THEN BEGIN

                   FieldProperty := COPYSTR(TempTextLine,1,FieldPropertyDelimiterPosition - 1);

                   IF IsExtraFieldProperty(FieldProperty) THEN BEGIN

                     OutputTextLine := TextLine;

                     WriteLine(OutputTextLine,TRUE);

                   END;

                 END;

               END;

             END;

           END;

       END;

     END;

     IF TableObjectFound THEN

       EndObject;

     Windows.CLOSE;

     OutputFile.CLOSE;

    END;

    LOCAL WriteLine(OutputTextLine : Text[1024];AddExtraProprty : Boolean)

    // Remove ; or } at the end

    OutputTextLine := DELCHR(OutputTextLine,'>',';}');

    OutputTextLine := OutputTextLine + '}';

    IF AddExtraProprty THEN BEGIN

     OutputFile.SEEK(OutputFile.POS - 3);

     OutputFile.WRITE(';');

    END;

    OutputFile.WRITE(OutputTextLine);

    LOCAL EndObject()

    IF OutputFile.POS > 0 THEN

     OutputFile.WRITE('}'); // End previous table object

    LOCAL IsExtraFieldProperty(FieldProperty : Text[30]) : Boolean

    EXIT(FieldProperty IN ['OptionString','FieldClass']);

  • Duizy Profile Picture
    45 on at

    The result of this text parsing is something like this. Just the least amount of object definition needed to keep the data but remove everything else that the compiler might get in trouble with.

    OBJECT Table 37 Sales Line

    {

     OBJECT-PROPERTIES

     {

       Date=;

       Time=;

       Version List=;

     }

     FIELDS

     {

       { 1   ;   ;Document Type       ;Option        ;

                                                      OptionString=Quote,Order,Invoice,Credit Memo,Blanket Order,Return Order }

       { 2   ;   ;Sell-to Customer No.;Code20        }

       { 3   ;   ;Document No.        ;Code20        }

       { 4   ;   ;Line No.            ;Integer       }

       { 5   ;   ;Type                ;Option        ;

                                                      OptionString=[ ,G/L Account,Item,Resource,Fixed Asset,Charge (Item)] }

       { 6   ;   ;No.                 ;Code20        }

       { 7   ;   ;Location Code       ;Code10        }

       { 8   ;   ;Posting Group       ;Code10        }

       { 10  ;   ;Shipment Date       ;Date          }

       { 11  ;   ;Description         ;Text50        }

       { 12  ;   ;Description 2       ;Text50        }

       { 13  ;   ;Unit of Measure     ;Text10        }

       { 15  ;   ;Quantity            ;Decimal       }

       { 16  ;   ;Outstanding Quantity;Decimal       }

       { 17  ;   ;Qty. to Invoice     ;Decimal       }

       { 18  ;   ;Qty. to Ship        ;Decimal       }

       { 22  ;   ;Unit Price          ;Decimal       }

       { 23  ;   ;Unit Cost (LCY)     ;Decimal       }

       { 25  ;   ;VAT %               ;Decimal       }

       { 27  ;   ;Line Discount %     ;Decimal       }

       { 28  ;   ;Line Discount Amount;Decimal       }

       { 29  ;   ;Amount              ;Decimal       }

       { 30  ;   ;Amount Including VAT;Decimal       }

       { 32  ;   ;Allow Invoice Disc. ;Boolean       }

       { 34  ;   ;Gross Weight        ;Decimal       }

       { 35  ;   ;Net Weight          ;Decimal       }

       { 36  ;   ;Units per Parcel    ;Decimal       }

       { 37  ;   ;Unit Volume         ;Decimal       }

       { 38  ;   ;Appl.-to Item Entry ;Integer       }

       { 40  ;   ;Shortcut Dimension 1 Code;Code20   }

       { 41  ;   ;Shortcut Dimension 2 Code;Code20   }

       { 42  ;   ;Customer Price Group;Code10        }

       { 45  ;   ;Job No.             ;Code20        }

       { 52  ;   ;Work Type Code      ;Code10        }

       { 57  ;   ;Outstanding Amount  ;Decimal       }

       { 58  ;   ;Qty. Shipped Not Invoiced;Decimal  }

       { 59  ;   ;Shipped Not Invoiced;Decimal       }

       { 60  ;   ;Quantity Shipped    ;Decimal       }

       { 61  ;   ;Quantity Invoiced   ;Decimal       }

       { 63  ;   ;Shipment No.        ;Code20        }

       { 64  ;   ;Shipment Line No.   ;Integer       }

       { 67  ;   ;Profit %            ;Decimal       }

       { 68  ;   ;Bill-to Customer No.;Code20        }

       { 69  ;   ;Inv. Discount Amount;Decimal       }

       { 71  ;   ;Purchase Order No.  ;Code20        }

       { 72  ;   ;Purch. Order Line No.;Integer      }

       { 73  ;   ;Drop Shipment       ;Boolean       }

       { 74  ;   ;Gen. Bus. Posting Group;Code10     }

       { 75  ;   ;Gen. Prod. Posting Group;Code10    }

       { 77  ;   ;VAT Calculation Type;Option        ;

                                                      OptionString=Normal VAT,Reverse Charge VAT,Full VAT,Sales Tax}

       { 78  ;   ;Transaction Type    ;Code10        }

       { 79  ;   ;Transport Method    ;Code10        }

       { 80  ;   ;Attached to Line No.;Integer       }

       { 81  ;   ;Exit Point          ;Code10        }

       { 82  ;   ;Area                ;Code10        }

       { 83  ;   ;Transaction Specification;Code10   }

       { 85  ;   ;Tax Area Code       ;Code20        }

       { 86  ;   ;Tax Liable          ;Boolean       }

       { 87  ;   ;Tax Group Code      ;Code10        }

       { 88  ;   ;VAT Clause Code     ;Code10        }

       { 89  ;   ;VAT Bus. Posting Group;Code10      }

       { 90  ;   ;VAT Prod. Posting Group;Code10     }

       { 91  ;   ;Currency Code       ;Code10        }

       { 92  ;   ;Outstanding Amount (LCY);Decimal   }

       { 93  ;   ;Shipped Not Invoiced (LCY);Decimal }

       { 95  ;   ;Reserved Quantity   ;Decimal       ;FieldClass=FlowField}

       { 96  ;   ;Reserve             ;Option        ;

                                                      OptionString=Never,Optional,Always }

       { 97  ;   ;Blanket Order No.   ;Code20        }

       { 98  ;   ;Blanket Order Line No.;Integer     }

       { 99  ;   ;VAT Base Amount     ;Decimal       }

       { 100 ;   ;Unit Cost           ;Decimal       }

       { 101 ;   ;System-Created Entry;Boolean       }

       { 103 ;   ;Line Amount         ;Decimal       }

       { 104 ;   ;VAT Difference      ;Decimal       }

       { 105 ;   ;Inv. Disc. Amount to Invoice;Decimal}

       { 106 ;   ;VAT Identifier      ;Code10        }

       { 107 ;   ;IC Partner Ref. Type;Option        ;

                                                      OptionString=[ ,G/L Account,Item,,,Charge (Item),Cross Reference,Common Item No.] }

       { 108 ;   ;IC Partner Reference;Code20        }

       { 109 ;   ;Prepayment %        ;Decimal       }

       { 110 ;   ;Prepmt. Line Amount ;Decimal       }

       { 111 ;   ;Prepmt. Amt. Inv.   ;Decimal       }

       { 112 ;   ;Prepmt. Amt. Incl. VAT;Decimal     }

       { 113 ;   ;Prepayment Amount   ;Decimal       }

       { 114 ;   ;Prepmt. VAT Base Amt.;Decimal      }

       { 115 ;   ;Prepayment VAT %    ;Decimal       }

       { 116 ;   ;Prepmt. VAT Calc. Type;Option      ;

                                                      OptionString=Normal VAT,Reverse Charge VAT,Full VAT,Sales Tax}

       { 117 ;   ;Prepayment VAT Identifier;Code10   }

       { 118 ;   ;Prepayment Tax Area Code;Code20    }

       { 119 ;   ;Prepayment Tax Liable;Boolean      }

       { 120 ;   ;Prepayment Tax Group Code;Code10   }

       { 121 ;   ;Prepmt Amt to Deduct;Decimal       }

       { 122 ;   ;Prepmt Amt Deducted ;Decimal       }

       { 123 ;   ;Prepayment Line     ;Boolean       }

       { 124 ;   ;Prepmt. Amount Inv. Incl. VAT;Decimal}

       { 129 ;   ;Prepmt. Amount Inv. (LCY);Decimal  }

       { 130 ;   ;IC Partner Code     ;Code20        }

       { 132 ;   ;Prepmt. VAT Amount Inv. (LCY);Decimal}

       { 135 ;   ;Prepayment VAT Difference;Decimal  }

       { 136 ;   ;Prepmt VAT Diff. to Deduct;Decimal }

       { 137 ;   ;Prepmt VAT Diff. Deducted;Decimal  }

       { 480 ;   ;Dimension Set ID    ;Integer       }

       { 900 ;   ;Qty. to Assemble to Order;Decimal  }

       { 901 ;   ;Qty. to Asm. to Order (Base);Decimal}

       { 902 ;   ;ATO Whse. Outstanding Qty.;Decimal ;FieldClass=FlowField}

       { 903 ;   ;ATO Whse. Outstd. Qty. (Base);Decimal;

                                                      FieldClass=FlowField}

       { 1001;   ;Job Task No.        ;Code20        }

       { 1002;   ;Job Contract Entry No.;Integer     }

       { 5402;   ;Variant Code        ;Code10        }

       { 5403;   ;Bin Code            ;Code20        }

       { 5404;   ;Qty. per Unit of Measure;Decimal   }

       { 5405;   ;Planned             ;Boolean       }

       { 5407;   ;Unit of Measure Code;Code10        }

       { 5415;   ;Quantity (Base)     ;Decimal       }

       { 5416;   ;Outstanding Qty. (Base);Decimal    }

       { 5417;   ;Qty. to Invoice (Base);Decimal     }

       { 5418;   ;Qty. to Ship (Base) ;Decimal       }

       { 5458;   ;Qty. Shipped Not Invd. (Base);Decimal}

       { 5460;   ;Qty. Shipped (Base) ;Decimal       }

       { 5461;   ;Qty. Invoiced (Base);Decimal       }

       { 5495;   ;Reserved Qty. (Base);Decimal       ;FieldClass=FlowField}

       { 5600;   ;FA Posting Date     ;Date          }

       { 5602;   ;Depreciation Book Code;Code10      }

       { 5605;   ;Depr. until FA Posting Date;Boolean}

       { 5612;   ;Duplicate in Depreciation Book;Code10}

       { 5613;   ;Use Duplication List;Boolean       }

       { 5700;   ;Responsibility Center;Code10       }

       { 5701;   ;Out-of-Stock Substitution;Boolean  }

       { 5702;   ;Substitution Available;Boolean     ;FieldClass=FlowField}

       { 5703;   ;Originally Ordered No.;Code20      }

       { 5704;   ;Originally Ordered Var. Code;Code10}

       { 5705;   ;Cross-Reference No. ;Code20        }

       { 5706;   ;Unit of Measure (Cross Ref.);Code10}

       { 5707;   ;Cross-Reference Type;Option        ;

                                                      OptionString=[ ,Customer,Vendor,Bar Code] }

       { 5708;   ;Cross-Reference Type No.;Code30    }

       { 5709;   ;Item Category Code  ;Code10        }

       { 5710;   ;Nonstock            ;Boolean       }

       { 5711;   ;Purchasing Code     ;Code10        }

       { 5712;   ;Product Group Code  ;Code10        }

       { 5713;   ;Special Order       ;Boolean       }

       { 5714;   ;Special Order Purchase No.;Code20  }

       { 5715;   ;Special Order Purch. Line No.;Integer}

       { 5749;   ;Whse. Outstanding Qty.;Decimal     ;FieldClass=FlowField}

       { 5750;   ;Whse. Outstanding Qty. (Base);Decimal;

                                                      FieldClass=FlowField}

       { 5752;   ;Completely Shipped  ;Boolean       }

       { 5790;   ;Requested Delivery Date;Date       }

       { 5791;   ;Promised Delivery Date;Date        }

       { 5792;   ;Shipping Time       ;DateFormula   }

       { 5793;   ;Outbound Whse. Handling Time;DateFormula}

       { 5794;   ;Planned Delivery Date;Date         }

       { 5795;   ;Planned Shipment Date;Date         }

       { 5796;   ;Shipping Agent Code ;Code10        }

       { 5797;   ;Shipping Agent Service Code;Code10 }

       { 5800;   ;Allow Item Charge Assignment;Boolean}

       { 5801;   ;Qty. to Assign      ;Decimal       ;FieldClass=FlowField}

       { 5802;   ;Qty. Assigned       ;Decimal       ;FieldClass=FlowField}

       { 5803;   ;Return Qty. to Receive;Decimal     }

       { 5804;   ;Return Qty. to Receive (Base);Decimal}

       { 5805;   ;Return Qty. Rcd. Not Invd.;Decimal }

       { 5806;   ;Ret. Qty. Rcd. Not Invd.(Base);Decimal}

       { 5807;   ;Return Rcd. Not Invd.;Decimal      }

       { 5808;   ;Return Rcd. Not Invd. (LCY);Decimal}

       { 5809;   ;Return Qty. Received;Decimal       }

       { 5810;   ;Return Qty. Received (Base);Decimal}

       { 5811;   ;Appl.-from Item Entry;Integer      }

       { 5909;   ;BOM Item No.        ;Code20        }

       { 6600;   ;Return Receipt No.  ;Code20        }

       { 6601;   ;Return Receipt Line No.;Integer    }

       { 6608;   ;Return Reason Code  ;Code10        }

       { 7001;   ;Allow Line Disc.    ;Boolean       }

       { 7002;   ;Customer Disc. Group;Code20        }

     }

     KEYS

     {

       {    ;Document Type,Document No.,Line No.     ;SumIndexFields=Amount,Amount Including VAT,Outstanding Amount,Shipped Not Invoiced,Outstanding Amount (LCY),Shipped Not Invoiced (LCY);

                                                      Clustered=Yes }

       {    ;Document No.,Line No.,Document Type      }

       {    ;Document Type,Type,No.,Variant Code,Drop Shipment,Location Code,Shipment Date;

                                                      SumIndexFields=Outstanding Qty. (Base);

                                                      SIFTLevelsToMaintain=[{Document Type,Type},

                                                                            {Document Type,Type,No.},

                                                                            {Document Type,Type,No.,Variant Code},

                                                                            {Document Type,Type,No.,Variant Code,Drop Shipment},

                                                                            {Document Type,Type,No.,Variant Code,Drop Shipment,Location Code},

                                                                            {Document Type,Type,No.,Variant Code,Drop Shipment,Location Code,Shipment Date:Year},

                                                                            {Document Type,Type,No.,Variant Code,Drop Shipment,Location Code,Shipment Date:Month},

                                                                            {Document Type,Type,No.,Variant Code,Drop Shipment,Location Code,Shipment Date:Day},

                                                                            {Document Type,Type,No.,Variant Code,Drop Shipment,Location Code,Shipment Date:Day,Document No.}] }

       {    ;Document Type,Bill-to Customer No.,Currency Code;

                                                      SumIndexFields=Outstanding Amount,Shipped Not Invoiced,Outstanding Amount (LCY),Shipped Not Invoiced (LCY),Return Rcd. Not Invd. (LCY) }

       { No ;Document Type,Type,No.,Variant Code,Drop Shipment,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Location Code,Shipment Date;

                                                      SumIndexFields=Outstanding Qty. (Base);

                                                      KeyGroups=Item(Dim) }

       { No ;Document Type,Bill-to Customer No.,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Currency Code;

                                                      SumIndexFields=Outstanding Amount,Shipped Not Invoiced,Outstanding Amount (LCY),Shipped Not Invoiced (LCY);

                                                      KeyGroups=Cust(Dim) }

       {    ;Document Type,Blanket Order No.,Blanket Order Line No.;

                                                      KeyGroups=SOP(Blank) }

       {    ;Document Type,Document No.,Location Code }

       {    ;Document Type,Shipment No.,Shipment Line No. }

       {    ;Type,No.,Variant Code,Drop Shipment,Location Code,Document Type,Shipment Date;

                                                      MaintainSQLIndex=No }

       {    ;Document Type,Sell-to Customer No.,Shipment No.;

                                                      SumIndexFields=Outstanding Amount (LCY) }

       {    ;Job Contract Entry No.                   }

       {    ;Document Type,Document No.,Qty. Shipped Not Invoiced }

       {    ;Document Type,Document No.,Type,No.      }

       {    ;Document Type,Return Receipt No.,Return Receipt Line No. }

       {    ;Document Type,Type,Drop Shipment,Sell-to Customer No.,Shipment Date }

     }

    }

  • StickyMan Profile Picture
    10 on at

    Thanks Duizy,

    Just to confirm that the reason for the "Error code 85132273" during my upgrade, was because the system tables were not compiled in Nav 2013 when I did the database upgrade to nav 2013 R2 that i did not execute the Sync-NAVTenant  cmdlet, however this tool would of my upgrade must easier.

    Here is also a link that I found to be very useful on line;

    blogs.msdn.com/.../upgrade-toolkit-for-upgrading-data-from-microsoft-dynamics-nav-2009-r2-and-microsoft-dynamics-nav-2009-sp1-to-microsoft-dynamics-nav-2013-r2.aspx

    Do you think that you could please e-mail me the object, it would save me a lot for the next upgrade that I start later in the week?

    Many Thanks,

    Pedro

  • Duizy Profile Picture
    45 on at

    Maybe solved in NAV2013R2 Cumulative Update 8:

    'Various errors when trying to import a large *.fob file with NAV 2013 R2'

  • Ashok Sundaram Profile Picture
    80 on at

    After Importing the objects, execute the powershell command 'Sync-NAVTenant' for the related Instance, and then compile your security tables. This should work.

  • VectorK Profile Picture
    25 on at

    In my case, (CU8) the error comes when importing CustomObjs.fob :(

    Any ideas?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans