cal-itp-sentry[bot]

Results 10 issues of cal-itp-sentry[bot]

Sentry Issue: [CAL-ITP-DATA-INFRA-27T5](https://sentry.calitp.org/organizations/sentry/issues/74220/?referrer=github_integration) ``` ValueError: Unparseable zip: File/directory structure within zipfile cannot be unpacked File "unzip_gtfs_schedule.py", line 165, in unzip_individual_feed zipfile_files, zipfile_md5_hash = process_feed_files( File "unzip_gtfs_schedule.py", line 125, in process_feed_files...

It seems that a column was changed in Airtable in the Transit Data Quality Issues table and because we use schema auto-detect (i.e., no schema is explicitly specified) in the...

As a Cal-ITP GTFS data user, I want rows to be unique at the expected level so that they don't cause unexpected fanout in joins. Specifically, rows in `dim_calendar_dates` with...

Sentry Issue: [CAL-ITP-DATA-INFRA-145X](https://sentry.calitp.org/organizations/sentry/issues/37083/?referrer=github_integration) ``` DbtTestFail: test.calitp_warehouse.unique_int_gtfs_quality__rt_validation_outcomes_key.6c4eae7fe1 - Got 1 result, configured to fail if != 0 ``` This is failing because there are hours with null extracts; I think the...

data-pipeline-ingestion-and-modeling

As a Cal-ITP data user, I don't want duplicate data in the warehouse so that I can be sure that my joins won't cause fanout. Specifically, we don't want duplicate...

Sentry Issue: [CAL-ITP-DATA-INFRA-24J2](https://sentry.calitp.org/organizations/sentry/issues/70478/?referrer=github_integration) ``` CalledProcessError: Command '['java', '-jar', '/gtfs-realtime-validator.jar', '-gtfs', '/tmp/tmpojtth514/google_transit.zip', '-gtfsRealtimePath', '/tmp/tmpojtth514/rt_44a2869ad642dfa9a626ddd7995e0393/', '-sort', 'name']' returned non-zero exit status 1. File "gtfs_rt_parser.py", line 634, in parse_and_validate return validate_and_upload( File "gtfs_rt_parser.py",...

Sentry Issue: [CAL-ITP-DATA-INFRA-24D4](https://sentry.calitp.org/organizations/sentry/issues/70320/?referrer=github_integration) ``` CalledProcessError: Command '['java', '-jar', '/gtfs-realtime-validator.jar', '-gtfs', '/tmp/tmpwd5haiit/google_transit.zip', '-gtfsRealtimePath', '/tmp/tmpwd5haiit/rt_ac6acf70d5c9ebf9164e3e789b678196/', '-sort', 'name']' returned non-zero exit status 1. File "gtfs_rt_parser.py", line 634, in parse_and_validate return validate_and_upload( File "gtfs_rt_parser.py",...

Sentry Issue: [CAL-ITP-DATA-INFRA-25HW](https://sentry.calitp.org/organizations/sentry/issues/71514/?referrer=github_integration) ``` DbtTestFail: test.calitp_warehouse.dbt_utils_expression_is_true_int_gtfs_schedule__stop_times_grouped__num_gtfs_flex_stop_times_0_is_gtfs_flex_trip.73b2c7213d - Got 14 results, configured to fail if != 0 ```

Sentry Issues: [CAL-ITP-DATA-INFRA-2458](https://sentry.calitp.org/organizations/sentry/issues/70017/) and [CAL-ITP-DATA-INFRA-13Q0](https://sentry.calitp.org/organizations/sentry/issues/36605) ``` DbtTestFail: test.calitp_warehouse.unique_fct_trip_updates_no_stop_times_key.907b2fcc09 - Got 3844 results, configured to fail if != 0 ``` and ``` DbtTestFail: test.calitp_warehouse.unique_fct_trip_updates_messages_key.8b49751ebd - Got 5 results, configured to fail...

data-pipeline-ingestion-and-modeling

Sentry Issue: [CAL-ITP-DATA-INFRA-24DD](https://sentry.calitp.org/organizations/sentry/issues/70329/?referrer=github_integration) ``` CalledProcessError: Command '['java', '-jar', '/gtfs-realtime-validator.jar', '-gtfs', '/tmp/tmpuqdpd_uu/gtfs.zip', '-gtfsRealtimePath', '/tmp/tmpuqdpd_uu/rt_5cb55aa2d061fe9b41335ec1650d27ef/', '-sort', 'name']' returned non-zero exit status 1. File "gtfs_rt_parser.py", line 634, in parse_and_validate return validate_and_upload( File "gtfs_rt_parser.py",...