Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Visual Importer hangs with error

Visual Importer hangs with error 9 months 2 weeks ago #19377

  • vgupte
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 1
Hi,
I am using Visual Importer Enterprise to import data from QVDs to MS SQL database. I have a package with several importer scripts that does this job. Each importer script reads a QVD and imports it to a target table in database.

Yesterday the package failed for one of the importer scripts with the following error:

Error 12/08/2019 5:47:55 PM Execution of Import Script: PathologyResults Importer has failed
Error 12/08/2019 5:47:55 PM Access violation at address 000000000042F63E in module 'VImpEnt.exe'. Read of address 0000000000007328

What does this error mean ? There's no other information in the log files.

Also, the application becomes unresponsive and I have to kill it.


Thanks,
Vik
The following user(s) said Thank You: Peter.Jonson

Please Log in or Create an account to join the conversation.

Visual Importer hangs with error 9 months 2 weeks ago #19378

  • admin
  • admin's Avatar
  • Away
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7798
  • Karma: 33
  • Thank you received: 465
That means that our software is unable to read QVD file for some reason. Are you able to email it to us so we can investigate?
Mike

Please Log in or Create an account to join the conversation.

Visual Importer hangs with error 9 months 2 weeks ago #19383

  • vgupte
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 1
Its too large to be emailed at 2.4 GB.

I tried to do the run of just the importer script that failed and it worked. So, QVD can be read. I will probaly need to take a full package run again to test. I will let you know what happens then.

Thanks,
Vik

Please Log in or Create an account to join the conversation.

Visual Importer hangs with error 9 months 2 weeks ago #19384

  • admin
  • admin's Avatar
  • Away
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7798
  • Karma: 33
  • Thank you received: 465
If you are using 32-bit version it might run out of memory so 64 bit is a better option.
Mike

Please Log in or Create an account to join the conversation.

Visual Importer hangs with error 1 month 2 weeks ago #19839

  • vgupte
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 1
Hi,
I have faced a similar error again for another file. Below is the error line from log file.

Error 17/04/2020 1:29:40 PM Access violation at address 000000000042F64E in module 'VImpEnt.exe'. Read of address 0000000000007328

I got the error in an importer script being run within a package. The QVD file is 1.24GB large.
Usualy, ETL tools is able to read this file. It has successfully read it many times before. So, I am not sure what went wrong this time.

The package is to be scheduled to be run daily as a part of automation. So its desired that the package runs without such errors.

Also, to your previous suggestion, we do use a 64 bit version. The ETL tools run on a server with 160 GB of RAM with an normal free space of 100 GB.

Do you have any suggestions to get more information on why this is happening ?

Regards,
Vik

Please Log in or Create an account to join the conversation.

Visual Importer hangs with error 1 month 2 weeks ago #19840

Hello.

We would like to connect remotely and investigate.
Please keep a copy of the file so we can work with it.
Peter Jonson
Support Analist

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 342 guests and 3 members online