Event Service configuration cannot find primary key in database table

Comments

2 comments

  • Avatar
    GP000

    This is how my table is made:

    CREATE TABLE [XXXXXXXXXX].[SeparateShipmentWorkflow](
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [CreationDate] [date] NOT NULL,
    [MachineId] [int] NOT NULL,
    PRIMARY KEY CLUSTERED
    (
    [Id] 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

    0
    Comment actions Permalink
  • Hi,

    there is a bug in AgilePoint for event listeners, that Agilepoint at this place doesn't recognize any other shema besides of dbo. Could you please move the table to dbo schema and try again?

    Regards,

    Alexey

    0
    Comment actions Permalink

Please sign in to leave a comment.