cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

Can we move only the IPAM to a separate database ?

Hi,

We have IPAM running as a module within the NPM.

IPAM is failing with SQL errors. Is it possible to re-configure the IPAM to access a different brand new database ?

Currently, the IPAM info tables are within the NPM database.

Best Regards,

A

0 Kudos
20 Replies
Level 8

Sure, I am doing a Storage firmware upgrade this weekend. I will try out

1. The timeout settings change

2. Reinstall steps

I surely update the outcome.

Regards,

A

0 Kudos
Level 8

Hi,

We had to escalate it. It turned out to be an issue with the database, where the old data was not getting purged.

Support managed to provide us a stored Procedure which is doing that now.

All is working now. Thanks a lot for your inputs

0 Kudos
Level 17

Glad to help out where I could and thank you for sharing what was done to get this corrected.

0 Kudos
Level 8

what ever we find the root cause, thanks lot to you for spending your valuable time on this.

I really appreciate it.

Regards

A

0 Kudos
Level 8

ERROR SolarWinds.IPAM.ScanningEngine.JobProcessor.JobProcessorBase`1 (null) - Error occurred when processing DHCP results - serverGroupId: 2497, serverNodeId: 4022

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

The statement has been terminated.

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

   at SolarWinds.IPAM.Storage.DAL.ConflictDAL.PurgeConflictData()

   at SolarWinds.IPAM.Storage.DAL.ConflictDAL.StoreDhcpConflicts(Int32 scopeId, List`1 conflicts, Boolean updateConflictData)

   at SolarWinds.IPAM.ScanMerge.DhcpDiscoveryMerger.UpdateScope(Int32 serverId, Int32 scopeId, Int32 groupId, String scopeAddress, Boolean includingGroupTable, DhcpServerType serverType)

   at SolarWinds.IPAM.ScanMerge.DhcpDiscoveryMerger.UpdateScopesState(Int32 serverId, Int32 groupId, Boolean addAutomaticallyNewScopes)

   at SolarWinds.IPAM.ScanningEngine.JobProcessor.JobProcessorOneTimeDhcpServerSync.SubmitResults(UIJob job)

ClientConnectionId:e4634d91-5859-4b86-90d4-0bcf39d4f0ad

This is what I see from the Logs.

Regards,

A

0 Kudos
Level 17

All I can recommend is what I did previously, reinstall then request escalation if there's still a failure.

0 Kudos
Level 8

it scans for almost 5 mins

First it stops at 33%, then it moves 67% immediately and then a long wait, then the error.

Regards,

A

0 Kudos
Level 8

Sorry,

Pops up this

Command Failed
An unexpected error has occurred when processing DHCP scopes results for server '1703'

Regards,

A

0 Kudos
Level 17

How long after you perform the scan?  I'd be more apt to thinking it's something wrong with the install.  You may want to do the uninstall/reinstall to see if that resolves it.  All you information will still be in the database.  If things still fail, I'd recommend requesting escalation from support.

Level 8

there are 150 server/scopes on the IPAM, 61805 IPs.

When Select a DHCP server and select Edit and then test, it is successful.

However, when I select the Same server and SCAN. fails with the error,

2014-10-21 05:22:35,390 [5] ERROR SolarWinds.IPAM.ScanningEngine.JobProcessor.JobProcessorBase`1 (null) - An unexpected error has occurred when processing scan results for subnetid '3409'

0 Kudos
Level 8

there is nothing really pointing to the latency.

from the IPM business layer log, this was seen,

2014-10-21 05:22:35,390 [5] ERROR SolarWinds.IPAM.ScanningEngine.JobProcessor.JobProcessorBase`1 (null) - An unexpected error has occurred when processing scan results for subnetid '3409'

System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

The statement has been terminated.

There only NPM 11.0.1  ,NCM 7.3.2  and IPAM 4.2.

Regards,

A

0 Kudos
Level 17

OK that would point to a connection timeout.  I'm assuming the database and application servers are in the same location.  An old schole trick that used to work on the SolarWinds server was finding the SWNetPerfMon.db file, opening it in notepad and changing the software's connection and command timeouts from 20 and 90 to 600.  From there, stop the services, save the change, and restart the services.  This will at least make sure the application is on the same timeout as SQL is.  This might help.  How many scopes are on that server?  Are your subnet scans working ok?

0 Kudos
Level 8

However the IPAM was working and some intermittent issues used to get reported, that used to vanish. A month ago it stopped working completely and then it was upgraded to fix. Since then it stopped working altogether.

Regards,

A

0 Kudos
Level 8

The IPAM 4.2  is failing to after 67%, with the error,

Command Failed
An unexpected error has occurred when processing DHCP scopes results for server '1703'

Solarwinds support is pointing it Storage latency. the Database is on SSD and so far no issues we have seen

So, I thought it will be possible to move to another Database.

Any other ideas I can have ?

Regards,

0 Kudos
Level 8

Also, it is after an upgrade, I am clueless what to do with it.

Regards,

A

0 Kudos
Level 17

So why are they pointing to Storage latency?  Did they give you a reason, or just that it has to be storage latency?  How many scopes are on that server?  What other modules do you have installed other than IPAM?

0 Kudos
Level 8

Also, if I install it on a different server, can I make it the link available from the NPM admin page ?

Thanks and Regards,

0 Kudos
Level 17

No on both.  If you uinstall and reinstall it on the same server, it's going to simply add as a module.  If you try on a separate server, it will be it's own app separate from the SolarWinds website.  There's no way to integrate it without having it installed as a module using the same database.

0 Kudos
Level 8

Hi,

Can't I uninstall it and install it on the same server and point it to a new database. I don't mind redoing the whole IPAM setup again.

Regards,

Athreya

0 Kudos
Level 17

You'd have to break out IPAM I believe onto it's own server.  There wouldn't be a way to configure it to another SQL server while still installed on the NPM server. 

0 Kudos