COUNT attempt exception encountered on cursor prepare/open

[calexander]

Hello,
I had noticed some logs that mention 'COUNT attempt exception encountered on cursor prepare/open'. I don't know if it's actually causing any issues as the app seems to behave fine, but I thought I'd mention it.

Here is a log after I was able to replicate the log that mentions the exception:

COUNT attempt exception encountered on cursor prepare/open.< br > < br > Counting statement:
select
count(1)
from
(
WITH customerflags AS (
SELECT
*
FROM
nuptesttb
)
SELECT
DISTINCT cust#,
customers.cust AS cust_name,
customerflags.mybool AS cust_flag
FROM
nuptesttb2 AS customers
JOIN customerflags ON customerflags.myid = customers.cust#
) temp < br > < br > Original statement: WITH customerflags AS (
SELECT
*
FROM
nuptesttb
)
SELECT
DISTINCT cust#,
customers.cust AS cust_name,
customerflags.mybool AS cust_flag
FROM
nuptesttb2 AS customers
JOIN customerflags ON customerflags.myid = customers.cust#?

It looks like the count statement does not put the WITH clause in the right spot for selecting the count. If I remove the DISTINCT keyword in the data source then it fixes the exception log issue and it instead logs:

COUNT statement: WITH customerflags AS (SELECT * FROM nuptesttb ) SELECT count(1) FROM nuptesttb2 AS customers JOIN customerflags  ON customerflags.myid = customers.cust#

Which appears to now put the WITH clause into the correct spot to make it a valid SQL statement. This happens on a grid that has the Infinite Scroll option checked.

Thank you!

[Johnny Major]

Can you please respond with just your SQL data source statement? Thanks

[calexander]

Here it is:

WITH customerflags AS (
  SELECT
    *
  FROM
    nuptesttb
)
SELECT
  DISTINCT cust#,
  customers.cust AS cust_name,
  customerflags.mybool AS cust_flag
FROM
  nuptesttb2 AS customers
  JOIN customerflags ON customerflags.myid = customers.cust#?