Sage 500

Welcome to the Sage 500 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

sage 500 erp data migrator missing temporary table

Posted By trozio over 4 years ago

Trying to execute stored procedure spSOapiSalesOrdIns but I am getting errors that some stored procedures cannot be found. When I look inside those stored procedures, they have errors saying that a specific table cannot be found. This table is: #tsoAPIValid. I cannot find this table anywhere in the SDK. Any help?

0 LouDavis over 4 years ago

I've taken a look at that stored procedure in Sage 500 2014 and see the table is defined and created by it. Have you traced the process to determine exactly where the error is occurring and what the specific error is?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jlputtman over 4 years ago

What version of Sage 500 are you working with? Also what permissions are you running the proc under? Is it a user that is a Sage 500 user? You might be running into permissions issues.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 500

sage 500 erp data migrator missing temporary table

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING