HELP!! Solaris, Oracle 8, CFServer, Client Tables

Posted on 2000-04-04
Last Modified: 2013-12-24
We are currently moving over from session.variables to client.variables because we are getting into load balancing. So we set up CF administrator to build the client storage tables... easy enough right.

Well now we have an Oracle Error spitting out:

Error Diagnostic Information
Oracle Error Code = 1841

ORA-01841: (full) year must be between -4713 and +9999, and not be 0

We can't get into CF administrator to try and fix this error and we also can't find the tables in Oracle.

Has anyone seen/heard/or fixed this before?
Question by:r2bacca
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2

Expert Comment

ID: 2685076
Sounds to me like you must have changed something else... off of the top of my head if not tho...

The only other thing might be how your putting the date back into oracle??

Check this and let me know.

Expert Comment

ID: 2740821
Any chance of seeing some cfcode and db values?

Expert Comment

ID: 2740824
I don't actually know anything about Oracle - but I think this document is suggesting that an 1841 error can be year 2000 related (or maybe not).

Expert Comment

ID: 2740942
Your right it sounds like a y2k issue.  However it also sounds like if you insert a date with a 4 digit year this should fix this...

give my your sql code for your insert...

I would replace the date with

<cfset datevar=#now()#>


I will try and remember to test this at work myself  because I am in a Oracle enviroment at work now.


Accepted Solution

nathans earned 75 total points
ID: 2828034
I guess r2bacca is not coming back...

If your there let me know if my answer worked.

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A web service ( is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question