Sql Error message: studio

Showing posts with label studio. Show all posts

Thursday, March 29, 2012

Error renaming analysis services project

After renaming an analysis services project in bi development studio I receive the following error when deploying the project to SQL2005 AS (SP1):

Error 1 The 'Database' with 'ID' = 'AS UPC Chain Sales ' doesn't exist in the collection. 0 0

However the database is available on the server and can be processed and used. Any ideas how to fix this error?

Try to rename your live database on the Analysis Server using SQL Management Studio.

Then create a new project in BI Dev Studio. Select a project type as "Import Analysis Services 9.0 Database...". Follow the steps and get your project re-created based on the live version of the database.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thanks, Edward. Worked like a charm!

Tuesday, March 27, 2012

Error read data from Sybase with SSIS 2005

and it doesn't work.
Could anyone help me please?
Thanks
SalmecFirst, make sure that you can connect to the Sybase system by setting up a
linked server in SQL 2005 (take SSIS out of the picture). If that fails,
check www.connectionstrings.com to see if you're missing something in the
connection string. I assume you have the sybase client installed on the SSIS
box? It would need to be the same if SQL Server were on a different server.
If you can make that connection and make a simple query of the table, beware
of implicit data type conversions. I've had problems doing just this sort of
thing with Sybase when it came to the "money" datatype. You'd think that
since Sybase and SQL Server have a money type that it would work fine. Um,
no. So if you can get it to work as a linked server, try eliminating fields
(especially those that have some uncommon data type).
Hope that helps a bit.
"Sal" <salmec@.gmail.com> wrote in message
news:1152175894.975209.80120@.m73g2000cwd.googlegroups.com...
> Hi to All,
> I am in process of transfering data from Sybase to Sql Server using
> Microsoft Visual Studio 2005
> have taken a Data Flow Task in Control Flow tab
> In Data flow tab, I have taken one Ole DB Source
> I am using Sybase Adaptive Server Anywhere Provider 9.0
> In Ole Db Source Editor ,
> For OLe Db Connection Manager, I choose Sybase Connection
> For Data access mode, I choose Table or View
> For Name of the table or the view, I choose a table by name Table1( it
> lists all the tables from Sybase database)
> When i click on preview button or Columns link, I get the following
> Error
> ________________________________
> TITLE: Microsoft Visual Studio
> --
> Error at Data Flow Task [OLE DB Source [215]]: An OLE DB error has
> occurred. Error code: 0x80040E21.
> Error at Data Flow Task [OLE DB Source [215]]: Unable to retrieve
> column information from the data source. Make sure your target table in
> the database is available.
>
> --
> ADDITIONAL INFORMATION:
> Exception from HRESULT: 0xC020204A
> (Microsoft.SqlServer.DTSPipelineWrap)
> ___________________________________
> I've tried to install "ODBC .NET Data Provider"
> but it wasn't tested with Sybase

and it doesn't work.
> Could anyone help me please?
> Thanks
> Salmec
>|||Hi James,
thanks for your interesting...
i resolved the problem:
i choose the "SSIS import and export Wizard" procedure (project menu)
At th first step - choose a Data Source - I choose ".Net Framework Data
Provider for Odbc"
As destination i've a SQL Native Client
I write a query to select the column tha i would like to import;
I choose the destination table
and after click Finish button
This procedure create a new package that import and convert the data.
and it works
Thanks to all
Sal

Error read data from Sybase with SSIS 2005

Hi to All,
I am in process of transfering data from Sybase to Sql Server using
Microsoft Visual Studio 2005
have taken a Data Flow Task in Control Flow tab
In Data flow tab, I have taken one Ole DB Source
I am using Sybase Adaptive Server Anywhere Provider 9.0
In Ole Db Source Editor ,
For OLe Db Connection Manager, I choose Sybase Connection
For Data access mode, I choose Table or View
For Name of the table or the view, I choose a table by name Table1( it
lists all the tables from Sybase database)
When i click on preview button or Columns link, I get the following
Error
________________________________
TITLE: Microsoft Visual Studio
--
Error at Data Flow Task [OLE DB Source [215]]: An OLE DB error has
occurred. Error code: 0x80040E21.
Error at Data Flow Task [OLE DB Source [215]]: Unable to retrieve
column information from the data source. Make sure your target table in
the database is available.
--
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC020204A
(Microsoft.SqlServer.DTSPipelineWrap)
___________________________________
I've tried to install "ODBC .NET Data Provider"
but it wasn't tested with Sybase :( and it doesn't work.
Could anyone help me please?
Thanks
SalmecFirst, make sure that you can connect to the Sybase system by setting up a
linked server in SQL 2005 (take SSIS out of the picture). If that fails,
check www.connectionstrings.com to see if you're missing something in the
connection string. I assume you have the sybase client installed on the SSIS
box? It would need to be the same if SQL Server were on a different server.
If you can make that connection and make a simple query of the table, beware
of implicit data type conversions. I've had problems doing just this sort of
thing with Sybase when it came to the "money" datatype. You'd think that
since Sybase and SQL Server have a money type that it would work fine. Um,
no. So if you can get it to work as a linked server, try eliminating fields
(especially those that have some uncommon data type).
Hope that helps a bit.
"Sal" <salmec@.gmail.com> wrote in message
news:1152175894.975209.80120@.m73g2000cwd.googlegroups.com...
> Hi to All,
> I am in process of transfering data from Sybase to Sql Server using
> Microsoft Visual Studio 2005
> have taken a Data Flow Task in Control Flow tab
> In Data flow tab, I have taken one Ole DB Source
> I am using Sybase Adaptive Server Anywhere Provider 9.0
> In Ole Db Source Editor ,
> For OLe Db Connection Manager, I choose Sybase Connection
> For Data access mode, I choose Table or View
> For Name of the table or the view, I choose a table by name Table1( it
> lists all the tables from Sybase database)
> When i click on preview button or Columns link, I get the following
> Error
> ________________________________
> TITLE: Microsoft Visual Studio
> --
> Error at Data Flow Task [OLE DB Source [215]]: An OLE DB error has
> occurred. Error code: 0x80040E21.
> Error at Data Flow Task [OLE DB Source [215]]: Unable to retrieve
> column information from the data source. Make sure your target table in
> the database is available.
>
> --
> ADDITIONAL INFORMATION:
> Exception from HRESULT: 0xC020204A
> (Microsoft.SqlServer.DTSPipelineWrap)
> ___________________________________
> I've tried to install "ODBC .NET Data Provider"
> but it wasn't tested with Sybase :( and it doesn't work.
> Could anyone help me please?
> Thanks
> Salmec
>|||Hi James,
thanks for your interesting...
i resolved the problem:
i choose the "SSIS import and export Wizard" procedure (project menu)
At th first step - choose a Data Source - I choose ".Net Framework Data
Provider for Odbc"
As destination i've a SQL Native Client
I write a query to select the column tha i would like to import;
I choose the destination table
and after click Finish button
This procedure create a new package that import and convert the data.
and it works
Thanks to all
Salsql

Error Processing a dimension

I'm having problems processing a dimension.

Before I could process the dimension manually through Mgmt Studio but it would fail when I ran a SQL job with an SSIS package to process the cube. Now I can't

Now I can't even process the dimension manually via Mgmt Studio. I keep getting the error below:

Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_vwRFC_EffortAnalysis_Details, Column: Est_Hours, Value: 0.

Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Vw RFC Effort Analysis Details of Dimension: RFC_EffortAnalysis_Details from Database: ProjectManagement, Record: 6093.

The unknownmember property of the dimension is none.

The nullProcessing proprty of the Est_Hours attribute is Automatic

The dimension view shcema has not changed.

The dimension key attribute does not include the Est_Hours atribute.

Can someone understand the error below? I can provide more information if needed.

Processing Dimension Attribute 'Vw RFC Effort Analysis Details' failed. 1 rows have been read.

(2 detailed error messages

(1)

<Batch ProcessAffectedObjects="true" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Parallel>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlnsdl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlnsdl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">
<Object>
<DatabaseID>ProjectManagement</DatabaseID>
<DimensionID>Vw RFC Effort Analysis Details</DimensionID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>
Processing Cube 'RFC_EffortAnalysis_Details' completed successfully.
Start time: 7/11/2007 2:38:23 PM; End time: 7/11/2007 2:38:23 PM; Duration: 0:00:00
Processing Measure Group 'RFC_EffortAnalysis_Details' completed successfully.
Start time: 7/11/2007 2:38:23 PM; End time: 7/11/2007 2:38:23 PM; Duration: 0:00:00
Processing Partition 'RFC_EffortAnalysis_Details' completed successfully.
Start time: 7/11/2007 2:38:23 PM; End time: 7/11/2007 2:38:23 PM; Duration: 0:00:00
Processing Dimension 'RFC_EffortAnalysis_Details' failed.
Start time: 7/11/2007 2:38:23 PM; End time: 7/11/2007 2:38:25 PM; Duration: 0:00:02
Processing Dimension Attribute '(All)' completed successfully.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
Processing Dimension Attribute 'Manager' completed successfully. 18 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Manager] AS [dbo_vwRFC_EffortAnalysis_DetailsManager0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Primary Change Category' completed successfully. 6 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Primary Change Category] AS [dbo_vwRFC_EffortAnalysis_Details0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'RFC Group' completed successfully. 10 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[RFC Group] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_x0020_Group0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'RFC Short Name' completed successfully. 316 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[RFC Short Name] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_x0020_Short_x0020_Name0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Role' completed successfully. 6 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Role] AS [dbo_vwRFC_EffortAnalysis_DetailsRole0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Sub Role' completed successfully. 12 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[SubRole] AS [dbo_vwRFC_EffortAnalysis_DetailsSubRole0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Status' completed successfully. 10 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Status] AS [dbo_vwRFC_EffortAnalysis_DetailsStatus0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'SVP Approver' completed successfully. 11814 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT [dbo_vwRFC_EffortAnalysis_Details].[Employee] AS [dbo_vwRFC_EffortAnalysis_DetailsEmployee0_0],[dbo_vwRFC_EffortAnalysis_Details].[RFC_No] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_No0_1],[dbo_vwRFC_EffortAnalysis_Details].[WeekOfDate] AS [dbo_vwRFC_EffortAnalysis_DetailsWeekOfDate0_2],[dbo_vwRFC_EffortAnalysis_Details].[SVP Approver] AS [dbo_vwRFC_EffortAnalysis_DetailsSVP_x0020_Approver0_3]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'SVP OK' completed successfully. 4 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[SVP OK?] AS [dbo_vwRFC_EffortAnalysis_DetailsSVP_x0020_OK_x003F_0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Est Hours' completed successfully. 274 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Est_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsEst_Hours0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Act Hours' completed successfully. 182 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Act_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsAct_Hours0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Rem Hours' completed successfully. 168 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Rem_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsRem_Hours0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Pred Hours' completed successfully. 61 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Pred_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsPred_Hours0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'ID' completed successfully. 316 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[ID] AS [dbo_vwRFC_EffortAnalysis_DetailsID0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Title' completed successfully. 316 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Title] AS [dbo_vwRFC_EffortAnalysis_DetailsTitle0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'IT Lead' completed successfully. 36 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[IT Lead] AS [dbo_vwRFC_EffortAnalysis_DetailsIT_x0020_Lead0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Parking Lot' completed successfully. 4 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Parking Lot] AS [dbo_vwRFC_EffortAnalysis_DetailsParking_x0020_Lot0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Total Scorecard Score' completed successfully. 227 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Total Scorecard Score] AS [dbo_vwRFC_EffortAnalysis_Details0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Process Excellence Project' completed successfully. 4 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Process Excellence Project] AS [dbo_vwRFC_EffortAnalysis_Details0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Requestor' completed successfully. 117 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Requestor] AS [dbo_vwRFC_EffortAnalysis_DetailsRequestor0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Scorecard Override' completed successfully. 6 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Scorecard Override] AS [dbo_vwRFC_EffortAnalysis_DetailsScorecard_x0020_Override0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Employee' completed successfully. 80 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Employee] AS [dbo_vwRFC_EffortAnalysis_DetailsEmployee0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'RFC No' completed successfully. 316 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[RFC_No] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_No0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Week Of Date' completed successfully. 187 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[WeekOfDate] AS [dbo_vwRFC_EffortAnalysis_DetailsWeekOfDate0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Vw RFC Effort Analysis Details' failed. 1 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:25 PM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Employee] AS [dbo_vwRFC_EffortAnalysis_DetailsEmployee0_0],[dbo_vwRFC_EffortAnalysis_Details].[RFC_No] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_No0_1],[dbo_vwRFC_EffortAnalysis_Details].[WeekOfDate] AS [dbo_vwRFC_EffortAnalysis_DetailsWeekOfDate0_2],[dbo_vwRFC_EffortAnalysis_Details].[Manager] AS [dbo_vwRFC_EffortAnalysis_DetailsManager0_3],[dbo_vwRFC_EffortAnalysis_Details].[Primary Change Category] AS [dbo_vwRFC_EffortAnalysis_Details0_4],[dbo_vwRFC_EffortAnalysis_Details].[RFC Group] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_x0020_Group0_5],[dbo_vwRFC_EffortAnalysis_Details].[RFC Short Name] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_x0020_Short_x0020_Name0_6],[dbo_vwRFC_EffortAnalysis_Details].[Role] AS [dbo_vwRFC_EffortAnalysis_DetailsRole0_7],[dbo_vwRFC_EffortAnalysis_Details].[SubRole] AS [dbo_vwRFC_EffortAnalysis_DetailsSubRole0_8],[dbo_vwRFC_EffortAnalysis_Details].[Status] AS [dbo_vwRFC_EffortAnalysis_DetailsStatus0_9],[dbo_vwRFC_EffortAnalysis_Details].[SVP OK?] AS [dbo_vwRFC_EffortAnalysis_DetailsSVP_x0020_OK_x003F_0_10],[dbo_vwRFC_EffortAnalysis_Details].[Est_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsEst_Hours0_11],[dbo_vwRFC_EffortAnalysis_Details].[Act_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsAct_Hours0_12],[dbo_vwRFC_EffortAnalysis_Details].[Rem_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsRem_Hours0_13],[dbo_vwRFC_EffortAnalysis_Details].[Pred_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsPred_Hours0_14],[dbo_vwRFC_EffortAnalysis_Details].[ID] AS [dbo_vwRFC_EffortAnalysis_DetailsID0_15],[dbo_vwRFC_EffortAnalysis_Details].[Title] AS [dbo_vwRFC_EffortAnalysis_DetailsTitle0_16],[dbo_vwRFC_EffortAnalysis_Details].[IT Lead] AS [dbo_vwRFC_EffortAnalysis_DetailsIT_x0020_Lead0_17],[dbo_vwRFC_EffortAnalysis_Details].[Parking Lot] AS [dbo_vwRFC_EffortAnalysis_DetailsParking_x0020_Lot0_18],[dbo_vwRFC_EffortAnalysis_Details].[Total Scorecard Score] AS [dbo_vwRFC_EffortAnalysis_Details0_19],[dbo_vwRFC_EffortAnalysis_Details].[Process Excellence Project] AS [dbo_vwRFC_EffortAnalysis_Details0_20],[dbo_vwRFC_EffortAnalysis_Details].[Requestor] AS [dbo_vwRFC_EffortAnalysis_DetailsRequestor0_21],[dbo_vwRFC_EffortAnalysis_Details].[Scorecard Override] AS [dbo_vwRFC_EffortAnalysis_DetailsScorecard_x0020_Override0_22]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Error Messages 2
Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_vwRFC_EffortAnalysis_Details, Column: Est_Hours, Value: 0. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Vw RFC Effort Analysis Details of Dimension: RFC_EffortAnalysis_Details from Database: ProjectManagement, Record: 6093.
Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_vwRFC_EffortAnalysis_Details, Column: Est_Hours, Value: 0. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Vw RFC Effort Analysis Details of Dimension: RFC_EffortAnalysis_Details from Database: ProjectManagement, Record: 6093. Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. Errors in the OLAP storage engine: An error occurred while the 'Vw RFC Effort Analysis Details' attribute of the 'RFC_EffortAnalysis_Details' dimension from the 'ProjectManagement' database was being processed.
Errors and Warnings from Response
Internal error: The operation terminated unsuccessfully.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
Errors in the OLAP storage engine: An error occurred while the 'Vw RFC Effort Analysis Details' attribute of the 'RFC_EffortAnalysis_Details' dimension from the 'ProjectManagement' database was being processed.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_vwRFC_EffortAnalysis_Details, Column: Est_Hours, Value: 0.
Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Vw RFC Effort Analysis Details of Dimension: RFC_EffortAnalysis_Details from Database: ProjectManagement, Record: 6093.

(2)

Hello! First question: Do you have referential integrity between the dimension tables and the fact table?

In other words do you have defined relations(foreign keys) between the dimension tables and the fact table?

Next question. Have you processed all dimensions before the cube(s)? Always process dimensions before the cubes in AS2000 and SSAS2005.

HTH

Thomas Ivarsson

|||

This was originally an AS 2000 cube .... I used Management Studio and VS2005 to migrate to an AS 2005 cube.

Therefore I needed to add a fact dimension in orer to enable drillthrough.

I am not even trying to process the cube.

I am trying to process the fact dimension (i.e the dimension is based on the same table/view the cube is based on)

No. There are no foreign keys or referential integrity checks.

I am not even trying to process a cube....thats the weird part.

|||

dear friend,

Tell us how you defined your dimensions. Relation with factTables, and hierarchies inside dimension.

Regards!

|||

Do you have a project in BI-Dev Studio for your migrated cube(s)?

If so, in the data connection for the project in BI-Dev Studio check the impersonation mode and set it to default if this is not the case.

If not you can import an deployed SSAS2005 cube in BI-Dev studio if you choose the import project.

HTH

Thomas Ivarsson

Monday, March 26, 2012

Error opening VSA from Script component and Script Task

TITLE: Microsoft Visual Studio

Cannot show Visual Studio for Applications editor.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.DataFlowUI.SR&EvtID=CouldNotShowVsaIDE&LinkId=20476

ADDITIONAL INFORMATION:

Engine returned Unknown Error (Microsoft.VisualBasic.Vsa)

A project with the name 'ScriptComponent_972bfcb1f5ae462081f39130ba1d36b2' already exists.

BUTTONS:

This happened immediately AFTER installing Visual Studio 2005. SQL Serve Workstation tools were already installed. I am running Windows XP SP2.

Anyway have any words of wisdon as to what the problem may be or how to investigate fix it?

Thanks

Jamie

Ignore this. Rebooting has solved it!!!

-Jamie

|||

Jamie,

I've got similar message which is persistent. I cannot open any script task anymore

Error message "Cannot show the editor for this task. Specified cast is not valid (Microsoft.VisualBasic.Vsa.DT)" pops up.

I even retried re-installing VS 2005. Did not resolved the issue.

Any idea?

Gulden

|||

Try to upgrade your machine with the cumulative hotfix package (build 2153) for SQL Server 2005.

Regards,
Yitzhak

|||

Yitzak,

Thank you for your answer.

I am getting "This machine does not have a product that matches this installation package"

on the first one in x86 group.

Do you have any idea?

This is my only chance.

I've re-installed SQL Server 2005 and Visual Studio 2005. Still cannot open the scripts.

Gulden

|||

Even betterjust exit out of VS2005 and go back in. That solved it for me.

Jeff

|||

In my case they had pushed DLLs in 600 people's banded machines in my company including vbscript.dll etc. by mistake. They resolved it by re-registering them

Gulden

|||

You need to install SP1 for MS SQL Server 2005 as a prerequisite before you will be able to upgrade your machine with the cumulative hotfix package (build 2153) for SQL Server 2005. SO it is a 2 steps process.

Regards,
Yitzhak

Error opening VSA from Script component and Script Task

TITLE: Microsoft Visual Studio

Cannot show Visual Studio for Applications editor.

ADDITIONAL INFORMATION:

Engine returned Unknown Error (Microsoft.VisualBasic.Vsa)

A project with the name 'ScriptComponent_972bfcb1f5ae462081f39130ba1d36b2' already exists.

BUTTONS:

This happened immediately AFTER installing Visual Studio 2005. SQL Serve Workstation tools were already installed. I am running Windows XP SP2.

Anyway have any words of wisdon as to what the problem may be or how to investigate fix it?

Thanks

Jamie

Ignore this. Rebooting has solved it!!!

-Jamie

|||

Jamie,

I've got similar message which is persistent. I cannot open any script task anymore

Error message "Cannot show the editor for this task. Specified cast is not valid (Microsoft.VisualBasic.Vsa.DT)" pops up.

I even retried re-installing VS 2005. Did not resolved the issue.

Any idea?

Gulden

|||

Try to upgrade your machine with the cumulative hotfix package (build 2153) for SQL Server 2005.

Regards,
Yitzhak

|||

Yitzak,

Thank you for your answer.

I am getting "This machine does not have a product that matches this installation package"

on the first one in x86 group.

Do you have any idea?

This is my only chance.

I've re-installed SQL Server 2005 and Visual Studio 2005. Still cannot open the scripts.

Gulden

|||

Even betterjust exit out of VS2005 and go back in. That solved it for me.

Jeff

|||

In my case they had pushed DLLs in 600 people's banded machines in my company including vbscript.dll etc. by mistake. They resolved it by re-registering them

Gulden

|||

Regards,
Yitzhak

Error opening VSA from Script component and Script Task

TITLE: Microsoft Visual Studio

Cannot show Visual Studio for Applications editor.

ADDITIONAL INFORMATION:

Engine returned Unknown Error (Microsoft.VisualBasic.Vsa)

A project with the name 'ScriptComponent_972bfcb1f5ae462081f39130ba1d36b2' already exists.

BUTTONS:

This happened immediately AFTER installing Visual Studio 2005. SQL Serve Workstation tools were already installed. I am running Windows XP SP2.

Anyway have any words of wisdon as to what the problem may be or how to investigate fix it?

Thanks

Jamie

Ignore this. Rebooting has solved it!!!

-Jamie

|||

Jamie,

I've got similar message which is persistent. I cannot open any script task anymore

Error message "Cannot show the editor for this task. Specified cast is not valid (Microsoft.VisualBasic.Vsa.DT)" pops up.

I even retried re-installing VS 2005. Did not resolved the issue.

Any idea?

Gulden

|||

Try to upgrade your machine with the cumulative hotfix package (build 2153) for SQL Server 2005.

Regards,
Yitzhak

|||

Yitzak,

Thank you for your answer.

I am getting "This machine does not have a product that matches this installation package"

on the first one in x86 group.

Do you have any idea?

This is my only chance.

I've re-installed SQL Server 2005 and Visual Studio 2005. Still cannot open the scripts.

Gulden

|||

Even betterjust exit out of VS2005 and go back in. That solved it for me.

Jeff

|||

In my case they had pushed DLLs in 600 people's banded machines in my company including vbscript.dll etc. by mistake. They resolved it by re-registering them

Gulden

|||

Regards,
Yitzhak

Error opening Management Studio (Express)

Hello all,

I'm having an error opening the SSMS Express on a machine. This is a new install on this machine, so i've never had this running. However, i've install SSMSE many times and this is the first error that I've come across. I have the minimum requirements on the machine (Framework, XML, Windows Installer)

The error is:

Header: "Microsoft .Net Framework"
"Unhandled exception has occured in a component in your application. If you click Continue, the application will igonore this error and attempt to continue.

Attempted to read or write protected memory. This is often an indication that the other memory is corrupt"

(Details at end of post)

Now what this machine is running is:

OS: SBS 2003 SP1

Memory: 1.5 GB (over 1 GB is free)

Hard Disk: 7 GB of free space

Windows Updates are done up to just before SP2

SQL Server Express (SP2) is installed on this machine.

SSMSE Version: 3042

What I've done trying to resolve this issue:
1) reboot the machine
2) apply remaining windows updates (save for W2K3 SP2)
3) Re-install of SSMSE
4) Re-download of SSMSE install package and an uninstall & reinstall
5) Repair of .Net Framework 2.0
6) Repair of SQL Native Client

I'm not sure what to attempt next, if anyone can give me any insite at all, that would be great. All I did was install the requirements, install SQL Server Express SP2, then install SSMSE. This has worked in the past for me.

Any and all help greatly appreciated!!

Thanks,

Ryan

Note: here is the stack track that the application generates:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
at System.Drawing.SafeNativeMethods.Gdip.GdipGetLogFontW(HandleRef font, HandleRef graphics, Object lf)
at System.Drawing.Font.ToLogFont(Object logFont, Graphics graphics)
at System.Drawing.Font.ToLogFont(Object logFont)
at System.Drawing.Font.ToHfont()
at System.Windows.Forms.Control.FontHandleWrapper..ctor(Font font)
at System.Windows.Forms.Control.get_FontHandle()
at System.Windows.Forms.Control.SetWindowFont()
at System.Windows.Forms.Control.OnHandleCreated(EventArgs e)
at System.Windows.Forms.TreeView.OnHandleCreated(EventArgs e)
at System.Windows.Forms.Control.WmCreate(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.TreeView.WndProc(Message& m)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LazyTreeView.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
-
Microsoft.SqlServer.Express.AppIDPackage
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.AppIDPackage.DLL
-
Microsoft.SqlServer.Express.VSIntegration
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.VSIntegration.DLL
-
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
Microsoft.VisualStudio.Shell.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
-
Microsoft.VisualStudio.OLE.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
-
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
-
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
-
Microsoft.SqlServer.Express.SqlWorkbench.Interfaces
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlWorkbench.Interfaces.DLL
-
Microsoft.SqlServer.Express.SqlTDiagM
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlTDiagM.DLL
-
Microsoft.DataWarehouse.SQM
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
-
Microsoft.SqlServer.Instapi
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
-
Microsoft.SqlServer.Express.ObjectExplorer
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.ObjectExplorer.DLL
-
Microsoft.SqlServer.Express.SqlMgmt
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.SqlMgmt.DLL
-
Microsoft.SqlServer.Express.ConnectionDlg
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.ConnectionDlg.DLL
-
Microsoft.VisualStudio
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 built by: RTM
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.dll
-
Microsoft.VisualStudio.Shell
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll
-
Microsoft.VisualStudio.Shell.Interop.8.0
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop.8.0/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.8.0.dll
-
System.Drawing.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing.Design/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.dll
-
Microsoft.VisualStudio.Designer.Interfaces
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Designer.Interfaces/1.0.5000.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Designer.Interfaces.dll
-
Microsoft.SqlServer.Express.RegSvrEnum
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.RegSvrEnum.DLL
-
Microsoft.SqlServer.Express.CustomControls
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.CustomControls.DLL
-
Microsoft.SqlServer.Express.Smo
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.Smo.DLL
-
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
-

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

**********************************************************************************************

To me that looks like a problem with the .NET framework. Try doing a full reinstall of the framework.

You might want to ask in one of the .NET forums and see if they can shead any light.

|||

That's what I thought too, so I ended up uninstalling the framework, rebooting, and reinstalling. No issues on the reinstall.

Still the error exists. However, I have found that I get errors in the SQL Surface Area Configuration Wizard as well. I'm assuming this runs off the ".NET Framework" as well. I've read some issues with this happening with some .NET controls, but I'm assuming that these are working fine as this seems to be the only machine with these issues. What concerns me is that if SQL Server uses any of hte .NET framework (besides the CLR) then I'm not sure if I want to continue on this machine.

Any ideas on what do look for?

|||

Ok, i'm convinced that this is an issue with .NET framework on this machine. It seems to be related to the System.Drawing DLL. I can get into the program but, it'll throw another error if I right click, however, this error comes from System.Drawing.Font

I'm going to move this thread to under a .NET Thread.

Thanks,

|||

Moved to:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1679733&SiteID=1&mode=1

|||

Ryan Slimmon wrote:

Moved to:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1679733&SiteID=1&mode=1

Any update on this issue - I am getting same message when trying to import SQL 2000 Server registration details

Error opening Management Studio (Express)

Hello all,

Attempted to read or write protected memory. This is often an indication that the other memory is corrupt"

(Details at end of post)

Now what this machine is running is:

OS: SBS 2003 SP1

Memory: 1.5 GB (over 1 GB is free)

Hard Disk: 7 GB of free space

Windows Updates are done up to just before SP2

SQL Server Express (SP2) is installed on this machine.

SSMSE Version: 3042

Any and all help greatly appreciated!!

Thanks,

Ryan

Note: here is the stack track that the application generates:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

For example:

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

**********************************************************************************************

To me that looks like a problem with the .NET framework. Try doing a full reinstall of the framework.

You might want to ask in one of the .NET forums and see if they can shead any light.

|||

That's what I thought too, so I ended up uninstalling the framework, rebooting, and reinstalling. No issues on the reinstall.

Any ideas on what do look for?

|||

I'm going to move this thread to under a .NET Thread.

Thanks,

|||

Moved to:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1679733&SiteID=1&mode=1

|||

Ryan Slimmon wrote:

Moved to:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1679733&SiteID=1&mode=1

Any update on this issue - I am getting same message when trying to import SQL 2000 Server registration details

sql

Friday, March 23, 2012

error on report server

when I try to run the report from VS.NET (SQL Server 2005 Business
Intelligence Development Studio). I got the following message:
======================================================================= TITLE: Microsoft Report Designer
--
A connection could not be made to the report server
http://localhost/ReportServer2005.
--
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but
expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting
Services 9.00.1399.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String
configFileName)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String
configFileName, String location)
at
Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String
configFileName, String configLocation)
at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()
at Microsoft.ReportingServices.WebServer.Global.StartApp()
at
Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object
sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the
report server log files for more information. (rsServerConfigurationError)
</li><ul>
<li>Access to the path 'C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is
denied.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span
class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.ReportingServices.Designer)
--
BUTTONS:
OK
--
=======================================================================
This is the error message I got when I try to run
http:\\localhost\reportserver2005 in IE. I got same error message when I run
http:\\MachineName\reportserver2005.
======================================================================= Reporting Services Error
----
a.. The report server has encountered a configuration error. See the
report server log files for more information. (rsServerConfigurationError)
a.. Access to the path 'C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is
denied.
----
SQL Server Reporting Services
=======================================================================
Please help!
Thank you very much
Darren L.Can you access http://localhost/Reports ? This is the default setting.
It looks like some setting problem. What does the log file say?|||Hi,
I ran http://localhost/Reports2005, I got following error:
The report server is not responding. Verify that the report server is
running and can be accessed from this computer.
I am thinking the problem maybe the setup (installation). I have SQL
Server 2000 Reports Service on my machine. When I installed the SQL Server
2005 Report Service. It simply tells me that report service has been
installed. So I created a new instance Reports2005 and ReportServer2005. Is
this the reason why it is not working? And what should I do to fix it?
Thanks
Darren
"Nick" <nick_1394@.yahoo.com.cn> wrote in message
news:1137696210.625104.289820@.g49g2000cwa.googlegroups.com...
> Can you access http://localhost/Reports ? This is the default setting.
> It looks like some setting problem. What does the log file say?
>|||Not sure if I am in the right log:
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
WindowsServiceUseFileShareStorage to 'False' as specified in Configuration
file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!configmanager!4!1/19/2006-10:02:52:: w WARN:
WebServiceAccount is not specified in the config file. Using default:
DL-DELL700M\ASPNET
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
DailyCleanupMinuteOfDay to default value of '120' minutes since midnight
because it was not specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
WatsonDumpOnExceptions to
'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
WatsonDumpExcludeIfContainsExceptions to
'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/19/2006-10:02:52:: i INFO: Initializing
WebServiceUseFileShareStorage to 'False' as specified in Configuration
file.
ReportingServicesService!servicecontroller!9!1/19/2006-10:02:57:: Total
Physical memory: 1055309824
ReportingServicesService!servicecontroller!4!1/19/2006-10:02:58:: i INFO:
RPC Server started. Endpoint name ='ReportingServices$MSSQL.3'
ReportingServicesService!library!3!1/19/2006-10:21:54:: i INFO: Catalog SQL
Server Edition = Developer
ReportingServicesService!resourceutilities!3!1/19/2006-10:21:54:: i INFO:
Reporting Services starting SKU: Standard
ReportingServicesService!resourceutilities!3!1/19/2006-10:21:54:: i INFO:
Evaluation copy: 0 days left
ReportingServicesService!library!3!1/19/2006-10:21:54:: e ERROR: restricted
SKUs: Workgroup Express Developer Evaluation - actual SKU Developer
ReportingServicesService!library!3!1/19/2006-10:21:54:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException:
The feature: "Using other editions of SQL Server for report data sources
and/or the report server database" is not supported in this edition of
Reporting Services., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException:
The feature: "Using other editions of SQL Server for report data sources
and/or the report server database" is not supported in this edition of
Reporting Services.
ReportingServicesService!library!a!1/19/2006-10:21:54:: i INFO: Catalog SQL
Server Edition = Developer
ReportingServicesService!library!a!1/19/2006-10:21:54:: e ERROR: restricted
SKUs: Workgroup Express Developer Evaluation - actual SKU Developer
ReportingServicesService!library!a!1/19/2006-10:21:54:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException:
The feature: "Using other editions of SQL Server for report data sources
and/or the report server database" is not supported in this edition of
Reporting Services., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException:
The feature: "Using other editions of SQL Server for report data sources
and/or the report server database" is not supported in this edition of
Reporting Services.
ReportingServicesService!library!3!1/19/2006-10:21:55:: i INFO: Catalog SQL
Server Edition = Developer
ReportingServicesService!library!3!1/19/2006-10:21:55:: e ERROR: restricted
SKUs: Workgroup Express Developer Evaluation - actual SKU Developer
ReportingServicesService!library!3!1/19/2006-10:21:55:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException:
The feature: "Using other editions of SQL Server for report data sources
and/or the report server database" is not supported in this edition of
Reporting Services., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException:
The feature: "Using other editions of SQL Server for report data sources
and/or the report server database" is not supported in this edition of
Reporting Services.
There are few error statements at the buttom. But...
Thanks
Darren L.
"Nick" <nick_1394@.yahoo.com.cn> wrote in message
news:1137696210.625104.289820@.g49g2000cwa.googlegroups.com...
> Can you access http://localhost/Reports ? This is the default setting.
> It looks like some setting problem. What does the log file say?
>

Monday, March 19, 2012

Error on DROP TABLE

Hi,

I was trying to drop a table (or alter it in any way) and the Managment Studio Express gave me an error of timeout. So I say something like DROP TABLE myTable, and it takes a while and gives me the error. Does anybody know how to unlock a table?

Thanks

Hi Alessandro,

As this is Express, I'm guessing that a stopping and restarting the SQL Server service sin't going to impact usage? If not, do this and re-issue your drop command, you'll probably that an application is placing a lock on the table in question and blocking the ddl command.

There are other ways to identify the offending session (spid), but this is probably easiest in your case.

Cheers,

Rob

|||

post back the actual error u gets...

Madhu

|||

Possible to post the error message to further explore your problem?

At the mean time:

1. Check whether the table really exists in the correct database. Do the folowing:

Select Name from Sys.Objects where name='tablename' -- (if exist)

Drop table databasename.schema.tablename

2. Check that the Login that you are using to execute this query has the approriate permission. You can do so by verify the user properties in the security node.

3. Check whether the table has any reference to other tables

4. Verify whether the table is locked using the current activity. If necessary, you can end the lock by killing the session.

ERROR on atach MDF file!

Code Snippet

TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server 'MS-DB'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Could not redo log record (805:390:13), for transaction ID (0:55765), on page (1:1061), database 'aws' (database ID 5). Page: LSN = (804:451:25), type = 2. Log: OpCode = 2, context 3, PrevPageLSN: (805:150:13). Restore from a backup of the database, or repair the database.
During redoing of a logged operation in database 'aws', an error occurred at log record ID (805:390:13). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.
Could not open new database 'aws'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 3456)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=3456&LinkId=20476

BUTTONS:

HELP ME!!

try to attach only the mdf file of your database.

run a command like this :

create database yourdb on (name =yourdb, filename='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\yourmdffile.mdf') for attach

If it doesn't work do what your message say

|||

Don't work...

The message....

Code Snippet

Msg 1813, Level 16, State 2, Line 1

Could not open new database 'aws'. CREATE DATABASE is aborted.

Msg 3456, Level 21, State 1, Line 1

Msg 3313, Level 21, State 2, Line 1

During redoing of a logged operation in database 'aws', an error occurred at log record ID (805:390:13). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.

|||

A last try :

when i said to attach only the mdf file i thaught to following thing:

don't use the log file when making the operation of attaching (put only de mdf file in the folder); so , SQL should recreate the log file.

|||

Ok,

I try this...

and

Code Snippet

File activation failure. The physical file name "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\aws_log.ldf" may be incorrect.

The log cannot be rebuilt because the database was not cleanly shut down.

Msg 1813, Level 16, State 2, Line 1

Could not open new database 'aws'. CREATE DATABASE is aborted.

|||

If you have not a backup try to recover with third party. It say :

"Selective recovery means repairing only those transactions and objects that are damaged" Maybe they can help you.

To the other part you have to review the procedures of using servers in your organization (using UPS etc) because "the database was not cleanly shutdown"

|||

As your db was not cleanly shut down you can perform as below

(a) Create a database with the same name in another directory as the one you're trying to attach
(b) Re-create all filesgroups and files as necessary
(c) Shutdown the server
(d) Swap in the old mdf file and any ndf files
(e) Bring up the server and let the database attempt to be recovered and then go into suspect
(f) Put the database in single-user mode.
(g) Run DBCC CHECKDB (dbname, REPAIR_ALLOW_DATA_LOSS) which will rebuild the log and run full repair
(h) Return database to online, multi-user mode.

|||

As your db was not cleanly shut down you can perform as below

ok(a) Create a database with the same name in another directory as the one you're trying to attach
ok(b) Re-create all filesgroups and files as necessary
ok(c) Shutdown the server
ok(d) Swap in the old mdf file and any ndf files
ok(e) Bring up the server and let the database attempt to be recovered and then go into suspect
(f) Put the database in single-user mode.

Well

I cant put the database in single-user mode, i receive this message whend i did this commands...

Commands:

Use aws

sp_dboption 'aws', 'dbo use only', false

sp_dboption 'aws','single_user', true

dbcc checkdb ('aws',repair_allow_data_loss)

aws is my DB

Message:

Msg 926, Level 14, State 1, Line 1
Database 'aws' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
Msg 926, Level 14, State 1, Line 1
Database 'aws' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
sp_dboption command failed.
Msg 3456, Level 21, State 1, Line 1
Could not redo log record (805:390:13), for transaction ID (0:55765), on page (1:1061), database 'aws' (database ID 5). Page: LSN = (804:451:25), type = 2. Log: OpCode = 2, context 3, PrevPageLSN: (805:150:13). Restore from a backup of the database, or repair the database.
Msg 3313, Level 21, State 2, Line 1
During redoing of a logged operation in database 'aws', an error occurred at log record ID (805:390:13). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.
Msg 3414, Level 21, State 1, Line 1
An error occurred during recovery, preventing the database 'aws' (database ID 5) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.

===================

Then i put the server in Single User mode and execute the command below: ( -m -c )

DBCC CHECKDB (aws, REPAIR_ALLOW_DATA_LOSS)

and receive this message:

Msg 926, Level 14, State 1, Line 1
Database 'aws' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.

======

Well

The DB was atach again, but i cant recovery the data =(

Thursday, March 29, 2012

Error renaming analysis services project

Tuesday, March 27, 2012

Error read data from Sybase with SSIS 2005

Error read data from Sybase with SSIS 2005

Error Processing a dimension

Monday, March 26, 2012

Error opening VSA from Script component and Script Task

Error opening VSA from Script component and Script Task

Error opening VSA from Script component and Script Task

Error opening Management Studio (Express)

Error opening Management Studio (Express)

Friday, March 23, 2012

error on report server

Monday, March 19, 2012

Error on DROP TABLE

ERROR on atach MDF file!

Sql Error message

Blog Archive

About Me