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. Asset Search Error (Joe Goldberg)
----------------------------------------------------------------------
Message: 1
Date: Thu, 8 Nov 2012 20:22:25 +0000
From: Joe Goldberg <[email protected]>
Subject: [Netdot-users] Asset Search Error
To: netdot-users <[email protected]>
Message-ID:
<b7b8607f08808346a11c7edfe20839d711d0e...@sn2prd0510mb382.namprd05.prod.outlook.com>
Content-Type: text/plain; charset="iso-8859-1"
I just installed version 1.0.2 (fresh install) and imported some devices.
Everything seems to be working perfectly except one thing. I am using a
Postgres DB
I can't an Asset Search (Management --> Assets --> Search. I get the error
below:
Any insight you may have, I would appreciate.
Asset can't SELECT id, serial_number, product_id, inventory_number, physaddr,
reserved_for, maint_from, maint_until
FROM asset
WHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR reserved_for LIKE
? OR description LIKE ? OR info LIKE ? OR po_number LIKE ? OR maint_contract
LIKE ? ) )
: DBD::Pg::st execute failed: ERROR: operator does not exist: bigint ~~ unknown
LINE 3: ...fo LIKE $5 OR po_number LIKE $6 OR maint_contract LIKE $7 ) ...
^
HINT: No operator matches the given name and argument type(s). You might need
to add explicit type casts. [for Statement "SELECT id, serial_number,
product_id, inventory_number, physaddr, reserved_for, maint_from, maint_until
FROM asset
WHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR reserved_for LIKE
? OR description LIKE ? OR info LIKE ? OR po_number LIKE ? OR maint_contract
LIKE ? ) )
" with ParamValues: 1='%falc%', 2='%falc%', 3='%falc%', 4='%falc%', 5='%falc%',
6='%falc%', 7='%falc%'] at /usr/share/perl5/DBIx/ContextualFetch.pm line 52.
Stack:
[/usr/share/perl5/DBIx/ContextualFetch.pm:52]
[/usr/share/perl5/DBIx/ContextualFetch.pm:32]
[/usr/share/perl5/Class/DBI.pm:1139]
[/usr/share/perl5/Class/DBI.pm:1083]
[/usr/share/perl5/Class/DBI/AbstractSearch.pm:33]
[/usr/local/netdot/htdocs/management/asset_tasks.html:243]
[/usr/local/netdot/htdocs/management/autohandler:81]
[/usr/share/perl5/HTML/Mason/Request.pm:936]
[/usr/local/netdot/htdocs/masondata/obj/991023240/management/autohandler.obj:21]
[/usr/local/netdot/htdocs/autohandler:76]
at /usr/share/perl5/Class/DBI/AbstractSearch.pm line 33
Trace begun at /usr/share/perl5/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception('Asset can\'t SELECT id,
serial_number, product_id, inventory_number, physaddr, reserved_for,
maint_from, maint_until^JFROM asset^JWHERE ( ( custom_serial LIKE ? OR
inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ? OR info
LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )^J: DBD::Pg::st execute
failed: ERROR: operator does not exist: bigint ~~ unknown^JLINE 3: ...fo LIKE
$5 OR po_number LIKE $6 OR maint_contract LIKE $7 ) ...^J
^^JHINT: No operator matches the given
name and argument type(s). You might need to add explicit type casts. [for
Statement "SELECT id, serial_number, product_id, inventory_number, physaddr,
reserved_for, maint_from, maint_until^JFROM asset^JWHERE ( ( custom_serial
LIKE ? OR inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ?
OR info LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )^J" with Para!
mValues: 1=\'%falc%\', 2=\'%falc%\', 3=\'%falc%\', 4=\'%falc%\', 5=\'%falc%\',
6=\'%falc%\', 7=\'%falc%\'] at /usr/share/perl5/DBIx/ContextualFetch.pm line
52.^J^JStack:^J [/usr/share/perl5/DBIx/ContextualFetch.pm:52]^J
[/usr/share/perl5/DBIx/ContextualFetch.pm:32]^J
[/usr/share/perl5/Class/DBI.pm:1139]^J [/usr/share/perl5/Class/DBI.pm:1083]^J
[/usr/share/perl5/Class/DBI/AbstractSearch.pm:33]^J
[/usr/local/netdot/htdocs/management/asset_tasks.html:243]^J
[/usr/local/netdot/htdocs/management/autohandler:81]^J
[/usr/share/perl5/HTML/Mason/Request.pm:936]^J
[/usr/local/netdot/htdocs/masondata/obj/991023240/management/autohandler.obj:21]^J
[/usr/local/netdot/htdocs/autohandler:76]^J at
/usr/share/perl5/Class/DBI/AbstractSearch.pm line 33^J') called at
/usr/share/perl5/Carp.pm line 44
Carp::croak('Asset can\'t SELECT id, serial_number, product_id,
inventory_number, physaddr, reserved_for, maint_from, maint_until^JFROM
asset^JWHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR
reserved_for LIKE ? OR description LIKE ? OR info LIKE ? OR po_number LIKE ? OR
maint_contract LIKE ? ) )^J: DBD::Pg::st execute failed: ERROR: operator does
not exist: bigint ~~ unknown^JLINE 3: ...fo LIKE $5 OR po_number LIKE $6 OR
maint_contract LIKE $7 ) ...^J
^^JHINT: No operator matches the given name and argument type(s).
You might need to add explicit type casts. [for Statement "SELECT id,
serial_number, product_id, inventory_number, physaddr, reserved_for,
maint_from, maint_until^JFROM asset^JWHERE ( ( custom_serial LIKE ? OR
inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ? OR info
LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )^J" with ParamValues:
1=\'%falc%\', 2=\'%fal!
c%\', 3=\'%falc%\', 4=\'%falc%\', 5=\'%falc%\', 6=\'%falc%\', 7=\'%falc%\'] at
/usr/share/perl5/DBIx/ContextualFetch.pm line 52.^J^JStack:^J
[/usr/share/perl5/DBIx/ContextualFetch.pm:52]^J
[/usr/share/perl5/DBIx/ContextualFetch.pm:32]^J
[/usr/share/perl5/Class/DBI.pm:1139]^J [/usr/share/perl5/Class/DBI.pm:1083]^J
[/usr/share/perl5/Class/DBI/AbstractSearch.pm:33]^J
[/usr/local/netdot/htdocs/management/asset_tasks.html:243]^J
[/usr/local/netdot/htdocs/management/autohandler:81]^J
[/usr/share/perl5/HTML/Mason/Request.pm:936]^J
[/usr/local/netdot/htdocs/masondata/obj/991023240/management/autohandler.obj:21]^J
[/usr/local/netdot/htdocs/autohandler:76]^J') called at
/usr/share/perl5/Class/DBI.pm line 169
Class::DBI::_croak('Asset', 'Asset can\'t SELECT id, serial_number, product_id,
inventory_number, physaddr, reserved_for, maint_from, maint_until^JFROM
asset^JWHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR
reserved_for LIKE ? OR description LIKE ? OR info LIKE ? OR po_number LIKE ? OR
maint_contract LIKE ? ) )^J: DBD::Pg::st execute failed: ERROR: operator does
not exist: bigint ~~ unknown^JLINE 3: ...fo LIKE $5 OR po_number LIKE $6 OR
maint_contract LIKE $7 ) ...^J
^^JHINT: No operator matches the given name and argument type(s).
You might need to add explicit type casts. [for Statement "SELECT id,
serial_number, product_id, inventory_number, physaddr, reserved_for,
maint_from, maint_until^JFROM asset^JWHERE ( ( custom_serial LIKE ? OR
inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ? OR info
LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )^J" with ParamValues:
1=\'%f!
alc%\', 2=\'%falc%\', 3=\'%falc%\', 4=\'%falc%\', 5=\'%falc%\', 6=\'%falc%\',
7=\'%falc%\'] at /usr/share/perl5/DBIx/ContextualFetch.pm line 52.^J^JStack:^J
[/usr/share/perl5/DBIx/ContextualFetch.pm:52]^J
[/usr/share/perl5/DBIx/ContextualFetch.pm:32]^J
[/usr/share/perl5/Class/DBI.pm:1139]^J [/usr/share/perl5/Class/DBI.pm:1083]^J
[/usr/share/perl5/Class/DBI/AbstractSearch.pm:33]^J
[/usr/local/netdot/htdocs/management/asset_tasks.html:243]^J
[/usr/local/netdot/htdocs/management/autohandler:81]^J
[/usr/share/perl5/HTML/Mason/Request.pm:936]^J
[/usr/local/netdot/htdocs/masondata/obj/991023240/management/autohandler.obj:21]^J
[/usr/local/netdot/htdocs/autohandler:76]^J', 'err',
'HTML::Mason::Exception=HASH(0x7f8b68789cf8)') called at
/usr/share/perl5/Class/DBI.pm line 1143
Class::DBI::sth_to_objects('Asset',
'DBIx::ContextualFetch::st=HASH(0x7f8b68531e88)', 'ARRAY(0x7f8b658590b0)')
called at /usr/share/perl5/Class/DBI.pm line 1083
Class::DBI::retrieve_from_sql('Asset', '( ( custom_serial LIKE ? OR
inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ? OR info
LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )', '%falc%', '%falc%',
'%falc%', '%falc%', '%falc%', '%falc%', '%falc%') called at
/usr/share/perl5/Class/DBI/AbstractSearch.pm line 33
Class::DBI::AbstractSearch::search_where('Asset', 'ARRAY(0x7f8b684e4820)')
called at /usr/local/netdot/htdocs/management/asset_tasks.html line 243
HTML::Mason::Commands::__ANON__('search', 'falc', 'submit', 'Search',
'search_type', 'all', 'showheader', 1, 'page', 'ASSETS') called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f8b684d6ba0)',
'search', 'falc', 'submit', 'Search', 'search_type', 'all', 'showheader', 1,
'page', 'ASSETS') called at /usr/share/perl5/HTML/Mason/Request.pm line 1284
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, undef, 'search', 'falc', 'submit',
'Search', 'search_type', 'all', 'showheader', 1, 'page', 'ASSETS') called at
/usr/share/perl5/HTML/Mason/Request.pm line 943
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x7f8b68520770)',
'page', 'ASSETS') called at /usr/local/netdot/htdocs/management/autohandler
line 81
HTML::Mason::Commands::__ANON__('search', 'falc', 'submit', 'Search',
'search_type', 'all', 'showheader', 1) called at
/usr/share/perl5/HTML/Mason/Component.pm line 157
HTML::Mason::Component::run_dynamic_sub('HTML::Mason::Component::FileBased=HASH(0x7f8b680f4bd0)',
'main', 'search', 'falc', 'submit', 'Search', 'search_type', 'all',
'showheader', 1) called at /usr/share/perl5/HTML/Mason/Request.pm line 936
HTML::Mason::Request::call_dynamic('HTML::Mason::Request::ApacheHandler=HASH(0x7f8b68520770)',
'main', 'search', 'falc', 'submit', 'Search', 'search_type', 'all',
'showheader', 1) called at
/usr/local/netdot/htdocs/masondata/obj/991023240/management/autohandler.obj
line 21
HTML::Mason::Commands::__ANON__('search', 'falc', 'submit', 'Search',
'search_type', 'all', 'showheader', 1) called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f8b680f4bd0)',
'search', 'falc', 'submit', 'Search', 'search_type', 'all', 'showheader', 1)
called at /usr/share/perl5/HTML/Mason/Request.pm line 1284
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, undef, 'search', 'falc', 'submit',
'Search', 'search_type', 'all', 'showheader', 1) called at
/usr/share/perl5/HTML/Mason/Request.pm line 943
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x7f8b68520770)',
'showheader', 1) called at /usr/local/netdot/htdocs/autohandler line 76
HTML::Mason::Commands::__ANON__('search', 'falc', 'submit', 'Search',
'search_type', 'all') called at /usr/share/perl5/HTML/Mason/Component.pm line
135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f8b681127e8)',
'search', 'falc', 'submit', 'Search', 'search_type', 'all') called at
/usr/share/perl5/HTML/Mason/Request.pm line 1279
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, undef, 'search', 'falc', 'submit',
'Search', 'search_type', 'all') called at
/usr/share/perl5/HTML/Mason/Request.pm line 473
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 473
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 425
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7f8b68520770)')
called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7f8b68520770)')
called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7f8b680a95a0)',
'Apache2::RequestRec=SCALAR(0x7f8b683f0d10)') called at
/usr/local/netdot/lib/Netdot/Mason.pm line 59
Netdot::Mason::handler('Apache2::RequestRec=SCALAR(0x7f8b683f0d10)') called at
-e line 0
eval {...} at -e line 0
Thanks,
Joe
Joe Goldberg
Director, Hosted Services
FalconStor Software (NASDAQ: FALC)
2 Huntington Quadrangle
Melville, NY 11747
Tel.: 631.773.5816
Cell: 516.510.7383
Defining Data Protection, Again(tm)
Follow us:
[Description: Description: Description: Description:
Blogger]<http://www.falconstor.com/community/blogs>[Description: Description:
Description: Description: Twitter1-icon]<http://twitter.com/FalconStor>
[Description: Description: Description: Description: linkedin-icon]
<http://www.linkedin.com/groups?mostPopular=&gid=776377> [Description:
Description: Description: Description: Youtube-icon]
<http://www.youtube.com/user/FalconStor> [Description: Description:
Description: Description: Flickr-icon1]
<http://www.flickr.com/photos/falconstor/>
[Description: Description: Description: Description:]Please consider the
environment before printing this email.
This email and any attachment(s) is for the intended recipient only and may be
confidential. If you are not the intended recipient, please delete this e-mail
and advise the sender immediately. Unauthorized use or distribution is
prohibited.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20121108/de6c4ad6/attachment.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 1066 bytes
Desc: image001.gif
Url :
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20121108/de6c4ad6/attachment.gif
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 2324 bytes
Desc: image002.png
Url :
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20121108/de6c4ad6/attachment.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 1745 bytes
Desc: image003.png
Url :
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20121108/de6c4ad6/attachment-0001.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 2235 bytes
Desc: image004.png
Url :
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20121108/de6c4ad6/attachment-0002.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 2183 bytes
Desc: image005.png
Url :
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20121108/de6c4ad6/attachment-0003.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 1373 bytes
Desc: image006.png
Url :
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20121108/de6c4ad6/attachment-0004.png
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 48, Issue 4
*******************************************
