SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 SQL ERROR "SQLState <22008>"
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kan1969
Starting Member

India
8 Posts

Posted - 01/09/2013 :  02:01:00  Show Profile  Reply with Quote

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
52325 Posts

Posted - 01/09/2013 :  03:05:51  Show Profile  Reply with Quote
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

India
8 Posts

Posted - 01/09/2013 :  06:12:17  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 01/09/2013 :  06:25:56  Show Profile  Reply with Quote
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

India
8 Posts

Posted - 01/09/2013 :  08:26:31  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 01/09/2013 :  22:53:29  Show Profile  Reply with Quote
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

India
8 Posts

Posted - 01/10/2013 :  04:17:46  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

India
2218 Posts

Posted - 01/10/2013 :  06:25:34  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 01/10/2013 :  06:30:26  Show Profile  Reply with Quote
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

India
8 Posts

Posted - 01/20/2013 :  23:32:04  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 01/21/2013 :  01:51:36  Show Profile  Reply with Quote
welcome

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

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000