Date conversion cache disabled due to overflow (default size
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Tue Apr 24, 2007 12:39 am
Date conversion cache disabled due to overflow (default size
Hi,
I am loading 6 million records from sequential file to Oracle .
My Job gets aborted at 3 million.
The error message is "Date conversion cache disabled due to overflow (default size: 1000)".
Please let me know how to handle this .
Regards
I am loading 6 million records from sequential file to Oracle .
My Job gets aborted at 3 million.
The error message is "Date conversion cache disabled due to overflow (default size: 1000)".
Please let me know how to handle this .
Regards
-
- Participant
- Posts: 21
- Joined: Tue Apr 24, 2007 12:39 am
Giving more details below
I have one Date column in my Job.The input date value in the txt file is like 2007-12-31.I am using StringToDate function to convert this into date format.The input txt file has 6 million records.
The Job gets aborted at 3 million throwing error as
"Date conversion cache disabled due to overflow (default size: 1000)".
Please help.
I have one Date column in my Job.The input date value in the txt file is like 2007-12-31.I am using StringToDate function to convert this into date format.The input txt file has 6 million records.
The Job gets aborted at 3 million throwing error as
"Date conversion cache disabled due to overflow (default size: 1000)".
Please help.
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Re: Date conversion cache disabled due to overflow (default
You are using sqlldr for loading and this is an error thrown by sqlldr.
Shadab_Farooque wrote:The error message is "Date conversion cache disabled due to overflow (default size: 1000)".
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Participant
- Posts: 21
- Joined: Tue Apr 24, 2007 12:39 am
Re: Date conversion cache disabled due to overflow (default
I am Using Oracle Enterprise for loading the data.
It works as sqlloader in background.
How to increase the date cache and Errors allowed parameters in Datastage 7.5.1(PX)
It works as sqlloader in background.
How to increase the date cache and Errors allowed parameters in Datastage 7.5.1(PX)
Shadab Farooque
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Date cache is set to 1000 by default, you may want to try either increasing the size of the date cache or disabling the cache by specifying DATE_CACHE=0. Consider adding/changing your options in $APT_ORACLE_LOAD OPTIONS to match your requirement.
Date cache:
Max Size: 1000
Max Size is the maximum number of entries in the cache. By default, the date cache size is 1,000 elements, but it can be changed with the SQL*Loader DATE_CACHE command-line parameter.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Participant
- Posts: 21
- Joined: Tue Apr 24, 2007 12:39 am
-
- Participant
- Posts: 63
- Joined: Mon Oct 20, 2008 12:01 am
- Location: Malaysia