Forum

This content is now out of date.

Visit Our Community

Editing a view very slow and getting error message

Hi Team ,

Whenever we edit a view , we see that the below warning message keeps coming in the logs . It takes too much time to edit the view.. Sometimes we get an error message also saying , "An error occured..... " .

Please suggest how to fix this


Logs:
YF:2015-02-10 07:17:13: WARN (OrgReferenceCodeRltshpManager:getAllRefRltshps) - Data will be loaded with the above row data for the given key
YF:2015-02-10 07:17:13: WARN (OrgReferenceCodeRltshpManager:getAllRefRltshps) - ERROR: Duplicate loading rltshp data - Key: 12001|PRIMARY|VIEWCATEGORY|YFVIEWS|FIELDCATEGORY|REPORTINGPARTNER index: 407
YF:2015-02-10 07:17:13: WARN (OrgReferenceCodeRltshpManager:getAllRefRltshps) - Data will be loaded with the above row data for the given key
YF:2015-02-10 07:17:13: WARN (OrgReferenceCodeRltshpManager:getAllRefRltshps) - ERROR: Duplicate loading rltshp data - Key: 12001|PRIMARY|VIEWCATEGORY|YFVIEWS|FIELDCATEGORY|REPORTINGPARTNER index: 408
YF:2015-02-10 07:17:13: WARN (OrgReferenceCodeRltshpManager:getAllRefRltshps) - Data will be loaded with the above row data for the given key
YF:2015-02-10 07:17:13: WARN (OrgReferenceCodeRltshpManager:getAllRefRltshps) - ERROR: Duplicate loading rltshp data - Key: 12001|PRIMARY|VIEWCATEGORY|YFVIEWS|FIELDCATEGORY|REPORTINGPARTNER index: 409
YF:2015-02-10 07:17:13: WARN (OrgReferenceCodeRltshpManager:getAllRefRltshps) - Data will be loaded with the above row data for the given key
YF:2015-02-10 07:18:00: INFO (TaskScheduler:A) - Running Source Filter Refresh Task for Report Task 213033: 12067,SOURCEFILTER,REPORTTASKID,213033
YF:2015-02-10 07:18:00: INFO (TaskScheduler:A) - Running Source Filter Refresh Task for Report Task 213129: 12067,SOURCEFILTER,REPORTTASKID,213129
YF:2015-02-10 07:18:00:ERROR (TaskScheduler:A) - java.lang.Exception: ReportViewSource record is deleted
java.lang.Exception: ReportViewSource record is deleted
at com.hof.mi.servlet.SourceFilterRefreshTask.runTask(SourceFilterRefreshTask.java:400)
at com.hof.mi.servlet.TaskScheduler$_A.A(TaskScheduler.java:106)
at com.hof.mi.servlet.TaskScheduler$_A.run(TaskScheduler.java:153)
at java.lang.Thread.run(Thread.java:619)




Regards,
Sanjay B S
Hello Sanjay,

If you are experiencing some slow performance using YF, it might be worth looking at increasing the memory that YF is using - we have a Forum Post with instructions on how to increase the memory.

If the memory increase does not resolve your issues, please send all the log files contained in your yellowfin/appserver/logs folder to support@yellowfin.bi, and we will investigate further.

Kind Regards,

Danny
Hi Danny ,

Thanks for your suggestion.. We will try increasing the memory and check the performance

But I am curious to know why there are so many warnings , errors and exceptions in the logs while editing a view.

Regards,
Sanjay B S
HI,

Currently we have the JAVA_OPTS="$JAVA_OPTS -Xms1024m -Xmx4096m . But still even if I am the only user logged in , the editing the view is very slow . we are cloning while editing a view.

If we import a view and try to edit a view also we are facing issues.. We are getting the error message as "The view is in an erroneous state. Please fix the errors to continue."

REgarding the log files , do you need catalina.out file ? The size of this file is around 1GB. Please let me know if this file is required.. Or else i can send all other log files

We are using YF 7.1 Jan patch on linux box


Regards,
Sanjay B S
Hello Sanjay,

I've attached the YF Performance Guide to this post, this may assist in further troubleshooting.

If the performance issues continue, all logs in the appserver/logs folder can be zipped and emailed to us ( the catalina.out file should compress to a reasonable size ). With your log files, could you also provide answers to the following:

Was the slowdown caused by;

Running particular dashboards?
Running particular reports maybe based on a specific view or a specific chart type?
Caching report filters?
Creating a report?
Particular user logging in?
What server hardware are you using? Amount of RAM ?
How much memory has been allocated to Yellowfin?
Are youaccessing Yellowfin directly, or through a proxy?
Is Yellowfin integrated with another application?
Is Yellowfin within an iFrame?

Hear from you soon,

Kind Regards,

Danny