Erros while running stored process to update records

sasprofile — Tue, 18 Aug 2015 20:51:33 GMT

Hi All,

I have an Issue with SAS AMO 5.1.

am trying to run a Stored process to update some records, when I changed the records and trying to update am getting continuously

two error prompt windows as shown below and the data is never getting updated. anyone has faced similar issue.

Error window 1

SAS Add-In

stored process "Name" encountered errors while opening the results

we can continue to open the results or postpone processing by placing them in the status window.

Continue Postpone Abort (These are buttons)

When I click continue above below it prompts with a different window

Error window 2

SAS Add-In

stored process "Name" has completed with no visual content. You can refresh this analysis through the Manage content dialog box

When I close this window the records never updates

I would really appreciate if any one can help me with this issue

Thanks in Advance

Re: Erros while running stored process to update records

RamakrishnanP — Wed, 11 Dec 2019 17:06:41 GMT

Hi,

Looks like there are zombie processes remaining on the server for “sassrv” ID. Make sure to kill all previous days processes before 7am the next day. We need to come up with a clean up script, this has been the case since the many environment. Users run jobs and cancel in the middle without letting it finish.

if kill isn’t working on server, thne have opened a ticket to UNIX team to resolve. Meanwhile, you can use sassrv ID to login directly and try to kill the zombie process which is running in background.

topic Erros while running stored process to update records in Microsoft Integration with SAS

Erros while running stored process to update records

Re: Erros while running stored process to update records