SharePoint List macro {sp-list} Failed with "Error rendering macro {sp-list}: Unable to retrieve list"
Symptoms
When trying to add a SharePoint List macro {sp-list} in a page, it failed and display the following error message:
Error rendering macro {sp-list}: Unable to retrieve list AllItems.aspx
The following appears in the atlassian-confluence.log:
2012-02-01 11:55:03,169 ERROR [TP-Processor1] [extra.sharepoint.macros.SharePointListMacroRenderer] getColumns Unable to retrieve list AllItems.aspx -- url: /confluence/display/test/Home | page: 983042 | userName: admin | referer: http://wiki/confluence/pages/editpage.action?pageId=983042 | action: viewpage java.lang.RuntimeException: javax.xml.ws.WebServiceException: org.apache.cxf.interceptor.Fault: Could not send Message. at com.atlassian.confluence.extra.sharepoint.ws.WebServiceAccessorImpl.getList(WebServiceAccessorImpl.java:431) at com.atlassian.confluence.extra.sharepoint.macros.SharePointListMacroRenderer.getColumns(SharePointListMacroRenderer.java:278) at com.atlassian.confluence.extra.sharepoint.macros.SharePointListMacroRenderer.render(SharePointListMacroRenderer.java:184) at com.atlassian.confluence.extra.sharepoint.macros.SharePointListMacro.execute(SharePointListMacro.java:32) at com.atlassian.renderer.v2.macro.ResourceAwareMacroDecorator.execute(ResourceAwareMacroDecorator.java:51) .... Caused by: javax.xml.ws.WebServiceException: org.apache.cxf.interceptor.Fault: Could not send Message. at org.apache.cxf.jaxws.JaxWsClientProxy.invoke(JaxWsClientProxy.java:141) at $Proxy695.getList(Unknown Source) at com.atlassian.confluence.extra.sharepoint.ws.cxf.CXFListsServiceWrapper.getList(CXFListsServiceWrapper.java:304) at com.atlassian.confluence.extra.sharepoint.ws.WebServiceAccessorImpl.getList(WebServiceAccessorImpl.java:426) ... 255 more Caused by: org.apache.cxf.interceptor.Fault: Could not send Message. at org.apache.cxf.interceptor.MessageSenderInterceptor$MessageSenderEndingInterceptor.handleMessage(MessageSenderInterceptor.java:64) at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:236) at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:472) at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:302) at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:254) at org.apache.cxf.frontend.ClientProxy.invokeSync(ClientProxy.java:73) at org.apache.cxf.jaxws.JaxWsClientProxy.invoke(JaxWsClientProxy.java:123) ... 258 more Caused by: java.io.IOException: Not Found
Note the underlying cause exception is shown as:
Caused by: java.io.IOException: Not Found
Cause
The List name entered in the macro doesn't exist or incorrectly written. The common mistake is that when, let's say, you have a list in SharePoint:
| List name | Doc Lib List |
| URL of the List | http://mysharepoint/SiteDirectory/foobar/Doc%20Lib%20List/Forms/AllItems.aspx |
Then you entered the following as the List name in SharePoint List macro {sp-list}:
Doc%20Lib%20List/Forms/AllItems.aspx
Resolution
You will need to enter the List name instead of the List path from the SharePoint URL. For example, from the sample above, you will need to enter Doc Lib List as the list name when inserting SharePoint List macro {sp-list}.
Related articles