FAQ – Frequently Asked Questions

Here you will find answers to most common questions about our software.
In any other case, please feel free to write to contact@wilcondata.com

Error Message : The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

It might be you get this Error Message when working with Excel Files or Access Tables. This error Message means – most obvious – that you haven’t installed the ACE Provider on your Machine.

Unfortunaly this Provider is neither installed by the Windows Operating system nor by the Office setup so that you have to install it.

Please do not forget to install it on the Machine where your Wilcon Designer is running AND on the Machine where the Wilcon Builder Service is running.

You can download and install the ACE Driver here:

Microsoft Access Database Engine 2010 Redistributable

How to read EXCEL files most efficiently

To get Excel Information into a Database System it is good to know some basics about Excel.

Please check this :

Datatypes in Excel

Column Headers in Excel

Nothing is transferred although jobs are pending

Most likely this happens because the Wilcon DWH Service APP is not working.

This might  be because of Network problems or Database-Server rebooting and so on.

The easiest way to get rid of it is to restart the Service:

Find the Service Wilcon DWH Builder Service, Stop the Service and start it again like this:

ServiceName

serviceRestart

A specific Task does not start even if it has to

It might be that this job did run before and could not finish because of loosing the network connection or database connection of the DWH system. In those cases the Wilcon DWH Builder tries to correct several times.

If this is not successful and you are sure that the specific job is not active set it not active in the DWH Builder Gui like this:

  • Open the Schedule Form
  • click on “Job is Active”
  • set the status  to “not active”

selectScheduleJobActive

JobActivetoNon

Contact – Get in touch with Wilcon Data

Main Office

Wilcon Data GmbH
Habichtweg 1
41468 Neuss, Germany

Tel.: +49 2131 316493-0
Email: contact@wilcondata.com

If you have any questions or need more information, don’t hesitate to contact us. We will answer your request immediately!

Please use our contact form.

2 + 3 = ?