AnsweredAssumed Answered

Too many app sessions when Xogging

Question asked by Jack on May 12, 2011
Latest reply on May 30, 2011 by mansriva
Hi, All
I'm using below code to xog (partially I pasted the gel code). Once the xog completed, I can see 32 active sessions in cmn_sessions table. I used two different ways to xog and there is no difference in each way.

(i) Create separate sessions as in below code to xog the file
(ii) Create only one session and complete the xog at one shot; But, no use in either way.

Apart from this, I have tried with logout tags to clear the sessions. No benefit at all. Tell me what I missed.

For your information, the project.xml contains 4 records, resource.xml contains 1 record and user.xml also contains 1 record. No error in bg-system.log or from Gel output.
<gel:include select="$project"/> 
<gel:serialize fileName="project.xml" var="${project}"/>

<gel:include select="$resource"/> 
<gel:serialize fileName="resource.xml" var="${resource}"/>

<gel:include select="$user"/> 
<gel:serialize fileName="user.xml" var="${user}"/>


        <soap:invoke endpoint="http://${xogserver}:80/niku/xog" var="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>${XOGusername}</xog:Username> 
                                                <xog:Password>${XOGpassword}</xog:Password> 
                                        </xog:Login> 
                                        <gel:parse var="xmlindoc" file="project.xml"/> 
                                        <gel:include select="$xmlindoc"/> 
                                </soapenv:Body> 
                        </soapenv:Envelope> 
                </soap:message> 
        </soap:invoke> 
<gel:out><gel:expr select="$auth"/></gel:out> 

        <soap:invoke endpoint="http://${xogserver}:80/niku/xog" var="auth2"> 
                <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>${XOGusername}</xog:Username> 
                                                <xog:Password>${XOGpassword}</xog:Password> 
                                        </xog:Login> 
                                        <gel:parse var="xmlindoc2" file="resource.xml"/> 
                                        <gel:include select="$xmlindoc2"/> 
                                </soapenv:Body> 
                        </soapenv:Envelope> 
                </soap:message> 
        </soap:invoke> 
<gel:out><gel:expr select="$auth2"/></gel:out> 

        <soap:invoke endpoint="http://${xogserver}:80/niku/xog" var="auth3"> 
                <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>${XOGusername}</xog:Username> 
                                                <xog:Password>${XOGpassword}</xog:Password> 
                                        </xog:Login> 
                                        <gel:parse var="xmlindoc3" file="users.xml"/> 
                                        <gel:include select="$xmlindoc3"/> 
                                </soapenv:Body> 
                        </soapenv:Envelope> 
                </soap:message> 
        </soap:invoke> 
<gel:out><gel:expr select="$auth3"/></gel:out> 
</gel:script> 

Outcomes