My 9.2.7 server is no longer allowing me to remove the items in the Unmanaged Assets database with the XMLUpdate tool. I run the command …
XMLUpdate.exe /deleteAllData "IMPORTED" bes_bfenterprise nt authentication
… I am getting this sql error back…
DBD::ODBC::st execute failed: [Microsoft][SQL Server Native Client 11.0][SQL Server]Error converting data type timestamp to numeric. (SQL-42000)(DBD: st_execute/SQLExecute err=-1) at /PerlApp/Database.pm line 66.
DBD::ODBC::st fetch failed: (DBD: no select statement currently executing err=-1) at /PerlApp/UnmanagedAssetStore.pm line 74.
DBD::ODBC::st execute failed: [Microsoft][SQL Server Native Client 11.0][SQL Server]Error converting data type timestamp to numeric. (SQL-42000)(DBD: st_execute/SQLExecute err=-1) at /PerlApp/Database.pm line 66.
DBD::ODBC::st fetch failed: (DBD: no select statement currently executing err=-1) at /PerlApp/UnmanagedAssetStore.pm line 87.
DBD::ODBC::st execute failed: [Microsoft][SQL Server Native Client 11.0][SQL Server]Error converting data type timestamp to numeric. (SQL-42000)(DBD: st_execute/SQLExecute err=-1) at /PerlApp/Database.pm line 66.
DBD::ODBC::st fetch failed: (DBD: no select statement currently executing err=-1) at /PerlApp/UnmanagedAssetStore.pm line 107.
I found some references from older versions of BigFix and it required a hot fix to resolve at the time. Is anybody else using the XMLUpdate.exe to import and delete unmanaged assets? If so, is it still working on 9.2.7?
Thanks.
-c