InforBI setup on landmark v11

unknown

Has anyone connected infor bi (v11)  to landmark v11? we are keep getting the error. below is what i see in landmark exception.

when we ran create cube ltm it created cubes in infor bi server but now it wont update/refresh any of the cubes.

 

 

Wed Jul 11 16:34:52 CDT 2018 - (Logged by SystemID: 14280@LMRKSVR, environment data area: GEN, data area: lmfintest) Start Exception ID: 09627836-2680-8000-0000-0e915b3e7e88
com.lawson.dataservices.alea.soap.AleaConnectionException: Exception encountered during a discover datasources request to the Infor BI server.  Count tries: 1
 at com.lawson.dataservices.alea.soap.SOAPSession.executeConnectionRequest(SOAPSession.java:416)
 at com.lawson.dataservices.alea.soap.SOAPSession.doDataSourceForTenantsApplicationRequest(SOAPSession.java:263)
 at com.lawson.dataservices.alea.read.ReadAleaCube.getDataSource(ReadAleaCube.java:190)
 at com.lawson.dataservices.alea.create.AleaImport.connectToDataModel(AleaImport.java:117)
 at com.lawson.rdtech.analytics.alea.AleaSessionPoolableObjectFactory.makeObject(AleaSessionPoolableObjectFactory.java:175)
 at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source)
 at com.lawson.rdtech.analytics.alea.AleaSessionPool.borrowAleaSession(AleaSessionPool.java:97)
 at com.lawson.rdtech.analytics.alea.AleaUtility.borrowSessionFromPool(AleaUtility.java:165)
 at com.lawson.rdtech.analytics.alea.ReadCubeAlea.setReadCubeArguments(ReadCubeAlea.java:952)
 at com.lawson.rdtech.analytics.alea.ReadCubeAlea.getCubeDataArray(ReadCubeAlea.java:247)
 at com.lawson.rdtech.analytics.alea.Alea.getCubeDataArray(Alea.java:147)
 at com.lawson.rdtech.framework.BusinessObjectEvaluator.getCubeSlice(BusinessObjectEvaluator.java:6302)
 at com.lawson.rdtech.framework.BusinessObjectEvaluator.areMeasureValuesBlank(BusinessObjectEvaluator.java:6077)
 at com.lawson.rdtech.framework.PagingOPFSortedSet$DataViewIterator.hasNext(PagingOPFSortedSet.java:334)
 at com.lawson.rdtech.framework.PagingService.fillOutNextPage(PagingService.java:1320)
 at com.lawson.rdtech.framework.PagingService.nextPage(PagingService.java:542)
 at com.lawson.rdtech.framework.PagingService.unsynchedFirstPage(PagingService.java:230)
 at com.lawson.rdtech.framework.PagingService.firstPage(PagingService.java:210)
 at com.lawson.rdtech.framework.AbstractBusinessTask._firstPage(AbstractBusinessTask.java:954)
 at com.lawson.rdtech.framework.BusinessClassEvaluator.procKeyDimension(BusinessClassEvaluator.java:5904)
 at com.lawson.rdtech.framework.BusinessClassEvaluator.getCubeSet(BusinessClassEvaluator.java:5257)
 at com.lawson.rdtech.framework.BusinessClassEvaluator.getListSet(BusinessClassEvaluator.java:6650)
 at com.lawson.rdtech.framework.BusinessClassEvaluator.getListSet(BusinessClassEvaluator.java:6570)
 at com.lawson.rdtech.framework.BusinessClassEvaluator.getListSet(BusinessClassEvaluator.java:4823)
 at com.lawson.rdtech.gridadapter.ldt.GridContainer.getListSet(GridContainer.java:1066)
 at com.lawson.rdtech.gridadapter.ldt.IServiceImpl.getListSet(IServiceImpl.java:1587)
 at sun.reflect.GeneratedMethodAccessor96.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at com.lawson.grid.proxy.ProxyServerImpl$ProxyRequestThread.invoke(ProxyServerImpl.java:3192)
 at com.lawson.grid.proxy.ProxyServerImpl$ProxyRequestThread.processRequest(ProxyServerImpl.java:2927)
 at com.lawson.grid.proxy.ProxyServerImpl$ProxyRequestThread.runThread(ProxyServerImpl.java:2850)
 at com.lawson.grid.util.thread.PooledThread.run(PooledThread.java:135)
 at java.lang.Thread.run(Thread.java:748)
Caused by: com.lawson.dataservices.alea.soap.SOAPClientException: Error parsing XMLA response from OLAP Server (SAXParseException): Premature end of file.  Line: 0, Column: -1
 at com.lawson.dataservices.alea.soap.SOAPResponse.parseXmlaResponse(SOAPResponse.java:643)
 at com.lawson.dataservices.alea.soap.SOAPSession.executeConnectionRequest(SOAPSession.java:359)
 ... 33 more
Caused by: org.xml.sax.SAXParseException; Premature end of file.
 at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
 at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
 at com.lawson.dataservices.alea.soap.SOAPResponse.parseXmlaResponse(SOAPResponse.java:631)

russel-cornelson

Good morning Vipul; just so it's here on the community is this the issue where we had a problem connecting to the certificate on InforBI?



I believe we added this line:

-Djavax.net.debug=all



To the grid nodes for the interactive node/batch node which was making the call out to Infor BI and ultimately determined that we were dealing with a certificate issue on the Infor BI side. I figured I would add that here in case anyone else in the community gets the same error.