2 Replies Latest reply on Mar 22, 2017 2:31 PM by Maria00u16wgd0xvx6EOJV1d8

    Load IDT failed exit code -1 in (IIR10.0)

    New Member
      Hello everyone,
      I have my systems in IIR 10.0 and everything worked correctly.
      I have tried to load a new 'system', but it sends me error when loading the ITDs:

       

      >>Error File:

       

      loadit>   Error:                                  Load IDT 'IDT_Transac' failed

      loadit> ErrorLog: [2017-03-16 19:49:38.085905  22] loadit                         > It is now 2017-03-16

      loadit> ErrorLog: [2017-03-16 19:49:38.085900  22] loadit.c     4231 rc          1* thread_entry

      loadit> ErrorLog: [2017-03-16 19:49:38.085900  22] error in loader_thread

      loadit> ErrorLog: [2017-03-16 19:49:38.085899  22] loadit.c     4231 rc          1* thread_entry

      loadit> ErrorLog: [2017-03-16 19:49:38.085899  22] loadit.c     3578 rc          1* loader_thread

      loadit> ErrorLog: [2017-03-16 19:49:38.085899  22] process_loader_queue failed

      loadit> ErrorLog: [2017-03-16 19:49:38.085898  22] loadit.c     3277 rc          1* process_loader_queue

      loadit> ErrorLog: [2017-03-16 19:49:38.085897  22] Load IDT 'IDT_Transac' failed

      loadit> ErrorLog: [2017-03-16 19:49:38.085897  22] loadit.c     3189 rc          1* process_loader_queue

      loadit> ErrorLog: [2017-03-16 19:49:38.085591  22] ssaodbc.c   25032 rc          1* ssadb8_ssaxld_record

      loadit> ErrorLog: [2017-03-16 19:49:38.085588  22] Running DBMS loader failed -1

      loadit> ErrorLog: [2017-03-16 19:49:38.085585  22] ssaodbc.c    1029 rc          1* db_specific

      loadit> ErrorLog: [2017-03-16 19:49:38.085580  22] msq.c        3287 rc          1* db_specific_msq

      loadit> ErrorLog: [2017-03-16 19:49:38.085578  22] msq.c        1482 rc          1* msq_load_do

      loadit> ErrorLog: [2017-03-16 19:49:38.085578  22] spawn.c       911 rc          1* ssaspawn

      loadit> ErrorLog: [2017-03-16 19:49:38.085576  22] spawn.c       760 rc          1* ssa_safe_spawn_ret

      loadit>   Error:..................................Loader [17] aborting

      loadit> ErrorLog: [2017-03-16 19:49:38.102250  17] loadit                         > It is now 2017-03-16

      init>     Error:                                  exit code -1

      init>     ErrorLog:...............................[2017-03-16 19:49:45.629029   1] bin/init    > It is now 2017-03-16 19:49:45.629030

      init>     ErrorLog:   [2017-03-16 19:49:45.627875   1] init.c       1283 rc          1* ssa_main_local

      init>     ErrorLog:    [2017-03-16 19:49:45.627874   1] Spawned task #1 failed with error -1. Check the task's messages

       

       

      >> idsdebug file:

       

      [2017-03-15 22:00:24.157252 ssasrsv                          10] ssarbn.c(2066) ssarbnl_inuse_add: Could not create inuse 'IP                              I'

      [2017-03-15 22:00:24.158705 ssasrsv                          10] ssarbn.c(1905) ssarbnl_inuse_read: inuse record='  '

      [2017-03-15 22:00:24.158943 ssasrsv                          10] ssarbn.c(1924) ssarbnl_inuse_read: Warning: Rulebase 'odb:0:ssa/@IIR' in use by server IP=localhost on port=1668, SSA_RB_RESTART_ID=1507080084

      [2017-03-15 22:00:24.159162 ssasrsv                          10] ssarbn.c(1926) ssarbnl_inuse_read: Warning: Server   started at '2017-03-15 21:49:36.145926' with ID 1480601082

      [2017-03-15 22:00:24.159370 ssasrsv                          10] ssarbn.c(1927) ssarbnl_inuse_read: Warning: Rulebase opened  at '2017-03-15 21:50:22.306945'

      [2017-03-15 22:00:24.159577 ssasrsv                          10] ssarbn.c(1928) ssarbnl_inuse_read: Warning: Rulebase opened  as 'odb:0:ssa/@IIR'

      [2017-03-15 22:00:24.160077 ssasrsv                          10] ssarbn.c(1978) ssarbnl_inuse_read: Warning: Owner information: ip=localhost pid=6944 host='server' ps='2017/03/16 03:49:36.1273'

      [2017-03-15 22:00:24.160306 ssasrsv                          10] ssarbn.c(1994) ssarbnl_inuse_read: Warning: Owner is not running

      [2017-03-15 22:00:24.160518 ssasrsv                          10] ssarbn.c(2008) ssarbnl_inuse_read: Warning: This is an automatic restart

      [2017-03-15 22:02:21.688223 loadit                           16] spawn.c(757) ssa_safe_spawn_ret: Error: spawning 'bcp.exe' failed 'Reason: No such file or directory'

      spawn.c(192) log_parms: pgm_name='bcp.exe'

       

                            

      The system is created without any error, the IDTs are created in the Database, but the index tables are not created, and nor are the data loaded in the IDTS tables.

      The database used by IIR is SQL Server 2012.

       

      I searched the knowledge base, but I do not find anything related that can help me.

       

       

      Any suggestions?

      Thank you.!