Skip to main content
Solved

unknown column error on project dashboard

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!

View original
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
Did this topic help you find an answer to your question?

4 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • nhatnghetinh
  • Captain II
  • 532 replies
  • June 25, 2024

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/truongpham80
iqraharrison
Chris Hackett
2 people like this
  • iqraharrison
    iqraharrison
  • Chris Hackett
    Chris Hackett
iqraharrison
Captain II
Forum|alt.badge.img+8
  • iqraharrison
  • Author
  • Captain II
  • 561 replies
  • 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
1 person likes this
  • Chris Hackett
    Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • 2759 replies
  • 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
  • 561 replies
  • 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
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