Hi Laura,

I suspect that the difference in behavior may be related to using Postgres on your local machine instead of SQLServer on your production server.

LabKey SQL uses || as the standard string concatenation operator. https://www.labkey.org/wiki/home/Documentation/page.view?name=labkeysql

Using + happens to work on SQL Server as well. On Postgres, I was able to fix the error message by changing this line:

tci.TransitionId.FragmentType + CAST(tci.TransitionId.FragmentOrdinal AS VARCHAR) AS FragmentIon,

to:

tci.TransitionId.FragmentType || CAST(tci.TransitionId.FragmentOrdinal AS VARCHAR) AS FragmentIon,

Please give it a try and see if it clears up the error on your machine too.

Thanks,
Josh