Skip to main content
Solved

Licence Maintenance Key not Present in Dictionary

J
Varsity I
Forum|alt.badge.img

Hi,

 

I have an unusual error message on the license maintenance screen that I have spent several hours testing and trying to resolve. 

The error is appearing on 3 locally hosted sites on build 2022.114.203.2690.  I don’t believe that this is related to any customisations as it exists on a newly deployed site before any customisations are applied.

 

What is the error?

Immediately after applying the license key and revisiting the Licence Maintenance screen, I get:

 

 

followed by a locked up screen that you can’t do anything with:

 

The trace shows:

 

 

 

I have worked out that you can restore the system to an unlicensed state by going 1) delete * from Licensing and, then 2) repairing the website.  After reapplying the key the error appears again.

 

Aside from the above the sites function normally (for example you can access stock items, customers,...), but anything associated with a license doesn’t work (eg you also get the error on the user screen and can’t change permissions)

 

Any Ideas? I’m beginning to think there may be a bug in build 2022.114.203.2690.  

 

Thanks in advance for your help,

 

John

Best answer by JWS539

Hey,

 

Just an update on the above.  This issue has gone to the MYOB support team who have confirmed that they have been able to replicate the issue and that the Missing Key in Dictionary error is actually a bug in the build we are using.

 

Also @emelda71 has provided the workaround she used to solve the MySQL collation issue (thanks!)

So, at the moment it seems we will just need to wait for MYOB support to fix the bug.

 

 

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

5 replies

J
Varsity I
Forum|alt.badge.img
  • JWS539
  • Author
  • Varsity I
  • 71 replies
  • April 20, 2023

Further to the above, I have applied the same licence key to an earlier build (2021.213.200.8950).  The licence key works fine here.

This implies that the issue is not related to the licence key but something about build 2022.114.203.2690?

 

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • 2754 replies
  • June 7, 2023

Hi @JWS539 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*.
J
Varsity I
Forum|alt.badge.img
  • JWS539
  • Author
  • Varsity I
  • 71 replies
  • June 8, 2023

Hi Chris,

 

Thanks for following up - really appreciate it 😀. 

 

This issue isn’t resolved and is a becoming a bit of a major for us.  We have 4 clients that we can’t properly service because, since they upgraded to 2022,  we are so far unable to set up local dev environments with data from a recent snapshot.  We have multiple support requests in with MYOB (the Australasian brand of Acumatica) but not much feedback or solutions at all.

Over the last 4 weeks, since the initial post, we have learnt more from our own trial and error (aka clutching at straws) testing  which we have spent 30+ working hours on.  The below details what we have tried and learnt since the initial post.

 

SQL Server

The issue seems to be confined to local instances deployed over SQL Server. 

  • We can do an install without data and the problem isn’t there.  As soon as you add data  (be it test data as part of the install, or imported from a snapshot post install), the installation cooks itself and you can’t do anything related to a license (user security, unable screens via CS10000,...).  This is on instances without any customizations applied.

 

 

  • We have tried deploying to three separate machines to try and rule out an environment issue on an individual PC.  All of these machines work fine on 2021 builds but have the exact same issue on 2022

 

  • We have tried a variety of License Keys and have requested new ones from MYOB support just in case it’s license key related.

MYSQL

We have also run some testing on MySQL.  However mySQL is relatively new to us and we’ve been experiencing some unwanted learning and development pain (we strongly to prefer to develop on SQL Server as that is what we know, and are only resorting to MySQL due to no solution to 1 above and the fact that our clients patience is running thin).  

  • When we deploy on MySQL we don’t seem to have this issue, but we have different ones 

 

  • On mySQL we get 2 install errors due to collation issues that initially we chose to ignore rather than resolve.

 

  • Subsequent development on MySQL hasn’t gone that well.  Simple customised DAC’s seem to be created with incompatable types (both C# and BQL), and we get cast conversion errors .  I suspect that this is related to the collation errors we chose to ignore, but am not 100% sure.  The developer training is based on on SQL Server, so there may be a few tricks on MySQL we don’t know about?  We have subsequently abandoned the idea of doing any further development on MySQL until we have worked out what is causing this.

 

  • We have started researching how to solve the collation issues in MySQL.  Found the following link where someone else had the same issue 

    However, this post doesn’t provide the solution, just that Acumatica support provided a workaround, but not what the work around actually was.  I understand how collation works on SQL server, would assume it is similar in MySQL, but haven’t worked out how to resolve the install errors as of yet.  I also don’t actually know if resolving the install errors will solve the cast conversion/incompatible type problem.  Being new to MySQL there might be something unrelated causing this.

 

So overall we’re not having a fun time and are more than slightly frustrated.  We were tracking along completely fine until our clients started upgrading to 2022. We need to get back into that space.

 

Thanks for any and all help, and thanks for being proactive!

John.

 

PS: The Acumatica dev forum is a great learning resource.  Have been reading the articles looking to pay it forward and help someone out on a problem I actually know the answer to.

 

 

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
J
Varsity I
Forum|alt.badge.img
  • JWS539
  • Author
  • Varsity I
  • 71 replies
  • Answer
  • June 19, 2023

Hey,

 

Just an update on the above.  This issue has gone to the MYOB support team who have confirmed that they have been able to replicate the issue and that the Missing Key in Dictionary error is actually a bug in the build we are using.

 

Also @emelda71 has provided the workaround she used to solve the MySQL collation issue (thanks!)

So, at the moment it seems we will just need to wait for MYOB support to fix the bug.

 

 

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • 2754 replies
  • June 19, 2023

Thank you for sharing the update with the community @JWS539 !

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*.

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