topic Site Manager - There was an error loading the data in Alfresco Archive

Site Manager - There was an error loading the data

agu84 — Thu, 18 Jun 2015 12:48:35 GMT

Hi,i have a problem with displaying data under Site Manager. I'm getting "There was an error loading the data" and nothing more. In server logs there are messages like this:14:17:06,418 ERROR [freemarker.runtime] [http-apr-8080-exec-18] Error executing FreeMarker templateFreeMarker template error:Th

Re: Site Manager - There was an error loading the data

borisstankov — Mon, 22 Jun 2015 06:51:21 GMT

Hi there,

When the error masseges stared to show up:
- Have you did something that caused them - any actions on the file system where is the alfresco installation?
- Any other actions like upgrade procedures or changing any varialble, custom code enabled?

Basically this is how this "site-admin-sites.get.json.ftl" file should look like:


<#import "../generic-paged-results.lib.ftl" as gen/>

<#macro siteJSON item>
<#escape x as jsonUtils.encodeJSONString(x)>
                   "url" : "${url.serviceContext + "/api/sites/" + item.siteInfo.shortName}",
                   "sitePreset" : "${item.siteInfo.sitePreset}",
                   "shortName" : "${item.siteInfo.shortName}",
                   "title" : "${item.siteInfo.title}",
                   "description" : "${item.siteInfo.description}",
                   "createdDate" : "${xmldate(item.siteInfo.createdDate)}",
                   "lastModifiedDate" : "${xmldate(item.siteInfo.lastModifiedDate)}",
                   "visibility" : "${item.siteInfo.visibility}",
                   "userIsSiteManager" : "${item.currentUserSiteManager?c}",
                   "siteManagers" : [
                        <#list item.members as manager>
                       {
                           "entry" : {
                               "userName" : "${manager.userName}",
                               "firstName" : "${manager.firstName}",
                               "lastName" : "${manager.lastName}"
                           }
                       }<#if manager_has_next>,</#if>
                        </#list>
                   ]    
</#escape>
</#macro>

{
   <@gen.standardRestfulPagedResults data=data ; item>
          <@siteJSON item=item /> 
   </@gen.standardRestfulPagedResults>
}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

And that's it, which could means that you are missing something from the file or the whole file, I can't explain why else you will see such an error.
Here is the GIThub link for the file:
https://github.com/Alfresco/community-edition/blob/master/projects/remote-api/config/alfresco/templates/webscripts/org/alfresco/repository/site/site-admin-sites.get.json.ftl

I do not know in which .jar file is located this .ftl file, but if you find it, check what's in it.

Cheers.

Re: Site Manager - There was an error loading the data

agu84 — Mon, 22 Jun 2015 07:52:01 GMT

Hi,

thanks for your response.

<blockcode>Have you did something that caused them - any actions on the file system where is the alfresco installation? </blockcode>

no i didn't

<blockcode>Any other actions like upgrade procedures or changing any varialble, custom code enabled</blockcode>

i've modified alfresco-global.properties file to set ldap auth.

Yes, i noticed that the file is missing and meantime i also found it on github, but don't know where to put it in the alfresco catalog structure 😕
I have alfresco 5.0.c version and there is no such structure like config/alfresco/templates/webscripts/org/alfresco/repository/site/
I newbie in alfresco, could you please guide me and tell where to put this missing files?

Best Regards

Re: Site Manager - There was an error loading the data

borisstankov — Mon, 22 Jun 2015 12:15:48 GMT

well, the file is not missing. It's in one of the .jar files and it loads itself when you restart the alfresco service.

I do not know in which .jar file is it, I tried to find some info about the file, but without success. So maybe someone else is more familiar with it or with your error message.

Re: Site Manager - There was an error loading the data

sharifu — Mon, 12 Oct 2015 10:22:00 GMT

i get this same issue on 5.0.d. i done `grep -ri site-admin-sites.get.json.ftl *` under tomcat which returns

Binary file webapps/alfresco/WEB-INF/lib/alfresco-remote-api-5.0.d.jar matches

I extracted this jar and found no files with that name.

Can i place this file under tomcat/shared/classes? if so which directory?

Re: Site Manager - There was an error loading the data

jherioux — Thu, 28 Apr 2016 13:43:10 GMT

Hello,

I just ran into this same problem with 5.1 General Relase 201602. Like you, I had the exact same error and started looking for missing files. However, just before deciding I wanted to try to dig down and recreate the missing file, I noticed the ${manager.lastName} variable at the beginning of the error and decided to investigate.

I noticed you mentioned that you had configured LDAP authentication, which I had also done. I was able to add the users fine, but my installation broke after I started adding users to sites. What I eventually found out is that there are no files missing that need to be replaced. The problem is that the ${manager.lastName} variable is coming up null due to the fact if a user was imported via LDAP and does not have BOTH a first and last name. Had the user been created in Alfresco, not having a last name would have been fine, but this is not the case with LDAP.

Having an LDAP user with either a first or last name in Alfresco is okay until you add the user as the manager of a site (and possibly other sites, but haven't tested).

To fix the issue, simply add a last (or first) name to the user in LDAP, re-sync your LDAP Alfresco user profiles by restarting the alfresco service, and you should be all set to go! Of course, do this for all users without a first and last name. For example, I had a user called "Shipping" which I renamed to "Shipping ." in LDAP. The user will never know the difference, and I can use Alfresco as intended.

Cheers