Database support module uses this query to get total row count:
select count(*) from (enteredQuery) C2668;

In this case:

select count(*) from (
select 
count(act.ACTION_ID) actcount, 
ncr.ncr_id, ncr.RAISED_DATE, ncr.COMPLETE, rca.rc_id, rca.DATE_OPEN,
rca.DATE_DUE, rca.COMPLETE,  ca.ca_id, ca.DATE_OPEN, ca.DATE_DUE, ca.COMPLETE 
from Ot_ncr ncr 
left outer join Ot_ncr_action act on ncr.NCR_ID = act.NCR_ID
left outer join Ot_ncr_root_cause rca on ncr.NCR_ID = rca.NCR_ID 
left outer join Ot_ncr_ca ca on rca.CA_ID = ca.CA_ID
group by ncr.ncr_id, ncr.RAISED_DATE, ncr.COMPLETE, rca.rc_id, rca.DATE_OPEN,
rca.DATE_DUE, rca.COMPLETE,  ca.ca_id, ca.DATE_OPEN, ca.DATE_DUE, ca.COMPLETE;
) C2668;

Please, try to execute this query and check whether the result is correct.
Thank you in advance.

The query:
select count(*) from (
select
count(act.ACTION_ID) actcount,
ncr.ncr_id, ncr.RAISED_DATE, ncr.COMPLETE, rca.rc_id, rca.DATE_OPEN, rca.DATE_DUE, rca.COMPLETE,  ca.ca_id, ca.DATE_OPEN, ca.DATE_DUE, ca.COMPLETE 
from Ot_ncr ncr 
left outer join Ot_ncr_action act on ncr.NCR_ID = act.NCR_ID 
left outer join Ot_ncr_root_cause rca on ncr.NCR_ID = rca.NCR_ID 
left outer join Ot_ncr_ca ca on rca.CA_ID = ca.CA_ID 
group by ncr.ncr_id, ncr.RAISED_DATE, ncr.COMPLETE, rca.rc_id, rca.DATE_OPEN, rca.DATE_DUE, rca.COMPLETE,  ca.ca_id, ca.DATE_OPEN, ca.DATE_DUE, ca.COMPLETE;
) C2668;

Causes an SQL error:
Error code 0, SQL state 37000: [Pervasive][ODBC Engine Interface]Syntax Error: er join Ot_ncr_ca ca on rca.CA_ID = ca.CA_ID 
group by ncr.ncr_id, ncr.RAISED_DATE, ncr.COMPLETE, rca.rc_id, rca.DATE_OPEN, rca.DATE_DUE, rca.COMPLETE,  ca.ca_id, ca.DATE_OPEN, ca.DATE_DUE, ca.COMPLET<< ??? 
Line 3, column 1

Error code 0, SQL state 37000: [LNA][Pervasive][ODBC Engine Interface]Syntax Error: << ??? >>)
Line 11, column 1

So - It seems that this is an issue of the generated SQL not being supported by the pervasive SQL dialect.

(In reply to comment #2)
> So - It seems that this is an issue of the generated SQL not being supported by
> the pervasive SQL dialect.

The parser is right - it is incorrect - please try this:

--------------------------

select count(*) from (
select 
count(act.ACTION_ID) actcount, 
ncr.ncr_id, ncr.RAISED_DATE, ncr.COMPLETE, rca.rc_id, rca.DATE_OPEN,
rca.DATE_DUE, rca.COMPLETE,  ca.ca_id, ca.DATE_OPEN, ca.DATE_DUE, ca.COMPLETE 
from Ot_ncr ncr 
left outer join Ot_ncr_action act on ncr.NCR_ID = act.NCR_ID
left outer join Ot_ncr_root_cause rca on ncr.NCR_ID = rca.NCR_ID 
left outer join Ot_ncr_ca ca on rca.CA_ID = ca.CA_ID
group by ncr.ncr_id, ncr.RAISED_DATE, ncr.COMPLETE, rca.rc_id, rca.DATE_OPEN,
rca.DATE_DUE, rca.COMPLETE,  ca.ca_id, ca.DATE_OPEN, ca.DATE_DUE, ca.COMPLETE
) C2668;

--------------------------

Notice the missing semi-colon in the last row of the inner query (the mentioned eleventh line).

Ah - I thought the ';' might be out of place - I already tried 

select count(*) from (
select
count(act.ACTION_ID) actcount,
ncr.ncr_id, ncr.RAISED_DATE, ncr.COMPLETE, rca.rc_id, rca.DATE_OPEN, rca.DATE_DUE, rca.COMPLETE,  ca.ca_id, ca.DATE_OPEN, ca.DATE_DUE, ca.COMPLETE 
from Ot_ncr ncr left outer join Ot_ncr_action act on ncr.NCR_ID = act.NCR_ID 
left outer join Ot_ncr_root_cause rca on ncr.NCR_ID = rca.NCR_ID 
left outer join Ot_ncr_ca ca on rca.CA_ID = ca.CA_ID 
group by ncr.ncr_id, ncr.RAISED_DATE, ncr.COMPLETE, rca.rc_id, rca.DATE_OPEN, rca.DATE_DUE, rca.COMPLETE,  ca.ca_id, ca.DATE_OPEN, ca.DATE_DUE, ca.COMPLETE
) C2668;  

This time I get a different error:

Error code 0, SQL state S0021: [LNA][Pervasive][ODBC Engine Interface]Column names in each view must be unique.

I'm reading through the pervasiveSQL (V10) documentation - but have not yet found a solution..

If I modify the query as:

select count(*) from (
select count(act.ACTION_ID) as actcount, count(conc.CONCESSION_ID) as conccount,  ncr.ncr_id as ncr_ncr_id, ncr.raised_date as ncr_raised_date, ncr.complete as ncr_complete, rca.rc_id as rca_rc_id, rca.date_open as rca_date_open, rca.date_due as rca_date_due, rca.complete as rca_complete,  ca.ca_id, ca.date_open as ca_date_open, ca.date_due as ca_date_due, ca.complete as ca_complete  from Ot_ncr ncr  left outer join Ot_ncr_action act on ncr.NCR_ID = act.NCR_ID left outer join Ot_ncr_concession conc on act.CONCESSION_ID = conc.CONCESSION_ID left outer join Ot_ncr_root_cause rca on ncr.NCR_ID = rca.NCR_ID  left outer join Ot_ncr_ca ca on rca.CA_ID = ca.CA_ID group by ncr.ncr_id, ncr.RAISED_DATE, ncr.COMPLETE, rca.rc_id, rca.DATE_OPEN, rca.DATE_DUE, rca.COMPLETE,  ca.ca_id, ca.DATE_OPEN, ca.DATE_DUE, ca.COMPLETE
) C2668;

I get valid SQL and correct result (63)

Sorry for confusion - I added an extra table in the last query - but it does not matter - the solution is to add the field alias names - but I guess that could be tricky in the NB query parser.

(In reply to comment #3)
> The parser is right - it is incorrect - please try this:
> [...]
> Notice the missing semi-colon [...]
I'm sorry, my fault. Thank you, Matthias, for correcting me.

It's quite valid to show that total count cannot be computed, but in this case total count is 1, which is incorrect.

The problem is that if the the query "select count(*) from (<original query>)" fails, another query, "select count(*) from <part of the original query after FROM>" is used, but only if it contains no "GROUP BY" statement.
In this case, "GROUP BY" wasn't detected, and the query was used despite risk of incorrect result.
Fixed here: http://hg.netbeans.org/core-main/rev/06f0fbe9e4ac

(In reply to comment #6)
> Sorry for confusion - I added an extra table in the last query - but it does
> not matter - the solution is to add the field alias names - but I guess that
> could be tricky in the NB query parser.
Yes, that would need full SQL parser, and it it would still leave some uncovered cases. So, just showing N/A should be acceptable, I hope.

Thank you very much for reporting and for your help.

Integrated into 'main-silver', will be available in build *201307022300* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)

Changeset: http://hg.netbeans.org/main-silver/rev/06f0fbe9e4ac
User: Jaroslav Havlin <jhavlin@netbeans.org>
Log: #232075: Total row count incorrect