protected function flushTmpSosaTable($force = false) {
        if( count($this->tmp_sosa_table)> 0 && 
            ($force ||  count($this->tmp_sosa_table) >= self::TMP_SOSA_TABLE_LIMIT)){            
                $this->sosa_provider->insertOrUpdate($this->tmp_sosa_table);
                $this->tmp_sosa_table = array();
        }
    }