Global Options: Version='07.01.0008', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
                disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0
                text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
                extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='OTHER'
conn=36389440, query=' '
conn=36389440, query='set DateStyle to 'ISO''
conn=36389440, query='set geqo to 'OFF''
conn=36389440, query='set ksqo to 'ON''
conn=36389440, query='select oid from pg_type where typname='lo''
    [ fetched 1 rows ]
    [ Large Object oid = 19959 ]
conn=36389440, query='select version()'
    [ fetched 1 rows ]
    [ PostgreSQL version string = 'PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96' ]
    [ PostgreSQL version number = '7.1' ]
conn=36389440, PGAPI_DriverConnect(out)='DSN=PostgreSQL;DATABASE=timetrack;SERVER=10.100.10.100;PORT=5432;UID=time;PWD=tmtr23;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=8190;DEBUG=1;COMMLOG=1;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=0;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_;'
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query='select PROJ_NAME, PROJ_PROP_AUTHOR, PROJ_LAST_SAVED from MSP_PROJECTS'
ERROR from backend during send_query: 'ERROR:  Relation 'msp_projects' does not exist'
STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while executing the query'
                 ------------------------------------------------------------
                 hdbc=36389440, stmt=37495712, result=37493008
                 manual_result=0, prepare=1, internal=0
                 bindings=37490720, bindings_allocated=3
                 parameters=0, parameters_allocated=0
                 statement_type=0, statement='select PROJ_NAME, PROJ_PROP_AUTHOR, PROJ_LAST_SAVED from MSP_PROJECTS'
                 stmt_with_params='select PROJ_NAME, PROJ_PROP_AUTHOR, PROJ_LAST_SAVED from MSP_PROJECTS'
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
                 cursor_name='SQL_CUR023C23A0'
                 ----------------QResult Info -------------------------------
                 fields=37490016, manual_tuples=0, backend_tuples=0, tupleField=0, conn=0
                 fetch_count=0, fcount=0, num_fields=0, cursor='(NULL)'
                 message='(NULL)', command='(NULL)', notice='(NULL)'
                 status=7, inTuples=0
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR:  Relation 'msp_projects' does not exist'
            ------------------------------------------------------------
            henv=37490544, conn=36389440, status=1, num_stmts=48
            sock=37490496, stmts=37496992, lobj_type=19959
            ---------------- Socket Info -------------------------------
            socket=284, reverse=0, errornumber=0, errormsg='(NULL)'
            buffer_in=36400324, buffer_out=36404424
            buffer_filled_in=50, buffer_filled_out=0, buffer_read_in=50
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_PROJECTS' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query='create table MSP_PROJECTS ( PROJ_ID  int4 , PROJ_NAME varchar ( 255 )  , PROJ_PROP_AUTHOR  text , PROJ_OPT_CALC_ACT_COSTS  char , PROJ_PROP_CATEGORY  text , PROJ_PROP_COMPANY  text , PROJ_OPT_CRITICAL_SLACK_LIMIT  int4 , PROJ_OPT_CURRENCY_DIGITS  int2 , PROJ_OPT_CURRENCY_POSITION  int2 , PROJ_OPT_CURRENCY_SYMBOL varchar ( 20 )  , PROJ_OPT_NEW_ARE_EFFORT_DRIVEN  char , PROJ_INFO_CURRENT_DATE  datetime , PROJ_OPT_DEF_FINISH_TIME  datetime , PROJ_OPT_DEF_FIX_COST_ACCRUAL  int2 , PROJ_OPT_MINUTES_PER_DAY  int4 , PROJ_OPT_MINUTES_PER_WEEK  int4 , PROJ_OPT_DEF_OVT_RATE  float8 , PROJ_OPT_DEF_STD_RATE  float8 , PROJ_OPT_DEF_START_TIME  datetime , PROJ_OPT_DEF_TASK_TYPE  int2 , PROJ_OPT_DUR_ENTRY_FMT  int2 , PROJ_INFO_FINISH_DATE  datetime , PROJ_OPT_HONOR_CONSTRAINTS  char , PROJ_PROP_KEYWORDS  text , PROJ_LAST_SAVED  datetime , PROJ_PROP_MANAGER  text , PROJ_OPT_MULT_CRITICAL_PATHS  char , PROJ_CREATION_DATE  datetime , PROJ_POOL_ATTACHED_TO  text , PROJ_INFO_CAL_NAME  text , PROJ_IS_RES_POOL  char , PROJ_INFO_SCHED_FROM  int2 , PROJ_OPT_SPLIT_IN_PROGRESS  char , PROJ_OPT_SPREAD_ACT_COSTS  char , PROJ_OPT_SPREAD_PCT_COMP  char , PROJ_INFO_START_DATE  datetime , PROJ_INFO_STATUS_DATE  datetime , PROJ_PROP_SUBJECT  text , PROJ_PROP_TITLE  text , PROJ_OPT_TASK_UPDATES_RES  char , PROJ_OPT_WORK_ENTRY_FMT  int2 , PROJ_OPT_CALC_SUB_AS_SUMMARY  char , PROJ_OPT_WEEK_START_DAY  int2 , PROJ_OPT_FY_START_MONTH  int2 , PROJ_OPT_FY_USE_START_YR  char , PROJ_OPT_DAYS_PER_MONTH  int2 , PROJ_OPT_NEW_TASK_EST  char , PROJ_OPT_SHOW_EST_DUR  char , PROJ_OPT_EXPAND_TIMEPHASED  char , PROJ_EXT_EDITED_DATE  char , PROJ_EXT_EDITED_DUR  char , PROJ_EXT_EDITED_NUM  char , PROJ_EXT_EDITED_FLAG  char , PROJ_EXT_EDITED_CODE  char , PROJ_EXT_EDITED_TEXT  char , PROJ_EXT_EDITED  char , PROJ_DATA_SOURCE varchar ( 128 )  , PROJ_READ_ONLY varchar ( 10 )  , PROJ_READ_WRITE varchar ( 4 )  , PROJ_READ_COUNT varchar ( 10 )  , PROJ_LOCKED varchar ( 4 )  , PROJ_MACHINE_ID varchar ( 100 )  , RESERVED_BINARY_DATA  lo ) '
conn=36389440, query=' create unique index I_MSP_PROJECTS on MSP_PROJECTS (PROJ_ID) '
conn=36389440, query=' create unique index I_PROJ_NAME on MSP_PROJECTS (PROJ_NAME) '
conn=36389440, query=' select RESERVED_BINARY_DATA from MSP_PROJECTS   where       PROJ_NAME  = 'Tam45''
    [ fetched 0 rows ]
conn=36389440, query='select PROJ_READ_COUNT , PROJ_LOCKED, PROJ_READ_WRITE, PROJ_READ_ONLY, PROJ_ID, PROJ_MACHINE_ID, PROJ_DATA_SOURCE from MSP_PROJECTS where PROJ_NAME = 'Tam45' '
    [ fetched 0 rows ]
conn=36389440, query='select max(PROJ_ID) from MSP_PROJECTS'
    [ fetched 1 rows ]
conn=36389440, query='select PROJ_READ_COUNT , PROJ_LOCKED, PROJ_READ_WRITE, PROJ_READ_ONLY, PROJ_ID, PROJ_MACHINE_ID, PROJ_DATA_SOURCE from MSP_PROJECTS where PROJ_NAME = 'Tam45' '
    [ fetched 0 rows ]
conn=36389440, query='insert into MSP_PROJECTS (PROJ_NAME, PROJ_ID, PROJ_READ_COUNT, PROJ_LOCKED, PROJ_READ_WRITE, PROJ_READ_ONLY , PROJ_MACHINE_ID,PROJ_DATA_SOURCE) values ( 'Tam45',1, '0', '0', '0', '0', 'SNOOPY', 'PostgreSQL') '
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_NUMBER_FIELDS' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query='create table MSP_NUMBER_FIELDS (PROJ_ID int4, NUM_CATEGORY int4, NUM_REF_UID int4,  NUM_FIELD_ID int4, NUM_VALUE float8) '
conn=36389440, query='create unique index I_MSP_NUMBER_FIELDS on MSP_NUMBER_FIELDS (PROJ_ID,NUM_CATEGORY,NUM_REF_UID,NUM_FIELD_ID)'
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_TEXT_FIELDS' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query=' create table MSP_TEXT_FIELDS (PROJ_ID int4, TEXT_CATEGORY int4, TEXT_REF_UID int4,  TEXT_FIELD_ID int4 , TEXT_VALUE varchar(255)) '
conn=36389440, query='create unique index I_MSP_TEXT_FIELDS on MSP_TEXT_FIELDS (PROJ_ID,TEXT_CATEGORY,TEXT_REF_UID,TEXT_FIELD_ID)'
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_DATE_FIELDS' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query='create table MSP_DATE_FIELDS (PROJ_ID int4, DATE_CATEGORY int4, DATE_REF_UID int4,  DATE_FIELD_ID int4, DATE_VALUE datetime) '
conn=36389440, query='create unique index I_MSP_DATE_FIELDS on MSP_DATE_FIELDS (PROJ_ID,DATE_CATEGORY,DATE_REF_UID,DATE_FIELD_ID)'
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_DURATION_FIELDS' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query=' create table MSP_DURATION_FIELDS (PROJ_ID  int4, DUR_CATEGORY int4, DUR_REF_UID int4,  DUR_FIELD_ID int4 , DUR_VALUE int4, DUR_FMT int2 ) '
conn=36389440, query='create unique index I_MSP_DURATION_FIELDS on MSP_DURATION_FIELDS (PROJ_ID,DUR_CATEGORY,DUR_REF_UID,DUR_FIELD_ID)'
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_NUMBER_FIELDS' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_FLAG_FIELDS' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query='create table MSP_FLAG_FIELDS (PROJ_ID int4, FLAG_CATEGORY int4, FLAG_REF_UID int4,  FLAG_FIELD_ID int4, FLAG_VALUE char) '
conn=36389440, query='create unique index I_MSP_FLAG_FIELDS on MSP_FLAG_FIELDS (PROJ_ID,FLAG_CATEGORY,FLAG_REF_UID,FLAG_FIELD_ID)'
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_CODE_FIELDS' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query='create table MSP_CODE_FIELDS (PROJ_ID int4, CODE_CATEGORY int4, CODE_REF_UID int4,  CODE_FIELD_ID int4, CODE_UID int4) '
conn=36389440, query='create unique index I_MSP_CODE_FIELDS on MSP_CODE_FIELDS (PROJ_ID,CODE_CATEGORY,CODE_REF_UID,CODE_FIELD_ID)'
conn=36389440, query='select PROJ_LAST_SAVED from MSP_PROJECTS where PROJ_ID = 1'
    [ fetched 1 rows ]
conn=36389440, query='update MSP_PROJECTS set PROJ_READ_COUNT = '1', PROJ_LOCKED = '1', PROJ_READ_WRITE = '1' , PROJ_READ_ONLY = '1' ,  PROJ_MACHINE_ID = 'SNOOPY',  PROJ_DATA_SOURCE = 'PostgreSQL' where PROJ_NAME = 'Tam45' and (PROJ_READ_COUNT = '0' or PROJ_READ_COUNT IS NULL) and (PROJ_READ_ONLY = '0' or PROJ_READ_ONLY IS NULL)'
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_TASKS' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query=' create table MSP_TASKS ( RESERVED_DATA char(1), PROJ_ID int4   , TASK_ACWP float8 , TASK_BCWP float8 , TASK_BCWS float8 , TASK_DUR_VAR int4 , TASK_FINISH_VAR int4 , TASK_OUTLINE_NUM varchar  ( 255 ) , TASK_START_VAR int4 , TASK_IS_OVERALLOCATED char , TASK_OVT_WORK float8 , TASK_VAC float8 , TASK_REG_WORK float8 , TASK_NUM_OBJECTS int4 , TASK_TOTAL_SLACK int4 , EXT_EDIT_REF_DATA varchar  ( 255 ) , TASK_UID int4 , TASK_ID int4 , TASK_HAS_LINKED_FIELDS char , TASK_IS_MILESTONE char , TASK_IS_CRITICAL char , TASK_IS_SUMMARY char , TASK_IS_SUBPROJ char , TASK_IS_MARKED char , TASK_IGNORES_RES_CAL char , TASK_IS_ROLLED_UP char , TASK_IS_FROM_FINISH_SUBPROJ char , TASK_BAR_IS_HIDDEN char , TASK_IS_RECURRING char , TASK_IS_RECURRING_SUMMARY char , TASK_IS_EXTERNAL char , TASK_IS_EFFORT_DRIVEN char , TASK_IS_COLLAPSED char , TASK_HAS_NOTES char , TASK_IS_READONLY_SUBPROJ char , TASK_LEVELING_CAN_SPLIT char , TASK_LEVELING_ADJUSTS_ASSN char , TASK_DUR_IS_EST char , TASK_EARLY_FINISH datetime , TASK_LATE_START datetime , TASK_STOP_DATE datetime , TASK_RESUME_DATE datetime , TASK_FREE_SLACK int4 , TASK_OUTLINE_LEVEL int2 , TASK_DUR int4 , TASK_DUR_FMT int2 , TASK_ACT_DUR int4 , TASK_REM_DUR int4 , TASK_BASE_DUR int4 , TASK_BASE_DUR_FMT int2 , TASK_CONSTRAINT_TYPE int2 , TASK_LEVELING_DELAY int4 , TASK_LEVELING_DELAY_FMT int2 , TASK_START_DATE datetime , TASK_FINISH_DATE datetime , TASK_ACT_START datetime , TASK_ACT_FINISH datetime , TASK_BASE_START datetime , TASK_BASE_FINISH datetime , TASK_CONSTRAINT_DATE datetime , TASK_PRIORITY int2 , TASK_PCT_COMP int2 , TASK_PCT_WORK_COMP int2 , TASK_TYPE int2 , TASK_FIXED_COST_ACCRUAL int2 , TASK_CREATION_DATE datetime , TASK_PRELEVELED_START datetime , TASK_PRELEVELED_FINISH datetime , TASK_EARLY_START datetime , TASK_LATE_FINISH datetime , TASK_CAL_UID int4 , TASK_DEADLINE datetime , TASK_WORK float8 , TASK_BASE_WORK float8 , TASK_ACT_WORK float8 , TASK_REM_WORK float8 , TASK_COST float8 , TASK_FIXED_COST float8 , TASK_ACT_COST float8 , TASK_REM_COST float8 , TASK_BASE_COST float8 , TASK_ACT_OVT_WORK float8 , TASK_REM_OVT_WORK float8 , TASK_OVT_COST float8 , TASK_ACT_OVT_COST float8 , TASK_REM_OVT_COST float8 , TASK_WBS varchar  ( 255 ) , TASK_NAME varchar  ( 255 ) , TASK_WBS_RIGHTMOST_LEVEL varchar  ( 255 ) , TASK_RTF_NOTES lo ) '
conn=36389440, query='create unique index I_MSP_TASKS on MSP_TASKS (PROJ_ID,TASK_UID)'
conn=36389440, query=' create table MSP_TIMEPHASED_DATA ( RESERVED_DATA char(1), PROJ_ID int4   , TD_UID int4 , TD_FIELD_ID int2 , TD_CATEGORY int2 , TD_REF_UID int4 , TD_START datetime , TD_FINISH datetime , TD_UNITS int2 , TD_VALUE1 float8 , TD_VALUE2 float8 , TD_VALUE3 float8 , TD_VALUE4 float8 , TD_VALUE5 float8 , TD_VALUE6 float8 , TD_VALUE7 float8 , TD_EXT_EDITED char ) '
conn=36389440, query='create unique index I_MSP_TIMEPHASED_DATA on MSP_TIMEPHASED_DATA (PROJ_ID,TD_UID)'
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_RESOURCES' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query=' create table MSP_RESOURCES ( RESERVED_DATA char(1), PROJ_ID int4   , RES_ACWP float8 , RES_BCWP float8 , RES_BCWS float8 , RES_NUM_OBJECTS int4 , EXT_EDIT_REF_DATA varchar  ( 255 ) , RES_UID int4 , RES_ID int4 , RES_HAS_LINKED_FIELDS char , RES_IS_OVERALLOCATED char , RES_TYPE char , RES_HAS_NOTES char , RES_CAN_LEVEL char , RES_STD_RATE_FMT int2 , RES_OVT_RATE_FMT int2 , RES_ACCRUE_AT int2 , RES_WORKGROUP_MESSAGING int2 , RES_CAL_UID int4 , RES_AVAIL_FROM datetime , RES_AVAIL_TO datetime , RES_STD_RATE float8 , RES_OVT_RATE float8 , RES_MAX_UNITS float8 , RES_WORK float8 , RES_ACT_WORK float8 , RES_BASE_WORK float8 , RES_OVT_WORK float8 , RES_COST_PER_USE float8 , RES_REM_WORK float8 , RES_REG_WORK float8 , RES_ACT_OVT_WORK float8 , RES_REM_OVT_WORK float8 , RES_PEAK float8 , RES_ACT_COST float8 , RES_COST float8 , RES_BASE_COST float8 , RES_REM_COST float8 , RES_OVT_COST float8 , RES_ACT_OVT_COST float8 , RES_REM_OVT_COST float8 , RES_NAME varchar  ( 255 ) , RES_INITIALS varchar  ( 255 ) , RES_PHONETICS varchar  ( 255 ) , RES_MATERIAL_LABEL varchar  ( 255 ) , RES_RTF_NOTES lo ) '
conn=36389440, query='create unique index I_MSP_RESOURCES on MSP_RESOURCES (PROJ_ID,RES_UID)'
conn=36389440, query=' create table MSP_RESOURCE_RATES ( RESERVED_DATA char(1), PROJ_ID int4   , RR_UID int4 , RES_UID int4 , RR_RATE_TABLE int2 , RR_FROM_DATE datetime , RR_TO_DATE datetime , RR_STD_RATE float8 , RR_STD_RATE_FMT int2 , RR_OVT_RATE float8 , RR_OVT_RATE_FMT int2 , RR_PER_USE_COST float8 ) '
conn=36389440, query='create unique index I_MSP_RESOURCE_RATES on MSP_RESOURCE_RATES (PROJ_ID,RR_UID)'
conn=36389440, query=' create table MSP_AVAILABILITY ( RESERVED_DATA char(1), PROJ_ID int4   , AVAIL_UID int4 , RES_UID int4 , AVAIL_FROM datetime , AVAIL_TO datetime , AVAIL_UNITS float8 ) '
conn=36389440, query='create unique index I_MSP_AVAILABILITY on MSP_AVAILABILITY (PROJ_ID,AVAIL_UID)'
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_CALENDARS' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query=' create table MSP_CALENDARS ( RESERVED_DATA char(1), PROJ_ID int4   , CAL_UID int4 , CAL_BASE_UID int4 , RES_UID int4 , CAL_IS_BASE_CAL char , CAL_NAME varchar  ( 255 ) ) '
conn=36389440, query='create unique index I_MSP_CALENDARS on MSP_CALENDARS (PROJ_ID,CAL_UID)'
conn=36389440, query=' create table MSP_CALENDAR_DATA ( RESERVED_DATA char(1), PROJ_ID int4   , CD_UID int4 , CAL_UID int4 , CD_DAY_OR_EXCEPTION int2 , CD_WORKING int2 , CD_FROM_DATE datetime , CD_TO_DATE datetime , CD_FROM_TIME1 datetime , CD_TO_TIME1 datetime , CD_FROM_TIME2 datetime , CD_TO_TIME2 datetime , CD_FROM_TIME3 datetime , CD_TO_TIME3 datetime , CD_FROM_TIME4 datetime , CD_TO_TIME4 datetime , CD_FROM_TIME5 datetime , CD_TO_TIME5 datetime ) '
conn=36389440, query='create unique index I_MSP_CALENDAR_DATA on MSP_CALENDAR_DATA (PROJ_ID,CD_UID)'
conn=36389440, query=' create table MSP_FIELD_ATTRIBUTES ( RESERVED_DATA char(1), PROJ_ID int4   , ATTRIB_FIELD_ID int4 , ATTRIB_ID int4 , ATTRIB_VALUE int4 , AS_ID int4 , ATTRIB_EXT_EDITED char ) '
conn=36389440, query='create unique index I_MSP_FIELD_ATTRIBUTES on MSP_FIELD_ATTRIBUTES (PROJ_ID,ATTRIB_FIELD_ID,ATTRIB_ID)'
conn=36389440, query=' create table MSP_ATTRIBUTE_STRINGS ( RESERVED_DATA char(1), PROJ_ID int4   , AS_ID int4 , AS_POSITION int4 , AS_VALUE varchar  ( 255 ) ) '
conn=36389440, query='create unique index I_MSP_ATTRIBUTE_STRINGS on MSP_ATTRIBUTE_STRINGS (PROJ_ID,AS_ID,AS_POSITION)'
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_ASSIGNMENTS' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query=' create table MSP_ASSIGNMENTS ( RESERVED_DATA char(1), PROJ_ID int4   , ASSN_ACT_FINISH datetime , ASSN_ACT_START datetime , ASSN_ACWP float8 , ASSN_BCWP float8 , ASSN_BCWS float8 , ASSN_RES_TYPE char , ASSN_IS_OVERALLOCATED char , ASSN_WORK_CONTOUR int2 , ASSN_START_VAR int4 , ASSN_FINISH_VAR int4 , ASSN_UPDATE_NEEDED char , EXT_EDIT_REF_DATA varchar  ( 255 ) , ASSN_UID int4 , ASSN_HAS_LINKED_FIELDS char , ASSN_IS_CONFIRMED char , ASSN_RESPONSE_PENDING char , ASSN_HAS_NOTES char , ASSN_TEAM_STATUS_PENDING char , TASK_UID int4 , RES_UID int4 , ASSN_START_DATE datetime , ASSN_FINISH_DATE datetime , ASSN_DELAY int4 , ASSN_DELAY_FMT int2 , ASSN_LEVELING_DELAY int4 , ASSN_COST_RATE_TABLE int2 , ASSN_BASE_START datetime , ASSN_BASE_FINISH datetime , ASSN_MATERIAL_RATE_FMT int2 , ASSN_UNITS float8 , ASSN_WORK float8 , ASSN_ACT_WORK float8 , ASSN_REG_WORK float8 , ASSN_REM_WORK float8 , ASSN_BASE_WORK float8 , ASSN_COST float8 , ASSN_ACT_COST float8 , ASSN_REM_COST float8 , ASSN_BASE_COST float8 , ASSN_BASE_COST_PER_USE float8 , ASSN_OVT_WORK float8 , ASSN_ACT_OVT_WORK float8 , ASSN_REM_OVT_WORK float8 , ASSN_ACT_OVT_COST float8 , ASSN_REM_OVT_COST float8 , ASSN_RTF_NOTES lo ) '
conn=36389440, query='create unique index I_MSP_ASSIGNMENTS on MSP_ASSIGNMENTS (PROJ_ID,ASSN_UID)'
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_LINKS' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query=' create table MSP_LINKS ( RESERVED_DATA char(1), PROJ_ID int4   , EXT_EDIT_REF_DATA varchar  ( 255 ) , LINK_UID int4 , LINK_IS_CROSS_PROJ char , LINK_PRED_UID int4 , LINK_SUCC_UID int4 , LINK_TYPE int2 , LINK_LAG_FMT int2 , LINK_LAG int4 ) '
conn=36389440, query='create unique index I_MSP_LINKS on MSP_LINKS (PROJ_ID,LINK_UID)'
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_OUTLINE_CODES' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query=' create table MSP_OUTLINE_CODES ( RESERVED_DATA char(1), PROJ_ID int4   , CODE_UID int4 , OC_PARENT int4 , OC_FIELD_ID int4 , OC_NAME varchar  ( 255 ) , OC_DESCRIPTION varchar  ( 255 ) ) '
conn=36389440, query='create unique index I_MSP_OUTLINE_CODES on MSP_OUTLINE_CODES (PROJ_ID,CODE_UID)'
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_RESOURCE_RATES' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query=' create table MSP_RESOURCE_RATES ( RESERVED_DATA char(1), PROJ_ID int4   , RR_UID int4 , RES_UID int4 , RR_RATE_TABLE int2 , RR_FROM_DATE datetime , RR_TO_DATE datetime , RR_STD_RATE float8 , RR_STD_RATE_FMT int2 , RR_OVT_RATE float8 , RR_OVT_RATE_FMT int2 , RR_PER_USE_COST float8 ) '
ERROR from backend during send_query: 'ERROR:  Relation 'msp_resource_rates' already exists'
STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while executing the query'
                 ------------------------------------------------------------
                 hdbc=36389440, stmt=37490048, result=37493008
                 manual_result=0, prepare=0, internal=0
                 bindings=37495952, bindings_allocated=15
                 parameters=0, parameters_allocated=0
                 statement_type=4, statement=' create table MSP_RESOURCE_RATES ( RESERVED_DATA char(1), PROJ_ID int4   , RR_UID int4 , RES_UID int4 , RR_RATE_TABLE int2 , RR_FROM_DATE datetime , RR_TO_DATE datetime , RR_STD_RATE float8 , RR_STD_RATE_FMT int2 , RR_OVT_RATE float8 , RR_OVT_RATE_FMT int2 , RR_PER_USE_COST float8 ) '
                 stmt_with_params=' create table MSP_RESOURCE_RATES ( RESERVED_DATA char(1), PROJ_ID int4   , RR_UID int4 , RES_UID int4 , RR_RATE_TABLE int2 , RR_FROM_DATE datetime , RR_TO_DATE datetime , RR_STD_RATE float8 , RR_STD_RATE_FMT int2 , RR_OVT_RATE float8 , RR_OVT_RATE_FMT int2 , RR_PER_USE_COST float8 ) '
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=50, keyset_size=0, cursor_type=3, scroll_concurrency=1
                 cursor_name='SQL_CUR023C0D80'
                 ----------------QResult Info -------------------------------
                 fields=37492976, manual_tuples=0, backend_tuples=0, tupleField=0, conn=0
                 fetch_count=0, fcount=0, num_fields=0, cursor='(NULL)'
                 message='(NULL)', command='(NULL)', notice='(NULL)'
                 status=7, inTuples=0
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR:  Relation 'msp_resource_rates' already exists'
            ------------------------------------------------------------
            henv=37490544, conn=36389440, status=1, num_stmts=48
            sock=37490496, stmts=37496992, lobj_type=19959
            ---------------- Socket Info -------------------------------
            socket=284, reverse=0, errornumber=0, errormsg='(NULL)'
            buffer_in=36400324, buffer_out=36404424
            buffer_filled_in=56, buffer_filled_out=0, buffer_read_in=56
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_RESOURCE_RATES' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_AVAILABILITY' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query=' create table MSP_AVAILABILITY ( RESERVED_DATA char(1), PROJ_ID int4   , AVAIL_UID int4 , RES_UID int4 , AVAIL_FROM datetime , AVAIL_TO datetime , AVAIL_UNITS float8 ) '
ERROR from backend during send_query: 'ERROR:  Relation 'msp_availability' already exists'
STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while executing the query'
                 ------------------------------------------------------------
                 hdbc=36389440, stmt=37490048, result=37493008
                 manual_result=0, prepare=0, internal=0
                 bindings=37495952, bindings_allocated=15
                 parameters=0, parameters_allocated=0
                 statement_type=4, statement=' create table MSP_AVAILABILITY ( RESERVED_DATA char(1), PROJ_ID int4   , AVAIL_UID int4 , RES_UID int4 , AVAIL_FROM datetime , AVAIL_TO datetime , AVAIL_UNITS float8 ) '
                 stmt_with_params=' create table MSP_AVAILABILITY ( RESERVED_DATA char(1), PROJ_ID int4   , AVAIL_UID int4 , RES_UID int4 , AVAIL_FROM datetime , AVAIL_TO datetime , AVAIL_UNITS float8 ) '
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=50, keyset_size=0, cursor_type=3, scroll_concurrency=1
                 cursor_name='SQL_CUR023C0D80'
                 ----------------QResult Info -------------------------------
                 fields=37492976, manual_tuples=0, backend_tuples=0, tupleField=0, conn=0
                 fetch_count=0, fcount=0, num_fields=0, cursor='(NULL)'
                 message='(NULL)', command='(NULL)', notice='(NULL)'
                 status=7, inTuples=0
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR:  Relation 'msp_availability' already exists'
            ------------------------------------------------------------
            henv=37490544, conn=36389440, status=1, num_stmts=48
            sock=37490496, stmts=37496992, lobj_type=19959
            ---------------- Socket Info -------------------------------
            socket=284, reverse=0, errornumber=0, errormsg='(NULL)'
            buffer_in=36400324, buffer_out=36404424
            buffer_filled_in=54, buffer_filled_out=0, buffer_read_in=54
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_AVAILABILITY' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_CALENDAR_DATA' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query=' create table MSP_CALENDAR_DATA ( RESERVED_DATA char(1), PROJ_ID int4   , CD_UID int4 , CAL_UID int4 , CD_DAY_OR_EXCEPTION int2 , CD_WORKING int2 , CD_FROM_DATE datetime , CD_TO_DATE datetime , CD_FROM_TIME1 datetime , CD_TO_TIME1 datetime , CD_FROM_TIME2 datetime , CD_TO_TIME2 datetime , CD_FROM_TIME3 datetime , CD_TO_TIME3 datetime , CD_FROM_TIME4 datetime , CD_TO_TIME4 datetime , CD_FROM_TIME5 datetime , CD_TO_TIME5 datetime ) '
ERROR from backend during send_query: 'ERROR:  Relation 'msp_calendar_data' already exists'
STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while executing the query'
                 ------------------------------------------------------------
                 hdbc=36389440, stmt=37490048, result=37493008
                 manual_result=0, prepare=0, internal=0
                 bindings=37495952, bindings_allocated=15
                 parameters=0, parameters_allocated=0
                 statement_type=4, statement=' create table MSP_CALENDAR_DATA ( RESERVED_DATA char(1), PROJ_ID int4   , CD_UID int4 , CAL_UID int4 , CD_DAY_OR_EXCEPTION int2 , CD_WORKING int2 , CD_FROM_DATE datetime , CD_TO_DATE datetime , CD_FROM_TIME1 datetime , CD_TO_TIME1 datetime , CD_FROM_TIME2 datetime , CD_TO_TIME2 datetime , CD_FROM_TIME3 datetime , CD_TO_TIME3 datetime , CD_FROM_TIME4 datetime , CD_TO_TIME4 datetime , CD_FROM_TIME5 datetime , CD_TO_TIME5 datetime ) '
                 stmt_with_params=' create table MSP_CALENDAR_DATA ( RESERVED_DATA char(1), PROJ_ID int4   , CD_UID int4 , CAL_UID int4 , CD_DAY_OR_EXCEPTION int2 , CD_WORKING int2 , CD_FROM_DATE datetime , CD_TO_DATE datetime , CD_FROM_TIME1 datetime , CD_TO_TIME1 datetime , CD_FROM_TIME2 datetime , CD_TO_TIME2 datetime , CD_FROM_TIME3 datetime , CD_TO_TIME3 datetime , CD_FROM_TIME4 datetime , CD_TO_TIME4 datetime , CD_FROM_TIME5 datetime , CD_TO_TIME5 datetime ) '
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=50, keyset_size=0, cursor_type=3, scroll_concurrency=1
                 cursor_name='SQL_CUR023C0D80'
                 ----------------QResult Info -------------------------------
                 fields=37492976, manual_tuples=0, backend_tuples=0, tupleField=0, conn=0
                 fetch_count=0, fcount=0, num_fields=0, cursor='(NULL)'
                 message='(NULL)', command='(NULL)', notice='(NULL)'
                 status=7, inTuples=0
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR:  Relation 'msp_calendar_data' already exists'
            ------------------------------------------------------------
            henv=37490544, conn=36389440, status=1, num_stmts=48
            sock=37490496, stmts=37496992, lobj_type=19959
            ---------------- Socket Info -------------------------------
            socket=284, reverse=0, errornumber=0, errormsg='(NULL)'
            buffer_in=36400324, buffer_out=36404424
            buffer_filled_in=55, buffer_filled_out=0, buffer_read_in=55
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_CALENDAR_DATA' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_FIELD_ATTRIBUTES' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query=' create table MSP_FIELD_ATTRIBUTES ( RESERVED_DATA char(1), PROJ_ID int4   , ATTRIB_FIELD_ID int4 , ATTRIB_ID int4 , ATTRIB_VALUE int4 , AS_ID int4 , ATTRIB_EXT_EDITED char ) '
ERROR from backend during send_query: 'ERROR:  Relation 'msp_field_attributes' already exists'
STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while executing the query'
                 ------------------------------------------------------------
                 hdbc=36389440, stmt=37490048, result=37493008
                 manual_result=0, prepare=0, internal=0
                 bindings=37495952, bindings_allocated=15
                 parameters=0, parameters_allocated=0
                 statement_type=4, statement=' create table MSP_FIELD_ATTRIBUTES ( RESERVED_DATA char(1), PROJ_ID int4   , ATTRIB_FIELD_ID int4 , ATTRIB_ID int4 , ATTRIB_VALUE int4 , AS_ID int4 , ATTRIB_EXT_EDITED char ) '
                 stmt_with_params=' create table MSP_FIELD_ATTRIBUTES ( RESERVED_DATA char(1), PROJ_ID int4   , ATTRIB_FIELD_ID int4 , ATTRIB_ID int4 , ATTRIB_VALUE int4 , AS_ID int4 , ATTRIB_EXT_EDITED char ) '
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=50, keyset_size=0, cursor_type=3, scroll_concurrency=1
                 cursor_name='SQL_CUR023C0D80'
                 ----------------QResult Info -------------------------------
                 fields=37492976, manual_tuples=0, backend_tuples=0, tupleField=0, conn=0
                 fetch_count=0, fcount=0, num_fields=0, cursor='(NULL)'
                 message='(NULL)', command='(NULL)', notice='(NULL)'
                 status=7, inTuples=0
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR:  Relation 'msp_field_attributes' already exists'
            ------------------------------------------------------------
            henv=37490544, conn=36389440, status=1, num_stmts=48
            sock=37490496, stmts=37496992, lobj_type=19959
            ---------------- Socket Info -------------------------------
            socket=284, reverse=0, errornumber=0, errormsg='(NULL)'
            buffer_in=36400324, buffer_out=36404424
            buffer_filled_in=58, buffer_filled_out=0, buffer_read_in=58
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_FIELD_ATTRIBUTES' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_ATTRIBUTE_STRINGS' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
conn=36389440, query=' create table MSP_ATTRIBUTE_STRINGS ( RESERVED_DATA char(1), PROJ_ID int4   , AS_ID int4 , AS_POSITION int4 , AS_VALUE varchar  ( 255 ) ) '
ERROR from backend during send_query: 'ERROR:  Relation 'msp_attribute_strings' already exists'
STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while executing the query'
                 ------------------------------------------------------------
                 hdbc=36389440, stmt=37490048, result=37493008
                 manual_result=0, prepare=0, internal=0
                 bindings=37495952, bindings_allocated=15
                 parameters=0, parameters_allocated=0
                 statement_type=4, statement=' create table MSP_ATTRIBUTE_STRINGS ( RESERVED_DATA char(1), PROJ_ID int4   , AS_ID int4 , AS_POSITION int4 , AS_VALUE varchar  ( 255 ) ) '
                 stmt_with_params=' create table MSP_ATTRIBUTE_STRINGS ( RESERVED_DATA char(1), PROJ_ID int4   , AS_ID int4 , AS_POSITION int4 , AS_VALUE varchar  ( 255 ) ) '
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=50, keyset_size=0, cursor_type=3, scroll_concurrency=1
                 cursor_name='SQL_CUR023C0D80'
                 ----------------QResult Info -------------------------------
                 fields=37492976, manual_tuples=0, backend_tuples=0, tupleField=0, conn=0
                 fetch_count=0, fcount=0, num_fields=0, cursor='(NULL)'
                 message='(NULL)', command='(NULL)', notice='(NULL)'
                 status=7, inTuples=0
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR:  Relation 'msp_attribute_strings' already exists'
            ------------------------------------------------------------
            henv=37490544, conn=36389440, status=1, num_stmts=48
            sock=37490496, stmts=37496992, lobj_type=19959
            ---------------- Socket Info -------------------------------
            socket=284, reverse=0, errornumber=0, errormsg='(NULL)'
            buffer_in=36400324, buffer_out=36404424
            buffer_filled_in=59, buffer_filled_out=0, buffer_read_in=59
conn=36389440, query='select relname, usename, relkind from pg_class, pg_user where relkind in ('r', 'v') and relname like 'MSP_ATTRIBUTE_STRINGS' and relname !~ '^pg_|^dd_' and usesysid = relowner order by relname'
    [ fetched 0 rows ]
