--- Associated statement is not prepared - SQL Agent

[Panther]

Hi ...

I got a job using Web Publishing to generate report based on the data
returned from store procedure. Lately, I got some funny problem which
never happen before.

*************
Error Message
*************
SQL Web Assistant: Could not execute the SQL statement. [SQLSTATE
42000] (Error 16805) Associated statement is not prepared [SQLSTATE
HY007] (Error 0). The step failed.

After I got an alert, I used SQL Query Analyser to run the same store
procedure. It works okay.

Anyone know what happen and what I should do in order to get it work ?

Thanks in advance ...