Skip to content
+1-888-319-3663

COMMUNITY FORUM

Node builder error

gigtech asked 8 years ago
I am getting an error trying to add tables onto a new node.

Invalid Object Name 'Dynamics..SC9001'

Any hints? 
Lorren replied 8 years ago

I assume you have Smart Connect installed and previously set up at this point, but if not, you should do that first.

If you do have Smart Connect installed, try creating the SC9001 table with the definition below.

USE [DYNAMICS]

GO

/****** Object: Table [dbo].[SC9001] Script Date: 06/19/2013 11:08:35 ******/

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[SC9001](

[PRODID] [smallint] NOT NULL,

[Series_Number] [smallint] NOT NULL,

[TABLTECH] [char](79) NOT NULL,

[TBLPHYSNM] [char](51) NOT NULL,

[TABLDESC] [char](51) NOT NULL,

[DEX_ROW_ID] [int] IDENTITY(1,1) NOT NULL,

CONSTRAINT [PKSC9001] PRIMARY KEY NONCLUSTERED

(

[PRODID] ASC,

[Series_Number] ASC,

[TABLTECH] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF                                         

 


If you would like to submit an answer or comment, please sign in to the eOne portal.