For those who get this error message (I wasn't able to find solution on internet):
Type: 'E', Message: 'Make sure that there is an active version of DataStore object "QUERY"
Make sure your connection string is created for particular type of BW object.
I accidentally was trying to load OLAP Cube with DSO/ODS connection string .
Thanks! I was doing exactly the opposite...