Toad World® Forums

00.00.0000 00:00 is not a valid date and time error on export dataset


#1

Hi,

When I try and export a results table by clicking the export dataset option after right clicking the results table I get the following error:

00.00.0000 00:00 is not a valid date and time

It started doing it before and I had to uninstall and reinstall to clear it. It has worked fine for a few months but now its back.

Any ideas that avoid the need to go through the trouble of uninstalling all over again?

Adam


#2

Morning Adam,

00.00.0000 00:00 is not a valid date and time It started doing it before

does the grid actually contain a date column? And if so, are any of them
null?

What do you get if you select min(date_column) from (your query here); ?

I can’t see any options to change null dates into all zeros in Toad’s
options, but maybe it’s an artefact of the format you are attempting to
export - what format have you chosen?

Cheers,
Norm. [TeamT]


#3

There are dates in there but none are null and until a couple of days ago I could export fine. This error isn’t just for a certain query on certain tables I cannot export dataset at all, I get the same error on any query on any DB, on any format, to a file and to clipboard.

All I want to do is copy the results to an excel sheet which I can do with cut and paste but it doesn’t copy the column headings, do you know of a work around?

“What do you get if you select min(date_column) from (your query here); ?”

I ran that and got “31/12/2009”

Thanks for taking the time to reply

Adam


#4

Hi Adam,

There are dates in there but none are null and until a couple of days
ago I could export fine.
I presume that if you run a query without dates, then you can export
those just fine?

This error isn’t just for a certain query on
certain tables I cannot export dataset at all,
:frowning:

I get the same error on
any query on any DB, on any format, to a file and to clipboard.
That’s very strange. Is it any query at all, even something simply such
as "select ‘Help me!’ from dual. Or does the query have to include a
date for the above to fail?

“What do you get if you select min(date_column) from (your query
here); ?” I ran that and got “31/12/2009”
Ok, thanks.

Thanks for taking the time to
reply Adam
My pleasure.

I’m wondering now, if this is something to do with a 9i client and a 10g
database (or higher) where there are timestamps involved? Are your date
columns DATE or TIMESTAMP?

Does your client match the database version? Ie, 10g for both or 9i for
both? I’ve had problems with Toad reporting exceptions in one of the 9i
Oracle DLLs when I query DBMS_SCHEDULED_JOBS in a 10g database with a 9i
client.

Toad 10.5 does Unicode, Oracle 9i client doesn’t. Does your database
have a unicode characterset? How about NLS_LANG on the client - does it
match?

More questions that answers I’m afraid, this is quite puzzling.

I don’t suppose spooling the SQL to the screen just before you export
the dataset gives any clues?

Cheers,
Norm. [TeamT]


#5

sorry should have added I’m running Toad for Oracle Base ver: 10.5.0.41 on a PC with Windows 7


#6

Hi,

I’m running 10g DB and client so no issue there.

I tried just selected a column that has no date or time in it and it still gave the same error.

I selected “Spool SQL to screen” ran a very simple query and then export and here is the result:


Session: APPS_DUAL_001@DUAL_ORCL
Timestamp: 10:21:54.722
select id_risk from risk

Session: APPS_DUAL_001@DUAL_ORCL
Timestamp: 10:22:02.326
select 1 from user_snapshots where name = :x
:x(VARCHAR[4],IN/OUT)=‘RISK’

Also here is the data in the error message - I’ve been told to remove the IP addresses from the “Network” section so that is why it is blank.

EurekaLog 6.0.22

Application:

1.1 Start Date : Wed, 22 Dec 2010 08:37:48 +0000
1.2 Name/Description: Toad.exe - (Toad for Oracle)
1.3 Version Number : 10.5.0.41
1.4 Parameters :
1.5 Compilation Date: Mon, 29 Mar 2010 18:19:19 +0000
1.6 Up Time : 1 hour, 39 minutes, 17 seconds

Exception:

2.1 Date : Wed, 22 Dec 2010 10:17:05 +0000
2.2 Address : 00412B4D
2.3 Module Name : Toad.exe - (Toad for Oracle)
2.4 Module Version: 10.5.0.41
2.5 Type : EConvertError
2.6 Message : ‘‘00.00.0000 00:00:00’’ is not a valid date and time.
2.7 ID : E970
2.8 Count : 1
2.9 Status : New
2.10 Note :

User:

3.1 ID : awatson
3.2 Name : admin
3.3 Email :
3.4 Company :
3.5 Privileges: SeLockMemoryPrivilege - OFF
SeIncreaseQuotaPrivilege - OFF
SeSecurityPrivilege - OFF
SeTakeOwnershipPrivilege - OFF
SeLoadDriverPrivilege - OFF
SeSystemProfilePrivilege - OFF
SeSystemtimePrivilege - OFF
SeProfileSingleProcessPrivilege - OFF
SeIncreaseBasePriorityPrivilege - OFF
SeCreatePagefilePrivilege - OFF
SeBackupPrivilege - OFF
SeRestorePrivilege - OFF
SeShutdownPrivilege - OFF
SeDebugPrivilege - OFF
SeSystemEnvironmentPrivilege - OFF
SeChangeNotifyPrivilege - ON
SeRemoteShutdownPrivilege - OFF
SeUndockPrivilege - OFF
SeManageVolumePrivilege - OFF
SeImpersonatePrivilege - ON
SeCreateGlobalPrivilege - ON
SeIncreaseWorkingSetPrivilege - OFF
SeTimeZonePrivilege - OFF
SeCreateSymbolicLinkPrivilege - OFF

Active Controls:

4.1 Form Class : TFormGridSaveAs
4.2 Form Text : Export Data
4.3 Control Class: TFormGridSaveAs
4.4 Control Text :

Computer:

5.1 Name : CIRCE
5.2 Total Memory : 3567 Mb
5.3 Free Memory : 1959 Mb
5.4 Total Disk : 232.79 Gb
5.5 Free Disk : 188.21 Gb
5.6 System Up Time: 1 day, 2 hours, 47 minutes, 38 seconds
5.7 Processor : Intel® Core™2 Duo CPU E7200 @ 2.53GHz
5.8 Display Mode : 1280 x 1024, 32 bit
5.9 Display DPI : 96
5.10 Video Card : Intel® Q33 Express Chipset Family (driver 8.15.10.1930 - RAM 256 MB)
5.11 Printer : HP LaserJet P2050 Series PCL6 (driver 6.1.7600.16385)

Operating System:

6.1 Type : Microsoft Windows 7
6.2 Build # : 7600
6.3 Update :
6.4 Language: English
6.5 Charset : 0

Network:

Call Stack Information:

|Address |Module |Unit |Class |Procedure/Method |Line |

Running Thread: ID=5488; Priority=-2; Class=; [Main]
00BA4BFB
00BA4A5C
00BAC17D
00BABEC4
00BA9078
00BA8FB4
00FA9AD8
00FA99E8
020569F4
01DDA0E7
01DD9FA0
01DD9D4D
01DD9CE0
01DDA183
01DDA13C
01E4474E
01E44734
01E446CA
01E446AC
01A3FDA2
752083DB
7520F2AA
752083CF
752083DB
76DE4DBA
752043F0
751FCCC7
00577277
751FCC8F
75207690
752043F0
752043DA
751FBBB3
75208E97
75208E8D
01A3C13D
01A3C038
01D0DBE0
00FBACB4
0101017B
75207854
75207829
75208E97
75208E8D
021E7CEA
76751192

Modules Information:

Processes Information:

Assembler Information:

Registers:


#7

Hi Adam,

Yuk! I don’t know what happened there but the format has been destroyed
(probably yahoo!) and everything came in on one line :frowning:

Hi, I’m running 10g DB and client so no issue there.
Excellent.

I tried just
selected a column that has no date or time in it and it still gave the
same error.
Sounds like it’s definitely not an Oracle problem that is causing the
error in that case. If there are no DATEs then there should not be a
reason to convert.

I selected “Spool SQL to screen” ran a very simple query and
then export and here is the result:

2.5 Type : EConvertError
2.6 Message : ‘‘00.00.0000 00:00:00’’ is not a valid date and time.

This shows that it’s [most likely] something internal to Toad and not
coming from Oracle - client or otherwise. I’m afraid you’ll need to wait
for the developers to come online for a solution. Sorry.

Cheers,
Norm. [TeamT]


#8

Adam,

Is your task scheduler service running? If not, does starting it and rebooting
your PC make the problem go away?

I know you aren’t scheduling anything here, but some code is firing that
has to do with scheduling. Looks like it is trying to determine the start date
of your computer and coming back with all zeros.

-John


#9

Oops, looks like that isn’t start time of your computer. Still, check the
scheduler service though…
image004.gif


#10

Oops, looks like that isn’t start time of your computer. Still, check the
scheduler service though…
image002.gif (43 Bytes)


#11

Thanks for looking at this.

Task scheduler is running and has been all the time


#12

If you haven’t set up anything in the Automation Designer, I think
you’ll be able to solve this by going to your User Files folder and
deleting ToadActions.dat (with Toad not running). Doing this will delete any
actions/apps you’ve set up though.


#13

Thank you very much guys for helping me with this

Message was edited by: Adam_watson


#14

Hi Adam-

When this occurs again, please open Utilities > Task Scheduler and send me a screen shot. You can erase anything which may be construed as confidential, I just want to see the Schedule dates. If any of the Schedule dates look funky, delete or reschedule that item. I believe that’s the source of your problem.

Mark


#15

I’ve got the problem back


#16

Hi,

I’ve got the problem back. I’ve attached a screen shot of the task scheduler. I can’t see any dodgy looking dates in there.

I also had a problem the other day when if I clicked the column heading in the results to sort. It did the sort but returned the entire table, ignoring the where statements. If I put a order by xxx desc in the statement then it ordered it correctly.

eg a select * from TABLE where COLUMN1 = 1 would return 10 results out of a 1000 line table, clicking the heading of COLUMN2 to sort would return all 1000 rows sorted on COLUMN2.

This has stopped happening and I remember it doing it shortly before I had the export error last time.

Thanks
Adam
Task.png


#17

Hi Adam-

The screenshot I need is from Toad: Utilities > Task Scheduler, for a variety of
reasons.

And you can send it directly to my email address - mark.lerch@quest.com

thanks for your help,

Mark


#18

I would just like to add that I have the exact same problem. I’m using Toad 10.5.0.41 on Windows 7 64 bit.

Here is a screenshot of my task scheduler.


#19

The problem is there are tasks (commonly Google update tasks) which have a zero
value for their scheduled time. The code wasn’t expecting that. You should be
able to either alter the schedule for those via Windows, remove them (like I
did, but I’m rather cranky and don’t like updates firing all over the place
constantly), or upgrade to a later version of Toad which has the problem fixed.


#20

Hi ,
This link worked for me. http://programmervision.blogspot.in/2012/09/solve-toad-problem-00000000-000000-is.html

Nandan