search

dbt-labs / dbt-core

dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.
https://getdbt.com
Apache License 2.0
9.71k stars 1.61k forks source link

Compilation error when defining sources in dbt_project.yml #3132

Closed marinsix closed 3 years ago

marinsix commented 3 years ago

Describe the bug

Unable to compile sources definition in dbt_project.yml. When i define my sources, I have this compilation error : 

Running with dbt=0.18.1
Encountered an error while reading the project:
  ERROR: Runtime Error
  at path ['sources']: [{'name': 'source', 'tables': [{'name': 'rox_events'}]}, {'name': 'eventbus', 'database': 'core', 'tables': [{'name': 'events'}]}, {'name': 'dwh', 'database': 'bi', 'tables': [{'name': 'customer'}, {'name': 'customer_security_flag'}]}] is not of type 'object'

Error encountered in /usr/src/develop/user-16695/environment-17120/repository-13929/dbt_project.yml
Runtime Error
  Could not run dbt

Steps To Reproduce

In dbt_project.yml file, add this section :

sources:
  - name: source
    tables:
      - name: rox_events
  - name: eventbus
    database: core
    tables:
      - name: events
  - name: dwh
    database: bi
    tables:
      - name: customer
      - name: customer_security_flag

Save the file. I have this long error message : 

Running with dbt=0.18.1
Serving RPC server at 0.0.0.0:8580, pid=16
Supported methods: ['cli_args', 'compile', 'compile_sql', 'deps', 'docs.generate', 'gc', 'get-manifest', 'kill', 'poll', 'ps', 'run', 'run-operation', 'run_sql', 'seed', 'snapshot', 'snapshot-freshness', 'status', 'test']
Send requests to http://localhost:8580/jsonrpc
handling status request
sending response (<Response 184 bytes [200 OK]>) to 10.0.4.19
handling status request
sending response (<Response 184 bytes [200 OK]>) to 10.0.22.116
handling status request
sending response (<Response 184 bytes [200 OK]>) to 10.0.4.19
handling status request
sending response (<Response 39941 bytes [200 OK]>) to 10.0.0.148
handling ps request
sending response (<Response 104 bytes [200 OK]>) to 10.0.29.185
handling status request
sending response (<Response 39941 bytes [200 OK]>) to 10.0.41.240
handling status request
sending response (<Response 39941 bytes [200 OK]>) to 10.0.29.185
handling status request
sending response (<Response 39941 bytes [200 OK]>) to 10.0.7.123
handling cli_args request
sending response (<Response 190 bytes [200 OK]>) to 10.0.44.55
handling status request
sending response (<Response 39941 bytes [200 OK]>) to 10.0.29.185
handling status request
sending response (<Response 39941 bytes [200 OK]>) to 10.0.32.128
handling status request
sending response (<Response 39941 bytes [200 OK]>) to 10.0.41.240
handling cli_args request
sending response (<Response 137 bytes [200 OK]>) to 10.0.29.185
handling poll request
sending response (<Response 9960 bytes [200 OK]>) to 10.0.3.75
handling poll request
sending response (<Response 30426 bytes [200 OK]>) to 10.0.41.240
handling poll request
sending response (<Response 341 bytes [200 OK]>) to 10.0.5.121
handling poll request
sending response (<Response 341 bytes [200 OK]>) to 10.0.32.128
Found 43 models, 157 tests, 0 snapshots, 0 analyses, 317 macros, 0 operations, 8 seed files, 0 sources

handling poll request
sending response (<Response 2620 bytes [200 OK]>) to 10.0.15.121
handling poll request
sending response (<Response 4241 bytes [200 OK]>) to 10.0.29.185
10:42:40 | Concurrency: 1 threads (target='dev')
10:42:40 | 
10:42:40 | 1 of 157 START test accepted_values_rox_audience_user_APP__Expekt__Betclic [RUN]
handling poll request
sending response (<Response 8356 bytes [200 OK]>) to 10.0.47.69
10:42:42 | 1 of 157 PASS accepted_values_rox_audience_user_APP__Expekt__Betclic. [PASS in 2.06s]
10:42:42 | 2 of 157 START test accepted_values_rox_audience_user_CHANNEL__DE__HU__PL__IT__FI__SV__EXPEKT__NO__EN__PA__PT__FR__BR__COM__ES [RUN]
handling poll request
sending response (<Response 11646 bytes [200 OK]>) to 10.0.4.19
10:42:44 | 2 of 157 PASS accepted_values_rox_audience_user_CHANNEL__DE__HU__PL__IT__FI__SV__EXPEKT__NO__EN__PA__PT__FR__BR__COM__ES [PASS in 1.39s]
10:42:44 | 3 of 157 START test accepted_values_rox_audience_user_DEPOSITOR__TRUE [RUN]
10:42:45 | 3 of 157 PASS accepted_values_rox_audience_user_DEPOSITOR__TRUE...... [PASS in 1.23s]
10:42:45 | 4 of 157 START test accepted_values_rox_audience_user_NUAP__TRUE..... [RUN]
handling poll request
sending response (<Response 14352 bytes [200 OK]>) to 10.0.41.240
10:42:46 | 4 of 157 PASS accepted_values_rox_audience_user_NUAP__TRUE........... [PASS in 1.35s]
10:42:46 | 5 of 157 START test accepted_values_rox_audience_user_PLATFORM__web__android__ios__mobileweb [RUN]
handling poll request
sending response (<Response 12230 bytes [200 OK]>) to 10.0.18.94
10:42:48 | 5 of 157 PASS accepted_values_rox_audience_user_PLATFORM__web__android__ios__mobileweb [PASS in 1.48s]
10:42:48 | 6 of 157 START test accepted_values_rox_audience_user_REGISTERED__TRUE [RUN]
handling poll request
sending response (<Response 5898 bytes [200 OK]>) to 10.0.5.121
10:42:50 | 6 of 157 PASS accepted_values_rox_audience_user_REGISTERED__TRUE..... [PASS in 2.66s]
10:42:50 | 7 of 157 START test accepted_values_rox_audience_user_UAP__TRUE...... [RUN]
handling poll request
sending response (<Response 8608 bytes [200 OK]>) to 10.0.18.94
10:42:52 | 7 of 157 PASS accepted_values_rox_audience_user_UAP__TRUE............ [PASS in 1.59s]
10:42:52 | 8 of 157 START test accepted_values_rox_audience_visitor_APP__Expekt__Betclic [RUN]
10:42:53 | 8 of 157 PASS accepted_values_rox_audience_visitor_APP__Expekt__Betclic [PASS in 1.19s]
10:42:53 | 9 of 157 START test accepted_values_rox_audience_visitor_CHANNEL__DE__HU__PL__IT__FI__SV__EXPEKT__NO__EN__PA__PT__FR__BR__COM__ES [RUN]
handling poll request
sending response (<Response 18313 bytes [200 OK]>) to 10.0.3.75
10:42:54 | 9 of 157 PASS accepted_values_rox_audience_visitor_CHANNEL__DE__HU__PL__IT__FI__SV__EXPEKT__NO__EN__PA__PT__FR__BR__COM__ES [PASS in 1.26s]
10:42:54 | 10 of 157 START test accepted_values_rox_audience_visitor_FIRST_LAUNCH__TRUE [RUN]
handling poll request
sending response (<Response 12847 bytes [200 OK]>) to 10.0.4.19
10:42:56 | 10 of 157 PASS accepted_values_rox_audience_visitor_FIRST_LAUNCH__TRUE [PASS in 1.33s]
10:42:56 | 11 of 157 START test accepted_values_rox_audience_visitor_PLATFORM__web__android__ios__mobileweb [RUN]
10:42:57 | 11 of 157 PASS accepted_values_rox_audience_visitor_PLATFORM__web__android__ios__mobileweb [PASS in 1.19s]
10:42:57 | 12 of 157 START test accepted_values_rox_audience_visitor_REGISTERED__TRUE [RUN]
handling poll request
sending response (<Response 15123 bytes [200 OK]>) to 10.0.32.128
10:42:58 | 12 of 157 PASS accepted_values_rox_audience_visitor_REGISTERED__TRUE. [PASS in 1.28s]
10:42:58 | 13 of 157 START test accepted_values_rox_device_APP__ExpextSeMobile__ShakeCasinoCom__Expekt__Betclic [RUN]
handling poll request
sending response (<Response 12572 bytes [200 OK]>) to 10.0.18.94
10:43:00 | 13 of 157 PASS accepted_values_rox_device_APP__ExpextSeMobile__ShakeCasinoCom__Expekt__Betclic [PASS in 1.55s]
10:43:00 | 14 of 157 START test accepted_values_rox_device_CHANNEL__DE__HU__PL__IT__FI__SV__EXPEKT__NO__EN__PA__PT__BR__FR__COM__ES [RUN]
10:43:01 | 14 of 157 PASS accepted_values_rox_device_CHANNEL__DE__HU__PL__IT__FI__SV__EXPEKT__NO__EN__PA__PT__BR__FR__COM__ES [PASS in 1.29s]
10:43:01 | 15 of 157 START test accepted_values_rox_device_HAS_ALREADY_LOGGED_ONCE__true__false [RUN]
handling poll request
sending response (<Response 16278 bytes [200 OK]>) to 10.0.44.55
handling poll request
sending response (<Response 3860 bytes [200 OK]>) to 10.0.47.69
10:43:03 | 15 of 157 PASS accepted_values_rox_device_HAS_ALREADY_LOGGED_ONCE__true__false [PASS in 2.38s]
10:43:03 | 16 of 157 START test accepted_values_rox_device_PLATFORM__android__web__mobileweb__ios [RUN]
10:43:05 | 16 of 157 PASS accepted_values_rox_device_PLATFORM__android__web__mobileweb__ios [PASS in 1.84s]
10:43:05 | 17 of 157 START test accepted_values_rox_device_PUSH_ACTIVE__true__false [RUN]
handling poll request
sending response (<Response 14345 bytes [200 OK]>) to 10.0.32.128
handling poll request
sending response (<Response 2061 bytes [200 OK]>) to 10.0.3.75
10:43:08 | 17 of 157 PASS accepted_values_rox_device_PUSH_ACTIVE__true__false... [PASS in 2.75s]
10:43:08 | 18 of 157 START test accepted_values_rox_onboarding_APP__ExpextSeMobile__ShakeCasinoCom__Expekt__Betclic [RUN]
handling poll request
sending response (<Response 10939 bytes [200 OK]>) to 10.0.11.216
10:43:10 | 18 of 157 PASS accepted_values_rox_onboarding_APP__ExpextSeMobile__ShakeCasinoCom__Expekt__Betclic [PASS in 1.59s]
10:43:10 | 19 of 157 START test accepted_values_rox_onboarding_CHANNEL__DE__HU__PL__IT__FI__SV__EXPEKT__NO__EN__PA__PT__FR__BR__COM__ES [RUN]
handling poll request
sending response (<Response 10472 bytes [200 OK]>) to 10.0.5.121
10:43:12 | 19 of 157 PASS accepted_values_rox_onboarding_CHANNEL__DE__HU__PL__IT__FI__SV__EXPEKT__NO__EN__PA__PT__FR__BR__COM__ES [PASS in 2.01s]
10:43:12 | 20 of 157 START test accepted_values_rox_onboarding_PLATFORM__web__android__ios__mobileweb [RUN]
10:43:13 | 20 of 157 PASS accepted_values_rox_onboarding_PLATFORM__web__android__ios__mobileweb [PASS in 1.51s]
10:43:13 | 21 of 157 START test accepted_values_rox_onboarding_prereg_APP__ExpextSeMobile__ShakeCasinoCom__Expekt__Betclic [RUN]
handling poll request
sending response (<Response 15862 bytes [200 OK]>) to 10.0.47.69
10:43:15 | 21 of 157 PASS accepted_values_rox_onboarding_prereg_APP__ExpextSeMobile__ShakeCasinoCom__Expekt__Betclic [PASS in 1.47s]
10:43:15 | 22 of 157 START test accepted_values_rox_onboarding_prereg_CHANNEL__DE__HU__PL__IT__FI__SV__EXPEKT__NO__EN__PA__PT__FR__BR__COM__ES [RUN]
handling poll request
sending response (<Response 12640 bytes [200 OK]>) to 10.0.41.240
10:43:16 | 22 of 157 PASS accepted_values_rox_onboarding_prereg_CHANNEL__DE__HU__PL__IT__FI__SV__EXPEKT__NO__EN__PA__PT__FR__BR__COM__ES [PASS in 1.44s]
10:43:16 | 23 of 157 START test accepted_values_rox_onboarding_prereg_PLATFORM__web__android__ios__mobileweb [RUN]
handling poll request
sending response (<Response 11777 bytes [200 OK]>) to 10.0.7.123
10:43:17 | 23 of 157 PASS accepted_values_rox_onboarding_prereg_PLATFORM__web__android__ios__mobileweb [PASS in 1.33s]
10:43:17 | 24 of 157 START test accepted_values_rox_onboarding_user_APP__ExpextSeMobile__ShakeCasinoCom__Expekt__Betclic [RUN]
10:43:19 | 24 of 157 PASS accepted_values_rox_onboarding_user_APP__ExpextSeMobile__ShakeCasinoCom__Expekt__Betclic [PASS in 1.43s]
10:43:19 | 25 of 157 START test accepted_values_rox_onboarding_user_CHANNEL__DE__HU__PL__IT__FI__SV__EXPEKT__NO__EN__PA__PT__FR__BR__COM__ES [RUN]
handling poll request
sending response (<Response 16246 bytes [200 OK]>) to 10.0.32.128
10:43:20 | 25 of 157 PASS accepted_values_rox_onboarding_user_CHANNEL__DE__HU__PL__IT__FI__SV__EXPEKT__NO__EN__PA__PT__FR__BR__COM__ES [PASS in 1.59s]
10:43:20 | 26 of 157 START test accepted_values_rox_onboarding_user_PLATFORM__web__android__ios__mobileweb [RUN]
handling poll request
sending response (<Response 10160 bytes [200 OK]>) to 10.0.22.116
10:43:22 | 26 of 157 PASS accepted_values_rox_onboarding_user_PLATFORM__web__android__ios__mobileweb [PASS in 1.64s]
10:43:22 | 27 of 157 START test accepted_values_rox_user_APP__ExpextSeMobile__ShakeCasinoCom__Expekt__Betclic [RUN]
handling poll request
sending response (<Response 11519 bytes [200 OK]>) to 10.0.4.19
10:43:24 | 27 of 157 PASS accepted_values_rox_user_APP__ExpextSeMobile__ShakeCasinoCom__Expekt__Betclic [PASS in 1.85s]
10:43:24 | 28 of 157 START test accepted_values_rox_user_APP__ShakeCasinoCom__Expekt__Betclic [RUN]
handling poll request
sending response (<Response 10552 bytes [200 OK]>) to 10.0.3.75
10:43:26 | 28 of 157 PASS accepted_values_rox_user_APP__ShakeCasinoCom__Expekt__Betclic [PASS in 1.67s]
10:43:26 | 29 of 157 START test accepted_values_rox_user_CHANNEL__DE__HU__PL__IT__FI__SV__EXPEKT__NO__EN__PA__PT__FR__BR__COM__ES [RUN]
10:43:27 | 29 of 157 PASS accepted_values_rox_user_CHANNEL__DE__HU__PL__IT__FI__SV__EXPEKT__NO__EN__PA__PT__FR__BR__COM__ES [PASS in 1.32s]
10:43:27 | 30 of 157 START test accepted_values_rox_user_FIRSTBETPLATFORM__web__android__ios__mobileweb [RUN]
handling poll request
sending response (<Response 16240 bytes [200 OK]>) to 10.0.44.55
10:43:28 | 30 of 157 PASS accepted_values_rox_user_FIRSTBETPLATFORM__web__android__ios__mobileweb [PASS in 1.21s]
10:43:28 | 31 of 157 START test accepted_values_rox_user_FIRSTDEPOSITPLATFORM__web__android__ios__mobileweb [RUN]
handling poll request
sending response (<Response 13206 bytes [200 OK]>) to 10.0.7.123
10:43:29 | 31 of 157 PASS accepted_values_rox_user_FIRSTDEPOSITPLATFORM__web__android__ios__mobileweb [PASS in 1.28s]
10:43:29 | 32 of 157 START test accepted_values_rox_user_FIRSTWITHDRAWALPLATFORM__web__android__ios__mobileweb [RUN]
10:43:31 | 32 of 157 PASS accepted_values_rox_user_FIRSTWITHDRAWALPLATFORM__web__android__ios__mobileweb [PASS in 1.55s]
10:43:31 | 33 of 157 START test accepted_values_rox_user_HASOPTINANDROID__TRUE__FALSE [RUN]
handling poll request
sending response (<Response 14880 bytes [200 OK]>) to 10.0.7.123
10:43:32 | 33 of 157 PASS accepted_values_rox_user_HASOPTINANDROID__TRUE__FALSE. [PASS in 1.47s]
10:43:32 | 34 of 157 START test accepted_values_rox_user_HASOPTINIOS__TRUE__FALSE [RUN]
handling poll request
sending response (<Response 10459 bytes [200 OK]>) to 10.0.44.55
10:43:34 | 34 of 157 PASS accepted_values_rox_user_HASOPTINIOS__TRUE__FALSE..... [PASS in 1.70s]
10:43:34 | 35 of 157 START test accepted_values_rox_user_REGISTEREDPLATFORM__web__android__ios__mobileweb [RUN]
handling poll request
sending response (<Response 10625 bytes [200 OK]>) to 10.0.0.148
10:43:36 | 35 of 157 PASS accepted_values_rox_user_REGISTEREDPLATFORM__web__android__ios__mobileweb [PASS in 2.21s]
10:43:36 | 36 of 157 START test not_null_campaign_APPLICATIONID................. [RUN]
handling poll request
sending response (<Response 8884 bytes [200 OK]>) to 10.0.15.46
10:43:37 | 36 of 157 ERROR not_null_campaign_APPLICATIONID...................... [ERROR in 1.22s]
10:43:37 | 37 of 157 START test not_null_campaign_CAMPAIGNSK.................... [RUN]
10:43:39 | 37 of 157 ERROR not_null_campaign_CAMPAIGNSK......................... [ERROR in 1.41s]
10:43:39 | 38 of 157 START test not_null_campaign_CAMPAIGNSTATUSSK.............. [RUN]
handling poll request
sending response (<Response 20605 bytes [200 OK]>) to 10.0.41.240
10:43:40 | 38 of 157 ERROR not_null_campaign_CAMPAIGNSTATUSSK................... [ERROR in 1.21s]
10:43:40 | 39 of 157 START test not_null_campaign_CAMPAIGNTYPESK................ [RUN]
handling poll request
sending response (<Response 12258 bytes [200 OK]>) to 10.0.32.128
10:43:41 | 39 of 157 ERROR not_null_campaign_CAMPAIGNTYPESK..................... [ERROR in 1.15s]
10:43:41 | 40 of 157 START test not_null_campaign_CREATIONDATETIME.............. [RUN]
handling poll request
sending response (<Response 12244 bytes [200 OK]>) to 10.0.7.123
10:43:43 | 40 of 157 ERROR not_null_campaign_CREATIONDATETIME................... [ERROR in 1.29s]
10:43:43 | 41 of 157 START test not_null_program_APPLICATION.................... [RUN]
handling poll request
sending response (<Response 13530 bytes [200 OK]>) to 10.0.7.123
10:43:44 | 41 of 157 PASS not_null_program_APPLICATION.......................... [PASS in 1.31s]
10:43:44 | 42 of 157 START test not_null_program_CATEGORY....................... [RUN]
handling poll request
sending response (<Response 7693 bytes [200 OK]>) to 10.0.7.123
10:43:45 | 42 of 157 PASS not_null_program_CATEGORY............................. [PASS in 1.19s]
10:43:45 | 43 of 157 START test not_null_program_CREATOR........................ [RUN]
handling poll request
sending response (<Response 8782 bytes [200 OK]>) to 10.0.44.55
10:43:46 | 43 of 157 PASS not_null_program_CREATOR.............................. [PASS in 1.28s]
10:43:46 | 44 of 157 START test not_null_program_DESCRIPTION.................... [RUN]
handling poll request
sending response (<Response 7745 bytes [200 OK]>) to 10.0.29.185
10:43:48 | 44 of 157 PASS not_null_program_DESCRIPTION.......................... [PASS in 1.22s]
10:43:48 | 45 of 157 START test not_null_program_IS_LAST_ACTIVATED_VERSION...... [RUN]
handling poll request
sending response (<Response 8535 bytes [200 OK]>) to 10.0.15.46
10:43:49 | 45 of 157 PASS not_null_program_IS_LAST_ACTIVATED_VERSION............ [PASS in 1.21s]
10:43:49 | 46 of 157 START test not_null_program_LAST_ACTIVATED_RELEASE_VERSION. [RUN]
handling poll request
sending response (<Response 8377 bytes [200 OK]>) to 10.0.29.185
10:43:50 | 46 of 157 PASS not_null_program_LAST_ACTIVATED_RELEASE_VERSION....... [PASS in 1.36s]
10:43:50 | 47 of 157 START test not_null_program_MISSION_NAME................... [RUN]
10:43:51 | 47 of 157 PASS not_null_program_MISSION_NAME......................... [PASS in 1.31s]
10:43:51 | 48 of 157 START test not_null_program_NAME........................... [RUN]
handling poll request
sending response (<Response 10822 bytes [200 OK]>) to 10.0.11.216
handling poll request
sending response (<Response 4588 bytes [200 OK]>) to 10.0.32.128
10:43:53 | 48 of 157 PASS not_null_program_NAME................................. [PASS in 1.46s]
10:43:53 | 49 of 157 START test not_null_program_PROGRAM_VERSION_MISSION_SK..... [RUN]
handling poll request
sending response (<Response 8194 bytes [200 OK]>) to 10.0.18.94
10:43:54 | 49 of 157 PASS not_null_program_PROGRAM_VERSION_MISSION_SK........... [PASS in 1.31s]
10:43:54 | 50 of 157 START test not_null_program_RELEASE_VERSION................ [RUN]
10:43:55 | 50 of 157 PASS not_null_program_RELEASE_VERSION...................... [PASS in 1.19s]
10:43:55 | 51 of 157 START test not_null_program_SOURCE_DYNAMO_PROGRAM_MISSION_ID [RUN]
handling poll request
sending response (<Response 12883 bytes [200 OK]>) to 10.0.7.123
10:43:57 | 51 of 157 PASS not_null_program_SOURCE_DYNAMO_PROGRAM_MISSION_ID..... [PASS in 1.25s]
10:43:57 | 52 of 157 START test not_null_program_STATUS......................... [RUN]
handling poll request
sending response (<Response 8016 bytes [200 OK]>) to 10.0.7.123
10:43:58 | 52 of 157 PASS not_null_program_STATUS............................... [PASS in 1.18s]
10:43:58 | 53 of 157 START test not_null_program_VERSION_ACTIVATOR.............. [RUN]
handling poll request
sending response (<Response 7787 bytes [200 OK]>) to 10.0.47.69
10:43:59 | 53 of 157 PASS not_null_program_VERSION_ACTIVATOR.................... [PASS in 1.25s]
10:43:59 | 54 of 157 START test not_null_program_VERSION_CREATOR................ [RUN]
handling poll request
sending response (<Response 7929 bytes [200 OK]>) to 10.0.4.19
10:44:01 | 54 of 157 PASS not_null_program_VERSION_CREATOR...................... [PASS in 1.43s]
10:44:01 | 55 of 157 START test not_null_program_VERSION_START_DATE............. [RUN]
handling poll request
sending response (<Response 7948 bytes [200 OK]>) to 10.0.4.19
10:44:02 | 55 of 157 PASS not_null_program_VERSION_START_DATE................... [PASS in 1.46s]
10:44:02 | 56 of 157 START test not_null_program_VERSION_STATUS................. [RUN]
handling poll request
sending response (<Response 7928 bytes [200 OK]>) to 10.0.3.75
10:44:04 | 56 of 157 PASS not_null_program_VERSION_STATUS....................... [PASS in 1.53s]
10:44:04 | 57 of 157 START test not_null_program_user_mission_CLAIMS_SETTLED.... [RUN]
handling poll request
sending response (<Response 9546 bytes [200 OK]>) to 10.0.29.185
10:44:05 | 57 of 157 PASS not_null_program_user_mission_CLAIMS_SETTLED.......... [PASS in 1.35s]
10:44:05 | 58 of 157 START test not_null_program_user_mission_END_DATE.......... [RUN]
10:44:06 | 58 of 157 PASS not_null_program_user_mission_END_DATE................ [PASS in 1.21s]
10:44:06 | 59 of 157 START test not_null_program_user_mission_GOALS............. [RUN]
handling poll request
sending response (<Response 14473 bytes [200 OK]>) to 10.0.3.75
10:44:07 | 59 of 157 PASS not_null_program_user_mission_GOALS................... [PASS in 1.24s]
10:44:07 | 60 of 157 START test not_null_program_user_mission_PROGRAM_VERSION_MISSION_SK [RUN]
handling poll request
sending response (<Response 11174 bytes [200 OK]>) to 10.0.15.46
10:44:08 | 60 of 157 PASS not_null_program_user_mission_PROGRAM_VERSION_MISSION_SK [PASS in 1.14s]
10:44:08 | 61 of 157 START test not_null_program_user_mission_SOURCE_DYNAMO_USER_MISSION_ID [RUN]
10:44:10 | 61 of 157 PASS not_null_program_user_mission_SOURCE_DYNAMO_USER_MISSION_ID [PASS in 1.21s]
10:44:10 | 62 of 157 START test not_null_program_user_mission_START_DATE........ [RUN]
handling poll request
sending response (<Response 14109 bytes [200 OK]>) to 10.0.22.116
10:44:11 | 62 of 157 PASS not_null_program_user_mission_START_DATE.............. [PASS in 1.36s]
10:44:11 | 63 of 157 START test not_null_program_user_mission_STATUS............ [RUN]
10:44:12 | 63 of 157 PASS not_null_program_user_mission_STATUS.................. [PASS in 1.22s]
10:44:12 | 64 of 157 START test not_null_program_user_mission_UPDATED_DATE...... [RUN]
handling poll request
sending response (<Response 13886 bytes [200 OK]>) to 10.0.5.121
handling poll request
sending response (<Response 5390 bytes [200 OK]>) to 10.0.18.94
10:44:14 | 64 of 157 PASS not_null_program_user_mission_UPDATED_DATE............ [PASS in 1.37s]
10:44:14 | 65 of 157 START test not_null_program_user_mission_USER_ID........... [RUN]
handling poll request
sending response (<Response 8091 bytes [200 OK]>) to 10.0.44.55
10:44:15 | 65 of 157 PASS not_null_program_user_mission_USER_ID................. [PASS in 1.40s]
10:44:15 | 66 of 157 START test not_null_rox_audience_user_APP_VER.............. [RUN]
handling poll request
sending response (<Response 7987 bytes [200 OK]>) to 10.0.29.185
10:44:16 | 66 of 157 PASS not_null_rox_audience_user_APP_VER.................... [PASS in 1.26s]
10:44:16 | 67 of 157 START test not_null_rox_audience_user_APP_VER_INT.......... [RUN]
10:44:17 | 67 of 157 PASS not_null_rox_audience_user_APP_VER_INT................ [PASS in 1.20s]
10:44:17 | 68 of 157 START test not_null_rox_audience_user_AU_PK................ [RUN]
handling poll request
sending response (<Response 12793 bytes [200 OK]>) to 10.0.7.123
10:44:19 | 68 of 157 PASS not_null_rox_audience_user_AU_PK...................... [PASS in 1.15s]
10:44:19 | 69 of 157 START test not_null_rox_audience_user_CHANNEL.............. [RUN]
handling poll request
sending response (<Response 7946 bytes [200 OK]>) to 10.0.44.55
10:44:20 | 69 of 157 PASS not_null_rox_audience_user_CHANNEL.................... [PASS in 1.21s]
10:44:20 | 70 of 157 START test not_null_rox_audience_user_NB_SESSION........... [RUN]
handling poll request
sending response (<Response 8029 bytes [200 OK]>) to 10.0.4.19
10:44:21 | 70 of 157 PASS not_null_rox_audience_user_NB_SESSION................. [PASS in 1.22s]
10:44:21 | 71 of 157 START test not_null_rox_audience_user_PLATFORM............. [RUN]
handling poll request
sending response (<Response 8043 bytes [200 OK]>) to 10.0.32.128
10:44:23 | 71 of 157 PASS not_null_rox_audience_user_PLATFORM................... [PASS in 1.44s]
10:44:23 | 72 of 157 START test not_null_rox_audience_user_USER_ID.............. [RUN]
handling poll request
sending response (<Response 7994 bytes [200 OK]>) to 10.0.47.69
10:44:24 | 72 of 157 PASS not_null_rox_audience_user_USER_ID.................... [PASS in 1.51s]
10:44:24 | 73 of 157 START test not_null_rox_audience_visitor_APP_VER........... [RUN]
handling poll request
sending response (<Response 8032 bytes [200 OK]>) to 10.0.7.123
10:44:25 | 73 of 157 PASS not_null_rox_audience_visitor_APP_VER................. [PASS in 1.37s]
10:44:25 | 74 of 157 START test not_null_rox_audience_visitor_APP_VER_INT....... [RUN]
handling poll request
sending response (<Response 8148 bytes [200 OK]>) to 10.0.15.121
10:44:27 | 74 of 157 PASS not_null_rox_audience_visitor_APP_VER_INT............. [PASS in 1.24s]
10:44:27 | 75 of 157 START test not_null_rox_audience_visitor_AV_PK............. [RUN]
handling poll request
sending response (<Response 8110 bytes [200 OK]>) to 10.0.15.121
10:44:28 | 75 of 157 PASS not_null_rox_audience_visitor_AV_PK................... [PASS in 1.34s]
10:44:28 | 76 of 157 START test not_null_rox_audience_visitor_CHANNEL........... [RUN]
handling poll request
sending response (<Response 8047 bytes [200 OK]>) to 10.0.3.75
10:44:29 | 76 of 157 PASS not_null_rox_audience_visitor_CHANNEL................. [PASS in 1.26s]
10:44:29 | 77 of 157 START test not_null_rox_audience_visitor_DEVICE_UUID....... [RUN]
handling poll request
sending response (<Response 8148 bytes [200 OK]>) to 10.0.47.69
10:44:30 | 77 of 157 PASS not_null_rox_audience_visitor_DEVICE_UUID............. [PASS in 1.19s]
10:44:30 | 78 of 157 START test not_null_rox_audience_visitor_NB_SESSION........ [RUN]
handling poll request
sending response (<Response 8195 bytes [200 OK]>) to 10.0.7.123
10:44:32 | 78 of 157 PASS not_null_rox_audience_visitor_NB_SESSION.............. [PASS in 1.24s]
10:44:32 | 79 of 157 START test not_null_rox_audience_visitor_PLATFORM.......... [RUN]
handling poll request
sending response (<Response 9551 bytes [200 OK]>) to 10.0.3.75
10:44:33 | 79 of 157 PASS not_null_rox_audience_visitor_PLATFORM................ [PASS in 1.25s]
10:44:33 | 80 of 157 START test not_null_rox_backend_metagame_BET_ID............ [RUN]
handling poll request
sending response (<Response 8061 bytes [200 OK]>) to 10.0.4.19
10:44:34 | 80 of 157 PASS not_null_rox_backend_metagame_BET_ID.................. [PASS in 1.40s]
10:44:34 | 81 of 157 START test not_null_rox_backend_metagame_GOAL_INDEX........ [RUN]
handling poll request
sending response (<Response 8139 bytes [200 OK]>) to 10.0.32.128
10:44:36 | 81 of 157 PASS not_null_rox_backend_metagame_GOAL_INDEX.............. [PASS in 1.41s]
10:44:36 | 82 of 157 START test not_null_rox_backend_metagame_HISTORY_LIST...... [RUN]
handling poll request
sending response (<Response 8223 bytes [200 OK]>) to 10.0.3.75
10:44:37 | 82 of 157 PASS not_null_rox_backend_metagame_HISTORY_LIST............ [PASS in 1.25s]
10:44:37 | 83 of 157 START test not_null_rox_backend_metagame_IDENTIFIER........ [RUN]
handling poll request
sending response (<Response 8193 bytes [200 OK]>) to 10.0.44.55
10:44:38 | 83 of 157 PASS not_null_rox_backend_metagame_IDENTIFIER.............. [PASS in 1.31s]
10:44:38 | 84 of 157 START test not_null_rox_backend_metagame_PK................ [RUN]
handling poll request
sending response (<Response 9155 bytes [200 OK]>) to 10.0.18.94
10:44:39 | 84 of 157 PASS not_null_rox_backend_metagame_PK...................... [PASS in 1.14s]
10:44:39 | 85 of 157 START test not_null_rox_backend_metagame_PROGRESS.......... [RUN]
handling poll request
sending response (<Response 8449 bytes [200 OK]>) to 10.0.15.46
10:44:41 | 85 of 157 PASS not_null_rox_backend_metagame_PROGRESS................ [PASS in 1.22s]
10:44:41 | 86 of 157 START test not_null_rox_backend_metagame_SK................ [RUN]
handling poll request
sending response (<Response 7928 bytes [200 OK]>) to 10.0.5.121
10:44:42 | 86 of 157 PASS not_null_rox_backend_metagame_SK...................... [PASS in 1.36s]
10:44:42 | 87 of 157 START test not_null_rox_backend_metagame_UPDATED_DATE...... [RUN]
handling poll request
sending response (<Response 8211 bytes [200 OK]>) to 10.0.32.128
10:44:43 | 87 of 157 PASS not_null_rox_backend_metagame_UPDATED_DATE............ [PASS in 1.32s]
10:44:43 | 88 of 157 START test not_null_rox_backend_metagame_USER_ID........... [RUN]
10:44:44 | 88 of 157 PASS not_null_rox_backend_metagame_USER_ID................. [PASS in 1.14s]
10:44:44 | 89 of 157 START test not_null_rox_backend_metagame_USER_MISSION_IDENTIFIER [RUN]
handling poll request
sending response (<Response 15911 bytes [200 OK]>) to 10.0.4.19
10:44:46 | 89 of 157 PASS not_null_rox_backend_metagame_USER_MISSION_IDENTIFIER. [PASS in 1.17s]
10:44:46 | 90 of 157 START test not_null_rox_backend_mission_APPLICATION_ID..... [RUN]
10:44:47 | 90 of 157 PASS not_null_rox_backend_mission_APPLICATION_ID........... [PASS in 1.47s]
10:44:47 | 91 of 157 START test not_null_rox_backend_mission_ASSIGN_TRIGGER..... [RUN]
handling poll request
sending response (<Response 13598 bytes [200 OK]>) to 10.0.15.46
10:44:48 | 91 of 157 PASS not_null_rox_backend_mission_ASSIGN_TRIGGER........... [PASS in 1.20s]
10:44:48 | 92 of 157 START test not_null_rox_backend_mission_AUTO_CLAIMED_PLATFORMS [RUN]
handling poll request
sending response (<Response 11157 bytes [200 OK]>) to 10.0.32.128
10:44:50 | 92 of 157 PASS not_null_rox_backend_mission_AUTO_CLAIMED_PLATFORMS... [PASS in 1.36s]
10:44:50 | 93 of 157 START test not_null_rox_backend_mission_CLAIM_ACTIONS...... [RUN]
10:44:51 | 93 of 157 PASS not_null_rox_backend_mission_CLAIM_ACTIONS............ [PASS in 1.29s]
10:44:51 | 94 of 157 START test not_null_rox_backend_mission_CREATION_DATE...... [RUN]
handling poll request
sending response (<Response 13538 bytes [200 OK]>) to 10.0.15.121
10:44:52 | 94 of 157 PASS not_null_rox_backend_mission_CREATION_DATE............ [PASS in 1.19s]
10:44:52 | 95 of 157 START test not_null_rox_backend_mission_DESC............... [RUN]
10:44:53 | 95 of 157 PASS not_null_rox_backend_mission_DESC..................... [PASS in 1.16s]
10:44:53 | 96 of 157 START test not_null_rox_backend_mission_END_DATE........... [RUN]
handling poll request
sending response (<Response 15757 bytes [200 OK]>) to 10.0.22.116
10:44:55 | 96 of 157 PASS not_null_rox_backend_mission_END_DATE................. [PASS in 1.18s]
10:44:55 | 97 of 157 START test not_null_rox_backend_mission_FINISH_ACTIONS..... [RUN]
handling poll request
sending response (<Response 8177 bytes [200 OK]>) to 10.0.18.94
10:44:56 | 97 of 157 PASS not_null_rox_backend_mission_FINISH_ACTIONS........... [PASS in 1.44s]
10:44:56 | 98 of 157 START test not_null_rox_backend_mission_GOALS.............. [RUN]
handling poll request
sending response (<Response 11039 bytes [200 OK]>) to 10.0.11.216
10:44:57 | 98 of 157 PASS not_null_rox_backend_mission_GOALS.................... [PASS in 1.50s]
10:44:57 | 99 of 157 START test not_null_rox_backend_mission_IDENTIFIER......... [RUN]
10:44:59 | 99 of 157 PASS not_null_rox_backend_mission_IDENTIFIER............... [PASS in 1.31s]
10:44:59 | 100 of 157 START test not_null_rox_backend_mission_NAME.............. [RUN]
handling poll request
sending response (<Response 12840 bytes [200 OK]>) to 10.0.15.46
10:45:00 | 100 of 157 PASS not_null_rox_backend_mission_NAME.................... [PASS in 1.16s]
10:45:00 | 101 of 157 START test not_null_rox_backend_mission_OPTIN_TYPE........ [RUN]
handling poll request
sending response (<Response 11031 bytes [200 OK]>) to 10.0.15.121
10:45:01 | 101 of 157 PASS not_null_rox_backend_mission_OPTIN_TYPE.............. [PASS in 1.52s]
10:45:01 | 102 of 157 START test not_null_rox_backend_mission_START_ACTIONS..... [RUN]
10:45:03 | 102 of 157 PASS not_null_rox_backend_mission_START_ACTIONS........... [PASS in 1.28s]
10:45:03 | 103 of 157 START test not_null_rox_backend_mission_START_DATE........ [RUN]
handling poll request
sending response (<Response 13057 bytes [200 OK]>) to 10.0.15.121
10:45:04 | 103 of 157 PASS not_null_rox_backend_mission_START_DATE.............. [PASS in 1.27s]
10:45:04 | 104 of 157 START test not_null_rox_backend_user_mission_CLAIMS_SETTLED [RUN]
handling poll request
sending response (<Response 11402 bytes [200 OK]>) to 10.0.7.123
10:45:05 | 104 of 157 PASS not_null_rox_backend_user_mission_CLAIMS_SETTLED..... [PASS in 1.44s]
10:45:05 | 105 of 157 START test not_null_rox_backend_user_mission_END_DATE..... [RUN]
10:45:07 | 105 of 157 PASS not_null_rox_backend_user_mission_END_DATE........... [PASS in 1.24s]
10:45:07 | 106 of 157 START test not_null_rox_backend_user_mission_GOALS........ [RUN]
handling poll request
sending response (<Response 13094 bytes [200 OK]>) to 10.0.44.55
10:45:08 | 106 of 157 PASS not_null_rox_backend_user_mission_GOALS.............. [PASS in 1.48s]
10:45:08 | 107 of 157 START test not_null_rox_backend_user_mission_IDENTIFIER... [RUN]
handling poll request
sending response (<Response 11282 bytes [200 OK]>) to 10.0.29.185
10:45:09 | 107 of 157 PASS not_null_rox_backend_user_mission_IDENTIFIER......... [PASS in 1.22s]
10:45:09 | 108 of 157 START test not_null_rox_backend_user_mission_MISSION_IDENTIFIER [RUN]
10:45:11 | 108 of 157 PASS not_null_rox_backend_user_mission_MISSION_IDENTIFIER. [PASS in 1.24s]
10:45:11 | 109 of 157 START test not_null_rox_backend_user_mission_START_DATE... [RUN]
handling poll request
sending response (<Response 13502 bytes [200 OK]>) to 10.0.4.19
10:45:12 | 109 of 157 PASS not_null_rox_backend_user_mission_START_DATE......... [PASS in 1.44s]
10:45:12 | 110 of 157 START test not_null_rox_backend_user_mission_STATUS....... [RUN]
10:45:13 | 110 of 157 PASS not_null_rox_backend_user_mission_STATUS............. [PASS in 1.35s]
10:45:13 | 111 of 157 START test not_null_rox_backend_user_mission_UPDATED_DATE. [RUN]
handling poll request
sending response (<Response 16185 bytes [200 OK]>) to 10.0.0.148
10:45:15 | 111 of 157 PASS not_null_rox_backend_user_mission_UPDATED_DATE....... [PASS in 1.31s]
10:45:15 | 112 of 157 START test not_null_rox_backend_user_mission_USER_ID...... [RUN]
handling poll request
sending response (<Response 8293 bytes [200 OK]>) to 10.0.5.121
10:45:16 | 112 of 157 PASS not_null_rox_backend_user_mission_USER_ID............ [PASS in 1.31s]
10:45:16 | 113 of 157 START test not_null_rox_device_CHANNEL.................... [RUN]
10:45:17 | 113 of 157 PASS not_null_rox_device_CHANNEL.......................... [PASS in 1.25s]
10:45:17 | 114 of 157 START test not_null_rox_device_DEVICE_UUID................ [RUN]
handling poll request
sending response (<Response 13876 bytes [200 OK]>) to 10.0.4.19
10:45:19 | 114 of 157 PASS not_null_rox_device_DEVICE_UUID...................... [PASS in 1.37s]
10:45:19 | 115 of 157 START test not_null_rox_device_LAST_CONNECTION............ [RUN]
handling poll request
sending response (<Response 9498 bytes [200 OK]>) to 10.0.18.94
10:45:20 | 115 of 157 PASS not_null_rox_device_LAST_CONNECTION.................. [PASS in 1.39s]
10:45:20 | 116 of 157 START test not_null_rox_device_NB_FIRST_LAUNCH............ [RUN]
10:45:21 | 116 of 157 PASS not_null_rox_device_NB_FIRST_LAUNCH.................. [PASS in 1.18s]
10:45:21 | 117 of 157 START test not_null_rox_device_NB_USER_ID................. [RUN]
handling poll request
sending response (<Response 15584 bytes [200 OK]>) to 10.0.32.128
10:45:22 | 117 of 157 PASS not_null_rox_device_NB_USER_ID....................... [PASS in 1.24s]
10:45:22 | 118 of 157 START test not_null_rox_device_PLATFORM................... [RUN]
handling poll request
sending response (<Response 7806 bytes [200 OK]>) to 10.0.32.128
10:45:24 | 118 of 157 PASS not_null_rox_device_PLATFORM......................... [PASS in 1.60s]
10:45:24 | 119 of 157 START test not_null_rox_experiences_ab_DEVICE_UUID........ [RUN]
handling poll request
sending response (<Response 7969 bytes [200 OK]>) to 10.0.32.128
10:45:25 | 119 of 157 PASS not_null_rox_experiences_ab_DEVICE_UUID.............. [PASS in 1.36s]
10:45:25 | 120 of 157 START test not_null_rox_experiences_ab_EXP_PK............. [RUN]
handling poll request
sending response (<Response 8060 bytes [200 OK]>) to 10.0.11.216
handling poll request
sending response (<Response 3261 bytes [200 OK]>) to 10.0.41.240
10:45:27 | 120 of 157 PASS not_null_rox_experiences_ab_EXP_PK................... [PASS in 1.69s]
10:45:27 | 121 of 157 START test not_null_rox_onboarding_CHANNEL................ [RUN]
10:45:28 | 121 of 157 PASS not_null_rox_onboarding_CHANNEL...................... [PASS in 1.33s]
10:45:28 | 122 of 157 START test not_null_rox_onboarding_DEVICE_UUID............ [RUN]
handling poll request
sending response (<Response 12609 bytes [200 OK]>) to 10.0.0.148
10:45:30 | 122 of 157 PASS not_null_rox_onboarding_DEVICE_UUID.................. [PASS in 1.41s]
10:45:30 | 123 of 157 START test not_null_rox_onboarding_OB_PK.................. [RUN]
handling poll request
sending response (<Response 7906 bytes [200 OK]>) to 10.0.47.69
10:45:31 | 123 of 157 PASS not_null_rox_onboarding_OB_PK........................ [PASS in 1.27s]
10:45:31 | 124 of 157 START test not_null_rox_onboarding_ab_DEVICE_UUID......... [RUN]
handling poll request
sending response (<Response 7967 bytes [200 OK]>) to 10.0.4.19
10:45:33 | 124 of 157 PASS not_null_rox_onboarding_ab_DEVICE_UUID............... [PASS in 1.50s]
10:45:33 | 125 of 157 START test not_null_rox_onboarding_ab_EXPERIENCE.......... [RUN]
handling poll request
sending response (<Response 8094 bytes [200 OK]>) to 10.0.44.55
10:45:34 | 125 of 157 PASS not_null_rox_onboarding_ab_EXPERIENCE................ [PASS in 1.22s]
10:45:34 | 126 of 157 START test not_null_rox_onboarding_ab_OB_AB_PK............ [RUN]
handling poll request
sending response (<Response 9429 bytes [200 OK]>) to 10.0.32.128
10:45:35 | 126 of 157 PASS not_null_rox_onboarding_ab_OB_AB_PK.................. [PASS in 1.48s]
10:45:35 | 127 of 157 START test not_null_rox_onboarding_ab_TEST................ [RUN]
handling poll request
sending response (<Response 6559 bytes [200 OK]>) to 10.0.15.46
10:45:37 | 127 of 157 PASS not_null_rox_onboarding_ab_TEST...................... [PASS in 1.34s]
10:45:37 | 128 of 157 START test not_null_rox_onboarding_prereg_APP_VER......... [RUN]
handling poll request
sending response (<Response 8002 bytes [200 OK]>) to 10.0.29.185
10:45:38 | 128 of 157 PASS not_null_rox_onboarding_prereg_APP_VER............... [PASS in 1.49s]
10:45:38 | 129 of 157 START test not_null_rox_onboarding_prereg_CHANNEL......... [RUN]
handling poll request
sending response (<Response 8115 bytes [200 OK]>) to 10.0.15.46
10:45:39 | 129 of 157 PASS not_null_rox_onboarding_prereg_CHANNEL............... [PASS in 1.24s]
10:45:39 | 130 of 157 START test not_null_rox_onboarding_prereg_DEVICE_UUID..... [RUN]
handling poll request
sending response (<Response 8183 bytes [200 OK]>) to 10.0.29.185
10:45:41 | 130 of 157 PASS not_null_rox_onboarding_prereg_DEVICE_UUID........... [PASS in 1.54s]
10:45:41 | 131 of 157 START test not_null_rox_onboarding_prereg_OB_PREREG_PK.... [RUN]
handling poll request
sending response (<Response 8264 bytes [200 OK]>) to 10.0.29.185
10:45:42 | 131 of 157 PASS not_null_rox_onboarding_prereg_OB_PREREG_PK.......... [PASS in 1.25s]
10:45:42 | 132 of 157 START test not_null_rox_onboarding_user_CHANNEL........... [RUN]
handling poll request
sending response (<Response 8159 bytes [200 OK]>) to 10.0.11.216
10:45:43 | 132 of 157 PASS not_null_rox_onboarding_user_CHANNEL................. [PASS in 1.24s]
10:45:43 | 133 of 157 START test not_null_rox_onboarding_user_OB_USER_PK........ [RUN]
handling poll request
sending response (<Response 9511 bytes [200 OK]>) to 10.0.7.123
10:45:45 | 133 of 157 PASS not_null_rox_onboarding_user_OB_USER_PK.............. [PASS in 1.15s]
10:45:45 | 134 of 157 START test not_null_rox_onboarding_user_USER_ID........... [RUN]
handling poll request
sending response (<Response 8074 bytes [200 OK]>) to 10.0.5.121
10:45:46 | 134 of 157 PASS not_null_rox_onboarding_user_USER_ID................. [PASS in 1.43s]
10:45:46 | 135 of 157 START test not_null_rox_user_APP.......................... [RUN]
handling poll request
sending response (<Response 7676 bytes [200 OK]>) to 10.0.3.75
10:45:47 | 135 of 157 PASS not_null_rox_user_APP................................ [PASS in 1.31s]
10:45:47 | 136 of 157 START test not_null_rox_user_CHANNEL...................... [RUN]
handling poll request
sending response (<Response 7637 bytes [200 OK]>) to 10.0.0.148
10:45:49 | 136 of 157 PASS not_null_rox_user_CHANNEL............................ [PASS in 1.45s]
10:45:49 | 137 of 157 START test not_null_rox_user_DATE_CREATED................. [RUN]
handling poll request
sending response (<Response 8957 bytes [200 OK]>) to 10.0.18.94
10:45:50 | 137 of 157 PASS not_null_rox_user_DATE_CREATED....................... [PASS in 1.21s]
10:45:50 | 138 of 157 START test not_null_rox_user_DATE_UPDATED................. [RUN]
handling poll request
sending response (<Response 7838 bytes [200 OK]>) to 10.0.32.128
10:45:51 | 138 of 157 PASS not_null_rox_user_DATE_UPDATED....................... [PASS in 1.32s]
10:45:51 | 139 of 157 START test not_null_rox_user_USER_ID...................... [RUN]
handling poll request
sending response (<Response 8042 bytes [200 OK]>) to 10.0.5.121
10:45:52 | 139 of 157 PASS not_null_rox_user_USER_ID............................ [PASS in 1.21s]
10:45:52 | 140 of 157 START test tests_rox_backend_metagame..................... [RUN]
handling poll request
sending response (<Response 7816 bytes [200 OK]>) to 10.0.32.128
10:45:54 | 140 of 157 PASS tests_rox_backend_metagame........................... [PASS in 1.56s]
10:45:54 | 141 of 157 START test tests_rox_backend_mission...................... [RUN]
handling poll request
sending response (<Response 7205 bytes [200 OK]>) to 10.0.18.94
10:45:56 | 141 of 157 PASS tests_rox_backend_mission............................ [PASS in 1.53s]
10:45:56 | 142 of 157 START test tests_rox_backend_user_mission................. [RUN]
handling poll request
sending response (<Response 8260 bytes [200 OK]>) to 10.0.7.123
10:45:57 | 142 of 157 PASS tests_rox_backend_user_mission....................... [PASS in 1.41s]
10:45:57 | 143 of 157 START test unique_program_PROGRAM_VERSION_MISSION_SK...... [RUN]
10:45:58 | 143 of 157 PASS unique_program_PROGRAM_VERSION_MISSION_SK............ [PASS in 1.26s]
10:45:58 | 144 of 157 START test unique_program_SOURCE_DYNAMO_PROGRAM_MISSION_ID [RUN]
handling poll request
sending response (<Response 14790 bytes [200 OK]>) to 10.0.29.185
10:46:00 | 144 of 157 PASS unique_program_SOURCE_DYNAMO_PROGRAM_MISSION_ID...... [PASS in 1.48s]
10:46:00 | 145 of 157 START test unique_program_user_mission_SOURCE_DYNAMO_USER_MISSION_ID [RUN]
handling poll request
sending response (<Response 8762 bytes [200 OK]>) to 10.0.4.19
10:46:01 | 145 of 157 PASS unique_program_user_mission_SOURCE_DYNAMO_USER_MISSION_ID [PASS in 1.23s]
10:46:01 | 146 of 157 START test unique_rox_audience_user_AU_PK................. [RUN]
10:46:02 | 146 of 157 PASS unique_rox_audience_user_AU_PK....................... [PASS in 1.19s]
10:46:02 | 147 of 157 START test unique_rox_audience_visitor_AV_PK.............. [RUN]
handling poll request
sending response (<Response 16132 bytes [200 OK]>) to 10.0.41.240
10:46:03 | 147 of 157 PASS unique_rox_audience_visitor_AV_PK.................... [PASS in 1.18s]
10:46:03 | 148 of 157 START test unique_rox_backend_metagame_IDENTIFIER......... [RUN]
handling poll request
sending response (<Response 9687 bytes [200 OK]>) to 10.0.41.240
10:46:05 | 148 of 157 PASS unique_rox_backend_metagame_IDENTIFIER............... [PASS in 1.36s]
10:46:05 | 149 of 157 START test unique_rox_backend_mission_IDENTIFIER.......... [RUN]
10:46:06 | 149 of 157 PASS unique_rox_backend_mission_IDENTIFIER................ [PASS in 1.24s]
10:46:06 | 150 of 157 START test unique_rox_backend_user_mission_IDENTIFIER..... [RUN]
handling poll request
sending response (<Response 14642 bytes [200 OK]>) to 10.0.32.128
10:46:07 | 150 of 157 PASS unique_rox_backend_user_mission_IDENTIFIER........... [PASS in 1.18s]
10:46:07 | 151 of 157 START test unique_rox_device_DEVICE_UUID.................. [RUN]
handling poll request
sending response (<Response 10782 bytes [200 OK]>) to 10.0.47.69
10:46:09 | 151 of 157 PASS unique_rox_device_DEVICE_UUID........................ [PASS in 1.43s]
10:46:09 | 152 of 157 START test unique_rox_experiences_ab_EXP_PK............... [RUN]
10:46:10 | 152 of 157 PASS unique_rox_experiences_ab_EXP_PK..................... [PASS in 1.68s]
10:46:10 | 153 of 157 START test unique_rox_onboarding_OB_PK.................... [RUN]
handling poll request
sending response (<Response 12970 bytes [200 OK]>) to 10.0.15.46
10:46:12 | 153 of 157 PASS unique_rox_onboarding_OB_PK.......................... [PASS in 1.44s]
10:46:12 | 154 of 157 START test unique_rox_onboarding_ab_OB_AB_PK.............. [RUN]
handling poll request
sending response (<Response 7971 bytes [200 OK]>) to 10.0.41.240
10:46:13 | 154 of 157 PASS unique_rox_onboarding_ab_OB_AB_PK.................... [PASS in 1.47s]
10:46:13 | 155 of 157 START test unique_rox_onboarding_prereg_OB_PREREG_PK...... [RUN]
handling poll request
sending response (<Response 11359 bytes [200 OK]>) to 10.0.22.116
10:46:14 | 155 of 157 PASS unique_rox_onboarding_prereg_OB_PREREG_PK............ [PASS in 1.31s]
10:46:14 | 156 of 157 START test unique_rox_onboarding_user_OB_USER_PK.......... [RUN]
handling poll request
sending response (<Response 8223 bytes [200 OK]>) to 10.0.4.19
10:46:16 | 156 of 157 PASS unique_rox_onboarding_user_OB_USER_PK................ [PASS in 1.44s]
10:46:16 | 157 of 157 START test unique_rox_user_USER_ID........................ [RUN]
handling poll request
sending response (<Response 7774 bytes [200 OK]>) to 10.0.15.121
10:46:17 | 157 of 157 FAIL 37 unique_rox_user_USER_ID........................... [FAIL 37 in 1.31s]
10:46:17 | 
10:46:17 | Finished running 157 tests in 220.21s.

Completed with 6 errors and 0 warnings:

Database Error in test not_null_campaign_APPLICATIONID (models/tls/schema.yml)
  002003 (02000): SQL compilation error:
  Schema 'ROX_DEV.DBT_MSIX_CRM' does not exist or not authorized.
  compiled SQL at target/compiled/rox_datamart/models/tls/schema.yml/schema_test/not_null_campaign_APPLICATIONID.sql

Database Error in test not_null_campaign_CAMPAIGNSK (models/tls/schema.yml)
  002003 (02000): SQL compilation error:
  Schema 'ROX_DEV.DBT_MSIX_CRM' does not exist or not authorized.
  compiled SQL at target/compiled/rox_datamart/models/tls/schema.yml/schema_test/not_null_campaign_CAMPAIGNSK.sql

Database Error in test not_null_campaign_CAMPAIGNSTATUSSK (models/tls/schema.yml)
  002003 (02000): SQL compilation error:
  Schema 'ROX_DEV.DBT_MSIX_CRM' does not exist or not authorized.
  compiled SQL at target/compiled/rox_datamart/models/tls/schema.yml/schema_test/not_null_campaign_CAMPAIGNSTATUSSK.sql

Database Error in test not_null_campaign_CAMPAIGNTYPESK (models/tls/schema.yml)
  002003 (02000): SQL compilation error:
  Schema 'ROX_DEV.DBT_MSIX_CRM' does not exist or not authorized.
  compiled SQL at target/compiled/rox_datamart/models/tls/schema.yml/schema_test/not_null_campaign_CAMPAIGNTYPESK.sql

Database Error in test not_null_campaign_CREATIONDATETIME (models/tls/schema.yml)
  002003 (02000): SQL compilation error:
  Schema 'ROX_DEV.DBT_MSIX_CRM' does not exist or not authorized.
  compiled SQL at target/compiled/rox_datamart/models/tls/schema.yml/schema_test/not_null_campaign_CREATIONDATETIME.sql

Failure in test unique_rox_user_USER_ID (models/marts/product/schema.yml)
  Got 37 results, expected 0.

  compiled SQL at target/compiled/rox_datamart/models/marts/product/schema.yml/schema_test/unique_rox_user_USER_ID.sql

Done. PASS=151 WARN=0 ERROR=6 SKIP=0 TOTAL=157
handling poll request
sending response (<Response 409874 bytes [200 OK]>) to 10.0.3.75
handling status request
sending response (<Response 39941 bytes [200 OK]>) to 10.0.22.116
handling status request
sending response (<Response 39941 bytes [200 OK]>) to 10.0.3.75
handling status request
sending response (<Response 39941 bytes [200 OK]>) to 10.0.4.19
handling cli_args request
sending response (<Response 190 bytes [200 OK]>) to 10.0.22.116
handling status request
sending response (<Response 39941 bytes [200 OK]>) to 10.0.18.94
handling status request
sending response (<Response 39941 bytes [200 OK]>) to 10.0.44.55
handling status request
sending response (<Response 39941 bytes [200 OK]>) to 10.0.0.148
handling cli_args request
sending response (<Response 190 bytes [200 OK]>) to 10.0.15.46
handling status request
sending response (<Response 39941 bytes [200 OK]>) to 10.0.41.240
Runtime Error
  at path ['sources']: [{'name': 'source', 'tables': [{'name': 'rox_events'}]}, {'name': 'eventbus', 'database': 'core', 'tables': [{'name': 'events'}]}, {'name': 'dwh', 'database': 'bi', 'tables': [{'name': 'customer'}, {'name': 'customer_security_flag'}]}] is not of type 'object'

Error encountered in /usr/src/develop/user-16695/environment-17120/repository-13929/dbt_project.yml

Save the file again. Now the error message is : 

Running with dbt=0.18.1
Encountered an error while reading the project:
  ERROR: Runtime Error
  at path ['sources']: [{'name': 'source', 'tables': [{'name': 'rox_events'}]}, {'name': 'eventbus', 'database': 'core', 'tables': [{'name': 'events'}]}, {'name': 'dwh', 'database': 'bi', 'tables': [{'name': 'customer'}, {'name': 'customer_security_flag'}]}] is not of type 'object'

Error encountered in /usr/src/develop/user-16695/environment-17120/repository-13929/dbt_project.yml
Runtime Error
  Could not run dbt

Expected behavior

I expect not to have any compilation error as the yml structure looks fine.

Screenshots and log output

image

System information

Which database are you using dbt with?

The output of dbt --version: I guess 0.18.1 as it is stated in the compilation error message, but dbt --version command fails so I am not sure : image

The operating system you're using: Windows 10

The output of python --version: Python 3.8.6

Additional context

Here is the whole dbt_project.yml file : 

name: 'rox_datamart'
version: '1.0.0'
config-version: 2

profile: 'dev'

source-paths: ["models"]
analysis-paths: ["analysis"]
test-paths: ["tests"]
data-paths: ["data"]
macro-paths: ["macros"]
snapshot-paths: ["snapshots"]
target-path: "target"
clean-targets:
    - "target"
    - "dbt_modules"

vars:
  # These variables are added here to make sure that 'dbt docs generate' doesn't fail
  # When running dbt they have to be passed as parameters : 'dbt run --vars '{MinDate: 2021-01-01, MaxDate: 2021-01-02}''
  MinDate: '2021-01-01'
  MaxDate: '2021-01-02'

sources:
  - name: source
    tables:
      - name: rox_events
  - name: eventbus
    database: core
    tables:
      - name: events
  - name: dwh
    database: bi
    tables:
      - name: customer
      - name: customer_security_flag

models:
  rox_datamart:
      staging:
          schema: STAGING
      tls:
          schema: CRM

seeds:
    rox_datamart:
        schema: STAGING
jtcohen6 commented 3 years ago

Hey @marinsix, sorry for the confusing error here. What you're trying to do is declare sources, in the form of defining properties under a sources block in a models/*.yml file.

What your current code is actually doing, while it's in the file dbt_project.yml instead, is attempting to configure existing sources—but those sources don't yet exist (you need to declare them first), and sources don't support those properties as configs.

The resolution is straightforward: Move your sources block out from dbt_project.yml and into a .yml file (with any name) under the models/ directory.

The distinction between properties and configs exists for technical reasons. We know it's confusing and have planned work to reconcile them as best as we can (#2401).