If you have the FULL DSK (not just the PIN) you could hand key it in on the hub using my app: [APP] SmartStart Manager for Z-Wave (Long Range support)
Also, for the cloud mode issue. Are you certain your phone and hub are on the exact same LAN / Subnet? No guest network or IoT device isolation setup? One of the most basic ways to check if the IP if you mobile and the IP of your hub, they should both be on the same subnet like 192.168.1.XXX
On the home screen of the app, tap the Hub Name, it should show the Hub IP there (the one the app gets from the cloud server). Then go to the app 3 lines menu (hamburger), then app settings, that shows your phones IP.