SYMPTOM:
In Strategy Enterprise Manager 9.x, data loading fails with the following error message:
Login to project unsuccessful.
Object variable or With block variable not set
CAUSE:
The project which the Strategy Enterprise Manager console is trying to reach cannot be found in Strategy Intelligence Server.
ACTION:
Run the following SQL:
SELECT * FROM EM_PROPS
The result should return a list of monitored projects with Project IDs. Users can check the problematic project (in the error message). It is possible that the project with the same project name is not loaded on Strategy Intelligence Server or the project does not have statistics logging enabled.
Make sure the target project is loaded on Strategy Intelligence Server and statistics are enabled.
