Error:Cannot call method "indexOf" of null.

[Sindy Ng]

Hi

I'm getting the following error message

Error:Cannot call method "indexOf" of null.

This is only happening on 2 out of the 3 accounts I manage.

All the sheets are set up exactly the same, and they all use the same GA/AW email address

Any Ideas?

Thanks

Sindy

[Mikael Thuneberg]

Can you temporarily share a sheet that has these errors with in...@supermetrics.com? Thanks.

--
You received this message because you are subscribed to the Google Groups "Supermetrics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to automateanalyt...@googlegroups.com.
Visit this group at http://groups.google.com/group/automateanalytics.
To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/6684ee36-616c-4d10-8756-9f3f25f00fb9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Sindy Ng]

Hi

 

Sorry I can’t share the sheet with you as it’s sensitive info ….

 

Is there any other way?

 

Thanks

Sindy

 

From: automate...@googlegroups.com [mailto:automate...@googlegroups.com] On Behalf Of Mikael Thuneberg
Sent: 07 September 2015 11:43
To: automate...@googlegroups.com
Subject: Re: [Supermetrics Help Forum] Error:Cannot call method "indexOf" of null.

 

Can you temporarily share a sheet that has these errors with in...@supermetrics.com? Thanks.

On 7 September 2015 at 13:41, Sindy Ng <sind...@jdplc.com> wrote:

Hi

 

I'm getting the following error message

 

Error:Cannot call method "indexOf" of null.

 

This is only happening on 2 out of the 3 accounts I manage.

All the sheets are set up exactly the same, and they all use the same GA/AW email address

 

Any Ideas?

 

Thanks

Sindy

--
You received this message because you are subscribed to the Google Groups "Supermetrics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to automateanalyt...@googlegroups.com.
Visit this group at http://groups.google.com/group/automateanalytics.
To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/6684ee36-616c-4d10-8756-9f3f25f00fb9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

 

--
You received this message because you are subscribed to a topic in the Google Groups "Supermetrics" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/automateanalytics/3tsEFX0oYAY/unsubscribe.
To unsubscribe from this group and all its topics, send an email to automateanalyt...@googlegroups.com.

Visit this group at http://groups.google.com/group/automateanalytics.

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/CAKRDB1uTeJc8%3DnERWRow_kwqroULD8QqKGFsGW5vnLWz1_jPiA%40mail.gmail.com.

[Mikael Thuneberg]

We already did some changes that should at least return a more descriptive error message. Without access to the query, it's difficult to do more at this point. Please post back here if you still get errors with these queries.

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/9FEA64E022EB164E90BADCFF20DE2DED50B229%40PRMAI86V.bury.jdsports.co.uk.

[Sindy Ng]

 

 

Seems like it’s just deleted parts of my query so it couldn’t refresh.

 

I’ve had to rebuild the whole query again…..which is a slight concern as we have these reports made for the whole JD Group

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/CAKRDB1uALfK1EU5wYQSgzry8xgBk_tMPQbutasopM_eaKq0shw%40mail.gmail.com.

[Mikael Thuneberg]

Can you include a full screenshots of everything the SupermetricsQueries sheet so we can see what's happening? You can email these to in...@supermetrics.com if you don't want to post them here.

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/9FEA64E022EB164E90BADCFF20DE2DED50B2A3%40PRMAI86V.bury.jdsports.co.uk.

[Sindy Ng]

Hi

 

Please see attached a copy of the supermetrics query tab

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/CAKRDB1tJ2fsM690C9aS3k6VXOjNd45NodmmKt-P%2BnUxVFsQiow%40mail.gmail.com.

[Mikael Thuneberg]

What happens if you refresh all those queries now?

[Sindy Ng]

Still getting the same error for the sheets I’ve not yet rebuilt

 

For the sheets I have rebuilt, it works fine

[Mikael Thuneberg]

Please select Refresh all queries. Which error do you get? Please include screenshot.

[Sindy Ng]

[Sindy Ng]

Hi Mikael

 

Let me know if you still need me to test anything else with the below?

 

Otherwise I’m going to start rebuilding the sheet

 

Thanks

Sindy

 

From: Sindy Ng
Sent: 07 September 2015 14:43
To: 'Mikael Thuneberg'
Cc: in...@supermetrics.com; automate...@googlegroups.com
Subject: RE: [Supermetrics Help Forum] Error:Cannot call method "indexOf" of null.

 

[Mikael Thuneberg]

Can you try refreshing the queries individually to see which of them returns the error?

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/9FEA64E022EB164E90BADCFF20DE2DED50B6A4%40PRMAI86V.bury.jdsports.co.uk.

[Sindy Ng]

Every single query return an error

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/CAKRDB1uKZ4CwjL4z0CVw1DAbO-FjPSbBP7RQWOpdwUCbEYzP7Q%40mail.gmail.com.

[Mikael Thuneberg]

Are you sure you can't share the file just temporarily with us? We could probably solve this is in a few minutes.

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/9FEA64E022EB164E90BADCFF20DE2DED50B746%40PRMAI86V.bury.jdsports.co.uk.

[Sindy Ng]

Hi

 

https://docs.google.com/spreadsheets/d/1KHKJVx-dPbd2yedzW9PPr8QP6zcxRP1iynWn5WxvRDc/edit?usp=sharing

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/CAKRDB1uvcVjtBG3ktfNkyk7aCGvE_a0KmwONkE9n8YCcuYcH4g%40mail.gmail.com.

[Mikael Thuneberg]

Thanks for sharing. For some reason, all of the "[" and "]" characters are missing from your file, someone has probably run a replace all command that has removed them. This causes problems with the query configuration that's stored on the SupermetricsQueries sheet. To fix, you will need to add those characters back or recreate the queries using the sidebar.

[Sindy Ng]

Is there a quick way to identify where I need to add the [ ] back into the queries?

[Mikael Thuneberg]

You could run one new query and use that as an example.

[Sindy Ng]

Thanks

 

How do I remove your access from the sheet?

[Mikael Thuneberg]

Using the Share button on the top right.

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/9FEA64E022EB164E90BADCFF20DE2DED50BA32%40PRMAI86V.bury.jdsports.co.uk.

[Sindy Ng]

Please can you provide a screen shot – I can’t seem to find it

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/CAKRDB1uFpJ-%2BvifZMBXO8ADhJ4CDyVsuVmVSmg%2Bw56oYczsmjg%40mail.gmail.com.

[DM]

Dear Mikael,

I also have the error "Error:Cannot call method "indexOf" of null".

Would you be able to help me out ?

In advance, thanks a lot,

DM