some broken specs

gistfile1.txt

Failures:

  1) DataTables date sorting Securitization with Various date value sorts correctly
     Failure/Error: expect(date_values.size).to be > 0
       expected: > 0
            got:   0
     # ./spec/features/data_tables_date_sorting_spec.rb:51:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  2) Elasticsearchable ActiveRecord/Elasticsearch data validation Elasticsearch index sizes match SQL counts
     Failure/Error: expect(ar_s).to eq es_s
       
       expected: "DimProperty: 91391"
            got: "DimProperty: 0"
       
       (compared using ==)
     # ./spec/integrations/elasticsearchable_spec.rb:262:in `(root)'
     # ./spec/integrations/elasticsearchable_spec.rb:243:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  3) Elasticsearchable ActiveRecord/Elasticsearch data validation Securitization's properties are searchable
     Failure/Error: expect(dim_property_search.response.hits.total).to eq ds.dim_properties.size
       
       expected: 31
            got: 119
       
       (compared using ==)
     # ./spec/integrations/elasticsearchable_spec.rb:284:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  4) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName
     Failure/Error: expect(ar_size).to eq(es_size), "Search (#{es_size}) & Query (#{ar_size}) for SecuritizationName: #{shelf} results are different"
       Search (20) & Query (6) for SecuritizationName: BACM results are different
     # ./spec/integrations/elasticsearchable_spec.rb:320:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  5) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on Securitization (partial token)
     Failure/Error: expect(ar_size).to eq(es_size), "Search for SecuritizationName: 'ba', Include0UPB:true record counts do not match [search: #{es_size}, query: #{ar_size}]"
       Search for SecuritizationName: 'ba', Include0UPB:true record counts do not match [search: 46, query: 14]
     # ./spec/integrations/elasticsearchable_spec.rb:342:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  6) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, PropertyTypeMajor
     Failure/Error: expect(ar_size).to be > 0, "SQL query for SecuritizationName: #{dim_securitization_securitization_name}, PropertyTypeMajor: Mobile Home Park, LoanStatus!=Defeased yields no results"
       SQL query for SecuritizationName: BACM 2005-5, PropertyTypeMajor: Mobile Home Park, LoanStatus!=Defeased yields no results
     # ./spec/integrations/elasticsearchable_spec.rb:529:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  7) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, PropertyTypeMinor (partial)
     Failure/Error: expect(search_results[1]['property_count']).to eq(ar_size), "Search for SecuritizationName: #{shelf}, PropertyTypeMinor: medical, Include0UPB:true property counts do not match SQL [es: #{search_results[1]['property_count']}, sql: #{ar_size}]"
       Search for SecuritizationName: BACM, PropertyTypeMinor: medical, Include0UPB:true property counts do not match SQL [es: 13, sql: 11]
     # ./spec/integrations/elasticsearchable_spec.rb:601:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  8) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, State (defeased excluded)
     Failure/Error: expect(ar_dwidNote.size - ar_defeased_dwidNote.size).to eq(search_results[1]['loan_count']), "Search for SecuritizationName: #{shelf}, State: NY, Include0UPB:true loan count (#{search_results[1]['loan_count']}) does not match SQL: [loans: #{ar_dwidNote.size} - defeased: #{ar_defeased_dwidNote.size}]"
       Search for SecuritizationName: BACM, State: NY, Include0UPB:true loan count (140) does not match SQL: [loans: 151 - defeased: 17]
     # ./spec/integrations/elasticsearchable_spec.rb:651:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  9) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, Vintage, NoteName, NoteDateStart, NoteDateEnd, LoanStatus, PropertyTypeMajor, PropertyName, StreetAddress, City, State
     Failure/Error: expect(ar_size).to eq(es_size), "Search for SecuritizationName: #{shelf}, Vintage: 2007, NoteName: avenue, NoteDateStart: 01/01/2007, NoteDateEnd: 12/31/2007, LoanStatus: perform, PropertyTypeMajor: office, PropertyName: avenue, StreetAddress: avenue, City: new york, State: ny, Include0UPB:true counts do not match SQL: [es: #{es_size}, sql: #{ar_size}]"
       Search for SecuritizationName: BACM, Vintage: 2007, NoteName: avenue, NoteDateStart: 01/01/2007, NoteDateEnd: 12/31/2007, LoanStatus: perform, PropertyTypeMajor: office, PropertyName: avenue, StreetAddress: avenue, City: new york, State: ny, Include0UPB:true counts do not match SQL: [es: 3, sql: 0]
     # ./spec/integrations/elasticsearchable_spec.rb:732:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  10) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, Vintage, NoteName, NoteDate, LoanStatus, PropertyTypeMajor, City, State
     Failure/Error: expect(ar_size).to eq(es_size), "Search for SecuritizationName: #{shelf}, Vintage: #{note_date}, NoteName: building, NoteDate: #{note_date}, LoanStatus: Perform(w), PropertyTypeMajor: office, City: new york, State: ny, Include0UPB:true counts do not match SQL: [es: #{es_size}, sql: #{ar_size}]"
       Search for SecuritizationName: BACM, Vintage: 2005, NoteName: building, NoteDate: 2005, LoanStatus: Perform(w), PropertyTypeMajor: office, City: new york, State: ny, Include0UPB:true counts do not match SQL: [es: 3, sql: 0]
     # ./spec/integrations/elasticsearchable_spec.rb:782:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  11) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, NoteName, State, and TennantName
     Failure/Error: expect(ar_results.size).to be > 0, "SQL query for SecuritizationName: #{shelf}, LoanStatus!=Defeased, State: #{property_state}, TennantName: #{tenant_name}, NoteName: #{note_name} yields no results"
       SQL query for SecuritizationName: BACM, LoanStatus!=Defeased, State: TN, TennantName: walgreens, NoteName: walgreens yields no results
     # ./spec/integrations/elasticsearchable_spec.rb:806:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  12) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on SecuritizationName, State, and TennantName
     Failure/Error: expect(ar_size).to be > 0, "SQL query for SecuritizationName: #{shelf}, LoanStatus!=Defeased, TennantName: #{tenant_name}, State: #{property_state} yields no results"
       SQL query for SecuritizationName: BACM, LoanStatus!=Defeased, TennantName: walgreens, State: TN yields no results
     # ./spec/integrations/elasticsearchable_spec.rb:859:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  13) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on ZipCode
     Failure/Error: expect(ar_results.count).to eq(search_results[1]['property_count']), "Search for ZipCode: 95687, Include0UPB:true property counts do not match SQL [es: #{search_results[1]['property_count']}, sql: #{ar_results.count}]"
       Search for ZipCode: 95687, Include0UPB:true property counts do not match SQL [es: 394, sql: 17]
     # ./spec/integrations/elasticsearchable_spec.rb:968:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  14) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on Securitization, StreetAddress
     Failure/Error: expect(ar_results.count).to eq(search_results[1]['property_count']), "Search for SecuritizationName: BACM, StreetAddress: pacific, Include0UPB:true property counts do not match SQL [es: #{search_results[1]['property_count']}, sql: #{ar_results.count}]"
       Search for SecuritizationName: BACM, StreetAddress: pacific, Include0UPB:true property counts do not match SQL [es: 16, sql: 8]
     # ./spec/integrations/elasticsearchable_spec.rb:1006:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  15) Elasticsearchable ActiveRecord/Elasticsearch data validation Search PropertyName
     Failure/Error: expect(ar_results.count).to eq(search_results[1]['property_count']), "Search for PropertyName: kindercare, Include0UPB:true property counts do not match SQL [es: #{search_results[1]['property_count']}, sql: #{ar_results.count}]"
       Search for PropertyName: kindercare, Include0UPB:true property counts do not match SQL [es: 2948, sql: 594]
     # ./spec/integrations/elasticsearchable_spec.rb:1042:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  16) Elasticsearchable ActiveRecord/Elasticsearch data validation Search on TennantName
     Failure/Error: expect(es_search_results[1]['loan_count']).to eq(ar_loan_count), "Search for TennantName: #{tenant_name}, Include0UPB:true loan counts do not match SQL [es: #{es_search_results[1]['loan_count']}, sql: #{ar_loan_count}]"
       Search for TennantName: walgreens, Include0UPB:true loan counts do not match SQL [es: 976, sql: 824]
     # ./spec/integrations/elasticsearchable_spec.rb:1070:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  17) CashFlow#get_prior_op_statements returns cash flow line items with prior op statement descriptions
     Failure/Error: expect(cash_flow.get_prior_op_statements(cash_flows).size).to eq(215)
       
       expected: 215
            got: 212
       
       (compared using ==)
     # ./spec/services/cash_flow_spec.rb:398:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  18) CashFlow#build_historical_occupancy_object returns an object with historical occupancy info
     Failure/Error: expect(cash_flow.build_historical_occupancy_object(mocked_his_occupancy_keys, mocked_year_labels).to_json).to eq(mocked_hist_header_obj.to_json)
       
       expected: "{\"occupancy\":{\"type\":\"line\",\"data\":{\"2011 Annual\":null,\"2011 Annual $/Unit\":\"-\",\"2012 Annual\":\"0.81\",\"2012 Annual $/Unit\":\"-\",\"2013 Annual\":\"0.89\",\"2013 Annual $/Unit\":\"-\",\"01/01/2014 YTD\":\"0.88\",\"01/01/2014 YTD $/Unit\":\"-\"}}}"
            got: "{\"occupancy\":{\"type\":\"line\",\"data\":{\"2011 Annual\":null,\"2011 Annual $/Unit\":\"-\",\"2012 Annual\":null,\"2012 Annual $/Unit\":\"-\",\"2013 Annual\":null,\"2013 Annual $/Unit\":\"-\",\"01/01/2014 YTD\":null,\"01/01/2014 YTD $/Unit\":\"-\"}}}"
       
       (compared using ==)
     # ./spec/services/cash_flow_spec.rb:684:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  19) CashFlow#build_historical_occupancy_object handles nil/null values for historical header year labels
     Failure/Error: expect(cash_flow.build_historical_occupancy_object(mocked_his_occupancy_keys, mocked_nil_year_labels).to_json).to eq(nil_mocked_hist_header_obj.to_json)
       
       expected: "{\"occupancy\":{\"type\":\"line\",\"data\":{\"\":\"0.89\",\" $/Unit\":\"-\",\"2012 Annual\":\"0.81\",\"2012 Annual $/Unit\":\"-\",\"01/01/2014 YTD\":\"0.88\",\"01/01/2014 YTD $/Unit\":\"-\"}}}"
            got: "{\"occupancy\":{\"type\":\"line\",\"data\":{\"\":null,\" $/Unit\":\"-\",\"2012 Annual\":null,\"2012 Annual $/Unit\":\"-\",\"01/01/2014 YTD\":null,\"01/01/2014 YTD $/Unit\":\"-\"}}}"
       
       (compared using ==)
     # ./spec/services/cash_flow_spec.rb:688:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  20) Valuation on valuation_details for specific loan with dwidNote = 21903 has most recent appraised value
     Failure/Error: expect(valuation_details['most_recent_appraised_value']).to be > 0
     NoMethodError:
       undefined method `>' for nil:NilClass
     # ./spec/services/valuation_spec.rb:102:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

  21) Valuation on valuation_details for specific loan with dwidNote = 21903 has most recent appraised date
     Failure/Error: expect(valuation_details['most_recent_appraised_date'].to_i).to eq(1277078400)
       
       expected: 1277078400
            got: 0
       
       (compared using ==)
     # ./spec/services/valuation_spec.rb:114:in `(root)'
     # ./spec/rails_helper.rb:67:in `(root)'

Finished in 10 minutes 29 seconds (files took 48.55 seconds to load)
1049 examples, 21 failures, 5 pending