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

Article:TECH167229  |  Created: 2011-08-16  |  Updated: 2012-07-21  |  Article URL
Article Type
Technical Solution



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.


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



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. 



Error executing SQL statement.bmp (233 kBytes)

Article URL

Terms of use for this information are found in Legal Notices