[556] in Project_DB
Re: Fwd: Project Database
daemon@ATHENA.MIT.EDU (Mike Barker)
Fri Sep 1 19:36:33 2000
Message-Id: <4.2.2.20000901193600.03d70410@po11.mit.edu>
Date: Fri, 01 Sep 2000 19:37:43 -0400
To: Robert Ferrara <rferrara@mit.edu>
From: Mike Barker <mbarker@MIT.EDU>
Cc: project-db@mit.edu, rar@mit.edu
In-Reply-To: <4.3.2.7.2.20000901175151.00b4a020@po9.mit.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
fixed.
the problem was that the priority wasn't set (in the error message,
priority='()').
So I set that to low first.
Then I changed the status.
Mike
At 05:52 PM 9/1/00 -0400, Robert Ferrara wrote:
>Hello,
>
>Both Roger and I got this same error report. Any help appreciated.
>
>Cheers, Bob
>
>
> >X-Mailer: exmh version 2.1.1 10/15/1999
> >To: Robert Ferrara <rferrara@MIT.EDU>
> >Subject: Project Database
> >From: "Roger A. Roach" <rar@MIT.EDU>
> >Address: MIT Room W91-201B, 77 Massachusetts Ave, Cambridge, MA 02139-4307
> >Telephone: 617-253-7011 Fax: 617-253-1266
> >Date: Fri, 01 Sep 2000 16:21:02 -0400
> >Sender: rar@MIT.EDU
> >
> >Bob,
> >
> >I tried to change the status of the "Ports from Decstations" as complete
> >and I got:
> >
> >Scheme Error
> >The object (error "ORA-02290: check constraint (PDB.SYS_C00436) violated\n
> >(update pdb.my_project_data\n set pstatus='Completed', priority='()'\n where
> >project_id = 18)\n"), passed as the first argument to integer-zero?, is not
> >the correct type.
> >
> >Any idea why?
> >
> >Roger
