Rename Table in NAV 2013 R2

tedl30

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

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

mohana_cse06

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

tedl30

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

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

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

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

@tedl30

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

girishkokney1122

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