Skip to Content
0
Nov 17, 2019 at 02:08 PM

Error while adding csv as a datasource in SAP designer studio

49 Views Last edit Nov 17, 2019 at 02:36 PM 2 rev

Hi Experts,

Can someone suggest why am I getting this error message while importing any .csv file as a datasource in SAP Business objects designer studio.Version of sap designer studio is 16.4.1

I have added the screenshots as well,please advise.

Error message:

"BI exception with class "BicsResourceFileRuntimeException" and message "Unexpected exception". See default trace for log ID "3364c68b-4a7a-416c-a9c6-68f57f87e95a"."

Stack trace error:

com.sap.ip.bi.bics.dataaccess.resource.impl.file.exceptions.BicsResourceFileRuntimeException: Unexpected exception
at com.sap.ip.bi.bics.dataaccess.resource.impl.file.csv.CSVRelationalProvider.readFull(CSVRelationalProvider.java:271)
at com.sap.ip.bi.bics.dataaccess.resource.impl.file.csv.CSVRelationalProvider.initialization(CSVRelationalProvider.java:205)
at com.sap.ip.bi.base.application.impl.ServiceManagement.registerService(ServiceManagement.java:776)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createService(ServiceManagement.java:397)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createService(ServiceManagement.java:365)
at com.sap.ip.bi.base.application.impl.Application.createService(Application.java:495)
at com.sap.ip.bi.base.application.service.base.BaseServiceDescription.createService(BaseServiceDescription.java:142)
at com.sap.ip.bi.bics.dataaccess.provider.relational.impl.rel2queryview.Rel2QueryView.isApplicable(Rel2QueryView.java:315)
at com.sap.ip.bi.base.application.impl.ServiceManagement.checkAndCreateService(ServiceManagement.java:720)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createMultipleServicesByGroup(ServiceManagement.java:587)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createMultipleServices(ServiceManagement.java:515)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createService(ServiceManagement.java:384)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createService(ServiceManagement.java:365)
at com.sap.ip.bi.base.application.impl.Application.createService(Application.java:495)
at com.sap.ip.bi.base.application.service.base.BaseServiceDescription.createService(BaseServiceDescription.java:142)
at com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.SelectionObject.isApplicable(SelectionObject.java:552)
at com.sap.ip.bi.base.application.impl.ServiceManagement.checkAndCreateService(ServiceManagement.java:720)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createMultipleServicesByGroup(ServiceManagement.java:551)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createMultipleServices(ServiceManagement.java:515)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createService(ServiceManagement.java:384)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createService(ServiceManagement.java:365)
at com.sap.ip.bi.base.application.impl.Application.createService(Application.java:495)
at com.sap.ip.bi.base.application.service.base.BaseServiceDescription.createService(BaseServiceDescription.java:142)
at com.sap.ip.bi.webapplications.dataproviders.selector.impl.WdpSelector$1.call(WdpSelector.java:338)
at com.sap.ip.bi.webapplications.dataproviders.selector.impl.WdpSelector$1.call(WdpSelector.java:1)
at com.sap.ip.bi.webapplications.runtime.impl.page.groups.DataSourceGroup$QueuedTask.execute(DataSourceGroup.java:269)
at com.sap.ip.bi.webapplications.runtime.impl.page.groups.DataSourceGroup$Worker.run(DataSourceGroup.java:234)
at com.sap.ip.bi.webapplications.runtime.impl.page.groups.DataSourceGroup.executeSynchron(DataSourceGroup.java:123)
at com.sap.ip.bi.webapplications.runtime.impl.page.groups.DataSourceGroup.processGroupSynchronNowForCompatibilityReasons(DataSourceGroup.java:195)
at com.sap.ip.bi.webapplications.runtime.impl.page.groups.DataSourceGroup.queueTask(DataSourceGroup.java:84)
at com.sap.ip.bi.webapplications.dataproviders.selector.impl.WdpSelector.doInit(WdpSelector.java:329)
at com.sap.ip.bi.webapplications.runtime.object.page.impl.PageObject.init(PageObject.java:284)
at com.sap.ip.bi.webapplications.runtime.object.provider.impl.Provider.init(Provider.java:37)
at com.sap.ip.bi.webapplications.runtime.impl.page.processor.PageStateProcessor.initPageObject(PageStateProcessor.java:2658)
at com.sap.ip.bi.webapplications.runtime.impl.page.processor.PageStateProcessor.setupPageObject(PageStateProcessor.java:1937)
at com.sap.ip.bi.webapplications.runtime.impl.page.processor.PageStateProcessor.createPageObject(PageStateProcessor.java:1894)
at com.sap.ip.bi.webapplications.runtime.impl.page.processor.PageCommandProcessor.doCreateDataProviderCommand(PageCommandProcessor.java:717)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.doCreateDataProviderCommand(Page.java:6066)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.sap.ip.bi.util.MethodInvoker.callMethod(MethodInvoker.java:155)
at com.sap.ip.bi.webapplications.runtime.service.command.CommandProcessorHelper.processCommand(CommandProcessorHelper.java:425)
at com.sap.ip.bi.webapplications.runtime.service.command.CommandProcessorHelper.processCommand(CommandProcessorHelper.java:340)
at com.sap.ip.bi.webapplications.runtime.processor.CommunicationProcessor.processCommand(CommunicationProcessor.java:241)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.processCommandSuper(Page.java:5104)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.processCommandInternal(Page.java:4687)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.processCommandSequence(Page.java:4858)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.doProcessRequest(Page.java:2585)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page._processRequest(Page.java:863)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.processRequest(Page.java:5358)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.processRequest(Page.java:5351)
at com.sap.ip.bi.webapplications.runtime.impl.controller.Controller.doProcessRequest(Controller.java:1228)
at com.sap.ip.bi.webapplications.runtime.impl.controller.Controller._processRequest(Controller.java:1084)
at com.sap.ip.bi.webapplications.runtime.impl.controller.Controller.processRequest(Controller.java:1050)
at com.sap.ip.bi.webapplications.runtime.impl.controller.Controller.processRequest(Controller.java:1)
at com.sap.ip.bi.server.runtime.sevice.impl.BIRuntimeServerService._handleRequest(BIRuntimeServerService.java:822)
at com.sap.ip.bi.server.runtime.sevice.impl.BIRuntimeServerService.handleRequest(BIRuntimeServerService.java:1205)
at com.sap.ip.bi.server.execution.engine.runtime.LocalBIExecutionService.executeRequest(LocalBIExecutionService.java:34)
at com.sap.ip.bi.zen.rt.client.handler.designer.LocalExecutionAdapter.executeRequest(LocalExecutionAdapter.java:39)
at com.sap.ip.bi.zen.rt.client.handler.RuntimeRequestHandler.handleRequest(RuntimeRequestHandler.java:28)
at com.sap.ip.bi.zen.rt.client.handler.designer.DesignerRuntimeRequestHandler.handleRequest(DesignerRuntimeRequestHandler.java:33)
at com.sap.ip.bi.zen.rt.client.handler.MainHandler.executeBiRequest(MainHandler.java:75)
at com.sap.ip.bi.zen.rt.client.handler.MainHandler.handleRegularRequest(MainHandler.java:59)
at com.sap.ip.bi.zen.rt.client.handler.MainHandler.handleRequest(MainHandler.java:35)
at com.sap.ip.bi.zen.rt.client.handler.PathHandler.handleRequest(PathHandler.java:54)
at com.sap.ip.bi.zen.rt.client.handler.designer.DesignerPathHandler.handleRequest(DesignerPathHandler.java:57)
at com.sap.ip.bi.zen.rt.client.handler.AbstractSupportabilityHandler.handleRequest(AbstractSupportabilityHandler.java:25)
at com.sap.ip.bi.zen.rt.client.handler.AbstractFrontServlet.handleRequest(AbstractFrontServlet.java:46)
at com.sap.ip.bi.zen.rt.client.handler.AbstractFrontServlet.handleRequest(AbstractFrontServlet.java:42)
at com.sap.ip.bi.zen.rt.client.handler.AbstractFrontServlet.doPost(AbstractFrontServlet.java:19)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyServlet.service(HttpServiceRuntimeImpl.java:1271)
at org.eclipse.equinox.http.servlet.internal.registration.EndpointRegistration.service(EndpointRegistration.java:162)
at org.eclipse.equinox.http.servlet.internal.servlet.ResponseStateHandler.processRequest(ResponseStateHandler.java:63)
at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl.doDispatch(HttpServiceRuntimeImpl.java:413)
at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl.doDispatch(HttpServiceRuntimeImpl.java:365)
at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl.doDispatch(HttpServiceRuntimeImpl.java:204)
at org.eclipse.equinox.http.servlet.internal.servlet.ProxyServlet.processAlias(ProxyServlet.java:91)
at org.eclipse.equinox.http.servlet.internal.servlet.ProxyServlet.service(ProxyServlet.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:356)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
at sap-design-studio-error.jpgorg.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:497)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
at java.lang.Thread.run(Thread.java:812)
Caused by: com.sap.ip.bi.bics.dataaccess.resource.impl.file.exceptions.BicsResourceFileRuntimeException: Metadata section expected
at com.sap.ip.bi.bics.dataaccess.resource.impl.file.csv.CSVRelationalProvider.decodeHeader(CSVRelationalProvider.java:376)
at com.sap.ip.bi.bics.dataaccess.resource.impl.file.csv.CSVRelationalProvider.readFull(CSVRelationalProvider.java:238)
... 99 more

Attachments