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 displayed 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 FoundNote the underlying cause exception is shown as:
Caused by: java.io.IOException: Not FoundCause
The List name entered in the macro doesn't exist or is 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.aspxResolution
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}.