view · edit · sidebar · attach · print · history


<< 20160719-fix-import-error-sandoz-xmlconv-ch-and-remove-flavor-bbmb-ch | Index | 20160715-debug-encoding-issuen-sandoz-bbmb-ch >>


  • Setuped, in local.
  • Fixed search filter on
  • Updated sbsm version on production (
  • Removed `Thread.exclusize` (deprecated) and then replaced Mutex
  • Implemented (missing) sorting for Aktiviert and Last Login columns (
  • Debugging importer error on

Commits / Patches / Pull Requests, Scripts


Fix encoding issue for search filter on

Setup applications

Before fixing issues, I've setup following bbmb applications in my local.


Search filter

On production, In search filter, we've got followig error.

@4000000057888f590e569dbc error in SBSM::Session#http_headers: /de
@4000000057888f590e56a1a4 ArgumentError
@4000000057888f590e56a1a4 invalid byte sequence in UTF-8
`block (3 levels) in init'

I think this Invalid byte sequence comes from sbsm-1.2.3's input (installed on Ruby 1.8.6 for mod_ruby). And some values are empty. Then I've added next 2 changes.

Remove thread exclusive

  • Change sbsm to sbsm-1.2.8 (newest) in apache config file (mod_ruby is compiled against 1.8.6, but use sbsm installed for application in Ruby 2.3.1)
  • Skip empty string
  • Avoid error by enexpected input

Commit: Fix search filter

Remove thread exclusive

I've got deprecated warning in test or log.
So I've updated Thread usage with Mutex.

% bundle exec test/suite.rb                                                     
bash -c 'bundle exec /path/to/bbmb/test/model/test_customer.rb --seed 62766  2>&1 | \
  tee test_customer.log; ( exit ${PIPESTATUS[0]} )'
Run options: --seed 62766                                                          

# Running:                                                                         

....Thread.exclusive is deprecated, use Mutex                                      
/path/to/bbmb/lib/bbmb/model/customer.rb:75:in `inject_order'                   
/path/to/bbmb/test/model/test_customer.rb:66:in `test_inject_order'             
/path/to/bbmb/.bundle/gems/ruby/2.3.0/gems/minitest-5.9.0/lib/minitest/test.rb:107:in `block (3 levels) in run'
/path/to/bbmb/.bundle/gems/ruby/2.3.0/gems/minitest-5.9.0/lib/minitest/test.rb:204:in `capture_exceptions'
/path/to/bbmb/.bundle/gems/ruby/2.3.0/gems/minitest-5.9.0/lib/minitest/test.rb:104:in `block (2 levels) in run'

* Use Mutex and remove Thread.exclusive

Fix sort order

For some fields, Sort feature does not work.
It seems that thees objects are Boolean and Date.

In log file:
could not sort by valid
could not sort by valid
could not sort by last_login

It seems that this sort fails, because
these columns are result of following methods (with argument
Yus has these methods.

  • user.entity_valid?(
  • last_login(

I made sort feature for this columns. It works.
But, Its are very slow, because by each line, sorting needs query to Yus Server (session). In my local machine it takes 12 - 15 seconds...
Perhaps, By above reason, the sorting for these 2 columns was not implemented.
Hmm, How should I avoid this?

I've used Delegator and cached some value into instance variable, then reduced queries to Yus server.
But, (In the future) It might need cache store (etc).

Commit: Add missing sorting for valid and last_login

Fix executable command permission

In the installation by gem command, these commands are appended x permission automatically.
But I've added this in source code for convenience.

Commit: Fix executable command permission (to 755)

Fix RuntimeError by importer on

If user access to following page, then RuntimeError occurs.

This is already rescued (and reported), but we have to know why this error occurs.

RuntimeError Bestellung OK, Eintrag in BBMB fehlgeschlagen: DRb::DRbConnError druby://localhost:12004 - #

/usr/local/lib/ruby/2.3.0/drb/drb.rb:745:in `rescue in block in open'
/usr/local/lib/ruby/2.3.0/drb/drb.rb:739:in `block in open'
/usr/local/lib/ruby/2.3.0/drb/drb.rb:738:in `each'
/usr/local/lib/ruby/2.3.0/drb/drb.rb:738:in `open'
/usr/local/lib/ruby/2.3.0/drb/drb.rb:1248:in `initialize'
view · edit · sidebar · attach · print · history
Page last modified on July 18, 2016, at 05:37 PM