HPL Error: cannot execute start_onpload

On IDS version 9.40 when I run the command onpladm run job sp -fu I am getting the error: Cannot execute stored procedure start_onpload SQL ERROR -668. I run the same series of commands to create the job and the device array on IDS 11.50 and everything works as planned. I am running everything as user informix, and I know start_onpload is a stored procedure in sysmaster, I just can't figure out why it's complaining. I have searched for similar problems, but all I can find are references to running the HPL from Windows, which I'm not. Here is the output of onpladm describe job sp -fu: BEGIN OBJECT FASTUNLOADJOB sp PROJECT <default> DEVICE spdev SERVER myinformixserver DATABASE mydatabasename QUERY sp END OBJECT And here is the output from onpladm describe device spdev: BEGIN OBJECT DEVICEARRAY spdev BEGIN SEQUENCE TYPE FILE FILE /temp/sp.unl TAPEBLOCKSIZE 0 TAPEDEVICESIZE 0 PIPECOMMAND END SEQUENCE END OBJECT If I need to provide further info, please let me know. Any help will be greatly appreciated.

Some more info: I looked at sysprocdures on both instances for start_onpload and they were identical. I used the excellent article by John Carlson at http://www.ibm.com/developerworks/data/zones/informix/library/techarticle/0307ca rlson/0307carlson.html to create the jobs. Since I'm unsure which version of IDS the tutorial used, I'm going to explore whether some arguments were different between 9.40 and 11.50.

Or, you can use an X interface with ipload. The 11.11 version may have a bug but the 9.x version run just fine under version 11. Some think this interface is a bit clunky and maybe it is but it's easier, at least for me, to control.

Thanks Ralph, I forgot to add that I got a demo of Exceed yesterday to run it through an X-Window and received the same error.

I apologize for the multiple replies for the same response. What I did was run the job I created with onpladm using the graphical tool. I will try creating the job and device array through ipload and see what results. Thanks again Ralph.

Hello! I´ve always thought the graphical interface is very complicated. Here I downloaded de myonpload application (available on the IIUG software repository) and it´s very simple to install and use, really. Hope it helps your needs. Best regards. Alexandre Marini Tecnologia da Informação - DBA SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix <cid:part2.01070909.00010801@fazenda.ms.gov.br> IBM Informix Dynamic Server Certified Professional V10 / V11 Contacte-me Linkedin <http://br.linkedin.com/pub/alexandre-marini/4/606/714>; --- @ WiseStamp Signature <http://my.wisestamp.com/link?u=5pyh9cbdjqrjbm83&site=www.wisestamp.com/email-in stall>. Get it now <http://my.wisestamp.com/link?u=5pyh9cbdjqrjbm83&site=www.wisestamp.com/email-in stall> Em 4/5/2010 10:51, ROBERT DOUGLAS escreveu: > Thanks Ralph, I forgot to add that I got a demo of Exceed yesterday to run it > through an X-Window and received the same error. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > >

RESOLUTION After diving in the sysprocbody for start_onpload that is called by onpladm and finding nothing that should result in onpload not being executed, I am just going to run onpload from the command line instead. There is a difference in start_onpload in 9.4 and 11.5 that checks for Windows OS, but for the life of me I can't figure out why the call to onpload fails in the stored procedure. Thanks to everyone for their input. P.S. I generated a new job from scratch using ipload in an X-Window and it gave me the same error.