ArcGIS Server 10.1 Publishing Map Services issue

Question

Good day,

i have an issue when publishing a MAP document on ArcGIS Server 10.1 final release where i get a "Service Publishing Result" window reporting the following error after some time during publishing process: "ERROR 001272: Analyzer errors were encountered (codes = 7)." same MXD can publish on ArcGIS 10.0 with no problem.

during troubleshooting this issue, we found out that certain query expressions used to govern what feature shows and what scale, which are validated and correct, had to be removed for the publish operation to go through.

can you please tell me if there is a limitation in 10.1 when publishing MXD documents using query expressions ? how to overcome this issue ?

RachelS · Answer

FYI: the date query syntax is dependent on the underlying data source, for example SQL Server requires in one way while FileGBD does it another way.

Hi, My date syntax is for the sql server which is what my data is, surely when using query builder it builds it according to the underlying data source. I still can't see why it won't publish it when it's in the correct syntax for sql server!

TanuHoque · Answer

Hi,
The query is a date (to show only records of 2012) and text query it's:
Date_Tested >= '2012-01-01 00:00:00' AND Colour = 'Blue'

FYI: the date query syntax is dependent on the underlying data source, for example SQL Server requires in one way while FileGBD does it another way.

RachelS · Answer

Hi,
I am having this same error Error 001272:Analyzer errors were encountered (codes = 7,7,7,7,7,7) thats the 6 layers I have.
I've worked out it's a problem with the definition query on each of them, because when I remove it there is no error but my definition query is essential. It was built using the Query builder so not sure why there is a problem.
The query is a date (to show only records of 2012) and text query it's:
Date_Tested >= '2012-01-01 00:00:00' AND Colour = 'Blue'

On a closer look it's the date part of the query it has a problem with, but how else can I write a query for a Date field?
Many thanks
Rachel