BNE_ROWCOUNT

Trying to setup parameter based content query and it is failing with message below:

************************

A problem has been encountered initializing the control for importing data as detailed below.

The data import has been aborted.Cannot execute SQL Statement.

Number of valid rows

BNE_ROWCOUNT

************************

Content query is as follows:

SELECT application_id,

       viewer_code,

       user_name,

       enabled_flag,

       CREATED_BY,

       CREATION_DATE,

       LAST_UPDATED_BY,

       LAST_UPDATE_LOGIN,

       LAST_UPDATE_DATE

  FROM bne_viewers_vl

WHERE application_id = $PARAM$.231:NEW_PARAMETER

231:NEW_PARAMETER is the parameter.

With a hard coded value like '231', there are no errors. If a parameter is used, it is failing.