Skip to main content

Hi Team,

 

I am trying to run this query in CDATA through powerautomate but its not producing any results but with some other divisons it producing results strange issue.please guide me on this  

SELECT GLAccountCode,MIN(FinancialYear) AS LeastFinancialYear,
MAX(FinancialYear) AS HighestFinancialYear
FROM OExactOnline1].111111111.1TransactionLines]
GROUP BY GLAccountCode

Hi ​@muthuEOL 

If you are running the same query but with a different schema depending on the Division number you are setting then the problem could be related to the Division in question. Can you confirm you have access to the data for this Division? Are you certain you are providing the correct Division as a Schema? In most cases we have seen that Division is a 6 digit number but you are providing a 8 digit Division in your query. Can you double check and verify?

https://cdn.cdata.com/help/DYK/jdbc/RSBExact_p_Division.htm 

If you think you have the correct Division but are still seeing issues then more details are needed  to further troubleshoot the issue. Would you be able to share the corresponding logs from Connect Cloud? You can find these in the Logs tab within Connect Cloud. I would recommend you submit a ticket with our support team here https://www.cdata.com/support/submit.aspx  so that one of our support specialists can start looking into this.

CData's Winter 2025 Release
Terms and ConditionsCookie settings