(imported topic written by sgdevworks)
Hello,
the import of my customers TEM SUA keeps failling with the following messages in the log:
Logfile created on Wed Jan 18 10:12:54 +0100 2012 by /
ETL Started: Wed Jan 18 10:12:54 +0100 2012
ETL was started by : admin
DSS:SAM version: 1.3.1.597
Refresh datasource properties Total: 4.234000 0.000000 4.234000 ( 6.312000)
BESETL setup/cleanup Total: 0.000000 0.000000 0.000000 ( 0.000000)
ETL stage failed for datasource xxx SUA
Etl.exe Total: 0.000000 0.000000 0.000000 ( 0.297000)
CREATE TABLE tmp_affected_computer_properties (computer_id int, property_id int)
“./bin/BulkLoad.exe” “tmp/properties_computer_ids.csv” SRV-MSSQL2K8 BFInventory tmp_affected_computer_properties -d -U sa -P MASKED
DELETE FROM computer_properties WITH (TABLOCK)
FROM tmp_affected_computer_properties AS foo
WHERE computer_properties.computer_id = foo.computer_id
AND computer_properties.property_id = foo.property_id
This occurs during scheduled and adhoc imports. We’ve restarted the server but this doesn’t help.
We urgently need to solve this. Any ideas?
Sonja Gresser