AnsweredAssumed Answered

Error when transport Custom Scripts

Question asked by Balbi on Jul 12, 2017
Latest reply on Oct 26, 2017 by mrueda

Hi,

  I'm trying to transport processes between distinct environments, using the bpm_process content_pack read XOGs.

 

I read the processes in an environment (development) and when I try to write these processes in the other environment (QA) I get the following error:

 <Record>
<KeyInformation>
<column name="ProcessCode">eb_atu_nome_prod</column>
</KeyInformation>
<ErrorInformation>
<Severity>FATAL</Severity>
<Description>Problem while inserting/updating processes</Description>
<Exception>
org.xml.sax.SAXParseException; lineNumber: 13; columnNumber: 54; The prefix "xog" for element "xog:Login" is not bound.
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)

 

I developed a very simple GEL Script, using the XOG documentation as guidance, to test this transport and it also did not work. The GEL Script below was used in the process I'm trying to transport:

 

<gel:script xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/" 
xmlns:core="jelly:core"
xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"
xmlns:file="jelly:com.niku.union.gel.FileTagLibrary"
xmlns:soap="jelly:com.niku.union.gel.SOAPTagLibrary"
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:sql="jelly:sql"
xmlns:x="jelly:xml"
xmlns:xog="http://www.niku.com/xog"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<gel:parameter default="http://localhost" var="XOGURL"/>
<gel:parameter default="uxog" var="XOGusername"/>
<gel:parameter secure="true" var="XOGpassword"/>

<soap:invoke endpoint="${XOGURL}/niku/xog" var="xog_login">
<soap:message>
<soap-env:Envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xog="http://www.niku.com/xog">
<soap-env:Body>
<xog:Login xmlns="http://www.niku.com/xog">
<xog:Username>${XOGusername}</xog:Username>
<xog:Password>${XOGpassword}</xog:Password>
</xog:Login>
</soap-env:Body>
</soap-env:Envelope>
</soap:message>
</soap:invoke>

<gel:set asString="true" select="$xog_login/soap-env:Envelope/soap-env:Body/xog:SessionID/text()" var="sessionID"/>

<core:choose>

<core:when test="${sessionID == null}">
<gel:out>Couldn't Log in. Check the username/password.</gel:out>
</core:when>

<core:otherwise>
<core:catch var="errorVar">
<gel:setDataSource dbId="Niku"/>
</core:catch>

<sql:query var="rs">

<![CDATA[
select i.code
, i.name
from inv_investments i
inner join odf_ca_project o on o.id = i.id
where i.odf_object_code = 'PROJECT'
and o.eb_cron_autom = 1
and i.code = '00002648'
]]>

</sql:query>

<core:forEach items="${rs.rowsByIndex}" trim="true" var="row">

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

<soap-env:Body>

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd">
<Header action="write" externalSource="NIKU" objectType="project" version="12.1.1.1208"/>
<Projects>
<Project name="${row[1]}" projectID="${row[0]}">
</Project>
</Projects>
</NikuDataBus>

</soap-env:Body>
</soap-env:Envelope>
</soap:message>
</soap:invoke>

<gel:set asString="true" select="$XOG_result/soap-env:Envelope/soap-env:Body/XOGOutput/Status/@state" var="XOG_STATUS"/>
<core:switch on="${XOG_STATUS}">
<core:case value="SUCCESS">
<gel:log level="INFO"> Sucesso no XOG. Projeto ${row[0]}</gel:log>
</core:case>
<core:case value="FAILURE">
<gel:log level="ERROR">
Erro no XOG.
<gel:expr select="$XOG_result"/>
</gel:log>
</core:case>
</core:switch>

</core:forEach>

</core:otherwise>
</core:choose>

<soap:invoke endpoint="${XOGURL}/niku/xog" var="xog_logout">
<soap:message>
<soap-env:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xog="http://www.niku.com/xog">
<soap-env:Header>
<xog:Auth>
<xog:SessionID>${sessionID}</xog:SessionID>
</xog:Auth>
</soap-env:Header>
<soap-env:Body>
<xog:Logout/>
</soap-env:Body>
</soap-env:Envelope>
</soap:message>
</soap:invoke>

</gel:script>

 

Has anyone ever experienced this ?

Outcomes