SAM Update Failed

system · January 22, 2013, 2:15pm

(imported topic written by SystemAdmin)

Hi,

I ran the most recent SAM update and this failed. Now we have no data in our drill down on the web console other than the custom apps.

I think the issue is that our SQL Database is located on different server to the SAM webserver.

Is there anything I can do to fix this?

Thanks

system · January 22, 2013, 3:15pm

(imported comment written by SystemAdmin)

Here is the output from the batch file

Verifying manifest…

base_packages.csv…OK

80f164596c95c181c5094834fc99dcb3

app_dictionaries.csv…OK

06530f43118659b425a7c0333c50f9f5

base_publishers.csv…OK

bc56a5abf4884fd7c3a116a1e6060c5e

base_executables.csv…OK

d5dbeb770bf952ee9e05c32816c58efb

base_app_executables.csv…OK

913094b5bbb77edb51e7c89b38c7eae3

base_software_title_versions.csv…OK

4ef18ae19632f6671e594dbd10c6ab46

base_app_software_title_versions.csv…OK

560a47c5437e0f2c2a8cd482ba818edf

base_software_titles.csv…OK

606b96d36a2b678c34206a36a9653c7f

base_apps.csv…OK

b91ef9cc63b61c72ca668dc17254bc53

export_info.yml…OK

13cf9ac8b5d3c5de007eb2731395c31a

schema.ini…OK

f002d0f28b7aa9e6912a23b6c7df629a

ReadHashManifest.rb…OK

3a97f8e75497a1aa9f66c13a5493c823

import.rb…OK

f5d106190bf68c1c83ea1100163e7682

install.bat…OK

f4778278615b5f35debbbcacb25905f6

bulkload.bat…OK

b2db5ffe5dc91a7a2e1ac77ef23c74bb

Installing Catalog…

“bin/bulkload.exe” "C:\Program Files (x86)\BigFix Enterprise\DSS\rails\db\Update

/app_dictionaries.csv" “10.51.0.199” BFInventory tmp_app_dictionaries

AUTH NT

Established DB connection.

Loaded dataset.

Records successfully written.

C:\Program Files (x86)\BigFix Enterprise\DSS\rails\db\Update\import.rb:224:in `r

ename’: Permission denied - C:\Program Files (x86)\BigFix Enterprise\DSS\rails\d

b\Update/base_executables.csv or C:\Program Files (x86)\BigFix Enterprise\DSS\ra

ils\db\Update/base_executables.original.csv (Errno::EACCES)

from C:\Program Files (x86)\BigFix Enterprise\DSS\rails\db\Update\import

.rb:224

from C:\Program Files (x86)\BigFix Enterprise\DSS\rails\db\Update\import

.rb:210:in `each’

from C:\Program Files (x86)\BigFix Enterprise\DSS\rails\db\Update\import

.rb:210

from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/1.8/benc

hmark.rb:293:in `measure’

from C:\Program Files (x86)\BigFix Enterprise\DSS\rails\db\Update\import

.rb:208

from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/site_rub

y/1.8/rubygems/custom_require.rb:31:in `eval’

from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8

/gems/rails-2.2.2/lib/commands/runner.rb:45

from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/site_rub

y/1.8/rubygems/custom_require.rb:31:in `gem_original_require’

from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/site_rub

y/1.8/rubygems/custom_require.rb:31:in `require’

from script/runner:3

Catalog import failed. Please refer to the error message above. ###
Possible causes: ###
Is the DSS database online and accessible? ###
Is the catalog directory writable? ###
Is there free disk space? ###
Please follow the instructions in Software Catalog Upgrade Guide. ###

Press any key to continue . . .

system · January 23, 2013, 10:50am

(imported comment written by SystemAdmin)

This was due to a permission issue on one of the folders.

I see this forum doesn’t really get many visits from anyone IBM people?

titan0 · July 21, 2015, 3:33am

Did anyone know how to fix above error?

i got the same error when update the software catalog.

thanks in advance.

MichalPaluch · July 27, 2015, 8:57am

@titan0
Hello,
If you read above “This was due to a permission issue on one of the folders.”

If you can be more specific what your problem is, I can try to help.

titan0 · July 27, 2015, 10:16am

Thanks for your reply.

My error message just a little bit difference, i am sorry for that.

Here is the detail message:

Installing Catalog…
Read secret token with hash -152766479
"bin/bulkload.exe" “C:\Program Files (x86)\BigFix Enterprise\DSS\rails\db\SAMCatalog_47/app_dictiona
ries.csv” “GAD4ITADBSP02\Bigfix” BFInventory tmp_app_dictionaries [AUTH NT]
Established DB connection.
Loaded dataset.
Records successfully written.
C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/acti
ve_record/connection_adapters/abstract_adapter.rb:188:in log': DBI::DatabaseError: Execute (ActiveR ecord::StatementInvalid) OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration o ption. HRESULT error code:0x80020009 Exception occurred.: UPDATE [app_dictionaries] SET [name] = N'Express Metrix', [blessed] = 0, [priority] = -1 WHERE [id] = 1 from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-s qlserver-adapter-1.0.0.9250/lib/active_record/connection_adapters/sqlserver_adapter.rb:337:inexecu
te’
from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-s
qlserver-adapter-1.0.0.9250/lib/active_record/connection_adapters/sqlserver_adapter.rb:317:in updat e_sql' from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2 .2.2/lib/active_record/connection_adapters/abstract/database_statements.rb:49:inupdate_without_que
ry_dirty’
from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2
.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:18:in update' from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2 .2.2/lib/active_record/base.rb:2708:inupdate_without_lock’
from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2
.2.2/lib/active_record/locking/optimistic.rb:70:in update_without_dirty' from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2 .2.2/lib/active_record/dirty.rb:148:inupdate_without_callbacks’
from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2
.2.2/lib/active_record/callbacks.rb:253:in update_without_timestamps' from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2 .2.2/lib/active_record/timestamp.rb:38:inupdate’
from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2
.2.2/lib/active_record/base.rb:2699:in create_or_update_without_callbacks' from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2 .2.2/lib/active_record/callbacks.rb:222:increate_or_update’
from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2
.2.2/lib/active_record/base.rb:2400:in save_without_validation!' from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2 .2.2/lib/active_record/validations.rb:1019:insave_without_dirty!'
from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2
.2.2/lib/active_record/dirty.rb:87:in save_without_transactions!' from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2 .2.2/lib/active_record/transactions.rb:150:insave!'
from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2
.2.2/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in transaction' from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2 .2.2/lib/active_record/transactions.rb:129:intransaction’
from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2
.2.2/lib/active_record/transactions.rb:138:in transaction' from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2 .2.2/lib/active_record/transactions.rb:150:insave!'
from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2
.2.2/lib/active_record/transactions.rb:158:in rollback_active_record_state!' from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/activerecord-2 .2.2/lib/active_record/transactions.rb:150:insave!'
from C:\Program Files (x86)\BigFix Enterprise\DSS\rails\db\SAMCatalog_47\import.rb:186
from C:\Program Files (x86)\BigFix Enterprise\DSS\rails\db\SAMCatalog_47\import.rb:174:in e ach' from C:\Program Files (x86)\BigFix Enterprise\DSS\rails\db\SAMCatalog_47\import.rb:174 from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/site_ruby/1.8/rubygems/custo m_require.rb:31:ineval’
from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/gems/1.8/gems/rails-2.2.2/li
b/commands/runner.rb:45
from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/site_ruby/1.8/rubygems/custo
m_require.rb:31:in gem_original_require' from C:/Program Files (x86)/BigFix Enterprise/DSS/ruby/lib/ruby/site_ruby/1.8/rubygems/custo m_require.rb:31:inrequire’
from script/runner:3

Catalog import failed. Please refer to the error message above.

Possible causes:

Is the DSS database online and accessible?

Is the catalog directory writable?

Is there free disk space?

Please follow the instructions in Software Catalog Upgrade Guide.

MichalPaluch · July 28, 2015, 7:37am

@titan0
I would like to ask you some more details:
what version and edition of SQL database does client use?
which OS edition does client us?
was this a new install or was there any change made recently?
does upgrade catalog ever successful before or this is fist time run catalog upgrade?
what version of catalog upgrade did client run?

Error may suggest database required to enable “clr enabled” configure.

titan0 · August 4, 2015, 11:02am

Thanks for your information.

I am using MS SQL Server 2008 R2.

The SAM installed on Microsoft Server 2008.

Occur the error when i updating the software catalog, this is second time import, last time was fine.

The software catalog upgrade from version 41 to 47.

Confirmed the CLR was enabled on database server.