Re: Fwd: Initial changes for SQL Ledger 3.0.x to LedgerSMB 1.4 migration

["Yves Lavoie, GaYLi" <..hidden..>]

Hi Erik,

Here are the latest results:

I was able to fix everything up to transactions.

INSERT INTO acc_trans
(entry_id, trans_id, chart_id, amount, transdate, source, cleared, fx_transaction,
    memo, approved, cleared_on, voucher_id)
SELECT lsmb_entry_id, trans_id, (select id
                    from account
                   where accno = (select accno
                                    from sl30.chart
                                   where chart.id = acc_trans.chart_id)),
                                    amount, transdate, source,
    CASE WHEN cleared IS NOT NULL THEN TRUE ELSE FALSE END, fx_transaction,
    memo, approved, cleared, vr_id
    FROM sl30.acc_trans ;
ERROR:  null value in column "chart_id" violates not-null constraint
DETAIL:  Failing row contains (11335, null, 34.47, 2013-10-01, null, f, f, null, null, t, null, null, null, 10155).

Somehow, this is wrong, the account table does containt all the accounts, the select returns all 8796 transactions, but 260 of them have null chart_id. I think that a warning should be issued, and the conversion should proceed.
From what I can see 239 of those 260 are remnants that should have been deleted. They are all many years old and are parts and counter part of a same transaction. During all those years, SL never complained about anything.
For now, I am changing the conversion query to this:

INSERT INTO acc_trans
(entry_id, trans_id, chart_id, amount, transdate, source, cleared, fx_transaction,
    memo, approved, cleared_on, voucher_id)
SELECT lsmb_entry_id, trans_id, (select id
                    from account
                   where accno = (select accno
                                    from sl30.chart
                                   where chart.id = acc_trans.chart_id)),
                                    amount, transdate, source,
    CASE WHEN cleared IS NOT NULL THEN TRUE ELSE FALSE END, fx_transaction,
    memo, approved, cleared, vr_id
    FROM sl30.acc_trans
    WHERE chart_id IS NOT null AND trans_id IN (SELECT id FROM transactions);

For the business unit,

INSERT INTO business_unit_ac (entry_id, class_id, bu_id)
SELECT ac.entry_id, 2, slac.project_id+1000
  FROM acc_trans ac
  JOIN sl30.acc_trans slac ON slac.entry_id = ac.entry_id
 WHERE project_id > 0;
ERROR:  column slac.entry_id does not exist
LINE 4:   JOIN sl30.acc_trans slac ON slac.entry_id = ac.entry_id

SL never had an entry_id. Should that be lsmb_entry_id?

For the Yearend,

INSERT INTO yearend (trans_id, transdate) SELECT * FROM sl30.yearend;
ERROR:  insert or update on table "yearend" violates foreign key constraint "yearend_trans_id_fkey"
DETAIL:  Key (trans_id)=(12049) is not present in table "gl".

Yearends can be redone without problems. We have to decide if stop the whole process for that or warn the user.
If we opt for the latter, then a warning has to be added and the query becomes

INSERT INTO yearend (trans_id, transdate) SELECT * FROM sl30.yearend
WHERE sl30.yearend.trans_id IN (SELECT id FROM gl);

For partscustomer, we already discussed that. An insert should not be attempted when pricegroup_id = 0

For jcitems:

INSERT INTO jcitems(id, parts_id, description, qty, allocated,
            sellprice, fxsellprice, serialnumber, checkedin, checkedout,
            person_id, notes, business_unit_id)
     SELECT j.id,  parts_id, description, qty, allocated,
            sellprice, fxsellprice, serialnumber, checkedin, checkedout,
            p.id, j.notes, j.project_id+1000
       FROM sl30.jcitems j
       JOIN sl30.employee e ON j.employee_id = e.id
       JOIN person p ON e.entity_id = p.entity_id;
ERROR:  null value in column "total" violates not-null constraint
DETAIL:  Failing row contains (2, 11076, 10096, Gestion de l'ingénierie, 2, 2, 130, 130, null, 2007-01-18 00:00:00-05, 2007-01-18 00:00:00-05, 10, , null, 0, null, null).

The total column isn't in the transferred items.

Anything else works. Fixing this will get us in the standard LSMB fixes.

Yves

psql:sql/modules/Fixes.sql:13: ERROR:  duplicate key value violates unique constraint "file_class_pkey"
DETAIL:  Key (class)=(internal) already exists.
psql:sql/modules/Fixes.sql:22: ERROR:  relation "file_internal" already exists
psql:sql/modules/Fixes.sql:26: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:30: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:37: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:42: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:46: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:50: ERROR:  relation "lot_tracking_number" already exists
psql:sql/modules/Fixes.sql:57: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:61: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:68: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:71: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:82: ERROR:  column "is_manager" of relation "entity_employee" already exists
psql:sql/modules/Fixes.sql:83: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:119: ERROR:  relation "location_class_to_entity_class" already exists
psql:sql/modules/Fixes.sql:121: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:124: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:126: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:127: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:129: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:137: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:140: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:155: ERROR:  function setting_get(unknown) does not exist
LINE 2: ...SET curr = (select s from unnest(string_to_array((setting_ge...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
psql:sql/modules/Fixes.sql:164: ERROR:  duplicate key value violates unique constraint "menu_node_pkey"
DETAIL:  Key (id)=(90) already exists.
psql:sql/modules/Fixes.sql:175: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:179: ERROR:  column "birthdate" of relation "person" already exists
psql:sql/modules/Fixes.sql:180: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:204: WARNING:  there is no transaction in progress
psql:sql/modules/Fixes.sql:207: ERROR:  column "is_return" of relation "ar" already exists
psql:sql/modules/Fixes.sql:210: ERROR:  column "is_return" of relation "ap" already exists
psql:sql/modules/Fixes.sql:216: ERROR:  duplicate key value violates unique constraint "menu_node_pkey"
DETAIL:  Key (id)=(129) already exists.
psql:sql/modules/Fixes.sql:217: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:221: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:225: ERROR:  column "vendor_sku" of relation "invoice" already exists
psql:sql/modules/Fixes.sql:234: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:238: ERROR:  constraint "ar_invnumber_key" of relation "ar" does not exist
psql:sql/modules/Fixes.sql:239: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:240: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:242: ERROR:  column "setting_sequence" of relation "ar" already exists
psql:sql/modules/Fixes.sql:273: ERROR:  column "category" of relation "account_heading" already exists
psql:sql/modules/Fixes.sql:294: ERROR:  relation "business_unit_ac_entry_id_idx" already exists
psql:sql/modules/Fixes.sql:295: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:296: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:302: ERROR:  relation "account_translation" already exists
psql:sql/modules/Fixes.sql:304: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:307: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:310: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:312: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:315: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Settings.sql:10: NOTICE:  function defaults_get_defaultcurrency() does not exist, skipping
psql:sql/modules/Settings.sql:26: NOTICE:  function setting__set(pg_catalog.varchar,pg_catalog.varchar) does not exist, skipping
psql:sql/modules/Util.sql:3: NOTICE:  type "lsmb_date_fields" does not exist, skipping
psql:sql/modules/Util.sql:83: NOTICE:  function invoice__get_by_vendor_number(text,text) does not exist, skipping
psql:sql/modules/Util.sql:99: NOTICE:  type "tree_record" does not exist, skipping
psql:sql/modules/Menu.sql:3: NOTICE:  type "menu_item" does not exist, skipping
psql:sql/modules/Menu.sql:142: NOTICE:  view "menu_friendly" does not exist, skipping
psql:sql/modules/Drafts.sql:3: NOTICE:  type "draft_search_result" does not exist, skipping
psql:sql/modules/Account.sql:3: NOTICE:  type "trial_balance_line" does not exist, skipping
psql:sql/modules/Account.sql:266: NOTICE:  function account_get(pg_catalog.int4) does not exist, skipping
psql:sql/modules/Account.sql:284: NOTICE:  function account__list_translations(pg_catalog.int4) does not exist, skipping
psql:sql/modules/Account.sql:353: NOTICE:  function account_heading__list_translations(pg_catalog.int4) does not exist, skipping
psql:sql/modules/Account.sql:644: NOTICE:  function account__save_tax(pg_catalog.int4,date,pg_catalog.numeric,text,pg_catalog.int4,pg_catalog.int4,date) does not exist, skipping
psql:sql/modules/Account.sql:682: NOTICE:  type "coa_entry" does not exist, skipping
psql:sql/modules/Account.sql:763: NOTICE:  view "account_heading_tree" does not exist, skipping
psql:sql/modules/Account.sql:781: NOTICE:  view "account_heading_descendant" does not exist, skipping
psql:sql/modules/Account.sql:803: NOTICE:  view "account_heading_derived_category" does not exist, skipping
psql:sql/modules/Account.sql:867: NOTICE:  trigger "loop_detection" for relation "account_heading" does not exist, skipping
psql:sql/modules/Business_Unit.sql:57: NOTICE:  type "business_unit_short" does not exist, skipping
psql:sql/modules/Business_Unit.sql:207: NOTICE:  trigger "eca_maintain_b_units" for relation "entity_credit_account" does not exist, skipping
psql:sql/modules/Business_Unit.sql:208: NOTICE:  trigger "eca_maintain_b_units_del" for relation "entity_credit_account" does not exist, skipping
psql:sql/modules/Location.sql:5: NOTICE:  type "location_class_item" does not exist, skipping
psql:sql/modules/Location.sql:13: NOTICE:  function location_list_class() does not exist, skipping
psql:sql/modules/Location.sql:199: NOTICE:  type "location_result" does not exist, skipping
psql:sql/modules/Company.sql:9: NOTICE:  type "company_entity" does not exist, skipping
psql:sql/modules/Company.sql:23: NOTICE:  type "eca__pricematrix" does not exist, skipping
psql:sql/modules/Company.sql:42: NOTICE:  type "contact_search_result" does not exist, skipping
psql:sql/modules/Company.sql:57: NOTICE:  type "eca_history_result" does not exist, skipping
psql:sql/modules/Company.sql:93: NOTICE:  function eca__history(text,text,text,text,text,text,text,text,text,pg_catalog.int4,date,date,pg_catalog.bpchar,date,date,pg_catalog.int4,bool,bool) does not exist, skipping
psql:sql/modules/Company.sql:218: NOTICE:  function eca__history_summary(text,text,text,text,text,text,text,text,text,pg_catalog.int4,date,date,pg_catalog.bpchar,date,date,pg_catalog.int4,bool,bool) does not exist, skipping
psql:sql/modules/Company.sql:254: NOTICE:  function contact__search(pg_catalog.int4,text,text[],text,text,text,text,text,text,date,date,pg_catalog.int4,text,text) does not exist, skipping
psql:sql/modules/Company.sql:262: NOTICE:  function contact__search(pg_catalog.int4,text,text[],text,text,text,text,text,text,date,date,pg_catalog.int4,text,text,text) does not exist, skipping
psql:sql/modules/Company.sql:386: NOTICE:  function eca__get_taxes(pg_catalog.int4) does not exist, skipping
psql:sql/modules/Company.sql:397: NOTICE:  function eca__set_taxes(pg_catalog.int4,pg_catalog.int4[]) does not exist, skipping
psql:sql/modules/Company.sql:498: NOTICE:  type "entity_credit_search_return" does not exist, skipping
psql:sql/modules/Company.sql:523: NOTICE:  type "entity_credit_retrieve" does not exist, skipping
psql:sql/modules/Company.sql:669: NOTICE:  type "company_billing_info" does not exist, skipping
psql:sql/modules/Company.sql:722: NOTICE:  function company_save(pg_catalog.int4,text,pg_catalog.int4,text,text,pg_catalog.int4,text,pg_catalog.int4,text,text) does not exist, skipping
psql:sql/modules/Company.sql:808: NOTICE:  function entity_credit_save(pg_catalog.int4,pg_catalog.int4,pg_catalog.int4,text,pg_catalog.numeric,bool,pg_catalog.numeric,pg_catalog.int4,pg_catalog.int4,pg_catalog.varchar,pg_catalog.int4,pg_catalog.varchar,pg_catalog.int4,pg_catalog.bpchar,date,date,pg_catalog.numeric,pg_catalog.int4,pg_catalog.int4,text,pg_catalog.int4) does not exist, skipping
psql:sql/modules/Company.sql:822: NOTICE:  function eca__save(pg_catalog.int4,pg_catalog.int4,pg_catalog.int4,text,pg_catalog.numeric,bool,pg_catalog.numeric,pg_catalog.int4,pg_catalog.int4,pg_catalog.varchar,pg_catalog.int4,pg_catalog.varchar,pg_catalog.int4,pg_catalog.bpchar,date,date,pg_catalog.numeric,pg_catalog.int4,pg_catalog.int4,text,pg_catalog.int4) does not exist, skipping
psql:sql/modules/Company.sql:975: NOTICE:  type "contact_list" does not exist, skipping
psql:sql/modules/Company.sql:1020: NOTICE:  function entity__save_bank_account(pg_catalog.int4,pg_catalog.int4,text,text,pg_catalog.int4) does not exist, skipping
psql:sql/modules/Company.sql:1120: NOTICE:  type "entity_note_list" does not exist, skipping
psql:sql/modules/Company.sql:1390: NOTICE:  function eca__save_contact(pg_catalog.int4,pg_catalog.int4,text,text,text,pg_catalog.int4) does not exist, skipping
psql:sql/modules/Employee.sql:12: NOTICE:  function employee__save(pg_catalog.int4,date,date,date,text,text,bool,pg_catalog.int4,text) does not exist, skipping
psql:sql/modules/Employee.sql:56: NOTICE:  function employee__get_user(pg_catalog.int4) does not exist, skipping
psql:sql/modules/Employee.sql:64: NOTICE:  view "employees" does not exist, skipping
psql:sql/modules/Employee.sql:77: NOTICE:  type "employee_result" does not exist, skipping
psql:sql/modules/Employee.sql:205: NOTICE:  view "employee_search" does not exist, skipping
psql:sql/modules/Payment.sql:13: NOTICE:  type "payment_vc_info" does not exist, skipping
psql:sql/modules/Payment.sql:40: NOTICE:  function payment_get_entity_accounts(pg_catalog.int4,text,text) does not exist, skipping
psql:sql/modules/Payment.sql:101: NOTICE:  function payment_get_open_accounts(pg_catalog.int4) does not exist, skipping
psql:sql/modules/Payment.sql:102: NOTICE:  function payment_get_open_accounts(pg_catalog.int4,date,date) does not exist, skipping
psql:sql/modules/Payment.sql:150: NOTICE:  function payment_get_all_accounts(pg_catalog.int4) does not exist, skipping
psql:sql/modules/Payment.sql:180: NOTICE:  type "payment_invoice" does not exist, skipping
psql:sql/modules/Payment.sql:337: NOTICE:  type "payment_contact_invoice" does not exist, skipping
psql:sql/modules/Payment.sql:493: NOTICE:  function payment_bulk_post(pg_catalog.numeric[],pg_catalog.int4,text,pg_catalog.numeric,text,text,date,pg_catalog.int4,pg_catalog.numeric,text) does not exist, skipping
psql:sql/modules/Payment.sql:1093: NOTICE:  type "payment_location_result" does not exist, skipping
psql:sql/modules/Payment.sql:1136: NOTICE:  type "payment_record" does not exist, skipping
psql:sql/modules/Payment.sql:1150: NOTICE:  function payment__search(text,date,date,pg_catalog.int4,text,pg_catalog.int4,pg_catalog.bpchar) does not exist, skipping
psql:sql/modules/Payment.sql:1219: NOTICE:  function payment__reverse(text,date,pg_catalog.int4,text,date,pg_catalog.int4,pg_catalog.int4,pg_catalog.int4) does not exist, skipping
psql:sql/modules/Payment.sql:1389: NOTICE:  type "payment_header_item" does not exist, skipping
psql:sql/modules/Payment.sql:1439: NOTICE:  type "payment_line_item" does not exist, skipping
psql:sql/modules/Payment.sql:1495: NOTICE:  view "overpayments" does not exist, skipping
psql:sql/modules/Payment.sql:1577: NOTICE:  type "payment_overpayments_available_amount" does not exist, skipping
psql:sql/modules/Payment.sql:1615: NOTICE:  type "overpayment_list_item" does not exist, skipping
psql:sql/modules/Payment.sql:1654: NOTICE:  function overpayment__reverse(pg_catalog.int4,date,pg_catalog.int4,pg_catalog.int4,text,pg_catalog.numeric,pg_catalog.bpchar) does not exist, skipping
psql:sql/modules/Person.sql:23: NOTICE:  type "person_entity" does not exist, skipping
psql:sql/modules/Person.sql:70: NOTICE:  function person__save(pg_catalog.int4,pg_catalog.int4,text,text,text,pg_catalog.int4) does not exist, skipping
psql:sql/modules/Person.sql:201: NOTICE:  function person__save_contact(pg_catalog.int4,pg_catalog.int4,text,text) does not exist, skipping
psql:sql/modules/PNL.sql:12: NOTICE:  function pnl__product(date,date,pg_catalog.int4,pg_catalog.int4[]) does not exist, skipping
psql:sql/modules/PNL.sql:13: NOTICE:  type "pnl_line" does not exist, skipping
psql:sql/modules/PNL.sql:156: NOTICE:  function pnl__income_statement_accrual(date,date,text,pg_catalog.int4[]) does not exist, skipping
psql:sql/modules/PNL.sql:277: NOTICE:  function pnl__income_statement_cash(date,date,text,pg_catalog.int4[]) does not exist, skipping
psql:sql/modules/PNL.sql:400: NOTICE:  function pnl__invoice(pg_catalog.int4) does not exist, skipping
psql:sql/modules/PNL.sql:492: NOTICE:  function pnl__customer(pg_catalog.int4,date,date) does not exist, skipping
psql:sql/modules/trial_balance.sql:3: NOTICE:  type "tb_row" does not exist, skipping
psql:sql/modules/trial_balance.sql:19: NOTICE:  function trial_balance__generate(date,date,pg_catalog.int4,pg_catalog.int4[],text,pg_catalog.int4[]) does not exist, skipping
psql:sql/modules/trial_balance.sql:23: NOTICE:  function trial_balance__generate(date,date,pg_catalog.int4,pg_catalog.int4[],text,pg_catalog.int4[],pg_catalog.int4) does not exist, skipping
psql:sql/modules/trial_balance.sql:210: NOTICE:  type "trial_balance__heading" does not exist, skipping
psql:sql/modules/Report.sql:5: NOTICE:  type "incoming_lot_cogs_line" does not exist, skipping
psql:sql/modules/Report.sql:45: NOTICE:  type "report_aging_item" does not exist, skipping
psql:sql/modules/Report.sql:72: NOTICE:  function report__invoice_aging_detail(pg_catalog.int4,pg_catalog.int4,text,date,pg_catalog.int4[],bool) does not exist, skipping
psql:sql/modules/Report.sql:189: NOTICE:  function report__invoice_aging_summary(pg_catalog.int4,pg_catalog.int4,text,date,pg_catalog.int4[],bool) does not exist, skipping
psql:sql/modules/Report.sql:206: NOTICE:  type "gl_report_item" does not exist, skipping
psql:sql/modules/Report.sql:323: NOTICE:  type "cash_summary_item" does not exist, skipping
psql:sql/modules/Report.sql:360: NOTICE:  type "general_balance_line" does not exist, skipping
psql:sql/modules/Report.sql:398: NOTICE:  type "aa_transactions_line" does not exist, skipping
psql:sql/modules/Report.sql:625: NOTICE:  function report__balance_sheet(date) does not exist, skipping
psql:sql/modules/Report.sql:626: NOTICE:  type "balance_sheet_line" does not exist, skipping
psql:sql/modules/Voucher.sql:31: NOTICE:  type "voucher_list" does not exist, skipping
psql:sql/modules/Voucher.sql:146: NOTICE:  type "batch_list_item" does not exist, skipping
psql:sql/modules/admin.sql:237: NOTICE:  function admin__get_user(pg_catalog.int4) does not exist, skipping
psql:sql/modules/admin.sql:254: NOTICE:  function admin__get_user_by_entity(pg_catalog.int4) does not exist, skipping
psql:sql/modules/admin.sql:272: NOTICE:  function admin__get_roles_for_user(pg_catalog.int4) does not exist, skipping
psql:sql/modules/admin.sql:409: NOTICE:  function admin__save_user(pg_catalog.int4,pg_catalog.int4,text,text,bool) does not exist, skipping
psql:sql/modules/admin.sql:515: NOTICE:  view "role_view" does not exist, skipping
psql:sql/modules/admin.sql:775: NOTICE:  function user__get_preferences(pg_catalog.int4) does not exist, skipping
psql:sql/modules/admin.sql:795: NOTICE:  type "user_result" does not exist, skipping
psql:sql/modules/admin.sql:830: NOTICE:  type "session_result" does not exist, skipping
psql:sql/modules/Reconciliation.sql:142: NOTICE:  trigger "block_change_when_approved" for relation "cr_report" does not exist, skipping
psql:sql/modules/Reconciliation.sql:419: NOTICE:  function reconciliation__pending_transactions(date,pg_catalog.int4,pg_catalog.int4,pg_catalog.numeric) does not exist, skipping
psql:sql/modules/Reconciliation.sql:596: NOTICE:  type "recon_accounts" does not exist, skipping
psql:sql/modules/TaxForm.sql:4: NOTICE:  function tax_form__save(pg_catalog.int4,pg_catalog.int4,text,bool) does not exist, skipping
psql:sql/modules/TaxForm.sql:46: NOTICE:  type "tax_form_list" does not exist, skipping
psql:sql/modules/TaxForm.sql:56: NOTICE:  function tax_form__list_all() does not exist, skipping
psql:sql/modules/TaxForm.sql:69: NOTICE:  type "taxform_list" does not exist, skipping
psql:sql/modules/1099_reports.sql:13: NOTICE:  type "tax_form_report_item" does not exist, skipping
psql:sql/modules/1099_reports.sql:25: NOTICE:  type "tax_form_report_detail_item" does not exist, skipping
psql:sql/modules/Assets.sql:252: NOTICE:  type "asset_class_result" does not exist, skipping
psql:sql/modules/Assets.sql:611: NOTICE:  type "asset_disposal_report_line" does not exist, skipping
psql:sql/modules/Assets.sql:662: NOTICE:  type "asset_nbv_line" does not exist, skipping
psql:sql/modules/Assets.sql:707: NOTICE:  type "partial_disposal_line" does not exist, skipping
psql:sql/modules/Assets.sql:872: NOTICE:  type "asset_report_line_result" does not exist, skipping
psql:sql/modules/Assets.sql:923: NOTICE:  type "asset_report_result" does not exist, skipping
psql:sql/modules/Files.sql:263: NOTICE:  type "file_list_item" does not exist, skipping
psql:sql/modules/Budgetting.sql:13: NOTICE:  type "budget_info_ext" does not exist, skipping
psql:sql/modules/Budgetting.sql:198: NOTICE:  type "budget_line_details" does not exist, skipping
psql:sql/modules/Budgetting.sql:212: NOTICE:  function budget__get_details(pg_catalog.int4) does not exist, skipping
psql:sql/modules/Budgetting.sql:262: NOTICE:  type "budget_variance_report" does not exist, skipping
psql:sql/modules/Inventory.sql:59: NOTICE:  aggregate product(pg_catalog.numeric) does not exist, skipping
psql:sql/modules/Inventory_Report.sql:3: NOTICE:  type "inventory_adjustment_line" does not exist, skipping
psql:sql/modules/Inventory_Report.sql:34: NOTICE:  type "inventory_adjustment_info" does not exist, skipping
psql:sql/modules/Payroll.sql:15: NOTICE:  function wage__save(pg_catalog.numeric,pg_catalog.int4,pg_catalog.int4) does not exist, skipping
psql:sql/modules/Payroll.sql:51: NOTICE:  function deduction__save(pg_catalog.numeric,pg_catalog.int4,pg_catalog.int4) does not exist, skipping
psql:sql/modules/Transaction_Templates.sql:6: NOTICE:  function journal__add(text,text,pg_catalog.int4,date,bool,bool) does not exist, skipping
psql:sql/modules/Transaction_Templates.sql:70: NOTICE:  type "journal_search_result" does not exist, skipping
psql:sql/modules/OrderEntry.sql:8: NOTICE:  type "order_search_line" does not exist, skipping
psql:sql/modules/Goods.sql:86: NOTICE:  type "goods_search_result" does not exist, skipping
psql:sql/modules/Goods.sql:119: NOTICE:  function goods__search(text,text,pg_catalog.int4,text,text,text,text,text,text,date,date,bool,bool,bool,bool,bool,bool) does not exist, skipping
psql:sql/modules/Goods.sql:169: NOTICE:  function partsgroups__list_all() does not exist, skipping
psql:sql/modules/Goods.sql:185: NOTICE:  type "inv_activity_line" does not exist, skipping
psql:sql/modules/Goods.sql:224: NOTICE:  type "part_at_date" does not exist, skipping
psql:sql/modules/Goods.sql:234: NOTICE:  view "invoice_sum" does not exist, skipping
psql:sql/modules/Goods.sql:235: NOTICE:  view "order_sum" does not exist, skipping
psql:sql/modules/Goods.sql:409: NOTICE:  function inventory_adjust__get(pg_catalog.int4) does not exist, skipping
psql:sql/modules/Goods.sql:431: NOTICE:  type "parts_history_result" does not exist, skipping
psql:sql/modules/Roles.sql:5: NOTICE:  function lsmb__create_role(text) does not exist, skipping
psql:sql/modules/Roles.sql:22: NOTICE:  function lsmb__grant_role(text,text) does not exist, skipping
psql:sql/modules/Roles.sql:120: NOTICE:  role "lsmb_lsmb_gayli__budget_approve" is already a member of role "lsmb_lsmb_gayli__budget_view"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__budget_view TO lsmb_lsmb_gayli__budget_approve"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:123: NOTICE:  role "lsmb_lsmb_gayli__budget_obsolete" is already a member of role "lsmb_lsmb_gayli__budget_view"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__budget_view TO lsmb_lsmb_gayli__budget_obsolete"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:255: NOTICE:  role "lsmb_lsmb_gayli__contact_create" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__contact_create"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:288: NOTICE:  role "lsmb_lsmb_gayli__employees_manage" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__employees_manage"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:301: NOTICE:  role "lsmb_lsmb_gayli__contact_edit" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__contact_edit"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:327: NOTICE:  role "lsmb_lsmb_gayli__contact_all_rights" is already a member of role "lsmb_lsmb_gayli__contact_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_create TO lsmb_lsmb_gayli__contact_all_rights"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:328: NOTICE:  role "lsmb_lsmb_gayli__contact_all_rights" is already a member of role "lsmb_lsmb_gayli__contact_edit"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_edit TO lsmb_lsmb_gayli__contact_all_rights"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:329: NOTICE:  role "lsmb_lsmb_gayli__contact_all_rights" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__contact_all_rights"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:330: NOTICE:  role "lsmb_lsmb_gayli__contact_all_rights" is already a member of role "lsmb_lsmb_gayli__contact_delete"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_delete TO lsmb_lsmb_gayli__contact_all_rights"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:357: NOTICE:  role "lsmb_lsmb_gayli__ar_transaction_create" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__ar_transaction_create"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:358: NOTICE:  role "lsmb_lsmb_gayli__ar_transaction_create" is already a member of role "lsmb_lsmb_gayli__exchangerate_edit"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__exchangerate_edit TO lsmb_lsmb_gayli__ar_transaction_create"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:380: NOTICE:  role "lsmb_lsmb_gayli__ar_transaction_create_voucher" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__ar_transaction_create_voucher"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:381: NOTICE:  role "lsmb_lsmb_gayli__ar_transaction_create_voucher" is already a member of role "lsmb_lsmb_gayli__batch_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__batch_create TO lsmb_lsmb_gayli__ar_transaction_create_voucher"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:397: NOTICE:  role "lsmb_lsmb_gayli__ar_invoice_create" is already a member of role "lsmb_lsmb_gayli__ar_transaction_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ar_transaction_create TO lsmb_lsmb_gayli__ar_invoice_create"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:406: NOTICE:  role "lsmb_lsmb_gayli__ar_invoice_create_voucher" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__ar_invoice_create_voucher"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:407: NOTICE:  role "lsmb_lsmb_gayli__ar_invoice_create_voucher" is already a member of role "lsmb_lsmb_gayli__batch_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__batch_create TO lsmb_lsmb_gayli__ar_invoice_create_voucher"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:408: NOTICE:  role "lsmb_lsmb_gayli__ar_invoice_create_voucher" is already a member of role "lsmb_lsmb_gayli__ar_transaction_create_voucher"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ar_transaction_create_voucher TO lsmb_lsmb_gayli__ar_invoice_create_voucher"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:416: NOTICE:  role "lsmb_lsmb_gayli__ar_transaction_list" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__ar_transaction_list"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:417: NOTICE:  role "lsmb_lsmb_gayli__ar_transaction_list" is already a member of role "lsmb_lsmb_gayli__file_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__file_read TO lsmb_lsmb_gayli__ar_transaction_list"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:429: NOTICE:  role "lsmb_lsmb_gayli__ar_voucher_all" is already a member of role "lsmb_lsmb_gayli__ar_transaction_create_voucher"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ar_transaction_create_voucher TO lsmb_lsmb_gayli__ar_voucher_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:430: NOTICE:  role "lsmb_lsmb_gayli__ar_voucher_all" is already a member of role "lsmb_lsmb_gayli__ar_invoice_create_voucher"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ar_invoice_create_voucher TO lsmb_lsmb_gayli__ar_voucher_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:435: NOTICE:  role "lsmb_lsmb_gayli__ar_transaction_all" is already a member of role "lsmb_lsmb_gayli__ar_transaction_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ar_transaction_create TO lsmb_lsmb_gayli__ar_transaction_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:435: NOTICE:  role "lsmb_lsmb_gayli__ar_transaction_all" is already a member of role "lsmb_lsmb_gayli__ar_invoice_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ar_invoice_create TO lsmb_lsmb_gayli__ar_transaction_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:435: NOTICE:  role "lsmb_lsmb_gayli__ar_transaction_all" is already a member of role "lsmb_lsmb_gayli__ar_transaction_list"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ar_transaction_list TO lsmb_lsmb_gayli__ar_transaction_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:435: NOTICE:  role "lsmb_lsmb_gayli__ar_transaction_all" is already a member of role "lsmb_lsmb_gayli__file_attach_tx"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__file_attach_tx TO lsmb_lsmb_gayli__ar_transaction_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:438: NOTICE:  role "lsmb_lsmb_gayli__sales_order_create" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__sales_order_create"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:439: NOTICE:  role "lsmb_lsmb_gayli__sales_order_create" is already a member of role "lsmb_lsmb_gayli__exchangerate_edit"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__exchangerate_edit TO lsmb_lsmb_gayli__sales_order_create"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:466: NOTICE:  role "lsmb_lsmb_gayli__sales_quotation_create" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__sales_quotation_create"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:467: NOTICE:  role "lsmb_lsmb_gayli__sales_quotation_create" is already a member of role "lsmb_lsmb_gayli__exchangerate_edit"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__exchangerate_edit TO lsmb_lsmb_gayli__sales_quotation_create"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:478: NOTICE:  role "lsmb_lsmb_gayli__sales_order_list" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__sales_order_list"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:479: NOTICE:  role "lsmb_lsmb_gayli__sales_order_list" is already a member of role "lsmb_lsmb_gayli__file_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__file_read TO lsmb_lsmb_gayli__sales_order_list"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:486: NOTICE:  role "lsmb_lsmb_gayli__sales_quotation_list" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__sales_quotation_list"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:487: NOTICE:  role "lsmb_lsmb_gayli__sales_quotation_list" is already a member of role "lsmb_lsmb_gayli__file_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__file_read TO lsmb_lsmb_gayli__sales_quotation_list"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:496: NOTICE:  role "lsmb_lsmb_gayli__ar_all" is already a member of role "lsmb_lsmb_gayli__ar_voucher_all"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ar_voucher_all TO lsmb_lsmb_gayli__ar_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:496: NOTICE:  role "lsmb_lsmb_gayli__ar_all" is already a member of role "lsmb_lsmb_gayli__ar_transaction_all"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ar_transaction_all TO lsmb_lsmb_gayli__ar_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:496: NOTICE:  role "lsmb_lsmb_gayli__ar_all" is already a member of role "lsmb_lsmb_gayli__file_attach_tx"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__file_attach_tx TO lsmb_lsmb_gayli__ar_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:500: NOTICE:  role "lsmb_lsmb_gayli__ap_transaction_create" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__ap_transaction_create"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:501: NOTICE:  role "lsmb_lsmb_gayli__ap_transaction_create" is already a member of role "lsmb_lsmb_gayli__exchangerate_edit"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__exchangerate_edit TO lsmb_lsmb_gayli__ap_transaction_create"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:518: NOTICE:  role "lsmb_lsmb_gayli__ap_transaction_create_voucher" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__ap_transaction_create_voucher"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:519: NOTICE:  role "lsmb_lsmb_gayli__ap_transaction_create_voucher" is already a member of role "lsmb_lsmb_gayli__batch_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__batch_create TO lsmb_lsmb_gayli__ap_transaction_create_voucher"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:540: NOTICE:  role "lsmb_lsmb_gayli__ap_invoice_create" is already a member of role "lsmb_lsmb_gayli__ap_transaction_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ap_transaction_create TO lsmb_lsmb_gayli__ap_invoice_create"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:551: NOTICE:  role "lsmb_lsmb_gayli__ap_invoice_create_voucher" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__ap_invoice_create_voucher"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:552: NOTICE:  role "lsmb_lsmb_gayli__ap_invoice_create_voucher" is already a member of role "lsmb_lsmb_gayli__batch_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__batch_create TO lsmb_lsmb_gayli__ap_invoice_create_voucher"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:560: NOTICE:  role "lsmb_lsmb_gayli__ap_transaction_list" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__ap_transaction_list"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:561: NOTICE:  role "lsmb_lsmb_gayli__ap_transaction_list" is already a member of role "lsmb_lsmb_gayli__file_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__file_read TO lsmb_lsmb_gayli__ap_transaction_list"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:569: NOTICE:  role "lsmb_lsmb_gayli__ap_all_vouchers" is already a member of role "lsmb_lsmb_gayli__ap_transaction_create_voucher"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ap_transaction_create_voucher TO lsmb_lsmb_gayli__ap_all_vouchers"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:570: NOTICE:  role "lsmb_lsmb_gayli__ap_all_vouchers" is already a member of role "lsmb_lsmb_gayli__ap_invoice_create_voucher"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ap_invoice_create_voucher TO lsmb_lsmb_gayli__ap_all_vouchers"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:573: NOTICE:  role "lsmb_lsmb_gayli__ap_all_transactions" is already a member of role "lsmb_lsmb_gayli__ap_transaction_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ap_transaction_create TO lsmb_lsmb_gayli__ap_all_transactions"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:574: NOTICE:  role "lsmb_lsmb_gayli__ap_all_transactions" is already a member of role "lsmb_lsmb_gayli__ap_invoice_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ap_invoice_create TO lsmb_lsmb_gayli__ap_all_transactions"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:575: NOTICE:  role "lsmb_lsmb_gayli__ap_all_transactions" is already a member of role "lsmb_lsmb_gayli__ap_transaction_list"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ap_transaction_list TO lsmb_lsmb_gayli__ap_all_transactions"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:581: NOTICE:  role "lsmb_lsmb_gayli__ap_transaction_all" is already a member of role "lsmb_lsmb_gayli__ap_transaction_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ap_transaction_create TO lsmb_lsmb_gayli__ap_transaction_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:581: NOTICE:  role "lsmb_lsmb_gayli__ap_transaction_all" is already a member of role "lsmb_lsmb_gayli__ap_invoice_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ap_invoice_create TO lsmb_lsmb_gayli__ap_transaction_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:581: NOTICE:  role "lsmb_lsmb_gayli__ap_transaction_all" is already a member of role "lsmb_lsmb_gayli__ap_transaction_list"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ap_transaction_list TO lsmb_lsmb_gayli__ap_transaction_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:581: NOTICE:  role "lsmb_lsmb_gayli__ap_transaction_all" is already a member of role "lsmb_lsmb_gayli__file_attach_tx"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__file_attach_tx TO lsmb_lsmb_gayli__ap_transaction_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:581: NOTICE:  role "lsmb_lsmb_gayli__ap_transaction_all" is already a member of role "lsmb_lsmb_gayli__exchangerate_edit"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__exchangerate_edit TO lsmb_lsmb_gayli__ap_transaction_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:584: NOTICE:  role "lsmb_lsmb_gayli__purchase_order_create" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__purchase_order_create"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:600: NOTICE:  role "lsmb_lsmb_gayli__rfq_create" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__rfq_create"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:601: NOTICE:  role "lsmb_lsmb_gayli__rfq_create" is already a member of role "lsmb_lsmb_gayli__exchangerate_edit"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__exchangerate_edit TO lsmb_lsmb_gayli__rfq_create"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:610: NOTICE:  role "lsmb_lsmb_gayli__purchase_order_list" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__purchase_order_list"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:616: NOTICE:  role "lsmb_lsmb_gayli__rfq_list" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__rfq_list"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:624: NOTICE:  role "lsmb_lsmb_gayli__ap_all" is already a member of role "lsmb_lsmb_gayli__ap_all_vouchers"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ap_all_vouchers TO lsmb_lsmb_gayli__ap_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:624: NOTICE:  role "lsmb_lsmb_gayli__ap_all" is already a member of role "lsmb_lsmb_gayli__file_attach_tx"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__file_attach_tx TO lsmb_lsmb_gayli__ap_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:624: NOTICE:  role "lsmb_lsmb_gayli__ap_all" is already a member of role "lsmb_lsmb_gayli__ap_all_transactions"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ap_all_transactions TO lsmb_lsmb_gayli__ap_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:655: NOTICE:  role "lsmb_lsmb_gayli__reconciliation_all" is already a member of role "lsmb_lsmb_gayli__reconciliation_approve"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__reconciliation_approve TO lsmb_lsmb_gayli__reconciliation_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:656: NOTICE:  role "lsmb_lsmb_gayli__reconciliation_all" is already a member of role "lsmb_lsmb_gayli__reconciliation_enter"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__reconciliation_enter TO lsmb_lsmb_gayli__reconciliation_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:659: NOTICE:  role "lsmb_lsmb_gayli__payment_process" is already a member of role "lsmb_lsmb_gayli__ap_transaction_list"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ap_transaction_list TO lsmb_lsmb_gayli__payment_process"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:660: NOTICE:  role "lsmb_lsmb_gayli__payment_process" is already a member of role "lsmb_lsmb_gayli__exchangerate_edit"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__exchangerate_edit TO lsmb_lsmb_gayli__payment_process"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:674: NOTICE:  role "lsmb_lsmb_gayli__receipt_process" is already a member of role "lsmb_lsmb_gayli__ap_transaction_list"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ap_transaction_list TO lsmb_lsmb_gayli__receipt_process"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:675: NOTICE:  role "lsmb_lsmb_gayli__receipt_process" is already a member of role "lsmb_lsmb_gayli__exchangerate_edit"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__exchangerate_edit TO lsmb_lsmb_gayli__receipt_process"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:691: NOTICE:  role "lsmb_lsmb_gayli__cash_all" is already a member of role "lsmb_lsmb_gayli__reconciliation_all"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__reconciliation_all TO lsmb_lsmb_gayli__cash_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:691: NOTICE:  role "lsmb_lsmb_gayli__cash_all" is already a member of role "lsmb_lsmb_gayli__payment_process"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__payment_process TO lsmb_lsmb_gayli__cash_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:691: NOTICE:  role "lsmb_lsmb_gayli__cash_all" is already a member of role "lsmb_lsmb_gayli__receipt_process"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__receipt_process TO lsmb_lsmb_gayli__cash_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:696: NOTICE:  role "lsmb_lsmb_gayli__part_create" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__part_create"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:710: NOTICE:  role "lsmb_lsmb_gayli__part_edit" is already a member of role "lsmb_lsmb_gayli__file_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__file_read TO lsmb_lsmb_gayli__part_edit"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:750: NOTICE:  role "lsmb_lsmb_gayli__inventory_approve" is already a member of role "lsmb_lsmb_gayli__ar_invoice_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ar_invoice_create TO lsmb_lsmb_gayli__inventory_approve"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:751: NOTICE:  role "lsmb_lsmb_gayli__inventory_approve" is already a member of role "lsmb_lsmb_gayli__ap_invoice_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ap_invoice_create TO lsmb_lsmb_gayli__inventory_approve"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:757: NOTICE:  role "lsmb_lsmb_gayli__pricegroup_create" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__pricegroup_create"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:764: NOTICE:  role "lsmb_lsmb_gayli__pricegroup_edit" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__pricegroup_edit"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:785: NOTICE:  role "lsmb_lsmb_gayli__inventory_ship" is already a member of role "lsmb_lsmb_gayli__sales_order_list"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__sales_order_list TO lsmb_lsmb_gayli__inventory_ship"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:791: NOTICE:  role "lsmb_lsmb_gayli__inventory_receive" is already a member of role "lsmb_lsmb_gayli__purchase_order_list"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__purchase_order_list TO lsmb_lsmb_gayli__inventory_receive"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:815: NOTICE:  role "lsmb_lsmb_gayli__inventory_all" is already a member of role "lsmb_lsmb_gayli__warehouse_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__warehouse_create TO lsmb_lsmb_gayli__inventory_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:815: NOTICE:  role "lsmb_lsmb_gayli__inventory_all" is already a member of role "lsmb_lsmb_gayli__warehouse_edit"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__warehouse_edit TO lsmb_lsmb_gayli__inventory_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:815: NOTICE:  role "lsmb_lsmb_gayli__inventory_all" is already a member of role "lsmb_lsmb_gayli__inventory_transfer"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__inventory_transfer TO lsmb_lsmb_gayli__inventory_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:815: NOTICE:  role "lsmb_lsmb_gayli__inventory_all" is already a member of role "lsmb_lsmb_gayli__inventory_receive"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__inventory_receive TO lsmb_lsmb_gayli__inventory_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:815: NOTICE:  role "lsmb_lsmb_gayli__inventory_all" is already a member of role "lsmb_lsmb_gayli__inventory_ship"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__inventory_ship TO lsmb_lsmb_gayli__inventory_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:815: NOTICE:  role "lsmb_lsmb_gayli__inventory_all" is already a member of role "lsmb_lsmb_gayli__assembly_stock"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__assembly_stock TO lsmb_lsmb_gayli__inventory_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:815: NOTICE:  role "lsmb_lsmb_gayli__inventory_all" is already a member of role "lsmb_lsmb_gayli__inventory_reports"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__inventory_reports TO lsmb_lsmb_gayli__inventory_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:815: NOTICE:  role "lsmb_lsmb_gayli__inventory_all" is already a member of role "lsmb_lsmb_gayli__part_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__part_create TO lsmb_lsmb_gayli__inventory_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:815: NOTICE:  role "lsmb_lsmb_gayli__inventory_all" is already a member of role "lsmb_lsmb_gayli__part_edit"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__part_edit TO lsmb_lsmb_gayli__inventory_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:841: NOTICE:  role "lsmb_lsmb_gayli__gl_reports" is already a member of role "lsmb_lsmb_gayli__ar_transaction_list"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ar_transaction_list TO lsmb_lsmb_gayli__gl_reports"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:842: NOTICE:  role "lsmb_lsmb_gayli__gl_reports" is already a member of role "lsmb_lsmb_gayli__ap_transaction_list"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__ap_transaction_list TO lsmb_lsmb_gayli__gl_reports"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:857: NOTICE:  role "lsmb_lsmb_gayli__batch_list" is already a member of role "lsmb_lsmb_gayli__gl_reports"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__gl_reports TO lsmb_lsmb_gayli__batch_list"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:864: NOTICE:  role "lsmb_lsmb_gayli__gl_all" is already a member of role "lsmb_lsmb_gayli__gl_transaction_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__gl_transaction_create TO lsmb_lsmb_gayli__gl_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:864: NOTICE:  role "lsmb_lsmb_gayli__gl_all" is already a member of role "lsmb_lsmb_gayli__gl_voucher_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__gl_voucher_create TO lsmb_lsmb_gayli__gl_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:864: NOTICE:  role "lsmb_lsmb_gayli__gl_all" is already a member of role "lsmb_lsmb_gayli__yearend_run"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__yearend_run TO lsmb_lsmb_gayli__gl_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:864: NOTICE:  role "lsmb_lsmb_gayli__gl_all" is already a member of role "lsmb_lsmb_gayli__gl_reports"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__gl_reports TO lsmb_lsmb_gayli__gl_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:867: NOTICE:  role "lsmb_lsmb_gayli__timecard_add" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__timecard_add"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:876: NOTICE:  role "lsmb_lsmb_gayli__timecard_list" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__timecard_list"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:882: NOTICE:  role "lsmb_lsmb_gayli__orders_generate" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__orders_generate"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:891: NOTICE:  role "lsmb_lsmb_gayli__timecard_order_generate" is already a member of role "lsmb_lsmb_gayli__orders_generate"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__orders_generate TO lsmb_lsmb_gayli__timecard_order_generate"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:892: NOTICE:  role "lsmb_lsmb_gayli__timecard_order_generate" is already a member of role "lsmb_lsmb_gayli__timecard_list"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__timecard_list TO lsmb_lsmb_gayli__timecard_order_generate"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:896: NOTICE:  role "lsmb_lsmb_gayli__orders_sales_to_purchase" is already a member of role "lsmb_lsmb_gayli__orders_generate"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__orders_generate TO lsmb_lsmb_gayli__orders_sales_to_purchase"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:901: NOTICE:  role "lsmb_lsmb_gayli__orders_purchase_consolidate" is already a member of role "lsmb_lsmb_gayli__orders_generate"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__orders_generate TO lsmb_lsmb_gayli__orders_purchase_consolidate"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:905: NOTICE:  role "lsmb_lsmb_gayli__orders_sales_consolidate" is already a member of role "lsmb_lsmb_gayli__orders_generate"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__orders_generate TO lsmb_lsmb_gayli__orders_sales_consolidate"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:912: NOTICE:  role "lsmb_lsmb_gayli__orders_manage" is already a member of role "lsmb_lsmb_gayli__timecard_order_generate"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__timecard_order_generate TO lsmb_lsmb_gayli__orders_manage"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:912: NOTICE:  role "lsmb_lsmb_gayli__orders_manage" is already a member of role "lsmb_lsmb_gayli__orders_sales_to_purchase"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__orders_sales_to_purchase TO lsmb_lsmb_gayli__orders_manage"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:912: NOTICE:  role "lsmb_lsmb_gayli__orders_manage" is already a member of role "lsmb_lsmb_gayli__orders_purchase_consolidate"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__orders_purchase_consolidate TO lsmb_lsmb_gayli__orders_manage"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:912: NOTICE:  role "lsmb_lsmb_gayli__orders_manage" is already a member of role "lsmb_lsmb_gayli__orders_sales_consolidate"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__orders_sales_consolidate TO lsmb_lsmb_gayli__orders_manage"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:916: NOTICE:  role "lsmb_lsmb_gayli__financial_reports" is already a member of role "lsmb_lsmb_gayli__gl_reports"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__gl_reports TO lsmb_lsmb_gayli__financial_reports"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:940: NOTICE:  role "lsmb_lsmb_gayli__system_settings_change" is already a member of role "lsmb_lsmb_gayli__system_settings_list"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__system_settings_list TO lsmb_lsmb_gayli__system_settings_change"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:993: NOTICE:  role "lsmb_lsmb_gayli__account_all" is already a member of role "lsmb_lsmb_gayli__account_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__account_create TO lsmb_lsmb_gayli__account_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:993: NOTICE:  role "lsmb_lsmb_gayli__account_all" is already a member of role "lsmb_lsmb_gayli__taxes_set"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__taxes_set TO lsmb_lsmb_gayli__account_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:993: NOTICE:  role "lsmb_lsmb_gayli__account_all" is already a member of role "lsmb_lsmb_gayli__account_edit"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__account_edit TO lsmb_lsmb_gayli__account_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:993: NOTICE:  role "lsmb_lsmb_gayli__account_all" is already a member of role "lsmb_lsmb_gayli__gifi_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__gifi_create TO lsmb_lsmb_gayli__account_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:993: NOTICE:  role "lsmb_lsmb_gayli__account_all" is already a member of role "lsmb_lsmb_gayli__gifi_edit"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__gifi_edit TO lsmb_lsmb_gayli__account_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:993: NOTICE:  role "lsmb_lsmb_gayli__account_all" is already a member of role "lsmb_lsmb_gayli__account_delete"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__account_delete TO lsmb_lsmb_gayli__account_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:1007: NOTICE:  role "lsmb_lsmb_gayli__business_type_all" is already a member of role "lsmb_lsmb_gayli__business_type_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__business_type_create TO lsmb_lsmb_gayli__business_type_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:1008: NOTICE:  role "lsmb_lsmb_gayli__business_type_all" is already a member of role "lsmb_lsmb_gayli__business_type_edit"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__business_type_edit TO lsmb_lsmb_gayli__business_type_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:1020: NOTICE:  role "lsmb_lsmb_gayli__sic_all" is already a member of role "lsmb_lsmb_gayli__sic_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__sic_create TO lsmb_lsmb_gayli__sic_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:1021: NOTICE:  role "lsmb_lsmb_gayli__sic_all" is already a member of role "lsmb_lsmb_gayli__sic_edit"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__sic_edit TO lsmb_lsmb_gayli__sic_all"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:1032: NOTICE:  role "lsmb_lsmb_gayli__users_manage" is already a member of role "lsmb_lsmb_gayli__contact_read"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_read TO lsmb_lsmb_gayli__users_manage"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:1033: NOTICE:  role "lsmb_lsmb_gayli__users_manage" is already a member of role "lsmb_lsmb_gayli__contact_create"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_create TO lsmb_lsmb_gayli__users_manage"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:1034: NOTICE:  role "lsmb_lsmb_gayli__users_manage" is already a member of role "lsmb_lsmb_gayli__contact_class_employee"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__contact_class_employee TO lsmb_lsmb_gayli__users_manage"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:1048: NOTICE:  role "lsmb_lsmb_gayli__system_admin" is already a member of role "lsmb_lsmb_gayli__system_settings_change"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__system_settings_change TO lsmb_lsmb_gayli__system_admin"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:1048: NOTICE:  role "lsmb_lsmb_gayli__system_admin" is already a member of role "lsmb_lsmb_gayli__account_all"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__account_all TO lsmb_lsmb_gayli__system_admin"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:1048: NOTICE:  role "lsmb_lsmb_gayli__system_admin" is already a member of role "lsmb_lsmb_gayli__business_type_all"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__business_type_all TO lsmb_lsmb_gayli__system_admin"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:1048: NOTICE:  role "lsmb_lsmb_gayli__system_admin" is already a member of role "lsmb_lsmb_gayli__sic_all"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__sic_all TO lsmb_lsmb_gayli__system_admin"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:1048: NOTICE:  role "lsmb_lsmb_gayli__system_admin" is already a member of role "lsmb_lsmb_gayli__users_manage"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__users_manage TO lsmb_lsmb_gayli__system_admin"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:1048: NOTICE:  role "lsmb_lsmb_gayli__system_admin" is already a member of role "lsmb_lsmb_gayli__tax_form_save"
CONTEXT:  SQL statement "GRANT lsmb_lsmb_gayli__tax_form_save TO lsmb_lsmb_gayli__system_admin"
PL/pgSQL function lsmb__grant_role(text,text) line 3 at EXECUTE statement
psql:sql/modules/Roles.sql:1187: NOTICE:  trigger "eclass_perms_check" for relation "entity" does not exist, skipping
psql:sql/modules/Roles.sql:1192: NOTICE:  trigger "eclass_perms_check" for relation "entity_credit_account" does not exist, skipping
psql:sql/modules/Timecards.sql:90: NOTICE:  type "timecard_report_line" does not exist, skipping
psql:sql/modules/Fixes.sql:13: ERROR:  duplicate key value violates unique constraint "file_class_pkey"
DETAIL:  Key (class)=(internal) already exists.
psql:sql/modules/Fixes.sql:22: ERROR:  relation "file_internal" already exists
psql:sql/modules/Fixes.sql:26: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:30: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:37: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:42: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:46: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:50: ERROR:  relation "lot_tracking_number" already exists
psql:sql/modules/Fixes.sql:57: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:61: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:68: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:71: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:82: ERROR:  column "is_manager" of relation "entity_employee" already exists
psql:sql/modules/Fixes.sql:83: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:91: ERROR:  relation "fixed_acc_trans" already exists
psql:sql/modules/Fixes.sql:119: ERROR:  relation "location_class_to_entity_class" already exists
psql:sql/modules/Fixes.sql:121: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:124: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:126: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:127: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:129: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:137: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:140: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:164: ERROR:  duplicate key value violates unique constraint "menu_node_pkey"
DETAIL:  Key (id)=(90) already exists.
psql:sql/modules/Fixes.sql:175: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:179: ERROR:  column "birthdate" of relation "person" already exists
psql:sql/modules/Fixes.sql:180: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:204: WARNING:  there is no transaction in progress
psql:sql/modules/Fixes.sql:207: ERROR:  column "is_return" of relation "ar" already exists
psql:sql/modules/Fixes.sql:210: ERROR:  column "is_return" of relation "ap" already exists
psql:sql/modules/Fixes.sql:216: ERROR:  duplicate key value violates unique constraint "menu_node_pkey"
DETAIL:  Key (id)=(129) already exists.
psql:sql/modules/Fixes.sql:217: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:221: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:225: ERROR:  column "vendor_sku" of relation "invoice" already exists
psql:sql/modules/Fixes.sql:234: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:238: ERROR:  constraint "ar_invnumber_key" of relation "ar" does not exist
psql:sql/modules/Fixes.sql:239: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:240: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:242: ERROR:  column "setting_sequence" of relation "ar" already exists
psql:sql/modules/Fixes.sql:273: ERROR:  column "category" of relation "account_heading" already exists
psql:sql/modules/Fixes.sql:294: ERROR:  relation "business_unit_ac_entry_id_idx" already exists
psql:sql/modules/Fixes.sql:295: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:296: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:302: ERROR:  relation "account_translation" already exists
psql:sql/modules/Fixes.sql:304: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:307: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:310: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:312: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:315: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:365: ERROR:  duplicate key value violates unique constraint "menu_node_pkey"
DETAIL:  Key (id)=(28) already exists.
psql:sql/modules/Fixes.sql:367: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:368: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/modules/Fixes.sql:369: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:475: ERROR:  null value in column "chart_id" violates not-null constraint
DETAIL:  Failing row contains (11086, null, 257.76, 2011-06-14, null, f, f, null, null, t, null, null, null, 64).
psql:/tmp/ledgersmb/upgrade.sql:483: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:489: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:498: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:506: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:510: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:519: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:526: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:541: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:564: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:570: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:575: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:579: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:582: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:585: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:587: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:589: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:591: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:598: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:600: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:607: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:614: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:619: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:627: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:630: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:637: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:639: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:641: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:651: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:653: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:656: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:662: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:664: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:665: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:666: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:667: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:668: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:669: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:670: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:671: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:672: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:673: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:674: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:675: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:676: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:677: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:678: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:679: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:680: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:681: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:682: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:683: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:684: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:685: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:686: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:687: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:688: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:689: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:690: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:691: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:692: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:693: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:694: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:695: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:696: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:697: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:698: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:699: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:700: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:701: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:702: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:703: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:704: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:705: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:706: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:707: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:708: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:709: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:710: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:711: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:712: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:714: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:715: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:716: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:717: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:718: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/tmp/ledgersmb/upgrade.sql:720: ERROR:  current transaction is aborted, commands ignored until end of transaction block

2016-03-22 21:26:13 EDT [8989-1] postgres@lsmb_gayli ERROR:  schema "public" already exists
2016-03-22 21:26:13 EDT [8989-2] postgres@lsmb_gayli STATEMENT:  CREATE SCHEMA public;
2016-03-22 21:26:56 EDT [8993-1] lsmb_dbadmin@postgres ERROR:  function public.setting_get(unknown) does not exist at character 15
2016-03-22 21:26:56 EDT [8993-2] lsmb_dbadmin@postgres HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2016-03-22 21:26:56 EDT [8993-3] lsmb_dbadmin@postgres STATEMENT:  SELECT * FROM "public"."setting_get"('ignore_version')
2016-03-22 21:26:58 EDT [8996-1] lsmb_dbadmin@lsmb_gayli ERROR:  column "value" does not exist at character 8
2016-03-22 21:26:58 EDT [8996-2] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT value FROM defaults WHERE setting_key = $1
2016-03-22 21:27:06 EDT [9007-1] lsmb_dbadmin@lsmb_gayli ERROR:  column "value" does not exist at character 8
2016-03-22 21:27:06 EDT [9007-2] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT value FROM defaults WHERE setting_key = $1
2016-03-22 21:27:06 EDT [9007-3] lsmb_dbadmin@lsmb_gayli ERROR:  column "value" does not exist at character 8
2016-03-22 21:27:06 EDT [9007-4] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT value FROM defaults WHERE setting_key = $1
2016-03-22 21:27:32 EDT [9029-1] lsmb_dbadmin@lsmb_gayli ERROR:  duplicate key value violates unique constraint "file_class_pkey"
2016-03-22 21:27:32 EDT [9029-2] lsmb_dbadmin@lsmb_gayli DETAIL:  Key (class)=(internal) already exists.
2016-03-22 21:27:32 EDT [9029-3] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO file_class (id, class) values (6, 'internal'), (7, 'incoming');
2016-03-22 21:27:32 EDT [9029-4] lsmb_dbadmin@lsmb_gayli ERROR:  relation "file_internal" already exists
2016-03-22 21:27:32 EDT [9029-5] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE TABLE file_internal (
	   check (file_class = 6),
	   unique(id),
	   primary key (ref_key, file_name, file_class),
	   check (ref_key = 0)
	) inherits (file_base);
2016-03-22 21:27:32 EDT [9029-6] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-7] lsmb_dbadmin@lsmb_gayli STATEMENT:  COMMENT ON COLUMN file_internal.ref_key IS
	$$ Always must be 0, and we have no primary key since these files all
	are for internal use and against the company, not categorized.$$;
2016-03-22 21:27:32 EDT [9029-8] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-9] lsmb_dbadmin@lsmb_gayli STATEMENT:  COMMENT ON TABLE file_internal IS
	$$ This is for internal files used operationally by LedgerSMB.  For example,
	company logos would be here.$$;
2016-03-22 21:27:32 EDT [9029-10] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-11] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE TABLE file_incoming (
	   check (file_class = 7),
	   unique(id),
	   primary key (ref_key, file_name, file_class),
	   check (ref_key = 0) 
	) inherits (file_base);
2016-03-22 21:27:32 EDT [9029-12] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-13] lsmb_dbadmin@lsmb_gayli STATEMENT:  COMMENT ON COLUMN file_incoming.ref_key IS
	$$ Always must be 0, and we have no primary key since these files all
	are for interal incoming use, not categorized.$$;
2016-03-22 21:27:32 EDT [9029-14] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-15] lsmb_dbadmin@lsmb_gayli STATEMENT:  COMMENT ON TABLE file_incoming IS
	$$ This is essentially a spool for files to be reviewed and attached.  It is 
	important that the names are somehow guaranteed to be unique, so one may want to prepend them with an email equivalent or the like.$$;
2016-03-22 21:27:32 EDT [9029-16] lsmb_dbadmin@lsmb_gayli ERROR:  relation "lot_tracking_number" already exists
2016-03-22 21:27:32 EDT [9029-17] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE SEQUENCE lot_tracking_number;
2016-03-22 21:27:32 EDT [9029-18] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-19] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE TABLE mfg_lot (
	    id serial not null unique,
	    lot_number text not null unique default nextval('lot_tracking_number')::text,
	    parts_id int not null references parts(id),
	    qty numeric not null,
	    stock_date date not null default now()::date
	);
2016-03-22 21:27:32 EDT [9029-20] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-21] lsmb_dbadmin@lsmb_gayli STATEMENT:  COMMENT ON TABLE mfg_lot IS 
	$$ This tracks assembly restocks.  This is designed to work with old code and
	may change as we refactor the parts.$$;
2016-03-22 21:27:32 EDT [9029-22] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-23] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE TABLE mfg_lot_item (
	    id serial not null unique,
	    mfg_lot_id int not null references mfg_lot(id),
	    parts_id int not null references parts(id),
	    qty numeric not null
	);
2016-03-22 21:27:32 EDT [9029-24] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-25] lsmb_dbadmin@lsmb_gayli STATEMENT:  COMMENT ON TABLE mfg_lot_item IS
	$$ This tracks items used in assembly restocking.$$;
2016-03-22 21:27:32 EDT [9029-26] lsmb_dbadmin@lsmb_gayli ERROR:  column "is_manager" of relation "entity_employee" already exists
2016-03-22 21:27:32 EDT [9029-27] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE entity_employee ADD is_manager bool DEFAULT FALSE;
2016-03-22 21:27:32 EDT [9029-28] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-29] lsmb_dbadmin@lsmb_gayli STATEMENT:  UPDATE entity_employee SET is_manager = true WHERE role = 'manager';
2016-03-22 21:27:32 EDT [9029-30] lsmb_dbadmin@lsmb_gayli ERROR:  relation "location_class_to_entity_class" already exists
2016-03-22 21:27:32 EDT [9029-31] lsmb_dbadmin@lsmb_gayli STATEMENT:  create table location_class_to_entity_class (
	  id serial unique,
	  location_class int not null references location_class(id),
	  entity_class int not null references entity_class(id)
	);
2016-03-22 21:27:32 EDT [9029-32] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-33] lsmb_dbadmin@lsmb_gayli STATEMENT:  GRANT SELECT ON location_class_to_entity_class TO PUBLIC;
2016-03-22 21:27:32 EDT [9029-34] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-35] lsmb_dbadmin@lsmb_gayli STATEMENT:  COMMENT ON TABLE location_class_to_entity_class IS
	$$This determines which location classes go with which entity classes$$;
2016-03-22 21:27:32 EDT [9029-36] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-37] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO location_class(id,class,authoritative) VALUES ('4','Physical',TRUE);
2016-03-22 21:27:32 EDT [9029-38] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-39] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO location_class(id,class,authoritative) VALUES ('5','Mailing',FALSE);
2016-03-22 21:27:32 EDT [9029-40] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-41] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT SETVAL('location_class_id_seq',5);
2016-03-22 21:27:32 EDT [9029-42] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-43] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO location_class_to_entity_class
	       (location_class, entity_class)
	SELECT lc.id, ec.id
	  FROM entity_class ec
	 cross
	  join location_class lc
	 WHERE ec.id <> 3 and lc.id < 4;
2016-03-22 21:27:32 EDT [9029-44] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-45] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO location_class_to_entity_class (location_class, entity_class)
	SELECT id, 3 from location_class lc where lc.id > 3;
2016-03-22 21:27:32 EDT [9029-46] lsmb_dbadmin@lsmb_gayli ERROR:  function setting_get(unknown) does not exist at character 83
2016-03-22 21:27:32 EDT [9029-47] lsmb_dbadmin@lsmb_gayli HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2016-03-22 21:27:32 EDT [9029-48] lsmb_dbadmin@lsmb_gayli STATEMENT:  UPDATE entity_credit_account
	   SET curr = (select s from unnest(string_to_array((setting_get('curr')).value, ':')) s limit 1)
	 WHERE curr IS NULL;
2016-03-22 21:27:32 EDT [9029-49] lsmb_dbadmin@lsmb_gayli ERROR:  duplicate key value violates unique constraint "menu_node_pkey"
2016-03-22 21:27:32 EDT [9029-50] lsmb_dbadmin@lsmb_gayli DETAIL:  Key (id)=(90) already exists.
2016-03-22 21:27:32 EDT [9029-51] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO menu_node (id, parent, position, label)
	VALUES (90, 172, 2, 'Product Receipt'),
	       (99, 156, 2, 'Product Receipt');
2016-03-22 21:27:32 EDT [9029-52] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-53] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO menu_attribute 
	(id, node_id, attribute, value) VALUES
	(228, 90, 'module', 'template.pm'),
	(229, 90, 'action', 'display'),
	(230, 90, 'template_name', 'product_receipt'),
	(231, 90, 'format', 'tex'),
	(240, 99, 'module', 'template.pm'),
	(241, 99, 'action', 'display'),
	(242, 99, 'template_name', 'product_receipt'),
	(245, 99, 'format', 'html');
2016-03-22 21:27:32 EDT [9029-54] lsmb_dbadmin@lsmb_gayli ERROR:  column "birthdate" of relation "person" already exists
2016-03-22 21:27:32 EDT [9029-55] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE person ADD COLUMN birthdate date;
2016-03-22 21:27:32 EDT [9029-56] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-57] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE person ADD COLUMN personal_id text;
2016-03-22 21:27:32 EDT [9029-58] lsmb_dbadmin@lsmb_gayli WARNING:  there is no transaction in progress
2016-03-22 21:27:32 EDT [9029-59] lsmb_dbadmin@lsmb_gayli ERROR:  column "is_return" of relation "ar" already exists
2016-03-22 21:27:32 EDT [9029-60] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE ar ADD COLUMN is_return bool default false;
2016-03-22 21:27:32 EDT [9029-61] lsmb_dbadmin@lsmb_gayli ERROR:  column "is_return" of relation "ap" already exists
2016-03-22 21:27:32 EDT [9029-62] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE ap ADD COLUMN is_return bool default false;
2016-03-22 21:27:32 EDT [9029-63] lsmb_dbadmin@lsmb_gayli ERROR:  duplicate key value violates unique constraint "menu_node_pkey"
2016-03-22 21:27:32 EDT [9029-64] lsmb_dbadmin@lsmb_gayli DETAIL:  Key (id)=(129) already exists.
2016-03-22 21:27:32 EDT [9029-65] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO menu_node (id, parent, position, label)
	VALUES (129, 1, 7, 'Add Return');
2016-03-22 21:27:32 EDT [9029-66] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-67] lsmb_dbadmin@lsmb_gayli STATEMENT:  update menu_node set position = position * -1 where position < 0;
2016-03-22 21:27:32 EDT [9029-68] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-69] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO menu_attribute (id, node_id, attribute, value)
	VALUES (251, 129, 'module', 'is.pl'),
	       (252, 129, 'action', 'add'),
	       (253, 129, 'type', 'customer_return');
2016-03-22 21:27:32 EDT [9029-70] lsmb_dbadmin@lsmb_gayli ERROR:  column "vendor_sku" of relation "invoice" already exists
2016-03-22 21:27:32 EDT [9029-71] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE invoice ADD vendor_sku text;
2016-03-22 21:27:32 EDT [9029-72] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-73] lsmb_dbadmin@lsmb_gayli STATEMENT:  UPDATE invoice SET vendor_sku = (select min(partnumber) from partsvendor
	                                  where parts_id = invoice.parts_id
	                                        AND credit_id = (
	                                                 select entity_credit_account
	                                                   from ap
	                                                  where ap.id = invoice.trans_id
	                                        )
	                                )
	 WHERE trans_id in (select id from ap);
2016-03-22 21:27:32 EDT [9029-74] lsmb_dbadmin@lsmb_gayli ERROR:  constraint "ar_invnumber_key" of relation "ar" does not exist
2016-03-22 21:27:32 EDT [9029-75] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE ar DROP CONSTRAINT ar_invnumber_key;
2016-03-22 21:27:32 EDT [9029-76] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-77] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE ar ADD CHECK(invnumber is not null OR not approved);
2016-03-22 21:27:32 EDT [9029-78] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-79] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE UNIQUE INDEX ar_invnumber_key_p ON ar(invnumber) where invnumber is not null;
2016-03-22 21:27:32 EDT [9029-80] lsmb_dbadmin@lsmb_gayli ERROR:  column "setting_sequence" of relation "ar" already exists
2016-03-22 21:27:32 EDT [9029-81] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE ar ADD setting_sequence TEXT;
2016-03-22 21:27:32 EDT [9029-82] lsmb_dbadmin@lsmb_gayli ERROR:  column "category" of relation "account_heading" already exists
2016-03-22 21:27:32 EDT [9029-83] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE account_heading ADD COLUMN category CHAR(1);
2016-03-22 21:27:32 EDT [9029-84] lsmb_dbadmin@lsmb_gayli ERROR:  relation "business_unit_ac_entry_id_idx" already exists
2016-03-22 21:27:32 EDT [9029-85] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE INDEX business_unit_ac_entry_id_idx ON business_unit_ac (entry_id);
2016-03-22 21:27:32 EDT [9029-86] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-87] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE INDEX business_unit_inv_entry_id_idx ON business_unit_inv(entry_id);
2016-03-22 21:27:32 EDT [9029-88] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-89] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE INDEX business_unit_oitem_entry_id_idx ON business_unit_oitem(entry_id);
2016-03-22 21:27:32 EDT [9029-90] lsmb_dbadmin@lsmb_gayli ERROR:  relation "account_translation" already exists
2016-03-22 21:27:32 EDT [9029-91] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE TABLE account_translation
	(PRIMARY KEY (trans_id, language_code)) INHERITS (translation);
2016-03-22 21:27:32 EDT [9029-92] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-93] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE account_translation
	ADD foreign key (trans_id) REFERENCES account(id);
2016-03-22 21:27:32 EDT [9029-94] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-95] lsmb_dbadmin@lsmb_gayli STATEMENT:  COMMENT ON TABLE account_translation IS
	$$Translations for account descriptions.$$;
2016-03-22 21:27:32 EDT [9029-96] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-97] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE TABLE account_heading_translation
	(PRIMARY KEY (trans_id, language_code)) INHERITS (translation);
2016-03-22 21:27:32 EDT [9029-98] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-99] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE account_heading_translation
	ADD foreign key (trans_id) REFERENCES account_heading(id);
2016-03-22 21:27:32 EDT [9029-100] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:32 EDT [9029-101] lsmb_dbadmin@lsmb_gayli STATEMENT:  COMMENT ON TABLE account_heading_translation IS
	$$Translations for account heading descriptions.$$;
2016-03-22 21:27:39 EDT [9440-1] lsmb_dbadmin@lsmb_gayli ERROR:  duplicate key value violates unique constraint "file_class_pkey"
2016-03-22 21:27:39 EDT [9440-2] lsmb_dbadmin@lsmb_gayli DETAIL:  Key (class)=(internal) already exists.
2016-03-22 21:27:39 EDT [9440-3] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO file_class (id, class) values (6, 'internal'), (7, 'incoming');
2016-03-22 21:27:39 EDT [9440-4] lsmb_dbadmin@lsmb_gayli ERROR:  relation "file_internal" already exists
2016-03-22 21:27:39 EDT [9440-5] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE TABLE file_internal (
	   check (file_class = 6),
	   unique(id),
	   primary key (ref_key, file_name, file_class),
	   check (ref_key = 0)
	) inherits (file_base);
2016-03-22 21:27:39 EDT [9440-6] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-7] lsmb_dbadmin@lsmb_gayli STATEMENT:  COMMENT ON COLUMN file_internal.ref_key IS
	$$ Always must be 0, and we have no primary key since these files all
	are for internal use and against the company, not categorized.$$;
2016-03-22 21:27:39 EDT [9440-8] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-9] lsmb_dbadmin@lsmb_gayli STATEMENT:  COMMENT ON TABLE file_internal IS
	$$ This is for internal files used operationally by LedgerSMB.  For example,
	company logos would be here.$$;
2016-03-22 21:27:39 EDT [9440-10] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-11] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE TABLE file_incoming (
	   check (file_class = 7),
	   unique(id),
	   primary key (ref_key, file_name, file_class),
	   check (ref_key = 0) 
	) inherits (file_base);
2016-03-22 21:27:39 EDT [9440-12] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-13] lsmb_dbadmin@lsmb_gayli STATEMENT:  COMMENT ON COLUMN file_incoming.ref_key IS
	$$ Always must be 0, and we have no primary key since these files all
	are for interal incoming use, not categorized.$$;
2016-03-22 21:27:39 EDT [9440-14] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-15] lsmb_dbadmin@lsmb_gayli STATEMENT:  COMMENT ON TABLE file_incoming IS
	$$ This is essentially a spool for files to be reviewed and attached.  It is 
	important that the names are somehow guaranteed to be unique, so one may want to prepend them with an email equivalent or the like.$$;
2016-03-22 21:27:39 EDT [9440-16] lsmb_dbadmin@lsmb_gayli ERROR:  relation "lot_tracking_number" already exists
2016-03-22 21:27:39 EDT [9440-17] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE SEQUENCE lot_tracking_number;
2016-03-22 21:27:39 EDT [9440-18] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-19] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE TABLE mfg_lot (
	    id serial not null unique,
	    lot_number text not null unique default nextval('lot_tracking_number')::text,
	    parts_id int not null references parts(id),
	    qty numeric not null,
	    stock_date date not null default now()::date
	);
2016-03-22 21:27:39 EDT [9440-20] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-21] lsmb_dbadmin@lsmb_gayli STATEMENT:  COMMENT ON TABLE mfg_lot IS 
	$$ This tracks assembly restocks.  This is designed to work with old code and
	may change as we refactor the parts.$$;
2016-03-22 21:27:39 EDT [9440-22] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-23] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE TABLE mfg_lot_item (
	    id serial not null unique,
	    mfg_lot_id int not null references mfg_lot(id),
	    parts_id int not null references parts(id),
	    qty numeric not null
	);
2016-03-22 21:27:39 EDT [9440-24] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-25] lsmb_dbadmin@lsmb_gayli STATEMENT:  COMMENT ON TABLE mfg_lot_item IS
	$$ This tracks items used in assembly restocking.$$;
2016-03-22 21:27:39 EDT [9440-26] lsmb_dbadmin@lsmb_gayli ERROR:  column "is_manager" of relation "entity_employee" already exists
2016-03-22 21:27:39 EDT [9440-27] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE entity_employee ADD is_manager bool DEFAULT FALSE;
2016-03-22 21:27:39 EDT [9440-28] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-29] lsmb_dbadmin@lsmb_gayli STATEMENT:  UPDATE entity_employee SET is_manager = true WHERE role = 'manager';
2016-03-22 21:27:39 EDT [9440-30] lsmb_dbadmin@lsmb_gayli ERROR:  relation "fixed_acc_trans" already exists
2016-03-22 21:27:39 EDT [9440-31] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE TABLE fixed_acc_trans (LIKE acc_trans);
2016-03-22 21:27:39 EDT [9440-32] lsmb_dbadmin@lsmb_gayli ERROR:  relation "location_class_to_entity_class" already exists
2016-03-22 21:27:39 EDT [9440-33] lsmb_dbadmin@lsmb_gayli STATEMENT:  create table location_class_to_entity_class (
	  id serial unique,
	  location_class int not null references location_class(id),
	  entity_class int not null references entity_class(id)
	);
2016-03-22 21:27:39 EDT [9440-34] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-35] lsmb_dbadmin@lsmb_gayli STATEMENT:  GRANT SELECT ON location_class_to_entity_class TO PUBLIC;
2016-03-22 21:27:39 EDT [9440-36] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-37] lsmb_dbadmin@lsmb_gayli STATEMENT:  COMMENT ON TABLE location_class_to_entity_class IS
	$$This determines which location classes go with which entity classes$$;
2016-03-22 21:27:39 EDT [9440-38] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-39] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO location_class(id,class,authoritative) VALUES ('4','Physical',TRUE);
2016-03-22 21:27:39 EDT [9440-40] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-41] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO location_class(id,class,authoritative) VALUES ('5','Mailing',FALSE);
2016-03-22 21:27:39 EDT [9440-42] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-43] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT SETVAL('location_class_id_seq',5);
2016-03-22 21:27:39 EDT [9440-44] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-45] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO location_class_to_entity_class
	       (location_class, entity_class)
	SELECT lc.id, ec.id
	  FROM entity_class ec
	 cross
	  join location_class lc
	 WHERE ec.id <> 3 and lc.id < 4;
2016-03-22 21:27:39 EDT [9440-46] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-47] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO location_class_to_entity_class (location_class, entity_class)
	SELECT id, 3 from location_class lc where lc.id > 3;
2016-03-22 21:27:39 EDT [9440-48] lsmb_dbadmin@lsmb_gayli ERROR:  duplicate key value violates unique constraint "menu_node_pkey"
2016-03-22 21:27:39 EDT [9440-49] lsmb_dbadmin@lsmb_gayli DETAIL:  Key (id)=(90) already exists.
2016-03-22 21:27:39 EDT [9440-50] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO menu_node (id, parent, position, label)
	VALUES (90, 172, 2, 'Product Receipt'),
	       (99, 156, 2, 'Product Receipt');
2016-03-22 21:27:39 EDT [9440-51] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-52] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO menu_attribute 
	(id, node_id, attribute, value) VALUES
	(228, 90, 'module', 'template.pm'),
	(229, 90, 'action', 'display'),
	(230, 90, 'template_name', 'product_receipt'),
	(231, 90, 'format', 'tex'),
	(240, 99, 'module', 'template.pm'),
	(241, 99, 'action', 'display'),
	(242, 99, 'template_name', 'product_receipt'),
	(245, 99, 'format', 'html');
2016-03-22 21:27:39 EDT [9440-53] lsmb_dbadmin@lsmb_gayli ERROR:  column "birthdate" of relation "person" already exists
2016-03-22 21:27:39 EDT [9440-54] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE person ADD COLUMN birthdate date;
2016-03-22 21:27:39 EDT [9440-55] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-56] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE person ADD COLUMN personal_id text;
2016-03-22 21:27:39 EDT [9440-57] lsmb_dbadmin@lsmb_gayli WARNING:  there is no transaction in progress
2016-03-22 21:27:39 EDT [9440-58] lsmb_dbadmin@lsmb_gayli ERROR:  column "is_return" of relation "ar" already exists
2016-03-22 21:27:39 EDT [9440-59] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE ar ADD COLUMN is_return bool default false;
2016-03-22 21:27:39 EDT [9440-60] lsmb_dbadmin@lsmb_gayli ERROR:  column "is_return" of relation "ap" already exists
2016-03-22 21:27:39 EDT [9440-61] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE ap ADD COLUMN is_return bool default false;
2016-03-22 21:27:39 EDT [9440-62] lsmb_dbadmin@lsmb_gayli ERROR:  duplicate key value violates unique constraint "menu_node_pkey"
2016-03-22 21:27:39 EDT [9440-63] lsmb_dbadmin@lsmb_gayli DETAIL:  Key (id)=(129) already exists.
2016-03-22 21:27:39 EDT [9440-64] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO menu_node (id, parent, position, label)
	VALUES (129, 1, 7, 'Add Return');
2016-03-22 21:27:39 EDT [9440-65] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-66] lsmb_dbadmin@lsmb_gayli STATEMENT:  update menu_node set position = position * -1 where position < 0;
2016-03-22 21:27:39 EDT [9440-67] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-68] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO menu_attribute (id, node_id, attribute, value)
	VALUES (251, 129, 'module', 'is.pl'),
	       (252, 129, 'action', 'add'),
	       (253, 129, 'type', 'customer_return');
2016-03-22 21:27:39 EDT [9440-69] lsmb_dbadmin@lsmb_gayli ERROR:  column "vendor_sku" of relation "invoice" already exists
2016-03-22 21:27:39 EDT [9440-70] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE invoice ADD vendor_sku text;
2016-03-22 21:27:39 EDT [9440-71] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-72] lsmb_dbadmin@lsmb_gayli STATEMENT:  UPDATE invoice SET vendor_sku = (select min(partnumber) from partsvendor
	                                  where parts_id = invoice.parts_id
	                                        AND credit_id = (
	                                                 select entity_credit_account
	                                                   from ap
	                                                  where ap.id = invoice.trans_id
	                                        )
	                                )
	 WHERE trans_id in (select id from ap);
2016-03-22 21:27:39 EDT [9440-73] lsmb_dbadmin@lsmb_gayli ERROR:  constraint "ar_invnumber_key" of relation "ar" does not exist
2016-03-22 21:27:39 EDT [9440-74] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE ar DROP CONSTRAINT ar_invnumber_key;
2016-03-22 21:27:39 EDT [9440-75] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-76] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE ar ADD CHECK(invnumber is not null OR not approved);
2016-03-22 21:27:39 EDT [9440-77] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-78] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE UNIQUE INDEX ar_invnumber_key_p ON ar(invnumber) where invnumber is not null;
2016-03-22 21:27:39 EDT [9440-79] lsmb_dbadmin@lsmb_gayli ERROR:  column "setting_sequence" of relation "ar" already exists
2016-03-22 21:27:39 EDT [9440-80] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE ar ADD setting_sequence TEXT;
2016-03-22 21:27:39 EDT [9440-81] lsmb_dbadmin@lsmb_gayli ERROR:  column "category" of relation "account_heading" already exists
2016-03-22 21:27:39 EDT [9440-82] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE account_heading ADD COLUMN category CHAR(1);
2016-03-22 21:27:39 EDT [9440-83] lsmb_dbadmin@lsmb_gayli ERROR:  relation "business_unit_ac_entry_id_idx" already exists
2016-03-22 21:27:39 EDT [9440-84] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE INDEX business_unit_ac_entry_id_idx ON business_unit_ac (entry_id);
2016-03-22 21:27:39 EDT [9440-85] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-86] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE INDEX business_unit_inv_entry_id_idx ON business_unit_inv(entry_id);
2016-03-22 21:27:39 EDT [9440-87] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-88] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE INDEX business_unit_oitem_entry_id_idx ON business_unit_oitem(entry_id);
2016-03-22 21:27:39 EDT [9440-89] lsmb_dbadmin@lsmb_gayli ERROR:  relation "account_translation" already exists
2016-03-22 21:27:39 EDT [9440-90] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE TABLE account_translation
	(PRIMARY KEY (trans_id, language_code)) INHERITS (translation);
2016-03-22 21:27:39 EDT [9440-91] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-92] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE account_translation
	ADD foreign key (trans_id) REFERENCES account(id);
2016-03-22 21:27:39 EDT [9440-93] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-94] lsmb_dbadmin@lsmb_gayli STATEMENT:  COMMENT ON TABLE account_translation IS
	$$Translations for account descriptions.$$;
2016-03-22 21:27:39 EDT [9440-95] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-96] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE TABLE account_heading_translation
	(PRIMARY KEY (trans_id, language_code)) INHERITS (translation);
2016-03-22 21:27:39 EDT [9440-97] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-98] lsmb_dbadmin@lsmb_gayli STATEMENT:  ALTER TABLE account_heading_translation
	ADD foreign key (trans_id) REFERENCES account_heading(id);
2016-03-22 21:27:39 EDT [9440-99] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-100] lsmb_dbadmin@lsmb_gayli STATEMENT:  COMMENT ON TABLE account_heading_translation IS
	$$Translations for account heading descriptions.$$;
2016-03-22 21:27:39 EDT [9440-101] lsmb_dbadmin@lsmb_gayli ERROR:  duplicate key value violates unique constraint "menu_node_pkey"
2016-03-22 21:27:39 EDT [9440-102] lsmb_dbadmin@lsmb_gayli DETAIL:  Key (id)=(28) already exists.
2016-03-22 21:27:39 EDT [9440-103] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO menu_node(id, parent, position, label) values (28, 0, 17, 'Transaction Templates');
2016-03-22 21:27:39 EDT [9440-104] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-105] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO menu_attribute(id, node_id, attribute, value)
	values (254, 28, 'module', 'transtemplate.pl'), (255, 28, 'action', 'list');
2016-03-22 21:27:39 EDT [9440-106] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-107] lsmb_dbadmin@lsmb_gayli STATEMENT:  DROP INDEX "je_unique_source";
2016-03-22 21:27:39 EDT [9440-108] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:39 EDT [9440-109] lsmb_dbadmin@lsmb_gayli STATEMENT:  CREATE UNIQUE INDEX "je_unique_source" ON journal_entry(journal, reference) where journal in (1, 2) and not is_template;
2016-03-22 21:27:40 EDT [9450-1] lsmb_dbadmin@lsmb_gayli ERROR:  null value in column "chart_id" violates not-null constraint
2016-03-22 21:27:40 EDT [9450-2] lsmb_dbadmin@lsmb_gayli DETAIL:  Failing row contains (11086, null, 257.76, 2011-06-14, null, f, f, null, null, t, null, null, null, 64).
2016-03-22 21:27:40 EDT [9450-3] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO acc_trans
	(entry_id, trans_id, chart_id, amount, transdate, source, cleared, fx_transaction, 
		memo, approved, cleared_on, voucher_id)
	SELECT lsmb_entry_id, trans_id, (select id
	                    from account
	                   where accno = (select accno
	                                    from sl30.chart
	                                   where chart.id = acc_trans.chart_id)),
	                                    amount, transdate, source,
		CASE WHEN cleared IS NOT NULL THEN TRUE ELSE FALSE END, fx_transaction,
		memo, approved, cleared, vr_id
		FROM sl30.acc_trans ;
2016-03-22 21:27:40 EDT [9450-4] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-5] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO business_unit_ac (entry_id, class_id, bu_id)
	SELECT ac.entry_id, 1, gl.department_id
	  FROM acc_trans ac 
	  JOIN (SELECT id, department_id FROM sl30.ar UNION ALL
	        SELECT id, department_id FROM sl30.ap UNION ALL
	        SELECT id, department_id FROM sl30.gl) gl ON gl.id = ac.trans_id 
	 WHERE department_id > 0;
2016-03-22 21:27:40 EDT [9450-6] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-7] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO business_unit_ac (entry_id, class_id, bu_id)
	SELECT ac.entry_id, 2, slac.project_id+1000
	  FROM acc_trans ac 
	  JOIN sl30.acc_trans slac ON slac.entry_id = ac.entry_id 
	 WHERE project_id > 0;
2016-03-22 21:27:40 EDT [9450-8] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-9] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO invoice (id, trans_id, parts_id, description, qty, allocated,
	            sellprice, fxsellprice, discount, assemblyitem, unit,
	            deliverydate, serialnumber)
	    SELECT  id, trans_id, parts_id, description, qty, allocated,
	            sellprice, fxsellprice, discount, assemblyitem, unit,
	            deliverydate, serialnumber
	       FROM sl30.invoice;
2016-03-22 21:27:40 EDT [9450-10] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-11] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO business_unit_inv (entry_id, class_id, bu_id)
	SELECT inv.id, 1, gl.department_id
	  FROM invoice inv 
	  JOIN (SELECT id, department_id FROM sl30.ar UNION ALL
	        SELECT id, department_id FROM sl30.ap UNION ALL
	        SELECT id, department_id FROM sl30.gl) gl ON gl.id = inv.trans_id
	 WHERE department_id > 0;
2016-03-22 21:27:40 EDT [9450-12] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-13] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO business_unit_inv (entry_id, class_id, bu_id)
	SELECT id, 2, project_id + 1000 FROM sl30.invoice 
	 WHERE project_id > 0 and  project_id in (select id from sl30.project);
2016-03-22 21:27:40 EDT [9450-14] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-15] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO partstax (parts_id, chart_id)
	     SELECT parts_id, a.id
	       FROM sl30.partstax pt
	       JOIN sl30.chart ON chart.id = pt.chart_id
	       JOIN account a ON chart.accno = a.accno;
2016-03-22 21:27:40 EDT [9450-16] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-17] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO tax(chart_id, rate, taxnumber, validto, pass, taxmodule_id)
	     SELECT a.id, t.rate, t.taxnumber, 
	            coalesce(t.validto::timestamp, 'infinity'), 1, 1
	       FROM sl30.tax t
	       JOIN sl30.chart c ON (t.chart_id = c.id)
	       JOIN account a ON (a.accno = c.accno);
2016-03-22 21:27:40 EDT [9450-18] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-19] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO eca_tax (eca_id, chart_id)
	  SELECT c.credit_id, (select id from account
	                      where accno = (select accno from sl30.chart sc
	                                      where sc.id = ct.chart_id))
	   FROM sl30.customertax ct
	   JOIN sl30.customer c
	     ON ct.customer_id = c.id
	  UNION
	  SELECT v.credit_id, (select id from account
	                      where accno = (select accno from sl30.chart sc
	                                      where sc.id = vt.chart_id))
	   FROM sl30.vendortax vt
	   JOIN sl30.vendor v
	     ON vt.vendor_id = v.id;
2016-03-22 21:27:40 EDT [9450-20] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-21] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT 
	  INTO oe(id, ordnumber, transdate, amount, netamount, reqdate, taxincluded,
	       shippingpoint, notes, curr, person_id, closed, quotation, quonumber,
	       intnotes, shipvia, language_code, ponumber, terms,
	       entity_credit_account, oe_class_id)
	SELECT oe.id,  ordnumber, transdate, amount, netamount, reqdate, oe.taxincluded,
	       shippingpoint, oe.notes, oe.curr, p.id, closed, quotation, quonumber,
	       intnotes, shipvia, oe.language_code, ponumber, oe.terms,
	       coalesce(c.credit_id, v.credit_id),
	       case 
	           when c.id is not null and quotation is not true THEN 1
	           WHEN v.id is not null and quotation is not true THEN 2
	           when c.id is not null and quotation is true THEN 3
	           WHEN v.id is not null and quotation is true THEN 4
	       end
	  FROM sl30.oe
	  LEFT JOIN sl30.customer c ON c.id = oe.customer_id
	  LEFT JOIN sl30.vendor v ON v.id = oe.vendor_id
	  LEFT JOIN sl30.employee e ON oe.employee_id = e.id
	  LEFT JOIN person p ON e.entity_id = p.id;
2016-03-22 21:27:40 EDT [9450-22] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-23] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO orderitems(id, trans_id, parts_id, description, qty, sellprice,
	            discount, unit, reqdate, ship, serialnumber)
	     SELECT id, trans_id, parts_id, description, qty, sellprice,
	            discount, unit, reqdate, ship, serialnumber
	       FROM sl30.orderitems;
2016-03-22 21:27:40 EDT [9450-24] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-25] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO business_unit_oitem (entry_id, class_id, bu_id)
	SELECT oi.id, 1, oe.department_id 
	  FROM orderitems oi
	  JOIN sl30.oe ON oi.trans_id = oe.id AND department_id > 0;
2016-03-22 21:27:40 EDT [9450-26] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-27] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO business_unit_oitem (entry_id, class_id, bu_id)
	SELECT id, 2, project_id + 1000 FROM sl30.orderitems
	 WHERE project_id > 0  and  project_id in (select id from sl30.project);
2016-03-22 21:27:40 EDT [9450-28] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-29] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO exchangerate select * from sl30.exchangerate;
2016-03-22 21:27:40 EDT [9450-30] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-31] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO status SELECT * FROM sl30.status;
2016-03-22 21:27:40 EDT [9450-32] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-33] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO business SELECT * FROM sl30.business;
2016-03-22 21:27:40 EDT [9450-34] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-35] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO sic SELECT * FROM sl30.sic;
2016-03-22 21:27:40 EDT [9450-36] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-37] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO warehouse SELECT * FROM sl30.warehouse;
2016-03-22 21:27:40 EDT [9450-38] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-39] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO inventory(entity_id, warehouse_id, parts_id, trans_id,
	            orderitems_id, qty, shippingdate)
	     SELECT e.entity_id, warehouse_id, parts_id, trans_id,
	            orderitems_id, qty, shippingdate
	       FROM sl30.inventory i
	       JOIN sl30.employee e ON i.employee_id = e.id;
2016-03-22 21:27:40 EDT [9450-40] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-41] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO yearend (trans_id, transdate) SELECT * FROM sl30.yearend;
2016-03-22 21:27:40 EDT [9450-42] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-43] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO partsvendor(credit_id, parts_id, partnumber, leadtime, lastcost,
	            curr)
	     SELECT v.credit_id, parts_id, partnumber, leadtime, lastcost,
	            pv.curr
	       FROM sl30.partsvendor pv
	       JOIN sl30.vendor v ON v.id = pv.vendor_id;
2016-03-22 21:27:40 EDT [9450-44] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-45] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO partscustomer(parts_id, credit_id, pricegroup_id, pricebreak,
	            sellprice, validfrom, validto, curr)
	     SELECT parts_id, credit_id, pv.pricegroup_id, pricebreak,
	            sellprice, validfrom, validto, pv.curr
	       FROM sl30.partscustomer pv
	       JOIN sl30.customer v ON v.id = pv.customer_id;
2016-03-22 21:27:40 EDT [9450-46] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-47] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO language
	SELECT * FROM sl30.language sllang
	 WHERE NOT EXISTS (SELECT 1
	                     FROM language l WHERE l.code = sllang.code);
2016-03-22 21:27:40 EDT [9450-48] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-49] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO audittrail(trans_id, tablename, reference, formname, action,
	            transdate, person_id)
	     SELECT trans_id, tablename, reference, formname, action,
	            transdate, p.entity_id
	       FROM sl30.audittrail a
	       JOIN sl30.employee e ON a.employee_id = e.id
	       JOIN person p on e.entity_id = p.entity_id;
2016-03-22 21:27:40 EDT [9450-50] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-51] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO user_preference(id)
	     SELECT id from users;
2016-03-22 21:27:40 EDT [9450-52] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-53] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO recurring(id, reference, startdate, nextdate, enddate,
	            recurring_interval, howmany, payment)
	     SELECT id, reference, startdate, nextdate, enddate, 
	            (repeat || ' ' || unit)::interval,
	            howmany, payment 
	       FROM sl30.recurring;
2016-03-22 21:27:40 EDT [9450-54] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-55] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO recurringemail SELECT * FROM sl30.recurringemail;
2016-03-22 21:27:40 EDT [9450-56] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-57] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO recurringprint SELECT * FROM sl30.recurringprint;
2016-03-22 21:27:40 EDT [9450-58] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-59] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO jcitems(id, parts_id, description, qty, allocated,
	            sellprice, fxsellprice, serialnumber, checkedin, checkedout,
	            person_id, notes, business_unit_id)
	     SELECT j.id,  parts_id, description, qty, allocated,
	            sellprice, fxsellprice, serialnumber, checkedin, checkedout,
	            p.id, j.notes, j.project_id+1000
	       FROM sl30.jcitems j
	       JOIN sl30.employee e ON j.employee_id = e.id
	       JOIN person p ON e.entity_id = p.entity_id;
2016-03-22 21:27:40 EDT [9450-60] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-61] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO parts_translation SELECT * FROM sl30.translation where trans_id in (select id from parts);
2016-03-22 21:27:40 EDT [9450-62] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-63] lsmb_dbadmin@lsmb_gayli STATEMENT:  INSERT INTO partsgroup_translation SELECT * FROM sl30.translation where trans_id in
	 (select id from partsgroup);
2016-03-22 21:27:40 EDT [9450-64] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-65] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('id', max(id)) FROM transactions;
2016-03-22 21:27:40 EDT [9450-66] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-67] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('acc_trans_entry_id_seq', max(entry_id)) FROM acc_trans;
2016-03-22 21:27:40 EDT [9450-68] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-69] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('partsvendor_entry_id_seq', max(entry_id)) FROM partsvendor;
2016-03-22 21:27:40 EDT [9450-70] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-71] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('inventory_entry_id_seq', max(entry_id)) FROM inventory;
2016-03-22 21:27:40 EDT [9450-72] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-73] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('partscustomer_entry_id_seq', max(entry_id)) FROM partscustomer;
2016-03-22 21:27:40 EDT [9450-74] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-75] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('audittrail_entry_id_seq', max(entry_id)) FROM audittrail;
2016-03-22 21:27:40 EDT [9450-76] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-77] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('account_id_seq', max(id)) FROM account;
2016-03-22 21:27:40 EDT [9450-78] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-79] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('account_heading_id_seq', max(id)) FROM account_heading;
2016-03-22 21:27:40 EDT [9450-80] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-81] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('account_checkpoint_id_seq', max(id)) FROM account_checkpoint;
2016-03-22 21:27:40 EDT [9450-82] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-83] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('pricegroup_id_seq', max(id)) FROM pricegroup;
2016-03-22 21:27:40 EDT [9450-84] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-85] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('country_id_seq', max(id)) FROM country;
2016-03-22 21:27:40 EDT [9450-86] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-87] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('country_tax_form_id_seq', max(id)) FROM country_tax_form;
2016-03-22 21:27:40 EDT [9450-88] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-89] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('asset_dep_method_id_seq', max(id)) FROM asset_dep_method;
2016-03-22 21:27:40 EDT [9450-90] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-91] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('asset_class_id_seq', max(id)) FROM asset_class;
2016-03-22 21:27:40 EDT [9450-92] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-93] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('entity_class_id_seq', max(id)) FROM entity_class;
2016-03-22 21:27:40 EDT [9450-94] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-95] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('asset_item_id_seq', max(id)) FROM asset_item;
2016-03-22 21:27:40 EDT [9450-96] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-97] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('asset_disposal_method_id_seq', max(id)) FROM asset_disposal_method;
2016-03-22 21:27:40 EDT [9450-98] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-99] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('users_id_seq', max(id)) FROM users;
2016-03-22 21:27:40 EDT [9450-100] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-101] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('entity_id_seq', max(id)) FROM entity;
2016-03-22 21:27:40 EDT [9450-102] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-103] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('company_id_seq', max(id)) FROM company;
2016-03-22 21:27:40 EDT [9450-104] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-105] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('location_id_seq', max(id)) FROM location;
2016-03-22 21:27:40 EDT [9450-106] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-107] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('open_forms_id_seq', max(id)) FROM open_forms;
2016-03-22 21:27:40 EDT [9450-108] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-109] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('location_class_id_seq', max(id)) FROM location_class;
2016-03-22 21:27:40 EDT [9450-110] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-111] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('asset_report_id_seq', max(id)) FROM asset_report;
2016-03-22 21:27:40 EDT [9450-112] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-113] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('salutation_id_seq', max(id)) FROM salutation;
2016-03-22 21:27:40 EDT [9450-114] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-115] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('person_id_seq', max(id)) FROM person;
2016-03-22 21:27:40 EDT [9450-116] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-117] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('contact_class_id_seq', max(id)) FROM contact_class;
2016-03-22 21:27:40 EDT [9450-118] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-119] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('entity_credit_account_id_seq', max(id)) FROM entity_credit_account;
2016-03-22 21:27:40 EDT [9450-120] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-121] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('entity_bank_account_id_seq', max(id)) FROM entity_bank_account;
2016-03-22 21:27:40 EDT [9450-122] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-123] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('note_class_id_seq', max(id)) FROM note_class;
2016-03-22 21:27:40 EDT [9450-124] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-125] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('note_id_seq', max(id)) FROM note;
2016-03-22 21:27:40 EDT [9450-126] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-127] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('batch_class_id_seq', max(id)) FROM batch_class;
2016-03-22 21:27:40 EDT [9450-128] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-129] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('batch_id_seq', max(id)) FROM batch;
2016-03-22 21:27:40 EDT [9450-130] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-131] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('invoice_id_seq', max(id)) FROM invoice;
2016-03-22 21:27:40 EDT [9450-132] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-133] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('voucher_id_seq', max(id)) FROM voucher;
2016-03-22 21:27:40 EDT [9450-134] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-135] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('parts_id_seq', max(id)) FROM parts;
2016-03-22 21:27:40 EDT [9450-136] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-137] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('taxmodule_taxmodule_id_seq', max(taxmodule_id)) FROM taxmodule;
2016-03-22 21:27:40 EDT [9450-138] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-139] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('taxcategory_taxcategory_id_seq', max(taxcategory_id)) FROM taxcategory;
2016-03-22 21:27:40 EDT [9450-140] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-141] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('oe_id_seq', max(id)) FROM oe;
2016-03-22 21:27:40 EDT [9450-142] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-143] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('orderitems_id_seq', max(id)) FROM orderitems;
2016-03-22 21:27:40 EDT [9450-144] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-145] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('business_id_seq', max(id)) FROM business;
2016-03-22 21:27:40 EDT [9450-146] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-147] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('warehouse_id_seq', max(id)) FROM warehouse;
2016-03-22 21:27:40 EDT [9450-148] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-149] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('partsgroup_id_seq', max(id)) FROM partsgroup;
2016-03-22 21:27:40 EDT [9450-150] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-151] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('jcitems_id_seq', max(id)) FROM jcitems;
2016-03-22 21:27:40 EDT [9450-152] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-153] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('payment_type_id_seq', max(id)) FROM payment_type;
2016-03-22 21:27:40 EDT [9450-154] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-155] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('custom_table_catalog_table_id_seq', max(table_id)) FROM custom_table_catalog;
2016-03-22 21:27:40 EDT [9450-156] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-157] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('custom_field_catalog_field_id_seq', max(field_id)) FROM custom_field_catalog;
2016-03-22 21:27:40 EDT [9450-158] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-159] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('menu_node_id_seq', max(id)) FROM menu_node;
2016-03-22 21:27:40 EDT [9450-160] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-161] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('menu_attribute_id_seq', max(id)) FROM menu_attribute;
2016-03-22 21:27:40 EDT [9450-162] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-163] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('menu_acl_id_seq', max(id)) FROM menu_acl;
2016-03-22 21:27:40 EDT [9450-164] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-165] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('new_shipto_id_seq', max(id)) FROM new_shipto;
2016-03-22 21:27:40 EDT [9450-166] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-167] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('payment_id_seq', max(id)) FROM payment;
2016-03-22 21:27:40 EDT [9450-168] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-169] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('cr_report_id_seq', max(id)) FROM cr_report;
2016-03-22 21:27:40 EDT [9450-170] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-171] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('cr_report_line_id_seq', max(id)) FROM cr_report_line;
2016-03-22 21:27:40 EDT [9450-172] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-173] lsmb_dbadmin@lsmb_gayli STATEMENT:  SELECT setval('business_unit_id_seq', max(id)) FROM business_unit;
2016-03-22 21:27:40 EDT [9450-174] lsmb_dbadmin@lsmb_gayli ERROR:  current transaction is aborted, commands ignored until end of transaction block
2016-03-22 21:27:40 EDT [9450-175] lsmb_dbadmin@lsmb_gayli STATEMENT:  UPDATE defaults SET value = 'yes' where setting_key = 'migration_ok';

--Setup

-- When moved to an interface, these will all be specified and preprocessed.
\set default_country '''CA'''
\set ar '''1200'''
\set ap '''2100'''

BEGIN;

-- adding mapping info for import.

ALTER TABLE sl30.vendor ADD COLUMN entity_id int;
ALTER TABLE sl30.vendor ADD COLUMN company_id int;
ALTER TABLE sl30.vendor ADD COLUMN credit_id int;

ALTER TABLE sl30.customer ADD COLUMN entity_id int;
ALTER TABLE sl30.customer ADD COLUMN company_id int;
ALTER TABLE sl30.customer ADD COLUMN credit_id int;


--Accounts

insert into account_link_description values ('CT_tax', false, false);

INSERT INTO account_heading(id, accno, description)
SELECT id, accno, description
  FROM sl30.chart WHERE charttype = 'H';

SELECT account__save(id, accno, description, category,
                     case when gifi_accno ~ '[\s\t]*' then NULL
                          else gifi_accno end, NULL::int,
                    contra,
                    CASE WHEN link like '%tax%' THEN true ELSE false END,
                    string_to_array(link,':'), 'f', 'f')
  FROM sl30.chart
 WHERE charttype = 'A';

delete from account_link where description = 'CT_tax';

--Entity

INSERT INTO entity (name, control_code, entity_class, country_id)
SELECT name, 'V-' || vendornumber, 1, 
       (select id from country 
         where lower(short_name)  = lower(:default_country))
FROM sl30.vendor
GROUP BY name, vendornumber;

INSERT INTO entity (name, control_code, entity_class, country_id)
SELECT name, 'C-' || customernumber, 2, 
       (select id from country 
         where lower(short_name)  =  lower(:default_country))
FROM sl30.customer
GROUP BY name, customernumber;

UPDATE sl30.vendor SET entity_id = (SELECT id FROM entity WHERE 'V-' || vendornumber = control_code);

UPDATE sl30.customer SET entity_id = coalesce((SELECT min(id) FROM entity WHERE 'C-' || customernumber = control_code), entity_id);

--Entity Credit Account

INSERT INTO entity_credit_account
(entity_id, meta_number, business_id, creditlimit, ar_ap_account_id, 
	cash_account_id, startdate, enddate, threshold, entity_class)
SELECT entity_id, vendornumber, business_id, creditlimit,
       (select id
          from account
         where accno = coalesce((select accno from sl30.chart
                                  where id = arap_accno_id) ,:ap)),   
	(select id
	   from account
	   where accno = (select accno from sl30.chart
	                   where id = payment_accno_id)),
	 startdate, enddate, threshold, 1
FROM sl30.vendor WHERE entity_id IS NOT NULL;

UPDATE sl30.vendor SET credit_id = 
	(SELECT id FROM entity_credit_account e 
	WHERE e.meta_number = vendornumber and entity_class = 1
        and e.entity_id = vendor.entity_id);

INSERT INTO entity_credit_account
(entity_id, meta_number, business_id, creditlimit, ar_ap_account_id, 
	cash_account_id, startdate, enddate, threshold, entity_class)
SELECT entity_id, customernumber, business_id, creditlimit,
       (select id
          from account
         where accno = coalesce((select accno from sl30.chart
                                  where id = arap_accno_id) ,:ar)), 
	(select id
	   from account
	   where accno = (select accno from sl30.chart
	                   where id = payment_accno_id)),
        startdate, enddate, threshold, 2
FROM sl30.customer WHERE entity_id IS NOT NULL;

UPDATE sl30.customer SET credit_id = 
	(SELECT id FROM entity_credit_account e 
	WHERE e.meta_number = customernumber and entity_class = 2
        and e.entity_id = customer.entity_id);

--Company

INSERT INTO company (entity_id, legal_name, tax_id)
SELECT entity_id, name, max(taxnumber) FROM sl30.vendor 
WHERE entity_id IS NOT NULL AND entity_id IN (select id from entity) GROUP BY entity_id, name;

UPDATE sl30.vendor SET company_id = (select id from company c where entity_id = vendor.entity_id);

INSERT INTO company (entity_id, legal_name, tax_id)
SELECT entity_id, name, max(taxnumber) FROM sl30.customer
WHERE entity_id IS NOT NULL AND entity_id IN (select id from entity) GROUP BY entity_id, name;

UPDATE sl30.customer SET company_id = (select id from company c where entity_id = customer.entity_id);

-- Contact

insert into eca_to_contact (credit_id, contact_class_id, contact,description) 
select v.credit_id, 1, v.phone, 'Primary phone: '||max(v.contact) as description
from sl30.vendor v 
where v.company_id is not null and v.phone is not null 
       and v.phone ~ '[[:alnum:]_]'::text 
group by v.credit_id, v.phone
UNION
select v.credit_id, 12, v.email, 
       'email address: '||max(v.contact) as description 
from sl30.vendor v 
where v.company_id is not null and v.email is not null 
       and v.email ~ '[[:alnum:]_]'::text 
group by v.credit_id, v.email
UNION
select v.credit_id, 12, v.cc, 'Carbon Copy email address' as description 
from sl30.vendor v 
where v.company_id is not null and v.cc is not null 
      and v.cc ~ '[[:alnum:]_]'::text 
group by v.credit_id, v.cc
UNION 
select v.credit_id, 12, v.bcc, 'Blind Carbon Copy email address' as description 
from sl30.vendor v 
where v.company_id is not null and v.bcc is not null 
       and v.bcc ~ '[[:alnum:]_]'::text 
group by v.credit_id, v.bcc
UNION
    select v.credit_id, 9, v.fax, 'Fax number' as description 
from sl30.vendor v 
where v.company_id is not null and v.fax is not null 
      and v.fax ~ '[[:alnum:]_]'::text 
group by v.credit_id, v.fax;

insert into eca_to_contact (credit_id, contact_class_id, contact,description) 
select v.credit_id, 1, v.phone, 'Primary phone: '||max(v.contact) as description
from sl30.customer v 
where v.company_id is not null and v.phone is not null 
       and v.phone ~ '[[:alnum:]_]'::text 
group by v.credit_id, v.phone
UNION
select v.credit_id, 12, v.email, 
       'email address: '||max(v.contact) as description 
from sl30.customer v 
where v.company_id is not null and v.email is not null 
       and v.email ~ '[[:alnum:]_]'::text 
group by v.credit_id, v.email
UNION
select v.credit_id, 12, v.cc, 'Carbon Copy email address' as description 
from sl30.customer v 
where v.company_id is not null and v.cc is not null 
      and v.cc ~ '[[:alnum:]_]'::text 
group by v.credit_id, v.cc
UNION 
select v.credit_id, 12, v.bcc, 'Blind Carbon Copy email address' as description 
from sl30.customer v 
where v.company_id is not null and v.bcc is not null 
       and v.bcc ~ '[[:alnum:]_]'::text 
group by v.credit_id, v.bcc
UNION
    select v.credit_id, 9, v.fax, 'Fax number' as description 
from sl30.customer v 
where v.company_id is not null and v.fax is not null 
      and v.fax ~ '[[:alnum:]_]'::text 
group by v.credit_id, v.fax;


-- addresses

INSERT INTO public.country (id, name, short_name) VALUES (-1, 'Invalid Country', 'XX');

INSERT INTO eca_to_location(credit_id, location_class, location_id)
SELECT eca.id, 1,
    min(location_save(NULL,

    case 
        when oa.address1 !~ '[[:alnum:]_]' then 'Null'
        when oa.address1 is null then 'Null'
        else oa.address1 
    end,
    oa.address2, 
    NULL,
    case 
        when oa.city !~ '[[:alnum:]_]' then 'Invalid' 
        when oa.city is null then 'Null' 
        else oa.city 
    end,
    case 
        when oa.state !~ '[[:alnum:]_]' then 'Invalid' 
        when oa.state is null then 'Null' 
        else oa.state 
    end,
    case 
        when oa.zipcode !~ '[[:alnum:]_]' then 'Invalid' 
        when oa.zipcode is null then 'Null' 
        else oa.zipcode 
    end,
    coalesce(c.id, -1)
    ))
FROM country c
RIGHT OUTER JOIN
     sl30.address oa
ON
    lower(trim(both ' ' from c.name)) = lower( trim(both ' ' from oa.country))
OR

    lower(trim(both ' ' from c.short_name)) = lower( trim(both ' ' from oa.country))
JOIN (select credit_id, id from sl30.vendor
          union
           select credit_id, id from sl30.customer) v ON oa.trans_id = v.id
JOIN entity_credit_account eca ON (v.credit_id = eca.id)
GROUP BY eca.id;

-- Shipto

INSERT INTO eca_to_location(credit_id, location_class, location_id)
SELECT eca.id, 2,
    min(location_save(NULL,

    case 
        when oa.shiptoaddress1 !~ '[[:alnum:]_]' then 'Null'
        when oa.shiptoaddress1 is null then 'Null'
        else oa.shiptoaddress1 
    end,
    oa.shiptoaddress2, 
    NULL,
    case 
        when oa.shiptocity !~ '[[:alnum:]_]' then 'Invalid' 
        when oa.shiptocity is null then 'Null' 
        else oa.shiptocity 
    end,
    case 
        when oa.shiptostate !~ '[[:alnum:]_]' then 'Invalid' 
        when oa.shiptostate is null then 'Null' 
        else oa.shiptostate 
    end,
    case 
        when oa.shiptozipcode !~ '[[:alnum:]_]' then 'Invalid' 
        when oa.shiptozipcode is null then 'Null' 
        else oa.shiptozipcode 
    end,
    coalesce(c.id, -1)
    ))
FROM country c
RIGHT OUTER JOIN
     sl30.shipto oa
ON
    lower(trim(both ' ' from c.name)) = lower( trim(both ' ' from oa.shiptocountry))
OR

    lower(trim(both ' ' from c.short_name)) = lower( trim(both ' ' from oa.shiptocountry))
JOIN (select credit_id, id from sl30.vendor
          union
           select credit_id, id from sl30.customer) v ON oa.trans_id = v.id
JOIN entity_credit_account eca ON (v.credit_id = eca.id)
GROUP BY eca.id;

INSERT INTO eca_note(note_class, ref_key, note, vector)
SELECT 3, credit_id, notes, '' FROM sl30.vendor 
WHERE notes IS NOT NULL AND credit_id IS NOT NULL;

INSERT INTO eca_note(note_class, ref_key, note, vector)
SELECT 3, credit_id, notes, '' FROM sl30.customer
WHERE notes IS NOT NULL AND credit_id IS NOT NULL;

UPDATE entity SET country_id = 
(select country_id FROM location l 
   JOIN eca_to_location e2l ON l.id = e2l.location_id
        AND e2l.location_class = 1
   JOIN entity_credit_account eca ON e2l.credit_id = eca.id
  WHERE eca.entity_id = entity_id
        AND l.country_id > -1
  LIMIT 1)
WHERE id IN
(select eca.entity_id FROM location l 
   JOIN eca_to_location e2l ON l.id = e2l.location_id
        AND e2l.location_class = 1
   JOIN entity_credit_account eca ON e2l.credit_id = eca.id
  WHERE eca.entity_id = entity_id
       aND l.country_id > -1);

INSERT INTO pricegroup
SELECT * FROM sl30.pricegroup;

ALTER TABLE sl30.employee ADD entity_id int;

INSERT INTO entity(control_code, entity_class, name, country_id)
select 'E-' || employeenumber, 3, name,
        (select id from country where lower(short_name) = lower(:default_country))
FROM sl30.employee;

UPDATE sl30.employee set entity_id = 
       (select id from entity where 'E-'||employeenumber = control_code);

INSERT INTO person (first_name, last_name, entity_id) 
select name, name, entity_id FROM sl30.employee;

-- users in SL2.8 have to be re-created using the 1.4 user interface
-- Intentionally do *not* migrate the users table to prevent later conflicts
--INSERT INTO users (entity_id, username)
--     SELECT entity_id, login FROM sl30.employee em
--      WHERE login IS NOT NULL;

-- No manager information in SL30
--INSERT 
--  INTO entity_employee(entity_id, startdate, enddate, role, ssn, sales,
--       employeenumber, dob, manager_id)
--SELECT entity_id, startdate, enddate, r.description, ssn, sales,
--       employeenumber, dob,
--       (select entity_id from sl30.employee where id = em.managerid)
--  FROM sl30.employee em
--LEFT JOIN sl30.acsrole r on em.acsrole_id = r.id;

INSERT 
  INTO entity_employee(entity_id, startdate, enddate, role, ssn, sales,
       employeenumber, dob, manager_id)
SELECT entity_id, startdate, enddate, r.description, ssn, sales,
       employeenumber, dob, 0
  FROM sl30.employee em
LEFT JOIN sl30.acsrole r on em.acsrole_id = r.id;



-- must rebuild this table due to changes since 1.2

INSERT INTO partsgroup (id, partsgroup) SELECT id, partsgroup FROM sl30.partsgroup;

INSERT INTO parts (id, partnumber, description, unit,
listprice, sellprice, lastcost, priceupdate, weight, onhand, notes,
makemodel, assembly, alternate, rop, inventory_accno_id,
income_accno_id, expense_accno_id, bin, obsolete, bom, image,
drawing, microfiche, partsgroup_id, avgcost)
 SELECT id, partnumber, description, unit,
listprice, sellprice, lastcost, priceupdate, weight, onhand, notes,
makemodel, assembly, alternate, rop, (select id
          from public.account
         where accno = (select accno from sl30.chart
                         where id = inventory_accno_id)),
(select id
          from public.account
         where accno = (select accno from sl30.chart
                         where id = income_accno_id)), (select id
          from public.account
         where accno = (select accno from sl30.chart
                         where id = expense_accno_id)),
 bin, obsolete, bom, image,
drawing, microfiche, partsgroup_id, avgcost FROM sl30.parts;


INSERT INTO makemodel (parts_id, make, model) 
SELECT parts_id, make, model FROM sl30.makemodel;

INSERT INTO gifi
SELECT * FROM sl30.gifi;

/* TODO -- can't be solved this easily: a freshly created defaults
table contains 30 keys, one after having saved the System->Defaults
screen contains 58. Also, there are account IDs here, which should
be migrated using queries, not just copied over.

To watch out for: keys which are semantically the same, but have
different names

UPDATE defaults 
   SET value = (select fldvalue from sl30.defaults src 
                 WHERE src.fldname = defaults.setting_key)
 WHERE setting_key IN (select fldvalue FROM sl30.defaults
                        where );
*/

INSERT INTO assembly (id, parts_id, qty, bom, adj)
SELECT id, parts_id, qty, bom, adj  FROM sl30.assembly;

ALTER TABLE gl DISABLE TRIGGER gl_audit_trail;

INSERT INTO business_unit (id, class_id, control_code, description)
SELECT id, 1, id, description
  FROM sl30.department;

INSERT INTO business_unit (id, class_id, control_code, description,
       start_date, end_date, credit_id)
SELECT 1000+id, 2, projectnumber, description, startdate, enddate,
       (select credit_id
          from sl30.customer c
         where c.id = p.customer_id)
  FROM sl30.project p;


INSERT INTO gl(id, reference, description, transdate, person_id, notes)
    SELECT gl.id, reference, description, transdate, p.id, gl.notes
      FROM sl30.gl 
 LEFT JOIN sl30.employee em ON gl.employee_id = em.id
 LEFT JOIN person p ON em.entity_id = p.id;

ALTER TABLE gl ENABLE TRIGGER gl_audit_trail;

ALTER TABLE ar DISABLE TRIGGER ar_audit_trail;

insert into ar 
(entity_credit_account, person_id,
	id, invnumber, transdate, taxincluded, amount, netamount, paid, 
	datepaid, duedate, invoice, ordnumber, curr, notes, quonumber, intnotes,
	shipvia, language_code, ponumber, shippingpoint, 
	on_hold, approved, reverse, terms, description)
SELECT 
	customer.credit_id,
	(select entity_id from sl30.employee WHERE id = ar.employee_id),
	ar.id, invnumber, transdate, ar.taxincluded, amount, netamount, paid, 
	datepaid, duedate, invoice, ordnumber, ar.curr, ar.notes, quonumber, 
	intnotes,
	shipvia, ar.language_code, ponumber, shippingpoint, 
	onhold, approved, case when amount < 0 then true else false end,
	ar.terms, description
FROM sl30.ar JOIN sl30.customer ON (ar.customer_id = customer.id) ;

ALTER TABLE ar ENABLE TRIGGER ar_audit_trail;

ALTER TABLE ap DISABLE TRIGGER ap_audit_trail;

insert into ap 
(entity_credit_account, person_id,
	id, invnumber, transdate, taxincluded, amount, netamount, paid, 
	datepaid, duedate, invoice, ordnumber, curr, notes, quonumber, intnotes,
        shipvia, language_code, ponumber, shippingpoint, 
	on_hold, approved, reverse, terms, description)
SELECT 
	vendor.credit_id,
	(select entity_id from sl30.employee 
		WHERE id = ap.employee_id),
	ap.id, invnumber, transdate, ap.taxincluded, amount, netamount, paid, 
	datepaid, duedate, invoice, ordnumber, ap.curr, ap.notes, quonumber, 
	intnotes,
	shipvia, ap.language_code, ponumber, shippingpoint, 
	onhold, approved, case when amount < 0 then true else false end,
	ap.terms, description
FROM sl30.ap JOIN sl30.vendor ON (ap.vendor_id = vendor.id) ;

ALTER TABLE ap ENABLE TRIGGER ap_audit_trail;

-- ### TODO: there used to be projects here!
-- ### Move those to business_units
-- ### TODO: Reconciled disappeared from the source table...

ALTER TABLE sl30.acc_trans ADD COLUMN lsmb_entry_id integer;

update sl30.acc_trans
  set lsmb_entry_id = nextval('acc_trans_entry_id_seq');

INSERT INTO acc_trans
(entry_id, trans_id, chart_id, amount, transdate, source, cleared, fx_transaction, 
	memo, approved, cleared_on, voucher_id)
SELECT lsmb_entry_id, trans_id, (select id
                    from account
                   where accno = (select accno
                                    from sl30.chart
                                   where chart.id = acc_trans.chart_id)),
                                    amount, transdate, source,
	CASE WHEN cleared IS NOT NULL THEN TRUE ELSE FALSE END, fx_transaction,
	memo, approved, cleared, vr_id
	FROM sl30.acc_trans ;

INSERT INTO business_unit_ac (entry_id, class_id, bu_id)
SELECT ac.entry_id, 1, gl.department_id
  FROM acc_trans ac 
  JOIN (SELECT id, department_id FROM sl30.ar UNION ALL
        SELECT id, department_id FROM sl30.ap UNION ALL
        SELECT id, department_id FROM sl30.gl) gl ON gl.id = ac.trans_id 
 WHERE department_id > 0;

INSERT INTO business_unit_ac (entry_id, class_id, bu_id)
SELECT ac.entry_id, 2, slac.project_id+1000
  FROM acc_trans ac 
  JOIN sl30.acc_trans slac ON slac.entry_id = ac.entry_id 
 WHERE project_id > 0;


 INSERT INTO invoice (id, trans_id, parts_id, description, qty, allocated,
            sellprice, fxsellprice, discount, assemblyitem, unit,
            deliverydate, serialnumber)
    SELECT  id, trans_id, parts_id, description, qty, allocated,
            sellprice, fxsellprice, discount, assemblyitem, unit,
            deliverydate, serialnumber
       FROM sl30.invoice;

INSERT INTO business_unit_inv (entry_id, class_id, bu_id)
SELECT inv.id, 1, gl.department_id
  FROM invoice inv 
  JOIN (SELECT id, department_id FROM sl30.ar UNION ALL
        SELECT id, department_id FROM sl30.ap UNION ALL
        SELECT id, department_id FROM sl30.gl) gl ON gl.id = inv.trans_id
 WHERE department_id > 0;

INSERT INTO business_unit_inv (entry_id, class_id, bu_id)
SELECT id, 2, project_id + 1000 FROM sl30.invoice 
 WHERE project_id > 0 and  project_id in (select id from sl30.project);




INSERT INTO partstax (parts_id, chart_id)
     SELECT parts_id, a.id
       FROM sl30.partstax pt
       JOIN sl30.chart ON chart.id = pt.chart_id
       JOIN account a ON chart.accno = a.accno;

INSERT INTO tax(chart_id, rate, taxnumber, validto, pass, taxmodule_id)
     SELECT a.id, t.rate, t.taxnumber, 
            coalesce(t.validto::timestamp, 'infinity'), 1, 1
       FROM sl30.tax t
       JOIN sl30.chart c ON (t.chart_id = c.id)
       JOIN account a ON (a.accno = c.accno);

INSERT INTO eca_tax (eca_id, chart_id)
  SELECT c.credit_id, (select id from account
                      where accno = (select accno from sl30.chart sc
                                      where sc.id = ct.chart_id))
   FROM sl30.customertax ct
   JOIN sl30.customer c
     ON ct.customer_id = c.id
  UNION
  SELECT v.credit_id, (select id from account
                      where accno = (select accno from sl30.chart sc
                                      where sc.id = vt.chart_id))
   FROM sl30.vendortax vt
   JOIN sl30.vendor v
     ON vt.vendor_id = v.id;



INSERT 
  INTO oe(id, ordnumber, transdate, amount, netamount, reqdate, taxincluded,
       shippingpoint, notes, curr, person_id, closed, quotation, quonumber,
       intnotes, shipvia, language_code, ponumber, terms,
       entity_credit_account, oe_class_id)
SELECT oe.id,  ordnumber, transdate, amount, netamount, reqdate, oe.taxincluded,
       shippingpoint, oe.notes, oe.curr, p.id, closed, quotation, quonumber,
       intnotes, shipvia, oe.language_code, ponumber, oe.terms,
       coalesce(c.credit_id, v.credit_id),
       case 
           when c.id is not null and quotation is not true THEN 1
           WHEN v.id is not null and quotation is not true THEN 2
           when c.id is not null and quotation is true THEN 3
           WHEN v.id is not null and quotation is true THEN 4
       end
  FROM sl30.oe
  LEFT JOIN sl30.customer c ON c.id = oe.customer_id
  LEFT JOIN sl30.vendor v ON v.id = oe.vendor_id
  LEFT JOIN sl30.employee e ON oe.employee_id = e.id
  LEFT JOIN person p ON e.entity_id = p.id;

INSERT INTO orderitems(id, trans_id, parts_id, description, qty, sellprice,
            discount, unit, reqdate, ship, serialnumber)
     SELECT id, trans_id, parts_id, description, qty, sellprice,
            discount, unit, reqdate, ship, serialnumber
       FROM sl30.orderitems;

INSERT INTO business_unit_oitem (entry_id, class_id, bu_id)
SELECT oi.id, 1, oe.department_id 
  FROM orderitems oi
  JOIN sl30.oe ON oi.trans_id = oe.id AND department_id > 0;

INSERT INTO business_unit_oitem (entry_id, class_id, bu_id)
SELECT id, 2, project_id + 1000 FROM sl30.orderitems
 WHERE project_id > 0  and  project_id in (select id from sl30.project);


INSERT INTO exchangerate select * from sl30.exchangerate;


INSERT INTO status SELECT * FROM sl30.status; -- may need to comment this one out sometimes

INSERT INTO business SELECT * FROM sl30.business;

INSERT INTO sic SELECT * FROM sl30.sic;

INSERT INTO warehouse SELECT * FROM sl30.warehouse;

INSERT INTO inventory(entity_id, warehouse_id, parts_id, trans_id,
            orderitems_id, qty, shippingdate)
     SELECT e.entity_id, warehouse_id, parts_id, trans_id,
            orderitems_id, qty, shippingdate
       FROM sl30.inventory i
       JOIN sl30.employee e ON i.employee_id = e.id;

INSERT INTO yearend (trans_id, transdate) SELECT * FROM sl30.yearend;

INSERT INTO partsvendor(credit_id, parts_id, partnumber, leadtime, lastcost,
            curr)
     SELECT v.credit_id, parts_id, partnumber, leadtime, lastcost,
            pv.curr
       FROM sl30.partsvendor pv
       JOIN sl30.vendor v ON v.id = pv.vendor_id;

INSERT INTO partscustomer(parts_id, credit_id, pricegroup_id, pricebreak,
            sellprice, validfrom, validto, curr)
     SELECT parts_id, credit_id, pv.pricegroup_id, pricebreak,
            sellprice, validfrom, validto, pv.curr
       FROM sl30.partscustomer pv
       JOIN sl30.customer v ON v.id = pv.customer_id;

INSERT INTO language
SELECT * FROM sl30.language sllang
 WHERE NOT EXISTS (SELECT 1
                     FROM language l WHERE l.code = sllang.code);

INSERT INTO audittrail(trans_id, tablename, reference, formname, action,
            transdate, person_id)
     SELECT trans_id, tablename, reference, formname, action,
            transdate, p.entity_id
       FROM sl30.audittrail a
       JOIN sl30.employee e ON a.employee_id = e.id
       JOIN person p on e.entity_id = p.entity_id;

INSERT INTO user_preference(id)
     SELECT id from users;

INSERT INTO recurring(id, reference, startdate, nextdate, enddate,
            recurring_interval, howmany, payment)
     SELECT id, reference, startdate, nextdate, enddate, 
            (repeat || ' ' || unit)::interval,
            howmany, payment 
       FROM sl30.recurring;

INSERT INTO recurringemail SELECT * FROM sl30.recurringemail;

INSERT INTO recurringprint SELECT * FROM sl30.recurringprint;

INSERT INTO jcitems(id, parts_id, description, qty, allocated,
            sellprice, fxsellprice, serialnumber, checkedin, checkedout,
            person_id, notes, business_unit_id)
     SELECT j.id,  parts_id, description, qty, allocated,
            sellprice, fxsellprice, serialnumber, checkedin, checkedout,
            p.id, j.notes, j.project_id+1000
       FROM sl30.jcitems j
       JOIN sl30.employee e ON j.employee_id = e.id
       JOIN person p ON e.entity_id = p.entity_id;

INSERT INTO parts_translation SELECT * FROM sl30.translation where trans_id in (select id from parts);

INSERT INTO partsgroup_translation SELECT * FROM sl30.translation where trans_id in
 (select id from partsgroup);

--  ### TODO: To translate to business_units
-- INSERT INTO project_translation SELECT * FROM sl30.translation where trans_id in
--  (select id from project);

SELECT setval('id', max(id)) FROM transactions;

 SELECT setval('acc_trans_entry_id_seq', max(entry_id)) FROM acc_trans;
 SELECT setval('partsvendor_entry_id_seq', max(entry_id)) FROM partsvendor;
 SELECT setval('inventory_entry_id_seq', max(entry_id)) FROM inventory;
 SELECT setval('partscustomer_entry_id_seq', max(entry_id)) FROM partscustomer;
 SELECT setval('audittrail_entry_id_seq', max(entry_id)) FROM audittrail;
 SELECT setval('account_id_seq', max(id)) FROM account;
 SELECT setval('account_heading_id_seq', max(id)) FROM account_heading;
 SELECT setval('account_checkpoint_id_seq', max(id)) FROM account_checkpoint;
 SELECT setval('pricegroup_id_seq', max(id)) FROM pricegroup;
 SELECT setval('country_id_seq', max(id)) FROM country;
 SELECT setval('country_tax_form_id_seq', max(id)) FROM country_tax_form;
 SELECT setval('asset_dep_method_id_seq', max(id)) FROM asset_dep_method;
 SELECT setval('asset_class_id_seq', max(id)) FROM asset_class;
 SELECT setval('entity_class_id_seq', max(id)) FROM entity_class;
 SELECT setval('asset_item_id_seq', max(id)) FROM asset_item;
 SELECT setval('asset_disposal_method_id_seq', max(id)) FROM asset_disposal_method;
 SELECT setval('users_id_seq', max(id)) FROM users;
 SELECT setval('entity_id_seq', max(id)) FROM entity;
 SELECT setval('company_id_seq', max(id)) FROM company;
 SELECT setval('location_id_seq', max(id)) FROM location;
 SELECT setval('open_forms_id_seq', max(id)) FROM open_forms;
 SELECT setval('location_class_id_seq', max(id)) FROM location_class;
 SELECT setval('asset_report_id_seq', max(id)) FROM asset_report;
 SELECT setval('salutation_id_seq', max(id)) FROM salutation;
 SELECT setval('person_id_seq', max(id)) FROM person;
 SELECT setval('contact_class_id_seq', max(id)) FROM contact_class;
 SELECT setval('entity_credit_account_id_seq', max(id)) FROM entity_credit_account;
 SELECT setval('entity_bank_account_id_seq', max(id)) FROM entity_bank_account;
 SELECT setval('note_class_id_seq', max(id)) FROM note_class;
 SELECT setval('note_id_seq', max(id)) FROM note;
 SELECT setval('batch_class_id_seq', max(id)) FROM batch_class;
 SELECT setval('batch_id_seq', max(id)) FROM batch;
 SELECT setval('invoice_id_seq', max(id)) FROM invoice;
 SELECT setval('voucher_id_seq', max(id)) FROM voucher;
 SELECT setval('parts_id_seq', max(id)) FROM parts;
 SELECT setval('taxmodule_taxmodule_id_seq', max(taxmodule_id)) FROM taxmodule;
 SELECT setval('taxcategory_taxcategory_id_seq', max(taxcategory_id)) FROM taxcategory;
 SELECT setval('oe_id_seq', max(id)) FROM oe;
 SELECT setval('orderitems_id_seq', max(id)) FROM orderitems;
 SELECT setval('business_id_seq', max(id)) FROM business;
 SELECT setval('warehouse_id_seq', max(id)) FROM warehouse;
 SELECT setval('partsgroup_id_seq', max(id)) FROM partsgroup;
 SELECT setval('jcitems_id_seq', max(id)) FROM jcitems;
 SELECT setval('payment_type_id_seq', max(id)) FROM payment_type;
 SELECT setval('custom_table_catalog_table_id_seq', max(table_id)) FROM custom_table_catalog;
 SELECT setval('custom_field_catalog_field_id_seq', max(field_id)) FROM custom_field_catalog;
 SELECT setval('menu_node_id_seq', max(id)) FROM menu_node;
 SELECT setval('menu_attribute_id_seq', max(id)) FROM menu_attribute;
 SELECT setval('menu_acl_id_seq', max(id)) FROM menu_acl;
-- SELECT setval('pending_job_id_seq', max(id)) FROM pending_job;
 SELECT setval('new_shipto_id_seq', max(id)) FROM new_shipto;
 SELECT setval('payment_id_seq', max(id)) FROM payment;
 SELECT setval('cr_report_id_seq', max(id)) FROM cr_report;
 SELECT setval('cr_report_line_id_seq', max(id)) FROM cr_report_line;
 SELECT setval('business_unit_id_seq', max(id)) FROM business_unit;

UPDATE defaults SET value = 'yes' where setting_key = 'migration_ok';

COMMIT;
--TODO:  Translation migratiion.  Partsgroups?
-- TODO:  User/password Migration

------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140

_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel