From Hash file to loading Table

parsi_cnu · Post by **parsi_cnu** » Sun Jul 17, 2005 12:54 pm

Hi,
i am storing the snapshot_date in the Hash file and if matches i am getting the snapshot_date but i am getting error ORA-01841: (full) year must be between -4713 and +9999, and not be 0. The same hash file working good in another job but i am getting error in one job. So what should i do shall i had to convert into internal date format and then convert into the orginal oracle date and pass to the target.

Thanks

sri

chulett · Post by **chulett** » Sun Jul 17, 2005 1:02 pm

More information needed.

* What format is the date stored in in the hashed file?
* What format is it in when you send it to Oracle?
* How is it defined in your target - DATE? TIMESTAMP?
* What datatype did you define it as in your job - Date? Timestamp? Varchar? What size?
* What kind of transformations are you doing on it now? Anything?

Not saying this is an all inclusive set of questions, but just trying to give you an idea that more information is needed to do anything other than guess at what you are doing and what an appropriate solution would be. And I'd rather see too much information rather than too little.

parsi_cnu · Post by **parsi_cnu** » Sun Jul 17, 2005 1:41 pm

The date in the hash file is stored in the Timestamp format and i am getting the timestamp format as it is and storing in the oracle table in timestamp format

Thanks
sri

chulett · Post by **chulett** » Sun Jul 17, 2005 3:08 pm

So, is the target an Oracle DATE field? If you treat this as a Timestamp in the job and make sure it looks like YYYY-MM-DD HH24:MI:SS when it gets to Oracle, you should be fine. This also assumes you are using an OCI stage to write to the database, that or the DRS stage set to Oracle.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Sun Jul 17, 2005 3:44 pm

Write the result in a seq file. That will give you an idea of what is being passed into the target.

ray.wurlod · Post by **ray.wurlod** » Mon Jul 18, 2005 12:16 am

You could use the Debugger if they hadn't broken it.

chulett · Post by **chulett** » Mon Jul 18, 2005 6:45 am

Are you saying it's broken, Ray? In what version?

ray.wurlod · Post by **ray.wurlod** » Mon Jul 18, 2005 2:59 pm

7.1, maybe 7.0.x, and still in 7.5x2. You get to the first breakpoint then the job aborts with the message "Debugger client disconnected".

chulett · Post by **chulett** » Mon Jul 18, 2005 3:04 pm

Ok. I get those at times using 7.0.1, typically when I've use a connection for multiple things before trying to debug a job. Usually can be 'worked around' by opening a new Designer session and doing the debugging of the job in isolation.

ray.wurlod · Post by **ray.wurlod** » Mon Jul 18, 2005 3:29 pm

Why should you have to?!! I still claim it's broken.

DSXchange

From Hash file to loading Table

From Hash file to loading Table

additional information about the question