Solved

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

Posted on 2000-04-04
5
429 Views
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?
0
Comment
Question by:r2bacca
  • 3
  • 2
5 Comments
 
LVL 5

Expert Comment

by:nathans
Comment Utility
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.
0
 
LVL 2

Expert Comment

by:paulkd
Comment Utility
Any chance of seeing some cfcode and db values?
0
 
LVL 2

Expert Comment

by:paulkd
Comment Utility
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).

http://www.oracle.fr/an2000/patchy2k_11.html
0
 
LVL 5

Expert Comment

by:nathans
Comment Utility
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()#>


#dateformat("#datevar#",'dd/mm/yyyy')#

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


0
 
LVL 5

Accepted Solution

by:
nathans earned 75 total points
Comment Utility
I guess r2bacca is not coming back...

If your there let me know if my answer worked.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now