Blackboard

Ask Dr. C Logo

Blackboard Learn 9.0.505.15 on Windows XP

rated by 0 users
Answered (Verified) This post has 1 verified answer | 3 Replies | 2 Followers

Top 150 Contributor
2 Posts
Kilimanjaro posted on 8 Feb 2010 10:16 AM

I'm trying to install Blackboard Learn 9.0.505.15 from scratch on a testmachine with Windows XP Professional, IIS, SQL Server 2008 Express, Java 1.6 Update 18, .Net Framework 2.0 and 3.0.

I've read many articles about installing Blackboard Academic Suite and Learn on Windows XP for testing/development purposes. I did configure all stuff exactly according to the manuals and tips (environment variables, installation paths, IIS, SQL Server properties, etcetera).

Issue is that installation goes fine, but keeps at 67%, last line in log file 'bb-installer-log' is:

  ------------- Create Database bb_bb60_report -------------
Running "create_activity_accumulator_job.sql.template" for "bb_bb60" schema...

At this momet the SQL Server Management Studio activity monitor reports of Recent Expensive Queries like fetching and quering with CPU level on 40% average. The bb_bb60 database does not grow in bytes as for the SQL databases.

I've tried installing it several times from scratch, even waiting 40 hours to see if it completes from this point, but no luck. No report in logs of 'build failed' and whatsoever, everything seems to go fine to this fine. Something goes wrong with creating the activity_accumulator_job.sql.template I assume.

Anyone any ideas on this (?),
besides telling me it isn't possible to install on a XP Professional machine.

Answered (Verified) Verified Answer

Top 10 Contributor
81 Posts

Hi,

In addition to Mike's suggestions, the problem may be with SQL Server 2008 Express. I don't know about Bb Learn 9.0 and SQL Server Express but Blackboard Vista/CE 8.0 require a minimum of SQL Server 2005 Standard, not Express.

You may want to look at trying SQL Server 2008 Standard as a minimum database system.

On my test systems, it's Windows 2003 Server, SQL Server 2005 Standard for both my Bb Learn 9.0 and Bb Vista/CE installations.

Cheers,

Bob

All Replies

Top 10 Contributor
Male
192 Posts

I assume you're looking at the developer version installation instructions here:

http://www.edugarage.com/display/BBDN/Installing+Academic+Suite+-+Developer+Edition

The instructions are for SQL Server 2005, not 2008.  To be honest, I don't know how different they are--I don't have any experience with SQL 2008--but since the supported technology specs at http://kb.blackboard.com/display/DOCS/Supported+Technologies+9.0+SP2 show SQL 2008 as only "Compatible" rather than "Certified", I'd start by trying to see if you don't have better luck with SQL 2005 Express Edition.

Since the error does seem to be happening on the SQL side, look to see if the bbadmin, bb_bb60, bb_bb60_stats databases are being created.  You might also look at error logs besides the install log.  I think you'll want to particularly look at schema-log.txt and sqlerror-log.txt

Mike

Top 10 Contributor
81 Posts

Hi,

In addition to Mike's suggestions, the problem may be with SQL Server 2008 Express. I don't know about Bb Learn 9.0 and SQL Server Express but Blackboard Vista/CE 8.0 require a minimum of SQL Server 2005 Standard, not Express.

You may want to look at trying SQL Server 2008 Standard as a minimum database system.

On my test systems, it's Windows 2003 Server, SQL Server 2005 Standard for both my Bb Learn 9.0 and Bb Vista/CE installations.

Cheers,

Bob

Top 150 Contributor
2 Posts

Fixed it with SQL Server 2008 Standard. So you were absolutly right!

With Procmon.exe I found out that activity acumulator is a SQL Server Agent job, and the Agent can't start in Express edition. It keeps trying to create the job but finds out the Agent isn't available and then it tries it again and again. BB9 'hangs' at 67%.

I'm running BB9 on a Windows XP Professional 32-bit with IIS 5.1, and it's running smoothly and extremely fast on my laptop with 2GB. Had to lower the max heap size in BB properties btw.

Page 1 of 1 (4 items) | RSS