Error when scheduling LOAD from Oracle table

[#1]

Hi. I have a qvw which loads data from an Oracle view successfully when it is done manually but fails with the following error when scheduled:

The task "Dev Data/GrowerDebt/TestCroplands.qvw" failed. Part of the log file follows:09/12/2010 09:09:04 Error The Source Document was NOT reloaded successfully. DocumentPath=D:\QVDATA\APPS\DATA\DEV DATA\GrowerDebt\TestCroplands.qvw.
09/12/2010 09:09:04 Error Reload failed.
09/12/2010 09:09:04 Error The task "Dev Data/GrowerDebt/TestCroplands.qvw" failed. ErrorCount=2

QlikView runs under a service account with sufficient access. I can logon to the Oracle server with this account and run a query against the view in question.

I removed everything from the qvw except the ODBC CONNECT, scheduled it and it ran successfully. Adding a simple SQL SELECT resulted in the above error.

I have been through various logs on both servers but have not found any indication as to the exact reason.

I would be grateful if anybody could shed some light on this.

[tabletuner]

did you check the folder locations? use the server's drive letters instead of network locations.

An other option may be to give the execution service a user with more rights. Do this in the service properties of the qv execution service

[#3]

Thanks for the input.

I changed the Logon user in the QlikView Server Service to one with full access to both servers but it had no effect.

As far as the path is concerned, it seems to be correct as the task runs for a while loading data from JDE in the first part but seems to fail as soon as it hits the SQL SELECT for the Oracle view. If I remove the SQL SELECT alone leaving the CONNECT in place, it finishes without an error. I even connected to JDE, loaded data, connected to Oracle and immediately re-connected to JDE and was able to load further JDE data successfully.

It is starting to look like an Oracle issue although I still can't explain why the task runs quite happily when invoked manually.

I have pasted the Task Details below for completeness.

Dave

(2010-12-09 14:02:38) Information: Executing ClusterID=1, QDSID=5fda05e7-a00f-6f77-5a66-172815059bd4 QDSMain.ReloadTask
(2010-12-09 14:02:38) Information: Starting task "Dev Data/GrowerDebt/GrowerDebt_Extract.qvw" (Attempt 1 of 1)
(2010-12-09 14:02:38) Information: Max run time: 06:00:00
(2010-12-09 14:02:38) Information: Opening "D:\QVDATA\APPS\DATA\DEV DATA\GrowerDebt\GrowerDebt_Extract.qvw"
(2010-12-09 14:02:38) Information: Allocating QlikView Engine
(2010-12-09 14:02:38) Information: Allocating new QlikView Engine. Current usagecount=2 of 2
(2010-12-09 14:02:38) Information: An instance of the QlikView Engine is being created
(2010-12-09 14:02:38) Information: Starting QlikView Engine
(2010-12-09 14:02:38) Information: Allocated QlikView Engine successfully. Current usagecount=2 of 2, Ticket=548
(2010-12-09 14:02:38) Information: Loading document "D:\QVDATA\APPS\DATA\DEV DATA\GrowerDebt\GrowerDebt_Extract.qvw" (0.12 Mb)
(2010-12-09 14:02:39) Information: Physical FileSize=0.12 Mb. Memory Allocation Delta for this file=2.48 Mb. Available Physical Memory Before Open=1486.02 Mb. Available Physical Memory After Open=1483.15 Mb. Total Physical Memory=3839.45 Mb.
(2010-12-09 14:02:39) Information: The document was loaded successfully.
(2010-12-09 14:02:39) Information: Initializing Checkout (0), Loading document (266), Initializing load (266), Checking read (266), Creating QlikView Engine (266), Checking Size (360), Load (360), Load Completed (422), Tables read (438), Opened successfully (469)
(2010-12-09 14:02:39) Information: Document was opened successfully
(2010-12-09 14:02:39) Information: Opened successfully (0)
(2010-12-09 14:02:39) Information: Starting reload
(2010-12-09 14:02:39) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.
(2010-12-09 14:02:39) Information: The Source Document is being reloaded. DocumentPath=D:\QVDATA\APPS\DATA\DEV DATA\GrowerDebt\GrowerDebt_Extract.qvw
(2010-12-09 14:02:40) Information: Reloading.
(2010-12-09 14:02:41) Information: Reloading..
(2010-12-09 14:02:42) Information: Reloading...
(2010-12-09 14:02:43) Information: Reloading....
(2010-12-09 14:02:44) Information: Reloading.....
(2010-12-09 14:02:45) Information: Reloading......
(2010-12-09 14:02:46) Information: Reloading.......
(2010-12-09 14:02:47) Information: Reloading........
(2010-12-09 14:02:48) Information: Reloading.........
(2010-12-09 14:02:49) Information: Reloading..........
(2010-12-09 14:02:50) Information: Slowing down logging. LoggingSeconds=2
(2010-12-09 14:02:50) Information: Reloading
(2010-12-09 14:02:52) Information: Reloading.
(2010-12-09 14:02:54) Information: Reloading..
(2010-12-09 14:02:56) Information: Reloading...
(2010-12-09 14:02:58) Information: Reloading....
(2010-12-09 14:03:00) Information: Reloading.....
(2010-12-09 14:03:01) Information: The Source Document reload complete. DocumentPath=D:\QVDATA\APPS\DATA\DEV DATA\GrowerDebt\GrowerDebt_Extract.qvw
(2010-12-09 14:03:01) Information: Memory Allocation Delta for this file=9.41 Mb. Available Physical Memory Before Reload=1483.14 Mb. Available Physical Memory After Reload=1476.00 Mb. Total Physical Memory=1476.00 Mb.
(2010-12-09 14:03:01) Error: The Source Document was NOT reloaded successfully. DocumentPath=D:\QVDATA\APPS\DATA\DEV DATA\GrowerDebt\GrowerDebt_Extract.qvw.
(2010-12-09 14:03:01) Information: Initializing Reload (0), Finished (22750)
(2010-12-09 14:03:01) Error: Reload failed.
(2010-12-09 14:03:01) Information: Closing the document.
(2010-12-09 14:03:02) Information: Closed the QlikView Engine successfully. ProcessID=12472
(2010-12-09 14:03:02) Information: Initializing (0), Finished (203)
(2010-12-09 14:03:02) Error: The task "Dev Data/GrowerDebt/GrowerDebt_Extract.qvw" failed. ErrorCount=2
(2010-12-09 14:03:02) Information: Sending Alert Mail to 4 recipients.

[#4]

Did you check the QVW .log file?

[Bjorn_Wedbratt]

I'm no Oracle expert but I know from the past that I had several issues with older Orca clients. For example there's a bug in older versions if running on a x64 platform and configuring orca home dir in /Program Files (x86)/. The drive couldn't handle the () in the path. Changing the orca home to C:\orca81 solved that issue.

Another issue is with environment variables not being configured properly making some system variable paths not being present when running in batch mode.

If you enable logging in the qvw-file you might be able to spot the SQL (ORA) error in the generated log file created next to the qvw-file when reloading. Might also be possible to do a SQL trace on the actual drive to see if you find something.