Crystal Reports Failed to retrieve data from the database.

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Failed to retrieve data from the database.

Author	Message
ckreds Newbie Joined: 24 Sep 2007 Location: Malaysia Online Status: Offline Posts: 16	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 Logged

wattsjr Groupie Joined: 25 Jun 2007 Location: United States Online Status: Offline Posts: 51	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 Logged

ckreds Newbie Joined: 24 Sep 2007 Location: Malaysia Online Status: Offline Posts: 16	Posted: 08 Oct 2007 at 7:07pm
	thks guy..
	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.016 seconds.