Menu

#28 Can't locate object method "last_insert_id"

open-accepted
9
2007-03-13
2007-03-13
Tony Cheung
No

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.

Discussion

  • Tony Cheung

    Tony Cheung - 2007-03-13
    • priority: 5 --> 9
     
  • Marco Nenciarini

    • status: open --> open-accepted
     
  • Marco Nenciarini

    Logged In: YES
    user_id=83598
    Originator: NO

    Can you tell me what is your operating system and the version of DBI perl module?

     

Log in to post a comment.

MongoDB Logo MongoDB