Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

General ODCB error, Cannot load QVD_Lader.qvd

Hi there,

When I try to reload the qvd-loader it keeps coming back with Failed. I've got the log below here.

Im new to qlikview and I don't really know where to look yet for this error.

Can someone please help me with this?

Thanks in advance.

Here is the log:

2015-04-17 11:36:23) Information: Executing ClusterID=1, QDSID=730dbace-b25b-bdfe-79e9-33b187cf6d82 QDSMain.DistributeTask

(2015-04-17 11:36:23) Information: Starting task "QVD Laders/QVD_Lader.qvw" (Attempt 1 of 1)

(2015-04-17 11:36:23) Information: Max run time: 06:00:00

(2015-04-17 11:36:23) Information: Document is marked for refresh; Initializing Reload.

(2015-04-17 11:36:23) Information: Opening "D:\QLIKVIEW\QVD LADERS\QVD_Lader.qvw"

(2015-04-17 11:36:23) Information: Allocating QlikView Engine

(2015-04-17 11:36:23) Information: Allocating new QlikView Engine. Current usagecount=1 of 2

(2015-04-17 11:36:23) Information: An instance of the QlikView Engine is being created

(2015-04-17 11:36:23) Information: Starting QlikView Engine

(2015-04-17 11:36:24) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 2, Ticket=2

(2015-04-17 11:36:24) Information: Loading document "D:\QLIKVIEW\QVD LADERS\QVD_Lader.qvw" (0.14 Mb)

(2015-04-17 11:36:25) Information: Loading. LoadTime=00:00:01.0140260

(2015-04-17 11:36:26) Information: Physical FileSize=0.14 Mb. Memory Allocation Delta for this file=5.89 Mb. Available Physical Memory Before Open=1698.29 Mb. Available Physical Memory After Open=1693.22 Mb. Total Physical Memory=4095.55 Mb.

(2015-04-17 11:36:26) Information: The document was loaded successfully.

(2015-04-17 11:36:26) Information: Initializing Checkout (0), Loading document (624), Initializing load (624), Checking read (624), Creating QlikView Engine (624), Checking Size (624), Load (2636), Load Completed (2652), Tables read (2667), Opened successfully (2683)

(2015-04-17 11:36:26) Information: Document was opened successfully

(2015-04-17 11:36:26) Information: Opened successfully (0)

(2015-04-17 11:36:26) Information: Starting reload

(2015-04-17 11:36:26) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

(2015-04-17 11:36:27) Information: Reloading.

(2015-04-17 11:36:28) Information: Reloading..

(2015-04-17 11:36:28) Information: The Source Document is being reloaded. DocumentPath=D:\QLIKVIEW\QVD LADERS\QVD_Lader.qvw

(2015-04-17 11:36:29) Information: Reloading...

(2015-04-17 11:36:30) Information: Reloading....

(2015-04-17 11:36:31) Information: Reloading.....

(2015-04-17 11:36:32) Information: Reloading......

(2015-04-17 11:36:33) Information: Reloading.......

(2015-04-17 11:36:34) Information: Reloading........

(2015-04-17 11:36:35) Information: Reloading.........

(2015-04-17 11:36:36) Information: Reloading..........

(2015-04-17 11:36:37) Information: Slowing down logging. LoggingSeconds=2

(2015-04-17 11:36:37) Information: Reloading

(2015-04-17 11:36:39) Information: Reloading.

(2015-04-17 11:36:41) Information: Reloading..

(2015-04-17 11:36:43) Information: Reloading...

(2015-04-17 11:36:44) Information: The Source Document reload complete. DocumentPath=D:\QLIKVIEW\QVD LADERS\QVD_Lader.qvw

(2015-04-17 11:36:44) Information: Memory Allocation Delta for this file=1.36 Mb. Available Physical Memory Before Reload=1693.24 Mb. Available Physical Memory After Reload=1690.18 Mb. Total Physical Memory=1690.18 Mb.

(2015-04-17 11:36:44) Error: The Source Document was NOT reloaded successfully. DocumentPath=D:\QLIKVIEW\QVD LADERS\QVD_Lader.qvw. Errors: 16 ScriptError: , ScriptErrorList: General ODBC Error

(2015-04-17 11:36:44) Error: Table Not Found

(2015-04-17 11:36:44) Error: Syntax Error

(2015-04-17 11:36:44) Error: General ODBC Error

(2015-04-17 11:36:44) Error: Syntax Error

(2015-04-17 11:36:44) Error: General Error

(2015-04-17 11:36:44) Error: Table Not Found

(2015-04-17 11:36:44) Error: General ODBC Error

(2015-04-17 11:36:44) Error: Field Not Found

(2015-04-17 11:36:44) Error: General Error

(2015-04-17 11:36:44) Error: General Error

(2015-04-17 11:36:44) Error: Table Not Found

(2015-04-17 11:36:44) Error: General ODBC Error

(2015-04-17 11:36:44) Error: General Error

(2015-04-17 11:36:44) Error: General Error

(2015-04-17 11:36:44) Error: Table Not Found

(2015-04-17 11:36:44) Error: , ScriptErrorDetails=

(2015-04-17 11:36:44) Information: Initializing Reload (0), Finished (17799)

(2015-04-17 11:36:44) Error: Reload failed.

(2015-04-17 11:36:44) Information: Closing the document.

(2015-04-17 11:36:44) Information: Closed the QlikView Engine successfully. ProcessID=3900

(2015-04-17 11:36:44) Information: Initializing (0), Finished (266)

(2015-04-17 11:36:44) Error: Reload failed. Distribution skipped.

(2015-04-17 11:36:44) Error: The task "QVD Laders/QVD_Lader.qvw" failed. ErrorCount=3

2 Replies
petter
Partner - Champion III
Partner - Champion III

General ODBC error with the specific error of field not found is pointing you towards an error in your SQL SELECT and the columns mentioned there that might not be in the database table anymore.

maxgro
MVP
MVP

in your doc

menù -> settings  --> document properties --> general tab --> check generate logfile

reload

and in the same folder of  yur .qvw doc you'll find a .log file with more info (wel,usually) on your error