none
SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;...... RRS feed

  • Вопрос

  • SCCM 1610 заметил почти во всех логах данное событие "SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMATmdy;"

    Сам SCCM в явном виде ни на что не ругается, SQL отдельно и там тоже в событиях все чисто. С недавнего времени созданные пакеты стали "застревать" на всех вторичных сайтах. Вопрос что это за сообщение и не говорит ли оно о проблемах с SQL раз все пакеты застревают на точках в статусе "выполняется"


    admin

    27 февраля 2017 г. 11:32

Ответы

Все ответы

  • в distmgr.log наблюдаете?

    с базами в Microsoft Customer Support Services (CSS)


    SCCM Blog: http://masyan.ru SCCM User Group Russia: https://www.facebook.com/groups/sccm.russia/ Telegram: https://telegram.me/configmgr

    27 февраля 2017 г. 13:11
    Модератор
  • да. все логи уже облазил

    на основном сайте

    Processing incoming file C:\Program Files\Microsoft Configuration Manager\inboxes\distmgr.box\INCOMING\D80GM143.STA. SMS_DISTRIBUTION_MANAGER 27.02.2017 14:18:33 11260 (0x2BFC)
    SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_DISTRIBUTION_MANAGER 27.02.2017 14:18:33 11260 (0x2BFC)
    SQL>>>>> Done. SMS_DISTRIBUTION_MANAGER 27.02.2017 14:18:33 11260 (0x2BFC)
    SQL>>>select Name,Version,Language,Manufacturer,Description,Source,SourceSite,StoredPkgPath,StoredPkgVersion,ShareName,PreferredAddress,StorePkgFlag,ShareType,Permission,RefreshSchedule,LastRefresh,UseForcedDisconnect,ForcedRetryDelay,DisconnectDelay,IgnoreSchedule,Priority,PkgFlags,MIFFilename,MIFPublisher,MIFName,MIFVersion,SourceVersion,SourceDate,SourceSize,SourceCompSize,ImageFlags,Hash,NewHash,HashVersion,Architecture,ImagePath,PackageType,AlternateContentProviders,SourceLocaleID,(select count(*) from vSMS_Program pg where pg.PkgID=SMSPackages.PkgID) as NumOfPrograms,SEDOComponentID,TransformReadiness,TransformAnalysisDate,SedoObjectVersion,DefaultImage,EncryptionKey,EncryptionAlgorithm,CryptoExtInfo,ISVString,PreDownloadRule,UpdateMask,Action,UpdateMaskEx FROM SMSPackages AS SMSPackages where PkgID = N'S0100025' SMS_DISTRIBUTION_MANAGER 27.02.2017 14:18:33 11260 (0x2BFC)
    SQL>>>>> Done. SMS_DISTRIBUTION_MANAGER 27.02.2017 14:18:33 11260 (0x2BFC)
    SQL>>>select  AlgorithmPreference, HashAlgorithm, Hash, SignatureHash from SMSPackageHash where PkgID = N'S0100025' SMS_DISTRIBUTION_MANAGER 27.02.2017 14:18:33 11260 (0x2BFC)
    SQL>>>>> Done. SMS_DISTRIBUTION_MANAGER 27.02.2017 14:18:33 11260 (0x2BFC)
    SQL>>>select UserGroup, Access from PkgAccess where PkgID = N'S0100025' order by UserGroup SMS_DISTRIBUTION_MANAGER 27.02.2017 14:18:33 11260 (0x2BFC)
    SQL>>>>> Done. SMS_DISTRIBUTION_MANAGER 27.02.2017 14:18:33 11260 (0x2BFC)
    SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_DISTRIBUTION_MANAGER 27.02.2017 14:18:33 11260 (0x2BFC)
    SQL>>>>> Done. SMS_DISTRIBUTION_MANAGER 27.02.2017 14:18:33 11260 (0x2BFC)
    SQL>>>select cp.Content_ID, cp.Content_UniqueID, cp.ContentVersion, cp.PkgID, cp.MinPackageVersion, cp.ContentSubFolder, c.SourceSize from CI_ContentPackages as cp join CI_Contents as c on cp.Content_ID = c.Content_ID where cp.ContentVersion>0 and cp.PkgID = N'S0100025' AND cp.Content_ID IN (select cicont.Content_ID from CI_ConfigurationItemContents as cicont  join vCI_ConfigurationItems as ci on ci.CI_ID=cicont.CI_ID  where ci.IsTombstoned = 0 AND ( ci.IsExpired = 0 OR ( ci.CIType_ID in (10,21) AND ci.IsLatest=1 AND  exists ( select * from CI_ConfigurationItemRelations cir inner join vCI_ConfigurationItems app on cir.FromCI_ID=app.CI_ID and cir.RelationType=9 where app.IsLatest=1 and cir.ToCI_ID=ci.CI_ID)))) order by cp.Content_ID SMS_DISTRIBUTION_MANAGER 27.02.2017 14:18:33 11260 (0x2BFC)
    SQL>>>>> Done. SMS_DISTRIBUTION_MANAGER 27.02.2017 14:18:33 11260 (0x2BFC)
    SQL>>>SELECT COUNT(*) FROM [ClientDeploymentSettings] WHERE [UpgradePackageID] = N'S0100025' OR [PilotingPackageID] = N'S0100025' SMS_DISTRIBUTION_MANAGER 27.02.2017 14:18:33 11260 (0x2BFC)
    SQL>>>>> Done. SMS_DISTRIBUTION_MANAGER 27.02.2017 14:18:33 11260 (0x2BFC)
    SQL>>>select top(1) CONVERT(NVARCHAR(56),LockID) from SEDO_LockableObjects where ObjectID = (SELECT ObjectID FROM SEDO_LockableObjectComponents WHERE ComponentID = N'738FFDBF-E80D-4DB3-A99E-E98B4AAF4F5D') SMS_DISTRIBUTION_MANAGER 27.02.2017 14:18:33 11260 (0x2BFC)
    SQL>>>>> Done. SMS_DISTRIBUTION_MANAGER 27.02.2017 14:18:33 11260 (0x2BFC)
    SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_DISTRIBUTION_MANAGER 27.02.2017 14:18:33 11260 (0x2BFC)

    и на вторичном 

    STATMSG: ID=2300 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_DISTRIBUTION_MANAGER" SYS=SPBM115-SRVSCCM.ETALON.LOCAL SITE=S02 PID=1964 TID=1412 GMTDATE=Пн фев 27 11:04:41.904 2017 ISTR0="TEST-COPY" ISTR1="S0100025" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=1 AID0=400 AVAL0="S0100025" SMS_DISTRIBUTION_MANAGER 27.02.2017 14:04:41 1412 (0x0584)
    Processing package S0100025 (SourceVersion:10;StoredVersion:0) SMS_DISTRIBUTION_MANAGER 27.02.2017 14:04:41 1412 (0x0584)
    No action specified for the package S0100025, however there may be package server changes for this package. SMS_DISTRIBUTION_MANAGER 27.02.2017 14:04:41 1412 (0x0584)
    The contents for the package S0100025 hasn't arrived from site S01 yet, will retry later. SMS_DISTRIBUTION_MANAGER 27.02.2017 14:04:41 1412 (0x0584)
    STATMSG: ID=2372 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_DISTRIBUTION_MANAGER" SYS=SPBM115-SRVSCCM.ETALON.LOCAL SITE=S02 PID=1964 TID=1412 GMTDATE=Пн фев 27 11:04:41.951 2017 ISTR0="S0100025" ISTR1="S01" ISTR2="S02" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=1 AID0=400 AVAL0="S0100025" SMS_DISTRIBUTION_MANAGER 27.02.2017 14:04:41 1412 (0x0584)
    All DP threads have completed for package S0100025 processing thread. SMS_DISTRIBUTION_MANAGER 27.02.2017 14:04:41 1412 (0x0584)
    Package S0100025 does not have a preferred sender. SMS_DISTRIBUTION_MANAGER 27.02.2017 14:04:42 1412 (0x0584)
    CDistributionSrcSQL::UpdateAvailableVersion PackageID=S0100025, Version=10, Status=2301 SMS_DISTRIBUTION_MANAGER 27.02.2017 14:04:42 1412 (0x0584)
    StoredPkgVersion (0) of package S0100025. StoredPkgVersion in database is 0. SMS_DISTRIBUTION_MANAGER 27.02.2017 14:04:42 1412 (0x0584)
    SourceVersion (10) of package S0100025. SourceVersion in database is 10. SMS_DISTRIBUTION_MANAGER 27.02.2017 14:04:42 1412 (0x0584)
    STATMSG: ID=2301 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_DISTRIBUTION_MANAGER" SYS=SPBM115-SRVSCCM.ETALON.LOCAL SITE=S02 PID=1964 TID=1412 GMTDATE=Пн фев 27 11:04:42.576 2017 ISTR0="TEST-COPY" ISTR1="S0100025" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=1 AID0=400 AVAL0="S0100025" SMS_DISTRIBUTION_MANAGER 27.02.2017 14:04:42 1412 (0x0584)
    Exiting package processing thread for package S0100025. SMS_DISTRIBUTION_MANAGER 27.02.2017 14:04:42 1412 (0x0584)
    Deleting trigger file 'S01.DSU' as it's not for a new site. SMS_DISTRIBUTION_MANAGER 27.02.2017 14:04:46 3908 (0x0F44)

    а статус в "мониторинге" по прежнему "выполняется" и "запуск обработки содержимого"


    admin

    27 февраля 2017 г. 13:39
  • тогда только рекомендация это писать обращение в Microsoft Customer Support Services (CSS)

    саппортов для партнеров https://partnersupport.microsoft.com/ru-ru

    премьер саппорт https://support.microsoft.com/en-us/premier

    для кастомеров https://support.microsoft.com/en-us/assistedsupportproducts 

    доступные варианты для кастомеров, если у вас энтерпрайз агримент, мсдн подписка и т.д. https://support.microsoft.com/en-us/gp/offerprophone


    SCCM Blog: http://masyan.ru SCCM User Group Russia: https://www.facebook.com/groups/sccm.russia/ Telegram: https://telegram.me/configmgr

    27 февраля 2017 г. 16:07
    Модератор