Java.lang.throwable error transformation

Lebo Dlamini shared this problem 7 months ago
Defect Logged

Hi Support,


I have a problem when running my transformation flow and I get the java.lang.throwable error (see below screenshot). 683024d42b1ea83bf553552043cc6afb


What I did was create a transformation flow and when I try to run the report, I get the error.


version : 7.4.7

build: 20180824


I currently don't have the log files.


Regards,

Lebo

Comments (8)

photo
1

a3d5ee1b0c52e10db939c566f2a02435

photo
1

Hi Lebohang,

Thanks for reaching out. java.lang.throwable and Null Pointer's are by default not terribly helpful error messages. Can you please re-replicate this issue then subsequently provide a compressed copy of your entire logs folder located at <YellowfinInstal>/appserver/logs so we can see what else is going on behind the scenes here? Without this information I'm afraid we'll be unable to assist further.

Thanks,

Mike

photo
1

Hi Mike,


My only problem is that I can't replicate it. It could have been a minor glitch in YF.


Can I reopen the ticket when it happens again?


Regards,

Lebo

photo
1

Hi Mike,


I managed to replicate this problem.


I have attached videos on how I replicated this problem.


Outside I get the throwable error and then when I open the error messages inside of the transformation I get the nullpointer error.


Regards,

Lebo

photo
1

Hi Mike,


Just to add onto this query. I realized the following.


1. In the csv there is a send time field which comes in as a Text field in YF.

2. When I run my transformation for the first time, it succeeds

3. When I edit the transformation because I need to change the file or even before I change the file and I press apply again, the send time fields data type gets removed. It becomes blank.


/D1XEtdjq+iLzAAAAAElFTkSuQmCC


How do I then deal with this problem?


Below I have attached the csv file for testing.


Regards,

Lebo

photo
1

Hi Lebohang,

Thanks for supplying this information and for the detailed replication steps. It turns out the key to all of this actually wound up being point 3 from your most recent reply.

To replicate your 3rd point, which I've confirmed gets straight to the issue, all you have to do is bring in the CSV file > click Apply, take note that it says TEXT next to 'send time' in the Fields list > click Apply again and take note that that field type is now blank in the Fields list, and all the data is gone. If you build without clicking re-apply all works as should, but once you edit and click apply again, or just click re-apply straight away, the transformation fails.

Why this is the case I can't say at this juncture, but I've gone ahead and raised it as a defect for the dev team to investigate further. I tried editing the format of the corresponding field in the csv file, but formatting as Text changes the values to decimals, and I also tried saving it in different formats - standard CSV as well as CSV (UTF-8). Ultimately, it's not too surprising these attempts were futile as it does import properly when first doing so, it just stops working once re-applying, which seems to imply something has gone awry within Yellowfin itself.

In the meantime, the only pseudo-workaround I can think of is to build a fresh transformation each time you're required to "edit" and re-apply a transformation. On the postive side, if your transformation is as simple as doing CSV -> Output to SQL Database, this isn't too difficult or time consuming to accomplish at least, but is inconvenient for sure and could become quite time consuming if this has to be done frequently.

Any potential updates regarding this matter will be posted here.

Regards,

Mike

photo
1

Hi Mike,


Thank you for the help.


Regards,

Lebo

photo
1

Hi Lebohang,

You're welcome. I'll keep you posted.

Regards,

Mike