Table not found in Stored Proc

[mishraamit2485]

Hi Experts,

We are facing a strange issue while running one SP(Execute SP_NAME), when I'm calling this SP from my QVD Gen it is throwing one error (Table Not Found) attaching the log File.

But when i'm executing the same SP in my SS Studio it is giving me proper records but failing in QVD Gen, any guess.

-----------------------------------------------

Point to note: till 2 days back it was running well but today some changes have been done in that SP after that it has been failing in my QVD Gen(But same time running well SS Studio sounds strange)

[Kushal_Chawda]

see the screenshot

[qlikviewwizard]

Thanks for the info.

[sasiparupudi1]

Try

sql {call dbo.SP_NAME} ;

[Anonymous]

Hi,

Try this

SQL GRANT EXEC ON  dbo.SP_NAME TO <UserName>

[mishraamit2485 · Accepted solution]

Hi All,

It was the issue with the DB Server it was not allocating the enough resources to execute.

Thanks everyone for their suggestions.

[sasiparupudi1]

Hi Amit

Please close this thread by marking the correct answer so that it will benefit others who might have similar problem.

Thanks

Sasi