Topic
1 reply Latest Post - ‏2013-01-10T14:32:07Z by Rick_J
SystemAdmin
SystemAdmin
15496 Posts
ACCEPTED ANSWER

Pinned topic UDA-SQL-0184

‏2012-12-20T11:27:13Z |
RQP-DEF-0177 An error occurred while performing operation
'sqlPrepareWithOptions' status='-203'. UDA-SQL-0184 The column "DUMMY"
was not found.

wat would be cause for the above error.
I am getting this error after new version of the package published , the scheduled report got failed.
Updated on 2013-01-10T14:32:07Z at 2013-01-10T14:32:07Z by Rick_J
  • Rick_J
    Rick_J
    138 Posts
    ACCEPTED ANSWER

    Re: UDA-SQL-0184

    ‏2013-01-10T14:32:07Z  in response to SystemAdmin
    If it started occuring in an existing report after a package build then check the FM for a macro that doesn't have a default column value set for the parameter. I thing "DUMMY" is used by default when no parameter is given in the macro. Change the macro to use an existing column.

    prompt('parameter','token','Your_Existing_Column')#