Transformation flow issue in 7.4.

Ronnie Abrahiem shared this problem 6 years ago
Resolved

Hello,


Today,we try “Transformation flow” in 7.4. for the first time in test environment andwhen I drag the input step (“extract from single table” ) from the panel ontothe canvas I received the error below.

/Z


Whenhit Ok. Yellowfin application keep circling and not let me to logout. I have to kill the sesseion to end the job. When I try to login back; the transformationflow tools is not show in the page. I have to login and wait 30 min and tryagain.

/2Q==


Replies (34)

photo
1

Hi Ronnie,

Do you have a few minutes to screen-share on this at any point today?

Regards,

Nathan

photo
1

Hi Nathan,

Yes, and I created the WebEx for screen-share.

https://diam.webex.com/diam/j.php?MTID=mcfcf887c8e7266bfc2e58ddde2f2f718

and my phone number 1-248-750-340


Thanks

Ronnie A.

photo
1

Hi Ronnie,

That link does not seem to be working, can you send a new one?

Nathan

photo
1

try the new link

------------------------------------------------------- To join the online meeting (Now from mobile devices!)

-------------------------------------------------------

1. Go to https://diam.webex.com/diam/e.php?MTID=mea98e3458f41d920149331be1f486ed7 2. If requested, enter your name and email address.

photo
1

Hi


YF:2018-01-19 15:56:34:ERROR (AjaxAction:error) - Error caught: java.lang.NullPointerException

java.lang.NullPointerException

at com.hof.mi.models.source.SelectSimpleSourceModelSessionImpl.getTransformationsEnabledForThirdParty(SelectSimpleSourceModelSessionImpl.java:123)

at com.hof.mi.models.source.SelectSimpleSourceModelSessionImpl.getDataSources(SelectSimpleSourceModelSessionImpl.java:107)

at com.hof.mi.web.action.NewSourceCreationAjaxAction.runAction(NewSourceCreationAjaxAction.java:113)

at com.hof.web.action.AjaxAction.execute(AjaxAction.java:155)

at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)

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

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

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

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

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at com.hof.servlet.BrowserHeaderFilter.doFilter(BrowserHeaderFilter.java:43)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source)

photo
1

Hey Ronnie,

I dont remember if we have tried this already, but it might be worth creating a second data source to see if you have better luck with the input step.

Looking at the error a bit more, this may have to do with the lack of viable connections.

Regards,

Nathan

photo
1

Hi Nathan,

Okay, I will create a new data source and try the input step again. I will let know. Thanks


Regards,

Ronnie A.

photo
1

Hi Nathan,

I created a new data source but still I have same issue and same error message. I received the error message before allow me to select the new Data Source or any Data Sources.

/GIL2JCHAAAAAElFTkSuQmCC


YF:2018-01-23 09:15:20:ERROR (AjaxAction:error) - Error caught: java.lang.NullPointerException

java.lang.NullPointerException

at com.hof.mi.models.source.SelectSimpleSourceModelSessionImpl.getTransformationsEnabledForThirdParty(SelectSimpleSourceModelSessionImpl.java:123)

at com.hof.mi.models.source.SelectSimpleSourceModelSessionImpl.getDataSources(SelectSimpleSourceModelSessionImpl.java:107)

at com.hof.mi.web.action.NewSourceCreationAjaxAction.runAction(NewSourceCreationAjaxAction.java:113)

at com.hof.web.action.AjaxAction.execute(AjaxAction.java:155)

at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)

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

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

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

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

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at com.hof.servlet.BrowserHeaderFilter.doFilter(BrowserHeaderFilter.java:43)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source)

YF:2018-01-23 09:16:00: INFO (SystemTaskManager:info) - Instantiating class: PersistentWebserviceSessionMonitorTask

YF:2018-01-23 09:16:00: INFO (SystemTaskManager:info) - Success instantiating class: PersistentWebserviceSessionMonitorTask


Thanks,

Ronnie A.

photo
1

Thanks for trying Ronnie,

I have logged this as a defect. 9620

photo
photo
1

What was the outcome? We are experiencing a similar error.

photo
1

Hi Daryle,

If you are experiencing the exact same error in the logs, then it was a defect believed to be related to materialized views. Does this sound like what you are seeing?

Nathan

photo
1

Nathan , I dont believe so. We are still working through the issue but we are making progress.

photo
1

Hi Daryle,

Sounds good it might be easier to log this as a separate ticket if you are not able to figure it out.

Nathan

photo
photo
1

Hi Nathan

Couple thing.

1. Please any update on the "extract from single table” issue

2. When I use Transformation flow for other purpose some time work fine and some time not give me black screen no tools. Please see the screen below with job log. thanks


/9Sm2AcxENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAAAJAQ0AAAAAQEJAAwAAAACQENAAAAAAACQENAAAAAAACQENAAAAAEBCQAMAAAAAkBDQAAAAAAAkBDQAAAAAAAkBDQAAAABAQkADAAAAAJAQ0AAAAAAAJAQ0AAAAAACB7UKVNlijjRF1AAAAAElFTkSuQmCC


YF:2018-01-29 16:39:00: INFO (SystemTaskManager:info) - Instantiating class: PersistentWebserviceSessionMonitorTask

YF:2018-01-29 16:39:00: INFO (SystemTaskManager:info) - Success instantiating class: PersistentWebserviceSessionMonitorTask

YF:2018-01-29 16:39:24: INFO (LogonAction:info) - Logon Action entered

YF:2018-01-29 16:39:24: INFO (LogonAction:info) - Internal Entry Point for Logon

YF:2018-01-29 16:39:24: INFO (LogonAction:info) - logon authorised..

YF:2018-01-29 16:39:24: INFO (MIEntryAction:info) - MIEntryAction entered (/MIEntry)

YF:2018-01-29 16:39:25: INFO (MIDashRedirectAction:info) - MIDashRedirectAction entered

YF:2018-01-29 16:39:25: INFO (MIDashRedirectAction:info) - MIDashRedirectAction exiting

YF:2018-01-29 16:39:25: INFO (MIRunDashboardAction:info) - MIRunDashboardAction entered

YF:2018-01-29 16:39:25: INFO (MIRunDashboardAction:info) - MIRunDashboardAction entered

YF:2018-01-29 16:39:25: INFO (MIPreDashboardAction:info) - MIPreDashboardAction entered

YF:2018-01-29 16:39:25: INFO (MIPreDashboardAction:info) - MIPreDashboardAction exiting with action: success

YF:2018-01-29 16:39:25: INFO (OrgCache:info) - Null reference code requested

YF:2018-01-29 16:39:26: INFO (ColourPickerAjaxAction:info) - ColourPickerAjaxAction entered

YF:2018-01-29 16:39:26: WARN (MIImageAction:warn) - Invalid thumbSize: THUMB_SCALE_50x50

YF:2018-01-29 16:39:30: INFO (MIDashboardAction:info) - MIDashboardAction entered

YF:2018-01-29 16:39:30: INFO (MIDashboardAction:info) - MIDashboardAction exiting with action: CreateTransformation

YF:2018-01-29 16:39:30: INFO (CreateETLAction:info) - CreateETLAction entered

YF:2018-01-29 16:39:30: INFO (CreateETLAction:info) - CreateETLAction exiting with action: success

YF:2018-01-29 16:39:30: INFO (ETLAction:info) - MIIETLAction entered

YF:2018-01-29 16:39:30: INFO (ETLAction:info) - MIIETLAction exiting with action: success

YF:2018-01-29 16:39:31: INFO (ColourPickerAjaxAction:info) - ColourPickerAjaxAction entered


Thanks

Ronnie A.

photo
1

Hi Ronnie,

Can you remind me of what build you are using here? is it 20180104?

Also, would it be possible for you to provide a dump of your configuration database? If so please let me know and I will provide you with access to our ftp server

Regards,

Nathan

photo
1

Hello Nathan

Please find the attached files.

Can you please give me a more details about which database configuration you are look for! because we do have two databases Oracle database and Yellowfin database. Thanks


Ronnie A.

photo
1

Hi Ronnie,

I am referring to the Yellowfin configuration database. I have sent you an invite to our FTP server.

However, it would also be nice to have a valid data source connection. Is this oracle DB publicly accessible?

Regards,

Nathan

photo
1

Hi Nathan,

The Oracle DB is connecting to our production database and not publicly accessible. Thanks


Ronnie A.

photo
1

Hi Ronnie,

No worries, if you can provide me with the yellowfin config we should be able to go from there.

Regards,

Nathan

photo
1

Hi Nathan,

Done. I uploaded Yellowfin database and another files. Please let me know if you need any more information. Thanks


Ronnie A.

photo
1

Thanks Ronnie,

I have passed this along to the dev team, so hopefully we can get a solution relatively quickly.

Regards,

Nathan

photo
1

Hello Nathan

You're welcome. Thank you again for your support.


Ronnie A.

photo
1

Nathan,

Its seem we have a same issue when I try to created a new View in Yellowfin 7.4. Please see the job log below:

/2Q==


YF:2018-02-09 10:17:00:ERROR (MIAdminProcess:error) - Error:java.lang.Exception: Exception selecting data from database


YF:2018-02-09 10:17:00:ERROR (DBAction:error) - Erroroccured selecting data: java.sql.SQLException: ORA-00900: invalid SQL statement


java.sql.SQLException: ORA-00900: invalid SQL statement


atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)


atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)


atoracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)


atoracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)


atoracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)


atoracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)


atoracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)


atoracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1037)


atoracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)


atoracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)


atoracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)


atoracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1205)


atcom.hof.util.DBAction.doSelect(DBAction.java:872)


atcom.hof.util.DBAction.doSelect(DBAction.java:817)


atcom.hof.mi.process.MIAdminProcess.runAccessFilterSql(MIAdminProcess.java:2336)


atcom.hof.mi.process.MIAdminProcess.refreshSqlAccessFilter(MIAdminProcess.java:2165)


at com.hof.mi.servlet.SourceFilterRefreshTask.B(SourceFilterRefreshTask.java:124)


atcom.hof.mi.servlet.SourceFilterRefreshTask.runTask(SourceFilterRefreshTask.java:194)


atcom.hof.mi.servlet.TaskScheduler$_A.A(TaskScheduler.java:115)


atcom.hof.mi.servlet.TaskScheduler$_A.run(TaskScheduler.java:170)


atjava.lang.Thread.run(Unknown Source)


YF:2018-02-09 10:17:00:ERROR (MIAdminProcess:error) - Error:java.lang.Exception: Exception selecting data from database


Thanks,

Ronnie A.

photo
1

Hi Ronnie,

Actually the Dev team just got back to me and had noticed this as well. The dev added a check for this but noted that:

This is because there is a third party data source called "Joson Test" that has broken. While it is not obvious what broke this originally, one guess is that the plugin needed for this has been removed. If this is not being used, the best fix is to try and delete this data source.

Let me know if this makes sense, or if you have any luck.

Nathan

photo
1

Hello Nathan,

Thank you for your support;

It's seem everything working fine now after I removed the "Joson Test" database from Plugin Management section and deleted the views. I tested the both Transformation Flow and create View and the both works fine without any issue.

Now the status of "Joson Test" data source "unavailable the connection to this data source" but when I try to delete the data source of "Joson Test" I get the error message below:

/fbAAAAABJRU5ErkJggg==

Thanks,

Ronnie A.

photo
1

Hi Ronnie,

Very glad to hear it is working again! Regarding the error message, can you please send me the logs shortly after re-producing this error?

This should give us a better idea of what is going wrong.

Nathan

photo
1

Hi Nathan,

Please see the job logs below:

YF:2018-02-12 13:39:31:ERROR (MIReportProcess:error) - Error: com.hof.util.ActionErrorsException

com.hof.util.ActionErrorsException

at com.hof.mi.process.MIReportProcess.loadReport(MIReportProcess.java:2613)

at com.hof.mi.process.MIReportProcess.loadReport(MIReportProcess.java:2607)

at com.hof.mi.process.MIReportProcess.getDashboardDrillThroughLinksForReport(MIReportProcess.java:23835)

at com.hof.mi.process.MIReportProcess.A(MIReportProcess.java:24030)

at com.hof.mi.process.MIReportProcess.A(MIReportProcess.java:3699)

at com.hof.mi.process.MIReportProcess.deleteReports(MIReportProcess.java:3612)

at com.hof.mi.process.MIReportProcess.deleteReports(MIReportProcess.java:3558)

at com.hof.mi.process.MIReportProcess.deleteSources(MIReportProcess.java:6672)

at com.hof.mi.web.action.MIDataSourceAction.execute(MIDataSourceAction.java:1046)

at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)

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

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

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

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

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at com.hof.servlet.BrowserHeaderFilter.doFilter(BrowserHeaderFilter.java:43)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source)


Thanks,

Ronnie A.

photo
1

Nathan,

Here's the begging of job logs.

YF:2018-02-12 13:39:31:ERROR (MIReportProcess:error) - Error: java.lang.Exception: Source record is DELETED: 107458

java.lang.Exception: Source record is DELETED: 107458

at com.hof.mi.process.MIReportProcess.loadReportDefinition(MIReportProcess.java:3149)

at com.hof.mi.process.MIReportProcess.loadReport(MIReportProcess.java:2671)

at com.hof.mi.process.MIReportProcess.loadReport(MIReportProcess.java:2619)

at com.hof.mi.process.MIReportProcess.loadReport(MIReportProcess.java:2612)

at com.hof.mi.process.MIReportProcess.loadReport(MIReportProcess.java:2607)

at com.hof.mi.process.MIReportProcess.getDashboardDrillThroughLinksForReport(MIReportProcess.java:23835)

at com.hof.mi.process.MIReportProcess.A(MIReportProcess.java:24030)

at com.hof.mi.process.MIReportProcess.A(MIReportProcess.java:3699)

at com.hof.mi.process.MIReportProcess.deleteReports(MIReportProcess.java:3612)

at com.hof.mi.process.MIReportProcess.deleteReports(MIReportProcess.java:3558)

at com.hof.mi.process.MIReportProcess.deleteSources(MIReportProcess.java:6672)

at com.hof.mi.web.action.MIDataSourceAction.execute(MIDataSourceAction.java:1046)

at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)

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

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

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

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

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at com.hof.servlet.BrowserHeaderFilter.doFilter(BrowserHeaderFilter.java:43)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source)

YF:2018-02-12 13:39:31:ERROR (MIReportProcess:error) - com.hof.util.ActionErrorsException

com.hof.util.ActionErrorsException

at com.hof.mi.process.MIReportProcess.loadReport(MIReportProcess.java:2613)

at com.hof.mi.process.MIReportProcess.loadReport(MIReportProcess.java:2607)

at com.hof.mi.process.MIReportProcess.getDashboardDrillThroughLinksForReport(MIReportProcess.java:23835)

at com.hof.mi.process.MIReportProcess.A(MIReportProcess.java:24030)

at com.hof.mi.process.MIReportProcess.A(MIReportProcess.java:3699)

at com.hof.mi.process.MIReportProcess.deleteReports(MIReportProcess.java:3612)

at com.hof.mi.process.MIReportProcess.deleteReports(MIReportProcess.java:3558)

at com.hof.mi.process.MIReportProcess.deleteSources(MIReportProcess.java:6672)

at com.hof.mi.web.action.MIDataSourceAction.execute(MIDataSourceAction.java:1046)

at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)

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

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

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

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

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at com.hof.servlet.BrowserHeaderFilter.doFilter(BrowserHeaderFilter.java:43)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source)


Thanks,

Ronnie A.

photo
1

Hi Ronnie,

It looks like this error is occurring because of the backend changes that were made. Typically, to ensure all links are properly removed it is best to do this through the UI, but in this case we should be able to get around this with a couple more changes.

Is this record entirely gone from the reportviewsource table or is it just set to DELETED?

Nathan

photo
1

Hello Nathan,

I checked "reportviewsource" table and the record of "Joson Test" still exist in table. Thanks

/Z

Thanks,

Ronnie A.

photo
1

Hi Ronnie,

If the content associated with this record has already been removed then removing this record, or setting its status code to "DELETED" should remove it from the list of available datasources. Will this work for you or are you looking for a more final solution?

Nathan

photo
1

Hello Nathan,

Yes, removed "Joson Test" from the list of data sources by set ACCESSCODE field to "DELETED" status. Thanks

[UPDATE REPORTVIEWSOURCE SET ACCESSCODE = 'DELETED' where SOURCEID = 107458;]


Thanks

Ronnie A.

photo
1

Good to hear. Let me know if you run into any other problems here.

Nathan

photo
1

Hi Nathan,

I have one more question about 7.4; Is there limit on number ofinput files in Transformation Flow and how Transformation flow option effect onsystem performer. Thanks

Ronnie A.

photo
1

Hi Ronnie,

To my knowledge there is no limit.

From what I know, there is only a single thread dedicated to ETL flows, so all processes contained within will be executed consecutively. This will exist on the JVM and use java memory in accordance, but typically these steps are designed so that only a small amount of the data being processed will consume memory at any point in time.

Let me know if this makes sense/ answers your question

Nathan

photo
1

Thank Nathan again for your support.


Ronnie A.

photo
1

No problem let me know if you have any other questions/issues.

Nathan

photo
1

Hello Nathan,

Is it possible for Yellowfin to bring in data from Hyperion?

Thanks

Ronnie A.

photo
1

Hi Ronnie,

I am not personally aware of any clients who use Hyperion, though from looking through a bit of documentation, there should be a database underlying this that we can connect to?

https://docs.oracle.com/cd/E12825_01/epm.111/migration/frameset.htm?source_rep_data_loc.html

I asked a few of my colleagues as well. but they are not aware of how exactly it works either. Sorry, if it turns out there is a set way please let me know and we can create a community article out of it.

Nathan

photo
1

Hi Nathan,


No problem, We will try to use Oracle FDM to convert Hyperion data to Oracle relationship database then we pull the data to Yellowfin.


Thanks


Ronnie A.

photo
1

Hi Ronnie,

Sounds good let me know if you run into problems.

Nathan

Leave a Comment
 
Attach a file