Hi,

I am trying to create a conenction between Sharepoint 2007 and webfocus.

The web service for sharepoint has been created.

But, when i try to pull the sharepoint data from the MFD its giveing me the error below:

1. (FOC44537) SOAP Request: htRecv got Local error : 1

Sometimes i am getting the error below:

2. Unknown error occurred. Agent on reporting server ENTADHW1 may have crashed. Please investigate reporting server log.

MFD CODE:

FILENAME=M6ILO, SUFFIX=SOAP , $
SEGMENT=GETLISTITEMS, SEGTYPE=S0, $
GROUP=GETLISTITEMS, ALIAS=GetListItems, ELEMENTS=5, $
$FIELDNAME=LISTNAME, ALIAS=listName, USAGE=A30, ACTUAL=A30, ACCESS_PROPERTY=(NEED_VALUE), $

FIELDNAME=LISTNAME, ALIAS=listName, USAGE=A50, ACTUAL=A50, XDEFAULT='{6XXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}',ACCESS_PROPERTY=(NEED_VALUE), $

FIELDNAME=QUERY, ALIAS=query, USAGE=A30, ACTUAL=A30, $
$FIELDNAME=VIEWFIELDS, ALIAS=viewFields, USAGE=A30, ACTUAL=A30, $
FIELDNAME=ROWLIMIT, ALIAS=rowLimit, USAGE=A30, ACTUAL=A30, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=QUERYOPTIONS, ALIAS=queryOptions, USAGE=A30, ACTUAL=A30, $
FIELDNAME=WEBID, ALIAS=webID, USAGE=A30, ACTUAL=A30, ACCESS_PROPERTY=(NEED_VALUE), $
FIELDNAME=__RESPONSE, USAGE=TX80L, ACTUAL=TX, ACCESS_PROPERTY=(INTERNAL), $
SEGMENT=RESPONSE, SEGTYPE=S0, SEGSUF=XML , PARENT=GETLISTITEMS, POSITION=__RESPONSE, $
FIELDNAME=RESPONSE, ALIAS=GetListItemsResponse, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), $
FIELDNAME=GETLISTITEMSRESULT, ALIAS=GetListItemsResult, USAGE=A30, ACTUAL=A30,
REFERENCE=RESPONSE, PROPERTY=ELEMENT,$

FIELDNAME=LISTITEMS, ALIAS=listitems, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=RESPONSE, PROPERTY=ELEMENT,$
FIELDNAME=DATA, ALIAS=data, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=RESPONSE, PROPERTY=ELEMENT,$
SEGMENT=ROW, SEGTYPE=S0, PARENT=RESPONSE,$
FIELDNAME=ROW, ALIAS=row, USAGE=A1, ACTUAL=A1, ACCESS_PROPERTY=(INTERNAL), REFERENCE=DATA, PROPERTY=ELEMENT,$

FIELDNAME=Name, ALIAS=ows_LinkFilename, USAGE=A255, ACTUAL=A255, REFERENCE=ROW, PROPERTY=ATTRIBUTE,$
FIELDNAME=Client_Team, ALIAS=ows_Client_x0020_Team, USAGE=A255, ACTUAL=A255, REFERENCE=ROW, PROPERTY=ATTRIBUTE,$



ACX CODE:

SEGNAME=GETLISTITEMS, CONNECTION=SharePoint_AP, VERSION=1.1,
OBJECT=GetListItems,
ACTION=http://schemas.microsoft.com/sharepoint/soap/GetListItems,
TARGETNS=http://schemas.microsoft.com/sharepoint/soap/, STYLE=DOCUMENT,
ELEMFORM=qualified, ATTRFORM=unqualified, $



I am using the code below to pull data from MFD:

TABLE FILE CS_GETLISTITEMS
PRINT
Name
Client_Team
WHERE LISTNAME EQ '6XXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX';
END

Please let me know how to go about it and let me know what might be the issue. Any help would be greatly appreciated.

Thanks,
Yashwins

This message has been edited. Last edited by: Kerry,

Hi,

Any updates from anybody on this post?

Any help would be great!

Thanks,
yashwins

Hi Yashwins,

For configuration issues, it should be addressed by a case with Customer Support Services. Please call 1-800-736-6130, or access online at InfoResponse.

Cheers,
Kerry