x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 15 subscribers
  • Views 606 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
4
replies
General Discussion
1k
topics
2k
replies
murni

Error creating new company after upgrade from version 2017 to version 2019

SUGGESTED
Posted By

Hi all,

after upgrading from sage 2017 to 2019, I have problem creating new company as in image below. What could be the problem and how to solve it? Thank you.

  • 0

    The InsertSYSCurrency.sql script creates the basic GBP, EUR and USD currencies with ID's 1,2,3. So if this script is failing, it's most likely that the SYSCurrency table already has these entries, or the SYSCurrencyISOCode table hasn't been populated.

    When this sort if thing happens, put a trace on the SQL Server using either SQL Profiler, Express Profiler  or similar. Invaluable for seeing what's going on behind the scenes.

  • 0 in reply to Geoff Turner
    SUGGESTED

    Response from Sage 200 Technical Support – with our apologies for not replying to this post sooner.

    Thank you for logging this Sage City post.

    Error creating new company after upgrade from version 2017 to version 2019

    Sage 200 System Administration

    Failed to run SQL script ‘InsertSYSCurrency’ against company dataset ‘FFLS’.

    Please retry the operation and if the problem persists contact your support provider.

    This is not a known issue from previous cases, but the suggestion from the other member would be useful to investigate.
    If your SQL trace does not reveal anything, please log this with the accredited Sage Business Partner.

     

    Kind regards

     

    Sage 200 Technical Support

*Community Hub is the new name for Sage City