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
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]
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
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,
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]
sorry should have added I’m running Toad for Oracle Base ver: 10.5.0.41 on a PC with Windows 7
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: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
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
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 :
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
4.1 Form Class : TFormGridSaveAs
4.2 Form Text : Export Data
4.3 Control Class: TFormGridSaveAs
4.4 Control Text :
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)
6.1 Type : Microsoft Windows 7
6.2 Build # : 7600
6.3 Update :
6.4 Language: English
6.5 Charset : 0
| 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 |
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 
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]
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
Oops, looks like that isn’t start time of your computer. Still, check the
scheduler service though…
Oops, looks like that isn’t start time of your computer. Still, check the
scheduler service though…
image002.gif (43 Bytes)
Thanks for looking at this.
Task scheduler is running and has been all the time
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.
Thank you very much guys for helping me with this
Message was edited by: Adam_watson
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
I’ve got the problem back
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
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
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.
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.
Hi ,
This link worked for me. http://programmervision.blogspot.in/2012/09/solve-toad-problem-00000000-000000-is.html
Nandan
