B
BruceFFIC
We are running SP2 & AUG09 MS CU. We were just running with WSS, but
then installed MOSS so we could use the more robust workflow. Since
then are SRS reports that have an execute statement fail I posted the
following on Developer stie about a week ago and got no responses.
Just wondering anyone else run into this problem?
We are running into errors with our SRS reports running in a test
environment under MOSS. Reports that execute a stored procedure
fail;
those that don't are successful. One likely cause we have discovered
is that our production environment has a dbo.MSP_EpmCPPrjVar1 table
(we have 53 custom project fields) -- the test environment doesn't,
so
calls to lookup custom project fields are failing, even for queries
that don't explicitly call the Var1 table. Our test environment
worked successfully with a recent upgrade to SP2 and Aug09 MS CU.
Thanks,
then installed MOSS so we could use the more robust workflow. Since
then are SRS reports that have an execute statement fail I posted the
following on Developer stie about a week ago and got no responses.
Just wondering anyone else run into this problem?
We are running into errors with our SRS reports running in a test
environment under MOSS. Reports that execute a stored procedure
fail;
those that don't are successful. One likely cause we have discovered
is that our production environment has a dbo.MSP_EpmCPPrjVar1 table
(we have 53 custom project fields) -- the test environment doesn't,
so
calls to lookup custom project fields are failing, even for queries
that don't explicitly call the Var1 table. Our test environment
worked successfully with a recent upgrade to SP2 and Aug09 MS CU.
Thanks,