We migrated from COG8 to COG10 and we used the MS excel plugin for both.
Unfortunately the plugin works fine with the COG8 but it fails for large amount of data in COG10.
We even tried increasing the governor limit to 35 Mb but failed again. As per recommendation, we should not exceed the limit to more than 50 Mb.
Can someone help us in this.
Quote from: Gary on 04 Mar 2015 11:06:39 AM
We migrated from COG8 to COG10 and we used the MS excel plugin for both.
Unfortunately the plugin works fine with the COG8 but it fails for large amount of data in COG10.
We even tried increasing the governor limit to 35 Mb but failed again. As per recommendation, we should not exceed the limit to more than 50 Mb.
Can someone help us in this.
Can you tell us what "it fails" means - in detail. Is there an error?
When you refer to the MS Excel plugin, are you referring to Cognos for Microsoft Office? What version? What version of Excel? 32 or 64 bit?
What is a "large amount of data"? Are you trying to use Cognos as an ETL tool to dump data into Excel?
MF.
Error is :
Looking at the logs, the error message is as following:
"
10.1.82.16:9300 40732 2014-11-13 14:29:12.317 +1 http-9300-593 CCS 5001 1 Audit.rds.CCS soap reportDataService Failure <messages><message><messageString>RDS-ERR-1021 The IBM Cognos report "/content/folder[@name='BICM']/folder[@name='Core']/folder[@name='Restricted Reports']/folder[@name='MS&C']/report[@name='BICM_R200_Project financial status']" could not be run because it contains unanswered prompts. Please provide the prompt answers, and run the report again.</messageString></message> <trace>null</trace>
10.1.82.16:9300 40732 2014-11-13 14:31:54.934 +1 http-9300-604 CCS 5001 1 Audit.rds.CCS soap reportDataService Failure <messages><message><messageString>RDS-ERR-1023 The report "CAMID("Edir:u:uid=t0115893,ou=internal")/session[@name='ea0ab8017e229e0601f978d5d0f76229555e0371ef7ba2a5edaee53d5149f26f']/output[@name='BICM_R200_Project financial status']" could not be run because it exceeds the Report Data Service data size limit set by the administrator.</messageString></message> <trace>com.cognos.ccs.exceptions.CCSGeneralException: GOVERNOR_ERROR at com.cognos.ccs.service.Cognos8Connector.checkDataSize(Unknown Source) at com.cognos.ccs.service.Cognos8Connector.checkDataSize(Unknown Source) at com.cognos.ccs.service.Cognos8Connector.getResultFromCM(Unknown Source)...
We are using Cognos Plugin for MS Office version 64 bit.
Users are using the Cognos Plugin in excel for reporting.
Quote from: Gary on 05 Mar 2015 08:02:05 AM
Error is :
Looking at the logs, the error message is as following:
"
10.1.82.16:9300 40732 2014-11-13 14:29:12.317 +1 http-9300-593 CCS 5001 1 Audit.rds.CCS soap reportDataService Failure <messages><message><messageString>RDS-ERR-1021 The IBM Cognos report "/content/folder[@name='BICM']/folder[@name='Core']/folder[@name='Restricted Reports']/folder[@name='MS&C']/report[@name='BICM_R200_Project financial status']" could not be run because it contains unanswered prompts. Please provide the prompt answers, and run the report again.</messageString></message> <trace>null</trace>
10.1.82.16:9300 40732 2014-11-13 14:31:54.934 +1 http-9300-604 CCS 5001 1 Audit.rds.CCS soap reportDataService Failure <messages><message><messageString>RDS-ERR-1023 The report "CAMID("Edir:u:uid=t0115893,ou=internal")/session[@name='ea0ab8017e229e0601f978d5d0f76229555e0371ef7ba2a5edaee53d5149f26f']/output[@name='BICM_R200_Project financial status']" could not be run because it exceeds the Report Data Service data size limit set by the administrator.</messageString></message> <trace>com.cognos.ccs.exceptions.CCSGeneralException: GOVERNOR_ERROR at com.cognos.ccs.service.Cognos8Connector.checkDataSize(Unknown Source) at com.cognos.ccs.service.Cognos8Connector.checkDataSize(Unknown Source) at com.cognos.ccs.service.Cognos8Connector.getResultFromCM(Unknown Source)...
We are using Cognos Plugin for MS Office version 64 bit.
Users are using the Cognos Plugin in excel for reporting.
The message seems to indicate that the reports in question have prompts that are not getting fulfilled. Have you entered default prompt values in the Cognos for MS Office import definition?
What version of Cognos 10 are you using? What version of Excel are you using?
MF.