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 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

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.",""

Read more...

Environment

  • Afaria Server
  • Afaria Enrollment Server

Product

SAP Afaria 6.6 ; SAP Afaria 7.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.