topic Scheduling the Jobs in QMC in QlikView

Scheduling the Jobs in QMC

Thu, 13 Oct 2011 06:41:20 GMT

Good Morning All,

I am new to QV, I have a problem in scheduling the jobs.

I am using QV 9.0 trying to scheule a job no error message is coming, in QMC, Status tab I can not see any error message but the report is not refreshed

previously it was fine, I don't know where I struck.

Anybody help me its really very urgent.

Regards

Chris

Scheduling the Jobs in QMC

its_anandrjs — Thu, 13 Oct 2011 06:44:34 GMT

Hi,

I suggest you need to check the log file of the application where you can find the error log by this you can find what is the error in your application. To find log file open the applicaiton folder which is present there and find the appliation log there.

Rgds

Anand

Scheduling the Jobs in QMC

SunilChauhan — Thu, 13 Oct 2011 06:50:31 GMT

open qlikview document -> setting -> documeent properties -> general -> generate logfile-> check

and reload by task . when it runs it creates a logfile at the location of qvw file.

in log u can find the error.

while creating the task in reload tab check weither reload is checked or not .

Scheduling the Jobs in QMC

Thu, 13 Oct 2011 07:14:03 GMT

Dear Sunil,

Thanks for your reply as what you said I have checked the "Create a Log file", I don't know which folder I can see the log file and what will be the extention of file.

Please advise..

Regards

Chris

Scheduling the Jobs in QMC

jonathandienst — Thu, 13 Oct 2011 08:01:18 GMT

Chris

The log file will be in the same folder as your model, with the same name as your model and a .log extension.

Regards

Jonathan

Scheduling the Jobs in QMC

its_anandrjs — Thu, 13 Oct 2011 08:13:10 GMT

Hi,

Its extention is .log file and suppose your file name is QVAppl.qvw then the log file will be QVAppl.qvw.log and it will open in the notepad.

Rgds

Anand

Scheduling the Jobs in QMC

SunilChauhan — Thu, 13 Oct 2011 08:45:46 GMT

it will be in your folder where application is .

its by applicationname.qvw.log in same flder as applicationname.qvw ( where you are getting error)

Scheduling the Jobs in QMC

Thu, 13 Oct 2011 09:20:15 GMT

Dear All,

Thanks for your reply, still I can not find solution, now I found the log file, when I reload manually the log file gives the exact report at the same time when I schedule it in QMC there is no impact on the log file also.

I think now the problem is very big..

Regards

Joe

Scheduling the Jobs in QMC

SunilChauhan — Thu, 13 Oct 2011 09:23:00 GMT

delete the task for application and create a task again

then reload and see

Scheduling the Jobs in QMC

Thu, 13 Oct 2011 09:40:54 GMT

Dear Sunil,

Is it a problem of "Directory Service Connector"

In the QMC, "Directory Service Connector" disconnects and again its automatically shows as running, if its yes means how to resovle it.

Chris

Scheduling the Jobs in QMC

Anonymous — Thu, 13 Oct 2011 09:54:04 GMT

Joe,

how do u get data from ERP , ODBC.... or wath?

Scheduling the Jobs in QMC

Thu, 13 Oct 2011 09:58:35 GMT

Hi,

From ODBC only. Data Source is AS/400..

Regards

Chris

Scheduling the Jobs in QMC

Anonymous — Thu, 13 Oct 2011 10:02:40 GMT

ODBC for AS400 ask serial number ... substitute serial number with ip address

Many time hai have problem with ODBC and AS400. The biggest problem is when u reload

by client it is work , but not work in QMC.

maybe your proble is that u can not connect to AS400.

ciao

Andrea

Scheduling the Jobs in QMC

Thu, 13 Oct 2011 13:18:21 GMT

Dear Andrea,

In the below I have attached the sample of qvevents log file, in that I can read that no access but the credentials which I was given is perfect.

I don't know where I am making mistake.

Can you suggest me ....

Regards

Chriss

2011-09-22 08:58:08 2011-10-12 16:08:59 2 110 Warning The document E:\Documents\Distribution.qvw failed to load because of no access [15].

2011-09-22 08:58:08 2011-10-12 16:11:42 2 110 Warning The document E:\Documents\Quality Distribution.qvw failed to load because of no access [15].

2011-09-22 08:58:08 2011-10-12 16:11:53 2 110 Warning The document E:\Documents\Quality Distribution.qvw failed to load because of no access [15].

2011-09-22 08:58:08 2011-10-12 16:12:12 2 110 Warning The document E:\Documents\Quality Distribution.qvw failed to load because of no access [15].

2011-09-22 08:58:08 2011-10-12 16:12:24 2 110 Warning The document E:\Documents\Quality Distribution.qvw failed to load because of no access [15].

2011-09-22 08:58:08 2011-10-12 17:05:45 2 110 Warning The document E:\Documents\port Analysis.qvw failed to load because of no access [15].

2011-09-22 08:58:08 2011-10-12 17:44:04 2 110 Warning The document E:\Documents\port Analysis.qvw failed to load because of no access [15].

2011-09-22 08:58:08 2011-10-12 18:17:15 2 110 Warning The document E:\Documents\port Analysis.qvw failed to load because of no access [15].

2011-09-22 08:58:08 2011-10-12 20:57:19 2 110 Warning The document E:\Documents\port Analysis.qvw failed to load because of no access [15]

Scheduling the Jobs in QMC

Anonymous — Thu, 13 Oct 2011 14:19:43 GMT

Chriss,

did u install I.E plug in?

The user u use to access in AS400 has USRCLS *SECOFR like user QSECOFR?

Scheduling the Jobs in QMC

Fri, 14 Oct 2011 05:37:02 GMT

Dear Andrea,

Thanks for your reply, and the IE Plugin is already installed and I have secheduled one document without a section access, that too failed to reload.

Really I don't know how to resolve it..

Regards

Chriss

Scheduling the Jobs in QMC

jonathandienst — Fri, 14 Oct 2011 06:01:33 GMT

Chris

Perhaps the access permissions have changed somewhere. Does the service account that QEMC runs under have sufficient priveleges on the data source(s), the log file folder and the model folder?

Regards

Jonathan

Scheduling the Jobs in QMC

Anonymous — Fri, 14 Oct 2011 09:58:32 GMT

Chris,

wath ODBC u use ? Client Access IBM?

when u connet with

ODBC CONNECT TO as520 (XUserId is OGMeGSVMNbbGXTFMNC, XPassword is CdOVGSVMNbbGXTFMHF);

XUserId is type *SECOFR?

when u select file like this :

FROM S661CFAA.LIBRARY.FILE;

TRY TO SOSTITUTE WITH

FROM 10.10.10.100.LIBRARY.FILE; Where 10.10.10.100 is ip of as400