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)

[mishraamit2485]

mby‌

[maxgro]

From the log it seems the procedure is executed because the error is after the STORE (after the execute)

Maybe the stor proc is executed but no records is returned, the table isn't created and the store of a missing table raises an error

add an exit script

after the execute SP_Name

reload and with the table viewer ctrl-t check if SP_Name table exists

7/30/2015 4:37:22 AM: 0045  SP_Name:

7/30/2015 4:37:22 AM: 0046  SQL

7/30/2015 4:37:22 AM: 0047 

7/30/2015 4:37:22 AM: 0048  execute SP_Name

7/30/2015 5:01:09 AM: 0050  STORE SP_Name into ..\..\..\..\..\QVD\SC\Del\GN\OSS\SP_Name.QVD

7/30/2015 5:01:10 AM:       Error: Table Not Found

7/30/2015 5:01:10 AM:       Genral Script Error

7/30/2015 5:01:10 AM:       Execution Falied

7/30/2015 5:01:10 AM:       Execution Finished

[mishraamit2485]

Yeah nothing is coming up in the table viewer no tables.

But why that SP is giving the records when we are executing it from the SS Studio but not through the QVD Gen

[sasiparupudi1]

Try to use the full path like

Exec dbo.sp_name

And also check if execute rights are permitted for the user

Hth

Sasi

[mishraamit2485]

Yes execute permission is there...and the SP is in same schema DBO checked on DB.

[sasiparupudi1]

try

load * sql exec  ('[dbo].[proc_Name]');

may be this can help

Execute a Stored Procedure in Qlikview

[mishraamit2485]

No Luck...

I just opened the SP, SP is (View A Union View B)...

so i tried to run like  View A Union View B in my QVD Gen, it is is throwing the error Object A does not exist....

But when I'm running both of them separately (Like select * from VIew A or Selct * from View B) both are running well and giving the records...its bit strange type of situation...

[Kushal_Chawda]

Hi,

Make sure that in script editor Setting tab "can execute external program"  "Open databases in read and write mode" is checked

run procedure as

sql exec databasename.dbo.procedurename

https://community.qlik.com/thread/62180

[mishraamit2485]

In QV? can u help me with that?