IDS Forum

RE: I have a puzzling situation

Posted By: Mark Tyrer
Date: Monday, 29 October 2012, at 10:21 a.m.

In Response To: I have a puzzling situation (John Adamski)

Just as a thought=2C you should install FC5 which is a maintenance release.=
It probably will not fix this issue=2C but could save you from a lot of ot=
her issues.

So the 2 users can execute echo hello|mailx -s 'This is a test' debarthe
on the database host and when you echo $? the result is 0

Do the users also have the path to mailx set for their accounts on the data=
base server host?

In the stored procedure=2C what happens when you explicitly specify /usr/bi=
n/mailx

-----Original Message-----

From: John Adamski
Sent: 29 Oct 2012 13:48:58 GMT
To: ids@iiug.org
Subject: I have a puzzling situation [28655]

HPUX 11.31 on BL8709c Integrity server
IDS 11.70.FC4

A little over a month ago we upgraded to 11.70 and the developers say that
since then some users have been having problems executing procedures that h=
ave
the SYSTEM command in them.

One of the developers has created a test procedure to help identify the cau=
se
of this reported problem. So far we know of two users that can't run the te=
st
procedure=2C they get a 668 error. All other users we have tried can execut=
e the
procedure successfully.

Checking permission on the users that work and the ones that don't did not
identify any cause. We check both OS and Informix.

We are testing using dbaccess using this command

execute procedure testsysfail()

The two users that fail get this message when they run.

SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit
Run the current SQL statements.

----------------------- cars@carsitcp ---------- Press CTRL-W for Help
--------

(expression)

Failed=2C error 668

1 row(s) retrieved.

I have included the latest version of the test procedure that the developer=
is
using below. Does anyone have any idea what might be causing these two user=
s
to get a 668 error when they run the procedure? Or what I might do to resol=
ve
this?

{
Revision Information (Automatically maintained by 'make' - DON'T CHANGE)
-------------------------------------------------------------------------
$Header: procskeleton=2Cv 8.0 2002/05/09 08:36:56 debarthe Released $
-------------------------------------------------------------------------
}
drop procedure testsysfail=3B

create procedure testsysfail()
returning char(32)=3B

{The SQL data type subset includes all the SQL data types except BYTE=2C SE=
RIAL=2C
and TEXT.}
{char=2C nchar=2C date=2C datetime=2C decimal=2C numeric=2C float=2C intege=
r=2C money
smallfloat=2C smallint=2C real=2C varchar=2C nvarchar
{define global var1 integer default default 0=3B}
{define var2 like id_rec.ss_no=3B}
{define var3 char(10)=3B}

define sys_var char(256)=3B

{This exception traps for error 284 multiple records from subquery
and must immediately follow the defines}
on exception in (-668)

return "Failed=2C error 668"=3B
end exception=3B

Set isolation to dirty read=3B

set optimization low=3B

--set debug file to "debugxxx" with append=3B
--trace on=3B
-- let sys_var =3D "echo this is a test > /tmp/"||USER||"test.test"=3B

let sys_var =3D "mailx -s 'This is a test' debarthe"=3B
system sys_var=3B

return "succeded"=3B
end procedure=3B

grant execute on testsysfail to public=3B

{Add an execute for testing and to try to force optimization}

--execute procedure testsysfail()=3B

***************************************************************************=
****
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• I have a puzzling situation
  John Adamski -- Monday, 29 October 2012, at 9:48 a.m.
  • Re: I have a puzzling situation
    Art Kagel -- Monday, 29 October 2012, at 10:09 a.m.
  • Re: I have a puzzling situation
    Art Kagel -- Monday, 29 October 2012, at 10:12 a.m.
    • RE: I have a puzzling situation
      John Adamski -- Monday, 29 October 2012, at 12:28 p.m.
      • Re: I have a puzzling situation
        Art Kagel -- Monday, 29 October 2012, at 1:22 p.m.
        • RE: I have a puzzling situation
          jim-cramer@uiowa.edu -- Tuesday, 30 October 2012, at 2:21 p.m.
          • RE: I have a puzzling situation
            John Adamski -- Wednesday, 31 October 2012, at 10:58 a.m.
            • RE: I have a puzzling situation
              jim-cramer@uiowa.edu -- Wednesday, 31 October 2012, at 12:50 p.m.
              • RE: I have a puzzling situation
                John Adamski -- Thursday, 1 November 2012, at 10:09 a.m.
                • RE: I have a puzzling situation
                  jim-cramer@uiowa.edu -- Thursday, 1 November 2012, at 11:20 a.m.
                  • RE: I have a puzzling situation
                    John Adamski -- Thursday, 1 November 2012, at 3:54 p.m.
                    • RE: I have a puzzling situation
                      jim-cramer@uiowa.edu -- Thursday, 1 November 2012, at 4:44 p.m.
                    • Re: RE: I have a puzzling situation
                      JASON HARRIS -- Friday, 2 November 2012, at 12:33 a.m.
                • RE: I have a puzzling situation
                  jim-cramer@uiowa.edu -- Thursday, 1 November 2012, at 1:53 p.m.
                  • Re: I have a puzzling situation
                    David Zinder -- Thursday, 1 November 2012, at 2:14 p.m.
    • Re: I have a puzzling situation
      FRANK J. COMPUTER -- Wednesday, 31 October 2012, at 4:01 a.m.
      • RE: I have a puzzling situation
        John Adamski -- Wednesday, 31 October 2012, at 11:12 a.m.
        • RE: I have a puzzling situation
          david@smooth1.co.uk -- Wednesday, 31 October 2012, at 12:02 p.m.
          • RE: I have a puzzling situation
            John Adamski -- Wednesday, 31 October 2012, at 4:11 p.m.
            • RE: I have a puzzling situation
              jim-cramer@uiowa.edu -- Wednesday, 31 October 2012, at 4:55 p.m.
  • RE: I have a puzzling situation
    Mark Tyrer -- Monday, 29 October 2012, at 10:21 a.m.
    • Re: I have a puzzling situation
      Art Kagel -- Monday, 29 October 2012, at 10:36 a.m.
      • RE: I have a puzzling situation
        Paul Watson -- Monday, 29 October 2012, at 10:42 a.m.
        • Re: I have a puzzling situation
          Art Kagel -- Monday, 29 October 2012, at 11:07 a.m.
  • Re: I have a puzzling situation
    Jonathan Leffler -- Monday, 29 October 2012, at 1:19 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.