Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 SQL ERROR "SQLState <22008>"

Author  Topic 

kan1969
Starting Member

8 Posts

Posted - 2013-01-09 : 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

52326 Posts

Posted - 2013-01-09 : 03:05:51
see

http://www.codeproject.com/Articles/21371/SQL-Server-Profiler-Step-by-Step

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

kan1969
Starting Member

8 Posts

Posted - 2013-01-09 : 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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-09 : 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/

Go to Top of Page

kan1969
Starting Member

8 Posts

Posted - 2013-01-09 : 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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-09 : 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/

Go to Top of Page

kan1969
Starting Member

8 Posts

Posted - 2013-01-10 : 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
Go to Top of Page

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-01-10 : 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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-10 : 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/

Go to Top of Page

kan1969
Starting Member

8 Posts

Posted - 2013-01-20 : 23:32:04
Thank you my friend. I did that and the tracer went fine.

thanks again...

With Kind Regards,
Kannan
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-21 : 01:51:36
welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -