Search 85,947 posts and 653 resources contributed by 43,565 members or post a topic.

Already Joined? Sign in
Importing IPs from ToolSet's IP Address Management

Page 1 of 2 (19 items) 1 2 Next > | RSS

rated by 0 users
Answered (Verified) This post has 2 verified answers | 18 Replies | 3 Followers | 1,811 Views


3 Posts
Points 9
sean.boston posted on Wed, Apr 29 2009 3:03 PM
rated by 0 users

Hello Thwack;

 

Has anyone been successful in importing IP addresses from Toolset's IP address Management app into IPAM?

 

Regards

Answered (Verified) Verified Answers


2,601 Posts
Points 11,172
Moderator
SolarWinds Employee
Answered (Verified) bshopp replied on Thu, Apr 30 2009 8:57 AM
rated by 0 users

Here you go

 

 

The parameter after STOP and START need to be enclosed within double quotes (and not the ones Word replaces on you with).

 

1.   Locate the Toolset IP Address Manager database on your Toolset server.

Note: The Toolset IP Address Manager database has an .ipdb extension.

2.   Copy the Toolset IP Address Manager database to an appropriate location on your Orion server.

3.   Open the Command Prompt on your Orion server.

Note: Typically, the command prompt may be opened by clicking Start > All Programs > Accessories > Command Prompt.

4.   Enter CD <volume>:\Program Files\SolarWinds\Orion\IPAM.

5.   Enter NET STOP "SolarWinds IPAM Information Service"

6.   Enter SolarWinds.IPAM.Init.exe -import <Full path to your Toolset IP Address Manager database>.

7.   Enter NET START "SolarWinds IPAM Information Service"

 

Brandon Shopp - Product Manager Orion NPM, Network Atlas and LANSurveyor

  • | Post Points: 23

331 Posts
Points 2,086
SolarWinds Employee
Answered (Verified) Peter.Cooper replied on Thu, May 7 2009 9:54 AM
rated by 0 users
Verified by Elisabeth Zakes

Just closing the loop on this issue.

We did investigate and constructed a private update for this issue. If your import throws an exception (fails with a verbose error), please contact our technical support for assistance. Thanks!

Peter Cooper, Principal Developer : Ottawa, Canada

  • | Post Points: 21

All Replies


2,318 Posts
Points 7,773
Moderator
SolarWinds Employee
Mark Wiggans replied on Wed, Apr 29 2009 3:16 PM
rated by 0 users

Yes, this is possible.

 

The steps can be found here.

 http://www.solarwinds.com/NetPerfMon/SolarWinds/OrionIPAMAGImportingIPAddressesSettings.htm

 

Mark Wiggans Information Development-

  • | Post Points: 3

3 Posts
Points 9
sean.boston replied on Thu, Apr 30 2009 8:07 AM
rated by 0 users

Hello Mark;

 

These instructions are only for importing from a Excel xls or csv file. That would mean exporting each of the IP addresses ranges. Isn't there a way to import the whole ipdb file into IPAM?

  • | Post Points: 1

28 Posts
Points 92
SolarWinds Certified Professional
tonyled replied on Thu, Apr 30 2009 8:20 AM
rated by 0 users

i too found no way to do this and have been entering all of mine manually

  • | Post Points: 5

2,601 Posts
Points 11,172
Moderator
SolarWinds Employee
bshopp replied on Thu, Apr 30 2009 8:53 AM
rated by 0 users

There is a command line utility you can  run to import subnets and IP's from Toolset, let me get the directions for you and re-post

Brandon Shopp - Product Manager Orion NPM, Network Atlas and LANSurveyor

  • | Post Points: 1

2,601 Posts
Points 11,172
Moderator
SolarWinds Employee
Answered (Verified) bshopp replied on Thu, Apr 30 2009 8:57 AM
rated by 0 users

Here you go

 

 

The parameter after STOP and START need to be enclosed within double quotes (and not the ones Word replaces on you with).

 

1.   Locate the Toolset IP Address Manager database on your Toolset server.

Note: The Toolset IP Address Manager database has an .ipdb extension.

2.   Copy the Toolset IP Address Manager database to an appropriate location on your Orion server.

3.   Open the Command Prompt on your Orion server.

Note: Typically, the command prompt may be opened by clicking Start > All Programs > Accessories > Command Prompt.

4.   Enter CD <volume>:\Program Files\SolarWinds\Orion\IPAM.

5.   Enter NET STOP "SolarWinds IPAM Information Service"

6.   Enter SolarWinds.IPAM.Init.exe -import <Full path to your Toolset IP Address Manager database>.

7.   Enter NET START "SolarWinds IPAM Information Service"

 

Brandon Shopp - Product Manager Orion NPM, Network Atlas and LANSurveyor

  • | Post Points: 23

335 Posts
Points 894
rgward replied on Thu, Apr 30 2009 6:30 PM
rated by 0 users

We have already populated IPAM with all our supernets and some subnets.  If we import our Toolset IPDB will IPAM insert each subnet under the corresponding supernet?  What happens if IPAM encounters a duplicate subnet on import?

(1) Orion v9.1 SP5 SLX running Web Site
(2) Orion v9.1 SP5 SLX polling engine
(1) Orion v9.1 SP5 SLX Hot-Standby
(1) MS SQL2000 EE
APM v2.5 ALX
VoIP Monitor v2 SP3
Wireless Network Monitor v8
IPAM v1.5 IPX

(1) Orion NPM v9.5.1 SLX running Web Site (Dev)
(1) APM 3.1 ALX (Dev)
(1) IPSLA 3.0 SLAX (Dev)
(1) NCM v5 DL500 (Dev)
(1) Lansurveyor v10 (Dev)

  • | Post Points: 3

331 Posts
Points 2,086
SolarWinds Employee
Peter.Cooper replied on Thu, Apr 30 2009 7:45 PM
rated by 0 users

rgward,

That's an excellent point you bring up. I'm glad you asked.

The import tool was meant to help initialize the install. It will seek out an existing subnet of the same address space and overwrite its contents. I wouldn't recommend you run it since all your subnets have been added... leading to a potential reversion of changes.

New subnets are added under "IP Networks"... the top level group.

Peter Cooper, Principal Developer : Ottawa, Canada


335 Posts
Points 894
rgward replied on Thu, Apr 30 2009 8:18 PM
rated by 0 users

Thanks Peter for your quick reply!   Okay, this will work for us, I think.  We're not doing any polling of subnet address spaces yet.  So, with the Toolset subnets imported at the top level, we should be able to drag and drop them into the proper supernet.

(1) Orion v9.1 SP5 SLX running Web Site
(2) Orion v9.1 SP5 SLX polling engine
(1) Orion v9.1 SP5 SLX Hot-Standby
(1) MS SQL2000 EE
APM v2.5 ALX
VoIP Monitor v2 SP3
Wireless Network Monitor v8
IPAM v1.5 IPX

(1) Orion NPM v9.5.1 SLX running Web Site (Dev)
(1) APM 3.1 ALX (Dev)
(1) IPSLA 3.0 SLAX (Dev)
(1) NCM v5 DL500 (Dev)
(1) Lansurveyor v10 (Dev)

  • | Post Points: 3

173 Posts
Points 4,641
BakerD replied on Fri, May 1 2009 9:39 AM
rated by 0 users

I am not sure if this step was suppose to be verbatim but didn't work for me:

 

5.   Enter NET STOP SolarWinds IPAM Information Service.

 

I used: net stop swipaminformationservice

After figuring that out, the import failed for me so I will be contacting support on it.

  • | Post Points: 3

2,601 Posts
Points 11,172
Moderator
SolarWinds Employee
bshopp replied on Fri, May 1 2009 9:53 AM
rated by 0 users

Can you post the error you are getting?

Brandon Shopp - Product Manager Orion NPM, Network Atlas and LANSurveyor

  • | Post Points: 3

173 Posts
Points 4,641
BakerD replied on Fri, May 1 2009 10:10 AM
rated by 0 users

bshopp:

Can you post the error you are getting?

 

Sure, it was:

Unhandled Exception: System.OverflowException: Failed to convert parameter value from a UInt64 to a Int64. ---> System.OverflowException: Value was either too large or too small for an Int64.

I just got off the phone with tech support and they had a hotfix for it and the import worked great afterwards.

 

 

 

 

  • | Post Points: 3

3 Posts
Points 9
sean.boston replied on Fri, May 1 2009 11:38 AM
rated by 0 users

Here is the error I'm getting.....

 

Can someone post the hotfix?



E:\Orion\IPAM>solarwinds.ipam.init.exe -import DiaglabsIPMan.ipdb

Unhandled Exception: System.OverflowException: Failed to convert parameter value
 from a UInt64 to a Int64. ---> System.OverflowException: Value was either too l
arge or too small for an Int64.
   at System.Convert.ToInt64(UInt64 value)
   at System.UInt64.System.IConvertible.ToInt64(IFormatProvider provider)
   at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvid
er provider)
   at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType dest
inationType)
   --- End of inner exception stack trace ---
   at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType dest
inationType)
   at System.Data.SqlClient.SqlParameter.GetCoercedValue()
   at System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommand
Proc)
   at System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser, SqlParam
eterCollection parameters)
   at System.Data.SqlClient.SqlCommand.BuildExecuteSql(CommandBehavior behavior,
 String commandText, SqlParameterCollection parameters, _SqlRPC& rpc)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBe
havior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehav
ior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult
 result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehav
ior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, S
tring method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at SolarWinds.IPAM.Storage.DAL.IPNodeDAL._ListOfNonExistentIpOrdinal(Int32 su
bnetId, String rangestring)
   at SolarWinds.IPAM.Storage.DAL.IPNodeDAL.EnsureOrdinals(Int32 subnetId, Strin
g rangestring)
   at SolarWinds.IPAM.Import.ImportHelper.FinalizeSubnetImport(SubnetInfo parent
)
   at SolarWinds.IPAM.Import.ImportHelper.ImportToolsetSubnetsDatabase(String fi
lepath, ImportMode mode, List`1 results)
   at IPAM.Init.Program.Import()
   at IPAM.Init.Program.Main(String[] args)

E:\Orion\IPAM>

  • | Post Points: 3

173 Posts
Points 4,641
BakerD replied on Fri, May 1 2009 1:35 PM
rated by 0 users

sean.boston:

Here is the error I'm getting.....

 

Can someone post the hotfix?


I was provided a secure authenticated link via email, so I think it would be best to contact support for the hotfix.  Also they can verify if it is right for your setup.  If they wanted it public, they would have provided it or maybe they will after further testing.

  • | Post Points: 3

331 Posts
Points 2,086
SolarWinds Employee
Answered (Verified) Peter.Cooper replied on Thu, May 7 2009 9:54 AM
rated by 0 users
Verified by Elisabeth Zakes

Just closing the loop on this issue.

We did investigate and constructed a private update for this issue. If your import throws an exception (fails with a verbose error), please contact our technical support for assistance. Thanks!

Peter Cooper, Principal Developer : Ottawa, Canada

  • | Post Points: 21
Page 1 of 2 (19 items) 1 2 Next > | RSS

© 2003 - 2010 SolarWinds, Inc. All Rights Reserved.

Who is SolarWinds?

SolarWinds is rewriting the rules for how companies manage their networks. Guided by a global community of network engineers, SolarWinds develops simple and powerful network management software and network monitoring software for networks of all sizes. SolarWinds also offers a network certification program to become a SolarWinds Certified Professional (SCP).

What is thwack?

thwack, SolarWinds online community site, was designed by network engineers, for network engineers. thwack is a vibrant, growing community of more than 30,000 IT pros who share a passion for technology.

Explore Resources, Answers, Templates, and Advice

Download Free Networking Tools

Learn More About SolarWinds Products