[ https://issues.apache.org/jira/browse/TC-248?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15984959#comment-15984959 ]
ASF GitHub Bot commented on TC-248: ----------------------------------- Github user asfgit closed the pull request at: https://github.com/apache/incubator-trafficcontrol/pull/519 > Importing and exporting profiles 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 > Assignee: Robert Scrimo > Attachments: CCR-NABOX9.traffic_ops > > > Centos 7.2; Profile is attached. Issue was confirmed in latest staging build > 2.1.0-6034.865c0efd.el7 and in my recently upgraded environment. > 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)