Skip to main content
Solved

NoteID Datatype Acumatica 2020 R1

  • October 29, 2021
  • 3 replies
  • 291 views
P
Freshman I

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

 

Best answer by mvolshteyn

@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

View original
Did this topic help you find an answer to your question?

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • 3393 replies
  • October 29, 2021

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

Naveen B
P
Freshman I
  • psletuana1
  • Author
  • Freshman I
  • 1 reply
  • October 29, 2021

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.

mvolshteyn
Acumatica Moderator
Forum|alt.badge.img+3
  • mvolshteyn
  • Technical Account Manager in the ISV Team
  • 110 replies
  • Answer
  • October 29, 2021

@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

MarkV
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved