ConcourseSuite Support

Support
Corporate
PUBLIC PROFILE

Back to topics

Discuss Installation and Maintenance

Moderator: Matt Rajkowski

CC5, DB2 9.5.2 ESE, IBMJava1.5.0, Apache6.0.14 - installation 3 step error in SEQENCE

You need to be logged in to post messages

This question is unanswered

CC5, DB2 9.5.2 ESE, IBMJava1.5.0, Apache6.0.14 - installation 3 step error in SEQENCE

4/17/2010 5:30 AM EDT

Please help to finish the installation.

Hi,
I've downloaded the 5 users version - https://www.concursive.com/download/concoursesuite/file/2850/0/concourse_war.zip and deployed on tomcat 6.0.14+IBMJava1.5.0 - IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 AIX ppc-32 j9vmap3223-20091104 (JIT enabled) then created the DB2 ESE database wit 32kb page size and UTF-8 encoding and PL collation/country.
The DB2 is working fine:
Database server = DB2/AIX64 9.5.2
DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09052"
with level identifier "03030107".
Informational tokens are "DB2 v9.5.0.2", "s080911", "U820796", and Fix Pack
"2a".
Product is installed at "/opt/IBM/db2/V9".

Then I've started the configuration process and after successful db connection there was a time of tables creation which was ok - the db2 list tables gives me 395 record(s) selected of table names but there is an error displayed in the installer:
An error occurred while trying to create the database schema, the following error was provided: DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: SITES_SITE_ID_SEQ;SEQUENCE.

In the tomcat catalina.out logs we can see:
...
Added Mapping-> ID: fetchUserCalendar, CLASS: org.aspcfs.modules.service.actions.FetchUserCalendar
SetupUtils-> evalScript: jndi:/localhost/centric/WEB-INF/setup/init/database.bsh
Inserting default user...
Inserting default organization...
SetupUtils-> URL protocol: jndi
Reading values for lookup lists
asset_category_draft
field_types
lookup_access_types
lookup_account_types
lookup_asset_status
lookup_call_priority
lookup_call_reminder
lookup_call_result
lookup_call_types
lookup_contactaddress_types
lookup_contactemail_types
lookup_contactphone_types
lookup_contact_types
lookup_contact_source
lookup_creditcard_types
lookup_currency
lookup_delivery_options
lookup_department
lookup_document_store_permission_category
lookup_document_store_role
lookup_document_store_permission
lookup_email_model
lookup_employment_types
lookup_help_features
lookup_hours_reason
lookup_im_types
lookup_im_services
lookup_industry
lookup_locale
lookup_onsite_model
lookup_opportunity_types
lookup_orderaddress_types
lookup_order_source
lookup_order_status
lookup_order_terms
lookup_order_type
lookup_orgaddress_types
lookup_orgemail_types
lookup_orgphone_types
lookup_payment_methods
lookup_payment_status
lookup_phone_model
lookup_product_category_type
lookup_product_conf_result
lookup_product_format
lookup_product_keyword
lookup_product_manufacturer
lookup_product_shipping
lookup_product_ship_time
lookup_product_tax
lookup_product_type
lookup_project_activity
lookup_project_category
lookup_project_loe
lookup_project_role
lookup_project_permission_category
lookup_project_permission
lookup_project_priority
lookup_project_status
lookup_quote_condition
lookup_quote_delivery
lookup_quote_remarks
lookup_quote_source
lookup_quote_status
lookup_quote_terms
lookup_quote_type
lookup_recurring_type
lookup_relationship_types
lookup_response_model
lookup_revenuedetail_types
lookup_revenue_types
lookup_sc_category
lookup_sc_type
lookup_stage
lookup_survey_types
lookup_task_category
lookup_task_loe
lookup_task_priority
lookup_textmessage_types
lookup_ticketsource
lookup_ticket_status
product_option_configurator
search_fields
survey
ticket_level
ticket_priority
ticket_severity
ticket_category_draft
lookup_opportunity_environment
lookup_opportunity_competitors
lookup_opportunity_event_compelling
lookup_opportunity_budget
lookup_duration_type
lookup_step_actions
lookup_asset_materials
lookup_ticket_cause
lookup_ticket_resolution
action_plan_constants
step_action_map
lookup_ticket_task_category
lookup_account_size
lookup_account_stage
lookup_segments
lookup_sub_segment
lookup_site_id
lookup_title
lookup_ticket_state
web_layout
web_style
lookup_payment_gateway
lookup_report_type
lookup_authentication_classes
lookup_container_menu
lookup_graph_type
lookup_contact_stage
lookup_webpage_priority
lookup_sitechange_frequency
lookup_emailaccount_inbox_behavior
lookup_emailserver_types
lookup_kb_status

Inserting values into:
asset_category_draft
field_types
lookup_access_types
lookup_account_types
lookup_asset_status
lookup_call_priority
lookup_call_reminder
lookup_call_result
lookup_call_types
lookup_contactaddress_types
lookup_contactemail_types
lookup_contactphone_types
lookup_contact_types
lookup_contact_source
lookup_creditcard_types
lookup_currency
lookup_delivery_options
lookup_department
lookup_document_store_permission_category
lookup_document_store_role
lookup_document_store_permission
lookup_email_model
lookup_employment_types
lookup_help_features
lookup_hours_reason
lookup_im_types
lookup_im_services
lookup_industry
lookup_locale
lookup_onsite_model
lookup_opportunity_types
lookup_orderaddress_types
lookup_order_source
lookup_order_status
lookup_order_terms
lookup_order_type
lookup_orgaddress_types
lookup_orgemail_types
lookup_orgphone_types
lookup_payment_methods
lookup_payment_status
lookup_phone_model
lookup_product_category_type
lookup_product_conf_result
lookup_product_format
lookup_product_keyword
lookup_product_manufacturer
lookup_product_shipping
lookup_product_ship_time
lookup_product_tax
lookup_product_type
lookup_project_activity
lookup_project_category
lookup_project_loe
lookup_project_role
lookup_project_permission_category
lookup_project_permission
lookup_project_priority
lookup_project_status
lookup_quote_condition
lookup_quote_delivery
lookup_quote_remarks
lookup_quote_source
lookup_quote_status
lookup_quote_terms
lookup_quote_type
lookup_recurring_type
lookup_relationship_types
lookup_response_model
lookup_revenuedetail_types
lookup_revenue_types
lookup_sc_category
lookup_sc_type
lookup_stage
lookup_survey_types
lookup_task_category
lookup_task_loe
lookup_task_priority
lookup_textmessage_types
lookup_ticketsource
lookup_ticket_status
product_option_configurator
search_fields
survey
ticket_level
ticket_priority
ticket_severity
ticket_category_draft
lookup_opportunity_environment
lookup_opportunity_competitors
lookup_opportunity_event_compelling
lookup_opportunity_budget
lookup_duration_type
lookup_step_actions
lookup_asset_materials
lookup_ticket_cause
lookup_ticket_resolution
action_plan_constants
step_action_map
lookup_ticket_task_category
lookup_account_size
lookup_account_stage
lookup_segments
lookup_sub_segment
lookup_site_id
lookup_title
lookup_ticket_state
web_layout
web_style
lookup_payment_gateway
lookup_report_type
lookup_authentication_classes
ERROR [org.aspcfs.modules.setup.actions.Setup] - Inserting default data failed: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DB2INST1.LOOKUP_AUTHEN_CATIONCODE_SEQ
FileUtils-> Destination already exists
INFO [org.aspcfs.controller.ApplicationPrefs] - Saving preferences to file: /opt/cognos/centric_crm/fileLibrary/centric/build.properties
SetupUtils-> Installing Schema: jndi:/localhost/centric/WEB-INF/setup/db2
DatabaseUtils-> ERROR(1), line: 3 message: DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: SITES_SITE_ID_SEQ;SEQUENCE
ERROR [org.aspcfs.modules.setup.actions.Setup] - Inserting default data failed: DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: SITES_SITE_ID_SEQ;SEQUENCE
FileUtils-> Destination already exists
INFO [org.aspcfs.controller.ApplicationPrefs] - Saving preferences to file: /opt/cognos/centric_crm/fileLibrary/centric/build.properties
SetupUtils-> Installing Schema: jndi:/localhost/centric/WEB-INF/setup/db2
DatabaseUtils-> ERROR(1), line: 3 message: DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: SITES_SITE_ID_SEQ;SEQUENCE
ERROR [org.aspcfs.modules.setup.actions.Setup] - Inserting default data failed: DB2 SQL error: SQLCODE: -601, SQLSTATE: 42710, SQLERRMC: SITES_SITE_ID_SEQ;SEQUENCE

- the last few lines shows the errors.

Please help to resolve the issue and complete the installation.

Regards,
Kris.