topic The stored process API failed to load the stored process metadata. in Developers

The stored process API failed to load the stored process metadata.

Sam2022 — Tue, 26 Jul 2022 09:56:20 GMT

Hi guys,

I have issue modifying my stored process in SAS EG, I have created it one month ago but now I can't modify it but I can run it and this error comes when trying to modify:

The stored process API failed to load the stored process metadata.

Object reference not set to an instance of an object.

I'm using SAS EG version 7.15

Re: The stored process API failed to load the stored process metadata.

JosvanderVelden — Wed, 27 Jul 2022 12:43:17 GMT

Which hotfix version?
There were issues similar to yours that were resolved by applying the latest hotfix.

Re: The stored process API failed to load the stored process metadata.

AllanBowe — Wed, 27 Jul 2022 13:47:36 GMT

I appreciate it doesn't directly answer your question, but I figured I'd point you to various tools we have built that may help on your journey:

* Folder Navigator. This web app lets you modify STPs in the browser: https://github.com/sasjs/folder-navigator
* Data Controller. Includes a metadata object explorer you can use to troubleshoot: https://4gl.uk/dcdeploy

* SASjs CLI. Create Stored Processes from Command Line. https://cli.sasjs.io

* mm_createstp. A macro to create Stored Processes programmatically. https://core.sasjs.io/mm__createstp_8sas.html

Re: The stored process API failed to load the stored process metadata.

Sam2022 — Tue, 02 Aug 2022 07:18:59 GMT

Thanks all for your help, i tried many things but it didn't work.

Laste thing I did, I tried to disconnect from server and close my SAS EG and opened it again and it worked !