Author Topic: Find Report Dependencies problem  (Read 59 times)

Offline MichaelB

  • Full Member
  • ***
  • Join Date: Dec 2017
  • Posts: 13
  • Forum Citizenship: +0/-0
Find Report Dependencies problem
« on: 17 May 2019 11:25:02 am »
We recently upgraded to 11.1.1 and then 11.1.2 when it was just released. Prior to this upgrade, our Report Dependencies function used to work beautifully. Now, not so much.
1. If I select a Restricted Search, it times out at almost exactly 4 minutes and 30 seconds every time, with the error of
Quote
"CCL-BIT-0005 A socket reported a communication error.
CAM_Send=0xfffffff4 <errorDetail><errorCode>10053</errorCode><errorMessage>Could not send to the socket, errno: 0x2745(10053)</errorMessage></errorDetail>"
2. If I don't restrict the search, but only return 1 record at most, it spins and spins and eventually I have to kill the app.

The reason that this is a major issue for my team is that we are going through an upgrade to our core application that feeds into the data warehouse. Some of those table structures will be changing and we are trying to come up with a validation plan all the way through the end of reporting.

I've been really fortunate to start learning about the Content Store and have been pretty comfortable with querying for it, but I can't seem to find anything that I can query in the tables that will give me the information that I need about which reports are hitting specific areas of the model.

Does anyone have any ideas of a fix or potential workaround to be able to trace our tables in our foundation view through to which reports are affected? Thanks in advance!

Offline dougp

  • Statesman
  • ******
  • Join Date: Jul 2014
  • Posts: 372
  • Forum Citizenship: +19/-1
Re: Find Report Dependencies problem
« Reply #1 on: 17 May 2019 11:59:39 am »
Quote
We recently upgraded to 11.1.1 and then 11.1.2 when it was just released.
Thanks for being a beta tester.  I made the mistake of "upgrading" from 10.2.1 to 11.0.4.  My users hate me.  Now I'm on 11.0.13 and it has fewer bugs, but still has considerable problems.  I'm hoping I can wait to "upgrade" to 11.1.x until at least release 10.

Quote
learning about the Content Store
Take a look at CMOBJPROPS7.  It has the report specifications.  You may be able to parse that to determine which reports use which objects in the model.
Of course, the correct way to do this is to use C# or Java to write a program leveraging the Cognos SDK.  The SDK is very slow.  Don't hold your breath while this program is running.  Plan to run it overnight and pick up the results in the morning.

Offline MichaelB

  • Full Member
  • ***
  • Join Date: Dec 2017
  • Posts: 13
  • Forum Citizenship: +0/-0
Re: Find Report Dependencies problem
« Reply #2 on: 17 May 2019 01:04:40 pm »
Yeah, as is usually my MO, once I post a question I usually think of a solution. Basically, I can pull up FM and trace the tables up into the Presentation Layer and search CMOBJPROPS7.SPEC for that string.

It might be a daunting task, but better than having no information at all. Thanks for taking the time to respond!

 


       
Twittear