Print Page | Close Window

Failed to retrieve data from the database.

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1464
Printed Date: 23 Apr 2024 at 4:06pm


Topic: Failed to retrieve data from the database.
Posted By: ckreds
Subject: Failed to retrieve data from the database.
Date Posted: 08 Oct 2007 at 12:49am
Im getting above error code when tried to preview the report. The full message as below:
Failed to retrieve data from the database.
Details: ORA-01843: not a valid month
[database Vendor Code: 1843]
 
Anyone can help?
Thks


Replies:
Posted By: wattsjr
Date Posted: 08 Oct 2007 at 8:28am
Hi ckreds,
 
It looks like you have specified a month value that Oracle doesn't recognize.  You might want to verify that your selection criteria is using the right date format.
 
Take a look at the following URLs for a better definition of the error code.
 
http://www.dba-oracle.com/t_ora_01843_not_a_valid_month.htm

http://www.techonthenet.com/oracle/errors/ora01843.php

Hope this helps.
Regards,


-------------
-jrw

Posted By: ckreds
Date Posted: 08 Oct 2007 at 7:07pm
thks guy..


Print Page | Close Window