Donate Share

]project-open[ - Service Management

Subscribe

How to change port from default 8080

You are viewing a single message from this topic. View all messages.

  1. 2009-11-04 21:51:41 UTC

    NEXT after reboot, logged in, Admin >> Enabled ASUS >> Cleanup Demo Data [Here I am copying the error via the HTML code as screen render was broken]

  2. Cleanup existing security tokens. A new set of tokens will be generated with the next server restart

  3. Cleanup multi-value attributes.
  4. Cleanup bulletin board email alersts
  5. Cleanup classified ads
  6. Cleanup user calendars
  7. Cleanup entrantstablename
  8. Cleanup spam history
  9. Cleanup calendar items
    • Cleanup calpartyprefs
    • Cleanup calitems
    • Cleanup calitemtypes
    • Cleanup acsevents
    • Cleanup acsactivities
    • Cleanup recurrences
    • Cleanup timespans
    • Cleanup timeintervals
    • Cleanup calendars

    • Cleanup calendar acspermissions
    • Cleanup calendar acsobjects
      . . . . . . . . . . . . .
  10. Cleanup calendarcategories
  11. Cleanup sessions
  12. Cleanup general comments
  13. Cleanup comments
  14. Cleanup links
  15. Cleanup chatmsgs
  16. Cleanup querystrings
  17. Cleanup usercurriculummap
  18. Cleanup usercontentmap
  19. Cleanup usergroupmap
  20. Cleanup usersinterests
  21. Cleanup users_charges

  22. Cleanup usersdemographics
  23. Cleanup userspreferences
  24. Cleanup userscontact
  25. Cleanup imcomponentpluginusermap
  26. Cleanup Content Repository
    • Cleanup acsmailbodyheaders
    • Cleanup acsmailbodies
    • Cleanup acsmailbodyheaders
    • Cleanup acsmailgcobjects
    • Cleanup acsmaillinks
    • Cleanup acsmailmultipartparts
    • Cleanup acsmailmultiparts
    • Cleanup acsmessages
  27. Cleanup imhours
  28. Cleanup impayments

  29. Cleanup impaymentsaudit
  30. Cleanup dangelingcosts
  31. Cleanup imhours - set cost_id = null
  32. Cleanup costs
    . HTTP/1.1 500 Internal Server Error Server: AOLserver/4.5 MIME-Version: 1.0 Date: Wed, 04 Nov 2009 00:00:20 GMT Content-Type: text/html; charset=utf-8 Content-Length: 48957 Connection: close

    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:  relation "imsearchobjects"
    does not exist
    CONTEXT:  SQL statement "SELECT  count(*) from
    im_search_objects where object_id =  $1  and
    object_type_id =  $2 "

    PL/pgSQL function "imsearchupdate" line 19 at select into variables SQL statement "SELECT imsearchupdate( $1 , 'improject', $2 , $3 )" PL/pgSQL function "improjectstsearch" line 27 at perform SQL statement "update improjects set costcachedirty = now() where projectid = $1 " PL/pgSQL function "imcostprojectcacheinvalidator" line 28 at SQL statement SQL statement "SELECT imcostprojectcache_invalidator ( $1 )"

    PL/pgSQL function "imcostprojectcachedeltr" line 3 at perform SQL statement "delete from imcosts where costid = $1 " PL/pgSQL function "imcostdelete" line 5 at SQL statement SQL statement "SELECT im_costdelete( $1 )" PL/pgSQL function "im_invoicedelete" line 17 at perform SQL statement "SELECT im_invoicedelete( $1 )"

    PL/pgSQL function "imtimesheetinvoice__delete" line 25 at perform ")

    ERROR: relation "imsearchobjects" does not exist CONTEXT: SQL statement "SELECT count(*) from im_search_objects where object_id = $1 and object_type_id = $2 " PL/pgSQL function "im_search_update" line 19 at select into variables SQL statement "SELECT im_search_update( $1 , 'im_project', $2 , $3 )" PL/pgSQL function "im_projects_tsearch" line 27 at perform SQL statement "update im_projects set cost_cache_dirty = now() where project_id = $1 "

    PL/pgSQL function "imcostprojectcacheinvalidator" line 28 at SQL statement SQL statement "SELECT imcostprojectcacheinvalidator ( $1 )" PL/pgSQL function "imcostprojectcachedeltr" line 3 at perform SQL statement "delete from imcosts where costid = $1 " PL/pgSQL function "imcostdelete" line 5 at SQL statement SQL statement "SELECT im_costdelete( $1 )"

    PL/pgSQL function "iminvoicedelete" line 17 at perform SQL statement "SELECT im_invoicedelete( $1 )" PL/pgSQL function "imtimesheet_invoice__delete" line 25 at perform

    SQL: select imtimesheetinvoicedelete(12977) while executing "nspgbind 0or1row nsdb0 {select imtimesheetinvoicedelete(12977)}" ("uplevel" body line 1) invoked from within

    "uplevel $ulevel [list nspgbind $type $db $sql]" ("postgresql" arm line 2) invoked from within "switch $driverkey { oracle { return [uplevel $ulevel [list nsora $type $db $sql] $args] } ..." invoked from within "dbexec 0or1row $db $fullname $sql" invoked from within "set selection [dbexec 0or1row $db $full_name $sql]"

    ("uplevel" body line 2) invoked from within "uplevel 1 $codeblock " invoked from within "dbwithhandle -dbn $dbn db { set selection [dbexec 0or1row $db $fullname $sql] }" (procedure "dbstring" line 8) invoked from within "dbstring delcost "select imtimesheetinvoice__delete(12977)""

    ("uplevel" body line 2) invoked from within "uplevel 1 $script" ("postgresql" arm line 5) invoked from within "switch $driverkey { postgresql { set script " dbstring $sqlname \"select $sql\"

           "
           upleve..."
    

    (procedure "imexecdml" line 7) invoked from within "imexecdml delcost "${objecttype}__delete($cost_id)"" ("foreach" body line 12) invoked from within

    "foreach costinfo $costinfos { set costid [lindex $costinfo 0] set objecttype [lindex $costinfo 1]

    if {0 == [expr $cnt % 13]} { ..." ("uplevel" body line 334) invoked from within "uplevel { # /packages/intranet-core/www/admin/cleanup-demo/ cleanup-demo-data-2.tcl #

    Copyright (C) 2003 - 2006 ]project-open[

    #

    This progr..."

    (procedure "code::tcl::/web/projop/packages/intranet-core/www/admin/clea..." 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 adpinit t..." (procedure "adpprepare" line 2) invoked from within "adpprepare " (procedure "template::adpparse" line 30) invoked from within

    "template::adpparse [file root [adconn file]] {}" (procedure "adpparseadconnfile" line 5) invoked from within "$handler" ("uplevel" body line 2) invoked from within "uplevel $code" invoked from within

    "adtry { $handler } adscriptabort val { # do nothing }" invoked from within "rpserveconcretefile [adconn file]" (procedure "rpserveabstractfile" line 60) invoked from within "rpserveabstract_file "$root/$path"" ("uplevel" body line 2) invoked from within

    "uplevel $code" invoked from within "adtry { rpserveabstractfile "$root/$path" set tclurl2file([adconn url]) [adconn file] set tclurl2path_info..."

< Previous | 1 | Next >

Add a Reply

This forum does not allow anonymous participation.

Log in to add a reply. Not registered? Create an account to participate and receive email updates when replies are posted to this topic.