[project-open-development] Why Project is not created

[Adarsh S. <ada...@or...>]

Dear all,

I am sorry if i forgot to follow any guidelines to post in this mailing 
list.

I configure Project Open in my CentOS  ( Linux ws-test 2.6.18-164.el5 #1 
SMP Thu Sep 3 03:28:30 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux ) system. 
Postgres Version is 8.4.2
I installed the following rpm packages :

aolserver-4.5.0-1.po.rhel5.i386
aolserver-tcl-8.4.14-1.po.rhel5.i386
nscache-1.5-1.po.rhel5.i386
nspostgres-4.0-2.po.rhel5.i386
tDOM-0.8.1cvs-3.po.rhel5.i386
nssha1-0.1-1.po.rhel5.i386

My Project Open is installed properly after following the below link :
http://www.project-open.org/documentation/install_redhat

But don't know why when I create a new project or any user following 
error occurs :

Database operation "0or1row" failed (exception ERROR, "ERROR:  missing FROM-clause entry for table "acs_object_id_seq" at character 8
QUERY:  select acs_object_id_seq.nextval
                    from dual
CONTEXT:  PL/pgSQL function "acs_object__new" line 12 at SQL statement
PL/pgSQL function "im_project__new" line 19 at assignment
")

ERROR:  missing FROM-clause entry for table "acs_object_id_seq" at character 8
QUERY:  select acs_object_id_seq.nextval
                    from dual
CONTEXT:  PL/pgSQL function "acs_object__new" line 12 at SQL statement
PL/pgSQL function "im_project__new" line 19 at assignment

SQL: 

select im_project__new (
        NULL,         
        'im_project',
        '2011-06-28 11:46:56.729132+05',
        '624',
        '127.0.0.1',
        NULL,
        'Orkash Globe',
        '2011_0001',
        '2011_0001',
        NULL,
        '16622',
        '99',
        '76'
);


    
    while executing
"ns_pg_bind 0or1row nsdb0 {

select im_project__new (
        NULL,         
        'im_project',
        :creation_date,
        :creation_user,
    ..."
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
    ("postgresql" arm line 2)
    invoked from within
"switch $driverkey {
                oracle {
                    return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
                }
       ..."
    invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
    invoked from within
"if {[regexp -nocase -- {^\s*select} $test_sql match]} {
                ns_log Debug "PLPGSQL: bypassed anon function"
                set selection [..."
    ("uplevel" body line 6)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle -dbn $dbn db {
            # plsql calls that are simple selects bypass the plpgsql 
            # mechanism for creating anonymous fun..."
    (procedure "db_exec_plsql" line 57)
    invoked from within
"db_exec_plsql create_new_project $sql"
    (procedure "project::new" line 57)
    invoked from within
"project::new  -project_name	$project_name  -project_nr		$project_nr  -project_path	$project_path  -company_id		$company_id  -parent_id		$parent_id  -p..."
    invoked from within
"if {[form is_valid $form_id]} {

    set project_path $project_nr

    # -----------------------------------------------------------------
    # Creat..."
    ("uplevel" body line 532)
    invoked from within
"uplevel {
    	  # /packages/intranet-core/projects/new.tcl
#
# Copyright (C) 1998-2004 various parties
# The software is based on ArsDigita ACS 3.4
#..."
    (procedure "code::tcl::/web/projop/packages/intranet-core/www/projects/n..." line 2)
    invoked from within
"code::tcl::$__adp_stub"
    invoked from within
"if { [file exists $__adp_stub.tcl] } {

      # ensure that data source preparation procedure exists and is up-to-date
      adp_init tcl $__adp_stub
..."
    ("uplevel" body line 3)
    invoked from within
"uplevel {

    if { [file exists $__adp_stub.tcl] } {

      # ensure that data source preparation procedure exists and is up-to-date
      adp_init t..."
    (procedure "adp_prepare" line 2)
    invoked from within
"adp_prepare "
    (procedure "template::adp_parse" line 30)
    invoked from within
"template::adp_parse [file root [ad_conn file]] {}"
    (procedure "adp_parse_ad_conn_file" line 5)
    invoked from within
"$handler"
    ("uplevel" body line 2)
    invoked from within
"uplevel $code"
    invoked from within
"ad_try {
                $handler
            } ad_script_abort val {
                # do nothing
            }"
    invoked from within
"rp_serve_concrete_file [ad_conn file]"
    (procedure "rp_serve_abstract_file" line 60)
    invoked from within
"rp_serve_abstract_file "$root/$path""
    ("uplevel" body line 2)
    invoked from within
"uplevel $code"
    invoked from within
"ad_try {
            rp_serve_abstract_file "$root/$path"
            set tcl_url2file([ad_conn url]) [ad_conn file]
            set tcl_url2path_info..."



Please guide me how to solve the issue as I struggle to find the root 
cause of it.


Thanks