Error: Email Subscription to Report (Sharepoint Integrated Mode) Options

I encounter this error when user try to subscribe using email delivery
to one of the report. I have configured the Reporting Services to use
Sharepoint integrated mode. This user is a regular user that has read
access to the report item.

Below is the message detail:

A subscription delivery error has occurred. (rsDeliveryError)
A subscription delivery error has occurred. (rsDeliveryError)
One of the extension parameters is not valid for the following reason:
The account you are using does not have administrator privileges. A
subscription cannot be created for [emailaddress].
(rsInvalidExtensionParameter)

Is it true that user needs to have administrator privilege in order to
subscribe for report? I don't think so, right?

Regards,
Gunady Ng

Hi Gunady,

Non-admin users can only send a report to an email address that is specified in the SharePoint user profile for that user. Can you check the "TO" field and ensure that the email address is that of the user as seen in the SharePoint user profile?

Thanks,

Sharmila

|||

Thank you for the answer. Is this restriction apply to cc or bcc as well?

Regards,

Gunady Ng

|||

Yes, it applies to all.

Thanks,
Sharmila

|||

is there a way around this?

Is there a way to setup on per-report basis?

I'm using reporting services within sharepoint as a content delivery solution, I need teh users to be able ost chedule reports and have them delivered by email to thair sharpoint drop box and/or to their customers staright from teh subscripton interface

I'm able to do this as admin but I need teh users to be able to do the same

I tried looking in the rsreportsever.config but can not figure out how to do this, I set <sendemailtouseralias>False but still nothing,

I also dont have the otion for CC: or BCC: when I'm loged in with nonadministrative account.

There must be an option for this but I'm not finding it in any documentation

I'm running Reporting Services SP2 in WSS3 integrated mode

Please advice and help...

Thanks

Nik

Error: duplicate key row

What might cause the following error when inserting rows in tables that have primary keys defined as IDENTITY (1,1)?

duplicate key row in object 'aa' with unique index 'aa'

I have seen this happen frequently when data has been bulk loaded sometime in the past into a table that has an IDENTITY key. This is especially common when you have a test environment in which some production data was bulk loaded to give some "good test data." To me it means that an identity number has "already been used" as a record key.

Dave

|||The rows are inserted one at a time using the parent IDENTITY key as a FK constraint in the child table which also has an IDENTITY KEY. However, this scenario does not sound like it would cause an error.|||

Can you post the table structures? That would help us to see what your problem might be.

If you can post a few statements that cause the duplicates, that would even be better.

|||

If you have the property NOT FOR REPLICATION enabled for the identity column.

Merging changes would allow the exact id values to be inserted rather than a new value that would give the error if same id value exists in the participating server.

similarly, if you are trying to insert manually using SET IDENTITY_INSERT table ON...

error: 'Dts' does not exist in the namespace 'Microsoft.Sqlserver'

I tried to create a package from a C# program, and I copied this from SQL server online book:

using Microsoft.Sqlserver.Dts.Runtime;

But I got compilation error:
The type or namespace name 'Dts' does not exist in the namespace 'Microsoft.Sqlserver'(are you missing an asssembly reference?)
What am I missing?

Thanks a lot

Have you, in fact, set a reference to Microsoft.SqlServer.ManagedDTS ? This is the assembly that contains the Dts.Runtime namespace.

-Doug
|||How do I set a reference to ManagedDTS? by writting:
using Microsoft.SqlServer.ManagedDTS
?

In this case ManagedDTS can not be found by compiler

Thanks for the hint
|||Please consult the Books Online for support. For example, the following article mentions what DLLs need to be registered:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9/html/e44bcc70-32d3-43e8-a84b-29aef819d5d3.htm
regards,
ash|||found the solution: from visual studio, click Project->Add reference, then browse the assembly ManagedDTS.dll at directory c:\program files\microsoft sql server\90\SDK\Assemblies, this willl add ManagedDTS.dll to the project and solve the problem.

Thanks everyone!|||

Hello,

if you get this problem on your server. build your site in release mode and then you have this dll in your bin\release folder.

Either find this DLL and upload that in your server bin directory manually

error: 'Dts' does not exist in the namespace 'Microsoft.Sqlserver'

I tried to create a package from a C# program, and I copied this from SQL server online book:

using Microsoft.Sqlserver.Dts.Runtime;

But I got compilation error:
The type or namespace name 'Dts' does not exist in the namespace 'Microsoft.Sqlserver'(are you missing an asssembly reference?)
What am I missing?

Thanks a lotHave you, in fact, set a reference to Microsoft.SqlServer.ManagedDTS ? This is the assembly that contains the Dts.Runtime namespace.

-Doug|||How do I set a reference to ManagedDTS? by writting:
using Microsoft.SqlServer.ManagedDTS
?

In this case ManagedDTS can not be found by compiler

Thanks for the hint|||Please consult the Books Online for support. For example, the following article mentions what DLLs need to be registered:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9/html/e44bcc70-32d3-43e8-a84b-29aef819d5d3.htm
regards,
ash|||found the solution: from visual studio, click Project->Add reference, then browse the assembly ManagedDTS.dll at directory c:\program files\microsoft sql server\90\SDK\Assemblies, this willl add ManagedDTS.dll to the project and solve the problem.

Thanks everyone!|||

Hello,

if you get this problem on your server. build your site in release mode and then you have this dll in your bin\release folder.

Either find this DLL and upload that in your server bin directory manually

Error: Decision Trees found no splits for model

Hi,

I am trying to run one of the mining models from the book "Delivering BI using SQl Server 2005" but I am running into "Decision Trees found no splits for model". The mining structure has 4 columns, the fourth one being marked as "Predict Only". My Cube slice for the model has sufficient data in the cube. I am lost.. Help!!

Regards

I'm not familiar with the DM section of that book. Could you give more descriptions of the data and the problem? What does the root node of the tree look like? Are you predicting a continuous or discrete value? Etc.

If you want to see the data the data mining is using, turn Drillthrough on for the model and then do

SELECT * FROM <model name>.CASES

To see the cases that were used for training the model. If this shows anything odd, you may see what's wrong.

|||

The mining model was created using Customer Dimension and Sales Fact. Following are the details of the mining model

Data Mining Technique: Microsoft Decision Trees
Dimension: Customer
Case Key: Customer.CustomerName
Attributes Used: Gender, Num Of Cars Owned, Num of Childer at home
Mining Model Column Usage: All the above columns except Num of Childeren at Home are Input and Num of Childeren at Home is defined as Predicatble only
Content and Data Type: All the above three columns are defined as discrete and text

Please note that I am new to DM stuff and I might have missed something obvoious. From what I see, when I try to explore the mining model viewer in BI studio, I see only 2 levels and histogram only shows two values, "Missing" and the "", the later having all the values. Ideally, it should have the customer in the root, then split to Gender and then to Num Of Cars Owned. "The num of children at home" should have come fromthe mining prediction.

Thanks for your reply.

|||

When you create the mining model, select the Allow Drillthrough option on the final page of the data mining wizard. When you view the model, right click on the root node and select "Drillthrough". This will show you the data that was used to train the model. It seems that the data that is being used for your model likely isn't the same as was in the book. I am unfamiliar with the book, but if you browse the data and see that maybe Num Children doesn't have the values you expect, it may show you why the model doesn't look like the book's.

You may try e-mailing the book's author as well.

HTH

sql

Error: Data source name not found and No default driver specified

Hello all,
I have an application which was written in VB6. I used
DSNless connection for the odbc connection to access sql 8.0. The
application works fine on one machine and when I try to run the appl.
on another machine I got this error. Any idea why' Here is my
connection string:
DSNName = "Driver={SQL Server};" & _
"Server=dummy;" & _
"Database=sql_data;" & _
"Uid=crystal"
The user id does not require a password.. Thank you.
SherryThis is a question for a VB group, not a SQL server group, but it sounds
like your DSNName is empty. Are you getting this value from an INI file,
the registry, or is it hardcoded in your app? You will most likely find
that this value is missing, wherever you define it.
Put in a message box that shows DSNName just prior to creating the
connection, and confirm that it is actually populated (I don't think it is).
<sunpalozzi@.gmail.com> wrote in message
news:1138811193.427214.282490@.g43g2000cwa.googlegroups.com...
> Hello all,
> I have an application which was written in VB6. I used
> DSNless connection for the odbc connection to access sql 8.0. The
> application works fine on one machine and when I try to run the appl.
> on another machine I got this error. Any idea why' Here is my
> connection string:
> DSNName = "Driver={SQL Server};" & _
> "Server=dummy;" & _
> "Database=sql_data;" & _
> "Uid=crystal"
> The user id does not require a password.. Thank you.
> Sherry
>|||Maybe the other machine doesn't have MDAC installed?
http://www.aspfaq.com/2057
Once you have the most recent version installed, an OLEDB connection string
will be better in most cases:
ConnectionString = _
"Provider=SQLOLEDB.1; " & _
"Data Source=dummy; " & _
"Initial Catalog=sql_data; " & _
"User ID=crystal; " & _
"Password="
<sunpalozzi@.gmail.com> wrote in message
news:1138811193.427214.282490@.g43g2000cwa.googlegroups.com...
> Hello all,
> I have an application which was written in VB6. I used
> DSNless connection for the odbc connection to access sql 8.0. The
> application works fine on one machine and when I try to run the appl.
> on another machine I got this error. Any idea why' Here is my
> connection string:
> DSNName = "Driver={SQL Server};" & _
> "Server=dummy;" & _
> "Database=sql_data;" & _
> "Uid=crystal"
> The user id does not require a password.. Thank you.
> Sherry
>|||thank you for all replies.. I did post in the vb group as well.. The
wire part is the same application is work on one pc but not the
another... I will try to find out if there a MDAC install on the
problem pc.. thanks.
Sherry

Error: Data Mining message

This may well be embarrasingly simple but....

I get this massage from Management Studion when I try to run any MDX

Error (Data mining): Either the user, LEONARD\Will Riley, does not have permission to access the referenced mining model, Contribution_Interest, or the object does not exist.

Is there something really simple I have missed?

Most likely you made syntax error in your MDX up tp a degree that it actually looks more like DMX than MDX, so AS tries to find mining model instead of cube. If you will paste your MDX statement, the forum should be able to help and fix it.|||

Yep, you got it

Once I plugged in what I knew to be some correctly structured MDX, the issue went away.

Cheers, Will