Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Direct discovery problem

It appear the following problem . It isn't always appear  How to solve this prolem   ?

Tags (1)
10 Replies
Not applicable

Re: Direct discovery problem

the attached pic

sergey_maka8
Valued Contributor

Re: Direct discovery problem

Hi, Jack

Did you try to see what is happening with memory via task manager?

Employee
Employee

Re: Direct discovery problem

Hi Jack,

What are the system resources of your database server?  Is their sufficient disk space?

The logging available to Direct Discovery is by way of ODBC logging.

Direct Discovery SQL statements passed to the data source can be recorded in the trace files of the database connection. For a standard ODBC connection, tracing is started with the ODBC Data Source Administrator:

ODBC.png

Can you enable logging and post the results?

Clint

Not applicable

Re: Direct discovery problem

My server memory is 256GB , My file  log is as following:

(2014-05-31 12:40:04) Information: The Source Document reload complete. DocumentPath=F:\BI\DEPLOY\STOCK.qvw

(2014-05-31 12:40:04) Information: Memory Allocation Delta for this file=435.48 Mb. Available Physical Memory Before Reload=371818.34 Mb. Available Physical Memory After Reload=373737.98 Mb. Total Physical Memory=373737.98 Mb.

(2014-05-31 12:40:04) Error: The Source Document was NOT reloaded successfully. DocumentPath=F:\BI\DEPLOY\STOCK.qvw.

(2014-05-31 12:40:04) Information: Closing the document.

Not applicable

Re: Direct discovery problem

I try many methods :

   1  I load it in two client  computer (the server is the same) . It isn't ok.

   2  Sometimes ,it can be reloaded .

   3  I have two server with 70% memory used, One is ok ,another isn't ok.

   4  Today I load ok  because of the server load is low.

I want to know which  factors affect  the DD .

Not applicable

Re: Re: Direct discovery problem

Today I run twice . One fail . The attachment is the log file on OMC. The third times reload too long  and the SQLlog is more 1.9GB .

antoniotiman
Honored Contributor III

Re: Direct discovery problem

Hi Jack,

have You tried to update ODBC Driver of MySql (5.1) ?

Regards,

Antonio

Not applicable

Re: Direct discovery problem

I am using mySQL3.51. I find there are data format problems using 5.1 when using QV SQL SELECT .

Not applicable

Re: Direct discovery problem

SORRY , MYSQL5.2

Community Browser