starred/netbox
1
0
Fork 0
mirror of https://github.com/netbox-community/netbox.git synced 2026-01-11 21:10:29 +01:00
Code Issues 273 Packages Projects Releases 10 Wiki Activity

Child Device Import fail #757

New Issue
Closed
opened 2025-12-29 16:25:32 +01:00 by adam · 1 comment
adam commented 2025-12-29 16:25:32 +01:00
Owner
Copy Link

Originally created by @elmmare on GitHub (Mar 8, 2017).

Issue type: bug report

**Python version:2.7.5
**NetBox version:1.9.1 and 1.9.0r1

Importing a child device list I obtain:

  • Record 1: null value in column "site_id" violates not-null constraint...

but "side id" is not a required field for child devices, it should be gathered from the parent device.
I'm quite sure that the feature was working in 1.8.4

Originally created by @elmmare on GitHub (Mar 8, 2017). <!-- Please note: GitHub issues are to be used only for feature requests and bug reports. For installation assistance or general discussion, please join us on the mailing list: https://groups.google.com/forum/#!forum/netbox-discuss Please indicate "bug report" or "feature request" below. Be sure to search the existing set of issues (both open and closed) to see if a similar issue has already been raised. --> ### Issue type: bug report <!-- If filing a bug, please indicate the version of Python and NetBox you are running. (This is not necessary for feature requests.) --> **Python version:2.7.5 **NetBox version:1.9.1 and 1.9.0r1 <!-- If filing a bug, please record the exact steps taken to reproduce the bug and any errors messages that are generated. If filing a feature request, please precisely describe the data model or workflow you would like to see implemented, and provide a use case. --> Importing a child device list I obtain: * *Record 1: null value in column "site_id" violates not-null constraint...* but "side id" is not a required field for child devices, it should be gathered from the parent device. I'm quite sure that the feature was working in 1.8.4
adam closed this issue 2025-12-29 16:25:32 +01:00
adam commented 2025-12-29 16:25:33 +01:00
Author
Owner
Copy Link

@pstanczak-vidscale commented on GitHub (Mar 8, 2017):

Same issue here
**NetBox version:1.9.1

When trying to import child object

,Patch Panel,,Panduit,FAP - SMF LC 6 port,,,,FT-103-01,FAP1
`

Record 1: null value in column "site_id" violates not-null constraint DETAIL: Failing row contains (384, 2017-03-08, 2017-03-08 20:54:57.716456+00, null, , null, null, t, , 14, 42, null, 22, null, null, null, null, null).

Trying to connect new child object to a parent object ID: 377 in dcim_device table.

 id  |  created   |         last_updated          |   name    | serial | position | face | status | comments | device_role_id | device_type_id | platform_id | rack_id | primary_ip4_id | primary_ip6_id | tenant_id | asset_tag | site_id
-----+------------+-------------------------------+-----------+--------+----------+------+--------+----------+----------------+----------------+-------------+---------+----------------+----------------+-----------+-----------+---------
 377 | 2017-03-08 | 2017-03-08 20:14:57.961739+00 | FT-103-01 |        |       45 |    1 | t      |          |             14 |             27 |             |      22 |                |                |           |           |       2
@pstanczak-vidscale commented on GitHub (Mar 8, 2017): Same issue here **NetBox version:1.9.1 When trying to import child object ` ,Patch Panel,,Panduit,FAP - SMF LC 6 port,,,,FT-103-01,FAP1` ` ` Record 1: null value in column "site_id" violates not-null constraint DETAIL: Failing row contains (384, 2017-03-08, 2017-03-08 20:54:57.716456+00, null, , null, null, t, , 14, 42, null, 22, null, null, null, null, null). ` Trying to connect new child object to a parent object ID: 377 in dcim_device table. ``` id | created | last_updated | name | serial | position | face | status | comments | device_role_id | device_type_id | platform_id | rack_id | primary_ip4_id | primary_ip6_id | tenant_id | asset_tag | site_id -----+------------+-------------------------------+-----------+--------+----------+------+--------+----------+----------------+----------------+-------------+---------+----------------+----------------+-----------+-----------+--------- 377 | 2017-03-08 | 2017-03-08 20:14:57.961739+00 | FT-103-01 | | 45 | 1 | t | | 14 | 27 | | 22 | | | | | 2 ```
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
beta
breaking change
complexity: high
complexity: low
complexity: medium
needs milestone
netbox
pending closure
plugin candidate
pull-request
Mirrored from GitHub Pull Request
 severity: high
severity: low
severity: medium
status: accepted
status: backlog
status: blocked
status: duplicate
status: needs owner
status: needs triage
status: revisions needed
status: under review
topic: GraphQL
topic: Internationalization
topic: OpenAPI
topic: UI/UX
topic: cabling
topic: event rules
topic: htmx navigation
topic: industrialization
topic: migrations
topic: plugins
topic: scripts
topic: templating
topic: testing
type: bug
type: deprecation
type: documentation
type: feature
type: housekeeping
type: translation
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
adam
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#757
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?