Missing stored proceudre

SOLVED

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?

Parents
  • +1
    verified 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

  • 0 in reply to jlputtman

    Found it. Many thanks

Reply Children
No Data