Ok,

a small update on this problem.
I have set up a local tool shed with in it a repository that holds 2 tool definitions of the same tool but with different verision nbrs


<tool id="NicybDummyTool" name="Nicyb Dummy Tool" version="1.0">
  <description>Dummy Tool</description>
  <command interpreter="python">
    dummyTool.py $inputFile $operand $outputFile
  </command>

  <inputs>
<param name="inputFile" type="data" format="txt" label="Input txt file" />
    <param name="operand" type="text" size="2" label="Operand"/>
  </inputs>

  <outputs>
    <!--callpeaks output-->
    <data name="outputFile" format="txt" label="${tool.name}: output" />
  </outputs>

  <tests>
    <test>
      <param name="inputFile" value="dummyTool_input.txt" ftype="txt"/>
      <param name="operand" value="2"/>
      <output name="outputFile" file="dummyTool_output.txt"/>
    </test>
  </tests>

and:

<tool id="NicybDummyTool" name="Nicyb Dummy Tool" version="2.0">
  <description>Dummy Tool v2</description>
  <command interpreter="python">
    dummyTool_v2.py $inputFile $operand $outputFile
  </command>

  <inputs>
<param name="inputFile" type="data" format="txt" label="Input txt file" />
    <param name="operand" type="text" size="2" label="Operand"/>
  </inputs>

  <outputs>
    <!--callpeaks output-->
    <data name="outputFile" format="txt" label="${tool.name}: output" />
  </outputs>

  <tests>
    <test>
      <param name="inputFile" value="dummyTool_input.txt" ftype="txt"/>
      <param name="operand" value="2"/>
      <output name="outputFile" file="dummyTool_output_v2.txt"/>
    </test>
  </tests>

</tool>

</tool>

I am successful in installing these tools in Galaxy using out own toolshed.
I get the following lines in shed_tool_conf.xml

<section id="nicyb_test_3" name="nicyb test 3" version="">
<tool file="galaxy.psb.ugent.be/repos/nicyb/testbla2/4c7117d7f90d/testbla2/dummyTool_wrapper.xml" guid="galaxy.psb.ugent.be:3333/toolshed/repos/nicyb/testbla2/NicybDummyTool/1.0">
<tool_shed>galaxy.psb.ugent.be:3333/toolshed</tool_shed>
        <repository_name>testbla2</repository_name>
        <repository_owner>nicyb</repository_owner>
<installed_changeset_revision>4c7117d7f90d</installed_changeset_revision>
<id>galaxy.psb.ugent.be:3333/toolshed/repos/nicyb/testbla2/NicybDummyTool/1.0</id>
        <version>1.0</version>
    </tool>
<tool file="galaxy.psb.ugent.be/repos/nicyb/testbla2/4c7117d7f90d/testbla2/dummyTool_wrapper_v2.xml" guid="galaxy.psb.ugent.be:3333/toolshed/repos/nicyb/testbla2/NicybDummyTool/2.0">
<tool_shed>galaxy.psb.ugent.be:3333/toolshed</tool_shed>
        <repository_name>testbla2</repository_name>
        <repository_owner>nicyb</repository_owner>
<installed_changeset_revision>4c7117d7f90d</installed_changeset_revision>
<id>galaxy.psb.ugent.be:3333/toolshed/repos/nicyb/testbla2/NicybDummyTool/2.0</id>
        <version>2.0</version>
    </tool>
</section>


When I look in the tool panel I can see both tools under section nicyb test3. Upon selecting one I get Nicyb Dummy Tool and then a drop down with "version 1.0" and "version 2.0"
However, when I change the version nbrs I get the following error:

 Module MySQLdb.connections:36 in defaulterrorhandler         view
OperationalError: (OperationalError) (1241, 'Operand should contain 1 column(s)') 'INSERT INTO event (create_time, update_time, history_id, user_id, message, session_id, tool_id) VALUES (%s, %s, %s, %s, %s, %s, %s)' (datetime.datetime(2014, 4, 8, 14, 34, 48, 567645), datetime.datetime(2014, 4, 8, 14, 34, 48, 567654), 1L, 1L, "Tool params: {'operand': u'', 'tool_state': u'800255db313334303737356537316139353463626339613333356235633261356166623236313166623137643a3762323236663730363537323631366536343232336132303232356332323465366636653635356332323232326332303232356635663730363136373635356635663232336132303330326332303232356635663732363537323735366535663732363536643631373035663661366636323566363936343566356632323361323036653735366336633263323032323639366537303735373434363639366336353232336132303232333233323232376471002e', 'refresh': u'refresh', 'inputFile': u'22'}", 16L, [u'galaxy.psb.ugent.be:3333/toolshed/repos/nicyb/testbla2/NicybDummyTool/2.0', u'galaxy.psb.ugent.be:3333/toolshed/repos/nicyb/testbla2/NicybDummyTool/1.0'])

Is there anyone with similar experiences or an explanation for this ?

Kind regards,

Nicolas

On 04/02/2014 06:00 PM, galaxy-dev-requ...@lists.bx.psu.edu wrote:
Subject:
[galaxy-dev] Problem with executing newly installed tools (via admin)
From:
"Nicolas Cybulski" <ni...@psb.vib-ugent.be>
Date:
04/02/2014 10:38 AM

To:
galaxy-dev@lists.bx.psu.edu


Hi,

I have installed the Picard tools using the Tool-shed functionality in the admin tools.
The tools and requisites have been correctly installed and run correctly.
The insert statement to the event table fails however. I get the following error on screen:

|OperationalError: (OperationalError) (1241, 'Operand should contain 1 column(s)') 'INSERT INTO event (create_time, update_time, history_id, user_id, message, session_id, tool_id) VALUES (%s, %s, %s, %s, %s, %s, %s)' (datetime.datetime(2014, 4, 2, 9, 32, 47, 823142), datetime.datetime(2014, 4, 2, 9, 32, 47, 823170), 35L, 4L, "Tool params: {'histWidth': u'0', 'deviations': u'10.0', 'malevel': u'ALL_READS', 'input_file': u'5266', 'out_prefix': u'Insertion size metrics', 'refresh': u'refresh', 'minPct': u'0.05', 'tool_state': u'800254cf010000316164663833323133363237333739303833323639353065346362343762393730383966363664313a37623232363836393733373435373639363437343638323233613230323235633232333035633232323232633230323236343635373636393631373436393666366537333232336132303232356332323331333032653330356332323232326332303232363936653730373537343566363636393663363532323361323032323335333233363336323232633230323235663566373036313637363535663566323233613230333032633230323235663566373236353732373536653566373236353664363137303566366136663632356636393634356635663232336132303665373536633663326332303232366436313663363537363635366332323361323032323563323234313463346335663532343534313434353335633232323232633230323236663735373435663730373236353636363937383232336132303232356332323439366537333635373237343639366636653230373336393761363532303664363537343", 1468L, [u'toolshed.g2.bx.psu.edu/repos/devteam/picard/PicardInsertSize/1.56.0', u'toolshed.g2.bx.psu.edu/repos/devteam/picard/PicardInsertSize/1.56.0'])

|The problem seems to be a duplicate entry of the tool_id

|[u'toolshed.g2.bx.psu.edu/repos/devteam/picard/PicardInsertSize/1.56.0', u'toolshed.g2.bx.psu.edu/repos/devteam/picard/PicardInsertSize/1.56.0']

|In the shed_tool_conf.xml the tools are generated as follows

<tool file="toolshed.g2.bx.psu.edu/repos/devteam/picard/ab1f60c26526/picard/rgPicardInsertSize.xml"guid="toolshed.g2.bx.psu.edu/repos/devteam/picard/PicardInsertSize/1.56.0">

If I change this guid to something less complicated like

<tool file="toolshed.g2.bx.psu.edu/repos/devteam/picard/ab1f60c26526/picard/rgPicardInsertSize.xml" guid="testPicard">

and restart galaxy it works ...
for all tools (so not only the one that I've changed).

Does anyone have an idea as to why this is ?

kind regards,

Nicolas

___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
  http://lists.bx.psu.edu/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/

Reply via email to