Re: Problem with reload as "service" - Qlik Community

johnlauridsen · ‎2012-12-12

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:

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

fosuzuki · ‎2012-12-12

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 · ‎2012-12-12

sorry.. where would this log be ?

/John

fosuzuki · ‎2012-12-12

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 · ‎2012-12-12

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 · ‎2012-12-12

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 · ‎2012-12-17

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 · ‎2012-12-17

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 · ‎2012-12-17

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 · ‎2012-12-17

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