B
BruceFFIC
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.
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.