DEVELOPERS FORUM - Error saying "cannot find table 0" on executing a stored procedure from aras SQL item

AmitS - Friday, December 20, 2013 1:59 PM:

Hi 

I'm facing once issue while using SQLs in Aras.

I've created a procedure with parameters to update an ItemType and calling the same from a server side method.

But when that procedure is executing (onAfterUpdate of itemType), its giving an error which says something like  "cannot find table 0 in sql stored procedure ......"

What could be the possible reasons for this? Please suggest how to resolve this.

Thanks.

Manoj katta - Thursday, September 8, 2016 3:41 AM:

Hi Amit,

Even i got same error "Cannot find table 0" can u find out solution 

edonahue - Monday, September 12, 2016 10:51 AM:

Hi Manoj katta,

Can you provide the SQL for your stored procedure, as well as some more detail about the goal of the procedure?