# MS SQL Stored Procedure Process Event Script not executing on either GET,POST \[RESOLVED\]

**URL:** <https://community.dreamfactory.com/t/ms-sql-stored-procedure-process-event-script-not-executing-on-either-get-post-resolved/2119>\
**Category:** Server-Side Scripting\
**Created:** [February 1, 2016, 11:43pm UTC](https://community.dreamfactory.com/t/ms-sql-stored-procedure-process-event-script-not-executing-on-either-get-post-resolved/2119 "2016-02-01T23:43:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kieren1](https://avatars.discourse-cdn.com/v4/letter/k/eb9ed0/32.png) [@Kieren1](https://community.dreamfactory.com/u/Kieren1)\
**Post date:** [February 1, 2016, 11:43pm UTC](https://community.dreamfactory.com/t/ms-sql-stored-procedure-process-event-script-not-executing-on-either-get-post-resolved/2119/1 "2016-02-01T23:43:18Z")

</div>

Hello.

Great product, love it!

Process Event Scripts don’t appear to be executing on either GET,POST, pre or post process for Stored Procedures.  
Admin Application Version: 2.0.6 DreamFactory Version: 2.0.4

I have a role defined and API an SCRIPT permissions enabled. When I add some post\_process code for a SQL table with GET for example, the Process Event Script is executing fine. But I cant get any code to execute for either GET or POST for Stored procedures. The dataset result of stored procedures calls all works and is returned in JSON/XML as expected. I also have an API key for the application and role which I’m currently using.

[POST] {service}.\_proc.{procedure\_name} {service}.\_proc.{procedure\_name}.post.post\_process  
[GET] {service}.\_proc.{procedure\_name} {service}.\_proc.{procedure\_name}.get.post\_process

Any help would be greatly appreciated.

Regards, Kieren.

---

<div class="post-metadata">

**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\
**Post date:** [February 2, 2016, 2:19pm UTC](https://community.dreamfactory.com/t/ms-sql-stored-procedure-process-event-script-not-executing-on-either-get-post-resolved/2119/2 "2016-02-02T14:19:34Z")

</div>

This is a bug that I believe was resolved in the 2.1 release.

---

<div class="post-metadata">

**Author:** ![Kieren1](https://avatars.discourse-cdn.com/v4/letter/k/eb9ed0/32.png) [@Kieren1](https://community.dreamfactory.com/u/Kieren1)\
**Post date:** [February 2, 2016, 10:30pm UTC](https://community.dreamfactory.com/t/ms-sql-stored-procedure-process-event-script-not-executing-on-either-get-post-resolved/2119/3 "2016-02-02T22:30:14Z")

</div>

Thanks for your reply.

I updated to the latest version.  
Admin Application Version: 2.1.0  
DreamFactory Version: 2.1.0  
running on Red Hat Enterprise Linux Server release 7.1

I’m now receive the following message in the dreamfactory.log when setting up a v8js post process script event

The script only had one line containing the following  
var\_dump(“Lets code ArnoldC”);

[2016-02-02 21:31:10] local.DEBUG: Resource event: {service}.\_proc.{procname}.get.pre\_process  
[2016-02-02 21:31:10] local.DEBUG: Resource event: {service}._proc.{procname}.get.post\_process  
[2016-02-02 21:31:10] local.ERROR: Exception executing javascript: {service}._{procname}.get.post\_process:8: SyntaxError: Unexpected token ;  
[2016-02-02 21:31:10] local.ERROR: \* Script did not return an array:  
[2016-02-02 21:31:10] local.DEBUG: Resource event: {service}.\_proc.{procedure\_name}.get.post\_process

Any help would be greatly appreciated.  
Regards, Kieren.

---

<div class="post-metadata">

**Author:** ![sridharsa](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/sridharsa/32/541_2.png) [@sridharsa](https://community.dreamfactory.com/u/sridharsa)\
**Post date:** [February 3, 2016, 1:32am UTC](https://community.dreamfactory.com/t/ms-sql-stored-procedure-process-event-script-not-executing-on-either-get-post-resolved/2119/4 "2016-02-03T01:32:18Z")

</div>

Try running a “php -m | grep v8” to see if v8js is installed or not. That might be the problem there.

---

<div class="post-metadata">

**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\
**Post date:** [February 3, 2016, 1:47pm UTC](https://community.dreamfactory.com/t/ms-sql-stored-procedure-process-event-script-not-executing-on-either-get-post-resolved/2119/5 "2016-02-03T13:47:08Z")

</div>

i think var\_dump requires an object or array.  
Try  
`var_dump(event);`

And see if the event object is written to the log.