One for the MVP's

Has anyone seen this kind of error.
I have a datawarehouse that I have to load and optomize
each morning before everyone gets in. The last few days
the load has failed due to not being able to update the
statistics on the tables. THey error out and here is what
I ma getting in the log. I have researched and our
networking group had a tech come in and upgrade the
controllers on the cluster where the db resides this
weekend. I believe what I am getting is a controller that
has trouble writing or disks that are not able to talk
well with the controller. DBCC checkDB shows that the
system has errors. Last night I ran a repair_fast on the
database in question but now it is accross all databases.
what do you think and have you had this before? thanks in
advance.
SQL Server Assertion: File: <recbase.cpp>, line=1374
Failed Assertion = 'm_nVars > 0'.If I were you, Id be calling PSS. It could be a bug, a corrupt database..
Whatever being the case, your best bet is getting PSS involved at this time.
Hope you have some good backups..
"Scott Dexter" <anonymous@.discussions.microsoft.com> wrote in message
news:01f901c3c59e$e8204740$a401280a@.phx.gbl...
> Has anyone seen this kind of error.
> I have a datawarehouse that I have to load and optomize
> each morning before everyone gets in. The last few days
> the load has failed due to not being able to update the
> statistics on the tables. THey error out and here is what
> I ma getting in the log. I have researched and our
> networking group had a tech come in and upgrade the
> controllers on the cluster where the db resides this
> weekend. I believe what I am getting is a controller that
> has trouble writing or disks that are not able to talk
> well with the controller. DBCC checkDB shows that the
> system has errors. Last night I ran a repair_fast on the
> database in question but now it is accross all databases.
> what do you think and have you had this before? thanks in
> advance.
>
> SQL Server Assertion: File: <recbase.cpp>, line=1374
> Failed Assertion = 'm_nVars > 0'.|||Doessound like hardware corruption. As Hassan states you can contact MS PSS
if you want to be sure andthey can walk thru the issues with you.
--
Andrew J. Kelly SQL MVP
"Scott Dexter" <anonymous@.discussions.microsoft.com> wrote in message
news:01f901c3c59e$e8204740$a401280a@.phx.gbl...
> Has anyone seen this kind of error.
> I have a datawarehouse that I have to load and optomize
> each morning before everyone gets in. The last few days
> the load has failed due to not being able to update the
> statistics on the tables. THey error out and here is what
> I ma getting in the log. I have researched and our
> networking group had a tech come in and upgrade the
> controllers on the cluster where the db resides this
> weekend. I believe what I am getting is a controller that
> has trouble writing or disks that are not able to talk
> well with the controller. DBCC checkDB shows that the
> system has errors. Last night I ran a repair_fast on the
> database in question but now it is accross all databases.
> what do you think and have you had this before? thanks in
> advance.
>
> SQL Server Assertion: File: <recbase.cpp>, line=1374
> Failed Assertion = 'm_nVars > 0'.sql

One dataflow for sevral Oracle Instances ?

Hi,

I designed a dataflow which extracts, transforms and load (the main goals of an ETL ....) data from an Oracle db to an Sql Server 2005 db. The issue is that I would like to run this dataflow on several Oracle instances in a row. This intances are not on the same Oracle Servers. Is there a way to set only one data source for all these intances and to use a loop to execute the dataflow for each?.

Regards

Ayzan

You could place the Data Flow inside a For Each Loop. Select the enumerator best suited to the list of servers you have, and obviously pass this out through a variable(s) so that you can use the specifics in an expression on the Oracle connection.|||

Ok, that's what I tried to do. But how do you pass variables to the Data Source. by editing the XML source ? Do you have any example ?

Regards

Ayzan

|||

You need to pass the current loop value through to the connection, which is used inside the loop. Store it in a variable, then use an expression on the connection string property of the connection, used by the source component in the data flow. This article demonstrates some of the concepts:

Looping over files with the Foreach Loop
(http://www.sqlis.com/default.aspx?55)

|||Right click on your Connection Manager and then Properties. Under the Expressions property click on the Ellipses [...].

In the Property Expressions Editor choose ConnectionString for the

property and then click on the Ellipses [...] next to the expression.

In the expression builder your expression will be similiar to the follwing

"Data Source=" + @.[User::InstanceName] + ";User

ID=MyUser;Provider=OraOLEDB.Oracle.1;Persist Security

Info=True;Password=MyPassword;"

You just need to replace the parts of the connection string that are

applicable to your environment (Instance Variable Name, UserID,

Provider, Password).

This assumes you are using the tnsnames.ora to declare the instances.

Larry Pope|||

Thank you all, that works really fine.

Regards

Ayzan

One dataflow for sevral Oracle Instances ?

Hi,

I designed a dataflow which extracts, transforms and load (the main goals of an ETL ....) data from an Oracle db to an Sql Server 2005 db. The issue is that I would like to run this dataflow on several Oracle instances in a row. This intances are not on the same Oracle Servers. Is there a way to set only one data source for all these intances and to use a loop to execute the dataflow for each?.

Regards

Ayzan

You could place the Data Flow inside a For Each Loop. Select the enumerator best suited to the list of servers you have, and obviously pass this out through a variable(s) so that you can use the specifics in an expression on the Oracle connection.|||

Ok, that's what I tried to do. But how do you pass variables to the Data Source. by editing the XML source ? Do you have any example ?

Regards

Ayzan

|||

You need to pass the current loop value through to the connection, which is used inside the loop. Store it in a variable, then use an expression on the connection string property of the connection, used by the source component in the data flow. This article demonstrates some of the concepts:

Looping over files with the Foreach Loop
(http://www.sqlis.com/default.aspx?55)

|||Right click on your Connection Manager and then Properties. Under the Expressions property click on the Ellipses [...].
In the Property Expressions Editor choose ConnectionString for the property and then click on the Ellipses [...] next to the expression.
In the expression builder your expression will be similiar to the follwing
"Data Source=" + @.[User::InstanceName] + ";User ID=MyUser;Provider=OraOLEDB.Oracle.1;Persist Security Info=True;Password=MyPassword;"
You just need to replace the parts of the connection string that are applicable to your environment (Instance Variable Name, UserID, Provider, Password).
This assumes you are using the tnsnames.ora to declare the instances.
Larry Pope
|||

Thank you all, that works really fine.

Regards

Ayzan

OLE DB drivers and Vista 64 bit

I am trying to load a Fox Pro file which I used to be able to load before I installed 64 bit Vista. I'm using ver 9 of the fox pro driver. I don't know if it's a driver problem or something else I am doing wrong.

Here's the error msg:

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154.

An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

Error: 0xC020801C at Load Country, OLE DB Source [1]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "C:\Users\john.church.LLC\Desktop\MaxMin\AccountingSystem Database\AccountingSystem Database\AccountingSystem.DBC" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

But then it also says something about registering a class. I'm a .net moron so I'm not sure what that means.

Any thoughts?

Thanks.

(Vista 64, SQL Svr 2005 64, visual studio - with all known updates/patches installed)

Hi John,The VFP OLE DB data provider isn't 64-bit compatible.|||"Does Microsoft have a 64 bit driver?" he asked, laughing and shaking his head.|||Not for Visual FoxPro, and there are no plans to create one.|||Kinda what I figured. Now my only decision is whether to go back to Vista 32 or XP.........has MS announced when they're going to cancel Vista yet?