dotCMS / core

Headless/Hybrid Content Management System for Enterprises
http://dotcms.com
Other
861 stars 468 forks source link

Dashboard: NullPointerException when try to see the host detail #1787

Closed graz1an0 closed 11 years ago

graz1an0 commented 11 years ago

This is the stack trace.

2013-01-09 17:51:14,250 ERROR com.dotcms.enterprise.priv.c - getTopReferers failed:java.lang.NullPointerException java.lang.NullPointerException at com.dotcms.enterprise.priv.c.getTopReferers(SourceFile:636) at com.dotmarketing.portlets.dashboard.business.DashboardAPIImpl.getTopReferers(DashboardAPIImpl.java:73) at com.dotcms.enterprise.priv.DashboardAjax.getHostStatistics(SourceFile:174) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.directwebremoting.impl.CreatorModule$1.doFilter(CreatorModule.java:229) at org.directwebremoting.impl.CreatorModule.executeMethod(CreatorModule.java:241) at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:379) at java.lang.Thread.run(Thread.java:662) 2013-01-09 17:51:14,253 ERROR com.dotcms.enterprise.priv.DashboardAjax - java.lang.NullPointerException com.dotmarketing.exception.DotRuntimeException: java.lang.NullPointerException at com.dotmarketing.exception.DotRuntimeException.fillInStackTrace(DotRuntimeException.java:33) at java.lang.Throwable.(Throwable.java:181) at java.lang.Exception.(Exception.java:29) at java.lang.RuntimeException.(RuntimeException.java:32) at com.dotmarketing.exception.DotRuntimeException.(DotRuntimeException.java:15) at com.dotcms.enterprise.priv.c.getTopReferers(SourceFile:676) at com.dotmarketing.portlets.dashboard.business.DashboardAPIImpl.getTopReferers(DashboardAPIImpl.java:73) at com.dotcms.enterprise.priv.DashboardAjax.getHostStatistics(SourceFile:174) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.directwebremoting.impl.CreatorModule$1.doFilter(CreatorModule.java:229) at org.directwebremoting.impl.CreatorModule.executeMethod(CreatorModule.java:241) at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:379) at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:332) at org.directwebremoting.dwrp.BaseCallHandler.handle(BaseCallHandler.java:104)

After running the /html/scripts/dashboard_data_generator.jsp we get the referers properly on MySQL

http://screencast.com/t/mOr1smFNmu

But not Oracle

http://screencast.com/t/ahi850hoip

Also, we need to get the "top" content pulling as well. If we need to modify the /html/scripts/dashboard_data_generator.jsp to populate data to make this show, then we should do that and then we can make sure it works on all 4 DBs - poor man's test driven development.

jtesser commented 11 years ago

This is in Oracle

graz1an0 commented 11 years ago

Yes in Oracle

graz1an0 commented 11 years ago

These are the steps that I've followed:

  1. Enabled the Run Dashboard on demo.dotcms.com host;
  2. Enabled the clickstream and dashboard on dotmarketing.properties;
  3. Browsed and navigated the demo site;
  4. At the user session expire the ClickstreamListener writes into the tables in a right way;
  5. The dashboard job fill the analytics tables;
  6. Went to the dashboard interface and click on demo.dotcms.com line;
  7. Into the detail I not saw anything and throws that exception.

Do you thing that I've missed some steps?

jtesser commented 11 years ago

no that is right. I wasn't asking if it was Oracle but letting the developer know it is :-) We will try to get tho this next week.

jgambarios commented 11 years ago

Fixed on #1881

DeanGonzalez commented 11 years ago

Will test on all db's after dashboard generator jsp is fixed: Created follow up fix task: https://github.com/dotCMS/dotCMS/issues/2171