topic Re: Table not found in Stored Proc in QlikView

Table not found in Stored Proc

mishraamit2485 — Sat, 01 Aug 2015 09:46:18 GMT

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)

Re: Table not found in Stored Proc

mishraamit2485 — Sat, 01 Aug 2015 09:49:30 GMT

mby‌

Re: Table not found in Stored Proc

maxgro — Sat, 01 Aug 2015 09:59:39 GMT

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

Re: Table not found in Stored Proc

mishraamit2485 — Sat, 01 Aug 2015 10:52:36 GMT

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

Re: Table not found in Stored Proc

sasiparupudi1 — Sat, 01 Aug 2015 11:47:35 GMT

Try to use the full path like

Exec dbo.sp_name

And also check if execute rights are permitted for the user

Hth

Sasi

Re: Table not found in Stored Proc

mishraamit2485 — Sat, 01 Aug 2015 11:54:02 GMT

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

Re: Table not found in Stored Proc

sasiparupudi1 — Sat, 01 Aug 2015 12:29:17 GMT

try

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

may be this can help

Execute a Stored Procedure in Qlikview

Re: Table not found in Stored Proc

mishraamit2485 — Sat, 01 Aug 2015 14:52:16 GMT

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

Re: Table not found in Stored Proc

Kushal_Chawda — Sat, 01 Aug 2015 15:20:51 GMT

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

Re: Table not found in Stored Proc

mishraamit2485 — Sat, 01 Aug 2015 15:26:21 GMT

In QV? can u help me with that?

Re: Table not found in Stored Proc

Kushal_Chawda — Sat, 01 Aug 2015 15:30:07 GMT

see the screenshot

Re: Table not found in Stored Proc

qlikviewwizard — Sat, 01 Aug 2015 15:58:11 GMT

Thanks for the info.

Re: Table not found in Stored Proc

sasiparupudi1 — Mon, 03 Aug 2015 06:32:02 GMT

Try

sql {call dbo.SP_NAME} ;

Re: Table not found in Stored Proc

Anonymous — Mon, 03 Aug 2015 07:03:41 GMT

Hi,

Try this

SQL GRANT EXEC ON dbo.SP_NAME TO <UserName>

Re: Table not found in Stored Proc

mishraamit2485 — Mon, 03 Aug 2015 15:07:41 GMT

Hi All,

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

Thanks everyone for their suggestions.

Re: Table not found in Stored Proc

sasiparupudi1 — Mon, 03 Aug 2015 15:24:34 GMT

Hi Amit

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

Thanks

Sasi