Editing a view very slow and getting error message
10 February, 2015
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
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
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
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
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
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