1810654 - A_IPHONE_DEVICE table does honor the collation/regional settings (Danish\German\French) on the server but the A_INV_IPHONE_AFARIA does not. - Afaria

Starting with the 13th till 31st of a month on MS SQL Server installed with Danish\German\French collation and Afaria database with danish\german\french collation, the A_IPHONE_DEVICE table does honor the collation/regional settings (danish\german\french) on the server but the A_INV_IPHONE_AFARIA does not.

1. Log samples during new Device Rollout:
    
   Afaria Server (captured with DebugVIEW (KB 1713349) ):
   00000135 23.80407333 [1180] 23.02.2012 10:48:55 ClientDAL.RunSQL: Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
   00000136 23.80407333 [1180] Die Anweisung wurde beendet.
   
   iOS Device (captured with iPhoneConfigurationUtility(KB 1713455)
    Feb 23 10:48:56 unknown Afaria[7576] <Warning>: HTTP/1.1 406 Not Acceptable
    Feb 23 10:48:56 unknown Afaria[7576] <Warning>: setStatusLine:"Verbindung fehlgeschlagen
   
   
2. Log samples during existing iOS Device Update:
    
   Afaria Server (data views -> logs -> messages -> all):
    
   "16.02.2012 18:15:07","AFARIASERVER","AfariaService","FATAL","ONS2000: iPhoneClientData:BuildInventoryQueue - Current 'Build inventory queue' for device 'Andreas Kuhn' (address 'andreas.kuhn@test.com'): Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
    Die Anweisung wurde beendet.",""

• Afaria Server
• Afaria Enrollment Server

ons2000,406,not acceptable,ios,mdm,enrollment , KBA , MOB-AFA , Afaria , Problem