Error: Populating Lansweeper Database

[Ponchohobono]

I received the following errors when installing 4.0(18/02):

Prerequisites installation status
Error: Populating Lansweeper Database
Error: There is insufficient system memory in resource pool 'internal' to run this query
Lansweeper service install
Error: Error: Starting service: The operation completed successfully

Below is that section from the install log.

2010-03-10 09:23:16.039 ------------ Installing Lansweeper Database ------------
2010-03-10 09:23:16.039 Creating Lansweeper Database...
2010-03-10 09:23:21.175 Creating Lansweeper Database... done.
2010-03-10 09:23:21.185 Building Lansweeper Database Tables...
2010-03-10 09:23:26.074 Building Lansweeper Database Tables... done.
2010-03-10 09:23:26.080 Building Lansweeper Database Views...
2010-03-10 09:23:29.746 Building Lansweeper Database Views... done.
2010-03-10 09:23:29.747 Building Lansweeper Database Procedures...
2010-03-10 09:23:32.060 Building Lansweeper Database Procedures... done.
2010-03-10 09:23:32.061 Populating Lansweeper Database...
2010-03-10 09:25:10.045 Error: Populating Lansweeper Database There is insufficient system memory in resource pool 'internal' to run this query
2010-03-10 09:25:10.119 Create login lansweeperuser...
2010-03-10 09:25:10.659 Create login lansweeperuser... done.
2010-03-10 09:25:10.660 Grant DB access to lansweeperuser...
2010-03-10 09:25:10.872 Grant DB access to lansweeperuser... done.
2010-03-10 09:25:10.873 Add rolemember to lansweeperuser...
2010-03-10 09:25:11.032 Add rolemember to lansweeperuser... done.

I was able to go back in to services & manually start the Lansweeper service. I'm just not sure about the populating database error. Is there anything to look at to see if something is missing from the database?

[Ponchohobono]

Just wanted to add a little more info. "Denali Sites, Inc." is always the last entry added before the error. It is record 3489. Perhaps the "GO" statements just need to be about every 3000 entries.

[Hemoco]

Thanks, we will add a "GO" after each insert

[Ponchohobono]

Thanks joegasper.

The populatedata.sql appears to have been the issue. The section of populating the tsysvendoroid table seems to have been the one it crapped out on. There should probably be a few more GO statements in there to break up all those INSERTS for that table.

Also, I noticed that it let me insert duplicate entries on the tsysreportpages table. Not sure if that should be allowed or not.

[joegasper]

In the installation location (i.e., \program files (x86)\lansweeper) there should be a folder "SQL script" with the operations run against the SQL database. One is called populatedata.sql. If you are comfortable with SQL, you can check a few of the tables against the data in that file (can rerun it manually, too). The query in question is just adding some data to the tables created, should be an intensive operation, but this looks like it relates to your error:

http://www.microsoft.com/technet/support/ee/transform.aspx?ProdName=SQL%20Server&ProdVer=10.0&EvtID=701&EvtSrc=MSSQLServer&LCID=1033