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-request@lists.bx.psu.edu wrote:
Subject: [galaxy-dev] Problem with executing newly installed tools (via admin) From: "Nicolas Cybulski" nicyb@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