Client Service Center

Launch error after migration from Sage Abra Suite HR (Fox Pro) to Sage HRMS (SQL)
Published on by CS3 Technology in Blog Posts

 

So, you’ve decided to bite the bullet and upgrade from Fox Pro to SQL. With CS3’s assistance, you’ve installed Sage HRMS on the server and run the Upsize Wizard. Your next step is installing the Sage HRMS Client so you can start training and navigating this wonderful new version.

 

Unfortunately, once the Client install is complete and you launch it, you get this error:

 

lisaerror1

 

What does it mean and how do you fix it? There were products available with your Abra Suite that the SQL version tries to place on your Quick Launch toolbar. These no longer exist so you will get these errors trying to launch Sage HRMS. To find and remove them, open up SQL Management Studio, click on the New Query button and type in the following query (or copy and paste from here):

 

Select * from SageHRMS_Live.dbo.sbarcust where s_app not in (select s_app from SageHRMS_Sample.dbo.sbarcust)

 

This query will return the rows that do not exist in the HRMS Sample company.

 

lisaerror2

 

You can then modify this query slightly and remove those items:

Delete SageHRMS_Live.dbo.sbarcust where s_app not in

(select s_app from SageHRMS_Sample.dbo.sbarcust)

Unless you modify your Abra Quick Launch toolbar, you will need to perform these steps each time you rerun the Upsize Wizard.

(877) 496-1600

Logo for CS3 Technology.

Pages

Software

Resources

Contact

This website is owned by CS3 Technology. CS3 Technology is independent from Sage and is not authorized to make any statement, representation, or warranties or grant any license or permission on behalf of Sage regarding any product, service, or website content. Certain materials made available on or through this website are owned by Sage and cannot be used without the prior written permission of Sage.