COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Administration and Security => Topic started by: froodyo on 14 Oct 2019 10:07:23 am

Title: Baffled - Some Users Work, Some Do Not
Post by: 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
Title: Re: Baffled - Some Users Work, Some Do Not
Post by: MFGF on 14 Oct 2019 10:25:39 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.
Title: Re: Baffled - Some Users Work, Some Do Not
Post by: froodyo on 14 Oct 2019 10:52:34 am
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
Title: Re: Baffled - Some Users Work, Some Do Not
Post by: Francis aka khayman on 14 Oct 2019 10:58:41 am
do the users with "the same exact access" belong to multiple groups?
Title: Re: Baffled - Some Users Work, Some Do Not
Post by: 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
Title: Re: Baffled - Some Users Work, Some Do Not
Post by: MFGF on 14 Oct 2019 11:19:23 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.
Title: Re: Baffled - Some Users Work, Some Do Not
Post by: froodyo on 14 Oct 2019 11:21:46 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
Title: Re: Baffled - Some Users Work, Some Do Not
Post by: MFGF on 14 Oct 2019 12:19:02 pm
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.