Polling Notifications [ART.116.3038] and [ADA.1.316] when tr

, ,
1

Hi,

I have ceated a basic update notifiaction (no when clause), however when I try to enable it I get:
[ART.116.3038] Adapter Runtime (Notification): Error in Notification Callback:enableCallback notification SMB002_Hr.DB:updateNewEmployee.
[ADA.1.316] Cannot execute the SQL statement “CREATE TRIGGER WMTba4mnmh ON dbo.t_Kand_Alg for update as if begin INSERT INTO e_Select.WMBba4mnmh (KAND_ID) SELECT inserted.KAND_ID FROM inserted end”. "
(HY000/156) [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Incorrect syntax near the keyword ‘begin’."
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Incorrect syntax near the keyword ‘begin’.

Seems as if the generated script for the tigger is malformed.
Does anyone knows what is happening ?

2

Problem solved, I forgot to define te notify on update on a column.

3

When enabling polling, I am getting the following error message:
[ART.116.3038] Adapter Runtime (Notification): Error in Notification Callback:enableCallback notification Horizon.notifiers:F0101UpdateNotify.[ADA.1.316] Cannot execute the SQL statement “INSERT INTO TESTDTA.WMSbb5ujkv VALUES( ‘WMBbb5ujkv’, 1)”. “(55019/-7008) [SQL7008] WMSBB5UJKV in TESTDTA not valid for operation.”[SQL7008] WMSBB5UJKV in TESTDTA not valid for operation.

Can you give me suggestion on this regarding.

4

Hi,

We encounter the following error when we try to enable an insert/delete notification.