Buna ziua,

de ieri am o problema cu un job, el merge, dar cand dau click dreapta pe el-history, sau properties, imi da o eroare:
'TITLE: Microsoft SQL Server Management Studio
------------------------------

'', hexadecimal value 0x1F, is an invalid character. Line 1, position 178. (System.Xml)

------------------------------
BUTTONS:

OK
------------------------------
'
Detalii tehnice:
===================================

'', hexadecimal value 0x1F, is an invalid character. Line 1, position 178. (System.Xml)

------------------------------
Program Location:

   at System.Xml.XmlTextReaderImpl.Throw(Exception e)
   at System.Xml.XmlTextReaderImpl.Throw(String res, String[] args)
   at System.Xml.XmlTextReaderImpl.ThrowInvalidChar(Int32 pos, Char invChar)
   at System.Xml.XmlTextReaderImpl.ParseNumericCharRefInline(Int32 startPos, Boolean expand, BufferBuilder internalSubsetBuilder, Int32& charCount, EntityType& entityType)
   at System.Xml.XmlTextReaderImpl.ParseCharRefInline(Int32 startPos, Int32& charCount, EntityType& entityType)
   at System.Xml.XmlTextReaderImpl.ParseText(Int32& startPos, Int32& endPos, Int32& outOrChars)
   at System.Xml.XmlTextReaderImpl.ParseText()
   at System.Xml.XmlTextReaderImpl.ParseElementContent()
   at System.Xml.XmlTextReaderImpl.Read()
   at System.Xml.XmlWriter.WriteNode(XmlReader reader, Boolean defattr)
   at System.Xml.XmlReader.ReadOuterXml()
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.GenerateXmlDocument()
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.Invoke()


Nu am gasit nimic pe net despre probleme de genul asta. Eroarea apare pe 3 PCuri, nu e doar la desktop-ul meu. Serverul e un Microsoft SQL Server Standard Edition, versiune 9.00.3294.00

Daca aveti o idee cum sa rezolv problema, va rog ajutati-ma.

Multumesc,
Dani

Pe ce sistem de operare?

Incearca sa aplici SP3...

Intradevar, nu are SP3, dar pana ieri a mers ok.

OS  e un Win 2003 Server R2, SP2.

Revin dupa ce aplic SP3.

Multumesc,
Dani

Intre timp s-au mai facut modificari in mediul de lucru? Care e situatia PC-urilor in cauza?

Încearcă te rog următorul query şi spune-ne rezultatele:

declare @tmp_sp_help_jobhistory table
(
instance_id int null,
job_id uniqueidentifier null,
job_name sysname null,
step_id int null,
step_name sysname null,
sql_message_id int null,
sql_severity int null,
message nvarchar(4000) null,
run_status int null,
run_date int null,
run_time int null,
run_duration int null,
operator_emailed sysname null,
operator_netsent sysname null,
operator_paged sysname null,
retries_attempted int null,
server sysname null
)

insert into @tmp_sp_help_jobhistory
exec msdb.dbo.sp_help_jobhistory
@mode='FULL'

SELECT * FROM @tmp_sp_help_jobhistory WHERE message LIKE '%'+CHAR(0x1F)+'%'

Răzvan

Merci Razvan pt query, in acest moment nu returneaza nimic, dar problema s-a rezolvat inainte sa il rulez.
In numele jobului respectiv era un caracter ciudat (un patratel), l-am sters si acum merge ok vizualizarea de istoric si proprietate job.

Multumesc tuturor!
Dani

...