]project-open[ V4.0.1 Dev-1 VMware Available

2012-01-20
2012-11-13
  • Frank Bergmann
    Frank Bergmann
    2012-01-20

    Hi,

    The ]popo[ V4.0 installer for download.
    The file is available here on SourceForge -> Files -> project-open -> V4.0 ->
    project-open-VMware-4.0.1.0.1-dev1.zip

    The version is called "Dev-1", because it's still under development (not even "alpha").
    However, the developments that are missing are new features rather then instabilities
    of the base product, so we are already using this version in production for many
    customers.

    In contrast to the basically stable product code, we have chosen CentOS 6.2 as the
    base for the VMware. This version is completely new for us, so there may still be some
    quirks to come.

    For a status of the development please see
    http://www.project-open.org/documentation/project_open_roadmap , go to the V4.0
    section and drill down into the links of the packages for a status.

    Please let us know about your experience with the VMware and post any issues
    either here in this forum or in the "Bug Tracker".

    Cheers!
    Frank

     
  • Frank Bergmann
    Frank Bergmann
    2012-01-20

    Hi,

    I've got already the first amendments, the reverse proxy Pound is not running correctly.
    As user "root" please enter:

    # chkconfig -add pound
    # chkconfig -levels 345 pound on
    # /etc/init.d/pound restart

    Cheers,
    Frank

     
  • Frank Bergmann
    Frank Bergmann
    2012-01-22

    Hi,

    Here is the next fix for a display issue of workflows. You need to create a symbolic
    link to the "dot" Linux command:

    # su - root
    # cd /usr/local/bin
    # ln -s /usr/bin/dot

    Cheers,
    Frank

     
  • Frank Bergmann
    Frank Bergmann
    2012-01-22

    Another fix for GraphViz "dot":

    # su - root
    # yum install graphviz-gd

    Bests,
    Frank

     
  • Frank Bergmann
    Frank Bergmann
    2012-01-23

    Hi,

    I see that we've got 45 downloads so far, but no feedback yet, neither positive nor negative.

    Could you please let us know if things have worked out for you after downloading the VMware?
    Just drop a short note in this thread, please.

    Thanks!
    Frank

     
  • Paulo Gerardo
    Paulo Gerardo
    2012-01-29

    Hi,

    We are going to use ]PO[ as our ERP on our IT company (we are a small MSP)

    We tested the 4.0 version but we gonna stick with the 3.5 for now.

    We are on the early phase of knowing the program and is functionality.

    I want to thank you for this fix:
    # su - root
    # yum install graphviz-gd

    Because the 3.5 vmware as the same error :) By the way, can't find the post about 3.5 vmaware release, can you help us?

    A note to the community: Both vmware versions can be installed in Virtualbox, just create a machine and use the VMDK files as the disk. In version 3.5 you have o to use SCSI controller for the disk, in version 4.0 the default SATA works just fine.

     
  • Paulo Gerardo
    Paulo Gerardo
    2012-01-29

    First error, cannot list all users:

    Database operation "0or1row" failed
    (exception ERROR, "ERROR:  function im_ticket__new(integer, character varying, timestamp with time zone, integer, character varying, integer, character varying, integer, integer, integer, integer) does not exist
    LINE 1: SELECT  im_ticket__new (  $1 ,  $2 ,  $3 ,  $4 ,  $5 ,  $6 ,…
                    ^
    HINT:  No function matches the given name and argument types. You may need to add explicit type casts.
    QUERY:  SELECT  im_ticket__new (  $1 ,  $2 ,  $3 ,  $4 ,  $5 ,  $6 ,  $7 ,  $8 ,  $9 ,  $10 ,  $11  )
    CONTEXT:  PL/pgSQL function "im_ticket__new" line 16 at return
    ")

        while executing
    "ns_pg_bind 0or1row nsdb0 {
    SELECT im_ticket__new (
    :ticket_id, - p_ticket_id
    'im_ticket', - object_type
    now(), - creation_date
    :error_…"
        ("uplevel" body line 1)
        invoked from within
    "uplevel $ulevel

    • "
          ("postgresql" arm line 2)
          invoked from within
      "switch $driverkey {
                      oracle {
                          return [uplevel $ulevel $args]
                      }
             …"
          invoked from within
      "db_exec 0or1row $db $full_name $sql"
          invoked from within
      "set selection "
          ("uplevel" body line 2)
          invoked from within
      "uplevel 1 $code_block "
          invoked from within
      "db_with_handle -dbn $dbn db {
                  set selection
              }"
          (procedure "db_string" line 27)
          invoked from within
      "db_string ticket_insert {}"
          invoked from within
      "set ticket_id "
          ("uplevel" body line 309)
          invoked from within
      "uplevel {
      # /packages/intranet-forum/www/intranet/forum/new-system-error.tcl
      #
      # Copyright (C) 2003 - 2009 ]project-open[
      #
      # All rights reserved. Ple…"
          (procedure "code::tcl::/web/projop/packages/intranet-forum/www/new-syste…" line 2)
          invoked from within
      "code::tcl::$__adp_stub"
          invoked from within
      "if {  } {

          # 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 {  } {

          # 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"
        invoked from within
    "template::adp_parse [file root ] {}"
        (procedure "adp_parse_ad_conn_file" line 6)
        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 "
        (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()
    set tcl_url2path_info() [ad_conn path_…"

     
  • Frank Bergmann
    Frank Bergmann
    2012-02-01

    Hi Pgerado,

    Please let us know the URL where this error occurs.

    Cheers,
    Frank

     
  • Paulo Gerardo
    Paulo Gerardo
    2012-02-09

    /intranet/users/index?&user_group_name=All

     
  • Paulo Gerardo
    Paulo Gerardo
    2012-02-09

    If i click Timesheet i get this error:

    Here is a detailed dump of what took place at the time of the error, which may assist a programmer in tracking down the problem:

        Database operation "0or1row" failed
        (exception ERROR, "ERROR:  function to_date(timestamp with time zone, unknown) does not exist
        LINE 1: select to_date(date_trunc('month',add_months( $1 ,1)),'YYYY-…
                       ^
        HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
        QUERY:  select to_date(date_trunc('month',add_months( $1 ,1)),'YYYY-MM-DD') - 1
        CONTEXT:  PL/pgSQL function "last_day" line 6 at SQL statement
        ")
        pqerror was: "ERROR:  function to_date(timestamp with time zone, unknown) does not exist
        LINE 1: select to_date(date_trunc('month',add_months( $1 ,1)),'YYYY-…
                       ^
        HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
        QUERY:  select to_date(date_trunc('month',add_months( $1 ,1)),'YYYY-MM-DD') - 1
        CONTEXT:  PL/pgSQL function "last_day" line 6 at SQL statement
        "
        (Status of PQexec call: PGRES_FATAL_ERROR)
        SQL: select to_char(trunc(to_date('2012-02-09', 'yyyy-mm-dd'), 'Month'), 'fmMonth') as month,
            to_char(trunc(to_date('2012-02-09', 'yyyy-mm-dd'), 'Month'), 'YYYY') as year,
            to_char(trunc(to_date('2012-02-09', 'yyyy-mm-dd'), 'Month'), 'J') as first_julian_date_of_month,
            to_char(last_day(to_date('2012-02-09', 'yyyy-mm-dd')), 'DD') as num_days_in_month,
            to_char(trunc(to_date('2012-02-09', 'yyyy-mm-dd'), 'Month'), 'D') as first_day_of_month,
            to_char(last_day(to_date('2012-02-09', 'yyyy-mm-dd')), 'DD') as last_day,
            trunc(add_months(to_date('2012-02-09', 'yyyy-mm-dd'), 1),'Day') as next_month,
            trunc(add_months(to_date('2012-02-09', 'yyyy-mm-dd'), -1),'Day') as prev_month,
            trunc(to_date('2012-02-09', 'yyyy-mm-dd'), 'year') as beginning_of_year,
            to_char(last_day(add_months(to_date('2012-02-09', 'yyyy-mm-dd'), -1)), 'DD') as days_in_last_month,
            to_char(add_months(to_date('2012-02-09', 'yyyy-mm-dd'), 1), 'fmMonth') as next_month_name,
            to_char(add_months(to_date('2012-02-09', 'yyyy-mm-dd'), -1), 'fmMonth') as prev_month_name
            from dual

            while executing
        "ns_pg_bind 0or1row nsdb0 -bind d11 {select to_char(trunc(to_date(:the_date, 'yyyy-mm-dd'), 'Month'), 'fmMonth') as month,
            to_char(trunc(to_date(:…"
            ("eval" body line 1)
            invoked from within
        "eval

    • "
              invoked from within
          "db_exec 0or1row $db $full_statement_name $sql"
              ("uplevel" body line 2)
              invoked from within
          "uplevel 1 $code_block "
              invoked from within
          "db_with_handle -dbn $dbn db {
                      set selection
                  }"
              (procedure "db_0or1row" line 50)
              invoked from within
          "db_0or1row calendar_get_information {select to_char(trunc(to_date(:the_date, 'yyyy-mm-dd'), 'Month'), 'fmMonth') as month,
              to_char(trunc(to_date(…"
              ("uplevel" body line 1)
              invoked from within
          "uplevel db_0or1row $args"
              (procedure "db_1row" line 2)
              invoked from within
          "db_1row calendar_get_information $month_info_query -bind $bind_vars -column_set calendar_info_set"
              (procedure "calendar_get_info_from_db" line 31)
              invoked from within
          "calendar_get_info_from_db $date"
              ("uplevel" body line 137)
              invoked from within
          "uplevel {
          # /packages/intranet-timesheet2/www/hours/index.tcl
          #
          # Copyright (C) 1998-2004 various parties
          # The code is based on ArsDigita ACS 3.4
          #
          #…"
              (procedure "code::tcl::/web/projop/packages/intranet-timesheet2/www/hour…" line 2)
              invoked from within
          "code::tcl::$__adp_stub"
              ("uplevel" body line 12)
              invoked from within
          "uplevel {

            if {  } {

              # 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"
            invoked from within
        "template::adp_parse [file root ] {}"
            (procedure "adp_parse_ad_conn_file" line 6)
            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 "
            (procedure "rp_serve_abstract_file" line 60)
            invoked from within
        "rp_serve_abstract_file "$root/$extra_url""
            ("uplevel" body line 2)
            invoked from within
        "uplevel $code"
            invoked from within
        "ad_try {
                    rp_serve_abstract_file "$root/$extra_url"
                    set tcl_url2file()
                    set tcl_url2path…"

     
  • Paulo Gerardo
    Paulo Gerardo
    2012-02-09

    in url:

    /intranet-timesheet2/hours/index

     
  • Paulo Gerardo
    Paulo Gerardo
    2012-02-09

    i really want to use this software to later ressel to my customers, but it's beeing hard :)

     
  • Frank Bergmann
    Frank Bergmann
    2012-02-12

    Hi,

    The issue has been fixed in ]po[ V4.0.3, which is not available also as an "upgrade installer" in the V4.0 section.

    Cheers,
    Frank

     
  • CMich
    CMich
    2012-02-27

    If I click on any project I get this error.  V 4.0.3

    Here is a detailed dump of what took place at the time of the error, which may assist a programmer in tracking down the problem:
    Database operation "0or1row" failed
    (exception ERROR, "ERROR:  column pi.item_project_member_hourly_cost does not exist
    LINE 5:     coalesce(pi.item_project_member_hourly_cost, '30') as ho…
                         ^
    ")
    pqerror was: "ERROR:  column pi.item_project_member_hourly_cost does not exist
    LINE 5:     coalesce(pi.item_project_member_hourly_cost, '30') as ho…
                         ^
    "
    (Status of PQexec call: PGRES_FATAL_ERROR)
    SQL:
    select sum(amount_converted * hourly_cost)
    from (
    select sum(pi.item_value) as amount_converted,
    coalesce(pi.item_project_member_hourly_cost, '30') as hourly_cost
    from im_planning_items pi
    where pi.item_object_id = '32672' and
    pi.item_cost_type_id = 3736
    group by
    pi.item_project_member_id,
    pi.item_project_member_hourly_cost
    ) t

        while executing
    "ns_pg_bind 0or1row nsdb1 {
    select sum(amount_converted * hourly_cost)
    from (
    select sum(pi.item_value) as amount_converted,
    coalesce(pi.ite…"
        ("uplevel" body line 1)
        invoked from within
    "uplevel $ulevel

    • "
          invoked from within
      "db_exec 0or1row $db $full_name $sql"
          ("uplevel" body line 2)
          invoked from within
      "uplevel 1 $code_block "
          invoked from within
      "db_with_handle -dbn $dbn db {
                  set selection
              }"
          (procedure "db_string" line 27)
          invoked from within
      "db_string ts_budget $planning_ts_hours_sql -default 0.0"
          (procedure "im_cost_update_project_cost_cache" line 128)
          invoked from within
      "im_cost_update_project_cost_cache $project_id"
          (procedure "im_costs_project_finance_component" line 63)
          invoked from within
      "im_costs_project_finance_component -show_details_p 0 $user_id $project_id"
          ("uplevel" body line 1)
          invoked from within
      "uplevel 1 $component_tcl"
          ("uplevel" body line 8)
          invoked from within
      "uplevel 1 $code_block "
          ("uplevel" body line 1)
          invoked from within
      "uplevel 1 $code_block "
          invoked from within
      "db_with_handle -dbn $dbn db {
              set selection

            set counter 0
            while { [db_getrow $…"
        (procedure "db_foreach" line 36)
        invoked from within
    "db_foreach get_plugins $plugin_sql {

    if {$any_perms_set_p > 0 && "f" == $perm} { continue }

    if {"" == $sort_order} { set sort_order $default_sort…"
        (procedure "im_component_bay" line 59)
        invoked from within
    "im_component_bay left"
        ("uplevel" body line 26)
        invoked from within
    "uplevel {
    set __adp_output ""

        set __adp_master
    set __adp_properties(title) "[ad_quotehtml…"
        (procedure "template::code::adp::/web/projop/packages/intranet-core/www/…" line 2)
        invoked from within
    "template::code::${template_extension}::$__adp_stub"
        invoked from within
    "template::adp_parse [file root ] {}"
        (procedure "adp_parse_ad_conn_file" line 6)
        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 "
        (procedure "rp_serve_abstract_file" line 60)
        invoked from within
    "rp_serve_abstract_file "$root/$extra_url""
        ("uplevel" body line 2)
        invoked from within
    "uplevel $code"
        invoked from within
    "ad_try {
                rp_serve_abstract_file "$root/$extra_url"
                set tcl_url2file()
                set tcl_url2path…"

     
  • CMich
    CMich
    2012-02-28

    I disabled that portlet and restarted the server.  I'm getting the same error.  Any ideas?

     
  • CMich
    CMich
    2012-02-28

    Fixed it!  Had to disable the portlet and the package!  Thanks for the help!

     
  • CMich
    CMich
    2012-02-28

    Before I fixed the project page I could look at my timesheet form.  Now when I click on timesheet I get this:

    Here is a detailed dump of what took place at the time of the error, which may assist a programmer in tracking down the problem:
    Database operation "0or1row" failed
    (exception ERROR, "ERROR:  function to_date(integer, unknown) does not exist
    LINE 12:                  and day between to_date(2455956, 'J') and t…
                                              ^
    HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
    ")
    pqerror was: "ERROR:  function to_date(integer, unknown) does not exist
    LINE 12:                  and day between to_date(2455956, 'J') and t…
                                              ^
    HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
    "
    (Status of PQexec call: PGRES_FATAL_ERROR)
    SQL:
    select
    sum(hours) as unconfirmed_hours
    from (
            select
                    to_char(day, 'J') as julian_date,
                    sum(hours) as hours
            from
                    im_hours
            where
                    user_id = 32677
                    and day between to_date(2455956, 'J') and to_date(2455962, 'J')
                    and conf_object_id is null
            group by
                    to_char(day, 'J')
    ) i
       

        while executing
    "ns_pg_bind 0or1row nsdb0 {
    select
    sum(hours) as unconfirmed_hours
    from (
            select
                    to_char(day, 'J') as julian_date,
         …"
        ("uplevel" body line 1)
        invoked from within
    "uplevel $ulevel

    • "
          invoked from within
      "db_exec 0or1row $db $full_name $sql"
          ("uplevel" body line 2)
          invoked from within
      "uplevel 1 $code_block "
          invoked from within
      "db_with_handle -dbn $dbn db {
                  set selection
              }"
          (procedure "db_string" line 27)
          invoked from within
      "db_string get_unconfirmed_hours $sql -default 0"
          (procedure "get_unconfirmed_hours_for_period" line 20)
          invoked from within
      "get_unconfirmed_hours_for_period $current_user_id $start_date_julian_wf $end_date_julian_wf"
          ("uplevel" body line 265)
          invoked from within
      "uplevel {
      # /packages/intranet-timesheet2/www/hours/index.tcl
      #
      # Copyright (C) 1998-2004 various parties
      # The code is based on ArsDigita ACS 3.4
      #
      #…"
          (procedure "code::tcl::/web/projop/packages/intranet-timesheet2/www/hour…" line 2)
          invoked from within
      "code::tcl::$__adp_stub"
          ("uplevel" body line 12)
          invoked from within
      "uplevel {

        if {  } {

          # 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"
        invoked from within
    "template::adp_parse [file root ] {}"
        (procedure "adp_parse_ad_conn_file" line 6)
        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 "
        (procedure "rp_serve_abstract_file" line 60)
        invoked from within
    "rp_serve_abstract_file "$root/$extra_url""
        ("uplevel" body line 2)
        invoked from within
    "uplevel $code"
        invoked from within
    "ad_try {
                rp_serve_abstract_file "$root/$extra_url"
                set tcl_url2file()
                set tcl_url2path…"

     
  • Frank Bergmann
    Frank Bergmann
    2012-02-28

    Hi,

    > Project Planning

    Please update the package intranet-planning from CVS. The latest version includes an upgrade script /packages/intranet-planning/sql/postgresq/upgrade/upgrade-4.0.3.0.2-4.0.3.0.3.sql that you can execute using "psql -f …". This will fix the listed issue.

    Hi Cmich,

    > ERROR:  function to_date(integer, unknown) does not exist

    Please perform a CVS update of the /packages/intranet-timesheet2 to fix the issue.

    Thanks for reporting!
    Frank

     
  • CMich
    CMich
    2012-03-02

    bash-4.1$ psql -f upgrade-4.0.3.0.2-4.0.3.0.3.sql
    psql:upgrade-4.0.3.0.2-4.0.3.0.3.sql:3: NOTICE:  adding missing FROM-clause entry for table "acs_log_id_seq"
    LINE 1: …ogs (log_id, log_level, log_key, message) values (acs_log_id…
                                                                 ^
    QUERY:  insert into acs_logs (log_id, log_level, log_key, message) values (acs_log_id_seq.nextval, 'debug',  $1 ,  $2 )
    CONTEXT:  PL/pgSQL function "acs_log__debug" line 5 at SQL statement
    acs_log__debug


                  0
    (1 row)

    CREATE FUNCTION
    inline_0


            0
    (1 row)

    DROP FUNCTION
    CREATE FUNCTION
    psql:upgrade-4.0.3.0.2-4.0.3.0.3.sql:70: ERROR:  column "item_project_member_hourly_cost" does not exist
    LINE 1: …r_id is not null and item_cost_type_id = 3736 and item_proje…
                                                                 ^
    QUERY:   select * from im_planning_items where item_project_member_id is not null and item_cost_type_id = 3736 and item_project_member_hourly_cost is null
    CONTEXT:  PL/pgSQL function "inline_0" line 4 at FOR over SELECT rows
    DROP FUNCTION
    CREATE FUNCTION
    bash-4.1$

     
  • CMich
    CMich
    2012-03-09

    Any ideas on that error?  I i try to run upgrade script for this through project open itself I get a server error 500.

     
  • Frank Bergmann
    Frank Bergmann
    2012-03-09

    Hi Cmich,

    The issue should be fixed in CVS with an upgrade script in intranet-planning.
    Please update and execute.

    Cheers,
    Frank