7.2 Error on Accessing BI Datasource from BI

[Former Member]

Hello

When I search for a tabel in the BI Datasource I get an error. See log an

Screenshot.

Pls see atached log.

Thx Sebastian

-

---

Show/Hide Details Error error 2010-09-06 13:26:00:345 VCSearchException:

[EXCEPTION]

com.sap.ds.core.services.search.VCSearchException: while trying to invoke the method java.util.Collection.iterator() of an object loaded from local variable 'c'... [see details] com.sap.search.SearchService

Log Record Details

[Collapse tray]

Message: VCSearchException:

[EXCEPTION]

com.sap.ds.core.services.search.VCSearchException: while trying to invoke the method java.util.Collection.iterator() of an object loaded from local variable 'c'

at com.sap.ip.vc.bi.search.BISearchProvider.search(BISearchProvider.java:297)

at com.sap.search.SearchService.sbiSearch(SearchService.java:866)

at com.sap.search.SearchService.search(SearchService.java:759)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.sap.ds.core.processor.impl.ServiceInstanceProcessor.processClientRequest(ServiceInstanceProcessor.java:233)

at com.sap.ds.core.processor.impl.ServiceInstanceProcessor.doProcessing(ServiceInstanceProcessor.java:104)

at com.sap.visualcomposer.servlet.ServiceChannel.doIt(ServiceChannel.java:35)

at com.sap.visualcomposer.servlet.FrontServlet.doAction(FrontServlet.java:46)

at com.sap.visualcomposer.servlet.FrontServlet.doPost(FrontServlet.java:26)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:152)

at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:38)

at com.sap.engine.services.servlets_jsp.server.servlet.InvokerServlet.service(InvokerServlet.java:217)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:152)

at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:38)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:400)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:203)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:438)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:427)

at com.sap.engine.services.servlets_jsp.filters.DSRWebContainerFilter.process(DSRWebContainerFilter.java:38)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.servlets_jsp.filters.ServletSelector.process(ServletSelector.java:80)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.servlets_jsp.filters.ApplicationSelector.process(ApplicationSelector.java:268)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.WebContainerInvoker.process(WebContainerInvoker.java:81)

at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.ResponseLogWriter.process(ResponseLogWriter.java:60)

at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.DefineHostFilter.process(DefineHostFilter.java:27)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.MonitoringFilter.process(MonitoringFilter.java:29)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.MemoryStatisticFilter.process(MemoryStatisticFilter.java:54)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.DSRHttpFilter.process(DSRHttpFilter.java:42)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.server.Processor.chainedRequest(Processor.java:447)

at com.sap.engine.services.httpserver.server.Processor$FCAProcessorThread.process(Processor.java:264)

at com.sap.engine.services.httpserver.server.rcm.RequestProcessorThread.run(RequestProcessorThread.java:56)

at com.sap.engine.core.thread.execution.Executable.run(Executable.java:122)

at com.sap.engine.core.thread.execution.Executable.run(Executable.java:101)

at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:328)

Caused by: java.lang.NullPointerException: while trying to invoke the method java.util.Collection.iterator() of an object loaded from local variable 'c'

at java.util.AbstractCollection.addAll(AbstractCollection.java:303)

at com.sap.ip.bi.sdk.dac.converter.udirelqv.RelationalObjectServices$NodeBase.search(RelationalObjectServices.java:244)

at com.sap.ip.bi.bics.objectservices.consumer.impl.nodes.OsConsumerNodeSystem.search(OsConsumerNodeSystem.java:309)

at com.sap.ip.vc.bi.search.BISearchProvider.search(BISearchProvider.java:239)

... 53 more

Date: Single Click Filter by Date 2010-09-06

Time: Single Click Filter by Time 13:26:00:345

Category: Single Click Filter by Category com.sap.search.SearchService

Location: Single Click Filter by Location com.sap.search.SearchService

Application: Single Click Filter by Application sap.com/VisualComposerServerEar05

Thread: Single Click Filter by Thread Thread[HTTP Worker [@1400383465],5,Dedicated_Application_Thread]

Data Source: j2ee\cluster\server0\log\defaultTrace_00.trc

Arguments:

DSR Transaction: Single Click Filter by DSR Transaction 5c3980a1b9a911dfb1a600000050b586

Message ID:

Session: Single Click Filter by Session 642

Transaction:

User: Single Click Filter by User adm_x72

Time Zone: Single Click Filter by Time Zone +0200

Customer Message Component: Single Click Filter by Customer Message Component EP-VC

DC Name: Single Click Filter by DC Name sap.com/core.dev

Correlation ID: Single Click Filter by Correlation ID 5289350000000004

DSR Root Context ID: Single Click Filter by DSR Root Context ID 47BFB5A9B9A811DF8BF300000050B586

DSR Connection: Single Click Filter by DSR Connection 5c3980a1b9a911dfb1a600000050b586

DSR Counter: Single Click Filter by DSR Counter 0

Host: Single Click Filter by Host FE0VM158

System: Single Click Filter by System X72

Instance: Single Click Filter by Instance J00

Node: Single Click Filter by Node server0

Log ID: Single Click Filter by Log ID 005056A67B2BE3EF0000000600001658

Show/Hide Details Error error 2010-09-06 13:26:00:345 [VC-DevServer][error in search BISearchProvider]while trying to invoke the method java.util.Collection.iterator() of an object loaded from local variable 'c' com.sap.search.SearchService

Edited by: Sebastian Lenk on Sep 6, 2010 2:14 PM

[former_member203343]

Hi,

1. Does your BI system (in the portal system landscape pass the connection test?

2. What kind of BI system? Is it a BI JDBC system or a BW system?

3. When exactly does this problem occur? When selecting the BI entry in VC drop down? When dragging the service to the storyboard?

Regards,

Natty

[Former Member]

Hello Natty,

1. yes the test passed. http://picasaweb.google.de/lh/photo/kcDy5FofEl9VT4jw2m6FZQ?feat=directlink

2. Yes, I try to access a regular oracle DB via JDBC.

3. The Error occurs when I'select the Datasource and entered a table name and then click the search button. http://picasaweb.google.de/lh/photo/iYPCjcdqIclUet1cNj-LNQ?feat=directlink

Thx for Help

Sebastian

[former_member203343]

Hi Sebastian,

In this case, I suggest you open a support ticket and attach the defaultTrace files from the time this occured. This is a little to complex for a forum thread...

Regards,

Natty

[Former Member]

Hello Natty,

Ok. I've already created one yesterday. It is 725470 / 2010.

It would be nice if you can accelerate the ticket handling a little bit.

Best Regards

Sebastian

[former_member203343]

Hi Sebastian,

Your message is on my colleague Talia's name. You are in good hands

Regards,

Natty