Oracle Analytics Cloud and Server
Editing the Title - Bug in Sentiment Analysis using Oracle Analytics Desktop even after latest upgra
Summary
Error occurred while processing the query. - It seems a bug as it got failed in two systems
Content
Hi,
Hope you are keeping well.
I am trying to do sentiment analysis on Twitter data, however I keep on getting the following error with no clue how to fix this. Any help on this would highly be appreciated. I tried with other data set as well with no success. Where am I going wrong?
Update as on 06-Jun-20 - I tried installing it in another system, but the problem persists. Is it a bug ? Is there a work around ?
Note:- DVML is also installed with no errors.
Attached error screenshot and sample data for your reference. It includes errors from 2 different systems.
Regards,
Saumyadip.
Version
Oracle Analytics Desktop 5.6.0
Answers
-
Hello Saumyadip,
Can you please share the screenshots of your dataflow, the error above doesn't show anything specific.
And also make sure that you save the dataflow first and then run it once it gets saved.
Regards,
Aman
-
Hi Aman,
Thank you for your reply. Please find attached Data flow screenshot. I am also sharing the Tweet data for your reference.
Please let me know if you require any additional details.
Awaiting your reply.
Regards,
Saumyadip.
-
Hi Aman,
Thank you for your reply. Please find attached Data flow screenshot. I am also sharing the Tweet data for your reference.
Please let me know if you require any additional details.
Awaiting your reply.
Regards,
Saumyadip.
-
Hi Aman,
Thank you for your reply. Please find attached Data flow screenshot. I am also sharing the Tweet data for your reference.
Please let me know if you require any additional details.
Awaiting your reply.
Regards,
Saumyadip.
-
Hi Aman,
Thank you for your reply. Please find attached Data flow screenshot. I am also sharing the Tweet data for your reference.
Please let me know if you require any additional details.
Awaiting your reply.
Regards,
Saumyadip.
-
Hi Aman,
Thank you for your reply. Please find attached Data flow screenshot. I am also sharing the Tweet data for your reference.
Please let me know if you require any additional details.
Awaiting your reply.
Regards,
Saumyadip.
-
Hi Aman,
Thank you for your reply. Please find attached Data flow screenshot. I am also sharing the Tweet data for your reference.
Please let me know if you require any additional details.
Awaiting your reply.
Regards,
Saumyadip.
-
Hi Aman,
Thank you for your reply. Please find attached Data flow screenshot. I am also sharing the Tweet data for your reference.
Please let me know if you require any additional details.
Awaiting your reply.
Regards,
Saumyadip.
-
Hi Aman,
Thank you for your reply. Please find attached Data flow screenshot. I am also sharing the Tweet data for your reference.
Please let me know if you require any additional details.
Awaiting your reply.
Regards,
Saumyadip.
-
Hello Saumyadip,
I created a Dataflow in OAC with your tweet dataset and it's working perfectly fine for me.
Attaching a test visual created on top of the output dataset with the emotion column as well as also attaching the Dataflow extract(.DVA file) for your reference.
Hope this helps!
Regards,
Aman Jain
-
Hi Aman,
Thank you for the file. However, it's throwing an error while I am trying to import it Oracle Analytics Desktop.
Attaching the error file. It is something related to desktop version ? Not sure though.
Based on my dataflow, did you find any error on the approach?
Regards,
Saumyadip.
-
Hello Saumyadip,
You will need to check the logs to figure out what exactly the issue is, below are the steps to generate the diagnostic dump:
- Open the command prompt and change the directory to the Oracle Analytics Desktop installation directory (for example, C:\Program Files\Oracle Analytics Desktop).
- Type diagnostic_dump.cmd and then provide a name for the .zip output file (for example, output.zip).
- Press Enter to execute the command.
You can find the diagnostic output file in your installation directory.
Regards,
Aman Jain
-
And also I am assuming that you have the latest OAD version with the DVML installed.
Please check that as well.
Regards,
Aman Jain
-
Yes I have the latest version with no updates pending. I have followed your instructions, but not able to generate the file. Here is the screenshot of command prompt. I sincerely thank you for your efforts on this.
Regards,
Saumyadip.
-
Hello Saumyadip,
Can you run the cmd as an administrator and check again as I see "access denied" in the screenshot , that might be the issue.
For more info on generating the diagnostic dump you can refer to the oracle doc:
https://blogs.oracle.com/analytics/4-steps-to-oracle-data-visualization-diagnostics-support
Regards,
Aman Jain
-
Hi Aman,
Got the output file. Attaching for your reference.
Regards,
Saumyadip.
-
Hello Saumyadip,
Can you confirm that you have installed the Machine Learning and Advanced Analytics component with your OAD?
You can refer to the below oracle doc for more info on how to install DVML component:
Hope this helps!
Regards,
Aman Jain
-
Hi Aman,
Yes I have installed Machine Learning and Advanced Analytics components by installing DVML and all other ML models have worked fine so far.
Regards,
Saumyadip.
-
Hi Aman,
Any further updates from the error log file. It would be great if we can fix this issue as I have some demo lined up on this.
I look forward to your expertise in resolving this issue.
Regards,
Sumyadip.
-
Hi Aman,
Even after the latest update to ODA 5.6.0 and installing DVML, the issues is not resolved. Do you have any update on this?
Is there a work around?
Regards,
Saumyadip.
-
Hi Aman,
I am also facing the same issue with my Oracle Analytics Desktop. I have 6.0 version of OAD in my desktop with DVML installed.
Can you please help!
Regards,
Kanyaka Sanjana Jupudi