Failed to call a SQL procedure

[lydia_x]

Hi,

I am new to Pentaho. I am trying to execute a stored procedure in SQL Server, but everytime I got those error messages below.
2012/01/19 13:37:44 - Call DB Procedure.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Because of an error, this step can't continue:
2012/01/19 13:37:44 - Call DB Procedure.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Unable to call procedure
2012/01/19 13:37:44 - Call DB Procedure.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Cannot find procedure 'CRMup.phy_specialty_mapping'.

I am sure that the procedure is in the database and the connection to the database has no problem.

Any help would be appreciated. Thank you!

[lydia_x]

I got it, guys. It's kinda a bug in Pentaho. When calling a SQL procedure using Call DB Procedure, you will have to delete the database name in the Proc-name section.

[Hrishi]

I faced the same error. Removing the database name from Proc-name actually works!!! Thanks for the solution!