Yellowfin upgrade issue from 9.2 to 9.8

Manikandan Appar shared this question 16 months ago
Completed

Hi Team,

Our customer tried to upgrade from 9.2 to 9.8 but they are unable to upgrade successfully.

When we verified it showed an issue in upgrading the schema (refer to the image), same we have validated it in the local environment and we are able to upgrade successfully.

Not sure what is missing on the customer side, I have verified all the logs it all looks good even though we are able to connect the database from the SQL management studio also tried SSL as well, can you please help us and provide your input?

Thanks.

Replies (5)

photo
1

Hi Manikandan,

It seems like there is some error with decrypting the password as it attempts to connect to the source database. Could you please supply the info.jsp page (found via the URL http://youryellowfinURL:port/info.jsp) from the customer's instance? I suspect it is a problem with the Java version used and may need to suggest an alternative Java install.

Can I also ask if the attempt to upgrade was tried more than once?

Kind regards,

Chris

photo
1

Hi Chris,

Thanks for your reply.

I have requested the info.jsp once I received I will upload the same. Also, we have tried multiple times to upgrade by changing the SSL=true and other options so yes we tried multiple times.

Thanks.

photo
1

Please find the info.jsp file in the ticket.

photo
1

Hi Mandikandan,

Thank you for the update and supplied file. Earlier versions of Yellowfin 9 did sometimes have compatibility issues with Java 14. I would suggest rolling back the installed Java version to Java 11 or 1.8.0_3xx and try the upgrade again.

You may need to modify the PATH environment variables to ensure that the upgrader uses the correct version of Java if you leave two versions installed. You can also make changes to the catalina.bat in the yellowfin/appserver/bin folder to specify the catalina_home variable.

After the upgrade you can then reinstall JDK 14.

Let me know how it goes.

Kind regards,

Chris

photo
1

Hi Chris,

I am reopening this ticket, as you instructed we informed the user to follow the same step that is mentioned but after following the instructions it is not working.

We have upgraded JDK and Java but didn't help much, can you please tell us what is issue still here?

Please find the attachment for more details.

Thanks,

Manikandan

photo
1

Hi Manikandan,

I don't use Outlook so cannot open this file, could you please send it in a different format or preferably describe the current problem. Is your client unable to upgrade? Your last message stated that they installed a new version of Yellowfin and migrated the reports over.

Kind regards,

Chris

photo
1

Hi Chris-

Please find the Word document attached, let me know if you can open the file.

Error while trying to upgrade the Yellowfin reports from version 9.2 to 9.7

Thanks.

photo
1

Hi Manikandan,

Thanks for sending that over. Could you please also attach the entire Yellowfin Patchlog file?

Before the ticket was closed, I recommended that you downgrade Java to JDK 11 or 1.8.0_3xx, try the upgrade and then you can change it back to OpenJDK 14 if that's required.

From the screenshots in the document, it appears that JDK 14 is still being used. Could you please try changing to Java 11.

Kind regards,

Chris

photo
1

Hi Manikandan,

I hope you're doing well. Just checking in here to see how it's all going with this one. Let me know if you still need some assistance or a recommended JDK build.

Kind regards,

Chris

photo
1

Thanks Chris. You can close this item.

Our team has identified the issue, after downgrading the JRE path in the environment variable was not updated correctly path once updated we were able to run the update exe.

we were not getting any input from your wiki document, please make sure this kind of initial check is present in the document so that we can progress.

You can close this item.

photo
1

Hi Manikandan,

Thanks for letting me know. I've passed your feedback on to our Wiki team. Have a great weekend!

Kind regards,

Chris

photo
1

Hi Mandikandan,

Following your support ticket, please review Yellowfin on G2 and claim a $50 gift card!

Thanks again for being a valued Yellowfin customer. To claim your $50 gift card, simply login to G2 here to submit your review. Don’t have a G2 account? You can also login via your Linkedin account or a Google business account.

G2 reviews take 5-10 minutes to complete. Once you have completed the review, please reply back to this email to confirm you completed the review and our team will send you a $50 gift card*.

Review Yellowfin on G2

You will be prompted by G2 to confirm that you are a current user of Yellowfin BI by uploading a screenshot showing you logged into Yellowfin BI.


Your review will be published after G2's team has a chance to review to ensure it's from a valid Yellowfin user. Regardless of G2's acceptance of the review, we will send you a gift card for your response. Your gift card will be sent in 1-2 business days.

*Note: If you wish to have the gift card sent to a different email address, please reply back to me with the correct email address. If you are outside the US, we will provide a gift card equivalent to USD $50 in a currency that you select.

Thank you for supporting Yellowfin and taking the time to review our product! We appreciate your time.

Kind regards,

Chris



photo
photo
1

Hi Chris,

This is not a feasible solution for the user to upgrade/change the Java and again do the Yellowfin version upgrade because it will be a tedious process to follow hence we have requested the user to export their custom report and import the reports in the new Yellowfin9.8 version.

You can close this item.

Thanks.

photo
1

Hi Manikandan,

Thanks for letting me know. I'll mark this one as complete. Have a pleasant rest of your week!

Kind regards,

Chris

photo
1

I have added comments, can you please check and respond?

Leave a Comment
 
Attach a file