Microsoft SQL Server 2005 Linked Server to ABRA - Bookmark error

I've found that on multiple threads as well, but I have other SQL jobs that are doing inserts into the same linked server with no issues.  I assumed that those threads were out of date.

Here is my code for the insert that is working.

create procedure spETCABRAProjects

as

delete from tpaABRAProjects_ETC

insert into tpaABRAProjects_ETC
 (ProjectNum)
select
  code
from
  ABRA...hrtables H
where
  [table] = 'PR'

insert into ABRA...hrtables
 (c1, c2, c3, c4, code, company, [desc],
  glcomp, n1, n2, n3, [rule], [table], tccomp,
  ud1, ud2, ud3)
select
  '', '', '', '',
  P.chrJobNumber,
  '***',
  SUBSTRING(P.chrJobName, 1, 25),
  '',
  0, 0, 0,
  'N',
  'PR',
  '', '', '', ''
from
  tpa00175 P
where
  P.CompanyID = 'GAI' and
  not exists (select 1 from tpaABRAProjects_ETC AP
                where AP.ProjectNum = P.chrJobNumber)
go