Hello guys. I try delete table name Solartec , but show infomration its no existe in data base, whe I execute selec from show table and in Orion server show table too. Same one can help me, In Orion server here I select and show the table. Whe I try delete. In messenger say "not is possible remove the table its not exist or not have permission" but the user is sa.

This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Error to try delete table

cjfranca over 8 years ago

Hello guys.

I try delete table name Solartec, but show infomration its no existe in data base, whe I execute selec from show table and in Orion server show table too.

Same one can help me,

In Orion server

no server.png

here I select and show the table.

base busca.png

Whe I try delete. erro ao deltar.png In messenger say "not is possible remove the table its not exist or not have permission" but the user is sa.

0 bscherer over 8 years ago

solartec is not a table. It looks like you are trying to delete a row from the agentmanagment_agents table.
You want to be very careful makes deletes to the tables in SQL. Is there a reason you cannot remove the agent through the web console? https://yourorionserver/Orion/AgentManagement/Admin/ManageAgents.aspx
Cancel
Vote Up 0 Vote Down

Cancel
0 bscherer over 8 years ago in reply to bscherer

Also, if you want to programmatically delete an agent, i would use the SDK.
something like this. This is powershell btw, but the same thing could be done via REST also.
$swis = connect-swis -swishost OrionServer -trusted
or
$swis = connect-swis -swishost OrionServer -username user -password password
$agentObj = get-swisdata -swisconnection $swis -query "select name,agentid from Orion.AgentManagement.Agent where name = 'solartec'"
Invoke-SwisVerb -SwisConnection $swis -EntityName Orion.AgentManagement.Agent -Verb Delete $agentObj.agentid
Cancel
Vote Up 0 Vote Down

Cancel
0 cjfranca over 8 years ago in reply to bscherer

I need delete all informations solartec in data base, how to can to make this.
Cancel
Vote Up 0 Vote Down

Cancel
0 neomatrix1217 over 8 years ago

You probably can't delete cause it's running and connected why can't you delete it from the web?
Cancel
Vote Up 0 Vote Down

Cancel
0 cjfranca over 8 years ago in reply to neomatrix1217

I do not understand I do not see sense in it. This server agent is showing something from a server that does not exist, the real is solartec2. And so I wanted to delete it at the base.
Cancel
Vote Up 0 Vote Down

Cancel