adapter notification (inser) error [SQL0104] Token & ungültig. Gültige Token: ( TABLE

, ,
1

Hi at all,

I’m trying to create a adapter notification on a DB2 database.
When I click “enable” in the JDBC adapter suface under polling notification, I get this error:

             [ART.116.3038] Adapter Runtime (Notification): Error in Notification Callback:enableCallback notification apl.test2:adapter.

[ADA.1.316] Cannot execute the SQL statement “Unable to get metadata.”. "
(42601/-104) [SQL0104] Token & ungültig. Gültige Token: ( TABLE ."
[SQL0104] Token & ungültig. Gültige Token: ( TABLE .

Translation:
(42601/-104) [SQL0104] Token & is not valid. valid Token: ( TABLE ."
[SQL0104] Token & is not valid. validToken: ( TABLE .

I try this on an IS 8.2.2 with JDBC adapter 6.5 Fix 31.

I have an older IS installation with 8.2.1 and JDBC adapter 6.5 Fix 28.
There it runs well.

I tried to uninstall the fix 31 and reinstall fix28. I believe the reinstallition works, but I couldn’t enable the notification, too.

Have you any idea if there is a setting? Or what the reason could be?

Many thanks and regards

Heiko

2

Hi at all,

with following steps it works:

re-compiling the source table,
re-entering the other properties at the connection
re-selecting table and filds at the adapter notification
refreshing the adapter notification

Regards