How to Resolve the error?

[former_member188628]

how to resolve the error faced during Refresh of a report in webi 4.0?

[former_member182521 · Accepted solution]

From the error message it is clearly evident that the procedure named CTDynamic in database PURCH needs a Parameter to be passed to execute it successfully.

Thanks

Mani

[former_member188628 · Accepted solution]

Thanks a lot Manik. Received a solution for this:-it was occuring because of the @variable in the custom sql in the report needed to be replaced with the @prompt function( from the system generated sql).We just replaced the syntax and it was working fine..but ended up in different issue...still working on that...But thanks a lot ... again.

[former_member190982]

Database level issue, if you run the query on the database you will get same error.

[former_member188628]

Hey Thanks Ritesh,yes it was sql level problem,replaced the @variable syntax of the custom sql with the @prompt syntax and it was working fine.Thanks a lot...

[Former Member]

Hi Moumita,

I believe there must be something wrong with the SQL statement of this report. If this report is based on SQL query then please check query.

I am not a report developer, so not sure what else would be wrong.

~SwapnilY

[former_member188628]

Thanks a lot Swapnil..yes figured out the solution for this,related to @variable and @prompt syntaxes in the report level(deski to webi upgradation project),replaced all the custom sql @variable with @prompt.Thanks again