Send Netdot-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Netdot-users digest..."
Today's Topics:
1. Backbone cable adding strands broken (status cannot be null)
(Boyer, Eric)
----------------------------------------------------------------------
Message: 1
Date: Mon, 22 Sep 2014 20:28:32 +0000
From: "Boyer, Eric" <[email protected]>
Subject: [Netdot-users] Backbone cable adding strands broken (status
cannot be null)
To: Netdot-users <[email protected]>
Cc: Carlos Vicente <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset="windows-1252"
Hello,
I?m using Netdot 1.0.6 and am seeing strange errors when trying to add a
backbone cable in the way that I?d expect to do it. I fill out the form for the
/netdot/cable_plant/cable_backbone.html page (filling out all fields
available). I tell it to allocate 12 strands to this backbone cable. When I hit
submit I get the following error:
"Error while inserting CableStrand: Can't insert new CableStrand:
DBD::mysql::st execute failed: Column 'status' cannot be null [for Statement
"INSERT INTO cablestrand (number, status, cable, name, fiber_type) VALUES (?,
?, ?, ?, ?) " with ParamValues: 0=1, 1=undef, 2='6', 3='NCSAOM3-01.1', 4=undef]
at /usr/share/perl5/DBIx/ContextualFetch.pm line 52.?
However, despite the error, two backbone cables get created with the same exact
names, attributes, etc (I?m not sure why two get created either). So then, I
tried adding the strands using the ?Manually Add Strands? portion of the page
and get the following very similar error:
"Error while inserting CableStrand: Can't insert new CableStrand:
DBD::mysql::st execute failed: Column 'status' cannot be null [for Statement
"INSERT INTO cablestrand (number, status, cable, name, fiber_type)
VALUES (?, ?, ?, ?, ?) with ParamValues: 0=1, 1=undef, 2='6', 3='NCSAOM3-01.1',
4='1'] at /usr/share/perl5/DBIx/ContextualFetch.pm line 52.?
At this point I?m led to believe that I should be able to define the status
somewhere, and by looking in the database schema and doing some poking around I
found a way to add a status but it still didn?t help because I couldn?t add
that status to any new cables
Finally, If I click on the [new] button for ?Cable Strands (0)? I get the below
error. Do you have any ideas what could be causing this?
"You need to pass a valid object or a table name Trace begun at
/usr/local/netdot/lib/Netdot.pm line 105
Netdot::throw_fatal('Netdot::UI=HASH(0x7fd75d0f2930)', 'You need to pass a
valid object or a table name') called at /usr/local/netdot/lib/Netdot/UI.pm
line 330 Netdot::UI::form_field('Netdot::UI=HASH(0x7fd75d0f2930)', 'object',
undef, 'column', 'circuit_id', 'lookup', 'Circuit', 'edit', 1, 'returnValOnly',
1, 'linkPage', 'circuit.html') called at
/usr/local/netdot/htdocs/cable_plant/cable_strand.html line 217
HTML::Mason::Commands::__ANON__('backbone_id', 6, 'id', 'NEW', 'showheader', 1)
called at /usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fd724322208)',
'backbone_id', 6, 'id', 'NEW', 'showheader', 1) called at
/usr/share/perl5/HTML/Mason/Request.pm line 1302 eval {...} at
/usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'backbone_id', 6, 'id', 'NE!
W', 'showheader', 1) called at /usr/share/perl5/HTML/Mason/Request.pm line 955
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x7fd724351d48)')
called at /usr/local/netdot/htdocs/cable_plant/autohandler line 353
HTML::Mason::Commands::__ANON__('backbone_id', 6, 'id', 'NEW', 'showheader', 1)
called at /usr/share/perl5/HTML/Mason/Component.pm line 157
HTML::Mason::Component::run_dynamic_sub('HTML::Mason::Component::FileBased=HASH(0x7fd75f38d480)',
'main', 'backbone_id', 6, 'id', 'NEW', 'showheader', 1) called at
/usr/share/perl5/HTML/Mason/Request.pm line 948
HTML::Mason::Request::call_dynamic('HTML::Mason::Request::ApacheHandler=HASH(0x7fd724351d48)',
'main', 'backbone_id', 6, 'id', 'NEW', 'showheader', 1) called at
/usr/local/netdot/htdocs/masondata/obj/1249759374/cable_plant/autohandler.obj
line 21 HTML::Mason::Commands::__ANON__('backbone_id', 6, 'id', 'NEW',
'showheader', 1) called at /usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Maso!
n::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fd75f38d4
80)', 'backbone_id', 6, 'id', 'NEW', 'showheader', 1) called at
/usr/share/perl5/HTML/Mason/Request.pm line 1302 eval {...} at
/usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'backbone_id', 6, 'id', 'NEW',
'showheader', 1) called at /usr/share/perl5/HTML/Mason/Request.pm line 955
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x7fd724351d48)',
'showheader', 1) called at /usr/local/netdot/htdocs/autohandler line 76
HTML::Mason::Commands::__ANON__('backbone_id', 6, 'id', 'NEW') called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fd72400c898)',
'backbone_id', 6, 'id', 'NEW') called at
/usr/share/perl5/HTML/Mason/Request.pm line 1297 eval {...} at
/usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'backbone_id', 6, 'id', 'NEW')
called at /usr/share/perl5/HTML/Mason/Request.pm line !
481 eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 481 eval {...}
at /usr/share/perl5/HTML/Mason/Request.pm line 433
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7fd724351d48)')
called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 165
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7fd724351d48)')
called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 831
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7fd75d25b9e0)',
'Apache2::RequestRec=SCALAR(0x7fd7242f4240)') called at
/usr/local/netdot/lib/Netdot/Mason.pm line 59
Netdot::Mason::handler('Apache2::RequestRec=SCALAR(0x7fd7242f4240)') called at
-e line 0 eval {...} at -e line 0?
Thanks,
-------------
Eric Boyer
Network Engineer
National Center for Supercomputing Applications
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20140922/270a9d38/attachment-0001.html
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 70, Issue 3
*******************************************
