You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafficcontrol.apache.org by "Robert Scrimo (JIRA)" <ji...@apache.org> on 2017/04/24 21:09:04 UTC

[jira] [Updated] (TC-248) Importing and Exporting does not work as expected

     [ https://issues.apache.org/jira/browse/TC-248?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Robert Scrimo updated TC-248:
-----------------------------
     Attachment: CCR-NABOX9.traffic_ops
    Description: 
Centos 7.2; Profile is attached.

Exporting profiles from Traffic Ops 2.1.0-6027.a62b5f9f.el7 does not include the required profile field "type".

Importing profiles with or without the profile "type" field produces the following error in Traffic Ops GUI:
Traffic Ops fatal error occurred while processing your request. 
Error at line 312 (    my $insert = $self->db->resultset('Profile')->create() 
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: null value in column "type" violates not-null constraint DETAIL: Failing row contains (34, CCR1-NABOX9, Traffic Router Profile for NABOX9, 2017-04-24 20:52:01.999393+00, null, null). [for Statement "INSERT INTO profile ( description, name) VALUES ( ?, ? ) RETURNING id" with ParamValues: 1='Traffic Router Profile for NABOX9', 2='CCR1-NABOX9'] at /opt/traffic_ops/app/lib/UI/Profile.pm line 312

  was:
Centos 7.2

Exporting profiles from Traffic Ops 2.1.0-6027.a62b5f9f.el7 does not include the required profile field "type".

Importing profiles with or without the profile "type" field produces the following error in Traffic Ops GUI:
Traffic Ops fatal error occurred while processing your request. 
Error at line 312 (    my $insert = $self->db->resultset('Profile')->create() 
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: null value in column "type" violates not-null constraint DETAIL: Failing row contains (34, CCR1-NABOX9, Traffic Router Profile for NABOX9, 2017-04-24 20:52:01.999393+00, null, null). [for Statement "INSERT INTO profile ( description, name) VALUES ( ?, ? ) RETURNING id" with ParamValues: 1='Traffic Router Profile for NABOX9', 2='CCR1-NABOX9'] at /opt/traffic_ops/app/lib/UI/Profile.pm line 312


> Importing and Exporting does not work as expected
> -------------------------------------------------
>
>                 Key: TC-248
>                 URL: https://issues.apache.org/jira/browse/TC-248
>             Project: Traffic Control
>          Issue Type: Bug
>          Components: Traffic Ops
>    Affects Versions: 2.1.0
>            Reporter: Robert Scrimo
>         Attachments: CCR-NABOX9.traffic_ops
>
>
> Centos 7.2; Profile is attached.
> Exporting profiles from Traffic Ops 2.1.0-6027.a62b5f9f.el7 does not include the required profile field "type".
> Importing profiles with or without the profile "type" field produces the following error in Traffic Ops GUI:
> Traffic Ops fatal error occurred while processing your request. 
> Error at line 312 (    my $insert = $self->db->resultset('Profile')->create() 
> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: null value in column "type" violates not-null constraint DETAIL: Failing row contains (34, CCR1-NABOX9, Traffic Router Profile for NABOX9, 2017-04-24 20:52:01.999393+00, null, null). [for Statement "INSERT INTO profile ( description, name) VALUES ( ?, ? ) RETURNING id" with ParamValues: 1='Traffic Router Profile for NABOX9', 2='CCR1-NABOX9'] at /opt/traffic_ops/app/lib/UI/Profile.pm line 312



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)