Issue time04:05:00 pm, by tom.green Email 20582 views
Categories: SSIS, Errors

Problem

When trying to open a BI project, the following error appears.

'\PATH_TO_PROJECT\PROJECT_NAME.dwproj' cannot be opened because its project type (.dwproj) is not supported by this version of the application. 
To open it, please use a version that supports this type of project.  

 

Solution

First, make sure that you have BIDS (SQL Server Business Intelligence Development Studio and Integration Services installed.

If you have them already installed and still get the error, it is possible that you try to open in SQL Server 2005 BIDS (for example) a project created (upgraded) in Microsoft SQL Server 2008, 2008 R2, 2012.

 

Full story »

Tags: .dtproj

Leave a comment
Issue time04:50:00 pm, by tom.green Email 9529 views
Categories: SSRS, Errors

Problem

When executing an SSRS report the following error appears:

An error has occurred during report processing. (rsProcessingAborted)

Cannot set the command text for dataset 'DATASET_NAME'. (rsErrorSettingCommandText)

Error during processing of the CommandText expression of dataset ?DATASET_NAME?. (rsQueryCommandTextProcessingError)

 

The report is using two parameters based on two different datasets.

The dataset of Parameter_1 is defined by the following query (this is just a simple example for better understanding):

=IIf(Parameters! Parameter_2.Value Is Nothing,"select 1","select 2")

 

 

Solution

Check if the query is not missing any quotes. If this doesn?t solve the problem take a look at the parameters order.

 

Full story »


Leave a comment
Issue time02:56:00 pm, by tom.green Email 10334 views
Categories: SSIS, Errors

Problem

When executing an SSIS package the following error appears:

A rowset based on the SQL command was not returned by the OLE DB provider.

Component "COMPONENT_NAME" failed the pre-execute phase and returned error code 0xC02092B4.

 

In my case, I received the error when running a SQL job that brings some data from several servers to another one during the night. The job executes a SSIS package that uses a data flow task.

In the data flow task, a stored procedure is executed and the results generated from the source servers are inserted into a table on the destination server.

 

Full story »


Leave a comment
Issue time06:32:00 pm, by tom.green Email 13251 views
Categories: SSAS, Errors

Problem

When trying to call DiscoverSessions function from the ASSP procedure the following error can appear.

CALL ASSP.DiscoverSessions()

Execution of the managed stored procedure DiscoverSessions failed with the following error: Exception has been thrown by the target of an invocation.The type initializer for 'Microsoft.AnalysisServices.Xmla.NamespacesMgr' threw an exception..

 

The error is received out of the blue, after many successful executions during several months.

 

Solution:

Delete the existing assembly and register the DLL again from Management Studio.

 

Full story »


Leave a comment
Issue time01:00:00 pm, by tom.green Email 17333 views
Categories: Errors, SQL Server

Problem

The following error appears when trying export data from SQL Server to a network share with BCP utility:

 

xp_cmdshell 'BCP "SELECT COLUMN_1, COLUMN_2, .. COLUMN_N FROM TABLE_NAME"
   QueryOut \\SERVER_NAME\SHARED_FOLDER\FILE_NAME.TXT -c /t \t /r \n /S SERVER_NAME /U user_name /P user_password'

 

SQLState = S1000, NativeError = 0

Error = [Microsoft][SQL Native Client]Unable to open BCP host data-file

 

Solution

Grand the user that writes to the network share the necessary rights. 

 

Full story »


Leave a comment
December 2017
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
          1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31            

Search

Email Subscription

Enter your email address:

Translate

Advertising











XML Feeds

DBA Blog

Latest posts

SSAS More...
SSRS More...
Server Configuration More...
SQL Server More...
SSIS More...
Server Configuration More...
Errors More...

Poll

Which database platform do you use?

View Results

Powered by b2evolution