Toad World® Forums

Failed Import


#1

Well the first thing I tested was to import an excel file and I get erros. Tried
restarting toad, only one connection up:

11:39:35 AM Thread (26) Import Started [31/03/2011 11:39:35 AM]
11:39:35 AM Thread (26) Processing “TMCD Users.xlsx” into “TMP.USER_DIMENSION”
11:39:35 AM Thread (26) Importing 1 out of 1 files
11:39:35 AM Thread (26) Reading from file TMCD Users.xlsx
11:39:35 AM Thread (26) Object reference not set to an instance of an object.
11:39:37 AM Thread (26) Error importing data, please check file format options:
Object reference not set to an instance of an object.
11:39:37 AM Thread (26) Import Finished [31/03/2011 11:39:37 AM]
11:39:37 AM Thread (26) Import time: 00:00:02.1090780

Here’s the tim file:

FormatIndex=“5” FileName=“C:\My Documents\Docs\TBS\MIS\WNP\TBSPERF\TMCD
Users.xlsx” Trl=" oracle://ADMIN@TSTDB629/TABLE/TMP/USER_DIMENSION "
ColumnNames=“True” FirstDataRow=“2” StartRow=“1” BlankAsNull=“True”
Encoding=“Western European (Windows)” NewTableName="" RecreateTable=“False”
HeterogenousImport=“False” Truncate=“False” Identity=“False”
SpanInputSource=“False” BlockInsertValue=“500”>
/>
/>
Key=“6” Value=“6” />
Value=“4” />
/>
/>
MultiItemRow=“0” MultiItemColumn=“0” MultiItemEndRow=“0” MultiItemEndColumn=“0”
MultiItemColumnHeaders=“True” MultiItemTranspose=“False” MultiItemFilter=""
/>
MultiItemEndRow=“0” MultiItemEndColumn=“0” MultiItemColumnHeaders=“False”
MultiItemTranspose=“False” MultiItemFilter="" />
MultiItemRow=“0” MultiItemColumn=“0” MultiItemEndRow=“0” MultiItemEndColumn=“0”
MultiItemColumnHeaders=“False” MultiItemTranspose=“False” MultiItemFilter=""
/>
MultiItemEndRow=“0” MultiItemEndColumn=“0” MultiItemColumnHeaders=“False”
MultiItemTranspose=“False” MultiItemFilter=""
/>

The error mentions file format. Is there somewhere to check this? Oddly it reads
the file, and lets you click through to the mapping window and Finish to launch
the import.

Regards,
Tom


#2

#3

Hello Tom, we created CR82857 for this. Should be in the beta next week.

Thanks,

Jane


#4

Hello all!

I’m having the same exact error importing a CSV file:

03:32:37 p.m. Thread (10) Import Started [03/04/2011 03:32:37 p.m.]
03:32:37 p.m. Thread (10) Processing “huawei_DATEFILE.txt” into “trafico_umts.crudos_hua_tmp”
03:32:37 p.m. Thread (10) Truncate table trafico_umts.crudos_hua_tmp
03:32:37 p.m. Thread (10) The rows failed importing will be written to file : F:\DBPCC\CrudosUMTS\huawei_DATEFILE_rows_with_error.csv
03:32:37 p.m. Thread (10) Importing 1 out of 1 files
03:32:37 p.m. Thread (10) Reading from file huawei_DATEFILE.txt
03:32:37 p.m. Thread (10) Object reference not set to an instance of an object.
03:32:37 p.m. Thread (10) Nothing to discard, delete F:\DBPCC\CrudosUMTS\huawei_DATEFILE_rows_with_error.csv
03:32:41 p.m. Thread (10) Error importing data, please check file format options: Object reference not set to an instance of an object.
03:32:41 p.m. Thread (10) Import Finished [03/04/2011 03:32:41 p.m.]
03:32:41 p.m. Thread (10) Import time: 00:00:04.2812500

This wasn’t happening in previous version, so I think this must be a 3.0 BETA problem. Hope it will be fixed in next week BETA as Jane said.

Thanks!!!


#5

This is in the Beta that was posted today. Please download Beta 3.0.0.739.

Debbie


#6

Kudos and many thanks for the quick turnaround on this.
Imports working correctly, all automation jobs are catching up.

This actually turns out to enable an interesting stress test. About 20
automations are running at the same time. Let’s see how well it holds up.

THANK YOU!


#7

Our pleasure:)


#8

Looks good all automations completed correctly, imports and all.