Loading
SLM 9 - Edit computer
Hi! After updating to the SLM 9, we got an error when we try to edit a computer from the portal side: In the Web error log file, found the following error: 09:21:02,403 ERROR COMPUTERDETAILSDATA Could load computer details. [ERRORMESSAGE: Column 'PackageID' does not belong to table ComputerDetailsDataGet9.]   09:21:53,700 ERROR COMPUTERDETAILSDATA Could load computer details. [ERRORMESSAGE: Column 'PackageID' does not belong to table ComputerDetailsDataGet9.]   09:31:18,908 ERROR COMPUTERDETAILSDATA Could load computer details. [ERRORMESSAGE: Column 'PackageID' does not belong to table ComputerDetailsDataGet9.]   09:41:17,243 ERROR COMPUTERDETAILSDATA Could load computer details. [ERRORMESSAGE: Column 'PackageID' does not belong to table ComputerDetailsDataGet9.]   09:41:26,015 ERROR COMPUTERDETAILSDATA Could load computer details. [ERRORMESSAGE: Column 'PackageID' does not belong to table ComputerDetailsDataGet9.]   ‍ ‍ ‍ ‍ ‍ Did you face this issue after updating to the SLM 9?   DUJ didn't help, iisreset too. Any suggestions will be great. BR, Viktors

  • Hi ‌, I have edited computers since the SLM 9 upgrade and not had any problems so far.  Have you tried editing a few different computers? I am wondering if it's data related.  Perhaps you can edit some computers but not others? Regards, David
    • Hi David! I'm also wondering. We have other customers without any problems.  I tried to edit other computers, 1 of 10 was successfully edited. BR, Viktors
  • Hi Viktors, I also didn't notice this error in SLM 9. We could edit computers. I saw this already in SLM 8 when we removed computers and the screen refresh did not work. So this message appeared, when we saw a computer in a list, tried to open details but the computer was already removed. So for me it looks like your data are not consistent, when also another DUJ did not help. Did you check if the Initial DUJ directly after SLM 9 installation worked successfully? Perhaps in tblerrorlog or in Job Activity Monitor some error messages are reported.
    Expand Post
    • Hello Carola! DUJ works correctly after an update - this was the 1st thing what I checked. There are no errors in the DB table and agent monitor. I just raised a support ticket regarding this issue. I will comment back. BR, Viktors
  • Hi Victors,  I think you should file a case with the support if you haven't already done that. There seems to be an error with the data schema for that computer, and I think Support has seen this before. I do not know the solution myself though. 
    • Hi Martin! Yes, I opened a ticket for this issue. I will comment back when I receive a solution. BR, Viktors
      • just another wish: If your ticket is already in process, could you post the agents name for me. I think it does not make sense that two or more agents handle the same problem.
  • Hi Victor, I assume that the "Edit" of a computer starts by getting all the data from tha computer stored in the database. Most of that data can be retreived by Running this query: exec ComputerDetailsDataGet @CID,@ComputerID,0,@UserID This brings apps, Computer Info, all users, VMs, found files, etc ... Maybe you can see if this brings back weird stuff in your case.
    • Hello Samuel could you figure out, which tables are read? It seams my problem comes from table #9 (ComputerDetailsDataGet9), but it is not transparent where the data comes from. So if the table is identified, the corrupt relation could be easily determined. BR Markus
10 of 17

Loading
SLM 9 - Edit computer