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