Afaria Profile failed to install

[Former Member]

Hi all,

we have installed the Afaria 7 SP3.

While trying to enroll in iOS device getting a error Profile faild to install. where can we trace this error. kindly help me to solve this issue.

Thanks,

Boopalan.M

[rakshit_doshi]

Dear Tushar,

Can you try to debug and find the error where exactly it is happening.

For debugging on Afaria Server follow these steps

1. Download DebugView and run it as Administrator

2. Go to the AIPS directory and under the Bin folder there is an AfariaIphoneServer.exe.config file. Set the LogDebugInfo variable to yes

Once you make this change, restart the AfariaIPhoneServer services.

In the debugview go to Capture button on the top and select all the available options (P.N to run the DebugView.exe file as Administrator)

Launch the Afaria Client on iPhone. Remember to enable debugging for the Afaria Client from the Settings screen. Keep the log level as Debug.

Run the iPhone Configuration Utility on your desktop and attach the iphone via USB to your desktop.

Initiate the enrollment process.

Capture the error on both the logs. This will help you understand if something is not working.

Kindly post both the logs for further analysis

Hope this helps,

Thanks,

Best Regards,

Rakshit Doshi

[Former Member]

Hello Rakshit,

We have collected the logs as you suggested. But unable to upload it..

[Former Member]

Debug View logs_iPhone server

00000001	0.00000000	[1960] thread:26 time: 2014/11/03 17:44:34
00000002	0.00000000	[1960] IPhoneSCEPEnrollRequestInfo SetDevInfoAndGetSCEPEnrollRequestInfo(DevInfo.6a664eab-0b36-4d43-9e5c-717e818411ce)
00000003	0.00000000	[1960]
00000004	0.00019590	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Select * from A_V_IPHONE_DEVICE,A_IPHONE_CHAL where Challenge=@cwe_Challenge and ARowID=A_IPHONE_CHAL.ClientUID and Type=1 << SetDevInfoAndGetSCEPEnrollRequestInfo.setDevInfoQuery, Params: 6a664eab-0b36-4d43-9e5c-717e818411ce
00000005	0.00270660	[1960] thread:26 time: 2014/11/03 17:44:34  RunQuery return <<setDevInfoQuery
00000006	0.00294090	[1960] thread:26 time: 2014/11/03 17:44:34  SetDevInfoAndGetSCEPEnrollRequestInfo T[1] R[1]
00000007	0.00307590	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Select * from A_V_IPHONE_DEVICE where UDID=@cwe_UDID and ARowID<>@cwe_ARowID << SetDevInfoAndGetSCEPEnrollRequestInfo.findAmbiguousUDIDQuery, Params: 116113a8f8dad3e44aa97e0a419c3627cfd672a5, 246
00000008	0.00390370	[1960] thread:26 time: 2014/11/03 17:44:34  RunQuery return <<findAmbiguousUDIDQuery
00000009	0.00399320	[1960] thread:26 time: 2014/11/03 17:44:34 >> IMEI[ DB: DevInfo:013538007168168 ] <<
00000010	0.00413990	[1960] thread:26 time: 2014/11/03 17:44:34 SetDevInfoAndGetSCEPEnrollRequestInfo Connection Log Entry:
00000011	0.00413990	[1960]   DeviceTableID: 246
00000012	0.00413990	[1960]   Action: Info. reply.
00000013	0.00413990	[1960]   Data: device @
00000014	0.00426260	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL LogConnectionState: insert into A_IPHONE_LOG ( ClientUID, TimeStamp, Action, Data, ConnectionID ) values (@cwe_ClientUID, @cwe_TimeStamp, @cwe_Action, @cwe_Data, @cwe_ConnectionID) << LogConnectionState.connectionLogInsert, Params: 246, 11/3/2014 5:44:34 PM, Info. reply., device @ , {6e80d0f6-329b-4850-8859-f474227d4a85}
00000015	0.02366440	[1960] thread:26 time: 2014/11/03 17:44:34  RunSQL return <<connectionLogInsert
00000016	0.02377730	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: insert into A_INV_SCANDATA_INPUT ( XMLData ) values ( @cwe_XMLData ) << SetDevInfoAndGetSCEPEnrollRequestInfo.initDBdataMembers, Params: <?xml version="1.0" encoding="utf-8"?>
00000017	0.02377730	[1960] <InventoryInfo>
00000018	0.02377730	[1960]  <Device>
00000019	0.02377730	[1960]   <ClientCategory>-8</ClientCategory>
00000020	0.02377730	[1960]   <DeviceOS>iOS</DeviceOS>
00000021	0.02377730	[1960]   <AssignedID>116113a8f8dad3e44aa97e0a419c3627cfd672a5</AssignedID>
00000022	0.02377730	[1960]   <iosUDID>116113A8F8DAD3E44AA97E0A419C3627CFD672A5</iosUDID>
00000023	0.02377730	[1960]   <ClassRestrictions>Client,Device,Phone</ClassRestrictions>
00000024	0.02377730	[1960]   <MissingTagDeletesData>y</MissingTagDeletesData>
00000025	0.02377730	[1960]   <iosDeviceOS>ios</iosDeviceOS>
00000026	0.02377730	[1960]   <iosICCID />
00000027	0.02377730	[1960]   <iosIMEI>013538007168168</iosIMEI>
00000028	0.02377730	[1960]   <iosProduct>IPHONE4,1</iosProduct>
00000029	0.02377730	[1960]   <iosSerialNumber>C8PML1V5FMLD</iosSerialNumber>
00000030	0.02377730	[1960]   <iosRomVersion>11D257</iosRomVersion>
00000031	0.02377730	[1960]   <iosPhoneNumber />
00000032	0.02377730	[1960]   <iosSMTPNotifyAddr />
00000033	0.02377730	[1960]   <iosUserName />
00000034	0.02377730	[1960]  </Device>
00000035	0.02377730	[1960] </InventoryInfo>
00000036	0.02377730	[1960]
00000037	0.03165770	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL setAfariaInventoryMdmEntry: SELECT * FROM A_INV_IPHONE_AFARIA WHERE ClientUID=@cwe_ClientUID << setAfariaInventoryMdmEntry.CheckScanData, Params: 246
00000038	0.03242820	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL setAfariaInventoryMdmEntry: UPDATE A_INV_IPHONE_AFARIA SET MDM=@cwe_MDM WHERE  ClientUID=@cwe_ClientUID << setAfariaInventoryMdmEntry.UpdateScanData, Params: 0, 246
00000039	0.03358590	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Update A_IPHONE_DEVICE Set UDID=@cwe_UDID,ICCID=@cwe_ICCID,Version=@cwe_Version1 Where ClientUID=@cwe_ClientUID1 << SetDevInfoAndGetSCEPEnrollRequestInfo.setDevClientInfoUpdate, Params: 116113A8F8DAD3E44AA97E0A419C3627CFD672A5, , 11D257, 246
00000040	0.03424480	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Update A_CLIENT Set IMEI=@cwe_IMEI, SerialNumber=@cwe_SerialNumber, OSVersion=@cwe_OSVersion2, Model=@cwe_Model, PhoneNumber=@cwe_PhoneNumber Where ClientUID=@cwe_ClientUID2 << SetDevInfoAndGetSCEPEnrollRequestInfo.setDevClientInfoUpdate, Params: 013538007168168, C8PML1V5FMLD, 11D257, IPHONE4,1, , 246
00000041	0.04395480	[1960] thread:26 time: 2014/11/03 17:44:34  RunSQL return <<setDevClientInfoUpdate
00000042	0.04409010	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Select * from A_IPHONE_DEVICE where ClientUID=@cwe_ClientUID  << SetDevInfoAndGetSCEPEnrollRequestInfo.SetDevInfoAndGetSCEPEnrollRequestInfo.UpdateSignMdmMessages, Params: 246
00000043	0.04508820	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Update A_IPHONE_DEVICE Set SignMdmMessages=@cwe_SignMdmMessages Where ClientUID=@cwe_ClientUID << SetDevInfoAndGetSCEPEnrollRequestInfo.SetDevInfoAndGetSCEPEnrollRequestInfo.UpdateSignMdmMessages, Params: 0, 246
00000044	0.04599090	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Select * from A_INV_IPHONE_PHONE where ClientCategory=-8 and ClientUID=@cwe_ClientUID << SetDevInfoAndGetSCEPEnrollRequestInfo.getInvPhoneStatusQuery, Params: 246
00000045	0.04670890	[1960] thread:26 time: 2014/11/03 17:44:34  RunSQL return <<getInvPhoneStatusQuery
00000046	0.04683540	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: insert into A_INV_IPHONE_PHONE (ClientUID, ICCID, ClientCategory) values (@cwe_Param0, @cwe_Param1, @cwe_Param2) << SetDevInfoAndGetSCEPEnrollRequestInfo.Insert, Params: 246, , -8
00000047	0.05674370	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Select * from A_IPHONE_VERSION_MAP where ROMNumber=@cwe_ROMNumber << SetDevInfoAndGetSCEPEnrollRequestInfo.convertROM2OSquery, Params: 11d257
00000048	0.05739390	[1960] thread:26 time: 2014/11/03 17:44:34  RunQuery return <<convertROM2OSquery
00000049	0.05755590	[1960] thread:26 time: 2014/11/03 17:44:34  SetDevInfoAndGetSCEPEnrollRequestInfo T[1] R[0]
00000050	0.05768670	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: UPDATE A_CLIENT SET IMEI=@cwe_IMEI, SerialNumber=@cwe_SerialNumber, Model=@cwe_Model WHERE ClientUID = @cwe_ClientUID << SetDevInfoAndGetSCEPEnrollRequestInfo.SetClientInfo, Params: 013538007168168, C8PML1V5FMLD, IPHONE4,1, 246
00000051	0.05861890	[1960] thread:26 time: 2014/11/03 17:44:34  RunSQL return <<SetClientInfo
00000052	0.05876650	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Select * from A_INV_IPHONE_DEVICE where ClientCategory=-8 and ClientUID=@cwe_ClientUID << SetDevInfoAndGetSCEPEnrollRequestInfo.getInvDeviceStatusQuery, Params: 246
00000053	0.05954870	[1960] thread:26 time: 2014/11/03 17:44:34  RunSQL return <<getInvDeviceStatusQuery
00000054	0.05968990	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: insert into A_INV_IPHONE_DEVICE (ClientUID, UDID, Version, SMTPNotifyAddr, UserName, ClientCategory) values (@cwe_Param0, @cwe_Param1, @cwe_Param2, @cwe_Param3, @cwe_Param4, @cwe_Param5) << SetDevInfoAndGetSCEPEnrollRequestInfo.Insert, Params: 246, 116113A8F8DAD3E44AA97E0A419C3627CFD672A5, 11D257, , , -8
00000055	0.06915660	[1960] thread:26 time: 2014/11/03 17:44:34
00000056	0.06915660	[1960]  >>> getScepUriCrqInfoAndSigningCertName entry
00000057	0.07620320	[1960] thread:26 time: 2014/11/03 17:44:34
00000058	0.07620320	[1960]  >>> getScepUriCrqInfoAndSigningCertName exit
00000059	0.07634540	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Update A_IPHONE_CHAL Set Type='3' Where Challenge=@cwe_Challenge and ClientUID=@cwe_ClientUID << SetDevInfoAndGetSCEPEnrollRequestInfo.setDevInfoStateAndGuidUpdate, Params: 6a664eab-0b36-4d43-9e5c-717e818411ce, 246
00000060	0.08610870	[1960] thread:26 time: 2014/11/03 17:44:34  RunSQL return <<setDevInfoStateAndGuidUpdate
00000061	0.09137110	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Select * from A_V_IPHONE_DEVICE where UDID=@cwe_UDID << SetDevInfoAndGetSCEPEnrollRequestInfo.SetDevInfoAndGetSCEPEnrollRequestInfoUDIDquery, Params: 116113a8f8dad3e44aa97e0a419c3627cfd672a5
00000062	0.09246660	[1960] thread:26 time: 2014/11/03 17:44:34 CaName: ServPro-SERVPRO66-CA
00000063	0.09256470	[1960] thread:26 time: 2014/11/03 17:44:34 CommonName:
00000064	0.09265150	[1960] thread:26 time: 2014/11/03 17:44:34 OrganizationName:
00000065	0.09273620	[1960] thread:26 time: 2014/11/03 17:44:34 OrganizationUnit:
00000066	0.09282050	[1960] thread:26 time: 2014/11/03 17:44:34 City:
00000067	0.09290420	[1960] thread:26 time: 2014/11/03 17:44:34 State:
00000068	0.09299910	[1960] thread:26 time: 2014/11/03 17:44:34 Country: IN
00000069	0.09318590	[1960] thread:26 time: 2014/11/03 17:44:34 SetDevInfoAndGetSCEPEnrollRequestInfo Connection Log Entry:
00000070	0.09318590	[1960]   DeviceTableID: 246
00000071	0.09318590	[1960]   Action: Enrollment req.
00000072	0.09318590	[1960]   Data: UDID: 116113A8F8DAD3E44AA97E0A419C3627CFD672A5, Cert. CN: 116113A8F8DAD3E44AA97E0A419C3627CFD672A5
00000073	0.09333520	[1960] thread:26 time: 2014/11/03 17:44:34 <SQL LogConnectionState: insert into A_IPHONE_LOG ( ClientUID, TimeStamp, Action, Data, ConnectionID ) values (@cwe_ClientUID, @cwe_TimeStamp, @cwe_Action, @cwe_Data, @cwe_ConnectionID) << LogConnectionState.connectionLogInsert, Params: 246, 11/3/2014 5:44:34 PM, Enrollment req., UDID: 116113A8F8DAD3E44AA97E0A419C3627CFD672A5, Cert. CN: 116113A8F8DAD3E44AA97E0A419C3627CFD672A5, {6e80d0f6-329b-4850-8859-f474227d4a85}
00000074	0.10240070	[1960] thread:26 time: 2014/11/03 17:44:34  RunSQL return <<connectionLogInsert
00000075	0.10282080	[1960] thread:26 time: 2014/11/03 17:44:34
00000076	0.10282080	[1960]  >>> IPhoneSCEPEnrollRequestInfo SetDevInfoAndGetSCEPEnrollRequestInfo exit
00000077	0.14486080	[1960] getClientInfoEx: queryA row# 0
00000078	0.14575940	[1960] getClientInfoEx: queryB row# 1
00000079	0.14592940	[1960] thread:26 time: 2014/11/03 17:44:34
00000080	0.14592940	[1960]  >>> getScepUriCrqInfoAndSigningCertName entry
00000081	0.14918759	[1960] thread:26 time: 2014/11/03 17:44:34
00000082	0.14918759	[1960]  >>> getScepUriCrqInfoAndSigningCertName exit
00000083	3.28608274	[1960]  lookup Id: {67d95b09-f47d-4dc8-acd8-c9a842e8e5fc}
00000084	4.20606375	[1960] thread:26 time: 2014/11/03 17:44:38
00000085	4.20606375	[1960] IPhoneConfigs SetCertificateAndGetPolicies(DevInfo.116113A8F8DAD3E44AA97E0A419C3627CFD672A5, x509[1422], IPhoneDatabaseRow)
00000086	4.20606375	[1960]
00000087	4.20627451	[1960] thread:26 time: 2014/11/03 17:44:38 <SQL SetCertificateAndGetPolicies: Select * from A_IPHONE_VERSION_MAP where ROMNumber=@cwe_ROMNumber << SetCertificateAndGetPolicies.convertROM2OSquery, Params: 11d257
00000088	4.20728302	[1960] thread:26 time: 2014/11/03 17:44:38  RunQuery return <<convertROM2OSquery
00000089	4.20743275	[1960] thread:26 time: 2014/11/03 17:44:38  SetCertificateAndGetPolicies T[1] R[0]
00000090	4.20758200	[1960] thread:26 time: 2014/11/03 17:44:38 <SQL SetCertificateAndGetPolicies: Select * from A_V_IPHONE_DEVICE,A_IPHONE_CHAL where UDID=@cwe_UDID and Type='3' and A_V_IPHONE_DEVICE.ClientUID=A_IPHONE_CHAL.ClientUID << SetCertificateAndGetPolicies.setCertAndGetPolicyQuery, Params: 116113a8f8dad3e44aa97e0a419c3627cfd672a5
00000091	4.20940304	[1960] thread:26 time: 2014/11/03 17:44:38  RunQuery return <<setCertAndGetPolicyQuery
00000092	4.20956659	[1960] thread:26 time: 2014/11/03 17:44:38  SetCertificateAndGetPolicies T[1] R[1]
00000093	4.20971632	[1960] thread:26 time: 2014/11/03 17:44:38 <SQL deviceTenantEnabled: Select A_V_IPHONE_DEVICE.TenantID, A_V_IPHONE_DEVICE.ARowID, A_TENANT.TenantID, A_TENANT.State from A_V_IPHONE_DEVICE, A_TENANT where A_V_IPHONE_DEVICE.TenantID = A_TENANT.TenantID and A_V_IPHONE_DEVICE.ARowID=@cwe_ARowID << deviceTenantEnabled.deviceEnabledInTenantQuery, Params: 246
00000094	4.21078253	[1960] thread:26 time: 2014/11/03 17:44:38  RunQuery return <<deviceEnabledInTenantTenantQuery
00000095	4.21088362	[1960] thread:26 time: 2014/11/03 17:44:38  SetCertificateAndGetPolicies.deviceTenantEnabled T[1] R[1] State: Enabled
00000096	4.21104383	[1960] thread:26 time: 2014/11/03 17:44:38 SetCertificateAndGetPolicies Connection Log Entry:
00000097	4.21104383	[1960]   DeviceTableID: 246
00000098	4.21104383	[1960]   Action: Enrollment reply.
00000099	4.21104383	[1960]   Data: CN = 116113A8F8DAD3E44AA97E0A419C3627CFD672A5
00000100	4.21121216	[1960] thread:26 time: 2014/11/03 17:44:38 <SQL LogConnectionState: insert into A_IPHONE_LOG ( ClientUID, TimeStamp, Action, Data, ConnectionID ) values (@cwe_ClientUID, @cwe_TimeStamp, @cwe_Action, @cwe_Data, @cwe_ConnectionID) << LogConnectionState.connectionLogInsert, Params: 246, 11/3/2014 5:44:38 PM, Enrollment reply., CN = 116113A8F8DAD3E44AA97E0A419C3627CFD672A5, {6e80d0f6-329b-4850-8859-f474227d4a85}
00000101	4.23300409	[1960] thread:26 time: 2014/11/03 17:44:38  RunSQL return <<connectionLogInsert
00000102	4.23322344	[1960] thread:26 time: 2014/11/03 17:44:38 <SQL SetCertificateAndGetPolicies: Update A_IPHONE_DEVICE Set LastMDMConnect=@cwe_LastMDMConnect,PublicKey=@cwe_PublicKey,Version=@cwe_Version Where ClientUID=@cwe_ClientUID << SetCertificateAndGetPolicies.setCertOsUpdate, Params: 11/3/2014 5:44:38 PM, MIIFijCCBHKgAwIBAgIKFF58sQAAAAAB7TANBgkqhkiG9w0BAQUFADBMMRIwEAYKCZImiZPyLGQBGRYCaW4xFzAVBgoJkiaJk/IsZAEZFgdTZXJ2UHJvMR0wGwYDVQQDExRTZXJ2UHJvLVNFUlZQUk82Ni1DQTAeFw0xNDExMDMxMjA0MzhaFw0xNjExMDIxMjA0MzhaMHAxCzAJBgNVBAYTAklOMQowCAYDVQQIEwEgMQowCAYDVQQHEwEgMQowCAYDVQQKEwEgMQowCAYDVQQLEwEgMTEwLwYDVQQDEygxMTYxMTNBOEY4REFEM0U0NEFBOTdFMEE0MTlDMzYyN0NGRDY3MkE1MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAxWNwHZA4ZODtiL9RNt/L0l6VfNBHy6IHnrj6oWjRPkap/ph3g9zVex0B5kAoX3xMT71PQbp61fI7+AVCdEB9y/Dl6IBMD3ricOLzYRDxmoltIUDhNgkLHXiA/rG0zyrqa8G7yQd93xoyRcXgl4BlM7ht6X7u/k4gB86ouU5Eb4ToK5t9SliqmmaUpdF0uj4GHxoS4tiIzW+RG6GvLTyVfm+CPNJ3bkZIgPiaG5DrrJEigMwVuAi2//y6gBs1x5esvLcAi9RZG14IGWFNEfpJe2hP7aXGDgBwy/htXxVM4NOjHS5fuYI1idhb6fGbcV32bfZ9Ap5tqhCBLW8sqYpDpwIDAQABo4ICSDCCAkQwDgYDVR0PAQH/BAQDAgWgMB0GA1UdDgQWBBR2G8+4vAUTAA+zmfq/G7qSaQA79TAfBgNVHSMEGDAWgBTZUL+9h9eZva8+73pgYpdalcLQ3TCB0wYDVR0fBIHLMIHIMIHFoIHCoIG/hoG8bGRhcDovLy9DTj1TZXJ2UHJvLVNFUlZQUk82Ni1DQSxDTj1TZXJ2cHJvNjYsQ049Q0RQLENOPVB1YmxpYyUyMEtleSUyMFNlcnZpY2VzLENOPVNlcnZpY2VzLENOPUNvbmZpZ3VyYXRpb24sREM9U2VydlBybyxEQz1pbj9jZXJ0aWZpY2F0ZVJldm9jYXRpb25MaXN0P2Jhc2U/b2JqZWN0Q2xhc3M9Y1JMRGlzdHJpYnV0aW9uUG9pbnQwgcUGCCsGAQUFBwEBBIG4MIG1MIGyBggrBgEFBQcwAoaBpWxkYXA6Ly8vQ049U2VydlByby1TRVJWUFJPNjYtQ0EsQ049QUlBLENOPVB1YmxpYyUyMEtleSUyMFNlcnZpY2VzLENOPVNlcnZpY2VzLENOPUNvbmZpZ3VyYXRpb24sREM9U2VydlBybyxEQz1pbj9jQUNlcnRpZmljYXRlP2Jhc2U/b2JqZWN0Q2xhc3M9Y2VydGlmaWNhdGlvbkF1dGhvcml0eTA/BgkrBgEEAYI3FAIEMh4wAEkAUABTAEUAQwBJAG4AdABlAHIAbQBlAGQAaQBhAHQAZQBPAGYAZgBsAGkAbgBlMBMGA1UdJQQMMAoGCCsGAQUFCAICMA0GCSqGSIb3DQEBBQUAA4IBAQBfIc4IZlKxaW09YbbHaYwzNr7leHcbBEHg360/sPkEiOzrmnAkCm6ZttIu/OX9m26JPrlzuVNYuNdrumxNFUmvz+H7PnqQ2XnZhRWx0E6Q65Zg4MlChSXDkCsfX+fhxv2L2I3oy0o5w+lu99B7R1U+zyxxyz4eMKib9T55GXN7sl1YD/wlqUAEjCUuBIoGw6l/kL8s8FQ5xW3sGVuQrbcOYh8uDNpoedOds6qKFUVcqJGw9BIEjvdNMh5InNsnsDqcmogQ/kcUbPylZ+p5f74K8+Mt0wSXjskNA9fyQPEkA/PjdkI/uAPvKgrCLl7nZqa2Azg8EPLoAYLWjG4cn3Zp, 11d257, 246
00000103	4.27847528	[1960] thread:26 time: 2014/11/03 17:44:39  RunSQL return <<setCertOsUpdate
00000104	4.27866220	[1960] thread:26 time: 2014/11/03 17:44:39 <SQL SetCertificateAndGetPolicies: Select * from A_IPHONE_MDM_QUEUE where ClientUID=@cwe_ClientUID << SetCertificateAndGetPolicies.getQueueDataQuery, Params: 246
00000105	4.28001022	[1960] thread:26 time: 2014/11/03 17:44:39  RunQuery return <<getQueueDataQuery
00000106	4.28011370	[1960] thread:26 time: 2014/11/03 17:44:39  SetCertificateAndGetPolicies T[1] R[11]
00000107	4.28027916	[1960] thread:26 time: 2014/11/03 17:44:39 SQL profile[11]
00000108	4.28047943	[1960] thread:26 time: 2014/11/03 17:44:39 <SQL SetCertificateAndGetPolicies: Select * from A_PRFL_POLICIES where PolicyID=@cwe_PolicyID << SetCertificateAndGetPolicies.getPolicyPayloadQuery, Params: {bdf39e52-3a82-46d6-b1b1-00cd67f5c20d}
00000109	4.28172445	[1960] thread:26 time: 2014/11/03 17:44:39  RunQuery return <<getPolicyPayloadQuery
00000110	4.28188705	[1960] thread:26 time: 2014/11/03 17:44:39 <SQL SetCertificateAndGetPolicies: Select * from A_PRFL_POLICIES where PolicyID=@cwe_PolicyID << SetCertificateAndGetPolicies.getPolicyPayloadQuery, Params: {8b399ecf-37a9-4c72-afa2-8cd49853e8ec}
00000111	4.28297949	[1960] thread:26 time: 2014/11/03 17:44:39  RunQuery return <<getPolicyPayloadQuery
00000112	4.28314877	[1960] thread:26 time: 2014/11/03 17:44:39 <SQL getDeviceWiFiMAC: Select * from A_V_IPHONE_DEVICE where ARowID=@cwe_ARowID << getDeviceWiFiMAC.getWiFiMACdeviceIDquery, Params: 246
00000113	4.28442526	[1960] thread:26 time: 2014/11/03 17:44:39  RunQuery return <<SetCertificateAndGetPolicies.getWiFiMACdeviceIDquery
00000114	4.28467989	[1960] thread:26 time: 2014/11/03 17:44:39 SetCertificateAndGetPolicies DeviceID: 246 WiFiMAC:  TenantID: -1 ret: False
00000115	4.28485346	[1960] thread:26 time: 2014/11/03 17:44:39 <SQL buildMdmConfigurationProfile: Select * from A_V_IPHONE_DEVICE where UDID=@cwe_UDID << buildMdmConfigurationProfile.buildMdmConfigurationProfileUDIDquery, Params: 116113a8f8dad3e44aa97e0a419c3627cfd672a5
00000116	4.28622150	[1960] thread:26 time: 2014/11/03 17:44:39  RunQuery return <<buildMdmConfigurationProfileUDIDquery
00000117	4.28660297	[1960] thread:26 time: 2014/11/03 17:44:39
00000118	4.28660297	[1960]  >>> getScepUriCrqInfoAndSigningCertName entry
00000119	4.29251051	[1960] thread:26 time: 2014/11/03 17:44:39
00000120	4.29251051	[1960]  >>> getScepUriCrqInfoAndSigningCertName exit
00000121	4.29268551	[1960] thread:26 time: 2014/11/03 17:44:39
00000122	4.29268551	[1960]  >>> getScepUriCrqInfoAndSigningCertName entry
00000123	4.29602289	[1960] thread:26 time: 2014/11/03 17:44:39
00000124	4.29602289	[1960]  >>> getScepUriCrqInfoAndSigningCertName exit
00000125	4.35947418	[1960] thread:26 time: 2014/11/03 17:44:39  >>> buildSCEPcertDictionary Challenge: 116113a8f8dad3e44aa97e0a419c3627cfd672a5 UseSCEPchallenge: True
00000126	4.36725378	[1960] thread:26 time: 2014/11/03 17:44:39 <SQL buildMdmConfigurationProfile: Select * From A_IPHONE_SETTINGS Where TenantID=@cwe_TenantID << buildMdmConfigurationProfile.buildMdmConfigurationProfileSettingsQuery, Params: 0
00000127	4.36963463	[1960] thread:26 time: 2014/11/03 17:44:39  RunSQL return <<buildMdmConfigurationProfileSettingsQuery
00000128	4.39630461	[1960] thread:26 time: 2014/11/03 17:44:39 ES extractCertChain count: 1
00000129	4.39650249	[1960] thread:26 time: 2014/11/03 17:44:39 <SQL buildMdmConfigurationProfile: Select * From A_IPHONE_SETTINGS Where TenantID=@cwe_TenantID << buildMdmConfigurationProfile.buildMdmConfigurationProfileTenantedSettingsQuery, Params: 4
00000130	4.39749193	[1960] thread:26 time: 2014/11/03 17:44:39 buildMdmConfigurationProfile.RunSQL return <<buildMdmConfigurationProfileTenantedSettingsQuery
00000131	4.39783716	[1960] thread:26 time: 2014/11/03 17:44:39 buildMdmConfigurationProfile invalid tenant: 4 revert to SystemTenant: 0
00000132	4.39786386	[1960] thread:26 time: 2014/11/03 17:44:39 createProfile
00000133	4.39786386	[1960] <?xml version="1.0" encoding="UTF-8"?>
00000134	4.39786386	[1960] <!DOCTYPE plist PUBLIC "-//Apple Inc//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
00000135	4.39786386	[1960] <plist version="1.0">
00000136	4.39786386	[1960] <dict>
00000137	4.39786386	[1960] <key>PayloadContent</key>
00000138	4.39786386	[1960] <array>
00000139	4.39786386	[1960]  <dict>
00000140	4.39786386	[1960]  <key>PayloadContent</key>
00000141	4.39786386	[1960]  <dict>
00000142	4.39786386	[1960]  <key>Challenge</key>
00000143	4.39786386	[1960]  <string>116113a8f8dad3e44aa97e0a419c3627cfd672a5</string>
00000144	4.39786386	[1960]  <key>Key Type</key>
00000145	4.39786386	[1960]  <string>RSA</string>
00000146	4.39786386	[1960]  <key>Key Usage</key>
00000147	4.39786386	[1960]  <integer>5</integer>
00000148	4.39786386	[1960]  <key>Keysize</key>
00000149	4.39786386	[1960]  <integer>2048</integer>
00000150	4.39786386	[1960]  <key>Name</key>
00000151	4.39786386	[1960]  <string>ServPro-SERVPRO66-CA</string>
00000152	4.39786386	[1960]  <key>GetCACaps</key>
00000153	4.39786386	[1960]   <array>
00000154	4.39786386	[1960]  <string>GETPKIOperation</string>
00000155	4.39786386	[1960]  <string>Renewal</string>
00000156	4.39786386	[1960]  <string>SHA-1</string>
00000157	4.39786386	[1960]   </array>
00000158	4.39786386	[1960]  <key>Subject</key>
00000159	4.39786386	[1960]  <array>
00000160	4.39786386	[1960]   <array>
00000161	4.39786386	[1960]    <array>
00000162	4.39786386	[1960]     <string>O</string>
00000163	4.39786386	[1960]     <string>AfariaMdmEnrollment</string>
00000164	4.39786386	[1960]    </array>
00000165	4.39786386	[1960]   </array>
00000166	4.39786386	[1960]   <array>
00000167	4.39786386	[1960]    <array>
00000168	4.39786386	[1960]     <string>C</string>
00000169	4.39786386	[1960]     <string>IN</string>
00000170	4.39786386	[1960]    </array>
00000171	4.39786386	[1960]   </array>
00000172	4.39786386	[1960]   <array>
00000173	4.39786386	[1960]    <array>
00000174	4.39786386	[1960]     <string>CN</string>
00000175	4.39786386	[1960]     <string>116113a8f8dad3e44aa97e0a419c3627cfd672a5</string>
00000176	4.39786386	[1960]    </array>
00000177	4.39786386	[1960]    </array>
00000178	4.39786386	[1960]   </array>
00000179	4.39786386	[1960]   <key>URL</key>
00000180	4.39786386	[1960]   <string>http://servpro70.servpro.in:80/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc/s...</string>
00000181	4.39786386	[1960]  </dict>
00000182	4.39786386	[1960]  <key>PayloadDescription</key>
00000183	4.39786386	[1960]  <string>mdmSCEP-116113a8f8dad3e44aa97e0a419c3627cfd672a5</string>
00000184	4.39786386	[1960]  <key>PayloadDisplayName</key>
00000185	4.39786386	[1960]  <string>mdmSCEP-116113a8f8dad3e44aa97e0a419c3627cfd672a5</string>
00000186	4.39786386	[1960]  <key>PayloadIdentifier</key>
00000187	4.39786386	[1960]  <string>Sybase - iAnywhere</string>
00000188	4.39786386	[1960]  <key>PayloadOrganization</key>
00000189	4.39786386	[1960]  <string>Sybase - iAnywhere</string>
00000190	4.39786386	[1960]  <key>PayloadType</key>
00000191	4.39786386	[1960]  <string>com.apple.security.scep</string>
00000192	4.39786386	[1960]  <key>PayloadUUID</key>
00000193	4.39786386	[1960]  <string>3e7f6190-9875-470b-bd05-fea5881967c6</string>
00000194	4.39786386	[1960]  <key>PayloadVersion</key>
00000195	4.39786386	[1960]  <integer>1</integer>
00000196	4.39786386	[1960]  </dict>
00000197	4.39786386	[1960]   <dict>
00000198	4.39786386	[1960]    <key>IdentityCertificateUUID</key>
00000199	4.39786386	[1960]    <string>3e7f6190-9875-470b-bd05-fea5881967c6</string>
00000200	4.39786386	[1960]    <key>Topic</key>
00000201	4.39786386	[1960]    <string>com.apple.mgmt.External.214eb693-942e-4c60-b634-cf0f6dd6160e</string>
00000202	4.39786386	[1960]    <key>ServerURL</key>
00000203	4.39786386	[1960]    <string>https://servpro70.servpro.in:443/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc...</string>
00000204	4.39786386	[1960]    <key>CheckInURL</key>
00000205	4.39786386	[1960]    <string>https://servpro70.servpro.in:443/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc...</string>
00000206	4.39786386	[1960]    <key>SignMessage</key>
00000207	4.39786386	[1960]    <true/>
00000208	4.39786386	[1960]    <key>AccessRights</key>
00000209	4.39786386	[1960]    <integer>8191</integer>
00000210	4.39786386	[1960]    <key>CheckOutWhenRemoved</key>
00000211	4.39786386	[1960]    <true/>
00000212	4.39786386	[1960]    <key>UseDevelopmentAPNS</key>
00000213	4.39786386	[1960]    <false/>
00000214	4.39786386	[1960]    <key>PayloadType</key>
00000215	4.39786386	[1960]    <string>com.apple.mdm</string>
00000216	4.39786386	[1960]    <key>PayloadDescription</key>
00000217	4.39786386	[1960]    <string>mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5</string>
00000218	4.39786386	[1960]    <key>PayloadDisplayName</key>
00000219	4.39786386	[1960]    <string>mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5</string>
00000220	4.39786386	[1960]    <key>PayloadIdentifier</key>
00000221	4.39786386	[1960]    <string>Sybase - iAnywhere</string>
00000222	4.39786386	[1960]    <key>PayloadOrganization</key>
00000223	4.39786386	[1960]    <string>Sybase - iAnywhere</string>
00000224	4.39786386	[1960]    <key>PayloadUUID</key>
00000225	4.39786386	[1960]    <string>9cdcbc66-9422-44d3-bc3c-9b7e378d9e1c</string>
00000226	4.39786386	[1960]    <key>PayloadVersion</key>
00000227	4.39786386	[1960]    <integer>1</integer>
00000228	4.39786386	[1960]   </dict>
00000229	4.39786386	[1960]   <dict>
00000230	4.39786386	[1960]   <key>PayloadCertificateFileName</key>
00000231	4.39786386	[1960]   <string></string>
00000232	4.39786386	[1960]   <key>PayloadContent</key>
00000233	4.39786386	[1960]   <data>
00000234	4.39786386	[1960] MIIDizCCAnOgAwIBAgIQQFqpP6YTg59J3MO6GZPxEzANBgkqhkiG9w0BAQUFADBMMRIwEAYKCZIm
00000235	4.39786386	[1960] iZPyLGQBGRYCaW4xFzAVBgoJkiaJk/IsZAEZFgdTZXJ2UHJvMR0wGwYDVQQDExRTZXJ2UHJvLVNF
00000236	4.39786386	[1960] UlZQUk82Ni1DQTAeFw0xNDAxMDIxMzIzNTRaFw0xOTAxMDIxMzMzNTBaMEwxEjAQBgoJkiaJk/Is
00000237	4.39786386	[1960] ZAEZFgJpbjEXMBUGCgmSJomT8ixkARkWB1NlcnZQcm8xHTAbBgNVBAMTFFNlcnZQcm8tU0VS
00000238	4.39833879	[1960] VlBS
00000239	4.39833879	[1960] TzY2LUNBMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAr+zGISN7p8QN6aEyPmV9isDn
00000240	4.39833879	[1960] F5nm/cfctDh3/jnf0Ha5YXLGfRohlFP0ccOA9iyx7eZ8MMyMWfukNUW3QmCyJeQKpRC32q0ue8rC
00000241	4.39833879	[1960] KE5Qo54DAag0s7AS8mLaWY1K5jw+nkiyPXkUbXW6gCu3r+XINO558yx+9RQ+lyVnsMihLA3XttBe
00000242	4.39833879	[1960] eNETtjLsT/sPsOBctX1/2ThgehMDrpH06uWVZqTZq4M+jTvIg3dy4DczZZ3tVD94E1zH+Zz+ZJRW
00000243	4.39833879	[1960] JI+q0fL9jBq+pnAU8zte8TGkezi4FH96jlg4xCC9pb/fLO+zxp5eLGf/M+0wBcDH8IkZWo41eWrs
00000244	4.39833879	[1960] JtNAO522M3BuewIDAQABo2kwZzATBgkrBgEEAYI3FAIEBh4EAEMAQTAOBgNVHQ8BAf8EBAMCAYYw
00000245	4.39833879	[1960] DwYDVR0TAQH/BAUwAwEB/zAdBgNVHQ4EFgQU2VC/vYfXmb2vPu96YGKXWpXC0N0wEAYJKwYBBAGC
00000246	4.39833879	[1960] NxUBBAMCAQAwDQYJKoZIhvcNAQEFBQADggEBAKDRTHpbzcgio5gmOTZOWXtQpbeWaJw8/ujZ9d6i
00000247	4.39833879	[1960] FfayOUidiO1JFJEyFjGPgTdIV2dEaTT+46yJ1OLGtnbN4VZzXtEPQ4pCWhdKRyAFfnR3zlrAIUTy
00000248	4.39833879	[1960] BTRdvrPFhpclBO/zWX5BQhiewfluEzaX6UgYVepC1VoIJP6PWzDRBLpRGP8P0N2VfvTg20rNzQSS
00000249	4.39833879	[1960] V8O9UO8nuaa5tkGdoPqzL07xNEBrnAPOkGrZPr4TbEwINKDMjlDap2E8exHk+/qMsA+SaYbdEku2
00000250	4.39833879	[1960] k0VLLQqDkT4LRVnLp7c7eXe5JexP2+7KAkehUia9kjguDgCb9PPswRXwxeQmIiLRfmEI07GEYT4=
00000251	4.39833879	[1960]   </data>
00000252	4.39833879	[1960]   <key>PayloadDescription</key>
00000253	4.39833879	[1960]   <string>Provides SSL cert chain.</string>
00000254	4.39833879	[1960]   <key>PayloadDisplayName</key>
00000255	4.39833879	[1960]   <string>servpro70.servpro.in</string>
00000256	4.39833879	[1960]   <key>PayloadIdentifier</key>
00000257	4.39833879	[1960]   <string>com.servpro70.servpro.in.SetupSslCertChain</string>
00000258	4.39833879	[1960]   <key>PayloadOrganization</key>
00000259	4.39833879	[1960]   <string>Sybase - Configure</string>
00000260	4.39833879	[1960]   <key>PayloadType</key>
00000261	4.39833879	[1960]   <string>com.apple.security.root</string>
00000262	4.39833879	[1960]   <key>PayloadUUID</key>
00000263	4.39833879	[1960]   <string>070bf19d-1022-4c89-926a-812a8857e010</string>
00000264	4.39833879	[1960]   <key>PayloadVersion</key>
00000265	4.39833879	[1960]   <integer>1</integer>
00000266	4.39833879	[1960]   </dict>
00000267	4.39833879	[1960]  </array>
00000268	4.39833879	[1960]  <key>PayloadDescription</key>
00000269	4.39833879	[1960]    <string>mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5</string>
00000270	4.39833879	[1960]  <key>PayloadDisplayName</key>
00000271	4.39833879	[1960]    <string>mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5</string>
00000272	4.39833879	[1960]  <key>PayloadIdentifier</key>
00000273	4.39833879	[1960]  <string>Sybase - iAnywhere</string>
00000274	4.39833879	[1960]  <key>PayloadOrganization</key>
00000275	4.39833879	[1960]  <string>Sybase - iAnywhere</string>
00000276	4.39833879	[1960]  <key>PayloadRemovalDisallowed</key>
00000277	4.39833879	[1960]  <false/>
00000278	4.39833879	[1960]  <key>PayloadType</key>
00000279	4.39833879	[1960]  <string>Configuration</string>
00000280	4.39833879	[1960]  <key>PayloadUUID</key>
00000281	4.39833879	[1960]    <string>47985676-dcba-479a-94ba-8bd53f842eac</string>
00000282	4.39833879	[1960]  <key>PayloadVersion</key>
00000283	4.39833879	[1960]  <integer>1</integer>
00000284	4.39833879	[1960] </dict>
00000285	4.39833879	[1960] </plist>
00000286	4.39833879	[1960]
00000287	4.39946890	[1960] thread:26 time: 2014/11/03 17:44:39 <SQL SetCertificateAndGetPolicies: Select * from A_IPHONE_DEVICE where ClientUID=@cwe_ClientUID  << SetCertificateAndGetPolicies.SetCertificateAndGetPolicies.UpdateSignMdmMessages, Params: 246
00000288	4.40002155	[1960] thread:26 time: 2014/11/03 17:44:39 <SQL SetCertificateAndGetPolicies: Update A_IPHONE_DEVICE Set SignMdmMessages=@cwe_SignMdmMessages Where ClientUID=@cwe_ClientUID << SetCertificateAndGetPolicies.SetCertificateAndGetPolicies.UpdateSignMdmMessages, Params: 10, 246
00000289	4.41610670	[1960] thread:26 time: 2014/11/03 17:44:39 OTA delivery of Mdm Configuration Profile.
00000290	4.41654348	[1960] thread:26 time: 2014/11/03 17:44:39 SetCertificateAndGetPolicies Connection Log Entry:
00000291	4.41654348	[1960]   DeviceTableID: 246
00000292	4.41654348	[1960]   Action: Mdm Provisioned.
00000293	4.41654348	[1960]   Data: CN = 116113A8F8DAD3E44AA97E0A419C3627CFD672A5
00000294	4.41675329	[1960] thread:26 time: 2014/11/03 17:44:39 <SQL LogConnectionState: insert into A_IPHONE_LOG ( ClientUID, TimeStamp, Action, Data, ConnectionID ) values (@cwe_ClientUID, @cwe_TimeStamp, @cwe_Action, @cwe_Data, @cwe_ConnectionID) << LogConnectionState.connectionLogInsert, Params: 246, 11/3/2014 5:44:39 PM, Mdm Provisioned., CN = 116113A8F8DAD3E44AA97E0A419C3627CFD672A5, {6e80d0f6-329b-4850-8859-f474227d4a85}
00000295	4.42407608	[1960] thread:26 time: 2014/11/03 17:44:39  RunSQL return <<connectionLogInsert
00000296	4.42423153	[1960] thread:26 time: 2014/11/03 17:44:39 <SQL SetCertificateAndGetPolicies: Select * From A_IPHONE_PAYLOADTYPE << SetCertificateAndGetPolicies.PayloadTypeInfo
00000297	4.42527056	[1960] thread:26 time: 2014/11/03 17:44:39  RunSQL return <<PayloadTypeInfo
00000298	4.42538309	[1960] thread:26 time: 2014/11/03 17:44:39  update IPhoneSCEPEnrollRequestInfo
00000299	4.42553759	[1960] thread:26 time: 2014/11/03 17:44:39
00000300	4.42553759	[1960]  >>> getScepUriCrqInfoAndSigningCertName entry
00000301	4.42924309	[1960] thread:26 time: 2014/11/03 17:44:39
00000302	4.42924309	[1960]  >>> getScepUriCrqInfoAndSigningCertName exit
00000303	4.42934179	[1960] thread:26 time: 2014/11/03 17:44:39 CaName: ServPro-SERVPRO66-CA
00000304	4.42942333	[1960] thread:26 time: 2014/11/03 17:44:39 CommonName:
00000305	4.42950821	[1960] thread:26 time: 2014/11/03 17:44:39 OrganizationName:
00000306	4.42983198	[1960] thread:26 time: 2014/11/03 17:44:39 OrganizationUnit:
00000307	4.42991209	[1960] thread:26 time: 2014/11/03 17:44:39 City:
00000308	4.42999458	[1960] thread:26 time: 2014/11/03 17:44:39 State:
00000309	4.43035412	[1960] thread:26 time: 2014/11/03 17:44:39 Country: IN
00000310	4.43055630	[1960] thread:26 time: 2014/11/03 17:44:39  update IPhoneDatabaseRow
00000311	4.43072176	[1960] thread:26 time: 2014/11/03 17:44:39 <SQL SetCertificateAndGetPolicies: Select * From A_IPHONE_SETTINGS Where TenantID=@cwe_TenantID << SetCertificateAndGetPolicies.setCertAndGetPolicySigingCertQuery, Params: 0
00000312	4.43185997	[1960] thread:26 time: 2014/11/03 17:44:39  RunSQL return <<setCertAndGetPolicySigingCertQuery
00000313	4.43196392	[1960] thread:26 time: 2014/11/03 17:44:39 SetCertificateAndGetPolicies - no cert no encryption -disabling EncryptPayload
00000314	4.43277168	[1960] thread:26 time: 2014/11/03 17:44:39
00000315	4.43277168	[1960]  >>> IPhoneConfigs SetCertificateAndGetPolicies exit
00000316	12.07697487	[1960]  lookup Id: {67d95b09-f47d-4dc8-acd8-c9a842e8e5fc}
00000317	12.88707447	[1960] thread:26 time: 2014/11/03 17:44:47
00000318	12.88707447	[1960]  >>> LogMessage exit
00000319	12.90988350	[1960] thread:26 time: 2014/11/03 17:44:47
00000320	12.90988350	[1960]  >>> LogMessage exit
00000321	53.69062424	[1960] thread:7 time: 2014/11/03 17:45:28 <SQL performDeferredDelivery: select * from A_IPHONE_DEFERRED_DELIVERY << performDeferredDelivery.getDeferredDeliveryQuery
00000322	53.69834900	[1960] thread:7 time: 2014/11/03 17:45:28  RunQuery return <<getDeferredDeliveryQuery
00000323	53.69972610	[1960] thread:7 time: 2014/11/03 17:45:28 performDeferredDelivery.DeferredDelivery[0]
00000324	53.70165253	[1960] thread:7 time: 2014/11/03 17:45:28 performDeferredDelivery done at 11/3/2014 5:45:28 PM

[Former Member]

device logs_iOS:

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: [DataSender connection:didReceiveResponse:]

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: httpResponse.allHeaderField Dictionary: {

     "Cache-Control" = private;

     "Content-Length" = 366;

     "Content-Type" = "text/xml";

     Date = "Mon, 03 Nov 2014 12:14:10 GMT";

     Server = "Microsoft-IIS/7.5, Microsoft-IIS/7.5";

     "X-AspNet-Version" = "4.0.30319";

     "X-Powered-By" = "ASP.NET, ASP.NET";

  }

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: connection:didReceiveResponse: http 200

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: [DataSender connection:didReceiveData:]

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: [DataSender connectionDidFinishLoading:]

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: HTTP code: 200, Received 366 bytes of data

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: [AipsController updateLastConnection]

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: [AipsController setStatusLine:"Verification complete"]

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: [AfariaAppDelegate netUser:0x1 busy:0]

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: [DataSender processResponse]

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: UIDevice.getUDID > 116113a8f8dad3e44aa97e0a419c3627cfd672a5

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: parser:didStartElement:root

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: NitroDesk URL = http://servpro70.servpro.in:80/ias_relay_server/client/rs_client.dll/ios-farm/aips/aipService.svc/Ge...? UDID=116113a8f8dad3e44aa97e0a419c3627cfd672a5

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: [AfariaAppDelegate netUser:0x1000 busy:1]

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: parser:didStartElement:ClientSeedInfo

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: parser:didStartElement:PackageServerAddress

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: parser:didEndElement:PackageServerAddress

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: parser:didStartElement:PackageServerVirtDir

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: parser:didEndElement:PackageServerVirtDir

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: parser:didStartElement:PackageServerAuthVirtDir

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: parser:didEndElement:PackageServerAuthVirtDir

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: parser:didStartElement:DeviceUDID

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: parser:didEndElement:DeviceUDID

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: parser:didEndElement:ClientSeedInfo

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: parser:didStartElement:TEMSettings

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: parser:didEndElement:TEMSettings

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: parser:didEndElement:root

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: didParsePackageServerAddress:"https://servpro70.servpro.in:443/ias_relay_server/client/rs_client.dll/portal-farm" virtDir:"ps" authVirtDir:"ps2" UDID:"116113a8f8dad3e44aa97e0a419c3627cfd672a5" WiFiMAC:"(null)"

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: handlePackageServerInfo:

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: handlePackageServerInfo: address="https://servpro70.servpro.in:443/ias_relay_server/client/rs_client.dll/portal-farm" virtDir="ps" authVirtDir="ps2"

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: UIDevice.setUDID > 116113a8f8dad3e44aa97e0a419c3627cfd672a5 match - redundant ok.

Nov  3 17:41:00 ServPRO-iPhone-4S Afaria[251] <Warning>: seedPS: ConnectionParams server="servpro70.servpro.in" port="443" protocol="https" farmID="portal-farm" urlPrefix="/ias_relay_server/client/rs_client.dll/%cid%" virtualDirectory="ps"  authVirtualDirectory="ps2"

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: connection:didReceiveResponse:

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: httpResponse.allHeaderField Dictionary: {

     "Cache-Control" = private;

     "Content-Length" = 66;

     "Content-Type" = "application/xml; charset=utf-8";

     Date = "Mon, 03 Nov 2014 12:14:12 GMT";

     "IAS-RS-Set-Cookie" = "ias-rs-sessionid=\"DgSlvnEAAAACAAAAcG9ydGFsLXNlcnZlcgA=\";";

     Server = "Microsoft-IIS/7.5, Microsoft-IIS/7.5";

     "Set-Cookie" = "ias-rs-sessionid=\"DgSlvnEAAAACAAAAcG9ydGFsLXNlcnZlcgA=\";";

     "X-AspNet-Version" = "4.0.30319";

     "X-Powered-By" = "ASP.NET, ASP.NET";

  }

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: connection:didReceiveResponse: http 200

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: connection:didReceiveData:

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: connectionDidFinishLoading:

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: [AfariaAppDelegate netUser:0x2 busy:0]

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: Succeeded: Received 66 bytes of data

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: didFinishParsing:

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: NitroDesk didRecieveData

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: NitroDeskDownloader.connectionDidFinishLoading start.

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: [AfariaAppDelegate netUser:0x1000 busy:0]

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: nitro desk xml <NitroDesk>

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: NitroDeskXML didStartDocument

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: NitroDeskXML didStartElement: NitroDesk

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: NitroDesk XMLParser error: The operation couldn’t be completed. (NSXMLParserErrorDomain error 5.)

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: Failed to parser NitroDeskXML

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: [AipsController NitroDeskDidFailToLoad]

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: [AipsController doMdmRedirect]

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: AppListViewControllerProtocol protocol -> appListDidLoad

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>:

  NUMBER OF ALL CATEGORIES> 2

  NUMBER OF CATEGORIES PER PAGE> 2

  NUMBER OF PAGES SHOULD BE> 1.000000

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: doSearch

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: [AfariaAppDelegate callbackSeedingViewController]

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: UIDevice.getUDID > 116113a8f8dad3e44aa97e0a419c3627cfd672a5

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: [AfariaAppDelegate.updateAppListRefreshTime: 2014-11-03 12:10:49 +0000]

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: [AfariaAppDelegate.updateAppListRefreshTime: 2014-11-03 12:11:01 +0000]

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: attempting redirect: http://servpro70.servpro.in:80/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc/S...

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: UIDevice.getUDID > 116113a8f8dad3e44aa97e0a419c3627cfd672a5

Nov  3 17:41:01 ServPRO-iPhone-4S kernel[0] <Debug>: launchd[252] Container: /private/var/mobile/Applications/3D8E241F-9CDC-467D-B3D4-EB638868BB1C (sandbox)

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: [AfariaAppDelegate alertView:<AFAlertWrapper: 0x14e8b610; baseClass = UIAlertView; frame = (18 219; 284 62); opaque = NO; layer = <CALayer: 0x14e4ff00>> didDismissWithButtonIndex:0]

Nov  3 17:41:01 ServPRO-iPhone-4S Afaria[251] <Warning>: loggingAlert dismissed with button 0

Nov  3 17:41:01 ServPRO-iPhone-4S backboardd[28] <Error>: HID: The 'Passive' connection 'MobileSafari' access to protected services is denied.

Nov  3 17:41:02 ServPRO-iPhone-4S Afaria[251] <Warning>: [AfariaAppDelegate applicationWillResignActive:]

Nov  3 17:41:02 ServPRO-iPhone-4S Afaria[251] <Warning>: [AfariaAppDelegate applicationDidEnterBackground:]

Nov  3 17:41:02 ServPRO-iPhone-4S Afaria[251] <Warning>: AppListViewControllerProtocol protocol -> resetImageDownloads

Nov  3 17:41:02 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709462.430996]: Foreground Network Application entered.

Nov  3 17:41:02 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709462.431701]: BG Application: Not Present, BG Daemon: Present. Daemons: apsd networkd lockdownd

Nov  3 17:41:02 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709462.433286]: problematic networks =  and potentially problematic networks =

Nov  3 17:41:02 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709462.433838]: Unblacklisting

Nov  3 17:41:02 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709462.434742]: No change in Background Scan candidates. Skip re-programming Background Scan

Nov  3 17:41:02 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709462.435647]: Already connected to ServPRO.

Nov  3 17:41:02 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709462.501588]:

Nov  3 17:41:02 ServPRO-iPhone-4S wifid[15] <Notice>: Too frequent(4.682950 secs) rssi event from driver

Nov  3 17:41:02 ServPRO-iPhone-4S wifid[15] <Notice>:

Nov  3 17:41:02 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709462.833521]:

Nov  3 17:41:02 ServPRO-iPhone-4S wifid[15] <Notice>: Too frequent(0.331933 secs) rssi event from driver, ignoring

Nov  3 17:41:02 ServPRO-iPhone-4S wifid[15] <Notice>:

Nov  3 17:41:04 ServPRO-iPhone-4S profiled[253] <Notice>: (Note ) profiled: Service starting...

Nov  3 17:41:04 ServPRO-iPhone-4S profiled[253] <Notice>: (Note ) MC: Profile “Sybase - iAnywhere” queued for installation.

Nov  3 17:41:04 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709464.459349]: Foreground Network Application exited.

Nov  3 17:41:04 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709464.460029]: BG Application: Not Present, BG Daemon: Present. Daemons: apsd networkd lockdownd

Nov  3 17:41:04 ServPRO-iPhone-4S backboardd[28] <Error>: HID: The 'Passive' connection 'Preferences' access to protected services is denied.

Nov  3 17:41:05 ServPRO-iPhone-4S Preferences[255] <Warning>: BTM: attaching to BTServer

Nov  3 17:41:07 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709467.840336]:

Nov  3 17:41:07 ServPRO-iPhone-4S wifid[15] <Notice>: Too frequent(0.228547 secs) rssi event from driver, ignoring

Nov  3 17:41:07 ServPRO-iPhone-4S wifid[15] <Notice>:

Nov  3 17:41:11 ServPRO-iPhone-4S medialibraryd[97] <Warning>: {MediaLibrary} [MediaLibraryService] Cancelling any active or suspended import operations in progress for process atc (process ID = 246)

Nov  3 17:41:11 ServPRO-iPhone-4S medialibraryd[97] <Warning>: {MediaLibrary} [MLWriter] Cleaning up any remaining transactions for ended process <unknown process> (process ID = 246)

Nov  3 17:41:12 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709472.847659]:

Nov  3 17:41:12 ServPRO-iPhone-4S wifid[15] <Notice>: Too frequent(0.090557 secs) rssi event from driver, ignoring

Nov  3 17:41:12 ServPRO-iPhone-4S wifid[15] <Notice>:

Nov  3 17:41:15 ServPRO-iPhone-4S profiled[253] <Notice>: (Note ) profiled: Service stopping.

Nov  3 17:41:17 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709477.879099]:

Nov  3 17:41:17 ServPRO-iPhone-4S wifid[15] <Notice>: Too frequent(0.002419 secs) rssi event from driver, ignoring

Nov  3 17:41:17 ServPRO-iPhone-4S wifid[15] <Notice>:

Nov  3 17:41:23 ServPRO-iPhone-4S profiled[256] <Notice>: (Note ) profiled: Service starting...

Nov  3 17:41:23 ServPRO-iPhone-4S profiled[256] <Notice>: (Note ) MC: Checking for MDM installation...

Nov  3 17:41:23 ServPRO-iPhone-4S profiled[256] <Notice>: (Note ) MC: ...finished checking for MDM installation.

Nov  3 17:41:23 ServPRO-iPhone-4S backboardd[28] <Error>: HID: The 'Rate Controlled' connection 'Preferences' access to protected services is denied.

Nov  3 17:41:24 ServPRO-iPhone-4S profiled[256] <Notice>: (Note ) MC: Enrolling in OTA Profile service...

Nov  3 17:41:28 ServPRO-iPhone-4S profiled[256] <Notice>: (Note ) MC: Attempting to retrieve issued certificate...

Nov  3 17:41:29 ServPRO-iPhone-4S profiled[256] <Notice>: (Note ) MC: Issued certificate received.

Nov  3 17:41:29 ServPRO-iPhone-4S profiled[256] <Notice>: (Note ) MC: Retrieving profile from OTA Profile service...

Nov  3 17:41:30 ServPRO-iPhone-4S profiled[256] <Notice>: (Note ) MC: Received final profile: Sybase - iAnywhere

Nov  3 17:41:30 ServPRO-iPhone-4S profiled[256] <Notice>: (Note ) MC: Beginning profile installation...

Nov  3 17:41:31 ServPRO-iPhone-4S profiled[256] <Error>: MKBDeviceLockAssertion: MKBDeviceLockAssertion (asserttype:3)

Nov  3 17:41:31 ServPRO-iPhone-4S securityd[86] <Error>:  SecDbItemInsertOrReplace INSERT failed: The operation couldn’t be completed. (com.apple.utilities.sqlite3 error 19 - reset: [19] columns ctyp, issr, slnr, agrp, sync are not unique sql: INSERT INTO cert(rowid,cdat,mdat,ctyp,cenc,labl,alis,subj,issr,slnr,skid,pkhh,data,agrp,pdmn,sync,tomb,sha1)VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?))

Nov  3 17:41:31 ServPRO-iPhone-4S securityd[86] <Error>:  securityd_xpc_dictionary_handler profiled[256] add The operation couldn’t be completed. (OSStatus error -25299 - duplicate item O,cert,AE250001,L,dku,com.apple.certificates,0,ctyp,cenc,labl,subj,issr,slnr,skid,pkhh,v_Data,20141103121131.811269Z,1A0E6D46)

Nov  3 17:41:31 ServPRO-iPhone-4S profiled[256] <Error>:  SecOSStatusWith error:[-25299] The operation couldn’t be completed. (OSStatus error -25299 - Remote error : The operation couldn’t be completed. (OSStatus error -25299 - duplicate item O,cert,AE250001,L,dku,com.apple.certificates,0,ctyp,cenc,labl,subj,issr,slnr,skid,pkhh,v_Data,20141103121131.811269Z,1A0E6D46))

Nov  3 17:41:36 ServPRO-iPhone-4S securityd[86] <Error>:  SecDbItemInsertOrReplace INSERT failed: The operation couldn’t be completed. (com.apple.utilities.sqlite3 error 19 - reset: [19] columns ctyp, issr, slnr, agrp, sync are not unique sql: INSERT INTO cert(rowid,cdat,mdat,ctyp,cenc,labl,alis,subj,issr,slnr,skid,pkhh,data,agrp,pdmn,sync,tomb,sha1)VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?))

Nov  3 17:41:36 ServPRO-iPhone-4S securityd[86] <Error>:  securityd_xpc_dictionary_handler profiled[256] add The operation couldn’t be completed. (OSStatus error -25299 - duplicate item O,cert,CA6E7F0E,L,dku,com.apple.certificates,0,ctyp,cenc,labl,subj,issr,slnr,pkhh,v_Data,20141103121136.830564Z,45279928)

Nov  3 17:41:36 ServPRO-iPhone-4S profiled[256] <Error>:  SecOSStatusWith error:[-25299] The operation couldn’t be completed. (OSStatus error -25299 - Remote error : The operation couldn’t be completed. (OSStatus error -25299 - duplicate item O,cert,CA6E7F0E,L,dku,com.apple.certificates,0,ctyp,cenc,labl,subj,issr,slnr,pkhh,v_Data,20141103121136.830564Z,45279928))

Nov  3 17:41:37 ServPRO-iPhone-4S profiled[256] <Notice>: (Note ) MC: Attempting to retrieve issued certificate...

Nov  3 17:41:37 ServPRO-iPhone-4S profiled[256] <Notice>: (Note ) MC: Issued certificate received.

Nov  3 17:41:38 ServPRO-iPhone-4S profiled[256] <Notice>: (Error) MDM: Cannot Authenticate. Error: NSError:

  Desc   : A connection to the server could not be established.

  US Desc: A connection to the server could not be established.

  Domain : MCHTTPTransactionErrorDomain

  Code   : 23001

  Type   : MCFatalError

  Params : (

     "https://servpro70.servpro.in:443/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc...",

     406

  )

Nov  3 17:41:38 ServPRO-iPhone-4S profiled[256] <Notice>: (Error) MC: Cannot install MDM “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5”. Error: NSError:

  Desc   : The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5” could not be installed.

  Sugg   : A connection to the server could not be established.

  US Desc: The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5” could not be installed.

  US Sugg: A connection to the server could not be established.

  Domain : MCInstallationErrorDomain

  Code   : 4001

  Type   : MCFatalError

  Params : (

     "mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5"

  )

  ...Underlying error:

  NSError:

  Desc   : A connection to the server could not be established.

  US Desc: A connection to the server could not be established.

  Domain : MCHTTPTransactionErrorDomain

  Code   : 23001

  Type   : MCFatalError

  Params : (

     "https://servpro70.servpro.in:443/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc...",

     406

  )

Nov  3 17:41:38 ServPRO-iPhone-4S profiled[256] <Notice>: (Error) MC: Rolling back installation of profile “Sybase - iAnywhere”...

Nov  3 17:41:38 ServPRO-iPhone-4S profiled[256] <Notice>: (Error) MC: Installation of profile “Sybase - iAnywhere” failed with error: NSError:

  Desc   : The profile “Config Payload” could not be installed.

  Sugg   : The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5” could not be installed.

  US Desc: The profile “Config Payload” could not be installed.

  US Sugg: The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5” could not be installed.

  Domain : MCProfileErrorDomain

  Code   : 1009

  Type   : MCFatalError

  Params : (

     "Config Payload"

  )

  ...Underlying error:

  NSError:

  Desc   : The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5” could not be installed.

  Sugg   : A connection to the server could not be established.

  US Desc: The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5” could not be installed.

  US Sugg: A connection to the server could not be established.

  Domain : MCInstallationErrorDomain

  Code   : 4001

  Type   : MCFatalError

  Params : (

     "mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5"

  )

  ...Underlying error:

  NSError:

  Desc   : A connection to the server could not be established.

  US Desc: A connection to the server could not be established.

  Domain : MCHTTPTransactionErrorDomain

  Code   : 23001

  Type   : MCFatalError

  Params : (

     "https://servpro70.servpro.in:443/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc...",

     406

  )

Nov  3 17:41:38 ServPRO-iPhone-4S profiled[256] <Notice>: (Error) MC: Profile “Sybase - iAnywhere” failed to install with error: NSError:

  Desc   : Profile Failed to Install

  Sugg   : The profile “Config Payload” could not be installed.

  US Desc: Profile Failed to Install

  US Sugg: The profile “Config Payload” could not be installed.

  Domain : MCInstallationErrorDomain

  Code   : 4001

  Type   : MCFatalError

  ...Underlying error:

  NSError:

  Desc   : The profile “Config Payload” could not be installed.

  Sugg   : The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5” could not be installed.

  US Desc: The profile “Config Payload” could not be installed.

  US Sugg: The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5” could not be installed.

  Domain : MCProfileErrorDomain

  Code   : 1009

  Type   : MCFatalError

  Params : (

     "Config Payload"

  )

  ...Underlying error:

  NSError:

  Desc   : The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5” could not be installed.

  Sugg   : A connection to the server could not be established.

  US Desc: The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5” could not be installed.

  US Sugg: A connection to the server could not be established.

  Domain : MCInstallationErrorDomain

  Code   : 4001

  Type   : MCFatalError

  Params : (

     "mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5"

  )

  ...Underlying error:

  NSError:

  Desc   : A connection to the server could not be established.

  US Desc: A connection to the server could not be established.

  Domain : MCHTTPTransactionErrorDomain

  Code   : 23001

  Type   : MCFatalError

  Params : (

     "https://servpro70.servpro.in:443/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc...",

     406

  )

Nov  3 17:41:38 ServPRO-iPhone-4S profiled[256] <Notice>: (Note ) MC: Removing certificate with persistent ID 69646e740000000000000335

Nov  3 17:41:38 ServPRO-iPhone-4S profiled[256] <Notice>: (Note ) MC: Removing certificate with persistent ID 69646e740000000000000336

Nov  3 17:41:38 ServPRO-iPhone-4S profiled[256] <Notice>: (Note ) MC: Removing certificate with persistent ID 69646e740000000000000333

Nov  3 17:41:38 ServPRO-iPhone-4S profiled[256] <Notice>: (Note ) MC: Removing certificate with persistent ID 636572740000000000000332

Nov  3 17:41:38 ServPRO-iPhone-4S profiled[256] <Notice>: (Note ) MC: Removing certificate with persistent ID 69646e740000000000000334

Nov  3 17:41:38 ServPRO-iPhone-4S Preferences[255] <Warning>: -[VPNConnectionStore reloadVPN]: The active VPN configuration has changed from (null) to (null)

Nov  3 17:41:38 ServPRO-iPhone-4S profiled[256] <Error>: __MKBAssertionFinalize: __MKBAssertionFinalize(0x1469fab0)

Nov  3 17:41:38 ServPRO-iPhone-4S profiled[256] <Notice>: (Error) MC: Installation failed. Error: NSError:

  Desc   : Profile Installation Failed

  Sugg   : Profile Failed to Install

  US Desc: Profile Installation Failed

  US Sugg: Profile Failed to Install

  Domain : MCInstallationErrorDomain

  Code   : 4001

  Type   : MCFatalError

  ...Underlying error:

  NSError:

  Desc   : Profile Failed to Install

  Sugg   : The profile “Config Payload” could not be installed.

  US Desc: Profile Failed to Install

  US Sugg: The profile “Config Payload” could not be installed.

  Domain : MCInstallationErrorDomain

  Code   : 4001

  Type   : MCFatalError

  ...Underlying error:

  NSError:

  Desc   : The profile “Config Payload” could not be installed.

  Sugg   : The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5” could not be installed.

  US Desc: The profile “Config Payload” could not be installed.

  US Sugg: The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5” could not be installed.

  Domain : MCProfileErrorDomain

  Code   : 1009

  Type   : MCFatalError

  Params : (

     "Config Payload"

  )

  ...Underlying error:

  NSError:

  Desc   : The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5” could not be installed.

  Sugg   : A connection to the server could not be established.

  US Desc: The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5” could not be installed.

  US Sugg: A connection to the server could not be established.

  Domain : MCInstallationErrorDomain

  Code   : 4001

  Type   : MCFatalError

  Params : (

     "mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5"

  )

  ...Underlying error:

  NSError:

  Desc   : A connection to the server could not be established.

  US Desc: A connection to the server could not be established.

  Domain : MCHTTPTransactionErrorDomain

  Code   : 23001

  Type   : MCFatalError

  Params : (

     "https://servpro70.servpro.in:443/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc...",

     406

  )

Nov  3 17:41:38 ServPRO-iPhone-4S Preferences[255] <Warning>: -[VPNBundleController _vpnConfigurationChanged:] (0x175824b0:<VPNBundleController: 0x175824b0>): _serviceCount(0), serviceCount(0), toggleInRootMenu(0), RootMenuItem(1)

Nov  3 17:41:41 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709501.507965]:

Nov  3 17:41:41 ServPRO-iPhone-4S wifid[15] <Notice>: Too frequent(3.550158 secs) rssi event from driver

Nov  3 17:41:41 ServPRO-iPhone-4S wifid[15] <Notice>:

Nov  3 17:41:42 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709502.990151]:

Nov  3 17:41:42 ServPRO-iPhone-4S wifid[15] <Notice>: Too frequent(1.482186 secs) rssi event from driver

Nov  3 17:41:42 ServPRO-iPhone-4S wifid[15] <Notice>:

Nov  3 17:41:44 ServPRO-iPhone-4S mstreamd[258] <Notice>: (Note ) mstreamd: mstreamd starting up.

Nov  3 17:41:44 ServPRO-iPhone-4S mstreamd[258] <Notice>: (Note ) PS: Media stream daemon starting...

Nov  3 17:41:44 ServPRO-iPhone-4S lockdownd[53] <Notice>: 002c1000 _select_socket: receive secure message timeout!

Nov  3 17:41:45 ServPRO-iPhone-4S mstreamd[258] <Notice>: (Note ) PS: MSPublisher - 476392424 Requesting derivatives for 1 files.

Nov  3 17:41:45 ServPRO-iPhone-4S awdd[259] <Error>: CoreLocation: CLClient is deprecated. Will be obsolete soon.

Nov  3 17:41:45 ServPRO-iPhone-4S mstreamd[258] <Notice>: (Note ) PS: MSPublisher - 476392424 Submitting 1 asset collections for publication.

Nov  3 17:41:45 ServPRO-iPhone-4S mstreamd[258] <Notice>: (Note ) PS: MSPublisher - 476392424 Sending metadata...

Nov  3 17:41:46 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709506.512994]: Background Network Application entered

Nov  3 17:41:46 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709506.513495]: BG Application: Present, BG Daemon: Present. Daemons: apsd networkd lockdownd

Nov  3 17:41:46 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709506.514286]: Already connected to ServPRO.

Nov  3 17:41:46 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709506.517528]: Background Network Application entered

Nov  3 17:41:46 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709506.517979]: BG Application: Not Present, BG Daemon: Present. Daemons: apsd networkd lockdownd

Nov  3 17:41:46 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709506.518975]: Already connected to ServPRO.

Nov  3 17:41:46 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709506.635574]:

Nov  3 17:41:46 ServPRO-iPhone-4S wifid[15] <Notice>: Too frequent(3.645423 secs) rssi event from driver

Nov  3 17:41:46 ServPRO-iPhone-4S wifid[15] <Notice>:

Nov  3 17:41:47 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436709507.996696]:

Nov  3 17:41:47 ServPRO-iPhone-4S wifid[15] <Notice>: Too frequent(1.361121 secs) rssi event from driver

Nov  3 17:41:47 ServPRO-iPhone-4S wifid[15] <Notice>:

Nov  3 17:41:48 ServPRO-iPhone-4S profiled[256] <Notice>: (Note ) profiled: Service stopping.

Nov  3 17:41:49 ServPRO-iPhone-4S mstreamd[258] <Notice>: (Note ) PS: MSPublisher - 476392424 uploading 1 assets...

[keith_nunn]

Tushar,

You're getting a 406 return code on the TokenCheckin.  Unfortunately, your debug log from the backend process doesn't show us any related errors.  So this may be the front end code that's returning the error.  To get frontend debug you have to uncomment the LogDebugInfo key line in the Web.config for the aips folder in the Enrollment Server's installation path.  It looks the same as the one you found in the AfariaiPhoneServer.exe.config but instead of being set to "no" by default it's just simply commented out. 

It looks like this (hoping SCN doesn't eat the HTML code): <!-- <add key="LogDebugInfo" value="yes"> -->  Just remove the commenting characters "<!--" and "-->", save the file and DebugView will then capture both frontend and backend. 

As a note, your logs have information about your environment which you may not wish to disclose.  Please be sure to review them before posting (as well as the ones you already posted) to see what information may be seen by anyone who visits the SCN.  If you are not comfortable with the information displayed, feel free to edit or remove it.

Thanks,

Keith Nunn
SAP Active Global Support
SAP Canada

[Former Member]

Below is the line from the AfariaIphoneServer.exe.config file. This was the same even when I collected the logs.

[keith_nunn]

Tushar,

Sorry for the confusion.  What I'm saying is that when you edit the Web.config, the LogDebugInfo line will look the same for both files, Web.config and AfariaiPhoneServer.exe.config.

---Web.config Example---

<appSettings>

  <!-- <add key ="StaticFilePath" value ="C:\tmp\aips"/> -->

  <add key="LogDebugInfo" value="yes"/>

</appSettings>

Also, be sure to make backup copies of the .config files before you edit to allow you to restore in case of a problem.

Thanks,

Keith Nunn
SAP Active Global Support
SAP Canada

[Former Member]

We have made changes on the web.config file. Yes we have backed it up.

Do you you want us to collect the logs from Debug view?

Thanks,

Tushar

[Former Member]

Please find the iOS device logs and DebugLog from the Enrollment server

**iOS_device log**


Nov  6 19:19:58 ServPRO-iPhone-4S profiled[270] <Notice>: (Note ) MC: Enrolling in OTA Profile service...
Nov  6 19:19:59 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436974599.058153]: 
Nov  6 19:19:59 ServPRO-iPhone-4S wifid[15] <Notice>: Too frequent(2.803958 secs) rssi event from driver
Nov  6 19:19:59 ServPRO-iPhone-4S wifid[15] <Notice>: 
Nov  6 19:20:01 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436974601.285275]: 
Nov  6 19:20:01 ServPRO-iPhone-4S wifid[15] <Notice>: Too frequent(2.227106 secs) rssi event from driver
Nov  6 19:20:01 ServPRO-iPhone-4S wifid[15] <Notice>: 
Nov  6 19:20:07 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436974607.350558]: 
Nov  6 19:20:07 ServPRO-iPhone-4S wifid[15] <Notice>: Too frequent(1.033848 secs) rssi event from driver
Nov  6 19:20:07 ServPRO-iPhone-4S wifid[15] <Notice>: 
Nov  6 19:20:07 ServPRO-iPhone-4S kernel[0] <Debug>: 008128.147097 wlan.A[2567] AppleBCMWLANNetManager::updateLinkQualityMetrics(): Report LQM to User Land 50, fAverageRSSI -71
Nov  6 19:20:08 ServPRO-iPhone-4S profiled[270] <Notice>: (Note ) MC: Attempting to retrieve issued certificate...
Nov  6 19:20:09 ServPRO-iPhone-4S profiled[270] <Notice>: (Note ) MC: Issued certificate received.
Nov  6 19:20:09 ServPRO-iPhone-4S profiled[270] <Notice>: (Note ) MC: Retrieving profile from OTA Profile service...
Nov  6 19:20:09 ServPRO-iPhone-4S profiled[270] <Notice>: (Note ) MC: Received final profile: Sybase - iAnywhere
Nov  6 19:20:09 ServPRO-iPhone-4S profiled[270] <Notice>: (Note ) MC: Beginning profile installation...
Nov  6 19:20:11 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436974611.348774]: 
Nov  6 19:20:11 ServPRO-iPhone-4S wifid[15] <Notice>: Too frequent(3.998214 secs) rssi event from driver
Nov  6 19:20:11 ServPRO-iPhone-4S wifid[15] <Notice>: 
Nov  6 19:20:12 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436974612.470607]: 
Nov  6 19:20:12 ServPRO-iPhone-4S wifid[15] <Notice>: Too frequent(1.121833 secs) rssi event from driver
Nov  6 19:20:12 ServPRO-iPhone-4S wifid[15] <Notice>: 
Nov  6 19:20:13 ServPRO-iPhone-4S profiled[270] <Error>: MKBDeviceLockAssertion: MKBDeviceLockAssertion (asserttype:3)
Nov  6 19:20:13 ServPRO-iPhone-4S securityd[86] <Error>:  SecDbItemInsertOrReplace INSERT failed: The operation couldn’t be completed. (com.apple.utilities.sqlite3 error 19 - reset: [19] columns ctyp, issr, slnr, agrp, sync are not unique sql: INSERT INTO cert(rowid,cdat,mdat,ctyp,cenc,labl,alis,subj,issr,slnr,skid,pkhh,data,agrp,pdmn,sync,tomb,sha1)VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?))
Nov  6 19:20:13 ServPRO-iPhone-4S securityd[86] <Error>:  securityd_xpc_dictionary_handler profiled[270] add The operation couldn’t be completed. (OSStatus error -25299 - duplicate item O,cert,AE250001,L,dku,com.apple.certificates,0,ctyp,cenc,labl,subj,issr,slnr,skid,pkhh,v_Data,20141106135013.500468Z,C6B3998B)
Nov  6 19:20:13 ServPRO-iPhone-4S profiled[270] <Error>:  SecOSStatusWith error:[-25299] The operation couldn’t be completed. (OSStatus error -25299 - Remote error : The operation couldn’t be completed. (OSStatus error -25299 - duplicate item O,cert,AE250001,L,dku,com.apple.certificates,0,ctyp,cenc,labl,subj,issr,slnr,skid,pkhh,v_Data,20141106135013.500468Z,C6B3998B))
Nov  6 19:20:16 ServPRO-iPhone-4S wifid[15] <Notice>: WiFi:[436974616.380883]: 
Nov  6 19:20:16 ServPRO-iPhone-4S wifid[15] <Notice>: Too frequent(3.910278 secs) rssi event from driver
Nov  6 19:20:16 ServPRO-iPhone-4S wifid[15] <Notice>: 
Nov  6 19:20:18 ServPRO-iPhone-4S lockdownd[53] <Notice>: 00281000 _select_socket: receive secure message timeout!
Nov  6 19:20:21 ServPRO-iPhone-4S securityd[86] <Error>:  SecDbItemInsertOrReplace INSERT failed: The operation couldn’t be completed. (com.apple.utilities.sqlite3 error 19 - reset: [19] columns ctyp, issr, slnr, agrp, sync are not unique sql: INSERT INTO cert(rowid,cdat,mdat,ctyp,cenc,labl,alis,subj,issr,slnr,skid,pkhh,data,agrp,pdmn,sync,tomb,sha1)VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?))
Nov  6 19:20:21 ServPRO-iPhone-4S securityd[86] <Error>:  securityd_xpc_dictionary_handler profiled[270] add The operation couldn’t be completed. (OSStatus error -25299 - duplicate item O,cert,CDD28461,L,dku,com.apple.certificates,0,ctyp,cenc,labl,subj,issr,slnr,pkhh,v_Data,20141106135021.901562Z,C7E264E6)
Nov  6 19:20:21 ServPRO-iPhone-4S profiled[270] <Error>:  SecOSStatusWith error:[-25299] The operation couldn’t be completed. (OSStatus error -25299 - Remote error : The operation couldn’t be completed. (OSStatus error -25299 - duplicate item O,cert,CDD28461,L,dku,com.apple.certificates,0,ctyp,cenc,labl,subj,issr,slnr,pkhh,v_Data,20141106135021.901562Z,C7E264E6))
Nov  6 19:20:22 ServPRO-iPhone-4S profiled[270] <Notice>: (Note ) MC: Attempting to retrieve issued certificate...
Nov  6 19:20:22 ServPRO-iPhone-4S profiled[270] <Notice>: (Note ) MC: Issued certificate received.
Nov  6 19:20:23 ServPRO-iPhone-4S profiled[270] <Notice>: (Error) MDM: Cannot Authenticate. Error: NSError:
  Desc   : A connection to the server could not be established.
  US Desc: A connection to the server could not be established.
  Domain : MCHTTPTransactionErrorDomain
  Code   : 23001
  Type   : MCFatalError
  Params : (
     "https://servpro70.servpro.in:443/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc...",
     406
  )
Nov  6 19:20:23 ServPRO-iPhone-4S profiled[270] <Notice>: (Error) MC: Cannot install MDM “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5â€&#157;. Error: NSError:
  Desc   : The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5â€&#157; could not be installed.
  Sugg   : A connection to the server could not be established.
  US Desc: The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5â€&#157; could not be installed.
  US Sugg: A connection to the server could not be established.
  Domain : MCInstallationErrorDomain
  Code   : 4001
  Type   : MCFatalError
  Params : (
     "mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5"
  )
  ...Underlying error:
  NSError:
  Desc   : A connection to the server could not be established.
  US Desc: A connection to the server could not be established.
  Domain : MCHTTPTransactionErrorDomain
  Code   : 23001
  Type   : MCFatalError
  Params : (
     "https://servpro70.servpro.in:443/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc...",
     406
  )
Nov  6 19:20:23 ServPRO-iPhone-4S profiled[270] <Notice>: (Error) MC: Rolling back installation of profile “Sybase - iAnywhereâ€&#157;...
Nov  6 19:20:23 ServPRO-iPhone-4S profiled[270] <Notice>: (Error) MC: Installation of profile “Sybase - iAnywhereâ€&#157; failed with error: NSError:
  Desc   : The profile “Config Payloadâ€&#157; could not be installed.
  Sugg   : The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5â€&#157; could not be installed.
  US Desc: The profile “Config Payloadâ€&#157; could not be installed.
  US Sugg: The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5â€&#157; could not be installed.
  Domain : MCProfileErrorDomain
  Code   : 1009
  Type   : MCFatalError
  Params : (
     "Config Payload"
  )
  ...Underlying error:
  NSError:
  Desc   : The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5â€&#157; could not be installed.
  Sugg   : A connection to the server could not be established.
  US Desc: The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5â€&#157; could not be installed.
  US Sugg: A connection to the server could not be established.
  Domain : MCInstallationErrorDomain
  Code   : 4001
  Type   : MCFatalError
  Params : (
     "mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5"
  )
  ...Underlying error:
  NSError:
  Desc   : A connection to the server could not be established.
  US Desc: A connection to the server could not be established.
  Domain : MCHTTPTransactionErrorDomain
  Code   : 23001
  Type   : MCFatalError
  Params : (
     "https://servpro70.servpro.in:443/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc...",
     406
  )
Nov  6 19:20:23 ServPRO-iPhone-4S profiled[270] <Notice>: (Error) MC: Profile “Sybase - iAnywhereâ€&#157; failed to install with error: NSError:
  Desc   : Profile Failed to Install
  Sugg   : The profile “Config Payloadâ€&#157; could not be installed.
  US Desc: Profile Failed to Install
  US Sugg: The profile “Config Payloadâ€&#157; could not be installed.
  Domain : MCInstallationErrorDomain
  Code   : 4001
  Type   : MCFatalError
  ...Underlying error:
  NSError:
  Desc   : The profile “Config Payloadâ€&#157; could not be installed.
  Sugg   : The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5â€&#157; could not be installed.
  US Desc: The profile “Config Payloadâ€&#157; could not be installed.
  US Sugg: The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5â€&#157; could not be installed.
  Domain : MCProfileErrorDomain
  Code   : 1009
  Type   : MCFatalError
  Params : (
     "Config Payload"
  )
  ...Underlying error:
  NSError:
  Desc   : The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5â€&#157; could not be installed.
  Sugg   : A connection to the server could not be established.
  US Desc: The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5â€&#157; could not be installed.
  US Sugg: A connection to the server could not be established.
  Domain : MCInstallationErrorDomain
  Code   : 4001
  Type   : MCFatalError
  Params : (
     "mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5"
  )
  ...Underlying error:
  NSError:
  Desc   : A connection to the server could not be established.
  US Desc: A connection to the server could not be established.
  Domain : MCHTTPTransactionErrorDomain
  Code   : 23001
  Type   : MCFatalError
  Params : (
     "https://servpro70.servpro.in:443/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc...",
     406
  )
Nov  6 19:20:23 ServPRO-iPhone-4S profiled[270] <Notice>: (Note ) MC: Removing certificate with persistent ID 69646e740000000000000349
Nov  6 19:20:23 ServPRO-iPhone-4S profiled[270] <Notice>: (Note ) MC: Removing certificate with persistent ID 69646e740000000000000347
Nov  6 19:20:23 ServPRO-iPhone-4S profiled[270] <Notice>: (Note ) MC: Removing certificate with persistent ID 69646e74000000000000034a
Nov  6 19:20:23 ServPRO-iPhone-4S profiled[270] <Notice>: (Note ) MC: Removing certificate with persistent ID 69646e740000000000000348
Nov  6 19:20:23 ServPRO-iPhone-4S profiled[270] <Notice>: (Note ) MC: Removing certificate with persistent ID 636572740000000000000346
Nov  6 19:20:23 ServPRO-iPhone-4S Preferences[271] <Warning>: -[VPNConnectionStore reloadVPN]: The active VPN configuration has changed from (null) to (null)
Nov  6 19:20:23 ServPRO-iPhone-4S profiled[270] <Error>: __MKBAssertionFinalize: __MKBAssertionFinalize(0x175a7bf0)
Nov  6 19:20:23 ServPRO-iPhone-4S profiled[270] <Notice>: (Error) MC: Installation failed. Error: NSError:
  Desc   : Profile Installation Failed
  Sugg   : Profile Failed to Install
  US Desc: Profile Installation Failed
  US Sugg: Profile Failed to Install
  Domain : MCInstallationErrorDomain
  Code   : 4001
  Type   : MCFatalError
  ...Underlying error:
  NSError:
  Desc   : Profile Failed to Install
  Sugg   : The profile “Config Payloadâ€&#157; could not be installed.
  US Desc: Profile Failed to Install
  US Sugg: The profile “Config Payloadâ€&#157; could not be installed.
  Domain : MCInstallationErrorDomain
  Code   : 4001
  Type   : MCFatalError
  ...Underlying error:
  NSError:
  Desc   : The profile “Config Payloadâ€&#157; could not be installed.
  Sugg   : The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5â€&#157; could not be installed.
  US Desc: The profile “Config Payloadâ€&#157; could not be installed.
  US Sugg: The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5â€&#157; could not be installed.
  Domain : MCProfileErrorDomain
  Code   : 1009
  Type   : MCFatalError
  Params : (
     "Config Payload"
  )
  ...Underlying error:
  NSError:
  Desc   : The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5â€&#157; could not be installed.
  Sugg   : A connection to the server could not be established.
  US Desc: The payload “mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5â€&#157; could not be installed.
  US Sugg: A connection to the server could not be established.
  Domain : MCInstallationErrorDomain
  Code   : 4001
  Type   : MCFatalError
  Params : (
     "mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5"
  )
  ...Underlying error:
  NSError:
  Desc   : A connection to the server could not be established.
  US Desc: A connection to the server could not be established.
  Domain : MCHTTPTransactionErrorDomain
  Code   : 23001
  Type   : MCFatalError
  Params : (
     "https://servpro70.servpro.in:443/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc...",
     406
  )

Debugviewlog**




00000001
0.00000000
[1896] thread:9 time: 2014/11/06 19:22:45 Request to GetEnrollmentSeedData: http://servpro90.servpro.in/aips/aipService.svc/GetEnrollmentSeedData?ID={e3ef792f-918f-41fd-b080-22cea15ed250}&ClientType=-8



00000002
0.00022110
[1896] thread:9 time: 2014/11/06 19:22:45 http GET Request



00000003
0.00031700
[1896] thread:9 time: 2014/11/06 19:22:45 getAfariaAuthentication: Afaria Client version 6.60.6620.2 found



00000004
0.00041440
[1896] thread:9 time: 2014/11/06 19:22:45 getAfariaAuthentication: Afaria Authentication version  found



00000005
0.00050680
[1896] thread:9 time: 2014/11/06 19:22:45 [0] Connection keep-alive



00000006
0.00059840
[1896] thread:9 time: 2014/11/06 19:22:45 [1] Accept */*



00000007
0.00069740
[1896] thread:9 time: 2014/11/06 19:22:45 [2] Accept-Encoding gzip, deflate



00000008
0.00078910
[1896] thread:9 time: 2014/11/06 19:22:45 [3] Accept-Language en-us



00000009
0.00088030
[1896] thread:9 time: 2014/11/06 19:22:45 [4] Host servpro70.servpro.in:80



00000010
0.00098170
[1896] thread:9 time: 2014/11/06 19:22:45 [5] User-Agent Afaria iPhone Client



00000011
0.00107720
[1896] thread:9 time: 2014/11/06 19:22:45 [6] IAS-RS-AFQ c187c5ec04f3000000000023.ios-server



00000012
0.00116810
[1896] thread:9 time: 2014/11/06 19:22:45 [7] AfariaCaps 6.60.6620.2



00000013
0.00130360
[1896] thread:9 time: 2014/11/06 19:22:45 [8] AfariaAuth  



00000014
0.00139320
[1896] thread:9 time: 2014/11/06 19:22:45 isGUID ok GUID: e3ef792f-918f-41fd-b080-22cea15ed250



00000015
0.00170760
[1896] thread:9 time: 2014/11/06 19:22:45 parseEnrollmentParams ClientType: -8



00000016
0.01978280
[1896] thread:9 time: 2014/11/06 19:22:45 CreateProxyInstance registry endpoint:



00000017
0.01978280
[1896]  net.tcp://localhost:7007/AfariaIphoneServer[2147483647]



00000018
0.02852340
[1960] thread:6 time: 2014/11/06 19:22:46 <SQL validateEnrollID: Select * From A_ENROLLMENT_CODES Where CodeID=@cwe_CodeID << validateEnrollID.validate enrollment code ID, Params: {e3ef792f-918f-41fd-b080-22cea15ed250}



00000019
0.03216370
[1960] thread:6 time: 2014/11/06 19:22:46  RunSQL return << validate enrollment code ID



00000020
0.03231660
[1960] thread:6 time: 2014/11/06 19:22:46 <SQL isPolicyEnabled: Select * from A_PRFL_PROFILE PP, A_PRFL_PROFILE_POLICIES PPP where (PP.WorkProfileID = PPP.WorkProfileID) and (PPP.PolicyID=@cwe_PolicyID) << isPolicyEnabled. retrieve policy dataset, Params: 56827fa8-fe8d-4013-ae7f-701f2659836b



00000021
0.03468990
[1960] thread:6 time: 2014/11/06 19:22:46 isPolicyEnabled ProfileEnabled: T



00000022
0.03534770
[1960] thread:6 time: 2014/11/06 19:22:46 isPolicyEnabled ProfileEnabled: True



00000023
0.03550270
[1960] thread:6 time: 2014/11/06 19:22:46 <SQL getEnrollmentCodeTenantID: Select TenantID From A_OBJECT_METADATA Where ObjectID=@cwe_ObjectID AND Type=@cwe_Type << getEnrollmentCodeTenantID.Grab the tenant id of the policy, Params: {56827fa8-fe8d-4013-ae7f-701f2659836b}, 2



00000024
0.03619960
[1960] thread:6 time: 2014/11/06 19:22:46  RunSQL return << Grab the tenant id of the policy



00000025
0.03633720
[1960] thread:6 time: 2014/11/06 19:22:46 <SQL getEnrollmentCodeTenantID: Select * From A_TENANT where TenantID = @cwe_TenantID << getEnrollmentCodeTenantID.Grab the tenant id of the policy, Params: 1



00000026
0.03708530
[1960] thread:6 time: 2014/11/06 19:22:46  RunSQL return << Grab the tenant id of the policy



00000027
0.03848990
[1960] thread:6 time: 2014/11/06 19:22:46 <SQL getEnrollmentCodeTenantID: Select TenantID From A_OBJECT_METADATA Where ObjectID=@cwe_ObjectID AND Type=@cwe_Type << getEnrollmentCodeTenantID.Grab the tenant id of the policy, Params: {56827fa8-fe8d-4013-ae7f-701f2659836b}, 2



00000028
0.03917070
[1960] thread:6 time: 2014/11/06 19:22:46  RunSQL return << Grab the tenant id of the policy



00000029
0.03930630
[1960] thread:6 time: 2014/11/06 19:22:46 <SQL getEnrollmentCodeTenantID: Select * From A_TENANT where TenantID = @cwe_TenantID << getEnrollmentCodeTenantID.Grab the tenant id of the policy, Params: 1



00000030
0.04000810
[1960] thread:6 time: 2014/11/06 19:22:46  RunSQL return << Grab the tenant id of the policy



00000031
0.04014400
[1960] thread:6 time: 2014/11/06 19:22:46 <SQL getIosSeedData: Select * From A_IPHONE_SETTINGS Where TenantID=@cwe_TenantID << getIosSeedData., Params: 0



00000032
0.04101540
[1960] thread:6 time: 2014/11/06 19:22:46  RunSQL return <<seedSettingsQuery



00000033
0.04120350
[1960] thread:6 time: 2014/11/06 19:22:46  getIosSeedData T[1] R[1]



00000034
0.04136280
[1960] thread:6 time: 2014/11/06 19:22:46 <SQL getPolicyXML: Select PolicyClientSideDef From A_PRFL_POLICIES Where PolicyID=@cwe_PolicyID << getPolicyXML.Grab related policy xml for enrollment code, Params: {56827fa8-fe8d-4013-ae7f-701f2659836b}



00000035
0.04223840
[1960] thread:6 time: 2014/11/06 19:22:46  RunSQL return << Grab related policy xml for enrollment code



00000036
0.04539730
[1960] thread:6 time: 2014/11/06 19:22:46 getIosSeedData Configuration xml:



00000037
0.04539730
[1960] <?xml version="1.0" encoding="utf-8"?>



00000038
0.04539730
[1960] <SeedData PolicyID="{56827fa8-fe8d-4013-ae7f-701f2659836b}">



00000039
0.04539730
[1960]  <Configuration>



00000040
0.04539730
[1960]   <ServerAddress>servpro70.servpro.in</ServerAddress>



00000041
0.04539730
[1960]   <ServerPort>80</ServerPort>



00000042
0.04539730
[1960]   <Protocol>http</Protocol>



00000043
0.04539730
[1960]   <VirtualDir>aips</VirtualDir>



00000044
0.04539730
[1960]   <EnrollVirtualDir>aips</EnrollVirtualDir>



00000045
0.04539730
[1960]   <RelayServerPath>/ias_relay_server/client/rs_client.dll/%cid%</RelayServerPath>



00000046
0.04539730
[1960]   <FarmID>ios-farm</FarmID>



00000047
0.04539730
[1960]  </Configuration>



00000048
0.04539730
[1960]  <UserPrompt>



00000049
0.04539730
[1960]   <UserName type="String" map="" Maxlen="64" MinLen="1" var="UserName" svtype="S" mask="0">



00000050
0.04539730
[1960]    <Display>E.g: FirstName.LastName</Display>



00000051
0.04539730
[1960]   </UserName>



00000052
0.04539730
[1960]   <ExchangePassword type="String" map="" Maxlen="64" MinLen="1" var="ExchangePassword" svtype="S" mask="1">



00000053
0.04539730
[1960]    <Display>Enter Exchange Password</Display>



00000054
0.04539730
[1960]   </ExchangePassword>



00000055
0.04539730
[1960]  </UserPrompt>



00000056
0.04539730
[1960]  <Server>



00000057
0.04539730
[1960]   <GroupAssign>



00000058
0.04539730
[1960]    <Group>4</Group>



00000059
0.04539730
[1960]   </GroupAssign>



00000060
0.04539730
[1960]   <MDMEnroll />



00000061
0.04539730
[1960]  </Server>



00000062
0.04539730
[1960]  <AfariaSeedData>



00000063
0.04539730
[1960]   <useNamingOptions>1</useNamingOptions>



00000064
0.04539730
[1960]   <connectAfterInstall>"1"</connectAfterInstall>



00000065
0.04539730
[1960]   <autoApprove>"1"</autoApprove>



00000066
0.04539730
[1960]   <UseIdentityCertificate>"0"</UseIdentityCertificate>



00000067
0.04539730
[1960]   <mbdType>"5"</mbdType>



00000068
0.04539730
[1960]   <mbdDnv>""</mbdDnv>



00000069
0.04539730
[1960]   <mbdPrefix>""</mbdPrefix>



00000070
0.04539730
[1960]   <Domain>""</Domain>



00000071
0.04539730
[1960]   <IOSAccessPolicy>130</IOSAccessPolicy>



00000072
0.04539730
[1960]   <enableCompromised>"0"</enableCompromised>



00000073
0.04539730
[1960]   <SSPTitle>""</SSPTitle>



00000074
0.04539730
[1960]   <SSPDescription>""</SSPDescription>



00000075
0.04539730
[1960]   <SSPURL>""</SSPURL>



00000076
0.04539730
[1960]   <tenantID>"ei0o:1"</tenantID>



00000077
0.04539730
[1960]   <relayServerPrefix>/ias_relay_server/client/rs_client.dll</relayServerPrefix>



00000078
0.04539730
[1960]   <relayServerFarmID>afaria-farm</relayServerFarmID>



00000079
0.04539730
[1960]   <ExtraData1>KQUlNw3wrbrRZwU/+GIgCN8QCNA=</ExtraData1>



00000080
0.04539730
[1960]   <iOSAndroidEnrollmentUri>http://servpro70.servpro.in:80/ias_relay_server/client/rs_client.dll/ios-farm/aips/aipService.svc/</iOSAndroidEnrollmentUri>



00000081
0.04539730
[1960]   <OOBInventorySupport>1</OOBInventorySupport>



00000082
0.04539730
[1960]  </AfariaSeedData>



00000083
0.04539730
[1960]  <Callback agent="KeyRequestAgent">/package/cert/generateKey2</Callback>



00000084
0.04539730
[1960] </SeedData>



00000085
0.04572510
[1896] thread:9 time: 2014/11/06 19:22:46 getAfariaEnrollmentSeedData ret: True



00000086
0.04607690
[1896] thread:9 time: 2014/11/06 19:22:46 sendData HttpStatusCode.OK



00000087
0.14002430
[FFFFFA8003608850] WskProIRPGetAddrInfo is called.



00000088
0.14003830
[bind=FFFFFA800363BE90] Binding reference count++ = 2 (status = 00000000, impersonation= 2).



00000089
0.14004271
[FFFFFA800383A820] Request reference count++ = 3.



00000090
0.14007650
[FFFFFA800383A820] RPC method type = 1: rpc-method succeeded, queue to rpc-pending-list.



00000091
0.14008079
[FFFFFA800383A820] Request reference count-- = 2.



00000092
0.43184200
[FFFFFA800383A820] WskKnrRpcComplete: rpc calls back for completion.



00000093
0.43185249
[FFFFFA800383A820] WskKnrCompletePending: complete pending request (rpc=1).



00000094
0.43185720
[FFFFFA800383A820] Request reference count-- = 1.



00000095
0.43186110
[FFFFFA800383A820] Request reference count-- = 0.



00000096
0.43188280
[FFFFFA800383A820] WskKnrCompleteRequest: rpc completion return status = 00000000 (reply=00000000).



00000097
0.43188840
[FFFFFA800383A820] WskProAPIGetAddressInfo returned addrinfo: [addr=FFFFF8A00884E390].



00000098
0.43189311
[bind=FFFFFA800363BE90] Binding reference count-- = 1.



00000099
0.43189839
[FFFFFA800383A820] WskKnrCompleteRequest: complete irp with IO status = 00000000.



00000100
0.53328389
[addr=FFFFF8A00884E390] WskProAPIFreeAddressInfo freed addrinfo.



00000101
9.58364773
[1896] thread:9 time: 2014/11/06 19:22:55 Request to EnrollmentRecord: http://servpro90.servpro.in/aips/aipService.svc/EnrollmentRecord?ID={56827fa8-fe8d-4013-ae7f-701f2659836b}&ClientType=-8



00000102
9.58376884
[1896] thread:9 time: 2014/11/06 19:22:55 isGUID ok GUID: 56827fa8-fe8d-4013-ae7f-701f2659836b



00000103
9.58498096
[1896] thread:9 time: 2014/11/06 19:22:55 parseEnrollmentParams ClientType: -8



00000104
9.58510685
[1960] thread:6 time: 2014/11/06 19:22:55 parseIosEnrollmentRecord default: ExchangePassword



00000105
9.58526802
[1960] thread:6 time: 2014/11/06 19:22:55 parseIosEnrollmentRecord default: UserName



00000106
9.58539677
[1960] thread:6 time: 2014/11/06 19:22:55 createIosEnrollmentRecord<build SQL U 116113a8f8dad3e44aa97e0a419c3627cfd672a5 <<findEnrollmentIDquery



00000107
9.58559895
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL createIosEnrollmentRecord: select Distinct * from A_V_IPHONE_DEVICE where UDID = @cwe_UDID <<findEnrollmentIDquery



00000108
9.58778286
[1960] thread:6 time: 2014/11/06 19:22:55  RunQuery return <<findEnrollmentUDIDQuery



00000109
9.58813667
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL getEnrollmentCodeTenantID: Select TenantID From A_OBJECT_METADATA Where ObjectID=@cwe_ObjectID AND Type=@cwe_Type << getEnrollmentCodeTenantID.Grab the tenant id of the policy, Params: {56827fa8-fe8d-4013-ae7f-701f2659836b}, 2



00000110
9.58891964
[1960] thread:6 time: 2014/11/06 19:22:55  RunSQL return << Grab the tenant id of the policy



00000111
9.58907127
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL getEnrollmentCodeTenantID: Select * From A_TENANT where TenantID = @cwe_TenantID << getEnrollmentCodeTenantID.Grab the tenant id of the policy, Params: 1



00000112
9.58994198
[1960] thread:6 time: 2014/11/06 19:22:55  RunSQL return << Grab the tenant id of the policy



00000113
9.59010124
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL getPolicyXML: Select PolicyClientSideDef From A_PRFL_POLICIES Where PolicyID=@cwe_PolicyID << getPolicyXML.Grab related policy xml for enrollment code, Params: {56827fa8-fe8d-4013-ae7f-701f2659836b}



00000114
9.59107018
[1960] thread:6 time: 2014/11/06 19:22:55  RunSQL return << Grab related policy xml for enrollment code



00000115
9.59363270
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL getPolicyXML: Select PolicyClientSideDef From A_PRFL_POLICIES Where PolicyID=@cwe_PolicyID << getPolicyXML.Grab related policy xml for enrollment code, Params: {56827fa8-fe8d-4013-ae7f-701f2659836b}



00000116
9.59455776
[1960] thread:6 time: 2014/11/06 19:22:55  RunSQL return << Grab related policy xml for enrollment code



00000117
9.59693050
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL getPolicyXML: Select PolicyClientSideDef From A_PRFL_POLICIES Where PolicyID=@cwe_PolicyID << getPolicyXML.Grab related policy xml for enrollment code, Params: {56827fa8-fe8d-4013-ae7f-701f2659836b}



00000118
9.59783459
[1960] thread:6 time: 2014/11/06 19:22:55  RunSQL return << Grab related policy xml for enrollment code



00000119
9.60047340
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL createIosEnrollmentRecord: insert into A_CLIENT ( ClientGUID, ClientFriendlyName, ClientCategory, FirstConnectDate, LastConnectDate, ClientLicenseType, Approved, TenantID, SelfServiceUserName, AssignmentsUserName ) values ( @cwe_ClientGUID, @cwe_ClientFriendlyName, -8, @cwe_FirstConnectionDate, @cwe_LastConnectDate, 0, @cwe_Approved, @cwe_TenantID, @cwe_SelfServiceUserName, @cwe_AssignmentsUserName) <<insertEnrollmentClientData(Client)



00000120
9.61700153
[1960] thread:6 time: 2014/11/06 19:22:55  RunSQL return <<insertEnrollmentData(Client)



00000121
9.61715031
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL createIosEnrollmentRecord: select ClientUID from a_client where ClientGUID = (@cwe_ClientGUID) <<selectEnrollmentClientUid



00000122
9.61801243
[1960] thread:6 time: 2014/11/06 19:22:55  RunSQL return <<selectEnrollmentClientUid[249]



00000123
9.61924648
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL createIosEnrollmentRecord: insert into A_IPHONE_DEVICE ( ClientUID, UDID, Version, SyncPolicy, WiFiMAC, UseIdentityCert, EnableCompromised, EnrollmentPolicy ) values (249, @cwe_UDID, @cwe_Version, @cwe_SyncPolicy, @cwe_WiFiMAC, @cwe_UseIdentityCert, @cwe_EnableCompromised, @cwe_EnrollmentPolicy) <<insertEnrollmentData(iPhone Device)



00000124
9.63378906
[1960] thread:6 time: 2014/11/06 19:22:55  RunSQL return <<insertEnrollmentData(iPhone Device)



00000125
9.63395882
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL getDeviceID: Select * from A_V_IPHONE_DEVICE where UDID=@cwe_UDID << getDeviceID.getDeviceIDquery, Params: 116113a8f8dad3e44aa97e0a419c3627cfd672a5



00000126
9.63516903
[1960] thread:6 time: 2014/11/06 19:22:55  RunQuery return <<createIosEnrollmentRecord.getDeviceIDquery



00000127
9.63533020
[1960] thread:6 time: 2014/11/06 19:22:55 Call insert of variable change date



00000128
9.65590668
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL getPolicyXML: Select PolicyClientSideDef From A_PRFL_POLICIES Where PolicyID=@cwe_PolicyID << getPolicyXML.Grab related policy xml for enrollment code, Params: {56827fa8-fe8d-4013-ae7f-701f2659836b}



00000129
9.65839672
[1960] thread:6 time: 2014/11/06 19:22:55  RunSQL return << Grab related policy xml for enrollment code



00000130
9.66187954
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL addIPhoneToGroups: Select * From A_OBJECT_METADATA Where ObjectID=@cwe_ObjectID << addIPhoneToGroups.Get the client group tenant ID, Params: 4



00000131
9.66268063
[1960] thread:6 time: 2014/11/06 19:22:55  RunSQL return <<  Get the client group tenant ID



00000132
9.66280365
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL addIPhoneToGroups: insert into A_GROUP_MEMBER ( GroupID, ClientUID ) values ( @cwe_GroupID, @cwe_ClientUID ) << addIPhoneToGroups.insertIPhoneGroupMember, Params: 4, 249



00000133
9.66724491
[1960] thread:6 time: 2014/11/06 19:22:55  RunSQL return <<insertIPhoneGroupMember



00000134
9.66742420
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL storeUserPromptResponses: Select TenantID, ClientCategory, SubstVarName, CreatedBy From A_DEV_SUBSTVAR_NAME Where (TenantID = '0' OR TenantID =@cwe_TenantID) AND ClientCategory = @cwe_ClientCategory AND SubstVarName = @cwe_SubstVarName ORDER BY TenantID ASC << storeUserPromptResponses.validateSubstVar, Params: 1, -8, UserName



00000135
9.66820335
[1960] thread:6 time: 2014/11/06 19:22:55  RunSQL return << validateSubstVar



00000136
9.66836452
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL storeUserPromptResponses: Select TenantID, ClientCategory, SubstVarName, CreatedBy From A_DEV_SUBSTVAR_NAME Where (TenantID = '0' OR TenantID =@cwe_TenantID) AND ClientCategory = @cwe_ClientCategory AND SubstVarName = @cwe_SubstVarName ORDER BY TenantID ASC << storeUserPromptResponses.validateSubstVar, Params: 1, -8, ExchangePassword



00000137
9.66947556
[1960] thread:6 time: 2014/11/06 19:22:55  RunSQL return << validateSubstVar



00000138
9.66959763
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL setIPhoneSysVar: Update A_IPHONE_DEVICE Set UserData=@cwe_UserData where UDID=@cwe_UDID << update iphone sys subst var  



00000139
9.67535019
[1960] thread:6 time: 2014/11/06 19:22:55  RunSQL return << update iphone sys subst var  



00000140
9.67547226
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL setIPhoneSysVar: Update A_CLIENT Set ClientName=@cwe_ClientName where ClientUID = (SELECT ClientUID from A_IPHONE_DEVICE WHERE UDID=@cwe_UDID) << update iphone sys subst var  



00000141
9.68375492
[1960] thread:6 time: 2014/11/06 19:22:55  RunSQL return << update iphone sys subst var  



00000142
9.68387985
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL setIPhoneSysVar: Update A_IPHONE_DEVICE Set SyncPolicy=@cwe_SyncPolicy where UDID=@cwe_UDID << update iphone sys subst var  



00000143
9.69213200
[1960] thread:6 time: 2014/11/06 19:22:55  RunSQL return << update iphone sys subst var  



00000144
9.78714275
[1960] Unable to call AfariaServer-UpdateSubstitutionVariables without an AssignmentUserName



00000145
9.78772831
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL cleanupChallengeTable: Delete From A_IPHONE_CHAL Where ClientUID=@cwe_ClientUID << cleanupChallengeTable.Delete, Params: 249



00000146
9.78886127
[1960] thread:6 time: 2014/11/06 19:22:55  RunSQL return <<Delete



00000147
9.97579575
[1960] thread:6 time: 2014/11/06 19:22:55 createIosEnrollmentRecord Connection Log Entry:



00000148
9.97579575
[1960]   DeviceTableID: 249



00000149
9.97579575
[1960]   Action: Enrollment Data Sent



00000150
9.97579575
[1960]   Data: device @ 116113a8f8dad3e44aa97e0a419c3627cfd672a5



00000151
9.97595692
[1960] thread:6 time: 2014/11/06 19:22:55 <SQL LogConnectionState: insert into A_IPHONE_LOG ( ClientUID, TimeStamp, Action, Data, ConnectionID ) values (@cwe_ClientUID, @cwe_TimeStamp, @cwe_Action, @cwe_Data, @cwe_ConnectionID) << LogConnectionState.connectionLogInsert, Params: 249, 11/6/2014 7:22:55 PM, Enrollment Data Sent, device @ 116113a8f8dad3e44aa97e0a419c3627cfd672a5, {b0e2803a-6cd7-4b93-83b4-bfa6aedc7348}



00000152
9.98410034
[1960] thread:6 time: 2014/11/06 19:22:55  RunSQL return <<connectionLogInsert



00000153
9.98440933
[1960] thread:6 time: 2014/11/06 19:22:55 createIosEnrollmentRecord Create outbound enrollment xml:



00000154
9.98440933
[1960] <?xml version="1.0" encoding="utf-8"?>



00000155
9.98440933
[1960] <!DOCTYPE plist PUBLIC "-//Apple Inc//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">



00000156
9.98440933
[1960] <plist version="1.0">



00000157
9.98440933
[1960]  <dict>



00000158
9.98440933
[1960]   <key>ClientID</key>



00000159
9.98440933
[1960]   <string>{838e2b33-1c45-4ad1-976e-abeddf6663fc}</string>



00000160
9.98440933
[1960]   <key>redirect</key>



00000161
9.98440933
[1960]   <string>http://servpro70.servpro.in:80/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc/S...</string>



00000162
9.98440933
[1960]   <key>UseIdentityCert</key>



00000163
9.98440933
[1960]   <false />



00000164
9.98440933
[1960]  </dict>



00000165
9.98440933
[1960] </plist>



00000166
9.98440933
[1960]  



00000167
9.98496437
[1896] thread:9 time: 2014/11/06 19:22:55 createAfariaEnrollmentRecord ret: True



00000168
9.98564243
[1896] thread:9 time: 2014/11/06 19:22:55 sendData HttpStatusCode.OK



00000169
10.34152985
[1896] thread:9 time: 2014/11/06 19:22:56 Request to clientData: http://servpro90.servpro.in/aips/aipService.svc/ClientData



00000170
10.34165382
[1896] thread:9 time: 2014/11/06 19:22:56 getAfariaAuthentication: Afaria Authentication version  found



00000171
10.34179592
[1896] thread:9 time: 2014/11/06 19:22:56 POST Request



00000172
10.34240818
[1896] thread:9 time: 2014/11/06 19:22:56 POST [1198] type: application/plist+xml AfariaClient: True



00000173
10.34273052
[1896] thread:9 time: 2014/11/06 19:22:56 parseClientData()



00000174
10.34296894
[1896] thread:9 time: 2014/11/06 19:22:56 iPhoneInputParser.parseClientData: True



00000175
10.34396839
[1896] thread:9 time: 2014/11/06 19:22:56 setAfariaClientInventory UDID: 116113a8f8dad3e44aa97e0a419c3627cfd672a5



00000176
10.34420395
[1960] thread:6 time: 2014/11/06 19:22:56 clientInventoryValid WiFiMAC null or empty



00000177
10.34441853
[1960] thread:6 time: 2014/11/06 19:22:56 clientInventoryValid TempID null or empty



00000178
10.34461117
[1960] thread:6 time: 2014/11/06 19:22:56 <SQL SetAfariaClientInventory: Select * from A_V_IPHONE_DEVICE where UDID=@cwe_UDID << SetAfariaClientInventory.setClientInventoryUDIDQuery, Params: 116113a8f8dad3e44aa97e0a419c3627cfd672a5



00000179
10.34633064
[1960] thread:6 time: 2014/11/06 19:22:56  RunQuery return <<setClientInventoryUUIDQuery



00000180
10.34648991
[1960] thread:6 time: 2014/11/06 19:22:56  SetAfariaClientInventory T[1] R[1]



00000181
10.34664917
[1960] thread:6 time: 2014/11/06 19:22:56 <SQL hasMDMtoken: Select * from A_IPHONE_MDM_TOKEN where UDID=@cwe_UDID << hasMDMtoken.getUDIDtokenStatusQuery, Params: 116113a8f8dad3e44aa97e0a419c3627cfd672a5



00000182
10.34748936
[1960] thread:6 time: 2014/11/06 19:22:56  RunQuery return <<getUDIDtokenStatusQuery



00000183
10.34766674
[1960] thread:6 time: 2014/11/06 19:22:56  hasMDMtoken T[1] R[0]



00000184
10.34783077
[1960] thread:6 time: 2014/11/06 19:22:56 <SQL deviceTenantEnabled: Select A_V_IPHONE_DEVICE.TenantID, A_V_IPHONE_DEVICE.ARowID, A_TENANT.TenantID, A_TENANT.State from A_V_IPHONE_DEVICE, A_TENANT where A_V_IPHONE_DEVICE.TenantID = A_TENANT.TenantID and A_V_IPHONE_DEVICE.ARowID=@cwe_ARowID << deviceTenantEnabled.deviceEnabledInTenantQuery, Params: 249



00000185
10.34866810
[1960] thread:6 time: 2014/11/06 19:22:56  RunQuery return <<deviceEnabledInTenantTenantQuery



00000186
10.34884930
[1960] thread:6 time: 2014/11/06 19:22:56  isClientApprovedAndTenantEnabled.deviceTenantEnabled T[1] R[1] State: Enabled



00000187
10.35114670
[1960] thread:6 time: 2014/11/06 19:22:56 <SQL SetAfariaClientInventory: Update A_IPHONE_DEVICE Set JailBroken=@cwe_JailBroken,AfariaInstalled=@cwe_AfariaInstalled,ApplicationToken=@cwe_ApplicationToken Where UDID=@cwe_UDID << SetAfariaClientInventory.updateClient&DeviceTableJailbroken, Params: 0, 1, , 116113a8f8dad3e44aa97e0a419c3627cfd672a5



00000188
10.36733818
[1960] thread:6 time: 2014/11/06 19:22:56  RunSQL return <<updateClient&DeviceTableJailbroken



00000189
10.36775208
[1960] thread:6 time: 2014/11/06 19:22:56 <SQL iPhoneComponentID: Select ComponentID from A_CONFIGURATION_COMPONENT_MAP where ComponentName=@cwe_ComponentName << iPhoneComponentID.getComponentIDquery, Params: iphone



00000190
10.36826420
[1960] thread:6 time: 2014/11/06 19:22:56  RunSQL return <<getComponentIDquery



00000191
10.36843395
[1960] thread:6 time: 2014/11/06 19:22:56 iPhoneComponentID: iPhone is 14



00000192
10.36860275
[1960] thread:6 time: 2014/11/06 19:22:56 <SQL getBrandingItem: Select Distinct * from A_TENANT_CONF_PROP where ComponentID=@cwe_ComponentID and Category='branding' and TenantID=@cwe_TenantID and DataKey=@cwe_DataKey and DataSubKey=@cwe_DataSubKey << getBrandingItem.getBrandingItemQuery, Params: 14, 1, hash, iphone4g



00000193
10.36932564
[1960] thread:6 time: 2014/11/06 19:22:56  RunSQL return <<getBrandingItemQuery



00000194
10.36942005
[1960] thread:6 time: 2014/11/06 19:22:56 getBrandingItem.A_TENANT_CONF_PROP empty/invalid DataSet



00000195
10.36959076
[1960] thread:6 time: 2014/11/06 19:22:56 brandingDataAvailable ret:False



00000196
10.36974621
[1960] thread:6 time: 2014/11/06 19:22:56 <SQL SetAfariaClientInventory: Select LastMDMConnect,LastSMSSent From A_INV_IPHONE_AFARIA Where ClientUID=@cwe_PhoneNumber << SetAfariaClientInventory.setClientInventoryLastConnectQuery2, Params: 249



00000197
10.37045956
[1960] thread:6 time: 2014/11/06 19:22:56  RunQuery return <<setClientInventoryLastConnectQuery2



00000198
10.37065983
[1960] thread:6 time: 2014/11/06 19:22:56  SetAfariaClientInventory T[1] R[1]



00000199
10.37183094
[1960] thread:6 time: 2014/11/06 19:22:56 <SQL SetAfariaClientInventory: insert into A_INV_SCANDATA_INPUT ( XMLData ) values ( @cwe_XMLData ) << SetAfariaClientInventory.InsertScanData, Params: <?xml version="1.0" encoding="utf-8"?>



00000200
10.37183094
[1960] <InventoryInfo>



00000201
10.37183094
[1960]  <Device>



00000202
10.37183094
[1960]   <ClientCategory>-8</ClientCategory>



00000203
10.37183094
[1960]   <DeviceOS>iOS</DeviceOS>



00000204
10.37183094
[1960]   <AssignedID>116113a8f8dad3e44aa97e0a419c3627cfd672a5</AssignedID>



00000205
10.37183094
[1960]   <iosUDID>116113a8f8dad3e44aa97e0a419c3627cfd672a5</iosUDID>



00000206
10.37183094
[1960]   <ClassRestrictions>Afaria</ClassRestrictions>



00000207
10.37183094
[1960]   <MissingTagDeletesData>y</MissingTagDeletesData>



00000208
10.37183094
[1960]   <iosJailbroken>0</iosJailbroken>



00000209
10.37183094
[1960]   <iosAfariaInstalled>1</iosAfariaInstalled>



00000210
10.37183094
[1960]   <iosAfariaVersion>6.60.6620.2</iosAfariaVersion>



00000211
10.37183094
[1960]   <iosLastClientConnect>11-6-2014 7:22:56 PM</iosLastClientConnect>



00000212
10.37183094
[1960]   <iosSyncPolicyDesc>Use Default Policy</iosSyncPolicyDesc>



00000213
10.37183094
[1960]   <iosLastConnect>11-6-2014 7:22:56 PM</iosLastConnect>



00000214
10.37183094
[1960]   <iosLastSMSSent>11/6/2014 7:22:55 PM</iosLastSMSSent>



00000215
10.37183094
[1960]   <iosMDM>0</iosMDM>



00000216
10.37183094
[1960]  </Device>



00000217
10.37183094
[1960] </InventoryInfo>



00000218
10.37183094
[1960]  



00000219
10.38445187
[1960] thread:6 time: 2014/11/06 19:22:56 SetAfariaClientInventory: True



00000220
10.38507748
[1896] thread:9 time: 2014/11/06 19:22:56 setAfariaClientInventory ret: True http: 200



00000221
10.38705444
[1960] thread:6 time: 2014/11/06 19:22:56 <SQL getDeviceID: Select * from A_V_IPHONE_DEVICE where UDID=@cwe_UDID << getDeviceID.getDeviceIDquery, Params: 116113a8f8dad3e44aa97e0a419c3627cfd672a5



00000222
10.38940239
[1960] thread:6 time: 2014/11/06 19:22:56  RunQuery return <<GetAfariaTEMSettingsTimestamp.getDeviceIDquery



00000223
10.41016865
[1960] thread:6 time: 2014/11/06 19:22:56 GetAfariaTEMSettingsTimestamp: Getting TEM Timestamp for device



00000224
10.41051102
[1896] thread:9 time: 2014/11/06 19:22:56 sendXmlMessage HttpStatusCode.OK



00000225
10.43808365
[1896] thread:9 time: 2014/11/06 19:22:56 Request to GetNitrodeskPolicySettings: http://servpro90.servpro.in/aips/aipService.svc/GetNitrodeskPolicySettings?%09%09%09%09%09UDID=11611...



00000226
10.43820000
[1896] thread:9 time: 2014/11/06 19:22:56 http GET Request



00000227
10.43842125
[1896] thread:9 time: 2014/11/06 19:22:56 isIdeviceMessage ? True # unknown



00000228
10.43933582
[1960] thread:6 time: 2014/11/06 19:22:56 <SQL getDeviceID: Select * from A_V_IPHONE_DEVICE where UDID=@cwe_UDID << getDeviceID.getDeviceIDquery, Params: 116113a8f8dad3e44aa97e0a419c3627cfd672a5



00000229
10.44087982
[1960] thread:6 time: 2014/11/06 19:22:56  RunQuery return <<GetiOSDeviceNirodeskSettings.getDeviceIDquery



00000230
10.50371170
[7820] getOSVersionFromClientGUID returned false, unable to find client record so allowing connection to proceed by default.



00000231
10.55638504
[1960] Unable to call AfariaServer-UpdateSubstitutionVariables without an AssignmentUserName



00000232
10.55711651
[1960] thread:6 time: 2014/11/06 19:22:56 <SQL GetiOSDeviceNitrodeskSettings:  SELECT  T6.ClientGUID,T1.GroupID,T2.WorkProfilePriority,T2.WorkProfileID, T4.PolicyClientSideDef



00000233
10.55711651
[1960]                                         FROM A_PRFL_ASSIGNMENTS T1  



00000234
10.55711651
[1960]                                         JOIN A_PRFL_PROFILE T2 ON T1.WorkProfileID = T2.WorkProfileID   AND  



00000235
10.55711651
[1960]                                                     T1.QualifiedGroup IN(@cwe_Group0, @cwe_Group1) AND  T2.ProfileEnabled = 'T'



00000236
10.55711651
[1960]                                         JOIN A_PRFL_PROFILE_POLICIES T3 ON T2.WorkProfileID = T3.WorkProfileID



00000237
10.55711651
[1960]                                         JOIN A_PRFL_POLICIES T4 ON T3.PolicyID=T4.PolicyID  AND T4.PolicyTypeID like 'XNiPhoneND%'



00000238
10.55711651
[1960]                                         JOIN A_V_IPHONE_DEVICE  T6 ON T6.ARowID= @cwe_GroupID



00000239
10.55711651
[1960]                                         JOIN



00000240
10.55711651
[1960]                                             (SELECT  TOP 1 T2.WorkProfilePriority, T2.WorkProfileID,T1.GroupID



00000241
10.55711651
[1960]                                             FROM A_PRFL_ASSIGNMENTS T1, A_PRFL_PROFILE T2,A_PRFL_PROFILE_POLICIES T3,A_PRFL_POLICIES T4,A_V_IPHONE_DEVICE T6



00000242
10.55711651
[1960]                                             WHERE



00000243
10.55711651
[1960]                                               T1.WorkProfileID = T2.WorkProfileID AND T1.QualifiedGroup IN(@cwe_Group0_2, @cwe_Group1_2) AND  



00000244
10.55711651
[1960]                                               T2.WorkProfileID = T3.WorkProfileID AND T2.ProfileEnabled = 'T'  AND



00000245
10.55711651
[1960]                                               T3.PolicyID=T4.PolicyID  AND T4.PolicyTypeID like 'XNiPhoneND%'  



00000246
10.55711651
[1960]                                               AND  



00000247
10.55711651
[1960]                                               T6.ARowID = @cwe_GroupID2 AND T1.TenantID = T6.TenantID



00000248
10.55711651
[1960]                                              order by T2.WorkProfilePriority,T2.WorkProfileID asc) AS  



00000249
10.55711651
[1960]                                             T50 (WorkProfilePriority, WorkProfileID,GroupID)



00000250
10.55711651
[1960]                                             ON T2.WorkProfilePriority = T50.WorkProfilePriority  



00000251
10.55711651
[1960]                                             AND T50.WorkProfileID = T2.WorkProfileID



00000252
10.55711651
[1960]                                             AND  COALESCE(T50.GroupID, -1) = COALESCE(T1.GroupID, -1) << GetiOSDeviceNitrodeskSettings.getNitrodeskSettingsQuery, Params: 4, SYSTEMGROUP:All Clients, 249, 4, SYSTEMGROUP:All Clients, 249



00000253
10.55900764
[1960] thread:6 time: 2014/11/06 19:22:56  RunQuery return <<getNitrodeskSettingsQuery



00000254
10.55954552
[1960] thread:6 time: 2014/11/06 19:22:56  RunQuery return <<getNitrodeskSettingsQuery



00000255
10.55970287
[1896] thread:9 time: 2014/11/06 19:22:56 getAfariaClientBrandingData ret: False



00000256
10.56000042
[1896] thread:9 time: 2014/11/06 19:22:56 sendData HttpStatusCode.OK



00000257
10.61950684
[7820] Unable to call AfariaServer-UpdateSubstitutionVariables without an AssignmentUserName



00000258
11.76817417
[1896] thread:9 time: 2014/11/06 19:22:57 Request to StartEnrollment: http://servpro90.servpro.in/aips2/aipService.svc/StartEnrollment?GUID=b2a1587c-903c-467d-b197-99dc08...



00000259
11.76829338
[1896] thread:9 time: 2014/11/06 19:22:57 http GET Request



00000260
11.76851368
[1896] thread:9 time: 2014/11/06 19:22:57 isIdeviceMessage ? True # iPhone



00000261
11.76894665
[1896] thread:9 time: 2014/11/06 19:22:57 CreateProxyInstance registry endpoint:



00000262
11.76894665
[1896]  net.tcp://localhost:7007/AfariaIphoneServer[2147483647]



00000263
11.78992653
[1960] thread:98 time: 2014/11/06 19:22:57



00000264
11.78992653
[1960] IPhoneDevInfoRequest GetDevInfoRequest(b2a1587c-903c-467d-b197-99dc08f83dab)



00000265
11.78992653
[1960]  



00000266
11.79014683
[1960] thread:98 time: 2014/11/06 19:22:57 <SQL GetDevInfoRequest: Select * from A_V_IPHONE_DEVICE,A_IPHONE_CHAL where Challenge=@cwe_Challenge and Type=0 and A_V_IPHONE_DEVICE.ClientUID=A_IPHONE_CHAL.ClientUID << GetDevInfoRequest.getDevInfoQuery, Params: b2a1587c-903c-467d-b197-99dc08f83dab



00000267
11.79309940
[1960] thread:98 time: 2014/11/06 19:22:57  RunQuery return <<getDevInfoQuery



00000268
11.79327488
[1960] thread:98 time: 2014/11/06 19:22:57  GetDevInfoRequest T[1] R[1]



00000269
11.79343891
[1960] thread:98 time: 2014/11/06 19:22:57 <SQL deviceTenantEnabled: Select A_V_IPHONE_DEVICE.TenantID, A_V_IPHONE_DEVICE.ARowID, A_TENANT.TenantID, A_TENANT.State from A_V_IPHONE_DEVICE, A_TENANT where A_V_IPHONE_DEVICE.TenantID = A_TENANT.TenantID and A_V_IPHONE_DEVICE.ARowID=@cwe_ARowID << deviceTenantEnabled.deviceEnabledInTenantQuery, Params: 249



00000270
11.79449368
[1960] thread:98 time: 2014/11/06 19:22:57  RunQuery return <<deviceEnabledInTenantTenantQuery



00000271
11.79463863
[1960] thread:98 time: 2014/11/06 19:22:57  GetDevInfoRequest.deviceTenantEnabled T[1] R[1] State: Enabled



00000272
11.79475307
[1960] thread:98 time: 2014/11/06 19:22:57 <SQL GetDevInfoRequest: Delete From A_IPHONE_CHAL Where ClientUID=@cwe_ClientUID and Type<>0 << GetDevInfoRequest.sqlOldChallengeDelete, Params: 249



00000273
11.79554844
[1960] thread:98 time: 2014/11/06 19:22:57  RunSQL return <<sqlOldChallengeDelete



00000274
11.79589081
[1960] thread:98 time: 2014/11/06 19:22:57 GetDevInfoRequest Connection Log Entry:



00000275
11.79589081
[1960]   DeviceTableID: 249



00000276
11.79589081
[1960]   Action: Begin enrollment.



00000277
11.79589081
[1960]   Data:  device @  



00000278
11.79604340
[1960] thread:98 time: 2014/11/06 19:22:57 <SQL LogConnectionState: insert into A_IPHONE_LOG ( ClientUID, TimeStamp, Action, Data, ConnectionID ) values (@cwe_ClientUID, @cwe_TimeStamp, @cwe_Action, @cwe_Data, @cwe_ConnectionID) << LogConnectionState.connectionLogInsert, Params: 249, 11/6/2014 7:22:57 PM, Begin enrollment.,  device @ , {c6a260ef-0919-430c-959b-f85f6d188cdf}



00000279
11.80930424
[1960] thread:98 time: 2014/11/06 19:22:57  RunSQL return <<connectionLogInsert



00000280
11.80944443
[1960] thread:98 time: 2014/11/06 19:22:57



00000281
11.80944443
[1960]  >>> getAuthorizedUriAndSigningCertName entry



00000282
11.80959511
[1960] thread:98 time: 2014/11/06 19:22:57 <SQL getAuthorizedUriAndSigningCertName: Select * From A_IPHONE_SETTINGS Where TenantID=@cwe_TenantID << getAuthorizedUriAndSigningCertName.getAuthUriQuery, Params: 0



00000283
11.81063461
[1960] thread:98 time: 2014/11/06 19:22:57  RunSQL return <<getAuthUriQuery



00000284
11.81074047
[1960] thread:98 time: 2014/11/06 19:22:57  getAuthorizedUriAndSigningCertName T[1] R[1]



00000285
11.81082439
[1960] thread:98 time: 2014/11/06 19:22:57



00000286
11.81082439
[1960]  >>> getAuthorizedUriAndSigningCertName exit



00000287
11.81099319
[1960] thread:98 time: 2014/11/06 19:22:57 @ Uri: http://servpro70.servpro.in:80/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc/P... CN:  



00000288
11.81111526
[1960] thread:98 time: 2014/11/06 19:22:57 <SQL GetDevInfoRequest: Update A_IPHONE_CHAL Set Challenge=@cwe_Challengeret,Type=1 Where Challenge=@cwe_Challenge << GetDevInfoRequest.getDevInfoStateAndGuidUpdate, Params: 316d302f-e94d-4314-abb3-d4bf17b1739e, b2a1587c-903c-467d-b197-99dc08f83dab



00000289
11.81764030
[1960] thread:98 time: 2014/11/06 19:22:57  RunSQL return <<getDevInfoStateAndGuidUpdate



00000290
11.81780434
[1960] thread:98 time: 2014/11/06 19:22:57 GetDevInfoRequest Connection Log Entry:



00000291
11.81780434
[1960]   DeviceTableID: 249



00000292
11.81780434
[1960]   Action: Info. request.



00000293
11.81780434
[1960]   Data:  device @  URL: http://servpro70.servpro.in:80/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc/P...



00000294
11.81794357
[1960] thread:98 time: 2014/11/06 19:22:57 <SQL LogConnectionState: insert into A_IPHONE_LOG ( ClientUID, TimeStamp, Action, Data, ConnectionID ) values (@cwe_ClientUID, @cwe_TimeStamp, @cwe_Action, @cwe_Data, @cwe_ConnectionID) << LogConnectionState.connectionLogInsert, Params: 249, 11/6/2014 7:22:57 PM, Info. request.,  device @  URL: http://servpro70.servpro.in:80/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc/P..., {c6a260ef-0919-430c-959b-f85f6d188cdf}



00000295
11.82589436
[1960] thread:98 time: 2014/11/06 19:22:57  RunSQL return <<connectionLogInsert



00000296
11.82654381
[1960] thread:98 time: 2014/11/06 19:22:57



00000297
11.82654381
[1960]  >>> IPhoneDevInfoRequest GetDevInfoRequest exit



00000298
11.82664871
[1896] thread:9 time: 2014/11/06 19:22:57 buildDeviceInfoRequest @ http://servpro70.servpro.in:80/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc/P...



00000299
11.82680416
[1896] thread:9 time: 2014/11/06 19:22:57 sendEvent: buildDeviceInfoRequest @ http://servpro70.servpro.in:80/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc/P...



00000300
11.82693005
[1896] thread:9 time: 2014/11/06 19:22:57 msPkcs7Io.applySignature: SignerCertName null or empty



00000301
11.82702446
[1896] thread:9 time: 2014/11/06 19:22:57 sendMessage HttpStatusCode.OK



00000302
11.82731915
[1896] thread:9 time: 2014/11/06 19:22:57 sendEvent: deviceInfoRequest True



00000303
19.31162262
[1896] thread:9 time: 2014/11/06 19:23:05 Request to PostData: http://servpro90.servpro.in/aips2/aipService.svc/PostData



00000304
19.31186676
[1896] thread:9 time: 2014/11/06 19:23:05 POST Request



00000305
19.31261635
[1896] thread:9 time: 2014/11/06 19:23:05 POST [3628] type: application/pkcs7-signature AfariaClient: False



00000306
19.32917786
[1896] thread:9 time: 2014/11/06 19:23:05 iPhoneInputParser.parseDeviceInfoReply: True



00000307
19.32928085
[1896] thread:9 time: 2014/11/06 19:23:05 sendEvent: deviceInfoReply



00000308
19.32937050
[1896] thread:9 time: 2014/11/06 19:23:05 sendEvent: deviceInfoReply.deviceInfoCHALLENGE 316d302f-e94d-4314-abb3-d4bf17b1739e



00000309
19.32972717
[1896] thread:9 time: 2014/11/06 19:23:05 sendEvent: deviceInfoReply.deviceInfoICCID



00000310
19.32987595
[1896] thread:9 time: 2014/11/06 19:23:05 sendEvent: deviceInfoReply.deviceInfoIMEI 013538007168168



00000311
19.32997704
[1896] thread:9 time: 2014/11/06 19:23:05 sendEvent: deviceInfoReply.deviceInfoPRODUCT IPHONE4,1



00000312
19.33007050
[1896] thread:9 time: 2014/11/06 19:23:05 sendEvent: deviceInfoReply.deviceInfoUDID 116113A8F8DAD3E44AA97E0A419C3627CFD672A5



00000313
19.33116913
[1896] thread:9 time: 2014/11/06 19:23:05 sendEvent: deviceInfoReply.deviceInfoVERSION 11D257



00000314
19.33139420
[1960] thread:98 time: 2014/11/06 19:23:05



00000315
19.33139420
[1960] IPhoneSCEPEnrollRequestInfo SetDevInfoAndGetSCEPEnrollRequestInfo(DevInfo.316d302f-e94d-4314-abb3-d4bf17b1739e)



00000316
19.33139420
[1960]  



00000317
19.33159447
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Select * from A_V_IPHONE_DEVICE,A_IPHONE_CHAL where Challenge=@cwe_Challenge and ARowID=A_IPHONE_CHAL.ClientUID and Type=1 << SetDevInfoAndGetSCEPEnrollRequestInfo.setDevInfoQuery, Params: 316d302f-e94d-4314-abb3-d4bf17b1739e



00000318
19.34794235
[1960] thread:98 time: 2014/11/06 19:23:05  RunQuery return <<setDevInfoQuery



00000319
19.34827423
[1960] thread:98 time: 2014/11/06 19:23:05  SetDevInfoAndGetSCEPEnrollRequestInfo T[1] R[1]



00000320
19.34859467
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Select * from A_V_IPHONE_DEVICE where UDID=@cwe_UDID and ARowID<>@cwe_ARowID << SetDevInfoAndGetSCEPEnrollRequestInfo.findAmbiguousUDIDQuery, Params: 116113a8f8dad3e44aa97e0a419c3627cfd672a5, 249



00000321
19.34956360
[1960] thread:98 time: 2014/11/06 19:23:05  RunQuery return <<findAmbiguousUDIDQuery



00000322
19.34966469
[1960] thread:98 time: 2014/11/06 19:23:05 >> IMEI[ DB: DevInfo:013538007168168 ] <<



00000323
19.34982300
[1960] thread:98 time: 2014/11/06 19:23:05 SetDevInfoAndGetSCEPEnrollRequestInfo Connection Log Entry:



00000324
19.34982300
[1960]   DeviceTableID: 249



00000325
19.34982300
[1960]   Action: Info. reply.



00000326
19.34982300
[1960]   Data: device @  



00000327
19.34996223
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL LogConnectionState: insert into A_IPHONE_LOG ( ClientUID, TimeStamp, Action, Data, ConnectionID ) values (@cwe_ClientUID, @cwe_TimeStamp, @cwe_Action, @cwe_Data, @cwe_ConnectionID) << LogConnectionState.connectionLogInsert, Params: 249, 11/6/2014 7:23:05 PM, Info. reply., device @ , {c6a260ef-0919-430c-959b-f85f6d188cdf}



00000328
19.37886429
[1960] thread:98 time: 2014/11/06 19:23:05  RunSQL return <<connectionLogInsert



00000329
19.37902069
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: insert into A_INV_SCANDATA_INPUT ( XMLData ) values ( @cwe_XMLData ) << SetDevInfoAndGetSCEPEnrollRequestInfo.initDBdataMembers, Params: <?xml version="1.0" encoding="utf-8"?>



00000330
19.37902069
[1960] <InventoryInfo>



00000331
19.37902069
[1960]  <Device>



00000332
19.37902069
[1960]   <ClientCategory>-8</ClientCategory>



00000333
19.37902069
[1960]   <DeviceOS>iOS</DeviceOS>



00000334
19.37902069
[1960]   <AssignedID>116113a8f8dad3e44aa97e0a419c3627cfd672a5</AssignedID>



00000335
19.37902069
[1960]   <iosUDID>116113A8F8DAD3E44AA97E0A419C3627CFD672A5</iosUDID>



00000336
19.37902069
[1960]   <ClassRestrictions>Client,Device,Phone</ClassRestrictions>



00000337
19.37902069
[1960]   <MissingTagDeletesData>y</MissingTagDeletesData>



00000338
19.37902069
[1960]   <iosDeviceOS>ios</iosDeviceOS>



00000339
19.37902069
[1960]   <iosICCID />



00000340
19.37902069
[1960]   <iosIMEI>013538007168168</iosIMEI>



00000341
19.37902069
[1960]   <iosProduct>IPHONE4,1</iosProduct>



00000342
19.37902069
[1960]   <iosSerialNumber>C8PML1V5FMLD</iosSerialNumber>



00000343
19.37902069
[1960]   <iosRomVersion>11D257</iosRomVersion>



00000344
19.37902069
[1960]   <iosPhoneNumber />



00000345
19.37902069
[1960]   <iosSMTPNotifyAddr />



00000346
19.37902069
[1960]   <iosUserName>test                                                            </iosUserName>



00000347
19.37902069
[1960]  </Device>



00000348
19.37902069
[1960] </InventoryInfo>



00000349
19.37902069
[1960]  



00000350
19.38656616
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL setAfariaInventoryMdmEntry: SELECT * FROM A_INV_IPHONE_AFARIA WHERE ClientUID=@cwe_ClientUID << setAfariaInventoryMdmEntry.CheckScanData, Params: 249



00000351
19.38741875
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL setAfariaInventoryMdmEntry: UPDATE A_INV_IPHONE_AFARIA SET MDM=@cwe_MDM WHERE  ClientUID=@cwe_ClientUID << setAfariaInventoryMdmEntry.UpdateScanData, Params: 0, 249



00000352
19.41275215
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Update A_IPHONE_DEVICE Set UDID=@cwe_UDID,ICCID=@cwe_ICCID,Version=@cwe_Version1 Where ClientUID=@cwe_ClientUID1 << SetDevInfoAndGetSCEPEnrollRequestInfo.setDevClientInfoUpdate, Params: 116113A8F8DAD3E44AA97E0A419C3627CFD672A5, , 11D257, 249



00000353
19.41387749
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Update A_CLIENT Set IMEI=@cwe_IMEI, SerialNumber=@cwe_SerialNumber, OSVersion=@cwe_OSVersion2, Model=@cwe_Model, PhoneNumber=@cwe_PhoneNumber Where ClientUID=@cwe_ClientUID2 << SetDevInfoAndGetSCEPEnrollRequestInfo.setDevClientInfoUpdate, Params: 013538007168168, C8PML1V5FMLD, 11D257, IPHONE4,1, , 249



00000354
19.43596840
[1960] thread:98 time: 2014/11/06 19:23:05  RunSQL return <<setDevClientInfoUpdate



00000355
19.43614006
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Select * from A_IPHONE_DEVICE where ClientUID=@cwe_ClientUID  << SetDevInfoAndGetSCEPEnrollRequestInfo.SetDevInfoAndGetSCEPEnrollRequestInfo.UpdateSignMdmMessages, Params: 249



00000356
19.43759918
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Update A_IPHONE_DEVICE Set SignMdmMessages=@cwe_SignMdmMessages Where ClientUID=@cwe_ClientUID << SetDevInfoAndGetSCEPEnrollRequestInfo.SetDevInfoAndGetSCEPEnrollRequestInfo.UpdateSignMdmMessages, Params: 0, 249



00000357
19.43859863
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Select * from A_INV_IPHONE_PHONE where ClientCategory=-8 and ClientUID=@cwe_ClientUID << SetDevInfoAndGetSCEPEnrollRequestInfo.getInvPhoneStatusQuery, Params: 249



00000358
19.43932343
[1960] thread:98 time: 2014/11/06 19:23:05  RunSQL return <<getInvPhoneStatusQuery



00000359
19.43943977
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: insert into A_INV_IPHONE_PHONE (ClientUID, ICCID, ClientCategory) values (@cwe_Param0, @cwe_Param1, @cwe_Param2) << SetDevInfoAndGetSCEPEnrollRequestInfo.Insert, Params: 249, , -8



00000360
19.44454002
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Select * from A_IPHONE_VERSION_MAP where ROMNumber=@cwe_ROMNumber << SetDevInfoAndGetSCEPEnrollRequestInfo.convertROM2OSquery, Params: 11d257



00000361
19.44536209
[1960] thread:98 time: 2014/11/06 19:23:05  RunQuery return <<convertROM2OSquery



00000362
19.44552231
[1960] thread:98 time: 2014/11/06 19:23:05  SetDevInfoAndGetSCEPEnrollRequestInfo T[1] R[0]



00000363
19.44565201
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: UPDATE A_CLIENT SET IMEI=@cwe_IMEI, SerialNumber=@cwe_SerialNumber, Model=@cwe_Model WHERE ClientUID = @cwe_ClientUID << SetDevInfoAndGetSCEPEnrollRequestInfo.SetClientInfo, Params: 013538007168168, C8PML1V5FMLD, IPHONE4,1, 249



00000364
19.44669533
[1960] thread:98 time: 2014/11/06 19:23:05  RunSQL return <<SetClientInfo



00000365
19.44685364
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Select * from A_INV_IPHONE_DEVICE where ClientCategory=-8 and ClientUID=@cwe_ClientUID << SetDevInfoAndGetSCEPEnrollRequestInfo.getInvDeviceStatusQuery, Params: 249



00000366
19.44780731
[1960] thread:98 time: 2014/11/06 19:23:05  RunSQL return <<getInvDeviceStatusQuery



00000367
19.44793892
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: insert into A_INV_IPHONE_DEVICE (ClientUID, UDID, Version, SMTPNotifyAddr, UserName, ClientCategory) values (@cwe_Param0, @cwe_Param1, @cwe_Param2, @cwe_Param3, @cwe_Param4, @cwe_Param5) << SetDevInfoAndGetSCEPEnrollRequestInfo.Insert, Params: 249, 116113A8F8DAD3E44AA97E0A419C3627CFD672A5, 11D257, , test                                                            , -8



00000368
19.45259094
[1960] thread:98 time: 2014/11/06 19:23:05



00000369
19.45259094
[1960]  >>> getScepUriCrqInfoAndSigningCertName entry



00000370
19.45708084
[1960] thread:98 time: 2014/11/06 19:23:05



00000371
19.45708084
[1960]  >>> getScepUriCrqInfoAndSigningCertName exit



00000372
19.45721817
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Update A_IPHONE_CHAL Set Type='3' Where Challenge=@cwe_Challenge and ClientUID=@cwe_ClientUID << SetDevInfoAndGetSCEPEnrollRequestInfo.setDevInfoStateAndGuidUpdate, Params: 316d302f-e94d-4314-abb3-d4bf17b1739e, 249



00000373
19.46152496
[1960] thread:98 time: 2014/11/06 19:23:05  RunSQL return <<setDevInfoStateAndGuidUpdate



00000374
19.46809387
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL SetDevInfoAndGetSCEPEnrollRequestInfo: Select * from A_V_IPHONE_DEVICE where UDID=@cwe_UDID << SetDevInfoAndGetSCEPEnrollRequestInfo.SetDevInfoAndGetSCEPEnrollRequestInfoUDIDquery, Params: 116113a8f8dad3e44aa97e0a419c3627cfd672a5



00000375
19.46964455
[1960] thread:98 time: 2014/11/06 19:23:05 CaName: ServPro-SERVPRO66-CA



00000376
19.46974945
[1960] thread:98 time: 2014/11/06 19:23:05 CommonName:  



00000377
19.46983910
[1960] thread:98 time: 2014/11/06 19:23:05 OrganizationName:  



00000378
19.46992493
[1960] thread:98 time: 2014/11/06 19:23:05 OrganizationUnit:  



00000379
19.47001648
[1960] thread:98 time: 2014/11/06 19:23:05 City:  



00000380
19.47010040
[1960] thread:98 time: 2014/11/06 19:23:05 State:  



00000381
19.47019196
[1960] thread:98 time: 2014/11/06 19:23:05 Country: IN



00000382
19.47036743
[1960] thread:98 time: 2014/11/06 19:23:05 SetDevInfoAndGetSCEPEnrollRequestInfo Connection Log Entry:



00000383
19.47036743
[1960]   DeviceTableID: 249



00000384
19.47036743
[1960]   Action: Enrollment req.



00000385
19.47036743
[1960]   Data: UDID: 116113A8F8DAD3E44AA97E0A419C3627CFD672A5, Cert. CN: 116113A8F8DAD3E44AA97E0A419C3627CFD672A5



00000386
19.47068787
[1960] thread:98 time: 2014/11/06 19:23:05 <SQL LogConnectionState: insert into A_IPHONE_LOG ( ClientUID, TimeStamp, Action, Data, ConnectionID ) values (@cwe_ClientUID, @cwe_TimeStamp, @cwe_Action, @cwe_Data, @cwe_ConnectionID) << LogConnectionState.connectionLogInsert, Params: 249, 11/6/2014 7:23:05 PM, Enrollment req., UDID: 116113A8F8DAD3E44AA97E0A419C3627CFD672A5, Cert. CN: 116113A8F8DAD3E44AA97E0A419C3627CFD672A5, {c6a260ef-0919-430c-959b-f85f6d188cdf}



00000387
19.47776031
[1960] thread:98 time: 2014/11/06 19:23:05  RunSQL return <<connectionLogInsert



00000388
19.47815323
[1960] thread:98 time: 2014/11/06 19:23:05



00000389
19.47815323
[1960]  >>> IPhoneSCEPEnrollRequestInfo SetDevInfoAndGetSCEPEnrollRequestInfo exit



00000390
19.47884560
[1896] thread:9 time: 2014/11/06 19:23:05 sendEnrollmentRequest IPhoneSCEPEnrollRequestInfo.UseSCEPchallenge True



00000391
19.48076248
[1960] getClientInfoEx: queryA row# 0



00000392
19.48162270
[1960] getClientInfoEx: queryB row# 1



00000393
19.48178864
[1960] thread:98 time: 2014/11/06 19:23:05



00000394
19.48178864
[1960]  >>> getScepUriCrqInfoAndSigningCertName entry



00000395
19.48530388
[1960] thread:98 time: 2014/11/06 19:23:05



00000396
19.48530388
[1960]  >>> getScepUriCrqInfoAndSigningCertName exit



00000397
19.51232147
[1896] thread:9 time: 2014/11/06 19:23:05 getAfariaSCEPchallenge ret: False



00000398
19.51261902
[1896] thread:9 time: 2014/11/06 19:23:05  >>> commonSCEP Challenge: 116113A8F8DAD3E44AA97E0A419C3627CFD672A5 UseSCEPchallenge: True



00000399
19.51273727
[1896] thread:9 time: 2014/11/06 19:23:05 buildCertEnrollmentRequest http://servpro70.servpro.in:80/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc/s...



00000400
19.51285362
[1896] thread:9 time: 2014/11/06 19:23:05 sendEvent: buildCertEnrollmentRequest http://servpro70.servpro.in:80/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc/s...



00000401
19.51301193
[1896] thread:9 time: 2014/11/06 19:23:05 msPkcs7Io.applySignature: SignerCertName null or empty



00000402
19.51310539
[1896] thread:9 time: 2014/11/06 19:23:05 sendMessage HttpStatusCode.OK



00000403
19.51344299
[1896] thread:9 time: 2014/11/06 19:23:05 sendEvent: enrollmentRequest



00000404
29.05337524
[1896] thread:9 time: 2014/11/06 19:23:15 Request to GetSCEP: http://servpro90.servpro.in/aips2/aipService.svc/scep?id=SkFORUlNRE1DTUxJREhLRk5ISk1MQU9BR09QS0hERlB...



00000405
29.05364799
[1896] thread:9 time: 2014/11/06 19:23:15 parseSCEPrequest ret: True cmd: GetCACert



00000406
29.10732460
[1896] thread:9 time: 2014/11/06 19:23:15 getAfariaSCEP ret: True http: 200



00000407
29.56765175
[1896] thread:9 time: 2014/11/06 19:23:15 Request to GetSCEP: http://servpro90.servpro.in/aips2/aipService.svc/scep?id=SkFORUlNRE1DTUxJREhLRk5ISk1MQU9BR09QS0hERlB...



00000408
29.56821060
[1896] yQTIzNUFBQTc4MjQ1QTZCQTA5NDg0NjA2MA0GCSqGSIb3DQEBAQUABIIBAIF3t9d%2FRaxVZ3IO9yiOXFldY1r4y2fsOwFQsaVwg1W7EvmrldFDpo3JME6q0NE%2Fu8Z0OIh1PrC6yiCn%2B8hGltdeQu1zxiu3qBtSQmRD4vvl5EASopAhFdG0%2BXnnEiBefOcd7zphQriGhDKSZ9i3nneEmbWLSoea7ei4PxmZD4qoJ5R7zMdpgQwkHrzjzmBCurJKH2gv0lWHWy9bLqFliJ01EEhgnmlryLsL2qB%2Fc4JuRElBB7fmQjGLD0XBPvQ18LVkrfzOioi6GCX5OIsu1MBywPGtSDMvu2N1Qpa0ivQgywQUUjr8D1KWei2I6FuEQ9IsCNCumxw3ctm5P%2FAn76AAAAAAAAA%3D



00000409
29.57045746
[1896] thread:9 time: 2014/11/06 19:23:15 parseSCEPrequest ret: True cmd: PKIOperation



00000410
29.68597031
[1960]  lookup Id: {9cceeeee-4f62-4be2-86b6-10c08852a06e}



00000411
29.99762535
[1896] thread:9 time: 2014/11/06 19:23:15 getAfariaSCEP ret: True http: 200



00000412
30.35263443
[1896] thread:9 time: 2014/11/06 19:23:16 Request to PostData: http://servpro90.servpro.in/aips2/aipService.svc/PostData



00000413
30.35287666
[1896] thread:9 time: 2014/11/06 19:23:16 POST Request



00000414
30.36441612
[1896] thread:9 time: 2014/11/06 19:23:16 POST [3348] type: application/pkcs7-signature AfariaClient: False



00000415
30.37285995
[1896] thread:9 time: 2014/11/06 19:23:16 iPhoneInputParser.parseDeviceInfoReply: False



00000416
30.37298012
[1896] thread:9 time: 2014/11/06 19:23:16 iPhoneInputParser.parseEnrollmentRequestReply: True



00000417
30.37308884
[1896] thread:9 time: 2014/11/06 19:23:16 sendEvent: enrollmentReply



00000418
30.37318420
[1896] thread:9 time: 2014/11/06 19:23:16 sendEvent: enrollmentReply.deviceInfoICCID



00000419
30.37327385
[1896] thread:9 time: 2014/11/06 19:23:16 sendEvent: enrollmentReply.deviceInfoIMEI 013538007168168



00000420
30.37336731
[1896] thread:9 time: 2014/11/06 19:23:16 sendEvent: enrollmentReply.deviceInfoPRODUCT IPHONE4,1



00000421
30.37345505
[1896] thread:9 time: 2014/11/06 19:23:16 sendEvent: enrollmentReply.deviceInfoUDID 116113A8F8DAD3E44AA97E0A419C3627CFD672A5



00000422
30.37423706
[1896] thread:9 time: 2014/11/06 19:23:16 sendEvent: enrollmentReply.deviceInfoVERSION 11D257



00000423
30.37493706
[1960] thread:98 time: 2014/11/06 19:23:16



00000424
30.37493706
[1960] IPhoneConfigs SetCertificateAndGetPolicies(DevInfo.116113A8F8DAD3E44AA97E0A419C3627CFD672A5, x509[1422], IPhoneDatabaseRow)



00000425
30.37493706
[1960]  



00000426
30.37515259
[1960] thread:98 time: 2014/11/06 19:23:16 <SQL SetCertificateAndGetPolicies: Select * from A_IPHONE_VERSION_MAP where ROMNumber=@cwe_ROMNumber << SetCertificateAndGetPolicies.convertROM2OSquery, Params: 11d257



00000427
30.37607765
[1960] thread:98 time: 2014/11/06 19:23:16  RunQuery return <<convertROM2OSquery



00000428
30.37624359
[1960] thread:98 time: 2014/11/06 19:23:16  SetCertificateAndGetPolicies T[1] R[0]



00000429
30.37640572
[1960] thread:98 time: 2014/11/06 19:23:16 <SQL SetCertificateAndGetPolicies: Select * from A_V_IPHONE_DEVICE,A_IPHONE_CHAL where UDID=@cwe_UDID and Type='3' and A_V_IPHONE_DEVICE.ClientUID=A_IPHONE_CHAL.ClientUID << SetCertificateAndGetPolicies.setCertAndGetPolicyQuery, Params: 116113a8f8dad3e44aa97e0a419c3627cfd672a5



00000430
30.37779236
[1960] thread:98 time: 2014/11/06 19:23:16  RunQuery return <<setCertAndGetPolicyQuery



00000431
30.37799644
[1960] thread:98 time: 2014/11/06 19:23:16  SetCertificateAndGetPolicies T[1] R[1]



00000432
30.37817574
[1960] thread:98 time: 2014/11/06 19:23:16 <SQL deviceTenantEnabled: Select A_V_IPHONE_DEVICE.TenantID, A_V_IPHONE_DEVICE.ARowID, A_TENANT.TenantID, A_TENANT.State from A_V_IPHONE_DEVICE, A_TENANT where A_V_IPHONE_DEVICE.TenantID = A_TENANT.TenantID and A_V_IPHONE_DEVICE.ARowID=@cwe_ARowID << deviceTenantEnabled.deviceEnabledInTenantQuery, Params: 249



00000433
30.37914467
[1960] thread:98 time: 2014/11/06 19:23:16  RunQuery return <<deviceEnabledInTenantTenantQuery



00000434
30.37926674
[1960] thread:98 time: 2014/11/06 19:23:16  SetCertificateAndGetPolicies.deviceTenantEnabled T[1] R[1] State: Enabled



00000435
30.37944603
[1960] thread:98 time: 2014/11/06 19:23:16 SetCertificateAndGetPolicies Connection Log Entry:



00000436
30.37944603
[1960]   DeviceTableID: 249



00000437
30.37944603
[1960]   Action: Enrollment reply.



00000438
30.37944603
[1960]   Data: CN = 116113A8F8DAD3E44AA97E0A419C3627CFD672A5



00000439
30.37959671
[1960] thread:98 time: 2014/11/06 19:23:16 <SQL LogConnectionState: insert into A_IPHONE_LOG ( ClientUID, TimeStamp, Action, Data, ConnectionID ) values (@cwe_ClientUID, @cwe_TimeStamp, @cwe_Action, @cwe_Data, @cwe_ConnectionID) << LogConnectionState.connectionLogInsert, Params: 249, 11/6/2014 7:23:16 PM, Enrollment reply., CN = 116113A8F8DAD3E44AA97E0A419C3627CFD672A5, {c6a260ef-0919-430c-959b-f85f6d188cdf}



00000440
30.39683151
[1960] thread:98 time: 2014/11/06 19:23:16  RunSQL return <<connectionLogInsert



00000441
30.39703369
[1960] thread:98 time: 2014/11/06 19:23:16 <SQL SetCertificateAndGetPolicies: Update A_IPHONE_DEVICE Set LastMDMConnect=@cwe_LastMDMConnect,PublicKey=@cwe_PublicKey,Version=@cwe_Version Where ClientUID=@cwe_ClientUID << SetCertificateAndGetPolicies.setCertOsUpdate, Params: 11/6/2014 7:23:16 PM, MIIFijCCBHKgAwIBAgIKG8C4bAAAAAAB9TANBgkqhkiG9w0BAQUFADBMMRIwEAYKCZImiZPyLGQBGRYCaW4xFzAVBgoJkiaJk/IsZAEZFgdTZXJ2UHJvMR0wGwYDVQQDExRTZXJ2UHJvLVNFUlZQUk82Ni1DQTAeFw0xNDExMDYxMzQzMTVaFw0xNjExMDUxMzQzMTVaMHAxCzAJBgNVBAYTAklOMQowCAYDVQQIEwEgMQowCAYDVQQHEwEgMQowCAYDVQQKEwEgMQowCAYDVQQLEwEgMTEwLwYDVQQDEygxMTYxMTNBOEY4REFEM0U0NEFBOTdFMEE0MTlDMzYyN0NGRDY3MkE1MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAu/Q8g4dIQ6X8bvSYing6nnwcT1Mj0/K0gP+r+gFcPboIY20YkdQCUcqCOuYRAYpzHEyqg2xg/fd8UgoT4h+C1Jn3PGlza9Q5oOyJnwmIw9aRiyu5b63f330JRUIeuSlrwf1GzizoI6U7tgONQRdyxTvqhT93I59a8NecltYyZSN29SDapzTuO0bmB1zXMknMd/NiC4DJHTn3p9VO3/WCodhQg32Tbu/oIdaBaFsMSg0oiPDjFzreFjTJNHP3h66x1w34luT9knlkg2iB7uJnVudhTiQuJvks/B5UwhqKQ83hbW8fhcpgqKFj09cecJB3XrnyksRxBIStgEjZy+roUQIDAQABo4ICSDCCAkQwDgYDVR0PAQH/BAQDAgWgMB0GA1UdDgQWBBSCV6KA2VV8sqI1qqeCRaa6CUhGBjAfBgNVHSMEGDAWgBTZUL+9h9eZva8+73pgYpdalcLQ3TCB0wYDVR0fBIHLMIHIMIHFoIHCoIG/hoG8bGRhcDovLy9DTj1TZXJ2UHJvLVNFUlZQUk82Ni1DQSxDTj1TZXJ2cHJvNjYsQ049Q0RQLENOPVB1YmxpYyUyMEtleSUyMFNlcnZpY2VzLENOPVNlcnZpY2VzLENOPUNvbmZpZ3VyYXRpb24sREM9U2VydlBybyxEQz1pbj9jZXJ0aWZpY2F0ZVJldm9jYXRpb25MaXN0P2Jhc2U/b2JqZWN0Q2xhc3M9Y1JMRGlzdHJpYnV0aW9uUG9pbnQwgcUGCCsGAQUFBwEBBIG4MIG1MIGyBggrBgEFBQcwAoaBpWxkYXA6Ly8vQ049U2VydlByby1TRVJWUFJPNjYtQ0EsQ049QUlBLENOPVB1YmxpYyUyMEtleSUyMFNlcnZpY2VzLENOPVNlcnZpY2VzLENOPUNvbmZpZ3VyYXRpb24sREM9U2VydlBybyxEQz1pbj9jQUNlcnRpZmljYXRlP2Jhc2U/b2JqZWN0Q2xhc3M9Y2VydGlmaWNhdGlvbkF1dGhvcml0eTA/BgkrBgEEAYI3FAIEMh4wAEkAUABTAEUAQwBJAG4AdABlAHIAbQBlAGQAaQBhAHQAZQBPAGYAZgBsAGkAbgBlMBMGA1UdJQQMMAoGCCsGAQUFCAICMA0GCSqGSIb3DQEBBQUAA4IBAQCbCYWgh6XN35gBRw4DOSht4hWVHgXV354slLbL7qFl8TJ5+1LlJzojdxa1MvcZXQBMoCbTVqKjmwTMlYtXh6crl7YY07aZNUR4naZw0wKY8bVP1bLgxjg0Kknmb/FTpqmFH4uK+a99UXrcCugR6r4s3/GbmKDUh++MG0xBrEE9htGdGH4y5gxcE6SW0Cbv9kBH65c3gTfF4XUmcXHcZm8u1YKMtDroKVMOoRLCyR/wudbdSux1AWIa3eULFdbGBcnBLjvrPgZ6faKQkEO6z9jpPa0xTGEAWfj+o9Iq3H8uOTKOMdNdmcg1lu4UcgvZCWyPBeItoUIxbyGb4of8lA5D, 11d257, 249



00000442
30.42195129
[1960] thread:98 time: 2014/11/06 19:23:16  RunSQL return <<setCertOsUpdate



00000443
30.42214012
[1960] thread:98 time: 2014/11/06 19:23:16 <SQL SetCertificateAndGetPolicies: Select * from A_IPHONE_MDM_QUEUE where ClientUID=@cwe_ClientUID << SetCertificateAndGetPolicies.getQueueDataQuery, Params: 249



00000444
30.42345238
[1960] thread:98 time: 2014/11/06 19:23:16  RunQuery return <<getQueueDataQuery



00000445
30.42354965
[1960] thread:98 time: 2014/11/06 19:23:16  SetCertificateAndGetPolicies T[1] R[11]



00000446
30.42371178
[1960] thread:98 time: 2014/11/06 19:23:16 SQL profile[11]



00000447
30.42395592
[1960] thread:98 time: 2014/11/06 19:23:16 <SQL SetCertificateAndGetPolicies: Select * from A_PRFL_POLICIES where PolicyID=@cwe_PolicyID << SetCertificateAndGetPolicies.getPolicyPayloadQuery, Params: {f1a2f775-17da-4288-a833-dbc2965897d7}



00000448
30.42482185
[1960] thread:98 time: 2014/11/06 19:23:16  RunQuery return <<getPolicyPayloadQuery



00000449
30.42500877
[1960] thread:98 time: 2014/11/06 19:23:16 <SQL SetCertificateAndGetPolicies: Select * from A_PRFL_POLICIES where PolicyID=@cwe_PolicyID << SetCertificateAndGetPolicies.getPolicyPayloadQuery, Params: {9d099350-49d5-41af-8913-eca4500811ff}



00000450
30.42618942
[1960] thread:98 time: 2014/11/06 19:23:16  RunQuery return <<getPolicyPayloadQuery



00000451
30.42634201
[1960] thread:98 time: 2014/11/06 19:23:16 <SQL getDeviceWiFiMAC: Select * from A_V_IPHONE_DEVICE where ARowID=@cwe_ARowID << getDeviceWiFiMAC.getWiFiMACdeviceIDquery, Params: 249



00000452
30.42764854
[1960] thread:98 time: 2014/11/06 19:23:16  RunQuery return <<SetCertificateAndGetPolicies.getWiFiMACdeviceIDquery



00000453
30.42782402
[1960] thread:98 time: 2014/11/06 19:23:16 SetCertificateAndGetPolicies DeviceID: 249 WiFiMAC:  TenantID: -1 ret: False



00000454
30.42798805
[1960] thread:98 time: 2014/11/06 19:23:16 <SQL buildMdmConfigurationProfile: Select * from A_V_IPHONE_DEVICE where UDID=@cwe_UDID << buildMdmConfigurationProfile.buildMdmConfigurationProfileUDIDquery, Params: 116113a8f8dad3e44aa97e0a419c3627cfd672a5



00000455
30.42931747
[1960] thread:98 time: 2014/11/06 19:23:16  RunQuery return <<buildMdmConfigurationProfileUDIDquery



00000456
30.42948532
[1960] thread:98 time: 2014/11/06 19:23:16



00000457
30.42948532
[1960]  >>> getScepUriCrqInfoAndSigningCertName entry



00000458
30.43426895
[1960] thread:98 time: 2014/11/06 19:23:16



00000459
30.43426895
[1960]  >>> getScepUriCrqInfoAndSigningCertName exit



00000460
30.43443871
[1960] thread:98 time: 2014/11/06 19:23:16



00000461
30.43443871
[1960]  >>> getScepUriCrqInfoAndSigningCertName entry



00000462
30.43755150
[1960] thread:98 time: 2014/11/06 19:23:16



00000463
30.43755150
[1960]  >>> getScepUriCrqInfoAndSigningCertName exit



00000464
30.45119095
[1960] thread:98 time: 2014/11/06 19:23:16  >>> buildSCEPcertDictionary Challenge: 116113a8f8dad3e44aa97e0a419c3627cfd672a5 UseSCEPchallenge: True



00000465
30.45700455
[1960] thread:98 time: 2014/11/06 19:23:16 <SQL buildMdmConfigurationProfile: Select * From A_IPHONE_SETTINGS Where TenantID=@cwe_TenantID << buildMdmConfigurationProfile.buildMdmConfigurationProfileSettingsQuery, Params: 0



00000466
30.46892548
[1960] thread:98 time: 2014/11/06 19:23:16  RunSQL return <<buildMdmConfigurationProfileSettingsQuery



00000467
30.46917725
[1960] thread:98 time: 2014/11/06 19:23:16 ES extractCertChain count: 1



00000468
30.46934319
[1960] thread:98 time: 2014/11/06 19:23:16 <SQL buildMdmConfigurationProfile: Select * From A_IPHONE_SETTINGS Where TenantID=@cwe_TenantID << buildMdmConfigurationProfile.buildMdmConfigurationProfileTenantedSettingsQuery, Params: 1



00000469
30.47044182
[1960] thread:98 time: 2014/11/06 19:23:16 buildMdmConfigurationProfile.RunSQL return <<buildMdmConfigurationProfileTenantedSettingsQuery



00000470
30.47084236
[1960] thread:98 time: 2014/11/06 19:23:16 buildMdmConfigurationProfile invalid tenant: 1 revert to SystemTenant: 0



00000471
30.47086716
[1960] thread:98 time: 2014/11/06 19:23:16 createProfile



00000472
30.47086716
[1960] <?xml version="1.0" encoding="UTF-8"?>



00000473
30.47086716
[1960] <!DOCTYPE plist PUBLIC "-//Apple Inc//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">



00000474
30.47086716
[1960] <plist version="1.0">



00000475
30.47086716
[1960] <dict>



00000476
30.47086716
[1960] <key>PayloadContent</key>



00000477
30.47086716
[1960] <array>



00000478
30.47086716
[1960]  <dict>



00000479
30.47086716
[1960]  <key>PayloadContent</key>



00000480
30.47086716
[1960]  <dict>



00000481
30.47086716
[1960]  <key>Challenge</key>



00000482
30.47086716
[1960]  <string>116113a8f8dad3e44aa97e0a419c3627cfd672a5</string>



00000483
30.47086716
[1960]  <key>Key Type</key>



00000484
30.47086716
[1960]  <string>RSA</string>



00000485
30.47086716
[1960]  <key>Key Usage</key>



00000486
30.47086716
[1960]  <integer>5</integer>



00000487
30.47086716
[1960]  <key>Keysize</key>



00000488
30.47086716
[1960]  <integer>2048</integer>



00000489
30.47086716
[1960]  <key>Name</key>



00000490
30.47086716
[1960]  <string>ServPro-SERVPRO66-CA</string>



00000491
30.47086716
[1960]  <key>GetCACaps</key>



00000492
30.47086716
[1960]   <array>



00000493
30.47086716
[1960]  <string>GETPKIOperation</string>



00000494
30.47086716
[1960]  <string>Renewal</string>



00000495
30.47086716
[1960]  <string>SHA-1</string>



00000496
30.47086716
[1960]   </array>



00000497
30.47086716
[1960]  <key>Subject</key>



00000498
30.47086716
[1960]  <array>



00000499
30.47086716
[1960]   <array>



00000500
30.47086716
[1960]    <array>



00000501
30.47086716
[1960]     <string>O</string>



00000502
30.47086716
[1960]     <string>AfariaMdmEnrollment</string>



00000503
30.47086716
[1960]    </array>



00000504
30.47086716
[1960]   </array>



00000505
30.47086716
[1960]   <array>



00000506
30.47086716
[1960]    <array>



00000507
30.47086716
[1960]     <string>C</string>



00000508
30.47086716
[1960]     <string>IN</string>



00000509
30.47086716
[1960]    </array>



00000510
30.47086716
[1960]   </array>



00000511
30.47086716
[1960]   <array>



00000512
30.47086716
[1960]    <array>



00000513
30.47086716
[1960]     <string>CN</string>



00000514
30.47086716
[1960]     <string>116113a8f8dad3e44aa97e0a419c3627cfd672a5</string>



00000515
30.47086716
[1960]    </array>



00000516
30.47086716
[1960]    </array>



00000517
30.47086716
[1960]   </array>



00000518
30.47086716
[1960]   <key>URL</key>



00000519
30.47086716
[1960]   <string>http://servpro70.servpro.in:80/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc/s...</string>



00000520
30.47086716
[1960]  </dict>



00000521
30.47086716
[1960]  <key>PayloadDescription</key>



00000522
30.47086716
[1960]  <string>mdmSCEP-116113a8f8dad3e44aa97e0a419c3627cfd672a5</string>



00000523
30.47086716
[1960]  <key>PayloadDisplayName</key>



00000524
30.47086716
[1960]  <string>mdmSCEP-116113a8f8dad3e44aa97e0a419c3627cfd672a5</string>



00000525
30.47086716
[1960]  <key>PayloadIdentifier</key>



00000526
30.47086716
[1960]  <string>Sybase - iAnywhere</string>



00000527
30.47086716
[1960]  <key>PayloadOrganization</key>



00000528
30.47086716
[1960]  <string>Sybase - iAnywhere</string>



00000529
30.47086716
[1960]  <key>PayloadType</key>



00000530
30.47086716
[1960]  <string>com.apple.security.scep</string>



00000531
30.47086716
[1960]  <key>PayloadUUID</key>



00000532
30.47086716
[1960]  <string>6aa4dfcc-7dec-4f63-a57d-f7a5576d13f3</string>



00000533
30.47086716
[1960]  <key>PayloadVersion</key>



00000534
30.47086716
[1960]  <integer>1</integer>



00000535
30.47086716
[1960]  </dict>



00000536
30.47086716
[1960]   <dict>



00000537
30.47086716
[1960]    <key>IdentityCertificateUUID</key>



00000538
30.47086716
[1960]    <string>6aa4dfcc-7dec-4f63-a57d-f7a5576d13f3</string>



00000539
30.47086716
[1960]    <key>Topic</key>



00000540
30.47086716
[1960]    <string>com.apple.mgmt.External.214eb693-942e-4c60-b634-cf0f6dd6160e</string>



00000541
30.47086716
[1960]    <key>ServerURL</key>



00000542
30.47086716
[1960]    <string>https://servpro70.servpro.in:443/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc...</string>



00000543
30.47086716
[1960]    <key>CheckInURL</key>



00000544
30.47086716
[1960]    <string>https://servpro70.servpro.in:443/ias_relay_server/client/rs_client.dll/ios-farm/aips2/aipService.svc...</string>



00000545
30.47086716
[1960]    <key>SignMessage</key>



00000546
30.47086716
[1960]    <true/>



00000547
30.47086716
[1960]    <key>AccessRights</key>



00000548
30.47086716
[1960]    <integer>8191</integer>



00000549
30.47086716
[1960]    <key>CheckOutWhenRemoved</key>



00000550
30.47086716
[1960]    <true/>



00000551
30.47086716
[1960]    <key>UseDevelopmentAPNS</key>



00000552
30.47086716
[1960]    <false/>



00000553
30.47086716
[1960]    <key>PayloadType</key>



00000554
30.47086716
[1960]    <string>com.apple.mdm</string>



00000555
30.47086716
[1960]    <key>PayloadDescription</key>



00000556
30.47086716
[1960]    <string>mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5</string>



00000557
30.47086716
[1960]    <key>PayloadDisplayName</key>



00000558
30.47086716
[1960]    <string>mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5</string>



00000559
30.47086716
[1960]    <key>PayloadIdentifier</key>



00000560
30.47086716
[1960]    <string>Sybase - iAnywhere</string>



00000561
30.47086716
[1960]    <key>PayloadOrganization</key>



00000562
30.47086716
[1960]    <string>Sybase - iAnywhere</string>



00000563
30.47086716
[1960]    <key>PayloadUUID</key>



00000564
30.47086716
[1960]    <string>f274c1e7-f8e6-4385-b912-964f4d77c85d</string>



00000565
30.47086716
[1960]    <key>PayloadVersion</key>



00000566
30.47086716
[1960]    <integer>1</integer>



00000567
30.47086716
[1960]   </dict>



00000568
30.47086716
[1960]   <dict>



00000569
30.47086716
[1960]   <key>PayloadCertificateFileName</key>



00000570
30.47086716
[1960]   <string></string>



00000571
30.47086716
[1960]   <key>PayloadContent</key>



00000572
30.47086716
[1960]   <data>



00000573
30.47086716
[1960] MIIDizCCAnOgAwIBAgIQQFqpP6YTg59J3MO6GZPxEzANBgkqhkiG9w0BAQUFADBMMRIwEAYKCZIm



00000574
30.47086716
[1960] iZPyLGQBGRYCaW4xFzAVBgoJkiaJk/IsZAEZFgdTZXJ2UHJvMR0wGwYDVQQDExRTZXJ2UHJvLVNF



00000575
30.47086716
[1960] UlZQUk82Ni1DQTAeFw0xNDAxMDIxMzIzNTRaFw0xOTAxMDIxMzMzNTBaMEwxEjAQBgoJkiaJk/Is



00000576
30.47086716
[1960] ZAEZFgJpbjEXMBUGCgmSJomT8ixkARkWB1NlcnZQcm8xHTAbBgNVBAMTFFNlcnZQcm8tU0VS



00000577
30.47122955
[1960] VlBS



00000578
30.47122955
[1960] TzY2LUNBMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAr+zGISN7p8QN6aEyPmV9isDn



00000579
30.47122955
[1960] F5nm/cfctDh3/jnf0Ha5YXLGfRohlFP0ccOA9iyx7eZ8MMyMWfukNUW3QmCyJeQKpRC32q0ue8rC



00000580
30.47122955
[1960] KE5Qo54DAag0s7AS8mLaWY1K5jw+nkiyPXkUbXW6gCu3r+XINO558yx+9RQ+lyVnsMihLA3XttBe



00000581
30.47122955
[1960] eNETtjLsT/sPsOBctX1/2ThgehMDrpH06uWVZqTZq4M+jTvIg3dy4DczZZ3tVD94E1zH+Zz+ZJRW



00000582
30.47122955
[1960] JI+q0fL9jBq+pnAU8zte8TGkezi4FH96jlg4xCC9pb/fLO+zxp5eLGf/M+0wBcDH8IkZWo41eWrs



00000583
30.47122955
[1960] JtNAO522M3BuewIDAQABo2kwZzATBgkrBgEEAYI3FAIEBh4EAEMAQTAOBgNVHQ8BAf8EBAMCAYYw



00000584
30.47122955
[1960] DwYDVR0TAQH/BAUwAwEB/zAdBgNVHQ4EFgQU2VC/vYfXmb2vPu96YGKXWpXC0N0wEAYJKwYBBAGC



00000585
30.47122955
[1960] NxUBBAMCAQAwDQYJKoZIhvcNAQEFBQADggEBAKDRTHpbzcgio5gmOTZOWXtQpbeWaJw8/ujZ9d6i



00000586
30.47122955
[1960] FfayOUidiO1JFJEyFjGPgTdIV2dEaTT+46yJ1OLGtnbN4VZzXtEPQ4pCWhdKRyAFfnR3zlrAIUTy



00000587
30.47122955
[1960] BTRdvrPFhpclBO/zWX5BQhiewfluEzaX6UgYVepC1VoIJP6PWzDRBLpRGP8P0N2VfvTg20rNzQSS



00000588
30.47122955
[1960] V8O9UO8nuaa5tkGdoPqzL07xNEBrnAPOkGrZPr4TbEwINKDMjlDap2E8exHk+/qMsA+SaYbdEku2



00000589
30.47122955
[1960] k0VLLQqDkT4LRVnLp7c7eXe5JexP2+7KAkehUia9kjguDgCb9PPswRXwxeQmIiLRfmEI07GEYT4=



00000590
30.47122955
[1960]   </data>



00000591
30.47122955
[1960]   <key>PayloadDescription</key>



00000592
30.47122955
[1960]   <string>Provides SSL cert chain.</string>



00000593
30.47122955
[1960]   <key>PayloadDisplayName</key>



00000594
30.47122955
[1960]   <string>servpro70.servpro.in</string>



00000595
30.47122955
[1960]   <key>PayloadIdentifier</key>



00000596
30.47122955
[1960]   <string>com.servpro70.servpro.in.SetupSslCertChain</string>



00000597
30.47122955
[1960]   <key>PayloadOrganization</key>



00000598
30.47122955
[1960]   <string>Sybase - Configure</string>



00000599
30.47122955
[1960]   <key>PayloadType</key>



00000600
30.47122955
[1960]   <string>com.apple.security.root</string>



00000601
30.47122955
[1960]   <key>PayloadUUID</key>



00000602
30.47122955
[1960]   <string>90e78f64-32de-4d05-80bf-9b2d8f306394</string>



00000603
30.47122955
[1960]   <key>PayloadVersion</key>



00000604
30.47122955
[1960]   <integer>1</integer>



00000605
30.47122955
[1960]   </dict>



00000606
30.47122955
[1960]  </array>



00000607
30.47122955
[1960]  <key>PayloadDescription</key>



00000608
30.47122955
[1960]    <string>mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5</string>



00000609
30.47122955
[1960]  <key>PayloadDisplayName</key>



00000610
30.47122955
[1960]    <string>mdm-116113a8f8dad3e44aa97e0a419c3627cfd672a5</string>



00000611
30.47122955
[1960]  <key>PayloadIdentifier</key>



00000612
30.47122955
[1960]  <string>Sybase - iAnywhere</string>



00000613
30.47122955
[1960]  <key>PayloadOrganization</key>



00000614
30.47122955
[1960]  <string>Sybase - iAnywhere</string>



00000615
30.47122955
[1960]  <key>PayloadRemovalDisallowed</key>



00000616
30.47122955
[1960]  <false/>



00000617
30.47122955
[1960]  <key>PayloadType</key>



00000618
30.47122955
[1960]  <string>Configuration</string>



00000619
30.47122955
[1960]  <key>PayloadUUID</key>



00000620
30.47122955
[1960]    <string>afc8e404-91c2-45c7-aad8-54f0b33ff8e5</string>



00000621
30.47122955
[1960]  <key>PayloadVersion</key>



00000622
30.47122955
[1960]  <integer>1</integer>



00000623
30.47122955
[1960] </dict>



00000624
30.47122955
[1960] </plist>



00000625
30.47122955
[1960]  



00000626
30.47145653
[1960] thread:98 time: 2014/11/06 19:23:16 <SQL SetCertificateAndGetPolicies: Select * from A_IPHONE_DEVICE where ClientUID=@cwe_ClientUID  << SetCertificateAndGetPolicies.SetCertificateAndGetPolicies.UpdateSignMdmMessages, Params: 249



00000627
30.47252083
[1960] thread:98 time: 2014/11/06 19:23:16 <SQL SetCertificateAndGetPolicies: Update A_IPHONE_DEVICE Set SignMdmMessages=@cwe_SignMdmMessages Where ClientUID=@cwe_ClientUID << SetCertificateAndGetPolicies.SetCertificateAndGetPolicies.UpdateSignMdmMessages, Params: 10, 249



00000628
30.50518799
[1960] thread:98 time: 2014/11/06 19:23:16 OTA delivery of Mdm Configuration Profile.



00000629
30.50540161
[1960] thread:98 time: 2014/11/06 19:23:16 SetCertificateAndGetPolicies Connection Log Entry:



00000630
30.50540161
[1960]   DeviceTableID: 249



00000631
30.50540161
[1960]   Action: Mdm Provisioned.



00000632
30.50540161
[1960]   Data: CN = 116113A8F8DAD3E44AA97E0A419C3627CFD672A5



00000633
30.50559616
[1960] thread:98 time: 2014/11/06 19:23:16 <SQL LogConnectionState: insert into A_IPHONE_LOG ( ClientUID, TimeStamp, Action, Data, ConnectionID ) values (@cwe_ClientUID, @cwe_TimeStamp, @cwe_Action, @cwe_Data, @cwe_ConnectionID) << LogConnectionState.connectionLogInsert, Params: 249, 11/6/2014 7:23:16 PM, Mdm Provisioned., CN = 116113A8F8DAD3E44AA97E0A419C3627CFD672A5, {c6a260ef-0919-430c-959b-f85f6d188cdf}



00000634
30.53024292
[1960] thread:98 time: 2014/11/06 19:23:16  RunSQL return <<connectionLogInsert



00000635
30.53041840
[1960] thread:98 time: 2014/11/06 19:23:16 <SQL SetCertificateAndGetPolicies: Select * From A_IPHONE_PAYLOADTYPE << SetCertificateAndGetPolicies.PayloadTypeInfo



00000636
30.53190422
[1960] thread:98 time: 2014/11/06 19:23:16  RunSQL return <<PayloadTypeInfo



00000637
30.53202248
[1960] thread:98 time: 2014/11/06 19:23:16  update IPhoneSCEPEnrollRequestInfo



00000638
30.53219223
[1960] thread:98 time: 2014/11/06 19:23:16



00000639
30.53219223
[1960]  >>> getScepUriCrqInfoAndSigningCertName entry



00000640
30.53732872
[1960] thread:98 time: 2014/11/06 19:23:16



00000641
30.53732872
[1960]  >>> getScepUriCrqInfoAndSigningCertName exit



00000642
30.53742409
[1960] thread:98 time: 2014/11/06 19:23:16 CaName: ServPro-SERVPRO66-CA



00000643
30.53750992
[1960] thread:98 time: 2014/11/06 19:23:16 CommonName:  



00000644
30.53759384
[1960] thread:98 time: 2014/11/06 19:23:16 OrganizationName:  



00000645
30.53767586
[1960] thread:98 time: 2014/11/06 19:23:16 OrganizationUnit:  



00000646
30.53775978
[1960] thread:98 time: 2014/11/06 19:23:16 City:  



00000647
30.53784370
[1960] thread:98 time: 2014/11/06 19:23:16 State:  



00000648
30.53793335
[1960] thread:98 time: 2014/11/06 19:23:16 Country: IN



00000649
30.53870964
[1960] thread:98 time: 2014/11/06 19:23:16  update IPhoneDatabaseRow



00000650
30.53887749
[1960] thread:98 time: 2014/11/06 19:23:16 <SQL SetCertificateAndGetPolicies: Select * From A_IPHONE_SETTINGS Where TenantID=@cwe_TenantID << SetCertificateAndGetPolicies.setCertAndGetPolicySigingCertQuery, Params: 0



00000651
30.53992271
[1960] thread:98 time: 2014/11/06 19:23:16  RunSQL return <<setCertAndGetPolicySigingCertQuery



00000652
30.54002190
[1960] thread:98 time: 2014/11/06 19:23:16 SetCertificateAndGetPolicies - no cert no encryption -disabling EncryptPayload



00000653
30.54182053
[1960] thread:98 time: 2014/11/06 19:23:16



00000654
30.54182053
[1960]  >>> IPhoneConfigs SetCertificateAndGetPolicies exit



00000655
30.54193687
[1896] thread:9 time: 2014/11/06 19:23:16 payloadInfoValid types[28] xml[1]



00000656
30.54246140
[1896] thread:9 time: 2014/11/06 19:23:16  iPhonePayloadKeyValuePairs.validatePayloads input[1]



00000657
30.54255295
[1896] thread:9 time: 2014/11/06 19:23:16  iPhonePayloadKeyValuePairs.validatePayloads added Paylod[1]



00000658
30.54409218
[1896] thread:9 time: 2014/11/06 19:23:16  iPhonePayloadKeyValuePairs.validatePayloads output[1]



00000659
30.54421997
[1896] thread:9 time: 2014/11/06 19:23:16 msPkcs7Io.applySignature: SignerCertName null or empty



00000660
30.54431343
[1896] thread:9 time: 2014/11/06 19:23:16 sendMessage HttpStatusCode.OK



00000661
30.54465675
[1896] thread:9 time: 2014/11/06 19:23:16 sendEvent: configRequest FAILED



00000662
42.80034256
[1896] thread:9 time: 2014/11/06 19:23:28 Request to GetSCEP: http://servpro90.servpro.in/aips2/aipService.svc/scep?id=SkFORUlNRE1DTUxJREhLRk5ISk1MQU9BR09QS0hERlB...



00000663
42.80449677
[1896] thread:9 time: 2014/11/06 19:23:28 parseSCEPrequest ret: True cmd: GetCACert



00000664
42.86244965
[1896] thread:9 time: 2014/11/06 19:23:28 getAfariaSCEP ret: True http: 200



00000665
43.22447205
[1896] thread:9 time: 2014/11/06 19:23:29 Request to GetSCEP: http://servpro90.servpro.in/aips2/aipService.svc/scep?id=SkFORUlNRE1DTUxJREhLRk5ISk1MQU9BR09QS0hERlB...



00000666
43.22495651
[1896] FRkFCQzAwDQYJKoZIhvcNAQEBBQAEggEAAo34kxn3Gq9MB1YIcoDUmmi7o773E32I7QPm1q%2F1b2omNO0X0IiA9CZYFvRwxp7KlX8xgJy2ZlyAnc1pKTge3H%2FuJXQTxqVdW8neK31VtjCso8%2BXgCKvx6arB2zWIzHlTDtjQmrhqJxMNsm2Nj4d8sizlNqtJLoQ0BXsWU4X4xCBloiz9uEbYNkh4BxKdtcc08uqtXxEW32H1fXz0cptxt1K%2BOK%2ByGx7aozjkXUMrDNk3%2FhNQJ1EWjLt1cdLmf9zx2Z9Ykz%2Bxb8YKTmgOkZEzzlPNS9ZTUb3L1KNhS4z9wyIDRPkAd%2Bs2XwK2oRgfmG1a4wfOpQ2cJr9Mb1FvAPDPwAAAAAAAA%3D%3D



00000667
43.22700119
[1896] thread:9 time: 2014/11/06 19:23:29 parseSCEPrequest ret: True cmd: PKIOperation



00000668
43.31298828
[1960]  lookup Id: {9cceeeee-4f62-4be2-86b6-10c08852a06e}



00000669
43.60902023
[1896] thread:9 time: 2014/11/06 19:23:29 getAfariaSCEP ret: True http: 200



00000670
44.02404404
[1896] thread:9 time: 2014/11/06 19:23:30 PUT TokenCheckin Request



00000671
44.02688980
[1896] thread:9 time: 2014/11/06 19:23:30 >>> getSignedMDMpacket : Mdm-Signature



00000672
44.03394318
[1896] thread:9 time: 2014/11/06 19:23:30 getSignedMDMpacket msPkcs7Io.verifyDetachedSignature : msPkcs7Io.verifyDetachedSignature.x509:



00000673
44.03394318
[1896] CryptographicException SignedCms.CheckSignature:



00000674
44.03394318
[1896] The revocation function was unable to check revocation because the revocation server was offline.



00000675
44.03394318
[1896]  



00000676
44.03496170
[1896] thread:9 time: 2014/11/06 19:23:30 getSignedMDMpacket Elapsed time: 00:00:00.0099300



00000677
44.05009460
[1960] thread:98 time: 2014/11/06 19:23:30



00000678
44.05009460
[1960]  >>> LogMessage exit



00000679
44.05019379
[1896] thread:9 time: 2014/11/06 19:23:30 iPhoneInputParser.parseCheckinData: True



00000680
44.05083084
[1896] thread:9 time: 2014/11/06 19:23:30 TokenCheckin x509: null



00000681
44.05808640
[1960] thread:98 time: 2014/11/06 19:23:30



00000682
44.05808640
[1960]  >>> LogMessage exit

[keith_nunn]

Tushar,

Here's the problem you're facing:

00000672	44.03394318	[1896] thread:9 time: 2014/11/06 19:23:30 getSignedMDMpacket msPkcs7Io.verifyDetachedSignature : msPkcs7Io.verifyDetachedSignature.x509:
00000673	44.03394318	[1896] CryptographicException SignedCms.CheckSignature:
00000674	44.03394318	[1896] The revocation function was unable to check revocation because the revocation server was offline.
00000675	44.03394318	[1896]
00000676	44.03496170	[1896] thread:9 time: 2014/11/06 19:23:30 getSignedMDMpacket Elapsed time: 00:00:00.0099300
00000677	44.05009460	[1960] thread:98 time: 2014/11/06 19:23:30
00000678	44.05009460	[1960]  >>> LogMessage exit

Please review KBAs 2072565 and 2058762 for potential solutions.

Thanks,

Keith Nunn
SAP Active Global Support
SAP Canada

[Former Member]

Hi Keith, We are now able to install MDM payloads on the ios devices. Followed the steps to enable the CRL on the CA server: http://service.sap.com/sap/support/notes/2073302 😄 Thanks to ALL Tushar Shetty

[Former Member]

Hi All,

We are facing the issue with the iOS device enrollment as the profile fails to install on the iOS device.

We are using a self-signed ssl certificate which is also placed in the device. The device shows below prompt:

"Profile Installation Failed"

Profile failed to Install

Attached is the device logs.

Hope we will hear from you soon.

Thanks,

Tushar Shetty   

Afaria log03112014.zip

[Former Member]

Are you using SCEP for Native MS for your CA server ?

In any case you should be able to go to http(s)://<ca server>/certsrv/ or http(s)://<ca server>/certsrv/mscep from your Afaria server.

Does this work ?

Peter

[Former Member]

Hi Peter,

We are using a Enterprise Root CA. Type : SCEP.

Regards,

Tushar

[Former Member]

Is the device (hardware) already in the system? Then delete it and retry enrollment

BR

Peter

[Former Member]

We do delete the devices from the server, every time we try the enrollment.

Thanks,

Tushar

[Former Member]

Hi,

As per observation CA server event viewer shows below two events when the device hits the server for enrollment.

The Network Device Enrollment Service cannot decode the http message from the client (0x8007000d).  The data is invalid. Event ID 16

The Network Device Enrollment Service received an http message without the "Operation" tag, or with an invalid "Operation" tag. Event ID 11

Hope this will help us to resolve this 😐

Regards,

Tushar

[Former Member]

Try to attach the device to Apple iPhone Configuration Utility and look at the console log and get the actual error. Then post the error code here 🙂

[nick_mackerness]

Boopalan, please follow Peter's advice to get the ICU log, so we can see why the Profile Failed to Install. 

There are quite a few reasons why this error might get raised, but it is often related to the certificate and/or CA server. 

Further details about getting the log can be found in the following KBA:

  http://service.sap.com/sap/support/notes/1713455

[Former Member]

Hi Peter,

Does it required mac system ? i dont have any mac system to attach Apple iPhone Configuration Utility and look at the console log.

Thanks,

Boopalan.M

[Former Member]

No, Windows or Mac will do fine :

iPhone Configuration Utility 3.6.2 for Windows

Peter

[Former Member]

Thanks Peter,

Got the error msg as below:

https://<host>:443/ias_relay_server/client/rs_client.dll/QAEnrollFarmId/aips2/aipService.svc/TokenCheckin failed with error: NSError:

Desc   : The server certificate for “https://<host>:443/ias_relay_server/client/rs_client.dll/QAEnrollFarmId/aips2/aipService.svc/TokenCheckin” is invalid.

US Desc: The server certificate for “https://<host>:443/ias_relay_server/client/rs_client.dll/QAEnrollFarmId/aips2/aipService.svc/TokenCheckin” is invalid.

Domain : MCHTTPTransactionErrorDomain

Code   : 23002

Type   : MCFatalError

Params : (

     "https://<host>:443/ias_relay_server/client/rs_client.dll/QAEnrollFarmId/aips2/aipService.svc/TokenCheckin"

)

Mar 19 17:34:52 iPhone profiled[396] <Notice>: (Error) MDM: Cannot Authenticate. Error: NSError:

Desc   : The server certificate for “https://<host>:443/ias_relay_server/client/rs_client.dll/QAEnrollFarmId/aips2/aipService.svc/TokenCheckin” is invalid.

US Desc: The server certificate for “https://<host>:443/ias_relay_server/client/rs_client.dll/QAEnrollFarmId/aips2/aipService.svc/TokenCheckin” is invalid.

Domain : MCHTTPTransactionErrorDomain

Code   : 23002

Type   : MCFatalError

Params : (

     "https://<host>:443/ias_relay_server/client/rs_client.dll/QAEnrollFarmId/aips2/aipService.svc/TokenCheckin"

Thanks,

Boopalan.M

[Former Member]

Does the log actually says: https://<host>:443/ or did you replace to hide your server ?

If you have "<host>" then you need to configure the correct FQDN in your enrollment server config page in Afaria Admin UI: Server, Settings, Enrollment Server

BR

Peter

[Former Member]

sorry forgot to point out.

i replaced my relay server's public ip address there.

Thanks,

BM

[Former Member]

It seems that you ssl cert doesn't match the common name on the relay server.

Can you type https://<host>:443/ias_relay_server/client/rs_client.dll in an outside browser (perhaps Safari on an 3G iOS device) does that work without certificate errors ?

Peter

[Former Member]

You can send the actual host in a private message to me also...