For the issue 2:

INVALID_PARAMETER_VALUE: Couldn't find enough valid rows in the selected table. Found 0 rows, minimum required is 1 for agent creation.

Since the previous step was failing due to a data type issue (VARIANT), it's highly likely that the entire table is being marked as invalid or unusable by the Agent framework's sampling mechanism.