Parametros inválidos ao deletar

0 respostas
Mariana.Vecci

Olá gente, tenho uma aplicação construida em Ruby on Rails e estou com um problema ao deletar. O seguinte log é gravado com o erro:

ActiveRecord::StatementInvalid (TinyTds::Error: Incorrect syntax near ','.: EXEC                                                                                                  sp_executesql N'      SELECT distinct parent.*, LEN(parent.path) - LEN(REPLACE(                                                                                                 parent.path,''.'','''')) level,
             tc.active,
             IIF(EXISTS(
                SELECT * FROM impasse_test_plan_cases AS tpc WHERE tpc.test_case                                                                                                 _id = parent.id
             ),1,0)
             AS planned
        FROM impasse_nodes AS parent
      JOIN impasse_nodes AS child
        ON parent.path = SUBSTRING(child.path, 1, LEN(parent.path))
      LEFT JOIN impasse_test_cases AS tc
        ON child.id = tc.id
      WHERE parent.path LIKE N''.14582.14292.%''
      ORDER BY level DESC
'):

Este é o método para remover:

def destroy
    params[:node][:id].each do |id|
      node = Impasse::Node.find(id)

      inactive_cases = []
      ActiveRecord::Base.transaction do
        node.all_decendant_cases_with_plan.each do |child|
          if child.planned?
            Impasse::TestCase.update_all({:active => false}, ["id=?", child.id])
            inactive_cases << child
          else
            case child.node_type_id
            when 2                
               if inactive_cases.all? {|ic| ! ic.path.start_with? child.path}
                Impasse::TestSuite.delete(id)
                child.destroy
              end
			when 3
              Impasse::TestCase.delete(child.id)
              child.destroy
			end
          end
        end
      end
    end

    render :json => {:status => true}
  end

Obrigada!!

Criado 15 de julho de 2014
Respostas 0
Participantes 1