Ah, forgot to ask what your uvodbc.config (or is called uci.config in UV 10.x?) file looks like on the client side (your Oracle server).
On one of our client servers the uvodbc.config has this section at the end of the file... these parameters are documented in the UCI manual (somewhere). [UNIVERSE] MAXFETCHBUFF = 32768 MAXFETCHCOLS = 1000 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Sidhu Sent: Wednesday, February 04, 2004 5:04 AM To: 'U2 Users Discussion List' Subject: RE: UCI Error UV version? UniVerse version - 10.0.6 OS version? UniVerse Box OS - HP/UX 11.0 What is the "different server"? Oracle Box OS - HP/UX 11.0 Does this query complete from the TCL prompt on the UV server? YES -----Original Message----- From: Hona, David S [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 9:32 PM To: 'U2 Users Discussion List' Subject: RE: UCI Error UV version? OS version? What is the "different server"? Does this query complete from the TCL prompt on the UV server? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Sidhu Sent: Tuesday, February 03, 2004 10:11 AM To: 'U2 Users Discussion List' Subject: RE: UCI Error Does anyone know if there is some time out variable in Universe that would cause this or maybe something that kicks my connection after a certain time (only a couple minutes) or kicks me due to memory faults? I'm connecting from a different Server to the Universe Server. I've never worked with Universe before so anything would help, Thanks, Dave -----Original Message----- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 3:03 PM To: U2 Users Discussion List Subject: RE: UCI Error Hi David, The docs say IM985 Error in RPC interface I think I would be checking the network and/or ensuring your rpc daemon is still running. The error 81002 is a universe system error >ED SYS.MESSAGE 081002 The file "SYS.MESSAGE" is read-only and cannot be updated. 2 lines long. ----: P 0001: unirpc: No Connection 0002: Bottom at line 2. ----: EX > Hope this helps Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Sidhu Sent: Tuesday, 3 February 2004 9:23 AM To: 'U2 Users Discussion List' Subject: UCI Error Anyone know what this error is when using UCI? I got it after running a query numerous times with different id's. I checked the sql statement and the ID both are correct. Just after a four thousand iterations I get this error. ERROR!!!!!! SQLExecDirect Died in SQLExecDirect with SQLSTATE IM985 Native error: 81002 [IBM][SQL Client][RPC] error code = 81002 The Query is simply: SELECT A.MEM.ID, A.REG.BEG.DT, A.REG.END.DT, A.GROUP FROM MEM.REG.HIST A WHERE A.MEM.ID = 'XXXXX*01'; Where the X's is the id number. Thanks, Dave _______________________________________________ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users _______________________________________________ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
