Hello,

I am getting the error below when I "Generate an Application" in the SSABI
excel. The same exact excel file works correctly on another machine. Both
machines have Windows XP SP2, SQL Server 2000 SP3, Analysis Services SP3 and
SSABI v1.2

The only difference I can think of is that the machine with the problem has
SQL Server 2005 Beta installed. Has anyone seen this issue before?

Thanks in advance.

Microsoft Analytics Builder Workbook Logfile
1/4/2005 12:54 Build 1.2.1125.0 (17-June-2003)
1/4/2005 12:54 Processing Database ID: OLAPSMb
1/4/2005 12:54 Testing connection to database servers...
1/4/2005 12:54 Connection test succeeded.
1/4/2005 12:54 Relational database OLAPSMb exists. Relational database
OLAPSMb_Staging exists.
1/4/2005 12:54 Validating Workbook...
1/4/2005 12:54 Workbook validated.
1/4/2005 12:54 Creating directory structure...
1/4/2005 12:54 Created directory structure.
1/4/2005 12:54 Saving a copy of the workbook...
1/4/2005 12:55 Saved a copy of the workbook.
1/4/2005 12:55 Created config file C:\Program Files\Microsoft SQL Server
Accelerator for BI\data\OLAPSMb\config.ini.
1/4/2005 12:55 Writing the contents of the workbook into an XML document...
1/4/2005 12:55 Wrote the XML document.
1/4/2005 12:55 Writing the client generator mapping file...
1/4/2005 12:55 Wrote the client generator mapping file.
1/4/2005 12:55 Connecting to the Analytics Builder catalog...
1/4/2005 12:55 Connected to the Analytics Builder catalog.
1/4/2005 12:55 ------------------------
1/4/2005 12:55 ------------------------
1/4/2005 12:55 Entering metadata into the catalog...
1/4/2005 12:55 Removing existing metadata for database OLAPSMb...
1/4/2005 12:55 Removed existing metadata for database OLAPSMb
1/4/2005 12:55 Adding metadata for database OLAPSMb...
1/4/2005 12:55 Added database metadata. OLAPSMb
1/4/2005 12:55 Adding metadata for autogenerated time dims...
1/4/2005 12:55 Added autogenerated time dimension virtual dimension info.
1/4/2005 12:55 Added metadata for autogenerated Standard time hierarchy.
1/4/2005 12:55 Added metadata for autogenerated time dims.
1/4/2005 12:55 Adding date range info for auto time dims.
1/4/2005 12:55 Added date range info.
1/4/2005 12:55 Adding metadata for dimensions...
1/4/2005 12:55 Added metadata for Part dimension.
1/4/2005 12:55 Added metadata for Geography dimension.
1/4/2005 12:55 Added metadata for Customer dimension.
1/4/2005 12:55 Added metadata for OrderStatus dimension.
1/4/2005 12:55 Added metadata for dimensions.
1/4/2005 12:55 Adding metadata for member properties...
1/4/2005 12:55 Added metadata for member properties.
1/4/2005 12:55 ------------------------
1/4/2005 12:55 ------------------------
1/4/2005 12:55 Adding metadata for cubes...
1/4/2005 12:55 Added metadata for Orders Shipped cube.
1/4/2005 12:55 Added metadata for Orders Backlog cube.
1/4/2005 12:55 Added metadata for Orders Other cube.
1/4/2005 12:55 Added metadata for Parts Shipped cube.
1/4/2005 12:55 Added metadata for Parts Backlog cube.
1/4/2005 12:55 Added metadata for Parts Other cube.
1/4/2005 12:55 Added metadata for Waybills cube.
1/4/2005 12:55 Added metadata for all cubes.
1/4/2005 12:55 ------------------------
1/4/2005 12:55 Adding metadata for Virtual cubes...
1/4/2005 12:55 Added metadata for Orders virtual cube.
1/4/2005 12:55 Added metadata for Parts virtual cube.
1/4/2005 12:55 Added metadata for Orders and Parts virtual cube.
1/4/2005 12:55 Added metadata for all virtual cubes.
1/4/2005 12:55 ------------------------
1/4/2005 12:55 Adding metadata for Calculated Members...
1/4/2005 12:55 Added metadata for all calculated members.
1/4/2005 12:55 ------------------------
1/4/2005 12:55 Adding metadata for Named Sets...
1/4/2005 12:55 Added metadata for all named sets.
1/4/2005 12:55 ------------------------
1/4/2005 12:55 Adding metadata for CalcCells...
1/4/2005 12:55 Added metadata for all CalcCells.
1/4/2005 12:55 ------------------------
1/4/2005 12:55 Adding metadata for Actions...
1/4/2005 12:55 Added metadata for all Actions.
1/4/2005 12:55 ------------------------
1/4/2005 12:55 ------------------------
1/4/2005 12:55 Creating database objects...
1/4/2005 12:55 Created empty SQLServer databases for OLAPSMb.
1/4/2005 12:55 Created SQLServer time dimensions.
1/4/2005 12:55 Created SQLServer dimensions.
1/4/2005 12:55 Created SQLServer fact tables.
1/4/2005 12:55 Successfully created all SQL Server database tables.
1/4/2005 12:55 ------------------------
1/4/2005 12:55 ------------------------
1/4/2005 12:55 Copying BISO database objects...
1/4/2005 12:55 Error: [Microsoft][ODBC SQL Server Driver][SQL
Server]'schema_name' is not a recognized function name. Check DTS log in
"C:\Program Files\Microsoft SQL Server Accelerator for BI\data\OLAPSMb\Temp"
1/4/2005 12:55 Location: CopyBisoObjs /Copy SQL Server Objects
failed/Microsoft SQL-DMO (ODBC SQLState: 42000)
1/4/2005 12:55 Analytics Builder processing halted unexpectedly.

It works on my machine and I have 2005 Beta installed - cant remember which
one was first though....could it be sp2 for xp - I dont' have
that one....

"John" <John K (AT) discussions (DOT) microsoft.com> wrote

Thanks Michael.

Since it is not 2005 causing the issue, I think I might try to reinstall SQL
Server 2000 and the SSABI again.

John K.

"Michael Vardinghus" wrote: