topic Reload engine failed in QlikView

Reload engine failed

Wed, 17 Jul 2013 09:21:30 GMT

Hi,

I sheduled one loader file based in the event of another loader succeded. Daily it's running fine but today it's failed caould anyone help me how to get that success as usual like daily.

Thanks.

Re: Reload engine failed

rajni_batra — Wed, 17 Jul 2013 10:58:17 GMT

Did u check that its running manually or not?

Re: Reload engine failed

Wed, 17 Jul 2013 11:27:21 GMT

Hi Rajni,

I tried reloading manually it's failing to reload one adddb table as it is getting ODBC read failed select *from tablename.how to solve this do I need to check with team who creted those file?

Thanks.

Re: Reload engine failed

rajni_batra — Wed, 17 Jul 2013 11:33:57 GMT

yes there may be some issue with ur ODBC connection check with tech team and try to load that table first in other QVW by creating new connection string and check if it is working fine or not

Re: Reload engine failed

Wed, 17 Jul 2013 11:38:56 GMT

Can you tell me what is the below error means?

Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000慭, ErrorCode: 4294965685, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Office Access database engine stopped the process because you and another user are attempting to change the same data at the same time.

Re: Reload engine failed

Joaquin_Lazaro — Wed, 17 Jul 2013 11:43:22 GMT

Lock problem.

One user get the access record for update, close the mdb or accdb and try again

Re: Reload engine failed

saumyashah90 — Wed, 17 Jul 2013 11:45:31 GMT

Hi Amelia,

Just open that qlikview application and go to Document properties

Under Settings->Document properties->General

In here you have check boxes on top right. Click on "Generate Log File" and reload it once.

By this you will get to know where the reload have gone wrong.

Mostly problem can be

a) source file name changed

b) tab inside source file name changes

c)Field names in a sheet might have changed.

Once you go through the log file you will get to know the where reload has failed.(Basically last line of the log file will be the error file.or else just type ctrl+f and type "error"; where evere error has occured you will get to know)

Re: Reload engine failed

saumyashah90 — Wed, 17 Jul 2013 11:47:49 GMT

Its an access problem.....When your query is hitting your database its not allowing to access

Re: Reload engine failed

Wed, 17 Jul 2013 12:03:47 GMT

Its showing ODBC time out and login time out in the log file how to sort out this?

Re: Reload engine failed

Wed, 17 Jul 2013 12:04:19 GMT

Its showing ODBC time out and login time out in the log file how to sort out this?

Re: Reload engine failed

Wed, 17 Jul 2013 12:04:33 GMT

Its showing ODBC time out and login time out in the log file how to sort out this?