Event Service configuration cannot find primary key in database table

Follow

GP000

• February 21, 2020 12:47

Hello,

 

When creating an Event Service trigger of type Database Insert, I select a table in which I'm absolutely certain there's a non-nullable primary key. The Primary Key drop-down menu doesn't offer any column, not even the Primary Key column. This prevents me from creating the event service.

 

How can I specify my primary key to AgilePoint?

Thank you,

G. Perreault

0

• 

  GP000

  • February 21, 2020 12:54

  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
• 

  sysberry GmbH

  • February 21, 2020 15:20

  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.