Skip to content

Failing to create test company in db #398

@Sulejman

Description

@Sulejman

After making all services (with cosmos) I try to run scripts to add test data:

make create-test-company
Creating test company...
ERROR:  relation "admin_service.companies" does not exist
LINE 1: INSERT INTO "admin_service"."companies" (id, name) VALUES ('...
                    ^
make: *** [create-test-company] Error 1

This is my output from another terminal running services:

yarn run v1.22.5
$ /Users/sule/Documents/GitHub/permissioning-engine/node_modules/.bin/lerna run dev --parallel --scope=@datawallet/signing-service --scope=@datawallet/permission-settings-service --scope=@datawallet/data-upload-service --scope=@datawallet/admin-service --scope=@datawallet/request-service --scope=@datawallet/stripe-service
lerna notice cli v3.20.2
lerna notice filter including ["@datawallet/signing-service","@datawallet/permission-settings-service","@datawallet/data-upload-service","@datawallet/admin-service","@datawallet/request-service","@datawallet/stripe-service"]
lerna info filter [
lerna info filter   '@datawallet/signing-service',
lerna info filter   '@datawallet/permission-settings-service',
lerna info filter   '@datawallet/data-upload-service',
lerna info filter   '@datawallet/admin-service',
lerna info filter   '@datawallet/request-service',
lerna info filter   '@datawallet/stripe-service'
lerna info filter ]
lerna info Executing command in 6 packages: "yarn run dev"
@datawallet/admin-service: $ DEBUG=admin-service:* nodemon --quiet --watch lib -r esm lib/index.js
@datawallet/data-upload-service: $ DEBUG=data-upload-service:* nodemon --quiet --watch lib -r esm lib/index.js
@datawallet/request-service: $ DEBUG=request-service:* nodemon --quiet --watch lib -r esm lib/index.js
@datawallet/signing-service: $ DEBUG=signing-service:* nodemon --quiet --watch lib -r esm lib/index.js
@datawallet/stripe-service: $ DEBUG=stripe-service:* nodemon --quiet --watch lib -r esm lib/index.js
@datawallet/permission-settings-service: $ DEBUG='permission-settings-service:*,services:database:*' nodemon --quiet --watch lib -r esm lib/index.js
@datawallet/admin-service: /Users/sule/Documents/GitHub/permissioning-engine/packages/admin-service/lib/config.js:1
@datawallet/admin-service: TypeError [ERR_INVALID_ARG_TYPE]: The "path" argument must be of type string. Received undefined
@datawallet/admin-service:     at validateString (internal/validators.js:120:11)
@datawallet/admin-service:     at join (path.js:1039:7)
@datawallet/admin-service:     at Object.<anonymous> (/Users/sule/Documents/GitHub/permissioning-engine/packages/admin-service/lib/config.js:25:7)
@datawallet/admin-service:     at Generator.next (<anonymous>)
@datawallet/admin-service:     at Object.<anonymous> (/Users/sule/Documents/GitHub/permissioning-engine/packages/admin-service/lib/index.js:1)
@datawallet/admin-service:     at Generator.next (<anonymous>) {
@datawallet/admin-service:   code: 'ERR_INVALID_ARG_TYPE'
@datawallet/admin-service: }
@datawallet/stripe-service: /Users/sule/Documents/GitHub/permissioning-engine/node_modules/plaid/lib/PlaidClient.js:1
@datawallet/stripe-service: Error: Missing Plaid "client_id"
@datawallet/stripe-service:     at new Client (/Users/sule/Documents/GitHub/permissioning-engine/node_modules/plaid/lib/PlaidClient.js:16:11)
@datawallet/stripe-service:     at Object.<anonymous> (/Users/sule/Documents/GitHub/permissioning-engine/packages/stripe-service/lib/config.js:29:22)
@datawallet/stripe-service:     at Generator.next (<anonymous>)
@datawallet/stripe-service:     at Object.<anonymous> (/Users/sule/Documents/GitHub/permissioning-engine/packages/stripe-service/lib/index.js:1)
@datawallet/stripe-service:     at Generator.next (<anonymous>)
@datawallet/data-upload-service: 2020-09-16T12:34:03.555Z data-upload-service:service-base Applying 001_create_requests_table.sql... OK
@datawallet/data-upload-service: 2020-09-16T12:34:03.567Z data-upload-service:service-base Applying 002_add_pubkey.sql... OK
@datawallet/data-upload-service: 2020-09-16T12:34:03.567Z data-upload-service:service-base Storing last migrated file in database...
@datawallet/request-service: [2020-09-16 12:34:03] DEBUG Creating transport: nodemailer (6.4.2; +https://nodemailer.com/; SMTP/6.4.2[client:6.4.2])
@datawallet/data-upload-service: 2020-09-16T12:34:03.635Z data-upload-service:service-base 2 migrations were applied
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/signing-service: 2020-09-16T12:34:05.105Z signing-service:service-base Applying 001_create_cluster_table.sql... OK
@datawallet/signing-service: 2020-09-16T12:34:05.141Z signing-service:service-base Applying 002_create_wallets_table.sql... OK
@datawallet/signing-service: 2020-09-16T12:34:05.149Z signing-service:service-base Applying 003_remove_unique_cluster_url.sql... OK
@datawallet/signing-service: 2020-09-16T12:34:05.149Z signing-service:service-base Storing last migrated file in database...
@datawallet/signing-service: 2020-09-16T12:34:05.158Z signing-service:service-base 3 migrations were applied
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/request-service: /Users/sule/Documents/GitHub/permissioning-engine/node_modules/twilio/lib/rest/Twilio.js:1
@datawallet/request-service: Error: username is required
@datawallet/request-service:     at new Twilio (/Users/sule/Documents/GitHub/permissioning-engine/node_modules/twilio/lib/rest/Twilio.js:147:11)
@datawallet/request-service:     at initializer (/Users/sule/Documents/GitHub/permissioning-engine/node_modules/twilio/lib/index.js:9:10)
@datawallet/request-service:     at Object.<anonymous> (/Users/sule/Documents/GitHub/permissioning-engine/packages/request-service/lib/helpers/phone.js:4:16)
@datawallet/request-service:     at Generator.next (<anonymous>)
@datawallet/request-service:     at Object.<anonymous> (/Users/sule/Documents/GitHub/permissioning-engine/packages/request-service/lib/services/verify.js:1)
@datawallet/request-service:     at Generator.next (<anonymous>)
@datawallet/permission-settings-service: 2020-09-16T12:34:05.195Z permission-settings-service:service-base Applying 001_create_requests_table.sql... OK
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: 2020-09-16T12:34:05.217Z permission-settings-service:service-base Applying 002_create_activity_table.sql... OK
@datawallet/permission-settings-service: 2020-09-16T12:34:05.220Z permission-settings-service:service-base Applying 003_add_error_column_to_requests_table.sql... OK
@datawallet/permission-settings-service: 2020-09-16T12:34:05.239Z permission-settings-service:service-base Applying 004_timestamp_with_time_zone.sql... OK
@datawallet/permission-settings-service: 2020-09-16T12:34:05.245Z permission-settings-service:service-base Applying 005_create_categories_table_fix.sql... OK
@datawallet/permission-settings-service: 2020-09-16T12:34:05.249Z permission-settings-service:service-base Applying 006_drop_categories_table.sql... OK
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: 2020-09-16T12:34:05.332Z permission-settings-service:service-base Applying 007_create_versioned_schema.sql... OK
@datawallet/permission-settings-service: 2020-09-16T12:34:05.337Z permission-settings-service:service-base Applying 008_add_data_point_groups_requests_relation.sql... OK
@datawallet/permission-settings-service: 2020-09-16T12:34:05.347Z permission-settings-service:service-base Applying 009_add_internal_use_case_id_to_choices.sql... OK
@datawallet/permission-settings-service: 2020-09-16T12:34:05.362Z permission-settings-service:service-base Applying 010_add_blochain_columns_to_choices.sql... OK
@datawallet/permission-settings-service: 2020-09-16T12:34:05.375Z permission-settings-service:service-base Applying 011_add_tx_data_to_request.sql... OK
@datawallet/permission-settings-service: 2020-09-16T12:34:05.380Z permission-settings-service:service-base Applying 012_add_ccpa_pit_tag_and_external_id_to_dpgs.sql... OK
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: 2020-09-16T12:34:05.423Z permission-settings-service:service-base Applying 013_timestamp_with_timezone.sql... OK
@datawallet/permission-settings-service: 2020-09-16T12:34:05.427Z permission-settings-service:service-base Applying 014_add_required_message_to_dpg.sql... OK
@datawallet/permission-settings-service: 2020-09-16T12:34:05.442Z permission-settings-service:service-base Applying 015_add_buyers_and_shares_columns_to_dpg.sql... OK
@datawallet/permission-settings-service: 2020-09-16T12:34:05.446Z permission-settings-service:service-base Applying 016_user_private_key.sql... OK
@datawallet/permission-settings-service: 2020-09-16T12:34:05.472Z permission-settings-service:service-base Applying 017_add_choosable_types.sql... OK
@datawallet/permission-settings-service: 2020-09-16T12:34:05.484Z permission-settings-service:service-base Applying 018_create_business_categories.sql... OK
@datawallet/permission-settings-service: 2020-09-16T12:34:05.487Z permission-settings-service:service-base Applying 019_remove_buyers_and_shares.sql... OK
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/permission-settings-service: 2020-09-16T12:34:05.499Z permission-settings-service:service-base Applying 020_add_business_categories_public_id_and_version_id_indices.sql... OK
@datawallet/permission-settings-service: 2020-09-16T12:34:05.518Z permission-settings-service:service-base Applying 021_add_is_default_to_choices_table.sql... OK
@datawallet/permission-settings-service: 2020-09-16T12:34:05.520Z permission-settings-service:service-base Applying 022_remove_null_desc_constraint.sql... OK
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: 2020-09-16T12:34:05.532Z permission-settings-service:service-base Applying 023_add_data_to_request.sql... OK
@datawallet/permission-settings-service: 2020-09-16T12:34:05.533Z permission-settings-service:service-base Storing last migrated file in database...
@datawallet/permission-settings-service: 2020-09-16T12:34:05.542Z permission-settings-service:service-base 23 migrations were applied
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: [connection-1] disconnected 
@datawallet/permission-settings-service: [connection-1] disconnected 
@datawallet/signing-service: [connection-1] disconnected 
@datawallet/data-upload-service: 2020-09-16T12:34:08.557Z data-upload-service:service-base Running on port 5002
@datawallet/permission-settings-service: 2020-09-16T12:34:08.727Z permission-settings-service:service-base Running on port 5000
@datawallet/signing-service: 2020-09-16T12:34:08.752Z signing-service:service-base Running on port 5005

And these are the tables which get created in DB instance:

Screenshot 2020-09-16 at 14 34 59

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions