Error when trying to create outbound for a table in business model

Question

When we try to make outbound for a random table in business model, the following error occur:

 

Error while attempt to generate model

Apache Tomcat/7.0.50 - Error report

HTTP Status 500 - it.eng.spagobi.commons.dao.SpagoBIDAOException: An unexpected error occured while saving model content [Content [id=null, fileName=8035 .sbimodel, creationDate=Wed Jan 31 15:50:13 EET 2018, active=null, dimension=null, creationUser=biadmin]]

type Exception report

message it.eng.spagobi.commons.dao.SpagoBIDAOException: An unexpected error occured while saving model content [Content [id=null, fileName=8035 .sbimodel, creationDate=Wed Jan 31 15:50:13 EET 2018, active=null, dimension=null, creationUser=biadmin]]

description The server encountered an internal error that prevented it from fulfilling this request.

exception

javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

root cause

java.sql.SQLException: Software caused connection abort: socket write error

org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)

org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)

org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)

org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)

org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)

org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:713)

org.hibernate.impl.SessionImpl.save(SessionImpl.java:701)

org.hibernate.impl.SessionImpl.save(SessionImpl.java:697)

it.eng.spagobi.tools.catalogue.dao.MetaModelsDAOImpl.insertMetaModelContent(MetaModelsDAOImpl.java:613)

it.eng.knowage.meta.service.MetaService.generateModel(MetaService.java:262)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

java.lang.reflect.Method.invoke(Unknown Source)

org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)

org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:294)

org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:248)

org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:235)

org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:398)

org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:205)

org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:228)

org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)

org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)

javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.50 logs.

Apache Tomcat/7.0.50

Answer 1

Hi,

from what I see in the error it seems that this is happening in the generation of the datamart, so not strictly related to the creation of an outbound relationship. The error says that there is some problem writing the final result (the datamart) on the Knowage database. What DBMS are you using for the Knowage metadata database? Also the problem could be caused by a network problem.