etl best practice

Hi
With As there's a lot of ETL.
How much is there with report builder ? I've seen the up-coming versionn
of the erp system Dynamics Ax and it looks as if there is no ETL at all -
they
just build a report model ontop of the production database.
Is this ok ? Give's realtime but is the transaction database structue okay
for building larger reporting solutions ?
/Michael V.I think you need to perform the etl to get to the datasource view state,
then you may want to build an AS 2005 cube, or a report object model or
both. My point is the etl gets you to the intermediary point. ETL may not
be required, but may be waranted for the same reasons we used etl processes
in AS 2000. I'm not familiar with Dynamics Ax.
Steve MunLeeuw
"michael v" <test@.test.com> wrote in message
news:OxB7TjZzGHA.3440@.TK2MSFTNGP06.phx.gbl...
> Hi
> With As there's a lot of ETL.
> How much is there with report builder ? I've seen the up-coming versionn
> of the erp system Dynamics Ax and it looks as if there is no ETL at all -
> they
> just build a report model ontop of the production database.
> Is this ok ? Give's realtime but is the transaction database structue okay
> for building larger reporting solutions ?
> /Michael V.
>

Errors processing SSAS 2005

Hi,

I am receiving the following error when i try to deploy project.

Error 1 The following system error occurred: .

AS 2005 SP1

Windows Server 2003 Ent. SP1

Make sure Analysis Server is runing. Go to the project's properties and make sure your project points to the Analysis Server.

Can you also describe the error. Is it a single error. Are there more errors? Is this the first time you are trying to deploy?

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

|||

Hello Edward!

On your questions: Analysis Server is runing - Yes, project points to the Analysis Server - Yes

Is it a single error - Yes. Is this the first time you are trying to deploy? - No, The error has appeared after the server became DC.

New projects are developed normally, All cubes old and new process is normal.

|||

This could be very much as a result of your computer becoming domaing controller.

Can you connect to Anlaysis Server from SQL Management Studio?

Try deleting everything from the data folder and restarting Analysis Server. This cause you to loose all of your databases, make sure you have you projects saved so you can re-create databases again .

If that doesnt help, the only solution I see is to try and re-install Analysis Services.

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

Errors of System DB Backup T-logJobs for Maint Plan

I have been bothered with the error signs of the DB Backup
jobs for my DB Maint Plan. These job errors were shown in
SQL Server Agent node of the Enterprise Manager.
After checking the DB Maint Plan history, I found the
errors were due to the Backup T-log job errors on system
databases, e.g. master, msdb. Later on I found out that
we can set master to Full recovery model, but still no T-
log backup choice available, while tempdb can not even be
set to Full model.
If I still want to select 'All Databases' in my Maint
Plan, how can I avoid these Maint Plan job errors in the
SQL Server Agent node? How do I decide the DB recovery
model (Full or Simple) for the system databases in my
database servers when configuring my Maint Plan?
Furthermore, I have heard that there are no T-log backup
device for the system databases, only for user databases.
What exactly does this mean?
Thanks in Advance.
JeffreyI normally create one maint plan for my sysdbs this way you can avoid that
and some other errors.
You cannot restore the master database like you restore the users db, the
master db has to be rebuild. Because of the size of your system db i
normally backed them up twice a day, and overwrite every two weeks and i
have it set to simple.
Take a look at BOL (books online) to understand more about backup models.
Yovan Fernandez
"Jeffrey" <jwang@.dot.state.tx.us> wrote in message
news:0bd901c377d7$bcf03a40$a001280a@.phx.gbl...
> I have been bothered with the error signs of the DB Backup
> jobs for my DB Maint Plan. These job errors were shown in
> SQL Server Agent node of the Enterprise Manager.
> After checking the DB Maint Plan history, I found the
> errors were due to the Backup T-log job errors on system
> databases, e.g. master, msdb. Later on I found out that
> we can set master to Full recovery model, but still no T-
> log backup choice available, while tempdb can not even be
> set to Full model.
> If I still want to select 'All Databases' in my Maint
> Plan, how can I avoid these Maint Plan job errors in the
> SQL Server Agent node? How do I decide the DB recovery
> model (Full or Simple) for the system databases in my
> database servers when configuring my Maint Plan?
> Furthermore, I have heard that there are no T-log backup
> device for the system databases, only for user databases.
> What exactly does this mean?
> Thanks in Advance.
> Jeffrey
>

Errors in log

The following are errors I found in one of my SQL Server Logs:
Error: 17207, Severity: 16, State: 1.
FCB::RemoveAlternateStreams: Operating system error (null) occurred while
creating or opening file 'C:\Program Files\Microsoft SQL
Server\MSSQL\data\master.mdf'. Diagnose and correct the operating system
error, and retry the operation.
Recovery is writing a checkpoint in database 'master' (1). This is an
informational message only. No user action is required.
CHECKDB for database 'master' finished without errors on 2007-06-12
14:09:11.613 (local time). This is an informational message only; no user
action is required.
I checked the security for master database file and it is ok. Any idea what
could cause this? thanks.
Lijun
On Jun 12, 9:13 pm, "Lijun Zhang" <sonyzhan...@.yahoo.com> wrote:
> The following are errors I found in one of my SQL Server Logs:
> Error: 17207, Severity: 16, State: 1.
> FCB::RemoveAlternateStreams: Operating system error (null) occurred while
> creating or opening file 'C:\Program Files\Microsoft SQL
> Server\MSSQL\data\master.mdf'. Diagnose and correct the operating system
> error, and retry the operation.
> Recovery is writing a checkpoint in database 'master' (1). This is an
> informational message only. No user action is required.
> CHECKDB for database 'master' finished without errors on 2007-06-12
> 14:09:11.613 (local time). This is an informational message only; no user
> action is required.
> I checked the security for master database file and it is ok. Any idea what
> could cause this? thanks.
> Lijun
Hi
Does this error happen regularly?
Other applications accessing the file such as Anti-Virus software can
cause problems similar to this e.g.
https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=201223&SiteID=1
John
|||Yes. I have to rebuild the master database to solve the problem.
Lijun
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1181719774.789471.92510@.o11g2000prd.googlegro ups.com...
> On Jun 12, 9:13 pm, "Lijun Zhang" <sonyzhan...@.yahoo.com> wrote:
> Hi
> Does this error happen regularly?
> Other applications accessing the file such as Anti-Virus software can
> cause problems similar to this e.g.
> https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=201223&SiteID=1
> John
>
|||Hi Lijun
On Jun 13, 8:23 pm, "Lijun Zhang" <sonyzhan...@.yahoo.com> wrote:
> Yes. I have to rebuild the master database to solve the problem.
> Lijun
> "John Bell" <jbellnewspo...@.hotmail.com> wrote in message
> news:1181719774.789471.92510@.o11g2000prd.googlegro ups.com...
That seems quite drastic as the message is only a warning and CHECKDB
returned no errors! Do you know what the cause was?
John
|||No. I don't know what is the cause.
Lijun
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1181805578.143092.163530@.n15g2000prd.googlegr oups.com...
> Hi Lijun
> On Jun 13, 8:23 pm, "Lijun Zhang" <sonyzhan...@.yahoo.com> wrote:
> That seems quite drastic as the message is only a warning and CHECKDB
> returned no errors! Do you know what the cause was?
> John
>

Errors in log

The following are errors I found in one of my SQL Server Logs:
Error: 17207, Severity: 16, State: 1.
FCB::RemoveAlternateStreams: Operating system error (null) occurred while
creating or opening file 'C:\Program Files\Microsoft SQL
Server\MSSQL\data\master.mdf'. Diagnose and correct the operating system
error, and retry the operation.
Recovery is writing a checkpoint in database 'master' (1). This is an
informational message only. No user action is required.
CHECKDB for database 'master' finished without errors on 2007-06-12
14:09:11.613 (local time). This is an informational message only; no user
action is required.
I checked the security for master database file and it is ok. Any idea what
could cause this? thanks.
LijunOn Jun 12, 9:13 pm, "Lijun Zhang" <sonyzhan...@.yahoo.com> wrote:
> The following are errors I found in one of my SQL Server Logs:
> Error: 17207, Severity: 16, State: 1.
> FCB::RemoveAlternateStreams: Operating system error (null) occurred while
> creating or opening file 'C:\Program Files\Microsoft SQL
> Server\MSSQL\data\master.mdf'. Diagnose and correct the operating system
> error, and retry the operation.
> Recovery is writing a checkpoint in database 'master' (1). This is an
> informational message only. No user action is required.
> CHECKDB for database 'master' finished without errors on 2007-06-12
> 14:09:11.613 (local time). This is an informational message only; no user
> action is required.
> I checked the security for master database file and it is ok. Any idea what
> could cause this? thanks.
> Lijun
Hi
Does this error happen regularly?
Other applications accessing the file such as Anti-Virus software can
cause problems similar to this e.g.
https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=201223&SiteID=1
John|||Yes. I have to rebuild the master database to solve the problem.
Lijun
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1181719774.789471.92510@.o11g2000prd.googlegroups.com...
> On Jun 12, 9:13 pm, "Lijun Zhang" <sonyzhan...@.yahoo.com> wrote:
>> The following are errors I found in one of my SQL Server Logs:
>> Error: 17207, Severity: 16, State: 1.
>> FCB::RemoveAlternateStreams: Operating system error (null) occurred while
>> creating or opening file 'C:\Program Files\Microsoft SQL
>> Server\MSSQL\data\master.mdf'. Diagnose and correct the operating system
>> error, and retry the operation.
>> Recovery is writing a checkpoint in database 'master' (1). This is an
>> informational message only. No user action is required.
>> CHECKDB for database 'master' finished without errors on 2007-06-12
>> 14:09:11.613 (local time). This is an informational message only; no user
>> action is required.
>> I checked the security for master database file and it is ok. Any idea
>> what
>> could cause this? thanks.
>> Lijun
> Hi
> Does this error happen regularly?
> Other applications accessing the file such as Anti-Virus software can
> cause problems similar to this e.g.
> https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=201223&SiteID=1
> John
>|||Hi Lijun
On Jun 13, 8:23 pm, "Lijun Zhang" <sonyzhan...@.yahoo.com> wrote:
> Yes. I have to rebuild the master database to solve the problem.
> Lijun
> "John Bell" <jbellnewspo...@.hotmail.com> wrote in message
> news:1181719774.789471.92510@.o11g2000prd.googlegroups.com...
That seems quite drastic as the message is only a warning and CHECKDB
returned no errors! Do you know what the cause was?
John|||No. I don't know what is the cause.
Lijun
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1181805578.143092.163530@.n15g2000prd.googlegroups.com...
> Hi Lijun
> On Jun 13, 8:23 pm, "Lijun Zhang" <sonyzhan...@.yahoo.com> wrote:
>> Yes. I have to rebuild the master database to solve the problem.
>> Lijun
>> "John Bell" <jbellnewspo...@.hotmail.com> wrote in message
>> news:1181719774.789471.92510@.o11g2000prd.googlegroups.com...
> That seems quite drastic as the message is only a warning and CHECKDB
> returned no errors! Do you know what the cause was?
> John
>

Errors in log

The following are errors I found in one of my SQL Server Logs:
Error: 17207, Severity: 16, State: 1.
FCB::RemoveAlternateStreams: Operating system error (null) occurred while
creating or opening file 'C:\Program Files\Microsoft SQL
Server\MSSQL\data\master.mdf'. Diagnose and correct the operating system
error, and retry the operation.
Recovery is writing a checkpoint in database 'master' (1). This is an
informational message only. No user action is required.
CHECKDB for database 'master' finished without errors on 2007-06-12
14:09:11.613 (local time). This is an informational message only; no user
action is required.
I checked the security for master database file and it is ok. Any idea what
could cause this? thanks.
LijunOn Jun 12, 9:13 pm, "Lijun Zhang" <sonyzhan...@.yahoo.com> wrote:
> The following are errors I found in one of my SQL Server Logs:
> Error: 17207, Severity: 16, State: 1.
> FCB::RemoveAlternateStreams: Operating system error (null) occurred while
> creating or opening file 'C:\Program Files\Microsoft SQL
> Server\MSSQL\data\master.mdf'. Diagnose and correct the operating system
> error, and retry the operation.
> Recovery is writing a checkpoint in database 'master' (1). This is an
> informational message only. No user action is required.
> CHECKDB for database 'master' finished without errors on 2007-06-12
> 14:09:11.613 (local time). This is an informational message only; no user
> action is required.
> I checked the security for master database file and it is ok. Any idea wha
t
> could cause this? thanks.
> Lijun
Hi
Does this error happen regularly?
Other applications accessing the file such as Anti-Virus software can
cause problems similar to this e.g.
https://forums.microsoft.com/MSDN/S...201223&SiteID=1
John|||Yes. I have to rebuild the master database to solve the problem.
Lijun
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1181719774.789471.92510@.o11g2000prd.googlegroups.com...
> On Jun 12, 9:13 pm, "Lijun Zhang" <sonyzhan...@.yahoo.com> wrote:
> Hi
> Does this error happen regularly?
> Other applications accessing the file such as Anti-Virus software can
> cause problems similar to this e.g.
> https://forums.microsoft.com/MSDN/S...201223&SiteID=1
> John
>|||Hi Lijun
On Jun 13, 8:23 pm, "Lijun Zhang" <sonyzhan...@.yahoo.com> wrote:
> Yes. I have to rebuild the master database to solve the problem.
> Lijun
> "John Bell" <jbellnewspo...@.hotmail.com> wrote in message
> news:1181719774.789471.92510@.o11g2000prd.googlegroups.com...
That seems quite drastic as the message is only a warning and CHECKDB
returned no errors! Do you know what the cause was?
John|||No. I don't know what is the cause.
Lijun
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1181805578.143092.163530@.n15g2000prd.googlegroups.com...
> Hi Lijun
> On Jun 13, 8:23 pm, "Lijun Zhang" <sonyzhan...@.yahoo.com> wrote:
> That seems quite drastic as the message is only a warning and CHECKDB
> returned no errors! Do you know what the cause was?
> John
>

Errors accessing VFP data.

I have a test system setup in Reading.
SQL Server is on machine EUK01314
IIS 5 also is on machine EUK01314
Reporting services are installed on machine EUK01314
Visual Studo is on machine EUK01314
I can create reports that access SQL server data, or via ODBC, or via OLEDB
to SQL server on EUK01314.
I can use those reports from our Terminal Server, no problem.
I can create reports that access Oracle data, via ODBC, or via OLEDB to
Oracle on a server in Belgim..
I can use those reports from our Terminal Server, no problem.
I draw a total blank accessing Visual FoxPro data.
I can create reports that access VFP data, via ODBC or OLEDB.
Those reports work on EUK01314 in Visual Studio.
Those reports work on EUK01314 in IE via Report Manager.
So why on earth (or any other planet) don't they work on any other machine
?
Connection string: Driver={Microsoft Visual FoxPro
Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
file \\ecengds001\connections\data\connrdp.dbc. ERROR [IM006]
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR
[01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the
version of ODBC behavior that the application requested (see SQLSetEnvAttr).
Connection string: Driver={Microsoft Visual FoxPro
Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Query execution failed for data set 'DataSet1'.
(rsErrorExecutingCommand) Get Online Help
a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
file \\ecengds001\connections\data\service.dbf.
Connection String: Provider=VFPOLEDB.1;Data
Source=\\eukfs01\mis_deve\andersonanalysis\data\;Collating Sequence=MACHINE
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
a.. Invalid path or file name.
Change to use credentials when connecting to datasource. (my user ID and
password)
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
a.. Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done.
Change to also impersonate user in Windows after connection.
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot impersonate user for data source 'DataSource1'.
(rsErrorImpersonatingUser) Get Online Help
a.. Specified method is not supported.
Remember, these work just fine when Report Manager is accessed from
EUK01314.
They do not work if Report Manager is accessed from another machine.
--
PAulHi PAul :-)
I think checking the Deleted box corresponds to SET DELETED ON which
evaluates to DELETED=YES in the connection string so be sure to verify that
you're getting what you want. Sorry I can't help on the ReportingSvcs stuff.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
"PAul Maskens" <pmaskens@.mvps.org> wrote in message
news:efE5woQwEHA.3872@.TK2MSFTNGP11.phx.gbl...
> Connection string: Driver={Microsoft Visual FoxPro
> Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO|||You are using SP1, right? This looks similar to an issue that we had with
Access databases (MDBs) on remote shares. Is the FoxPro database on the same
machine as the Report Server? At one point, we were incorrectly adding an
Integrated Security property to the connection string but this should have
been fixed.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"PAul Maskens" <pmaskens@.mvps.org> wrote in message
news:efE5woQwEHA.3872@.TK2MSFTNGP11.phx.gbl...
>I have a test system setup in Reading.
> SQL Server is on machine EUK01314
> IIS 5 also is on machine EUK01314
> Reporting services are installed on machine EUK01314
> Visual Studo is on machine EUK01314
> I can create reports that access SQL server data, or via ODBC, or via
> OLEDB to SQL server on EUK01314.
> I can use those reports from our Terminal Server, no problem.
> I can create reports that access Oracle data, via ODBC, or via OLEDB to
> Oracle on a server in Belgim..
> I can use those reports from our Terminal Server, no problem.
> I draw a total blank accessing Visual FoxPro data.
> I can create reports that access VFP data, via ODBC or OLEDB.
> Those reports work on EUK01314 in Visual Studio.
> Those reports work on EUK01314 in IE via Report Manager.
> So why on earth (or any other planet) don't they work on any other machine
> ?
> Connection string: Driver={Microsoft Visual FoxPro
> Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
> file \\ecengds001\connections\data\connrdp.dbc. ERROR [IM006]
> [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR
> [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the
> version of ODBC behavior that the application requested (see
> SQLSetEnvAttr).
> Connection string: Driver={Microsoft Visual FoxPro
> Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Query execution failed for data set 'DataSet1'.
> (rsErrorExecutingCommand) Get Online Help
> a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
> file \\ecengds001\connections\data\service.dbf.
> Connection String: Provider=VFPOLEDB.1;Data
> Source=\\eukfs01\mis_deve\andersonanalysis\data\;Collating
> Sequence=MACHINE
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> a.. Invalid path or file name.
> Change to use credentials when connecting to datasource. (my user ID and
> password)
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> a.. Multiple-step OLE DB operation generated errors. Check each OLE
> DB status value, if available. No work was done.
> Change to also impersonate user in Windows after connection.
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot impersonate user for data source 'DataSource1'.
> (rsErrorImpersonatingUser) Get Online Help
> a.. Specified method is not supported.
> Remember, these work just fine when Report Manager is accessed from
> EUK01314.
> They do not work if Report Manager is accessed from another machine.
> --
> PAul
>|||Thanks Brian.
Sorry for the delay, I've been away in Utrecht.
I started out with the evaluation edition, then installed the SP1 download
onto that.
I had no errors reported during the installation of SP1, so I assume it
really completed OK.
How can I find out what the connection string being used is?
I know what I typed into the Report Manager, but you're implying that
something else is actually sent.
If there's a way to debug this, I'd like to get to the bottom of it.|||Hmm. I'm not sure there is a trace for VFP. Is it OLE DB or ODBC? For SP1,
the string should be the same (we don't add the Integrated Security flag for
other providers). You can make sure SP1 was successful by looking at the
version under http://server/reportserver.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"PAul Maskens" <pmaskens@.mvps.org> wrote in message
news:OZUD5Xx0EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Thanks Brian.
> Sorry for the delay, I've been away in Utrecht.
> I started out with the evaluation edition, then installed the SP1 download
> onto that.
> I had no errors reported during the installation of SP1, so I assume it
> really completed OK.
> How can I find out what the connection string being used is?
> I know what I typed into the Report Manager, but you're implying that
> something else is actually sent.
> If there's a way to debug this, I'd like to get to the bottom of it.
>|||Sorry for the delay, I've been dragged onto a BizTalk project for a while.
Microsoft SQL Server Reporting Services Version 8.00.878.00

Errorlog File The system cannot find the path specified

I have a cluster SQL Server 2000 database with Windows 2003 server operating
system. Periodically I receive the error listed below. The database is
functioning properly when I received this error message.
Please help me determine why this error occurs periodically.
Thanks,
initerrlog: Could not open error log file 'F=:\LOG\ERRORLOG'. Operating
system error = 3(The system cannot find the path specified.).
Hi,
just go that path and see is there any error log file or not
if not then create a error logfile.
U did not mentioned from where does this error occurs.
thanx
from
killer

Errorlog File The system cannot find the path specified

I have a cluster SQL Server 2000 database with Windows 2003 server operating
system. Periodically I receive the error listed below. The database is
functioning properly when I received this error message.
Please help me determine why this error occurs periodically.
Thanks,
initerrlog: Could not open error log file 'F=:\LOG\ERRORLOG'. Operating
system error = 3(The system cannot find the path specified.).Hi,
just go that path and see is there any error log file or not
if not then create a error logfile.
U did not mentioned from where does this error occurs.
thanx
from
killer

Errorlog File The system cannot find the path specified

I have a cluster SQL Server 2000 database with Windows 2003 server operating
system. Periodically I receive the error listed below. The database is
functioning properly when I received this error message.
Please help me determine why this error occurs periodically.
Thanks,
initerrlog: Could not open error log file 'F=:\LOG\ERRORLOG'. Operating
system error = 3(The system cannot find the path specified.).Hi,
just go that path and see is there any error log file or not
if not then create a error logfile.
U did not mentioned from where does this error occurs.
thanx
from
killer

Error2Text is not a member of System.Data.SqlClient.SqlParameter

Error 2 'Text' is not a member of 'System.Data.SqlClient.SqlParameter'.

I think this error has something to do with the lack of an Import command, anyone point me in the right direction?

sorry, I've decided to upload all the code of default.aspx.vb...I'm trying to make a mailing list sign up. So member can add their name and email for a monthly newsletter. I'm getting three errors, the one posted above on each of the three text boxes. what do I do?

Thanks very much

Partial Class _Default
Inherits System.Web.UI.Page

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles AddButton.Click

Dim connect As String
connect = "data source='.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True'"
Dim sqlconnect As New System.Data.SqlClient.SqlConnection(connect)
Dim command As String

command = "insert into DataForm values(@.firstname,@.lastname,@.email)"
Dim sqlcommand As New System.Data.SqlClient.SqlCommand

sqlcommand.CommandText = command
sqlcommand.Connection = sqlconnect

Dim firstname As New System.Data.SqlClient.SqlParameter()

firstname.ParameterName = "@.firstname"
firstname.Value = firstname.Text
firstname.SqlDbType = System.Data.SqlDbType.VarChar
sqlcommand.Parameters.Add(firstname)

Dim lastname As New System.Data.SqlClient.SqlParameter()

lastname.ParameterName = "@.lastname"
lastname.Value = lastname.Text
lastname.SqlDbType = System.Data.SqlDbType.VarChar
sqlcommand.Parameters.Add(lastname)

Dim email As New System.Data.SqlClient.SqlParameter()

email.ParameterName = "@.email"
email.Value = email.Text
email.SqlDbType = System.Data.SqlDbType.VarChar
sqlcommand.Parameters.Add(email)

sqlconnect.Open()
sqlcommand.ExecuteNonQuery()
sqlconnect.Close()

End Sub

Protected Sub SqlDataSource1_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles SqlDataSource1.Selecting

End Sub

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

End Sub

Protected Sub AddButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles AddButton.Click

End Sub
End Class

|||

Hi,

I think you need to start naming your objects a bit better, seems to me that both your textbox and your SqlParameter have the same name(e.g. firstname, lastname)

I'm pretty sure that's the source of your problems. Try renaming either the textbox control or the SqlParameter (or both) to like txtFirstname and parFirstname.

Good Luck,

Tim Lensen

|||

thanks for the reply I'll give it a go and get back shortly!

Thanks!

-Ian

|||thanks that solved my problem!

Error18025:xp_test_mapi_profile failed with mail error0x80040111

Hi,

I configured the Sql server agent to start with local system and made a profile in intenet mail as SQLMail (Did not used Outlook or Excahnge Server used ar inbox on desktop (Windows messaging system) and internet mail, sendmail which we are having in house), When I tried to Configure SQL Mail for sql server and test , it is ginving the following error.

Error18025:xp_test_mail_profile failed with mail error 0x80040111

:mad:Hello,

i have the same Problemes, how you described it.

Did you start the mail Session?

Have a look on this:
USE master
EXEC xp_startmail

Please enter this brackets in Sql Query and start them.

My Problems already exists. I have problems in sending an e-mail if a error occurs by excuting jobs.

Bye
Harald Bothner|||Ok fellows...

There goes the answers to both of you.

1- Error18025:xp_test_mapi_profile failed with mail error0x80040111

The SQL Server relies in the MAPI libraries to send email messages. Unfortunately, it works at its best allied with Exchange, wich you seem to do not have. But it also works with a pop3 box, leaving the inconvenient need of requiring an Outlook open to get and send messages, and you would have to manage it manually.

Try to use Exchange. If you cant, try using CDONTS. Take a look at the link bellow:
http://support.microsoft.com/default.aspx?scid=kb;en-us;312839

2- mail problems by using sql server

It seems to me that you have not configured the SQL Mail Agent, wich is used by the SQL Server Agent to send notifications about alerts or job status etc.
Take a look at the properties of your SQL Server Agent and see if the email profile is set properly. If its not, just set it and then restart the SQL Server Agent and youre done.

ERROR: There is no data for the field at position 20

This error is displaying in the log file just prior to this entry:
ERROR: Internal error: System.Web.HttpException: Cannot redirect after HTTP
headers have been sent.
The report is being called and displayed using the out of the box Report
Manager with all current updates. It is a periodic problem with the
user-facing error displaying smack dab in the middle of the page in a middle
column of the report.
Can anyone provide any help in resolving this intermittent issue?I had the same problem.
We are using an alias for our server name and the following file was causing
it to redirect in the background to the real server name which was causing
authentication to fail especially through the proxies.
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\rswebapplication.config
hth
Dave
"ToxicDice" wrote:
> This error is displaying in the log file just prior to this entry:
> ERROR: Internal error: System.Web.HttpException: Cannot redirect after HTTP
> headers have been sent.
> The report is being called and displayed using the out of the box Report
> Manager with all current updates. It is a periodic problem with the
> user-facing error displaying smack dab in the middle of the page in a middle
> column of the report.
> Can anyone provide any help in resolving this intermittent issue?|||Thanks Dave. We in fact are aliasing the site and that config file does have
the real name. I'll change it to the alias and see if we still encounter the
problem. Thanks for the help!

Error: The type or namespace name DataReader could not be found

In my DAL:

using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public DataReader getPersonList2() {
using (SqlConnection conn = getConnection())
{
SqlCommand cmd = new SqlCommand("PERSON_SP_getPersonList", conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
return cmd.ExecuteReader();
}
}

In my BLL:

using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

DAL d = new DAL();

public DataReader getPersonList2(){
return d.getPersonList2();
}

I get the following error in my BLL:

Compiler Error Message:CS0246: The type or namespace name 'DataReader' could not be found (are you missing a using directive or an assembly reference?)

Source Error:

Line 34: }
Line 35:
Line 36: public DataReader getPersonList2(){
Line 37: return d.getPersonList2();
Line 38: }

Source File: c:\Inetpub\wwwroot\study\App_Code\BLL.cs Line: 36

Just wondering if someone could tell me why this is happening? I have the same namespaces that I have in the DAL in my BLL.

Puzzled.That should likely be SqlDataReader, not DataReader.|||public SqlDataReader getOUDetails(int SMU_Id) { SqlDataReader dr; string Qry = ""; con.Open(); cmd1 = new SqlCommand(Qry, con); return cmd.ExecuteReader(); cmd.Dispose(); con.Close(); }try do this way

Error: System.Runtime.InteropServices.COMException ...

Error: System.Runtime.InteropServices.COMException (0x80040428): Exception from HRESULT: 0x80040428 at DTS.PackageClass.Execute() at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()

Can anyone tell what caused this error when I tried to run the DTS package from my SSIS package ?

Thanks.

Steve

I had the same problem....drove me batty. Packages run fine using Execute Package utility in SSMS - but fail when running as a scheduled job, or called from within a Stored Procedure - failed every time.

I found my particular issue was not permission, per say, but rather the Exception file, I was referencing in the Data Driven Query task - which kept failing. Once I removed the Exception File, everything runs fine.

|||

I have had a similar problem running a SQL2000 DTS job from within an SSIS package. The strange thing I found that on the production server, it would readily run the job, yet a similarly created DTS on the development servers failed.

What was the "Exception file" that you had to remove?

|||

If you trust the internal logic of your package, then an error condition - especially from an Agent job - usually points to the package's interaction with external resources; in particular, to permissions issues. That's probably why no longer trying to write to an exception file solved the problem for the other gentleman. Check the package's use of database connections and file system resources, and determine whether the account under which it's executing does indeed have the required rights to connect, to read and write, etc.

Here's the Agent Job kb article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;918760

-Doug

|||

I have rewrote the DTS package into a stored procedure that

1) Truncates the target tables

2) Copy the data from the source on another database to the target tables

3) Backs up the target database.

Now the account that would not run the DTS package runs a stored procedure successfully!

Error: System.Runtime.InteropServices.COMException ...

Error: System.Runtime.InteropServices.COMException (0x80040428): Exception from HRESULT: 0x80040428 at DTS.PackageClass.Execute() at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()

Can anyone tell what caused this error when I tried to run the DTS package from my SSIS package ?

Thanks.

Steve

I had the same problem....drove me batty. Packages run fine using Execute Package utility in SSMS - but fail when running as a scheduled job, or called from within a Stored Procedure - failed every time.

I found my particular issue was not permission, per say, but rather the Exception file, I was referencing in the Data Driven Query task - which kept failing. Once I removed the Exception File, everything runs fine.

|||

I have had a similar problem running a SQL2000 DTS job from within an SSIS package. The strange thing I found that on the production server, it would readily run the job, yet a similarly created DTS on the development servers failed.

What was the "Exception file" that you had to remove?

|||

If you trust the internal logic of your package, then an error condition - especially from an Agent job - usually points to the package's interaction with external resources; in particular, to permissions issues. That's probably why no longer trying to write to an exception file solved the problem for the other gentleman. Check the package's use of database connections and file system resources, and determine whether the account under which it's executing does indeed have the required rights to connect, to read and write, etc.

Here's the Agent Job kb article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;918760

-Doug

|||

I have rewrote the DTS package into a stored procedure that

1) Truncates the target tables

2) Copy the data from the source on another database to the target tables

3) Backs up the target database.

Now the account that would not run the DTS package runs a stored procedure successfully!

Error: System.Runtime.InteropServices.COMException ...

Error: System.Runtime.InteropServices.COMException (0x80040428): Exception from HRESULT: 0x80040428 at DTS.PackageClass.Execute() at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()

Can anyone tell what caused this error when I tried to run the DTS package from my SSIS package ?

Thanks.

Steve

I had the same problem....drove me batty. Packages run fine using Execute Package utility in SSMS - but fail when running as a scheduled job, or called from within a Stored Procedure - failed every time.

I found my particular issue was not permission, per say, but rather the Exception file, I was referencing in the Data Driven Query task - which kept failing. Once I removed the Exception File, everything runs fine.

|||

I have had a similar problem running a SQL2000 DTS job from within an SSIS package. The strange thing I found that on the production server, it would readily run the job, yet a similarly created DTS on the development servers failed.

What was the "Exception file" that you had to remove?

|||

If you trust the internal logic of your package, then an error condition - especially from an Agent job - usually points to the package's interaction with external resources; in particular, to permissions issues. That's probably why no longer trying to write to an exception file solved the problem for the other gentleman. Check the package's use of database connections and file system resources, and determine whether the account under which it's executing does indeed have the required rights to connect, to read and write, etc.

Here's the Agent Job kb article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;918760

-Doug

|||

I have rewrote the DTS package into a stored procedure that

1) Truncates the target tables

2) Copy the data from the source on another database to the target tables

3) Backs up the target database.

Now the account that would not run the DTS package runs a stored procedure successfully!

Error: System.Runtime.InteropServices.COMException ...

Error: System.Runtime.InteropServices.COMException (0x80040428): Exception from HRESULT: 0x80040428 at DTS.PackageClass.Execute() at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()

Can anyone tell what caused this error when I tried to run the DTS package from my SSIS package ?

Thanks.

Steve

I had the same problem....drove me batty. Packages run fine using Execute Package utility in SSMS - but fail when running as a scheduled job, or called from within a Stored Procedure - failed every time.

I found my particular issue was not permission, per say, but rather the Exception file, I was referencing in the Data Driven Query task - which kept failing. Once I removed the Exception File, everything runs fine.

|||

I have had a similar problem running a SQL2000 DTS job from within an SSIS package. The strange thing I found that on the production server, it would readily run the job, yet a similarly created DTS on the development servers failed.

What was the "Exception file" that you had to remove?

|||

If you trust the internal logic of your package, then an error condition - especially from an Agent job - usually points to the package's interaction with external resources; in particular, to permissions issues. That's probably why no longer trying to write to an exception file solved the problem for the other gentleman. Check the package's use of database connections and file system resources, and determine whether the account under which it's executing does indeed have the required rights to connect, to read and write, etc.

Here's the Agent Job kb article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;918760

-Doug

|||

I have rewrote the DTS package into a stored procedure that

1) Truncates the target tables

2) Copy the data from the source on another database to the target tables

3) Backs up the target database.

Now the account that would not run the DTS package runs a stored procedure successfully!

ERROR: System.OutOfMemoryException

How should I resolve the following error message when running report?
ERROR:
Exception of type 'System.OutOfMemoryException' was thrownBuy more RAM ¬¬
No, I'm kidding. Well, what are you exactly doing? Are you running a report
that accesses many tables or tables with many rows?|||What a great sense of humor!
However, I am just running a report via Report Manager.
http://reportserv/reports
TABLE ROWS below:
6,683
QUERY below:
SELECT Lists_Members.LSTM_Lists_ID, Lists_Members.LSTM_Group,
List_Codes_Table.LIST_Name, Lists_Members.LSTM_Name_ID
FROM Lists_Members AS Lists_Members INNER JOIN
List_Codes_Table AS List_Codes_Table ON
Lists_Members.LSTM_Lists_ID = List_Codes_Table.LIST_Id
GROUP BY Lists_Members.LSTM_Lists_ID, Lists_Members.LSTM_Group,
List_Codes_Table.LIST_Name, Lists_Members.LSTM_Name_ID
ORDER BY Lists_Members.LSTM_Lists_ID, Lists_Members.LSTM_Group
"F. Dwarf" wrote:
> Buy more RAM ¬¬
> No, I'm kidding. Well, what are you exactly doing? Are you running a report
> that accesses many tables or tables with many rows?|||Well, I'm still puzzled. I don't figure out what could be the problem