ansaurus

Question

Problem with Google Analytics for Android : "Dispatcher thinks it finished, but there were 543 failed events"

Answer 1

+1 A:

The problem is related with whitespaces in trackEvent and trackPageView labels.

1) Remove all whitespaces (or escape them) from all trackEvent and trackPageView calls.

2) Clear the google_analytics.db events table (at least all rows having lable column containing a whitespace)

. . .

To clear the events rows by code you can use the following code:

import android.content.Context;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class AnalyticsDB extends SQLiteOpenHelper {

    // The Android's default system path of your application database.
    private static String DB_PATH = "/data/data/<YOUR_PACKAGENAME>/databases/";

    private static String DB_NAME = "google_analytics";

    private SQLiteDatabase myDataBase;

    /**
     * Constructor Takes and keeps a reference of the passed context in order to
     * access to the application assets and resources.
     * 
     * @param context
     */
    public AnalyticsDB(Context context) {
        super(context, DB_NAME, null, 1);
    }

    public void openDataBase() throws SQLException {

        // Open the database
        String myPath = DB_PATH + DB_NAME + ".db";
        myDataBase = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READWRITE);

    }

    @Override
    public synchronized void close() {

        if (myDataBase != null) myDataBase.close();

        super.close();

    }

    @Override
    public void onCreate(SQLiteDatabase db) {

    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }

    public int deleteEvents() {
        return myDataBase.delete("events", "label LIKE '% %'", null);
    }
}

and add it to your activity at startup

   public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);

            AnalyticsDB myDbHelper = new AnalyticsDB(context);

            try {
                myDbHelper.openDataBase();
                int deleted = myDbHelper.deleteEvents();
                myDbHelper.close();
            }
            catch (SQLException sqle) {
                throw sqle;
            }
            finally{
                myDbHelper.close();
            }

    }

The events table will be deleted when you uninstall and installs the app, but this is probably not always the preferred solution.

So, if point 1) and 2) is not fixed, your Google Analytics code will be dead meat --- forever...

Kudos to Jason and Stig B for helping out debugging

PHP_Jedi 2010-04-06 13:45:38

Answer 2

A:

Hi Jedi

I am having the same issues. I have implemented your tracker = null and checked that the tracker is null when I instantiate it, but am still getting that error

onCreate() {
...
tracker = GoogleAnalyticsTracker.getInstance();
tracker.start("UA-xxxx-yy", this);
tracker.trackEvent("test1", "test2", "test3", 1);
tracker.dispatch();
}

and my onDestroy() looks exactly the same as you have.

Any ideas? Have hit the wall on this one...

Thanks in advance, Neil

Neil 2010-04-07 09:28:28

I updated the answer above. I think it should solve the issue.

PHP_Jedi 2010-04-07 14:26:48

ansaurus

tags:

views:

answers:

Problem with Google Analytics for Android : "Dispatcher thinks it finished, but there were 543 failed events"

related questions