Home Knowledge Articles IBM Cognos 8 Planning GTP error Activex component can't create object or Method
Follow us on Twitter


Countries

50.1%United States United States
7.6%India India
7%United Kingdom United Kingdom
5.1%Australia Australia
4.8%Canada Canada

Visitors

Today: 32
Yesterday: 573
This Week: 32
Last Week: 3348
This Month: 9417
Last Month: 15365
Total: 383504


GTP error Activex component can't create object or Method Print E-mail
(1 vote, average 5.00 out of 5)

Error on Go To Production: Activex component can't create object or Method '~' of object '~' failed
Error when performing a Go To Production (GTP).
Unable to process the toolbar click correctly.
Unable to create the object with ProgID of Production_%v.GTPTransactionDocument Activex component can't create object
Or
Method '~' of object '~' failed

A Flag in the contributor application database stops the GTP.  There are invalid values in GTP_Transaction OptionID field which must be removed.

There are 2 options:

1. Clear the flag in the database with a script, to reset the GTP_Transaction OptionID value to blank.
2. Remove the flag manually from the planning store

Steps option 1:
1. Backup the application's schema or database first!.
2. Open Query Analyzer and authenticate against the Contributor Application Database.
3. Execute the below script to reset the value in the admin option table. UPDATE adminoption set optionvalue = '' WHERE optionid = 'GTP_TRANSACTION'
4. When script is complete, excute the GTP or Admin Link again.

Or

To remove the flag manually, go into the adminoption table of the application database in question and remove the entry from the optionvalue column for the GTP_transaction row.
Additional Information:

www.cogknowhow.com

Comments

Please login to post comments or replies.
 
 

Login

For more content en features!



CogKnowHow Newsletter

Season's Greetings


Receive HTML?

Polls

How many users are working on your Cognos environment?