Error installing SQL Server 2005 SP1 - Reporting Services - log excerpt included

Hello, any information about this issue would certainly be appreciated! I've been trying to install SP1 for my SQL Server 2005. There is a failure for the reporting services which appears in the following text from the log:

--

MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:402]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:417]: Note: 1: 2360
MSI (s) (7C:38) [13:43:05:417]: Executing op: CacheBaselineFile(Baseline=0,FileKey=RSWebUserInterface.dll.B7E12617_911F_413B_9E42_083AE8682587,FilePath=C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager\Bin\ReportingServicesWebUserInterface.dll,,Existing=1)
MSI (s) (7C:38) [13:43:05:433]: Note: 1: 2318 2: C:\WINDOWS\Installer\$PatchCache$\Managed\E281BDB31738DB64CA931CA4195DEE8F\9.0.1399\RSWebUserInterface.dll.B7E12617_911F_413B_9E42_083AE8682587
MSI (s) (7C:38) [13:43:05:621]: Executing op: FileCopy(SourceName=WebUse~1.dll|ReportingServicesWebUserInterface.dll,SourceCabKey=RSWebUserInterface.dll.B7E12617_911F_413B_9E42_083AE8682587,DestName=ReportingServicesWebUserInterface.dll,Attributes=20992,FileSize=1235744,PerTick=32768,,VerifyMedia=1,,,,,CheckCRC=0,Version=9.0.2047.0,Language=0,InstallMode=58982400,,,,,,,)
MSI (s) (7C:38) [13:43:05:621]: File: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager\Bin\ReportingServicesWebUserInterface.dll; Overwrite; Won't patch; Existing file is a lower version
MSI (s) (7C:38) [13:43:05:621]: Source for file 'RSWebUserInterface.dll.B7E12617_911F_413B_9E42_083AE8682587' is compressed
MSI (s) (7C:38) [13:43:05:636]: Re-applying security from existing file.
MSI (s) (7C:38) [13:43:05:667]: Verifying accessibility of file: ReportingServicesWebUserInterface.dll
MSI (s) (7C:38) [13:43:05:667]: Verifying accessibility of file: ReportingServicesWebUserInterface.dll
MSI (s) (7C:38) [13:43:05:667]: Note: 1: 2318 2: C:\Config.Msi\73537e.rbf
MSI (s) (7C:38) [13:43:05:667]: Using source file security for destination.
MSI (s) (7C:38) [13:43:05:667]: Note: 1: 1310 2: 5 3: C:\Config.Msi\73537e.rbf
MSI (s) (7C:38) [13:43:05:667]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:667]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Transforming table Error.

MSI (s) (7C:38) [13:43:05:683]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (7C:38) [13:43:05:683]: Product: Microsoft SQL Server 2005 Reporting Services -- Error 1310. Error writing to file: C:\Config.Msi\73537e.rbf. System error 5. Verify that you have access to that directory.

Error 1310. Error writing to file: C:\Config.Msi\73537e.rbf. System error 5. Verify that you have access to that directory.
MSI (s) (7C:38) [13:43:05:730]: User policy value 'DisableRollback' is 0
MSI (s) (7C:38) [13:43:05:730]: Machine policy value 'DisableRollback' is 0
Action ended 13:43:05: InstallFinalize. Return value 3.
MSI (s) (7C:38) [13:43:05:746]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=892169565,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (7C:38) [13:43:05:746]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (7C:38) [13:43:05:746]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005 Reporting Services)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\73536e.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\73536f.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735370.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735371.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735372.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735373.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735374.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735375.rbf)
MSI (s) (7C:38) [13:43:05:746]: Executing op: RegisterBackupFile(File=C:\Config.Msi\735376.rbf)

--

Please note that I develop reports locally against a database on another server; would this be part of the problem? Let me know if you need more info, too. Thanks.

Hi !

Did you check the following ones:

You receive an "Error 1303. The installer has insufficient privileges to
access this directory" error message when you
http://support.microsoft.com/default.aspx?scid=kb;en-us;228658

You receive the "Error 1303" error message when you try to install
http://support.microsoft.com/default.aspx?scid=kb;en-us;836194

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Hi Jens, the first link was the problem! The install completed successfully now. Thank you for your help!

Error in Processing Cube while ROLAP Storage

Hello,

When I process the Cube having ROLAP storage, it gives the error as below, any thoughts on this would be greatly appreciated.

Errors in the back-end database access module. ROLAP partition with the Name='Fact One' Id='Fact One' can not have aggregations at the (all, all, ... ) level. Aggregaion skipped. OLE DB error: OLE DB or ODBC error: Cannot create index on view "TESTROLAP.dbo.Agg_Fact One_0_1_1_1_1_1" because it references derived table "dbo_Fact_One" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.; 42000.

Thanks,
Nasir

Nasir wrote:

Hello,

When I process the Cube having ROLAP storage, it gives the error as below, any thoughts on this would be greatly appreciated.

Errors in the back-end database access module. ROLAP partition with the Name='Fact One' Id='Fact One' can not have aggregations at the (all, all, ... ) level. Aggregaion skipped. OLE DB error: OLE DB or ODBC error: Cannot create index on view "TESTROLAP.dbo.Agg_Fact One_0_1_1_1_1_1" because it references derived table "dbo_Fact_One" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.; 42000.

Thanks,
Nasir

Above Cube runs these two Queries while processing:

Query 1 succeeds and Query 2 fails, here are both of them:

Query 1

CREATE

VIEW [Agg_Fact One_0_1_1_1_1_1] ( [Amount_0],[_1],[TimeID_2], [COUNT_BIG_7673aff6-2445-4ef6-a4c9-7bf3d93bd42a] ) WITH SCHEMABINDING AS

(

SELECT SUM ( [dbo_Fact_One].[dbo_Fact_OneAmount0_0] )

AS [dbo_Fact_OneAmount0_0],

COUNT_BIG ( [dbo_Fact_One].[dbo_Fact_One0_1] )

AS [dbo_Fact_One0_1],[dbo_Fact_One].[dbo_Fact_OneTimeID0_2] AS [dbo_Fact_OneTimeID0_2], COUNT_BIG(*) AS [COUNT_BIG_7673aff6-2445-4ef6-a4c9-7bf3d93bd42a]

FROM

(

SELECT [Amount] AS [dbo_Fact_OneAmount0_0],1 AS [dbo_Fact_One0_1],[TimeID] AS [dbo_Fact_OneTimeID0_2]

FROM [dbo].[Fact_One]

)

AS [dbo_Fact_One]

GROUP BY [dbo_Fact_One].[dbo_Fact_OneTimeID0_2]

)

Query 2

CREATE

UNIQUE CLUSTERED INDEX [Agg_Fact One_0_1_1_1_1_1] ON [Agg_Fact One_0_1_1_1_1_1] ( [TimeID_2] )

Error import;Dll Error 126

How do I find the File(rtl70.bpl) and put it back. I know for sure I erased it by mistake. Any suggestions will be appreciated.

Treasa

It's not a SQL Server file - It's a Borland Delphi 7 runtime file. So reinstall whatever program you installed that included that file.

-Sue