PAGE HEADER: message

Showing posts with label message. Show all posts

Monday, March 26, 2012

Problem with SQL Agent using Database Mail

All,
I posted this message to a thread dated 11/25/2004... I guess I should have
started a new thread.
Anyway, I am having a problem with database mail and the SQL agent. The
error from the maintenance history notification step is:
Executing the query "EXECUTE msdb.dbo.sp_notify_operator
@.name=N'JimmyV',@.body=N'Database Verification Failed!'
" failed with the following error: "No global profile is configured. Specify
a profile name in the @.profile_name parameter.". Possible failure reasons:
Problems with the query, "ResultSet" property not set correctly, parameters
not set correctly, or connection not established correctly.
I've configured the database mail system, created a database mail account
and profile which is the default for the agent. I created the agent user
account in msdb in the DatabaseMailUser role. And I've created the operator.
I've also tried public default profiles and they fail too.
I can send test messages from Database Mail.
The interseting thing is that the 'Test' button is dimmed on the SQL Agent,
Alert System, Mail Session page even though the correct profile is selected!
Please, any help will be greatly appreciated.
Thanks,
JimI had a somewhat similar problem. In my case, I assigned the operators
and the Notification recipients prior to configuring the SQL Agent to
use Database Mail. Even though the jobs were set to notify on
completion (success/failure), I never received any e-mails. However,
restarting the SQL Agent service fixed it.
-Prabhakar
JimmyV wrote:
> All,
> I posted this message to a thread dated 11/25/2004... I guess I should have
> started a new thread.
> Anyway, I am having a problem with database mail and the SQL agent. The
> error from the maintenance history notification step is:
> Executing the query "EXECUTE msdb.dbo.sp_notify_operator
> @.name=N'JimmyV',@.body=N'Database Verification Failed!'
> " failed with the following error: "No global profile is configured. Specify
> a profile name in the @.profile_name parameter.". Possible failure reasons:
> Problems with the query, "ResultSet" property not set correctly, parameters
> not set correctly, or connection not established correctly.
> I've configured the database mail system, created a database mail account
> and profile which is the default for the agent. I created the agent user
> account in msdb in the DatabaseMailUser role. And I've created the operator.
> I've also tried public default profiles and they fail too.
> I can send test messages from Database Mail.
> The interseting thing is that the 'Test' button is dimmed on the SQL Agent,
> Alert System, Mail Session page even though the correct profile is selected!
> Please, any help will be greatly appreciated.
> Thanks,
> Jim|||Do you have Outlook installed on your server? I believe that it is required
to create the profiles that can be assigned in the server properties and in
the SQL Agent properties. After you install Outlook, go to the control
panel and create a profile on the server using the account the SQL Server
service uses. You then should be able to assign the profile to both the
server mail properties and the SQL Agent properties.
If you have Outlook installed, use Query analyzer and try sending an email
message using xp_sendmail. If you get an error message, issue the following
commands...
exec xp_stopmail
exec xp_startmail
This should get you started in trying to get SQL mail to work for you on
your server.
"preddy" <prvangala@.gmail.com> wrote in message
news:1138730276.706755.82690@.f14g2000cwb.googlegroups.com...
>I had a somewhat similar problem. In my case, I assigned the operators
> and the Notification recipients prior to configuring the SQL Agent to
> use Database Mail. Even though the jobs were set to notify on
> completion (success/failure), I never received any e-mails. However,
> restarting the SQL Agent service fixed it.
> -Prabhakar
> JimmyV wrote:
>> All,
>> I posted this message to a thread dated 11/25/2004... I guess I should
>> have
>> started a new thread.
>> Anyway, I am having a problem with database mail and the SQL agent. The
>> error from the maintenance history notification step is:
>> Executing the query "EXECUTE msdb.dbo.sp_notify_operator
>> @.name=N'JimmyV',@.body=N'Database Verification Failed!'
>> " failed with the following error: "No global profile is configured.
>> Specify
>> a profile name in the @.profile_name parameter.". Possible failure
>> reasons:
>> Problems with the query, "ResultSet" property not set correctly,
>> parameters
>> not set correctly, or connection not established correctly.
>> I've configured the database mail system, created a database mail account
>> and profile which is the default for the agent. I created the agent user
>> account in msdb in the DatabaseMailUser role. And I've created the
>> operator.
>> I've also tried public default profiles and they fail too.
>> I can send test messages from Database Mail.
>> The interseting thing is that the 'Test' button is dimmed on the SQL
>> Agent,
>> Alert System, Mail Session page even though the correct profile is
>> selected!
>> Please, any help will be greatly appreciated.
>> Thanks,
>> Jim
>|||> Do you have Outlook installed on your server?
Database Mail (in contrast to SQL Mail) does *not* need Outlook as it isn't using MAPI. Database
mail makes SMTP calls, so it is only dependent on TCP being available. Database Mail is new to SQL
Server 2005.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Scott Cupstid" <scupstid@.tampabay.rr.com> wrote in message news:drob90$2chn$1@.news3.infoave.net...
> Do you have Outlook installed on your server? I believe that it is required to create the
> profiles that can be assigned in the server properties and in the SQL Agent properties. After you
> install Outlook, go to the control panel and create a profile on the server using the account the
> SQL Server service uses. You then should be able to assign the profile to both the server mail
> properties and the SQL Agent properties.
> If you have Outlook installed, use Query analyzer and try sending an email message using
> xp_sendmail. If you get an error message, issue the following commands...
> exec xp_stopmail
> exec xp_startmail
> This should get you started in trying to get SQL mail to work for you on your server.
> "preddy" <prvangala@.gmail.com> wrote in message
> news:1138730276.706755.82690@.f14g2000cwb.googlegroups.com...
>>I had a somewhat similar problem. In my case, I assigned the operators
>> and the Notification recipients prior to configuring the SQL Agent to
>> use Database Mail. Even though the jobs were set to notify on
>> completion (success/failure), I never received any e-mails. However,
>> restarting the SQL Agent service fixed it.
>> -Prabhakar
>> JimmyV wrote:
>> All,
>> I posted this message to a thread dated 11/25/2004... I guess I should have
>> started a new thread.
>> Anyway, I am having a problem with database mail and the SQL agent. The
>> error from the maintenance history notification step is:
>> Executing the query "EXECUTE msdb.dbo.sp_notify_operator
>> @.name=N'JimmyV',@.body=N'Database Verification Failed!'
>> " failed with the following error: "No global profile is configured. Specify
>> a profile name in the @.profile_name parameter.". Possible failure reasons:
>> Problems with the query, "ResultSet" property not set correctly, parameters
>> not set correctly, or connection not established correctly.
>> I've configured the database mail system, created a database mail account
>> and profile which is the default for the agent. I created the agent user
>> account in msdb in the DatabaseMailUser role. And I've created the operator.
>> I've also tried public default profiles and they fail too.
>> I can send test messages from Database Mail.
>> The interseting thing is that the 'Test' button is dimmed on the SQL Agent,
>> Alert System, Mail Session page even though the correct profile is selected!
>> Please, any help will be greatly appreciated.
>> Thanks,
>> Jim
>|||I tried what you suggested and unfortunately it still fails in the same way.
The really strange thing is that the 'Test' button will not activate; telling
me something is still wrong.
Jim
"preddy" wrote:
> I had a somewhat similar problem. In my case, I assigned the operators
> and the Notification recipients prior to configuring the SQL Agent to
> use Database Mail. Even though the jobs were set to notify on
> completion (success/failure), I never received any e-mails. However,
> restarting the SQL Agent service fixed it.
> -Prabhakar
> JimmyV wrote:
> > All,
> >
> > I posted this message to a thread dated 11/25/2004... I guess I should have
> > started a new thread.
> >
> > Anyway, I am having a problem with database mail and the SQL agent. The
> > error from the maintenance history notification step is:
> >
> > Executing the query "EXECUTE msdb.dbo.sp_notify_operator
> > @.name=N'JimmyV',@.body=N'Database Verification Failed!'
> > " failed with the following error: "No global profile is configured. Specify
> > a profile name in the @.profile_name parameter.". Possible failure reasons:
> > Problems with the query, "ResultSet" property not set correctly, parameters
> > not set correctly, or connection not established correctly.
> >
> > I've configured the database mail system, created a database mail account
> > and profile which is the default for the agent. I created the agent user
> > account in msdb in the DatabaseMailUser role. And I've created the operator.
> >
> > I've also tried public default profiles and they fail too.
> >
> > I can send test messages from Database Mail.
> >
> > The interseting thing is that the 'Test' button is dimmed on the SQL Agent,
> > Alert System, Mail Session page even though the correct profile is selected!
> >
> > Please, any help will be greatly appreciated.
> >
> > Thanks,
> > Jim
>sql

Problem with SQL Agent using Database Mail

Friday, March 23, 2012

Problem with sp_OACreate

The sp_OACreate fails at nights it works fine at daytime, I checked the
Event Log, and saw below error message for every databases I have.
18278 :
Database log truncated: Database: DBNAME.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:523AA016-9F7B-4CDA-A3DA-809E79084527@.microsoft.com...
> Hi
> You may want to try turning it off for a period and see if the problem
> persists. You need to asses the risk of doing this, such as
> http://support.microsoft.com/defaul...kb;en-us;309422
> John
> "Erdal Akbulut" wrote:
>
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_oa-oz_3enj.asp[/ur
l]
any
ActiveX
Windows
ActiveXHi
I don't think that has anything to do with the error! You may want to check
if there are any scheduled virus scans at the time your error occurs.
John
"Erdal Akbulut" wrote:

> The sp_OACreate fails at nights it works fine at daytime, I checked the
> Event Log, and saw below error message for every databases I have.
> 18278 :
> Database log truncated: Database: DBNAME.
>
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:523AA016-9F7B-4CDA-A3DA-809E79084527@.microsoft.com...
> http://msdn.microsoft.com/library/d...
a-oz_3enj.asp
> any
> ActiveX
> Windows
> ActiveX
>
>|||Hi,
We have a w

ly scheduled Virus Scan on that machine.sp_OACreate fails more
than once in a w

Thanks,
Erdal
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:24CDDF90-D6DF-4BA7-A02D-84B6F5A5308A@.microsoft.com...
> Hi
> I don't think that has anything to do with the error! You may want to
check
> if there are any scheduled virus scans at the time your error occurs.
> John
> "Erdal Akbulut" wrote:
>
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_oa-oz_3enj.asp[/ur
l]
there
using|||Hi
You may be better migrating to CDO.
John
"Erdal Akbulut" wrote:

> Hi,
> We have a w

ly scheduled Virus Scan on that machine.sp_OACreate fails mo
re
> than once in a w

> Thanks,
> Erdal
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:24CDDF90-D6DF-4BA7-A02D-84B6F5A5308A@.microsoft.com...
> check
> http://msdn.microsoft.com/library/d...
a-oz_3enj.asp
> there
> using
>
>|||John,
I am not sure if I can use CDOSYS.dll instead of CDONOTS.dll in my VB6
application. Actualy The Server is Win2003 and there was no CDONTS.dll I
copied and registered that dll.
Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:0FBF1B85-A949-45A5-B2FE-B9FB780A4C25@.microsoft.com...
> Hi
> You may be better migrating to CDO.
> John
> "Erdal Akbulut" wrote:
>
more
the
problem
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_oa-oz_3enj.asp[/ur
l]
VB
moved to
create|||Hi
I am still not sure why it runs during the day and not at night using the
same process, therefore to eliminate any incorrect configuration of
cdonts.dll it would be safer to use the native cdo. If that fails then the
issue is probably external to CDO.
John
"Erdal Akbulut" wrote:

> John,
> I am not sure if I can use CDOSYS.dll instead of CDONOTS.dll in my VB6
> application. Actualy The Server is Win2003 and there was no CDONTS.dll I
> copied and registered that dll.
> Thanks.
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:0FBF1B85-A949-45A5-B2FE-B9FB780A4C25@.microsoft.com...
> more
> the
> problem
> http://msdn.microsoft.com/library/d...
a-oz_3enj.asp
> VB
> moved to
> create
>
>

Wednesday, March 21, 2012

Problem with simple subquery in SQL2005 AND SQL2000.

When I use the simple query with a subquery shown below, this is the error message I get in SQL 2000 AND SQL 2005

"Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression."

And here is the query I use:

SELECT docSections.SectionID,

(SELECT docSectionText.colText FROM docSectionText

WHERE (docSections.SectionID = docSectionText.SectionID)

AND (docSectionText.colOrdinal = 1)) AS SecTitle

FROM docSections

Can anyone please let me know what I do wrong here.

Thanks

Gerhard

I can tell you why you get the error. But, without understanding your schema and requirements, I can not give you a solution for what you are trying to do.

The problem is that when you have a subquery in your SELECT it can only return 1 row per row. So, your subquery must be returning multiple rows.

To check try the following queries and see what it returns.

-- This should show you the sectionid that have multiple rows with colOrdinal = 1
SELECT SECTIONID, count(coltext) as rowcount
FROM docSections
WHERE docSectionText.colOrdinal = 1
GROUP BY SectionID
HAVING count(coltext) > 1

-- This should checks if perhaps the identified sections have multiple rows
--but all with same coltext. If first returns rows, but this doesn't,
--then you can add distinct to solve your problems
SELECT SECTIONID, count(distinct coltext) as rowcount
FROM docSections
WHERE docSectionText.colOrdinal = 1
GROUP BY SectionID
HAVING count(distinct coltext) > 1

HTH

|||

Thank You very much.

You were correct. I had 2 doubles in my table.

Gerhard

Monday, March 12, 2012

Problem with sa password

Hi All,
I get error when I tried to edit the properties of the sa password. I get
the follwing message:
"Error 21776: [SQL-DMO] The name 'dbo' was not found in the users
collection"
No problems with editing others.
This is very serious because it is the production server.
I urgently need help.
Thank
Egbon.Check out this article: Q218172. It sounds like you have some databases
where dbo is mapped to null.
You should still be able to change the password with sp_changepassword.
"Egbon" <Vnjowusi@.gosps.com> wrote in message
news:unQGxgsUDHA.1680@.tk2msftngp13.phx.gbl...
> Hi All,
> I get error when I tried to edit the properties of the sa password. I get
> the follwing message:
> "Error 21776: [SQL-DMO] The name 'dbo' was not found in the users
> collection"
> No problems with editing others.
> This is very serious because it is the production server.
> I urgently need help.
> Thank
> Egbon.
>|||Many thanks, James.
Egbon
"James Luetkehoelter" <james.luetkehoetler@.NOSPAMspyglassllc.com> wrote in
message news:em1EQmsUDHA.3220@.tk2msftngp13.phx.gbl...
> Check out this article: Q218172. It sounds like you have some databases
> where dbo is mapped to null.
> You should still be able to change the password with sp_changepassword.
> "Egbon" <Vnjowusi@.gosps.com> wrote in message
> news:unQGxgsUDHA.1680@.tk2msftngp13.phx.gbl...
> > Hi All,
> >
> > I get error when I tried to edit the properties of the sa password. I
get
> > the follwing message:
> > "Error 21776: [SQL-DMO] The name 'dbo' was not found in the users
> > collection"
> > No problems with editing others.
> > This is very serious because it is the production server.
> > I urgently need help.
> >
> > Thank
> >
> > Egbon.
> >
> >
>

Problem with restoring sql server database

Hi
I need to restore a recent backup of sql server database. However, the
message I am getting is that database needs to be in exclusive mode. It is in
use. My question is how to know who is using the database and get them off
the database so that I can restore the database from a backup. Thanks in
advanceHave a look at the ALTER DATABASE command and the SET SINGLE_USER and
ROLLBACK IMEDIATE options.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:C581FA7C-EC5A-4A97-AB02-790554E8ABB2@.microsoft.com...
> Hi
> I need to restore a recent backup of sql server database. However, the
> message I am getting is that database needs to be in exclusive mode. It is
> in
> use. My question is how to know who is using the database and get them off
> the database so that I can restore the database from a backup. Thanks in
> advance|||Thanks for your help Andrew. I appreciate it. Let me try this and see.
"Andrew J. Kelly" wrote:
> Have a look at the ALTER DATABASE command and the SET SINGLE_USER and
> ROLLBACK IMEDIATE options.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Jack" <Jack@.discussions.microsoft.com> wrote in message
> news:C581FA7C-EC5A-4A97-AB02-790554E8ABB2@.microsoft.com...
> > Hi
> > I need to restore a recent backup of sql server database. However, the
> > message I am getting is that database needs to be in exclusive mode. It is
> > in
> > use. My question is how to know who is using the database and get them off
> > the database so that I can restore the database from a backup. Thanks in
> > advance
>|||Most of the time, it's "you," the DBA trying to restore the database that is
using the database. Whether using Enterprise Manager or Management Studio,
users tend to select the database in the UI when restoring. This has
already created a connection to the database. I'd rather do it using scripts
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:CEF6E906-04B9-4053-9E83-5CB7E89C78CD@.microsoft.com...
> Thanks for your help Andrew. I appreciate it. Let me try this and see.
> "Andrew J. Kelly" wrote:
>> Have a look at the ALTER DATABASE command and the SET SINGLE_USER and
>> ROLLBACK IMEDIATE options.
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "Jack" <Jack@.discussions.microsoft.com> wrote in message
>> news:C581FA7C-EC5A-4A97-AB02-790554E8ABB2@.microsoft.com...
>> > Hi
>> > I need to restore a recent backup of sql server database. However, the
>> > message I am getting is that database needs to be in exclusive mode. It
>> > is
>> > in
>> > use. My question is how to know who is using the database and get them
>> > off
>> > the database so that I can restore the database from a backup. Thanks
>> > in
>> > advance
>>|||Jack wrote:
> Hi
> I need to restore a recent backup of sql server database. However,
> the message I am getting is that database needs to be in exclusive
> mode. It is in use. My question is how to know who is using the
> database and get them off the database so that I can restore the
> database from a backup. Thanks in advance
Hi, Jack
You can use sp_who2 or look in Management / Activity Monitor (in
Management Studio).
It is possible that the connection using the database belongs to
yourself. Close any open windows that are accesing that database. If
you are using a query window to restore, make sure you the current
database is not that database (change it to master, for example).
--
Razvan Socol
SQL Server MVP

Friday, March 9, 2012

Problem with Report viewer

This is a multi-part message in MIME format.
--=_NextPart_000_0006_01C6EDDF.D2BB2D90
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
I recently upgraded by ASP.Net 1.1 application to 2.0. 1.1 application = was using awReportViewer to view the reports.
But, when upgraded, awreportViewer doesnt display the RS2005 = enhancements like sorting, etc...so I decided to replace it with Report = Viewer control in VS2005.
Now the problem starts, Whenever I try accesing the reports, it gives me = error "Client found response content type of '', but expected = 'text/xml'.
The request failed with an empty response."
This is how I have coded,
ReportViewer1.ProcessingMode =3D ProcessingMode.Remote
ReportViewer1.ServerReport.ReportServerUrl =3D New = Uri(http://localhost/ReportServer/reportservice.asmx)
ReportViewer1.ServerReport.ReportPath =3D reportname
//Some code to set parameters in Report Paramater "parameters"
ReportViewer1.ServerReport.SetParameters(parameters)
My questions:
1. Am I going wrong somewhere in the above code?
2. Can awReportViewer be modified / upgraded so that it can support = RS2005 features like sorting, multivalued parameters?
TIA
Tanmaya
--=_NextPart_000_0006_01C6EDDF.D2BB2D90
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi,

I recently upgraded by ASP.Net 1.1 = application to 2.0. 1.1 application was using awReportViewer to view the = reports.
But, when upgraded, awreportViewer = doesnt display the RS2005 enhancements like sorting, etc...so I decided to replace it = with Report Viewer control in VS2005.

Now the problem starts, Whenever I try = accesing the reports, it gives me error "Client found response content type = of '', but expected 'text/xml'.The request failed with an empty response."

This is how I have coded,

ReportViewer1.ProcessingMode =3D ProcessingMode.Remote
ReportViewer1.ServerReport.ReportServerUrl =3D New Uri(http://localhost/ReportServer/reportservice.asmx)
ReportViewer1.ServerReport.ReportPath =3D = reportname
//Some code to set parameters in Report = Paramater "parameters"
ReportViewer1.ServerReport.SetParameters(parameters)
My questions:
1. Am I going wrong somewhere in the = above code?
2. Can awReportViewer be modified / = upgraded so that it can support RS2005 features like sorting, multivalued = parameters?
TIA
Tanmaya
--=_NextPart_000_0006_01C6EDDF.D2BB2D90--On Thu, 12 Oct 2006 09:21:39 +0530, "Tan"
<tanmaya_kulkarni@.persistent.co.in> wrote:
>Hi,
>I recently upgraded by ASP.Net 1.1 application to 2.0. 1.1 application was using awReportViewer to view the reports.
>But, when upgraded, awreportViewer doesnt display the RS2005 enhancements like sorting, etc...so I decided to replace it with Report Viewer control in VS2005.
>Now the problem starts, Whenever I try accesing the reports, it gives me error "Client found response content type of '', but expected 'text/xml'.
>The request failed with an empty response."
>This is how I have coded,
>ReportViewer1.ProcessingMode = ProcessingMode.Remote
>ReportViewer1.ServerReport.ReportServerUrl = New Uri(http://localhost/ReportServer/reportservice.asmx)
>ReportViewer1.ServerReport.ReportPath = reportname
>//Some code to set parameters in Report Paramater "parameters"
>ReportViewer1.ServerReport.SetParameters(parameters)
>My questions:
>1. Am I going wrong somewhere in the above code?
>2. Can awReportViewer be modified / upgraded so that it can support RS2005 features like sorting, multivalued parameters?
>TIA
>Tanmaya
Dunno but I've never added the /reportservice.asmx at the end fo the
ReportServerURL. I've just used http://localhost/ReportServer.
Actually I set that at design time so I don't know if that makes a
difference.

Problem with Report Pack for sharepoint's, rpdataextraction parser

hi,

when i try to execute the rpdataextraction parser, i am getting the following message - Unable to access site collection: User cannot be found.

it will be of immense help for me if any one helps me on this or directs me to right resource.

thanks

hello,

I have the same problem, so yesterday I found a possible solution for this problem, I'm trying to follow it:

There are a french blog for this issue: http://fmdain.blogspot.com/2006/06/reporting-pack-sps.pour-sql2k5.html.

The solution consist in:

1 - Verify that the tables DimDate and DimTime was complete filled. In my case the DimTime wasn't.

2 - an edition on procedures on database dbSPSReporting, to comment's lines : WHERE dd.DateFull and DATEADD, for all procedures on database.

I localized only those below:

PROCEDURE dbo.uspStorage_AreaGrowthTrend
PROCEDURE dbo.uspStorage_ListGrowthTrend
PROCEDURE dbo.uspStorage_SiteCollectionTrend
PROCEDURE dbo.uspStorage_SizeTrend
PROCEDURE dbo.usp_StartDateEndDate_Retrieve

If you use this solution and works, please send me a confirmation and any other comments about, or other solution.

Regards,

Ernani

Problem with Report Pack for sharepoint's, rpdataextraction parser

hi,

when i try to execute the rpdataextraction parser, i am getting the following message - Unable to access site collection: User cannot be found.

it will be of immense help for me if any one helps me on this or directs me to right resource.

thanks

hello,

I have the same problem, so yesterday I found a possible solution for this problem, I'm trying to follow it:

There are a french blog for this issue: http://fmdain.blogspot.com/2006/06/reporting-pack-sps.pour-sql2k5.html.

The solution consist in:

1 - Verify that the tables DimDate and DimTime was complete filled. In my case the DimTime wasn't.

2 - an edition on procedures on database dbSPSReporting, to comment's lines : WHERE dd.DateFull and DATEADD, for all procedures on database.

I localized only those below:

If you use this solution and works, please send me a confirmation and any other comments about, or other solution.

Regards,

Ernani

Monday, February 20, 2012

Problem with osql.exe -L

This is a multi-part message in MIME format.
--=_NextPart_000_0033_01C566E6.B2395460
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Everyone,
I'm facing a small problem. Whenever I execute osql.exe -L command it = lists all the server on the network except my local server instance (not = default instance) and other similar server instance names on the = network.
Earlier it use to list all the server instance but all of a sudden = stopped listing.
What can be the problem? Please help me to rectify this issue.
Thanks in adv.
Regards,
BGS
--=_NextPart_000_0033_01C566E6.B2395460
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi Everyone,I'm facing a small problem. Whenever I execute osql.exe = -L command it lists all the server on the network except my local = server instance (not default instance) and other similar server instance names = on the network.Earlier it use to list all the server instance but all = of a sudden stopped listing.What can be the problem? Please help me = to rectify this issue.Thanks in adv.Regards,BGS
--=_NextPart_000_0033_01C566E6.B2395460--OSQL -L uses the ODBC SQLBrowseConnect functionality. It's
not guaranteed to give a complete list due to broadcast
issues, network routers/subnet issues, instances may not
respond within the timeout period, etc. You can find issues
listed here:
http://www.sqldev.net/misc/ListSQLSvr.htm
-Sue
On Wed, 1 Jun 2005 20:15:46 +0530, "Gururaj Badam"
<gururajb@.msn.com> wrote:
>Hi Everyone,
>I'm facing a small problem. Whenever I execute osql.exe -L command it lists all the server on the network except my local server instance (not default instance) and other similar server instance names on the network.
>Earlier it use to list all the server instance but all of a sudden stopped listing.
>What can be the problem? Please help me to rectify this issue.
>Thanks in adv.
>Regards,
>BGS|||Sue,
Is ListAvailableSQLServers in SQL-DMO is also same as "osql -L" command?
Actually I'm trying to populate a ComboBox with list of all the SQL Servers
on the network and set the default to the Local Server (desired instance).
Can you suggest some other better mechanism which can be used to acheive the
same?
-BGS|||ListAvailableServers is also based on the ODBC function
SQLBrowseConnect. If you need a guaranteed list and are
running SQL 2000, you could register all SQL Servers in AD
and go through AD to list all of SQL Servers.
-Sue
On Thu, 2 Jun 2005 09:57:10 +0530, "Gururaj Badam"
<gururajb@.msn.com> wrote:
>Sue,
>Is ListAvailableSQLServers in SQL-DMO is also same as "osql -L" command?
>Actually I'm trying to populate a ComboBox with list of all the SQL Servers
>on the network and set the default to the Local Server (desired instance).
>Can you suggest some other better mechanism which can be used to acheive the
>same?
>-BGS
>|||Sue,
Actually I'm not using SQL 2k but MSDE installation. It is a product, I
can't ask the client to install SQL Server 2000.
That's the reason I'm packing the MSDE along with the application
installation package.
-BGS
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:g9ut91daj141d35g8v2dn133q713uo9ieq@.4ax.com...
> ListAvailableServers is also based on the ODBC function
> SQLBrowseConnect. If you need a guaranteed list and are
> running SQL 2000, you could register all SQL Servers in AD
> and go through AD to list all of SQL Servers.
> -Sue
>|||MSDE is SQL Server, so everything that Sue mentioned still applies.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Gururaj Badam" <gururajb@.msn.com> wrote in message news:OV9E6C3ZFHA.2916@.TK2MSFTNGP14.phx.gbl...
> Sue,
> Actually I'm not using SQL 2k but MSDE installation. It is a product, I
> can't ask the client to install SQL Server 2000.
> That's the reason I'm packing the MSDE along with the application
> installation package.
> -BGS
>
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:g9ut91daj141d35g8v2dn133q713uo9ieq@.4ax.com...
>> ListAvailableServers is also based on the ODBC function
>> SQLBrowseConnect. If you need a guaranteed list and are
>> running SQL 2000, you could register all SQL Servers in AD
>> and go through AD to list all of SQL Servers.
>> -Sue
>|||Tibor,
How can I ask the user of my product to register the SQL Server with the AD,
that looks odd.
Is there any other way to approach this problem?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23AYiWX3ZFHA.3040@.TK2MSFTNGP14.phx.gbl...
> MSDE is SQL Server, so everything that Sue mentioned still applies.
> --
> Tibor Karaszi, SQL Server MVP

Monday, March 26, 2012

Problem with SQL Agent using Database Mail

Problem with SQL Agent using Database Mail

Problem with SQL Agent using Database Mail

Friday, March 23, 2012

Problem with sp_OACreate

Wednesday, March 21, 2012

Problem with simple subquery in SQL2005 AND SQL2000.

Monday, March 12, 2012

Problem with sa password

Problem with restoring sql server database

Friday, March 9, 2012

Problem with Report viewer

Problem with Report Pack for sharepoint's, rpdataextraction parser

Problem with Report Pack for sharepoint's, rpdataextraction parser

Monday, February 20, 2012

Problem with osql.exe -L

PAGE HEADER

Blog Archive

About Me