Hello,
I'm creating a maintenance plan for a SQL SERVER DB in 64 bits. The plan
includes rebuild indexes, check integrity, update statistics, etc.
I'm using the wizard to create to plan, but at the when I press the finish
button at the end of the wizard there is an error message and I'm unable to
create the plan.
The error message is include at the end of this email.
Does anybody know what could be causing the error?
In advance I appreciate your help and comments.
Edmundo J. Davila
ERROR
---
TITLE: Maintenance Plan Wizard Progress
--
Create maintenance plan failed.
ADDITIONAL INFORMATION:
Create failed for JobStep 'Subplan'.
(Microsoft.SqlServer.MaintenancePlanTasks)
For help, click:
EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExcept
ionText&EvtID=Create+JobStep&LinkId=20476" target="_blank">http://go.microsoft.com/fwlink?Prod...ep&LinkId=20476
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
The specified '@.subsystem' is invalid (valid values are returned by
sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
For help, click:
tSrc=MSSQLServer&EvtID=14234&LinkId=20476" target="_blank">http://go.microsoft.com/fwlink?Prod...34&LinkId=20476
BUTTONS:
OK
--This question has already been answered.
Ekrem nsoy
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:4F578C0F-8F8A-4371-88B1-C6FDA8C0D4AD@.microsoft.com...
> Hello,
> I'm creating a maintenance plan for a SQL SERVER DB in 64 bits. The plan
> includes rebuild indexes, check integrity, update statistics, etc.
> I'm using the wizard to create to plan, but at the when I press the finish
> button at the end of the wizard there is an error message and I'm unable
> to create the plan.
> The error message is include at the end of this email.
> Does anybody know what could be causing the error?
> In advance I appreciate your help and comments.
> Edmundo J. Davila
> ERROR
> ---
>
> TITLE: Maintenance Plan Wizard Progress
> --
> Create maintenance plan failed.
> --
> ADDITIONAL INFORMATION:
> Create failed for JobStep 'Subplan'.
> (Microsoft.SqlServer.MaintenancePlanTasks)
> For help, click:
> 0&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExce
ptionText&EvtID=Create+JobStep&LinkId=20476" target="_blank">http://go.microsoft.com/fwlink?Prod...ep&LinkId=20476
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The specified '@.subsystem' is invalid (valid values are returned by
> sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
> For help, click:
> EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476" target="_blank">http://go.microsoft.com/fwlink?Prod...34&LinkId=20476
> --
> BUTTONS:
> OK
> --
>
Showing posts with label indexes. Show all posts
Showing posts with label indexes. Show all posts
Wednesday, March 21, 2012
Monday, March 19, 2012
Error creating Indexes in ROLAP based OLAP in Analysis Server 2005
Hi,
We are implementing OLAP based system in which the team has decided to use ROLAP as storage structure. But we are getting error while deploying the cube. The error is
OLE DB error: OLE DB or ODBC error: Cannot create index on view "Reporting.dbo.Agg_Fact Table_27_48_48_44_44_4" because it references derived table "dbo_Fact_Table" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.; 42000.
It seems that it has created a view that uses derived table and tries to create a clustered index on that. [Indexed View]. The above view definition contains derived table but as we know that the Indexed view can’t contain derived table. What is the workaround for this problem?
Thanks a lot for any advice.
Rakesh Mishra
Hi Rakesh
I got the same problem and can't find any solution. Did you find any workaround to solve the problem
Leo
|||Hi,
I have experienced the same problem. Has this issue been resolved?
Thanks,
Bill
|||I am sorry for *bumping* this one up, but I encounter the same problem on my project, so I wonder if there is a solution for it.
I would like to add that my project works well in MOLAP and does process completly without errors, switching to rolap gives the same message as the original poster has, with some different names and numbers for the tables and index columns of course.
Thanks
Ralf
|||I have encountered this issue as well. I too wonder if there is a solution for this.
It appears to be only an issue when a particular attribute is used in an aggregation.
Error creating Indexes in ROLAP based OLAP in Analysis Server 2005
Hi,
We are implementing OLAP based system in which the team has decided to use ROLAP as storage structure. But we are getting error while deploying the cube. The error is
OLE DB error: OLE DB or ODBC error: Cannot create index on view "Reporting.dbo.Agg_Fact Table_27_48_48_44_44_4" because it references derived table "dbo_Fact_Table" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.; 42000.
It seems that it has created a view that uses derived table and tries to create a clustered index on that. [Indexed View]. The above view definition contains derived table but as we know that the Indexed view can’t contain derived table. What is the workaround for this problem?
Thanks a lot for any advice.
Rakesh Mishra
Hi Rakesh
I got the same problem and can't find any solution. Did you find any workaround to solve the problem
Leo
|||Hi,
I have experienced the same problem. Has this issue been resolved?
Thanks,
Bill
|||I am sorry for *bumping* this one up, but I encounter the same problem on my project, so I wonder if there is a solution for it.
I would like to add that my project works well in MOLAP and does process completly without errors, switching to rolap gives the same message as the original poster has, with some different names and numbers for the tables and index columns of course.
Thanks
Ralf
|||I have encountered this issue as well. I too wonder if there is a solution for this.
It appears to be only an issue when a particular attribute is used in an aggregation.
Error creating Indexes in ROLAP based OLAP in Analysis Server 2005
Hi,
We are implementing OLAP based system in which the team has decided to use ROLAP as storage structure. But we are getting error while deploying the cube. The error is
OLE DB error: OLE DB or ODBC error: Cannot create index on view "Reporting.dbo.Agg_Fact Table_27_48_48_44_44_4" because it references derived table "dbo_Fact_Table" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.; 42000.
It seems that it has created a view that uses derived table and tries to create a clustered index on that. [Indexed View]. The above view definition contains derived table but as we know that the Indexed view can’t contain derived table. What is the workaround for this problem?
Thanks a lot for any advice.
Rakesh Mishra
Hi Rakesh
I got the same problem and can't find any solution. Did you find any workaround to solve the problem
Leo
|||Hi,
I have experienced the same problem. Has this issue been resolved?
Thanks,
Bill
|||I am sorry for *bumping* this one up, but I encounter the same problem on my project, so I wonder if there is a solution for it.
I would like to add that my project works well in MOLAP and does process completly without errors, switching to rolap gives the same message as the original poster has, with some different names and numbers for the tables and index columns of course.
Thanks
Ralf
|||I have encountered this issue as well. I too wonder if there is a solution for this.
It appears to be only an issue when a particular attribute is used in an aggregation.
Error creating Indexes in ROLAP based OLAP in Analysis Server 2005
Hi,
We are implementing OLAP based system in which the team has decided to use ROLAP as storage structure. But we are getting error while deploying the cube. The error is
OLE DB error: OLE DB or ODBC error: Cannot create index on view "Reporting.dbo.Agg_Fact Table_27_48_48_44_44_4" because it references derived table "dbo_Fact_Table" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.; 42000.
It seems that it has created a view that uses derived table and tries to create a clustered index on that. [Indexed View]. The above view definition contains derived table but as we know that the Indexed view can’t contain derived table. What is the workaround for this problem?
Thanks a lot for any advice.
Rakesh Mishra
Hi Rakesh
I got the same problem and can't find any solution. Did you find any workaround to solve the problem
Leo
|||Hi,
I have experienced the same problem. Has this issue been resolved?
Thanks,
Bill
|||I am sorry for *bumping* this one up, but I encounter the same problem on my project, so I wonder if there is a solution for it.
I would like to add that my project works well in MOLAP and does process completly without errors, switching to rolap gives the same message as the original poster has, with some different names and numbers for the tables and index columns of course.
Thanks
Ralf
|||I have encountered this issue as well. I too wonder if there is a solution for this.
It appears to be only an issue when a particular attribute is used in an aggregation.
Subscribe to:
Posts (Atom)