ORA-36165: (XSAGGCNTPROP) Variable workspace object cannot have both an AGGCOUNT and the $COUNTVAR property.

ORA-36165: (XSAGGCNTPROP) Variable workspace object cannot have both an AGGCOUNT and the $COUNTVAR property.

Cause: An attempt was made to add the $COUNTVAR property to a variable which already had an AGGCOUNT, or vice versa.

Action: Delete the already existing $COUNTVAR property or AGGCOUNT first.