Client Management Suite

 View Only

  • 1.  Altiris Error while deploying Package Server

    Posted Jun 26, 2013 06:01 AM

    Hi,


    We tried to configure a Package Server in our Altiris environment. While going through the logs we found the following error:

     

    <event date="Jun 25 04:34:22 +00:00" severity="2" hostName="xxx" source="Altiris.NS.ResourceManagement.Database.DataLoaderSqlClientInserter.ExecuteBatch" module="AeXSVC.exe" process="AeXSvc" pid="1276" thread="35" tickCount="23865204"><![CDATA[Failed to insert row into table ( INSERT INTO dbo.[Evt_NS_Scheduled_Event] ([_ResourceGuid],[ItemName],[ItemGuid],[StartTime],[TickCount],[_eventTime]) VALUES (N'21c5b59d-1cbb-4c32-b255-77e309804ef0',N'Policy Filter Update',N'{c1aa60e3-43cf-49b8-a7cb-8531b06bf871}',N'1434-08-16 07:34:20',N'0',N'1434-08-16 07:34:22.190') ) Line Error: System.Data.SqlClient.SqlError: The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
    **CEDUrlStart** :http://entced.symantec.com/entt?product=SMP&version=7.1.8400.0&language=ar&module=qEPgIkM+lsiAeLHrNINNL9D6AgEJoSSmuS0Qo7WlSzor2vhOVUBUibOorcXjridC&error=-52648456&build=**CEDUrlEnd**
     
    Can anyone please help in this regard?


  • 2.  RE: Altiris Error while deploying Package Server

    Posted Jul 05, 2013 03:22 AM
    try this, http://www.symantec.com/docs/HOWTO4752


  • 3.  RE: Altiris Error while deploying Package Server

    Posted Jul 15, 2013 05:37 PM

    Hi Sachin, actually we have spent nearly 20 days with Symantec Enterprise Support and the Backline Team but the problem did not get resolved. 

    The problem was that while creating the Package Server the Notification Server use to insert the date in the DB from the system date. The NS OS was imaged on Arabic calendar and system locale with the current year being 1434. SQL replied that it required a date range above 1900.

    We even changed the calendar and system locale back to English (US) and still the problem persisted.

    It is an unknown problem. Support also uploaded the following KB article:

    http://www.symantec.com/business/support//index?page=content&id=TECH208192&actp=RSS

    Unfortunetly, this didnt work at all and we had to tell the customer that the Production Servers OS needs to be rebuilt with calendar and system locale in English (US).

    So the solution was that:

    Make sure that the OS of all the servers where Altiris components are installed must have calendar, and more importantly system locale in English (US).