System using Postgres SQL 8.1.4-1 and Perl DB Module is 1.32.5 and got the following error message when execute the Warehouse Loader. Thanks for your help.
Found 1 day to process: 2007-03-13
Loading day '2007-03-13' in the warehouse
Found 2 sessions in day 2007-03-13
Use of uninitialized value in concatenation (.) or string at ./htminer_warehouse_loader line 570.
Use of uninitialized value in concatenation (.) or string at ./htminer_warehouse_loader line 570.
Use of uninitialized value in concatenation (.) or string at ./htminer_warehouse_loader line 570.
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "error_facts_2007_03_pkey" for table "error_facts_2007_03"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "page_facts_2007_03_pkey" for table "page_facts_2007_03"
Use of uninitialized value in concatenation (.) or string at ./htminer_warehouse_loader line 621.
DBD::Pg::db table_info failed: ERROR: syntax error at or near ")" at character 796 at ./htminer_warehouse_loader line 623.
WARNING: No components found updating views error_facts.
Use of uninitialized value in concatenation (.) or string at ./htminer_warehouse_loader line 621.
DBD::Pg::db table_info failed: ERROR: syntax error at or near ")" at character 795 at ./htminer_warehouse_loader line 623.
WARNING: No components found updating views page_facts.
Use of uninitialized value in concatenation (.) or string at ./htminer_warehouse_loader line 521.
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_2007_pkey" for table "users_2007"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "hosts_2007_pkey" for table "hosts_2007"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "locations_2007_pkey" for table "locations_2007"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "urls_2007_pkey" for table "urls_2007"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "referers_2007_pkey" for table "referers_2007"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "user_agents_2007_pkey" for table "user_agents_2007"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sessions_2007_pkey" for table "sessions_2007"
NOTICE: CREATE TABLE / UNIQUE will create implicit index "sessions_2007_oltp_id_session_key" for table "sessions_2007"
1/2
Can't locate object method "last_insert_id" via package "DBI::db" at ./htminer_warehouse_loader line 693.
Logged In: YES
user_id=83598
Originator: NO
Can you tell me what is your operating system and the version of DBI perl module?