Error executing SQL statement: insert into #x_task values... when importing job

Article:TECH167229  |  Created: 2011-08-16  |  Updated: 2012-07-21  |  Article URL http://www.symantec.com/docs/TECH167229
Article Type
Technical Solution

Product(s)

Issue



After exporting a Deployment Solution Job from the Console or via axExport.exe tool successfully you receive the message: Error executing SQL statement: insert into #x_task values, when trying to reimport the same job.


Environment



Deployment Solution 6.9  installed on a English version of Windows server 2003 operating system configured with any other Regional settings but English

 


Solution



1) Go to Administrative Tools, open Data sources (ODBC)

2) Select System DSN and click "Configure"  on the Altiris eXpress Database, click "Next"  three times.

3) uncheck the "Use regional settings when outputting currency, numbers, dates and times." option, click finish and Test Data Sources.

4) Close and reopen the Deployment console, now you should be able to export and re-import the jobs successfully. 

 


Attachments

Error executing SQL statement.bmp (233 kBytes)


Article URL http://www.symantec.com/docs/TECH167229


Terms of use for this information are found in Legal Notices