Solved

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

Posted on 2000-04-04
5
464 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
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.
0
 
LVL 2

Expert Comment

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

Expert Comment

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

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

Expert Comment

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


#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
ID: 2828034
I guess r2bacca is not coming back...

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

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
WSUS Client Issues 52 2,418
Coldfusion Datefield problem 2 124
Asp.net plan security, reliable, stable 2 135
Use System DSN 6 90
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…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

685 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