Text Importer stops before all input records in text file are read

[NE WCC]

The input file has 142,853 records and the importer stops loading records into the Oracle table after row 44354. There are no warnings or error messages, it just stops. Do you have any ideas why it won't finish loading the input file?

PL/SQL Developer
Version 12.0.5.1828 (32 bit)
01.115016 - 5 user license
Service Contract: 8/1/2018
Windows 10 (64-bit) Build 17763

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Homes
OH1335871885 (C:\oracle\product\11.1.1\as_1)
OraClient12Home1_32bit (C:\oracle\product\12.2.0)

DLLs
C:\oracle\product\12.2.0\bin\oci.dll

Using
Home: OraClient12Home1
DLL: C:\oracle\product\12.2.0\bin\oci.dll
OCI: version 12.1
Oracle Database 12c Standard Edition Release 12.1.0.2.0

Process
Working Set = 116,211,712
Memory = 36,463,080
GDI Objects = 645
User Objects = 381
Handles = 586

Thanks. Bruce

 

[Marco Kalter]

I'm not sure what could cause this. As a test, can you try the same with the current 13.0.4 version?

 

[cct]

I have seen similar, in that the performance loading large files is not good. So after a number of records, it seems as if it has frozen, ie the interface freezes, but will finish eventually - given time.

Chris

 

[NE WCC]

We had need to try this again and it still is stopping. There are 212,144 records in the text file but it stops at 194,316. We have removed the following characters: #()'";,& replacing with space. The input file is 49.3 MB (51,765,248 bytes).

We are running the 64 bit version now on a server. Here is the latest support info:

PL/SQL Developer
Version 13.0.4.1906 (64 bit)
01.120949 - 5 user license
Service Contract: 9/1/2019
Windows 10 Build 14393

Physical memory : 1,048,176 kB (312,236 available)
Paging file : 2,527,392 kB (1,251,956 available)
Virtual memory : 137,438,953,344 kB (137,438,319,892 available)

Parameters
C:\Program Files\PLSQL Developer 13\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Program Files\PLSQL Developer 13\Preferences\Default\Default.ini
C:\Users\ediServer\AppData\Roaming\PLSQL Developer 13\Preferences\ediServer\default.ini

License File
C:\Users\ediServer\AppData\Roaming\PLSQL Developer 13\aalf.dat

Debug file
C:\Users\ediServer\AppData\Roaming\PLSQL Developer 13\PlSqlDev.elf

Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer 13\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer 13\PlugIns\plsqldoc.dll)
(* is Active)

Aliases
WCCDEVA0
WCCDEVB0
WCCProd

Homes
OraClient12Home1 (C:\oracle\product\12.2.0\client_1)

DLLs
C:\oracle\product\12.2.0\client_1\oci.dll

TNS File
C:\oracle\product\12.2.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient12Home1
DLL: C:\oracle\product\12.2.0\client_1\oci.dll
OCI: version 12.1 (12.2.0.1.0)
Oracle Database 12c Standard Edition Release 12.1.0.2.0

Character Sets
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG:
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: AL32UTF8

Process
Working Set = 97,079,296
Memory = 45,867,002
GDI Objects = 1547
User Objects = 904
Handles = 780

Monitor
PixelsPerInch = 96

Id = 0
PPI = 96
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1920
Height = 1080

MainFormOnTaskbar = True

Looking for any other possible ideas.

Thanks.

 

[Marco Kalter]

When it stops, does it hang or has it simply finished without importing all records?

Can you also try the same with the current 13.0.6 version?