4 Replies Latest reply on Apr 24, 2012 4:08 PM by tonyjameshart

    Inventory service on server stops

    Apprentice

      I've noticed that every couple of days, the inventory service on the server stops working. I can manually start it and everything will work for a few more days but it will just stop again. I checked the event viewer logs and found:

       

      Database exception: SCA7F1C.SCN, LDInv.dll
      -2147467259
      Data provider or other service returned an E_FAIL status.

       

      Error comitting on table LD_SCHEDULED_TASKS:   DATA PROVIDER OR OTHER SERVICE RETURNED AN E_FAIL STATUS.
           Increased column size might be necessary, Thread ID: 7536.

       

      How can I resolve this? I'm running LDMS 9.0SP2 on Windows2k8R2, database is running on Windows2k3R2 with MSSQL 2005. Thanks

        • 1. Re: Inventory service on server stops
          slyork Rookie

          Hi Tom


          Did you get anywhere with this?  I am seeing similar problems.

          Inventory Service looks like its running, but latest hardware scan shows 2 days ago, the scans have reached the server and are sitting in the normal location.

          When the service is restarted it processes them.

          I am also running LD9 SP2 but on Win 2003/R2 database is also on 2003 R2 I believe.

           

          Regards

           

          Steve

          • 2. Re: Inventory service on server stops
            slyork Rookie

            Well my problem seems to be covered by this

             

            http://community.landesk.com/support/docs/DOC-22421

            • 3. Re: Inventory service on server stops
              Apprentice

              Looking for an update on this. I have now upgraded to SP3 and am still experiencing this issue. I looked at the document posted above, but that only seems applicable to SP2.

               

               

              SCA1094.SCN, LDInv.dll

              -2147217873

              Violation of PRIMARY KEY constraint 'XPK_System_Capability'.

              Cannot insert duplicate key in object 'dbo.SYSTEM_CAPABILITY'.

               

              Error comitting on table SYSTEM_CAPABILITY: VIOLATION OF PRIMARY KEY CONSTRAINT 'XPK_SYSTEM_CAPABILITY'. CANNOT INSERT DUPLICATE KEY IN OBJECT 'DBO.SYSTEM_CAPABILITY'.

              Increased column size might be necessary, Thread ID: 5768

              • 4. Re: Inventory service on server stops
                Apprentice

                The default col size is 255.

                Stop Inventory service

                Edit the DATAMART.XML to allow more characters than the longest scheduled task line.

                run CoreDBUtil.exe /buildcomponents

                Restart the Inventory service.

                put errored scn in parent folder to see if it gets processed.

                If not and It errors again you may need to manually change the col size to be larger that 255.

                So look for all the columns that are 255 in the table of interest and increase accordingly via a SQL statement.