Missing stored proceudre

Question

Upon attempting to execute stored procedure, spsoCreateShipLines, the console says that it could not find a specific stored procedure executed within this procedure. This specific procedure is called spGetNextBlockSurrogateKey. I cannot find this procedure anywhere in the Sage 500 ERP SDK 2017. Any help finding this?

jlputtman · Accepted Answer

HI trozio, 
 spGetNextBlockSurrogateKey is a very very important stored procedure in Sage 500. You should be able to use SSMS and the object browser to locate the stored procedure in the sage500_app or the mas500_app database. This stored procedure makes a call out to an extended stored procedure that uses the CLR to get the next surrogate keys for particular tables. You might be running into a permissions issue if you are calling this from custom code. 
 I would not expect that your Sage 500 installation would work unless this procedure was in place. 
 Hope that Helps 
 John

Sage 500

Missing stored proceudre

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING