Skip to main content
Answer

unknown column error on project dashboard

  • June 24, 2024
  • 4 replies
  • 78 views
iqraharrison
Captain II
Forum|alt.badge.img+8

Hi!

looking at the project dashboard in the sales demo, I am getting this error when switching between projects.  I have a feeling this is in regards to a table but I am not sure.  Has anyone seen this and been able to resolve?

 

Best answer by iqraharrison

@Chris Hackett hi! i ended up submitting a ticket to acumatica.  we found that MySQL was causing issues.  I worked with our internal IT department to set up the local and cloud hosted instances with the MS SQL and we no longer had any issues!  We also noticed an increase in the instance’s speed!

I provided acumatica with all the details and they escalated it to the development to look into, however, we were able to close the case since our issue was resolved by changing the database type

thanks!

Iqra ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*. Proud Acumatica MVP (2024, 2025) - See my journey here: https://community.acumatica.com/community-site-discussions-150/iqra-harrison-acumatica-mvp-2025-28977

4 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11

Hi @iqraharrison 

I tried with version 2023.R1 and it works well.

 

 

Best Regards,

NNT

I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
iqraharrison
Chris Hackett
iqraharrison
Captain II
Forum|alt.badge.img+8
  • iqraharrison
  • Author
  • Captain II
  • June 26, 2024

@nhatnghetinh hi! this is happening in 24R1 build 4 and 5 (at least that’s where i’ve tested it) but I just met with acumatica to discuss this and it seems to be working on the version 24.100

Iqra ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*. Proud Acumatica MVP (2024, 2025) - See my journey here: https://community.acumatica.com/community-site-discussions-150/iqra-harrison-acumatica-mvp-2025-28977
Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • July 31, 2024

Hi @iqraharrison were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
iqraharrison
Captain II
Forum|alt.badge.img+8
  • iqraharrison
  • Author
  • Captain II
  • Answer
  • August 1, 2024

@Chris Hackett hi! i ended up submitting a ticket to acumatica.  we found that MySQL was causing issues.  I worked with our internal IT department to set up the local and cloud hosted instances with the MS SQL and we no longer had any issues!  We also noticed an increase in the instance’s speed!

I provided acumatica with all the details and they escalated it to the development to look into, however, we were able to close the case since our issue was resolved by changing the database type

thanks!

Iqra ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*. Proud Acumatica MVP (2024, 2025) - See my journey here: https://community.acumatica.com/community-site-discussions-150/iqra-harrison-acumatica-mvp-2025-28977
Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
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