Errors while attempting to load the datasource Error while getting structure of data source by id

Question

Hi there,

When attempting to open up Meta Web to build a meta model from scratch from a data source that I know works and have used to build a meta model before, I have been receiving the following error:

Errors while attempting to load the datasource: Error while getting structure of data source by id

On top of that, I am receiving " Error An unexpected error occured while initializing cache" when attempting to open the existing business model that works just fine on my other machine. Does anyone know why I might be receiving these errors? Thank you in advance for taking a look!

Chris

LOGS:

[http-nio-8543-exec-7] 14 Nov 2018 10:46:16,693 ERROR it.eng.spagobi.tools.dataset.service.SelfServiceDatasetAction.getParameters:156 - CacheException catched:
it.eng.spagobi.tools.dataset.cache.CacheException: An unexpected error occured while initializing cache
    at it.eng.spagobi.tools.dataset.cache.SpagoBICacheManager.initializeCache(SpagoBICacheManager.java:68)
    at it.eng.spagobi.tools.dataset.cache.SpagoBICacheManager.getCache(SpagoBICacheManager.java:44)
    at it.eng.spagobi.tools.dataset.service.SelfServiceDatasetAction.buildQbeEditFromFederationServiceUrl(SelfServiceDatasetAction.java:356)
    at it.eng.spagobi.tools.dataset.service.SelfServiceDatasetAction.getParameters(SelfServiceDatasetAction.java:110)
    at org.apache.jsp.WEB_002dINF.jsp.tools.workspace.workspaceManagement_jsp._jspService(workspaceManagement_jsp.java:383)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
 

[http-nio-8543-exec-2] 14 Nov 2018 10:32:29,931 ERROR it.eng.spagobi.rest.interceptors.RestExceptionMapper.toResponse:59 - Catched service error:
it.eng.spagobi.utilities.exceptions.SpagoBIRestServiceException: Error while getting structure of data source by id
    at it.eng.spagobi.api.v2.DataSourceResource.getDataSourceStruct(DataSourceResource.java:333)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  

logs abbr due to character limit, let me know if more would be useful

Comments

Could you please post the entire log somewhere (ie. pastebin.com)? Also what database is the datasource using?

---

Hi mcortella,

Thank you for your quick response - I am using postgresql and it turned out I was using an outdated driver. I downloaded 42.2.5.jar and my issue was resolved. Thanks again!

Chris