Can anyone suggest what could be the possible reason for the failure of BFI import.
This is the very first import after the installation…
The system is having sufficient memory so I assume that is not the problem here.
Below is the log file generated.
# Logfile created on 2017-12-30 09:58:19 +0000 by logger.rb/v1.2.7
2017-12-30 09:58:19 (+0:00:00.000) INFO: BFI version: 9.2.10.0-20171213-1141
2017-12-30 09:58:19 (+0:00:00.002) INFO: All times in log are in UTC time zone!
2017-12-30 09:58:19 (+0:00:00.000) INFO: Import created at (UTC): 2017-12-30 09:58:19 UTC
2017-12-30 09:58:19 (+0:00:00.002) INFO: Import type: complete
2017-12-30 09:58:19 (+0:00:00.000) INFO: Local server timezone: CurrentTimeZone=330 (UTC+05:30) DaylightBias=-60
2017-12-30 09:58:19 (+0:00:00.047) INFO: Check datasources connectivity: Start
2017-12-30 09:58:20 (+0:00:00.182) INFO: Data Source: Data Source, Bigfix Server Version: 9.5.5.193 with schema: 9.44, DB Version: 10.50.4000.0 SP2 Enterprise Evaluation Edition (64-bit)
2017-12-30 09:58:20 (+0:00:00.001) INFO: Check datasources connectivity: Success
2017-12-30 09:58:21 (+0:00:01.326) INFO: Calling Model.before_snapshot: Start
2017-12-30 09:58:22 (+0:00:01.045) INFO: Calling Model.before_snapshot: Success
2017-12-30 09:58:22 (+0:00:00.001) INFO: Install software catalog to staging tables: Start
2017-12-30 09:58:34 (+0:00:11.672) INFO: Install software catalog to staging tables: Failed
2017-12-30 09:58:34 (+0:00:00.000) ERROR: Sequel::DatabaseError: DBNAME: temadb - Java::ComMicrosoftSqlserverJdbc::SQLServerException: Internal Query Processor Error: The query processor encountered an unexpected error during execution.
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(com/microsoft/sqlserver/jdbc/SQLServerException.java:258)
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:1535)
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:845)
com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:752)
com.microsoft.sqlserver.jdbc.TDSCommand.execute(com/microsoft/sqlserver/jdbc/IOBuffer.java:7151)
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(com/microsoft/sqlserver/jdbc/SQLServerConnection.java:2478)
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:219)
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:199)
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:680)
java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:508)
Sequel::JDBC::Database.execute(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/adapters/jdbc.rb:268)
Sequel::JDBC::Database.execute(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/adapters/jdbc.rb:268)
Sequel::Database.log_yield(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/database/logging.rb:37)
Sequel::Database.log_yield(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/database/logging.rb:37)
Sequel::Database.log_yield(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/database/logging.rb:36)
Sequel::Database.log_yield(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/database/logging.rb:36)
Sequel::JDBC::Database.execute(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/adapters/jdbc.rb:268)
Sequel::JDBC::Database.execute(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/adapters/jdbc.rb:268)
Sequel::JDBC::Database.statement(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/adapters/jdbc.rb:672)
Sequel::JDBC::Database.statement(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/adapters/jdbc.rb:672)
Sequel::JDBC::Database.execute(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/adapters/jdbc.rb:251)
Sequel::JDBC::Database.execute(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/adapters/jdbc.rb:251)
Sequel::ThreadedConnectionPool.hold(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/connection_pool/threaded.rb:110)
Sequel::ThreadedConnectionPool.hold(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/connection_pool/threaded.rb:110)
Sequel::Database.synchronize(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/database/connecting.rb:254)
Sequel::Database.synchronize(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/database/connecting.rb:254)
Sequel::JDBC::Database.execute(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/adapters/jdbc.rb:250)
Sequel::JDBC::Database.execute(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/adapters/jdbc.rb:250)
RUBY.execute_dui(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/dataset/actions.rb:932)
RUBY.delete(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/dataset/actions.rb:122)
RUBY.empty_staging_mssql(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/domains/sam/app/models/sam/catalog.rb:96)
org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613)
RUBY.empty_staging_mssql(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/domains/sam/app/models/sam/catalog.rb:94)
RUBY.empty_staging(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/domains/sam/app/models/sam/catalog.rb:66)
RUBY.stage(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/domains/sam/app/models/sam/catalog.rb:575)
RUBY.Domain(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/domains/sam/domain.rb:617)
org.jruby.RubyProc.call(org/jruby/RubyProc.java:281)
RUBY.run(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/task.rb:11)
RUBY.run_task(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/tasks.rb:38)
RUBY.run_no_txn(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/tasks.rb:51)
org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613)
RUBY.run_no_txn(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/tasks.rb:50)
RUBY.run(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/tasks.rb:20)
RUBY.run(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/runner.rb:67)
RUBY.freeze_date(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/sequel/extensions/date_utils.rb:22)
Sequel::ThreadedConnectionPool.hold(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/connection_pool/threaded.rb:114)
Sequel::ThreadedConnectionPool.hold(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/connection_pool/threaded.rb:114)
Sequel::ThreadedConnectionPool.hold(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/connection_pool/threaded.rb:112)
Sequel::ThreadedConnectionPool.hold(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/connection_pool/threaded.rb:112)
Sequel::Database.synchronize(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/database/connecting.rb:254)
Sequel::Database.synchronize(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-4.24.0.6369d34f70988ff5e2d4489b876d1cc303accdc9/lib/sequel/database/connecting.rb:254)
RUBY.freeze_date(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/sequel/extensions/date_utils.rb:17)
RUBY.run(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/runner.rb:66)
RUBY.within_import(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/runner.rb:162)
RUBY.log_to(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/dss/logger.rb:22)
RUBY.within_import(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/runner.rb:153)
org.jruby.RubyKernel.tap(org/jruby/RubyKernel.java:1858)
RUBY.within_import(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/runner.rb:144)
RUBY.run(C:/Program Files/ibm/BFI/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/runner.rb:38)
java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:508)
RUBY.(:1)
RUBY.(:1)
java.lang.Thread.run(java/lang/Thread.java:785)
2017-12-30 09:58:34 (+0:00:00.011) INFO: Import failed in 0:00:15
2017-12-30 09:58:34 (+0:00:00.000) INFO: Import contains 1 errors.