view · edit · sidebar · attach · print · history

20130401-investigate-unexpected-objects-in-database

<< | Index | >>


Summary

  • Debug unexpected objects in database.(It may be related to PI.)

Commits

Index


Debug unexpected Objects

Tried same Data with production on local machine.
But could not get same error.

thinpower oddb.org # RUBY_OPT="" bin/admin 
ch.oddb> patinfos.values.select{|pi| !pi.descriptions.is_a?(ODDB::SimpleLanguage::Descriptions) }.length
-> 0

Check after import_daily, again.


Debug Swissreg Patent Updater

ch.oddb> Updater.new(self).update_swissreg_news
Checked    153 Substances for connected Patents
Found        0 Patents
of which     0 had a Swissmedic-Number.
             0 Registrations were successfully updated;
for these    0 Swissmedic-Numbers no Registration was found:

Swissregd got many redirects.
swissreg server has something changes.

redirecting to: /srclient/faces/jsp/start.jsp
redirecting to: /srclient/faces/jsp/spc/sr1.jsp
redirecting to: /srclient/faces/jsp/start.jsp
redirecting to: /srclient/faces/jsp/spc/sr1.jsp
redirecting to: /srclient/faces/jsp/start.jsp
...
...

Debug swissregd.

[2] 1.9.3-p194(#<ODDB::Swissreg::Session>)> response.to_hash
=> {"location"=>["https://www.swissreg.chhttps://www.swissreg.ch/srclient/"],  # <= strange
 "server"=>["BigIP"],
 "connection"=>["close"],
 "content-length"=>["0"]}
...

swissregd uses Net::HTTPSession#get.

This method never raises an exception.

swissregd could not handle this strange redirects.

  • unexpected empty content-length with 302.
  • certificate is changed.
Plugin: ODDB::SwissregPlugin
Error: OpenSSL::SSL::SSLError
Message: SSL_connect returned=1 errno=0 state=SSLv2/v3 read server hello A: unknown protocol
Backtrace:

And Form is also changed. All Requests are POST ;(
Post request does not respond any parameters.

autoScroll=0%2C0&id_swissreg_SUBMIT=1&id_swissreg%3A_idcl=id_swissreg_sub_nav_ipiNavigation_item0&id_swissreg%3A_link_hidden_=&javax.faces.ViewState=rO0ABXVyABNbTGphdmEubGFuZy5PYmplY3Q7kM5YnxBzKWwCAAB4cAAAAAN0AAE1cHQADi9qc3Avc3RhcnQuanNw

Many broken Objects are production.
Broken Registration data.

@400000005159dc692e2652cc NoMethodError
@400000005159dc692e2652cc undefined method `force_encoding' for nil:NilClass
@400000005159dc692e2656b4 /var/www/oddb.org/src/model/indication.rb:56:in `description'
@400000005159dc692e2656b4 /var/www/oddb.org/src/util/language.rb:50:in `method_missing'
@400000005159dc692e2656b4 /var/www/oddb.org/src/view/additional_information.rb:450:in `twitter_share'
@400000005159dc692e275c6c /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:68:in `create'
@400000005159dc692e276054 /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:286:in `compose_component'
@400000005159dc692e27643c error in SBSM::Session#to_html: /de/mobile/fachinfo/reg/38096/chapter/effects/currency/CHF
@400000005159dc692e27643c NoMethodError
@400000005159dc692e27643c undefined method `name' for nil:NilClass
@400000005159dc692e276ff4 /var/www/oddb.org/src/view/drugs/fachinfo.rb:234:in `fachinfo_name'
@400000005159dc692e2773dc /var/www/oddb.org/src/view/drugs/fachinfo.rb:329:in `fachinfo_name'
@400000005159dc692e2773dc /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:68:in `create'
@400000005159dc692e2773dc /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:286:in `compose_component'
@400000005159dc692e278b4c /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:211:in `block in compose'
@400000005159dc582f7e39dc error in SBSM::Session#http_headers: /de/gcc/patinfo/reg/39813/seq/01/currency/EUR
@400000005159dc582f7e41ac NoMethodError
@400000005159dc582f7e4594 undefined method `name' for nil:NilClass
@400000005159dc582f7e4594 /var/www/oddb.org/src/view/drugs/patinfo.rb:188:in `patinfo_name'
@400000005159dc582f7e4594 /var/www/oddb.org/src/view/drugs/patinfo.rb:227:in `patinfo_name'
@400000005159dc582f7e497c /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:68:in `create'
@400000005159dc582f7e785c /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:286:in `compose_component'
@400000005159dc582f7e7c44 /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:211:in `block in compose'
@400000005159dc582f7e87fc NoMethodError
@400000005159dc582f7e8be4 undefined method `force_encoding' for nil:NilClass
@400000005159dc582f7e8be4 /var/www/oddb.org/src/model/indication.rb:56:in `description'
@400000005159dc582f7e8be4 /var/www/oddb.org/src/util/language.rb:50:in `method_missing'
@400000005159dc582f7e8fcc (eval):2:in `send'
@400000005159dc582f7e979c /var/www/oddb.org/src/view/additional_information.rb:450:in `twitter_share'
@400000005159dc582f7e979c /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:68:in `create'
@400000005159dc582f7eaf0c /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:286:in `compose_component'
@400000005159dc8e399f03c4 error in SBSM::Session#http_headers: /de/mobile/fachinfo/reg/38096/chapter/effects/currency/CHF
@400000005159dc8e399f0b94 NoMethodError
@400000005159dc8e399f0b94 undefined method `name' for nil:NilClass
@400000005159dc8e399f0f7c /var/www/oddb.org/src/view/drugs/fachinfo.rb:234:in `fachinfo_name'
@400000005159dc8e399f0f7c /var/www/oddb.org/src/view/drugs/fachinfo.rb:329:in `fachinfo_name'
@400000005159dc8e399f1364 /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:68:in `create'
@400000005159dc8e399f6184 /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:286:in `compose_component'
@400000005159dc8e399f6184 /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:211:in `block in compose'
@400000005159dc8e399f656c error in SBSM::Session#to_html: /de/gcc/patinfo/reg/38034/seq/02
@400000005159dc8e399f656c NoMethodError
@400000005159dc8e399f6954 undefined method `name' for nil:NilClass
@400000005159dc8e399f7124 /var/www/oddb.org/src/view/drugs/patinfo.rb:188:in `patinfo_name'
@400000005159dc8e399f7124 /var/www/oddb.org/src/view/drugs/patinfo.rb:227:in `patinfo_name'
@400000005159dc8e399f750c /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:68:in `create'
@400000005159dc8e399f750c /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:286:in `compose_component'
@400000005159dc8e399f8894 /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:211:in `block in compose'
@400000005159dc8e399f8c7c /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:205:in `each'
@400000005159dc8e399f9064 /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:205:in `compose'
@400000005159def8372f191c error in SBSM::Session#to_html: /de/gcc/patinfo/reg/56157/seq/01
@400000005159def8372f1d04 NoMethodError
@400000005159def8372f1d04 undefined method `chapter_names' for nil:NilClass
@400000005159def8372f1d04 /var/www/oddb.org/src/view/drugs/patinfo.rb:98:in `display_names'
@400000005159def8372f20ec /var/www/oddb.org/src/view/drugs/patinfo.rb:75:in `init'
@400000005159def8372f28bc /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/component.rb:139:in `initialize'
@400000005159def8372f2ca4 /var/www/oddb.org/src/view/drugs/patinfo.rb:210:in `new'
@400000005159def8372f2ca4 /var/www/oddb.org/src/view/drugs/patinfo.rb:210:in `chapter_chooser'
@400000005159def8372f308c /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:68:in `create'
@400000005159def8372f4be4 /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:286:in `compose_component'
@400000005159dfa33b2741d4 error in SBSM::Session#http_headers: /fr/mobile/patinfo/reg/48523/seq/01
@400000005159dfa33b2749a4 NoMethodError
@400000005159dfa33b274d8c undefined method `each' for nil:NilClass
@400000005159dfa33b274d8c /var/www/oddb.org/src/view/drugs/patinfo.rb:80:in `init'
@400000005159dfa33b275174 /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/component.rb:139:in `initialize'
@400000005159dfa33b275174 /var/www/oddb.org/src/view/drugs/patinfo.rb:210:in `new'
@400000005159dfa33b27555c /var/www/oddb.org/src/view/drugs/patinfo.rb:210:in `chapter_chooser'
@400000005159dfa33b278824 /usr/local/lib/ruby/gems/1.9.1/gems/htmlgrid-1.0.6/lib/htmlgrid/composite.rb:68:in `create'
commit

Missing Connections.

ch.oddb> registrations.values.select{|reg| !reg.fachinfo.nil? }.length
-> 6183
view · edit · sidebar · attach · print · history
Page last modified on April 01, 2013, at 09:46 PM