Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Failed to retrieve data from the database. Post Reply Post New Topic
Author Message
ckreds
Newbie
Newbie


Joined: 24 Sep 2007
Location: Malaysia
Online Status: Offline
Posts: 16
Quote ckreds Replybullet Topic: Failed to retrieve data from the database.
    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
IP IP Logged
wattsjr
Groupie
Groupie
Avatar

Joined: 25 Jun 2007
Location: United States
Online Status: Offline
Posts: 51
Quote wattsjr Replybullet 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
IP IP Logged
ckreds
Newbie
Newbie


Joined: 24 Sep 2007
Location: Malaysia
Online Status: Offline
Posts: 16
Quote ckreds Replybullet Posted: 08 Oct 2007 at 7:07pm
thks guy..
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.