Hi;
I am trying to install APM v2.0 and i am getting an error stating that my database includes data from a previous beta(1). I have searched the site and i have seen a post. There was script removing APM tables.I have downloaded it. I am using SQL Server 2005 Express Edition. I couldnt find anywhere to run this script. What should i do? How can solve this problem? Is there a solution different from this?
Can you use Orion Database Manager to run the script? see Start Menu | All Programs | SolarWinds Orion | Database Utilities | Database Manager
i have done it using nodes table and query table and pasted the query. when i refresh the query i got an error message "Can not drop the table APM_Application because it doesnt exist or you dont have permission". What should i do? Is there any other script suiting my problem?
Does Database Manager list any tables that being with "APM_"?
yes it does
can this script be old or is there any new script for this operation?
yilkilicaslan: yes it does
Is one of those APM_Application? You need to remove all the APM_ tables. If APM_Application isn't there then you can remove that line from the script (the drop table APM_Application line).
I have corrected the previous problem removing tables using drop tablename command for each table. It s ok now. Hovewer i am getting an error " Error while executing script-Invalid object name 'information_schema.tables'. What should i do?
Open a support ticket. It sounds like something is odd with your environment.
i can install NPM successfully to the same machine. I cant install APM. I have formatted the machine and re-installed NPM. and then tried to install APM but again the same error:
Error while executing script-Invalid object name 'information_schema.tables'
What is the wrong?
Is your database or database server case sensitive? That might give the error you are seeing.
i am using sql express edition and i dont know how i can set it up.
Execute this query. What does it return?
SELECT CAST((CASE WHEN 'A'='a' THEN 1 ELSE 0 END) AS INT)
result is 1