topic SAS stored process is not calling in SAS Programming

SAS stored process is not calling

AravindPalanichamy — Thu, 13 Nov 2014 09:21:01 GMT

Hi,

We are retrieving data from front end java application using Jquery. In that we have two buttons to type the input data either character or numeric. After entering the data in front end when i try to see it in the dataset which is not updated. Am not sure where this error occurs. From back end we given the proper code to retrieve those datas. Is there any other way to check the stored process to identify where this error is occuring, from which end the data is not transfering properly.

That particular stored process is not calling at all. So i could not able to identify the error in log also. Please suggest some ideas to identify the input parameters which is transfering between front end and back end.

Is there any tool to get the data between these two ends.

Please suggest

Regards,

Aravind

Re: SAS stored process is not calling

Kurt_Bremser — Thu, 13 Nov 2014 10:20:17 GMT

The stored process server(s) write(s) a log in which you can find if a certain stored process has been executed at a given time

(.../Lev1/SASApp/StoredProcessServer/Logs)

You can insert statements in the stored process code that lets you more closely follow what is happening

- reroute the log with proc printto

- use put or %put to write additional information to that log

- assign a filename reference to a persistent file and write messages to that file with data _null_ steps to monitor progress

Re: SAS stored process is not calling

AravindPalanichamy — Thu, 13 Nov 2014 10:27:54 GMT

Thanks Kurt for the suggestion.

I went to the same log file path and i could not able to see the particular Stored process in the log.

Re: SAS stored process is not calling

Kurt_Bremser — Thu, 13 Nov 2014 12:22:51 GMT

This indicates that the stored process was never called from the frontend, so you will need to look for information there.

Re: SAS stored process is not calling

JuanS_OCS — Thu, 13 Nov 2014 19:20:16 GMT

Kurt is correct.

You can look for the issue from the SAS side, but it will be easier for you to do it from the start of your request to the Stored Process.

As you are making use of JQuery, I would debug first the front-end (many options, I like the firefox ones) to validate that, at least, the dynamic query (js, AJAX) and if it is OK, then debug the Java application or see the logs from your web application server (Jboss, WebLogic, etc) and your Java application. This is the critical point to realize the origin of your issue.

From the SAS side, you should check the logs in the Metadata server, your object spawner.... a little more complicated, but maybe worthy sooner or later.

Re: SAS stored process is not calling

AravindPalanichamy — Fri, 14 Nov 2014 18:59:27 GMT

Thanks Juan. But i how to debug the front end. Using firefox means. please elaborate. how to check the error from front side

Re: SAS stored process is not calling

JuanS_OCS — Fri, 14 Nov 2014 19:38:42 GMT

It is possible to install plugins in Firefox for debugging, like one called FireBug, very popular. But if it is your first time to debug and investigate the front end, I think it would be a good idea for you to sit together with an experienced collega on this area.