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: 
johnlauridsen
Contributor III
Contributor III

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
Partner - Specialist III
Partner - Specialist III

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
Contributor III
Contributor III
Author

sorry.. where would this log be ?

/John

fosuzuki
Partner - Specialist III
Partner - Specialist III

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.

Ricardo_Gerhard
Employee
Employee

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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

Miguel_Angel_Baeyens

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
Partner - Specialist III
Partner - Specialist III

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...