Error description

I want to club the ErrorDescription system variable property in OnError.

And I want to send this whole ErrorDescription variable on onTaskFailed.

Can you please suggest how to club this errordescription on OnError event

In the data flow, you can use a script component to grab the description:

Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Public Class ScriptMain
Inherits UserComponent

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
'Use the incoming error number as a parameter to GetErrorDescription
Row.ErrorDescription = ComponentMetaData.GetErrorDescription(Row.ErrorCode)
End Sub

End Class|||

What do you mean by club?

The above the script will return your error description.

|||

Leo,

It would be better to insert the error descriptions into a custom table on Onerror event with System::ExecutionInstanceGUID to assosiate/identify with the package run instance. Or enable logging for the package with SQL server provider for Onerror. Then you can query the custom table or dbo.sysdtslog90 table using System::ExecutionInstanceGUID to fetch the errors for email notification, etc.

Above suggestion assumes you are using SQL Server.

good luck.

|||

hellomahesh wrote:

Leo,

It would be better to insert the error descriptions into a custom table on Onerror event with System::ExecutionInstanceGUID to assosiate/identify with the package run instance. Or enable logging for the package with SQL server provider for Onerror. Then you can query the custom table or dbo.sysdtslog90 table using System::ExecutionInstanceGUID to fetch the errors for email notification, etc.

Above suggestion assumes you are using SQL Server.

good luck.

This sounds good, except, how do you propose he gets the errorDescription? This isn't the same as the error message.|||

but onerorr event doesn't insert one row for single error for ex"no row yeilded during lookup. It inserts multiple (atleast 6-10).

thete are some unnecessary rows as well like "

thread "WorkThread0" has exited with error code 0xC0047039

But I want to send only related error message as an email that too on OnTaskFailed.

suggestions..?

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.

Error creating DSN

Hi
I'm trying to set up a DSN and get a 18456 error
Here is what I do
start->programs->administrative tools->data sources (ODBC).
On system DSN sheet I press add
A window opens and I choose SQL Server
Another window opens (create a new data source to sql server)
Field name = XML description = XML, server = local ( I have 2 options local
and moshik).
I press next and the window changes here I choose "with sql server
quthentication using a login ID and password entered by the user"
Bellow I enter loginid = moshik, password=XXX
I press next and get the follwoing error message
"connection failed;
sql state: '28000'
sql server error : 18456
[microsoft][odbc sql server driver][sql server]login failed for user
'moshik'."
I loged into the computer using moshik's user and opened enterprize manager
and manipulated the data on the database so user moshik has rights to the
database.
I have a Win 2000 server sp 4 and sql server 2000. The win 2000 server is
stand alone and not connected to a network and not in a domain.
Any help will be appreciated
Moshik Amit
When you specify the local server, did you use:
(local)
You may also want to type the name of the server yourself in
the server drop down. Specify the machine name instead of
using (local). You aren't limited to just what is displayed
in the drop down - you can type any server, machine name in
there as well.
-Sue
On Tue, 9 Aug 2005 09:30:05 -0700, "Moshik Amit"
<MoshikAmit@.discussions.microsoft.com> wrote:

>Hi
>I'm trying to set up a DSN and get a 18456 error
>Here is what I do
>start->programs->administrative tools->data sources (ODBC).
>On system DSN sheet I press add
>A window opens and I choose SQL Server
>Another window opens (create a new data source to sql server)
>Field name = XML description = XML, server = local ( I have 2 options local
>and moshik).
>I press next and the window changes here I choose "with sql server
>quthentication using a login ID and password entered by the user"
>Bellow I enter loginid = moshik, password=XXX
>I press next and get the follwoing error message
>"connection failed;
>sql state: '28000'
>sql server error : 18456
>[microsoft][odbc sql server driver][sql server]login failed for user
>'moshik'."
>I loged into the computer using moshik's user and opened enterprize manager
>and manipulated the data on the database so user moshik has rights to the
>database.
>I have a Win 2000 server sp 4 and sql server 2000. The win 2000 server is
>stand alone and not connected to a network and not in a domain.
>Any help will be appreciated
>Moshik Amit

Error creating DSN

Hi
I'm trying to set up a DSN and get a 18456 error
Here is what I do
start->programs->administrative tools->data sources (ODBC).
On system DSN sheet I press add
A window opens and I choose SQL Server
Another window opens (create a new data source to sql server)
Field name = XML description = XML, server = local ( I have 2 options local
and moshik).
I press next and the window changes here I choose "with sql server
quthentication using a login ID and password entered by the user"
Bellow I enter loginid = moshik, password=XXX
I press next and get the follwoing error message
"connection failed;
sql state: '28000'
sql server error : 18456
[microsoft][odbc sql server driver][sql server]login failed for
user
'moshik'."
I loged into the computer using moshik's user and opened enterprize manager
and manipulated the data on the database so user moshik has rights to the
database.
I have a Win 2000 server sp 4 and sql server 2000. The win 2000 server is
stand alone and not connected to a network and not in a domain.
Any help will be appreciated
Moshik AmitWhen you specify the local server, did you use:
(local)
You may also want to type the name of the server yourself in
the server drop down. Specify the machine name instead of
using (local). You aren't limited to just what is displayed
in the drop down - you can type any server, machine name in
there as well.
-Sue
On Tue, 9 Aug 2005 09:30:05 -0700, "Moshik Amit"
<MoshikAmit@.discussions.microsoft.com> wrote:

>Hi
>I'm trying to set up a DSN and get a 18456 error
>Here is what I do
>start->programs->administrative tools->data sources (ODBC).
>On system DSN sheet I press add
>A window opens and I choose SQL Server
>Another window opens (create a new data source to sql server)
>Field name = XML description = XML, server = local ( I have 2 options local
>and moshik).
>I press next and the window changes here I choose "with sql server
>quthentication using a login ID and password entered by the user"
>Bellow I enter loginid = moshik, password=XXX
>I press next and get the follwoing error message
>"connection failed;
>sql state: '28000'
>sql server error : 18456
>[microsoft][odbc sql server driver][sql server]login failed for
user
>'moshik'."
>I loged into the computer using moshik's user and opened enterprize manager
>and manipulated the data on the database so user moshik has rights to the
>database.
>I have a Win 2000 server sp 4 and sql server 2000. The win 2000 server is
>stand alone and not connected to a network and not in a domain.
>Any help will be appreciated
>Moshik Amit

Error connecting to SQL 2000 db "The entry MCLConnectionString has already been added"

When I try to run my application using VWD from the file system I can connect and run the application and it connects to the remote SQL 2000 server with no problem.

However, when I publish to my web server I get the folloiwng error message:

Anyone got any ideas??

Configuration Error

Description:An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message:The entry 'MCLConnectionString' has already been added.

Source Error:

Line 11: <appSettings/>Line 12: <connectionStrings>Line 13: <add name="MCLConnectionString" connectionString="Data Source=GEACO1INTR1;Initial Catalog=MCL;Persist Security Info=True;User ID=ASPNET;Password=PAUL0001" providerName="System.Data.SqlClient"/>Line 14: </connectionStrings>Line 15: <system.web>

Source File:c:\inetpub\wwwroot\mcltest\web.config Line:13

I also notice that it works if I put the connection string in each form, but as soon as I try to add it to the web.config file I get the above error.

Thanks

Paul

|||

My guess is that you have a ConnectionString with the same name on a Parent Web Application, my advise would be either to change the name of the ConnectionString, or do this:

<connectionString>
<clear/>
<add name="MCLConnectionString" connectionString="..." />
</connectionStrings
Hope this Helps,

Roberto Hernandez-Pou
http://www.rhpconsulting.net

IMPORTANT: If you use the <clear/> to clean all connectionString keys, you would also be removing the ones for the SqlAuthenticationProvider and SqlRoleProvider.

|||

To add onto Roberto's reply...

If the MCLConnectionString does already exist higher in the configuration hierarchy, you don't have to add it again to use at this level. Remove it at this level's web.config and read the connection string as normal, and the configuration API will pick it up.

Don

|||

Thanks, that sorted it. I had a copy of the web.config file left in the root directory of the web server.

Thanks again for your help

Paul

Error connecting to Report Manager

System.Net.WebException: Unable to connect to the remote server -->
System.Net.Sockets.SocketException: No connection could be made because the
target machine actively refused it 127.0.0.1:443
Can someone help me with that error?
ThanksThats a bit unusual. Try this post
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=552017&SiteID=1
Cheers
Shai
On Nov 19, 11:46 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
> System.Net.WebException: Unable to connect to the remote server -->
> System.Net.Sockets.SocketException: No connection could be made because the
> target machine actively refused it 127.0.0.1:443
> Can someone help me with that error?
> Thanks

Error connecting to remote server

Hi
I am trying to cerate a System DSN (in ODBC Data Source Administrator) for a
remote SQL Server. I am getting the below error message;
Connection failed:
SQL State: '01000'
SQL Server Error: 14
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid
Instance())
Connection failed:
SQL State: '08001'
SQL Server Error: 14
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid Connection
What is the problem and how can I fix it?
Thanks
RegardsOn Sep 14, 4:57 pm, "John" <J...@.nospam.infovis.co.uk> wrote:
> Hi
> I am trying to cerate a System DSN (in ODBC Data Source Administrator) for a
> remote SQL Server. I am getting the below error message;
> Connection failed:
> SQL State: '01000'
> SQL Server Error: 14
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid
> Instance())
> Connection failed:
> SQL State: '08001'
> SQL Server Error: 14
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid Connection
> What is the problem and how can I fix it?
> Thanks
> Regards
the remote server isn't running sql as a named instance is it?|||Not sure. It is our web hosts which is an outside company. What should I ask
them to do?
Many Thanks
Regards
"densial" <densial@.gmail.com> wrote in message
news:1189754261.882976.147900@.r34g2000hsd.googlegroups.com...
> On Sep 14, 4:57 pm, "John" <J...@.nospam.infovis.co.uk> wrote:
>> Hi
>> I am trying to cerate a System DSN (in ODBC Data Source Administrator)
>> for a
>> remote SQL Server. I am getting the below error message;
>> Connection failed:
>> SQL State: '01000'
>> SQL Server Error: 14
>> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid
>> Instance())
>> Connection failed:
>> SQL State: '08001'
>> SQL Server Error: 14
>> [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid Connection
>> What is the problem and how can I fix it?
>> Thanks
>> Regards
> the remote server isn't running sql as a named instance is it?
>|||We are trying to access the SQL Server from behind an ISA 2004 firewall.
Even though I have created a rule for port 1433 on ISA 2004, I wonder if
there is something still missing at the ISA 2004 that I need to do.
Many Thanks
Regards
"densial" <densial@.gmail.com> wrote in message
news:1189754261.882976.147900@.r34g2000hsd.googlegroups.com...
> On Sep 14, 4:57 pm, "John" <J...@.nospam.infovis.co.uk> wrote:
>> Hi
>> I am trying to cerate a System DSN (in ODBC Data Source Administrator)
>> for a
>> remote SQL Server. I am getting the below error message;
>> Connection failed:
>> SQL State: '01000'
>> SQL Server Error: 14
>> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid
>> Instance())
>> Connection failed:
>> SQL State: '08001'
>> SQL Server Error: 14
>> [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid Connection
>> What is the problem and how can I fix it?
>> Thanks
>> Regards
> the remote server isn't running sql as a named instance is it?
>|||On Sep 14, 8:49 pm, "John" <J...@.nospam.infovis.co.uk> wrote:
> We are trying to access the SQL Server from behind an ISA 2004 firewall.
> Even though I have created a rule for port 1433 on ISA 2004, I wonder if
> there is something still missing at the ISA 2004 that I need to do.
> Many Thanks
> Regards
> "densial" <dens...@.gmail.com> wrote in message
> news:1189754261.882976.147900@.r34g2000hsd.googlegroups.com...
> > On Sep 14, 4:57 pm, "John" <J...@.nospam.infovis.co.uk> wrote:
> >> Hi
> >> I am trying to cerate a System DSN (in ODBC Data Source Administrator)
> >> for a
> >> remote SQL Server. I am getting the below error message;
> >> Connection failed:
> >> SQL State: '01000'
> >> SQL Server Error: 14
> >> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid
> >> Instance())
> >> Connection failed:
> >> SQL State: '08001'
> >> SQL Server Error: 14
> >> [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid Connection
> >> What is the problem and how can I fix it?
> >> Thanks
> >> Regards
> > the remote server isn't running sql as a named instance is it?
that error msg <snip>Invalid Instance()</snip> makes me think your
providor is using a named instance, just ask them if they are, then
reference your server as "servername\instancename" (check the slash
direction, can't remember off hand if it's forward or backward).
Another issue could be the port number, try either "servername,1433"
or "servername\instancename,1433" as your server address. this is
often a problem if your using load balanced sql server. also there's
somestuff about the server knowing which port to reply on (for
sql2005), but this is a bit more complex and sometimes requires some
server side config in awkward situations, anyways if it's 2k5 your
connecting to read up about sqlbrowser replying to the client on port
1434 instead of 1433.

Error Code

Error messages:
Source: mscorlib
Target Site: Void WinIOError(Int32, System.String)
Message: Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ReplData\unc\Servername_ADVENTUREWORKS_ADVWORKSPRODUCTTRANS\20070625161637\' is denied.
Stack: at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.Directory.InternalCreateDirectory(String fullPath, String path, DirectorySecurity dirSecurity)
at System.IO.Directory.CreateDirectory(String path, DirectorySecurity directorySecurity)
at Microsoft.SqlServer.Replication.Utilities.CreateDirectoryWithExtendedErrorInformation(String directory)
at Microsoft.SqlServer.Replication.Snapshot.SnapshotProvider.CreateSnapshotFolders()
at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()
at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()
at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: mscorlib, Error number: 0)

I totally followed by tutorials of replication, repldata is new created folder

sharing for windowns accounts like shown below

repl_distribution read

repl_merge read

repl_snapshot Full control

the settting for these accounts same with security setting

any idea about this error?

many thanks

Can you confirm that xp_cmdshell is enabled? Also can you confirm that the account your snapshot agent is running under (either the windows impersonation account, of the SQL Server agent account on your publisher) has write, and list files and folders rights on the publisher?

Error at deployment time (SSAS 2005)

Hello all,

May be somebody know what does this error mean:

"Error 1 Exception of type 'System.OutOfMemoryException' was thrown. 0 0"

I get it during deployment of cube after small changes I made in cube role.

When I deleted the role to return project to prviouse condition which was working, I still get the same error.

If anybody has any idea - it would be very appreciated.

Thanks

Inna

Hard to say on what is going on. Not clear which component produced an error.

Try connecting to Analysis Server from SQL Profiler and see if you will get the same error from the server.

Can you try and make changes to the role from SQL Managment studio and see if you are getting the same error?

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

|||

Hello Inna

Could it be possible that Your workstation has not enough memory for the Business Intelligence Studio ? You could also have some trouble in he Control Panel/System/Performance. I recommend a contact with Your System Support.

regards

Matti

|||

Hi Edward,

Thank you for your answer.

From SQL Profiler I didn't see my deployment process - when task failed it doesn't reach server and doesn't apply any changes there.

I tried and made changes to the role from SQL Management studio as you advised and it worked without any errors.

At the same time project stood not up to date and I don't know how to export the changes I made directly on the server to VS to continue development:

I can open Analysis Database in V Studio and make changes directly on the server.

After all I reopened the project, deleted role at all and got the same error.

Every time after reboot - it let me to make and to deploy changes for only one time.

Do you have any idea what could be a problem?

Thanks a lot

Inna

|||

Hello Matti,

Thank you for your reply.

Unfortunately now I have to work directly on the server (Windows Server 2003 Standard x64 edition - 6 GB memory and 1 CPU). BI studio installed there. When I get this error during deployment time – memory doesn’t grow out of 2 GB. So I thought enough is still available.

May be I need to configure BI Studio the way it can raise the memory it needs? - I have no idea if it makes sense.

I didn't notice any degradation in performance on the server at the time I got memory error.

All additional ideas would be much appreciated.

Regards

Inna

|||

Hi Inna again

You seem to have lots of memory.

I have met same error and same behaviour ones with my own Java application in Windows Xp.

In that case I could make the correction by changing in the registry the limit for the space of memory the operating system allocates to that type of applications.

Sorry, but I am not an expert in Windows Server 2003. I expect that there somewhere is a limit for the size of memory the operating system allocates to one task.

This is only a quess, but I hope it would be helpfull.

regards

Matti