ERROR UPDATING DATASET

[former_member222570]

Hi everyone.

First of all, I apologize for the extension. Keep calm and read ;-D.

ticket 2014-11-04.txt.zip

[Henry_Banks · Accepted solution]

please could you elaborate the problem by putting the text here?

clicking on a .txt.zip doesn't inspire much confidence.. could be malicious.

also, is this already being processed by technical support ticket?

Regards,

H

[former_member222570 · Accepted solution]

ZIP extensión is by default. The original file is in TXT. You can open it with all security.

Regards.

[former_member222570 · Accepted solution]

I have problems putting the text here, copying from the file.

[Henry_Banks · Accepted solution]

please can you summarise the problem? i.e. what is the symptom?

-  something to do with Merged datasets, then visualisations get corrupted when data files get updated?

regards,

H

[former_member222570 · Accepted solution]

There are 2 datasets : SOLMAN and HOURS.

Both are merged.

SOLMAN is loaded from FILE A.

HOURS is loaded from FILE B.

Now I have 2 new files :

- FILE C (more recently than FILE A, same structure).

- FILE D (more recently than FILE B, same estructure).

I upgrade the connection in the main window to FILE C instead of FILE A.

Then I enter into the dataset SOLMAN and press UPDATE.

At that time is when error is prompted.

Regards.

[achab · Accepted solution]

Hey Sergio,

Can you attach Lumira full log file? Let me know if I did not pass you the procedure yet.

Thanks

Antoine

[former_member222570]

sorry.

TraceLog_15972_2014_11_04_11_13_00_385_trace.txt.zip

[achab]

Thanks Sergio. Does the log contain the operation that failed? In case it is not, to generate a clean log file:

1. Close Lumira

2. Open Lumira and re-do the operations up to the error

3. Close Lumira

4. Take the latest generated log file.

For the moment I do not see any error logged in the log file.

Thanks & regards

Antoine

[former_member222570]

Herewith joined last log archive.

Regards.

Sergio.

TraceLog_11168_2014_11_04_16_57_25_308_trace.TXT.zip

[achab]

Thanks

Do you have the file HORAS_CODORNIU_201410.xlsx in folder C:\smasjuan\meus\SAP\SAP LUMIRA\dades?

Unable to find file "C:\smasjuan\meus\SAP\SAP LUMIRA\dades\HORAS_CODORNIU_201410.xlsx"

2014/11/04 17:01:59.550000|>>|S| |11168|  60| |||||||||||||||[com.sap.hilo.orchestration.workspace.internal.refresh.DataSetRefreshAsyncTask]Asynchronous refresh of dataset has failed

com.sap.hilo.model.datasource.DataSourceException: Unable to find file "C:\smasjuan\meus\SAP\SAP LUMIRA\dades\HORAS_CODORNIU_201410.xlsx"

  at com.sap.hilo.datasource.excelevents.internal.ExcelEventsEngine.<init>(ExcelEventsEngine.java:353)

  at com.sap.hilo.datasource.excelevents.internal.ExcelEventsDataSource.createEngine(ExcelEventsDataSource.java:37)

  at com.sap.hilo.datasource.excelevents.internal.ExcelEventsDataSource.createEngine(ExcelEventsDataSource.java:1)

  at com.sap.hilo.model.datasource.AbstractDADataSource$ConnectedDADataSource.<init>(AbstractDADataSource.java:313)

  at com.sap.hilo.model.datasource.AbstractDADataSource.createInstance(AbstractDADataSource.java:301)

  at com.sap.hilo.orchestration.workspace.internal.refresh.DataSetRefreshAsyncTask.execute(DataSetRefreshAsyncTask.java:109)

  at com.sap.hilo.orchestration.workspace.internal.refresh.WorkspaceRefreshAsyncTask.run(WorkspaceRefreshAsyncTask.java:72)

Caused by: java.io.FileNotFoundException: C:\smasjuan\meus\SAP\SAP LUMIRA\dades\HORAS_CODORNIU_201410.xlsx

  ... 7 more

2014/11/04 17:02:00.000000|>>|S| |11168|  40| |||||||||||||||[com.sap.hilo.desktop.embeddedserver.httpservice.HTTPAdapter]Call to service 'getTransactionStatus' failed

com.sap.hilo.desktop.embeddedserver.VIServiceException: java.lang.RuntimeException: DataSet Refresh has failed

  at com.sap.hilo.desktop.h5v2.service.GetTransactionStatus.execute(GetTransactionStatus.java:69)

  at com.sap.hilo.desktop.h5v2.service.HiloService.execute(HiloService.java:23)

  at com.sap.hilo.desktop.h5v2.common.service.BaseService.execute(BaseService.java:33)

  at com.sap.hilo.desktop.embeddedserver.httpservice.HTTPAdapter.execute(HTTPAdapter.java:89)

  at com.sap.hilo.desktop.embeddedserver.DispatcherServlet.handleRequest(DispatcherServlet.java:101)

  at com.sap.hilo.desktop.embeddedserver.DispatcherServlet.doPost(DispatcherServlet.java:86)

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

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

  at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:598)

  at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1367)

  at com.sap.hilo.desktop.embeddedserver.JsonPaddingFilter.doFilter(JsonPaddingFilter.java:80)

  at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1338)

  at com.sap.hilo.desktop.embeddedserver.configurator.internal.SecurityFilter.doFilter(SecurityFilter.java:59)

  at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1338)

  at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:484)

  at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)

  at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1065)

  at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:413)

  at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:192)

  at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:999)

  at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)

  at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111)

  at org.eclipse.jetty.server.Server.handle(Server.java:350)

  at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:454)

  at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:900)

  at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:954)

  at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:851)

  at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)

  at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:77)

  at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:606)

  at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:46)

  at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:603)

  at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:538)

  at java.lang.Thread.run(Thread.java:811)

Caused by: java.lang.RuntimeException: DataSet Refresh has failed

  at com.sap.hilo.desktop.h5v2.service.refresh.RefreshWorkspaceListener.getError(RefreshWorkspaceListener.java:131)

  at com.sap.hilo.desktop.h5v2.service.GetTransactionStatus.execute(GetTransactionStatus.java:59)

  ... 33 more

[former_member222570]

Hi, Antoine.

Where an I find that log file?.

Thanks.

[achab]

C:\Users\<Your Windows User>\AppData\Local\Temp\sapvi\logs, look for the latest file whose name starts with TraceLog.

[former_member222570]

Herewith joined last log file.