Boot.ini file: sp1

Showing posts with label sp1. Show all posts

Tuesday, March 20, 2012

BUG: 3rd Request: Series style function BUG in SP1

I'll try posting this again, since it garnered no reply either of the
times that I posted it. Is my post being ignored for some reason?
Greetings.
I found an odd issue when working with a series style in a line chart
in SP1. I was using my own function to determine the color of the
series. So I entered =Code.PickColor(Fields!ResultSort.Value) for the
formula. My code is this:
Public Function PickColor(iResultSort As Integer) As String
Dim sColor As String
Select Case iResultSort
Case 0: sColor = "#000000" ' Black, Full
Case 3: sColor = "#800000" ' Brown, Avg
End Select
PickColor = sColor
End Function
The ResultSort field is defined in SQL as an integer. What happened
on the chart is that the data line was drawn in the color expected,
but from the end of the line to the x axis, a black line was drawn.
If I change the code to use a String instead:
Public Function PickColor(sResultSort As String) As String
Dim sColor As String
Select Case sResultSort
Case "0": sColor = "#000000" ' Black, Full
Case "3": sColor = "#800000" ' Brown, Avg
End Select
PickColor = sColor
End Function
then it draws as expected.
I would sort of like to know if there is something that I am missing
here that causes it to behave like this or if there is an issue with
the functionality.
I have the rdl and sample data as xml attached here, and can email
screenshots or whatever if desired.
Thanks.
Dale.
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Chart Name="chart1">
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Legend>
<Visible>true</Visible>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Position>RightCenter</Position>
</Legend>
<Palette>Default</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Fields!DPC.Value</Value>
</DataValue>
</DataValues>
<DataLabel />
<Style>
<BorderColor>
<Default>=Code.PickColor( Fields!ResultSort.Value
)</Default>
</BorderColor>
</Style>
<Marker>
<Type>Auto</Type>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<CategoryAxis>
<Axis>
<Title />
<MajorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Visible>true</Visible>
</Axis>
</CategoryAxis>
<DataSetName>DataSet1</DataSetName>
<PointWidth>0</PointWidth>
<Type>Line</Type>
<Title />
<CategoryGroupings>
<CategoryGrouping>
<DynamicCategories>
<Grouping Name="chart1_CategoryGroup1">
<GroupExpressions>
<GroupExpression>=Fields!DaysAfter.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Label>=Fields!DaysAfter.Value</Label>
</DynamicCategories>
</CategoryGrouping>
</CategoryGroupings>
<SeriesGroupings>
<SeriesGrouping>
<DynamicSeries>
<Grouping Name="chart1_SeriesGroup1">
<GroupExpressions>
<GroupExpression>=Fields!ResultSort.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Label>=Fields!ResultSort.Value</Label>
</DynamicSeries>
</SeriesGrouping>
</SeriesGroupings>
<Subtype>Plain</Subtype>
<PlotArea>
<Style>
<BackgroundColor>White</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</PlotArea>
<ValueAxis>
<Axis>
<Title />
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Margin>true</Margin>
<Visible>true</Visible>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
</Chart>
</ReportItems>
<Style />
<Height>5.125in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="List_History ReadOnly">
<rd:DataSourceID>f2bd5a97-e7bc-444d-a3f9-b6f33e8fb5a7</rd:DataSourceID>
<DataSourceReference>List_History ReadOnly</DataSourceReference>
</DataSource>
</DataSources>
<Code>Public Function PickColor(iResultSort As Integer) As String
Dim sColor As String
Select Case iResultSort
Case 0: sColor = "#000000" ' Black, Full
Case 3: sColor = "#800000" ' Brown, Avg
End Select
PickColor = sColor
End Function
Public Function PickLineWidth(sResultSort As String) As String
Dim sWidth As String
Select Case sResultSort
Case 0: sWidth = "1.5pt" ' Thicker
Case Else: sWidth = "1pt" ' Normal
End Select
End Function
</Code>
<Width>6.625in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="DaysAfter">
<DataField>DaysAfter</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ResultSort">
<DataField>ResultSort</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="DPC">
<DataField>DPC</DataField>
<rd:TypeName>System.Decimal</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>List_History ReadOnly</DataSourceName>
<CommandText>SELECT * FROM dbo.Dale</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<Description />
<rd:ReportID>1f236bff-9e92-4d02-a9b0-b41e2d7f6950</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
<SampleData>
<DataRow DaysAfter="34" ResultSort="0" DPC="4.07"/><DataRow
DaysAfter="65" ResultSort="0" DPC="4.07"/><DataRow DaysAfter="95"
ResultSort="0" DPC="4.07"/><DataRow DaysAfter="126" ResultSort="0"
DPC="4.07"/><DataRow DaysAfter="156" ResultSort="0"
DPC="4.07"/><DataRow DaysAfter="187" ResultSort="0"
DPC="4.07"/><DataRow DaysAfter="218" ResultSort="0"
DPC="4.07"/><DataRow DaysAfter="248" ResultSort="0"
DPC="4.07"/><DataRow DaysAfter="279" ResultSort="0"
DPC="4.07"/><DataRow ResultSort="0" DPC="4.07"/><DataRow
DaysAfter="34" ResultSort="1" DPC="3.06"/><DataRow DaysAfter="65"
ResultSort="1" DPC="3.06"/><DataRow DaysAfter="95" ResultSort="1"
DPC="3.06"/><DataRow DaysAfter="126" ResultSort="1"
DPC="3.06"/><DataRow DaysAfter="156" ResultSort="1"
DPC="3.06"/><DataRow DaysAfter="187" ResultSort="1"
DPC="3.06"/><DataRow DaysAfter="218" ResultSort="1"
DPC="3.06"/><DataRow DaysAfter="248" ResultSort="1"
DPC="3.06"/><DataRow DaysAfter="279" ResultSort="1"
DPC="3.06"/><DataRow ResultSort="1" DPC="3.06"/><DataRow
DaysAfter="34" ResultSort="3" DPC="8.59"/><DataRow DaysAfter="65"
ResultSort="3" DPC="11.32"/><DataRow DaysAfter="95" ResultSort="3"
DPC="14.78"/><DataRow DaysAfter="126" ResultSort="3"
DPC="15.42"/><DataRow DaysAfter="156" ResultSort="3"
DPC="16.04"/><DataRow DaysAfter="187" ResultSort="3"
DPC="16.33"/></SampleData>I think there might be several issues here:
* you use DaysAfter as category grouping. Your data has NULLs for DaysAfter
in some of the rows - is this intended?
* the category grouping does not use a sort expression (to sort DaysAfter
ascending) - add a sort expression identical on the category group
expression: =Fields!DaysAfter.Value
* A series grouping is present in the chart - therefore instead of using
=Code.PickColor( Fields!ResultSort.Value), you should use this expression:
=Code.PickColor(First(Fields!ResultSort.Value, "chart1_SeriesGroup1")
The important part is the aggregate scope which has to be identical to the
chart series grouping name. Just using the First aggregate without the scope
will give you incorrect results, because the aggregate will be just scoped
for every chart datapoint (and therefore null if you don't have any
datapoints for a particular series group / category group combination).
Finally, I'm not sure but you might run into an issue in the chart control
we have identified recently and for which we have provided a fix. The fix is
related to NULL datapoints in line charts. Details:
http://support.microsoft.com/default.aspx?scid=kb;en-us;883675. Please feel
free to contact PSS and refer them to KB 883675.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shrumishi" <shrumishi@.yahoo.com> wrote in message
news:4380bfd3.0409170628.7daebbd3@.posting.google.com...
> I'll try posting this again, since it garnered no reply either of the
> times that I posted it. Is my post being ignored for some reason?
> Greetings.
> I found an odd issue when working with a series style in a line chart
> in SP1. I was using my own function to determine the color of the
> series. So I entered =Code.PickColor(Fields!ResultSort.Value) for the
> formula. My code is this:
> Public Function PickColor(iResultSort As Integer) As String
> Dim sColor As String
> Select Case iResultSort
> Case 0: sColor = "#000000" ' Black, Full
> Case 3: sColor = "#800000" ' Brown, Avg
> End Select
> PickColor = sColor
> End Function
> The ResultSort field is defined in SQL as an integer. What happened
> on the chart is that the data line was drawn in the color expected,
> but from the end of the line to the x axis, a black line was drawn.
> If I change the code to use a String instead:
> Public Function PickColor(sResultSort As String) As String
> Dim sColor As String
> Select Case sResultSort
> Case "0": sColor = "#000000" ' Black, Full
> Case "3": sColor = "#800000" ' Brown, Avg
> End Select
> PickColor = sColor
> End Function
> then it draws as expected.
> I would sort of like to know if there is something that I am missing
> here that causes it to behave like this or if there is an issue with
> the functionality.
> I have the rdl and sample data as xml attached here, and can email
> screenshots or whatever if desired.
> Thanks.
> Dale.
> <?xml version="1.0" encoding="utf-8"?>
> <Report
>
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
>
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <RightMargin>1in</RightMargin>
> <Body>
> <ReportItems>
> <Chart Name="chart1">
> <ThreeDProperties>
> <Rotation>30</Rotation>
> <Inclination>30</Inclination>
> <Shading>Simple</Shading>
> <WallThickness>50</WallThickness>
> </ThreeDProperties>
> <Style>
> <BackgroundColor>White</BackgroundColor>
> </Style>
> <Legend>
> <Visible>true</Visible>
> <Style>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> </Style>
> <Position>RightCenter</Position>
> </Legend>
> <Palette>Default</Palette>
> <ChartData>
> <ChartSeries>
> <DataPoints>
> <DataPoint>
> <DataValues>
> <DataValue>
> <Value>=Fields!DPC.Value</Value>
> </DataValue>
> </DataValues>
> <DataLabel />
> <Style>
> <BorderColor>
> <Default>=Code.PickColor( Fields!ResultSort.Value
> )</Default>
> </BorderColor>
> </Style>
> <Marker>
> <Type>Auto</Type>
> <Size>6pt</Size>
> </Marker>
> </DataPoint>
> </DataPoints>
> </ChartSeries>
> </ChartData>
> <CategoryAxis>
> <Axis>
> <Title />
> <MajorGridLines>
> <Style>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> </Style>
> </MajorGridLines>
> <MinorGridLines>
> <Style>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> </Style>
> </MinorGridLines>
> <MajorTickMarks>Outside</MajorTickMarks>
> <Min>0</Min>
> <Visible>true</Visible>
> </Axis>
> </CategoryAxis>
> <DataSetName>DataSet1</DataSetName>
> <PointWidth>0</PointWidth>
> <Type>Line</Type>
> <Title />
> <CategoryGroupings>
> <CategoryGrouping>
> <DynamicCategories>
> <Grouping Name="chart1_CategoryGroup1">
> <GroupExpressions>
>
<GroupExpression>=Fields!DaysAfter.Value</GroupExpression>
> </GroupExpressions>
> </Grouping>
> <Label>=Fields!DaysAfter.Value</Label>
> </DynamicCategories>
> </CategoryGrouping>
> </CategoryGroupings>
> <SeriesGroupings>
> <SeriesGrouping>
> <DynamicSeries>
> <Grouping Name="chart1_SeriesGroup1">
> <GroupExpressions>
>
<GroupExpression>=Fields!ResultSort.Value</GroupExpression>
> </GroupExpressions>
> </Grouping>
> <Label>=Fields!ResultSort.Value</Label>
> </DynamicSeries>
> </SeriesGrouping>
> </SeriesGroupings>
> <Subtype>Plain</Subtype>
> <PlotArea>
> <Style>
> <BackgroundColor>White</BackgroundColor>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> </Style>
> </PlotArea>
> <ValueAxis>
> <Axis>
> <Title />
> <MajorGridLines>
> <ShowGridLines>true</ShowGridLines>
> <Style>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> </Style>
> </MajorGridLines>
> <MinorGridLines>
> <Style>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> </Style>
> </MinorGridLines>
> <MajorTickMarks>Outside</MajorTickMarks>
> <Min>0</Min>
> <Margin>true</Margin>
> <Visible>true</Visible>
> <Scalar>true</Scalar>
> </Axis>
> </ValueAxis>
> </Chart>
> </ReportItems>
> <Style />
> <Height>5.125in</Height>
> </Body>
> <TopMargin>1in</TopMargin>
> <DataSources>
> <DataSource Name="List_History ReadOnly">
>
<rd:DataSourceID>f2bd5a97-e7bc-444d-a3f9-b6f33e8fb5a7</rd:DataSourceID>
> <DataSourceReference>List_History ReadOnly</DataSourceReference>
> </DataSource>
> </DataSources>
> <Code>Public Function PickColor(iResultSort As Integer) As String
> Dim sColor As String
> Select Case iResultSort
> Case 0: sColor = "#000000" ' Black, Full
> Case 3: sColor = "#800000" ' Brown, Avg
> End Select
> PickColor = sColor
> End Function
> Public Function PickLineWidth(sResultSort As String) As String
> Dim sWidth As String
> Select Case sResultSort
> Case 0: sWidth = "1.5pt" ' Thicker
> Case Else: sWidth = "1pt" ' Normal
> End Select
> End Function
> </Code>
> <Width>6.625in</Width>
> <DataSets>
> <DataSet Name="DataSet1">
> <Fields>
> <Field Name="DaysAfter">
> <DataField>DaysAfter</DataField>
> <rd:TypeName>System.Int32</rd:TypeName>
> </Field>
> <Field Name="ResultSort">
> <DataField>ResultSort</DataField>
> <rd:TypeName>System.Int32</rd:TypeName>
> </Field>
> <Field Name="DPC">
> <DataField>DPC</DataField>
> <rd:TypeName>System.Decimal</rd:TypeName>
> </Field>
> </Fields>
> <Query>
> <DataSourceName>List_History ReadOnly</DataSourceName>
> <CommandText>SELECT * FROM dbo.Dale</CommandText>
> <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
> </Query>
> </DataSet>
> </DataSets>
> <LeftMargin>1in</LeftMargin>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <rd:DrawGrid>true</rd:DrawGrid>
> <Description />
> <rd:ReportID>1f236bff-9e92-4d02-a9b0-b41e2d7f6950</rd:ReportID>
> <BottomMargin>1in</BottomMargin>
> <Language>en-US</Language>
> </Report>
> <SampleData>
> <DataRow DaysAfter="34" ResultSort="0" DPC="4.07"/><DataRow
> DaysAfter="65" ResultSort="0" DPC="4.07"/><DataRow DaysAfter="95"
> ResultSort="0" DPC="4.07"/><DataRow DaysAfter="126" ResultSort="0"
> DPC="4.07"/><DataRow DaysAfter="156" ResultSort="0"
> DPC="4.07"/><DataRow DaysAfter="187" ResultSort="0"
> DPC="4.07"/><DataRow DaysAfter="218" ResultSort="0"
> DPC="4.07"/><DataRow DaysAfter="248" ResultSort="0"
> DPC="4.07"/><DataRow DaysAfter="279" ResultSort="0"
> DPC="4.07"/><DataRow ResultSort="0" DPC="4.07"/><DataRow
> DaysAfter="34" ResultSort="1" DPC="3.06"/><DataRow DaysAfter="65"
> ResultSort="1" DPC="3.06"/><DataRow DaysAfter="95" ResultSort="1"
> DPC="3.06"/><DataRow DaysAfter="126" ResultSort="1"
> DPC="3.06"/><DataRow DaysAfter="156" ResultSort="1"
> DPC="3.06"/><DataRow DaysAfter="187" ResultSort="1"
> DPC="3.06"/><DataRow DaysAfter="218" ResultSort="1"
> DPC="3.06"/><DataRow DaysAfter="248" ResultSort="1"
> DPC="3.06"/><DataRow DaysAfter="279" ResultSort="1"
> DPC="3.06"/><DataRow ResultSort="1" DPC="3.06"/><DataRow
> DaysAfter="34" ResultSort="3" DPC="8.59"/><DataRow DaysAfter="65"
> ResultSort="3" DPC="11.32"/><DataRow DaysAfter="95" ResultSort="3"
> DPC="14.78"/><DataRow DaysAfter="126" ResultSort="3"
> DPC="15.42"/><DataRow DaysAfter="156" ResultSort="3"
> DPC="16.04"/><DataRow DaysAfter="187" ResultSort="3"
> DPC="16.33"/></SampleData>sql

Monday, March 19, 2012

Bug with 'enable identity insert on'

I'm using sp1, tryng to copy from 2005 db to 2005 db, selecting many tables at once, delete target rows on, identity insert ON.

choosing not to optimize for many tables:

Error: 0xC0202009 at Data Flow Task, Destination - table1 [22]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK_table1'. Cannot insert duplicate key in object 'dbo.table1.".

Error: 0xC0202009 at Data Flow Task, Destination 3 - table2 [226]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

Etc., for each table

Optimizing for many tables:

Error: 0xC0202009 at {AB2253E6-28B4-4D5A-B843-236F8E53E075}, OLE DB Destination [2]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".

Information: 0x402090E0 at {AB2253E6-28B4-4D5A-B843-236F8E53E075}, OLE DB Destination [2]: The final commit for the data insertion has ended.

When I drop and recreate the tables manually and set 'identity insert on' it doesn't bring the identity field over AT ALL.

I like that MS has tried to make it easier to move many tables at once by allowing us to set 'enable identity insert' to everything at once, but it doesn't appear to work. ( I've been puzzling over how it could work, anyway...)

Before sp 1, I had to go into each table by clicking the 'edit' button, and it would bring the correct identity value over, but the tables would no longer have the identity property on that field.

I have also tried 'run as a transaction' to no avail...

Well, the error is about PK violation, not about the Identity column definition.

|||Unless the identity column is the PK, in which case you should not have any columns mapped to the identity field in the destination OLE DB component. Leave it blank.|||

The identity column is indeed the PK - NOTE: I didn't design this.

Because the identity column is the PK, and various tables reference the PK, I need to be able to import the actual value.

I did tell it to delete the data first.

If I drop the tables and re-create them with no data, it doesn't bring the identity value over at all, the field auto-numbers.

I seem to be in a no-win situation. Even if I drop all the keys, i still have the problem with not getting the actual identity value inserted.

If the tool is going to allow you to indicate the data should be cleared in the tables first, I think there should be some indication regarding the keys.

I suppose my problem actually lies with the identity value not coming over. I have searched in this forum and found that several others seem to be having the same problem, but have not seen a resolution.

|||Are you using "fast load" in the OLE DB destination with "Keep identity" checked?|||

Perhaps I'm misunderstanding the problem but I have just managed to populate a table with an identity column as the PK by loading values into that column.

Here's the code to set it up:

Code Snippet

CREATE DATABASE tmp

USE tmp

CREATE TABLE source (id INT IDENTITY(1,1) PRIMARY key, chr CHAR(1))

INSERT source VALUES ('a')

INSERT source VALUES ('b')

INSERT source VALUES ('c')

CREATE TABLE destination (id INT IDENTITY(1,1) PRIMARY key, chr CHAR(1))

and below is the package that realised it. Let me know what is different in your scenario.

-Jamie

Code Snippet

<?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:ExecutableType="MSDTS.Package.1"><DTS:Property DTS:Name="PackageFormatVersion">2</< FONT>DTS:Property><DTS:Property DTS:Name="VersionComments"></< FONT>DTS:Property><DTS:Property DTS:Name="CreatorName">CT\jtbx</< FONT>DTS:Property><DTS:Property DTS:Name="CreatorComputerName">2UA63600NJ</< FONT>DTS:Property><DTS:Property DTS:Name="CreationDate" DTS:DataType="7">3/29/2007 3:25:55 PM</< FONT>DTS:Property><DTS:Property DTS:Name="PackageType">5</< FONT>DTS:Property><DTS:Property DTS:Name="ProtectionLevel">1</< FONT>DTS:Property><DTS:Property DTS:Name="MaxConcurrentExecutables">-1</< FONT>DTS:Property><DTS:Property DTS:Name="PackagePriorityClass">0</< FONT>DTS:Property><DTS:Property DTS:Name="VersionMajor">1</< FONT>DTS:Property><DTS:Property DTS:Name="VersionMinor">0</< FONT>DTS:Property><DTS:Property DTS:Name="VersionBuild">1</< FONT>DTS:Property><DTS:Property DTS:Name="VersionGUID">{2B4A9733-B18D-47EE-A743-7219941EEEB7}</< FONT>DTS:Property><DTS:Property DTS:Name="EnableConfig">0</< FONT>DTS:Property><DTS:Property DTS:Name="CheckpointFileName"></< FONT>DTS:Property><DTS:Property DTS:Name="SaveCheckpoints">0</< FONT>DTS:Property><DTS:Property DTS:Name="CheckpointUsage">0</< FONT>DTS:Property><DTS:Property DTS:Name="SuppressConfigurationWarnings">0</< FONT>DTS:Property>

<DTS:ConnectionManager><DTS:Property DTS:Name="DelayValidation">0</< FONT>DTS:Property><DTS:Property DTS:Name="ObjectName">LocalHost</< FONT>DTS:Property><DTS:Property DTS:Name="DTSID">{711EB6A5-1873-451F-AF3A-8453EC797462}</< FONT>DTS:Property><DTS:Property DTS:Name="Description"></< FONT>DTS:Property><DTS:Property DTS:Name="CreationName">OLEDB</< FONT>DTS:Property><DTS:ObjectData><DTS:ConnectionManager><DTS:Property DTS:Name="Retain">0</< FONT>DTS:Property><DTS:Property DTS:Name="ConnectionString">Data Source=.;Initial Catalog=tmp;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;</< FONT>DTS:Property></< FONT>DTS:ConnectionManager></< FONT>DTS:ObjectData></< FONT>DTS:ConnectionManager>

<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><Package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsControlFlowDiagram><dwd:Layout><dds>

<font>

</font>

</mouseicon>

</diagram>

</layoutmanager>

</control>

</ddsxmlobj>

</layoutobject>

</ddscontrol>

</dds></dwd:Layout></dwd:DtsControlFlowDiagram></Package></< FONT>DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</< FONT>DTS:Property><DTS:Property DTS:Name="ObjectName">{CBA6818F-FBB0-4EE8-A1BF-AD304660C52A}</< FONT>DTS:Property><DTS:Property DTS:Name="DTSID">{F740740D-718C-47DB-9D17-E2071E8A5DF3}</< FONT>DTS:Property><DTS:Property DTS:Name="Description"></< FONT>DTS:Property><DTS:Property DTS:Name="CreationName"></< FONT>DTS:Property></< FONT>DTS:PackageVariable>

<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><TaskHost xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DtsDataFlowDiagram><dwd:BoundingTop>3863</dwd:BoundingTop><dwd:Layout><dds>

<font>

</font>

</mouseicon>

</diagram>

</layoutmanager>

</control>

</ddsxmlobj>

</layoutobject>

</ddscontrol>

</control>

</ddsxmlobj>

</layoutobject>

</ddscontrol>

</ddsxmlobj>

</control>

</ddsxmlobj>

</layoutobject>

</connector>

</ddscontrol>

</dds></dwd:Layout></dwd:DtsDataFlowDiagram><dwd:DtsComponentDesignerPropertiesList><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">52 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">1 DataSourceViewID</dwd:key></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">52 TableInfoObjectType</dwd:key><dwd:value xsi:type="xsd:string">Table</dwd:value></dwd:DtsComponentDesignTimeProperty><dwd:DtsComponentDesignTimeProperty><dwd:key xsi:type="xsd:string">1 TableInfoObjectType</dwd:key><dwd:value xsi:type="xsd:string">Table</dwd:value></dwd:DtsComponentDesignTimeProperty></dwd:DtsComponentDesignerPropertiesList></TaskHost></< FONT>DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</< FONT>DTS:Property><DTS:Property DTS:Name="ObjectName">{D1234F40-926A-4975-86F0-EFC71316CEB6}</< FONT>DTS:Property><DTS:Property DTS:Name="DTSID">{59998195-8E74-4AB7-9A98-206CCB534639}</< FONT>DTS:Property><DTS:Property DTS:Name="Description"></< FONT>DTS:Property><DTS:Property DTS:Name="CreationName"></< FONT>DTS:Property></< FONT>DTS:PackageVariable>

<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><PipelinePath xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DestinationName>OLE DB Destination Input</dwd:DestinationName><dwd:SourceName>OLE DB Source Output</dwd:SourceName></PipelinePath></< FONT>DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</< FONT>DTS:Property><DTS:Property DTS:Name="ObjectName">{D1234F40-926A-4975-86F0-EFC71316CEB6}-69</< FONT>DTS:Property><DTS:Property DTS:Name="DTSID">{CF4C1E95-3336-4ED4-A60C-F4219105D5DE}</< FONT>DTS:Property><DTS:Property DTS:Name="Description"></< FONT>DTS:Property><DTS:Property DTS:Name="CreationName"></< FONT>DTS:Property></< FONT>DTS:PackageVariable><DTS:Property DTS:Name="ForceExecValue">0</< FONT>DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</< FONT>DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</< FONT>DTS:Property><DTS:Property DTS:Name="Disabled">0</< FONT>DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</< FONT>DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</< FONT>DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</< FONT>DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</< FONT>DTS:Property><DTS:Property DTS:Name="LocaleID">1033</< FONT>DTS:Property><DTS:Property DTS:Name="TransactionOption">1</< FONT>DTS:Property><DTS:Property DTS:Name="DelayValidation">0</< FONT>DTS:Property>

<DTS:Executable DTS:ExecutableType="{C3BF9DC1-4715-4694-936F-D3CFDA9E42C5}"><DTS:Property DTS:Name="ExecutionLocation">0</< FONT>DTS:Property><DTS:Property DTS:Name="ExecutionAddress"></< FONT>DTS:Property><DTS:Property DTS:Name="TaskContact"></< FONT>DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</< FONT>DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</< FONT>DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</< FONT>DTS:Property><DTS:Property DTS:Name="Disabled">0</< FONT>DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</< FONT>DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</< FONT>DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</< FONT>DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</< FONT>DTS:Property><DTS:Property DTS:Name="LocaleID">-1</< FONT>DTS:Property><DTS:Property DTS:Name="TransactionOption">1</< FONT>DTS:Property><DTS:Property DTS:Name="DelayValidation">0</< FONT>DTS:Property>

<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</< FONT>DTS:Property><DTS:Property DTS:Name="FilterKind">1</< FONT>DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></< FONT>DTS:Property></< FONT>DTS:LoggingOptions><DTS:Property DTS:Name="ObjectName">Data Flow Task</< FONT>DTS:Property><DTS:Property DTS:Name="DTSID">{D1234F40-926A-4975-86F0-EFC71316CEB6}</< FONT>DTS:Property><DTS:Property DTS:Name="Description">Data Flow Task</< FONT>DTS:Property><DTS:Property DTS:Name="CreationName">{C3BF9DC1-4715-4694-936F-D3CFDA9E42C5}</< FONT>DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</< FONT>DTS:Property><DTS:ObjectData><pipeline id="0" name="pipelineXml" description="pipelineXml" defaultBufferMaxRows="10000" engineThreads="5" defaultBufferSize="10485760" BLOBTempStoragePath="" bufferTempStoragePath="" runInOptimizedMode="true">

<property id="2" name="CommandTimeout" dataType="System.Int32" state="default" isArray="false" description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">0</< FONT>property>

<property id="3" name="OpenRowset" dataType="System.String" state="default" isArray="false" description="Specifies the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">[dbo].[source]</< FONT>property>

<property id="4" name="OpenRowsetVariable" dataType="System.String" state="default" isArray="false" description="Specifies the variable that contains the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></< FONT>property>

<property id="5" name="SqlCommand" dataType="System.String" state="default" isArray="false" description="The SQL command to be executed." typeConverter="" UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" containsID="false" expressionType="None"></< FONT>property>

<property id="6" name="SqlCommandVariable" dataType="System.String" state="default" isArray="false" description="The variable that contains the SQL command to be executed." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></< FONT>property>

<property id="7" name="DefaultCodePage" dataType="System.Int32" state="default" isArray="false" description="Specifies the column code page to use when code page information is unavailable from the data source." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">1252</< FONT>property>

<property id="8" name="AlwaysUseDefaultCodePage" dataType="System.Boolean" state="default" isArray="false" description="Forces the use of the DefaultCodePage property value when describing character data." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</< FONT>property>

<property id="9" name="AccessMode" dataType="System.Int32" state="default" isArray="false" description="Specifies the mode used to access the database." typeConverter="AccessMode" UITypeEditor="" containsID="false" expressionType="None">0</< FONT>property>

<property id="15" name="ParameterMapping" dataType="System.String" state="default" isArray="false" description="The mappings between the parameters in the SQL command and variables." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></< FONT>property></< FONT>properties>

<connection id="10" name="OleDbConnection" description="The OLE DB runtime connection used to access the database." connectionManagerID="{711EB6A5-1873-451F-AF3A-8453EC797462}"/></< FONT>connections>

<outputColumn id="50" name="chr" description="" lineageId="50" precision="0" scale="0" length="1" dataType="str" codePage="1252" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="49"/></< FONT>outputColumns><externalMetadataColumns isUsed="True">

<externalMetadataColumn id="49" name="chr" description="" precision="0" scale="0" length="1" dataType="str" codePage="1252"/></< FONT>externalMetadataColumns></< FONT>output>

<outputColumn id="14" name="ErrorColumn" description="" lineageId="14" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="2" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/></< FONT>outputColumns><externalMetadataColumns isUsed="False"/></< FONT>output>

</< FONT>outputs>

</< FONT>component>

<property id="53" name="CommandTimeout" dataType="System.Int32" state="default" isArray="false" description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">0</< FONT>property>

<property id="54" name="OpenRowset" dataType="System.String" state="default" isArray="false" description="Specifies the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">[dbo].[destination]</< FONT>property>

<property id="55" name="OpenRowsetVariable" dataType="System.String" state="default" isArray="false" description="Specifies the variable that contains the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></< FONT>property>

<property id="56" name="SqlCommand" dataType="System.String" state="default" isArray="false" description="The SQL command to be executed." typeConverter="" UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" containsID="false" expressionType="None"></< FONT>property>

<property id="57" name="DefaultCodePage" dataType="System.Int32" state="default" isArray="false" description="Specifies the column code page to use when code page information is unavailable from the data source." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">1252</< FONT>property>

<property id="58" name="AlwaysUseDefaultCodePage" dataType="System.Boolean" state="default" isArray="false" description="Forces the use of the DefaultCodePage property value when describing character data." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</< FONT>property>

<property id="59" name="AccessMode" dataType="System.Int32" state="default" isArray="false" description="Specifies the mode used to access the database." typeConverter="AccessMode" UITypeEditor="" containsID="false" expressionType="None">3</< FONT>property>

<property id="61" name="FastLoadKeepIdentity" dataType="System.Boolean" state="default" isArray="false" description="Indicates whether the values supplied for identity columns will be copied to the destination. If false, values for identity columns will be auto-generated at the destination. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">true</< FONT>property>

<property id="62" name="FastLoadKeepNulls" dataType="System.Boolean" state="default" isArray="false" description="Indicates whether the columns containing null will have null inserted in the destination. If false, columns containing null will have their default values inserted at the destinaton. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</< FONT>property>

<property id="63" name="FastLoadOptions" dataType="System.String" state="default" isArray="false" description="Specifies options to be used with fast load. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">TABLOCK,CHECK_CONSTRAINTS</< FONT>property>

<property id="64" name="FastLoadMaxInsertCommitSize" dataType="System.Int32" state="default" isArray="false" description="Specifies when commits are issued during data insertion. A value of 0 specifies that one commit will be issued at the end of data insertion. Applies only if fast load is turned on." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">0</< FONT>property></< FONT>properties>

<connection id="60" name="OleDbConnection" description="The OLE DB runtime connection used to access the database." connectionManagerID="{711EB6A5-1873-451F-AF3A-8453EC797462}"/></< FONT>connections>

</< FONT>inputColumns><externalMetadataColumns isUsed="True">

<externalMetadataColumn id="88" name="chr" description="" precision="0" scale="0" length="1" dataType="str" codePage="1252"/></< FONT>externalMetadataColumns></< FONT>input>

</< FONT>inputs>

<outputColumn id="68" name="ErrorColumn" description="" lineageId="68" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="2" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed" externalMetadataColumnId="0"/></< FONT>outputColumns><externalMetadataColumns isUsed="False"/></< FONT>output>

</< FONT>outputs>

</< FONT>component>

</< FONT>components>

<paths>

</< FONT>paths></< FONT>pipeline></< FONT>DTS:ObjectData></< FONT>DTS:Executable><DTS:Property DTS:Name="ObjectName">Package9</< FONT>DTS:Property><DTS:Property DTS:Name="DTSID">{CBA6818F-FBB0-4EE8-A1BF-AD304660C52A}</< FONT>DTS:Property><DTS:Property DTS:Name="Description"></< FONT>DTS:Property><DTS:Property DTS:Name="CreationName">MSDTS.Package.1</< FONT>DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</< FONT>DTS:Property></< FONT>DTS:Executable>

Bug report RS with SP1

Microsoft gang,
I have the following query. if I use @.Shipping instead of @.CustomerShipTo as
a parameter name, at the preview stage, I receive @.StartDate not defined
error.
SELECT
ProductType,Product,
SUM(TotalCases) as TotalCases,
UnitofMeasure,
DatePart(yyyy, DDate) as YDate,
DateName(mm,DDate) as MDate
FROM
fn_CreateBlankSalesCases(@.StartDate,@.EndDate,@.Broker,@.Customer,@.CustomerShip
To)
GROUP BY ProductType,Product,UnitofMeasure,DDate
Regards,
CemSome more information about the parameter bug.
When I add the parameter manually (Report > Report Parameters), the query
below blows at run time, works perfect at query designer.
The way I get around this problem was to define the parameter in the result
query first. The moment I add it to the function below, it shows up in
report parameters. After configuration works perfect.
/*Main query*/
SELECT
ProductType,Product,
SUM(TotalCases) as TotalCases,
UnitofMeasure,
DatePart(yyyy, DDate) as YDate,
DateName(mm,DDate) as MDate
FROM
fn_CreateBlankSalesCases(@.StartDate,@.EndDate,@.Broker,@.Customer,@.CustomerShip
,@.BrandName,@.CanSize)
GROUP BY ProductType,Product,UnitofMeasure,DDate
/*Parameter query*/
SELECT DISTINCT CanSize, CanSize as CanSizeDisplay FROM fn_CreateCanList()
UNION
SELECT Null , '--Select All--'
Regards,
Cem
"Cem Demircioglu" <cem@.NoSpamPlease.com> wrote in message
news:%23VP2%23ZmeEHA.2812@.tk2msftngp13.phx.gbl...
>
> Microsoft gang,
> I have the following query. if I use @.Shipping instead of @.CustomerShipTo
as
> a parameter name, at the preview stage, I receive @.StartDate not defined
> error.
> SELECT
> ProductType,Product,
> SUM(TotalCases) as TotalCases,
> UnitofMeasure,
> DatePart(yyyy, DDate) as YDate,
> DateName(mm,DDate) as MDate
> FROM
>
fn_CreateBlankSalesCases(@.StartDate,@.EndDate,@.Broker,@.Customer,@.CustomerShip
> To)
> GROUP BY ProductType,Product,UnitofMeasure,DDate
> Regards,
> Cem
>|||Thanks. We'll take a look and see if we can repro here.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cem Demircioglu" <cem@.NoSpamPlease.com> wrote in message
news:uNgnLbhfEHA.2848@.TK2MSFTNGP10.phx.gbl...
>
> Some more information about the parameter bug.
> When I add the parameter manually (Report > Report Parameters), the query
> below blows at run time, works perfect at query designer.
> The way I get around this problem was to define the parameter in the
> result
> query first. The moment I add it to the function below, it shows up in
> report parameters. After configuration works perfect.
> /*Main query*/
> SELECT
> ProductType,Product,
> SUM(TotalCases) as TotalCases,
> UnitofMeasure,
> DatePart(yyyy, DDate) as YDate,
> DateName(mm,DDate) as MDate
> FROM
> fn_CreateBlankSalesCases(@.StartDate,@.EndDate,@.Broker,@.Customer,@.CustomerShip
> ,@.BrandName,@.CanSize)
> GROUP BY ProductType,Product,UnitofMeasure,DDate
> /*Parameter query*/
> SELECT DISTINCT CanSize, CanSize as CanSizeDisplay FROM
> fn_CreateCanList()
> UNION
> SELECT Null , '--Select All--'
> Regards,
> Cem
> "Cem Demircioglu" <cem@.NoSpamPlease.com> wrote in message
> news:%23VP2%23ZmeEHA.2812@.tk2msftngp13.phx.gbl...
>>
>> Microsoft gang,
>> I have the following query. if I use @.Shipping instead of @.CustomerShipTo
> as
>> a parameter name, at the preview stage, I receive @.StartDate not defined
>> error.
>> SELECT
>> ProductType,Product,
>> SUM(TotalCases) as TotalCases,
>> UnitofMeasure,
>> DatePart(yyyy, DDate) as YDate,
>> DateName(mm,DDate) as MDate
>> FROM
> fn_CreateBlankSalesCases(@.StartDate,@.EndDate,@.Broker,@.Customer,@.CustomerShip
>> To)
>> GROUP BY ProductType,Product,UnitofMeasure,DDate
>> Regards,
>> Cem
>>
>|||Could you send me definitions of your functions fn_CreateBlankSalesCases and
fn_CreateCanList?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cem Demircioglu" <cem@.NoSpamPlease.com> wrote in message
news:uNgnLbhfEHA.2848@.TK2MSFTNGP10.phx.gbl...
>
> Some more information about the parameter bug.
> When I add the parameter manually (Report > Report Parameters), the query
> below blows at run time, works perfect at query designer.
> The way I get around this problem was to define the parameter in the
> result
> query first. The moment I add it to the function below, it shows up in
> report parameters. After configuration works perfect.
> /*Main query*/
> SELECT
> ProductType,Product,
> SUM(TotalCases) as TotalCases,
> UnitofMeasure,
> DatePart(yyyy, DDate) as YDate,
> DateName(mm,DDate) as MDate
> FROM
> fn_CreateBlankSalesCases(@.StartDate,@.EndDate,@.Broker,@.Customer,@.CustomerShip
> ,@.BrandName,@.CanSize)
> GROUP BY ProductType,Product,UnitofMeasure,DDate
> /*Parameter query*/
> SELECT DISTINCT CanSize, CanSize as CanSizeDisplay FROM
> fn_CreateCanList()
> UNION
> SELECT Null , '--Select All--'
> Regards,
> Cem
> "Cem Demircioglu" <cem@.NoSpamPlease.com> wrote in message
> news:%23VP2%23ZmeEHA.2812@.tk2msftngp13.phx.gbl...
>>
>> Microsoft gang,
>> I have the following query. if I use @.Shipping instead of @.CustomerShipTo
> as
>> a parameter name, at the preview stage, I receive @.StartDate not defined
>> error.
>> SELECT
>> ProductType,Product,
>> SUM(TotalCases) as TotalCases,
>> UnitofMeasure,
>> DatePart(yyyy, DDate) as YDate,
>> DateName(mm,DDate) as MDate
>> FROM
> fn_CreateBlankSalesCases(@.StartDate,@.EndDate,@.Broker,@.Customer,@.CustomerShip
>> To)
>> GROUP BY ProductType,Product,UnitofMeasure,DDate
>> Regards,
>> Cem
>>
>|||Lev,
Below you may find the functions you requested. Thanks.
Regards,
Cem
CREATE FUNCTION fn_CreateBlankSalesCases (
@.StartDate as DateTime,
@.EndDate as DateTime,
@.Broker as VarChar(50),
@.Customer as VarChar(50),
@.CustomerShip as VarChar(50),
@.BrandName as VarChar(50),
@.CanSize as VarChar(50))
RETURNS @.DateTable TABLE (
ProductType VarChar(150),
Product VarChar(150),
TotalCases Int,
UnitofMeasure VarChar(10),
DDate DateTime)
/*Table created in memory*/
AS
BEGIN
DECLARE @.StartTempDate as DateTime
DECLARE @.ProductType as VarChar(150)
DECLARE @.Product as VarChar(150)
DECLARE @.TotalCases as Int
DECLARE @.UnitofMeasure as VarChar(10)
DECLARE @.TDate as DateTime
SET @.StartTempDate = @.StartDate
/* String manupilation for the brandname */
If (@.CanSize IS NULL)
SET @.CanSize = '%'
ELSE
SET @.CanSize = '%' + @.CanSize + '%'
If (@.BrandName IS NULL)
SET @.BrandName = '%'
ELSE
SET @.BrandName = @.BrandName + '%'
DECLARE SalesActualProducts CURSOR FOR
SELECT
can_typ1.description AS ProductType,
plldb1.descl_plldbx AS Product,
sitem1.qty_sd AS TotalCases,
sitem1.um_sd AS UnitofMeasure,
CAST(CAST(MONTH(shead1.post_date) AS varchar(20)) + '/1/' +
CAST(YEAR(shead1.post_date) AS varchar(20)) AS datetime) AS TDate
FROM can_typ1 INNER JOIN
plldb1 ON can_typ1.type_mstr = plldb1.can_type INNER JOIN
sitem1 ON plldb1.part_mstr = sitem1.part_sd INNER JOIN
shead1 ON sitem1.sorder_sd = shead1.sorder_so
WHERE
(NOT (shead1.sotype_so = 'V')) AND
(NOT (shead1.post_date IS NULL)) AND
(shead1.post_date > @.StartDate) AND
(shead1.post_date < @.EndDate) AND
(shead1.sales_so = @.Broker) AND
(shead1.billto_so = COALESCE(@.Customer, shead1.billto_so)) AND
(shead1.shipto_so = COALESCE(@.CustomerShip, shead1.shipto_so))AND
(sitem1.part_sd LIKE @.BrandName) AND
(can_typ1.can_size LIKE @.CanSize)
GROUP BY
can_typ1.description,
plldb1.descl_plldbx,
sitem1.qty_sd,sitem1.um_sd,
CAST(CAST(MONTH(shead1.post_date) AS varchar(20)) + '/1/' +
CAST(YEAR(shead1.post_date) AS varchar(20)) AS datetime)
/*Start to insert data into the table */
OPEN SalesActualProducts
FETCH NEXT FROM
SalesActualProducts INTO @.ProductType, @.Product, @.TotalCases,
@.UnitofMeasure, @.TDate
WHILE @.@.FETCH_STATUS = 0
BEGIN
INSERT INTO @.DateTable VALUES (@.ProductType,
@.Product,@.TotalCases,@.UnitofMeasure,@.TDate)
FETCH NEXT FROM SalesActualProducts INTO @.ProductType, @.Product,
@.TotalCases, @.UnitofMeasure, @.TDate
END
CLOSE SalesActualProducts
DECLARE SalesProducts CURSOR FOR
SELECT
can_typ1.description AS ProductType,
plldb1.descl_plldbx AS Product,
sitem1.qty_sd AS TotalCases,
sitem1.um_sd AS UnitofMeasure,
CAST(CAST(MONTH(shead1.post_date) AS varchar(20)) + '/1/' +
CAST(YEAR(shead1.post_date) AS varchar(20)) AS datetime) AS TDate
FROM can_typ1 INNER JOIN
plldb1 ON can_typ1.type_mstr = plldb1.can_type INNER JOIN
sitem1 ON plldb1.part_mstr = sitem1.part_sd INNER JOIN
shead1 ON sitem1.sorder_sd = shead1.sorder_so
WHERE
(NOT (shead1.sotype_so = 'V')) AND
(NOT (shead1.post_date IS NULL)) AND
(shead1.post_date > @.StartDate) AND
(shead1.post_date < @.EndDate) AND
(shead1.sales_so = @.Broker) AND
(shead1.billto_so = COALESCE(@.Customer, shead1.billto_so)) AND
(shead1.shipto_so = COALESCE(@.CustomerShip, shead1.shipto_so))AND
(sitem1.part_sd LIKE @.BrandName) AND
(can_typ1.can_size LIKE @.CanSize)
GROUP BY
can_typ1.description,
plldb1.descl_plldbx,
sitem1.qty_sd,sitem1.um_sd,
CAST(CAST(MONTH(shead1.post_date) AS varchar(20)) + '/1/' +
CAST(YEAR(shead1.post_date) AS varchar(20)) AS datetime)
/*Start to insert data into the table */
OPEN SalesProducts
FETCH NEXT FROM
SalesProducts INTO @.ProductType, @.Product, @.TotalCases, @.UnitofMeasure,
@.TDate
WHILE @.@.FETCH_STATUS = 0
BEGIN
WHILE (@.StartDate < @.EndDate)
BEGIN
INSERT INTO @.DateTable VALUES (@.ProductType,
@.Product,0,@.UnitofMeasure,@.StartDate)
SET @.StartDate = DATEADD(month, 1, @.StartDate)
END
SET @.StartDate = @.StartTempDate
FETCH NEXT FROM SalesProducts INTO @.ProductType, @.Product, @.TotalCases,
@.UnitofMeasure, @.TDate
END
CLOSE SalesProducts
/*Return Table*/
RETURN
END
CREATE FUNCTION fn_CreateCanList()
RETURNS
@.CanTable TABLE (
CanSize VarChar(150),
CanSizeOld VarChar(150)
)
/*Table created in memory*/
AS
BEGIN
DECLARE @.CanSizeTemp as VarChar(50)
DECLARE CanSizeList CURSOR FOR
SELECT DISTINCT can_size
FROM can_typ1
WHERE can_size IS NOT NULL
/*Start to insert data into the table */
OPEN CanSizeList
FETCH NEXT FROM
CanSizeList INTO @.CanSizeTemp
WHILE @.@.FETCH_STATUS = 0
BEGIN
IF CHARINDEX('/',@.CanSizeTemp) > 0
INSERT INTO @.CanTable
VALUES(RIGHT(RTRIM(@.CanSizeTemp),LEN(@.CanSizeTemp)-CHARINDEX('/',@.CanSizeTem
p)) ,@.CanSizeTemp)
ELSE
INSERT INTO @.CanTable VALUES(@.CanSizeTemp, @.CanSizeTemp)
FETCH NEXT FROM CanSizeList INTO @.CanSizeTemp
END
CLOSE CanSizeList
/*Return Table*/
RETURN
END
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
news:uQ8Q1hnfEHA.3928@.TK2MSFTNGP11.phx.gbl...
> Could you send me definitions of your functions fn_CreateBlankSalesCases
and
> fn_CreateCanList?
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Cem Demircioglu" <cem@.NoSpamPlease.com> wrote in message
> news:uNgnLbhfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> >
> >
> > Some more information about the parameter bug.
> >
> > When I add the parameter manually (Report > Report Parameters), the
query
> > below blows at run time, works perfect at query designer.
> >
> > The way I get around this problem was to define the parameter in the
> > result
> > query first. The moment I add it to the function below, it shows up in
> > report parameters. After configuration works perfect.
> >
> > /*Main query*/
> > SELECT
> > ProductType,Product,
> > SUM(TotalCases) as TotalCases,
> > UnitofMeasure,
> > DatePart(yyyy, DDate) as YDate,
> > DateName(mm,DDate) as MDate
> >
> > FROM
> >
fn_CreateBlankSalesCases(@.StartDate,@.EndDate,@.Broker,@.Customer,@.CustomerShip
> > ,@.BrandName,@.CanSize)
> > GROUP BY ProductType,Product,UnitofMeasure,DDate
> >
> > /*Parameter query*/
> > SELECT DISTINCT CanSize, CanSize as CanSizeDisplay FROM
> > fn_CreateCanList()
> > UNION
> > SELECT Null , '--Select All--'
> >
> > Regards,
> > Cem
> >
> > "Cem Demircioglu" <cem@.NoSpamPlease.com> wrote in message
> > news:%23VP2%23ZmeEHA.2812@.tk2msftngp13.phx.gbl...
> >>
> >>
> >> Microsoft gang,
> >>
> >> I have the following query. if I use @.Shipping instead of
@.CustomerShipTo
> > as
> >> a parameter name, at the preview stage, I receive @.StartDate not
defined
> >> error.
> >>
> >> SELECT
> >> ProductType,Product,
> >> SUM(TotalCases) as TotalCases,
> >> UnitofMeasure,
> >> DatePart(yyyy, DDate) as YDate,
> >> DateName(mm,DDate) as MDate
> >>
> >> FROM
> >>
> >
fn_CreateBlankSalesCases(@.StartDate,@.EndDate,@.Broker,@.Customer,@.CustomerShip
> >> To)
> >> GROUP BY ProductType,Product,UnitofMeasure,DDate
> >>
> >> Regards,
> >> Cem
> >>
> >>
> >
> >
>

Sunday, March 11, 2012

Bug Listing?

Is there anywhere on your website that lists the current bugs/problems
identified post SP1 that will be fixed in future SP releases? I think it
would be very useful for a lot of RS developers to have a definitive list,
rather than scouring around newsgroups to find that the problem we've got is
actually a bug?If you have some bugs you know of, please post them here.
http://www.reportingservicesfaq.com/ow.asp?SP1Bugs
Help build the Wiki!
--
Reporting Services Articles, Forums, Blogs and Wiki Community
www.ReportingServicesFAQ.com
Simon wrote:
> Is there anywhere on your website that lists the current bugs/problems
> identified post SP1 that will be fixed in future SP releases? I think it
> would be very useful for a lot of RS developers to have a definitive list,
> rather than scouring around newsgroups to find that the problem we've got is
> actually a bug?

Bug in SQL 2005 SP1

I am trying to chase this down and have noticed similar postings on the web concerning applying this SP. I have successfully upgraded all components except for the "database services" component. Has anyone been able to get beyond this? Below is the log:

04/23/2006 09:24:53.523 ================================================================================
04/23/2006 09:24:53.523 Hotfix package launched
04/23/2006 09:24:56.664 Product discovery successfully completed during the install process for MSSQLSERVER
04/23/2006 09:24:56.680 SP Level check successfully completed during the install process for MSSQLSERVER
04/23/2006 09:24:56.695 Product language check successfully completed during the install process for MSSQLSERVER
04/23/2006 09:24:56.695 Product version check successfully completed during the install process for MSSQLSERVER
04/23/2006 09:24:56.711 Command-line instance name check completed during the install process
04/23/2006 09:24:56.727 Baseline build check completed during the install process
04/23/2006 09:26:23.634 Attempting to install instance: MSSQLSERVER
04/23/2006 09:26:23.665 Attempting to install target: BUBBA
04/23/2006 09:26:23.681 Attempting to stop service: SQLSERVERAGENT
04/23/2006 09:26:28.759 Successfully stopped service: SQLSERVERAGENT
04/23/2006 09:26:28.759 Attempting to stop service: MSSQLServer
04/23/2006 09:26:31.775 Successfully stopped service: MSSQLServer
04/23/2006 09:26:31.775 Attempting to check for locked files: sqlrun_sql.msp
04/23/2006 09:26:31.853 Attempting to check for locked files: \\BUBBA\f$\1d45d29b4040fe84b0e458b39adf\HotFixSQL\Files\sqlrun_sql.msp
04/23/2006 09:26:31.868 Creating MSP locked file check log at: C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.out
04/23/2006 09:26:57.634 MSP returned 1602: The user cancels installation.
04/23/2006 09:26:57.791 Successfully checked file: \\BUBBA\f$\1d45d29b4040fe84b0e458b39adf\HotFixSQL\Files\sqlrun_sql.msp
04/23/2006 09:26:57.806 Successfully opened registry key: System\CurrentControlSet\Control\Session Manager
04/23/2006 09:26:57.822 Failed to read registry key: PendingFileRenameOperations
04/23/2006 09:26:57.837 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xmlfilt.dll
04/23/2006 09:26:57.869 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\ThaWBrkr.dll
04/23/2006 09:26:57.900 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\query.dll
04/23/2006 09:26:57.931 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\nls400.dll
04/23/2006 09:26:57.947 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\nlhtml.dll
04/23/2006 09:26:57.962 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msir5jp.dll
04/23/2006 09:26:57.978 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msftesql.exe
04/23/2006 09:26:57.994 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msftepxy.dll
04/23/2006 09:26:58.009 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msftefd.exe
04/23/2006 09:26:58.025 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msfte.dll
04/23/2006 09:26:58.025 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\LangWrbk.dll
04/23/2006 09:26:58.041 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\korwbrkr.dll
04/23/2006 09:26:58.072 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\infosoft.dll
04/23/2006 09:26:58.087 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\FTERef\FTERef.dll
04/23/2006 09:26:58.103 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\CHTBRKR.DLL
04/23/2006 09:26:58.119 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\ChsBrkr.dll
04/23/2006 09:26:58.134 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\COM\Resources\1033\REPLRES.rll
04/23/2006 09:26:58.150 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\COM\replrec.dll
04/23/2006 09:26:58.166 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\COM\rplisapi.dll
04/23/2006 09:26:58.181 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\WINDOWS\assembly\GAC_32\Microsoft.SqlServer.Replication\9.0.242.0__89845dcd8080cc91\Repl.dll
04/23/2006 09:26:58.197 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.DataStorage\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.DataStorage.dll
04/23/2006 09:26:58.212 Failed to read version information for the following file: C:\Program Files\Common Files\Microsoft Shared\Database Replication\Resources\1033\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\rplhtfin.sql
04/23/2006 09:26:58.228 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\
C:\Program Files\Microsoft SQL Server\90\COM\qrdrsvc.exe
04/23/2006 09:26:58.244 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\COM\snapshot.exe
04/23/2006 09:26:58.259 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\COM\replmerg.exe
04/23/2006 09:26:58.291 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\tablediff.exe
04/23/2006 09:26:58.306 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\COM\DISTRIB.exe
04/23/2006 09:26:58.306 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\DatabaseMail90.exe
04/23/2006 09:26:58.322 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\3082\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\2052\sqlevn70.rll
04/23/2006 09:26:58.353 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1042\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1041\sqlevn70.rll
04/23/2006 09:26:58.353 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1040\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1036\sqlevn70.rll
04/23/2006 09:26:58.369 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1031\sqlevn70.rll
04/23/2006 09:26:58.384 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1028\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\XPStar90.RLL
04/23/2006 09:26:58.416 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlaccess.dll
04/23/2006 09:26:58.431 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlaccess.dll
04/23/2006 09:26:58.431 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlaccess.dll
04/23/2006 09:26:58.447 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\6.6.3.5
C:\Program Files\Microsoft SQL Server\90\Shared\msxmlsql.dll
04/23/2006 09:26:58.478 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\2.0.3609.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xmlrw.dll
04/23/2006 09:26:58.494 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlsvc90.dll
04/23/2006 09:26:58.509 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlsvc90.dll
04/23/2006 09:26:58.525 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlsvc90.dll
04/23/2006 09:26:58.556 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLBOOT.dll
04/23/2006 09:26:58.556 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xplog70.dll
04/23/2006 09:26:58.572 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\batchp~1.dll
04/23/2006 09:26:58.587 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\SQLAgentMail90.rll
04/23/2006 09:26:58.619 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\SQLAgentMail90.rll
04/23/2006 09:26:58.634 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\SQLAgentMail90.rll
04/23/2006 09:26:58.650 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\SQLAGENT90.RLL
04/23/2006 09:26:58.650 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\SQLAGENT90.RLL
04/23/2006 09:26:58.666 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\SQLAGENT90.RLL
04/23/2006 09:26:58.697 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAgentMail90.dll
04/23/2006 09:26:58.697 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAgentMail90.dll
04/23/2006 09:26:58.712 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAgentMail90.dll
04/23/2006 09:26:58.728 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAGENT90.EXE
04/23/2006 09:26:58.744 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAGENT90.EXE
04/23/2006 09:26:58.759 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAGENT90.EXE
04/23/2006 09:26:58.775 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\Resources\1033\9.0.2047.0
C:\Program Files\Microsoft SQL Server\90\Shared\msmdrdir.dll
04/23/2006 09:26:58.791 Failed to read version information for the following file: C:\Program Files\Common Files\System\ole db\2.0.3609.0
C:\Program Files\Common Files\System\ole db\xmlrw.dll
04/23/2006 09:26:58.806 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\msmdlocal.dll
04/23/2006 09:26:58.837 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\msmdlocal.dll
04/23/2006 09:26:58.837 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\msmdlocal.dll
04/23/2006 09:26:58.853 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe
04/23/2006 09:26:58.869 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe
04/23/2006 09:26:58.900 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe
04/23/2006 09:26:58.916 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\msasxpress.dll
04/23/2006 09:26:58.931 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\msasxpress.dll
04/23/2006 09:26:58.931 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\msasxpress.dll
04/23/2006 09:26:58.963 Failed to read version information for the following file: C:\Program Files\Microsoft.NET\ADOMD.NET\90\en\Microsoft.AnalysisServices.AdomdClient.xml
04/23/2006 09:26:58.978 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft.NET\ADOMD.NET\90\Microsoft.AnalysisServices.AdomdClient.dll
04/23/2006 09:26:58.994 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.AnalysisServices.AdomdClient\9.0.242.0__89845dcd8080cc91\Microsoft.AnalysisServices.AdomdClient.dll
04/23/2006 09:26:58.994 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\sqlcm.xml
04/23/2006 09:26:59.009 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\SqlManager.rll
04/23/2006 09:26:59.041 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\SqlManager.rll
04/23/2006 09:26:59.056 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\SqlManager.rll
04/23/2006 09:26:59.056 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\binn\SqlManager.dll
04/23/2006 09:26:59.072 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\binn\SqlManager.dll
04/23/2006 09:26:59.103 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\binn\SqlManager.dll
04/23/2006 09:26:59.119 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\batchparser90.dll
04/23/2006 09:26:59.134 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\batchparser90.dll
04/23/2006 09:26:59.150 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\batchparser90.dll
04/23/2006 09:26:59.181 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\Tools\binn\SQLSVC90.DLL
04/23/2006 09:26:59.197 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\2.0.3609.0
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLdiag.exe
04/23/2006 09:26:59.197 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\Shared\sqlsvc~1.dll
04/23/2006 09:26:59.228 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlsecacctchg.dll
04/23/2006 09:26:59.228 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlsecacctchg.dll
04/23/2006 09:26:59.259 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlsecacctchg.dll
04/23/2006 09:26:59.275 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlftacct.dll
04/23/2006 09:26:59.291 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlftacct.dll
04/23/2006 09:26:59.306 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlftacct.dll
04/23/2006 09:26:59.322 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\isacctchange.dll
04/23/2006 09:26:59.338 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\isacctchange.dll
04/23/2006 09:26:59.353 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\isacctchange.dll
04/23/2006 09:26:59.369 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\svrenumapi.dll
04/23/2006 09:26:59.384 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\svrenumapi.dll
04/23/2006 09:26:59.416 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\svrenumapi.dll
04/23/2006 09:26:59.431 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\Shared\sqlsqm.exe
04/23/2006 09:26:59.431 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\9.0.2047.0
C:\Program Files\Microsoft SQL Server\90\Shared\dbghelp.dll
04/23/2006 09:26:59.463 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\SqlDumper.exe
04/23/2006 09:26:59.478 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\SqlDumper.exe
04/23/2006 09:26:59.509 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\SqlDumper.exe
04/23/2006 09:26:59.525 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.Rmo\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.Rmo.dll
04/23/2006 09:26:59.541 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.AnalysisServices\9.0.242.0__89845dcd8080cc91\Microsoft.AnalysisServices.DLL
04/23/2006 09:26:59.572 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.DataWarehouse.Interfaces\9.0.242.0__89845dcd8080cc91\Microsoft.DataWarehouse.Interfaces.DLL
04/23/2006 09:26:59.588 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.RegSvrEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.RegSvrEnum.dll
04/23/2006 09:26:59.603 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_32\Microsoft.SqlServer.BatchParser\9.0.242.0__89845dcd8080cc91\microsoft.sqlserver.batchparser.dll
04/23/2006 09:26:59.619 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_32\Microsoft.SqlServer.BatchParser\9.0.242.0__89845dcd8080cc91\microsoft.sqlserver.batchparser.dll
04/23/2006 09:26:59.634 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_32\Microsoft.SqlServer.BatchParser\9.0.242.0__89845dcd8080cc91\microsoft.sqlserver.batchparser.dll
04/23/2006 09:26:59.666 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ServiceBrokerEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.ServiceBrokerEnum.dll
04/23/2006 09:26:59.681 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.WmiEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.WmiEnum.dll
04/23/2006 09:26:59.697 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.SqlEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.SqlEnum.dll
04/23/2006 09:26:59.713 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.SmoEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.SmoEnum.dll
04/23/2006 09:26:59.728 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.Smo\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.Smo.dll
04/23/2006 09:26:59.744 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\SqlSAC.exe
04/23/2006 09:26:59.759 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\Microsoft.SqlSac.Public.dll
04/23/2006 09:31:20.825 Attempting to install file: sqlrun_sql.msp
04/23/2006 09:31:20.888 Attempting to install file: \\BUBBA\f$\1d45d29b4040fe84b0e458b39adf\HotFixSQL\Files\sqlrun_sql.msp
04/23/2006 09:31:20.903 Creating MSP install log file at: C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.log
04/23/2006 09:31:20.919 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
04/23/2006 09:31:20.935 Failed to read registry key: Debug
04/23/2006 09:33:20.046 MSP returned 1603: A fatal error occurred during installation.
04/23/2006 09:33:20.280 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
04/23/2006 09:33:20.296 Failed to read registry key: Debug
04/23/2006 09:33:20.311 Unable to install MSP file: \\BUBBA\f$\1d45d29b4040fe84b0e458b39adf\HotFixSQL\Files\sqlrun_sql.msp
04/23/2006 09:33:20.311 The following exception occurred: Unable to install Windows Installer MSP file Date: 04/23/2006 09:33:20.311 File: \depot\sqlvault\setupmain\setup\sqlse\sqlsedll\copyengine.cpp Line: 856
04/23/2006 09:33:20.374
04/23/2006 09:33:20.405 Product Status Summary:
04/23/2006 09:33:20.421 Product: SQL Server Native Client
04/23/2006 09:33:20.436 SQL Server Native Client (RTM ) - Success
04/23/2006 09:33:20.499
04/23/2006 09:33:20.514 Product: Setup Support Files
04/23/2006 09:33:20.514 Setup Support Files (RTM ) - Success
04/23/2006 09:33:20.546
04/23/2006 09:33:20.561 Product: Database Services
04/23/2006 09:33:20.577 Database Services (RTM 1399 ENU) - Failure
04/23/2006 09:33:20.592 Details: Unable to install Windows Installer MSP file
04/23/2006 09:33:20.608 Analysis Services (SP1 2047 ENU) - Not Applied
04/23/2006 09:33:20.624 Reporting Services (SP1 2047 ENU) - Not Applied
04/23/2006 09:33:20.655
04/23/2006 09:33:20.655 Product: Notification Services
04/23/2006 09:33:20.671 Notification Services (SP1 2047 ENU) - Not Applied
04/23/2006 09:33:20.686
04/23/2006 09:33:20.702 Product: Integration Services
04/23/2006 09:33:20.733 Integration Services (SP1 2047 ENU) - Not Applied
04/23/2006 09:33:20.749
04/23/2006 09:33:20.764 Product: Client Components
04/23/2006 09:33:20.796 Client Components (RTM 1399 ENU) - Not Applied
04/23/2006 09:33:20.827
04/23/2006 09:33:20.842 Product: MSXML 6.0 Parser
04/23/2006 09:33:20.874 MSXML 6.0 Parser (RTM ) - Not Applied
04/23/2006 09:33:20.905
04/23/2006 09:33:20.936 Product: SQLXML4
04/23/2006 09:33:20.952 SQLXML4 (RTM ) - Not Applied
04/23/2006 09:33:20.967
04/23/2006 09:33:21.014 Product: Backward Compatibility
04/23/2006 09:33:21.030 Backward Compatibility (RTM ) - Not Applied
04/23/2006 09:33:21.030
04/23/2006 09:33:21.061 Product: Microsoft SQL Server VSS Writer
04/23/2006 09:33:21.077 Microsoft SQL Server VSS Writer (RTM ) - Not Applied
04/23/2006 09:33:21.092

Moving to the Setup and Upgrade forum...

There is a separate setup log for "database services" component at C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090.log. Open it up and see there is anything obvious. If not, please reply back with a pointer to that log file (or the content directly if the file is not too big).

|||

Thank you for your response.

The first install failure indicated that there was not enough free space on the system partition. After freeing up about 1.5 GB of space I had attempted to apply SP1 3 times of which all attempts failed with the same messaging you will see below.

Below are the contents of that log file you requested. Please note a lot of the components were not selected because they had previously installed successfully.

04/23/2006 22:28:15.512 ================================================================================
04/23/2006 22:28:15.512 Hotfix package launched
04/23/2006 22:28:18.575 Product discovery successfully completed during the install process for MSSQLSERVER
04/23/2006 22:28:18.590 SP Level check successfully completed during the install process for MSSQLSERVER
04/23/2006 22:28:18.606 Product language check successfully completed during the install process for MSSQLSERVER
04/23/2006 22:28:18.622 Product version check successfully completed during the install process for MSSQLSERVER
04/23/2006 22:28:18.637 Command-line instance name check completed during the install process
04/23/2006 22:28:18.653 Baseline build check completed during the install process
04/23/2006 22:32:00.578 Attempting to install instance: MSSQLSERVER
04/23/2006 22:32:00.593 Attempting to install target: BUBBA
04/23/2006 22:32:00.609 Attempting to stop service: MSSQLServer
04/23/2006 22:32:03.625 Successfully stopped service: MSSQLServer
04/23/2006 22:32:03.640 Attempting to check for locked files: sqlrun_sql.msp
04/23/2006 22:32:03.718 Attempting to check for locked files: \\BUBBA\f$\2622ddd6e585e0b7e51654259c1ce5\HotFixSQL\Files\sqlrun_sql.msp
04/23/2006 22:32:03.734 Creating MSP locked file check log at: C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.out
04/23/2006 22:32:30.562 MSP returned 1602: The user cancels installation.
04/23/2006 22:32:30.734 Successfully checked file: \\BUBBA\f$\2622ddd6e585e0b7e51654259c1ce5\HotFixSQL\Files\sqlrun_sql.msp
04/23/2006 22:32:30.766 Successfully opened registry key: System\CurrentControlSet\Control\Session Manager
04/23/2006 22:32:30.766 Failed to read registry key: PendingFileRenameOperations
04/23/2006 22:32:30.781 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xmlfilt.dll
04/23/2006 22:32:30.797 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\ThaWBrkr.dll
04/23/2006 22:32:30.812 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\query.dll
04/23/2006 22:32:30.828 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\nls400.dll
04/23/2006 22:32:30.844 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\nlhtml.dll
04/23/2006 22:32:30.859 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msir5jp.dll
04/23/2006 22:32:30.859 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msftesql.exe
04/23/2006 22:32:30.875 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msftepxy.dll
04/23/2006 22:32:30.891 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msftefd.exe
04/23/2006 22:32:30.906 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msfte.dll
04/23/2006 22:32:30.906 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\LangWrbk.dll
04/23/2006 22:32:30.937 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\korwbrkr.dll
04/23/2006 22:32:30.937 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\infosoft.dll
04/23/2006 22:32:30.953 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\FTERef\FTERef.dll
04/23/2006 22:32:30.969 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\CHTBRKR.DLL
04/23/2006 22:32:30.984 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\ChsBrkr.dll
04/23/2006 22:32:31.000 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\COM\Resources\1033\REPLRES.rll
04/23/2006 22:32:31.016 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\COM\replrec.dll
04/23/2006 22:32:31.016 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\COM\rplisapi.dll
04/23/2006 22:32:31.031 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\WINDOWS\assembly\GAC_32\Microsoft.SqlServer.Replication\9.0.242.0__89845dcd8080cc91\Repl.dll
04/23/2006 22:32:31.047 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.DataStorage\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.DataStorage.dll
04/23/2006 22:32:31.062 Failed to read version information for the following file: C:\Program Files\Common Files\Microsoft Shared\Database Replication\Resources\1033\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\rplhtfin.sql
04/23/2006 22:32:31.062 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\
C:\Program Files\Microsoft SQL Server\90\COM\qrdrsvc.exe
04/23/2006 22:32:31.078 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\COM\snapshot.exe
04/23/2006 22:32:31.094 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\COM\replmerg.exe
04/23/2006 22:32:31.109 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\tablediff.exe
04/23/2006 22:32:31.125 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\COM\DISTRIB.exe
04/23/2006 22:32:31.141 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\DatabaseMail90.exe
04/23/2006 22:32:31.141 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\3082\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\2052\sqlevn70.rll
04/23/2006 22:32:31.172 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1042\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1041\sqlevn70.rll
04/23/2006 22:32:31.172 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1040\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1036\sqlevn70.rll
04/23/2006 22:32:31.187 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1031\sqlevn70.rll
04/23/2006 22:32:31.203 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1028\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\XPStar90.RLL
04/23/2006 22:32:31.219 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlaccess.dll
04/23/2006 22:32:31.234 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlaccess.dll
04/23/2006 22:32:31.250 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlaccess.dll
04/23/2006 22:32:31.250 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\6.6.3.5
C:\Program Files\Microsoft SQL Server\90\Shared\msxmlsql.dll
04/23/2006 22:32:31.266 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\2.0.3609.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xmlrw.dll
04/23/2006 22:32:31.281 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlsvc90.dll
04/23/2006 22:32:31.297 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlsvc90.dll
04/23/2006 22:32:31.312 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlsvc90.dll
04/23/2006 22:32:31.312 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLBOOT.dll
04/23/2006 22:32:31.344 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xplog70.dll
04/23/2006 22:32:31.344 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\batchp~1.dll
04/23/2006 22:32:31.359 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\SQLAgentMail90.rll
04/23/2006 22:32:31.375 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\SQLAgentMail90.rll
04/23/2006 22:32:31.391 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\SQLAgentMail90.rll
04/23/2006 22:32:31.422 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\SQLAGENT90.RLL
04/23/2006 22:32:31.437 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\SQLAGENT90.RLL
04/23/2006 22:32:31.453 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\SQLAGENT90.RLL
04/23/2006 22:32:31.469 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAgentMail90.dll
04/23/2006 22:32:31.484 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAgentMail90.dll
04/23/2006 22:32:31.500 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAgentMail90.dll
04/23/2006 22:32:31.500 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAGENT90.EXE
04/23/2006 22:32:31.516 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAGENT90.EXE
04/23/2006 22:32:31.531 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAGENT90.EXE
04/23/2006 22:32:31.547 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\Resources\1033\9.0.2047.0
C:\Program Files\Microsoft SQL Server\90\Shared\msmdrdir.dll
04/23/2006 22:32:31.562 Failed to read version information for the following file: C:\Program Files\Common Files\System\ole db\2.0.3609.0
C:\Program Files\Common Files\System\ole db\xmlrw.dll
04/23/2006 22:32:31.578 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\msmdlocal.dll
04/23/2006 22:32:31.594 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\msmdlocal.dll
04/23/2006 22:32:31.609 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\msmdlocal.dll
04/23/2006 22:32:31.609 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe
04/23/2006 22:32:31.625 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe
04/23/2006 22:32:31.641 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe
04/23/2006 22:32:31.656 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\msasxpress.dll
04/23/2006 22:32:31.672 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\msasxpress.dll
04/23/2006 22:32:31.687 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\msasxpress.dll
04/23/2006 22:32:31.703 Failed to read version information for the following file: C:\Program Files\Microsoft.NET\ADOMD.NET\90\en\Microsoft.AnalysisServices.AdomdClient.xml
04/23/2006 22:32:31.719 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft.NET\ADOMD.NET\90\Microsoft.AnalysisServices.AdomdClient.dll
04/23/2006 22:32:31.719 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.AnalysisServices.AdomdClient\9.0.242.0__89845dcd8080cc91\Microsoft.AnalysisServices.AdomdClient.dll
04/23/2006 22:32:31.734 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\sqlcm.xml
04/23/2006 22:32:31.750 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\SqlManager.rll
04/23/2006 22:32:31.750 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\SqlManager.rll
04/23/2006 22:32:31.781 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\SqlManager.rll
04/23/2006 22:32:31.781 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\binn\SqlManager.dll
04/23/2006 22:32:31.797 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\binn\SqlManager.dll
04/23/2006 22:32:31.812 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\binn\SqlManager.dll
04/23/2006 22:32:31.828 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\batchparser90.dll
04/23/2006 22:32:31.844 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\batchparser90.dll
04/23/2006 22:32:31.859 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\batchparser90.dll
04/23/2006 22:32:31.859 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\Tools\binn\SQLSVC90.DLL
04/23/2006 22:32:31.875 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\2.0.3609.0
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLdiag.exe
04/23/2006 22:32:31.891 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\Shared\sqlsvc~1.dll
04/23/2006 22:32:31.906 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlsecacctchg.dll
04/23/2006 22:32:31.922 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlsecacctchg.dll
04/23/2006 22:32:31.937 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlsecacctchg.dll
04/23/2006 22:32:31.953 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlftacct.dll
04/23/2006 22:32:31.969 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlftacct.dll
04/23/2006 22:32:31.969 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlftacct.dll
04/23/2006 22:32:31.984 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\isacctchange.dll
04/23/2006 22:32:32.000 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\isacctchange.dll
04/23/2006 22:32:32.016 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\isacctchange.dll
04/23/2006 22:32:32.031 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\svrenumapi.dll
04/23/2006 22:32:32.031 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\svrenumapi.dll
04/23/2006 22:32:32.047 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\svrenumapi.dll
04/23/2006 22:32:32.062 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\Shared\sqlsqm.exe
04/23/2006 22:32:32.078 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\9.0.2047.0
C:\Program Files\Microsoft SQL Server\90\Shared\dbghelp.dll
04/23/2006 22:32:32.094 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\SqlDumper.exe
04/23/2006 22:32:32.109 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\SqlDumper.exe
04/23/2006 22:32:32.125 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\SqlDumper.exe
04/23/2006 22:32:32.141 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.Rmo\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.Rmo.dll
04/23/2006 22:32:32.141 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.AnalysisServices\9.0.242.0__89845dcd8080cc91\Microsoft.AnalysisServices.DLL
04/23/2006 22:32:32.156 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.DataWarehouse.Interfaces\9.0.242.0__89845dcd8080cc91\Microsoft.DataWarehouse.Interfaces.DLL
04/23/2006 22:32:32.172 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.RegSvrEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.RegSvrEnum.dll
04/23/2006 22:32:32.187 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_32\Microsoft.SqlServer.BatchParser\9.0.242.0__89845dcd8080cc91\microsoft.sqlserver.batchparser.dll
04/23/2006 22:32:32.203 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_32\Microsoft.SqlServer.BatchParser\9.0.242.0__89845dcd8080cc91\microsoft.sqlserver.batchparser.dll
04/23/2006 22:32:32.219 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_32\Microsoft.SqlServer.BatchParser\9.0.242.0__89845dcd8080cc91\microsoft.sqlserver.batchparser.dll
04/23/2006 22:32:32.219 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ServiceBrokerEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.ServiceBrokerEnum.dll
04/23/2006 22:32:32.234 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.WmiEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.WmiEnum.dll
04/23/2006 22:32:32.250 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.SqlEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.SqlEnum.dll
04/23/2006 22:32:32.266 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.SmoEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.SmoEnum.dll
04/23/2006 22:32:32.281 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.Smo\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.Smo.dll
04/23/2006 22:32:32.297 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\SqlSAC.exe
04/23/2006 22:32:32.312 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\Microsoft.SqlSac.Public.dll
04/23/2006 22:32:32.391 Attempting to install file: sqlrun_sql.msp
04/23/2006 22:32:32.437 Attempting to install file: \\BUBBA\f$\2622ddd6e585e0b7e51654259c1ce5\HotFixSQL\Files\sqlrun_sql.msp
04/23/2006 22:32:32.453 Creating MSP install log file at: C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.log
04/23/2006 22:32:32.469 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
04/23/2006 22:32:32.484 Failed to read registry key: Debug
04/23/2006 22:34:29.986 MSP returned 1603: A fatal error occurred during installation.
04/23/2006 22:34:30.143 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
04/23/2006 22:34:30.174 Failed to read registry key: Debug
04/23/2006 22:34:30.189 Unable to install MSP file: \\BUBBA\f$\2622ddd6e585e0b7e51654259c1ce5\HotFixSQL\Files\sqlrun_sql.msp
04/23/2006 22:34:30.205 The following exception occurred: Unable to install Windows Installer MSP file Date: 04/23/2006 22:34:30.205 File: \depot\sqlvault\setupmain\setup\sqlse\sqlsedll\copyengine.cpp Line: 856
04/23/2006 22:34:30.283
04/23/2006 22:34:30.314 Product Status Summary:
04/23/2006 22:34:30.330 Product: SQL Server Native Client
04/23/2006 22:34:30.346 SQL Server Native Client (RTM ) - Success
04/23/2006 22:34:30.377
04/23/2006 22:34:30.393 Product: Setup Support Files
04/23/2006 22:34:30.408 Setup Support Files (RTM ) - Success
04/23/2006 22:34:30.455
04/23/2006 22:34:30.486 Product: Database Services
04/23/2006 22:34:30.502 Database Services (RTM 1399 ENU) - Failure
04/23/2006 22:34:30.533 Details: Unable to install Windows Installer MSP file
04/23/2006 22:34:30.564 Analysis Services (SP1 2047 ENU) - Not Applied
04/23/2006 22:34:30.580 Reporting Services (SP1 2047 ENU) - Not Applied
04/23/2006 22:34:30.611
04/23/2006 22:34:30.627 Product: Notification Services
04/23/2006 22:34:30.643 Notification Services (SP1 2047 ENU) - Not Selected
04/23/2006 22:34:30.658
04/23/2006 22:34:30.689 Product: Integration Services
04/23/2006 22:34:30.721 Integration Services (SP1 2047 ENU) - Not Selected
04/23/2006 22:34:30.736
04/23/2006 22:34:30.752 Product: Client Components
04/23/2006 22:34:30.799 Client Components (SP1 2047 ENU) - Not Selected
04/23/2006 22:34:30.830
04/23/2006 22:34:30.861 Product: MSXML 6.0 Parser
04/23/2006 22:34:30.893 MSXML 6.0 Parser (RTM ) - Not Selected
04/23/2006 22:34:30.924
04/23/2006 22:34:30.939 Product: SQLXML4
04/23/2006 22:34:30.971 SQLXML4 (RTM ) - Not Selected
04/23/2006 22:34:30.986
04/23/2006 22:34:31.080 Product: Backward Compatibility
04/23/2006 22:34:31.283 Backward Compatibility (RTM ) - Not Selected
04/23/2006 22:34:31.299
04/23/2006 22:34:31.299 Product: Microsoft SQL Server VSS Writer
04/23/2006 22:34:31.314 Microsoft SQL Server VSS Writer (RTM ) - Not Selected
04/23/2006 22:34:31.330
04/23/2006 22:39:02.586 Hotfix package closed

|||

Thanks for the log. Hm, there is nothing interesting here. Let's try a different log. Open C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.log and do a search for "ue 3". If found, copy a block of text from 10 lines above "ue 3" to 10 lines below "ue 3" back to this thread (or if you can tell that the error is bigger, copy the whole error block). This usually helps locate the problem.

|||

I'm experiencing the same problem described above. Here is the block of error lines from my SQL9_Hotfix_KB913090_sqlrun_sql.msp.log file that you mentioned above.

I'm not sure why it the procsyst.sql file is not there, or where it should be.

Thanks for any help.

<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Doing Action: CommitSqlUpgrade
PerfTime Start: CommitSqlUpgrade : Wed May 10 16:51:44 2006
<Func Name='ComponentUpgrade'>
There was a failure during installation search up in this log file for this message:
SQL Server Setup failed to parse the SQL script "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Upgrade\procsyst.sql". The error code is The system cannot find the file specified.
. To continue, correct the problem, and then run SQL Server Setup again.
<EndFunc Name='ComponentUpgrade' Return='2' GetLastError='0'>
PerfTime Stop: CommitSqlUpgrade : Wed May 10 16:51:44 2006
Gathering darwin properties for failure handling.
<EndFunc Name='LaunchFunction' Return='2' GetLastError='0'>
MSI (s) (3C:80) [16:51:44:781]: Transforming table InstallExecuteSequence.

MSI (s) (3C:80) [16:51:44:781]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (3C:80) [16:51:44:781]: Transforming table InstallExecuteSequence.

MSI (s) (3C:80) [16:51:44:781]: Transforming table InstallExecuteSequence.

MSI (s) (3C:80) [16:51:44:781]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (3C:80) [16:51:44:781]: Transforming table InstallExecuteSequence.

MSI (s) (3C:80) [16:51:44:781]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
Action ended 16:51:44: CommitSqlUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.
Action ended 16:51:44: INSTALL. Return value 3.

|||

- Context --

Setting status of unmanaged components and removing unmanaged resources

MSI (s) (8C!88) [08:33:44:201]: Transforming table Error.

MSI (s) (8C!88) [08:33:44:201]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (8C!88) [08:33:44:201]: Transforming table Error.

MSI (s) (8C!88) [08:33:44:201]: Transforming table Error.

MSI (s) (8C!88) [08:33:44:201]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (8C!88) [08:33:44:201]: Transforming table Error.

MSI (s) (8C!88) [08:33:44:201]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 29506
MSI (s) (8C!88) [08:33:44:201]: Transforming table Error.

MSI (s) (8C!88) [08:33:44:201]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (8C!88) [08:33:44:201]: Transforming table Error.

MSI (s) (8C!88) [08:33:44:201]: Transforming table Error.

MSI (s) (8C!88) [08:33:44:201]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (8C!88) [08:33:44:201]: Transforming table Error.

MSI (s) (8C!88) [08:33:44:201]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (8C!88) [08:33:44:201]: Product: Microsoft SQL Server 2005 -- Error 29506. SQL Server Setup failed to modify security permissions on file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user **********. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that exists on the destination drive.

|||

This link got me started. It is saying that the master database and the sysresources database (new in 2005) need to be in the same directory for the upgrade to be successful. What they don't say is that the distmdl database also needs to be in that same directory.

http://support.microsoft.com/kb/918695/EN-US/

I had moved master and its log to separate database and log disk drives. I moved them back to the install directory (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data in our case), changed config manager to reflect the new location, and the install went through with no issues.

Moving the master database after install is not atypical. This is an interesting hole to fall into...

|||

I have worked my way through all of this and to no avail. I installed on 5 servers and only have an issue with this one. Dis anyone come up with any other solutions?

Master Chief

Tuesday, March 20, 2012

BUG: 3rd Request: Series style function BUG in SP1

Monday, March 19, 2012

Bug with 'enable identity insert on'

Bug report RS with SP1

Sunday, March 11, 2012

Bug Listing?

Bug in SQL 2005 SP1

Boot.ini file

Blog Archive

About Me