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.
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 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.
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.
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
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 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 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
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.
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: