APT_FileExportOperator unable to export record: Record large

dsisbank · Post by **dsisbank** » Tue Mar 27, 2007 4:42 am

I have oracle target stage and use load medhod.I want to fill timestamp column with current timestamp.In transformer stage ,i use CurrentTimestamp function but i take warnings like this and no load data.

Oracle_Enterprise_50,1: APT_FileExportOperator unable to export record: Record larger than fixed-length record stream [impexp/recordstream.C:1362]

this column in oracle has timestamp data type and also in DS.

kumar_s · Post by **kumar_s** » Tue Mar 27, 2007 5:41 am

The function that you use will give the current time stamp in internal Datastage format. But you need to pass the value into to Oracle to its requried value. You need to use TO_DATE() function to convert it into oracle format while loading it.

dsisbank · Post by **dsisbank** » Tue Mar 27, 2007 8:25 am

But how can i use to_date function for load option?
I use load medhod for oracle stage.There is no function like to_date in transformer stage or i havent seen yet.

DSguru2B · Post by **DSguru2B** » Tue Mar 27, 2007 8:44 am

What if you load it as varchar? Run a test on a table using the load method which does not have timestamp in it. Is it really a timestamp issue? All that the error says is that the record is larger than the fixed length. We dont know for sure it really is a timestamp issue.

dsisbank · Post by **dsisbank** » Wed Mar 28, 2007 12:46 am

if target column is varchar,it's not a problem.it works fine and when i look data,data format is ok.But i cant change target column from timestamp to varchar because Business objects' reports will be effected.

dsisbank · Post by **dsisbank** » Wed Mar 28, 2007 1:04 am

when i chose upsert medhod ,it works fine.But i must load medhod because of volume of data

dsisbank · Post by **dsisbank** » Wed Mar 28, 2007 2:05 am

I solved this problem using OCI LOAD stage.But souce data is 30.03.2005 23:57:32.962000 but after load in target it seems 30.03.2005 23:57:32.000000.

How can i solve?

DSguru2B · Post by **DSguru2B** » Wed Mar 28, 2007 7:03 am

dsisbank wrote:if target column is varchar,it's not a problem.it works fine and when i look data,data format is ok.But i cant change target column from timestamp to varchar because Business objects' reports will be effected.

Your change will only be at the datastage level. Not at the database level. How will that effect BO again? BO has no visibility to DataStage metadata.

dsisbank · Post by **dsisbank** » Thu Mar 29, 2007 12:56 am

I mean db level and also i solved load problem using OCI bulk loader.Bu i havent solved micrasecond problem.I search forum but i couldnt find any solution.there are many solution recomended but they have no affect.

My source is 30.03.2005 23:57:32.150000 but i load this data like 30.03.2005 23:57:32.000000

microseccond is missing

Do you know how can i solve this?

ray.wurlod · Post by **ray.wurlod** » Thu Mar 29, 2007 5:08 am

Is the target column TIMESTAMP(6) ? Does the date format string for this column in your record schema include ".6" at the end?

dsisbank · Post by **dsisbank** » Thu Mar 29, 2007 6:32 am

Yes target column is timestamp(6) and timestamp format in DS is %yyyy-%mm-%dd %hh:%nn:%ss.6
i take data from DB2 both varchar and timestamp,When i use timestamp,it doesnt work but i use varchar it works but milisecond is missing.

as i read Parallel Job Developers Guide page 13-7,DS doesnt support milisecond

kumar_s · Post by **kumar_s** » Mon Apr 02, 2007 4:05 am

For this case, you can change the source to Char/varcahr using To_Char function and convert it back to Date with Timestamp with to_date function in the load stage. But you will need to use User Defined SQL for that.