AnsweredAssumed Answered

Executing XOG via a gel script connecting to SSL clarity

Question asked by Plidian on Mar 23, 2011
Latest reply on Dec 18, 2012 by riteshkumar
This will probably be a simple one.

I'm trying to write a script that pulls data out of the database then depending on what that data is generates a XOG script one of 2 ways and then execute that XOG.

Unfortunately since the customer is hosted their environment is SSL.

I have an initialization script that I use to capture the URL, username and password.

<gel:script
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:core="jelly:core"
xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"
xmlns:sql="jelly:sql"
xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<gel:parameter default="http://localhost:80" var="xog_url"/>
<gel:parameter var="xog_user"/>
<gel:parameter secure="true" var="xog_pass"/>
<gel:persist scope="INSTANCE" value="${gel_objectInstanceId}" var="myObjectId"/>
<gel:persist scope="INSTANCE" value="${gel_processInstanceId}" var="myProcessId"/>
<gel:persist scope="INSTANCE" value="${xog_url}" var="myXogUrl"/>
<gel:persist scope="INSTANCE" value="${xog_user}" var="myXogUser"/>
<gel:persist scope="INSTANCE" value="${xog_pass}" var="myXogPass"/>

</gel:script>


Then I use a step with a custom script in it to generate the XOG and try and xog it in. Unfortunately I'm not even connecting the process genreates the following error.

org.apache.commons.jelly.JellyTagException: null:113:62: <soap:invoke> Failed to send a SOAP message generated to 'https://localhost/niku/xog'.Connection refused: connect at com.niku.union.gel.tags.soap.InvokeTag.doTag(InvokeTag.java:64) at

Line 113 is as follows

<soap:invoke endpoint="${myXogUrl}/niku/xog" var="runresult">

The username and password work to log into clarity, and to execute a xog script in action=xog.client


<core:catch var="xogerr">
<soap:invoke endpoint="${myXogUrl}/niku/xog" var="target_auth">
<soap:message>
<soapenv:Envelope
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xog="http://www.niku.com/xog">
<soapenv:Header/>
<soapenv:Body>
<xog:Login>
<xog:Username>${myXogUser}</xog:Username>
<xog:Password>${myXogPass}</xog:Password>
</xog:Login>
</soapenv:Body>
</soapenv:Envelope>
</soap:message>
</soap:invoke>
</core:catch>
<!-- Checking whether a sessionID is returned. If not, it means that Login was not successful. -->
<core:set var="sessionID" value="$target_auth/SOAP-ENV:Envelope/SOAP-ENV:Body/xog:SessionID/text()" />


<soap:invoke endpoint="${myXogUrl}/niku/xog" var="runresult">
<soap:message>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xog="http://www.niku.com/xog">
<soapenv:Header>
<xog:Auth>
<xog:SessionID>${sessionID}</xog:SessionID>
</xog:Auth>
</soapenv:Header>




<soapenv:Body>





<gel:include select="$dataload"/>




</soapenv:Body>



</soapenv:Envelope>
</soap:message>
</soap:invoke>

Am I missing something obvious? Or can I just not execute a XOG from within Gel against a system that has SSL enabled?
Thanks
-Nathan

Outcomes