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 [ExactOnline1].[11111111.[TransactionLines]
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?
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 AI? You can find these in the Logs tab within Connect AI. 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.