SmartConnect GP Tables Missing
Smartconnect installation went well. I'm getting an error while trying to add GP Real time Data Source Invalid object name 'DYNAMICS.dbo.SC9000'. I realized the tables are not showing up in DYNAMICS. I ran the process for resource cache. It didn't work.
Can you expand on what you mean when you say it didn't work? The resource cache never completed? Or it completed but didn't create the SC9000 table?
I get the message maintenance completed but it fails to create any table
any luck on this one?
The second is the Resource Cache that is run from inside of GP that has the SmartConnect dictionary installed on it.
For the first process, you want to ensure you are logged into SmartConnect as an admin and have setup a user in the GP Connector with power user rights (like sa). When logging into GP for the second process you also want to use the sa account.
This will ensure those processes are running under an account with enough rights to create any missing objects.
I’m getting this same error.
On System Maintenance in SmartConnect interface I get this error: Error: Microsoft Dynamics Gp- An error occurred while Re-Registering ‘Real Time Event’ ‘Update’ for ‘Connector ‘SmartConnect Dynamics GP Connector”: Invalid object name ‘SC9400’.
In GP in the Create GP Resource Cache, I get this error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name ‘DYNAMICS.dbo.SC9000’.
Any ideas on what to try?
[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name ‘DYNAMICS.dbo.SLB10000’.
Next the cache didn’t work and throw these error
[Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure ‘DYNAMICS.dbo.zDP_EXT90101L_1’.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name ‘DYNAMICS.dbo.EXT90101’.
If you would like to submit an answer or comment, please sign in to the eOne portal.