HomeForum
Welcome, Guest

Problems with large txt file
(1 viewing) (1) Guest
  • Page:
  • 1
  • 2

TOPIC: Problems with large txt file

Problems with large txt file 1 year, 5 months ago #1233

  • cmarra
  • OFFLINE
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
I'm trying to export some data from a txt file (quite large: more then 1300 columns, pipe delimited, from 5 to 100 rows) into a postgresql db table.
Here my problems:

Reader module
- setting field's name to 0 returns an error: "Access violation at address ...... in module 'AdvancedETL.exe'. Read of address ......" After that, any operation on reader module returns a similar error (.... Write of address....)
- no way to manual set field's names ? (seems fine only when the input file has at least an header row)
- using Auto format grid in reader module lead to a cpu load next to 100% (a manual width set to the exact number of columns seems fine but sometimes the program become unresponsive)

Validator & Transformer
- any attempt to open the editor locks the program for minutes (more than 15 minutes to open!!!)

Notice that the same operation with Visual Importer proceeded without problems.
I can PM the text file if needed

Regards
C

Re: Problems with large txt file 1 year, 5 months ago #1234

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2174
  • Karma: 12
Hello

Sure we will do everything to help you.
You did not say the version number you work with

setting field's name to 0 returns an error
It think it was already addressed
You should not be able to set to 0 but 1

I will check this one for you

Anyway the plan of actions

Make sure that you are using latest version
If it does not help email us the text file
We will do our own internal investigations
If we are not able to reproduce the problem here we will create a special build for you which will indicate the source of the problem

Mike

Re: Problems with large txt file 1 year, 5 months ago #1235

  • cmarra
  • OFFLINE
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
The version I'm using now is 3.2.2.5 (but the same problems since version 3.2.2.1)

Re: Problems with large txt file 1 year, 5 months ago #1236

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2174
  • Karma: 12
Reproduced the problem

an update will be available shortly

Mike

Re: Problems with large txt file 1 year, 5 months ago #1237

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2174
  • Karma: 12
Can you try version 3.2.2.6 please and let us know the outcome

Mike

Re: Problems with large txt file 1 year, 5 months ago #1238

  • cmarra
  • OFFLINE
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
Hello Mike,
bad news, with version 3.2.2.6 still the same delay opening the validator and after a field rename in the reader module the application hangs for minutes (the vertical scroll bar start resizing indefinitely; this behavior also in previous versions)
C.
  • Page:
  • 1
  • 2
Time to create page: 0.19 seconds

Testimonials

We tried many expensive software in our test environment but no one qualified.

C Gandhi
Nesa-Canada

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top