Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

johnlauridsen
New Contributor

Problem with reload as "service"

Hi

All or documents are reloaded using the Management Console - on the Reload tab of the document.

But 2-3 documents often fails. Not always bot often (like 5 out of 7 days). I get the folllowing error by e-mail.

************

The task
"Testing/ETL_Filer/Extract/Extract_Sales_Scanglas.qvw" failed. Part
of the log file follows:

2012-12-11 20:58:21                  Error                   The Source Document was NOT
reloaded successfully. DocumentPath=C:\PROGRAM FILES\QLIKVIEW\QV
UTVECKLING\ETL_Filer\Extract\Extract_Sales_Scanglas.qvw.

2012-12-11 20:58:22                  Error                   The task
"Testing/ETL_Filer/Extract/Extract_Sales_Scanglas.qvw" failed.
Exception:

  1. QDSMain.Exceptions.DistributionFailedException:
    Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException:
    Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source
    Document was NOT reloaded successfully. DocumentPath=C:\PROGRAM
    FILES\QLIKVIEW\QV UTVECKLING\ETL_Filer\Extract\Extract_Sales_Scanglas.qvw.

   at
QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

   at
QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String
sectionAccessUserName, String sectionAccessPassword, eReloadOptions
reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

   --- End of inner
exception stack trace ---

   at
QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String
sectionAccessUserName, String sectionAccessPassword, eReloadOptions
reloadOption, String variableName, String variableValue, Boolean
moniterCpuUsage)

   at
QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

   --- End of inner
exception stack trace ---

   at
QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

   at
QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult
taskResult)

*********

does the above mean anything to any of you ?

Thanks in advance. Sorry for the format.

/John

11 Replies
fosuzuki
Valued Contributor II

Re: Problem with reload as "service"

Maybe you can find more details about the error in the document log. Can you post it?

I saw that the problem occurred in an Extractor, probably this QVW is generating QVDs. I'd guess that the Extractor is trying to store a table to a QVD while the QVD is being read by another QVW...

johnlauridsen
New Contributor

Re: Problem with reload as "service"

sorry.. where would this log be ?

/John

fosuzuki
Valued Contributor II

Re: Problem with reload as "service"

To enable it, you must go to Settings > Document Properties > General > Generate Log File. It will be created in the same folder as the QVW.

Employee
Employee

Re: Problem with reload as "service"

Make this test:

- Verify it this documents are reloaded during execution of another task;

- Schedule your task with dependencies to prevent this overlapping;

- Change your documents to create log files like Fernando Suzuki saw;

- Verify if your server has memory to execute this task.

Find this problem is not simple, but it´s necessary.

Ricardo Gerhard
OEM Solution Architect
LATAM
johnlauridsen
New Contributor

Re: Problem with reload as "service"

Well actually this document was the first in a row of documents.

I did check several documents for reloads and I did activate the logging, this evening it ran ok, I will get back with the results in the next days.

Thanks so far for your replies.

/John

johnlauridsen
New Contributor

Re: Problem with reload as "service"

Well after activating the Log-file-generation I have now a look at the log file. the last line contains the error.

2012-12-16 21:03:56:        39 fields found: LAG_MANDANT, LAG_ART_TYP, LAG_ART_NUM, LAG_MNG_EINH, LAG_MNG_STK, LAG_MIN_BESTELL, LAG_MIN_BESTAND, LAG_BESTAND, LAG_RES_BESTAND, LAG_GEPL_BESTAND, LAG_BESTELLT, LAG_LTZT_LIEF_NR, LAG_BESTELLTEXT_JN, LAG_LFM_STK, LAG_REFERENZ, LAG_PRIORITY, LAG_VORLAUF, LAG_BREITE, LAG_HOEHE, LAG_BEARB, LAG_SFORM, LAG_LTZT_BEW_DAT, LAG_MAX_WBZ, LAG_MIN_WBZ, LAG_VERFUEGBAR, LAG_KG_STK, LAG_LIT_STK, LAG_ZUSCHN_JN, LAG_MAT_CODE, LAG_LTZT_EIN_DAT, LAG_EINK_PREIS, LAG_GRP_ID, LAG_TIEFE, LAG_MAX_BESTAND, LAG_CLASSIFIC, LAG_OSP_REF, LAG_OSP_ITM, LAG_OSP_SEQ, LAG_STOCKVAL_MODE, 
2012-12-16 21:03:56:       QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 1406, ErrorMsg: [Oracle][ODBC][Ora]ORA-01406: hentet kolonneværdi blev afskåret

Its still strange, as its not always failing to reload, and its never failing when re-loading in the document.

/John

johnlauridsen
New Contributor

Re: Problem with reload as "service"

And the log file when it goes OK.

2012-12-17 13:42:50: 0324  SQL SELECT *

2012-12-17 13:42:50: 0325  FROM LIORDER."V_LAGER_ST_ALPHA"

2012-12-17 13:42:51:        39 fields found: LAG_MANDANT, LAG_ART_TYP, LAG_ART_NUM, LAG_MNG_EINH, LAG_MNG_STK, LAG_MIN_BESTELL, LAG_MIN_BESTAND, LAG_BESTAND, LAG_RES_BESTAND, LAG_GEPL_BESTAND, LAG_BESTELLT, LAG_LTZT_LIEF_NR, LAG_BESTELLTEXT_JN, LAG_LFM_STK, LAG_REFERENZ, LAG_PRIORITY, LAG_VORLAUF, LAG_BREITE, LAG_HOEHE, LAG_BEARB, LAG_SFORM, LAG_LTZT_BEW_DAT, LAG_MAX_WBZ, LAG_MIN_WBZ, LAG_VERFUEGBAR, LAG_KG_STK, LAG_LIT_STK, LAG_ZUSCHN_JN, LAG_MAT_CODE, LAG_LTZT_EIN_DAT, LAG_EINK_PREIS, LAG_GRP_ID, LAG_TIEFE, LAG_MAX_BESTAND, LAG_CLASSIFIC, LAG_OSP_REF, LAG_OSP_ITM, LAG_OSP_SEQ, LAG_STOCKVAL_MODE, 5.087 lines fetched

/John

MVP
MVP

Re: Problem with reload as "service"

Hello John,

Just to be sure, which version of QlikView is the Server running? If different to the latest release v11 SR2 Update 2 build 11440, I'd strongly recommend you to upgrade as there were some issues with previous releases of v11.

I assume that the account running the services has all permissions to run the ODBC, so if you log on to Windows as this account and manually reload, this will work just fine.

Hope that helps.

Miguel

fosuzuki
Valued Contributor II

Re: Problem with reload as "service"

Hi John,

I think you already did it, but I googled the error code ORA-01406:

http://www.dba-oracle.com/t_ora_01406_fetched_column_value_was_truncated.htm

So your problem might not be in QlikView. Strange though that it is intermitent...

Community Browser