Undeclared tag ID 28 is used in a FOR XML EXPLICIT query

From: Peter Mison (pmison_at_atdw.com.au)
Date: 08/26/04 

Date: Wed, 25 Aug 2004 17:03:17 -0700

I have quite a large FOR XML EXPLICIT query in a stored
procedure with the last parent tag id as 28. The query
works perfectly most of the time however intermittently
this error occurs complaining that the Tag ID 28 is
undeclared. It is in fact declared.

The way I have been rectifying the problem to date is to
drop the stored procedure and re-load it (unchanged).
Then the query works perfectly again.

I am concerned why this is happenning as the tag in error
is definately declared. If it wasn't declared, you would
expect the error to occur 100% of the time (knowing that
there is no change to the data being returned).

I have seen only one other report of this on the internet
where it was suggested that it has something to do with
the ordering and that when it works it is only by
accident that the query plan allowed it to work. I am not
convinced it has anything to do with ordering. What this
error says to me is that the tag ID 28 has been refenced
but there is no such tag ID declared in the first union
where the columns are declared.

I would appreciate a response from anyone who can offer a
suggestion or who may have previously experienced and
resolved this issue.

Cheers
Pete

Relevant Pages

  • Re: Complex RecordSource
    ... FROM Bill ... You need to join your menu table to the query to display their selections. ... her spouses ... as the last name on the name tag of the spouse. ...
    (microsoft.public.access.reports)
  • RE: Complex RecordSource
    ... FROM Bill ... You need to join your menu table to the query to display their selections. ... her spouses ... as the last name on the name tag of the spouse. ...
    (microsoft.public.access.reports)
  • RE: Help with Record Not On File
    ... take the Where condition out of your query. ... be able to find a specific tag number. ... It's row source should be "SELECT TagNum FROM tblAnimals" ... Set rst = Me.RecordsetClone ...
    (microsoft.public.access.forms)
  • Re: crosstab query fails when based on query with subquery?
    ... revision needs to be calculated per tag per document. ... LEFT JOIN qryReleasesToRevisions AS tRR ON tRs.ID = tRR.releaseID ... The problem is that the crosstab query, generated from qryRevFlag, ...
    (microsoft.public.access.queries)
  • Re: Can the number of records to return be specified in an SQL query
    ... just add order by that tag at the end of your SQL query ... Now depending on the SQL Database you are querying you can put RANGE 51,100 ... I am trying to revise an app which has a grid that browses an entire ... I would like to do this with a query to keep the data ...
    (microsoft.public.fox.programmer.exchange)