Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello - Am running into an error code 1000195 when installing Qlik Replicate on a windows machine before the installation completes. It looks like the installation expects a local drive to be the shared storage location for the data folder while am trying to use a shared storage file share location. Can anyone please confirm if the data folder needs to be on a local drive on the server or can it be any file share location? I tried to create a mapped drive to the file share location on the windows machine to use during installation but it doesn't recognize the mapped drive, it says its invalid. Any help is greatly appreciated.
Thank you
Deepti Mathew
it could be that you did not follow the cluster install guide.
please try to uninstall , clean and install fresh using the cluster install guide
Is there a log file created with a more explicit error message description beyond the error message code ? Please share.
The Replicate documentation seems to be behind the times in its "Disk requirements" using decades old lingo like 'rpm' and does not mention SSD or similar. The whole section is labeled "Recommended hardware configuration". One could interpret that as 'not required' and there is no explicit mention of network attached storage (NAS).
The Replicate DATA disk access can be the defining factor in Replicate performance. This is notably the case when long running transactions which may have to be staged in workfiles; when the target is slow requiring further staging; when multiple GB transaction sorting is needed; when (multiple GB) CSV files are to be produced.
As such Replicate does not want to get a bad name caused by poor storage choices and may well require a 'real' disk or a device not distinguishable from that during installation. I suppose it should document that clearly and give a clear non-compliance message if/when it does an active test, but here we are.
I would strongly recommend NOT bothering with an NFS style data drive for the above reasons.
If you want to try that anyway then I'd suggest to go ahead and install using a 'local' disk first, even if that were to be the 'c:' drive for now. Once you have a successful installation you can start 'playing' with it. For that follow the documented instructions under "Changing the Data Directory location on Windows". Using this approach you will at least know what worked, what broke, and you'll have (hopefully) clear information in a 'repsrv.log' if it fails. ( Hmmm, actually, there is probably no regular repsrv.log or at best it is in the bin directory, as it normally would be located on that data drive :-). Check the windows event logs ?!
hth,
Hein.
Hey Hein - Thank you for your response. I should have mentioned earlier am doing the Qlik Replicate installation in a cluster environment, that's the reason am using a common file share location. I don't see any errors in the event logs but I do see an error in the data folder log files. Unable to connect to GlobalRepo.sqlite, could be the accounts access am using for installation? Have you come across this error before? I will check with my windows admins to make sure it's not access related. I'll go ahead and try installing using the local server drive first and then follow Changing the Data Directory location on windows instructions. Appreciate your suggestion.
Thank You
Deepti
Ah! Cluster. That indeed requires a shared storage area visible to all executing nodes.
Mak sure to carefully read Appendix D - "Setting up Qlik Replicate in a cluster
environment"
>> Unable to connect to GlobalRepo.sqlite
yes, that's bound to be a security issue assuming the cluster services for the share are activated.
Be sure to download the DB Browser for SQLite (https://sqlitebrowser.org/) and test access with 'run as' or logged in as the username used for Replicate.
Or just run 'Logged on as' - 'local system'. That's just easier in general, and really not any less safe as no customer code is running. Admittedly it may not be usable if you need the Replicate logged on credentials to connect to a SQLserver DB
Hein.
it could be that you did not follow the cluster install guide.
please try to uninstall , clean and install fresh using the cluster install guide
thanks Hein, am going to try the SQLite download and redo the install.
Deepti
Morning, when setting up a cluster with nodes on different sites what's the best way to set up shared storage location? Is it best to have both the nodes (server 1 and 2) on the same site? Any suggestions?
Thank You
Deepti