locked
Database Assigned Applications not being Installed RRS feed

  • Question

  • Hi,

    I have a role with an application that is assigned to one or more computers in my MDT 2013 database. The deployment runs fine but it doesn't install the application. ZTIGather.log shows a connection to SQL with a return of 0, no apps. What is the best way to troubleshoot and fix this?

    ------ Processing the [CAPPS] section ------    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Determining the INI file to use.    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Using DEFAULT VALUE: Ini file = \\MDTSrv\MDTProduction$\Control\CustomSettings.ini    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Finished determining the INI file to use.    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Using specified INI file = \\MDTSrv\MDTProduction$\Control\CustomSettings.ini    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    CHECKING the [CAPPS] section    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Using from [CAPPS]: SQLServer = MDTSrv ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Using from [CAPPS]: Instance = ADK    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Port key not defined in the section [CAPPS]    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Using from [CAPPS]: Database = MDTPROD    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Using from [CAPPS]: Netlib = DBNMPNTW    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Using from [CAPPS]: Table = ComputerApplications    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    StoredProcedure key not defined in the section [CAPPS]    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    DBID key not defined in the section [CAPPS]    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    DBPwd key not defined in the section [CAPPS]    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Using from [CAPPS]: SQLShare = MDTProduction$    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Using from [CAPPS]: ParameterCondition = OR    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Validating connection to \\MDTSrv\MDTProduction$    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Mapping server share: \\MDTSrv\MDTProduction$    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Already connected to server MDTSrv ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    OPENING TRUSTED SQL CONNECTION to server MDTSrv.    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Connecting to SQL Server using connect string: Provider=SQLOLEDB;OLE DB Services=0;Data Source=MDTSrv\ADK;Initial Catalog=MDTPROD;Network Library=DBNMPNTW;Integrated Security=SSPI    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Successfully opened connection to database.    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    About to issue SQL statement: SELECT * FROM ComputerApplications WHERE UUID = '13153A3C-C9A2-11E4-A986-EAB1F5ED0D00' OR SERIALNUMBER = '12345678' OR MACADDRESS IN ('00:11:22:33:44:55') ORDER BY Sequence    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Successfully queried the database.    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)
    Record count from SQL = 0.    ZTIGather    7/15/2016 1:46:08 PM    0 (0x0000)

    CS.ini

    [Settings]
    Priority=CSettings, CPackages, CApps, CAdmins, CRoles, Locations, LSettings, LPackages, LApps, LAdmins, LRoles, MMSettings, MMPackages, MMApps, MMAdmins, MMRoles, RSettings, RPackages, RApps, RAdmins,Default
    Properties=MyCustomProperty

    [Default]
    _SMSTSORGNAME=Computing
    _SMSTSPackageName=%TaskSequenceName%
    OSInstall=Y
    UserDataLocation=AUTO
    TimeZoneName=Eastern Standard Time
    AdminPassword=password
    JoinDomain=domain.com
    DomainAdmin=DOMAIN\mdt
    DomainAdminPassword=password
    'MachineObjectOU=OU=Desktops,DC=domain,DC=com
    SLShare=%DeployRoot%\Captures\Logs
    'SLShareDynamicLogging=%DeployRoot%\Logs\%COMPUTERNAME%
    ScanStateArgs=/ue:*\* /ui:SAS\*
    USMTMigFiles001=MigApp.xml
    USMTMigFiles002=MigUser.xml
    HideShell=NO
    ApplyGPOPack=NO
    WSUSServer=http://wsus.domain.com
    SkipAppsOnUpgrade=NO
    SkipAdminPassword=YES
    SkipProductKey=YES
    SkipComputerName=YES
    SkipDomainMembership=YES
    SkipUserData=YES
    SkipLocaleSelection=YES
    SkipTaskSequence=YES
    SkipTimeZone=YES
    SkipApplications=NO
    SkipBitLocker=YES
    SkipSummary=YES
    SkipCapture=YES
    SkipFinalSummary=NO
    FinishAction=LOGOFF
    EventService=http://MDTSrv:9800
    BitsPerPel=32
    VRefresh=60
    XResolution=1
    YResolution=1

    SkipLocaleSelection=YES
    UILanguage=en-US
    UserLocale=0409:00000409
    InputLocale= 0409:00000409
    KeyboardLocale= 0409:00000409

    [CSettings]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=ComputerSettings
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR

    [CPackages]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=ComputerPackages
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR
    Order=Sequence

    [CApps]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=ComputerApplications
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR
    Order=Sequence

    [CAdmins]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=ComputerAdministrators
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR

    [CRoles]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=ComputerRoles
    Parameters=UUID, AssetTag, SerialNumber, MacAddress
    ParameterCondition=OR

    [Locations]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=Locations
    Parameters=DefaultGateway

    [LSettings]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=LocationSettings
    Parameters=DefaultGateway

    [LPackages]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=LocationPackages
    Parameters=DefaultGateway
    Order=Sequence

    [LApps]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=LocationApplications
    Parameters=DefaultGateway
    Order=Sequence

    [LAdmins]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=LocationAdministrators
    Parameters=DefaultGateway

    [LRoles]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=LocationRoles
    Parameters=DefaultGateway

    [MMSettings]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=MakeModelSettings
    Parameters=Make, Model

    [MMPackages]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=MakeModelPackages
    Parameters=Make, Model
    Order=Sequence

    [MMApps]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=MakeModelApplications
    Parameters=Make, Model
    Order=Sequence

    [MMAdmins]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=MakeModelAdministrators
    Parameters=Make, Model

    [MMRoles]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=MakeModelRoles
    Parameters=Make, Model

    [RSettings]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=RoleSettings
    Parameters=Role

    [RPackages]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=RolePackages
    Parameters=Role
    Order=Sequence

    [RApps]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=RoleApplications
    Parameters=Role
    Order=Sequence

    [RAdmins]
    SQLServer=MDTSrv
    Instance=ADK
    Database=MDTPROD
    Netlib=DBNMPNTW
    SQLShare=MDTProduction$
    Table=RoleAdministrators
    Parameters=Role

    Thanks


    Jason

    Friday, July 15, 2016 7:50 PM