Category
Data Transformation
Product Version
7.4
Transformation flow issue in 7.4.
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.
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.
The same problem 
Hi Ronnie,
Do you have a few minutes to screen-share on this at any point today?
Regards,
Nathan
Hi Ronnie,
Do you have a few minutes to screen-share on this at any point today?
Regards,
Nathan
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.
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.
Hi Ronnie,
That link does not seem to be working, can you send a new one?
Nathan
Hi Ronnie,
That link does not seem to be working, can you send a new one?
Nathan
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.
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.
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)
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)
What was the outcome? We are experiencing a similar error.
What was the outcome? We are experiencing a similar error.
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
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.
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
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.
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
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
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.
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.
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
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
Hi Nathan,
The Oracle DB is connecting to our production database and not publicly accessible. Thanks
Ronnie A.
Hi Nathan,
The Oracle DB is connecting to our production database and not publicly accessible. Thanks
Ronnie A.
Hi Ronnie,
No worries, if you can provide me with the yellowfin config we should be able to go from there.
Regards,
Nathan
Hi Ronnie,
No worries, if you can provide me with the yellowfin config we should be able to go from there.
Regards,
Nathan
Hi Nathan,
Done. I uploaded Yellowfin database and another files. Please let me know if you need any more information. Thanks
Ronnie A.
Hi Nathan,
Done. I uploaded Yellowfin database and another files. Please let me know if you need any more information. Thanks
Ronnie A.
Thanks Ronnie,
I have passed this along to the dev team, so hopefully we can get a solution relatively quickly.
Regards,
Nathan
Thanks Ronnie,
I have passed this along to the dev team, so hopefully we can get a solution relatively quickly.
Regards,
Nathan
Hello Nathan
You're welcome. Thank you again for your support.
Ronnie A.
Hello Nathan
You're welcome. Thank you again for your support.
Ronnie A.
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:
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.
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:
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.
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
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
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:
Thanks,
Ronnie A.
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:
Thanks,
Ronnie A.
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
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
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.
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.
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.
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.
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
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
Hello Nathan,
I checked "reportviewsource" table and the record of "Joson Test" still exist in table. Thanks
Thanks,
Ronnie A.
Hello Nathan,
I checked "reportviewsource" table and the record of "Joson Test" still exist in table. Thanks
Thanks,
Ronnie A.
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
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
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.
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.
Good to hear. Let me know if you run into any other problems here.
Nathan
Good to hear. Let me know if you run into any other problems here.
Nathan
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.
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.
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
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
Thank Nathan again for your support.
Ronnie A.
Thank Nathan again for your support.
Ronnie A.
No problem let me know if you have any other questions/issues.
Nathan
No problem let me know if you have any other questions/issues.
Nathan
Hello Nathan,
Is it possible for Yellowfin to bring in data from Hyperion?
Thanks
Ronnie A.
Hello Nathan,
Is it possible for Yellowfin to bring in data from Hyperion?
Thanks
Ronnie A.
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
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
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.
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.
Hi Ronnie,
Sounds good let me know if you run into problems.
Nathan
Hi Ronnie,
Sounds good let me know if you run into problems.
Nathan
Replies have been locked on this page!