In this blog post, let’s learn about the error message “12324 Creation failed. The statement includes multiple grouping clauses. Incremental refresh type cannot be specified.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
12324 Creation failed. The statement includes multiple grouping clauses. Incremental refresh type cannot be specified.
Reason for the Error
You specified multiple grouping expressions in the MV definition, such as both DISTINCT and GROUP BY clauses.
Solution
Remove one of the grouping clauses and resubmit the statement
