Error Renaming Company with LinkedObjects

Arseni
Arseni Member Posts: 9
edited 2011-10-31 in NAV/Navision Classic Client
Dear all,

I have a Dynamics NAV 2009 SP1 database with some tables with the LinkedObject property set to True.

We have differents companies and we want to rename one of these. When we are renaming this company we get the following error:

We have tried to delete the views of the current company and create the new views of the new company name before rename the company. We have tried to create the new views of the new company name before rename the company. But always appear this error.

How can I rename the company???

Thanks and best regards!
Arseni Hernandez

Answers

  • FDickschat
    FDickschat Member Posts: 380
    1) In SSMS: Use the built in function "Script view as -> CREATE to -> New Query Editor window" for all these views
    2) In SSMS: Delete the views from the DB
    3) In NAV: Export the table objects which are views and delete them from NAV
    4) In NAV: Increase Object cache to at least 100 MB and rename the company
    5) In SSMS: In the created scripts use "Find and Replace" to replace the old company name against the new one.
    6) In SSMS: Execute the scripts - the views are recreated
    7) In NAV: Import the saved objects
    Done
    Frank Dickschat
    FD Consulting
  • Arseni
    Arseni Member Posts: 9
    Thank you Frank,

    This is one way to rename a company, but I wanted to know if is possible to do without delete any object in Dynamics NAV.
    Is there any way to do it more automatically?

    Thanks and best reagrds,

    Arseni.
    Arseni Hernandez
  • FDickschat
    FDickschat Member Posts: 380
    Not that I know of.

    A colleague once developed a solution in NAV which could do all of the above: Store the SQL views in a table, drop the views and recreate them (correct with the new company names), save the NAV objects in a table, delete the objects and restore the objects. Only the rename needs to be done manually.

    Theoretically it is possible to program the company rename also but only MS knows why it takes ages to change the company name via code while it only takes 20 minutes when done manually. It must have something to do with the object cache:

    Rename of any 1 company in a 220GB DB (out of 10 companies):
    ...............................Manually............By Code
    Object Cache 32MB:....~8-9 hours........~8-9 hours
    Object Cache 100MB:...~20 minutes.......~8-9 hours
    Frank Dickschat
    FD Consulting
  • Arseni
    Arseni Member Posts: 9
    Thank you again Frank,

    I've done it manually and it works well.

    Thanks and best regards!
    Arseni Hernandez

Categories