invalid page_view data

[Elijah Tabb]

Hi!

At risk of making a fool of myself again I have another question. When I try and run storage-loader I get ERROR:  Load into table 'events' failed.

From the stl_load_errors table it seems like loading page_view events is failing with a "invalid data" error. This is the entry in the table:

105 0 376995  2014-08-04 21:11:51.664395  31959 872059  s3://snowplow-looker-emr-out/enriched/good/run=2014-08-01-14-35-27/part-00000                                                                                                                                                                                     1 dvce_tstamp                                                                                                                     timestamp   0           53    web 2014-08-01 03:40:59.000 2014-08-01 03:40:55.848 page_view   4a6773fb-1e45-4d3a-96a0-3b6c55b20307  861154  cf  js-2.0.0  cloudfront  hadoop-0.5.0-common-0.4.0   66.249.83.75  1894599038  84099e418e50fb08  1   US  CA  Mountain View 94043 37.419205 -122.0574 https://gtm-msr.appspot.com/render?id=GTM-NCR8W3  gtm-msr http://www.google.com.ua/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&ved=0CCMQFjAD&url=https%3A%2F%2Fwww.googletagmanager.com%2Fset_cookie%3Fid%3DGTM-NCR8W3%26gtm_preview%3D3%26gtm_auth%3DiZf6fFEi2zTdWJY1PqmpaA%26gtm_scan%3D1&ei=JgzbU_PwM-nQuQPvEg&usg=AFQjCNEcVC5uVA9RsIFxXBPWXf1TzU-GxA https gtm-msr.appspot.com 80  /render id=GTM-NCR8W3   http  www.google.com.ua 80  /url  sa=t&rct=j&q=&esrc=s&source=web&cd=3&ved=0CCMQFjAD&url=https%3A%2F%2Fwww.googletagmanager.com%2Fset_cookie%3Fid%3DGTM-NCR8W3%26gtm_preview%3D3%26gtm_auth%3DiZf6fFEi2zTdWJY1PqmpaA%26gtm_scan%3D1&ei=JgzbU_PwM-nQuQPvEg&usg=AFQjCNEcVC5uVA9RsIFxXBPWXf1TzU-GxA    search  Google                                                                  Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1)  page_view                                                                                                                                                   

The error is pretty vague so if anyone's had this problem before or has some ideas of what I could check out that would be awesome!

Thanks so much,

Elijah

[Alex Dean]

I can't see anything wrong with that line - what's the exact error in stl_load_errors?

A

--
You received this message because you are subscribed to the Google Groups "Snowplow" group.
To unsubscribe from this group and stop receiving emails from it, send an email to snowplow-use...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Co-founder
Snowplow Analytics
The Roma Building, 32-38 Scrutton Street, London EC2A 4RQ, United Kingdom
+44 (0)203 589 6116
+44 7881 622 925
@alexcrdean

[Elijah Tabb]

The exact error is 8001 Invalid data, not very helpful unfortunately.