Error (GTP): Unable to create the object with ProgID of 'Production_73.GTP

[Radhika]

Hi

When i am running a GTP in CAC i am getting the below error:

Unable to create the object with ProgID of 'Production_73.GTPTransactionDocument' (request was for 'Production_%v.GTPTransactionDocument')~~~~ActiveX component can't create object)

I am using Cognos Planning 7.3 version.

Any suggestions on the above one are welcome.

Thanks
Radhika

[JaromirSeps]

Hi,
Im I'm not mistaken, you didn't paste the whole message which starts like
"Unable to process the toolbar click correctly." ...

The appstore in the database didn't cancel the status of running GTP. So you need to do this manually. I would recommend to make a backup of the affected datastore before you do this (although I never had any trouble and we are doing this without backup).

MSSQL:
Open Query Analyzer in SQL Server and authenticate against the Contributor Application Database.
Execute the below script.  This will reset the value for the GTP_Transaction OptionID to blank.
UPDATE adminoption set optionvalue = '' where OPTIONID = 'GTP_TRANSACTION'

Oracle: add the schema_name in front of <adminoption>

(the two '' are two single quotes!)

regards
Jaromir

[raaju]

Hi radhika:

This is Priya. I have been working on CognosBI since past three years. Recently I got trained on Cognos Planning as I am thinking to start focusing on Cognos Planning from now on.

I have a interview to attend which I may need your help. It would be really kind of you if you can response back to my personal mail id:

ppriya.g3@gmail.com

We will talk in private.

I look forward to hearing from you.
thanks,
Priya.

[Radhika]

Hi Priya,

You can reach me on cognos.planner@gmail.com/gtalk:cognos.planner@gmail.com


Thanks
Radhika

[Radhika]

Thank you, Jaromir


Regards
Radhika