Issue with a teradata query

Database

Issue with a teradata query

Hi,

I have teradata stored procedure  which has a query with a group by. The group by has some constants as well.

When I run the query in prod environment, sometimes I get anerror

"SQL_STATE:53003|SQL_CODE:3883|OUT_ERR_MSG:Invalid Group BY constant" . When I re run the query this issue goes off. I am not able to replicate this error in any other environments as well.

Please provide your inputs for the same

Thanks,

Sreeja