Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
Bulk Load
 Login/Join
 
Member
posted
Does anybody have any tips on using bulk load and how to get the best out of it.

We are using Data Migrator v533.

It is working okay for some jobs but for others I am getting errors as bellow:

Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation
SQLState = 22001, NativeError = 0

and

SQLState = 22005, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Invalid character value for cast spec
ification

They work fine if I set it back to insert records from memory.

Many thanks
 
Posts: 17 | Registered: August 03, 2004Reply With QuoteReport This Post
Member
posted Hide Post
I have tracked down the cause:

It is only causing a problem if I am using bulk load where the job has a Date in.

I think it is something to do with the format of the date when it is being passed to the SQL server.
 
Posts: 17 | Registered: August 03, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
We just had the same problem in 5.2.8. It was patched in 5.2.9. It had been working fine in 5.2.3, so there were obviously some regression issues.


------------------------------------------------------------------------
PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
 
Posts: 210 | Location: Ottawa | Registered: November 03, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.