topic Re: How can we migrate inputs from DB Connect 3.7 to 3.11? in All Apps and Add-ons

How can we migrate inputs from DB Connect 3.7 to 3.11?

joshiro — Fri, 20 Jan 2023 13:53:33 GMT

Splunk Enterprise 9.0.1.
We upgrade DB Connect from 3.7.0. to 3.11.1 and we started to notice that some inputs were not working.
Also on _internal we found an event that lists inputs that require migration.

INFO c.s.d.s.m.s.DbInputToModularInputInstanceMigrator - DB Inputs requiring migration: [...]

The actual documentation doesnt say anything about this migration.
https://docs.splunk.com/Documentation/DBX/3.11.1/DeployDBX/MigratefromDBConnectv1

Is there any other documentation on how to migrate to the latest version?

UPDATE:

We found that the cron expression validation changed between versions:
'1/10 * * * *' was a valid expression in 3.7, now its no longer valid. We have to do '1-59/10 * * * *'.

Also we have to disable and then enable the input for it to start working again, changing the cron is not enough.

Re: How can we migrate inputs from DB Connect 3.7 to 3.11?

scelikok — Fri, 20 Jan 2023 02:38:07 GMT

Hi @joshiro,

You can try below migration script.

https://docs.splunk.com/Documentation/DBX/3.9.0/DeployDBX/MigratefromDBConnectv1#Upgrade_and_migrate_instructions

Re: How can we migrate inputs from DB Connect 3.7 to 3.11?

joshiro — Fri, 20 Jan 2023 13:15:23 GMT

We already saw that documentation, and we didnt try to migrate that way because it doesnt match our context. We are already on 3.7 and that document is for an upgrade from 2.x to 3.
And we were using DB Connect 3 for a long time without problems, this just happened recently when updating to the latest version, from 3.7.0.

Might check what the upgrade scripts do, and see if they help us in any way.

Thanks.

Re: How can we migrate inputs from DB Connect 3.7 to 3.11?

scelikok — Fri, 20 Jan 2023 13:38:44 GMT

If not too many inputs seem to be migrated, you can copy the query and setting to create new inputs. It maybe a faster solution.

Re: How can we migrate inputs from DB Connect 3.7 to 3.11?

joshiro — Fri, 20 Jan 2023 13:52:46 GMT

We got lots of inputs, we can try to remake them, but its going to take time. This is the last thing we are trying.

We found that the cron expression validation changed between versions:
'1/10 * * * *' was a valid expression in 3.7, now its no longer valid. We have to do '1-59/10 * * * *'.

Also we have to disable and then enable the input for it to start working again, changing the cron is not enough.

Re: How can we migrate inputs from DB Connect 3.7 to 3.11?

scelikok — Fri, 20 Jan 2023 14:08:57 GMT

Very nice to hear you solved and thank you for the information.