Error: Failed to load script task

I have an email script that keeps failing to load when I execute my script task. I have the precompileintobinarycode set to true. Anyone know why it won't load the script? I would use the Send Mail task but it can't find my smtp connection or something.

Thanks,

Mike

This error can spontaneously appear for no apparent reason. It seems that if you have the PreCompile property set to True, but you have precompiled script in the package, which is what spontaneously disappears, this error will be raised. To resolve this issue:

a. Open the package

b. Open the Script Task editor

c. Click Design Script

d. Close the VSA Editor

e. Close the Script Task Editor

f. Save and close the package.

|||

didn't work I still get the same error.

sql

Error: Failed to load script task

I have an email script that keeps failing to load when I execute my script task. I have the precompileintobinarycode set to true. Anyone know why it won't load the script? I would use the Send Mail task but it can't find my smtp connection or something.

Thanks,

Mike

This error can spontaneously appear for no apparent reason. It seems that if you have the PreCompile property set to True, but you have precompiled script in the package, which is what spontaneously disappears, this error will be raised. To resolve this issue:

a. Open the package

b. Open the Script Task editor

c. Click Design Script

d. Close the VSA Editor

e. Close the Script Task Editor

f. Save and close the package.

|||

didn't work I still get the same error.

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: 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: 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: 15457, Severity: 0, State: 1

I get this error every time that I try to email through SQL this has
stopped me from being able to use sql mail for the last month and all of
my notifications are failing. I've read the other thred on this and
didn't get much of a solution, ANY Ideas?
--
Posted via http://dbforums.comThis is what it says in the SQL Server books online
Configuration option '%ls' changed from %ld to %ld. Run
the RECONFIGURE statement to install.
Not sure if that helps or not.
>--Original Message--
>I get this error every time that I try to email through
SQL this has
>stopped me from being able to use sql mail for the last
month and all of
>my notifications are failing. I've read the other thred
on this and
>didn't get much of a solution, ANY Ideas?
>
>--
>Posted via http://dbforums.com
>.
>|||consider using xpsmtp instead of sql mail from
http://www.sqldev.net/xp/xpsmtp.htm
We decided to try this after getting frustrated by
occasional problems with sql mail, since then we never
have problems emailing from sql server.
>--Original Message--
>I get this error every time that I try to email through
SQL this has
>stopped me from being able to use sql mail for the last
month and all of
>my notifications are failing. I've read the other thred
on this and
>didn't get much of a solution, ANY Ideas?
>
>--
>Posted via http://dbforums.com
>.
>

Error with Email Subscriptions

Hi,
I have configured the Email settings, and have set up a scheduled
subscription to send report links.
The SQL Server Agent is running and I have also configured SQL Mail with
the correct MAPI Profile.
The subscriptions dont work and give the following error "The e-mail address
of one or more recipients is not valid.".
The email Ids are valid.
Can anybody pls help?
Thanks & Regards
MPPWell i had the same problem.It occurs when the email is not in the domain of
the server.I still don't know what 2 do.
"MPP" wrote:
> Hi,
> I have configured the Email settings, and have set up a scheduled
> subscription to send report links.
> The SQL Server Agent is running and I have also configured SQL Mail with
> the correct MAPI Profile.
> The subscriptions dont work and give the following error "The e-mail address
> of one or more recipients is not valid.".
> The email Ids are valid.
> Can anybody pls help?
> Thanks & Regards
> MPP
>
>|||You have to set your mail server up to allow relaying
--
---
Yes, I searched first :)
"MPP" wrote:
> Hi,
> I have configured the Email settings, and have set up a scheduled
> subscription to send report links.
> The SQL Server Agent is running and I have also configured SQL Mail with
> the correct MAPI Profile.
> The subscriptions dont work and give the following error "The e-mail address
> of one or more recipients is not valid.".
> The email Ids are valid.
> Can anybody pls help?
> Thanks & Regards
> MPP
>
>

error while using distinct top with Order By

I am trying to run a simple query
select DISTINCT TOP 10 email,code from user_info where code like 'xx12%'
ORDER BY x_date desc
I get this error-
Server: Msg 145, Level 15, State 1, Line 1
ORDER BY items must appear in the select list if SELECT DISTINCT is specifie
d.
Can anyone help?select DISTINCT TOP 10 email, code, x_date
from user_info where code like 'xx12%'
ORDER BY x_date desc
AMB
"Mike" wrote:

> I am trying to run a simple query
> select DISTINCT TOP 10 email,code from user_info where code like 'xx12%'
> ORDER BY x_date desc
> I get this error-
> Server: Msg 145, Level 15, State 1, Line 1
> ORDER BY items must appear in the select list if SELECT DISTINCT is specif
ied.
> Can anyone help?
>|||Some backgrouung info from celko:
http://groups.google.de/groups?hl=d...r />
2540tk2ms
ftngp13.phx.gbl%26rnum%3D1
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Mike" <Mike@.discussions.microsoft.com> schrieb im Newsbeitrag
news:FFEDAF14-77CE-46C1-AA15-363D99E265C6@.microsoft.com...
>I am trying to run a simple query
> select DISTINCT TOP 10 email,code from user_info where code like 'xx12%'
> ORDER BY x_date desc
> I get this error-
> Server: Msg 145, Level 15, State 1, Line 1
> ORDER BY items must appear in the select list if SELECT DISTINCT is
> specified.
> Can anyone help?
>|||The error message seems clear. You need to put x_Date in the Select statemen
t
like so:
Select Distinct TOP 10 x_Date, Email, Code
From User_Info
Where Code Like 'xx12%'
Order By x_Date Desc
Thomas
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:FFEDAF14-77CE-46C1-AA15-363D99E265C6@.microsoft.com...
>I am trying to run a simple query
> select DISTINCT TOP 10 email,code from user_info where code like 'xx12%'
> ORDER BY x_date desc
> I get this error-
> Server: Msg 145, Level 15, State 1, Line 1
> ORDER BY items must appear in the select list if SELECT DISTINCT is specif
ied.
> Can anyone help?
>|||you should put x_date in the select if it is used in the order by clause
SELECT DISTINCT TOP 10 email, code, x_date
FROM user_info
WHERE code LIKE 'xx12%'
ORDER BY x_date DESC
Ilyan Mishiyev
IGM Consulting Corporation
Enterprise Web Solutions
www.igmcc.com
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:FFEDAF14-77CE-46C1-AA15-363D99E265C6@.microsoft.com...
>I am trying to run a simple query
> select DISTINCT TOP 10 email,code from user_info where code like 'xx12%'
> ORDER BY x_date desc
> I get this error-
> Server: Msg 145, Level 15, State 1, Line 1
> ORDER BY items must appear in the select list if SELECT DISTINCT is
> specified.
> Can anyone help?
>|||You can put x_date in the SELECT list, as suggested by other posters, but
what I think you are after is:
select TOP 10 email,code
from user_info
where code like 'xx12%'
GROUP BY email,code
ORDER BY MIN(x_date) desc
Jacco Schalkwijk
SQL Server MVP
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:FFEDAF14-77CE-46C1-AA15-363D99E265C6@.microsoft.com...
>I am trying to run a simple query
> select DISTINCT TOP 10 email,code from user_info where code like 'xx12%'
> ORDER BY x_date desc
> I get this error-
> Server: Msg 145, Level 15, State 1, Line 1
> ORDER BY items must appear in the select list if SELECT DISTINCT is
> specified.
> Can anyone help?
>