Error getting list of users

[Former Member]

Hi All,

I have a transaction for getting the list of users and sending mail to them. I have used XML query to get the list of users using the following URL:

"http://<server:port>/XMII/Illuminator?Service=Admin&Mode=UserList&Group=XMII Administrators&Content-Type=text/xml".

When I am executing the transaction from Workbench, I am getting the list of users but if I run the transaction using a scheduler, I am getting the following as output of XML query.

<?xml version="1.0" encoding="UTF-8"?>

<Rowsets DateCreated="2009-07-14T06:17:51" EndDate="2009-07-14T06:17:51" StartDate="2009-07-14T06:17:51" Version="12.0.4 Build(120)"><FatalError>Premature end of file.</FatalError></Rowsets>

I have added the the necessary roles to Admin service(System Security).

What could be the reason for this??

Thanks,

Sophila

[jcgood25 · Accepted solution]

Sophila - from the WB you are already logged in so the URL works, but from the scheduler there is no user account to permit this fully qualified http request, so the premature end of file error is because the XMLQuery is expecting Rowsets/Rowset/Row xml back but gets the NW login page instead.

Either pass the necessary credentials into the TRX through the scheduler parameters and append them into the URL in your XMLQuery dynamically or just add them as static: &IllumLoginName=XXX&IllumLoginPassword=XXX (this will need to be a user with permission to the Admin service).

[Former Member · Accepted solution]

Thanks Jeremy, It worked!

[Former Member]

Sophila,

You can do this by other way also. Load the User xml file available in root folder in transaction and send the mails to them.

In your current case it may be due to : Not availability of XML file or some spaces in xml file or not closing the tags currectly.

-Suresh