You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When setting up a basic IB Monitor (1 database, only default monitoring), there is a SQL syntax error in the resulting monitoring SQL. The SQL is missing single quotes inside the parentheses for NOT IN ().
Example SQL Error:
Select/*+ Index(PSAPMSGPUBHDR PSCPSAPMSGPUBHDR) */ IBTRANSACTIONID FromPSADM.PSAPMSGPUBHDRWhere PUBSTATUS in (0,5,6) and IBTRANSACTIONID not in ();
00936. 00000-"missing expression"*Cause:
*Action:
Error at Line: 37 Column: 149
When setting up a basic IB Monitor (1 database, only default monitoring), there is a SQL syntax error in the resulting monitoring SQL. The SQL is missing single quotes inside the parentheses for
NOT IN ()
.Example SQL Error:
Here is the configuration for the setup:
The text was updated successfully, but these errors were encountered: