Rename Table in NAV 2013 R2

tedl30 · 2013-12-12

Hy I have one problem with rename table in NAV 2013 R2, build 35796 (latest build)

Follow Steps:

1. Make Table on range 50000 Test with one field
2. Rename table Test to Test1
3. I go to Designer table (Test1) and Save As with name Test in ID 50001
4. Run NAV and i get SQL error

Is anyone have similiar error?

ara3n · 2013-12-12

i followed your steps and had no error. try and restart your service tier.

mohana_cse06 · 2013-12-13

Yes, try to restart your service or compile both objects or all objects..

tedl30 · 2013-12-13

Hm, can you try this.

1. Create table test on range 50000 or similiar range.
2. Compile object 50000
3. DON'T RUN NAVISION
4. go to the SQL and execute statement like this. select * from [CRONUS International Ltd_$test]

have a nice day

dete · 2013-12-13

First example is only for illustration of problem that we experienced with fob or text import when objects and fields have been renamed.

1. Make Table on range 50000 Test with one field
2. Rename table Test to Test1
3. I go to Designer table (Test1) and Save As with name Test in ID 50001
4. Run table Test (ID 50001) from developer enviroment

Best Regards

thegunzo · 2013-12-13

The server side object metadata does not work well with the rename feature.
You will need to rebuild server side objects for all object that you rename.

tedl30 · 2013-12-13

thegunzo wrote:

The server side object metadata does not work well with the rename feature.
You will need to rebuild server side objects for all object that you rename.

Is this a little bug in NAV 2013 R2
"The server side object metadata does not work well with the rename feature."

thegunzo · 2013-12-16

@tedl30

rename object has had this problem since we got the three tier solution in NAV 2009.

girishkokney1122 · 2014-06-02

Build server side Objects solves this problem ? I have got the same error, tried build server side objects but no Luck

Rename Table in NAV 2013 R2

Comments

Categories