UDA-SQL-0184

[EArumugam]

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.

thanks,
eas

[MFGF]

Sounds like someone has made some changes in FM which do not match up to the database. Adding a column called "DUMMY" to a SQL select statement, for test purposes maybe?

If you go back to FM and search for DUMMY, does it return anything?

MF.

[Bark]

That's probably because you are trying to call a column called DUMMY in your select statement. Do you have any macro function embedded? something like #prompt('parameter','token','DUMMY')#? it could be either in the report or in the model.

If this is the case, it will fail in the validation and if you don't set any value for the parameter when running it.

Regards,

Bark

[EArumugam]

Thanks for your reply bark and MFGF.

Bark,

We have used the macro function as you said below and that prompt macro parameter we have not used in some reports. we are getting error for the report we have not used. Please advice how can we resolve this.

thank you once again,
eas

[Bark]

The thing is that the macro function as I wrote it, will use 'DUMMY' as a default so, if you don't set the parameter, it will try to call a column called 'DUMMY'. To solve it, either set as default an existing column in your table or remove the last parameter (this latter will make the parameter to be required):

1. #prompt('parameter','token','EXISTING COLUMN NAME')#
2. #prompt('parameter','token')#

Regards,

Bark