Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: sascha on 03 Sep 2008 03:13:22 AM

Title: GTP problem with 'missing stream error'
Post by: sascha on 03 Sep 2008 03:13:22 AM
Hi folks

have you ever experienced a GTP post-prodution-error 'missing stream error' like this:
(http://sascha.pytalhost.net/screenshots/screenshot1.jpg)?

The error log does not give any valuable information to me:

The environment looks like this:

When putting the same app onto my virtual Win XP VmWare with SQL 2005 and Planning 8.4 FCS there is no problem at all.

Thanks for your help,
Sascha
Title: Re: GTP problem with 'missing stream error'
Post by: SanderH on 03 Sep 2008 04:12:40 AM
I've never seen such an error message.

What you might try is adding and removing an Access Table. This forces a reconcile.
After this, try to GTP.
Title: Re: GTP problem with 'missing stream error'
Post by: sascha on 03 Sep 2008 04:17:07 AM
Hi Sander

thanks for your fast reply.
The problem already occurs on the very first GTP directly after initially setting the app.

I did in between try on another small and very quick app if the environment has got a problem but the GTP ran through successfully on this one.

Right now I am trying to strip down the problem app to only a few dlist/elist items without any access tables. Will post updates information once available.

Regards,
Sascha
Title: Re: GTP problem with 'missing stream error'
Post by: sascha on 03 Sep 2008 05:04:52 AM
Hmm this really confuses me... ??? I now rebuilt the app the third time, but this time step by step (start with few item dlists, added full dimensionality, added full elist, added imported AT...) and now - in it's final step - it's (still) working.

A little bit disappointing not to find a "real" reason for this. I also found something on the web outside this forum but there's also no explaination available  :-\

So thanks for sharing ideas...
Title: Re: GTP problem with 'missing stream error'
Post by: SanderH on 03 Sep 2008 06:37:36 AM
Unfortunately I've had the same experience ... some errors just can't be logically explained or being reproduced.
Title: Re: GTP problem with 'missing stream error'
Post by: SomeClown on 03 Sep 2008 07:08:14 AM
I've seen similar errors, with no attributable cause, but typically comes down to dropped network connections or lost database connections, etc.  Usually means that it can't find the database server (lost the connection).  It's sporadic in that you can't usually find an error message anywhere, and it doesn't show up as server unavailable. 
Title: Re: GTP problem with 'missing stream error'
Post by: sascha on 03 Sep 2008 07:25:19 AM
A lost network connection could not be the problem as the SQL Server sits in the same machine (which is in fact not the best scenario I can imagine).
Title: Re: GTP problem with 'missing stream error'
Post by: Susie Ward on 25 Sep 2008 09:45:39 AM
I am having finding similar errors in the plannignerrorlog to Sascha:

TransportClient.cpp   invoke   185   epcTransport::default::TransportClient.cpp::invoke::185   -2147467259   Unexpected: missing HRESULT parameter

TransportClient.cpp   invoke   213   epcTransport::default::TransportClient.cpp::invoke::185   -2147467259   Unexpected: missing HRESULT parameter

RemoteDispatcher.cpp   invokeRemoteMethod   56   epcTransport::default::TransportClient.cpp::invoke::185   -2147467259   Unexpected: missing HRESULT parameter

RemoteDispatcher.cpp   invokeRemoteMethod   74   epcTransport::default::TransportClient.cpp::invoke::185   -2147467259   Unexpected: missing HRESULT parameter

OSProxy.cpp   invoke   105   epcTransport::default::TransportClient.cpp::invoke::185   -2147467259   Process exception

   PopulateModel   100   epcTransport::default::TransportClient.cpp::invoke::185   -2147352567   Unexpected: missing HRESULT parameter~~Unable to get user view for Planning Administration Domain ~~~~Unexpected: missing HRESULT parameter

   GetApplicationURI   110   epcTransport::default::TransportClient.cpp::invoke::185   -2147352567   Unexpected: missing HRESULT parameter~~Unable to get user view for Planning Administration Domain ~~~~Unexpected: missing HRESULT parameter



....... they are not as a result of a GTP but instead seem to be caused by an A2C link. If the A2C link appears to have run successfull (via a macro) and you go into the admin console there is no reconcile running. This makes me think the errors could be linked. If however, the A2C link does not run then a series of errors which occur and the above mentioned planningerrorlog messages appear. Please see attached additional error message.

This problem is really difficult to reproduce and since typing this blog it has since resolved itself. I am convinced it is due to a drop in connectivity. Can anyone help?  :-\

Susie



Title: Re: GTP problem with 'missing stream error'
Post by: sascha on 25 Sep 2008 11:29:08 AM
Hi Susie
depending on the complexity of your app did you try to rebuild it?
Title: Re: GTP problem with 'missing stream error'
Post by: Susie Ward on 26 Sep 2008 07:47:16 AM
No...

Did you eventually manage to solve your problem or is it still an issue?

Susie
Title: Re: GTP problem with 'missing stream error'
Post by: sascha on 26 Sep 2008 09:23:51 AM
Quote from: Sascha on 03 Sep 2008 05:04:52 AM
I now rebuilt the app the third time, but this time step by step (start with few item dlists, added full dimensionality, added full elist, added imported AT...) and now - in it's final step - it's (still) working.

As mentioned I solved the problem with rebuilding the app. It was really strange because I rebuilt it two times. The first time I did all development steps at once (as I usually do) but this led to the same error. When I did the app step by step (to find the place where the error occurs) the error did not appear again. That's why I can't precise why the error occured. Maybe Cognos knows... maybe not...  ;)
Text only | Text with Images