Hi All,
As part of a web application development using SAS STP, we are tryign to integrate the same with JQgrid, wherein we are referencing the following global forum paper "http://support.sas.com/resources/papers/proceedings16/6960-2016.pdf",
For testing purpose we were trying to replicate the example mentioned in the paper, however we are not able to see the output in the HTML page, tihough our stored process is running absolutely fine.
Can someone please look into the sample HTML and STP we have created and advise what are we doing wrong.
Thanks
Ron
Ronny,
I've just tested your code and it works ok.
Are you familiar with how the debug consoles on Chrome / Firefox work? If the name of your SAS web tier host is indeed sasva.demo.sas.com, you need to make sure that the AJAX request is actually being made. You should be able to copy the jqGrid URL property into your browser and see your data.
Where are you hosting your .html file? You should try putting it in a subdirectory of Lev1/Web/WebServer/htdocs/ so it is behind the same reverse proxy.
Other simple things to look at - Streaming output needs to be enabled on your stp obviously. Again, check that the output was correct through the SPWA, easily done by copying and pasting the URL into a new tab.
Make sure you have a look at the console and network tabs of your browser's debug console. What browser are you using?
Nik
Hey Nik,
Yes,
- the html file is stored in the HTDOCS folder
- The STP URL works one, and shows the JSON output.
- All access individual jqgrid to test its accessibility.
- testing it using both IE ver 11 and Chrome ver 51.x
Can you please share the screenshot,
Regards
Ron
Hi Nik,
Unfortunately, we are working in controlled environment and hence cannot have any webex,
Thanks
Ron
Ron,
Here's a list of things to consider in that case:
- You should change this line:
url: 'http://sasva.demo.sas.com/SASStoredProcess/do?_program=%2FShared+Data%2FCustomSTP%2FTestGrid',
to this:
url: '/SASStoredProcess/do?_program=%2FShared+Data%2FCustomSTP%2FTestGrid',
You should not need to specify the full hostname and the protocol if you are loading your .html file correctly. This will make your code more portable and ensures you're not having problems with same origin policy or a mismatch when switching between http/https.
I expect your DataGrid.txt file you attached is called DataGrid.html in your system, and when stored inside your htdocs directory, you should be loading it with a URL like
http://sasva.demo.sas.com/[whateversubdirectoryinyourhtdocs]/DataGrid.html
With that out of the way, the main thing I can think of is that your browser session inside your controlled environment is not able to access the external internet, therefore unable to source the JavaScript files from the CDNs. This should show up on the Network tab of Chrome DevTools as red, failed requests and should be obvious. If that's the case, you should copy down the .js and .css files sourced at the top of your html page into the same directory as your DataGrid.html, and change your <head> to something like this:
<head> <!-- The jQuery library is a prerequisite for all jqSuite products --> <script type="text/ecmascript" src="jquery-2.1.1.min.js"></script> <!-- This is the JavaScript file of jqGrid --> <script type="text/ecmascript" src="jquery.jqGrid.min.js"></script> <!-- This is the localization file of the grid controlling messages, labels, etc. --> <!-- We support more than 40 localizations --> <script type="text/ecmascript" src="grid.locale-en.js"></script> <!-- A link to a jQuery UI ThemeRoller theme, more than 22 built-in and many more custom --> <link rel="stylesheet" type="text/css" media="screen" href="jquery-ui.css" /> <!-- The link to the CSS that the grid needs --> <link rel="stylesheet" type="text/css" media="screen" href="ui.jqgrid.css" />
As Vasilij suggests, you should spend some time getting comfortable with the DevTools console and the Network tab - all of these problems should be pretty obvious from there.
Nik
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.