| Author |
 Topic  |
|
|
kan1969
Starting Member
India
8 Posts |
 Posted - 01/09/2013 : 02:01:00
|
Hi Experts,
I am new to this forum.
I am right now working on SAP Data Services whose Source System is R3 and Target System is MS SQL 2005.
As I was loading the data, I came across an error:
"|Sub data flow DF_ProfitCenterFactOldGLActual_SAP_1|Loader DXFER_R3_ProfCntrFactActual_DT__15_337_141_1
ODBC data source <SSTL-DEVDB\DEVDB2005> warning message for operation <bcp_sendrow>:
<[Microsoft][ODBC SQL ServerDriver]Datetime field overflow>, SQLState <22008>."
"|Sub data flow DF_ProfitCenterFactOldGLActual_SAP_1|Loader DXFER_R3_ProfCntrFactActual_DT__15_337_141_1
Bulk loader API has exceeded the maximum error count <0>."
"|Dataflow DF_ProfitCenterFactOldGLActual_SAP|Pipe Listener for DF_ProfitCenterFactOldGLActual_SAP_1
Named pipe error occurred: <The pipe has been ended."
I understand it is something to do with some erroneous source data. Since the source data is very huge, I would like
to run a trace on MS SQL to find out which data is the erroneous one.
So, I would like to know how to run a trace on the MS SQL 2005 database table and the steps to do it.
Kindly guide me.
Thanks,
With Kind Regards,
Kannan |
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48076 Posts |
|
|
kan1969
Starting Member
India
8 Posts |
Posted - 01/09/2013 : 06:12:17
|
Hi Visakh16,
I thank you for your kind reply. It is really helpful. I just want to know if it is possible to run the trace for exactly two databases which is my need.
Thank you once again.
With Kind Regards,
Kannan |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48076 Posts |
Posted - 01/09/2013 : 06:25:56
|
yep...its possible. just add databases in filters and it will only trace activities in them
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
kan1969
Starting Member
India
8 Posts |
Posted - 01/09/2013 : 08:26:31
|
Thanks again - I checked it, but there is no specification for databases in filters. Can you please throw more light on it.
Thanks again,
Kannan
With Kind Regards,
Kannan |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48076 Posts |
Posted - 01/09/2013 : 22:53:29
|
quote:
Originally posted by kan1969
Thanks again - I checked it, but there is no specification for databases in filters. Can you please throw more light on it.
Thanks again,
Kannan
With Kind Regards,
Kannan
which version are you using?
anyways try below
1. Click the "Events Selection" tab
2. Click the "Column Filters" button
3. Select "DatabaseName", click the plus next to Like in the right-hand pane, and type your database name.
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
kan1969
Starting Member
India
8 Posts |
Posted - 01/10/2013 : 04:17:46
|
Thank you once again,
We are using MS SQL 2005 version. Is there any way to change the default location from C: drive to D: drive. The trace file takes lot of space in the C: drive.
Thanks,
With kind regards,
Kannan
With Kind Regards,
Kannan |
|
|
|
bandi
Flowing Fount of Yak Knowledge
India
1711 Posts |
Posted - 01/10/2013 : 06:25:34
|
quote:
Originally posted by kan1969
Thank you once again,
We are using MS SQL 2005 version. Is there any way to change the default location from C: drive to D: drive. The trace file takes lot of space in the C: drive.
In Event Selection Tab, check the Save to a File option --> choose D:\ location
--
Chandu |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48076 Posts |
Posted - 01/10/2013 : 06:30:26
|
also make sure Start tracing immediately after making connection checkbox is disabled otherwise Trace Properties window wont appear
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
kan1969
Starting Member
India
8 Posts |
Posted - 01/20/2013 : 23:32:04
|
Thank you my friend. I did that and the tracer went fine.
thanks again...
With Kind Regards,
Kannan |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48076 Posts |
Posted - 01/21/2013 : 01:51:36
|
welcome
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
| |
Topic |
|
SQL ERROR "SQLState <22008>"
