RMS Integration Problem

(0) Share

Report

Posted on by Scott Emick

280

I'm trying to link a company to RMS. We are using GP 10 SP 3. I create the linked server which works fine - I can run queries to it using the 4 part naming and get results. Then I go into GP and click on RMS Server Integration setup and I get the following error: a get/change first operation on table 'RMSLinkedServerInfo' cannot find the table.

I googled the RMSLinkedServerInfo and only get 2 results, none of which told me much of anything. I looked in the company database and Dynamics database and don't see a table or view there by that name.

Any ideas or help would greatly be appreciated.

Thanks,

Scott Emick
SQL DBA - Programmer - Dynamics GP - Dynamics RMS

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

nChannel 370 on at

Like (0)

Report

Re: RMS Integration Problem

Hi Scott,

You may be interested in our solution that helps easily integrate RMS and GP. Our connector for RMS starts copying your customer, item, sales and supplier data to the nchannel platform which you can use to begin exchanging data between Microsoft Dynamics RMS and GP.

We'd be happy to go over any questions you may have. Here is a bit more about our RMS connector: www.nchannel.com/connect-microsoft-dynamics-rms-2

Feel free to contact us at any time with any questions you may have.

Thanks,

Darren

nChannel

1-800-406-8217

info@nchannel.com
Scott Emick 280 on at

Like (0)

Report

Re: RMS Integration Problem

Under more info I get the following:

[Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'WINDY.dbo.zDP_RMS00100F_1'.

[Microsoft][SQL Native Client][SQL Server]Invalid object name 'WINDY.dbo.RMS00100'.

It looks like I'm going to have to run the database utilties to recreate those.