Skip to main content

Is it safe to Drop table or Change data type of some column in Tables Starting ‘AM’? because I notice some of NoteID Column has Int data type. it is supposed to be Uniqueidentifier. it causes error on my upgrade from Acumatica 2020 R1 to Acumatica 2021 R1

 

Hi @psletuana1  Is there any data available under the NOTEID column?


Some tables with NoteID (Int,not null) has no data and some has data. I’m planning to change the data type of columns with data to uniqueidenifier. We already tried it on our test server and it work and the dropped tables was automatically recreated during the upgrade but I don’t know if it safe to drop column with empty data.


@psletuana1 , I would say it is not safe nad upgrade might result in data corruption or loss. If you have a support contract, suggest to contact Acumatica support.  Anyway, please make sure to take the backup before upgrade


Reply