Hi Cygnus,
With regards to what's taking place, it's not too clear based on the error. Can you try manually running the creation scripts against the catalog?
Here's the order that they should be:
AMS_System_Schema.sql
AMSCreateIndex.sql
AMS_SamplePackagingTemplate.sql
AS_System_Schema.sql
Seed_Data.sql
CustomReportWizard.sql
I suspect one of these will produce the error you're seeing, and give us a better idea as to what the problem is. Make sure to run these scripts against a newly created empty database, as this will have none of the tables the scripts are trying to create.