Upgrade Sage 2014 to 2018 ERROR FireDAC

Installed 2018 on server 2012. 

Migrating from Server 2008 Timeslips version 14. 

- Backed up data

- Copied back up file to new server

- Start 2018 on new server - Restored Database. 

Any ideas?

.....................

Converting TAL Pro Client and Customer table
Converting TAL Pro Slips From Bills PT table
Converting TAL Pro Slips from Pymnts, Chks & Bills table
Converting Alert Rule table
Converting Alert table
Converting Slip Template table
Slip Template Records 3..4255

ERROR


Class: EIBNativeException
[FireDAC][Phys][IB]Dynamic SQL Error
SQL error code = -303
arithmetic exception, numeric overflow, or string truncation
string right truncation

  • 0

    It is unusual to have an error during conversion, but not completely unheard of. I have no idea why it is kicking that error or how to fix it. 

    Interesting that you are just now installing v2018 as Sage stopped selling it almost 9 months ago. Stuff happens, not judging.  Just wondering about (as Paul Harvey would say) "the rest of the story."

    You will be converting the database from a v2014 BDE database to a v2018 Firebird database.  

    During the conversion it will step your data through each version since v2014.  So, 2015, 2016, 2017 then 2018.

    As a general rule, I like to run all my client conversions inhouse for exactly this reason.  I.e. it lets me chase any problem without disturbing what they may have in place at the office before any rollout.

    I like to run some diagnostics on the old version, and a few reports, then step it up only a few versions at a time, checking my reports along the way.

    You should be able to tell from the log file which version it is try to move from when it hits the error.

    Nancy Duhon, Esq.
    Duhon Technology Solutions, LLC
    Master Certified Consultant for Sage Timeslips
    Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions.
    404-325-9779
    [email protected]

  • 0 in reply to Nancy Duhon

    How does one obtain other copies of TImeslips to install and run 1 at a time conversions. 

  • 0 in reply to GreenpointSolutions

    Well, the short answer is that you don't.  1) they are no longer available for sale, and 2) even if they were it would still be more cost effective to just pay someone who already has them to convert it for you.

    Does your customer have a tech support agreement with Sage? If so, I'd contact them first since they are already paying for that. 

    If not, you would be looking at either getting a tech support agreement with Sage, or hiring one of the Certified Consultants that frequent this board (yes, that includes myself.)

    Nancy Duhon, Esq.
    Duhon Technology Solutions, LLC
    Master Certified Consultant for Sage Timeslips
    Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions.
    404-325-9779
    [email protected]

  • 0 in reply to Nancy Duhon

    Thank you. I believe I found the issues. The slip templates have Special characters in their name. It seems like 2017+ no longer allow special characters. 

    So I have to go through and delete or update the slips templates before converting. 

  • 0 in reply to GreenpointSolutions

    Excellent. That sounds highly likely to be the issue. 

    Does your customer use the slip templates?  Most of our users do not, so am intrigued.

    Nancy Duhon, Esq.
    Duhon Technology Solutions, LLC
    Master Certified Consultant for Sage Timeslips
    Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions.
    404-325-9779
    [email protected]

  • 0 in reply to Nancy Duhon

    Apparently many do use the templates. We have over 4000 of them. Now I need to figure out the best way to remove the special characters from the templates. 

  • 0 in reply to GreenpointSolutions

    @GreenpointSolutions.  In my 25 years as a Timeslips Consultant, I have ONE client that uses slip templates as part of their non-profit fundraising business where they create lots of entries, but are not really interested in the descriptions, so they use the templates with the Timesheet feature.  

    It works well for them, but yes, it does lead to LOTS of templates for that one business.

    Nancy Duhon, Esq.

    Duhon Technology Solutions, LLC

    Master Certified Consultant for Sage Timeslips

    Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions.

    404-325-9779

    [email protected] 

  • 0 in reply to Nancy Duhon

    Nancy,

     How much for a copy of 2016 so I can try to upgrade to 2016 from 2014. Or how much for you to take the backup database and see if you can convert it to 2018? or 17?

  • 0 in reply to GreenpointSolutions

    If you would like to make the backup available.  I'd be happy to take a look and see if I can get it converted.  I can look at it later today.

    Nancy Duhon, Esq.
    Duhon Technology Solutions, LLC
    Master Certified Consultant for Sage Timeslips
    Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions.
    404-325-9779
    [email protected]