Event Service configuration cannot find primary key in database table

フォローする

GP000

• 2020年02月21日 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

  • 2020年02月21日 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

  コメントアクション パーマリンク
• 

  sysberry GmbH

  • 2020年02月21日 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

  コメントアクション パーマリンク

サインインしてコメントを残してください。