Showing posts with label 7th. Show all posts
Showing posts with label 7th. Show all posts

Tuesday, March 20, 2012

Can not change filter on model report - UPDATED 7th June

I have a very simple report based on a test model.

The report is filtered via a date field and runs ok.

If I try to change the filter I get the following error message:

Operation Failed

Short time pattern does not include hours and minutes

Does anyone know how I can correct this?

Regards

John

UPDATE

This only happens if I try to filter between two dates, a single date works correctly!

Can you please save report that fails to file and post it?|||

Alexandre

This is the rdl for the failing report.

<?xml version="1.0" encoding="utf-8"?>

<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

<Language>en-US</Language>

<BottomMargin>0.5in</BottomMargin>

<RightMargin>0.5in</RightMargin>

<DataSets>

<DataSet Name="dataSet">

<Query>

<DataSourceName>dataSource1</DataSourceName>

<CommandText>&lt;SemanticQuery xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:rb="http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder" xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"&gt;

&lt;Hierarchies&gt;

&lt;Hierarchy&gt;

&lt;BaseEntity&gt;

&lt;!--Epex Referral--&gt;

&lt;EntityID&gt;G066c76f8-9856-4acd-8b54-d734971da2c8&lt;/EntityID&gt;

&lt;/BaseEntity&gt;

&lt;Groupings&gt;

&lt;Grouping Name="Epex Referral"&gt;

&lt;Expression Name="Epex Referral"&gt;

&lt;EntityRef&gt;

&lt;!--Epex Referral--&gt;

&lt;EntityID&gt;G066c76f8-9856-4acd-8b54-d734971da2c8&lt;/EntityID&gt;

&lt;/EntityRef&gt;

&lt;/Expression&gt;

&lt;Details&gt;

&lt;Expression Name="Created"&gt;

&lt;AttributeRef&gt;

&lt;!--Created--&gt;

&lt;AttributeID&gt;G9a9689b0-64a7-49de-abae-58b8d30322e9&lt;/AttributeID&gt;

&lt;/AttributeRef&gt;

&lt;/Expression&gt;

&lt;Expression Name="Close Date"&gt;

&lt;AttributeRef&gt;

&lt;!--Close Date--&gt;

&lt;AttributeID&gt;G36ac2614-9e79-4c60-9c3e-fc45de7c67ec&lt;/AttributeID&gt;

&lt;/AttributeRef&gt;

&lt;/Expression&gt;

&lt;Expression Name="Patient"&gt;

&lt;Path&gt;

&lt;RolePathItem&gt;

&lt;!--Patient--&gt;

&lt;RoleID&gt;G036974d5-33a0-4096-bc96-166d82853818&lt;/RoleID&gt;

&lt;/RolePathItem&gt;

&lt;/Path&gt;

&lt;AttributeRef&gt;

&lt;!--Name--&gt;

&lt;AttributeID&gt;Gd6622d3c-8a4f-4273-a190-c8834bf90031&lt;/AttributeID&gt;

&lt;/AttributeRef&gt;

&lt;/Expression&gt;

&lt;Expression Name="expr1"&gt;

&lt;AttributeRef&gt;

&lt;!--Updated--&gt;

&lt;AttributeID&gt;Gfee3c95d-eb72-48c3-b372-0e2865ac44c8&lt;/AttributeID&gt;

&lt;/AttributeRef&gt;

&lt;/Expression&gt;

&lt;/Details&gt;

&lt;/Grouping&gt;

&lt;/Groupings&gt;

&lt;Filter&gt;

&lt;Expression Name="expr2"&gt;

&lt;Function&gt;

&lt;FunctionName&gt;And&lt;/FunctionName&gt;

&lt;Arguments&gt;

&lt;Expression&gt;

&lt;Function&gt;

&lt;FunctionName&gt;GreaterThanOrEquals&lt;/FunctionName&gt;

&lt;Arguments&gt;

&lt;Expression&gt;

&lt;AttributeRef&gt;

&lt;!--Created--&gt;

&lt;AttributeID&gt;G9a9689b0-64a7-49de-abae-58b8d30322e9&lt;/AttributeID&gt;

&lt;/AttributeRef&gt;

&lt;/Expression&gt;

&lt;Expression&gt;

&lt;Literal&gt;

&lt;DataType&gt;DateTime&lt;/DataType&gt;

&lt;Value&gt;2005-01-01T00:00:00&lt;/Value&gt;

&lt;/Literal&gt;

&lt;/Expression&gt;

&lt;/Arguments&gt;

&lt;/Function&gt;

&lt;/Expression&gt;

&lt;Expression&gt;

&lt;Function&gt;

&lt;FunctionName&gt;LessThanOrEquals&lt;/FunctionName&gt;

&lt;Arguments&gt;

&lt;Expression&gt;

&lt;AttributeRef&gt;

&lt;!--Created--&gt;

&lt;AttributeID&gt;G9a9689b0-64a7-49de-abae-58b8d30322e9&lt;/AttributeID&gt;

&lt;/AttributeRef&gt;

&lt;/Expression&gt;

&lt;Expression&gt;

&lt;Literal&gt;

&lt;DataType&gt;DateTime&lt;/DataType&gt;

&lt;Value&gt;2006-01-01T00:00:00&lt;/Value&gt;

&lt;/Literal&gt;

&lt;/Expression&gt;

&lt;/Arguments&gt;

&lt;/Function&gt;

&lt;/Expression&gt;

&lt;/Arguments&gt;

&lt;/Function&gt;

&lt;CustomProperties&gt;

&lt;CustomProperty Name="qd:FilterCondition" /&gt;

&lt;CustomProperty Name="qd:Filter" /&gt;

&lt;CustomProperty Name="qd:ContextEntityID"&gt;

&lt;Value xsi:type="xsd:string"&gt;G066c76f8-9856-4acd-8b54-d734971da2c8&lt;/Value&gt;

&lt;/CustomProperty&gt;

&lt;CustomProperty Name="qd:AutoChangeBaseEntity" /&gt;

&lt;CustomProperty Name="qd:Design"&gt;

&lt;Value xsi:type="xsd:string"&gt;expr3&lt;/Value&gt;

&lt;/CustomProperty&gt;

&lt;/CustomProperties&gt;

&lt;/Expression&gt;

&lt;/Filter&gt;

&lt;/Hierarchy&gt;

&lt;/Hierarchies&gt;

&lt;CalculatedAttributes&gt;

&lt;Expression Name="expr3"&gt;

&lt;Function&gt;

&lt;FunctionName&gt;And&lt;/FunctionName&gt;

&lt;Arguments&gt;

&lt;Expression&gt;

&lt;Function&gt;

&lt;FunctionName&gt;And&lt;/FunctionName&gt;

&lt;Arguments&gt;

&lt;Expression&gt;

&lt;Function&gt;

&lt;FunctionName&gt;GreaterThanOrEquals&lt;/FunctionName&gt;

&lt;Arguments&gt;

&lt;Expression&gt;

&lt;AttributeRef&gt;

&lt;!--Created--&gt;

&lt;AttributeID&gt;G9a9689b0-64a7-49de-abae-58b8d30322e9&lt;/AttributeID&gt;

&lt;/AttributeRef&gt;

&lt;/Expression&gt;

&lt;Expression&gt;

&lt;Literal&gt;

&lt;DataType&gt;DateTime&lt;/DataType&gt;

&lt;Value&gt;2005-01-01T00:00:00&lt;/Value&gt;

&lt;/Literal&gt;

&lt;/Expression&gt;

&lt;/Arguments&gt;

&lt;/Function&gt;

&lt;/Expression&gt;

&lt;Expression&gt;

&lt;Function&gt;

&lt;FunctionName&gt;LessThanOrEquals&lt;/FunctionName&gt;

&lt;Arguments&gt;

&lt;Expression&gt;

&lt;AttributeRef&gt;

&lt;!--Created--&gt;

&lt;AttributeID&gt;G9a9689b0-64a7-49de-abae-58b8d30322e9&lt;/AttributeID&gt;

&lt;/AttributeRef&gt;

&lt;/Expression&gt;

&lt;Expression&gt;

&lt;Literal&gt;

&lt;DataType&gt;DateTime&lt;/DataType&gt;

&lt;Value&gt;2006-01-01T00:00:00&lt;/Value&gt;

&lt;/Literal&gt;

&lt;/Expression&gt;

&lt;/Arguments&gt;

&lt;/Function&gt;

&lt;/Expression&gt;

&lt;/Arguments&gt;

&lt;/Function&gt;

&lt;CustomProperties&gt;

&lt;CustomProperty Name="qd:FilterCondition" /&gt;

&lt;/CustomProperties&gt;

&lt;/Expression&gt;

&lt;Expression&gt;

&lt;Null /&gt;

&lt;CustomPropertes&gt;

&lt;CustomProperty Name="qd:Unspecified" /&gt;

&lt;/CustomProperties&gt;

&lt;/Expression&gt;

&lt;/Arguments&gt;

&lt;/Function&gt;

&lt;CustomProperties&gt;

&lt;CustomProperty Name="qd:Filter" /&gt;

&lt;CustomProperty Name="qd:ContextEntityID"&gt;

&lt;Value xsi:type="xsd:string"&gt;G066c76f8-9856-4acd-8b54-d734971da2c8&lt;/Value&gt;

&lt;/CustomProperty&gt;

&lt;CustomProperty Name="qd:AutoChangeBaseEntity" /&gt;

&lt;/CustomProperties&gt;

&lt;/Expression&gt;

&lt;/CalculatedAttributes&gt;

&lt;/SemanticQuery&gt;</CommandText>

</Query>

<Fields>

<Field Name="EpexReferral">

<DataField>Epex Referral</DataField>

</Field>

<Field Name="Created">

<DataField>Created</DataField>

</Field>

<Field Name="CloseDate">

<DataField>Close Date</DataField>

</Field>

<Field Name="Patient">

<DataField>Patient</DataField>

</Field>

<Field Name="expr1">

<DataField>expr1</DataField>

</Field>

</Fields>

</DataSet>

</DataSets>

<DataSources>

<DataSource Name="dataSource1">

<DataSourceReference>/Models/Mars Cutdown</DataSourceReference>

<rd:DataSourceID>4d1edcd6-3c78-4e68-9566-ef952e495be4</rd:DataSourceID>

</DataSource>

</DataSources>

<PageHeight>11in</PageHeight>

<LeftMargin>0.5in</LeftMargin>

<TopMargin>0.5in</TopMargin>

<Width>7.5in</Width>

<Body>

<Height>0in</Height>

<ReportItems>

<Textbox Name="Title">

<Left>0.5in</Left>

<Top>0.5in</Top>

<CanGrow>true</CanGrow>

<Width>6.5in</Width>

<Value />

<Style>

<FontFamily>Tahoma</FontFamily>

<TextAlign>Left</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>Normal</FontWeight>

<FontSize>18pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CustomProperties>

<CustomProperty>

<Name>rb:Watermark</Name>

<Value>Click to add title</Value>

</CustomProperty>

</CustomProperties>

<Height>0.375in</Height>

</Textbox>

<Table Name="table">

<Top>1.25in</Top>

<Details>

<TableRows>

<TableRow>

<TableCells>

<TableCell>

<ReportItems>

<Textbox Name="Created_Value">

<DataElementOutput>Output</DataElementOutput>

<CanGrow>true</CanGrow>

<Action>

<Drillthrough>

<ReportName>=DataSources!dataSource1.DataSourceReference</ReportName>

<Parameters>

<Parameter Name="rs:EntityID">

<Value>G066c76f8-9856-4acd-8b54-d734971da2c8</Value>

</Parameter>

<Parameter Name="rs:DrillType">

<Value>Detail</Value>

</Parameter>

<Parameter Name="rs:Command">

<Value>Drillthrough</Value>

</Parameter>

<Parameter Name="DrillthroughSourceQuery">

<Value>=DataSets!dataSet.RewrittenCommandText</Value>

</Parameter>

<Parameter Name="DrillthroughContext">

<Value>=CreateDrillthroughContext()</Value>

</Parameter>

</Parameters>

</Drillthrough>

</Action>

<Value>=Fields!Created.Value</Value>

<Styl>

<Language>en-US</Language>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<FontFamily>Tahoma</FontFamily>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>Normal</FontWeight>

<FontSize>8pt</FontSize>

<Format>d</Format>

<BackgroundColor>White</BackgroundColor>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="CloseDate_Value">

<DataElementOutput>Output</DataElementOutput>

<CanGrow>true</CanGrow>

<Value>=Fields!CloseDate.Value</Value>

<Style>

<Language>en-US</Language>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<FontFamily>Tahoma</FontFamily>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>Normal</FontWeight>

<FontSize>8pt</FontSize>

<Format>d</Format>

<BackgroundColor>White</BackgroundColor>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="Patient_Value">

<DataElementOutput>Output</DataElementOutput>

<CanGrow>true</CanGrow>

<Action>

<Drillthrough>

<ReportName>=DataSources!dataSource1.DataSourceReference</ReportName>

<Parameters>

<Parameter Name="rs:EntityID">

<Value>G2ceef5ce-4e09-4806-8e8c-9a4e4e8f35fa</Value>

</Parameter>

<Parameter Name="rs:DrillType">

<Value>Detail</Value>

</Parameter>

<Parameter Name="rs:Command">

<Value>Drillthrough</Value>

</Parameter>

<Parameter Name="DrillthroughSourceQuery">

<Value>=DataSets!dataSet.RewrittenCommandText</Value>

</Parameter>

<Parameter Name="DrillthroughContext">

<Value>=CreateDrillthroughContext()</Value>

</Parameter>

</Parameters>

</Drillthrough>

</Action>

<Value>=Fields!Patient.Value</Value>

<Style>

<Language>en-US</Language>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<FontFamily>Tahoma</FontFamily>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>Normal</FontWeight>

<FontSize>8pt</FontSize>

<BackgroundColor>White</BackgroundColor>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<Height>0.25in</Height>

</TableRow>

</TableRows>

<Grouping Name="table_EpexReferral">

<GroupExpressions>

<GroupExpression>=Fields!EpexReferral.Value</GroupExpression>

</GroupExpressions>

</Grouping>

<Sorting>

<SortBy>

<SortExpression>=IIf(True, Fields!expr1.Value, Nothing)</SortExpression>

<Direction>Descending</Direction>

</SortBy>

<SortBy>

<SortExpression>=IIf(True, Fields!Created.Value, Nothing)</SortExpression>

<Direction>Descending</Direction>

</SortBy>

</Sorting>

</Details>

<Style />

<Width>0in</Width>

<Height>0in</Height>

<DataSetName>dataSet</DataSetName>

<TableColumns>

<TableColumn>

<Width>0.90092in</Width>

<Visibility>

<Hidden>=Fields!Created.IsMissing</Hidden>

</Visibility>

</TableColumn>

<TableColumn>

<Width>1.06361in</Width>

<Visibility>

<Hidden>=Fields!CloseDate.IsMissing</Hidden>

</Visibility>

</TableColumn>

<TableColumn>

<Width>1.62189in</Width>

<Visibility>

<Hidden>=Fields!Patient.IsMissing</Hidden>

</Visibility>

</TableColumn>

</TableColumns>

<Header>

<TableRows>

<TableRow>

<TableCells>

<TableCell>

<ReportItems>

<Textbox Name="Created_Header">

<CanGrow>true</CanGrow>

<UserSort>

<SortExpression>=Fields!Created.Value</SortExpression>

<SortExpressionScope>table_EpexReferral</SortExpressionScope>

</UserSort>

<Value>Created</Value>

<Style>

<Language>en-US</Language>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<FontFamily>Tahoma</FontFamily>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>Bold</FontWeight>

<FontSize>8pt</FontSize>

<BackgroundColor>#518ae5</BackgroundColor>

<Color>White</Color>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="CloseDate_Header">

<CanGrow>true</CanGrow>

<UserSort>

<SortExpression>=Fields!CloseDate.Value</SortExpression>

<SortExpressionScope>table_EpexReferral</SortExpressionScope>

</UserSort>

<Value>Close Date</Value>

<Style

<Language>en-US</Language>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<FontFamily>Tahoma</FontFamily>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>Bold</FontWeight>

<FontSize>8pt</FontSize>

<BackgroundColor>#518ae5</BackgroundColor>

<Color>White</Color>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="Patient_Header">

<CanGrow>true</CanGrow>

<UserSort>

<SortExpression>=Fields!Patient.Value</SortExpression>

<SortExpressionScope>table_EpexReferral</SortExpressionScope>

</UserSort>

<Value>Patient</Value>

<Style>

<Language>en-US</Language>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<FontFamily>Tahoma</FontFamily>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>Bold</FontWeight>

<FontSize>8pt</FontSize>

<BackgroundColor>#518ae5</BackgroundColor>

<Color>White</Color>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<Height>0.25in</Height>

</TableRow>

</TableRows>

<RepeatOnNewPage>true</RepeatOnNewPage>

<FixedHeader>true</FixedHeader>

</Header>

<Left>0.5in</Left>

</Table>

<Textbox Name="TotalRows">

<Left>0.5in</Left>

<Top>3in</Top>

<CanGrow>true</CanGrow>

<Width>6.5in</Width>

<Value>=String.Format("Total Epex Referrals" &amp; Chr(58) &amp; " {0}", COUNTROWS("dataSet"))</Value>

<Style>

<PaddingLeft>3pt</PaddingLeft>

<PaddingBottom>3pt</PaddingBottom>

<FontWeight>Normal</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>3pt</PaddingRight>

<PaddingTop>3pt</PaddingTop>

</Style>

<CustomProperties>

<CustomProperty>

<Name>rb:SpecialContent</Name>

<Value>TotalRows</Value>

</CustomProperty>

</CustomProperties>

<Height>0.25in</Height>

</Textbox>

<Textbox Name="FilterDescription">

<Left>0.5in</Left>

<Top>3.5in</Top>

<CanGrow>true</CanGrow>

<Width>6.5in</Width>

<Value>Filter: Epex Referrals with: Created from 01/01/2005 to 01/01/2006</Value>

<Style>

<PaddingLeft>3pt</PaddingLeft>

<PaddingBottom>3pt</PaddingBottom>

<FontWeight>Normal</FontWeight>

<FontSize>8pt</FontSize>

<PaddingRight>3pt</PaddingRight>

<PaddingTop>3pt</PaddingTop>

</Style>

<CustomProperties>

<CustomProperty>

<Name>rb:SpecialContent</Name>

Value>FilterDescription</Value>

</CustomProperty>

</CustomProperties>

<Height>0.25in</Height>

</Textbox>

</ReportItems>

<Style />

</Body>

<PageWidth>8.5in</PageWidth>

</Report>

|||

Is this error happening when you are editing report or when you are running this report? Can you save this report to report server and run it from Report Manager (http://rshost/reports)?

Thanks!

|||

The report executes with no problems, I only get the error if I try to change the filter.

What is strange, I can get around the error by apply to separate date filters, one using Greater Than Or Equal and the other Less Than or Equal.

This gets around the problem but I would like to offer my end users the option of From and To as this is what the use in other parts of SSRS.

Regards

John

|||

We have the same problem even after installing SP1 and the hotfixes. Has anybody a solution/answer?

Regards

Werner

|||This is a known issue that will be fixed in SP2. Unfortunately the only way to avoid this error for now is to change your Windows regional settings to use a 12-hour clock.|||

Bob,

thanks for the immediate answer, when can we approx. expect SP2?

Regards

Werner

|||No committed dates yet, but I believe it's on track for later this year.|||

Bob,

i tried to change the format in the regional settings like you said but no changes. We use a german W2003 server... When i select a date field in the report builder filter, select a date from the datetime picker (22.06.2006) and try to save it with the ok button i get a message box saying 'no valid date'...?!?

Can i change anything in the model to solve the problem? Is this filter problem caused by SP1 (in this case we could think about setting up the SQL Server again)?

Regards

Werner

Posted by Bryant at 10:36 PM 0 comments
Labels: , , , , , , , , , , , , , , , ,

Can Not add new data file to the primary File group- SQL Server 20

Hi All
I am trying to add a new data file (7th one) to a database on SQL Server
2005
The existing 6th file has autogowth set to grow by 100 MB
When I try to add 7th file to make it autogow by 100 MB on a drive which
more than 300 GB I get the following error
Could not allocate space for object 'sys.sysfiles1'.'sysfiles1' in database
'SomeDb' because the 'PRIMARY' filegroup is full. Create disk space by
deleting unneeded files, dropping objects in the filegroup, adding additional
files to the filegroup, or setting autogrowth on for existing files in the
filegroup.
I tried using T-SQL and also management studio I get the same error
Any advises will be appreciated.
Thanks
KiranAutogrowth is set to 100MB but how about Restricted File Growth?
I think it is set to Restricted File Growth = some_value
Please check out your Database's Properties and Files from options and check
if above mentioned value is set correctly or not.
--
Ekrem Ã?nsoy
"Kiran" <Kiran@.discussions.microsoft.com> wrote in message
news:63E763B8-6677-4F7C-8DC4-194A84344170@.microsoft.com...
> Hi All
> I am trying to add a new data file (7th one) to a database on SQL
> Server
> 2005
> The existing 6th file has autogowth set to grow by 100 MB
> When I try to add 7th file to make it autogow by 100 MB on a drive which
> more than 300 GB I get the following error
> Could not allocate space for object 'sys.sysfiles1'.'sysfiles1' in
> database
> 'SomeDb' because the 'PRIMARY' filegroup is full. Create disk space by
> deleting unneeded files, dropping objects in the filegroup, adding
> additional
> files to the filegroup, or setting autogrowth on for existing files in the
> filegroup.
> I tried using T-SQL and also management studio I get the same error
> Any advises will be appreciated.
> Thanks
> Kiran|||Thanks Ekrem for the reply
I have checked autogowth for the 6th file it is "Unrestricted" and grow by
100 MB
Thanks
Kiran
"Ekrem Ã?nsoy" wrote:
> Autogrowth is set to 100MB but how about Restricted File Growth?
> I think it is set to Restricted File Growth = some_value
> Please check out your Database's Properties and Files from options and check
> if above mentioned value is set correctly or not.
> --
> Ekrem Ã?nsoy
>
> "Kiran" <Kiran@.discussions.microsoft.com> wrote in message
> news:63E763B8-6677-4F7C-8DC4-194A84344170@.microsoft.com...
> > Hi All
> > I am trying to add a new data file (7th one) to a database on SQL
> > Server
> > 2005
> > The existing 6th file has autogowth set to grow by 100 MB
> > When I try to add 7th file to make it autogow by 100 MB on a drive which
> > more than 300 GB I get the following error
> >
> > Could not allocate space for object 'sys.sysfiles1'.'sysfiles1' in
> > database
> > 'SomeDb' because the 'PRIMARY' filegroup is full. Create disk space by
> > deleting unneeded files, dropping objects in the filegroup, adding
> > additional
> > files to the filegroup, or setting autogrowth on for existing files in the
> > filegroup.
> >
> > I tried using T-SQL and also management studio I get the same error
> >
> > Any advises will be appreciated.
> >
> > Thanks
> > Kiran
>|||Hi All
FYI, I see space available under database properties when viewed from
management studio is 0 bytes
Is this preventing addition of new files ? ( Just a guess?)
Thanks
Kiran
"Kiran" wrote:
> Thanks Ekrem for the reply
> I have checked autogowth for the 6th file it is "Unrestricted" and grow by
> 100 MB
> Thanks
> Kiran
>
> "Ekrem Ã?nsoy" wrote:
> > Autogrowth is set to 100MB but how about Restricted File Growth?
> >
> > I think it is set to Restricted File Growth = some_value
> >
> > Please check out your Database's Properties and Files from options and check
> > if above mentioned value is set correctly or not.
> >
> > --
> > Ekrem Ã?nsoy
> >
> >
> >
> > "Kiran" <Kiran@.discussions.microsoft.com> wrote in message
> > news:63E763B8-6677-4F7C-8DC4-194A84344170@.microsoft.com...
> > > Hi All
> > > I am trying to add a new data file (7th one) to a database on SQL
> > > Server
> > > 2005
> > > The existing 6th file has autogowth set to grow by 100 MB
> > > When I try to add 7th file to make it autogow by 100 MB on a drive which
> > > more than 300 GB I get the following error
> > >
> > > Could not allocate space for object 'sys.sysfiles1'.'sysfiles1' in
> > > database
> > > 'SomeDb' because the 'PRIMARY' filegroup is full. Create disk space by
> > > deleting unneeded files, dropping objects in the filegroup, adding
> > > additional
> > > files to the filegroup, or setting autogrowth on for existing files in the
> > > filegroup.
> > >
> > > I tried using T-SQL and also management studio I get the same error
> > >
> > > Any advises will be appreciated.
> > >
> > > Thanks
> > > Kiran
> >
Posted by Bryant at 10:26 PM 0 comments
Labels: , , , , , , , , , , , , ,
Subscribe to: Posts (Atom)