Hello Everyone,
I am at a complete loss and can not figure out an issue with some users being able to access reports in my Cognos v11 instance.
Here is the issue I am having, I don't even know how to ask this properly:
Being an administrator I am able to access reports just fine, which makes perfect sense. I can setup new users that can access reports perfectly. But, I have some users that have lost the ability to run reports, they can see them, but when they try to run them they get the following error:
Failure XQE-GEN-018 Query Service internal error has occurred, please see log for details.
They can see all the reports in the package, it's just loading up the package and running the various reports in the package.
Now, I have tried several things, removing the user, restarting the servers, giving the users administrator rights. I have even tried to recreate the issue by setting up new users exactly like them and have had no luck.
Has anyone ever encountered anything like this? Am I missing something?
Thanks,
Grady
Quote from: froodyo on 14 Oct 2019 10:07:23 AM
Hello Everyone,
I am at a complete loss and can not figure out an issue with some users being able to access reports in my Cognos v11 instance.
Here is the issue I am having, I don't even know how to ask this properly:
Being an administrator I am able to access reports just fine, which makes perfect sense. I can setup new users that can access reports perfectly. But, I have some users that have lost the ability to run reports, they can see them, but when they try to run them they get the following error:
Failure XQE-GEN-018 Query Service internal error has occurred, please see log for details.
They can see all the reports in the package, it's just loading up the package and running the various reports in the package.
Now, I have tried several things, removing the user, restarting the servers, giving the users administrator rights. I have even tried to recreate the issue by setting up new users exactly like them and have had no luck.
Has anyone ever encountered anything like this? Am I missing something?
Thanks,
Grady
Hi,
What do the XQE logs show when these errors occur? If you can find more details in there, it might give you a steer towards what might be causing the issue?
Cheers!
MF.
Looks like a metadata issue:
XQE-MD-0007 Unable to establish a metadata connection to data source
We are using TM1 cubes - so I guess it could be on that side of the house.
I will start googling, but how do you track that down where it affects certain users and not others when they have the same exact access?
Grady
do the users with "the same exact access" belong to multiple groups?
This was one of our thoughts, and they were, so we tried to recreate the issue with no luck. We then removed them from every group in Cognos, and TM1, no dice.
I'm telling you we are really over looking something, or its life's greatest mystery lol
Grady
Quote from: froodyo on 14 Oct 2019 11:02:17 AM
This was one of our thoughts, and they were, so we tried to recreate the issue with no luck. We then removed them from every group in Cognos, and TM1, no dice.
I'm telling you we are really over looking something, or its life's greatest mystery lol
Grady
Hi,
Looks like XQE-MD-0007 errors can be caused by a lack of temp space.
https://www.ibm.com/support/pages/xqe-md-0007-errors-running-report
Are you also seeing
java.io.IOEXCEPTION: No space left on device messages in the XQE logs?
MF.
Quote from: MFGF on 14 Oct 2019 11:19:23 AM
Hi,
Looks like XQE-MD-0007 errors can be caused by a lack of temp space.
https://www.ibm.com/support/pages/xqe-md-0007-errors-running-report
Are you also seeing java.io.IOEXCEPTION: No space left on device messages in the XQE logs?
MF.
Sadly that is not in the error log at all. This is why it is baffling, everything I find does not seem to fit in with the issue.
Grady
Quote from: froodyo on 14 Oct 2019 11:21:46 AM
Sadly that is not in the error log at all. This is why it is baffling, everything I find does not seem to fit in with the issue.
Grady
What security model is being used by TM1? Is it using CAM security from Cognos Analytics? If so, then the user's login from CA is being used to authenticate in TM1, and it's possible some users might not have security rights to be able to access the cube or cubes the report requires? This is set up from the TM1 side, though, so it's worth asking your TM1 experts if you don't have access to check this yourself.
Cheers!
MF.